vb.org Archive - vBindex v2.1

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 2.x Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=4)

- - vBindex v2.1 (https://vborg.vbsupport.ru/showthread.php?t=41916)

Quote:

Originally posted by LightBringer
Hey NTLDR, any comments about the template names by chance?

For instance: TWT's hack requires shoutbox_error.
Your hack requires: home_shoutbox_error.

There's a few others like this and I've renamed the those within the the new vbindex.php to match accordingly. Is this correct?

I prefixed all the templates with home_ so that they can be modified to change the look of the shoutbox on the home page without effecting what you see when you are looking at the full page shoutbox that is part of TWT's hack. It doesn't really matter what the templates are called, as long as they match throughout, ie in $templatesused at the top, in the eval statements and in the CP.

Quote:

Originally posted by groovesalad
so, anyone know where I can get the 1.3 version? The link doesn't work.

You will need to contact el3m3nt the author of vBindex 1.3.

Quote:

Originally posted by TheSaint-AeD
Perhaps it'd be better to update the first Post and prune this thread to the important Posts.

The first post contains all the important information regarding this hack at present.

the relase canditate says a DB error :( i will wait the 2.1 :)

Quote:

Originally posted by Asso
the relase canditate says a DB error :( i will wait the 2.1 :)

Whats the DB Error you get? If its related to the shoutbox then you haven't installed the prerequisit. If not could you post the error here? Otherwise it will still be in 2.1. I'm having no errors with this currently.

First of all NTLDR I want to commend you for a great hack and all the support you have given to all the people like me asking for help...

First of all I was wondering how i can add in the right pane the last posts for some selected forums...

and secondly, I a user logs in and has a PM waiting the normal popup window will appear and if he tries to follow the popup box to read the message, and error appears. It is a cgi error. i think it is because the url it is linking to is wrong... here is my forum..

Smartphonesource

thanks for all your help

Quote:

Originally posted by jimmyjoe
First of all I was wondering how i can add in the right pane the last posts for some selected forums...

Change (in 2.0.1):

PHP Code:


		
			
if  ($action == "getnew") {

    // new posts

    $threadsquery = $DB_site->query("select threadid,forumid,title,postusername,lastposter,replycount,iconid from thread WHERE visible=1 AND thread.lastpost>=".$bbuserinfo[lastvisit]." AND thread.open<>10 ".$threadsql." order by lastpost desc limit $numthreads");

}

To:

PHP Code:


		
			
if  ($action == "getnew") {

    // new posts

    $threadsquery = $DB_site->query("select threadid,forumid,title,postusername,lastposter,replycount,iconid from thread WHERE visible=1 AND thread.lastpost>=".$bbuserinfo[lastvisit]." AND thread.open<>10 AND  forumid=X ".$threadsql." order by lastpost desc limit $numthreads");

}

Replace X with the forumid. To add more forums add AND forumid=X after the last one.

Quote:

and secondly, I a user logs in and has a PM waiting the normal popup window will appear and if he tries to follow the popup box to read the message, and error appears. It is a cgi error. i think it is because the url it is linking to is wrong... here is my forum..

Edit the head_newpm template and put $bburl before the (I think 2) instances of private.php that way they will be sent to the right URL ;)

Quote:

Originally posted by NTLDR

Whats the DB Error you get? If its related to the shoutbox then you haven't installed the prerequisit. If not could you post the error here? Otherwise it will still be in 2.1. I'm having no errors with this currently.

I'm getting a db error. Maybe it's the same one. Just installed the rc 1.3 on top of a 2.0.1u.

-paul

forgot the error:

Database error in vBulletin 2.2.8:

Invalid SQL: SELECT thread.*,threadpost.pagetext AS pagetext FROM thread LEFT JOIN post AS threadpost ON (thread.tpostid = threadpost.postid) WHERE forumid = '3' ORDER BY thread.dateline DESC LIMIT 5
mysql error: Unknown column 'thread.tpostid' in 'on clause'

mysql error number: 1054

Quote:

Originally posted by fluent
I'm getting a db error. Maybe it's the same one. Just installed the rc 1.3 on top of a 2.0.1u.

You haven't done the changes that are in this post: https://vborg.vbsupport.ru/showthrea...664#post305664 like it says to to in the install instructions in the first post. Make those changes and you won't get the DB error.

Quote:

Replace X with the forumid. To add more forums add AND forumid=X after the last one.

