[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

[squawell]

Originally Posted by Boofo

How would we add a button in the editor for this?

also want to know this

[Boofo]

Originally Posted by squawell

also want to know this

Hello there, sir. Where you been?

[squawell]

Originally Posted by Boofo

Hello there, sir. Where you been?

Hello,Bobim come from Asia ........nice to meet u

by the way...if anyone want to replace the word--SQL query to phrase

variable just open the file(functions_bbcodeparse_custom_created.php) find

PHP Code:

function handle_bbcode_sql($code) 
{ 


below it add:

PHP Code:

global $vboptions, $vbphrase, $stylevar; 


i test it,and it works...hope u guys like it

[Boofo]

Originally Posted by squawell

Hello,Bobim come from Asia ........nice to meet u

by the way...if anyone want to replace the word--SQL query to phrase

variable just open the file find

PHP Code:

function handle_bbcode_sql($code) 
{ 


below it add:

PHP Code:

global $vboptions, $vbphrase, $stylevar; 


i test it,and it works...hope u guys like it

Make sure you let them know which file to open.

I had already done this but why did you add the $stylevar and $vboptions to it?

[Xenon]

@Bob: if you want to use other variables within the template you have to add them as well, he just made an all in one thing

@Chris: hmm, i can think of it, maybe i'll do it

@Bob2: hmm, you have to add it o the main JS scripts, but as i don't know JS i cannot answer this

[squawell]

Originally Posted by Boofo

Make sure you let them know which file to open.

I had already done this but why did you add the $stylevar and $vboptions to it?

ok...ill edit my post above let others know

because i paste it from another file and LAZY to edit the code

[Boofo]

Originally Posted by squawell

ok...ill edit my post above let others know

because i paste it from another file and LAZY to edit the code

LOL Don't feel bad, I have done the same thing many times in the past. I had to also add $bbuserinfo to that line to allow my block codes hack to work.

[Boofo]

Originally Posted by Xenon

@Bob: if you want to use other variables within the template you have to add them as well, he just made an all in one thing

@Chris: hmm, i can think of it, maybe i'll do it

@Bob2: hmm, you have to add it o the main JS scripts, but as i don't know JS i cannot answer this

I was just razzin' him, Stefan.

The disable tags would be great if you decide you want to do it.

Wouldn't there be a way to just make a bbcode for the sql tags, without having to add the code that is? That allows buttons to be entered in the editor.

[Xenon]

Wouldn't there be a way to just make a bbcode for the sql tags, without having to add the code that is? That allows buttons to be entered in the editor.

not that i know of, as you have to call some functions...
also i'm a purist, so i don't use the editors, a plain textbox is really enough for me

[gmarik]

Do you use it over the board or somewhere in the admin panel as well?