function blog_sort_by_uid($id) { global $tablePreStr; $t_blog = $tablePreStr . "blog_sort"; $id = intval($id); $result_rs = array(); $dbo = new dbex(); dbplugin('r'); $sql = " select * from {$t_blog} where user_id = {$id} "; $result_rs = $dbo->getRs($sql); return $result_rs; }
function message_get_remind($is_focus, $num) { $limit = intval($num) ? " limit {$num} " : ""; $result_rs = array(); $dbo = new dbex(); dbplugin('r'); $uid = get_sess_userid(); global $tablePreStr; $t_remind = $tablePreStr . "remind"; $sql = "select * from {$t_remind} where user_id={$uid} and is_focus={$is_focus} order by id desc {$limit} "; $result_rs = $dbo->getRs($sql); return $result_rs; }
function scrip_notice_get($fields = "*", $num = "", $condition = "") { global $tablePreStr; global $page_num; global $page_total; $fields = filt_fields($fields); $uid = get_sess_userid(); $t_scrip = $tablePreStr . "msg_inbox"; $result_rs = array(); $dbo = new dbex(); dbplugin('r'); $sql = " select {$fields} from {$t_scrip} where user_id = {$uid} and mesinit_id='' {$condition} order by mess_id desc "; $dbo->setPages(20, $page_num); $result_rs = $dbo->getRs($sql); $page_total = $dbo->totalPage; return $result_rs; }
function pals_self_by_online($fields = "*", $num = "") { $num = intval($num); $limit = ''; if ($num != 0) { $limit = " limit {$num} "; } $fields = filt_fields($fields); $pals_id_str = get_sess_mypals(); global $tablePreStr; $t_online = $tablePreStr . "online"; $result_rs = array(); $dbo = new dbex(); dbplugin('r'); $sql = " select {$fields} from {$t_online} where user_id in ({$pals_id_str}) and hidden = 0 order by active_time desc {$limit} "; return $dbo->getRs($sql); }
function group_self_by_pals($fields = "*") { $fields = filt_fields($fields); $group_id_str = ''; global $tablePreStr; $t_group_members = $tablePreStr . "group_members"; $result_rs = array(); $dbo = new dbex(); dbplugin('r'); $pals_id = get_sess_mypals(); $sql = " select group_id from {$t_group_members} where user_id in ({$pals_id}) "; $group_data = $dbo->getRs($sql); foreach ($group_data as $rs) { $group_id_str .= $rs['group_id'] . ","; } $group_id_str = preg_replace("/,\$/", "", $group_id_str); return group_self_by_gid($fields, $group_id_str); }
$m_langpackage = new modulelp(); $u_langpackage = new uilp(); $ad_langpackage = new adminmenulp(); if (get_session('admin_group') != 'superadmin') { echo $ri_langpackage->ri_refuse; exit; } //数据库读写 $dbo = new dbex(); dbtarget('w', $dbServs); $user_group = get_argg('user_group'); //数据表定义 $t_frontgroup = $tablePreStr . "frontgroup"; $t_users = $tablePreStr . "users"; $sql = "select gid,name from {$t_frontgroup}"; $groups = $dbo->getRs($sql); $options = "<option value=\"\" selected>" . $ri_langpackage->ri_choose . "</option>"; $group_array = array(); if ($groups) { foreach ($groups as $group) { $selected = ''; if ($user_group == $group['gid']) { $selected = 'selected'; } $options .= '<option value="' . $group['gid'] . '" ' . $selected . '>' . $group['name'] . '</option>'; $group_array[$group['gid']] = $group['name']; } } if (get_args("op") == 'upd') { $group = get_args('group'); $user_id = intval(get_args('user_id'));
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 { $autoorder = ""; } if (isset($plugin[0]['valid']) && $plugin[0]['valid'] == 1) { $valid = "checked"; } else { $valid = ""; } echo <<<EOD <form method="post" name="uploadform" action="?path={$path}&operator=update"> \t<table width="100%" border="0"> \t <tr>
$t_polluser = $tablePreStr . "polluser"; $t_users = $tablePreStr . "users"; //定义写操作 dbtarget('r', $dbServs); $dbo = new dbex(); $sql = "select username from {$t_polluser} where uid={$ses_uid} and pid={$pid}"; $is_poll = $dbo->getRow($sql); if (!empty($is_poll)) { action_return(0, "{$pol_langpackage->pol_repeat}", -1); } $option = ''; 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)) {
$dbo = new dbex(); dbtarget('w', $dbServs); //当前页面参数 $page_num = trim(get_argg('page')); //变量区 $c_orderby = short_check(get_argg('order_by')); $c_ordersc = short_check(get_argg('order_sc')); $c_perpage = get_argg('perpage') ? intval(get_argg('perpage')) : 20; $eq_array = array('s_id', 'user_id', 'user_name'); $like_array = array(); $date_array = array("add_time"); $num_array = array(); $sql = spell_sql($t_table, $eq_array, $like_array, $date_array, $num_array, $c_orderby, $c_ordersc); $dbo->setPages($c_perpage, $page_num); //设置分页 $share_rs = $dbo->getRs($sql); $page_total = $dbo->totalPage; //分页总数 //按字段排序 $o_def = ''; $o_add_time = ''; if (!get_argg('order_by') || get_argg('order_by') == "shareid") { $o_def = "selected"; } if (get_argg('order_by') == "add_time") { $o_add_time = "selected"; } //显示控制 $isset_data = ""; $none_data = "content_none"; $isNull = 0;
$mp_sort_list = array(); $sql = "select * from {$t_mypals} where user_id={$user_id} and accepted > 0 "; if ($sort_id != '') { $str = $mp_langpackage->mp_whole; $show_none_str = $mp_langpackage->mp_sort_pals; $sql .= " and pals_sort_id = {$sort_id} "; } else { if ($search_name != '') { $show_none_str = $mp_langpackage->mp_none_search; $sql .= " and pals_name like '%{$search_name}%' "; } } $sql .= " order by pals_sort_id desc "; $dbo->setPages(20, $page_num); //设置分页 $mp_list_rs = $dbo->getRs($sql); $page_total = $dbo->totalPage; //分页总数 $none_data = "content_none"; $isNull = 0; if (empty($mp_list_rs)) { $none_data = ""; $isNull = 1; } $mp_sort_list = api_proxy("pals_sort"); //取得好友圈分类 ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
} if ($autoorder) { $plugin->removeChild($autoorder); } if ($valid) { $plugin->removeChild($valid); } $dom->formatOutput = true; $dom->save("{$plugin_base}/{$path}/plugin.xml"); //清除权限资源 $xmlpath = $webRoot . "plugins/resources.xml"; $xml = new XMLOperator($xmlpath); if ($xml->query("//group[@id='plugin_{$path}']")) { $sql = "select id,rights from {$t_backgroup} where rights like '%{$path}_%'"; dbtarget('r', $dbServs); $groups = $dbo->getRs($sql); dbtarget('w', $dbServs); if (!empty($groups)) { foreach ($groups as $group) { $rights = preg_replace("/{$path}[^,]+(,?)/", "", $group['rights']); if (substr($rights, -1) == ',') { $rights = substr($rights, 0, -1); } $sql = "update {$t_backgroup} set rights='{$rights}' where id={$group['id']}"; $dbo->exeUpdate($sql); } } $xml->delNode("//group[@id='plugin_{$path}']"); $xml->save($xmlpath); } $xmlpath = $webRoot . "plugins/front_resources.xml";
echo $ri_langpackage->ri_isset_id; exit; } } else { if (get_args('del') == 'del') { $sql = "delete from {$t_backgroup} where gid='{$id}'"; $dbo->exeUpdate($sql); } else { if (get_args('update')) { $sql = "update {$t_backgroup} set name='{$value}' where gid='{$id}'"; $dbo->exeUpdate($sql); } } } $sql = "select * from {$t_backgroup}"; $elements = $dbo->getRs($sql); ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title></title> <link rel="stylesheet" type="text/css" media="all" href="../css/admin.css"> <script type='text/javascript' src='../../servtools/ajax_client/ajax.js'></script> <script type='text/javascript'> function update_group(id_value){ var group_value=document.getElementById("value_"+id_value).value; if(group_value==''){ alert('<?php echo $ri_langpackage->ri_user_wrong;
dbtarget('w', $dbServs); $sql = "insert into {$t_admin} (admin_name,admin_password,active_time,admin_group) values('{$name}','{$password}',now(),'{$group}')"; $dbo->exeUpdate($sql); } else { echo $ri_langpackage->ri_isset_user; } } else { echo "<script>alert('" . $p_langpackage->p_differ . "')</script>"; } } } } } } $sql = "select * from {$t_admin}"; $admins = $dbo->getRs($sql); ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title></title> <link rel="stylesheet" type="text/css" media="all" href="../css/admin.css"> </head> <body> <div id="maincontent"> <div class="wrap"> <div class="crumbs"><?php echo $ad_langpackage->ad_location; ?> >> <a href="javascript:void(0);"><?php
//数据表定义区 $t_blog = $tablePreStr . "blog"; $t_uploadfile = $tablePreStr . "uploadfile"; $t_blog_comments = $tablePreStr . "blog_comment"; $dbo = new dbex(); //读写分离定义函数 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);
//变量取得 if (empty($album_id)) { $album_id = intval(get_argg('aid')); $user_id = intval(get_argg('uid')); } //删除相册功能 //数据表定义区 $t_album = $tablePreStr . "album"; $t_photo = $tablePreStr . "photo"; $t_photo_comment = $tablePreStr . "photo_comment"; $t_album_comment = $tablePreStr . "album_comment"; $dbo = new dbex(); //读写分离定义方法 dbtarget('r', $dbServs); $sql = "select * from {$t_photo} where album_id={$album_id}"; $photo_rs = $dbo->getRs($sql); dbtarget('w', $dbServs); foreach ($photo_rs as $val) { @unlink('../' . $val['photo_src']); @unlink('../' . $val['photo_thumb_src']); increase_integral($dbo, $int_del_photo, $user_id); //删除照片相关评论 $photo_id = $val['photo_id']; $sql = "delete from {$t_photo_comment} where photo_id ={$photo_id}"; $dbo->exeUpdate($sql); } //删除相册有关照片 $sql = "delete from {$t_photo} where album_id={$album_id}"; $dbo->exeUpdate($sql); //删除相册相关评论 $sql = "delete from {$t_album_comment} where album_id={$album_id}";
$ra_type_str = $ra_type ? " and type_id={$ra_type} " : ""; $pals_str = ''; $limit_num = 0; $ra_rs = array(); //数据表定义区 $t_rec_affair = $tablePreStr . "recent_affair"; //数据库读操作 $dbo = new dbex(); dbtarget('r', $dbServs); if ($holder_id != '') { //home新鲜事 $limit_num = $homeAffairNum; $hidden_button_over = "void(0)"; $hidden_button_out = "void(0)"; $sql = "select * from {$t_rec_affair} where user_id={$holder_id} order by id desc limit {$start_num} , {$limit_num}"; $ra_rs = $dbo->getRs($sql); } else { //main新鲜事 if ($pals_id) { $limit_num = $mainAffairNum; $ra_mod_type = ''; $hidden_button_over = "feed_menu({id},1);"; $hidden_button_out = "feed_menu({id},0);"; //屏蔽某人新鲜事 if ($hidden_pals_id != '' && $hidden_pals_id != ',') { $pals_str = "," . $pals_id . ","; $hidden_pals_array = explode(",", $hidden_pals_id); foreach ($hidden_pals_array as $rep) { if ($rep != '') { $pals_str = str_replace("," . $rep . ",", ",", $pals_str); }
} if ($s_city != $mp_langpackage->mp_city && $s_city != '' && $s_city != $mp_langpackage->mp_none_limit) { $cols .= " and (reside_city like '%{$s_city}%') "; } if ($sex != '') { $cols .= " and user_sex={$sex} "; } if ($age) { $age = explode('|', $age); $cols .= " and {$now_year}-birth_year BETWEEN {$age['0']} and {$age['1']} "; } if ($is_online == 1) { $table = $t_online; $cols .= " and hidden = 0 "; } $page_num = trim(get_argg('page')); $sql = "select user_id,user_name,user_sex,birth_province,birth_city,reside_province,reside_city,user_ico from {$table} where {$cols} "; $dbo->setPages(20, $page_num); //设置分页 $search_rs = $dbo->getRs($sql); $page_total = $dbo->totalPage; //分页总数 //控制显示 $isset_data = ""; $none_data = "content_none"; $isNull = 0; if (empty($search_rs)) { $isset_data = "content_none"; $none_data = ""; $isNull = 1; }
$dbo = new dbex(); dbtarget('w', $dbServs); //当前页面参数 $page_num = trim(get_argg('page')); //变量区 $c_orderby = short_check(get_argg('order_by')); $c_ordersc = short_check(get_argg('order_sc')); $c_perpage = get_argg('perpage') ? intval(get_argg('perpage')) : 20; $eq_array = array('album_id', 'user_id', 'user_name'); $like_array = array('album_name'); $date_array = array("add_time"); $num_array = array(); $sql = spell_sql($t_table, $eq_array, $like_array, $date_array, $num_array, $c_orderby, $c_ordersc); $dbo->setPages($c_perpage, $page_num); //设置分页 $album_rs = $dbo->getRs($sql); $page_total = $dbo->totalPage; //分页总数 //按字段排序 $o_def = ''; $o_add_time = ''; $o_hits = ''; if (!get_argg('order_by') || get_argg('order_by') == "album_id") { $o_def = "selected"; } if (get_argg('order_by') == "add_time") { $o_add_time = "selected"; } if (get_argg('order_by') == "photo_num") { $o_hits = "selected"; }
if ($user_info['inputmess_limit'] == 1) { if (!api_proxy("pals_self_isset", $holder_id)) { $show_msg = 0; } } } } $dbo = new dbex(); //读写分离定义方法 dbtarget('r', $dbServs); $holder_photo = array(); $holder_blog = array(); $holder_message = array(); //取得最新照片 $sql = "select p.album_id,p.photo_id,p.photo_thumb_src,p.add_time,p.photo_name from {$t_album} as a join {$t_photo} as p on(a.album_id=p.album_id) where p.user_id={$holder_id} and a.privacy='' and p.privacy='' and a.is_pass=1 and p.is_pass=1 order by p.photo_id desc limit 4"; $holder_photo = $dbo->getRs($sql); //取得最新日志 $sql = "select log_id,log_title,log_content,add_time from {$t_blog} where user_id={$holder_id} and is_pass=1 and privacy='' order by log_id desc limit 3 "; $holder_blog = $dbo->getRs($sql); ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="X-UA-Compatible" content="IE=EmulateIE7" /> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> <title></title> <base href='<?php echo $siteDomain; ?> ' /> <link rel="stylesheet" href="skin/<?php
$int_login='******'; $int_one_ico=' . $one_ico . '; $int_convert=' . $convert . '; $int_upgrade=' . $upgrade . '; $int_poll=' . $poll . '; $int_del_poll=' . $del_poll . '; $int_share=' . $sha . '; $int_del_share=' . $del_sha . '; ?>'; fwrite($config_re, trim($insert_config_data)); fclose($config_re); echo "<script type='text/javascript'>alert('{$f_langpackage->f_amend_suc}');window.location.href='integral.php';</script>"; } dbtarget('r', $dbServs); $sql = "select * from {$t_integral}"; $integral_rs = $dbo->getRs($sql); ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <link rel="stylesheet" type="text/css" media="all" href="css/admin.css"> <title></title> </head> <body> <div id="maincontent"> <div class="wrap"> <div class="crumbs"><?php echo $ad_langpackage->ad_location; ?> >> <a href="javascript:void(0);"><?php
<?php $pl_langpackage = new pluginslp(); require "api/base_support.php"; require "foundation/fpages_bar.php"; $search_app = get_argp('search_app'); $def_image = "skin/" . $skinUrl . "/images/plu_def.jpg"; $page_num = intval(get_argg('page')); $app_rs = array(); if ($search_app) { $page_total = ''; $dbo = new dbex(); dbtarget('r', $dbServs); $t_plugins = $tablePreStr . "plugins"; $search_app = short_check(get_argp('search_app')); $sql = "select * from {$t_plugins} where `title` like '%{$search_app}%'"; $app_rs = $dbo->getRs($sql); $isNull = 1; $error_str = $pl_langpackage->pl_search_none; } else { $app_rs = api_proxy("plugins_get_all"); $isNull = 0; if (empty($app_rs)) { $isNull = 1; } $error_str = $pl_langpackage->pl_none; }
dbtarget('w', $dbServs); //当前页面参数 $page_num = trim(get_argg('page')); //变量区 $c_orderby = short_check(get_argg('order_by')); $c_ordersc = short_check(get_argg('order_sc')); $c_perpage = get_argg('perpage') ? intval(get_argg('perpage')) : 20; $eq_array = array('group_id', 'group_type_id', 'group_join_type', 'group_type'); $like_array = array('group_name'); $date_array = array(); $num_array = array("comments", "subjects_num", "member_count"); $sql = spell_sql($t_table, $eq_array, $like_array, $date_array, $num_array, $c_orderby, $c_ordersc); //设置分页 $dbo->setPages($c_perpage, $page_num); //取得数据 $group_rs = $dbo->getRs($sql); //分页总数 $page_total = $dbo->totalPage; //加入方式 $j_no_limit = ''; $j_free = ''; $j_check = ''; $j_reju = ''; if (get_argg('join_type') == '') { $j_no_limit = "selected"; } if (get_argg('join_type') == '0') { $j_free = "selected"; } if (get_argg('join_type') == '1') { $j_check = "selected";
$is_check = check_rights("a10"); if (!$is_check) { echo $m_langpackage->m_no_pri; exit; } if (!$is_check) { echo $m_langpackage->m_no_pri; exit; } $mod = "pals"; $str = $f_langpackage->f_fir_sort; $t_pals_def_sort = $tablePreStr . "pals_def_sort"; $sql = "select * from {$t_pals_def_sort} order by order_num desc"; } } $sort_rs = $dbo->getRs($sql); ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <title></title> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> <link rel="stylesheet" type="text/css" media="all" href="css/admin.css"> <script type='text/javascript' src='../servtools/ajax_client/ajax.js'></script> <script type='text/javascript'> function manager_sort(modules,sort_id,type_value) { if(type_value=="add"){var sort_name=document.getElementById("add_value").value;var sort_order=document.getElementById("add_order_num").value;} if(type_value=="change"){var sort_name=document.getElementById("input_title_"+sort_id).value;var sort_order=document.getElementById("input_num_"+sort_id).value;} var manager_sort=new Ajax(); manager_sort.getInfo("manager_sort.action.php?module="+modules+"&type_value="+type_value+"&sort_id="+sort_id,"post","app","sort_name="+sort_name+"&sort_order="+sort_order,function(c){window.location.reload();});
$dbo = new dbex(); dbtarget('w', $dbServs); //当前页面参数 $page_num = trim(get_argg('page')); //变量区 $c_orderby = short_check(get_argg('order_by')); $c_ordersc = short_check(get_argg('order_sc')); $c_perpage = get_argg('perpage') ? intval(get_argg('perpage')) : 20; $eq_array = array('type'); $like_array = array(); $date_array = array(); $num_array = array(); $sql = spell_sql($t_table, $eq_array, $like_array, $date_array, $num_array, $c_orderby, $c_ordersc); $dbo->setPages($c_perpage, $page_num); //设置分页 $reqort_rs = $dbo->getRs($sql); $page_total = $dbo->totalPage; //分页总数 //条件显示 $l_gro = ''; $l_blg = ''; $l_pic = ''; $l_alb = ''; $l_poll = ''; $l_sub = ''; $l_sha = ''; $l_spc = ''; if (get_argg('type') == "1") { $l_gro = "selected"; } if (get_argg('type') == "0") {
//当前页面参数 $page_num = trim(get_argg('page')); //变量区 $c_orderby = short_check(get_argg('order_by')); $c_ordersc = short_check(get_argg('order_sc')); $c_perpage = get_argg('perpage') ? intval(get_argg('perpage')) : 20; $eq_array = array('user_id', 'group_id', 'subject_id'); $like_array = array("title", "user_name"); $date_array = array("add_time"); $num_array = array("comments", "hits"); $join_cond = "group_id"; $sql = spell_sql($t_table, $eq_array, $like_array, $date_array, $num_array, $c_orderby, $c_ordersc, $join_cond); //设置分页 $dbo->setPages($c_perpage, $page_num); //取得数据 $subject_rs = $dbo->getRs($sql); //分页总数 $page_total = $dbo->totalPage; //按字段排序 $o_def = ''; $o_s_date = ''; $o_hits = ''; $o_comments = ''; if (!get_argg('order_by') || get_argg('order_by') == "subject_id") { $o_def = "selected"; } if (get_argg('order_by') == "add_time") { $o_s_date = "selected"; } if (get_argg('order_by') == "hits") { $o_hits = "selected";
$dbo = new dbex(); dbtarget('w', $dbServs); //当前页面参数 $page_num = trim(get_argg('page')); //变量区 $c_orderby = short_check(get_argg('order_by')); $c_ordersc = short_check(get_argg('order_sc')); $c_perpage = get_argg('perpage') ? intval(get_argg('perpage')) : 20; $eq_array = array('is_pass', 'user_sex', 'user_id', 'rec_class'); $like_array = array('user_name'); $date_array = array("add_time"); $num_array = array('guest_num'); $sql = spell_sql($t_table, $eq_array, $like_array, $date_array, $num_array, $c_orderby, $c_ordersc); //取得数据 $dbo->setPages($c_perpage, $page_num); $recommend_rs = $dbo->getRs($sql); $page_total = $dbo->totalPage; //用户状态 $s_no_limit = ''; $s_lock = ''; $s_normal = ''; if (get_argg('u_state') == '') { $s_no_limit = "selected"; } if (get_argg('u_state') == '0') { $s_lock = "selected"; } if (get_argg('u_state') == '1') { $s_normal = "selected"; } //用户性别
$dbo = new dbex(); dbtarget('w', $dbServs); //当前页面参数 $page_num = trim(get_argg('page')); //变量区 $c_orderby = short_check(get_argg('order_by')); $c_ordersc = short_check(get_argg('order_sc')); $c_perpage = get_argg('perpage') ? intval(get_argg('perpage')) : 20; $eq_array = array('host_id', 'visitor_id', 'visitor_name', $con_id); $like_array = array('content'); $date_array = array("add_time"); $num_array = array(); $sql = spell_sql($t_table, $eq_array, $like_array, $date_array, $num_array, $c_orderby, $c_ordersc); $dbo->setPages($c_perpage, $page_num); //设置分页 $com_rs = $dbo->getRs($sql); $page_total = $dbo->totalPage; //分页总数 //按字段排序 $o_def = ''; $o_add_time = ''; if (get_argg('order_by') == '' || get_argg('order_by') == "com_id") { $o_def = "selected"; } if (get_argg('order_by') == "add_time") { $o_add_time = "selected"; } //显示控制 $isset_data = ""; $none_data = "content_none"; $isNull = 0;
<?php //引入模块公共方法文件 require "foundation/module_users.php"; require "foundation/fcontent_format.php"; require "foundation/fpages_bar.php"; $to_user_id = get_sess_userid(); $hi_rs = array(); //当前页面参数 $page_num = trim(get_argg('page')); //引入语言包 $u_langpackage = new userslp(); $hi_langpackage = new hilp(); //数据表定义区 $t_hi = $tablePreStr . "hi"; //定义读取操作 dbtarget('r', $dbServs); $dbo = new dbex(); $dbo->setPages(20, $page_num); //设置分页 $sql = "select * from {$t_hi} where to_user_id={$to_user_id} order by add_time desc"; $hi_rs = $dbo->getRs($sql); $page_total = $dbo->totalPage; //分页总数 $isNull = 0; $none_data = 'content_none'; if (empty($hi_rs)) { $none_data = ''; $isNull = 1; }
require_once $dbConfFile; // init $dbServs require_once $webRoot . 'foundation/debug.php'; if (!is_login()) { header($siteRoot . "index.php"); exit; } echo '<p><sup>说明:<br />通过调用api <a href="http://open.weibo.com/wiki/2/statuses/repost_by_me">repost_by_me</a> 来获取当前用户最新转发微博列表.<br />然后比对数据库中当前用户的任务记录.<br />问题:<br />1. repost_by_me 只能用户登录时自己调用;<br />2. repost_by_me获取所谓‘最新转发’,但是具体时间并没有说明,测试结果也比较诡异。包括since_id和max_id,都有待进一步测试。</p>'; echo '<hr />'; // 按照用户检查转发任务,测试版 // 从数据库中取出当前用户做过的转发任务的mid(同id) $uid = $_SESSION['uid']; $dbo = new dbex($dbServs); echo '<h3>我在微动力做转发任务产生的mid</h3>'; $sql = "select task_id, repost_mid, task_text from do_task JOIN task using(task_id) where user_id = {$uid} and status = 'finish' and type = 'forward' limit 10"; $sql_res = $dbo->getRs($sql); $task_weibo_mids = array(); if (0 != count($sql_res)) { foreach ($sql_res as $weibo) { echo '任务微博 -- ' . $weibo['task_text'] . '。<br />转发产生的mid -- ' . $weibo['repost_mid'] . '</p>'; $task_weibo_mids[$weibo['task_id']] = $weibo['repost_mid']; } } else { echo '<p>我最近没有在微动力上做任务</p>'; } // 通过api查询当前用户最近转发的微博id //var_dump($sql_res); echo '<hr />'; $c = new SaeTClientV2(WB_AKEY, WB_SKEY, $_SESSION['stoken']); echo '<h3>用新浪api获取我最近转发的微博mid</h3>'; $repost_weibos = $c->repost_by_me(1, 9, 3430446513991533);
if (!isset($_GET['type'])) { $type = 'sina_repost'; } else { $type = $_GET['type']; //if ( 'sina_repost' != $type && 'sina_follow' != $type && 'sina_review' != $type && 'sina_create' != $type ) { if ('sina_repost' != $type && 'sina_follow' != $type) { $type = 'sina_repost'; } } // 根据用户身份获取不同内容 if ('ader' == $_SESSION['role']) { // 企业用户 switch ($type) { case 'sina_repost': $sql = "select * from task_info_sina_repost join task using(task_id) where owner_id = {$_SESSION['uid']} and type = 1"; $res = $dbo->getRs($sql); break; case 'sina_follow': $sql = "select * from task_info_sina_follow join task using(task_id) where owner_id = {$_SESSION['uid']} and type = 2"; $res = $dbo->getRs($sql); break; default: break; } } else { if ('user' == $_SESSION['role']) { // 个人用户 switch ($type) { case 'sina_repost': $sql = "select time, screen_name, text from task_info_sina_repost join do_task using(task_id) where user_id = {$_SESSION['uid']} and task_type = 1"; $res = $dbo->getRs($sql);