[Modern AAC] How to add a new option on Highscores...

[Dantarrix]

Well, i want to add a new options on this, i added a table on my database called football (i have a football level on my server), so i wanted to addn option on "highscores" so let players now who has the best football level....
Here is the highscores.php edited by me, someone can say me what is wrong? When i select "Football Level" on web page, it redirects me to level ranking...:

<?php
require("config.php");
$ide = new IDE;
try {$ide->loadInjections("highscores");} catch(Exception $e) {error($e->getMessage()); }
echo form_open('highscores');
	$uri = $this->uri->segment(5) ? $this->uri->segment(5) : 0;

	if(count($config['worlds']) > 1) {
		echo "<b>World</b>&nbsp;&nbsp;";
		echo "<select name='world'>";
		foreach($config['worlds'] as $id=>$name) {
			if($_POST['world'] == $id)
			echo "<option selected='true' value='$id'>$name</option>";
			else
			echo "<option value='$id'>$name</option>";
		}
		echo "</select>";
	}
	
	echo "&nbsp;&nbsp;<b>Rank of</b>&nbsp;&nbsp;";
	echo "<select name='skill'>";
	echo "<option class='skill' ".set_select('skill', 1, true)." value='level'>Experience</option>";
	echo "<option class='skill' ".set_select('skill', 9)." value='magic'>Magic Level</option>";
	echo "<option class='skill' ".set_select('skill', 10)." value='football'>Football Level</option>";
	echo "<option class='skill' ".set_select('skill', 2)." value='1'>Fist Fighting</option>";
	echo "<option class='skill' ".set_select('skill', 3)." value='2'>Club Fighting</option>";
	echo "<option class='skill' ".set_select('skill', 4)." value='3'>Sword Fighting</option>";
	echo "<option class='skill' ".set_select('skill', 5)." value='4'>Axe Fighting</option>";
	echo "<option class='skill' ".set_select('skill', 6)." value='5'>Distance Fighting</option>";
	echo "<option class='skill' ".set_select('skill', 7)." value='6'>Shielding</option>";
	echo "<option class='skill' ".set_select('skill', 8)." value='7'>Fishing</option>";
	echo "</select>";
	echo " <input type='submit' value='Show'>";

	echo "</form>";

	echo "<h2><center>Ranking of ". (is_numeric($type) ? $skills[$type] : $type) ." on ".$config['worlds'][$world]."</center></h2>";
	
	$i = 1 + $uri;
	echo "<table width='100%'>";
	if(is_numeric($type)) {
		
		echo "<tr><td width='5%'><b><center>*</center></b></td><td width='40%'><center><b>Name</b></center></td><td width='5%'><center><b>Skill</b></center></td></tr>";
		foreach($players as $player) {
			if(in_array($player['name'], $config['newchar_vocations'][0])) continue;
			echo '<tr><td width="5%" align="center">'.$i.'</center></td><td width="40%" align="center"><a href="'.WEBSITE.'/index.php/character/view/'.$player['name'].'" class="'. ($player['online'] ? 'green' : 'red') .'">'.$player['name'].'</a></td><td width="5%" align="center">'.$player['value'].'</td></tr>';
			$i++;
		}
	}else{
		switch($type) {
			case 'level':
			echo "<tr><td width='5%'><b><center>*</center></b></td><td width='40%'><center><b>Name</b></center></td><td width='10%'><center><b>Exp</b></center></td><td width='5%'><center><b>Level</b></center></td></tr>";
			foreach($players as $player) {
				if(in_array($player['name'], $config['newchar_vocations'][0])) continue;
				echo '<tr><td width="5%" align="center">'.$i.'</td><td width="40%" align="center"><a href="'.WEBSITE.'/index.php/character/view/'.$player['name'].'" class="'. ($player['online'] ? 'green' : 'red') .'">'.$player['name'].'</a></td><td width="10%" align="center">'.$player['experience'].'</td><td width="5%" align="center">'.$player['level'].'</td></tr>';
				$i++;
			}
			break;
			case 'magic':
			echo "<tr><td width='5%'><b><center>*</center></b></td><td width='40%'><center><b>Name</b></center></td><td width='10%'><center><b>Magic Level</b></center></td></tr>";
			foreach($players as $player) {
				if(in_array($player['name'], $config['newchar_vocations'][0])) continue;
				echo '<tr><td width="5%" align="center">'.$i.'</td><td width="40%" align="center"><a href="'.WEBSITE.'/index.php/character/view/'.$player['name'].'" class="'. ($player['online'] ? 'green' : 'red') .'">'.$player['name'].'</a></td><td width="10%" align="center">'. $player['maglevel'] .'</td></tr>';
				$i++;	
			}
			break;
			case 'football':
			echo "<tr><td width='5%'><b><center>*</center></b></td><td width='40%'><center><b>Name</b></center></td><td width='10%'><center><b>Football Level</b></center></td></tr>";
			foreach($players as $player) {
				if(in_array($player['name'], $config['newchar_vocations'][0])) continue;
				echo '<tr><td width="5%" align="center">'.$i.'</td><td width="40%" align="center"><a href="'.WEBSITE.'/index.php/character/view/'.$player['name'].'" class="'. ($player['online'] ? 'green' : 'red') .'">'.$player['name'].'</a></td><td width="10%" align="center">'. $player['football'] .'</td></tr>';
				$i++;
			}
			break;
		}	
	}
	echo "</table>";
	echo $this->pagination->create_links();

So, i have the option but its not working on web page (without errors)... ://

 

[Bogart]

Did you add the queries to highscores_models.php?

 

[Dantarrix]

Nope, thank you... I'm recently initializing on this...
P.D.: Can I ask you later if I dont know what queries I need to add? Thank you...

 

[Bogart]

Yes you can.

 

[Dantarrix]

Well, I added them well, now, I have another problem, in Magic Level on highscores, if the player has the minimun level (0), there doesnt appears his level... And appears one "0" after the numeration of players... ://

 

[Bogart]

make everyone football level+1

 

[Dantarrix]

Yep, I did that, but it happens with magic level, how I fix that? ://

Now i want to know how to sort highscores by vocation too..., like this:
mtibia 8.6!
I think it's not too easy... ://

 

[Dantarrix]

Bump!

 

[HeberPcL]

UP.