function king_ajax_login()
{
/**
登录页面增加一个$act变量，做登录判断用。
*/
global $king;
$adminname = kc_post('adminname');
$adminpass = kc_post('adminpass');
$s = '<div class="k_login"><div><label>' . $king->lang->get('system/login/name') . ':</label><p><input type="text" class="k_in w150" id="adminname" name="adminname" value="' . htmlspecialchars($adminname) . '" maxlength="12" />';
$s .= kc_check(array(array('adminname', 0, $king->lang->get('system/check/e0'), 2, 12), array('adminname', 1, $king->lang->get('system/check/e1'))));
$s .= '</p></div>';
$s .= '<div><label>' . $king->lang->get('system/login/pass') . ':</label><p><input type="password" class="k_in w150" id="adminpass" name="adminpass" maxlength="30" />';
$s .= kc_check(array(array('adminpass', 0, $king->lang->get('system/check/e0'), 6, 30)));
if ($GLOBALS['ischeck']) {
$s .= kc_check(array(array('adminpass', 12, $king->lang->get('system/login/check'), !king_ajax_login_check($adminname, $adminpass))));
}
$s .= '</p></div>';
//expire
$array_select = array(0 => $king->lang->get('system/time/cookie'), 86400 => $king->lang->get('system/time/oneday'), 2592000 => $king->lang->get('system/time/jan'), 15768000 => $king->lang->get('system/time/halfyear'), 315360000 => $king->lang->get('system/time/forever'));
$s .= '<div><label>' . $king->lang->get('portal/user/expire') . ':</label><p>' . kc_htm_select('expire', $array_select, 86400) . '</p></div></div>';
$but = kc_htm_a($king->lang->get('system/common/login'), "{CMD:'login',IS:1}");
$but .= '<a href="javascript:;" title="' . $king->lang->get('system/common/close') . '" class="k_close">' . $king->lang->get('system/common/close') . '</a>';
// $s.='</p>';
if ($GLOBALS['ischeck']) {
$_sql = "select adminlogin from %a_admin where adminname='" . $king->db->escape($adminname) . "';";
if ($_res = $king->db->getRows_one($_sql)) {
$_location = $_res['adminlogin'];
}
kc_ajax('', '', 0, "parent.location='{$_location}'");
} else {
kc_ajax($king->lang->get('system/login/title'), $s, $but, '', 420, 220);
kc_error($but);
}
}
/**
编辑
*/
function king_ajax_edt()
{
global $king;
$king->access('portal_express_edt');
$eid = kc_get('eid', 2);
$sql = "kname,nsprice,niprice,kremark,kaddress";
$array_sql = explode(',', $sql);
if ($GLOBALS['ismethod'] || empty($eid)) {
$data = $_POST;
if (!$GLOBALS['ismethod']) {
$data['kaddress'] = 'http://';
}
} else {
if (!($data = $king->db->getRows_one("select {$sql} from %s_express where eid={$eid}"))) {
kc_error($king->lang->get('system/error/notre'));
}
}
$data = kc_data($array_sql, $data);
//kname
$array = array(array('kname', 0, 1, 50));
$s = $king->htmForm($king->lang->get('portal/express/name'), kc_htm_input('kname', $data['kname'], 50, 200), $array);
//nsprice
$array = array(array('nsprice', 0, 1, 5), array('nsprice', 2));
$s .= $king->htmForm($king->lang->get('portal/express/sprice'), kc_htm_input('nsprice', $data['nsprice'], 5, 50), $array);
//nsprice
$array = array(array('niprice', 0, 1, 5), array('niprice', 2));
$s .= $king->htmForm($king->lang->get('portal/express/iprice'), kc_htm_input('niprice', $data['niprice'], 5, 50), $array);
//kaddress
$array = array(array('kaddress', 0, 1, 255), array('kaddress', 6));
$s .= $king->htmForm($king->lang->get('portal/express/address'), kc_htm_input('kaddress', $data['kaddress'], 255, 400), $array);
//kremark
$array = array(array('kremark', 0, 0, 3000));
$s .= $king->htmForm($king->lang->get('portal/common/remark'), '<textarea name="kremark" id="kremark" rows="6" cols="100" class="k_in w400">' . htmlspecialchars($data['kremark']) . '</textarea>', $array);
if ($GLOBALS['ischeck']) {
$array = array();
foreach ($array_sql as $val) {
$array[$val] = $data[$val];
}
if (empty($eid)) {
//insert
$king->db->insert('%s_express', $array);
} else {
$king->db->update('%s_express', $array, "eid={$eid}");
}
$js = 'setTimeout("parent.location=\'manage.express.php\'",1000)';
kc_ajax('', '', '', $js);
}
$but = kc_htm_a($king->lang->get('system/common/save'), "{CMD:'edt',eid:'{$eid}',IS:1}");
kc_ajax($king->lang->get('portal/title/expressedt'), $s, $but, '', 440, 350 + $GLOBALS['check_num'] * 15);
}
/**
发货
*/
function king_ajax_express()
{
global $king;
$king->access('portal_orders_delivery');
$oid = kc_get('oid', 2, 1);
$sql = "eid,expressnumber,kremark,nsenddate";
$array_sql = explode(',', $sql);
if ($GLOBALS['ismethod']) {
$data = $_POST;
} else {
if (!($data = $king->db->getRows_one("select {$sql} from %s_orders where oid={$oid}"))) {
kc_error($king->lang->get('system/error/notre'));
}
}
$data = kc_data($array_sql, $data);
$s = '';
//eid
$express = $king->portal->getExpress();
$array_express = array();
foreach ($express as $eid => $rs) {
$array_express[$eid] = htmlspecialchars($rs['kname']);
}
$array = array(array('eid', 0, 1, 11), array('eid', 2));
$s .= $king->htmForm($king->lang->get('portal/orders/express'), kc_htm_select('eid', $array_express, $data['eid']), $array);
//expressnumber
$array = array(array('expressnumber', 0, 1, 30));
$s .= $king->htmForm($king->lang->get('portal/express/expressnumber'), kc_htm_input('expressnumber', $data['expressnumber'], 30, 200), $array);
//kremark
$array = array(array('kremark', 0, 0, 3000));
$s .= $king->htmForm($king->lang->get('portal/common/remark'), '<textarea name="kremark" id="kremark" rows="8" cols="100" class="k_in w400">' . htmlspecialchars($data['kremark']) . '</textarea>', $array);
if ($GLOBALS['ischeck']) {
$array = array();
foreach ($array_sql as $val) {
$array[$val] = $data[$val];
}
if (empty($data['nsenddate'])) {
$array['nsenddate'] = time();
}
//如果nsenddate为空，则填写当前时间戳
$array['nstatus'] = 4;
//交易状态设置为发货
$king->db->update('%s_orders', $array, "oid={$oid}");
$js = 'setTimeout("parent.location=\'manage.orders.php\'",1000)';
kc_ajax('', '', '', $js);
}
$but = kc_htm_a($king->lang->get('portal/common/delivery'), "{CMD:'express',oid:'{$oid}',IS:1,nsenddate:'{$data['nsenddate']}'}");
kc_ajax($king->lang->get('portal/title/delivery'), $s, $but, '', 440, 290 + $GLOBALS['check_num'] * 15);
}
/**
移动
*/
function king_ajax_moveto()
{
global $king;
$king->access('portal_content_edt');
$list = kc_getlist();
$listid = kc_get('listid', 2, 1);
$info = $king->portal->infoList($listid);
$model = $king->portal->infoModel($info['modelid']);
$newid = kc_get('newid', 2);
$newinfo = $king->portal->infoList($newid);
if ($newid) {
$check = array(array('newid', 12, $king->lang->get('portal/error/moveto'), $info['modelid'] != $newinfo['modelid']), array('newid', 12, $king->lang->get('portal/error/moveto1'), $listid == $newid));
$default = $newid;
} else {
$check = array();
$default = $listid;
}
$s = $king->htmForm($king->lang->get('portal/label/moveto'), $king->portal->LinkAge('newid', $default), $check);
if ($GLOBALS['ischeck'] && $newid) {
$array_list = explode(',', $list);
foreach ($array_list as $kid) {
kc_f_delete($king->config('xmlpath', 'portal') . '/portal/' . $info['modelid'] . '/' . wordwrap($kid, 1, '/', 1) . '.xml');
}
$king->db->query("update %s__{$model['modeltable']} set listid={$newid} where kid in ({$list}) or kid1 in ({$list});");
//更新列表信息
$king->portal->lastUpdated($listid, 'list');
$king->portal->lastUpdated($newid, 'list');
//删除缓存
$king->cache->del('portal/list/' . $listid);
$king->cache->del('portal/list/' . $newid);
kc_ajax('OK', "<p class=\"k_ok\">" . $king->lang->get('system/goto/ok') . "</p>", 1);
}
kc_ajax($king->lang->get('portal/common/moveto'), $s, kc_htm_a($king->lang->get('system/common/move'), "{CMD:'moveto',list:'{$list}',listid:{$listid}}"), null, 420, 120 + $GLOBALS['check_num'] * 15);
}
function king_ajax_incode()
{
global $king;
$king->access('portal_model_dbin');
/*
if($GLOBALS['ismethod']){//POST过程
$data=$_POST;
}
*/
$fields = array('modelname', 'modeltable', 'incode');
$data = kc_data($fields);
//模型名称
$_array = array(array('modelname', 0, 2, 50));
$s = $king->htmForm($king->lang->get('portal/label/newmodelname') . ' (2-50)', '<input class="k_in w200" type="text" id="modelname" name="modelname" value="' . htmlspecialchars($data['modelname']) . '" maxlength="50" />', $_array);
//数据表名称
$_array = array(array('modeltable', 0, 1, 50), array('modeltable', 1), array('modeltable', 12, $king->lang->get('system/check/none'), $king->db->getRows_one("select modelid from %s_model where modeltable='" . $king->db->escape($data['modeltable']) . "';")), array('modeltable', 18, null, $king->portal->holdmodel));
$s .= $king->htmForm($king->lang->get('portal/label/newtable') . ' (1-50)', '<input class="k_in w200" type="text" id="modeltable" name="modeltable" value="' . htmlspecialchars($data['modeltable']) . '" maxlength="50" />', $_array);
//数据表代码
if ($GLOBALS['ischeck']) {
$_array = array(array('incode', 0, 10, 9999999), array('incode', 12, $king->lang->get('portal/check/incode'), !$king->portal->unModelCode($data['incode'], $data['modelname'], $data['modeltable'])));
} else {
$_array = array();
}
$s .= $king->htmForm($king->lang->get('system/common/code'), '<textarea id="incode" name="incode" class="k_in w400" style="height:135px;font-size:10px;line-height:10px;">' . htmlspecialchars($data['incode']) . '</textarea>', $_array);
$but = kc_htm_a($king->lang->get("system/common/save"), "{CMD:'incode'}");
if ($GLOBALS['ischeck']) {
//如果以上几个都正确的话，就开始执行验证
$king->cache->del('portal/model');
$king->cache->rd('portal/model');
kc_ajax('OK', "<p class=\"k_ok\">" . $king->lang->get('system/ok/add') . "</p>", 1);
}
$height = 290 + $GLOBALS['check_num'] * 15;
kc_ajax($king->lang->get('portal/list/dbin'), $s, $but, null, 435, $height);
}
function king_ajax_lostpwd1()
{
global $king;
$username = kc_post('username');
//ask
if ($user = $king->db->getRows_one("select userid,uid,userask,useranswer,usermail from %s_user where isdelete=0 and username='******'username')) . "'")) {
if (!$user['userask']) {
kc_error($king->lang->get('user/error/ask'));
}
} else {
kc_error($king->lang->get('system/error/param'));
}
$s = $king->htmForm($king->lang->get('user/label/ask'), htmlspecialchars($user['userask']));
//answer
$array = array(array('useranswer', 0, 1, 16), array('useranswer', 12, $king->lang->get('portal/check/lost/answer'), $user['useranswer'] != kc_post('useranswer')));
$s .= $king->htmForm($king->lang->get('user/label/answer'), '<input class="k_in w150" type="text" name="useranswer" id="useranswer" maxlength="16" value="' . htmlspecialchars(kc_post('useranswer')) . '" />', $array);
//mail
$_array = array(array('usermail', 0, 6, 32), array('usermail', 5, $king->lang->get('portal/check/reg/u-4')), array('usermail', 12, $king->lang->get('portal/check/lost/mail'), strtolower($user['usermail']) != strtolower(kc_post('usermail'))));
$s .= $king->htmForm($king->lang->get('portal/user/mail'), '<input class="k_in w250" type="text" name="usermail" value="' . htmlspecialchars(kc_post('usermail')) . '" maxlength="32" />', $_array);
//pass
$_array = array(array('userpass', 0, 6, 30), array('userpass', 17, null, 'userpass1'));
$s .= $king->htmForm($king->lang->get('portal/user/pass') . ' (6-30)', '<input class="k_in w150" type="password" name="userpass" id="userpass" maxlength="30" value="' . htmlspecialchars(kc_post('userpass')) . '" />', $_array);
//repass
$s .= $king->htmForm($king->lang->get('portal/user/pass1'), '<input class="k_in w150" type="password" name="userpass1" id="userpass1" maxlength="30" value="' . htmlspecialchars(kc_post('userpass1')) . '" />');
$verify = new KC_Verify_class();
$s .= $verify->Show();
if ($GLOBALS['ischeck']) {
$array = array();
$salt = kc_random(6);
$md5pass = md5($salt . kc_post('userpass'));
$array['userpass'] = $md5pass;
$array['ksalt'] = $salt;
$userid = $king->db->update('%s_user', $array, "userid={$user['userid']}");
//写Cookie
$s = $king->user->userLogin($user['userid'], 2592000);
$king->user->delUserInfo($user['userid']);
kc_ajax($king->lang->get('system/common/welcome'), $s . "<p class=\"k_ok\">" . $king->lang->get('portal/user/lostok') . "</p>", 0);
}
$but = kc_htm_a($king->lang->get('system/common/submit'), "{URL:'" . $king->config('inst') . "user/index.php',CMD:'lostpwd1',username:'******',IS:1}");
$height = $king->config('verifyopen') ? 250 + $king->config('verifyheight') : 230;
kc_ajax($king->lang->get('portal/user/name'), $s, $but, '', 420, $height + $GLOBALS['check_num'] * 15);
}
function king_ajax_conn_edt()
{
global $king;
$king->access('#conn_edt');
$kid = kc_get('kid', 2);
$sql = "kid,kname,ksign,urlpath";
$array_sql = explode(',', $sql);
if ($GLOBALS['ismethod'] || empty($kid) || kc_post('reset') == 1) {
//若kid为空，则添加
$data = $_POST;
if (!$GLOBALS['ismethod']) {
//预置项
$data['ntype'] = isset($_POST['ntype']) ? $_POST['ntype'] : 1;
}
} else {
//编辑数据，从数据库读出
if (!($data = $king->db->getRows_one("select {$sql} from %s_conn where kid={$kid} limit 1"))) {
kc_error($king->lang->get('system/error/notrecord'));
}
}
$data = kc_data($array_sql, $data);
//kname
$array = array(array('kname', 0, 1, 50));
//验证重复值
if (empty($kid)) {
$array[] = array('kname', 12, $king->lang->get('system/conn/error/name'), $king->db->getRows_one("select kid from %s_conn where kname='" . $king->db->escape($data['kname']) . "'"));
} else {
$array[] = array('kname', 12, $king->lang->get('system/conn/error/name'), $king->db->getRows_one("select kid from %s_conn where kname='" . $king->db->escape($data['kname']) . "' and kid<>{$kid}"));
}
$s = $king->htmForm($king->lang->get('system/conn/name'), kc_htm_input('kname', $data['kname'], 50, 400), $array);
//urlpath
$array = array(array('urlpath', 0, 0, 50), array('urlpath', 6), array('urlpath', 12, $king->lang->get('system/conn/error/urlpath'), substr($data['urlpath'], -1, 1) == '/'));
$s .= $king->htmForm($king->lang->get('system/conn/urlpath'), kc_htm_input('urlpath', $data['urlpath'], 50, 400), $array);
//ksign
$array = array(array('ksign', 0, 0, 32));
$s .= $king->htmForm($king->lang->get('system/conn/sign'), kc_htm_input('ksign', $data['ksign'], 32, 250), $array);
if ($GLOBALS['ischeck']) {
$array = array('kname' => $data['kname'], 'urlpath' => $data['urlpath'], 'ksign' => $data['ksign']);
if (empty($kid)) {
//insert
$array['norder'] = $king->db->neworder('%s_conn');
$king->db->insert('%s_conn', $array);
} else {
$king->db->update('%s_conn', $array, "kid={$kid}");
}
$king->cache->del('system/conn/info');
kc_ajax('OK', "<p class=\"k_ok\">" . $king->lang->get('system/ok/' . (empty($kid) ? 'add' : 'edt')) . "</p>", 1);
}
$but = kc_htm_a($king->lang->get("system/common/" . (empty($kid) ? 'add' : 'edit')), "{URL:'../system/manage.php',CMD:'conn_edt',kid:'{$kid}',IS:1}");
kc_ajax($king->lang->get('system/title/conn'), $s, $but, '', 440, 170 + $GLOBALS['check_num'] * 15);
}
function king_ajax_orders()
{
global $king;
//显示物流方式选择页，并显示对应的物流费用
//订单insert到数据库，并返回订单号。以便客户查询订单，也为邮政付款的用户提供收据上传功能
//清空购物记录
$king->Load('user');
$tip = ($user = $king->user->checkLogin()) ? '' : '<a href="javascript:;" class="k_user_login">' . $king->lang->get('portal/user/nologin') . '</a> <a href="javascript:;" class="k_user_register">' . $king->lang->get('portal/user/regshop') . '</a>';
$array_sql = array('usermail', 'realname', 'useraddress', 'userpost', 'usertel', 'kfeedback');
if ($GLOBALS['ismethod']) {
$data = $_POST;
} else {
$data = array();
if (is_array($user)) {
//用户已登录
foreach ($array_sql as $val) {
$data[$val] = kc_val($user, $val);
}
}
}
$data = kc_data($array_sql, $data);
//kconsignee
$array = array(array('realname', 0, 2, 30));
$s = $king->htmForm($king->lang->get('portal/orders/realname'), kc_htm_input('realname', $data['realname'], 30, 100), $array, null, $tip);
//ktel
$array = array(array('usertel', 0, 6, 30));
$s .= $king->htmForm($king->lang->get('portal/orders/tel'), kc_htm_input('usertel', $data['usertel'], 30, 200), $array);
//kmail
$array = array(array('usermail', 0, 6, 32), array('usermail', 5));
$s .= $king->htmForm($king->lang->get('portal/orders/mail'), kc_htm_input('usermail', $data['usermail'], 32, 200), $array);
//kaddress
$array = array(array('useraddress', 0, 5, 250));
$s .= $king->htmForm($king->lang->get('portal/orders/address'), '<textarea cols="10" id="useraddress" name="useraddress" rows="3" class="k_in w400">' . htmlspecialchars($data['useraddress']) . '</textarea>', $array);
//kpost
$array = array(array('userpost', 0, 6, 6), array('userpost', 2));
$s .= $king->htmForm($king->lang->get('portal/orders/post'), kc_htm_input('userpost', $data['userpost'], 6, 50), $array);
//kfeedback
$array = array(array('kfeedback', 0, 0, 255));
$s .= $king->htmForm($king->lang->get('portal/orders/feedback'), '<textarea cols="10" rows="4" name="kfeedback" id="kfeedback" class="k_in w400">' . htmlspecialchars($data['kfeedback']) . '</textarea>', $array);
if ($GLOBALS['ischeck']) {
$cart = kc_cookie('KingCMS_Cart');
$eid = kc_post('eid');
if (!($cart && isset($eid))) {
kc_error($king->lang->get('system/error/param'));
}
$weight = 0;
$total = 0;
$nnum = 0;
$cart_array = unserialize($cart);
//要过滤掉的内容
$array_black = str_split('<>\'"%');
foreach ($cart_array as $key => $number) {
list($listid, $kid) = explode('-', $key);
$ID = $king->portal->infoID($listid, $kid);
if ($total === 0) {
//第一次运算
$mch_name = kc_substr(str_replace($array_black, '', $ID['ktitle']), 0, 16);
}
$weight += $number * $ID['nweight'];
$total += $number * $ID['nprice'];
$nnum += $number;
}
$nexpress = 0;
//运费
if ($weight !== 0) {
$express = $king->portal->getExpress();
$nexpress = $express[$eid]['nsprice'] + $express[$eid]['niprice'] * ceil($weight > 500 ? $weight / 500 - 1 : 0);
}
$ono = kc_formatdate(time(), 'Ymd') . sprintf("%08.0d", $king->db->neworder('%s_orders', '', 'oid'));
$array = array('kname' => $mch_name, 'userid' => is_array($user) ? $user['userid'] : 0, 'kcontent' => $cart, 'ndate' => time(), 'nip' => kc_getip(), 'eid' => $eid, 'ntotal' => round($total, 2), 'ono' => $ono, 'nnumber' => $nnum, 'kfeedback' => $data['kfeedback'], 'nweight' => $weight, 'nexpress' => $nexpress);
foreach ($array_sql as $val) {
$array[$val] = kc_val($data, $val);
}
$oid = $king->db->insert('%s_orders', $array);
setcookie('KingCMS_Cart', '', -86400000, $king->config('inst'));
$js = "\$.kc_ajax('{URL:\\'" . $king->config('inst') . "portal/cart.php\\',CMD:\\'payment\\',IS:1,oid:{$oid}}')";
kc_ajax('', '', '', $js);
}
$but = kc_htm_a($king->lang->get('portal/cart/backcart'), "{URL:'" . $king->config('inst') . "portal/cart.php',CMD:'buy',IS:1}");
$but .= kc_htm_a($king->lang->get('portal/cart/suborders'), "{URL:'" . $king->config('inst') . "portal/cart.php',CMD:'orders',eid:" . kc_post('eid') . ",IS:1}");
kc_ajax($king->lang->get('portal/cart/suborders'), $s, $but, '', 600, 350 + $GLOBALS['check_num'] * 15);
}
/**
添加/编辑碎片
*/
function king_ajax_edt()
{
global $king;
$king->access('dbquery_edt');
$kid = kc_get('kid', 2);
$sql = "kid,kname,ntype,dbhost,dbname,dbfile,dbuser,dbpass,dbcharset";
$array_sql = explode(',', $sql);
if ($GLOBALS['ismethod'] || empty($kid) || kc_post('reset') == 1) {
//若kid为空，则添加
$data = $_POST;
if (!$GLOBALS['ismethod']) {
//预置项
$data['ntype'] = isset($_POST['ntype']) ? $_POST['ntype'] : 1;
}
} else {
//编辑数据，从数据库读出
if (!($data = $king->db->getRows_one("select {$sql} from %s_dbquery where kid={$kid} limit 1"))) {
kc_error($king->lang->get('system/error/notrecord'));
}
}
$data = kc_data($array_sql, $data);
//ntype
$array_type = array(1 => 'MySQL', 2 => 'SQLite');
$exp = " onClick=\"\$('#ntype').val(\$(this).val());setTimeout('\$.kc_ajax({URL:\\'../dbquery/manage.php\\',CMD:\\'edt\\',IS:1,METHOD:\\'GET\\',kid:\\'{$kid}\\',reset:1})',50)\" ";
$s = $king->htmForm($king->lang->get('dbquery/label/type'), kc_htm_radio('ntype_show', $array_type, $data['ntype'], $exp));
$s .= kc_htm_hidden(array('ntype' => $data['ntype']));
//kname
$array = array(array('kname', 0, 1, 50));
//验证重复值
if (empty($kid)) {
$array[] = array('kname', 12, $king->lang->get('dbquery/error/name'), $king->db->getRows_one("select kid from %s_dbquery where kname='" . $king->db->escape($data['kname']) . "'"));
} else {
$array[] = array('kname', 12, $king->lang->get('dbquery/error/name'), $king->db->getRows_one("select kid from %s_dbquery where kname='" . $king->db->escape($data['kname']) . "' and kid<>{$kid}"));
}
$s .= $king->htmForm($king->lang->get('dbquery/label/name'), kc_htm_input('kname', $data['kname'], 50, 200), $array);
if ($data['ntype'] == 1) {
//mysql
//dbhost
$array = array(array('dbhost', 0, 1, 50));
$s .= $king->htmForm($king->lang->get('dbquery/label/dbhost'), kc_htm_input('dbhost', $data['dbhost'], 50, 400), $array);
//dbname
$array = array(array('dbname', 0, 1, 50));
$s .= $king->htmForm($king->lang->get('dbquery/label/dbname'), kc_htm_input('dbname', $data['dbname'], 50, 400), $array);
//dbuser
$array = array(array('dbuser', 0, 1, 50));
$s .= $king->htmForm($king->lang->get('dbquery/label/dbuser'), kc_htm_input('dbuser', $data['dbuser'], 50, 200), $array);
//dbpass
$array = array(array('dbpass', 0, 0, 50));
$s .= $king->htmForm($king->lang->get('dbquery/label/dbpass'), kc_htm_input('dbpass', $data['dbpass'], 50, 200), $array);
//dbcharset
$array = array(array('dbcharset', 0, 0, 50));
$array_charset = array('UTF-8' => 'UTF-8', 'GBK' => 'GBK');
$s .= $king->htmForm($king->lang->get('dbquery/label/dbcharset'), kc_htm_select('dbcharset', $array_charset, $data['dbcharset']), $array);
$height = 340;
} else {
//dbfile
$array = array(array('dbfile', 0, 4, 50), array('dbfile', 12, $king->lang->get('dbquery/error/dbfile'), !is_file(ROOT . $data['dbfile'])));
$s .= $king->htmForm($king->lang->get('dbquery/label/dbfile'), kc_htm_input('dbfile', $data['dbfile'], 50, 400), $array);
$height = 160;
}
if ($GLOBALS['ischeck']) {
if ($data['ntype'] == 1) {
$array = array('ntype' => 1, 'kname' => $data['kname'], 'dbhost' => $data['dbhost'], 'dbname' => $data['dbname'], 'dbuser' => $data['dbuser'], 'dbpass' => $data['dbpass'], 'dbcharset' => $data['dbcharset']);
} else {
$array = array('ntype' => 2, 'kname' => $data['kname'], 'dbfile' => $data['dbfile']);
}
if (empty($kid)) {
//insert
$array['norder'] = $king->db->neworder('%s_dbquery');
$king->db->insert('%s_dbquery', $array);
} else {
$king->db->update('%s_dbquery', $array, "kid={$kid}");
}
$king->cache->del("dbquery/info/{$data['kname']}");
kc_ajax('OK', "<p class=\"k_ok\">" . $king->lang->get('system/ok/' . (empty($kid) ? 'add' : 'edt')) . "</p>", 1);
}
$tit = $king->lang->get('dbquery/title/' . (empty($kid) ? 'add' : 'edt'));
$but = kc_htm_a($king->lang->get("system/common/" . (empty($kid) ? 'add' : 'edit')), "{URL:'../dbquery/manage.php',CMD:'edt',kid:'{$kid}',IS:1}");
kc_ajax($tit, $s, $but, '', 440, $height + $GLOBALS['check_num'] * 15);
}
/**
编辑文本
*/
function king_ajax_edit()
{
global $king;
$king->access('webftp_edit');
$path = kc_post('path');
$ext = kc_f_ext($path);
switch ($ext) {
case 'html':
$code = 'html';
break;
case 'htm':
$code = 'html';
break;
case 'shtml':
$code = 'html';
break;
case 'shtm':
$code = 'html';
break;
case 'css':
$code = 'css';
break;
case 'js':
$code = 'js';
break;
case 'php':
$code = 'php';
break;
case 'php3':
$code = 'php';
break;
case 'php4':
$code = 'php';
break;
case 'sql':
$code = 'sql';
break;
case 'xml':
$code = 'xml';
break;
default:
$code = '';
}
if (isset($_POST['webftpcontent'])) {
//写文件
kc_f_put_contents($path, $_POST['webftpcontent'], 1);
kc_ajax('OK', "<p class=\"k_ok\">" . $king->lang->get('system/ok/save') . "</p>");
}
if (!kc_f_isfile($path)) {
kc_error($king->lang->get('system/error/notfile'));
}
$content = kc_f_get_contents($path);
$js = "editAreaLoader.init({\r\n\t\t\tid: \"webftpcontent\"\r\n\t\t\t,start_highlight: " . (strlen($content) > 10240 ? 'false' : 'true') . "\r\n\t\t\t,allow_resize: \"both\"\r\n\t\t\t,allow_toggle: false\r\n\t\t\t,word_wrap: true\r\n\t\t\t,language: \"en\"\r\n\t\t\t,syntax: \"php\"\r\n\t\t});";
$s = "<textarea id=\"webftpcontent\" name=\"webftpcontent\" rows=\"15\" cols=\"80\" style=\"width:870px;height:420px\">";
$s .= htmlspecialchars($content);
$s .= "</textarea>";
$but = kc_htm_a($king->lang->get('system/common/save'), "{CMD:'edit',IS:1,path:'{$path}'}");
kc_ajax($king->lang->get('system/common/edit') . ' : ' . $path, $s, $but, $js, 900, 450);
}
function king_ajax_list_addeditor()
{
global $king;
$king->access('portal_editor_edt');
$listid = kc_get('listid', 2, 1);
//kc_error($listid);
$array = array(array('username', 0, 3, 15));
if (kc_post('username')) {
$array[] = array('username', 12, $king->lang->get('user/check/notuser'), !($res = $king->db->getRows_one("select userid from %s_user where username='******'username')) . "';")));
if ($res) {
$array[] = array('username', 12, $king->lang->get('user/check/repeatuser'), $king->db->getRows_one("select kid from %s_list_editor where userid={$res['userid']} and listid={$listid}"));
}
}
$s = $king->htmForm($king->lang->get('portal/user/name'), kc_htm_input('username', kc_post('username'), 15, 150), $array);
$s .= $king->htmForm($king->lang->get('portal/label/issub'), '<span><input id="issub" name="issub" type="checkbox" value="1"/><label for="issub">' . $king->lang->get('portal/help/issub') . '</label></span>');
if ($GLOBALS['ischeck']) {
$array = array('userid' => $res['userid'], 'issub' => kc_post('issub') ? 1 : 0, 'listid' => $listid);
$king->db->insert('%s_list_editor', $array);
$js = "\$.kc_ajax('{CMD:\\'list_editor\\',listid:{$listid},IS:1}')";
kc_ajax('', '', '', $js);
}
$but = $king->db->getRows("select kid from %s_list_editor where listid={$listid}") ? kc_htm_a($king->lang->get('portal/title/listeditor'), "{CMD:'list_editor',listid:{$listid},IS:1}") : '';
$but .= kc_htm_a($king->lang->get('system/common/add'), "{CMD:'list_addeditor',listid:{$listid},IS:1}");
kc_ajax($king->lang->get('portal/title/listeditoredt'), $s, $but, '', 400, 120 + $GLOBALS['check_num'] * 15);
}
