[DaveNGU]

Originally Posted by kh99

You'd have to connect to the database. You can write a script that chdir()s to the forum directory then includes global.php, then you can use $vbulletin->db, or you could use the php mysql functions to go directly to the database (but you need the connection info from config.php).



It's not, only the userid is there. But if you only have the username you could do this:

$ranks =  $vbulletin->db->query_first("
			SELECT rank
			FROM ".$schema.".".$db_prefix."usertextfield AS usertextfield
                        LEFT JOIN ".$schema.".".$db_prefix."user AS user ON (user.userid = usertextfield.userid)
			WHERE username = 'Jake'
			");

Got you. I've managed to update it as well, so this seems to be working fine .

Will report back if need be, thanks for your help.