/**
* loop through twitter messages, put them to database and send them to qaul app
*/
function twitter_process_messages($data, $type)
{
foreach ($data as $item) {
// check if message already exists
$msg = MsgQuery::create()->filterByTwitterid($item->id_str)->findOne();
if (!$msg) {
// save message in data base
$msg = new Msg();
$msg->setType($type);
$msg->setName($item->user->screen_name);
$msg->setMsg($item->text);
$msg->setIp(get_qaul_setting('ip'));
$msg->setTime($item->created_at);
$msg->setStatus(0);
$msg->setTwitterid($item->id_str);
$msg->save();
// send message to qaul app
twitter_send2qaul($msg);
}
}
}
}
// put messages into data base and send them via qaul app
if (isset($data->errors)) {
echo "twitter error occured ... \n";
} else {
twitter_process_messages($data, $type);
}
// --------------------------------------------------
// search twitter for messages containing the
// configured search term.
// --------------------------------------------------
if (get_qaul_setting("twitter_search_term")) {
// check for last message entry.
// if there is a message not older than 60 minutes
$type = 22;
$last = MsgQuery::create()->filterByCreatedAt(array('min' => time() - 24 * 60 * 60))->filterByType($type)->orderByCreatedAt('desc')->findOne();
// request messages for hash tag from twitter library
// https://dev.twitter.com/docs/api/1.1/get/search/tweets
$twitter_url = 'https://api.twitter.com/1.1/search/tweets.json';
$twitter_requestMethod = 'GET';
$twitter_getfield = '?q=' . get_qaul_setting("twitter_search_term");
if ($last) {
$twitter_getfield .= '&since_id=' . $last->getTwitterid();
}
// search only from this language
if (get_qaul_setting("twitter_search_language")) {
$twitter_getfield .= '&lang=' . get_qaul_setting("twitter_search_language");
}
// restrict number of results
$twitter_getfield .= '&count=20';
if (get_debug()) {
* qaulhub_msg.php?id=123
*/
// include needed configuration & libraries
require_once '../qaulhub/config.php';
require_once '../qaulhub/helper_functions.php';
// check get variables
if (isset($_GET['id'])) {
$id = $_GET['id'];
} else {
$id = 0;
}
// pull messages from data base
if ($id) {
$msgs = MsgQuery::create()->filterById(array('min' => $id + 1))->orderById('asc')->limit(10)->find();
} else {
$msgs = MsgQuery::create()->orderById('desc')->limit(30)->find();
}
// send json to client
$first = true;
echo '{"name":"' . get_qaul_setting('name') . "\",\n";
echo "\"messages\":[\n";
foreach ($msgs as $msg) {
if ($first) {
$first = false;
} else {
echo ",\n";
}
echo "{";
/*
echo '"id":' .$msg->getId() .',';
echo '"type":' .$msg->getType() .',';
