mYvBindex v3.1

mYvBindex 3.2.2 released! (5/22/03)

mYvBindex 3.2 will allow you to include different options from your vBulletin message board on your website's index page. Everything is completely template based so it is very easy to customize and change everything through your Admin CP.

Features:

• Login box for members to log in to your site on the homepage.
• Post News in a forum you specify and have it appear on your homepage.
• Show the latest threads started in your forum on your homepage.
• Show a poll and allow users to vote and see the results on your homepage.
• Shows users avatar, new private messages, and buddy list for members who are logged in.
• Shows a list of active users.
• Shows statistics such as total members, threads, posts, top poster, newest member, and today's birthday's.
• Shows a mini calendar with links to days with scheduled events, and a box with today's scheduled events.
• Search box to allow users to quickly search your forums.
• Current weather and updates on your homepage.
• Set and change all options via the Admin CP.
• Ability to easily switch on/off the polls, users avatar, buddy list, online users, search box, calendar, weather, custom templates, news icons, news comments, smilies, set the maximum number of news posts, and many other options via the Admin CP.
• Everything is completely template based so it is very easy to customize.
• Install file that will make all database queries and templates for you in seconds.
• Uninstalls in seconds.
• Tested and stable with vBulletin v2.6+

Screen Shots:
Guest Homepage
Admin Homepage
User Homepage
Admin CP


Queries:
A nice feature of mYvBindex is that it performs only 11 queries with all the options turned off, no matter how many news articles or latest threads you choose to display. Some options will cause the script to perform extra queries, but even with all the options turned on it still performs only 29 queries at max.

Here is a list of each extra function that will cause extra queries:

• Poll - 2 queries
• User's Avatar - 1 query
• Private Messages - 1 query
• Buddy List - 1 query
• Online Users - 3 queries
• Mini Calendar - 1 query
• Weather - 2 queries
• Poll and/or News Smilies - 1 query
• Stats - 5 queries

*Mini Hacks:*
Adding More Custom Templates
To add more custom templates to your mYvBindex, please see this post.

Stylin' Buddy List - by MartynJ
This will add your the users avatar and usertitle to the buddy list (Similar to and inspired by velocd's Stylin' Buddy List hack), and adds no extra queries to your homepage.
Download (Screen shot included in zip)

Shoutbox Integration - by MartynJ
This hack integrates the ever popular Shoutbox hack with your mYvBindex.
Download (Screen shot included in zip)

TWCommish's vB Shoutbox Integration - by Brahm
This is a slightly different shout box made by TWCommish. His hack is required and can be found here. After downloading his hack, use Brahm's instructions here to integrate it with mYvBindex.

Attachments in News Posts - by Tigga
This hack allows attachments posted in news posts to be viewed in the news section on your homepage.
Download

Allow users to set homepage options - by Tigga
This mini-hack will allow your users to set which options they would like displayed on the homepage. They will be able to turn on/off avatars, weather, custom templates, and etc on a per user basis.
Download *Note* It may be necessary to open this file in a text editor (other than notepad) to get it to display properly.

Multiple News forums from different links - by Tigga
This hack allows allows you to have a link to a "different index file" which will pull news posts from a different forum.
Instructions can be found here


Credits:
mYvBindex uses modified versions of the following hacks:
Mini Calendar from vbPortal - by wajones
vB Weather Mk. 2- by JJR512


Copyright:
This hack is NOT to be re-distributed or placed on website for download without permission. All copyright notes in the script itself must remain unchanged.

Please don't forget to hit the Install Button


Updates from version 3.2.1
After the release of v3.2.1 a couple of small bugs were found. They affected the ability to edit a news post from the link on the homepage, pulling the wrong post from a thread for the news section, and updating your most users ever online if a new record is set. The changes from v3.2 to 3.2.1 were minimal, so those should be the only bugs found. Upgrading once again is very easy. Just download the new files, change the path in the myvbindex.php file, and upload it over your existing one.

