Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.


  • Content count

  • Joined

  • Last visited

1 Follower

About umc

  • Birthday 12/07/1982

Profile Information

  • Real Name
    Mircea Calin
  • Website
  1. Well... I manually ran the scripts, and that's how the output looked, without the full path, but with those constants it looked ok, so I figured Google must see it the same way I see it... no ? :). It's a solution that worked for my problem, and since everybody is kind enough to help everybody, I thought someone else might have this problem, so maybe it helpes someone else too :) Probably the full link didn't appear because of the modifications I did arround here... I made some seo links attempts... :). Anyway, the contributions is very easy to understand and to modify, so most people shouldn't have problems with it :) Congratulations again ;)
  2. Later edit: I miss-spelled a constant... instead of DIR_WS_CATALOG it's DIR_WS_HTTP_CATALOG.
  3. Excelent and simple to install. Indeed, a great contrib. When I generated the sitemaps, I only got relative paths: something like en/comedy/theres-something-about-mary.html instead of http://www.server-name.com/en/comedy/theres-something-about-mary.html but that can be fixed very easily if you add (in all files, googleSitemapCategories, googleSitemapProducts, etc) in line that contains $location = ... the absolute path constants HTTP_SERVER and DIR_WS_CATALOG. For example in the Categories file the original line is $location = tep_href_link(FILENAME_DEFAULT, 'cPath=' . $cID, 'NONSSL', false); if you also have problems with the link, try something like $location = HTTP_SERVER . DIR_WS_CATALOG . tep_href_link(FILENAME_DEFAULT, 'cPath=' . $cID, 'NONSSL', false); . And I also did a little modification, so I'd have links for all languages, because they have different content, and in my case I have also the language and product, category or manufacturer name in the url. If you need that too, you can try adding the following code in each file that interests you (I use only googleSitemapCategories.php, googleSitemapManufacturer.php and googleSitemapProducts.php): in each file, at the begining, right after the $sql variable is defined, add the following code: // added for language support global $languages_id; $old_lang = $languages_id; $res_lang = mysql_query("select languages_id from languages"); $languages_array = array(); while ($row_lang = mysql_fetch_assoc($res_lang)) $languages_array[] = $row_lang["languages_id"]; foreach($languages_array as $value){ $languages_id = $value; // end of add and at the end of each file, before the line echo '</urlset>'; add: // added for language support } // end for each $languages_id = $old_lang; // set back the old language // end of add ...that's it :). For me it worked, because the function tep_href_link (in 'includes/functions/html_output.php') builds the links based on the language ID. So... in case any of you need something similar, this might do the trick :). Best of luck
  4. umc

    dob dropdown

    It is indeed a usefull contribution. I also made the modifications to the order_info.php file (because I have purchase without account and fast easy chechout, so when a guest wants to proceed to checkout he'll fill a form and have an account created) and to the account_edit.php file, where users will end up if they want to change their detailes. But here is not enough to just modify the file, because everytime you go to "change account information" the data shown will be the default one (which is not important when new accounts are about to be created), but if you already have a date set, it will not be shown. So, after you make the modifications from the contrib, at the second step where you are supposed to replace one line <td class="main"><?php echo tep_draw_input_field('dob') . ' ' . (tep_not_null(ENTRY_DATE_OF_BIRTH_TEXT) ? '<span class="inputRequirement">' . ENTRY_DATE_OF_BIRTH_TEXT . '</span>': ''); ?></td> with block (I added line numbers to explain better the modifications): 1. <td class="main"> 2. <?php 3. for ($i=1; $i<32; $i++) { 4. $dob_day_arr[] = array('id' => sprintf('%02d', $i), 'text' => sprintf('%02d', $i)); 5. } 6. for ($i=1; $i<13; $i++) { 7. $dob_month_arr[] = array('id' => sprintf('%02d', $i), 'text' => strftime('%B',mktime(0,0,0,$i,1,2000))); 8. } 9. $today = getdate(); 10. $first_year = $today['year'] - 77; 11. $last_year = $today['year'] - 17; 12. for ($i=$first_year; $i < $last_year; $i++) { 13. $dob_year_arr[] = array('id' => sprintf('%02d', $i), 'text' => sprintf('%02d', $i)); 14. } 15. echo tep_draw_pull_down_menu('dob_day', $dob_day_arr); 16. echo tep_draw_pull_down_menu('dob_month', $dob_month_arr); 17. echo tep_draw_pull_down_menu('dob_year', $dob_year_arr); 18. echo tep_not_null(ENTRY_DATE_OF_BIRTH_TEXT) ? '<span class="inputRequirement">' . ENTRY_DATE_OF_BIRTH_TEXT . '</span>': ''; 19. ?> 20. </td> Before line 15 add the following code: $s_dob = $account['customers_dob']; $dob_year = substr($s_dob, 0, 4); $dob_month = substr($s_dob, 5, 2); $dob_day = substr($s_dob, 8, 2); And lines 15, 16 and 17 become: echo tep_draw_pull_down_menu('dob_day', $dob_day_arr, $dob_day); echo tep_draw_pull_down_menu('dob_month', $dob_month_arr, $dob_month); echo tep_draw_pull_down_menu('dob_year', $dob_year_arr, $dob_year); ...that's it :). The values from the day of birth will be displayed in the combo-boxes. Hope it helped anyone. Best regards
  5. umc

    [Contribution] Extra Fields

    Ok... there have been people having the same problem as I did... Here are their posts: http://www.oscommerce.com/forums/index.php?s=&...ndpost&p=787317 http://www.oscommerce.com/forums/index.php?s=&...ndpost&p=771277 http://www.oscommerce.com/forums/index.php?s=&...ndpost&p=846297 http://www.oscommerce.com/forums/index.php?s=&...ndpost&p=709172 http://www.oscommerce.com/forums/index.php?s=&...ndpost&p=737856 and my post: http://www.oscommerce.com/forums/index.php?s=&...ndpost&p=853480 This are only some of the problems... Who knows how many others have this same problem... :( So it can't be something we're all screwing up... No one has any ideea where it goes wrong ? :'(
  6. Well... I don't know exactly what the heck I did, but now I can see what others purchased too... :D. I turned on cache, to see if that was the problem, then I turned it off, purchased some more products to make sure, and I entered with another account to see if I choose one product if I see what others purchased, and it worked. I think that in the first case I might have had some products purchased that are not present in the catalog anymore, so my guess it's that probably that's why I didn't see any products, because only one was in the catalog and I was watching it... Bye and have a nice day :)
  7. I also have the same problem... I checked the values set in the admin, for "Also Purchased", (min = 1, max = 6), I've overwritten the file from http://www.oscommerce.com/community/contri...rch,also+bought , but I still can't see the Also Purchased box (and I checked in the pages of two products that I bought, and with a guest account and other account, but still haven't seen anything...)... or where should I see what other users purchased ? I also have STS 4.1. Should I modify something in order to see that ? Thanks for any ideeas... Best of luck
  8. You might want to try and read the posts from here: http://www.oscommerce.com/forums/index.php?s=&...ndpost&p=858751 I was also confused as of how to merge the two contribution, but I figured it out... also read the instruction carefully and you will see what you have to do with your boxes scripts... Hope you'll manage. Best of luck ;)
  9. umc

    [Contribution] STS v4

    Oh well... I just skipped those files... I don't need to skin columns, header and footer anyway. The boxes work ok. I presume I can change the template to look like the boxes. Please corect me if I'm wrong :). Btw... do you know the support thread of Infobox skin manager ? I haven't found it with search... Cheers.
  10. umc

    [Contribution] STS v4

    Has anyone installed Infobox skin manager over STS ? I'm trying to do that now, but I'm a bit confused about the replacement files... let's say that the most confusing is /catalog/includes/column_left.php. After adding sts, the begining of the file looks smth like: ... Released under the GNU General Public License */ // START STS 4.1 if ($sts->display_template_output) { $sts->stop_capture(); include DIR_WS_MODULES.'sts_inc/sts_column_left.php'; } else { //END STS 4.1 ?> <table border="0" width="100%" cellspacing="3" cellpadding="3"> <tr> ... but the begining of the file from the infobox skin manager zip looks something like: ... Released under the GNU General Public License */ if (COLUMN_LEFT_SLICE_SET != 0){ $slice_set = COLUMN_LEFT_SLICE_SET; $bgcol = constant('INFOBOX_SKIN_BGCOL' . $slice_set); echo '<table border="0" width="100%" cellspacing="0" cellpadding="0"'; echo '<tr height="100%">'; echo '<td width="' . BOX_WIDTH . '" valign="top" height="100%">'; echo '<table cellspacing="0" cellpadding="0" border="0" height="100%"><tr><td><img src="images/slice_sets/' . $slice_set . '/top_left.jpg"></td>' . '<td background = "' . DIR_WS_IMAGES . 'slice_sets/' . $slice_set . '/top_background.jpg" class="newinfobox_top' . $slice_set . '" valign="middle" align="center" width="100%">' . $header_text; echo '</td><td><img src="images/slice_sets/' . $slice_set . '/top_right.jpg"></td></tr>'; echo '<tr><td background = "' . DIR_WS_IMAGES . 'slice_sets/' . $slice_set . '/left_background.jpg" height="100%"></td>'; echo '<td bgcolor = "' . $bgcol . '" valign="top" width="100%" height="100%">'; echo '<table cellspacing="0" cellpadding="0" border="0">'; } else { ?> <table border="0" width="100%" cellspacing="3" cellpadding="3"> <tr> ... How exactly am I supposed to merge this two files so everything would be fine ? Are there other cases where I should be carefull about the merging of files ? (header.php, footer.php, column_left.php, column_right.php) Thanks for any info.
  11. umc

    [Contribution] Extra Fields

    I must have been blind for not seing frost77's post earlier about the wrong querry... Now the search works fine... but I still can't see the extra fields in the product_info page... Nobody found an answer ? I can't disable SE Friendly URLS as wkdwich said, because I use Advanced SEO URLs and it won't work if I disable SE Friendly URLS. Since lot's of people are having the same problem I don't think there's something wrong with my store... (I hope ^_^). Any tips or bits advice will be most welcome... Best of luck.
  12. umc

    [Contribution] STS v4

    @itnchans you can start in /catalog/includes/sts_templates/ folder. There you have two templates, Test and Full, but first you have to enable the shop to use templates, from the Administration side, by going to Modules -> STS -> Default -> Install. You can set it up to use the Test template for starters, and then start modifying the way sts_template.html looks (found in the includes/sts_templates/test/ folder). And also read the documentation, because there are lots of usefull informations there too... (STS4.doc, found in the sts4.1 archive) @contrib developers I thought of a feature that is not present in the contribution and some people might find usefull... For example, I had to modify the templates so they wouldn't show some boxes and informations when an affiliate is loged in, so I had to design a template for each page (and for the affiliate there are about 20 or so files) that can show up when an affiliate is logged in. It's basically the same html, but with different names... affiliate_banners.php.html, affiliate_clicks.php.html, etc... Wouldn't it be a nice ideea to have a feature somewhere in the administration panel where you could say something like "I want to use <this> template for the following pages: <script1>,<script2>..." ? Or is there another way in the present to do this ? Because in this case, the different affiliate files are not like cathegories or products where you could just pass an ID or smth... it would be very good to have something like that, cause in that way you could design a single html and modify it easily so it would show in all cases, instead of copying the file for each script, each time you modify it :) Best of luck for everybody... PS: I have STS 4.1 and HTC 2.5.9 and they work great together. Before, I had STS 3 and HTC 2.5.5, but the HTC didn't work ok. I didn't update to get to the new versions, instead I removed the old versions completelly and then reinstalled the new ones. Maybe some of you would say that it's too difficult to remove them, but I had installed other contributions in the meanwhile, so I know how it is, but still it's the best way to make sure the instalation works fine... (when you install HTC, don't modify the files from the catalog, just copy the new ones, and in the admin side remember to specify at the STS module that "Files for normal template" would have to use sts_user_code.php;headertags.php)
  13. umc

    [Contribution] Extra Fields

    I noticed that the search is not working after I installed the product extra fields contribution. I get the following error in advanced_search_result.php: 1066 - Not unique table/alias: 'pd' select count(distinct p.products_id) as total from (products p left join products_to_products_extra_fields p2pef on p.products_id=p2pef.products_id) left join manufacturers m on m.manufacturers_id=p.manufacturers_id, products_description pd left join specials s on p.products_id = s.products_id, categories c, products_to_categories p2c, products_description pd, categories c, products_to_categories p2c where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and ((pd.products_name like '%test%' or p.products_model like '%test%' or m.manufacturers_name like '%test%' or p2pef.products_extra_fields_value like '%test%' or pd.products_description like '%test%') ) My line goes something like: $from_str = "from (" . TABLE_PRODUCTS . " p left join " . TABLE_PRODUCTS_TO_PRODUCTS_EXTRA_FIELDS . " p2pef on p.products_id=p2pef.products_id) left join " . TABLE_MANUFACTURERS . " m on m.manufacturers_id=p.manufacturers_id, " . TABLE_PRODUCTS_DESCRIPTION . " pd left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_CATEGORIES . " c, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c"; instead of the old line $from_str = "from " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m using(manufacturers_id) left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id"; I know it's somewhere arround line 215, where the $from_str is build, but I can't figure out where I screw up... :(. If you have the search running fine, could you please show me the lines from the file ? And the product extra fields still don't show up in the product_info page... No clues to that either ? I removed STS and HTC (for other purposes) and tested without them, and I still don't see the extra fields... :( Thanks.
  14. Finally... this version worked great. Before, I had STS 3 and HTC 2.5.5, but HTC didn't work as it should. Now I removed STS 3, installed STS 4.1, removed HTC 2.5.5 (completelly) and installed HTC 2.5.9, but only database, admin side and copied the new files in the catalog side, but I haven't modified the files from the catalog side, and now it works ok. So in case someone else has problems with STS and HTC, this versions worked for me. Also read in the docs of STS what else you must do when you install STS to have HTC working with it. I also run in the same problem as I head with HTC 2.5.5: double slashes in the admin side. If someone else has this problem, look at post http://www.oscommerce.com/forums/index.php?sho...78entry762178 and a few posts after to see a solution... Hope this helps someone :)
  15. umc

    [Contribution] Extra Fields

    I also have problems with product extra fields... The installation went fine, I got no errors, I added a test field, modified it's value for a keyboard, in the preview everything is fine. If I purchase the keyboard, in the confirmation email I see the field (I've done that optional step, to have extra fields written in emails), but I still can't see the information in the product information page... I used sts, but I temporarily uninstalled it (I had to do an upgrade anyway) because I thought there was a problem with some placeholders or smth, but even without STS, I can't see the extra fields... I've seen that at least 3 or 4 people wrote here about the same problem, but I haven't seen a solution... :( If someone knows what the problem is, I'm sure a lot of user would apreaciate the solution, including me :) Thanks in advanced for anyone who can provide a fix for this great contribution... Best of luck