<?
include_once("./_common.php");
if (!$is_admin =="super"){ 
 alert_close("ÃÖ°í °ü¸®ÀÚ ¿µ¿ª ÀÔ´Ï´Ù."); 
}
/* ¸¸µçÀÌ : Çæ·©ÀÌ / http://avaschool.net / kcho07@msn.com */
?>
<?
if ($sv =="yes") { 
if ($ms =="excel"){
   $g4[title] = "¿¢¼¿ ¹®¼­ ´Ù¿î·Îµå";
   header( "Content-type: application/vnd.ms-excel" ); 
   header( "Content-Disposition: attachment; filename=g4_member.xls" ); 
  } else if ($ms =="power"){ 
   $g4[title] = "ÆÄ¿öÆ÷ÀÎÆ® ¹®¼­ ´Ù¿î·Îµå";
   header( "Content-type: application/vnd.ms-powerpoint" ); 
   header( "Content-Disposition: attachment; filename=g4_member.ppt" ); 
  } else if ($ms =="word"){ 
   $g4[title] = "¿öµå ¹®¼­ ´Ù¿î·Îµå";
   header( "Content-type: application/vnd.ms-word" ); 
   header( "Content-Disposition: attachment; filename=g4_member.doc" ); 
  } else if ($ms =="memo"){ 
   $g4[title] = "¸Þ¸ð ¹®¼­ ´Ù¿î·Îµå";
   header( "Content-type: application/vnd.ms-notepad" ); 
   header( "Content-Disposition: attachment; filename=g4_member.txt" ); 
  } else {
   $g4[title] = "¿¢¼¿ ¹®¼­ ´Ù¿î·Îµå";
   header( "Content-type: application/vnd.ms-excel" ); 
   header( "Content-Disposition: attachment; filename=g4_member.xls" );
  }
   header( "Content-Description: PHP Generated Data" ); 
// ´Ù¿î·Îµå ¸ðµå¿¡¼­ÀÇ  ³Ñ¾î¿Â °ª¿¡ ´ëÇÑÃ³¸®
if($code =="1"){
$m_que = "$g4[member_table] order by mb_id desc";
}else if($code =="2"){
$m_que = "$g4[member_table] order by mb_id asc";
}else if($code =="3"){
$m_que = "$g4[member_table] order by mb_level desc";
}else if($code =="4"){
$m_que = "$g4[member_table] order by mb_level asc";
}else if($code =="5"){
$m_que = "$g4[member_table] order by mb_point desc";
}else if($code =="6"){
$m_que = "$g4[member_table] order by mb_point asc";
}else if($code =="7"){
$m_que = "$g4[member_table] order by mb_datetime desc";
}else if($code =="8"){
$m_que = "$g4[member_table] order by mb_datetime asc";
}else if($code =="9"){
if (!$name) {
$m_que = "$g4[member_table] order by mb_level desc";
} else {
$m_que = "$g4[member_table] where mb_level ='$name'";
}
}else if($code =="10"){
if (!$name) {
$m_que = "$g4[member_table] order by mb_level asc";
} else {
$m_que = "$g4[member_table] where mb_level <= $name";
}
}else if($code =="11"){
if (!$name) {
$m_que = "$g4[member_table] order by mb_level desc";
} else {
$m_que = "$g4[member_table] where mb_level >= $name";
}
}else if($code =="12"){
$m_que = "$g4[member_table] order by mb_today_login desc";
}else if($code =="13"){
$m_que = "$g4[member_table] order by mb_today_login asc";
}else if($code =="14"){
$m_que = "$g4[member_table] order by mb_nick_date desc";
}else if($code =="15"){
$m_que = "$g4[member_table] order by mb_nick_date asc";
}else if($code =="16"){
$m_que = "$g4[member_table] where mb_sex ='M'";
}else if($code =="17"){
$m_que = "$g4[member_table] where mb_sex ='F'";
}else if($code =="18"){
$m_que = "$g4[member_table] order by mb_birth desc";
}else if($code =="19"){
$m_que = "$g4[member_table] order by mb_birth asc";
}else if($code =="20"){
$m_que = "$g4[member_table] where mb_mailling ='1'";
}else if($code =="21"){
$m_que = "$g4[member_table] where mb_mailling ='0'";
}else if($code =="22"){
$m_que = "$g4[member_table] where mb_sms ='1'";
}else if($code =="23"){
$m_que = "$g4[member_table] where mb_sms ='0'";
}else if($code =="24"){
$m_que = "$g4[member_table] where mb_open ='1'";
}else if($code =="25"){
$m_que = "$g4[member_table] where mb_open ='0'";
}else if($code =="26"){
$m_que = "$g4[member_table] where mb_id like '%$name%'";
}else if($code =="27"){
$m_que = "$g4[member_table] where mb_name like '%$name%'";
}else if($code =="28"){
$m_que = "$g4[member_table] where mb_nick like '%$name%'";
} else {
$m_que = "$g4[member_table] order by mb_id desc";
}
$result = mysql_query("select * from $m_que");
$temp = mysql_fetch_array(mysql_query("select count(*) from $g4[member_table] $m_que"));
 $number=$temp[0]
?>
<html>
<head>
<title><?=$g4[title]?> -ÆäÀÌÁö-</title>
<meta http-equiv="Content-Type" content="text/html; charset=<?=$ks?>">
</head>
<body>
     <table width=100% cellpadding=0 cellspacing=0 border=1>
       <tr align=center height=25 bgcolor=999999>
	     <td style=font-weight:bold;>no</td>
         <td style=font-weight:bold;>id¸í</td>
         <td style=font-weight:bold;>ÀÌ¸§</td>
         <td style=font-weight:bold;>´Ð³Û</td>
         <td style=font-weight:bold;>·¹º§</td>
         <td style=font-weight:bold;>Æ÷ÀÎÆ®</td>
         <td style=font-weight:bold;>°¡ÀÔÀÏ</td>
         <td style=font-weight:bold;>ÃÖÁ¾Á¤º¸</td>
         <td style=font-weight:bold;>ÀÌ¸á</td>
         <td style=font-weight:bold;>È¨ÆäÀÌÁö</td>
         <td style=font-weight:bold;>¼ºº°</td>
         <td style=font-weight:bold;>»ýÀÏ</td>
         <td style=font-weight:bold;>ÀüÈ­</td>
         <td style=font-weight:bold;>ÈÞ´ëÆù</td>
         <td style=font-weight:bold;>¸ÞÀÏ¸µ</td>
         <td style=font-weight:bold;>¹®ÀÚ¼ö½Å</td>
         <td style=font-weight:bold;>Á¤º¸°ø°³</td>
         <td style=font-weight:bold;>ÃÖ±Ù·Î±×ÀÎ</td>
         <td style=font-weight:bold;>ÁÖ¼Ò</td>
       </tr>
<?
while($data=mysql_fetch_array($result))
  {
if ($data[mb_sex] =="M") { $mb_sex ="³²ÀÚ"; } else if ($data[mb_sex] =="F"){ $mb_sex ="¿©ÀÚ"; }
if ($data[mb_mailling] =="1") { $mb_mailling ="¹ÞÀ½"; } else if ($data[mb_mailling] =="0"){ $mb_mailling ="¾È¹ÞÀ½"; }
if ($data[mb_sms] =="1") { $mb_sms  ="¹ÞÀ½"; } else if ($data[mb_sms] =="0"){ $mb_sms ="¾È¹ÞÀ½"; }
if ($data[mb_open] =="1") { $mb_open  ="°ø°³"; } else if ($data[mb_open] =="0"){ $mb_open ="ºñ°ø°³"; }
   echo"
        <tr align=center height=24>
		   <td>$number</td>
           <td>$data[mb_id]</td>
           <td>$data[mb_name]</td>
		   <td>$data[mb_nick]</td>
           <td>$data[mb_level]</td>
           <td>$data[mb_point]</td>
           <td>$data[mb_datetime]</td>
           <td>$data[mb_nick_date]</td>
           <td>$data[mb_email]</td>
           <td>$data[mb_homepage]</td>
           <td>$mb_sex</td>
           <td>$data[mb_birth]</td>
           <td>$data[mb_tel]</td>
           <td>$data[mb_hp]</td>
           <td>$mb_mailling</td>
		   <td>$mb_sms</td>
           <td>$mb_open</td>
           <td>$data[mb_today_login]</td>
           <td>$data[mb_addr1]</td>
        </tr>
		";  
   $number--;
   }
echo "
 </table>
 </body>
</html>";
 }
