function popular($skin_dir = 'basic', $pop_cnt = 7, $date_cnt = 3)
{
    global $config, $g5;
    if (!$skin_dir) {
        $skin_dir = 'basic';
    }
    $date_gap = date("Y-m-d", G5_SERVER_TIME - $date_cnt * 86400);
    $sql = " select pp_word, count(*) as cnt from {$g5['popular_table']} where pp_date between '{$date_gap}' and '" . G5_TIME_YMD . "' group by pp_word order by cnt desc, pp_word limit 0, {$pop_cnt} ";
    $result = sql_query($sql);
    for ($i = 0; $row = sql_fetch_array($result); $i++) {
        $list[$i] = $row;
        // 스크립트등의 실행금지
        $list[$i]['pp_word'] = get_text($list[$i]['pp_word']);
    }
    ob_start();
    if (G5_IS_MOBILE) {
        $popular_skin_path = G5_MOBILE_PATH . '/' . G5_SKIN_DIR . '/popular/' . $skin_dir;
        $popular_skin_url = G5_MOBILE_URL . '/' . G5_SKIN_DIR . '/popular/' . $skin_dir;
    } else {
        $popular_skin_path = G5_SKIN_PATH . '/popular/' . $skin_dir;
        $popular_skin_url = G5_SKIN_URL . '/popular/' . $skin_dir;
    }
    include_once $popular_skin_path . '/popular.skin.php';
    $content = ob_get_contents();
    ob_end_clean();
    return $content;
}

 public function Footer()
 {
     parent::Footer();
     $this->SetXY(IanseoPdf::sideMargin, $this->h - $this->savedBottomMargin);
     $this->MultiCell(70, 5, $this->copy2, 0, "L", 0);
     //$this->Line(195, $this->tMargin, 195, $this->tMargin+50);
     //$this->Line(195, $this->tMargin+60, 195, $this->tMargin+110);
     $this->StartTransform();
     $this->setXY(195, $this->tMargin + 50);
     $this->Rotate(90);
     $this->Cell(45, 5, get_text('OrgResponsible', 'Tournament'), 'T', 0, 'C');
     $this->setXY(195, $this->tMargin + 100);
     $this->Rotate(90);
     $this->Cell(45, 5, get_text('Judge', 'Tournament'), 'T', 0, 'C');
     $this->setXY(185, $this->tMargin + 175);
     $this->Rotate(90);
     $this->SetFont('barcode', '', 40);
     $this->Cell(65, 15, IsBlocked(BIT_BLOCK_REPORT) ? '*' . str_replace(".", "", $this->validationCode) . '*' : '', 0, 0, 'C');
     $this->setXY(185, $this->tMargin + 235);
     $this->Rotate(90);
     $this->SetFont($this->FontFix, 'B', 20);
     $this->Cell(50, 15, IsBlocked(BIT_BLOCK_REPORT) ? $this->validationCode : get_text('TourNoBlock', 'Tournament'), 0, 0, 'C');
     $this->StopTransform();
     if (!IsBlocked(BIT_BLOCK_REPORT)) {
         $this->WaterMark(get_text('TourNoBlock', 'Tournament'));
     }
 }

 function step2()
 {
     if (!$this->input->post('w')) {
         goto_url('/');
     }
     $not_mb_id = $this->input->post('not_mb_id');
     if ($not_mb_id) {
         $title = '회원아이디 찾기 결과';
     } else {
         if (!$not_mb_id || $this->session->flashdata('mb_idpwd')) {
             $title = '비밀번호 찾기 2단계';
         }
     }
     $mb = $this->Member_forget_model->check();
     if (isset($mb['mb_id'])) {
         if ($mb['mb_id'] == ADMIN) {
             alert('관리자 아이디는 접근 불가합니다.');
         }
     } else {
         alert('입력하신 내용으로는 회원정보가 존재하지 않습니다.', 'member/forget_idpwd');
     }
     $this->load->helper('textual');
     $mb['mb_password_q'] = get_text($mb['mb_password_q']);
     $head = array('title' => $title);
     $data = array('time' => time(), 'mb_id' => $mb['mb_id'], 'mb_password_q' => $mb['mb_password_q']);
     widget::run('head', $head);
     $this->load->view('member/forget_' . ($not_mb_id ? 'id' : 'pwd'), $data);
     widget::run('tail');
 }

 function lists($flag, $page)
 {
     $this->load->helper('sideview');
     $this->load->library('pagination');
     $member = unserialize(MEMBER);
     if (!$flag) {
         $flag = 'R';
     }
     if (!$page) {
         $page = 1;
     }
     // 설정일이 지난 메모 삭제
     $this->Member_memo_model->cf_delete($member['mb_id']);
     if ($member['mb_memo_call']) {
         $this->Member_memo_model->call_delete($member['mb_id']);
     }
     $config['base_url'] = RT_PATH . '/member/memo/lists/' . $flag . '/';
     $total_cnt = $this->Member_memo_model->total_cnt($flag, $member['mb_id']);
     $config['total_rows'] = $total_cnt;
     $config['per_page'] = 10;
     $this->pagination->initialize($config);
     $offset = ($page - 1) * $config['per_page'];
     $result = $this->Member_memo_model->list_result($flag, $member['mb_id'], $config['per_page'], $offset);
     $list = array();
     $token = get_token();
     foreach ($result as $i => $row) {
         $name = $this->config->item('cf_use_nick') && $row['mb_nick'] ? $row['mb_nick'] : $row['mb_name'];
         $check = 'X';
         $check_time = '아직 읽지 않음';
         if (substr($row['me_check'], 0, 1) != '0') {
             $check = 'O';
             $check_time = substr($row['me_check'], 2, 14);
         }
         $list[$i] = new stdClass();
         $list[$i]->me_no = $row['me_no'];
         $list[$i]->check = $check;
         $list[$i]->check_time = $check_time;
         $list[$i]->name = get_sideview($row['me_mb_id'], $name);
         $list[$i]->datetime = substr($row['me_datetime'], 2, 14);
         $list[$i]->content = cut_str(get_text($row['me_content']), 40);
         $list[$i]->view_href = RT_PATH . '/member/memo/view/' . $flag . '/' . $row['me_no'];
         $list[$i]->del_href = '_trans/member/memo_delete';
         $list[$i]->del_parm = "{flag:'" . $flag . "',me_no:'" . $row['me_no'] . "',token:'" . $token . "'}";
     }
     if ($flag == 'R') {
         $flag_title = '받은';
         $me_subject = '보낸이';
     } else {
         if ($flag == 'S') {
             $flag_title = '보낸';
             $me_subject = '받는이';
         }
     }
     $head = array('title' => "내 쪽지함");
     $data = array('token' => $token, 'path' => RT_PATH . '/member', 'flag_title' => $flag_title, 'total_cnt' => number_format($total_cnt), 'memo_del_day' => $this->config->item('cf_memo_del'), 'me_subject' => $me_subject, 'list' => $list, 'flag' => $flag, 'paging' => $this->pagination->create_links());
     widget::run('head', $head);
     $this->load->view('member/memo_list', $data);
     widget::run('tail');
 }

