Jump to content

Jan Zonjee

  • Content count

  • Joined

  • Last visited

  • Days Won


Jan Zonjee last won the day on September 10

Jan Zonjee had the most liked content!

About Jan Zonjee

  • Rank
    Governor of Peace

Profile Information

Recent Profile Visitors

157,140 profile views
  1. Jan Zonjee

    What are the advantages of QuickBooks hosted on cloud?

    I'm sure ;you are going to tell us soon via an another account.
  2. Jan Zonjee

    sql syntax error any ideas

    Looks to me that "< ? php /* */ " shouldn't be part of the SQL syntax. But what about the spaces in "< ? php" Shouldn't it be "<?php" ?
  3. Jan Zonjee

    Paypal App - Incorporation of mods in new admin/orders.php

    Yes, that would need to be changed. Would this work? : <?php echo $this->customer['customers_group_name']; ?></p> instead of: <?php echo $order->customer['customers_group_name']; ?></p>
  4. Jan Zonjee

    Paypal App - Incorporation of mods in new admin/orders.php

    Sounds like the best option. Haven't tried this so just writing queries from what I remember of them :-) : admin/classes/order.php around line 30: function query($order_id) { global $languages_id; $order_id = tep_db_prepare_input($order_id); $order_query = tep_db_query("select customers_id, customers_name, customers_company, customers_street_address, customers_suburb, customers_city, customers_postcode, customers_state, customers_country, customers_telephone, customers_email_address, customers_address_format_id, delivery_name, delivery_company, delivery_street_address, delivery_suburb, delivery_city, delivery_postcode, delivery_state, delivery_country, delivery_address_format_id, billing_name, billing_company, billing_street_address, billing_suburb, billing_city, billing_postcode, billing_state, billing_country, billing_address_format_id, payment_method, cc_type, cc_owner, cc_number, cc_expires, currency, currency_value, date_purchased, orders_status, last_modified from " . TABLE_ORDERS . " where orders_id = '" . (int)$order_id . "'"); $order = tep_db_fetch_array($order_query); // BOF SPPC $customer_group_query = tep_db_query("select cg.customers_group_name from " . TABLE_CUSTOMERS . " c, " . TABLE_CUSTOMERS_GROUPS . " cg on c.customers_group_id = cg. customers_group_id where c.customers_id = " . $order['customers_id'] . " "); $customer_group_info = tep_db_fetch_array($customer_group_query); // EOF SPPC and then later (around line 71 now): $this->customer = array('id' => $order['customers_id'], 'name' => $order['customers_name'], 'company' => $order['customers_company'], 'street_address' => $order['customers_street_address'], 'suburb' => $order['customers_suburb'], 'city' => $order['customers_city'], 'postcode' => $order['customers_postcode'], 'state' => $order['customers_state'], 'country' => array('title' => $order['customers_country']), 'format_id' => $order['customers_address_format_id'], // BOF SPPC 'customers_group_name' => $customer_group_info['customers_group_name'], // EOF SPPC 'telephone' => $order['customers_telephone'], 'email_address' => $order['customers_email_address']);
  5. Jan Zonjee

    bmp images for products

    bmp is not a format normally used on webpages. http://www.htmlgoodies.com/primers/html/article.php/3478181/Basic-HTML-Images.htm Even though some browers, such as Internet Explorer, will allow you to place a BMP as an image, I wouldn't. Most browsers will not be able to display it. Go with .gif, .jpg or .png. Not a clue. Maybe too big and over the size limit PHP will allow?
  6. Jan I try of install Add on Separate Pricing Per Customer (SPPC) Version 4.2.2, I changed codes and files necessary followed of the instructions and when finish, only view logo oscommerce, and nothing more. In the Catalog and Admin Panel.

  7. Jan I need help installing the Add on Separate Pricing Per Customer 4.2.2 for RC2a. You have documentation or how much cost install this Add on in my site?.

  8. Because you don't want to start with those outdated data in those tables.
  9. Jan Zonjee

    10 free templates

    Could it be you are just uploading a text file where to download a template? That's not allowed. It should be availabe/downloadable from the osC addon site.
  10. Jan Zonjee

    [Contribution] Cross Sell (X-Sell) Admin

    Is that file (xsell_products.php) actually there in catalog/includes/modules/ ?
  11. Jan Zonjee

    [contribution] Total B2B

    The ALL CAPITALS filenames point to missing constants. Probably, you missed adding these constants to the file admin/includes/filenames.php. Something like: define('FILENAME_GROUPS', 'groups.php');
  12. Jan Zonjee

    Quantity Price Breaks

    No, but to me a number of things looks suspicious in the above piece of code. In the line: if (tep_not_null($listing['specials_new_products_price'])) { it looks like the [$x] is missing. Also there is a "del" tag in the html-code. I assume most browsers will display it as text with a line through it but the appropriate way to do it is probably using CSS like: <span style="text-decoration: line-through;">
  13. Dear Sir I just PM you my problem cud u help me Pls , I have also posted my problem on the forum at http://forums.oscommerce.com/topic/380867-response-time-of-store-slow-and-specials-by-category-error/

  14. Jan Zonjee

    French charset?

    Not a clue, but I would say, retype that character (or delete it) and try again.
  15. Jan Zonjee

    French charset?

    Perhaps this page is helpful.