<?php $root = "/home/football/www/"; include $root . 'dbconnect_new.php'; require_once $root . 'api/v2/app_functions.php'; getLeagues(); function getLeagues() { global $dbconn; $query = $dbconn->prepare("SELECT country_id, name, COUNT(id) AS count FROM league\n\t\t\t\t\t\t\t GROUP BY name, country_id\n\t\t\t\t\t\t\t HAVING count>1"); $query->execute(); $allLeagues = $query->fetchAll(); foreach ($allLeagues as $data) { $query = $dbconn->prepare("SELECT id, name FROM league WHERE name = '{$data['name']}' AND country_id={$data['country_id']}"); $query->execute(); $ids = $query->fetchAll(); foreach ($ids as $id) { $name = $id['name']; $id = $id['id']; $query = $dbconn->prepare("SELECT id FROM sub_league WHERE league_id = '{$id}'"); $query->execute(); $subLeagueID = $query->fetchAll(); $newSubLeagueIds = array(); foreach ($subLeagueID as $subid) { $newSubLeagueIds[] = $subid['id']; } $newSubLeagueIds[] = $id; $newSubLeagueIds = implode(',', $newSubLeagueIds); $query = $dbconn->prepare("SELECT id FROM fixtures WHERE league_id in ({$newSubLeagueIds})"); $query->execute(); $fixturesReturned = $query->fetchAll();
*/ include 'gohtmlhead.php'; include 'goheader.php'; if (!isset($_GET['title'])) { $userSettings = new goUserSettings($userID); } ?> <form name="input" action="<?php echo $_SERVER['PHP_SELF']; ?> " method="get"> <?php echo '<div id="selectbets">'; // search selection filters via listbox populateTimeFilter($params['timefilter']); getLeagues('nfl'); getTeams($params['league'], $params['team']); // Has lot's of data - have to think how to make decipherable and efficient echo '<input type="hidden" value="selected" name="selected" />'; echo '<input type="submit" value="go" />'; echo '</div>'; echo '</form>'; echo '<div id="gameresults">'; getPublicGames($params); echo '</div>'; include 'gofooter.php'; ob_end_flush(); exit; function getPublicGames($params) { if (count($params) > 0) {
function letsGetStarted() { global $dbconn; $now_alternative = date('Y-m-d H:m:s'); /* $countriesToDelete = array( array('country'=>'Albania', 'id'=>'37623'), array('country'=>'Algeria', 'id'=>'37628'), array('country'=>'Austria', 'id'=>'35824'), array('country'=>'Belgium', 'id'=>'35850'), array('country'=>'Bosnia Herze', 'id'=>'37619'), array('country'=>'Bulgaria', 'id'=>'35907'), array('country'=>'Chile', 'id'=>'35922'), array('country'=>'Croatia', 'id'=>'35967'), array('country'=>'Cyprus', 'id'=>'35976'), array('country'=>'Czech Republic', 'id'=>'35988'), array('country'=>'Denmark', 'id'=>'35999'), array('country'=>'England', 'id'=>'36023'), array('country'=>'Europe UEFA', 'id'=>'35253'), array('country'=>'France', 'id'=>'36133'), array('country'=>'Germany', 'id'=>'36159'), array('country'=>'Greece', 'id'=>'36184'), array('country'=>'Hungary', 'id'=>'36204'), array('country'=>'Iran', 'id'=>'37640'), array('country'=>'Israel', 'id'=>'36304'), array('country'=>'Italy', 'id'=>'36317'), array('country'=>'Jordan', 'id'=>'37856'), array('country'=>'Kuwait', 'id'=>'37694'), array('country'=>'Malta', 'id'=>'37854'), array('country'=>'Moldova', 'id'=>'37657'), array('country'=>'Montenegro', 'id'=>'37950'), array('country'=>'Morocco', 'id'=>'37645'), array('country'=>'Netherlands', 'id'=>'36421'), array('country'=>'Northern Ireland', 'id'=>'36457'), array('country'=>'Oman', 'id'=>'37876'), array('country'=>'Poland', 'id'=>'36498'), array('country'=>'Portugal', 'id'=>'36509'), array('country'=>'Qatar', 'id'=>'37700'), array('country'=>'Romania', 'id'=>'36519'), array('country'=>'Russia', 'id'=>'36521'), array('country'=>'Saudia Arabia', 'id'=>'37652'), array('country'=>'Scotland', 'id'=>'36616'), array('country'=>'Slovakia', 'id'=>'36667'), array('country'=>'Slovenia', 'id'=>'36677'), array('country'=>'Spain', 'id'=>'36734'), array('country'=>'Switzerland', 'id'=>'36763'), array('country'=>'Tunisia', 'id'=>'37637'), array('country'=>'Turkey', 'id'=>'36774'), array('country'=>'UAE', 'id'=>'37708'), array('country'=>'Ukraine', 'id'=>'36798'), array('country'=>'Wales', 'id'=>'36840') ); */ foreach ($countriesToDelete as $country) { $leagues = getLeagues($country['id']); foreach ($leagues as $league) { $leagueID = $league['id']; $subleagues = getSubLeagues($leagueID); doDeleting($leagueID); if (count($subleagues) > 0) { foreach ($subleagues as $subleague) { $subleague_id = $subleague['id']; doDeleting($leagueID); } } } deleteCountry($country['id']); } vacuumDatabase(); echo 'DELETED'; }