vBindex v2.1

[TECK]

no.

[glo]

what is the difference between vBindex v2 and vBhome (lite) 3.0???

I am looking for the most suitable hack that will allow me to do the following:

1. place the login/password feature on the home (non vB) page.
2. place polls on non vB pages.
3. calculate the users online on the entire site, not just the vB forum pages.
4. have some member only pages (non vB), protected by the username and password access from vB!

I am using vB 2.2.7. (brand new forum!)

I guess this is directed to NTLDR & TECK but anyone can assist!

[otacon]

<a href="http://www.fusionart.org/forum/vbindex.php" target="_blank">www.fusionart.org/forum/vbindex.php</a>

is there a way i can make the font not so small in the news posts

[TECK]

Originally posted by glo
what is the difference between vBindex v2 and vBhome (lite) 3.0???

I am looking for the most suitable hack that will allow me to do the following:

1. place the login/password feature on the home (non vB) page.
2. place polls on non vB pages.
3. calculate the users online on the entire site, not just the vB forum pages.
4. have some member only pages (non vB), protected by the username and password access from vB!

I am using vB 2.2.7. (brand new forum!)

I guess this is directed to NTLDR & TECK but anyone can assist! vbIndex was "inspired" from my original vbHome 1.0, when element ripped my code, wajones's poll and other's and stick it togheter...
then NTLDR released a different version and credited a part of the code element stolled from me as:
"code by nakkid" (my previous nick at vb.org)

the diff between vbIndex and vbHome (lite) is the number of queries and the code stability. the queries are in a loop. so vbIndex could easily "boost" your page at 150queries if you go at ease with the options. that equals death to the server.
even set at default, with minimum options, if i understood corectly from NTLDR, there are still 47queries loaded, wich is huge for a simple page... the server could easily crash on a busy site with this number of queries.

vbHome (lite) 3 performs only 13queries (14 as loggedin) and also is optimised for extremly fast page loads (average 0.09seconds).
this was tested on 2 servers.
NTLDR can give you more precise info about it's code performance, since he code it. i posted my specs here just to have a better idea.

cheers.

[MiF]

Couple of problems I found:

1. I don't know if it's a problem with vbhacker generating the text file of changes or the hack is incorrect.

+-------------------------------------------------------------------------------------------------+
| In admin/template.php, replace this code: |
+-------------------------------------------------------------------------------------------------+
$only[\'showgroup\'] = \'Show Groups\';
+-------------------------------------------------------------------------------------------------+

+-------------------------------------------------------------------------------------------------+
| With this code: |
+-------------------------------------------------------------------------------------------------+
$only[\'home\'] = \'vBindex\';
+-------------------------------------------------------------------------------------------------+


Shouldn't this line be inserted after the code found instead of replaced?

+-------------------------------------------------------------------------------------------------+
| In admin/usergroup.php, replace this code: |
+-------------------------------------------------------------------------------------------------+
makeyesnocode("Can view board","canview",1);
+-------------------------------------------------------------------------------------------------+

+-------------------------------------------------------------------------------------------------+
| With this code: |
+-------------------------------------------------------------------------------------------------+
// vBindex Edit
makeyesnocode("Can view vBindex?","canviewvbindex,1");
// vBindex Edit
+-------------------------------------------------------------------------------------------------+

Same as above question plus the replacement text is bad. "canviewvbindex,1" should be "canviewvbindex",1

2. The poll query takes extreme amount of time to complete. I think it's not constructed properly but maybe it's a bug in my version of MySQL.

This code:

$pollinfo=$DB_site->query_first("SELECT *,thread.open FROM poll LEFT JOIN thread ON (thread.pollid = poll.pollid) WHERE thread.forumid='$pollsforum' ORDER BY poll.dateline DESC LIMIT 1");


Should be:

$pollinfo=$DB_site->query_first("SELECT poll.*,thread.open FROM thread LEFT JOIN poll ON (thread.pollid=poll.pollid) WHERE thread.forumid='$pollsforum' ORDER BY poll.dateline DESC LIMIT 1");


And of course code appropriately changed to reflect query change.

[MiF]

Found another problem. When installing the templates using vbitemplate_install or vbi_install, the PHP variables in some templates are replaced during the insertion. They are not escaped properly.

[glo]

Originally posted by glo
what is the difference between vBindex v2 and vBhome (lite) 3.0???

I am looking for the most suitable hack that will allow me to do the following:

1. place the login/password feature on the home (non vB) page.
2. place polls on non vB pages.
3. calculate the users online on the entire site, not just the vB forum pages.
4. have some member only pages (non vB), protected by the username and password access from vB!

I am using vB 2.2.7. (brand new forum!)

I guess this is directed to NTLDR & TECK but anyone can assist!

NTLDR, your thoughts please.

[NTLDR]

Originally posted by TECK
if i understood corectly from NTLDR, there are still 47queries loaded, wich is huge for a simple page... the server could easily crash on a busy site with this number of queries.

That number is about right if you have everything switched on and enabled, but of course varies on how many news/latest posts you have. I will be trying my own methods of getting the queries out of the loop for the next version ;) Lets hope I can do as good a job as TECK managed to do.

[NTLDR]

Originally posted by MiF
Found another problem. When installing the templates using vbitemplate_install or vbi_install, the PHP variables in some templates are replaced during the insertion. They are not escaped properly.

The installer has been re-done for the next version, thanks for pointing out what the problem is with it ;) You are correct with the problems with the vBhacker file, there seem to be problems with vBhacker now :ermm:

[NTLDR]

Originally posted by glo
1. place the login/password feature on the home (non vB) page.
Both vBindex and vBhome can do this, this is default with vBindex.
2. place polls on non vB pages.
Again avalible for both, as default for vBindex there is a tutorial for vBhome.
3. calculate the users online on the entire site, not just the vB forum pages.
vBindex displays the users online by default. Users on pages by both hacks will be counted as the number of members online.
4. have some member only pages (non vB), protected by the username and password access from vB!
By deault you have the option of choosing which user groups can access the vBindex page, its also easy with both hacks to restrict to specific groups/userids. vBindex also has a multi-page option by default.
I am using vB 2.2.7. (brand new forum!)
Both hacks should work fine with 2.2.7

To mention again what TECK said, the origional version of vBindex by el3m3nt was based on vBhome but was a more "compleate" option as it didn't require people to have to add code for other stuff into the page. vBhome was made in my understanding for users to modify more heavily to meet there specific needs, thats my understanding at least. After e3l3m3nt stoped providing major support to the hack I started to re-code parts of it and release a new version with his permission.

[TECK]

NTLDR, the login/logout is default also on vbHome (lite) 3. :)
and yes, you are correct. vbHL, is designed for the average coder who wants to create his own custom page that uses several functions in VB and also to be a news(information) page.

[otacon]

hay guys i rely need to make the font bigger it is way to small for my users alot of them want me to change it. if there is eny way to do this plz tell me

->vbindex page www.fusionart.org/forum/vbindex.php

[NTLDR]

You can replace the font tags within the home templates, eg change <smallfont> to <normalfont> or <font size="x"> for example.

[Buddha]

ntldr, how can i break up the news items?
i tried adding a <br> in the template in various places, but that just didn't work.
???

[TECK]

he probably uses a string replace, to kill all the <br>, just in case you use html. just comment that line.

[Buddha]

you talking about this one teck?
//$newstext=str_replace("<br />","",$newstext);

if so, it is commented.
??
any thoughts?

[NTLDR]

Try adding a blank cell at the end of the news item as its in a table:

<tr><td></td></tr>

[Buddha]

thanks.

(btw, truly loving this hack... setting up other pages using it for the whole site. )

[Neo]

OMG!!!! Its BUDDHA!!!!

[Buddha]

???

do i know you?

[Buddha]

btw, for those interested in breaking up the news items, it's not quite as easy as simply inserting a <br> or a table as listed above. you can add the table tags at the end of the home_newsbit template, but then you end up with a border around it.
if you don't mind that, then no problem... but if you'd rather not have that border, you have to go into the home_news template and remove the table that includes the cellpading and cell spacing. then paste that into the home_newsbit surrounding the whole thing. then add a new <table> tag that does not have a border, at the very end.

i can post my news and newsbit for those that are actually interested. not much to do, but for us that are just getting used to templates and such, it might be handy.

[-=dm=-]

NTLDR does this work with 2.2.4?

looks great man :)

[NTLDR]

