function getTweets($newsitem, $parentNode)
{
global $doc, $root, $minTweets;
$newsitem_id = $newsitem["id"];
$newsitem_time = strtotime($newsitem['createdTime']);
$result = mysql_query("SELECT * FROM backtweets_db WHERE newswire_id=" . $newsitem_id . " ORDER BY tweet_id ASC");
$totalTweets = mysql_num_rows($result);
if ($totalTweets >= $minTweets) {
appendAttribute($doc, $parentNode, 'total', $totalTweets);
while ($row = mysql_fetch_assoc($result)) {
$tweet = addTweet($row, $parentNode);
$tweetTime = strtotime($row['tweet_created_at']);
$hours = floor(($tweetTime - $newsitem_time) / (60 * 60));
$minutes = ($tweetTime - $newsitem_time) / 60 % 60;
appendAttribute($doc, $tweet, 'hourDiff', $hours);
appendAttribute($doc, $tweet, 'minDiff', $minutes);
}
}
return $totalTweets;
}
$root->appendChild($newsNode);
}
}
if ($limit > 0 && $totalNewsitems > $limit) {
break;
}
$id = $row['id'];
$totalTweets = 0;
$newsNode = $doc->createElement('news_item');
appendNewsNodeItems($newsNode, $row);
$tweetNode = $doc->createElement('tweets');
$newsNode->appendChild($tweetNode);
}
$newsitem_id = $row["id"];
$newsitem_time = strtotime($row['createdTime']);
$tweet = addTweet($row, $tweetNode);
$tweetTime = strtotime($row['tweet_created_at']);
$hours = floor(($tweetTime - $newsitem_time) / (60 * 60));
$minutes = ($tweetTime - $newsitem_time) / 60 % 60;
appendAttribute($doc, $tweet, 'hourDiff', $hours);
appendAttribute($doc, $tweet, 'minDiff', $minutes);
}
appendAttribute($doc, $root, 'totalNewsItems', strval($totalNewsitems));
echo $xml_string = $doc->saveXML();
function addTweet($tweetitem, $parentNode)
{
global $doc;
$entry = appendElement($doc, $parentNode, 'tweet');
$node = appendElement($doc, $entry, 'tweet_id');
appendTextNode($doc, $node, $tweetitem['tweet_id']);
$node = appendElement($doc, $entry, 'tweet_from_user_id');
/*
Changed addTweet to add Battle info to the database!
*/
function addTweet($Name, $Hit)
{
if (isset($Name)) {
$IP = "0.0.0.0";
$User = "******";
$con = mysqli_connect($IP, $User, "", "CelebrityDM");
$query = "insert into Battle(name, hit, time) values ('" . $Name . "', '" . $Hit . "','" . date("Y-m-d H:i:s") . "');";
if (mysqli_query($con, $query)) {
echo '<html><body><br><a><b>';
echo 'New record created!';
echo '</b></a></br></body></html>';
} else {
echo '<html><body><br><a><b>';
echo "Error: " . $query . "<br>" . mysqli_error($con);
echo '</b></a></br></body></html>';
}
mysqli_close($con);
} else {
echo '<html><body><br><a><b>';
echo 'No info in variable';
echo '</b></a></br></body></html>';
}
}
$Name = $_GET['Name'];
$Hit = $_GET['Hit'];
//startMiner();
addTweet($Name, $Hit);
//https://celebritydeathhash-arnolf.c9.io/AlexTestFolder/test.php?TweetText="Test insert with GET!"