function getBoardTable($bo_table)
{
    global $g5_board;
    $sql = " select * from {$g5_board} where bo_table = '{$bo_table}' ";
    $board = sql_fetch($sql);
    $bo_subject = get_text($board['bo_subject']);
    return [$board, $bo_subject];
}

function NumFormat($TheNum, $Dec = 0)
{
    if (is_numeric($TheNum)) {
        return number_format($TheNum, $Dec, get_text('NumberDecimalSeparator'), get_text('NumberThousandsSeparator'));
    } else {
        return 0;
    }
}

function outlogin($skin_dir = 'basic')
{
    global $config, $member, $g5, $urlencode, $is_admin, $is_member;
    if (array_key_exists('mb_nick', $member)) {
        $nick = get_text(cut_str($member['mb_nick'], $config['cf_cut_name']));
    }
    if (array_key_exists('mb_point', $member)) {
        $point = number_format($member['mb_point']);
    }
    if (preg_match('#^theme/(.+)$#', $skin_dir, $match)) {
        if (G5_IS_MOBILE) {
            $outlogin_skin_path = G5_THEME_MOBILE_PATH . '/' . G5_SKIN_DIR . '/outlogin/' . $match[1];
            if (!is_dir($outlogin_skin_path)) {
                $outlogin_skin_path = G5_THEME_PATH . '/' . G5_SKIN_DIR . '/outlogin/' . $match[1];
            }
            $outlogin_skin_url = str_replace(G5_PATH, G5_URL, $outlogin_skin_path);
        } else {
            $outlogin_skin_path = G5_THEME_PATH . '/' . G5_SKIN_DIR . '/outlogin/' . $match[1];
            $outlogin_skin_url = str_replace(G5_PATH, G5_URL, $outlogin_skin_path);
        }
        $skin_dir = $match[1];
    } else {
        if (G5_IS_MOBILE) {
            $outlogin_skin_path = G5_MOBILE_PATH . '/' . G5_SKIN_DIR . '/outlogin/' . $skin_dir;
            $outlogin_skin_url = G5_MOBILE_URL . '/' . G5_SKIN_DIR . '/outlogin/' . $skin_dir;
        } else {
            $outlogin_skin_path = G5_SKIN_PATH . '/outlogin/' . $skin_dir;
            $outlogin_skin_url = G5_SKIN_URL . '/outlogin/' . $skin_dir;
        }
    }
    // 읽지 않은 쪽지가 있다면
    if ($is_member) {
        $sql = " select count(*) as cnt from {$g5['memo_table']} where me_recv_mb_id = '{$member['mb_id']}' and me_read_datetime = '0000-00-00 00:00:00' ";
        $row = sql_fetch($sql);
        $memo_not_read = $row['cnt'];
        $is_auth = false;
        $sql = " select count(*) as cnt from {$g5['auth_table']} where mb_id = '{$member['mb_id']}' ";
        $row = sql_fetch($sql);
        if ($row['cnt']) {
            $is_auth = true;
        }
    }
    $outlogin_url = login_url($urlencode);
    //$outlogin_action_url = G5_HTTPS_BBS_URL.'/login_check.php';
    $outlogin_action_url = G5_BBS_URL . '/login_check.php';
    ob_start();
    if ($is_member) {
        include_once $outlogin_skin_path . '/outlogin.skin.2.php';
        // 로그인 후
    } else {
        include_once $outlogin_skin_path . '/outlogin.skin.1.php';
        // 로그인 전
    }
    $content = ob_get_contents();
    ob_end_clean();
    return $content;
}

 function Footer()
 {
     // Position at 1.5 cm from bottom
     $this->SetY(-15);
     // Arial italic 8
     $this->SetFont('Arial', 'I', 8);
     // Page number
     $this->Cell(0, 10, get_text('Page') . ' ' . $this->PageNo() . '/{nb}', 0, 0, 'C');
 }

