diff facebook/facebookLogin.php @ 6:077b0a0a3e6d

remaining originals according to dependency walk
author Robert Boland <robert@markup.co.uk>
date Thu, 16 Feb 2017 22:29:02 +0000
parents
children 385ddd7c4b55 a67bf725e87b
line wrap: on
line diff
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/facebook/facebookLogin.php	Thu Feb 16 22:29:02 2017 +0000
@@ -0,0 +1,90 @@
+<?PHP
+header("Expires: Mon, 26 Jul 1997 05:00:00 GMT");
+header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT");
+header("Cache-Control: no-store, no-cache, must-revalidate");
+header("Cache-Control: post-check=0, pre-check=0", false);
+header("Pragma: no-cache");
+	require 'facebook.php';
+
+	// Create our Application instance.
+	$facebook = new Facebook(array(
+	  'appId'  => '128245333876633',
+	  'secret' => 'f51afc7e04289db62448edd8b70d83bf',
+	  'cookie' => true,
+	));
+
+	$session = $facebook->getSession();
+
+	$me = null;
+	sleep(2);
+	// Session based API call.
+	if ($session) {
+	  try {
+		$uid = $facebook->getUser();
+		$me = $facebook->api('/me');
+		
+		include "../../private/db.php"; 
+		$Email = $me['email'];
+		$FirstName = $me['first_name'];
+		$Surname = $me['last_name'];
+		//echo $Email;
+		$sql1="SELECT FirstName, Surname, DisplayName, UserID from user WHERE Email ='$Email'";
+		//echo $sql1;
+		$result1=mysqli_query($link,$sql1);
+
+		// If successfully queried
+		if($result1){
+			$count=mysqli_num_rows($result1);
+			if($count==0){
+				//User doesn't already exist
+				$add="CALL addNewUser('$Email', 'facebook', '$FirstName', '$Surname', 0, '', 0)";
+				//echo $add;
+				$result2 = mysqli_query($link, $add);
+				
+				//reset connection
+				mysqli_close($link);
+				include "../../private/db.php"; 
+				
+				$sql3="SELECT FirstName, Surname, DisplayName, UserID from user WHERE Email ='$Email'";
+				//echo $sql3;
+				$resultFull=mysqli_query($link,$sql3);
+			}
+			else{
+				$resultFull = $result1;
+			}
+			if($resultFull){	
+				//User Exists
+				//echo "ResultFull!";
+				$line=mysqli_fetch_array($resultFull, MYSQLI_ASSOC);
+				$firstName=$line['FirstName'];
+				$surname=$line['Surname'];
+				$displayName=$line['DisplayName'];
+				$id=$line['UserID'];
+				
+				if($displayName == "")
+				{
+					if($firstName == "")
+						$displayName=$Email;
+					else
+						$displayName = $firstName;
+				}
+				
+				session_start();
+				$_SESSION['displayName']=$displayName;
+				$_SESSION['email']=$Email;
+				$_SESSION['surname']=$surname;
+				$_SESSION['UserID']=$id;
+				$_SESSION['receiveEmail']=$receiveEmail;
+				$_SESSION['GRState']=$GRState;
+				$_SESSION['Loc']=$LocID;
+				echo session_id();
+				echo ":::" . $displayName . ":::" . $surname . ":::" . $receiveEmail . ":::" . $GRState . ":::" . $LocID . ":::" . $Email . ":::" . $id;
+			}
+		}
+					
+	  } catch (FacebookApiException $e) {
+		error_log($e);
+	  }
+	}
+
+?>