$result_ClanScores = $sql->db_Query($q_ClanScores); $numClanScores = mysql_numrows($result_ClanScores); if ($numClanScores == 0) { // Delete players, teams, members, divisions and clan $q_ClanDivs = "SELECT " . TBL_DIVISIONS . ".*" . " FROM " . TBL_DIVISIONS . " WHERE (" . TBL_DIVISIONS . ".Clan = '{$clan_id}')"; $result_ClanDivs = $sql->db_Query($q_ClanDivs); $numClanDivs = mysql_numrows($result_ClanDivs); for ($i = 0; $i < $numClanDivs; $i++) { $div_id = mysql_result($result_ClanDivs, $i, TBL_DIVISIONS . ".DivisionID"); $division = new Division($div_id); $division->deleteDivPlayers(); $division->deleteDivTeams(); $division->deleteDivMembers(); $division->deleteDiv(); } $clan->deleteClan(); } //echo "-- clandelete --<br />"; header("Location: clans.php"); exit; } if (isset($_POST['clandeletediv'])) { $div_id = $_POST['clandiv']; $division = new Division($div_id); $q_DivScores = "SELECT " . TBL_DIVISIONS . ".*, " . TBL_TEAMS . ".*, " . TBL_PLAYERS . ".*, " . TBL_SCORES . ".*" . " FROM " . TBL_DIVISIONS . ", " . TBL_TEAMS . ", " . TBL_PLAYERS . ", " . TBL_SCORES . " WHERE (" . TBL_DIVISIONS . ".DivisionID = '{$div_id}')" . " AND (" . TBL_TEAMS . ".Division = " . TBL_DIVISIONS . ".DivisionID)" . " AND (" . TBL_PLAYERS . ".Team = " . TBL_TEAMS . ".TeamID)" . " AND (" . TBL_SCORES . ".Player = " . TBL_PLAYERS . ".PlayerID)"; $result_DivScores = $sql->db_Query($q_DivScores); $numDivScores = mysql_numrows($result_DivScores); if ($numDivScores == 0) { // Delete players, teams, members and divison $division->deleteDivPlayers(); $division->deleteDivTeams();