Forums arranged in columns on forumhome

As requested several times, this hack allows you to arrange forums on forumhome in xx columns instead of just one per row as it now.

You have to set up a new category(s). All direct subforums to this category(s) will be arranged in columns.
It can be very usefull if you have very much Subforums, so you haven't to scroll as much as you have before

Newest Version: 1.21
Known Bugs: none

Screenshots below.

Design can be changed in templates..

[omegauk]

That black border yes, can you see it?

[Corbu]

I like this hack !

Can you post how to do this : Insert images in a table ans "last post by " please Xenon ...

Such like in Yaxay forum...

Good job..

[croft]

well i cant get this to work =(
does these lines have anything to do with it and if so where do i put them ?INSERT INTO setting (settingid,settinggroupid,title,varname,value,desc ription,optioncode,displayorde r) VALUES (NULL,5,'Parent forums column arranged subforums','columnparent','0','Choose a Parent Forumid. All Subforums will be displayed in column arrangement (seperat with spaces)','','8')
INSERT INTO setting (settingid,settinggroupid,title,varname,value,desc ription,optioncode,displayorde r) VALUES (NULL,5,'Display Forum Columns','forumcols','4','','','9')

[Hooper]

Hi Croft.

The above are queries not php code. One Insert at a time, you install or query your database with the data so that the tables will have the above data inserted in to them. The above alters the database information.

You can use phpmyadmin, or if you know how, you can do this from a prompt. If you have never worked on a database before I would recommend phpmyadmin.

Stick this in the queries box. And then the second. Before you do anything, back up your database with a mysqldump.

INSERT INTO setting (settingid,settinggroupid,title,varname,value,desc ription,optioncode,displayorde r) VALUES (NULL,5,'Parent forums column arranged subforums','columnparent','0','Choose a Parent Forumid. All Subforums will be displayed in column arrangement (seperat with spaces)','','8')

[croft]

The above are queries not php code. One Insert at a time, you install or query your database with the data so that the tables will have the above data inserted in to them. The above alters the database information.

My problem is i have no idea what so ever how to insert these in to my DB =(
Is there a step by step solution for idiots like me ?
I love the hack by the way and i realy want this =)
If this works this will be my second hack i install wooohooo. as you might have moticed im new to the hack part of vb.. Have no idea what kind of hack is usefull and wich hacks are not...
This one is usefull tho and i want it..
Any help would be wery much apriciated =)
http://www.dabforum.com

[Hooper]

You are not an idiot. You have never added tables or inserted information into a database. This does not qualify for the term idiot.

I gave instructions for the easiest solution that I know of.
phpmyadmin. You will have to do some experimenting. If you are going to experiment with this hack, I would advise you to use 2.2.6 as the hack suggests it works with. 2.2.7 has issues with this hack.

[croft]

Well i exported the setting from my db.. can i yust past the things in the downloaded file or do i HAVE to set this up on the db itself ?
sorry for all these questions.

[Hooper]

You have to do as the installation instructions request.

You have to add the queries to the database so that the alterations are made. Once this has been completed, carry on with the rest of the hack. Do your database alterations (run quereies) before you move forward. This is really not very hard to accomplish. Being it's your first time altering vBulletin and the database, you will want to experiment as mentioned so that you can see how the changes work.

Do you have phpmyadmin?

[croft]

Yes i do.. im at it right now .... =)

[Hooper]

Super.

Ok. You simply and carefully copy one query at a time and paste the query into the box that says run a query. Once there and you are ready, hit the submit button. It will give you one of two things when you do this. You will get an error and explaination, or it will say something like inserted whatever into the database. This is important to be careful not to run the query on the wrong database if you have multiple databases. Be sure to chose the correct one.

Make sure you have selected the appropriate database and click on the database name at the top of the left hand column in phpmyadmin. You will find the querie box there.

Just a note, although phpmyadmin is alright for some things, do dumps and restores from the prompt.