Change username on custom php page.

[Shalom.]

hello, i just make a new php page that allowed users to change their usernames.
i use this code:
$db->query_read("UPDATE user SET username='$newusername' where userid=$userid");
but it's sucks because in the fromdisplay i still see the old username.
i tried to find the code that used on the admincp but i didn't find it..
please help, thanks.

[ForceHSS]

<a href="https://vborg.vbsupport.ru/showthread.php?t=236980&highlight=change+username" target="_blank">https://vborg.vbsupport.ru/showt...hange+username</a>

[Shalom.]

i have a custom page..
i just want the code to set the new username.
i try this code:
$db->query_read("UPDATE user SET username='$newusername' where userid=$userid");
but in the forumdisply i still have the old username

(i tried to find the code from the admincp>user.php but i didn't find the code..

[ForceHSS]

the above plugin will do it for you

[Shalom.]

i dont want plugin..
i have the all code, i just want code to update the username in all tables(on db)

[ForceHSS]

Then why don't you download that plugin and see how it works

[Shalom.]

i did..
$userdata =& datamanager_init('User', $vbulletin, ERRTYPE_CP);
$userdata->set_existing(fetch_userinfo($exists['userid']));
$userdata->set('username', $vbulletin->GPC['newusername']);
$userdata->save();
unset($userdata);
but it dosent work..
maybe i have mistake ?
can u give me expamle with that code?

[Dave]

It shows the old username because in the post table there's a column called username and in the thread table there are 2 columns called postusername and lastposter.

[Shalom.]

Originally Posted by Dave

It shows the old username because in the post table there's a column called username and in the thread table there are 2 columns called postusername and lastposter.

so how in the admincp it's change the all username in all tables?
can u give me the code from the admincp ? i can't find it

[tbworld]

Originally Posted by Shalom.

hello, i just make a new php page that allowed users to change their usernames.
i use this code:
$db->query_read("UPDATE user SET username='$newusername' where userid=$userid");
but it's sucks because in the fromdisplay i still see the old username.
i tried to find the code that used on the admincp but i didn't find it..
please help, thanks.

First, it would have been nice if you showed your code, when your asking for assistance time.
Second, where is your query_write?
Third, use the datamanager you will have less problems. See "/includes/class_dm_user.php". There are several examples here on the board on how to use the datamanagers. I will see if I can find you a reference.