[SQL] - vB Code

This hack is more or less Selfexplaining as we use it since a long time on vb.org .
Credits go to Chen Avinadav for the original version for vBulletin 2.

It allows you and your users to use [ SQL] Tags to highlight special SQL Tags and so on.
example:
[SQL]
SELECT *
FROM user
LEFT JOIN userfield USING(userid)
[/sql]

most of the queries are working perfectly, just nested quotes can make problems, i'll try to fix these, soon

Enjoy

[Xenon]

just on the board

[Boofo]

If you want to be able to use the new codemaxlines variable that is in RC3 so the boxes won't ever go past the point that the others do now, you need to add:

PHP Code:

 // fetch height of block element
$blockheight = fetch_block_height($code); 


right above:

PHP Code:

 eval('$html = "' . fetch_template('bbcode_sql') . '";');
return $html; 


in the included functions_bbcodeparse_custom_created.php that comes with this hack. If you also add:

PHP Code:

 global $vbphrase, $stylevar; 


right under

PHP Code:

 function handle_bbcode_sql($code) 
{ 


in the same file, you can use the same code for the sql template for the box as the code template (with a few small modifications, of course) instead of hard-coding everything.

[Xenon]

seems there are changes in rc3 i never noticed ^^

[g-force2k2]

Nice Hack Xenon

Was wondering how when vb.org used to run vb2 people got the sql code to work, didn't even know it existed for vb2. Even though most places won't find this useful I find it interesting.

Cheers,
g-force2k2

[Xenon]

the vb2 version was written by Chen just for vb.org and was never released

i just ported it over to vb3, optimized it and then asked chen if i could release it.
i know that there are not much boards which can use it, but if at least one other board can use it, it was worth the release

[Boofo]

Originally Posted by Xenon

seems there are changes in rc3 i never noticed ^^

Just trying to help.

It took me a while with the padding not working right when following the other bbcode templates for the sql template. Then it hit me with the stylevar[cellpadding] variable they were using. I had hardcoded it into the template, but it is easier this way if you ever want to do a global change. The blockcodeheight is new in RC3 and doesn't quite work right yet. I reported it over to vb.com and they are wroking on it, I guess.

I even got the sql box (as well as the others) set up with the double-click that they had for vB2, totally revamped for vB3. It makes it alot easier now that the boxes are smaller.

[Xenon]

well i use a codebox height coded myself on vb.org, that'S why i have not noticed the rc3's as i have not reverted the templates

i'll add your fixes into my next installfile

[Boofo]

Can you share your height code until RC3 gets theirs working right?

If you want the double-click code for it, let me know. It works different with the pre tags than it did as a replacement with the td tags.

You can use the same template as one of the other bbcodes with that stuff added to the install file. No more having to hard-code it.

Oh, and we also added a SQL button to the editors. Just had to add something to 2 templates. Didn't have to mess with any js files. This vB3 is GREAT!!!

[Boofo]

Don't forget the add the SQL template to the showthread.php and the showpost.php, too.

[Xenon]

hmm, i think the height hack isn't that perfect, too.
at least sometimes it does things it shouldn't do

but i'll look at it at all