/** * Load a cached resultset by id. * * @param vB_Current_User $user * @param int $searchid The id of the search the results are for * @return vB_Search_Results */ public static function create_from_searchid($user, $searchid) { global $vbulletin; $db = $vbulletin->db; $sql = "\r\n\t\t\tSELECT *\r\n\t\t\tFROM " . TABLE_PREFIX . "searchlog\r\n\t\t\tWHERE userid = " . intval($user->get_field('userid')) . " AND\r\n\t\t\t\tsearchlogid = " . intval($searchid) . " AND\r\n\t\t\t\tcompleted = 1"; $row = $db->query_first($sql); return self::create_from_record($user, $row); }
/** * Load a cached resultset by id. * * @param vB_Current_User $user * @param int $searchid The id of the search the results are for * @return vB_Search_Results */ public static function create_from_searchid($user, $searchid) { global $vbulletin; $db = $vbulletin->db; $sql = "\n\t\t\tSELECT *\n\t\t\tFROM " . TABLE_PREFIX . "searchlog\n\t\t\tWHERE userid = " . intval($user->get_field('userid')) . " AND\n\t\t\t\tsearchlogid = " . intval($searchid) . " AND\n\t\t\t\tcompleted = 1"; // Prob best to leave this reading from master. The entry may only // just have been created, and not replicated to the slave yet. $row = $db->query_first($sql); return self::create_from_record($user, $row); }