// | http://www.zen-cart.com/index.php |
// | |
// | Portions Copyright (c) 2003 osCommerce |
// +----------------------------------------------------------------------+
// | This source file is subject to version 2.0 of the GPL license, |
// | that is bundled with this package in the file LICENSE, and is |
// | available through the world-wide-web at the following url: |
// | http://www.zen-cart.com/license/2_0.txt. |
// | If you did not receive a copy of the zen-cart license and are unable |
// | to obtain it through the world-wide-web, please send a note to |
// | license@zen-cart.com so we can mail you a copy immediately. |
// +----------------------------------------------------------------------+
// $Id: collect_info.php 277 2004-09-10 23:03:52Z wilt $
//
$parameters = array('faqs_contact_name' => '', 'faqs_contact_mail' => '', 'faqs_name' => '', 'faqs_description' => '', 'faqs_answer' => '', 'faqs_url' => '', 'faqs_id' => '', 'faqs_image' => '', 'faqs_date_added' => '', 'faqs_last_modified' => '', 'faqs_status' => '', 'faqs_sort_order' => '0', 'master_faq_categories_id' => '');
$pInfo = new objectInfo($parameters);
if (isset($_GET['pID']) && empty($_POST)) {
$faq = $db->Execute("select pd.faqs_name, pd.faqs_description, pd.faqs_answer, pd.faqs_url, pd.faqs_contact_name, pd.faqs_contact_mail,\n p.faqs_id,\n p.faqs_image,\n p.faqs_date_added, p.faqs_last_modified,\n p.faqs_status, \n p.faqs_sort_order,\n p.master_faq_categories_id\n from " . TABLE_FAQS . " p, " . TABLE_FAQS_DESCRIPTION . " pd\n where p.faqs_id = '" . (int) $_GET['pID'] . "'\n and p.faqs_id = pd.faqs_id\n and pd.language_id = '" . (int) $_SESSION['languages_id'] . "'");
$pInfo->objectInfo($faq->fields);
} elseif (zen_not_null($_POST)) {
$pInfo->objectInfo($_POST);
$faqs_name = $_POST['faqs_contact_name'];
$faqs_contact_name = $_POST['faqs_contact_mail'];
$faqs_contact_mail = $_POST['faqs_name'];
$faqs_description = $_POST['faqs_description'];
$faqs_answer = $_POST['faqs_answer'];
$faqs_url = $_POST['faqs_url'];
$faqs_notify = $_POST['faqs_notify'];
}
$languages = zen_get_languages();
if (!isset($pInfo->faqs_status)) {
?>
</td>
<td class="smallText" align="center" width="100"><?php
echo TEXT_LEGEND_BANNER_OPEN_NEW_WINDOWS . '<br />' . zen_image(DIR_WS_IMAGES . 'icon_orange_on.gif', IMAGE_ICON_BANNER_OPEN_NEW_WINDOWS_ON) . ' ' . zen_image(DIR_WS_IMAGES . 'icon_orange_off.gif', IMAGE_ICON_BANNER_OPEN_NEW_WINDOWS_OFF);
?>
</td>
</tr>
</table></td>
</tr>
<?php
}
// legend
if ($action == 'new') {
$form_action = 'insert';
$parameters = array('expires_date' => '', 'date_scheduled' => '', 'banners_title' => '', 'banners_url' => '', 'banners_group' => '', 'banners_image' => '', 'banners_html_text' => '', 'expires_impressions' => '', 'banners_open_new_windows' => '', 'banners_on_ssl' => '');
$bInfo = new objectInfo($parameters);
if (isset($_GET['bID'])) {
$form_action = 'update';
$bID = zen_db_prepare_input($_GET['bID']);
$banner = $db->Execute("select banners_title, banners_url, banners_image, banners_group,\n banners_html_text, status,\n date_format(date_scheduled, '%Y/%m/%d') as date_scheduled,\n date_format(expires_date, '%Y/%m/%d') as expires_date,\n expires_impressions, date_status_change, banners_open_new_windows, banners_on_ssl, banners_sort_order\n from " . TABLE_BANNERS . "\n where banners_id = '" . (int) $bID . "'");
$bInfo->objectInfo($banner->fields);
} elseif (zen_not_null($_POST)) {
$bInfo->objectInfo($_POST);
}
if (!isset($bInfo->status)) {
$bInfo->status = '1';
}
switch ($bInfo->status) {
case '0':
$is_status = false;
$not_status = true;
<?php
/**
* @package admin
* @copyright Copyright 2003-2011 Zen Cart Development Team
* @copyright Portions Copyright 2003 osCommerce
* @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0
* @version $Id: collect_info.php 19330 2011-08-07 06:32:56Z drbyte $
*/
if (!defined('IS_ADMIN_FLAG')) {
die('Illegal Access');
}
$parameters = array('products_name' => '', 'products_description' => '', 'products_url' => '', 'products_id' => '', 'products_quantity' => '', 'products_model' => '', 'products_image' => '', 'products_price' => '', 'products_virtual' => DEFAULT_PRODUCT_MUSIC_PRODUCTS_VIRTUAL, 'products_weight' => '', 'products_date_added' => '', 'products_last_modified' => '', 'products_date_available' => '', 'products_status' => '', 'products_tax_class_id' => DEFAULT_PRODUCT_MUSIC_TAX_CLASS_ID, 'manufacturers_id' => '', 'products_quantity_order_min' => '', 'products_quantity_order_units' => '', 'products_priced_by_attribute' => '', 'product_is_free' => '', 'product_is_call' => '', 'products_quantity_mixed' => '', 'product_is_always_free_shipping' => DEFAULT_PRODUCT_MUSIC_PRODUCTS_IS_ALWAYS_FREE_SHIPPING, 'products_qty_box_status' => PRODUCTS_QTY_BOX_STATUS, 'products_quantity_order_max' => '0', 'products_sort_order' => '0', 'products_discount_type' => '0', 'products_discount_type_from' => '0', 'products_price_sorter' => '0', 'master_categories_id' => '');
$pInfo = new objectInfo($parameters);
if (isset($_GET['pID']) && empty($_POST)) {
$product = $db->Execute("select pd.products_name, pd.products_description, pd.products_url,\r\n p.products_id, p.products_quantity, p.products_model,\r\n p.products_image, p.products_price, p.products_virtual, p.products_weight,\r\n p.products_date_added, p.products_last_modified,\r\n date_format(p.products_date_available, '%Y-%m-%d') as\r\n products_date_available, p.products_status, p.products_tax_class_id,\r\n pe.artists_id, pe.record_company_id,pe.music_genre_id,\r\n p.products_quantity_order_min, p.products_quantity_order_units, p.products_priced_by_attribute,\r\n p.product_is_free, p.product_is_call, p.products_quantity_mixed,\r\n p.product_is_always_free_shipping, p.products_qty_box_status, p.products_quantity_order_max,\r\n p.products_sort_order,\r\n p.products_discount_type, p.products_discount_type_from,\r\n p.products_price_sorter, p.master_categories_id\r\n from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd,\r\n " . TABLE_PRODUCT_MUSIC_EXTRA . " pe\r\n where p.products_id = '" . (int) $_GET['pID'] . "'\r\n and p.products_id = pd.products_id and p.products_id = pe.products_id\r\n and pd.language_id = '" . (int) $_SESSION['languages_id'] . "'");
$pInfo->objectInfo($product->fields);
} elseif (zen_not_null($_POST)) {
$pInfo->objectInfo($_POST);
$products_name = $_POST['products_name'];
$products_description = $_POST['products_description'];
$products_url = $_POST['products_url'];
}
$artists_array = array(array('id' => '', 'text' => TEXT_NONE));
$artists = $db->Execute("select artists_id, artists_name\r\n from " . TABLE_RECORD_ARTISTS . " order by artists_name");
while (!$artists->EOF) {
$artists_array[] = array('id' => $artists->fields['artists_id'], 'text' => $artists->fields['artists_name']);
$artists->MoveNext();
}
$record_company_array = array(array('id' => '', 'text' => TEXT_NONE));
$record_company = $db->Execute("select record_company_id, record_company_name\r\n from " . TABLE_RECORD_COMPANY . " order by record_company_name");
" valign="top"><table border="0" width="<?php
echo BOX_WIDTH;
?>
" cellspacing="1" cellpadding="1" class="columnLeft">
<!-- left_navigation //-->
<?php
require DIR_WS_INCLUDES . 'column_left.php';
?>
<!-- left_navigation_eof //-->
</table></td>
<!-- body_text //-->
<td width="100%" valign="top">
<?php
if ($action == 'new_product') {
$parameters = array('products_name' => '', 'products_description' => '', 'products_spec' => '', 'products_url' => '', 'products_id' => '', 'products_quantity' => '', 'products_model' => '', 'products_image' => '', 'products_image_med' => '', 'products_image_lrg' => '', 'products_image_sm_1' => '', 'products_image_xl_1' => '', 'products_image_sm_2' => '', 'products_image_xl_2' => '', 'products_image_sm_3' => '', 'products_image_xl_3' => '', 'products_image_sm_4' => '', 'products_image_xl_4' => '', 'products_image_sm_5' => '', 'products_image_xl_5' => '', 'products_image_sm_6' => '', 'products_image_xl_6' => '', 'products_price' => '', 'products_weight' => '', 'products_date_added' => '', 'products_last_modified' => '', 'products_date_available' => '', 'products_status' => '', 'products_tax_class_id' => '', 'manufacturers_id' => '');
$pInfo = new objectInfo($parameters);
//HTC BOC and MaxiDVD: Modified For Ultimate Images Pack!
if (isset($_GET['pID']) && !$_POST) {
$product_query = tep_db_query("select pd.products_name, pd.products_description, pd.products_spec, pd.products_head_title_tag, pd.products_head_desc_tag, pd.products_head_keywords_tag, pd.products_url, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_image_med, p.products_image_lrg, p.products_image_sm_1, p.products_image_xl_1, p.products_image_sm_2, p.products_image_xl_2, p.products_image_sm_3, p.products_image_xl_3, p.products_image_sm_4, p.products_image_xl_4, p.products_image_sm_5, p.products_image_xl_5, p.products_image_sm_6, p.products_image_xl_6, p.products_price, p.products_weight, p.products_date_added, p.products_last_modified, date_format(p.products_date_available, '%Y-%m-%d') as products_date_available, p.products_status, p.products_tax_class_id, p.manufacturers_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = '" . (int) $_GET['pID'] . "' and p.products_id = pd.products_id and pd.language_id = '" . (int) $languages_id . "'");
$product = tep_db_fetch_array($product_query);
//HTC EOC
$pInfo->objectInfo($product);
} elseif (tep_not_null($_POST)) {
$pInfo->objectInfo($_POST);
$products_name = $_POST['products_name'];
$products_description = $_POST['products_description'];
$products_spec = $_POST['products_spec'];
$products_url = $_POST['products_url'];
}
$manufacturers_array = array(array('id' => '', 'text' => TEXT_NONE));
$manufacturers_query = tep_db_query("select manufacturers_id, manufacturers_name from " . TABLE_MANUFACTURERS . " order by manufacturers_name");
</td>
<td class="main">
<?php
// toggle switch for editor
echo TEXT_EDITOR_INFO . zen_draw_form('set_editor_form', FILENAME_EZPAGES_ADMIN, '', 'get') . ' ' . zen_draw_pull_down_menu('reset_editor', $editors_pulldown, $current_editor_key, 'onChange="this.form.submit();"') . zen_hide_session_id() . zen_draw_hidden_field('action', 'set_editor') . '</form>';
}
?>
</td>
</tr>
</table></td>
</tr>
<?php
if ($action == 'new') {
$form_action = 'insert';
$parameters = array('pages_title' => '', 'page_open_new_window' => '', 'page_is_ssl' => '', 'pages_html_text' => '', 'alt_url' => '', 'alt_url_external' => '', 'header_sort_order' => '', 'sidebox_sort_order' => '', 'footer_sort_order' => '', 'toc_sort_order' => '', 'toc_chapter' => '', 'status_header' => '', 'status_sidebox' => '', 'status_footer' => '', 'status_toc' => '', 'page_open_new_window' => '', 'page_is_ssl' => '');
$ezInfo = new objectInfo($parameters);
if (isset($_GET['ezID'])) {
$form_action = 'update';
$ezID = zen_db_prepare_input($_GET['ezID']);
$page_query = "select * from " . TABLE_EZPAGES . " where pages_id = '" . $_GET['ezID'] . "'";
$page = $db->Execute($page_query);
$ezInfo->objectInfo($page->fields);
} elseif (zen_not_null($_POST)) {
$ezInfo->objectInfo($_POST);
}
// set all status settings and switches
if (!isset($ezInfo->status_header)) {
$ezInfo->status_header = '1';
}
switch ($ezInfo->status_header) {
case '0':
" valign="top"><table border="0" width="<?php
echo BOX_WIDTH;
?>
" cellspacing="0" cellpadding="1" class="columnLeft">
<!-- left_navigation //-->
<?php
require DIR_WS_INCLUDES . 'column_left.php';
?>
<!-- left_navigation_eof //-->
</table></td>
<!-- body_text //-->
<td width="100%" valign="top">
<?php
if ($action == 'edit' || $action == 'new') {
$parameters = array('manufacturers_name' => '', 'manufacturers_description' => '', 'manufacturers_id' => '', 'manufacturers_image' => '', 'date_added' => '', 'last_modified' => '');
$mInfo = new objectInfo($parameters);
if (tep_not_null($HTTP_GET_VARS['mID']) && empty($HTTP_POST_VARS)) {
$manufacturer_query = tep_db_query("select m.*, mi.* from " . TABLE_MANUFACTURERS . " m, " . TABLE_MANUFACTURERS_INFO . " mi where m.manufacturers_id = '" . (int) $HTTP_GET_VARS['mID'] . "' and m.manufacturers_id = mi.manufacturers_id and mi.languages_id = '" . (int) $languages_id . "'");
$manufacturer = tep_db_fetch_array($manufacturer_query);
$mInfo->objectInfo($manufacturer);
} elseif (tep_not_null($HTTP_POST_VARS)) {
$mInfo->objectInfo($HTTP_POST_VARS);
$manufacturers_name = array_map("stripslashes", $HTTP_POST_VARS['manufacturers_name']);
$manufacturers_description = array_map("stripslashes", $HTTP_POST_VARS['manufacturers_description']);
}
$languages = tep_get_languages();
$form_action = tep_not_null($HTTP_GET_VARS['mID']) ? 'save' : 'insert';
echo tep_draw_form('manufacturers', FILENAME_MANUFACTURERS, tep_get_all_get_params(array('mID', 'action')) . (tep_not_null($HTTP_GET_VARS['mID']) ? '&mID=' . $HTTP_GET_VARS['mID'] : '') . '&action=' . $form_action, 'post', 'enctype="multipart/form-data"') . tep_draw_hidden_field('manufacturers_id', $mInfo->manufacturers_id);
?>
<table border="0" width="100%" cellspacing="0" cellpadding="2">
<tr>
<tr>
<td><table border="0" width="100%" cellspacing="0" cellpadding="0">
<tr>
<td class="pageHeading"><?php
echo HEADING_TITLE;
?>
</td>
<td class="pageHeading" align="right"> </td>
</tr>
</table></td>
</tr>
<?php
if ($action == 'new') {
$form_action = 'insert';
$parameters = array('title' => '', 'content' => '', 'module' => '');
$nInfo = new objectInfo($parameters);
if (isset($_GET['nID'])) {
$form_action = 'update';
$nID = tep_db_prepare_input($_GET['nID']);
$newsletter_query = tep_db_query("select title, content, module from " . TABLE_NEWSLETTERS . " where newsletters_id = '" . (int) $nID . "'");
$newsletter = tep_db_fetch_array($newsletter_query);
$nInfo->objectInfo($newsletter);
} elseif ($_POST) {
$nInfo->objectInfo($_POST);
}
$file_extension = substr($PHP_SELF, strrpos($PHP_SELF, '.'));
$directory_array = array();
if ($dir = dir(DIR_WS_MODULES . 'newsletters/')) {
while ($file = $dir->read()) {
if (!is_dir(DIR_WS_MODULES . 'newsletters/' . $file)) {
if (substr($file, strrpos($file, '.')) == $file_extension) {
" valign="top"><table border="0" width="<?php
echo BOX_WIDTH;
?>
" cellspacing="0" cellpadding="1" class="columnLeft">
<!-- left_navigation //-->
<?php
require DIR_WS_INCLUDES . 'column_left.php';
?>
<!-- left_navigation_eof //-->
</table></td>
<!-- body_text //-->
<td width="100%" valign="top">
<?php
if ($action == 'edit_message' || $action == 'new_message') {
$parameters = array('messages_name' => '', 'messages_description' => '', 'messages_id' => '', 'date_added' => '', 'last_modified' => '', 'status' => '', 'messages_pages' => array(), 'sort_order' => '');
$mInfo = new objectInfo($parameters);
if (isset($HTTP_GET_VARS['mID']) && empty($HTTP_POST_VARS)) {
$message_query = tep_db_query("select * from " . TABLE_MESSAGES . " where messages_id = '" . (int) $HTTP_GET_VARS['mID'] . "'");
$message = tep_db_fetch_array($message_query);
$mInfo->objectInfo($message);
if (tep_not_null($mInfo->messages_pages)) {
$mInfo->messages_pages = explode("\n", $mInfo->messages_pages);
} else {
$mInfo->messages_pages = array();
}
} elseif (tep_not_null($HTTP_POST_VARS)) {
$mInfo->objectInfo($HTTP_POST_VARS);
}
if (!isset($mInfo->status)) {
$mInfo->status = '1';
}
echo NEWS_BOX_HEADING_TITLE;
?>
</td>
<td class="pageHeading" align="right"><?php
echo zen_draw_separator('pixel_trans.gif', HEADING_IMAGE_WIDTH, HEADING_IMAGE_HEIGHT);
?>
</td>
</tr>
</table>
</td>
</tr>
<?php
if ($action == 'new') {
$form_action = 'insert';
$parameters = array('news_title' => '', 'news_content' => '', 'news_added_date' => '', 'news_modified_date' => '', 'news_start_date' => '', 'news_end_date' => '', 'more_news_page' => '');
$nInfo = new objectInfo($parameters);
if (isset($_GET['nID'])) {
$form_action = 'update';
$nID = zen_db_prepare_input($_GET['nID']);
$news = $db->Execute("select nc.news_title, nc.news_content, n.more_news_page,\r\n date_format(n.news_added_date, '%Y-%m-%d') as news_added_date,\r\n date_format(n.news_modified_date, '%Y-%m-%d') as news_modified_date,\r\n date_format(n.news_start_date, '%Y-%m-%d') as news_start_date,\r\n date_format(n.news_end_date, '%Y-%m-%d') as news_end_date\r\n\t\t from " . TABLE_BOX_NEWS_CONTENT . " nc, " . TABLE_BOX_NEWS . " n \r\n\t\t where n.box_news_id = '" . (int) $nID . "'");
$nInfo->objectInfo($news->fields);
} elseif ($_POST) {
$nInfo->objectInfo($_POST);
}
?>
<link rel="stylesheet" type="text/css" href="includes/javascript/spiffyCal/spiffyCal_v2_1.css">
<script language="JavaScript" src="includes/javascript/spiffyCal/spiffyCal_v2_1.js"></script>
<script language="javascript">
<!--
var dateNewsStart = new ctlSpiffyCalendarBox("dateNewsStart", "news", "news_start_date","btnDate1","<?php
echo $nInfo->news_start_date;
echo BOX_WIDTH;
?>
" cellspacing="1" cellpadding="1" class="columnLeft">
<!-- left_navigation //-->
<?php
require DIR_WS_INCLUDES . 'column_left.php';
?>
<!-- left_navigation_eof //-->
</table></td>
<!-- body_text //-->
<td width="100%" valign="top">
<?php
if ($action == 'new_page') {
$parameters = array('pages_name' => '', 'pages_title' => '', 'pages_body' => '', 'pages_id' => '', 'pages_image' => '', 'pages_status' => '', 'sort_order' => '');
$pInfo = new objectInfo($parameters);
if (isset($_GET['pID']) && empty($_POST)) {
$page_query = tep_db_query("select pd.pages_title, pd.pages_body, p.pages_id, p.pages_name, p.pages_image, p.pages_status, p.sort_order from " . TABLE_PAGES . " p, " . TABLE_PAGES_DESCRIPTION . " pd where p.pages_id = '" . (int) $_GET['pID'] . "' and p.pages_id = pd.pages_id and pd.language_id = '" . (int) $languages_id . "'");
$page = tep_db_fetch_array($page_query);
$pInfo->objectInfo($page);
} elseif (tep_not_null($_POST)) {
$pInfo->objectInfo($_POST);
$pages_name = $_POST['pages_name'];
$pages_title = $_POST['pages_title'];
$pages_body = $_POST['pages_body'];
}
$languages = tep_get_languages();
if (!isset($pInfo->pages_status)) {
$pInfo->pages_status = '1';
}
switch ($pInfo->pages_status) {
" valign="top"><table border="0" width="<?php
echo BOX_WIDTH;
?>
" cellspacing="1" cellpadding="1" class="columnLeft">
<!-- left_navigation //-->
<?php
require DIR_WS_INCLUDES . 'column_left.php';
?>
<!-- left_navigation_eof //-->
</table></td>
<!-- body_text //-->
<td width="100%" valign="top">
<?php
if ($action == 'new_news') {
$parameters = array('news_title' => '', 'source' => '', 'sort_order' => '', 'news_categories_id' => '', 'date_added' => '', 'news_content' => '', 'news_status' => '', 'icon' => '');
$nInfo = new objectInfo($parameters);
if (isset($HTTP_GET_VARS['nID']) && empty($HTTP_POST_VARS)) {
$news_query = tep_db_query("select n.news_id, n.news_title, n.news_content, n.source, n.icon, n.sort_order, n.news_categories_id, n.news_status, n.date_added from " . TABLE_NEWS . " n where n.news_id = '" . (int) $HTTP_GET_VARS['nID'] . "'");
$news = tep_db_fetch_array($news_query);
$nInfo->objectInfo($news);
} elseif (tep_not_null($HTTP_POST_VARS)) {
$nInfo->objectInfo($HTTP_POST_VARS);
// $products_name = $HTTP_POST_VARS['products_name'];
// $products_description = $HTTP_POST_VARS['products_description'];
// $products_url = $HTTP_POST_VARS['products_url'];
// $news_title = $HTTP_POST_VARS['news_title'];
// $news_content = $HTTP_POST_VARS['news_content'];
// $news_icon_name = $HTTP_POST_VARS['icon'];
}
if (!isset($nInfo->news_status)) {
$nInfo->news_status = '1';
<?php
/**
* @package admin
* @copyright Copyright 2003-2016 Zen Cart Development Team
* @copyright Portions Copyright 2003 osCommerce
* @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0
* @version $Id: Author: DrByte Sun Oct 18 02:03:48 2015 -0400 Modified in v1.5.5 $
*/
if (!defined('IS_ADMIN_FLAG')) {
die('Illegal Access');
}
$parameters = array('products_name' => '', 'products_description' => '', 'products_url' => '', 'products_id' => '', 'products_quantity' => '', 'products_model' => '', 'products_image' => '', 'products_price' => '', 'products_price_w' => '', 'products_virtual' => DEFAULT_PRODUCT_PRODUCTS_VIRTUAL, 'products_weight' => '', 'products_date_added' => '', 'products_last_modified' => '', 'products_date_available' => '', 'products_status' => '', 'products_tax_class_id' => DEFAULT_PRODUCT_TAX_CLASS_ID, 'manufacturers_id' => '', 'products_quantity_order_min' => '', 'products_quantity_order_units' => '', 'products_priced_by_attribute' => '', 'product_is_free' => '', 'product_is_call' => '', 'products_quantity_mixed' => '', 'product_is_always_free_shipping' => DEFAULT_PRODUCT_PRODUCTS_IS_ALWAYS_FREE_SHIPPING, 'products_qty_box_status' => PRODUCTS_QTY_BOX_STATUS, 'products_quantity_order_max' => '0', 'products_sort_order' => '0', 'products_discount_type' => '0', 'products_discount_type_from' => '0', 'products_price_sorter' => '0', 'master_categories_id' => '');
$pInfo = new objectInfo($parameters);
if (isset($_GET['pID']) && empty($_POST)) {
$product = $db->Execute("select pd.products_name, pd.products_description, pd.products_url,\n p.products_id, p.products_quantity, p.products_model,\n/* Dual Pricing start */\n p.products_image, p.products_price, p.products_price_w, p.products_virtual, p.products_weight,\n/* Dual Pricing end */\n p.products_date_added, p.products_last_modified,\n date_format(p.products_date_available, '%Y-%m-%d') as\n products_date_available, p.products_status, p.products_tax_class_id,\n p.manufacturers_id,\n p.products_quantity_order_min, p.products_quantity_order_units, p.products_priced_by_attribute,\n p.product_is_free, p.product_is_call, p.products_quantity_mixed,\n p.product_is_always_free_shipping, p.products_qty_box_status, p.products_quantity_order_max,\n p.products_sort_order,\n p.products_discount_type, p.products_discount_type_from,\n p.products_price_sorter, p.master_categories_id\n from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd\n where p.products_id = '" . (int) $_GET['pID'] . "'\n and p.products_id = pd.products_id\n and pd.language_id = '" . (int) $_SESSION['languages_id'] . "'");
$pInfo->updateObjectInfo($product->fields);
} elseif (zen_not_null($_POST)) {
$pInfo->updateObjectInfo($_POST);
$products_name = $_POST['products_name'];
$products_description = $_POST['products_description'];
$products_url = $_POST['products_url'];
}
$category_lookup = $db->Execute("select *\n from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd\n where c.categories_id ='" . (int) $current_category_id . "'\n and c.categories_id = cd.categories_id\n and cd.language_id = '" . (int) $_SESSION['languages_id'] . "'");
if (!$category_lookup->EOF) {
$cInfo = new objectInfo($category_lookup->fields);
} else {
$cInfo = new objectInfo(array());
}
$manufacturers_array = array(array('id' => '', 'text' => TEXT_NONE));
$manufacturers = $db->Execute("select manufacturers_id, manufacturers_name\n from " . TABLE_MANUFACTURERS . " order by manufacturers_name");
<!-- left_navigation //-->
<?php
require DIR_WS_INCLUDES . 'column_left.php';
?>
<!-- left_navigation_eof //-->
</table></td>
<!-- body_text //-->
<td width="100%" valign="top">
<?php
if ($action == 'new_block' || $action == 'edit_block') {
$parameters = array();
$query = tep_db_query("describe " . TABLE_BLOCKS);
while ($row = tep_db_fetch_array($query)) {
$parameters[$row['Field']] == (tep_not_null($row['Default']) ? $row['Default'] : '');
}
$bInfo = new objectInfo($parameters);
if (isset($HTTP_GET_VARS['bID']) && empty($HTTP_POST_VARS)) {
if ($tPath == '0') {
$block_query = tep_db_query("select * from " . TABLE_BLOCKS . " where blocks_id = '" . (int) $HTTP_GET_VARS['bID'] . "' and language_id = '" . (int) $languages_id . "'");
} else {
$block_query = tep_db_query("select b.*, if (bt.blocks_types_field='textarea_text', b.blocks_description, b.blocks_description_short) as blocks_description from " . TABLE_BLOCKS . " b, " . TABLE_BLOCKS_TYPES . " bt where b.blocks_id = '" . (int) $HTTP_GET_VARS['bID'] . "' and b.blocks_types_id = bt.blocks_types_id and b.language_id = bt.language_id and b.language_id = '" . (int) $languages_id . "'");
}
$block = tep_db_fetch_array($block_query);
$block['templates'] = array();
$templates = array();
$templates_query = tep_db_query("select distinct templates_id from " . TABLE_TEMPLATES_TO_BLOCKS . " where blocks_id = '" . (int) $block['blocks_id'] . "'");
while ($templates_array = tep_db_fetch_array($templates_query)) {
$block['templates'][] = $templates_array['templates_id'];
}
$bInfo->objectInfo($block);
} elseif (tep_not_null($HTTP_POST_VARS)) {
?>
</td>
<td class="pageHeading" align="right"><?php
echo tep_draw_separator('pixel_trans.gif', HEADING_IMAGE_WIDTH, HEADING_IMAGE_HEIGHT);
?>
</td>
</tr>
</table>
</td>
</tr>
<?php
//uncommment 'new newsletter' button below to activate
if ($action == 'new') {
$form_action = 'insert';
$parameters = array('title' => $title, 'htmlcontent' => $htmlcontent, 'txtcontent' => $txtcontent, 'template' => $template);
$nInfo = new objectInfo($parameters);
if (isset($HTTP_GET_VARS['nID'])) {
$form_action = 'update';
$nID = tep_db_prepare_input($HTTP_GET_VARS['nID']);
$mail_query = tep_db_query("select title, htmlcontent, txtcontent, placeholders, template, status from " . TABLE_MM_RESPONSEMAIL . " where mail_id = '" . (int) $nID . "'");
$mail = tep_db_fetch_array($mail_query);
$placeholders = $mail['placeholders'];
$template_title = $mail['template'];
$nInfo->objectInfo($mail);
} elseif ($HTTP_POST_VARS) {
$nInfo->objectInfo($HTTP_POST_VARS);
}
?>
<tr>
<td><?php
$menuType = "registration";
?>
<div class="content-wrapper">
<!-- Content Header (Page header) -->
<section class="content-header">
<h1>
Student Registration
</h1>
</section>
<!-- Main content -->
<section class="content">
<div class="row">
<?php
$registrationInfo = new dataInfo();
$objectInfoData = new objectInfo();
$classData = $objectInfoData->getClass();
$subjectData = $objectInfoData->getSubject();
if (isset($_REQUEST['studentId'])) {
$registrationData = $registrationInfo->getDataById("studentregistration", "studentId", $_REQUEST['studentId']);
$edit = true;
}
?>
<div class="col-md-12">
<div class="nav-tabs-custom">
<div class="tab-content">
<div id="settings" class="tab-pane active">
<form class="form-horizontal" method="post" action="<?php
echo $_SERVER['REQUEST_URI'];
?>
">
}
$template_array = $g_db->fetch_array($template_query);
$filename = tep_create_safe_string(strtolower($template_array['template_title']), '-') . '.html';
header('Content-type: application/x-octet-stream');
header('Content-disposition: attachment; filename=' . $filename);
echo $template_array['template_content'];
$g_session->close();
break;
default:
break;
}
require DIR_FS_OBJECTS . 'html_start_sub1.php';
require DIR_FS_OBJECTS . 'html_start_sub2.php';
if ($action == 'new_template') {
$parameters = array('template_id' => '', 'group_id' => TEMPLATE_SYSTEM_GROUP, 'template_title' => '', 'template_subject' => '', 'template_content' => $template_content);
$tInfo = new objectInfo($parameters);
$groups_query = "select group_id as id, group_title as text from " . TABLE_TEMPLATES_GROUPS . " order by group_title";
$groups_array = $g_db->query_to_array($groups_query);
if (!empty($tID)) {
$template_query = $g_db->query("select template_id, group_id, template_title, template_subject, template_content from " . TABLE_TEMPLATES . " where template_id = '" . (int) $tID . "'");
$template = $g_db->fetch_array($template_query);
$tInfo->objectInfo($template, false);
if (!empty($template_content)) {
$tInfo->template_content = $template_content;
}
}
if (!empty($tID)) {
$form_action = 'tID=' . $tID . '&action=template_upload';
} else {
$form_action = 'action=template_upload';
}
<td class="pageHeading"><?php
echo HEADING_TITLE;
?>
</td>
<td class="pageHeading" align="right"><?php
echo tep_draw_separator('pixel_trans.gif', HEADING_IMAGE_WIDTH, HEADING_IMAGE_HEIGHT);
?>
</td>
</tr>
</table></td>
</tr>
<?php
if ($action == 'new') {
$form_action = 'insert';
$parameters = array('expires_date' => '', 'date_scheduled' => '', 'banners_title' => '', 'banners_url' => '', 'banners_group' => '', 'banners_image' => '', 'banners_html_text' => '', 'expires_impressions' => '');
$bInfo = new objectInfo($parameters);
if (isset($HTTP_GET_VARS['bID'])) {
$form_action = 'update';
$bID = tep_db_prepare_input($HTTP_GET_VARS['bID']);
$banner_query = tep_db_query("select banners_title, banners_url, banners_image, banners_group, banners_html_text, status, date_format(date_scheduled, '%d/%m/%Y') as date_scheduled, date_format(expires_date, '%d/%m/%Y') as expires_date, expires_impressions, date_status_change from " . TABLE_BANNERS . " where banners_id = '" . (int) $bID . "'");
$banner = tep_db_fetch_array($banner_query);
$bInfo->objectInfo($banner);
} elseif (tep_not_null($HTTP_POST_VARS)) {
$bInfo->objectInfo($HTTP_POST_VARS);
}
$groups_array = array();
$groups_query = tep_db_query("select distinct banners_group from " . TABLE_BANNERS . " order by banners_group");
while ($groups = tep_db_fetch_array($groups_query)) {
$groups_array[] = array('id' => $groups['banners_group'], 'text' => $groups['banners_group']);
}
?>
// EOF QPBPP for SPPC
} else {
// LINE MODED: Separate Pricing Per Customer adapted for QPBPP for SPPC v4.2
// LINE MODED: Open Feature Sets : Added ", pd.products_short"
// $product_query = tep_db_query("select p.products_id, pd.language_id, pd.products_name, pd.products_description, pd.products_short, pd.tab1, pd.tab2, pd.tab3, pd.tab4, pd.tab5, pd.tab6, pd.products_url, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_weight, p.products_length, p.products_width, p.products_height, p.products_ready_to_ship, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_status, p.manufacturers_id, p.products_qty_blocks, p.products_min_order_qty from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = pd.products_id and p.products_id = '" . (int)$_GET['pID'] . "'");
// BOF: Extra Product Fields
// LINE MODED: MSRP: Added "p.products_msrp,"
$query = "select p.products_id, pd.language_id, pd.products_name, pd.products_description, pd.products_short, pd.tab1, pd.tab2, pd.tab3, pd.tab4, pd.tab5, pd.tab6, pd.products_url, p.products_quantity, p.products_model, p.products_image, p.products_msrp, p.products_price, p.products_weight, p.products_length, p.products_width, p.products_height, p.products_ready_to_ship, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_status, p.products_ship_sep, p.manufacturers_id, p.products_qty_blocks, p.products_min_order_qty ";
foreach ($xfields as $f) {
$query .= ', pd.' . $f;
}
$query .= " from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = pd.products_id and p.products_id = '" . (int) $_GET['pID'] . "'";
$product_query = tep_db_query($query);
// EOF: Extra Product Fields
$product = tep_db_fetch_array($product_query);
$pInfo = new objectInfo($product);
$products_image_name = $pInfo->products_image;
// move retail settings for quantity blocks and min order qty to an array indexed
// by customer_group_id, like we get back in $_POST values
unset($pInfo->products_qty_blocks);
$pInfo->products_qty_blocks[0] = $product['products_qty_blocks'];
unset($pInfo->products_min_order_qty);
$pInfo->products_min_order_qty[0] = $product['products_min_order_qty'];
// price_breaks_array is taken care of by PriceFormatterAdmin.php
// EOF QPBPP for SPPC
// BOF indvship 4.5
$products_shipping_query = tep_db_query("SELECT * FROM " . TABLE_PRODUCTS_SHIPPING . " WHERE products_id=" . (int) $_GET['pID']);
while ($products_shipping = tep_db_fetch_array($products_shipping_query)) {
$products_ship_methods_id = $products_shipping['products_ship_methods_id'];
$products_ship_zip = $products_shipping['products_ship_zip'];
$products_ship_price = $products_shipping['products_ship_price'];
<tr>
<td><?php
echo tep_draw_separator('pixel_trans.gif', '1', '10');
?>
</td>
</tr>
<tr>
<td align="right" class="main"><?php
echo tep_image_submit('button_update.gif', IMAGE_UPDATE) . ' <a href="' . tep_href_link(FILENAME_BOARDS, tep_get_all_get_params(array('action'))) . '">' . tep_image_button('button_cancel.gif', IMAGE_CANCEL) . '</a>';
?>
</td>
</tr></form>
<?php
} elseif ($action == 'new_category' || $action == 'edit_category') {
$parameters = array('boards_categories_name' => '', 'boards_categories_description' => '', 'boards_categories_id' => '', 'image' => '', 'date_added' => '', 'last_modified' => '', 'status' => '', 'boards_categories_path' => '');
$cInfo = new objectInfo($parameters);
if (isset($HTTP_GET_VARS['cID']) && empty($HTTP_POST_VARS)) {
$boards_category_query = tep_db_query("select * from " . TABLE_BOARDS_CATEGORIES . " where boards_categories_id = '" . (int) $HTTP_GET_VARS['cID'] . "' and language_id = '" . (int) $languages_id . "'");
$boards_category = tep_db_fetch_array($boards_category_query);
$cInfo->objectInfo($boards_category);
} elseif (tep_not_null($HTTP_POST_VARS)) {
$cInfo->objectInfo($HTTP_POST_VARS);
$boards_categories_name = $HTTP_POST_VARS['boards_categories_name'];
$boards_categories_description = $HTTP_POST_VARS['boards_categories_description'];
}
$languages = tep_get_languages();
if (!isset($cInfo->status)) {
$cInfo->status = '1';
}
switch ($cInfo->status) {
case '0':
<td class="pageHeading"><?php
echo HEADING_TITLE;
?>
</td>
<td class="pageHeading" align="right"><?php
echo tep_draw_separator('pixel_trans.gif', HEADING_IMAGE_WIDTH, HEADING_IMAGE_HEIGHT);
?>
</td>
</tr>
</table></td>
</tr>
<?php
if ($action == 'new') {
$form_action = 'insert';
$parameters = array('pages_title' => '', 'pages_html_text' => '', 'sort_order' => '', 'status' => '');
$bInfo = new objectInfo($parameters);
if (isset($_GET['bID'])) {
$form_action = 'update';
$bID = tep_db_prepare_input($_GET['bID']);
$page_query = tep_db_query("select\n s.status,\n s.sort_order,\n s.page_type,\n p.pages_title,\n p.pages_html_text,\n p.intorext,\n p.externallink,\n p.link_target,\n p.language_id\n from\n " . TABLE_PAGES . " s left join " . TABLE_PAGES_DESCRIPTION . " p on s.pages_id=p.pages_id\n where\n s.pages_id = '" . (int) $bID . "'");
while ($page = tep_db_fetch_array($page_query)) {
$languageid = $page['language_id'];
$page_type = $page['page_type'];
$pagetitle[$languageid] = $page['pages_title'];
$sortorder = $page['sort_order'];
$pages_html_text[$languageid] = $page['pages_html_text'];
$intorext[$languageid] = $page['intorext'];
$externallink[$languageid] = $page['externallink'];
$link_target[$languageid] = $page['link_target'];
}
} elseif (tep_not_null($_POST)) {
<!-- left_navigation //-->
<?php
require DIR_WS_INCLUDES . 'column_left.php';
?>
<!-- left_navigation_eof //-->
</table></td>
<!-- body_text //-->
<td width="100%" valign="top">
<?php
if ($action == 'edit' || $action == 'new') {
$parameters = array();
$query = tep_db_query("describe " . TABLE_AUTHORS . "");
while ($row = tep_db_fetch_array($query)) {
$parameters[$row['Field']] = '';
}
$aInfo = new objectInfo($parameters);
if (tep_not_null($HTTP_GET_VARS['aID']) && empty($HTTP_POST_VARS)) {
$author_query = tep_db_query("select * from " . TABLE_AUTHORS . " where authors_id = '" . (int) $HTTP_GET_VARS['aID'] . "' and language_id = '" . (int) $languages_id . "'");
$author = tep_db_fetch_array($author_query);
$aInfo->objectInfo($author);
} elseif (tep_not_null($HTTP_POST_VARS)) {
$aInfo->objectInfo($HTTP_POST_VARS);
$authors_name = array_map("stripslashes", $HTTP_POST_VARS['authors_name']);
$authors_description = array_map("stripslashes", $HTTP_POST_VARS['authors_description']);
}
$languages = tep_get_languages();
$form_action = tep_not_null($HTTP_GET_VARS['aID']) ? 'save' : 'insert';
echo tep_draw_form('authors', FILENAME_AUTHORS, tep_get_all_get_params(array('aID', 'action')) . (tep_not_null($HTTP_GET_VARS['aID']) ? '&aID=' . $HTTP_GET_VARS['aID'] : '') . '&action=' . $form_action, 'post', 'enctype="multipart/form-data"') . (tep_not_null($HTTP_GET_VARS['aID']) ? tep_draw_hidden_field('authors_id', $aInfo->authors_id) : '');
?>
<table border="0" width="100%" cellspacing="0" cellpadding="2">
<tr>
<td class="pageHeading"><?php
echo HEADING_TITLE;
?>
</td>
<td class="pageHeading" align="right"><?php
echo tep_draw_separator('pixel_trans.gif', HEADING_IMAGE_WIDTH, HEADING_IMAGE_HEIGHT);
?>
</td>
</tr>
</table></td>
</tr>
<?php
if ($action == 'new') {
$form_action = 'insert';
$parameters = array('expires_date' => '', 'date_scheduled' => '', 'banners_title' => '', 'banners_url' => '', 'banners_group' => '', 'banners_image' => '', 'banners_html_text' => '', 'expires_impressions' => '');
$bInfo = new objectInfo($parameters);
if (isset($_GET['bID'])) {
$form_action = 'update';
$bID = tep_db_prepare_input($_GET['bID']);
$banner_query = tep_db_query("select banners_title, banners_url, banners_image, banners_group, banners_html_text, status, date_format(date_scheduled, '%Y/%m/%d') as date_scheduled, date_format(expires_date, '%Y/%m/%d') as expires_date, expires_impressions, date_status_change from " . TABLE_BANNERS . " where banners_id = '" . (int) $bID . "'");
$banner = tep_db_fetch_array($banner_query);
$bInfo->objectInfo($banner);
} elseif (tep_not_null($_POST)) {
$bInfo->objectInfo($_POST);
}
$groups_array = array();
$groups_query = tep_db_query("select distinct banners_group from " . TABLE_BANNERS . " order by banners_group");
while ($groups = tep_db_fetch_array($groups_query)) {
$groups_array[] = array('id' => $groups['banners_group'], 'text' => $groups['banners_group']);
}
?>
" valign="top"><table border="0" width="<?php
echo BOX_WIDTH;
?>
" cellspacing="1" cellpadding="1" class="columnLeft">
<!-- left_navigation //-->
<?php
require DIR_WS_INCLUDES . 'column_left.php';
?>
<!-- left_navigation_eof //-->
</table></td>
<!-- body_text //-->
<td width="100%" valign="top">
<?php
if ($action == 'new_product') {
$parameters = array('products_name' => '', 'products_description' => '', 'products_url' => '', 'products_id' => '', 'products_quantity' => '', 'products_model' => '', 'products_image' => '', 'products_price' => '', 'products_weight' => '', 'products_date_added' => '', 'products_last_modified' => '', 'products_date_available' => '', 'products_status' => '', 'products_tax_class_id' => '', 'manufacturers_id' => '', 'products_fsk18' => '', 'products_price_class' => '', 'products_ean' => '', 'products_distributor_id' => '');
$pInfo = new objectInfo($parameters);
if (isset($HTTP_GET_VARS['pID']) && empty($HTTP_POST_VARS)) {
$product_query = tep_db_query("select p.products_ean,p.products_distributor_id,pd.short_description,p.products_price_class,pd.products_name, pd.products_description, pd.products_url, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_weight, p.products_date_added, p.products_last_modified, date_format(p.products_date_available, '%Y-%m-%d') as products_date_available, p.products_status, p.products_tax_class_id, p.manufacturers_id,p.products_fsk18 from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = '" . (int) $HTTP_GET_VARS['pID'] . "' and p.products_id = pd.products_id and pd.language_id = '" . (int) $languages_id . "'");
$product = tep_db_fetch_array($product_query);
$pInfo->objectInfo($product);
} elseif (tep_not_null($HTTP_POST_VARS)) {
$pInfo->objectInfo($HTTP_POST_VARS);
$products_name = $HTTP_POST_VARS['products_name'];
$products_description = $HTTP_POST_VARS['products_description'];
$short_description = $HTTP_POST_VARS['short_description'];
$products_url = $HTTP_POST_VARS['products_url'];
}
$manufacturers_array = array(array('id' => '', 'text' => TEXT_NONE));
$manufacturers_query = tep_db_query("select manufacturers_id, manufacturers_name from " . TABLE_MANUFACTURERS . " order by manufacturers_name");
while ($manufacturers = tep_db_fetch_array($manufacturers_query)) {
$manufacturers_array[] = array('id' => $manufacturers['manufacturers_id'], 'text' => $manufacturers['manufacturers_name']);
" cellspacing="0" cellpadding="1" class="columnLeft">
<!-- left_navigation //-->
<?php
require DIR_WS_INCLUDES . 'column_left.php';
?>
<!-- left_navigation_eof //-->
</table></td>
<!-- body_text //-->
<td width="100%" valign="top"><?php
if ($action == 'new' || $action == 'edit') {
$parameters = array();
$query = tep_db_query("describe " . TABLE_TEMPLATES);
while ($row = tep_db_fetch_array($query)) {
$parameters[$row['Field']] == (tep_not_null($row['Default']) ? $row['Default'] : '');
}
$tInfo = new objectInfo($parameters);
$tInfo->blocks = array();
$tInfo->blocks_types = array();
if (isset($HTTP_GET_VARS['tID']) && empty($HTTP_POST_VARS)) {
$template_query = tep_db_query("select * from " . TABLE_TEMPLATES . " where templates_id = '" . (int) $HTTP_GET_VARS['tID'] . "' and language_id = '" . (int) $languages_id . "'");
$template = tep_db_fetch_array($template_query);
$template['blocks'] = array();
$blocks_query = tep_db_query("select blocks_id from " . TABLE_TEMPLATES_TO_BLOCKS . " where templates_id = '" . (int) $HTTP_GET_VARS['tID'] . "'");
while ($blocks = tep_db_fetch_array($blocks_query)) {
$template['blocks'][] = $blocks['blocks_id'];
}
$template['blocks_types'] = array();
$types_query = tep_db_query("select blocks_types_id from " . TABLE_TEMPLATES_TO_BLOCKS_TYPES . " where templates_id = '" . (int) $HTTP_GET_VARS['tID'] . "'");
while ($types = tep_db_fetch_array($types_query)) {
$template['blocks_types'][] = $types['blocks_types_id'];
}
?>
</td>
<?php
if (!in_array($action, array('send', 'confirm', 'confirm_send', ''))) {
// toggle switch for editor
echo TEXT_EDITOR_INFO . zen_draw_form('set_editor_form', FILENAME_NEWSLETTERS, '', 'get') . ' ' . zen_draw_pull_down_menu('reset_editor', $editors_pulldown, $current_editor_key, 'onChange="this.form.submit();"') . zen_hide_session_id() . zen_draw_hidden_field('action', 'set_editor') . '</form>';
}
?>
</tr>
</table></td>
</tr>
<?php
if ($action == 'new') {
$form_action = 'insert';
$parameters = array('title' => '', 'content' => '', 'content_html' => '', 'module' => '');
$nInfo = new objectInfo($parameters);
if (isset($_GET['nID'])) {
$form_action = 'update';
$nID = zen_db_prepare_input($_GET['nID']);
$newsletter = $db->Execute("select title, content, content_html, module\n from " . TABLE_NEWSLETTERS . "\n where newsletters_id = '" . (int) $nID . "'");
$nInfo->objectInfo($newsletter->fields);
} elseif ($_POST) {
$nInfo->objectInfo($_POST);
}
$file_extension = substr($PHP_SELF, strrpos($PHP_SELF, '.'));
$directory_array = array();
if ($dir = dir(DIR_WS_MODULES . 'newsletters/')) {
while ($file = $dir->read()) {
if (!is_dir(DIR_WS_MODULES . 'newsletters/' . $file)) {
if (substr($file, strrpos($file, '.')) == $file_extension) {
$directory_array[] = $file;
tep_redirect(tep_href_link(FILENAME_CATEGORIES, 'cPath=' . $categories_id . '&pID=' . $products_id));
break;
}
}
// check if the catalog image directory exists
if (is_dir(DIR_FS_CATALOG_IMAGES)) {
if (!tep_is_writable(DIR_FS_CATALOG_IMAGES)) {
$messageStack->add(ERROR_CATALOG_IMAGE_DIRECTORY_NOT_WRITEABLE, 'error');
}
} else {
$messageStack->add(ERROR_CATALOG_IMAGE_DIRECTORY_DOES_NOT_EXIST, 'error');
}
require DIR_WS_INCLUDES . 'template_top.php';
if ($action == 'new_product') {
$parameters = array('products_name' => '', 'products_description' => '', 'products_url' => '', 'products_id' => '', 'products_quantity' => '', 'products_model' => '', 'products_image' => '', 'products_larger_images' => array(), 'products_price' => '', 'products_weight' => '', 'products_date_added' => '', 'products_last_modified' => '', 'products_date_available' => '', 'products_status' => '', 'products_tax_class_id' => '', 'manufacturers_id' => '');
$pInfo = new objectInfo($parameters);
if (isset($HTTP_GET_VARS['pID']) && empty($HTTP_POST_VARS)) {
$product_query = tep_db_query("select pd.products_name, pd.products_description, pd.products_url, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_weight, p.products_date_added, p.products_last_modified, date_format(p.products_date_available, '%Y-%m-%d') as products_date_available, p.products_status, p.products_tax_class_id, p.manufacturers_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = '" . (int) $HTTP_GET_VARS['pID'] . "' and p.products_id = pd.products_id and pd.language_id = '" . (int) $languages_id . "'");
$product = tep_db_fetch_array($product_query);
$pInfo->objectInfo($product);
$product_images_query = tep_db_query("select id, image, htmlcontent, sort_order from " . TABLE_PRODUCTS_IMAGES . " where products_id = '" . (int) $product['products_id'] . "' order by sort_order");
while ($product_images = tep_db_fetch_array($product_images_query)) {
$pInfo->products_larger_images[] = array('id' => $product_images['id'], 'image' => $product_images['image'], 'htmlcontent' => $product_images['htmlcontent'], 'sort_order' => $product_images['sort_order']);
}
}
$manufacturers_array = array(array('id' => '', 'text' => TEXT_NONE));
$manufacturers_query = tep_db_query("select manufacturers_id, manufacturers_name from " . TABLE_MANUFACTURERS . " order by manufacturers_name");
while ($manufacturers = tep_db_fetch_array($manufacturers_query)) {
$manufacturers_array[] = array('id' => $manufacturers['manufacturers_id'], 'text' => $manufacturers['manufacturers_name']);
}
$tax_class_array = array(array('id' => '0', 'text' => TEXT_NONE));
?>
" style="text-decoration: underline;">
Подписчики</a>
</td>
<td class="pageHeading" align="right"><?php
echo tep_draw_separator('pixel_trans.gif', HEADING_IMAGE_WIDTH, HEADING_IMAGE_HEIGHT);
?>
</td>
</tr>
</table></td>
</tr>
<?php
if ($action == 'new') {
$form_action = 'insert';
$parameters = array('title' => '', 'content' => '', 'module' => '', 'filter' => '');
$nInfo = new objectInfo($parameters);
if (isset($HTTP_GET_VARS['nID'])) {
$form_action = 'update';
$nID = tep_db_prepare_input($HTTP_GET_VARS['nID']);
$newsletter_query = tep_db_query("select title, content, module, filter from " . TABLE_NEWSLETTERS . " where newsletters_id = '" . (int) $nID . "'");
$newsletter = tep_db_fetch_array($newsletter_query);
$nInfo->objectInfo($newsletter);
} elseif ($HTTP_POST_VARS) {
$nInfo->objectInfo($HTTP_POST_VARS);
}
$file_extension = substr($PHP_SELF, strrpos($PHP_SELF, '.'));
$directory_array = array();
if ($dir = dir(DIR_WS_MODULES . 'newsletters/')) {
while ($file = $dir->read()) {
if (!is_dir(DIR_WS_MODULES . 'newsletters/' . $file)) {
if (substr($file, strrpos($file, '.')) == $file_extension) {
<h2><i class="fa fa-picture-o"></i> <a href="<?php
echo OSCOM::link('banner_manager.php');
?>
"><?php
echo OSCOM::getDef('heading_title');
?>
</a></h2>
<?php
if (!empty($action)) {
if ($action == 'new') {
$show_listing = false;
$form_action = 'insert';
$parameters = array('expires_date' => '', 'date_scheduled' => '', 'banners_title' => '', 'banners_url' => '', 'banners_group' => '', 'banners_image' => '', 'banners_html_text' => '', 'expires_impressions' => '');
$bInfo = new objectInfo($parameters);
if (isset($_GET['bID'])) {
$form_action = 'update';
$bID = HTML::sanitize($_GET['bID']);
$Qbanner = $OSCOM_Db->get('banners', ['banners_title', 'banners_url', 'banners_image', 'banners_group', 'banners_html_text', 'status', 'date_format(date_scheduled, "%Y-%m-%d") as date_scheduled', 'date_format(expires_date, "%Y-%m-%d") as expires_date', 'expires_impressions', 'date_status_change'], ['banners_id' => (int) $bID]);
$bInfo->objectInfo($Qbanner->toArray());
} elseif (tep_not_null($_POST)) {
$bInfo->objectInfo($_POST);
}
$groups_array = [];
$Qgroups = $OSCOM_Db->get('banners', 'distinct banners_group', null, 'banners_group');
while ($Qgroups->fetch()) {
$groups_array[] = ['id' => $Qgroups->value('banners_group'), 'text' => $Qgroups->value('banners_group')];
}
?>
<table border="0" width="100%" cellspacing="0" cellpadding="0">
<tr>
<td class="pageHeading"><?php
echo HEADING_TITLE;
?>
</td>
<td class="pageHeading" align="right"> </td>
</tr>
</table>
</td>
</tr>
<?php
if ($action == 'new') {
$form_action = 'insert';
$parameters = array('title' => '', 'content' => '', 'module' => '');
$nInfo = new objectInfo($parameters);
if (isset($_GET['nID'])) {
$form_action = 'update';
$nID = tep_db_prepare_input($_GET['nID']);
$affiliate_newsletter_query = tep_db_query("select title, content, module from " . TABLE_AFFILIATE_NEWSLETTERS . " where affiliate_newsletters_id = '" . (int) $nID . "'");
$affiliate_newsletter = tep_db_fetch_array($affiliate_newsletter_query);
$nInfo->objectInfo($affiliate_newsletter);
} elseif ($_POST) {
$nInfo->objectInfo($_POST);
}
$file_extension = substr($PHP_SELF, strrpos($PHP_SELF, '.'));
$directory_array = array();
if ($dir = dir(DIR_WS_MODULES . 'newsletters/')) {
while ($file = $dir->read()) {
if (!is_dir(DIR_WS_MODULES . 'newsletters/' . $file)) {
if (substr($file, strrpos($file, '.')) == $file_extension) {
<div class="row">
<div class="col-xs-1">
<h3 class="box-title">Registration</h3>
</div>
<form action="<?php
echo $_SERVER['REQUEST_URI'];
?>
" method="get">
<div class="col-xs-10">
<h3 class="box-title" style="padding:0 5% 0 5%">
<select class="form-control" name="city" >
<option value="">Select City</option>
<?php
$registrationInfo = new dataInfo();
$objectInfoData = new objectInfo();
$classData = $objectInfoData->getClass();
$cityData = $registrationInfo->selectAll("city");
foreach ($cityData as $city) {
if (isset($_REQUEST['city']) && $city->cityId == $_REQUEST['city']) {
?>
<option value="<?php
echo $city->cityId;
?>
" selected="selected"><?php
echo $city->name;
?>
</option>
<?php
} else {
?>
