include"snapoll_config.php3";
## ·Î±×ÀÎ
if($mode == "" || $mode == "login") {
AdminHead("°ü¸®ÀÚ ·Î±×ÀÎ","
°ü¸®ÀÚ¸¸ ·Î±×ÀÎ ÇϽǼö ÀÖ½À´Ï´Ù. ºñ¹Ð¹øÈ£¸¦ ÀÔ·ÂÇϽðí [·Î±×ÀÎ] ¹öưÀ» ´©¸£¼¼¿ä. |
");
// ÆÐ½º¿öµå ÀÔ·ÂÆû Ãâ·Â
echo"
";
AdminFoot();
}
else if($mode == "install_ok") {
Login_Check();
MysqlConnect();
// ÅõÇ¥ Å×ÀÌºí »ý¼º
if(!@mysql_query("
CREATE TABLE snapoll(
uid INT AUTO_INCREMENT NOT NULL,
id VARCHAR(200) NOT NULL,
subject VARCHAR(255),
item VARCHAR(255),
vote VARCHAR(255),
start_day INT,
end_day INT,
PRIMARY KEY(uid,id)
)")) ErrorMsg("¼³Ä¡ ¿¡·¯!
".mysql_errno()." : ".mysql_error());
Move("$path/snapoll_admin.html?mode=list");
}
## ÅõÇ¥ ¸ñ·Ï
else if($mode == "list") {
Login_Check();
MysqlConnect();
// ÇÑÆäÀÌÁö¿¡ Ç¥½ÃµÉ ÆäÀÌÁö ¸µÅ©¼ö
$page_num = "10";
// ÇÑÆäÀÌÁö¿¡ º¸¿©Áú ÅõÇ¥ °¹¼ö
$limit = "10";
// ÅõÇ¥ °¹¼ö »Ì¾Æ¿À±â
$total = total_search();
// ÆäÀÌÁö ±¸Çϱâ
if(!$page) $page=1;
if($poll == "ing") $total_no = $total[ing];
else if($poll == "end") $total_no = $total[end];
else $total_no = $total[all];
$total_page = intval(($total_no-1)/$limit)+1;
$first = ($page-1)*$limit;
$last = $limit;
if($total_no < $last) $last = $total_no;
$limit = "limit $first,$last";
// °Ô½Ã¹° »Ì¾Æ¿À±â
$query = select_query();
$result = mysql_query($query);
if($poll == "ing") $bgcolor_ing = "bgcolor=white";
else if($poll == "end") $bgcolor_end = "bgcolor=white";
else $bgcolor_all = "bgcolor=white";
AdminHead("
Total : $total_no - Page : $page/$total_page","
");
echo"
¹øÈ£ | ÄÚµå | ÁÖÁ¦ | ÅõÇ¥ | µî·ÏÀÏ | Á¾·áÀÏ | |
|
";
// ÅõÇ¥°¡ Çϳªµµ ¾øÀ»¶§
if($total_no == "0") {
echo"
ÅõÇ¥°¡ ¾ø½À´Ï´Ù. |
|
";
// ÅõÇ¥°¡ ÀÖÀ»¶§
} else {
while($list = mysql_fetch_array($result)) {
// ¹øÈ£
$no = $total_no-$first;
// Áö±Ý ½Ã°£
$today = time();
// Á¾·áµÈ ÅõÇ¥´Â Á¾·áÀÏ¿¡ »ö
if($poll != "ing" && $poll != "end") {
if($list[end_day] < $today) $bgcolor="bgcolor='#EEFAFF'";
else $bgcolor="";
}
// µî·ÏÀÏ | Á¾·áÀÏ
$start_day = date("Y.m.d",$list[start_day]);
$end_day = date("Y.m.d",$list[end_day]);
// ÃÑ ÅõÇ¥¼ö
$vote = explode(":",$list[vote]);
$total_vote = "0";
for($i=0; $i
$no |
$list[id] |
$list[subject] |
$total_vote |
$start_day |
$end_day |
º¸±â : »èÁ¦ : ¼öÁ¤ |
|
";
$first++;
}
}
echo"
";
page_link("snapoll_admin.html?mode=list&poll=$poll");
echo"
|
";
AdminFoot();
}
## ÅõÇ¥ µî·Ï
else if($mode == "input_1") {
Login_Check();
AdminHead("µî·Ï > ±âÃÊ ¼³Á¤","");
// µî·Ï ¾ç½Ä Ãâ·Â
echo"
";
AdminFoot();
}
else if($mode == "input_2") {
Login_Check();
if(CheckField($poll_id) || CheckField($subject)|| CheckField($item) || CheckField($period)) ErrorMsg("¸ðµÎ ÀÔ·Â ÇÏ¼Å¾ß ´ÙÀ½ ´Ü°è·Î °¥¼ö ÀÖ½À´Ï´Ù.
[µÚ·Î°¡±â] ¹öưÀ» ´©¸£½Ã°í ¸ðµÎ ÀÔ·ÂÇϽñ⠹ٶø´Ï´Ù.");
if(CheckInt($item) || CheckInt($period)) ErrorMsg("Ç׸ñÀ̳ª ±â°£Àº ¼ýÀڷθ¸ ÀÌ·ç¾î Á®¾ß ÇÕ´Ï´Ù.");
MysqlConnect();
// Áߺ¹ ÄÚµå üũ
$query = mysql_query("select * from snapoll where id='$poll_id'");
if(mysql_num_rows($query) != 0) ErrorMsg("ÀÌ¹Ì µî·ÏµÈ ÄÚµåÀÔ´Ï´Ù.");
AdminHead("µî·Ï > Ç׸ñ ¼³Á¤","");
echo"
";
AdminFoot();
}
else if($mode == "input_3") {
Login_Check();
if(CheckField($poll_id) || CheckField($subject) || CheckField($period)) ErrorMsg("Ç׸ñÀ» ÀÔ·ÂÇÏ¼Å¾ß ´ÙÀ½ ´Ü°è·Î °¥¼ö°¡ ÀÖ½À´Ï´Ù.
[µÚ·Î°¡±â] ¹öưÀ» ´·¯¼ Ç׸ñÀ» ÀÔ·ÂÇϼ¼¿ä.");
// ÃÑ Ç׸ñ¼ö üũ
for($i=0; $iÇ׸ñÀ» ÀÔ·ÂÇÏ¼Å¾ß ´ÙÀ½ ´Ü°è·Î °¥¼ö°¡ ÀÖ½À´Ï´Ù.
[µÚ·Î°¡±â] ¹öưÀ» ´·¯¼ Ç׸ñÀ» ÀÔ·ÂÇϼ¼¿ä.");
AdminHead("µî·Ï > ¼³Á¤ È®ÀÎ","¾Æ·¡ ÀÔ·Â »çÇ×À¸·Î µî·Ï ÇϽ÷Á¸é [µî·ÏÇϱâ] ¹öưÀ» ´©¸£¼¼¿ä. ¼öÁ¤ÇϽ÷Á¸é [ÀÌÀü´Ü°è] ¹öưÀ» ´©¸£¼¼¿ä. |
");
// ¿À´Ã ½Ã°£ ±¸Çϱâ
$today = time();
// ¸¶°¨ÀÏ ±¸Çϱâ
$endday = $today+($period*24*60*60);
// Á¤È®ÇÑ ³¯Â¥ ±¸Çϱâ
$today_time = date("Y³âm¿ùdÀÏ",$today);
$endday_time = date("Y³âm¿ùdÀÏ",$endday);
echo"
";
AdminFoot();
}
else if($mode == "input_ok") {
Login_Check();
if(CheckField($poll_id) || CheckField($subject) || CheckField($start_day) || CheckField($end_day) || CheckField($item) || CheckField($vote)) ErrorMsg("µî·Ï ¿¡·¯!!");
for($i=0; $i".mysql_errno()." : ".mysql_error());
}
Move("$path/snapoll_admin.html?mode=list&poll=$poll&page=$page");
}
## ¼öÁ¤Çϱâ
else if($mode == "modify_1") {
Login_Check();
if(CheckField($id)) ErrorMsg("Äڵ尡 ¾ø½À´Ï´Ù.");
MysqlConnect();
$query = mysql_query("select * from snapoll where id='$id'");
$list = mysql_fetch_array($query);
AdminHead("¼öÁ¤","¸ðµÎ ÀÔ·ÂÇϽðí [´ÙÀ½´Ü°è] ¹öưÀ» ´©¸£¼¼¿ä. |
");
$item = explode(":",$list[item]);
$vote = explode(":",$list[vote]);
$total_item = count($item)-1;
echo"
";
AdminFoot();
}
else if($mode == "modify_2") {
Login_Check();
if(CheckField($id) || CheckField($subject) || CheckField($item) || CheckInt($total_item) || CheckField($vote) || CheckField($start_day) || CheckInt($period)) ErrorMsg("¸ðµÎ ÀÔ·ÂÇÏ¼Å¾ß ¼öÁ¤ µË´Ï´Ù.");
AdminHead("¼öÁ¤ > Ç׸ñ ¼öÁ¤","Ç׸ñÀ» ¼öÁ¤ÇϽðí [´ÙÀ½´Ü°è] ¹öưÀ» ´©¸£¼¼¿ä. |
");
echo"
";
AdminFoot();
}
else if($mode == "modify_3") {
Login_Check();
if(CheckField($id) || CheckField($subject) || CheckField($item) || CheckField($vote) || CheckField($start_day) || CheckField($period)) ErrorMsg("¸ðµÎ ÀÔ·ÂÇÏ¼Å¾ß ¼öÁ¤ µË´Ï´Ù.");
AdminHead("¼öÁ¤ > È®ÀÎ","¾Æ·¡ ³»¿ëÀÌ ¸ÂÀ¸¸é [¼öÁ¤¿Ï·á] ¹öưÀ» ´©¸£¼¼¿ä. |
");
$total_item = count($item);
echo"