Updates from version 3.2
v3.2.1 is again just a small maintenance release. The main change in this version is the way the forum permissions are done. Before, the forum permissions would cause the latest threads query to take much longer than it should (mostly on larger forums). Now with the new permissions system in place, the query to pull the latest threads should take less than 0.01 seconds. Other than the permissions section, the only other changes were a few optimizations to the code syntax. Upgrading from v3.2 is simple - Just upload the new myvbindex.php file over your existing one and you're done.

Updates from version 3.1
v3.2 is mostly another maintenance release, and will hopefully be the last release for vBulletin 2.X (unless any bugs are found). Here are a list of all the changes.
Fixed a bug where setting the "Show Latest Threads Icon?" option to "No" could disable the latest threads section.
Fixed a bug where signatures with vBcode were not displayed properly in the news section.
Fixed a bug where the icons in the news and latest thread parts weren't displaying the right icon for some users.
Added an option to completely disable signatures in news posts.
Added an option to select a random poll from any forum for the poll part of the hack.
Further optimized parts of the code and slightly changed part of the structure.
Now shows "No Buddies Online" in the buddy list if no buddies are online.
Changed so it will no longer show a default icon for the news and latest threads unless your options are also set to show a default icon on the forumdisplay page.
Now shows the last poster and last post time when you hold your mouse over the title of a thread in the Latest Threads part.
The install script has been re-written so you can install, upgrade, uninstall, update your news posts (useful for first time installations where a news forum already exists), or install just the templates (useful after upgrading vBulletin to a new version) all from one file.
Significantly reduced the size of the weather_install.php file (from 3.0 MB to 1.25 MB) so it will not take so long to upload to your server.
Fixed a couple of small spacing issues in the poll templates.
Fixed a problem with JJR512's weather hack not pulling the weather forcast.
Added a FAQ section to the readme file to help common problems.

Upgrading should take no longer than 2 minutes and instructions can be found at the bottom of the readme file.


Updates from version 3.0
v3.1 is mostly a maintenance release to help cut down on first time installation problems. Other than that, the biggest difference you will notice is the template "style" has changed to mesh better with vBulletin (see screenshots above). You do not have to install the new templates as you will have the option to install the new templates or to skip that step in the install file. Other than the templates, here is a list of the other changes:
A few more "error checking" features have been added to ensure you won't get a nasty sql error if you leave your News or Poll Forum ID, or any of the other fields blank.
The problem some users were experiencing with the temperature for the weather part of the hack should be fixed for good.
The "Show Poll" option in the Admin CP is removed as this can now be disabled simply by leaving the "Poll Fourm ID" filed blank.
Fixed a small typo and optimized parts of the code a little further.
Slightly changed the position of the days and numbers in the calendar part.
Fixes a bug where the Today's Birthday part wouldn't point to the correct url.

Upgrading should take no longer than 2 minutes and instructions can be found at the bottom of the readme file.


Updates from version 2.0
Removed the option from the Admin CP to allow smilies in News posts as this can now be set per post just as you would when making a regular post.
Added a stats section with info such as total members, threads, posts, newest member, top poster, and today's birthdays.
Added a "Today's Events" section under the calendar that will display any events that are scheduled for the current day, and will only be visible if there are events listed for the current day.
Added an option to show the poster's avatar with the news post.
You can now have your signature displayed with the news post. This is controlled when posting the message just as you would with a regular post.
Added an option to display the news post's rating with the news.
Added options to show small icons to allow users to show a printable version of the news post and an option to allow users to email their friends a link to the news post.
Added an option to allow/disable HTML in news posts.
Added an option to allow/disable the [img] tag in news posts.
Shows the number of times a news post has been viewed.
Shows the number of new posts since the users last visit.
Shows the number of replies to the poll if poll discussions are allowed.
Fixed a bug where the search box would take you to the search page rather than displaying the results.
Fixed a bug where setting the News Posts Maximum to 0 would disable the news rather than giving it no limit.
Optimized the code a little more to increase performance.


Help & Support
Before asking for support Please read the F.A.Q in the readme.html file! Most common problems are answered there! If you have any problems or questions that are not covered in the F.A.Q. please please post them here. I will be more than happy to help in any way I can if the request for help is made here. Anyone trying to contact me via email, private message, my website, or any other means will be ignored.

[Tigga]

