[Mijae]

Database error in vBulletin 2.2.6:

Invalid SQL: SELECT field5 FROM userfield WHERE userid=Array
mysql error: Unknown column 'Array' in 'where clause'

mysql error number: 1054

Date: Wednesday 04th of December 2002 04:57:07 PM
Script: http://www.invoid.net/forum/forum/itemshop.php
Referer: http://www.invoid.net/forum/itemshop.php?action=donate

PHP Code:

if($action==donate && isset($user)) {
    if ($bbuserinfo['userid']==0) {
    eval("dooutput(\"".gettemplate("error_notreg")."\");");
    } else {
        if($user == $bbuserinfo[userid]) {
        eval("dooutput(\"".gettemplate("itemshop_donate-self")."\");");
        exit;
        } else {
            if($points > 0) {
            eval("dooutput(\"".gettemplate("itemshop_donate")."\");");
            exit;
            } else {
            eval("dooutput(\"".gettemplate("itemshop_donate-error")."\");");
            exit;
            }
        }
    }
}
if (isset($iddonate)) {
    if($points >= $amount) {
    $dpointss=$DB_site->query_first("SELECT $pointfield FROM userfield WHERE userid=$iddonate");
    $dpoints = (int) $dpointss[$pointfield];
    $donated = ($dpoints + $amount);
    $substr = ($points - $amount);
    $DB_site->query("UPDATE userfield SET $pointfield='$donated' WHERE userid=$iddonate");
    $DB_site->query("UPDATE userfield SET $pointfield='$substr' WHERE userid=$bbuserinfo[userid]");
    eval("dooutput(\"".gettemplate("itemshop_donate-thanks")."\");");
    exit;
    } else {
    eval("dooutput(\"".gettemplate("itemshop_donate-more")."\");");
    exit;
    }
} 


Something has to be wrong there, but since I am a newbie I have no idea what it can be.