PHP jimplode函数代码示例

 function Main()
 {
     $uid = MEMBER_ID;
     if ($uid < 1) {
         $this->Messager("请先<a href='index.php?mod=login'>点此登录</a>或者<a href='index.php?mod=member'>点此注册</a>一个帐号", 'index.php?mod=login');
     }
     $member = jsg_member_info($uid);
     $sql = "select * from `" . TABLE_PREFIX . "blacklist` where `uid` = '" . MEMBER_ID . "' ";
     $query = $this->DatabaseHandler->Query($sql);
     $uids = array();
     while (false != ($row = $query->GetRow())) {
         $uids[$row['touid']] = $row['touid'];
     }
     if ($uids) {
         $where = "where `uid` in (" . jimplode($uids) . ")";
         $member_list = $this->_MemberList($where);
         if ($uids && MEMBER_ID > 0) {
             $sql = "select `uid`,`tid`,`content`,`dateline` from `" . TABLE_PREFIX . "topic` where `uid` in (" . jimplode($uids) . ") group by `uid` order by `dateline` desc";
             $query = $this->DatabaseHandler->Query($sql);
             $topic_list = array();
             while (false != ($row = $query->GetRow())) {
                 $row['content'] = cut_str($row['content'], 100);
                 $row['dateline'] = my_date_format2($row['dateline']);
                 $topic_list[] = $row;
             }
         }
     }
     $group_list = jlogic('buddy_follow_group')->get_my_group(MEMBER_ID);
     $this->Title = '黑名单';
     include template('social/blacklist');
 }

 public function new_topic($p)
 {
     $ps = array('cache_time' => max(0, (int) $p['cache_time']), 'page_url' => $p['page_url']);
     if (isset($p['perpage'])) {
         $ps['perpage'] = (int) $p['perpage'];
     }
     $ps['cache_key'] = 'topic-new_topic';
     $ps['order'] = ' `dateline` DESC ';
     $ps['where'] = ' `type` IN (' . jimplode(get_topic_type()) . ') ';
     return $this->_get($ps);
 }

 function CategoryUserList($where = '', $limit = '', $query_link = '', $orderby = 'uid')
 {
     $per_page_num = $limit ? $limit : 20;
     $p = array('cache_time' => 300, 'cache_file' => 1, 'sql_where' => $where, 'sql_order' => ' `id` DESC ');
     $uds = jtable('validate_category_fields')->get_ids($p, 'uid');
     if ($uds) {
         $total_record = count($uds);
         $page_arr = page($total_record, $per_page_num, $query_link, array('return' => 'array'));
         $wherelist = "where `uid` in (" . jimplode($uds) . ") and `city` !='' order by `{$orderby}` desc  {$page_arr['limit']} ";
         $TopicLogic = jlogic('topic');
         $members = $TopicLogic->GetMember($wherelist, "`uid`,`ucuid`,`media_id`,`aboutme`,`username`,`nickname`,`province`,`city`,`face_url`,`face`,`validate`");
         $members = buddy_follow_html($members, 'uid', 'follow_html2');
     }
     $user_ary = array('member' => $members, 'uids' => $uds, 'pagearr' => $page_arr);
     return $user_ary;
 }

 function get_token($uids)
 {
     $token = array();
     $uids = is_array($uids) ? $uids : (is_numeric($uids) && $uids > 0 ? array($uids) : ('all' == $uids ? $uids : array()));
     if ($uids) {
         if ('all' == $uids) {
             $query = DB::query("SELECT `token` FROM " . DB::table('ios'));
         } else {
             $query = DB::query("SELECT `token` FROM " . DB::table('ios') . " where uid IN (" . jimplode($uids) . ")");
         }
         while ($value = DB::fetch($query)) {
             $token[] = $value['token'];
         }
     }
     return $token;
 }

 function delete_feed($p = array())
 {
     $time = TIMESTAMP;
     if ($p['all']) {
         DB::Query("delete from " . DB::table('feed_log'));
     } elseif ($p['week']) {
         $time = $time - 7 * 24 * 3600;
         DB::Query("delete from " . DB::table('feed_log') . " where `dateline` < '{$time}'");
     } elseif ($p['month']) {
         $time = $time - 30 * 24 * 3600;
         DB::Query("delete from " . DB::table('feed_log') . " where `dateline` < '{$time}'");
     } elseif ($p['ids']) {
         $dids = is_array($p['ids']) ? $p['ids'] : (array) $p['ids'];
         DB::Query("delete from " . DB::table('feed_log') . " where `id` in(" . jimplode($dids) . ")");
     }
 }

 function DoModify()
 {
     if (($new_module = trim($this->Post['new_module'])) && trim($new_module_name = $this->Post['new_module_name'])) {
         jtable('role_module')->replace(array("module" => $new_module, "name" => $new_module_name));
     }
     $module_list = (array) $this->Post['module'];
     foreach ($module_list as $module) {
         jtable('role_module')->replace($module);
     }
     $delete_list = (array) $this->Post['delete'];
     if ($delete_list) {
         $module_in = " `module` IN (" . jimplode($delete_list) . ") ";
         DB::query("DELETE FROM " . TABLE_PREFIX . "role_module where " . $module_in);
         $sql = "DELETE FROM " . TABLE_PREFIX . "role_action where " . $module_in;
         $this->DatabaseHandler->Query($sql);
     }
     $this->Messager("修改成功");
 }

 function attach_list($ids)
 {
     $ids = $this->get_ids($ids, 0, 1);
     $list = array();
     if ($ids) {
         $query = DB::query("SELECT * FROM " . DB::table('topic_attach') . " WHERE id IN(" . jimplode($ids) . ")");
         $candown = jclass('member')->HasPermission('uploadattach', 'down');
         $canviewtype = array('doc', 'ppt', 'pdf', 'xls', 'txt', 'docx', 'xlsx', 'pptx');
         while ($attach = DB::fetch($query)) {
             $attach_img = $attach['filetype'];
             $attach_name = $attach['name'];
             $attach_size = $attach['filesize'];
             $attach_down = $attach['download'];
             $attach_size = $attach_size > 1024 * 1024 ? round($attach_size / (1024 * 1024), 2) . 'MB' : ($attach_size == 0 ? '未知' : round($attach_size / 1024, 1) . 'KB');
             $attach_score = $attach['score'];
             $attach_file = RELATIVE_ROOT_PATH . $attach['file'];
             $attach_url = ($attach['site_url'] ? $attach['site_url'] : $GLOBALS['_J']['site_url']) . '/' . str_replace('./', '', $attach['file']);
             $list[$attach['id']] = array('id' => $attach['id'], 'attach_img' => 'images/filetype/' . $attach_img . '.gif', 'attach_file' => $attach_file, 'attach_name' => $attach_name, 'attach_score' => $attach_score, 'attach_down' => $attach_down, 'attach_size' => '大小:' . $attach_size, 'url' => $attach_url, 'onlineview' => $candown && in_array($attach_img, $canviewtype) && $attach_score == 0 ? $attach_url : '');
         }
     }
     return $list;
 }

