vb.org Archive - Query required to set all users "COPPA User" to NO

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

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

- - Query required to set all users "COPPA User" to NO (https://vborg.vbsupport.ru/showthread.php?t=233758)

fer_75

01-21-2010 05:04 PM

Query required to set all users "COPPA User" to NO

Hi,

I have imported some users to my board, it is all working perfect. But now all that users has "COPPA User" set to YES.

I would like to run a query to SET all COPPA User to NO. I do not find the field for coppa in user table.

Could you please help me out and provide me the right Query to set all user coppa field to NO?

http://img717.imageshack.us/img717/8938/copa.png

Please help!

All times are GMT. The time now is 05:01 PM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01075 seconds Memory Usage 1,701KB 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 (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (1)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: