football.class.php changes
Produced: 8/25/2007 12:09:31 PM

Mode: Differences with Context

Left file: D:\phpfootball20\football.class.php Right file: D:\phpfootball20old\football.class.php

 //* Copyright 2005 by Brian Paulson and George Garcia                                         *
 //* Please see http://lvbash.com/phpBB2 for more support on PHPFootball    *
 //* version                                                                                                                     *
 //*                                                                         *
 //***************************************************************************
 // DONOT CHANGE NEXT TWO VARIABLES -------------------------------------------------------------------------------
-var $version = "2.1 Spreads";
+var $version = "2.0 Spreads No Auto Scores";
-var $release_date = "Aug. 25, 2007";
+var $release_date = "June 27, 2007 2:40pm";
 // DONOT CHANGE ABOVE TWO VARIABLES  -----------------------------------------------------------------------------
 ########################################################
 # Database Variables                                                               #
 ########################################################
 var $host;
 var $ticker_righttoleft = "false";
 var $ticker_speed = "3";
 var $ticker_font = "Arial";
 var $ticker_fontsize ="14";
 var $ticker_fontcolor= "#ffffff";
 var $ticker_paused = "false";
-// SMTP mail entries
-var $UseSMTP = "";   // Use SMTP to mail users true = yes false = no
-var $SMTPHost = "";  // SMTP mail host
-var $SMTPUser = "";  // SMTP User id
-var $SMTPPassWord = ""; // SMTP Password
 //******************************************************************************
 //                              END USER CONFIGURATION                                                                             *
 //******************************************************************************
 function football()
         {
     require("dbinfo.php");
      $this->password_min_len = $row->password_min_len;
      $this->bet_amount = $row->bet_amount;
      $this->display_graphics = $row->display_graphics;
      $this->logo_width = $row->logo_width;
      $this->rssurl = $row->rssurl;
      $this->usespread = $row->spread;
-     $this->UseSMTP = $row->UseSMTP;
-     $this->SMTPHost = $row->SMTPHost;
-     $this->SMTPUser = $row->SMTPUser;
-     $this->SMTPPassWord = $row->SMTPPassWord;
      }
     }
 function dbConnect()
         {
         $db = @mysql_connect($this->host, $this->user, $this->pass);
         return $db;
     }
 function WhoOnlineIdle()
     {
     //get the current time
     $time = time();
-//    $sql1="select * from ".$this->prefix."online where timestamp+3600 < '".$time."'";
-//    $rs1=$this->dbQuery($sql1);
     //delete idle entries
      $del="delete from ".$this->prefix."online where timestamp+3600 < '".$time."'";
-     $dels = $this->dbQuery($del) or die( $del . mysql_error() );
+     $dels = $this->dbQuery($del);
     }
 // Validate e-mail including checking the server
 function checkEmail($email)
 {
    if(eregi("^[a-zA-Z0-9_]+@[a-zA-Z0-9\-]+\.[a-zA-Z0-9\-\.]+$]", $email))
      $captionno++;
      }
      }
 function getTicker1()
     {
-  $week=$this->currentWeek()-1;
+  $week=$this->currentWeek();
   $nogames=$this->AllGamesPlayedWeek($week);
   $str="";
   $display="Y";
   $list = $this->WinnersList($week,$display);
   if(is_array($list))
         {
          echo "<span style='background-color:#7FB51A;'> &nbsp; &nbsp; <B><font color=#000000>PHPFootball News Ticker</B></font>&nbsp; &nbsp; </span>\n";
     while($row = mysql_fetch_object($rs))
      {
      echo "&nbsp;--&nbsp; <B>$row->msg_line</B>&nbsp;\n";
      }
      if ($nogames == 0) {   //check if all games played for the week
-     echo "<span style='background-color:#EEE309;'> &nbsp; <B><font color=#000000>Week $week&nbsp; Winner:&nbsp;</font></span><b> $str &nbsp;&nbsp;</B>\n";
+     echo "<span style='background-color:#EEE309;'> &nbsp; <B><font color=#000000>This Week Winner:&nbsp;</font></span><b> $str &nbsp;&nbsp;</B>\n";
-      }
-     }
-          }
-function getTicker2()
-    {
-  $week=$this->currentWeek()-1;
-  $nogames=$this->AllGamesPlayedWeek($week);
-  $str="";
-  $display="Y";
-  $list = $this->WinnersList($week,$display);
-  if(is_array($list))
-        {
-        $str=implode(",",$this->WinnersList($week,$display));
-        }
-    $sql = "select msg_line from ".$this->prefix."ticker order by id";
-    $rs = $this->dbQuery($sql);
-    $rows = mysql_num_rows($rs);
-    if ($rows >0) {
-         echo "<nobr> &nbsp; &nbsp; <B><font color=#7FB51A>PHPFootball News Ticker</B></font>&nbsp; &nbsp;";
-    while($row = mysql_fetch_object($rs))
-     {
-     echo "&nbsp;--&nbsp; <B>$row->msg_line</B>&nbsp;";
-     }
-     if ($nogames == 0) {   //check if all games played for the week
-     echo "&nbsp; <B><font color=#000000>Week $week&nbsp;Winner:&nbsp;</font>$str</B></nobr>";
-      } else {
-      echo "</nobr>";
       }
      }
           }
 function NumberOfGames($week)
         {
        if ($row['gametime'] <= $ts)
                         {
                 $lockcount = $lockcount + 1;
             }
         }
        if ($gamecount == $lockcount)
