How to show a users Respect.

[Maestro]

Hello everyone,

I am editing a RevCms theme and tried to make a better me page. On this page I have added pixels,vippoints,respect and giftsgiven to let the user know which stats he/she has. Pixels and Vippoints was easy {pixels} and {shells}. I tried to do this with respects and gifts as well. But since it inst inside the class file it wont work. So tried to add it. Because it loads from the table user_stats. Butthis didnt work.

Does anyone know how to show Respects, Giftsgiven?

Hope to hear from you guys.

-Maestro

 

[Pocket]

Have you Tried Mucking around with a /stats Page? Seeming as that Shows all of that So it might have all the {stuff}

 

[Maestro]

The stats checks the user_stats decedanding, I have no idea how to show it for just the selecter user.

Anyone has an idea?

-Maestrom

 

[Pocket]

@Sledmore

 

[Maestro]

This is the code the Stats page uses for Gifts given:

<!-- / Table center - Geschenke -->
<div id="column" class="column"><div class="habblet-container ">
<div class="cbb clearfix blue ">
<h2 class="title"><span style="float: left;">kados gegeven</span> </h2>
<div align="left">
<table width="100%">

<tr>
<?php

$userstats_a = mysql_query("SELECT * FROM user_stats ORDER BY GiftsGiven DESC LIMIT 5");
while($userstats = mysql_fetch_assoc($userstats_a)){
$row = mysql_fetch_assoc($row = mysql_query("SELECT * FROM users WHERE id = '".$userstats['id']."' LIMIT 5"));

?>

<tr><td width="5px"> </td>
<td width="20px"><img src="<?php echo $avatar; echo $row['look']; ?>&size=s&direction=2&head_direction=2&gesture=sml&size=m" align="left"></td>
<td width="195px"><a href="../home/<?php echo $row['username']; ?>"><b><?php echo $row['username']; ?></b></a><br />
<?php echo $userstats['GiftsGiven']; ?> Kados gegeven</td>
</tr>

<?php } ?>
</table>
</div> </div>

</div>
</div> </div>