#1
|
||||
|
||||
How to enable sig images
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] 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 by StarGirl; 04-01-2012 at 05:14 AM. |
#2
|
||||
|
||||
Anyone? :/
|
#3
|
||||
|
||||
Well just get rid of these from your profile.php and you will find users showing up only once:
PHP Code:
__________________
Mysidia Adoptables, a free and ever-improving script for aspiring adoptables/pets site. |
#4
|
||||
|
||||
I already fixed the showing up twice problem by changing it to..
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://{$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()){ $avatar = ($avatarrow->avatar); } $article_content .= "<strong><a href='profile.php?user={$row->username}'>{$star}<img src='{$avatar}' width='25' length='25'>{$row->username}</a></strong><br />"; } $article_content .= "<br />{$pagination->showPage()}"; } |
#5
|
||||
|
||||
I see, looks like you did not retrieve the avatars from database successfully. Since usergroup and avatar info are stored in separate database tables, you will need to use the JOIN feature for your mysql query. The new Mys v1.3.1 database engine makes it all easy, I will show you how it will work when the new version is released.
__________________
Mysidia Adoptables, a free and ever-improving script for aspiring adoptables/pets site. |
#6
|
||||
|
||||
Join feature ? So you mean I put a JOIN in the query?
Last edited by StarGirl; 04-04-2012 at 10:51 AM. |
#7
|
||||
|
||||
Well the JOIN keyword is used when you attempt to grab data from multiple database tables. The new script for Mys v1.3.1 will introduce a database class and a method called join() which makes things easier. I will show you an example later tonight after I return from classes.
__________________
Mysidia Adoptables, a free and ever-improving script for aspiring adoptables/pets site. |
#8
|
||||
|
||||
I think i'll just wait for v1.3.1, this is confusing for me. :P
|
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
GD images | mapleblade | Mys v1.2.x Mods | 11 | 03-04-2012 04:39 AM |
breeding enable alt problem | SilverDragonTears | Questions and Supports | 0 | 11-30-2011 10:32 PM |
no images | RoconzaArt | Questions and Supports | 1 | 03-13-2011 10:39 AM |
I cant see the images | zKaZy | Questions and Supports | 11 | 03-28-2010 11:49 AM |
Images not showing | Tequila | Questions and Supports | 22 | 03-07-2009 07:15 AM |
What's New? |
What's Hot? |
What's Popular? |