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);