Mercurial > hg > ywww
view twitter/twitterLogin.php @ 33:c9d9b76ecbf9
minor tidying
| author | Charlie Root |
|---|---|
| date | Fri, 04 Jan 2019 11:35:59 -0500 |
| parents | 077b0a0a3e6d |
| children | 385ddd7c4b55 a67bf725e87b |
line wrap: on
line source
<?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; } } ?>
