Reward New Players Scroll

Gamer · 14 مارس 2017

Scroll FB+Stats 100% + Plus +16
طبعا الموضوع باين من عنوانه .. اسكرولاية صغيرة كدا عملتها ف حبيت اشاركها معاكو هنا

الاسكرولاية بأختصار لو انت عايز تعمل Reward لي الناس الجديدة ف السيرفر من غير ما تتعب نفسك بتعمل الاسكرول دي( بتعملك الحاجه اللي الشخصية لابساها +16 100% FB ) ممكن تعملها 80% / 0% انت وراحت وممكن تعدل علي ال + في Procedure برضه انت وراحتك ..
نخش في الموضوع بقا معلش طولت عليكو :emoji35::emoji18:

Database Slide

_RefObjCommon

كود:

1	61536	ITEM_MALL_GAMER_FB	?????	xxx	SN_ITEM_MALL_SILK_SCROLL_5	SN_ITEM_POINT_1_TT_DESC	1	0	3	3	3	1	180000	3	0	1	1	1	255	0	1	0	0	1	0	0	0	0	0	0	0	-1	0	-1	0	-1	0	-1	0	-1	0	0	0	0	0	0	0	100	0	0	0	xxx	item\etc\drop_mall_scroll.bsr	item\etc\archemy_reinforce_athanasia_a.ddj	xxx	xxx	2236467

RefObjItem

كود:

2236467	1	2	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1000	????	1	??????                                                                                                                           	-1	RESURRECT	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	0	0	0

Media Slide

Itemdata45000.txt

كود:

1	61536	ITEM_MALL_GAMER_FB	?????	xxx	SN_ITEM_MALL_GAMER_FB	SN_ITEM_MALL_GAMER_FB_TT_DESC	1	0	3	3	3	1	180000	3	0	1	1	1	255	0	1	0	0	1	0	0	0	0	0	0	0	-1	0	-1	0	-1	0	-1	0	-1	0	0	0	0	0	0	0	100	0	0	0	xxx	item\etc\drop_mall_scroll.bsr	pet2\item\item_pet2_system_name_remove.ddj	xxx	xxx	1	2	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1000	????	1	??????                                                                                                                           	-1	RESURRECT	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	0	0

Textdata_Object.txt

كود:

1	SN_ITEM_MALL_GAMER_FB								Reward Scroll

_AddLogItem

كود:

	IF (@Operation=41 AND @ItemRefID=61536) BEGIN -- Codded By Gamer1337
	EXEC FB @CHARID END

Create Procedure

كود:

