`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();