Jump to content

xavkick

Members
  • Content count

    66
  • Joined

  • Last visited

Posts posted by xavkick


  1. i have installed this contribution but i still have problem

     

    i can see on the page the number of link for each categories but when i try to see the link i have : There are no links to list in this category.

     

    i have set all the language to false, i use seo but i have put in my htaccess : RewriteRule ^(.*)-links-(.*).html$ links.php?lPath=$2&%{QUERY_STRING}

     

    Can someone help me please?


  2. i have installed this contribution but i still have problem

     

    i can see on the page the number of link for each categories but when i try to see the link i have : There are no links to list in this category.

     

    i have set all the language to false, i use seo but i have put in my htaccess : RewriteRule ^(.*)-links-(.*).html$ links.php?lPath=$2&%{QUERY_STRING}

     

    Can someone help me please?


  3. is there a way to simply not show an attribute if it is out of stock for a particular item?

     

    Specifically, is there built in functionality in QT Pro?

     

    I'd rather not have the annoying message saying your selection is out of stock (on the default item in the attribute list) if none is there - nor do I want the customer to be able to select an attribute that isn't there.

     

    Thanks.

     

     

    The best thing is to use with QTPRO Limited Stock by Article

     

    It work very good with qtpro

     

    xav


  4. quick question for you all, i really really hope someone knows what im talking about. we have paypal IPN and QTpro installed on my oscommerce. after the paypal ipn was installed QTpro would not automatically update the stock. it would be very, very convenient if we found a fix for this but i just cant seem to find one. any suggestions at all? it automatically updates if paypal ipn is not installed. any and all information would be greatly appreciated and thanks in advance for the help!

     

    -ben

     

     

    This fix already exist search in the IPN Paypal topics.

     

    xav


  5. hi,

     

     

    I use the contrib Order at glance in the files orders.php and this contrib use html_noquote from the general.php here is the code from the orders.php

    <?php // ====> BOF: ORDERS AND COMMENTS AT-A-GLANCE <==== ?>
    			<td class="dataTableContent" align="left"><?php echo '<b>' . $orders['orders_id'] . '</b>'; 
    
    $products = "";
    $products_query = tep_db_query("SELECT orders_products_id, products_name, products_quantity FROM " . TABLE_ORDERS_PRODUCTS . " WHERE orders_id = '" . tep_db_input($orders['orders_id']) . "' ");
    while($products_rows = tep_db_fetch_array($products_query))
    {
    $products .= ($products_rows["products_quantity"]) . "x " . (tep_html_noquote($products_rows["products_name"])) . "<br>";
    $result_attributes = tep_db_query("SELECT products_options, products_options_values FROM " . TABLE_ORDERS_PRODUCTS_ATTRIBUTES . " WHERE orders_id = '" . tep_db_input($orders['orders_id']). "' AND orders_products_id = '" . $products_rows["orders_products_id"] . "' ORDER BY products_options");
    while($row_attributes = tep_db_fetch_array($result_attributes))
    {
    $products .=" - " . (tep_html_noquote($row_attributes["products_options"])) . ": " 
    . (tep_html_noquote($row_attributes["products_options_values"])) . "<br>";
    }
    }
      ?>	
    	<img src="images/icons/comment2.gif" onMouseOver="ddrivetip('<?php echo '' . $products . ''; ?>', 'silver', 350);" onMouseOut="hideddrivetip();" align="top" border="0">
    </td>
     <?php  // ====> EOF: ORDERS AT-A-GLANCE <==== ?>

     

     

    Then i i cancel the function tep_html_noquote form the generalhp

      function tep_html_noquote($string) {
     $string=str_replace(''', '', $string);
     $string=str_replace("'", "", $string);
     $string=str_replace('"', '', $string);
     $string=preg_replace("/\\r\\n|\\n|\\r/", "<BR>", $string); 
     return $string;
    
     }

     

    i can not open the orders in the admin

     

    Do you have an idee how to modify the code :

    <?php // ====> BOF: ORDERS AND COMMENTS AT-A-GLANCE <==== ?>
    			<td class="dataTableContent" align="left"><?php echo '<b>' . $orders['orders_id'] . '</b>'; 
    
    $products = "";
    $products_query = tep_db_query("SELECT orders_products_id, products_name, products_quantity FROM " . TABLE_ORDERS_PRODUCTS . " WHERE orders_id = '" . tep_db_input($orders['orders_id']) . "' ");
    while($products_rows = tep_db_fetch_array($products_query))
    {
    $products .= ($products_rows["products_quantity"]) . "x " . (tep_html_noquote($products_rows["products_name"])) . "<br>";
    $result_attributes = tep_db_query("SELECT products_options, products_options_values FROM " . TABLE_ORDERS_PRODUCTS_ATTRIBUTES . " WHERE orders_id = '" . tep_db_input($orders['orders_id']). "' AND orders_products_id = '" . $products_rows["orders_products_id"] . "' ORDER BY products_options");
    while($row_attributes = tep_db_fetch_array($result_attributes))
    {
    $products .=" - " . (tep_html_noquote($row_attributes["products_options"])) . ": " 
    . (tep_html_noquote($row_attributes["products_options_values"])) . "<br>";
    }
    }
      ?>	
    	<img src="images/icons/comment2.gif" onMouseOver="ddrivetip('<?php echo '' . $products . ''; ?>', 'silver', 350);" onMouseOut="hideddrivetip();" align="top" border="0">
    </td>
     <?php  // ====> EOF: ORDERS AT-A-GLANCE <==== ?>


  6. hi,

     

    Very nice contrib.

     

    But i use Qtpro and i use the option sequenced_dropdown.

     

    I would like to konw if someone know how to make only valid color only by size.

     

    I explain me better, i sell clothes and the customers has to choose the size before choosing the color. Sometime i do not have all the the color for ervy size.

    The probleme is that with option_as_images all the color are valid for each size.

     

    Can you help me by giving me some tips how to do it ?

     

    xav


  7. hi,

     

    still not working, i have :

     

    Warning: file(): URL file-access is disabled in the server configuration in /home/WwwBSD/france-incontinence.fr/admin/includes/functions/seo_assistant.php on line 96
    
    Warning: file(http://www.google.com/search?client=navclient-auto&ch=6-1330140846&ie=UTF-8&oe=UTF-8&features=Rank&q=info:www.france-incontinence.fr%2F): failed to open stream: no suitable wrapper could be found in /home/WwwBSD/france-incontinence.fr/admin/includes/functions/seo_assistant.php on line 96
    
    Warning: implode(): Bad arguments. in /home/WwwBSD/france-incontinence.fr/admin/includes/functions/seo_assistant.php on line 97


  8. Instructions For Getting This Great Contribution to Work with Paypal IPN (osCommmerce_PayPal_IPN_v1.2)

     

    These are the steps required in addition to those in the installation guide that comes with the contribution, in order to get it to work with the official osCommmerce_PayPal_IPN_v1.2 contribution. Backup your files before performing these steps!!! It worked for me, but nothing is guaranteed in the coding world!

     

    Repeat Step 7 of the installation instructions for /catalog/includes/modules/payment/paypal_ipn.php, as follows

     

    Step 7b:

    Open: catalog/includes/modules/payment/paypal_ipn.php

     

    Directly under:

    // lets start with the email confirmation

     

    Add this:

    // START HTML Invoice
     if (EMAIL_INVOICE == 'true') {
    require(DIR_WS_MODULES . EMAIL_INVOICE_DIR . FILENAME_EMAIL_INVOICE);
     } else {
    // END HTML Invoice

     

    Directly above:

    // load the after_process function from the payment modules
     $payment_modules->after_process();

     

    Add this:

    // START HTML Invoice
     }
    // END HTML Invoice

     

    Further Steps Required

     

    Open catalog/includes/modules/email_invoice/email_invoice.php

     

    Find this code near the beginning of the file:

     

    require(DIR_FS_ADMIN . DIR_WS_LANGUAGES . $language . "/" . FILENAME_ORDERS_INVOICE);

     

    Replace this with

     

    //   Edited to make Fancier Packing SLip and Invoice v 1.2 work with Paypal IPN
    //   require(DIR_FS_ADMIN . DIR_WS_LANGUAGES . $language . "/" . FILENAME_ORDERS_INVOICE);
    
      $language_query = tep_db_query("select directory from " . TABLE_LANGUAGES . " where languages_id = '" . tep_db_input($languages_id) . "'");
      $language = tep_db_fetch_array($language_query);
      $language_dir= $language['directory'];
    
      require(DIR_FS_ADMIN . DIR_WS_LANGUAGES . $language_dir . "/" . FILENAME_ORDERS_INVOICE);

     

    Open catalog\includes\modules\email_invoice\templates\html_invoice.php

     

    Replace all instances of $oID with $order_id

     

    I imagine you will need to repeat this for all files in the template dir that you intend to use, but I haven't verified this.

     

    Hey presto... it should now work!

     

    I hope this is of some help to people out there!

     

     

    When i make this change i have :

     

    Warning: main(includes/languages/Array.php): failed to open stream: No such file or directory in /home/WwwBSD/france-incontinence.fr/DSPH/includes/application_top.php on line 313
    
    Fatal error: main(): Failed opening required 'includes/languages/Array.php' (include_path='.:/usr/share/pear') in /home/WwwBSD/france-incontinence.fr/DSPH/includes/application_top.php on line 313

     

    xavier


  9. Perhaps you could revert to $oID and put in these lines of code somewhere near the top of your email template files, something like this

     

    if (int)$oID == 0 {

    $oID = $order_id;

    }

     

     

    hi why don't you try this :

     

    in the checkout process

    if (!tep_session_is_registered('payment')) tep_session_register('payment');
     if (isset($HTTP_POST_VARS['payment'])) $payment = $HTTP_POST_VARS['payment'];

     

    and in the mail tempalte simply add :

     

    if ($payment=='paypal') {$oID = $order_id;}

     

    xavier


  10. Hi,

     

     

    very great contrib but just one thing, does anyone know how can work do for the mail? I recieve ( me and the custommers) only basic emails ( no html )

     

    i have Fancier Invoice and Packingslip and i don't know how the make working with this contrib..

    xavier


  11. This is interesting. I believe what is happening is that you are deleting the entry in the quantity box along with checking the delete checkbox, so when you hit the update button the variable $products_details["qty"] is null and you get this error.

     

    Thanks- you've identified a very small omission on my part, namely that the code assumes $products_details["qty"] is not null.

     

    Find

    // 1.3.1 Update orders_products Table
    	if (is_array ($_POST['update_products'])){
    	foreach($_POST['update_products'] as $orders_products_id => $products_details)	{

    and add directly below it

    		if (!tep_not_null($products_details["qty"])) $products_details["qty"] = 0;

     

    and you should not have a problem with this again.

     

     

     

    cool it's running very nice now

     

    xav


  12. i have a trouble when i try to delete one items on the order i have :

     

    1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' products_ordered = products_ordered - WHERE product

     

    UPDATE products SET products_quantity = products_quantity + , products_ordered = products_ordered - WHERE products_id = '0'

     

    [TEP STOP]

     

     

     

    xavier


  13. I don't understand the problem. Could you be more specific please?

     

     

    Hi, i have made a mistake. This is much much better this version with atrtibut.

     

    Please will it be possbile to think about a solution for working with QTPRO

     

    In this contrib with use attributes but th stock is taking in a special table product-stock

    here is the detail of this table

     

    `products_stock` (

    `products_stock_id` int(11) NOT NULL auto_increment,

    `products_id` int(11) NOT NULL default '0',

    `products_stock_attributes` varchar(255) NOT NULL default '',

    `products_stock_quantity` int(11) NOT NULL default '0',

    PRIMARY KEY (`products_stock_id`),

    UNIQUE KEY `idx_products_stock_attributes` (`products_id`,`products_stock_attributes`)

    ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=810 ;

     

    --

    -- `products_stock`

    --

     

    INSERT INTO `products_stock` (`products_stock_id`, `products_id`, `products_stock_attributes`, `products_stock_quantity`) VALUES (374, 139, '2-17', 4),

    (31, 63, '4-41', -1),

    (735, 60, '4-40', 0),

    (6, 65, '4-39', 2),

    (7, 61, '4-39', 2),

     

    Thank you for your help

     

    Xav


  14. Hi

     

    Sorry I didn't make myself very clear, I've installed the files and changed catagories.php. But it doesn't work, nothing! I have checked in the source code of the html when I bring up the add product page, and the commands are there but nothing on the add product page.

     

    Thanks

     

    Mike

     

     

    Simply delete the .httacess in the file attributeManager.

     

     

     

    May i know if this contrib will have the possbility for managing different weight. I use it in my shop and we sell piece or set of three.

    Does anybody hava a solution.

     

    xavier


  15. Dig through the code that comes with qtpro and find the delete function of orders.php (the code that modifies the original delete function and the queries associated with it). That should be enough to write something up.

     

     

    in the checkout_process.php the portion of the QTPRO code are :

     

    $products_stock_attributes=null;
    if (STOCK_LIMITED == 'true') {
    	$products_attributes = $order->products[$i]['attributes'];

     

    and

     

    $actual_stock_bought = $order->products[$i]['qty'];
    	$download_selected = false;
    	if ((DOWNLOAD_ENABLED == 'true') && isset($stock_values['products_attributes_filename']) && tep_not_null($stock_values['products_attributes_filename'])) {
    	  $download_selected = true;
    	  $products_stock_attributes='$$DOWNLOAD$$';
    	}
    //	  If not downloadable and attributes present, adjust attribute stock
    	if (!$download_selected && is_array($products_attributes)) {
    	  $all_nonstocked = true;
    	  $products_stock_attributes_array = array();
    	  foreach ($products_attributes as $attribute) {
    		if ($attribute['track_stock'] == 1) {
    		  $products_stock_attributes_array[] = $attribute['option_id'] . "-" . $attribute['value_id'];
    		  $all_nonstocked = false;
    		}
    	  } 
    	  if ($all_nonstocked) {
    		$actual_stock_bought = $order->products[$i]['qty'];
    	  }  else {
    		asort($products_stock_attributes_array, SORT_NUMERIC);
    		$products_stock_attributes = implode(",", $products_stock_attributes_array);
    		$attributes_stock_query = tep_db_query("select products_stock_quantity from " . TABLE_PRODUCTS_STOCK . " where products_stock_attributes = '$products_stock_attributes' AND products_id = '" . tep_get_prid($order->products[$i]['id']) . "'");
    		if (tep_db_num_rows($attributes_stock_query) > 0) {
    		  $attributes_stock_values = tep_db_fetch_array($attributes_stock_query);
    		  $attributes_stock_left = $attributes_stock_values['products_stock_quantity'] - $order->products[$i]['qty'];
    		  tep_db_query("update " . TABLE_PRODUCTS_STOCK . " set products_stock_quantity = '" . $attributes_stock_left . "' where products_stock_attributes = '$products_stock_attributes' AND products_id = '" . tep_get_prid($order->products[$i]['id']) . "'");
    		  $actual_stock_bought = ($attributes_stock_left < 1) ? $attributes_stock_values['products_stock_quantity'] : $order->products[$i]['qty'];
    		} else {
    		  $attributes_stock_left = 0 - $order->products[$i]['qty'];
    		  tep_db_query("insert into " . TABLE_PRODUCTS_STOCK . " (products_id, products_stock_attributes, products_stock_quantity) values ('" . tep_get_prid($order->products[$i]['id']) . "', '" . $products_stock_attributes . "', '" . $attributes_stock_left . "')");
    		  $actual_stock_bought = 0;
    		}
    	  }
    	}
    //		$stock_query = tep_db_query("select products_quantity from " . TABLE_PRODUCTS . " where products_id = '" . tep_get_prid($order->products[$i]['id']) . "'");
    //	  }
    //	  if (tep_db_num_rows($stock_query) > 0) {
    //		$stock_values = tep_db_fetch_array($stock_query);
    // do not decrement quantities if products_attributes_filename exists
    	if (!$download_selected) {
    	  $stock_left = $stock_values['products_quantity'] - $actual_stock_bought;
    	  tep_db_query("UPDATE " . TABLE_PRODUCTS . " 
    					SET products_quantity = products_quantity - '" . $actual_stock_bought . "' 
    					WHERE products_id = '" . tep_get_prid($order->products[$i]['id']) . "'");

     

    and

     

     if (!isset($products_stock_attributes)) $products_stock_attributes=null;
    $sql_data_array = array('orders_id' => $insert_id, 
    						'products_id' => tep_get_prid($order->products[$i]['id']), 
    						'products_model' => $order->products[$i]['model'], 
    						'products_name' => $order->products[$i]['name'], 
    						'products_price' => $order->products[$i]['price'], 
    						'final_price' => $order->products[$i]['final_price'], 
    						'products_tax' => $order->products[$i]['tax'], 
    						'products_quantity' => $order->products[$i]['qty'],
    						'products_stock_attributes' => $products_stock_attributes);

     

     

     

    i hope you can help me

     

    xav

×