vBadvanced Homepage

Official Support Forums
vBadvanced.com is now open! There you will find more information regarding vBadvanced Homepage, FAQ's, hacks & modifications, and more.


vBadvanced Homepage v1.1 Released! (01.27.04)

vBadvanced Homepage is an advanced homepage / portal that will allow you to include different options from your vBulletin message board on your site's homepage. It also allows you to easily create and manage new pages which are completely powered by vBulletin and vBadvanced. There are over 40 options where you can enable/disable the features, plus everything is 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.
• Create new pages in which the content will replace the news section of 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.
• 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, 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 3.0 RC.
• 100% validated XHTML 1.0 compliance
  

A nice feature of vBadvanced Homepage is that it is optimized and designed for large web sites. vBadvanced Homepage performs only 5 queries with all the options turned off. Some options will cause the script to perform extra queries, but even with all the options turned on it still performs only 17 queries at max.

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

• News - 1 query
• Latest Threads - 1 query
• Poll - 1 query (2 if the user has voted)
• User's Avatar - 1 query
• Buddy List and/or Online Users - 1 query
• Mini Calendar - 3 queries (none for the simple calendar)
• Stats - 2 queries
• New Posts - 1 query

Screen Shots:
Admin Homepage
Guest Homepage
Admin CP Options

Example Sites:
http://vbadvanced.com
http://plurplanet.com
http://digitalkore.net
http://differentdawn.com

Updates From v1.01 to v1.1

• News Archive where you can display links and info about older news posts.
• Online usere & buddylist now show "Username HTML Markup".
• Shows subscribed threads in news, news archive, and latest threads.
• Preivew on Latest threads and news archive (similar to the preview on forumdisplay).
• Option to display what forum(s) the latest threads were posted in.
• Poll icon in the latest threads section for threads which contain polls.
• New option to change the date/time format for news posts.
• Support for left/right text direction and languages.
• All known bugs from v1.01 have been fixed.

There are 7 new options in your Admin CP which include:

• News Date & Time Format (Allows you to change the date/time format for news posts)
• Show News Subscribed Threads (Shows the "subscribed" icon in the news posts if a user is subscribed to that post)
• Number of Archived News Posts to Display (Allows you to set the number of archived news posts you would like to display)
• Show Preview in Archive? (Similar to the thread preview, shows a preview of the threads in the News Arcive section)
• Show Subscribed Icon? (Shows the "subscribed" icon in the latest threads section for users that are subscribed to that thread)
• Show Preview of New Threads? (Similar to the thread preview option for the forumdisplay page, it shows you a preview of the thread)
• Show Latest Threads Forum? (Shows a link to, and the name of the forum the thread is in)

Most every template has changed as well, so it may be necessary to revert your templates and re-apply any chnages you have made.


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

Copyright:
This script is ? 2003 - 2004 vBadvanced.com and PlurPlanet, LLC.
This hack is NOT to be re-distributed in any way or placed on a website for download without permission.
All copyright notes in the script itself must remain unchanged.


Thanks To:
Faranth & Littlebit for helping test the beta versions and hopefully squashing most of the bugs.

[Zachery]

Originally Posted by Milhouse

As i stated, vb3 rc3 is a fresh install. No modyfications have been done to it. I simply downloaded the zip file from the first post in this thread. Followed all instructions. All went smooth, all linked fine as far as news, polls, etc.

If I am at the portal page and logged in, everything is linking fine to the forums. news, poll, pm's latest threads. However the bottom footer that has ADMIN/ MOD/ Archive all those link wrong.

If a gues comes they will have to register/login/forget pass, all those links are wrong as well as the footer.

I have not made any changes, and used the templates that come in the zip file.

if your using the default header / footer templates you shouldnt have too much if any problems

[Milhouse]

OK ignore het above problem. It seems i woudl have to edit the standard_errors template to reflect the correct url. So instead i changed the guests access to be ablve to view the board but need to register and that is fine. Here is one little problem,

The index_newsbits as a varable $newsicon , That $newsicon is linking to the wrong place so it displays a nice big RED X . It is pointing to /images/icons/... instead of /forums/images/icons/...

How would i go abotus of changing that variable to reflect the correct path.

[Zachery]

icon manager in the ACP not sure where it is off the top of my head

[Milhouse]

Originally Posted by Faranth

icon manager in the ACP not sure where it is off the top of my head

That won't do anything. it's the variable $newsicon in the index_newsbits template that is wrong. If i go to post icon manager and look at the icon it is linked fine there and it displays fine in the forum. But in the portal page it shows a nice big X

