헐랭이님의 다기능쪽지 질문

헐랭이님의 다기능쪽지 질문 정보

헐랭이님의 다기능쪽지 질문

본문

안녕하세요~

'헐랭이님의 다기능쪽지'를 쓰고 있는데요.

혼자 해결해보려고 이리저리 머리 굴려보다가

질문 올립니다.

'친구등록/관리'를 클릭하고 회원검색을 하면

검색한 내용은 잘 나옵니다.

그런데 그 다음 페이지로 넘어가기 위해서 페이지번호를 누르면

다시 전체회원이 나와버려요.

검색한 내용에 대한것만 출력 되는 것이 아니라

두번째 페이지부터는 전체회원으로 다시 나와버립니다.

코드를 올릴테니 한번만 봐주세요 고수님들~

아직 배우는 단계라서 뭐가뭔지 모르겠습니다..ㅜ.ㅜ

어디서 고쳐야할지는 알겠는데 어찌 고쳐야 할지를 모르겠어요~

아참 그리고...

헐랭이님~ 이글을 보시면 하나만 더 질문드릴게요~

'친구등록/관리' 누르면 전체회원이 다 나와버리는데요.

본인을 추천한 사람만 초기화면에서 출력되게 할 수는 없을까요?

다른 고수분들도 아시면 좀 부탁드리겠습니다.

항상 여러 그누고수분들 고맙게 생각하고 있습니다.

언제 다 모셔서 맥주라도 쏘고 싶네요 ^^;

member_list.php 입니다.

<?
$g4_path = "../../..";
include_once ("$g4_path/common.php");
$g4[title] = "회원목록";
include_once("$g4[path]/head.sub.php");

if (!$member[mb_id]) {
alert_close("로그인 하십시오.");
}
$member_skin_path = "$g4[path]/skin/member/$config[cf_member_skin]";

if ($smenu == "b")
{
    $recv_img = "off";
    $send_img = "on";
    $send_imgc = "off";
}
else if ($smenu == "c")
{
    $recv_img = "off";
    $send_img = "off";
    $send_imgc = "on";
}
else if ($smenu == "d")
{
    $recv_img = "off";
    $send_img = "off";
    $send_imgc = "off";
}
else
{
    $recv_img = "on";
    $send_img = "off";
    $send_imgc = "off";
}

if ($smenu =="b"){
$sql = " select * from $g4[member_table] a left join g4_memo_friend b on (b.mf_id = a.mb_id) where my_id = '$member[mb_id]' ";
}
else if ($smenu =="c")
{
$sql = " select * from $g4[member_table] a left join g4_memo_friend b on (b.my_id = a.mb_id) where mf_id = '$member[mb_id]' ";
}
else if ($smenu =="d")
{
$sql = " select a.mb_id, b.mb_id, b.mb_nick, b.mb_name, b.mb_email, b.mb_homepage, b.mb_open, b.mb_point, b.mb_today_login, a.lo_ip, a.lo_location, a.lo_url from $g4[login_table] a left join $g4[member_table] b on (a.mb_id = b.mb_id) where a.mb_id <> '$config[cf_admin]' ";
}
else
{
$sql_common = " from $g4[member_table]";
$sql_search = " where (1) ";
if ($stx) {
    $sql_search .= " and ( ";
    switch ($sfl) {
        case "mb_point" :
            $sql_search .= " ($sfl >= '$stx') ";
            break;
        case "mb_level" :
            $sql_search .= " ($sfl = '$stx') ";
            break;
        default :
            $sql_search .= " ($sfl like '$stx%') ";
            break;
    }
    $sql_search .= " ) ";
}

if ($is_admin == 'group')
$sql_search .= " and mb_level = '$member[mb_level]' ";

if (!$sst) {
$sst = "mb_datetime";
$sod = "desc";
}

$sql_order = " order by $sst $sod ";
}

if ($smenu =="b"){
$sql = " select count(mb_id) as cnt from $g4[member_table] a left join g4_memo_friend b on (b.mf_id = a.mb_id) where my_id = '$member[mb_id]' ";
}
else if ($smenu =="c"){
$sql = " select count(mb_id) as cnt from $g4[member_table] a left join g4_memo_friend b on (b.my_id = a.mb_id) where mf_id = '$member[mb_id]' ";
}
else if ($smenu =="d"){
$sql = " select count(*) as cnt from $g4[login_table] a left join $g4[member_table] b on (a.mb_id = b.mb_id) where b.mb_id <> '$config[cf_admin]' ";
}
else
{
$sql = " select count(*) as cnt
        $sql_common
        $sql_search
        $sql_order ";
}

