invasi0n

Anybody can help please?

Hello, I couldn't find the support thread for Hide products from customer groups for SPPC that's why I opened a new one. I need some help with catalog/includes/modules/new_products.php This is the code of my modules/new_products.php. It works perfectly with Separate Pricing Per Customer but I don't know how to modify it for Hide products from customer groups for SPPC <?php /* $Id: new_products.php,v 1.35 2004/02/05 15:50:00 adf Exp $ Randomize New Products adapted for Separate Pricing Per Customer 2006/04/29 $Id: new_products.php,v 1.34 2003/06/09 22:49:58 hpdl Exp $ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2003 osCommerce Released under the GNU General Public License */ ?> <!-- new_products //--> <?php if ( (!isset($new_products_category_id)) || ($new_products_category_id == '0') ) { // start random new products // deleted all reference to specials, only NULL as specials_new_products_price left $new_products_query = tep_db_query("select p.products_id, p.products_image, p.products_price, p.products_tax_class_id, pd.products_name, NULL as specials_new_products_price from " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS . " p where products_status = '1' and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' order by p.products_date_added desc limit " . MAX_RANDOM_SELECT_NEW); } else { // in a category $cats[] = $new_products_category_id; // current catID as starting value // put cat-IDs of all cats nested in current branch into $cats array, go through all subbranches for($i=0;$i<count($cats);$i++) { $categorie_query = tep_db_query("select categories_id from " . TABLE_CATEGORIES . " where parent_id = '" . (int)$cats[$i] . "'"); while ($categorie = tep_db_fetch_array($categorie_query)) { $cats[] = $categorie['categories_id']; } $cats=array_unique($cats); // sort out doubles } $num = (int) MAX_DISPLAY_NEW_PRODUCTS; $new_products_query = tep_db_query("select distinct p.products_id, p.products_image, p.products_price, NULL as specials_new_products_price, p.products_tax_class_id, pd.products_name from " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS . " p , " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_CATEGORIES . " c where p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and c.parent_id in (".implode(', ', $cats).") and p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' order by p.products_date_added desc limit " . MAX_RANDOM_SELECT_NEW); // end random new products } if (tep_db_num_rows($new_products_query) > 0) { $info_box_contents = array(); $info_box_contents[] = array('text' => sprintf(TABLE_HEADING_NEW_PRODUCTS, strftime('%B'))); new contentBoxHeading($info_box_contents); $row = 0; $col = 0; $pCount = 0; $info_box_contents = array(); $found_products = array(); $num_rows = tep_db_num_rows($new_products_query); if (MAX_DISPLAY_NEW_PRODUCTS > MAX_RANDOM_SELECT_NEW) { // don't allow more new products than will be queried $max_new_products = MAX_RANDOM_SELECT_NEW; } else { $max_new_products = MAX_DISPLAY_NEW_PRODUCTS; } if ($num_rows < $max_new_products) { $max_new_products = $num_rows; } if ($num_rows > 0) { // SPPC code to get correct prices if(!tep_session_is_registered('sppc_customer_group_id')) { $customer_group_id = '0'; } else { $customer_group_id = $sppc_customer_group_id; } while ($_new_products = tep_db_fetch_array($new_products_query)) { $new_products[] = $_new_products; $list_of_prdct_ids[] = $_new_products['products_id']; } $select_list_of_prdct_ids = "products_id = '".$list_of_prdct_ids[0]."' "; if ($num_rows > 1) { for ($n = 1; $n < count($list_of_prdct_ids); $n++) { $select_list_of_prdct_ids .= "or products_id = '".$list_of_prdct_ids[$n]."' "; } } // get all customers_group_prices for products with the particular customer_group_id // however not necessary for customer_group_id = 0 if ($customer_group_id != '0') { $pg_query = tep_db_query("select pg.products_id, customers_group_price as price from " . TABLE_PRODUCTS_GROUPS . " pg where (".$select_list_of_prdct_ids.") and pg.customers_group_id = '".$customer_group_id."'"); while ($pg_array = tep_db_fetch_array($pg_query)) { $new_prices[] = array ('products_id' => $pg_array['products_id'], 'products_price' => $pg_array['price'], 'specials_new_products_price' => ''); } for ($x = 0; $x < $num_rows; $x++) { // replace products prices with those from customers_group table if(!empty($new_prices)) { for ($i = 0; $i < count($new_prices); $i++) { if( $new_products[$x]['products_id'] == $new_prices[$i]['products_id'] ) { $new_products[$x]['products_price'] = $new_prices[$i]['products_price']; } } } // end if(!empty($new_prices) } // end for ($x = 0; $x < $num_rows; $x++) } // end if ($customer_group_id != '0') // an extra query is needed for all the specials $specials_query = tep_db_query("select products_id, specials_new_products_price from specials where (".$select_list_of_prdct_ids.") and status = '1' and customers_group_id = '" .$customer_group_id. "' "); while ($specials_array = tep_db_fetch_array($specials_query)) { $new_s_prices[] = array ('products_id' => $specials_array['products_id'], 'specials_new_products_price' => $specials_array['specials_new_products_price']); } // replace NULL with the correct specials_new_products_price if(!empty($new_s_prices)) { for ($x = 0; $x < $num_rows; $x++) { for ($i = 0; $i < count($new_s_prices); $i++) { if( $new_products[$x]['products_id'] == $new_s_prices[$i]['products_id'] ) { $new_products[$x]['specials_new_products_price'] = $new_s_prices[$i]['specials_new_products_price']; } } } } // // end if(!empty($new_s_prices) while ($pCount < $max_new_products) { // choose a random row $random_product = ''; $random_row = tep_rand(0, ($num_rows - 1)); // tep_db_data_seek($new_products_query, $random_row); // $random_product = tep_db_fetch_array($new_products_query); // because the fetch array of the new_products_query has already been done, slightly different // code is used: $random_product = $new_products[$random_row]; // see if found already, if not use else skip $found = 0; for ($ii=0; $ii < $pCount; $ii++) { if ($found_products[$ii] == $random_product['products_id']) { $found = 1; break; } } if ($found == 0) { // keep track of found id's $found_products[$pCount] += $random_product['products_id']; $pCount++; // add to display array // next two queries made obsolete by adapted $new_products_query (products_name) and sppc code (special prices) // $random_product['products_name'] = tep_get_products_name($random_product['products_id']); // $random_product['specials_new_products_price'] = tep_get_products_special_price($random_product['products_id']); if (tep_not_null($random_product['specials_new_products_price'])) { $whats_new_price = '<s>' . $currencies->display_price($random_product['products_price'], tep_get_tax_rate($random_product['products_tax_class_id'])) . '</s> '; $whats_new_price .= '<span class="productSpecialPrice">' . $currencies->display_price($random_product['specials_new_products_price'], tep_get_tax_rate($random_product['products_tax_class_id'])) . '</span>'; } else { $whats_new_price = $currencies->display_price($random_product['products_price'], tep_get_tax_rate($random_product['products_tax_class_id'])); } $product_query = tep_db_query("select products_description from " . TABLE_PRODUCTS_DESCRIPTION . " where products_id = '" . (int)$random_product['products_id'] . "' and language_id = '" . (int)1 . "'"); $product = tep_db_fetch_array($product_query); $random_product['products_description'] = $product['products_description']; $info_box_contents[$row][$col] = array('align' => 'center', 'params' => 'class="smallText" width="25%" align="center" valign="top"', 'text' => '<table class="new_product" border="0" width="100%" height="100%" cellspacing="0" cellpadding="0"> <tr> <td class="new_product_title" align="center" valign="midle" height="82" colspan="4"><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $random_product['products_id']) . '">' . tep_image(DIR_WS_IMAGES . $random_product['products_image'], $random_product['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '</a> </td> </tr> <tr> <td height="12" colspan="4"></td> </tr> <tr> <td class="new_product_price" align="center" valign="top" height="65" colspan="4"><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $random_product['products_id']) . '">' . $random_product['products_name'] . '</a> </td> </tr> <tr> <td class="new_product_price" height="52" width="3%"></td> <td class="new_product_price" height="52" valign="center">Price: ' . $whats_new_price . ' </td> <td class="new_product_price" height="52" valign="center"><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, tep_get_all_get_params(array('action')) . 'action=buy_now&products_id=' . $random_product['products_id']) . '">Buy Now</a></td> <td class="new_product_price" height="52" width="3%"></td> </tr> </table>'); $col ++; if ($col > 3) { $col = 0; $row ++; } } // found } // while pCount } // num_rows // end random new products new contentBox($info_box_contents); } ?> <!-- new_products_eof //--> Thanks.

Download Link - Image Magic - On-the-fly thumbnails, watermarks and image processing and Installation Instructions

Hi, I think this contribution is made for catalog part, not for admin. When I installed this contribution, I modified catalog part only. And about watermark, i tried only "Text Watermark" function, which I like more then "Graphic Watermark".

BTW, I noticed something on your website... I don't think those 2 links "Login de Clientes" and "Sair da TUA conta" in your header look professional. Go to includes/header.php, find <tr><td><img src="images/m07.gif" align="absmiddle" height="8" width="8"> <a style="font-size: 10px;" href="login.php" class="ml">Login de Clientes</a><br></td></tr> <tr><td><img src="images/m07.gif" align="absmiddle" height="8" width="8"> <a style="font-size: 10px;" href="logoff.php" class="ml">Sair da TUA conta</a><br><br></td></tr> and replace with <tr><td><img src=images/m07.gif width=8 height=8 align=absmiddle> <?php if (tep_session_is_registered('customer_id')) { ?><a style="font-size:10px" href="<?php echo tep_href_link(FILENAME_LOGOFF, '', 'SSL'); ?>" class=ml><?php echo HEADER_TITLE_LOGOFF; ?></a><br><?php } else echo '<a style="font-size:10px" href="' . tep_href_link(FILENAME_LOGIN, tep_get_all_get_params(), 'SSL') . '" class=ml>' . HEADER_TITLE_LOGIN . '</a>'; ?><br><br></td></tr> The visitors will see "Login de Clientes" if they are not logged and "Sair da TUA conta" will be displayed only when are looged in.

I tried to access this: https://atualoja.com/imagemagic.php?img=ima...;h=78&page= and it says Warning: glob(): SAFE MODE Restriction in effect. If you have in your cgi-bin a php.ini file, try to add this line: safe_mode=off I'm not sure if it will work, but if it doesn't, remove that line from php.ini.

You can set it using your FTP client. PHP 5 could be the problem, I'm not sure. But why you have thumbnails/images/images/ folder? You should have only thumbnails/images/

Try to turn it On.

Have you created the thumbnails folder? It has the right permissions (777)?

Something like that can be done if you will install Admin Specials by Categories for SPPC which is easy to do it.

I think is between line 74 and 113. Try to replace this: function tep_image($src, $alt = '', $width = '', $height = '', $parameters = '') { if ( (empty($src) || ($src == DIR_WS_IMAGES)) && (IMAGE_REQUIRED == 'false') ) { return false; } // alt is added to the img tag even if it is null to prevent browsers from outputting // the image filename as default $image = '<img src="' . tep_output_string($src) . '" border="0" alt="' . tep_output_string($alt) . '"'; if (tep_not_null($alt)) { $image .= ' title=" ' . tep_output_string($alt) . ' "'; } if ( (CONFIG_CALCULATE_IMAGE_SIZE == 'true') && (empty($width) || empty($height)) ) { if ($image_size = @getimagesize($src)) { if (empty($width) && tep_not_null($height)) { $ratio = $height / $image_size[1]; $width = $image_size[0] * $ratio; } elseif (tep_not_null($width) && empty($height)) { $ratio = $width / $image_size[0]; $height = $image_size[1] * $ratio; } elseif (empty($width) && empty($height)) { $width = $image_size[0]; $height = $image_size[1]; } } elseif (IMAGE_REQUIRED == 'false') { return false; } } if (tep_not_null($width) && tep_not_null($height)) { $image .= ' width="' . tep_output_string($width) . '" height="' . tep_output_string($height) . '"'; } if (tep_not_null($parameters)) $image .= ' ' . $parameters; $image .= '>'; return $image; }

Image Magic and Fancier Invoice & Packingslip conflict and how to fix it: Just installed this contribution and the images are not displayed, and when checking the image link this error comes up: Warning: chdir(): No such file or directory (errno 2) in /home/www/xxxxxxxxxxxxx/imagemagic.php on line 21 Warning: Cannot modify header information - headers already sent by (output started at /home/www/xxxxxxxxxxxxx/imagemagic.php:21) in /home/www/xxxxxxxxxxxxx/imagemagic.php on line 492 Warning: Cannot modify header information - headers already sent by (output started at /home/www/xxxxxxxxxxxxx/imagemagic.php:21) in /home/www/xxxxxxxxxxxxx/imagemagic.php on line 493 Warning: Cannot modify header information - headers already sent by (output started at /home/www/xxxxxxxxxxxxx/imagemagic.php:21) in /home/www/xxxxxxxxxxxxx/imagemagic.php on line 494 Warning: Cannot modify header information - headers already sent by (output started at /home/www/xxxxxxxxxxxxx/imagemagic.php:21) in /home/www/xxxxxxxxxxxxx/imagemagic.php on line 495 Warning: Cannot modify header information - headers already sent by (output started at /home/www/xxxxxxxxxxxxx/imagemagic.php:21) in /home/www/xxxxxxxxxxxxx/imagemagic.php on line 496 Warning: Cannot modify header information - headers already sent by (output started at /home/www/xxxxxxxxxxxxx/imagemagic.php:21) in /home/www/xxxxxxxxxxxxx/imagemagic.php on line 497 ????JFIF??0kG?ȿd???}3?χ_?N/??j|?????1?????i;??&???????~?????? ???????g?????&??.??-?c?㗇?l????????? ???????g_???1?(?T???H?ڏ???? ???Z??_?ߌ?o?x?ş~8??~"???u???S??}??/???????%? ? '? S? ?? O?g?1????????0w?d??+??h?Qڿ؟?N?G???%??,?_0|,????0x??6? ?7?߇?3??????|?K?g?g??{??¾??}???????C??~~??~?~Կn?x??n?f|2? ?Ӿ\??^???????i?x???>~???RO???z??ϟ?u?o????????ǟ?>???e?|<?> ??z?Ɲ?|8??f|]??]?S?????????d??w???|v???????O?????o?????C?g?>'뿴???????j?? ?4f???^?-?Px??????,?????'???~?7c?x??|;???????? x??_??k>???? ?O?\?g?&W????c?o???????M???????]????ƽg???o??ᇀ???Yï?מ?????????N??/ۻ????5???M?v??6|??7??? xw? |?????^??l K?????/??????_|K???j/ x???&???^???P?n|s??&???????E????i_?? ah?k?Y?0?7??????&?џ?M??~?Q_?? ?n??*o?~$?? >!~˿??^?J?????ߴ???M?Ej?LJ?9????/ï??S???Eh߱_??????j?)7?}w?6??????O?~;???????>.?2?????_??6j???????????g??f?x??i??^|1? < ??h???$Z???????????9~ѿ?????Z?? ??do??? ???g?<? ???e?kv_ ?@??+???"???!?]??~,??~??>*?_?~?? <?믇?????wD??< ?i?,??ǰ\?ɾ ???o?(e??/ ??.?-????^???k:???:??_x???p??O,?+k?_??????o????2k^>Կf????g?W? ?~??w???/???I?+?A????????#ğ?i?'? ?=k?ϊ?Q??"????ee??N???˟??w???~ۿ?S_?K???$????a?e??s]? ??x?~???7?????????????x?_?s??W?????e???~ѿ?f/?U?s?~??????????&????<-?!? ?l??Ɠ?????????????X?*x???/????~.?L??1?k?[?^??'??e????N?S???/?M???????_|E?~??x'R????ٛ??o????W? ?=???| ??l?H???CI???c???]????~x?¿???E?h?4???(x????o?Z7?/???_?n??????^o|c?7?????< ???G??x????G?Q?x??h_ۇ???????S???ex??????/???????h??l?U?D??d}k?????&??????;_x????C?????%}ǁ<'?y???\???x?B?R??+P??+?ً????A?????_??<???x'K?? ?4??g?#¾'?5??u????\?ׇ?;????? ?????׮|I?Ӵ?;???/?>6???? \????'²?>???(??(??(??(??(??(??(??(??(??(??(??(??(??(??(??(??(??(??(??(??(??(??(??(??(??(??(??(?? Probably is already posted, but i'm not gonna check all 40 pages to see exactly. So, if somebody will get that error and has installed Fancier Invoice, here is the solution: In catalog/imagemagic.php we have this: The original oscommerce-2.2ms2-051113 package, doesn't have any includes/local/configure.php. As the script says, when includes/local/configure.php is not there, it will go to includes/configure.php. But, installing Fancier Invoice & Packingslip you must create a includes/local/configure.php which doesn't have what imagemagic.php is looking for, that's why that error comes up; imagemagic.php finds the includes/local/configure.php file, but with something else inside it. To get rid of that error, i simply removed this code: if (file_exists('includes/local/configure.php')) { //use local dev params if available } else { // include server parameters require('includes/configure.php'); and now what i have in my imagemagic.php is this: include('includes/configure.php'); require('includes/imagemagic/imagemagic.functions.php'); chdir (DIR_FS_CATALOG); The script will not check if includes/local/configure.php exists or not, it will simply includes includes/configure.php. Now, all my images are displayed :)

Try first with a small file, arround 100kb. Forget about the number of products, that's not important. Important is the size of the file. Also, check Configuration>Easy Populate>Delimiter. You should have in that box \t

.

Look how is mine and it works: in account_history_info.php i have this code (line 438 in my case): <td><div style="float:left"><?php echo '<a href="' . tep_href_link(FILENAME_ACCOUNT_HISTORY, tep_get_all_get_params(array('order_id')), 'SSL') . '">' . tep_image_button('button_back.gif', IMAGE_BUTTON_BACK) . '</a></div><div style=float:right>'; ?><a href="java script:popupPrintReceipt('<?php echo tep_href_link([b]FILENAME_ORDERS_PRINTABLE[/b], tep_get_all_get_params(array('order_id')) . 'order_id=' . $HTTP_GET_VARS['order_id'], 'SSL'); ?>')"><?php echo tep_image_button('button_print_order.gif', IMAGE_BUTTON_PRINT_ORDER) . '</a>'; ?></div></td> and in filenames.php: define('FILENAME_ORDERS_PRINTABLE', 'print_my_invoice.php'); define('FILENAME_ORDERS_PRINTABLE_INFO', 'print_my_invoice.php'); Also, make sure you have print_my_invoice.php in your catalog folder and catalog/includes/languages/english

go to catalog/includes/filenames.php and check if you have:

probably in your account_history_info.php you have <a href="java script:popupPrintReceipt('<?php echo tep_href_link(FILENAME_PRINT_MY_INVOICE, insteed of <a href="java script:popupPrintReceipt('<?php echo tep_href_link(FILENAME_ORDERS_PRINTABLE,

I think i found a solution. At leats for me worked. Set $replace_quotes = false; , not true. If you use a version wher you can set it false/true from Admin > Configuration > Easy Populate > Replace Quotes, set it false. The only problem was with " ' " which i changed it like this: " \' " , using notepad. Upload the products and go to admin to edit one of them. Now it show exactly what i have uploaded. In your case should be exactly <table width="95%" border="0" cellspacing="1" cellpadding="5">... Just try.

but i think the best way is to modify somehow admin/customers_groups.php, to add there a min order field

Thanks for reply, If i add that sql how should i modify shopping_cart.php and check out files?

Hello, I'd like to know if it's possible to integrate Minimum Order Amount contribution with Separate Prices. I mean, with min order amount contrib, we can set an min amount for all customers. What we have to modify in order to have for each group a min order amount? Thank you all,

Hello, I think the problem is solved. This line: 'currency' => $order->info['currency'], was missing from checkout_process.php Thank you very much for your help.

Here is what i have in Administration->Localization->Currencies About checkout process i don't know what to say, but the orders looks good if the edit button is not pressed. I mean everything is displayed when an order is submitted. The currency sign is removed once the edit button is pressed.

I forgot to mention, that is stored in orders table.

Hi, Look what is stored... And for other orders it is displayed the same thing..