<?php
$page = (int)$_GET['page'];
$count = mysql_num_rows(mysql_query("SELECT * FROM `mod_log`"));
$per_page = 20;
$pages = ceil($count / $per_page);
if($page == NULL || $page < 1 || $page > $pages) {
$page = 1;
}
$a = ($page - 1) * $per_page;
echo " <table border=\"1\" cellspacing=\"0\" cellpadding=\"2\">
<tr>
<td><b>Запис #</b></td>
<td><b>Модератор ID</b></td>
<td><b>Модератор Име</b></td>
<td><b>Модератор - Действие</b></td>
<td><b>Модератор - IP адрес</b></td>
<td><b>Модератор - час и дата</b></td>
<td><b>Снимка</b></td>
<td><b>18+</b></td>
<td><b>Добавил</b></td>
<td><b>Добавена на</b></td>
<td><b>Активност</b></td>
<td><b>Статус</b></td>
</tr>
";
$query = "SELECT * FROM `mod_log` ORDER BY `log_id` ASC LIMIT $a, $per_page";
$result = mysql_query($query) or die(mysql_error());
while($row = mysql_fetch_array($result)) {
$mod_time = date("H:i:s d-m-Y", $row['mod_time']);
$dateadded = date("H:i:s d-m-Y", $row['dateadded']);
echo "
<tr>
<td>{$row['log_id']}</td>
<td>{$row['mod_id']}</td>
<td>{$row['mod_username']}</td>
<td>";
if($row['mod_action'] == 1) {
echo "<font color=\"green\"><b>Одобряване</b></font>";
}
elseif($row['mod_action'] == 2) {
echo "<font color=\"orange\"><b>Преместване в кошчето</b></font>";
}
elseif($row['mod_action'] == 3) {
echo "<font color=\"blue\"><b>Добавяне в 18+</b></font>";
}
elseif($row['mod_action'] == 4) {
echo "<font color=\"blue\"><b>Премахване от 18+</b></font>";
}
elseif($row['mod_action'] == 5) {
echo "<font color=\"red\"><b>Триене</b></font>";
}
echo "</td>
<td>{$row['mod_ip']}</td>
<td>{$mod_time}</td>
<td>{$row['filename']}</td>
<td>";
if($row['adult'] == 1) {
echo "<font color=\"red\"><b>Да</b></font>";
}
elseif($row['adult'] == 0) {
echo "<font color=\"green\"><b>Не</b></font>";
}
echo "</td>
<td>{$row['member_id']}</td>
<td>{$dateadded}</td>
<td>";
if($row['active'] == 1) {
echo "<font color=\"green\"><b>Активна</b></font>";
}
elseif($row['active'] == 0) {
echo "<font color=\"red\"><b>Неактивна</b></font>";
}
echo "</td>
<td>";
if($row['approved'] == 0) {
echo "<font color=\"red\"><b>Не е одобрена</b></font>";
}
elseif($row['approved'] != 0){
echo "<font color=\"green\"><b>Одобрена</b></font>";
}echo "</td>
</tr>";
}
if($page > 1) {
$prev = $page - 1;
$prev = "<a href=\"index.php?page=$prev\"><< предишна</a>";
}
if($page < $pages) {
$next = $page + 1;
$next = "<a href=\"index.php?page=$next\">следваща >></a>";
}
echo "
</table>
$prev $next
";
?>
