delimiter // drop procedure if exists sp_GetSiteSettings // CREATE DEFINER=`nativeadmin`@`localhost` PROCEDURE `sp_GetSiteSettings`() GetSiteSettings:BEGIN ########################################################### # # sp_GetSiteSettings stored procedure DECLARE vVersion FLOAT DEFAULT 0.007; # # To Do: # ########################################################### IF (NOT ISNULL(@vSettingsLoaded)) THEN LEAVE GetSiteSettings; END IF; DROP TABLE IF EXISTS tsettings; CREATE TEMPORARY TABLE tsettings (SettingName VARCHAR(255) NOT NULL PRIMARY KEY, SettingValue TEXT) DEFAULT CHARSET=UTF8; INSERT INTO tsettings SELECT SettingName,SettingValue FROM webnative.searchenginesettings WHERE SiteID=0; IF NOT(ISNULL(@vSiteID)) THEN REPLACE INTO tsettings SELECT SettingName,SettingValue FROM webnative.searchenginesettings WHERE SiteID=@vSiteID; END IF; BEGIN DECLARE vcDone BOOLEAN DEFAULT FALSE; DECLARE vSettingName VARCHAR(255) CHARSET UTF8; DECLARE vSettingValue TEXT CHARSET UTF8; DECLARE cSettings CURSOR FOR SELECT SettingName,SettingValue FROM tsettings; DECLARE CONTINUE HANDLER FOR NOT FOUND SET vcDone = TRUE; OPEN cSettings; REPEAT FETCH cSettings INTO vSettingName,vSettingValue; IF NOT vcDone THEN SET @qPrep=CONCAT_WS(_utf8"","SET @v",vSettingName,"=""",XINET_QUOTE(vSettingValue,0),""";"); PREPARE sPrep FROM @qPrep; EXECUTE sPrep; END IF; UNTIL vcDone END REPEAT; CLOSE cSettings; END; SET @vDebugMode=IFNULL(@vDebugMode,0); SET @vDebugLogDir=IFNULL(@vDebugLogDir,@@datadir); IF RIGHT(@vDebugLogDir,1) NOT IN ("/","\\") THEN SET @vDebugLogDir=CONCAT_WS(_utf8"",@vDebugLogDir,IF(LEFT(@@version_compile_os,3)="Win",0x5C5C,"/")); END IF; SET @vDefaultCollation="utf8_bin"; SET @vDisableNonMViewExplain=IFNULL(@vDisableNonMViewExplain,0); SET @vMaxFilterResults=IFNULL(@vMaxFilterResults,10000); SET @vNoLimitAfterDelay=IFNULL(@vNoLimitAfterDelay,0); SET @vBrowseResultsExpDelay=IFNULL(@vBrowseResultsExpDelay,0); SET @vSearchResultsExpDelay=IFNULL(@vSearchResultsExpDelay,0); SET @vKeepBrowseHistory=IFNULL(@vKeepBrowseHistory,0); SET @vKeepSearchHistory=IFNULL(@vKeepSearchHistory,0); SET @vMaxPathJoin=IFNULL(@vMaxPathJoin,500); SET @vMaxResults=IFNULL(@vMaxResults,2000); IF @vContentUsesXinetParser IS NULL THEN SELECT IFNULL(MAX(variable_value="ON"),0) INTO @vContentUsesXinetParser FROM information_schema.GLOBAL_VARIABLES WHERE variable_name="xinet_content_full_parser"; INSERT INTO webnative.searchenginesettings (SettingName,SettingValue,SiteID) VALUES ("ContentUsesXinetParser",@vContentUsesXinetParser,""); END IF; IF @vFTMinWordLen IS NULL THEN SELECT variable_value INTO @vFTMinWordLen FROM information_schema.GLOBAL_VARIABLES WHERE variable_name="ft_min_word_len"; INSERT INTO webnative.searchenginesettings (SettingName,SettingValue,SiteID) VALUES ("FTMinWordLen",@vFTMinWordLen,""); END IF; IF @vFTMaxWordLen IS NULL THEN SELECT variable_value INTO @vFTMaxWordLen FROM information_schema.GLOBAL_VARIABLES WHERE variable_name="ft_max_word_len"; INSERT INTO webnative.searchenginesettings (SettingName,SettingValue,SiteID) VALUES ("FTMaxWordLen",@vFTMaxWordLen,""); END IF; SET @vDefaultSearchAllFieldID=IFNULL(@vDefaultSearchAllFieldID,127); SET @vRunSubSearchIfMaxed=IFNULL(@vRunSubSearchIfMaxed,0); SET @vKeepDirsInSubSearches=IFNULL(@vKeepDirsInSubSearches,0); SET @vImageGroupTypeID=IFNULL(@vImageGroupTypeID,1); SET @vMaxResultTruncMethod=IFNULL(@vMaxResultTruncMethod,"KeepNewer"); SET @vNoSearchPathIDs=IFNULL(@vNoSearchPathIDs,""); SET @vMaxFilesInNavigator=IFNULL(@vMaxFilesInNavigator,100); SET @vMaxFoldersInNavigator=IFNULL(@vMaxFoldersInNavigator,500); SET @vIncludeSpotColorInSearchAll=IFNULL(@vIncludeSpotColorInSearchAll,0); SET @vQuickFiltersMaxKWItems=IFNULL(@vQuickFiltersMaxKWItems,5); SET @vQuickFiltersMaxFTItems=IFNULL(@vQuickFiltersMaxFTItems,10); SET @vQuickFiltersMaxKWTokenLen=IFNULL(@vQuickFiltersMaxKWTokenLen,64); SET @vVersionsFolder=IFNULL(@vVersionsFolder,"Versions"); SET @vMultiLevelLinkedFiles=IFNULL(@vMultiLevelLinkedFiles,1); SET @vChildATLocksParent=IFNULL(@vChildATLocksParent,0); SET @vFolderATLocksContent=IFNULL(@vFolderATLocksContent,0); SET @vSettingsLoaded=TRUE; DROP TEMPORARY TABLE tsettings; END GetSiteSettings// delimiter ;