if ($min_sorter == "") { $SQL = "INSERT INTO category_groups\n\t\t\t\t\t(category_id, group_id, sorter)\n\t\t\t\t\tVALUES\n\t\t\t\t\t('" . $category_id . "', '" . $group_id . "', '" . new_sorter("category_groups") . "')\n\t\t\t\t\t"; } else { $SQL = "UPDATE category_groups SET sorter = sorter + 1 WHERE sorter >= '" . $min_sorter . "'"; $Q->query($DB, $SQL); $SQL = "INSERT INTO category_groups\n\t\t\t\t\t(category_id, group_id, sorter)\n\t\t\t\t\tVALUES\n\t\t\t\t\t('" . $category_id . "', '" . $group_id . "', '" . $min_sorter . "')\n\t\t\t\t\t"; } $Q->query($DB, $SQL); } if ($_POST[sorter] == "after") { $SQL = "SELECT sorter FROM category_groups WHERE group_id = '" . $_POST[after_group] . "'"; $result = $Q->query($DB, $SQL); $after_sorter = mysql_fetch_assoc($result); $after_sorter = $after_sorter[sorter]; if ($after_sorter == "") { $SQL = "INSERT INTO category_groups\n\t\t\t\t\t(category_id, group_id, sorter)\n\t\t\t\t\tVALUES\n\t\t\t\t\t('" . $category_id . "', '" . $group_id . "', '" . new_sorter("category_groups") . "')\n\t\t\t\t\t"; } else { $SQL = "UPDATE category_groups SET sorter = sorter + 1 WHERE sorter > '" . $after_sorter . "'"; $Q->query($DB, $SQL); $SQL = "INSERT INTO category_groups\n\t\t\t\t\t(category_id, group_id, sorter)\n\t\t\t\t\tVALUES\n\t\t\t\t\t('" . $category_id . "', '" . $group_id . "', '" . ($after_sorter + 1) . "')\n\t\t\t\t\t"; } $Q->query($DB, $SQL); } header("location:params_list.php?id=" . $category_id); } $id = $_GET[id]; $query = "select * from " . $module_name . " where id='" . $id . "'"; $Q->query($DB, $query); $row = $Q->getrow(); $lt = getlangtemplate($adminlanguage, "../sadmin/_inc/templates/module"); //echo $id;
include "../sadmin/_bfunctions.php"; include "../sadmin/_admin_config.php"; include "./params_functions.php"; /** * @author kross * @copyright 2009 */ if ($_POST[add_param]) { $SQL = "INSERT INTO params_names\n\t(param_name, param_type)\n\tVALUES\n\t('" . trim($_POST[param_name]) . "', '" . $_POST[param_type] . "')\n\t"; $Q->query($DB, $SQL); $SQL = "SELECT * FROM params_names WHERE param_name = '" . trim($_POST[param_name]) . "' AND param_type = '" . $_POST[param_type] . "' ORDER BY param_id DESC LIMIT 1"; $result = $Q->query($DB, $SQL); $param_id = mysql_fetch_assoc($result); $param_id = $param_id[param_id]; $SQL = "INSERT INTO groups_params\n\t(group_id, param_id, sorter)\n\tVALUES\n\t('" . $_POST[param_group] . "', '" . $param_id . "', '" . new_sorter("groups_params") . "')\n\t"; $Q->query($DB, $SQL); header("location:params_list.php?id=" . $_GET[id]); } $id = $_GET[id]; $query = "select * from " . $module_name . " where id='" . $id . "'"; $Q->query($DB, $query); $row = $Q->getrow(); $lt = getlangtemplate($adminlanguage, "../sadmin/_inc/templates/module"); //echo $id; ?> <html> <head> <title>Administration:<?php echo $module_title; ?>