SELECT userid, DateUpdated FROM userlogin WHERE (sessionid = '#LogoutSessID#') SELECT FormFieldData FROM formdata WHERE (meID = -1) AND (FormFieldID = #SelNicknameFieldID#) AND (UserID = #GetLoggedInCmsUser.userid#) AND (UserID = -2) SELECT id, name FROM chatuser WHERE name = '#ChatNickname#' DELETE FROM chatsession WHERE (userid = #GetChatUser.id#) UPDATE chatuser SET clientId = '', online = 0 WHERE (id = #GetChatUser.id#) DELETE FROM userlogin WHERE (sessionid = '#LogoutSessID#') SELECT UseHttpsOnAllPages FROM options_cms WHERE (MandantID = #CMS_MandantID#) SELECT * FROM menuentries WHERE (MenuEntriesID = '#meID#') AND (UseHTTPS = 1) ---> > SELECT MenuLabelsName FROM menulabels WHERE MenuEntriesID = #MeID# ---> ---> SELECT userid FROM userlogin WHERE sessionid = '#OldSessID#' SELECT loginid FROM userlogin WHERE sessionid = '#GeneratedSessionID#' SELECT Max(loginID) AS MaxID FROM userlogin INSERT INTO userlogin (loginid, userid, sessionid, DateUpdated) VALUES (#NewUserLoginID#, #GetOldSession.userid#, '#GeneratedSessionID#', #Now()#)