'; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo '
'; echo '
'.$kingdomName.'
'; echo '
'; $conditions = "WHERE id='$kingdom'"; $leader = getInfo(leader,kingdoms,$conditions); $consort = getInfo(consort,kingdoms,$conditions); $consortName = getInfo(username,users,"WHERE id='$consort'"); $leaderName = getInfo(username,users,"WHERE id='$leader'"); if (($leader) && (!admin($leader))) { echo 'Lead by '; if (getInfo(sex,users,"WHERE id='$leader'") == "m") echo "King "; else echo "Queen "; echo $leaderName; if ($consort) { echo ' and '; if (getInfo(sex,users,"WHERE id='$consort'") == "m") echo "King "; else echo "Queen "; echo $consortName; } echo '
'; } $children = getInfo(children,kingdoms,$conditions); if ($children) { echo "Princes/Princesses : "; $children = explode('.',$children); $numChildren = count($children); for ($i = 0;$i < $numChildren;$i++) { $child = $children[$i]; $children[$i] = getInfo(username,users,"WHERE id='$child'"); } $children = implode(', ',$children); echo $children.'

'; } $time = time() - (3600 * 24 * 7); $citizens = numRowsConditions(users,"WHERE nationality='$kingdom' and status!='dead' and logged>='$time' and id!='$leader'"); $conquered = getInfo(conquered,kingdoms,$conditions); if (!$conquered) echo 'There are currently '.$citizens.' active citizens. [Apply for Citizenship]

'; else { if ($conquered == "_fire_") echo '*'.$kingdomName.' has been destroyed. The capital was burnt to the ground.*

'; else echo '*'.$kingdomName.' has been conquered by '.$conquered.'*

'; } $description = getInfo(description,kingdoms,$conditions); echo $description; echo '
'; echo '

'; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; $result = getRows(towns,"WHERE kingdom='$kingdom'"); while ($row = mysql_fetch_array($result)) { $name = stripslashes($row['name']); $type = $row['type']; $id = $row['id']; echo ''; echo ''; $counter = numRowsConditions(places,"WHERE town='$id'"); echo ''; echo ''; echo ''; } echo ''; echo '
'; echo 'Town'; echo ''; echo '
Type
'; echo '
'; echo 'Buildings'; echo '
'; echo ''.$name.''; echo ''; echo '
'.capitalize($type).'
'; echo '
'; echo '
'.$counter.'
'; echo '
'; echo ''; } else { echo '
'; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo '
'; echo '
Error
'; echo '
'; echo '
You have not specified a kingdom to view.
'; echo '
'; } ?>