• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!
  • If you're using Gesior 2012 or MyAAC, please review this thread for information about a serious security vulnerability and a fix.

AAC Quest Maker have a problem

asdzx123

Member
Joined
Jul 1, 2019
Messages
37
Reaction score
8
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();
Screenshot_1.png

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();
Screenshot_2.png

I hope you understand my words, thank you for reading
Post automatically merged:

bamp
 
Last edited:
OP
OP
asdzx123

asdzx123

Member
Joined
Jul 1, 2019
Messages
37
Reaction score
8
do you mean sorting?
SQL ORDER BY Keyword (https://www.w3schools.com/sql/sql_orderby.asp)

PHP:
$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:

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

New Member
Joined
Mar 24, 2008
Messages
54
Solutions
1
Reaction score
4
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?
 
OP
OP
asdzx123

asdzx123

Member
Joined
Jul 1, 2019
Messages
37
Reaction score
8
I have if I do limit 1 the players with higher experience do not appear why like thisScreenshot_5.png
Post automatically merged:

Please help me for this problem
 
Last edited:
Top