Jump to content

RattleSn@ke

Members
  • Content count

    13
  • Joined

  • Last visited

1 Follower

Profile Information

  • Real Name
    Onno
  1. RattleSn@ke

    PDF Catalog v.1.5

    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. RattleSn@ke

    PDF Catalog v.1.5

    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. RattleSn@ke

    PDF Catalog v.1.5

    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. RattleSn@ke

    [Contribution] Step-By-Step Manual Order

    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. RattleSn@ke

    [Contribution] Step-By-Step Manual Order

    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. RattleSn@ke

    [Contribution] Step-By-Step Manual Order

    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. RattleSn@ke

    Need testers for manualorder mod

    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. RattleSn@ke

    Need testers for manualorder mod

    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.
×