Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- private function doOdds() {
- $timestamp = time();
- $sentCnt = 0;
- foreach ($this->myusers as $user) {
- $sql3 = "SELECT SessionLogs.eventid, MarketMatchWinner.HomeWin, MarketMatchWinner.AwayWin, Market3Way.Home3Way
- FROM SessionLogs
- LEFT JOIN EventInfo ON SessionLogs.slotid = EventInfo.SlotID and EventInfo.PackageID = '{$user->packageid}'
- LEFT JOIN Market3Way ON EventInfo.Market3WayID = Market3Way.Market3WayID
- LEFT JOIN MarketMatchWinner ON EventInfo.MatchWinnerID = MarketMatchWinner.MatchWinnerID
- Order By SessionLogs.eventid desc
- Limit 1";
- $res = db_fetch($sql3);
- $returnXML = '<Odds timestamp="'.$timestamp.'">';
- foreach ($res as $eventInfo) {
- $returnXML .= '<Event eventid="'.$eventInfo['eventid'].'"
- Home3Way="'.$eventInfo['Home3Way'].'"
- Away3Way="'.$eventInfo['Away3Way'].'" Tie3Way="'.$eventInfo['Tie3Way'].'"/>';
- }
- $returnXML .= "</Odds>";
- $this->send($user, $returnXML);
- $this->doLogMessage($user, 10);
- $sentCnt++;
- }
- echo "Sent Odds message to {$sentCnt} users.n";
- }
- else if (substr($message, 1, 4) == "Odds") {echo "Odds message receivedn";
- $this->DoMessageLog("Odds", $timestamp);
- $eventInfo = $msgArr['Event'];
- $eventid = $eventInfo['@attributes']['eventid'];
- $Home3Way = $eventInfo['@attributes']['Home3Way'];
- $Away3Way = $eventInfo['@attributes']['Away3Way'];
- $Tie3Way = $eventInfo['@attributes']['Tie3Way'];
- $sql = "update SessionLogs set
- Away3Way = '{$Away3Way}',
- Home3Way = '{$Home3Way}',
- Tie3Way = '{$Tie3Way}'
- where SessionLogs.eventid in '{$eventid}'";
- db_query($sql);
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement