// Load all actions
$result = SQL_QUERY("SELECT
- `id`, `status`, `action`, `new_status`
+ `actions_id`,
+ `actions_status`,
+ `actions_action`,
+ `actions_new_status`
FROM
`{?_MYSQL_PREFIX?}_surfbar_actions`
ORDER BY
- `status` ASC,
- `action` ASC", __FILE__, __LINE__);
+ `actions_status` ASC,
+ `actions_action` ASC", __FILE__, __LINE__);
// Entries found?
if (SQL_NUMROWS($result) > 0) {
$OUT = ''; $SW = 2;
while ($content = SQL_FETCHARRAY($result)) {
// "Translate" some data
- $content['status'] = translateSurfbarUrlStatus($content['status']);
- $content['action'] = getMessage(sprintf("MEMBER_SURFBAR_ACTION_%s_SUBMIT", $content['action']));
+ $content['actions_action'] = getMessage(sprintf("MEMBER_SURFBAR_ACTION_%s_SUBMIT", $content['actions_action']));
// New status set?
- if (!is_null($content['new_status'])) {
+ if (!is_null($content['actions_new_status'])) {
// Translate it
- $content['new_status'] = translateSurfbarUrlStatus($content['new_status']);
+ $content['actions_new_status'] = translateSurfbarUrlStatus($content['actions_new_status']);
} else {
// "Do nothing" status
- $content['new_status'] = getMessage('SURFBAR_URL_STATUS_NONE');
+ $content['actions_new_status'] = getMessage('SURFBAR_URL_STATUS_NONE');
}
// Add color