Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Denzel

Members
  • Content count

    540
  • Joined

  • Last visited

  • Days Won

    8

Everything posted by Denzel

  1. Denzel

    ULTIMATE Seo Urls 5 - by FWR Media

    Hi @@piernas I have installed USU5 on my 2.3.4 Edge Shop and its great again (w00t) Thank you for porting it ! Unfortunately I have detected, that it eats the "%"-Percent-Signs in the URL, which are used by the Products Filter BS Addon (9374). Is there an easy way to leave them inside the URL ? SEE YA ! Denzel.
  2. Denzel

    View Counter

    The other Contrib which is using the pagination starts a session... if (isset($HTTP_GET_VARS['page'])) { if ( ! tep_session_is_registered('page') ) tep_session_register('page'); $page = $HTTP_GET_VARS['page']; } maybe this is the clue ? SEE YA Denzel.
  3. Denzel

    View Counter

    Hi @@Jack_mcs my PHP Version is 5.6.29. I dont think, that it is a generally problem, cause the page up/down function works on other admin sites. I'll take a look now. SEE YA Denzel.
  4. Denzel

    View Counter

    Hi Forum, hi @@Jack_mcs ! Does anyone knows the problem, that the page changing doesnt work on monitor site ? The links were created correctly (.../view_counter.php?page=2) but it will be ignored completely (Displaying 1 to 20 (of 184 links)). Further I got a Warning: Illegal string offset 'file_name' in .../admin/includes/functions/view_counter.php on line 97 if I try to watch the Hacking attempts from the reports... I try to have a closer look at it today, but maybe someone else has the same issues with the 2.3 BS Edge... SEE YA Denzel.
  5. Hi @@raiwa ! Of course you are right. The above is the source code, the below the debug output... B) SEE YA Denzel.
  6. Hi Forum, I have found the Supportthread for this contrib closed, so I open my own... B) Does anyone use this contrib and has products in multiple categories ? It stores the hidden categories ids in the $hiddencats array. In my shop the products_new.php displays the products as often as they are joined with different categories. The build in sql does the correct thing, but if I hide some (or one) category, the bug appears. My shop is a 2.3 BS Edge one. Here are the querys: if (!empty($hiddencats)) { $listing_sql = "select " . $select_column_list . " p.products_id, SUBSTRING_INDEX(pd.products_description, ' ', 20) as products_description, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = pd.products_id and p.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "' and (not (p2c.categories_id in (" . implode(',', $hiddencats) . ")))"; } else { $listing_sql = "select " . $select_column_list . " p.products_id, SUBSTRING_INDEX(pd.products_description, ' ', 20) as products_description, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "'"; } This is the buggy for better view: select p.products_image, pd.products_name, p.products_id, SUBSTRING_INDEX(pd.products_description, ' ', 20) as products_description, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from products_description pd, products_to_categories p2c, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id left join specials s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = pd.products_id and p.products_id = p2c.products_id and pd.language_id = '2' and (not (p2c.categories_id in (48,48))) order by p.products_id DESC limit 0, 20 Maybe there is a SQL-Crack here, who can help me... :D SEE YA Denzel.
  7. Denzel

    Google XML Sitemap SEO

    Hi @@Jack_mcs ! I got it :D This is the section of sitemap.class.php where the SitemapIndex.xml is build: /** * Function to generate sitemap index file * @[member=author] Bobby Easland * @version 1.1 * @[member=Return] boolean */ function GenerateSitemapIndex(){ $content = '<?xml version="1.0" encoding="UTF-8"?>' . "\n"; $content = '<?xml-stylesheet type="text/xsl" href="gss.xsl"?>' . "\n"; //human readable $content .= '<sitemapindex xmlns="http://www.google.com/schemas/sitemap/0.9">' . "\n"; $pattern = defined('GOOGLE_SITEMAP_COMPRESS') ? GOOGLE_SITEMAP_COMPRESS == 'true' ? "{sitemap*.xml.gz}" : "{sitemap*.xml}" : "{sitemap*.xml}"; foreach ( glob($this->savepath . $pattern, GLOB_BRACE) as $filename ) { if ( preg_match('/index/i', $filename) ) continue; if ( preg_match('/manufacturers/i', $filename) && GOOGLE_XML_SITEMAP_CREATE_MANU != 'true' ) continue; if ( preg_match('/pages/i', $filename) && GOOGLE_XML_SITEMAP_CREATE_PAGES != 'true' ) continue; if ( preg_match('/specials/i', $filename) && GOOGLE_XML_SITEMAP_CREATE_SPECIALS != 'true' ) continue; if ( preg_match('/topics/i', $filename) && GOOGLE_XML_SITEMAP_CREATE_TOPICS != 'true' ) continue; if ( preg_match('/mobile/i', $filename) && GOOGLE_XML_SITEMAP_CREATE_IMAGES != 'true' ) continue; if ( preg_match('/mobile/i', $filename) && GOOGLE_XML_SITEMAP_CREATE_MOBILE != 'true' ) continue; $content .= "\t" . '<sitemap>' . "\n"; $content .= "\t\t" . '<loc>'.$this->base_url . basename($filename).'</loc>' . "\n"; $content .= "\t\t" . '<lastmod>'.date ("Y-m-d", filemtime($filename)).'</lastmod>' . "\n"; $content .= "\t" . '</sitemap>' . "\n"; } # end foreach $content .= '</sitemapindex>'; return $this->SaveFile($content, 'index'); } # end function First, again... In line 541 the dot in front of the "=" is missing. Second: The savepath in line 548 is the serverpath: /homepages/1/a123456789/htdocs/mysite.de/ The script tries to find the sitemaps based on parts of their filenames: preg_match('/index/i', $filename) preg_match('/manufacturers/i', $filename) and so on. Unfortunately it looks for /pages/ too. If you have watched closely, you know that my serverpath contains /homepages/1/a123456789/htdocs/mysite.de/ Thats the reason, why "Enable Standart Pages" was the only way to get some output. The solution is easy: Just tell the script to search for the /sitemappages/. The whole Function now looks like this: /** * Function to generate sitemap index file * @[member=author] Bobby Easland * @version 1.1 * @[member=Return] boolean */ function GenerateSitemapIndex(){ $content = '<?xml version="1.0" encoding="UTF-8"?>' . "\n"; $content .= '<?xml-stylesheet type="text/xsl" href="gss.xsl"?>' . "\n"; //human readable $content .= '<sitemapindex xmlns="http://www.google.com/schemas/sitemap/0.9">' . "\n"; $pattern = defined('GOOGLE_SITEMAP_COMPRESS') ? GOOGLE_SITEMAP_COMPRESS == 'true' ? "{sitemap*.xml.gz}" : "{sitemap*.xml}" : "{sitemap*.xml}"; foreach ( glob($this->savepath . $pattern, GLOB_BRACE) as $filename ) { if ( preg_match('/sitemapindex/i', $filename) ) continue; if ( (preg_match('/sitemapmanufacturers/i', $filename)) && GOOGLE_XML_SITEMAP_CREATE_MANU != 'true' ) continue; if ( (preg_match('/sitemappages/i', $filename)) && GOOGLE_XML_SITEMAP_CREATE_PAGES != 'true' ) continue; if ( (preg_match('/sitemapspecials/i', $filename)) && GOOGLE_XML_SITEMAP_CREATE_SPECIALS != 'true' ) continue; if ( (preg_match('/sitemaptopics/i', $filename)) && GOOGLE_XML_SITEMAP_CREATE_TOPICS != 'true' ) continue; if ( (preg_match('/sitemapimages/i', $filename)) && GOOGLE_XML_SITEMAP_CREATE_IMAGES != 'true' ) continue; if ( (preg_match('/sitemap_mobile/i', $filename)) && GOOGLE_XML_SITEMAP_CREATE_MOBILE != 'true' ) continue; $content .= "\t" . '<sitemap>' . "\n"; $content .= "\t\t" . '<loc>'.$this->base_url . basename($filename).'</loc>' . "\n"; $content .= "\t\t" . '<lastmod>'.date ("Y-m-d", filemtime($filename)).'</lastmod>' . "\n"; $content .= "\t" . '</sitemap>' . "\n"; } # end foreach $content .= '</sitemapindex>'; return $this->SaveFile($content, 'index'); } # end function Now it does what it should do for me. Hope I could help someone not to despair on this old contrib :lol: SEE YA Denzel.
  8. Denzel

    Google XML Sitemap SEO

    Hi @@Jack_mcs, it's me again... Now I figured out, that if I set the "Standart Pages Map" to true, everything goes like it should. <?xml version="1.0" encoding="UTF-8"?> <sitemapindex xmlns="http://www.google.com/schemas/sitemap/0.9"> <sitemap> <loc>http://www.nazzalstraumhochzeit.de/sitemapcategories.xml</loc> <lastmod>2016-12-20</lastmod> </sitemap> <sitemap> <loc>http://www.nazzalstraumhochzeit.de/sitemapimages.xml</loc> <lastmod>2016-12-20</lastmod> </sitemap> <sitemap> <loc>http://www.nazzalstraumhochzeit.de/sitemappages.xml</loc> <lastmod>2016-12-20</lastmod> </sitemap> <sitemap> <loc>http://www.nazzalstraumhochzeit.de/sitemapproducts.xml</loc> <lastmod>2016-12-20</lastmod> </sitemap> </sitemapindex> But no matter what else is set to true, if I set the "Standart Pages Map" to false, the index looks like above again :wacko: No idea... SEE YA Denzel.
  9. Denzel

    Google XML Sitemap SEO

    Hi @@Jack_mcs ! I have just installed the 1.9 Version of Google-XML Sitemap on my 2.3 BS Edge Shop. I cant make a cronjob on my webspace, so I start the script manually. There are no errors, but the Sitemapindex.xml is empty - not at all, looks like this: <?xml version="1.0" encoding="UTF-8"?> <?xml-stylesheet type="text/xsl" href="gss.xsl"?> <sitemapindex xmlns="http://www.google.com/schemas/sitemap/0.9"> </sitemapindex> First the first line dissappears due to a missing "." in front of the "=" in line 541 of the sitemap.class.php. But all the other entrys are missing, too. No matter, if I activate some of the additional sitemaps in admin. The products and categories sitemaps are filled correctly, but without index nothing goes ;) Can you help me ? Thank you ! See Ya ! Denzel.
  10. Hi @ll, hi @@raiwa ! Actually I try to find a contrib thats able to display a random set of products from a choosen category below a product which is ranged in an other choosen category. I think @@naiadomare has tried to do the same about eight years ago in the same thread. Has anyone got this to work ? Or contains this contrib the requested function already ? I would be grateful for any help ! SEE YA ! Denzel.
  11. Denzel

    shop by price

    Hmm.. I see... The headline disappears, if no products matches the range... maybe we can prevent choosing a range which shows no results ? I have to dive deeper... Every help is welcome ;) SEE YA Denzel.
  12. Denzel

    shop by price

    Hi @@raiwa ! Ive just installed this and got a question: Why not place the pulldown in the headline of the product_listing-module ? Between the list/grid switch and the sortorder pulldown is enough free space... Has anyone done this before, or is it my turn again ? SEE YA Denzel.
  13. Hi @@Jack_mcs I have tried almost everything. I think its the same issue that Midijay has descriped a few jears ago. But it is quiet simple: In the draw method of QTpro's pad_base.php the attributes were called one after the other. No chance to sort something. function draw() { $out=$this->_draw_table_start(); $out.=$this->_draw_stocked_attributes(); $out.=$this->_draw_nonstocked_attributes(); $out.=$this->_draw_table_end(); return $out; But I think I can live with that, while only my testitem has stocked and unstocked attributes. The contrib is a very confusing mixture of different other contribs. Attribute sort is affected (but unnecessary) QTpro has a small saying. Something with weights is in the contrib too. Datadasefields were installed but not used... I think if you not really know what you are doing, you are slightly overwhelmed with it. And lets try to put this into the modular BS product info... :- SEE YA Denzel.
  14. OK, I have found the solution: QTpro makes a difference between stocked and nonstocked attributes. The stocked were drawn first, then the nonstocked. Maybe someone can order the array after reading out of the database. At this point my php knowledges ends :wacko: SEE YA Denzel.
  15. Hi @ll ! First thank you to everyone who has worked on this very nice contrib ! But one question is left: I have build this in a BS Edge Shop. Everything works, even the sort order of the Attributes. But actually I dont know why the sort order of the Options itself is not saved. Example: One Product. Two Options: Color and Size. I'm able to order the red and green and S, L, XL appearance. But the order of the appearance of the Color- and Size-Dropdowns will not be saved. I dont know if its a bug or feature. In the database in products_attributes table the products_options_sort_order field is filled with the correct numbers. In products_options the products_options_sort_order field is filled with zeros. Is this prepared for a later version, or have i made a mistake while mounting the contrib into my shop ? Thank you for every help ! SEE YA Denzel.
  16. Hi Jim, are there any plans to adapt this nice contrib for the BS Versions, especially your modular product_info page ? SEE YA Denzel.
  17. I have tried already, but its difficult cause the changes affect the price and the options module... maybe Ill try again tomorrow, today my eyes are to small already -_- SEE YA Denzel.
  18. Hi Jim, thank you for your fast reply. I think I did not have explained it exactly enough. What I mean is a price update without loading the product page again, if you add attributes to your article. Like this one: http://addons.oscommerce.com/info/8968 I have tried to get it to work, but no chance :( SEE YA Denzel.
  19. Hi @ll ! Has anyone an Ajax Price Updater per Attribute got to work with the Modular Product Page ? :wacko: SEE YA Denzel.
  20. Ok, I got it... I had to change if ($product_check['total'] > 0) { //We don't want to add products that don't exist/are not available to if (isset($product_info) && $product_info->product_exists() === true) { //We don't want to add products that don't exist/are not available and global $oscTemplate, $PHP_SELF, $_SESSION, $recently_viewed_string, $product_check; to global $oscTemplate, $PHP_SELF, $_SESSION, $recently_viewed_string, $product_info; in ht_recently_viewed.php. Now the Box is displayed but missing articles would not added to the session. :thumbsup: SEE YA Denzel.
  21. Hi Rainer, I found, that the if ($product_check['total'] > 0) { //We don't want to add products that don't exist/are not available query in ht_recently_viewed.php prevents the display of the box. Seems that this is an issue of the Modular Product Page http://addons.oscommerce.com/info/9453 which I have missed to add to my list... :angry: I have commented out the if query and everthing goes... But what is the replacement ? Maybe its: if (true = $product->product_exists()) { I didnt have tested it... SEE YA Denzel.
  22. Hi Rainer, Now, after a few days adding contribs to my shop, all the boxes has stopped to work. nothing is displayed :wacko: I think the $_SESSION['recently_viewed'] is not set. Ive tried a debug output like this: if (tep_session_is_registered ('recently_viewed') && strlen ($_SESSION['recently_viewed']) > 0) { ... } else { $oscTemplate->addBlock('123'.$_SESSION['recently_viewed'], $this->group); } in bm_recently_viewed. The 123 appears, but nothing else. The headertag module is installed... Is there a known intolerance against any of these contribs: Previous - Next - With detailed info 2016-06-21 Wishlist BS 2016-06-21 Modular Shopping Cart BS 2016-06-23 Ship In Cart BS reloaded 2016-06-23 Latest News Rotator Multilingual 1.0 BS 2016-06-23 dashboard whos online history 2016-06-23 Who's Online Dashboard 2016-06-23 Invoice Editor 1.0 2016-06-26 Run SQL Script from Admin v1.2 for osCommerce 2.3.x 2016-06-27 Ask a Product Question 1.0 for 2.3 2016-06-28 Admin Notes 2016-06-29 Common Product Notes for osCommerce 2.3 2016-06-29 Thank you for helping B) SEE YA Denzel.
  23. @@valquiria23 thank you, but I only have done some copy/paste... The whole work is done by @@burt and @@kymation. Ive uploadet the Contact Us Link in the Addons-Section. SEE YA Denzel.
  24. Ok, this morning Ive changed the "Show the current product" Switch to True and now it does what I want it to do :D Everything is fine :thumbsup: SEE YA Denzel.
  25. Denzel

    [Addon} Theme Switcher

    Hi Jim, its me again ;) Ive just installes the Themeswitcher Module and noticed, that the Scrolling Boxes (Customer Testimonials, Specials and Whats New) doesnt scroll anymore. I think the scroll-functions must be in the bootstrap.min.css, which isnt included when Themeroller is activ. Is there a way to strap out these scroll-css an add it to the code seperately ? Or is the Bug in front of the screen ? :wacko: Thank you again ! SEE YA Denzel.
×