I replaced the php and changed the forumid to 7 and added another AND forumid=11 and i got a php error on that line... :(

what am i doing wrong??

what i was going for is 3 boxes like this

Latest in 6035 disscussions
thread
thread
thread
thread

new box

latest in 7135 discussions
thread
thread
thread
thread

new box

latest in general discussion
thread
thread
thread
thread

is that what you had in mind??? sorry if i am being dense i am not that good with php...

thanks for all your help....

Try changing:

PHP Code:


		
			
    // active topics

    $threadsquery = $DB_site->query("SELECT threadid,forumid,title,postusername,lastposter,replycount,iconid FROM thread WHERE forumid!=$newsforum AND forumid!=$pollsforum ".$threadsql." AND visible=1 order by lastpost desc limit $numthreads");

To:

PHP Code:


		
			
    // active topics

    $threadsquery = $DB_site->query("SELECT threadid,forumid,title,postusername,lastposter,replycount,iconid FROM thread WHERE forumid!=$newsforum AND forumid!=$pollsforum AND forumid=X AND visible=1 order by lastpost desc limit $numthreads");

Instead. Note this won't hide and private forums.

If you wanted the 3 latest threads boxes you will want you would need to replace all the latest threads code and add extra templates to sperate them all up.

I don't understand this. Am I supposed to change my vbindex.php to index.php? If so, what am I supposed to do with my original index.php that my other .php files point to?

NTLDR, in your admin options queries, you have 2 option ID's with the same id...
just letting you know. cheers.

Quote:

Database error in vBulletin 2.2.8:

Invalid SQL: SELECT thread.*,threadpost.pagetext AS pagetext FROM thread LEFT JOIN post AS threadpost ON (thread.tpostid = threadpost.postid) WHERE forumid = '29' ORDER BY thread.dateline DESC LIMIT 10
mysql error: Unknown column 'thread.tpostid' in 'on clause'

mysql error number: 1054

Date: Saturday 05th of October 2002 06:50:20 AM
Script: http://www.darkblazes.com/forums/
Referer: http://www.darkblazes.com/forums/index.php?

I get that when I try and access the vBindex...

Satan

I tried a fix, but now the post contents appear all wrong on the main page!!!

What is wrong?

Ive posted a screenshot below, and have reverted back a Version for now...

Satan

I found the changes that needed to be made...

Now I get no news on my main page!

Satan

Quote:

Originally posted by groovesalad
I don't understand this. Am I supposed to change my vbindex.php to index.php? If so, what am I supposed to do with my original index.php that my other .php files point to?

There is no need to change the filename unless you want to.

Quote:

Originally posted by hellsatan
I found the changes that needed to be made...

Now I get no news on my main page!

Satan

Satan, upload the attached script to your admin dir and and run it, this will add the postids of the first post in a thread to the thread table, this should fix the news issues with posts made prior to the upgrade :)

This will be integrated into the Update Counters bit in the final release ;)

Quote:

Originally posted by TECK
NTLDR, in your admin options queries, you have 2 option ID's with the same id...
just letting you know. cheers.

Thanks for letting me know TECK :)

Thanks NTLDR...

It sorted the problem out:)

Satan

I should read the entire post before posting this question, I'll be back :)

Quote:

Originally posted by NTLDR

There is no need to change the filename unless you want to.

So then how do most people implement this vbindex.php file as the starting page of their website? Mine obviously has to point to index.html, but how do I get vbindex.php to load up in its place? What do most people do?

change your htaccess file.
i wrote about this several pages back.

I wasn't able to find out how to add the Shoutbox to the vbindex.php page. I have the hack installed, but it only is showing up on my forums page as of now.

You have to edit one of the home sidebar templates (i suggest home_right), and add $homeshoutbox between one of the <tr> </tr> tags...

@groovesalad - Some people change the name of the file to index.php, and delete their index.htm/.html files...

Alternatively, you could make your index.htm/.html file redirect to the vBindex.php file...

Satan

When I deleted my index.html file and changed the bvindex.php to index.php, I got a 401 error. So I assumed that it didn't default to picking up the index.php because of the .php extension.

Also, how do I place a shoutbox on there? I have it installed normally on my forums page, but it says that it supports the shoutbox on the first post in this thread. I can't figure out how to get it to show up.

Quote:

Originally posted by hellsatan
You have to edit one of the home sidebar templates (i suggest home_right), and add $homeshoutbox between one of the <tr> </tr> tags...

Satan

Maybe I didn't install it correct becuase I dont have a home_shoutbox template under the VBindex Templates. Is this not correct?

You did...

This is because NTLDR did not include an Auto-Installer, meaning your home_shoutbox template would be a Custom Template, rather than a vBindex template;)

Satan

Oh, so I was supposed to make a custom template and call it home_shoutbox?

If so, where do I find the html code that goes in that template?

It should be in the Templates folder:)

Satan

Hmm, weird. I don't have that.

Oh...

Try Re-downloading the file;)

Satan

Quote:

Originally posted by groovesalad
Hmm, weird. I don't have that.

The shoutbox is only included in vBindex 2.1 RC1 and later releases, if you have installed 2.0.1 then you don't have the shoutbox code.

This hack uses still 35 queries if all options are turned on?!

Just curious.

Thanks,
Till

Man, I can't get vbindex 2.0.1 to install correctly and I definitely can't get 2.1 to install correctly. How do I uninstall everything and just start over?

Nice hack!

I've got the page up and running, but one problem? The only image that loads on my vbindex.php page is my avatar. All the others lare pointing to the wrong DIR.

Ive installed this vbindex.php file in my base DIR and the forums are in base folder/vbulletin .

Any ideas?

Thanks alot!
/DJ

P.S.
I could not find this in the admin/template.php:

PHP Code:


		
			
