може ли да ми каже някой каде да сложа проверка и кодчето за проверката в кода
Код:
<?php
if ($username) {
$sqlmsg = "SELECT count(id) as obshto FROM messages WHERE touser = '$username'";
$resmsg = mysql_query($sqlmsg) or die(mysql_error());
$msg = mysql_fetch_array($resmsg);
$obshto = $msg['obshto'];
$sqlmsg = "SELECT count(id) as unread FROM messages WHERE touser = '$username' AND unread=0";
$resmsg = mysql_query($sqlmsg) or die(mysql_error());
$msg = mysql_fetch_array($resmsg);
$unread = $msg['unread'];
echo "<table align='center'>";
echo "<td class='urok_td'><a href='index.php?p=folder'>Папка</a></td>";
if($obshto == 0) {
echo "<td class='urok_td'><a href='index.php?p=messages'>Съобщения($unread/$obshto)</a></td>";
}
else {
echo "<td class='urok_td'><a href='index.php?p=messages'>Съобщения($unread/$obshto)</a></td>";
}
echo "<td class='urok_td'><a href='index.php?p=favorites'>Любими уроци</a></td>
<td class='urok_td'><a href='index.php?p=friends'>Приятели</a></td>
<td class='urok_td'><a href='index.php?p=warning'>Забележки</a></td>";
echo "</table>";
$pp = "10";
$page = $_GET['page'];
if(!$_GET['page'])
{
$page = "1";
}
$limit = ($pp*$page)-$pp;
$redove = mysql_query("SELECT * FROM friends");
$max = mysql_num_rows($redove);
$total = ceil($max/$pp);
$db = mysql_query("SELECT * FROM users WHERE username='$username'");
while ($r = mysql_fetch_array($db)) {
$id = $r['id'];
$usr = $r['username'];
}
$sql = mysql_query("SELECT * FROM friends WHERE user='$usr' ORDER BY id DESC LIMIT $limit,$pp");
$fr = mysql_num_rows($sql);
if ($fr > 0) {
while ($r = mysql_fetch_array($sql)) {
echo "<hr><table id='urok_table' align='center' border='0' cellspacing='2' cellpadding='2'>
<tr>
<td class='urok_td' colspan='3' valign='top' align='center'>";
$friend = $r['friend'];
$sql2 = mysql_query ("SELECT * FROM users where username='$friend'");
while ($r2 = mysql_fetch_array($sql2)) {
$sql3 = mysql_query("SELECT * FROM friends WHERE id='$r[id]'");
while ($r3 = mysql_fetch_array($sql3)) {
echo "<a href='index.php?p=user&profile=$r2[username]'>$r2[username]</a></td></tr>";
$filename = 'avatars/'.$r2[username].'.gif';
if (file_exists($filename)) {
echo '<tr><td align="center"><img src="'.$filename.'" border="0"></td></tr>';
}
else {
echo "<tr><td align='center'><img src='avatars/avatar.png' border='0'></td></tr>";
}
echo "<tr><td align='center' class='urok_td'><a href='index.php?p=deletefriend&friend=$r3[id]'><font color='red'>Премахни</font></a></td></tr>";
}
echo "</table><br />";
}
}
echo "<br />
<table width='100%' id='urok_table' border='0' cellspacing='2' cellpadding='2'>
<tr>
<td colspan='3' class='urok_td' align='center' valign='top'>";
if (!$page or ($page > $total)) {
$page="1";
}
if ($total < 10) {
for($i = 1 ; $i <= $total ; $i++) {
if (($page) == $i ) {
echo "<b class='stranica'>$i</b> ";
}
else {
echo "<a href=\"index.php?p=friends&page=".$i."\" class='stranici'>".$i."</a> ";
}
}
}
else {
for($i = 1 ; $i <= 3 ; $i++) {
if (($page) == $i ) {
echo "<b class='stranica'>$i</b> ";
}
else {
echo "<a href=\"index.php?p=friends&page=".$i."\" class='stranici'>".$i."</a> ";
}
}
if ($page <= 3) {
if ($page == 3) echo "<a href=\"?page=4\" class='stranici'>4</a> ";
echo "... ";
for ($i = $total - 2; $i <= $total; $i++)
echo "<a href=\"index.php?p=friends&page=".$i."\" class='stranici'>".$i."</a> ";
}
if ($page == 5) $parva.= "<a href=\"?page=4\" class='stranici'>4</a> ";
if (($page == 4) or ($page == 5) ) {
for ($i = $page; $i <= $page+1; $i++) {
if ($page == $i) echo "<b class='stranica'>$i</b> ";
else
echo "<a href=\"index.php?p=friends&page=".$i."\" class='stranici'>".$i."</a> ";
}
echo "... ";
for ($i = $total - 2; $i <= $total; $i++)
echo "<a href=\"index.php?p=friends&page=".$i."\" class='stranici'>".$i."</a> ";
}
if (($page > 5) and ($page < ($total - 4)) ) {
echo "... ";
for ($i = $page - 1; $i <= $page + 1; $i++) {
if ($page == $i) echo "<b class='stranica'>$i</b> ";
else
echo "<a href=\"index.php?p=friends&page=".$i."\" class='stranici'>".$i."</a> ";
}
echo "... ";
for ($i = $total - 2; $i <= $total; $i++)
echo "<a href=\"index.php?p=friends&page=".$i."\" class='stranici'>".$i."</a> ";
}
if ($page > ($total - 5) ) {
echo "... ";
for ($i = $total - 5; $i <= $total; $i++) {
if ($page == $i) echo "<b class='stranica'>$i</b> ";
else
echo "<a href=\"index.php?p=friends&page=".$i."\" class='stranici'>".$i."</a> ";
}
}
}
echo "</td></tr>
</table>";
}
else {
echo "<hr><table width='80%' class='error1' align='center'>
<tr>
<td class='error' align='left' rowspan='4' width='5%'>
<img src='images/error_button.png' border='0' width='33' height='33'>
</td>
<td align='left' width='100%'><font color='red'><b>Нямате добавени приятели в списъка!</b></font></td>
<td class='error' align='right' rowspan='4' width='5%'>
</td>
</tr>
</table>";
}
}
else {
echo "<table width='80%' class='error1' align='center'>
<tr>
<td class='error' align='left' rowspan='4' width='5%'>
<img src='images/error_button.png' border='0' width='33' height='33'>
</td>
<td align='left' width='100%'><font color='red'><b>За да добавите приятел трябва да влезете в профила си!</b></font></td>
<td class='error' align='right' rowspan='4' width='5%'>
</td>
</tr>
</table>";
}