function get_convert($row, $board, $subject_len = 60, $qstr, $list_view = FALSE)
{
    $row['href'] = RT_PATH . '/board/' . BO_TABLE . '/view/wr_id/' . $row['wr_id'] . $qstr;
    $row['subject'] = cut_str(get_text($row['wr_subject']), $subject_len);
    $tmp_name = cut_str(get_text($row['wr_name']), 14);
    $row['name'] = $board['bo_use_sideview'] ? get_sideview($row['mb_id'], $tmp_name) : "<span class='" . ($row['mb_id'] ? 'member' : 'guest') . "'>" . $tmp_name . "</span>";
    // 당일인 경우 시간으로 표시함
    $row['datetime'] = substr($row['wr_datetime'], 0, 10);
    $row['datetime2'] = $row['datetime'] == TIME_YMD ? substr($row['wr_datetime'], 11, 5) : substr($row['wr_datetime'], 5, 5);
    if ($list_view) {
        // 최근 갱신 시간
        $row['last'] = substr($row['wr_last'], 0, 10);
        $row['last2'] = $row['last'] == TIME_YMD ? substr($row['wr_last'], 11, 5) : substr($row['wr_last'], 5, 5);
        $row['comment_cnt'] = '';
        if ($row['wr_comment']) {
            $row['comment_cnt'] = '(' . $row['wr_comment'] . ')';
        }
        // 답변 여백
        $reply = strlen($row['wr_reply']);
        $row['ico_reply'] = '';
        if ($reply > 1) {
            for ($k = 1; $k < $reply; $k++) {
                $row['ico_reply'] .= '　';
            }
        }
        if ($reply > 0) {
            $row['ico_reply'] .= '<span class="glyphicon glyphicon-expand text-danger" title="답변"></span>';
        }
        $row['ico_new'] = '';
        if ($row['wr_datetime'] >= date("Y-m-d H:i:s", time() - $board['bo_new'] * 3600)) {
            $row['ico_new'] = '<span class="glyphicon glyphicon-fire text-danger" title="최신"></span>';
        }
        $row['ico_hot'] = '';
        if ($row['wr_hit'] >= $board['bo_hot']) {
            $row['ico_hot'] = '<span class="glyphicon glyphicon-flag text-danger" title="이슈 ' . $board['bo_hot'] . 'Hit!"></span>';
        }
        $row['ico_secret'] = '';
        if (strpos($row['wr_option'], 'secret') !== FALSE) {
            $row['ico_secret'] = '<span class="glyphicon glyphicon-lock text-danger" title="비밀"></span>';
        }
        // 가변 파일 - 첨부파일이 0개 이상일 경우에만 실행
        $row['ico_file'] = $row['ico_image'] = $row['ico_movie'] = '';
        if ($row['wr_count_file'] > 0) {
            $row['ico_file'] = '<span class="glyphicon glyphicon-file text-danger" title="파일"></span>';
        }
        if ($row['wr_count_image'] > 0) {
            $row['ico_image'] = '<span class="glyphicon glyphicon-picture text-danger" title="이미지"></span>';
        }
        if (stripos($row['wr_content'], '&lt;embed')) {
            $row['ico_movie'] = '<span class="glyphicon glyphicon-facetime-video text-danger" title="동영상"></span>';
        }
    }
    return $row;
}

