Boofo
05-28-2010, 10:12 PM
I am trying to update an old hack and this is the query that always worked in vb 3, but they don't use a single search table anymore in vb 4. There are four different search-type tables now. Can anyone please give me a clue as to what the vb 4 version of this query would be?
$lastsearches = $db->query_read("
SELECT search.*
, user.username
FROM " . TABLE_PREFIX . "search AS search
LEFT JOIN " . TABLE_PREFIX . "user AS user USING (userid)
WHERE search.query != ''
AND orderedids != ''
AND personal <> 1
ORDER BY search.searchid DESC
LIMIT 0, 15
");
$lastsearches = $db->query_read("
SELECT search.*
, user.username
FROM " . TABLE_PREFIX . "search AS search
LEFT JOIN " . TABLE_PREFIX . "user AS user USING (userid)
WHERE search.query != ''
AND orderedids != ''
AND personal <> 1
ORDER BY search.searchid DESC
LIMIT 0, 15
");