Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <? error_reporting(0);
- //данные о хосте, пользователе и базе данных
- $host = 'localhost';
- $user = 'linkslin_muhann';
- $pass = 'Electronik21011987';
- $dbname = 'linkslin_muhann';
- // подключаемся и выбираем бд, которую указали выше
- if(!mysql_connect($host,$user,$pass))die('No connect to MySql!');elseif(!mysql_select_db($dbname)) die('No DB!');
- $conf=mysql_fetch_array(mysql_query("SELECT prefix FROM lnks_conf"));
- $re1=mysql_query("select * FROM ".$conf[prefix]."myBuys where sDateOver>=".time()." && sDateStart<=".time()." && ( sDateLastPayment<=".(time()-(60*60*24))." || sDateLastPayment='')");
- while($r1=mysql_fetch_array($re1))
- {
- //Витрина
- $userCase=mysql_fetch_array(mysql_query("SELECT * FROM ".$conf[prefix]."userCase WHERE id='".$r1[idUserCase]."' && status='1' && ban!='1'"));
- //Исполнитель
- $performer=mysql_fetch_array(mysql_query("SELECT * FROM ".$conf[prefix]."users WHERE id='".$r1[idUser]."'"));
- //Считаю дни
- $days_all = number_format(($r1[sDateOver]- $r1[sDateStart]) /86400); //Всего дней
- $days_remains = number_format( ($r1[sDateOver]- time()) /86400); //Осталось дней
- $sumForDay = number_format($r1[sum]/$days_all, 3, '.', ''); //Сумма за день
- $amount_remains = number_format($sumForDay*$days_remains, 3, '.', ''); //Оставшиеся деньги
- if($r1[sDateOver]>=$r1[sDateStart]){
- //Если касса вмомент проверки не рабочая,отдаем оставшиеся деньги исполнителю
- if(empty($userCase[id])){
- mysql_query("UPDATE ".$conf[prefix]."users SET balans_hold=balans_hold-".$amount_remains.", balans=balans+".$amount_remains." WHERE id='".(int)$r1[idUser]."' limit 1");
- mysql_query("delete from ".$conf[prefix]."myBuys WHERE id=".$r1[id]."");
- echo"Заказ ID: $r1[id] - Вернул ".$amount_remains." руб. (Статус витрины не определен)...<br>";
- }else{
- if($r1[orderStatus]!='1'){mysql_query("UPDATE ".$conf[prefix]."systemStatistics SET successful_transactions=successful_transactions+1 WHERE id=1 limit 1");}
- mysql_query("UPDATE ".$conf[prefix]."myBuys SET orderStatus='1', sDateLastPayment='".time()."' WHERE id='".(int)$r1[id]."' limit 1");
- mysql_query("UPDATE ".$conf[prefix]."users SET balans_hold=balans_hold-".$sumForDay." WHERE id='".(int)$r1[idUser]."' limit 1");
- mysql_query("UPDATE ".$conf[prefix]."users SET balans=balans+".$sumForDay." WHERE id='".(int)$userCase[idUser]."' limit 1");
- $sql = 'INSERT INTO '.$conf[prefix].'statisticsOfUserSales(date, idUser, sum, idMyBuy, idUserCase, type)
- VALUES("'.time().'", "'.$userCase[idUser].'", "'.$sumForDay.'", "'.$r1[id].'", "'.$userCase[id].'", "'.$userCase[type].'")';
- if(mysql_query($sql)){ echo"Заказ ID: $r1[id] средства за сегодня списаны у заказчика ID: $r1[idUser] для исполнителя ID: $userCase[idUser] - в размере: $sumForDay руб.!<br>";}
- }
- }
- }
- //Добавляю раб. день
- mysql_query("UPDATE ".$conf[prefix]."systemStatistics SET updDate = '".time()."', work_days=work_days+1 WHERE id='1' && ( updDate<=".(time()-(60*60*24))." || updDate='') limit 1");
- mysql_close();exit();?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement