include "lib.php";
include "func.php";
$btn = Util::getReq('btn');
$gen = Util::getReq('gen', 'int', 0);
$type = 0;
//로그인 검사
CheckLogin();
$connect = dbConn();
$query = "select userlevel,skin from general where user_id='$_SESSION[p_id]'";
$result = MYDB_query($query, $connect) or Error(__LINE__.MYDB_error($connect),"");
$me = MYDB_fetch_array($result);
if($me[userlevel] < 5) {
echo "
관리메뉴
관리자가 아닙니다.
";
banner();
echo "
";
exit();
}
if($btn == '정렬하기') {
$gen = 0;
}
$sel[$type] = "selected";
?>
외교정보
외 교 정 보 closeButton(); ?> |
|
|
| 외 교 관 계 |
| 국 가 명 |
국 가 명 |
상 태 |
기 간 |
비 고 |
$query = "select nation,name,color from nation";
$result = MYDB_query($query, $connect) or Error(__LINE__.MYDB_error($connect),"");
$nationcount = MYDB_num_rows($result);
for($i=0; $i < $nationcount; $i++) {
$nation = MYDB_fetch_array($result);
$nationName[$nation[nation]] = $nation[name];
$nationColor[$nation[nation]] = $nation[color];
}
switch($type) {
case 0: $query = "select * from diplomacy where me < you order by state desc"; break;
}
$result = MYDB_query($query, $connect) or Error(__LINE__.MYDB_error($connect),"");
$dipcount = MYDB_num_rows($result);
for($i=0; $i < $dipcount; $i++) {
$dip = MYDB_fetch_array($result);
$me = $dip[me];
$you = $dip[you];
$query = "select reserved,showing from diplomacy where you='$me' and me='$you'";
$result2 = MYDB_query($query, $connect) or Error(__LINE__.MYDB_error($connect),"");
$dip2 = MYDB_fetch_array($result2);
if($dip[state] == 2 && $dip[fixed] == "" && $dip[reserved] == "" && $dip2[reserved] == "") {
continue;
}
switch($dip[state]) {
case 0: $state = "교 전"; break;
case 1: $state = "선포중"; break;
case 2: $state = "통 상"; break;
case 3: $state = "통합수락중"; break;
case 4: $state = "통합제의중"; break;
case 5: $state = "합병수락중"; break;
case 6: $state = "합병제의중"; break;
case 7: $state = "불가침"; break;
}
$date = date('Y-m-d H:i:s');
$note = "";
if($dip[fixed] != "") {
if($dip[state] == 7) {
$note .= $dip[fixed];
} else {
$note .= "{$dip[fixed]}";
}
if($dip[reserved] != "" || $dip2[reserved] != "") {
$note .= "
";
}
}
if($dip[reserved] != "") {
if($dip[showing] >= $date) {
$note .= "아국측 제의: {$dip[reserved]}";
} else {
$note .= "아국측 제의: {$dip[reserved]}";
}
if($dip2[reserved] != "") {
$note .= "
";
}
}
if($dip2[reserved] != "") {
if($dip2[showing] >= $date) {
$note .= "상대측 제의: {$dip2[reserved]}";
} else {
$note .= "상대측 제의: {$dip2[reserved]}";
}
}
if($note == "") { $note = " "; }
echo "
| $nationName[$me] |
$nationName[$you] |
$state |
$dip[term] 개월 |
{$note} |
";
}
?>
| closeButton(); ?> |
| banner(); ?> |