1. 1
2. 2
3. 3
4. 4
5. 5
6. 6
7. 7
8. 8
9. 9
10. 10
11. 11
12. 12
13. 13
14. 14
15. 15
16. 16
17. 17
18. 18
19. 19
20. 20
21. 21
22. 22
23. 23
24. 24
25. 25
26. 26
27. 27
28. 28
29. 29
30. 30
31. 31
32. 32
33. 33
34. 34
35. 35
36. 36
37. 37
38. 38
39. 39
40. 40
41. 41
42. 42
43. 43
44. 44
45. 45
46. 46
47. 47
48. 48
49. 49
50. 50
51. 51
52. 52
53. 53
54. 54
55. 55
56. 56
57. 57
58. 58
59. 59
60. 60
61. 61
62. 62
63. 63
64. 64
65. 65
66. 66
67. 67
68. 68
69. 69
70. 70
71. 71
72. 72
73. 73
74. 74
75. 75
76. 76
77. 77
78. 78
79. 79
80. 80
81. 81
82. 82
83. 83
84. 84
85. 85
86. 86
87. 87
88. 88
89. 89
90. 90
91. 91
92. 92
93. 93
94. 94
95. 95
96. 96
97. 97
98. 98
99. 99
100. 100

<?php

class db {

var $MySQL_time_taken = 0;

function __construct ($mysql_host,$mysql_user,$mysql_pass,$mysql_db,$mysql_charset="cp1251") {

//	global $mysql_host,$mysql_user,$mysql_pass,$mysql_db;

	if(!($this->link = @mysqli_connect($mysql_host,$mysql_user,$mysql_pass)))
		{
		echo "<font color=\"red\">Error:</font> connect to host: $mysql_host";
		//exit();
		}
	if(!mysqli_select_db($this->link,$mysql_db))
		{
		echo "<font color=\"red\">Error:</font> select database $mysql_db";
		exit();
		}
	
 	mysqli_query($this->link,"SET NAMES $mysql_charset");
	return $this->link;
	}

function sql_query ($query,$debug=false) {
	$time_befor = $this->get_real_time();
	$result = mysqli_query($this->link, $query);
		if (!$result)
			{
			$this->error_msg = mysqli_error($result);
			return print($this->error_msg);
			}
	
	$this->MySQL_time_taken += $this->get_real_time() - $time_before;
	//print("<font color=\"blue\">" . $time . "</font><br>");
	return $result;
	}

function sql_fetch_assoc ($query) {
		$res=sql_query($query);
		while ($rows = mysqli_fetch_assoc($res))
			{
			$row[]=$rows;
			}
		mysqli_free_result($res);
		return $row;
	}

function sql_fetch_array ($query,$numarr=MYSQLI_BOTH) {
		$res = $this->sql_query($query);
		
		while ($row = mysqli_fetch_array($res,$numarr))
			{
			$array[] = $row;
			}
		
		mysqli_free_result($res);
		return $array;
	}

function get_id_passkey ($passkey) {
		$query = "SELECT id FROM users WHERE passkey='" . $passkey . "'";
		$res=$this->sql_query($query);
		$row = mysqli_fetch_array($res);
		mysqli_free_result($res);
		return $row;
	}

function get_real_time()
        {
                list($seconds, $microSeconds) = explode(' ', microtime());
                return ((float)$seconds + (float)$microSeconds);
        }

function torrent_search ($string,$owner="",$sort="added",$cat="all",$checked="2")
	{
	$limit = 10;
	$stmt = mysqli_prepare($this->link, "SELECT id,name,owner,added,cheched FROM torrents WHERE name '%?%' AND checked='?' AND owner='?'SORT BY ? LIMIT ?");
	var_dump($stmt);
	//mysqli_bind_param('sissi', $string,$checked,$owner,$sort,$limit);
	mysqli_bind_param(mysqli_stmt_init($this->link),'sissi', $string,$checked,$owner,$sort,$limit);
	mysqli_stmt_execute($stmt) or die("Ошибка:  Неудачный запрос");
	$stmt = mysqli_stmt_bind_result($id, $name, $owner, $added, $checked);
		while ($stmt->fetch()) { 
        		echo "|" . $id . " || " . $name . " || " . $owner . " || " . $added . " || " . $checked . "|<br>";
		}
	mysqli_stmt_close($stmt);
	}

function catlist() 
	{
	$query = "SELECT id, name FROM categories ORDER BY sort ASC";
	$ret = $this->sql_fetch_array($query);
	$cats_list = "";
	foreach ($ret as $cats_list_array) 
		{
		$cats_list .= "<option name=\"" . $cats_list_array["id"] . "\">" . $cats_list_array["name"] . "</option>";
		}
	return $cats_list;