Originally posted by -=dm=-
NTLDR does this work with 2.2.4?

looks great man :)

Yes it will Indeed ;)

It has been tested on 2.2.4, 2.2.6 and 2.2.7 but should work on all 2.2.x :)

[-=dm=-]

cool thanx :)

is it possible to move the "latest thread" in the center instead of havin em in the right block? (like the old design)

laterz

[NTLDR]

Just use the v1.3 home_thread and home_threadbit templates and move $threads in the home template, it will then look like it did in 1.3 :)

[-=dm=-]

Thanx NTLDR :)
I also coiped my old home_template over to the new one and it seem to work perfect :)

[clangrounds.com]

Hey I tried to upgrade my vbindex from 2.2.6 to 2.2.7 and it messed up last time. I ended up having my host company reinstall the backup I made before I tried to upgrade. Thank goodness because it didn't work right when I used the upgrade20.php file.

Anyways...

I want to upgrade to 2.2.8 this time from 2.2.6, are there suggestions you have so I do not mess my forum up like I did last time? I am using vbindex as index.php for my site, and it is pretty modified. Basically all I want to do is fix the permissions bug from 2.2.6 if anyone knows a simple way how...

Thanks,

[LightBringer]

clangrounds.com, I don't know if this is the same thing as what you experienced, but I did noticed that when I went to upgrade to 2.2.7, it screwed up my templates within the admin cp. If you notice, the templates are still there they just ARENT under the vbindex template category anymore.

Here's a quick tip: Back em up as html.
Run the vbindex template installation ONLY.
Then reimport your vbindex backed up templates. :)

It worked like a charm for me.

[clangrounds.com]

Thanks, that worked for me just fine. :happydance: :)

[LightBringer]

Originally posted by clangrounds.com
Thanks, that worked for me just fine. :happydance: :)

Great!

Nice site btw...

[NTLDR]

Running the upgradeXX.php or install.php will wipe any vBindex templates that haven't been modified.

[LightBringer]

Originally posted by NTLDR
Running the upgradeXX.php or install.php will wipe any vBindex templates that haven't been modified.

Actually, for some reason when I ran the upgrade20.php, it didn't clear them. What it DID do however for me, was instead of all the home_XXX templates being under the category vbIndex, they were moved to the root/created section :)

A simple run of the vbindex template installer was enough to put them BACK under the proper category.

Then I simply imported my custom home_XXX templates. :)

Speaking of upgrades and installs...how's the newest version of VBIndex coming along?

[Buddha]

how would i go about displaying the total posts of a specific category, or selected forums.
i have a category that includes many forums for various genres of movies, and within each are the reviews.
on my vbindex, i'd like to be able to say;
"Total reviews: XX"
where XX is the total of all of the forums within that category.

thanks in advance guys.

[NTLDR]

Originally posted by LightBringer
Speaking of upgrades and installs...how's the newest version of VBIndex coming along?

Most of it has been done, the new version is all controled via the ACP, so you only ever need to do 1-2 edits to the file :) I've been delayed in releasing this though due to lack of time and other commitments. I would like to reduce the queries before the next version is out that way it will allways be under 30, with everything switched on :)

[LightBringer]

BTW, this appears to work on 2.2.8 as well. Just got done upgrading. :)

[NTLDR]

Originally posted by Buddha
"Total reviews: XX"
where XX is the total of all of the forums within that category.

Add near the top where the posts info is:

$reviews = $DB_site->query_first("SELECT COUNT(*) AS totalreviews FROM thread WHERE forumid=X");

and add $reviews[totalreviews] in your template where you want it to appear, remember to chane X to the forumid that the reviews are in. If they are in multiple forums add AND forumid=X to the end for each extra forum.

[Buddha]

excellent.
thank you man!
will try it out asap.
btw, does it slow it down, if i'm putting about twenty AND forumid=x to include all of the forums?

[Buddha]

umm... sorry.
don't know exactly where to put it.
tried a few spots, and i just get
Total Reviews: Array.

where do you mean "near the top in post info?"

ps. i changed the forumid to the category's id... would that make a difference... i just figured it would encompass all of the forumid's within it.

[NTLDR]

Sorry, my mistake, put $reviews[totalreviews] in the template. This will add 1 extra query to the page, but shouldn't really slow the page down to much. If you have many forums use parentid=X and but the id of the catagory forum in instead to save having 20+ AND forumid=X in the query, this will probably speed things up a little.

[MultiSync]

NTLDR

I am currently using your vBindex(Great Hack) and I have checked out your site, it is great:)

Just got a few questions, how do make a link to homepage and forum?(like the ones you have on your site, root and home) also can you tell me where I can customize my site? like the one you have. I wanna take out the vbulletin pic at the homepage and in the forum.Thanks!

(btw can u tell me the steps how to do it, because I am pretty new to forum stuff :p )

[Buddha]

Invalid SQL: SELECT COUNT(*) AS totalreviews FROM thread WHERE parentid=26
mysql error: Unknown column 'parentid' in 'where clause'

mysql error number: 1054

this is what i got.
any thoughts ntldr?

[Buddha]

Originally posted by MultiSync
NTLDR

I am currently using your vBindex(Great Hack) and I have checked out your site, it is great:)

Just got a few questions, how do make a link to homepage and forum?(like the ones you have on your site, root and home) also can you tell me where I can customize my site? like the one you have. I wanna take out the vbulletin pic at the homepage and in the forum.Thanks!

(btw can u tell me the steps how to do it, because I am pretty new to forum stuff :p )

link forum to index.php
<a href="index.php?s=$session[sessionhash]">forum</a>

and link homepage to vbindex.php
<a href="vbindex.php?s=$session[sessionhash]">home</a>

and your logo can be changed from the styles menu in the cp. or just change it in the templates (header and vbindex/home_header).
hope that helps.

[MultiSync]

Thanks Buddha, I will try and see if I can figure it out. Thanks for the info:)

[Buddha]

no problem multisync.

is there anyone that could help me with my querry problem by any chance?
thanks.

[MultiSync]

Hey Budda need your help again :nervous:

Where do I place all those lines you mention above? And do i need to make a icon for those?

[Buddha]

depends on how you want it to look multisync.
if you want it to be like the top navagation buttons, open up header and home_header (in the vbindex template group). look at the link for home. copy and paste it, changing only the url as i stated up (adding vb to index), and then change the name of the img src as well. create another button like the home, name it whatever you want. upload to your image directory, and you're laughing.

hope that helps.

[MultiSync]

Thanks I think I knowwhat you mean now. :classic:

[xevious]

How do i get the poll to show up for a guest without having to vote to get it to show up? And for the latest threads, how do i get it to also show the number of replies to each latest thread? It just shows the title and who posted it. Any help will be greatly appreciated. Great hack by the way. I am usin it on a new site I am building right now. :) One more thing, how do i get some space between news posts?

[Buddha]

Originally posted by MultiSync
Thanks I think I knowwhat you mean now. :classic:

no problem MS.
glad i could help.

[NTLDR]

Originally posted by Buddha
this is what i got.
any thoughts ntldr?

As the parentid isn't in the thread table you would have to do a LEFT JOIN I think which I haven't been able to work and I expect would add a greater load then adding each forumid via the AND forumid= statement.

[NTLDR]

Originally posted by xevious
How do i get the poll to show up for a guest without having to vote to get it to show up?
One more thing, how do i get some space between news posts?

These have already been covered in the thread.

And for the latest threads, how do i get it to also show the number of replies to each latest thread?

Add: $numreplies in the home_threadbit template where you want the reply count to appear.

[TheSaint-AeD]

This Hack doesn't seem to work on 2.2.8

I took a totally unmodified 2.2.8 to test it before applying it on my home-Forums.

Step6: Used vBHacker, no Problems in admin/usergroup.php, changes to admin/template.php failed because the reqested string was not found.

