Help!!!!!

[Lovaboye]

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?

[Neo]

DELETE FROM user WHERE posts=0

this would work.. and next time please only post one thread.

[Lovaboye]

real sorry bro, but thx 4 the help

[2 X Viverridae]

https://vborg.vbsupport.ru/showthread.php?s=&threadid=43477

https://vborg.vbsupport.ru/showthread.php?s=&threadid=43478

Holy triple cross-posting Batman!

@ Lovaboye - there are few things as annoying as finding several threads with identical content in 'em.

[[D]Vincent]

One of the things as annoying is people pointing it out after the person apologized.

[Logician]

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..

[[D]Vincent]

Vincent]I believe there's a hack for this anyways.

Found the hack...
http://www.vbulletin.org/hacks/index.php?s=&action=showhack&hackid=514

[g-force2k2]

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