X-Cart forums - Multi currency modul

X-Cart forums (https://forum.x-cart.com/index.php)

- Dev Questions (https://forum.x-cart.com/forumdisplay.php?f=20)

- - Multi currency modul (https://forum.x-cart.com/showthread.php?t=38421)

Re: Multi currency modul

Hi guys

This mod is exactly what I need. I'm using 4.1.9. (my signature says 4.1.10, but the site I'm currently working on is 4.1.9)
Does it work on this version?

Your signature is a bit disconcerting Virtual! LOL:

Quote:

Check what you can do with x-cart 4.1.9:

I have limited knowledge of PHP so would need assistance fixing any bugs.

Much appreciated :D/

Re: Multi currency modul

Quote:

Originally Posted by Waynarky

Hi guys

This mod is exactly what I need. I'm using 4.1.9. (my signature says 4.1.10, but the site I'm currently working on is 4.1.9)
Does it work on this version?

I think it should work with it. I can help you with it if it won't work.

Re: Multi currency modul

Many Thanks!! I'll implement it and let you know either way.

Re: Multi currency modul

Hi Virtual

I've implemented the module and its working great. Thank you very much!
The instructions were clear and simple :)

I do want to ask about one small issue though. When I change currency it goes back to the home page, instead of refreshing the product page. I see that on your www.smee.hr site, that's not the case. Can you help?

Re: Multi currency modul

Yep - I would also like to know how to keep the user on the current page after a currency change - thanks

Re: Multi currency modul

Quote:

Originally Posted by virtual@croatia

If you are willing to search for it, there is a file x-currency.sql in folder sql which has to be corrected. If you won't be able to fix it, I'll do it for you when I come home (2 weeks).

Regards,
virtual

Hi there

I tried to fix it myself but i didn't have any success. I always get the same sql error. I also have to admit that my sql-knowledge isn't very good either :mrgreen:.

Is there anything else i should try?

thanks for your time

Aqua

Re: Multi currency modul

Okay, i figured that one out, just add an empty string at the end of row 1 and it will install but the menu-point "currencies" won't appear in the backend and i get this if i try to reinstall the module

Code:

Copying skin files ...



Creating directory: [skin1/modules/Multi_Currency] ... [OK]

Copying to file skin1/modules/Multi_Currency/menu_currency.tpl - [OK]

Copying to file skin1/modules/Multi_Currency/currencies.tpl - [OK]

[OK]



Activating the module ...



Please wait ...

[OK]



Please wait ...

Creating table: [xcart_currency_rate] ... [OK]

Creating table: [xcart_customer_currency] ... [OK]

[OK]



Please wait ...

[FAILED] Duplicate entry 'US-lbl_default_currency' for key 1

Re: Multi currency modul

Quote:

Originally Posted by AquaClic

Code:

Copying skin files ...



Creating directory: [skin1/modules/Multi_Currency] ... [OK]

Copying to file skin1/modules/Multi_Currency/menu_currency.tpl - [OK]

Copying to file skin1/modules/Multi_Currency/currencies.tpl - [OK]

[OK]



Activating the module ...



Please wait ...

[OK]



Please wait ...

Creating table: [xcart_currency_rate] ... [OK]

Creating table: [xcart_customer_currency] ... [OK]

[OK]



Please wait ...

[FAILED] Duplicate entry 'US-lbl_default_currency' for key 1

I hope we can get this module working for 4.1.10. Is the author around anymore?

Re: Multi currency modul

Okay, i figured this one out

It actually was an empty string missing in the x-currency.sql in the sql folder. I didn't try this because Virtual stated in a post before that it didn't work.

BEWARE
I'm posting this only to find out what the problem is. The problem is following and i'm still working on it, maybe someone can help me out:

I installed the module and it's working correctly on 4.1.10 but i get the error 2 posts above if i try to reinstall/uninstall the module.

I don't know what will happen with other 4.1.10 installations and i'm not sure if it is good for anyone to install it this way untill we've found a proper solution(!).

This is how my x-currency.sql in the sql folder looks like:

Code:

INSERT INTO xcart_config VALUES ('default_currency', 'Select default currency', 'EUR', 'Multi_Currency', 10, 'text', 'EUR','','');



INSERT INTO xcart_modules (module_name, module_descr, active) VALUES ('Multi_Currency','This module adds a multi currency support.','Y');



CREATE TABLE xcart_currency_rate (

    code CHAR( 3 ) NOT NULL DEFAULT '',

    rate DECIMAL( 12, 5 ) NOT NULL DEFAULT '1.00000',

    active CHAR( 1 ) NOT NULL DEFAULT 'N',

    order_by INT( 11 ) NOT NULL DEFAULT '0',

    PRIMARY KEY  (code)

) TYPE=MyISAM;



INSERT INTO xcart_currency_rate (code) SELECT code FROM xcart_currencies;



UPDATE xcart_currency_rate SET active = 'Y' WHERE code = (SELECT value FROM xcart_config WHERE name = 'currency_symbol') OR code = (SELECT xcart_currencies.code FROM xcart_currencies INNER JOIN xcart_config ON xcart_currencies.symbol = xcart_config.value AND xcart_config.name = 'currency_symbol');



CREATE TABLE xcart_customer_currency (

    login VARCHAR ( 32 ) NOT NULL DEFAULT '',

    currency CHAR( 3 ) NOT NULL DEFAULT '',

    PRIMARY KEY  (login)

) TYPE=MyISAM;

I only added an empty string in the first line.

If you want to try it for yourself then please backup everything you can and don't chop off my head if something goes wrong, i never told that this is a nice solution, it' merely an unfinished fix :D

Re: Multi currency modul

Can anyone help get this mod working? I am willing to pay for this.