Zen-Cart-Bitcoin-Payment-Module/currency_updater.php at master · Devba/Zen-Cart-Bitcoin-Payment-Module · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
#!/usr/bin/php
<?php
/**
 *
 * Bitcoin Payment Module
 *
 * @package paymentMethod
 *
 *  Author: Adiow (https://github.com/adiow/Zen-Cart-Bitcoin-Payment-Module/)
 *  Moddified by:  MasterX1582 (https://github.com/MasterX1582/Zen-Cart-Bitcoin-Payment-Module/)
 *  Donations: 1JBKYhNvF1B8eLEcCUq3jw8wvrzDCPCGiB
 *
**/

#Script patched together from snippets of code I found on the web. Adrian Golser, Sept. 2012.
#Script moddified to add support for btc-e and updated mtgox api url. Davy Moedbeck (MasterX1582), July 20 2013.
#Enter defining data at beginning, make sure exchange api returns correct value and set up a cron-job to execute
#according to preferences.

define('BTCEXCHANGE', 'btce'); 	// Wich Exchange are we using?
				// For MtGox use code 'mtgox'.
				// For BTC-E use code 'btce'.


# Set this to the physical path of your installation.
# Make sure to include the trailing "/"
define('PATH_TO_STORE_ROOT','/home/user/zen/');


#Settings for rate calculation: (typical api-output: {"ticker":{"high":8.79,"low":8.40145,"avg":8.583123374,"vwap":8.56141034,"vol":2342,"last_all":8.679,"last_local":8.679,"last":8.679,"buy":8.59688,"sell":8.679}}
define('WHICH_VALUE','avg');

define('DEFAULT_SYMBOL','USD');

if (BTCEXCHANGE != 'btce'){ // For BTC-E we get the fee from the api so this is not needed.
	define('EXCHANGE_FEE','02'); // Exchange fee you add to your rate. Example: write 02 for 2%

	#API-Settings. Create from your mtgox-account.
	define('MTGOX_KEY','');
	define('MTGOX_SECRET','');
}

/////////////////////


// Get Zen Cart configuration data
require_once(PATH_TO_STORE_ROOT . 'includes/configure.php');
require_once(PATH_TO_STORE_ROOT . 'includes/database_tables.php');


//get ticker data from btce. Code is from bitcoin wiki. Output is 2d-array
function exchange_query($path, array $req = array()) {
  // API settings


	// generate a nonce as microtime, with as-string handling to avoid problems with 32bits systems
	$mt = explode(' ', microtime());
	$req['nonce'] = $mt[1].substr($mt[0], 2, 6);

	// generate the POST data string
	$post_data = http_build_query($req, '', '&');

	if (BTCEXCHANGE != 'btce'){
		// generate the extra headers
		$headers = array(
			'Rest-Key: '.MTGOX,
			'Rest-Sign: '.base64_encode(hash_hmac('sha512', $post_data, base64_decode(MTGOX_SECRET), true)),
		);
	}

	// our curl handle (initialize if required)
	static $ch = null;
	if (is_null($ch)) {
		$ch = curl_init();
		curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
		curl_setopt($ch, CURLOPT_USERAGENT, 'Mozilla/4.0 (compatible; MtGox PHP client; '.php_uname('s').'; PHP/'.phpversion().')');
	}

	if (BTCEXCHANGE == 'btce'){ curl_setopt($ch, CURLOPT_URL, 'https://btc-e.com/api/2/'.$path);}
	if (BTCEXCHANGE == 'mtgox'){ curl_setopt($ch, CURLOPT_URL, 'https://data.mtgox.com/api/'.$path);}
	curl_setopt($ch, CURLOPT_POSTFIELDS, $post_data);
	if (BTCEXCHANGE != 'btce'){curl_setopt($ch, CURLOPT_HTTPHEADER, $headers);}
	curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, FALSE);

	// run the query
	$res = curl_exec($ch);
	if ($res === false) throw new Exception('Could not get reply: '.curl_error($ch));
	$dec = json_decode($res, true);
	if (!$dec) throw new Exception('Invalid data received, please make sure connection is working and requested API exists');
	return $dec;
}


//bit of math
if (BTCEXCHANGE == 'mtgox'){
	define('EFEE','1.'.EXCHANGE_FEE); // No need to change this...
	$exchange_array = exchange_query('0/ticker.php?Currency='.DEFAULT_SYMBOL);
}elseif (BTCEXCHANGE == 'btce'){
	$feeurl = 'https://btc-e.com/api/2/btc_'.strtolower(DEFAULT_SYMBOL).'/fee';
	$json = file_get_contents($feeurl);
	$fee = json_decode($json);
	define('EFEE', '1.'.($fee->trade * 100));
	$exchange_array = exchange_query('btc_'.strtolower(DEFAULT_SYMBOL).'/ticker');
}
$newrate = (1 / (($exchange_array["ticker"][WHICH_VALUE]) * EFEE));

//uncomment for testing
//return (var_dump((float)($exchange_array["ticker"][WHICH_VALUE])));
//return (var_dump($newrate));


//Time to punch this into the database

$mysqli = new mysqli(DB_SERVER, DB_SERVER_USERNAME, DB_SERVER_PASSWORD, DB_DATABASE);
if ($mysqli->connect_errno) {
    echo "Failed to connect to MySQL: (" . $mysqli->connect_errno . ") " . $mysqli->connect_error;
}

$mysqli->select_db(DB_DATABASE) or die("Database not avalable");
$mysqli->query("update ".TABLE_CURRENCIES. " set value='$newrate', last_updated=now() where code='BTC'");
$mysqli->close();

?>