може ли някой да ми помогне да каже каде и как точно да напрвя така, че да сложа този урок http://web-tourist.net/login/login/view.php?st=2621 в моя код
Код:
<?php
$query = mysql_query("SELECT * FROM users WHERE username = '$username'");
$red = mysql_num_rows($query);
if($_GET['profile'] == NULL) {
echo '<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td>';
echo '<center><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></center>';
echo '
</td>
</tr>
</table>';
}
else {
echo '
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td>';
if (!isset($_GET['profile'])){
$getusername = mysql_query("SELECT * from users order by id desc");
while ($user = mysql_fetch_array($getusername)) {
}
}
else {
$getusername = mysql_query("SELECT * from users where username = '$_GET[profile]'");
$usernamenum = mysql_num_rows($getusername);
if ($usernamenum == 0) {
echo ("<center><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>Потребителя <font color='green'>$_GET[profile]</font> не съществува!</b></font></td>
<td class='error' align='right' rowspan='4' width='5%'>
</td>
</tr>
</table></center>");
}
else {
$profile = mysql_fetch_array($getusername);
echo '<table width="100%" border="0" cellspacing="2" cellpadding="2">
<tr>
<td colspan="3" class="urok_td" valign="top" align="center"><h2>'.$profile['username'].'</h2></td>
</tr>
<tr>';
echo '<tr>
<td width="30%" class="urok_td" rowspan="4" align="center" valign="middle">';
$filename = 'avatars/'.$profile[username].'.gif';
if (file_exists($filename)) {
echo '<img src="'.$filename.'" border="0">';
}
else {
echo "<img src='avatars/avatar.png' border='0'>";
}
echo '</td>
<td width="20%" class="urok_td" valign="top">Уроци:</td>
<td width="50%" class="urok_td" valign="top"><b>';
$tutorials_user = mysql_query("SELECT count(id) as tutorials_user_total FROM tutorials WHERE author='$profile[username]' AND active='1'");
while($r=mysql_fetch_array($tutorials_user)){
echo "<b>" .$r['tutorials_user_total']."</b>";
}
echo '</b> (<a href="index.php?p=userlessons&author='.$profile['username'].'">Всички уроци на '.$profile['username'].'</a>)</td>
</tr>
<tr>
<td class="urok_td" valign="top">Мнения:</td>
<td width="50%" class="urok_td" valign="top"><b>';
$comments_user = mysql_result(mysql_query("SELECT count(id) FROM comments WHERE author='$profile[username]'"),0);
$user = $comments_user;
echo "<b>" .$user."</b>";
echo '</b> (<a href="index.php?p=userposts&author='.$profile['username'].'">Всички мнения на '.$profile['username'].'</a>)</td>
</tr>
<tr>
<td class="urok_td" valign="top">Точки:</td>
<td width="50%" class="urok_td" valign="top"><b>';
echo "<b>0</b>";
echo '</tr>
<tr>
<td class="urok_td" valign="top">Представяне:</td>
<td class="urok_td" valign="top"><b>';
if($profile['show'] == NULL) {
echo '- Не са указани -';
}
else {
echo $profile['show'];
}
echo '</b></td>
</tr>
<tr>
<td class="urok_td" valign="top">
<table width="100%" border="0" cellspacing="2" cellpadding="2">
<tr>
<td colspan="2" align="center" valign="top">
<hr>
<a href="index.php?p=messages&action=send&user='.$profile[username].'"><img src="images/pm.gif"></a>';
$sql = mysql_query("SELECT * FROM friends WHERE friend='$profile[username]' AND user='$username'");
$broi = mysql_num_rows($sql);
if ($username) {
if ($username == $profile['username']) {
}
else {
if ($broi < 1) {
echo '<hr><a href="index.php?p=friend&user='.$profile['username'].'">Добави в Приятели</a>';
}
else {
}
}
}
$comments = mysql_result(mysql_query("SELECT COUNT(`id`) FROM `comments` WHERE `author` = '$profile[username]'"),0);
$tutorials = mysql_result(mysql_query("SELECT COUNT(`id`) FROM `tutorials` WHERE `author` = '$profile[username]'"),0);
$level = $comments + $tutorials;
echo "<hr>";
$one = "<img src='ranks/star.png'>";
$two = "<img src='ranks/star.png'><img src='ranks/star.png'>";
$three = "<img src='ranks/star.png'><img src='ranks/star.png'><img src='ranks/star.png'>";
$four = "<img src='ranks/star.png'><img src='ranks/star.png'><img src='ranks/star.png'><img src='ranks/star.png'>";
$five = "<img src='ranks/star.png'><img src='ranks/star.png'><img src='ranks/star.png'><img src='ranks/star.png'><img src='ranks/star.png'>";
$six = "<img src='ranks/star.png'><img src='ranks/star.png'><img src='ranks/star.png'><img src='ranks/star.png'><img src='ranks/star.png'><img src='ranks/star.png'>";
if ($level <= 150) {
echo "<div align='center'>Ранк: <b>Нов</b> <br />".$one."</div>";
}
else
if ($level > 150 && $level <= 250) {
echo "<div align='center'>Ранк: <b>Напреднал</b> <br />".$two."</div>";
}
else
if ($level > 250 && $level <= 350) {
echo "<div align='center'>Ранк: <b>Турист</b> <br />".$three."</div>";
}
else
if ($level > 350 && $level <= 450) {
echo "<div align='center'>Ранк: <b>Потребител</b> <br />".$four."</div>";
}
else
if ($level > 450 && $level <= 550) {
echo "<div align='center'>Ранк: <b>Редовен</b> <br />".$five."</div>";
}
else
if ($level > 550 && $level <= 650) {
echo "<div align='center'>Ранк: <b>Активен</b> <br />".$six."</div>";
}
else
if ($level > 650) {
echo "<div align='center'>Ранк: <b>Активен</b> <br />".$six."</div>";
}
echo '<hr />';
$rank = 3;
$sql = "SELECT * FROM users WHERE username='$username' and rank='$rank'";
$res = mysql_query($sql) or die (mysql_error());
$count = mysql_num_rows($res);
if ($count == 1) {
echo "<a href='index.php?p=admin&action=warnings&user=$profile[username]'><img src='images/warning.png'></a><hr>";
}
echo '</td>
</tr>
</table>
</td>
<td colspan="2" class="urok_td" valign="top">
<table width="100%" border="0" cellspacing="2" cellpadding="2">
<tr>
<td class="urok_td" valign="top">Е-майл:</span></td>
<td class="urok_td" valign="top"><b>';
if($profile['hidden'] == 1) {
echo '- Скрит -';
}
else {
echo "<a href='mailto:$profile[email]'>";
echo $profile['email'];
echo "</a>";
}
echo '</b></td>
</tr>
<tr>
<td class="urok_td" valign="top">Skype:</span></td>
<td class="urok_td" valign="top"><b>';
if($profile['skype'] == NULL) {
echo '- Не е указан -';
}
else {
echo "<a href='skype:$profile[skype]?userinfo'>";
echo $profile['skype'];
echo "</a>";
}
echo '</b></td>
</tr>
<tr>
<td width="35%" class="urok_td" valign="top">Сайт:</td>
<td width="65%" class="urok_td" valign="top"><b>';
if($profile['web'] == NULL) {
echo '- Не е указан -';
}
else {
$link = "$profile[web]";
$result = preg_match('/^http:\/\/.*?$/', $link) ? $link : "http://".$link;
echo "<a href='$result'>";
echo $profile[web];
echo "</a>";
}
echo '</b></td>
</tr>
<td colspan="2" class="urok_td" valign="top">
<table width="100%" border="0" cellspacing="2" cellpadding="2">
<tr>
<td class="urok_td" valign="top">Последно влизане:</td>
<td class="urok_td" valign="top"><b>';
$query = "SELECT history FROM users where username='$profile[username]'";
$result = mysql_query($query);
if ($result) {
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
echo "".$row['history']. "";
}
}
echo '</b></td></tr>
<tr>
<td class="urok_td" valign="top">Регистриран на:</td>
<td class="urok_td" valign="top"><b>
'.$profile['date'].'
</b></td>
</tr></table></td></table>
</td>
</tr>
</table>';
}
}
echo '</td>
</tr>
</table>';
}