function get_course_types()
{
    $query = 'SELECT course_type_cde, course_type_desc, sort_order
                from course_type
                order by sort_order';
    return get_list($query);
}

function latest($skin_dir = "", $bo_table, $rows = 10, $subject_len = 40, $options = "")
{
    global $g4;
    if ($skin_dir) {
        $GLOBALS['latest_skin_path'] = $latest_skin_path = "{$g4['path']}/skin/latest/{$skin_dir}";
    } else {
        $GLOBALS['latest_skin_path'] = $latest_skin_path = "{$g4['path']}/skin/latest/basic";
    }
    $list = array();
    $sql = " select * from {$g4['board_table']} where bo_table = '{$bo_table}'";
    $board = sql_fetch($sql);
    $tmp_write_table = $g4['write_prefix'] . $bo_table;
    // 게시판 테이블 전체이름
    $sql = " select * from {$tmp_write_table} where wr_is_comment = 0 order by wr_num limit 0, {$rows} ";
    //explain($sql);
    $result = sql_query($sql);
    for ($i = 0; $row = sql_fetch_array($result); $i++) {
        $list[$i] = get_list($row, $board, $latest_skin_path, $subject_len);
    }
    ob_start();
    include "{$latest_skin_path}/latest.skin.php";
    $content = ob_get_contents();
    ob_end_clean();
    return $content;
}

function get_signup_dates()
{
    $query = 'SELECT grade_lvl, mode_desc, signup_dates_mode.mode_cde, start, end
              FROM signup_dates, signup_dates_mode
              WHERE signup_dates.mode_cde = signup_dates_mode.mode_cde and grade_lvl != 13';
    return get_list($query);
}

 function __construct($coach_id)
 {
     // MySQL stored information
     $this->coach_id = $coach_id;
     $this->setStats(false, false, false);
     $this->ring = (int) $this->ring;
     if (empty($this->mail)) {
         $this->mail = '';
     }
     # Re-define as empty string, and not numeric zero.
     if (empty($this->phone)) {
         $this->phone = '';
     }
     # Re-define as empty string, and not numeric zero.
     if (empty($this->realname)) {
         $this->realname = '';
     }
     # Re-define as empty string, and not numeric zero.
     // Coach's site settings.
     $this->settings = array();
     // Is overwriten to type = string when loading MySQL data into this object.
     foreach (get_list('coaches', 'coach_id', $this->coach_id, 'settings') as $set) {
         list($key, $val) = explode('=', $set);
         $this->settings[$key] = $val;
     }
     global $settings;
     $init = array('theme' => 1, 'lang' => Translations::fallback, 'home_lid' => null);
     // Setting values which must be initialized if not stored/saved in mysql.
     foreach ($init as $key => $val) {
         if (!array_key_exists($key, $this->settings) || !isset($this->settings[$key])) {
             $this->settings[$key] = $val;
         }
     }
 }

function get_session_times()
{
    $query = 'SELECT ses_id, ses_name, ses_start, ses_end 
					from session_times
					order by sort_order';
    return get_list($query);
}

function get_room_list()
{
    $query = 'SELECT rm_nbr, rm_id
              from room
              
			  order by rm_nbr';
    return get_list($query);
}

function get_rooms()
{
    $query = 'select distinct rm_nbr, p.rm_id
                from presentation p, room r
                where p.rm_id = r.rm_id
                order by r.rm_nbr;';
    return get_list($query);
}

function get_teacher_list()
{
    $query = 'SELECT teacher_id, last_name, first_name, display_name
                from teacher
                where active = 1
                order by last_name, first_name';
    return get_list($query);
}

function get_user_list()
{
    $query = 'SELECT usr_id, usr_bca_id, usr_type_cde, usr_class_year, usr_grade_lvl, 
                 usr_first_name, usr_last_name, usr_active
              from user
              where usr_active = 1
			  order by usr_grade_lvl desc, usr_last_name, usr_first_name ';
    return get_list($query);
}

function get_mentors()
{
    $query = 'SELECT mentor.mentor_id,  mentor_last_name ,  mentor_first_name ,  mentor_field ,
					mentor_position , mentor_company ,  mentor_profile ,  mentor_keywords ,
					active ,  pres_room , pres_host_teacher ,
					pres_max_capacity
					from mentor
					order by mentor.mentor_last_name';
    return get_list($query);
}

function get_signup_dates_list()
{
    $query = 'SELECT signup_dates.class_year, class_year, start, end,
                    GET_SCHEDULE_TIMES_LIST (signup_dates.class_year) as times
                from signup_dates
                inner join course_type
                on course.course_type_cde = course_type.course_type_cde
                inner join teacher
                on course.teacher_id = teacher.teacher_id
                where course.active = 1
                order by course.course_nbr';
    return get_list($query);
}

