[HIDE]
[/HIDE]
SQL:
USE SRO_VT_SHARD
GO
-- Battle Arena Randoom
------------------------------------------------------------------------------------------------------------------------------------
DECLARE @MatchSaat int = '19' DECLARE @MatchDakika int = '15' -- Battle Arena Başlangıcından 15 dakika önceki saat ve Dakikayı gir.
DECLARE @KayıtSaat int = '19' DECLARE @KayıtDakika int = '20' -- Battle Arena Başlangıcından 10 dakika önceki saat ve Dakikayı gir.
DECLARE @StartSaat int = '19' DECLARE @StartDakika int = '25' -- Battle Arena Başlangıcından 5 dakika önceki saat ve Dakikayı gir.
------------------------------------------------------------------------------------------------------------------------------------
--*************|DOKUNMA|******************************|DOKUNMA|******************************|DOKUNMA|*******************************--
INSERT SRO_VT_SHARD.._Schedule (ScheduleDefineIdx,DateStart,DateEnd,MainInterval_Type,MainInterval_TypeDate,SubInterval_DayOfWeek,
SubInterval_Days,SubInterval_Weeks,SubInterval_Months,SubInterval_StartTimeHour,SubInterval_StartTimeMinute,SubInterval_StartTimeSecond,
SubInterval_DurationSecond,SubInterval_RepititionTerm,SubInterval_MaintainTime,Param,Description) values
(14,'2023-08-17 00:00:00.000','2030-08-17 00:00:00.000',1,1,0,0,0,0,@MatchSaat,@MatchDakika,0,1800,0,0,'','')
--*************|DOKUNMA|******************************|DOKUNMA|******************************|DOKUNMA|*******************************--
INSERT SRO_VT_SHARD.._Schedule (ScheduleDefineIdx,DateStart,DateEnd,MainInterval_Type,MainInterval_TypeDate,SubInterval_DayOfWeek,
SubInterval_Days,SubInterval_Weeks,SubInterval_Months,SubInterval_StartTimeHour,SubInterval_StartTimeMinute,SubInterval_StartTimeSecond,SubInterval_DurationSecond,SubInterval_RepititionTerm,SubInterval_MaintainTime,Param,Description) values
(16,'2023-08-17 00:00:00.000','2030-08-17 00:00:00.000',1,1,0,0,0,0,@KayıtSaat,@KayıtDakika,0,600,0,0,'','')
--*************|DOKUNMA|******************************|DOKUNMA|******************************|DOKUNMA|*******************************--
INSERT SRO_VT_SHARD.._Schedule (ScheduleDefineIdx,DateStart,DateEnd,MainInterval_Type,MainInterval_TypeDate,SubInterval_DayOfWeek,
SubInterval_Days,SubInterval_Weeks,SubInterval_Months,SubInterval_StartTimeHour,SubInterval_StartTimeMinute,SubInterval_StartTimeSecond,
SubInterval_DurationSecond,SubInterval_RepititionTerm,SubInterval_MaintainTime,Param,Description) values
(17,'2023-08-17 00:00:00.000','2030-08-17 00:00:00.000',1,1,0,0,0,0,@StartSaat,@StartDakika,0,900,0,0,'','')
--*************|DOKUNMA|******************************|DOKUNMA|******************************|DOKUNMA|*******************************--