Stat/Plus/FB Scroll

Gamer

Gamer

طاقم الإدارة
مشرف
SQL Developer
2 فبراير 2017
844
46
94
94
المنصورة
Facebook
xGamer1337

المستوي:

  • #1
    257454929.gif

    505913405.gif

    591526393.gif

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

    148752263800041.gif


    Database Slide

    148752263800041.gif


    _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

    148752263800041.gif


    Media Slide

    148752263800041.gif


    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

    148752263800041.gif


    _AddLogItem


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


    Create Procedure


    PHP: 
    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.._CHAR WHERE CHARID=@Charid
SET @PLUS = '16' 
SET @Charid = (select CharID from SRO_VT_SHARD.._Char where CharName16=@Charname) 
SET @Head = (Select ItemID from SRO_VT_SHARD.dbo._Inventory where Slot=0 and CharID=@Charid) 
SET @CHEST = (Select ItemID from SRO_VT_SHARD.dbo._Inventory where Slot=1 and CharID=@Charid) 
SET @LEGS = (Select ItemID from SRO_VT_SHARD.dbo._Inventory where Slot=4 and CharID=@Charid) 
SET @SHOULDER = (Select ItemID from SRO_VT_SHARD.dbo._Inventory where Slot=2 and CharID=@Charid) 
SET @HAND = (Select ItemID from SRO_VT_SHARD.dbo._Inventory where Slot=3 and CharID=@Charid) 
SET @FOOT = (Select ItemID from SRO_VT_SHARD.dbo._Inventory where Slot=5 and CharID=@Charid) 
SET @RING1 = (Select ItemID from SRO_VT_SHARD.dbo._Inventory where Slot=11 and CharID=@Charid) 
SET @RING2 = (Select ItemID from SRO_VT_SHARD.dbo._Inventory where Slot=12 and CharID=@Charid) 
SET @NECK = (Select ItemID from SRO_VT_SHARD.dbo._Inventory where Slot=10 and CharID=@Charid) 
SET @ERRING = (Select ItemID from SRO_VT_SHARD.dbo._Inventory where Slot=9 and CharID=@Charid) 
SET @WEP =(Select ItemID from SRO_VT_SHARD.dbo._Inventory where Slot=6 and CharID=@Charid) 
SET @SHIELD =(Select ItemID from SRO_VT_SHARD.dbo._Inventory where Slot=7 and CharID=@Charid) 

update SRO_VT_SHARD.._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.._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.._Items  
set MagParamNum=4, 
optlevel=@PLUS, 
MagParam1 =30064771150, 
MagParam2 =30064771144, 
MagParam3 =858993459290, 
MagParam4=257698037898, 
Variance=1073741823 
where ID64 =@SHOULDER 

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


update SRO_VT_SHARD.._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.._Items  
set MagParamNum=4, 
optlevel=@PLUS, 
MagParam1 =30064771150, 
MagParam2 =30064771144, 
MagParam3 =858993459290, 
MagParam4=257698037898, 
Variance=1073741823 
where ID64 =@FOOT 

update SRO_VT_SHARD.._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.._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.._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.._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.._Items  
set MagParamNum=4, 
optlevel=@PLUS, 
MagParam1 =30064771150, 
MagParam2 =30064771144, 
MagParam3 =858993459290, 
MagParam4 =257698037862, 
Variance=34359738367 
where ID64 =@WEP 


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


    148752263800041.gif


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

    148752263800041.gif


    ان شاء الله انهارده هعمل شرح ازاي تضيفها في السيرفر ..

    148752263800041.gif


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

    148752263800041.gif

    سلاموز
    139875365.gif
     




    DraCula

    DraCula

    V.I.P
    Designer & Pk2 Editor
    عضو
    2 فبراير 2017
    624
    15
    232
    244
    الجيزة
    Facebook
    Abdo.Dracula

    المستوي:

  • #2
    رد: Stat/Plus/FB Scroll

    عااااااااااااااااااااش بس ياريت الشرح يكون موضح علشان الجهاز بتاعى تقيل و برنامج الفيديوهات اللى انت بتستخدمو اتقل انصحك بى البرنامج اللى انا شغل بية
    Camtasia Studio 8
     




    يجب تسجيل الدخول أو التسجيل كي تتمكن من الرد هنا.

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

    بسم الله الرحمن الرحيم تم اعادة فتح المنتدي بطريقة حديثة متزامنه مع تطورات المواقع وتطبيقات الويب الحديثة وهيتم تحديث المنتدي اول بأول واضافة نظم وطرق جديده اول ب اول ومتابعه الاعضاء النشطين مع نظام مكافئات هعلن عنه قريب ..
    أعلى أسفل
    قائمة