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 .

[iblis]

Originally posted by danielhollands
Hi all, i've just installed this hack here (soon to be here), and so far it's looking really good.

What I want to do, once i've moved the forum to GameVine.co.uk is use this file in the root directory rather than the forum dir, what would I need to change in order for this to be possable?

Cheers (sorry if this quistion has already been asked, but over 300 posts is a bit too much to track though)

just add:

chdir("/home/yoursite/forum");

above "require('./global.php');" in vbindex index.php file..

then add "/forum" on all the url's in the vbindex templates

ps: sorry for my bad english..

[Ninth Dimension]

Hi, thank you for this, it works fantasticly (i just put in chdir("./forum"); rather than the whole path)

I do have another problem, voting on the poll does not work, I get the following error message:

The action you have attempted could not be performed as your session appears to be invalid. Click the below link to attempt this action again with a new session.

(Yet again, i'm sorry if this question has been answered, but like i said before, 300 posts in a little too much to read though)

Cheers again.

[NTLDR]

Originally posted by danielhollands
I do have another problem, voting on the poll does not work, I get the following error messageYet again, i'm sorry if this question has been answered, but like i said before, 300 posts in a little too much to read though)

Indeed this has been fixed somewhere in this thread, I'm going to contact el3m3nt and see if I can release a new version with all the bug fixes and maybe somemore features soon.

From memory you should have this line in the home_poll template:

<input type="hidden" name="s" value="$session[sessionhash]">

Which needs to be changed to:

<input type="hidden" name="s" value="$session[dbsessionhash]">

To be able to vote correctly.

[NTLDR]

Originally posted by iblis
btw NTLDR, you know of a easy way to add the avatar on the user on the index page?

The way I have done this is to use the welcome panel hack that is avalible for your forums and applied it to the front page, take a look at mysite for an example. Is that the kind of thing you wanted?

[Ninth Dimension]

Thank you for the advice, i'll be looking foward to any new releases of this hack

[NTLDR]

No problem

I've contacted el3m3nt regarding a new (or updated) realease of this hack and am wating to hear back from him.

[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

[Ninth Dimension]

I found the only way to solve this problem was to edit the {imagesfolder} patch in the replacements section of the admin.

Try that

[iblis]

huh? /vbimages?

[Grower]

I highly recommend everybody using this hack to install also "Thread Preview Hack". Some level of data redundancy is the only way to go with this kind of hack. Then you can remove extra queries in loop (putting query into a loop is always the worst solution and should be avoided).

For those who have installed this hack and have also "firstpostid" column in thread table here is code you can use for pulling news:

// news by nakkid (modified)
// -------------------------
$newsquery=$DB_site->query("SELECT thread.threadid,thread.title,thread.dateline,thread.postusername,thread.postuserid,
thread.replycount,thread.iconid,post.pagetext,icon.title AS icontitle,icon.iconpath
FROM thread
LEFT JOIN post ON thread.firstpostid = post.postid
LEFT JOIN icon ON icon.iconid = post.iconid
WHERE forumid='$newsforum' ORDER BY thread.dateline DESC LIMIT $newsposts");
while ($news=$DB_site->fetch_array($newsquery)) {
  $newsthreadid=$news[threadid];
  $newstitle=$news[title];
  $newstime=vbdate($timeformat,$news[dateline]);
  $newsdate=vbdate($dateformat,$news[dateline]);
  $newsusername=$news[postusername];
  $newsuserid=$news[postuserid];
  $comments=$news[replycount];

  $newstext=bbcodeparse($news[pagetext],$newsforum,1);
  $newstext=str_replace("<br />","",$newstext);

  if ($news[iconid]=='0') {
	$news[icontitle]="";
	$news[iconpath]="https://vborg.vbsupport.ru/images/icons/icon.gif";
  }

  eval("\$newsbits .= \"".gettemplate('home_newsbit')."\";");
}

eval("\$news = \"".gettemplate('home_news')."\";");

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

$templatesused='error_nopermission,home,home_buddy1,home_buddy2,home_footer,home_header,home_headinclude,home_left';
$templatesused.=',home_login,home_logout,home_news,home_newsbit,home_nothreads,home_poll,home_pollresult,home_right';
$templatesused.=',home_threadbit,home_threads,forumhome_loggedinuser,forumhome_loggedinusers,maxloggedin';

This thread is so long that I hope I'm not reposting something already fixed

[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.....