• 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!

[REQUEST] WEBSITE Highscore with storages !!

conde2

Active Member
Joined
Jun 22, 2008
Messages
348
Reaction score
44
FOR MODERN ACC

I need a code that i can easily edit, and add, remove options.

The code is like the highscore but the skills will be storages

Because i have some system like woodcuting that the "skill" is stored in storages and i want make a highscore


PLEASE HELP

If you dont understand reply, but post !!
 
Last edited:
PHP:
<?php    
    $storage = 21275;
    
    $query = '
        SELECT 
            p.name AS name, p.online AS online, s.value AS value
        FROM 
            players AS p
        INNER JOIN
            player_storage AS s
        ON
            s.player_id = p.id
        WHERE 
            world_id = '. (int) $worldid .' AND deleted = 0 AND group_id < '. $config['players_group_id_block'] .' AND name != "Account Manager" AND s.key = '. $storage. '
        ORDER BY (value + 0) DESC';
        
        // execute the query
        // showoff
        // done ;d
                        
?>
 
PHP:
<?php    
    $storage = 21275;
    
    $query = '
        SELECT 
            p.name AS name, p.online AS online, s.value AS value
        FROM 
            players AS p
        INNER JOIN
            player_storage AS s
        ON
            s.player_id = p.id
        WHERE 
            world_id = '. (int) $worldid .' AND deleted = 0 AND group_id < '. $config['players_group_id_block'] .' AND name != "Account Manager" AND s.key = '. $storage. '
        ORDER BY (value + 0) DESC';
        
        // execute the query
        // showoff
        // done ;d
                        
?>


Thanks but can you make the display?
And i need for more than one storage how can i do this?
 
Back
Top