Beispiel #1
0
                    } else {
                        if ($id == "4") {
                            $where = " AND `st_url` LIKE '%{$Keyword}%'";
                        } else {
                            if ($id == "5") {
                                $where = " AND `st_ip` LIKE '%{$Keyword}%'";
                            } else {
                                if ($id == "6") {
                                    $where = " AND `st_username` LIKE '%{$Keyword}%'";
                                }
                            }
                        }
                    }
                }
            }
        }
        $smarty->assign('Keyword', $Keyword);
    }
    if ($type != '') {
        $where .= " AND TO_DAYS(`st_date`)>=TO_DAYS('{$type}')";
    }
    if ($Industry != '') {
        $where .= " AND TO_DAYS(`st_date`)<=TO_DAYS('{$Industry}')";
    }
    $nNums = $GETSQL->fNumrows("SELECT st_id FROM `{$ODBC['tablepre']}statistics` WHERE `st_admin`='1'{$where}");
    $sql_statistics = $GETSQL->fSql("*", "`{$ODBC['tablepre']}statistics`", "`st_admin`='1'{$where}", "ORDER BY `st_date` DESC,`st_id` DESC", $nPage * $nCount, $nCount);
    $fpageup = fPagesadmin($nNums, $nPage, $nCount, $cParameter, "showtable", 1);
    $smarty->assign('fpageup', $fpageup);
    $smarty->assign("sql_statistics", $sql_statistics);
    $smarty->display("statistics.htm");
}
Beispiel #2
0
    $smarty->assign('rentime', fmicrotime());
    $smarty->display("hotelyouthread.htm");
}
if ($option == 'showyouword') {
    $nCount = $cache_config['numser'] ? $cache_config['numser'] : "10";
    $cParameter = "action={$action}&option={$option}&id={$id}&Industry={$Industry}";
    include_once Getincludefun("page");
    $nNums = $GETSQL->fNumrows("SELECT word_id FROM `{$ODBC['tablepre']}hotelyouword` WHERE `word_hid`='{$id}'");
    if ($nNums > 0) {
        $sql_hotelword = $GETSQL->fSql("*", "`{$ODBC['tablepre']}hotelyouword`", "`word_hid`='{$id}' AND `word_tid`='{$Industry}'", "ORDER BY `word_date`,`word_id`", $nPage * $nCount, $nCount);
        foreach ($sql_hotelword as $key => $value) {
            $wordip = explode(".", $value['word_ip']);
            $sql_hotelword[$key]['word_ip'] = "{$wordip[0]}.{$wordip[1]}.{$wordip[2]}.*";
        }
        if ($nNums > $nCount) {
            $fpageup = fPagesadmin($nNums, $nPage, $nCount, $cParameter, "showyouword", 1);
            $smarty->assign('fpageup', $fpageup);
        }
        $smarty->assign('sql_hotelword', $sql_hotelword);
    }
    $smarty->assign('sql_hotel', $sql_hotel);
    $smarty->display("hotelyouword.htm");
}
if ($option == 'hotelphoto') {
    $sql_hotel = $GETSQL->fSql("hot_id,hot_uid,hot_subject,hot_start,hot_pass", "`{$ODBC['tablepre']}hotel`", "`hot_id`='{$id}'", "", "", "", "U_B");
    if ($sql_hotel['hot_pass'] != '1') {
        Showmsg('酒店还没通过管理员审核');
    }
    $GETSQL->fUpdate("`{$ODBC['tablepre']}hotel`", "`hot_see`=`hot_see`+1", "`hot_id`='{$id}'");
    $smarty->assign('config', array('title' => "{$sql_hotel['hot_subject']}_相册", 'keywords' => $config['keywords'] . "{$sql_hotel['hot_subject']}_相册_{$cache_config['subject']}", 'description' => $config['description'] . "{$sql_hotel['hot_subject']}_相册_{$cache_config['subject']}"));
    include_once GetLang('image');
Beispiel #3
0
            die(gb2utf8("数据表{$_GET['table']}删除"));
        }
        if ($_POST['update'] == 'update') {
            /*
            $GETSQL->fUpdate("`{$ODBC['tablepre']}{$_GET['table']}`",
            "`about_subject`='{$_POST['blog_title']}',`about_content`='{$_POST['blog_body']}'",
            "`about_id`='{$_POST['bid']}'");
            */
            die(gb2utf8("数据表修改功能暂时没有升级"));
        }
        if ($_GET['show'] == 'select') {
            $nCount = 20;
            $cParameter = "action=sqladmin&option=sqlupdate&table={$_GET['table']}&show=select&read=1";
            $nNums = $GETSQL->fNumrows("SELECT * FROM `{$_GET['table']}`");
            $sql_user = $GETSQL->fSql("*", "`{$_GET['table']}`", "", "", $nPage * $nCount, $nCount, "");
            $fpageup = fPagesadmin($nNums, $nPage, $nCount, $cParameter, "showwindow", 1);
        }
    }
    $smarty->assign('sql_users', $sql_user[0]);
    $smarty->assign('sql_user', $sql_user);
    $smarty->assign('sqltable', $_GET['table']);
    $smarty->assign('fpageup', $fpageup);
    $smarty->display("sqladmin.htm");
}
if ($option == 'columns') {
    if ($_GET['del'] != '') {
        $GETSQL->fQuery("ALTER TABLE `{$_GET['table']}` DROP `{$_GET['del']}`");
        die(gb2utf8("字段{$_GET['table']}.{$_GET['del']}删除"));
    }
    $sql_rs = $GETSQL->fArray("show columns from `{$_GET['table']}`");
    $smarty->assign('table', $_GET['table']);
Beispiel #4
0
    $smarty->assign('rentime', fmicrotime());
    $smarty->display("travelattr.htm");
}
if ($option == 'showtravelattrword') {
    $nCount = $cache_config['numser'] ? $cache_config['numser'] : "10";
    $cParameter = "action={$action}&option={$option}&id={$id}&Industry={$Industry}";
    include_once Getincludefun("page");
    $nNums = $GETSQL->fNumrows("SELECT word_id FROM `{$ODBC['tablepre']}travelattrword` WHERE `word_hid`='{$id}'");
    if ($nNums > 0) {
        $sql_hotelword = $GETSQL->fSql("*", "`{$ODBC['tablepre']}travelattrword`", "`word_hid`='{$id}' AND `word_tid`='{$Industry}'", "ORDER BY `word_date`,`word_id`", $nPage * $nCount, $nCount);
        foreach ($sql_hotelword as $key => $value) {
            $wordip = explode(".", $value['word_ip']);
            $sql_hotelword[$key]['word_ip'] = "{$wordip[0]}.{$wordip[1]}.{$wordip[2]}.*";
        }
        if ($nNums > $nCount) {
            $fpageup = fPagesadmin($nNums, $nPage, $nCount, $cParameter, "showtravelattrword", 1);
            $smarty->assign('fpageup', $fpageup);
        }
        $smarty->assign('sql_hotelword', $sql_hotelword);
    }
    $smarty->display("travelattrword.htm");
}
if ($option == 'travelphoto') {
    $sql_travel = $GETSQL->fSql("sc_id,sc_uid,sc_subject,sc_start,sc_pass", "`{$ODBC['tablepre']}travel`", "`sc_id`='{$id}'", "", "", "", "U_B");
    if ($sql_travel['sc_pass'] != '1') {
        Showmsg('旅行社还没通过管理员审核');
    }
    $GETSQL->fUpdate("`{$ODBC['tablepre']}travel`", "`sc_see`=`sc_see`+1", "`sc_id`='{$id}'");
    include_once GetLang('image');
    include_once Getincludefun("image");
    if ($Industry != '') {