Yes, that will add the option to turn the weather on/off. That part you need to edit in the file is actually the query that adds the option.
Do you mean the exact weather_install.php script I used, or the zip file with the manual queries?

[Tony DiMera]

The exact weather_install.php file that you used for your site. Thanks again for you help.

[Tigga]

Ok, well I tried to send the file but the email was returned saying it was too big. I'll just attach it here.

[Tigga]

Ok MartyJ, here's at least half of what you wanted.
To make it so that you can make a news post in any forum:

You will need to run these queries in phpMyAdmin before uploading your changed files:
ALTER TABLE post DROP `isnews`;

Then this query:
ALTER TABLE post ADD isnews char(1) NOT NULL DEFAULT 'N';

Note that after you run those queries no news posts will be visible on your myvbindex page. This is necessary since you are in a sense completely changing the way the news part works.


Create a new template called newthread_newsopt with the following content:

PHP Code:

<br><input type="checkbox" name="isnews" value="Y"> <b>Make News:</b> Make this post news? 


Then edit your newthread template and look for:

PHP Code:

<input type="checkbox" name="signature" value="yes" $signaturechecked> <b>Show Signature:</b> include your profile signature.  Only registered users may have signatures. 


Right Below that Add:

PHP Code:

$newsoption 


Edit your editpost template and find:

PHP Code:

<input type="checkbox" name="signature" $signaturechecked value="yes"> <b>Show Signature:</b> include your profile signature.  Only registered users may have signatures. 


Right Below that Add:

PHP Code:

$newsoption 


Open myvbindex.php and find:

PHP Code:

WHERE thread.forumid=$newsforum AND isnews='Y' GROUP BY thread.threadid ORDER BY thread.threadid DESC $newsmax"); 


Replace that with:

PHP Code:

WHERE isnews='Y' GROUP BY thread.threadid ORDER BY thread.threadid DESC $newsmax"); 


Then open your newthread.php file and look for:

PHP Code:

'$ipaddress','$iconid','1','Y')"); 


Replace that with:

PHP Code:

'$ipaddress','$iconid','1','$isnews')"); 


Still in newthread.php, find:

PHP Code:

  if ($permissions[canpostattachment] and (!$safeupload or function_exists("is_uploaded_file"))) {
    eval("\$attachmentoption = \"".gettemplate("newpost_attachment")."\";");
  } else {
    $attachmentoption="";
  } 


Above that Add:

PHP Code:

$newsoption = '';
if (in_array($bbuserinfo['usergroupid'], array(5, 6))){
eval("\$newsoption .= \"".gettemplate('newthread_newsopt')."\";");
} 


Open your editpost.php file and look for:

