Quote: $query = $db->query("
SELECT u.*, a.*
FROM ".TABLE_PREFIX."myawards a
LEFT JOIN ".TABLE_PREFIX."myawards_users u ON (u.awid=a.awid)
ORDER BY awname ASC
");
while($results = $db->fetch_array($query))
{
$bgcolor = alt_trow();
$user = get_user(intval($results['awuid']));
$profilelink = build_profile_link($user['username'],$user['uid']);
$awbody .="<tr>
<td class=\"{$bgcolor}\" align=\"center\"><img src=\"uploads/awards/".$results['awimg']."\" alt=\"".$results['awname']."\" width=\"32px\" /></td>
<td class=\"{$bgcolor}\" align=\"center\"><img src=\"uploads/awards/".$results['awimg']."\" alt=\"".$results['awname']."\" /></td>
<td class=\"{$bgcolor}\"><strong><a href=\"myawards.php?awid={$results['awid']}\">{$results['awname']}</a></strong><br />{$results['awdescr']}</td>
<td class=\"{$bgcolor}\" align=\"center\">{$profilelink}</td>
That $profile link puts one next next to award
eg.
I want to turn this;
Admin Award - Phil
Admin Award - dreamweaver
into this;
Admin Award - Phil, dreamweaver
I'm not too bothered about it showing as guest when no-one has award. The last section is 'Users Who Have Already Recieved Awards', so I'm looking to try and get it to show a bit like who's online list
Well there supposed to be demo in this forum right?!
Anyway my few points(for Postbits)
1. a gap between awards would look better
2. I don't know if there is, but a link to "awards" page on the awards images would be needed.(I made the awards work on my forum myself without any plugin, but I got stuck when I came to parse html!)
3. Please show some live demo(not only pics)
Thanks.
Finally!(Well not that it took a long time just been waiting for it
).
Great work once again Labrocca.
Live demo. well i am running it. But i screwed with it and sort of have it duplicated. I want to create a specific idea so take that aside yes i have a working demo. Click my sig. 2 easy.
Its for flame wars on my forum.
Just so you know.
Sorry here is a better link.
http://www.ftw.net.au/showthread.php?tid...12#pid4212 look at contracts bit. He has 4 wins and 4 trophies although i need to make new trohies of course.
Yeah I will have live demo here soon enough.
Quote:'Users Who Have Already Recieved Awards',
You can use the query from the ALL function.
Quote:1. a gap between awards would look better
I still have to experiment with layout a bit. It really can depend too on the images you use. Shouldn't be hard to use a non-breaking-space between images or possible a simple hspace tag too.
Quote:2. I don't know if there is, but a link to "awards" page on the awards images would be needed.
I don't agree. That's a lot of extra links on the page for nothing. From profile of any user you can go to their awards details page.
(Oct 12, 2008 02:59 AM)labrocca Wrote: [ -> ]Yeah I will have live demo here soon enough.
Quote:'Users Who Have Already Recieved Awards',
You can use the query from the ALL function.
Still the same. It's like {$profilelink} just puts one name to each award. I'll try and figure it out
Thank you labrocca teşşekürler
Great work on this can't wait to try it!
