public static function getUpid($nameone) { $districtinfo = db_factory::get_one('select * from ' . TABLEPRE . 'witkey_district where name="' . $nameone . '"'); if ($districtinfo) { $twoupid = $districtinfo['id']; } else { $insertsqlarr['name'] = $nameone; $insertsqlarr['upid'] = "0"; $intResult = db_factory::inserttable(TABLEPRE . 'witkey_district', $insertsqlarr); $twoupid = $intResult; } return $twoupid; }
foreach ($arrIndusC as $k => $v) { $arrNewIndusC[$v['indus_pid']][] = $v; } } if (isset($ky)) { $ky = htmlspecialchars($ky); $ky = kekezu::escape($ky); $arrHwStatus = db_factory::query("select v from " . TABLEPRE . "witkey_basic_config where k='hot_words_status'"); $arrUpdateStatus = db_factory::query("select v from " . TABLEPRE . "witkey_basic_config where k='update_status'"); $arrSearch = db_factory::query("select * from " . TABLEPRE . "witkey_hotwords where words = '{$ky}'"); if ($arrHwStatus[0]['v'] == 'open') { if ($arrUpdateStatus[0]['v'] == 'auto') { if (count($arrSearch)) { db_factory::updatetable(TABLEPRE . "witkey_hotwords", array('count' => $arrSearch[0]['count'] + 1, 'time' => time()), array('words' => $arrSearch[0]['words'])); } else { db_factory::inserttable(TABLEPRE . "witkey_hotwords", array('words' => $ky, 'time' => time(), 'auto' => '1')); } } else { if (count($arrSearch)) { db_factory::updatetable(TABLEPRE . "witkey_hotwords", array('count' => $arrSearch[0]['count'] + 1, 'time' => time()), array('words' => $arrSearch[0]['words'], 'auto' => '0')); } } } } $arrPayitemConfig = keke_payitem_class::get_payitem_config(null, null, null, 'item_id'); $arrIndusAll = $kekezu->_indus_arr; $arrModelLabel = array(0 => '未知', 1 => '单人', 2 => '多人', 3 => '计件', 4 => '招标', 5 => '订金', 6 => '文件', 7 => '服务'); $page and $intPage = intval($page); $intPage = intval($intPage) ? $intPage : 1; $intPagesize = intval($intPagesize) ? $intPagesize : 10; $strSql = "select a.*,substring(payitem_time,instr(a.payitem_time,'top')+4+LENGTH('top'),10) as top_time\n\t\t from " . TABLEPRE . "witkey_service as a where ";
} } if ($msgConfigsTpl) { foreach ($msgConfigsTpl as $k => $v) { $insertsqlarr = array(); $insertsqlarr['content'] = $msgConfigsTpl[$k]['content'] ? str_replace(array('<p></p>', '<p><br/></p>', '<p><br /></p>'), array('', '', ''), htmlspecialchars_decode($msgConfigsTpl[$k]['content'])) : ''; $insertsqlarr['content'] = $msgConfigsTpl[$k]['content'] ? str_replace(array('task_id='), array('id='), $msgConfigsTpl[$k]['content']) : ''; if ($k == 'get_password') { $insertsqlarr['mobile_content'] = $insertsqlarr['content'] ? str_replace(array('<p></p>', '<p><br/></p>', '<p><br /></p>'), array('', '', ''), htmlspecialchars_decode($insertsqlarr['content'])) : $insertsqlarr['content']; } else { $insertsqlarr['mobile_content'] = $msgConfigsTpl[$k]['mobile_content'] ? str_replace(array('<p></p>', '<p><br/></p>', '<p><br /></p>'), array('', '', ''), htmlspecialchars_decode($msgConfigsTpl[$k]['mobile_content'])) : $insertsqlarr['content']; } $insertsqlarr['k'] = $msgConfigsTpl[$k]['k']; $insertsqlarr['obj'] = $msgConfigsTpl[$k]['obj']; $insertsqlarr['desc'] = $msgConfigsTpl[$k]['desc']; $insertsqlarr['prompt'] = $msgConfigsTpl[$k]['prompt']; $insertsqlarr['v'] = 'a:2:{s:8:"send_sms";i:1;s:10:"send_email";i:1;}'; $insertsqlarr['on_time'] = $msgConfigsTpl[$k]['on_time']; //$insertsqlarr['content'] = $msgConfigsTpl[$k]['content']; $insertsqlarr['send_type'] = $msgConfigsTpl[$k]['send_type']; //$insertsqlarr['mobile_content'] = $msgConfigsTpl[$k]['mobile_content']; $insertsqlarr['mobile'] = 0; if (!in_array($k, $smsListsKeys)) { db_factory::inserttable(TABLEPRE . 'witkey_msg_config', $insertsqlarr); } else { $wheresqlarr = array(); $wheresqlarr['k'] = $k; db_factory::updatetable(TABLEPRE . 'witkey_msg_config', $insertsqlarr, $wheresqlarr); } } }
static function save_feed($feed_arr, $uid, $username, $feedtype = "", $obj_id = 0, $obj_link = "", $icon = '') { $title = serialize($feed_arr); $insertsqlarr = array(); $insertsqlarr['icon'] = $icon; $insertsqlarr['feed_time'] = time(); $insertsqlarr['feedtype'] = $feedtype; $insertsqlarr['obj_link'] = $obj_link; $insertsqlarr['obj_id'] = $obj_id; $insertsqlarr['title'] = $title; $insertsqlarr['uid'] = $uid; $insertsqlarr['username'] = $username; return db_factory::inserttable(TABLEPRE . 'witkey_feed', $insertsqlarr); }
<?php $excite_uid and $intExciteUid = intval($excite_uid); $excite_code and $strExciteCode = strval($excite_code); $arrUserInfo = kekezu::get_user_info($intExciteUid); if ($arrUserInfo) { $strMd5Code = md5($arrUserInfo['uid'] . ',' . $arrUserInfo['username'] . ',' . $arrUserInfo['email']); if ($arrUserInfo['status'] == '3') { if ($strMd5Code == $strExciteCode) { $intRes = db_factory::execute(sprintf("update %switkey_space set status='1' where uid='%d'", TABLEPRE, $intExciteUid)); if ($intRes) { $arrAuthDatas = array('email_a_id' => null, 'uid' => $arrUserInfo['uid'], 'username' => $arrUserInfo['username'], 'email' => $arrUserInfo['email'], 'auth_time' => time(), 'auth_status' => '1'); db_factory::inserttable(TABLEPRE . "witkey_auth_email", $arrAuthDatas); $arrRecordDatas = array('record_id' => null, 'auth_code' => 'email', 'uid' => $arrUserInfo['uid'], 'username' => $arrUserInfo['username'], 'auth_status' => '1'); db_factory::inserttable(TABLEPRE . "witkey_auth_record", $arrRecordDatas); $objMessage = new keke_msg_class(); if ($objMessage->validate('reg')) { $objMessage->send_message($arrUserInfo['uid'], $arrUserInfo['username'], 'reg', '注册成功', array(), $arrUserInfo['email'], '', 2); } } } } } else { kekezu::show_msg($_lang['operate_notice'], 'index.php', 3, '待激活的账号不存在', 'warning'); }
public static function set_task_comment($comment_arr, $is_reply = false) { strtolower(CHARSET) == 'gbk' and $comment_arr['content'] = kekezu::utftogbk($comment_arr['content']); $comment_arr['content'] = kekezu::escape(kekezu::str_filter($comment_arr['content'])); $lid = db_factory::inserttable(TABLEPRE . "witkey_comment", $comment_arr, 1); $is_reply or db_factory::execute(sprintf("update %switkey_task set leave_num = leave_num+1 where task_id = '%d'", TABLEPRE, $comment_arr['obj_id'])); return $lid; }
<?php $url = "index.php?do={$do}&view={$view}&target_id={$target_id}"; if (isset($stb_add)) { eval("\$arr=" . kekezu::k_stripslashes($position) . ";"); $position = serialize($arr); $insertsqlarr = array('name' => $name, 'code' => $code, 'description' => $description, 'targets' => $targets, 'position' => $position, 'ad_size' => $ad_size, 'ad_num' => $ad_num, 'sample_pic' => $sample_pic); if ($target_id) { $result = db_factory::updatetable("keke_witkey_ad_target", $insertsqlarr, array("target_id" => $target_id)); } else { $result = db_factory::inserttable('keke_witkey_ad_target', $insertsqlarr); } $result && kekezu::admin_show_msg($_lang['add_submit_success'], $url, 3, '', 'success'); } if ($target_id) { $target_arr = db_factory::get_one("select * from " . TABLEPRE . "witkey_ad_target where target_id='{$target_id}'"); $target_arr['position'] = var_export(unserialize($target_arr['position']), 1); } require $template_obj->template(ADMIN_DIRECTORY . '/tpl/admin_' . $do . '_' . $view);