ÊÓÌíá ÇáÏÎæá ÏÇÆãÂ
ط§ظ„ط¥ط¹ظ„ط§ظ†ط§طھ
ÞÏíã 23-09-2014, 12:12 PM   #1

NotTalkToMe
ÚÖæ ÝÚÇá





• ÇáÇäÜÊÜÓÜÇÈ » Jun 2012
• ÑÞÜã ÇáÚÜÖÜæíÜÉ » 101506
• ÇáãÔÜÜÜÇÑßÜÇÊ » 230
• ÇáÜÏæáÜÉ » ßæßÈí ÇáÎÇÕ
• ÇáÜåÜæÇíÜÉ » ÇáÞÑÇÁå
• ÇÓÜã ÇáÜÓÜíÜÑÝÜÑ » Private Server
• ÇáÜÌÜäÜÓ » Male
• äÞÜÇØ ÇáÊÞííã » 10
NotTalkToMe ÕÜÇÚÜÏ

NotTalkToMe ÛíÑ ãÊæÇÌÏ ÍÇáíÇð



ÇÝÊÑÇÖí Çí ÇÚãá Èáæß ÔÇÊ ¿



áæ ÚÇíÒ ÇÏí áÍÏ Èáæß ÔÇÊ áÝÊÑå ãÚíäå ÇäÇ Çááì ÇÍÏÏåÇ ÇÚãáåÇ ãäíä ¿
æÇáÝæÑÊÌíä æÑáÏ ÚäÏí Çááì ÈíÎÔåÇ ÈÊÌíÈáå dc ãÚ Çä ÇáãÏä ÈÊÇÚÊåÇ ãÝÊæÍå Çíå ÇáÍá ¿


ÊæÞíÚ NotTalkToMe :


ÅÚáÇäÇÊ google

ÞÏíã 23-09-2014, 06:59 PM   #2

Hero
ÚÖæ ãÔÇÑß



ÇáÕæÑÉ ÇáÑãÒíÉ Hero


• ÇáÇäÜÊÜÓÜÇÈ » Jan 2014
• ÑÞÜã ÇáÚÜÖÜæíÜÉ » 116050
• ÇáãÔÜÜÜÇÑßÜÇÊ » 6,999
• ÇáÜÏæáÜÉ » Egypt
• ÇáÜåÜæÇíÜÉ » ;"#string n = "C
• ÇÓÜã ÇáÜÓÜíÜÑÝÜÑ » No Server
• ÇáÜÌÜäÜÓ » Male
• äÞÜÇØ ÇáÊÞííã » 85
Hero ÌÜíÜÏ

Hero ÛíÑ ãÊæÇÌÏ ÍÇáíÇð



ÇÝÊÑÇÖí



Çæá ØáÈ åÈÚÊáß ÇáÕæÑ áãÇ áÞíåÇ ÈÓ åíÇ áíåÇ ÔÑÍ åäÇ ßãÇä
ÊÇäì ØáÈ ÇÊÝÖá ÇÚãá ÇáßæÑì Ïì

ßæÏ PHP:
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 (nolockwhere 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 and @Category and @Serial64=0) or (@JobID and @Category and @Serial64=0)  --For Guild and CharJob            
     
if (@JobID and @Category and @Serial64=0)   --Only for Guild
            BEGIN
            set 
@CharID 0            
            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
            
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 <> or @@rowcount 0)
                
                return -
3
     
return @NewJobID 


ÊæÞíÚ Hero :
...!!


ÞÏíã 30-09-2014, 03:21 AM   #3

NotTalkToMe
ÚÖæ ÝÚÇá





• ÇáÇäÜÊÜÓÜÇÈ » Jun 2012
• ÑÞÜã ÇáÚÜÖÜæíÜÉ » 101506
• ÇáãÔÜÜÜÇÑßÜÇÊ » 230
• ÇáÜÏæáÜÉ » ßæßÈí ÇáÎÇÕ
• ÇáÜåÜæÇíÜÉ » ÇáÞÑÇÁå
• ÇÓÜã ÇáÜÓÜíÜÑÝÜÑ » Private Server
• ÇáÜÌÜäÜÓ » Male
• äÞÜÇØ ÇáÊÞííã » 10
NotTalkToMe ÕÜÇÚÜÏ

NotTalkToMe ÛíÑ ãÊæÇÌÏ ÍÇáíÇð



ÇÝÊÑÇÖí



æÕÇÊ áÍÇÌå Ýì Èáæß ÇáÔÇÊ ¿


ÊæÞíÚ NotTalkToMe :


ÞÏíã 30-09-2014, 03:50 AM   #4

™Dev Microsoft™





• ÇáÇäÜÊÜÓÜÇÈ » Mar 2013
• ÑÞÜã ÇáÚÜÖÜæíÜÉ » 110495
• ÇáãÔÜÜÜÇÑßÜÇÊ » 2,201
• ÇáÜÏæáÜÉ » in Dedicated Server
• ÇáÜåÜæÇíÜÉ » Develop DB&PHP Edit&Fixing Buged Files
• ÇÓÜã ÇáÜÓÜíÜÑÝÜÑ » Private Server
• ÇáÜÌÜäÜÓ » Male
• äÞÜÇØ ÇáÊÞííã » 61
™Dev Microsoft™ ÌÜíÜÏ

