paidsub_build Plugin - HELP!!! :(

[Mko]

Hello everyone,
I've been trying to construct a plugin where, upon a user purchasing any sort of subscription on the Forums, it'd update their usergroup on my server.

Here's the Plugin information:
Location: paidsub_build
Code:
$uid_ps = $vbulletin->userinfo['userid'];
$userid_ps = fetch_userinfo($uid_ps);

$query = "UPDATE characters SET mgroup = 11 WHERE id = '{$userid_ps}'";

print_log("Applying Premium for: User ID - {$vbulletin->userinfo['userid']}, Changing group to - 11");

$db->query_write($query);

It doesn't seem to work sadly. Does anyone have any idea of how to fix it?

Thanks a bunch :)

[kh99]

It looks like you already have the user info but are calling fetch_userinfo()? I don't think you have to do that. Also the return value is an array. I think you would just want to use $uid_ps in your query like:


$uid_ps = $vbulletin->userinfo['userid'];

$query = "UPDATE characters SET mgroup = 11 WHERE id = $uid_ps";

[Mko]

It looks like you already have the user info but are calling fetch_userinfo()? I don't think you have to do that. Also the return value is an array. I think you would just want to use $uid_ps in your query like:


$uid_ps = $vbulletin->userinfo['userid'];

$query = "UPDATE characters SET mgroup = 11 WHERE id = $uid_ps";

Alright, I'll try it out and let you know how it goes.
Here's the new code:
$uid_ps = $vbulletin->userinfo['userid'];
//$userid_ps = fetch_userinfo($uid_ps);

$query = "UPDATE characters SET mgroup = 11 WHERE id = $uid_ps";

print_log("Applying Premium for: User ID - {$vbulletin->userinfo['userid']}, Changing group to - 11");

$db->query_write($query);