function plugins_set_mine($id, $is_del = 0) { $id = intval($id); $is_del = intval($is_del); $val = ''; $uid = get_sess_userid(); global $tablePreStr; $t_users = $tablePreStr . "users"; $t_plugins = $tablePreStr . "plugins"; $result_rs = array(); $dbo = new dbex(); dbplugin('r'); $u_apps = get_sess_apps(); if ($is_del == 0) { if ($u_apps == '') { $val = $id; } else { $val = $u_apps . "," . $id; } } else { $val = str_replace(",{$id},", "", ",{$u_apps},"); } $sql = " update {$t_users} set use_apps = '{$val}' where user_id = {$uid} "; if ($dbo->exeUpdate($sql)) { set_sess_apps($val); if ($is_del == 0) { $sql = " update {$t_plugins} set use_num=use_num+1 where id={$id} "; } else { $sql = " update {$t_plugins} set use_num=use_num-1 where id={$id} "; } return $dbo->exeUpdate($sql); } else { return 0; } }
function code_exists() { $is_admin = ''; $sendor_id = ''; $admin_id = get_session('admin_id'); if ($admin_id) { $is_admin = 1; $sendor_id = $admin_id; } else { $user_id = get_sess_userid(); if (!$user_id) { return false; exit; } $is_admin = 0; $sendor_id = $user_id; } if ($sendor_id != '' && $is_admin !== '') { global $inviteCodeValue; global $tablePreStr; global $inviteCodeLength; $t_invite_code = $tablePreStr . "invite_code"; $t_users = $tablePreStr . "users"; if ($is_admin == 0) { $user_info = api_proxy('user_self_by_uid', 'integral', $sendor_id); $intg = $user_info['integral']; if ($inviteCodeValue > $intg) { return false; } } $dbo = new dbex(); dbplugin('r'); $invite_code = randkeys($inviteCodeLength); $sql = "select id from {$t_invite_code} where code_txt='{$invite_code}'"; $is_exists = $dbo->getRow($sql); if ($is_exists['id']) { code_exists(); } else { $time = time(); $sql = "insert into {$t_invite_code} (sendor_id,code_txt,is_admin,add_time) values({$sendor_id},'{$invite_code}',0,{$time})"; $success = $dbo->exeUpdate($sql); if ($success) { if ($is_admin == 0) { $sql = "update {$t_users} set integral=integral-{$inviteCodeValue} where user_id={$sendor_id}"; $dbo->exeUpdate($sql); } return $invite_code; } else { return false; } } } }
function msgboard_set($to_user_id) { global $tablePreStr; $dbo = new dbex(); dbplugin('w'); $t_message = $tablePreStr . "msgboard"; $sql = "update {$t_message} set readed=1 where to_user_id='{$to_user_id}'"; $dbo->exeUpdate($sql); }
function scrip_send($sender, $title, $content, $to_id, $scrip_id = '') { global $tablePreStr; $uid = get_sess_userid(); $uico = get_sess_userico(); $t_scrip = $tablePreStr . "msg_inbox"; $dbo = new dbex(); dbplugin('w'); $sql = "insert into {$t_scrip} (mess_title,mess_content,from_user,from_user_ico,user_id,add_time,from_user_id,mesinit_id)" . "value('{$title}','{$content}','{$sender}','{$uico}',{$to_id},NOW(),{$uid},'{$scrip_id}')"; return $dbo->exeUpdate($sql); }
function money_set_add_user_money($user_id, $consume_point, $exchange_datetime, $exchange_money) { global $tablePreStr; $t_money = $tablePreStr . "money"; $result_rs = array(); $dbo = new dbex(); dbplugin('w'); //insert into isns_money (user_id, consume_point, exchange_datetime, exchange_money) value (1, 10, '2015-08-11 15:55:23', 33); $sql = "insert into {$t_money} (user_id, consume_point, exchange_datetime, exchange_money) \n\t\t\tvalue ({$user_id}, {$consume_point}, '{$exchange_datetime}', {$exchange_money})"; $result_rs = $dbo->exeUpdate($sql); return $result_rs; }
function user_set_update_user_point($user_id, $user_point) { global $tablePreStr; $t_users = $tablePreStr . "users"; $result_rs = array(); $dbo = new dbex(); dbplugin('w'); //update isns_users set user_point=2000 where user_id=1; $sql = "update {$t_users} set user_point={$user_point} where user_id={$user_id}"; $result_rs = $dbo->exeUpdate($sql); return $result_rs; }
function paper_add_view_count($paper_id) { global $tablePreStr; $t_papers = $tablePreStr . "papers"; $result_rs = array(); $dbo = new dbex(); dbplugin('r'); $get_view_count_sql = "select {$t_papers}.view_count from {$t_papers} where {$t_papers}.paper_id={$paper_id}"; $result_rs = $dbo->getRow($get_view_count_sql); $view_count = $result_rs['view_count']; $view_count += 1; //读写分离定义函数 dbtarget('w', $dbServs); $update_view_count_sql = "update {$t_papers} set {$t_papers}.view_count={$view_count} where {$t_papers}.paper_id={$paper_id}"; if ($dbo->exeUpdate($update_view_count_sql)) { //执行成功返回到我发的纸条界面 return true; } return false; }
function tag_relation($mod_id, $tag_id, $content_id, $type = 'add') { global $tablePreStr; global $dbo; $dbo = new dbex(); dbplugin('w'); $table = $tablePreStr . "tag_relation"; $tag_id = explode(',', $tag_id); foreach ($tag_id as $rs) { if ($rs != '') { if ($type == 'add') { $sql = "insert into {$table} (`id`,`mod_id`,`content_id`) values ({$rs},{$mod_id},{$content_id})"; } else { $sql = "delete from {$table} where content_id={$content_id} and id={$tag_id} and mod_id={$mod_id}"; } if (!$dbo->exeUpdate($sql)) { return 'error'; break; } } } }
//insert into isns_papers (user_id, content, picture, create_time) value (1, '纸条内容', '纸条路径', '2015-08-12 15:57:12'); dbplugin('r'); $get_comment_count_sql = "select {$t_papers}.comment_count,{$t_papers}.private_count from {$t_papers} where {$t_papers}.paper_id={$paper_id}"; $result_rs = $dbo->getRow($get_comment_count_sql); $comment_count = $result_rs['comment_count']; $private_count = $result_rs['private_count']; if ($comment_type == 0) { $comment_count += 1; } else { $private_count += 1; } //读写分离定义函数 dbtarget('w', $dbServs); /* update isns_papers set isns_papers.comment_count = 3 where isns_papers.paper_id=111114; */ $update_comment_count_sql = "update {$t_papers} set {$t_papers}.comment_count={$comment_count},{$t_papers}.private_count={$private_count} where {$t_papers}.paper_id={$paper_id}"; if ($dbo->exeUpdate($update_comment_count_sql)) { //插入纸条评论 //insert into isns_comments (paper_id, comment_content, commenter_id, comment_time, comment_status, comment_type) //value (1111111, "abc", 1, '2015-08-05 22:39:12', 0, 1); $sql = "insert into {$t_comments} (paper_id, comment_content, commenter_id, comment_time, comment_status, comment_type) \n\t\tvalue ({$paper_id}, '{$comment_content}', {$commenter_id}, '{$current_time}', 0, {$comment_type})"; if ($dbo->exeUpdate($sql)) { //if(0 == $comment_type) //{ action_return(1, '', 'modules.php?app=paper_show_detail&paper_id=' . $paper_id); //}else{ //action_return(1, '', 'modules.php?app=pick_paper_detail&paper_id='.$paper_id); //} } else { action_return(0, 'error', '-1'); } } else {
$t_subject_comment = $tablePreStr . "group_subject_comment"; $t_mood = $tablePreStr . "mood"; $t_mood_comment = $tablePreStr . "mood_comment"; $dbo = new dbex(); switch ($type_id) { case "0": $t_table = $t_blog; $t_table_com = $t_blog_comment; $mod_col = "log_id"; break; case "1": $group_info = api_proxy("group_sub_by_sid", "group_id", $com_id); $group_id = $group_info['group_id']; dbtarget('w', $dbServs); $sql = "update {$t_group} set comments=comments-1 where group_id={$group_id}"; $dbo->exeUpdate($sql); $t_table = $t_subject; $t_table_com = $t_subject_comment; $mod_col = "subject_id"; break; case "2": $t_table = $t_album; $t_table_com = $t_album_comment; $mod_col = "album_id"; break; case "3": $t_table = $t_photo; $t_table_com = $t_photo_comment; $mod_col = "photo_id"; break; case "4":
$page = 1; $count = 50; $since_id = 0; $max_id = 0; $base_app = 0; $trim_user = 0; $feature = 1; // 0-全部,1-原创,2-图片,3-视频,4-音乐 $statuses = $c->user_timeline_by_id($uid, $page, $count, $since_id, $max_id, $feature, $trim_user, $base_app); if_weiboapi_fail($statuses); foreach ($statuses['statuses'] as $status) { if ("{$wid}" == $status['idstr']) { // wid 是当前用户的原创微博 // 扣钱先 $sql = "update user set realtime_money = realtime_money - {$db_total_price} where user_id = '{$_SESSION['uid']}' limit 1"; $num = $dbo->exeUpdate($sql); if (1 != $num) { $msg = "扣钱失败,跳转。SQL:" . $sql; debug($msg, __FILE__, __LINE__); } // 扣钱成功,写task表 $sql = "insert into task (owner_id, publisher_id, type, base_price, amount, status, create_at, expire_in) values('{$_SESSION['uid']}', '{$_SESSION['uid']}', 1, '{$db_base_price}', '{$amount}', 1, now(), '{$expire_in_sec}')"; $num = $dbo->exeUpdate($sql); if (1 != $num) { // 写数据表失败,回滚金钱数据 $sql2 = "update user set realtime_money=realtime_money + {$db_total_price} where user_id = '{$_SESSION['uid']}' limit 1"; $num2 = $dbo->exeUpdate($sql2); if (1 != $num2) { $msg = "回滚金钱数据失败,这个比较糟糕。SQL:" . $sql2; debug($msg, __FILE__, __LINE__); }
//读写分离定义函数 dbtarget('r', $dbServs); //删除blog内部的图片 $blog_content = api_proxy("blog_self_by_bid", "log_content", $ulog_id); $blog_content = $blog_content['log_content']; preg_match_all("/classId=\"\\d\"/", $blog_content, $match); $match = preg_replace("/[classId=,\"]/", '', $match[0]); if (!empty($match)) { $match = join(",", $match); $sql = "select file_src from {$t_uploadfile} where id in ({$match})"; $file_src = $dbo->getRs($sql); foreach ($file_src as $rs) { unlink($rs['file_src']); } } //定义写操作 dbtarget('w', $dbServs); if (!empty($match)) { $sql = "delete from {$t_uploadfile} where id in ({$match})"; $dbo->exeUpdate($sql); } $sql = "delete from {$t_blog} where log_id={$ulog_id} and user_id={$user_id}"; if ($dbo->exeUpdate($sql) && mysql_affected_rows() > 0) { $sql = "delete from {$t_blog_comments} where log_id={$ulog_id}"; $dbo->exeUpdate($sql); increase_integral($dbo, $int_del_blog, $user_id); del_affair($dbo, 0, $ulog_id); action_return(1, '', 'modules.php?app=blog_list'); } else { action_return(0, $b_langpackage->b_del_false); }
$give_point = intval(get_argp('give_point')); $user_id = get_sess_userid(); $dbo = new dbex(); //增加评论数 //insert into isns_papers (user_id, content, picture, create_time) value (1, '纸条内容', '纸条路径', '2015-08-12 15:57:12'); dbplugin('r'); $check_sql = "select * from {$t_papers} where {$t_papers}.paper_id={$paper_id} and {$t_papers}.user_id={$user_id}"; $result_rs = $dbo->getRow($check_sql); if (empty($result_rs)) { action_return(0, 'error', '-1'); } //读写分离定义函数 dbtarget('w', $dbServs); /* update isns_papers set isns_papers.paper_status = 1 where isns_papers.paper_id=111114; */ $update_paper_status_sql = "update {$t_papers} set {$t_papers}.paper_status=1 where {$t_papers}.paper_id={$paper_id}"; $result_rs = $dbo->exeUpdate($update_paper_status_sql); $update_comment_money_sql = "update {$t_comments} set comment_money = {$give_point} where paper_id = {$paper_id} and comment_status = 1"; $dbo->exeUpdate($update_comment_money_sql); if ($result_rs) { dbplugin('r'); $query_receiver_point_sql = "select {$t_users}.user_point from {$t_users} where {$t_users}.user_id={$point_receiver_id}"; $result_rs = $dbo->getRow($query_receiver_point_sql); if (empty($result_rs)) { action_return(0, 'error', '-2'); } $receiver_point = $result_rs['user_point']; $receiver_point += $give_point; dbtarget('w', $dbServs); //插入纸条评论 $add_user_point_sql = "update {$t_users} set {$t_users}.user_point={$receiver_point} where {$t_users}.user_id={$point_receiver_id}"; if ($dbo->exeUpdate($add_user_point_sql)) {
foreach ($cho as $v) { $option .= "," . $v; } $sql = "select `option` from {$t_polloption} where oid in(0.{$option})"; $option_rs = $dbo->getRs($sql); $cho_str = ''; foreach ($option_rs as $val) { $cho_str .= "\"" . $val['option'] . "\","; } //定义写操作 dbtarget('w', $dbServs); foreach ($cho as $value) { if (short_check($value) != '') { $cho_value = short_check($value); $sql = "update {$t_polloption} set votenum=votenum+1 where oid={$cho_value}"; $dbo->exeUpdate($sql); } } //加分过程 if (!empty($total_credit) && !empty($per_int)) { if ($total_credit <= $per_int) { $per_int = $total_credit; $sql = "update {$t_poll} set credit = 0 , percredit = 0 where p_id={$pid}"; $dbo->exeUpdate($sql); } else { $sql = "update {$t_poll} set credit=credit-{$per_int} where p_id={$pid}"; $dbo->exeUpdate($sql); } $sql = "update {$t_users} set integral=integral+{$per_int} where user_id={$user_id}"; $is_suc = $dbo->exeUpdate($sql); }
<?php //引入语言包 $pr_langpackage = new privacylp(); //变量获得 $user_id = get_sess_userid(); $input_mess_para = short_check(get_argp('input_mess')); //数据表定义区 $t_users = $tablePreStr . "users"; $dbo = new dbex(); //读写分离定义函数 dbtarget('w', $dbServs); $sql = "update {$t_users} set inputmess_limit={$input_mess_para} where user_id={$user_id}"; $dbo->exeUpdate($sql); action_return(1, $pr_langpackage->pr_save_sec, "modules.php?app=pr_inputmess");
//引入语言包 $pu_langpackage = new publiclp(); //变量取得 $private_id = get_argg("private_id"); $user_id = get_sess_userid(); if (empty($user_id)) { header("location:error.php"); exit; } $dbo = new dbex(); //数据表定义区 $t_comments = $tablePreStr . "comments"; $t_papers = $tablePreStr . "papers"; dbplugin('r'); $paperIdSql = "select paper_id from {$t_comments} where comment_id = {$private_id}"; $res = $dbo->getRow($paperIdSql); $paper_id = $res['paper_id']; //读写分离定义函数 dbtarget('w', $dbServs); $refuseAllPrivateSql = "update {$t_comments} set comment_status = 2 where paper_id = {$paper_id} and comment_type = 1"; $paperStatusUpdate = "update {$t_papers} set paper_status = 2 where paper_id = {$paper_id}"; $dbo->exeUpdate($refuseAllPrivateSql); $dbo->exeUpdate($paperStatusUpdate); /* update isns_papers set isns_papers.comment_count = 3 where isns_papers.paper_id=111114; */ $update_comment_sql = "update {$t_comments} set comment_status = 1 where comment_id = {$private_id} and comment_type = 1"; if ($dbo->exeUpdate($update_comment_sql)) { action_return(1, '', 'modules.php?app=user_settings&main_key=show_user_unread'); } else { action_return(0, 'error', '-2'); }
require "session_check.php"; require "../api/Check_MC.php"; $is_check = check_rights("c07"); if (!$is_check) { echo $m_langpackage->m_no_pri; exit; } //语言包引入 $m_langpackage = new modulelp(); //数据表定义区 $t_recommend = $tablePreStr . "recommend"; $t_users = $tablePreStr . "users"; //变量区 $user_name = short_check(get_argp('uname')); $user_ico = short_check(get_argg('uico')); $is_pass = short_check(get_argg('upass')); $user_id = intval(get_argg('uid')); $guest_num = intval(get_argg('gnum')); $user_sex = intval(get_argg('usex')); $dbo = new dbex(); dbtarget('w', $dbServs); $sql = "insert into {$t_recommend} (user_id,user_name,user_ico,is_pass,guest_num,user_sex,show_ico) " . "values ('{$user_id}','{$user_name}','{$user_ico}','{$is_pass}','{$guest_num}','{$user_sex}','{$user_ico}')"; $sql1 = "update {$t_users} set is_recommend=1 where user_id={$user_id}"; if ($dbo->exeUpdate($sql) && $dbo->exeUpdate($sql1)) { $key_mt = 'recommend/list/rec_order/all/0_mt'; updateCache($key_mt); echo $m_langpackage->m_recomed; } else { echo $m_langpackage->m_recomed_lose; }
} //得到群组数据 $group_name = $group_row['group_name']; $creat_id = $group_row['add_userid']; $manager_id = $group_row['group_manager_id']; if ($group_row['group_join_type'] == 2) { echo $g_langpackage->g_refuse_join; exit; } if ($group_row['group_join_type'] == 0) { $user_join_group = empty($user_join_group) ? "," . $group_id . "," : $user_join_group . $group_id . ","; //写定义 dbtarget('w', $dbServs); //更新用户表 $sql = "update {$t_users} set join_group='{$user_join_group}' where user_id={$user_id}"; $dbo->exeUpdate($sql); //插入群组关系表 $sql = "insert into {$t_group_members} (group_id,user_id,user_name,user_sex,state,role,add_time,user_ico) values ({$group_id},{$user_id},'{$user_name}','{$user_sex}',1,2,NOW(),'{$userico}')"; if ($dbo->exeUpdate($sql)) { //增加群组人数 $sql = "update {$t_groups} set member_count=member_count+1 where group_id={$group_id}"; $dbo->exeUpdate($sql) or die('false'); } //纪录新鲜事 $title = $g_langpackage->g_joined_group . '<a href="home.php?h=' . $user_id . '&app=group_space&group_id=' . $group_id . '" target="_blank">' . $group_name . '</a>'; $content = '<a href="home.php?h=' . $user_id . '&app=group_space&group_id=' . $group_id . '" target="_blank">' . $group_name . '</a>'; $is_suc = api_proxy("message_set", 0, $title, $content, 0, 1); //更新session set_sess_jgroup($user_join_group); echo $g_langpackage->g_join_suc; exit;
function message_del_affair($rid) { global $tablePreStr; $t_recent_affair = $tablePreStr . "recent_affair"; $dbo = new dbex(); dbplugin('w'); $uid = get_sess_userid(); $sql = "delete from {$t_recent_affair} where id={$rid} and user_id={$uid}"; return $dbo->exeUpdate($sql); }
<?php //引入语言包 $pu_langpackage = new publiclp(); $user_id = get_sess_userid(); $user_school = get_argp("user_school"); $user_nickname = get_argp('user_nickname'); if (empty($user_id)) { echo '1'; } else { //数据表定义区 $t_users = $tablePreStr . "users"; $dbo = new dbex(); //增加评论数 dbtarget('w', $dbServs); $updateSql = "update {$t_users} set user_nickname='{$user_nickname}',user_school='{$user_school}' where user_id={$user_id}"; if ($dbo->exeUpdate($updateSql)) { set_session('user_school', $user_school); echo '0'; } else { echo '1'; } }
$users_row = api_proxy("user_self_by_uid", "user_id,user_name,user_ico", $msg_touser); if ($users_row) { $touser_id = $users_row[0]; $touser = $users_row[1]; $touser_ico = $users_row[2]; if ($touser_id == $user_id) { action_return(0, $m_langpackage->m_no_mys, "modules.php?app=msg_creator" . $toidUrlStr); } } else { action_return(0, $m_langpackage->m_one_err, "modules.php?app=msg_creator" . $toidUrlStr); } $dbo = new dbex(); //读写分离定义函数 dbtarget('w', $dbServs); $sql = "insert into {$t_msg_outbox} (mess_title,mess_content,to_user_id,to_user,to_user_ico,user_id,add_time,state)" . "value('{$msg_title}','{$msg_txt}',{$touser_id},'{$touser}','{$touser_ico}',{$user_id},NOW(),'1')"; if (!$dbo->exeUpdate($sql)) { action_return(0, $m_langpackage->m_data_err, "-1"); exit; } $sql = "insert into {$t_msg_inbox} (mess_title,mess_content,from_user_id,from_user,from_user_ico,user_id,add_time,mesinit_id)" . "value('{$msg_title}','{$msg_txt}',{$user_id},'{$user_name}','{$user_ico}',{$touser_id},NOW(),LAST_INSERT_ID())"; if ($dbo->exeUpdate($sql)) { api_proxy("message_set", $touser_id, $m_langpackage->m_remind, "modules.php?app=msg_minbox", 0, 5, "remind"); if (get_argp('nw') == "2") { action_return(1, '', "modules.php?app=hstart&user_id=" . $touser_id); } else { action_return(1, '', "modules.php?app=msg_moutbox" . $toidUrlStr); } } else { $sql = "update {$t_msg_outbox} set state='0' where mess_id=LAST_INSERT_ID()"; $dbo->exeUpdate($sql); action_return(0, $m_langpackage->m_send_err, "-1");
//语言包引入 $m_langpackage = new modulelp(); //读写分离 $dbo = new dbex(); dbtarget('w', $dbServs); //判断是否批量删除 if (get_argp('checkany')) { //批量 //数据表定义区 $t_mood = $tablePreStr . "mood"; $t_mood_com = $tablePreStr . "mood_comment"; $mood_ids = get_argp('checkany'); foreach ($mood_ids as $rs) { //删除心情 $sql = "delete from {$t_mood} where mood_id={$rs}"; $dbo->exeUpdate($sql); $sql = "delete from {$t_mood_com} where mood_id={$rs}"; $dbo->exeUpdate($sql); } } else { //单条 //变量取得 $mood_id = short_check(get_argg('mood')); $uid = intval(get_argg('uid')); //数据表定义区 $t_mood = $tablePreStr . "mood"; $t_mood_com = $tablePreStr . "mood_comment"; //删除心情 $sql = "delete from {$t_mood} where mood_id={$mood_id}"; if ($dbo->exeUpdate($sql)) { $sql = "delete from {$t_mood_com} where mood_id = {$mood_id}";
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title></title> </head> <body style="text-align:center"> <div style="width:100%" > <?php if (!is_null($path)) { //检测是不是有数据库文件 $create_tables = "{$plugin_base}/{$path}/plugin_create_tables.php"; $dbo = new dbex(); dbtarget('w', $dbServs); if (file_exists($create_tables)) { $tables = explode(';', file_get_contents($create_tables)); foreach ($tables as $table) { $sql = "drop table " . $table; if ($dbo->exeUpdate($sql)) { echo "<div style='color:green'>" . $pl_langpackage->pl_table . ":" . $table . $pl_langpackage->pl_delete_successful . "<br /></div>"; } } unlink($create_tables); } if (rename("{$plugin_base}/{$path}/_plugin.xml", "{$plugin_base}/{$path}/plugin.xml")) { $dom = new DOMDocument(); $dom->load("{$plugin_base}/{$path}/plugin.xml"); $plugin = $dom->getElementsByTagName("plugin")->item(0); $plugin_id = $plugin->getElementsByTagName("plugin_id")->item(0); $autoorder = $plugin->getElementsByTagName('autoorder')->item(0); $valid = $plugin->getElementsByTagName('valid')->item(0); if ($plugin_id) { $plugin->removeChild($plugin_id); }
$sendor_id = intval(get_argg('uedid')); require 'poll_del.action.php'; break; case "8": $share_id = intval(get_argg('redid')); $u_id = intval(get_argg('uedid')); require 'share_del.action.php'; break; case "9": $subject_id = intval(get_argg('redid')); $sendor_id = intval(get_argg('uedid')); require 'subject_del.action.php'; break; case "10": $user_id = intval(get_argg('redid')); $type_value = 0; require 'member_lock.action.php'; break; default: $is_check = check_rights("c36"); if (!$is_check) { echo $m_langpackage->m_no_pri; exit; } break; } $sql = "delete from {$t_report} where report_id ={$report_id}"; $is_success = $dbo->exeUpdate($sql); if ($type == '') { echo $m_langpackage->m_del_suc; }
<?php //引入语言包 $u_langpackage = new userslp(); //变量获得 $user_id = get_sess_userid(); $ol_is_latent = intval(get_argg('is_hidden')); echo $ol_is_latent; //表声明区 $t_users = $tablePreStr . "users"; $t_online = $tablePreStr . "online"; $dbo = new dbex(); //读写分离定义函数 dbtarget('w', $dbServs); //更新online表 $sql = "update {$t_online} set `hidden`={$ol_is_latent} where user_id={$user_id};"; if ($dbo->exeUpdate($sql)) { set_sess_online($ol_is_latent); echo $u_langpackage->u_set_suc; } else { echo $u_langpackage->u_set_los; }
$sql_str = $xmldom->getElementsByTagName('update_sql'); //取得sql列表 $is_success = 1; //状态 //升级sql if ($sql_str->length) { $queries = explode(";\n", $sql_str->item(0)->nodeValue); $dbo = new dbex(); dbtarget('w', $dbServs); foreach ($queries as $query) { $query = str_replace("isns_", $tablePreStr, $query); if (substr($query, -1) != ";") { $query .= ";"; } $result = $so_softwarelp->so_success; if (!$dbo->exeUpdate($query)) { $result = $so_softwarelp->so_false; $is_success = 0; } echo str_replace("{result}", $result, $so_softwarelp->so_sql_result); } } //升级目录 foreach ($dir_array as $dir) { if (!file_exists("../" . $dir->nodeValue)) { $result = $so_softwarelp->so_success; if (!mkdir("../" . $dir->nodeValue)) { $result = $so_softwarelp->so_false; $is_success = 0; } echo str_replace(array("{result}", "{dir}"), array($result, $dir->nodeValue), $so_softwarelp->so_dir_result);
function paper_related_update_paper_unread($user_id, $paper_id, $is_user_paper) { global $tablePreStr; global $dbServs; $dbo = new dbex(); $t_comments = $tablePreStr . "comments"; dbtarget('w', $dbServs); $updateSql = ""; if (1 === $is_user_paper) { $updateSql = "update {$t_comments} set {$t_comments}.comment_status=1 \n\t\t\t\twhere {$t_comments}.paper_id={$paper_id} and {$t_comments}.comment_type=1"; } else { $updateSql = "update {$t_comments} set {$t_comments}.comment_status=1 \n\t\t\t\twhere {$t_comments}.paper_id={$paper_id} and {$t_comments}.commenter_id = {$user_id} and {$t_comments}.comment_type=2"; } if ($dbo->exeUpdate($updateSql)) { return true; } return false; }
// 获取用户身份信息 $c = new SaeTClientV2(WB_AKEY, WB_SKEY, $token['access_token']); $sid_get = $c->get_uid(); if_weiboapi_fail($sid_get); $sid = $sid_get['uid']; // 判断是否首次授权,首次授权则登记sina uid $dbo = new dbex($dbServs); if (!$dbo->checkExist($sid, 'sina_uid', 'user_info_sina')) { // 首次授权 在绑定微博或用微博帐号注册 if (isset($_SESSION['uid'])) { //已注册微动力,在绑定微博,完善信息 $id = $_SESSION['uid']; $api_res = $c->show_user_by_id($sid); if_weiboapi_fail($api_res); $sql = "insert into user_info_sina (user_id, sina_uid, sina_token, token_update_at, token_expires_in, sina_screen_name, sina_location, sina_description, bind_time) values ('{$id}', '{$sid}', '{$token['access_token']}', now(), '{$token['expires_in']}', '{$api_res['screen_name']}', '{$api_res['location']}', '{$api_res['description']}', now())"; $num = $dbo->exeUpdate($sql); if (1 != $num) { $msg = "向数据库插入数据出错。file:" . __FILE__ . ";line:" . __LINE__ . "sql:" . $sql; debug($msg); } $sql = "update user set bind_status = bind_status + 1 where user_id = '{$id}' limit 1"; $num = $dbo->exeUpdate($sql); if (1 != $num) { $msg = "向数据库插入数据出错。file:" . __FILE__ . ";line:" . __LINE__ . "sql:" . $sql; debug($msg); } //写session,跳转 $_SESSION['sid'] = $sid; $_SESSION['stoken'] = $token['access_token']; header("Location:task.php"); // 后台获取用户的已关注用户id列表,写入SESSION
<body style="text-align:center"> <div style="width:100%;text-align:left" id="show" > <?php $dbo = new dbex(); if (!is_null(get_args('operator')) && get_args('operator') == 'update') { dbtarget('w', $dbServs); $valid = get_args('valid'); $autoorder = get_args('autoorder'); if (is_null($valid)) { $valid = 0; } if (is_null($autoorder)) { $autoorder = 0; } $sql = "update {$plugin_table} set autoorder={$autoorder},valid={$valid} where name='{$path}'"; if ($dbo->exeUpdate($sql) !== false) { comp_plugins_position(); echo "<script>parent.Dialog.alert('" . $pl_langpackage->pl_update_suc . "')</script>"; } else { echo "<script>parent.Dialog.alert('" . $pl_langpackage->pl_update_false . "')</script>"; } } if (!is_null($path)) { //检测是不是有数据库文件 dbtarget('r', $dbServs); $sql = "select * from {$plugin_table} where name='{$path}'"; $plugin = $dbo->getRs($sql); if (is_array($plugin)) { if (isset($plugin[0]['autoorder']) && $plugin[0]['autoorder'] == 1) { $autoorder = "checked"; } else {
$user_point = get_session('user_point'); //兑换红包消耗10点积分 $consume_point = 10; //使用积分兑换红包 $user_point -= $consume_point; global $tablePreStr; $t_users = $tablePreStr . "users"; $t_money = $tablePreStr . "money"; $result_rs = array(); //更新数据库记录 $dbo = new dbex(); //读写分离定义函数 dbtarget('w', $dbServs); //update isns_users set user_point=2000 where user_id=1; $update_user_point_sql = "update {$t_users} set user_point={$user_point} where user_id={$user_id}"; if ($dbo->exeUpdate($update_user_point_sql)) { //更新session值 set_session('user_point', $user_point); //用户兑换记录 $exchange_money = rand(5, 100); $exchange_datetime = date("Y-m-d H:i:s", time()); //insert into isns_money (user_id, consume_point, exchange_datetime, exchange_money) value (1, 10, '2015-08-11 15:55:23', 33); $sql = "insert into {$t_money} (user_id, consume_point, exchange_datetime, exchange_money) \n\t\t\t\tvalue ({$user_id}, {$consume_point}, '{$exchange_datetime}', {$exchange_money})"; if ($dbo->exeUpdate($sql)) { action_return(1, '', 'modules.php?app=user_settings&main_key=exchange_money&sub_key=exchange_result&exchange_money=' . $exchange_money); } else { action_return(0, 'error', '-1'); } } else { action_return(0, 'error', '-2'); }