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 group_sub_by_uid($fields = "*", $id, $num = 10) { $fields = filt_fields($fields); $id_str = filt_num_array($id); $condition = strpos($id_str, ',') ? " user_id in ({$id_str}) " : " user_id={$id_str} "; return group_sub_read_base($fields, $condition, '', $num); }
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 poll_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 poll_read_base($fields, $condition); }
function share_self_by_sort($fields = "*", $sort, $num = 10) { $num = intval($num); $sort_str = filt_num_array($sort); $condition = strpos($sort_str, ',') ? " and type_id in ({$sort_str}) " : " and type_id={$sort_str} "; return share_read_base($fields, $condition, "", $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 blog_self_by_uid($fields = "*", $id, $sort_id = '', $num = '') { $fields = filt_fields($fields); $id_str = filt_num_array($id); $sort_str = filt_num_array($sort_id); $condition = strpos($id_str, ',') ? " and user_id in ({$id_str}) " : " and user_id = {$id_str} "; if ($sort_id != '') { $condition .= " and log_sort in ({$sort_str}) "; } return blog_read_base($fields, $condition, 'getRs', $num); }
function group_self_by_gid($fields = "*", $id, $get_type = '') { $fields = filt_fields($fields); $id_str = filt_num_array($id); if (strpos($id_str, ",")) { $condition = " and group_id in ({$id_str}) "; } else { $condition = " and group_id = {$id_str} "; $get_type = $get_type == 'getRs' ? "getRs" : "getRow"; } return group_read_base($fields, $condition, $get_type); }
function user_self_by_uid($fields = "*", $id) { $fields = filt_fields($fields); $id_str = filt_num_array($id); $get_type = ""; if (strpos($id_str, ",")) { $condition = " and user_id in ({$id_str}) "; } else { $condition = " and user_id = {$id_str} "; $get_type = "getRow"; } return user_read_base($fields, $condition, $get_type); }
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 plugins_get_pid($id, $get_type = '') { global $tablePreStr; $t_plugins = $tablePreStr . "plugins"; $t_plugin_url = $tablePreStr . "plugin_url"; $result_rs = array(); $dbo = new dbex(); dbplugin('r'); $id_str = filt_num_array($id); $sql = "select a.*,b.url from {$t_plugins} as a join {$t_plugin_url} as b on (a.name=b.name) where a.id ={$id_str}"; $get_type = $get_type ? $get_type : "getRow"; if (strpos($id_str, ",")) { $sql = "select a.*,b.url from {$t_plugins} as a join {$t_plugin_url} as b on (a.name=b.name) where a.id in ({$id_str})"; $get_type = "getRs"; } return $dbo->{$get_type}($sql); }
function message_get_affair_uid($id, $type = '', $num = 20) { $limit = intval($num) ? " limit {$num} " : ""; $type_str = filt_num_array($type); $id_str = filt_num_array($id); $sql_type = ""; if ($type_str != '') { $sql_type = " and mod_type in ({$type_str}) "; } global $tablePreStr; $t_recent_affair = $tablePreStr . "recent_affair"; $result_rs = array(); $dbo = new dbex(); dbplugin('r'); $sql = "select * from {$t_recent_affair} where user_id in ({$id_str}) {$sql_type} order by id desc {$limit} "; $result_rs = $dbo->getALL($sql); return $result_rs; }