<script language=JavaScript>
function bluring(){
if(event.srcElement.tagName=="A"||event.srcElement.tagName=="IMG") document.body.focus();
}
document.onfocusin=bluring;
</script>

 

 

 

<?
// 라이브러리 함수 파일 인크루드
 require "lib.php";
 
// DB 연결
 $connect=dbConn();

// 멤버정보 구하기
 $member=member_info();

 if(!$member[no]) Error("로그인된 회원만이 사용할수 있습니다","window.close");

 if(!$page&&!$status) $status=1;

// 그룹데이타 읽어오기;;
 $group_data=mysql_fetch_array(mysql_query("select * from $group_table where no='$member[group_no]'"));

// 검색어 처리;;
 if($keyword) {
  if(!$status) $s_que=" where user_id like '%$keyword%' or name like '%$keyword%' ";
 }

// 전체 회원의 수
 $temp2=mysql_fetch_array(mysql_query("select count(*) from $member_table  $s_que"));
 $total_member=$temp2[0];

 if($status) {
  $_str = trim(zReadFile("data/now_member_connect.php"));
  if($_str) {
   $_str = str_replace("<?/*","",$_str);
   $_str = str_replace("*/?>","",$_str);
   $_connector = explode(":",$_str);
   
   $total = count($_connector);
  }
 } else $total=$total_member;

// 페이지 계산
 $page_num=10;
 $total_page=(int)(($total-1)/$page_num)+1; // 전체 페이지 구함

 if(!$page) $page=1;
 if($page>$total_page) $page=1; // 페이지가 전체 페이지보다 크면 페이지 번호 바꿈
 
 $start_num=($page-1)*$page_num; // 페이지 수에 따른 출력시 첫번째가 될 글의 번호 구함

 

// 데이타 뽑아오는 부분

// 오프라인 멤버
 if(!$status) {
  $que="select * from $member_table $s_que order by no desc limit $start_num,$page_num";
  $result=mysql_query($que) or Error(mysql_error());
// 온라인 멤버
 } else {
  $endnum = $start_num + $page_num;
  if($endnum>$total) $endnum=$total;
  unset($s_que);
  for($i=$start_num;$i<$endnum;$i++) {
   $member_no = substr($_connector[$i],12);
   if($s_que) $s_que .= " or no = '$member_no' "; else $s_que = " where no = '$member_no' ";
  }
  $que = "select * from $member_table $s_que";
  $result=mysql_query($que) or Error(mysql_error());

 }

// 페이지 계산  $print_page 라는 변수에 저장
 $print_page="";
 $show_page_num=10;
 $start_page=(int)(($page-1)/$show_page_num)*$show_page_num;
 $i=1;

 if($page>$show_page_num) {
  $prev_page=$start_page;
  $print_page="<a href=$PHP_SELF?page=$prev_page&status=$status&keyword=$keyword>[Prev]</a> ";
  $print_page.="<a href=$PHP_SELF?page=1&status=$status&keyword=$keyword>[1]</a>..";
 }
 
 while($i+$start_page<=$total_page&&$i<=$show_page_num) {
  $move_page=$i+$start_page;
  if($page==$move_page) $print_page.=" <b>$move_page</b> ";
  else $print_page.="<a href=$PHP_SELF?page=$move_page&status=$status&keyword=$keyword>[$move_page]</a>";
  $i++;
 }

 if($total_page>$move_page) {
  $next_page=$move_page+1;
  $print_page.="..<a href=$PHP_SELF?page=$total_page&status=$status&keyword=$keyword>[$total_page]</a>";
  $print_page.=" <a href=$PHP_SELF?page=$next_page&status=$status&keyword=$keyword>[Next]</a>";
 }
  
 head("bgcolor=white");
?>

<style type='text/css'>
body {color:#666666}

A:link    {color:666666;text-decoration:none;}
A:visited {color:666666;text-decoration:none;}
A:active  {color:666666;text-decoration:none;}
A:hover  {color:333333;text-decoration:none;}

.input {border:1px #dddddd solid;height:18px;font-family:tahoma;font-size:9pt;color:#666666;background-color:#fafafa;}

</style>

<table width="100%" border="0" cellspacing="0" cellpadding="0" align="center">
<tr>
    <td align=center align="100%"  height="10" >     
            </td>
  </tr>
  <tr>
    <td align="center"><img src="memo_images/memo_topright_user.gif" width="400" height="50" border="0"></td>
  </tr>
</table>

<table width="100%" border="0" cellspacing="0" cellpadding="5">
  <tr>
 <td>&nbsp;&nbsp;&nbsp;<a href=member_memo.php><img src=memo_images/vi_B_inbox.gif border=0></a> <a href=member_memo2.php><img src=memo_images/vi_B_sent.gif border=0></a> <a href=member_memo3.php><img src=memo_images/vi_B_write.gif border=0></a></td>
    <td align=right><font style=font-family:Tahoma;font-size:7pt;color:#666666>All Members : <b><?=$total?></b></font>&nbsp;&nbsp;&nbsp;&nbsp;</td>
  </tr>
</table>

<table width="100%" border="0" cellspacing="0" cellpadding="0" align="center">
  <tr>
    <td width="16"></td>
    <td >

<script>
 function check_status()
 {
  if(document.list.status.checked) {
  if(document.list.keyword.value) {
   alert("온라인 상태에서는 검색할수가 없습니다");
   return false;
  }
 }
 return true;
 }

</script>

<TABLE><TR><TD HEIGHT=15></TD></TR></TABLE>

<table border=0 cellspacing=0 cellpadding=0 width=100%>
<form method=post action=<?=$PHP_SELF?> name=list onsubmit="return check_status()">
<input type=hidden name=page value=<?=$page?>>
<tr>
 <td colspan=4 height=1 bgcolor=#eeeeee></td>
</tr>
<tr align=center height=15>
  <td width=30% style="border-width:1px; border-color:rgb(231,228,228);" height="25" bgcolor="white">
                            <p align="center"><b><font style=font-family:Tahoma;font-size:7pt;color:#666666>LEVEL</font><b></td>
  <td width=30% style="border-width:1px; border-color:rgb(231,228,228);" height="25" bgcolor="white">
                            <p align="center"><b><font style=font-family:Tahoma;font-size:7pt;color:#666666>ID</font><b></td>
  <td width=25% style="border-width:1px; border-color:rgb(231,228,228);" height="25" bgcolor="white">
                            <p align="center"><b><font style=font-family:Tahoma;font-size:7pt;color:#666666>NAME</font><b></td>
  <?if($status){?><td width=15% style="border-width:1px; border-color:rgb(231,228,228);" height="25" bgcolor="white">
                            <p align="center"><b><font style=font-family:Tahoma;font-size:7pt;color:#666666>STATUS</font><b></td>
                     
<?}?>
</tr>

<?
// 출력
 $loop_number=$total-($page-1)*$page_num;
 while($data=mysql_fetch_array($result)) {
  $name=stripslashes($data[name]);
  
  $temp_name = get_private_icon($data[no], "2");
  if($temp_name) $name="<img src='$temp_name' border=0 align=absmiddle>";
  $temp_name = get_private_icon($data[no], "1");
  if($temp_name) $name="<img src='$temp_name' border=0 align=absmiddle>&nbsp;".$name;

  
  $user_id=stripslashes($data[user_id]);
  //$check=mysql_fetch_array(mysql_query("select count(*) from $now_table where user_id='$data[user_id]'"));
  if($check[0]) $stat="<img src=images/memo_online.gif>";
  else $stat="<img src=images/memo_offline.gif>";
  if($data[is_admin]==1) $kind="<font color=#666666 style=font-family:Tahoma;font-size:8pt;><b>Super Administrator</b>($data[level])</font>";
  elseif($data[is_admin]==2) $kind="<font color=#666666 style=font-family:Tahoma;font-size:8pt;><b>Group Administrator</b>($data[level])</font>";
  else $kind="<font style=font-family:Tahoma;font-size:8pt;><b>Member</b>($data[level])</font>";

  echo"
        <tr>
          <td colspan=5 bgcolor=#f4f4f4 align=center><img src=images/t.gif width=10 height=1></td>
        </tr>
   <tr align=center height=23 onMouseOver=this.style.backgroundColor=\"#Fafafa\" onMouseOut=this.style.backgroundColor=\"\" style=cursor:hand; onclick=location.href=\"javascript:void(window.open('+ '+ 'view_info.php?member_no=$data[no]','view_info','width=400,height=500,toolbar=no,scrollbars=yes'))\">
      <td style='word-break:break-all;'>$kind</td>
      <td style='word-break:break-all;'+ '><img src=images/t.gif width=10 height=3><br><a href=javascript:void(window.open('view_info.php?member_no=$data[no]','view_info','width=400,height=500,toolbar=no,scrollbars=yes'))>$user_id</a></td>
      <td style='word-break:break-all;'><img src=images/t.gif width=10 height=3><br>$name</td>";
      if($status) echo"<td style='word-break:break-all;'><img src=images/memo_online.gif></td>";
   echo"
   </tr>
     ";
   $loop_number--;
 }
?>
<tr>
 <td colspan=4 height=1 bgcolor=#eeeeee></td>
</tr>
<tr>
  <td colspan=5 bgcolor="white" align=center height="23" style="border-style:none;"><span style="font-size:1pt;">&nbsp;</span></td>
</tr>

<tr align=center>
<? $checked[$status]="checked"; ?>
  <td colspan=5 height="42" valign="bottom" bgcolor="white" width="100%">
                         
     <table border=0 cellpadding=0 cellspacing=0 style="border:1px #eeeeee solid;" align=center>
     <tr>
  <td height=3 colspan=5></td>
 </tr>
  <tr>
  <td><input type=checkbox value=1 name=status <?=$checked[1]?>></td>
     <td><b><font style=font-family:Tahoma;font-size:7pt;color:#666666>ONLINE</font><b>&nbsp;&nbsp;</td>
     <td>
  <input type=text name=keyword value="<?=$keyword?>" size=20 style=font-size:9pt;width:140px;height:18px;border-color:#eeeeee;background-color:#fafafa; class=input></td>    
     <td><INPUT TYPE="submit" class=input value=Search style=color:#FFFFFF;border-color:#666666;background-color:#666666;font-size:7pt;font-family:Tahoma;height:18px;>&nbsp;&nbsp;</td>
     <td><a href=<?=$PHP_SELF?>?page=<?=$page?>><b><font style=font-family:Tahoma;font-size:7pt;color:#666666>CANCLE</font><b></a>&nbsp;</td>
     </tr>
  <tr>
  <td height=3 colspan=5></td>
 </tr>
     </table>
 
                           
  </td>
</tr>
</form>
</table>
    </td>
    <td width="17">&nbsp;</td>
  </tr> 
</table>

<p align="center" style="line-height:100%; margin-top:0; margin-bottom:0;">&nbsp;</p>
<table width="100%" border="0" cellspacing="0" cellpadding="5" align="center">
  <tr>
    <td>&nbsp;&nbsp;&nbsp;<font style=font-family:Tahoma;font-size:7pt;color:#666666><?=$print_page?></font></td>
    <td align="right">
     
            <p style="margin-right:20;" align="right"><a href=JavaScript:window.close()><img src="memo_images/memo_close_m.gif" width="50" height="30" border="0"></a> </td>
  </tr>
</table>

<?
// MySQL 닫기
 if($connect) mysql_close($connect);

 foot();
?>

 

 

 

현재접속자 누르면

 

이렇게 나와요..

 

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ');/*200911030115189' or no = '1'' at line 1

 

호스팅업체에선 원래 제로보드가 4.0x인데 제껀 버전이 5.x라서 그렇다고 하더군요..

어떻게 해야하는걸까요?;ㅁ;..

누가 좀 도와주세요..