Print 'Doing pre run Checks to ensure script not already run';
Select * from Script_History where Script_Name='FICOnReturnedStores18Dec2024';
if @@ROWCOUNT!=0
	BEGIN
		RAISERROR('THIS SCRIPT HAS ALREADY BEEN RUN ON THIS SERVER, CANNOT CONTINUE, PLEASE CONTACT DEV',11,1);
		RETURN;
	END
GO

declare @StoreId int;

set @StoreId = (select default_value from system_default where Default_Name = 'Main_store_id');

If(@StoreId in (2,3,6,7,8,9,17,24,25,26,27,35,38,41,43,50,54,62,67,68,69,70,75,76,82,86,90,93,96,100,101,106,110,111,118,121,122,124,126,127,129,131,135,142,146,149,150,155,156,157,158,162,164,165,173,174,182,183,186,188,192,199,219,225,227,243,245,246,251,252,262,268,276,284,312,314))
begin
update SystemSetting set SettingValueBit = 1 where SettingKey = 'FIC';

update systemsetting set settingvaluestring ='4h5j0ZNgwmU5nUx6hIKS4g==;QbnNkc7cvR0yol4fGh/S5g==' where settingkey = 'FICCredentials' and @StoreId=96;
update systemsetting set settingvaluestring ='zCIIaQALZua5zbLbVwg0Aw==;QbnNkc7cvR0yol4fGh/S5g==' where settingkey = 'FICCredentials' and @StoreId=243;
update systemsetting set settingvaluestring ='sZ/ZL1Oj\u002Bi0BCqBaogaBrw==;QbnNkc7cvR0yol4fGh/S5g==' where settingkey = 'FICCredentials' and @StoreId=2;
update systemsetting set settingvaluestring ='UE\u002BAKmBUaCJa0V1ZYK83Zg==;QbnNkc7cvR0yol4fGh/S5g==' where settingkey = 'FICCredentials' and @StoreId=76;
update systemsetting set settingvaluestring ='OOTKqFwq8qCo47j8t5a8WA==;QbnNkc7cvR0yol4fGh/S5g==' where settingkey = 'FICCredentials' and @StoreId=50;
update systemsetting set settingvaluestring ='uOTOZo0LH0f5fQ07jAcT6Q==;QbnNkc7cvR0yol4fGh/S5g==' where settingkey = 'FICCredentials' and @StoreId=90;
update systemsetting set settingvaluestring ='hM6zzoAp63nWcwrEg7TmeQ==;QbnNkc7cvR0yol4fGh/S5g==' where settingkey = 'FICCredentials' and @StoreId=6;
update systemsetting set settingvaluestring ='0a16IgZgk/luE8iUixfGcg==;QbnNkc7cvR0yol4fGh/S5g==' where settingkey = 'FICCredentials' and @StoreId=124;
update systemsetting set settingvaluestring ='I4m9jE5iW10NjMEbJqQcOA==;QbnNkc7cvR0yol4fGh/S5g==' where settingkey = 'FICCredentials' and @StoreId=100;
update systemsetting set settingvaluestring ='o1vfznrVAheTMU0QMPXvsA==;QbnNkc7cvR0yol4fGh/S5g==' where settingkey = 'FICCredentials' and @StoreId=101;
update systemsetting set settingvaluestring ='MUGcMAkxtYoDPBE5wbJ3og==;QbnNkc7cvR0yol4fGh/S5g==' where settingkey = 'FICCredentials' and @StoreId=199;
update systemsetting set settingvaluestring ='ppHFxVMcxrYpuJxfPL2Ifw==;QbnNkc7cvR0yol4fGh/S5g==' where settingkey = 'FICCredentials' and @StoreId=182;
update systemsetting set settingvaluestring ='9aMuj13Io9g6G\u002BZ3jiL5ow==;QbnNkc7cvR0yol4fGh/S5g==' where settingkey = 'FICCredentials' and @StoreId=26;
update systemsetting set settingvaluestring ='\u002BeGxn4V72adPf4PDeghayA==;QbnNkc7cvR0yol4fGh/S5g==' where settingkey = 'FICCredentials' and @StoreId=106;
update systemsetting set settingvaluestring ='YD3sfKSCUm6sPpU0m9Vlcg==;QbnNkc7cvR0yol4fGh/S5g==' where settingkey = 'FICCredentials' and @StoreId=162;
update systemsetting set settingvaluestring ='ClNIXvaWBMKBjv9NVm7cBA==;QbnNkc7cvR0yol4fGh/S5g==' where settingkey = 'FICCredentials' and @StoreId=24;
update systemsetting set settingvaluestring ='/pixwC7pYpofZ04FWfUlNw==;QbnNkc7cvR0yol4fGh/S5g==' where settingkey = 'FICCredentials' and @StoreId=110;
update systemsetting set settingvaluestring ='luHcULtpRmtTO\u002BWhfWnvJQ==;QbnNkc7cvR0yol4fGh/S5g==' where settingkey = 'FICCredentials' and @StoreId=111;
update systemsetting set settingvaluestring ='njNrGkR1Uq9xHun40sRkjQ==;QbnNkc7cvR0yol4fGh/S5g==' where settingkey = 'FICCredentials' and @StoreId=252;
update systemsetting set settingvaluestring ='qUD8JgZfyMCZsxBzutFhag==;QbnNkc7cvR0yol4fGh/S5g==' where settingkey = 'FICCredentials' and @StoreId=7;
update systemsetting set settingvaluestring ='sjM6bZ2l1E0tKbk\u002BSiReLg==;QbnNkc7cvR0yol4fGh/S5g==' where settingkey = 'FICCredentials' and @StoreId=192;
update systemsetting set settingvaluestring ='5ultx7EkvMcTb28cwUyXZw==;QbnNkc7cvR0yol4fGh/S5g==' where settingkey = 'FICCredentials' and @StoreId=245;
update systemsetting set settingvaluestring ='d3fqXipyGsn5KOqm\u002ByyFeQ==;QbnNkc7cvR0yol4fGh/S5g==' where settingkey = 'FICCredentials' and @StoreId=8;
update systemsetting set settingvaluestring ='JJZ/xb2\u002BvLufABxV3ZUHKw==;QbnNkc7cvR0yol4fGh/S5g==' where settingkey = 'FICCredentials' and @StoreId=35;
update systemsetting set settingvaluestring ='i1PmEKVR/4AAMg2e32D4IA==;QbnNkc7cvR0yol4fGh/S5g==' where settingkey = 'FICCredentials' and @StoreId=164;
update systemsetting set settingvaluestring ='35tJOOjguXEESFr71OunCQ==;QbnNkc7cvR0yol4fGh/S5g==' where settingkey = 'FICCredentials' and @StoreId=268;
update systemsetting set settingvaluestring ='XiB\u002BVI8PFdAvMQBVWjnLXA==;QbnNkc7cvR0yol4fGh/S5g==' where settingkey = 'FICCredentials' and @StoreId=165;
update systemsetting set settingvaluestring ='\u002B8CySAeBzsr8NbgGhqZwVg==;QbnNkc7cvR0yol4fGh/S5g==' where settingkey = 'FICCredentials' and @StoreId=118;
update systemsetting set settingvaluestring ='gX\u002BQ\u002BWSDgw6s0BFQc8HctA==;QbnNkc7cvR0yol4fGh/S5g==' where settingkey = 'FICCredentials' and @StoreId=156;
update systemsetting set settingvaluestring ='6\u002BLJtVQ0HZIxQkABKsmTRg==;QbnNkc7cvR0yol4fGh/S5g==' where settingkey = 'FICCredentials' and @StoreId=121;
update systemsetting set settingvaluestring ='8nNUNAxrseToMpmaS/qUVw==;QbnNkc7cvR0yol4fGh/S5g==' where settingkey = 'FICCredentials' and @StoreId=38;
update systemsetting set settingvaluestring ='jc/\u002BYBXgOJ6kpG8edpdjNw==;QbnNkc7cvR0yol4fGh/S5g==' where settingkey = 'FICCredentials' and @StoreId=86;
update systemsetting set settingvaluestring ='hw6gEJlxeOsVwXoWCPmOGQ==;QbnNkc7cvR0yol4fGh/S5g==' where settingkey = 'FICCredentials' and @StoreId=262;
update systemsetting set settingvaluestring ='/4esrXouhDWg5XSjLbWGlA==;QbnNkc7cvR0yol4fGh/S5g==' where settingkey = 'FICCredentials' and @StoreId=284;
update systemsetting set settingvaluestring ='GGpdvghTdcU2lz36IbJtTg==;QbnNkc7cvR0yol4fGh/S5g==' where settingkey = 'FICCredentials' and @StoreId=54;
update systemsetting set settingvaluestring ='n0vvAHu3h8w3p2omlad4og==;QbnNkc7cvR0yol4fGh/S5g==' where settingkey = 'FICCredentials' and @StoreId=122;
update systemsetting set settingvaluestring ='f0fkHUu/eXTtgUSd6pxRBmPyOjO5Bl6LW0RDIQ\u002Ba3ho=;QbnNkc7cvR0yol4fGh/S5g==' where settingkey = 'FICCredentials' and @StoreId=251;
update systemsetting set settingvaluestring ='t9APWU5KhsuGw5kBYMGXTO3PtlaJ2QXIr0hpWfhlims=;QbnNkc7cvR0yol4fGh/S5g==' where settingkey = 'FICCredentials' and @StoreId=129;
update systemsetting set settingvaluestring ='S23LB7d2HRueR9ed7HMzNje8N8B6Odj4dwkppOOwAuc=;QbnNkc7cvR0yol4fGh/S5g==' where settingkey = 'FICCredentials' and @StoreId=174;
update systemsetting set settingvaluestring ='smDSI2Dg2k36VaC\u002BSRka7w==;QbnNkc7cvR0yol4fGh/S5g==' where settingkey = 'FICCredentials' and @StoreId=312;
update systemsetting set settingvaluestring ='YJyld1fZ9VDH\u002BZBLKkxlVQ==;QbnNkc7cvR0yol4fGh/S5g==' where settingkey = 'FICCredentials' and @StoreId=126;
update systemsetting set settingvaluestring ='EJp93dE8SUvGyQJ2hqjHNA==;QbnNkc7cvR0yol4fGh/S5g==' where settingkey = 'FICCredentials' and @StoreId=127;
update systemsetting set settingvaluestring ='RSVcG2bvpUE8vXtVZvKcCQ==;QbnNkc7cvR0yol4fGh/S5g==' where settingkey = 'FICCredentials' and @StoreId=186;
update systemsetting set settingvaluestring ='LYkkgbq6KEC0/S1DthoSzpRwqZVFindIuaE2rU0Aqyo=;QbnNkc7cvR0yol4fGh/S5g==' where settingkey = 'FICCredentials' and @StoreId=41;
update systemsetting set settingvaluestring ='BzUY4/77qNTquro2cXsEhg==;QbnNkc7cvR0yol4fGh/S5g==' where settingkey = 'FICCredentials' and @StoreId=227;
update systemsetting set settingvaluestring ='D/AlMZQvK5FBVZCpENslqKJ4Q76TaCJw05mIPQSIq/c=;QbnNkc7cvR0yol4fGh/S5g==' where settingkey = 'FICCredentials' and @StoreId=43;
update systemsetting set settingvaluestring ='XBZIYgMxADzXJ5PX4B/OMw==;QbnNkc7cvR0yol4fGh/S5g==' where settingkey = 'FICCredentials' and @StoreId=67;
update systemsetting set settingvaluestring ='L6BlVIUFjHFPwZMSJNw1SRgH2WkSeoNPPWQzTjmQNiw=;QbnNkc7cvR0yol4fGh/S5g==' where settingkey = 'FICCredentials' and @StoreId=246;
update systemsetting set settingvaluestring ='df2J8fMH69ZuJ\u002BbJ4BMeMA==;QbnNkc7cvR0yol4fGh/S5g==' where settingkey = 'FICCredentials' and @StoreId=131;
update systemsetting set settingvaluestring ='W\u002B9RxgYu8IEfQf0qKEzl\u002BA==;QbnNkc7cvR0yol4fGh/S5g==' where settingkey = 'FICCredentials' and @StoreId=69;
update systemsetting set settingvaluestring ='D7EC5ZTW2wU83qkmvQZTuA==;QbnNkc7cvR0yol4fGh/S5g==' where settingkey = 'FICCredentials' and @StoreId=276;
update systemsetting set settingvaluestring ='iXxSVI5D2lc4D414I/Jj2w==;QbnNkc7cvR0yol4fGh/S5g==' where settingkey = 'FICCredentials' and @StoreId=135;
update systemsetting set settingvaluestring ='cnhqMZwH0vh74ouA4rsBqw==;QbnNkc7cvR0yol4fGh/S5g==' where settingkey = 'FICCredentials' and @StoreId=25;
update systemsetting set settingvaluestring ='I2yAFbsu2Mfp8tuVh8r/jQ==;QbnNkc7cvR0yol4fGh/S5g==' where settingkey = 'FICCredentials' and @StoreId=3;
update systemsetting set settingvaluestring ='F86n\u002BwgObS1PxeGfp2BMGg==;QbnNkc7cvR0yol4fGh/S5g==' where settingkey = 'FICCredentials' and @StoreId=183;
update systemsetting set settingvaluestring ='fxtoKz4EVKjBItBVJhWOaw==;QbnNkc7cvR0yol4fGh/S5g==' where settingkey = 'FICCredentials' and @StoreId=219;
update systemsetting set settingvaluestring ='rE9mrCGs0V/a\u002BEixlKkHSg==;QbnNkc7cvR0yol4fGh/S5g==' where settingkey = 'FICCredentials' and @StoreId=142;
update systemsetting set settingvaluestring ='gdEv130oL/r2e8vaWiUpWA==;QbnNkc7cvR0yol4fGh/S5g==' where settingkey = 'FICCredentials' and @StoreId=173;
update systemsetting set settingvaluestring ='5wzDoJANKOqoCEF8cl4kYw==;QbnNkc7cvR0yol4fGh/S5g==' where settingkey = 'FICCredentials' and @StoreId=9;
update systemsetting set settingvaluestring ='unxVyQI0j1wouOWneFRzcA==;QbnNkc7cvR0yol4fGh/S5g==' where settingkey = 'FICCredentials' and @StoreId=17;
update systemsetting set settingvaluestring ='0zJkmhpG/A51G7xbXDknBw==;QbnNkc7cvR0yol4fGh/S5g==' where settingkey = 'FICCredentials' and @StoreId=146;
update systemsetting set settingvaluestring ='MFBt1ed4fogwZWfGwjGPYQ==;QbnNkc7cvR0yol4fGh/S5g==' where settingkey = 'FICCredentials' and @StoreId=82;
update systemsetting set settingvaluestring ='Yrm1ifmFjmzYey6H/PJ3LA==;QbnNkc7cvR0yol4fGh/S5g==' where settingkey = 'FICCredentials' and @StoreId=149;
update systemsetting set settingvaluestring ='RDjMFlLLumwWFwzESw1ylw==;QbnNkc7cvR0yol4fGh/S5g==' where settingkey = 'FICCredentials' and @StoreId=150;
update systemsetting set settingvaluestring ='zlKnvnYBgCZhAU/4w0v3ng==;QbnNkc7cvR0yol4fGh/S5g==' where settingkey = 'FICCredentials' and @StoreId=62;
update systemsetting set settingvaluestring ='umZuOUsFghOZzFdXY/bTWw==;QbnNkc7cvR0yol4fGh/S5g==' where settingkey = 'FICCredentials' and @StoreId=68;
update systemsetting set settingvaluestring ='/5F9w/57k9k/ZZRuU5j6DQ==;QbnNkc7cvR0yol4fGh/S5g==' where settingkey = 'FICCredentials' and @StoreId=314;
update systemsetting set settingvaluestring ='bfjXMmPEoRna5blYcCP2Sg==;QbnNkc7cvR0yol4fGh/S5g==' where settingkey = 'FICCredentials' and @StoreId=27;
update systemsetting set settingvaluestring ='b48VZVmCtQmLMEYsodHUDQ==;QbnNkc7cvR0yol4fGh/S5g==' where settingkey = 'FICCredentials' and @StoreId=155;
update systemsetting set settingvaluestring ='\u002BvYDka5LaG4tFwgR7oCgGQ==;QbnNkc7cvR0yol4fGh/S5g==' where settingkey = 'FICCredentials' and @StoreId=225;
update systemsetting set settingvaluestring ='hclZu/uNi7hZGZu\u002BH6hoEQ==;QbnNkc7cvR0yol4fGh/S5g==' where settingkey = 'FICCredentials' and @StoreId=93;
update systemsetting set settingvaluestring ='u4Jj9/RT2IBe82NsUtkpJw==;QbnNkc7cvR0yol4fGh/S5g==' where settingkey = 'FICCredentials' and @StoreId=70;
update systemsetting set settingvaluestring ='qUelcXhIZF9EdWIZ6zYvpA==;QbnNkc7cvR0yol4fGh/S5g==' where settingkey = 'FICCredentials' and @StoreId=188;
update systemsetting set settingvaluestring ='kA356CB5T1NsfSciYF9rew==;QbnNkc7cvR0yol4fGh/S5g==' where settingkey = 'FICCredentials' and @StoreId=157;
update systemsetting set settingvaluestring ='erz85zbNjNvTcFfBukgQ9w==;QbnNkc7cvR0yol4fGh/S5g==' where settingkey = 'FICCredentials' and @StoreId=158;
update systemsetting set settingvaluestring ='d4R/q4YbKSmlLrqOWcgJOg==;QbnNkc7cvR0yol4fGh/S5g==' where settingkey = 'FICCredentials' and @StoreId=75;


end

Print 'Insert into script history if everything else is cool';
	Insert into Script_History (RunDate,Script_Name) Values (CURRENT_TIMESTAMP,'FICOnReturnedStores18Dec2024');
	IF @@ERROR != 0
		BEGIN
			RAISERROR ('UNABLE TO CONTINUE WITH SCRIPT', 11, 1);
			RETURN;
		END
GO