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 dbstats_read($limit = 15)
 110 {
 111     if (HAVE_MYSQL) {
 112         $sql = "SELECT *, (LENGTH(perky) - LENGTH(REPLACE(perky, ' ', '')) + 1) AS perky_pocet FROM fallout_stats ";
 113         $sql .= " WHERE (invalid = '') OR (invalid IS NULL) ";
 114         $sql .= " ORDER BY skore DESC";
 115         $sql .= " LIMIT $limit";
 116
 117         $result = mysql_query($sql)
 118             or die("Unable to execute update: ". mysql_error());
 119
 120         $r = array();
 121         while ($row = mysql_fetch_assoc($result)) {
 122             $r[] = $row;
 123         }
 124         return $r;
 125     }
 126     else {
 127         return array();
 128     }
 129
 130 }
 131
 132 function dbstats_avg($limit = 15)
 133 {
 134     if (HAVE_MYSQL) {
 135         $sql = "SELECT AVG(perky_pocet) AS pp, AVG(penize) AS p, AVG(jidlo) AS j, AVG(karma) AS k, AVG(skore) AS s FROM (";
 136
 137         $sql .= " SELECT *, (LENGTH(perky) - LENGTH(REPLACE(perky, ' ', '')) + 1) AS perky_pocet FROM fallout_stats ";
 138         $sql .= " WHERE (invalid = '') OR (invalid IS NULL) ";
 139         $sql .= " ORDER BY skore DESC";
 140         $sql .= " LIMIT $limit";
 141         $sql .= ") AS topskore";
 142
 143         $result = mysql_query($sql)
 144             or die("Unable to execute update: ". mysql_error());
 145
 146         return mysql_fetch_assoc($result);
 147     }
 148     else {
 149         return array();
 150     }
 151
 152 }
 153
 154 function sql_log($sql)
 155 {
 156  $SQL_FILE= TMPDIR . "/sql.txt";
 157
 158  $fh = fopen($SQL_FILE, 'a');
 159  fwrite($fh, "$sql;\n");
 160  fclose($fh);
 161 }