The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
|
|||||||
mYvBindex v3.1 Details »»
|
|||||||||||||||||||||||||
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:
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:
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. Show Your Support
|
|||||||||||||||||||||||||
About Developer
Visit Web Site
No support by the author.| Comments |
|
#1542
07-25-2003, 07:46 PM
|
||||
|
||||
im not sure if you did, if you copied the header from header and copied it into index_header
it would display your header :P and take that awful music off your page :\ if you dont want that white stripe, find Code:
<td valign="top" align="left" background="/forums/images/menu_background.gif"> Code:
<td valign="top" align="left" > that is on your index_header 
|
|
#1543
07-25-2003, 08:02 PM
|
|||
|
|||
|
white stripe is still their. If I remove the logo the stripe goes away. But once a logo is inserted, it creates that table with the white background it.
I tried what you guys said but nothing has helped yet. I put the code back to the way it was so that is what you are seeing now.
|
|
#1544
07-25-2003, 08:02 PM
|
||||
|
||||
|
If you'll add 'index_rotm' and 'index_buddy_none' to the templatesused section at the top of the file, that will remove 2 of the queries. Apparently 4 others are coming from your vBstats hack in your global.php file...
-------------------------------------------------------------------------------- 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.1263689994812 Time after: 0.12737095355988 -------------------------------------------------------------------------------- Query: update vbstats_countries set hits = hits+1 where code = 'us' Time before: 0.12776899337769 Time after: 0.12833797931671 -------------------------------------------------------------------------------- Query: Select date from vbstats_date WHERE date='2003-07-25' Time before: 0.12861597537994 Time after: 0.12964296340942 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.13033998012543 Time after: 0.13225495815277 -------------------------------------------------------------------------------- As for the polls, make sure that you have the poll templates and that you have "RAND" entered for the polls forum id. The threads from you private forums will only be visible to those who have permission to view them, assuming you have your forum permissions set correctly. 
|
|
#1546
07-25-2003, 08:12 PM
|
|||
|
|||
|
where is the templates used section? Is it in the global.php file also under start templates
$templatesused.='gobutton,timezone,username_logged out,username_loggedin,phpinclu de,headinclude,header,footer,forumjumpbit,forumjum p,nav_linkoff,nav_linkon,navba r,nav_joiner'; $templatesused.=',pagenav,pagenav_curpage,pagenav_ firstlink,pagenav_lastlink,pag enav_nextlink,pagenav_pagelink,pagenav_prevlink,mi crostats';
|
|
#1548
07-25-2003, 08:39 PM
|
|||
|
|||
|
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?
|
|
#1550
07-25-2003, 08:42 PM
|
|||
|
|||
|
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
|
|
#1551
07-25-2003, 08:44 PM
|
||||
|
||||
|
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
|
 |
«
Previous Thread
|
Next Thread
»
|
|
All times are GMT. The time now is 09:54 AM.