Mercurial > hg > ywww

comparison twitter/twitterLogin.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 include "../../private/db.php";
3
4 include 'EpiCurl.php';
5 include 'EpiOAuth.php';
6 include 'EpiTwitter.php';
7 include 'secret.php';
8
9 $twitterObj = new EpiTwitter($consumer_key, $consumer_secret);
10
11 $twitterObj->setToken($_GET['oauth_token']);
12 $token = $twitterObj->getAccessToken();
13 $twitterObj->setToken($token->oauth_token, $token->oauth_token_secret);
14
15 // save to cookies
16 setcookie('oauth_token', $token->oauth_token);
17 setcookie('oauth_token_secret', $token->oauth_token_secret);
18
19 $twitterInfo= $twitterObj->get_accountVerify_credentials();
20
21 $User = "@" . $twitterInfo->screen_name;
22 /*$link = mysqli_connect("localhost","root","");
23 mysqli_select_db($link, "books");
24 $User = "@" . "BWaaack";*/
25
26 $sql1="SELECT FirstName, Surname, DisplayName, UserID from user WHERE Email ='$User'";
27 //echo $sql1;
28 $result1=mysqli_query($link,$sql1);
29
30 // If successfully queried
31 if($result1){
32 $count=mysqli_num_rows($result1);
33 if($count==0){
34 //User doesn't already exist
35 //set email to TwitterName
36 //use defaults for other values
37 $add="CALL addNewUser('$User', 'twitter', '', '', 0, '$User', 0)";
38 //echo $add;
39 $result2 = mysqli_query($link, $add);
40
41 //reset connection
42 mysqli_close($link);
43 include "../../private/db.php";
44
45 $sql3="SELECT FirstName, Surname, DisplayName, UserID from user WHERE Email ='$User'";
46 //echo $sql3;
47 $resultFull=mysqli_query($link,$sql3);
48 }
49 else{
50 $resultFull = $result1;
51 }
52 if($resultFull){
53 //User Exists
54 $line=mysqli_fetch_array($resultFull, MYSQLI_ASSOC);
55 $email = $line['Email'];
56 $firstName=$line['FirstName'];
57 $surname=$line['Surname'];
58 $displayName=$line['DisplayName'];
59 $id=$line['UserID'];
60
61 if($displayName == "")
62 {
63 if($firstName == "")
64 $displayName=$email;
65 else
66 $displayName = $firstName;
67 }
68
69 session_start();
70 $_SESSION['displayName']=$displayName;
71 $_SESSION['email']=$email;
72 $_SESSION['surname']=$surname;
73 $_SESSION['UserID']=$id;
74 $_SESSION['receiveEmail']=$receiveEmail;
75 $_SESSION['GRState']=$GRState;
76 $_SESSION['Loc']=$LocID;
77 echo session_id();
78 echo ":::" . $displayName . ":::" . $surname . ":::" . $receiveEmail . ":::" . $GRState . ":::" . $LocID . ":::" . $email . ":::" . $id;
79 }
80 }
81 ?>