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.

[d3nnis]

so is vbadvanced ready for vb 3 gold?

[deathemperor]

I haven't changed anything of the installation steps, just do the 3rd step and reinstall the template and Vbadvanced is ready for Gold ^ ^

[hockyfan]

So installing this clean on Gold should work fine?

h

[a43079]

I installed VBA but i cant login via VBA would anyone be able to point me in the right direction i login and it accepts my name but it resets back as if i am a guest the rest of the board works fine..

[SnowBot]

aarrggg on a hacked board im having a problem

Database error in vBulletin 3.0.0:

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(27,28,29,30)
GROUP BY post.postid
ORDER BY dateline DESC, attachmentid LIMIT 5
mysql error: Column: 'filesize' in field list is ambiguous




Any help would be great.

It installs fine but as soon as i put the NEWS forum ID's in i get this error

[LeeCHeSSS]

Originally Posted by SnowBot

aarrggg on a hacked board im having a problem

Database error in vBulletin 3.0.0:

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(27,28,29,30)
GROUP BY post.postid
ORDER BY dateline DESC, attachmentid LIMIT 5
mysql error: Column: 'filesize' in field list is ambiguous




Any help would be great.

It installs fine but as soon as i put the NEWS forum ID's in i get this error

For all the other folks running Tigga's vBadvanced: change filesize to attachment.filesize

Or use a better portal...

[Tigga]

Originally Posted by LeeCHeSSS

For all the other folks running Tigga's vBadvanced: change filesize to attachment.filesize

Or use a better portal...

Or use the latest version, rather than an older one that was designed for vB3 Beta.

[SnowBot]

THANKS to LeeCHeSSS its all fixed

[SnowBot]

Originally Posted by Tigga

Or use the latest version, rather than an older one that was designed for vB3 Beta.

I used version 1.1

Is this not the latest?

[Tigga]

That couldn't be v1.1 if you were getting that error. That query was changed for v1.1 (IIRC) after vB3 Gamma was released and the filesize column was added to the customavatar table, and was no longer unique to the attachment table.