$sql = 'INSERT INTO ' . $GLOBALS['db_table']['history'] . ' (type, user_id, name, result, message_id, created) VALUES
("1", "' . $u1->escape($fb_user_id) . '", "' . $u1->escape($name) . '", "' . $u1->escape($message) . '",
"' . $u1->escape($message_id) . '", "' . $created . '")';
$u1->executeQuery($sql);
}
echo $nb_fb_updates . " Facebook updates\n";
}
if ($twt_ids != '') {
$users = getUsers(array('type_id' => 2));
$tokensTab = array();
for ($i = 0; $i < count($users); $i++) {
$tokensTab[$users[$i]['user_id']]['token'] = $users[$i]['token'];
$tokensTab[$users[$i]['user_id']]['token_secret'] = $users[$i]['token_secret'];
$tokensTab[$users[$i]['user_id']]['username'] = $users[$i]['username'];
}
$t1 = new Twt_box();
$twt_idsTab = explode(',', $twt_ids);
$nb_twt_updates = 0;
for ($i = 0; $i < count($twt_idsTab); $i++) {
$twt_user_id = $twt_idsTab[$i];
$token = $tokensTab[$twt_user_id]['token'];
$token_secret = $tokensTab[$twt_user_id]['token_secret'];
$username = $tokensTab[$twt_user_id]['username'];
//update
if ($token != '' && $token_secret != '') {
$result = $t1->publishTweet(array('status' => $twt_status, 'token' => $token, 'token_secret' => $token_secret));
if ($result->id_str != '') {
$message = '';
$message_id = $result->id_str;
$nb_twt_updates++;
} else {
<?php
include_once '../include/webzone.php';
if (is_admin() && $GLOBALS['demo_mode'] != 1) {
$t1 = new Twt_box();
if ($t1->is_connected() === true) {
$user_data = $t1->getUserData();
if ($user_data['id_str'] != '') {
$type = 2;
//2=Twitter
$users = getUsers(array('user_id' => $user_data['id_str'], 'type' => $type));
if (count($users) == 0) {
$u1 = new MySqlTable();
$sql = "INSERT INTO " . $GLOBALS['db_table']['users'] . " (type, user_id, username, name, picture, token, token_secret, created) VALUES \n\t\t\t\t('" . $u1->escape($type) . "', '" . $u1->escape($user_data['id_str']) . "', '" . $u1->escape($user_data['screen_name']) . "', '" . $u1->escape($user_data['name']) . "', '" . $u1->escape($user_data['profile_image_url']) . "',\n\t\t\t\t'" . $u1->escape($user_data['token']) . "', '" . $u1->escape($user_data['token_secret']) . "', '" . date('Y-m-d H:i:s') . "')";
$u1->executeQuery($sql);
} else {
echo 'The account "<b>' . $user_data['screen_name'] . '</b>" is already connected<br>
To connect another Twitter account, please close your <a href="http://twitter.com" target="_blank">Twitter session</a> and try again.<br>';
echo '<a href="../">Back</a>';
exit;
}
}
header('Location: ../');
} else {
$t1->connect_process();
}
} else {
header('Location: ../');
}
