paidsub_build Plugin - Still Doesn't Work :(

[Mko]

Again, my code in paidsub_build doesn't seem to work (still) :s

So, here's the code I've come up with:

include_once("./vb_plugin.php"); 

//global $vbulletin;  
//require_once('./global.php');  

$uid_ps = $user['userid'];  
//$userid_ps = fetch_userinfo($uid_ps); 

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

print_log("Applying Premium for: User ID - {$uid_ps} Changing group to - {$sub['nusergroupid']}"); 

$db->query_write($query); 

The print_log function prints that string into a text file, where it looks like it works.
However, for the actual $query, the $uid_ps is still not being interpreted. I really just need to find out how to call the userid so I can use it in the query and be done with it, haha.

So if anyone can help me out on how to fetch a user's id for use in the paidsub_build plugin, I'd appreciate it.

Also, if I'm doing this completely wrong, let me know. If you have any sort of tutorial on how to execute a query in paidsub_plugin, also let me know


Thanks in advance for everything,
Mark.