Hello.
I just installed the Super Download Shop contrib.
Two problems so far:
1) I get the following message when trying to access product attributes in my admin panel:
Parse error: syntax error, unexpected T_CASE in /hsphere/local/home/webtask/eterya.com/admin/products_attributes.php on line 90
Here´s the modification from line 90:
// BOF Super Download Shop v1.0 mod
case 'add_filegroups':
$filegroup_id = tep_db_prepare_input($HTTP_POST_VARS['filegroup_id']);
$file_group_array = $HTTP_POST_VARS['file_group_name'];
// check if any name given
$name_check = 0;
for ($i=0, $n=sizeof($languages); $i<$n; $i ++) {
if (!empty($file_group_array[$languages[$i]['id']])) $name_check = 1;
}
if (is_numeric($filegroup_id) && $name_check == 1) {
for ($i=0, $n=sizeof($languages); $i<$n; $i ++) {
$file_group_name = tep_db_prepare_input($file_group_array[$languages[$i]['id']]);
tep_db_query("insert into " . TABLE_PRODUCTS_ATTRIBUTES_DOWNLOAD_GROUPS . " (download_group_id, download_group_name, language_id) values ('" . (int)$filegroup_id . "', '" . tep_db_input($file_group_name) . "', '" . (int)$languages[$i]['id'] . "')");
}
}
tep_redirect(tep_href_link(FILENAME_PRODUCTS_ATTRIBUTES, $page_info));
break;
case 'add_group_file':
$filegroup_id = tep_db_prepare_input($HTTP_POST_VARS['filegroup_id']);
$file_desc_array = $HTTP_POST_VARS['file_desc'];
$file_name = '';
if (isset($HTTP_POST_VARS['input_filename']) && !empty($HTTP_POST_VARS['input_filename'])) {
$file_name = tep_db_prepare_input($HTTP_POST_VARS['input_filename']);
}
if (tep_not_null($file_name) && file_exists(DIR_FS_CATALOG_DOWNLOAD . $file_name)) {
// check existing file and descriptions
$file_query = tep_db_query("select download_groups_file_id from " . TABLE_PRODUCTS_ATTRIBUTES_DOWNLOAD_GROUPS_FILES . " where download_group_filename = '" . $file_name . "'");
if (tep_db_num_rows($file_query) > 0) {
$file_array = tep_db_fetch_array($file_query);
tep_db_query("insert into " . TABLE_PRODUCTS_ATTRIBUTES_DOWNLOAD_GROUPS_FILES . " (download_groups_file_id, download_group_id, download_group_filename) values ('" . (int)$file_array['download_groups_file_id'] . "', '" . (int)$filegroup_id . "', '" . tep_db_input($file_name) . "')");
} else {
tep_db_query("insert into " . TABLE_PRODUCTS_ATTRIBUTES_DOWNLOAD_GROUPS_FILES . " (download_group_id, download_group_filename) values ('" . (int)$filegroup_id . "', '" . tep_db_input($file_name) . "')");
$download_groups_file_id = tep_db_insert_id();
for ($i=0, $n=sizeof($languages); $i<$n; $i ++) {
$file_desc = tep_db_prepare_input($file_desc_array[$languages[$i]['id']]);
if (empty($file_desc)) $file_desc = tep_db_prepare_input(TEXT_TEMP_DESC . ' ' . $download_groups_file_id);
tep_db_query("insert into " . TABLE_PRODUCTS_ATTRIBUTES_DOWNLOAD_GROUPS_TO_FILES . " (download_groups_file_id, language_id, download_group_file_description) values ('" . (int)$download_groups_file_id . "', '" . (int)$languages[$i]['id'] . "', '" . tep_db_input($file_desc) . "')");
}
}
} else {
if (!tep_not_null($file_name)) $messageStack->add(ERROR_NO_FILENAME, 'error');
else $messageStack->add(sprintf(ERROR_FILE_DOES_NOT_EXIST, $file_name), 'error');
}
tep_redirect(tep_href_link(FILENAME_PRODUCTS_ATTRIBUTES, $page_info));
break;
case 'add_mass_files':
$filegroup_id = tep_db_prepare_input($HTTP_POST_VARS['filegroup_id']);
$file_selected = $HTTP_POST_VARS['file_selected'];
foreach($file_selected as $k => $file_name) {
if (tep_not_null($file_name)) {
$file_name = tep_db_prepare_input($file_name);
// check if file already in group
$file_check_query = tep_db_query("select * from " . TABLE_PRODUCTS_ATTRIBUTES_DOWNLOAD_GROUPS_FILES . " where download_group_id = '" . (int)$filegroup_id . "' and download_group_filename = '" . $file_name . "'");
if (tep_db_num_rows($file_check_query) == 0) {
// check existing file and descriptions
$file_query = tep_db_query("select download_groups_file_id from " . TABLE_PRODUCTS_ATTRIBUTES_DOWNLOAD_GROUPS_FILES . " where download_group_filename = '" . $file_name . "'");
if (tep_db_num_rows($file_query) > 0) {
$file_array = tep_db_fetch_array($file_query);
tep_db_query("insert into " . TABLE_PRODUCTS_ATTRIBUTES_DOWNLOAD_GROUPS_FILES . " (download_groups_file_id, download_group_id, download_group_filename) values ('" . (int)$file_array['download_groups_file_id'] . "', '" . (int)$filegroup_id . "', '" . tep_db_input($file_name) . "')");
} else {
tep_db_query("insert into " . TABLE_PRODUCTS_ATTRIBUTES_DOWNLOAD_GROUPS_FILES . " (download_group_id, download_group_filename) values ('" . (int)$filegroup_id . "', '" . tep_db_input($file_name) . "')");
$download_groups_file_id = tep_db_insert_id();
for ($i=0, $n=sizeof($languages); $i<$n; $i ++) {
$file_desc = tep_db_prepare_input(TEXT_TEMP_DESC . ' ' . $download_groups_file_id);
tep_db_query("insert into " . TABLE_PRODUCTS_ATTRIBUTES_DOWNLOAD_GROUPS_TO_FILES . " (download_groups_file_id, language_id, download_group_file_description) values ('" . (int)$download_groups_file_id . "', '" . (int)$languages[$i]['id'] . "', '" . tep_db_input($file_desc) . "')");
}
}
}
}
}
tep_redirect(tep_href_link(FILENAME_PRODUCTS_ATTRIBUTES, $page_info));
break;
case 'update_filegroup_name':
$file_group_name_array = $HTTP_POST_VARS['file_group_name'];
$filegroup_id = tep_db_prepare_input($HTTP_POST_VARS['filegroup_id']);
for ($i=0, $n=sizeof($languages); $i<$n; $i ++) {
$file_group_name = tep_db_prepare_input($file_group_name_array[$languages[$i]['id']]);
tep_db_query("update " . TABLE_PRODUCTS_ATTRIBUTES_DOWNLOAD_GROUPS . " set download_group_name = '" . tep_db_input($file_group_name) . "' where download_group_id = '" . (int)$filegroup_id . "' and language_id = '" . (int)$languages[$i]['id'] . "'");
}
tep_redirect(tep_href_link(FILENAME_PRODUCTS_ATTRIBUTES, $page_info));
break;
case 'update_file_desc':
$file_desc_array = $HTTP_POST_VARS['file_desc'];
$file_id = tep_db_prepare_input($HTTP_POST_VARS['file_id']);
for ($i=0, $n=sizeof($languages); $i<$n; $i ++) {
$file_desc = tep_db_prepare_input($file_desc_array[$languages[$i]['id']]);
tep_db_query("update " . TABLE_PRODUCTS_ATTRIBUTES_DOWNLOAD_GROUPS_TO_FILES . " set download_group_file_description = '" . tep_db_input($file_desc) . "' where download_groups_file_id = '" . (int)$file_id . "' and language_id = '" . (int)$languages[$i]['id'] . "'");
}
tep_redirect(tep_href_link(FILENAME_PRODUCTS_ATTRIBUTES, $page_info));
break;
case 'delete_download_group':
$filegroup_id = tep_db_prepare_input($HTTP_GET_VARS['filegroup_id']);
tep_db_query("delete from " . TABLE_PRODUCTS_ATTRIBUTES_DOWNLOAD_GROUPS . " where download_group_id = '" . (int)$filegroup_id . "'");
// check files in other group
$files_query = tep_db_query("select download_groups_file_id from " . TABLE_PRODUCTS_ATTRIBUTES_DOWNLOAD_GROUPS_FILES . " where download_group_id = '" . (int)$filegroup_id . "'");
while ($file_array = tep_db_fetch_array($files_query)) {
$file_check = tep_db_query("select download_groups_file_id from " . TABLE_PRODUCTS_ATTRIBUTES_DOWNLOAD_GROUPS_FILES . " where download_group_id != '" . (int)$filegroup_id . "' and download_groups_file_id = '" . $file_array['download_groups_file_id'] . "'");
if (tep_db_num_rows($file_check) === 0) {
tep_db_query("delete from " . TABLE_PRODUCTS_ATTRIBUTES_DOWNLOAD_GROUPS_TO_FILES . " where download_groups_file_id = '" . $file_array['download_groups_file_id'] . "'");
}
}
tep_db_query("delete from " . TABLE_PRODUCTS_ATTRIBUTES_DOWNLOAD_GROUPS_FILES . " where download_group_id = '" . (int)$filegroup_id . "'");
tep_redirect(tep_href_link(FILENAME_PRODUCTS_ATTRIBUTES, $page_info));
break;
case 'delete_file_from_group':
$filegroup_id = tep_db_prepare_input($HTTP_GET_VARS['filegroup_id']);
$file_id = tep_db_prepare_input($HTTP_GET_VARS['group_file_id']);
tep_db_query("delete from " . TABLE_PRODUCTS_ATTRIBUTES_DOWNLOAD_GROUPS_FILES . "
where download_group_id = '" . (int)$filegroup_id . "'
and download_groups_file_id = '" . (int)$file_id . "'");
// check files in other group
$file_check = tep_db_query("select download_groups_file_id from " . TABLE_PRODUCTS_ATTRIBUTES_DOWNLOAD_GROUPS_FILES . "
where download_group_id != '" . (int)$filegroup_id . "'
and download_groups_file_id = '" . (int)$file_id . "'");
if (tep_db_num_rows($file_check) === 0) {
tep_db_query("delete from " . TABLE_PRODUCTS_ATTRIBUTES_DOWNLOAD_GROUPS_TO_FILES . " where download_groups_file_id = '" . (int)$file_id . "'");
}
tep_redirect(tep_href_link(FILENAME_PRODUCTS_ATTRIBUTES, $page_info));
break;
case 'delete_file_all_groups':
$file_id = tep_db_prepare_input($HTTP_GET_VARS['group_file_id']);
tep_db_query("delete from " . TABLE_PRODUCTS_ATTRIBUTES_DOWNLOAD_GROUPS_FILES . "
where download_groups_file_id = '" . (int)$file_id . "'");
tep_db_query("delete from " . TABLE_PRODUCTS_ATTRIBUTES_DOWNLOAD_GROUPS_TO_FILES . " where download_groups_file_id = '" . (int)$file_id . "'");
tep_redirect(tep_href_link(FILENAME_PRODUCTS_ATTRIBUTES, $page_info));
break;
// EOF Super Download Shop v1.0 mod
2) I´m supposed to access catalog/admin/filegroup_db_setup.php to create the initial file group entry in my database for each language.
When doing so this file opens: /admin/forbiden.php
Anyone who can help me?
PS: My site is in the root folder and not catalog.