";
$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)=ms sql_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,GN ame,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>
";
Зачем здесь Сессия?
