function insertTable($table, $tag)
{
global $conn, $goodtweets, $worsttweets;
if ($conn->connect_error) {
//Check connection
die("Connection failed: " . $conn->connect_error);
}
if (isset($_GET["is_fav"])) {
$is_fav = 1;
} else {
$is_fav = 0;
}
if ($res = $conn->query("SELECT count(*) as entry from hashtags WHERE `tag`='" . $tag . "' and user_id= " . $_SESSION['user_id'] . ";")) {
$row = $res->fetch_assoc();
if ($row["entry"] == '0') {
if (!$conn->query("INSERT INTO hashtags(tag,date_time,graph_values,user_id,is_fav) VALUES('" . $tag . "','" . date("Y-m-d H:i:s") . "','" . $table . "','" . $_SESSION["user_id"] . "','" . $is_fav . "');")) {
echo "Failed to insert";
} else {
if (($tid = getTagId($tag)) != -1) {
insertTweet($goodtweets, $worsttweets, $tid);
}
}
} else {
if (!$conn->query("UPDATE hashtags set date_time='" . date("Y-m-d H:i:s") . "',graph_values='" . $table . "' WHERE tag='" . $tag . "' and user_id= " . $_SESSION['user_id'] . ";")) {
echo "Failed to update";
} else {
if (($tid = getTagId($tag)) != -1) {
insertTweet($goodtweets, $worsttweets, $tid);
}
}
}
}
}
function checkTweets($newsitem)
{
$backtweet_api_key = "93cf9404dc4d8aebe92f";
$q = $newsitem["url"];
$newsitem_id = $newsitem["id"];
echo "querying: " . $q . "<br>";
$sinceString = "";
$since_result = mysql_query("SELECT * FROM backtweets_db WHERE newswire_id=" . $newsitem_id . " ORDER BY tweet_id DESC LIMIT 1");
if ($since_result) {
$since_row = mysql_fetch_assoc($since_result);
$since_id = $since_row["tweet_id"];
$sinceString .= "&since_id=" . $since_id;
}
echo "<br>since string: " . $sinceString . " since_id: " . $since_id . "<br>";
$jsonString = getData("http://backtweets.com/search.json?q=" . $q . "&key=" . $backtweet_api_key . "&itemsperpage=100" . $sinceString);
$tweetsObj = json_decode($jsonString);
//echo "status: ".$tweetsObj->status;
//echo $jsonString;.
echo "total results: " . $tweetsObj->totalresults . "<br>";
//$indexable = 1;
//if ($tweetsObj->totalresults < 1) {
// if ($newsitem["indexed"] > 2) {
//$indexable = 0;
// }
//}
//mysql_query( "UPDATE newswire_tb SET indexable=".$indexable.", indexed=indexed+1 WHERE id=".$newsitem["id"] );
for ($i = 0; $i < count($tweetsObj->tweets); $i++) {
// echo $tweetsObj->tweets[$i]->tweet_from_user ."<br>";
echo "<br>Tweet: since id : " . $sinceString . "<br>";
insertTweet($tweetsObj->tweets[$i], $newsitem["id"]);
echo "<br><br>";
}
}
$err = 'Whoa! Something weird just happened. Try again, I guess? (Debug ' . intval($_POST['submit']) . ')';
} elseif (bannedTweet($stat)) {
$err = 'Sorry, I just can\'t post that.';
}
if ($err == '') {
require_once 'includes/twitter.inc.php';
$tw = new Twitter('ub3rk1ttencom', 'oopsiesthisgotleaksied');
$rets = false;
$exc = false;
try {
$ret = $tw->updateStatus(stripslashes($stat));
$rets = $ret['id'];
} catch (TwitterException $ex) {
$err = 'Uh oh! Twitter appears to be having problems right now. Anything you say won\'t go on Twitter, sadly.';
$exc = true;
}
if ($exc) {
// Fail safe if Twitter down
insertTweet($stat, $rets);
} else {
if ($rets != '') {
// If Twitter rejects, we reject
insertTweet($stat, $rets);
}
}
}
if ($err == '') {
header('Location: index.php');
} else {
header('Location: index.php?&err=' . urlencode(base64_encode($err)));
}