$row = sql_fetch($sql);
$total_count = $row[cnt];
/*
echo"<script language=\"javascript\">
window.alert(\"총갯수: $total_count \");
</script>";
*/
$rows = $config[cf_page_rows];
$total_page = ceil($total_count / $rows); // 전체 페이지 계산
if (!$page) $page = 1; // 페이지가 없으면 첫 페이지 (1 페이지)
$from_record = ($page - 1) * $rows; // 시작 열을 구함

if ($smenu =="b"){
$sql = " select * from $g4[member_table] a left join g4_memo_friend b on (b.mf_id = a.mb_id) where my_id = '$member[mb_id]' order by mf_id desc limit $from_record, $rows ";
}
else if ($smenu =="c")
{
$sql = " select * from $g4[member_table] a left join g4_memo_friend b on (b.my_id = a.mb_id) where mf_id = '$member[mb_id]' order by my_id desc limit $from_record, $rows ";
}
else if ($smenu =="d")
{
$sql = " select a.mb_id, b.mb_nick, b.mb_name, b.mb_email, b.mb_homepage, b.mb_open, b.mb_point, b.mb_today_login from $g4[login_table] a left join $g4[member_table] b on (a.mb_id = b.mb_id) where b.mb_id <> '$config[cf_admin]' order by mb_id desc limit $from_record, $rows ";
}
else
{
$sql = " select *
          $sql_common
          $sql_search
          $sql_order
          limit $from_record, $rows ";
}
$result = sql_query($sql);

$listall = "<a href='$_SERVER[PHP_SELF]'><b>[처음]</b></a>";

// 내가 선택한 친구들
function memo_friend($my_id, $mf_id, $mf_name, $page) {
global $g4, $member_skin_path;

$sql_where = "where mf_id = '$mf_id' and my_id = '$my_id'";

$sql = " select * from g4_memo_friend
$sql_where
order by my_id";

$row3 = sql_fetch($sql);

if ($row3[mf_id] == $mf_id) {
// 삭제표시
if ($mf_id) {
$f_plus = "<a href=\"javascript:win_memo('".$g4[bbs_path]."/memo_form.php?me_recv_mb_id=$mf_id');\"><img src=\"$member_skin_path/img/icon_formmail.gif\" title=\"내가추가한 친구\" border=0></a> <a href=\"javascript:del('$member_skin_path/memo_frmember.php?w=d&mf_id=$mf_id&my_id=$my_id&smenu=$smenu&page=$page');\" title=\"내친구 목록에서 제외하기\">삭제</a>";
};
} else {
$f_plus = "<a href=\"$member_skin_path/memo_frmember.php?w=u&mf_id=$mf_id&mf_name=$mf_name&my_id=$my_id&smenu=$smenu&page=$page\" title=\"내친구로 등록하기\">추가</a>";
}

return $f_plus;
}

// 나를 친구로 선택한 내팬들
function memosm_friend($my_id, $mf_id, $mf_name, $page) {
global $g4, $member_skin_path;

$sql_wheres = "where mf_id = '$mf_id' and my_id = '$my_id'";

$sqls = " select * from g4_memo_friend
$sql_wheres
order by my_id";

$rows3 = sql_fetch($sqls);

if ($rows3[mf_id] == $mf_id) {
$fs_plus = "<a onclick=\"alert('{$rows3[my_id]}({$mf_name}) 님이 나를 친구로 추가한 팬 입니다.')\" style=\"cursor: pointer;\" title=\"{$rows3[my_id]}({$mf_name}) 님이 나를친구로 추가한 팬\"><img src=\"$member_skin_path/img/my_mf.gif\" border=0></a>";
} else {
$fs_plus = "-";
}

return $fs_plus;
}
// 내가 맺은 친구들
$sql = " select count(*) as cnt from g4_memo_friend
where my_id = '$member[mb_id]'
order by mf_id";
$row = sql_fetch($sql);
$memo_friend_count = $row[cnt];

