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.

[Zachery]

what are you trying to take out?

[arracing]

I figured out the templates thing was in myvbindex.

As far as the polls random thing I am confused. I only want the polls picked at random from the polls forum only. Dont I have to change some code in the myvbindex file for this?

[Zachery]

no idea on my part, as far as i know its not a built in thing :\

[arracing]

Also here is the explain thing for my forums, can you show me how to get rid of some queries their?

Query: SELECT template FROM template WHERE title='options'
Time before: 0.07497501373291
Time after: 0.07695198059082

table type possible_keys key key_len ref rows Extra
template ref title title 30 const 1 Using where

--------------------------------------------------------------------------------

Query: SELECT sessionhash,userid,host,useragent,styleid FROM session WHERE lastactivity>1059168462 AND sessionhash='91adba9914cb16019f205696dda10b35' AND (host='68.41.47.235' OR (althash='' AND althash<>'')) AND useragent='Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1;'
Time before: 0.09148097038269
Time after: 0.092326998710632

table type possible_keys key key_len ref rows Extra
session const PRIMARY PRIMARY 32 const 1

--------------------------------------------------------------------------------

Query: SELECT user.*,userfield.* FROM user LEFT JOIN userfield ON userfield.userid=user.userid WHERE user.userid='1'
Time before: 0.093616008758545
Time after: 0.095041990280151

table type possible_keys key key_len ref rows Extra
user const PRIMARY PRIMARY 4 const 1
userfield const PRIMARY PRIMARY 4 const 1

--------------------------------------------------------------------------------

Query: SELECT templatesetid,replacementsetid,userselect FROM style WHERE styleid='1'
Time before: 0.097440004348755
Time after: 0.098170042037964

table type possible_keys key key_len ref rows Extra
style const PRIMARY PRIMARY 2 const 1

--------------------------------------------------------------------------------

Query: SELECT template,title
FROM template
WHERE (title IN ('forumhome_birthdaybit','error_nopermission','for umhome_pmloggedin','forumhome_ welcometext','forumhome_logoutcode','forumhome_new posts','forumhome_todayposts', 'forumhome_logincode','forumhome_loggedinuser','fo rumhome_loggedinusers','forumh ome_lastpostby','forumhome_moderator','forumhome_f orumbit_level1_nopost','forumh ome_forumbit_level1_post','forumhome_forumbit_leve l2_nopost','forumhome_forumbit _level2_post','forumhome','forumhome_unregmessage' ,'index_rotm','index_buddy_non e','gobutton','timezone','username_loggedout','use rname_loggedin','phpinclude',' headinclude','header','footer','forumjumpbit','for umjump','nav_linkoff','nav_lin kon','navbar','nav_joiner','pagenav','pagenav_curp age','pagenav_firstlink','page nav_lastlink','pagenav_nextlink','pagenav_pagelink ','pagenav_prevlink','microsta ts')
AND (templatesetid=-1 OR templatesetid=1))
OR (title = 'maxloggedin')
OR (title = 'birthdays')
ORDER BY templatesetid
Time before: 0.099313974380493
Time after: 0.11214196681976

table type possible_keys key key_len ref rows Extra
template range title title 32 87 Using where; Using filesort

--------------------------------------------------------------------------------

Query: update vbstats_counter set count=count+1 where (type='total' and var='hits') or (var='MSIE' and type='browser') or (var='Windows' and type='os')
Time before: 0.1307510137558
Time after: 0.13244700431824

--------------------------------------------------------------------------------

Query: update vbstats_countries set hits = hits+1 where code = 'us'
Time before: 0.13284802436829
Time after: 0.13345098495483

--------------------------------------------------------------------------------

Query: Select date from vbstats_date WHERE date='2003-07-25'
Time before: 0.13375794887543
Time after: 0.13481605052948

table type possible_keys key key_len ref rows Extra
vbstats_date ALL 248 Using where

