[Deletion of (sent items) started right now [Manually]. (86766 x 20 = 1,735,320 send items)

[bestblackhatforum]

86766 x 20 = 1,735,320 pm on sent items to be deleted.

Sent Item(s)


Private Inbox Message (PM) as of 07-11-2022, 03:42 AM


Once I completed the deletion of "Sent Item(s)".
PM will follow.

I have been announcing since February 01, 2022 to backup all your PM.
This is more than 5 month(s) already. I have not failed to remind everyone.
This is necessary for me to carry some major upgrade since our database right now is more than 9.5GB+.

And i have to minimize the size of it for smoother upgrade.

Thank you for understanding.

[bestblackhatforum]

You can help me speed up the process too if you can delete it by yourself.

Simply go to

PM:
http://bestblackhatforum.com/private.php

Sent items:
http://bestblackhatforum.com/private.php?fid=2

Trash Can:
http://bestblackhatforum.com/private.php?fid=4

and delete unnecessary pm you have.
Nonetheless even without your help i am already starting deleting it,
But still i would appreciate some help. Thanks.

[bestblackhatforum]

150k+ pm deleted. My eyes and fingers are quite tired.


Does anyone here know the exact sql command to delete old pm, let say pm that is more than year 2020, meaning all pm from year 2020, 2019, 2018 below can be deleted right away with single sql command.

I found someone sharing sql command from this thread:
https://community.mybb.com/thread-114253.html

Quote:you can use SQL query similar to below

PHP Code:

DELETE FROM `mybb_privatemessages` WHERE `uid` = X AND `dateline` < unixtimestamp 


eg.

PHP Code:

DELETE FROM `mybb_privatemessages` WHERE `uid` = 1 AND `dateline` < 1325397600 


1325397600 is unix time stamp of 1st Jan 2012 (0h:0m EST)

i tried testing it

PHP Code:

DELETE FROM `privatemessages` WHERE `uid` = 1 AND `dateline` < 1607725230 


but it seems it only delete my pm but not pm from all users. Appreciate someone who can help me with the exact sql command, as i am still deleting it manually until now. Thanks.

[darkweb]

Hi Admin,
Any pointers or instructions on how to backup these messages in my inbox? I'd be happy to help out but would like to save them if possible. Not sure how though. Thanks and good luck.

[bestblackhatforum]

(07-14-2022 05:00 PM)darkweb Wrote:  Hi Admin,
Any pointers or instructions on how to backup these messages in my inbox? I'd be happy to help out but would like to save them if possible. Not sure how though. Thanks and good luck.

Hi darkweb, on your private message, if there is important details like email address used on payment among seller/buyer, or payment receipt you used before that contain the date of purchase, etc. You can backup it if you want on your pc or laptop, you can save create a folder and store it on notepad.txt to save some important details cause that soon will be deleted. Thanks.

-Mikhael

[sjc999]

"...WHERE `uid` = 1 AND `dateline` < 1607725230 "

What I would try: if you are the superuser, UID = 1 is specifying only to delete your messages.
Try without the UID:

"...WHERE `dateline` < 1607725230 "

I have no way to test it, but it is logical. Hope it helps.

[Makepeace]

(07-14-2022 05:00 PM)darkweb Wrote:  Hi Admin,
Any pointers or instructions on how to backup these messages in my inbox? I'd be happy to help out but would like to save them if possible. Not sure how though. Thanks and good luck.

This links allows you to export sll PMs as a HTML file, or Excel:
http://bestblackhatforum.com/private.php?action=export

[bestblackhatforum]

(07-14-2022 09:08 PM)sjc999 Wrote:  "...WHERE `uid` = 1 AND `dateline` < 1607725230 "

What I would try: if you are the superuser, UID = 1 is specifying only to delete your messages.
Try without the UID:

"...WHERE `dateline` < 1607725230 "

I have no way to test it, but it is logical. Hope it helps.

Thank you so much sjc999. It works.

PHP Code:

DELETE FROM `privatemessages` WHERE `dateline` < 1607725230 


[rh619]

ohh shit, i am not a regular user, i have bought a lot of tools from 1 GB , and I need my private messages, how can I recover my old messages?

[zlee]

I am in same boat as rh619. I have been away from BBF for awhile and just now getting back into the swing of the IM thing. Had no idea this was going on. Hadn't even noticed until now. ALL of my BBF purchases, access etc is now gone. Is there no option to retrieve?
Thanks.