// 나를 맺은 친구 회원수
$sql2 = " select count(*) as cnt from g4_memo_friend
where mf_id = '$member[mb_id]'
order by my_id";
$row2 = sql_fetch($sql2);
$memo_friend_count2 = $row2[cnt];
$sql3 = " select count(*) as cnt from $g4[login_table] a left join $g4[member_table] b on (a.mb_id = b.mb_id) where b.mb_id <> '$config[cf_admin]' ";
$row3 = sql_fetch($sql3);
$memo_friend_count3 = $row3[cnt];

?>
<script>
//resizeTo('420','600');
</script>
<script language="javascript" src="<?=$g4[path]?>/js/sideview.js"></script>

<tr class='subject subjectbg ht' align=center>
    <td><?=subject_sort_link('mb_id')?>회원아이디</a></td>
<td>상태</td>
    <td><?=subject_sort_link('mb_nick')?>별 명</a></td>
    <td><?=subject_sort_link('mb_today_login', '', 'desc')?>최종접속</a></td>
    <td><a href='<?=$member_skin_path?>/member_list.php?smenu=b'>친구</a></td>
<td><a href='<?=$member_skin_path?>/member_list.php?smenu=c'>팬들</a></td>
</tr>

<?
for ($i=0; $row=sql_fetch_array($result); $i++) {
if ($row[mb_id]) {
$k = $i + 1;
$sql2 = "select mb_id from $g4[login_table] where mb_id='$row[mb_id]'";
$resultm = sql_fetch($sql2);
if($resultm[mb_id])
{
$member_online ="<font color='red'><a onclick=\"alert('$row[mb_nick] 님은 현재 접속중 입니다.')\" style=\"cursor: pointer;\" title=\"접속중\">online</a></font>";
}
else
{
$member_online ="<font color='#666666'><a onclick=\"alert('$row[mb_nick] 님은 미접속 상태 입니다.')\" style=\"cursor: pointer;\" title=\"미접속\">off</a></font>";
}
// 접근가능한 그룹수
    $sql2 = " select count(*) as cnt from $g4[group_member_table] where mb_id = '$row[mb_id]' ";
    $row2 = sql_fetch($sql2);
    $group = "";
    if ($row2[cnt])
        $group = "<a href='$g4[admin_path]/boardgroupmember_form.php?mb_id=$row[mb_id]'>$row2[cnt]</a>";
$leave_date = $row[mb_leave_date] ? $row[mb_leave_date] : date("Ymd", $g4[server_time]);
    $intercept_date = $row[mb_intercept_date] ? $row[mb_intercept_date] : date("Ymd", $g4[server_time]);
    $mb_id = get_sideview($row[mb_id], $row[mb_id], $row[mb_email], $row[mb_homepage]);
      $mb_nick = get_sideview($row[mb_id], $row[mb_nick], $row[mb_email], $row[mb_homepage]);
    $list = $i%2;
    echo "
    <input type=hidden name=mb_id[$i] value='$row[mb_id]'>
    <tr class='ht list' bgcolor='#ffffff' height='20' align='center' onMouseOver=this.style.backgroundColor='#eeeeee' onMouseOut=this.style.backgroundColor=''>
        <td width='90' align='center'>$mb_id</td>
    <td width='35' align='center'>$member_online</font></td>
        <td width='90' align='center'>$mb_nick</td>
        <td>".substr($row[mb_today_login],2,8)."</td>
        <td width='50' align='center'>".memo_friend($member[mb_id], $row[mb_id], $row[mb_nick], $qstr)."</td>
    <td width='30' align='center'>".memosm_friend($row[mb_id], $member[mb_id], $row[mb_nick], $qstr)."</td>
        $s_mod $s_del $s_grp
    </tr>";
}
}
if ($i == 0)
echo "<tr><td colspan='14' align=center height=100 class=contentbg>자료가 없습니다.</td></tr>";
echo "</table>";

$pagelist = get_paging($config[cf_write_pages], $page, $total_page, "?smenu=$smenu&page=");
echo "<table width=100% cellpadding=3 cellspacing=1>";
echo "<tr><td width=100% align=center>$pagelist</td></tr><tr></table>\n";
?>
<table width="100%"><tr><td align="center">
<a href="javascript:cancel()"><img src="<?=$member_skin_path?>/img/btn_close.gif" border=0 ></a>
</td></tr></table>
<?
if ($stx)
echo "<script language='javascript'>document.fsearch.sfl.value = '$sfl';</script>\n";
?>
</form>
<script language="JavaScript">

</script>
<script language="javascript" src="<?=$g4[path]?>/js/common.js"></script>
<?
include_once("$g4[path]/tail.sub.php");
?>