function load_states_from_file()
{
print "Loading states from file...";
ob_end_flush();
$d =& amDb();
$prefix = amConfig('db.mysql.prefix');
$sql = file_get_contents(ROOT_DIR . '/sql-states.sql');
$sql = str_replace('@DB_MYSQL_PREFIX@', $prefix, $sql);
$d->query($sql);
$c = $d->selectCell("SELECT COUNT(*) FROM ?_states");
print "[{$c}] imported OK<br />\n";
ob_end_flush();
}
$vars = get_input_vars();
$sql = $vars['sql'];
$h_sql = htmlentities($sql);
$t->display('admin/header.inc.html');
print <<<CUT
<center>
<h2>SQL Monitor</h2>
<hr>
<form method=post>
<textarea name="sql" cols="80" rows="5">{$h_sql}</textarea>
<br />
<input type=submit value="Go" style='width: 200px;'>
</form>
CUT;
if ($sql != '') {
$d =& amDb();
$res = $d->select($sql);
if (is_array($res)) {
if ($res == array()) {
print "Query returned 0 rows.";
} else {
$cols = array_keys($res[0]);
print "<table width=90% class=hedit><tr>";
foreach ($cols as $k) {
print "<th>" . htmlentities($k) . "</th>";
}
print "</tr><tr>";
foreach ($res as $r) {
foreach ($r as $v) {
print "<td>" . htmlentities($v) . "</td>";
}
function amDb_setLogger()
{
function amDb_logger($db, $sql)
{
$caller = $db->findLibraryCaller();
$tip = "at " . @$caller['file'] . ' line ' . @$caller['line'];
// ���⠥� ����� (����筮, Debug_HackerConsole ����)
echo "<xmp title=\"{$tip}\">";
print_r($sql);
echo "</xmp>";
}
$db =& amDb();
$db->setLogger('amDb_logger');
}
function smarty_function_lookup_state($params, &$smarty)
{
$d =& amDb();
return $d->selectCell("SELECT title FROM ?_states WHERE country=? and state=?", $params['country'], $params['key']);
}
function cc_core_rebill($plugin, $dat = '', $running_from_cron = true, $repeat_declined = false)
{
global $config, $db, $t;
if (!$config['use_cron'] && $running_from_cron) {
$db->log_error("{$plugin} rebill can be run only with external cron");
}
$amDb =& amDb();
if ($dat == '') {
$dat = date('Y-m-d');
}
$tomorrow = date('Y-m-d', strtotime($dat) + 3600 * 24);
$pl =& instantiate_plugin('payment', $plugin);
if (!method_exists($pl, 'cc_bill')) {
fatal_error("This plugin ({$plugin}) is not handled by cc_core!");
}
// check if another rebilling process is active
// last status_tm / added_tm in rebill_log is < 5 minutes ago
// to avoiding starting new process while a PHP rebill script runned
// less than 10 minutes ago is still running
if ($running_from_cron) {
if ($last_rebill_log_id = $amDb->selectCell("SELECT MAX(rebill_log_id) FROM ?_rebill_log")) {
$last_tm_diff = $amDb->selectCell("SELECT UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP(IFNULL(status_tm, added_tm)) \n\t\t\t\tFROM ?_rebill_log WHERE rebill_log_id=?", $last_rebill_log_id);
if ($last_tm_diff < 5 * 60) {
$db->log_error("[Notice] cc_core_rebill({$plugin}, {$dat}) skipped because previous rebilling process still working ({$last_tm_diff} seconds ago)");
return;
}
}
print ".\n";
// to avoid Apache's timeout
}
$payments = $db->get_expired_payments($dat, $dat, $plugin);
$renewed = array();
$log = "{$plugin} Rebill\n";
foreach ($payments as $p) {
if ($p['data']['CANCELLED']) {
continue;
}
$member_id = $p['member_id'];
$member = $db->get_user($member_id);
$product_id = $p['product_id'];
if ($renewed[$member_id][$product_id]++) {
continue;
}
$product =& get_product($product_id);
if (!$product->config['is_recurring']) {
continue;
}
if ($product->config['rebill_times'] && !cc_core_check_rebill_times($product->config['rebill_times'], $p)) {
continue;
}
// check if we've already tried to rebill the customer today
$check = $repeat_declined ? "SUM(status = 0)" : "MAX(status IS NOT NULL)";
if ($amDb->selectCell("SELECT {$check} FROM ?_rebill_log\n\t\t\tWHERE payment_id = ? AND payment_date = ? ", $p['payment_id'], $dat)) {
// retry on payment processor failure? todo, real tests needed
continue;
}
$vars = array('RENEWAL_ORIG' => "RENEWAL_ORIG: {$p['payment_id']}");
$pc =& new PriceCalculator();
$pc->setTax(get_member_tax($member_id));
$coupon_code = $p['data'][0]['COUPON_CODE'];
if ($config['use_coupons'] && $coupon_code != '') {
$coupon = $db->coupon_get($coupon_code, null, 1);
if ($coupon['coupon_id'] && $coupon['is_recurring']) {
$pc->setCouponDiscount($coupon['discount'], split(',', trim($coupon['product_id'])));
$vars['COUPON_CODE'] = $coupon_code;
}
}
$pc->addProduct($product_id);
$terms =& $pc->calculate();
$additional_values = array();
$additional_values['COUPON_DISCOUNT'] = $terms->discount;
$additional_values['TAX_AMOUNT'] = $terms->tax;
$payment_id = $db->add_waiting_payment($member_id, $product_id, $plugin, $terms->total, $dat, $product->get_expire($dat), $vars, $additional_values);
$rebill_log_id = $amDb->query("INSERT INTO ?_rebill_log \n\t\t(payment_id, added_tm, payment_date, amount, rebill_payment_id)\n\t\tVALUES\n\t\t(?d, ?, ?, ?f, ?d)", $p['payment_id'], date('Y-m-d H:i:s'), $dat, $terms->total, $payment_id);
$payment = $db->get_payment($payment_id);
$cc_info = $member['data'];
$cc_info['cc_number'] = amember_decrypt($cc_info['cc-hidden']);
$x = list($res, $err_msg, $receipt_id, $log) = $pl->cc_bill($cc_info, $member, $payment['amount'], $product->config[$payment['paysys_id'] . '_currency'], $product->config['title'], CC_CHARGE_TYPE_RECURRING, $payment['payment_id'], $payment);
foreach ($log as $v) {
$payment['data'][] = $v;
}
$db->update_payment($payment['payment_id'], $payment);
$amDb->query("UPDATE ?_rebill_log \n \tSET status = ?, status_tm = ?, status_msg = ? \n \tWHERE rebill_payment_id = ?d", $res, date('Y-m-d H:i:s'), $err_msg, $payment_id);
switch ($res) {
case CC_RESULT_SUCCESS:
$err = $db->finish_waiting_payment($payment['payment_id'], $payment['paysys_id'], $receipt_id, $payment['amount'], '', cc_core_get_payer_id($vars, $member));
if ($err) {
$db->log_error($err . ": payment_id = {$payment['payment_id']} (rebilling)");
}
if ($config['cc_rebill_success']) {
mail_rebill_success_member($member, $payment_id, $product);
}
break;
case CC_RESULT_INTERNAL_ERROR:
case CC_RESULT_DECLINE_TEMP:
if ($pl->config['reattempt'] != '') {
$new_expire = cc_core_prorate_subscription($p['payment_id'], $pl->config['reattempt'], $dat);
}
if ($config['cc_rebill_failed']) {
mail_rebill_failed_member($member, $payment_id, $product, "{$err_msg}", $new_expire);
}
if ($config['cc_rebill_failed_admin']) {
mail_rebill_failed_admin($member, $payment_id, $product, "{$err_msg}", $new_expire);
}
break;
case CC_RESULT_DECLINE_PERM:
if ($pl->config['reattempt'] != '') {
$new_expire = cc_core_prorate_subscription($p['payment_id'], $pl->config['reattempt'], $dat);
}
if ($config['cc_rebill_failed']) {
mail_rebill_failed_member($member, $payment_id, $product, "{$err_msg}", $new_expire);
}
if ($config['cc_rebill_failed_admin']) {
mail_rebill_failed_admin($member, $payment_id, $product, "{$err_msg}", $new_expire);
}
// clean_cc_info($member);
break;
case CC_RESULT_IGNORE:
break;
default:
$db->log_error("Unknown return from plugin_bill: {$res}");
}
}
}
function load_states_disabled($country)
{
$db =& amDb();
$response = '';
$states = @$db->selectCol("SELECT state as ARRAY_KEY, title\n FROM ?_states WHERE tag<0 AND country='{$country}' \t \n ORDER BY tag DESC, title");
foreach ($states as $state => $title) {
$response .= "<option value=\"{$state}\">{$title}</option>";
}
ajaxResponse(array('msg' => $response, 'errorCode' => 0));
}