vBindex

Latest Version: 1.3

This hack is not very special for me. I just wanted to create a mainpage on which you can see.. (as a member) everything what u like to see. The idea of the script is similar to the vbHome of nakkid and also a little bit to the vBPortal. I tested all of them.. but i was looking for something better . so i decided to write such a script myself...

Features:

• Active threads & newest posts
• News & Polls (read from a newsforum and a pollforum)
• Quick CP Links on the index-site
• Buddies on the index-site
• Very easy to customize. Just edit the templates!
• Available in english and german!

Summary: On this index-site you can see everything what you as a member would like to see .

Demo-Sites:

• http://partylife.ch [German Version]
• http://www.kampfkunst-info.de.vu [German Version]
• http://www.ukwinternet.co.uk/forum/home.php [English Version]

Screenshot 1: http://partylife.ch/misc/vbindex1.jpg // the original version and arrangement of the tables.
Screenshot 2: http://partylife.ch/misc/vbindex2.jpg // the nav on the right side.
Screenshot 3: http://partylife.ch/misc/vbindex3.jpg // or if u like 2 navs, left & right
Screenshot 4: http://partylife.ch/misc/vbindex4.jpg // another screen
Screenshot 5: http://partylife.ch/misc/vbindex5.jpg // buddies etc.


Installation
All instructions can you find in the readme.english/german.txt


Download
vBindex 1.3: http://partylife.ch/misc/vBindex1.3.zip
vBindex with Link-DB Script (Link-Script by The_Sisko; Integration of the Link-Script in vBindex by KarateKid): http://www.kampfkunst-board.de/sonst...tabasehack.rar


Credits
Newscode part from vBHome by nakkid.
Onlinetodaycode part from Online Today Hack by Mystics.
Pollcode part from vBPortal by wajones.


Note!
I'd really like to get every feedback you guys can give me. Also post bugreports and suggestions to improve this script. If you have installed this hack, pls click on the install button to receive updates thru email. Thank you .

[erdem]

no luck... still same colors..
also most user online stuff not working..

[NTLDR]

If you PM me the vbindex file I will take a look at the code you have.

[erdem]

also i cant make new messages table addon to vbindex..

why i want this? if u look into my forum, i am using it like file database,document database and so on..

i want to make additional 3 tables like latest files,documents and blabla

but noluck.. i create new template.. edit thread code but i didnt show anything.. any idea?

[NTLDR]

Hi,

I PM'ed you the update file, I hope it works, incase ayone else is wondering about this and has this hack installed here is the code:

PHP Code:

// Afterburners Colored OnlineUserHack Start
      if ($loggedin['usergroupid'] == 6 and $highlightadmin) {
          $username = "<b><i><font color=#ff0000>$loggedin[username]</font></i></b>"; // Color for Admin
      } else if (($loggedin['usergroupid'] == 5) and $highlightadmin) {
          $username = "<b><font color=#8b0000>$loggedin[username]</font></b>"; // Color for Supermod
      } else if (($mod["$userid"]) and $highlightadmin) {
          $username = "<b><font color=#008000>$loggedin[username]</font></b>"; // Color for Mod
      } else {
        $username = "<font color=#0000ff>$loggedin[username]</font>"; // Color for normal Member or "Highlight Admin" is turned of
      }
      eval("\$activeusers = \"".gettemplate('forumhome_loggedinuser')."\";");
    }

    while ($loggedin=$DB_site->fetch_array($loggedins)) {
      $numberregistered++;
      $invisibleuser = '';
      if ($loggedin['invisible']==1 and $bbuserinfo['usergroupid']!=6) {
        continue;
      }
      $numbervisible++;
      $userid=$loggedin['userid'];
      if ($loggedin['invisible'] == 1) { // Invisible User but show to Admin
        $invisibleuser = '*';
      }
      if ($loggedin['usergroupid'] == 6 and $highlightadmin) {
          $username = "<b><i><font color=#ff0000>$loggedin[username]</font></i></b>"; // Color for Admin
      } else if (($loggedin['usergroupid'] == 5) and $highlightadmin) {
          $username = "<b><font color=#8b0000>$loggedin[username]</font></b>"; // Color for Supermod
      } else if (($mod["$userid"]) and $highlightadmin) {
          $username = "<b><font color=#008000>$loggedin[username]</font></b>"; // Color for Mod
      } else {
        $username = "<font color=#0000ff>$loggedin[username]</font>"; // Color for normal Member or "Highlight Admin" is turned of
      }
// Afterburners Colored OnlineUserHack End 


Hopefull this will work

I am affraid I haven't installed the addons at the moment, but I may try in the future.

[erdem]

NTLDR tnx!

i fixed some more bugs in codes..
i think its because of my modified vbindex..

also i remove most user online update in code.. so its show only online users and not try to update muo thing..

tnx!

hmm i want to add more tables.. like newer msgs from some forums.. how to that? add new templates and codes..
like threads stuff right?

[NTLDR]

No problem, gald I could help you out.

To the latest threads from specific forums you need to change and add in again the news code, but this will add alot of extra queries to the page and I wouldn't recommend atting to much more.

As you alrady have 50 queries on that page I wouldn't add any more, I belive around 30 is the max that you want to have for any page!

[erdem]

hmm... anyway i will try and see what i have

[JoeHarrison]

el3m3nt,

In your English distribution, the home_threadbit template needs to be updated. I think you just missed translating one thing because it says 'Last Post 05-01-2002 05:05 PM
von Joe'. No biggie... just thought I'd metion it.

Thanks,
Joe

[FlyingDutchman]

Originally posted by neuron
guess it's becouse of database size or something...

I'll see if I can test a little to find out what it is.

Becouse that ONE query takes 12 seconds, if I take away that the rest goes in 0 sec's

// edit

It's the LEFT JOIN that does it, it's a major performance hit in mysql, I'll post more info if I can find a solution.

(adding indexes will probably speed it up to about 0sec per query )

//edit2

if you have a fairly new mysql server (connect to it and confirm that the query works) replace the LEFT JOIN with INNER JOIN, my results on a 1.4ghz tbird, big database:

INNER JOIN:
1 row in set (0.01 sec)
LEFT JOIN:
1 row in set (50.18 sec)

output is identical of course

Were you talking to me? I mean, i have no f*cking idea were you are talking about
My database should be ok, and the server has 2x 800 mhz PIII... the latest threads do show up, but the news and the poll just don't

I can't give you guys and URL, because it's in a private network...
I really need to get this hack to work

[NTLDR]

Originally posted by FlyingDutchman
I can't give you guys and URL, because it's in a private network...
I really need to get this hack to work

Put this into the address bar: http://urltoyourforums/vbindex.php?explain=1

Where: urltoyourforums is the URL to where the vbindex file is and vbindex.php is the vbindex file.

At the bottom of the page you will see something similar to:

Page generated in 0.22719204425812 seconds with 15 queries,
spending 0.039559841156006 doing MySQL queries and 0.18763220310211 doing PHP things.

Can you post those results here?