makejs_train_classify();
//填写管理员日志
write_log("后台成功添加分类 , 共添加" . $num . "个！", $_SESSION['admin_name'], 3);
adminmsg("添加成功！共添加" . $num . "个分类", 2, $link);
}
} elseif ($act == 'edit_category') {
get_token();
$smarty->assign('navlabel', "group");
$smarty->assign('category', get_category_one($_GET['id']));
$smarty->display('category/admin_category_edit.htm');
} elseif ($act == 'edit_category_save') {
check_token();
$setsqlarr['c_name'] = !empty($_POST['c_name']) ? trim($_POST['c_name']) : adminmsg("请填写名称", 1);
$setsqlarr['c_order'] = intval($_POST['c_order']);
$setsqlarr['c_parentid'] = intval($_POST['c_parentid']);
$setsqlarr['c_index'] = getfirstchar($setsqlarr['c_name']);
$setsqlarr['c_note'] = trim($_POST['c_note']);
!$db->updatetable(table('category'), $setsqlarr, " c_id=" . intval($_POST['c_id'])) ? adminmsg("保存失败！", 0) : "";
$link[0]['text'] = "返回列表";
$link[0]['href'] = '?act=show_category&alias=' . $_POST['c_alias'];
$link[1]['text'] = "查看修改结果";
$link[1]['href'] = "?act=edit_category&id=" . intval($_POST['c_id']);
refresh_category_cache();
makejs_classify();
makejs_train_classify();
//填写管理员日志
write_log("后台成功修改分类", $_SESSION['admin_name'], 3);
adminmsg("保存成功！", 2, $link);
} elseif ($act == 'del_category') {
check_token();
$id = $_REQUEST['id'];
function pinyin($zh)
{
$ret = "";
$s1 = iconv("UTF-8", "gb2312", $zh);
$s2 = iconv("gb2312", "UTF-8", $s1);
if ($s2 == $zh) {
$zh = $s1;
}
for ($i = 0; $i < strlen($zh); $i++) {
$s1 = substr($zh, $i, 1);
$p = ord($s1);
if ($p > 160) {
$s2 = substr($zh, $i++, 2);
$ret .= getfirstchar($s2);
} else {
$ret .= $s1;
}
}
return $ret;
}
function firstPinyin($zh)
{
$ret = "";
$s1 = iconv('UTF-8', 'GB2312//ignore', $zh);
$s2 = iconv("GB2312", "UTF-8", $s1);
if ($s2 == $zh) {
$zh = $s1;
}
for ($i = 0; $i < strlen($zh); $i++) {
$s1 = substr($zh, $i, 1);
$p = ord($s1);
if ($p > 160) {
$s2 = substr($zh, $i++, 2);
$ret .= getfirstchar($s2);
} else {
$ret .= strtoupper($s1);
}
}
return strtoupper($ret);
$ret = '';
}
die;
header("Content-type: text/html; charset=utf-8");
set_time_limit(0);
error_reporting(E_ALL ^ E_NOTICE);
ini_set('display_errors', 'On');
$lnk = mysql_connect('114.215.210.34', 'root', 'xujj10192917') or die('Not connected : ' . mysql_error());
// make foo the current db
mysql_select_db('touzilicai', $lnk) or die('Can\'t use foo : ' . mysql_error());
mysql_query("set names utf8");
$result = mysql_query('select * from tags where pinyinPrefix="" order by id asc limit 1000');
$total = mysql_affected_rows();
$index = 0;
while ($row = mysql_fetch_assoc($result)) {
$index++;
$pinyinPrefix = strtolower(getfirstchar($row['name']));
if (ord($pinyinPrefix) < 10) {
$pinyinPrefix = 1;
}
if ($pinyinPrefix) {
$sql = 'update tags set pinyinPrefix="' . $pinyinPrefix . '" where id=' . $row['id'];
// echo 'sql:'.$sql.'<br>';
mysql_query($sql) or die("Invalid query: " . mysql_error());
echo $index . '/' . $total . '<br>';
} else {
echo $index . '/' . $total . ':error<br>';
}
ob_flush();
flush();
}
function getfirstchar($s0)
$smarty->assign('district', get_category_district());
$smarty->assign('subsite', $subsite);
$smarty->assign('rand', rand(1, 100));
$smarty->assign('upfiles_dir', $upfiles_dir);
$smarty->display('subsite/admin_subsite_edit.htm');
} elseif ($act == 'edit_save') {
check_token();
$s_id = intval($_POST['s_id']);
$setsqlarr['s_sitename'] = !empty($_POST['s_sitename']) ? trim($_POST['s_sitename']) : adminmsg('请填写分站名称！', 1);
$setsqlarr['s_effective'] = isset($_POST['s_effective']) ? intval($_POST['s_effective']) : 1;
$setsqlarr['s_districtname'] = !empty($_POST['s_districtname']) ? trim($_POST['s_districtname']) : adminmsg('请填写地区名称！', 1);
$setsqlarr['s_domain'] = !empty($_POST['s_domain']) ? trim($_POST['s_domain']) : adminmsg('请填写域名！', 1);
$setsqlarr['s_m_domain'] = trim($_POST['s_m_domain']);
$setsqlarr['s_tpl'] = !empty($_POST['s_tpl']) ? trim($_POST['s_tpl']) : '';
$setsqlarr['s_order'] = intval($_POST['s_order']);
$setsqlarr['s_index'] = getfirstchar($setsqlarr['s_sitename']);
$setsqlarr['s_title'] = trim($_POST['s_title']);
$setsqlarr['s_keywords'] = trim($_POST['s_keywords']);
$setsqlarr['s_description'] = trim($_POST['s_description']);
if ($_FILES['s_logo']['name']) {
$setsqlarr['s_logo'] = _asUpFiles($upfiles_dir, "s_logo", 1024 * 2, 'jpg/gif/png', "logo" . md5($setsqlarr['s_domain']));
if (empty($setsqlarr['s_logo'])) {
adminmsg('上传图片出错！', 1);
}
}
$link[0]['text'] = "查看修改结果";
$link[0]['href'] = '?act=edit&id=' . $s_id;
$link[1]['text'] = "返回分站管理";
$link[1]['href'] = '?act=list';
if (!$db->updatetable(table('subsite'), $setsqlarr, " s_id=" . $s_id . "")) {
adminmsg("修改失败！", 0);
