select contenthistid, body from tcontent where body like update tcontent set body= where contenthistid='#contenthistid#' select contenthistid, summary from tcontent where summary like '%#arguments.find#%' update tcontent set summary= where contenthistid='#contenthistid#' delete from tcontent where siteid = select * from tcontent where siteid = and active = 1 insert into tcontent (Active,Approved,audience,Body,ContentHistID,ContentID,Credits,Display,DisplayStart,DisplayStop,featureStart,featureStop,FileID,Filename,forceSSL,inheritObjects,isFeature,IsLocked,IsNav,keyPoints,lastUpdate,lastUpdateBy,lastUpdateByID,MenuTitle,MetaDesc,MetaKeyWords,moduleAssign,ModuleID,nextN,Notes,OrderNo,ParentID,displayTitle,ReleaseDate,RemoteID,RemotePubDate,RemoteSource,RemoteSourceURL,RemoteURL,responseChart,responseDisplayFields,responseMessage,responseSendTo,Restricted,RestrictGroups,searchExclude,SiteID,sortBy,sortDirection,Summary,Target,TargetParams,Template,Title,Type,subType,Path,tags) values ( , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ) delete from tcontentobjects where siteid = select * from tcontentobjects where siteid = insert into tcontentobjects (ColumnID,ContentHistID,ContentID,Name,Object,ObjectID,OrderNo,SiteID) values ( , , , , , , , ) delete from tcontenttags where siteid = select * from tcontenttags where siteid = insert into tcontenttags (ContentHistID,ContentID,siteID,tag) values ( , , , ) delete from tsystemobjects where siteid = select * from tsystemobjects where siteid = insert into tsystemobjects (Name,Object,OrderNo,SiteID) values ( , , , ) delete from tpermissions where siteid = select * from tpermissions where siteid = insert into tpermissions (contentID,groupID,Type,SiteID) values ( , , , ) select advertiserUserPoolID from tsettings where siteid = delete from tadcampaigns where userID in (select userID from tusers where siteid = '#application.settingsManager.getSite(rsSettings.advertiserUserPoolID).getPrivateUserPoolID()#' or siteid = '#application.settingsManager.getSite(rsSettings.advertiserUserPoolID).getPublicUserPoolID()#') select * from tadcampaigns where userID in (select userID from tusers where siteid = '#application.settingsManager.getSite(rsSettings.advertiserUserPoolID).getPrivateUserPoolID()#' or siteid = '#application.settingsManager.getSite(rsSettings.advertiserUserPoolID).getPublicUserPoolID()#') insert into tadcampaigns (campaignID,dateCreated,endDate,isActive,lastUpdate,lastUpdateBy,name,notes,startDate,userID) values ( , , , , , , , , , ) delete from tadcreatives where userID in (select userID from tusers where siteid = '#application.settingsManager.getSite(rsSettings.advertiserUserPoolID).getPrivateUserPoolID()#' or siteid = '#application.settingsManager.getSite(rsSettings.advertiserUserPoolID).getPublicUserPoolID()#') select * from tadcreatives where userID in (select userID from tusers where siteid = '#application.settingsManager.getSite(rsSettings.advertiserUserPoolID).getPrivateUserPoolID()#' or siteid = '#application.settingsManager.getSite(rsSettings.advertiserUserPoolID).getPublicUserPoolID()#') insert into tadcreatives (altText,creativeID,creativeType,dateCreated,fileID,height,isActive,lastUpdate,lastUpdateBy,mediaType,name,notes,redirectURL,textBody,userID,width) values ( , , , , , , , , , , , , , , , ) delete from tadipwhitelist where siteid = select * from tadipwhitelist where siteid = insert into tadipwhitelist (IP,siteID) values ( , ) delete from tadzones where siteid = select * from tadzones where siteid = insert into tadzones (adZoneID,creativeType,dateCreated,height,isActive,lastUpdate,lastUpdateBy,name,notes,siteID,width) values ( , , , , , , , , , , ) delete from tadplacements where adzoneid in (select adzoneid from tadzones where siteid = ) select * from tadplacements where adzoneid in (select adzoneid from tadzones where siteid = ) insert into tadplacements (adZoneID,billable,budget,campaignID,costPerClick,costPerImp,creativeID,dateCreated,endDate,isActive,isExclusive,lastUpdate,lastUpdateBy,notes,placementID,startDate) values ( , , , , , , , , , , , , , , , ) delete from tadplacementdetails where placementid in (select placementid from tadplacements where adzoneid in (select adzoneid from tadzones where siteid = )) select * from tadplacementdetails where placementid in (select placementid from tadplacements where adzoneid in (select adzoneid from tadzones where siteid = )) insert into tadplacementdetails (placementID, placementType, placementValue) values ( , , ) delete from tcontentcategoryassign where siteid = select * from tcontentcategoryassign where siteid = insert into tcontentcategoryassign (categoryID,contentHistID,contentID,featureStart,featureStop,isFeature,orderno,siteID) values ( , , , , , , , ) delete from tcontentfeeds where siteid = select * from tcontentfeeds where siteid = insert into tcontentfeeds (allowHTML,channelLink,dateCreated,description,feedID,isActive,isDefault,isFeaturesOnly,isPublic,lang,lastUpdate,lastUpdateBy,maxItems,name,parentID,restricted,restrictGroups,siteID,Type,version,sortBy,sortDirection,nextN,displayName,displayRatings,displayComments) values ( , , , , , , , , , , , , , , , , , , , , , , , , , ) delete from tcontentfeeditems where feedID in (select feedID from tcontentfeeds where siteid = ) select * from tcontentfeeditems where feedID in (select feedID from tcontentfeeds where siteid = ) insert into tcontentfeeditems (feedID,itemID,type) values ( , , ) delete from tcontentfeedadvancedparams where feedID in (select feedID from tcontentfeeds where siteid = ) select * from tcontentfeedadvancedparams where feedID in (select feedID from tcontentfeeds where siteid = ) insert into tcontentfeedadvancedparams (paramID,feedID,param,relationship,field,dataType,`condition`condition,criteria) values ( , , , , , , , ) delete from tcontentrelated where siteid = select * from tcontentrelated where siteid = insert into tcontentrelated (contentHistID,contentID,relatedID,siteID) values ( , , , ) delete from tmailinglist where siteid = select * from tmailinglist where siteid = insert into tmailinglist (Description,isPublic,isPurge,LastUpdate,MLID,Name,SiteID) values ( , , , , , , ) delete from tfiles where siteid = select * from tfiles where siteid = insert into tfiles (contentID,contentSubType,contentType,fileExt,fileID,filename,fileSize,image,imageMedium,imageSmall,moduleID,siteID,created) values ( , , , , , , , , , , , , ) delete from tcontentcategories where siteid = select * from tcontentcategories where siteid = insert into tcontentcategories (categoryID,dateCreated,isActive,isInterestGroup,isOpen,lastUpdate,lastUpdateBy,name,notes,parentID,restrictGroups,siteID,sortBy,sortDirection,Path) values ( , , , , , , , , , , , , , , ) delete from tcontentcomments where commentid not in (select commentid from tcontent where siteid = ) select * from tcontentcomments where siteid = delete from tcontentcomments where siteid = insert into tcontentcomments (comments,commentid,contenthistid,contentid,email,entered,ip,isApproved,name,siteid,url) values ( , , , , , , , , , , ) delete from tcontentratings where contentid not in (select contentid from tcontent where siteid = ) select * from tcontentratings where siteid = delete from tcontentratings where siteid = insert into tcontentratings (contentID,rate,siteID,userID,entered) values ( , , , , ) delete from tusersinterests where categoryid not in (select categoryid from tcontentcategories where siteid = ) select * from tusersinterests where categoryid in (select categoryid from tcontentcategories where siteid = ) delete from tusersinterests where categoryid in (select categoryid from tcontentcategories where siteid = ) insert into tusersinterests (categoryID,userID) values ( , ) delete from tclassextenddata select * from tclassextenddata where siteid = and baseID in (select contenthistid from tcontent where siteid = ) insert into tclassextenddata (baseID,attributeID,attributeValue,siteID) values ( , , , ) update tsettings set lastDeployment = #now()# update tsettings set lastDeployment = #now()# update tglobals set appreload = #now()# select siteid, deploy from tsettings