Latest News: (loading..)

Denzel

Members
  • Content count

    59
  • Joined

  • Last visited

About Denzel

  • Birthday 06/22/1976

Profile Information

  1. Hi @@annuity, I think @@Jack_mcs is right. My PHP Version is 5.6.30 and I had no errors after installation like you are talking about. SEE YA Denzel.
  2. Hi @@raiwa recently I recognized that the qtpro_sick_product_count() function in header.php from my 2.3.4 BS Edge Shop with QTpro for osc 2.3 V4.6.1 takes about 30 seconds while loading my backend :blink: I'm not sure when this problem occurs, maybe it was a creeping process. I have only 337 products with 19 tracked options in my shop. Do you think that the problem disappears if I update to your 5.2 version ? Do you use the same functions ? I'm unsure to install the update... B) Thank you for helping me ! SEE YA Denzel.
  3. Ok, I allready have found it in usu_general_functions.php: function usu_cleanse( $value ) { return preg_replace( '@[^a-z0-9_]@i', '', $value ); } can be changed to: function usu_cleanse( $value ) { return preg_replace( '@[^a-z0-9_\%]@i', '', $value ); } Now the Percent Character (%) stays in the URL for $_GET usage. But thats not my success, the question allready was asked on 1st February of 2012 by @@zipicip in #3581 of this thread. SEE YA Denzel.
  4. 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.
  5. 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.
  6. 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.
  7. 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.
  8. Hi @@raiwa ! Of course you are right. The above is the source code, the below the debug output... B) SEE YA Denzel.
  9. 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.
  10. Hola @@SpicyGirl, if you are still reading... Sorry it takes a while... But I figured out the problem and have added the new-image-directory-string in the snipplet: // copy the file to the specified dir if (move_uploaded_file($_FILES['products_multiple_images_new']['tmp_name'][$i], DIR_FS_CATALOG_IMAGES . '/' . $dir . $_FILES['products_multiple_images_new']['name'][$i])) { $sql_data_array['image'] = $dir . $_FILES['products_multiple_images_new']['name'][$i]; Thats what the subdir adds to the multi-images-upload :thumbsup: SEE YA Denzel.
  11. 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.
  12. 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.
  13. 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.
  14. Hi @@raiwa ! yes, you are right. Looks like this was the old file from deDokta (RIP). Now Im up to date. Thank you for helping me ! SEE YA Denzel.
  15. Hallo @@raiwa ! Ok, I got it... In the file catalog/account_pwa.php in row 16 is require(DIR_WS_LANGUAGES . $language . '/checkout_pwa.php'); this has to be require(DIR_WS_LANGUAGES . $language . '/account_pwa.php'); BTW the languagefile is buggy: an ";" is missing and a ")" is placed wrong (row 22 and 25). SEE YA Denzel.