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