AAC Geisor Top players

[Niioxce]

Anyone know how i can turn down the numbers? So it's in 4 digits and M unit.
Php code for topexperience

            <div class="Box">
                <div class="TopExperience">
                </div>
                <?PHP
                    $divid = 31;


                
                    $number_of_people = 0;
                    $skills = $SQL->query('SELECT name,online,level,experience,vocation,promotion FROM players WHERE players.deleted = 0 AND players.group_id NOT IN ('.implode(',', $config['site']['groups_hidden']).')  AND name != "Account Manager" ORDER BY level DESC, experience DESC LIMIT 10;');
                        foreach($skills as $skill) {
                        
                            if($divid == 40) $players_skill .= '<div class="ItemLast">';
                                $players_skill .= '<div class="Item" onclick="location.href=\'?subtopic=characters&name='.urlencode($skill['name']).'\';" '.$divid.')" ('.$divid.')"><div class="Img"></div><div id="'.$divid.'txtL" class="TextL">'
                                .($skill['online']>0 ? "<font color=\"green\">".$skill['name']."</font>" : "".$skill['name']."").'
                                </div><div id="'.$divid.'txtR" class="TextR">'.$skill['level'].'</div></div>';
                            if($divid == 40) $players_skill .= '</div>';
                            $divid++;
                        }
                    echo "$players_skill";

                ?>
                
            </div>

Image of how it's not suposed to look


And this is how i want it to be.

 

[Snavy]

You could use number_format( (float)(level / 1000000), 1, '.', '' )
Result : 135.3M

number_format((float)( $skill['level'] /1000000), 1, '.', '')."M"

Show a number to two decimal places

What's the correct way to round a PHP string to two decimal places? $number = "520"; // It's a string from a database $formatted_number = round_to_2dp($number); echo $formatted_number; The output

stackoverflow.com

 

[Niioxce]

Hmm, i'm pretty bad at php and i can't even seem to understand my own script lmao. Could you break it down for me?

 

[Snavy]

Hmm, i'm pretty bad at php and i can't even seem to understand my own script lmao. Could you break it down for me?

Ok, modified it for you.

Try this:

<div class="Box">
    <div class="TopExperience"></div>
    <?PHP

        // html div id ( not sure why you have this.. )
        $divid = 31;
        $number_of_people = 0;

        /* Fetch top 10 players from `players` table */
        $players = $SQL->query('SELECT `name`,`online`,`level`,`experience`,`vocation`,`promotion`
            FROM `players` WHERE `players`.`deleted` = 0 AND `players`.`group_id`
            NOT IN ('.implode(',', $config['site']['groups_hidden']).')  AND `name` != "Account Manager"
            ORDER BY `level` DESC `experience` DESC LIMIT 10;');

        // For every player
        foreach($players as $player) {

            if($divid == 40) {
                $players_skill .= '<div class="ItemLast">';
            }

            $players_skill .= '
                <div class="Item" onclick="location.href=\'?subtopic=characters&name='.urlencode($player['name']).'\';" '.$divid.')" ('.$divid.')">
                    <div class="Img"></div>
                    <div id="'.$divid.'txtL" class="TextL">'
                        .($player['online']>0 ? "<font color=\"green\">".$player['name']."</font>" : "".$player['name']."").'
                    </div>
                    <div id="'.$divid.'txtR" class="TextR">'.number_format( (float)($player['level'])/1000000, 1, '.', '').'M </div>
                </div>';

            if($divid == 40) {
                $players_skill .= '</div>';
            }

            $divid++;
        }
        echo "$players_skill";

    ?>

</div>

 

[Niioxce]

Didnt seem to work. I tried changing from $player to $skill instead and that also didnt seem to work.

 

[oen432]

number_format( (float)($player["level"])/1000000, 1, ".", "")
Looks like formating issue, if that didn't help then you should look at PHP errors.

 

[Niioxce]

Fixed it by just doing this.

                <?PHP
                    $divid = 31;
                    $number_of_people = 0;
                    $skills = $SQL->query('SELECT name,online,level,experience,vocation,promotion FROM players WHERE players.deleted = 0 AND players.group_id NOT IN ('.implode(',', $config['site']['groups_hidden']).')  AND name != "Account Manager" ORDER BY level DESC, experience DESC LIMIT 10;');
                        foreach($skills as $skill) {
                        
                            if($divid == 40) $players_skill .= '<div class="ItemLast">';
                                $players_skill .= '<div class="Item" onclick="location.href=\'?subtopic=characters&name='.urlencode($skill['name']).'\';"('.$divid.')"('.$divid.')"><div class="Img"></div><div id="'.$divid.'txtL" class="TextL">'
                                .($skill['online']>0 ? "<font color=\"green\">".$skill['name']."</font>" : "".$skill['name']."").'
                                </div><div id="'.$divid.'txtR" class="TextR">'.number_format( (float)($skill['level'])/1000000, 1, '.', '').'M </div></div>';
                            if($divid == 40) $players_skill .= '</div>';
                            $divid++;
                        }
                    echo "$players_skill";

                ?>