--------------------------------------------------------------------------------

Query: UPDATE vbstats_date set count = count+1 where date = '2003-07-25'
Time before: 0.13570702075958
Time after: 0.13771498203278

--------------------------------------------------------------------------------

Query: SELECT * FROM usergroup WHERE usergroupid=6
Time before: 0.14379394054413
Time after: 0.14503705501556

table type possible_keys key key_len ref rows Extra
usergroup const PRIMARY PRIMARY 2 const 1

--------------------------------------------------------------------------------

Query: SELECT COUNT(*) AS messages FROM privatemessage WHERE userid=1
Time before: 0.14890003204346
Time after: 0.14967596530914

table type possible_keys key key_len ref rows Extra
privatemessage ref userid userid 4 const 45 Using where; Using index

--------------------------------------------------------------------------------

Query: SELECT COUNT(*) AS messages FROM privatemessage WHERE userid=1 AND dateline>1059165043 AND folderid=0
Time before: 0.15060794353485
Time after: 0.15190196037292

table type possible_keys key key_len ref rows Extra
privatemessage ref userid userid 4 const 45 Using where

--------------------------------------------------------------------------------

Query: SELECT COUNT(*) AS messages FROM privatemessage WHERE userid=1 AND messageread=0 AND folderid=0
Time before: 0.15289795398712
Time after: 0.15412402153015

table type possible_keys key key_len ref rows Extra
privatemessage ref userid userid 4 const 45 Using where

--------------------------------------------------------------------------------

Query: SELECT COUNT(*) AS users,MAX(userid) AS max FROM user
Time before: 0.15628504753113
Time after: 0.15683901309967

table type possible_keys key key_len ref rows Extra


--------------------------------------------------------------------------------

Query: SELECT COUNT(*) AS posts FROM post
Time before: 0.15768694877625
Time after: 0.15807497501373

table type possible_keys key key_len ref rows Extra


--------------------------------------------------------------------------------

Query: SELECT COUNT(*) AS threads FROM thread
Time before: 0.15872097015381
Time after: 0.15909194946289

table type possible_keys key key_len ref rows Extra


--------------------------------------------------------------------------------

Query: SELECT userid,username FROM user WHERE userid=390
Time before: 0.15973997116089
Time after: 0.16027796268463

table type possible_keys key key_len ref rows Extra
user const PRIMARY PRIMARY 4 const 1

--------------------------------------------------------------------------------

Query: SELECT * FROM forum WHERE displayorder<>0 AND active=1 ORDER BY parentid,displayorder
Time before: 0.16230797767639
Time after: 0.16545104980469

table type possible_keys key key_len ref rows Extra
forum ALL 51 Using where; Using filesort

--------------------------------------------------------------------------------

Query: SELECT forumid,canview,canpostnew FROM forumpermission WHERE usergroupid='6'
Time before: 0.17623496055603
Time after: 0.17706000804901

table type possible_keys key key_len ref rows Extra
forumpermission ref ugid_fid ugid_fid 2 const 1 Using where

--------------------------------------------------------------------------------

Query: SELECT forumid,accessmask FROM access WHERE userid='1'
Time before: 0.17811703681946
Time after: 0.17866396903992

table type possible_keys key key_len ref rows Extra
access ref userid userid 4 const 1 Using where

--------------------------------------------------------------------------------

Query: SELECT user.userid,user.username,moderator.forumid
FROM moderator
LEFT JOIN user
ON (moderator.userid=user.userid)
ORDER BY user.username
Time before: 0.17950904369354
Time after: 0.18144702911377

table type possible_keys key key_len ref rows Extra
moderator index userid 6 42 Using index; Using temporary; Using filesort
user eq_ref PRIMARY PRIMARY 4 moderator.userid 1

--------------------------------------------------------------------------------

Query: SELECT COUNT(*) AS sessions FROM session WHERE userid=0 AND lastactivity>1059168462
Time before: 0.18493902683258
Time after: 0.18557298183441

