Jump to content

acidrush

Members
  • Content count

    22
  • Joined

  • Last visited

  1. acidrush

    [CONTRIBUTION] Specials on Default.php

    Hi ! I have a same problem :(
  2. acidrush

    [Contribution] Mindsparx admin

    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.
  3. acidrush

    [Contribution] Mindsparx admin

    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
  4. acidrush

    [Contribution] Mindsparx admin

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

    [Contribution] Mindsparx admin

    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
  6. acidrush

    Header Tags SEO

    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
  7. acidrush

    Header Tags SEO

    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
  8. acidrush

    Header Tags SEO

    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:
  9. acidrush

    Header Tags SEO

    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! :(
  10. acidrush

    Header Tags SEO

    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......
  11. acidrush

    Header Tags SEO

    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.
  12. acidrush

    Header Tags SEO

    - 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
  13. acidrush

    Header Tags SEO

    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
  14. acidrush

    Prize Draw Competition help

    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:
  15. acidrush

    Prize Draw Competition help

    :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
×