Jump to content

custodian

Members
  • Content count

    620
  • Joined

  • Last visited

Everything posted by custodian

  1. It would be nearly imposslbe for anyone here to know what contrib you installed in order to define the correct sql entries. If you haven't installed any other contrib, I would recommend d/l the OSC files again and simply replace that file. Another thing you can do is to remove cc_cvv from the offending file
  2. See this http://forums.oscommerce.com/lofiversion/i...hp/t132093.html
  3. custodian

    [Contribution] Admin Notes

    I don't know if this would not make it show or not (tables can be funny like that).. but initially looking at this part <tr> <td class="main"><b><?php echo ENTRY_PAYMENT_METHOD; ?></b></td> <td class="main"><?php echo $order->info['payment_method']; ?></td> <tr> <td class="main"><b><?php echo ENTRY_CUSTOMER_NOTES; ?></b></td> <td><i><?php //query to grab the notes $cust_notes_query = tep_db_query("select customers_id, customers_notes from " . TABLE_CUSTOMERS . " where customers_id = '" . (int)$cID . "'"); $cust_notes = tep_db_fetch_array($cust_notes_query); //end query echo $cust_notes['customers_notes']; ?></i></td> </tr> I think that should be <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 ENTRY_CUSTOMER_NOTES; ?></b></td> <td><i><?php //query to grab the notes $cust_notes_query = tep_db_query("select customers_id, customers_notes from " . TABLE_CUSTOMERS . " where customers_id = '" . (int)$cID . "'"); $cust_notes = tep_db_fetch_array($cust_notes_query); //end query echo $cust_notes['customers_notes']; ?></i></td> </tr>
  4. custodian

    Customer Private Messages

    OK, for those you that may have the same issue. Do the following In account.php in the Customers Private Message section look for echo '<form action=' . $_SERVER['PHP_SELF'] . ' method="post">'; and change it to // echo '<form action=' . $_SERVER['PHP_SELF'] . ' method="post">'; echo '<form method="post">'; You only need to change this if it's logging you out
  5. custodian

    Customer Private Messages

    In admin, go to the customer list. Click on a customer to go into their details. You will see the Private Message Box under the newsletter option in their details. Currently the Customer Private Messages is only for leaving the customer messages - the customer can always email you if needed, but if you can't get in contact with them you're stuck with calling them (if you have a phone number). I'll work something into a future release for the customer replying, possible taking them to the contact us page with auto populating.
  6. custodian

    Customer Private Messages

    The message size destroying your layout/design is from the site layout itself. In the catalog/account.php where you placed <!-- BEGIN Private Message v1.0 --> <tr> <td><table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr> <td class="main"><b><?php echo PRIVATE_MESSAGES_TITLE; ?></b></td> </tr> </table> <table border="0" cellspacing="0" cellpadding="2" class="infoBox" width="100%"> <tr class="infoBoxContents"><td align="left"> <?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?> <?php $result = tep_db_query("select customers_private_messages from " . TABLE_CUSTOMERS . " where customers_id = '" . (int)$customer_id . " '"); $result_array = tep_db_fetch_array($result); if ($result_array['customers_private_messages'] != "") { echo PRIVATE_MESSAGES_YES . "<P>" . $result_array['customers_private_messages']; echo '<form action=' . $_SERVER['PHP_SELF'] . ' method="post">'; echo '<input type="submit" name="submit" value="Delete Message">'; echo '</form>'; if (isset($_POST['submit'])) { tep_db_query("UPDATE " . TABLE_CUSTOMERS . " SET customers_private_messages = ('') where customers_id ='" . (int)$customer_id . "'"); echo PRIVATE_MESSAGES_DELETED; } } else { echo PRIVATE_MESSAGES_NO; } ?> </td></tr></table> <!-- END Private Messages --> Adjust the the following items in red according to your site layout. You may choose to make them a fixed width and not a percentage. I choose percentage as the stock default layout has this in the middle of the left and right colum, therefore the 100% would take advantage of the most area it could before wrapping the text. And I also aligned it left to ensure the text was left justified. Your layout could be different, or your customization could be creating a conflict. <tr> <td><table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr> <td class="main"><b><?php echo PRIVATE_MESSAGES_TITLE; ?></b></td> </tr> </table> <table border="0" cellspacing="0" cellpadding="2" class="infoBox" width="100%"> <tr class="infoBoxContents"><td align="left"> Also depending on your site layout you may want to adjust, remove or add the <table> arrangements
  7. custodian

    [Contribution] Admin Notes

    Is that you entire file? I have atleast another 25 lines in my file after where you left off? Did you just snip it, or was that all of it?
  8. custodian

    Customer Private Messages

    What are you looking for? Possibly a link that pop's open a window with the message? Do you want the same thing in Admin or to simply not see the message preview at all?
  9. custodian

    Customer Private Messages

    Thanks Rolly - I guess I should stay away from last minute changes when it's 3am >_<
  10. custodian

    Customer Private Messages

    Glad you found it.
  11. custodian

    Customer Private Messages

    The message location was a draw - My users go to their account page automatically after login,so I opted to place it there AND my index is busy enough :) I plan on adding a notifier into application_top so that they'll know when they have a message if they are currently logged in. The <BR> tags were from my editor, it was attempting to maintain layout by adding them. I though I got them all - thanks for the heads up... I fix that now.
  12. custodian

    [Contribution] Admin Notes

    If you click on the customer you want and select edit and go into their account details.. at the bottom of the screen you don't see a text box to enter the notes?
  13. custodian

    Customer Private Messages

    Error in v1.0 SQL entry Was listed as ALTER TABLE customers ADD private_messages LONGTEXT NOT NULL; should have been ALTER TABLE customers ADD customers_private_messages LONGTEXT NOT NULL; v1.1 corrects with some other trivial corrections
  14. custodian

    Customer Private Messages

    It's currently running on my site. I have included 4 screen shots in the contribution - one of each screen/phase from my site to show how it works and what is looks like.
  15. custodian

    Customer Private Messages

    "Broadcast" and "Clear All" are two features that I am working on and will have in a later release.
  16. custodian

    Can a customer "save" credit card info in "their account"

    I'd be quite interested in that mod as well -
  17. custodian

    Sub-Category Problem

    Your issue is that you do not have the site at a fixed width. When I make my browser window smaller, your web page should not shrink with it, but it does. Try what I said on your site and then go to mine and try the same thing. You'll see the difference. It enables the page to hold it's forrmatting. They way you have it, when the sub cat are displayed, the page needs more room, so instead of narrowing the center (where the products are listed), instead it wraps the right colum over to the left side. Meanwhile all that empty whitespace isn't being utilized for contracting and expanding. You need to have the entire site wrapped in a table with a fixed width of around 700px to 750px Also depending on the layout changes you've done, you may have certain tables already set at minimums that are to large. Other than the main table for the site, its usually a good practice to use % for inner table - to avoid them pushing the others too far - which rearranges the layout as you are seeing.
  18. custodian

    Any info on this contrib?

    I useOrder Entry and also have the latest OSC - it works fine. No errors. Therefore I'd guess that you have installed incorrectly or have another contrib interfering.
  19. custodian

    Paypal

    Install the PayPal IPN contirbution
  20. custodian

    NEW! Complete Order Editing Tool!

    That's fantastic! I'll need to give this a try tonight during some scheduled down-time. I often need to note on the account coments what was removed due to being out of stock or back ordered. Will this list the price as $0.00 also? Not that it needs to be, just cusrious as what to expect.
  21. custodian

    Coolmenu not showing on category pages

    The link is password protected, can't get in.
  22. custodian

    NEW! Complete Order Editing Tool!

    I use it mainly for refund/adjustments - Items sell out fairly fast and sometimes I need to refund an item that is no logner available but has been ordered and paid for. The only thing I do wish I could do is edit the invoice and have it show 0 (instead of removing it), this way they would know what they ordered, but also know that it was not included in their order (Backordered - out of stock - etc...)
  23. custodian

    Shipping calculated by Zip Code

    Still having this issue?
  24. custodian

    essential mod tips/advice

    OTF w/GD is highly recommended Get it here http://www.oscommerce.com/community/contributions,2226
  25. This contirb (header tags) is one of ony two contribs that I absolutely could not get to work and I just gave up. My product_info was the same, I even thought it was something I did, so I went through it again (3 times) and ever time the same. If an answer is found to this persons problem, please post it in detail here so that I may try once again.
×