|
http://www.hackerschool.org/HS_Boards/zboard.php?id=QNA_programming&no=2261 [복사]
<?php
include "config.php";
$conn = mysql_connect($linuxip,$username,$password);
$db = mysql_select_db($schema, $conn);
$name = $_POST[name];
$pasw = $_POST[pasw];
$charname = $_POST[charname];
$clan = $_POST[clan];
$idcheck = mysql_query("SELECT * FROM `Player` WHERE `PlayerID` = '$name' AND `Password` = PASSWORD('$pasw')");
$charcheck = mysql_query("SELECT * FROM `$clan` WHERE `Name` = '$charname' AND `PlayerID` = '$name'");
$increase = "UPDATE `$clan` SET `AdvancementClass` = 1, `Bonus` = `Bonus`+4, `SMSCharge` = `SMSCharge`+1 WHERE `Name` = '$charname'";
if (mysql_num_rows($idcheck) > 0) {
if (mysql_num_rows($charcheck) <= 0) {
echo "
<script language='javascript'>
alert('캐릭터, $charname 가(이) 존재하지않습니다.')
location='increase.php';
</script>
";
} else {
while ($row = mysql_fetch_array($charcheck)) {
if ($row[SMSCharge] > 5) {
echo "
<script language='javascript'>
alert('$charname 은 이미 환생 제한횟수 5번을 모두 사용하신 상태이므로 환생이 불가능합니다.')
location='increase.php';
</script>
";
} else {
if ($clan != "") {
if ($row[AdvancementClass] == 100) {
mysql_query($increase, $conn);
mysql_close($conn);
echo "
<script language='javascript'>
alert('$name 의 캐릭터인 $charname 가(이) 환생이 완료되었습니다.')
location='increase.php';
</script>
";
} else {
echo "
<script language='javascript'>
alert('$charname 은 승직 100등급 이하이므로 환생이 불가능합니다.')
location='increase.php';
</script>
";
}
}
}
}
}
} else {
echo "
<script language='javascript'>
alert('서버 계정인 $name 가(이) 없습니다.')
location='increase.php';
</script>
";
}
?>
ㅎㅎ |
Hit : 2809 Date : 2010/01/17 09:32
|
3206, 
5/161 
