} else {
$db->Execute("update " . TABLE_RECORD_ARTISTS . "\r\n set artists_image = ''\r\n where artists_id = '" . (int) $artists_id . "'");
}
}
}
$languages = zen_get_languages();
for ($i = 0, $n = sizeof($languages); $i < $n; $i++) {
$artists_url_array = $_POST['artists_url'];
$language_id = $languages[$i]['id'];
$sql_data_array = array('artists_url' => zen_db_prepare_input($artists_url_array[$language_id]));
if ($action == 'insert') {
$insert_sql_data = array('artists_id' => $artists_id, 'languages_id' => $language_id);
$sql_data_array = array_merge($sql_data_array, $insert_sql_data);
zen_db_perform(TABLE_RECORD_ARTISTS_INFO, $sql_data_array);
} elseif ($action == 'save') {
zen_db_perform_language(TABLE_RECORD_ARTISTS_INFO, $sql_data_array, 'artists_id', (int) $artists_id, (int) $language_id);
}
}
zen_redirect(zen_href_link(FILENAME_RECORD_ARTISTS, (isset($_GET['page']) ? 'page=' . $_GET['page'] . '&' : '') . 'mID=' . $artists_id));
break;
case 'deleteconfirm':
// demo active test
if (zen_admin_demo()) {
$_GET['action'] = '';
$messageStack->add_session(ERROR_ADMIN_DEMO, 'caution');
zen_redirect(zen_href_link(FILENAME_RECORD_ARTISTS, 'page=' . $_GET['page']));
}
$artists_id = zen_db_prepare_input($_POST['mID']);
if (isset($_POST['delete_image']) && $_POST['delete_image'] == 'on') {
$manufacturer = $db->Execute("select artists_image\r\n from " . TABLE_RECORD_ARTISTS . "\r\n where artists_id = '" . (int) $artists_id . "'");
$image_location = DIR_FS_CATALOG_IMAGES . $manufacturer->fields['artists_image'];
} else {
$db->Execute("update " . TABLE_RECORD_COMPANY . "\n set record_company_image = ''\n where record_company_id = '" . (int) $record_company_id . "'");
}
}
}
$languages = zen_get_languages();
for ($i = 0, $n = sizeof($languages); $i < $n; $i++) {
$record_company_url_array = $_POST['record_company_url'];
$language_id = $languages[$i]['id'];
$sql_data_array = array('record_company_url' => zen_db_prepare_input($record_company_url_array[$language_id]));
if ($action == 'insert') {
$insert_sql_data = array('record_company_id' => $record_company_id, 'languages_id' => $language_id);
$sql_data_array = array_merge($sql_data_array, $insert_sql_data);
zen_db_perform(TABLE_RECORD_COMPANY_INFO, $sql_data_array);
} elseif ($action == 'save') {
zen_db_perform_language(TABLE_RECORD_COMPANY_INFO, $sql_data_array, 'record_company_id', (int) $record_company_id, (int) $language_id);
}
}
zen_redirect(zen_href_link(FILENAME_RECORD_COMPANY, (isset($_GET['page']) ? 'page=' . $_GET['page'] . '&' : '') . 'mID=' . $record_company_id));
break;
case 'deleteconfirm':
// demo active test
if (zen_admin_demo()) {
$_GET['action'] = '';
$messageStack->add_session(ERROR_ADMIN_DEMO, 'caution');
zen_redirect(zen_href_link(FILENAME_RECORD_COMPANY, 'page=' . $_GET['page']));
}
$record_company_id = zen_db_prepare_input($_POST['mID']);
if (isset($_POST['delete_image']) && $_POST['delete_image'] == 'on') {
$record_company = $db->Execute("select record_company_image\n from " . TABLE_RECORD_COMPANY . "\n where record_company_id = '" . (int) $record_company_id . "'");
$image_location = DIR_FS_CATALOG_IMAGES . $record_company->fields['record_company_image'];