MyBB Community Forums

Full Version: Help me with query please
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
I've change many users UID in table users so their post are incorrect with UID right now

But I already know their old uid and new uid

What query I need to run to correct the method like

for all table, if uid = x, then fix x uid = y;

Thx >_<
I guess you can try this. Run this query on phpMyAdmin.

UPDATE mybb_users SET uid=xx WHERE uid=x

Change mybb_ if you're using another table prefix.
xx is the uid you want to change it to
x current uid.
OMG thank you!!

Can I married with you?
Constrictor Wrote:OMG thank you!!

Can I married with you?

Lol, your very welcome. And um marry me? Haha
DCR Wrote:
Constrictor Wrote:OMG thank you!!

Can I married with you?
Lol, your very welcome. And um marry me? Haha
Is this the first ever MyBB Community marriage proposal? Big Grin
DCR is one lucky person Toungue