diff options
| author | Philip Häusler <msquare@notrademark.de> | 2012-05-19 17:50:09 +0200 |
|---|---|---|
| committer | Philip Häusler <msquare@notrademark.de> | 2012-05-19 17:50:09 +0200 |
| commit | 505ad98e33b778ee4ba186d945f4e94cf9083db1 (patch) | |
| tree | 73aa06916b75c459f09a049a951c28d14c0dc9a5 /includes/pages/admin_rooms.php | |
| parent | aac265ec7e9e18466f3d8e4c5a78562b035c4609 (diff) | |
#51 fix problems with changing needed angeltypes in rooms
Diffstat (limited to 'includes/pages/admin_rooms.php')
| -rw-r--r-- | includes/pages/admin_rooms.php | 20 |
1 files changed, 11 insertions, 9 deletions
diff --git a/includes/pages/admin_rooms.php b/includes/pages/admin_rooms.php index c1f00387..160316c6 100644 --- a/includes/pages/admin_rooms.php +++ b/includes/pages/admin_rooms.php @@ -67,21 +67,23 @@ function admin_rooms() { else $ok = false; - foreach ($angeltypes as $angeltype_id => $angeltype) - if (isset ($_REQUEST['angeltype_count_' . $angeltype_id]) && preg_match("/^[0-9]{1,11}$/", $_REQUEST['angeltype_count_' . $angeltype_id])) - $angeltypes_count[$angeltype_id] = $_REQUEST['angeltype_count_' . $angeltype_id]; - else { - $ok = false; - $msg .= error(sprintf("Please enter needed angels for type %s.", $angeltype), true); + foreach ($angeltypes as $angeltype_id => $angeltype) { + if (isset ($_REQUEST['angeltype_count_' . $angeltype_id]) && preg_match("/^[0-9]{1,4}$/", $_REQUEST['angeltype_count_' . $angeltype_id])) + $angeltypes_count[$angeltype_id] = $_REQUEST['angeltype_count_' . $angeltype_id]; + else { + $ok = false; + $msg .= error(sprintf("Please enter needed angels for type %s.", $angeltype), true); + } } if ($ok) { if(isset($id)) sql_query("UPDATE `Room` SET `Name`='" . sql_escape($name) . "', `FromPentabarf`='" . sql_escape($from_pentabarf) . "', `show`='" . sql_escape($public) . "', `Number`='" . sql_escape($number) . "' WHERE `RID`=" . sql_escape($id) . " LIMIT 1"); - else + else { sql_query("INSERT INTO `Room` SET `Name`='" . sql_escape($name) . "', `FromPentabarf`='" . sql_escape($from_pentabarf) . "', `show`='" . sql_escape($public) . "', `Number`='" . sql_escape($number) . "'");
- $id = sql_id(); - + $id = sql_id(); + } + sql_query("DELETE FROM `NeededAngelTypes` WHERE `room_id`=" . sql_escape($id)); foreach ($angeltypes_count as $angeltype_id => $angeltype_count) sql_query("INSERT INTO `NeededAngelTypes` SET `room_id`=" . sql_escape($id) . ", `angel_type_id`=" . sql_escape($angeltype_id) . ", `count`=" . sql_escape($angeltype_count)); |