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;
?>
