MyBB Community Forums

MyBB Community Forums > Community Archive > Archived Forums > Archived Development and Support > MyBB 1.6 > 1.6 General Support > SQL query to set a prefix to all threads posted by a specific user
Full Version: SQL query to set a prefix to all threads posted by a specific user
You're currently viewing a stripped down version of our content. View the full version with proper formatting.

One-Two

2011-06-23, 02:02 PM
Hi, I need an SQL query to set a prefix to all threads made by a specific user (let's say UID=1 / me).
For example if the user has posted 50 threads, I want all 50 to have the same prefix.

Is it possible? Thanks.

faviouz

2011-06-23, 02:08 PM
UPDATE  `mybb_threads` SET  `prefix` =  '2' WHERE  `uid` =  '1'

Replace 2 with the prefix ID and 1 with the user ID.

One-Two

2011-06-23, 02:25 PM
Works fine.
Thank you faviouz!
MyBB Community Forums > Community Archive > Archived Forums > Archived Development and Support > MyBB 1.6 > 1.6 General Support > SQL query to set a prefix to all threads posted by a specific user