<?php $login = '******'; error_reporting(E_ERROR); require_once realpath(dirname(__FILE__) . '/../') . '/classes/stdf.php'; require_once realpath(dirname(__FILE__) . '/../') . '/classes/account.php'; require_once realpath(dirname(__FILE__) . '/../') . '/classes/session.php'; require_once realpath(dirname(__FILE__) . '/../') . '/classes/payed.php'; require_once realpath(dirname(__FILE__) . '/../') . '/classes/users.php'; $ses = new session(); $user = $DB->row("\n SELECT uid, login\n FROM users\n WHERE login='******';\n "); $payed = new payed(); $sess = new session(); $transaction_id = account::start_transaction($user['uid']); $payed->AdminAddPRO($user['uid'], $transaction_id, '2 days'); $sess->UpdateProEndingDate($user['login']); echo date('H:m:s') . " - {$login}\n\n";
<?php require_once '../classes/stdf.php'; require_once '../classes/account.php'; require_once '../classes/session.php'; require_once '../classes/payed.php'; $users = $DB->rows("\n SELECT uid, login, EXTRACT(epoch FROM to_date)/86400 as days \n FROM orders \n INNER JOIN employer e ON e.uid = orders.from_id\n WHERE tarif = 76;\n "); echo "Execute recovery PRO accounts for " . count($users) . " users.\n"; $payed = new payed(); $sess = new session(); foreach ($users as $user) { $transaction_id = account::start_transaction($user['uid']); $payed->AdminAddPRO($user['uid'], $transaction_id, $user['days'] / 7 * 17 . ' days'); $session->UpdateProEndingDate($user['login']); }
AND NOT EXISTS ( SELECT 1 FROM orders WHERE from_id = o.from_id AND ( (from_date <= '2013-10-18 00:00:00') AND (from_date + to_date >= '2013-10-17 00:00:00') ) ) "); echo "Execute recovery PRO accounts for " . count($users) . " users.\n"; foreach ($users as $user) { $transaction_id = account::start_transaction($user['from_id']); $payed->AdminAddPRO($user['from_id'], $transaction_id, '2 days'); $session->UpdateProEndingDate($user['login']); } */ $users = $DB->rows("\n SELECT\n DISTINCT from_id, login\n FROM\n orders o\n INNER JOIN\n users ON o.from_id = users.uid\n WHERE\n (from_date <= '2013-10-25 00:00:00') AND (from_date + to_date >= '2013-10-24 00:00:00')\n AND EXISTS ( SELECT 1 FROM orders WHERE from_id = o.from_id AND ( (from_date <= '2013-10-18 00:00:00') AND (from_date + to_date >= '2013-10-17 00:00:00') ) )\n"); echo 'Execute recovery PRO accounts for ' . count($users) . " users.\n"; foreach ($users as $user) { $transaction_id = account::start_transaction($user['from_id']); $payed->AdminAddPRO($user['from_id'], $transaction_id, '1 days'); $session->UpdateProEndingDate($user['login']); } /* $users = $DB->rows(" SELECT DISTINCT user_id, profession FROM users_first_page x WHERE (from_date <= '2013-10-25 00:00:00') AND (from_date + to_date >= '2013-10-24 00:00:00') AND NOT EXISTS ( SELECT 1 FROM users_first_page WHERE user_id = x.user_id AND ( (from_date <= '2013-10-18 00:00:00') AND (from_date + to_date >= '2013-10-17 00:00:00') ) ) "); echo "Execute recovery pay places for " . count($users) . " users.\n"; $fp = new firstpage; foreach ($users as $user) {
case "addserv": $login = __paramInit('string', NULL, 'login'); $days = __paramInit('string', NULL, 'days'); $type = __paramInit('int', NULL, 'type'); $where = __paramInit('int', NULL, 'where'); $fid = users::GetUid($err, $login); if ($fid && $login) { if (preg_match('#^[1-9]+[\\d]*$#', $days)) { require_once ABS_PATH . '/classes/account.php'; $nDays = intval($days); $trsn_id = account::start_transaction($fid); switch ($type) { case 1: require_once ABS_PATH . '/classes/payed.php'; $pro = new payed(); $pro->AdminAddPRO($fid, $trsn_id, $nDays . ' days'); break; } header('Location: /siteadmin/rating/?result=success'); } else { $sError = 'ќшибка, ол-во дней должно быть целым числом.'; } } else { $sError = 'ќшибка, пользователь не найден.'; } break; } $prfs = new professions(); $profs = $prfs->GetAllProfessions("", 0, 0); $css_file = array('moderation.css', 'nav.css'); $content = "../content.php";