vb.org Archive - How do I set post count to 0 for user accounts imported from another board?

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

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

- - How do I set post count to 0 for user accounts imported from another board? (https://vborg.vbsupport.ru/showthread.php?t=57322)

translucent

09-22-2003 08:32 PM

How do I set post count to 0 for user accounts imported from another board?

I imported all user accounts from a previous install into my new site. Some of the users stayed with the board while others chose not to transfer. The users who stayed want to keep their post count cumulative between the two boards. What I'd like to do is set the post count to zero for any member who posted on the previous board but not on the new one. I've tried standard SQL update statements joining the post and user tables only to encounter a syntax error. Do you guys have any ideas?

translucent

10-07-2003 05:01 PM

Anyone?

All times are GMT. The time now is 06:52 PM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01093 seconds Memory Usage 1,702KB 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 (2)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: