Guild Penalty

07/24/2020 03:48 mudik#1
Can anyone help me and say me why i get this: [Only registered and activated users can see links. Click Here To Register...]

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
07/24/2020 06:31 NorseGodTyr#2
Quote:
Originally Posted by mudik View Post
Can anyone help me and say me why i get this: [Only registered and activated users can see links. Click Here To Register...]

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, @[Only registered and activated users can see links. Click Here To Register...]D int, @[Only registered and activated users can see links. Click Here To Register...]Keep int,
@Data1 int,
@Data2 int,
--##begin due to develop composite item
@Data3 int,
@Data4 int,
@Data5 int,
@Data6 int,
@Data7 int,
@Data8 int, @[Only registered and activated users can see links. Click Here To Register...]64 bigint, @[Only registered and activated users can see links. Click Here To Register...] int
--##end due to develop composite item
if (not exists (select CharID from _Char with (nolock) where CharID = @CharID))
return -1
if @[Only registered and activated users can see links. Click Here To Register...]Keep <= 0)
return -2
declare @[Only registered and activated users can see links. Click Here To Register...]JobID int
set @[Only registered and activated users can see links. Click Here To Register...]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 @[Only registered and activated users can see links. Click Here To Register...]D = 1 and @Category = 2 and @[Only registered and activated users can see links. Click Here To Register...]64=0) or @[Only registered and activated users can see links. Click Here To Register...]D = 2 and @Category = 2 and @[Only registered and activated users can see links. Click Here To Register...]64=0) --For Guild and CharJob
if ( @[Only registered and activated users can see links. Click Here To Register...]D = 1 and @Category = 2 and @[Only registered and activated users can see links. Click Here To Register...]64=0) or @[Only registered and activated users can see links. Click Here To Register...]D = 2 and @Category = 2 and @[Only registered and activated users can see links. Click Here To Register...]64=0)) or @[Only registered and activated users can see links. Click Here To Register...]D = 2 and @Category = 2 and @[Only registered and activated users can see links. Click Here To Register...]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, @[Only registered and activated users can see links. Click Here To Register...]D, @[Only registered and activated users can see links. Click Here To Register...]Keep, @Data1, @Data2, @Data3, @Data4, @Data5, @Data6, @Data7, @Data8, @[Only registered and activated users can see links. Click Here To Register...]64, @[Only registered and activated users can see links. Click Here To Register...])

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, @[Only registered and activated users can see links. Click Here To Register...]D, @[Only registered and activated users can see links. Click Here To Register...]Keep, @Data1, @Data2, @Data3, @Data4, @Data5, @Data6, @Data7, @Data8, @[Only registered and activated users can see links. Click Here To Register...]64, @[Only registered and activated users can see links. Click Here To Register...])
END
--##end due to develop composite item
set @[Only registered and activated users can see links. Click Here To Register...]JobID = @@identity
if (@@error <> 0 or @@rowcount = 0)

return -3
return @[Only registered and activated users can see links. Click Here To Register...]JobID
07/24/2020 20:33 mudik#3
Quote:
Originally Posted by NorseGodTyr View Post
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, @[Only registered and activated users can see links. Click Here To Register...]D int, @[Only registered and activated users can see links. Click Here To Register...]Keep int,
@Data1 int,
@Data2 int,
--##begin due to develop composite item
@Data3 int,
@Data4 int,
@Data5 int,
@Data6 int,
@Data7 int,
@Data8 int, @[Only registered and activated users can see links. Click Here To Register...]64 bigint, @[Only registered and activated users can see links. Click Here To Register...] int
--##end due to develop composite item
if (not exists (select CharID from _Char with (nolock) where CharID = @CharID))
return -1
if @[Only registered and activated users can see links. Click Here To Register...]Keep <= 0)
return -2
declare @[Only registered and activated users can see links. Click Here To Register...]JobID int
set @[Only registered and activated users can see links. Click Here To Register...]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 @[Only registered and activated users can see links. Click Here To Register...]D = 1 and @Category = 2 and @[Only registered and activated users can see links. Click Here To Register...]64=0) or @[Only registered and activated users can see links. Click Here To Register...]D = 2 and @Category = 2 and @[Only registered and activated users can see links. Click Here To Register...]64=0) --For Guild and CharJob
if ( @[Only registered and activated users can see links. Click Here To Register...]D = 1 and @Category = 2 and @[Only registered and activated users can see links. Click Here To Register...]64=0) or @[Only registered and activated users can see links. Click Here To Register...]D = 2 and @Category = 2 and @[Only registered and activated users can see links. Click Here To Register...]64=0)) or @[Only registered and activated users can see links. Click Here To Register...]D = 2 and @Category = 2 and @[Only registered and activated users can see links. Click Here To Register...]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, @[Only registered and activated users can see links. Click Here To Register...]D, @[Only registered and activated users can see links. Click Here To Register...]Keep, @Data1, @Data2, @Data3, @Data4, @Data5, @Data6, @Data7, @Data8, @[Only registered and activated users can see links. Click Here To Register...]64, @[Only registered and activated users can see links. Click Here To Register...])

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, @[Only registered and activated users can see links. Click Here To Register...]D, @[Only registered and activated users can see links. Click Here To Register...]Keep, @Data1, @Data2, @Data3, @Data4, @Data5, @Data6, @Data7, @Data8, @[Only registered and activated users can see links. Click Here To Register...]64, @[Only registered and activated users can see links. Click Here To Register...])
END
--##end due to develop composite item
set @[Only registered and activated users can see links. Click Here To Register...]JobID = @@identity
if (@@error <> 0 or @@rowcount = 0)

return -3
return @[Only registered and activated users can see links. Click Here To Register...]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
07/24/2020 20:35 NorseGodTyr#4
Der fügt das hier nicht komplett ein die fehler stehen aber dort beim error und welche line
07/24/2020 21:26 mudik#5
Quote:
Originally Posted by NorseGodTyr View Post
Der fügt das hier nicht komplett ein die fehler stehen aber dort beim error und welche line
Danke dir.
08/27/2020 00:47 mudik#6
Quote:
Originally Posted by NorseGodTyr View Post
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, @[Only registered and activated users can see links. Click Here To Register...]D int, @[Only registered and activated users can see links. Click Here To Register...]Keep int,
@Data1 int,
@Data2 int,
--##begin due to develop composite item
@Data3 int,
@Data4 int,
@Data5 int,
@Data6 int,
@Data7 int,
@Data8 int, @[Only registered and activated users can see links. Click Here To Register...]64 bigint, @[Only registered and activated users can see links. Click Here To Register...] int
--##end due to develop composite item
as
if (not exists (select CharID from _Char with (nolock) where CharID = @CharID))
return -1
if @[Only registered and activated users can see links. Click Here To Register...]Keep <= 0)
return -2
declare @[Only registered and activated users can see links. Click Here To Register...]JobID int
set @[Only registered and activated users can see links. Click Here To Register...]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 @[Only registered and activated users can see links. Click Here To Register...]D = 1 and @Category = 2 and @[Only registered and activated users can see links. Click Here To Register...]64=0) or @[Only registered and activated users can see links. Click Here To Register...]D = 2 and @Category = 2 and @[Only registered and activated users can see links. Click Here To Register...]64=0) --For Guild and CharJob
if ( @[Only registered and activated users can see links. Click Here To Register...]D = 1 and @Category = 2 and @[Only registered and activated users can see links. Click Here To Register...]64=0) or @[Only registered and activated users can see links. Click Here To Register...]D = 2 and @Category = 2 and @[Only registered and activated users can see links. Click Here To Register...]64=0 or @[Only registered and activated users can see links. Click Here To Register...]D = 2 and @Category = 2 and @[Only registered and activated users can see links. Click Here To Register...]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, @[Only registered and activated users can see links. Click Here To Register...]D, @[Only registered and activated users can see links. Click Here To Register...]Keep, @Data1, @Data2, @Data3, @Data4, @Data5, @Data6, @Data7, @Data8, @[Only registered and activated users can see links. Click Here To Register...]64, @[Only registered and activated users can see links. Click Here To Register...])
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, @[Only registered and activated users can see links. Click Here To Register...]D, @[Only registered and activated users can see links. Click Here To Register...]Keep, @Data1, @Data2, @Data3, @Data4, @Data5, @Data6, @Data7, @Data8, @[Only registered and activated users can see links. Click Here To Register...]64, @[Only registered and activated users can see links. Click Here To Register...])
END
--##end due to develop composite item
set @[Only registered and activated users can see links. Click Here To Register...]JobID = @@identity
if (@@error <> 0 or @@rowcount = 0)

return -3
return @[Only registered and activated users can see links. Click Here To Register...]JobID




Falls mal irgendwann mal das selbe Problem bekommen sollte.