case 2:
show_useroptions(false, $u_id, get_lang(157), true);
break;
case 3:
show_useroptions(false, $u_id, get_lang(165), true);
break;
default:
show_useroptions(false, $u_id, get_lang(358), true);
break;
}
}
break;
case 'deletefiletype':
if ($valuser->isadmin() && frm_ok('del', 1)) {
db_execquery('DELETE from ' . TBL_FILETYPES . ' WHERE id = ' . frm_get('del', 1));
settings_edit(1, 3);
}
break;
case 'findmusic':
if ($valuser->isadmin()) {
findmusic();
}
break;
case 'editfiletype':
if ($valuser->isadmin() && frm_ok('id', 1)) {
edit_filetype(frm_get('id', 1));
}
break;
case 'storefiletype':
if ($valuser->isadmin()) {
if (frm_isset('extension')) {
function settings_update($event, $step)
{
global $txp_user, $vars, $txpcfg, $prefs;
extract(doSlash($_REQUEST));
if ($settings_update == "general") {
if (!isset($inventory_management_on)) {
$inventory_management_on = 0;
}
if (!isset($send_low_inventory_email_notification)) {
$send_low_inventory_email_notification = 0;
}
$storeSettingExist = safe_count("store_settings", "1");
//do we even have any store settings?
if ($storeSettingExist > 0) {
$return = safe_update("store_settings", "inventory_management_on\t\t= {$inventory_management_on},\r\n\t\t\t\t\t\t hide_inventory_when_depleted\t= {$hide_inventory_when_depleted},\r\n\t\t\t\t\t\t depleted_inventory_message\t\t= '{$depleted_inventory_message}',\r\n\t\t\t\t\t\t send_low_inventory_email_notification = {$send_low_inventory_email_notification},\r\n\t\t\t\t\t\t store_address\t\t\t\t\t= '{$store_address}',\r\n\t\t\t\t\t\t store_city\t\t\t\t\t\t= '{$store_city}',\r\n\t\t\t\t\t\t store_state\t\t\t\t\t= '{$store_state}',\r\n\t\t\t\t\t\t store_zip\t\t\t\t\t\t= '{$store_zip}',\r\n\t\t\t\t\t\t store_country\t\t\t\t\t= '{$store_country}',\r\n\t\t\t\t\t\t owner_email\t\t\t\t\t= '{$owner_email}',\r\n\t\t\t\t\t\t unit_system\t\t\t\t\t= '{$unit_system}',\r\n\t\t\t\t\t\t store_currency\t\t\t\t\t= '{$store_currency}'", "1");
} else {
$return = safe_insert("store_settings", "inventory_management_on\t\t= {$inventory_management_on},\r\n\t\t\t\t\t\t hide_inventory_when_depleted\t= {$hide_inventory_when_depleted},\r\n\t\t\t\t\t\t depleted_inventory_message\t\t= '{$depleted_inventory_message}',\r\n\t\t\t\t\t\t send_low_inventory_email_notification = {$send_low_inventory_email_notification},\r\n\t\t\t\t\t\t store_address\t\t\t\t\t= '{$store_address}',\r\n\t\t\t\t\t\t store_city\t\t\t\t\t\t= '{$store_city}',\r\n\t\t\t\t\t\t store_state\t\t\t\t\t= '{$store_state}',\r\n\t\t\t\t\t\t store_zip\t\t\t\t\t\t= '{$store_zip}',\r\n\t\t\t\t\t\t store_country\t\t\t\t\t= '{$store_country}',\r\n\t\t\t\t\t\t owner_email\t\t\t\t\t= '{$owner_email}',\r\n\t\t\t\t\t\t unit_system\t\t\t\t\t= '{$unit_system}',\r\n\t\t\t\t\t\t store_currency\t\t\t\t\t= '{$store_currency}'");
}
if (!$return) {
echo mysql_error();
} else {
settings_edit($event, $step, $message = 'General settings updated');
}
} else {
if ($settings_update == "add_zone") {
$country = safe_row("name", "countries", "id={$country_id}");
$country = $country['name'];
if (!isset($shipping_rate_id)) {
$shipping_rate_id = 'NULL';
}
$return = safe_insert("shipping_zones", "name \t\t= '{$country}',\r\n\t\t\t\t\t\t country_id = {$country_id},\r\n\t\t\t\t\t\t tax_rate\t= {$tax_rate},\r\n\t\t\t\t\t\t shipping_rate_id={$shipping_rate_id}");
if (!$return) {
echo mysql_error();
} else {
settings_edit($event, $step, $message = 'Shipping region added', "zones");
}
} else {
if ($settings_update == "delete_zone") {
$return = safe_delete("shipping_zones", "id={$id}");
if (!$return) {
echo mysql_error();
} else {
settings_edit($event, $step, $message = 'Shipping region deleted', "zones");
}
} else {
if ($settings_update == "update_zone") {
$return = safe_update("shipping_zones", "tax_rate = {$tax_rate}", "id={$id}");
if (!$return) {
echo mysql_error();
} else {
settings_edit($event, $step, $message = 'Shipping region updated', "zones");
}
} else {
if ($settings_update == "update_zone") {
$return = safe_update("shipping_zones", "tax_rate = {$tax_rate}", "id={$id}");
if (!$return) {
echo mysql_error();
} else {
settings_edit($event, $step, $message = 'Shipping region updated', "zones");
}
} else {
if ($settings_update == "update_rate") {
$return = safe_update("shipping_rates", "title = '{$title}',\r\n\t\t\t\t\t\t\t\t\t rate = {$rate},\r\n\t\t\t\t\t\t\t\t\t start_weight = {$start_weight},\r\n\t\t\t\t\t\t\t\t\t end_weight\t = {$end_weight}", "id={$shipping_rate_id}");
if (!$return) {
echo mysql_error();
} else {
settings_edit($event, $step, $message = 'Shipping rate updated', "rates");
}
} else {
if ($settings_update == "add_rate") {
$rate_id = safe_insert("shipping_rates", "title = '{$title}',\r\n\t\t\t\t\t\t\t\t\t rate = {$rate},\r\n\t\t\t\t\t\t\t\t\t start_weight = {$start_weight},\r\n\t\t\t\t\t\t\t\t\t end_weight\t = {$end_weight}");
if (!$rate_id) {
echo mysql_error();
die;
}
$return = safe_insert("zones_rates", "shipping_rate_id = {$rate_id},\r\n\t\t\t\t\t\t\t\t shipping_zone_id = {$id}");
if (!$return) {
echo mysql_error();
} else {
settings_edit($event, $step, $message = 'Shipping rate added', "rates");
}
} else {
if ($settings_update == "delete_rate") {
$result = safe_delete("shipping_rates", "id={$shipping_rate_id}");
if (!$result) {
echo mysql_error();
die;
}
$result = safe_delete("zones_rates", "shipping_rate_id = {$shipping_rate_id} AND\r\n\t\t\t\t\t\t\t\t shipping_zone_id = {$id}");
if (!$result) {
echo mysql_error();
} else {
settings_edit($event, $step, $message = 'Shipping rate deleted', "rates");
}
} else {
if ($settings_update == "notices") {
$result = $return = safe_update("store_settings", "order_confirmation_form = '{$order_confirmation_form}',\r\n\t\t\t\t\t\t\t\t\t\t\t new_order_notification_form = '{$new_order_notification_form}'", "1");
if (!$result) {
echo mysql_error();
} else {
settings_edit($event, $step, $message = 'Notices updated', "notices");
}
}
}
}
}
}
}
}
}
}
}
