$ud = new UserDAO($db);
$owner = $od->getByEmail($_SESSION['user']);
$i = $id->getByUserId($fb_user);
if (isset($i)) {
echo "Instance exists<br />";
$oi = $oid->get($owner->id, $i->id);
if ($oi == null) {
//Instance already exists, owner instance doesn't
$oid->insert($owner->id, $i->id, $session_key);
//Add owner instance with session key
echo "Created owner instance.<br />";
}
} else {
//Instance does not exist
echo "Instance does not exist<br />";
$id->insert($fb_user, $fb_username, 'facebook');
echo "Created instance";
$i = $id->getByUserId($fb_user);
$oid->insert($owner->id, $i->id, $session_key);
echo "Created owner instance.<br />";
}
if (!$ud->isUserInDB($fb_user)) {
$r = array('user_id' => $fb_user, 'user_name' => $fb_username, 'full_name' => $fb_username, 'avatar' => '', 'location' => '', 'description' => '', 'url' => '', 'is_protected' => '', 'follower_count' => 0, 'friend_count' => 0, 'post_count' => 0, 'last_updated' => '', 'last_post' => '', 'joined' => '', 'last_post_id' => '', 'network' => 'facebook');
$u = new User($r, 'Owner info');
$ud->updateUser($u);
}
} else {
echo "No session key or logged in Facebook user.";
}
# clean up
$db->closeConnection($conn);
$twitter_id = $api->doesAuthenticate();
if ($twitter_id > 0) {
echo "Twitter authentication successful.<br />";
$id = new InstanceDAO($db);
$i = $id->getByUsername($tu);
$oid = new OwnerInstanceDAO($db);
if (isset($i)) {
echo "Instance already exists.<br />";
$id->updatePassword($tu, $tp);
echo "Updated existing instance's password.<br />";
$oi = $oid->get($owner->id, $i->id);
if ($oi != null) {
echo "Owner already has this instance, no insert or update.<br />";
} else {
$oid->insert($owner->id, $i->id);
echo "Added owner instance.<br />";
}
} else {
echo "Instance does not exist.<br />";
$id->insert($twitter_id, $tu, $tp);
echo "Created instance with password.<br />";
$i = $id->getByUsername($tu);
$oid->insert($owner->id, $i->id);
echo "Created an owner_instance.<br />";
}
} else {
echo 'Twitter authentication failed.';
}
# clean up
$db->closeConnection($conn);
echo '<br /> <a href="' . $THINKTANK_CFG['site_root_path'] . 'account/">Back to your account</a>.';
$db = new Database($THINKTANK_CFG);
$conn = $db->getConnection();
$od = new OwnerDAO($db);
$owner = $od->getByEmail($_SESSION['user']);
if ($twitter_id > 0) {
echo "Twitter authentication successful.<br />";
$id = new InstanceDAO($db);
$i = $id->getByUsername($tu);
$oid = new OwnerInstanceDAO($db);
if (isset($i)) {
echo "Instance already exists.<br />";
$oi = $oid->get($owner->id, $i->id);
if ($oi != null) {
echo "Owner already has this instance, no insert or update.<br />";
} else {
$oid->insert($owner->id, $i->id, $tok['oauth_token'], $tok['oauth_token_secret']);
echo "Added owner instance.<br />";
}
} else {
echo "Instance does not exist.<br />";
$id->insert($twitter_id, $tu);
echo "Created instance.<br />";
$i = $id->getByUsername($tu);
$oid->insert($owner->id, $i->id, $tok['oauth_token'], $tok['oauth_token_secret']);
echo "Created an owner_instance.<br />";
}
}
# clean up
$db->closeConnection($conn);
}
echo '<br /> <a href="' . $THINKTANK_CFG['site_root_path'] . 'account/">Back to your account</a>.';