Results of the second one were fast as well..

Query: SELECT thread.pollid,thread.open FROM thread WHERE thread.forumid='108' ORDER BY thread.dateline DESC LIMIT 1
Time before: 0.20433604717255
Time after: 0.20571005344391

Hate to interrupt your guys troubleshooting session here but I'm curious if there's a way to add more custom templates? =)

I'm using a portal page write now that I did in html, and I have 5 sections that I would need to add.

Thanks!

Ok, since both of those seem ok I guess it's not a problem with it querying the table, so maybe it's something with the way they are joined.

Try this query and see if it's any better...

alkatraz,

I would imagine you would just change this

to something like this...

And create templates for each.

Then edit the 'index' template located under mYvBindex Templates and add $custom3, $custom4, $custom5 where ever you want the templates to be displayed.

A little better...

Page generated in 2.58082700 instead of 3.6 - 4 seconds. :)

To add more custom templates to your homepage, follow the instructions below...

Look in your myvbindex.php file look inbetween the following lines of code:
And:
In that space you can add code for it to call more custom templates. You would just add something like the following:

Or, if you would prefer to have the option to turn these templates on/off in the Admin CP like the first two, you would add something like this:
Then, only if you want to add the options to turn them on/off you would run the following queries via phpMyAdmin.

INSERT INTO setting VALUES (NULL,50,'Show Custom Template 2?','showcustom2','0','Show your second customized template.','yesno','30');

You would change the two places you see the number 2 in that query to 3, then 4, and so on for more templates. You would also need to change the last number (30) to incriment by one for each template you add (that's the part that tells it what order the option should be displayed).


The variable $custom3 in the code above can be called whatever you would like and would be what you would place in your index template to display your new custom template. Then the part index_custom3 in the above code may be renamed to whatever you would like to call your new template. Also, if you would like to be able to use the $getbgrow variable in that template to alternate between your firstaltcolor & secondaltcolor, you should add the following above that code as it is with the others.

$getbgrow=getrowcolor();

Ok... I don't see where either of these queries would make a difference, but then again I don't see why it would be taking that one so long, so it's worth a shot, right? :)

Try this one:
And if that doesn't help maybe this one:

First one did it...

Page generated in 0.54202199 seconds

There's no link for discuss this poll but everything else works like a charm. :)

Alright! All I did was basically have it call to the thread table rather than the poll table first. Don't see why that made a difference, but hey it works now. ;)

To fix the discuss this poll link just change the first part of the query to "SELECT thread.pollid, thread.open, thread.threadid," adding the thread.thredid in there. It figures I'd forget one small part when changing it. :)

LOL

Thanks a million.. :)