示例#1
0
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);
}
示例#2
0
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);
}
示例#3
0
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);
}
示例#4
0
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);
}
示例#5
0
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);
}
示例#6
0
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);
}
示例#7
0
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);
}
示例#8
0
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);
}
示例#9
0
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);
}
示例#10
0
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);
}
示例#11
0
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);
}
示例#12
0
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);
}
示例#13
0
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);
}
示例#14
0
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;
}