Home Community Mys-Script Creative Off-Topic |
|
|
Thread Tools | Display Modes |
#11
|
||||
|
||||
the forum and main site's members should share the same IDs - I had to do some edits, but everything should be lining up now.
__________________
|
#12
|
||||
|
||||
I thought so too, but then I put it on my site and a member from the site doesn't match the ones on the forum. Mine does.... hmmm
|
#13
|
||||
|
||||
I guess mine is messed up somehow but you can try it on yours. Add this to the query:
Code:
, ".constant("PREFIX")."users.uid Code:
<a href='http://www.ratties.x10.mx/forum/member.php?action=profile&uid={$row->uid}'>{$row->username}</a> |
#14
|
||||
|
||||
Okay, it's like 12:30 here and I think I found the query but I have no idea if I did - where do I put this? :c
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("css/pagination.css"); $query = "SELECT * FROM ".constant("PREFIX")."users ORDER BY uid ASC"; $stmt = $adopts->query($query); $rowsperpage = 15; $pagination = new Pagination($adopts, $query, $rowsperpage, "http://www.".constant("DOMAIN").constant("SCRIPTPATH")."/profile.php"); $pagination->setPage($_GET[page]); $stmt = $adopts->select("users", array(), "1 ORDER BY uid ASC LIMIT {$pagination->getLimit()},{$rowsperpage}"); while ($row = $stmt->fetchObject()){ $status = cancp($row->usergroup); $star = ($status == "yes")?"<img src='templates/icons/star.gif' border=0' /> ":""; $article_content .= "<strong><a href='http://www.ratties.x10.mx/forum/member.php?action=profile&uid='{$row->uid}'>{$star}{$row->username}</a></strong><br />"; } $article_content .= "<br />{$pagination->showPage()}</div>"; }
__________________
|
#15
|
||||
|
||||
I was looking at the wrong page. What you have now should work. Try this
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("css/pagination.css"); $query = "SELECT * FROM ".constant("PREFIX")."users ORDER BY uid ASC"; $stmt = $adopts->query($query); $rowsperpage = 15; $pagination = new Pagination($adopts, $query, $rowsperpage, "http://www.".constant("DOMAIN").constant("SCRIPTPATH")."/profile.php"); $pagination->setPage($_GET[page]); $stmt = $adopts->select("users", array(), "1 ORDER BY uid ASC LIMIT {$pagination->getLimit()},{$rowsperpage}"); while ($row = $stmt->fetchObject()){ $status = cancp($row->usergroup); $star = ($status == "yes")?"<img src='templates/icons/star.gif' border=0' /> ":""; $article_content .= "<strong><a href='http://www.ratties.x10.mx/forum/member.php?action=profile&uid={$row->uid}'>{$star}{$row->username}</a></strong><br />"; } $article_content .= "<br />{$pagination->showPage()}</div>"; } |
#16
|
||||
|
||||
Still not working. :/ I don't know how hard it is fetch the id.
__________________
|
#17
|
||||
|
||||
It should already be fetching it.
|
#18
|
||||
|
||||
It's probably fetching, it just isn't inserting it into the URL.
http://www.ratties.x10.mx/forum/memb...n=profile&uid= <-- this is what I've been getting every time. I removed the quotes around the id thing, and for some reason it was kinda working then - the ids were showing up, but everything went wonky.
__________________
|
#19
|
||||
|
||||
Show me it again... what you have now?
I have this and it works Code:
$stmt = $adopts->select("users", array(), "1 ORDER BY uid ASC LIMIT {$pagination->getLimit()},{$rowsperpage}"); while ($row = $stmt->fetchObject()){ $status = cancp($row->usergroup); $star = ($status == "yes")?"<img src='templates/icons/star.gif' border=0' /> ":""; $article_content .= "<strong><a href='http://taleofdragons.net/forum/member.php?action=profile&uid={$row->uid}'>{$star}{$row->username}</a></strong><br />"; } Last edited by SilverDragonTears; 04-20-2012 at 10:51 PM. |
#20
|
||||
|
||||
Code:
} else{ // 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("css/pagination.css"); $query = "SELECT * FROM ".constant("PREFIX")."users ORDER BY uid ASC"; $stmt = $adopts->query($query); $rowsperpage = 15; $pagination = new Pagination($adopts, $query, $rowsperpage, "http://www.".constant("DOMAIN").constant("SCRIPTPATH")."/profile.php"); $pagination->setPage($_GET[page]); $stmt = $adopts->select("users", array(), "1 ORDER BY uid ASC LIMIT {$pagination->getLimit()},{$rowsperpage}"); while ($row = $stmt->fetchObject()){ $status = cancp($row->usergroup); $star = ($status == "yes")?"<img src='templates/icons/star.gif' border=0' /> ":""; $article_content .= "<strong><a href='http://www.ratties.x10.mx/forum/member.php?action=profile&uid='{$row->uid}'>{$star}{$row->username}</a></strong><br />"; } $article_content .= "<br />{$pagination->showPage()}</div>"; } http://www.ratties.x10.mx/profile.php member list I can remove the quotes again and show you how it went.
__________________
|
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
problem with pagination or profile.php | kristhasirah | Questions and Supports | 0 | 01-16-2013 04:59 PM |
help me with levelup.php | Sensacionsk8 | Questions and Supports | 0 | 02-23-2011 05:48 PM |
Pagination/ My Adopts Page | Missy Master | Suggestions and Feature Requests | 13 | 01-23-2011 08:37 PM |
adopt.php pagination | cetroline | Questions and Supports | 5 | 12-13-2010 06:41 PM |
pagination for my adopts | redheadturkey | Questions and Supports | 18 | 05-01-2010 10:45 AM |
What's New? |
What's Hot? |
What's Popular? |