diff twitter/twitterLogin.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/twitter/twitterLogin.php	Thu Feb 16 22:29:02 2017 +0000
@@ -0,0 +1,81 @@
+<?PHP
+	include "../../private/db.php"; 
+
+	include 'EpiCurl.php';
+	include 'EpiOAuth.php';
+	include 'EpiTwitter.php';
+	include 'secret.php';
+
+	$twitterObj = new EpiTwitter($consumer_key, $consumer_secret);
+
+	$twitterObj->setToken($_GET['oauth_token']);
+	$token = $twitterObj->getAccessToken();
+	$twitterObj->setToken($token->oauth_token, $token->oauth_token_secret);
+
+	// save to cookies
+	setcookie('oauth_token', $token->oauth_token);
+	setcookie('oauth_token_secret', $token->oauth_token_secret);
+
+	$twitterInfo= $twitterObj->get_accountVerify_credentials();
+
+	$User = "@" . $twitterInfo->screen_name;
+	/*$link = mysqli_connect("localhost","root","");
+	mysqli_select_db($link, "books");
+	$User = "@" . "BWaaack";*/
+
+	$sql1="SELECT FirstName, Surname, DisplayName, UserID from user WHERE Email ='$User'";
+	//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
+			//set email to TwitterName
+			//use defaults for other values	
+			$add="CALL addNewUser('$User', 'twitter', '', '', 0, '$User', 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 ='$User'";
+			//echo $sql3;
+			$resultFull=mysqli_query($link,$sql3);
+		}
+		else{
+			$resultFull = $result1;
+		}
+		if($resultFull){	
+			//User Exists
+			$line=mysqli_fetch_array($resultFull, MYSQLI_ASSOC);
+			$email = $line['Email'];
+			$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;
+		}
+	}
+?>
\ No newline at end of file