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