Printable View
hm if youre useing mssql 2008 thats strange as you shouldnt recieve those errors .. cant help ya then .. normally mssql 2005 throws those errors when useing the new mssql 2008 syntax (declaring and initialising variables in one line with declare and = instead of set for example)
you could try to declare all variables before initialising them and use Set to initialise them instead of useing = (where applicable)
np problem bro i added it maniual and it full work :D
:( -,-'
not work need full fix
madengo, you need to move your code up, this line (on this proc) "return @NewJobID" ends the procedure, so ignore code bellow it. put the code next to this "--##end due to develop composite item"
use this:Quote:
Originally Posted by MaDenGo
PHP Code:USE [SRO_VT_SHARD]
GO
/****** Object: StoredProcedure [dbo].[_AddTimedJob] Script Date: 06/05/2013 15:10:09 ******/
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(@JobID = '35032') -- 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
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 and @Category = 2 and @Serial64=0) or (@JobID = 2 and @Category = 2 and @Serial64=0) --For Guild and CharJob
if (@JobID = 1 and @Category = 2 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 <> 0 or @@rowcount = 0)
return -3
return @NewJobID
Thanks alot working now <3Quote:
Originally Posted by Caosfox
<3 thank you bro working now...Quote:
Originally Posted by lemoniscool
any picture of how this work ? .. thx in adv.
Before loggin in game, in _Char change your character name to have @ before it like > SupremeSRO => "@SupremeSRO"Quote:
Originally Posted by SupremeSRO
you will be able to see the effect.
Not CharID, but CharName16 ... your ingame name.. for example your character is called HellBurner ... you go in _Char and on CharName16 where you see HellBurner just put @ before the name so it will be @HellBurner .. login ingame..Quote:
Originally Posted by loveme
Hey friend i have this error.
http://imageshack.com/a/img834/9167/5kv2.jpg
My lines in Skilldata35000_Enc is this:
please help me :*::*::?:PHP Code:1 45000 1225 SKILL_MALL_CHANGENAME ???? ???? SKILL_MALL_CHANGENAME 0 1 1 0 0 0 0 0 1000 0 0 0 3599 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 3 0 0 255 255 0 0 0 0 0 255 255 255 255 item\etc\mall_optlevel_upgrade_scroll_1.ddj SN_SKILL_MALL_CHANGENAME xxx SN_SKILL_MALL_CHANGENAME_TT_DESC xxx 0 0 3 1667396966 1851946342 1685418593 1500 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
1 45001 1226 SKILL_MALL_STATS_POINT_RECALL_A ???? ???? SKILL_MALL_STATS_POINT_RECALL_A 0 1 1 0 0 0 0 0 1000 0 0 0 3599 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 3 0 0 255 255 0 0 0 0 0 255 255 255 255 item\etc\mall_stats_point_recall_81lv.ddj SN_ITEM__MALL_STATS_POINT_RECALL_A xxx SN_ITEM_MALL_STATS_POINT_RECALL_A_TT_DESC xxx 0 0 3 1667396966 1851946342 1685418593 1500 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0