HELP - Online Gift Card v1.0

baavandus · November 28, 2007

Hi,

I'm new at php/ sql and oscommerce, so forgive me if my problem is obvious to the expert :blush:

Have installed several mods - among these is discount coupons, that works great!!!

I do need a Gift Card function too, so I thought I would install Online gift card mod as well....... had to manually update the files because of the other mods....

BUT - After the update, I can no longer see my admin page? Only the links on the left.... no main "frame" is visible???

I'm not exactly sure what to look for, but the files affected in Online gift card mod are (list from install instruction):

admin/categories.php

admin/includes/filenames.php

admin/includes/database_tables.php

admin/includes/boxes/catalog.php (Called categories in install instruction text?)

admin/includes/languages/english.php

admin/includes/languages/english/categories.php

checkout_confirmation.php

checkout_process.php

checkout_shipping.php

checkout_success.php

account.php

shopping_cart.php

includes/database_tables.php

includes/filenames.php

includes/classes/shopping_cart.php

includes/classes/order.php

includes/functions/general.php

includes/languages/english/account.php

includes/languages/english/checkout_confirmation.php

includes/languages/english/checkout_success.php

includes/languages/english/shopping_cart.php

Which file would be the troublemaker? And what should I look for?

Thanks a million!!!

baavandus · November 28, 2007

BUT - After the update, I can no longer see my admin page? Only the links on the left.... no main "frame" is visible???
admin/includes/boxes/catalog.php (Called categories in install instruction text?)

Fixed! so far... I reversed the update of this file... seem to work in admin.

BUT now - when I'm testing gift card - I can add the gift card, but gets an error when pushing "add to cart" or just want to see the cart! So I'm guessing that there is a problem with the shpping cart :blink:?

My catalog/shopping_cart.php file looks like this:

<?php

/*

$Id: shopping_cart.php,v 1.73 2003/06/09 23:03:56 hpdl Exp $

osCommerce, Open Source E-Commerce Solutions

http://www.oscommerce.com

Released under the GNU General Public License

*/

require("includes/application_top.php");

require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_SHOPPING_CART);

* gift card modification */

$error = false;

