0) {
While ($row = mysql_fetch_assoc($result)) {
$pwrlist[$row['id']] = $row['power'];
}
}
$sql = "SELECT id, alias FROM char_main WHERE id != $char";
$result = mysql_query($sql) or die(mysql_error());
if (mysql_num_rows($result) > 0) {
$row = mysql_fetch_assoc($result);
$charlist[$row['id']] = $row['alias'];
}
if ($char != '0') {
$sql = "SELECT c.alias, c.real_name AS name, c.align, l.lair_addr
AS address, z.city, z.state, z.id AS zip FROM char_main c,
char_lair l, char_zipcode z WHERE z.id = l.zip_id AND
c.lair_id = l.id AND c.id = $char";
$result = mysql_query($sql) or die(mysql_error());
$ch = mysql_fetch_assoc($result);
if (is_array($ch)) {
$subtype = "Update";
$tablebg = '#EEFFEE';
$subhead = "Edit data for " . $ch['alias'] . " and click
'$subtype Character.'";
$sql = "SELECT p.id FROM char_main c JOIN char_power p
JOIN char_power_link pk ON c.id = pk.char_id
AND p.id = pk.power_id WHERE c.id = $char";
$result = mysql_query($sql) or die(mysql_error());
if (mysql_num_rows($result) > 0) {
While ($row = mysql_fetch_assoc($result)) {
$powers[$row['id']] = 'selected';
}
}
// get list of character's enemies
$sql = "SELECT n.id FROM char_main c JOIN char_good_bad_link gb
JOIN char_main n ON (c.id = gb.good_id AND n.id = gb.bad_id)
OR (n.id = gb.good_id AND c.id = gb.bad_id) WHERE
c.id = $char";
$result = mysql_query($sql) or die(mysql_error());
if (mysql_num_rows($result) > 0) {
While ($row = mysql_fetch_assoc($result)) {
$enemies[$row['id']] = 'selected';
}
}
}
}
?>
Character Editor