The String should be:
$only[\'showgroup\'] = \'Show Groups\';

found a string $only['showgroup'] = 'Show Groups';

edited it to $only['home'] = 'vBindex'; (if else, i got errors in that line)

If i call up my domain, i'm redirected to index.php which has no changes to it, same if i click on home. If I open vbindex.php, I see the following (screen attached). The Test-Pool is not displayed on the left, and from the Index I don't have any Chance to get to the forums from there.

Don't really know what to do with this, any help?

[EDIT]

The Test-Poll is displayed for Ones who voted in it using the Poll-Forum.

[NTLDR]

Originally posted by TheSaint-AeD
If i call up my domain, i'm redirected to index.php which has no changes to it, same if i click on home.

This is whats supposed to happen, you need to change a number of things if you want it to work differently to this, eg change the header links, change it to index.php and index.php to forums.php for example.

If I open vbindex.php, I see the following (screen attached). The Test-Pool is not displayed on the left, and from the Index I don't have any Chance to get to the forums from there

As has been said plently of time before you need to update the home_poll template for it to display correctly.

[Buddha]

thanks for the help regardless ntldr.
i figured a way around it anyway, that's more productive.
your method works perfectly (forumid) now that i've switched things around.
thanks a bunch.

[MultiSync]

NTLDR

Got a little problem (a minor one), how come the online buddy list on vBindex doesn't work, but in the forum it works? Thanks!

Just a note I got the forum addon:)

[groovesalad]

How do I get my Latest Threads to look like the ones on this site? http://www.trojanforge.net/

[erdem]

Originally posted by groovesalad
How do I get my Latest Threads to look like the ones on this site? http://www.trojanforge.net/

allright i can help you ..
that site is mine ..

what u mean by : "How do I get my Latest Threads to look like the ones on this site?"

template? style?
also that one is vbindex 1.3 ..
im gonna update to latest ..

greetz

[TheSaint-AeD]

I forgot something very important in my first Post: Thx 4 this great Hack ;)

But know to my Questions:

I want vBIndex to be the default-load when visiting my domain, so rename vbindex.php to index.php and index.php to forums.php? How Du I add a Forum Button in the upper Row like on vB.org?

My next Question is: I run a big Clanboard, so my Page is visited by "Members" (who may vote on the poll and see the news) and "Outsiders" (they may not see the vote and if possible see there own news, which morely will be some infos on the clan). How can I achive this, or should I better use vB Portal?

[Buddha]

Originally posted by TheSaint-AeD
I want vBIndex to be the default-load when visiting my domain, so rename vbindex.php to index.php and index.php to forums.php? How Du I add a Forum Button in the upper Row like on vB.org?


i can help you with that one.
edit your .htaccess and make it look like this...

DirectoryIndex vbindex.php index.php

that way, it looks to open vbindex first, and if that isn't there, it'll open index.php

[NTLDR]

Originally posted by groovesalad
How do I get my Latest Threads to look like the ones on this site? http://www.trojanforge.net/

Use the thread templates from vBindex 1.3, like I have already said.

[NTLDR]

Originally posted by MultiSync
Got a little problem (a minor one), how come the online buddy list on vBindex doesn't work, but in the forum it works? Thanks!

The buddy list works fine with vBindex.

[xevious]

Ok, i know this has probably been covered already but this thread is really long lol. I want to make my header a flash file so i would like to make that part of the home template a frame and then the rest of the index page its own frame so when a person clicks on a link, only the bottom frame will reload. Not the header. I have been messin around with the html and cant get it to work. I am a total noob when it comes to html lol, but this is what i was tryin to do in the home template:
<iframe width="790"height="200" >$homeheader</iframe>

[NTLDR]

Using an iframe to do this would be pointless. You either need to modify the PHP so that it will eval the lower frame and make the home template contain the frames.

[groovesalad]

Originally posted by NTLDR


Use the thread templates from vBindex 1.3, like I have already said.

The link to download vBindex 1.3 is not working on this site. Anyone know how/where I can get it?

[MultiSync]

Originally posted by NTLDR


The buddy list works fine with vBindex.

I know it should be working, but it is not working on mine.(only works in forum)

But that's okay. I removed the buddy section. Thanks!

[MultiSync]

One more question NTLDR, how can I show the stats info of user with the stats addon?

I edited the vbindex.php file already, but no matter I add to the left column templete, I always got a sql error? Can you show me where to add the poster html and forum threads html? Thanks!

[DarkDraco07]

my polls wont show, it just shows the vote button

[NTLDR]

Originally posted by DarkDraco07
my polls wont show, it just shows the vote button

Please READ the thread. I've this question must have been asked on every single page by now :rolleyes:

NOTE TO ALL USERS

Read the thread before posting questions that have been answered allready. Questions like the one above that have allready been answered will just be ignored from now on.

Thank You.

[DarkDraco07]

well there are 38 pages to this thread, do u think i or anyone else has time to read them all?

[Buddha]

<a href="https://vborg.vbsupport.ru/showthread.php?postid=281735#post281735" target="_blank">here</a>

[NTLDR]

Originally posted by DarkDraco07
well there are 38 pages to this thread, do u think i or anyone else has time to read them all?

And I suppose I HAVE got the time to post the same answer time and time again? :rolleyes:

Incase it haden't escaped your notice the solution is even posted in the first post of the thread which you clearly haven't read.

[drives fast]

I am on the fence here.....I like vbindex and I also like vbhome (lite)

What I am looking for is one of them that has a maxcharacters limit because some of the posts in my news forum can get so long that they muck up the look of the portal page.

Would you be able to add that to vbindex? because I would really like to use that one

[TECK]

NTLDR.. is TECK, not TECH... on the credits. ;) :)
thanks.

[lemarsu]

Hi,

I was wondering if there is a way to show more then one poll on the vbindex page ?
i have read 99% of them...

LeMarsu

[NTLDR]

Originally posted by TECK
NTLDR.. is TECK, not TECH... on the credits. ;) :)
thanks.
Sorry TECK, I'll change it straight away ;)

[NTLDR]

New Features That Will Be In 2.1


Shoutbox;
Full Admin CP integration, for max threads, forumid's etc;
Set the length of news posts;
Switch vBindex on or off independantly of your board;
Switch functions of via the ACP to save queries;
New installer/unistaller.

[NTLDR]

Originally posted by lemarsu
I was wondering if there is a way to show more then one poll on the vbindex page ?

You would need to change this query:

$pollinfo=$DB_site->query_first("SELECT *,thread.open FROM poll LEFT JOIN thread ON (thread.pollid = poll.pollid) WHERE thread.forumid='$pollsforum' ORDER BY poll.dateline DESC LIMIT 1");

And create a while loop similar to that of the news/threads. I don't have time to write/test it now but i'll try and look into it. If you page seems to have a high load time then I don't recoment this as the poll seems to increase this servely for some people.

[lemarsu]

Originally posted by NTLDR
create a while loop similar to that of the news/threads.

Changing the sql is the 1st thing I did then got stuck in the php part of things...
I will look into the while loop.

LeMarsu

[NTLDR]

In the next couple of days I hope to realease vBindex 2.1 Beta 3. This will be pretty much the same as 2.1 Final, but it won't have the installer done.

This will include all the new features mentioned above, bar the new installer/uninstaller.

[Buddha]

how easy will it be to upgrade, ntldr?
especially if we've changed a lot of the templates.

[NTLDR]

There will be a few queries to run to add the options to the ACP and you will need to upload the new PHP file. As for template changes there is only a couple of edits and a few new templates for the shoutbox.

[Buddha]

how many querries is it averaging now, ntldr?
(the new one, of course.)

[NTLDR]

Currently with everything enabled it adds one extra query to collect the shouts, however I do intend to optimise the threads/news queries before it goes final.

[Asso]

WOW! I need 2.1! :)

In future will be a topic sistem like *nuke?

[NTLDR]

Originally posted by Asso
WOW! I need 2.1! :)

In future will be a topic sistem like *nuke?

vBindex 2.1 RC1 will be released in the next few hours :D

Why type of topic system did you want? I've never really understood how they work ;)

[NTLDR]

Here is RC1 of vBindex 2.1 :D

[LightBringer]

Hey NTLDR, I am curious as to where the query to insert the shoutbox information in the db is?

I know with TWT's hack you had to do the following:

CREATE TABLE `shoutbox` (
`shoutid` int(11) NOT NULL auto_increment,
`userid` int(11) NOT NULL default '0',
`shout_text` text NOT NULL,
`timestamp` int(11) NOT NULL default '0',
PRIMARY KEY (`shoutid`)
) TYPE=MyISAM;


Will this still hold true for the RC1 version of vBindex2.1?

I'm a bit hesitant to jump right on this install yet since there isn't an installer included and I've already got the shoutbox implemented on my main site per conversations we've had here before. My only concern is should I step back through the shoutbox hack, remove everything, and then install your solution? Or should I attempt to leave things as they are and JUST update the other vBindex features knowing that I may run into higher query issues? :)

