Excellent hack, installed no probs A++++ Check it out at http://www.boogle.org.uk.

Found it very easy to customise, hoping to get a new skin on it over the weekend.

WELL DONE!

Units - Please check post #634 in this thread. If that doesn't help let me know.


Prophet2002 - If you'll open your myvbindex.php file and look for this line:
Replace that with:
Replace XX there with the forum id that you do not want to appear in the latest threads.


mforster - Thank you. Hope you enjoy the hack. :)

you are the man PP, thx for the info.:D

attempted to use this Hack ... looks good ...

But going through the install I found that in the step to edit the pages ..

(Q1)
Step 3 - File Modifications

Find:
'1')");

Replace it with:
'1','Y')");

I could not find this in my file.

(Q2)
In step 2, was I supposed to clear out all the data in those templates and replace with the data in the instructions?

(Q3)
I can't seem to log out of my Forums now.

Any help would be appreciated ... thanks

1. What version of vBulletin are you running? Unless you have another hack that's changed that part of the file, that code should be just a couple of lines below the first line you edited.

2. For the first 2 template mods, yes. For the 3rd one you are only supposed to change the link to point to the full url to your forums.

3. Did you set the Cookie Domain to .yoursite.com as instructed in the install file? Also be sure your Cookie Path (the option right under the Cookie Domain) is set to /

Ok figured out my first question, but still need on the other two. Thanks

Trying to Post to the News Forum .. I recieve this error ..

Database error in vBulletin 2.2.6:

Invalid SQL: INSERT INTO post (postid,threadid,title,username,userid,dateline,at tachmentid,pagetext,allowsmilie,showsignature,ipad dress,iconid,visible,isnews) VALUES (NULL,'4330','Test','Kiko','1','1044720361','0','T est','1','1','66.61.50.249','0','1')
mysql error: Column count doesn't match value count at row 1

mysql error number: 1136

Date: Saturday 08th of February 2003 11:06:01 AM
Script: http://www.consilioetarmis.com/forum.../newthread.php
Referer: http://www.consilioetarmis.com/forum...ead&forumid=85


And on an existing Thread ...

Database error in vBulletin 2.2.6:

Invalid SQL: INSERT INTO post (postid,threadid,title,username,userid,dateline,at tachmentid,pagetext,allowsmilie,showsignature,ipad dress,iconid,visible,isnews) VALUES (NULL,'4331','Test','Kiko','1','1044720985','0','T EST','1','1','66.61.50.249','0','1')
mysql error: Column count doesn't match value count at row 1

mysql error number: 1136

Date: Saturday 08th of February 2003 11:16:25 AM
Script: http://www.consilioetarmis.com/forum.../newthread.php
Referer: http://www.consilioetarmis.com/forum...read&forumid=8


----------------------------------



Ok when i tried both of these, it gave the error, but still created the thread, but didnt have the body of the message in it ..

Also any new post I put in an existing thread seems to clean that thread ...

You didn't edit the newthread.php file correctly and make the 2nd change listed in the install file.

I found a problem in latest threads. Basically if you have a forum such as a moderator forum where you want the forum visible on the board yet restricted so that only mods can get in. I have such a forum and the thread topics are showing up in the myvbindex latest thread table even when the permissions such as for guest say you cannot see in that folder. I know if I make this a private forum the thread topics will not show but I do not want to make the forum private because it will disapear. I really do not want others that cannot get into the mod forum to see what the thread topics are. Is their anything i can do to change this?

This is answered about 5 or so posts up in post #642.

Just make sure that you change the XX to the forum that you do not want to show in your latest threads list.

Also, there is a typo in the post. fourmid should be forumid. :D

HTH,
Jarvis

www.mhogaming.com

If permissions are set for that forum so that those groups can't view other's threads then they shouldn't be visible in the latest forum topics. If for some reason that doesn't work though just check the post jarvis pointed out above. And thanks for pointing out that typo jarvis. :)

whats the code if i wanted to put more than 1 forum in that XX ?

also i put in that code with the correct forum id where the xx were but it still shows in the myvbindex.

Ahhh, it's probably still telling it to pull threads from that forum because of the forum permissions. That code you added in would tell it not to look in that forum, but the part for the forum permissions would tell it to look in that forum, so I guess the permissions are canceling that part out. If you look for this line of code instead:
Right before ORDER BY in that query, add AND forumid!=XX. If you wanted to exclude more than one forum, you would just add the AND forumid!=XX again right after the first one.

im a bit confused. Should i replace this new line you just gave me with the code from before? What do I do with the line I already replaced? Should I put it back to the original line or are you saying I should modify 2 lines of code with the XX line?

You can change the first line in the threads query back to the way it was (removing the AND forumid!=XX).

Then look for this line of code:
Replace that with:
Then just change XX and YY there to the forum ids.

thanks plurplanet, that worked fabulously.

I have another question tho, I want to understand how the latest threads get picked to be displayed? I checked my latest threads and I know their are threads that are newer then some of the threads it picks for the latest threads table in myvbindex. So im wondering how it picks them?

nevermind i was looking at the thread creation date. But just to confirm how this work, it will look in all forums that do not have != and look for the latest post and display the value of how many you wanted in the table from what it finds? correct?

