X-Cart: shopping cart software

X-Cart forums (https://forum.x-cart.com/index.php)
-   Third Party Add-Ons for X-Cart 4 (https://forum.x-cart.com/forumdisplay.php?f=45)
-   -   Anonymous to registered customer conversion (https://forum.x-cart.com/showthread.php?t=66713)

BCSE 08-13-2013 11:28 AM

Re: Anonymous to registered customer conversion
 
Quote:

Originally Posted by quietcoolone
i don't store or wish to store customer credit card numbers and if that is the only major difference, then DPM will do. If i got this wrong please point me in the right direction.

BTW, The patch and installation was easy however i can't get the Free module to appears in general setting/modules nor the "create user" button in order details page. I have cleared templates etc but still no love


thanks.


DPM is what you need then.


For the patch, did you run cleanup.php to make sure X-cart clears it's internal cache? Also make sure the SQL patch applied. I'm not seeing it listed in your list of modules. It should be safe to run the sql patch again if you aren't sure.

Thanks,

Carrie

BCSE 08-13-2013 11:47 AM

Re: Anonymous to registered customer conversion
 
OK I see the module now in your modules area, have you enabled it? It looks disabled.
Quote:

3rd party modules
Enabled
XPDF
Disabled
BCSE_Unanonymizer


Once you do, you can go to an order that is an anonymous order and you should see that new button. If the order is not anonymous it won't show up.

Let us know!

Thanks,

Carrie

quietcoolone 08-13-2013 11:56 AM

Re: Anonymous to registered customer conversion
 
Quote:

Originally Posted by BCSE
OK I see the module now in your modules area, have you enabled it? It looks disabled.


Once you do, you can go to an order that is an anonymous order and you should see that new button. If the order is not anonymous it won't show up.

Let us know!

Thanks,

Carrie


Carrie,
success-- works like a charm!!
btw, how do you know what module i have installed? :)

BCSE 08-13-2013 12:01 PM

Re: Anonymous to registered customer conversion
 
Quote:

Originally Posted by quietcoolone
Carrie,
success-- works like a charm!!
btw, how do you know what module i have installed? :)



Um.... Many years of knowing X-cart (10+). :) If you want to email us I can show you. You should probably block a certain file, but really if someone wanted to figure out if you had X-cart or not it wouldn't be that hard. There's a file that lists the modules installed.

Carrie

BCSE 08-13-2013 12:03 PM

Re: Anonymous to registered customer conversion
 
Oh, and glad it's working great! Feel free to post a review on it on our site if you'd like, so others know.

Thanks,

Carrie

Dougrun 08-13-2013 12:56 PM

Re: Anonymous to registered customer conversion
 
FYI, that mod to order_history.php, the line is at the top of my 4.6 file, not the bottom as the install states.

same with the other file.

BCSE 08-14-2013 10:29 AM

Re: Anonymous to registered customer conversion
 
Quote:

Originally Posted by Dougrun
FYI, that mod to order_history.php, the line is at the top of my 4.6 file, not the bottom as the install states.

same with the other file.


Yes you're right, it should say towards the top of the file.

Thanks!

Carrie

quietcoolone 08-31-2013 02:14 PM

Re: Anonymous to registered customer conversion
 
I discovered today that this add-on does not work in xcart 4.4.5 if the customer has a "special character" in their names.
For example:
i tried to create a user who's last name is O'Shaughnessy. Xcart would display an error message and shortly after i received the following email:

SQL query : INSERT INTO xcart_customers (`login`, `username`, `password`, `change_password_date`, `usertype`, `change_password`, `activity`, `status`, `language`, `membershipid`, `cart`, `referer`, `last_login`, `first_login`, `firstname`, `lastname`, `email`) VALUES ('***@hotmail.com', '***@hotmail.com', 'B-70c2b68cb973733118d286d5c678d5a6', '1377986143', 'C', 'Y', 'Y', 'Y', 'en', '0', '', '', '1377986143', '1377986143', 'John Doe', 'O'Shaughnessy', '***@hotmail.com')
Error code : 1064
Description : 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 'Shaughnessy', '***@hotmail.com')' at line 1
Request URI: /admin/order.php?orderid=300214&mode=bcse_create_user


Removing the special character allowed the user to be created

BCSE 09-03-2013 10:48 AM

Re: Anonymous to registered customer conversion
 
Thanks for the info on that! We'll update the mod and let you guys know when it's ready. Sounds like X-cart's fun_array2insert doesn't 'addslashes' and we need to clean the data before using that function.

Carrie

cherie 09-03-2013 12:28 PM

Re: Anonymous to registered customer conversion
 
This is how 4.6 does it in func_change_user_password if that helps:
PHP Code:

...
        
func_array2insert(
            
'old_passwords',
            array(
                
'userid'    => $xuserid,
                
'password'  => addslashes($_old_password),
            ),
            
true
        
); 



All times are GMT -8. The time now is 11:48 PM.

Powered by vBulletin Version 3.5.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.