function antiRePost($sendStr)
{
global $RefreshType;
global $anit_refresh;
if ($sendStr == get_session('PostSendStr')) {
if (isset($RefreshType) == 'ajax') {
action_return(2, 'error:' . $anit_refresh, "-1");
} else {
action_return(1, $anit_refresh, "-1");
}
}
set_session('PostSendStr', $sendStr);
}
}
$sql = "select id from {$t_invite_code} where code_txt='{$invite_code}'";
$is_check = $dbo->getRow($sql);
if (empty($is_check)) {
action_return(0, '邀请码不正确或已经失效', "-1");
exit;
}
$sql = "delete from {$t_invite_code} where code_txt='{$invite_code}'";
$dbo->exeUpdate($sql);
}
//写入数据
$user_ico = $user_sex == 0 ? "skin/{$skinUrl}/images/d_ico_0_small.gif" : "skin/{$skinUrl}/images/d_ico_1_small.gif";
dbtarget('w', $dbServs);
$sql = "insert into {$t_users} (user_name,user_pws,user_sex,user_email,user_add_time,user_ico,invite_from_uid,is_pass,lastlogin_datetime,birth_year , birth_month , birth_day ,login_ip )" . " values('{$user_name}','{$user_pws}',{$user_sex},'{$user_email}',NOW(),'{$user_ico}',{$invite_fromuid},{$is_pass},NOW(),'','','','{$_SERVER['REMOTE_ADDR']}')";
if (!$dbo->exeUpdate($sql)) {
action_return(0, $re_langpackage->re_reg_false, "-1");
}
$user_id = mysql_insert_id();
set_sess_userid($user_id);
set_sess_usersex($user_sex);
set_sess_username($user_name);
set_sess_userico($user_ico);
set_sess_online('0');
$now_time = time();
$sql = "insert into {$t_online} (user_id,user_name,user_sex,user_ico,active_time,hidden) values ({$user_id},'{$user_name}',{$user_sex},'{$user_ico}','{$now_time}',0)";
$dbo->exeUpdate($sql);
foreach ($sort_rs as $rs) {
$sort_id = $rs['id'];
$sort_name = $rs['name'];
$sql = "insert into {$t_pals_sort} ( name , user_id ) values ( '{$sort_name}' , {$user_id} )";
$dbo->exeUpdate($sql);
$dbo = new dbex();
//读写分离定义函数
dbtarget('w', $dbServs);
if ($del_array == NULL) {
$del_array[] = $msg_id;
}
foreach ($del_array as $rs) {
$rs = short_check($rs);
if (get_argg("t") == "0") {
$sql = "delete from {$t_msg_inbox} where mess_id={$rs} and user_id={$user_uid}";
$reTurnUrl = "modules.php?app=msg_minbox";
} else {
if (get_argg("t") == "1") {
$sql = "delete from {$t_msg_outbox} where mess_id={$rs} and user_id={$user_uid}";
$reTurnUrl = "modules.php?app=msg_moutbox";
} else {
if (get_argg("t") == "2") {
$sql = "delete from {$t_msg_inbox} where mess_id={$rs} and user_id={$user_uid}";
$reTurnUrl = "modules.php?app=msg_notice";
}
}
}
$dbo->exeUpdate($sql);
}
if (get_argg("h") == NULL) {
//刷新提醒页面
echo "<script type='text/javascript'>\r\n\t\t parent.frames['remind'].location.reload();\r\n\t\t </script>";
}
//回应信息
action_return(1, "", $reTurnUrl);
$fileSrcStr = str_replace(dirname(__FILE__), "", $realtxt['dir']) . $realtxt['name'];
$thumb_src = str_replace(dirname(__FILE__), "", $realtxt['dir']) . $realtxt['thumb'];
$sql = "insert into {$t_photo}(`user_id`,`add_time`,`photo_src`,`photo_thumb_src`,`album_id`,`user_name`,`privacy`)\r\n\t\t\t\t\t values({$user_id},now(),'{$fileSrcStr}','{$thumb_src}',{$album_id},'{$user_name}','');";
if ($dbo->exeUpdate($sql)) {
$photo_id = mysql_insert_id();
$fs[$index]['photo_id'] = $photo_id;
$sql = "update {$t_album} set photo_num=photo_num+1,update_time=NOW() where album_id={$album_id}";
if ($dbo->exeUpdate($sql)) {
increase_integral($dbo, $int_photo, $user_id);
}
$photos_array[$i]['id'] = $photo_id;
$photos_array[$i]['file'] = $thumb_src;
}
$i++;
} else {
if ($realtxt['flag'] == -1) {
action_return(0, $a_langpackage->a_no_jpg, "-1");
} else {
if ($realtxt['flag'] == -2) {
action_return(0, $a_langpackage->a_big, "-1");
}
}
}
}
set_session('S_fs', $fs);
//回应信息
if ($i > 0) {
action_return(1, "", "modules.php?app=photo_update&album_id={$album_id}");
} else {
action_return(0, $a_langpackage->a_upd_false, "-1");
}
$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 {
action_return(0, 'error', '-2');
}
$join_group = get_sess_jgroup();
$creat_group = get_sess_cgroup();
$group_id = intval(get_argg('group_id'));
$ulog_title = short_check(get_argp("LOG_TITLE"));
$ulog_txt = big_check(get_argp("CONTENT"));
$u_id = intval(get_argg('user_id'));
$tag = short_check(get_argp('tag'));
//防止重复提交
antiRePost($ulog_title);
//数据表定义
$t_group_subject = $tablePreStr . "group_subject";
$t_group = $tablePreStr . "groups";
//权限判定
dbtarget('r', $dbServs);
$dbo = new dbex();
//写入方式
dbtarget('w', $dbServs);
$sql = "insert into {$t_group_subject} (user_id,title,content,add_time,group_id,user_name,hits,user_ico,`tag`) values({$user_id},'{$ulog_title}','{$ulog_txt}',NOW(),{$group_id},'{$user_name}',0,'{$user_ico}','{$tag}')";
$dbo->exeUpdate($sql);
$last_id = mysql_insert_id();
$sql = "update {$t_group} set subjects_num=subjects_num+1 where group_id={$group_id}";
$dbo->exeUpdate($sql);
//标签功能
$tag_id = tag_add($tag);
$tag_state = tag_relation(4, $tag_id, $last_id);
increase_integral($dbo, $int_subject, $user_id);
$jump = "modules.php?app=group_space&group_id={$group_id}&user_id=" . $u_id;
action_return(1, "", $jump);
?>
<?php
//引入语言包
$a_langpackage = new albumlp();
//变量取得
$album_id = intval(get_argg('album_id'));
$album_name = short_check(get_argp('album_name'));
$album_information = long_check(get_argp('album_information'));
$tag = short_check(get_argp('tag'));
$privacy = short_check(get_argp('privacy'));
$user_id = get_sess_userid();
//数据表定义区
$t_album = $tablePreStr . "album";
$dbo = new dbex();
//读写分离定义函数
dbtarget('w', $dbServs);
$sql = "update {$t_album} set `album_name`='{$album_name}',`user_id`={$user_id},`album_info`='{$album_information}',`tag`='{$tag}',`update_time`=NOW(),`privacy`='{$privacy}' where album_id={$album_id}";
$dbo->exeUpdate($sql);
//回应信息
action_return(1, "", "");
<?php
//引入语言包
$mp_langpackage = new mypalslp();
$user_id = get_sess_userid();
$user_name = get_sess_username();
$req_id = intval(get_argg("req_id"));
$req_uid = intval(get_argg("req_uid"));
//数据表定义区
$t_pals_request = $tablePreStr . "pals_request";
$t_mypals = $tablePreStr . "pals_mine";
//定义写操作
dbtarget('w', $dbServs);
$dbo = new dbex();
$sql = "delete from {$t_pals_request} where id={$req_id} and user_id={$user_id}";
if ($dbo->exeUpdate($sql)) {
$sql = "delete from {$t_mypals} where pals_id = {$user_id} and user_id = {$req_uid} and accepted = 0";
$dbo->exeUpdate($sql);
}
//刷新提醒页面
echo "<script type='text/javascript'>\r\n parent.frames['remind'].location.reload();\r\n </script>";
action_return(0, '', "");
?>
$my_pals = get_sess_mypals();
$req_id = intval(get_argg('req_id'));
$req_user_id = intval(get_argg('req_user_id'));
//数据表定义区
$t_users = $tablePreStr . "users";
$t_mypals = $tablePreStr . "pals_mine";
$t_pals_request = $tablePreStr . "pals_request";
$dbo = new dbex();
//定义写操作
dbtarget('w', $dbServs);
//判断好友列表里是否已有该人
if (api_proxy("pals_self_isset", $user_id, $req_user_id)) {
$accepted = 2;
$sql = "update {$t_mypals} set accepted=2 where user_id={$user_id} and pals_id={$req_user_id}";
$dbo->exeUpdate($sql);
} else {
$accepted = 1;
}
$sql = "update {$t_mypals} set accepted={$accepted} where pals_id={$user_id} and user_id={$req_user_id}";
$dbo->exeUpdate($sql);
$sql = "delete from {$t_pals_request} where user_id={$user_id} and id={$req_id}";
$dbo->exeUpdate($sql);
$title = $user_name . $m_langpackage->m_agr_app;
$scrip_content = $user_name . $m_langpackage->m_agree_app;
$is_success = api_proxy('scrip_send', $mp_langpackage->mp_system_sends, $title, $scrip_content, $req_user_id, 0);
if ($is_success) {
api_proxy("message_set", $req_user_id, "{num}" . $mp_langpackage->mp_a_notice, "modules.php?app=msg_notice", 0, 1, "remind");
action_return(2, $mp_langpackage->mp_treatment_success, -1);
} else {
action_return(2, $mp_langpackage->mp_treatment_failure, -1);
}
//读写分离定义函数
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);
}
<?php
//引入语言包
$pr_langpackage = new privacylp();
//变量获得
$user_id = get_sess_userid();
$h_access_para = short_check(get_argp('home_acess'));
$access_q_1 = short_check(get_argp('question_1'));
$access_q_2 = short_check(get_argp('question_2'));
$access_q_3 = short_check(get_argp('question_3'));
$access_a_1 = short_check(get_argp('answer_1'));
$access_a_2 = short_check(get_argp('answer_2'));
$access_a_3 = short_check(get_argp('answer_3'));
//数据表定义区
$t_users = $tablePreStr . "users";
$dbo = new dbex();
//读写分离定义函数
dbtarget('w', $dbServs);
$sql_part = '';
if ($h_access_para == '3') {
$sql_part = ",access_questions='{$access_q_1},{$access_q_2},{$access_q_3}'";
$sql_part = $sql_part . ",access_answers='{$access_a_1},{$access_a_2},{$access_a_3}'";
}
$sql = "update {$t_users} set access_limit={$h_access_para} {$sql_part} where user_id={$user_id}";
$dbo->exeUpdate($sql);
action_return(1, $pr_langpackage->pr_save_sec, "modules.php?app=privacy");
}
dbtarget('w', $dbServs);
$dbo = new dbex();
$up = new upload();
$up->set_dir($webRoot . 'uploadfiles/photo_store/', '{y}/{m}/{d}');
$fs = $up->execute();
$user_id = get_sess_userid();
//用户ID
//定义文件表
$t_uploadfile = $tablePreStr . "uploadfile";
$realtxt = $fs[0];
if ($realtxt['flag'] == 1) {
$fileSrcStr = str_replace($webRoot, "", $realtxt['dir']) . $realtxt['name'];
$fileName = $realtxt['initname'];
$sql = "insert into {$t_uploadfile} (file_name,file_src,user_id,add_time) values ('{$fileName}','{$fileSrcStr}','{$user_id}',NOW())";
$dbo->exeUpdate($sql);
$last_id = mysql_insert_id();
echo "<script type='text/javascript'>parent.AddContentImg('{$fileSrcStr}','{$last_id}');</script>";
action_return(1, "", 'modules.php?app=upload_form');
} else {
if ($realtxt[flag] == -1) {
action_return(0, $pu_langpackage->pu_type_err, '-1');
} else {
if ($realtxt[flag] == -2) {
action_return(0, $pu_langpackage->pu_capacity_err, '-1');
}
}
}
?>
$user_id = get_sess_userid();
$formerly_pw = short_check(get_argp('formerly_pw'));
$new_pw = short_check(get_argp('new_pw'));
$new_pw_repeat = short_check(get_argp('new_pw_repeat'));
if ($new_pw == '' || $new_pw_repeat == '') {
action_return(0, $u_langpackage->u_password_not_empty, -1);
exit;
}
if ($new_pw != $new_pw_repeat) {
action_return(0, $u_langpackage->u_pw2_err, "modules.php?app=user_pw_change");
exit;
}
if (!$user_id) {
action_return(0, $u_langpackage->u_after_operation_log, $indexFile);
exit;
}
//读写分离定义函数
$sql = "select user_pws from {$t_users} where user_id={$user_id}";
$user_row = $dbo->getRow($sql);
$formerly_pw = md5($formerly_pw);
if ($user_row['user_pws'] == $formerly_pw) {
$new_pw = md5($new_pw);
//读写分离定义函数
dbtarget('w', $dbServs);
$sql = "update {$t_users} set user_pws ='{$new_pw}' where user_id = {$user_id}";
$dbo->exeUpdate($sql);
action_return(1, $u_langpackage->u_pw_chg_suc, "modules.php?app=user_pw_change");
} else {
action_return(0, $u_langpackage->u_pw_err, "modules.php?app=user_pw_change");
}
}
<?php
//变量取得
$sort_id = intval(get_argg('id'));
$user_id = get_sess_userid();
//数据表定义区
$t_pals_sort = $tablePreStr . "pals_sort";
$t_mypals = $tablePreStr . "pals_mine";
$dbo = new dbex();
//读写分离定义函数
dbtarget('w', $dbServs);
$sql = "delete from {$t_pals_sort} where id={$sort_id} and user_id={$user_id}";
$dbo->exeUpdate($sql);
$sql = "update {$t_mypals} set pals_sort_name=NULL , pals_sort_id=0 where pals_sort_id={$sort_id} and user_id={$user_id}";
$dbo->exeUpdate($sql);
action_return(0, "", "");
<?php
//引入语言包
$pr_langpackage = new privacylp();
//变量获得
$user_id = get_sess_userid();
$palsreq_para = short_check(get_argp('palsreq_check'));
//数据表定义区
$t_users = $tablePreStr . "users";
$dbo = new dbex();
//读写分离定义函数
dbtarget('w', $dbServs);
$sql = "update {$t_users} set palsreq_limit={$palsreq_para} where user_id={$user_id}";
$dbo->exeUpdate($sql);
action_return(1, $pr_langpackage->pr_save_sec, "modules.php?app=pr_reqcheck");
<?php
//语言包引入
$pr_langpackage = new privacylp();
//变量获得
$user_id = get_sess_userid();
$holder_id = intval(get_argg('holder_id'));
$answer_key = short_check(get_argp('questions'));
$input_answer = short_check(get_argp('answer'));
$ha_arr = get_session($holder_id . 'homeAccessAnswers');
if ($ha_arr[$answer_key] == $input_answer) {
set_session($holder_id . 'homeAccessAnswers', '');
set_session($holder_id . 'homeAccessPass', '1');
action_return(1, '', "home.php?h={$holder_id}");
} else {
set_session($holder_id . 'homeAccessPass', '0');
action_return(0, $pr_langpackage->pr_qanswer_err, -1);
}
<?php
//会员退出
$dbo = new dbex();
dbtarget('r', $dbServs);
$t_online = $tablePreStr . "online";
$user_id = get_sess_userid();
$sql = "delete from {$t_online} where user_id={$user_id}";
$dbo->exeUpdate($sql);
setcookie("IsReged", '');
session_destroy();
action_return(1, '', '');
}
$s_ico = str_replace('.' . $img_ext, '_small.' . $img_ext, $ico_url);
$small_ico = imagecreatetruecolor(70, 70);
imagecopyresampled($small_ico, $temp_img, 0, 0, 0, 0, 70, 70, 200, 200);
imagejpeg($small_ico, $s_ico);
} else {
$s_ico = $ico_url;
}
if (update_user_ico($dbo, $t_users, $user_ico, $u_field_id, $user_id, $s_ico)) {
if (get_sess_userico() == "skin/{$skinUrl}/images/d_ico_0_small.gif" or get_sess_userico() == "skin/{$skinUrl}/images/d_ico_1_small.gif") {
increase_integral($dbo, $int_one_ico, get_sess_userid());
}
//更新数据
update_user_ico($dbo, $t_mypals, $pals_ico, $p_field_id, $user_id, $s_ico);
update_user_ico($dbo, $t_pals_req, $req_ico, $q_field_id, $user_id, $s_ico);
set_sess_userico($s_ico);
if (preg_match("/uploadfiles\\/photo_store/", $photo_url)) {
unlink($photo_url);
//删除临时图片文件
}
//记录新鲜事
$title = $u_langpackage->u_picture_update;
$content = '<img class="photo_frame" onerror=parent.pic_error(this) src="' . $ico_url . '" align="top">';
api_proxy("message_set", 0, $title, $content, 1, 7);
action_return(1, "", 'modules.php?app=user_ico');
} else {
action_return(0, $u_langpackage->u_save_false, '-1');
}
?>
<?php
//引入语言包
$mo_langpackage = new moodlp();
require "foundation/module_affair.php";
//变量取得
$mood_id = intval(get_argg('mood_id'));
$user_id = get_sess_userid();
//数据表定义区
$t_mood = $tablePreStr . "mood";
$t_mood_com = $tablePreStr . "mood_comment";
$dbo = new dbex();
//读写分离定义函数
dbtarget('w', $dbServs);
//删除心情
$sql = "delete from {$t_mood} where mood_id={$mood_id} and user_id={$user_id}";
$dbo->exeUpdate($sql);
$sql = "delete from {$t_mood_com} where mood_id={$mood_id}";
$dbo->exeUpdate($sql);
del_affair($dbo, 6, $mood_id);
//回应信息
action_return(1, "", "-1");
//引入语言包
$u_langpackage = new userslp();
//变量获得
$user_id = get_sess_userid();
$model = short_check(get_argg('model'));
$marry = short_check(get_argp('marry'));
$birth_year = short_check(get_argp('birth_year'));
$birth_month = short_check(get_argp('birth_month'));
$birth_day = short_check(get_argp('birth_day'));
$blood = short_check(get_argp('blood'));
$reside_city = short_check(get_argp('reside_city'));
$reside_province = short_check(get_argp('reside_province'));
$birth_city = short_check(get_argp('birth_city'));
$birth_province = short_check(get_argp('birth_province'));
$qq = short_check(get_argp('qq'));
$is_finish = intval(get_argg('is_finish'));
//表声明区
$t_users = $tablePreStr . "users";
$t_online = $tablePreStr . "online";
$dbo = new dbex();
//读写分离定义函数
dbtarget('w', $dbServs);
//更新users表
$sql = "update {$t_users} set birth_province='{$birth_province}',birth_city='{$birth_city}',reside_province='{$reside_province}',reside_city='{$reside_city}',user_marry='{$marry}',birth_year='{$birth_year}',birth_month='{$birth_month}',birth_day='{$birth_day}',user_blood='{$blood}',user_qq='{$qq}'\r\n\t\t\twhere user_id = {$user_id};";
$dbo->exeUpdate($sql);
//更新online表
$sql = "update {$t_online} set birth_province='{$birth_province}',birth_city='{$birth_city}',reside_province='{$reside_province}',reside_city='{$reside_city}',birth_year='{$birth_year}' where user_id = {$user_id};";
$dbo->exeUpdate($sql);
//回应信息
action_return(1, "", "modules.php?app=user_info&single={$is_finish}&user_id={$user_id}");
<?php
$ua_langpackage = new userapplp();
require "api/base_support.php";
$id = intval(get_argg('id'));
$is_affair = intval(get_argp('is_affair'));
$app_rs = api_proxy("plugins_get_pid", $id);
$def_small_image = "skin/" . $skinUrl . "/images/plu_def_small.gif";
$small_url = $app_rs['image'] ? preg_replace("/([^\\.]+)(\\.\\w+)/", "\$1_small\$2", "plugins/" . $app_rs['name'] . "/" . $app_rs['image']) : $def_small_image;
if ($id) {
api_proxy("plugins_set_mine", $id);
if ($is_affair == 1) {
$title = $ua_langpackage->ua_add_new_app;
$content = '<a href="main.php?app=add_app&id=' . $app_rs['id'] . '" target="_blank">' . $app_rs['title'] . '</a>';
api_proxy("message_set", 0, $title, $content, 0, 8);
}
}
action_return(1, '', -1);
$album_id = intval(get_argg('album_id'));
$photo_id = array();
$photo_information = array();
$album_skin = short_check(get_argp('album_skin'));
$photo_id = get_argp('photo_id');
$photo_information = get_argp('photo_information');
$photo_name = get_argp('photo_name');
$user_id = get_sess_userid();
//变量定义区
$t_album = $tablePreStr . "album";
$t_photo = $tablePreStr . "photo";
$dbo = new dbex();
//读写分离定义函数
dbtarget('w', $dbServs);
//添加图片信息
foreach ($photo_id as $id) {
$information = each($photo_information);
$name = each($photo_name);
$id = intval($id);
$information = long_check($information['value']);
$name = short_check($name['value']);
$sql = "update {$t_photo} set photo_information = '{$information}',photo_name='{$name}' where photo_id={$id}";
$dbo->exeUpdate($sql);
}
if (!empty($album_skin)) {
$sql = "update {$t_album} set album_skin = '{$album_skin}' where album_id={$album_id}";
$dbo->exeUpdate($sql);
}
//回应信息
action_return(1, "", "modules.php?app=album");
require "api/base_support.php";
require "foundation/aintegral.php";
//变量取得
$photo_id = intval(get_argg('photo_id'));
$album_id = intval(get_argg('album_id'));
$user_id = get_sess_userid();
//数据表定义区
$t_album = $tablePreStr . "album";
$t_photo = $tablePreStr . "photo";
$album_row = api_proxy("album_self_by_aid", "album_skin", $album_id);
$photo_row = api_proxy("album_photo_by_photoid", "photo_thumb_src,photo_src", $photo_id);
$dbo = new dbex();
//读写分离定义函数
dbtarget('w', $dbServs);
//删除照片
if ($album_row['album_skin'] == $photo_row['photo_thumb_src']) {
$album_skin = 'uploadfiles/album/logo.jpg';
$sql = "update {$t_album} set album_skin = '{$album_skin}' where album_id={$album_id}";
$dbo->exeUpdate($sql);
}
@unlink($photo_row['photo_src']);
@unlink($photo_row['photo_thumb_src']);
$sql = "delete from {$t_photo} where photo_id={$photo_id} and user_id={$user_id}";
if ($dbo->exeUpdate($sql)) {
increase_integral($dbo, $int_del_photo, $user_id);
}
$sql = "update {$t_album} set photo_num=photo_num-1,update_time=NOW() where album_id={$album_id}";
$dbo->exeUpdate($sql);
//回应信息
action_return(1, "", "modules.php?app=photo_list&album_id={$album_id}");
<?php
//变量取得
$user_id = get_sess_userid();
$hi_id = short_check(get_argg('hi_id'));
$del_array = get_argp("attach");
//数据表定义区
$t_hi = $tablePreStr . "hi";
$dbo = new dbex();
//读写分离定义函数
dbtarget('w', $dbServs);
if ($del_array == NULL) {
$del_array[] = $hi_id;
}
foreach ($del_array as $rs) {
$rs = short_check($rs);
$sql = "delete from {$t_hi} where hi_id={$rs}";
$dbo->exeUpdate($sql);
}
action_return(1, "", -1);
action_return(0, $g_langpackage->g_no_privilege, "-1");
}
//定义写操作
dbtarget('w', $dbServs);
$group_name = short_check(get_argp('group_name'));
$group_resume = short_check(get_argp('group_resume'));
$group_join_type = intval(get_argp('group_join_type'));
$group_type_id = intval(get_argp('group_type_id'));
$group_type_name = short_check(get_argp('group_type_name'));
$tag = short_check(get_argp('tag'));
$gonggao = short_check(get_argp('affiche'));
$is_pic = "";
if (isset($_FILES['attach']) && $_FILES['attach']['name'][0] != '') {
$up = new upload();
$up->set_dir('uploadfiles/group_logo/', '{y}/{m}/{d}');
//目录设置
$fs = $up->execute();
if ($fs[0]['flag'] == -1) {
action_return(0, $g_langpackage->g_logo_limit, "-1");
}
$fileSrcStr = str_replace(dirname(__FILE__), "", $fs[0]['dir']) . $fs[0]['name'];
@unlink(get_argp('old_group_logo'));
$is_pic = ",group_logo='{$fileSrcStr}'";
}
$sql = "update {$t_groups} set group_name='{$group_name}',affiche ='{$gonggao}',tag = '{$tag}',group_resume = '{$group_resume}',group_join_type = {$group_join_type},group_type = '{$group_type_name}',group_type_id={$group_type_id} {$is_pic} where group_id={$group_id}";
$dbo->exeUpdate($sql);
$jump = "modules.php?app=group_manager&group_id={$group_id}";
action_return(1, '', $jump);
?>
$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");
}
?>
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);
}
//纪录新鲜事
$title = $pol_langpackage->pol_participate_vote . '<a href="home.php?h=' . $user_id . '&app=poll&p_id=' . $pid . '" target="_blank">' . $p_subject . '</a>';
$content = '<a href="home.php?h=' . $user_id . '&app=poll&p_id=' . $pid . '" target="_blank">' . $p_subject . '</a>';
$is_suc = api_proxy("message_set", 0, $title, $content, 0, 4);
$sql = "update {$t_poll} set voternum=voternum+1,lastvote=NOW() where p_id={$pid}";
$dbo->exeUpdate($sql);
$sql = "insert into {$t_polluser} (`uid`,`username`,`pid`,`option`,`dateline`,`anony`) values ({$user_id},'{$user_name}',{$pid},'{$cho_str}',NOW(),{$anon})";
$dbo->exeUpdate($sql);
//回应信息
action_return(0, "", -1);
<?php
//引入语言包
$g_langpackage = new grouplp();
require "api/base_support.php";
//变量区
$user_id = get_sess_userid();
$group_id = short_check(get_argg('group_id'));
$dbo = new dbex();
//数据表定义
$t_groups = $tablePreStr . "groups";
$t_group_members = $tablePreStr . "group_members";
$t_users = $tablePreStr . "users";
//取得用户加入的群组
$join_group_array = api_proxy("user_self_by_uid", "join_group", $user_id);
$user_join_group = preg_replace("/,{$group_id},/", ",", $join_group_array['join_group']);
//写方式
dbtarget('w', $dbServs);
//更新用户表
$sql = "update {$t_users} set join_group='{$user_join_group}' where user_id={$user_id}";
$dbo->exeUpdate($sql);
//更新群组人数
$sql = "update {$t_groups} set member_count=member_count-1 where group_id={$group_id}";
$dbo->exeUpdate($sql);
//删除群组关系表
$sql = "delete from {$t_group_members} where group_id={$group_id} && user_id={$user_id}";
$dbo->exeUpdate($sql);
//更新session
set_sess_jgroup($user_join_group);
action_return(1, '', "");
<?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");
<?php
//引入模块公共方法文件
require "foundation/module_blog.php";
//变量取得
$pals_sort = short_check(get_argp("new_sort"));
$user_id = get_sess_userid();
$user_name = get_sess_username();
//数据表定义区
$t_pals_sort = $tablePreStr . "pals_sort";
$dbo = new dbex();
//读写分离定义函数
dbtarget('w', $dbServs);
$sql = "insert into {$t_pals_sort} (name,user_id) value('{$pals_sort}',{$user_id})";
if ($dbo->exeUpdate($sql)) {
action_return(0, "", "");
} else {
action_return(1, $b_langpackage->b_add_fal, -1);
}
