addMenuDescription('admin', __FILE__);
// Start listing holiday requests
-$result = SQL_QUERY("SELECT h.id, h.userid, h.holiday_start, h.holiday_end, h.comments, d.status, d.last_online
-FROM `{?_MYSQL_PREFIX?}_user_holidays` AS h
-LEFT JOIN `{?_MYSQL_PREFIX?}_user_data` AS d
-ON h.userid=d.userid
-ORDER BY h.userid", __FILE__, __LINE__);
+$result = SQL_QUERY("SELECT
+ h.id, h.userid, h.holiday_start, h.holiday_end, h.comments, d.status, d.last_online
+FROM
+ `{?_MYSQL_PREFIX?}_user_holidays` AS h
+LEFT JOIN
+ `{?_MYSQL_PREFIX?}_user_data` AS d
+ON
+ h.userid=d.userid
+ORDER BY
+ h.userid ASC", __FILE__, __LINE__);
if (SQL_NUMROWS($result) > 0) {
// List all holiday requests
// Prepare data for the row template
$content = array(
- 'sw' => $SW,
- 'id' => $content['id'],
- 'userid' => generateUserProfileLink($content['userid']),
- 'start' => generateDateTime($content['holiday_start'], 3),
- 'end' => generateDateTime($content['holiday_end'], 3),
- 'comments' => wordwrap($content['comments'], 15),
- 'status' => translateUserStatus($content['status']),
- 'last_online' => generateDateTime($content['last_online'], 3),
+ 'sw' => $SW,
+ 'id' => $content['id'],
+ 'userid' => $content['userid'],
+ 'start' => generateDateTime($content['holiday_start'], 3),
+ 'end' => generateDateTime($content['holiday_end'], 3),
+ 'comments' => wordwrap($content['comments'], 15),
+ 'status' => $content['status'],
+ 'last_online' => generateDateTime($content['last_online'], 3),
);
// Load row template and switch color
$OUT .= loadTemplate('admin_list_holiday_row', true, $content);
$SW = 3 - $SW;
- }
+ } // END - while
// Free memory
SQL_FREERESULT($result);