vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)
-   -   User thread queries (https://vborg.vbsupport.ru/showthread.php?t=285868)

VIRUS-T-HUNTER 07-23-2012 01:00 PM

User thread queries
 
Hello !

I recently notice that their are thousands of threads of different users who are doing spam on my forum about 5000 posts, is their any query to delete the user along with their posts and threads?

and also if their is query if user has more then 1000 posts delete that user along with its posts and threads

because from admincp prune option takes ages

I would be very great full to you all thanks

Simon Lloyd 07-23-2012 01:14 PM

You'd have to do it in phpmyadmin to delete the posts by the user then delete the user.

VIRUS-T-HUNTER 07-23-2012 01:22 PM

ok thank you for replying ill install phpmyadmin right now

i have to access in post table and delete all posts by that user id then delete user right?

Simon Lloyd 07-23-2012 08:05 PM

Yes, if you do it in opposite order you'll not find the posts to delete :)

VIRUS-T-HUNTER 07-23-2012 10:55 PM

ok thanks just did that and it works like a charm


All times are GMT. The time now is 04:16 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.00929 seconds
  • Memory Usage 1,707KB
  • 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
  • (5)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