View file sertificat.php

File size: 5.95Kb 
<?

header('Cache-Control: no-store, no-cache, must-revalidate');	// HTTP/1.1
if ($ver=="wml")header ("Content-type:text/vnd.wap.wml; charset=utf-8");
else header("Content-Type:text/html; charset=UTF-8");

require("inc.php");
$link = connect_db();
list($row, $id, $ps, $fsize1, $fsize2) = check_login($link);
require("version.php");

$r = mysql_query ("select level from users where id='$id';");
$arr = mysql_fetch_array($r);
$lev=$arr['level'];

$mid = intval($mid);

if ($ver=="wml"){
echo $xml;
echo $dtd;
echo "<wml>\n";
echo "<card title=\"Сертификаты\">\n";
echo "<p align=\"center\">\n";
}else{
echo "<!DOCTYPE html PUBLIC \"-//W3C//DTD XHTML 1.0 Transitional//EN\" \"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd\">";
echo "<html xmlns=\"http://www.w3.org/1999/xhtml\">";
if($row["skin"]=="0"){echo "<head><link rel=\"stylesheet\" type=\"text/css\" href=\"css/css.css\"/>";}if($row["skin"]=="1"){echo "<head><link rel=\"stylesheet\" type=\"text/css\" href=\"css/css1.css\"/>";}if($row["skin"]=="2"){echo "<head><link rel=\"stylesheet\" type=\"text/css\" href=\"css/css2.css\"/>";}if($row["skin"]=="3"){echo "<head><link rel=\"stylesheet\" type=\"text/css\" href=\"css/css3.css\"/>";}
echo "<title>Сертификаты</title>";
echo "<meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\"/></head><body>";
echo "<div align=\"center\">";
}


switch($mod) {
case 'delete':

if($lev == 8) {
$fid = intval(check($_GET['fid']));
if (eregi("[^0-9]", $fid))
{echo"ЗЫ. Попытка взлома!!!";
echo'<a href="../enter.php?'.$ses.'&amp;ref='.$ref.'">В прихожую</a><br/>';
include_once"../foot3.php"; ob_end_flush(); exit;}
if (empty($_GET['fid'])){echo "Ошибка!";include_once"../foot3.php"; ob_end_flush(); exit;}
$typ = mysql_query("select * from `sertificat` where zhenih='" . $fid . "';");
$ms = mysql_fetch_array($typ);
if (empty($ms[id]))
{echo "Ошибка!"; include_once"../foot3.php"; ob_end_flush(); exit;}

mysql_query("delete from `sertificat` where `zhenih`='" . $fid . "';");

echo"Сертификат аннулирован!";

}

break;

case 'view':

$fid = intval(check($_GET['fid']));
if (eregi("[^0-9]", $fid))
{echo"ЗЫ. Попытка взлома!!!";
echo'<a href="../enter.php?'.$ses.'&amp;ref='.$ref.'">В прихожую</a><br/>';
include_once"../foot3.php"; ob_end_flush(); exit;}
if (empty($_GET['fid'])){echo "Ошибка!";include_once"../foot3.php"; ob_end_flush(); exit;}
$typ = mysql_query("select * from `sertificat` where zhenih='" . $fid . "';");
$ms = mysql_fetch_array($typ);
if (empty($ms[id]))
{echo "Ошибка!"; include_once"../foot3.php"; ob_end_flush(); exit;}

$q=@mysql_query("select * from sertificat where zhenih='$fid';");
$arr=@mysql_fetch_array($q);

$rs=mysql_query("SELECT `user` FROM `users` WHERE `id`='".$arr['zhenih']."';");
$rowx = mysql_fetch_array($rs);
$uz = $rowx[0];

$rsx=mysql_query("SELECT `user` FROM `users` WHERE `id`='".$arr['nevesta']."';");
$rx = mysql_fetch_array($rsx);
$uz2 = $rx[0];

$rsx3=mysql_query("SELECT `user` FROM `users` WHERE `id`='".$arr['svidetel2']."';");
$rx3 = mysql_fetch_array($rsx3);
$uz23 = $rx3[0];

$rsx2=mysql_query("SELECT `user` FROM `users` WHERE `id`='".$arr['svidetel1']."';");
$rx2 = mysql_fetch_array($rsx2);
$uz22 = $rx2[0];

$dats = date("d.m.y / H:i",$arr['time']);

		echo $fsize1;
		echo "<b>Пара:</b> $uz + $uz2";
		echo "<br/><b>Дата свадьбы:</b> ".$arr['date'];
		echo "<br/><b>Свидетель от мужа:</b> $uz22";
		echo "<br/><b>Свидетель от жены:</b> $uz23";
	    echo "<br/><b>Кол-во гостей:</b> ".$arr['kolvo'];
	    echo "<br/><b>Дата подписания сертификата:</b> $dats";
		echo "<br/>";
        echo $fsize2;
break;


default:

echo"Все брачные сертификаты<br/><br/>";

if (empty($_GET['p'])) $page = 1;
	else $page=$_GET['p'];
				$result = mysql_query("SELECT count(`id`) FROM `sertificat`;");
			$cntData = mysql_fetch_row($result);
			$count_users = $cntData[0];
			$max_page = ceil ($count_users / 5);

			$page	= ($page > $max_page) ? (($max_page == 0)? $page : $max_page) : $page;

			$start  = 5*($page-1);
			$end	= 5;

			$resultx=mysql_query("SELECT * FROM `sertificat` ORDER BY time DESC LIMIT $start,$end;");
$count_users_on_pagex = mysql_num_rows($resultx);


for($i = 0; $i < $count_users_on_pagex; $i++)
{
$row = mysql_fetch_array($resultx);
$xid = $row[id];
$muzh = $row[zhenih];
$zhena = $row[nevesta];

$dats = date("d.m.y / H:i",$time);

$rs=mysql_query("SELECT `user` FROM `users` WHERE `id`='".$muzh."';");
$rowx = mysql_fetch_array($rs);
$uz = $rowx[0];

$rsx=mysql_query("SELECT `user` FROM `users` WHERE `id`='".$zhena."';");
$rx = mysql_fetch_array($rsx);
$uz2 = $rx[0];


if($lev == 8) {
echo'<a href="sertificat.php?'.$ses.'&amp;mod=delete&amp;fid='.$muzh.'&amp;ref='.$ref.'">[X]</a> '; }
echo'<a href="sertificat.php?'.$ses.'&amp;mod=view&amp;fid='.$muzh.'&amp;ref='.$ref.'">'.$uz.' + '.$uz2.'</a><br/>Дата выдачи: '.$dats.'<br/><br/>';


}
echo"<br/>";
			if($i==0)
			{
			echo "<br/><center><b>Пока нету...</b></center><br/>";
			}

if ($max_page > 1)
{
$ba=ceil($count_users/5);
$ba2=$ba*5-5;

echo "Страницы:";
$asd=$start-(5*4);
$asd2=$start+(5*5);

if($asd<$count_users && $asd>0){echo ' <a href="sertificat.php?p=1&amp;'.$ses.'&amp;ref='.$ref.'">1</a> ... ';}

for($i=$asd; $i<$asd2;)
{
if($i<$count_users && $i>=0){
$ii=floor(1+$i/5);

if ($start==$i) {
echo ' <b>('.$ii.')</b>';
               }
                else {
echo ' <a href="sertificat.php?p='.$ii.'&amp;'.$ses.'&amp;ref='.$ref.'">'.$ii.'</a>';
                     }}


$i=$i+5;}
if($asd2<$count_users){echo ' ... <a href="sertificat.php?p='.$ba.'&amp;'.$ses.'&amp;ref='.$ref.'">'.$ba.'</a>';}

				}
echo"<br/>";


break;
}
echo $fsize1;
echo $divide;
if($mod) {
echo "<a href=\"sertificat.php?$ses&amp;ref=$ref\">Все сертификаты</a><br/>";
}


echo "<a href=\"enter.php?$ses&amp;ref=$rand\">Прихожая</a><br/>";
echo $fsize2;
include_once"foot2.php";
?>