provided by Star2Billing S.L.

CURRENCY TABLE is automaticaly updated through the webservice oanda.com.
For more information please visite the website http://www.oanda.com.

the currency table is not updated automatically.

the exchange rates are simply wrong.

did not find any part in source which should do update ....

even when i would like the yahoo script





Joined: 12 Mar 2006
Posts: 193
Location: Barcelona

PostPosted: Tue Mar 28, 2006 11:20 pm Post subject: Reply with quote
Yeah this is the true Very Happy
There is a script you can run to update the currency table from the yahoo
financial, best would be to put that on a cront like once a day :

A2Billing_AGI/libs_a2billing/crontjob/currencies_update_yahoo.php



how should i call this script?

this script is located at

/var/lib/asterisk/agi-bin/libs_a2billing/crontjob/currencies_update_yahoo.php

and to this directory i can't point with my browser.


how to update currencies now?

Hi Chief ... how to updates currency now?

Hello,

Run from shell


alternative create a cron job.

Aha ....

condor:~ # php5 /var/lib/asterisk/agi-bin/libs_a2billing/crontjob/currencies_update_yahoo.php
PHP Notice: Undefined index: debugshell in /var/lib/asterisk/agi-bin/libs_a2billing/Class.A2Billing.php on line 402
PHP Notice: Undefined variable: idconfig in /var/lib/asterisk/agi-bin/libs_a2billing/crontjob/currencies_update_yahoo.php on line 19
PHP Notice: Undefined index: debugshell in /var/lib/asterisk/agi-bin/libs_a2billing/Class.A2Billing.php on line 402
--20:15:48-- http://finance.yahoo.com/d/quotes.csv?s ... ZWD=X&f=l1
=> `/tmp/currencies.cvs'
Resolving finance.yahoo.com... 206.190.56.229
Connecting to finance.yahoo.com|206.190.56.229|:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: unspecified [application/octet-stream]

[ <=> ] 1,161 --.--K/s

20:15:50 (52.72 MB/s) - `/tmp/currencies.cvs' saved [1161]

PHP Notice: Undefined offset: 149 in /var/lib/asterisk/agi-bin/libs_a2billing/crontjob/currencies_update_yahoo.php on line 74
PHP Fatal error: Call to undefined method ADORecordSet_empty::numRows() in /var/lib/asterisk/agi-bin/libs_a2billing/db_php_lib/Class.Table.php on line 48

hello,


i have solution for
PHP Fatal error: Call to undefined method ADORecordSet_empty::numRows() in /var/lib/asterisk/agi-bin/libs_a2billing/db_php_lib/Class.Table.php on line 48


edit Class.Table.php (line 48 )
// $num = $res -> numRows();
$num=149;

Hi,

I believe that the correct way to solve this problem is to change:

$num = $res -> numRows();

to instead be:

$num = $res -> RecordCount();

If you set $num to a specific value it will return this value each time and therefore break other functions such as incoming DID forwarding etc.