Guild Penalty

[mudik]

Can anyone help me and say me why i get this:

When i teleport i can create new guild/when i relog i can create a new guild. I want the original system which says you have to wait 3-7days

[NorseGodTyr]

Originally Posted by mudik

Can anyone help me and say me why i get this:

When i teleport i can create new guild/when i relog i can create a new guild. I want the original system which says you have to wait 3-7days

Der GameServer und die Procedure wurde bearbeitet so wie es aussieht

Schau mal in shard bei procedure _AddTimedJob
das müsste eig, so aussehen

USE [SRO_VT_SHARD]
GO
/****** Object: StoredProcedure [dbo].[_AddTimedJob] Script Date: 24.07.2020 06:32:39 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER procedure [dbo].[_AddTimedJob]
@CharID int,
@Category tinyint, @D int, @Keep int,
@Data1 int,
@Data2 int,
--##begin due to develop composite item
@Data3 int,
@Data4 int,
@Data5 int,
@Data6 int,
@Data7 int,
@Data8 int, @64 bigint, @ int
--##end due to develop composite item
if (not exists (select CharID from _Char with (nolock) where CharID = @CharID))
return -1
if @Keep <= 0)
return -2
declare @JobID int
set @JobID = 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 @D = 1 and @Category = 2 and @64=0) or @D = 2 and @Category = 2 and @64=0) --For Guild and CharJob
if ( @D = 1 and @Category = 2 and @64=0) or @D = 2 and @Category = 2 and @64=0)) or @D = 2 and @Category = 2 and @64=0) --For Guild and CharJob
BEGIN
insert into _TimedJob(CharID,Category,JobID,TimeToKeep,Data1,D ata2,Data3,Data4,Data5,Data6,Data7,Data8,Serial64, JID)
values(@CharID, @Category, @D, @Keep, @Data1, @Data2, @Data3, @Data4, @Data5, @Data6, @Data7, @Data8, @64, @)

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, @D, @Keep, @Data1, @Data2, @Data3, @Data4, @Data5, @Data6, @Data7, @Data8, @64, @)
END
--##end due to develop composite item
set @JobID = @@identity
if (@@error <> 0 or @@rowcount = 0)

return -3
return @JobID

[mudik]

Originally Posted by NorseGodTyr

Der GameServer und die Procedure wurde bearbeitet so wie es aussieht

Schau mal in shard bei procedure _AddTimedJob
das müsste eig, so aussehen

USE [SRO_VT_SHARD]
GO
/****** Object: StoredProcedure [dbo].[_AddTimedJob] Script Date: 24.07.2020 06:32:39 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER procedure [dbo].[_AddTimedJob]
@CharID int,
@Category tinyint, @D int, @Keep int,
@Data1 int,
@Data2 int,
--##begin due to develop composite item
@Data3 int,
@Data4 int,
@Data5 int,
@Data6 int,
@Data7 int,
@Data8 int, @64 bigint, @ int
--##end due to develop composite item
if (not exists (select CharID from _Char with (nolock) where CharID = @CharID))
return -1
if @Keep <= 0)
return -2
declare @JobID int
set @JobID = 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 @D = 1 and @Category = 2 and @64=0) or @D = 2 and @Category = 2 and @64=0) --For Guild and CharJob
if ( @D = 1 and @Category = 2 and @64=0) or @D = 2 and @Category = 2 and @64=0)) or @D = 2 and @Category = 2 and @64=0) --For Guild and CharJob
BEGIN
insert into _TimedJob(CharID,Category,JobID,TimeToKeep,Data1,D ata2,Data3,Data4,Data5,Data6,Data7,Data8,Serial64, JID)
values(@CharID, @Category, @D, @Keep, @Data1, @Data2, @Data3, @Data4, @Data5, @Data6, @Data7, @Data8, @64, @)

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, @D, @Keep, @Data1, @Data2, @Data3, @Data4, @Data5, @Data6, @Data7, @Data8, @64, @)
END
--##end due to develop composite item
set @JobID = @@identity
if (@@error <> 0 or @@rowcount = 0)

return -3
return @JobID

Msg 156, Level 15, State 1, Procedure _AddTimedJob, Line 14 [Batch Start Line 7]
Incorrect syntax near the keyword 'if'.
Msg 102, Level 15, State 1, Procedure _AddTimedJob, Line 16 [Batch Start Line 7]
Incorrect syntax near ')'.
Msg 102, Level 15, State 1, Procedure _AddTimedJob, Line 23 [Batch Start Line 7]
Incorrect syntax near ')'.
Msg 102, Level 15, State 1, Procedure _AddTimedJob, Line 25 [Batch Start Line 7]
Incorrect syntax near 'ata2'.
Msg 102, Level 15, State 1, Procedure _AddTimedJob, Line 32 [Batch Start Line 7]
Incorrect syntax near 'ata2'.


funktioniert leider nicht

[NorseGodTyr]

Der fügt das hier nicht komplett ein die fehler stehen aber dort beim error und welche line

[mudik]

Originally Posted by NorseGodTyr

Der fügt das hier nicht komplett ein die fehler stehen aber dort beim error und welche line

Danke dir.

[mudik]

Originally Posted by NorseGodTyr

Der fügt das hier nicht komplett ein die fehler stehen aber dort beim error und welche line

Hat wunderbar geklappt bedanke mich nochmal hier, sorry für die späte antwort aber hatte in real life viel zu tun...


USE [SRO_VT_SHARD]
GO
/****** Object: StoredProcedure [dbo].[_AddTimedJob] Script Date: 8/27/2020 12:41:56 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER procedure [dbo].[_AddTimedJob]
@CharID int,
@Category tinyint, @D int, @Keep int,
@Data1 int,
@Data2 int,
--##begin due to develop composite item
@Data3 int,
@Data4 int,
@Data5 int,
@Data6 int,
@Data7 int,
@Data8 int, @64 bigint, @ int
--##end due to develop composite item
as
if (not exists (select CharID from _Char with (nolock) where CharID = @CharID))
return -1
if @Keep <= 0)
return -2
declare @JobID int
set @JobID = 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 @D = 1 and @Category = 2 and @64=0) or @D = 2 and @Category = 2 and @64=0) --For Guild and CharJob
if ( @D = 1 and @Category = 2 and @64=0) or @D = 2 and @Category = 2 and @64=0 or @D = 2 and @Category = 2 and @64=0 --For Guild and CharJob
BEGIN
insert into _TimedJob(CharID,Category,JobID,TimeToKeep,Data1,D ata2,Data3,Data4,Data5,Data6,Data7,Data8,Serial64, JID)
values(@CharID, @Category, @D, @Keep, @Data1, @Data2, @Data3, @Data4, @Data5, @Data6, @Data7, @Data8, @64, @)
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, @D, @Keep, @Data1, @Data2, @Data3, @Data4, @Data5, @Data6, @Data7, @Data8, @64, @)
END
--##end due to develop composite item
set @JobID = @@identity
if (@@error <> 0 or @@rowcount = 0)

return -3
return @JobID




Falls mal irgendwann mal das selbe Problem bekommen sollte.