Jump to content

NEMROD34

Members
  • Content count

    45
  • Joined

  • Last visited

1 Follower

Profile Information

  • Real Name
    NEMROD34
  1. NEMROD34

    RSS Feed contribution support thread

    Hello i have 2 problems: I use RSS Feed v2.3 with this .sql: INSERT INTO configuration( configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function ) VALUES ( '', 'RSS Articles', 'MAX_RSS_ARTICLES', '20', 'Number of articles displayed by the RSS feed', '3', '25', '2007-03-14 22:15:35', '2007-03-14 22:15:35', NULL , NULL ); It's ok, but in admin/categories.php i have: 1054 - Unknown column 'p.products_to_rss' in 'field list' select pd.products_name, pd.products_description, pd.products_url, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_pdfupload, p.products_fileupload, p.products_price, p.products_weight, p.products_date_added, p.products_last_modified, date_format(p.products_date_available, '%Y-%m-%d') as products_date_available, p.products_status, p.products_sold, p.products_tax_class_id, p.manufacturers_id, p.products_sort_order, p.products_to_rss from products p, products_description pd where p.products_id = '1097' and p.products_id = pd.products_id and pd.language_id = '1' and in rss.php 1054 - Unknown column 'p.products_to_rss' in 'where clause' select p.products_id, p.manufacturers_id, p.products_model, p.products_price, p.products_image, p.products_date_added, pd.products_name, pd.products_description, m.manufacturers_name, cd.categories_name, 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 products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id left join specials s on p.products_id = s.products_id, products_to_categories p2c LEFT JOIN categories_description cd ON p2c.categories_id = cd.categories_id where p.products_status = '1' and p.products_to_rss='1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' GROUP BY p.products_id ORDER BY p.products_id DESC LIMIT 20 [TEP STOP] My code in admin/categories.php: $product_query = tep_db_query("select pd.products_name, pd.products_description, pd.products_url, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_pdfupload, p.products_fileupload, p.products_price, p.products_weight, p.products_date_added, p.products_last_modified, date_format(p.products_date_available, '%Y-%m-%d') as products_date_available, p.products_status, p.products_sold, p.products_tax_class_id, p.manufacturers_id, p.products_sort_order, p.products_to_rss from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = '" . (int)$HTTP_GET_VARS['pID'] . "' and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "'"); $product = tep_db_fetch_array($product_query); $pInfo->objectInfo($product); } elseif (tep_not_null($HTTP_POST_VARS)) { $pInfo->objectInfo($HTTP_POST_VARS); $products_name = $HTTP_POST_VARS['products_name']; $products_info = $HTTP_POST_VARS['products_info']; $products_description = $HTTP_POST_VARS['products_description']; $products_url = $HTTP_POST_VARS['products_url']; } --------------------------------------------- $product_query = tep_db_query("select p.products_id, pd.language_id, pd.products_name, pd.products_info, pd.products_description, pd.products_url, p.products_quantity, p.products_model, p.products_image, p.products_pdfupload, p.products_fileupload, p.products_price, p.products_weight, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_status, p.products_sold, p.manufacturers_id, p.products_sort_order, p.products_to_rss 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); ------------------------------------------------ $products_query = tep_db_query("select p.products_id, pd.products_name, p.products_quantity, p.products_image, p.products_pdfupload, p.products_fileupload, p.products_price, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_status, p.products_sold, p2c.categories_id, p.products_sort_order, p.products_to_rss from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' and p.products_id = p2c.products_id and pd.products_name like '%" . tep_db_input($search) . "%' order by pd.products_name"); } else { $products_query = tep_db_query("select p.products_id, pd.products_name, p.products_quantity, p.products_image, p.products_pdfupload, p.products_fileupload, p.products_price, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_status, p.products_sold, p.products_sort_order, p.products_to_rss from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' and p.products_id = p2c.products_id and p2c.categories_id = '" . (int)$current_category_id . "' order by pd.products_name"); } I dont understand ...
  2. NEMROD34

    RSS Feed contribution support thread

    Sorry another pic:
  3. NEMROD34

    RSS Feed contribution support thread

    @@alex121 Hello , i'm a french guy and i have the same problem: Can you explain to me (clearely please :D ) how you fix this ? Thank you !
  4. NEMROD34

    [Contribution] CKEditor [wyswyg]

    It's ok : i use KFM, in configuration.php: $kfm_userfiles_output = HTTP_SERVER.DIR_WS_CATALOG_IMAGES; Replace by: $kfm_userfiles_output = DIR_WS_CATALOG_IMAGES; ;-)
  5. NEMROD34

    [Contribution] CKEditor [wyswyg]

    Hello, I use ckeditor and kfm, but I have a problem: The product image disappears when I go to "preview": And when I return to the page image missing: Categories.php code: <tr> <td class="main" valign="top"><?php echo tep_image(DIR_WS_ADMIN . DIR_WS_IMAGES . 'scanner.gif'); ?> </td> <td class="main"><?php echo tep_draw_textarea_ckeditor('products_image', '700', '150', $pInfo->products_image); ?></td> </tr> Html_output.php code: /// function textarea avec ckeditor function tep_draw_textarea_ckeditor($name, $wrap, $width, $height, $text = '', $parameters = '', $reinsert_value = true) { global $HTTP_GET_VARS, $HTTP_POST_VARS; if ($width < 100) $width = 700; if ($height < 100) $height = 200; $field = '<textarea name="' . tep_output_string($name) . '" '; if (tep_not_null($parameters)) $field .= ' ' . $parameters; $field .= '>'; if ( ($reinsert_value == true) && ( (isset($HTTP_GET_VARS[$name]) && is_string($HTTP_GET_VARS[$name])) || (isset($HTTP_POST_VARS[$name]) && is_string($HTTP_POST_VARS[$name])) ) ) { if (isset($HTTP_GET_VARS[$name]) && is_string($HTTP_GET_VARS[$name])) { $field .= tep_output_string_protected(stripslashes($HTTP_GET_VARS[$name])); } elseif (isset($HTTP_POST_VARS[$name]) && is_string($HTTP_POST_VARS[$name])) { $field .= tep_output_string_protected(stripslashes($HTTP_POST_VARS[$name])); } } elseif (tep_not_null($text)) { $field .= tep_output_string_protected($text); } $field .= '</textarea>'; $field .= '<script type="text/javascript"> CKEDITOR.replace( \''.tep_output_string($name).'\', { resize_minWidth : 500 , resize_maxWidth : 850 , width : '.$width.', height : '.$height.', filebrowserBrowseUrl: "includes/kfm/index.php" }); </script>'; return $field; } ?> Someone have an idea ? Thanks.
  6. NEMROD34

    Customer Add Product

    Hello, I have several problems: - If there are no pictures I like it when it is realized: With an image it goes. - When a customer a product shipments of the product appears as being sent by all clients. - And if I want to validate that all clients simultaneously. - In the admin I have a client side "Admins" if I select: Warning: array_merge() [function.array-merge]: Argument #1 is not an array in /public_html/***/***/***/admin/customers.php on line 1212 Warning: array_merge() [function.array-merge]: Argument #2 is not an array in /public_html/***/***/***/admin/customers.php on line 1212 Warning: array_merge() [function.array-merge]: Argument #2 is not an array in /public_html/***/***/***/admin/customers.php on line 1214 Warning: reset() [function.reset]: Passed variable is not an array or object in /public_html/***/***/***/admin/includes/classes/object_info.php on line 17 Warning: Variable passed to each() is not an array or object in /public_html/***/***/***/admin/includes/classes/object_info.php - In the e-mail received was "A new product has been added in category: "tests as" while in the menu on the client side it has "test-> tests as" ms2 + cap 1.4.3
  7. NEMROD34

    [Contribution] Additional Images Module

    Hello in the installation it says: <?php // BOF: Additional Images: added: onSubmit="return check_form(new_product);" ?> <?php echo tep_draw_form('new_product', FILENAME_CATEGORIES, 'cPath=' . $cPath . (isset($HTTP_GET_VARS['pID']) ? '&pID=' . $HTTP_GET_VARS['pID'] : '') . '&action=new_product_preview', 'post', 'enctype="multipart/form-data" onSubmit="return check_form(this);"') . tep_hide_session_id(); ?> <?php // EOF: Additional Images ?> For me it's the line 765 But with: onSubmit="return check_form(new_product);" Or: onSubmit="return check_form(this);" I still have the same error when I add a new product: Fatal error: Call to undefined function tep_hide_session_id() in /public_html/portail/****/***/admin/categories.php on line 765 When i want édit a product : 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 ' p.products_image_med, p.products_image_pop, p.products_image_description, p.pro' at line 1 select pd.products_name, pd.products_description, pd.products_url, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_pdfupload, p.products_price, p.products_weight, p.products_date_added,, p.products_image_med, p.products_image_pop, p.products_image_description, p.products_last_modified, date_format(p.products_date_available, '%Y-%m-%d') as products_date_available, p.products_status, p.products_tax_class_id, p.products_sold, p.manufacturers_id from products p, products_description pd where p.products_id = '826' and p.products_id = pd.products_id and pd.language_id = '1' [TEP STOP] I have be insert the .sql file in my data base I have a problem with admin/includes/functions/html_output: in the contrib : In my page: // The HTML image wrapper function function tep_image($src, $alt = '', $width = '', $height = '', $params = '') { $image = '<img src="' . $src . '" border="0" alt="' . $alt . '"'; if ($alt) { $image .= ' title=" ' . $alt . ' "'; } // BOF: Additional Images /* if (tep_not_null($width) && tep_not_null($height)) { $image .= ' width="' . tep_output_string($width) . '" height="' . tep_output_string($height) . '"'; } */ if (tep_not_null($width)) { $image .= ' width="' . tep_output_string($width) . '"'; } if (tep_not_null($height)) { $image .= ' height="' . tep_output_string($height) . '"'; } // EOF: Additional Images if ($params) { $image .= ' ' . $params; } $image .= '>'; return $image; } //// // The HTML form submit button wrapper function // Outputs a button in the selected language It's ok ? Thanks
  8. NEMROD34

    PDF File Upload and Display

    Ok solved by putting it in product_info.php:
  9. NEMROD34

    PDF File Upload and Display

    I have : http://labourseauxlivres.net/cnegu/DIR_WS_MANUALSHoldUpPlanetaire.pdf With: 2:) ##### open catalog/includes/configure.php find define('DIR_WS_IMAGES', 'images/'); ##----> add under neath define('DIR_WS_MANUALS', 'manuals/'); define('DIR_WS_CATALOG_MANUALS', DIR_WS_CATALOG . 'manuals/'); 3:) ### catalog/admin/includes/configure.php find define('DIR_WS_IMAGES', 'images/'); ##----> add underneath define('DIR_WS_MANUALS', 'manuals/'); define('DIR_WS_CATALOG_MANUALS', DIR_WS_CATALOG . 'manuals/'); ## same file find: define('DIR_FS_CATALOG_IMAGES', DIR_FS_CATALOG . 'images/'); ##----> add underneath define('DIR_FS_CATALOG_MANUALS', DIR_FS_CATALOG . 'manuals/');
  10. NEMROD34

    Customer Add Product

    -Description product HTML -> you can do it by your self Forgiveness for my English. Afflicted but I do not arrive there, nor with fck editor. I does not understand that it is done at the base, because I do not see the interest to have to correct by the administration. Could somebody explain once how to make? If is needed it I would add it with the contrib, and if I manages to make function fck editor with too. Autre chose j'ai une erreur quand je valide l'annonce: 1054 - Unknown column 'language_id' in 'where clause' select categories_id from categories where categories_id = '284' and language_id = '1' [TEP STOP]
  11. NEMROD34

    Customer Add Product

    ok: // ########## [Delaballe] ADD FCKeditor ########## case 'new_product_preview': // copy image only if modified //echo DIR_WS_IMAGES; //print_r ($customer); //die($products_image); $products_image = new upload('products_image'); $products_image->set_destination(DIR_WS_IMAGES); if ($products_image->parse() && $products_image->save()) { $products_image_name = $products_image->filename; } else { $products_image_name = (isset($_POST['products_previous_image']) ? $_POST['products_previous_image'] : ''); } if ($products_image_swf){ /* echo $products_image_swf; $products_image_swf = new upload('products_image_swf'); $products_image_swf->set_destination(DIR_WS_IMAGES); if ($products_image_swf->parse() && $products_image_swf->save()) { $products_image_name2 = $products_image_swf->filename; } else { $products_image_name2 = (isset($_POST['products_previous_image']) ? $_POST['products_previous_image'] : ''); }*/ } //die($products_image_name); break; if (isset($HTTP_POST_VARS['products_image']) && tep_not_null($HTTP_POST_VARS['products_image']) && ($HTTP_POST_VARS['products_image'] != 'none')) { $products_image_name = $HTTP_POST_VARS['products_image']; } else { $products_image_name = (isset($HTTP_POST_VARS['products_previous_image']) ? $HTTP_POST_VARS['products_previous_image'] : ''); } $products_image_name = htmlspecialchars(stripslashes($products_image_name)); $products_image_name = strstr($products_image_name, 'src='); $products_image_name = ereg_replace('src="', '', $products_image_name); $products_image_name_end = strstr($products_image_name, '"'); $products_image_name = ereg_replace($products_image_name_end, '', $products_image_name); $products_image_name = ereg_replace(DIR_WS_CATALOG . DIR_WS_IMAGES, '', $products_image_name); break; // ########## [Delaballe] END - ADD FCKeditor ########## case 'insert_product': case 'update_product': // ########## [Delaballe] ADD FCKeditor ########## But if i write in description : blabla blabla bla i show this in prewiew: _p_blabla_/p_ _p align="center"_blabla bla_/p_
  12. NEMROD34

    Customer Add Product

    Ok attempt at integration of fck éditor: - I have well the bar with the tools in the box description. But two problems (perhaps one depend on the other): Warning: ereg_replace() [function.ereg-replace]: REG_EMPTY in /home/.filer4/bourseauxlivres/www/account_add.php on line 43 And aucunne beacon does not leave correctly, nor the returns to the line. Caution: I have make modifs on the files account_ass (for the moment I deal with him). A blow of hand would have come well! To download the package If you know a means of making, that the products added by oblique this find yourself with dimensions admin, in the products on standby I am taking (to validate it is simpler). sorry for my english
  13. NEMROD34

    Customer Add Product

    With this only the subcatégorie name is on e-mail. How can i do for have categorie/subcatégorie ?
  14. NEMROD34

    Customer Add Product

    Hello, there is a means of entering the products with a presentation which comprises jumps of line of the text in fat ect? If required to integrate fck editor? Because carractères HTML are not taken into account, the return to the line either. Thank you
  15. NEMROD34

    [contribution] CustomerDiscount

    hello here it is necessary me to apply the reduction to the product and not to the options. MOREOVER it is necessary that that left only in the basket: I did that: dans currencies.php in bottom pagepage : //CustomerDiscount start function display_price_nodiscount($products_price, $products_tax, $quantity = 1) { global $customer_id; $query = tep_db_query("select customers_discount from " . TABLE_CUSTOMERS . " where customers_id = '" . $customer_id . "'"); $query_result = tep_db_fetch_array($query); $customer_discount = $query_result['customers_discount']; if (strstr($customer_discount, "+") != null) { $products_price_nodiscount = $products_price + $products_price * abs($customer_discount) / 100; } else { $products_price_nodiscount = $products_price - $products_price * abs($customer_discount) / 100; } return $this->format(tep_add_tax($products_price, $products_tax) * $quantity); } function display_price($products_price, $products_tax, $quantity = 1) { return $this->format(tep_add_tax($products_price, $products_tax) * $quantity); } //CustomerDiscount end } ?> replace: 'params' => 'class="productListing-data" valign="top"', 'text' => '<b>' . $currencies->display_price($products[$i]['final_price'], tep_get_tax_rate($products[$i]['tax_class_id']), $products[$i]['quantity']) . '</b>'); by: //CustomerDiscount end 'params' => 'class="productListing-data" valign="top"', 'text' => '<b>' . $currencies->display_price_nodiscount($products[$i]['final_price'], tep_get_tax_rate($products[$i]['tax_class_id']), $products[$i]['quantity']) . '</b>'); //CustomerDiscount end i delete: //CustomerDiscount start global $customer_id; $query = tep_db_query("select customers_discount from " . TABLE_CUSTOMERS . " where customers_id = '" . $customer_id . "'"); $query_result = tep_db_fetch_array($query); $customer_discount = $query_result['customers_discount']; if (strstr($customer_discount, "+") != null) { $attribute_price['options_values_price'] = $attribute_price['options_values_price'] + $attribute_price['options_values_price'] * abs($customer_discount) / 100; } else { $attribute_price['options_values_price'] = $attribute_price['options_values_price'] - $attribute_price['options_values_price'] * abs($customer_discount) / 100; //CustomerDiscount end Here I have the price of work + the framed price of the option. In under total I have price of work-20% + price of option it's ok ut in checkout_confirmation I have not the reduction in the subtotal: i want the same subtotal like shopping_cart in checkout_confimation.
×