Community Add-Ons

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', '<b>Meta Tag Information</b>');
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:
<?php
} elseif ($action == 'new_product_preview') {
if (tep_not_null($HTTP_POST_VARS)) {
$pInfo = new objectInfo($HTTP_POST_VARS);
$products_name = $HTTP_POST_VARS['products_name'];
$products_title = $HTTP_POST_VARS['products_title'];
$products_description = $HTTP_POST_VARS['products_description'];
$products_url = $HTTP_POST_VARS['products_url'];
} else {
$product_query = tep_db_query("select p.products_id, pd.language_id, pd.products_name, pd.products_title, pd.products_description, pd.products_url, 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, p.products_date_available, p.products_status, p.manufacturers_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = pd.products_id and p.products_id = '" . (int)$HTTP_GET_VARS['pID'] . "'");
$product = tep_db_fetch_array($product_query);

REPLACE WITH:
<!-- HTC BOC //-->
<?php
} elseif ($action == 'new_product_preview') {
if (tep_not_null($HTTP_POST_VARS)) {
$pInfo = new objectInfo($HTTP_POST_VARS);
$products_name = $HTTP_POST_VARS['products_name'];
$products_title = $HTTP_POST_VARS['products_title'];
$products_description = $HTTP_POST_VARS['products_description'];
$products_head_title_tag = $HTTP_POST_VARS['products_name'];
$products_head_desc_tag = $HTTP_POST_VARS['products_name'];
$products_head_keywords_tag = $HTTP_POST_VARS['products_name'];
$products_url = $HTTP_POST_VARS['products_url'];
} else {
$product_query = tep_db_query("select p.products_id, pd.language_id, 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_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, p.products_date_available, p.products_status, p.manufacturers_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = pd.products_id and p.products_id = '" . (int)$HTTP_GET_VARS['pID'] . "'");
$product = tep_db_fetch_array($product_query);
// HTC EOC


FIND:
echo tep_draw_hidden_field('products_name', htmlspecialchars(stripslashes($products_name)));
echo tep_draw_hidden_field('products_title', htmlspecialchars(stripslashes($products_title)));
echo tep_draw_hidden_field('products_description', htmlspecialchars(stripslashes($products_description)));
echo tep_draw_hidden_field('products_url', htmlspecialchars(stripslashes($products_url)));

REPLACE WITH:
// HTC BOC
echo tep_draw_hidden_field('products_name', htmlspecialchars(stripslashes($products_name)));
echo tep_draw_hidden_field('products_title', htmlspecialchars(stripslashes($products_title)));
echo tep_draw_hidden_field('products_description', htmlspecialchars(stripslashes($products_description)));
echo tep_draw_hidden_field('products_url', htmlspecialchars(stripslashes($products_url)));
echo tep_draw_hidden_field('products_head_title_tag', htmlspecialchars(stripslashes($products_head_title_tag)));
echo tep_draw_hidden_field('products_head_desc_tag', htmlspecialchars(stripslashes($products_head_desc_tag)));
echo tep_draw_hidden_field('products_head_keywords_tag', htmlspecialchars(stripslashes($products_head_keywords_tag)));
echo tep_draw_hidden_field('products_url', htmlspecialchars(stripslashes($products_url)));
// HTC EOC

FIND:
<tr>
<td class="main" valign="top"><?php echo TEXT_PRODUCTS_DESCRIPTION; ?></td>
<td class="main"><?php echo tep_draw_separator('pixel_trans.gif', '24', '15') . '&nbsp;' . tep_draw_textarea_field('products_description', 'soft', '70', '15', $pInfo->products_description); ?></td>
</tr>

ADD AFTER:
<tr>
<td colspan="2" class="main"><hr><?php echo TEXT_PRODUCT_METTA_INFO; ?></td>
</tr>
<tr>
<td colspan="2"><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td>
</tr>
<tr>
<td class="main" valign="top"><?php echo TEXT_PRODUCTS_PAGE_TITLE; ?></td>
<td><table border="0" cellspacing="0" cellpadding="0">
<tr>
<td colspan="2" class="main"><?php echo tep_draw_textarea_field('products_head_title_tag', 'soft', '70', '5', (isset($products_head_title_tag) ? stripslashes($products_head_title_tag) : tep_get_products_head_title_tag($pInfo->products_id, $languages_id))); ?></td>
</tr>
</table></td>
</tr>
<tr>
<td colspan="2"><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td>
</tr>
<tr>
<td class="main" valign="top"> <?php echo TEXT_PRODUCTS_HEADER_DESCRIPTION; ?></td>
<td><table border="0" cellspacing="0" cellpadding="0">
<tr>
<td colspan="2" class="main"><?php echo tep_draw_textarea_field('products_head_desc_tag', 'soft', '70', '5', (isset($products_head_desc_tag) ? stripslashes($products_head_desc_tag) : tep_get_products_head_desc_tag($pInfo->products_id, $languages_id))); ?></td>
</tr>
</table></td>
</tr>
<tr>
<td colspan="2"><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td>
</tr>
<tr>
<td class="main" valign="top"> <?php echo TEXT_PRODUCTS_KEYWORDS; ?></td>
<td><table border="0" cellspacing="0" cellpadding="0">
<tr>
<td colspan="2" class="main"><?php echo tep_draw_textarea_field('products_head_keywords_tag', 'soft', '70', '5', (isset($products_head_keywords_tag) ? stripslashes($products_head_keywords_tag) : tep_get_products_head_keywords_tag($pInfo->products_id, $languages_id))); ?></td>
</tr>
</table></td>
</tr>
<tr>
<td colspan="2"><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td>
</tr>
<!-- HTC EOC //-->

the Multiple custom auction_product_info files mod below is a great idea, but it bypasses image_magic. It is a very simple fix. Just put the 2 in the name anywhere before PRODUCT_INFO in the name of the second file. PRODUCT_INFO is how image magic recognizes the "medium" thumbnail size.

This is just a tip I'd like to share.

If you have 2 different auction_product_info pages you can configure one for your website (so you can includes header.php and footer.php) and then a seperate one for ebay. You can't have headers and footers displaying in your ebay item description field.

This is just a document describing the easy steps. It's not a complete distribution.

the complete informations on this contribution since today packed in a installation-patch. no guarantee that this works in modified installations... this thing is much better than installing from a fc'd checklist...
btw. use at you own risk.

Since ebay.com has changed their website you have to replace your get_auction_info.php file with this one. Now your auctions and the buyers e-mail will show up at your store.
Thanks to flatcat and imitch1.

Version 1.1 wegen einem Fehler. Dank an Ernst, der ihn entdeckte, Dank an Micha, der bei der Entfernung half.
Es ist ausreichend, die get_auction_info.php auszutauschen. Zum Download ist aber das ganze Contrib
bereitgestellt.

Das Contrib von Joseph Smith (vielen Dank an ihn fuer die Entwicklung) wurde an die deutsche Sprache angepasst (im Admin-Bereich) und um einige kleine Features erweitert (Anzeige des Artikels bei Ebay; weiter Einkaufen nach Checkout mit Erhalt Warenkorb u. a.). CURL ist notwendig!!!
Die README ist original in Englisch, erweitert um die eingebrachten Features. Es ist auch ein Skript dabei, mit welchem das Parsen von Ebay getestet werden kann. Dieses Contrib benötigt keine Tools bzw. Erweiterungen von Ebay oder Dritte, welche Geld kosten.
Fragen bitte in das Forum!
http://forums.oscommerce.de/index.php?showtopic=27976
Jörg

This is what I decided to do. Instead of having the updated files (below) included in the zip file I have decided to add it to the install.txt. This works for those of you that already have these files modified.

Found error in auction_listings_admin.php
for the "viewed: 5 times"

Fixed

Oops I forgot a file...Me Bad

Fixed it so someone browsing the regular store can not checkout an auction item.

Four new files added:
products_new.php
product_info.php
/includes/modules/new_products.php
/includes/boxes/whats_new.php

Fixed it so someone browsing the regular store can not checkout an auction item.

Thre new files added:
products_new.php
product_info.php
/includes/modules/new_products.php

Fixed file links

This is a full blown Auction Manager contrib that easily allows you to upload your auction listings from ebay
and manage your ebay auctions.

IMPORTANT:
----------
It is recomended to install the Purchase Without Account contrib to use with this one.
You are not required to but it is recomended. It can be found here:

http://www.oscommerce.com/community/contributions,355

Also, this contrib REQUIRES cURL. You must have the cURL module for php installed.
You can check by looking at the Server Info from the admin. You will see it listed there.