& [sql]
 ‘/(?<!\\\\)\[sql(?::\w+)?\](.*?)\[\/sql(?::\w+)?\]/sie‘								 => "highlight_sql(‘\\1‘);",
 ‘/(?<!\\\\)\[code(?::\w+)?\](.*?)\[\/code(?::\w+)?\]/sie‘							 => "highlight_code(‘\\1‘);",
 ‘/(?<!\\\\)\[php(?::\w+)?\](.*?)\[\/php(?::\w+)?\]/ise‘								 => "highlight_php(‘\\1‘);",
// [email]
 ‘/(?<!\\\\)\[email(?::\w+)?\](.*?)\[\/email(?::\w+)?\]/si‘							 => "<a href="mailto:\\1" class="bb-email">\\1</a>",
 ‘/(?<!\\\\)\[email(?::\w+)?=(.*?)\](.*?)\[\/email(?::\w+)?\]/si‘							 => "<a href="mailto:\\1" class="bb-email">\\2</a>",
// [url]
 ‘/(?<!\\\\)\[url(?::\w+)?\]www\.(.*?)\[\/url(?::\w+)?\]/si‘							 => "<a href="http://www.\\1" target="_blank" class="bburl">\\1</a>",
 ‘/(?<!\\\\)\[url(?::\w+)?\](.*?)\[\/url(?::\w+)?\]/si‘								 => "<a href="\\1" target="_blank" class="bb-url">\\1</a>",
 ‘/(?<!\\\\)\[url(?::\w+)?=(.*?)?\](.*?)\[\/url(?::\w+)?\]/si‘							 => "<a href="\\1" target="_blank" class="bb-url">\\2</a>",
// [img]
 ‘/(?<!\\\\)\[img(?::\w+)?\](.*?)\[\/img(?::\w+)?\]/si‘								 => "<img src="\\1" alt="\\1" class="bb-image" />",
 ‘/(?<!\\\\)\[img(?::\w+)?=(.*?)x(.*?)\](.*?)\[\/img(?::\w+)?\]/si‘						 => "<img width="\\1" height="\\2" src="\\3" alt="\\3"class="bb-image" />",
