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]

Yippie! I found it!!
I previously had a bug with a quote box being at the end of a row: Something of vBulletin was "eating" the <br /> behind the </div> of the quote box. So I added a workaround for this which worked on my test server.
While trying to reproduce "your bug" I found out that if a post is submitted throug AJAX a linebreak is saved as "\n". If a post is submitted through normal answering (without AJAX) a linebreak is saved as "\r\n". My workaround only worked for the first version.

So uninstall my product, edit the xml of the product and replace the second line:

PHP Code:

#workaround for div-bug
$code = preg_replace('#(?<!:)</div>(\r)?\n#im','</div><br />',$code); 


(should be line 72 in the beta xml file) and install it again.
This workaround is not the best, but I don't know how to make it better. It would take to much time to explain why that is so...

This bug will also be fixed (as described) in the next version.

[ChiliVB]

Your mod looks terrific.

I have a couple questions that I didn't see covered in this thread.

1. I understand the table skin automatically fits the style.

Q: Is it possible to configure alternate colors (from the style) for the table header or lines within the table on the fly when making a new table?

2. We heavily utilize another bbtable plugin but the flexibility your mod has to use various types of vBcode in a table is inticing me to consider changing.

Q: Would it be possible for this mod to co-exist with the current mod we utilize (BB code tables 1.0) so all existing posts/tables would not have to be edited? This may not be something you can answer, and if so I understand.

[Keyser520]

Woudl you have a version that doesn't rename the existing "table" ?

[StGaensler]

Originally Posted by ChiliVB

Q: Is it possible to configure alternate colors (from the style) for the table header or lines within the table on the fly when making a new table?

Currently its only possible to format all "my" tables through css, but I plan to add a feature for defining the css class of the table and every individual tablerow. So this can be done with a future version by defining some other css classes for the table - but I can't really promise when this will be possible. Primarely I have to learn for my german "Abitur" (general qualification for university entrance), and I have to do other things, too. When I will find some time I will work on this issue.

Originally Posted by ChiliVB

Q: Would it be possible for this mod to co-exist with the current mod we utilize (BB code tables 1.0) so all existing posts/tables would not have to be edited? This may not be something you can answer, and if so I understand.

If you definitly plan to use my version in future, the best way would be to edit the source of the other mod so that he wil parse tables with a tag e.g. like [tableold], and change the current code in all posts. You won't have to edit all posts manually, this could be done automatically with some querys! So you can easily use my code, and updating will be very simple. If you do it the other way round you will have to edit the source code of my mod every time you want to update it. It is by you which way you want to go

Originally Posted by Keyser520

Woudl you have a version that doesn't rename the existing "table" ?

Basically not, but you can edit the xml-file to get such a version. Remove all code between and including <code version="0.0.1"> and </code> as well as <uninstallcode> and </uninstallcode>.
I think this will not solve your problem. If you do this, you will have two mods wanting to parse the same vB code. You will have to decide which one you want to use primarely, and rename the other (by editing the code of the mod).

[ChiliVB]

Installed! And my users and I are very, very happy with the format flexibility available with the vBCode Table mod.

Thanks to some !!excellent support!! from StGaensler I am now running the vBCode Table mod parallel with BB Code Tables mod so all older data posted with the legacy table tag is preserved. Migration was very smooth and users have a choice on which table code to utilize - the legacy tag or the new vBCode tags.

After the mod was installed users were creating tables with the new features and formating in less than 15 minutes. Several heavy table users only had to add a few format codes on spreadsheets to make cut and pasting data easy.

If you need tables or already utilize tables in your forums, this mods a great choice.

[ChiliVB]

I'm seeing an issue with the colsp option and I may just expect it to be doing more than is intended.

The colsp option works on the first line of the table, but if used in any other rows in the table it is producing the "colspan!!!" comment that you referred to earlier. If the colsp option is not intended to be used for other rows/cells I understand.

I have the beta xml installed. Attached is a screenshot of a test table. I can provide the actually table format in a txt file if needed for this example table.

[StGaensler]

I found two small mistakes I made and removed them - should work now. Thanks for feedback!

Just import this product (overwriting the old one).

EDIT: attachment removed (8 views) - new version is out: post #947182

[ChiliVB]

Working now after new version imported. Thank you! :classic:

[ChiliVB]

Is there an option or attribute at this time that can be used to "fill" cells/rows if they are not part of the header row?

This would allow us to have a divider in the table. I've attached a sample table with a row highlighted in pink to illustrate what I am asking.

[StGaensler]

Do you want to fill a table cell with text or with a colour?
The second will be possible in future, because I want to allow a user to choose the CSS class of the table and each individual row. Sorry, currently this is not possible. In your example I would add the comments below the table and would not include them into the table.