-LIMIT 1", array(getUserId()), __FILE__, __LINE__);
- if (SQL_NUMROWS($result) == 1) {
- // Data was found
- $content = merge_array($content, SQL_FETCHARRAY($result));
- SQL_FREERESULT($result);
-
- // Prepare it for the template
- define('__HOLIDAY_START', generateDateTime($content['holiday_start'], '3'));
- define('__HOLIDAY_END' , generateDateTime($content['holiday_end'] , '3'));
-
- // Deactivate it now
- SQL_QUERY_ESC("UPDATE `{!_MYSQL_PREFIX!}_user_data`
+LIMIT 1", array(getMemberId()), __FILE__, __LINE__);
+ if (SQL_NUMROWS($result2) == 1) {
+ // Data was found so merge it
+ $content = merge_array($content, SQL_FETCHARRAY($result2));
+
+ // Prepare it for the template
+ $content['start'] = generateDateTime($content['holiday_start'], 3);
+ $content['end'] = generateDateTime($content['holiday_end'] , 3);
+
+ // Deactivate it now
+ SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_user_data`