define(
'SED_CODE'
, TRUE);
require_once
(
'../../../datas/config.php'
);
$cfg
[
'system_dir'
] =
str_replace
(
"./"
,
"../../../"
,
$cfg
[
'system_dir'
]);
$cfg
[
'plugins_dir'
] =
str_replace
(
"./"
,
"../../../"
,
$cfg
[
'plugins_dir'
]);
require_once
(
$cfg
[
'system_dir'
].
'/functions.php'
);
require_once
(
'../../../plugins/shop/inc/configs.php'
);
require_once
(
'../../../plugins/shop/inc/functions.php'
);
require_once
(
$cfg
[
'system_dir'
].
'/database.'
.
$cfg
[
'sqldb'
].
'.php'
);
$sed_dbc
= sed_sql_connect(
$cfg
[
'mysqlhost'
],
$cfg
[
'mysqluser'
],
$cfg
[
'mysqlpassword'
],
$cfg
[
'mysqldb'
]);
unset(
$cfg
[
'mysqlhost'
],
$cfg
[
'mysqluser'
],
$cfg
[
'mysqlpassword'
]);
$cat
= sed_import(
"cat"
,
"G"
,
"INT"
);
$podbor_size
= sed_import(
"podbor_size"
,
"G"
,
"INT"
);
$sql
= sed_sql_query(
"SELECT * FROM $db_sizes_groups WHERE sg_id IN (SELECT sg.sg_root FROM $db_tovars t, $db_tovars_sizes ts, $db_sizes_groups sg, $db_sizes s WHERE t.tovar_catid='$cat' AND ts.ts_tovarid=t.tovar_id AND s.size_id=ts.ts_sizeid AND sg.sg_id=s.size_groupid) ORDER BY sg_name ASC"
);
while
(
$res
= sed_sql_fetcharray(
$sql
))
{
$select
= (
$res
[
'sg_id'
] ==
$podbor_size
) ?
"selected"
: false;
echo
"<option style='background:#eee;' value='"
.
$res
['sg_id
']."'
$select
>".
$res
[
'sg_name'
].
"</option>"
;
$sql1
= sed_sql_query(
"SELECT * FROM $db_sizes_groups WHERE sg_root='"
.
$res
['sg_id
']."'
ORDER BY sg_name ASC");
while
(
$res1
= sed_sql_fetcharray(
$sql1
))
{
$select
= (
$res1
[
'sg_id'
] ==
$podbor_size
) ?
"selected"
: false;
echo
"<option value='"
.
$res1
['sg_id
']."'
$select
> ".
$res1
[
'sg_name'
].
"</option>"
;
}
}