View Full Version : Query Question
kaotic
06-17-2003, 01:31 AM
This time, I need a query to change everyone's "cookieuser" field to 1. Many are set to 0, which disables their ability to join my chatroom.
Cloudrunner
06-17-2003, 03:20 AM
ALTER TABLE `user` CHANGE `cookieuser` `cookieuser` SMALLINT(6) DEFAULT '1' NOT NULL;
This sets all new registers to default to '1', then run this query:
UPDATE `user` SET `cookieuser` = '1' WHERE `cookieuser` = '0';
This set all users whose `cookieuser` column is '0' to '1'.
Enjoy
)O( Cloudrunner )O(
kaotic
06-17-2003, 04:16 AM
Many thanks for your assistance. Also, do you know what exactly this column for? I'm not sure what the cookieuser thing is all about. Will there a problem if I were to alter the table like this?
Cloudrunner
06-17-2003, 04:58 AM
This column is to set whether the users are using cookies to browse the board or not.
They can change that column in their user CP if they so choose.
filburt1
06-17-2003, 10:42 AM
Be sure to remove it from the user CP and registration templates, too (or make it a hidden field).
kaotic
06-19-2003, 11:32 PM
Good idea. :D
vBulletin® v3.8.12 by vBS, Copyright ©2000-2025, vBulletin Solutions Inc.