Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

BdMdesigN

Pioneers
  • Posts

    22
  • Joined

  • Last visited

About BdMdesigN

  • Birthday 12/04/1973

Profile Information

BdMdesigN's Achievements

  1. Did it works now? If not, try this: if ($listing['products_quantity'] < 1) { // dont show buy_now button // } elseif { //
  2. Update to Availability & Warranty Manager 1.0.7 for 2.3.1 now under http://addons.oscommerce.com/info/8496 available. Best Regards Peter
  3. Traffic Light ON/OFF switch fix: open in catalog/YourAdminFolder/categories.php serch for line 218: tep_redirect(tep_href_link(FILENAME_CATEGORIES, 'cPath=' . $new_parent_id . '&pID=' . $products_id)); break; case 'insert_product': case 'update_product': if (isset($HTTP_GET_VARS['pID'])) $products_id = tep_db_prepare_input($HTTP_GET_VARS['pID']); $products_date_available = tep_db_prepare_input($HTTP_POST_VARS['products_date_available']); $products_date_available = (date('Y-m-d') < $products_date_available) ? $products_date_available : 'null'; $sql_data_array = array('products_quantity' => (int)tep_db_prepare_input($HTTP_POST_VARS['products_quantity']), // BOF: Availability + Warranty 'warranty_id' => tep_db_prepare_input($_POST['warranty_id']), ->> 'availability_status' => tep_db_prepare_input($_POST['products_status']), 'availability_id_in_stock' => tep_db_prepare_input($_POST['availability_id_in_stock']), 'availability_id_in_stock2' => tep_db_prepare_input($_POST['availability_id_in_stock2']), 'availability_id_in_stock3' => tep_db_prepare_input($_POST['availability_id_in_stock3']), change to: 'availability_status' => tep_db_prepare_input($_POST['availability_status']), search for line 384: // BOF: Availability + Warranty Added: , warranty_id, availability_id_in_stock, availability_id_in_stock2, availability_id_in_stock3, availability_id_in_stock_special, availability_id_out_of_stock, availability_id_in_stock_image, availability_id_in_stock2_image, availability_id_in_stock3_image, availability_id_in_stock_special_image, availability_id_out_of_stock_image, quantity_stock, quantity_stock_2, quantity_stock_3, quantity_stock_special, quantity_stock_zero $product_query = tep_db_query("select products_quantity, products_model, warranty_id, availability_id_in_stock, availability_id_in_stock2, availability_id_in_stock3, availability_id_in_stock_special, availability_id_out_of_stock, availability_id_out_of_stock_image, availability_id_in_stock_image, availability_id_in_stock2_image, availability_id_in_stock3_image, availability_id_in_stock_special_image, products_image, quantity_stock, quantity_stock_2, quantity_stock_3, quantity_stock_special, quantity_stock_zero, products_price, products_date_available, products_weight, products_tax_class_id, manufacturers_id from " . TABLE_PRODUCTS . " where products_id = '" . (int)$products_id . "'"); // EOF: Availability + Warranty cange to: // BOF: Availability + Warranty Added: , warranty_id, availability_id_in_stock, availability_id_in_stock2, availability_id_in_stock3, availability_id_in_stock_special, availability_id_out_of_stock, availability_id_in_stock_image, availability_id_in_stock2_image, availability_id_in_stock3_image, availability_id_in_stock_special_image, availability_id_out_of_stock_image, quantity_stock, quantity_stock_2, quantity_stock_3, quantity_stock_special, quantity_stock_zero $product_query = tep_db_query("select products_quantity, products_model, warranty_id, availability_status, availability_id_in_stock, availability_id_in_stock2, availability_id_in_stock3, availability_id_in_stock_special, availability_id_out_of_stock, availability_id_out_of_stock_image, availability_id_in_stock_image, availability_id_in_stock2_image, availability_id_in_stock3_image, availability_id_in_stock_special_image, products_image, quantity_stock, quantity_stock_2, quantity_stock_3, quantity_stock_special, quantity_stock_zero, products_price, products_date_available, products_weight, products_tax_class_id, manufacturers_id from " . TABLE_PRODUCTS . " where products_id = '" . (int)$products_id . "'"); // EOF: Availability + Warranty search for line 499 - 504: if (!isset($pInfo->products_status)) $pInfo->products_status = '1'; switch ($pInfo->products_status) { case '0': $in_status = false; $out_status = true; break; case '1': default: $in_status = true; $out_status = false; } add after it: // BOF: Availability if (!isset($pInfo->availability_status)) $pInfo->availability_status = '1'; switch ($pInfo->availability_status) { case '0': $in_status = false; $out_status = true; break; case '1': default: $in_status = true; $out_status = false; } // EOF: Availability thats all. Now the switch works correctly. Best Regards Peter
  4. New Support Tread: http://www.oscommerce.com/forums/topic/388210-availability-warranty-manager-105-for-231/ Best Regards Peter
  5. I have awake the AddOn Availability 1.0.4 to a new Live in osC 2.3.1. You can with a Switch turn on/off the Traffic Light Availability image for each Product in the Product Configuratin Page (categories.php) You have 5 categories.phpOptions (text and images) Warranty Option in categories.php added You can get the AddOn here: http://addons.oscommerce.com/info/4948 (Availability & Warranty Manager 1.0.5 for 2.3.1) http://addons.oscommerce.com/info/8496 (Availability & Warranty Manager 1.0.4 for 2.3.1) Best Regards Peter
  6. Yes thats correct. Thats the reason, why i hade made a Sample in the readme file. <Edit> The standart Config and DB Files has only one Language in the configuration_group Table. And thats english. There is no languages_id field in the original configuration_group table. Have a look on the Original SQL File and you know what i mean. </Edit> Best Regards Peter
  7. Moin Moin, I have made the Configuration Infobox in the Admin CP multilingual. If yor browser turn on german, it's shows the box in German. If your brower in english, it's shows the box in english. http://addons.oscommerce.com/info/8497 Best Regards Peter
  8. Add the availability message in the product_listing.php and in the new_product.php is not so easy, i will try to fix it in the next Version. I have added now a switch in the categories.php to turn ON/OFF the Traffic Light System for each product. If you turn the Traffic Light System OFF, than its shown the availability message on the Products Info Best Regards Peter
  9. No not really. I will have a look on the oscmax files, to check what is difference to the osc Original files. Best Regards Peter
  10. Yes i think it too, if i made the warranty externsion, but to try i made one only. In the Next Update i can put 2 extra warranty options in it. Thanx for the feedback :D :thumbsup: Best Regards Peter
  11. I have upload the fix for the Errors. And i have checked the products_new.php, product_info.php and the shopping_cart.php and fixed some Issues. The files *_ohne-without_ampel_traffic-lights.php are now without images and shows only Messages. You need the Availability 1.0.4 Packet. Best Regards Peter
  12. If you use the Traffic Light System it don't works. If you use "without_traffic_light_System" it should works. See it here: http://demo.osc2pragmamx.org/catalog-file-product_info-products_id-26.html it was the v.1.0.3 without my changes. I will check it today in the evening. Best Regards Peter
  13. Now open in catalog/admin/includes the availability_configurer.php mand go to Line 79: $table_mods_array[] = array ( 'tablename' => 'products', 'columnname' => 'availability_id_in_stock', 'create' => "ALTER TABLE products ADD availability_id_in_stock int(11) default '1' AFTER products_quantity;", 'remove' => "ALTER TABLE products DROP availability_id_in_stock" ); $table_mods_array[] = array ( 'tablename' => 'products', 'columnname' => 'availability_id_out_of_stock', 'create' => "ALTER TABLE products ADD availability_id_out_of_stock int(11) default '2' AFTER availability_id_in_stock;", 'remove' => "ALTER TABLE products DROP availability_id_out_of_stock" ); $table_mods_array[] = array ( 'tablename' => 'products', 'columnname' => 'availability_id_in_stock2', 'create' => "ALTER TABLE products ADD availability_id_in_stock2 int(11) default '3' AFTER availability_id_out_of_stock;", 'remove' => "ALTER TABLE products DROP availability_id_in_stock2" ); $table_mods_array[] = array ( 'tablename' => 'products', 'columnname' => 'availability_id_in_stock3', 'create' => "ALTER TABLE products ADD availability_id_in_stock3 int(11) default '4' AFTER availability_id_in_stock2;", 'remove' => "ALTER TABLE products DROP availability_id_in_stock3" ); $table_mods_array[] = array ( 'tablename' => 'products', 'columnname' => 'availability_id_in_stock_special', 'create' => "ALTER TABLE products ADD availability_id_in_stock_special int(11) default '5' AFTER availability_id_in_stock3;", 'remove' => "ALTER TABLE products DROP availability_id_in_stock_specia" ); $table_mods_array[] = array ( 'tablename' => 'products', 'columnname' => 'availability_id_in_stock_image', 'create' => "ALTER TABLE products ADD availability_id_in_stock_image` varchar(64) default 'red.png' AFTER `availability_id_in_stock;", 'remove' => "ALTER TABLE products DROP availability_id_in_stock_image" ); $table_mods_array[] = array ( 'tablename' => 'products', 'columnname' => 'availability_id_out_of_stock_image', 'create' => "ALTER TABLE products ADD availability_id_out_of_stock_image varchar(64) default 'remove.png' AFTER availability_id_out_of_stock;", 'remove' => "ALTER TABLE products DROP availability_id_out_of_stock_image" ); $table_mods_array[] = array ( 'tablename' => 'products', 'columnname' => 'availability_id_in_stock2_image', 'create' => "ALTER TABLE products ADD availability_id_in_stock2_image varchar(64) default 'yellow.png' AFTER availability_id_in_stock2;", 'remove' => "ALTER TABLE products DROP availability_id_in_stock2_image" ); $table_mods_array[] = array ( 'tablename' => 'products', 'columnname' => 'availability_id_in_stock3_image', 'create' => "ALTER TABLE products ADD availability_id_in_stock3_image varchar(64) default 'green.png' AFTER availability_id_in_stock3;", 'remove' => "ALTER TABLE products DROP availability_id_in_stock3_image" ); $table_mods_array[] = array ( 'tablename' => 'products', 'columnname' => 'availability_id_in_stock_special_image', 'create' => "ALTER TABLE products ADD availability_id_in_stock_special_image varchar(64) default 'lila.png' AFTER availability_id_in_stock_special;", 'remove' => "ALTER TABLE products DROP availability_id_in_stock_special_image" ); $table_mods_array[] = array ( 'tablename' => 'products', 'columnname' => 'quantity_stock', 'create' => "ALTER TABLE products ADD quantity_stock int(4) NOT NULL default '2' AFTER availability_id_in_stock_image;", 'remove' => "ALTER TABLE products DROP quantity_stock" ); $table_mods_array[] = array ( 'tablename' => 'products', 'columnname' => 'quantity_stock_2', 'create' => "ALTER TABLE products ADD quantity_stock_2 int(4) NOT NULL default '5' AFTER availability_id_out_of_stock_image;", 'remove' => "ALTER TABLE products DROP quantity_stock_2" ); $table_mods_array[] = array ( 'tablename' => 'products', 'columnname' => 'quantity_stock_3', 'create' => "ALTER TABLE products ADD quantity_stock_3 int(4) NOT NULL default '5' AFTER availability_id_in_stock2_image;", 'remove' => "ALTER TABLE products DROP quantity_stock_3" ); $table_mods_array[] = array ( 'tablename' => 'products', 'columnname' => 'quantity_stock_special', 'create' => "ALTER TABLE products ADD quantity_stock_special int(4) NOT NULL default '-1' AFTER availability_id_in_stock3_image;", 'remove' => "ALTER TABLE products DROP quantity_stock_special" ); $table_mods_array[] = array ( 'tablename' => 'products', 'columnname' => 'quantity_stock_zero', 'create' => "ALTER TABLE products ADD quantity_stock_zerol int(4) NOT NULL default '0' AFTER availability_id_in_stock_special_image;", 'remove' => "ALTER TABLE products DROP quantity_stock_zero" ); $table_mods_array[] = array ( 'tablename' => 'products', 'columnname' => 'warranty_id', 'create' => "ALTER TABLE products ADD warranty_id int(11) default '1' AFTER availability_id_in_stock_special;", 'remove' => "ALTER TABLE products DROP warranty_id" ); Change it to: $table_mods_array[] = array ( 'tablename' => 'products', 'columnname' => 'availability_id_in_stock', 'create' => "ALTER TABLE products ADD availability_id_in_stock int(11) default '1' AFTER products_quantity;", 'remove' => "ALTER TABLE products DROP availability_id_in_stock" ); $table_mods_array[] = array ( 'tablename' => 'products', 'columnname' => 'availability_id_out_of_stock', 'create' => "ALTER TABLE products ADD availability_id_out_of_stock int(11) default '2' AFTER availability_id_in_stock;", 'remove' => "ALTER TABLE products DROP availability_id_out_of_stock" ); $table_mods_array[] = array ( 'tablename' => 'products', 'columnname' => 'availability_id_in_stock2', 'create' => "ALTER TABLE products ADD availability_id_in_stock2 int(11) default '3' AFTER availability_id_out_of_stock;", 'remove' => "ALTER TABLE products DROP availability_id_in_stock2" ); $table_mods_array[] = array ( 'tablename' => 'products', 'columnname' => 'availability_id_in_stock3', 'create' => "ALTER TABLE products ADD availability_id_in_stock3 int(11) default '4' AFTER availability_id_in_stock2;", 'remove' => "ALTER TABLE products DROP availability_id_in_stock3" ); $table_mods_array[] = array ( 'tablename' => 'products', 'columnname' => 'availability_id_in_stock_special', 'create' => "ALTER TABLE products ADD availability_id_in_stock_special int(11) default '5' AFTER availability_id_in_stock3;", 'remove' => "ALTER TABLE products DROP availability_id_in_stock_special" ); $table_mods_array[] = array ( 'tablename' => 'products', 'columnname' => 'availability_id_in_stock_image', 'create' => "ALTER TABLE products ADD availability_id_in_stock_image varchar(64) default 'red.png' AFTER availability_id_in_stock;", 'remove' => "ALTER TABLE products DROP availability_id_in_stock_image" ); $table_mods_array[] = array ( 'tablename' => 'products', 'columnname' => 'availability_id_in_stock_image', 'create' => "ALTER TABLE products ADD availability_id_in_stock_image varchar(64) default 'red.png' AFTER availability_id_in_stock;", 'remove' => "ALTER TABLE products DROP availability_id_in_stock_image" ); $table_mods_array[] = array ( 'tablename' => 'products', 'columnname' => 'availability_id_out_of_stock_image', 'create' => "ALTER TABLE products ADD availability_id_out_of_stock_image varchar(64) default 'remove.png' AFTER availability_id_out_of_stock;", 'remove' => "ALTER TABLE products DROP availability_id_out_of_stock_image" ); $table_mods_array[] = array ( 'tablename' => 'products', 'columnname' => 'availability_id_in_stock2_image', 'create' => "ALTER TABLE products ADD availability_id_in_stock2_image varchar(64) default 'yellow.png' AFTER availability_id_in_stock2;", 'remove' => "ALTER TABLE products DROP availability_id_in_stock2_image" ); $table_mods_array[] = array ( 'tablename' => 'products', 'columnname' => 'availability_id_in_stock3_image', 'create' => "ALTER TABLE products ADD availability_id_in_stock3_image varchar(64) default 'green.png' AFTER availability_id_in_stock3;", 'remove' => "ALTER TABLE products DROP availability_id_in_stock3_image" ); $table_mods_array[] = array ( 'tablename' => 'products', 'columnname' => 'availability_id_in_stock_special_image', 'create' => "ALTER TABLE products ADD availability_id_in_stock_special_image varchar(64) default 'lila.png' AFTER availability_id_in_stock_special;", 'remove' => "ALTER TABLE products DROP availability_id_in_stock_special_image" ); $table_mods_array[] = array ( 'tablename' => 'products', 'columnname' => 'quantity_stock', 'create' => "ALTER TABLE products ADD quantity_stock int(4) NOT NULL default '2' AFTER availability_id_in_stock_image;", 'remove' => "ALTER TABLE products DROP quantity_stock" ); $table_mods_array[] = array ( 'tablename' => 'products', 'columnname' => 'quantity_stock_2', 'create' => "ALTER TABLE products ADD quantity_stock_2 int(4) NOT NULL default '5' AFTER availability_id_out_of_stock_image;", 'remove' => "ALTER TABLE products DROP quantity_stock_2" ); $table_mods_array[] = array ( 'tablename' => 'products', 'columnname' => 'quantity_stock_3', 'create' => "ALTER TABLE products ADD quantity_stock_3 int(4) NOT NULL default '5' AFTER availability_id_in_stock2_image;", 'remove' => "ALTER TABLE products DROP quantity_stock_3" ); $table_mods_array[] = array ( 'tablename' => 'products', 'columnname' => 'quantity_stock_special', 'create' => "ALTER TABLE products ADD quantity_stock_special int(4) NOT NULL default '-1' AFTER availability_id_in_stock3_image;", 'remove' => "ALTER TABLE products DROP quantity_stock_special" ); $table_mods_array[] = array ( 'tablename' => 'products', 'columnname' => 'quantity_stock_zero', 'create' => "ALTER TABLE products ADD quantity_stock_zero int(4) NOT NULL default '0' AFTER availability_id_in_stock_special_image;", 'remove' => "ALTER TABLE products DROP quantity_stock_zero" ); $table_mods_array[] = array ( 'tablename' => 'products', 'columnname' => 'warranty_id', 'create' => "ALTER TABLE products ADD warranty_id int(11) default '1' AFTER availability_id_in_stock_special;", 'remove' => "ALTER TABLE products DROP warranty_id" ); Best Regards Peter
  14. Yes, the field doesn't exist TABLE products_description. Please open the product_info.php and go to Line 72: // BOF: Availability $product_info_query = tep_db_query("select p.products_id, pd.products_name, pd.warranty_id_image, p.warranty_id, p.availability_id_in_stock, p.availability_id_in_stock2, p.availability_id_in_stock3, p.availability_id_in_stock_special, p.availability_id_out_of_stock, p.availability_id_in_stock_image, p.availability_id_in_stock2_image, p.availability_id_in_stock3_image, p.availability_id_in_stock_special_image, p.availability_id_out_of_stock_image, p.quantity_stock, p.quantity_stock_2, p.quantity_stock_3, p.quantity_stock_special, p.quantity_stock_zero, pd.products_description, p.products_model, p.products_quantity, p.products_image, pd.products_url, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "'"); // EOF: Availability Change it to: // BOF: Availability + Warranty $product_info_query = tep_db_query("select p.products_id, pd.products_name, w.warranty_id_image, p.warranty_id, p.availability_id_in_stock, p.availability_id_in_stock2, p.availability_id_in_stock3, p.availability_id_in_stock_special, p.availability_id_out_of_stock, p.availability_id_in_stock_image, p.availability_id_in_stock2_image, p.availability_id_in_stock3_image, p.availability_id_in_stock_special_image, p.availability_id_out_of_stock_image, p.quantity_stock, p.quantity_stock_2, p.quantity_stock_3, p.quantity_stock_special, p.quantity_stock_zero, pd.products_description, p.products_model, p.products_quantity, p.products_image, pd.products_url, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_WARRANTY . " w where p.products_status = '1' and p.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pd.products_id = p.products_id and p.warranty_id = w.warranty_id and pd.language_id = '" . (int)$languages_id . "'"); // EOF: Availability + Warranty This fix the first Error Did you have try to install the sql file or did you use only the Configurer Option ? I will fix the erros now Best Regards Peter
  15. @ surfalot: Nothing. But the Warranty Messages based on your availability messages and i have added it in the same time if i made the extension of the addon. So I could not separate the extensions and i dont have the time to do that. :( I am also fulfilled your wish to configure the addon only via the admin panel. You have made this Great Addon and so all your Credits are in it and thats good so, thats the reason why i don't Upload it as new addon. Have a look: categories.php Top categories.php availability messages Warranty Manager Based on Availability Messages Manager Best Regards Peter
×
×
  • Create New...