jop

[mohamed habib]

كنت عايز اجرب ال trader عندى بس مش عارف اسجل فىيها
كلمة ال jop مش ظاهره عندى وانا بفتح الشخصيه
معلش انا مبتدىء

http://www.silkroad4arab.com/vb/images/like_share/share.gif (http://www.silkroad4arab.com/vb/showthread.php?t=616340#)

[mohamed habib]

بالله عليكم حد يساعدنى

[mohamed habib]

فين الساده المشرفين

[™Ozoo-Eboda™]

USE [SRO_VT_SHARD]
GO
/****Ozoo******/
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,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جرب دي..
..

[mohamed habib]

USE [SRO_VT_SHARD]
GO
/****Ozoo******/
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,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جرب دي..
..
حضرتك تكرم قوى لانك بتساعدنى كل سنه وحضرتك طيب بس حضرتك اخد back up
الاول ولا عادى

[™Ozoo-Eboda™]

حضرتك تكرم قوى لانك بتساعدنى كل سنه وحضرتك طيب بس حضرتك اخد back up
الاول ولا عادى

اولا:- شكرا علي ردك .. وكل سنة وانت طيب
..
بالنسبة للـ back up اتعود قبل اى تعديل او اضافات تبقي عامل back up احتياطي لتجنب الاخطاء..شكرا

[mohamed habib]

اولا:- شكرا علي ردك .. وكل سنة وانت طيب
..
بالنسبة للـ back up اتعود قبل اى تعديل او اضافات تبقي عامل back up احتياطي لتجنب الاخطاء..شكرا
حضرتك انا سافرت معلش انا فى الجيش
هجرب اول مانزل شكرا لحضرتك

[™Ozoo-Eboda™]

بالتوفيق انشاء الله