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.

[tekguru]

Thanks for coming back to us. I'd have done that a few weeks ago but have had to wipe my test system from 3.7.x to go back to 3.6.8 to do soem other testing.

[4number8]

I tried that also and it didn't work, thanks for keeping us informed.

[tekguru]

A pity that - worth a try though!

[Dr. Bantham]

This is quite simply one of the most valuable mods to my site. I truly hope that we see it ported to 3.7, as it would be a great loss.

I have one issue which should be fairly simple for someone to resolve. I am using live sortable columns, which creates links in the header element. The header seems to be defaulting to a different CSS setting when it comes to links. It works well for the content rows (defaulting to the correct link colors for alt1 and alt2. However, a couple of my styles have table header backgrounds which are causing the column headers to be illegible when the links show.

I have had success modifying the header css by adding the following to Additional CSS Definitions:

PHP Code:

table.stg_table thead th {height:25px; font-weight:bold} 


What do I need to add to specify a link color for the header? I do not wish to impact the link colors of row content.

EDIT
I discovered the following comment in the sorttable.js:

PHP Code:

//link.className = 'sortheader'; 


Unfortunately, I tried the follow three settings to no avail:

PHP Code:

table.sortable thead th {color:#FFFFFF; font-weight: bold}
table.stg_table.sortable thead th {color:#FFFFFF; font-weight: bold}
table.stg_table sortable {color:#FFFFFF; font-weight: bold} 


[kylek]

Trying this out myself on 3.7.0 Beta 3 and get this error while attempting to install, could this be the problem with 3.7.0/

Database error in vBulletin 3.7.0 Beta 3:

Invalid SQL:
INSERT INTO vb3_bbcode VALUES (NULL, 'table', 'No code has to be inserted here.', '[table]column 1|column 2|column 3[/table]', 'With this vB code tables can be inserted into the post. Columns are seperated by ?|?, every new line is a new row.', 0, 'table', '');;

MySQL Error : Column count doesn't match value count at row 1
Error Number : 1136
Date : Monday, January 21st 2008 @ 03:33:06 AM
Script : http://www.xxxxx.xxx/forum/admincp/p...=productimport
Referrer : http://www.xxxx.xxx/forum/admincp/pl...?do=productadd

MySQL Version : 4.1.22-standard

[StGaensler]

Originally Posted by Dr. Bantham

What do I need to add to specify a link color for the header? I do not wish to impact the link colors of row content.

table.stg_table .sortheader {color:limegreen;}
will do it

Originally Posted by kylek

Trying this out myself on 3.7.0 Beta 3 and get this error while attempting to install, could this be the problem with 3.7.0/

Currently vB 3.7 is not supported. There are more bugs to fix - e.g. you can't save the preferences of my mod.
If you want, you can remove/comment out this query (<installcode>-block) this isn't really needed for operation. You only won't have entry in your custom bb codes - you can add one yourself.

Stefan

[Pod]

Originally Posted by StGaensler

If you want, you can remove/comment out this query (<installcode>-block) this isn't really needed for operation. You only won't have entry in your custom bb codes - you can add one yourself.

The query to add the BB code might not be working 'cause the table now has more rows? They added fields to delete the tag if it's empty, and to disable smilies and word-wrap inside.

[beastybob]

Just curious is it possible to only allow Admins access to use this in posts ? Just to prevent users stuffing the site. I want to start some news threads with a table of results and there is no need for users to have the option on my site.

If it can be set only for admins/moderators can someone please let me know

Thanks

[4number8]

Originally Posted by StGaensler

If you want, you can remove/comment out this query (<installcode>-block) this isn't really needed for operation. You only won't have entry in your custom bb codes - you can add one yourself.
Stefan

After doing this and testing it out on my test board, this seems to fix it with 3.7

Thanks

[Royalridge]

With a single modification to the product xml file this can be made to import on 3.7 and create the relevant bbcode table entry, however as always, I'd suggest waiting for the developer to release an approved version.