When a player enters a sector (which is the universe table in the DB), the players sector field is updated to the sector they are in. Now what I want to do is compare the planets table and the players table to identify how many planets are in that sector.
If the sector_id field in planets and the sector in players match, then that changes x. Planets in sector: x
This is what I have
Code: Select all
<?php
$plSector = mysql_query("SELECT COUNT(*) AS sector_id FROM planets WHERE sector_id='$sector_id'");
$numPl = mysql_fetch_array($plSector);
$sectorPl = $numPl["sector_id"];
if ($sectorPl == $sector)
{
echo "$sectorPl";
}
if ($sectorPl != $sector)
{
echo "0";
}
?>
Code: Select all
<?php
$plSector = "SELECT * FROM planets s WHERE EXISTS ( SELECT * FROM players ss WHERE (sector)=(s.sector_id))";
$plCount = mysql_query($plSector) or die(mysql_error());
echo "$plCount";
?>
Code: Select all
<?php
$sql = "SELECT * FROM players";
$user_query = mysql_query($sql);
while ($row = mysql_fetch_array($user_query))
{
$id = $row["id"];
$shipname = $row["shipname"];
$username = $row["username"];
$level = $row["level"];
$exper = $row["exper"];
$rank_lvl = $row["rank_lvl"];
$rank = $row["rank"];
$credits = $row["credits"];
$tokens = $row["tokens"];
$iron = $row["iron"];
$gold = $row["gold"];
$silver = $row["silver"];
$food = $row["food"];
$col = $row["col"];
$hull = $row["hull"];
$engine = $row["engine"];
$power = $row["power"];
$comp = $row["comp"];
$sensors = $row["sensors"];
$beam = $row["beam"];
$torp_launch = $row["torp_launch"];
$torp = $row["torp"];
$shields = $row["shields"];
$damage = $row["damage"];
$sector = $row["sector"];
$pl_create = $row["pl_create"];
$last_login = $row["last_login"];
$score = $row["score"];
$fleet = $row["fleet_id"];
$planets = $row["planets"];
}
Code: Select all
$sqlPl = "SELECT * FROM planets";
$planet_query = mysql_query($sqlPl);
while ($row1 = mysql_fetch_array($planet_query))
{
$planet_id = $row1['planet_id'];
$sector_id = $row1['sector_id'];
$planet_name = $row1['name'];
$planet_size = $row1['planet_size'];
$planet_iron = $row1['iron'];
$planet_gold = $row1['gold'];
$planet_silver = row1['silver'];
$planet_food = $row1['food'];
$planet_col = $row1['colonists'];
$planet_creds = $row1['credits'];
$planet_owner = $row1['owner'];
$planet_fleet = $row1['fleet'];
}