How to I use this info? Help!

[anti-human]

How do I use this info or where do I put it, what file do I edit? Help please.

This is the same error as this thread ;

http://www.vbulletin.org/forum/showthread.php?t=119719

The broken line is this one ;

$getnewestmember=$db->query_first("SELECT userid, username FROM " . TABLE_PREFIX . "user WHERE " . TABLE_PREFIX . "userid=$numbersmembers[max]"); 

The table name is missing from the WHERE section after the table prefix.

i.e. TABLE_PREFIX . "userid should be TABLE_PREFIX . "user.userid

However, table prefix should not be used in WHERE clauses anyway, instead you should us an AS after the initial table selection, like this ;

:

$getnewestmember=$db->query_first("SELECT userid, username FROM " . TABLE_PREFIX . "user AS user WHERE user.userid=$numbersmembers[max]"); 

Finally, since only one table is actually used in this select, the table references can be dropped completely as no ambiguity is possible.

$getnewestmember=$db->query_first("SELECT userid, username FROM " . TABLE_PREFIX . "user WHERE userid=$numbersmembers[max]"); 

anti-human Reviewed by anti-human on 8th Dec 2009. How to I use this info? Help! How do I use this info or where do I put it, what file do I edit? Help please. This is the same error as this thread ; http://www.vbulletin.org/forum/showthread.php?t=119719 The broken line is this one ; Rating: 5

[Affix]

the AS clause is needed as it is how vBulletin handles queries.

[anti-human]

the AS clause is needed as it is how vBulletin handles queries.

Okay but what file do i edit? where do i add it?