Файл: region_clean/sertificat.php
Строк: 93
<?
#######################################
## Mod By KoT (borispol) [76-75-072] ##
#######################################
require_once "start.php";
require_once "sid.php";
header('Cache-Control: no-store, no-cache, must-revalidate');
if ($ver == "wml")header ("Content-type:text/vnd.wap.wml; charset=utf-8");
else header("Content-Type:text/html; charset=UTF-8");
require_once "inc.php";
$link = connect_db();
list($row, $id, $ps, $fsize1, $fsize2) = check_login($link);
require_once "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
<card title="Сертификаты">n
<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">
<html xmlns="http://www.w3.org/1999/xhtml">
<head><link rel="stylesheet" type="text/css" href="css/$css.css"/>
<title>Сертификаты</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"/></head><body>
<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.'&ref='.$ref.'">В прихожую</a><br/>';
include_once "foot.php";
ob_end_flush();
exit;
}
if (empty($_GET['fid'])) {
echo 'Ошибка!';
include_once "foot.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 "foot.php";
ob_end_flush();
exit;
}
mysql_query("delete from `sertificat` where `zhenih`='" . $fid . "';");
echo 'Сертификат аннулирован!<br/>';
}
break;
case 'view':
$fid = intval(check($_GET['fid']));
if (eregi("[^0-9]", $fid))
{
echo 'Попытка взлома!!!';
echo'<a href="../enter.php?'.$ses.'&ref='.$ref.'">В прихожую</a><br/>';
include_once "foot.php";
ob_end_flush();
exit;
}
if (empty($_GET['fid'])) {
echo 'Ошибка!';
include_once "foot.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 "foot.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
<br/><b>Дата свадьбы:</b> ".$arr['date']."
<br/><b>Свидетель от мужа:</b> $uz22
<br/><b>Свидетель от жены:</b> $uz23
<br/><b>Кол-во гостей:</b> ".$arr['kolvo']."
<br/><b>Дата подписания сертификата:</b> ".$dats."
<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.'&mod=delete&fid='.$muzh.'&ref='.$ref.'">[X]</a> '; }
echo '<a href="sertificat.php?'.$ses.'&mod=view&fid='.$muzh.'&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 and $asd > 0) {
echo ' <a href="sertificat.php?p=1&'.$ses.'&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.'&'.$ses.'&ref='.$ref.'">'.$ii.'</a>';
}
}
$i = $i + 5;
}
if ($asd2 < $count_users) {
echo ' ... <a href="sertificat.php?p='.$ba.'&'.$ses.'&ref='.$ref.'">'.$ba.'</a>';
}
}
echo '<br/>';
break;
}
echo $fsize1;
echo $divide;
if (!empty($mod)) {
echo "<a href="sertificat.php?$ses&ref=$ref">Все сертификаты</a><br/>";
}
echo "<div class='d1'><a href="enter.php?$ses&ref=$rand">Прихожая</a></div>";
echo $fsize2;
include_once "foot.php";
?>