static function pretify($sql) { $position = 0; $completed = 0; $start = 0; $end = 0; $skips = null; $c = null; $literals = new _hx_array(array()); while ($position <= strlen($sql)) { $c = _hx_char_at($sql, $position++); switch ($c) { case "\\": $position += 1; break; case "'": $start = $position; $skips = system_base_Sql_colour::skippy(system_base_Sql_colour::$QUOTE, $sql, $position); $end = $skips->position; $skips = system_base_Sql_colour::now_in_colour($sql, $completed, $start, $end, null); $sql = $skips->string; $completed = $skips->position; $position = $completed + 1; break; case "\"": $start = $position; $skips = system_base_Sql_colour::skippy(system_base_Sql_colour::$QUOTES, $sql, $position); $end = $skips->position; $skips = system_base_Sql_colour::now_in_colour($sql, $completed, $start, $end, null); $sql = $skips->string; $completed = $skips->position; $position = $completed + 1; break; case "`": $start = $position; $skips = system_base_Sql_colour::skippy(system_base_Sql_colour::$REV_TICK, $sql, $position); $end = $skips->position; $skips = system_base_Sql_colour::now_in_colour($sql, $completed, $start, $end, system_base_Sql_colour::$REV_TICK); $sql = $skips->string; $completed = $skips->position; $position = $completed + 1; break; } } $sql = system_base_Sql_colour::now_in_colour($sql, $completed, $position, $position, null)->string; $sql = system_base_Sql_colour::$NEWLINE->replace($sql, "<br>"); $sql = system_base_Sql_colour::$TAB->replace($sql, " "); return $sql; }