AAC Show Task points

[Kownikuzyt]

Hello, I have a problem with showing player quest points.
What I have come to:

<?php
$limitt = 3;

$skills = mysql_select_multi("SELECT player_storage.player_id, player_storage.key, player_storage.value, players.id, players.name FROM player_storage, players WHERE player_storage.key = 2500 ORDER BY player_storage.value ASC LIMIT $limitt");

$number_of_rows = 0;
foreach($skills as $skillss) {
$number_of_rows++;
echo '<a href="characterprofile.php?name='.urlencode($skillss['name']).'" class="menu">'.$skillss['name'].'</a><br>';
echo '<em class="style2">Paw & Fur Points: <b>'.urlencode($skillss['player_storage'.'value']).'</b></em></li><br />';
}
?>

player_storage.key = 2500 <--- Task ID.

Missing:

player_storage.value <--- Point value (9 shown in the image)

Post automatically merged: Aug 30, 2021

Solved:

$skills = mysql_select_multi("SELECT player_storage.player_id, player_storage.key, player_storage.value, players.id, players.name FROM player_storage, players WHERE player_storage.player_id = players.id AND player_storage.key = 2500 ORDER BY player_storage.value DESC LIMIT $limitt");