I can't believe it is the db or anything with the MySQL because the board runs fine as well as all of the other hacks I have installed. Like you said, it is just one of those things that can't be explained on some boards. Mine seems to be one of them, I guess. ;)

You script looks good. I'd be interested in taking a closer look at it when you get some more of the stuff added. Let me know if I can help in any way. ;)

post 38 attachment works fine - no errors whatsoever

and yeah i have over 2000 pms on my site and it aint slow.

[high]* DPoole click installs
[/high]

even though there is no Install :)

seems like an interesting hack, although i had problems running it on my localhost, probibly cause i have modified the tables a lot

Does this do the same as PPN's hack or more? :)

- miSt

Well, It works for me, but it is very slow... and I have 2473 pm's on my forum...
Oh, I think there is a problem, it shows me the last pm date: 04/08/03 @ 7:24 am
and look at the date now... i sent at least 5 pm's today...
and another problem (I think) it tells me that theres 2473 pm's on my forum but the last message ID is 1800... :paranoid:
anyone has any ideas?

I have PPN's hack installed and I believe the difference is this hack shows all PMs and individual PMs. PPN's only shows individual.

Are you finished with the hack? I'll install it when you are. (Pages mainly, as we have thousands of PMs...hundreds daily, I think)

This forum has been down for like 3 days, and yes i still have lots of modification to add to it, i assure you when i finish ill try and get all the bugs out.

Thats because that number 2473 means the total amount of pm's on your forum, if the last message ID is 1800 that means that ur members deleted it... this script only shows the current PM's on the forum, if they delete the PM, its deleted it from the mysql table therefor gone..and this script wont show it. Also there no bug in the script for the date, its pulling that directly from whats in ur table, so if anything its what vbulletins written to that field, this script simply reads.

Update:
Cleaned the code up a bit more, and if your using ./global from the admin folder, i made it so the queries use vbulletins function $DB_site->query() else it will use the standard mysql_query, since vbulletin already checks for globals etc... MAYBE that will solve some of the problems that people have been having on some servers...i have no idea, i dont specialize in the technicalities of how the php modules works.. Also I added a "Generate in" so you know how long it took for php/mysql to parse it/retrieve it w/e , notice if you wait seconds and ur like Damn this is slow, its not the script believe me, i have pretty much optimized it far as i can in query usage without using left and right joins which i really dont want to do.. it would either be the time php is fetching the rows from the db, or your connection you have to think 2000+ messages is a lot of text (in theory), also i cant believe i didnt do it earlier, i added nl2br() so its formatted correctly like you would see it if you were reading your own pm, later I will add pageanation (*damn still gotta do it*) and a view config, cause if you dont already know when you send a pm, it actually makes 2 inserts into the table, a copy for you and a copy for the receiver, but anyway, I was gonna make it so on the main page, of all the pm's if you set view to 1 it would basically check for duplicate messages and not show 1 of them so you dont have lots of the same message everywhere... more later.

Ill be adding some more stuff later yo's sorry i couldnt reply earlier...

bump

It is a bug! i've asked my friend to send me a message...
i kept it but still the last message id is 1800.
when i klicked on my nick the last message id I saw is:
So what do you think?