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