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

[Hamza FiGo]

تمت الموافقة

بس ياريت يكون الشرح بالعربي. احنا منتدي عربي ^^ . شكرا علي الموضوع

[Dev. iLegend]

there are many wrongs in the first query , the main wrong is
you ignore the last hwan level of the old Billionaire character and in the second query in
case IF @EventID 9 or 11 when you update dbo._Char you already update the old character that had the title name to hwan level 0
this ignoring the title which he had it before he gain the billionaire title

for example
i did the Count quest and my hawn level is now 4
and i got a higher gold inside dbo._Char

by the way this section is wrong
If Exists (Select top 1 Charname16 from SH_OWOJuStiCe.._Char

Order by RemainGold DESC)so i get automatic hwan level of billionaire
good , when other player get a higher gold than me so automatic title will transfer to him , and my title will be non means hwan level not 4 as i was nah it will be zero

[CritYouDown]

there are many wrongs in first query , the main wrong is
you ignore the last hwan level of the old Billionaire character and in the second query in
case IF @EventID 9 or 11 when you update dbo._Char you already update the old character that had the title name to hwan level 0
this ignoring the title which he had it before he gain the billionaire title

for example
i did the Count quest and my hawn level is now 4
and i got a higher gold inside dbo._Char

by the way this section is wrong
If Exists (Select top 1 Charname16 from SH_OWOJuStiCe.._Char

Order by RemainGold DESC)so i get automatic hwan level of billionaire
good , when other player get a higher gold than me so automatic title will transfer to him , and my title will be non means hwan level not 4 as i was nah it will be zero


You Alright 100% :thumbup:
but i cannot release my full Procs
http://s18.postimg.org/a20277gc9/Untitlesd.jpg

btw
this system may work fine in PVP Servers
after small edits in hwanlevel when removing Billionaire title

[Yousef Ayyoub]

as a matter of fact could you please translate the topic to arabic .. due to ur low level in english eloquence (no offence) ,. the reason am saying so is than i didnot understand 1 word from the topic and either ways non-english speakers .. which is 90% of the forum will understand nothing !! ..


:111 (15)::111 (15):

[CritYouDown]

as a matter of fact could you please translate the topic to arabic .. due to ur low level in english eloquence (no offence) ,. the reason am saying so is than i didnot understand 1 word from the topic and either ways non-english speakers .. which is 90% of the forum will understand nothing !! ..


:111 (15)::111 (15):

Reason you don't understand 1 word from the topic ,because you may still beginner in SQL not of my english

Second, when you ask for something, there are a respectable way for a question :wink3:

[CritYouDown]

تمت الموافقة

بس ياريت يكون الشرح بالعربي. احنا منتدي عربي ^^ . شكرا علي الموضوع

Done :biggrin:

[Yousef Ayyoub]

Reason you don't understand 1 word from the topic ,because you may still beginner in SQL not of my english

Second, when you ask for something, there are a respectable way for a question :wink3:

am sorry if you do get me wrong .. but i do not mean any disrespect to you !!
what so ever , i admit am a SQL beginner .. but the least i deserve and his community deserve is to know already how the system work ..
a decent topic must present !

:hypocrite1::hypocrite1:

[Yousef Ayyoub]

so long ,, thanks for translating the topic :specool:

[gotsha]

You Alright 100% :thumbup:
but i cannot release my full Procs
http://s18.postimg.org/a20277gc9/Untitlesd.jpg

btw
this system may work fine in PVP Servers
after small edits in hwanlevel when removing Billionaire title

يا معلم مع احترامى ليك انت دلوقتى بتنزل موضوع لتعمله باتقان وبكل بساطه للناس عشان تفهموا وتفيد الناس فعلا لكن متنزلش حاجه ناقصه وتقول هتفيد الناس للاسف المجال دة بقى فيه ناس كتير عامله نفسها فاهمه وهيا مش عارفه حاجه ودول كتير وانا مش قصدى عليك بس بقولك ياريت لما تنزل حاجه تبقى كامله وشكرا وكل سنه وانت طيب :)

[Hamza FiGo]

انا مع gotsha في كلامة. اللي عايز يساعد الناس بيساعد بمعلومة كاملة. انت تشكر انك نزلت اول الخيط لاكن كان مهم انك تكمل السيستم لان ناس كتير متعرفش حاجة عن السيستمات. فا ياما تنزل الموضوع كامل يا بلاشو خالص

يغلق

##