UBB.threads PHP Forum Software Community Forums UBB.threads 7 Version 7 Support using mysql to update a group's title

$q = "
update {$config['TABLE_PREFIX']}USER_PROFILE
set USER_CUSTOM_TITLE='n00b Sponsor!', USER_NAME_COLOR='#0af'
where USER_ID=$user_id";

$dbh->do_query($q); 

update ubbt_USER_PROFILE up, ubbt_USER_GROUPS ug
set up.USER_CUSTOM_TITLE="whatever title"
where up.USER_ID=ug.USER_ID
and ug.GROUP_ID=xxx

} else {																		   
	// Add user to this group														
	$query = "																	   
		replace into {$config['TABLE_PREFIX']}USER_GROUPS							  
		(USER_ID,GROUP_ID)															 
		values																		 
		( ? , ? )																	  
	";																			   
	$dbh->do_placeholder_query($query,array($user_id,$group_id),__LINE__,__FILE__); 

// SD Mod -- Update their name color / title
if ($group_id == xx) {
$query = "
	update {$config['TABLE_PREFIX']}USER_PROFILE
	set USER_CUSTOM_TITLE='n00b Sponsor!', USER_NAME_COLOR='#0af'
	where USER_ID=$user_id
";
$dbh->do_query($query);
}