function recGet($array, $count, $max)
{
    $text = '';
    if ($count == 1) {
        for ($i = 0; $i < 5; $i++) {
            $text .= get_text($max - $count, $array[$i]) . ' ';
        }
    } else {
        for ($i = 0; $i < 5; $i++) {
            $text .= get_text($max - $count, $array[$i]) . ' ';
            $text .= recGet($array[$i], $count - 1, $max) . ' ';
        }
    }
    return $text;
}

function photoresize($file, $direct = false)
{
    global $errMsg;
    if ($direct or $file['error'] == UPLOAD_ERR_OK) {
        // check del tipo: ammessi JPG e PNG
        list($width, $height, $type, $attr) = getimagesize($direct ? $file : $file["tmp_name"]);
        if ($type != IMAGETYPE_JPEG && $type != IMAGETYPE_PNG) {
            $errMsg = get_text('PhotoBadTypeError', 'Tournament');
        } else {
            $im = '';
            if ($type == IMAGETYPE_JPEG) {
                $im = imagecreatefromjpeg($direct ? $file : $file["tmp_name"]);
            } elseif ($type == IMAGETYPE_PNG) {
                $im = imagecreatefrompng($direct ? $file : $file["tmp_name"]);
            }
            if (!$im) {
                $errMsg = get_text('PhotoBadTypeError', 'Tournament');
            } else {
                if ($width != MAX_WIDTH || $height != MAX_HEIGHT) {
                    // we have to crop or resize image
                    $ratio = min($width / MAX_WIDTH, $height / MAX_HEIGHT);
                    // we resize the image to fit the greater value
                    $new_width = $width / $ratio;
                    $new_height = $height / $ratio;
                    $im2 = imagecreatetruecolor(MAX_WIDTH, MAX_HEIGHT);
                    $bgcolor = imagecolorallocate($im2, 255, 255, 255);
                    imagefill($im2, 0, 0, $bgcolor);
                    if (!imagecopyresampled($im2, $im, (MAX_WIDTH - $new_width) / 2, (MAX_HEIGHT - $new_height) / 2, 0, 0, $new_width, $new_height, $width, $height)) {
                        $errMsg = get_text('PhotoDimError', 'Tournament', array(MAX_WIDTH, MAX_HEIGHT));
                    } else {
                        // check now the proportions
                        $im = $im2;
                    }
                }
                if (!$errMsg) {
                    $savedImage = tempnam('/tmp', 'snp');
                    imagejpeg($im, $savedImage, 70);
                    $ResizedImage = addslashes(base64_encode(file_get_contents($savedImage)));
                    unlink($savedImage);
                    return $ResizedImage;
                }
            }
        }
    } elseif ($file['error'] != UPLOAD_ERR_NO_FILE) {
        $errMsg = get_text('PhotoUpError', 'Tournament');
    }
}

