Jump to content

Mindvision

Members
  • Content count

    13
  • Joined

  • Last visited

1 Follower

Profile Information

  • Real Name
    Justin
  1. Mindvision

    Seperate Pricing Per Customer v3.5

    I spoke to soon!!! The customer admin now loads but I'm now getting this on the customer details listing. Existing Groups: Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /var/www/html/shop/admin/includes/functions/database.php on line 99 I guess the proble originates in customers.php Obviously I can't even cut and paste!!! :unsure: Any help would be very appreciated.
  2. Mindvision

    Seperate Pricing Per Customer v3.5

    Scott, Stupid me!!! I must have deleted: } else { tep_db_query("update " . TABLE_REVIEWS . " set customers_id = null where customers_id = '" . (int)$customers_id . "'"); } I think all is OK now. Thanks very much for you help.
  3. Mindvision

    Seperate Pricing Per Customer v3.5

    Mark, I just tried it and the problem is still there. Thanks anyway. (any other ideas most welcome)
  4. Mindvision

    Seperate Pricing Per Customer v3.5

    Hi, I've just installed SPPC 3.5 on MS 2.2 (tried to) I'm getting the following error message: Parse error: parse error in /var/www/html/shop/admin/customers.php on line 259 I've seen a couple of posts with this problem and I think I followed the install pretty well. Any ideas? Here's the code from line 250 to 265 in my admin/customers.php tep_db_query("delete from " . TABLE_ADDRESS_BOOK . " where customers_id = '" . (int)$customers_id . "'"); tep_db_query("delete from " . TABLE_CUSTOMERS . " where customers_id = '" . (int)$customers_id . "'"); tep_db_query("delete from " . TABLE_CUSTOMERS_INFO . " where customers_info_id = '" . (int)$customers_id . "'"); tep_db_query("delete from " . TABLE_CUSTOMERS_BASKET . " where customers_id = '" . (int)$customers_id . "'"); tep_db_query("delete from " . TABLE_CUSTOMERS_BASKET_ATTRIBUTES . " where customers_id = '" . (int)$customers_id . "'"); tep_db_query("delete from " . TABLE_WHOS_ONLINE . " where customer_id = '" . (int)$customers_id . "'"); tep_redirect(tep_href_link(FILENAME_CUSTOMERS, tep_get_all_get_params(array('cID', 'action')))); break; default: $customers_query = tep_db_query("select c.customers_id, c.customers_gender, c.customers_firstname, c.customers_lastname, c.customers_dob, c.customers_email_address, a.entry_company, a.entry_street_address, a.entry_suburb, a.entry_postcode, a.entry_city, a.entry_state, a.entry_zone_id, a.entry_country_id, c.customers_telephone, c.customers_fax, c.customers_newsletter, c.customers_default_address_id from " . TABLE_CUSTOMERS . " c left join " . TABLE_ADDRESS_BOOK . " a on c.customers_default_address_id = a.address_book_id where a.customers_id = c.customers_id and c.customers_id = '" . (int)$HTTP_GET_VARS['cID'] . "'"); $customers = tep_db_fetch_array($customers_query); $cInfo = new objectInfo($customers); } } ?>
  5. Mindvision

    Advanced Category Box with 3 images

    I've only just got round to trying this - it works! Great bit of information, thanks. I'll put together some images and add it as a contribution. Thanks again Matt (iiinetworks) :D
  6. Mindvision

    Advanced Category Box with 3 images

    Sorry, didn't read the messege properly, I understand now!!! I'll try to get it working then add it as a contribution.
  7. Mindvision

    Advanced Category Box with 3 images

    Thank you for that, I'll give it a try and let you know how it works. Sorry if I sound stupid though but... How does PHP tell which image is for which category level?
  8. I'm trying to customise the Category box to look something like this... Has anyone done this before? Any help would be appreciated.
×