Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 General Discussions
Reload this Page Help!!!!!
FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1  
Old 09-12-2002, 09:18 PM
Lovaboye Lovaboye is offline
 
Join Date: Apr 2002
Posts: 46
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Help!!!!!
DELETE FROM 'user' WHERE 'posts' = '0'

is this correct?

i want to delete all users with 0-posts, what is the correct query to run in phpmyadmin thx?
Reply With Quote
  #2  
Old 09-12-2002, 09:26 PM
Neo's Avatar
Neo Neo is offline
 
Join Date: Oct 2001
Location: Anywhere
Posts: 1,817
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
DELETE FROM user WHERE posts=0

this would work.. and next time please only post one thread.
Reply With Quote
  #3  
Old 09-12-2002, 09:31 PM
Lovaboye Lovaboye is offline
 
Join Date: Apr 2002
Posts: 46
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
real sorry bro, but thx 4 the help
Reply With Quote
  #4  
Old 09-12-2002, 10:03 PM
2 X Viverridae's Avatar
2 X Viverridae 2 X Viverridae is offline
 
Join Date: Jul 2002
Location: Undisclosed
Posts: 61
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
https://vborg.vbsupport.ru/showthrea...threadid=43477

https://vborg.vbsupport.ru/showthrea...threadid=43478

Holy triple cross-posting Batman!

@ Lovaboye - there are few things as annoying as finding several threads with identical content in 'em.
Reply With Quote
  #5  
Old 09-13-2002, 12:51 AM
[D]Vincent's Avatar
[D]Vincent [D]Vincent is offline
 
Join Date: Jun 2002
Location: In my own little world?
Posts: 411
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
One of the things as annoying is people pointing it out after the person apologized.
Reply With Quote
  #6  
Old 09-13-2002, 08:18 AM
Logician's Avatar
Logician Logician is offline
 
Join Date: Nov 2001
Location: inside vb code
Posts: 4,449
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Quote:
Originally posted by Lovaboye
i want to delete all users with 0-posts, what is the correct query to run in phpmyadmin thx?
I dont recommend deleting users like this. Your will be able to delete their records from user table but there can be many other traces of this user in other tables in your database. Examples: His private messages, his subscribed threads, his personal calender events.. etc. By deleting the user with this query you'll leave orphaned records of this user in your database and it would be more than hard to pin point and remove them later. Your best bet is to delete them inside Admin CP or write a script which will also delete other traces of these users from your database..My 2 cents..
Reply With Quote
  #7  
Old 09-13-2002, 06:41 PM
[D]Vincent's Avatar
[D]Vincent [D]Vincent is offline
 
Join Date: Jun 2002
Location: In my own little world?
Posts: 411
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Vincent]I believe there's a hack for this anyways.

Found the hack...
http://www.vbulletin.org/hacks/index...ack&hackid=514
Reply With Quote
  #8  
Old 09-13-2002, 07:54 PM
g-force2k2 g-force2k2 is offline
 
Join Date: Mar 2002
Location: Everywhere you wanna be..
Posts: 1,608
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
i have to agree with Logician... deleting users by just userid leaves more then enough information still left in the database... theres about like five (or more different tables) based upon the userid so basically you're just leaving excess storage in there when a simple delete user will do the trick regards...

g-force2k2
Reply With Quote
Reply

« Previous Thread | Next Thread »
Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT. The time now is 11:28 AM.

Contact Us - Archive - Top

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.04565 seconds
  • Memory Usage 2,221KB
  • Queries Executed 13 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (8)post_thanks_box
  • (8)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (8)post_thanks_postbit_info
  • (8)postbit
  • (8)postbit_onlinestatus
  • (8)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 
Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete