set('site_fees_header_message', header5(MSG_BTN_SITE_FEES));
$category_id = (!empty($_POST['fees_category_id'])) ? intval($_POST['fees_category_id']) : 0;
$template->set('category_id', $category_id);
$fee_row = $db->get_sql_row("SELECT * FROM " . DB_PREFIX . "fees WHERE category_id = '" . $category_id . "'");
$template->set('fee_row', $fee_row);
$sql_select_categories = $db->query("SELECT category_id, name FROM " . DB_PREFIX . "categories WHERE
parent_id=0 AND custom_fees=1 ORDER BY order_id ASC, name ASC");
$fees_categories_box = ' ';
$template->set('fees_categories_box', $fees_categories_box);
$sql_select_setup_fees = $db->query("SELECT * FROM " . DB_PREFIX . "fees_tiers WHERE
fee_type='setup' AND category_id='" . $category_id . "' ORDER BY fee_from ASC");
$is_setup_fee = $db->num_rows($sql_select_setup_fees);
$template->set('is_setup_fee', $is_setup_fee);
(string) $listing_fees_table = null;
while ($tier_details = $db->fetch_array($sql_select_setup_fees))
{
$background = ($counter++%2) ? 'c1' : 'c2';
$listing_fees_table .= ' '.
' | ' . MSG_FROM . ' ' . $fees->display_amount($tier_details['fee_from']) . ' ' . MSG_TO . ' ' . $fees->display_amount($tier_details['fee_to']) . ' | '.
' ' . (($tier_details['calc_type'] == 'flat') ? $fees->display_amount($tier_details['fee_amount']) : $tier_details['fee_amount'] . '%') . ' | '.
'
';
}
$template->set('listing_fees_table', $listing_fees_table);
$sql_select_stores = mysql_query("SELECT * FROM " . DB_PREFIX . "fees_tiers WHERE
fee_type='store' ORDER BY fee_amount ASC");
$is_stores = $db->num_rows($sql_select_stores);
$template->set('is_stores', $is_stores);
(string) $store_subscriptions_table = null;
$shop = new shop();
$shop->setts = &$setts;
$shop->user_id = 0;
while ($store_details = $db->fetch_array($sql_select_stores))
{
$background = ($counter++%2) ? 'c1' : 'c2';
$store_subscriptions_table .= ' '.
' | ' . $store_details['store_name'] . ' | '.
' ' . $shop->shop_description($store_details, false) . ' | '.
'
';
}
$template->set('store_subscriptions_table', $store_subscriptions_table);
$sql_select_sale_fees = $db->query("SELECT * FROM " . DB_PREFIX . "fees_tiers WHERE
fee_type='endauction' AND category_id='" . $category_id . "' ORDER BY fee_from ASC");
$is_sale_fee = $db->num_rows($sql_select_sale_fees);
$template->set('is_sale_fee', $is_sale_fee);
(string) $sale_fees_table = null;
while ($tier_details = $db->fetch_array($sql_select_sale_fees))
{
$background = ($counter++%2) ? 'c1' : 'c2';
$sale_fees_table .= ' '.
' | ' . MSG_FROM . ' ' . $fees->display_amount($tier_details['fee_from']) . ' ' . MSG_TO . ' ' . $fees->display_amount($tier_details['fee_to']) . ' | '.
' ' . (($tier_details['calc_type'] == 'flat') ? $fees->display_amount($tier_details['fee_amount']) : $tier_details['fee_amount'] . '%') . ' | '.
'
';
}
$template->set('sale_fees_table', $sale_fees_table);
if ($setts['enable_tax'])
{
$tax = new tax();
$tax_settings = $db->get_sql_row("SELECT * FROM " . DB_PREFIX . "tax_settings WHERE site_tax = 1");
$tax_message = $tax_settings['amount'] . '% ' . $tax_settings['tax_name'] . ' ' . MSG_WILL_BE_APPLIED_TO_USERS_FROM . ' ' . $tax->display_countries($tax_settings['countries_id']);
$template->set('tax_message', $tax_message);
$template->set('tax_amount', $tax_settings['amount']);
}
$template_output .= $template->process('site_fees.tpl.php');
include_once ('global_footer.php');
echo $template_output;
?>