Dustin Rohel Posted January 30 Share Posted January 30 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! Quote Link to comment Share on other sites More sharing options...
corruptcity || skalman Posted January 30 Share Posted January 30 (edited) 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 by corruptcity || skalman Quote Link to comment Share on other sites More sharing options...
Dustin Rohel Posted January 30 Author Share Posted January 30 Hi, thanks for the code. where would i place this? Quote Link to comment Share on other sites More sharing options...
corruptcity || skalman Posted January 30 Share Posted January 30 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( Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.