// [quote]
 ‘/(?<!\\\\)\[quote(?::\w+)?\](.*?)\[\/quote(?::\w+)?\]/si‘							 => "<div>Quote:<div class="bb-quote">\\1</div></div>",
 ‘/(?<!\\\\)\[quote(?::\w+)?=(?:"|"|\‘)?(.*?)["\‘]?(?:"|"|\‘)?\](.*?)\[\/quote\]/si‘			 => "<div>Quote \\1:<divclass="bb-quote">\\2</div></div>",
// 

 ‘/(?<!\\\\)(?:\s*<br\s*\/?>\s*)?\[\*(?::\w+)?\](.*?)(?=(?:\s*<br\s*\/?>\s*)?\[\*|(?:\s*<br\s*\/?>\s*)?\[\/?list)/si‘ => "\n<li class="bb-listitem">\\1</li>",
 ‘/(?<!\\\\)(?:\s*<br\s*\/?>\s*)?\[\/list(:(?!u|o)\w+)?\](?:<br\s*\/?>)?/si‘					 => "\n</ul>",
 ‘/(?<!\\\\)(?:\s*<br\s*\/?>\s*)?\[\/list:u(:\w+)?\](?:<br\s*\/?>)?/si‘						 => "\n</ul>",
 ‘/(?<!\\\\)(?:\s*<br\s*\/?>\s*)?\[\/list:o(:\w+)?\](?:<br\s*\/?>)?/si‘						 => "\n</ol>",
 ‘/(?<!\\\\)(?:\s*<br\s*\/?>\s*)?\[list(:(?!u|o)\w+)?\]\s*(?:<br\s*\/?>)?/si‘					 => "\n<ul class="bb-list-unordered">",
 ‘/(?<!\\\\)(?:\s*<br\s*\/?>\s*)?\[list:u(:\w+)?\]\s*(?:<br\s*\/?>)?/si‘						 => "\n<ul class="bb-list-unordered">",
 ‘/(?<!\\\\)(?:\s*<br\s*\/?>\s*)?\[list:o(:\w+)?\]\s*(?:<br\s*\/?>)?/si‘						 => "\n<ol class="bb-list-ordered">",
 ‘/(?<!\\\\)(?:\s*<br\s*\/?>\s*)?\[list(?::o)?(:\w+)?=1\]\s*(?:<br\s*\/?>)?/si‘					 => "\n<ol class="bb-list-ordered,bb-listordered-d">",
 ‘/(?<!\\\\)(?:\s*<br\s*\/?>\s*)?\[list(?::o)?(:\w+)?=i\]\s*(?:<br\s*\/?>)?/s‘					 => "\n<ol class="bb-list-ordered,bb-listordered-lr">",
 ‘/(?<!\\\\)(?:\s*<br\s*\/?>\s*)?\[list(?::o)?(:\w+)?=I\]\s*(?:<br\s*\/?>)?/s‘					 => "\n<ol class="bb-list-ordered,bb-listordered-ur">",
 ‘/(?<!\\\\)(?:\s*<br\s*\/?>\s*)?\[list(?::o)?(:\w+)?=a\]\s*(?:<br\s*\/?>)?/s‘					 => "\n<ol class="bb-list-ordered,bb-listordered-la">",
 ‘/(?<!\\\\)(?:\s*<br\s*\/?>\s*)?\[list(?::o)?(:\w+)?=A\]\s*(?:<br\s*\/?>)?/s‘					 => "\n<ol class="bb-list-ordered,bb-listordered-ua">",
// escaped tags like \, \[color], \[url], ...
 ‘/\\\\(\[\/?\w+(?::\w+)*\])/‘											 => "\\1"
 );
 $message = preg_replace(array_keys($preg), array_values($preg),$message);
 return $message;
}

///////////////////

function highlight_php($str)
{
 $tags_exists = true;

 $res = htmlspecialchars($str);
 $res = str_replace(array(‘<?php‘, ‘<?‘, ‘?>‘, ‘->‘,‘=>‘), array(‘<?php‘, ‘<?‘, ‘?>‘, ‘->‘, ‘=>‘), $res);

 if(strpos(‘<?‘, $res) === false)
 {
 $res = ‘<?php ‘.$res.‘ ?>‘;
 $tags_exists = false;
 }

$res = ‘<div class="bb-php">‘.highlight_string($res, true).‘</div>‘;
 if(!$tags_exists)
 {
 $res = str_replace(array(‘<?php‘, ‘<?‘, ‘?>‘, ‘<br/>‘), array(‘‘, ‘‘, ‘‘, ‘‘), $res);
 }

 return $res;
}

////////////////

function highlight_code($str)
{
 $res = ‘<div class="bb-code">‘.htmlspecialchars($str).‘</div>‘;
 return $res;
}

////////////

function highlight_sql($str) 
{
 $words = array(‘add‘, ‘auto_increment‘, ‘all‘, ‘alter‘,
 ‘analyze‘, ‘and‘,‘as‘, ‘asc‘, ‘before‘, ‘between‘, ‘bigint‘, ‘binary‘,‘blob‘,‘both‘, ‘by‘, ‘cascade‘, ‘case‘, ‘change‘, ‘character‘,‘check‘,
 ‘collate‘, ‘column‘, ‘columns‘, ‘constraint‘, ‘convert‘,‘create‘, ‘cross‘, ‘current_date‘, ‘current_time‘,‘current_timestamp‘,‘current_user‘, ‘database‘, ‘databases‘, ‘day_hour‘,‘day_microsecond‘,
 ‘day_minute‘, ‘day_second‘, ‘dec‘, ‘decimal‘, ‘default‘,‘delayed‘,‘delete‘, ‘desc‘, ‘describe‘, ‘distinct‘,‘distinctrow‘, ‘div‘,‘double‘, ‘drop‘, ‘dual‘, ‘else‘, ‘enclosed‘,‘escaped‘, ‘exists‘,
 ‘explain‘, ‘false‘, ‘fields‘, ‘float‘, ‘float4‘,‘float8‘, ‘for‘, ‘force‘, ‘foreign‘, ‘from‘, ‘fulltext‘, ‘grant‘,‘group‘, ‘having‘,
 ‘high_priority‘, ‘hour_microsecond‘, ‘hour_minute‘,‘hour_second‘,‘if‘, ‘ignore‘, ‘in‘, ‘index‘, ‘infile‘, ‘inner‘,‘insert‘, ‘int‘,‘int1‘, ‘int2‘, ‘int3‘, ‘int4‘, ‘int8‘, ‘integer‘,‘interval‘,‘into‘, ‘is‘, ‘join‘, ‘key‘, ‘keys‘, ‘kill‘, ‘leading‘,‘left‘,
 ‘like‘, ‘limit‘, ‘lines‘, ‘load‘, ‘localtime‘,‘localtimestamp‘,‘lock‘, ‘long‘, ‘longblob‘, ‘longtext‘, ‘low_priority‘,‘match‘,
 ‘mediumblob‘, ‘mediumint‘, ‘mediumtext‘, ‘middleint‘,‘minute_microsecond‘, ‘minute_second‘, ‘mod‘,‘natural‘, ‘not‘,‘no_write_to_binlog‘, ‘null‘, ‘numeric‘, ‘on‘,
 ‘optimize‘,‘option‘, ‘optionally‘, ‘or‘, ‘order‘, ‘outer‘,‘outfile‘,‘precision‘, ‘primary‘, ‘privileges‘, ‘procedure‘,‘purge‘, ‘raid0‘,‘read‘, ‘real‘, ‘references‘, ‘regexp‘, ‘rename‘,‘replace‘,
 ‘require‘, ‘restrict‘, ‘revoke‘, ‘right‘, ‘rlike‘,‘second_microsecond‘,‘select‘, ‘separator‘, ‘set‘, ‘show‘, ‘smallint‘,‘soname‘, ‘spatial‘,‘sql_big_result‘, ‘sql_calc_found_rows‘,‘sql_small_result‘, ‘ssl‘,
 ‘starting‘, ‘straight_join‘, ‘table‘, ‘tables‘,‘terminated‘, ‘then‘,‘tinyblob‘, ‘tinyint‘, ‘tinytext‘, ‘text‘, ‘to‘,‘trailing‘, ‘true‘,‘union‘, ‘unique‘, ‘unlock‘, ‘unsigned‘, ‘update‘,
 ‘usage‘, ‘use‘,‘using‘, ‘utc_date‘, ‘utc_time‘, ‘utc_timestamp‘,‘values‘, ‘varbinary‘,‘varcharacter‘, ‘varchar‘, ‘varying‘, ‘when‘, ‘where‘,‘with‘,‘write‘, ‘x509‘, ‘xor‘, ‘year_month‘, ‘zerofill‘,‘char‘
 );

 foreach ($words as $word)
 {
 $patterns[] = ‘/\b‘.$word.‘\b/i‘;
 $WORDS[] = ‘<span class="bb-sql-word">‘.strtoupper($word).‘</span>‘;
 }

 $res = ‘<div class="bb-sql">‘.preg_replace($patterns, $WORDS,$str).‘</div>‘;
 return $res;
}
/*
Ну, и, в финале, приведу список всех bb-кодов, которые умеет обрабатывать этот набор функций:
• [color=...]...[/color] – подкрашивает текст в указанный цвет
• [size=...]...[/size] – задает шрифту определенный размер
• [font=...]...[/font] – задает гарнитуру шрифта
• [align=...]...[/align] – задает выравнивание текста (left, right, center, justify)
• [b]... – жирный текст
• ... – наклонный шрифт
• ... – подчеркивание
• 
...
 – выравнивание по центру
• [sql]...[/sql] – раскраска SQL запроса
• [code]...