<?php
function secure($var) {
return addslashes(htmlspecialchars($var));
}
$page6 = secure($_GET['page']);
if(is_numeric($page6)){
$stranici = 10;
$pageNum = 1;
if(isset($page6)) {
$pageNum = $page6; }
$reds = ($pageNum - 1) * $stranici;
$query = "SELECT * FROM `ibf_message_text` ORDER BY msg_id DESC" . " LIMIT $reds, $stranici";
$sql = mysql_query($query)or die(mysql_error());
while ($row = mysql_fetch_assoc($sql)) {
$msg_post = $row['msg_post'];
$msg_id = $row['msg_id'];
$msg_author_id = $row['msg_author_id'];
$msg_date = $row['msg_date'];
$sql2 = mysql_query("SELECT * FROM `ibf_message_topics` WHERE mt_msg_id = '$msg_id' LIMIT 0,1")or die (mysql_error());
$row2 = mysql_fetch_assoc($sql2);
$mt_title = $row2['mt_title'];
$mt_to_id2 = $row2['mt_to_id'];
$mt_from_id2 = $row2['mt_from_id'];
$sql3 = mysql_query("SELECT * FROM `ibf_members` WHERE id = '$mt_from_id2' LIMIT 0,1")or die (mysql_error());
$row3 = mysql_fetch_assoc($sql3);
$mt_from_id = $row3['members_display_name'];
$sql4 = mysql_query("SELECT * FROM `ibf_members` WHERE id = '$mt_to_id2' LIMIT 0,1")or die (mysql_error());
$row4 = mysql_fetch_assoc($sql4);
$mt_to_id = $row4['members_display_name'];
echo "
<table class=\"sample\" width=\"100%\">
<tr>
<td> <b>Заглавие:</b> </td>
<td> <b>$mt_title</b> </td>
</tr>
<tr>
<td> <b>Автор:</b> </td>
<td> <b>$mt_from_id</b> </td>
</tr>
<tr>
<td> <b>До:</b> </td>
<td> <b>$mt_to_id</b> </td>
</tr>
<tr>
<td> <b>Дата:</b> </td>
<td> <b>$msg_date</b> </td>
</tr>
<tr>
<td> <b>Отговор:</b> </td>
<td> <b>$msg_post</b> </td>
</tr>
</table>
<br /><br />
";
}
echo "</td></tr></table>";
$query = "SELECT COUNT(msg_id) AS broi FROM ibf_message_text";
$result = mysql_query($query);
$row = mysql_fetch_array($result, MYSQL_ASSOC);
$numrows = $row['broi'];
$maxPage = ceil($numrows/$stranici);
$self = $_SERVER['PHP_SELF'];
$nstranica = '';
for($page = 1; $page <= $maxPage; $page++) {
if ($page == $pageNum) {
$nstranica .= "<a href='#top' style='background-color:#313131;border:1px solid #C5C1B6;color: red;'><b>$page</b></a> ";
}
else {
$nstranica .= " <a href=\"$self?page=$page\">$page</a>";
}
}
if ($pageNum > 1) {
$page = $pageNum - 1;
$pred = " <a href=\"$self?page=$page\"> <b>«</b> </a>";
}
else {
$pred = ' ';
}
if ($pageNum < $maxPage) {
$page = $pageNum + 1;
$sled = " <a href=\"$self?page=$page\"> <b>»</b> </a>";
}
else {
$sled = ' ';
}
echo "<br /><br /><br /><div class='pages'>". $pred . $nstranica . $sled;
}
else {
echo "<h2>Страницата , която търсите не съществува!</h2><br /><br />";
}
$our2 = mysql_query("SELECT count(msg_id) as message_text_total FROM ibf_message_text");
while($r=mysql_fetch_array($our2)){
echo "</div> Общо съобщения в базата: <b>" .$r['message_text_total']."</b></center>";
}
echo '
</body><br /><br />
</html>';
}
?>