Hall Of Fame(USER REMOVAL)

[Dustin Rohel]

Hey everyone, I'm trying to figure out how to remove certain users from showing up on the Hall Of Fame, such as my NPC's. But can't figure out how, if someone could kindly help me out that'd be awesome.

 

Thanks!

[corruptcity || skalman]

Hey, in the query you can do WHERE u.user_level = 1 or  u.userid no IN (1,2,3 other staff ids) or u.userid != 1 etc.
The section of code your looking for is this

if(in_array($_GET['action'], $hofqtwo)) {
    if($_GET['action'] == 'total') {
        $us = '(`strength` + `agility` + `guard` + `speed`+ `physical` + `mental` + `endurance`)';
    }
    else {
        $us = '`' . $_GET['action'] . '`';
    }

    $q = $db->query("SELECT u.`userid`, `laston`, `gender`, `donatordays`,
                     `level`, `money`, `diamonds`, `username`, cartel, c.`cartel_PRESIDENT`, c.`cartel_PREF`,
                     `strength`, `agility`, `guard`, `speed`, `physical`, `mental`, `endurance`
                     FROM `users` AS `u`
                     INNER JOIN `userstats` AS `us`
                     ON `u`.`userid` = `us`.`userid`
                     LEFT JOIN `cartels` AS `c`
                     ON `c`.`cartel_ID` = `u`.`cartel`
                     WHERE `u`.`user_level` = 1
                     $myf
                     ORDER BY {$us} DESC, `u`.`userid` ASC
                     LIMIT 25");
}

Hope this helps

 

Edited January 30, 2024 by corruptcity || skalman

[Dustin Rohel]

Hi, thanks for the code. where would i place this?

[corruptcity || skalman]

no that the bit of code your looking for in what you already have or if you can't find what I've put just look for the

 $q = $db->query(