function guest_self_by_uid($fields = "*", $id, $num = 5)
{
$fields = filt_fields($fields);
$id_str = filt_num_array($id);
$condition = " user_id = {$id_str} ";
return guest_read_base($fields, $condition, '', $num);
}
function share_self_by_uid($fields = "*", $id)
{
$fields = filt_fields($fields);
$id_str = filt_num_array($id);
$condition = strpos($id_str, ',') ? " and user_id in ({$id_str}) " : " and user_id={$id_str} ";
return share_read_base($fields, $condition);
}
function album_self_by_uid($fields = "*", $id, $num = '')
{
$fields = filt_fields($fields);
$id_str = filt_num_array($id);
$condition = strpos($id_str, ',') ? " and user_id in ({$id_str}) " : " and user_id = {$id_str} ";
return album_read_base($fields, $condition, 'getRs', $num);
}
function pals_self_by_uid($fields = "*", $id, $num = '')
{
$num = intval($num);
$fields = filt_fields($fields);
$id_str = filt_num_array($id);
$condition = strpos($id_str, ",") ? " user_id in ({$id_str}) and accepted>0 " : " user_id = {$id_str} and accepted>0 ";
return pals_read_base($fields, $condition, 'getRs', $num);
}
function mood_self_by_uid($fields = "*", $id)
{
$fields = filt_fields($fields);
$id_str = filt_num_array($id);
$get_type = "";
$condition = strpos($id_str, ',') ? " user_id in ({$id_str}) " : " user_id={$id_str} ";
return mood_read_base($fields, $condition);
}
function group_sub_by_date($fields = "*", $date = '', $col_by = 'hits', $order = 'desc', $num = 10)
{
$fields = filt_fields($fields);
if ($col_by != 'hits') {
$col_by = "comments";
}
$order = filt_order($order);
$condition = str_replace("{date}", "add_time", date_filter($date));
return group_sub_read_base($fields, $condition, '', $num, $col_by, $order);
}
function blog_self_by_date($fields = "*", $date = '', $by_col = 'hits', $order = "desc", $num = 10)
{
$num = intval($num);
$fields = filt_fields($fields);
$order = filt_order($order);
if ($by_col != 'hits') {
$by_col = 'comments';
}
$condition = str_replace("{date}", "add_time", date_filter($date));
return blog_read_base("*", $condition, "", $by_col, $order, $num);
}
function group_member_by_gid($fields = "*", $gid = "", $state = "")
{
global $tablePreStr;
$fields = filt_fields($fields);
$gid = intval($gid);
$condition = " group_id={$gid} ";
if ($state !== '') {
$state = intval($state);
$condition .= " and state={$state} ";
}
return group_member_base($fields, $condition);
}
function msgboard_self_by_uid($fields = "*", $uid = "", $is_read = "", $num = "", $date = "")
{
$uid = $uid ? $uid : get_sess_userid();
$is_read = intval($is_read);
$fields = filt_fields($fields);
$condition = " to_user_id = {$uid} ";
if ($date != '') {
$condition .= str_replace("{date}", "add_time", date_filter($date));
}
if ($is_read != '') {
$condition .= " and readed = {$is_read} ";
}
return msgboard_read_base($fields, $condition, "getRs", $num);
}
function scrip_inbox_get_mine($fields = "*", $date = "", $is_read = "", $from_id = "")
{
$from_id_str = filt_num_array($from_id);
$fields = filt_fields($fields);
$condition = "";
$condition .= str_replace("{date}", "add_time", date_filter($date));
if ($is_read == '0' || $is_read == '1') {
$is_read = intval($is_read);
$condition .= " and readed = {$is_read} ";
}
if ($from_id != '') {
$condition .= " and from_user_id in ({$from_id_str}) ";
}
return inbox_read_base($fields, $condition);
}
function scrip_outbox_get_mine($fields = "*", $to_id = "", $is_read = "", $date = "")
{
$to_id_str = filt_num_array($to_id);
$fields = filt_fields($fields);
$condition = "";
$condition .= str_replace("{date}", "add_time", date_filter($date));
if ($is_read !== '') {
$is_read = intval($is_read);
$condition .= " and state = {$is_read} ";
}
if ($to_id != '') {
$condition .= " and to_user_id in ({$to_id_str}) ";
}
return outbox_read_base($fields, $condition);
}
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 group_self_by_memberCount($fields = "*", $num = 10)
{
$fields = filt_fields($fields);
return group_read_base($fields, "", "", $num, "member_count");
}
function user_self_by_new($fields = "*", $num = 4)
{
$fields = filt_fields($fields);
return user_read_base($fields, "", "", $num);
}
function user_recommend_get($fields = "*")
{
$fields = filt_fields($fields);
return user_recommend_base($fields);
}
function poll_self_by_reward($fields = "*", $order = "desc", $num = 20)
{
$fields = filt_fields($fields);
$condition = " and percredit>0 ";
return poll_read_base($fields, $condition, '', $num, 'credit', $order, 1, "reward_");
}