Great hack as always.

[NTLDR]

There are no queries for the shoutbox if you already have it installed, which RC1 assumes you have.

In your case LightBringer, you just need to run the queries in the vbiqueries.sql file to add the options to the CP and then upload the new vbindex.php file. Thats it :D The only other change for you would be to add $readmore into the home_newsbit template if you intend on shortening the newsposts.

Hope thats helps ;)

[LightBringer]

That does help for the most part NTLDR, the issue I have now is that some of the templates are a bit off.

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

There's a few others like this and I'm unsure which of those to change. Should I just rename the ones you've got listed in your hack to match mine?

[LightBringer]

doh...
i just realized something else after installing.
You've got the random quote hack code inside vbindex.php but some of us don't have that hack installed. :/ So it's popping up with a database error at the moment.

Database error in vBulletin 2.2.8:

Invalid SQL: SELECT quote,name FROM quotes ORDER BY rand() LIMIT 1
mysql error: Table 'brainphr_devforum.quotes' doesn't exist

mysql error number: 1146

Date: Thursday 03rd of October 2002 01:02:57 PM
Script: http://www.brainphreeze.com/forums/forums/vbindex.php
Referer: http://www.brainphreeze.com/

[LightBringer]

Ok, I have commented out the random quote hack code, and I am now receiving the following db error:

Database error in vBulletin 2.2.8:

Invalid SQL: SELECT * FROM thread WHERE open=1 AND thread.open<>10 AND visible=1 ORDER BY lastpost DESC LIMIT
mysql error: You have an error in your SQL syntax near '' at line 1

mysql error number: 1064

Date: Thursday 03rd of October 2002 01:21:14 PM
Script: http://www.brainphreeze.com/forums/forums/vbindex.php
Referer: http://www.brainphreeze.com/

[NTLDR]

Originally posted by LightBringer
Ok, I have commented out the random quote hack code, and I am now receiving the following db error:

Sorry about the quote hack bit, I was sure I deleted that :rolleyes: Zip updated now.

Have you changed and submitted the options in the Admin CP?

[LightBringer]

Originally posted by NTLDR


Sorry about the quote hack bit, I was sure I deleted that :rolleyes: Zip updated now.

Have you changed and submitted the options in the Admin CP?

Yup, I sure did. As long as I have the latest threads option turned off in the ACP, it pulls up the vbindex page.

I've also noticed that the news section isn't pulling the appropriate NEW posts. What it is pulling is the latest new post and all the replies associated with it. :/

You can see that on my site I have the news set to 5, but it's not pulling the 5 new posts as I stated.

http://www.brainphreeze.com/forums/vbindex.php

[NTLDR]

Thats strange. I have the exact same code as in the Zip file running here: http://www.thesistersthree.com/vbindex.php Which is working file and you can see.

You do only have one forumid specified for each forum in the ACP?

[LightBringer]

You do only have one forumid specified for each forum in the ACP?


You bet. :)
If I set up that particular news forum so that there are no replies allowed, then it works fine, but as long as there are comments associated with the post, those comments show up as news items on the front page.

I'm not sure if that helps or not.

[NTLDR]

Originally posted by LightBringer
If I set up that particular news forum so that there are no replies allowed, then it works fine, but as long as there are comments associated with the post, those comments show up as news items on the front page.

Thats a slight oversight on my part, the board I was testing with didn't have any replies in the threads. To use the new query reduced code will require an alteration to the thread table to store the first postid when a newthread is started.

After a load of thinking and testing I have come up with these changes you need to do.

ALTER TABLE thread ADD tpostid int( 10 ) unsigned DEFAULT '0' NOT NULL

In newthread.php find:

$postid=$DB_site->insert_id();

After it add:

if ($forumid=$newsforum) {
$DB_site->query("UPDATE thread SET tpostid=$postid WHERE threadid=$threadid");
}

This will only add the extra query when starting threads in the news forum, of course you can just add the query without the if to add it to all posts.

And upload the new vbindex.php that is attached. Just the threads to look into now.

[groovesalad]

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

[Valerie]

Looks great! :D

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

[TheSaint-AeD]

Perhaps it'd be better to update the first Post and prune this thread to the important Posts.

[NTLDR]

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.

[NTLDR]

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.

[NTLDR]

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.

[Asso]

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

[NTLDR]

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.

[jimmyjoe]

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 (http://www.smartphonesource.com)

thanks for all your help

[NTLDR]

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):

if ($action == "getnew") {
// new posts
$threadsquery = $DB_site->query("select threadid,forumid,title,postusername,lastposter,rep lycount,iconid from thread WHERE visible=1 AND thread.lastpost>=".$bbuserinfo[lastvisit]." AND thread.open<>10 ".$threadsql." order by lastpost desc limit $numthreads");
}

To:

if ($action == "getnew") {
// new posts
$threadsquery = $DB_site->query("select threadid,forumid,title,postusername,lastposter,rep lycount,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.


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 ;)

[fluent]

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

[NTLDR]

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/showthread.php?postid=305664#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.

[jimmyjoe]

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

[NTLDR]

Try changing:

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

To:

// active topics
$threadsquery = $DB_site->query("SELECT threadid,forumid,title,postusername,lastposter,rep lycount,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.

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

[TECK]

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

[Chris M]

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

[Chris M]

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

[groovesalad]

anyone? anyone? :)

[Chris M]

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

Now I get no news on my main page!

Satan

[NTLDR]

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.

[NTLDR]

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 ;)

[NTLDR]

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 :)

[Chris M]

Thanks NTLDR...

It sorted the problem out:)

Satan

[Antorz]

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

[groovesalad]

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?

[Buddha]

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

[groovesalad]

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.

[otacon]

a

[Chris M]

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

[groovesalad]

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.

[Chris M]

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

[groovesalad]

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

[Chris M]

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

[groovesalad]

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?

[Chris M]

It should be in the Templates folder:)

Satan

[groovesalad]

Hmm, weird. I don't have that.

[Chris M]

Oh...

Try Re-downloading the file;)

Satan

[NTLDR]

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.

[Till]

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

Just curious.

Thanks,
Till

[groovesalad]

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?