-//         if ($lockcount >0)  // use to lock all games after start of first game ow week
          {
           $alllocked=true;
           }
        return $alllocked;
        }
          $del="delete from ".$this->prefix."tiebreaker where week = ".$week." and user = '".$user."'";
          $dels = $this->dbQuery($del);
          $in="insert into ".$this->prefix."tiebreaker (week, user, points) values(".$week.", '".$user."',".$picks['tb'].")";
          $ins = $this->dbQuery($in);
           }
+// email picks to user
+    $sql  = "SELECT * FROM ".$this->prefix."users WHERE user = '".$user."' AND maillist = '1'";
+    $rs = $this->dbQuery($sql);
+    $row = mysql_fetch_array($rs);
+    $email = $row['email'];
+    if ($email != "") {
+    $subject = "Your ".$this->sitetitle."";
+    $subject .= " Picks for Week: ".$week."";
+    $contents = "<html><head><title>User Picks</title></head><body>";
+    $contents .= "<link rel=\"stylesheet\" type=\"text/css\" href=\"".$this->copyrightweb."/styles.css\" />";
+    $contents .= "<font size=\"2\">Below are your picks for Week: ".$week."<br><b>Underlined teams are your picks</b></font><br><br>\n";
+    $contents .= "<table class=\"main\" cellpadding=\"0\" cellspacing=\"0\"><tr>\n<td align=\"left\" colspan=\"7\">Week ".$week." Picks for ".$user."</th></tr>\n<tr><td align=\"center\" colspan=\"3\"><strong>Date/Time</strong></td>\n<td align=\"center\" colspan=\"1\"><strong>Away</strong></td>\n<td>&nbsp;</td>\n<td align=\"center\" colspan=\"2\"><strong>Home</strong></td>\n</tr>\n";
+   $sql = "select * from ".$this->prefix."tiebreaker where week = '".$week."' and user = '".$user."'";
+   $rs = $this->dbQuery($sql);
+   $row = mysql_fetch_array($rs);
+   $tb = $row['points'];
+   $sql = "SELECT * FROM ".$this->prefix."picks, ".$this->prefix."schedule, ".$this->prefix."teams WHERE USER = '".$user."' AND week = '".$week."' AND ".$this->prefix."picks.gameid = ".$this->prefix."schedule.gameid AND ".$this->prefix."picks.pick = ".$this->prefix."teams.id ORDER BY ".$this->prefix."schedule.gametime, ".$this->prefix."schedule.gameid";
+   $result = $this->dbQuery($sql);
+   $nRows = mysql_num_rows($result);
+   $upicks = "";
+   for ($i=0; $i< $nRows; $i++){
+            $row = mysql_fetch_array($result);
+            $pickcity = $row['city'];
+            $pickname = $row['name'];
+            $gameid = $row['gameid'];
+            $pick = $row['pick'];
+   $sql="select ".$this->prefix."schedule.*, ".$this->prefix."teams.city as VCity, ".$this->prefix."teams.name as VName, ".$this->prefix."teams.display as VDisplayName, ".$this->prefix."teams.icon as Vicon, teams2.city as HCity, teams2.name as HName, teams2.display as HDisplayName, teams2.icon as Hicon from (".$this->prefix."schedule inner join ".$this->prefix."teams on ".$this->prefix."schedule.vid = ".$this->prefix."teams.id) inner join ".$this->prefix."teams as teams2 on ".$this->prefix."schedule.hid = teams2.id where ".$this->prefix."schedule.gameid = '".$gameid."'";
+   $pickresult = $this->dbQuery($sql);
+   $prow = mysql_fetch_array($pickresult);
+   $game = "";
+   $vid = $prow['vid'];
+   $vcity = $prow['VCity'];
+   $vname = $prow['VName'];
+   $vicon = $prow['Vicon'];
+   $hid = $prow['hid'];
+   $hcity = $prow['HCity'];
+   $hname = $prow['HName'];
+   $hicon = $prow['Hicon'];
+   $gametime = $prow['gametime'];
+   $date = date("m/d/Y",$gametime);
+   $time = date("H:i:s A",$gametime);
+   $ts = $this->doDate($date,$time,$this->display_offset);
+   $day = date("D",$ts);
+   $month = date("M d",$ts);
+   $time = date("g:i a",$ts);
+   $contents .= "<tr><td>".$day."</td><td>".$month."</td><td>".$time."</td>";
+   if ($vid == $pick) {
+    $visitor = "<b><u>";
+    $visitor .= $vcity;
+    $visitor .= " ";
+    $visitor .= $vname;
+    $visitor .= "</b></u>";
-         }
+    }
+    else {
+    $visitor = $vcity;
+    $visitor .= " ";
+    $visitor .= $vname;
+    }
+   $contents .= "<td>$visitor";
+   $contents .= $this->getTeamStats($vid);
+   $contents .= "</td>";
+   $contents .= "<td><img src = \"".$this->copyrightweb."/images/$vicon\" width=".$this->logo_width."></td>\n";
+   if ($hid == $pick) {
+    $home = "<b><u>";
+    $home .= $hcity;
+    $home .= " ";
+    $home .= $hname;
+    $home .= "</b></u>";
+    }
+    else {
+    $home = $hcity;
+    $home .= " ";
+    $home .= $hname;
+    }
+  $contents .= "<td>at  $home";
+  $contents .= $this->getTeamStats($hid);
+  $contents .= "</td>";
+  $contents .= "<td><img src = \"".$this->copyrightweb."/images/$hicon\" width=".$this->logo_width."></td>";
+  $contents .= "</tr>\n";
+}
+  $contents .= "</table>\n";
+  $contents .= "<br><br><br><b>Tie breaker for Monday Night Game: ".$tb."</b>\n";
+  $contents .= "<br><br>\n";
+  $to = $email;
+  $footer = "If you wish to not receive this letter, please click the following link:<br>\n";
+  $y = "<br><br>------------------------------------------------------------------------<br>\n";
+  $y .= $footer."<a href=\"".$this->copyrightweb."/unsubscribe.php\"><font size=\"2\">Unsubscribe</font></a><br>";
+  $y .= "\n";
+  $y .= "<br>------------------------------------------------------------------------\n";
+  $y .= "</body>";
+  $email = $contents.$y;
+  $headers .= "From: $this->admin_email\n";
+  $headers .= "Reply-To: $this->admin_email\n";
+  $headers .= "Return-Path: $this->admin_email\n";
+//  $headers .= "MIME-Version: 1.0\r\n";
+  $headers .= "Content-Type: text/html\r\n";
+//  $headers .= "X-Mailer: PHP / ".phpversion()."\r\n";
+  mail($to,$subject,$email,$headers);
+  $mail = "1";
+ }
+ return $mail;
+ }
 function GetPick($user)
         {
         $getpick="";
     $sql="select pick,gameid from ".$this->prefix."picks where user = '".$user."'";
         $rs = $this->dbQuery($sql);
                  $gamesxml[$row['gameid']] = $xmldata;
                  }
         return $gamesxml;
 }
 function fetchGameData($game) {
-    $myFFLurl = 'http://feeds.myffl.net/feed/game/';
-//    $myFFLurl = 'http://www.myffl.net/myffl/live/game.php';
+    $myFFLurl = 'http://www.myffl.net/myffl/live/game.php';
-    $myFFLquery = "?$game/PHP/arr/game";
+    $myFFLquery = "?$game/php";
     //$httpQuery = $this->ffl_HttpGet( $myFFLurl.$myFFLquery );
     $httpQuery = $this->ffl_HttpGet( $myFFLurl.$myFFLquery );
     $dataArray = unserialize( $httpQuery['body'] );
     return $dataArray;
 }