Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

RattleSn@ke

Archived
  • Posts

    13
  • Joined

  • Last visited

Everything posted by RattleSn@ke

  1. Again, since no-one wants to reply (or just no-one has the problem / solution) on my previous question, i'll repost it:: Fatal error: Call to a member function on a non-object in /var/www/shop/admin/pdf_fpdf.php on line 1592 Someone an idea how to fix this?! Thanks! PS. Here is what's on line 1592 ... $bgColor = $this->m_img->m_gih->m_colorTable->colorIndex($bgColor); Greetz.
  2. Hmmm, 'cause some reason I can't edit my own post ... So I'll add more this way.. Here is what's on line 1592 ... $bgColor = $this->m_img->m_gih->m_colorTable->colorIndex($bgColor); Greetz.
  3. Fatal error: Call to a member function on a non-object in /var/www/shop/admin/pdf_fpdf.php on line 1592 Someone an idea how to fix this?! Thanks!
  4. Hi all, I added some code to make products with price 0 also inactive. I rather have them deleted, but this fuction is still not available. But my question is, does someone know a page with an overview of the table relations in the database??? eg. orders <-> orders_products etc. etc. Thank you. Greetz. RattleSn@ke.
  5. DAMN! I said so to my self, DON'T FORGET TO TELL WHICH FILE !!!! Stupid me! The changes has to be made in: admin/create_order.php 10000 times sorry! Greetz. RattleSn@ke. NOTE: Because I can't edit the other post, I say it in this one. To add the Customer ID searchbox mentioned in my post on page 10 edit the following file: admin/create_order.php
  6. Hi Guntram, I build-in in my shop just the thing you're looking for! (I hope ... :rolleyes: ) I don't (yet) have as much customers as you, but i'm someone that looks forward ... First you have to prevent that the drop-down box automaticly picks the first customer. To do that, edit the code around line 26 if (tep_db_num_rows($result) > 0) { // Query Successful $SelectCustomerBox = "<select name='Customer'>\n"; while($db_Row = tep_db_fetch_array($result)) { $SelectCustomerBox .= "<option value='" . $db_Row["customers_id"] . "'"; Replace this with if (tep_db_num_rows($result) > 0) { // Query Successful $SelectCustomerBox = "<select name='Customer'><option value=''>Choose Customer</option>\n"; while($db_Row = tep_db_fetch_array($result)) { $SelectCustomerBox .= "<option value='" . $db_Row["customers_id"] . "'"; Then replace this (around line 39): if(IsSet($HTTP_GET_VARS['Customer'])) { $account_query = tep_db_query("select * from " . TABLE_CUSTOMERS . " where customers_id = '" . $HTTP_GET_VARS['Customer'] . "'"); $account = tep_db_fetch_array($account_query); $customer = $account['customers_id']; $address_query = tep_db_query("select * from " . TABLE_ADDRESS_BOOK . " where customers_id = '" . $HTTP_GET_VARS['Customer'] . "'"); $address = tep_db_fetch_array($address_query); //$customer = $account['customers_id']; } with this: if(IsSet($HTTP_GET_VARS['Customer'])) { $account_query = tep_db_query("select * from " . TABLE_CUSTOMERS . " where customers_id = '" . $HTTP_GET_VARS['Customer'] . "'"); $account = tep_db_fetch_array($account_query); $customer = $account['customers_id']; $address_query = tep_db_query("select * from " . TABLE_ADDRESS_BOOK . " where customers_id = '" . $HTTP_GET_VARS['Customer'] . "'"); $address = tep_db_fetch_array($address_query); //$customer = $account['customers_id']; } elseif (IsSet($HTTP_GET_VARS['Customer_nr'])) { $account_query = tep_db_query("select * from " . TABLE_CUSTOMERS . " where customers_id = '" . $HTTP_GET_VARS['Customer_nr'] . "'"); $account = tep_db_fetch_array($account_query); $customer = $account['customers_id']; $address_query = tep_db_query("select * from " . TABLE_ADDRESS_BOOK . " where customers_id = '" . $HTTP_GET_VARS['Customer_nr'] . "'"); $address = tep_db_fetch_array($address_query); //$customer = $account['customers_id']; } To display the extra search box under the drop-down box to search customers on their ID, place the following code UNDER the code for the drop-down box. (around line 102: The code-block of the drop-down box is almost the same as the one below) <?php print "<form action='$PHP_SELF' method='GET'>\n"; print "<table border='0'>\n"; print "<tr>\n"; print "<td><font class=main><b>or by customer ID:</b></font><br><input type=text name='Customer_nr'></td>\n"; print "<td valign='bottom'><input type='submit' value=\"Select customer\"></td>\n"; print "</tr>\n"; print "</table>\n"; print "</form>\n"; ?> so the resulting code looks like this:: <?php print "<form action='$PHP_SELF' method='GET'>\n"; print "<table border='0'>\n"; print "<tr>\n"; print "<td><font class=main><b>Select Customer to Create an Order for:</b></font><br>$SelectCustomerBox</td>\n"; print "<td valign='bottom'><input type='submit' value=\"Select Customer\"></td>\n"; print "</tr>\n"; print "</table>\n"; print "</form>\n"; ?> <?php print "<form action='$PHP_SELF' method='GET'>\n"; print "<table border='0'>\n"; print "<tr>\n"; print "<td><font class=main><b>or by customer ID:</b></font><br><input type=text name='Customer_nr'></td>\n"; print "<td valign='bottom'><input type='submit' value=\"Select customer\"></td>\n"; print "</tr>\n"; print "</table>\n"; print "</form>\n"; ?> Now you can search by name OR by customer ID (don't use them both) Please let me know if you could use this. Greetz. RattleSn@ke
  7. MARY ANN !!!!!!!!! You're da best!!!!!!! I just found out that it indeed didn't work ... AND NOW IT'S WORKING!!! Big hug from me!~ ;) Greetz. RattleSn@ke
  8. Does anyone know a good (html/php)file-compare program?!? So one that lets you see which code is added or deleted?? Thank you. Onno.
  9. Finally I've got this mod working ... BUT, I still run into some problems... 1. When I create manually a customer, and submit the details, I get a javascript runtime error ... :: Small translation: There is a runtime-error Line: 29 Error: 'document.account_edit.confirmation.value' is empty or not an object When I click "no" the customer is added without any problem... Any one an idea how to get rid of this?!? The second problem is as follow: When the customer is manually created, a password is send to it's email-address. But when it wants to login, it gets this error: "Error: No match for E-Mail Address and/or Password." The customer must click the "Forgot password" link in order to get a new one and to log on. Does anyone know a solution or the place to find the source of this problem?! But after all, it's a great script! :) Greetings!
  10. The error you describe is because the function doesn't exist ... You have to delete the "tep_" part from the code ... Then it would work! :) P.S. Zie net dat je nederlander bent ... sorry ... (dat m'n post in 't engels is, maar ja, dan hebben andere er ook wat aan ...)
  11. My wishes are heard ... :D It worked great ... (as far as i tried it ...) Great work!! But, (note: this is just an idea ...) what if you have, let's say: 500 customers ... this would be a big dropdown list then ... Maybe a search fuction for customer-numbers? (i've implemented this in the 'main' customers part in the admin area ... But afterall, a great mod!! Hope that it's soon ready ... Greetz.
×
×
  • Create New...