Latest News: (loading..)

lelijk

Members
  • Content count

    19
  • Joined

  • Last visited

About lelijk

Profile Information

  • Real Name
    Gekke Gerrit
  1. Is there (PLEASE!!! :'( ) somebody who can update the contribution (+install.txt) to make it complete with the flying image?? I've tried all kind of things mentioned in this thread but.............no luck (or knowledge...hehe).' greetings, Chris
  2. Hi all, First of all THANKS for this great contribution. My question is: I want to integrate the all_products page within the multiple shop system but get lost with the query that get the products..........the query is: $listing_sql = "select p.products_id, p.products_model, pd.products_name, pd.products_description, p.products_image, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, p.products_date_added, m.manufacturers_name from " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id left join " . TABLE_PRODUCTS_DESCRIPTION . " pd on p.products_id = pd.products_id and pd.language_id = '" . $languages_id . "' left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id $where order by pd.products_name"; The problem I have overhere is that I've tried about 30/40 combinations to make this multishop-compatible but.............I'm a PHP/SQL NOOB!!! :blink: Can anyone please help me with this one? Thanks in advance! Chris P.S. Wrongly posted before as new topic, excuse me!
  3. Hi all, First of all THANKS for this great contribution. My question is: I want to integrate the all_products page within the multiple shop system but get lost with the query that get the products..........the query is: $listing_sql = "select p.products_id, p.products_model, pd.products_name, pd.products_description, p.products_image, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, p.products_date_added, m.manufacturers_name from " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id left join " . TABLE_PRODUCTS_DESCRIPTION . " pd on p.products_id = pd.products_id and pd.language_id = '" . $languages_id . "' left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id $where order by pd.products_name"; The problem I have overhere is that I've tried about 30/40 combinations to make this multishop-compatible but.............I'm a PHP/SQL NOOB!!! :blink: Can anyone please help me with this one? Thanks in advance! Chris
  4. it has to be: $sts->start_capture(); require(DIR_WS_BOXES . 'info_page.php'); $sts->stop_capture('infopagebox', 'box'); to create a new box On sts_template.html call the box with: $infopagebox greetings, Chris
  5. Rigadin, Tried to use the other code for making a new box and............IT WORKS, THANKS! :) Now another question: how can I use meta tags within this STS, I tried some dynamic things but didn't get it to work and even with the standard <title>Test</title> in the HEAD nothing happens...........??? I've got NO clue were to do this right, do you?! thanks in advance, Chris
  6. tried the same things with another box on another place and same thing happens........ :( example on: examplesite wtih WRONG box places................
  7. Hi ALL, Tried to make a new box within sts_user_code with: require(DIR_WS_BOXES . 'shop_by_price.php'); $sts->stop_capture('shopbypricebox', 'box'); // or use $sts->restart ('newthingbox', 'box') if another box is following $template['shopbypricebox'] = sts_strip_unwanted_tags($sts->sts_block['shopbypricebox'], 'shopbypricebox'); This way NO error but wherever I put the $shopbypricebox# on index.php.html it ALWAYS shows totally ugly above the header logo?! when I try: require(DIR_WS_BOXES . 'shop_by_price.php'); $sts->restart ('shopbyprice', 'box');// if another box is following $template['shopbypricebox'] = sts_strip_unwanted_tags($sts->sts_block['shopbypricebox'], 'shopbypricebox'); I get an error for the restart call: Fatal error: Call to undefined function: restart() in /var/www/html/includes/modules/sts_inc/sts_user_code.php on line 21 Anybody experienced this before? Not sure were to look for the answer........... I've made one of the example sites (at diamondsea.com) example, so I'm not totally stupid.......?! Any help is greatly appriciated!! greetings, Chris P.S. Great development on STS!
  8. Hi all! I've installed Alternative attribute handling (putting attributes at the products page) and after this I've installed attributes sort order. From the attributes page I can assign attributes but when I do this from the products page, with alternative attribute handling, I get the error: 1136 - Column count doesn't match value count at row 1 insert into products_attributes values ('', '1', '3', '6', '', '') [TEP STOP] I already know this has to do that within the database there are 7 columns and the script is putting 6 in.......... Already tried a couple of things but no luck.........i'm a designer and not a programmer...... :( Can somebody PLEASE look this code and tell me what I have to do to get rid of this error?! The code that had to use: This is the database column: THANKS IN ADVANCE!! Chris
  9. ever heard of the contri Margin Report ? I think it does the same you want to accomplish?! latersssss, Chris