} else {
error_log($hfb->lastError);
}
} catch (Exception $e) {
error_log($e);
}
}
}
}
$user_object = new usuario();
$db = new bd();
$time = time();
$day = date('D', $time);
$hour_min = date('H:i:00', strtotime('- 4 minutes', $time));
$hour_max = date('H:i:00', strtotime('+ 4 minutes', $time));
$table = "manager_messages_scheduled";
$condition = " days LIKE '%{$day}%' \n\t\tAND time_start<{$time} AND time_end>{$time} \n\t\tAND hour>'{$hour_min}' && hour<'{$hour_max}'";
$user_object = new usuario();
if ($res = $db->doFullSelect($table, $condition)) {
foreach ($res as $re) {
$message = new Handler_Message($re, false);
if ($message->canPublishTwitter()) {
handleTwitterMessage($message, $db, $user_object);
}
if ($message->canPublishFacebook()) {
handleFacebookMessage($message, $db, $user_object);
}
}
}
?>
}
}
}
}
}
$user_object = new usuario();
$db = new bd();
$usuarios = $user_object->listarUsuariosConPublicaciones(1);
foreach ($usuarios as $usuario) {
$uid = $usuario['id'];
$pubs = $usuario['publicaciones']->fetchAll();
$message = new Handler_Message($pubs[0]);
$query = "SELECT * FROM manager_messages_scheduled WHERE userid = {$uid}";
if ($res = $db->query($query)) {
$plus = $res->rowCount();
} else {
$plus = 0;
}
$upst = $usuario['total'] + $plus;
if ($upst > 0) {
if ($message->canPublishTwitter()) {
handleTwitterMessage($message, $uid, $db, $user_object, $upst);
}
if ($message->canPublishFacebook()) {
handleFacebookMessage($message, $uid, $db, $user_object, $upst, "fb");
}
if ($message->canPublishFacebookFanPage()) {
handleFacebookMessage($message, $uid, $db, $user_object, $upst, "fbp");
}
}
}
