vBindex v3.0.0 RC5

[high]vBindex v3.0.0 RC5[/high]

I happy to announce the fith release of vBindex for vBulletin 3 here at vBulletin.org and also the first Offical vB3 Hack here . This is the 9th release of vBindex for vB3 and there are few known problems currently. This release works with vB 3.0.0 Gamma, vB 3.0.0 RC1, vB 3.0.0 RC2, vB 3.0.0 RC3, vB 3.0.0 RC4 and vB 3.0.0.

[high]Features[/high]

The following are the features that are presently avalible in vBindex, those marked [high]*NEW*[/high] have been updated since vBindex 2.1 and those marked [high]*NEW*[/high] have been updated since Pre-RC2 was released and those marked [high]*NEW*[/high] have been added since RC2 and those marked [high]*NEW*[/high] have been added since RC3.

• News:
  • News (taken from a specified news forum), with vBcode, Smilies and optional news posters avatar;
  • [high]*NEW*[/high] Improved avatar system for news posts;
  • [high]*NEW*[/high] Option to have sticky threads in the news forum sticky on vBindex;
  • [high]*NEW*[/high] Option to limit the number of characters in news posts;
• Side Blocks:
  • Easy Administration:
    • [high]*NEW*[/high] All side blocks can be moved from within the ACP, no template edits needed!;
    • [high]*NEW*[/high] Custom blocks, add unlimited custom side blocks and control them all from the ACP;
    • [high]*NEW*[/high] Support for right, left and dual side blocks;
    • [high]*NEW*[/high] Each side block can be expanded/contracted just like the forums, QRB, post rules etc on the forum;
      [high]*NEW*[/high] Dynamic side blocks via a special PHP Include type system (vbindex_customblock_php);
  • Latest Threads:
    • [high]*NEW*[/high] More functional and faster new threads and posts;
    • [high]*NEW*[/high] Link to first unread post if the user has not read the thread yet;
      [high]*NEW*[/high] Ability to have the latest threads under the news with more details;
  • [high]*NEW*[/high] Online user list, with buddies and invisible users marked:
    • [high]*NEW*[/high] Option to show users online in the past 24 hours;
    • [high]*NEW*[/high] Online users block can be switched off;
  • Integrated Welcome Panel:
    • [high]*NEW*[/high] Option for detault avatar in the Welcome Box for members without an avatar and Guests;
  • Fully integrated Shoutbox:
    • [high]*NEW*[/high] Scrolling shoutbox option;
    • [high]*NEW*[/high] Allow users to delete own shouts if option is turned on;
    • [high]*NEW*[/high] Select which usergroups can delete any users shouts;
    • [high]*NEW*[/high] View all shouts, a full page shoutbox built it;
    • [high]*NEW*[/high] Option to show disabled postshout area to unregistred users;
    • [high]*NEW*[/high] Order shouts in either direction;
      [high]*NEW*[/high] Limit the length of shouts;
  • Poll, with the option to select a random poll from a given set of forums;
  • [high]*NEW*[/high] Calendar:
    • [high]*NEW*[/high] Links to events;
    • [high]*NEW*[/high] Option to show weekends and dynmically adjust the side bars to the correct size;
  • [high]*NEW*[/high] Todays birthdays;
• Templates & Phrases:
  • [high]*NEW*[/high] Fully phrased, both the vBindex Options and the front end are 100% phrased;
  • [high]*NEW*[/high] 100% Valid XHTML 1.0 Templates.
  • [high]*NEW*[/high] Templates/Phrases installed during install/upgrade;
• General:
  • [high]*NEW*[/high] Thread subscription icons for news and latest threads;
  • [high]*NEW*[/high] Global and user specific ignore list throughout all items;
  • Will work 100% outside of your forums directory;
  • Fully integrated into the Admin CP, change all options there!
  • Very easy to customize, just edit/add templates;
  • Capable of operating a multi-paged site; (Extra Page Tutorial)
  • [high]*NEW*[/high] Dynamic PHP Driven Extra Pages via Templates; (Extra Dynamic Page Tutorial)
  • [high]*NEW*[/high] Optimised code;
  • [high]*NEW*[/high] Use date/time option (Today/Yesterday and Detailed) specified in vB Options;
  • Only 5 queries with everything switched off, and still only 13 with all options turned on, thats 5 queries less than our nearest competitor!
  • [high]*NEW*[/high] Improved install, easy onscreen instructions that even new hackers should be able to follow and have vBindex working quicky;
  • [high]*NEW*[/high] Compatible with vBwar for vB3 when its released.
  • [high]*NEW*[/high] Admin Help system, gives help with all the vBindex options in the ACP.
  • [high]*NEW*[/high] Uninstall/Re-Install System.

[high]Installation/Upgrade[/high]

See the README_1ST.htm file included in the zip for more detailed install instructions and details of where to upload the files. Then point your browser to http://www.mydomain.com/forums/admin/vbiupgrade.php.

Changes Since vBindex 3.0.0 RC4

vBindex 3.0.0 RC4 was released about a week ago, RC5 has just a few changes and is expected to be the last release before vBindex 3.0.0. Changes include fixing of an XHTML issue in the custom block templates; admin help system added; ability to restrict the length of shouts.

[high]Support[/high]

Support will be given here in this thread ONLY. [high]Support *WILL NOT* be given via PM/Email/IM.[/high]

[high]************************************************[/high]