function writeGroupHeader($pdf, $section, $follows = false)
{
    $pdf->SetFont($pdf->FontStd, 'B', 10);
    $pdf->Cell(190, 6, $section['descr'], 1, 1, 'C', 1);
    if ($follows) {
        $pdf->SetXY(170, $pdf->GetY() - 6);
        $pdf->SetFont($pdf->FontStd, '', 6);
        $pdf->Cell(30, 6, get_text('Continue'), 0, 1, 'R', 0);
    }
    $pdf->SetFont($pdf->FontStd, 'B', 7);
    $pdf->Cell(20, 4, get_text('Medal'), 1, 0, 'C', 1);
    $pdf->Cell(50, 4, get_text('Athlete'), 1, 0, 'L', 1);
    $pdf->Cell(90, 4, get_text('Country'), 1, 0, 'L', 1);
    $pdf->Cell(30, 4, get_text('TotaleScore'), 1, 1, 'C', 1);
    $pdf->SetFont($pdf->FontStd, '', 1);
    $pdf->Cell(190, 0.5, '', 1, 1, 'C', 0);
}

function eb_popular($skin_dir = 'basic', $pop_cnt = 7, $date_cnt = 3)
{
    global $config, $g5, $tpl, $tpl_name;
    if (!$skin_dir) {
        $skin_dir = 'basic';
    }
    $date_gap = date("Y-m-d", G5_SERVER_TIME - $date_cnt * 86400);
    $sql = " select pp_word, count(*) as cnt from {$g5['popular_table']} where pp_date between '{$date_gap}' and '" . G5_TIME_YMD . "' group by pp_word order by cnt desc, pp_word limit 0, {$pop_cnt} ";
    $result = sql_query($sql);
    for ($i = 0; $row = sql_fetch_array($result); $i++) {
        $list[$i] = $row;
        // 스크립트등의 실행금지
        $list[$i]['pp_word'] = get_text($list[$i]['pp_word']);
    }
    $tpl->define(array('pc' => 'skin_pc/popular/' . $skin_dir . '/popular.skin.html', 'mo' => 'skin_mo/popular/' . $skin_dir . '/popular.skin.html', 'bs' => 'skin_bs/popular/' . $skin_dir . '/popular.skin.html'));
    $tpl->assign(array('list' => $list));
    $tpl->print_($tpl_name);
}

