[vQmod] Add new field to Registration Form,Frontend&Backend

New version for Opencart 1.5.X attached to the first post.

Let me know if you find errors or anything that can be done to improve it.

Marvin M.

Thanks again Marvman.

This guy was cool enough to take the time to update the xml out of his own time to help me finish a project I am working on! You are the man!

Hi i uploaded this to vqmod/xml was that correct?
if so how do i add some questions etc as i can't find it on my admin panel anywhere sorry

error

admin_controller_sale_customer.php on line 357Notice: Undefined index: expert_id in /home/users/.../vqmod/vqcache/vq-admin_controller_sale_customer.php

ckonig wrote:Thank you!
I totally forgot to mod the system/library files to add a get Method, thats a nice one! As said, i did almost the same work before, and I merged your contribution with mine. This way, I also got rid of your problem concerning the empty field in the frontend.
But I have a question about your query manipulation. Wouldn't it be better to only add the field to the begin of the query, ignoring what comes after, so i can copy & paste the script as often as I want to?
For example with the UPDATE query:

Code: Select all

<operation>
		<search position="replace"><![CDATA[$this->db->query("UPDATE " . DB_PREFIX . "customer SET firstname = '" . $this->db->escape($data['firstname']) . "',]]></search>
		<add trim="true"><![CDATA[$this->db->query("UPDATE " . DB_PREFIX . "customer SET expert_id = '" . $this->db->escape($data['expert_id']) . "', firstname = '" . $this->db->escape($data['firstname']) . "',]]></add>
	</operation>

In my opinion this can only work one time, if I want to use two instances of this mod, I need to change it to:

Code: Select all

<operation>
		<search position="replace"><![CDATA[$this->db->query("UPDATE " . DB_PREFIX . "customer SET ]]></search>
		<add trim="true"><![CDATA[$this->db->query("UPDATE " . DB_PREFIX . "customer SET expert_id = '" . $this->db->escape($data['expert_id']) . "', ]]></add>
	</operation>

This way I can use this script more than one and I dont have to mind what other scripts are doing with the query.

I also added the extra field into the backend views (list and detail view). If you're interested, here's my version (actually my field is called "expert_id"). I hope this helps.

smitch6 wrote:Hi i uploaded this to vqmod/xml was that correct?
if so how do i add some questions etc as i can't find it on my admin panel anywhere sorry

what exactly do you want to do? The vqmod in my first post will add a new field called "cedula" to the registration form, cust edit, and to admin cust edit. You just need to substitute that for you custom field. Remember you also need to add the field to the database.

SVN wrote:error

admin_controller_sale_customer.php on line 357Notice: Undefined index: expert_id in /home/users/.../vqmod/vqcache/vq-admin_controller_sale_customer.php

ckonig wrote:Thank you!
I totally forgot to mod the system/library files to add a get Method, thats a nice one! As said, i did almost the same work before, and I merged your contribution with mine. This way, I also got rid of your problem concerning the empty field in the frontend.
But I have a question about your query manipulation. Wouldn't it be better to only add the field to the begin of the query, ignoring what comes after, so i can copy & paste the script as often as I want to?
For example with the UPDATE query:

Code: Select all

<operation>
		<search position="replace"><![CDATA[$this->db->query("UPDATE " . DB_PREFIX . "customer SET firstname = '" . $this->db->escape($data['firstname']) . "',]]></search>
		<add trim="true"><![CDATA[$this->db->query("UPDATE " . DB_PREFIX . "customer SET expert_id = '" . $this->db->escape($data['expert_id']) . "', firstname = '" . $this->db->escape($data['firstname']) . "',]]></add>
	</operation>

In my opinion this can only work one time, if I want to use two instances of this mod, I need to change it to:

Code: Select all

<operation>
		<search position="replace"><![CDATA[$this->db->query("UPDATE " . DB_PREFIX . "customer SET ]]></search>
		<add trim="true"><![CDATA[$this->db->query("UPDATE " . DB_PREFIX . "customer SET expert_id = '" . $this->db->escape($data['expert_id']) . "', ]]></add>
	</operation>

This way I can use this script more than one and I dont have to mind what other scripts are doing with the query.

I also added the extra field into the backend views (list and detail view). If you're interested, here's my version (actually my field is called "expert_id"). I hope this helps.

Youre talking about the vqmod attached by ckonig?

Yep, sorry, forgot to mention.
I was talking about the Expert ID.

OC 1.4.9.6

marvmen21 wrote:

SVN wrote:error

admin_controller_sale_customer.php on line 357Notice: Undefined index: expert_id in /home/users/.../vqmod/vqcache/vq-admin_controller_sale_customer.php

ckonig wrote:Thank you!
I totally forgot to mod the system/library files to add a get Method, thats a nice one! As said, i did almost the same work before, and I merged your contribution with mine. This way, I also got rid of your problem concerning the empty field in the frontend.
But I have a question about your query manipulation. Wouldn't it be better to only add the field to the begin of the query, ignoring what comes after, so i can copy & paste the script as often as I want to?
For example with the UPDATE query:

Code: Select all

<operation>
		<search position="replace"><![CDATA[$this->db->query("UPDATE " . DB_PREFIX . "customer SET firstname = '" . $this->db->escape($data['firstname']) . "',]]></search>
		<add trim="true"><![CDATA[$this->db->query("UPDATE " . DB_PREFIX . "customer SET expert_id = '" . $this->db->escape($data['expert_id']) . "', firstname = '" . $this->db->escape($data['firstname']) . "',]]></add>
	</operation>

In my opinion this can only work one time, if I want to use two instances of this mod, I need to change it to:

Code: Select all

<operation>
		<search position="replace"><![CDATA[$this->db->query("UPDATE " . DB_PREFIX . "customer SET ]]></search>
		<add trim="true"><![CDATA[$this->db->query("UPDATE " . DB_PREFIX . "customer SET expert_id = '" . $this->db->escape($data['expert_id']) . "', ]]></add>
	</operation>

This way I can use this script more than one and I dont have to mind what other scripts are doing with the query.

I also added the extra field into the backend views (list and detail view). If you're interested, here's my version (actually my field is called "expert_id"). I hope this helps.

Youre talking about the vqmod attached by ckonig?

you forgot to add the new field in the checkout registration??!?

victor.gatto wrote:you forgot to add the new field in the checkout registration??!?

You're right! Thanks. Right now I don't have time to update it, I'll work on it as soon as I get some time free. I'll add it to the checkout registration and also the guest check out.

marvmen21 wrote:

victor.gatto wrote:you forgot to add the new field in the checkout registration??!?[/uquote]
You're right! Thanks. Right now I don't have time to update it, I'll work on it as soon as I get some time free. I'll add it to the checkout registration and also the guest check out.

thanks heaps

It was not working properly in the backend with the recently released version (oc 1.5.1.3) since there were two small changes in the controller file. New version New_Field_Registration_Form_1.0.3.xml attached to the first post.

what would a sample sql statement be to update a 1.5.1.3 db?

thanks

Hi, it depends on the field you want to add, but generally it would be.. You could also add it manually.

New Version attached to first post. New_Field_Registration_Form_1.0.4.xml for OC 1.5.1.3

As victor.gatto notticed, I had forgotten the checkout/registration form...

victor.gatto wrote:you forgot to add the new field in the checkout registration??!?

So this is the updated version to include the "new field" to the checkout/registration form. Some might say it's also important to include the "new field" to the guest/registration form, and I first tried (you can see the commented parts in the xml file), but then decided not to since you're not going to be able to get that information because the cust is not creating any account. The only way would be to get the order_info form to show it in your backend which would take another bunch of files to modify. Anyways, It depends on the field and the information you're collecting from it, In my case, I just need it for people who actually create the account.

hey marv, thanks for the updates!

New_Field_Registration_Form_1.1.xml

This new version now adds the "new field" to the affiliate/register & edit and to the backend. This is actually the vqmod I am using in my store, and that's why it adds the field called "cedula" at the beginning, just before "Name". You can change the position as you need.

I just spotted one error, check below and update your file. (this error is only in the last version posted) Instead of customer_query, it should be affiliate_query.

EDIT No need to correct that, I've updated the file.

Hello,

Noob alerte! Sorry, but I am having difficulties to understand the correct way to implement new fields.
I think I installed without any problems Vqmod, also the last New_Field_Registration_Form_1.1.xml form.

But how can I add a new field? I read that comment "<!--Copy and paste the code to add new fields, rememeber to add them to the database, too -->", so what does it really say? to copy all the code between <modification> or just a part of the code?

Also in the database, where do I insert the new field name?

Sorry I am very confused.

Hope you can help me.
Thanks.

hello! this extension is able for version 1.4.9.1???

Hi newpt, it's not that difficult once you understand the structure. You can read about that here http://forum.opencart.com/viewtopic.php?f=29&t=2648
The first thing you need to know is what kind of fields and where you want to add them. Knowing that will tell you what table in the database you need to add it and which files to modify.

In the case of this vqmod, this adds a new required field called "cedula" ( ID) just before "Name" in all registration pages except in the guest checkout. The mod is "plug and play" so by putting it in the xml folder, it will make all the modifications required. You can go to account/create in your website and see the field that was added. You may get errors since you also need that field in the database. To do that, you can use the following query to alter the customer table in the database After that, you should have no problems. If you are adding just one field, you could use this vqmod almost as it is. Just change the language parts to change the name of the field, and if you want to change the positions, just change the code it is searching in the .tpl files.
Now,if you want to add more than one field, let's say... a new field called "abc" just before "fax" , You will need to modify the code between the search tag to look for the position and add the field exactly where you want it, and add or copy paste code in all the operations you find in the vqmod. Basically, to add a new field you need to add code to all these files:Template files, controller files, mode files, and language files, and some files in the system/library.
This would the example on how to add abc to the template file.