// Load it from database
$result = SQL_QUERY_ESC("SELECT `stats_entry`,`stats_value` FROM `{?_MYSQL_PREFIX?}_stats_%s` ORDER BY `stats_entry` ASC",
- array(date('Ymd', time())), __FUNCTION__, __LINE__);
+ array(generateDateTime(time(), '6')), __FUNCTION__, __LINE__);
// Read all rows
while ($row = SQL_FETCHARRAY($result)) {
// Ask for it
$result = SQL_QUERY_ESC("SHOW TABLES LIKE '{?_MYSQL_PREFIX?}_stats_%s'",
- array(date('Ymd', time())), __FUNCTION__, __LINE__);
+ array(generateDateTime(time(), '6')), __FUNCTION__, __LINE__);
// Do we have a row?
return SQL_NUMROWS($result);
`stats_value` BIGINT(20) NOT NULL DEFAULT 0,
PRIMARY KEY (`stats_entry`)
) TYPE=HEAP COMMENT='Temporary statistics table'",
- array(date('Ymd', time())), __FUNCTION__, __LINE__);
+ array(generateDateTime(time(), '6')), __FUNCTION__, __LINE__);
}
// Write all entries to the table
// Empty the table first
SQL_QUERY_ESC("TRUNCATE `{?_MYSQL_PREFIX?}_stats_%s`",
- array(date('Ymd', time())), __FUNCTION__, __LINE__);
+ array(generateDateTime(time(), '6')), __FUNCTION__, __LINE__);
// Begin the SQL command
$sql = sprintf("REPLACE INTO `{?_MYSQL_PREFIX?}_stats_%s` (`stats_entry`,`stats_value`) VALUES ",
- date('Ymd', time()));
+ generateDateTime(time(), '6'));
// Add all entries to the final query
foreach ($GLOBALS['stats'] as $entry => $value) {