function app_itemid2tid($item, $item_id, $options = null)
{
    $table_name = app_table($item);
    if (!$table_name) {
        return array();
    }
    if ($item == 'talk' && $options['talkwhere']) {
        $where_sql = $options['talkwhere'];
    } else {
        $where_sql = ' 1 ';
    }
    if (is_array($item_id)) {
        $where_sql .= " AND item_id IN (" . jimplode($item_id) . ") ";
    } else {
        $where_sql .= " AND item_id='{$item_id}' ";
    }
    $query = DB::query("SELECT tid FROM " . DB::table($table_name) . " WHERE {$where_sql} ");
    $tid_ary = array();
    while ($value = DB::fetch($query)) {
        $tid_ary[] = $value['tid'];
    }
    return $tid_ary;
}

 function iframe_recommend()
 {
     $ids = (int) (jget('ids') ? jget('ids') : jget('id'));
     if ($ids < 1) {
         exit('ids is empty');
     }
     $sql = " select * from `" . TABLE_PREFIX . "share` where `id` = '{$ids}' ";
     $query = $this->DatabaseHandler->Query($sql);
     $sharelist = $query->GetRow();
     if (!$sharelist) {
         exit('ids is invalid');
     }
     $share = @unserialize($sharelist['show_style']);
     $topic_charset = $share['topic_charset'];
     $share['limit'] = max(0, (int) $share['limit']);
     if ($share['limit'] < 1 || $share['limit'] > 200) {
         $share['limit'] = 20;
     }
     $share['string'] = max(0, (int) $share['string']);
     $order = ' `dateline` DESC ';
     $condition = '';
     $rets = $topic_list = array();
     if ('live' == $sharelist['type']) {
         $rr = jlogic('live')->get_script_out_list(1, $share['limit'], $share['string']);
         $rets = $live_list = $rr;
     } else {
         $user_topic_list = '';
         if ('topic' == $sharelist['type']) {
             $nickname = '';
             if ($sharelist['nickname']) {
                 $nickname = $sharelist['nickname'];
             } else {
                 $nickname = get_safe_code(jget('nickname'));
             }
             if ($nickname) {
                 $ns = explode('|', $nickname);
                 $uids = jtable('members')->get_ids(array('nickname' => $ns, 'result_count' => count($ns)), 'uid');
                 if (!$uids) {
                     exit('nickname is invalid');
                 }
                 $user_topic_list = " `uid` IN (" . jimplode($uids) . ") ";
             }
         }
         $tag_condition = '';
         if ('tag' == $sharelist['type']) {
             $tag = '';
             if ($sharelist['tag']) {
                 $tag = $sharelist['tag'];
             } else {
                 $tag = get_safe_code(jget('tag'));
             }
             if ($tag) {
                 $ts = explode('|', $tag);
                 $tagids = jtable('tag')->get_ids(array('name' => $ts, 'result_count' => count($ts)), 'id');
                 if (!$tagids) {
                     exit('tag is invalid');
                 }
                 $tids = jtable('topic_tag')->get_ids(array('tag_id' => $tagids, 'result_count' => $share['limit'], 'sql_order' => ' `dateline` DESC '), 'item_id');
                 if ($tids) {
                     $tag_condition = " `tid` IN (" . jimplode($tids) . ") ";
                     $topic_list = jlogic('topic')->Get($tids);
                 }
             }
         }
         $channel_condition = '';
         if ('channel' == $sharelist['type']) {
             $cids = array();
             if ($share['channel']['name']) {
                 $cname = $share['channel']['name'];
             } else {
                 $channel_id = jget('channel_id', 'int');
                 if ($channel_id > 0) {
                     $cids[$channel_id] = $channel_id;
                 } else {
                     $cname = jget('channel') ? jget('channel') : (jget('channel_name') ? jget('channel_name') : jget('ch_name'));
                 }
             }
             if ($cname) {
                 $ns = explode('|', $cname);
                 $cids = jtable('channel')->get_ids(array('ch_name' => $ns, 'result_count' => count($ns)), 'ch_id');
                 if (!$cids) {
                     exit('channel is invalid');
                 }
             }
             if ($cids) {
                 $condition = " `item`='channel' AND `item_id` IN(" . jimplode($cids) . ") ";
             }
         }
         if ('recommend' == $sharelist['type']) {
             $p = array('sql_order' => ' `dateline` DESC ', 'result_count' => $share['limit']);
             $its = array();
             $item = $share['recommend']['item'];
             if ($item) {
                 $its = $share['recommend']['item_id'];
             } else {
                 $item = jget('item', 'txt');
                 $its = jget('item_id', 'txt');
             }
             if (in_array($item, array('qun', 'channel')) && $its) {
                 ${$item_id . '_id'} = $its;
//.........这里部分代码省略.........

 function Getguest($ids)
 {
     $list = array();
     $uids = array();
     $guests = array();
     $ids = is_array($ids) ? $ids : array((int) $ids);
     $query = DB::query("SELECT iid,itemid,uid,description,type FROM " . DB::table('item_user') . " WHERE item = 'talk' AND itemid IN(" . jimplode($ids) . ")");
     while ($row = DB::fetch($query)) {
         $uids[] = $row['uid'];
         $guests[$row['itemid']][$row['uid']]['type'] = $row['type'];
         $guests[$row['itemid']][$row['uid']]['iid'] = $row['iid'];
         $guests[$row['itemid']][$row['uid']]['description'] = $row['description'];
     }
     $uids = array_unique($uids);
     $users = array();
     $userss = $this->TopicLogic->GetMember($uids, "`uid`,`ucuid`,`username`,`nickname`,`face`,`face_url`,`fans_count`,`validate`,`validate_category`");
     foreach ($userss as $val) {
         $users[$val['uid']] = $val;
     }
     unset($userss);
     foreach ($guests as $key => $val) {
         $guests_g = array();
         $guests_h = array();
         $guests_m = array();
         $guests_hg = array();
         $guests_a = array();
         foreach ($val as $k => $v) {
             $guests_a[$key][$k] = $guests[$key][$k]['type'];
             if ($guests[$key][$k]['type'] == 'guest') {
                 unset($guests[$key][$k]['type']);
                 $guests_g[$key][$k] = array_merge($users[$k], $guests[$key][$k]);
                 $guests_hg[$key][$k] = $users[$k]['nickname'];
             } elseif ($guests[$key][$k]['type'] == 'host') {
                 unset($guests[$key][$k]['type']);
                 $guests_h[$key][$k] = array_merge($users[$k], $guests[$key][$k]);
                 $guests_hg[$key][$k] = $users[$k]['nickname'];
             } elseif ($guests[$key][$k]['type'] == 'media') {
                 unset($guests[$key][$k]['type']);
                 $guests_m[$key][$k] = array_merge($users[$k], $guests[$key][$k]);
             }
         }
         $list[$key]['guest'] = $guests_g[$key];
         $list[$key]['host'] = $guests_h[$key];
         $list[$key]['media'] = $guests_m[$key];
         $list[$key]['host_guest'] = $guests_hg[$key];
         $list[$key]['all'] = $guests_a[$key];
     }
     return $list;
 }

 function getDigUser()
 {
     $dateline = time() - 7 * 24 * 3600;
     $sql = " SELECT `uid`,count(*) as num FROM `" . DB::table('topic_dig') . "` WHERE `dateline` > '{$dateline}' GROUP BY uid ORDER BY num DESC , dateline DESC  ";
     $query = DB::query($sql);
     $uid = array();
     while ($rs = DB::fetch($query)) {
         $uid[$rs['uid']] = $rs['uid'];
     }
     if ($uid) {
         $members = jlogic('topic')->GetMember(" WHERE `uid` in (" . jimplode($uid) . ") ORDER BY `fans_count` DESC limit 10 ", "`uid`,`ucuid`,`username`,`validate`,`validate_category`,`face`,`nickname`");
     }
     return $members;
 }

 function delete_ploy($ids)
 {
     $ids = (array) $ids;
     $where_sql = jimplode($ids);
     DB::query("DELETE FROM " . DB::table('qun_ploy') . " WHERE id IN({$where_sql})");
 }

 function delZone()
 {
     $area = $this->Get['area'];
     $city = $this->Get['city'];
     $fid = $this->Get['fid'];
     $id_arr = array();
     if ($fid) {
         $id_arr = $this->getNextId($fid);
         $id_arr[$fid] = $fid;
     }
     if ($id_arr) {
         $id_list = jimplode($id_arr);
         $this->DatabaseHandler->Query("delete from `" . TABLE_PREFIX . "common_district` where id in ({$id_list})");
     }
     $this->Messager("区域删除成功", "admin.php?mod=city&code=zone&area={$area}&city={$city}");
 }

 function TagSearch()
 {
     $per_page_num = 10;
     $topic_parent_disable = false;
     $query_link = 'index.php?mod=search&code=tag';
     $tag = trim(get_param('tag'));
     if ($tag) {
         $tag = get_safe_code($tag);
         $tag = $this->_filterKeyword($tag);
         $search_keyword = $tag;
         $_GET['highlight'] = $search_keyword;
         $cache_time = 600;
         $cache_key = "tag-search-{$tag}";
         if (false === ($topic_ids = cache_db('mget', $cache_key))) {
             $sql = "select `id` from `" . TABLE_PREFIX . "tag` WHERE " . build_like_query('`name`', $tag) . " ORDER BY `last_post` DESC LIMIT {$this->cache_ids_limit} ";
             $query = $this->DatabaseHandler->Query($sql);
             $tag_id = array();
             while (false != ($row = $query->GetRow())) {
                 $tag_id[$row['id']] = $row['id'];
             }
             $topic_ids = array();
             if ($tag_id) {
                 $sql = "SELECT `item_id` FROM `" . TABLE_PREFIX . "topic_tag` WHERE `tag_id` in(" . jimplode($tag_id) . ") ORDER BY `item_id` DESC LIMIT {$this->cache_ids_limit} ";
                 $query = $this->DatabaseHandler->Query($sql);
                 while (false != ($row = $query->GetRow())) {
                     $topic_ids[$row['item_id']] = $row['item_id'];
                 }
             }
             cache_db('mset', $cache_key, $topic_ids, $cache_time);
         }
         $topic_ids = filter_tids($topic_ids);
         if ($topic_ids) {
             $where = " `tid` in('" . implode("','", $topic_ids) . "') ";
         }
         $query_link .= "&tag=" . urlencode($tag);
     }
     if ($where) {
         $options = array('where' => $where, 'type' => get_topic_type(), 'order' => ' `dateline` desc ', 'page_url' => $query_link, 'perpage' => $per_page_num);
         $info = $this->TopicListLogic->get_data($options);
         $topic_list = array();
         $total_record = 0;
         if (!empty($info)) {
             $topic_list = $info['list'];
             $total_record = $info['count'];
             $page_arr = $info['page'];
         }
         $topic_list_count = 0;
         if ($topic_list) {
             $topic_list_count = count($topic_list);
             if (!$topic_parent_disable) {
                 $parent_list = $this->TopicLogic->GetParentTopic($topic_list);
             }
         }
     }
     $member = jsg_member_info(MEMBER_ID);
     if ($member['medal_id']) {
         $medal_list = $this->TopicLogic->GetMedal($member['medal_id'], $member['uid']);
     }
     $this->Title = "话题搜索";
     include template('social/search_list');
 }

 function index()
 {
     $view = empty($this->Get['view']) ? '' : trim($this->Get['view']);
     $filter = empty($this->Get['filter']) ? '' : trim($this->Get['filter']);
     $uid = empty($this->Get['uid']) ? 0 : intval($this->Get['uid']);
     $gets = array('mod' => 'vote', 'view' => $this->Get['view'], 'filter' => $this->Get['filter']);
     $page_url = 'index.php?' . url_implode($gets);
     $perpage = $this->ShowConfig['vote']['list'];
     $perpage = empty($perpage) ? 20 : $perpage;
     $tpl = 'vote/vote_index';
     $where_sql = " 1 ";
     switch ($view) {
         case 'new':
             $this->Title = '最新投票';
             $order_sql = ' ORDER BY dateline DESC ';
             break;
         case 'me':
             if ($uid && $uid != MEMBER_ID) {
                 $user_info = $this->TopicLogic->GetMember($uid);
                 $this->Title = $user_info['nickname'] . '发起的投票';
                 if (empty($user_info)) {
                     $this->Messager("当前页面不存在", 'index.php?mod=vote');
                 }
                 $tpl = 'vote/vote_me';
             } else {
                 $this->_check_login();
                 $this->Title = '我的投票';
                 $uid = MEMBER_ID;
             }
             if ($filter == 'joined') {
                 $vids = $this->VoteLogic->get_joined($uid);
                 if (!empty($vids)) {
                     $where_sql .= " AND `v`.`vid` IN(" . jimplode($vids) . ") ";
                 } else {
                     $where_sql = ' 0 ';
                 }
             } else {
                 if ($filter == 'new_update') {
                     jlogic('member')->clean_new_remind('vote_new', $uid);
                     $vids = $this->VoteLogic->get_joined($uid);
                     if (!empty($vids)) {
                         $where_sql .= " AND `v`.`vid` IN(" . jimplode($vids) . ") ";
                     }
                     $where_sql .= " OR `v`.`uid`='{$uid}' ";
                 } else {
                     $where_sql .= " AND `v`.`uid`='{$uid}' ";
                     $filter = 'created';
                 }
             }
             $order_sql = ' ORDER BY lastvote DESC ';
             break;
         case 'fllow':
             $this->_check_login();
             $this->Title = '我关注的人的投票';
             $buddyids = get_buddyids(MEMBER_ID);
             if ($filter == 'joined') {
                 $vids = $this->VoteLogic->get_joined($buddyids);
                 if (!empty($vids)) {
                     $where_sql .= " AND `v`.`vid` IN(" . jimplode($vids) . ") ";
                 } else {
                     $where_sql = ' 0 ';
                 }
             } else {
                 if (!empty($buddyids)) {
                     $where_sql .= " AND `v`.`uid` IN (" . jimplode($buddyids) . ") ";
                 } else {
                     $where_sql = ' 0 ';
                 }
                 $filter = 'created';
             }
             $order_sql = ' ORDER BY dateline DESC ';
             break;
         default:
             $this->Title = '最新参与投票';
             $view = 'newjoin';
             $where_sql .= " AND v.expiration >= '" . time() . "' AND v.lastvote > 0 ";
             $order_sql = ' ORDER BY v.lastvote DESC ';
             break;
     }
     if (!empty($filter)) {
         $filter_on[$filter] = 'class="v_on"';
     }
     $where_sql .= " AND v.verify = 1";
     $param = array('where' => $where_sql, 'order' => $order_sql, 'page' => true, 'perpage' => $perpage, 'page_url' => $page_url);
     $vote_info = $this->VoteLogic->find($param);
     $count = 0;
     $vote_list = array();
     $page_arr['html'] = '';
     $uid_ary = array();
     if (!empty($vote_info)) {
         $count = $vote_info['count'];
         $vote_list = $vote_info['vote_list'];
         $page_arr['html'] = $vote_info['page']['html'];
         $uid_ary = $vote_info['uids'];
     }
     if (!empty($uid_ary)) {
         $members = $this->TopicLogic->GetMember($uid_ary);
     }
     $this->Title .= ' | 微博投票';
     $active[$view] = 'class="tago"';
//.........这里部分代码省略.........