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_"); }