الموقع العربي الاول للعبة Silkroad Online

- - Auto] Billionaire System] (https://silkroad4arab.com/vb/showthread.php?t=591951)

Auto] Billionaire System]

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

رد: Auto] Billionaire System]

تمت الموافقة

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

رد: Auto] Billionaire System]

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

كود PHP:


		
			
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

رد: Auto] Billionaire System]

اقتباس:

المشاركة الأصلية كتبت بواسطة Dev. iLegend (المشاركة 5222355)

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

كود PHP:


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



Order by RemainGold DESC)

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

رد: Auto] Billionaire System]

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):

رد: Auto] Billionaire System]

اقتباس:

المشاركة الأصلية كتبت بواسطة Yousef Ayyoub (المشاركة 5222577)

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:

رد: Auto] Billionaire System]

اقتباس:

المشاركة الأصلية كتبت بواسطة Hamza FiGo (المشاركة 5222292)

تمت الموافقة

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

Done :biggrin:

رد: Auto] Billionaire System]

اقتباس:

المشاركة الأصلية كتبت بواسطة CritYouDown (المشاركة 5222582)

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:

رد: Auto] Billionaire System]

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

رد: Auto] Billionaire System]

اقتباس:

المشاركة الأصلية كتبت بواسطة CritYouDown (المشاركة 5222457)

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

رد: Auto] Billionaire System]

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

يغلق

##