The Arcive of Official vBulletin Modifications Site.

BB Code [table] · **Released**: 02-13-2006

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:

Code:

[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

install attached product XML through product manager (overwrite existing)
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)

rename a existing BB code "table" to "table_saved"
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 · #**512** 10-05-2009, 03:21 PM

This is a great mod StGaensler!

I mashed up a little MS Excel file to auto-create tables up to 20 columns wide x 50 rows.

It doesn't support CSS or the colsp variables (yet?) but it lets me very quickly create the BB code for large tables in a WYSIWYG way.

If anyone wants to give it a run just let me know. I tried to avoid macros entirely (as you'll see from the coding), but Excel has a bug that doesn't allow clean copying of cell values with line returns...it embeds extra " marks in the clipboard.

RedHacker · #**513** 10-06-2009, 06:12 PM

Install 0.1.7.x....

How to worked....?

Alfa1 · #**514** 10-06-2009, 06:52 PM

An Excell like applet would be nice. Some of my members are climbing on the walls due to the table code.

I'll gladly try out your Excell file War.Frog

War.Frog · #**515** 10-07-2009, 12:50 AM

Quote:

Originally Posted by Alfa1

An Excell like applet would be nice. Some of my members are climbing on the walls due to the table code.

I'll gladly try out your Excell file War.Frog

Hi Alfa1...

Sure thing. Give this a run. There's no guarantee of some little glitches I haven't found, but it seems to create the tables accurately. Just enter the info into the main table (up to 20x50) and click the button to copy the table code to the clipboard.

Paste it into your post and you're done. Extra carriage returns are entered where empty rows exist but they're ignored by vBulletin.

Let me know how you make out!

BRotondi · #**516** 10-15-2009, 02:21 PM

1000 Thanks for this Add, Stefan!

And also for the Excel-Sheet, War.Frog! It seems not to work 100% on Excel 2007 though... perhaps I will find the time to debug it later...

Greetings, Bruno

War.Frog · #**517** 10-16-2009, 10:34 AM

Quote:

Originally Posted by BRotondi

1000 Thanks for this Add, Stefan!

And also for the Excel-Sheet, War.Frog! It seems not to work 100% on Excel 2007 though... perhaps I will find the time to debug it later...

Greetings, Bruno

Thanks Bruno. Hmm could be the macro? I noticed I leave an extra | character in the title row when that option is selected, resulting in extra right-side columns. I'll take a crack at this this weekend as well as cleaning up some of the formula code.

I hated having to use the macro, but Excel does not copy to clipboard nicely when there are carriage return characters in the source.

BRotondi · #**518** 10-16-2009, 02:42 PM

Hello War.Frog

Other Problems:

I always get 50 lines, even when I fill out only 2
Sorting gives a php-error, but could be also be a missunderstanding on my side.

I wait for your cleaned up code and give it a try again. Perhaps I can then see what has to be changed for Excel 2007. Which Excel do you use?

Greetings & Thanks!
Bruno

War.Frog · #**519** 10-16-2009, 03:52 PM

Quote:

Originally Posted by BRotondi

Hello War.Frog

Other Problems:

I always get 50 lines, even when I fill out only 2
Sorting gives a php-error, but could be also be a missunderstanding on my side.

I wait for your cleaned up code and give it a try again. Perhaps I can then see what has to be changed for Excel 2007. Which Excel do you use?

Greetings & Thanks!
Bruno

Hi Bruno...

Do you get 50 lines rendered in your table, or just 50 lines in the preview / entry window? The problem I found with Excel is, when I try to do a simple concatenation of the final table code and copy it to the clipboard, Excel adds extra " marks in the clipboard itself, even though they don't show on screen. To get around that, I copied the full 50-row set into the clipboard and vBulletin 3.8.4 seems to happily ignore the extra carriage returns.

I'll have a look at the sorting too. I made some changes from an earlier version but never gave sorting another run.

War.Frog · #**520** 10-17-2009, 01:07 AM

I fixed some of the coding here to try and make it a little more efficient - and work.

Sorting appears to work now, and I also added an Alignment selection for each column (left, center, right).

See how it runs on 2007 - this was created in Excel 2002 so I'm not sure if there are some inconsistencies with the formulas or macros. On 2002, there's no way around copying the full 50 rows to get the table code properly saved in the clipboard.

Have a try...

AfterWorldForum · #**521** 10-17-2009, 07:57 AM

Quote:

Originally Posted by War.Frog

To get around that, I copied the full 50-row set into the clipboard and vBulletin 3.8.4 seems to happily ignore the extra carriage returns.

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.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.06195 seconds Memory Usage 2,370KB Queries Executed 26 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (1)bbcode_code (4)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (4)navbar_link (120)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (3)pagenav_pagelinkrel (11)post_thanks_box (11)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (11)post_thanks_postbit_info (10)postbit (15)postbit_attachment (11)postbit_onlinestatus (11)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_attachment postbit_display_complete post_thanks_function_can_thank_this_post_start pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!