AAC Quest Maker have a problem

[asdzx123]

Hello
Why when changing the limit to number 1, the first player does not appear at the top, on the contrary, the second player appears at the top, where is the situation?

$players = $SQL->query('SELECT * FROM players WHERE deleted = 0 AND group_id = 1 AND account_id != 1 LIMIT 2; ')->fetchAll();

When it is changed to Limit 1, the first player like appearance in limit 2 does not appear
Tatamoto does not appear when Limit 1 . is changed

$players = $SQL->query('SELECT * FROM players WHERE deleted = 0 AND group_id = 1 AND account_id != 1 LIMIT 1; ')->fetchAll();

I hope you understand my words, thank you for reading

Post automatically merged: Sep 5, 2022

bamp

 

[Jizzor]

do you mean sorting?
SQL ORDER BY Keyword (https://www.w3schools.com/sql/sql_orderby.asp)

$players = $SQL->query('SELECT * FROM players WHERE deleted = 0 AND group_id = 1 AND account_id != 1 ORDER BY ColumnName ASC LIMIT 1 ; ')->fetchAll();

 

[asdzx123]

do you mean sorting?
SQL ORDER BY Keyword (https://www.w3schools.com/sql/sql_orderby.asp)

$players = $SQL->query('SELECT * FROM players WHERE deleted = 0 AND group_id = 1 AND account_id != 1 ORDER BY ColumnName ASC LIMIT 1 ; ')->fetchAll();

There is no column If there is a column I was adding but nothing sees it

Post automatically merged: Sep 6, 2022

This table >>

<?PHP
if(!defined('INITIALIZED'))
exit;

$tasks = $config['site']['tasks'];

$tasks_list = $tasks;


// $nr_gracza = 0;
$players = $SQL->query('SELECT * FROM players WHERE deleted = 0 AND group_id = 1 AND account_id != 1 ORDER BY percent ASC LIMIT 1 ; ')->fetchAll();

$data .= '
<center>
<TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=98%>
</center>
<tr bgcolor="'.$config['site']['vdarkborder'].'">
<TD align="left" COLSPAN=3 CLASS=white width="100%" height="25px">
<B>Tasks Ranking - Top 30 Tasks Makers on '.$config['server']['serverName'].'</B>
</TD>
</tr>';

foreach ($players as $player)
{
$number_of_rows = 0;
$ilosc_taskow_wykonanych = 0;
$ilosc_taskow = 0;
$i = 1;
foreach($tasks_list as $storage => $procent)
{
$ilosc_taskow++;
$task_baza = $SQL->query("SELECT * FROM player_storage WHERE player_id = " . $player['id'] . " AND key = '" . $tasks_list[$storage] . " LIMIT 1;'")->fetchAll();
foreach($task_baza as $idd)
$ilosc_taskow_wykonanych++;
}

$ilosc_procent = ($ilosc_taskow_wykonanych / $ilosc_taskow) * 100;
$player_result[$player['name']] = $ilosc_procent;
}

$players_results = arsort($player_result);
foreach($player_result as $player => $procent)
{
if(is_int($number_of_rows / 2)) { $bgcolor = $config['site']['darkborder']; } else { $bgcolor = $config['site']['lightborder']; } $number_of_rows++;
$data .= '
<TR BGCOLOR="' . $bgcolor . '">
<TD WIDTH="5%" height="25px"><center>'.$i.'.</center></td>
<TD WIDTH="35%" height="25px"><a href="?subtopic=characters&name=' . urlencode($player) . '"> <b>' . $player . ' </a></b></td>
<TD WIDTH="60%" height="25px"><div style="width:100%;height:15px;background-color:white;">
<div title="' . number_format($procent, 0) . '%" style="position:absolute;margin-left:25%;"><B>' . number_format($procent, 0) . '%</b></div>
<div style="width:' . $procent . '%;height:15px;background-image: url(/images/loading.jpg);"></div>
</div>
</TR>
';
$i++;
}
$data .= '
</table>';
$main_content .= $data;
?>

 

[Jizzor]

I'm sorry but I have no idea what you're asking for, do you mean the players should get sorted by percent but it doesnt output correctly?

 

[asdzx123]

I have if I do limit 1 the players with higher experience do not appear why like this

Post automatically merged: Sep 6, 2022

Please help me for this problem