You know in your site settings, there's an option to turn on " Enable Alternate Friendly Signature BBCode". It says I need to change the .htaccess file to something that will make it work. So what exactly do I change in there? I see the file, I see the part that converts the links..
Also, I've tried to get user's avatars to show up on the profile.php page. I got it, but now users are shown twice, one after the other and I think some are mixed up. Can you help? [I have no programming experience, I simply copied the query and edited it]
Also, I've tried to get user's avatars to show up on the profile.php page. I got it, but now users are shown twice, one after the other and I think some are mixed up. Can you help? [I have no programming experience, I simply copied the query and edited it]
Code:
// We did not specify a user, so show the memberlist
$article_title = "Memberlist";
$article_content = "Here are all of the members of this site, sorted by registration date.<br /><br />";
include("classes/class_pagination.php");
include("css/pagination.css");
$query = "SELECT * FROM {$prefix}users ORDER BY uid ASC";
$stmt = $adopts->query($query);
$rowsperpage = 15;
$pagination = new Pagination($adopts, $query, $rowsperpage, "http://www.{$domain}{$scriptpath}/profile.php");
$pagination->setPage($_GET[page]);
$query = "SELECT * FROM {$prefix}users ORDER BY uid ASC LIMIT {$pagination->getLimit()},{$rowsperpage}";
$stmt = $adopts->query($query);
while ($row = $stmt->fetchObject()){
$status = cancp($row->usergroup);
$star = ($status == "yes")?"<img src='icons/star-rating-full.png' border=0' width='15' length='15' /> ":"";
$getavatar = "SELECT * FROM {$prefix}users_profile ORDER BY uid ASC LIMIT {$pagination->getLimit()},{$rowsperpage}";
$stmt2 = $adopts->query($getavatar);
while ($avatarrow = $stmt2->fetchObject()){
$article_content .= "<strong><a href='profile.php?user={$row->username}'>{$star}<img src='{$avatarrow->avatar}' width='25' length='25'>{$row->username}</a></strong><br />";
}
}
$article_content .= "<br />{$pagination->showPage()}";
}
Last edited: