<?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";