?>


<html>
<head>
<title><?=$g4[title]?> -ÆäÀÌÁö-</title>
<? if (!$ks) { ?>
<meta http-equiv="Content-Type" content="text/html; charset=euc-kr">
<? } else { ?>
<meta http-equiv="Content-Type" content="text/html; charset=<?=$ks?>">
<? } ?>
</head>
<body>
<form name=search_member method=get action=<?=$PHP_SELF?> style="margin:0px;">	
 <table width=850 cellpadding=1 cellspacing=1 border=1>
 <tr height=20 bgcolor=eeeeee>				
<td>
  &nbsp;<select name='sv'>
<option value='no'>À¥¿¡¼­¹Ù·Îº¸±â</option>
<option value='yes'>´Ù¿î·Îµå¹Þ±â</option>
</select>

<select name='ks'>
<option value='euc-kr'>¾ð¾î¼±ÅÃ</option>
<option value='euc-kr'>ÇÑ±¹¾î</option>
<option value='utf-8'>À¯´ÏÄÚµå</option>
<option value='euc-jp'>ÀÏº»¾î</option>
<option value='gb2312'>Áß±¹¾î</option>
<option value='iso-8859-1'>¿µ¾î</option>
</select>

<select name='ms'>
<option value=''>ÆÄÀÏ¼±ÅÃ</option>
<option value='excel'>¿¢¼¿ÆÄÀÏ</option>
<option value='power'>ÆÄ¿öÆ÷ÀÎÆ®</option>
<option value='word'>¿öµå¹®¼­</option>
<option value='memo'>¿öµåÆÐµå</option>
</select>

