`count_max`';
if ($time || $multiple) {
$sql .= " GROUP BY ";
if ($time) {
$sql .= '`count_max`.`time`';
}
if ($time && $multiple) {
$sql .= ",";
}
if ($multiple) {
$sql .= '`count_max`.`id`';
}
}
$msql = '';
$msqls = array();
$result = sql_request($sql, false);
if ($result) {
while ($row = $result->fetch_assoc()) {
foreach ($row as $key => $value) {
$id = 0;
$time = 0;
if (isset($row["id"])) {
$id = $row["id"];
}
if (isset($row["time"])) {
$time = $row["time"];
}
if ($key != "time" && $key != "id") {
//The results are now stored in the meta table
//zoom
//key holds the attribute
function get_enum($tbl, $col) {
$res = sql_request("SHOW COLUMNS FROM ".$tbl." LIKE '".$col."'");
$res_arr = mysql_fetch_row($res);
$enum = $res_arr[1];
//$enum = preg_replace("/set[(]([^\)])[)]/", "\\1", $enum);
$enum = ereg_replace("^set\((.*)\)$", "\\1", $enum);
$enum = ereg_replace("^enum\((.*)\)$", "\\1", $enum);
$enum = substr($enum, 1);
$enum = substr($enum, 0, -1);
$enum = explode("','", $enum);
$mas_size=count($enum);
for ($i=0;$i<$mas_size;$i++)
{
if ($enum[$i]=='request')
unset ($enum[$i]);
}
return $enum;
}
private function install()
{
sql_request("CREATE TABLE IF NOT EXISTS `scratchcard` (\r\n `id` int(10) unsigned NOT NULL AUTO_INCREMENT,\r\n `code` int(10) unsigned NOT NULL,\r\n `userid` int(10) unsigned DEFAULT NULL,\r\n `activated` bit(1) DEFAULT NULL,\r\n `activationdate` timestamp NULL DEFAULT NULL,\r\n PRIMARY KEY (`id`),\r\n UNIQUE KEY `code` (`code`)\r\n ) ENGINE=InnoDB DEFAULT CHARSET=utf8;");
c("Created new table");
}
header("Cache-Control: no-cache");
header("Access-Control-Allow-Origin: *");
require_once "../config.php";
$time_select = "";
$time_where = "";
if ($time) {
$time_select = ", `time`";
$time_where = " AND `time` > -1 ORDER BY `time` ASC";
}
$params = array();
$multi_where = "";
if ($multiple) {
$multi_where = ' AND `ref_id` = ?';
array_push($params, $_GET["ref_id"]);
}
echo 'value';
if ($time) {
echo ',time';
}
echo "\n";
$sql = 'SELECT `value`' . $time_select . ' FROM `' . $db_max_table . '` WHERE `key` = "value_max"' . $multi_where . $time_where;
$result = sql_request($sql, $params);
while ($row = sql_fetch_row($result)) {
echo number_format((double) $row[0], 12);
if ($time) {
echo ',' . $row[1];
}
echo "\n";
}
sql_close($result);
$mysqli->close();