Yes, it will check through all forums except those that you added with the != in front of them. It will also check the forum permissions, so if a user doesn't have access to a forum, those topics should be excluded as well. And yes, it looks for the latest X posts and displays those. By the way, did you ever check to see if the forum permissions for those forums were set to not allow those groups to view others' threads? If all the permissions are set correctly, I'm pretty sure those threads should't be displayed anyways.
Also, if you would prefer for it to show the last poster and time instead, search this thread for "lastposter". I know I've posted instructions for others on how to change this at least once or twice. ;)

Which country's weather does the weather box report?

Have you any ideas or plans on extra hacks or features that future versions of myvBindex will have?

certify - The weather box has 247 countries and over 37,000 cities to choose from.

Yuber - If there are any future versions of this script it will probably be a couple of months before they are released, and will definitely be after vB 3.0 comes out. Lately I've been concentrating on a much bigger portal system that has been consuming the majority of my free time. There are already a couple of mini-hacks listed in the first post in this thread, plus there are a few others that I've posted throughout this thread that I will add to the first post as well once I get the time. If you have any suggestions for future versions or mini-hacks though please let me know. :)

Will the current version of myvbindex work with vB 3.0? Or once vB 3.0 isreleased say I got picked for private beta, would i have to delete myvbindex until you make a higher version for 3.0?

It's hard to say since I have no idea which variables and database tables will change, but it's very doubtful that everything would still work the same way. I've applied to beta test 3.0 as well, but since they're only picking 20 sites out of 600 that applied, I'll probably have to wait until the first public beta is released. Either way, as soon as I get my hands on 3.0 I will be rewriting the script since I will have to update it for my site as well, so I would expect to have it posted here within a couple of days after 3.0 is released.

I am sure that you have telled us how i can change the position of the boxes...

But my enlish is not so good that i can read the complete thread...

can somebody tell me how i can change the boxes and the positions...
specialy i want the last post box in the middle

i have deinstalled the portal....

i am sorry about it i nerv but i am an wbb user and a newbee in vb since yesterday

cu and thx
maxxxxxx

That is mostly just a matter of editing some html. If you edit your index template and move the whole table that has the $threadbits variable to right underneath the $newsbits variable that should do the trick. And you'll probably want to edit your index_threadbit template as well to change the way each thread is displayed.

quick question. Can I only show a custom box to registered users? I have the two custom boxes with one of them being links but we wanted to reserve that box for our members? Any easy way to do that?

I'm assuming you just want this to be displayed for a user that has registered, and it doesn't matter if they have activated their account or whatnot, just simply that they have registered... If so, just open your myvbindex.php and look for this line:
Replace that with:
If you don't want it to be displayed to users if they haven't yet activated their account, instead replace that with:

sorry if this has been posted before, but my images keep commin up as broken, any help?

on the myvbindex page in the news section their is those icons that print and mail to a friend. Well i want to change the icons to different ones but not have it affect the same icons on the forums. How can i do this?

Also my second question is I have a header.php file i want to load up on the myvbindex page that is different from the one on my forums. I know their is a post about this around post number 72 or such but i didnt understand what to do. I am trying to do a call function in the index_header template of the myvbindex group. I want this function to call that header.php file i have. Im not sure if this is possible or what. Basically in the header.php file is 1 table with an image in it. Can someone help me so that above the myvbindex page will be this image. Also eventually in this table i want to put code so that the image is a background and over to the right of it a banner also is their for sponsors.

Okay... news is not showing up at all. I looked in the post table and there isn't a isnews field.. please advise.. I have phpMyAdmin 2.3.2 thanks.

forum URL: http://www.serenepoets.com/myvbindex.php

Ok.. before I installed this hack I moved the forum to a new server... after installing everything and making the post above, I realized that I forgot to update my config.php to reflect the new settings... when I did that, I started getting a blank page at http://www.serenepoets.com/myvbindex.php however http://www.serenepoets.com/ still shows up fine... please help.

okay.. everything makes sense now... haha, sorry and thanks anyway :)

love the script.

I had a poll on my vbindex page. But now that I posted a new poll nothing is there and I can't get it to show up? Could it be because of the number of choices? I have 25 choices. I made sure that the polls id was still correct which is 16

just installed on 2.3.0 fresh install, no problems ^_^ works great

my first install i missed a step :bunny:

arracing - To change those images you would edit the index_newsbits_printable & index_newsbits_sendtofriend templates. As for the header file, could you not just put the image and table in the index_header template?

Yuber - What version of myvbindex & vbulletin are you using? Is the poll and thread open, or was it moved from another forum? What happens if you try to post another poll in the polls forum?

Faranth & alnany - Hope you enjoy the hack. :)

I have VBulletin 2.29 installed with VBindex 3.1
WWW.FRANKENBERRIE.COM

Now, I wanna upgrate to Vbulletin 2.30. Will I have to follow the steps of reinstallign VBindex after doing the 2.30 upgrade?

Look to see where the script is trying to find the images and if you don't have the coding expertise to change that, put the images there. ;)

Amy

frankenberrie - You will have to re-apply the 3 (or 4 if using the weather part) file modifications listed in the readme file. Other than that you shouldn't have to do anything else, but if you do run into problems let me know.

ok, so far everything looks good on my forums how ever the top section where the logo and buttons, looks like the default vbulletin sytle, the buttons and banner are correct, just not the layout

image attached is what it looks like