function phpwcms_revision_r538() { $status = true; // do former revision check – fallback to r537 if (phpwcms_revision_check_temp('537') !== true) { $status = phpwcms_revision_check('537'); } $result = _dbQuery("SHOW COLUMNS FROM `" . DB_PREPEND . "phpwcms_articlecat` WHERE Field='acat_public'"); if (isset($result[0]['Default']) && $result[0]['Default'] == 0) { $update = _dbQuery("ALTER TABLE `" . DB_PREPEND . "phpwcms_articlecat` CHANGE `acat_public` `acat_public` INT(1) NOT NULL DEFAULT '1'", 'ALTER'); if (!$update) { $status = false; } } $result = _dbQuery("SHOW COLUMNS FROM `" . DB_PREPEND . "phpwcms_articlecat` WHERE Field='acat_alias'"); if (isset($result[0]['Type']) && strpos($result[0]['Type'], '255') === false) { $update = _dbQuery("ALTER TABLE `" . DB_PREPEND . "phpwcms_articlecat` CHANGE `acat_alias` `acat_alias` VARCHAR(255) NOT NULL DEFAULT ''", 'ALTER'); if (!$update) { $status = false; } } // Reset cache values _setConfig('structure_array_vmode_all', false, 'frontend_render', 1); _setConfig('structure_array_vmode_editor', false, 'frontend_render', 1); _setConfig('structure_array_vmode_admin', false, 'frontend_render', 1); return $status; }
function phpwcms_revision_r540() { $status = true; // do former revision check – fallback to r539 if (phpwcms_revision_check_temp('539') !== true) { $status = phpwcms_revision_check('539'); } $result = _dbQuery("SHOW COLUMNS FROM `" . DB_PREPEND . "phpwcms_article` WHERE Field='article_canonical'"); if (!isset($result[0])) { $insert = _dbQuery("ALTER TABLE `" . DB_PREPEND . "phpwcms_article` ADD `article_canonical` VARCHAR(2000) NOT NULL DEFAULT ''", 'ALTER'); if (!$insert) { $status = false; } } $result = _dbQuery("SHOW COLUMNS FROM `" . DB_PREPEND . "phpwcms_articlecat` WHERE Field='acat_canonical'"); if (!isset($result[0])) { $insert = _dbQuery("ALTER TABLE `" . DB_PREPEND . "phpwcms_articlecat` ADD `acat_canonical` VARCHAR(2000) NOT NULL DEFAULT ''", 'ALTER'); if (!$insert) { $status = false; } // Reset cache values _setConfig('structure_array_vmode_all', false, 'frontend_render', 1); _setConfig('structure_array_vmode_editor', false, 'frontend_render', 1); _setConfig('structure_array_vmode_admin', false, 'frontend_render', 1); } return $status; }
function phpwcms_revision_r541() { $status = true; // do former revision check – fallback to r540 if (phpwcms_revision_check_temp('540') !== true) { $status = phpwcms_revision_check('540'); } $result = _dbQuery("SHOW COLUMNS FROM `" . DB_PREPEND . "phpwcms_articlecat` WHERE Field='acat_breadcrumb'"); if (!isset($result[0])) { $insert = _dbQuery("ALTER TABLE `" . DB_PREPEND . "phpwcms_articlecat` ADD `acat_breadcrumb` INT(1) NOT NULL DEFAULT '0'", 'ALTER'); if (!$insert) { $status = false; } // Reset cache values _setConfig('structure_array_vmode_all', false, 'frontend_render', 1); _setConfig('structure_array_vmode_editor', false, 'frontend_render', 1); _setConfig('structure_array_vmode_admin', false, 'frontend_render', 1); } $result = _dbQuery("SHOW COLUMNS FROM `" . DB_PREPEND . "phpwcms_shop_products` WHERE Field='shopprod_unit'"); if (!isset($result[0])) { if (!($insert = _dbQuery("ALTER TABLE `" . DB_PREPEND . "phpwcms_shop_products` ADD `shopprod_unit` VARCHAR(100) NOT NULL DEFAULT ''", 'ALTER'))) { $status = false; } } return $status; }
function phpwcms_revision_r537() { $status = true; // do former revision check – fallback to r536 if (phpwcms_revision_check_temp('536') !== true) { $status = phpwcms_revision_check('536'); } $result = _dbQuery("SHOW COLUMNS FROM `" . DB_PREPEND . "phpwcms_articlecat` WHERE Field='acat_public'"); if (isset($result[0]['Default']) && $result[0]['Default'] == 0) { $update = _dbQuery("ALTER TABLE `" . DB_PREPEND . "phpwcms_articlecat` CHANGE `acat_public` `acat_public` INT(1) NOT NULL DEFAULT '1'", 'ALTER'); if (!$update) { $status = false; } } $result = _dbQuery("SHOW COLUMNS FROM `" . DB_PREPEND . "phpwcms_articlecat` WHERE Field='acat_opengraph'"); if (!isset($result[0])) { $insert = _dbQuery("ALTER TABLE `" . DB_PREPEND . "phpwcms_articlecat` ADD `acat_opengraph` INT(1) UNSIGNED NOT NULL DEFAULT '1', ADD INDEX (`acat_opengraph`)", 'ALTER'); if (!$insert) { $status = false; } // Reset cache values _setConfig('structure_array_vmode_all', false, 'frontend_render', 1); _setConfig('structure_array_vmode_editor', false, 'frontend_render', 1); _setConfig('structure_array_vmode_admin', false, 'frontend_render', 1); } $result = _dbQuery("SHOW COLUMNS FROM `" . DB_PREPEND . "phpwcms_content` WHERE Field='cnt_opengraph'"); if (!isset($result[0])) { $insert = _dbQuery("ALTER TABLE `" . DB_PREPEND . "phpwcms_content` ADD `cnt_opengraph` INT(1) UNSIGNED NOT NULL DEFAULT '1', ADD INDEX (`cnt_opengraph`)", 'ALTER'); if (!$insert) { $status = false; } } $result = _dbQuery("SHOW COLUMNS FROM `" . DB_PREPEND . "phpwcms_categories` WHERE Field='cat_opengraph'"); if (!isset($result[0])) { $insert = _dbQuery("ALTER TABLE `" . DB_PREPEND . "phpwcms_categories` ADD `cat_opengraph` INT(1) UNSIGNED NOT NULL DEFAULT '1', ADD INDEX (`cat_opengraph`)", 'ALTER'); if (!$insert) { $status = false; } } $result = _dbQuery("SHOW COLUMNS FROM `" . DB_PREPEND . "phpwcms_shop_products` WHERE Field='shopprod_opengraph'"); if (!isset($result[0])) { $insert = _dbQuery("ALTER TABLE `" . DB_PREPEND . "phpwcms_shop_products` ADD `shopprod_opengraph` INT(1) UNSIGNED NOT NULL DEFAULT '1', ADD INDEX (`shopprod_opengraph`)", 'ALTER'); if (!$insert) { $status = false; } } return $status; }
function get_struct_data($root_name = '', $root_info = '') { //returns the complete active and public struct data as array //so it is reusable by many menu functions -> lower db access // first check pre-rendered structure for current user mode $sysvalue_key = 'structure_array_vmode_' . get_user_vmode(); $data = _getConfig($sysvalue_key); if (is_array($data)) { return $data; } global $db; global $indexpage; $data = array(); $data[0] = array("acat_id" => 0, "acat_name" => $indexpage['acat_name'], "acat_info" => $indexpage['acat_info'], "acat_struct" => 0, "acat_sort" => 0, "acat_hidden" => intval($indexpage['acat_hidden']), "acat_regonly" => intval($indexpage['acat_regonly']), "acat_ssl" => intval($indexpage['acat_ssl']), "acat_template" => intval($indexpage['acat_template']), "acat_alias" => $indexpage['acat_alias'], "acat_topcount" => intval($indexpage['acat_topcount']), "acat_maxlist" => intval($indexpage['acat_maxlist']), "acat_redirect" => $indexpage['acat_redirect'], "acat_order" => intval($indexpage['acat_order']), "acat_timeout" => $indexpage['acat_timeout'], "acat_nosearch" => $indexpage['acat_nosearch'], "acat_nositemap" => $indexpage['acat_nositemap'], "acat_permit" => !empty($indexpage['acat_permit']) && is_array($indexpage['acat_permit']) ? $indexpage['acat_permit'] : array(), "acat_pagetitle" => empty($indexpage['acat_pagetitle']) ? '' : $indexpage['acat_pagetitle'], "acat_paginate" => empty($indexpage['acat_paginate']) ? 0 : 1, "acat_overwrite" => empty($indexpage['acat_overwrite']) ? '' : $indexpage['acat_overwrite'], "acat_archive" => empty($indexpage['acat_archive']) ? 0 : 1, "acat_class" => empty($indexpage['acat_class']) ? '' : $indexpage['acat_class'], "acat_keywords" => empty($indexpage['acat_keywords']) ? '' : $indexpage['acat_keywords'], "acat_disable301" => empty($indexpage['acat_disable301']) ? 0 : 1, "acat_opengraph" => isset($indexpage['acat_opengraph']) ? $indexpage['acat_opengraph'] : 1, "acat_canonical" => empty($indexpage['acat_canonical']) ? '' : $indexpage['acat_canonical']); $sql = "SELECT * FROM " . DB_PREPEND . "phpwcms_articlecat WHERE "; // VISIBLE_MODE: 0 = frontend (all) mode, 1 = article user mode, 2 = admin user mode if (VISIBLE_MODE != 2) { // for 0 AND 1 $sql .= "acat_aktiv=1 AND "; } $sql .= "acat_trash=0 ORDER BY acat_struct, acat_sort"; if ($result = mysql_query($sql, $db)) { while ($row = mysql_fetch_assoc($result)) { $data[$row["acat_id"]] = array("acat_id" => $row["acat_id"], "acat_name" => $row["acat_name"], "acat_info" => $row["acat_info"], "acat_struct" => $row["acat_struct"], "acat_sort" => $row["acat_sort"], "acat_hidden" => $row["acat_hidden"], "acat_regonly" => $row["acat_regonly"], "acat_ssl" => $row["acat_ssl"], "acat_template" => $row["acat_template"], "acat_alias" => $row["acat_alias"], "acat_topcount" => $row["acat_topcount"], "acat_maxlist" => $row["acat_maxlist"], "acat_redirect" => $row["acat_redirect"], "acat_order" => $row["acat_order"], "acat_timeout" => $row["acat_cache"], "acat_nosearch" => $row["acat_nosearch"], "acat_nositemap" => $row["acat_nositemap"], "acat_permit" => empty($row["acat_permit"]) ? array() : explode(',', $row["acat_permit"]), "acat_pagetitle" => $row["acat_pagetitle"], "acat_paginate" => $row["acat_paginate"], "acat_overwrite" => $row["acat_overwrite"], "acat_archive" => $row["acat_archive"], "acat_class" => $row["acat_class"], "acat_keywords" => $row["acat_keywords"], "acat_disable301" => $row["acat_disable301"], "acat_opengraph" => $row["acat_opengraph"], "acat_canonical" => $row["acat_canonical"]); } mysql_free_result($result); } // set max_allowed_package to bigger value _dbSetVar('max_allowed_packet', 16 * 1024 * 1024, '<'); // store pre-rendered serialized array in database _setConfig($sysvalue_key, $data, 'frontend_render', 1); return $data; }
if ($s_del) { $sql = "UPDATE " . DB_PREPEND . "phpwcms_articlecat SET acat_trash=9, acat_alias=CONCAT(acat_alias,'_del-','" . date('YmdHis') . "') WHERE (" . $s_del . ")"; mysql_query($sql, $db) or die("error while deleting structures"); } } } break; } } //Ende Abarbeiten Aktion update_cache(); // empty pre-rendered frontend structure for all visible modes // VISIBLE_MODE: 0 = frontend (all) mode, 1 = article user mode, 2 = admin user mode _setConfig('structure_array_vmode_all', false, 'frontend_render', 1); _setConfig('structure_array_vmode_editor', false, 'frontend_render', 1); _setConfig('structure_array_vmode_admin', false, 'frontend_render', 1); if (isset($_POST['SubmitClose'])) { headerRedirect(PHPWCMS_URL . 'phpwcms.php?' . get_token_get_string('csrftoken') . '&do=admin&p=6&' . get_token_get_string('csrftoken')); } else { headerRedirect($ref); } function get_struct_del_id($s_id = 0, $dbcon) { $s_id = intval($s_id); //retrieve article ID list that should be deleted $sql = "SELECT article_id FROM " . DB_PREPEND . "phpwcms_article WHERE article_deleted=0 AND article_cid=" . $s_id; if ($result = mysql_query($sql, $dbcon)) { while ($row = mysql_fetch_row($result)) { $GLOBALS["article_del"][] = $row[0]; } mysql_free_result($result);
<?php if (!($plugin['data']['shop_pref_vat'] = _getConfig('shop_pref_vat'))) { $plugin['data']['shop_pref_vat'] = array('0.00'); _setConfig('shop_pref_vat', $plugin['data']['shop_pref_vat'], 'module_shop'); } $add_option = ''; $add_vat = array(); foreach ($plugin['data']['shop_pref_vat'] as $value) { echo '<option value="' . $value . '"'; if ($plugin['data']['shopprod_vat'] == $value) { echo ' selected="selected"'; } elseif (!empty($plugin['data']['shopprod_vat']) && !in_array($plugin['data']['shopprod_vat'], $plugin['data']['shop_pref_vat'])) { $plugin['data']['shop_pref_vat'][] = $plugin['data']['shopprod_vat']; natsort($plugin['data']['shop_pref_vat']); _setConfig('shop_pref_vat', $plugin['data']['shop_pref_vat'], 'module_shop'); $add_option .= LF . '<option value="' . $plugin['data']['shopprod_vat'] . '" selected="selected">'; $add_option .= number_format($plugin['data']['shopprod_vat'], 2, $BLM['dec_point'], $BLM['thousands_sep']); $add_option .= '</option>'; } echo '>'; echo number_format($value, 2, $BLM['dec_point'], $BLM['thousands_sep']); echo '</option>' . LF; } echo $add_option; ?> </select></td> <td> %</td>
_setConfig('shop_pref_vat', $plugin['data']['shop_pref_vat'], 'module_shop'); _setConfig('shop_pref_email_to', $plugin['data']['shop_pref_email_to'], 'module_shop'); _setConfig('shop_pref_email_from', $plugin['data']['shop_pref_email_from'], 'module_shop'); _setConfig('shop_pref_email_paypal', $plugin['data']['shop_pref_email_paypal'], 'module_shop'); _setConfig('shop_pref_shipping_calc', $plugin['data']['shop_pref_shipping_calc'], 'module_shop'); _setConfig('shop_pref_shipping', $plugin['data']['shop_pref_shipping'], 'module_shop'); _setConfig('shop_pref_payment', $plugin['data']['shop_pref_payment'], 'module_shop'); _setConfig('shop_pref_terms', $plugin['data']['shop_pref_terms'], 'module_shop'); _setConfig('shop_pref_terms_format', $plugin['data']['shop_pref_terms_format'], 'module_shop'); _setConfig('shop_pref_id_shop', $plugin['data']['shop_pref_id_shop'], 'module_shop'); _setConfig('shop_pref_id_cart', $plugin['data']['shop_pref_id_cart'], 'module_shop'); _setConfig('shop_pref_discount', $plugin['data']['shop_pref_discount'], 'module_shop'); _setConfig('shop_pref_loworder', $plugin['data']['shop_pref_loworder'], 'module_shop'); _setConfig('shop_pref_felang', $plugin['data']['shop_pref_felang'], 'module_shop'); _setConfig('shop_pref_zone_base', $plugin['data']['shop_pref_zone_base'], 'module_shop'); _setConfig('shop_pref_api_access', $plugin['data']['shop_pref_api_access'], 'module_shop'); _setConfig('shop_pref_api_key', $plugin['data']['shop_pref_api_key'], 'module_shop'); // save and back to listing mode headerRedirect(shop_url('controller=pref', '')); } } $_checkPref_shipping_default = array('weight' => '', 'net' => 0, 'vat' => 0, 'price' => '', 'price_net' => 0, 'price_vat' => 0, 'zone' => '', 'zone_net' => 0, 'zone_vat' => 0, 'zone_label' => ''); $_checkPref = array('shop_pref_currency' => '', 'shop_pref_unit_weight' => 'kg', 'shop_pref_vat' => array('0.00', '7.00', '19.00'), 'shop_pref_email_to' => '', 'shop_pref_email_from' => '', 'shop_pref_email_paypal' => '', 'shop_pref_id_shop' => 0, 'shop_pref_id_cart' => 0, 'shop_pref_felang' => 0, 'shop_pref_shipping_calc' => 0, 'shop_pref_shipping' => array(0 => $_checkPref_shipping_default, 1 => $_checkPref_shipping_default, 2 => $_checkPref_shipping_default, 3 => $_checkPref_shipping_default, 4 => $_checkPref_shipping_default), 'shop_pref_zone_base' => '', 'shop_pref_payment' => array('paypal' => 1, 'prepay' => 1, 'pod' => 1, 'onbill' => 1, 'ccard' => 1, 'accepted_ccard' => array('americanexpress', 'mastercard', 'visa')), 'shop_pref_terms' => '', 'shop_pref_terms_format' => 0, 'shop_pref_discount' => array('discount' => 0, 'percent' => 0, 'amount' => 0, 'freeshipping' => 0, 'discount_1' => 0, 'percent_1' => 0, 'amount_1' => 0, 'freeshipping_1' => 0, 'discount_2' => 0, 'percent_2' => 0, 'amount_2' => 0, 'freeshipping_2' => 0), 'shop_pref_loworder' => array('loworder' => 0, 'under' => 0, 'charge' => 0, 'vat' => 0), 'shop_pref_api_access' => 0, 'shop_pref_api_key' => ''); // retrieve all settings foreach ($_checkPref as $key => $value) { if (false === ($plugin['data'][$key] = _getConfig($key))) { $plugin['data'][$key] = $value; _setConfig($key, $plugin['data'][$key], 'module_shop'); } } }