Job Coins For Each Star & New Features

[elbattawy1st]

السلام عليكم و رحمه الله و بركاتة

شرح فكرة system

السيستم دا عباره عن انو بيدى reward coin او gold لكل star ل hunter او trader او thieve
والسيستم دا مختلف عن اى سيستم نزل على النت قبل كده كان بيعمل star واحد وساعت كمان مش بيشتغل
هنا انا مثبت قيمه Contribution علشان السيستم يشتغل تمام وميكونش فية اى مشاكل معاك
بس قبل ماتستخدم system اعمل backup علشان لو حصل معاك اى error
ملحوظه اى نظام كنت عاملو فى gold هيتشال يعنى لو كنت عامل اى تغير فى rate gold
مش هيكون موجود

وبرضو السيستم دا فية حاجة جديد عملتها فية
انا عملت تابل بيجمع فية نقاط بمعنى
لو انت عملت Trade Star 5 هتاخد 3 point
ولو عملت Trade Star 4 هتاخد 2 point
ولو عملت Trade Star 3 هتاخد 1 point
انا عامل star 1 و star 2 مش بياخدو اى نقاط
ونفس الكلام لو hunter او thieve
طبعا الكلام دا هيتسجل فى الداتا بيز من غير برنامج اوتوماتك على طول
وانت بتحدد عدد النقاط مثلا 500
لما يوصل ل 500 نقطة هياخد Reward coin او silk او title انت بتحددو و بينكتب اسمة
فى السيرفر انو بقى top فى Trader او hunter او thieve وطبعا بيتمسح من التابل كل النقاط الكاكتر جابها و الكاركتر التانين الا كانو
عاوزين يوصلو ل 500 علشان سيستم يبدا من جديد و دا طبعا اوتوماتك
من غير اى برنامج برضو
ولازم تشغل برنامج Vsro Multi Tools علشان Notice
و فى نظام برضو back title automatic
ودا لما واحد ياخد title top trader مثلا و يجى واحد تانى يجمع النقاط التانى دا هياخد
منو title top و الاول هيرحعلو title بتاعو نفس نطام (Unique Killer system) الا انا
كنت عاملو
و عملت برضو صفحه ل job rank علشان الناس تعرف منها points بتاعتها


ندخل بقى فى التحميل و شرح كيفية التشغيل

Tables

