paidsub hook

[ZERO <ibis>]

PHP Code:

function function($userid, $findstuff = true, $sbaid = "", $sbmemgroups = "")
{
    global $db, $vB_Groups, $sB_Groups, $sB_Names, $sB_Server, $sbaidfield;

    if ($findstuff)
    {
        $sbquery = $db->query_read("
            SELECT " . TABLE_PREFIX . "user.membergroupids, " . TABLE_PREFIX . "userfield.$sbaidfield
            FROM " . TABLE_PREFIX . "user, " . TABLE_PREFIX . "userfield
            WHERE " . TABLE_PREFIX . "user.userid = " . TABLE_PREFIX . "userfield.userid
                AND " . TABLE_PREFIX . "user.userid = $userid
        ");

        $sbrow = $db->fetch_array($sbquery);
        $sbaid = $sbrow[$sbaidfield];
        $sbmemgroups = $sbrow['membergroupids'];
    } 


So it runs that query when the userid is returned to it correctly.

in useradmin_update_save i run:

PHP Code:

$sbsteam = $userdata->userfield[$steamfield];

$db->query_write("
    UPDATE sb_admins
    SET authid = '$sbsteam'".$sbpwquery."
    WHERE aid = ". $userdata->userfield[$sbaidfield]
);

function($userdata->fetch_field('userid'), false, $userdata->userfield[$sbaidfield], $userdata->fetch_field('membergroupids')); 


This works fine and has no issues excusing the function. I was using this on vb3 but after moving to vb4 the paidsub_build and paidsub_delete part broke. I have been trying to figure out how to get it working again to no avail.


Also if you need more code to figure out what is going on I can pm you the exact code I am using. I am also willing to pay $ to get this working.

--------------- Added [DATE]1305682080[/DATE] at [TIME]1305682080[/TIME] ---------------

OK perhaps this is an sql issue. When I run:

(this from my understanding as listed in another thread should be correct)

PHP Code:

global $vbulletin;

require_once('./global.php'); 

function($user[userid]); 


I get this sql error:

Invalid SQL:

                       SELECT vbb_user.membergroupids, vbb_userfield.
                       FROM vbb_user, vbb_userfield
                       WHERE vbb_user.userid = vbb_userfield.userid
                               AND vbb_user.userid = 1;

MySQL Error   : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM vbb_user, vbb_userfield
                       WHERE vbb_user.userid = vbb_userfield.userid
                       ' at line 2
Error Number  : 1064

Note that 1 is the value returned by $user[userid] which is the correct value.

--------------- Added [DATE]1305683556[/DATE] at [TIME]1305683556[/TIME] ---------------

Thank you all for the help. It was an sql issue. It appears that sql no longer likes $variables in the code. So for now hard coding the values in works.