select * from tusers where userid= select * from tusers where username= and (siteid='#application.settingsManager.getSite(arguments.siteID).getPublicUserPoolID()#' or siteid='#application.settingsManager.getSite(arguments.siteID).getPrivateUserPoolID()#' ) select * from tusers where remoteid= and (siteid='#application.settingsManager.getSite(arguments.siteID).getPublicUserPoolID()#' or siteid='#application.settingsManager.getSite(arguments.siteID).getPrivateUserPoolID()#' ) INSERT INTO tusers (UserID, RemoteID, s2, Fname, Lname, Password, PasswordCreated, Email, GroupName, Type, subType, ContactForm, LastUpdate, lastupdateby, lastupdatebyid,InActive, username, perm, isPublic, company,jobtitle,subscribe,siteid,website,notes,mobilePhone, description,interests,photoFileID,keepPrivate,IMName,IMService,created,tags) VALUES( '#arguments.userBean.getuserid()#', , #arguments.userBean.gets2()#, , , , #createODBCDateTime(now())#, , , #arguments.userBean.getType()#, , , #createodbcdatetime(now())#, , , #arguments.userBean.getInActive()#, , #arguments.userBean.getperm()#, #arguments.userBean.getispublic()#, , , #arguments.userBean.getsubscribe()#, , , , , , , , #arguments.userBean.getKeepPrivate()#, , , #createODBCDAteTime(now())#, ) DELETE FROM tusers where userid= DELETE FROM tusersfavorites where userID= DELETE FROM tcontentratings where userID= UPDATE tusers SET RemoteID = , Fname = , Lname = , GroupName = , Email = , Password = , passwordCreated =#createODBCDateTime(now())#, s2 =#arguments.userBean.gets2()#, Type = #arguments.userBean.getType()#, subType = , ContactForm = , LastUpdate = #createodbcdatetime(now())#, LastUpdateBy = , LastUpdateByID = , InActive = #arguments.userBean.getInActive()#, username = , isPublic = #arguments.userBean.getispublic()#, company = , jobtitle = , website = , notes = , subscribe=#arguments.userBean.getsubscribe()#, siteid = '#trim(arguments.userBean.getSiteID())#', MobilePhone = , Description = , Interests = , PhotoFileID = , keepPrivate = #arguments.userBean.getKeepPrivate()#, IMName = , IMService = , Tags = WHERE UserID = '#arguments.userBean.getUserID()#' DELETE FROM tusersmemb where UserID= and groupID in (select userID from tusers where siteid= ) DELETE FROM tusersmemb where groupID= DELETE FROM tpermissions where groupID= delete from tusersmemb where userid= and groupid= select * from tusersmemb where groupid= and userid= INSERT INTO tusersmemb (UserID, GroupID) VALUES( , ) DELETE FROM tusersinterests where UserID='#arguments.UserId#' and categoryID in (select categoryID from tcontentcategories where siteid='#arguments.originID#') INSERT INTO tusersinterests (UserID, categoryID) VALUES( , ) Select * from tusersmemb where userid= Select * from tusers, tusersmemb where tusers.userid=tusersmemb.userid and tusersmemb.groupid= and tusers.s2 =0 order by lname SELECT categoryID from tusersinterests where userid= UPDATE tusers SET password = , passwordCreated =#createODBCDateTime(now())# WHERE UserID = SELECT userID,password as userHash,siteID,isPublic from tusers WHERE UserID = select * from tuseraddresses where addressid= UPDATE tuseraddresses SET phone = , address1 = , address2 = , city = , state = , zip = , fax = , addressNotes = , siteid = '#trim(arguments.addressBean.getSiteID())#', UserID = , addressName= , country= , addressURL=, longitude = #arguments.addressBean.getLongitude()#, latitude = #arguments.addressBean.getLatitude()#, addressEmail=, hours = WHERE AddressID = INSERT INTO tuseraddresses (AddressID,UserID,siteID, phone,fax,address1, address2, city, state, zip , addressName,country,isPrimary,addressNotes,addressURL, longitude,latitude,addressEmail,hours) VALUES( '#arguments.addressBean.getAddressid()#', '#arguments.addressBean.getuserid()#', , , , , , , , , , , #arguments.addressBean.getIsPrimary()#, , , #arguments.addressBean.getLongitude()#, #arguments.addressBean.getLatitude()#, , ) DELETE FROM tuseraddresses where addressID= DELETE FROM tcontentratings where contentID= DELETE FROM tcontentratings where contentID in (select addressID from tuseraddresses where userID=) DELETE FROM tuseraddresses where userID= UPDATE tuseraddresses set isPrimary=0 where userID= UPDATE tuseraddresses set isPrimary=1 where addressID= select * from tuseraddresses where userID= order by isPrimary desc delete from tusersmemb where userID= and groupID not in (select userID from tusers where siteid= and type=1 and isPublic=1 ) insert into tuserstags (userid,siteid,tag) values( , , ) delete from tuserstags where userid=