<select name='code'>
<option value='1'>ºÐ·ù(Á¤·Ä)¼±ÅÃ</option>
<option value='1'>¾ÆÀÌµð</option>
<option value='2'>¾ÆÀÌµð¿ª¼ø</option>
<option value='3'>·¹º§³ôÀº¼ø</option>
<option value='4'>·¹º§³·Àº¼ø</option>
<option value='5'>Æ÷ÀÎÆ®¸¹Àº¼ø</option>
<option value='6'>Æ÷ÀÎÆ®ÀûÀº¼ø</option>
<option value='7'>ÃÖ±Ù°¡ÀÔÀÏ¼ø</option>
<option value='8'>ÀÌÀü°¡ÀÔÀÏ¿ª¼ø</option>
<option value='9'>ÁöÁ¤ÇÑ·¹º§¸¸</option>
<option value='10'>ÁöÁ¤·¹º§³·À½¼ø</option>
<option value='11'>ÁöÁ¤·¹º§³ôÀ½¼ø</option>
<option value='12'>ÃÖ±Ù·Î±×ÀÎ¼ø</option>
<option value='13'>ÃÖ±Ù·Î±×ÀÎ¿ª¼ø</option>
<option value='14'>ÃÖÁ¾Á¤º¸¼öÁ¤¼ø</option>
<option value='15'>ÃÖÁ¾Á¤º¸¼öÁ¤¿ª¼ø</option>
<option value='16'>³²ÀÚ¸¸Ãâ·ÂÇÏ±â</option>
<option value='17'>¿©ÀÚ¸¸Ãâ·ÂÇÏ±â</option>
<option value='18'>»ýÀÏ¼øÀ¸·Î</option>
<option value='19'>»ýÀÏ¿ª¼øÀ¸·Î</option>
<option value='20'>¸ÞÀÏ¸µ¹ÞÀ½</option>
<option value='21'>¸ÞÀÏ¸µ¾È¹ÞÀ½</option>
<option value='22'>¹®ÀÚ¼ö½Å¹ÞÀ½</option>
<option value='23'>¹®ÀÚ¼ö½Å¾È¹ÞÀ½</option>
<option value='24'>È¸¿øÁ¤º¸°ø°³</option>
<option value='25'>È¸¿øÁ¤º¸ºñ°ø°³</option>
<option value='26'>¾ÆÀÌµð·Î°Ë»ö½Ã</option>
<option value='27'>ÀÌ¸§À¸·Î°Ë»ö½Ã</option>
<option value='28'>´Ð³ÛÀ¸·Î°Ë»ö½Ã</option>
</select>
°Ë»öor·¹º§ÁöÁ¤: <input  type=text name='name' size=12 maxlength=22 value=''>
<input type=submit class=submit value=º¸±â/´Ù¿î·Îµå>
</form>
</td>
<td>
  <form name=search_member2 method=get action=<?=$PHP_SELF?> style="margin:0px;">	
  <input type=hidden name='sv' value=''>
  <input type=hidden name='ks' value=''>
  <input type=hidden name='ms' value=''>
  <input type=hidden name='code' value=''>
  <input type=hidden name='name' value=''>
  <input type=submit class=submit value=ÃÊ±âÈ­>