[digitalJE5U5]

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:
$only[\'showgroup\'] = \'Show Groups\';

So i could NOT replace it with
$only[\'home\'] = \'vBindex\';

Is this the reason for my error??

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

Dunno
:tired:

[Kohhal]

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?

// 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 (http://www.vbulletin.com/forum/showthread.php?postid=347921#post347921) 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:

[NTLDR]

Originally posted by Till
This hack uses still 35 queries if all options are turned on?!


No, like the first post says unline version 2.0.1 this hack significatly reducues queries and should allways have less than 30 with everything I have supplied enabled.

[NTLDR]

Originally posted by TheMasterG
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?

As you can see the UPDATE query for maxloggedin is duplicated so I know something's definetly wrong here. I found a thread (http://www.vbulletin.com/forum/showthread.php?postid=347921#post347921) 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:

I know this is not the case with vB 2.2.4 upwards, if you want to PM me your vBindex PHP file I can add the code from 2.2.8 for you which works.

[NTLDR]

Originally posted by digitalJE5U5
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 .


Change your images folder to the full URL, this will make sure the images load correctly.

find $only['showgroups'] is what you need to find and place the code AFTER it, vBhacker gives the wrong instructions for some reason.

[Buddha]

ntldr... i have a suggestion for the new version, if it's not too late. don't know how hard it would be either.
i haven't upgraded yet (and am unsure if i will) as i have done so much work with this and it would be a +++++ to have to redo all of it. i am using your hack to power all of my site (thank you so much). i have nearly twenty additional pages that i have created, using vbindex as the base. i then have gone in and changed the code to point that page to the proper templates. i've had to create a crapload extra templates for all of these additional pages. however, i've taken stuff out of the extra pages (such as the polls, and i'm currently searching for which part of vbindex to remove if you don't use the newest threads in the right menu... don't remember seeing a post about it here, but i am checking now) to reduce querries.
here's my suggestion... you say that the new one can be controlled through the admin cp now, to choose what you would like selected and whatnot. is it possible to have it so that you can create a copy within the cp, choose a name and all of the options you would like selected for that page, and which templates would correspond to the header/footer, left, main and right. know what i mean? then have a dropdown menu perhaps that displays all of the additional pages that you have created and then you can select one and do the work on it from there.

just a thought.
i know that it would make it a lot easier to upgrade my site to the newest version if you had this available.

*edit*
ok, checked through all of the pages, and it's nowhere to be found, so now i'm asking.
is there a way that i can trim the vbindex code to remove querries if i am not using the newest threads display in the right panel (using 2.0.1). thanks.

[NTLDR]

Originally posted by Buddha
here's my suggestion... you say that the new one can be controlled through the admin cp now, to choose what you would like selected and whatnot. is it possible to have it so that you can create a copy within the cp, choose a name and all of the options you would like selected for that page, and which templates would correspond to the header/footer, left, main and right. know what i mean? then have a dropdown menu perhaps that displays all of the additional pages that you have created and then you can select one and do the work on it from there.

Changing the code so that a certain header/left and right templates are displayed based on the page would be quite easy, are you using the standard vbindex.php?page=template_name method for displaying extra pages? Alternativly you can make a copy of the vbindex.php and remove the code for the functions you don't use and use that php file for the rest of the site.

ok, checked through all of the pages, and it's nowhere to be found, so now i'm asking.
is there a way that i can trim the vbindex code to remove querries if i am not using the newest threads display in the right panel (using 2.0.1). thanks.

If you are not using the latest threads bit at all for your site, you can comment out or delete all of the code starting at:

// latest threads
// -------------------------
if (!isset($numthreads)) {
$numthreads=$maxthreads;
}

To:

eval("\$threads = \"".gettemplate('home_threads')."\";");
// -------------------------
// end latest threads

This will then remove the queries that are generated by it.

[Buddha]

thanks bud... just checked and i'd already taken that out but just wanted to check if there were any other querries anywhere else as well.
i'm using 2.0.1 and i'm not using the vbindex.php?page=template_name method... i've made copies and renamed them and did exactly what you said and took out all of the extra stuff that i don't want. i've been able to greatly reduce the querries on the extra pages by doing that.

[Buddha]

couple more questions for you ntldr.
what's the eta on a final version of 2.1?
also, how many querries is it cutting down. i know you said with everything on, it only adds 1, but i'm wondering how much it will cut down in general. were you able to get the loop going so that it doesn't matter how many posts are displayed?
thanks.

[Ninth Dimension]

Hi, just wanted to say that I've added the beta upgrade to my localhost forum (soon to be released) and after a bit of messing arround, and fixing the minor bugs you have it's working very well.

I love the shoutbox intregration that you have, my users will love it.

Keep up the good work, i look foward to seeing more updates on this soon :)

[NTLDR]

Originally posted by Buddha
couple more questions for you ntldr.
what's the eta on a final version of 2.1?
also, how many querries is it cutting down. i know you said with everything on, it only adds 1, but i'm wondering how much it will cut down in general. were you able to get the loop going so that it doesn't matter how many posts are displayed?
thanks.

The final will be out when I have enough time to finish the installer and check everything works correctly, the actual coding for 2.1 has been pretty much finalished.

v2.1 allways has less than 30 queries will everything enabled, latest threads, news posts, poll, buddies, threads/post since last visit, who's online, who's online today. I have managed to optimise and get out of the loop for both the news and the threads queries on v2.1

The example site running a customised v2.1 (it has 5 extra queries for specific things not in vBindex and has the online users code removed) has the following microstats:

Page generated in 0.506 seconds (47.40% PHP - 52.60% MySQL) with 30 queries.

Which is about 10-15 queries less than it had using v2.0.1 (with only 1 query added for a specific thing not in vBindex).

[NTLDR]

Originally posted by Ninth Dimension
Hi, just wanted to say that I've added the beta upgrade to my localhost forum (soon to be released) and after a bit of messing arround, and fixing the minor bugs you have it's working very well.

I love the shoutbox intregration that you have, my users will love it.

Keep up the good work, i look foward to seeing more updates on this soon :)

Thanks for the feedback Ninth Dimension :D

As you have mentioned it were all the minor bugs you found have a fix in this thread? If not I'd like to know what they are so I can correct them :)

[digitalJE5U5]

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.

Change your images folder to the full URL, this will make sure the images load correctly.

Where do you want me to change my images folder? Templates, what.php? Where?

Thanks,
/DJ

[NTLDR]

You need to modify the replacement for { imagesfolder } in the ACP to the full URL

[Till]

Originally posted by NTLDR


No, like the first post says unline version 2.0.1 this hack significatly reducues queries and should allways have less than 30 with everything I have supplied enabled.

Oh, sorry about bugging you. I guess I have to actually get used to reading instead of scanning websites. :)

The hack looks very charming. I'm going to install it tonight.

Thanks for your reply,
Till

[groovesalad]

NTLDR - I have obviously done something wrong when installing VBindex 2.0.1 or either done something wrong when installing VBIndex 2.1 because there is no change. When I load up the page after installing 2.1, it looks the same. Even if I change information in the ACP. Is there a way to uninstall 2.1 & 2.0.1 and just start over?

[Till]

I just installed the hack and it just looks as predicted.

I'm wondering though should I add a rule to .htaccess to use vbindex.php as the default page served from the directory or did I miss anything? I did go over the instruction and read it, but I'm not sure.

Cheers,
Till

[Buddha]

that's what i've done and it works great that way, till.

[kmoo]

I would like to install this but can not find the first version you ask to install. I whent to that forum and the link for the download is No good. Can someone please help.....

[jimmyjoe]

I have it installed and working great... Thanks NTLDR...

One other thing is that I don't know where to put $bburl at so that my listing of who's online works when you click on the name... I don't know what template that is coming from...

I don't have vbindex in my forums folder..

Thanks for your help...

[jimmyjoe]

I have it installed and working great... Thanks NTLDR...

One other thing is that I don't know where to put $bburl at so that my listing of who's online works when you click on the name... I don't know what template that is coming from...

I don't have vbindex in my forums folder..

Thanks for your help...

[NTLDR]

Originally posted by jimmyjoe
One other thing is that I don't know where to put $bburl at so that my listing of who's online works when you click on the name... I don't know what template that is coming from...

forumhome_loggedinuser is the template that you need to edit :)

[NTLDR]

Originally posted by groovesalad
NTLDR - I have obviously done something wrong when installing VBindex 2.0.1 or either done something wrong when installing VBIndex 2.1 because there is no change. When I load up the page after installing 2.1, it looks the same. Even if I change information in the ACP. Is there a way to uninstall 2.1 & 2.0.1 and just start over?

There is a compleate unistall procedure posted in this thread towards the start ;)

[NTLDR]

Originally posted by kmoo
I would like to install this but can not find the first version you ask to install. I whent to that forum and the link for the download is No good. Can someone please help.....

vBindex v2.0.1 is in the first post of this thread;
vBindex v2.1 RC1 is linked to in the first post;
vBindex v1.x is no longer avalible.

[NTLDR]

Originally posted by Till
I'm wondering though should I add a rule to .htaccess to use vbindex.php as the default page served from the directory or did I miss anything? I did go over the instruction and read it, but I'm not sure

This would be the quickest way via .htacess:

DirectoryIndex vbindex.php index.php index.html

[Buddha]

Originally posted by NTLDR
v2.1 allways has less than 30 queries will everything enabled, latest threads, news posts, poll, buddies, threads/post since last visit, who's online, who's online today. I have managed to optimise and get out of the loop for both the news and the threads queries on v2.1

so then, if i understand correctly, the querries are optimised, however you will have more querries per page depending on how many posts are displayed.

is this correct?


thanks.

[NTLDR]

Originally posted by Buddha
so then, if i understand correctly, the querries are optimised, however you will have more querries per page depending on how many posts are displayed.

No, it will allways be a static number of queries no matter how many news posts/latest threads are displayed :D

[Buddha]

oh yeah.
that's fantastic.
good to hear.
that means with a lot of the options removed (such as i currently have), i should be able to drop the querries to the low 20s.
very cool.
i guess i will be updating afterall then.
looking forward to that final release buddy.

(by the way, will you have a manual install still with the final release as well as the installer? i'd like to make certain that all of the work i've put in isn't destroyed by the installer.)

[NTLDR]

Yes I will have manual install instructions for the final release :)

The man change is really the PHP which just needs updating, there are only 2 or 3 template edits and a few new ones for the shoutbox, upgrading should be very simple, easy and quick :D

[Buddha]

