paidsub hook

[ZERO <ibis>]

I am trying to use the paidsub_build and paidsub_delete hooks to run a function however I can not seem to get it to work. I think that I am not getting the userid the correct way below is what I have tried:

global $vbulletin;

require_once('./global.php');

function($user['userid']);

global $vbulletin;

require_once('./global.php');

function($user[userid]);

function($user[userid]);

function($user['userid']);

function($userid);

global $vbulletin;

require_once('./global.php');

function($userid);

global $vbulletin;

require_once('./global.php');

function(paymentinfo['userid']);

What am I doing wrong here?

[Eliasen]

Not sure if this is of any help, but how about this:

$vbulletin->userinfo['userid']

[ZERO <ibis>]

Tried (updated as I attempt multiple combinations):
(if one produces an error it will be indicated, otherwise does nothing)

function($vbulletin->userinfo['userid']);

function(vbulletin->userdata['userid']);

[Boofo]

What is the function part?

[ZERO <ibis>]

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:
$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 1305682080 at 1305682080 ---------------

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

(this from my understanding as listed in another thread should be correct)
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 1305683556 at 1305683556 ---------------

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.