<?php
  require('config.php');
  
  foreach ($\_POST\; as$key => $value)\; \{\; \$\$key\; =$value;
  }
  
  $conn\; =\; mysql\_connect(SQL\_HOST,\; SQL\_USER,\; SQL\_PASS)\; or\; die(\text{'}Could\; not\; connect\; to\; MySQL\; database.\; \text{'}\; .\; mysql\_error());\; mysql\_select\_db(SQL\_DB,$conn);
  
  switch ($action)\; \{\; case\; "Create\; Character":$sql = "INSERT IGNORE INTO char_zipcode (id, city, state) " .
             "VALUES ('$zip\text{'},\; \text{'}$city', '$state\text{'})";$result = mysql_query($sql)\; or\; die(mysql\_error());$sql = "INSERT INTO char_lair (id, zip_id, lair_addr) " .
             "VALUES (NULL, '$zip\text{'},\; \text{'}$address')";
      $result\; =\; mysql\_query($sql) 
        or die(mysql_error());
      if ($result)\; \{$lairid = mysql_insert_id($conn);\; \}$sql = "INSERT INTO char_main (id,lair_id,alias,real_name,align) " .
             "VALUES (NULL, '$lairid\text{'},\; \text{'}$alias', '$name\text{'},\; \text{'}$align')";
      $result\; =\; mysql\_query($sql) 
        or die(mysql_error());
      if ($result)\; \{$charid = mysql_insert_id($conn);\; \}\; if\; ($powers != "") {
        $val\; =\; "";\; foreach\; ($powers as $key\; =>$id) {
          $val[]\; =\; "(\text{'}$charid', '$id\text{'})";\; \}$values = implode(',', $val);$sql = "INSERT IGNORE INTO char_power_link (char_id, power_id) " .
               "VALUES $values";$result = mysql_query($sql)\; or\; die(mysql\_error());\; \}\; if\; ($enemies != '') {
        $val\; =\; "";\; foreach\; ($enemies as $key\; =>$id) {
          $val[]\; =\; "(\text{'}$charid', '$id\text{'})";\; \}$values = implode(',', $val);\; if\; ($align = 'good') {
          $cols\; =\; \text{'}(good\_id,\; bad\_id)\text{'};\; \}\; else\; \{$cols = '(bad_id, good_id)';
        }
        $sql\; =\; "INSERT\; IGNORE\; INTO\; char\_good\_bad\_link$cols " .
               "VALUES $values";$result = mysql_query($sql)\; or\; die(mysql\_error());\; \}$redirect = 'charlist.php';
      break;
  
    case "Delete Character":
      $sql\; =\; "DELETE\; FROM\; char\_main,\; char\_lair\; "\; .\; "USING\; char\_main\; m,\; char\_lair\; l\; "\; .\; "WHERE\; m.lair\_id\; =\; l.id\; AND\; m.id\; =$cid";
      $result\; =\; mysql\_query($sql) 
        or die(mysql_error());
  
      $sql\; =\; "DELETE\; FROM\; char\_power\_link\; WHERE\; char\_id\; =$cid";
      $result\; =\; mysql\_query($sql) 
        or die(mysql_error());
  
      $sql\; =\; "DELETE\; FROM\; char\_good\_bad\_link\; "\; .\; "WHERE\; good\_id\; =$cid OR bad_id = $cid";$result = mysql_query($sql)\; or\; die(mysql\_error());$redirect = 'charlist.php';
      break;
   
    case "Update Character":
      $sql\; =\; "INSERT\; IGNORE\; INTO\; char\_zipcode\; (id,\; city,\; state)\; "\; .\; "VALUES\; (\text{'}$zip', '$city\text{'},\; \text{'}$state')";
      $result\; =\; mysql\_query($sql) 
        or die(mysql_error());
  
      $sql\; =\; "UPDATE\; char\_lair\; l,\; char\_main\; m\; "\; .\; "SET\; l.zip\_id=\text{'}$zip', l.lair_addr='$address\text{'},\; "\; .\; "alias=\text{'}$alias', real_name='$name\text{'},\; align=\text{'}$align' " .
             "WHERE m.id = $cid\; AND\; m.lair\_id\; =\; l.id";$result = mysql_query($sql)\; or\; die(mysql\_error());$sql = "DELETE FROM char_power_link WHERE char_id = $cid";$result = mysql_query($sql)\; or\; die(mysql\_error());\; if\; ($powers != "") {
        $val\; =\; "";\; foreach\; ($powers as $key\; =>$id) {
          $val[]\; =\; "(\text{'}$cid', '$id\text{'})";\; \}$values = implode(',', $val);$sql = "INSERT IGNORE INTO char_power_link (char_id, power_id) " .
               "VALUES $values";$result = mysql_query($sql)\; or\; die(mysql\_error());\; \}$sql = "DELETE FROM char_good_bad_link " .
             "WHERE good_id = $cid\; OR\; bad\_id\; =$cid";
      $result\; =\; mysql\_query($sql) 
        or die(mysql_error());
  
      if ($enemies\; !=\; \text{'}\text{'})\; \{$val = "";
        foreach ($enemies\; as$key => $id)\; \{$val[] = "('$cid\text{'},\; \text{'}$id')";
        }
        $values\; =\; implode(\text{'},\text{'},$val);
        if ($align\; ==\; \text{'}good\text{'})\; \{$cols = '(good_id, bad_id)';
        } else {
          $cols\; =\; \text{'}(bad\_id,\; good\_id)\text{'};\; \}$sql = "INSERT IGNORE INTO char_good_bad_link $cols\; "\; .\; "VALUES$values";
        $result\; =\; mysql\_query($sql) 
          or die(mysql_error());
      }
  
      $redirect\; =\; \text{'}charlist.php\text{'};\; break;\; case\; "Delete\; Powers":\; if\; ($powers != "") {
        $powerlist\; =\; implode(\text{'},\text{'},$powers);
  
        $sql\; =\; "DELETE\; FROM\; char\_power\; WHERE\; id\; IN\; ($powerlist)";
        $result\; =\; mysql\_query($sql) 
          or die(mysql_error());
  
        $sql\; =\; "DELETE\; FROM\; char\_power\_link\; "\; .\; "WHERE\; power\_id\; IN\; ($powerlist)";
        $result\; =\; mysql\_query($sql) 
          or die(mysql_error());
      }
  
      $redirect\; =\; \text{'}poweredit.php\text{'};\; break;\; case\; "Add\; Power":\; if\; ($newpower != '') {
        $sql\; =\; "INSERT\; IGNORE\; INTO\; char\_power\; (id,\; power)\; "\; .\; "VALUES\; (NULL,\; \text{'}$newpower')";
        $result\; =\; mysql\_query($sql) 
          or die(mysql_error());
      }
  
      $redirect\; =\; \text{'}poweredit.php\text{'};\; break;\; default:$redirect = 'charlist.php';
  }
  header("Location: $redirect");\; ?>$