الـجـروب الـرسـمى لـلـمـنـتـدى FaceBook | Official Group

**fouad66** · 20-05-2015, 12:13 AM

انا محمل سيرفر phantom من عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ] وكل ما اجى اضرب speed بأخود DC على طول ارجو الحل من حضرتكم..........

**MR D.B** · 20-05-2015, 12:47 AM

ات صوره من srogameserver بعد ام تضرب speed

**fouad66** · 20-05-2015, 01:01 AM

دى صورة من gameserver بعد ضرب السرعة عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]

**MR D.B** · 20-05-2015, 01:07 AM

المشكله فى addTimeJOB
اتلى الى مكتوب جوه

**fouad66** · 20-05-2015, 01:08 AM

اجيبو ازاى

**MR D.B** · 20-05-2015, 01:16 AM

SRO_VT_SHARD>PROGRAMMABILITY>STOREDPROCEDURES

**fouad66** · 20-05-2015, 01:18 AM

USE [SRO_VT_SHARD]
GO
/****** Object: StoredProcedure [dbo].[_AddTimedJob] Script Date: 20/05/2015 12:17:08 ص ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER procedure [dbo].[_AddTimedJob]
@CharID int,
@Category tinyint,
@JobID int,
@TimeToKeep int,
@Data1 int,
@Data2 int,
--##begin due to develop composite item
@Data3 int,
@Data4 int,
@Data5 int,
@Data6 int,
@Data7 int,
@Data8 int,
@Serial64 bigint,
@JID int
--##end due to develop composite item
as
--Start All Produc's Storxy-
---------------------------------------------------------------------------------------------------------
declare @lottery_coins int=(select top 1 amount from SRO_VT_SHARDLOG..lottery_coins where id between '1' and '5' order by newid())
declare @charnamme_test varchar (50)=(select charname16 from _char where CharID=@CharID)
if(@JobID = '70061') --Storxy Coins (LOW)
begin
exec _ADD_ITEM_EXTERN @charnamme_test ,'ITEM_ETC_SD_TOKEN_01',@lottery_coins,1
end
---------------------------------------------------------------------------------------------------------

declare @lottery_coins_1 int=(select top 1 amount from SRO_VT_SHARDLOG..lottery_coins where id between '5' and '20' order by newid())

if(@JobID = '70062') --Storxy Coins (Normal)
begin
exec _ADD_ITEM_EXTERN @charnamme_test ,'ITEM_ETC_SD_TOKEN_01',@lottery_coins_1,1
end
---------------------------------------------------------------------------------------------------------

declare @lottery_coins_2 int=(select top 1 amount from SRO_VT_SHARDLOG..lottery_coins where id between '25' and '35' order by newid())

if(@JobID = '70063') --Storxy Coins (Max)
begin
exec _ADD_ITEM_EXTERN @charnamme_test ,'ITEM_ETC_SD_TOKEN_01',@lottery_coins_2,1
end
---------------------------------------------------------------------------------------------------------
declare @lottery_coins_3 int=(select top 1 amount from SRO_VT_SHARDLOG..lottery_coins where id between '1' and '10' order by newid())

if(@JobID = '70064') --
begin
exec _ADD_ITEM_EXTERN @charnamme_test ,'ITEM_ETC_ARCHEMY_MAGICSTONE_LUCK_11',@lottery_co ins_3,1
end
---------------------------------------------------------------------------------------------------------
declare @lottery_coins_4 int=(select top 1 amount from SRO_VT_SHARDLOG..lottery_coins where id between '1' and '10' order by newid())

if(@JobID = '70065') --
begin
exec _ADD_ITEM_EXTERN @charnamme_test ,'ITEM_ETC_ARCHEMY_MAGICSTONE_SOLID_11',@lottery_c oins_4,1
end
---------------------------------------------------------------------------------------------------------
declare @lottery_coins_5 int=(select top 1 amount from SRO_VT_SHARDLOG..lottery_coins where id between '1' and '25' order by newid())

if(@JobID = '70066') --
begin
exec _ADD_ITEM_EXTERN @charnamme_test ,'ITEM_ETC_ARCHEMY_REINFORCE_RECIPE_WEAPON_B',@lot tery_coins_5,1
end
---------------------------------------------------------------------------------------------------------
declare @lottery_coins_6 int=(select top 1 amount from SRO_VT_SHARDLOG..lottery_coins where id between '1' and '25' order by newid())

if(@JobID = '70067') --
begin
exec _ADD_ITEM_EXTERN @charnamme_test ,'ITEM_ETC_ARCHEMY_REINFORCE_RECIPE_ARMOR_B',@lott ery_coins_6,1
end
---------------------------------------------------------------------------------------------------------
declare @lottery_coins_7 int=(select top 1 amount from SRO_VT_SHARDLOG..lottery_coins where id between '1' and '25' order by newid())

if(@JobID = '70068') --
begin
exec _ADD_ITEM_EXTERN @charnamme_test ,'ITEM_ETC_ARCHEMY_REINFORCE_RECIPE_SHIELD_B',@lot tery_coins_7,1
end
---------------------------------------------------------------------------------------------------------
declare @lottery_coins_8 int=(select top 1 amount from SRO_VT_SHARDLOG..lottery_coins where id between '1' and '25' order by newid())

if(@JobID = '70069') --
begin
exec _ADD_ITEM_EXTERN @charnamme_test ,'ITEM_ETC_ARCHEMY_REINFORCE_RECIPE_ACCESSARY_B',@ lottery_coins_8,1
end
---------------------------------------------------------------------------------------------------------
declare @lottery_coins_9 int=(select top 1 amount from SRO_VT_SHARDLOG..lottery_coins where id between '25' and '35' order by newid())

if(@JobID = '59754') --Storxy Coins (Max)
begin
exec _ADD_ITEM_EXTERN @charnamme_test ,'ITEM_ETC_SD_TOKEN_01',@lottery_coins_9,1
end

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

if(@JobID = '59752') -- 10M SP
begin
update _Char set RemainSkillPoint = RemainSkillPoint+'10000000' where CharID = @CharID -- I don't want the title i just want the blue zerk.
end
---------------------------------

if(@JobID= '59749')-- Holy temple remove
begin
delete from _CharInstanceWorldData where CharID= @CharID

return -3
end
if(@JobID= '59750') --Remover Blue Avatar
begin
Update _Items Set MagParamNum = 0, MagParam1 = NULL, MagParam2 = NULL, MagParam3 = NULL, MagParam4 = NULL, MagParam5 = NULL, MagParam6 = NULL, MagParam7 = NULL, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL where ID64 in (select ItemID from _Inventoryforavatar where CharID = @CharID and Slot between 0 and 2 and ItemID>0)
return -3
end

if(@JobID = '59751') -- Pk Remover
begin
Update _Char Set DailyPK = 0 Where CharID = @CharID
Update _Char Set TotalPK = 0 Where CharID = @CharID
Update _Char Set PKPenaltyPoint = 0 Where CharID = @CharID
return -3
end
if(@JobID= '59753') --Remover Adv
begin
DELETE FROM _BindingOptionWithItem where nItemDBID IN (SELECT ItemID FROM _Inventory WHERE Slot like '6' and bOptType=2 AND CharID=@CharID)

end
--End All Bluemoon Scrolls Producs By Storxy--
if(@JobID = '59701')
BEGIN
UPDATE dbo._Char SET HwanLevel = 32 Where CharID = @CharID
END
if(@JobID = '59702')
BEGIN
UPDATE dbo._Char SET HwanLevel = 33 Where CharID = @CharID
END
if(@JobID = '59703')
BEGIN
UPDATE dbo._Char SET HwanLevel = 34 Where CharID = @CharID
END
if(@JobID = '59704')
BEGIN
UPDATE dbo._Char SET HwanLevel = 35 Where CharID = @CharID
END
if(@JobID = '59705')
BEGIN
UPDATE dbo._Char SET HwanLevel = 36 Where CharID = @CharID
END
if(@JobID = '59706')
BEGIN
UPDATE dbo._Char SET HwanLevel = 37 Where CharID = @CharID
END
if(@JobID = '59707')
BEGIN
UPDATE dbo._Char SET HwanLevel = 38 Where CharID = @CharID
END
if(@JobID = '59708')
BEGIN
UPDATE dbo._Char SET HwanLevel = 39 Where CharID = @CharID
END
if(@JobID = '59709')
BEGIN
UPDATE dbo._Char SET HwanLevel = 40 Where CharID = @CharID
END
if(@JobID = '59710')
BEGIN
UPDATE dbo._Char SET HwanLevel = 41 Where CharID = @CharID
END
if(@JobID = '59711')
BEGIN
UPDATE dbo._Char SET HwanLevel = 42 Where CharID = @CharID
END
if(@JobID = '59712')
BEGIN
UPDATE dbo._Char SET HwanLevel = 43 Where CharID = @CharID
END
if(@JobID = '59713')
BEGIN
UPDATE dbo._Char SET HwanLevel = 44 Where CharID = @CharID
END
if(@JobID = '59714')
BEGIN
UPDATE dbo._Char SET HwanLevel = 45 Where CharID = @CharID
END
if(@JobID = '59715')
BEGIN
UPDATE dbo._Char SET HwanLevel = 46 Where CharID = @CharID
END
if(@JobID = '59716')
BEGIN
UPDATE dbo._Char SET HwanLevel = 47 Where CharID = @CharID
END
if(@JobID = '59717')
BEGIN
UPDATE dbo._Char SET HwanLevel = 48 Where CharID = @CharID
END
if(@JobID = '59718')
BEGIN
UPDATE dbo._Char SET HwanLevel = 49 Where CharID = @CharID
END
if(@JobID = '59719')
BEGIN
UPDATE dbo._Char SET HwanLevel = 50 Where CharID = @CharID
END
if(@JobID = '59720')
BEGIN
UPDATE dbo._Char SET HwanLevel = 51 Where CharID = @CharID
END
if(@JobID = '59721')
BEGIN
UPDATE dbo._Char SET HwanLevel = 52 Where CharID = @CharID
END
if(@JobID = '59722')
BEGIN
UPDATE dbo._Char SET HwanLevel = 53 Where CharID = @CharID
END
if(@JobID = '59723')
BEGIN
UPDATE dbo._Char SET HwanLevel = 54 Where CharID = @CharID
END
if(@JobID = '59724')
BEGIN
UPDATE dbo._Char SET HwanLevel = 55 Where CharID = @CharID
END
if(@JobID = '59725')
BEGIN
UPDATE dbo._Char SET HwanLevel = 56 Where CharID = @CharID
END
if(@JobID = '59726')
BEGIN
UPDATE dbo._Char SET HwanLevel = 57 Where CharID = @CharID
END
if(@JobID = '59727')
BEGIN
UPDATE dbo._Char SET HwanLevel = 58 Where CharID = @CharID
END
if(@JobID = '59728')
BEGIN
UPDATE dbo._Char SET HwanLevel = 59 Where CharID = @CharID
END
if(@JobID = '59729')
BEGIN
UPDATE dbo._Char SET HwanLevel = 60 Where CharID = @CharID
END
if(@JobID = '59730')
BEGIN
UPDATE dbo._Char SET HwanLevel = 61 Where CharID = @CharID
END
if(@JobID = '59731')
BEGIN
UPDATE dbo._Char SET HwanLevel = 62 Where CharID = @CharID
END
if(@JobID = '59732')
BEGIN
UPDATE dbo._Char SET HwanLevel = 63 Where CharID = @CharID
END
if(@JobID = '59733')
BEGIN
UPDATE dbo._Char SET HwanLevel = 64 Where CharID = @CharID
END
if(@JobID = '59734')
BEGIN
UPDATE dbo._Char SET HwanLevel = 65 Where CharID = @CharID
END
if(@JobID = '59735')
BEGIN
UPDATE dbo._Char SET HwanLevel = 66 Where CharID = @CharID
END
if(@JobID = '59736')
BEGIN
UPDATE dbo._Char SET HwanLevel = 67 Where CharID = @CharID
END
if(@JobID = '59737')
BEGIN
UPDATE dbo._Char SET HwanLevel = 68 Where CharID = @CharID
END
if(@JobID = '59738')
BEGIN
UPDATE dbo._Char SET HwanLevel = 69 Where CharID = @CharID
END
if(@JobID = '59739')
BEGIN
UPDATE dbo._Char SET HwanLevel = 70 Where CharID = @CharID
END
if(@JobID = '59740')
BEGIN
UPDATE dbo._Char SET HwanLevel = 71 Where CharID = @CharID
END
if(@JobID = '59741')
BEGIN
UPDATE dbo._Char SET HwanLevel = 72 Where CharID = @CharID
END
if(@JobID = '59742')
BEGIN
UPDATE dbo._Char SET HwanLevel = 73 Where CharID = @CharID
END
if(@JobID = '59743')
BEGIN
UPDATE dbo._Char SET HwanLevel = 74 Where CharID = @CharID
END
if(@JobID = '59744')
BEGIN
UPDATE dbo._Char SET HwanLevel = 75 Where CharID = @CharID
END
if(@JobID = '59745')
BEGIN
UPDATE dbo._Char SET HwanLevel = 76 Where CharID = @CharID
END
if(@JobID = '59746')
BEGIN
UPDATE dbo._Char SET HwanLevel = 77 Where CharID = @CharID
END
if(@JobID = '59747')
BEGIN
UPDATE dbo._Char SET HwanLevel = 78 Where CharID = @CharID
END
if(@JobID = '59748')
BEGIN
UPDATE dbo._Char SET HwanLevel = 79 Where CharID = @CharID
END
if(@JobID = '59749')
BEGIN
UPDATE dbo._Char SET HwanLevel = 80 Where CharID = @CharID
END
if(@JobID = '59750')
BEGIN
UPDATE dbo._Char SET HwanLevel = 81 Where CharID = @CharID
END
if(@JobID = '59751')
BEGIN
UPDATE dbo._Char SET HwanLevel = 82 Where CharID = @CharID
END
if(@JobID = '59699')
BEGIN
UPDATE dbo._Char SET HwanLevel = 30 Where CharID = @CharID
END
if(@JobID = '59700')
BEGIN
UPDATE dbo._Char SET HwanLevel = 31 Where CharID = @CharID
END
if(@JobID = '60001')
BEGIN
UPDATE dbo._Char SET HwanLevel = 100 Where CharID = @CharID
END
if(@JobID = '60002')
BEGIN
UPDATE dbo._Char SET HwanLevel = 101 Where CharID = @CharID
END
if(@JobID = '60003')
BEGIN
UPDATE dbo._Char SET HwanLevel = 102 Where CharID = @CharID
END
if(@JobID = '60004')
BEGIN
UPDATE dbo._Char SET HwanLevel = 103 Where CharID = @CharID
END
if(@JobID = '60005')
BEGIN
UPDATE dbo._Char SET HwanLevel = 104 Where CharID = @CharID
END
if(@JobID = '60006')
BEGIN
UPDATE dbo._Char SET HwanLevel = 105 Where CharID = @CharID
END
if(@JobID = '60007')
BEGIN
UPDATE dbo._Char SET HwanLevel = 106 Where CharID = @CharID
END
if(@JobID = '60008')
BEGIN
UPDATE dbo._Char SET HwanLevel = 107 Where CharID = @CharID
END
if(@JobID = '60009')
BEGIN
UPDATE dbo._Char SET HwanLevel = 108 Where CharID = @CharID
END
if(@JobID = '60010')
BEGIN
UPDATE dbo._Char SET HwanLevel = 109 Where CharID = @CharID
END
if(@JobID = '60011')
BEGIN
UPDATE dbo._Char SET HwanLevel = 110 Where CharID = @CharID
END
if(@JobID = '60012')
BEGIN
UPDATE dbo._Char SET HwanLevel = 111 Where CharID = @CharID
END
if(@JobID = '60013')
BEGIN
UPDATE dbo._Char SET HwanLevel = 112 Where CharID = @CharID
END
if(@JobID = '60014')
BEGIN
UPDATE dbo._Char SET HwanLevel = 113 Where CharID = @CharID
END
if(@JobID = '60015')
BEGIN
UPDATE dbo._Char SET HwanLevel = 114 Where CharID = @CharID
END
if(@JobID = '60016')
BEGIN
UPDATE dbo._Char SET HwanLevel = 115 Where CharID = @CharID
END
if(@JobID = '60017')
BEGIN
UPDATE dbo._Char SET HwanLevel = 116 Where CharID = @CharID
END
if(@JobID = '60018')
BEGIN
UPDATE dbo._Char SET HwanLevel = 117 Where CharID = @CharID
END
if(@JobID = '60019')
BEGIN
UPDATE dbo._Char SET HwanLevel = 118 Where CharID = @CharID
END
if(@JobID = '60020')
BEGIN
UPDATE dbo._Char SET HwanLevel = 119 Where CharID = @CharID
END
if(@JobID = '60021')
BEGIN
UPDATE dbo._Char SET HwanLevel = 120 Where CharID = @CharID
END
if(@JobID = '60022')
BEGIN
UPDATE dbo._Char SET HwanLevel = 121 Where CharID = @CharID
END
if(@JobID = '60023')
BEGIN
UPDATE dbo._Char SET HwanLevel = 122 Where CharID = @CharID
END
if(@JobID = '60024')
BEGIN
UPDATE dbo._Char SET HwanLevel = 123 Where CharID = @CharID
END
if(@JobID = '60025')
BEGIN
UPDATE dbo._Char SET HwanLevel = 124 Where CharID = @CharID
END
if(@JobID = '60026')
BEGIN
UPDATE dbo._Char SET HwanLevel = 125 Where CharID = @CharID
END
if(@JobID = '60027')
BEGIN
UPDATE dbo._Char SET HwanLevel = 126 Where CharID = @CharID
END
if(@JobID = '60028')
BEGIN
UPDATE dbo._Char SET HwanLevel = 127 Where CharID = @CharID
END
if(@JobID = '60029')
BEGIN
UPDATE dbo._Char SET HwanLevel = 128 Where CharID = @CharID
END
if(@JobID = '60030')
BEGIN
UPDATE dbo._Char SET HwanLevel = 129 Where CharID = @CharID
END
if(@JobID = '60031')
BEGIN
UPDATE dbo._Char SET HwanLevel = 130 Where CharID = @CharID
END
if(@JobID = '60032')
BEGIN
UPDATE dbo._Char SET HwanLevel = 131 Where CharID = @CharID
END
if(@JobID = '60033')
BEGIN
UPDATE dbo._Char SET HwanLevel = 132 Where CharID = @CharID
END
if(@JobID = '60034')
BEGIN
UPDATE dbo._Char SET HwanLevel = 133 Where CharID = @CharID
END
if(@JobID = '60035')
BEGIN
UPDATE dbo._Char SET HwanLevel = 134 Where CharID = @CharID
END
if(@JobID = '60036')
BEGIN
UPDATE dbo._Char SET HwanLevel = 135 Where CharID = @CharID
END
if(@JobID = '60037')
BEGIN
UPDATE dbo._Char SET HwanLevel = 136 Where CharID = @CharID
END
if(@JobID = '60038')
BEGIN
UPDATE dbo._Char SET HwanLevel = 137 Where CharID = @CharID
END
if(@JobID = '60039')
BEGIN
UPDATE dbo._Char SET HwanLevel = 138 Where CharID = @CharID
END
if(@JobID = '60040')
BEGIN
UPDATE dbo._Char SET HwanLevel = 139 Where CharID = @CharID
END
if(@JobID = '60041')
BEGIN
UPDATE dbo._Char SET HwanLevel = 140 Where CharID = @CharID
END
if(@JobID = '60042')
BEGIN
UPDATE dbo._Char SET HwanLevel = 141 Where CharID = @CharID
END
if(@JobID = '60043')
BEGIN
UPDATE dbo._Char SET HwanLevel = 142 Where CharID = @CharID
END
if(@JobID = '60044')
BEGIN
UPDATE dbo._Char SET HwanLevel = 143 Where CharID = @CharID
END
if(@JobID = '60045')
BEGIN
UPDATE dbo._Char SET HwanLevel = 144 Where CharID = @CharID
END
if(@JobID = '60046')
BEGIN
UPDATE dbo._Char SET HwanLevel = 145 Where CharID = @CharID
END
if(@JobID = '60047')
BEGIN
UPDATE dbo._Char SET HwanLevel = 146 Where CharID = @CharID
END
if(@JobID = '60048')
BEGIN
UPDATE dbo._Char SET HwanLevel = 147 Where CharID = @CharID
END
if(@JobID = '60049')
BEGIN
UPDATE dbo._Char SET HwanLevel = 148 Where CharID = @CharID
END
if(@JobID = '60050')
BEGIN
UPDATE dbo._Char SET HwanLevel = 149 Where CharID = @CharID
END

if (not exists (select CharID from _Char with (nolock) where CharID = @CharID))
return -1
if (@TimeToKeep <= 0)
return -2
declare @NewJobID int
set @NewJobID = 0
--##begin due to develop composite item

if (@JobID = 1 or @JobID = 2)
BEGIN
insert into _TimedJob(CharID,Category,JobID,TimeToKeep,Data1,D ata2,Data3,Data4,Data5,Data6,Data7,Data8,Serial64, JID)
values(@CharID, @Category, @JobID, 1, @Data1, @Data2, @Data3, @Data4, @Data5, @Data6, @Data7, @Data8, @Serial64, @JID)
END
ELSE
BEGIN
--##begin due to develop composite item
insert into _TimedJob(CharID,Category,JobID,TimeToKeep,Data1,D ata2,Data3,Data4,Data5,Data6,Data7,Data8,Serial64, JID)
values(@CharID, @Category, @JobID, @TimeToKeep, @Data1, @Data2, @Data3, @Data4, @Data5, @Data6, @Data7, @Data8, @Serial64, @JID)
END
--##end due to develop composite item
set @NewJobID = @@identity
if (@@error <> 0 or @@rowcount = 0)

return -3
return @NewJobID
---------

insert into _TimedJob(CharID,Category,JobID,TimeToKeep,Data1,D ata2,Data3,Data4,Data5,Data6,Data7,Data8,Serial64, JID)
values(@CharID, @Category, @JobID, @TimeToKeep, @Data1, @Data2, @Data3, @Data4, @Data5, @Data6, @Data7, @Data8, @Serial64, @JID)
--##end due to develop composite item
if(@JobID = '59691') -- Mudar nome do char
BEGIN
declare @CharName16 varchar(64)
Select @CharName16=CharName16 from _Char where CharID = @CharID
Update _Char Set CharName16 = '@'+ @CharName16 Where CharID = @CharID
return -3
END
set @NewJobID = @@identity
if (@@error <> 0 or @@rowcount = 0)
return -3
return @NewJobID
----

**MR D.B** · 20-05-2015, 01:20 AM

اقتباس:

USE [SRO_VT_SHARD]
GO
/****** Object: StoredProcedure [dbo].[_AddTimedJob] Script Date: 20/05/2015 12:16:40 ص ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER procedure [dbo].[_AddTimedJob]
@CharID int,
@Category tinyint,
@JobID int,
@TimeToKeep int,
@Data1 int,
@Data2 int,
--##begin due to develop composite item
@Data3 int,
@Data4 int,
@Data5 int,
@Data6 int,
@Data7 int,
@Data8 int,
@Serial64 bigint,
@JID int
--##end due to develop composite item
as
if (not exists (select CharID from _Char with (nolock) where CharID = @CharID))
return -1
if (@TimeToKeep <= 0)
return -2
declare @NewJobID int
set @NewJobID = 0
--##begin due to develop composite item
insert into _TimedJob(CharID,Category,JobID,TimeToKeep,Data1,D ata2,Data3,Data4,Data5,Data6,Data7,Data8,Serial64, JID)
values(@CharID, @Category, @JobID, @TimeToKeep, @Data1, @Data2, @Data3, @Data4, @Data5, @Data6, @Data7, @Data8, @Serial64, @JID)
--##end due to develop composite item
set @NewJobID = @@identity
if (@@error <> 0 or @@rowcount = 0)
return -3

if @Category=2 and @JobID=2
begin
delete from _TimedJob where ID=@NewJobID
end
return @NewJobID

بد ديه بى الى عندك و جرب

**!_Ahmed Elabbasy_!** · 20-05-2015, 01:30 AM

كود PHP:


			
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER   procedure [dbo].[_AddTimedJob] 
@CharID            int, 
@Category        tinyint, 
@JobID            int, 
@TimeToKeep    int, 
@Data1            int, 
@Data2            int, 
--##begin due to develop composite item 
@Data3            int, 
@Data4            int, 
@Data5            int, 
@Data6            int, 
@Data7            int, 
@Data8            int, 
@Serial64        bigint, 
@JID            int 
--##end due to develop composite item 
as 
    if (not exists (select CharID from _Char with (nolock) where CharID = @CharID)) 
                return -1 
            if (@TimeToKeep <= 0) 
                return -2 
            declare @NewJobID int 
            set @NewJobID = 0 

            --##JobID 1 = Guild // JobID 2 = Thief/Hunter/Trader 
            --##If you want to only have one not both, then just modify the line below! 
            if (@JobID = 1 or @JobID = 2) 
            BEGIN 
                return -1 
            END 
            ELSE 
            BEGIN 
            --##begin due to develop composite item 
            insert into _TimedJob(CharID,Category,JobID,TimeToKeep,Data1,Data2,Data3,Data4,Data5,Data6,Data7,Data8,Serial64,JID) 
            values(@CharID, @Category, @JobID, @TimeToKeep, @Data1, @Data2, @Data3, @Data4, @Data5, @Data6, @Data7, @Data8, @Serial64, @JID) 
            END 
            --##end due to develop composite item 
            set @NewJobID = @@identity 
            if (@@error <> 0 or @@rowcount = 0) 
                 
                return -3 
     return @NewJobID

**!_Ahmed Elabbasy_!** · 20-05-2015, 01:30 AM

كود PHP:


			
SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO



ALTER   procedure [dbo].[_AddTimedJob] 

@CharID            int, 

@Category        tinyint, 

@JobID            int, 

@TimeToKeep    int, 

@Data1            int, 

@Data2            int, 

--##begin due to develop composite item 

@Data3            int, 

@Data4            int, 

@Data5            int, 

@Data6            int, 

@Data7            int, 

@Data8            int, 

@Serial64        bigint, 

@JID            int 

--##end due to develop composite item 

as 

    if (not exists (select CharID from _Char with (nolock) where CharID = @CharID)) 

                return -1 

            if (@TimeToKeep <= 0) 

                return -2 

            declare @NewJobID int 

            set @NewJobID = 0 



            --##JobID 1 = Guild // JobID 2 = Thief/Hunter/Trader 

            --##If you want to only have one not both, then just modify the line below! 

            if (@JobID = 1 or @JobID = 2) 

            BEGIN 

                return -1 

            END 

            ELSE 

            BEGIN 

            --##begin due to develop composite item 

            insert into _TimedJob(CharID,Category,JobID,TimeToKeep,Data1,Data2,Data3,Data4,Data5,Data6,Data7,Data8,Serial64,JID) 

            values(@CharID, @Category, @JobID, @TimeToKeep, @Data1, @Data2, @Data3, @Data4, @Data5, @Data6, @Data7, @Data8, @Serial64, @JID) 

            END 

            --##end due to develop composite item 

            set @NewJobID = @@identity 

            if (@@error <> 0 or @@rowcount = 0) 

                 

                return -3 

     return @NewJobID

**fouad66** · 20-05-2015, 01:31 AM

فى مشكلة فى اللى انت حططها عند cher iD

**fouad66** · 20-05-2015, 01:35 AM

تم حل المشكلة وشكرا MR D.B .....Ahmed Elabbasy_! بجد شكرا ليكم جداااا

**!_Ahmed Elabbasy_!** · 20-05-2015, 01:51 AM

طب اختار افضل اجابة و يغلق ## و العفو يا كبيير

يتصفح الموضوع حالياً : 1 (0 عضو و 1 زائر)

	حفظ بياناتي ؟

شـريـط الاهـداءات