Teribear stats

Config['BaseURL'].$URL); } function Run() { } } class MyApplication extends Application { var $Database; var $Config; function __construct() { } function ShowMenu() { $Output = '

'. //'Tance '. //'Školy '. //'Seznamka '. '

'; return($Output); } function ProcessURL() { if(array_key_exists('REDIRECT_QUERY_STRING', $_SERVER)) $PathString = $_SERVER['REDIRECT_QUERY_STRING']; else $PathString = ''; if(substr($PathString, -1, 1) == '/') $PathString = substr($PathString, 0, -1); $PathItems = explode('/', $PathString); if(array_key_exists('REQUEST_URI', $_SERVER) and (strpos($_SERVER['REQUEST_URI'], '?') !== false)) $_SERVER['QUERY_STRING'] = substr($_SERVER['REQUEST_URI'], strpos($_SERVER['REQUEST_URI'], '?') + 1); else $_SERVER['QUERY_STRING'] = ''; parse_str($_SERVER['QUERY_STRING'], $_GET); return($PathItems); } // Query: text from name // Page: index of page, one page is 30 items // Category: '', all, men, woman, kids, families, teams // TeamId: id of team // Count: number of items per page, default 30 function QueryRunners($Category, $Page, $TeamId, $Query = null, $StartNumber = null, $Count = null) { $URL = 'http://leaderboard.teribear.cz/Home/GetRunners?category='.$Category.'&page='.$Page.'&teamId='.$TeamId; if ($Count != null) $URL .= '&count='.$Count; if ($Query != null) $URL .= '&query='.$Query; if ($Category != null) $URL .= '&startNumber='.$StartNumber; $Content = file_get_contents($URL); $JSON = json_decode($Content, true); //print_r($JSON); return $JSON; } function ShowTeamUpdate() { $Time = time(); $DbResult = $this->Database->query('SELECT * FROM Team'); while ($Team = $DbResult->fetch_assoc()) { echo('Checking team '.$Team['WebId'].'...'); $Runners = $this->QueryRunners('teams', 0, $Team['WebId']); foreach ($Runners['items'] as $Runner) { //print_r($Runner); $RunnerItem = new Runner(); $RunnerItem->Database = $this->Database; $RunnerItem->Name = $Runner['Name']; $RunnerItem->ChipNumber = $Runner['ChipNumber']; if ($Runner['Type'] == 'man') $RunnerItem->Gender = 1; if ($Runner['Type'] == 'woman') $RunnerItem->Gender = 2; $RunnerItem->Team = $Team['Id']; $RunnerItem->AddIfNotExist(); $DbResult = $this->Database->query('SELECT * FROM RunnerStat WHERE Runner='.$RunnerItem->Id.' ORDER BY TIME DESC LIMIT 1'); if ($DbResult->num_rows > 0) { $RunnerStat = $DbResult->fetch_assoc(); if ($RunnerStat['Distance'] != $Runner['OverallDistance']) { $this->Database->insert('RunnerStat', array( 'Time' => TimeToMysqlDateTime($Time), 'Runner' => $RunnerItem->Id, 'Distance' => $Runner['OverallDistance'], 'Rank' => $Runner['Pos'], 'Money' => $Runner['Money'], )); } } else { $this->Database->insert('RunnerStat', array( 'Time' => TimeToMysqlDateTime($Time), 'Runner' => $RunnerItem->Id, 'Distance' => $Runner['OverallDistance'], 'Rank' => $Runner['Pos'], 'Money' => $Runner['Money'], )); } } echo("
\n"); } } function ShowTeam() { $Output = ''; $TeamId = 1; if ((count($this->PathItems) > 0) and ($this->PathItems[count($this->PathItems) - 1] != '')) $TeamId = $this->PathItems[count($this->PathItems) - 1]; if (!is_numeric($TeamId)) die('TeamId needs to be numeric'); $DbResult = $this->Database->query('SELECT * FROM Team WHERE Id='.$TeamId); $DbRow = $DbResult->fetch_assoc(); $Output .= '

Team '.$DbRow['Name'].'

'; $Where = 'Team='.$TeamId; $DbResult = $this->Database->query('SELECT COUNT(*) FROM `Runner` WHERE '.$Where); $DbRow = $DbResult->fetch_row(); $PageList = GetPageList($DbRow[0]); $Gender = array('', 'Male', 'Female'); $Output .= '

'; $Output .= $PageList['Output']; $TableColumns = array( array('Name' => 'Name', 'Title' => 'Name'), array('Name' => 'Gender', 'Title' => 'Gender'), array('Name' => 'Distance', 'Title' => 'Distance'), array('Name' => 'Money', 'Title' => 'Money'), array('Name' => 'Rank', 'Title' => 'Rank'), array('Name' => 'Time', 'Title' => 'Last change'), ); $Order = GetOrderTableHeader($TableColumns, 'Distance', 1); $Output .= ''; $Output .= $Order['Output']; $DbResult = $this->Database->select('Runner', '*, '. '(SELECT RunnerStat.Distance FROM RunnerStat WHERE RunnerStat.Runner=Runner.Id ORDER BY Time DESC LIMIT 1) AS Distance'. ', (SELECT RunnerStat.Money FROM RunnerStat WHERE RunnerStat.Runner=Runner.Id ORDER BY Time DESC LIMIT 1) AS Money'. ', (SELECT RunnerStat.Time FROM RunnerStat WHERE RunnerStat.Runner=Runner.Id ORDER BY Time DESC LIMIT 1) AS Time'. ', (SELECT RunnerStat.Rank FROM RunnerStat WHERE RunnerStat.Runner=Runner.Id ORDER BY Time DESC LIMIT 1) AS Rank', $Where.$Order['SQL'].$PageList['SQLLimit']); while($MeetItem = $DbResult->fetch_assoc()) { $Output .= ''. ''. ''. ''. ''. ''. ''. ''; } $Output .= '

'.$MeetItem['Name'].'

'.$Gender[$MeetItem['Gender']].'

'.$MeetItem['Distance'].'

'.$MeetItem['Money'].'

'.$MeetItem['Rank'].'

'.HumanDateTime(MysqlDateTimeToTime($MeetItem['Time'])).'

'; $Output .= $PageList['Output']; $Output .= '

'; return($Output); } function ShowRunner() { $PrefixMultiplier = new PrefixMultiplier(); $Output = ''; $RunnerId = 1; if ((count($this->PathItems) > 0) and ($this->PathItems[count($this->PathItems) - 1] != '')) $RunnerId = $this->PathItems[count($this->PathItems) - 1]; if (!is_numeric($RunnerId)) die('Runner id needs to be numeric'); $DbResult = $this->Database->query('SELECT * FROM Runner WHERE Id='.$RunnerId); $DbRow = $DbResult->fetch_assoc(); $Output .= '

Runner '.$DbRow['Name'].'

'; $Where = 'Runner='.$RunnerId; $DbResult = $this->Database->query('SELECT COUNT(*) FROM `RunnerStat` WHERE '.$Where); $DbRow = $DbResult->fetch_row(); $PageList = GetPageList($DbRow[0]); $Output .= '

'; $Output .= $PageList['Output']; $TableColumns = array( array('Name' => 'Time', 'Title' => 'Time'), array('Name' => 'Distance', 'Title' => 'Distance [km]'), array('Name' => 'Money', 'Title' => 'Money [Kč]'), array('Name' => 'Rank', 'Title' => 'Rank'), array('Name' => 'Duration', 'Title' => 'Duration'), array('Name' => 'Length', 'Title' => 'Length [km]'), array('Name' => 'Speed', 'Title' => 'Speed [km/hour]'), ); $Order = GetOrderTableHeader($TableColumns, 'Time', 1); $Output .= ''; $Output .= $Order['Output']; $DbResult = $this->Database->query('SELECT *'. ', (SELECT RunnerStat.Time - B.Time FROM RunnerStat AS B WHERE (B.Time < RunnerStat.Time) AND (B.Runner = RunnerStat.Runner) ORDER BY B.Time DESC LIMIT 1) AS Duration'. ', (SELECT RunnerStat.Distance - B.Distance FROM RunnerStat AS B WHERE (B.Time < RunnerStat.Time) AND (B.Runner = RunnerStat.Runner) ORDER BY B.Time DESC LIMIT 1) AS Length'. ', NULL AS Speed'. ' FROM RunnerStat'. ' WHERE '.$Where.$Order['SQL'].$PageList['SQLLimit']); while($MeetItem = $DbResult->fetch_assoc()) { $Output .= ''. ''. ''. ''. ''; if ($MeetItem['Duration'] != null) $Output .= ''; else $Output .= ''; $Output .= ''; if ($MeetItem['Duration'] > 0) $Output .= ''; else $Output .= ''; $Output .= ''; } $Output .= '

'.HumanDateTime(MysqlDateTimeToTime($MeetItem['Time'])).'

'.$MeetItem['Distance'].'

'.$MeetItem['Money'].'

'.$MeetItem['Rank'].'

'.$PrefixMultiplier->Add($MeetItem['Duration'], '', 4, 'Time').'

'.$MeetItem['Length'].'

'.$PrefixMultiplier->Add($MeetItem['Length'] / $MeetItem['Duration'] * 3600, '', 4, 'Decimal').'

'; $Output .= $PageList['Output']; $Output .= '

'; return($Output); } function ShowPage($Content) { global $Config; $Output = 'Config['Encoding'].'"?>'."\n". ''. ''. ''. ''. ''. ''; $Output .= 'Teribear stats'. ''; $Output .= $Content; $Output .= '
'; $Output .= ''; return($Output); } function Run() { global $Config; $this->Config = $Config; $this->Database = new Database(); $this->Database->Connect($this->Config['Database']['Host'], $this->Config['Database']['User'], $this->Config['Database']['Password'], $this->Config['Database']['Database']); $this->Database->Prefix = $this->Config['Database']['Prefix']; $this->Database->charset($this->Config['Database']['Charset']); $this->PathItems = $this->ProcessURL(); $Output = ''; if(count($this->PathItems) > 0) { if($this->PathItems[0] == 'team-update') $Output .= $this->ShowTeamUpdate(); if($this->PathItems[0] == 'runner') $Output .= $this->ShowRunner(); else $Output .= $this->ShowTeam(); } else $Output .= $this->ShowTeam(); if (!$this->NoFullPage) { $Output = $this->ShowMenu().$Output; echo($this->ShowPage($Output)); } else echo($Output); } } $Application = new MyApplication(); $Application->Run();