Temos pavadinimas: WordPress, Shopify ir PHPFusion programuotojų bendruomenė :: Narysx klausimai

Parašė Narysx· 2009 Vas. 22 19:02:29
#1
Nusprendžiau nebekurti atskirtų temų ir visus savo klausimus rašyti čia. :)

1. Kaip .php faile padaryti, kad kintamasis $vardas $pavarde kuris reiškia Jonas Jonaitis būtų atvaizduojamas kaip jonas jonaitis? Iš mažųjų raidžių.

Parašė Narysx· 2009 Vas. 22 19:02:05
#2
Dar vienas klausimas... Kas blogai šitoje užklausoje:

("SELECT * from table WHERE te_id='$pl_team_id' AND $pl_team_id < 30");

Parašė Narysx· 2009 Vas. 22 20:02:51
#3
up...

Parašė ex-it· 2009 Vas. 22 20:02:12
#4
po AND blogai.

Parašė Narysx· 2009 Vas. 22 20:02:27
#5
Šitą dalyką jau susitvarkiau. :)
Dabar jei galite atsakykit į pirmą klausimą ir turiu dar vieną...

3. Po užklausos mano $kaip gali reikšti 1, 2, 3, 4 arba 0. Kaip padaryti, kad jei 1 tai vaizduotų A, jei 2, tai B ir t.t. Čia kiek suprantu su if. :?

Parašė ex-it· 2009 Vas. 22 20:02:31
#6
if($kaip == '1') print A;
Redagavo ex-it· 2009 Vas. 22 20:02:44

Parašė Narysx· 2009 Vas. 22 20:02:01
#7
Ačiū. :) Dar laukiu atsakymo į pirmą klsm. ;D
Jau pasidariau. :) Nebereikia.
Redagavo Narysx· 2009 Vas. 22 20:02:59

Parašė Narysx· 2009 Vas. 23 16:02:05
#8
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

Parašė samatikas· 2009 Vas. 23 16:02:29
#9
kintamiesiums jonas ir jonaitis nepriskirtos reiksmes turetu buti $vardas = "jonas";
$pavarde = "jonaitis";
o jei nori atvaizduoti taj echo "$vardas.$pavrde";
Redagavo samatikas· 2009 Vas. 23 16:02:20

Parašė Narysx· 2009 Vas. 23 16:02:24
#10
Tai aš šitą viską jau susitvarkiau... Dabar man tik tereikia pagalbos su 4 klausimu.

Parašė samatikas· 2009 Vas. 23 17:02:31
#11
tingiu koda skaityt :D

Parašė Narysx· 2009 Vas. 23 17:02:48
#12
:[ Gal yra netinginčiu? :/