</form>		
 </td>	
</tr>
</table>
<?
if ($sv =="no") { 
// À¥»ó¿¡¼­ ¹Ù·Îº¸±â ÀÌ¸ç ³Ñ¾î¿Â °ª¿¡ ´ëÇÑÃ³¸®
if($code =="1"){
$m_que = "$g4[member_table] order by mb_id desc";
}else if($code =="2"){
$m_que = "$g4[member_table] order by mb_id asc";
}else if($code =="3"){
$m_que = "$g4[member_table] order by mb_level desc";
}else if($code =="4"){
$m_que = "$g4[member_table] order by mb_level asc";
}else if($code =="5"){
$m_que = "$g4[member_table] order by mb_point desc";
}else if($code =="6"){
$m_que = "$g4[member_table] order by mb_point asc";
}else if($code =="7"){
$m_que = "$g4[member_table] order by mb_datetime desc";
}else if($code =="8"){
$m_que = "$g4[member_table] order by mb_datetime asc";
}else if($code =="9"){
if (!$name) {
$m_que = "$g4[member_table] order by mb_level desc";
} else {
$m_que = "$g4[member_table] where mb_level ='$name'";
}
}else if($code =="10"){
if (!$name) {
$m_que = "$g4[member_table] order by mb_level asc";
} else {
$m_que = "$g4[member_table] where mb_level <= $name";
}
}else if($code =="11"){
if (!$name) {
$m_que = "$g4[member_table] order by mb_level desc";
} else {
$m_que = "$g4[member_table] where mb_level >= $name";
}
}else if($code =="12"){
$m_que = "$g4[member_table] order by mb_today_login desc";
}else if($code =="13"){
$m_que = "$g4[member_table] order by mb_today_login asc";
}else if($code =="14"){
$m_que = "$g4[member_table] order by mb_nick_date desc";
}else if($code =="15"){
$m_que = "$g4[member_table] order by mb_nick_date asc";
}else if($code =="16"){
$m_que = "$g4[member_table] where mb_sex ='M'";
}else if($code =="17"){
$m_que = "$g4[member_table] where mb_sex ='F'";
}else if($code =="18"){
$m_que = "$g4[member_table] order by mb_birth desc";
}else if($code =="19"){
$m_que = "$g4[member_table] order by mb_birth asc";
}else if($code =="20"){
$m_que = "$g4[member_table] where mb_mailling ='1'";
}else if($code =="21"){
$m_que = "$g4[member_table] where mb_mailling ='0'";
}else if($code =="22"){
$m_que = "$g4[member_table] where mb_sms ='1'";
}else if($code =="23"){
$m_que = "$g4[member_table] where mb_sms ='0'";
}else if($code =="24"){
$m_que = "$g4[member_table] where mb_open ='1'";
}else if($code =="25"){
$m_que = "$g4[member_table] where mb_open ='0'";
}else if($code =="26"){
$m_que = "$g4[member_table] where mb_id like '%$name%'";
}else if($code =="27"){
$m_que = "$g4[member_table] where mb_name like '%$name%'";
}else if($code =="28"){
$m_que = "$g4[member_table] where mb_nick like '%$name%'";
} else {
$m_que = "$g4[member_table] order by mb_id desc";
}
$result = mysql_query("select * from $m_que");
$temp = mysql_fetch_array(mysql_query("select count(*) from $g4[member_table] $m_que"));
$number=$temp[0]
?>
 <table width=2000 cellpadding=0 cellspacing=0 border=1>
        <tr align=center height=25 bgcolor=999999>
         <td style=font-weight:bold;>no</td>
		 <td style=font-weight:bold;>id¸í</td>
         <td style=font-weight:bold;>ÀÌ¸§</td>
         <td style=font-weight:bold;>´Ð³Û</td>
         <td style=font-weight:bold;>·¹º§</td>
         <td style=font-weight:bold;>Æ÷ÀÎÆ®</td>
         <td style=font-weight:bold;>°¡ÀÔÀÏ</td>
         <td style=font-weight:bold;>ÃÖÁ¾Á¤º¸</td>
         <td style=font-weight:bold;>ÀÌ¸á</td>
         <td style=font-weight:bold;>È¨ÆäÀÌÁö</td>
         <td style=font-weight:bold;>¼ºº°</td>
         <td style=font-weight:bold;>»ýÀÏ</td>
         <td style=font-weight:bold;>ÀüÈ­</td>
         <td style=font-weight:bold;>ÈÞ´ëÆù</td>
         <td style=font-weight:bold;>¸ÞÀÏ¸µ</td>
         <td style=font-weight:bold;>¹®ÀÚ¼ö½Å</td>
         <td style=font-weight:bold;>Á¤º¸°ø°³</td>
         <td style=font-weight:bold;>ÃÖ±Ù·Î±×ÀÎ</td>
         <td style=font-weight:bold;>ÁÖ¼Ò</td>
       </tr>
<?
while($data=mysql_fetch_array($result))
  {
if ($data[mb_sex] =="M") { $mb_sex ="³²ÀÚ"; } else if ($data[mb_sex] =="F"){ $mb_sex ="¿©ÀÚ"; }
if ($data[mb_mailling] =="1") { $mb_mailling ="¹ÞÀ½"; } else if ($data[mb_mailling] =="0"){ $mb_mailling ="¾È¹ÞÀ½"; }
if ($data[mb_sms] =="1") { $mb_sms  ="¹ÞÀ½"; } else if ($data[mb_sms] =="0"){ $mb_sms ="¾È¹ÞÀ½"; }
if ($data[mb_open] =="1") { $mb_open  ="°ø°³"; } else if ($data[mb_open] =="0"){ $mb_open ="ºñ°ø°³"; }
   echo"
        <tr align=center height=24>
           <td>$number</td>
           <td>$data[mb_id]</td>
           <td>$data[mb_name]</td>
		   <td>$data[mb_nick]&nbsp;</td>
           <td>$data[mb_level]</td>
           <td>$data[mb_point]&nbsp;</td>
           <td>$data[mb_datetime]&nbsp;</td>
           <td>$data[mb_nick_date]&nbsp;</td>
           <td>$data[mb_email]&nbsp;</td>
           <td>$data[mb_homepage]&nbsp;</td>
           <td>$mb_sex&nbsp;</td>
           <td>$data[mb_birth]&nbsp;</td>
           <td>$data[mb_tel]&nbsp;</td>
           <td>$data[mb_hp]&nbsp;</td>
           <td>$mb_mailling</td>
		   <td>$mb_sms</td>
           <td>$mb_open</td>
           <td>$data[mb_today_login]&nbsp;</td>
           <td>$data[mb_addr1]&nbsp;</td>
        </tr>";  
   $number--;
   }
  echo "</table>";	
}
?>
</body>
</html>
