1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
|
<?php
/**
* Twitter Works
*
* Adapted for Ampache by Chris Slamar
*
*
* LICENSE: GNU General Public License, version 2 (GPLv2)
* Copyright (c) 2001 - 2011 Ampache.org All Rights Reserved
*
* This program is free software; you can redistribute it and/or
* modify it under the terms of the GNU General Public License v2
* as published by the Free Software Foundation.
*
* This program is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU General Public License for more details.
*
* You should have received a copy of the GNU General Public License
* along with this program; if not, write to the Free Software
* Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.
*
* @author Chris Slamar
* @copyright 2001 - 2011 Ampache.org
* @license http://opensource.org/licenses/gpl-2.0 GPLv2
* @link http://www.ampache.org/
*/
require_once '../../lib/init.php';
require_once( Config::get('prefix') . "/modules/twitter/twitteroauth/twitteroauth.php");
session_start();
if(!empty($_SESSION['twitterusername'])) {
header('Location: ' . Config::Get('web_path') . '/modules/twitter/twitter_update.php');
debug_event("Twitter", "Twitter user has logged in this session.", "5");
}
if(!empty($_GET['oauth_verifier']) && !empty($_SESSION['oauth_token']) && !empty($_SESSION['oauth_token_secret'])){
debug_event("Twitter", "Got all 3 pieces for auth", "5");
} else {
if( $_SESSION['twitterCount'] < 4 ) {
debug_event("Twitter", "Didn't get all 3 auth pieces, going to try again. Try #" . $_SESSION['twitterCount'], "5");
$_SESSION['twitterCount']++;
header('Location: ' . Config::Get('web_path') . '/modules/twitter/twitter_login.php');
} else {
debug_event("Twitter", "Failed to auth too many times. Giving up.", "5");
header('Location: ' . Config::Get('web_path') );
}
}
// TwitterOAuth instance, with two new parameters we got in twitter_login.php
$twitteroauth = new TwitterOAuth( Config::get('twitter_consumer_key'), Config::get('twitter_consumer_secret'), $_SESSION['oauth_token'], $_SESSION['oauth_token_secret']);
if( !isset($twitteroauth) ) {
debug_event("Twitter", "Couldn't create OAuth object.", "5");
header('Location: ' . Config::get('web_path'));
}
// Let's request the access token
$access_token = $twitteroauth->getAccessToken($_GET['oauth_verifier']);
if( !isset($access_token) ) {
debug_event("Twitter", "Couldn't get access token", "5");
header('Location: ' . Config::get('web_path'));
}
// Save it in a session var
$_SESSION['access_token'] = $access_token;
// Let's get the user's info
$user_info = $twitteroauth->get('account/verify_credentials');
debug_event("Twttier", "User ID:{$user_info->id}. ScreenName:{$user_info->screen_name}.", "5");
debug_event("Twitter", "access token:" . $access_token['oauth_token'], "5");
debug_event("Twitter", "access token secret:" . $access_token['oauth_token_secret'], "5");
if( isset($user_info->error)) {
debug_event("Twitter", "Error verifying credentials", "5");
session_destroy();
header('Location: ' . Config::get('web_path'));
} else {
// Let's find the user by its twitterid and ampacheid
$idselectquery = "SELECT * FROM twitter_users WHERE oauth_provider = 'twitter' AND oauth_uid = ". $user_info->id . " AND ampache_id = " . $_SESSION['userdata']['uid'];
debug_event("Twitter", "Id query: " . $idselectquery, "6");
$idselectrun = Dba::read($idselectquery);
$result = Dba::fetch_assoc($idselectrun);
debug_event("Twitter", "ampache_id: {$_SESSION['userdata']['uid']}", "5");
debug_event("Twitter", "oauth_uid: {$user_info->id}", "5");
debug_event("Twitter", "oauth_token: {$access_token['oauth_token']}", "5");
debug_event("Twitter", "oauth_secret: {$access_token['oauth_token_secret']}", "5");
debug_event("Twitter", "username: {$user_info->screen_name}", "5");
// If not, let's add it to the database
if(empty($result)){
debug_event("Twitter", "First time user. Add them to the DB.", "5");
$insert_query ="INSERT INTO twitter_users (ampache_id, oauth_provider, oauth_uid, oauth_token, oauth_secret, username) VALUES ( '{$_SESSION['userdata']['uid']}', 'twitter', '{$user_info->id}', '{$access_token['oauth_token']}', '{$access_token['oauth_token_secret']}', '{$user_info->screen_name}')";
debug_event("Twitter", "Insert query: " . $insert_query, "6");
$insert_run = Dba::write($insert_query);
$select_query = "SELECT * FROM twitter_users WHERE username = '" . $user_info->screen_name . "' AND ampache_id = " . $_SESSION['userdata']['uid'];
debug_event("Twitter", "Select query: {$query}", "6");
$select_run = Dba::read( $select_query );
$result = Dba::fetch_assoc($select_run);
} else {
debug_event("Twitter", "Update the DB to hold current tokens", "5");
$update_query = "UPDATE twitter_users SET oauth_token = '{$access_token['oauth_token']}', oauth_secret = '{$access_token['oauth_token_secret']}' WHERE oauth_provider = 'twitter' AND oauth_uid = {$user_info->id} AND ampache_id = {$_SESSION['userdata']['uid']}";
debug_event("Twitter", "update query: " . $update_query, "6");
$update_run = Dba::write($update_query);
$select_query = "SELECT * FROM twitter_users WHERE username = '" . $user_info->screen_name . "'";
debug_event("Twitter", "select query: " . $select_query, "6");
$select_run = Dba::read($select_query);
$result = Dba::fetch_assoc($select_run);
}
$_SESSION['id'] = $result['id'];
$_SESSION['twitterusername'] = $result['username'];
$_SESSION['oauth_uid'] = $result['oauth_uid'];
$_SESSION['oauth_provider'] = $result['oauth_provider'];
$_SESSION['oauth_token'] = $result['oauth_token'];
$_SESSION['oauth_secret'] = $result['oauth_secret'];
header('Location: ' . Config::get('web_path') . '/modules/twitter/twitter_update.php');
}
?>
|