table type possible_keys key key_len ref rows Extra
session ALL 4 Using where

--------------------------------------------------------------------------------

Query: SELECT DISTINCT session.userid,username,invisible,usergroupid
FROM session
LEFT JOIN user ON (user.userid=session.userid)
WHERE session.userid>0 AND session.lastactivity>1059168462
ORDER BY invisible ASC, username ASC
Time before: 0.29781603813171
Time after: 0.29889500141144

table type possible_keys key key_len ref rows Extra
session ALL 4 Using where; Using temporary; Using filesort
user eq_ref PRIMARY PRIMARY 4 session.userid 1

--------------------------------------------------------------------------------

Query:
SELECT findword, replaceword, replacementsetid
FROM replacement
WHERE replacementsetid IN(-1, '1')
ORDER BY replacementsetid, replacementid DESC

Time before: 0.42030394077301
Time after: 0.42234098911285

table type possible_keys key key_len ref rows Extra
replacement ALL replacementsetid 56 Using where; Using filesort

--------------------------------------------------------------------------------

Page generated in 0.40744400024414 seconds with 24 queries,
spending 0.039765119552612 doing MySQL queries and 0.36767888069153 doing PHP things.
Query: UPDATE session SET lastactivity=1059169362,location='/forums/index.php?explain=1' WHERE sessionhash='91adba9914cb16019f205696dda10b35' Time before: 0.47847700119019 Time after: 0.47915899753571
--------------------------------------------------------------------------------
Query: UPDATE user SET lastactivity=1059169362,inforum='0' WHERE userid='1' Time before: 0.47937405109406 Time after: 0.48000800609589

[Zachery]

if you red the install it would tell you what options add querrys. and unless your server is under super high load, i wouldnt worry so much about your querie count

[arracing]

well, the thing is its not about added options. I think something is wrong cause the query counts seems to be significantly higher then before my upgrade. I had alot of hacks so I am unsure what is interfering with what. Just trying to clean up the mess a little.

[Zachery]

whats with that music, i dont think its making much of a difference
and i dont think its much to worry about, but that music is damn annoying :\

like i said i dont think its a big deal

[arracing]

It goes well with the concept of my forums. I like it.

[arracing]

why is it the random poll works say if you click one of the menu options. But on the main index it doenst work????

[arracing]

also how do i get that AR Racing image to size correctly with the rest of the index?

nevermind i got it.

[jbear6]

I saw this post https://vborg.vbsupport.ru/showthrea...671#post397671 on page 84 of this thread, and I have a similar question please.

Is it possible to get the "News" or the "Latest Threads" to display results from an entire Category, instead of only one forum (news), or all forums (latest threads)?

Thanks
Jbear6

[Zachery]

well doing the entire forum, every time a new topic was posted it would display on the front page, i think this might add alot of queries but im not sure

[deano1]

sorry
i didn't read all 104 pages of this thread

but i just upgraded to VB3 beta 4
and it killed my myvbindex portal

is ther a way to make it work with VB 3 ??

thank you

[jbear6]

Today at 07:29 PM Faranth said this in Post #1557
well doing the entire forum, every time a new topic was posted it would display on the front page, i think this might add alot of queries but im not sure

I might not have been clear on exactly what I meant. Instead of pulling "Latest Threads" from every forum on a vb, I was wondering if I could pull the "Latest Threads' from only one Category of a vb.

I have three main categories, each with sub categories, and postable forums under the sub categories. I would like to pull the Latest Threads from the postable forums located under one Category only, not the whole board.

Thanks,
Jbear6

[Zachery]

Yesterday at 10:38 PM deano1 said this in Post #1558
sorry
i didn't read all 104 pages of this thread

but i just upgraded to VB3 beta 4
and it killed my myvbindex portal

is ther a way to make it work with VB 3 ??

thank you

note at this time