Файл: wenr.online/app/user/sell_all.php
Строк: 5
<?php
if (!$user->isAuth()) {
redirect('/');
exit;
}
$sell = $db->prepare('select SUM(`bonus`) as gold from `bag` where `type` = ? and `user` = ?');
$sell -> execute(['drop',$user->get()->user_id]);
$sell = $sell -> fetch(PDO :: FETCH_OBJ);
if(empty($sell->gold)){
Notif :: error('Нет предметов для продажи','/bag/cat?id=7');
exit;
}
$usup = $db->prepare('update `users` set `gold` = ? where `user_id` = ?');
$usup -> execute([$user->get()->gold+$sell->gold,$user->get()->user_id]);
$del = $db->prepare('delete from `bag` where `user` = ? and `type` = ?');
$del -> execute([$user->get()->user_id,'drop']);
Notif :: message('Вы продали вещи за '.$sell->gold.' <img src="/public/assets/images/zoloto.png">','/bag/cat?id=7');
exit;