Jump to content

snights

Members
  • Content count

    27
  • Joined

  • Last visited

Everything posted by snights

  1. snights

    Product listing

    That did the trick! Awesome!
  2. snights

    Product listing

    @@FWR Media I've sent you a PM with image .png. Another "error". saw that my pixel_trans.gif got a thumbnail now and its white not transparency. Maybe same thing or maby its something wrong with the person behind screen. (me :) )
  3. snights

    Product listing

    great work as alway FWR! .jpg works great. .png dont work. any fix for that? or is it just me? :) another question. is there any tip on how to hide the thumbnail folder? htaccess rewrite? or maby change it to catalog/thumbnail/ instead? thought for secuirty reason? maby useless idont know. just got a feeling thats no reason showing of subfolders like that. thanks again for a great addon! if everyone would be like you.. what a wonderful world.
  4. Have someone succed with make wishlist box to a osc 2.3.1 box? Orginal code is <?php /* $Id: wishlist.php,v 3.0 2005/04/20 Dennis Blake osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Released under the GNU General Public License */ /******************************************************************* ****** QUERY THE DATABASE FOR THE CUSTOMERS WISHLIST PRODUCTS ****** *******************************************************************/ require_once(DIR_WS_LANGUAGES . $language . '/' . FILENAME_WISHLIST); ?> <!-- wishlist //--> <?php $info_box_contents = array(); $info_box_contents[] = array('align' => 'left', 'text' => BOX_HEADING_CUSTOMER_WISHLIST ); new infoBoxHeading($info_box_contents, false, false, tep_href_link(FILENAME_WISHLIST, '','NONSSL')); $info_box_contents = array(); if (is_array($wishList->wishID) && !empty($wishList->wishID)) { reset($wishList->wishID); if (count($wishList->wishID) < MAX_DISPLAY_WISHLIST_BOX) { $wishlist_box = '<table>'; $counter = 1; /******************************************************************* *** LOOP THROUGH EACH PRODUCT ID TO DISPLAY IN THE WISHLIST BOX **** *******************************************************************/ while (list($wishlist_id, ) = each($wishList->wishID)) { $wishlist_id = tep_get_prid($wishlist_id); $products_query = tep_db_query("select pd.products_id, pd.products_name, pd.products_description, p.products_image, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from (" . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd ) left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where pd.products_id = '" . $wishlist_id . "' and p.products_id = pd.products_id and pd.language_id = '" . $languages_id . "' order by products_name"); $products = tep_db_fetch_array($products_query); $wishlist_box .= '<tr><td class="infoBoxContents" valign="top">0' . $counter . '.</td>'; $wishlist_box .= '<td class="infoBoxContents"><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $products['products_id'], 'NONSSL') . '">' . $products['products_name'] . '</a></td></tr>'; $counter++; } $wishlist_box .= '</table>'; } else { $wishlist_box = '<div class="infoBoxContents">' . sprintf(TEXT_WISHLIST_COUNT, count($wishList->wishID)) . '</div>'; } } else { $wishlist_box = '<div class="infoBoxContents">' . BOX_WISHLIST_EMPTY . '</div>'; } $info_box_contents[] = array('align' => 'left', 'text' => $wishlist_box); new infoBox($info_box_contents); ?> <!-- wishlist_eof //--> Also the old include to column_right.php is if($wishList->count_wishlist() != '0') { require(DIR_WS_BOXES . 'wishlist.php'); }
  5. Try <?php } //++++ QT Pro: End Changed Code change that to <?php //++++ QT Pro: End Changed Code That is delete the first "}" So the whole thing should look like <?php //++++ QT Pro: End Changed Code $products_attributes_query = tep_db_query("select count(*) as total from " . TABLE_PRODUCTS_OPTIONS . " popt, " . TABLE_PRODUCTS_ATTRIBUTES . " patrib where patrib.products_id='" . (int)$HTTP_GET_VARS['products_id'] . "' and patrib.options_id = popt.products_options_id and popt.language_id = '" . (int)$languages_id . "'"); $products_attributes = tep_db_fetch_array($products_attributes_query); if ($products_attributes['total'] > 0) { //++++ QT Pro: Begin Changed code $products_id=(preg_match("/^\d{1,10}(\{\d{1,10}\}\d{1,10})*$/",$HTTP_GET_VARS['products_id']) ? $HTTP_GET_VARS['products_id'] : (int)$HTTP_GET_VARS['products_id']); require(DIR_WS_CLASSES . 'pad_' . PRODINFO_ATTRIBUTE_PLUGIN . '.php'); $class = 'pad_' . PRODINFO_ATTRIBUTE_PLUGIN; $pad = new $class($products_id); echo $pad->draw(); } //Display a table with which attributecombinations is on stock to the customer? if(PRODINFO_ATTRIBUTE_DISPLAY_STOCK_LIST == 'True'): require(DIR_WS_MODULES . "qtpro_stock_table.php"); endif; //++++ QT Pro: End Changed Code ?>
  6. Where did you find 15c) Around line 599 find the section of code that reads as follows: } elseif ($action == 'new_product_preview') { if (tep_not_null($HTTP_POST_VARS)) { $pInfo = new objectInfo($HTTP_POST_VARS); $products_name = $HTTP_POST_VARS['products_name']; $products_description = $HTTP_POST_VARS['products_description']; $products_url = $HTTP_POST_VARS['products_url']; } else { $product_query = tep_db_query("select p.products_id, pd.language_id, pd.products_name, pd.products_description, pd.products_url, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_weight, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_status, p.manufacturers_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = pd.products_id and p.products_id = '" . (int)$HTTP_GET_VARS['pID'] . "'"); $product = tep_db_fetch_array($product_query); in admin/categories.php?? all I find thats close to that is. } elseif ($action == 'new_product_preview') { $product_query = tep_db_query("select p.products_id, pd.language_id, pd.products_name, pd.products_description, pd.products_url, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_weight, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_status, p.manufacturers_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = pd.products_id and p.products_id = '" . (int)$HTTP_GET_VARS['pID'] . "'"); $product = tep_db_fetch_array($product_query); $pInfo = new objectInfo($product); $products_image_name = $pInfo->products_image; $languages = tep_get_languages(); for ($i=0, $n=sizeof($languages); $i<$n; $i++) { $pInfo->products_name = tep_get_products_name($pInfo->products_id, $languages[$i]['id']); $pInfo->products_description = tep_get_products_description($pInfo->products_id, $languages[$i]['id']); $pInfo->products_url = tep_get_products_url($pInfo->products_id, $languages[$i]['id']); ? Also same file 15e) Around line 386 find the code that reads as follows: $products_name = $HTTP_POST_VARS['products_name']; $products_description = $HTTP_POST_VARS['products_description']; $products_url = $HTTP_POST_VARS['products_url']; Does not exist
  7. snights

    [Contribution] Cross Sell (X-Sell) Admin

    Anyone got x-sell to work on osc 2.3.1? I got so far that its working in admin and i can create a cross sale. But it wont show up on products_info Any one that have succeeded?
  8. snights

    Create Page Management Module

    Ive tried but well i just gave up and hope someone will make a version for 2.3.1 :) information box looks like this on dynamic information pages <?php /* $Id: information.php,v 1.6 2003/02/10 22:31:00 hpdl Exp $ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2003 osCommerce Released under the GNU General Public License */ ?> <!-- information_pages //--> <tr> <td> <?php //BEGIN Added Lines: Dynamic Information pages $information_pages_query = tep_db_query("select p.pages_id, pd.pages_name from " . TABLE_PAGES . " p, " . TABLE_PAGES_DESCRIPTION . " pd where p.pages_status = '1' and p.pages_id = pd.pages_id and pd.language_id = '" . $languages_id . "' order by p.sort_order, pd.pages_name"); $info_box_contents = array(); $info_box_contents[] = array('text' => BOX_HEADING_INFORMATION); new infoBoxHeading($info_box_contents, false, false); //To use numbered listing like in the bestsellers box: Replace || . tep_image(DIR_WS_IMAGES . 'tri.gif') . || with || . tep_row_number_format($rows) . $rows = 0; while ($information_pages = tep_db_fetch_array($information_pages_query)) { $rows++; $information_list .= '<a href="' . tep_href_link(FILENAME_PAGE_INFO, 'pages_id=' . $information_pages['pages_id'] . '&pages_name=' . $information_pages['pages_name']) . '">' . $information_pages['pages_name'] . '</a><br>'; } //END Added Lines: Dynamic Information pages $info_box_contents = array(); $info_box_contents[] = array('text' => '<a href="' . tep_href_link(FILENAME_SHIPPING) . '">' . BOX_INFORMATION_SHIPPING . '</a><br>' . '<a href="' . tep_href_link(FILENAME_PRIVACY) . '">' . BOX_INFORMATION_PRIVACY . '</a><br>' . '<a href="' . tep_href_link(FILENAME_CONDITIONS) . '">' . BOX_INFORMATION_CONDITIONS . '</a><br>' . '<a href="' . tep_href_link(FILENAME_CONTACT_US) . '">' . BOX_INFORMATION_CONTACT . '</a><br>' . '<a href="' . tep_href_link(FILENAME_IMPRESSUM) . '">' . BOX_INFORMATION_IMPRESSUM . '</a>' //BEGIN Added Lines: Dynamic Information pages . '<br>' . $information_list ); //END Added Lines: Dynamic Information pages new infoBox($info_box_contents); ?> </td> </tr> <!-- information_pages_eof //-->
  9. snights

    Create Page Management Module

    I have tried Information Pages Unlimited for 2.3.1 and the things i didnt get to work was the menu's in catalog and admin. hope there will be a 2.3.1 release on that addon soon :(
  10. snights

    [Addon} Modular Front Page

    no, i only have one language in oscommerce and that swedish. Edit: I also get this error message with "Modular SEO Header Tags 1.2.2" on every "string" module.
  11. snights

    [Addon} Modular Front Page

    Warning: constant() [function.constant]: Couldn't find constant MODULE_FRONT_PAGE_TEXT_MAIN_SWEDISH in E:\www\includes\modules\front_page\text_main.php on line 46" on version "Modular Front Page 1.2.1"
  12. snights

    Google XML Sitemap SEO

    How do i uninstall the SQL? INSERT INTO configuration_group (configuration_group_id, configuration_group_title, configuration_group_description, sort_order, visible) VALUES ('289', 'Google XML SEO', 'Google XML Sitemap SEO Options', '29', '1'); 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 (NULL,'Sitemap file', 'GOOGLE_XML_SITEMAP_SEO', 'Standard', 'Which file to use for the sitemap creation. Use Standard unless it doesn\'t work correctly.<br>(Standard=on Alternate=off)', '289', '1', 'tep_cfg_select_option(array(\'Standard\', \'Alternate\'), ', now(), NULL); 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 (NULL,'Enable Manufacturers Map', 'GOOGLE_XML_SITEMAP_CREATE_MANU', 'false', 'Set to true if you would like a site map created for your manufactureres.<br>(true=on false=off)', '289', '5', 'tep_cfg_select_option(array(\'true\', \'false\'), ', now(), NULL); 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 (NULL,'Enable Specials Map', 'GOOGLE_XML_SITEMAP_CREATE_SPECIALS', 'false', 'Set to true if you would like a site map created for your specials.<br>(true=on false=off)', '289', '7', 'tep_cfg_select_option(array(\'true\', \'false\'), ', now(), NULL); 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 (NULL,'Enable Standard Pages Map', 'GOOGLE_XML_SITEMAP_CREATE_PAGES', 'false', 'Set to true if you would like a site map created for your standard pages.<br>(true=on false=off)', '289', '10', 'tep_cfg_select_option(array(\'true\', \'false\'), ', now(), NULL); 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 (NULL,'Enable Diagnostic Output', 'GOOGLE_XML_SITEMAP_SHOW_DIAGNOSTIC', 'false', 'Set to true if you would like debug information displayed. This is useful if the site maps are not being created correctly.<br>(true=on false=off)', '289', '15', 'tep_cfg_select_option(array(\'true\', \'false\'), ', now(), NULL); 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 (NULL, 'Exclude these pages', 'GOOGLE_XML_SITEMAP_EXCLUDE_PAGES', '', 'Add these pages to the built-in file exclude list. This will prevent the links from being added to the pages site map.', '289', '20', NULL, now(), NULL); DROP something something.. I wanted to update from an older version. Now I have 2 rows of everything in admin->configuration->Google XML Sitemap
  13. Hi, Ive installed a contribution called "oscyoutube" http://addons.oscommerce.com/info/6373 I installed this becus putting youtube embedd code directly into products description made it go error and just gave a blank page. After this contribtion it worked perfectly. I tryed it on my three other computers to and it worked.. But then i tried at my friends place and it gave me error.. It loaded the page so that the logo on the top showed but rest of the page was blank. Tried at another computer samething.. Then another computer it worked and so on.. So about 50% of all the test at the same page and product it worked, the rest 50% it didnt. ?.. Anyone have any idé what it could be? And it uses a code i product_info.php <!-- begin Video Youtube --> <?php $small_youtube = $product_info['products_youtube']; if ($small_youtube == NULL) { echo '<font color="red">NO VIDEO</font>'; } else { $info_box_contents = array(); $info_box_contents[] = array('align' => 'center', 'text' => ' <object width="425" height="344"> <param name="movie" value="http://www.youtube.com/v/'.$small_youtube.'&hl=en&fs=1&rel=0&color1=0x3a3a3a&color2= 0x999999"> </param><param name="allowFullScreen" value="true"> </param><embed src="http://www.youtube.com/v/'.$small_youtube.'&hl=en&fs=1&rel=0&color1=0x3a3a3a&color2= 0x999999" type="application/x-shockwave-flash" allowfullscreen="true" width="425" height="344"></embed></object> '); new infoBox($info_box_contents); } ?> <!-- Video Youtube //-->
  14. snights

    Youtube movie on product info

    Solved. Changed <object width="425" height="344"> <param name="movie" value="http://www.youtube.com/v/'.$small_youtube.'&hl=en&fs=1&rel=0&color1=0x3a3a3a&color2= 0x999999"> </param><param name="allowFullScreen" value="true"> </param><embed src="http://www.youtube.com/v/'.$small_youtube.'&hl=en&fs=1&rel=0&color1=0x3a3a3a&color2= 0x999999" type="application/x-shockwave-flash" allowfullscreen="true" width="425" height="344"></embed></object> To <object type="application/x-shockwave-flash" width="425" height="344" data="http://www.youtube.com/v/'.$small_youtube.'&hl=en&fs=1&rel=0&color1=0x3a3a3a&color2= 0x999999" id="VideoPlayback"> <param name="movie" value="http://www.youtube.com/v/'.$small_youtube.'&hl=en&fs=1&rel=0&color1=0x3a3a3a&color2= 0x999999"> <param name="allowScriptAcess" value="sameDomain"> <param name="quality" value="best"> <param name="bgcolor" value="#FFFFFF"> <param name="scale" value="noScale"> <param name="salign" value="TL"> <param name="FlashVars" value="playerMode=embedded" /> <param name="wmode" value="transparent" /> </object>
  15. snights

    Youtube movie on product info

    Im thinking its maby problem occurs with my lightbox script that it haves "dom:loaded".. a i.e problem?..
  16. snights

    ULTIMATE Seo Urls 5 - by FWR Media

    Is it possible with this contribution to have categories separeted? I mean instead of catalog/tshirt-nice-love-p12.html have catalog/tshirt/nice-love.p12.html ?
  17. snights

    Char Categories

    How do I convert special character å=>aa, ä=>ae, ö=>oe on categories Ultimate SEO 2.7? Product listning is correct exempel: catalog/oevrigt-c-28.html But when im on product info the categories dont convert special special characters but the product does. catalog/övrigt/troeja-p-328.html Current settings: Enable SEO URLs? true Add cPath to product URLs? false Add category parent to begining of URLs? true Filter Short Words 3 Output W3C valid URLs (parameter string)? false Enable SEO cache to save queries? true Enable product cache? true Enable categories cache? true Enable manufacturers cache? true Enable articles cache? true Enable topics cache? true Enable information cache? true Enable link directory cache? true Enable automatic redirects? true Choose URL Rewrite Type Rewrite Enter special character conversions å=>aa, ä=>ae, ö=>oe, é=>e, Å=>Aa, Ä=>Ae, Ö=>Oe Remove all non-alphanumeric characters? false Reset SEO URLs Cache false
  18. Hello folks Ive just installed this great contribution "Product Extra Fields" http://www.oscommerce.com/community/contributions,2202 original it places the extra fields in a row.. as souch Effect: 600w Color: White Weight: 5.1kg e.t.c. And my wishes is to do this "two and two" coloumns... as souch Effect: 600w Color: White Weight: 5.1 kg e.t.c. e.t.c. Anyone who has a idé how to do this? I include the piece of code that i insert in product info.php <?php // START: Extra Fields Contribution v2.0b - mintpeel display fix $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=". (int)$HTTP_GET_VARS['products_id'] ." and ptf.products_extra_fields_value<>'' and (pef.languages_id='0' or pef.languages_id='".(int)$languages_id."') ORDER BY products_extra_fields_order"); echo '<tr> <td> <table border="0" width="50%" cellspacing="0" cellpadding="2px">'; while ($extra_fields = tep_db_fetch_array($extra_fields_query)) { if (! $extra_fields['status']) // show only enabled extra field continue; echo'<tr><td class="main" align="left" valign="middle"><font size="1" color="#666666"><b>'.$extra_fields['name'].': </b>' . stripslashes($extra_fields['value']).'</font></td></tr>'; } echo' </table> </td> </tr>'; // END: Extra Fields Contribution - mintpeel display fix ?>
  19. Hallo Someone who has managed to put together these two add-ons on the index page? Random Products - http://addons.oscommerce.com/info/3410 Product short Description - http://addons.oscommerce.com/info/3123 Random products filen looks like this <?php /* $Id: rnd_products.php,v 1.00 2005/08/09 hpdl Exp $ Contribution: Random Products in Index by: Fabio Andres Herrera Cali - Colombia contact: andres@playstargames.com osCommerce, Open Source E-Commerce Solutions [url="http://www.oscommerce.com"]http://www.oscommerce.com[/url] Copyright © 2003 osCommerce Released under the GNU General Public License */ /* TODO: SELECT RANDOM PRODUCTS EFICENTLY ANY PRODUCT CAN BY PUT IN THE INDEX */ ?> <!-- rnd_products //--> <?php $new_products_query = tep_db_query("select p.products_id, p.products_image, p.products_tax_class_id, if(s.status, s.specials_new_products_price, p.products_price) as products_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where products_status = '1' order by rand() limit " . MAX_DISPLAY_NEW_PRODUCTS); ?> <?php $info_box_contents = array(); $info_box_contents[] = array('text' => sprintf(TABLE_HEADING_NEW_PRODUCTS, strftime('%B'))); new contentBoxHeading($info_box_contents); $info_box_contents = array(); $row = 0; $col = 0; $info_box_contents = array(); while ($new_products = tep_db_fetch_array($new_products_query)) { $new_products['products_name'] = tep_get_products_name($new_products['products_id']); $info_box_contents[$row][$col] = array('align' => 'center', 'params' => 'class="smallText" width="33%" valign="top"', 'text' => '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $new_products['products_id']) . '">' . tep_image(DIR_WS_IMAGES . $new_products['products_image'], $new_products['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '</a><br><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $new_products['products_id']) . '">' . $new_products['products_name'] . '</a><br>' . $currencies->display_price($new_products['products_price'], tep_get_tax_rate($new_products['products_tax_class_id'])) .'<br>'. '<a href="' . tep_href_link(basename($PHP_SELF), tep_get_all_get_params(array('action')) . 'action=buy_now&products_id=' . $new_products['products_id']) . '">' . tep_image_button('button_buy_rnd.gif', IMAGE_BUTTON_BUY_NOW) . '</a> '); $col ++; if ($col > 2) { $col = 0; $row ++; } } new contentBox($info_box_contents); ?> <!-- rnd_products_eof //--> Here I therefore try to get even short description Short desc is normally viewed through this text tab '. $ listing [ 'short_desc']. ' But I understand that this works is not because you have to download from sql database pd.short_desc and it is always under ALTER TABLE `products_description` ADD `short_desc` TEXT; so that only add "pd.short_desc 'work is then of course not in this script. Any suggestions? (Sry about the bad english... blame google translator or my english teacher)
×