4.
<?php
class NBAM {
public function __construct() {
$this->db = $GLOBALS["db"];
}
public function importDBF($teams_dbf, $players_dbf) {
// players
$dbf = new dbf_class($players_dbf);
$arrRec = $dbf->dbf_record;
foreach($arrRec as $key => $value) {
$pl_id = $value["PLAYERID"];
$player[$pl_id]["pl_id"] = (int)$pl_id;
$player[$pl_id]["pl_team_id"] = (int)$value["TEAM"];
$player[$pl_id]["pl_name"] = $value["NAME"];
$player[$pl_id]["pl_fname"] = $value["FNAME"];
$player[$pl_id]["pl_position"] = (int)$value["POSITION"];
$player[$pl_id]["pl_position1"] = (int)$value["POSITION2"];
$player[$pl_id]["pl_number"] = (int)$value["NUMBER"];
$player[$pl_id]["pl_rosterpos"] = (int)$value["ROSTERPOS"];
$player[$pl_id]["pl_overall"] = (int)$value["OVERALLRTG"];
$player[$pl_id]["pl_speed"] = (int)$value["SPEED"];
$player[$pl_id]["pl_quick"] = (int)$value["QUICK"];
$player[$pl_id]["pl_dribble"] = (int)$value["DRIBBLE"];
$player[$pl_id]["pl_offreb"] = (int)$value["OREABILITY"];
$player[$pl_id]["pl_defreb"] = (int)$value["DREABILITY"];
$player[$pl_id]["pl_dunk"] = (int)$value["DNKABILITY"];
$player[$pl_id]["pl_3pt"] = (int)$value["THREEPTBAS"];
$player[$pl_id]["pl_fg"] = (int)$value["FGPBASE"];
$player[$pl_id]["pl_ft"] = (int)$value["FTPBASE"];
$player[$pl_id]["pl_steal"] = (int)$value["STLABILITY"];
$player[$pl_id]["pl_block"] = (int)$value["BLKABILITY"];
$player[$pl_id]["pl_pass"] = (int)$value["BALABILITY"];
$player[$pl_id]["pl_nr"] = (int)$value["NUMBER"];
$player[$pl_id]["pl_exp"] = (int)$value["YEARSEXP"];
$player[$pl_id]["pl_hand"] = (int)$value["HAND"];
$player[$pl_id]["pl_birth"] = (int)$value["BIRTHDATE"];
$player[$pl_id]["pl_year"] = (int)$value["DRAFTYEAR"];
$player[$pl_id]["pl_draft"] = $value["DRAFTEDBY"];
$player[$pl_id]["pl_dps"] = (int)$value["DPLACE"];
$player[$pl_id]["pl_stam"] = (int)$value["FATIGUE"];
$this->db->insertArray($player[$pl_id], TABLE_PLAYERS);
}
unset($player, $arrRec);
// teams
$dbf = new dbf_class($teams_dbf);
$arrRec = $dbf->dbf_record;
foreach($arrRec as $key => $value) {
$te_id = $value["TEAMNUM"];
$team[$te_id]["te_id"] = (int)$te_id;
$team[$te_id]["te_name"] = $value["TEAMNAME"];
$team[$te_id]["te_city"] = $value["CITYNAME"];
$team[$te_id]["te_abbrev"] = $value["ABBREV"];
$team[$te_id]["te_abbrev1"] = $value["TEAMABR2"];
$team[$te_id]["te_abbrev2"] = $value["TEAMABR4"];
$team[$te_id]["te_division"] = (int)$value["DIVISION"];
$team[$te_id]["te_overall"] = (int)$value["OVERALL"];
$this->db->insertArray($team[$te_id], TABLE_TEAMS);
}
unset($team, $arrRec);
}
public function importGames($data_dir) {
$this->db->query("TRUNCATE ".TABLE_GAMES);
$this->db->query("TRUNCATE ".TABLE_GAMESTATS);
if ($handle = opendir($data_dir)) {
while (false !== ($dir = readdir($handle))) {
if ($dir != "." && $dir != ".." && filetype($data_dir."/".$dir) == "dir") {
$dir = realpath($data_dir."/".$dir);
$this->addGame2($dir);
}
}
closedir($handle);
}
}
public function addGame2($dir) {
$game["date"] = (int)substr($dir, strrpos($dir, "/")+1);
$game["home"] = $this->fetchStats("$dir/home.txt");
$game["away"] = $this->fetchStats("$dir/away.txt");
$sql = "SELECT * FROM ".TABLE_TEAMS." WHERE te_city='".$game["home"]["team"]."'";
$home = $this->db->getRow($sql);
$sql = "SELECT * FROM ".TABLE_TEAMS." WHERE te_city='".$game["away"]["team"]."'";
$away = $this->db->getRow($sql);
$sql = "INSERT INTO ".TABLE_GAMES." (ga_home_id, ga_away_id, ga_home_score, ga_away_score, ga_date) VALUES ($home[te_id], $away[te_id],".$game["home"]["Pts"].",".$game["away"]["Pts"].", $game[date])";
$this->db->query($sql);
$game_id = $this->db->lastID();
foreach ($game["home"]["players"] as $param => $value) {
$s[0] = $value["Pos."]; // pos to int
if ($value["Pos."] == "C") $s[0] = 0;
if ($value["Pos."] == "PF") $s[0] = 1;
if ($value["Pos."] == "SF") $s[0] = 2;
if ($value["Pos."] == "SG") $s[0] = 3;
if ($value["Pos."] == "PG") $s[0] = 4;
$s[1] = addslashes($value["Name"]); //pl_id to int
$sql = "SELECT pl_id FROM ".TABLE_PLAYERS." WHERE pl_team_id=".$home["te_id"]." AND CONCAT(SUBSTRING(pl_fname,1,1),'. ',pl_name) LIKE '%".addslashes($value["Name"])."%' AND (pl_position=$s[0] OR pl_position1=$s[0])";
$s[1] = $this->db->getOne($sql);
$s[2] = (int)$value["Pts"];
$s[3] = (int)$value["Rebs"];
$s[4] = (int)$value["Ast"];
$s[5] = (int)$value["Blk"];
$s[6] = (int)$value["Stl"];
$s[7] = (int)$value["TO"];
$s[8] = (int)$value["Fouls"];
$s[9] = (int)$value["Mins"];
$s[10] = (int)$value["FG/Att"];
$s[11] = (int)substr($value["FG/Att"], strpos($value["FG/Att"], "/")+1);
$s[12] = (int)str_replace(".", "", $value["FG%"]);
$s[13] = (int)$value["3P/Att"];
$s[14] = (int)substr($value["3P/Att"], strpos($value["3P/Att"], "/")+1);
$s[15] = (int)str_replace(".", "", $value["3P%"]);
$s[16] = (int)$value["FT/Att"];
$s[17] = (int)substr($value["FT/Att"], strpos($value["FT/Att"], "/")+1);
$s[18] = (int)str_replace(".", "", $value["FT%"]);
$s[19] = (int)$value["O. Reb"];
$s[20] = (int)$value["D. Reb"];
$sql = "INSERT INTO ".TABLE_GAMESTATS." (st_ga_id,st_te_id,st_pl_id,st_pts,st_rebs,st_ast,st_blk,st_stl,st_to,st_fouls,st_mins,st_fgm,st_fga,st_fgp,st_3pm,st_3pa,st_3pp,st_ftm,st_fta,st_ftp,st_oreb,st_dreb)VALUES ($game_id,$home[te_id],$s[1],$s[2],$s[3],$s[4],$s[5],$s[6],$s[7],$s[8],$s[9],$s[10],$s[11],$s[12],$s[13],$s[14],$s[15],$s[16],$s[17],$s[18],$s[19],$s[20])";
if($s[1]) {
$this->db->query($sql);
}
}
foreach ($game["away"]["players"] as $param => $value) {
$s[0] = $value["Pos."]; // pos to int
if ($value["Pos."] == "C") $s[0] = 0;
if ($value["Pos."] == "PF") $s[0] = 1;
if ($value["Pos."] == "SF") $s[0] = 2;
if ($value["Pos."] == "SG") $s[0] = 3;
if ($value["Pos."] == "PG") $s[0] = 4;
$s[1] = addslashes($value["Name"]); //pl_id to int
$sql = "SELECT pl_id FROM ".TABLE_PLAYERS." WHERE pl_team_id=".$away["te_id"]." AND CONCAT(SUBSTRING(pl_fname,1,1),'. ',pl_name) LIKE '%".addslashes($value["Name"])."%' AND (pl_position=$s[0] OR pl_position1=$s[0])";
$s[1] = $this->db->getOne($sql);
$s[2] = (int)$value["Pts"];
$s[3] = (int)$value["Rebs"];
$s[4] = (int)$value["Ast"];
$s[5] = (int)$value["Blk"];
$s[6] = (int)$value["Stl"];
$s[7] = (int)$value["TO"];
$s[8] = (int)$value["Fouls"];
$s[9] = (int)$value["Mins"];
$s[10] = (int)$value["FG/Att"];
$s[11] = (int)substr($value["FG/Att"], strpos($value["FG/Att"], "/")+1);
$s[12] = (int)str_replace(".", "", $value["FG%"]);
$s[13] = (int)$value["3P/Att"];
$s[14] = (int)substr($value["3P/Att"], strpos($value["3P/Att"], "/")+1);
$s[15] = (int)str_replace(".", "", $value["3P%"]);
$s[16] = (int)$value["FT/Att"];
$s[17] = (int)substr($value["FT/Att"], strpos($value["FT/Att"], "/")+1);
$s[18] = (int)str_replace(".", "", $value["FT%"]);
$s[19] = (int)$value["O. Reb"];
$s[20] = (int)$value["D. Reb"];
$sql = "INSERT INTO ".TABLE_GAMESTATS." (st_ga_id,st_te_id,st_pl_id,st_pts,st_rebs,st_ast,st_blk,st_stl,st_to,st_fouls,st_mins,st_fgm,st_fga,st_fgp,st_3pm,st_3pa,st_3pp,st_ftm,st_fta,st_ftp,st_oreb,st_dreb)VALUES ($game_id,$away[te_id],$s[1],$s[2],$s[3],$s[4],$s[5],$s[6],$s[7],$s[8],$s[9],$s[10],$s[11],$s[12],$s[13],$s[14],$s[15],$s[16],$s[17],$s[18],$s[19],$s[20])";
if($s[1]) {
$this->db->query($sql);
}
}
return $game_id;
}
public function addGame($dir) {
$game["date"] = (int)substr($dir, strrpos($dir, "/")+1);
$game["home"] = $this->fetchStats("$dir/home.txt");
$game["away"] = $this->fetchStats("$dir/away.txt");
$sql = "SELECT * FROM ".TABLE_TEAMS." WHERE te_city='".$game["home"]["team"]."'";
$home = $this->db->getRow($sql);
$sql = "SELECT * FROM ".TABLE_TEAMS." WHERE te_city='".$game["away"]["team"]."'";
$away = $this->db->getRow($sql);
$sql = "INSERT INTO ".TABLE_GAMES." (ga_home_id, ga_away_id, ga_home_score, ga_away_score, ga_date) VALUES ($home[te_id], $away[te_id],".$game["home"]["Pts"].",".$game["away"]["Pts"].", $game[date])";
$this->db->query($sql);
$game_id = $this->db->lastID();
if($game["home"]["Pts"] > $game["away"]["Pts"])
{
list($win_name) = mysql_fetch_array(mysql_query("SELECT user_name FROM qwerty813asd1_users WHERE user_te_id='$home[te_id]'"));
list($lose_name) = mysql_fetch_array(mysql_query("SELECT user_name FROM qwerty813asd1_users WHERE user_te_id='$away[te_id]'"));
}
else
{
list($win_name) = mysql_fetch_array(mysql_query("SELECT user_name FROM qwerty813asd1_users WHERE user_te_id='$away[te_id]'"));
list($lose_name) = mysql_fetch_array(mysql_query("SELECT user_name FROM qwerty813asd1_users WHERE user_te_id='$home[te_id]'"));
}
if($win_name)
{
if(!mysql_fetch_array(mysql_query("SELECT * FROM qwerty813asd1_users_points WHERE owner_name='$win_name'")))
{
list($idas) = mysql_fetch_array(mysql_query("SELECT user_id FROM qwerty813asd1_users WHERE user_name='$win_name'"));
mysql_query("INSERT INTO qwerty813asd1_users_points (owner_name,owner_id) value('$win_name','$idas')");
}
}
if($lose_name)
{
if(!mysql_fetch_array(mysql_query("SELECT * FROM qwerty813asd1_users_points WHERE owner_name='$lose_name'")))
{
list($idas) = mysql_fetch_array(mysql_query("SELECT user_id FROM qwerty813asd1_users WHERE user_name='$lose_name'"));
mysql_query("INSERT INTO qwerty813asd1_users_points (owner_name,owner_id) value('$lose_name','$idas')");
}
mysql_query("UPDATE qwerty813asd1_users_points SET points_total=points_total+100 WHERE owner_name='$win_name'");
mysql_query("UPDATE qwerty813asd1_users_points SET points_total=points_total+50 WHERE owner_name='$lose_name'");
}
foreach ($game["home"]["players"] as $param => $value) {
$s[0] = $value["Pos."]; // pos to int
if ($value["Pos."] == "C") $s[0] = 0;
if ($value["Pos."] == "PF") $s[0] = 1;
if ($value["Pos."] == "SF") $s[0] = 2;
if ($value["Pos."] == "SG") $s[0] = 3;
if ($value["Pos."] == "PG") $s[0] = 4;
$s[1] = addslashes($value["Name"]); //pl_id to int
$sql = "SELECT pl_id FROM ".TABLE_PLAYERS." WHERE pl_team_id=".$home["te_id"]." AND CONCAT(SUBSTRING(pl_fname,1,1),'. ',pl_name) LIKE '%".addslashes($value["Name"])."%' AND (pl_position=$s[0] OR pl_position1=$s[0])";
$s[1] = $this->db->getOne($sql);
$s[2] = (int)$value["Pts"];
$s[3] = (int)$value["Rebs"];
$s[4] = (int)$value["Ast"];
$s[5] = (int)$value["Blk"];
$s[6] = (int)$value["Stl"];
$s[7] = (int)$value["TO"];
$s[8] = (int)$value["Fouls"];
$s[9] = (int)$value["Mins"];
$s[10] = (int)$value["FG/Att"];
$s[11] = (int)substr($value["FG/Att"], strpos($value["FG/Att"], "/")+1);
$s[12] = (int)str_replace(".", "", $value["FG%"]);
$s[13] = (int)$value["3P/Att"];
$s[14] = (int)substr($value["3P/Att"], strpos($value["3P/Att"], "/")+1);
$s[15] = (int)str_replace(".", "", $value["3P%"]);
$s[16] = (int)$value["FT/Att"];
$s[17] = (int)substr($value["FT/Att"], strpos($value["FT/Att"], "/")+1);
$s[18] = (int)str_replace(".", "", $value["FT%"]);
$s[19] = (int)$value["O. Reb"];
$s[20] = (int)$value["D. Reb"];
$sql = "INSERT INTO ".TABLE_GAMESTATS." (st_ga_id,st_te_id,st_pl_id,st_pts,st_rebs,st_ast,st_blk,st_stl,st_to,st_fouls,st_mins,st_fgm,st_fga,st_fgp,st_3pm,st_3pa,st_3pp,st_ftm,st_fta,st_ftp,st_oreb,st_dreb)VALUES ($game_id,$home[te_id],$s[1],$s[2],$s[3],$s[4],$s[5],$s[6],$s[7],$s[8],$s[9],$s[10],$s[11],$s[12],$s[13],$s[14],$s[15],$s[16],$s[17],$s[18],$s[19],$s[20])";
if($s[1]) {
$this->db->query($sql);
}
}
foreach ($game["away"]["players"] as $param => $value) {
$s[0] = $value["Pos."]; // pos to int
if ($value["Pos."] == "C") $s[0] = 0;
if ($value["Pos."] == "PF") $s[0] = 1;
if ($value["Pos."] == "SF") $s[0] = 2;
if ($value["Pos."] == "SG") $s[0] = 3;
if ($value["Pos."] == "PG") $s[0] = 4;
$s[1] = addslashes($value["Name"]); //pl_id to int
$sql = "SELECT pl_id FROM ".TABLE_PLAYERS." WHERE pl_team_id=".$away["te_id"]." AND CONCAT(SUBSTRING(pl_fname,1,1),'. ',pl_name) LIKE '%".addslashes($value["Name"])."%' AND (pl_position=$s[0] OR pl_position1=$s[0])";
$s[1] = $this->db->getOne($sql);
$s[2] = (int)$value["Pts"];
$s[3] = (int)$value["Rebs"];
$s[4] = (int)$value["Ast"];
$s[5] = (int)$value["Blk"];
$s[6] = (int)$value["Stl"];
$s[7] = (int)$value["TO"];
$s[8] = (int)$value["Fouls"];
$s[9] = (int)$value["Mins"];
$s[10] = (int)$value["FG/Att"];
$s[11] = (int)substr($value["FG/Att"], strpos($value["FG/Att"], "/")+1);
$s[12] = (int)str_replace(".", "", $value["FG%"]);
$s[13] = (int)$value["3P/Att"];
$s[14] = (int)substr($value["3P/Att"], strpos($value["3P/Att"], "/")+1);
$s[15] = (int)str_replace(".", "", $value["3P%"]);
$s[16] = (int)$value["FT/Att"];
$s[17] = (int)substr($value["FT/Att"], strpos($value["FT/Att"], "/")+1);
$s[18] = (int)str_replace(".", "", $value["FT%"]);
$s[19] = (int)$value["O. Reb"];
$s[20] = (int)$value["D. Reb"];
$sql = "INSERT INTO ".TABLE_GAMESTATS." (st_ga_id,st_te_id,st_pl_id,st_pts,st_rebs,st_ast,st_blk,st_stl,st_to,st_fouls,st_mins,st_fgm,st_fga,st_fgp,st_3pm,st_3pa,st_3pp,st_ftm,st_fta,st_ftp,st_oreb,st_dreb)VALUES ($game_id,$away[te_id],$s[1],$s[2],$s[3],$s[4],$s[5],$s[6],$s[7],$s[8],$s[9],$s[10],$s[11],$s[12],$s[13],$s[14],$s[15],$s[16],$s[17],$s[18],$s[19],$s[20])";
if($s[1]) {
$this->db->query($sql);
}
}
return $game_id;
}
public function removeGame($id) {
$sql = "SELECT ga_date FROM ".TABLE_GAMES." WHERE ga_id=$id";
$gameDate = $this->db->getOne($sql);
$gameDir = realpath(DIR_GAMESDATA."/".$gameDate);
$homeFile = "$gameDir/home.txt";
$awayFile = "$gameDir/away.txt";
unlink($homeFile); unlink($awayFile); rmdir($gameDir);
$sql = "DELETE FROM ".TABLE_GAMES." WHERE ga_id=$id";
$this->db->query($sql);
$sql = "DELETE FROM ".TABLE_GAMESTATS." WHERE st_ga_id=$id";
$this->db->query($sql);
}
private function fetchStats($file) {
$txt = file($file);
$team = trim($txt[1]);
$stats["team"]= $team;
$params = $txt[3];
$format = array(12,12,18,12,12,12,12,12,12,12,12,12,12,12,12,12,12,12,12);
$p = 0;
for ($i=0; $i<=count($format); $i++) {
$h = trim(substr($params, $p, $format[$i]));
if (strlen($h) > 0) $head[$i] = $h;
$p += $format[$i];
}
$txt = array_slice($txt, 5);
foreach ($txt as $line) {
$p = 0;
if (strlen(trim($line)) > 2) {
for ($i=0; $i<=count($format); $i++) {
$h = trim(substr($line, $p, $format[$i]));
if (strlen($h) > 0) $player[$head[$i]] = $h;
$p += $format[$i];
}
$stats["Pts"] += (int)$player["Pts"];
$stats["players"][$player["Name"].$player["Pos."]] = $player;
}
}
return $stats;
}
}
?>
Čia toks NBA turnyrams rezultatų įrašymo funkcijų failas. Jo dėka per .html failą galima įdėti rezultatą ir atsinaujina visa informacija duom. bazėje, + į ftp įsideda prisegti .txt failai. Aš noriu, kad visą to rezultato įdėjimą būtų galima įdėti php-fusion webe. Jei reikia, štai ir tas.html failas:
{include file="include/header.html"}
<b>Prašome įkelti statistikos failus.</b><br/><br/>
<form action="" method="post" enctype="multipart/form-data">
<input type="hidden" name="step" value="1" />
<input type="hidden" name="command" value="addgame" />
Namų komandos statistika: <br/>
<input type="file" name="home" />
<br/>
Svečių komandos statistika:<br/>
<input type="file" name="away" />
<br/><br/>
Slaptažodis:<br/>
<input type="password" name="password" />
<br/><br/>
<input type="submit" value="Atsiųsti" />
</form>
{include file="include/footer.html"}
Redagavo Narysx 2009 Vas. 23 16:02:48 |
Gal yra netinginčiu? :/