Plik który przetwarza wszystko,
<?php
require('config.php');
foreach ($_POST as $key => $value) {
$$key = $value;
}
switch ($action) {
case "Utwórz postać":
$sql = "INSERT IGNORE INTO char_zipcode (id, city, state) " .
"VALUES ('$zip', '$city', '$state')";
$sql = "INSERT INTO char_lair (id, zip_id, lair_addr) " .
"VALUES (NULL, '$zip', '$address')";
if ($result) {
}
$sql = "INSERT INTO char_main (id,lair_id,alias,real_name,align) " .
"VALUES (NULL, '$lairid', '$alias', '$name', '$align')";
if ($result) {
}
if ($powers != "") {
$val = "";
foreach ($powers as $key => $id) {
$val[] = "('$charid', '$id')";
}
$sql = "INSERT IGNORE INTO char_power_link (char_id, power_id) " .
"VALUES $values";
}
if ($enemies != '') {
$val = "";
foreach ($enemies as $key => $id) {
$val[] = "('$charid', '$id')";
}
if ($align = 'dobry') {
$cols = '(good_id, bad_id)';
} else {
$cols = '(bad_id, good_id)';
}
$sql = "INSERT IGNORE INTO char_good_bad_link $cols " .
"VALUES $values";
}
$redirect = 'charlist.php';
break;
case "Usuń postać":
$sql = "DELETE FROM char_main, char_lair " .
"USING char_main m, char_lair l " .
"WHERE m.lair_id = l.id AND m.id = $cid";
$sql = "DELETE FROM char_power_link WHERE char_id = $cid";
$sql = "DELETE FROM char_good_bad_link " .
"WHERE good_id = $cid OR bad_id = $cid";
$redirect = 'charlist.php';
break;
case "Uaktualnij postać":
$sql = "INSERT IGNORE INTO char_zipcode (id, city, state) " .
"VALUES ('$zip', '$city', '$state')";
$sql = "UPDATE char_lair l, char_main m " .
"SET l.zip_id='$zip', l.lair_addr='$address', " .
"alias='$alias', real_name='$name', align='$align' " .
"WHERE m.id = $cid AND m.lair_id = l.id";
$sql = "DELETE FROM char_power_link WHERE char_id = $cid";
if ($powers != "") {
$val = "";
foreach ($powers as $key => $id) {
$val[] = "('$cid', '$id')";
}
$sql = "INSERT IGNORE INTO char_power_link (char_id, power_id) " .
"VALUES $values";
}
$sql = "DELETE FROM char_good_bad_link " .
"WHERE good_id = $cid OR bad_id = $cid";
if ($enemies != '') {
$val = "";
foreach ($enemies as $key => $id) {
$val[] = "('$cid', '$id')";
}
if ($align == 'dobry') {
$cols = '(good_id, bad_id)';
} else {
$cols = '(bad_id, good_id)';
}
$sql = "INSERT IGNORE INTO char_good_bad_link $cols " .
"VALUES $values";
}
$redirect = 'charlist.php';
break;
case "Usuń moce":
if ($powers != "") {
$powerlist = implode(',', $powers);
$sql = "DELETE FROM char_power WHERE id IN ($powerlist)";
$sql = "DELETE FROM char_power_link " .
"WHERE power_id IN ($powerlist)";
}
$redirect = 'poweredit.php';
break;
case "Dodaj moc":
if ($newpower != '') {
$sql = "INSERT IGNORE INTO char_power (id, power) " .
"VALUES (NULL, '$newpower')";
}
$redirect = 'poweredit.php';
break;
default:
$redirect = 'charlist.php';
}
header("Location: $redirect"); ?>
formularz ma wstawiać dane użytkownika imię nazwisko pseudonim itd..