Currency Update (Automatic)

[charals]

I am using the download automated_currency_update_v3_1.

So far I have had no error messages. But am waiting for the currencies to change. I will give it a few days to see how it goes.

I will check with my hosting service if there are any successful confirmation emails with their CRON feature. I would rather not have any as to not fill up me email inbox.

I appreciate your help very much.

Charals

[zahid]

Hi All!

I want to set currency updation for my client, now i put my currency_update.php in directory. /var/www/dev01/shzaikhn/surarean/internationalgalleryexposure.com/cartfm/pub
and i give path like this.
DEFINE('PATH_TO_STORE_ROOT','pub/currency_update.php');
now my qustion is that, how i will call corn, how mail i will recieve , i dont know if these are working or not, if error are remove.
i just calling that currency_update.php file like.
and please told me, what is the process of its working, means how calling are done.

team-kh.awpdc.com/~shzaikhn/surarean/internationalgalleryexposure.com/cartfm/pub/currency_update.php

but it give me error like,

Warning: require_once(includes/configure.php) [function.require-once]: failed to open stream: No such file or directory in /var/www/dev01/shzaikhn/surarean/internationalgalleryexposure.com/cartfm/pub/currency_update.php on line 20

Fatal error: require_once() [function.require]: Failed opening required 'includes/configure.php' (include_path='.:/usr/share/pear:/usr/share/php') in /var/www/dev01/shzaikhn/surarean/internationalgalleryexposure.com/cartfm/pub/currency_update.php on line 20

please help me, i am very confused what i do for this.


Any help would be realy appreciate,

[danielson]

Can anyone point me towards an example of this module actually working on a live Zen Cart site? I went through 5 pages of this long thread but didn't see a real example.

Thanks :)

[kuroi]

I run it on any site operating with more than one currency, but there's nothing to see. It's all hidden away behind the scenes.

If your point is that the thread contains posts primarily with people having problems, well that's the nature of a support thread. People who install and run it without problem don't really have any reason to post here.

[danielson]

Thanks kuroi

Is there an option to change currency? e.g. if price is displayed by default in £, can the user change it to $?

[kuroi]

This mod only updates currencies, it doesn't touch prices which are converted to the appropriate currency by Zen Cart core code.

[Schtoo]

Hi,

Got a question for those folks who might understand what's going on with the currency update addon I have that just stopped working...

The cronjob I had running the update automatically today returned a timeout error, and doing the same thing manually gets the same time out. I am using the EU site for updates.

The error I get is this...

Warning: file(http://www. e c b.europa.eu/stats/eurofxref/eurofxref-daily.xml) [function.file]: failed to open stream: Connection timed out in /home/mysite/public_html/currency_update.php on line 37

Warning: Invalid argument supplied for foreach() in /home/mysite/public_html/currency_update.php on line 40


The .php file on the site has not changed (when compared to a known good file) , and it looks like the EU site is there and working and the mod has been working just fine for the past few months.

Any ideas why it's stopped working just now?


(And I just ran it again now, it's working again! I guess this means it's something that generally isn't noticed? Something not to worry about?)

Thanks, and I hope some good comes of this, even if what I had happening was nothing...

[wurdup]

to anyone having problems with the root directory install I had problems with this until I removed the . at the start of the directory address.


$location = '/home/[username]/public_html/'; // location of zen-cart intall


seemed to work fine after that.

[wurdup]

Ok I'll post my setup to help people having problems. (Using justhost.com)


using standard cron through cpanel:

php -q /home/[username]/public_html/catalog/currency_update.php


php -q tells the cron to use the php intrepter or the cron will just try to run each line in the php file itself.


the php file has:

$location = '/home/[username]/public_html/catalog/'; // location of zen-cart intall


Although yours may not have the catalog folder. Make sure you include the '/' at the end and in this case I had to delete the '.' at the start.

The file persmission needs to be 644 although some cron jobs need 755? i think.

With this currency_update.php script I added an email function that tells you when the script has been run. I had concerns that a user can run the script to update currencies when rates suddenly drop in a certain currency and therefore purchasing the product for cheaper than you intended. Ok it's unlikely but never say never.
Anyway this addition emails you when its run and also the new rates. This also provides you with a backup of currency rates if you need to change them back.



add this:

 require_once($location.'includes/configure.php');
 require_once($location.'includes/database_tables.php');
 // no need to edit below this line
 // !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!


$newrates=''; // add this here

now add the $newrates code to the orignal and also the email function so it looks like:

    $newrates = $newrates."\n".$currency['code']." ".$rate;
	
    if ($rate) {mysql_db_query(DB_DATABASE, "update " . TABLE_CURRENCIES . " set value = '" . $rate . "', last_updated = now() where currencies_id = '" . $currency['currencies_id']. "'", $link);}
   }
 }

 mysql_close($link);
 //end lookup

$to = "[email protected]";
$subject = "Currency Update";
$thedate = getdate();
$thedate = $thedate['hours'].":".$thedate['minutes'].".".$thedate['seconds']." ".$thedate['mday']."/".$thedate['mon']."/".$thedate['year'];
$body = "mywebsite.com\n\ncurrency_update.php script has been run on ".$thedate."\nRate: ".$newrates;
if (mail($to, $subject, $body)) {
  echo("<p>Message successfully sent!</p>");
 } else {
  echo("<p>Message delivery failed...</p>");
}

dont forget to change the email address.


Not sure if that will help you or not but it's helped me.

[Pazaz]

I have tried both versions and get similar results, the latest "currency_update_curled.php: Permission denied"
I have asked my host if they can fix it and basically they say no. Only if I set up my own php.ini and I really dont have the guts for all that.

QUOTE The issue here is that, for security reasons, we have remote url access through fuctions like file disabled. UNQUOTE

Are there any other options (apart from moving host) ???

rgds
Mick