/Control/NewMessage.php

<?php

require 'RegisterLogic.php';

require 'SendNotification.php';

require '../Model/Connect.php';



ob_start();

$To = 0;

$Club = 0;



if(LoggedIn()) {

	$Notify = new Notification();

	$MsgTo1 = $_POST['to'];

	$MsgTo = substr($MsgTo1,8);

	$Message = $_POST['message'];

	$User = $_SESSION['username'];

    $time = time();

	if(isset($_POST['club'])) {

    	$Club = $_POST['club'];

	}

    

    $GetUsernameTo = "SELECT mp_username FROM memberprofile WHERE mp_fullname = '".$MsgTo."' ";

    $ResultUsernameTo = mysql_query($GetUsernameTo);

	if ($ResultUsernameTo) {

		$rows = mysql_num_rows($ResultUsernameTo); 

		while($info = mysql_fetch_assoc( $ResultUsernameTo)) {

			$To = $info['mp_username'];

		}

	}

    

    $GetNameFrom = "SELECT mp_fullname FROM memberprofile WHERE mp_username = '".$User."' ";

    $ResultNameFrom = mysql_query($GetNameFrom);

	if ($ResultNameFrom) {

		$rows = mysql_num_rows($ResultNameFrom); 

		while($info = mysql_fetch_assoc( $ResultNameFrom)) {

			$From = $info['mp_fullname'];

		}

	}

    

    $sql = "SELECT max(no_ID)+1 AS x FROM notify ";

    $ResultSql = mysql_query($sql);

	if ($ResultSql) {

		$rows = mysql_num_rows($ResultSql); 

		while($info = mysql_fetch_assoc( $ResultSql)) {

			$MsgID = $info['x'];

		}

	}

    

   

    

	if(!$To || !$Message ) {

		echo 'Please enter the required details';

	} else if(!$Club) {

		$Result = $Notify->SendMessage($To,$From,$Message,$MsgID,$time);

		if($Result) {

			echo '<script language="javascript">alert("Message sent successfully")</script>';

			if($_SESSION['role'] == 'member' || $_SESSION['role'] == 'clubAdmin' ) {

				echo '<script type="text/javascript"> window.location = "../View/MemberProfile.php"</script>';

			} else {

				echo '<script type="text/javascript"> window.location = "../View/SiteAdminProfile.php"</script>';

			}

		} else {

			echo '<script language="javascript">alert("Message sending error. Try again later")</script>';

			if($_SESSION['role'] == 'member') {

				echo '<script type="text/javascript"> window.location = "../View/MemberProfile.php"</script>';

			} else {

				echo '<script type="text/javascript"> window.location = "../View/SiteAdminProfile.php"</script>';

			}

		}

	} else {

		//send message to the club members

		$ClubId = GetClubId($Club);

		$sql = "SELECT cm_member FROM clubmember WHERE cm_clubid = '".$ClubId."'";

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

        	$rows = mysql_num_rows($result);

        	$storeArray = Array();

            while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {

                $storeArray[] =  $row['cm_member'];  

        	}

            for ( $i=0 ; $i<$rows ; $i++ )

        	{

        	    $To = $storeArray[$i];

        		$send = $notify->SendMessage($To,$From,$Message);

        		if ($send) {

        		    $done = 1;

        		}

        	}

        } else {

        	echo 'OOOPPPSSS';

        }

        if ($done == 1) {

        	return true;

        } else {

        	return false;

        }

		

	}

} else {

	echo 'error';

}



function GetClubId($ClubName)

{ 

    $sql = "SELECT cl_id FROM Club WHERE cl_name = '".$ClubName."'";

	$Result = mysql_query($sql);

	if ($Result) {

		$rows = mysql_num_rows($Result); 

		while($info = mysql_fetch_assoc( $Result )) {

			$ID = $info['cm_clubid'];

		}

		return $ID;

	} else {

	    return false;

	}   

}

?>