UBB.Developers Forums UBB.threads 7 Development How Do I? finding a user in the database

Hi there

how do i find a particular username in the database, whats happend is that he has changes his profile to spanish language but when he logs in it comes up with some page and he cant do anything from it, just reloads the same page all the time, so i need to set him back to english...

cheers

You should be able to edit the user and then 'edit profile' should have a language field to change.

hmmm i dont seem to have a lanuage option in the edit profile area!

?

You can run a query in the sql command window

Update w3t_Users SET U_Language = 'english' where U_Username = 'XXXX'


Replace XXXX with the username

Thanks heaps!