} 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"); }
$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');
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']);
$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 != '') {