The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
|
#11
10-26-2002, 05:57 AM
|
||||
|
||||
But it should not be a query - all you need is a line that says "if ($bbuserinfo[userid]==1) { etc. etc. " which does not take a db query at all. What other hacks do you have? You may have installed a hack, and uninstalled it, but left some code in your showthread.php or functions.php.
|
|
#12
10-26-2002, 11:58 AM
|
||||
|
||||
|
There's no such line in my showthread.php or admin/functions.php
And I've got a fair few hacks installed, but I've completely removed all code from any hacks that I've uninstalled. I always ensure to double-check that so as to not chance any errors.
|
|
#13
11-03-2002, 06:23 AM
|
||||
|
||||
|
Do you by chance have TECK's "Quick Post Delete" (or something like that) hack installed? If so check the thread for updates. There was an error that was causing many queries on the showthread pages.
|
|
#15
11-03-2002, 01:10 PM
|
||||
|
||||
|
I thought that might be it.
 I had the hack installed on my board and noticed the jump in queries about a month later. It took me forever to figure out what was causing it. And I agree... It's very handy and much easier than the default method. 
|
|
#16
11-03-2002, 01:23 PM
|
||||
|
||||
|
Hmmm, even with the fix I'm still getting around 50 queries on a showthread page, like this one...
http://x-mencomics.com/xfan/forums/s...=&pagenumber=2
|
|
#19
11-03-2002, 01:56 PM
|
||||
|
||||
|
Have you added all the templates for hacks in the $templatesused section near the top of the file? It sounds like you might have missed a few. The 1st and 7th table you see on the explain=1 should be the only ones that start out with template. If you see any others that look like this...
Query: SELECT template FROM template WHERE title='some_template_name_here' Just add the name of that template in $templatesused on showthread.php and it'll remove at least a few of the queries. I only have one select count(*) query on my page, so I'm not sure where those are coming from. If you post a couple of them here I'll try to help you figure that out if you like. Oh, a note about adding the templates... Make sure you add them under the 2nd instance of $templatesused on showthread.php. You should see the following lines right above it... // ################################################## ############################ // ############################# SHOW THREAD #################################### // ################################################## ############################
|
|
#20
11-03-2002, 06:14 PM
|
||||
|
||||
|
Plurplanet is right. Each template that is eval() that is not in the $templatesused list is an extra unnecessary query. Cache them by adding them to the $templatesused section.
|
 |
«
Previous Thread
|
Next Thread
»
Linear Mode
|
|
All times are GMT. The time now is 01:39 AM.