if (isset($HTTP_GET_VARS['action']) && ($HTTP_GET_VARS['action'] == 'gift_card')) {

$gift_card_check = tep_db_query("select * from `".TABLE_GIFT_CARDS."` where gift_cards_code='".$HTTP_POST_VARS['gift_card_code']."' and gift_cards_enabled='1'");

if (tep_db_num_rows($gift_card_check)>0) { // found a record

$gift_card_row = tep_db_fetch_array($gift_card_check);

$_SESSION['gift_card'] = $gift_card_row['gift_cards_code'];

//tep_session_register('gift_card');

$messageStack->add('shopping_cart_success', SUCCESS_GIFT_CARD.'$ '.$gift_card_row['gift_cards_amount_remaining'], 'success');

} else { // error, bad gift card code

// spit out error to the user, so they know what is going on

$error = true;

}

} else if (tep_session_is_registered('gift_card')) {

$gift_card_check = tep_db_query("select * from `".TABLE_GIFT_CARDS."` where gift_cards_code='".$_SESSION['gift_card']."' and gift_cards_enabled='1'");

if (tep_db_num_rows($gift_card_check)>0) { // found a record

$gift_card_row = tep_db_fetch_array($gift_card_check);

//tep_session_register('gift_card');

$messageStack->add('shopping_cart_success', SUCCESS_GIFT_CARD.'$ '.$gift_card_row['gift_cards_amount_remaining'], 'success');

}

if ($error) {

$messageStack->add('shopping_cart', GIFT_CARD_ERROR);

}

/* gift card modification */

$breadcrumb->add(NAVBAR_TITLE, tep_href_link(FILENAME_SHOPPING_CART));

?>

<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">

<head>

</head>

<?php require(DIR_WS_INCLUDES . 'header.php'); ?>

<tr>

<td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="2">

<?php require(DIR_WS_INCLUDES . 'column_left.php'); ?>

</table></td>

<tr>

<tr>

</tr>

</table></td>

</tr>

<tr>

</tr>

<?php

/* gift card modification */

if ($messageStack->size('shopping_cart') > 0) {

?>

<tr>

<td><?php echo $messageStack->output('shopping_cart'); ?></td>

</tr>

<tr>

</tr>

<?php

}

if ($messageStack->size('shopping_cart_success') > 0) {

?>

<tr>

<td><?php echo $messageStack->output('shopping_cart_success'); ?></td>

</tr>

<tr>

</tr>

<?php

}

/* end of gift card modification */

?>

<?php

if ($cart->count_contents() > 0) {

?>

<tr>

<td>

<?php

$info_box_contents = array();

$info_box_contents[0][] = array('align' => 'center',

'params' => 'class="productListing-heading"',

'text' => TABLE_HEADING_REMOVE);

$info_box_contents[0][] = array('params' => 'class="productListing-heading"',

'text' => TABLE_HEADING_PRODUCTS);

$info_box_contents[0][] = array('align' => 'center',

'params' => 'class="productListing-heading"',

'text' => TABLE_HEADING_QUANTITY);

$info_box_contents[0][] = array('align' => 'right',

'params' => 'class="productListing-heading"',

'text' => TABLE_HEADING_TOTAL);

$any_out_of_stock = 0;

$products = $cart->get_products();

for ($i=0, $n=sizeof($products); $i<$n; $i++) {

// Push all attributes information in an array

if (isset($products[$i]['attributes']) && is_array($products[$i]['attributes'])) {

while (list($option, $value) = each($products[$i]['attributes'])) {

echo tep_draw_hidden_field('id[' . $products[$i]['id'] . '][' . $option . ']', $value);

$attributes = tep_db_query("select popt.products_options_name, poval.products_options_values_name, pa.options_values_price, pa.price_prefix

from " . TABLE_PRODUCTS_OPTIONS . " popt, " . TABLE_PRODUCTS_OPTIONS_VALUES . " poval, " . TABLE_PRODUCTS_ATTRIBUTES . " pa

where pa.products_id = '" . (int)$products[$i]['id'] . "'

and pa.options_id = '" . (int)$option . "'

and pa.options_id = popt.products_options_id

and pa.options_values_id = '" . (int)$value . "'

and pa.options_values_id = poval.products_options_values_id

and popt.language_id = '" . (int)$languages_id . "'

and poval.language_id = '" . (int)$languages_id . "'");

$attributes_values = tep_db_fetch_array($attributes);

$products[$i][$option]['products_options_name'] = $attributes_values['products_options_name'];

$products[$i][$option]['options_values_id'] = $value;

$products[$i][$option]['products_options_values_name'] = $attributes_values['products_options_values_name'];

$products[$i][$option]['options_values_price'] = $attributes_values['options_values_price'];

$products[$i][$option]['price_prefix'] = $attributes_values['price_prefix'];

}

for ($i=0, $n=sizeof($products); $i<$n; $i++) {

if (($i/2) == floor($i/2)) {

$info_box_contents[] = array('params' => 'class="productListing-even"');

} else {

$info_box_contents[] = array('params' => 'class="productListing-odd"');

}

$cur_row = sizeof($info_box_contents) - 1;

$info_box_contents[$cur_row][] = array('align' => 'center',

'params' => 'class="productListing-data" valign="top"',

'text' => tep_draw_checkbox_field('cart_delete[]', $products[$i]['id']));

$products_name = '<table border="0" cellspacing="2" cellpadding="2">' .

' <tr>' .

' <td class="productListing-data" align="center"><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $products[$i]['id']) . '">' . tep_image(DIR_WS_IMAGES . $products[$i]['image'], $products[$i]['name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '</a></td>' .

' <td class="productListing-data" valign="top"><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $products[$i]['id']) . '"><b>' . $products[$i]['name'] . '</b></a>';

if (STOCK_CHECK == 'true') {

$stock_check = tep_check_stock($products[$i]['id'], $products[$i]['quantity']);

if (tep_not_null($stock_check)) {

$any_out_of_stock = 1;

$products_name .= $stock_check;

}

if (isset($products[$i]['attributes']) && is_array($products[$i]['attributes'])) {

reset($products[$i]['attributes']);

while (list($option, $value) = each($products[$i]['attributes'])) {

$products_name .= '<br><small><i> - ' . $products[$i][$option]['products_options_name'] . ' ' . $products[$i][$option]['products_options_values_name'] . '</i></small>';

}

$products_name .= ' </td>' .

' </tr>' .

'</table>';

$info_box_contents[$cur_row][] = array('params' => 'class="productListing-data"',

'text' => $products_name);

$info_box_contents[$cur_row][] = array('align' => 'center',

'params' => 'class="productListing-data" valign="top"',

'text' => tep_draw_input_field('cart_quantity[]', $products[$i]['quantity'], 'size="4"') . tep_draw_hidden_field('products_id[]', $products[$i]['id']));

$info_box_contents[$cur_row][] = array('align' => 'right',

'params' => 'class="productListing-data" valign="top"',

'text' => '<b>' . $currencies->display_price($products[$i]['final_price'], tep_get_tax_rate($products[$i]['tax_class_id']), $products[$i]['quantity']) . '</b>');

}

new productListingBox($info_box_contents);

?>

</td>

</tr>

<tr>

</tr>

<tr>

<td align="right" class="main"><b><?php echo SUB_TITLE_SUB_TOTAL; ?> <?php echo $currencies->format($cart->show_total()); ?></b></td>

</tr>

<?php

if ($any_out_of_stock == 1) {

if (STOCK_ALLOW_CHECKOUT == 'true') {

?>

<tr>

</tr>

<?php

} else {

?>

<tr>

</tr>

<?php

}

?>

<tr>

</tr>

<tr>

<tr>

<?php

$back = sizeof($navigation->path)-2;

if (isset($navigation->path[$back])) {

?>

<td class="main"><?php echo '<a href="' . tep_href_link($navigation->path[$back]['page'], tep_array_to_string($navigation->path[$back]['get'], array('action')), $navigation->path[$back]['mode']) . '">' . tep_image_button('button_continue_shopping.gif', IMAGE_BUTTON_CONTINUE_SHOPPING) . '</a>'; ?></td>

<?php

}

?>

<td align="right" class="main"><?php echo '<a href="' . tep_href_link(FILENAME_CHECKOUT_SHIPPING, '', 'SSL') . '">' . tep_image_button('button_checkout.gif', IMAGE_BUTTON_CHECKOUT) . '</a>'; ?></td>

</tr>

</table></td>

</tr>

</table></td>

</tr>

<?php

} else {

?>

<tr>

<td align="center" class="main"><?php new infoBox(array(array('text' => TEXT_CART_EMPTY))); ?></td>

</tr>

<tr>

</tr>

<tr>

<tr>

<td align="right" class="main"><?php echo '<a href="' . tep_href_link(FILENAME_DEFAULT) . '">' . tep_image_button('button_continue.gif', IMAGE_BUTTON_CONTINUE) . '</a>'; ?></td>

</tr>

</table></td>

</tr>

</table></td>

</tr>

<?php

}

?>

</table></form>

<tr>

</tr>

<tr>

<td align="right"><?php echo tep_draw_form('gift_card_form', tep_href_link(FILENAME_SHOPPING_CART, 'action=gift_card', 'SSL'), 'post'); ?>Gift Card Code: <input type="text" name="gift_card_code"><br /><?php echo dyton_draw_submit('Update Price', 'class="page_buttons"'); ?></form><br /><font color="#FF0000">** Gift card discounts will be applied after a payment method has been chosen.</font></td>

</tr>

</table>

</td>

<td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="2">

<?php require(DIR_WS_INCLUDES . 'column_right.php'); ?>

</table></td>

</tr>

</table>

<?php require(DIR_WS_INCLUDES . 'footer.php'); ?>

<br>

</body>

</html>

<?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>

AND my catalog/includes/languages/english/shopping_cart.php like this:

<?php

/*

$Id: shopping_cart.php,v 1.13 2002/04/05 20:24:02 project3000 Exp $

osCommerce, Open Source E-Commerce Solutions

http://www.oscommerce.com

Released under the GNU General Public License

*/

define('NAVBAR_TITLE', 'Cart Contents');

define('HEADING_TITLE', 'What\'s In My Cart?');

define('TABLE_HEADING_REMOVE', 'Remove');

define('TABLE_HEADING_QUANTITY', 'Qty.');

define('TABLE_HEADING_MODEL', 'Model');

define('TABLE_HEADING_PRODUCTS', 'Product(s)');

define('TABLE_HEADING_TOTAL', 'Total');

define('TEXT_CART_EMPTY', 'Your Shopping Cart is empty!');

define('SUB_TITLE_SUB_TOTAL', 'Sub-Total:');

define('SUB_TITLE_TOTAL', 'Total:');

define('OUT_OF_STOCK_CANT_CHECKOUT', 'Products marked with ' . STOCK_MARK_PRODUCT_OUT_OF_STOCK . ' dont exist in desired quantity in our stock.<br>Please alter the quantity of products marked with (' . STOCK_MARK_PRODUCT_OUT_OF_STOCK . '), Thank you');

define('OUT_OF_STOCK_CAN_CHECKOUT', 'Products marked with ' . STOCK_MARK_PRODUCT_OUT_OF_STOCK . ' dont exist in desired quantity in our stock.<br>You can buy them anyway and check the quantity we have in stock for immediate deliver in the checkout process.');

/* gift card modification */

define('GIFT_CARD_ERROR', 'The gift card code you entered does not exist or the amount remaining is $0.00.');

define('SUCCESS_GIFT_CARD', 'Gift card amount to be applied at checkout: ');

/* end of gift card modification */

?>

Hope someone can help :rolleyes:

baavandus · November 28, 2007

After the above problem I have this:

I can checkout fine.

I can also use the gift card, everything is fine all amount are correct through the order process. (Should add Gift Card as payment option?).

UNTILL the order confirmaation is mailed and stored in the system - then the amount of gift card used is equal to the amount that is left (makes sense??). So a calculation is wrong somewhere.... where should I look?

:blush:

HELP - Online Gift Card v1.0

Recommended Posts

baavandus

Link to comment

Share on other sites

baavandus

Link to comment

Share on other sites

baavandus

Link to comment

Share on other sites

Join the conversation

Browse

Activity