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 .

[NTLDR]

Originally posted by iblis
NTLDR: I used the code from the "welcome panel" to.. but my index.php is not in the /forum directory..

so the avatar image gets broken, pointing to www.domain.com/avatar.php ..

the correct url would be www.domain.com/forum/avatar.php ..

but I cant find the <a> to fix it

You need to change the follwoing:

PHP Code:

if ($bbuserinfo[userid]!=0) {
  $avatarurl=getavatarurl($bbuserinfo[userid]);
  if ($avatarurl=='') {
    $avatarurl='images/avatars/noavatar.gif';
  }
  $avatarimage='<a href="member.php?s='.$session[sessionhash].'&action=editavatar"><img src="'.$avatarurl.'" border="0">';
} else {
  $avatarimage='<a href="register.php?s='.$session[sessionhash].'&action=signup"><img src="images/avatars/guestavatar.gif" border="0"></a>';
} 


Change the paths for guestavatar.gif and noavatar.gif, also change the href's for member.php and register.php (you can use $bburl to point to your forums directory). You also need to change:

PHP Code:

  $avatarimage='<a href="member.php?s='.$session[sessionhash].'&action=editavatar"><img src="'.$avatarurl.'" border="0">'; 


To:

PHP Code:

  $avatarimage='<a href="$bburl/member.php?s='.$session[sessionhash].'&action=editavatar"><img src="forums-path'.$avatarurl.'" border="0">'; 


The last change should work but is untested.

[NTLDR]

Originally posted by Grower
Also there is an error on first few lines where templatesused string is filled (missing commas) which caused extra queries. Here is fixed code:

I would also highly recommend everybody does this for all templates that are used in there vBindex, I never got round to doing it properly and have gone through and made sure every template was added and it has saved me 12 queries on my vBindex page, thanks for reminding me to do this

[Sigon]

i tried the avatar fix and did not get anywhere with it.
www.mediaphorums.com
Any help?

[mbaskett]

NTLDR:

I've been having the same problems with most users ever online that has been posted about numerous times here. I've sifted through the code extensively, even commented out the Who's online today section of code. Still had the problem, Deleted the code, still had the problem.

I'm still looking into the cause, but the most ever users online works fine until somebody loads home.php, then it reverts the number to however many users are online at that time. :/

Any ideas? I *may have found the problem, or at least something that may lead us to the problem.

When examining the queries that occur just before the update of the template, in home.php I found a query:

Query: SELECT template FROM template WHERE title='maxloggedin' AND (templatesetid=-1 OR templatesetid='5') ORDER BY templatesetid DESC LIMIT 1

Then I looked at the db record for any and all entries in the template table. Found one matching title='maxloggedin' but its templatesetid is -2.

I thought this a bit odd, so I examined the queries around the same update query on the index.php (my forumshome page) and found no similar query.

Now I know that this query is being generated in the ./admin/functions.php file that is called from ./global.php, but I'm wondering why home.php is creating it in the first place, as index.php doesn't, besides the templatesetid's called for in the query don't match the actual id is shows in the db table.

I'm going to keep looking into this, but I'd appreciate any input/suggestions/help you could give, as this 'quirk' is starting to frustrate me....

Thanks,

[mbaskett]

Okay,

Good news... no, GREAT news... I was going along the lines of thinking in my last post... and edited the record in the templates table to make the 'maxloggedin' record have a templatesetid of -1

I did that edit and then waited on my board for the user count to go up, increase the max users online count, and then for the current number of users online to go below that. Once that happened, I loaded my home.php page, then went back to index.php and it's HOLDING the CORRECT count!!!!!

So, for those of you out there that are having this problem, before you delete the who's onlinetoday code, try this fix and post up if it solves it... It seems to work for me, and I'm going to add the whosonlinetoday code back in to see if it works again... will post results once that's done.

Edit
Have Mystics Whos Online Today hack re-installed and the count seems to be working. Will see how it holds up throughout the week. (we had problems with the onlinetoday count resetting every 24 hours, but I think the db record change will solve that as well.)

I don't know of any adverse effects of making this change. I don't *think* there will be any, but if anyone knows differently, please post up and let me/us know. If I find any, I'll be sure to let eveyone know as well.....

[JJR512]

The maxloggedin template should have a templatesetid of -2. I also don't know what difference it will make, but that's how it is by default.

I think the problem you all are having is because the index.php file in this hack is missing this:

PHP Code:

$loadbirthdays=1;
$loadmaxusers=1; 


This needs to be near the top of index.php, just under the $templatesused bits. You'll see it's in vBulletin's own index.php. I've made a similar hack to this one, only I've never released it, and had the same problem with the maxonline record getting reset to the current number whenever someone loaded my home page. Putting those lines in fixed it. It's only the loadmaxusers line that you really need to fix this problem, but you should probably have the loadbirthdays line, too.

[mbaskett]

Confirmed JJR512: that does work, and I like it much better.... plus it saved me a couple of queries!

[EA Junkie]

Hmm... I think I followed the instructions correctly, but when I load the new index page it's blank. Just a white screen? Any suggestions... Please...

Thanks in advance!

[grooveh]

I recently installed this hack and first and foremost, kudos for this meli-melo of hacks. I think you put them together excellently. This really adds a lot to my forum.

I have a couple of questions and am wondering if someone can point me in the right direction here.

1) On the news part, I'd love to be able to only display, say the 1st paragraph of a thread on the home page, with a read full>> button going to the thread with the full article. I've seen a few of the other hacks with something like this, but for the life of me, cant seem to be able to piece them together properly. Is there a simple way to do this, that I'm just missing???

The other thing is that I'm having a devil of a time trying to get some html to post properly when posted on the front page. eg: i put an img src to point to an image. Worked on the actual forum page, but on the front page, all it shows is the code, not the picture.

I would be very grateful to anyone that can help me. I've been beating my head against my desk for a while now trying to get something to work.

Cheers!

[countryboy713]

i seem to be having a slight problem with this. whenever i try to post news on the front page i get this MySQL error:

Database error in vBulletin 2.2.6:

Invalid SQL: INSERT INTO post (postid,threadid,title,username,userid,dateline,at tachmentid,pagetext,allowsmilie,showsignature,ipad dress,iconid,visible,topic) VALUES (NULL,'5','Site Open!','CoUnTrYbOy','2','1028104984','0','welcome' ,'1','0','IPADDRESS'')
mysql error: Unknown column 'topic' in 'field list'

mysql error number: 1054

Date: Wednesday 31st of July 2002 04:43:04 AM
Script: http://www.digitalkore.net/forums/forums/newthread.php
Referer: http://www.digitalkore.net/forums/ne...ead&forumid=45

i edited out the spot that had my IP and put in IPADDRESS in its place

if anyone can help i'd be extremely greatful.