{ $query = "SELECT * FROM auction WHERE\n\t auction.auction_id IN( SELECT bid.auction_id FROM bid\n\t WHERE bid.bidder_id IN( SELECT bid.bidder_id FROM bid\n\t WHERE bid.bidder_id <> {$user_id} AND bid.auction_id IN(\n SELECT bid.auction_id FROM bid WHERE bid.bidder_id = {$user_id}\n GROUP BY bid.auction_id) GROUP BY bid.bidder_id ) GROUP BY\n\t bid.auction_id ) AND auction.has_ended = '0' LIMIT 10;"; $recommends = mysqli_query($dbconnection, $query); if ($recommends->num_rows == 0) { return ''; } $str_recommends = "You may be interested in:<br><br>"; while ($result = mysqli_fetch_array($recommends)) { $get_item_name_query = "SELECT name FROM item WHERE item_id = " . $result['item_id']; $get_item_name = mysqli_query($dbconnection, $get_item_name_query); $item_name = mysqli_fetch_array($get_item_name)['name']; $str_recommends .= 'Auction (<a href="http://ec2-52-58-25-40.eu-central-1.compute.amazonaws.com/auction.php?auction=' . $result['auction_id'] . '">' . $item_name . '</a>)<br> End Date: ' . $result['end_date'] . '<br> Current Price: ' . $result['current_price'] . '<br> <br>'; } return $str_recommends; } echo date("Y-m-d H:i:s") . " recommendation.php : \n"; $query = "SELECT user_id,email_address from user"; $users = mysqli_query($connection, $query); $sender = new email_sender(); $counter = 0; while ($user = mysqli_fetch_array($users)) { $str_recommends = recommend($connection, $user['user_id']); if ($str_recommends != '') { $counter++; $sender->send_with_log($user['email_address'], 'Recommended Items for You!!', $str_recommends); } } echo "{$counter} emails sent\n";
if ($counter != 0) { $sender = new email_sender(); } echo date("Y-m-d H:i:s") . " auction_handler.php : {$counter} auctions ended.\n"; while ($auction = mysqli_fetch_array($auctions)) { mysqli_query($connection, "update auction set has_ended='1' where auction_id=" . $auction['auction_id'] . ""); $query = "select b.price, u.user_id, u.name, u.email_address\n from bid as b\n left join user as u\n on b.bidder_id=u.user_id\n where b.auction_id=" . $auction['auction_id'] . "\n order by b.price desc\n limit 1"; $winner = mysqli_query($connection, $query); if ($winner = mysqli_fetch_array($winner)) { $winner_exists = true; } else { $winner_exists = false; } if ($winner_exists) { if ($winner['price'] < $auction['reserve_price']) { $sender->send_with_log($winner['email_address'], 'Your Bid Did Not Meet Reserve Price!!', 'Your bid was the highest in the auction for <a href="http://ec2-52-58-25-40.eu-central-1.compute.amazonaws.com/auction.php?auction=' . $auction['auction_id'] . '">' . $auction['item_name'] . '</a>, but we are sorry that you could not get the item as your bid did not meet the reserve price set by the seller.'); $sender->send_with_log($auction['seller_address'], 'Your Auction Ended But Below Reserve Price!!', 'Your auction for <a href="http://ec2-52-58-25-40.eu-central-1.compute.amazonaws.com/auction.php?auction=' . $auction['auction_id'] . '">' . $auction['item_name'] . '</a> just ended, but the highest bid on the auction did not meet the reserve price you set.'); } else { mysqli_query($connection, "update item set owner_id='" . $winner['user_id'] . "' where item_id='" . $auction['item_id'] . "'"); mysqli_query($connection, "insert into rating (user_id, rated_by, auction_id, created_at) values ('" . $auction['seller_id'] . "', '" . $winner['user_id'] . "', '" . $auction['auction_id'] . "', NULL)"); mysqli_query($connection, "insert into rating (user_id, rated_by, auction_id, created_at) values ('" . $winner['user_id'] . "', '" . $auction['seller_id'] . "', '" . $auction['auction_id'] . "', NULL)"); $sender->send_with_log($winner['email_address'], 'You Won an Auction!!', 'Congratulations!!<br> You won the auction for <a href="http://ec2-52-58-25-40.eu-central-1.compute.amazonaws.com/auction.php?auction=' . $auction['auction_id'] . '">' . $auction['item_name'] . '</a>!!<br> Now it is yours!!<br> <a href="http://ec2-52-58-25-40.eu-central-1.compute.amazonaws.com/">Go to the website</a> and rate the seller!!'); $sender->send_with_log($auction['seller_address'], 'Your Auction Ended With a Winner!!', 'Congratulations!!<br> Your auction <a href="http://ec2-52-58-25-40.eu-central-1.compute.amazonaws.com/auction=' . $auction['auction_id'] . '">' . $auction['item_name'] . '</a> just ended with a winner and now your item is sold!!<br> <a href="http://ec2-52-58-25-40.eu-central-1.compute.amazonaws.com/user.php?user='******'user_id'] . '">' . $winner['name'] . '</a> won the auction!!<br> <a href="http://ec2-52-58-25-40.eu-central-1.compute.amazonaws.com/">Go to the website</a> and rate the winner!!'); } } else {
<?php require_once realpath(dirname(__FILE__) . "/resources/dbconnection.php"); require_once realpath(dirname(__FILE__) . "/resources/email.php"); echo date("Y-m-d H:i:s") . " sellers_report.php : \n"; $query = "select user_id,email_address from user where user_type='seller'"; $sellers = mysqli_query($connection, $query); while ($seller = mysqli_fetch_array($sellers)) { $message = ''; $query = "select a.end_date, a.current_price, a.reserve_price, a.auction_id, a.view_count, i.name\n from auction as a\n left join item as i\n on a.item_id = i.item_id\n where a.seller_id = '" . $seller['user_id'] . "' and a.end_date > now()"; $auctions = mysqli_query($connection, $query); while ($auction = mysqli_fetch_array($auctions)) { $query = "select * from bid where auction_id='" . $auction['auction_id'] . "'"; $bids = mysqli_query($connection, $query); $bid_count = mysqli_num_rows($bids); $message .= 'Auction (<a href="http://ec2-52-58-25-40.eu-central-1.compute.amazonaws.com/auction.php?auction=' . $auction['auction_id'] . '">' . $auction['name'] . '</a>)<br> End Date: ' . $auction['end_date'] . '<br> Current Price: ' . $auction['current_price'] . '<br> Reserve Price: ' . $auction['reserve_price'] . '<br> Bid Count: ' . $bid_count . ' bid(s)<br> View Count: ' . $auction['view_count'] . ' view(s)<br> <br>'; } if ($message != '') { $sender = new email_sender(); $sender->send_with_log($seller['email_address'], 'Your Current Auction Report!!', $message); } }