select * from tplugins select * from tpluginsettings select tplugins.name,tpluginscripts.moduleID, tplugins.pluginID, tpluginscripts.runat, tpluginscripts.scriptfile, tcontent.siteID from tpluginscripts inner join tplugins on (tpluginscripts.moduleID=tplugins.moduleID) inner join tcontent on (tplugins.moduleID=tcontent.moduleID) where tpluginscripts.runat not in ('onGlobalLogin','onGlobalRequestStart','onApplicationLoad') and tplugins.deployed=1 select tplugins.name,tpluginscripts.moduleID, tplugins.pluginID, tpluginscripts.runat, tpluginscripts.scriptfile, '' siteID from tpluginscripts inner join tplugins on (tpluginscripts.moduleID=tplugins.moduleID) where tpluginscripts.runat in ('onGlobalLogin','onGlobalRequestStart','onApplicationLoad') and tplugins.deployed=1 select * from rsScripts1 union select * from rsScripts2 select tplugindisplayobjects.objectID, tplugindisplayobjects.moduleID, tplugindisplayobjects.name, tplugindisplayobjects.displayObjectfile, tplugins.pluginID, tcontent.siteID, tcontent.title,tplugindisplayobjects.location from tplugindisplayobjects inner join tplugins on (tplugindisplayobjects.moduleID=tplugins.moduleID) inner join tcontent on (tplugins.moduleID=tcontent.moduleID) select * from tplugins order by pluginID insert into tplugins (moduleID,name,provider,providerURL,version,deployed,category,created) values ( , , null, null, null, 0, null, #createODBCDateTime(now())# ) ` update tplugins set name=, provider=, providerURL=, version=, category=, created=#createODBCDateTime(now())# where moduleID= select * from variables.rsPlugins where pluginID=#arguments.ID# moduleID= select * from tplugins where pluginID=#arguments.ID# moduleID= select * from variables.rsSettings where moduleID= select siteID,moduleID from tcontent where moduleID= delete from tcontent where moduleID= insert into tpluginsettings (moduleID,name,settingValue) values ( , , ) insert into tcontent (siteID,moduleID,contentID,contentHistID,parentID,type,subType,title, display,approved,isNav,active,forceSSL,searchExclude) values ( , , , , , 'Plugin', 'Default', , 1, 1, 1, 1, 1, 1 ) update tplugindisplayobjects set location= where moduleID= select * from variables.rsDisplayObjects where moduleID= update tplugins set deployed=1 where moduleID= delete from tpluginsettings where moduleID= delete from tpluginscripts where moduleID= delete from tcontentobjects where objectID in (select objectID from tplugindisplayobjects where moduleID=) delete from tplugindisplayobjects where moduleID= select tplugins.pluginID,tplugins.moduleID,tplugins.name,tplugins.version, tplugins.provider, tplugins.providerURL,tplugins.category,tplugins.created from tplugins inner join tcontent on (tplugins.moduleID=tcontent.moduleID and tcontent.siteID=) delete from tplugins where moduleID= select pluginID, scriptfile,name from variables.rsScripts where runat= and siteID= order by pluginID select objectID, moduleID, siteID, name, title from variables.rsDisplayObjects where siteID= order by moduleID, title, name select pluginID, displayObjectFile,location from variables.rsDisplayObjects where objectID= group by pluginID, displayObjectFile, location