Help with Id=View
Posted: Sun Apr 08, 2012 2:41 pm
So i have a members list,
http://sketchedneo.com/testmemberlist.php
I want to make the names clickable so people can view the members profiles.
But Ive gone around in cirlces for 3 days now.
Can someone help please.
I also want to code it onto my forum to make their names click to their profiles too.
http://www.sketchedneo.com//forum/forum.php
Also, The warnings you get at the top of pages, are not there when logged in.
Thank you
http://sketchedneo.com/testmemberlist.php
I want to make the names clickable so people can view the members profiles.
But Ive gone around in cirlces for 3 days now.
Can someone help please.
Code: Select all
<?php
$pagetitle = "All Users";
$checkrank = 5;
include ($_SERVER['DOCUMENT_ROOT'].'/header.inc.php');
$min=$_GET['min'];
$num = mysql_num_rows(mysql_query("SELECT id FROM members"));
echo "<center>Lutari has $num members.<p><table width=\"226\" border=\"0\" cellspacing=\"0\" cellpadding=\"4\" style=\"border-top: 1pt solid black;border-bottom: 1pt solid black;border-left: 1pt solid black;border-right: 1pt solid black; \">
<tr>
<td width=\"100\" style=\"border-bottom: 1pt solid black;border-right: 1pt solid black; background-color:#5eaed4;\">Username</td>
<td width=\"100\" style=\"border-bottom: 1pt solid black;border-right: 1pt solid black; background-color:#5eaed4;\">Joined</td>
<td width=\"100\" style=\"border-bottom: 1pt solid black; background-color:#5eaed4;\">Rank</td>
</tr>";
if ($num <= 0)
{
echo "
<tr>
<td colspan=\"4\" style=\"border-bottom: 1pt solid black;border-right: 1pt solid black; background-color:#f4f4f4;\" ><center>There are no muted users :D</center></td>
</tr>";
}
if (!$min) { $min = 0; }
$max = $min + 50;
$sort = mysql_query("SELECT * FROM members ORDER BY username LIMIT $min,50");
while($sort2 = mysql_fetch_array($sort))
{
if (!$min) { $min = 0; }
$max = $min + 50;
{
$x = 0;
if ($num >= 1)
$datejoin = date("M j Y",$sort2[joined]);
$rankk = mysql_fetch_array(mysql_query("SELECT * FROM jobs WHERE id = '$sort2[rank]'"));
echo "<center>\n";
if($sort2[id]){
echo("
<tr>
<td style=\"border-bottom: 1pt solid black;border-right: 1pt solid black; background-color:#f4f4f4;\" valign=\"top\">$sort2[username]</td>
<td style=\"border-bottom: 1pt solid black;border-right: 1pt solid black; background-color:#f4f4f4;\" valign=\"top\">$datejoin</td>
<td style=\"border-bottom: 1pt solid black; background-color:#f4f4f4;\" valign=\"top\">$rankk[job]</td>
</tr>
"); }
}
}
echo "<tr>
<td colspan=\"4\" style=\"background-color:#5eaed4;\" > </td>
</tr>
</table>
<p> </p>";
if ($num >= 50)
{
echo "<p align=center><a href=$baseurl/staff/all_members.php?min=$max><b>Next page</b></a></p>";
}
if ($min != 0)
{
$prev_min = $min - 50;
echo "<p align=center><a href=$baseurl/staff/all_members.php?min=$prev_min><b>Previous page</b></a></p>";
}
$x = 0;
echo "<p></center>\n";
echo "</center>\n";
include ($_SERVER['DOCUMENT_ROOT'].'/footer.inc.php');
?>I also want to code it onto my forum to make their names click to their profiles too.
http://www.sketchedneo.com//forum/forum.php
Code: Select all
<?php
$pagetitle = "Forum";
$checkrank = 2;
include ($_SERVER['DOCUMENT_ROOT'].'/header.inc.php');
include ($_SERVER['DOCUMENT_ROOT'].'/security/smiliesonly.php');
$min=$_GET['min'];
$id=$_GET['id'];
$sort00 = mysql_fetch_array(mysql_query("SELECT * FROM forum_boards WHERE id = '$id'"));
$file = "staff";
if ($sort00[filed] == $file AND $rank < 5)
{
die("<center>You can not view this board.");
}
$num = mysql_num_rows(mysql_query("SELECT id FROM forum_topic WHERE board = '$id'"));
echo "<center><a href=\"$baseurl/forum/forum.php\">Boards</a> || <a href=\"$baseurl/forum/add_topic.php\">Add Topic</a> || <a href=\"$baseurl/forum/preferences.php\">Preferences</a><p></center>";
echo "<center><table width=\"635\" border=\"0\" cellspacing=\"0\" cellpadding=\"4\" style=\"border-top: 1pt solid black;border-bottom: 1pt solid black;border-left: 1pt solid black;border-right: 1pt solid black; \">
<tr>
<td width=\"108\" valign=\"middle\" style=\"border-bottom: 1pt solid black;border-right: 1pt solid black; background-color:#5eaed4;\"><center>
Posted By
</center></td>
<td width=\"424\" valign=\"middle\" style=\"border-bottom: 1pt solid black;border-right: 1pt solid black; background-color:#5eaed4;\"><center>Title</center></td>
<td width=\"77\" valign=\"middle\" style=\"border-bottom: 1pt solid black; background-color:#5eaed4;\"><center>
Last Post
</center></td>
</tr>";
if ($num <= 0)
{
echo "
<tr>
<td colspan=\"4\" style=\"border-bottom: 1pt solid black; background-color:#f4f4f4;\" ><center>There are no topics on this board :(</center></td>
</tr>";
}
if (!$min) { $min = 0; }
$max = $min + 30;
$sort = mysql_query("SELECT * FROM forum_topic WHERE board = '$id' ORDER BY updated DESC LIMIT $min,30");
while($sort2 = mysql_fetch_array($sort))
{
if (!$min) { $min = 0; }
$max = $min + 30;
{
$x = 0;
if ($num >= 1)
echo "<center>\n";
if($sort2[id])
{
$numreplies = mysql_num_rows(mysql_query("SELECT * FROM forum_replies WHERE topic = '$sort2[id]'"));
$sort4 = mysql_fetch_array(mysql_query("SELECT * FROM forum_replies WHERE topic = '$sort2[id]'"));
$ftime = date("H:i",$sort2[date]);
$fdate = date("M j Y",$sort2[date]);
$updated = date("M j Y",$sort2[updated]);
$ftitle = smiliesonly($sort2[title]);
echo("
<tr>
<td width=\"108\" valign=\"middle\" style=\"border-bottom: 1pt solid black;border-right: 1pt solid black; background-color:#f4f4f4;\"><center>
<p>$sort2[postedby]<br>
$fdate $ftime</p>
</center></td>
<td width=\"424\" valign=\"middle\" style=\"border-bottom: 1pt solid black;border-right: 1pt solid black; background-color:#f4f4f4;\"><a href=\"$baseurl/forum/topic.php?id=$sort2[id]\">$ftitle</a></td>
<td width=\"77\" valign=\"middle\" style=\"border-bottom: 1pt solid black; background-color:#f4f4f4;\"><center>
$updated<br>
Replies: $numreplies
</center></td>
</tr>
"); }
}
}
echo "<tr>
<td colspan=\"3\" style=\"background-color:#5eaed4;\" > </td>
</tr>
</table>
<p> </p>
";
if ($num >= 30)
{
echo "<p align=center><a href=$baseurl/forum/board.php?min=$max><b>Next page</b></a></p>";
}
if ($min != 0)
{
$prev_min = $min - 30;
echo "<p align=center><a href=$baseurl/forum/board.php?min=$prev_min><b>Previous page</b></a></p>";
}
$x = 0;
echo "<p></center>\n";
echo "</center>\n";
include ($_SERVER['DOCUMENT_ROOT'].'/footer.inc.php');
?>Also, The warnings you get at the top of pages, are not there when logged in.
Thank you