[Forum] Question About Mysql Query Via PHPMyadmin

[BUDIMAN]

I hope anyone who expert with database & sql query has answer for this.


1. How to prune all Private Message
2. How to prune all Visitors Message
3. When there's a user sign up, which one table will be added? I mean, what's the table that related to users list.?
4. What's the table that related to thread & post

[Steve Machol]

1. To delete all PMs, run these 5 queries:

UPDATE `user` SET `pmtotal` = '0';
UPDATE `user` SET `pmunread` = '0';
TRUNCATE TABLE `pm`;
TRUNCATE TABLE `pmtext`;
TRUNCATE TABLE `pmreceipt`;

Of course, backup your database first.

2. To delete all visitormessages, run these queries:

truncate vistormessage;
truncate visitormessage_hash;

update user set vnunreadcount='0';
update user set vmmoderatedcount='0';


3. The user data is added to three tables:

user
userfield
usertextfield

4. That would be the thread and post tables.

[BUDIMAN]

Thanks Steve. I'll figure that out..