changing email login to username

[acklikx]

Hi, i really need help changing the login page, so that instead of using the email address as the username, i can use a regular name or user defined name. Does anyone know how to do this? Ive tried switching the names of the php variables for $email to $firstname as a wild guess but didnt work. any help would be greatly appreciated. thanks

 

craig marlowe

[kgt]

Try this contribution:

 

http://www.oscommerce.com/community/contri...search,username

[acklikx]

Try this contribution:

 

http://www.oscommerce.com/community/contri...search,username

 

thanks kgt, that would definitely work, but do you know of one that i can install on an existing store? i have about 130 customers that i entered manually (im setting up a store for one company with many branches), and would really not want to have to add all of their information again. thanks.

[kgt]

I am not familiar with the contribution, so I'm not sure why you think you'd have to reenter any information. It looks like it's only adding a customer_username to the customers table. Even if it were a separate table, I can't imagine why you'd have to manually reenter anything. If you have a field, like first name, that you are currently using as the username, (or wish to use) then you only need to run one simple SQL statement to populate customer_username with the usernames you have already entered.

 

update customers set customers_username = customers_firstname