Jump to content

Micke

Members
  • Content count

    193
  • Joined

  • Last visited

Everything posted by Micke

  1. Micke

    Seperate Pricing Per Customer v3.5

    Hi All! I'm finished with the upgrade from Hide products and categories 1.03 to 2.01. It seems to work very well with one small exeption. I have a categories-box contribution installed called Dynamenu. The "tep_db_query" in Dynamenu: $result = tep_db_query('select c.categories_id, cd.categories_name, c.parent_id from ' . TABLE_CATEGORIES . ' c, ' . TABLE_CATEGORIES_DESCRIPTION . ' cd where c.categories_id = cd.categories_id and cd.language_id="' . (int)$languages_id .'" '.$parent_query.'order by sort_order, cd.categories_name'); The hide products "tep_db_query": $categories_query = tep_db_query("select c.categories_id, cd.categories_name, c.parent_id from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.parent_id = '0' and c.categories_id = cd.categories_id and cd.language_id='" . (int)$languages_id ."' and find_in_set('" . $customer_group_id . "', categories_hide_from_groups) = 0 order by sort_order, cd.categories_name"); I thought it looked easy so I have tried several times to edit the Dynamenu query to work with Hide 2.01, but I think I need help! //Micke
  2. Micke

    Address Book Enhancer

    Hi Hobbz! I just downloaded the contrib again, unzipped a fresh address_book_process.php and did a compare... There was a chunk of code (about a dozen lines) missing after the statement that I attached to the prior post. It turns out it was a simple cut-and-paste mistake! Now it works like a charm. Thanks! //Micke
  3. Micke

    Address Book Enhancer

    Hi All! The contribution [v1.1 - 06/06/2005] installed perfectly and all went very smooth. Thank you!! Just one problem though... When my customers press the EDIT buttons next to thier addresses in the address book they recieve the message: "The address book entry does not exist." How come? If I understand this right, the actual error message comes from "catalog/address_book_process.php" Here's the line in the contrib install package: if (isset($HTTP_GET_VARS['edit']) && is_numeric($HTTP_GET_VARS['edit'])) { //rmh addr-enhancer edited next line $entry_query = tep_db_query("select entry_id_name, entry_gender, entry_company, entry_firstname, entry_lastname, entry_street_address, entry_street_address2, entry_suburb, entry_postcode, entry_city, entry_state, entry_zone_id, entry_country_id, entry_telephone, entry_fax from " . TABLE_ADDRESS_BOOK . " where customers_id = '" . (int)$customer_id . "' and address_book_id = '" . (int)$HTTP_GET_VARS['edit'] . "'"); if (!tep_db_num_rows($entry_query)) { $messageStack->add_session('addressbook', ERROR_NONEXISTING_ADDRESS_BOOK_ENTRY); ...and here's mine: // BOF Separate Pricing Per Customer if (isset($HTTP_GET_VARS['edit']) && is_numeric($HTTP_GET_VARS['edit'])) { //rmh addr-enhancer edited next line $entry_query = tep_db_query("select entry_id_name, entry_gender, entry_company, entry_tva_intracom, entry_company_tax_id, entry_firstname, entry_lastname, entry_street_address, entry_street_address2, entry_suburb, entry_postcode, entry_city, entry_state, entry_zone_id, entry_country_id, entry_telephone, entry_fax from " . TABLE_ADDRESS_BOOK . " where customers_id = '" . (int)$customer_id . "' and address_book_id = '" . (int)$HTTP_GET_VARS['edit'] . "'"); // EOF Separate Pricing Per Customer if (!tep_db_num_rows($entry_query)) { $messageStack->add_session('addressbook', ERROR_NONEXISTING_ADDRESS_BOOK_ENTRY); ...as you can see I have SPPC and the E.U VAT Intracom contribs installed, but that should not be a problem, should it? Here's an example link from an EDIT-button: "http://www.whatever.com/address_book_process.php/edit/96 Deleting an address works just as usual.... Any ideas anyone? //Micke
  4. Micke

    Seperate Pricing Per Customer v3.5

    Hi All! For those of you who, like me, has to "hide price if $0" in includes/modules/featured.php... Add: //BOF Here's if price is 0 } elseif ($featured_products[$x]['products_price'] == 0) { $info_box_contents[$row][$col] = array('align' => 'center', 'params' => 'class="smallText" width="' . (floor(100 / $no_of_columns)) . '%" valign="top" style="padding-top: 4px; '. ( $row < $last_row ? 'border-bottom: 1px ' . $border_style_h . ' ' . $color_h . '; ': '') . ( $col < ($no_of_columns - 1) ? 'border-right: 1px ' . $border_style_v . ' ' . $color_v . ';"': '"'), 'text' => '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $featured_products[$x]['products_id']) . '">' . tep_image(DIR_WS_IMAGES . $featured_products[$x]['products_image'], $featured_products[$x]['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '</a><br><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $featured_products[$x]['products_id']) . '">' . $featured_products[$x]['products_name'] . '</a><br>' . ( TEXT_CALL_FOR_PRICE )); //EOF Here's if price is 0 before: } else { $info_box_contents[$row][$col] = array('align' => 'center', 'params' => 'class="smallText" width="' . (floor(100 / $no_of_columns)) . '%" valign="top" style="padding-top: 4px; '. ( $row < $last_row ? 'border-bottom: 1px ' . $border_style_h . ' ' . $color_h . '; ': '') . ( $col < ($no_of_columns - 1) ? 'border-right: 1px ' . $border_style_v . ' ' . $color_v . ';"': '"'), 'text' => '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $featured_products[$x]['products_id']) . '">' . tep_image(DIR_WS_IMAGES . $featured_products[$x]['products_image'], $featured_products[$x]['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '</a><br><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $featured_products[$x]['products_id']) . '">' . $featured_products[$x]['products_name'] . '</a><br>' . $currencies->display_price($featured_products[$x]['products_price'], tep_get_tax_rate($featured_products[$x]['products_tax_class_id']))); } You have to install the Hide Price if $0 for "Quantity Price Breaks for SPPC 4.1.1" contribution first, of course... //Micke
  5. Micke

    Seperate Pricing Per Customer v3.5

    Hi All! To hide products from groups in includes/modules/featured.php JanZ's Featured Products V1.5.2 adapted for Separate Pricing Per Customer v4.1 2006/02/26, change the sql query from: $featured_products_query = tep_db_query("select p.products_id, p.products_image, p.products_tax_class_id, NULL as specstat, NULL as specials_new_products_price, p.products_price, pd.products_name from " . TABLE_PRODUCTS . " p left join " . TABLE_FEATURED . " f using(products_id) left join " . TABLE_PRODUCTS_DESCRIPTION . " pd using(products_id) where p.products_status = '1' and f.status = '1' and pd.language_id = '" . (int)$languages_id . "' order by rand($mtm) DESC limit " . MAX_DISPLAY_FEATURED_PRODUCTS); to: $featured_products_query = tep_db_query("select p.products_id, p.products_image, p.products_tax_class_id, NULL as specstat, NULL as specials_new_products_price, p.products_price, pd.products_name from " . TABLE_PRODUCTS . " p left join " . TABLE_FEATURED . " f using(products_id) left join " . TABLE_PRODUCTS_DESCRIPTION . " pd using(products_id) where p.products_status = '1' and f.status = '1' and find_in_set('" . $customer_group_id . "', products_hide_from_groups) = 0 and pd.language_id = '" . (int)$languages_id . "' order by rand($mtm) DESC limit " . MAX_DISPLAY_FEATURED_PRODUCTS); Works for me... //Micke
  6. Micke

    Seperate Pricing Per Customer v3.5

    Hi All! Now I have succeeded in installing JanZ's Featured Products V1.5.2 adapted for Separate Pricing Per Customer v4.1 2006/02/26. If I've got it right, all that is left for me is to tweak the sql query's to match those from Hide products and categories from groups 2006/06/04 in includes/featured.php and catalog/featured_products.php. Before I start.. Has anyone attempted to do this before? How did you do it? What happened? //Micke
  7. Micke

    Seperate Pricing Per Customer v3.5

    Hi All! Does this mean that there is hope for us who wants to use the SPPC and Bundled Products contributions together?//Micke
  8. Micke

    ODN

    I was wrong, the Admin Access contribution login panel can be filled out but it takes a bit of practice. The panel, with it's centered form, is bigger than the ODN "no-resize" window and the ODN is refreshed before you can fill out both fields and press submit... The trick is to type the username and password in a "notepad" window and do a cut-and-paste move. //Micke
  9. Micke

    New order number

    Hi All! When we recieve an order we type in the order details in our main system. This returns a new 5-digit order number. We have to type this into the order comments box to have any connection to the "osc order number". But it's not possible to find the correlation later... Is it possible to edit the osc order number somehow? Is it possible to add a field to the order with the 5-digit order number and have this showing in the orders overview? //Micke
  10. Micke

    Article Manager v1.0

    Hi All! I'd like to have a box on the Contact us page (in the middle, not in column left or right) with all the authors listed. Name and description, clicking the name would take you to the Authors detail page with lists of articles and so on. Maybe it would be possible to modify the Authors box in some way? // Micke
  11. Hi All! 95SILVER4U uploaded this contrib today. Products & Categories Anywhere "This contribution allows you to get your products and categories listed anywhere - outside of your OSC store; even on a different site." This looks very promising, but it seems like you have to hand over all config information (database passwords and so on) to whoever will show your contents on your site... Is it possible to develop this contrib so you only need to hand over a "key" or something? (Nothing fancy/encrypted/licencing stuff, just a "key" anyone can use to get to the goodies without telling the world this sensitive information...) //Micke
  12. Micke

    Current AUctions V2.0

    Hi All! I have got this contribution up and running, it's very impressive! Thank you all for being a part of creating it! However, in Sweden we have our own version of ebay. How do I connect to it? Here's a link to their english pages... Swedish Ebay Any help would be much appreciated. //Micke
  13. Micke

    Support Tickets

    Hi All! When I append comments, in support tickets, two posts are inserted in the table. Both on admin and catalog side. Looks weird. How do I avoid it? //Micke
  14. Micke

    Article Manager v1.0

    Hi all! Are we all at the point where we can: See the sub topics but not list them in articles.php? Find/Click/Read the article in a subtopic from New or All articles? If this is the case, someone who actually knows php should have a look at whatever lists the articles in articles.php right? I have the problem above and thought it had to do with seo_urls or something, until you guys came along... //Micke
  15. Micke

    Article Manager v1.0

    Hi All! That function is already there. I overwrote it with the one you posted but there's no improvement... The links to the article works fine , both in the "New articles" listing and in the "All articles" listing. It's the listing of the subtopic that does'nt work... //Micke
  16. Micke

    Article Manager v1.0

    Jamez! There is a contribution here:Ultimate SEO URLs for articles Is this the solution to our problem or is this the hack that started it? I can't remember installing it... //Micke
  17. Micke

    Article Manager v1.0

    Hi all! For some reason the subtopics will not get listed on my site... The articles are there, like: http://www.example.com/article-subtopic-a-13.html But they don't get listed in: http://www.example.com/topic-t-3_6.html That gives me a "404"... Is a page missing? //Micke
  18. Perhaps someone who actually understands php could have a look at this and tell me what it takes to make it draw that neat little box around this module like in also_purchased_products.php and so on... <?php $info_box_contents = array(); $info_box_contents[] = array('text' => TEXT_NEW_ARTICLES); new infoBoxHeading($info_box_contents, false, false); $articles_new_query_raw = "select a.articles_id, a.articles_date_added, ad.articles_name, ad.articles_head_desc_tag, au.authors_id, au.authors_name, td.topics_id, td.topics_name from " . TABLE_ARTICLES . " a, " . TABLE_ARTICLES_TO_TOPICS . " a2t left join " . TABLE_TOPICS_DESCRIPTION . " td on a2t.topics_id = td.topics_id left join " . TABLE_AUTHORS . " au on a.authors_id = au.authors_id, " . TABLE_ARTICLES_DESCRIPTION . " ad where a.articles_id = a2t.articles_id and a.articles_status = '1' and a.articles_id = ad.articles_id and ad.language_id = '" . (int)$languages_id . "' and td.language_id = '" . (int)$languages_id . "' order by a.articles_date_added desc, ad.articles_name"; $articles_new_split = new splitPageResults($articles_new_query_raw, MAX_NEW_ARTICLES_PER_PAGE); if ($articles_new_split->number_of_rows > 0) { $articles_new_query = tep_db_query($articles_new_split->sql_query); echo '<table class="listing">'; while ($articles_new = tep_db_fetch_array($articles_new_query)) { $info_box_contents = array( ); echo '<tr>'; echo '<td class="smalltext"> ?<img src="/javascript/jscooktree/ThemeLibrary/page.gif" align="absmiddle">?<a href="' . tep_href_link(FILENAME_ARTICLE_INFO, 'articles_id=' . $articles_new['articles_id']) . '">' . $articles_new['articles_name']. '</a> </td>'; echo '<td class="smalltext"> ?<img src="/javascript/jscooktree/ThemeLibrary/folderopen.gif" align="absmiddle">?<a href="' . tep_href_link(FILENAME_ARTICLES, 'tPath=' . $articles_new['topics_id']) . '">' . $articles_new['topics_name'] . '</a> ? </td>'; echo '<td class="smalltext"> ?'; echo '</tr>'; } echo '</table></div>'; } else { } new infoBox($info_box_contents); ?> //Micke
  19. This a really sweet idea! I've been using it for a while even though It has a few issues... Has anyone out there found out how to: 1. Put it in a box [in the middle, just like new products] 2. Only show a limited number of articles on the main page [i can't get the "define('MAX_NEW_ARTICLES_PER_PAGE', '5');" to work...] This feature is so nice it deserves to be a part of the "Article Manager" contribution. //Micke
  20. Thank you JanZ! I don' know this little the [$x] fellow but that did it for me! //Micke
  21. Even though I have very poor knowledge in PHP I have succeded in installing many contributions. There is however one thing that I have never gotten quite right. It's the part in product_listing.php in the "Hide price if $0"contribution. I want to show all prices in the product listing exept from those at $0. (Installing the contribution right "out of the box" hides all prices in the product listing. Removing it shows all prices with $0 too...) Now I'm trying a different approach, maybe the if-else (for specials) in product listing could be used to select the $0's and show the TEXT_CALL_FOR_PRICE instead... Since I'm a cut-and paste kind of guy I can't make it work. I still hides all prices... Anybody knows what to do? In catalog/includes/modules/product_listing.php case 'PRODUCT_LIST_PRICE': $lc_align = 'right'; if (tep_not_null($listing[$x]['specials_new_products_price'])) { $lc_text = '?<s>' . $currencies->display_price($listing[$x]['products_price'], tep_get_tax_rate($listing[$x]['products_tax_class_id'])) . '</s>??<span class="productSpecialPrice">' . $currencies->display_price($listing[$x]['specials_new_products_price'], tep_get_tax_rate($listing[$x]['products_tax_class_id'])) . '</span>?'; //BOF Here's what I'm trying to do } elseif ($listing['products_price'] == 0) { $lc_text = '?' . ( TEXT_CALL_FOR_PRICE ) . '?'; //EOF Here's what I'm trying to do } else { $lc_text = '?' . $currencies->display_price($listing[$x]['products_price'], tep_get_tax_rate($listing[$x]['products_tax_class_id'])) . '?'; } break;
  22. Hi! I can't find the answer to this (strange, cause I can't be the only one, can I?) Products without images renders this browser window: Products with images renders perfect PDF:s! Question: How do I make this contrib work with products without images too? I tried this tweak: ... but then no images are show even if they exist.
  23. Hey! There must be something missing in this contrib package... I need install instructions. I get: Fatal error: Call to undefined function: tep_loginbox_greeting_top() in /catalog/includes/boxes/loginbox.php on line 49 and so on...
  24. I have installed the PDF Upload and Display v1.0 contribution. [Here's the contribution.] Does anyone know how to add a checkbox like the "Search In Product Descriptions"-checkbox on advanced_search.php and let customer search for products that have a file uploaded? [This contrib can be used for uploading other files than PDF's]
  25. I've got the problem solved the caveman way. Paste this over the stuff at line 120 and on... while(list($key,$val) = each($list)){ if ($GLOBALS['this_level'] != $level) { if ($GLOBALS['this_level'] < $level) $output .= "\n".'<ul>'; elseif ($GLOBALS['this_level'] -1 == $level) $output .= '</ul></li>'."\n"; elseif ($GLOBALS['this_level'] -2 == $level) $output .= '</ul></li></ul></li>'."\n"; elseif ($GLOBALS['this_level'] -3 == $level) $output .= '</ul></li></ul></li></ul></li>'."\n"; elseif ($GLOBALS['this_level'] -4 == $level) $output .= '</ul></li></ul></li></ul></li></ul></li>'."\n"; $GLOBALS['this_level'] = $level; } This takes care of the depth in my categories...
×