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.

[War.Frog]

Originally Posted by AfterWorldForum

Ran into the same problem. I modified your Excelsheet to suit our needs, and then removed the additonal pipe char from the second sheet.

Whenever I tried copy/pasting, somehow I'd end up with an extra table head line. The problem is the internal Excel markup (I think). Problem can be solved by copy/pasting into notepad, then selecting all in there, and pasting into vB.

I fixed the extra bar issue in v 1.4. It works pretty well but I'm not sure if the extra returns affect different versions of vBulletin.

I'd love to include bold and colspan, but I don't know how I'd do cell-by-cell properties without making it clunky. I am, however, going to add bolding option to the header row and at column level.

[Wired1]

Keep us updated! I can think of some uses for this when polished.

[trotskid]

Hi. If sort a column of numbers with "." or "," (Project column), the values does not sort properly. For example:

30,274,388 will post higher than 101,274,388 (3>1).

How can I fix that with the current code?

Thank you

PHP Code:

[table="head;sort=2d;autonum=1;autonumtitle=Rank;width=65%"]xxxx|Project|Points|P/day|National

test1|30,274,388|68,520|60|3|

test2|101,274,388|50,956|80|2|

test3|20,274,388|21,325|29|6|

[/table] 


[mickknutson]

I am trying to get this to work with Vault Wiki.

http://www.blincmagazine.com/forum/w...cs?redirect=no

I used this code, but still only ever get 1 row and no head row:

[table="head;sort=2d,2;class=head;cellpadding=4;cellspacing=1;border=1"]ObjectType|Number
Building|0
Antenna|0
Span|0
Earth|23[/table]

[BRotondi]

Still did not work in 2007 because the simple copy now adds some differen CRs -> you would need to paste it as text only (through Notepad or in simple Editor mode)

I solved this and reduzed the 50 lines to "auto" in the attached version. Does it work on 2002?

Regards, Bruno

[MagicThemeParks]

Great work guys, keep at it! :up:

If you can get a true, glitch-free option for bringing the info straight over from Excel, then it would take this mod to the stratosphere!

[BRotondi]

Hmmm... but I don't get live sort to work...
- sorttable.js copied to clientscripts
- enabled in the settings

... still no clickable header...

Thanks for any help!
Bruno

[BRotondi]

O.K. Another "Known Bug" or "minor problem": Table will not be sortable after ajax-Editing the post. You have to reload the page!

And: Be sure to use [table="head"], else you have no head to sort

Bruno

[BRotondi]

And another Bug: One CR will be deleted after [/table] each time you press "Preview"

...[/table]

Text

->

...[/table]
Text

->

...[/table]Text

Greetings, Bruno

Edit: Interesting: Does not happen any more since I installed live sort...

[BRotondi]

Perhaps you've seen, that sorting will use the default asc/desc image which sometimes makes the next column header unreadable. Workaround: These little Icons from Windows Explorer. Save them e.g. on /images/sort*.png and change the path in sorttable.js:

    if (span.getAttribute("sortdir") == 'down') {
        ARROW = '&nbsp;<img src="/images/sortasc.png" />';
        newRows.reverse();
        span.setAttribute('sortdir','up');
    } else {
        ARROW = '&nbsp;<img src="/images/sortdesc.png" />';
        span.setAttribute('sortdir','down');
    }

Example

Greetings, Bruno