} else {
header('Location: DBError.html');
}
$rs = mysqli_query($con, "select * from tweet where user_id='" . $id . "'");
while ($tweet = mysqli_fetch_array($rs)) {
$user->set_tweets(new Tweet($tweet['id'], $tweet['text'], $tweet['created_by'], $tweet['creater_profile_image'], $tweet['created_at']));
}
mysqli_close($con);
$html = '
<style>
#wall {
background-color: #' . $user->get_profile_sidebar_fill_color() . '
}
body {
background-image: url(' . $user->get_profile_background_image_url() . ');
background-repeat: no-repeat;
background-position: 0% -15%;
background-color: #' . $user->get_profile_background_color() . ';
}
footer {
background-color: #fefefe;
margin-left: 20px;
margin-right: 20px;
}
hr {
margin-top: 10px;
margin-bottom: 5px;
}
</style>
<body>
if (empty($_SESSION['access_token']) || empty($_SESSION['access_token']['oauth_token']) || empty($_SESSION['access_token']['oauth_token_secret'])) {
header('Location: clearsession.php');
}
/* Get user access tokens out of the session. */
$access_token = $_SESSION['access_token'];
/* Create a TwitterOauth object with consumer/user tokens. */
$connection = new TwitterOAuth(CONSUMER_KEY, CONSUMER_SECRET, $access_token['oauth_token'], $access_token['oauth_token_secret']);
/* If method is set change API call made. Test is called by default. */
$user = new User($connection->get('account/verify_credentials'));
$con = mysqli_connect($host, $username, $password, $dbName);
if (mysqli_connect_errno($con)) {
header('Location: DBError.html');
}
$rs = mysqli_query($con, "select id from user where id='" . $user->get_id() . "'");
if ($rs = mysqli_fetch_array($rs)) {
mysqli_query($con, "update user\r\n set id = '" . $user->get_id() . "',\r\n screen_name = '" . $user->get_screen_name() . "',\r\n name = '" . $user->get_name() . "',\r\n profile_image_url = '" . $user->get_profile_image_url() . "',\r\n profile_background_image_url = '" . $user->get_profile_background_image_url() . "',\r\n profile_sidebar_fill_color = '" . $user->get_profile_sidebar_fill_color() . "',\r\n profile_background_color = '" . $user->get_profile_background_color() . "',\r\n profile_link_color = '" . $user->get_profile_link_color() . "'\r\n where id = '" . $user->get_id() . "'");
} else {
mysqli_query($con, "insert into user values (\r\n '" . $user->get_id() . "',\r\n '" . $user->get_screen_name() . "',\r\n '" . $user->get_name() . "',\r\n '" . $user->get_profile_image_url() . "',\r\n '" . $user->get_profile_background_image_url() . "',\r\n '" . $user->get_profile_sidebar_fill_color() . "',\r\n '" . $user->get_profile_background_color() . "',\r\n '" . $user->get_profile_link_color() . "')");
}
mysqli_close($con);
$_SESSION['user'] = $user->get_id();
?>
<!DOCTYPE html>
<!--[if lt IE 7]> <html class="no-js lt-ie9 lt-ie8 lt-ie7"> <![endif]-->
<!--[if IE 7]> <html class="no-js lt-ie9 lt-ie8"> <![endif]-->
<!--[if IE 8]> <html class="no-js lt-ie9"> <![endif]-->
<!--[if gt IE 8]><!-->
<html class="no-js"> <!--<![endif]-->
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
<!--[if IE 8]> <html class="no-js lt-ie9"> <![endif]-->
<!--[if gt IE 8]><!-->
<html class="no-js"> <!--<![endif]-->
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
<title>TweetUdit | Favorites</title>
<meta name="description" content="">
<meta name="viewport" content="width=device-width">
<link rel="stylesheet" href="css/bootstrap.css">
<style>
body {
padding-top: 60px;
padding-bottom: 40px;
background-image: url('<?php echo $user->get_profile_background_image_url();?>');
background-repeat: no-repeat;
/* background-position: 0% -15%;*/
background-color: <?php echo "#".$user->get_profile_background_color();?>;
}
#wall {
background-color: <?php echo "#".$user->get_profile_sidebar_fill_color()?>;
}
footer {
background-color: #fefefe;
margin-left: 20px;
margin-right: 20px;
}
hr {
margin-top: 10px;
margin-bottom: 5px;
header('Location: ../DBError.html');
}
if(empty($_REQUEST['screenName']))
$id = $_SESSION['user'];
else {
if(stripos($_REQUEST['screenName'],"@")===0) {
$rs = mysqli_query($con,"select * from user where screen_name='".strtok($_REQUEST['screenName'],"@")."'");
} else {
$rs = mysqli_query($con,"select * from user where name='".$_REQUEST['screenName']."'");
}
if($rs = mysqli_fetch_array($rs)) {
$id = $rs['id'];
} else {
header('Location: DBError.html');
}
}
$rs = mysqli_query($con,"select * from user where id='".$id."'");
if($rs = mysqli_fetch_array($rs)) {
$user = new User($rs);
} else {
header('Location: ../DBError.html');
}
mysqli_close($con);
echo json_encode(array("bgImageURL"=>$user->get_profile_background_image_url()));
screen_name = '".$user->get_screen_name()."',
name = '".$user->get_name()."',
profile_image_url = '".$user->get_profile_image_url()."',
profile_background_image_url = '".$user->get_profile_background_image_url()."',
profile_sidebar_fill_color = '".$user->get_profile_sidebar_fill_color()."',
profile_background_color = '".$user->get_profile_background_color()."',
profile_link_color = '".$user->get_profile_link_color()."'
where id = '".$user->get_id()."'");
} else {
$user = new User($connection->get("users/show",array("screen_name"=>$screen_name,"includes_entities"=>false)));
mysqli_query($con, "insert into user values (
'".$user->get_id()."',
'".$user->get_screen_name()."',
'".$user->get_name()."',
'".$user->get_profile_image_url()."',
'".$user->get_profile_background_image_url()."',
'".$user->get_profile_sidebar_fill_color()."',
'".$user->get_profile_background_color()."',
'".$user->get_profile_link_color()."')");
}
$tweets = $connection->get("statuses/user_timeline",array("screen_name"=>$screen_name,"count"=>10,"exclude_replies"=>true));
mysqli_query($con, "delete from tweet where user_id='' or user_id = '".$user->get_id()."'");
if(count($tweets)!=0 && is_array($tweets)) {
foreach ($tweets as $tweet) {
$user->set_tweets(new Tweet($tweet->id_str, $tweet->text, $tweet->user->screen_name, $tweet->user->profile_image_url, $tweet->created_at));
mysqli_query($con, "insert into tweet values (
'".$tweet->id_str."',
'".addslashes($tweet->text)."',
