jolilola Posted May 2, 2010 Share Posted May 2, 2010 hello, i'm sorry but it's ok now. i have a bad date_base.php think florian Quote Link to comment Share on other sites More sharing options...
IronMaiden400081 Posted May 13, 2010 Share Posted May 13, 2010 My problem is, if we add details in the admin,say I mention a drop down box for customer membership Membership:- Free Premium It is displayed when customer tries to create the account But how can I display it in the customer details section in the admin panel?so that admin along with the displayed fields can also see what membership the customer has. Or how can I add a flag next to a customer field in which the admin can mention the customer as "Free" or "Premium" Quote Link to comment Share on other sites More sharing options...
jblaise Posted May 24, 2010 Share Posted May 24, 2010 hello, i have just add one extrafield "tva number" to test ... all is ok but i can't find the $?field to add in this CCA code contribution into creat_account.php (to send me an email confiramtion when new account is created ... tep_mail(STORE_OWNER, CCA_EMAIL_CONFIRM_1, 'Nouveau compte online', 'Un nouveau compte à été créée par :' . "\n\n" . $firstname . ' ' . $lastname . "\n\n" . 'Société & TVA : ' . $company . ' - ' . $extra_fields??? . "\n\n" . $street_address . ' - ' . $suburb . "\n\n" . $postcode . ' - ' . $city . ', ' . $country . "\n\n" . $email_address . "\n\n" . 'Telephone: ' . $telephone . "\n\n" . 'Password: ' . $password . "\n\n" . 'Adresse IP: ' . tep_get_ip_address() , STORE_OWNER, CCA_EMAIL_CONFIRM_1); thanks for help ... Quote Link to comment Share on other sites More sharing options...
lopi Posted June 9, 2010 Share Posted June 9, 2010 After creating a new account the 'account_success' page is displayed. Before installing the contribution, the "continue" button on 'account_success' linked either to "your account information" if the account wasn't created during the checkout process or to "checkout_shipping" if it was created when checking out the content of the cart. After installing the contribution, the "continue" button on 'account_success' always takes you back to the index page. Does anyone know a way to fix this? Sorry for this useless post. Although it happened after modifying "create_account.php" to add the extra fields, the extra fields contribution wasn't related to the problem on "account_success.php". Quote Link to comment Share on other sites More sharing options...
Fireflight Posted July 12, 2010 Share Posted July 12, 2010 I'm received the following whenever I try to create any new field types: 1366 - Incorrect integer value: 'on' for column 'fields_required_status' at row 1 insert into extra_fields (fields_status, fields_input_type, fields_input_value, fields_required_status, fields_size, fields_required_email) values ('1', '3', 'No', 'on', '', 'on') [TEP STOP] I search through the thread and didn't locate any solutions to this issue. Can anyone offer any suggestions? Quote Link to comment Share on other sites More sharing options...
Fireflight Posted July 12, 2010 Share Posted July 12, 2010 (edited) I'm received the following whenever I try to create any new field types: 1366 - Incorrect integer value: 'on' for column 'fields_required_status' at row 1 insert into extra_fields (fields_status, fields_input_type, fields_input_value, fields_required_status, fields_size, fields_required_email) values ('1', '3', 'No', 'on', '', 'on') [TEP STOP] I search through the thread and didn't locate any solutions to this issue. Can anyone offer any suggestions? Well that was quick, just fixed it myself. This helped provide the solution. Find the following in admin/extra_fields.php $sql_data_array = array('fields_status' => 1, 'fields_input_type' => $fields_input_type, 'fields_input_value' => $fields_input_value, 'fields_required_status' => $fields_required_status, 'fields_size' => $fields_size, 'fields_required_email' => (int)$fields_required_email); and change it to: $sql_data_array = array('fields_status' => (int)1, 'fields_input_type' => (int)$fields_input_type, 'fields_input_value' => $fields_input_value, 'fields_required_status' => (int)$fields_required_status, 'fields_size' => (int)$fields_size, 'fields_required_email' => (int)$fields_required_email); Not sure if I've broken anything in the process by adding (int) in front, but all my client needs is a basic checkbox, so everything seems fine. Edited July 12, 2010 by Fireflight Quote Link to comment Share on other sites More sharing options...
Tom172 Posted August 31, 2010 Share Posted August 31, 2010 (edited) Hi there. I´ve installed customer extra fields 1.3.1 and it´s running smoothly. thank you. I also have the order email add on with FCK editor installed and can´t get the extra fields show up in my order confirmation. I guess the extra fields should show up some how in the list of variables. But I have no Idea how to accomplish this. This section of the thread would not be of any help: http://www.oscommerce.com/forums/topic/179371-customers-extra-fields/page__st__100__p__982750entry982750 Anybody got an Idea? THX Tom in addition to the above: I also have the Extra Product Fields Contribution #6856 (v2.23) installed (it took me a while to get it separated from Extra Customer Fields. Same Problem: I can´t get the extra fields in the order editor. My thought was as the two add on are basically the same a good solution to the above problem would also give hints on how solve the problem with extra product fields. I am a user, not a coder => copy and paste is what I can do best :) Edited August 31, 2010 by Tom172 Quote Link to comment Share on other sites More sharing options...
stitchie Posted December 18, 2010 Share Posted December 18, 2010 Hello, Installed, step by step, but i don't see the fields into email. I put the extra field in de create_account I just want to customer can fill 1 extra field with 1 radio button menu in create account, not required, and these fields show in customer e-mail. In Extra Fields Manager, every field are checked with "Send Field In Emails", but not working. I see the fields, but what they complete not shown in e-mail. Anyone a solution? Quote Link to comment Share on other sites More sharing options...
kifot Posted January 26, 2011 Share Posted January 26, 2011 Is it usable with 2.3.1.? I change the files mentioned in the manual. Now I can see this option in the Administrator panel, can also add an extra field, but it did not appear in user interface. Tables are created and extra field there appear, problem is - how to show it in user interface? Quote Link to comment Share on other sites More sharing options...
moloch30 Posted February 11, 2011 Share Posted February 11, 2011 Great addon. Ive installed it and the field appears in the create account page, but it sort of ruins the rest of the page:have a look: http://mobilepartner.dk/create_account.php how can i change it so it look like the other fields? Am i missing something? Will it print the field info on the invoice? Thx in advance Quote Link to comment Share on other sites More sharing options...
JuanOnnet Posted October 1, 2011 Share Posted October 1, 2011 Well I have a problem, or 3 of them. But I guess they are depending each other. The first 2 problems occured when I installed this contrib. I couldn`t find in the file catalog/create_acount.php an therefore wasn�t able to add the line . And in the file catalog/account_edit.php I couldn�t find so i couldn�t enter this: . Adding the other lines were no problem, also in this 2 files. And I guess as a result of these 2 errors i can�t find anywhere in the admin panel of my shop anything to add customer fields. I hope anyone can help me! Thanks alot! I have the same problem, how to fix it? i made step 6 and 11 and it is not the problem. Quote Link to comment Share on other sites More sharing options...
mcollina Posted October 20, 2011 Share Posted October 20, 2011 Hi, everyone. I've installed this contribution on my oscommerce 2.3.1 and put some questions in the creat_account.php. Now When I'm trying to created a new account on my store I have this message: 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 '' at line 1 delete from customers_to_extra_fields where customers_id= [TEP STOP] I've tryed to install more the once e the problem continue there. What I need to do??? I love this contribution. Tks, Quote Link to comment Share on other sites More sharing options...
mcollina Posted October 21, 2011 Share Posted October 21, 2011 People! I discover what happened. the string delete from customers_to_extra_fields where customers_id= was in the middle of created_account.php. Now i fixed! Quote Link to comment Share on other sites More sharing options...
poorgirl_richgirl Posted December 7, 2011 Share Posted December 7, 2011 I've installed. On the file /admin/extra_fields.php I dont see options to disable certain fields on the registration form?? Where can I do this Quote Link to comment Share on other sites More sharing options...
Guest Posted December 22, 2011 Share Posted December 22, 2011 Has anyone worked with putting this contribution in version 2.3 and if thats too easy, how about getting it to work with One Page Checkout on version2.3? I am really wanting to have customer fill in 4 vital pieces of information at checkout. Thanks!! Nick Getzendanner Quote Link to comment Share on other sites More sharing options...
lucsangel Posted September 6, 2012 Share Posted September 6, 2012 Has anyone worked with putting this contribution in version 2.3 and if thats too easy, how about getting it to work with One Page Checkout on version2.3? I am really wanting to have customer fill in 4 vital pieces of information at checkout. Thanks!! Nick Getzendanner Contribution reworked for Oscommerce 2.3.1 with complete files to compare by Artful-Webdesign. Go to : http://addons.oscommerce.com/info/8549 Hope this helps others. Quote Link to comment Share on other sites More sharing options...
webnirman Posted September 7, 2012 Share Posted September 7, 2012 I am getting following SQL error. Can you please guide me. 1366 - Incorrect integer value: 'on' for column 'fields_input_type' at row 1 insert into extra_fields (fields_status, fields_input_type, fields_input_value, fields_required_status, fields_size, fields_required_email) values ('1', 'on', '', 'on', '', 'on') Quote Link to comment Share on other sites More sharing options...
anttimie Posted December 18, 2012 Share Posted December 18, 2012 (edited) Hey. thanks for wonderful add-on! :) Installed to 2.3.1 Everything working like it should, except when I place "test order". All the fields in the extra fields dissapear (also from admin) and don't show in reply-email. Any help? Edit: All data is at DB... Edit2: Err, seems after test order DB data goes to ZERO. Edited December 18, 2012 by anttimie Quote Link to comment Share on other sites More sharing options...
anttimie Posted December 19, 2012 Share Posted December 19, 2012 Hey. thanks for wonderful add-on! :) Installed to 2.3.1 Everything working like it should, except when I place "test order". All the fields in the extra fields dissapear (also from admin) and don't show in reply-email. Any help? Edit: All data is at DB... Edit2: Err, seems after test order DB data goes to ZERO. Haa found out finally.... had this at totally wrong place... at "checkout_shipping.php".. eh. No wonder. :blush: //START Customers Extra Field tep_db_query("delete from " . TABLE_CUSTOMERS_TO_EXTRA_FIELDS . " where customers_id=" . $customer_id); $extra_fields_query = tep_db_query("select ce.fields_id from " . TABLE_EXTRA_FIELDS . " ce where ce.fields_status=1 "); while($extra_fields = tep_db_fetch_array($extra_fields_query)){ $sql_data_array = array('customers_id' => $customer_id, 'fields_id' => $extra_fields['fields_id'], 'value' => $HTTP_POST_VARS['fields_' . $extra_fields['fields_id']]); tep_db_perform(TABLE_CUSTOMERS_TO_EXTRA_FIELDS, $sql_data_array); } //END Customers Extra Field Quote Link to comment Share on other sites More sharing options...
yourgoal Posted June 27, 2014 Share Posted June 27, 2014 Hi, I am unable to follow the step 15 where I am unable to locate the code "$messageStack->add('account_edit', $string_error); } }" In account_edit.php (catalog/account_edit.php) Please help... Quote Link to comment Share on other sites More sharing options...
yourgoal Posted June 27, 2014 Share Posted June 27, 2014 HI, Please help.... Quote Link to comment Share on other sites More sharing options...
yourgoal Posted June 28, 2014 Share Posted June 28, 2014 Dear all, Please help me with the issue as mentioned above as it is very necessary that I add some extra fields during registration. Quote Link to comment Share on other sites More sharing options...
29gk Posted July 21, 2014 Share Posted July 21, 2014 Look for the following code and proceed with the installation $messageStack->add('account_edit', ENTRY_TELEPHONE_NUMBER_ERROR); } Quote Link to comment Share on other sites More sharing options...
hashar Posted March 17, 2015 Share Posted March 17, 2015 Hi, I have read all 11 pages of the posts here and have seen the question asked several times but have not seen an answer. <?php echo tep_get_extra_fields($cInfo->customers_id,$languages_id)?> But that just displays the entry box, not the data. We need to display the results of the extra_fields i.e. display the data the customer entered into the extra_fields on our order page. Hi, if you are using 2.3.4v , you have to copy exactly the admin/customers.php file from addon into your shop instead of editing the code. am sure you will overcome this error. 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.