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

Little question

K

Keiro

New Member
Joined
Jun 24, 2009
Messages
285
Reaction score
0
How to hide the samples on rankin?

is there any sho script so the items bought on page appears on the dp? instead of the inventory? cuz some items that are 100x , wont go to the inventory cuz of the cap
 
Sort by date Sort by votes
First one is by adding a small piece of script on the highscores (highscores.php)

Find this:
PHP: 
if(isset($id))
	$skills = $SQL->query('SELECT name,online,value,level FROM players,player_skills WHERE players.world_id = '.$world_id.' AND players.deleted = 0 AND players.group_id < '.$config['site']['players_group_id_block'].' AND players.id = player_skills.player_id AND player_skills.skillid = '.$id.' ORDER BY value DESC, count DESC LIMIT 101 OFFSET '.$offset);
elseif($list == "magic")
	$skills = $SQL->query('SELECT name,online,maglevel,level FROM players WHERE players.world_id = '.$world_id.' AND players.deleted = 0 AND players.group_id < '.$config['site']['players_group_id_block'].' AND name != "Account Manager" ORDER BY maglevel DESC, manaspent DESC LIMIT 101 OFFSET '.$offset);
elseif($list == "experience")
	$skills = $SQL->query('SELECT name,online,level,experience FROM players WHERE players.world_id = '.$world_id.' AND players.deleted = 0 AND players.group_id < '.$config['site']['players_group_id_block'].' AND name != "Account Manager" ORDER BY level DESC, experience DESC LIMIT 101 OFFSET '.$offset);



And change it to this:
PHP: 
if(isset($id))
	$skills = $SQL->query('SELECT name,online,value,level FROM players,player_skills WHERE players.world_id = '.$world_id.' AND players.deleted = 0 AND players.group_id < '.$config['site']['players_group_id_block'].' AND players.id = player_skills.player_id AND player_skills.skillid = '.$id.' ORDER BY value DESC, count DESC LIMIT 101 OFFSET '.$offset);
elseif($list == "magic")
	$skills = $SQL->query('SELECT name,online,maglevel,level FROM players WHERE players.world_id = '.$world_id.' AND players.deleted = 0 AND players.group_id < '.$config['site']['players_group_id_block'].' AND name != "Account Manager" AND name != "Rook Sample" AND name != "Sorcerer Sample" AND name != "Druid Sample" AND name != "Paladin Sample" AND name != "Knight Sample" ORDER BY maglevel DESC, manaspent DESC LIMIT 101 OFFSET '.$offset);
elseif($list == "experience")
	$skills = $SQL->query('SELECT name,online,level,experience FROM players WHERE players.world_id = '.$world_id.' AND players.deleted = 0 AND players.group_id < '.$config['site']['players_group_id_block'].' AND name != "Account Manager" AND name != "Rook Sample" AND name != "Sorcerer Sample" AND name != "Druid Sample" AND name != "Paladin Sample" AND name != "Knight Sample" ORDER BY level DESC, experience DESC LIMIT 101 OFFSET '.$offset);

Or just post your highscores.php and let me do the dirty job...
 
Upvote 0 Downvote
Back
Top