™Dev Microsoft™ ÛíÑ ãÊæÇÌÏ ÍÇáíÇð


ÅÑÓÇá ÑÓÇáÉ ÚÈÑ Yahoo Åáì ™Dev Microsoft™

ÇÝÊÑÇÖí



ãä ÇáÜSMC íÇ ÈÑæ




ÞÏíã 30-09-2014, 04:57 AM   #5

NotTalkToMe
ÚÖæ ÝÚÇá





• ÇáÇäÜÊÜÓÜÇÈ » Jun 2012
• ÑÞÜã ÇáÚÜÖÜæíÜÉ » 101506
• ÇáãÔÜÜÜÇÑßÜÇÊ » 230
• ÇáÜÏæáÜÉ » ßæßÈí ÇáÎÇÕ
• ÇáÜåÜæÇíÜÉ » ÇáÞÑÇÁå
• ÇÓÜã ÇáÜÓÜíÜÑÝÜÑ » Private Server
• ÇáÜÌÜäÜÓ » Male
• äÞÜÇØ ÇáÊÞííã » 10
NotTalkToMe ÕÜÇÚÜÏ

NotTalkToMe ÛíÑ ãÊæÇÌÏ ÍÇáíÇð



ÇÝÊÑÇÖí



ããßä ÊßÊÈáí ãäíä ÈÇáÙÈØ ÝíåÇ íÇ ÈÇÔÇ


ÊæÞíÚ NotTalkToMe :


ÞÏíã 30-09-2014, 05:34 AM   #6

Hero
ÚÖæ ãÔÇÑß



ÇáÕæÑÉ ÇáÑãÒíÉ Hero


• ÇáÇäÜÊÜÓÜÇÈ » Jan 2014
• ÑÞÜã ÇáÚÜÖÜæíÜÉ » 116050
• ÇáãÔÜÜÜÇÑßÜÇÊ » 6,999
• ÇáÜÏæáÜÉ » Egypt
• ÇáÜåÜæÇíÜÉ » ;"#string n = "C
• ÇÓÜã ÇáÜÓÜíÜÑÝÜÑ » No Server
• ÇáÜÌÜäÜÓ » Male
• äÞÜÇØ ÇáÊÞííã » 85
Hero ÌÜíÜÏ

Hero ÛíÑ ãÊæÇÌÏ ÍÇáíÇð



ÇÝÊÑÇÖí



smc>>punishment>>id account>>æ ÊÚãá Èáæß


ÊæÞíÚ Hero :
...!!


ÞÏíã 01-10-2014, 03:52 AM   #7

Hero
ÚÖæ ãÔÇÑß



ÇáÕæÑÉ ÇáÑãÒíÉ Hero


• ÇáÇäÜÊÜÓÜÇÈ » Jan 2014
• ÑÞÜã ÇáÚÜÖÜæíÜÉ » 116050
• ÇáãÔÜÜÜÇÑßÜÇÊ » 6,999
• ÇáÜÏæáÜÉ » Egypt
• ÇáÜåÜæÇíÜÉ » ;"#string n = "C
• ÇÓÜã ÇáÜÓÜíÜÑÝÜÑ » No Server
• ÇáÜÌÜäÜÓ » Male
• äÞÜÇØ ÇáÊÞííã » 85
Hero ÌÜíÜÏ

Hero ÛíÑ ãÊæÇÌÏ ÍÇáíÇð



ÇÝÊÑÇÖí



íÛáÞ


ÊæÞíÚ Hero :
...!!


ãæÖæÚ ãÛáÞ


íÊÕÝÍ ÇáãæÖæÚ ÍÇáíÇð : 1 (0 ÚÖæ æ 1 ÒÇÆÑ)
 

ÖæÇÈØ ÇáãÔÇÑßÉ
áÇ ÊÓÊØíÚ ÅÖÇÝÉ ãæÇÖíÚ ÌÏíÏÉ
áÇ ÊÓÊØíÚ ÇáÑÏ Úáì ÇáãæÇÖíÚ
áÇ ÊÓÊØíÚ ÅÑÝÇÞ ãáÝÇÊ
áÇ ÊÓÊØíÚ ÊÚÏíá ãÔÇÑßÇÊß

BB code ãÊÇÍÉ
ßæÏ [IMG] ãÊÇÍÉ
ßæÏ HTML ãÚØáÉ

ÇáÇäÊÞÇá ÇáÓÑíÚ

ÇáãæÇÖíÚ ÇáãÊÔÇÈåå
ÇáãæÖæÚ ßÇÊÈ ÇáãæÖæÚ ÇáãäÊÏì ÇáÑÏæÏ ÂÎÑ ãÔÇÑßÉ
ÇÒÇí ÇÚãá Èáæß Çæ ÈÇä áÍÏ Ýí ÇááÚÈÉ NooRhan ÞÜÓÜã ÇáÇÓÜÆÜáÜå æ ÇáÇÓÜÊÜÝÜÓÜÇÑÇÊ ÍÜæá ÇáÜáÜÚÜÈÜÉ 2 31-05-2012 07:55 PM


ÇáÓÇÚÉ ÇáÂä 11:11 AM.