[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

[PET]

is there any posibility how can i add this as a...icon in bbcode's icons ?

Boofo, i have seen that on your site...share ?

[Boofo]

Evil made the icon. I suppose we could share it with you.

[Xenon]

I've uploaded a new version now.

all yu have to do is to replace the functions file, i've just optimized the parser a bit

[SamirDarji]

Wow, is this a dangerous hack. The DROP TABLE function comes to mind and scares me.

[Xenon]

erm, this hack does not execute any SQL statement, it just displays it in a highlighted way. exactly as the [php] tag doesn't execute PHP code

[SamirDarji]

Originally Posted by Xenon

erm, this hack does not execute any SQL statement, it just displays it in a highlighted way. exactly as the [php] tag doesn't execute PHP code

Oops! That makes more sense. Excuse my ignorance. I think I've been working too hard...

[Xenon]

*gg*
no problem, everyone knows such days

[mikaelweb1]

Add New BB Code
Title?
Tag?
Replacement ?
Example?
Use {option} yes or no
Button Image (Optional)

to same plase as [php] is how do i make this hapen ????????

[Xenon]

read the install file, such codes cannot be done via the ACP, it needs file changes

[mikaelweb]

alll code and SQL is same now

if ($vboptions['allowedbbcodes'] & ALLOW_BBCODE_CODE)
{
// [SQL]
$bbcodes['custom']['find']['[sql]'] = '#\[sql\](.*)\[/sql\]#esiU';
$bbcodes['custom']['replace']['[sql]'] = "handle_bbcode_sql('\\1')";
$bbcodes['custom']['recurse']['sql'][0] = array('handler' => 'handle_bbcode_sql');
}

what is this to SQL CODE

define('ALLOW_BBCODE_BASIC', 1);
define('ALLOW_BBCODE_COLOR', 2);
define('ALLOW_BBCODE_SIZE', 4);
define('ALLOW_BBCODE_FONT', 8);
define('ALLOW_BBCODE_ALIGN', 16);
define('ALLOW_BBCODE_LIST', 32);
define('ALLOW_BBCODE_URL', 64);
define('ALLOW_BBCODE_CODE', 128);
define('ALLOW_BBCODE_PHP', 256);
define('ALLOW_BBCODE_HTML', 512);