/Control/CreateTournamentLogic.php

<?php



function CheckClubAvailability($TourName) {

    $Query = "SELECT * FROM `tournament` WHERE `to_tournamentname` = '".$TourName."'";

	$QueryRun = mysql_query($Query);

				

	if (mysql_num_rows($QueryRun) == 1) {

	    return true;

	}

}



function InsertClub($TourID,$TourName) {

    $Query1 = "INSERT INTO `club` VALUES ('','".$ClubName."','".$ClubType."','".$Username."','".$Image."')";

	$Query2 = "SELECT * FROM `club` WHERE cl_name = '".$ClubName."' AND cl_type = '".$ClubType."' AND cl_administrator = '".$Username."'";

	if($Query1Run = mysql_query($Query1) && $Query2Run = mysql_query($Query2)) {

	    if (mysql_num_rows($Query2Run) == 1) {

			$ClubID = mysql_result ($Query2Run, 0, 'cl_id');

			$Query3 = "UPDATE `user` SET us_role = 'clubAdmin' WHERE us_username = '".$Username."'";

			$Query3Run = mysql_query($Query3);

			$Query4 = "INSERT INTO `clubmember` values('".$ClubID."', '".$Username."')";

			if($Query4Run = mysql_query($Query4)) {

				return $ClubID;

			}

		}					    

	} else {

		return false;

	}

}



function DeleteTourReq($TourName, $Username) {

    $QueryDelete = "DELETE FROM `tourcreaterequest` WHERE tcr_name='".$TourName."' AND tcr_from='".$Username."' ";

	$result = mysql_query($QueryDelete);

	if($result) {

	    return true;				    

	} else {

		return false;

	}

}

?>