that sounds great then!
i was hoping to hear that... like i said, i've duplicated the php file nearly 20 times and altered it, and have created a lot of extra templates and replacements for those extra pages... didn't want that work to have been done for nothing.

again, i want to thank you for all of this work. i've been checking out peoples sites who have posted in this forum, and it's kinda disappointing to see that many are in fact using this script, but they have removed the copyright. i don't understand why people are so hesitant to show their support... i'm quite proud to have that copyright on my pages. shows i respect the work that has been done, and i support the product.
thanks.

[NTLDR]

Thanks for the kind words Buddha. I hope to release RC2 next week which will have the installer and the correct templates etc which I will have for test for about one week to iron out any bugs that may be left then it will go gold :D

[Buddha]

looking forward to it, buddy.
for sure.

you were mentioning in another post that there wouldn't be too many template edits... hoping this is still true.

[clangrounds.com]

D'oh...I recently purchased a Ravio skin, and converted the vbindex to fit the design. However, I think I messed up the poll display. It's weird b/c you can see the results just fine, but for someone who has not voted on the poll, it shows up like this:

[Buddha]

rebel, is that vbindex you've got as the index to clangrounds.com?

[FleaBag]

Error

SQL-query :

INSERT INTO setting VALUES (216, 82, 'Enable vBindex', 'vbiactive', '1', 'Turns vBindex on or off globally.', 'yesno', 1)

MySQL said:


Duplicate entry '216' for key 1

Back


And what does that mean in English? :p

[NTLDR]

Originally posted by GamerForums
And what does that mean in English? :p

In the SQL file (vbisettings.sql) each line after the first has a number on, 216,217 etc, change them all to NULL and the re-run the file.

[NTLDR]

Originally posted by clangrounds.com
D'oh...I recently purchased a Ravio skin, and converted the vbindex to fit the design. However, I think I messed up the poll display. It's weird b/c you can see the results just fine, but for someone who has not voted on the poll, it shows up like this:

When adding new styles they will use the default home templates that were added when running the installer. You therefore have the home_poll template that is incorrect, the updated one is in the updated_templates folder of the zip.

[NTLDR]

Originally posted by Buddha
you were mentioning in another post that there wouldn't be too many template edits... hoping this is still true.

There will be a few optional major template edits, which are needed to compleatly remove a feature from the site from the CP. There are no mandatory edits other than the fixed home_poll template. Other than that there will be a few new templates for the shoutbox and 1 or 2 tiny edits for other features.

[FleaBag]

I get the same problem with 82 now... Null that aswell? And do I remove the commas?

[TECK]

gamer, i see that you advertise this:
I'll install vBulletin for anyone, on any server, for $50 [or move your vBulletin to another server/domain]. I'll install hacks for $10 each. PM me for more information.
why do you ask such a simple question to answer? since you are capable to install complex vBulletin configurations and hacks?

[ontherun]

Im doing a clean install of vB and vbindex..........

Im looking at Step 3

// add here the vBulletin code of the original index.php
// lines 139 - 213(in an unhacked 2.2.6 index.php)


Now Im using vBulletin 2.2.8 so do we have to find the code from 2.2.6 index.php or can we use the same lines from 2.2.8 index.php?


Quote from Readme

