Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

acidrush

Pioneers
  • Posts

    22
  • Joined

  • Last visited

Profile Information

  • Real Name
    acid

acidrush's Achievements

  1. 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.
  2. 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
  3. Wooow! :D Its working! Now I understand! Many thanx for your help! lol Cheers, Acid
  4. 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
  5. 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
  6. 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
  7. 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:
  8. 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! :(
  9. 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......
  10. 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.
  11. - 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
  12. 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
  13. 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:
  14. :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
×
×
  • Create New...