<?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();
Esempio n. 2
0
*/
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';
}