uninstall SQL patch that's messed up my site

[limelites]

Hey, BUNYIP, you're a genius and I love you!! If I could buy you a drink right now I promise it'd be a bottle of the finest.

Thank you so much for helping me there, I was sure it was s disaster...

I need to be careful what mods I install!!

THANK YOU!!

[bunyip]

I need to be careful what mods I install!!

You should always install mods on a test site first - NEVER on a live site, and ALWAYS after making a backup...

[limelites]

I know, I've been working on this site (my first website btw) for a week now and I don't have a backup yet.

It's almost ready to start uploading our full range of products so tonight I will FTP the whole site to my HDD.

Then, tomorrow I'll create a test site in a sub folder for future testing of mods. GREAT IDEA THAT!

Again, thank you for your help, I'm just glad to have the site back the way I built it as it had taken a lot of time and effort.

[limelites]

I wonder now if the reason that mod was so destructive was that it overwrote my tpl_modules_attributes.php file which I'd heavily edited.

[bunyip]

don't forget - apart from the files, a test site also means a different database (or a set of database tables with different prefix in the same database if your hosting allows you only one database)

[bunyip]

I wonder now if the reason that mod was so destructive was that it overwrote my tpl_modules_attributes.php file which I'd heavily edited.

quite likely

[limelites]

I'm allowed up to 5 databases on the GoDaddy account I'm with, so basically it'd be a complete new install in a different folder.

I always was a daredevil, tempted to try again but this time just edit the new lines into the tpl_modules_attributes.php

Do you think I'd just need to copy in these 70 lines of code into the top of my own file?


<?php
/**
* Module Template
*
* Template used to render attribute display/input fields
*
* @package templateSystem
* @copyright Copyright 2003-2005 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: tpl_modules_attributes.php 3208 2006-03-19 16:48:57Z birdbrain $
*/
?>
<div id="productAttributes">
<?php if ($zv_display_select_option > 0) { ?>
<?php
$products_attributes = $db->Execute("select count(distinct products_options_id) as total from " . TABLE_PRODUCTS_OPTIONS . " popt, " . TABLE_PRODUCTS_ATTRIBUTES . " patrib where patrib.products_id='" . (int)$_GET['products_id'] . "' and patrib.options_id = popt.products_options_id and popt.language_id = ". (int)$_SESSION['languages_id'] ."");


if ($products_attributes->fields['total'] > 1) {

$products_id=(preg_match("/^\d{1,10}(\{\d{1,10}\}\d{1,10})*$/",$_GET['products_id']) ? $_GET['products_id'] : (int)$_GET['products_id']);
require(DIR_WS_CLASSES . 'pad_' . PRODINFO_ATTRIBUTE_PLUGIN_MULTI . '.php');
$class = 'pad_' . PRODINFO_ATTRIBUTE_PLUGIN_MULTI;

$pad = new $class($products_id);

echo $pad->draw();

}
elseif ($products_attributes->fields['total'] > 0) {

$products_id=(preg_match("/^\d{1,10}(\{\d{1,10}\}\d{1,10})*$/",$_GET['products_id']) ? $_GET['products_id'] : (int)$_GET['products_id']);
require(DIR_WS_CLASSES . 'pad_' . PRODINFO_ATTRIBUTE_PLUGIN_SINGLE . '.php');
$class = 'pad_' . PRODINFO_ATTRIBUTE_PLUGIN_SINGLE;

$pad = new $class($products_id);

echo $pad->draw();
}


?>

<?php
if ($options_attributes_image[$i] != '') {
?>
<?php echo $options_attributes_image[$i]; ?>
<?php
}
?>
<br class="clearBoth" />
<?php
}
?>


<?php
if ($show_onetime_charges_description == 'true') {
?>
<div class="wrapperAttribsOneTime"><?php echo TEXT_ONETIME_CHARGE_SYMBOL . TEXT_ONETIME_CHARGE_DESCRIPTION; ?></div>
<?php } ?>


<?php
if ($show_attributes_qty_prices_description == 'true') {
?>
<div class="wrapperAttribsQtyPrices"><?php echo zen_image(DIR_WS_TEMPLATE_ICONS . 'icon_status_green.gif', TEXT_ATTRIBUTES_QTY_PRICE_HELP_LINK, 10, 10) . '&nbsp;' . '<a href="javascriptopupWindowPrice(\'' . zen_href_link(FILENAME_POPUP_ATTRIBUTES_QTY_PRICES, 'products_id=' . $_GET['products_id'] . '&products_tax_class_id=' . $products_tax_class_id) . '\')">' . TEXT_ATTRIBUTES_QTY_PRICE_HELP_LINK . '</a>'; ?></div>
<?php } ?>
</div>

[bunyip]

no, I don't think that would work. Pay attention to the div classes that are being used and incorporate them into your stylesheet - you should get what you want that way.

[limelites]

Never mind, that was bonkers thing to say..... was thinking it was a different file, this one's not so different from my existing one

[limelites]

It's getting too late for me.. midnight here, so best hit the hay and tackle Zen another day :-)


Thanks so much though for all your help, I'm sure I'll need you again sometime lol...