[DaveNGU]

Originally Posted by kh99

You could update the user's rank field in the usertextfield table, but the rank gets recalculated whenever any user data is updated, so it's not meant to be set to an aribitrary value.

How would I do this?

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

Originally Posted by kh99

You could update the user's rank field in the usertextfield table, but the rank gets recalculated whenever any user data is updated, so it's not meant to be set to an aribitrary value.

$ranks =  $vbulletin->db->query_first("
			SELECT rank
			FROM ".$schema.".".$db_prefix."usertextfield
			WHERE username = 'Jake'
			");

I've put the username in there as a test.. but this is giving me: MySQL Error : Unknown column 'username' in 'where clause'

Is their username not stored in this table?