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