3 require_once('config.php');
6 $link = mysql_connect ($DB_HOST, $DB_USER, $DB_PASS);
9 echo 'Could not connect to database: ' . mysql_error();
13 Header('X-Status: Mysql Connected successfully');
15 mysql_select_db($DB_DB, $link) or die("Unable to select database: ". mysql_error());
19 if ($_REQUEST['db_create'] == $DB_CREATE) {
20 echo 'creating db<br />';
22 $result = mysql_query('DROP TABLE fallout_stats')
23 or die("Unable to drop table: ". mysql_error());
25 $result = mysql_query('
26 CREATE TABLE IF NOT EXISTS fallout_stats (
27 id integer not null AUTO_INCREMENT,
42 or die("Unable to create table ". mysql_error());
45 //$res=mysql_query("select count(*) from fallout_stats");
48 function dbstats_access(&$U)
50 $params = array('login','klice','penize','jidlo','karma');
51 foreach ($params as $p) {
53 $U["${p}_mysql"] = mysql_real_escape_string($U["${p}"]);
56 $U["${p}_mysql"] = $U["${p}"];
59 $sql = 'INSERT INTO fallout_stats (cas, ip, ua, invalid ';
60 foreach ($params as $p) {
63 $sql .= ") \nVALUES (now(), '${_SERVER['REMOTE_ADDR']}', '${_SERVER['HTTP_USER_AGENT']}', 'submit' ";
64 foreach ($params as $p) {
66 $sql .= $U["${p}_mysql"] ;
73 $result = mysql_query($sql)
74 or die("Unable to execute insert: ". mysql_error());
76 $id = mysql_insert_id();
79 $id = rand(1, 10000000);
85 function dbstats_update(&$U, $cert, $invalid)
88 $invalid = empty($invalid) ?
'null' : "'$invalid'";
89 $cert = empty($cert) ?
'null' : "'$cert'";
90 $skore = empty($U['skore']) ?
'null' : "'${U['skore']}'";
91 $perky = empty($U['perky']) ?
'null' : "'" . implode(' ', $U['perky']) . "'" ;
92 $sql = " UPDATE fallout_stats ";
94 $sql .= " invalid = $invalid, ";
95 $sql .= " cert = $cert, ";
96 $sql .= " skore = $skore, ";
97 $sql .= " perky = $perky " ;
99 $sql .= " WHERE id = $id ";
103 $result = mysql_query($sql)
104 or die("Unable to execute update: ". mysql_error());
109 function sql_log($sql)
111 $SQL_FILE= TMPDIR
. "/sql.txt";
113 $fh = fopen($SQL_FILE, 'a');
114 fwrite($fh, "$sql;\n");