hey dont get me wrong!
may be sometimes u can miss little [better wash my mouth][better wash my mouth][better wash my mouth][better wash my mouth]s!

anyway...
:lick:

I wish you had a link to it so we could check it out, maybe it's just a simple fix.
The one thing I noticed that when I did this hack and created the new forums, news and polls, they don't show up unless there is a new post in them. Could it be as simple as that? Dunno?

Could you post a link, if not PM me and I will take a look. I pulled my hair trying to get this thing to work right and am pretty confident now that I know it in and out.


Mike

Thats correct Mike, if there isn't a poll as the Latest Thread then it will not show up at all.

Another thought is you do have $news in your home template?

any fix for the poll time yet?

I got a dual amd 1800MP proc on a oc3, server load 0.03 atm, running the poll query takes 12 seconds...

there HAS to be a better way of doing it ;)

Only takes 0.136secs to generate mine with 49 queries at the moment, thats on a dual 1GHz Itel Pentium III, server load around 0.60-0.70.

I've never had any problems with the load time, even when the page had 60 queries on it and was on an AMD K6-3 450, still didn't take that long.

I did post a news thread and a poll
of course i did

I just installed the hack, and set the variables and inserted the [better wash my mouth][better wash my mouth][better wash my mouth][better wash my mouth] from index.php to the new index.php. nothing more, because nothing more is needed... but just doesn't work

guess it's becouse of database size or something...

I'll see if I can test a little to find out what it is.

Becouse that ONE query takes 12 seconds, if I take away that the rest goes in 0 sec's :)

// edit

It's the LEFT JOIN that does it, it's a major performance hit in mysql, I'll post more info if I can find a solution.

(adding indexes will probably speed it up to about 0sec per query ;) )

//edit2

if you have a fairly new mysql server (connect to it and confirm that the query works) replace the LEFT JOIN with INNER JOIN, my results on a 1.4ghz tbird, big database:

INNER JOIN:
1 row in set (0.01 sec)
LEFT JOIN:
1 row in set (50.18 sec)

output is identical of course

:)

Try taking a look at the lastest version of vbPortal's code and see if the poll code has change there, I belive the code is pretty similar if not identical to that of vbPortal, so wajones may have changed the code since the realease od vBindex and it maybe more optimised now.

Do you have a URL or could you send me the file so I can take a look at it for you? I'm guessing that its something simple, cus it works fine for me and everyone else by the looks of it, we all make simple mistakes ;)

<a href="http://www.trojanforge.net/" target="_blank">http://www.trojanforge.net/</a> -> demo... i did what i said before..

new index.php is on root and forum index.php is in forum folder..