function eb_tagmenu($skin_dir = 'basic', $limit = 20, $sort = 'regdt')
{
    global $eyoom, $g5, $tpl, $tpl_name, $theme;
    $skin_dir = $eyoom['tag_skin'];
    if (!$skin_dir) {
        $skin_dir = 'basic';
    }
    $limit = $eyoom['tag_dpmenu_count'];
    if (!$limit) {
        $limit = 20;
    }
    $sort = $eyoom['tag_dpmenu_sort'];
    if (!$sort) {
        $sort = 'regdt';
    }
    switch ($sort) {
        case 'regdt':
            $sql_order = "tg_regdt desc";
            break;
        case 'score':
            $sql_order = "tg_score desc";
            break;
        case 'regcnt':
            $sql_order = "tg_regcnt desc";
            break;
        case 'scnt':
            $sql_order = "tg_scnt desc";
            break;
        case 'random':
            $sql_order = "rand()";
            break;
    }
    $sql = " select * from {$g5['eyoom_tag']} where (1) and tg_theme = '{$theme}' and tg_dpmenu = 'y' order by {$sql_order} limit {$limit} ";
    $result = sql_query($sql);
    for ($i = 0; $row = sql_fetch_array($result); $i++) {
        $list[$i] = $row;
        $list[$i]['tag'] = get_text($list[$i]['tg_word']);
        $list[$i]['href'] = G5_URL . '/tag/?tag=' . str_replace("&", "^", $list[$i]['tg_word']);
    }
    $tpl->define(array('pc' => 'skin_pc/tag/' . $skin_dir . '/tag_menu.skin.html', 'mo' => 'skin_mo/tag/' . $skin_dir . '/tag_menu.skin.html', 'bs' => 'skin_bs/tag/' . $skin_dir . '/tag_menu.skin.html'));
    $tpl->assign(array('list' => $list));
    $tpl->print_($tpl_name);
}

 function comment($limit = 5, $cut = 50)
 {
     $this->db->cache_on();
     $this->db->select('bo_table, wr_id, co_id, co_option, co_content');
     $this->db->order_by('co_datetime', 'desc');
     $result = $this->db->get('ki_comment', $limit)->result_array();
     $this->db->cache_off();
     $list = array();
     $this->load->helper('textual');
     foreach ($result as $i => $row) {
         if (strpos($row['co_option'], 'secret') !== FALSE) {
             // DB 쿼리로 교체 요망
             continue;
         }
         $list[$i] = new stdClass();
         $list[$i]->href = RT_PATH . '/board/' . $row['bo_table'] . '/view/wr_id/' . $row['wr_id'] . '#c_' . $row['co_id'];
         $list[$i]->content = cut_str(get_text($row['co_content']), $cut);
     }
     return $list;
 }

function popular($skin_dir = 'basic', $pop_cnt = 7, $date_cnt = 3)
{
    global $config, $g4;
    if (!$skin_dir) {
        $skin_dir = 'basic';
    }
    $date_gap = date("Y-m-d", $g4[server_time] - $date_cnt * 86400);
    $sql = " select pp_word, count(*) as cnt from {$g4['popular_table']}\n              where pp_date between '{$date_gap}' and '{$g4['time_ymd']}'\n              group by pp_word\n              order by cnt desc, pp_word\n              limit 0, {$pop_cnt} ";
    $result = sql_query($sql);
    for ($i = 0; $row = sql_fetch_array($result); $i++) {
        $list[$i] = $row;
        // 스크립트등의 실행금지
        $list[$i][pp_word] = get_text($list[$i][pp_word]);
    }
    ob_start();
    $popular_skin_path = "{$g4['path']}/skin/popular/{$skin_dir}";
    include_once "{$popular_skin_path}/popular.skin.php";
    $content = ob_get_contents();
    ob_end_clean();
    return $content;
}

function eb_tagrecommend($skin_dir = 'basic', $limit = 5)
{
    global $eyoom, $g5, $tpl, $tpl_name, $theme;
    $skin_dir = $eyoom['tag_skin'];
    if (!$skin_dir) {
        $skin_dir = 'basic';
    }
    $limit = $eyoom['tag_recommend_count'];
    if (!$limit) {
        $limit = 5;
    }
    $sql = " select * from {$g5['eyoom_tag']} where (1) and tg_theme = '{$theme}' and tg_recommdt <> '0000-00-00 00:00:00' order by tg_recommdt desc limit {$limit} ";
    $result = sql_query($sql);
    for ($i = 0; $row = sql_fetch_array($result); $i++) {
        $list[$i] = $row;
        $list[$i]['tag'] = get_text($list[$i]['tg_word']);
        $list[$i]['href'] = G5_URL . '/tag/?tag=' . str_replace("&", "^", $list[$i]['tg_word']);
    }
    $tpl->define(array('pc' => 'skin_pc/tag/' . $skin_dir . '/tag_recommend.skin.html', 'mo' => 'skin_mo/tag/' . $skin_dir . '/tag_recommend.skin.html', 'bs' => 'skin_bs/tag/' . $skin_dir . '/tag_recommend.skin.html'));
    $tpl->assign(array('list' => $list));
    $tpl->print_($tpl_name);
}