+---------------------------------------------------------+
| In admin/template.php, replace this code: |
+---------------------------------------------------------+
$only[\'showgroup\'] = \'Show Groups\';
+---------------------------------------------------------+
( there's a \ in front and back off showgroups in both places
but does not show in forum thread)
+---------------------------------------------------------+
| With this code: |
+---------------------------------------------------------+
($only[\'home\'] = \'vBindex\'; )
+---------------------------------------------------------+
( there's a \ in front and back off home and vBindex but does not show in forum thread)
See Text file in vbindex-v201final.zip vbindex.hack.txt

END Quote


Well the closest line of code in the admin/template.php to this is:
$only['showgroup'] = 'Show Groups';


As you can see there are NO ( \ hash \ ) Marks in the 2.2.8 version of admin/template.php

( I left the hash \ marks \ out ...................


Where do I find tha vbindex CP I have a screen shot of it but can't locate it anywhere in my ACP

[NTLDR]

Originally posted by GamerForums
I get the same problem with 82 now... Null that aswell? And do I remove the commas?

If you have allready run the first query in the file then you skip that one and just do the others, to find out if the first one executed correctly:

SELECT * FROM settinggroup WHERE settinggroupid='82';

You should have a line with the vBindex setting group displayed if it has been run before.

[NTLDR]

Originally posted by ontherun
Now Im using vBulletin 2.2.8 so do we have to find the code from 2.2.6 index.php or can we use the same lines from 2.2.8 index.php?

You can use the code from any 2.2.x version of vB, just make sure you copy between the lines indicated in the ReadMe file.

Well the closest line of code in the admin/template.php to this is:
$only['showgroup'] = 'Show Groups';

For some reason vBhacker seems to be very buggy, you should add:

$only['home'] = 'vBindex Home Page';

After the line you posted above.

Where do I find tha vbindex CP I have a screen shot of it but can't locate it anywhere in my ACP

For 2.0.1 in the usergroup settings.

[FleaBag]

Teck: Because I've never run into a problem like this before. I currently have 60 hacks running on my board - I can handle that, but I'm not too hot with SQL.

NTLDR: It did run correctly, I checked in phpMyAdmin.

I do though have the same problem as Satan had earlier, where no news text is shown on OLD news posts, I made a new one to test and it all appears correctly. I ran the script you posted here (https://vborg.vbsupport.ru/showthread.php?postid=306439#post306439) in the admin folder, it seemed to process some posts but then I got the following SQL error.


Invalid SQL: UPDATE thread SET tpostid= WHERE threadid=34
mysql error: You have an error in your SQL syntax near 'WHERE threadid=34' at line 1

mysql error number: 1064


Also, when I tried to post something in the Shoutbox on the vBindex page, it tries to go to a page named vbibeta.php. I resolved this by replacing vbibeta.php with $bburl/shoutbox.php in the home_postshout template. But how do I make the vBindex come back to the main page after a shout is posted? The smilies in the vBindex Shoutbox also don't use the correct URL so none of them show up.

It might also be a good idea to state in the instructions that people using vBindex outside of the forums folder shout change their' imagesfolder replacement to the full URL [this doesn't though, fix the Shoutbox smilie problem].

[NTLDR]

Originally posted by GamerForums
NTLDR: It did run correctly, I checked in phpMyAdmin.

Just run the other queries as instructed above ;)

I do though have the same problem as Satan had earlier, where no news text is shown on OLD news posts, I made a new one to test and it all appears correctly. I ran the script you posted here (https://vborg.vbsupport.ru/showthread.php?postid=306439#post306439) in the admin folder, it seemed to process some posts but then I got the following SQL error.

I have used this on a board with 1,741 threads without a problem, for some reason threadid 34 doesn't seem to be able to get the postid of the first post within that thread.

Also, when I tried to post something in the Shoutbox on the vBindex page, it tries to go to a page named vbibeta.php. I resolved this by replacing vbibeta.php with $bburl/shoutbox.php in the home_postshout template. But how do I make the vBindex come back to the main page after a shout is posted? The smilies in the vBindex Shoutbox also don't use the correct URL so none of them show up.

vbibeta.php was what I had the file called on my test install, replace it with the name of your vbindex.php file to correct this problem.

It might also be a good idea to state in the instructions that people using vBindex outside of the forums folder shout change their' imagesfolder replacement to the full URL [this doesn't though, fix the Shoutbox smilie problem].

I think this is already included if not it will be added for the Final Release along with a list of other templates that require editing if used outside the forums directory.

[ontherun]

I have whiped out everything and reinstalled. I have vbindex working GREAT with the vBulletin default style set. I add a new style set and lose parts the header background and menu bars on the vbindex page.

Parts of the Stlye ( Welcome ) on the news banner. But the background and menu items do not. The Welcome above NEWS is part of the New Style set and pulling from the right sub-directory.

I have ask this question a few times and I have received any information that would help solve this issue

Please help me fix this, DSS TV LIVE is in need of this type of front end and we need to be able to allow the user to pick between different style sets.

[NTLDR]

You header for the platinum style uses different names (not the default vB ones) for the images at the top. Copy the contents of your header template into the home_header template and then the images will load.

For the broken icon image for the news title you need to add icon0.gif into your platium style's icons folder. icon0.gif can be found in the vBulletin zip file.

[Xelation]

Originally posted by NTLDR
You header for the platinum style uses different names (not the default vB ones) for the images at the top. Copy the contents of your header template into the home_header template and then the images will load.

For the broken icon image for the news title you need to add icon0.gif into your platium style's icons folder. icon0.gif can be found in the vBulletin zip file.


what home_header?

[NTLDR]

Originally posted by Xelation
what home_header?

home_header is the template ontherun needs to edit for the styles that arn't displaying correctly.

[ontherun]

NTLDR,

I know you said this a couple times to me but it took a all night'r to figure out what you where tring to tell me.

Its so easy once I started Expanding everything.

THANK YOU --------------- And I say that with high respect for you and your work.

[FleaBag]

So how do I get around this? Delete the problematic thread? If so how do I find out which one it is?

[NTLDR]

Originally posted by GamerForums
So how do I get around this? Delete the problematic thread? If so how do I find out which one it is?

This is the thread that is causing problems:
http://www.gamerforums.com/board/showthread.php?threadid=34

All I can suggest is deleting it as I can't see any reason why the script isn't geting the postid for it.

[FleaBag]

All seems to be working 100% now. Great work! :D

[NTLDR]

Originally posted by GamerForums
All seems to be working 100% now. Great work! :D

No problem, Glad its working correctly for you :D

[FleaBag]

It seems that the index.php?page=pagename feature no longer works?

I also found that for smilies to work in the vBindex Shoutbox, you have to put their' full URL in the ACP.

[NTLDR]

Originally posted by GamerForums
It seems that the index.php?page=pagename feature no longer works?

I also found that for smilies to work in the vBindex Shoutbox, you have to put their' full URL in the ACP.

For the smilies to work anywhere on the main page correctly if vBindex is outside your forums directory then the full path is needed, just like for the images folder.

How have you named the template in the ACP that you are trying to access via ?page=pagename

[FleaBag]

I named it home_pagename, like in the last version of vBindex?

[NTLDR]

Try renaming it home_extra_pagename

I slightly changed it in this version to improve security.

[FleaBag]

How does that imrpove security? I tried that already anyway [I had a look at your code] - it didn't work. :(

[NTLDR]

Originally posted by GamerForums
How does that imrpove security? I tried that already anyway [I had a look at your code] - it didn't work. :(

It improves security by not allowing users to look at other templates like home_welcomemessage which are only ment for logged in users.

Just change home_extra_$page to home_$page in the vbindex.php file and it should work the old way again.

[FleaBag]

I like your security idea, I'll try to make it work!

[NTLDR]

I shall be looking into that for the final version as well.

[FleaBag]

Hmmm, sorry sir, but your home_extra system just worked. Sorry for being a pain in the arse - dunno why it didn't work before! :)

[NTLDR]

:D Less work to be done :D

[FleaBag]

And what good work it is too! I've been waiting for something like this for a while. You're the man! :D

[groovesalad]

I installed 2.0.1 correctly and had it running fine. When i installed 2.1, here is what I got



Database error in vBulletin 2.2.6:

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

mysql error number: 1054

Date: Wednesday 16th of October 2002 03:04:07 PM
Script: http://groove-salad.com/forum/forum/vbindex.php
Referer:

[NTLDR]

Originally posted by groovesalad
I installed 2.0.1 correctly and had it running fine. When i installed 2.1, here is what I go

You haven't installed v2.1 RC1 correctly. Please read the install instructions.

[groovesalad]

Ok, not sure where I went wrong:

You must allready have already installed vBindex v2.0 or v2.0.1 in order to use the Release Candidate. No installer is included for RC1.

Did it

Run the SQL in vbisettings.sql, this will add the vBindex settings to the database, then go into vBulletin Options in the Admin CP and change the options to what you require.

Did it


There are one/two edits required for the vbindex.php file itself. I. Copy the code from forum/index.php where indicated in the file. II. Change the chdir(); statement if you are running outside your forums directory.

Did it


If you rename the vbindex.php file, you will need to change the name in the home_postshout template.

Didn't rename it, so don't need to do it

To add the shoutbox to the left/right side add $homeshoutbox after one of the <tr>'s do not put it in its own <tr><td>. The only template edit since v2.0.1 is home_newsbit which adds $readmore incase you have $maxchars set.

Did it

If you wish to use the shoutbox then this hack is a prerequsit, and needs to be installed first, however if you do not require the shoutbox option disable it in the ACP, otherwise you will get DB errors.

Already had it installed. So what else should I do?

[NTLDR]

Originally posted by groovesalad
Already had it installed. So what else should I do?

You haven't followed all the instructions:

Please also see this post (https://vborg.vbsupport.ru/showthread.php?postid=305664#post305664) for extra details on the installation.

[groovesalad]

Once again, you're awesome! Me? Not so much. lol

Thanks again.

[NTLDR]

*hehe* No problem, glad its all up and running now :D

[groovesalad]

Ok, it works great, the only thing I can't seem to get to show is the text for the News section. I have it set to 500 characters, so I think that's plenty. Any ideas?

http://www.groove-salad.com/forum/vbindex.php

[NTLDR]

Posts made prior to the changes in newthread.php won't have the ID, upload the file called setpostid.php in the zip into the admin folder and run it, they should then show up.

This will be fully integrated into the Update Counters bit in the final release.

[groovesalad]

I've downloaded 3 .zip files from this thread, but neither one of them have that setpostid.php in the zip file. Was I supposed to look somewhere else for it?

[NTLDR]

I'm sure it was in vbi21rc1.3.zip, I've attached it here anyway :D

[groovesalad]

Great, thanks for attaching it. I ran it in my admin directory, it went through several posts, then came up with this:



Database error in vBulletin Control Panel 2.2.6:

Invalid SQL: UPDATE thread SET tpostid= WHERE threadid=97
mysql error: You have an error in your SQL syntax near 'WHERE threadid=97' at line 1

mysql error number: 1064

Date: Wednesday 16th of October 2002 05:42:28 PM
Script: http://groove-salad.com/forum/forum/admin/setpostid.php?
Referer:



Any ideas?

The weird thing is, the URL is http://groove-salad.com/forum/forum/admin/setpostid.php?

and has two forum/forum in it. Not sure why it's trying to go to that URL.

[ontherun]

NTLDR,

What code do I need to write in the index.php to load the vbindex.php first

This was my best guess after seening it in a different loader in a hack from another site I just changed the code to point at vbindex

// vbindex Loader
$loader = split("/", getenv(REQUEST_URI));
$n = count($loader)-1;
$loader = $loader[$n];
if (trim($loader)=="index.php") {
Header("Location: vbindex.php");
}
// End vbindex Loader

User say that there still going straght to the to the forum and not the vbindex front page.

Any help?

[FleaBag]

NTLDR, it wasn't there, just so you don't think you're going mad. There's no instructions in there either.

[FleaBag]

groovesalad, I had that problem and had to delete the problematic thread. I'm not saying that's what you should do - though. ;)

[Buddha]

ontherun, change your htaccess file. mentioned several times in previous posts. easy to do bud.

[NTLDR]

Originally posted by GamerForums
NTLDR, it wasn't there, just so you don't think you're going mad. There's no instructions in there either.

Strange, I have it in my local zip, I must have updated it :rolleyes:

I know there is a lack of instructions in the zip, I am going to try and realease RC2 this week which will have all the instructions in it and a new installer.

[NTLDR]

Originally posted by groovesalad
and has two forum/forum in it. Not sure why it's trying to go to that URL.

You have $bburl set wrong in your ACP I expect.

Problematic thread: http://groove-salad.com/forum/showthread.php?threadid=97

Problem, there is no post to get the postid from, hence the DB error.

[NTLDR]

I hope to release vBindex v2.1 RC2 later tonight. This will include the automated installer.

I have further optimised the code since RC1 and I expect some more optimisations for v2.1 Final :D

The templates are done, so its just some finishing touches and a little optimising to go ;)

[NTLDR]

At last its here :D RC2 of vBindex, the templates have been re-worked the installer has been significantly updated and now includes an uninstall option and an upgrade from v2.0.1 :D

Notes for the install:

Upload vbi_install.php and select the required option for you install.

If you choose an upgrade or templates install then all your home templates will be deleted and replaced. Backup your database first, quite a few changes are made in the install procedure.

In newthread.php find:

$postid=$DB_site->insert_id();

After it add:

if ($forumid=$newsforum) {
$DB_site->query("UPDATE thread SET tpostid=$postid WHERE threadid=$threadid");
}

This will allow the news text to be displayed on new threads posted in your selected news forum. If you news posts don't appear, upload setpostid.php from the zip into forums/admin and run, this should correct the problem.

Note: you must have TWT's shoutbox installed if the shoutbox option is set to on in the ACP.

Full instructions of other template and file edits for this hack that are optional will be included in the final release.

Templates Changed From v2.0.1:

home_buddy1;
home_poll (fixed);
home_left;
home_right;
home_newsbit;
home_pollresult;
home_threads;

These are mostly minor changes to cope with the new ACP system.

I strongly recomend turning Avatars OFF for news posts, this will reduce queries by a large number :D

As allways, support is provided IN THIS THREAD ONLY.

[Buddha]

damn, i am so looking forward to the final release of this. i'll need to go through the manual upgrade though, seeing as i've made quite a few changes to the templates and copied and renamed vbindex.php quite a few times for the extra pages.

[NTLDR]

I hope the final to be out next week, I made this RC2 just incase there are any bugs and so I can release the changes sooner rather than later.

I'll probably try and make a list of changes in the templates from vBindex v2.0.1 to make it eaiser for you and other users with template changes to upgrade. None of the edits are manditory though :D

[Kohhal]

Hi,

I'm running v2.1 RC1 and it's working perfectly apart from no thread no. on the comments link in the poll.

Is there much differences in this new version? Is the fix for the poll included? (couldn't find it in the mass of pages)

Thanks and again, top hack!!!

G

[NTLDR]

I'd suggest uploading the new vbindex.php file I'll take a look into the missing threadid on the link now :)

[NTLDR]

Originally posted by TheMasterG
Is the fix for the poll included? (couldn't find it in the mass of pages)

I have fixed the error, just updating the zip now, thanks for pointing it out TheMasterG :D

[groovesalad]

Originally posted by GamerForums
groovesalad, I had that problem and had to delete the problematic thread. I'm not saying that's what you should do - though. ;)

Is there a way to search by thread number? I have no idea where thread #97 would be. Thanks.

[groovesalad]

Originally posted by NTLDR


You have $bburl set wrong in your ACP I expect.

Problematic thread: http://groove-salad.com/forum/showthread.php?threadid=97

Problem, there is no post to get the postid from, hence the DB error.

Weird. I moved the thread and it must have left a remnant of the thread.

[NTLDR]

I posted the link to thread 97 above ;)

[LightBringer]

*sigh* I should have left things the way they were, but alas, I was tempted. So, in light of this:

I removed all of the old vbindex code.
Reinstalled fresh.
Had to make some changes like not showing certain forums on latest threads, recopying all of my original templates over, etc.

However, NOW the news doesn't show up right and I tried to use the fix with "setpostid.php", this is the error I got:

Database error in vBulletin Control Panel 2.2.8:

Invalid SQL: UPDATE thread SET tpostid= WHERE threadid=256
mysql error: You have an error in your SQL syntax near 'WHERE threadid=256' at line 1

mysql error number: 1064

Date: Thursday 17th of October 2002 03:22:33 PM
Script: http://www.brainphreeze.com/forums/forums/admin/setpostid.php?
Referer:

[groovesalad]

Originally posted by NTLDR
I posted the link to thread 97 above ;)

I asked before I saw your post. :) Thank you :)

