summaryrefslogtreecommitdiff
path: root/demos/time-tracker/protected/App_Data
diff options
context:
space:
mode:
Diffstat (limited to 'demos/time-tracker/protected/App_Data')
-rw-r--r--demos/time-tracker/protected/App_Data/users.xml8
1 files changed, 5 insertions, 3 deletions
diff --git a/demos/time-tracker/protected/App_Data/users.xml b/demos/time-tracker/protected/App_Data/users.xml
index 78de588a..f4151c30 100644
--- a/demos/time-tracker/protected/App_Data/users.xml
+++ b/demos/time-tracker/protected/App_Data/users.xml
@@ -82,12 +82,14 @@
(#token#, #username#, NOW())
</insert>
-<select id="ValidateAutoSignon" resultClass="TimeTrackerUser">
+<select id="ValidateAutoSignon" resultMap="time-tracker-user">
SELECT
users.Username as Name,
- users.EmailAddress as EmailAddress
+ users.EmailAddress as EmailAddress,
+ user_roles.RoleType as role
FROM
- users, signon
+ users LEFT JOIN user_roles ON users.Username = user_roles.UserID,
+ signon
WHERE
users.Username = signon.Username
AND signon.SessionToken = #value#