- case "edit": // Change entries
- foreach ($_POST['lvl'] as $id => $value) {
- // Secure ID
- $id = bigintval($id);
-
- // Revert german commata
- $_POST['perc'][$id] = REVERT_COMMA($_POST['perc'][$id]);
-
- // Update entry
- SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_refdepths SET level='%s', percents='%s' WHERE id=%s LIMIT 1",
- array(bigintval($value), $_POST['perc'][$id], $id), __FILE__, __LINE__);
+ case "ref":
+ switch (REQUEST_GET('do'))
+ {
+ case 'add':
+ ADD_SQL("INSERT INTO `{!_MYSQL_PREFIX!}_refdepths` (level, percents) VALUES ('".REQUEST_POST('lvl')."','".REQUEST_POST('perc')."')");
+ break;
+
+ case 'edit': // Change entries
+ foreach (REQUEST_POST('lvl') as $id => $value) {
+ // Secure ID
+ $id = bigintval($id);
+
+ // Revert german commata
+ REQUEST_SET_POST(array('perc', $id), convertCommaToDot(REQUEST_POST('perc', $id)));
+
+ // Update entry
+ SQL_QUERY_ESC("UPDATE `{!_MYSQL_PREFIX!}_refdepths` SET level='%s', percents='%s' WHERE `id`=%s LIMIT 1",
+ array(bigintval($value), REQUEST_POST('perc', $id), $id), __FILE__, __LINE__);
+ }
+ $message = getMessage('REF_DEPTHS_SAVED');
+ break;
+
+ case 'del':
+ foreach (REQUEST_POST('id') as $id => $value) {
+ SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{!_MYSQL_PREFIX!}_refdepths` WHERE `id`=%s LIMIT 1",
+ array(bigintval($id)), __FILE__, __LINE__);
+ }
+ $message = getMessage('REF_DEPTHS_DELETED');
+ break;