function DbGetTop($limit) { global $min_votes; //gemiddelde van ALLE movies bijelkaar $total_avg = db_QueryFetchRow("\n\t SELECT \n\t\tAVG(vote_value) as avg\n\t FROM votes\n\t"); // movies met hoogstge bayesian ratings $tops = db_QueryFetch("\n\t SELECT\n\t\tmovies.*,\n\t\t(( ({$min_votes} * {$total_avg['avg']}) + COUNT(vote_value) * AVG(vote_value) ) / ({$min_votes} + COUNT(vote_value))) as avg\n\t FROM votes,movies\n\t WHERE movies.movie_id=votes.movie_id\n\t GROUP by movie_id\n\t ORDER by avg DESC\n\t LIMIT {$limit}\n\t"); // rearrange to this form: // $ret[movie_name]=array($thumbs); foreach ($tops as $top) { $ret[$top[movie_name]] = GetThumbs($top[movie_name]); } return $ret; }
function theme_GetStrikes($user) { return db_QueryFetch("SELECT id,node,reason,`timestamp` FROM " . CMW_TABLE_USER_STRIKE . " \n\t\tWHERE user=?", $user); }
function themeIdea_GetDetail($event_id, $user_id = 0, $threshold = null, $query_suffix = ";") { if ($user_id) { return db_QueryFetch("SELECT id,theme,parent,user,score," . DB_FIELD_DATE('timestamp') . "\n\t\t\tFROM " . SH_TABLE_PREFIX . SH_TABLE_THEME_IDEA . " \n\t\t\tWHERE node=? AND user=?" . $query_suffix, $event_id, $user_id); } else { if (isset($threshold)) { return db_QueryFetch("SELECT id,theme,parent,user,score," . DB_FIELD_DATE('timestamp') . "\n\t\t\t\tFROM " . SH_TABLE_PREFIX . SH_TABLE_THEME_IDEA . " \n\t\t\t\tWHERE node=? AND score>=?" . $query_suffix, $event_id, $threshold); } else { return db_QueryFetch("SELECT id,theme,parent,user,score," . DB_FIELD_DATE('timestamp') . "\n\t\t\t\tFROM " . SH_TABLE_PREFIX . SH_TABLE_THEME_IDEA . " \n\t\t\t\tWHERE node=?" . $query_suffix, $event_id); } } }
function db_QueryFetchFirst($query, ...$args) { $ret = db_QueryFetch($query, ...$args); if (isset($ret[0])) { return $ret[0]; } return null; }
function db_QueryFetchFirst($query, ...$args) { $ret = db_QueryFetch($query, ...$args); // Calling non-internal function, so ... if (isset($ret[0])) { return $ret[0]; } return null; }
function access_GetIP($ip) { return db_QueryFetch("SELECT id,user," . (defined('CMW_USING_MARIADB') ? "INET6_NTOA(ip)" : "INET_NTOA(ip)") . " AS ip,first_timestamp,last_timestamp,total FROM " . CMW_TABLE_USER_ACCESS . " \n\t\tWHERE ip=" . (defined('CMW_USING_MARIADB') ? "INET6_ATON(?)" : "INET_ATON(?)"), $ip); }
function user_GetByNode($node, $query_suffix = ";") { $ret = db_QueryFetch("SELECT id,node,mail," . DB_FIELD_DATE('created') . ",hash,HEX(secret) AS secret,auth_key," . DB_FIELD_DATE('last_auth') . "\n\t\tFROM " . SH_TABLE_PREFIX . SH_TABLE_USER . " \n\t\tWHERE node=?" . $query_suffix, $node); return db_ParseRows($ret, _SH_USER_ROW_MAP); }
function theme_GetHistory() { $ret = cache_Fetch(_THEME_CACHE_KEY . "THEME_HISTORY"); if ($ret === null) { $ret = db_QueryFetch("SELECT node,shorthand,name,theme FROM " . CMW_TABLE_THEME_HISTORY); if (is_array($ret)) { cache_Store(_THEME_CACHE_KEY . "THEME_HISTORY", $ret, _THEME_CACHE_TTL); } else { return null; } } return $ret; }