This is an excellent hack. Thank you very much not only for the hack, but for the clean install, the clean layout using templates, and the overall high quality of this.

Ran into a problem with this in 2.2.9. When I first set it up, my polls forum was empty. Not having any polls to display would cause the myvbindex.php to crash. If I turned off the showing of polls, or just created a poll in my polls forum, then the front page worked.

That's the extent of my ability to do custom things so I have a question for you: Could you possibly provide some code that would allow me to specifify only certain forums to use when considering the "latest threads" on the front page? I am of course trying to do this on my own but; since I can't actually code php I'm certain it will take me years to figure out. It would be nice to have in the vBulletin options, where the other myvbindex stuff is, to have a text field where I can just list the forum ID's with some delimeter in-between them that I would like to use on the front page; and it would then ignore all other forums for the front page new threads listing. I hope it doesn't hurt to ask this and if this is viewed as inappropriate to ask for, I apologize.

Thanks again for this extremely usefule and very high quality hack.

Ok, I asked about running large scripts and this is what they said:

"> REMOTE_HOST:
> HTTP_USER_AGENT: Mozilla/4.0 (compatible; MSIE 6.0; AOL 7.0; Windows NT
> 5.1; .NET CLR 1.0.3705)
>
>
Hi,

We do not have size-restricted limits.

Happy Holidays!

Please dont hesitate to contact me with any further questions you may have.

Regards,

John Dritsas"

DarkDraco - What mini-hack?

Jarvis - Glad it works for you too! The way it was written before, it would insert ?C or ?F in the database with the temperature. Now it just inserts the number, then later in the script it will see if it's supposed to be C or F. I guess some versions of mySQL don't like the ? symbol being in the database. ;)

Chris - Yea, I know about the problem when leaving a news or poll forum id blank. I added in a little more 'error checking' in v3.1 so that it will first make sure that field isn't blank before continuing with the database queries. That way the news or poll area will simply be blank rather than returning a nasty sql error. That should help cut down on the number of people having problems with fresh installs too since many go to check the page before setting all the options, and then think they have installed it wrong when they see the error.
As for the latest threads part... For now you can hard code it in the script what forum id's you would like it to check. You would just open mYvBindex.php and look for:
You would replace that with:
Then of course just change X, Y, and Z to the forum id's you would like it to check. I may add this as an option in a future version, but that should help you for now. :) Oh, also note that this will not do any kind of permission checking, so if you have a private forum id specified, all users will be able to see that topic. Of course they won't actually be able to read it, but they will see the title of the post on the homepage.

Tony - I'm not sure why the install script wouldn't work then. I'm sure there are many other possible reasons, just not sure exactly which one it would be. Didn't you already run the queries manually and get it working ok though?

Thanks for your response PlurPlanet. This hack is absolutely perfect for my needs. I just turned it on at http://www.sonsofvalor.com/

that mini hack :rambo:

Hmm, everything appears to be working, exept the index! I get a mysql error, here is the page: http://www.zeldaxtreme.com/extremegames/myvbindex.php The error reads:

Database error in vBulletin 2.2.9:

Invalid SQL: SELECT threadid,title,replycount,postusername,postuserid, dateline,views FROM thread WHERE open='1' AND open<>10 AND forumid=23 OR forumid=1 OR forumid=7 OR forumid=11 OR forumid=44 OR forumid=14 OR forumid=19 OR forumid=27 OR forumid=32 OR forumid=37 OR forumid=42 OR forumid=2 OR forumid=5 OR forumid=6 OR forumid=49 OR forumid=8 OR forumid=9 OR forumid=10 OR forumid=12 OR forumid=13 OR forumid=15 OR forumid=18 OR forumid=16 OR forumid=17 OR forumid=20 OR forumid=22 OR forumid=25 OR forumid=26 OR forumid=24 OR forumid=28 OR forumid=29 OR forumid=30 OR forumid=31 OR forumid=33 OR forumid=34 OR forumid=35 OR forumid=36 OR forumid=38 OR forumid=39 OR forumid=40 OR forumid=41 OR forumid=43 OR forumid=48 OR forumid=45 OR forumid=46 OR forumid=47 ORDER BY lastpost DESC LIMIT
mysql error: You have an error in your SQL syntax near '' at line 1

mysql error number: 1064

Date: Friday 03rd of January 2003 12:44:49 AM
Script: http://www.zeldaxtreme.com/extremega.../myvbindex.php
Referer:
------------------------------------------------------------------------------------
Number one, it sais http://www.zeldaxtreme.com/extremega...myvbindex.php, and its not that! it's really http://www.zeldaxtreme.com/extremega...myvbindex.php. Second, it's not their. The file myvbindex is not in that directory. Is that why, please help me! Thank you for your time!

DarkDraco07 - I'm not sure how hard that's going to be to do... I'll look into it when I get a chance.

Zalbard - It looks like you left your Latest Threads Maximum blank in your Admin CP. I guess I should add something to check for that too in v3.1. :)
As for it showing you the wrong path... What do you have your URL set to (3rd option under General Settings in the Admin CP)? You may want make sure that's set correctly as well as it could cause problems with links and such.

My URL to the forums are set too: http://www.zeldaxtreme.com/extremegames/forums

Is this problem fixable!?!

To answer your PM... Log into your Admin CP. Click on "vBulletin Options". Scroll to the bottom of that screen to your mYvBindex options. Set your Latest Threads Maximum to whatever number of latest threads you would like displayed on your homepage.

I disabled that, so now the error only reads:

Database error in vBulletin 2.2.9:

Invalid SQL: 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.forumid= ORDER BY thread.pollid DESC LIMIT 1
mysql error: You have an error in your SQL syntax near 'ORDER BY thread.pollid DESC LIMIT 1' at line 1

mysql error number: 1064

Date: Friday 03rd of January 2003 11:27:10 AM
Script: http://www.zeldaxtreme.com/extremega.../myvbindex.php
Referer:

How do I fix this error? It seems pretty odd that it works for everyone else, and just this one wont. I know it's fixable.