deleting all pm's

[kidzior]

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.

 

[bluescorpion]

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

 

[nesta42]

hi

in your phpmyadmin Send this SQL command

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

 

[kidzior]

Only clear for me, but not for other users, help.

 

[dxbstars]

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 ^_^

 

[nesta42]

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 ^_^

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>

After sending the command sql, updates the counters

 

[dxbstars]

its same ^_^ but its beter with the product for newbie