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 user_GetByMail($mail, $query_suffix = ";") { $ret = db_QueryFetchFirst("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 mail=?\n\t\tLIMIT 1" . $query_suffix, $mail); return db_ParseRow($ret, _SH_USER_ROW_MAP); }