الـجـروب الـرسـمـي لـلـمـنـتـدى Silkroad4arab 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

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

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

المواضيع المتشابهه
الموضوع	كاتب الموضوع	المنتدى	الردود	آخر مشاركة
مشكلة حلها يحل مليون مشكلة عندي ارجو الدخول لليعرف يحل مشاكل	AssassinCr	قسم الاسئلة و الاستفسارات لعمل السيرفرات الخاصة	11	27-07-2012 03:20 PM
مشكلة في عمل سيرفر ارجو الدخول	Cru3L1337	قسم الاسئلة و الاستفسارات لعمل السيرفرات الخاصة	7	08-07-2012 03:26 PM

	ط§ظ„ط¨ظ‚ط§ط، ظ…ط³ط¬ظ„ ط¯ط§ط¦ظ…ط¢

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