<?php session_start();?> <head> <meta content="text/html; charset=windows-1251" http-equiv="Content-Type" /> </head> <?php define('HOST_MSSQL','localhost');#хост define('LOGIN_MSSQL','Логин_Базы');#логин базы define('PASSWORD_MSSQL','Пароль_Базы');#пароль базы define('WORLD','База_Мира');#база мира if(@mssql_connect(HOST_MSSQL,LOGIN_MSSQL,PASSWORD_MSSQL)) {} else {echo"Нет соединения с базой!";} mssql_select_db(WORLD); function sel_eserial() { $seleserial = mssql_query("SELECT eSerial FROM tbl_patriarch_candidate ORDER BY eSerial DESC"); while($eserial1=mssql_fetch_array($seleserial)) { $eser[]=$eserial1['eSerial']; } $eserial=$eser{0}; list($proveserial)=mssql_fetch_array(mssql_query("SELECT eSerial FROM tbl_patriarch_candidate WHERE eSerial='$eserial' AND ClassType='0'")); if($proveserial =='') {$serial=$eserial-1;} else{$serial=$eserial;} return $serial; } patr_form(); function patr_form() { $n=0; while($n<9) { $serial=sel_eserial(); $select1= mssql_fetch_array(mssql_query("SELECT Serial,AName FROM tbl_patriarch_candidate WHERE eSerial='$serial' AND ClassType='$n' AND Race='0'")); $aserial["0"]["$n"] = $select1['Serial']; $aname["0"]["$n"] = $select1['AName']; $select2= mssql_fetch_array(mssql_query("SELECT Serial,AName FROM tbl_patriarch_candidate WHERE eSerial='$serial' AND ClassType='$n' AND Race='1'")); $aserial["1"]["$n"] = $select2['Serial']; $aname["1"]["$n"] = $select2['AName']; $select3= mssql_fetch_array(mssql_query("SELECT Serial,AName FROM tbl_patriarch_candidate WHERE eSerial='$serial' AND ClassType='$n' AND Race='2'")); $aserial["2"]["$n"] = $select3['Serial']; $aname["2"]["$n"] = $select3['AName']; $n++; } echo" <form method='post'><table style=' width:100%;border:0px'> <tr > <td width='30%'> <table width='100%'>"; $m=0; while($m<3) { switch($m) { case 0: $racename = "Беллато"; break; case 1: $racename = "Кора"; break; case 2: $racename = "Акретия"; break; } $k=0; while($k<9) { $name["$k"]=$aname["$m"]["$k"]; $candser["$k"]=$aserial["$m"]["$k"]; $k++; } echo" <tr> <td><b><font color='lime'>$racename</font></b></td></tr> <tr><td><font color='red'>Патриарх</font><input class='pole2' name='n0$m' value='$name[0]' type=text> <input name='s0$m' value='$candser[0]' type=hidden></td></tr> <tr><td><font color='blue'>Архонты</font> <br>1<input class='pole2' name='n1$m' value='$name[1]' type=text> <input name='s1$m' value='$candser[1]' type=hidden> 2: <input class='pole2' name='n5$m' value='$name[5]' type=text> <input name='s5$m' value='$candser[5]' type=hidden></td></tr> <tr><td><font color='blue'>Атака</font><br> 1:<input class='pole2' name='n2$m' value='$name[2]' type=text> <input name='s2$m' value='$candser[2]' type=hidden> 2:<input class='pole2' name='n6$m' value='$name[6]' type=text> <input name='s6$m' value='$candser[6]' type=hidden></td></tr> <tr><td><font color='blue'>Защита</font> <br>1:<input class='pole2' name='n3$m' value='$name[3]' type=text> <input name='s3$m' value='$candser[3]' type=hidden> 2:<input class='pole2' name='n7$m' value='$name[7]' type=text> <input name='s7$m' value='$candser[7]' type=hidden></td></tr> <tr><td><font color='blue'>Поддержка</font> <br>1:<input class='pole2' name='n4$m' value='$name[4]' type=text> <input name='s4$m' value='$candser[4]' type=hidden> 2:<input class='pole2' name='n8$m' value='$name[8]' type=text> <input name='s8$m' value='$candser[8]' type=hidden></td></tr>"; $m++; } echo"</table> <br><input name='savepatr' type='submit' value='Сохранить' ></td> <td><textarea cols='20' rows='5' disabled='disabled'>$_SESSION[error]</textarea><br> "; $eserial=$serial+1; $candlist=mssql_query("SELECT AName,Race,Serial FROM tbl_patriarch_candidate WHERE eSerial='$eserial' AND ClassType='255' AND State='1'"); echo"<b>Кандидаты на выборы</b><br><table> <TH> Имя </TH> <TH> Раса </TH> <TH> Снять c кандидатов</TH>"; while(list($candname,$candrace1,$candserial)=mssql_fetch_array($candlist)) { switch($candrace1) { case 0: $candrace = "Беллато"; break; case 1: $candrace = "Кора"; break; case 2: $candrace = "Акретия"; break; } echo"<form method='post'><tr > <td width='20%' align='center'><font color='red'>$candname</font></td> <td width='20%' align='center'>$candrace</td> <td width='20%' align='center'><input type='button' value='Снять' type='submit' name='canddel'> <input value='$candserial' type='hidden' name='candserial'></td> <td width='40%'></td></tr></form>"; } echo"</table><hr><b>На выборах</b><br> <table> <TH> Имя </TH> <TH> Раса </TH> <TH> Снять c выбирающихся</TH>"; $electlist=mssql_query("SELECT AName,Race,Serial FROM tbl_patriarch_candidate WHERE eSerial='$eserial' AND ClassType='255' AND State='2'"); while(list($electname,$electrace1,$electserial)=mssql_fetch_array($electlist)) { $electrace = switch_race($electrace1); echo"<form method='post'><tr > <td width='20%' align='center'><font color='red'>$electname</font></td> <td width='20%' align='center'>$electrace</td> <td width='20%' align='center'><input value='Снять' type='submit' name='electdel'> <input value='$electserial' type='hidden' name='electserial'></td> <td width='40%'></td></tr></form>"; } echo"</table></td> </tr></table></form>"; } function save_patr() { $error="Архонты успешно изменены!"; $eserial=sel_eserial(); $n=0; while ($n<9) { $m=0; while ($m<3) { $name=$_POST["n{$n}{$m}"]; $serial=$_POST["s{$n}{$m}"]; if($name!='') { $sel1=mssql_fetch_array(mssql_query("SELECT Serial,Lv,Race FROM tbl_base WHERE Name='$name'")); $sel2 = mssql_fetch_array(mssql_query("SELECT PvpPoint,GuildSerial,CharacterGrade FROM tbl_general WHERE Serial='$sel1[Serial]'")); $sel3 = mssql_fetch_array(mssql_query("SELECT id FROM tbl_Guild WHERE Serial='$sel01[GuildSerial]'")); switch($sel1['Race']) { case 0: $race["$m"] = 0; break; case 1: $race["$m"] = 0; break; case 2: $race["$m"] = 1; break; case 3: $race["$m"] = 1; break; case 4: $race["$m"] = 2; break; } if($race["$m"]==$m and $sel1['Serial']!='') { if($serial!='') { mssql_query("UPDATE tbl_patriarch_candidate SET Race='$m',Lv='$sel1[Lv]',PvpPoint='$sel2[PvpPoint]',ASerial='$sel1[Serial]', AName='$name',GSerial='$sel2[GuildSerial]',GName='$sel3[id]',Grade='$sel2[CharacterGrade]' WHERE Serial='$serial'"); } else { mssql_query("INSERT INTO tbl_patriarch_candidate (eSerial,Race,Lv,PvpPoint,ASerial,AName,GSerial,GName,ClassType,State,Grade) VALUES ('$eserial','$m','$sel1[Lv]','$sel2[PvpPoint]','$sel1[Serial]','$name','$sel2[GuildSerial]','$sel3[id]','$n','2','$sel2[CharacterGrade]')"); } } else {$error.=" Персонаж $name не может стать архонтом!";} } else { mssql_query("DELETE FROM tbl_patriarch_candidate WHERE Serial='$serial'");} $m++; } $n++; } echo" <head><meta http-equiv='Refresh' content='0; $_SERVER[REQUEST_URI]'></head> "; $_SESSION['error']="$error"; } function switch_race($value) { switch($value) { case 0: $race = "Беллато"; break; case 1: $race = "Кора"; break; case 2: $race = "Акретия"; break; } return $race; } function del_cand($serial) { mssql_query("DELETE FROM tbl_patriarch_candidate WHERE Serial='$serial'"); echo" <head><meta http-equiv='Refresh' content='0; $_SERVER[REQUEST_URI]'></head> "; } if(isset($_POST['savepatr'])) { save_patr(); } if(isset($_POST['canddel'])) { del_cand($_POST['candserial']); } if(isset($_POST['electdel'])) { del_cand($_POST['electserial']); } ?>