PHP Code:

  $editattachment = '';
  if ($postinfo[attachmentid]!=0 and (!$safeupload or function_exists("is_uploaded_file"))) {
    // show edit attachment options
    // keep, delete, new upload
    $attachmentinfo=$DB_site->query_first("SELECT filename FROM attachment WHERE attachmentid=$postinfo[attachmentid]");
    $postinfo[filename] = htmlspecialchars($attachmentinfo['filename']); 


Above that Add:

PHP Code:

  $newsoption = '';
if (in_array($bbuserinfo['usergroupid'], array(5, 6))){
eval("\$newsoption .= \"".gettemplate('newthread_newsopt')."\";");
} 


Still in editpost.php, find:

PHP Code:

  $DB_site->query("UPDATE post SET title='".addslashes(htmlspecialchars($title))."',pagetext='".addslashes($message)."',allowsmilie='$allowsmilie',showsignature='$signature',iconid='$iconid'$editedbysql$attachmentsql WHERE postid='$postid'"); 


Replace that with:

PHP Code:

  $DB_site->query("UPDATE post SET title='".addslashes(htmlspecialchars($title))."',pagetext='".addslashes($message)."',allowsmilie='$allowsmilie',showsignature='$signature',iconid='$iconid',isnews='$isnews'$editedbysql$attachmentsql WHERE postid='$postid'"); 


Upload the changed files and make sure you have ran the queries in phpMyAdmin. Now admins for your board will see an extra check box right under "Show Signature" with the option to make the thread news. If you don't want this option to be available to all admins let me know and I can tell you how to change who will see the option.

[Tigga]

jarvis - Here is how you would go about using multiple myvbindex's.

First make a copy of your myvbindex.php file and rename it to whatever you would like it to be called. In the copy, look for:

PHP Code:

WHERE thread.forumid=$pollsforum 


Replace that with:

PHP Code:

WHERE thread.forumid=$pollsforum2 


(Just adding a 2 at the end of $pollsforum)

Then look for:

PHP Code:

WHERE thread.forumid=$newsforum 


Replace that with:

PHP Code:

WHERE thread.forumid=$newsforum2 


(Again, just adding a 2 at the end)


Then you will want to run the following queries with phpMyAdmin:

INSERT INTO setting VALUES (NULL,50,'2nd News Forum ID','newsforum2','','The ID number of your news forum.','','31');

INSERT INTO setting VALUES (NULL,50,'2nd Polls Forum ID','pollsforum2','','The ID number of your polls forum.','','32');



That should be everything you need to do to use another myvbindex with different news and poll id's. The News & Poll ID settings will be at the bottom of your myvbindex options in the Admin CP.
Then to add additional copies, you would change the number in the file modifications each time to 3, then 4, and so on. In each of the queries you should run, I marked in bold the parts that will change with each new copy. The first part marked in bold has '2nd News Forum ID'. That can say whatever you would like to distinguish which part of the forum that is for. Then the '2' that is marked in bold should be changed to 3, then 4, and so on. Then the last numbers (31 for the news query, 32 for the poll query) is the part that orders the options. Those numbers should increment for every new option, so the next copy you add should have 33 at the end of the news query, and 34 at the end of the poll query.

Ok, that should be it. I tried to explain all that the best I could, so hopefully it makes sense. If you have any problems or don't understand part of it let me know.

[TECK]

Originally posted by PlurPlanet
mYvBindex 3.0 released!

Credits:
mYvBindex uses modified versions of the following hacks:
Mini Calendar from vbPortal - by wajones
vB Weather Mk. 2- by JJR512

PlurPlanet, you also use my XX Latest Threads and some code technique borrowed from vbHome (lite) script.
You had that added before, but you decided to remove it.

Also you should mention to your users that the way you have set the script, it will add at least one query for every new article you display.
So if you have for instance 15-20queries (due to few options enabled) and you display 15 articles posted, your total queries will be [high]30-35[/high]. I'm sure if you enable all your options, you could endup easy with 40-50 queries easy on the front page.
40-50 queries on a busy site will kill your server, so you should be careful with the options and let the users know about it.

[Tigga]

Originally posted by TECK PlurPlanet, you also use my XX Latest Threads and some code technique borrowed from vbHome (lite) script.
You had that added before, but you decided to remove it.

3.0 no longer uses your latest threads hack. Many parts of the coding were completely re-written.

Also you should mention to your users that the way you have set the script, it will add at least one query for every new article you display.

Um, no. The number of queries does not increase with the number of news posts. It will be the same whether you have 5 or 50.

So if you have your for instance 15-20queries (due to few options enabled) and you display 15 articles posted, your total queries will be [high]30-35[/high]. I'm sure if you enable all your options, you could endup easy with 40-50 queries easy on the front page.
40-50 queries on a busy site will kill your server, so you should be careful with the options and let the users know about it. [/B]

And no again. With every option turned on it will perform no more than 29 queries.

[Smoothie]

PlurPlanet-

Hi. I just checked your page, the first time it loaded there were 35 queries, the second time, 33. Yet you say max 29 queries with your script and all options enabled?

[Tigga]

Well if what Teck says is correct, then I would have to have more than one news post wouldn't I? My index page normally has 25 queries since I don't use all the options. If you'll look again, you'll notice a few things aren't working right now, and the reason it's displaying so many queries is because it's not caching the templates for some reason. I finally upgraded to 2.2.9 and I guess I did something wrong.

[Tigga]

Btw, if you look again it's running the way it should (20 queries as guest, 25 when logged in). When I ran the vB upgrade script I guess it deleted my templates, which would explain why nothing was working right.