Auto] Billionaire System]

[CritYouDown]

Billionaire System :-

الـ System دا بيشوف اكتر واحد فى السيرفر معاه جولد و بيديلو Titlename
شوف اى Title عندك ملهاش لزمه و غير اسمها لـ Billionaire او اعمل انت Title جديده

==========================================
كيفية الاضافه للمبدئين

==========================================

1- غير "your Billionaire number" بـرقم الـ Title الـعندك


2- غير "Team Titlename number" بـارقام Title الـ GA , GM & Supporeter علشان مفيش حد من التيم ياخد الـ Title

3- مكان الاضافه SRO_VT_SHARD ==> Procedure ==> _AddLogChar ==> Right Click then Modify
وحط الـLines فى الاخر

الموضوع من جزئين :-
=============
-الجزء الاول : السيستم

-الجرء الثانى : Notice لما الـ Char الـمعاه الـ Title يفتح و يقفل

============================================

ألجزء الاول

============================================

--// ©JuStiCe

DECLARE @HwanLevel int = (Select HwanLevel From SRO_VT_SHARD.._Char Where CharID = @CharID)

DECLARE @JuStiCe varchar(64) = (Select Charname16 from SRO_VT_SHARD.._Char Where CharID = @CharID and HwanLevel = 'your Billionaire number')

If (@EventID = '9') Or (@EventID = '11')

Begin

If Exists (Select top 1 Charname16 from SH_OWOJuStiCe.._Char

Order by RemainGold DESC)

Begin

Update SH_OWOJuStiCe.dbo._Char Set HwanLevel = 'your Billionaire number' Where CharID = @CharID And HwanLevel not in (Team Titlename Number,Team Titlename Number,Team Titlename Number)

Update SH_OWOJuStiCe.dbo._Char Set HwanLevel = '0' Where HwanLevel = 'your Billionaire number' and not CharID = @CharID And HwanLevel not in (Team Titlename Number,Team Titlename Number,Team Titlename Number)

END

END

==============================================

الجزء الثانى :-
[لازم تكون بستخدم [PlusNotice]......

==============================================

--//If you want Notice When Login or Logoff Add These Lines


If (@EventID in (6,4)) And (@hwanlevel = 'your Billionaire number')

Begin

If (@EventID = '6')

Begin

SET @MSG = ' The Billionaire ===>' + @JuStiCe + ' <=== Has Logout '

End

Begin

INSERT INTO PlusNotice VALUES (0, @MSG, GETDATE())

UPDATE PlusNotice SET [Sent] = 1 WHERE [Date] < DATEADD(MINUTE, -5, GETDATE())

END

If (@EventID = '4')

Begin

SET @MSG = ' The Billionaire ===>' + @JuStiCe + ' <=== Has Logoin '

End

Begin

INSERT INTO PlusNotice VALUES (0, @MSG, GETDATE())

UPDATE PlusNotice SET [Sent] = 1 WHERE [Date] < DATEADD(MINUTE, -5, GETDATE())
ُEND
END

END