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