Mercurial > hg > ywww

comparison facebook/facebookLogin.php @ 6:077b0a0a3e6d

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
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
comparison
equal deleted inserted replaced
5:55445b456ad0 6:077b0a0a3e6d
1 <?PHP
2 header("Expires: Mon, 26 Jul 1997 05:00:00 GMT");
3 header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT");
4 header("Cache-Control: no-store, no-cache, must-revalidate");
5 header("Cache-Control: post-check=0, pre-check=0", false);
6 header("Pragma: no-cache");
7 require 'facebook.php';
8
9 // Create our Application instance.
10 $facebook = new Facebook(array(
11 'appId' => '128245333876633',
12 'secret' => 'f51afc7e04289db62448edd8b70d83bf',
13 'cookie' => true,
14 ));
15
16 $session = $facebook->getSession();
17
18 $me = null;
19 sleep(2);
20 // Session based API call.
21 if ($session) {
22 try {
23 $uid = $facebook->getUser();
24 $me = $facebook->api('/me');
25
26 include "../../private/db.php";
27 $Email = $me['email'];
28 $FirstName = $me['first_name'];
29 $Surname = $me['last_name'];
30 //echo $Email;
31 $sql1="SELECT FirstName, Surname, DisplayName, UserID from user WHERE Email ='$Email'";
32 //echo $sql1;
33 $result1=mysqli_query($link,$sql1);
34
35 // If successfully queried
36 if($result1){
37 $count=mysqli_num_rows($result1);
38 if($count==0){
39 //User doesn't already exist
40 $add="CALL addNewUser('$Email', 'facebook', '$FirstName', '$Surname', 0, '', 0)";
41 //echo $add;
42 $result2 = mysqli_query($link, $add);
43
44 //reset connection
45 mysqli_close($link);
46 include "../../private/db.php";
47
48 $sql3="SELECT FirstName, Surname, DisplayName, UserID from user WHERE Email ='$Email'";
49 //echo $sql3;
50 $resultFull=mysqli_query($link,$sql3);
51 }
52 else{
53 $resultFull = $result1;
54 }
55 if($resultFull){
56 //User Exists
57 //echo "ResultFull!";
58 $line=mysqli_fetch_array($resultFull, MYSQLI_ASSOC);
59 $firstName=$line['FirstName'];
60 $surname=$line['Surname'];
61 $displayName=$line['DisplayName'];
62 $id=$line['UserID'];
63
64 if($displayName == "")
65 {
66 if($firstName == "")
67 $displayName=$Email;
68 else
69 $displayName = $firstName;
70 }
71
72 session_start();
73 $_SESSION['displayName']=$displayName;
74 $_SESSION['email']=$Email;
75 $_SESSION['surname']=$surname;
76 $_SESSION['UserID']=$id;
77 $_SESSION['receiveEmail']=$receiveEmail;
78 $_SESSION['GRState']=$GRState;
79 $_SESSION['Loc']=$LocID;
80 echo session_id();
81 echo ":::" . $displayName . ":::" . $surname . ":::" . $receiveEmail . ":::" . $GRState . ":::" . $LocID . ":::" . $Email . ":::" . $id;
82 }
83 }
84
85 } catch (FacebookApiException $e) {
86 error_log($e);
87 }
88 }
89
90 ?>