ok thnx for the hlp still a lil confused but... i dono i am going to try

I searched for this line in my myvbindex file but couldnt find it
ORDER BY thread.pollid DESC LIMIT 1

nevermind, those lines were in the include file not the myvbindex file. The random function is working perfectly picking from all forums. This is awsome. I just want to make sure it doenst pick from forums such as my moderator forums and what not. What do i need to inlclude in the code to make it not pick from certain forum ids?

also you never answered my question about that hack you showed me to do with opening the pages on the right side. Since they are in templates and also the way the meta tags are set up, can search engines search these for content? Do search engines search templates or no?

I put AND forumid!=XX before the Order by rand.....

and that didnt work. This random thing is useless if I cannot block those forums. Their has got to be a way to do this, but i have no clue. Hopefully you know the answer.

You were close... Try using WHERE forumid!=XX instead. ;)
By the way, that will work ok for you now, but once your board starts to get bigger you will start to run into problems... I thought about using that on my site which has 300,000+ posts, but it took my homepage 30+ seconds to load. I should be able to split the polls query up into 2 separate queries though that will do the job much more efficiently, so when I do I'll post the code here for you.
Oh, and search engines shouldn't have a problem spidering the pages you added in your templates.

Sorry I can't search all this Thread with 53 pages

My Question:

How can I add more then News Forum ID

Example: News Forum ID 64,48,21,9

Regards

Sulaiti - Open your myvbindex and find:
thread.forumid=$newsforum

Replace that with:
thread.forumid=XX OR thread.forumid=YY
(obviously replace the XX and YY there with your forumids)


arracing - Try replacing your polls query with the one here. I tried it on my site and it seemed to work perfectly.
$pollinfo=$DB_site->query_first("SELECT thread.pollid, thread.open, thread.threadid, thread.replycount, poll.pollid, poll.question, poll.dateline, poll.options, poll.votes, poll.active, poll.numberoptions, poll.timeout, poll.multiple, poll.voters FROM thread LEFT JOIN poll ON (thread.pollid=poll.pollid) WHERE thread.pollid!='0' AND thread.forumid!=XX ORDER BY RAND()");
And of course change the XX there to the fourmid you don't want it to pull polls from.

i am sometimes getting blank polls being displayed on the index. Can you check that out. Just keep refreshing and you will see what I mean. Thats with your latest code update. www.ar-racing.com

Hmmm... It looks like it's pulling threads that have been moved and that's where it's creating the problem. Try adding in this code:
AND thread.open='1' AND thread.open<>10

Right after this code in the poll query:
WHERE thread.pollid!='0'

That should fix it but if not let me know.