USE [SRO_VT_SHARDLOG] -- Codded By Gamer1337
GO
/****** Object:  StoredProcedure [dbo].[FB]    Script Date: 14/03/2017 12:00:00 ص ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================

CREATE PROCEDURE [dbo].[FB] 
@CHARID INT
AS
BEGIN

	SET NOCOUNT ON;


DECLARE @ItemID int 
,@Charname VarChar(50) 
,@PLUS int 
, @Head int 
,@CHEST int 
,@LEGS int 
,@SHOULDER int 
,@HAND int 
, @FOOT int 
,@RING1 int 
,@RING2 int 
,@NECK int 
,@ERRING int 
,@WEP int 
,@SHIELD int 

SELECT @Charname=CHARNAME16 FROM SRO_VT_SHARD__JOoOo.._CHAR WHERE CHARID=@Charid
SET @PLUS = '[COLOR="Red"]16[/COLOR]' 
SET @Charid = (select CharID from SRO_VT_SHARD__JOoOo.._Char where CharName16=@Charname) 
SET @Head = (Select ItemID from SRO_VT_SHARD__JOoOo.dbo._Inventory where Slot=0 and CharID=@Charid) 
SET @CHEST = (Select ItemID from SRO_VT_SHARD__JOoOo.dbo._Inventory where Slot=1 and CharID=@Charid) 
SET @LEGS = (Select ItemID from SRO_VT_SHARD__JOoOo.dbo._Inventory where Slot=4 and CharID=@Charid) 
SET @SHOULDER = (Select ItemID from SRO_VT_SHARD__JOoOo.dbo._Inventory where Slot=2 and CharID=@Charid) 
SET @HAND = (Select ItemID from SRO_VT_SHARD__JOoOo.dbo._Inventory where Slot=3 and CharID=@Charid) 
SET @FOOT = (Select ItemID from SRO_VT_SHARD__JOoOo.dbo._Inventory where Slot=5 and CharID=@Charid) 
SET @RING1 = (Select ItemID from SRO_VT_SHARD__JOoOo.dbo._Inventory where Slot=11 and CharID=@Charid) 
SET @RING2 = (Select ItemID from SRO_VT_SHARD__JOoOo.dbo._Inventory where Slot=12 and CharID=@Charid) 
SET @NECK = (Select ItemID from SRO_VT_SHARD__JOoOo.dbo._Inventory where Slot=10 and CharID=@Charid) 
SET @ERRING = (Select ItemID from SRO_VT_SHARD__JOoOo.dbo._Inventory where Slot=9 and CharID=@Charid) 
SET @WEP =(Select ItemID from SRO_VT_SHARD__JOoOo.dbo._Inventory where Slot=6 and CharID=@Charid) 
SET @SHIELD =(Select ItemID from SRO_VT_SHARD__JOoOo.dbo._Inventory where Slot=7 and CharID=@Charid) 

update SRO_VT_SHARD__JOoOo.._Items  
set MagParamNum=6, 
optlevel=@PLUS, 
MagParam1 =5583457484950, 
MagParam2 =5583457484962, 
MagParam3 =30064771144, 
MagParam4=858993459290, 
MagParam5=30064771150, 
MagParam6=257698037898, 
Variance=1073741823
where ID64 =@Head 
--------------- 

update SRO_VT_SHARD__JOoOo.._Items  
set MagParamNum=6, 
optlevel=@PLUS, 
MagParam1 =5583457484950, 
MagParam2 =5583457484962, 
MagParam3 =30064771144, 
MagParam4=858993459290, 
MagParam5=30064771150, 
MagParam6=257698037898, 
Variance=1073741823 
where ID64 =@CHEST 

---------------------- 

update SRO_VT_SHARD__JOoOo.._Items  
set MagParamNum=4, 
optlevel=@PLUS, 
MagParam1 =30064771150, 
MagParam2 =30064771144, 
MagParam3 =858993459290, 
MagParam4=257698037898, 
Variance=1073741823 
where ID64 =@SHOULDER 

---------------------- 
update SRO_VT_SHARD__JOoOo.._Items  
set MagParamNum=4, 
optlevel=@PLUS, 
MagParam1 =30064771150, 
MagParam2 =30064771144, 
MagParam3 =858993459290, 
MagParam4=257698037898, 
Variance=1073741823 
where ID64 =@HAND 


update SRO_VT_SHARD__JOoOo.._Items  
set MagParamNum=6, 
optlevel=@PLUS, 
MagParam1 =5583457484950, 
MagParam2 =5583457484962, 
MagParam3 =30064771144, 
MagParam4=858993459290, 
MagParam5=30064771150, 
MagParam6=257698037898, 
Variance=1073741823 
where ID64 =@LEGS 

----------------------- 

update SRO_VT_SHARD__JOoOo.._Items  
set MagParamNum=4, 
optlevel=@PLUS, 
MagParam1 =30064771150, 
MagParam2 =30064771144, 
MagParam3 =858993459290, 
MagParam4=257698037898, 
Variance=1073741823 
where ID64 =@FOOT 

update SRO_VT_SHARD__JOoOo.._Items  
set MagParamNum=6, 
optlevel=@PLUS, 
MagParam1 =30064771144, 
MagParam2 =30064771150, 
MagParam3 =85899346100, 
MagParam4 =85899346094, 
MagParam5 =85899346112, 
MagParam6 =85899346106, 
Variance=1023
where ID64 =@RING1 



update SRO_VT_SHARD__JOoOo.._Items  
set MagParamNum=6, 
optlevel=@PLUS, 
MagParam1 =30064771144, 
MagParam2 =30064771150, 
MagParam3 =85899346100, 
MagParam4 =85899346094, 
MagParam5 =85899346112, 
MagParam6 =85899346106, 
Variance=1023
where ID64 =@RING2 

update SRO_VT_SHARD__JOoOo.._Items  
set MagParamNum=6, 
optlevel=@PLUS, 
MagParam1 =30064771144, 
MagParam2 =30064771150, 
MagParam3 =85899346100, 
MagParam4 =85899346094, 
MagParam5 =85899346112, 
MagParam6 =85899346106, 
Variance=1023 
where ID64 =@NECK 


update SRO_VT_SHARD__JOoOo.._Items  
set MagParamNum=6, 
optlevel=@PLUS, 
MagParam1 =30064771144, 
MagParam2 =30064771150, 
MagParam3 =85899346100, 
MagParam4 =85899346094, 
MagParam5 =85899346112, 
MagParam6 =85899346106, 
Variance=1023
where ID64 =@ERRING 

update SRO_VT_SHARD__JOoOo.._Items  
set MagParamNum=4, 
optlevel=@PLUS, 
MagParam1 =30064771150, 
MagParam2 =30064771144, 
MagParam3 =858993459290, 
MagParam4 =257698037862, 
Variance=34359738367 
where ID64 =@WEP 


update SRO_VT_SHARD__JOoOo.._Items  
set MagParamNum=3, 
optlevel=@PLUS, 
MagParam1 =30064771150, 
MagParam2 =30064771144, 
MagParam3 =858993459290, 
Variance=1073741823
where ID64 =@SHIELD 
set nocount off;
END

لو تلاحظو في ال Procedure انا عامل ال + بالاحمر عشان اللي حابب يعدل عليه ..

انتظرو المزيد من الشروحات ان شاء الله:emoji33:

سلاموز :emoji21::emoji11:

DraCula · 14 مارس 2017

رد: Reward New Players Scroll

استمر

Gamer · 14 مارس 2017

رد: Reward New Players Scroll

Abdo.Mohamed قال:
استمر

حبيبي تسلم:emoji21: .. عامله مخصوص ليك والله

NESTA3 · 15 مارس 2017

رد: Reward New Players Scroll

بجد الله ينور عليك :emoji37: :emoji13:

Gamer · 15 مارس 2017

رد: Reward New Players Scroll

NESTA3 قال:
بجد الله ينور عليك :emoji37: :emoji13:

تسلم وشكرا لمرورك:emoji2::emoji3:

DraCula · 16 مارس 2017

رد: Reward New Players Scroll

Gamer قال:
حبيبي تسلم:emoji21: .. عامله مخصوص ليك والله

حبيبى واللهى ياكبير بس معلش فى حاجه صغيره معايا فى الموضع ده ال

Create Procedure ده

HTML:

USE [SRO_VT_SHARDLOG] -- Codded By Gamer1337
GO
/****** Object:  StoredProcedure [dbo].[FB]    Script Date: 14/03/2017 12:00:00 ص ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================

CREATE PROCEDURE [dbo].[FB] 
@CHARID INT
AS
BEGIN

	SET NOCOUNT ON;


DECLARE @ItemID int 
,@Charname VarChar(50) 
,@PLUS int 
, @Head int 
,@CHEST int 
,@LEGS int 
,@SHOULDER int 
,@HAND int 
, @FOOT int 
,@RING1 int 
,@RING2 int 
,@NECK int 
,@ERRING int 
,@WEP int 
,@SHIELD int 

SELECT @Charname=CHARNAME16 FROM SRO_VT_SHARD__JOoOo.._CHAR WHERE CHARID=@Charid
SET @PLUS = '16' 
SET @Charid = (select CharID from SRO_VT_SHARD__JOoOo.._Char where CharName16=@Charname) 
SET @Head = (Select ItemID from SRO_VT_SHARD__JOoOo.dbo._Inventory where Slot=0 and CharID=@Charid) 
SET @CHEST = (Select ItemID from SRO_VT_SHARD__JOoOo.dbo._Inventory where Slot=1 and CharID=@Charid) 
SET @LEGS = (Select ItemID from SRO_VT_SHARD__JOoOo.dbo._Inventory where Slot=4 and CharID=@Charid) 
SET @SHOULDER = (Select ItemID from SRO_VT_SHARD__JOoOo.dbo._Inventory where Slot=2 and CharID=@Charid) 
SET @HAND = (Select ItemID from SRO_VT_SHARD__JOoOo.dbo._Inventory where Slot=3 and CharID=@Charid) 
SET @FOOT = (Select ItemID from SRO_VT_SHARD__JOoOo.dbo._Inventory where Slot=5 and CharID=@Charid) 
SET @RING1 = (Select ItemID from SRO_VT_SHARD__JOoOo.dbo._Inventory where Slot=11 and CharID=@Charid) 
SET @RING2 = (Select ItemID from SRO_VT_SHARD__JOoOo.dbo._Inventory where Slot=12 and CharID=@Charid) 
SET @NECK = (Select ItemID from SRO_VT_SHARD__JOoOo.dbo._Inventory where Slot=10 and CharID=@Charid) 
SET @ERRING = (Select ItemID from SRO_VT_SHARD__JOoOo.dbo._Inventory where Slot=9 and CharID=@Charid) 
SET @WEP =(Select ItemID from SRO_VT_SHARD__JOoOo.dbo._Inventory where Slot=6 and CharID=@Charid) 
SET @SHIELD =(Select ItemID from SRO_VT_SHARD__JOoOo.dbo._Inventory where Slot=7 and CharID=@Charid) 

update SRO_VT_SHARD__JOoOo.._Items  
set MagParamNum=6, 
optlevel=@PLUS, 
MagParam1 =5583457484950, 
MagParam2 =5583457484962, 
MagParam3 =30064771144, 
MagParam4=858993459290, 
MagParam5=30064771150, 
MagParam6=257698037898, 
Variance=1073741823
where ID64 =@Head 
--------------- 

update SRO_VT_SHARD__JOoOo.._Items  
set MagParamNum=6, 
optlevel=@PLUS, 
MagParam1 =5583457484950, 
MagParam2 =5583457484962, 
MagParam3 =30064771144, 
MagParam4=858993459290, 
MagParam5=30064771150, 
MagParam6=257698037898, 
Variance=1073741823 
where ID64 =@CHEST 

---------------------- 

update SRO_VT_SHARD__JOoOo.._Items  
set MagParamNum=4, 
optlevel=@PLUS, 
MagParam1 =30064771150, 
MagParam2 =30064771144, 
MagParam3 =858993459290, 
MagParam4=257698037898, 
Variance=1073741823 
where ID64 =@SHOULDER 

---------------------- 
update SRO_VT_SHARD__JOoOo.._Items  
set MagParamNum=4, 
optlevel=@PLUS, 
MagParam1 =30064771150, 
MagParam2 =30064771144, 
MagParam3 =858993459290, 
MagParam4=257698037898, 
Variance=1073741823 
where ID64 =@HAND 


update SRO_VT_SHARD__JOoOo.._Items  
set MagParamNum=6, 
optlevel=@PLUS, 
MagParam1 =5583457484950, 
MagParam2 =5583457484962, 
MagParam3 =30064771144, 
MagParam4=858993459290, 
MagParam5=30064771150, 
MagParam6=257698037898, 
Variance=1073741823 
where ID64 =@LEGS 

----------------------- 

update SRO_VT_SHARD__JOoOo.._Items  
set MagParamNum=4, 
optlevel=@PLUS, 
MagParam1 =30064771150, 
MagParam2 =30064771144, 
MagParam3 =858993459290, 
MagParam4=257698037898, 
Variance=1073741823 
where ID64 =@FOOT 

update SRO_VT_SHARD__JOoOo.._Items  
set MagParamNum=6, 
optlevel=@PLUS, 
MagParam1 =30064771144, 
MagParam2 =30064771150, 
MagParam3 =85899346100, 
MagParam4 =85899346094, 
MagParam5 =85899346112, 
MagParam6 =85899346106, 
Variance=1023
where ID64 =@RING1 



update SRO_VT_SHARD__JOoOo.._Items  
set MagParamNum=6, 
optlevel=@PLUS, 
MagParam1 =30064771144, 
MagParam2 =30064771150, 
MagParam3 =85899346100, 
MagParam4 =85899346094, 
MagParam5 =85899346112, 
MagParam6 =85899346106, 
Variance=1023
where ID64 =@RING2 

update SRO_VT_SHARD__JOoOo.._Items  
set MagParamNum=6, 
optlevel=@PLUS, 
MagParam1 =30064771144, 
MagParam2 =30064771150, 
MagParam3 =85899346100, 
MagParam4 =85899346094, 
MagParam5 =85899346112, 
MagParam6 =85899346106, 
Variance=1023 
where ID64 =@NECK 


update SRO_VT_SHARD__JOoOo.._Items  
set MagParamNum=6, 
optlevel=@PLUS, 
MagParam1 =30064771144, 
MagParam2 =30064771150, 
MagParam3 =85899346100, 
MagParam4 =85899346094, 
MagParam5 =85899346112, 
MagParam6 =85899346106, 
Variance=1023
where ID64 =@ERRING 

update SRO_VT_SHARD__JOoOo.._Items  
set MagParamNum=4, 
optlevel=@PLUS, 
MagParam1 =30064771150, 
MagParam2 =30064771144, 
MagParam3 =858993459290, 
MagParam4 =257698037862, 
Variance=34359738367 
where ID64 =@WEP 


update SRO_VT_SHARD__JOoOo.._Items  
set MagParamNum=3, 
optlevel=@PLUS, 
MagParam1 =30064771150, 
MagParam2 =30064771144, 
MagParam3 =858993459290, 
Variance=1073741823
where ID64 =@SHIELD 
set nocount off;
END

ده اعمله بى Query !

DraCula · 16 مارس 2017

رد: Reward New Players Scroll

علشان انا عملته بى Query و رسترت السرفر و كلو تمام اجى اضرب الاسكرولاية لبس الشخصية مش بيتعمل + او اى حاجه بيفضل زى ما هوا

Dev.Ri3o · 16 مارس 2017

رد: Reward New Players Scroll

جميل بس الاحسن انك كنت خليتها فى ال AddNewChar تنزل جاهزة من غير Procedure تعدل على ال RefMail

Gamer · 18 مارس 2017

رد: Reward New Players Scroll

Abdo.Mohamed قال:
علشان انا عملته بى Query و رسترت السرفر و كلو تمام اجى اضرب الاسكرولاية لبس الشخصية مش بيتعمل + او اى حاجه بيفضل زى ما هوا

ياريس انت عدلت علي ال ID بتاع ال procedure ب ID RefObjCommon ؟؟

Gamer · 18 مارس 2017

رد: Reward New Players Scroll

Dev.Ri3o قال:
جميل بس الاحسن انك كنت خليتها فى ال AddNewChar تنزل جاهزة من غير Procedure تعدل على ال RefMail

حوار:emoji35:

DraCula · 19 مارس 2017

رد: Reward New Players Scroll

Gamer قال:
ياريس انت عدلت علي ال ID بتاع ال procedure ب ID RefObjCommon ؟؟

عملته بى Query و دوست F5

Gamer · 19 مارس 2017

رد: Reward New Players Scroll

Abdo.Mohamed قال:
عملته بى Query و دوست F5

هاتلي ID الاسكرول من RefObjCommon

DraCula · 19 مارس 2017

رد: Reward New Players Scroll

gamer قال:
هاتلي id الاسكرول من refobjcommon

62758

Gamer · 20 مارس 2017

رد: Reward New Players Scroll

لما تفتح ال _AddLogItem في SRO_VT_SHARDLOG
هتحط الكود ده في اخر ال procedure زي ما هو كدا ودوس F5 وجرب .

كود:

	IF (@Operation=41 AND @ItemRefID=62758) BEGIN -- Codded By Gamer1337
	EXEC FB @CHARID END

DraCula · 21 مارس 2017

رد: Reward New Players Scroll

Gamer قال:
لما تفتح ال _AddLogItem في SRO_VT_SHARDLOG
هتحط الكود ده في اخر ال procedure زي ما هو كدا ودوس F5 وجرب .

كود:

IF (@Operation=41 AND @ItemRefID=62758) BEGIN -- Codded By Gamer1337 EXEC FB @CHARID END

بردك نفس المشكله

Gamer · 21 مارس 2017

رد: Reward New Players Scroll

هاتلي Team Viewer

DraCula · 21 مارس 2017

رد: Reward New Players Scroll

gamer قال:
هاتلي team viewer

ماشى بس لى الفيس بتعاك
مقفول

Gamer · 22 مارس 2017

رد: Reward New Players Scroll

abdo.mohamed قال:
ماشى بس لى الفيس بتعاك
مقفول

بعتلك لينك الفيس في الخاص .. عشان ممنوع هنا

Ahmedmosaad · 7 مارس 2019

رد: Reward New Players Scroll

هو تسلم ايدك وانا عملها عندي بس الجيم عندي مشغل فيه سيستم البلص يعني الناس بتعمل بلص عادي لحد +٣٠ المشكله ان لما حد بيضرب الاسكرول دي بترجع كل اللي هو رفعه للبلص المتحدد ينفع احددها تشتغل مع الايتم +0 بس !

Reward New Players Scroll

كلمة مدير الموقع