function get_mentor_list()
{
    $query = 'SELECT mentor.mentor_id, mentor_last_name, mentor_first_name, mentor_field,
                 mentor_position, mentor_company, mentor_profile, mentor_keywords,
                  active, pres_room, pres_host_teacher, pres_max_capacity, 
                  GROUP_CONCAT(ses_id order by ses_id SEPARATOR \', \') as sessions
              from mentor
              left join presentation on mentor.mentor_id = presentation.mentor_id
              where active = 1
              group by mentor.mentor_id
			  order by mentor_last_name';
    return get_list($query);
}

function get_presentation_list()
{
    $query = 'SELECT workshop.wkshp_nme, presentation.pres_id, presentation.org_name, presentation.rm_id,
                    pres_max_teachers, pres_max_seats, pres_enrolled_teachers, pres_enrolled_seats,
                    pres_max_seats - presentation.pres_enrolled_seats as remaining, 
                    presenter_names, rm_nbr, ses_start_time, ses_end_time, presentation.ses_id, presentation.wkshp_id
                FROM presentation, room, session_times, workshop 
                WHERE presentation.rm_id = room.rm_id
                    and presentation.ses_id = session_times.ses_id
                    and presentation.wkshp_id = workshop.wkshp_id
                    
                order by rm_nbr, presentation.ses_id ';
    return get_list($query);
}

function get_course_list()
{
    $query = 'SELECT course.course_id, course_name, course_nbr, course_short_name, 
                    course_desc, course_type_desc, teacher.display_name, 
                    course.course_nbr, 
                    GET_SCHEDULE_TIMES_LIST (course.course_id) as times
                from course
                inner join course_type
                on course.course_type_cde = course_type.course_type_cde
                inner join teacher
                on course.teacher_id = teacher.teacher_id
                where course.active = 1
                order by course.course_nbr';
    return get_list($query);
}

function getWriteTable($bo_table, $boardTableRow)
{
    global $currentPageNo, $rowsPerPage, $write_prefix;
    $board = $boardTableRow[0];
    $subject_len = 40;
    $startPage = ($currentPageNo - 1) * $rowsPerPage;
    $endPage = $rowsPerPage;
    $tmp_write_table = $write_prefix . $bo_table;
    // 게시판 테이블 전체이름
    $sql = " select * from {$tmp_write_table} where wr_is_comment = 0 order by wr_num LIMIT  {$startPage}, {$endPage} ";
    $result = sql_query($sql);
    $resultArray = array();
    for ($i = 0; $row = sql_fetch_array($result); $i++) {
        $resultArray[$row['wr_id']] = get_list($row, $board, '', $subject_len);
    }
    if (count($resultArray) == 0) {
        $resultArray["status_msg"] = "list no length";
        $resultArray["status_code"] = "-2";
    } else {
        $resultArray["status_msg"] = "success";
        $resultArray["status_code"] = "0";
    }
    return $resultArray;
}

if ($key != 'e3dc653e2d68697346818dfc0b208322') {
    $result = array('success' => false, 'result' => -2, 'error_msg' => "添加失败，标识码有误！");
    echo json_encode($result);
    exit;
}
$shop_info = new shop_infoBean($db, 'shop_info');
$sys_dict = new sys_dictBean($db, 'sys_dict');
$sys_area = new sys_areaBean($db, 'sys_area');
$sys_user = new sys_userBean($db, 'sys_user');
$user_order = new user_orderBean($db, 'user_order');
$user_order_goods = new user_order_goodsBean($db, 'user_order_goods');
$user_comment = new user_commentBean($db, 'user_comment');
switch ($act) {
    case 'list':
        //商家列表
        $result = get_list($db, $user_comment, $user_order, $shop_info);
        break;
    case 'info':
        //商家信息
        $result = detail($db, $shop_info, $user_comment, $user_order);
        break;
    case 'order_list':
        //获取商家订单列表
        $result = get_order_list($sid, $user_order, $sys_user, $sys_dict, $user_order_goods);
        break;
    case 'type':
        $result = get_type($db, $sys_dict);
        break;
    case 'trading_mode':
        $result = trading_mode($sid, $shop_info);
        //获取商家交易模式

function get_registered_users()
{
    $query = 'SELECT completed.usr_grade_lvl, completed.num AS Complete, partial.num AS Partial, none.num AS None
    FROM
    (SELECT usr_grade_lvl, sum(num) AS num
    FROM
    (SELECT distinct grade_lvl as usr_grade_lvl, 0 AS num
    FROM signup_dates

    UNION

    SELECT usr_grade_lvl, count(*) AS num
    FROM (
    SELECT usr_grade_lvl, user.usr_id, count(*) AS num_sessions
    FROM user 
    INNER JOIN user_presentation_xref ON user_presentation_xref.usr_id = user.usr_id
    WHERE usr_active = 1
    GROUP BY usr_grade_lvl, user.usr_id
    HAVING num_sessions = 4
    ) temp
    GROUP BY usr_grade_lvl ) a

    GROUP BY usr_grade_lvl) completed

    INNER JOIN (
    SELECT usr_grade_lvl, sum(num) AS num
    FROM
    (SELECT distinct grade_lvl as usr_grade_lvl, 0 AS num
    FROM signup_dates

    UNION
    SELECT usr_grade_lvl, count(*) AS num
    FROM (
    SELECT usr_grade_lvl, user.usr_id, count(*) AS num_sessions
    FROM user 
    INNER JOIN user_presentation_xref ON user_presentation_xref.usr_id = user.usr_id
    WHERE usr_active = 1
    GROUP BY usr_grade_lvl, user.usr_id
    HAVING num_sessions < 4
    ) temp
    GROUP BY usr_grade_lvl
     ) a

    GROUP BY usr_grade_lvl

    ) partial ON completed.usr_grade_lvl = partial.usr_grade_lvl



    INNER JOIN (
    SELECT usr_grade_lvl, sum(num) AS num
    FROM
    (SELECT distinct grade_lvl as usr_grade_lvl, 0 AS num
    FROM signup_dates

    UNION
    SELECT usr_grade_lvl, count(*) AS num
    FROM user
    LEFT JOIN user_presentation_xref ON user_presentation_xref.usr_id= user.usr_id
    WHERE user_presentation_xref.usr_id IS NULL
    AND usr_active = 1
    GROUP BY usr_grade_lvl
    ) a

    GROUP BY usr_grade_lvl

    ) none ON completed.usr_grade_lvl = none.usr_grade_lvl
    ORDER BY usr_grade_lvl;';
    return get_list($query);
}

 public static function render_list()
 {
     $list = get_list();
     $langs = null;
     foreach ($list as $code => $name) {
         $langs .= LANG == $code ? '<a href="' . LOCAL . $code . (u0 ? '/' . PATH : '') . '" class="active" title="' . $name . '"><img src="' . LOCAL . 'images/flags/' . $code . '.png" alt="' . $code . '" /></a> ' : '<a href="' . LOCAL . $code . (u0 ? '/' . PATH : '') . '" class="inactive" title="' . $name . '"><img src="' . LOCAL . 'images/flags/' . $code . '.png" alt="' . $code . '" /></a> ';
     }
     return $langs;
 }

<?php

session_start();
require_once dirname(__FILE__) . '/../../utils/http_response_code.php';
if (!isset($_SESSION['adm']) || $_SESSION['adm'] !== true) {
    http_response_code(401);
    die;
}
require_once dirname(__FILE__) . '/../../account/config/deployment_environment.php';
require_once dirname(__FILE__) . '/../../connect.php';
require_once dirname(__FILE__) . '/get_list_fieldnames.php';
require_once dirname(__FILE__) . '/../common/get_list.php';
$link = connect();
$stmt = get_list($link, 'vtest_type_resources');
$data = array();
$testResourceIds = array();
$langs = array($_SESSION['if_lang']);
foreach ($_SESSION['interface_languages'] as $language) {
    if ($language['val'] !== $_SESSION['if_lang']) {
        $langs[] = $language['val'];
    }
}
while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
    if (!isset($data[$row['tresourceid']])) {
        $data[$row['tresourceid']] = array(array());
    }
    $data[$row['tresourceid']][0][$row['ttypeid']] = array('name' => $row['ttypedesc'], 'val' => $row['ttypeid']);
    $data[$row['tresourceid']][array_search($row['tresourcelang'], $langs) + 1] = $row['tresourcedesc'];
    $testResourceIds[$row['tresourceid']] = $row['tresourceid'];
}
$data = array_values($data);

            }
        }
        if (!empty($_GET['source'])) {
            $source = $_GET["source"];
            $wheresql .= " AND `source` like '%" . $source . "%'";
        }
        if (!empty($_GET['title'])) {
            $wheresql .= " AND `parent_id` = '" . $_GET["title"] . "' ";
        }
    }
    $total_sql = "SELECT COUNT(*) AS num FROM " . table('relation') . $wheresql;
    $total_val = $db->get_total($total_sql);
    $page = new page(array('total' => $total_val, 'perpage' => $perpage, 'getarray' => $_GET));
    $currenpage = $page->nowindex;
    $offset = ($currenpage - 1) * $perpage;
    $list = get_list($offset, $perpage, $wheresql . $oederbysql);
    $smarty->assign('list', $list);
    $smarty->assign('page', $page->show(3));
    $smarty->assign('navlabel', "list");
    $smarty->assign('source_list', get_source_list());
    $smarty->assign('title_list', get_title_list());
    $smarty->assign('source', $_GET['source']);
    $smarty->assign('title', $_GET['title']);
    $smarty->assign('type', $_GET['type']);
    get_token();
    $smarty->display('replace/admin_replace.htm');
} elseif ($act == 'add') {
    get_token();
    $smarty->assign('navlabel', "add");
    $smarty->display('replace/admin_replace_add.htm');
} elseif ($act == 'add_title') {