frog Posted January 23, 2003 Share Posted January 23, 2003 Hope that you will give a full oscommerce package for this....too difficult to implement on existing stores Quote Link to comment Share on other sites More sharing options...
elari Posted January 23, 2003 Author Share Posted January 23, 2003 ok, i will download to my dl area a full package of my osc main file you'll have also to download customers satus 3.x and qtydisplay allowed for adding non Osc files and the query Quote Link to comment Share on other sites More sharing options...
Guest Posted January 23, 2003 Share Posted January 23, 2003 Hi elari, is it also possible to set different prices for different groups of coustomers? Not in %, i need different prices for each group. any idea? THx Jan Quote Link to comment Share on other sites More sharing options...
elari Posted January 23, 2003 Author Share Posted January 23, 2003 yes standard + 3 prices (can be exapanded) avalaible by products for each group you select the price level you want Quote Link to comment Share on other sites More sharing options...
Guest Posted January 23, 2003 Share Posted January 23, 2003 sorry, i can?t understand your meanings. In my shop is no group availible. Is there some thing wrong? Quote Link to comment Share on other sites More sharing options...
elari Posted January 24, 2003 Author Share Posted January 24, 2003 like orders_status in localization you must set them first time i will add them in a query for fresh install but you can easilly add them create at least Guest Status Newsletter Satus New Customer Status define the setting for these groups then go in admin configuration / my store and set the according values for each default status Quote Link to comment Share on other sites More sharing options...
elari Posted January 24, 2003 Author Share Posted January 24, 2003 here it is .... ## Contenu de la table `customers_status` # INSERT INTO `customers_status` (`customers_status_id`, `language_id`, `customers_status_name`, `customers_status_public`, `customers_status_image`, `customers_status_price_level`, `customers_status_discount`, `customers_status_ot_discount_flag`, `customers_status_ot_discount`, `customers_status_staffelpreis`, `customers_status_payment_unallowed`, `customers_status_show_price`, `customers_status_show_price_tax`) VALUES (1, 1, 'Guest Status', 1, 'light-yellow.gif', 0, '0.00', '0', '0.00', '0', '', 0, 0); INSERT INTO `customers_status` (`customers_status_id`, `language_id`, `customers_status_name`, `customers_status_public`, `customers_status_image`, `customers_status_price_level`, `customers_status_discount`, `customers_status_ot_discount_flag`, `customers_status_ot_discount`, `customers_status_staffelpreis`, `customers_status_payment_unallowed`, `customers_status_show_price`, `customers_status_show_price_tax`) VALUES (1, 2, 'Guest Status', 1, 'light-yellow.gif', 0, '0.00', '0', '0.00', '0', '', 0, 0); INSERT INTO `customers_status` (`customers_status_id`, `language_id`, `customers_status_name`, `customers_status_public`, `customers_status_image`, `customers_status_price_level`, `customers_status_discount`, `customers_status_ot_discount_flag`, `customers_status_ot_discount`, `customers_status_staffelpreis`, `customers_status_payment_unallowed`, `customers_status_show_price`, `customers_status_show_price_tax`) VALUES (1, 3, 'Guest Status', 1, 'light-yellow.gif', 0, '0.00', '0', '0.00', '0', '', 0, 0); INSERT INTO `customers_status` (`customers_status_id`, `language_id`, `customers_status_name`, `customers_status_public`, `customers_status_image`, `customers_status_price_level`, `customers_status_discount`, `customers_status_ot_discount_flag`, `customers_status_ot_discount`, `customers_status_staffelpreis`, `customers_status_payment_unallowed`, `customers_status_show_price`, `customers_status_show_price_tax`) VALUES (1, 4, 'Guest Status', 1, 'light-yellow.gif', 0, '0.00', '0', '0.00', '0', '', 0, 0); INSERT INTO `customers_status` (`customers_status_id`, `language_id`, `customers_status_name`, `customers_status_public`, `customers_status_image`, `customers_status_price_level`, `customers_status_discount`, `customers_status_ot_discount_flag`, `customers_status_ot_discount`, `customers_status_staffelpreis`, `customers_status_payment_unallowed`, `customers_status_show_price`, `customers_status_show_price_tax`) VALUES (2, 1, 'Newsletter Only', 1, 'icon_eye.gif', 0, '10.00', '0', '0.00', '0', 'all', 1, 0); INSERT INTO `customers_status` (`customers_status_id`, `language_id`, `customers_status_name`, `customers_status_public`, `customers_status_image`, `customers_status_price_level`, `customers_status_discount`, `customers_status_ot_discount_flag`, `customers_status_ot_discount`, `customers_status_staffelpreis`, `customers_status_payment_unallowed`, `customers_status_show_price`, `customers_status_show_price_tax`) VALUES (2, 2, 'Newsletter Only', 1, 'icon_eye.gif', 0, '10.00', '0', '0.00', '0', 'all', 1, 0); INSERT INTO `customers_status` (`customers_status_id`, `language_id`, `customers_status_name`, `customers_status_public`, `customers_status_image`, `customers_status_price_level`, `customers_status_discount`, `customers_status_ot_discount_flag`, `customers_status_ot_discount`, `customers_status_staffelpreis`, `customers_status_payment_unallowed`, `customers_status_show_price`, `customers_status_show_price_tax`) VALUES (2, 3, 'Newsletter Only', 1, 'icon_eye.gif', 0, '10.00', '0', '0.00', '0', 'all', 1, 0); INSERT INTO `customers_status` (`customers_status_id`, `language_id`, `customers_status_name`, `customers_status_public`, `customers_status_image`, `customers_status_price_level`, `customers_status_discount`, `customers_status_ot_discount_flag`, `customers_status_ot_discount`, `customers_status_staffelpreis`, `customers_status_payment_unallowed`, `customers_status_show_price`, `customers_status_show_price_tax`) VALUES (2, 4, 'Newsletter Only', 1, 'icon_eye.gif', 0, '10.00', '0', '0.00', '0', 'all', 1, 0); INSERT INTO `customers_status` (`customers_status_id`, `language_id`, `customers_status_name`, `customers_status_public`, `customers_status_image`, `customers_status_price_level`, `customers_status_discount`, `customers_status_ot_discount_flag`, `customers_status_ot_discount`, `customers_status_staffelpreis`, `customers_status_payment_unallowed`, `customers_status_show_price`, `customers_status_show_price_tax`) VALUES (3, 1, 'New Customer', 1, 'smile-grey.gif', 0, '0.00', '0', '0.00', '0', '', 1, 1); INSERT INTO `customers_status` (`customers_status_id`, `language_id`, `customers_status_name`, `customers_status_public`, `customers_status_image`, `customers_status_price_level`, `customers_status_discount`, `customers_status_ot_discount_flag`, `customers_status_ot_discount`, `customers_status_staffelpreis`, `customers_status_payment_unallowed`, `customers_status_show_price`, `customers_status_show_price_tax`) VALUES (3, 2, 'Neue', 1, 'smile-grey.gif', 0, '0.00', '0', '0.00', '0', '', 1, 1); INSERT INTO `customers_status` (`customers_status_id`, `language_id`, `customers_status_name`, `customers_status_public`, `customers_status_image`, `customers_status_price_level`, `customers_status_discount`, `customers_status_ot_discount_flag`, `customers_status_ot_discount`, `customers_status_staffelpreis`, `customers_status_payment_unallowed`, `customers_status_show_price`, `customers_status_show_price_tax`) VALUES (3, 3, 'Novo', 1, 'smile-grey.gif', 0, '0.00', '0', '0.00', '0', '', 1, 1); INSERT INTO `customers_status` (`customers_status_id`, `language_id`, `customers_status_name`, `customers_status_public`, `customers_status_image`, `customers_status_price_level`, `customers_status_discount`, `customers_status_ot_discount_flag`, `customers_status_ot_discount`, `customers_status_staffelpreis`, `customers_status_payment_unallowed`, `customers_status_show_price`, `customers_status_show_price_tax`) VALUES (3, 4, 'Nouveau Client', 1, 'smile-grey.gif', 0, '0.00', '0', '0.00', '0', '', 1, 1); INSERT INTO `customers_status` (`customers_status_id`, `language_id`, `customers_status_name`, `customers_status_public`, `customers_status_image`, `customers_status_price_level`, `customers_status_discount`, `customers_status_ot_discount_flag`, `customers_status_ot_discount`, `customers_status_staffelpreis`, `customers_status_payment_unallowed`, `customers_status_show_price`, `customers_status_show_price_tax`) VALUES (4, 1, 'Trustable', 1, 'smile-yellow.gif', 0, '0.00', '0', '0.00', '0', '', 1, 1); INSERT INTO `customers_status` (`customers_status_id`, `language_id`, `customers_status_name`, `customers_status_public`, `customers_status_image`, `customers_status_price_level`, `customers_status_discount`, `customers_status_ot_discount_flag`, `customers_status_ot_discount`, `customers_status_staffelpreis`, `customers_status_payment_unallowed`, `customers_status_show_price`, `customers_status_show_price_tax`) VALUES (4, 2, 'Trustable', 1, 'smile-yellow.gif', 0, '0.00', '0', '0.00', '0', '', 1, 1); INSERT INTO `customers_status` (`customers_status_id`, `language_id`, `customers_status_name`, `customers_status_public`, `customers_status_image`, `customers_status_price_level`, `customers_status_discount`, `customers_status_ot_discount_flag`, `customers_status_ot_discount`, `customers_status_staffelpreis`, `customers_status_payment_unallowed`, `customers_status_show_price`, `customers_status_show_price_tax`) VALUES (4, 3, 'Trustable', 1, 'smile-yellow.gif', 0, '0.00', '0', '0.00', '0', '', 1, 1); INSERT INTO `customers_status` (`customers_status_id`, `language_id`, `customers_status_name`, `customers_status_public`, `customers_status_image`, `customers_status_price_level`, `customers_status_discount`, `customers_status_ot_discount_flag`, `customers_status_ot_discount`, `customers_status_staffelpreis`, `customers_status_payment_unallowed`, `customers_status_show_price`, `customers_status_show_price_tax`) VALUES (4, 4, 'Confiance', 1, 'smile-yellow.gif', 0, '0.00', '0', '0.00', '0', '', 1, 1); INSERT INTO `customers_status` (`customers_status_id`, `language_id`, `customers_status_name`, `customers_status_public`, `customers_status_image`, `customers_status_price_level`, `customers_status_discount`, `customers_status_ot_discount_flag`, `customers_status_ot_discount`, `customers_status_staffelpreis`, `customers_status_payment_unallowed`, `customers_status_show_price`, `customers_status_show_price_tax`) VALUES (5, 1, 'Care', 0, 'smile-orange.gif', 0, '0.00', '0', '0.00', '0', '', 1, 1); INSERT INTO `customers_status` (`customers_status_id`, `language_id`, `customers_status_name`, `customers_status_public`, `customers_status_image`, `customers_status_price_level`, `customers_status_discount`, `customers_status_ot_discount_flag`, `customers_status_ot_discount`, `customers_status_staffelpreis`, `customers_status_payment_unallowed`, `customers_status_show_price`, `customers_status_show_price_tax`) VALUES (5, 2, 'Care', 0, 'smile-orange.gif', 0, '0.00', '0', '0.00', '0', '', 1, 1); INSERT INTO `customers_status` (`customers_status_id`, `language_id`, `customers_status_name`, `customers_status_public`, `customers_status_image`, `customers_status_price_level`, `customers_status_discount`, `customers_status_ot_discount_flag`, `customers_status_ot_discount`, `customers_status_staffelpreis`, `customers_status_payment_unallowed`, `customers_status_show_price`, `customers_status_show_price_tax`) VALUES (5, 3, 'Care', 0, 'smile-orange.gif', 0, '0.00', '0', '0.00', '0', '', 1, 1); INSERT INTO `customers_status` (`customers_status_id`, `language_id`, `customers_status_name`, `customers_status_public`, `customers_status_image`, `customers_status_price_level`, `customers_status_discount`, `customers_status_ot_discount_flag`, `customers_status_ot_discount`, `customers_status_staffelpreis`, `customers_status_payment_unallowed`, `customers_status_show_price`, `customers_status_show_price_tax`) VALUES (5, 4, 'Faire Attention', 0, 'smile-orange.gif', 0, '0.00', '0', '0.00', '0', '', 1, 1); INSERT INTO `customers_status` (`customers_status_id`, `language_id`, `customers_status_name`, `customers_status_public`, `customers_status_image`, `customers_status_price_level`, `customers_status_discount`, `customers_status_ot_discount_flag`, `customers_status_ot_discount`, `customers_status_staffelpreis`, `customers_status_payment_unallowed`, `customers_status_show_price`, `customers_status_show_price_tax`) VALUES (6, 1, 'No COD', 0, 'smile-red.gif', 0, '0.00', '0', '0.00', '0', 'cod', 1, 1); INSERT INTO `customers_status` (`customers_status_id`, `language_id`, `customers_status_name`, `customers_status_public`, `customers_status_image`, `customers_status_price_level`, `customers_status_discount`, `customers_status_ot_discount_flag`, `customers_status_ot_discount`, `customers_status_staffelpreis`, `customers_status_payment_unallowed`, `customers_status_show_price`, `customers_status_show_price_tax`) VALUES (6, 5, 'Pas de CRBT', 0, 'smile-red.gif', 0, '0.00', '0', '0.00', '0', 'cod', 1, 1); INSERT INTO `customers_status` (`customers_status_id`, `language_id`, `customers_status_name`, `customers_status_public`, `customers_status_image`, `customers_status_price_level`, `customers_status_discount`, `customers_status_ot_discount_flag`, `customers_status_ot_discount`, `customers_status_staffelpreis`, `customers_status_payment_unallowed`, `customers_status_show_price`, `customers_status_show_price_tax`) VALUES (6, 2, 'No COD', 0, 'smile-red.gif', 0, '0.00', '0', '0.00', '0', 'cod', 1, 1); INSERT INTO `customers_status` (`customers_status_id`, `language_id`, `customers_status_name`, `customers_status_public`, `customers_status_image`, `customers_status_price_level`, `customers_status_discount`, `customers_status_ot_discount_flag`, `customers_status_ot_discount`, `customers_status_staffelpreis`, `customers_status_payment_unallowed`, `customers_status_show_price`, `customers_status_show_price_tax`) VALUES (6, 3, 'No COD', 0, 'smile-red.gif', 0, '0.00', '0', '0.00', '0', 'cod', 1, 1); INSERT INTO `customers_status` (`customers_status_id`, `language_id`, `customers_status_name`, `customers_status_public`, `customers_status_image`, `customers_status_price_level`, `customers_status_discount`, `customers_status_ot_discount_flag`, `customers_status_ot_discount`, `customers_status_staffelpreis`, `customers_status_payment_unallowed`, `customers_status_show_price`, `customers_status_show_price_tax`) VALUES (7, 1, 'Banned', 0, 'bad-man-red-light.gif', 0, '0.00', '0', '0.00', '0', '', 1, 1); INSERT INTO `customers_status` (`customers_status_id`, `language_id`, `customers_status_name`, `customers_status_public`, `customers_status_image`, `customers_status_price_level`, `customers_status_discount`, `customers_status_ot_discount_flag`, `customers_status_ot_discount`, `customers_status_staffelpreis`, `customers_status_payment_unallowed`, `customers_status_show_price`, `customers_status_show_price_tax`) VALUES (7, 4, 'Interdit', 0, 'bad-man-red-light.gif', 0, '0.00', '0', '0.00', '0', '', 1, 1); INSERT INTO `customers_status` (`customers_status_id`, `language_id`, `customers_status_name`, `customers_status_public`, `customers_status_image`, `customers_status_price_level`, `customers_status_discount`, `customers_status_ot_discount_flag`, `customers_status_ot_discount`, `customers_status_staffelpreis`, `customers_status_payment_unallowed`, `customers_status_show_price`, `customers_status_show_price_tax`) VALUES (7, 2, 'Banned', 0, 'bad-man-red-light.gif', 0, '0.00', '0', '0.00', '0', '', 1, 1); INSERT INTO `customers_status` (`customers_status_id`, `language_id`, `customers_status_name`, `customers_status_public`, `customers_status_image`, `customers_status_price_level`, `customers_status_discount`, `customers_status_ot_discount_flag`, `customers_status_ot_discount`, `customers_status_staffelpreis`, `customers_status_payment_unallowed`, `customers_status_show_price`, `customers_status_show_price_tax`) VALUES (7, 3, 'Banned', 0, 'bad-man-red-light.gif', 0, '0.00', '0', '0.00', '0', '', 1, 1); INSERT INTO `customers_status` (`customers_status_id`, `language_id`, `customers_status_name`, `customers_status_public`, `customers_status_image`, `customers_status_price_level`, `customers_status_discount`, `customers_status_ot_discount_flag`, `customers_status_ot_discount`, `customers_status_staffelpreis`, `customers_status_payment_unallowed`, `customers_status_show_price`, `customers_status_show_price_tax`) VALUES (8, 1, 'Reseller', 1, 'hand-up.gif', 0, '100.00', '0', '0.00', '0', '', 1, 1); INSERT INTO `customers_status` (`customers_status_id`, `language_id`, `customers_status_name`, `customers_status_public`, `customers_status_image`, `customers_status_price_level`, `customers_status_discount`, `customers_status_ot_discount_flag`, `customers_status_ot_discount`, `customers_status_staffelpreis`, `customers_status_payment_unallowed`, `customers_status_show_price`, `customers_status_show_price_tax`) VALUES (8, 2, 'Reseller', 1, 'hand-up.gif', 0, '100.00', '0', '0.00', '0', '', 1, 1); INSERT INTO `customers_status` (`customers_status_id`, `language_id`, `customers_status_name`, `customers_status_public`, `customers_status_image`, `customers_status_price_level`, `customers_status_discount`, `customers_status_ot_discount_flag`, `customers_status_ot_discount`, `customers_status_staffelpreis`, `customers_status_payment_unallowed`, `customers_status_show_price`, `customers_status_show_price_tax`) VALUES (8, 3, 'Reseller', 1, 'hand-up.gif', 0, '100.00', '0', '0.00', '0', '', 1, 1); INSERT INTO `customers_status` (`customers_status_id`, `language_id`, `customers_status_name`, `customers_status_public`, `customers_status_image`, `customers_status_price_level`, `customers_status_discount`, `customers_status_ot_discount_flag`, `customers_status_ot_discount`, `customers_status_staffelpreis`, `customers_status_payment_unallowed`, `customers_status_show_price`, `customers_status_show_price_tax`) VALUES (8, 4, 'Revendeur', 1, 'hand-up.gif', 0, '100.00', '0', '0.00', '0', '', 1, 1); check the default value, they are commercially non sense but just for test Quote Link to comment Share on other sites More sharing options...
elari Posted January 24, 2003 Author Share Posted January 24, 2003 and to define accorded default statuses #CHANGED 2N0124 to define new default statuses according to default values#Set the default Customers status for News Customers, Guest Not logged, Newsletter subscribe only #These options would be set in admin / my store DELETE FROM configuration WHERE configuration_key = 'DEFAULT_CUSTOMERS_STATUS_ID'; INSERT INTO configuration( configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function, date_added ) values ( 'Customers Status Guest', 'DEFAULT_CUSTOMERS_STATUS_ID_GUEST', '1', 'What would be the default customers status for a guest before logged in ?', '1', '1', 'tep_get_customers_status_name', 'tep_cfg_pull_down_customers_status_list(', now( ) ); INSERT INTO configuration( configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function, date_added ) values ( 'Customers Status For New Customers', 'DEFAULT_CUSTOMERS_STATUS_ID', '1', 'What would be the default customers status for a new customer ?', '1', '2', 'tep_get_customers_status_name', 'tep_cfg_pull_down_customers_status_list(', now( ) ); INSERT INTO configuration( configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function, date_added ) values ( 'Customers Status Subscribe to Newsletter Only', 'DEFAULT_CUSTOMERS_STATUS_ID_NEWSLETTER', '1', 'What would be the default customers status for subscribing to newsletter before without create account ?', '1', '3', 'tep_get_customers_status_name', 'tep_cfg_pull_down_customers_status_list(', now( ) ); Quote Link to comment Share on other sites More sharing options...
envy2000 Posted February 11, 2003 Share Posted February 11, 2003 elari, i have installed the 2&3x sql and am trying to insert this, but i get this error... Error SQL-query : INSERT INTO `customers_status` (`customers_status_id`, `language_id`, `customers_status_name`, `customers_status_public`, `customers_status_image`, `customers_status_price_level`, `customers_status_discount`, `customers_status_ot_discount_flag`, `customers_status_ot_discount`, `customers_status_staffelpreis`, `customers_status_payment_unallowed`, `customers_status_show_price`, `customers_status_show_price_tax`) VALUES (1, 1, 'Guest Status', 1, 'light-yellow.gif', 0, '0.00', '0', '0.00', '0', '', 0, 0) MySQL said: Unknown column 'customers_status_price_level' in 'field list' Back Quote Link to comment Share on other sites More sharing options...
envy2000 Posted February 11, 2003 Share Posted February 11, 2003 also getting this error... Fatal error: Call to undefined function: tep_db_query() in /admin/includes/functions/general_elari_cs.php on line 28 Quote Link to comment Share on other sites More sharing options...
envy2000 Posted February 12, 2003 Share Posted February 12, 2003 fatal error fixed. application_top_elari_cs.php must be after general.php include in application_top.php now i am getting this when i check out orders. 1054 - Unknown column 'orders_status_need_conf' in 'field list' select orders_status_id, orders_status_name, orders_status_need_conf, orders_status_need_conf_id, orders_status_final from orders_status where language_id = '1' [TEP STOP] People, i would not recommend installing this. It looks great, and i don't mean to slag a free contribution that someone has worked hard on, but... there is no seperation between this contribution and other contributions, so you either have to install all the contributions that elari has used, or go through and remove all references to them. This is tough, because it's not documented what code belongs to what contribution. is the above error for customer_status, or from one of these that have been included: - helpdesk 1.0 (snowman) - Product Listing Hack v.2 (Paul Crovella / John Poynton) - quantity displayed if allowed (elari) - cod customer confirmation (elari) - staffelpreise (jurgen) - support ticket from Dave - all product printable catalog 1.5 - easy populate - Advanced multilanguage guestbook (elari) - Gsm logo and ringtones - Easy news 1.1 - Faq System - list order content in admin - login box / my account modified elari for support ticket and some other i forgot... CAUTION!!! Quote Link to comment Share on other sites More sharing options...
elari Posted February 12, 2003 Author Share Posted February 12, 2003 elari, i have installed the 2&3x sql and am trying to insert this, but i get this error... Error SQL-query : INSERT INTO `customers_status` (`customers_status_id`, `language_id`, `customers_status_name`, `customers_status_public`, `customers_status_image`, `customers_status_price_level`, `customers_status_discount`, `customers_status_ot_discount_flag`, `customers_status_ot_discount`, `customers_status_staffelpreis`, `customers_status_payment_unallowed`, `customers_status_show_price`, `customers_status_show_price_tax`) VALUES (1, 1, 'Guest Status', 1, 'light-yellow.gif', 0, '0.00', '0', '0.00', '0', '', 0, 0) MySQL said: Unknown column 'customers_status_price_level' in 'field list' Back you missed that in the querry #Added 2N0117 Set the price level for each status ALTER TABLE `customers_status` ADD `customers_status_price_level` INT(1) DEFAULT '0' NOT NULL AFTER `customers_status_image` ; certaily also miss what follow #Added 2N0121 New field for upgrading osc since 14 Jan 03 to add new configuration for core osc#INSERT INTO configuration_group VALUES ('14', 'GZip Compression', 'GZip compression options', '14', '1'); #INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Enable GZip Compression', 'GZIP_COMPRESSION', 'false', 'Enable HTTP GZip compression.', '14', '1', 'tep_cfg_select_option(array('true', 'false'), ', now()); #INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Compression Level', 'GZIP_LEVEL', '5', 'Use this compression level 0-9 (0 = minimum, 9 = maximum).', '14', '2', now()); ######################################################################## #################PACKAGE PUBLISHED 2N0117 -> 2N0123 # ######################################################################## #Added 2N0124 for request of default status missing # Contenu de la table `customers_status` INSERT INTO `customers_status` (`customers_status_id`, `language_id`, `customers_status_name`, `customers_status_public`, `customers_status_image`, `customers_status_price_level`, `customers_status_discount`, `customers_status_ot_discount_flag`, `customers_status_ot_discount`, `customers_status_staffelpreis`, `customers_status_payment_unallowed`, `customers_status_show_price`, `customers_status_show_price_tax`) VALUES (1, 1, 'Guest Status', 1, 'light-yellow.gif', 0, '0.00', '0', '0.00', '0', '', 0, 0); INSERT INTO `customers_status` (`customers_status_id`, `language_id`, `customers_status_name`, `customers_status_public`, `customers_status_image`, `customers_status_price_level`, `customers_status_discount`, `customers_status_ot_discount_flag`, `customers_status_ot_discount`, `customers_status_staffelpreis`, `customers_status_payment_unallowed`, `customers_status_show_price`, `customers_status_show_price_tax`) VALUES (1, 2, 'Guest Status', 1, 'light-yellow.gif', 0, '0.00', '0', '0.00', '0', '', 0, 0); INSERT INTO `customers_status` (`customers_status_id`, `language_id`, `customers_status_name`, `customers_status_public`, `customers_status_image`, `customers_status_price_level`, `customers_status_discount`, `customers_status_ot_discount_flag`, `customers_status_ot_discount`, `customers_status_staffelpreis`, `customers_status_payment_unallowed`, `customers_status_show_price`, `customers_status_show_price_tax`) VALUES (1, 3, 'Guest Status', 1, 'light-yellow.gif', 0, '0.00', '0', '0.00', '0', '', 0, 0); INSERT INTO `customers_status` (`customers_status_id`, `language_id`, `customers_status_name`, `customers_status_public`, `customers_status_image`, `customers_status_price_level`, `customers_status_discount`, `customers_status_ot_discount_flag`, `customers_status_ot_discount`, `customers_status_staffelpreis`, `customers_status_payment_unallowed`, `customers_status_show_price`, `customers_status_show_price_tax`) VALUES (1, 4, 'Guest Status', 1, 'light-yellow.gif', 0, '0.00', '0', '0.00', '0', '', 0, 0); INSERT INTO `customers_status` (`customers_status_id`, `language_id`, `customers_status_name`, `customers_status_public`, `customers_status_image`, `customers_status_price_level`, `customers_status_discount`, `customers_status_ot_discount_flag`, `customers_status_ot_discount`, `customers_status_staffelpreis`, `customers_status_payment_unallowed`, `customers_status_show_price`, `customers_status_show_price_tax`) VALUES (2, 1, 'Newsletter Only', 1, 'icon_eye.gif', 0, '10.00', '0', '0.00', '0', 'all', 1, 0); INSERT INTO `customers_status` (`customers_status_id`, `language_id`, `customers_status_name`, `customers_status_public`, `customers_status_image`, `customers_status_price_level`, `customers_status_discount`, `customers_status_ot_discount_flag`, `customers_status_ot_discount`, `customers_status_staffelpreis`, `customers_status_payment_unallowed`, `customers_status_show_price`, `customers_status_show_price_tax`) VALUES (2, 2, 'Newsletter Only', 1, 'icon_eye.gif', 0, '10.00', '0', '0.00', '0', 'all', 1, 0); INSERT INTO `customers_status` (`customers_status_id`, `language_id`, `customers_status_name`, `customers_status_public`, `customers_status_image`, `customers_status_price_level`, `customers_status_discount`, `customers_status_ot_discount_flag`, `customers_status_ot_discount`, `customers_status_staffelpreis`, `customers_status_payment_unallowed`, `customers_status_show_price`, `customers_status_show_price_tax`) VALUES (2, 3, 'Newsletter Only', 1, 'icon_eye.gif', 0, '10.00', '0', '0.00', '0', 'all', 1, 0); INSERT INTO `customers_status` (`customers_status_id`, `language_id`, `customers_status_name`, `customers_status_public`, `customers_status_image`, `customers_status_price_level`, `customers_status_discount`, `customers_status_ot_discount_flag`, `customers_status_ot_discount`, `customers_status_staffelpreis`, `customers_status_payment_unallowed`, `customers_status_show_price`, `customers_status_show_price_tax`) VALUES (2, 4, 'Newsletter Only', 1, 'icon_eye.gif', 0, '10.00', '0', '0.00', '0', 'all', 1, 0); INSERT INTO `customers_status` (`customers_status_id`, `language_id`, `customers_status_name`, `customers_status_public`, `customers_status_image`, `customers_status_price_level`, `customers_status_discount`, `customers_status_ot_discount_flag`, `customers_status_ot_discount`, `customers_status_staffelpreis`, `customers_status_payment_unallowed`, `customers_status_show_price`, `customers_status_show_price_tax`) VALUES (3, 1, 'New Customer', 1, 'smile-grey.gif', 0, '0.00', '0', '0.00', '0', '', 1, 1); INSERT INTO `customers_status` (`customers_status_id`, `language_id`, `customers_status_name`, `customers_status_public`, `customers_status_image`, `customers_status_price_level`, `customers_status_discount`, `customers_status_ot_discount_flag`, `customers_status_ot_discount`, `customers_status_staffelpreis`, `customers_status_payment_unallowed`, `customers_status_show_price`, `customers_status_show_price_tax`) VALUES (3, 2, 'Neue', 1, 'smile-grey.gif', 0, '0.00', '0', '0.00', '0', '', 1, 1); INSERT INTO `customers_status` (`customers_status_id`, `language_id`, `customers_status_name`, `customers_status_public`, `customers_status_image`, `customers_status_price_level`, `customers_status_discount`, `customers_status_ot_discount_flag`, `customers_status_ot_discount`, `customers_status_staffelpreis`, `customers_status_payment_unallowed`, `customers_status_show_price`, `customers_status_show_price_tax`) VALUES (3, 3, 'Novo', 1, 'smile-grey.gif', 0, '0.00', '0', '0.00', '0', '', 1, 1); INSERT INTO `customers_status` (`customers_status_id`, `language_id`, `customers_status_name`, `customers_status_public`, `customers_status_image`, `customers_status_price_level`, `customers_status_discount`, `customers_status_ot_discount_flag`, `customers_status_ot_discount`, `customers_status_staffelpreis`, `customers_status_payment_unallowed`, `customers_status_show_price`, `customers_status_show_price_tax`) VALUES (3, 4, 'Nouveau Client', 1, 'smile-grey.gif', 0, '0.00', '0', '0.00', '0', '', 1, 1); INSERT INTO `customers_status` (`customers_status_id`, `language_id`, `customers_status_name`, `customers_status_public`, `customers_status_image`, `customers_status_price_level`, `customers_status_discount`, `customers_status_ot_discount_flag`, `customers_status_ot_discount`, `customers_status_staffelpreis`, `customers_status_payment_unallowed`, `customers_status_show_price`, `customers_status_show_price_tax`) VALUES (4, 1, 'Trustable', 1, 'smile-yellow.gif', 0, '0.00', '0', '0.00', '0', '', 1, 1); INSERT INTO `customers_status` (`customers_status_id`, `language_id`, `customers_status_name`, `customers_status_public`, `customers_status_image`, `customers_status_price_level`, `customers_status_discount`, `customers_status_ot_discount_flag`, `customers_status_ot_discount`, `customers_status_staffelpreis`, `customers_status_payment_unallowed`, `customers_status_show_price`, `customers_status_show_price_tax`) VALUES (4, 2, 'Trustable', 1, 'smile-yellow.gif', 0, '0.00', '0', '0.00', '0', '', 1, 1); INSERT INTO `customers_status` (`customers_status_id`, `language_id`, `customers_status_name`, `customers_status_public`, `customers_status_image`, `customers_status_price_level`, `customers_status_discount`, `customers_status_ot_discount_flag`, `customers_status_ot_discount`, `customers_status_staffelpreis`, `customers_status_payment_unallowed`, `customers_status_show_price`, `customers_status_show_price_tax`) VALUES (4, 3, 'Trustable', 1, 'smile-yellow.gif', 0, '0.00', '0', '0.00', '0', '', 1, 1); INSERT INTO `customers_status` (`customers_status_id`, `language_id`, `customers_status_name`, `customers_status_public`, `customers_status_image`, `customers_status_price_level`, `customers_status_discount`, `customers_status_ot_discount_flag`, `customers_status_ot_discount`, `customers_status_staffelpreis`, `customers_status_payment_unallowed`, `customers_status_show_price`, `customers_status_show_price_tax`) VALUES (4, 4, 'Confiance', 1, 'smile-yellow.gif', 0, '0.00', '0', '0.00', '0', '', 1, 1); INSERT INTO `customers_status` (`customers_status_id`, `language_id`, `customers_status_name`, `customers_status_public`, `customers_status_image`, `customers_status_price_level`, `customers_status_discount`, `customers_status_ot_discount_flag`, `customers_status_ot_discount`, `customers_status_staffelpreis`, `customers_status_payment_unallowed`, `customers_status_show_price`, `customers_status_show_price_tax`) VALUES (5, 1, 'Care', 0, 'smile-orange.gif', 0, '0.00', '0', '0.00', '0', '', 1, 1); INSERT INTO `customers_status` (`customers_status_id`, `language_id`, `customers_status_name`, `customers_status_public`, `customers_status_image`, `customers_status_price_level`, `customers_status_discount`, `customers_status_ot_discount_flag`, `customers_status_ot_discount`, `customers_status_staffelpreis`, `customers_status_payment_unallowed`, `customers_status_show_price`, `customers_status_show_price_tax`) VALUES (5, 2, 'Care', 0, 'smile-orange.gif', 0, '0.00', '0', '0.00', '0', '', 1, 1); INSERT INTO `customers_status` (`customers_status_id`, `language_id`, `customers_status_name`, `customers_status_public`, `customers_status_image`, `customers_status_price_level`, `customers_status_discount`, `customers_status_ot_discount_flag`, `customers_status_ot_discount`, `customers_status_staffelpreis`, `customers_status_payment_unallowed`, `customers_status_show_price`, `customers_status_show_price_tax`) VALUES (5, 3, 'Care', 0, 'smile-orange.gif', 0, '0.00', '0', '0.00', '0', '', 1, 1); INSERT INTO `customers_status` (`customers_status_id`, `language_id`, `customers_status_name`, `customers_status_public`, `customers_status_image`, `customers_status_price_level`, `customers_status_discount`, `customers_status_ot_discount_flag`, `customers_status_ot_discount`, `customers_status_staffelpreis`, `customers_status_payment_unallowed`, `customers_status_show_price`, `customers_status_show_price_tax`) VALUES (5, 4, 'Faire Attention', 0, 'smile-orange.gif', 0, '0.00', '0', '0.00', '0', '', 1, 1); INSERT INTO `customers_status` (`customers_status_id`, `language_id`, `customers_status_name`, `customers_status_public`, `customers_status_image`, `customers_status_price_level`, `customers_status_discount`, `customers_status_ot_discount_flag`, `customers_status_ot_discount`, `customers_status_staffelpreis`, `customers_status_payment_unallowed`, `customers_status_show_price`, `customers_status_show_price_tax`) VALUES (6, 1, 'No COD', 0, 'smile-red.gif', 0, '0.00', '0', '0.00', '0', 'cod', 1, 1); INSERT INTO `customers_status` (`customers_status_id`, `language_id`, `customers_status_name`, `customers_status_public`, `customers_status_image`, `customers_status_price_level`, `customers_status_discount`, `customers_status_ot_discount_flag`, `customers_status_ot_discount`, `customers_status_staffelpreis`, `customers_status_payment_unallowed`, `customers_status_show_price`, `customers_status_show_price_tax`) VALUES (6, 5, 'Pas de CRBT', 0, 'smile-red.gif', 0, '0.00', '0', '0.00', '0', 'cod', 1, 1); INSERT INTO `customers_status` (`customers_status_id`, `language_id`, `customers_status_name`, `customers_status_public`, `customers_status_image`, `customers_status_price_level`, `customers_status_discount`, `customers_status_ot_discount_flag`, `customers_status_ot_discount`, `customers_status_staffelpreis`, `customers_status_payment_unallowed`, `customers_status_show_price`, `customers_status_show_price_tax`) VALUES (6, 2, 'No COD', 0, 'smile-red.gif', 0, '0.00', '0', '0.00', '0', 'cod', 1, 1); INSERT INTO `customers_status` (`customers_status_id`, `language_id`, `customers_status_name`, `customers_status_public`, `customers_status_image`, `customers_status_price_level`, `customers_status_discount`, `customers_status_ot_discount_flag`, `customers_status_ot_discount`, `customers_status_staffelpreis`, `customers_status_payment_unallowed`, `customers_status_show_price`, `customers_status_show_price_tax`) VALUES (6, 3, 'No COD', 0, 'smile-red.gif', 0, '0.00', '0', '0.00', '0', 'cod', 1, 1); INSERT INTO `customers_status` (`customers_status_id`, `language_id`, `customers_status_name`, `customers_status_public`, `customers_status_image`, `customers_status_price_level`, `customers_status_discount`, `customers_status_ot_discount_flag`, `customers_status_ot_discount`, `customers_status_staffelpreis`, `customers_status_payment_unallowed`, `customers_status_show_price`, `customers_status_show_price_tax`) VALUES (7, 1, 'Banned', 0, 'bad-man-red-light.gif', 0, '0.00', '0', '0.00', '0', '', 1, 1); INSERT INTO `customers_status` (`customers_status_id`, `language_id`, `customers_status_name`, `customers_status_public`, `customers_status_image`, `customers_status_price_level`, `customers_status_discount`, `customers_status_ot_discount_flag`, `customers_status_ot_discount`, `customers_status_staffelpreis`, `customers_status_payment_unallowed`, `customers_status_show_price`, `customers_status_show_price_tax`) VALUES (7, 4, 'Interdit', 0, 'bad-man-red-light.gif', 0, '0.00', '0', '0.00', '0', '', 1, 1); INSERT INTO `customers_status` (`customers_status_id`, `language_id`, `customers_status_name`, `customers_status_public`, `customers_status_image`, `customers_status_price_level`, `customers_status_discount`, `customers_status_ot_discount_flag`, `customers_status_ot_discount`, `customers_status_staffelpreis`, `customers_status_payment_unallowed`, `customers_status_show_price`, `customers_status_show_price_tax`) VALUES (7, 2, 'Banned', 0, 'bad-man-red-light.gif', 0, '0.00', '0', '0.00', '0', '', 1, 1); INSERT INTO `customers_status` (`customers_status_id`, `language_id`, `customers_status_name`, `customers_status_public`, `customers_status_image`, `customers_status_price_level`, `customers_status_discount`, `customers_status_ot_discount_flag`, `customers_status_ot_discount`, `customers_status_staffelpreis`, `customers_status_payment_unallowed`, `customers_status_show_price`, `customers_status_show_price_tax`) VALUES (7, 3, 'Banned', 0, 'bad-man-red-light.gif', 0, '0.00', '0', '0.00', '0', '', 1, 1); INSERT INTO `customers_status` (`customers_status_id`, `language_id`, `customers_status_name`, `customers_status_public`, `customers_status_image`, `customers_status_price_level`, `customers_status_discount`, `customers_status_ot_discount_flag`, `customers_status_ot_discount`, `customers_status_staffelpreis`, `customers_status_payment_unallowed`, `customers_status_show_price`, `customers_status_show_price_tax`) VALUES (8, 1, 'Reseller', 1, 'hand-up.gif', 0, '100.00', '0', '0.00', '0', '', 1, 1); INSERT INTO `customers_status` (`customers_status_id`, `language_id`, `customers_status_name`, `customers_status_public`, `customers_status_image`, `customers_status_price_level`, `customers_status_discount`, `customers_status_ot_discount_flag`, `customers_status_ot_discount`, `customers_status_staffelpreis`, `customers_status_payment_unallowed`, `customers_status_show_price`, `customers_status_show_price_tax`) VALUES (8, 2, 'Reseller', 1, 'hand-up.gif', 0, '100.00', '0', '0.00', '0', '', 1, 1); INSERT INTO `customers_status` (`customers_status_id`, `language_id`, `customers_status_name`, `customers_status_public`, `customers_status_image`, `customers_status_price_level`, `customers_status_discount`, `customers_status_ot_discount_flag`, `customers_status_ot_discount`, `customers_status_staffelpreis`, `customers_status_payment_unallowed`, `customers_status_show_price`, `customers_status_show_price_tax`) VALUES (8, 3, 'Reseller', 1, 'hand-up.gif', 0, '100.00', '0', '0.00', '0', '', 1, 1); INSERT INTO `customers_status` (`customers_status_id`, `language_id`, `customers_status_name`, `customers_status_public`, `customers_status_image`, `customers_status_price_level`, `customers_status_discount`, `customers_status_ot_discount_flag`, `customers_status_ot_discount`, `customers_status_staffelpreis`, `customers_status_payment_unallowed`, `customers_status_show_price`, `customers_status_show_price_tax`) VALUES (8, 4, 'Revendeur', 1, 'hand-up.gif', 0, '100.00', '0', '0.00', '0', '', 1, 1); #CHANGED 2N0124 to define new default statuses according to default values #Set the default Customers status for News Customers, Guest Not logged, Newsletter subscribe only #These options would be set in admin / my store DELETE FROM configuration WHERE configuration_key = 'DEFAULT_CUSTOMERS_STATUS_ID'; INSERT INTO configuration( configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function, date_added ) values ( 'Customers Status Guest', 'DEFAULT_CUSTOMERS_STATUS_ID_GUEST', '1', 'What would be the default customers status for a guest before logged in ?', '1', '1', 'tep_get_customers_status_name', 'tep_cfg_pull_down_customers_status_list(', now( ) ); INSERT INTO configuration( configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function, date_added ) values ( 'Customers Status For New Customers', 'DEFAULT_CUSTOMERS_STATUS_ID', '1', 'What would be the default customers status for a new customer ?', '1', '2', 'tep_get_customers_status_name', 'tep_cfg_pull_down_customers_status_list(', now( ) ); INSERT INTO configuration( configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function, date_added ) values ( 'Customers Status Subscribe to Newsletter Only', 'DEFAULT_CUSTOMERS_STATUS_ID_NEWSLETTER', '1', 'What would be the default customers status for subscribing to newsletter before without create account ?', '1', '3', 'tep_get_customers_status_name', 'tep_cfg_pull_down_customers_status_list(', now( ) ); ######################################################################## #################PACKAGE PRIVATE -> 2N0130 # ######################################################################## #2n0203 change the value of customers satus box for admin DELETE FROM configuration WHERE configuration_key = 'DEFAULT_CUSTOMERS_STATUS_ID_GUEST'; DELETE FROM configuration WHERE configuration_key = 'DEFAULT_CUSTOMERS_STATUS_ID_NEWSLETTER'; DELETE FROM configuration WHERE configuration_key = 'DEFAULT_CUSTOMERS_STATUS_ID'; INSERT INTO configuration_group VALUES ('98', 'Customer Status', 'Customers Status Default Option', '98', '1'); INSERT INTO configuration( configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function, date_added ) values ( 'Customers Status Guest', 'DEFAULT_CUSTOMERS_STATUS_ID_GUEST', '1', 'What would be the default customers status for a guest before logged in ?', '98', '1', 'tep_get_customers_status_name', 'tep_cfg_pull_down_customers_status_list(', now( ) ); INSERT INTO configuration( configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function, date_added ) values ( 'Customers Status Subscribe to Newsletter Only', 'DEFAULT_CUSTOMERS_STATUS_ID_NEWSLETTER', '2', 'What would be the default customers status for subscribing to newsletter before without create account ?', '98', '2', 'tep_get_customers_status_name', 'tep_cfg_pull_down_customers_status_list(', now( ) ); INSERT INTO configuration( configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function, date_added ) values ( 'Customers Status For New Customers', 'DEFAULT_CUSTOMERS_STATUS_ID', '3', 'What would be the default customers status for a new customer ?', '98', '3', 'tep_get_customers_status_name', 'tep_cfg_pull_down_customers_status_list(', now( ) ); Quote Link to comment Share on other sites More sharing options...
elari Posted February 12, 2003 Author Share Posted February 12, 2003 fatal error fixed. application_top_elari_cs.php must be after general.php include in application_top.php reread install file before Add String & Function to add in both catalog & admin directory You can add these lines at the end of each files, just before existing last line ?> Admin Part - In /includes/application_top.php add include('includes/application_top_elari_cs.php'); - In /includes/functions/general.php add include('includes/functions/general_elari_cs.php'); - In /includes/languages/english.php add include('includes/languages/english_elari_cs.php'); - In /includes/languages/french.php add include('includes/languages/french_elari_cs.php'); - In /includes/languages/espanol.php add include('includes/languages/espanol_elari_cs.php'); - In /includes/languages/german.php add include('includes/languages/german_elari_cs.php'); Catalog Part - In /includes/functions/general.php add include('includes/functions/general_elari_cs.php'); now i am getting this when i check out orders. 1054 - Unknown column 'orders_status_need_conf' in 'field list' select orders_status_id, orders_status_name, orders_status_need_conf, orders_status_need_conf_id, orders_status_final from orders_status where language_id = '1' [TEP STOP] this is part of DOS_Payment, you can install it or remove unnecessary change People, i would not recommend installing this. It looks great, and i don't mean to slag a free contribution that someone has worked hard on, but... there is no seperation between this contribution and other contributions, so you either have to install all the contributions that elari has used, or go through and remove all references to them. This is tough, because it's not documented what code belongs to what contribution. is the above error for customer_status, or from one of these that have been included: - helpdesk 1.0 (snowman) - Product Listing Hack v.2 (Paul Crovella / John Poynton) - quantity displayed if allowed (elari) - cod customer confirmation (elari) - staffelpreise (jurgen) - support ticket from Dave - all product printable catalog 1.5 - easy populate - Advanced multilanguage guestbook (elari) - Gsm logo and ringtones - Easy news 1.1 - Faq System - list order content in admin - login box / my account modified elari for support ticket and some other i forgot... CAUTION!!! yes this is why all osc files are in a separate osc_files that MUST be compared to the file you have. most change made are indicated in files 1/ in the header there is indicated the hack installed 2/ before most files i have changed i have added the corresponding hack so just have to read and make working your brain :twisted: i agree this is a hard to install contrib, but i will not manage only for your ease plenty version of my change that will be too easy break & loose many part yes, again, this is hard to implement cstatus, but this is the only way i found to be nearest osc implementation and coding statndard without adding too many separate query that overload server & nobody force you to use it :) last, you can pay me to install all contrib directly on your server :))) Quote Link to comment Share on other sites More sharing options...
frog Posted February 12, 2003 Share Posted February 12, 2003 yes, again, this is hard to implement cstatus, but this is the only way i found to be nearest osc implementation and coding statndard without adding too many separate query that overload server & nobody force you to use it :) last, you can pay me to install all contrib directly on your server :))) Hello elari and hello guys! I wanted to have an ecomm website for me and the customers status was fine to me. I can say that the hack from the osc was too hard to me and so i moved to a "normal" oscommerce Anyway I would like to say that elari was very nice with me and supported me a lot so please don't blame if the contribution is too hard to install. It's free and so if You are not able to hack, don't hack or pay a person that is able to. Anyway, a good gift certificate for elari will be the first thing i will do when I'll open the online store Quote Link to comment Share on other sites More sharing options...
envy2000 Posted February 12, 2003 Share Posted February 12, 2003 thanks for the help. i went to install the sql you provided through phpmyadmin and got this Error SQL-query : INSERT INTO `customers_status` (`customers_status_id`, `language_id`, `customers_status_name`, `customers_status_public`, `customers_status_image`, `customers_status_price_level`, `customers_status_discount`, `customers_status_ot_discount_flag`, `customers_status_ot_discount`, `customers_status_staffelpreis`, `customers_status_payment_unallowed`, `customers_status_show_price`, `customers_status_show_price_tax`) VALUES (1, 1, 'Guest Status', 1, 'light-yellow.gif', 0, '0.00', '0', '0.00', '0', '', 0, 0) MySQL said: Duplicate entry '1-1' for key 1 here's the table... Field Type Attributes Null Default Extra Action customers_status_id int(11) No 0 Change Drop Primary Index Unique Fulltext language_id int(11) No 1 Change Drop Primary Index Unique Fulltext customers_status_name varchar(32) No Change Drop Primary Index Unique Fulltext customers_status_public int(1) No 1 Change Drop Primary Index Unique Fulltext customers_status_image varchar(64) Yes NULL Change Drop Primary Index Unique Fulltext customers_status_price_level int(1) No 0 Change Drop Primary Index Unique Fulltext customers_status_discount decimal(4,2) Yes 0.00 Change Drop Primary Index Unique Fulltext customers_status_ot_discount_flag char(1) No 0 Change Drop Primary Index Unique Fulltext customers_status_ot_discount decimal(4,2) Yes 0.00 Change Drop Primary Index Unique Fulltext customers_status_staffelpreis char(1) No Change Drop Primary Index Unique Fulltext customers_status_show_price int(1) No 1 Change Drop Primary Index Unique Fulltext customers_status_show_price_tax int(1) No 1 Change Drop Primary Index Unique Fulltext customers_status_payment_unallowed varchar(255) No Change Drop Primary Index Unique Fulltext -------- You are right nobody forced me to use it. i just wanted to warn people of limited experience not to try installing this. yes this is why all osc files are in a separate osc_files that MUST be compared to the file you have. most change made are indicated in files most contributions that i have seen provide just the code changes, not the full install files. this may confuse people. i have never seen the DOS cont before, so i was not sure if it is a part of this or not. I think that it's not a bad way to do it, it was really easy with Beyond Compare, but i think the challenge for people comes when the aren't sure if it is another contribution or this one. Basically i think OSC needs a module install application like postnuke. it's slick. :) thanks for your help. Ryan Quote Link to comment Share on other sites More sharing options...
ibandyop Posted February 12, 2003 Share Posted February 12, 2003 Basically i think OSC needs a module install application like postnuke. it's slick. :) I believe that is being investigated for a totally new version. Customer Status 2.x works great for me ! I am just waiting for the fantastic pace at which elari delivers code for 3.x to stabilize before I try to integrate it. Customer status is a fantastic and complicated modification, and I am extremelly happy that he has taken up the challenge and is giving this to the community for free. In elari's defence, He does provide a loaded version at: http://www.unlockgsm.com/dload-osc/pafiled...n=category&id=4 Granted it does not have Customer Status 3x yet, but I am sure he can put it there soon. Very helpful if your starting a new store. Eagerly awaiting a stable version :lol: Quote ibandyop Link to comment Share on other sites More sharing options...
elari Posted February 12, 2003 Author Share Posted February 12, 2003 will be ready with ms1 :) which we all hope will ease some update on stable basis Quote Link to comment Share on other sites More sharing options...
elari Posted February 12, 2003 Author Share Posted February 12, 2003 most contributions that i have seen provide just the code changes, not the full install files. this may confuse people. i have never seen the DOS cont before, so i was not sure if it is a part of this or not.Ryan as you can see the number of change to make, i can not provide a " how to" and which line to change, it will make more work, more errors... i think providing the files i use is the best way and make compare i prefer using examdiff pro v3 from prestosoft it's really the most powerfull tool i've found Quote Link to comment Share on other sites More sharing options...
envy2000 Posted February 13, 2003 Share Posted February 13, 2003 elari, any ideas? SQL-query : INSERT INTO `customers_status` (`customers_status_id`, `language_id`, `customers_status_name`, `customers_status_public`, `customers_status_image`, `customers_status_price_level`, `customers_status_discount`, `customers_status_ot_discount_flag`, `customers_status_ot_discount`, `customers_status_staffelpreis`, `customers_status_payment_unallowed`, `customers_status_show_price`, `customers_status_show_price_tax`) VALUES (1, 1, 'Guest Status', 1, 'light-yellow.gif', 0, '0.00', '0', '0.00', '0', '', 0, 0) MySQL said: Duplicate entry '1-1' for key 1 1054 - Unknown column 'date_finished' in 'field list' select customers_name, customers_company, customers_street_address, customers_suburb, customers_city, customers_postcode, customers_state, customers_country, customers_telephone, customers_email_address, customers_address_format_id, delivery_name, delivery_company, delivery_street_address, delivery_suburb, delivery_city, delivery_postcode, delivery_state, delivery_country, delivery_address_format_id, billing_name, billing_company, billing_street_address, billing_suburb, billing_city, billing_postcode, billing_state, billing_country, billing_address_format_id, payment_method, cc_type, cc_owner, cc_number, cc_expires, comments, currency, currency_value, date_purchased, orders_status, last_modified, customers_fax, customers_ip_order, customers_ip_order_host, customers_ip_confirm, customers_ip_confirm_host, customers_status, customers_status_name, customers_status_image, customers_status_discount, date_finished, orders_status_closed, orders_status_need_conf, orders_status_need_conf_password from orders where orders_id = '100' here's the table... Field Type Attributes Null Default Extra Action customers_status_id int(11) No 0 Change Drop Primary Index Unique Fulltext language_id int(11) No 1 Change Drop Primary Index Unique Fulltext customers_status_name varchar(32) No Change Drop Primary Index Unique Fulltext customers_status_public int(1) No 1 Change Drop Primary Index Unique Fulltext customers_status_image varchar(64) Yes NULL Change Drop Primary Index Unique Fulltext customers_status_price_level int(1) No 0 Change Drop Primary Index Unique Fulltext customers_status_discount decimal(4,2) Yes 0.00 Change Drop Primary Index Unique Fulltext customers_status_ot_discount_flag char(1) No 0 Change Drop Primary Index Unique Fulltext customers_status_ot_discount decimal(4,2) Yes 0.00 Change Drop Primary Index Unique Fulltext customers_status_staffelpreis char(1) No Change Drop Primary Index Unique Fulltext customers_status_show_price int(1) No 1 Change Drop Primary Index Unique Fulltext customers_status_show_price_tax int(1) No 1 Change Drop Primary Index Unique Fulltext customers_status_payment_unallowed varchar(255) No Change Drop Primary Index Unique Fulltext Quote Link to comment Share on other sites More sharing options...
elari Posted February 13, 2003 Author Share Posted February 13, 2003 elari, any ideas? SQL-query : INSERT INTO `customers_status` (`customers_status_id`, `language_id`, `customers_status_name`, `customers_status_public`, `customers_status_image`, `customers_status_price_level`, `customers_status_discount`, `customers_status_ot_discount_flag`, `customers_status_ot_discount`, `customers_status_staffelpreis`, `customers_status_payment_unallowed`, `customers_status_show_price`, `customers_status_show_price_tax`) VALUES (1, 1, 'Guest Status', 1, 'light-yellow.gif', 0, '0.00', '0', '0.00', '0', '', 0, 0) MySQL said: Duplicate entry '1-1' for key 1 you already have this data in your table 1054 - Unknown column 'date_finished' in 'field list' select customers_name, customers_company, customers_street_address, customers_suburb, customers_city, customers_postcode, customers_state, customers_country, customers_telephone, customers_email_address, customers_address_format_id, delivery_name, delivery_company, delivery_street_address, delivery_suburb, delivery_city, delivery_postcode, delivery_state, delivery_country, delivery_address_format_id, billing_name, billing_company, billing_street_address, billing_suburb, billing_city, billing_postcode, billing_state, billing_country, billing_address_format_id, payment_method, cc_type, cc_owner, cc_number, cc_expires, comments, currency, currency_value, date_purchased, orders_status, last_modified, customers_fax, customers_ip_order, customers_ip_order_host, customers_ip_confirm, customers_ip_confirm_host, customers_status, customers_status_name, customers_status_image, customers_status_discount, date_finished, orders_status_closed, orders_status_need_conf, orders_status_need_conf_password from orders where orders_id = '100' here's the table... Field Type Attributes Null Default Extra Action customers_status_id int(11) No 0 Change Drop Primary Index Unique Fulltext language_id int(11) No 1 Change Drop Primary Index Unique Fulltext customers_status_name varchar(32) No Change Drop Primary Index Unique Fulltext customers_status_public int(1) No 1 Change Drop Primary Index Unique Fulltext customers_status_image varchar(64) Yes NULL Change Drop Primary Index Unique Fulltext customers_status_price_level int(1) No 0 Change Drop Primary Index Unique Fulltext customers_status_discount decimal(4,2) Yes 0.00 Change Drop Primary Index Unique Fulltext customers_status_ot_discount_flag char(1) No 0 Change Drop Primary Index Unique Fulltext customers_status_ot_discount decimal(4,2) Yes 0.00 Change Drop Primary Index Unique Fulltext customers_status_staffelpreis char(1) No Change Drop Primary Index Unique Fulltext customers_status_show_price int(1) No 1 Change Drop Primary Index Unique Fulltext customers_status_show_price_tax int(1) No 1 Change Drop Primary Index Unique Fulltext customers_status_payment_unallowed varchar(255) No Change Drop Primary Index Unique Fulltext you have to set this field in the table 'date_finished' in tha table 'ORDERS' not 'customers_status' read the query line by line, compare with your actual tables and make your brain work a little more :) Quote Link to comment Share on other sites More sharing options...
Farrukh Posted February 14, 2003 Share Posted February 14, 2003 elari I have made the necessary changes but where do I see the settings of what I have done. Where is it in the admin section? Quote Link to comment Share on other sites More sharing options...
Waza04 Posted February 16, 2003 Share Posted February 16, 2003 Hiya All, I just love this mod!! Anyways, is there any way tobe able to let the admin set the image ov a 'customer status' in some other way than it is now (Browse) as this is a pain in the ass!! Maybe a drop down list or something, im sure you'll agree this would be better. Thanks, Warren Quote Link to comment Share on other sites More sharing options...
Waza04 Posted February 17, 2003 Share Posted February 17, 2003 OH NO!!!!!!!!!!!!!!!!!! I have just found a problem with my cart!! I will pay for anyone to fix this!! Whenever a customer signs up, it automatically makes them a newsletter account no matter how they do it (ie if the sign up for a full account) and when they want to upgrade, it still remain as a news account! Anybody, please, Remeber I can PAY!! PM Me or suggest what the matter may be, PLEASE!! Warren Quote Link to comment Share on other sites More sharing options...
Waza04 Posted February 17, 2003 Share Posted February 17, 2003 PLZ :( :( :( :( :( Quote Link to comment Share on other sites More sharing options...
Waza04 Posted February 17, 2003 Share Posted February 17, 2003 :evil: :evil: :evil: :evil: Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.