Решил перегнать свой сайт на MySQLi, есть такая функция:
PHP:
скопировать код в буфер обмена
скопировать код в буфер обмена
- //Выводим блоки по позициям
- function show_blocks($position) {
- global $config, $already_used, $mysqli;
- //Использовать блоки ?
- if ($config['blocks']) {
- if (!$already_used) {
- $blocks_res = $mysqli->query("SELECT * FROM orbital_blocks WHERE active = 1 ORDER BY weight ASC");
- while ($blocks_row = $blocks_res->fetch_assoc())
- $orbital_blocks[] = $blocks_row;
- if (!$orbital_blocks)
- $already_used = true;
- }
- //Цикл
- foreach ($orbital_blocks as $block) {
- $bid = $block["bid"];
- $content = $block["content"];
- $title = $block["title"];
- $blockfile = $block["blockfile"];
- $bposition = $block["bposition"];
- if ($position != $bposition)
- continue;
- $view = $block["view"];
- continue;
- }
- if ($view == 0) {
- render_blocks($blockfile, $title, $content, $bid, $bposition);
- } elseif ($view == 1 && $CURUSER) {
- render_blocks($blockfile, $title, $content, $bid, $bposition);
- } elseif ($view == 2 && (get_user_class() >= UC_MODERATOR)) {
- render_blocks($blockfile, $title, $content, $bid, $bposition);
- } elseif ($view == 3 && (!$CURUSER || get_user_class() >= UC_MODERATOR)) {
- render_blocks($blockfile, $title, $content, $bid, $bposition);
- }
- }
- }
- }