OpenCart Currency Updater v0.1 by HM2K

Code: Select all

<?php

//OpenCart Currency Updater v0.1 by HM2K

//If you find this useful please donate to paypal@hm2k.org

// Configuration
require('config.php');

// Locator
include(DIR_LIBRARY . 'locator.php');
$locator =& new Locator();

// Config
$config =& $locator->get('config');

// Database
$database =& $locator->get('database');

// Settings
$settings = $database->getRows("select * from setting where type = 'catalog' or type = 'global'");

foreach ($settings as $setting) {
	$config->set($setting['key'], $setting['value']);
}

// Request
$request =& $locator->get('request');

//Rest Of Code

$default=$config->get('config_currency');

echo "Default code is $default<br>\n";

$sql = "select currency_id, title, code, value, date_modified from currency";
$sql .= " order by title asc";

$results = $database->getRows($sql);

foreach ($results as $result) {
	$id=$result['currency_id'];
	$code=$result['code'];
	$value=$result['value'];
	$new=ucc(1,$default,$code);
	echo "$code = $value => $new <br>\n";
	$sql = "update currency set value = '?', date_modified = now() where currency_id = '?'";
	$database->query($database->parse($sql, $new, $id));
}

function ucc ($amount,$from,$to) {
	$url='http://www.xe.com/ucc/convert.cgi?Amount=%s&From=%s&To=%s';
	$url=sprintf($url,$amount,$from,$to);
	ini_set('user_agent','Mozilla/5.0 (Windows; U; Windows NT 5.1; en-GB; rv:1.7.12) Gecko/20050919 Firefox/1.0');
	$c=file_get_contents($url);
	$c=strip_tags($c);
	preg_match("/1 $from = (.+?) $to/s",$c,$matches);
	return $matches[1];
}

?>

Code: Select all

<?php
/*
	Another OpenCart Currency Updater v0.1, by Ogun.
	Derived from 'OpenCart Currency Updater v0.1 by HM2Kv'
	If you find this useful please donate to paypal@hm2k.org
*/

// Reinvent wheel
function array_sample($array,$key) {
	$result = array();
	foreach($array as $sample) {
		if(isset($sample[$key])) $result[] = $sample[$key];
	}
	return $result;
}
function array_remove(&$array,$key) {
	$result = $array[$key];
	unset($array[$key]);
	return $result;
}

// Locator
$locator =& new Locator();

// Database
$database =& $locator->get('database');

/*
	OC uses a reserved word for a column name, so put it in backticks.
	TODO: Check the other tables and have a look at database.php.
*/
// Default currency
$default = $database->getRow("
	SELECT value
	FROM setting
	WHERE `key` = 'config_currency'
");
$default = $default['value'];

$codes = $database->getRows("
	SELECT code, value
	FROM currency
	ORDER BY title ASC
");
$codes = array_sample($codes,'code');

// Grab the XML feed from the ECB. Not worth XML'ing, just explode.
$tmp = file_get_contents("http://www.ecb.europa.eu/stats/eurofxref/eurofxref-daily.xml");
$tmp = explode('<Cube currency=',$tmp);
unset($tmp[0]);

// The ECB file is in euros, so they won't be in the list.
$rates = array('EUR' => 1);
// Only include the rate if it's in the list of required currency codes.
foreach($tmp as $rate) {
	$rate = explode("'",$rate);
	if(in_array($rate[1],$codes)) $rates[$rate[1]] = $rate[3];
}

/*
	What does OC do for errors/exceptions?
*/

// Bomb out if the default currency isn't in the ECB'd list.
if(!in_array($default,array_keys($rates))) die("ERROR: No data for $default.");
// Remove the default currency from the ECB'd list (Assuming it'll always be 1).
else $default_value = array_remove($rates,$default);

// If euros aren't the default currency, we'll need to convert them (and everything else).
if($default != 'EUR') {
	foreach($rates as $key => $value) $rates[$key] = 1/$default_value * $value;
	$rates['EUR'] = 1/$default_value;
}

// Update the database
foreach($rates as $key => $value) {
	$database->query("
		UPDATE currency
		SET value = $value, date_modified = NOW()
		WHERE code = '$key'
	");
}

echo '<pre>' . count($rates) . ' record(s) updated.<br />';
print_r($rates);
echo '</pre>';

?>

Code: Select all

$query,
         $correct,
         $m_host = "www.website.com/content.xml";

     function file_get_contents($url)
      {
      $out = "GET /$url HTTP/1.1\r\n";
      $out .= "Host: {$this->m_host}\r\n";
      $out .= "User-Agent: Mozilla 4.0\r\n";
      $out .= "Connection: close\r\n\r\n";

    $h = fsockopen($this->m_host,80);
    fwrite($h,$out);
    for($a = 0,$r = '';!$a;)
    {
       $b = fread($h,8192);
       $r .= $b;
       $a = (($b=='') ? 1 : 0);
    }
    fclose($h);
    return $r;
  }

$xmldata = $this->file_get_contents($this->m_url);