<?php // Grids echo getGrids($_SESSION['TourId']); ?> </table> </div> <div id="AwaDiv"> <div class="Title" style="cursor:pointer" onclick="this.nextElementSibling.style.display=(this.nextElementSibling.style.display=='none'?'table':'none')"><?php print get_text('ScheduleAwards', 'Boinx'); ?> </div> <table class="Tabella"> <?php // Awards echo getAwards($_SESSION['TourId']); ?> </table> </div> <?php include 'Common/Templates/tail.php'; function getExtra($TourId) { $QuaSes = 0; $ret = '<tr valign="top">'; // select all the possible feeds... $ret .= '<td colspan="4"><table cellpadding="0" cellspacing="0" border="0" width="100%">'; // Qualifications IND (Div and Class) $q = safe_r_sql("select distinct QuSession, BsType, left(BsExtra, 1) as BsSession, substr(BsExtra, 2) as BsTargetNo\n\t\t\tfrom Qualifications\n\t\t\tinner join Entries on EnId=QuId and EnTournament={$TourId}\n\t\t\tleft join BoinxSchedule on EnTournament=BsTournament and BsType=concat_ws('_', 'Qua', 'Ind')\n\t\t\twhere QuSession!='0'\n\t\t\torder by QuSession"); $ret .= '<tr><th colspan="' . (safe_num_rows($q) + 2) . '">' . get_text('Session') . "</th></tr>\n";
function getPlayerInfo($href) { //$href = "playerpage.htm?ilkid=ALLENMAR01"; //$href = "playerpage.htm?ilkid=ARRINLAV01"; $debug = false; $base_url = "http://databasefootball.com/players/"; //echo "href: $href<br>"; //echo "$base_url $href<br>"; $p_url = $base_url . $href; //echo "player url: $p_url<br>"; $player_page = file_get_html($p_url); $bio = $player_page->find('font.bio', 0); //echo var_dump($bio); $plaintext = $bio->plaintext; $innerText = $bio->innerText; //echo "innerText: $innerText<br>"; echo "Plaintext: {$plaintext}<br>"; $plaintext = preg_replace("(\\'\\')", "\"", $plaintext); $plaintext = preg_replace("(\\')", "\\'", $plaintext); $fullName = $position = $height = $weight = $dob = $hometown = $college = $drafted = $nickname = "null"; $fullName = getAttribute($plaintext, "", "Position:"); if (preg_match("/Full Name:/", $plaintext)) { if (!(strpos($fullName, "Full Name:") === false)) { $fullName = getAttribute($plaintext, "Full Name:", "Position:"); } } if (preg_match("/\\(*\\)/", $fullName)) { $nickname = getAttribute($plaintext, "(", ")"); } //echo "FullName: $fullName<br>"; if (preg_match("/Position:/", $plaintext)) { if (preg_match("/Height:/", $plaintext)) { $position = getAttribute($plaintext, "Position:", "Height:"); } else { $position = getAttribute($plaintext, "Position:", "Born:"); } } if (preg_match("/Height:/", $plaintext)) { $height = getAttribute($plaintext, "Height:", "Weight:"); } if (preg_match("/Weight:/", $plaintext)) { $weight = getAttribute($plaintext, "Weight:", "Born:"); } if (preg_match("/Born:/", $plaintext)) { if (preg_match("/, in/", $plaintext)) { $dob = getAttribute($plaintext, "Born:", ", in"); $hometown = getAttribute($plaintext, ", in", "High School:"); } else { if (preg_match("/High School:/", $plaintext)) { $dob = getAttribute($plaintext, "Born:", "High School:"); $dob = preg_replace("/,/", "", $dob); } else { $dob = getAttribute($plaintext, "Born:", ""); } } $dob = preg_replace("/,/", "", $dob); } if (preg_match("/College:/", $plaintext)) { $college = getAttribute($plaintext, "College:", "Drafted"); } if (preg_match("/Drafted:/", $plaintext)) { $drafted = getAttribute($plaintext, "Drafted:", ""); } //$fullName = $player_page->find("a h1")->plaintext; $header = $player_page->find("a[name] h1", 0); $fullName = $header->plaintext; //Jerry Da prato //John Smith //La var Arrington $fullName = preg_replace("/[[:space:]]([A-Z])/", " !\$1", htmltrim($fullName)); $fullName = preg_replace("(\\')", "\\'", $fullName); //echo var_dump($fullName)."<br>"; $name_array = explode(' !', $fullName); $first = $name_array[0]; $last = $name_array[1]; //echo "trs: ".var_dump($player_page->find('table tr[onmouseover]')); $teams = getTeams($player_page->find('table tbody tr td table tbody tr[onmouseover]')); //echo "Name: $fullName<br>"; if ($debug) { echo "plaintext: {$plaintext}<br>"; echo "nickName: {$nickname}<br>"; echo "Position: '{$position}'<br>"; echo "height: {$height}<br>"; echo "weight: {$weight}<br>"; echo "dob: {$dob}<br>"; echo "hometown: {$hometown}<br>"; echo "college: {$college}<br>"; echo "drafted: {$drafted}<br>"; echo "teams: {$teams}<br><br>"; } $insert = "INSERT INTO players (\r\n\t\t\t\tfirst_name, last_name, height, weight, dob, position, team, college, hometown, drafted, nickname) \r\n\t\t\t\tVALUES('{$first}', '{$last}', '{$height}', {$weight}, '{$dob}', '{$position}', '{$teams}', '{$college}', '{$hometown}', '{$drafted}', '{$nickname}')"; preg_replace("/''/", "'", $insert); echo $insert . "<br>"; //$result = mysql_query($insert); $id = mysql_insert_id(); /*********************** ///awards section /***********************/ getAwards($id, $player_page->find('td p font.bio', 0)); //->find('a[href^=/awards]') }
/******************************** * Process 'Awards' ********************************/ ErrorLog("Processing Award Data (" . $data["pID_{$x}"] . ")", 3); // Check if Minimal Central Update $awdsReqComplete = $cfg->get('stats_awds_complete'); if ($centralupdate == 2) { // Ignore any Award Data in SnapShot as this could mess up current data $complete = 0; $awdsReqComplete = 1; } if ($complete || !$awdsReqComplete) { // Check Backend Awards checkBackendAwards(); $awards = array(); getAwards(); if (count($awards)) { for ($i = 0; $i < count($awards); $i += 2) { if ($awards[$i] > 2000000 && $awards[$i] < 3000000) { $query = "SELECT level FROM awards WHERE (id = " . $data["pID_{$x}"] . ") AND (awd = {$awards[$i]})"; } else { $query = "SELECT level FROM awards WHERE (id = " . $data["pID_{$x}"] . ") AND (awd = {$awards[$i]}) AND (level = " . $awards[$i + 1] . ")"; } $result = mysql_query($query); checkSQLResult($result, $query); if (!mysql_num_rows($result)) { if ($awards[$i] > 2000000 && $awards[$i] < 3000000) { $first = time(); } elseif ($awards[$i] < 2000000 && $awards[$i + 1] > 1) { $first = 0; // Need to do extra work for Badges as more than one badge per round may have been awarded