vb.org Archive - Query Question

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)

- - Query Question (https://vborg.vbsupport.ru/showthread.php?t=54428)

kaotic

06-17-2003 01:31 AM

Query Question

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

Code:

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:

Code:

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

All times are GMT. The time now is 07:08 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01827 seconds Memory Usage 1,711KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (2)bbcode_code_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (6)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: