function display_categories($cats)
{
echo '<ul>';
foreach ($cats as $cat) {
echo '<li><a href="' . base_url() . 'cart/category/' . $cat['category']->slug . '">' . $cat['category']->name . '</a>';
if (sizeof($cat['children']) > 0) {
display_categories($cat['children']);
}
echo '</li>';
}
echo '</ul>';
}
function shopp_categories_menu($options = array('exclude' => NULL))
{
extract($options);
$cats = SA_SHOPP_ACTIVE ? display_categories('links') : null;
if (!is_null($cats)) {
?>
<?php
foreach ($cats as $key => $cat) {
?>
<?php
if (!in_array($key, $exclude)) {
?>
<?php
$subcats = display_categories('links', $key);
?>
<h5 class="shopp-cat-<?php
echo $key;
?>
"><?php
echo $cat;
?>
</h5>
<?php
if (!is_null($subcats)) {
?>
<ul>
<?php
foreach ($subcats as $subkey => $subcat) {
?>
<li cat="shopp-cat-<?php
echo $subkey;
?>
shopp-parent-<?php
echo $key;
?>
"><?php
echo $subcat;
?>
</li>
<?php
}
?>
</ul>
<?php
}
?>
<?php
}
}
}
}
function display_categories($id = null, $level = 0)
{
global $wpdb, $category_data;
if (is_numeric($id)) {
$category_sql = "SELECT * FROM `" . $wpdb->prefix . "product_categories` WHERE `active`='1' AND `category_parent` = '" . $id . "' ORDER BY `id`";
$category_list = $wpdb->get_results($category_sql, ARRAY_A);
} else {
$category_sql = "SELECT * FROM `" . $wpdb->prefix . "product_categories` WHERE `active`='1' AND `category_parent` = '0' ORDER BY `id`";
$category_list = $wpdb->get_results($category_sql, ARRAY_A);
}
if ($category_list != null) {
foreach ($category_list as $category) {
display_category_row($category, $level);
display_categories($category['id'], $level + 1);
}
}
}
$template['files'][] = 'resources_retrieve.html';
$template['resources'] = "";
$template['category_list'] = "";
// Pull all details
$all_locations_assoc = $db->GetAssoc("SELECT * FROM " . LOCATIONS_TABLE . " WHERE location_id != 0 ORDER BY loc_order_hash ASC, loc_name ASC");
// Define the SQL to pull all resources, alter if a specific row is requested
$sql = "SELECT * FROM " . RESOURCES_TABLE;
if ($row = isset($_GET['row'])) {
$sql .= " WHERE resource_id = " . clean_string($_GET['row']);
}
$all_resources = $db->Execute($sql . " ORDER BY resource_id ASC");
// If this isn't a category refresh, we generate the return location and bookable location drop-downs
if (!$cat) {
$template['location_list'] = display_form($all_locations, "create_base_location", FALSE, FALSE);
$template['book_location'] = str_replace("create_base_location", "create_book_location", $template['location_list']);
// Display resources
foreach ($all_resources as $resource) {
$display = display_resource($resource);
if ($ajax) {
echo $display;
} else {
$template['resources'] .= $display;
}
}
}
$template['category_list'] = display_categories($all_categories);
if ($ajax && $cat) {
echo $template['category_list'];
} else {
$template['category_list'] = display_categories($all_categories);
}
<?php
require 'book_sc_fns.php';
session_start();
do_html_header("Welcome to BUKVOFIL shop!");
echo '<p>Please, choose your category:</p>';
$cat_array = get_categories();
display_categories($cat_array);
if (isset($_SESSION['admin_user'])) {
display_button("admin.php", "admin_menu", "Administration menu");
}
do_html_footer();
function add_category_form($in_action, $type = 'simple')
{
$in_action = Security::remove_XSS($in_action);
// Initiate the object
$form = new FormValidator('note', 'post', api_get_self() . '?' . api_get_cidreq() . '&action=' . $in_action . "&type=" . $type);
// Setting the form elements
$form->addElement('header', get_lang('AddACategory'));
$form->addElement('text', 'category_name', get_lang('CategoryName'), array('class' => 'span6'));
$form->add_html_editor('category_description', get_lang('CategoryDescription'), false, false, array('ToolbarSet' => 'test_category', 'Width' => '90%', 'Height' => '200'));
$form->addElement('select', 'parent_id', get_lang('Parent'), array(), array('id' => 'parent_id'));
$form->addElement('style_submit_button', 'SubmitNote', get_lang('AddTestCategory'), 'class="add"');
// Setting the rules
$form->addRule('category_name', get_lang('ThisFieldIsRequired'), 'required');
// The validation or display
if ($form->validate()) {
$check = Security::check_token('post');
if ($check) {
$values = $form->getSubmitValues();
$parent_id = isset($values['parent_id']) && isset($values['parent_id'][0]) ? $values['parent_id'][0] : null;
$objcat = new Testcategory(0, $values['category_name'], $values['category_description'], $parent_id, $type, api_get_course_int_id());
if ($objcat->addCategoryInBDD()) {
Display::display_confirmation_message(get_lang('AddCategoryDone'));
} else {
Display::display_confirmation_message(get_lang('AddCategoryNameAlreadyExists'));
}
}
Security::clear_token();
display_add_category($type);
display_categories($type);
} else {
display_goback($type);
$token = Security::get_token();
$form->addElement('hidden', 'sec_token');
$form->setConstants(array('sec_token' => $token));
$form->display();
}
}
function widget($args, $instance)
{
extract($args);
$parentcat = esc_attr($instance['parentcat']);
$cats = display_categories('links', $parentcat);
$numcats = count($cats);
$rem = $numcats % 2;
if ($rem == 0) {
//even num
$col = $numcats / 2;
} else {
$col = floor($numcats / 2) + 1;
}
echo $before_widget;
echo $before_title;
echo 'Shop ' . get_bloginfo('name') . ' Brands';
//.' '.$col.' '.$numcats . ' '. $rem;
echo $after_title;
echo '<ul id="sabrandslist1">';
$i = 0;
foreach ($cats as $cat) {
if ($i == $col) {
echo '</ul><ul id="sabrandslist2">';
}
echo "<li>{$cat}</li>";
$i++;
}
echo '</ul>';
echo $after_widget;
}
function display_categories($cats, $layer, $first = '')
{
if ($first) {
echo '<ul' . $first . '>';
}
foreach ($cats as $cat) {
echo '<li><a href="' . base_url() . '' . $cat['category']->slug . '">' . $cat['category']->name . '</a>' . "\n";
if (sizeof($cat['children']) > 0) {
if ($layer == 1) {
$next = $layer + 1;
display_categories($cat['children'], $next, ' class="first"');
} else {
$next = $layer + 1;
display_categories($cat['children'], $next, ' class="nav"');
}
}
echo '</li>';
}
if ($first) {
echo '</ul>';
}
}
</p>
<?php
}
?>
</form>
<?php
} elseif ($step == 2) {
display_database_config();
} elseif ($step == 3) {
if (!isset($error["error"])) {
display_target();
} else {
display_database_error($error, $step - 1);
}
} elseif ($step == 4) {
display_categories();
} elseif ($step == 5) {
display_finish();
}
?>
</div>
<div id="footer">
<ul>
<li>
<a href="<?php
echo get_absolute_url();
?>
readme.php" target="_blank">Readme</a>
</li>
<li>
<a href="http://osclass.org/contact/" target="_blank">Feedback</a>
}
} else {
// Standard stuff. Get the ID, then run the query. If the query succeeds, print message.
if ($db->Execute("DELETE FROM " . RESOURCES_TABLE . " WHERE resource_id = {$id}")) {
$db->Execute("DELETE FROM " . BOOKINGS_TABLE . " WHERE resource_id = {$id}");
echo "<p>Resource successfully deleted.</p>";
} else {
echo "<p>There was a database error: " . $db->ErrorMsg() . "</p>";
}
}
echo "<p><small>[ <a href=\"javascript:hide_element('AJAX_update')\">Hide this message</a> ]</small></p>\n";
} else {
$id = clean_string($_GET['id']);
if ($cat) {
// Initialise variables and
$update = clean_string($_GET['update']);
$categories = $db->GetAssoc("SELECT * FROM " . RESOURCE_CATEGORIES_TABLE);
$cat_resources = $db->GetArray("SELECT * FROM " . RESOURCES_TABLE . " WHERE category_id = {$id}");
$name = $categories[$id];
if (($has_resources = count($cat_resources)) > 0) {
// Remove the category to delete from the array, and generate the list
$categories[$id] = FALSE;
$categories = array_filter($categories);
}
$category_list = display_categories($categories, 0, "new_category");
require_once $root_path . 'style/templates/category_delete.html';
} else {
// Display confirm form
require_once $root_path . 'style/templates/resources_delete.html';
}
}
function wpsc_display_groups_page()
{
global $wpdb, $wp_rewrite;
if (!is_numeric($_GET['category_group']) || (int) $_GET['category_group'] == null) {
$current_categorisation = $wpdb->get_row("SELECT * FROM `" . WPSC_TABLE_CATEGORISATION_GROUPS . "` WHERE `active` IN ('1') AND `default` IN ('1') LIMIT 1 ", ARRAY_A);
} else {
$current_categorisation = $wpdb->get_row("SELECT * FROM `" . WPSC_TABLE_CATEGORISATION_GROUPS . "` WHERE `active` IN ('1') AND `id` IN ('" . (int) $_GET['category_group'] . "') LIMIT 1 ", ARRAY_A);
}
if ($_POST['submit_action'] == "add") {
//exit("<pre>".print_r($_POST,true)."</pre>");
if ($_FILES['image'] != null && preg_match("/\\.(gif|jp(e)*g|png){1}\$/i", $_FILES['image']['name'])) {
if (function_exists("getimagesize")) {
if ((int) $_POST['width'] > 10 && (int) $_POST['width'] < 512 && ((int) $_POST['height'] > 10 && (int) $_POST['height'] < 512)) {
$width = (int) $_POST['width'];
$height = (int) $_POST['height'];
image_processing($_FILES['image']['tmp_name'], WPSC_CATEGORY_DIR . $_FILES['image']['name'], $width, $height);
} else {
image_processing($_FILES['image']['tmp_name'], WPSC_CATEGORY_DIR . $_FILES['image']['name']);
}
$image = $wpdb->escape($_FILES['image']['name']);
} else {
$new_image_path = WPSC_CATEGORY_DIR . basename($_FILES['image']['name']);
move_uploaded_file($_FILES['image']['tmp_name'], $new_image_path);
$stat = stat(dirname($new_image_path));
$perms = $stat['mode'] & 0666;
@chmod($new_image_path, $perms);
$image = $wpdb->escape($_FILES['image']['name']);
}
} else {
$image = '';
}
if (is_numeric($_POST['category_parent'])) {
$parent_category = (int) $_POST['category_parent'];
} else {
$parent_category = 0;
}
//$tidied_name = sanitize_title();
//$tidied_name = strtolower($tidied_name);
$url_name = sanitize_title($_POST['name']);
$similar_names = $wpdb->get_row("SELECT COUNT(*) AS `count`, MAX(REPLACE(`nice-name`, '{$url_name}', '')) AS `max_number` FROM `" . WPSC_TABLE_PRODUCT_CATEGORIES . "` WHERE `nice-name` REGEXP '^({$url_name}){1}(\\d)*\$' ", ARRAY_A);
$extension_number = '';
if ($similar_names['count'] > 0) {
$extension_number = (int) $similar_names['max_number'] + 1;
}
$url_name .= $extension_number;
switch ($_POST['display_type']) {
case "grid":
$display_type = 'grid';
break;
case "list":
$display_type = 'list';
break;
case "default":
$display_type = 'default';
break;
default:
$display_type = '';
break;
}
if ($_POST['product_height'] > 0) {
$product_height = (int) $_POST['product_height'];
} else {
$product_height = '';
}
if ($_POST['product_width'] > 0) {
$product_width = (int) $_POST['product_width'];
} else {
$product_width = '';
}
if (trim($_POST['name']) != null) {
//$_POST['name'] = "test";
$insertsql = "INSERT INTO `" . WPSC_TABLE_PRODUCT_CATEGORIES . "` (`group_id`, `name` , `nice-name` , `description`, `image`, `fee` , `active`, `category_parent`, `order` ) VALUES ( '" . (int) $_POST['categorisation_group'] . "', '" . $wpdb->escape(stripslashes($_POST['name'])) . "', '" . $url_name . "', '" . $wpdb->escape(stripslashes($_POST['description'])) . "', '{$image}', '0', '1' ,'{$parent_category}', '0')";
$wp_rewrite->flush_rules();
if ($wpdb->query($insertsql)) {
$category_id = $wpdb->get_var("SELECT LAST_INSERT_ID() AS `id` FROM `" . WPSC_TABLE_PRODUCT_CATEGORIES . "` LIMIT 1");
if ($_POST['use_additonal_form_set'] != '') {
wpsc_update_categorymeta($category_id, 'use_additonal_form_set', $_POST['use_additonal_form_set']);
} else {
wpsc_delete_categorymeta($category_id, 'use_additonal_form_set');
}
if ((bool) (int) $_POST['uses_billing_address'] == true) {
wpsc_update_categorymeta($category_id, 'uses_billing_address', 1);
$uses_additional_forms = true;
} else {
wpsc_update_categorymeta($category_id, 'uses_billing_address', 0);
$uses_additional_forms = false;
}
// if($uses_additional_forms == true) {
// $checkout_form_sets = get_option('wpsc_checkout_form_sets');
// $checkout_form_sets[$url_name] = $wpdb->escape(stripslashes($_POST['name']));
// update_option('wpsc_checkout_form_sets', $checkout_form_sets);
// }
echo "<div class='updated'><p align='center'>" . __('The item has been added', 'wpsc') . "</p></div>";
} else {
echo "<div class='updated'><p align='center'>" . __('The item has not been added', 'wpsc') . "</p></div>";
}
update_option('wpsc_category_url_cache', array());
$wp_rewrite->flush_rules();
} else {
echo "<div class='updated'><p align='center'>" . __('The item has not been added', 'wpsc') . "</p></div>";
}
// Jeff 15-04-09 Used for category target market options
if ($_POST['countrylist2'] != null && $category_id > 0) {
$AllSelected = false;
$countryList = $wpdb->get_col("SELECT `id` FROM `" . WPSC_TABLE_CURRENCY_LIST . "`");
if (in_array('all', $_POST['countrylist2'])) {
foreach ($countryList as $country) {
$wpdb->query("INSERT INTO `" . WPSC_TABLE_CATEGORY_TM . "`(`visible`, `countryid`, `categoryid`) VALUES ('1','{$country}', '{$category_id}' )");
//echo "REPLACE INTO `".WPSC_TABLE_CATEGORY_TM."`(`visible`, `countryid`, `categoryid`) VALUES ('1','{$country}', '{$category_id}' )<br />";
}
$AllSelected = true;
}
if (in_array('none', $_POST['countrylist2'])) {
foreach ($countryList as $country) {
$wpdb->query("REPLACE INTO `" . WPSC_TABLE_CATEGORY_TM . "`(`visible`, `countryid`, `categoryid`) VALUES ('0','{$country}', '{$category_id}' )");
}
$AllSelected = true;
}
if ($AllSelected != true) {
$unselectedCountries = array_diff($countryList, $_POST['countrylist2']);
foreach ($unselectedCountries as $unselected) {
$wpdb->query("REPLACE INTO `" . WPSC_TABLE_CATEGORY_TM . "`(`visible`, `countryid`, `categoryid`) VALUES ('0','{$unselected}', '{$category_id}' )");
//echo "REPLACE INTO `".WPSC_TABLE_CATEGORY_TM."`(`visible`, `countryid`, `categoryid`) VALUES ('0','{$unselected}', '{$category_id}' )<br />";
}
//find the countries that are selected
$selectedCountries = array_intersect($countryList, $_POST['countrylist2']);
foreach ($selectedCountries as $selected) {
$wpdb->query("REPLACE INTO `" . WPSC_TABLE_CATEGORY_TM . "`(`visible`, `countryid`, `categoryid`) VALUES ('1','{$selected}', '{$category_id}' )");
//echo "REPLACE INTO `".WPSC_TABLE_CATEGORY_TM."`(`visible`, `countryid`, `categoryid`) VALUES ('1','{$unselected}', '{$category_id}' )<br />";
}
}
}
}
if ($_POST['submit_action'] == "edit" && is_numeric($_POST['prodid'])) {
$category_id = absint($_POST['prodid']);
if ($_FILES['image'] != null && preg_match("/\\.(gif|jp(e)*g|png){1}\$/i", $_FILES['image']['name'])) {
if (function_exists("getimagesize")) {
if ((int) $_POST['width'] >= 10 && (int) $_POST['width'] <= 512 && ((int) $_POST['height'] >= 10 && (int) $_POST['height'] <= 512)) {
$width = (int) $_POST['width'];
$height = (int) $_POST['height'];
image_processing($_FILES['image']['tmp_name'], WPSC_CATEGORY_DIR . $_FILES['image']['name'], $width, $height);
} else {
image_processing($_FILES['image']['tmp_name'], WPSC_CATEGORY_DIR . $_FILES['image']['name']);
}
$image = $wpdb->escape($_FILES['image']['name']);
} else {
move_uploaded_file($_FILES['image']['tmp_name'], WPSC_CATEGORY_DIR . $_FILES['image']['name']);
$image = $wpdb->escape($_FILES['image']['name']);
}
} else {
$image = '';
}
if (is_numeric($_POST['height']) && is_numeric($_POST['width']) && $image == null) {
$imagedata = $wpdb->get_var("SELECT `image` FROM `" . WPSC_TABLE_PRODUCT_CATEGORIES . "` WHERE `id`=" . (int) $_POST['prodid'] . " LIMIT 1");
if ($imagedata != null) {
$height = $_POST['height'];
$width = $_POST['width'];
$imagepath = WPSC_CATEGORY_DIR . $imagedata;
$image_output = WPSC_CATEGORY_DIR . $imagedata;
image_processing($imagepath, $image_output, $width, $height);
}
}
$category_data = $wpdb->get_row("SELECT * FROM `" . WPSC_TABLE_PRODUCT_CATEGORIES . "` WHERE `id` IN ('" . (int) $_POST['prodid'] . "')", ARRAY_A);
if ($_POST['title'] != $category_data['name'] && trim($_POST['title']) != null) {
$category_name = $_POST['title'];
$category_sql_list[] = "`name` = '{$category_name}' ";
/* creates and checks the tidy URL name */
// $tidied_name = trim($category_name);
// $tidied_name = strtolower($tidied_name);
$url_name = sanitize_title($category_name);
if ($url_name != $category_data['nice-name']) {
$similar_names = $wpdb->get_row("SELECT COUNT(*) AS `count`, MAX(REPLACE(`nice-name`, '{$url_name}', '')) AS `max_number` FROM `" . WPSC_TABLE_PRODUCT_CATEGORIES . "` WHERE `nice-name` REGEXP '^({$url_name}){1}(0-9)*\$' AND `id` NOT IN ('" . (int) $category_data['id'] . "') ", ARRAY_A);
//exit("<pre>".print_r($similar_names,true)."</pre>");
$extension_number = '';
if ($similar_names['count'] > 0) {
$extension_number = (int) $similar_names['max_number'] + 1;
}
$url_name .= $extension_number;
}
/* checks again, just in case */
if ($url_name != $category_data['nice-name']) {
$category_sql_list[] = "`nice-name` = '{$url_name}' ";
}
update_option('wpsc_category_url_cache', array());
$wp_rewrite->flush_rules();
}
// Jeff 15-04-09 Used for category target market options
if ($_POST['countrylist2'] != null) {
$countryList = $wpdb->get_col("SELECT `id` FROM `" . WPSC_TABLE_CURRENCY_LIST . "`");
$AllSelected = false;
if (in_array('all', $_POST['countrylist2'])) {
foreach ($countryList as $country) {
$wpdb->query("REPLACE INTO `" . WPSC_TABLE_CATEGORY_TM . "`(`visible`, `countryid`, `categoryid`) VALUES ('1','{$country}', '{$category_id}' )");
}
$AllSelected = true;
}
if (in_array('none', $_POST['countrylist2'])) {
$wpdb->query("UPDATE `" . WPSC_TABLE_CATEGORY_TM . "` SET `visible` = '0' WHERE `categoryid`='{$category_id}'");
$AllSelected = true;
}
if ($AllSelected != true) {
$unselectedCountries = array_diff($countryList, $_POST['countrylist2']);
foreach ($unselectedCountries as $unselected) {
$wpdb->query("REPLACE INTO `" . WPSC_TABLE_CATEGORY_TM . "` (`visible`, `countryid`, `categoryid`) VALUES (0,'{$unselected}', '{$category_id}' )");
}
//find the countries that are selected
$selectedCountries = array_intersect($countryList, $_POST['countrylist2']);
foreach ($selectedCountries as $selected) {
$wpdb->query("REPLACE INTO `" . WPSC_TABLE_CATEGORY_TM . "`(`visible`, `countryid`, `categoryid`) VALUES ('1','{$selected}', '{$category_id}' )");
}
}
}
if ($_POST['description'] != $category_data['description']) {
$description = $_POST['description'];
$category_sql_list[] = "`description` = '{$description}' ";
}
if (is_numeric($_POST['category_parent']) and $_POST['category_parent'] != $category_data['category_parent']) {
$parent_category = (int) $_POST['category_parent'];
$category_sql_list[] = "`category_parent` = '{$parent_category}' ";
}
if ($_POST['deleteimage'] == 1) {
$category_sql_list[] = "`image` = ''";
} else {
if ($image != null) {
$category_sql_list[] = "`image` = '{$image}'";
}
}
if ($_POST['display_type'] != $category_data['display_type']) {
switch ($_POST['display_type']) {
case "grid":
$display_type = 'grid';
break;
case "list":
$display_type = 'list';
break;
case "default":
$display_type = 'default';
break;
default:
$display_type = '';
break;
}
$category_sql_list[] = "`display_type` = '{$display_type}' ";
}
//echo "<pre>".print_r($category_sql_list,true)."</pre>";
if ($_POST['product_height'] > 0) {
$product_height = (int) $_POST['product_height'];
} else {
$product_height = '';
}
$category_sql_list[] = "`image_height` = '{$product_height}' ";
if ($_POST['product_width'] > 0) {
$product_width = (int) $_POST['product_width'];
} else {
$product_width = '';
}
$category_sql_list[] = "`image_width` = '{$product_width}' ";
if (count($category_sql_list) > 0) {
$category_sql = implode(", ", $category_sql_list);
$wpdb->query("UPDATE `" . WPSC_TABLE_PRODUCT_CATEGORIES . "` SET {$category_sql} WHERE `id`='" . (int) $_POST['prodid'] . "' LIMIT 1");
$category_id = absint($_POST['prodid']);
update_option('wpsc_category_url_cache', array());
if ($_POST['use_additonal_form_set'] != '') {
wpsc_update_categorymeta($category_id, 'use_additonal_form_set', $_POST['use_additonal_form_set']);
} else {
wpsc_delete_categorymeta($category_id, 'use_additonal_form_set');
}
if ((bool) (int) $_POST['uses_billing_address'] == true) {
wpsc_update_categorymeta($category_id, 'uses_billing_address', 1);
$uses_additional_forms = true;
} else {
wpsc_update_categorymeta($category_id, 'uses_billing_address', 0);
$uses_additional_forms = false;
}
// if($uses_additional_forms == true) {
// $category_name = $wpdb->escape(stripslashes($_POST['title']));
// $url_name = sanitize_title($category_name);
// $checkout_form_sets = get_option('wpsc_checkout_form_sets');
// $checkout_form_sets[$url_name] = $category_name;
// //print_r($checkout_form_sets);
// //exit();
// update_option('wpsc_checkout_form_sets', $checkout_form_sets);
// }
$wp_rewrite->flush_rules();
}
echo "<div class='updated'><p align='center'>" . __('The product group has been edited.', 'wpsc') . "</p></div>";
}
if ($_POST['submit_action'] == "add_categorisation") {
$wpdb->query("INSERT INTO `" . WPSC_TABLE_CATEGORISATION_GROUPS . "` ( `name`, `description`, `active`, `default`) VALUES ( '" . $wpdb->escape(stripslashes($_POST['name'])) . "', '" . $wpdb->escape(stripslashes($_POST['description'])) . "', '1', '0')");
echo "<div class='updated'><p align='center'>" . __('The group has been added.', 'wpsc') . "</p></div>";
}
if ($_POST['submit_action'] == "edit_categorisation") {
$edit_group_id = $_POST['group_id'];
$wpdb->query("UPDATE `" . WPSC_TABLE_CATEGORISATION_GROUPS . "` SET `name` = '" . $wpdb->escape(stripslashes($_POST['name'])) . "', `description` = '" . $wpdb->escape(stripslashes($_POST['description'])) . "' WHERE `id` IN('{$edit_group_id}') LIMIT 1 ");
echo "<div class='updated'><p align='center'>" . __('The group has been edited.', 'wpsc') . "</p></div>";
if (!is_numeric($_GET['category_group']) || (int) $_GET['category_group'] == null) {
$current_categorisation = $wpdb->get_row("SELECT * FROM `" . WPSC_TABLE_CATEGORISATION_GROUPS . "` WHERE `active` IN ('1') AND `default` IN ('1') LIMIT 1 ", ARRAY_A);
} else {
$current_categorisation = $wpdb->get_row("SELECT * FROM `" . WPSC_TABLE_CATEGORISATION_GROUPS . "` WHERE `active` IN ('1') AND `id` IN ('" . (int) $_GET['category_group'] . "') LIMIT 1 ", ARRAY_A);
}
}
if (is_numeric($_GET['category_delete_id'])) {
$delete_id = (int) $_GET['category_delete_id'];
$deletesql = "UPDATE `" . WPSC_TABLE_CATEGORISATION_GROUPS . "` SET `active` = '0' WHERE `id`='{$delete_id}' AND `default` IN ('0') LIMIT 1";
$wpdb->query($deletesql);
$delete_subcat_sql = "UPDATE `" . WPSC_TABLE_PRODUCT_CATEGORIES . "` SET `active` = '0', `nice-name` = '' WHERE `group_id`='{$delete_id}'";
$wpdb->query($delete_subcat_sql);
update_option('wpsc_category_url_cache', array());
$wp_rewrite->flush_rules();
}
if (is_numeric($_GET['deleteid'])) {
$delete_id = absint($_GET['deleteid']);
$deletesql = "UPDATE `" . WPSC_TABLE_PRODUCT_CATEGORIES . "` SET `active` = '0', `nice-name` = '' WHERE `id`='{$delete_id}' LIMIT 1";
if ($wpdb->query($deletesql)) {
$delete_subcat_sql = "UPDATE `" . WPSC_TABLE_PRODUCT_CATEGORIES . "` SET `active` = '0', `nice-name` = '' WHERE `category_parent`='{$delete_id}'";
$wpdb->query($delete_subcat_sql);
// if this is the default category, we need to find a new default category
if ($delete_id == get_option('wpsc_default_category')) {
// select the category that is not deleted with the greatest number of products in it
$new_default = $wpdb->get_var("SELECT `cat`.`id` FROM `" . WPSC_TABLE_PRODUCT_CATEGORIES . "` AS `cat`\r\n\t\t\t\tLEFT JOIN `" . WPSC_TABLE_ITEM_CATEGORY_ASSOC . "` AS `assoc` ON `cat`.`id` = `assoc`.`category_id`\r\n\t\t\t\tWHERE `cat`.`active` IN ( '1' )\r\n\t\t\t\tGROUP BY `cat`.`id`\r\n\t\t\t\tORDER BY COUNT( `assoc`.`id` ) DESC\r\n\t\t\t\tLIMIT 1");
if ($new_default > 0) {
update_option('wpsc_default_category', $new_default);
}
}
update_option('wpsc_category_url_cache', array());
$wp_rewrite->flush_rules();
}
}
unset($GLOBALS['wpsc_category_url_cache']);
update_option('wpsc_category_url_cache', array());
?>
<script language='javascript' type='text/javascript'>
function conf() {
var check = confirm("<?php
echo __('Are you sure you want to delete this category? If the category has any subcategories, they will be deleted too.', 'wpsc');
?>
");
if(check) {
return true;
} else {
return false;
}
}
function categorisation_conf() {
var check = confirm("<?php
echo __('Are you sure you want to delete this product group? All categories it contains will be deleted too.', 'wpsc');
?>
");
if(check) {
return true;
} else {
return false;
}
}
<?php
if (is_numeric($_POST['prodid'])) {
echo "fillcategoryform(" . $_POST['prodid'] . ");";
}
?>
</script>
<div class="wrap">
<h2><?php
echo __('Categories', 'wpsc');
?>
</h2>
<?php
if (function_exists('add_object_page')) {
echo "<div id='dashboard-widgets' class='metabox-holder'>";
}
?>
<span><?php
echo __('Categorizing your products into groups help your customers find them. For instance if you sell hats and trousers you might want to setup a Group called clothes and add hats and trousers to that group.', 'wpsc');
?>
</span>
<?php
if (function_exists('add_object_page')) {
echo "<div class='wpsc_products_nav27'>";
} else {
echo "<div class='tablenav wpsc_groups_nav' >";
}
?>
<div class="alignleft product_group" style='width: 500px;'>
<form action='' method='GET' id='submit_categorisation_form' >
<input type='hidden' value='<?php
echo $_GET['page'];
?>
' name='page' />
<?php
$categorisation_groups = $wpdb->get_results("SELECT * FROM `" . WPSC_TABLE_CATEGORISATION_GROUPS . "` WHERE `active` IN ('1')", ARRAY_A);
//echo "<ul class='categorisation_links'>\n\r";
echo "<label for='select_categorisation_group' class='select_categorisation_group'>" . __('Select a Group to Manage', 'wpsc') . ": </label>";
echo "<select name='category_group' id='select_categorisation_group' onchange='submit_status_form(\"submit_categorisation_form\")'>";
foreach ((array) $categorisation_groups as $categorisation_group) {
$selected = '';
if ($current_categorisation['id'] == $categorisation_group['id']) {
//$selected = "class='selected'";
$selected = "selected='selected'";
}
echo "<option value='{$categorisation_group['id']}' {$selected} >{$categorisation_group['name']}</option>";
//echo " <li $selected >\n\r";
//echo " <a href='?page={$_GET['page']}&category_group={$categorisation_group['id']}'>{$categorisation_group['name']}</a> ";
//echo " </li>\n\r";
}
echo "</select>";
//echo "<li>- <a href='' onclick='return showadd_categorisation_form()'><span>".__('Add New Group', 'wpsc')."</span></a></li>";
//echo "</ul>\n\r";
?>
<span><?php
_e('or');
?>
</span>
<?php
echo "<a class='button add_categorisation_group' href='#' onclick='return showadd_categorisation_form()'><span>" . __('Add New Group', 'wpsc') . "</span></a>";
?>
</form>
</div>
<!--
<div class="alignright">
<a target="_blank" href='http://www.instinct.co.nz/e-commerce/product-groups/' class='about_this_page'><span><?php
//echo __('About This Page', 'wpsc');
?>
</span> </a>
</div>
-->
<br class="clear"/>
</div>
<div id='add_categorisation'>
<strong><?php
echo __('Add New Group', 'wpsc');
?>
</strong>
<form method='POST' enctype='multipart/form-data'>
<fieldset>
<label for='add_categorisation_name'>Name</label>
<input type='text' name='name' value='' id='add_categorisation_name' />
</fieldset>
<fieldset>
<label for='add_categorisation_description'>Description</label>
<input type='text' name='description' value='' id='add_categorisation_description' />
</fieldset>
<fieldset>
<label> </label>
<input type='hidden' name='submit_action' value='add_categorisation' />
<input type='submit' name='submit_form' value='<?php
echo __('Submit', 'wpsc');
?>
' />
</fieldset>
</form>
<br/>
</div>
<div id='edit_categorisation'>
<strong><?php
echo __('Edit Group', 'wpsc');
?>
</strong>
<form method='POST' enctype='multipart/form-data'>
<fieldset>
<label for='add_categorisation_name'>Name</label>
<input type='text' name='name' value='<?php
echo $current_categorisation['name'];
?>
' id='add_categorisation_name' />
</fieldset>
<fieldset>
<label for='add_categorisation_description'>Description</label>
<input type='text' name='description' value='<?php
echo $current_categorisation['description'];
?>
' id='add_categorisation_description' />
</fieldset>
<fieldset>
<label> </label>
<input type='hidden' name='group_id' value='<?php
echo $current_categorisation['id'];
?>
' />
<input type='hidden' name='submit_action' value='edit_categorisation' />
<input type='submit' name='submit_form' value='<?php
echo __('Submit', 'wpsc');
?>
' />
<?php
if ($current_categorisation['default'] != 1) {
?>
<a href='<?php
echo "?page={$_GET['page']}&category_delete_id={$current_categorisation['id']}";
?>
' onclick='return categorisation_conf()' > <?php
echo __('Delete', 'wpsc');
?>
</a>
<?php
}
?>
</fieldset>
</form>
<br/>
</div>
<?php
$num = 0;
echo " <table id='productpage' style='margin-top: 1ex;'>\n\r";
echo " <tr><td class='firstcol' style='width: 297px;'>\n\r";
if (function_exists('add_object_page')) {
echo "<div class='postbox' style='margin-right: 15px; min-width:255px;'>";
echo "<h3 class='hndle'>" . str_replace("[categorisation]", $current_categorisation['name'], __('"[categorisation]" Group', 'wpsc')) . "</h3>";
echo "<div class='inside'>";
}
//echo "<div class='categorisation_title'><a href='' onclick='return showaddform()' class='add_category_link'><span>". __('+ Add new category to the "[categorisation]" Group', 'wpsc')."</span></a><strong class='form_group'>".str_replace("[categorisation]", $current_categorisation['name'], __('Manage "[categorisation]"', 'wpsc'))." <a href='#' onclick='return showedit_categorisation_form()'>[".__('Edit', 'wpsc')."]</a> </strong></div>";
echo " <table id='itemlist'>\n\r";
if (function_exists('add_object_page')) {
echo "<tr></tr>";
} else {
echo " <tr class='firstrow categorisation_title'>\n\r";
echo " <td>\n\r";
echo __('Image', 'wpsc');
echo " </td>\n\r";
echo " <td>\n\r";
echo __('Name', 'wpsc');
echo " </td>\n\r";
echo " <td>\n\r";
//echo __('Description', 'wpsc');
echo " </td>\n\r";
echo " <td>\n\r";
echo __('Edit', 'wpsc');
echo " </td>\n\r";
echo " </tr>\n\r";
}
echo " <tr>\n\r";
echo " <td colspan='4' class='colspan'>\n\r";
echo "<div class='editing_this_group'><p>";
echo str_replace("[categorisation]", $current_categorisation['name'], __('You are editing the "[categorisation]" Group', 'wpsc'));
echo " <a href='#' onclick='return showedit_categorisation_form()'>" . __('Edit', 'wpsc') . "</a>";
echo "</p></div>";
echo " </td>\n\r";
echo " <tr>\n\r";
display_categories($current_categorisation['id']);
if (function_exists('add_object_page')) {
echo "</table>";
echo "</div>";
//class inside ends
echo "</div>";
//class postbox ends
} else {
echo "</table>\n\r";
}
echo " </td><td id='poststuff' class='secondcol product_groups_page'>\n\r";
echo " <div id='productform' class='postbox'>";
echo "<form method='POST' enctype='multipart/form-data' name='editproduct{$num}'>\n\r";
if (function_exists('add_object_page')) {
echo "<h3 class='hndle'>" . str_replace("[categorisation]", $current_categorisation['name'], __('You are editing an item in the "[categorisation]" Group', 'wpsc')) . "</h3>";
echo "<div class='inside'>";
} else {
echo "<div class='categorisation_title'><strong class='form_group'>" . __('Edit Details', 'wpsc') . " </strong></div>\n\r";
echo "<div class='editing_this_group'><p>" . str_replace("[categorisation]", $current_categorisation['name'], __('You are editing an item in the "[categorisation]" Group', 'wpsc')) . "</p></div>";
}
echo " <div id='formcontent'>\n\r";
echo " </div>\n\r";
if (function_exists('add_object_page')) {
echo "</div>";
}
echo "</form>\n\r";
echo " </div>\n\r";
?>
<div id="blank_item">
<h3 class="form_heading"><?php
echo str_replace("[categorisation]", $current_categorisation['name'], __('Add Category', 'wpsc'));
?>
</h3>
<div class="inside">
<a href='' onclick='return showaddform()' class='add_category_link'><span><?php
echo str_replace("[categorisation]", $current_categorisation['name'], __('+ Add new category to the "[categorisation]" Group', 'wpsc'));
?>
</span></a>
<span class="setting-description"><?php
echo __('Adding a new category here will make it available when you add or edit a product.', 'wpsc');
?>
</span>
</div>
</div>
<div id='additem' class='postbox'>
<h3 class='hndle'><?php
echo str_replace("[categorisation]", $current_categorisation['name'], __('You are adding a new item to the "[categorisation]" Group', 'wpsc'));
?>
</h3>
<div class='inside'>
<form method='post' enctype='multipart/form-data' class='additem'>
<div class='editing_this_group'><p> <?php
echo "" . str_replace("[categorisation]", $current_categorisation['name'], __('You are adding a new item to the "[categorisation]" Group', 'wpsc')) . "";
?>
</p></div>
<table class='category_forms form_table'>
<tr>
<td>
<?php
echo __('Name', 'wpsc');
?>
:
</td>
<td>
<input type='text' class="text" name='name' value='' />
</td>
</tr>
<tr>
<td>
<?php
echo __('Description', 'wpsc');
?>
:
</td>
<td>
<textarea name='description' rows='8'></textarea>
</td>
</tr>
<tr>
<td>
<?php
echo __('Group Parent', 'wpsc');
?>
:
</td>
<td>
<?php
echo wpsc_parent_category_list($current_categorisation['id'], 0, 0);
?>
</td>
</tr>
<tr>
<td>
<?php
echo __('Group Image', 'wpsc');
?>
:
</td>
<td>
<input type='file' name='image' value='' />
</td>
</tr>
<?php
if (function_exists("getimagesize")) {
?>
<tr>
<td>
</td>
<td>
<?php
echo __('Height', 'wpsc');
?>
:<input type='text' size='6' name='height' value='<?php
echo get_option('category_image_height');
?>
' /> <?php
echo __('Width', 'wpsc');
?>
:<input type='text' size='6' name='width' value='<?php
echo get_option('category_image_width');
?>
' /> <br />
<span class='wpscsmall description'><?php
echo __('You can upload thumbnail images for each group. To display Group details in your shop you must configure these settings under <a href="admin.php?page=wpsc-settings&tab=presentation">Presentation Settings</a>.', 'wpsc');
?>
</span>
</td>
</tr>
<?php
}
?>
<?php
wpsc_category_tm();
//category target market checkbox
?>
<tr>
<td colspan='2' class='category_presentation_settings'>
<h4><?php
echo __('Presentation Settings', 'wpsc');
?>
</h4>
<span class='small'><?php
echo __('To over-ride the presentation settings for this group you can enter in your prefered settings here', 'wpsc');
?>
</span>
</td>
</tr>
<tr>
<td>
<?php
echo __('Catalog View', 'wpsc');
?>
:
</td>
<td>
<select name='product_view'>
<option value='default' <?php
echo $product_view1;
?>
><?php
echo __('Default View', 'wpsc');
?>
</option>
<?php
if (function_exists('product_display_list')) {
?>
<option value='list' <?php
echo $product_view2;
?>
><?php
echo __('List View', 'wpsc');
?>
</option>
<?php
} else {
?>
<option value='list' disabled='disabled' <?php
echo $product_view2;
?>
><?php
echo __('List View', 'wpsc');
?>
</option>
<?php
}
if (function_exists('product_display_grid')) {
?>
<option value='grid' <?php
echo $product_view3;
?>
><?php
echo __('Grid View', 'wpsc');
?>
</option>
<?php
} else {
?>
<option value='grid' disabled='disabled' <?php
echo $product_view3;
?>
><?php
echo __('Grid View', 'wpsc');
?>
</option>
<?php
}
?>
</select>
</td>
</tr>
<tr>
<td colspan='2'>
<?php
echo __('Thumbnail Size', 'wpsc');
?>
:
<?php
echo __('Height', 'wpsc');
?>
: <input type='text' value='' name='product_height' size='6'/>
<?php
echo __('Width', 'wpsc');
?>
: <input type='text' value='' name='product_width' size='6'/> <br/>
</td>
</tr>
<tr>
<td colspan='2' class='category_presentation_settings'>
<h4><?php
_e('Checkout Settings', 'wpsc');
?>
</h4>
<?php
/* <span class='small'><?php _e('To over-ride the presentation settings for this group you can enter in your prefered settings here', 'wpsc'); ?></span> */
?>
</td>
</tr>
<tr>
<td><?php
_e("This category requires additional checkout form fields", 'wpsc');
?>
:</td>
<td>
<select name='use_additonal_form_set'>
<option value=''>None</option>
<?php
$checkout_sets = get_option('wpsc_checkout_form_sets');
unset($checkout_sets[0]);
foreach ((array) $checkout_sets as $key => $value) {
$selected_state = "";
if ($_GET['checkout-set'] == $key) {
$selected_state = "selected='selected'";
}
echo "<option {$selected_state} value='{$key}'>" . stripslashes($value) . "</option>";
}
?>
</select>
<?php
/* <label><input type="radio" name="uses_additonal_forms" value="1"/><?php _e("Yes",'wpsc'); ?></label> */
/* <label><input type="radio" checked="checked" name="uses_additonal_forms" value="0"/><?php _e("No",'wpsc'); ?></label>*/
?>
</td>
</tr>
<tr>
<td colspan='2'> </td>
</tr>
<tr>
<td><?php
_e("Products in this category use the billing address to calculate shipping", 'wpsc');
?>
:</td>
<td>
<label><input type="radio" name="uses_billing_address" value="1"/><?php
_e("Yes", 'wpsc');
?>
</label>
<label><input type="radio" checked="checked" name="uses_billing_address" value="0"/><?php
_e("No", 'wpsc');
?>
</label>
</td>
</tr>
<tr>
<td>
</td>
<td class='last_row'>
<input type='hidden' name='categorisation_group' value='<?php
echo $current_categorisation['id'];
?>
' />
<input type='hidden' name='submit_action' value='add' />
<input class='button-primary' type='submit' name='submit' value='<?php
echo __('Add Category', 'wpsc');
?>
' />
</td>
</tr>
</table>
</form>
</div>
</div>
</td></tr>
</table>
</div>
<?php
}
</p>
<?php
}
?>
</form>
<?php
} elseif ($step == 2) {
display_database_config();
} elseif ($step == 3) {
if (!isset($error["error"])) {
display_target();
} else {
display_database_error($error, $step - 1);
}
} elseif ($step == 4) {
display_categories($error, $password);
} elseif ($step == 5) {
// ping engines
ping_search_engines($_COOKIE['osclass_ping_engines']);
setcookie('osclass_save_stats', '', time() - 3600);
setcookie('osclass_ping_engines', '', time() - 3600);
display_finish($password);
}
?>
</div>
<div id="footer">
<ul>
<li>
<a href="<?php
echo get_absolute_url();
?>
/**
* fungsi display category khusus menggunakan rekursif
* @param type $parent
* @param type $titik_titik
*/
function display_categories($parent = 0, $titik_titik = '')
{
$sql = sql_display_table_master_categories_by_parent_category($parent);
$query = db_query($sql);
while ($row = db_fetch($query)) {
start_row("class='odd gradeX'");
text_cell($row['id'], "align='center'");
text_cell($titik_titik . $row['category_name'], "align='left'");
text_cell($row['description'], "align='left'");
edit_delete_link('tb_categories', $row['id'], $_SESSION['key'], "");
end_row();
$is_there = is_there_category_by_parent($row['id']);
if ($is_there) {
display_categories($row['id'], $titik_titik . "---- ");
}
}
}
function display_categories($parent_id, $section_id, $tiefe = 0)
{
$padding = $tiefe * 20;
global $database;
global $url;
global $page_id;
global $MOD_FOLDERGALLERY;
global $settings;
$list = "\n";
$sql = 'SELECT * FROM ' . TABLE_PREFIX . 'mod_foldergallery_categories WHERE parent_id=' . $parent_id . ' AND section_id =' . $section_id . ' ORDER BY `position` ASC;';
$query = $database->query($sql);
$zagl = $query->numRows();
$arrup = false;
$arrdown = true;
if ($zagl > 1) {
}
$counter = 0;
while ($result = $query->fetchRow()) {
$counter++;
if ($counter > 1) {
$arrup = true;
}
if ($counter == $zagl) {
$arrdown = false;
}
if ($parent_id != "-1") {
$cursor = ' cursor: move;';
$result['categorie'] = $settings['root_dir'] . $result['parent'] . '/' . $result['categorie'];
} else {
$cursor = '';
$result['categorie'] = $settings['root_dir'];
}
if ($result['active'] == 1) {
$activ_string = $MOD_FOLDERGALLERY['CAT_ACTIVE'];
} else {
$activ_string = $MOD_FOLDERGALLERY['CAT_INACTIVE'];
}
$list .= "<li id='recordsArray_" . $result['id'] . "' style='padding: 1px 0px 1px 0px;" . $cursor . "'>\n" . "<table width='100%' cellpadding='0' cellspacing='0' border='0' class='cat_table'>\n" . '<tr onmouseover="this.style.backgroundColor = \'#F1F8DD\';" onmouseout="this.style.backgroundColor = \'#ECF3F7\';">' . "<td width='20px' style='padding-left:" . $padding . "px'>\n";
if ($result['has_child']) {
// Display Expand Sign
$list .= '<a href="javascript: toggle_visibility(\'p' . $result['id'] . '\');" title="' . $MOD_FOLDERGALLERY['EXPAND_COLAPSE'] . '">' . '<img src="' . THEME_URL . '/images/plus_16.png" name="plus_minus_p' . $result['id'] . '" border="0" alt="+" />' . '</a>';
}
// Categorie Name and Folder
$list .= '</td>' . "<td width='" . (350 - $padding) . "px'><a href='" . $url['edit'] . $result['id'] . "' title='" . $MOD_FOLDERGALLERY['EDIT_CATEGORIE'] . "'>" . '<img src="' . THEME_URL . '/images/visible_16.png" alt="edit" border="0" align="left" style="margin-right: 5px" />' . $result['cat_name'] . "</a></td>" . "<td align='left'>" . $result['categorie'] . "</td>" . '<td width="30">';
// Active / Inactive Sign
if ($parent_id != "-1") {
$list .= '<a class="FG_active_categorie" href="javascript: toggle_active_inactive(\'p' . $result['id'] . '\');"><img id="ip' . $result['id'] . '" src="' . WB_URL . '/modules/foldergallery/images/active' . $result['active'] . '.gif" border="0" alt="" title="' . $activ_string . '" /></a> ';
}
$list .= '</td>' . "<td width='20'>";
if ($arrup == true) {
// Move up arrow
$list .= "<a href='" . WB_URL . "/modules/foldergallery/admin/scripts/move_up.php?page_id=" . $page_id . "§ion_id=" . $section_id . "&id=" . $result['id'] . "' title='" . $MOD_FOLDERGALLERY['MOVE_UP'] . "'>" . "<img src='" . THEME_URL . "/images/up_16.png' border='0' alt='v' /></a>";
}
$list .= "</td>" . "<td width='20'>";
if ($arrdown == true) {
// Move down arrow
$list .= "<a href='" . WB_URL . "/modules/foldergallery/admin/scripts/move_down.php?page_id=" . $page_id . "§ion_id=" . $section_id . "&id=" . $result['id'] . "' title='" . $MOD_FOLDERGALLERY['MOVE_DOWN'] . "'>" . "<img src='" . THEME_URL . "/images/down_16.png' border='0' alt='u' /></a>";
}
$list .= "</td>" . "</tr></table>\n" . "<ul id='p" . $result['id'] . "'style='padding: 1px 0px 1px 0px;' class='cat_subelem'>";
if ($result['has_child']) {
$list .= display_categories($result['id'], $section_id, $tiefe + 1);
}
$list .= "</ul></li>\n ";
}
return $list;
}
function wpsc_display_groups_page()
{
global $wpdb, $wp_rewrite;
if (!is_numeric($_GET['category_group']) || (int) $_GET['category_group'] == null) {
$current_categorisation = $wpdb->get_row("SELECT * FROM `" . WPSC_TABLE_CATEGORISATION_GROUPS . "` WHERE `active` IN ('1') AND `default` IN ('1') LIMIT 1 ", ARRAY_A);
} else {
$current_categorisation = $wpdb->get_row("SELECT * FROM `" . WPSC_TABLE_CATEGORISATION_GROUPS . "` WHERE `active` IN ('1') AND `id` IN ('" . (int) $_GET['category_group'] . "') LIMIT 1 ", ARRAY_A);
}
if ($_POST['submit_action'] == "add") {
//exit("<pre>".print_r($_POST,true)."</pre>");
if ($_FILES['image'] != null && preg_match("/\\.(gif|jp(e)*g|png){1}\$/i", $_FILES['image']['name'])) {
if (function_exists("getimagesize")) {
if ((int) $_POST['width'] > 10 && (int) $_POST['width'] < 512 && ((int) $_POST['height'] > 10 && (int) $_POST['height'] < 512)) {
$width = (int) $_POST['width'];
$height = (int) $_POST['height'];
image_processing($_FILES['image']['tmp_name'], WPSC_CATEGORY_DIR . $_FILES['image']['name'], $width, $height);
} else {
image_processing($_FILES['image']['tmp_name'], WPSC_CATEGORY_DIR . $_FILES['image']['name']);
}
$image = $wpdb->escape($_FILES['image']['name']);
} else {
$new_image_path = WPSC_CATEGORY_DIR . basename($_FILES['image']['name']);
move_uploaded_file($_FILES['image']['tmp_name'], $new_image_path);
$stat = stat(dirname($new_image_path));
$perms = $stat['mode'] & 0666;
@chmod($new_image_path, $perms);
$image = $wpdb->escape($_FILES['image']['name']);
}
} else {
$image = '';
}
if (is_numeric($_POST['category_parent'])) {
$parent_category = (int) $_POST['category_parent'];
} else {
$parent_category = 0;
}
//$tidied_name = sanitize_title();
//$tidied_name = strtolower($tidied_name);
$url_name = sanitize_title($_POST['name']);
$similar_names = $wpdb->get_row("SELECT COUNT(*) AS `count`, MAX(REPLACE(`nice-name`, '{$url_name}', '')) AS `max_number` FROM `" . WPSC_TABLE_PRODUCT_CATEGORIES . "` WHERE `nice-name` REGEXP '^({$url_name}){1}(\\d)*\$' ", ARRAY_A);
$extension_number = '';
if ($similar_names['count'] > 0) {
$extension_number = (int) $similar_names['max_number'] + 1;
}
$url_name .= $extension_number;
switch ($_POST['display_type']) {
case "grid":
$display_type = 'grid';
break;
case "list":
$display_type = 'list';
break;
case "default":
$display_type = 'default';
break;
default:
$display_type = '';
break;
}
if ($_POST['product_height'] > 0) {
$product_height = (int) $_POST['product_height'];
} else {
$product_height = '';
}
if ($_POST['product_width'] > 0) {
$product_width = (int) $_POST['product_width'];
} else {
$product_width = '';
}
if (trim($_POST['name']) != null) {
//$_POST['name'] = "test";
$insertsql = "INSERT INTO `" . WPSC_TABLE_PRODUCT_CATEGORIES . "` (`group_id`, `name` , `nice-name` , `description`, `image`, `fee` , `active`, `category_parent`, `order` ) VALUES ( '" . (int) $_POST['categorisation_group'] . "', '" . $wpdb->escape(stripslashes($_POST['name'])) . "', '" . $url_name . "', '" . $wpdb->escape(stripslashes($_POST['description'])) . "', '{$image}', '0', '1' ,'{$parent_category}', '0')";
$wp_rewrite->flush_rules();
if ($wpdb->query($insertsql)) {
$category_id = $wpdb->get_var("SELECT LAST_INSERT_ID() AS `id` FROM `" . WPSC_TABLE_PRODUCT_CATEGORIES . "` LIMIT 1");
echo "<div class='updated'><p align='center'>" . TXT_WPSC_ITEMHASBEENADDED . "</p></div>";
} else {
echo "<div class='updated'><p align='center'>" . TXT_WPSC_ITEMHASNOTBEENADDED . "</p></div>";
}
update_option('wpsc_category_url_cache', array());
$wp_rewrite->flush_rules();
} else {
echo "<div class='updated'><p align='center'>" . TXT_WPSC_ITEMHASNOTBEENADDED . "</p></div>";
}
// Jeff 15-04-09 Used for category target market options
if ($_POST['countrylist2'] != null && $category_id > 0) {
$AllSelected = false;
$countryList = $wpdb->get_col("SELECT `id` FROM `" . WPSC_TABLE_CURRENCY_LIST . "`");
if (in_array('all', $_POST['countrylist2'])) {
foreach ($countryList as $country) {
$wpdb->query("INSERT INTO `" . WPSC_TABLE_CATEGORY_TM . "`(`visible`, `countryid`, `categoryid`) VALUES ('1','{$country}', '{$category_id}' )");
//echo "REPLACE INTO `".WPSC_TABLE_CATEGORY_TM."`(`visible`, `countryid`, `categoryid`) VALUES ('1','{$country}', '{$category_id}' )<br />";
}
$AllSelected = true;
}
if (in_array('none', $_POST['countrylist2'])) {
foreach ($countryList as $country) {
$wpdb->query("REPLACE INTO `" . WPSC_TABLE_CATEGORY_TM . "`(`visible`, `countryid`, `categoryid`) VALUES ('0','{$country}', '{$category_id}' )");
}
$AllSelected = true;
}
if ($AllSelected != true) {
$unselectedCountries = array_diff($countryList, $_POST['countrylist2']);
foreach ($unselectedCountries as $unselected) {
$wpdb->query("REPLACE INTO `" . WPSC_TABLE_CATEGORY_TM . "`(`visible`, `countryid`, `categoryid`) VALUES ('0','{$unselected}', '{$category_id}' )");
//echo "REPLACE INTO `".WPSC_TABLE_CATEGORY_TM."`(`visible`, `countryid`, `categoryid`) VALUES ('0','{$unselected}', '{$category_id}' )<br />";
}
//find the countries that are selected
$selectedCountries = array_intersect($countryList, $_POST['countrylist2']);
foreach ($selectedCountries as $selected) {
$wpdb->query("REPLACE INTO `" . WPSC_TABLE_CATEGORY_TM . "`(`visible`, `countryid`, `categoryid`) VALUES ('1','{$selected}', '{$category_id}' )");
//echo "REPLACE INTO `".WPSC_TABLE_CATEGORY_TM."`(`visible`, `countryid`, `categoryid`) VALUES ('1','{$unselected}', '{$category_id}' )<br />";
}
}
}
}
if ($_POST['submit_action'] == "edit" && is_numeric($_POST['prodid'])) {
$category_id = absint($_POST['prodid']);
if ($_FILES['image'] != null && preg_match("/\\.(gif|jp(e)*g|png){1}\$/i", $_FILES['image']['name'])) {
if (function_exists("getimagesize")) {
if ((int) $_POST['width'] >= 10 && (int) $_POST['width'] <= 512 && ((int) $_POST['height'] >= 10 && (int) $_POST['height'] <= 512)) {
$width = (int) $_POST['width'];
$height = (int) $_POST['height'];
image_processing($_FILES['image']['tmp_name'], WPSC_CATEGORY_DIR . $_FILES['image']['name'], $width, $height);
} else {
image_processing($_FILES['image']['tmp_name'], WPSC_CATEGORY_DIR . $_FILES['image']['name']);
}
$image = $wpdb->escape($_FILES['image']['name']);
} else {
move_uploaded_file($_FILES['image']['tmp_name'], WPSC_CATEGORY_DIR . $_FILES['image']['name']);
$image = $wpdb->escape($_FILES['image']['name']);
}
} else {
$image = '';
}
if (is_numeric($_POST['height']) && is_numeric($_POST['width']) && $image == null) {
$imagedata = $wpdb->get_var("SELECT `image` FROM `" . WPSC_TABLE_PRODUCT_CATEGORIES . "` WHERE `id`=" . (int) $_POST['prodid'] . " LIMIT 1");
if ($imagedata != null) {
$height = $_POST['height'];
$width = $_POST['width'];
$imagepath = WPSC_CATEGORY_DIR . $imagedata;
$image_output = WPSC_CATEGORY_DIR . $imagedata;
image_processing($imagepath, $image_output, $width, $height);
}
}
$category_data = $wpdb->get_row("SELECT * FROM `" . WPSC_TABLE_PRODUCT_CATEGORIES . "` WHERE `id` IN ('" . (int) $_POST['prodid'] . "')", ARRAY_A);
if ($_POST['title'] != $category_data['name'] && trim($_POST['title']) != null) {
$category_name = $_POST['title'];
$category_sql_list[] = "`name` = '{$category_name}' ";
/* creates and checks the tidy URL name */
// $tidied_name = trim($category_name);
// $tidied_name = strtolower($tidied_name);
$url_name = sanitize_title($category_name);
if ($url_name != $category_data['nice-name']) {
$similar_names = $wpdb->get_row("SELECT COUNT(*) AS `count`, MAX(REPLACE(`nice-name`, '{$url_name}', '')) AS `max_number` FROM `" . WPSC_TABLE_PRODUCT_CATEGORIES . "` WHERE `nice-name` REGEXP '^({$url_name}){1}(0-9)*\$' AND `id` NOT IN ('" . (int) $category_data['id'] . "') ", ARRAY_A);
//exit("<pre>".print_r($similar_names,true)."</pre>");
$extension_number = '';
if ($similar_names['count'] > 0) {
$extension_number = (int) $similar_names['max_number'] + 1;
}
$url_name .= $extension_number;
}
/* checks again, just in case */
if ($url_name != $category_data['nice-name']) {
$category_sql_list[] = "`nice-name` = '{$url_name}' ";
}
update_option('wpsc_category_url_cache', array());
$wp_rewrite->flush_rules();
}
// Jeff 15-04-09 Used for category target market options
if ($_POST['countrylist2'] != null) {
$countryList = $wpdb->get_col("SELECT `id` FROM `" . WPSC_TABLE_CURRENCY_LIST . "`");
$AllSelected = false;
if (in_array('all', $_POST['countrylist2'])) {
foreach ($countryList as $country) {
$wpdb->query("REPLACE INTO `" . WPSC_TABLE_CATEGORY_TM . "`(`visible`, `countryid`, `categoryid`) VALUES ('1','{$country}', '{$category_id}' )");
}
$AllSelected = true;
}
if (in_array('none', $_POST['countrylist2'])) {
$wpdb->query("UPDATE `" . WPSC_TABLE_CATEGORY_TM . "` SET `visible` = '0' WHERE `categoryid`='{$category_id}'");
$AllSelected = true;
}
if ($AllSelected != true) {
$unselectedCountries = array_diff($countryList, $_POST['countrylist2']);
foreach ($unselectedCountries as $unselected) {
$wpdb->query("REPLACE INTO `" . WPSC_TABLE_CATEGORY_TM . "` (`visible`, `countryid`, `categoryid`) VALUES (0,'{$unselected}', '{$category_id}' )");
}
//find the countries that are selected
$selectedCountries = array_intersect($countryList, $_POST['countrylist2']);
foreach ($selectedCountries as $selected) {
$wpdb->query("REPLACE INTO `" . WPSC_TABLE_CATEGORY_TM . "`(`visible`, `countryid`, `categoryid`) VALUES ('1','{$selected}', '{$category_id}' )");
}
}
}
if ($_POST['description'] != $category_data['description']) {
$description = $_POST['description'];
$category_sql_list[] = "`description` = '{$description}' ";
}
if (is_numeric($_POST['category_parent']) and $_POST['category_parent'] != $category_data['category_parent']) {
$parent_category = (int) $_POST['category_parent'];
$category_sql_list[] = "`category_parent` = '{$parent_category}' ";
}
if ($_POST['deleteimage'] == 1) {
$category_sql_list[] = "`image` = ''";
} else {
if ($image != null) {
$category_sql_list[] = "`image` = '{$image}'";
}
}
if ($_POST['display_type'] != $category_data['display_type']) {
switch ($_POST['display_type']) {
case "grid":
$display_type = 'grid';
break;
case "list":
$display_type = 'list';
break;
case "default":
$display_type = 'default';
break;
default:
$display_type = '';
break;
}
$category_sql_list[] = "`display_type` = '{$display_type}' ";
}
//echo "<pre>".print_r($category_sql_list,true)."</pre>";
if ($_POST['product_height'] > 0) {
$product_height = (int) $_POST['product_height'];
} else {
$product_height = '';
}
$category_sql_list[] = "`image_height` = '{$product_height}' ";
if ($_POST['product_width'] > 0) {
$product_width = (int) $_POST['product_width'];
} else {
$product_width = '';
}
$category_sql_list[] = "`image_width` = '{$product_height}' ";
if (count($category_sql_list) > 0) {
$category_sql = implode(", ", $category_sql_list);
$wpdb->query("UPDATE `" . WPSC_TABLE_PRODUCT_CATEGORIES . "` SET {$category_sql} WHERE `id`='" . (int) $_POST['prodid'] . "' LIMIT 1");
update_option('wpsc_category_url_cache', array());
$wp_rewrite->flush_rules();
}
echo "<div class='updated'><p align='center'>" . TXT_WPSC_CATEGORYHASBEENEDITED . "</p></div>";
}
if ($_POST['submit_action'] == "add_categorisation") {
$wpdb->query("INSERT INTO `" . WPSC_TABLE_CATEGORISATION_GROUPS . "` ( `name`, `description`, `active`, `default`) VALUES ( '" . $wpdb->escape(stripslashes($_POST['name'])) . "', '" . $wpdb->escape(stripslashes($_POST['description'])) . "', '1', '0')");
echo "<div class='updated'><p align='center'>" . TXT_WPSC_CATEGORISATIONHASBEENADDED . "</p></div>";
}
if ($_POST['submit_action'] == "edit_categorisation") {
$edit_group_id = $_POST['group_id'];
$wpdb->query("UPDATE `" . WPSC_TABLE_CATEGORISATION_GROUPS . "` SET `name` = '" . $wpdb->escape(stripslashes($_POST['name'])) . "', `description` = '" . $wpdb->escape(stripslashes($_POST['description'])) . "' WHERE `id` IN('{$edit_group_id}') LIMIT 1 ");
echo "<div class='updated'><p align='center'>" . TXT_WPSC_CATEGORISATIONHASBEENEDITED . "</p></div>";
if (!is_numeric($_GET['category_group']) || (int) $_GET['category_group'] == null) {
$current_categorisation = $wpdb->get_row("SELECT * FROM `" . WPSC_TABLE_CATEGORISATION_GROUPS . "` WHERE `active` IN ('1') AND `default` IN ('1') LIMIT 1 ", ARRAY_A);
} else {
$current_categorisation = $wpdb->get_row("SELECT * FROM `" . WPSC_TABLE_CATEGORISATION_GROUPS . "` WHERE `active` IN ('1') AND `id` IN ('" . (int) $_GET['category_group'] . "') LIMIT 1 ", ARRAY_A);
}
}
if (is_numeric($_GET['category_delete_id'])) {
$delete_id = (int) $_GET['category_delete_id'];
$deletesql = "UPDATE `" . WPSC_TABLE_CATEGORISATION_GROUPS . "` SET `active` = '0' WHERE `id`='{$delete_id}' AND `default` IN ('0') LIMIT 1";
$wpdb->query($deletesql);
$delete_subcat_sql = "UPDATE `" . WPSC_TABLE_PRODUCT_CATEGORIES . "` SET `active` = '0', `nice-name` = '' WHERE `group_id`='{$delete_id}'";
$wpdb->query($delete_subcat_sql);
update_option('wpsc_category_url_cache', array());
$wp_rewrite->flush_rules();
}
if (is_numeric($_GET['deleteid'])) {
$delete_id = absint($_GET['deleteid']);
$deletesql = "UPDATE `" . WPSC_TABLE_PRODUCT_CATEGORIES . "` SET `active` = '0', `nice-name` = '' WHERE `id`='{$delete_id}' LIMIT 1";
if ($wpdb->query($deletesql)) {
$delete_subcat_sql = "UPDATE `" . WPSC_TABLE_PRODUCT_CATEGORIES . "` SET `active` = '0', `nice-name` = '' WHERE `category_parent`='{$delete_id}'";
$wpdb->query($delete_subcat_sql);
// if this is the default category, we need to find a new default category
if ($delete_id == get_option('wpsc_default_category')) {
// select the category that is not deleted with the greatest number of products in it
$new_default = $wpdb->get_var("SELECT `cat`.`id` FROM `" . WPSC_TABLE_PRODUCT_CATEGORIES . "` AS `cat`\n\t\t\t\tLEFT JOIN `" . WPSC_TABLE_ITEM_CATEGORY_ASSOC . "` AS `assoc` ON `cat`.`id` = `assoc`.`category_id`\n\t\t\t\tWHERE `cat`.`active` IN ( '1' )\n\t\t\t\tGROUP BY `cat`.`id`\n\t\t\t\tORDER BY COUNT( `assoc`.`id` ) DESC\n\t\t\t\tLIMIT 1");
if ($new_default > 0) {
update_option('wpsc_default_category', $new_default);
}
}
update_option('wpsc_category_url_cache', array());
$wp_rewrite->flush_rules();
}
}
unset($GLOBALS['wpsc_category_url_cache']);
update_option('wpsc_category_url_cache', array());
?>
<script language='javascript' type='text/javascript'>
function conf() {
var check = confirm("<?php
echo TXT_WPSC_SURETODELETECATEGORY;
?>
");
if(check) {
return true;
} else {
return false;
}
}
function categorisation_conf() {
var check = confirm("<?php
echo TXT_WPSC_SURETODELETECATEGORISATION;
?>
");
if(check) {
return true;
} else {
return false;
}
}
<?php
if (is_numeric($_POST['prodid'])) {
echo "fillcategoryform(" . $_POST['prodid'] . ");";
}
?>
</script>
<div class="wrap">
<h2><?php
echo TXT_WPSC_CATEGORISATION;
?>
</h2>
<?php
if (function_exists('add_object_page')) {
echo "<div id='dashboard-widgets' class='metabox-holder'>";
}
?>
<span><?php
echo TXT_WPSC_CATEGORISATION_GROUPS_DESCR;
?>
</span>
<?php
if (function_exists('add_object_page')) {
echo "<div class='wpsc_products_nav27'>";
} else {
echo "<div class='tablenav wpsc_groups_nav' >";
}
?>
<div class="alignleft product_group" style='width: 500px;'>
<form action='' method='GET' id='submit_categorisation_form' >
<input type='hidden' value='<?php
echo $_GET['page'];
?>
' name='page' />
<?php
$categorisation_groups = $wpdb->get_results("SELECT * FROM `" . WPSC_TABLE_CATEGORISATION_GROUPS . "` WHERE `active` IN ('1')", ARRAY_A);
//echo "<ul class='categorisation_links'>\n\r";
echo "<label for='select_categorisation_group' class='select_categorisation_group'>" . TXT_WPSC_SELECT_PRODUCT_GROUP . ": </label>";
echo "<select name='category_group' id='select_categorisation_group' onchange='submit_status_form(\"submit_categorisation_form\")'>";
foreach ((array) $categorisation_groups as $categorisation_group) {
$selected = '';
if ($current_categorisation['id'] == $categorisation_group['id']) {
//$selected = "class='selected'";
$selected = "selected='selected'";
}
echo "<option value='{$categorisation_group['id']}' {$selected} >{$categorisation_group['name']}</option>";
//echo " <li $selected >\n\r";
//echo " <a href='?page={$_GET['page']}&category_group={$categorisation_group['id']}'>{$categorisation_group['name']}</a> ";
//echo " </li>\n\r";
}
echo "</select>";
//echo "<li>- <a href='' onclick='return showadd_categorisation_form()'><span>".TXT_WPSC_ADD_CATEGORISATION."</span></a></li>";
//echo "</ul>\n\r";
?>
<span><?php
_e('or');
?>
</span>
<?php
echo "<a class='button add_categorisation_group' href='#' onclick='return showadd_categorisation_form()'><span>" . TXT_WPSC_ADD_CATEGORISATION . "</span></a>";
?>
</form>
</div>
<!--
<div class="alignright">
<a target="_blank" href='http://www.instinct.co.nz/e-commerce/product-groups/' class='about_this_page'><span><?php
echo TXT_WPSC_ABOUT_THIS_PAGE;
?>
</span> </a>
</div>
-->
<br class="clear"/>
</div>
<div id='add_categorisation'>
<strong><?php
echo TXT_WPSC_ADD_CATEGORISATION;
?>
</strong>
<form method='POST' enctype='multipart/form-data'>
<fieldset>
<label for='add_categorisation_name'>Name</label>
<input type='text' name='name' value='' id='add_categorisation_name' />
</fieldset>
<fieldset>
<label for='add_categorisation_description'>Description</label>
<input type='text' name='description' value='' id='add_categorisation_description' />
</fieldset>
<fieldset>
<label> </label>
<input type='hidden' name='submit_action' value='add_categorisation' />
<input type='submit' name='submit_form' value='<?php
echo TXT_WPSC_SUBMIT;
?>
' />
</fieldset>
</form>
<br/>
</div>
<div id='edit_categorisation'>
<strong><?php
echo TXT_WPSC_EDIT_CATEGORISATION;
?>
</strong>
<form method='POST' enctype='multipart/form-data'>
<fieldset>
<label for='add_categorisation_name'>Name</label>
<input type='text' name='name' value='<?php
echo $current_categorisation['name'];
?>
' id='add_categorisation_name' />
</fieldset>
<fieldset>
<label for='add_categorisation_description'>Description</label>
<input type='text' name='description' value='<?php
echo $current_categorisation['description'];
?>
' id='add_categorisation_description' />
</fieldset>
<fieldset>
<label> </label>
<input type='hidden' name='group_id' value='<?php
echo $current_categorisation['id'];
?>
' />
<input type='hidden' name='submit_action' value='edit_categorisation' />
<input type='submit' name='submit_form' value='<?php
echo TXT_WPSC_SUBMIT;
?>
' />
<?php
if ($current_categorisation['default'] != 1) {
?>
<a href='<?php
echo "?page={$_GET['page']}&category_delete_id={$current_categorisation['id']}";
?>
' onclick='return categorisation_conf()' > <?php
echo TXT_WPSC_DELETE;
?>
</a>
<?php
}
?>
</fieldset>
</form>
<br/>
</div>
<?php
$num = 0;
echo " <table id='productpage' style='margin-top: 1ex;'>\n\r";
echo " <tr><td class='firstcol' style='width: 297px;'>\n\r";
if (function_exists('add_object_page')) {
echo "<div class='postbox' style='margin-right: 15px; min-width:255px;'>";
echo "<h3 class='hndle'>" . str_replace("[categorisation]", $current_categorisation['name'], TXT_WPSC_CURRENT_GROUP) . "</h3>";
echo "<div class='inside'>";
}
//echo "<div class='categorisation_title'><a href='' onclick='return showaddform()' class='add_category_link'><span>". TXT_WPSC_ADDNEWCATEGORY."</span></a><strong class='form_group'>".str_replace("[categorisation]", $current_categorisation['name'], TXT_WPSC_MANAGE_CATEGORISATION)." <a href='#' onclick='return showedit_categorisation_form()'>[".TXT_WPSC_EDIT."]</a> </strong></div>";
echo " <table id='itemlist'>\n\r";
if (function_exists('add_object_page')) {
echo "<tr></tr>";
} else {
echo " <tr class='firstrow categorisation_title'>\n\r";
echo " <td>\n\r";
echo TXT_WPSC_IMAGE;
echo " </td>\n\r";
echo " <td>\n\r";
echo TXT_WPSC_NAME;
echo " </td>\n\r";
echo " <td>\n\r";
//echo TXT_WPSC_DESCRIPTION;
echo " </td>\n\r";
echo " <td>\n\r";
echo TXT_WPSC_EDIT;
echo " </td>\n\r";
echo " </tr>\n\r";
}
echo " <tr>\n\r";
echo " <td colspan='4' class='colspan'>\n\r";
echo "<div class='editing_this_group'><p>";
echo str_replace("[categorisation]", $current_categorisation['name'], TXT_WPSC_EDITING_GROUP);
echo " <a href='#' onclick='return showedit_categorisation_form()'>" . TXT_WPSC_EDIT . "</a>";
echo "</p></div>";
echo " </td>\n\r";
echo " <tr>\n\r";
display_categories($current_categorisation['id']);
if (function_exists('add_object_page')) {
echo "</table>";
echo "</div>";
//class inside ends
echo "</div>";
//class postbox ends
} else {
echo "</table>\n\r";
}
echo " </td><td id='poststuff' class='secondcol product_groups_page'>\n\r";
echo " <div id='productform' class='postbox'>";
echo "<form method='POST' enctype='multipart/form-data' name='editproduct{$num}'>\n\r";
if (function_exists('add_object_page')) {
echo "<h3 class='hndle'>" . str_replace("[categorisation]", $current_categorisation['name'], TXT_WPSC_EDITING_IN_GROUP) . "</h3>";
echo "<div class='inside'>";
} else {
echo "<div class='categorisation_title'><strong class='form_group'>" . TXT_WPSC_EDITDETAILS . " </strong></div>\n\r";
echo "<div class='editing_this_group'><p>" . str_replace("[categorisation]", $current_categorisation['name'], TXT_WPSC_EDITING_IN_GROUP) . "</p></div>";
}
echo " <div id='formcontent'>\n\r";
echo " </div>\n\r";
if (function_exists('add_object_page')) {
echo "</div>";
}
echo "</form>\n\r";
echo " </div>\n\r";
?>
<div id="blank_item">
<h3 class="form_heading"><?php
echo str_replace("[categorisation]", $current_categorisation['name'], TXT_WPSC_ADDNEWCATEGORY_TITLE);
?>
</h3>
<div class="inside">
<a href='' onclick='return showaddform()' class='add_category_link'><span><?php
echo str_replace("[categorisation]", $current_categorisation['name'], TXT_WPSC_ADDNEWCATEGORY);
?>
</span></a>
<span class="setting-description"><?php
echo TXT_WPSC_ADDING_A_NEW_CATEGORY;
?>
</span>
</div>
</div>
<div id='additem' class='postbox'>
<h3 class='hndle'><?php
echo str_replace("[categorisation]", $current_categorisation['name'], TXT_WPSC_ADDING_TO_GROUP);
?>
</h3>
<div class='inside'>
<form method='post' enctype='multipart/form-data' class='additem'>
<div class='editing_this_group'><p> <?php
echo "" . str_replace("[categorisation]", $current_categorisation['name'], TXT_WPSC_ADDING_TO_GROUP) . "";
?>
</p></div>
<table class='category_forms form_table'>
<tr>
<td>
<?php
echo TXT_WPSC_NAME;
?>
:
</td>
<td>
<input type='text' class="text" name='name' value='' />
</td>
</tr>
<tr>
<td>
<?php
echo TXT_WPSC_DESCRIPTION;
?>
:
</td>
<td>
<textarea name='description' rows='8'></textarea>
</td>
</tr>
<tr>
<td>
<?php
echo TXT_WPSC_CATEGORY_PARENT;
?>
:
</td>
<td>
<?php
echo wpsc_parent_category_list($current_categorisation['id'], 0, 0);
?>
</td>
</tr>
<tr>
<td>
<?php
echo TXT_WPSC_GROUP_IMAGE;
?>
:
</td>
<td>
<input type='file' name='image' value='' />
</td>
</tr>
<?php
if (function_exists("getimagesize")) {
?>
<tr>
<td>
</td>
<td>
<?php
echo TXT_WPSC_HEIGHT;
?>
:<input type='text' size='6' name='height' value='<?php
echo get_option('category_image_height');
?>
' /> <?php
echo TXT_WPSC_WIDTH;
?>
:<input type='text' size='6' name='width' value='<?php
echo get_option('category_image_width');
?>
' /> <br />
<span class='wpscsmall description'><?php
echo TXT_WPSC_GROUP_IMAGE_TEXT;
?>
</span>
</td>
</tr>
<?php
}
?>
<?php
wpsc_category_tm();
//category target market checkbox
?>
<tr>
<td colspan='2' class='category_presentation_settings'>
<h4><?php
echo TXT_WPSC_PRESENTATIONSETTINGS;
?>
</h4>
<span class='small'><?php
echo TXT_WPSC_GROUP_PRESENTATION_TEXT;
?>
</span>
</td>
</tr>
<tr>
<td>
<?php
echo TXT_WPSC_CATALOG_VIEW;
?>
:
</td>
<td>
<select name='product_view'>
<option value='default' <?php
echo $product_view1;
?>
><?php
echo TXT_WPSC_DEFAULT;
?>
</option>
<?php
if (function_exists('product_display_list')) {
?>
<option value='list' <?php
echo $product_view2;
?>
><?php
echo TXT_WPSC_LIST;
?>
</option>
<?php
} else {
?>
<option value='list' disabled='disabled' <?php
echo $product_view2;
?>
><?php
echo TXT_WPSC_LIST;
?>
</option>
<?php
}
if (function_exists('product_display_grid')) {
?>
<option value='grid' <?php
echo $product_view3;
?>
><?php
echo TXT_WPSC_GRID;
?>
</option>
<?php
} else {
?>
<option value='grid' disabled='disabled' <?php
echo $product_view3;
?>
><?php
echo TXT_WPSC_GRID;
?>
</option>
<?php
}
?>
</select>
</td>
</tr>
<tr>
<td colspan='2'>
<?php
echo TXT_WPSC_THUMBNAIL_SIZE;
?>
:
<?php
echo TXT_WPSC_HEIGHT;
?>
: <input type='text' value='' name='product_height' size='6'/>
<?php
echo TXT_WPSC_WIDTH;
?>
: <input type='text' value='' name='product_width' size='6'/> <br/>
</td>
</tr>
<tr>
<td>
</td>
<td class='last_row'>
<input type='hidden' name='categorisation_group' value='<?php
echo $current_categorisation['id'];
?>
' />
<input type='hidden' name='submit_action' value='add' />
<input class='button-primary' type='submit' name='submit' value='<?php
echo TXT_WPSC_ADD_GROUP;
?>
' />
</td>
</tr>
</table>
</form>
</div>
</div>
</td></tr>
</table>
</div>
<?php
}
// Text im Template setzten
$t->set_var(array('TITEL_BACKEND_STRING' => $MOD_FOLDERGALLERY['TITEL_BACKEND'], 'TITEL_MODIFY' => $MOD_FOLDERGALLERY['TITEL_MODIFY'], 'SETTINGS_STRING' => $MOD_FOLDERGALLERY['SETTINGS'], 'FOLDER_IN_FS_STRING' => $MOD_FOLDERGALLERY['FOLDER_IN_FS'], 'CAT_TITLE_STRING' => $MOD_FOLDERGALLERY['CAT_TITLE'], 'ACTIONS_STRING' => $MOD_FOLDERGALLERY['ACTION'], 'SYNC_STRING' => $MOD_FOLDERGALLERY['SYNC'], 'EDIT_CSS_STRING' => $MOD_FOLDERGALLERY['EDIT_CSS'], 'EXPAND_COLAPSE_STRING' => $MOD_FOLDERGALLERY['EXPAND_COLAPSE'], 'HELP_STRING' => $MOD_FOLDERGALLERY['HELP_INFORMATION'], 'NEW_CAT_STRING' => $MOD_FOLDERGALLERY['NEW_CAT']));
// Template ausgeben
$t->pparse('output', 'modify');
// Kategorien von der obersten Ebene aus DB hohlen
$sql = "SELECT * FROM " . TABLE_PREFIX . "mod_foldergallery_categories WHERE section_id=" . $section_id . " AND niveau=0;";
$query = $database->query($sql);
while ($result = $query->fetchRow()) {
$results[] = $result;
}
// Needed for display_categories()
$url = array('edit' => WB_URL . "/modules/foldergallery/admin/modify_cat.php?page_id=" . $page_id . "§ion_id=" . $section_id . "&cat_id=");
echo '<script type="text/javascript">
var the_parent_id = "0";
var theme_url = "' . THEME_URL . '";
var fg_url = "' . WB_URL . '/modules/foldergallery";
</script>
<ul>
' . display_categories(-1, $section_id) . '
</ul>
<div id="dragableCategorie">
<ul>
' . display_categories(0, $section_id) . '
</ul>
</div>
<div style="display: block; width: 90%; height: 15px; padding: 5px;"><div id="dragableResult"> </div></div><hr>
';
// Schluss vom else Teil ganz oben!
}
// reset the mySQL encoding
mysql_set_charset($oldMysqlEncoding, $database->db_handle);
