function buildActions() { global $EVENTS, $GROUPS, $INTERNAL, $RESPONSE; $RESPONSE->Actions = ""; if ($result = queryDB(true, "SELECT `trigger_id`,`action_id` FROM `" . DB_PREFIX . DATABASE_EVENT_ACTION_INTERNALS . "` INNER JOIN `" . DB_PREFIX . DATABASE_EVENT_TRIGGERS . "` ON `" . DB_PREFIX . DATABASE_EVENT_ACTION_INTERNALS . "`.`trigger_id`=`" . DB_PREFIX . DATABASE_EVENT_TRIGGERS . "`.`id` WHERE `" . DB_PREFIX . DATABASE_EVENT_ACTION_INTERNALS . "`.`receiver_user_id` = '" . @mysql_real_escape_string(CALLER_SYSTEM_ID) . "' GROUP BY `action_id` ORDER BY `" . DB_PREFIX . DATABASE_EVENT_ACTION_INTERNALS . "`.`created` ASC")) { while ($row = mysql_fetch_array($result, MYSQL_BOTH)) { $internalaction = new EventActionInternal($row); $RESPONSE->Actions .= $internalaction->GetXML(); } } queryDB(true, "DELETE FROM `" . DB_PREFIX . DATABASE_EVENT_ACTION_INTERNALS . "` WHERE `" . DB_PREFIX . DATABASE_EVENT_ACTION_INTERNALS . "`.`receiver_user_id` = '" . @mysql_real_escape_string(CALLER_SYSTEM_ID) . "';"); }
function buildActions() { Server::$Response->Actions = ""; if (count(Server::$Events->Events) > 0) { if ($result = DBManager::Execute(true, "SELECT `trigger_id`,`action_id` FROM `" . DB_PREFIX . DATABASE_EVENT_ACTION_INTERNALS . "` INNER JOIN `" . DB_PREFIX . DATABASE_EVENT_TRIGGERS . "` ON `" . DB_PREFIX . DATABASE_EVENT_ACTION_INTERNALS . "`.`trigger_id`=`" . DB_PREFIX . DATABASE_EVENT_TRIGGERS . "`.`id` WHERE `" . DB_PREFIX . DATABASE_EVENT_ACTION_INTERNALS . "`.`receiver_user_id` = '" . DBManager::RealEscape(CALLER_SYSTEM_ID) . "' GROUP BY `action_id` ORDER BY `" . DB_PREFIX . DATABASE_EVENT_ACTION_INTERNALS . "`.`created` ASC")) { while ($row = DBManager::FetchArray($result)) { $internalaction = new EventActionInternal($row); Server::$Response->Actions .= $internalaction->GetXML(); } } DBManager::Execute(true, "DELETE FROM `" . DB_PREFIX . DATABASE_EVENT_ACTION_INTERNALS . "` WHERE `" . DB_PREFIX . DATABASE_EVENT_ACTION_INTERNALS . "`.`receiver_user_id` = '" . DBManager::RealEscape(CALLER_SYSTEM_ID) . "';"); } }