Well, i've tried in a smaller database (smaller PM table) and it worked. My forum PM table has 26.6Mb. Maybe thats the problem. Not very large table friendly.

Well i don't what else to do. I have even tried to change that part of code to Dream's one but i'm definitely not a coder :D. So i wont bodder you anymore. Thanks for your effort.

Update: v3.8.004 - Friday 27th March 2009
-- Changed: Layout of PM lists, individual PMs, sent/received PMs, Search Results
-- Fixed: High server load when clicking List Users with PMs, especially if there are 1000s of users that have PMs (now split into categories acording to how many PMs a user has)
-- Removed: From info for individual users sent PMs
-- Added: Constant to limit minimum length a key search word can be, to limit higher server loads when trying to search for a keyword with a length of 1 (ie. "a"). This minimum is currently set at 4, but can be altered by editing read_pms.php)
-- Added: Various links (depending what function you are using) to view all a users PMs, go to the users pmstats page, edit the user and send the user a PM

Can you please make this only show under users to superadmins as well.

thx ;)

installed ..

thanks a lot :)

Excellent update! However the high server load when trying to "Read PMs" for a single user remains that's a pity :( But as i said before one won't die because of that. My forum has 103118 users and all of them have at least one PM, maybe that's the reason why load gets so high - searching in thousands of PMs, although Dreams code works very well when listing a single user PMs. I'm not complaining, just reporting in case you wich to do something :)

My PM tables:

VBPM 26,6MB
Format fixed
Collation latin1_swedish_ci
Rows 520,364
Row length ? 21
Row size ? 54 Bytes
Next Autoindex 806,562


VBPMReceipt 21,7KB
Format dynamic
Collation latin1_swedish_ci
Rows 189
Row length ? 58
Row size ? 118 Bytes


VBPMText 63,3MB
Format dynamic
Collation latin1_swedish_ci
Rows 142,364
Row length ? 441
Row size ? 466 Bytes
Next Autoindex 233,864

If you want to do this why dont you go into the mysql database and select the "pmtext" table ? there you can edit , read , delete :)

Update: v3.8.005 - Saturday 28th March 2009
-- Added: Read Single PM - read a single PM by typing in pmtextid
-- Added: Ability to disable the limit minimum length a key search word can be

IMPORTANT: This hack is now feature complete and there will be NO more updates, apart from fixing proven bugs.

lol thanks a tonne for locking it up. I was tired of its updates.

Hi thanks
Please be edited and clean these messages are added.

I get this error since the update

You have another hack installed that is using the bbcode_fetch_tags file hook, this is called as part of function fetch_tag_list that is probably causing the problem.

This hack does not use any file hooks at all, and has not changed the calls to the function fetch_tag_list between v3.8.002 and v3.8.005, and again, it does not call the bbcode_fetch_tags file hook.

You can try editing read_pms.php, find the 2 instances of:
Change them to:

And re-upload the file.

If that does not fix it, then what I advise you to do is to check any hacks that use the bbcode_fetch_tags file hook and disable it, and see the problem re-occurs, if it does not then post in that hacks' support thread.

i dont know how to find the user manager and the read pms link. someone help?

lol just look in admincp -> Users dropdown -> Read PM

i know
i want edit & delete from admincp no database
If can Add this Einrichtungen ist so easy work

Please read the above.

And even if this hack was not feature complete, I would still not be adding functions to edit/delete PM directly into this hack, this hack is called Read PMs, as that is all it does. It does have links to other parts of the AdminCP where you can delete all PMs for a user.

This is the second time I have posted that I will not be adding edit/delete functionality to this hack, I will not be replying to any more requests for this functionality, but I will also not be changing my mind at all.

Excellent update, as always. That's a pity that the high server load issue couldn't be solved and because of it i'll use both scripts Dream's and yours. Thank you again.

That fixed it. I know what the other mod is that it was interfering with, it was the video directory remixed. Changing above what you said fixed it thanks a lot.

Can a regular admin upload this?

If they have ftp access, then yes. But only Super Administrators can use this hack.

Database error in vBulletin 3.8.1:

Invalid SQL:

SELECT pm.*, pmtext.*
FROM `pm` AS pm
LEFT JOIN `pmtext` AS pmtext ON(pmtext.pmtextid = pm.pmtextid)
HAVING pm.userid=2820
ORDER BY pmtext.dateline DESC;

Please post the exact error message, as what you posted above does not tell me anything apart from the affected query.

Why Is It Saying Invalid File....

Read the Installation Instructions, as you have not followed them. There are no files to import into the AdminCP.

Update: v3.8.006 - Tuesday 31st March 2009
-- Fixed: High server load when finding PMs for single user id or username
-- Fixed: Problems with hacks that have custom BBCode being called by the bbcode_fetch_tags file hook

Good Job
thank you

I knew you do it! You're the man! Load problem solved, definitely! :up:
Many many thanks to you.

You are most welcome :)

Sorry Bro My Bad
Thanks Anyways
Its Working Fine.....
Great.

Then please click Mark as Installed to show that you are using it on your site.

Very nice working perfectly. Installed!

hmm yeah done
thanks

Where would one go to change what the "button" says? Instead of "Read PM's" I would like to change it to say someting else like "master delete". Thus any admin clicking it would get the super admin message and would never know what it was. I have no desire to use this hack unless warranted thus being the reason noone else needs to know its there.
Thanks

Easy. Change read_pms.php name to (for ex.) super_admin.php, open read_pms.php (or super_admin.php if already changed) and where its says: define('THIS_SCRIPT', 'read_pms'); change it to: define('THIS_SCRIPT', 'super_admin'); open cpnav_rpm.xml and change this lines to what ever modified above:

Thank you very much

You're welcome ;)

Installed. Now I can hunt for terrorists on my forum!

Good job Mosh! Good luck maintaining it :)

I'm wondering if they will still work with 4.0, there's a chance as the PM system will not be changed.

lol man if they will still work with 4.0 than Jelsoft sucks :D

Thanks for allowing me to build on your original version :)

As for v4.0, we will not know until the release the betas, RCs and then Gold, if any of our hacks will still work or not. I suppose we will find out in due course.