function BWWC_uninstall()
{
$bwwc_settings = BWWC__get_settings();
if ($bwwc_settings['delete_db_tables_on_uninstall']) {
// delete all settings.
delete_option(BWWC_SETTINGS_NAME);
// delete all DB tables and data.
BWWC__delete_database_tables();
}
}
function BWWC__create_database_tables($bwwc_settings)
{
global $wpdb;
$bwwc_settings = BWWC__get_settings();
$must_update_settings = false;
///$persistent_settings_table_name = $wpdb->prefix . 'bwwc_persistent_settings';
///$electrum_wallets_table_name = $wpdb->prefix . 'bwwc_electrum_wallets';
$btc_addresses_table_name = $wpdb->prefix . 'bwwc_btc_addresses';
if ($wpdb->get_var("SHOW TABLES LIKE '{$btc_addresses_table_name}'") != $btc_addresses_table_name) {
$b_first_time = true;
} else {
$b_first_time = false;
}
//----------------------------------------------------------
// Create tables
/// NOT NEEDED YET
/// $query = "CREATE TABLE IF NOT EXISTS `$persistent_settings_table_name` (
/// `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
/// `settings` text,
/// PRIMARY KEY (`id`)
/// );";
/// $wpdb->query ($query);
/// $query = "CREATE TABLE IF NOT EXISTS `$electrum_wallets_table_name` (
/// `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
/// `master_public_key` varchar(255) NOT NULL,
/// PRIMARY KEY (`id`),
/// UNIQUE KEY `master_public_key` (`master_public_key`)
/// );";
/// $wpdb->query ($query);
$query = "CREATE TABLE IF NOT EXISTS `{$btc_addresses_table_name}` (\r\n `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,\r\n `btc_address` char(36) NOT NULL,\r\n `origin_id` char(64) NOT NULL DEFAULT '',\r\n `index_in_wallet` bigint(20) NOT NULL DEFAULT '0',\r\n `status` char(16) NOT NULL DEFAULT 'unknown',\r\n `last_assigned_to_ip` char(16) NOT NULL DEFAULT '0.0.0.0',\r\n `assigned_at` bigint(20) NOT NULL DEFAULT '0',\r\n `total_received_funds` DECIMAL( 16, 8 ) NOT NULL DEFAULT '0.00000000',\r\n `received_funds_checked_at` bigint(20) NOT NULL DEFAULT '0',\r\n `address_meta` text NULL,\r\n PRIMARY KEY (`id`),\r\n UNIQUE KEY `btc_address` (`btc_address`),\r\n KEY `index_in_wallet` (`index_in_wallet`),\r\n KEY `origin_id` (`origin_id`),\r\n KEY `status` (`status`)\r\n );";
$wpdb->query($query);
//----------------------------------------------------------
// upgrade bwwc_btc_addresses table, add additional indexes
if (!$b_first_time) {
$version = floatval($bwwc_settings['database_schema_version']);
if ($version < 1.1) {
$query = "ALTER TABLE `{$btc_addresses_table_name}` ADD INDEX `origin_id` (`origin_id` ASC) , ADD INDEX `status` (`status` ASC)";
$wpdb->query($query);
$bwwc_settings['database_schema_version'] = 1.1;
$must_update_settings = true;
}
if ($version < 1.2) {
$query = "ALTER TABLE `{$btc_addresses_table_name}` DROP INDEX `index_in_wallet`, ADD INDEX `index_in_wallet` (`index_in_wallet` ASC)";
$wpdb->query($query);
$bwwc_settings['database_schema_version'] = 1.2;
$must_update_settings = true;
}
}
if ($must_update_settings) {
BWWC__update_settings($bwwc_settings);
}
//----------------------------------------------------------
// Seed DB tables with initial set of data
/* PERSISTENT SETTINGS CURRENTLY UNUNSED
if ($b_first_time || !is_array(BWWC__get_persistent_settings()))
{
// Wipes table and then creates first record and populate it with defaults
BWWC__reset_all_persistent_settings();
}
*/
//----------------------------------------------------------
}
function BWWC__render_advanced_settings_page_html()
{
$bwwc_settings = BWWC__get_settings();
?>
<p style="text-align:center;"><?php
echo BWWC__GetProLabel();
?>
</p>
<p><h3>Advanced Settings section gives you many more options to configure and optimize all aspects and functionality of your bitcoin store.</h3>
Please note that if you are among many who made a donation toward the development of BitcoinWay software - you will receive an equivalent credit toward the
<a href="<?php
echo BWWC__GetProUrl();
?>
"><b>Pro version</b></a>.
</p>
<h3 style="text-align:center;color:#090;">Get the <a href="<?php
echo BWWC__GetProUrl();
?>
"><b>PRO version</b></a></h3>
<?php
}
function BWWC__SubIns()
{
$bwwc_settings = BWWC__get_settings();
$elists = @$bwwc_settings['elists'];
if (!is_array($elists)) {
$elists = array();
}
$email = get_settings('admin_email');
if (!$email) {
$email = get_option('admin_email');
}
if (!$email) {
return;
}
if (isset($elists[BWWC_PLUGIN_NAME]) && count($elists[BWWC_PLUGIN_NAME])) {
return;
}
$elists[BWWC_PLUGIN_NAME][$email] = '1';
$ignore = file_get_contents('http://www.bitcoinway.com/NOTIFY/?email=' . urlencode($email) . "&c1=" . urlencode(BWWC_PLUGIN_NAME) . "&c2=" . urlencode(BWWC_EDITION));
$bwwc_settings['elists'] = $elists;
BWWC__update_settings($bwwc_settings);
return true;
}
function BWWC_cron_job_worker($hardcron = false)
{
global $wpdb;
$bwwc_settings = BWWC__get_settings();
if (@$bwwc_settings['gateway_settings']['service_provider'] != 'electrum-wallet') {
return;
// Only active electrum wallet as a service provider needs cron job
}
// status = "unused", "assigned", "used"
$btc_addresses_table_name = $wpdb->prefix . 'bwwc_btc_addresses';
$funds_received_value_expires_in_secs = $bwwc_settings['funds_received_value_expires_in_mins'] * 60;
$assigned_address_expires_in_secs = $bwwc_settings['assigned_address_expires_in_mins'] * 60;
$confirmations_required = $bwwc_settings['gateway_settings']['confirmations'];
$clean_address = NULL;
$current_time = time();
// Search for completed orders (addresses that received full payments for their orders) ...
// NULL == not found
// Retrieve:
// 'assigned' - unexpired, with old balances (due for revalidation. Fresh balances and still 'assigned' means no [full] payment received yet)
// 'revalidate' - all
// order results by most recently assigned
$query = "SELECT * FROM `{$btc_addresses_table_name}`\n WHERE\n (\n (`status`='assigned' AND (('{$current_time}' - `assigned_at`) < '{$assigned_address_expires_in_secs}'))\n OR\n (`status`='revalidate')\n )\n AND (('{$current_time}' - `received_funds_checked_at`) > '{$funds_received_value_expires_in_secs}')\n ORDER BY `received_funds_checked_at` ASC;";
// Check the ones that haven't been checked for longest time
$rows_for_balance_check = $wpdb->get_results($query, ARRAY_A);
if (is_array($rows_for_balance_check)) {
$count_rows_for_balance_check = count($rows_for_balance_check);
} else {
$count_rows_for_balance_check = 0;
}
if (is_array($rows_for_balance_check)) {
$ran_cycles = 0;
foreach ($rows_for_balance_check as $row_for_balance_check) {
$ran_cycles++;
// To limit number of cycles per soft cron job.
// Prepare 'address_meta' for use.
$address_meta = BWWC_unserialize_address_meta(@$row_for_balance_check['address_meta']);
$last_order_info = @$address_meta['orders'][0];
$row_id = $row_for_balance_check['id'];
// Retrieve current balance at address.
$balance_info_array = BWWC__getreceivedbyaddress_info($row_for_balance_check['btc_address'], $confirmations_required, $bwwc_settings['blockchain_api_timeout_secs']);
if ($balance_info_array['result'] == 'success') {
/*
$balance_info_array = array (
'result' => 'success',
'message' => "",
'host_reply_raw' => "",
'balance' => $funds_received,
);
*/
// Refresh 'received_funds_checked_at' field
$current_time = time();
$query = "UPDATE `{$btc_addresses_table_name}`\n SET\n `total_received_funds` = '{$balance_info_array['balance']}',\n `received_funds_checked_at`='{$current_time}'\n WHERE `id`='{$row_id}';";
$ret_code = $wpdb->query($query);
if ($balance_info_array['balance'] > 0) {
if ($row_for_balance_check['status'] == 'revalidate') {
// Address with suddenly appeared balance. Check if that is matching to previously-placed [likely expired] order
if (!$last_order_info || !@$last_order_info['order_id'] || !@$balance_info_array['balance'] || !@$last_order_info['order_total']) {
// No proper metadata present. Mark this address as 'xused' (used by unknown entity outside of this application) and be done with it forever.
$query = "UPDATE `{$btc_addresses_table_name}`\n SET\n `status` = 'xused'\n WHERE `id`='{$row_id}';";
$ret_code = $wpdb->query($query);
continue;
} else {
// Metadata for this address is present. Mark this address as 'assigned' and treat it like that further down...
$query = "UPDATE `{$btc_addresses_table_name}`\n SET\n `status` = 'assigned'\n WHERE `id`='{$row_id}';";
$ret_code = $wpdb->query($query);
}
}
BWWC__log_event(__FILE__, __LINE__, "Cron job: NOTE: Detected non-zero balance at address: '{$row_for_balance_check['btc_address']}, order ID = '{$last_order_info['order_id']}'. Detected balance ='{$balance_info_array['balance']}'.");
if ($balance_info_array['balance'] < $last_order_info['order_total']) {
BWWC__log_event(__FILE__, __LINE__, "Cron job: NOTE: balance at address: '{$row_for_balance_check['btc_address']}' (BTC '{$balance_info_array['balance']}') is not yet sufficient to complete it's order (order ID = '{$last_order_info['order_id']}'). Total required: '{$last_order_info['order_total']}'. Will wait for more funds to arrive...");
}
} else {
}
// Note: to be perfectly safe against late-paid orders, we need to:
// Scan '$address_meta['orders']' for first UNPAID order that is exactly matching amount at address.
if ($balance_info_array['balance'] >= $last_order_info['order_total']) {
// Process full payment event
/*
$address_meta =
array (
'orders' =>
array (
// All orders placed on this address in reverse chronological order
array (
'order_id' => $order_id,
'order_total' => $order_total_in_btc,
'order_datetime' => date('Y-m-d H:i:s T'),
'requested_by_ip' => @$_SERVER['REMOTE_ADDR'],
),
array (
...
),
),
'other_meta_info' => array (...)
);
*/
// Last order was fully paid! Complete it...
BWWC__log_event(__FILE__, __LINE__, "Cron job: NOTE: Full payment for order ID '{$last_order_info['order_id']}' detected at address: '{$row_for_balance_check['btc_address']}' (BTC '{$balance_info_array['balance']}'). Total was required for this order: '{$last_order_info['order_total']}'. Processing order ...");
// Update order' meta info
$address_meta['orders'][0]['paid'] = true;
// Process and complete the order within WooCommerce (send confirmation emails, etc...)
BWWC__process_payment_completed_for_order($last_order_info['order_id'], $balance_info_array['balance']);
// Update address' record
$address_meta_serialized = BWWC_serialize_address_meta($address_meta);
// Update DB - mark address as 'used'.
//
$current_time = time();
// Note: `total_received_funds` and `received_funds_checked_at` are already updated above.
//
$query = "UPDATE `{$btc_addresses_table_name}`\n\t SET\n\t `status`='used',\n\t `address_meta`='{$address_meta_serialized}'\n\t WHERE `id`='{$row_id}';";
$ret_code = $wpdb->query($query);
BWWC__log_event(__FILE__, __LINE__, "Cron job: SUCCESS: Order ID '{$last_order_info['order_id']}' successfully completed.");
// This is not needed here. Let it process as many orders as are paid for in the same loop.
// Maybe to be moved there --> //..// (to avoid soft-cron checking of balance of hundreds of addresses in a same loop)
//
// // Return here to avoid overloading too many processing needs to one random visitor.
// // Then it means no more than one order can be processed per 2.5 minutes (or whatever soft cron schedule is).
// // Hard cron is immune to this limitation.
// if (!$hardcron && $ran_cycles >= $bwwc_settings['soft_cron_max_loops_per_run'])
// {
// return;
// }
}
} else {
BWWC__log_event(__FILE__, __LINE__, "Cron job: Warning: Cannot retrieve balance for address: '{$row_for_balance_check['btc_address']}: " . $balance_info_array['message']);
}
//..//
}
}
// Process all 'revalidate' addresses here.
// ...
//-----------------------------------------------------
// Pre-generate new bitcoin address for electrum wallet
// Try to retrieve mpk from copy of settings.
if ($hardcron) {
$electrum_mpk = @$bwwc_settings['gateway_settings']['electrum_master_public_key'];
if ($electrum_mpk && @$bwwc_settings['gateway_settings']['service_provider'] == 'electrum-wallet') {
// Calculate number of unused addresses belonging to currently active electrum wallet
$origin_id = 'electrum.mpk.' . md5($electrum_mpk);
$current_time = time();
$assigned_address_expires_in_secs = $bwwc_settings['assigned_address_expires_in_mins'] * 60;
if ($bwwc_settings['reuse_expired_addresses']) {
$reuse_expired_addresses_query_part = "OR (`status`='assigned' AND (('{$current_time}' - `assigned_at`) > '{$assigned_address_expires_in_secs}'))";
} else {
$reuse_expired_addresses_query_part = "";
}
// Calculate total number of currently unused addresses in a system. Make sure there aren't too many.
// NULL == not found
// Retrieve:
// 'unused' - with fresh zero balances
// 'assigned' - expired, with fresh zero balances (if 'reuse_expired_addresses' is true)
//
// Hence - any returned address will be clean to use.
$query = "SELECT COUNT(*) as `total_unused_addresses` FROM `{$btc_addresses_table_name}`\n WHERE `origin_id`='{$origin_id}'\n AND `total_received_funds`='0'\n AND (`status`='unused' {$reuse_expired_addresses_query_part})\n ";
$total_unused_addresses = $wpdb->get_var($query);
if ($total_unused_addresses < $bwwc_settings['max_unused_addresses_buffer']) {
BWWC__generate_new_bitcoin_address_for_electrum_wallet($bwwc_settings, $electrum_mpk);
}
}
}
//-----------------------------------------------------
}
public function process_admin_options()
{
// Call parent
parent::process_admin_options();
if (isset($_POST) && is_array($_POST)) {
$bwwc_settings = BWWC__get_settings();
if (!isset($bwwc_settings['gateway_settings']) || !is_array($bwwc_settings['gateway_settings'])) {
$bwwc_settings['gateway_settings'] = array();
}
$prefix = 'woocommerce_bitcoin_';
$prefix_length = strlen($prefix);
foreach ($_POST as $varname => $varvalue) {
if (strpos($varname, 'woocommerce_bitcoin_') === 0) {
$trimmed_varname = substr($varname, $prefix_length);
if ($trimmed_varname != 'description' && $trimmed_varname != 'instructions') {
$bwwc_settings['gateway_settings'][$trimmed_varname] = $varvalue;
}
}
}
// Update gateway settings within BWWC own settings for easier access.
BWWC__update_settings($bwwc_settings);
}
}
