SELECT tusers.UserID from tusers WHERE perm=1 and type=1 and siteid='#variables.instance.settingsManager.getSite(arguments.crumbdata[1].siteid).getPrivateUserPoolID()#' and groupname='Admin' SELECT tusers.UserID, tusers.Fname, tusers.Lname, tusers.Email, tusersmemb.GroupID, 'Editor' AS Type FROM tusers INNER JOIN tusersmemb ON tusers.UserID = tusersmemb.UserID WHERE tusers.Email Is Not Null AND (tusersmemb.GroupID In (,) or tusers.s2=1) union SELECT tusers.UserID, tusers.Fname, tusers.Lname, tusers.Email, tusersmemb.GroupID, 'Author' AS Type FROM tusers INNER JOIN tusersmemb ON tusers.UserID = tusersmemb.UserID WHERE tusers.Email Is Not Null and siteid='#variables.instance.settingsManager.getSite(arguments.crumbdata[1].siteid).getPrivateUserPoolID()#' AND tusersmemb.GroupID In (,) select * from rsprenotify order by lname, fname Select mlid, name from tmailinglist where siteid= and isPublic=1 order by name select groupname, userid,isPublic from tusers where type=1 and ( (isPublic=1 and siteid='#variables.instance.settingsManager.getSite(arguments.siteid).getPublicUserPoolID()#') or (isPublic=0 and siteid='#variables.instance.settingsManager.getSite(arguments.siteid).getPrivateUserPoolID()#') ) and groupname != 'Admin' order by isPublic desc, groupname Select contentid from tcontent where siteid= and filename = and active=1 and type in ('Portal','Page','Calendar','Gallery') select contentid, filename from tcontent where siteid= and filename like and active=1 and type in ('Page','Calendar','Portal','Gallery') select filename from tcontent where siteid= and contentid= and active=1 and type in ('Page','Calendar','Portal','Gallery') update tcontent set filename=replace(filename,,) where siteid= and filename like and active=1 and type in ('Page','Calendar','Portal','Gallery','Link') update tcontent set filename= where siteid= and filename = and active=1 and type in ('Page','Calendar','Portal','Gallery','Link') select contenthistid, body from tcontent where type in ('Page','Calendar','Portal','Component','Form','Gallery') and body like and siteid= update tcontent set body= where contenthistid= select contenthistid, summary from tcontent where type in ('Page','Calendar','Portal','Component','Form','Gallery') and summary like and siteid= update tcontent set summary= where contenthistid= select userID, email, fname, lname from tusers where userid in ( , ) insert into tredirects (redirectID,URL,created) values( , , #createODBCDateTime(now())# ) select email, fname, lname from tusers where userid= #arguments.data.message# Review Link: http://#cgi.SERVER_NAME##variables.instance.configBean.getServerPort()##variables.instance.configBean.getContext()##variables.instance.contentRenderer.getURLStem(arguments.contentBean.getSiteID(),redirectID)# #arguments.data.message# Review Link: http://#cgi.SERVER_NAME##variables.instance.configBean.getServerPort()##variables.instance.configBean.getContext()##variables.instance.contentRenderer.getURLStem(arguments.contentBean.getSiteID(),redirectID)# insert into tcontentpublicsubmissionapprovals (contentid,isApproved,email,siteid) values( , 0, , ) select * from tcontentpublicsubmissionapprovals where contentid= and isApproved=0 #publicSubmissionApprovalScript# Your content item has been posted on #variables.instance.settingsManager.getSite(arguments.contentBean.getSiteID()).getSite()# website. You can view the posting at: #returnURL# If you have any questions or comments about the news on #variables.instance.settingsManager.getSite(arguments.contentBean.getSiteID()).getSite()#, please contact us at #variables.instance.settingsManager.getSite(arguments.contentBean.getSiteID()).getContactPhone()# or email us at #variables.instance.settingsManager.getSite(arguments.contentBean.getSiteID()).getContactEmail()# Sincerely, #variables.instance.settingsManager.getSite(arguments.contentBean.getSiteID()).getSite()# update tcontentpublicsubmissionapprovals set isApproved=1 where contentid= and isApproved=0 insert into tcontentcategoryassign (contentHistID, categoryID, contentID, isFeature, orderno, siteID, featurestart,featurestop) select '#newContentHistID#',categoryID,'#newContentID#',isFeature,orderno,siteid,featurestart,featurestop from tcontentcategoryassign where siteid='#arguments.siteid#' and contentID='#arguments.contentID#' and contentHistID='#contentHistID#' insert into tcontentrelated (contentHistID,relatedID, contentID, siteID) select '#newContentHistID#',relatedID,'#newContentID#',siteID from tcontentrelated where siteid='#arguments.siteid#' and contentID='#arguments.contentID#' and contentHistID='#contentHistID#' insert into tcontentobjects (contentHistID, objectID, object, contentID, name, orderno, siteid, columnid) select '#newContentHistID#',objectid, object, '#newContentID#',name,orderno,siteid,columnid from tcontentobjects where siteid='#arguments.siteid#' and contentID='#arguments.contentID#' and contentHistID='#contentHistID#' insert into tpermissions (contentID, groupID, siteID, type) select '#newContentID#', groupID, siteid,type from tpermissions where siteid='#arguments.siteid#' and contentID='#arguments.contentID#' insert into tclassextenddata (baseID,attributeID,siteID,attributeValue) select '#newContentHistID#',attributeID,siteID,attributeValue from tclassextenddata where baseid='#contentHistID#' select contentID from tcontent where siteid= and parentID= and active=1 update tcontent set path= where siteid= and contentID= update tcontent set filename=replace(filename,,) where siteid= and filename like and active=1 and type in ('Page','Calendar','Portal','Gallery','Link') select contenthistid, body from tcontent where body like and siteID = and type in ('Page','Calendar','Portal','Gallery','Link') update tcontent set body = where contenthistid = select contenthistid, summary from tcontent where summary like and siteID = and type in ('Page','Calendar','Portal','Gallery','Link') update tcontent set summary = where contenthistid =