query ("SELECT version, max(CAST(name AS UNSIGNED)) AS max, count(name) AS count FROM `active` WHERE user_id='' GROUP BY version")) {
foreach ($db as $row) {
$max[$row['version']] = $row['max'];
}
}
*/
if ($db->query ("SELECT '3.0.1+' AS version, max(CAST(name AS UNSIGNED)) AS max, count(name) AS count FROM `active` WHERE user_id='' AND version>='3' AND version<'3.0.2'")) {
foreach ($db as $row) {
$max[$row['version']] = $row['max'];
$maxCols = max($maxCols, $row['max']);
}
}
if ($db->query ("SELECT '3.0.3+' AS version, max(CAST(name AS UNSIGNED)) AS max, count(name) AS count FROM `active` WHERE user_id='' AND version>='3.0.2' AND version<'4'")) {
foreach ($db as $row) {
$max[$row['version']] = $row['max'];
$maxCols = max($maxCols, $row['max']);
}
}
/*
if ($db->query ("SELECT version, DATE_FORMAT(date_sub(time, interval 1 DAY), '%d.%m.%Y') AS date, name AS count FROM `active` WHERE user_id='' ORDER BY time ASC")) {
foreach ($db as $row) {
$info['active'][$row['version']] = $row['count'];
$info['flow'][$row['version']] .= "";
$maxRows = max($maxRows, $db->rows);
}
}
*/
if ($db->query ("SELECT '3.0.1+' AS version, DATE_FORMAT(date_sub(time, interval 1 DAY), '%d.%m.%Y') AS date, SUM(name) AS count FROM `active` WHERE user_id='' AND version>='3' AND version<'3.0.2' GROUP BY date ORDER BY time ASC")) {
$info['flow'][$db[0]['version']] = "";
foreach ($db as $row) {
$info['active'][$row['version']] = $row['count'];
$info['flow'][$row['version']] .= "";
}
$info['flow'][$row['version']] = "" . $info['flow'][$row['version']] . "
" . $info['flow'][$row['version']] . "
setPlaceholder("text", $info); ?>
html ("text")?>