PDA

View Full Version : Automated Auction Process



michael_s
08-23-2007, 11:12 AM
NOT A FULL PACKAGE

This mod adds header tags controller 2.6.3 Complete support.

1. This step helps correct header tags controller support. The problem is the header does not parse correctly.

make a new category: Auctions and disable it, and id is 9999. Use php admin to run this query.

INSERT INTO `categories_description` ( `categories_id` , `language_id` , `categories_name` ,`categories_htc_title_tag` , `categories_htc_desc_tag` , `categories_htc_keywords_tag` ,`categories_htc_description` ) VALUES ('9999', '1', 'Auctions', NULL , NULL , NULL , NULL);

2. In admin/includes/languages/english/auction_listings_admin.php
ADD before last ?>:
//HTC BOC
define('TEXT_PRODUCT_METTA_INFO', 'Meta Tag Information');
define('TEXT_PRODUCTS_PAGE_TITLE', 'Product Title Tag:');
define('TEXT_PRODUCTS_HEADER_DESCRIPTION', 'Product Description Tag:');
define('TEXT_PRODUCTS_KEYWORDS', 'Product Keywords Tag:');
//HTC EOC

3. In catalog/admin/auction_listings_admin.php:
FIND:
$sql_data_array = array('products_name' => tep_db_prepare_input($HTTP_POST_VARS['products_name']),
'products_title' => tep_db_prepare_input($HTTP_POST_VARS['products_title']),
'products_description' => tep_db_prepare_input($HTTP_POST_VARS['products_description']),
'products_url' => tep_db_prepare_input($HTTP_POST_VARS['products_url']));

REPLACE WITH:
//HTC BOC
$sql_data_array = array('products_name' => tep_db_prepare_input($HTTP_POST_VARS['products_name']),
'products_title' => tep_db_prepare_input($HTTP_POST_VARS['products_title']),
'products_description' => tep_db_prepare_input($HTTP_POST_VARS['products_description']),
'products_url' => tep_db_prepare_input($HTTP_POST_VARS['products_url']),
'products_head_title_tag' => ((tep_not_null($HTTP_POST_VARS['products_head_title_tag'])) ? tep_db_prepare_input($HTTP_POST_VARS['products_head_title_tag']) : tep_db_prepare_input($HTTP_POST_VARS['products_name'])),
'products_head_desc_tag' => ((tep_not_null($HTTP_POST_VARS['products_head_desc_tag'])) ? tep_db_prepare_input($HTTP_POST_VARS['products_head_desc_tag']) : tep_db_prepare_input($HTTP_POST_VARS['products_name'])),
'products_head_keywords_tag' => ((tep_not_null($HTTP_POST_VARS['products_head_keywords_tag'])) ? tep_db_prepare_input($HTTP_POST_VARS['products_head_keywords_tag']) : tep_db_prepare_input($HTTP_POST_VARS['products_name'])));
//HTC EOC


FIND: if you DO NOT have more pics contrib installed:
if (isset($HTTP_GET_VARS['pID']) && empty($HTTP_POST_VARS)) {
$product_query = tep_db_query("select pd.products_name, pd.products_title, 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 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);
OR

FIND: if you DO have more pics contrib installed:
if (isset($HTTP_GET_VARS['pID']) && empty($HTTP_POST_VARS)) {
$product_query = tep_db_query("select pd.products_name, pd.products_title, pd.products_description, pd.products_url, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_image_2, p.products_image_3, p.products_image_4, p.products_image_5, p.products_image_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 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);

REPLACE WITH: if you DO NOT have more pics contrib installed:
if (isset($HTTP_GET_VARS['pID']) && empty($HTTP_POST_VARS)) {
$product_query = tep_db_query("select pd.products_name, pd.products_title, pd.products_description, 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_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 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);
OR

REPLACE WITH:if you DO have more pics contrib installed:
if (isset($HTTP_GET_VARS['pID']) && empty($HTTP_POST_VARS)) {
$product_query = tep_db_query("select pd.products_name, pd.products_title, pd.products_description, 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_2, p.products_image_3, p.products_image_4, p.products_image_5, p.products_image_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 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);


FIND:




ADD AFTER:











































More... (http://www.oscommerce.com/community/contributions,1739)