/*
Á¦ÀÛÀÚ : ½º³ªÀÌÆÛ(sniper)
¸ÞÀÏ : sniper@nteen.org
ȨÆäÀÌÁö : http://nteen.org/sniper/@phpfree
º» ÀúÀÛ±ÇÀº Áö¿ì½Ã¸é ¾ÈµË´Ï´Ù.
*/
include('connect.php3');
$today = date(Ymd);
if($mode == '') // ·Î±×ÀÎ
{
echo"
°ü¸®ÀÚ ·Î±×ÀÎ
";
}
else if($mode == login) // ·Î±×ÀΠó¸®
{
if(!$pass)
{
echo" "; exit;
}
if($pass != $admin_pass)
{
echo" "; exit;
}
setcookie("sniper_poll_admin","y","");
echo"";
}
else if($mode == login_ok) // ·Î±×ÀÎÈÄ °ü¸®ÀÚ ¸Þ´º
{
if(!$sniper_poll_admin)
{
echo" "; exit;
}
echo"Å×ÀÌºí ¼³Ä¡Çϱâ / ÅõÇ¥ °ü¸®";
}
else if($mode == table) // Å×ÀÌºí »ý¼º
{
if(!$sniper_poll_admin)
{
echo" "; exit;
}
mysql_query("CREATE TABLE $table (
uid int(10) NOT NULL auto_increment,
code varchar(15) ,
title varchar(15),
poll_date varchar(15) ,
q1 varchar(20) ,
q2 varchar(20) ,
q3 varchar(20) ,
q4 varchar(20) ,
q5 varchar(20) ,
q6 varchar(20) ,
q7 varchar(20) ,
q8 varchar(20) ,
q9 varchar(20) ,
q10 varchar(20) ,
v1 int(10) not null,
v2 int(10) not null,
v3 int(10) not null,
v4 int(10) not null,
v5 int(10) not null,
v6 int(10) not null,
v7 int(10) not null,
v8 int(10) not null,
v9 int(10) not null,
v10 int(10) not null,
poll_num int(2),
primary key(uid)
)"
);
echo"»ý¼º ¿Ï·á!!";
}
else if($mode == 'list') // ÅõÇ¥ ¸®½ºÆ®
{
if(!$sniper_poll_admin)
{
echo" "; exit;
}
$query = mysql_query("select * from $table order by uid desc",$dbconn);
$num_result = mysql_query("select count(*) from $table",$dbconn);
$num_query = mysql_fetch_array($num_result);
$num = $num_query[0];
echo"
ÃÑ $num °³ |
|
|
¹øÈ£ |
ÄÚµå |
ÅõÇ¥ Á¦¸ñ
|
";
$i = 1;
while($list = mysql_fetch_array($query))
{
$date_check = explode("-",$list[poll_date]);
while(list($key,$val) = each($date_check)) // ³¯Â¥ ¹è¿ ¸¸µé±â
{
$date_check_ok = "${date_check[0]}${date_check[1]}${date_check[2]}";
}
if($date_check_ok <= $today)
{
$now = "[Á¾·á]";
}
echo"
$i |
$list[code] |
$now $list[title] |
[¼öÁ¤] |
[»èÁ¦] |
";
$i++;
}
echo"
";
}
else if($mode == 'make') // ÅõÇ¥ »ý¼º
{
if(!$sniper_poll_admin)
{
echo" "; exit;
}
echo"
";
}
else if($mode == make_ok) // ÅõÇ¥ »ý¼º ó¸®
{
if(!$sniper_poll_admin)
{
echo" "; exit;
}
// ¾ø´Â ÅõÇ¥ ÄÚµå üũ
$check = mysql_query("select code from $table where code='$code'",$dbconn);
$check2 = mysql_fetch_array($check);
if($code == $check2[0])
{
echo"
";
exit;
}
$date = $Y.'-'.$m.'-'.$d;
$date_check = explode("-",$date);
while(list($key,$val) = each($date_check)) // ³¯Â¥ ¹è¿ ¸¸µé±â
{
$date_check_ok = "${date_check[0]}${date_check[1]}${date_check[2]}";
}
if($today >= $date_check_ok)
{
echo" "; exit;
}
mysql_query("insert into $table (code,title,poll_date,poll_num,q1,q2,q3,q4,q5,q6,q7,q8,q9,q10,v1,v2,v3,v4,v5,v6,v7,v8,v9,v10) values('$code','$title','$date','$poll_num','$q1','$q2','$q3','$q4','$q5','$q6','$q7','$q8','$q9','$q10','$v1','$v2','$v3','$v4','$v5','$v6','$v7','$v8','$v9','$v10')",$dbconn);
echo"";
}
else if($mode == modify) // ¼öÁ¤
{
if(!$sniper_poll_admin)
{
echo" "; exit;
}
$query = mysql_query("select * from $table where uid='$uid'",$dbconn);
while($list = mysql_fetch_array($query))
{
$date_check = explode("-",$list[poll_date]);
while(list($key,$val) = each($date_check)) // ³¯Â¥ ¹è¿ ¸¸µé±â
{
$date_1 = $date_check[0];
$date_2 = $date_check[1];
$date_3 = $date_check[2];
}
if($list[poll_num] == 1) $check1 = "selected";
if($list[poll_num] == 2) $check2 = "selected";
if($list[poll_num] == 3) $check3 = "selected";
if($list[poll_num] == 4) $check4 = "selected";
if($list[poll_num] == 5) $check5 = "selected";
if($list[poll_num] == 6) $check6 = "selected";
if($list[poll_num] == 7) $check7 = "selected";
if($list[poll_num] == 8) $check8 = "selected";
if($list[poll_num] == 9) $check9 = "selected";
if($list[poll_num] == 10) $check10 = "selected";
echo"
";
}
}
else if($mode == 'modify_ok') // ¼öÁ¤ ó¸®
{
if(!$sniper_poll_admin)
{
echo" "; exit;
}
$date = $Y.'-'.$m.'-'.$d;
$date_check = explode("-",$date);
while(list($key,$val) = each($date_check)) // ³¯Â¥ ¹è¿ ¸¸µé±â
{
$date_check_ok = "${date_check[0]}${date_check[1]}${date_check[2]}";
}
if($today >= $date_check_ok)
{
echo" "; exit;
}
mysql_query("UPDATE $table SET
code = '$code',
title = '$title',
poll_date = '$date',
poll_num = '$poll_num',
q1 = '$q1',
q2 = '$q2',
q3 = '$q3',
q4 = '$q4',
q5 = '$q5',
q6 = '$q6',
q7 = '$q7',
q8 = '$q8',
q9 = '$q9',
q10 = '$q10',
v1 = '$v1',
v2 = '$v2',
v3 = '$v3',
v4 = '$v4',
v5 = '$v5',
v6 = '$v6',
v7 = '$v7',
v8 = '$v8',
v9 = '$v9',
v10 = '$v10' WHERE uid = '$uid'",$dbconn);
echo"¼öÁ¤ ¿Ï·á!!";
}
else if($mode == 'del')
{
if(!$sniper_poll_admin)
{
echo" "; exit;
}
$query = mysql_query("delete from $table where uid = '$uid'",$dbconn);
echo"»èÁ¦ ¿Ï·á!!
";
exit;
}
?>