SQL BBCode

[Adrian Schneider]

The SQL bbcode is extremely glitchy.

If you preview/edit it, then it actually renders it into the WYSIWG as formatted text and previewing or submitting will destroy your original code.

[Dream]

Some of my members reported similar behavior. Isn't it a stock vBulletin problem?

[Wayne Luke]

Some of my members reported similar behavior. Isn't it a stock vBulletin problem?
There is no SQL bbcode in a default vBulletin.

[Adrian Schneider]

Any update on this? It's a major flaw when posting any SQL.

[Marco van Herwaarden]

Never seen it destroy original code, what i have experienced is that (when using preview???) sometimes 2 extra /SPAN are somehow added outside of the box. This might affect layout after the SQL code but i have never seen it make any changes to the code itself.

[Adrian Schneider]

SQL Query: (how to run queries (http://www.vbulletin.com/docs/html/maintenance_query))
UPDATE TABLE ohnoes;

^^ final result.

Progress / reproduction pictures attached.

[Dream]

There is no SQL bbcode in a default vBulletin.

Oh nevermind, I thought he was talking about the preview button messing text in general.

[Adrian Schneider]

Still an issue...

[Opserty]

I get this too. :)

[Paul M]

Sorry, but its likely to remain an issue for the moment. I have no idea who wrote it, or the time to investigate how it works. I dont know if anyone else has time. All I can suggest for now is that you dont use the WYSIWG editor to preview it. I know thats not ideal, but thats how it is for the moment.

[Opserty]

Just in case, class_bbcode_alt.php has an array of tags to ignore when parsing for the WYSIWYG editor you could maybe add SQL to the array somehow. Might not work, but I saw it yesterday so just thought I'd mention it :D

[Lizard King]

Just in case, class_bbcode_alt.php has an array of tags to ignore when parsing for the WYSIWYG editor you could maybe add SQL to the array somehow. Might not work, but I saw it yesterday so just thought I'd mention it :D
You saved me a lot of headache :) Thanks for the tip ;)

[Boofo]

I think the SQL tags were were written by Xenon a long time back. I have no idea who has updated it here since then.

[Paul M]

Just in case, class_bbcode_alt.php has an array of tags to ignore when parsing for the WYSIWYG editor you could maybe add SQL to the array somehow. Might not work, but I saw it yesterday so just thought I'd mention it :D
Thanks. I'll have a look at that in the next few days, if its that simple then it will get fixed.

[Dismounted]

I've just had a look, and this might work (looked in 3.7 files though). Create a plugin at bbcode_create. Add this PHP:
if ($this->is_wysiwyg() AND (isset($this->tag_list['no_option']['sql']) OR isset($this->tag_list['option']['sql'])))
{
unset($this->tag_list['no_option']['sql'], $this->tag_list['option']['sql']);
}