vBindex is Copyright MMII - MMIV Winter Systems, you may not distribute in part or whole any portion of the source code (apart from in this thread) or any file included in the zip (Unless you are posting a language translation of vbindex_phrases.xml in this thread). Portions Copyright MM - MMIV Jelsoft Enterprises Limited. Both the Jelsoft vBulletin and the Winter Systems vBindex Copyright notice in the footer must stay in place for any page powered by vBindex.

[high]************************************************[/high]

[high]vBindex is *FREE*, please have the courtesy click install if you use this hack, thank you[/high]

RC3 Build 7: 719
RC3 Build 8: 377
RC3 Build 10: 486
RC4 Build 5: 107
RC5 Build 5: 87

[Mobo]

Oppsss, sorry about being a tard on the URLs...I should have caught that . I know I saw an email addy some were to send you a donation, I'd like to send one if I can find the addy again.

Also, one of my users asked if it was possible to have new PMs show up on the front page. Maybe some thing under where it show what subscribes threads have been updated. Like this...

Welcome Back mobo!

New & Updated Threads: 40 | New posts: 111
Updated Susbscribed Threads: 12
New Private Messages: 3
View New Posts | Today's Posts

Is that possible?

[NTLDR]

Just edit the VBINDEX template.

[Mobo]

I opened up that template and I think I figured out where to edit it, but I'm not sure what to put in there to make the new PMs show up. I'm way new at this code/hack stuff.

Thanks for your help.

[NTLDR]

The HTML/variables can be found in the navbar and global.php.

[Mobo]

So, is this the bit of coade that I need to insert?

PHP Code:

$pmunread_html = iif($bbuserinfo['pmunread'], "<strong>$bbuserinfo[pmunread]</strong>", $bbuserinfo['pmunread']);
$vbphrase['unread_x_nav_compiled'] = construct_phrase($vbphrase['unread_x_nav'], $pmunread_html);
$vbphrase['total_x_nav_compiled'] = construct_phrase($vbphrase['total_x_nav'], $bbuserinfo['pmtotal']); 


[Qualia]

Hi,

I'm helping CrankN while he's at work. I downloaded a fresh copy, removed and replaced all the files. I went to the admin cp, pasted http://www.ourdomain.net/folder/admincp/vbiupgrade.php and hit Enter. It started to load, "Processing complete...proceed" flashed at the top of the page, then the page went blank. The side menu of the admin cp shows but the main right side is plain white. It looks like a path problem to me. We don't have /forum/ and I'm wondering if the install is looking for that or not. If not, have you got any ideas what might be causing this and what I can do to complete it?

Thanks,
Janice

[Maikeru]

Is there anyway to make this appear when you go to http://www.lvlzero.uni.cc?

Also could I make the news go in decending order?

[Mobo]

Never mind on the PM thing. It's already show at the top of the page

My users have found a problem though. If you click on the "go to last post" icon, it brings up a Page can not be displayed error. It's been verified on diferent computers and networks.

Any thoughts?

[ImportPassion]

I am a little concerned about at least 2 of the queries.

In the GET NEWS query I see this...

PHP Code:

WHERE forumid IN ($vbindex[newsfid])
AND deletionlog.primaryid IS NULL
AND forumid NOT IN (".implode(',', $limitfids).") 


now, if you are already doing and IN clause, there is no need to do a NOT IN clause. It's more overhead for absolutely nothing.

Now in the GET LATEST THREADS there is a similar issue..

PHP Code:

WHERE open = '1'
AND thread.open <> 10
AND thread.forumid NOT IN (".iif(is_numeric($vbindex['newsfid']), "$vbindex[newsfid],").implode(',', $limitfids).") 


Here we see open=1 and open <> 10. You don't use both. You are already looking for 1, so <>10 will again be useless overhead.

For this NOT IN, I had more NOT IN id's than I would have IN id's, so I changed this to an IN statement and hardcoded my id's. I think only 5 instead of 30 or so I want to exclude. I think this could be made an option.

One last thing, I added indexes on dateline for post and thread and it made a significant increase in speed for my db with 100,000+ threads and over 1.5million posts.

Went from the vbIndex loading in 30s to about 3s with all these changes.

Your milage may vary, but I think it's worth a shot.

[Big Daddy]

When I try to enable news on my vbindex, it gives me this error:

-------------------------
Database error in vBulletin 3.0.1:

Invalid SQL:
## GET NEWS ##
SELECT thread.*,thread.iconid AS threadiconid, threadpost.pagetext AS pagetext,
threadpost.attach AS attachcount,


IF(user.displaygroupid = 0, user.usergroupid, user.displaygroupid) AS displaygroupid
FROM thread AS thread
LEFT JOIN user AS user ON (thread.postuserid = user.userid)
LEFT JOIN post AS threadpost ON (thread.firstpostid = threadpost.postid)
LEFT JOIN deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND type = 'thread')


WHERE forumid IN (http://www.my domain.com/forums/forumdisplay.php?t=15)
AND deletionlog.primaryid IS NULL
AND forumid NOT IN (0)
AND thread.open <> 10
AND thread.visible = '1'


ORDER BY thread.dateline DESC
LIMIT 4
mysql error: You have an error in your SQL syntax near '://www.my domain.com/forums/forumdisplay.php?t=15)
AND deletionlog.primar' at line 14

mysql error number: 1064
--------------------------------------------------------

What do I do??????
Thanks in advance for your help!!!