Jump to content

Jerfersor

Members
  • Content count

    23
  • Joined

  • Last visited

  1. Jerfersor

    Official PayPal IPN Support Thread

    ok I've been getting 6 emails everytime an order gets placed with the "PayPal IPN Invalid Process" i've read and reintalled the package... I have wt pro installed so i modded the necessary file like the help file said to... \That did not solve my problem... I also noticed I have the "Package Tracking with Email Notification" which did mod my checkout_process.php file here is what was moded: ***Step 11*** catalog/checkout_process.php Find this: tep_mail($order->customer['firstname'] . ' ' . $order->customer['lastname'], $order->customer['email_address'], EMAIL_TEXT_SUBJECT, $email_order, STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS); And replace with this: <!-- Tracking contribution begin --> tep_mail($order->customer['firstname'] . ' ' . $order->customer['lastname'], $order->customer['email_address'], EMAIL_TEXT_SUBJECT_1 . ' ' . $insert_id . ' ' .EMAIL_TEXT_SUBJECT_2 , $email_order, STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS); <!-- Tracking contribution end --> Find this: tep_mail('', SEND_EXTRA_ORDER_EMAILS_TO, EMAIL_TEXT_SUBJECT, $email_order, STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS); And replace with this: <!-- Tracking contribution begin --> tep_mail('', SEND_EXTRA_ORDER_EMAILS_TO, EMAIL_TEXT_SUBJECT_1 . ' ' . $insert_id . ' ' .EMAIL_TEXT_SUBJECT_2, $email_order, STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS); <!-- Tracking contribution end --> I don't know if that is what is causing the problem... I've read all 53 pages trying to find what could be causing my problem and I've tried everything that other people said. Would anyone be able to give me a hint? please. I don't know what i should change on my paypal ipn file :S Thanks!
  2. Jerfersor

    Shipping Estimator Small Form error

    stupid me darn... was using: name="country" instead of: name="country_id" anyways it's fixed now :) thanks!!!
  3. Hi all ! I had the shipping estimator working, but I only ship to the us, (other countries would have to call in) so I made USA the default, unchangeable to calculate the shipping. so I added to the code if(CARTSHIP_SHOWCDD == 'true'){ $ShipTxt.='<tr><td class="main"><b>USA</b>'. tep_draw_hidden_field('country','223'); } wich brings me back with <tr> <td class="main"><b>USA</b><input type="hidden" name="country" value="223"> now when i try to calculate the browser seems to not send the country in the form and so it doesn't calculate anything :( anyone could give an Idea? I don't want to put back drop down list with only one country to choose as it looks stupid... here is the code it comes back with as of now... maybe i have some html issues: <tr> <td class="boxText"><form name="estimator" action="http://www.brazilianhotstuff.com/shopping_cart.php" method="post"><input type="hidden" name="sid" value=""> <table> <tr> <td colspan="3" class="main"> <b>Product(s) Qnt :</b> 1</td> </tr> <tr> <td class="main"><b>USA</b><input type="hidden" name="country" value="223"> <b>ZIP Code:</b> <input type="text" name="zip_code" value="" size="5"></td> <td style="padding-right:8" align="right"><a href="_" onClick="return shipincart_submit('');"><img src="includes/languages/english/images/buttons/button_shipping_estimator.gif" border="0" alt="Update Cart" title="Update Cart"> </a></td> </tr> <tr> <td class="main"><b>Carrier</b></td> <td class="main" align="left"><b>Delivery Methods</b></td> <td class="main" align="right"><b>Rates</b></td> </tr> <tr> <td colspan="3" class="main"><img src="images/pixel_black.gif" width="100%" height="1" border="0" alt=""></td> </tr> </table> </form></td> </tr> thanks for the help!
  4. Jerfersor

    checkout_process.php problem at last step

    great man!!! you're a life saver!!! i looked at the tags all day long yesterday but it seems like that one passed right trhu me :S Thanks for the fix!
  5. Hi all! Ok everything seemed to be working fine after qt pro contrib was installed... now I made some alterations ( not let people checkout when there is not enought in stock) I started getting this error at the last step of checkout :/ Could someoneone help me out i tried to find an answer to my question for 5 hrs and nothing. :( the line on the checkout_process.php (228) is this: //++++ QT Pro: Begin Changed code } //**si** 14-11-05 fix missing att list else { if ( is_array($order->products[$i]['attributes']) ) { $products_stock_attributes_array = array(); foreach ($order->products[$i]['attributes'] as $attribute) { $products_stock_attributes_array[] = $attribute['option_id'] . "-" . $attribute['value_id']; } the entire file contains: <?php /* $Id: checkout_process.php,v 1.128 2003/05/28 18:00:29 hpdl Exp $ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2003 osCommerce Released under the GNU General Public License */ include('includes/application_top.php'); // if the customer is not logged on, redirect them to the login page if (!tep_session_is_registered('customer_id')) { $navigation->set_snapshot(array('mode' => 'SSL', 'page' => FILENAME_CHECKOUT_PAYMENT)); tep_redirect(tep_href_link(FILENAME_LOGIN, '', 'SSL')); } if (!tep_session_is_registered('sendto')) { tep_redirect(tep_href_link(FILENAME_CHECKOUT_PAYMENT, '', 'SSL')); } if ( (tep_not_null(MODULE_PAYMENT_INSTALLED)) && (!tep_session_is_registered('payment')) ) { tep_redirect(tep_href_link(FILENAME_CHECKOUT_PAYMENT, '', 'SSL')); } // avoid hack attempts during the checkout procedure by checking the internal cartID if (isset($cart->cartID) && tep_session_is_registered('cartID')) { if ($cart->cartID != $cartID) { tep_redirect(tep_href_link(FILENAME_CHECKOUT_SHIPPING, '', 'SSL')); } } include(DIR_WS_LANGUAGES . $language . '/' . FILENAME_CHECKOUT_PROCESS); // load selected payment module require(DIR_WS_CLASSES . 'payment.php'); $payment_modules = new payment($payment); // load the selected shipping module require(DIR_WS_CLASSES . 'shipping.php'); $shipping_modules = new shipping($shipping); require(DIR_WS_CLASSES . 'order.php'); $order = new order; // load the before_process function from the payment modules $payment_modules->before_process(); require(DIR_WS_CLASSES . 'order_total.php'); $order_total_modules = new order_total; $order_totals = $order_total_modules->process(); $sql_data_array = array('customers_id' => $customer_id, 'customers_name' => $order->customer['firstname'] . ' ' . $order->customer['lastname'], 'customers_company' => $order->customer['company'], 'customers_street_address' => $order->customer['street_address'], 'customers_suburb' => $order->customer['suburb'], 'customers_city' => $order->customer['city'], 'customers_postcode' => $order->customer['postcode'], 'customers_state' => $order->customer['state'], 'customers_country' => $order->customer['country']['title'], 'customers_telephone' => $order->customer['telephone'], 'customers_email_address' => $order->customer['email_address'], 'customers_address_format_id' => $order->customer['format_id'], 'delivery_name' => $order->delivery['firstname'] . ' ' . $order->delivery['lastname'], 'delivery_company' => $order->delivery['company'], 'delivery_street_address' => $order->delivery['street_address'], 'delivery_suburb' => $order->delivery['suburb'], 'delivery_city' => $order->delivery['city'], 'delivery_postcode' => $order->delivery['postcode'], 'delivery_state' => $order->delivery['state'], 'delivery_country' => $order->delivery['country']['title'], 'delivery_address_format_id' => $order->delivery['format_id'], 'billing_name' => $order->billing['firstname'] . ' ' . $order->billing['lastname'], 'billing_company' => $order->billing['company'], 'billing_street_address' => $order->billing['street_address'], 'billing_suburb' => $order->billing['suburb'], 'billing_city' => $order->billing['city'], 'billing_postcode' => $order->billing['postcode'], 'billing_state' => $order->billing['state'], 'billing_country' => $order->billing['country']['title'], 'billing_address_format_id' => $order->billing['format_id'], 'payment_method' => $order->info['payment_method'], 'cc_type' => $order->info['cc_type'], 'cc_owner' => $order->info['cc_owner'], 'cc_number' => $order->info['cc_number'], 'cc_expires' => $order->info['cc_expires'], 'date_purchased' => 'now()', 'orders_status' => $order->info['order_status'], 'currency' => $order->info['currency'], 'currency_value' => $order->info['currency_value']); tep_db_perform(TABLE_ORDERS, $sql_data_array); $insert_id = tep_db_insert_id(); for ($i=0, $n=sizeof($order_totals); $i<$n; $i++) { $sql_data_array = array('orders_id' => $insert_id, 'title' => $order_totals[$i]['title'], 'text' => $order_totals[$i]['text'], 'value' => $order_totals[$i]['value'], 'class' => $order_totals[$i]['code'], 'sort_order' => $order_totals[$i]['sort_order']); tep_db_perform(TABLE_ORDERS_TOTAL, $sql_data_array); } $customer_notification = (SEND_EMAILS == 'true') ? '1' : '0'; $sql_data_array = array('orders_id' => $insert_id, 'orders_status_id' => $order->info['order_status'], 'date_added' => 'now()', 'customer_notified' => $customer_notification, 'comments' => $order->info['comments']); tep_db_perform(TABLE_ORDERS_STATUS_HISTORY, $sql_data_array); // initialized for the email confirmation $products_ordered = ''; $subtotal = 0; $total_tax = 0; for ($i=0, $n=sizeof($order->products); $i<$n; $i++) { // Stock Update - Joao Correia //++++ QT Pro: Begin Changed code $products_stock_attributes=null; if (STOCK_LIMITED == 'true') { $products_attributes = $order->products[$i]['attributes']; // if (DOWNLOAD_ENABLED == 'true') { //++++ QT Pro: End Changed Code // if (STOCK_LIMITED == 'true') { // if (DOWNLOAD_ENABLED == 'true') { $stock_query_raw = "SELECT products_quantity, pad.products_attributes_filename FROM " . TABLE_PRODUCTS . " p LEFT JOIN " . TABLE_PRODUCTS_ATTRIBUTES . " pa ON p.products_id=pa.products_id LEFT JOIN " . TABLE_PRODUCTS_ATTRIBUTES_DOWNLOAD . " pad ON pa.products_attributes_id=pad.products_attributes_id WHERE p.products_id = '" . tep_get_prid($order->products[$i]['id']) . "'"; // Will work with only one option for downloadable products // otherwise, we have to build the query dynamically with a loop //++++ QT Pro: Begin Changed code // $products_attributes = $order->products[$i]['attributes']; //++++ QT Pro: End Changed Code // $products_attributes = $order->products[$i]['attributes']; if (is_array($products_attributes)) { $stock_query_raw .= " AND pa.options_id = '" . $products_attributes[0]['option_id'] . "' AND pa.options_values_id = '" . $products_attributes[0]['value_id'] . "'"; } $stock_query = tep_db_query($stock_query_raw); } else { $stock_query = tep_db_query("select products_quantity from " . TABLE_PRODUCTS . " where products_id = '" . tep_get_prid($order->products[$i]['id']) . "'"); } if (tep_db_num_rows($stock_query) > 0) { $stock_values = tep_db_fetch_array($stock_query); //++++ QT Pro: Begin Changed code $actual_stock_bought = $order->products[$i]['qty']; $download_selected = false; if ((DOWNLOAD_ENABLED == 'true') && isset($stock_values['products_attributes_filename']) && tep_not_null($stock_values['products_attributes_filename'])) { $download_selected = true; $products_stock_attributes='$$DOWNLOAD$$'; } // If not downloadable and attributes present, adjust attribute stock if (!$download_selected && is_array($products_attributes)) { $all_nonstocked = true; $products_stock_attributes_array = array(); foreach ($products_attributes as $attribute) { //**si** 14-11-05 fix missing att list // if ($attribute['track_stock'] == 1) { // $products_stock_attributes_array[] = $attribute['option_id'] . "-" . $attribute['value_id']; $products_stock_attributes_array[] = $attribute['option_id'] . "-" . $attribute['value_id']; if ($attribute['track_stock'] == 1) { //**si** 14-11-05 end $all_nonstocked = false; } } if ($all_nonstocked) { $actual_stock_bought = $order->products[$i]['qty']; //**si** 14-11-05 fix missing att list asort($products_stock_attributes_array, SORT_NUMERIC); $products_stock_attributes = implode(",", $products_stock_attributes_array); //**si** 14-11-05 end } else { asort($products_stock_attributes_array, SORT_NUMERIC); $products_stock_attributes = implode(",", $products_stock_attributes_array); $attributes_stock_query = tep_db_query("select products_stock_quantity from " . TABLE_PRODUCTS_STOCK . " where products_stock_attributes = '$products_stock_attributes' AND products_id = '" . tep_get_prid($order->products[$i]['id']) . "'"); if (tep_db_num_rows($attributes_stock_query) > 0) { $attributes_stock_values = tep_db_fetch_array($attributes_stock_query); $attributes_stock_left = $attributes_stock_values['products_stock_quantity'] - $order->products[$i]['qty']; tep_db_query("update " . TABLE_PRODUCTS_STOCK . " set products_stock_quantity = '" . $attributes_stock_left . "' where products_stock_attributes = '$products_stock_attributes' AND products_id = '" . tep_get_prid($order->products[$i]['id']) . "'"); $actual_stock_bought = ($attributes_stock_left < 1) ? $attributes_stock_values['products_stock_quantity'] : $order->products[$i]['qty']; } else { $attributes_stock_left = 0 - $order->products[$i]['qty']; tep_db_query("insert into " . TABLE_PRODUCTS_STOCK . " (products_id, products_stock_attributes, products_stock_quantity) values ('" . tep_get_prid($order->products[$i]['id']) . "', '" . $products_stock_attributes . "', '" . $attributes_stock_left . "')"); $actual_stock_bought = 0; } } } // $stock_query = tep_db_query("select products_quantity from " . TABLE_PRODUCTS . " where products_id = '" . tep_get_prid($order->products[$i]['id']) . "'"); // } // if (tep_db_num_rows($stock_query) > 0) { // $stock_values = tep_db_fetch_array($stock_query); // do not decrement quantities if products_attributes_filename exists if (!$download_selected) { $stock_left = $stock_values['products_quantity'] - $actual_stock_bought; tep_db_query("UPDATE " . TABLE_PRODUCTS . " SET products_quantity = products_quantity - '" . $actual_stock_bought . "' WHERE products_id = '" . tep_get_prid($order->products[$i]['id']) . "'"); //++++ QT Pro: End Changed Code //// do not decrement quantities if products_attributes_filename exists // if ((DOWNLOAD_ENABLED != 'true') || (!$stock_values['products_attributes_filename'])) { // $stock_left = $stock_values['products_quantity'] - $order->products[$i]['qty']; // } else { // $stock_left = $stock_values['products_quantity']; // } // tep_db_query("update " . TABLE_PRODUCTS . " set products_quantity = '" . $stock_left . "' where products_id = '" . tep_get_prid($order->products[$i]['id']) . "'"); if ( ($stock_left < 1) && (STOCK_ALLOW_CHECKOUT == 'false') ) { tep_db_query("update " . TABLE_PRODUCTS . " set products_status = '0' where products_id = '" . tep_get_prid($order->products[$i]['id']) . "'"); } } } //++++ QT Pro: Begin Changed code } //**si** 14-11-05 fix missing att list else { if ( is_array($order->products[$i]['attributes']) ) { $products_stock_attributes_array = array(); foreach ($order->products[$i]['attributes'] as $attribute) { $products_stock_attributes_array[] = $attribute['option_id'] . "-" . $attribute['value_id']; } asort($products_stock_attributes_array, SORT_NUMERIC); $products_stock_attributes = implode(",", $products_stock_attributes_array); } } //**si** 14-11-05 end //++++ QT Pro: End Changed Code // Update products_ordered (for bestsellers list) tep_db_query("update " . TABLE_PRODUCTS . " set products_ordered = products_ordered + " . sprintf('%d', $order->products[$i]['qty']) . " where products_id = '" . tep_get_prid($order->products[$i]['id']) . "'"); //++++ QT Pro: Begin Changed code if (!isset($products_stock_attributes)) $products_stock_attributes=null; $sql_data_array = array('orders_id' => $insert_id, 'products_id' => tep_get_prid($order->products[$i]['id']), 'products_model' => $order->products[$i]['model'], 'products_name' => $order->products[$i]['name'], 'products_price' => $order->products[$i]['price'], 'final_price' => $order->products[$i]['final_price'], 'products_tax' => $order->products[$i]['tax'], 'products_quantity' => $order->products[$i]['qty'], 'products_stock_attributes' => $products_stock_attributes); //++++ QT Pro: End Changed Code // $sql_data_array = array('orders_id' => $insert_id, // 'products_id' => tep_get_prid($order->products[$i]['id']), // 'products_model' => $order->products[$i]['model'], // 'products_name' => $order->products[$i]['name'], // 'products_price' => $order->products[$i]['price'], // 'final_price' => $order->products[$i]['final_price'], // 'products_tax' => $order->products[$i]['tax'], // 'products_quantity' => $order->products[$i]['qty']); tep_db_perform(TABLE_ORDERS_PRODUCTS, $sql_data_array); $order_products_id = tep_db_insert_id(); //------insert customer choosen option to order-------- $attributes_exist = '0'; $products_ordered_attributes = ''; if (isset($order->products[$i]['attributes'])) { $attributes_exist = '1'; for ($j=0, $n2=sizeof($order->products[$i]['attributes']); $j<$n2; $j++) { if (DOWNLOAD_ENABLED == 'true') { $attributes_query = "select popt.products_options_name, poval.products_options_values_name, pa.options_values_price, pa.price_prefix, pad.products_attributes_maxdays, pad.products_attributes_maxcount , pad.products_attributes_filename from " . TABLE_PRODUCTS_OPTIONS . " popt, " . TABLE_PRODUCTS_OPTIONS_VALUES . " poval, " . TABLE_PRODUCTS_ATTRIBUTES . " pa left join " . TABLE_PRODUCTS_ATTRIBUTES_DOWNLOAD . " pad on pa.products_attributes_id=pad.products_attributes_id where pa.products_id = '" . $order->products[$i]['id'] . "' and pa.options_id = '" . $order->products[$i]['attributes'][$j]['option_id'] . "' and pa.options_id = popt.products_options_id and pa.options_values_id = '" . $order->products[$i]['attributes'][$j]['value_id'] . "' and pa.options_values_id = poval.products_options_values_id and popt.language_id = '" . $languages_id . "' and poval.language_id = '" . $languages_id . "'"; $attributes = tep_db_query($attributes_query); } else { $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 = '" . $order->products[$i]['id'] . "' and pa.options_id = '" . $order->products[$i]['attributes'][$j]['option_id'] . "' and pa.options_id = popt.products_options_id and pa.options_values_id = '" . $order->products[$i]['attributes'][$j]['value_id'] . "' and pa.options_values_id = poval.products_options_values_id and popt.language_id = '" . $languages_id . "' and poval.language_id = '" . $languages_id . "'"); } $attributes_values = tep_db_fetch_array($attributes); $sql_data_array = array('orders_id' => $insert_id, 'orders_products_id' => $order_products_id, 'products_options' => $attributes_values['products_options_name'], 'products_options_values' => $attributes_values['products_options_values_name'], 'options_values_price' => $attributes_values['options_values_price'], 'price_prefix' => $attributes_values['price_prefix']); tep_db_perform(TABLE_ORDERS_PRODUCTS_ATTRIBUTES, $sql_data_array); if ((DOWNLOAD_ENABLED == 'true') && isset($attributes_values['products_attributes_filename']) && tep_not_null($attributes_values['products_attributes_filename'])) { $sql_data_array = array('orders_id' => $insert_id, 'orders_products_id' => $order_products_id, 'orders_products_filename' => $attributes_values['products_attributes_filename'], 'download_maxdays' => $attributes_values['products_attributes_maxdays'], 'download_count' => $attributes_values['products_attributes_maxcount']); tep_db_perform(TABLE_ORDERS_PRODUCTS_DOWNLOAD, $sql_data_array); } $products_ordered_attributes .= "\n\t" . $attributes_values['products_options_name'] . ' ' . $attributes_values['products_options_values_name']; } } //------insert customer choosen option eof ---- $total_weight += ($order->products[$i]['qty'] * $order->products[$i]['weight']); $total_tax += tep_calculate_tax($total_products_price, $products_tax) * $order->products[$i]['qty']; $total_cost += $total_products_price; $products_ordered .= $order->products[$i]['qty'] . ' x ' . $order->products[$i]['name'] . ' (' . $order->products[$i]['model'] . ') = ' . $currencies->display_price($order->products[$i]['final_price'], $order->products[$i]['tax'], $order->products[$i]['qty']) . $products_ordered_attributes . "\n"; } // lets start with the email confirmation $email_order = STORE_NAME . "\n" . EMAIL_SEPARATOR . "\n" . EMAIL_TEXT_ORDER_NUMBER . ' ' . $insert_id . "\n" . EMAIL_TEXT_INVOICE_URL . ' ' . tep_href_link(FILENAME_ACCOUNT_HISTORY_INFO, 'order_id=' . $insert_id, 'SSL', false) . "\n" . EMAIL_TEXT_DATE_ORDERED . ' ' . strftime(DATE_FORMAT_LONG) . "\n\n"; if ($order->info['comments']) { $email_order .= tep_db_output($order->info['comments']) . "\n\n"; } $email_order .= EMAIL_TEXT_PRODUCTS . "\n" . EMAIL_SEPARATOR . "\n" . $products_ordered . EMAIL_SEPARATOR . "\n"; for ($i=0, $n=sizeof($order_totals); $i<$n; $i++) { $email_order .= strip_tags($order_totals[$i]['title']) . ' ' . strip_tags($order_totals[$i]['text']) . "\n"; } if ($order->content_type != 'virtual') { $email_order .= "\n" . EMAIL_TEXT_DELIVERY_ADDRESS . "\n" . EMAIL_SEPARATOR . "\n" . tep_address_label($customer_id, $sendto, 0, '', "\n") . "\n"; } $email_order .= "\n" . EMAIL_TEXT_BILLING_ADDRESS . "\n" . EMAIL_SEPARATOR . "\n" . tep_address_label($customer_id, $billto, 0, '', "\n") . "\n\n"; if (is_object($$payment)) { $email_order .= EMAIL_TEXT_PAYMENT_METHOD . "\n" . EMAIL_SEPARATOR . "\n"; $payment_class = $$payment; $email_order .= $payment_class->title . "\n\n"; if ($payment_class->email_footer) { $email_order .= $payment_class->email_footer . "\n\n"; } } <!-- Tracking contribution begin --> tep_mail($order->customer['firstname'] . ' ' . $order->customer['lastname'], $order->customer['email_address'], EMAIL_TEXT_SUBJECT_1 . ' ' . $insert_id . ' ' .EMAIL_TEXT_SUBJECT_2 , $email_order, STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS); <!-- Tracking contribution end --> // send emails to other people if (SEND_EXTRA_ORDER_EMAILS_TO != '') { <!-- Tracking contribution begin --> tep_mail('', SEND_EXTRA_ORDER_EMAILS_TO, EMAIL_TEXT_SUBJECT_1 . ' ' . $insert_id . ' ' .EMAIL_TEXT_SUBJECT_2, $email_order, STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS); <!-- Tracking contribution end --> } // load the after_process function from the payment modules $payment_modules->after_process(); $cart->reset(true); // unregister session variables used during checkout tep_session_unregister('sendto'); tep_session_unregister('billto'); tep_session_unregister('shipping'); tep_session_unregister('payment'); tep_session_unregister('comments'); tep_redirect(tep_href_link(FILENAME_CHECKOUT_SUCCESS, '', 'SSL')); require(DIR_WS_INCLUDES . 'application_bottom.php'); ?> thanks for the help!
  6. if anyone else is interested on solving the same problem... here it is: http://www.mywebsite.com/index-c-0.html it will redirect you to the base of your categories of your store ;) I tried it all by myself and finally got somewhere :) check it out if you don't know what I am talking about http://www.brazilianhotstuff.com/index-c-0.html
  7. I've got it installed and working flawlessly, except by one thing I have a link to all categories, it would redirect you to index.php?cPath=0 http://www.brazilainhotstuff.com/index.php?cPath=0 it won't work anylonger... it redirects me back to the index.... what would be the new link I should use? or better how do I fix it? Thanks!!!
  8. Hello all!!! All I've ever learned about coding (HTML and PHP) was "hands on" never read a book or studied lol but I kinda get away with it pretty well... I am using the "image magic" mod, just to make it clear ( http://www.oscommerce.com/community/contributions,3770 ) anyways I modded the upcoming catalog/includes/modules/upcoming_products.php so it would show pictures of the products not only text :) (feel free to use it) <?php /* $Id: upcoming_products.php,v 1.24 2003/06/09 22:49:59 hpdl Exp $ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2003 osCommerce Released under the GNU General Public License */ $expected_query = tep_db_query("select p.products_id, pd.products_name, products_image, products_date_available as date_expected from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where to_days(products_date_available) >= to_days(now()) and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' order by " . EXPECTED_PRODUCTS_FIELD . " " . EXPECTED_PRODUCTS_SORT . " limit " . MAX_DISPLAY_UPCOMING_PRODUCTS); if (tep_db_num_rows($expected_query) > 0) { ?> <!-- upcoming_products //--> <tr> <td><table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr> <td colspan="3"><?php echo tep_draw_separator(); ?></td> </tr> <tr> <td colspan="2" class="featuretitle"> <?php echo TABLE_HEADING_UPCOMING_PRODUCTS; ?> </td> <td align="right" class="featuretitle"> <?php echo TABLE_HEADING_DATE_EXPECTED; ?> </td> </tr> <tr> <td colspan="3"><?php echo tep_draw_separator(); ?></td> </tr> <tr> <?php $row = 0; while ($expected = tep_db_fetch_array($expected_query)) { $row++; if (($row / 2) == floor($row / 2)) { echo ' <tr class="upcome-even">' . "\n"; } else { echo ' <tr class="upcome-odd">' . "\n"; } echo ' <td width="40" height="40" align="center" valign="center"><a class="featured" href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $expected['products_id']) . '">' . tep_image(DIR_WS_IMAGES . $expected['products_image'], HEADING_IMAGE_WIDTH, HEADING_IMAGE_HEIGHT) . '</a></td>' . "\n" . ' <td class="upcome-odd"><a class="featured" href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $expected['products_id']) . '"> ' . $expected['products_name'] . ' </a></td>' . "\n" . ' <td align="right" class="smallText"> ' . tep_date_short($expected['date_expected']) . ' </td>' . "\n" . ' </tr>' . "\n"; } ?> <tr> <td colspan="3"><?php echo tep_draw_separator(); ?></td> </tr> </table></td> </tr> <!-- upcoming_products_eof //--> <?php } ?> ok here is the most important part of the code (where I have trouble): <?php $row = 0; while ($expected = tep_db_fetch_array($expected_query)) { $row++; if (($row / 2) == floor($row / 2)) { echo ' <tr class="upcome-even">' . "\n"; } else { echo ' <tr class="upcome-odd">' . "\n"; } echo ' <td width="40" height="40" align="center" valign="center"><a class="featured" href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $expected['products_id']) . '">' . tep_image(DIR_WS_IMAGES . $expected['products_image'], HEADING_IMAGE_WIDTH, HEADING_IMAGE_HEIGHT) . '</a></td>' . "\n" . ' <td class="upcome-odd"><a class="featured" href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $expected['products_id']) . '"> ' . $expected['products_name'] . ' </a></td>' . "\n" . ' <td align="right" class="smallText"> ' . tep_date_short($expected['date_expected']) . ' </td>' . "\n" . ' </tr>' . "\n"; } ?> and it returns: !-- upcoming_products //--> <tr> <td><table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr> <td colspan="3"><img src="images/pixel_black.gif" width="100%" height="1" border="0" alt=""></td> </tr> <tr> <td colspan="2" class="featuretitle"> Upcoming Products </td> <td align="right" class="featuretitle"> Date Expected </td> </tr> <tr> <td colspan="3"><img src="images/pixel_black.gif" width="100%" height="1" border="0" alt=""></td> </tr> <tr> <tr class="upcome-odd"> <td width="40" height="40" align="center" valign="center"><a class="featured" href="http://www.brazilianhotstuff.com/product_info.php?products_id=31&osCsid=b145288071621e786250601e92658426"><img src="imagemagic.php?img=1q%2BzqL%2B8e6yiwMfV4LS7g7C2lQ%3D%3D&w=40&h=32&page=" width="40" height="32" border="0" alt="57" title="57"></a></td> <td class="upcome-odd"><a class="featured" href="http://www.brazilianhotstuff.com/product_info.php?products_id=31&osCsid=b145288071621e786250601e92658426"> Brazil Car Flag </a></td> <td align="right" class="smallText"> 03/17/2006 </td> </tr> <tr> <td colspan="3"><img src="images/pixel_black.gif" width="100%" height="1" border="0" alt=""></td> </tr> </table></td> </tr> <!-- upcoming_products_eof //--> the problem is that Image Magic does it's work and makes a thumbnail (wich is what I wanted) but here: <td width="40" height="40" align="center" valign="center"><a class="featured" href="http://www.brazilianhotstuff.com/product_info.php?products_id=31&osCsid=b145288071621e786250601e92658426"><img src="imagemagic.php?img=1q%2BzqL%2B8e6yiwMfV4LS7g7C2lQ%3D%3D&w=40&h=32&page=" width="40" height="32" border="0" alt="57" title="57"></a></td> as you can see it gives me width="40" height="32" border="0" alt="57" title="57" where does it get all of these values from? because HEADING_IMAGE_WIDTH = 57 HEADING_IMAGE_HEIGHT = 40 and it uses the HEADING_IMAGE_HEIGHT (40) as width... and it figures out the width according to the image dimentions... but than it gets even more wierd .... HEADING_IMAGE_WIDTH (57) as alt and title (alt="57" title="57") what am I doing wrong? if i am not even calling an "alt" value neither a "title" and whats up with the dimmentions... I dont care much about the dimentions as they are ok being this small my main concern is leaving the "alt" and the "title" blank
  9. Jerfersor

    USPS Labels not working

    erm dummy me... how could i ? anyways thanks! I hope you like the shaved up look :) and thanks for pointing out the double weight calculation :S
  10. Jerfersor

    USPS Labels not working

    Thanks Sid04! I noticed I had packed the wrong "differentshipping.php" file now I uninstalled ... reinstalled using the new pack to make sure I had everything working ... and it did. So that should be a final. Thanks again
  11. Jerfersor

    USPS Labels not working

    mmm it seemed to be working perfectly on my end... I'll work on it a little more and tweak it up when final ver is ready i guess i'll upload
  12. Jerfersor

    USPS Labels not working

    Ok guys I've wasted most of my day cleaning up the code and patching up everything Now you have a one stop download updated, tested & working Follow up the readme and now when you click on "sign in" it open in a new window so you can login, close the window and than continue processing your label. Thanks for everyone who's been helping along with this great contribution Download it now :) http://www.oscommerce.com/community/contributions,1498 Jerf.
×