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...
|