zoneslevels.php

<?php
$Title = "Populated Zones By Level";
include('./includes/config.php');
include($includes_dir . 'constantes.php');
include($includes_dir . 'headers.php');
include($includes_dir . 'mysql.php');
include($includes_dir . 'functions.php');

print "<div class='container zone-levels'>";
print "<p>The suggested levels are approximate based upon the levels of the majority of creatures found in the zone. Except for the newbie zones, this assumes that you will hunt with a group. Most zones also have higher and lower level roaming npcs, and are selectively hunted at different levels.</p>";
if ($SortZoneLevelList == true) {
	print "<p>Zones are sorted following average npc's levels. If a newbie zone contains high level friendly guards, they count in the average level and false the sort.</p>";
}
print "<p>Follow the links to get more complete descriptions for the individual zones.</p>";
// Tweak the second SQL query to your needs, if for example you added a field for trigger npcs, or guards, filter it !
// In the default config, invisible men and level 1 npcs are ignored (there's enough lvl 2-5 npcs in newbie zones to have them marked at that lvl)

$levels     = array();
$LevelRange = 0;
for ($i = 0; $i <= ($ServerMaxNPCLevel / 5); $i++) {
	$LevelRange += 5;
	$levels[$i] = $LevelRange;
}
// Set $lowlimit to the minimum of NPCS signifying the zones is populated for that lvl.
// Ex : $lowlimit=5 => if a zone has less than 5 npcs of a level, they will be ignored
$lowlimit      = 5;
// $MinimumNpcLvl allows you to remove low lvl npcs, such as invisible men used for triggers, set to 0 if not used
$MinimumNpcLvl = 1;
$zones         = array();
$query         = "SELECT $tbzones.*
        FROM $tbzones";
$v             = "WHERE";
foreach ($IgnoreZones as $zid) {
	$query .= " $v $tbzones.short_name!='$zid'";
	$v = " AND ";
}
$query .= " ORDER BY $tbzones.long_name ASC";
$result = mysqli_query($db, $query) or message_die('zoneslevels.php', 'MYSQL_QUERY', $query, mysqli_error($db));
$cpt = 0;
while ($res = mysqli_fetch_array($result)) {
	$zones[$cpt]["shortname"] = $res["short_name"];
	$zones[$cpt]["longname"]  = $res["long_name"];
	$zones[$cpt]["npcs"]      = 0;
	$zones[$cpt]["val"]       = 0;
	$query                    = "SELECT $tbnpctypes.level
          FROM $tbnpctypes,$tbspawn2,$tbspawnentry
          WHERE $tbspawn2.zone='" . $res["short_name"] . "'
          AND $tbspawnentry.spawngroupID=$tbspawn2.spawngroupID
          AND $tbspawnentry.npcID=$tbnpctypes.id";
	if ($HideInvisibleMen == true) {
		$query .= " AND $tbnpctypes.race!=127 AND $tbnpctypes.race!=240";
	}
	$query .= " AND $tbnpctypes.level>$MinimumNpcLvl
          GROUP BY $tbnpctypes.id";
	$result2 = mysqli_query($db, $query) or message_die('zoneslevels.php', 'MYSQL_QUERY', $query, mysqli_error($db));
	while ($row = mysqli_fetch_array($result2)) {
		$lvl = floor($row["level"] / 5);
		$zones[$cpt][$lvl]++;
		$zones[$cpt]["npcs"]++;
	}
	$cpt++;
}

// Edit config.php and put FALSE to that next variable if you don't want to sort the zones
if ($SortZoneLevelList == true) {
	for ($i = 0; $i < $cpt; $i++) {
		if ($zones[$i]["npcs"] > 0) { // populated
			$zones[$i]["val"] = 0;
			$nb               = 0;
			foreach ($levels as $lkey => $lval) {
				if ($zones[$i][$lkey] > $lowlimit) {
					$zones[$i]["val"] += $levels[$lkey] * $zones[$i][$lkey];
					$nb += $zones[$i][$lkey];
				}
			}
			if ($nb == 0) {
				$zones[$i]["val"] = 999;
			} else {
				$zones[$i]["val"] = $zones[$i]["val"] / $nb;
			}
		}
	}
	// lets sort all that data
	$max = $cpt;
	do {
		$max--;
		$end = true;
		for ($z = 0; $z < $max; $z++) {
			if ($zones[$z]["val"] > $zones[$z + 1]["val"]) {
				$end           = false;
				$myzone        = $zones[$z];
				$zones[$z]     = $zones[$z + 1];
				$zones[$z + 1] = $myzone;
			}
		}
	} while ($end == false);
}


print "<div class='table-wrapper'><table border=0 width=100% class='sticky-header'><tr valign=top><td width=100%>";
print "<thead><tr><th>Name</th>
       <th class='tab_title short-name'>Short name</th>";
print "<td class=tab_title>Avg Lvl</td>";
$LevelMax = 0;
for ($i = 0; $i <= ($ServerMaxNPCLevel / 5); $i++) {
	$LevelMax += 5;
	$LevelMin = $LevelMax - 4;
	print "<th class=tab_title width='4%'>" . $LevelMin . " - " . $LevelMax . "</th>";
}
print "</tr></thead>";


//print "<pre>";
//print "\r\n";
//print print_r($levels);
//print "</pre>";

$nb = 0;
for ($i = 0; $i <= $cpt; $i++) {
	if ($zones[$i]["npcs"] > $lowlimit) {
		$nb++;
		if (modulo($nb, 10) == 1) {
			print "<tr>
                       <td class=tab_title width='10%'>Name</td>
                       <td class='tab_title short-name'>Short name</td>";
			if ($SortZoneLevelList == true) {
				print "<td class=tab_title>Avg Lvl</td>";
			}
			foreach ($levels as $key2 => $val2) {
				print "<td class=tab_title>$val2</td>";
			}
			print "</tr>";
		}
		print "<tr>
           <td width='200'><a href=zone.php?name=" . $zones[$i]["shortname"] . ">" . $zones[$i]["longname"] . "</a></td>
           <td class='short-name'>" . $zones[$i]["shortname"] . "</td>";
		if ($SortZoneLevelList == true) {
			print "<td align=center>" . round($zones[$i]["val"]) . "</td>";
		}
		foreach ($levels as $lkey => $lval) {
			print "<td class = " . $lkey . " align=center width='4%'>";
			if ($zones[$i][$lkey] > $lowlimit) {
				if ($ShowNPCNumberInZoneLevelList == true) {
					print $zones[$i][$lkey];
				} else {
					print "x";
				}
			}
			print "</td>";
		}
	}
}

print "</td></tr></table></div></div></div>";

include($includes_dir . "footers.php");