[RobAC]

Is it possible to add a random block function? For example, I want to add a random quote box to my vBadvanced home page that would add a random quote from a list of quotes in a text file in the block each time the user refreshes their browser. How can this be programmed?

[eger]

im gettin this error after install. followed all directions.

Database error in vBulletin 3.0.0 Release Candidate 3:

Invalid SQL: SELECT thread.threadid, thread.title, replycount, postusername, postuserid, thread.dateline, IF(views<=replycount, replycount+1, views) AS views, forumid, thread.iconid, votenum, votetotal, post.postid, pagetext, allowsmilie, showsignature
	  		, avatarpath, NOT ISNULL(avatardata) AS hascustom, customavatar.dateline AS avatardateline  
	  		,thread.iconid 
	  		 ,attachment.filename, filesize, attachment.visible, attachmentid, counter, thumbnail, LENGTH(thumbnail) AS thumbnailsize 
				FROM thread AS thread
				LEFT JOIN post AS post ON (post.postid = thread.firstpostid) 
				LEFT JOIN user AS user ON (user.userid = post.userid) 
				LEFT JOIN avatar as avatar ON (avatar.avatarid = user.avatarid)
				LEFT JOIN customavatar as customavatar ON (customavatar.userid = user.userid)  
				LEFT JOIN attachment AS attachment ON (post.postid = attachment.postid)
				WHERE forumid IN(2)
				GROUP BY post.postid
				ORDER BY dateline DESC, attachmentid LIMIT 5
mysql error: Column: 'filesize' in field list is ambiguous

mysql error number: 1052

Date: Friday 23rd of January 2004 01:23:03 PM
Script: http://test.test.test
Referer: 
Username: test
IP Address: 63.63.63.63

EDIT: i've determined this to be the New attachment option. when i turn it off, the page displays. BUT it only displays the very first thread from the news forumid and it only displays the Subject, not the text from the post. this is odd =\

[Zachery]

Originally Posted by eger

im gettin this error after install. followed all directions.

Database error in vBulletin 3.0.0 Release Candidate 3:
 
Invalid SQL: SELECT thread.threadid, thread.title, replycount, postusername, postuserid, thread.dateline, IF(views<=replycount, replycount+1, views) AS views, forumid, thread.iconid, votenum, votetotal, post.postid, pagetext, allowsmilie, showsignature
			 , avatarpath, NOT ISNULL(avatardata) AS hascustom, customavatar.dateline AS avatardateline 
			 ,thread.iconid 
			  ,attachment.filename, filesize, attachment.visible, attachmentid, counter, thumbnail, LENGTH(thumbnail) AS thumbnailsize 
				FROM thread AS thread
				LEFT JOIN post AS post ON (post.postid = thread.firstpostid) 
				LEFT JOIN user AS user ON (user.userid = post.userid) 
				LEFT JOIN avatar as avatar ON (avatar.avatarid = user.avatarid)
				LEFT JOIN customavatar as customavatar ON (customavatar.userid = user.userid) 
				LEFT JOIN attachment AS attachment ON (post.postid = attachment.postid)
				WHERE forumid IN(2)
				GROUP BY post.postid
				ORDER BY dateline DESC, attachmentid LIMIT 5
mysql error: Column: 'filesize' in field list is ambiguous
 
mysql error number: 1052
 
Date: Friday 23rd of January 2004 01:23:03 PM
Script: http://test.test.test
Referer: 
Username: test
IP Address: 63.63.63.63

EDIT: i've determined this to be the New attachment option. when i turn it off, the page displays. BUT it only displays the very first thread from the news forumid and it only displays the Subject, not the text from the post. this is odd =\

did you upgrade? with the correct upgrade script?

[tgmorris]

Change:

,attachment.filename, filesize, attachment.visible

To:

,attachment.filename, attachment.filesize, attachment.visible

[Milhouse]

Originally Posted by Faranth

did you upgrade? with the correct upgrade script?

Why not include the correct install file with the zip in he first post? Would avoid this.

[Darnell 0216]

Originally Posted by Milhouse

That won't do anything. it's the variable $newsicon in the index_newsbits template that is wrong. If i go to post icon manager and look at the icon it is linked fine there and it displays fine in the forum. But in the portal page it shows a nice big X

As someone mentioned either here or on vb.com, even though settings are automatically inputted, they don't always stick. In this case it is necessary to "Save" the instruction anyway even when it appears correctly. I've had to go to my smilies and click save on them anyway to make them work with the index page.