vb.org Archive - SQL BBCode

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin.org Site Feedback (https://vborg.vbsupport.ru/forumdisplay.php?f=7)

- - SQL BBCode (https://vborg.vbsupport.ru/showthread.php?t=168734)

Adrian Schneider

01-25-2008 09:18 PM

SQL BBCode

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

01-26-2008 06:33 AM

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

Wayne Luke

01-27-2008 12:20 PM

Quote:

Originally Posted by Dream (Post 1429125)

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

01-28-2008 06:06 AM

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

Marco van Herwaarden

01-28-2008 06:16 AM

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

01-28-2008 06:55 AM

1 Attachment(s)

SQL Query: (how to run queries)
UPDATE TABLE ohnoes;

^^ final result.

Progress / reproduction pictures attached.

Dream

01-28-2008 12:15 PM

Quote:

Originally Posted by Wayne Luke (Post 1430017)

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

06-17-2008 11:17 PM

Still an issue...

Opserty

06-18-2008 06:14 AM

I get this too. :)

Paul M

06-18-2008 10:22 AM

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

06-18-2008 11:03 AM

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

06-18-2008 11:25 AM

Quote:

Originally Posted by Opserty (Post 1552495)

You saved me a lot of headache :) Thanks for the tip ;)

Boofo

06-18-2008 12:06 PM

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

06-18-2008 03:00 PM

Quote:

Originally Posted by Opserty (Post 1552495)

Thanks. I'll have a look at that in the next few days, if its that simple then it will get fixed.

Dismounted

06-19-2008 06:43 AM

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:

PHP Code:


		
			
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']);
}

All times are GMT. The time now is 03:45 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01207 seconds Memory Usage 1,747KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_php_printable (4)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (15)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.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/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.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 printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: