www-apps/gc-fallout/dev/stats.php

   1 <?php
   2
   3 require_once('config.php');
   4
   5 if (HAVE_MYSQL) {
   6   $link = mysql_connect ($DB_HOST, $DB_USER, $DB_PASS);
   7
   8   if (!$link) {
   9     echo 'Could not connect to database: ' . mysql_error();
  10     die();
  11   }
  12
  13   Header('X-Status: Mysql Connected successfully');
  14
  15   mysql_select_db($DB_DB, $link) or die("Unable to select database: ". mysql_error());
  16
  17
  18
  19   if ($_REQUEST['db_create'] == $DB_CREATE) {
  20     echo 'creating db<br />';
  21
  22    $result = mysql_query('DROP TABLE  fallout_stats')
  23         or die("Unable to drop table: ". mysql_error());
  24
  25    $result = mysql_query('
  26         CREATE TABLE IF NOT EXISTS fallout_stats (
  27         id      integer not null AUTO_INCREMENT,
  28         cas     datetime,
  29         invalid varchar(200),
  30         login   varchar(100),
  31         klice   varchar(300),
  32         penize  integer,
  33         jidlo   integer,
  34         karma   integer,
  35         perky   varchar(300),
  36         skore   integer,
  37         ip      varchar(20),
  38         ua      varchar(300),
  39         cert    varchar(500),
  40         PRIMARY KEY (id)
  41         )')
  42         or die("Unable to create table ". mysql_error());
  43   }
  44
  45   //$res=mysql_query("select count(*) from fallout_stats");
  46 }
  47
  48 function dbstats_access(&$U)
  49 {
  50     $params = array('login','klice','penize','jidlo','karma');
  51     foreach ($params as $p) {
  52         if (HAVE_MYSQL) {
  53             $U["${p}_mysql"] = mysql_real_escape_string($U["${p}"]);
  54         }
  55         else {
  56             $U["${p}_mysql"] = $U["${p}"];
  57         }
  58     }
  59     $sql = 'INSERT INTO fallout_stats (cas, ip, ua, invalid ';
  60     foreach ($params as $p) {
  61         $sql .= ", $p";
  62     }
  63     $sql .= ") \nVALUES (now(), '${_SERVER['REMOTE_ADDR']}', '${_SERVER['HTTP_USER_AGENT']}', 'submit' ";
  64     foreach ($params as $p) {
  65         $sql .= ", '";
  66         $sql .= $U["${p}_mysql"] ;
  67         $sql .= "'";
  68     }
  69     $sql .= ")";
  70
  71     sql_log($sql);
  72     if (HAVE_MYSQL) {
  73       $result = mysql_query($sql)
  74         or die("Unable to execute insert: ". mysql_error());
  75
  76       $id = mysql_insert_id();
  77     }
  78     else {
  79       $id = rand(1, 10000000);
  80     }
  81     $U['id'] = $id;
  82     return $id;
  83 }
  84
  85 function dbstats_update(&$U, $cert, $invalid)
  86 {
  87     $id = $U['id'];
  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 ";
  93     $sql .= " SET ";
  94     $sql .= " invalid = $invalid, ";
  95     $sql .= " cert = $cert, ";
  96     $sql .= " skore = $skore, ";
  97     $sql .= " perky = $perky " ;
  98
  99     $sql .= " WHERE id = $id ";
 100
 101     sql_log($sql);
 102     if (HAVE_MYSQL) {
 103       $result = mysql_query($sql)
 104         or die("Unable to execute update: ". mysql_error());
 105     }
 106
 107 }
 108
 109 function sql_log($sql)
 110 {
 111  $SQL_FILE= TMPDIR . "/sql.txt";
 112
 113  $fh = fopen($SQL_FILE, 'a');
 114  fwrite($fh, "$sql;\n");
 115  fclose($fh);
 116 }