<table width="100%" cellspacing="0" cellpadding="0" border="0">
<tr height="1px">
<td width="100%" style="padding-left:20px;">
<?php
$compare = $_POST[compare];
$SQL = "SELECT * FROM " . $module_name . " WHERE id IN (" . implode(", ", $compare) . ") AND enabled <> 'no' ORDER BY date DESC";
$result = $Q->query($DB, $SQL);
for ($products = array(); $row = mysql_fetch_assoc($result); $products[] = $row) {
}
$output = "\n\t<table>\n\t<tr>\n\t\t<td></td>\n\t";
for ($i = 0; $i < count($products); $i++) {
$output .= "\n\t\t<td align=center>\n\t\t\t<a href='" . get_link($products[$i][id]) . "' class='goodnameSmall'>" . $products[$i][name] . "</a><br>\n\t\t\t<img src='/shortimage.php?path=attachments--" . $products[$i][id] . "--1.jpg&x=137&y=121' border='0'/>\n\t\t</td>\n\t\t";
}
$output .= "</tr>";
$category_id = get_rubric_id($products[0][id]);
$SQL = "SELECT * FROM category_groups INNER JOIN params_groups_names ON category_groups.group_id = params_groups_names.group_id WHERE category_id = '" . $category_id . "' ORDER BY sorter";
$result = $Q->query($DB, $SQL);
for ($groups = array(); $row = mysql_fetch_assoc($result); $groups[] = $row) {
}
for ($i = 0; $i < count($groups); $i++) {
$SQL = "SELECT * FROM groups_params INNER JOIN params_names ON groups_params.param_id = params_names.param_id WHERE group_id = '" . $groups[$i][group_id] . "' ORDER BY groups_params.sorter";
$result = $Q->query($DB, $SQL);
for ($params = array(); $row = mysql_fetch_assoc($result); $params[] = $row) {
}
for ($j = 0; $j < count($params); $j++) {
$output .= "\n\t\t\t<tr>\n\t\t\t\t<td>\n\t\t\t\t\t" . $params[$j][param_name] . "\n\t\t\t\t</td>\n\t\t\t";
for ($k = 0; $k < count($products); $k++) {
if ($params[$j][param_type] == "select") {
$SQL = "SELECT * FROM products_values INNER JOIN values_titles ON products_values.value = values_titles.value_id WHERE product_id = '" . $products[$k][id] . "' AND param_id = '" . $params[$j][param_id] . "'";
$result = $Q->query($DB, $SQL);
$value = mysql_fetch_assoc($result);
function show_params($product_id)
{
global $DB, $Q, $module_name;
$rubric_id = get_rubric_id($product_id);
if ($rubric_id != null) {
$output = show_tmpl("params_table_begin", array(), array());
$SQL = "SELECT * FROM category_groups INNER JOIN params_groups_names ON category_groups.group_id = params_groups_names.group_id WHERE category_id = '" . $rubric_id . "' ORDER BY sorter ASC";
$result = $Q->query($DB, $SQL);
for ($groups = array(); $row = mysql_fetch_assoc($result); $groups[] = $row) {
}
for ($i = 0; $i < count($groups); $i++) {
$output .= show_tmpl("params_group", array("group"), array($groups[$i][group_name]));
$SQL = "SELECT * FROM groups_params INNER JOIN params_names ON groups_params.param_id = params_names.param_id WHERE group_id = '" . $groups[$i][group_id] . "' ORDER BY sorter ASC";
$result = $Q->query($DB, $SQL);
for ($params = array(); $row = mysql_fetch_assoc($result); $params[] = $row) {
}
for ($j = 0; $j < count($params); $j++) {
$SQL = "SELECT * FROM products_values WHERE product_id = '" . $product_id . "' AND param_id = '" . $params[$j][param_id] . "'";
$result = $Q->query($DB, $SQL);
$value = mysql_fetch_assoc($result);
if ($params[$j][param_type] == "select") {
$SQL = "SELECT * FROM values_titles WHERE value_id = '" . $value[value] . "'";
$result = $Q->query($DB, $SQL);
$value = mysql_fetch_assoc($result);
//print_r($value);
$value = $value[value_title];
if ($value == "") {
$value = " ";
}
$output .= show_tmpl("params_param_value", array("param", "value"), array($params[$j][param_name], $value));
}
if ($params[$j][param_type] == "text_field") {
$value = $value[value];
if ($value == "") {
$value = " ";
}
$output .= show_tmpl("params_param_value", array("param", "value"), array($params[$j][param_name], $value));
}
if ($params[$j][param_type] == "checkbox") {
$value_id = split(",", $value[value]);
//print_r($value_id);
$value = "";
if (count($value_id) > 0 && $value_id[0] != "") {
$SQL = "SELECT * FROM values_titles WHERE value_id IN (" . implode(", ", $value_id) . ")";
$result = $Q->query($DB, $SQL);
for ($values = array(); $row = mysql_fetch_assoc($result); $values[] = $row) {
}
for ($k = 0; $k < count($values); $k++) {
$value .= $values[$k][value_title];
if ($k < count($values) - 1) {
$value .= ", ";
}
}
}
if ($value == "") {
$value = " ";
}
$output .= show_tmpl("params_param_value", array("param", "value"), array($params[$j][param_name], $value));
}
}
}
$output .= show_tmpl("params_table_end", array(), array());
}
return $output;
}
</a></td>
</tr>
</table>
<?php
echo $setup_status;
?>
<form action="params_product_save.php" method="post">
<input type="hidden" name="product_id" value="<?php
echo $id;
?>
">
<table border=0>
<?php
$product_id = $_GET[id];
$output = "";
$param_rubric_id = get_rubric_id($_GET[id]);
//echo "param_rubric_id=".$param_rubric_id;
$SQL = "SELECT * FROM category_groups INNER JOIN params_groups_names ON category_groups.group_id = params_groups_names.group_id WHERE category_id='" . $param_rubric_id . "' ORDER BY category_groups.sorter ASC";
$result = $Q->query($DB, $SQL);
for ($groups = array(); $row = mysql_fetch_assoc($result); $groups[] = $row) {
}
for ($i = 0; $i < count($groups); $i++) {
$output .= "\n\t\t<tr>\n\t\t\t<td colspan=2 style='font-size:15px; font-weight:bold; color:#009933'>\n\t\t\t\t" . $groups[$i][group_name] . "\n\t\t\t</td>\n\t\t</tr>\n\t\t<tr>\n\t\t\t<td colspan=2>\n\t\t\t\t<hr width=100%>\n\t\t\t</td>\n\t\t</tr>\n\t\t";
$SQL = "SELECT * FROM groups_params INNER JOIN params_names ON groups_params.param_id = params_names.param_id WHERE group_id='" . $groups[$i][group_id] . "' ORDER BY groups_params.sorter ASC";
$result = $Q->query($DB, $SQL);
for ($params = array(); $row = mysql_fetch_assoc($result); $params[] = $row) {
}
for ($j = 0; $j < count($params); $j++) {
$SQL = "SELECT * FROM products_values WHERE product_id = '" . $product_id . "' AND param_id = '" . $params[$j][param_id] . "'";
$result = $Q->query($DB, $SQL);
$product_value = mysql_fetch_assoc($result);
