session_start(); require 'admin/config.php'; $conn = new mysqli($sqlhost, $sqluser, $sqlpass, $sqldb); if($conn->connect_errno) { die('Failed to connect to database.'); } $conn->set_charset("utf8"); $scriptname = "records.php?" . $_SERVER['QUERY_STRING']; $nav_id = "fea"; $prefdata = $conn->query("SELECT * FROM tplss_preferences WHERE ID = '0'"); if($prefdata->num_rows) { $pdata = $prefdata->fetch_assoc(); } mysqli_free_result($prefdata); if(isset($_SESSION['defaultseasonid_tplss']) || isset($_SESSION['defaultmatchtypeid_tplss'])) { $seasonid = $_SESSION['defaultseasonid_tplss']; $compid = $_SESSION['defaultmatchtypeid_tplss']; } else { $_SESSION['defaultseasonid_tplss'] = $pdata['DefaultSeasonID']; $_SESSION['defaultmatchtypeid_tplss'] = $pdata['DefaultMatchTypeID']; $seasonid = $_SESSION['defaultseasonid_tplss']; $compid = $_SESSION['defaultmatchtypeid_tplss']; } $get_all_seasons = $conn->query("SELECT * FROM tplss_seasonnames ORDER BY SeasonName DESC"); $get_all_comps = $conn->query("SELECT * FROM tplss_matchtypes WHERE MatchGrade != 0 ORDER BY MatchTypeName"); ?>