1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:
40:
41:
42:
43:
44:
45:
46:
47:
48:
49:
50:
51:
52:
53:
54:
55:
56:
57:
58:
59:
60:
61:
62:
63:
64:
65:
66:
67:
68:
69:
70:
71:
72:
73:
74:
75:
76:
77:
78:
79:
80:
81:
82:
83:
84:
85:
86:
87:
88:
89:
90:
91:
92:
93:
94:
95:
96:
97:
98:
99:
100:
101:
102:
103:
104:
105:
106:
107:
108:
109:
110:
111:
112:
113:
114:
115:
116:
117:
118:
119:
120:
121:
122:
123:
124:
125:
126:
127:
128:
129:
130:
131:
132:
133:
134:
135:
136:
137:
138:
139:
140:
141:
142:
143:
144:
145:
146:
147:
148:
149:
150:
151:
152:
153:
154:
155:
156:
157:
158:
159:
|
<?php
// 21072004
//do some cleanup here to make sure magic_quotes_gpc is ON, and magic_quotes_runtime is OFF, and error reporting is all but notice.
error_reporting (E_ALL ^ E_NOTICE);
if (!get_magic_quotes_gpc()){
set_magic_quotes($_GET);
set_magic_quotes($_POST);
set_magic_quotes($_SESSION);
set_magic_quotes($_COOKIE);
set_magic_quotes($HTTP_GET_VARS);
set_magic_quotes($HTTP_POST_VARS);
set_magic_quotes($HTTP_COOKIE_VARS);
ini_set("magic_quotes_gpc",1);
}
set_magic_quotes_runtime(0);
function set_magic_quotes(&$vars) {
//eval("\$vars_val =& \$GLOBALS[$vars]$suffix;");
if (is_array($vars)) {
reset($vars);
while (list($key,$val) = each($vars))
set_magic_quotes($vars[$key]);
}else{
$vars = addslashes($vars);
//eval("\$GLOBALS$suffix = \$vars_val;");
}
}
define('DBTYPE',"mysql");
$dbqueriesthishit=0;
$dbtimethishit = 0;
function db_query($sql){
global $session,$dbqueriesthishit,$dbtimethishit;
$dbqueriesthishit++;
$dbtimethishit -= getmicrotime();
$fname = DBTYPE."_query";
$r = $fname($sql) or die(($session[user][superuser]>=3 || 1?"<pre>".HTMLEntities($sql)."</pre>":"").db_error(LINK));
$dbtimethishit += getmicrotime();
//$x = strpos($sql,"WHERE");
//if ($x!==false) {
// $where = substr($sql,$x+6);
// $x = strpos($where,"ORDER BY");
// if ($x!==false) $where = substr($where,0,$x);
// $x = strpos($where,"LIMIT");
// if ($x!==false) $where = substr($where,0,$x);
// $where = preg_replace("/'[^']*'/","",$where);
// $where = preg_replace('/"[^"]*"/',"",$where);
// $where = preg_replace("/[^a-zA-Z ]/","",$where);
// mysql_query("INSERT DELAYED INTO queryanalysis VALUES (0,\"".addslashes($where)."\",0)");
//}
return $r;
}
/*function db_query($sql) {
global $dbqueriesthishit,$dbtimethishit;
$dbqueriesthishit++;
$dbtimethishit -= microtime(true);
$r = mysql_query($sql, LINK);
if($r === false) {
$backtrace = debug_backtrace();
echo "<div style=\"text-align: left; background-color: white; color: black;\"><pre>Es ist ein MySQL-Fehler aufgetreten: ".db_error()."<br />
SQL: $sql<br />
Backtrace:<br />";
foreach($backtrace as $hook) {
echo "File $hook[file] on line $hook[line] in function $hook[class]$hook[type]$hook[function](".
substr(implode(',', $hook['args']), 0, 10)."..."
.")<br />";
}
echo "</pre></div>";
}
$dbtimethishit += microtime(true);
#rawoutput("<p>Query: $sql</p>)";
return $r;
}*/
function db_insert_id($link=false) {
global $dbtimethishit;
$dbtimethishit -= getmicrotime();
$fname = DBTYPE."_insert_id";
if ($link===false) {
$r = $fname();
}else{
$r = $fname($link);
}
$dbtimethishit += getmicrotime();
return $r;
}
function db_error($link){
$fname = DBTYPE."_error";
$r = $fname($link);
return $r;
}
function db_fetch_assoc($result){
global $dbtimethishit;
$dbtimethishit -= getmicrotime();
$fname = DBTYPE."_fetch_assoc";
$r = $fname($result);
$dbtimethishit += getmicrotime();
return $r;
}
function db_num_rows($result){
global $dbtimethishit;
$dbtimethishit -= getmicrotime();
$fname = DBTYPE."_num_rows";
$r = $fname($result);
$dbtimethishit += getmicrotime();
return $r;
}
function db_affected_rows($link=false){
global $dbtimethishit;
$dbtimethishit -= getmicrotime();
$fname = DBTYPE."_affected_rows";
if ($link===false) {
$r = $fname();
}else{
$r = $fname($link);
}
$dbtimethishit += getmicrotime();
return $r;
}
function db_pconnect($host,$user,$pass){
global $dbtimethishit;
$dbtimethishit -= getmicrotime();
$fname = DBTYPE."_connect";
$r = $fname($host,$user,$pass);
$dbtimethishit += getmicrotime();
return $r;
}
function db_select_db($dbname){
global $dbtimethishit;
$dbtimethishit -= getmicrotime();
$fname = DBTYPE."_select_db";
$r = $fname($dbname);
$dbtimethishit += getmicrotime();
return $r;
}
function db_free_result($result){
global $dbtimethishit;
$dbtimethishit -= getmicrotime();
$fname = DBTYPE."_free_result";
$r = $fname($result);
$dbtimethishit += getmicrotime();
return $r;
}
?>
|