![]() |
#1 | ||||||||||
![]() ![]()
|
ÇäÇ ÏáæÞÊì ÚíÒ ÇáØÑíÞå ÇáÕÍíÍå áÚãá Çä ÇáäÇÓ áãÇ ÊØáÚ ãä ÇáÌíÏáÏ ÊÏÎá Ýì äÝÓ ÇáæÞÊ ÚáÔÇä ÇáßæíÑ ãÔ ÔÛÇá 2. ÚíÒÇ ÇÚÑÝ ÇÔßÇá ÇáÇÓáÍå ÈíÈÞì Ýíä Ýì ÇáßáíäÊ ÔßÑÇ 3.æÇÒì ÇÚãá íæÊß str æíäß int ?! |
||||||||||
ÇáÊÚÏíá ÇáÃÎíÑ Êã ÈæÇÓØÉ BonBOoony ; 17-12-2012 ÇáÓÇÚÉ 04:48 PM
![]() |
![]() |
#2 | ||||||||||
![]() ![]()
|
Çíå íÇ ÌÇãÚå ãÝíÔ Íá ! |
||||||||||
![]() |
![]() |
#3 | ||||||||||
![]() ![]()
|
1- ßæÏ ÈáÛÉ HTML:
USE [SRO_VT_SHARD]
GO
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
2- Ýí ÇáÜ data.pk2 Ýí ÇáÃæá ÔæÝ ãßÇä Çábsr file Ýíä ãä ÇáÜ itemdata æ åÊáÇÞíå Ýí data/res/item ... áãÇ ÊáÇÞí ÇáÜ bsr file ÇÝÊ꾂 ÈÃí text editor æ åÊáÇÞí ãßæäÇÊå Çíå ÚÔÇä ßá ÍÇÌÉ æ áíåÇ ãáÝ ãÎÊáÝ ãËáÇ Çááæä áíå ãáÝ æ Çáåíßá áíå ãáÝ ÇáÎ 3- Çáíæäíß ãÌÑÏ ÈíÒæÏæáæ ÇáÜ physical defense ÝÜ ÈíÇÎÏ ÏÇãÌ Þáíá ÌÏÇ ãä Çá STR Ãæ ÇáÚßÓ..íÒæÏæáæ Çá magical defense ÝÜ ÈíÇÎÏ ÏÇãÌ Þáíá ÌÏÇ ãä Çá INT æ åãÇ ÇáÇÊäíä ãä RefObjChar_ |
||||||||||
![]() |
![]() |
#4 | ||||||||||
![]() ![]()
|
ÇáÝ ÔßÑ íÇ ÈÇÔÇ ÈÓ ããßä ÔÑÍ Ôæíå áÍæÇÑ Çáíæäß Ïå ! |
||||||||||
![]() |
![]() |
íÊÕÝÍ ÇáãæÖæÚ ÍÇáíÇð : 1 (0 ÚÖæ æ 1 ÒÇÆÑ) | |
|
|
![]() |
||||
ÇáãæÖæÚ | ßÇÊÈ ÇáãæÖæÚ | ÇáãäÊÏì | ÇáÑÏæÏ | ÂÎÑ ãÔÇÑßÉ |
ããßä Íá æäÈí í ÌãÇÚÉ æäÈí ÇäÇ ÚÇÑÝ Çä Ïå ãÔ ÇáÞÓã ÇáãäÇÓÈ | ÇÝäÏíäÇTM.Lion.TM | ÞÜÓÜã ÊÜÚÜÏíÜá [ PK2 Edit ] | 4 | 19-03-2014 11:21 AM |
ÚäÏì ÓÄÇá Úä ÍÇÌÉ áæ ÍÏ íÚÑÝ íÝÏäì | xDD | ÈÜÚÜíÜÏ ÚÜä ÓÜíÜáÜß ÑæÏ | 1 | 17-08-2013 07:31 PM |
æäÈì ãÍÊÇÌ ÍÏ íÇÎÏäì ãÚÇå ÝÇÑã ÇæäÌ æäÈì | essso | Bellona | 8 | 16-04-2010 06:26 PM |
ÓÄÇá ãåã æäÈì áá Bow | SadBird | ÇáÜÞÜÓÜã ÇáÜÊÜÚÜáÜíÜãÜì | 1 | 06-10-2008 01:12 PM |