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!"