[2root4u]

Today at 11:55 AM Lethal said this in Post #15
I get this error when i try to few the memberlist:

Database error in vBulletin 2.3.0:

Invalid SQL: SELECT *,5+0 as 5
FROM user,userfield
WHERE 1=1 AND
user.userid = userfield.userid
AND usergroupid NOT IN (1,3,4)
ORDER BY username ASC
LIMIT 0,30
mysql error: You have an error in your SQL syntax near '5
FROM user,userfield
WHERE ' at line 1

mysql error number: 1064


And in the postbit no matter what amount of donation I put in, it always shows up as *Diamond Donator*


Something is wrong with this part of the code:

PHP Code:

$users=$DB_site->query("SELECT *,$donationfield+0 as $donationfield
                          FROM user,userfield
                          WHERE $condition AND
                                user.userid = userfield.userid
                                ".iif($memberAllGood, " AND usergroupid NOT IN (1,3,4) ", "")."
                          ORDER BY $orderby $direction
                          LIMIT ".($limitlower-1).",$perpage"); 


I moved stuff around but couldn't get it to work.

I am running 2.3.0

Little help plz

In $donationfield, specify it as "field5" and not just "5". That should fix it.