function getHistory($criteria = array()) { $type = $criteria['type']; $start = $criteria['start']; $nb_display = $criteria['nb_display']; $u1 = new MySqlTable(); $sql = "SELECT * FROM " . $GLOBALS['db_table']['history'] . " WHERE 1"; if ($type != '') { $sql .= ' AND type="' . $u1->escape($type) . '"'; } $sql .= ' ORDER BY id DESC'; if ($nb_display > 0) { $sql .= ' LIMIT ' . $start . ', ' . $nb_display; } $result = $u1->customQuery($sql); return $result; }
<?php include '../include/webzone.php'; if (is_admin() && $GLOBALS['demo_mode'] != 1) { unset($_SESSION['ygp_fb_box']); $user_id = $_GET['id']; $type = 1; $users = getUsers(array('user_id' => $user_id, 'type' => $type)); if (count($users) > 0) { $u1 = new MySqlTable(); $sql = 'DELETE FROM ' . $GLOBALS['db_table']['users'] . ' WHERE user_id="' . $u1->escape($user_id) . '" AND type="' . $type . '"'; $u1->executeQuery($sql); } } header('Location: ../');
$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 { $message = $result->errors[0]->message; $message_id = ''; } //History update $u1 = new MySqlTable(); $sql = 'INSERT INTO ' . $GLOBALS['db_table']['history'] . ' (type, user_id, name, result, message_id, created) VALUES ("2", "' . $u1->escape($twt_user_id) . '", "' . $u1->escape($username) . '", "' . $u1->escape($message) . '", "' . $u1->escape($message_id) . '", "' . $created . '")'; $u1->executeQuery($sql); } } echo $nb_twt_updates . " Twitter updates"; } } else { echo 'Feature disabled in demo mode'; }
<?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: ../'); }