Jump to content

Z3RatuL

Members
  • Content count

    46
  • Joined

  • Last visited

1 Follower

About Z3RatuL

  • Birthday 03/06/1982

Profile Information

  1. Z3RatuL

    PDF Catalog v.1.5

    I tried to use PDF catalog and I successfuly produced a pdf file with all my products. The thing is that my eshop is in Greek language (ISO-8859-7) and fpdf doesn't recognize the language so it diplays all the Greek letters like this: ???????????? ?????? ???????????. I have only one langauge enabled in my shop (Greek) which is the default too, so it doesn't have to do with oscommerce settings There is an ISO-8859-7 file inside the fonts folder of PDF Catalog contribution, but from what I saw fpdf doesn't use it. Anyone has successfuly generated a PDF catalog from a language that uses special characters like Greek, Chinese or something?
  2. From what I read this module might do what I want. I have a store that sells DVDs, Books and Magazines. What I want to accomplish is that when someone buys any product(s) up to 150euro the shipping price will be 3euro (I managed to do that with Table Rate). But, when someone buys Books that cost more than 100euro I want to ship them for free and for magazines that cost more than 200 euro I also want to ship them for free... I kinda think of it as: charge a shipping amount according to the category of the product(s). Anyone knows if this is possible using this module?
  3. Z3RatuL

    [contribution] STS PLUS v4

    Hey guys... I have managed to install STS 4 with the product extra fields contribution. They both work but I have a simple problem at displaying more than one extra field at the product page using STS. I pasted this code which is the product extra fields code: // START: Extra Fields Contribution v2.0b $extra_fields_query = tep_db_query("SELECT pef.products_extra_fields_status as status, pef.products_extra_fields_name as name, ptf.products_extra_fields_value as value FROM ". TABLE_PRODUCTS_EXTRA_FIELDS ." pef LEFT JOIN ". TABLE_PRODUCTS_TO_PRODUCTS_EXTRA_FIELDS ." ptf ON ptf.products_extra_fields_id=pef.products_extra_fields_id WHERE ptf.products_id=".$HTTP_GET_VARS['products_id']." and ptf.products_extra_fields_value<>'' and (pef.languages_id='0' or pef.languages_id='".$languages_id."') ORDER BY products_extra_fields_order"); $counter = tep_db_num_rows($extra_fields_query); if($counter > 0){ while($extra_fields = tep_db_fetch_array($extra_fields_query)) { if(!$extra_fields['status']) // show only enabled extra field continue; $template['product_extra_field_name'] = '<b>'.$extra_fields['name'].': </b>'; $template['product_extra_field_value'] = $extra_fields['value'].'<br>'; } } else { $template['product_extra_field_name'] = ''; $template['product_extra_field_value'] = ''; } // END: Extra Fields Contribution into sts_product_info.php file and it does display the extra fields but it shows only the last field and not all... For example: Say I have a DVD, that I need to display extra fields with the following order: 1. Year 2. Duration of the movie 3. Director 4. Actors 5. Subtitles The page only shows the last field which is Subtitles, even though all other fields are filled properly. Anyone knows a solution? Thanks in advance
  4. Z3RatuL

    [contribution] Simple Template System (sts)

    Hey guys... I have installed STS with the product extra fields contribution. They both work but I have a simple problem at displaying more than one extra field at the product page using STS. I pasted this code which is the product extra fields code: // START: Extra Fields Contribution v2.0b $extra_fields_query = tep_db_query("SELECT pef.products_extra_fields_status as status, pef.products_extra_fields_name as name, ptf.products_extra_fields_value as value FROM ". TABLE_PRODUCTS_EXTRA_FIELDS ." pef LEFT JOIN ". TABLE_PRODUCTS_TO_PRODUCTS_EXTRA_FIELDS ." ptf ON ptf.products_extra_fields_id=pef.products_extra_fields_id WHERE ptf.products_id=".$HTTP_GET_VARS['products_id']." and ptf.products_extra_fields_value<>'' and (pef.languages_id='0' or pef.languages_id='".$languages_id."') ORDER BY products_extra_fields_order"); $counter = tep_db_num_rows($extra_fields_query); if($counter > 0){ while($extra_fields = tep_db_fetch_array($extra_fields_query)) { if(!$extra_fields['status']) // show only enabled extra field continue; $template['product_extra_field_name'] = '<b>'.$extra_fields['name'].': </b>'; $template['product_extra_field_value'] = $extra_fields['value'].'<br>'; } } else { $template['product_extra_field_name'] = ''; $template['product_extra_field_value'] = ''; } // END: Extra Fields Contribution into sts_product_info.php file and it does display the extra fields but it shows only the last field and not all... For example: Say I have a DVD, that I need to display extra fields with the following order: 1. Year 2. Duration of the movie 3. Director 4. Actors 5. Subtitles The page only shows the last field which is Subtitles, even though all other fields are filled properly. Anyone knows a solution? Thanks in advance
  5. Z3RatuL

    [Contribution] Extra Fields

    I have a simple problem at displaying more than one extra field at the product page using STS. I pasted this code: // START: Extra Fields Contribution v2.0b $extra_fields_query = tep_db_query("SELECT pef.products_extra_fields_status as status, pef.products_extra_fields_name as name, ptf.products_extra_fields_value as value FROM ". TABLE_PRODUCTS_EXTRA_FIELDS ." pef LEFT JOIN ". TABLE_PRODUCTS_TO_PRODUCTS_EXTRA_FIELDS ." ptf ON ptf.products_extra_fields_id=pef.products_extra_fields_id WHERE ptf.products_id=".$HTTP_GET_VARS['products_id']." and ptf.products_extra_fields_value<>'' and (pef.languages_id='0' or pef.languages_id='".$languages_id."') ORDER BY products_extra_fields_order"); $counter = tep_db_num_rows($extra_fields_query); if($counter > 0){ while($extra_fields = tep_db_fetch_array($extra_fields_query)) { if(!$extra_fields['status']) // show only enabled extra field continue; $template['product_extra_field_name'] = '<b>'.$extra_fields['name'].': </b>'; $template['product_extra_field_value'] = $extra_fields['value'].'<br>'; } } else { $template['product_extra_field_name'] = ''; $template['product_extra_field_value'] = ''; } // END: Extra Fields Contribution into sts_product_info.php file and it does display the extra fields but it shows only the last field and not all. I checked to see if I enabled all the fields and all are, so it's not a problem from there... For example: Say I have a DVD, that I need to display extra fields with the following order: 1. Year 2. Duration of the movie 3. Director 4. Actors 5. Subtitles The page only shows the last field which is Subtitles, even though all other fields are filled properly. Anyone has a workaround? Thanks in advance
  6. Z3RatuL

    [contribution] Simple Template System (sts)

    OK here we go... This is what you should do: Open column_right.php: ###Add:### // Article Manager require(DIR_WS_BOXES . 'authors.php'); // STS: ADD $sts_block_name = 'authorsbox'; require(STS_RESTART_CAPTURE); // STS: EOADD require(DIR_WS_BOXES . 'articles.php'); // STS: ADD $sts_block_name = 'articlesbox'; require(STS_RESTART_CAPTURE); // STS: EOADD Open sts_display_output: ###Add### $template['authorsbox'] = strip_unwanted_tags($sts_block['authorsbox'], 'authorsbox'); $template['articlesbox'] = strip_unwanted_tags($sts_block['articlesbox'], 'articlesbox'); Then you have to enter: $template['articlesbox'] = strip_unwanted_tags($sts_block['articlesbox'], 'articlesbox'); into the sts_user_code.php file also. After doing that, the boxes work.
  7. Z3RatuL

    [contribution] Simple Template System (sts)

    From what I saw you are using product_info.php.html template file for your product info page and not sts_template.html file. Edit the product_info.php.html istead and you're done! If you want to see for yourself just right click at your website -> view source and look at the very first two lines. It says: <!-- Page layout by Simple Template System (STS) v3.00 Beta 2 on osCommerce 2.2-MS2 - http://www.diamondsea.com/sts/ --> <!-- Using Template File [includes/sts_templates/mysite/product_info.php.html) -->
  8. Z3RatuL

    [contribution] Simple Template System (sts)

    The latest STS Full package is Simple Template System (STS) v3.00 Beta 2 released from the original author DiamonSea. It's beta but it works fine... If you don't wanna use this cause it's beta and it's certain that the standard version should be released sometime, maybe you should use an older version and upgrade later. If you want a good version try using this: Simple Template System (STS) v2.01 and then apply the patch using this: STS 2.01 Bug fixes; and you're done. Now if you use more contribs use the appropriate patch for each contrib.
  9. Z3RatuL

    [contribution] Simple Template System (sts)

    I don't remember the name of the contribution you want but I'm posting here the categories.php file I use at my site that does the thing you want (replace text with image), so you can replace it with your old one (remember to backup your old one first!). The only thing I found is that if you enable cache your categories may not be displayed correctly. <?php /* $Id: categories.php,v 1.20 2002/06/05 19:18:22 dgw_ Exp $ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2002 osCommerce Released under the GNU General Public License */ function tep_show_category($counter) { global $foo, $categories_string, $id, $aa; for ($a=0; $a<$foo[$counter]['level']; $a++) { // $categories_string .= "??"; // $categories_string .= "??"; } //kreseczki start if ($foo[$counter]['level'] == 0) { if ($aa == 1) { // odchaszowac Ώeby dostaζ kreseczkκ // $categories_string .= "<hr noshade size=1>"; $categories_string .= '<img src="images/pixel_silver.gif" border="0" alt="" width="100%" height="1"><br><img src="images/pixel_trans.gif" border="0" alt="" width="100%" height="1">'; } else {$aa=1;} } //kreseczki koniec // display category name // $categories_string .= $foo[$counter]['name']; // Eger alt kategorileri veya Asama0 olanalara varsa OK ekler if (tep_has_category_subcategories($counter) || $foo[$counter]['level'] == 0) { if ( ($id) && (in_array($counter, $id)) ) { // display category name $categories_string .= '<table class="categ"><tr><td class="categ">' . tep_image(DIR_WS_IMAGES . 'categories/arrow_down.gif', '', '9', '9') . "?</td>"; } else { // display category name $categories_string .= '<table class="categ"><tr><td class="categ">' .tep_image(DIR_WS_IMAGES . 'categories/arrow_right.gif', '', '9', '9') . "?</td>"; } } else { $categories_string .= '<table class="categ"><tr><td class="categ">??' .tep_image(DIR_WS_IMAGES . 'categories/arrow_bullet.gif', 'nokta', '9', '9') . "</td>"; } $categories_string .= '<td class="categ"><a href="'; if ($foo[$counter]['parent'] == 0) { $cPath_new = 'cPath=' . $counter; } else { $cPath_new = 'cPath=' . $foo[$counter]['path']; } $categories_string .= tep_href_link(FILENAME_DEFAULT, $cPath_new); $categories_string .= '">'; if ( ($id) && (in_array($counter, $id)) ) { $categories_string .= '<b>'; } //nazwa kategorii $categories_string .= $foo[$counter]['name']; if ( ($id) && (in_array($counter, $id)) ) { $categories_string .= '</b>'; } if (tep_has_category_subcategories($counter)) { $categories_string .= '?'; } $categories_string .= '</a>'; if (SHOW_COUNTS == 'true') { $products_in_category = tep_count_products_in_category($counter); if ($products_in_category > 0) { $categories_string .= '?(' . $products_in_category . ')'; } } // $categories_string .= '<br>'; $categories_string .= '</td></tr></table>'; if ($foo[$counter]['next_id']) { tep_show_category($foo[$counter]['next_id']); } } ?> <!-- categories //--> <tr> <td> <?php $info_box_contents = array(); $info_box_contents[] = array('align' => 'left'); new infoBoxHeading($info_box_contents, false, false); $categories_string = ''; $categories_query = tep_db_query("select c.categories_id, cd.categories_name, c.parent_id from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.parent_id = '0' and c.categories_id = cd.categories_id and cd.language_id='" . $languages_id ."' order by sort_order, cd.categories_name"); while ($categories = tep_db_fetch_array($categories_query)) { $foo[$categories['categories_id']] = array( 'name' => $categories['categories_name'], 'parent' => $categories['parent_id'], 'level' => 0, 'path' => $categories['categories_id'], 'next_id' => false ); if (isset($prev_id)) { $foo[$prev_id]['next_id'] = $categories['categories_id']; } $prev_id = $categories['categories_id']; if (!isset($first_element)) { $first_element = $categories['categories_id']; } } //------------------------ if ($cPath) { $id = split('_', $cPath); reset($id); while (list($key, $value) = each($id)) { $new_path .= $value; unset($prev_id); unset($first_id); $categories_query = tep_db_query("select c.categories_id, cd.categories_name, c.parent_id from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.parent_id = '" . $value . "' and c.categories_id = cd.categories_id and cd.language_id='" . $languages_id ."' order by sort_order, cd.categories_name"); $category_check = tep_db_num_rows($categories_query); while ($row = tep_db_fetch_array($categories_query)) { $foo[$row['categories_id']] = array( 'name' => $row['categories_name'], 'parent' => $row['parent_id'], 'level' => $key+1, 'path' => $new_path . '_' . $row['categories_id'], 'next_id' => false ); if (isset($prev_id)) { $foo[$prev_id]['next_id'] = $row['categories_id']; } $prev_id = $row['categories_id']; if (!isset($first_id)) { $first_id = $row['categories_id']; } $last_id = $row['categories_id']; } if ($category_check != 0) { $foo[$last_id]['next_id'] = $foo[$value]['next_id']; $foo[$value]['next_id'] = $first_id; } $new_path .= '_'; } } tep_show_category($first_element); $info_box_contents = array(); $info_box_contents[] = array('align' => 'left', 'text' => $categories_string ); new infoBox($info_box_contents); ?> </td> </tr> <!-- categories_eof //-->
  10. Z3RatuL

    [contribution] Simple Template System (sts)

    Maybe you have the cache enabled at your site? If you do please disable it and it will work. If not I don't know what it might be <_< Has anyone succeeded on showing the table customers who purchased this product also purchased with a custom sts_product_info template? Cause even at STS 3 beta it's not working... It just displays the table on top of the page before anything else.
  11. Z3RatuL

    [contribution] Simple Template System (sts)

    From what I saw your header images are being downloaded from here: https://secure16.ozhosting.com/images/ While all other images (that are being displayed correctly) are being downloaded from here: https://secure16.ozhosting.com/funatical/shop/images/ Are you sure you have to change the general.php file to make it work? If you leave it as is what's the result?
  12. Z3RatuL

    [contribution] Simple Template System (sts)

    tried that before posting my message. sts doesn't recognize php code when it's in the html template file :(
  13. Z3RatuL

    [contribution] Simple Template System (sts)

    Hey guys.... I'm using STS 2.01 and I have a prob using the table customers who purchased this product also purchased at sts_product_info.php. It just displays all the related products at the top of the store before the template and not where I specified the $alsopurchased tag... I can't update to STS 3 yet cause I used many customized blocks and the site is live... It says at the comments it may not work and this is true... Anyone fixed this or knows a workaround?
  14. WOW that's an awesome QUICK answer! Thanks man it solved the problem. I'm so dumb afterall... :D
  15. I have a weird problem when I try t upload some products. I made a 50 products test file to see if easypopulate works... I upload the csv file without splitting cause it's only 50 products and when it ends it says everything went smooth but when I check to see if the products are there, there's only the last product! Here's an example of easypopulate's output: File uploaded. Temporary filename: /tmp/phpFm2dcf User filename: spectra.csv Size: 9090 | History | History-1 | test1 | test1 | | 7 | 0.00 | | 17/06/2005 | 20 | | Magazines | PCMag | | VAT 19% | Active !New Product! | History | History-2 | test2 | test2 | | 7 | 0.00 | | 17/06/2005 | 20 | | Magazines | PCMag | | VAT 19% | Active Updated | History | History-3 | test3 | test3 | | 7 | 0.00 | | 17/06/2005 | 20 | | Magazines | PCMag | | VAT 19% | Active Updated | History | History-4 | test4 | test4 | | 7 | 0.00 | | 17/06/2005 | 20 | | Magazines | PCMag | | VAT 19% | Active Updated | History | History-5 | test5 | test5 | | 7 | 0.00 | | 17/06/2005 | 20 | | Magazines | PCMag | | VAT 19% | Active Updated | History | History-6 | test6 | test6 | | 7 | 0.00 | | 17/06/2005 | 20 | | Magazines | PCMag | | VAT 19% | Active Updated | History | History-7 | test7 | test7 | | 7 | 0.00 | | 17/06/2005 | 20 | | Magazines | PCMag | | VAT 19% | Active Updated | History | History-8 | test8 | test8 | | 7 | 0.00 | | 17/06/2005 | 20 | | Magazines | PCMag | | VAT 19% | Active Updated | History | History-9 | test9 | test9 | | 7 | 0.00 | | 17/06/2005 | 20 | | Magazines | PCMag | | VAT 19% | Active Updated .... until it reaches the end (50th product) | | | | | | | | | | | | | | | | No products_model field in record. This line was not imported
×