$only[\'showgroup\'] = \'Show Groups\';

So i could NOT replace it with

PHP Code:


		
			
$only[\'home\'] = \'vBindex\';

Is this the reason for my error??

I tried just adding the "$only[\'show...." but it messed things up.

Dunno
:tired:

First off, great hack :D

I'm running v2.1 RC1 with vBulletin 2.2.2 successfully for the past week but just noticed one problem today, the "Most users ever online" is getting overwritten from vbIndex somehow.

I've noticed some duplication between what's in my "Original vBulletin code" section and the "Users online today" section which may or may not be causing the problem. It could be because my original code is from v2.2.2 and maybe I should delete some or all of the maxloggedin code?

PHP Code:


		
			
// start vBulletin original code

// -------------------------

$activeusers = "";

$loggedinusers = "";

if ($displayloggedin) {

  $datecut=time()-$cookietimeout;



  $loggedins=$DB_site->query_first("SELECT COUNT(*) AS sessions FROM session WHERE userid=0 AND lastactivity>$datecut");

  $numberguest=$loggedins['sessions'];



  $numbervisible=0;

  $numberregistered=0;



  $loggedins=$DB_site->query("SELECT DISTINCT session.userid,username,invisible,usergroupid

                              FROM session

                              LEFT JOIN user ON (user.userid=session.userid)

                              WHERE session.userid>0 AND session.lastactivity>$datecut

                              ORDER BY invisible ASC, username ASC");

  if ($loggedin=$DB_site->fetch_array($loggedins)) {

    $numberregistered++;

    if ($loggedin['invisible']==0 or $bbuserinfo['usergroupid']==6) {

      $numbervisible++;

      $userid = $loggedin['userid'];

      if ($loggedin['invisible'] == 1) { // Invisible User but show to Admin

        $invisibleuser = '*';

      } else {

        $invisibleuser = '';

      }

      if ($loggedin['usergroupid'] == 6 and $highlightadmin) {

          $username = "<b><i>$loggedin[username]</i></b>";

      } else if (($mod["$userid"] or $loggedin['usergroupid'] == 5) and $highlightadmin) {

          $username = "<b>$loggedin[username]</b>";

      } else {

        $username = $loggedin['username'];

      }

      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>$loggedin[username]</i></b>";

      } else if (($mod["$userid"] or $loggedin['usergroupid'] == 5) and $highlightadmin) {

           $username = "<b>$loggedin[username]</b>";

      } else {

        $username = $loggedin['username'];

      }

      eval("\$activeusers .= \", ".gettemplate('forumhome_loggedinuser')."\";");

    }

  }

  $DB_site->free_result($loggedins);



  $totalonline=$numberregistered+$numberguest;

  $numberinvisible=$numberregistered-$numbervisible;



  $maxusers=explode(" ", gettemplate('maxloggedin',0,0));

  if ((int)$maxusers[0] <= $totalonline) {

    $time = time();

    $maxloggedin = "$totalonline " . $time;

    $DB_site->query("UPDATE template SET template='$maxloggedin' WHERE title='maxloggedin'");

    $maxusers[0] = $totalonline;

    $maxusers[1] = $time;

  }

  $recordusers = $maxusers[0];

  $recorddate = vbdate($dateformat,$maxusers[1]);

  $recordtime = vbdate($timeformat,$maxusers[1]);

  eval("\$loggedinusers = \"".gettemplate('forumhome_loggedinusers')."\";");

}

// -------------------------

// end vBulletin original code



// users online today by Mystics

// -------------------------

  if ((int)$maxusers[0] <= $totalonline) {

    $time = time();

    $maxloggedin = "$totalonline " . $time . " " . $maxusers[2] . " " . $maxusers[3];

    $DB_site->query("UPDATE template SET template='$maxloggedin' WHERE title='maxloggedin'");

    $maxusers[0] = $totalonline;

    $maxusers[1] = $time;

  }



  $todayloggedinusers = "";

  $numbertodayonline = 0;

  $numbertodayonlineinvisible = 0;



  $todayusers=$DB_site->query("SELECT userid, username, usergroupid, lastactivity, invisible FROM user

                WHERE lastactivity > " . mktime(0,0,0,date("m"),date("d"),date("Y")) . "

                ORDER BY username");

  while ($todayuser=$DB_site->fetch_array($todayusers)) {

    $numbertodayonline++;

    if ($todayuser['invisible']==1 and $bbuserinfo['usergroupid']!=6) {

      $numbertodayonlineinvisible++;

      continue;

    }

  }



  $DB_site->free_result($todayusers);



  if ($bbuserinfo[usergroupid] == 6) {

    $todayonline = $numbertodayonline;

  } else {

    $todayonline = $numbertodayonline - $numbertodayonlineinvisible;

  }

// -------------------------

// end users online today

As you can see the UPDATE query for maxloggedin is duplicated so I know something's definetly wrong here. I found a thread on vBulletin.com which seems to indicate the problem is with this hack.
So should I remove some or all of the maxloggedin code? From both sections or just the "original code" part?

Thanks and once again, great hack :classic:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.03101 seconds Memory Usage 1,907KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (7)bbcode_php_printable (16)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (2)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (40)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: