BB Code Enhancements - BB Code [table]

BB Code [table]
by StGaensler

Description
This Hack provides a BB code [table] to add a table to the post
The skin of the table automatically fits the style because the CSS classes of vBulletin are used.

A table is simply made of some lines (will be the rows). The cols are seperated by |. So this will be a table:

[table="head"]head col1|head col2|head col3
row1 col1|row1 col2|row1 col3
row2 col1|row2 col2|row2 col3[/table]

A screenshot of a "ready" table is attached

Usage

1. install attached product XML through product manager (overwrite existing)
2. install at least one language pack in AdminCP -> Languages & Phrases -> Download / Upload Languages -> Import Language XML File
   Important: Select the language you want to import the phrases into, not "(Create New Language)" - this won't work! If you use another version of vBulletin than I use enable "Ignore Language Version" to import the language pack.

Please note: (installing)
Installing this product will: (reverted during uninstall)

1. rename a existing BB code "table" to "table_saved"
2. add a new BB code [table]

If you want to have live sortable columns (JavaScript): Download attached sorttable.js.txt rename it to sorttable.js and place it into the /clientscript/ folder of your vBulletin. Then go to AdminCP -> vBulletin Options -> BB Code [table] Settings -> Enabled Features Of This BB Code and enable sortable
Note: Including the file on the webpages where it is necessary is done by my product. So if sortable is disabled, it won't be included automatically.
If you want to have a icon for the editor you may use this for free: Download this icon and place it in your /images/editor/ folder.

Please note: (usage)

• Of course you can use vB Code and smilies inside the table!
• The first line defines how much columns are in the table. If the other lines have more or less colums they are cut off or filled with   (space)
• You can find a detailed description of the options (please read it before requesting help)
• Empty rows are (should be ) removed.

New features

• define colspan of cells
• small panel in AdminCP
• define CSS class of table and tablerows
• live sorting of table through clicking the head of a column
• defining maximum width of a table

Maybe planned features

• detailed description of the vB Code in misc.php?do=bbcode depending on the features enabled in AdminCP (planned for next beta version)
• define formatting (bold, italic), align (left, right, center) and width of the cols

Suggested but not planned features

• none

Known problems

• Bugfix of version 0.1.1 doesn't work if vBulletin should write template names into the source code

Version history:
0.0.1 - 0.0.5 internal releases for testing purposes (Thanks to Zombie79 from powerforen.de for testing)
0.1 first official release
0.1.1 fixed small bug: if a line ends with eg vbcode quote no new row was generated (should already have been fixed but did not work)
0.1.2 workaround: removed call to function bcmod(), it could also be done another way
0.1.3.x beta version described here (and following) - added admin panel, colpan and css feature
0.1.4 stable version - no significant changes to the last beta (0.1.3.8)
0.1.5.x beta version described here (and following) - added sortable, maxwidth, versioncheck, upgrade message, compatibility to vB 3.6
0.1.6 stable version - two bugfixes to last beta, {br} for posting linebreaks in a tablecell
0.1.7.x stable version - compatibility to vB 3.7 (description) - added tab seperated tables

This hack can be used for free. If you want to make a small donation, just contact me. We will find a way
I don't want this product to be distributed from other sources. Please don't upload it to other vBulletin related boards etc.

[StGaensler]

1.) Yes, but remember post #127.

2.) I don't really know how this could be done. As far as I know don't I have the usergropid of the user on the place where my code works. There is a mod out there for those things but I also don't know if it supports mine.

[ricknlida]

I'm sorry I missed that. I couldn't remember if I asked or not so searched this thread for $3.5" and got zero results.

[PJSkiboy]

OK, I am giving into the fact that I'm retarded over this. I can not get the cellpadding turned off using this bbcode. I am assuming i'm not using the correct syntax. I've read the first post, the examples given throughout the thread, I'm just simply missing something I think.

I tried something like this, but no luck.

[table cellpadding=0]

I've also tried using quotes and what not, but I can't get the cellpadding to go away. A little help would be appreciated, thanks.

Edit: OK, I've read every post in this thread and I see now that this is all tied to the CSS definitions. I've tried syntax posted by the author to this same question. To me, the answer is not very clear, but I guess I'll keep plugging away.

2nd Edit: My head hurts now, but alas, I did it. With the help of the author and evesve, I have solved my problem. If anyone has issues getting the css definitions put in the right place and figuring out the syntax involed in calling them properly, feel free to give me a shout about this. I'm sure the author doesn't want to explain all of this ever again, lol.

Thanks again Stefan for a very userful mod. I definitely appreciate all the work that goes into this.

[Juum]

Hi,

Thanks for the mod!

One thing though: I'm using itemstats clicky. I want to be able to make the [item] and [/item] tags inside the table, but when i do so it just inputs the data that should pop up into the actual table cell, consequently messing the whole table up and being 100 times larger than it should.

Any idea's?

Thanks in advance!

[GBSteve]

Stefan,

Have you given any thought to improving the javascript file to correctly sort numbers? I love this mod and use it in combination with the Forms mod. I'll continue to use it but the fact that it can't correctly sort numbers is a little irritating for me.

Thoughts?

[StGaensler]

Originally Posted by Juum

I want to be able to make the [item] and [/item] tags inside the table, but when i do so it just inputs the data that should pop up into the actual table cell, consequently messing the whole table up and being 100 times larger than it should.

I can't reproduce this with the original itemstats code, but with the modification made by Zachariah. This adds some line breaks (<br />) to the output - these have to be replaced:

This is one line<br />and the next line

should get

<p>This is one line</p><p>and the next line</p>

This is necessary because my mod interprets every linebreak as a new tablerow.

Originally Posted by GBSteve

Have you given any thought to improving the javascript file to correctly sort numbers?

No I don't have any idea how to do it. As I stated in the javascript file it is from http://www.kryogenix.org/code/browser/sorttable/ so please ask him to fix it.

[ChiliVB]

I have been talking with Stefan off and on for a long time experimenting with various versions WOW Itemstats to try and make it work with his tables code.

I was able to get everything working together today utilizing Blackjack's gitemstats version (and itemstats 1.5.5 core module) located here.

After upgrading my forums to 3.6.5 last night and installing Blackjack's gitemstats it all came together and works like a charm. And, there was no tweaking or special workarounds, it just works!

[ChiliVB]

Has anyone tried to define a custom table class that utilizes an image on the first row (header row of the table) ?

Using the following results in the alt2 image continuing to display on row 1 of the table:

 
/* ***** Test Table *****/
.stg_table_test {border:1px; padding: 2px;}
.stg_table_test th {background-image: url(forums/images/style/head.gif);}
.stg_table_test td {border: 1px; #C08F52 solid;}
.stg_table_test .alt1 {background-image: url(forums/images/style/alt1.gif); }
.stg_table_test .alt2 {background-image: url (forums/images/style/alt2.gif); }
/* ***** Test Table End *****/

I also tried using .stg_table_test th {background:#FFF} just to see if I could turn the background for the first row white but it continued to display the alt2 image.

I must be missing something.

[ArchangelX]

Does this work in 3.5.3? From reading this thread, it seems that it should? I'm getting this error:

Database error in vBulletin 3.5.3:

Invalid SQL:

### INSERT QUERY GENERATED BY fetch_query_sql() ###
INSERT INTO plugin

MySQL Error  : Unknown column 'executionorder' in 'field list'
Error Number : 1054

See the attached file for the rest...

What am I doing wrong?

[ChiliVB]

Originally Posted by ArchangelX

Does this work in 3.5.3? From reading this thread, it seems that it should? I'm getting this error:

Database error in vBulletin 3.5.3:
 
Invalid SQL:
 
### INSERT QUERY GENERATED BY fetch_query_sql() ###
INSERT INTO plugin
 
MySQL Error  : Unknown column 'executionorder' in 'field list'
Error Number : 1054

See the attached file for the rest...

What am I doing wrong?

Archangel - it works on 3.5.x versions.

This post (#127 in this thread) by Stefan will help with the error you are getting trying to install.