Top_Jop_System (https://mega.nz/#!b0VygKTb!Qsu5_HthZ7lIBokbu3CdiSZKNkTy9SEXTDJQJID 6gSE)

Jop_Reward_Log (https://mega.nz/#!Hw1RhDwL!FoxHJIGq6SV7E1FCim4A1kACKh3IS1anCZ53I7l TNUg)

Jop_Reward_system (https://mega.nz/#!3403gTKK!56A2p7PBWcQCl0d0skxLD_9PA6B2f2Vr14neLdy 6fhI)

Old_Titles_Jop (https://mega.nz/#!G1NgRZDD!CbQAdmK-vMpwa31wFQcnnvFApicyjnJGpUDpZtQip4c)

Procedures

Jop_Coins (https://mega.nz/#!GkkXGAbI!1OO8Wispkdo2hC3ewrzA7bprWbXzuslx9KYXfQf MxwM)

Top_Jop_Count (https://mega.nz/#!qlli3CjB!GJInnW_tsCX3IsDja_ujNK9Spl6aBihCik_Fs50 reos)

لو انت كنت عامل system unique killer system متعملش البروسيدور الجاى دا

CGI_WebPurchaseSilk_gift (https://mega.nz/#!6kdFCD5Y!yOXLDxGswxDp3jW63Bbch9Up0J9V_WRX5NFxQe6 rXzM)

لو انت كنت عامل system unique killer system متعملش البروسيدور الجاى دا

CGI_WebPurchaseSilk_Own (https://mega.nz/#!6wdBAbAa!IDV6YzJ9PXeDGBHFDxMVwTmAP58cMTyvZXHtEyQ qaV0)

AddlogChar

IF (@EventID = 6)
BEGIN
EXEC [SRO_VT_SHARDLOG].[dbo].[_Job_Coin] @CharID
END
/* Job Top Count */
IF (@EventID = 9 OR @EventID = 11)
BEGIN
EXEC [SRO_VT_SHARDLOG].[dbo].[Top_Job_Count] @CharID
END

How To Use

اعمل query دا

ملحوظه اعمل backup الاول قبل ماتستخدم query دا الاحتياط بس
و اعمل ريستارت ل gameserver و shardmanager

UPDATE SRO_VT_SHARD.dbo._ItemQuotation set BaseQuot=1.88 , Quot_LB=1.58 , Quot_UB=1.58


UPDATE SRO_VT_SHARD.dbo._CharTrijob set Contribution = '0'


1- نزل tables و procedures واعمل EXEC
2- اقفل و افتح sql تانى علشان Tables الجديد الا انت عملتها
3- ادخل على تابل Job_Reward التابل دا الخاص ب reward الا هيجى لكل كاركتر تعمل
Trade او hunter او thieve
هتلاقى كذا تاب ندخل على شرح كل واحد :
* JopType دا خاص بنوع job
رقم 1 يعنى trader
رقم 2 يعنى thieve
رقم 3 يعنى hunter
* CurLevel دا لو عاوز تحدد max level لناس الا هتاخد reward
* Gold_1Star هنا قيمة الجولد الا هياخدها دى بتاعت star 1
* Gold_2Star قيمة الجولد بتاعت star 2
* Gold_3star قيمة الجولد بتاعت star 3
* Gold_4star قيمة الجولد بتاعت star 4
* Gold_5star قيمة الجولد بتاعت star 5
*Reward_1_1Star كود اول reward بتاعت Star 1
Num_1_1Star كمية اول reward بتاع Star 1
انا عامل لكل ستار ليك ثلاثة reward عاوز تلغى واحده فيهم اكتب 0 بدل كود
*Reward_2_1Star كود تانى reward بتاعت Star 1
Num_2_1Star كمية تانى reward بتاع Star 1
*Reward_3_1Star كود ثالث reward بتاعت Star 1
Num_3_1Star كمية ثالث reward بتاع Star 1
وهكذا فى بقت التابات هتلاقى بس التغير فى رقم القبل star يعنى
Reward_1_2Star هنا رقم 2 الا قبل star اتغير ورقم دا بتاع star يعنى
التاب بتاع star 3 هيكون بالشكل دا Reward_1_3Star وهكذا و رقم 1 الا فى النص دا
يعنى اول reward و انت عندك لحد رقم ثلاثة و هكذا فى بقيت stars

هيبقى تابل الاجواه بالشكل دا
1 120 1000000 20000 30000 40000 500000000 ITEM_ETC_ARENA_COIN 500 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 ITEM_ETC_ARENA_COIN 500 ITEM_ETC_SD_TOKEN_01 500 0 0
2 120 50000 600000 700000 80000 600000000 ITEM_ETC_ARENA_COIN 500 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 ITEM_ETC_ARENA_COIN 600 ITEM_ETC_SD_TOKEN_01 600 0 0
3 120 9000000 100000000 15000000 1200000 700000000 ITEM_ETC_ARENA_COIN 500 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 ITEM_ETC_ARENA_COIN 700 ITEM_ETC_SD_TOKEN_01 700 0 0

ندخل بقى على نظام points

1- افتح تابل Top_Jop_System دا التابل الخاص ب points
2- JopType دا خاص بنوع job
رقم 1 يعنى trader
رقم 2 يعنى thieve
رقم 3 يعنى hunter
3- Points دا عدد النقاط الا هما هيوصلولها علشان ياخدو reward
4- HwanLevel هنا رقم (title top (reward لو مش عاوز تديلو title اعمل رقم 0
5- Reward1 اول كود للهدية
6- Num1 الكمية
7- Plus1 لو انت حابب تديلو سلاح لية بلص ولا حاجة
8- Reward2 تانى هدية
9- Num2 كمية تانية هدية
10- Plus قيمة + تانى هدية
11- و نفس الكلام فى Reward3 و Num3 و Plus3
12- Silk_Own دا قيمة silk donate
13- Silk_Gift دا قيمة silk Free
14- Notice هنا notice الا هتظهر فى الجيم لما يوصل لعدد النقاط الا انت محددو

ودا شكل تابل بعد الاضافه

1 500 4 0 0 0 0 0 0 0 0 0 500 0 Gz Now , u Hero on Mode (Trader)
2 700 0 0 0 0 0 0 0 0 0 0 500 0 Gz Now , u Hero on Mode (Thieve)
3 800 2 0 0 0 0 0 0 0 0 0 500 0 Gz Now , u Hero on Mode (Hunter)

Page Rank Job

Download Files (https://mega.nz/#!i91gyK4J!z85BfU_ds1OX3sIgEVI2g19UUhR4kZdBjl-ilefveSU)

Some Photos From Page

http://i.epvpimg.com/eiIxh.jpg
-------------------------------------------------------------------------
http://i.epvpimg.com/cYCxb.jpg
-------------------------------------------------------------------------
http://i.epvpimg.com/T9rsd.jpg

How To Use

نزل ملفات الصحفة وادخل على folder mods
افتح ملف config وغير كل بيانات sql الموجوده للبياناتك

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

ملحوظه : علشان تستلم الهديه بعد كل trade لازم تقفل و تفتح
اما بالنسبة علشان تستلم هدية لما تجمع points لازم تعمل teleport

Vedio
zppwrhltyPk

[Hamza FiGo]

موضوع هايل ودا متوقع منك ^^

تسلم ايدك

[elbattawy1st]

موضوع هايل ودا متوقع منك ^^

تسلم ايدك

شكراا على الموافقة و تسلم على كلامك دا :winksmiley02:

[Dev.BigBear]

ايوة بقى ياخربها هههههههههههه
بس برضو مش زى الى انا عملتو علشان انا السيستم كلة شغال 1000000000/10
و معدل فى حجتين بس و بياخد الريورد بعد تسليم التريدة
انا شايف حاجات كتير اوووى اية كل دا يعم احنا هتحارب هههههههه
بس الله ينور على على الموقع :111 (5):

[elbattawy1st]

ايوة بقى ياخربها هههههههههههه
بس برضو مش زى الى انا عملتو علشان انا السيستم كلة شغال 1000000000/10
و معدل فى حجتين بس و بياخد الريورد بعد تسليم التريدة
انا شايف حاجات كتير اوووى اية كل دا يعم احنا هتحارب هههههههه
بس الله ينور على على الموقع :111 (5):

تسلم يامعلم
بس declares و select الكتير دا علشان table انا لو كنت عملتو من غير تابل كان سيستم
هيكون فى 5 سطور بكتير بس انا محبتش الناس تعدل فى بروسيدور علشان سعات ناس مش بتعرف تعدل فى البروسيدور فا موضوع تابل دا بيكون سهل عليهم فى التعديل
اما بيكون الوحش فية بيكون بروسيدور كبير زى ماانت شايف ^_^
والسيستم دا شغال تمام من غير مشاكل انا جربتو اكتر من مره
واحنا منك بنتعلم برضو يابرنس ^_^

[Dev.BigBear]

تسلم يامعلم
بس declares و select الكتير دا علشان table انا لو كنت عملتو من غير تابل كان سيستم
هيكون فى 5 سطور بكتير بس انا محبتش الناس تعدل فى بروسيدور علشان سعات ناس مش بتعرف تعدل فى البروسيدور فا موضوع تابل دا بيكون سهل عليهم فى التعديل
اما بيكون الوحش فية بيكون بروسيدور كبير زى ماانت شايف ^_^
والسيستم دا شغال تمام من غير مشاكل انا جربتو اكتر من مره
واحنا منك بنتعلم برضو يابرنس ^_^

هههههههه الموضوع والله مش محتاج الجداول دى كلها
هى طبعا حاجة كويسة للى ميعرفش بس الى انا عملتو بيثبت الحاجات
ممكن اعملو تابل للريورد بس برضو مش هياخد كل دة

[elbattawy1st]

هههههههه الموضوع والله مش محتاج الجداول دى كلها
هى طبعا حاجة كويسة للى ميعرفش بس الى انا عملتو بيثبت الحاجات
ممكن اعملو تابل للريورد بس برضو مش هياخد كل دة

بس كل الا انا عاملو جدول واحد ل reward و جدول ل log علشان يعرفك مين الا اخد reward
اما الحاجات التانية دى تبع نظام تانى فى سيستم وكمان جدول بتاع log عملو علشان النظام بتاع points
يعنى انت لو هتركب بس system coins من غير نظام points هتلاقيك ضايف بروسيدور واحد و جدول واحد يعنى
مش جداول ^_^

[Dev.BigBear]

بس كل الا انا عاملو جدول واحد ل reward و جدول ل log علشان يعرفك مين الا اخد reward
اما الحاجات التانية دى تبع نظام تانى فى سيستم وكمان جدول بتاع log عملو علشان النظام بتاع points
يعنى انت لو هتركب بس system coins من غير نظام points هتلاقيك ضايف بروسيدور واحد و جدول واحد يعنى
مش جداول ^_^

تمام ياكبير
بس بجد تسلم ايدك
:kiss1:

[Cru3L1337]

عااش الله ينور

[SkyZ]

Nice its Good System Good job my best Frined <3

[elbattawy1st]

عااش الله ينور

شكراا لمرورك ^_^

[elbattawy1st]

Nice its Good System Good job my best Frined <3

شكراا لمرورك ^_^

[PirateKings]

انت و بس
ديه اقل حاجة ليك

بس سؤال لو حبيت اعرف عدد النقاط بتاع بلاير معين و اسم اكتر واحد اجيبه منين من SQL ?

[elbattawy1st]

انت و بس
ديه اقل حاجة ليك

بس سؤال لو حبيت اعرف عدد النقاط بتاع بلاير معين و اسم اكتر واحد اجيبه منين من SQL ?

تسلم ^_^
اسم اكتر واحد هتلاقيه معمول في الموقع بيجيب اسماء اكتر 50
ولو عاوز تعرف واحد معين من تابل jobrewardlog

[PirateKings]

تسلم ^_^
اسم اكتر واحد هتلاقيه معمول في الموقع بيجيب اسماء اكتر 50
ولو عاوز تعرف واحد معين من تابل jobrewardlog
انت مفيش منك يااض والله :] انت عديت الحدود :]

[™ EgY_KhaN ™]

اخيرا لقينا حد بينزل حاجه جديده وكاملة مش كوبي وباست
استمر

[elbattawy1st]

اخيرا لقينا حد بينزل حاجه جديده وكاملة مش كوبي وباست
استمر

في الخدمه ياباشا ^_^
بس في ناس هنا كتير برضو بتنزل حاجات جديده و كامله

[PirateKings]

مش شغاال
عملت اللي انت قلت عليه علي الفيس خد الاكواد اهيه بايظ
JobRewardLog
NULL NULL NULL NULL
Job_Reward
1 130 1000000000 2000000000 300000000 4000000000 5000000000 ITEM_ETC_SD_TOKEN_01 50 ITEM_ETC_SD_TOKEN_02 50 ITEM_ETC_SD_TOKEN_03 50 ITEM_ETC_SD_TOKEN_01 50 ITEM_ETC_SD_TOKEN_02 100 ITEM_ETC_SD_TOKEN_03 100 ITEM_ETC_SD_TOKEN_01 100 ITEM_ETC_SD_TOKEN_02 150 ITEM_ETC_SD_TOKEN_03 150 ITEM_ETC_SD_TOKEN_01 200 ITEM_ETC_SD_TOKEN_02 200 ITEM_ETC_SD_TOKEN_03 200 ITEM_ETC_SD_TOKEN_01 250 ITEM_ETC_SD_TOKEN_02 250 ITEM_ETC_SD_TOKEN_03 250
Top_Jop_System
1 50 60 ITEM_ETC_SD_TOKEN_01 500 0 ITEM_ETC_SD_TOKEN_02 500 0 ITEM_ETC_SD_TOKEN_03 500 0 0 0 20 Points
Top_Job_Count
USE [SRO_VT_SHARDLOG]
GO
/****** Object: StoredProcedure [dbo].[Top_Job_Count] Script Date: 20/04/2016 04:49:52 ص ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO




-- =============================================
-- Author: Abdelrhman Elbattawy
-- =============================================

ALTER procedure [dbo].[Top_Job_Count]
@CharID int
as
---------- Main Declares ----------------------
DECLARE @UserID int = (SELECT userjid FROM [SRO_VT_SHARD].[dbo].[_User] where CharID = @CharID)
DECLARE @PointsTR int ,@Top_TR int ,@CharName1 varchar(20),@Points2 int , @Points3 int ,@CharName2 varchar(20) , @CharName3 varchar(20),@HwanTitle1 int
,@PointsHU int ,@PointsTH int ,@Top_HU int ,@Top_TH int ,@HwanTitle int ,@Reward1 varchar(MAX),@Num1 int,@Num2 int,@Num3 int ,@Reward2 varchar(MAX)
,@Reward3 varchar(MAX) , @Notice varchar(Max),@Silkown int,@Plus1 int,@Plus2 int,@Plus3 int,@Silkgift int ,@Count int , @CharNameOld varchar(20) ,@Hwanlevelchange int,@CheckHwanlevel tinyint
Set @PointsTR = (Select Points From [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] where CharID=@CharID And JopType='1')
Set @PointsHU = (Select Points From [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] where CharID=@CharID And JopType='3')
Set @PointsTH = (Select Points From [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] where CharID=@CharID And JopType='2')
----------- Start Top System --------------------------

/* Start Trader Section */
Set @Top_TR = (Select Top 1 (CharID) From [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] where JopType='1' Order By Points desc)
Set @CharName1 = (Select CharName16 From [SRO_VT_SHARD].[dbo].[_Char] where CharID=@Top_TR)
Select @Count = Points,@Notice=notice,@HwanTitle = HwanLevel ,@Reward1=Reward1,@Reward2=Reward2,@Reward3=Reward 3,@Num1=Num1,@Num2=Num2,@Num3=Num3,@Silkown=Silk_O wn,@Silkgift=Silk_Gift,@Plus1=Plus1,@Plus2=Plus2,@ Plus3=Plus3 From [SRO_VT_SHARDLOG].[dbo].[Top_Jop_System] Where JopType = '1'
Set @CheckHwanlevel = (SELECT HwanLevel FROM [SRO_VT_SHARD].[dbo].[_Char] Where CharName16 = @CharName1)
Set @CharNameOld = (SELECT CharName16 FROM [SRO_VT_SHARD].[dbo].[_Char] Where HwanLevel = @HwanTitle)
Set @Hwanlevelchange = (SELECT OldHwan FROM [SRO_VT_SHARDLOG].[dbo].[_OldTitles_Jop] Where CharName=@CharNameOld)
IF @PointsTR >= @Count
BEGIN
-- Take the title from the player
IF Not EXISTS (Select Oldhwan From SRO_VT_SHARDLOG.dbo._OldTitles_jop where CharName=@CharName1)
Begin
Insert Into [SRO_VT_SHARDLOG].[dbo].[_OldTitles_jop] ([CharName],[OldHwan],[UName]) Values (@CharName1,@CheckHwanlevel,@HwanTitle)
END
IF EXISTS (Select Oldhwan From SRO_VT_SHARDLOG.dbo._OldTitles_jop where CharName=@CharName1)
IF (@CheckHwanlevel Not In (Select Hwanlevel From [SRO_VT_SHARDLOG].[dbo].[Top_Jop_System]))
BEGIN
UPDATE [SRO_VT_SHARDLOG].[dbo].[_OldTitles_jop] Set OldHwan=@CheckHwanlevel , UName=@HwanTitle where CharName=@CharName1
END
UPDATE [SRO_VT_SHARD].[dbo].[_Char] SET HwanLevel = @Hwanlevelchange where CharName16 = @CharNameOld
-- Adding the title to the new player
IF(@HwanTitle > '0')
Begin
UPDATE [SRO_VT_SHARD].[dbo].[_Char] set HwanLevel = @HwanTitle where CharName16 = @CharName1
END
-- Item Reward
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName1,@Reward1,@Num1,@Plus1
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName1,@Reward2,@Num2,@Plus2
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName1,@Reward3,@Num3,@Plus3
EXEC SRO_VT_ACCOUNT.[CGI].[CGI_WebPurchaseSilk_Own] @UserID,@Silkown
EXEC SRO_VT_ACCOUNT.[CGI].[CGI_WebPurchaseSilk_Gift] @UserID,@Silkgift
-- Notice Lines To show All server this char is Hero
insert into [SRO_VT_SHARDLOG].[dbo].[iLegend_Tool] ([Service],[Type],[Message],[Date]) Values ('1','Notice',' *** '+@CharName1+'*** , '+@Notice+'',GETDATE())
-- Delete Log Unique From Table
DELETE from [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] where JopType = '1'
END

/* End Trader Section */

/* Start Thieves Section */
Set @Top_TH = (Select Top 1 (CharID) From [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] where JopType='2' Order By Points desc)
Set @CharName2 = (Select CharName16 From [SRO_VT_SHARD].[dbo].[_Char] where CharID=@Top_TH)
Set @CheckHwanlevel = (SELECT HwanLevel FROM [SRO_VT_SHARD].[dbo].[_Char] Where CharName16 = @CharName2)
Select @Count = Points,@Notice=notice,@HwanTitle = HwanLevel ,@Reward1=Reward1,@Reward2=Reward2,@Reward3=Reward 3,@Num1=Num1,@Num2=Num2,@Num3=Num3,@Silkown=Silk_O wn,@Silkgift=Silk_Gift,@Plus1=Plus1,@Plus2=Plus2,@ Plus3=Plus3 From [SRO_VT_SHARDLOG].[dbo].[Top_Jop_System] Where JopType = '2'
Set @CharNameOld = (SELECT CharName16 FROM [SRO_VT_SHARD].[dbo].[_Char] Where HwanLevel = @HwanTitle)
Set @Hwanlevelchange = (SELECT OldHwan FROM [SRO_VT_SHARDLOG].[dbo].[_OldTitles_Jop] Where CharName=@CharNameOld)
IF @PointsTH >= @Count
BEGIN
-- Take the title from the player
IF Not EXISTS (Select Oldhwan From SRO_VT_SHARDLOG.dbo._OldTitles_jop where CharName=@CharName2)
Begin
Insert Into [SRO_VT_SHARDLOG].[dbo].[_OldTitles_jop] ([CharName],[OldHwan],[UName]) Values (@CharName2,@CheckHwanlevel,@HwanTitle)
END
IF EXISTS (Select Oldhwan From SRO_VT_SHARDLOG.dbo._OldTitles_jop where CharName=@CharName2)
IF (@CheckHwanlevel Not In (Select Hwanlevel From [SRO_VT_SHARDLOG].[dbo].[Top_Jop_System]))
BEGIN
UPDATE [SRO_VT_SHARDLOG].[dbo].[_OldTitles_jop] Set OldHwan=@CheckHwanlevel , UName=@HwanTitle where CharName=@CharName2
END
UPDATE [SRO_VT_SHARD].[dbo].[_Char] SET HwanLevel = @Hwanlevelchange where CharName16 = @CharNameOld
-- Adding the title to the new player
IF(@HwanTitle > '0')
Begin
UPDATE [SRO_VT_SHARD].[dbo].[_Char] set HwanLevel = @HwanTitle where CharName16 = @CharName2
END
-- Item Reward
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName1,@Reward1,@Num1,@Plus1
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName1,@Reward2,@Num2,@Plus2
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName1,@Reward3,@Num3,@Plus3
EXEC SRO_VT_ACCOUNT.[CGI].[CGI_WebPurchaseSilk_Own] @UserID,@Silkown
EXEC SRO_VT_ACCOUNT.[CGI].[CGI_WebPurchaseSilk_Gift] @UserID,@Silkgift
-- Notice Lines To show All server this char is Hero
insert into [SRO_VT_SHARDLOG].[dbo].[iLegend_Tool] ([Service],[Type],[Message],[Date]) Values ('1','Notice',' *** '+@CharName2+'*** , '+@Notice+'',GETDATE())
-- Delete Log Unique From Table
DELETE from [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] where JopType = '2'
END

/* End Thieves Section */

/* Start Hunter Section */
Set @Top_HU = (Select Top 1 (CharID) From [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] where JopType='3' Order By Points desc)
Set @CharName3 = (Select CharName16 From [SRO_VT_SHARD].[dbo].[_Char] where CharID=@Top_HU)
Set @CheckHwanlevel = (SELECT HwanLevel FROM [SRO_VT_SHARD].[dbo].[_Char] Where CharName16 = @CharName3)
Select @Count = Points,@Notice=notice,@HwanTitle = HwanLevel ,@Reward1=Reward1,@Reward2=Reward2,@Reward3=Reward 3,@Num1=Num1,@Num2=Num2,@Num3=Num3,@Silkown=Silk_O wn,@Silkgift=Silk_Gift,@Plus1=Plus1,@Plus2=Plus2,@ Plus3=Plus3 From [SRO_VT_SHARDLOG].[dbo].[Top_Jop_System] Where JopType = '3'
Set @CharNameOld = (SELECT CharName16 FROM [SRO_VT_SHARD].[dbo].[_Char] Where HwanLevel = @HwanTitle)
Set @Hwanlevelchange = (SELECT OldHwan FROM [SRO_VT_SHARDLOG].[dbo].[_OldTitles_Jop] Where CharName=@CharNameOld)
IF @PointsHU >= @Count
BEGIN
-- Take the title from the player
IF Not EXISTS (Select Oldhwan From SRO_VT_SHARDLOG.dbo._OldTitles_jop where CharName=@CharName3)
Begin
Insert Into [SRO_VT_SHARDLOG].[dbo].[_OldTitles_jop] ([CharName],[OldHwan],[UName]) Values (@CharName3,@CheckHwanlevel,@HwanTitle)
END
IF EXISTS (Select Oldhwan From SRO_VT_SHARDLOG.dbo._OldTitles_jop where CharName=@CharName3)
IF (@CheckHwanlevel Not In (Select Hwanlevel From [SRO_VT_SHARDLOG].[dbo].[Top_Jop_System]))
BEGIN
UPDATE [SRO_VT_SHARDLOG].[dbo].[_OldTitles_jop] Set OldHwan=@CheckHwanlevel , UName=@HwanTitle where CharName=@CharName3
END
UPDATE [SRO_VT_SHARD].[dbo].[_Char] SET HwanLevel = @Hwanlevelchange where CharName16 = @CharNameOld
-- Adding the title to the new player
IF(@HwanTitle > '0')
Begin
UPDATE [SRO_VT_SHARD].[dbo].[_Char] set HwanLevel = @HwanTitle where CharName16 = @CharName3
END
-- Item Reward
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName1,@Reward1,@Num1,@Plus1
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName1,@Reward2,@Num2,@Plus2
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName1,@Reward3,@Num3,@Plus3
EXEC SRO_VT_ACCOUNT.[CGI].[CGI_WebPurchaseSilk_Own] @UserID,@Silkown
EXEC SRO_VT_ACCOUNT.[CGI].[CGI_WebPurchaseSilk_Gift] @UserID,@Silkgift
-- Notice Lines To show All server this char is Hero
insert into [SRO_VT_SHARDLOG].[dbo].[iLegend_Tool] ([Service],[Type],[Message],[Date]) Values ('1','Notice',' *** '+@CharName3+'*** , '+@Notice+'',GETDATE())
-- Delete Log Unique From Table
DELETE from [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] where JopType = '3'
END

/* End Hunter Section */


_Job_Coin
USE [SRO_VT_SHARDLOG]
GO
/****** Object: StoredProcedure [dbo].[_Job_Coin] Script Date: 20/04/2016 04:50:32 ص ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO





-- =============================================
-- Author: Abdelrhman Elbattawy
-- =============================================

ALTER procedure [dbo].[_Job_Coin]
@CharID int
as
---------- Main & Select Declares ----------------------
DECLARE @JobType int ,@Contri bigint ,@CurLevel int ,@UserJID int , @Points int ,@CharName varchar(20),@Reqlevel int,@Reward_1_3Star varchar(max),@Reward_2_3Star varchar(max),@Reward_3_3Star varchar(max),@Num_1_3Star int,@Num_2_3Star int,@Num_3_3Star int
,@Reward_1_4Star varchar(max),@Reward_2_4Star varchar(max),@Reward_3_4Star varchar(max),@Num_1_4Star int,@Num_2_4Star int,@Num_3_4Star int,@Gold_3Star bigint,@Gold_4Star bigint,@Gold_5Star bigint
,@Reward_1_5Star varchar(max),@Reward_2_5Star varchar(max),@Reward_3_5Star varchar(max),@Num_1_5Star int,@Num_2_5Star int,@Num_3_5Star int,@Gold_2Star bigint,@Gold_1Star bigint
,@Reward_1_2Star varchar(max),@Reward_2_2Star varchar(max),@Reward_3_2Star varchar(max),@Num_1_2Star int,@Num_2_2Star int,@Num_3_2Star int
,@Reward_1_1Star varchar(max),@Reward_2_1Star varchar(max),@Reward_3_1Star varchar(max),@Num_1_1Star int,@Num_2_1Star int,@Num_3_1Star int
Set @JobType = (Select JobType From [SRO_VT_SHARD].[dbo].[_CharTrijob] where CharID=@CharID)
Set @CurLevel = (Select CurLevel From [SRO_VT_SHARD].[dbo].[_Char] where CharID=@CharID)
Set @UserJID = (Select userjid FROM [SRO_VT_SHARD].[dbo].[_User] where CharID = @CharID)
Set @Contri = (Select Contribution From [SRO_VT_SHARD].[dbo].[_CharTrijob] where CharID=@CharID)
Set @Points = (Select Points From [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] where CharID=@CharID And JopType='1')
Set @CharName =(Select CharName16 From [SRO_VT_SHARD].[dbo].[_Char] where CharID=@CharID)
Declare @Remaingold bigint = (Select RemainGold From [SRO_VT_SHARD].[dbo].[_Char] where CharID=@CharID)
---------- Start Trader System ----------------------
Select @Reqlevel=Curlevel , @Reward_1_3Star=Reward_1_3Star ,@Num_1_3Star=Num_1_3Star ,@Reward_2_3Star=Reward_2_3Star,@Num_2_3Star=Num_2 _3Star ,@Reward_3_3Star=Reward_3_3Star,@Num_3_3Star=Num_3 _3Star
,@Reward_1_4Star=Reward_1_4Star ,@Num_1_4Star=Num_1_4Star ,@Reward_2_4Star=Reward_2_4Star,@Num_2_4Star=Num_2 _4Star ,@Reward_3_4Star=Reward_3_4Star,@Num_3_4Star=Num_3 _4Star,@Gold_3Star = Gold_3Star,@Gold_4Star = Gold_4Star,@Gold_5Star = Gold_5Star
,@Reward_1_5Star=Reward_1_5Star ,@Num_1_5Star=Num_1_5Star ,@Reward_2_5Star=Reward_2_5Star,@Num_2_5Star=Num_2 _5Star ,@Reward_3_5Star=Reward_3_5Star,@Num_3_5Star=Num_3 _5Star,@Gold_2Star = Gold_2Star
,@Reward_1_2Star=Reward_1_2Star ,@Num_1_2Star=Num_1_2Star ,@Reward_2_2Star=Reward_2_2Star,@Num_2_2Star=Num_2 _2Star ,@Reward_3_2Star=Reward_3_2Star,@Num_3_2Star=Num_3 _2Star,@Gold_1Star = Gold_1Star
,@Reward_1_1Star=Reward_1_1Star ,@Num_1_1Star=Num_1_1Star ,@Reward_2_1Star=Reward_2_1Star,@Num_2_1Star=Num_2 _1Star ,@Reward_3_1Star=Reward_3_1Star,@Num_3_1Star=Num_3 _1Star From [SRO_VT_SHARDLOG].[dbo].[Job_Reward] where JopType='1'
/* 1 Star Section */
IF (@JobType = '1' AND @Contri BETWEEN '2420' And '48400')
BEGIN
UPDATE SRO_VT_SHARD.dbo._CharTrijob SET Contribution = '0' WHERE CharID = @CharID
UPDATE [SRO_VT_SHARD].[dbo].[_Char] Set RemainGold = @Remaingold + @Gold_1Star where CharID=@CharID
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName,@Reward_1_1Star,@Num_1_1Star,0
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName,@Reward_2_1Star,@Num_2_1Star,0
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName,@Reward_3_1Star,@Num_3_1Star,0
UPDATE [SRO_VT_SHARD].[dbo].[_CharTrijob] SET Contribution = '0' WHERE CharID = @CharID
Insert Into [SRO_VT_SHARDLOG].[dbo].[iLegend_Tool] (Service,Type,Target,Message,Date) Values (1,'Private',@CharName,'u have achieved star 1, ur points not increased',Getdate())
END

/* 2 Star Section */
IF (@JobType = '1' AND @Contri BETWEEN '50820' And '87120')
BEGIN
UPDATE SRO_VT_SHARD.dbo._CharTrijob SET Contribution = '0' WHERE CharID = @CharID
UPDATE [SRO_VT_SHARD].[dbo].[_Char] Set RemainGold = @Remaingold + @Gold_2Star where CharID=@CharID
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName,@Reward_1_2Star,@Num_1_2Star,0
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName,@Reward_2_2Star,@Num_2_2Star,0
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName,@Reward_3_2Star,@Num_3_2Star,0
UPDATE [SRO_VT_SHARD].[dbo].[_CharTrijob] SET Contribution = '0' WHERE CharID = @CharID
Insert Into [SRO_VT_SHARDLOG].[dbo].[iLegend_Tool] (Service,Type,Target,Message,Date) Values (1,'Private',@CharName,'u have achieved star 2, ur points not increased',Getdate())
END

/* 3 Star Section */
IF (@JobType = '1' AND @Contri BETWEEN '89540' And '137940')
BEGIN
UPDATE SRO_VT_SHARD.dbo._CharTrijob SET Contribution = '0' WHERE CharID = @CharID
UPDATE [SRO_VT_SHARD].[dbo].[_Char] Set RemainGold = @Remaingold + @Gold_3Star where CharID=@CharID
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName,@Reward_1_3Star,@Num_1_3Star,0
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName,@Reward_2_3Star,@Num_2_3Star,0
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName,@Reward_3_3Star,@Num_3_3Star,0
UPDATE [SRO_VT_SHARD].[dbo].[_CharTrijob] SET Contribution = '0' WHERE CharID = @CharID
Insert Into [SRO_VT_SHARDLOG].[dbo].[iLegend_Tool] (Service,Type,Target,Message,Date) Values (1,'Private',@CharName,'u have achieved star 3, ur point now increased +1',Getdate())
IF Not EXISTS (Select Points From [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] where CharID=@CharID And JopType='1')
Begin
Insert Into [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] ([CharID],[Charname],[JopType],[Points]) Values (@CharID,@CharName,'1','1')
END
IF EXISTS (Select Points From [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] where CharID=@CharID And JopType='1')
BEGIN
UPDATE [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] Set charname=@Charname , Points=@Points + 1 where CharID=@CharID And JopType='1'
END
END

/* 4 Star Section */
IF (@JobType = '1' AND @Contri BETWEEN '140360' And '205700')
BEGIN
UPDATE SRO_VT_SHARD.dbo._CharTrijob SET Contribution = '0' WHERE CharID = @CharID
UPDATE [SRO_VT_SHARD].[dbo].[_Char] Set RemainGold = @Remaingold + @Gold_4Star where CharID=@CharID
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName,@Reward_1_4Star,@Num_1_4Star,0
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName,@Reward_2_4Star,@Num_2_4Star,0
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName,@Reward_3_4Star,@Num_3_4Star,0
UPDATE [SRO_VT_SHARD].[dbo].[_CharTrijob] SET Contribution = '0' WHERE CharID = @CharID
Insert Into [SRO_VT_SHARDLOG].[dbo].[iLegend_Tool] (Service,Type,Target,Message,Date) Values (1,'Private',@CharName,'u have achieved star 4, ur point now increased +2',Getdate())
IF Not EXISTS (Select Points From [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] where CharID=@CharID And JopType='1')
Begin
Insert Into [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] ([CharID],[Charname],[JopType],[Points]) Values (@CharID,@CharName,'1','2')
END
IF EXISTS (Select Points From [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] where CharID=@CharID And JopType='1')
BEGIN
UPDATE [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] Set charname=@Charname , Points=@Points + 2 where CharID=@CharID And JopType='1'
END
END

/* 5 Star Section */
IF (@JobType = '1' AND @Contri BETWEEN '208120' And '384780')
BEGIN
UPDATE SRO_VT_SHARD.dbo._CharTrijob SET Contribution = '0' WHERE CharID = @CharID
UPDATE [SRO_VT_SHARD].[dbo].[_Char] Set RemainGold = @Remaingold + @Gold_5Star where CharID=@CharID
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName,@Reward_1_5Star,@Num_1_5Star,0
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName,@Reward_2_5Star,@Num_2_5Star,0
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName,@Reward_3_5Star,@Num_3_5Star,0
UPDATE [SRO_VT_SHARD].[dbo].[_CharTrijob] SET Contribution = '0' WHERE CharID = @CharID
Insert Into [SRO_VT_SHARDLOG].[dbo].[iLegend_Tool] (Service,Type,Target,Message,Date) Values (1,'Private',@CharName,'u have achieved star 5, ur point now increased +3',Getdate())
IF Not EXISTS (Select Points From [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] where CharID=@CharID And JopType='1')
Begin
Insert Into [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] ([CharID],[Charname],[JopType],[Points]) Values (@CharID,@CharName,'1','3')
END
IF EXISTS (Select Points From [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] where CharID=@CharID And JopType='1')
BEGIN
UPDATE [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] Set charname=@Charname , Points=@Points + 3 where CharID=@CharID And JopType='1'
END
END
---------- End Trader System ----------------------
----------- Start Hunter System ----------------------
Set @Points = (Select Points From [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] where CharID=@CharID And JopType='3')
Select @Reqlevel=Curlevel , @Reward_1_3Star=Reward_1_3Star ,@Num_1_3Star=Num_1_3Star ,@Reward_2_3Star=Reward_2_3Star,@Num_2_3Star=Num_2 _3Star ,@Reward_3_3Star=Reward_3_3Star,@Num_3_3Star=Num_3 _3Star
,@Reward_1_4Star=Reward_1_4Star ,@Num_1_4Star=Num_1_4Star ,@Reward_2_4Star=Reward_2_4Star,@Num_2_4Star=Num_2 _4Star ,@Reward_3_4Star=Reward_3_4Star,@Num_3_4Star=Num_3 _4Star,@Gold_3Star = Gold_3Star,@Gold_4Star = Gold_4Star,@Gold_5Star = Gold_5Star
,@Reward_1_5Star=Reward_1_5Star ,@Num_1_5Star=Num_1_5Star ,@Reward_2_5Star=Reward_2_5Star,@Num_2_5Star=Num_2 _5Star ,@Reward_3_5Star=Reward_3_5Star,@Num_3_5Star=Num_3 _5Star,@Gold_2Star = Gold_2Star
,@Reward_1_2Star=Reward_1_2Star ,@Num_1_2Star=Num_1_2Star ,@Reward_2_2Star=Reward_2_2Star,@Num_2_2Star=Num_2 _2Star ,@Reward_3_2Star=Reward_3_2Star,@Num_3_2Star=Num_3 _2Star,@Gold_1Star = Gold_1Star
,@Reward_1_1Star=Reward_1_1Star ,@Num_1_1Star=Num_1_1Star ,@Reward_2_1Star=Reward_2_1Star,@Num_2_1Star=Num_2 _1Star ,@Reward_3_1Star=Reward_3_1Star,@Num_3_1Star=Num_3 _1Star From [SRO_VT_SHARDLOG].[dbo].[Job_Reward] where JopType='3'
/* 1 Star Section */
IF (@JobType = '3' AND @Contri BETWEEN '1776' And '35520')
BEGIN
UPDATE SRO_VT_SHARD.dbo._CharTrijob SET Contribution = '0' WHERE CharID = @CharID
UPDATE [SRO_VT_SHARD].[dbo].[_Char] Set RemainGold = @Remaingold + @Gold_1Star where CharID=@CharID
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName,@Reward_1_1Star,@Num_1_1Star,0
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName,@Reward_2_1Star,@Num_2_1Star,0
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName,@Reward_3_1Star,@Num_3_1Star,0
UPDATE [SRO_VT_SHARD].[dbo].[_CharTrijob] SET Contribution = '0' WHERE CharID = @CharID
Insert Into [SRO_VT_SHARDLOG].[dbo].[iLegend_Tool] (Service,Type,Target,Message,Date) Values (1,'Private',@CharName,'u have achieved star 1, ur points not increased',Getdate())
END

/* 2 Star Section */
IF (@JobType = '3' AND @Contri BETWEEN '37296' And '63936')
BEGIN
UPDATE SRO_VT_SHARD.dbo._CharTrijob SET Contribution = '0' WHERE CharID = @CharID
UPDATE [SRO_VT_SHARD].[dbo].[_Char] Set RemainGold = @Remaingold + @Gold_2Star where CharID=@CharID
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName,@Reward_1_2Star,@Num_1_2Star,0
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName,@Reward_2_2Star,@Num_2_2Star,0
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName,@Reward_3_2Star,@Num_3_2Star,0
UPDATE [SRO_VT_SHARD].[dbo].[_CharTrijob] SET Contribution = '0' WHERE CharID = @CharID
Insert Into [SRO_VT_SHARDLOG].[dbo].[iLegend_Tool] (Service,Type,Target,Message,Date) Values (1,'Private',@CharName,'u have achieved star 2, ur points not increased',Getdate())
END

/* 3 Star Section */
IF (@JobType = '3' AND @CurLevel >= @Reqlevel AND @Contri BETWEEN '65712' And '101232')
BEGIN
UPDATE SRO_VT_SHARD.dbo._CharTrijob SET Contribution = '0' WHERE CharID = @CharID
UPDATE [SRO_VT_SHARD].[dbo].[_Char] Set RemainGold = @Remaingold + @Gold_3Star where CharID=@CharID
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName,@Reward_1_3Star,@Num_1_3Star,0
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName,@Reward_2_3Star,@Num_2_3Star,0
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName,@Reward_3_3Star,@Num_3_3Star,0
UPDATE [SRO_VT_SHARD].[dbo].[_CharTrijob] SET Contribution = '0' WHERE CharID = @CharID
Insert Into [SRO_VT_SHARDLOG].[dbo].[iLegend_Tool] (Service,Type,Target,Message,Date) Values (1,'Private',@CharName,'u have achieved star 3, ur point now increased +1',Getdate())
IF Not EXISTS (Select Points From [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] where CharID=@CharID And JopType='3')
Begin
Insert Into [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] ([CharID],[Charname],[JopType],[Points]) Values (@CharID,@CharName,'3','1')
END
IF EXISTS (Select Points From [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] where CharID=@CharID And JopType='3')
BEGIN
UPDATE [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] Set charname=@Charname , Points=@Points + 1 where CharID=@CharID And JopType='3'
END
END
/* 4 Star Section */
IF (@JobType = '3' AND @CurLevel >= @Reqlevel AND @Contri BETWEEN '103008' And '150960')
BEGIN
UPDATE SRO_VT_SHARD.dbo._CharTrijob SET Contribution = '0' WHERE CharID = @CharID
UPDATE [SRO_VT_SHARD].[dbo].[_Char] Set RemainGold = @Remaingold + @Gold_4Star where CharID=@CharID
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName,@Reward_1_4Star,@Num_1_4Star,0
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName,@Reward_2_4Star,@Num_2_4Star,0
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName,@Reward_3_4Star,@Num_3_4Star,0
UPDATE [SRO_VT_SHARD].[dbo].[_CharTrijob] SET Contribution = '0' WHERE CharID = @CharID
Insert Into [SRO_VT_SHARDLOG].[dbo].[iLegend_Tool] (Service,Type,Target,Message,Date) Values (1,'Private',@CharName,'u have achieved star 4, ur point now increased +2',Getdate())
IF Not EXISTS (Select Points From [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] where CharID=@CharID And JopType='3')
Begin
Insert Into [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] ([CharID],[Charname],[JopType],[Points]) Values (@CharID,@CharName,'3','2')
END
IF EXISTS (Select Points From [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] where CharID=@CharID And JopType='3')
BEGIN
UPDATE [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] Set charname=@Charname , Points=@Points + 2 where CharID=@CharID And JopType='3'
END
END
/* 5 Star Section */
IF (@JobType = '3' AND @CurLevel >= @Reqlevel AND @Contri BETWEEN '152736' And '282384')
BEGIN
UPDATE SRO_VT_SHARD.dbo._CharTrijob SET Contribution = '0' WHERE CharID = @CharID
UPDATE [SRO_VT_SHARD].[dbo].[_Char] Set RemainGold = @Remaingold + @Gold_5Star where CharID=@CharID
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName,@Reward_1_5Star,@Num_1_5Star,0
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName,@Reward_2_5Star,@Num_2_5Star,0
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName,@Reward_3_5Star,@Num_3_5Star,0
UPDATE [SRO_VT_SHARD].[dbo].[_CharTrijob] SET Contribution = '0' WHERE CharID = @CharID
Insert Into [SRO_VT_SHARDLOG].[dbo].[iLegend_Tool] (Service,Type,Target,Message,Date) Values (1,'Private',@CharName,'u have achieved star 5, ur point now increased +3',Getdate())
IF Not EXISTS (Select Points From [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] where CharID=@CharID And JopType='3')
Begin
Insert Into [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] ([CharID],[Charname],[JopType],[Points]) Values (@CharID,@CharName,'3','3')
END
IF EXISTS (Select Points From [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] where CharID=@CharID And JopType='3')
BEGIN
UPDATE [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] Set charname=@Charname , Points=@Points + 3 where CharID=@CharID And JopType='3'
END
END
----------- End Hunter System ------------------------


----------- Start Thieves System ----------------------
Set @Points = (Select Points From [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] where CharID=@CharID And JopType='2')
Select @Reqlevel=Curlevel , @Reward_1_3Star=Reward_1_3Star ,@Num_1_3Star=Num_1_3Star ,@Reward_2_3Star=Reward_2_3Star,@Num_2_3Star=Num_2 _3Star ,@Reward_3_3Star=Reward_3_3Star,@Num_3_3Star=Num_3 _3Star
,@Reward_1_4Star=Reward_1_4Star ,@Num_1_4Star=Num_1_4Star ,@Reward_2_4Star=Reward_2_4Star,@Num_2_4Star=Num_2 _4Star ,@Reward_3_4Star=Reward_3_4Star,@Num_3_4Star=Num_3 _4Star,@Gold_3Star = Gold_3Star,@Gold_4Star = Gold_4Star,@Gold_5Star = Gold_5Star
,@Reward_1_5Star=Reward_1_5Star ,@Num_1_5Star=Num_1_5Star ,@Reward_2_5Star=Reward_2_5Star,@Num_2_5Star=Num_2 _5Star ,@Reward_3_5Star=Reward_3_5Star,@Num_3_5Star=Num_3 _5Star,@Gold_2Star = Gold_2Star
,@Reward_1_2Star=Reward_1_2Star ,@Num_1_2Star=Num_1_2Star ,@Reward_2_2Star=Reward_2_2Star,@Num_2_2Star=Num_2 _2Star ,@Reward_3_2Star=Reward_3_2Star,@Num_3_2Star=Num_3 _2Star,@Gold_1Star = Gold_1Star
,@Reward_1_1Star=Reward_1_1Star ,@Num_1_1Star=Num_1_1Star ,@Reward_2_1Star=Reward_2_1Star,@Num_2_1Star=Num_2 _1Star ,@Reward_3_1Star=Reward_3_1Star,@Num_3_1Star=Num_3 _1Star From [SRO_VT_SHARDLOG].[dbo].[Job_Reward] where JopType='2'
/* 1 Star Section */
IF (@JobType = '2' AND @Contri BETWEEN '6128' And '122560')
BEGIN
UPDATE SRO_VT_SHARD.dbo._CharTrijob SET Contribution = '0' WHERE CharID = @CharID
UPDATE [SRO_VT_SHARD].[dbo].[_Char] Set RemainGold = @Remaingold + @Gold_1Star where CharID=@CharID
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName,@Reward_1_1Star,@Num_1_1Star,0
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName,@Reward_2_1Star,@Num_2_1Star,0
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName,@Reward_3_1Star,@Num_3_1Star,0
UPDATE [SRO_VT_SHARD].[dbo].[_CharTrijob] SET Contribution = '0' WHERE CharID = @CharID
Insert Into [SRO_VT_SHARDLOG].[dbo].[iLegend_Tool] (Service,Type,Target,Message,Date) Values (1,'Private',@CharName,'u have achieved star 1, ur points not increased',Getdate())
END

/* 2 Star Section */
IF (@JobType = '2' AND @Contri BETWEEN '128688' And '220608')
BEGIN
UPDATE SRO_VT_SHARD.dbo._CharTrijob SET Contribution = '0' WHERE CharID = @CharID
UPDATE [SRO_VT_SHARD].[dbo].[_Char] Set RemainGold = @Remaingold + @Gold_2Star where CharID=@CharID
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName,@Reward_1_2Star,@Num_1_2Star,0
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName,@Reward_2_2Star,@Num_2_2Star,0
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName,@Reward_3_2Star,@Num_3_2Star,0
UPDATE [SRO_VT_SHARD].[dbo].[_CharTrijob] SET Contribution = '0' WHERE CharID = @CharID
Insert Into [SRO_VT_SHARDLOG].[dbo].[iLegend_Tool] (Service,Type,Target,Message,Date) Values (1,'Private',@CharName,'u have achieved star 2, ur points not increased',Getdate())
END

/* 3 Star Section */
IF (@JobType = '2' AND @CurLevel >= @Reqlevel AND @Contri BETWEEN '226736' And '349296')
BEGIN
UPDATE SRO_VT_SHARD.dbo._CharTrijob SET Contribution = '0' WHERE CharID = @CharID
UPDATE [SRO_VT_SHARD].[dbo].[_Char] Set RemainGold = @Remaingold + @Gold_3Star where CharID=@CharID
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName,@Reward_1_3Star,@Num_1_3Star,0
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName,@Reward_2_3Star,@Num_2_3Star,0
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName,@Reward_3_3Star,@Num_3_3Star,0
UPDATE [SRO_VT_SHARD].[dbo].[_CharTrijob] SET Contribution = '0' WHERE CharID = @CharID
Insert Into [SRO_VT_SHARDLOG].[dbo].[iLegend_Tool] (Service,Type,Target,Message,Date) Values (1,'Private',@CharName,'u have achieved star 3, ur point now increased +1',Getdate())
IF Not EXISTS (Select Points From [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] where CharID=@CharID And JopType='2')
Begin
Insert Into [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] ([CharID],[Charname],[JopType],[Points]) Values (@CharID,@CharName,'2','1')
END
IF EXISTS (Select Points From [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] where CharID=@CharID And JopType='2')
BEGIN
UPDATE [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] Set charname=@Charname , Points=@Points + 1 where CharID=@CharID And JopType='2'
END
END
/* 4 Star Section */
IF (@JobType = '2' AND @CurLevel >= @Reqlevel AND @Contri BETWEEN '355424' And '520880')
BEGIN
UPDATE SRO_VT_SHARD.dbo._CharTrijob SET Contribution = '0' WHERE CharID = @CharID
UPDATE [SRO_VT_SHARD].[dbo].[_Char] Set RemainGold = @Remaingold + @Gold_4Star where CharID=@CharID
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName,@Reward_1_4Star,@Num_1_4Star,0
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName,@Reward_2_4Star,@Num_2_4Star,0
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName,@Reward_3_4Star,@Num_3_4Star,0
UPDATE [SRO_VT_SHARD].[dbo].[_CharTrijob] SET Contribution = '0' WHERE CharID = @CharID
Insert Into [SRO_VT_SHARDLOG].[dbo].[iLegend_Tool] (Service,Type,Target,Message,Date) Values (1,'Private',@CharName,'u have achieved star 4, ur point now increased +2',Getdate())
IF Not EXISTS (Select Points From [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] where CharID=@CharID And JopType='2')
Begin
Insert Into [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] ([CharID],[Charname],[JopType],[Points]) Values (@CharID,@CharName,'2','2')
END
IF EXISTS (Select Points From [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] where CharID=@CharID And JopType='2')
BEGIN
UPDATE [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] Set charname=@Charname , Points=@Points + 2 where CharID=@CharID And JopType='2'
END
END
/* 5 Star Section */
IF (@JobType = '2' AND @CurLevel >= @Reqlevel AND @Contri BETWEEN '527008' And '974352')
BEGIN
UPDATE SRO_VT_SHARD.dbo._CharTrijob SET Contribution = '0' WHERE CharID = @CharID
UPDATE [SRO_VT_SHARD].[dbo].[_Char] Set RemainGold = @Remaingold + @Gold_5Star where CharID=@CharID
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName,@Reward_1_5Star,@Num_1_5Star,0
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName,@Reward_2_5Star,@Num_2_5Star,0
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName,@Reward_3_5Star,@Num_3_5Star,0
UPDATE [SRO_VT_SHARD].[dbo].[_CharTrijob] SET Contribution = '0' WHERE CharID = @CharID
Insert Into [SRO_VT_SHARDLOG].[dbo].[iLegend_Tool] (Service,Type,Target,Message,Date) Values (1,'Private',@CharName,'u have achieved star 5, ur point now increased +3',Getdate())
IF Not EXISTS (Select Points From [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] where CharID=@CharID And JopType='2')
Begin
Insert Into [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] ([CharID],[Charname],[JopType],[Points]) Values (@CharID,@CharName,'2','3')
END
IF EXISTS (Select Points From [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] where CharID=@CharID And JopType='2')
BEGIN
UPDATE [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] Set charname=@Charname , Points=@Points + 3 where CharID=@CharID And JopType='2'
END
END
----------- End Thieves System ------------------------




و طبعا addlogchar

[elbattawy1st]

مش شغاال
عملت اللي انت قلت عليه علي الفيس خد الاكواد اهيه بايظ
JobRewardLog
NULL NULL NULL NULL
Job_Reward
1 130 1000000000 2000000000 300000000 4000000000 5000000000 ITEM_ETC_SD_TOKEN_01 50 ITEM_ETC_SD_TOKEN_02 50 ITEM_ETC_SD_TOKEN_03 50 ITEM_ETC_SD_TOKEN_01 50 ITEM_ETC_SD_TOKEN_02 100 ITEM_ETC_SD_TOKEN_03 100 ITEM_ETC_SD_TOKEN_01 100 ITEM_ETC_SD_TOKEN_02 150 ITEM_ETC_SD_TOKEN_03 150 ITEM_ETC_SD_TOKEN_01 200 ITEM_ETC_SD_TOKEN_02 200 ITEM_ETC_SD_TOKEN_03 200 ITEM_ETC_SD_TOKEN_01 250 ITEM_ETC_SD_TOKEN_02 250 ITEM_ETC_SD_TOKEN_03 250
Top_Jop_System
1 50 60 ITEM_ETC_SD_TOKEN_01 500 0 ITEM_ETC_SD_TOKEN_02 500 0 ITEM_ETC_SD_TOKEN_03 500 0 0 0 20 Points
Top_Job_Count
USE [SRO_VT_SHARDLOG]
GO
/****** Object: StoredProcedure [dbo].[Top_Job_Count] Script Date: 20/04/2016 04:49:52 ص ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO




-- =============================================
-- Author: Abdelrhman Elbattawy
-- =============================================

ALTER procedure [dbo].[Top_Job_Count]
@CharID int
as
---------- Main Declares ----------------------
DECLARE @UserID int = (SELECT userjid FROM [SRO_VT_SHARD].[dbo].[_User] where CharID = @CharID)
DECLARE @PointsTR int ,@Top_TR int ,@CharName1 varchar(20),@Points2 int , @Points3 int ,@CharName2 varchar(20) , @CharName3 varchar(20),@HwanTitle1 int
,@PointsHU int ,@PointsTH int ,@Top_HU int ,@Top_TH int ,@HwanTitle int ,@Reward1 varchar(MAX),@Num1 int,@Num2 int,@Num3 int ,@Reward2 varchar(MAX)
,@Reward3 varchar(MAX) , @Notice varchar(Max),@Silkown int,@Plus1 int,@Plus2 int,@Plus3 int,@Silkgift int ,@Count int , @CharNameOld varchar(20) ,@Hwanlevelchange int,@CheckHwanlevel tinyint
Set @PointsTR = (Select Points From [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] where CharID=@CharID And JopType='1')
Set @PointsHU = (Select Points From [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] where CharID=@CharID And JopType='3')
Set @PointsTH = (Select Points From [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] where CharID=@CharID And JopType='2')
----------- Start Top System --------------------------

/* Start Trader Section */
Set @Top_TR = (Select Top 1 (CharID) From [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] where JopType='1' Order By Points desc)
Set @CharName1 = (Select CharName16 From [SRO_VT_SHARD].[dbo].[_Char] where CharID=@Top_TR)
Select @Count = Points,@Notice=notice,@HwanTitle = HwanLevel ,@Reward1=Reward1,@Reward2=Reward2,@Reward3=Reward 3,@Num1=Num1,@Num2=Num2,@Num3=Num3,@Silkown=Silk_O wn,@Silkgift=Silk_Gift,@Plus1=Plus1,@Plus2=Plus2,@ Plus3=Plus3 From [SRO_VT_SHARDLOG].[dbo].[Top_Jop_System] Where JopType = '1'
Set @CheckHwanlevel = (SELECT HwanLevel FROM [SRO_VT_SHARD].[dbo].[_Char] Where CharName16 = @CharName1)
Set @CharNameOld = (SELECT CharName16 FROM [SRO_VT_SHARD].[dbo].[_Char] Where HwanLevel = @HwanTitle)
Set @Hwanlevelchange = (SELECT OldHwan FROM [SRO_VT_SHARDLOG].[dbo].[_OldTitles_Jop] Where CharName=@CharNameOld)
IF @PointsTR >= @Count
BEGIN
-- Take the title from the player
IF Not EXISTS (Select Oldhwan From SRO_VT_SHARDLOG.dbo._OldTitles_jop where CharName=@CharName1)
Begin
Insert Into [SRO_VT_SHARDLOG].[dbo].[_OldTitles_jop] ([CharName],[OldHwan],[UName]) Values (@CharName1,@CheckHwanlevel,@HwanTitle)
END
IF EXISTS (Select Oldhwan From SRO_VT_SHARDLOG.dbo._OldTitles_jop where CharName=@CharName1)
IF (@CheckHwanlevel Not In (Select Hwanlevel From [SRO_VT_SHARDLOG].[dbo].[Top_Jop_System]))
BEGIN
UPDATE [SRO_VT_SHARDLOG].[dbo].[_OldTitles_jop] Set OldHwan=@CheckHwanlevel , UName=@HwanTitle where CharName=@CharName1
END
UPDATE [SRO_VT_SHARD].[dbo].[_Char] SET HwanLevel = @Hwanlevelchange where CharName16 = @CharNameOld
-- Adding the title to the new player
IF(@HwanTitle > '0')
Begin
UPDATE [SRO_VT_SHARD].[dbo].[_Char] set HwanLevel = @HwanTitle where CharName16 = @CharName1
END
-- Item Reward
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName1,@Reward1,@Num1,@Plus1
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName1,@Reward2,@Num2,@Plus2
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName1,@Reward3,@Num3,@Plus3
EXEC SRO_VT_ACCOUNT.[CGI].[CGI_WebPurchaseSilk_Own] @UserID,@Silkown
EXEC SRO_VT_ACCOUNT.[CGI].[CGI_WebPurchaseSilk_Gift] @UserID,@Silkgift
-- Notice Lines To show All server this char is Hero
insert into [SRO_VT_SHARDLOG].[dbo].[iLegend_Tool] ([Service],[Type],[Message],[Date]) Values ('1','Notice',' *** '+@CharName1+'*** , '+@Notice+'',GETDATE())
-- Delete Log Unique From Table
DELETE from [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] where JopType = '1'
END

/* End Trader Section */

/* Start Thieves Section */
Set @Top_TH = (Select Top 1 (CharID) From [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] where JopType='2' Order By Points desc)
Set @CharName2 = (Select CharName16 From [SRO_VT_SHARD].[dbo].[_Char] where CharID=@Top_TH)
Set @CheckHwanlevel = (SELECT HwanLevel FROM [SRO_VT_SHARD].[dbo].[_Char] Where CharName16 = @CharName2)
Select @Count = Points,@Notice=notice,@HwanTitle = HwanLevel ,@Reward1=Reward1,@Reward2=Reward2,@Reward3=Reward 3,@Num1=Num1,@Num2=Num2,@Num3=Num3,@Silkown=Silk_O wn,@Silkgift=Silk_Gift,@Plus1=Plus1,@Plus2=Plus2,@ Plus3=Plus3 From [SRO_VT_SHARDLOG].[dbo].[Top_Jop_System] Where JopType = '2'
Set @CharNameOld = (SELECT CharName16 FROM [SRO_VT_SHARD].[dbo].[_Char] Where HwanLevel = @HwanTitle)
Set @Hwanlevelchange = (SELECT OldHwan FROM [SRO_VT_SHARDLOG].[dbo].[_OldTitles_Jop] Where CharName=@CharNameOld)
IF @PointsTH >= @Count
BEGIN
-- Take the title from the player
IF Not EXISTS (Select Oldhwan From SRO_VT_SHARDLOG.dbo._OldTitles_jop where CharName=@CharName2)
Begin
Insert Into [SRO_VT_SHARDLOG].[dbo].[_OldTitles_jop] ([CharName],[OldHwan],[UName]) Values (@CharName2,@CheckHwanlevel,@HwanTitle)
END
IF EXISTS (Select Oldhwan From SRO_VT_SHARDLOG.dbo._OldTitles_jop where CharName=@CharName2)
IF (@CheckHwanlevel Not In (Select Hwanlevel From [SRO_VT_SHARDLOG].[dbo].[Top_Jop_System]))
BEGIN
UPDATE [SRO_VT_SHARDLOG].[dbo].[_OldTitles_jop] Set OldHwan=@CheckHwanlevel , UName=@HwanTitle where CharName=@CharName2
END
UPDATE [SRO_VT_SHARD].[dbo].[_Char] SET HwanLevel = @Hwanlevelchange where CharName16 = @CharNameOld
-- Adding the title to the new player
IF(@HwanTitle > '0')
Begin
UPDATE [SRO_VT_SHARD].[dbo].[_Char] set HwanLevel = @HwanTitle where CharName16 = @CharName2
END
-- Item Reward
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName1,@Reward1,@Num1,@Plus1
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName1,@Reward2,@Num2,@Plus2
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName1,@Reward3,@Num3,@Plus3
EXEC SRO_VT_ACCOUNT.[CGI].[CGI_WebPurchaseSilk_Own] @UserID,@Silkown
EXEC SRO_VT_ACCOUNT.[CGI].[CGI_WebPurchaseSilk_Gift] @UserID,@Silkgift
-- Notice Lines To show All server this char is Hero
insert into [SRO_VT_SHARDLOG].[dbo].[iLegend_Tool] ([Service],[Type],[Message],[Date]) Values ('1','Notice',' *** '+@CharName2+'*** , '+@Notice+'',GETDATE())
-- Delete Log Unique From Table
DELETE from [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] where JopType = '2'
END

/* End Thieves Section */

/* Start Hunter Section */
Set @Top_HU = (Select Top 1 (CharID) From [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] where JopType='3' Order By Points desc)
Set @CharName3 = (Select CharName16 From [SRO_VT_SHARD].[dbo].[_Char] where CharID=@Top_HU)
Set @CheckHwanlevel = (SELECT HwanLevel FROM [SRO_VT_SHARD].[dbo].[_Char] Where CharName16 = @CharName3)
Select @Count = Points,@Notice=notice,@HwanTitle = HwanLevel ,@Reward1=Reward1,@Reward2=Reward2,@Reward3=Reward 3,@Num1=Num1,@Num2=Num2,@Num3=Num3,@Silkown=Silk_O wn,@Silkgift=Silk_Gift,@Plus1=Plus1,@Plus2=Plus2,@ Plus3=Plus3 From [SRO_VT_SHARDLOG].[dbo].[Top_Jop_System] Where JopType = '3'
Set @CharNameOld = (SELECT CharName16 FROM [SRO_VT_SHARD].[dbo].[_Char] Where HwanLevel = @HwanTitle)
Set @Hwanlevelchange = (SELECT OldHwan FROM [SRO_VT_SHARDLOG].[dbo].[_OldTitles_Jop] Where CharName=@CharNameOld)
IF @PointsHU >= @Count
BEGIN
-- Take the title from the player
IF Not EXISTS (Select Oldhwan From SRO_VT_SHARDLOG.dbo._OldTitles_jop where CharName=@CharName3)
Begin
Insert Into [SRO_VT_SHARDLOG].[dbo].[_OldTitles_jop] ([CharName],[OldHwan],[UName]) Values (@CharName3,@CheckHwanlevel,@HwanTitle)
END
IF EXISTS (Select Oldhwan From SRO_VT_SHARDLOG.dbo._OldTitles_jop where CharName=@CharName3)
IF (@CheckHwanlevel Not In (Select Hwanlevel From [SRO_VT_SHARDLOG].[dbo].[Top_Jop_System]))
BEGIN
UPDATE [SRO_VT_SHARDLOG].[dbo].[_OldTitles_jop] Set OldHwan=@CheckHwanlevel , UName=@HwanTitle where CharName=@CharName3
END
UPDATE [SRO_VT_SHARD].[dbo].[_Char] SET HwanLevel = @Hwanlevelchange where CharName16 = @CharNameOld
-- Adding the title to the new player
IF(@HwanTitle > '0')
Begin
UPDATE [SRO_VT_SHARD].[dbo].[_Char] set HwanLevel = @HwanTitle where CharName16 = @CharName3
END
-- Item Reward
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName1,@Reward1,@Num1,@Plus1
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName1,@Reward2,@Num2,@Plus2
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName1,@Reward3,@Num3,@Plus3
EXEC SRO_VT_ACCOUNT.[CGI].[CGI_WebPurchaseSilk_Own] @UserID,@Silkown
EXEC SRO_VT_ACCOUNT.[CGI].[CGI_WebPurchaseSilk_Gift] @UserID,@Silkgift
-- Notice Lines To show All server this char is Hero
insert into [SRO_VT_SHARDLOG].[dbo].[iLegend_Tool] ([Service],[Type],[Message],[Date]) Values ('1','Notice',' *** '+@CharName3+'*** , '+@Notice+'',GETDATE())
-- Delete Log Unique From Table
DELETE from [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] where JopType = '3'
END

/* End Hunter Section */


_Job_Coin
USE [SRO_VT_SHARDLOG]
GO
/****** Object: StoredProcedure [dbo].[_Job_Coin] Script Date: 20/04/2016 04:50:32 ص ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO





-- =============================================
-- Author: Abdelrhman Elbattawy
-- =============================================

ALTER procedure [dbo].[_Job_Coin]
@CharID int
as
---------- Main & Select Declares ----------------------
DECLARE @JobType int ,@Contri bigint ,@CurLevel int ,@UserJID int , @Points int ,@CharName varchar(20),@Reqlevel int,@Reward_1_3Star varchar(max),@Reward_2_3Star varchar(max),@Reward_3_3Star varchar(max),@Num_1_3Star int,@Num_2_3Star int,@Num_3_3Star int
,@Reward_1_4Star varchar(max),@Reward_2_4Star varchar(max),@Reward_3_4Star varchar(max),@Num_1_4Star int,@Num_2_4Star int,@Num_3_4Star int,@Gold_3Star bigint,@Gold_4Star bigint,@Gold_5Star bigint
,@Reward_1_5Star varchar(max),@Reward_2_5Star varchar(max),@Reward_3_5Star varchar(max),@Num_1_5Star int,@Num_2_5Star int,@Num_3_5Star int,@Gold_2Star bigint,@Gold_1Star bigint
,@Reward_1_2Star varchar(max),@Reward_2_2Star varchar(max),@Reward_3_2Star varchar(max),@Num_1_2Star int,@Num_2_2Star int,@Num_3_2Star int
,@Reward_1_1Star varchar(max),@Reward_2_1Star varchar(max),@Reward_3_1Star varchar(max),@Num_1_1Star int,@Num_2_1Star int,@Num_3_1Star int
Set @JobType = (Select JobType From [SRO_VT_SHARD].[dbo].[_CharTrijob] where CharID=@CharID)
Set @CurLevel = (Select CurLevel From [SRO_VT_SHARD].[dbo].[_Char] where CharID=@CharID)
Set @UserJID = (Select userjid FROM [SRO_VT_SHARD].[dbo].[_User] where CharID = @CharID)
Set @Contri = (Select Contribution From [SRO_VT_SHARD].[dbo].[_CharTrijob] where CharID=@CharID)
Set @Points = (Select Points From [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] where CharID=@CharID And JopType='1')
Set @CharName =(Select CharName16 From [SRO_VT_SHARD].[dbo].[_Char] where CharID=@CharID)
Declare @Remaingold bigint = (Select RemainGold From [SRO_VT_SHARD].[dbo].[_Char] where CharID=@CharID)
---------- Start Trader System ----------------------
Select @Reqlevel=Curlevel , @Reward_1_3Star=Reward_1_3Star ,@Num_1_3Star=Num_1_3Star ,@Reward_2_3Star=Reward_2_3Star,@Num_2_3Star=Num_2 _3Star ,@Reward_3_3Star=Reward_3_3Star,@Num_3_3Star=Num_3 _3Star
,@Reward_1_4Star=Reward_1_4Star ,@Num_1_4Star=Num_1_4Star ,@Reward_2_4Star=Reward_2_4Star,@Num_2_4Star=Num_2 _4Star ,@Reward_3_4Star=Reward_3_4Star,@Num_3_4Star=Num_3 _4Star,@Gold_3Star = Gold_3Star,@Gold_4Star = Gold_4Star,@Gold_5Star = Gold_5Star
,@Reward_1_5Star=Reward_1_5Star ,@Num_1_5Star=Num_1_5Star ,@Reward_2_5Star=Reward_2_5Star,@Num_2_5Star=Num_2 _5Star ,@Reward_3_5Star=Reward_3_5Star,@Num_3_5Star=Num_3 _5Star,@Gold_2Star = Gold_2Star
,@Reward_1_2Star=Reward_1_2Star ,@Num_1_2Star=Num_1_2Star ,@Reward_2_2Star=Reward_2_2Star,@Num_2_2Star=Num_2 _2Star ,@Reward_3_2Star=Reward_3_2Star,@Num_3_2Star=Num_3 _2Star,@Gold_1Star = Gold_1Star
,@Reward_1_1Star=Reward_1_1Star ,@Num_1_1Star=Num_1_1Star ,@Reward_2_1Star=Reward_2_1Star,@Num_2_1Star=Num_2 _1Star ,@Reward_3_1Star=Reward_3_1Star,@Num_3_1Star=Num_3 _1Star From [SRO_VT_SHARDLOG].[dbo].[Job_Reward] where JopType='1'
/* 1 Star Section */
IF (@JobType = '1' AND @Contri BETWEEN '2420' And '48400')
BEGIN
UPDATE SRO_VT_SHARD.dbo._CharTrijob SET Contribution = '0' WHERE CharID = @CharID
UPDATE [SRO_VT_SHARD].[dbo].[_Char] Set RemainGold = @Remaingold + @Gold_1Star where CharID=@CharID
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName,@Reward_1_1Star,@Num_1_1Star,0
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName,@Reward_2_1Star,@Num_2_1Star,0
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName,@Reward_3_1Star,@Num_3_1Star,0
UPDATE [SRO_VT_SHARD].[dbo].[_CharTrijob] SET Contribution = '0' WHERE CharID = @CharID
Insert Into [SRO_VT_SHARDLOG].[dbo].[iLegend_Tool] (Service,Type,Target,Message,Date) Values (1,'Private',@CharName,'u have achieved star 1, ur points not increased',Getdate())
END

/* 2 Star Section */
IF (@JobType = '1' AND @Contri BETWEEN '50820' And '87120')
BEGIN
UPDATE SRO_VT_SHARD.dbo._CharTrijob SET Contribution = '0' WHERE CharID = @CharID
UPDATE [SRO_VT_SHARD].[dbo].[_Char] Set RemainGold = @Remaingold + @Gold_2Star where CharID=@CharID
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName,@Reward_1_2Star,@Num_1_2Star,0
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName,@Reward_2_2Star,@Num_2_2Star,0
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName,@Reward_3_2Star,@Num_3_2Star,0
UPDATE [SRO_VT_SHARD].[dbo].[_CharTrijob] SET Contribution = '0' WHERE CharID = @CharID
Insert Into [SRO_VT_SHARDLOG].[dbo].[iLegend_Tool] (Service,Type,Target,Message,Date) Values (1,'Private',@CharName,'u have achieved star 2, ur points not increased',Getdate())
END

/* 3 Star Section */
IF (@JobType = '1' AND @Contri BETWEEN '89540' And '137940')
BEGIN
UPDATE SRO_VT_SHARD.dbo._CharTrijob SET Contribution = '0' WHERE CharID = @CharID
UPDATE [SRO_VT_SHARD].[dbo].[_Char] Set RemainGold = @Remaingold + @Gold_3Star where CharID=@CharID
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName,@Reward_1_3Star,@Num_1_3Star,0
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName,@Reward_2_3Star,@Num_2_3Star,0
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName,@Reward_3_3Star,@Num_3_3Star,0
UPDATE [SRO_VT_SHARD].[dbo].[_CharTrijob] SET Contribution = '0' WHERE CharID = @CharID
Insert Into [SRO_VT_SHARDLOG].[dbo].[iLegend_Tool] (Service,Type,Target,Message,Date) Values (1,'Private',@CharName,'u have achieved star 3, ur point now increased +1',Getdate())
IF Not EXISTS (Select Points From [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] where CharID=@CharID And JopType='1')
Begin
Insert Into [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] ([CharID],[Charname],[JopType],[Points]) Values (@CharID,@CharName,'1','1')
END
IF EXISTS (Select Points From [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] where CharID=@CharID And JopType='1')
BEGIN
UPDATE [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] Set charname=@Charname , Points=@Points + 1 where CharID=@CharID And JopType='1'
END
END

/* 4 Star Section */
IF (@JobType = '1' AND @Contri BETWEEN '140360' And '205700')
BEGIN
UPDATE SRO_VT_SHARD.dbo._CharTrijob SET Contribution = '0' WHERE CharID = @CharID
UPDATE [SRO_VT_SHARD].[dbo].[_Char] Set RemainGold = @Remaingold + @Gold_4Star where CharID=@CharID
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName,@Reward_1_4Star,@Num_1_4Star,0
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName,@Reward_2_4Star,@Num_2_4Star,0
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName,@Reward_3_4Star,@Num_3_4Star,0
UPDATE [SRO_VT_SHARD].[dbo].[_CharTrijob] SET Contribution = '0' WHERE CharID = @CharID
Insert Into [SRO_VT_SHARDLOG].[dbo].[iLegend_Tool] (Service,Type,Target,Message,Date) Values (1,'Private',@CharName,'u have achieved star 4, ur point now increased +2',Getdate())
IF Not EXISTS (Select Points From [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] where CharID=@CharID And JopType='1')
Begin
Insert Into [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] ([CharID],[Charname],[JopType],[Points]) Values (@CharID,@CharName,'1','2')
END
IF EXISTS (Select Points From [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] where CharID=@CharID And JopType='1')
BEGIN
UPDATE [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] Set charname=@Charname , Points=@Points + 2 where CharID=@CharID And JopType='1'
END
END

/* 5 Star Section */
IF (@JobType = '1' AND @Contri BETWEEN '208120' And '384780')
BEGIN
UPDATE SRO_VT_SHARD.dbo._CharTrijob SET Contribution = '0' WHERE CharID = @CharID
UPDATE [SRO_VT_SHARD].[dbo].[_Char] Set RemainGold = @Remaingold + @Gold_5Star where CharID=@CharID
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName,@Reward_1_5Star,@Num_1_5Star,0
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName,@Reward_2_5Star,@Num_2_5Star,0
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName,@Reward_3_5Star,@Num_3_5Star,0
UPDATE [SRO_VT_SHARD].[dbo].[_CharTrijob] SET Contribution = '0' WHERE CharID = @CharID
Insert Into [SRO_VT_SHARDLOG].[dbo].[iLegend_Tool] (Service,Type,Target,Message,Date) Values (1,'Private',@CharName,'u have achieved star 5, ur point now increased +3',Getdate())
IF Not EXISTS (Select Points From [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] where CharID=@CharID And JopType='1')
Begin
Insert Into [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] ([CharID],[Charname],[JopType],[Points]) Values (@CharID,@CharName,'1','3')
END
IF EXISTS (Select Points From [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] where CharID=@CharID And JopType='1')
BEGIN
UPDATE [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] Set charname=@Charname , Points=@Points + 3 where CharID=@CharID And JopType='1'
END
END
---------- End Trader System ----------------------
----------- Start Hunter System ----------------------
Set @Points = (Select Points From [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] where CharID=@CharID And JopType='3')
Select @Reqlevel=Curlevel , @Reward_1_3Star=Reward_1_3Star ,@Num_1_3Star=Num_1_3Star ,@Reward_2_3Star=Reward_2_3Star,@Num_2_3Star=Num_2 _3Star ,@Reward_3_3Star=Reward_3_3Star,@Num_3_3Star=Num_3 _3Star
,@Reward_1_4Star=Reward_1_4Star ,@Num_1_4Star=Num_1_4Star ,@Reward_2_4Star=Reward_2_4Star,@Num_2_4Star=Num_2 _4Star ,@Reward_3_4Star=Reward_3_4Star,@Num_3_4Star=Num_3 _4Star,@Gold_3Star = Gold_3Star,@Gold_4Star = Gold_4Star,@Gold_5Star = Gold_5Star
,@Reward_1_5Star=Reward_1_5Star ,@Num_1_5Star=Num_1_5Star ,@Reward_2_5Star=Reward_2_5Star,@Num_2_5Star=Num_2 _5Star ,@Reward_3_5Star=Reward_3_5Star,@Num_3_5Star=Num_3 _5Star,@Gold_2Star = Gold_2Star
,@Reward_1_2Star=Reward_1_2Star ,@Num_1_2Star=Num_1_2Star ,@Reward_2_2Star=Reward_2_2Star,@Num_2_2Star=Num_2 _2Star ,@Reward_3_2Star=Reward_3_2Star,@Num_3_2Star=Num_3 _2Star,@Gold_1Star = Gold_1Star
,@Reward_1_1Star=Reward_1_1Star ,@Num_1_1Star=Num_1_1Star ,@Reward_2_1Star=Reward_2_1Star,@Num_2_1Star=Num_2 _1Star ,@Reward_3_1Star=Reward_3_1Star,@Num_3_1Star=Num_3 _1Star From [SRO_VT_SHARDLOG].[dbo].[Job_Reward] where JopType='3'
/* 1 Star Section */
IF (@JobType = '3' AND @Contri BETWEEN '1776' And '35520')
BEGIN
UPDATE SRO_VT_SHARD.dbo._CharTrijob SET Contribution = '0' WHERE CharID = @CharID
UPDATE [SRO_VT_SHARD].[dbo].[_Char] Set RemainGold = @Remaingold + @Gold_1Star where CharID=@CharID
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName,@Reward_1_1Star,@Num_1_1Star,0
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName,@Reward_2_1Star,@Num_2_1Star,0
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName,@Reward_3_1Star,@Num_3_1Star,0
UPDATE [SRO_VT_SHARD].[dbo].[_CharTrijob] SET Contribution = '0' WHERE CharID = @CharID
Insert Into [SRO_VT_SHARDLOG].[dbo].[iLegend_Tool] (Service,Type,Target,Message,Date) Values (1,'Private',@CharName,'u have achieved star 1, ur points not increased',Getdate())
END

/* 2 Star Section */
IF (@JobType = '3' AND @Contri BETWEEN '37296' And '63936')
BEGIN
UPDATE SRO_VT_SHARD.dbo._CharTrijob SET Contribution = '0' WHERE CharID = @CharID
UPDATE [SRO_VT_SHARD].[dbo].[_Char] Set RemainGold = @Remaingold + @Gold_2Star where CharID=@CharID
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName,@Reward_1_2Star,@Num_1_2Star,0
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName,@Reward_2_2Star,@Num_2_2Star,0
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName,@Reward_3_2Star,@Num_3_2Star,0
UPDATE [SRO_VT_SHARD].[dbo].[_CharTrijob] SET Contribution = '0' WHERE CharID = @CharID
Insert Into [SRO_VT_SHARDLOG].[dbo].[iLegend_Tool] (Service,Type,Target,Message,Date) Values (1,'Private',@CharName,'u have achieved star 2, ur points not increased',Getdate())
END

/* 3 Star Section */
IF (@JobType = '3' AND @CurLevel >= @Reqlevel AND @Contri BETWEEN '65712' And '101232')
BEGIN
UPDATE SRO_VT_SHARD.dbo._CharTrijob SET Contribution = '0' WHERE CharID = @CharID
UPDATE [SRO_VT_SHARD].[dbo].[_Char] Set RemainGold = @Remaingold + @Gold_3Star where CharID=@CharID
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName,@Reward_1_3Star,@Num_1_3Star,0
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName,@Reward_2_3Star,@Num_2_3Star,0
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName,@Reward_3_3Star,@Num_3_3Star,0
UPDATE [SRO_VT_SHARD].[dbo].[_CharTrijob] SET Contribution = '0' WHERE CharID = @CharID
Insert Into [SRO_VT_SHARDLOG].[dbo].[iLegend_Tool] (Service,Type,Target,Message,Date) Values (1,'Private',@CharName,'u have achieved star 3, ur point now increased +1',Getdate())
IF Not EXISTS (Select Points From [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] where CharID=@CharID And JopType='3')
Begin
Insert Into [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] ([CharID],[Charname],[JopType],[Points]) Values (@CharID,@CharName,'3','1')
END
IF EXISTS (Select Points From [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] where CharID=@CharID And JopType='3')
BEGIN
UPDATE [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] Set charname=@Charname , Points=@Points + 1 where CharID=@CharID And JopType='3'
END
END
/* 4 Star Section */
IF (@JobType = '3' AND @CurLevel >= @Reqlevel AND @Contri BETWEEN '103008' And '150960')
BEGIN
UPDATE SRO_VT_SHARD.dbo._CharTrijob SET Contribution = '0' WHERE CharID = @CharID
UPDATE [SRO_VT_SHARD].[dbo].[_Char] Set RemainGold = @Remaingold + @Gold_4Star where CharID=@CharID
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName,@Reward_1_4Star,@Num_1_4Star,0
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName,@Reward_2_4Star,@Num_2_4Star,0
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName,@Reward_3_4Star,@Num_3_4Star,0
UPDATE [SRO_VT_SHARD].[dbo].[_CharTrijob] SET Contribution = '0' WHERE CharID = @CharID
Insert Into [SRO_VT_SHARDLOG].[dbo].[iLegend_Tool] (Service,Type,Target,Message,Date) Values (1,'Private',@CharName,'u have achieved star 4, ur point now increased +2',Getdate())
IF Not EXISTS (Select Points From [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] where CharID=@CharID And JopType='3')
Begin
Insert Into [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] ([CharID],[Charname],[JopType],[Points]) Values (@CharID,@CharName,'3','2')
END
IF EXISTS (Select Points From [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] where CharID=@CharID And JopType='3')
BEGIN
UPDATE [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] Set charname=@Charname , Points=@Points + 2 where CharID=@CharID And JopType='3'
END
END
/* 5 Star Section */
IF (@JobType = '3' AND @CurLevel >= @Reqlevel AND @Contri BETWEEN '152736' And '282384')
BEGIN
UPDATE SRO_VT_SHARD.dbo._CharTrijob SET Contribution = '0' WHERE CharID = @CharID
UPDATE [SRO_VT_SHARD].[dbo].[_Char] Set RemainGold = @Remaingold + @Gold_5Star where CharID=@CharID
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName,@Reward_1_5Star,@Num_1_5Star,0
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName,@Reward_2_5Star,@Num_2_5Star,0
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName,@Reward_3_5Star,@Num_3_5Star,0
UPDATE [SRO_VT_SHARD].[dbo].[_CharTrijob] SET Contribution = '0' WHERE CharID = @CharID
Insert Into [SRO_VT_SHARDLOG].[dbo].[iLegend_Tool] (Service,Type,Target,Message,Date) Values (1,'Private',@CharName,'u have achieved star 5, ur point now increased +3',Getdate())
IF Not EXISTS (Select Points From [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] where CharID=@CharID And JopType='3')
Begin
Insert Into [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] ([CharID],[Charname],[JopType],[Points]) Values (@CharID,@CharName,'3','3')
END
IF EXISTS (Select Points From [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] where CharID=@CharID And JopType='3')
BEGIN
UPDATE [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] Set charname=@Charname , Points=@Points + 3 where CharID=@CharID And JopType='3'
END
END
----------- End Hunter System ------------------------


----------- Start Thieves System ----------------------
Set @Points = (Select Points From [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] where CharID=@CharID And JopType='2')
Select @Reqlevel=Curlevel , @Reward_1_3Star=Reward_1_3Star ,@Num_1_3Star=Num_1_3Star ,@Reward_2_3Star=Reward_2_3Star,@Num_2_3Star=Num_2 _3Star ,@Reward_3_3Star=Reward_3_3Star,@Num_3_3Star=Num_3 _3Star
,@Reward_1_4Star=Reward_1_4Star ,@Num_1_4Star=Num_1_4Star ,@Reward_2_4Star=Reward_2_4Star,@Num_2_4Star=Num_2 _4Star ,@Reward_3_4Star=Reward_3_4Star,@Num_3_4Star=Num_3 _4Star,@Gold_3Star = Gold_3Star,@Gold_4Star = Gold_4Star,@Gold_5Star = Gold_5Star
,@Reward_1_5Star=Reward_1_5Star ,@Num_1_5Star=Num_1_5Star ,@Reward_2_5Star=Reward_2_5Star,@Num_2_5Star=Num_2 _5Star ,@Reward_3_5Star=Reward_3_5Star,@Num_3_5Star=Num_3 _5Star,@Gold_2Star = Gold_2Star
,@Reward_1_2Star=Reward_1_2Star ,@Num_1_2Star=Num_1_2Star ,@Reward_2_2Star=Reward_2_2Star,@Num_2_2Star=Num_2 _2Star ,@Reward_3_2Star=Reward_3_2Star,@Num_3_2Star=Num_3 _2Star,@Gold_1Star = Gold_1Star
,@Reward_1_1Star=Reward_1_1Star ,@Num_1_1Star=Num_1_1Star ,@Reward_2_1Star=Reward_2_1Star,@Num_2_1Star=Num_2 _1Star ,@Reward_3_1Star=Reward_3_1Star,@Num_3_1Star=Num_3 _1Star From [SRO_VT_SHARDLOG].[dbo].[Job_Reward] where JopType='2'
/* 1 Star Section */
IF (@JobType = '2' AND @Contri BETWEEN '6128' And '122560')
BEGIN
UPDATE SRO_VT_SHARD.dbo._CharTrijob SET Contribution = '0' WHERE CharID = @CharID
UPDATE [SRO_VT_SHARD].[dbo].[_Char] Set RemainGold = @Remaingold + @Gold_1Star where CharID=@CharID
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName,@Reward_1_1Star,@Num_1_1Star,0
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName,@Reward_2_1Star,@Num_2_1Star,0
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName,@Reward_3_1Star,@Num_3_1Star,0
UPDATE [SRO_VT_SHARD].[dbo].[_CharTrijob] SET Contribution = '0' WHERE CharID = @CharID
Insert Into [SRO_VT_SHARDLOG].[dbo].[iLegend_Tool] (Service,Type,Target,Message,Date) Values (1,'Private',@CharName,'u have achieved star 1, ur points not increased',Getdate())
END

/* 2 Star Section */
IF (@JobType = '2' AND @Contri BETWEEN '128688' And '220608')
BEGIN
UPDATE SRO_VT_SHARD.dbo._CharTrijob SET Contribution = '0' WHERE CharID = @CharID
UPDATE [SRO_VT_SHARD].[dbo].[_Char] Set RemainGold = @Remaingold + @Gold_2Star where CharID=@CharID
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName,@Reward_1_2Star,@Num_1_2Star,0
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName,@Reward_2_2Star,@Num_2_2Star,0
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName,@Reward_3_2Star,@Num_3_2Star,0
UPDATE [SRO_VT_SHARD].[dbo].[_CharTrijob] SET Contribution = '0' WHERE CharID = @CharID
Insert Into [SRO_VT_SHARDLOG].[dbo].[iLegend_Tool] (Service,Type,Target,Message,Date) Values (1,'Private',@CharName,'u have achieved star 2, ur points not increased',Getdate())
END

/* 3 Star Section */
IF (@JobType = '2' AND @CurLevel >= @Reqlevel AND @Contri BETWEEN '226736' And '349296')
BEGIN
UPDATE SRO_VT_SHARD.dbo._CharTrijob SET Contribution = '0' WHERE CharID = @CharID
UPDATE [SRO_VT_SHARD].[dbo].[_Char] Set RemainGold = @Remaingold + @Gold_3Star where CharID=@CharID
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName,@Reward_1_3Star,@Num_1_3Star,0
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName,@Reward_2_3Star,@Num_2_3Star,0
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName,@Reward_3_3Star,@Num_3_3Star,0
UPDATE [SRO_VT_SHARD].[dbo].[_CharTrijob] SET Contribution = '0' WHERE CharID = @CharID
Insert Into [SRO_VT_SHARDLOG].[dbo].[iLegend_Tool] (Service,Type,Target,Message,Date) Values (1,'Private',@CharName,'u have achieved star 3, ur point now increased +1',Getdate())
IF Not EXISTS (Select Points From [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] where CharID=@CharID And JopType='2')
Begin
Insert Into [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] ([CharID],[Charname],[JopType],[Points]) Values (@CharID,@CharName,'2','1')
END
IF EXISTS (Select Points From [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] where CharID=@CharID And JopType='2')
BEGIN
UPDATE [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] Set charname=@Charname , Points=@Points + 1 where CharID=@CharID And JopType='2'
END
END
/* 4 Star Section */
IF (@JobType = '2' AND @CurLevel >= @Reqlevel AND @Contri BETWEEN '355424' And '520880')
BEGIN
UPDATE SRO_VT_SHARD.dbo._CharTrijob SET Contribution = '0' WHERE CharID = @CharID
UPDATE [SRO_VT_SHARD].[dbo].[_Char] Set RemainGold = @Remaingold + @Gold_4Star where CharID=@CharID
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName,@Reward_1_4Star,@Num_1_4Star,0
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName,@Reward_2_4Star,@Num_2_4Star,0
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName,@Reward_3_4Star,@Num_3_4Star,0
UPDATE [SRO_VT_SHARD].[dbo].[_CharTrijob] SET Contribution = '0' WHERE CharID = @CharID
Insert Into [SRO_VT_SHARDLOG].[dbo].[iLegend_Tool] (Service,Type,Target,Message,Date) Values (1,'Private',@CharName,'u have achieved star 4, ur point now increased +2',Getdate())
IF Not EXISTS (Select Points From [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] where CharID=@CharID And JopType='2')
Begin
Insert Into [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] ([CharID],[Charname],[JopType],[Points]) Values (@CharID,@CharName,'2','2')
END
IF EXISTS (Select Points From [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] where CharID=@CharID And JopType='2')
BEGIN
UPDATE [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] Set charname=@Charname , Points=@Points + 2 where CharID=@CharID And JopType='2'
END
END
/* 5 Star Section */
IF (@JobType = '2' AND @CurLevel >= @Reqlevel AND @Contri BETWEEN '527008' And '974352')
BEGIN
UPDATE SRO_VT_SHARD.dbo._CharTrijob SET Contribution = '0' WHERE CharID = @CharID
UPDATE [SRO_VT_SHARD].[dbo].[_Char] Set RemainGold = @Remaingold + @Gold_5Star where CharID=@CharID
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName,@Reward_1_5Star,@Num_1_5Star,0
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName,@Reward_2_5Star,@Num_2_5Star,0
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName,@Reward_3_5Star,@Num_3_5Star,0
UPDATE [SRO_VT_SHARD].[dbo].[_CharTrijob] SET Contribution = '0' WHERE CharID = @CharID
Insert Into [SRO_VT_SHARDLOG].[dbo].[iLegend_Tool] (Service,Type,Target,Message,Date) Values (1,'Private',@CharName,'u have achieved star 5, ur point now increased +3',Getdate())
IF Not EXISTS (Select Points From [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] where CharID=@CharID And JopType='2')
Begin
Insert Into [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] ([CharID],[Charname],[JopType],[Points]) Values (@CharID,@CharName,'2','3')
END
IF EXISTS (Select Points From [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] where CharID=@CharID And JopType='2')
BEGIN
UPDATE [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] Set charname=@Charname , Points=@Points + 3 where CharID=@CharID And JopType='2'
END
END
----------- End Thieves System ------------------------




و طبعا addlogchar

لا سيسنم شغال ومفهوش مشاكل لما ارجع انشاء الله من السفر
هعمل فيدبو ازاي تضيفو صح

[PirateKings]

لا سيسنم شغال ومفهوش مشاكل لما ارجع انشاء الله من السفر
هعمل فيدبو ازاي تضيفو صح

طب في ايه ماهو كل حاجة صح :]

[Mr.Viper]

تسلم ايدك

[elbattawy1st]

تسلم ايدك

شكراا لمرورك ^_^

[elbattawy1st]

تم اضافة فيديو شرح تشغيل السيستم

[Jayden]

تسلم يا كبير .. مجهودك واضح ما شاء الله
مع ان فى Procedure اسرع من كده وده بالنسباله بطىء جدا بس تشكر على موضوعك

[elbattawy1st]

تسلم يا كبير .. مجهودك واضح ما شاء الله
مع ان فى Procedure اسرع من كده وده بالنسباله بطىء جدا بس تشكر على موضوعك

شكراا لمرورك
فى بروسيدور الاسرع انت قصدك الا هوا مستخدم فية Case when then
؟؟؟
وبرضو لو مكنتش عملت declares و select لتابل بتاع Reward
كان ممكن يكون اقل من كده يعنى كنت ممكن اعملو فى 5 سطور بكتير بس فى ناس مش بتعرف تعدل فى البروسيدور و انا كنت اولهم لما كنت باخد جاجة من على النت مكنتش بعرف اعدل على البروسيدور علشان
كده حبيت اسهل الموضوع على الناس
وانشاء الله فى اى system جديد هعملو هحاول اعملو يكون اسرع و اقل و شكراا للملاحظة ^_^

[Dev.LumiusCux]

الله ينور واللهي شغل ميه ميه اعقبال الي في بلنا يتعمل:specool:

[elbattawy1st]

الله ينور واللهي شغب ميه ميه اعقبال البي بلنا يتعمل:specool:

انشاء الله قريب ^_^

[Last_Fiddler]

تسلم ايدك على الموضوع الجميل ده بس فى تعليق
انا جربته اشتغال الريورد بتاع التريده بس نظام البوينت مش شغال ارجو التاكيد عليه

[elbattawy1st]

تسلم ايدك على الموضوع الجميل ده بس فى تعليق
انا جربته اشتغال الريورد بتاع التريده بس نظام البوينت مش شغال ارجو التاكيد عليه

شغال تمام مفهوش مشاكل ممكن يكون العيب من عندك انت ^_^

[Last_Fiddler]

طب ممكن حضرتك تيجى تيم فيور وتتاكد بنفسك

[Last_Fiddler]

انا اسكى بى بتاعى
badr.mohamed15

[elbattawy1st]

انا اسكى بى بتاعى
badr.mohamed15

تمام لما اجي انشاء الله من السفر يوم الخميس هعملهولك

[Last_Fiddler]

توصل بالسلامه ان شاء الله

[Cru3L1337]

انا جربت السيستك بتاعك بتاع الJob و كل حاجة تمام بس المشكلة ان عدد الجولد الي انا كتبوا في * Gold_5star مش هو الي بيجي بعد ما اعمل التريد و كمان مفيش Reward بتيجي من الي انا محددها انا محدد يجيب ITEM_SD_TOKEN_04
مفيش حاجة بتيجي خاالص حتي بعد ما اعمل ريستارت للكاركتر

[MrBlackHeart]

i can not get the system to give any rewards. everything went into sql with no problems but not working.. can i get some help ? bocc1337 skype thx

[fefe2010]

يا ريت تعمل شرح فيديو للكلام دة
لان انا مش عارف احط ال php code دة فين بصراحة
:]
و على العموم تسلم ايدك بجد
^_^

[kareemeljooe]

الـ Contribution عندي أعلى بكتير من الأرقام اللي بتطلع .. أظبطها ازاي ، أعرف نسبة Contribution بتطلع بناءاً عليه إزاي ؟ :):hammer:

[elbattawy1st]

الـ Contribution عندي أعلى بكتير من الأرقام اللي بتطلع .. أظبطها ازاي ، أعرف نسبة Contribution بتطلع بناءاً عليه إزاي ؟ :):hammer:

عادي يامعلم ضيف الارقام بتاعتك و حطها في البروسيدور بدل الارقام بتاعتي

[ابو ليلى]

دى حاجة وعمل كل اللى حضرتك قلت علية الريورد مش شغال وعملت ريتيرن وتليبورت مفيش ريورد بيجى
وفى نقطة البوينت حضرتك قلت ان اللاعب لما يجيب اعلى نقطة بياخد تيتل او ريويرد انا محددو ولما يجى لاعب تانى يعدى ترجع الاعب الاولانى لى التيتل بتاعو زى مكان
هنا السؤال هل ينفع
اخالى المنافسة تبقى ع اول 5 بلاير مثلا يجيبو ال 500 بوينت يخدو الهونر بف
ولو حد عدى ال500 بوينت واحد من دول يتشال من علية الهونر بف
نفس فكرة الاكادمى بدل متعمل شخصيات وتلفلها
ويجى واحد يعمل شخصيات اكتر منو عشان ياخد الهونر بف
ينفع ولا لا

[elbattawy1st]

دى حاجة وعمل كل اللى حضرتك قلت علية الريورد مش شغال وعملت ريتيرن وتليبورت مفيش ريورد بيجى
وفى نقطة البوينت حضرتك قلت ان اللاعب لما يجيب اعلى نقطة بياخد تيتل او ريويرد انا محددو ولما يجى لاعب تانى يعدى ترجع الاعب الاولانى لى التيتل بتاعو زى مكان
هنا السؤال هل ينفع
اخالى المنافسة تبقى ع اول 5 بلاير مثلا يجيبو ال 500 بوينت يخدو الهونر بف
ولو حد عدى ال500 بوينت واحد من دول يتشال من علية الهونر بف
نفس فكرة الاكادمى بدل متعمل شخصيات وتلفلها
ويجى واحد يعمل شخصيات اكتر منو عشان ياخد الهونر بف
ينفع ولا لا


بالنسبه لموضوع ال reward لازم تعمل relog علشان تاخد reward وانا عامل الموضوع دا علشان cheate الابيحصل في الجيم و لو مخدتش reward يبقي كدا ارقام contributions الاعندك مش زي الموجوده في البروسيدور فالازم تغيرها علشان السيستم يشتغل معاك و لو معرفتش تغيرها استني لحد ما انزل شرح تغيرها في الموضوع انشاى الله
بالنسبه لموضوع النقاط انا كنت قايل انك بتحدد عدد معين من النقاط مثلا 500 و اول لاعب يوصل لنقاط دي هياخد reward و تيتل و بعد كدا السيستم هيبدا من جديد بمعني ان هيتمسح اي نقاط الناس خدتها قبل كدا و هيبدا يعد من جديد لحد مايوصل لاعب تاني لعدد 500 قبل الاول و ياخد منه التيتل و يبدا السيستم من جديد و هكذا......

[elbattawy1st]

اما بالنسه لموضوع الاكاديمي سهل انك تعدل علي الاكواد البروسيدور و تعمل اي فكره انت عاوزها
و ممكن تبدا بموضوع العضو jayden الا هوا advanced job reward
هوا هناك ضايف نظام الاكاديمي بس بفكره مختلفه عن بتاعتك بمعني ان كل ما حد يطلع تريد ياخد نقاط اكاديمي بس لازم يكون عامل الاكاديمي الاول فاانت بقي شوف جزء الاكاديمي عنده في البروسيدور و حاول تبدا من هناك و واحدة واحدة هتوصل لاانت عاوزه انشاء الله و لو في اي مشاكل قابلتك انا موجود و انشاء الله هاحلها و اسف علي الاطاله ^_^

[Jayden]

اما بالنسه لموضوع الاكاديمي سهل انك تعدل علي الاكواد البروسيدور و تعمل اي فكره انت عاوزها
و ممكن تبدا بموضوع العضو jayden الا هوا advanced job reward
هوا هناك ضايف نظام الاكاديمي بس بفكره مختلفه عن بتاعتك بمعني ان كل ما حد يطلع تريد ياخد نقاط اكاديمي بس لازم يكون عامل الاكاديمي الاول فاانت بقي شوف جزء الاكاديمي عنده في البروسيدور و حاول تبدا من هناك و واحدة واحدة هتوصل لاانت عاوزه انشاء الله و لو في اي مشاكل قابلتك انا موجود و انشاء الله هاحلها و اسف علي الاطاله ^_^
أنا عامل انه لو مش عامل Academy السيستم هيعمله واحده
عيب عليك :peace:

[elbattawy1st]

أنا عامل انه لو مش عامل Academy السيستم هيعمله واحده
عيب عليك :peace:

اها تمام الغلطه منى سورى ^_^

[Jayden]

اها تمام الغلطه منى سورى ^_^

ولا يهمك يا باشا

[ronz]

bump un working

[Dev.Ri3o]

bump un working

الموضوع شغال 100% وانا عن نفس مجربو وشغال ... اى مشكلة او استفسار اكتبها فى قسم الاسئلة والاستفسارات

[mohamedAhmed1]

ل reward عملت التريده مرتين وجه فيه الى الحجة الى محدده مره تلاته مش ردى يجيب رورد خالص جربت كذا مره منفعش عملت اكونت جديد وجربت جبلى ريورد مرتين بعد كدا مجبش حجه مع العلم انى جربت اعمل من downhand ل jangan و من hotan ل jangan فيش اى حجه بيجى غير متعمل اكونت جديد

[Helper4You]

الله ينور :thumb_yello: بس مش فاهم حاجه عشان الموقع مش مضبوط يا ريت الاداره تشوف حل فى الاستايل

[TheBold]

موضوع هايل ودا متوقع منك ^^

تسلم ايدك

فعلاً بطاوي شكله على وضعه

[™Kabloz]

الله ينور تسـلـممم :111 (27):

[eslamsaied]

تسلم ايدك بس ياتري في طريقة اخلي البلاير يكلم الداتا ويسألها علي كمية الpoint اللي معاه والداتا ترد عليه بكمية الpoint اللي معاه فعلا ؟؟

[akai]

عملت الموضوع مرتين و مشتغلش خالص مع اني ماشي مع الفيديو اللي هو عامله خطوه بخطوه و بأكد علي الحاجه مره و التانيه والتالته قبل ماطلع منها و مشتغلش ايه العمل يا شباب ؟ ممكن يبقي في مشكله في الداتا عندي ؟ انا شغال علي
Database Elyson Sro Dg10

[khaledowies]

ممكن بعد ازنكم لينك بتاع سيستم الاكادمي اللي اتكلمته عليه في الموضوع

[Xandish]

الموضوع مش شغال اصلا

[Mahmoud Rashwan]

الموضوع مش شغال اصلا

حضرتك المشكله اللى بتقبلك بتعمل بيها موضوع في قسم الأسئلة و الاستفسارات مش هنا

[.Gamer.]

عااش:Emoji4:

[MrBlackHeart]

Prodigy online system

[elbattawy1st]

الموضوع مش شغال اصلا

سيستم شغال عند ناس كتير اوى بس انت الامحولتش تشغله صح علشان بتاخد copy past وخلاص

[vairas1]

انا ضيفتو بس المشكله ان ال table بتاعت jop_reward مش مكتوب فيها اي حاجه ولا اي لاينز ارجو الرد

[MrGame3]

اللنكات مش شغاله يا رجاله

[manchester1337]

لو سمحت يا عبده تعمل ReUploud للينكات عشان مش شغاله او محذوفه..

[holakoo55]

link بايظ ياريت التجديد

[gedso01]

اللنكات بايظة ي شباب ممكن عند يرفعها ؟