/** * サイドバナーを1件ランダムで取得 * * @return array c_banner */ function db_banner_get_side_banner($is_logined = false) { $sql = 'SELECT * FROM c_banner WHERE type = \'SIDE\''; if ($is_logined) { $sql .= ' AND is_hidden_after = 0'; } else { $sql .= ' AND is_hidden_before = 0'; } $sql .= db_order_by_rand(); return db_get_row($sql); }
function biz_getJoinGroup($id, $limit = null) { $list = array(); $sql = "SELECT * FROM biz_group_member"; $sql .= " WHERE c_member_id = ?"; $sql .= db_order_by_rand(); $params = array(intval($id)); if (!is_null($limit)) { $list = db_get_all_limit($sql, 0, intval($limit), $params); } else { $list = db_get_all($sql, $params); } foreach ($list as $key => $value) { $list[$key] += biz_getGroupData($value['biz_group_id']); $list[$key]['count'] = count(biz_getGroupMember($value['biz_group_id'])); } return $list; }
/** * お気に入りメンバーリスト */ function db_bookmark_member_list($c_member_id, $limit = 0) { static $is_recurred = false; //再帰処理中かどうかの判定フラグ if (!$is_recurred) { //function cacheのために再帰処理を行う $is_recurred = true; $funcargs = func_get_args(); $result = pne_cache_recursive_call(OPENPNE_FUNCTION_CACHE_LIFETIME_LONG, __FUNCTION__, $funcargs); $is_recurred = false; return $result; } $sql = 'SELECT c_member_id_to AS c_member_id FROM c_bookmark' . ' WHERE c_member_id_from = ?' . db_order_by_rand(); $params = array(intval($c_member_id)); if ($limit) { $result = db_get_all_limit($sql, 0, intval($limit), $params); } else { $result = db_get_all($sql, $params); } foreach ($result as $key => $value) { $result[$key] = db_member_c_member4c_member_id_LIGHT($value['c_member_id']); $result[$key]['friend_count'] = db_friend_count_friends($value['c_member_id']); } return $result; }
/** * 友達ランダム50人 */ function db_friend_ktai_c_friend_list_random4c_member_id($c_member_id) { $sql = "SELECT cf.c_member_id_to, cm.nickname"; $sql .= " FROM c_friend AS cf, c_member AS cm"; $sql .= " WHERE cf.c_member_id_from = ?" . " AND cf.c_member_id_to = cm.c_member_id"; $sql .= db_order_by_rand(); $params = array(intval($c_member_id)); return db_get_all_limit($sql, 0, 50, $params); }
/** * Myフレンドから指定コミュに参加していない人をランダムに選ぶ */ function db_commu_c_friend_list_random4c_member_id4c_commu_id($c_member_id, $c_commu_id, $limit) { //友達リスト $friend_list = db_friend_c_member_id_list($c_member_id); //参加者リスト $sql = "SELECT c_member_id FROM c_commu_member WHERE c_commu_id = ?"; $params = array(intval($c_commu_id)); $member_list = db_get_col($sql, $params); //友達リストから参加者リストを引く $result = array_diff($friend_list, $member_list); if (!$result) { return array(); } $result = implode(',', array_map('intval', $result)); $sql = 'SELECT c_member_id, nickname FROM c_member' . ' WHERE c_member_id IN ( ' . $result . ') ' . db_order_by_rand(); return db_get_all_limit($sql, 0, $limit); }