/Control/CreateClubLogic.php

<?php



function CheckClubAvailability($ClubName) {

    $Query = "SELECT * FROM `club` WHERE `cl_name` = '".$ClubName."'";

	$QueryRun = mysql_query($Query);

				

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

	    return true;

	}

}



function InsertClub($ClubName, $ClubType, $Username,$Image) {

    $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 SendNotification($From,$Name,$Type)

{

    $sql = "INSERT INTO clubcreaterequest VALUES ('".$From."','".$Name."','".$Type."',1) "; 

	if ($result = mysql_query($sql)) {

		return true;

	} else {

		return false;

	}			

}



function DeleteClubReq($ClubName, $ClubType, $Username) {

    $QueryDelete = "DELETE FROM `clubcreaterequest` WHERE ccr_name='".$ClubName."' AND ccr_type='".$ClubType."' AND ccr_from='".$Username."' ";

	$result = mysql_query($QueryDelete);

	if($result) {

	    return true;				    

	} else {

		return false;

	}

}

?>