/**
* 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);
}
