function legacy_GetUserWithInfo($id) { db_Connect(); return db_DoFetchFirst("SELECT id," . MYSQL_ISO_FORMAT('timestamp') . ",hash,bonus_votes,num_events,gravatar\n\t\tFROM " . CMW_TABLE_LEGACY_USER . " WHERE id=? LIMIT 1;", $id); }
function theme_GetIdeaHourlyStats() { $ret = cache_Fetch(_THEME_CACHE_KEY . "IDEA_HOURLYSTATS"); if ($ret === null) { $result = db_DoFetch("SELECT value,COUNT(id) AS count," . MYSQL_ISO_FORMAT('timestamp') . ",HOUR(timestamp) as hour,DAYOFYEAR(timestamp) as day FROM " . CMW_TABLE_THEME_IDEA_VOTE . "\n\t\t\t\tGROUP BY day,hour,value\n\t\t\t"); $ret = []; foreach ($result as $item) { $idx = $item['day'] * 24 + $item['hour']; $ret[$idx]['timestamp'] = $item['timestamp']; $ret[$idx]['day'] = $item['day']; $ret[$idx]['hour'] = $item['hour']; $ret[$idx]['count'][$item['value']] = $item['count']; if (isset($ret[$idx]['total'])) { $ret[$idx]['total'] += $item['count']; } else { $ret[$idx]['total'] = $item['count']; } } $ret = array_values($ret); cache_Store(_THEME_CACHE_KEY . "IDEA_HOURLYSTATS", $ret, _THEME_CACHE_TTL); } return $ret; }