case "5": $t_table = $t_share; $t_table_com = $t_share_comment; $mod_col = "s_id"; break; case "6": $t_table = $t_mood; $t_table_com = $t_mood_comment; $mod_col = "mood_id"; break; default: echo 'error'; break; } //定义读操作 dbtarget('w', $dbServs); $is_true = 0; $sql = "delete from {$t_table_com} where comment_id={$com_id}"; if ($dbo->exeUpdate($sql)) { $sql = "update {$t_table} set comments=comments-1 where {$mod_col}={$parent_id}"; $is_true = $dbo->exeUpdate($sql); } if ($is_true) { increase_integral($dbo, $int_del_com_msg, $sendor_id); echo "success"; } else { echo $rp_langpackage->rp_del_los; } ?>
$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); ?>
set_sess_plugins($user_info['use_plugins']); set_sess_apps($user_info['use_apps']); set_sess_online($hidden); set_session($user_info['user_id'] . "_dressup", $user_info['dressup']); $sql = "select * from {$t_frontgroup} where gid='{$user_info['user_group']}'"; $rights = $dbo->getRow($sql); if ($rights) { set_sess_rights($rights['rights']); } else { set_sess_rights(""); } //定义写操作 dbtarget('w', $dbServs); $now_time = time(); $last_data = date("Y-m-d", strtotime($user_info['lastlogin_datetime'])); $now_data = date("Y-m-d", $now_time); if ($last_data != $now_data) { increase_integral($dbo, $int_login, $user_info['user_id']); } $sql = "delete from {$t_online} where user_id={$user_info['user_id']}"; $dbo->exeUpdate($sql); $sql = "insert into {$t_online} (user_id,user_name,user_sex,user_ico,birth_province,birth_city,reside_province,reside_city,active_time,hidden,birth_year) values " . "({$user_info['user_id']},'{$user_info['user_name']}',{$user_info['user_sex']},'{$user_info['user_ico']}','{$user_info['birth_province']}','{$user_info['birth_city']}','{$user_info['reside_province']}','{$user_info['reside_city']}',{$now_time},{$hidden},'{$user_info['birth_year']}')"; $dbo->exeUpdate($sql); $sql = "update {$t_users} set lastlogin_datetime=now(),login_ip='{$_SERVER['REMOTE_ADDR']}' where user_id={$user_info['user_id']}"; $dbo->exeUpdate($sql); if (get_sess_preloginurl()) { echo get_sess_preloginurl(); } else { echo $acttarget[1]; set_sess_preloginurl(''); }
<?php require "foundation/aintegral.php"; require "api/Check_MC.php"; //引入语言包 $mb_langpackage = new msgboardlp(); //变量取得 $to_user_id = intval(get_argg('user_id')); $mess_id = intval(get_argg('mess_id')); $from_user_id = get_sess_userid(); //数据表定义区 $t_message = $tablePreStr . "msgboard"; $dbo = new dbex(); //读写分离定义函数 dbtarget('w', $dbServs); //评论相册 $sql = "delete from {$t_message} where mess_id={$mess_id} "; if ($dbo->exeUpdate($sql)) { increase_integral($dbo, $int_del_com_msg, $to_user_id); } //回应信息 action_return(1, "", "-1");
if ($img_ext == 'gif') { $temp_img = imagecreatefromgif($ico_url); } if ($img_ext == 'png') { $temp_img = imagecreatefrompng($ico_url); } $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 {
//删除主题内部的图片 $subject_content = api_proxy("group_sub_by_sid", "content", $subject_id); $subject_content = $subject_content['content']; preg_match_all("/classId=\"\\d\"/", $subject_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_group_subject} where subject_id={$subject_id}"; $dbo->exeUpdate($sql); $sql = "update {$t_group} set subjects_num=subjects_num-1 where group_id={$group_id}"; $dbo->exeUpdate($sql); $sql = "delete from {$t_group_comment} where subject_id={$subject_id}"; $dbo->exeUpdate($sql); $jump = "modules.php?app=group_space&group_id={$group_id}&user_id=" . $u_id; increase_integral($dbo, $int_del_subject, $sendor_id); action_return(1, "", $jump); ?>
//删除评论 $sql = "delete from {$t_share} where s_id={$rs}"; if ($dbo->exeUpdate($sql)) { del_affair($dbo, 5, $rs); increase_integral($dbo, $int_del_share, $u_id); } } } else { //单条 //变量取得 if (empty($share_id)) { $share_id = intval(get_argg('sid')); $u_id = intval(get_argg('u_id')); } //数据表定义区 $t_share = $tablePreStr . "share"; $dbo = new dbex(); //读写分离定义函数 dbtarget('w', $dbServs); //删除评论 $sql = "delete from {$t_share} where s_id={$share_id}"; if ($dbo->exeUpdate($sql)) { del_affair($dbo, 5, $share_id); increase_integral($dbo, $int_del_share, $u_id); echo $m_langpackage->m_del_suc; } } ?> <script language="javascript" type="text/javascript"> window.location.href='share_list.php?order_by=s_id&order_sc=desc'; </script>
$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']); } } if (!empty($match)) { $sql = "delete from {$t_uploadfile} where id in ({$match})"; $dbo->exeUpdate($sql); } $sql = "delete from {$t_blog} where log_id={$blog_id}"; if ($dbo->exeUpdate($sql)) { $sql = "delete from {$t_blog_comments} where log_id={$blog_id}"; $dbo->exeUpdate($sql); increase_integral($dbo, $int_del_blog, $sendor_id); del_affair($dbo, 0, $blog_id); //回应信息 echo $m_langpackage->m_del_suc; } else { echo $m_langpackage->m_del_lose; } } ?> <script language="javascript" type="text/javascript"> window.location.href='blog_list.php?order_by=log_id&order_sc=desc'; </script>
$dbo->exeUpdate($sql); increase_integral($dbo, $int_del_poll, $sendor_id); } } else { //变量区 if (empty($pid)) { $pid = intval(get_argg('poll_id')); $sendor_id = intval(get_argg('sendor_id')); } //数据表定义区 $t_users = $tablePreStr . "users"; $t_poll = $tablePreStr . "poll"; $t_polloption = $tablePreStr . "polloption"; $t_polluser = $tablePreStr . "polluser"; $t_poll_com = $tablePreStr . "poll_comment"; $sql = "delete from {$t_poll} where p_id={$pid}"; $dbo->exeUpdate($sql); $sql = "delete from {$t_polloption} where pid={$pid}"; $dbo->exeUpdate($sql); $sql = "delete from {$t_polluser} where pid={$pid}"; $dbo->exeUpdate($sql); $sql = "delete from {$t_poll_com} where p_id={$pid}"; $dbo->exeUpdate($sql); increase_integral($dbo, $int_del_poll, $sendor_id); //回应信息 echo $m_langpackage->m_del_suc; } ?> <script language="javascript" type="text/javascript"> window.location.href='poll_list.php?order_by=p_id&order_sc=desc'; </script>
$title = $s_langpackage->s_shared . $user_name . $s_langpackage->s_video . '<a href="home.php?h=' . $uid . '&app=share_show&s_id=' . $s_content_id . '" target="_blank">' . $title_data . '</a>'; $share_id = share_act($dbo, $s_type, $s_content_id, $title, $tag, $re_link, $re_thumb, $re_m_link); $content = '<div style="background:url(' . $re_thumb . ') no-repeat scroll 0% 0% transparent;" class="movie_player"><a href="home.php?h=' . $user_id . '&app=share_show&s_id=' . $share_id . '" target="_blank"></a></div>'; break; case "8": $rs = api_proxy("group_sub_by_sid", "group_id,user_id,user_name,title,content", $s_content_id); if ($rs['user_id'] == $user_id) { echo $s_langpackage->s_no_share; } else { $user_name = '<a href="home.php?h=' . $rs['user_id'] . '" target="_blank">' . $rs['user_name'] . '</a>'; $title_data = $title_data ? $title_data : $rs['title']; $title = $s_langpackage->s_shared . $user_name . $s_langpackage->s_s_topic . '<a href="home.php?h=' . $rs['user_id'] . '&app=group_sub_show&group_id=' . $rs['group_id'] . '&subject_id=' . $s_content_id . '" target="_blank">' . $title_data . '</a>'; $share_id = share_act($dbo, $s_type, $s_content_id, $title, $tag); $content = get_blog_lentxt($rs['content']); break; } } //标签功能 $tag_id = tag_add($tag); $tag_state = tag_relation(3, $tag_id, $share_id); $content .= $s_comment ? '<div class="clear"></div><div class="left_g left"></div><div class="center_g left">' . $s_comment . '</div><div class="right_g left"></div><div class="clear"></div>' : ''; //插入动态表 $is_suc = api_proxy("message_set", $share_id, $title, $content, 4, 5); if ($is_suc) { $sql = "update {$t_share} set content='{$content}' where s_id={$share_id}"; $is_update = $dbo->exeUpdate($sql); increase_integral($dbo, $int_share, $user_id); echo "success"; } else { echo $s_langpackage->s_share_los; }
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); } if ($invite_fromuid) { increase_integral($dbo, $int_invited, $invite_fromuid); //取得介绍人的资料信息 $user_row = api_proxy("user_self_by_uid", "user_id,user_name,user_sex,user_ico,palsreq_limit", $invite_fromuid); if ($user_row) { $touser_id = $user_row['user_id']; $touser_name = $user_row['user_name']; $touser_sex = $user_row['user_sex']; $touser_ico = $user_row['user_ico']; $touser_pals_limit = $user_row['palsreq_limit']; } if ($touser_pals_limit == 0) { $sql = "insert into {$t_mypals} (user_id,pals_id,pals_name,pals_sex,add_time,pals_ico,accepted) values ({$user_id},{$invite_fromuid},'{$touser_name}','{$touser_sex}',NOW(),'{$touser_ico}',1)"; $dbo->exeUpdate($sql); set_sess_mypals($invite_fromuid); } }
if ($to_user_id != $from_user_id && $user_info['inputmess_limit']) { if ($user_info['inputmess_limit'] == 2) { action_return($result_type, $mb_langpackage->mb_add_pvw, "-1"); exit; } else { if ($user_info['inputmess_limit'] == 1) { if (!api_proxy("pals_self_isset", $to_user_id)) { action_return($result_type, $mb_langpackage->mb_add_pvw, "-1"); exit; } } } } $dbo = new dbex(); //读写分离定义函数 dbtarget('w', $dbServs); //留言 $sql = "insert into {$t_message}(`from_user_id`,`from_user_name`,`from_user_ico`,`to_user_id`,`message`,`add_time`) values({$from_user_id},'{$from_user_name}','{$from_user_ico}',{$to_user_id},'{$message}',now())"; if ($dbo->exeUpdate($sql)) { if ($to_user_id != $from_user_id) { increase_integral($dbo, $int_com_msg, $from_user_id); api_proxy("message_set", $to_user_id, $mb_langpackage->mb_remind, "modules.php?app=msgboard_more", 0, 7, "remind"); } if ($restore == 1) { $sql = "insert into {$t_message}(`from_user_id`,`from_user_name`,`from_user_ico`,`to_user_id`,`message`,`add_time`) values({$from_user_id},'{$from_user_name}','{$from_user_ico}',{$from_user_id},'{$message}',now())"; $dbo->exeUpdate($sql); } action_return($result_type, "", "-1"); } else { action_return($result_type, $mb_langpackage->mb_message_failed, "-1"); }
if ($maxchoice == 1) { $input_type = 'radio'; } else { $input_type = 'checkbox'; } $poll_option = "<input type=\"" . $input_type . "\" disabled />" . $cho_array[0] . "<br />"; $poll_option .= "<input type=\"" . $input_type . "\" disabled />" . $cho_array[1] . "<br />"; $poll_option .= "......"; $cho_ser = serialize(array($cho_array[0], $cho_array[1])); $multiple = $maxchoice == 1 ? 0 : 1; $cre_value = empty($credit) ? 0 : intval($credit); $per_value = empty($percredit) ? 0 : intval($percredit); $sql = "insert into {$t_poll} (`user_id`,`username`,`user_ico`,`subject`,`multiple`,`maxchoice`,`sex`,`noreply`,`dateline`,`credit`,`percredit`,`expiration`,`message`,`option`) values ({$user_id},'{$user_name}','{$userico}','{$subject}',{$multiple},{$maxchoice},{$sex},{$noreply},NOW(),{$cre_value},{$per_value},'{$expiration}','{$message}','{$cho_ser}')"; $dbo->exeUpdate($sql); $last_pid = mysql_insert_id(); foreach ($cho_array as $val) { $sql = "insert into {$t_polloption} (`pid` ,`option`) values ({$last_pid},'{$val}')"; $dbo->exeUpdate($sql); } if ($makefeed == 1) { //纪录新鲜事 $title = $pol_langpackage->pol_launch_vote . '<a href="home.php?h=' . $user_id . '&app=poll&p_id=' . $last_pid . '" target="_blank">' . $subject . '</a>'; $content = '<a href="home.php?h=' . $user_id . '&app=poll&p_id=' . $last_pid . '" target="_blank">' . $subject . '</a>'; $is_suc = api_proxy("message_set", $last_pid, $title, $content, 0, 4); } //标签功能 $tag_id = tag_add($tag); $tag_state = tag_relation(5, $tag_id, $last_pid); increase_integral($dbo, $int_poll, $user_id); //回应信息 action_return(0, "", "");
//目录设置 $up->set_thumb(180, 180); //缩略图设置 $fs = $up->execute(); $i = 0; foreach ($fs as $index => $realtxt) { if ($realtxt['flag'] == 1) { $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"); } } } }
//读写分离定义函数 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); }
$msgboards = $dbo->getRow($sql); $fu_id = $msgboards['from_user_id']; $to_uid = $msgboards['to_user_id']; //删除留言 $sql = "delete from {$t_table} where mess_id={$rs}"; if ($dbo->exeUpdate($sql)) { increase_integral($dbo, $int_del_com_msg, $fu_id); } } } else { //单条 //变量取得 $mess_id = intval(get_argg('mid')); $fu_id = intval(get_argg('fu_id')); $to_uid = intval(get_argg('to_uid')); //数据表定义区 $t_table = $tablePreStr . "msgboard"; $dbo = new dbex(); //读写分离定义函数 dbtarget('w', $dbServs); //删除留言 $sql = "delete from {$t_table} where mess_id={$mess_id}"; if ($dbo->exeUpdate($sql)) { increase_integral($dbo, $int_del_com_msg, $fu_id); echo $m_langpackage->m_del_suc; } } ?> <script language="javascript" type="text/javascript"> window.location.href='msgboard_list.php?order_by=mess_id&order_sc=desc'; </script>
if ($visitor_id != $host_id) { $focus = api_proxy("message_get_remind_count", $host_id); if ($focus[0] >= 20) { api_proxy("message_set_del", "remind", '', $host_id); } api_proxy("message_set", $host_id, $remind_content, $link, 1, 0, "remind"); } if ($to_userid) { $focus = api_proxy("message_get_remind_count", $to_userid); if ($focus[0] >= 20) { api_proxy("message_set_del", "remind", '', $to_userid); } api_proxy("message_set", $to_userid, $remind_content, $link, 1, 0, "remind"); } } increase_integral($dbo, $int_com_msg, $visitor_id); if ($last_id) { echo ' <div class="reaction" id="record_' . $type_id . '_' . $last_id . '">'; if ($visitor_id == $host_id) { echo '<a href="javascript:parent.del_com(' . $host_id . ',' . $type_id . ',' . $mod_id . ',' . $last_id . ',' . $visitor_id . ')" class="replyclose"></a>'; } echo ' <a class="figure" href="home.php?h=' . $visitor_id . '" target="_blank"><img src="' . $visitor_ico . '"/></a> <a href="home.php?h=' . $visitor_id . '" target="_blank">' . filt_word($visitor_name) . '</a><label>' . date("Y-m-d H:i:s", time()) . '</label> <p class="left">' . filt_word(get_face($content)) . '</p> </div>'; } ?>