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 |
|
#1532
07-25-2003, 06:08 AM
|
|||
|
|||
Well I am willing to pay what a fair salary is for a web designer. This is if he wanted to be hired that is. Tigga email me about this, instead of replying here if you are interested.
|
|
#1533
07-25-2003, 06:11 AM
|
||||
|
||||
|
arracing - The query count does sound high since you don't have some of the more intensive options turned on. Once you have the templates re-installed though it should fix that.
Right now I'm working full time for a web design company, plus I also run a club/rave promotion company. I haven't had that much time to take on extra projects lately, but if you'd like to email me with some more details about the site, what you'd like done, and a timeframe of when/how fast the work needs to be done, then I can let you know if it's something I would be able to do and give you an estimate if so. 
|
|
#1536
07-25-2003, 03:41 PM
|
|||
|
|||
|
where is that white background coming from that is behind the main logo at the top left. I want it to be that baby blue color. I cannot find which template is calling that white background. Do u know?
Also I re-installed the templates but the query count still remained high.
|
|
#1537
07-25-2003, 04:12 PM
|
||||
|
||||
|
two ways to fix this, go to your templates find header. open it and copy it, then go to myvbindex > index_header i think and open that, and paste it in there, that should work
i belive the other is to change the gettemplate function at the top, instead of index_header, change it to header try the top one first however
|
|
#1538
07-25-2003, 05:19 PM
|
||||
|
||||
|
Arracing - You should modify your index_header template as Faranth suggested, but if you copy your normal header be sure to add $bburl in front of each of the links, otherwise they'll be broken.
 As far as the queries, if you'd like to put your server in debug mode (Add $debug=1; somewhere in your admin/config.php file), then go to the url http://yoursite.com/index.php?explain=1 If you'll do that and post the results here I'll see what is causing the extra queries.
