} 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"); } } }