[groovesalad]

Weird, I moved about 4 posts from one Forum to another and left it so it said Moved:Thread Name in the old thread. That's where I'm getting that error. If I post a link to the problematic thread, delete it, then it runs fine. Hmmm.

[NTLDR]

Originally posted by LightBringer
However, NOW the news doesn't show up right and I tried to use the fix with "setpostid.php", this is the error I got:

I've changed setpostid.php very slightly, try it now and see if it works or gives you the same error :)

[LightBringer]

Also NTLDR, I noticed that in the newest RC that you've got up there, you have original vbulletin code in the section that says "copy and paste from lines 142-202" or whatever. :)

[NTLDR]

Originally posted by groovesalad
Weird, I moved about 4 posts from one Forum to another and left it so it said Moved:Thread Name in the old thread. That's where I'm getting that error. If I post a link to the problematic thread, delete it, then it runs fine. Hmmm.

Thanks for that groovesalad, thats exactly what the problem is :) I'm on to this now :D

[LightBringer]

hehe that setpostid worked, I added in the forums I DIDNT want to show up Latest Threads by placing a forumid!=forumid# (IE: forumid!=43) in the vbindex threadsquery string and now everything looks dandy! :)

[NTLDR]

Originally posted by LightBringer
Also NTLDR, I noticed that in the newest RC that you've got up there, you have original vbulletin code in the section that says "copy and paste from lines 142-202" or whatever. :)

Fixed, setpostid.php fixed and all resolved to, heres the latest version which ignores thread redirects compleatly :D

[LightBringer]

Cosmetic Change advice:

In your home_shoutboxbit, ya may want to change it from this:
<td bgcolor=$color valign="middle"><a href="$bburl/member.php?s=$sessionhash[sessionid]&action=getinfo&userid=$userid"><normalfont><b>$username</b></a><br />$shout_text</normalfont></td>


to this:

<td bgcolor=$color valign="middle"><a href="$bburl/member.php?s=$sessionhash[sessionid]&action=getinfo&userid=$userid"><smallfont><b>$username</b></a><br />$shout_text</smallfont></td>


Just changed the font from normal to small to match the rest of the front page. :)

[LightBringer]

It looks great NTLDR...
Have you been able to fix it so that unregistered and registered users NOT in a particluar usergroup don't see specific threads from forums they shouldn't have access to in the "Latest Threads" section? I like the ability for users that have access to the private forums, to be able to see them in the Latest Threads, whereas, those that shouldn't can't. :)

I'm sure it's just a matter of adding "bbusergroup!=whatever" somewhere...

[NTLDR]

Small but good change there LightBringer :)

Very nice vBindex implimentation too on your site :D

[LightBringer]

Originally posted by NTLDR
Small but good change there LightBringer :)

Very nice vBindex implimentation too on your site :D


Thank you very much and as cliche` as it may sound NTLDR, I couldn't have done it without you! :) (or your hacks for that matter hehe)

[NTLDR]

Originally posted by LightBringer
It looks great NTLDR...
Have you been able to fix it so that unregistered and registered users NOT in a particluar usergroup don't see specific threads from forums they shouldn't have access to in the "Latest Threads" section? I like the ability for users that have access to the private forums, to be able to see them in the Latest Threads, whereas, those that shouldn't can't. :)

I'm sure it's just a matter of adding "bbusergroup!=whatever" somewhere...

They way it works is it selects all the forumid's from the forumpermission table where canview=0 (ie the user group can't view them) and then in the query it blocks out all the forumids there.

The problem I have just thought of with it is that it may still get threads from child forums if they inherit the permissions of its parent. I'll look into this some more :)

[LightBringer]

Thanks NTLDR. :) I'll wait patiently for your return! heh

[TECK]

Originally posted by LightBringer
I'm sure it's just a matter of adding "bbusergroup!=whatever" somewhere... is not as simple as you think.

[groovesalad]

NTLDR, first off, many thanks for your hacks and especially for your willingness to help all of us. :)

One quick question (someone asked this, but not sure if it was answered), I installed 2.1 RC1. Is there any difference between that and 2.1 RC2? If so, I'll be installing that right away.

[NTLDR]

Originally posted by groovesalad
NTLDR, first off, many thanks for your hacks and especially for your willingness to help all of us. :)

One quick question (someone asked this, but not sure if it was answered), I installed 2.1 RC1. Is there any difference between that and 2.1 RC2? If so, I'll be installing that right away.

The templates have been properly done in RC2, now you can switch off say the latest threads and it doesn't leave a blank <tr>

Also I have changed a fair bit of code in RC2, so it would be at least worth using the new vbindex.php file :)

[NTLDR]

Originally posted by TECK
is not as simple as you think.

Indeed it isn't. Currently it hides all threads for forums that have explicitly been set so that users can't view them and that don't just inherit the parents permission. This is the one major thing to work on now :D

[groovesalad]

Excellent, thank you.

[groovesalad]

So, I'm assuming I'd just upload the vbindex.php file and not run the vbi_install.php file because I already have 2.1 RC1 running. Is this correct? Or should I uninstall 2.1RC1 and reinstall with vbi_install.php for 2.1 RC2?