acidrush

Hi ! I have a same problem :(

Anyone know how can I put the configuration pseudo data to submenu? I want to group together the localization, configuration and location/taxes menu with 3 submenu.

Okay! I want to giving back something! One of my friends maked a small code for listing top referal urls data from supertracker contribution! If you have supertracker just put the code somewhere on your admin/index.php This will be listing top referrer site urls to your site.(Like star product) I hope this is helpfull someone ! <table width="428" border="0" cellspacing="0" cellpadding="0"> <tr> <td height="25" background="mindsparx_admin/template/<?php echo ADMIN_TEMPLATE?>/images/adm_box_1.gif"><table width="428" border="0" cellspacing="0" cellpadding="0"> <tr> <td> <span class="text" style="font-weight:bold; color:#FFFFFF;">Top ref</span></td> <td width="100" align="center"><span class="text" style="font-weight:bold; color:#FFFFFF;">count</span></td> </tr> </table></td> </tr> <tr> <td background="mindsparx_admin/template/<?php echo ADMIN_TEMPLATE?>/images/adm_box_2.gif"> <?php //---------supertracker top ref $result=tep_db_query("SELECT *, COUNT(*) as total FROM supertracker WHERE referrer !='' GROUP BY referrer order by total DESC LIMIT 0,10"); // how many links there should be $i=0; // table header echo '<table width="90%" border="0" align="center" cellpadding="4" cellspacing="0" class="text">'; // table data while ($tracker = tep_db_fetch_array($result)) { $i++; echo '<tr> <td style="border-bottom:solid 1px; border-color:#e3e3e3;" class="dataTableContent">'.$i.'</td>'. '<td style="border-bottom:solid 1px; border-color:#e3e3e3;" class="dataTableContent"><a href="'.$tracker['referrer'].'" target="blank">'.$tracker['referrer'].'</td>'. '<td style="border-bottom:solid 1px; border-color:#e3e3e3;" class="dataTableContent">'.$tracker['total'].'</td>'. '</tr>'; } echo '</table>'; ?> </td> </tr> <tr> <td height="10" background="mindsparx_admin/template/<?php echo ADMIN_TEMPLATE?>/images/adm_box_3.gif"></td> </tr> </table> </td> </tr> </table> Thats it! Sorry for my English

Wooow! :D Its working! Now I understand! Many thanx for your help! lol Cheers, Acid

Hi! Sorry about that but my word understandig in English is not the best ! I dont understand all content of the guide. I cant make corectly working submenus. If you can please put here one example box code wich have 1-2 submenu. Maybe I can understand that fast when I see the example. Thank you! Sorry for my English.... Cheers, Acid

Well ! I sad not force (only) the pseudopage problem. I dont have time refill database 'coz too many data. (have any other idea for fix this problem without reinstall database, or any idea how can I save and fill back the database data fast and easy) But I love this contribution, and I think this is the most usefull contrib for this function! I use it in a future too just without using in the pseudopages tags. Cheers, Acid

Oh my god! I have a live shop with so many tag information and spent too many hours to create it. I may not do reinstall headertag tables data to database. I think I do not force this thing then long. Thank you so much for your help but this thing is not worth this much. Thanks for your help. Cheers, Acid

Okay I experimented and puts the code onto good place now! looks like this // information.php case (basename($_SERVER['PHP_SELF']) === FILENAME_INFORMATION): $page = 'information.php?info_id=5'; $parts = explode("?",$page); $parts = explode("=", $parts[1]); if (isset($parts[0])) { $found = false; $name = FILENAME_INFORMATION . "?" . $parts[0] . "="; $pageTags_query = tep_db_query("select * from " . TABLE_HEADERTAGS . " where page_name like '" . $name . "%' and language_id = '" . (int)$languages_id . "'"); if (tep_db_num_rows($pageTags_query) > 0) { while($pageTags = tep_db_fetch_array($pageTags_query)) { if ($name . $_GET[$parts[0]] === $pageTags['page_name']) { $header_tags_array = tep_header_tag_page($pageTags['page_name']); $found = true; break; } } } if (! $found) $header_tags_array = tep_header_tag_page(FILENAME_INFORMATION); } else $header_tags_array = tep_header_tag_page(FILENAME_INFORMATION); break; But the test page indicate this result The number of file entries in the database (28) does not match the number in the includes/header_tags.php file (21). A fájlok nem tartalmazzák a /header_tags.php fájlt: <---means dont have header tags installed on this pages. advanced_search_result.php 1 advanced_search.php 2 aszf.php 3 product_infox.php 4 <--- not original product_info.php / not important review_notice.php 5 shipping.php 6 28 - 21 = 7 The 7 is the information.php?info_id=5. Not changed. The problem is the same. Show only information.php tags instead of information.php?info_id=5. ...and getting permission warning in admin after I changed 755 to 777 :blink: :blink: :blink:

I changed the permission to 777 and got this code above the opening <?php tag in header_tag.php (also code start the first line in header_tag.php) $page = 'information.php?info_id=5'; $parts = explode("?",$page); $parts = explode("=", $parts[1]); if (isset($parts[0])) { $found = false; $name = FILENAME_INFORMATION . "?" . $parts[0] . "="; $pageTags_query = tep_db_query("select * from " . TABLE_HEADERTAGS . " where page_name like '" . $name . "%' and language_id = '" . (int)$languages_id . "'"); if (tep_db_num_rows($pageTags_query) > 0) { while($pageTags = tep_db_fetch_array($pageTags_query)) { if ($name . $_GET[$parts[0]] === $pageTags['page_name']) { $header_tags_array = tep_header_tag_page($pageTags['page_name']); $found = true; break; } } } if (! $found) $header_tags_array = tep_header_tag_page(FILENAME_INFORMATION); } else I think i need manual dropping down that after the <?php but I dont know where. Have you any idea why put codes to wrong place! If this code working I will be happy, but playing with this every time when i add new pseudo pages, this is not so funy! :(

This mean: I need setup the permission for header_tag.php to 777, or else php file's on my server? Sorry but I dont understand all! :( My translator machine (English to Hungarian) sending me too weird text. Please forgive it that I am lame......

Sorry but I dont see this line (// information.php) in header_tags.php My header_tags.php in catalog/inculdes/ looks like this: <?php /* $Id: header_tags_seo.php,v 3.0 2008/01/10 by Jack_mcs osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2003 osCommerce Released under the GNU General Public License */ require_once(DIR_WS_FUNCTIONS . 'header_tags.php'); require_once(DIR_WS_FUNCTIONS . 'clean_html_comments.php'); // Clean out HTML comments from ALT tags etc. $header_tags_array = array(); $sortOrder = array(); $tmpTags = array(); $defaultTags_query = tep_db_query("select * from " . TABLE_HEADERTAGS_DEFAULT . " where language_id = '" . (int)$languages_id . "'"); $defaultTags = tep_db_fetch_array($defaultTags_query); $tmpTags['def_title'] = (tep_not_null($defaultTags['default_title'])) ? $defaultTags['default_title'] : ''; $tmpTags['def_desc'] = (tep_not_null($defaultTags['default_description'])) ? $defaultTags['default_description'] : ''; $tmpTags['def_keywords'] = (tep_not_null($defaultTags['default_keywords'])) ? $defaultTags['default_keywords'] : ''; $tmpTags['def_logo_text'] = (tep_not_null($defaultTags['default_logo_text'])) ? $defaultTags['default_logo_text'] : ''; // Define specific settings per page: switch (true) { // INDEX.PHP case (basename($_SERVER['PHP_SELF']) === FILENAME_DEFAULT): $pageTags_query = tep_db_query("select * from " . TABLE_HEADERTAGS . " where page_name like '" . FILENAME_DEFAULT . "' and language_id = '" . (int)$languages_id . "'"); $pageTags = tep_db_fetch_array($pageTags_query); $catStr = "select categories_htc_title_tag as htc_title_tag, categories_htc_desc_tag as htc_desc_tag, categories_htc_keywords_tag as htc_keywords_tag from " . TABLE_CATEGORIES_DESCRIPTION . " where categories_id = '" . (int)$current_category_id . "' and language_id = '" . (int)$languages_id . "'"; $manStr = "select mi.manufacturers_htc_title_tag as htc_title_tag, mi.manufacturers_htc_desc_tag as htc_desc_tag, mi.manufacturers_htc_keywords_tag as htc_keywords_tag from " . TABLE_MANUFACTURERS . " m LEFT JOIN " . TABLE_MANUFACTURERS_INFO . " mi on m.manufacturers_id = mi.manufacturers_id where m.manufacturers_id = '" . (int)$_GET['manufacturers_id'] . "' and mi.languages_id = '" . (int)$languages_id . "'"; if ($pageTags['append_root'] || $category_depth == 'top' && ! isset($_GET['manufacturers_id']) ) { $sortOrder['title'][$pageTags['sortorder_root']] = $pageTags['page_title']; $sortOrder['description'][$pageTags['sortorder_root']] = $pageTags['page_description']; $sortOrder['keywords'][$pageTags['sortorder_root']] = $pageTags['page_keywords']; $sortOrder['logo'][$pageTags['sortorder_root']] = $pageTags['page_logo']; } $sortOrder = GetCategoryAndManufacturer($sortOrder, $pageTags, $defaultTags, $catStr, $manStr); if ($pageTags['append_default_title'] && tep_not_null($tmpTags['def_title'])) $sortOrder['title'][$pageTags['sortorder_title']] = $tmpTags['def_title']; if ($pageTags['append_default_description'] && tep_not_null($tmpTags['def_desc'])) $sortOrder['description'][$pageTags['sortorder_description']] = $tmpTags['def_desc']; if ($pageTags['append_default_keywords'] && tep_not_null($tmpTags['def_keywords'])) $sortOrder['keywords'][$pageTags['sortorder_keywords']] = $tmpTags['def_keywords']; if ($pageTags['append_default_logo'] && tep_not_null($tmpTags['def_logo_text'])) $sortOrder['logo'][$pageTags['sortorder_logo']] = $tmpTags['def_logo_text']; FillHeaderTagsArray($header_tags_array, $sortOrder); break; // PRODUCT_INFO.PHP // PRODUCT_REVIEWS.PHP // PRODUCT_REVIEWS_INFO.PHP // PRODUCT_REVIEWS_WRITE.PHP case (basename($_SERVER['PHP_SELF']) === FILENAME_PRODUCT_INFO): case (basename($_SERVER['PHP_SELF']) === FILENAME_PRODUCT_REVIEWS): case (basename($_SERVER['PHP_SELF']) === FILENAME_PRODUCT_REVIEWS_INFO): case (basename($_SERVER['PHP_SELF']) === FILENAME_PRODUCT_REVIEWS_WRITE): switch (true) { case (basename($_SERVER['PHP_SELF']) === FILENAME_PRODUCT_INFO): $filename = FILENAME_PRODUCT_INFO; break; case (basename($_SERVER['PHP_SELF']) === FILENAME_PRODUCT_REVIEWS): $filename = FILENAME_PRODUCT_REVIEWS; break; case (basename($_SERVER['PHP_SELF']) === FILENAME_PRODUCT_REVIEWS_INFO): $filename = FILENAME_PRODUCT_REVIEWS_INFO; break; case (basename($_SERVER['PHP_SELF']) === FILENAME_PRODUCT_REVIEWS_WRITE): $filename = FILENAME_PRODUCT_REVIEWS_WRITE; break; default: $filename = FILENAME_PRODUCT_INFO; } $pageTags_query = tep_db_query("select * from " . TABLE_HEADERTAGS . " where page_name like '" . $filename . "' and language_id = '" . (int)$languages_id . "'"); $pageTags = tep_db_fetch_array($pageTags_query); $the_product_info_query = tep_db_query("select p.products_id, pd.products_head_title_tag, pd.products_head_keywords_tag, pd.products_head_desc_tag, p.manufacturers_id from " . TABLE_PRODUCTS . " p left join " . TABLE_PRODUCTS_DESCRIPTION . " pd on p.products_id = pd.products_id where p.products_id = '" . (int)$_GET['products_id'] . "' and pd.language_id ='" . $languages_id . "'"); $the_product_info = tep_db_fetch_array($the_product_info_query); $header_tags_array['product'] = $the_product_info['products_head_title_tag']; //save for use on the logo $tmpTags['prod_title'] = (tep_not_null($the_product_info['products_head_title_tag'])) ? $the_product_info['products_head_title_tag'] : ''; $tmpTags['prod_desc'] = (tep_not_null($the_product_info['products_head_desc_tag'])) ? $the_product_info['products_head_desc_tag'] : ''; $tmpTags['prod_keywords'] = (tep_not_null($the_product_info['products_head_keywords_tag'])) ? $the_product_info['products_head_keywords_tag'] : ''; $catStr = "select c.categories_htc_title_tag as htc_title_tag, c.categories_htc_desc_tag as htc_desc_tag, c.categories_htc_keywords_tag as htc_keywords_tag from " . TABLE_CATEGORIES_DESCRIPTION . " c, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where c.categories_id = p2c.categories_id and p2c.products_id = '" . (int)$the_product_info['products_id'] . "' and language_id = '" . (int)$languages_id . "'"; $manStr = "select mi.manufacturers_htc_title_tag as htc_title_tag, mi.manufacturers_htc_desc_tag as htc_desc_tag, mi.manufacturers_htc_keywords_tag as htc_keywords_tag from " . TABLE_MANUFACTURERS . " m LEFT JOIN " . TABLE_MANUFACTURERS_INFO . " mi on m.manufacturers_id = mi.manufacturers_id where m.manufacturers_id = '" . (int)$the_product_info['manufacturers_id'] . "' and mi.languages_id = '" . (int)$languages_id . "' LIMIT 1"; if ($pageTags['append_root']) { $sortOrder['title'][$pageTags['sortorder_root']] = $pageTags['page_title']; $sortOrder['description'][$pageTags['sortorder_root']] = $pageTags['page_description']; $sortOrder['keywords'][$pageTags['sortorder_root']] = $pageTags['page_keywords']; $sortOrder['logo'][$pageTags['sortorder_root']] = $pageTags['page_logo']; } if ($pageTags['append_product']) { $sortOrder['title'][$pageTags['sortorder_product']] = $tmpTags['prod_title']; //places the product title at the end of the list $sortOrder['description'][$pageTags['sortorder_product']] = $tmpTags['prod_desc']; $sortOrder['keywords'][$pageTags['sortorder_product']] = $tmpTags['prod_keywords']; $sortOrder['logo'][$pageTags['sortorder_product']] = $tmpTags['prod_title']; } $sortOrder = GetCategoryAndManufacturer($sortOrder, $pageTags, $defaultTags, $catStr, $manStr, true); if ($pageTags['append_default_title'] && tep_not_null($tmpTags['def_title'])) $sortOrder['title'][$pageTags['sortorder_title']] = $tmpTags['def_title']; if ($pageTags['append_default_description'] && tep_not_null($tmpTags['def_desc'])) $sortOrder['description'][$pageTags['sortorder_description']] = $tmpTags['def_desc']; if ($pageTags['append_default_keywords'] && tep_not_null($tmpTags['def_keywords'])) $sortOrder['keywords'][$pageTags['sortorder_keywords']] = $tmpTags['def_keywords']; if ($pageTags['append_default_logo'] && tep_not_null($tmpTags['def_logo_text'])) $sortOrder['logo'][$pageTags['sortorder_logo']] = $tmpTags['def_logo_text']; FillHeaderTagsArray($header_tags_array, $sortOrder); break; // SPECIALS.PHP case (basename($_SERVER['PHP_SELF']) === FILENAME_SPECIALS): $pageTags_query = tep_db_query("select * from " . TABLE_HEADERTAGS . " where page_name like '" . FILENAME_SPECIALS . "' and language_id = '" . (int)$languages_id . "'"); $pageTags = tep_db_fetch_array($pageTags_query); // Build a list of ALL specials product names to put in keywords $new = tep_db_query("select p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_image, s.specials_new_products_price from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_SPECIALS . " s where p.products_status = '1' and s.products_id = p.products_id and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' and s.status = '1' order by s.specials_date_added DESC "); $row = 0; $the_specials=''; while ($new_values = tep_db_fetch_array($new)) { $the_specials .= clean_html_comments($new_values['products_name']) . ', '; } if (strlen($the_specials) > 30000) //arbitrary number - may vary with server setting $the_specials = substr($the_specials, 0, 30000); //adjust as needed if ($pageTags['append_root']) { $sortOrder['title'][$pageTags['sortorder_root']] = $pageTags['page_title']; $sortOrder['description'][$pageTags['sortorder_root']] = $pageTags['page_description']; $sortOrder['keywords'][$pageTags['sortorder_root']] = $pageTags['page_keywords']; $sortOrder['logo'][$pageTags['sortorder_root']] = $pageTags['page_logo']; } $sortOrder['keywords'][10] = $the_specials;; if ($pageTags['append_default_title'] && tep_not_null($tmpTags['def_title'])) $sortOrder['title'][$pageTags['sortorder_title']] = $tmpTags['def_title']; if ($pageTags['append_default_description'] && tep_not_null($tmpTags['def_desc'])) $sortOrder['description'][$pageTags['sortorder_description']] = $tmpTags['def_desc']; if ($pageTags['append_default_keywords'] && tep_not_null($tmpTags['def_keywords'])) $sortOrder['keywords'][$pageTags['sortorder_keywords']] = $tmpTags['def_keywords']; if ($pageTags['append_default_logo'] && tep_not_null($tmpTags['def_logo_text'])) $sortOrder['logo'][$pageTags['sortorder_logo']] = $tmpTags['def_logo_text']; FillHeaderTagsArray($header_tags_array, $sortOrder); break; // ALL OTHER PAGES NOT DEFINED ABOVE default: $header_tags_array['title'] = tep_db_prepare_input($defaultTags['default_title']); $header_tags_array['desc'] = tep_db_prepare_input($defaultTags['default_description']); $header_tags_array['keywords'] = tep_db_prepare_input($defaultTags['default_keywords']); break; } echo ' <title>' . $header_tags_array['title'] . '</title>' . "\n"; echo ' <meta name="Title" content="' . $header_tags_array['title'] . '">' . "\n"; // saját echo ' <meta name="Description" content="' . $header_tags_array['desc'] . '">' . "\n"; echo ' <meta name="Keywords" content="' . $header_tags_array['keywords'] . '">' . "\n"; echo ' <meta name="Author" content="xxxxx.">' . "\n"; // saját echo ' <meta name="Generator" content="xxxxx.hu">' . "\n"; // saját if ($defaultTags['meta_google']) echo ' <meta name="googlebot" content="all">' . "\n"; if ($defaultTags['meta_language']) echo ' <meta http-equiv="Content-Language" content="hu">'."\n"; if ($defaultTags['meta_noodp']) echo ' <meta name="robots" content="noodp">' . "\n"; if ($defaultTags['meta_noydir']) echo ' <meta name="slurp" content="noydir">' . "\n"; if ($defaultTags['meta_revisit']) echo ' <meta name="revisit-after" content="3 days">' . "\n"; if ($defaultTags['meta_robots']) echo ' <meta name="robots" content="index, follow">' . "\n"; if ($defaultTags['meta_unspam']) echo ' <meta name="no-email-collection" value="' . HTTP_SERVER . '">' . "\n"; if ($defaultTags['meta_replyto']) echo ' <meta name="Reply-to" content="' . STORE_OWNER_EMAIL_ADDRESS . '">' . "\n"; echo ' <meta http-equiv="Content-Type" content="text/html; charset=' . CHARSET . '">'."\n"; echo '<!-- EOF: Header Tags SEO Generated Meta Tags -->' . "\n"; ?> Or i checked the wrong file? --------------------------------------------------- The root checkbox is set for the pseudo page in page control.

- Yes I can edit pseudo pages tags in page control and save it to database! - I tried add another pseudo pages, and got a same problem. - The test routine dont sow problem whit information.php or pseudo information pages. - The non-pseudo pages works fine and show correctly. One thing: In the pseudo pages show this "information.php?info_id=5. - Magyar" in page control after I add them in database. The "- Magyar" it means Hungarian language. Maybe the problems found here? maybe language routing problem in pseudo pages? I dont know, I'm not so good for codeing. I use only one language in my shop and all other pages work correctly. Sorry for my English Cheers

Hi! This is a helpfull and great contribution, but I have a litlte problem! I try to use the "Add a Pseudo Page" function, but i cant get it to work with information pages unlimited. I ran add missing page and information.php is there with its own tags, then i add information.php?info_id=5 in the pseudo box and update. Then I select information.php?info_id=5 from the drop down box and add tags. Then.... When i select the information page with id 5 i got the tags from the information.php file instead of the id =5 page. I use SEO urls and have rewriting enabled. The url that shows in browser is testpage-i-5.html and accessing this url "information.php?info_id=5" is rewriting to testpage-i-6.html I can see the Tags in the database what I entered to "information.php?info_id=5" (dropdownlist) and looks like everythings fine in the database like other pages. I tried to look up the answer but I did not find one like that what would work for me. Is there a solution to this or is pseudo not intended to work this way or am i doing something wrong. Thanks, Acid

Hi! I have a problem with answers. Look's like something is missing. When I create a new competiton. I can give 3 answer in admin, but the catalog side in competition.php I didn't see the 3 answers. Only the question are there! :blink:

:rolleyes: Thanx to Newtest! Can fixed the problems. 1. The install troubleshooting guide is fixed the problem. 2. In SQL changed the contestant_email to utf8_unicode_ci and looks like working. This is a great contrib! cheers. Acid

Hello! I like this contribution but i have some problems. (I use a 2.0 version) If i try clicking on the add costumers button (in admin) I getting this error message: 1267 - Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_hungarian_ci,IMPLICIT) for operation '<>' SELECT distinct(o.customers_email_address), o.orders_id, o.customers_name, o.customers_email_address FROM orders o, contest c where o.date_purchased > '2009-02-25 00:00:00' AND o.date_purchased < '2009-02-26 00:00:00' AND o.customers_email_address != c.contestant_email AND o.orders_status = 3 order by o.date_purchased ASC and... When I click the subbmit button (in catalog competition page) I getting this error message: 1054 - Unknown column 'competition_code' in 'where clause' select count(*) as total from customers where customers_email_address = '[email protected]' and customers_id = '47' AND competition_code = '007' [TEP STOP] can anyone help? Sorry for my english.... cheers

Hello! Sorry for posting here but I do not know it where I shall turn for council in my problem! Maybe you can help me. I changed some of my product names for better results in google. Its work's well but the the old URL works too and the google saw that's duplicate content. :huh: Example: Old URL : www.mysite.com/product-name-p-176.html New URL : www.mysite.com/different-product-name-p-176.html Different name but same product id and all URL works! If I would recreate again the product with different id. I think I will loosing my postion in google results. (Now the products are in the first place in the Google results.) Have you any idea please? Sorry for my English! Thank you cheers

Hello! Sorry for posting here but I do not know it where I shall turn for council in my problem! Maybe you can help me. (I use this contribution!) I changed some of my product names for better results in google. Its work's well but the the old URL work's too and the google saw that's duplicate content. :blink: Example: Old URL : www.mysite.com/product-name-p-176.html New URL : www.mysite.com/different-product-name-p-176.html Different name but same product id and all URL works! If I would recreate again the product with different id. I think I will loosing my postion in google results. (Now the products are in the first place in the Google results.) Have you any idea please? Sorry for my English! Thank you cheers

I have a same problem. Can anyone help? Thx

Thanks alot! This is solve my problem! :D Great contribution!

This is a good contribution! But i have a litlle problem. When i try import he sql I get this message: I'm newbie and i cant figure what is the problem. Please help me if you can! Sorry for my english Thanks a lot......

When i try import the sql file i get this error message: SQL-kérés: Dokumentáció INSERT INTO configuration( configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added, use_function ) VALUES ( '', 'Automatically Add New Pages', 'HEADER_TAGS_AUTO_ADD_PAGES', 'true', 'Adds any new pages when Page Control is accessed<br>(true=on false=off)', '543', '3', 'tep_cfg_select_option(array(\'true\', \'false\'), ', now( ) , NULL ); MySQL jelzi: Dokumentáció #1366 - Incorrect integer value: '' for column 'configuration_id' at row 1 Can anyone help to this? :( Sorry for my english....