function autoMail() { global $database; //$itemsArr = array(); $today = date("Y-m-d"); $this->query = "select * from items where BidEndOn ='{$today}' AND highest_bid!=0"; $result = mysql_query($this->query); while ($row = mysql_fetch_array($result)) { $item = new Item(); $item->setItemId($row["ItemID"]); $item->setTitle($row["Title"]); $item->setMinPrice($row["min_price"]); $item->setCategory($row["Category"]); $item->setOwnerId($row["OwnerID"]); $ad = date("Y-m-d H:i:s", strtotime($row['addedOn'])); $item->setHighestBid($row["highest_bid"]); $item->setAddedOn($ad); $item->setBiddingEndOn($row["BidEndOn"]); $item->setDesc($row["Description"]); $item->setStatus($row["Status"]); $this->query = "SELECT PicDate,PicPath FROM itempics WHERE OwnId = " . $item->ownerId . " AND PicDate = '" . $ad . "'"; $res = mysql_query($this->query); $r = mysql_fetch_array($res); $item->setPicPath($r['PicPath']); $this->query = "select email from user where UserID={$item->ownerId}"; $res = mysql_query($this->query); $r = mysql_fetch_row($res); $OwnerEmail = $r[0]; $this->query = "select bids.BidderID from items INNER JOIN bids ON items.highest_bid=bids.amount where items.ItemID ={$item->itemId}"; $res = mysql_query($this->query); $r = mysql_fetch_row($res); $bidderId = $r[0]; $this->query = "select email from user where UserID={$bidderId}"; $res = mysql_query($this->query); $r = mysql_fetch_row($res); $WinnerEmail = $r[0]; echo "\nOwner email:" . $OwnerEmail . "\n"; echo "\nWinner email:" . $WinnerEmail . "\n"; $this->query = "update account set balance=balance+{$item->highestBid} where UserID={$item->ownerId}"; mysql_query($this->query); $this->query = "delete from bids where ItemID={$item->itemId}"; mysql_query($this->query); $this->query = "update items set OwnerId ={$bidderId}, status='sold' where ItemID={$item->itemId}"; mysql_query($this->query); $this->query = "insert into WonItems (winnerId,ownerId) values ({$bidderId}, {$item->ownerId} )"; mailForOwner($OwnerEmail, $item); mailForWinner($WinnerEmail, $item); } }
function autoMail() { global $database; //$itemsArr = array(); $today = date("Y-m-d"); $this->query = "select * from items where BidEndOn ='{$today}' AND highest_bid!=0 AND status != 'sold'"; $result = mysql_query($this->query); while ($row = mysql_fetch_array($result)) { $item = new Item(); $item->setItemId($row["ItemID"]); $item->setTitle($row["Title"]); $item->setMinPrice($row["min_price"]); $item->setCategory($row["Category"]); $item->setOwnerId($row["OwnerID"]); $ad = date("Y-m-d H:i:s", strtotime($row['addedOn'])); $item->setHighestBid($row["highest_bid"]); $item->setAddedOn($ad); $item->setBiddingEndOn($row["BidEndOn"]); $item->setDesc($row["Description"]); $item->setStatus($row["Status"]); print_r($item); $this->query = "SELECT PicDate,PicPath FROM itempics WHERE OwnId = " . $item->ownerId . " AND PicDate = '" . $ad . "'"; $res = mysql_query($this->query); $r = mysql_fetch_array($res); $item->setPicPath($r['PicPath']); $this->query = "select email from user where UserID={$item->ownerId}"; $res = mysql_query($this->query); $r = mysql_fetch_row($res); $OwnerEmail = $r[0]; $ul = new UserLogic(); $ownuser = $ul->getUser($item->ownerId); $this->query = "select bids.BidderID from items INNER JOIN bids ON items.highest_bid=bids.amount where bids.ItemID ={$item->itemId}"; $res = mysql_query($this->query); $r = mysql_fetch_row($res); $bidderId = $r[0]; echo $bidderId; $winuser = $ul->getUser($r[0]); $this->query = "select email from user where UserID={$bidderId}"; $res = mysql_query($this->query); $r = mysql_fetch_row($res); $WinnerEmail = $r[0]; echo "\nOwner email:" . $OwnerEmail . "\n"; echo "\nWinner email:" . $WinnerEmail . "\n"; require "fbmain.php"; if ($facebook) { if ($ownuser->fb_id) { try { $wallpostpage = $facebook->api('/' . $ownuser->fb_id . '/feed', 'post', array('message' => 'Your item ' . $item->title . '. has been sold at price ' . $item->highestBid . '$. ', 'picture' => 'http://profile.ak.fbcdn.net/hprofile-ak-snc4/hs1324.snc4/161996_166764056682774_6216247_q.jpg ', 'link' => 'http://www.facebook.com/apps/application.php?id=166764056682774', 'name' => 'eVeiling.com', 'cb' => '')); } catch (FacebookApiException $e) { print_r($o); } } if ($winuser->fb_id) { try { $wallpostpage = $facebook->api('/' . $winuser->fb_id . '/feed', 'post', array('message' => 'You have won the auction of ' . $item->title . ' at ' . $item->highestBid . '$.', 'picture' => 'http://profile.ak.fbcdn.net/hprofile-ak-snc4/hs1324.snc4/161996_166764056682774_6216247_q.jpg ', 'link' => 'http://www.facebook.com/apps/application.php?id=166764056682774', 'name' => 'eVeiling.com', 'cb' => '')); } catch (FacebookApiException $e) { print_r($o); } } } $this->query = "update account set balance=balance+{$item->highestBid} where UserID={$item->ownerId}"; mysql_query($this->query); $this->query = "delete from bids where ItemID={$item->itemId}"; mysql_query($this->query); $this->query = "update items set OwnerId ={$bidderId}, status='sold' where ItemID={$item->itemId}"; mysql_query($this->query); $this->query = "insert into WonItems (winnerId,ownerId,ItemId) values ({$bidderId}, {$item->ownerId},{$item->itemId} )"; mysql_query($this->query); mailForOwner($OwnerEmail, $item); mailForWinner($WinnerEmail, $item); } }