deleting all pm's

K

kidzior

New Member
Hi how to can i delete all pm's ?
i use phpmyadmin and i clear table prefix_pm and pm are clear, but i have
Private Messages: Unread 0, Total 313.

Help me guys.
 
The PM table is only one of them. My vB has three related PM tables. I think you have to purge them all. I don't see any counters to update but don't know about that for sure. If you check pmtext, you will probably find the number of records that are being reported and you may find some thing in pmreceipt but I suspect that one is empty.

HTH,

bs
 
hi

in your phpmyadmin Send this SQL command

PHP: 
TRUNCATE TABLE pm;
TRUNCATE TABLE pmtext;
TRUNCATE TABLE pmreceipt;
UPDATE user SET pmtotal=0,pmunread=0;
 
i have this hack "product"

upload it and it will delete all yor pm [automatically]

note: wait 30 second after uploading the product and delete it from your forum ^_^
 
dxbstars said:
i have this hack "product"

upload it and it will delete all yor pm [automatically]

note: wait 30 second after uploading the product and delete it from your forum ^_^
Click to expand...

hi

lol
open the file xml .

<?xml version="1.0" encoding="ISO-8859-1"?>
<product productid="pm" active="1">
<title>deleted all PMs</title>
<description />
<version>1</version>
<codes>
<code version="1">
<installcode><![CDATA[$db->hide_errors();
$db->query_write("TRUNCATE `pm`;");
$db->query_write("TRUNCATE `pmreceipt`;");
$db->query_write("TRUNCATE `pmtext`;");
$db->query_write("UPDATE `user` SET `pmtotal` = 0, `pmunread` = 0;");
$db->errno = 0;]]></installcode>
<uninstallcode />
</code>
</codes>
<templates>
</templates>
<plugins>
</plugins>
<phrases>
</phrases>
<options>
</options>
</product>
Click to expand...

After sending the command sql, updates the counters
 
You must log in or register to reply here.
Back
Top