|
|
#1540
07-25-2003, 07:15 PM
|
|||
|
|||
|
I did what you guys said with the headers and it didnt remove the white stripe. The stripe shows up in my forums header anyways, I just dont want it to show on myvbindex page.
Query: SELECT template FROM template WHERE title='options' Time before: 0.067090034484863 Time after: 0.069048047065735 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>1059162995 AND sessionhash='dc0592577954f6fe5d940af59f88d8c3' 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.081784009933472 Time after: 0.082612991333008 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.083825945854187 Time after: 0.085193991661072 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.087414979934692 Time after: 0.088251948356628 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 ('index','index_header','index_footer','headinclud e','index_welcometext','index_ logincode','index_buddy','index_buddylist','index_ buddypmlink','forumhome_logged inuser','index_online','index_search','index_welco metext_avatar','index_calendar ','index_calendar_todaysevents','index_weather','i ndex_custom1','index_custom2', 'index_stats','index_birthdaybits','index_threadbi t','index_newsbits','index_new s_adminopts','index_news_comments','index_news_com mentnull','index_news_readmore ','index_newsbits_rating','index_newsbits_signatur e','index_newsbits_avatar','in dex_newsbits_sendtofriend','index_newsbits_printab le','showthread_ratingdisplay' ,'index_pollresult','index_polloption_multiple','i ndex_polloption','index_pollop tions','index_pollresults_voted','index_pollresult s_closed','index_pollreview',' index_pollresults','index_polldiscuss','index_poll edit','','gobutton','timezone' ,'username_loggedout','username_loggedin','phpincl ude','headinclude','header','f ooter','forumjumpbit','forumjump','nav_linkoff','n av_linkon','navbar','nav_joine r','pagenav','pagenav_curpage','pagenav_firstlink' ,'pagenav_lastlink','pagenav_n extlink','pagenav_pagelink','pagenav_prevlink','mi crostats') AND (templatesetid=-1 OR templatesetid=1)) OR (title = 'maxloggedin') OR (title = 'birthdays') ORDER BY templatesetid Time before: 0.089380025863647 Time after: 0.10731399059296 table type possible_keys key key_len ref rows Extra template range title title 32 131 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.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 -------------------------------------------------------------------------------- Query: SELECT * FROM usergroup WHERE usergroupid=6 Time before: 0.13749396800995 Time after: 0.13856601715088 table type possible_keys key key_len ref rows Extra usergroup const PRIMARY PRIMARY 2 const 1 -------------------------------------------------------------------------------- Query: SELECT count(*) AS count FROM post WHERE dateline>='1059152592' Time before: 0.14228403568268 Time after: 0.35819399356842 table type possible_keys key key_len ref rows Extra post ALL 26582 Using where -------------------------------------------------------------------------------- Query: SELECT COUNT(*) AS messages FROM privatemessage WHERE userid='1' AND messageread='0' AND folderid='0' Time before: 0.35933005809784 Time after: 0.36073505878448 table type possible_keys key key_len ref rows Extra privatemessage ref userid userid 4 const 45 Using where -------------------------------------------------------------------------------- Query: SELECT userid,username,invisible,lastactivity,lastvisit FROM user WHERE (user.userid='143' OR user.userid='134' OR user.userid='160' OR user.userid='121' OR user.userid='118') AND lastactivity > 1059162995 AND lastvisit!=lastactivity ORDER BY username Time before: 0.36296999454498 Time after: 0.36397504806519 table type possible_keys key key_len ref rows Extra user range PRIMARY PRIMARY 4 5 Using where; Using filesort -------------------------------------------------------------------------------- Query: SELECT template FROM template WHERE title='index_buddy_none' AND (templatesetid=-1 OR templatesetid=1) ORDER BY templatesetid DESC LIMIT 1 Time before: 0.36498701572418 Time after: 0.36581897735596 table type possible_keys key key_len ref rows Extra template range title title 32 2 Using where -------------------------------------------------------------------------------- Query: SELECT COUNT(*) AS sessions FROM session WHERE userid=0 AND lastactivity>1059162995 Time before: 0.36761403083801 Time after: 0.36813902854919 table type possible_keys key key_len ref rows Extra session ALL 3 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>1059162995 ORDER BY invisible ASC, username ASC Time before: 0.36893403530121 Time after: 0.36982703208923 table type possible_keys key key_len ref rows Extra session ALL 3 Using where; Using temporary; Using filesort user eq_ref PRIMARY PRIMARY 4 session.userid 1 -------------------------------------------------------------------------------- Query: SELECT forumid,canview FROM forumpermission WHERE usergroupid='6' Time before: 0.37197494506836 Time after: 0.37254595756531 table type possible_keys key key_len ref rows Extra forumpermission ref ugid_fid ugid_fid 2 const 1 Using where -------------------------------------------------------------------------------- Query: SELECT forumid,parentid,displayorder FROM forum WHERE displayorder<>0 ORDER BY parentid,displayorder Time before: 0.37338399887085 Time after: 0.37498998641968 table type possible_keys key key_len ref rows Extra forum ALL 51 Using where; Using filesort -------------------------------------------------------------------------------- Query: SELECT thread.pollid, open, threadid, replycount, question, poll.dateline, options, votes, active, numberoptions, timeout, multiple, voters FROM thread LEFT JOIN poll ON (thread.pollid=poll.pollid) WHERE forumid='71' AND thread.pollid!='0' ORDER BY poll.pollid DESC LIMIT 1 Time before: 0.37878203392029 Time after: 0.38135600090027 table type possible_keys key key_len ref rows Extra thread ref forumid forumid 2 const 12 Using where; Using temporary; Using filesort poll eq_ref PRIMARY PRIMARY 4 thread.pollid 1 -------------------------------------------------------------------------------- Query: SELECT smilietext,smiliepath FROM smilie Time before: 0.38301599025726 Time after: 0.38529205322266 table type possible_keys key key_len ref rows Extra smilie ALL 193 -------------------------------------------------------------------------------- Query: SELECT pollvoteid FROM pollvote WHERE userid='1' AND pollid='92' Time before: 0.4006199836731 Time after: 0.40136098861694 table type possible_keys key key_len ref rows Extra pollvote ref userid userid 8 const,const 1 Using where -------------------------------------------------------------------------------- Query: SELECT threadid,thread.title,replycount,postusername,post userid,dateline,views,lastpost er,lastpost,thread.iconid as iconid,icon.title as icontitle,icon.iconpath as iconpath FROM thread LEFT JOIN icon ON icon.iconid=thread.iconid WHERE open<>10 ORDER BY lastpost DESC LIMIT 10 Time before: 0.43457794189453 Time after: 0.45274901390076 table type possible_keys key key_len ref rows Extra thread ALL 2639 Using where; Using filesort icon eq_ref PRIMARY PRIMARY 2 thread.iconid 1 -------------------------------------------------------------------------------- Query: SELECT thread.threadid,thread.title,replycount,postuserna me,postuserid,thread.dateline, views,thread.iconid,votenum,votetotal,postid,paget ext,allowsmilie,showsignature, signature ,thread.iconid as iconid,icon.title as icontitle,icon.iconpath as iconpath FROM thread LEFT JOIN post ON (thread.threadid=post.threadid) LEFT JOIN user ON (user.userid=post.userid) LEFT JOIN icon ON icon.iconid=thread.iconid WHERE forumid='66' AND isnews='Y' AND open<>10 GROUP BY thread.threadid ORDER BY thread.threadid DESC LIMIT 10 Time before: 0.46166598796844 Time after: 0.46672296524048 table type possible_keys key key_len ref rows Extra thread ref forumid forumid 2 const 8 Using where; Using temporary; Using filesort post ref threadid threadid 4 thread.threadid 11 Using where user eq_ref PRIMARY PRIMARY 4 post.userid 1 icon eq_ref PRIMARY PRIMARY 2 thread.iconid 1 -------------------------------------------------------------------------------- Query: SELECT bbcodetag,bbcodereplacement,twoparams FROM bbcode Time before: 0.48248398303986 Time after: 0.48327898979187 table type possible_keys key key_len ref rows Extra bbcode ALL 9 -------------------------------------------------------------------------------- Query: SELECT eventdate,subject,eventid,public FROM calendar_events WHERE eventdate LIKE '2003-07-%' AND ((userid='1' AND public='0') OR (public='1')) Time before: 0.76708197593689 Time after: 0.76792299747467 table type possible_keys key key_len ref rows Extra calendar_events ALL userid 12 Using where -------------------------------------------------------------------------------- Query: SELECT template FROM template WHERE title='index_rotm' AND (templatesetid=-1 OR templatesetid=1) ORDER BY templatesetid DESC LIMIT 1 Time before: 0.77690303325653 Time after: 0.77811396121979 table type possible_keys key key_len ref rows Extra template range title title 32 2 Using where -------------------------------------------------------------------------------- Query: SELECT findword, replaceword, replacementsetid FROM replacement WHERE replacementsetid IN(-1, '1') ORDER BY replacementsetid, replacementid DESC Time before: 0.79495394229889 Time after: 0.79683399200439 table type possible_keys key key_len ref rows Extra replacement ALL replacementsetid 56 Using where; Using filesort -------------------------------------------------------------------------------- Page generated in 0.78423702716827 seconds with 27 queries, spending 0.28480398654938 doing MySQL queries and 0.4994330406189 doing PHP things. Query: UPDATE session SET lastactivity=1059163895,location='/index.php?explain=1' WHERE sessionhash='dc0592577954f6fe5d940af59f88d8c3' Time before: 0.82737004756927 Time after: 0.8279869556427 -------------------------------------------------------------------------------- Query: UPDATE user SET lastactivity=1059163895,inforum='0' WHERE userid='1' Time before: 0.82818400859833 Time after: 0.82877898216248
|
|
#1541
07-25-2003, 07:18 PM
|
|||
|
|||
|
I also noticed that my poll is not picking random polls from the poll menu. And Also in my latest threads, they are taking threads from private forums.
|
 |
«
Previous Thread
|
Next Thread
»
|
|
All times are GMT. The time now is 03:48 PM.