The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
Comments |
#2
|
|||
|
|||
Stallion,
Seems faster to me. Of course, its kind of late at night so the load on the server is kind of low as well. One thing to note, this part Code:
user.avimage as avimage Nice work. Gotta love optimizations. Now can you do anything for the member.php?action=showprofile? |
#3
|
|||
|
|||
Make note that if you paste that in, you will break any hacks that deal with showthread (avatar,location,stars,etc) so be ready for that. Nothing ill will come of it, your hack will just dissapear from the posts.
|
#4
|
|||
|
|||
It appears "avimage" was part of the avatar hack, so I removed that section for my inital post. If you do have any hacks which modified this SELECT statement, you'll want to go through and re-hack any modified steps.
If you don't feel comfortable doing that, and think the loading speed for showthread.php is fine, then don't worry about making these changes at all. |
#5
|
|||
|
|||
"avimage" is probably part of Moonwolf's avatar hack.
|
#6
|
|||
|
|||
It seems that in your rush for glory you forgot one small detail. You are doing a join on the post table and user table where user.userid = post.userid
Only problem is that if I allow Guests to post - as I do on one forum - they have a userid of 0 which has no match in the user table, hence the message is now empty. Case in point : http://www.thebangles.net/forums/sho...hp?threadid=13 I cheated and created a "Guest" user with userid of 0 so there would be something to match. You would need to come up with something cleaner though. The threads do seem faster now though This little "hack" should help out forums like Martins, wrestlingtalks, etc immensely as just imagine 120 users, each issueing 30 (say you allow 30 posts to show on a thread page) mysql select statements at once (3600 statements!). That is now cut down to 120 select statements with slight overhead of making a join. I only have 230 users (6000+) posts and it makes a big difference as I don't subtly see the thread "build" itself now, it just pops on the screen at once. [Edited by rangersfan on 08-29-2000 at 12:24 AM] |
#7
|
|||
|
|||
looking good ... how do you keep track of other hacks you add into a php file like showthread.php ?
i have the following hacks installed locations/interest hack rangersfan's avatar hack search result new post/last post jump arrows so doing the above changes to showthread.php, to re add the hacks do i just follow the original hack's instructions ? |
#8
|
|||
|
|||
I had installed the PM hack, and it had some changes to the second MySQL query above. However, it was one word off (and it looked like it was tacked on) so I just replaced it. I tacked on "user.receivepm as receivepm" to the first query statement above, and it's working fine now.
LMK if I've done something terribly wrong, as I'm a relative newbie to PHP and MySQL... |
#9
|
|||
|
|||
I implemented the hack (including the addition of the the "user.receivepm as receivepm" which Armage Bedar suggested) and it seems to be just great so far. One question though: are there any changes I ought to add if I have the Poll hack?
Thanks, Bira |
#10
|
|||
|
|||
I don't have the private messaging/poll hacks installed, so I can't give specific info. All I can suggest is that if the hack modified the SQL statement listed, you go back and repeat whatever steps modified that statement, but base it off the new SQL statement I posted.
rangersfan: I don't have guest posting enabled on my forum, so I wasn't aware of that problem. I'll look more into the way vB handles non-registered posts and see if I can come up with an update. |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|