Jump to content

custodian

Members
  • Content count

    620
  • Joined

  • Last visited

Everything posted by custodian

  1. custodian

    Shipping calculated by Zip Code

    mine is none also Did you just change the zip? I change my zip, state and city
  2. custodian

    Shipping calculated by Zip Code

    Quoted figures are changing for me for a 26lb package I set my real address and was quoted 65.00 49.00 33.00 Changed my location to Beverly Hill, CA 90210 and the figures changed to 65.00 28.00 20.00
  3. I decide to go with 2.0 with caching and it's workng BUT in admin I get a black page. In order to determine what code was breaking it.. and if I remove from admin/includes/functions/general.php // Ultimate SEO URLs - by Chemo // Funtion to reset SEO URLs database cache entries function tep_reset_cache_data_seo_urls($action){ switch ($action){ case 'reset': tep_db_query("DELETE FROM cache WHERE cache_name LIKE '%seo_urls%'"); tep_db_query("UPDATE configuration SET configuration_value='false' WHERE configuration_key='SEO_URLS_CACHE_RESET'"); break; default: break; } # The return value is used to set the value upon viewing # It's NOT returining a false to indicate failure!! return 'false'; } the admin pages load properly. I've placed this before the closing ?> and have even moved it upwards in the file all the way to the top with the same results. Suggestions?
  4. Hopefully someone can shed some light on this for me. I've been using rewrite's for quite some time now, so mod rewrite isn't the issue here. When I install 2.1(a, b, c, d,... doesn't matter) I get the following (see photo below). This is before I even get to my .htaccess; which I thought would fix it since it's the last step in the install though updating the .htaccess file doesn't correct the problem either. Everytime I instll SEO URL's I get this That's all I get.. solid text
  5. custodian

    NEW! Complete Order Editing Tool!

    NO, (and I ran a diff on the stock file and mine to make sure)though I have do have 3 sections of the invoice.php that have been modified. I've installed Better Invoice Order Number; which shouldn't be casuing my problems That code is in two spots like such <!-- order number addon START //--> </TR> <TR Align="RIGHT"> <TD><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></TD> <!-- order number addon END //--> The second part is <tr> <td class="main"><b><?php echo "ORDER#:"; ?></b></td> <td class="main"><?php echo tep_trans_id($order->info['date_purchased'], $oID); ?></td> </tr> The Third section is an Improved Invoice Contrib that is the following <!-- Improved Invoice --> <?php $orders_status_query = tep_db_query("select orders_status_id, orders_status_name from " . TABLE_ORDERS_STATUS . " where language_id = '" . (int)$languages_id . "'"); while ($orders_status = tep_db_fetch_array($orders_status_query)) { $orders_statuses[] = array('id' => $orders_status['orders_status_id'], 'text' => $orders_status['orders_status_name']); $orders_status_array[$orders_status['orders_status_id']] = $orders_status['orders_status_name']; } ?> <CENTER> <table width="70%" border="1" cellspacing="0" cellpadding="2"> <P> <BR> <P> <BR> <P> <BR> <P> <tr> <td class="smallText" align="center"><b>Date Added</b></td> <td class="smallText" align="center"><b>Status</b></td> <td class="smallText" align="center"><b>Comments</b></td> </tr> <tr> <?php $orders_history_query = tep_db_query("select orders_status_id, date_added, customer_notified, comments from " . TABLE_ORDERS_STATUS_HISTORY . " where orders_id = '" . tep_db_input($oID) . "' order by date_added"); if (tep_db_num_rows($orders_history_query)) { while ($orders_history = tep_db_fetch_array($orders_history_query)) { echo ' <tr>' . "\n" . ' <td class="smallText" valign="middle" align="center" width = 100>' . tep_datetime_short($orders_history['date_added']) . '</td>' . "\n" . ' <td class="smallText" valign="middle" align="center" width = 100>' . $orders_status_array[$orders_history['orders_status_id']] . ' </td>' . "\n" . ' <td class="smallText" valign="middle">' . nl2br(tep_db_output($orders_history['comments'])) . ' </td>' . "\n" . ' </tr>' . "\n"; } } else { echo ' <tr>' . "\n" . ' <td class="smallText" colspan="5">' . TEXT_NO_ORDER_HISTORY . '</td>' . "\n" . ' </tr>' . "\n"; } ?> </tr> </table></CENTER> <!-- End Improved Invoice --> The entire code put together is <?php /* $Id: invoice.php,v 1.6 2003/06/20 00:37:30 hpdl Exp $ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2003 osCommerce Released under the GNU General Public License */ require('includes/application_top.php'); require(DIR_WS_CLASSES . 'currencies.php'); $currencies = new currencies(); $oID = tep_db_prepare_input($HTTP_GET_VARS['oID']); $orders_query = tep_db_query("select orders_id from " . TABLE_ORDERS . " where orders_id = '" . (int)$oID . "'"); include(DIR_WS_CLASSES . 'order.php'); $order = new order($oID); ?> <!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN"> <html <?php echo HTML_PARAMS; ?>> <head> <meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>"> <title><?php echo TITLE; ?></title> <link rel="stylesheet" type="text/css" href="includes/stylesheet.css"> </head> <body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0" bgcolor="#FFFFFF"> <!-- body_text //--> <table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr> <td><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td class="pageHeading"><?php echo nl2br(STORE_NAME_ADDRESS); ?></td> <td class="pageHeading" align="right"><?php echo tep_image(DIR_WS_IMAGES . 'oscommerce.gif', 'osCommerce', '204', '50'); ?></td> </tr> </table></td> </tr> <tr> <td><table width="100%" border="0" cellspacing="0" cellpadding="2"> <tr> <td colspan="2"><?php echo tep_draw_separator(); ?></td> <!-- order number addon START //--> </TR> <TR Align="RIGHT"> <TD><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></TD> <!-- order number addon END //--> </tr> <tr> <td valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="2"> <tr> <td class="main"><b><?php echo ENTRY_SOLD_TO; ?></b></td> </tr> <tr> <td class="main"><?php echo tep_address_format($order->customer['format_id'], $order->customer, 1, '', '<br>'); ?></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '1', '5'); ?></td> </tr> <tr> <td class="main"><?php echo $order->customer['telephone']; ?></td> </tr> <tr> <td class="main"><?php echo '<a href="mailto:' . $order->customer['email_address'] . '"><u>' . $order->customer['email_address'] . '</u></a>'; ?></td> </tr> </table></td> <td valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="2"> <tr> <td class="main"><b><?php echo ENTRY_SHIP_TO; ?></b></td> </tr> <tr> <td class="main"><?php echo tep_address_format($order->delivery['format_id'], $order->delivery, 1, '', '<br>'); ?></td> </tr> </table></td> </tr> </table></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td> </tr> <tr> <td><table border="0" cellspacing="0" cellpadding="2"> <tr> <td class="main"><b><?php echo ENTRY_PAYMENT_METHOD; ?></b></td> <td class="main"><?php echo $order->info['payment_method']; ?></td> </tr> <tr> <td class="main"><b><?php echo "ORDER#:"; ?></b></td> <td class="main"><?php echo tep_trans_id($order->info['date_purchased'], $oID); ?></td> </tr> </table></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td> </tr> <tr> <td><table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr class="dataTableHeadingRow"> <td class="dataTableHeadingContent" colspan="2"><?php echo TABLE_HEADING_PRODUCTS; ?></td> <td class="dataTableHeadingContent"><?php echo TABLE_HEADING_PRODUCTS_MODEL; ?></td> <td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_TAX; ?></td> <td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_PRICE_EXCLUDING_TAX; ?></td> <td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_PRICE_INCLUDING_TAX; ?></td> <td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_TOTAL_EXCLUDING_TAX; ?></td> <td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_TOTAL_INCLUDING_TAX; ?></td> </tr> <?php for ($i = 0, $n = sizeof($order->products); $i < $n; $i++) { echo ' <tr class="dataTableRow">' . "\n" . ' <td class="dataTableContent" valign="top" align="right">' . $order->products[$i]['qty'] . ' x</td>' . "\n" . ' <td class="dataTableContent" valign="top">' . $order->products[$i]['name']; if (isset($order->products[$i]['attributes']) && (($k = sizeof($order->products[$i]['attributes'])) > 0)) { for ($j = 0; $j < $k; $j++) { echo '<br><nobr><small> <i> - ' . $order->products[$i]['attributes'][$j]['option'] . ': ' . $order->products[$i]['attributes'][$j]['value']; if ($order->products[$i]['attributes'][$j]['price'] != '0') echo ' (' . $order->products[$i]['attributes'][$j]['prefix'] . $currencies->format($order->products[$i]['attributes'][$j]['price'] * $order->products[$i]['qty'], true, $order->info['currency'], $order->info['currency_value']) . ')'; echo '</i></small></nobr>'; } } echo ' </td>' . "\n" . ' <td class="dataTableContent" valign="top">' . $order->products[$i]['model'] . '</td>' . "\n"; echo ' <td class="dataTableContent" align="right" valign="top">' . tep_display_tax_value($order->products[$i]['tax']) . '%</td>' . "\n" . ' <td class="dataTableContent" align="right" valign="top"><b>' . $currencies->format($order->products[$i]['final_price'], true, $order->info['currency'], $order->info['currency_value']) . '</b></td>' . "\n" . ' <td class="dataTableContent" align="right" valign="top"><b>' . $currencies->format(tep_add_tax($order->products[$i]['final_price'], $order->products[$i]['tax']), true, $order->info['currency'], $order->info['currency_value']) . '</b></td>' . "\n" . ' <td class="dataTableContent" align="right" valign="top"><b>' . $currencies->format($order->products[$i]['final_price'] * $order->products[$i]['qty'], true, $order->info['currency'], $order->info['currency_value']) . '</b></td>' . "\n" . ' <td class="dataTableContent" align="right" valign="top"><b>' . $currencies->format(tep_add_tax($order->products[$i]['final_price'], $order->products[$i]['tax']) * $order->products[$i]['qty'], true, $order->info['currency'], $order->info['currency_value']) . '</b></td>' . "\n"; echo ' </tr>' . "\n"; } ?> <tr> <td align="right" colspan="8"><table border="0" cellspacing="0" cellpadding="2"> <?php for ($i = 0, $n = sizeof($order->totals); $i < $n; $i++) { echo ' <tr>' . "\n" . ' <td align="right" class="smallText">' . $order->totals[$i]['title'] . '</td>' . "\n" . ' <td align="right" class="smallText">' . $order->totals[$i]['text'] . '</td>' . "\n" . ' </tr>' . "\n"; } ?> </table></td> </tr> </table></td> </tr> </table> <!-- Improved Invoice --> <?php $orders_status_query = tep_db_query("select orders_status_id, orders_status_name from " . TABLE_ORDERS_STATUS . " where language_id = '" . (int)$languages_id . "'"); while ($orders_status = tep_db_fetch_array($orders_status_query)) { $orders_statuses[] = array('id' => $orders_status['orders_status_id'], 'text' => $orders_status['orders_status_name']); $orders_status_array[$orders_status['orders_status_id']] = $orders_status['orders_status_name']; } ?> <CENTER> <table width="70%" border="1" cellspacing="0" cellpadding="2"> <P> <BR> <P> <BR> <P> <BR> <P> <tr> <td class="smallText" align="center"><b>Date Added</b></td> <td class="smallText" align="center"><b>Status</b></td> <td class="smallText" align="center"><b>Comments</b></td> </tr> <tr> <?php $orders_history_query = tep_db_query("select orders_status_id, date_added, customer_notified, comments from " . TABLE_ORDERS_STATUS_HISTORY . " where orders_id = '" . tep_db_input($oID) . "' order by date_added"); if (tep_db_num_rows($orders_history_query)) { while ($orders_history = tep_db_fetch_array($orders_history_query)) { echo ' <tr>' . "\n" . ' <td class="smallText" valign="middle" align="center" width = 100>' . tep_datetime_short($orders_history['date_added']) . '</td>' . "\n" . ' <td class="smallText" valign="middle" align="center" width = 100>' . $orders_status_array[$orders_history['orders_status_id']] . ' </td>' . "\n" . ' <td class="smallText" valign="middle">' . nl2br(tep_db_output($orders_history['comments'])) . ' </td>' . "\n" . ' </tr>' . "\n"; } } else { echo ' <tr>' . "\n" . ' <td class="smallText" colspan="5">' . TEXT_NO_ORDER_HISTORY . '</td>' . "\n" . ' </tr>' . "\n"; } ?> </tr> </table></CENTER> <!-- End Improved Invoice --> <!-- body_text_eof //--> <br> </body> </html> <?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>
  6. custodian

    NEW! Complete Order Editing Tool!

    Nevermind, I was taking your word or "Value" as a variable and not as the actual "Value" table. I see what you mean, that it is -$5.00 in one field and 5.00 in the other. I appreciate your efforts, though since this isn't an issue with OE, I'll shot over to PR and let them know. Thanks for your time and effort in clearing this up.
  7. custodian

    NEW! Complete Order Editing Tool!

    I didn't know this! Do you know for sure if this is for all states in the US or based on individual State tax laws? (Ie: Some states can charge tax on Shipping, though in Pennsylvania we do not)
  8. custodian

    NEW! Complete Order Editing Tool!

    So you're sayig the orders_total shouldn't have <font="FF0000> - <--- Negative here as it current is $5.00 But should be in the db as <font="FF0000> -$5.00 ^--------------Negative Here in order of OE it process it properly ?
  9. custodian

    NEW! Complete Order Editing Tool!

    The 1st screen shot is Before As you can see, in the 2nd when I clicked edit, the screen shot shows the number as positive, OE dropped the - from the value. So when I update it is now a positive. A screen shot of afterwards wasn't included, though the difference from the 1st screen shot to afterwards is that it's all black, and since it is not a positive it is added to the total. The third screen shot is the orders_total table Before using the editor. It's difficult to see, but the - is on the above line right after FF0000"> I like the negative showing as red, but that's not my concern... it more of the neg/pos reversal
  10. custodian

    NEW! Complete Order Editing Tool!

    FYI: The version I d/l was Version 2.0, now with Vitamin A! djmonkey1 14 Mar 2006 and then added Error in Language File mrossi 14 Mar 2006
  11. custodian

    NEW! Complete Order Editing Tool!

    Yes I am using the latest version, just downloaded and installed shortly before original post. OK.. here's the info I open an Order for a customer (regardless of status) and it appears like this I then select edit and the screen shows this This entry in the database is under the orders_total and is set up like this If I edit the order and resave the order looks as it does in the first phote above, but the points are in black and are now added to the total (since it drops the - in front of the entery in the database.) If I can be of any more help to fix this, let me know. I just finished d/l the contrib again adn went through all the step (to make sure I did it right and to make sure I did in fact d/l the latest and all the code match - looked at it through win merge also.)
  12. custodian

    NEW! Complete Order Editing Tool!

    Installed your latest release and it works great, only thing I noticed is that it interferes with negative values. I am use Points Reward and when I edit the invoice it take the dollar value (let's say -$5.00) and upon opening the editor changes it to +$5.00 I didn't cath this right away, and some customers were emailing. It also removes the formatting. With points reward the points are listed as such on the invoice Redeemed Point -$5.00 After editting it appears as Redeemed Point +$5.00 No red and no longer a negative value. Any way I can maintain the formatting of that entry, both formatting and value. If not, is there anywehre I can modified the code sot hat it does NOT even bother loading that field - then if I need to make a point adjustment invoice I can merely tack on another row with the adjustment. Thanks
  13. custodian

    How Did You Hear About Us - Support

    I have a heavily modded shop. I have this contrib running smoothly, though I was a little unsure where to place the application_top code //rmh referral start // set the referral id if (!tep_session_is_registered('referral_id') || isset($HTTP_GET_VARS['ref'])) { if (!tep_session_is_registered('referral_id') && !tep_session_is_registered('customer_id')) { tep_session_register('referral_id'); } if (isset($HTTP_GET_VARS['ref']) && tep_not_null($HTTP_GET_VARS['ref'])) { $referral_id = $HTTP_GET_VARS['ref']; } else { $referral_id = ''; } } //rmh referral end As the install file doesn't match up.. My first shot broke my wholes prices.. my second attmept at placement seems to be working now, but I am unsure if where I have placed the code, if it is really doing what it's suppose to be doing. Here the section that I added it to and where I added it. Like I said, my shop is working, but since I am unsure what theis section of code is meant to do, I am unsure if I've broke it or if it is still doing what it should break; case 'cust_order' : if (tep_session_is_registered('customer_id') && isset($HTTP_GET_VARS['pid'])) { if (tep_has_product_attributes($HTTP_GET_VARS['pid'])) { tep_redirect(tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $HTTP_GET_VARS['pid'])); } else { $cart->add_cart($HTTP_GET_VARS['pid'], $cart->get_quantity($HTTP_GET_VARS['pid'])+1); } } tep_redirect(tep_href_link($goto, tep_get_all_get_params($parameters))); break; } // end switch // BOF Separate Pricing Per Customer v4.1, Hide products from groups mod } ///// Originally placed the rmh Referral here but it broke wholesale I then moved it down else { // $hide_product is true tep_redirect(tep_href_link(FILENAME_DEFAULT)); } // EOF Separate Pricing Per Customer v4.1, Hide products from groups mod } // if (isset($HTTP_GET_VARS['action'])) //rmh referral start // set the referral id if (!tep_session_is_registered('referral_id') || isset($HTTP_GET_VARS['ref'])) { if (!tep_session_is_registered('referral_id') && !tep_session_is_registered('customer_id')) { tep_session_register('referral_id'); } if (isset($HTTP_GET_VARS['ref']) && tep_not_null($HTTP_GET_VARS['ref'])) { $referral_id = $HTTP_GET_VARS['ref']; } else { $referral_id = ''; } } //rmh referral end // include the who's online functions require(DIR_WS_FUNCTIONS . 'whos_online.php'); tep_update_whos_online(); // include the password crypto functions require(DIR_WS_FUNCTIONS . 'password_funcs.php'); // include validation functions (right now only email address) Does it look ok?
  14. custodian

    I lose the cents !

    And you have Decimal Places: 2
  15. custodian

    changing img when selecting color/model?

    Possibly this http://www.oscommerce.com/community/contributions,1467
  16. custodian

    Paypal problems after server hijack

    I know this doesn't help, but I had nothing but issues with Paypal and PayPal IPN. People couldn't complete transaction, it would work, then it wouldn't, different problems one after another. I switched to a merchant account that gives a discount for using OsCommerce (got to love them for that!) And I haven't missed a a single order, and the customer never leaves my web site. And the module for them was made by their staff .
  17. custodian

    In dev contrib

    OK, sorry about that, as I said, these forums go against my intuition. I assumed that contrib support was for john doe needing help with his contrib. It made more sense for me to look here , but I see the pinned posting over there.
  18. custodian

    In dev contrib

    I'm working on a new contribution of something I had done with a previous store I had using Perl. I pickup languages and processes fairly easy, but I seem to have a difficult time knowning where to look here on the forum for the resource I need. Since I'm new to OC and PHP can someone point me to possible OC documentation that lists all stock filenames, related requires for each file, all defines within the stock and any guidelines that are encourage to be followed when dev'ing a contribution. I know I can dig through the stock files, but if there is already a resource for this information it would save me a considerable amount of time. And I'm hoping to have this contrib out by next week. :wacko: Thank you
  19. Update: Replaced the catalog file and it worked. Ran the admin and it broke everything again (blank pages) - Remove the ' that the admin keeps taking the \ away from and I could access the pages but tag would generate dynamically. Checked the DB, all fields filled in properly. Remvoed the admin, replaced the catalog files again and all is well. Do I really need the admin for anything? The Contrib I already have installed, troubleshot and have working? Admin Notes Adsense Auto copyright Auto Login Secure Black List Catalog Product with Images Conditions and Privacy Create Account Cron BDV Down for Maintenance Feedback Request Froogle Data Feeder Froogle Data Feed (Perl) Great Categories Hide Products For CG SPPC Improved Invoices Improved Order Number Auto Remove MD5 Master Password NewsDesk Order Editor On The Fly Thumbnails w/GD Lib Points Reward Preset Order Comments Quanity Min Per CG SPPC Price Break Related Products Secure Pay CVS Separate Prices Shipping Status Show Price List for SPPC Spiders Super Tracker Currency Updater Watermarkiing Welcome Email Pwd Who's Online Enhancement I've been around the block a few times with these files... :wacko:
  20. Mine work too until I installed the admin, which I will most likely remove now. I got the blank pages too. The issue is the admin removes the \ from the what\'s new and cause everypage to go blank I've also caught numerous spelling errors, file name, paths, etc.. Worked much better without the admin. Hopefully it will as it did when I remove it too
  21. BTW: Yes, I can place default value in, but is there a way to get the rest of the title to self populate?
  22. OK, I just installed 2.5.6. Am I missing something? I go to admin, I click on Fill ALL Tags. and I have nothing. My page source is this <title></title> <meta name="Description" content=""/> <meta name="Keywords" content=""/> Do I have to enter all these myself? I thought this would populate itself from the description already in the databse for the products. to make its own title, description and keywords. Besides that point, if I go into one of my products I see information filled in inside the three new boxes for th product (in admin). So there is information there, but when I go to the product page on the catalog side.. nothing. The admin is secure The files mentioned in the readme were set to 666, I even tried 777 - no dice! I replaced the files with backups and reinstalled the entire thing all over again. Same thing - Nothing suggestions?
  23. custodian

    USPS Shipping price ongoing problem

    Your address? Or you zip code? Did you have USPS put you onto the Production Server? Until the do it won't work. By default new accounts are on Test servers untill you call them and have them move it over. Simply state that you are using the oscommerce 3rd party solution and no testing is needed. They'll activate it while you are on the phone and it will work instantly. Also make sure the the USPS module is set to Production (or live) server as well.
  24. custodian

    NEW! Complete Order Editing Tool!

    Well it's the latest (last time I checked) PHP Version: 5.1.2 (Zend: 2.1.0)
  25. custodian

    How To Intall Contributions

    Well, once you modify the pages you will need to upload them (unless you are changing them directly on the server). But yes, it is more involved then simply uploading the contrib and away you go! Some contrib's may be a file and a single line of code to modify, other will have multi-change per file and may involve nearly every file... I've broken my store many of time - I'm up to about 50 contribs and every 36 hour day I spent on them was well worth it :)
×