function getTargets($ByDiv = true)
{
    $ar = array();
    $MySql = "select" . " DivId" . ", ClId" . ", TfId " . ", TfName " . ", TfDefault " . "from" . " Divisions" . " inner join Classes on DivTournament=ClTournament and DivAthlete=ClAthlete" . " inner join TargetFaces Tf on DivTournament=TfTournament and if(TfRegExp>'', concat(trim(DivId),trim(ClId)) REGEXP TfRegExp, concat(trim(DivId),trim(ClId)) like TfClasses) " . "WHERE" . " DivTournament={$_SESSION['TourId']} " . " AND DivAthlete='1' " . " AND (ClDivisionsAllowed='' or find_in_set(DivId, ClDivisionsAllowed))" . "order by" . " DivViewOrder" . ", ClViewOrder" . ", TfDefault desc" . ", TfRegExp>'' desc" . ", concat(trim(DivId),trim(ClId)) = TfClasses desc" . ", left(TfClasses,1)!='_' and left(TfClasses,1)!='%' desc" . ", left(TfClasses,1)='_' desc" . ", TfClasses desc" . ", TfClasses='%' ";
    $q = safe_r_sql($MySql);
    if ($ByDiv) {
        while ($r = safe_fetch($q)) {
            if (!$r->TfDefault or empty($ar[$r->DivId][$r->ClId])) {
                $ar[$r->DivId][$r->ClId][$r->TfId] = get_text($r->TfName, 'Tournament', '', true);
            }
        }
    } else {
        $divs = array();
        while ($r = safe_fetch($q)) {
            if (!$r->TfDefault or empty($divs[$r->DivId][$r->ClId])) {
                $ar[$r->TfId][$r->DivId][$r->ClId] = $r->TfDefault;
                $divs[$r->DivId][$r->ClId] = 'done';
            }
        }
    }
    return $ar;
}

function conv_content($str, $html)
{
    $CI =& get_instance();
    $CI->load->library('typography');
    if ($html) {
        // 동영상 출력
        function entity_decode($text)
        {
            return htmlspecialchars_decode($text[0]);
        }
        $str = preg_replace_callback('#(<|&lt;)/?(object|embed|param)([^>]*|[^&gt;]*)(&gt;|>)#i', 'entity_decode', $str);
        $str = $CI->typography->auto_typography($str);
        // format_characters
    } else {
        $str = get_text($str);
        $str = $CI->typography->nl2br_except_pre($str);
    }
    // URL 링크
    $patterns = array("/&lt;/", "/&gt;/", "/&amp;/", "/&quot;/", "/&nbsp;/", "/([^(http:\\/\\/)]|\\(|^)(www\\.[a-zA-Z0-9\\.-]+)/i", "/([^(HREF=\"?'?)|(SRC=\"?'?)]|\\(|^)((http|https|ftp|telnet|news|mms):\\/\\/[a-zA-Z0-9\\.-]+\\.[가-힣�-�a-zA-Z0-9\\.:&#=_\\?\\/~\\+%@;\\-\\|\\,\\(\\)]+)/i", "/([0-9a-z]([-_\\.]?[0-9a-z])*@[0-9a-z]([-_\\.]?[0-9a-z])*\\.[a-z]{2,4})/i", "/\t_nbsp_\t/", "/\t_lt_\t/", "/\t_gt_\t/");
    $replace = array("\t_lt_\t", "\t_gt_\t", "&", "\"", "\t_nbsp_\t", "\\1<a href=\"http://\\2\" target='_blank'>\\2</a>", "\\1<a href=\"\\2\" target='_blank'>\\2</a>", "<a href='mailto:\\1'>\\1</a>", "&nbsp;", "&lt;", "&gt;");
    $str = preg_replace($patterns, $replace, $str);
    return $str;
}

function get_help($cmd)
{
    $title = "IRC:exec aliases";
    $section = $cmd;
    if (login(True) == False) {
        return False;
    }
    $result = "";
    $text = get_text($title, $section, True, True);
    if ($text !== False) {
        for ($i = 0; $i < min(count($text), 3); $i++) {
            bot_ignore_next();
            privmsg(trim($text[$i]));
        }
        if ($cmd[0] == "~") {
            $cmd = ".7E" . substr($cmd, 1);
        }
        privmsg("http://wiki.soylentnews.org/wiki/IRC:exec_aliases#{$cmd}");
        $result = True;
    }
    logout(True);
    return $result;
}