Fix : Guild Not Show Members

[emekpc]

Telecaster db has two read methods for guild members.
1- for Guild Manager
2- for Guild Members

for guild members read not necessary to fix. but guild manager not show members after reset gameserver.

USE [Telecaster]
GO
/****** Object: StoredProcedure [dbo].[smp_insert_guild] Script Date: 18.05.2012 19:19:34 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

-- start of smp_insert_guild
CREATE PROCEDURE [dbo].[smp_insert_guild]

@IN_NAME NVARCHAR(31),
@IN_GUILD_SID INT,
@IN_LEADER_SID INT,
@IN_ADVERTISE_TYPE INT,
@IN_RECRUITING INT,
@IN_MIN_RECRUIT_LEVEL INT,
@IN_MAX_RECRUIT_LEVEL INT,
@IN_PERMISSION_NAME_1 nvarchar(MAX),
@IN_PERMISSION_NAME_2 nvarchar(MAX),
@IN_PERMISSION_NAME_3 nvarchar(MAX),
@IN_PERMISSION_NAME_4 nvarchar(MAX),
@IN_PERMISSION_NAME_5 nvarchar(MAX),
@IN_PERMISSION_NAME_6 nvarchar(MAX)

AS
SET NOCOUNT ON
DECLARE @ACCOUNT varchar (MAX)
DECLARE @LV INT
DECLARE @JOB varchar (MAX)
INSERT INTO Guild(
sid,
name,
notice,
icon,
icon_size,
banner,
banner_size,
name_changed,
dungeon_id,
dungeon_block_time,
gold,
chaos,
alliance_id,
alliance_block_time,
donation_point,
PERMISSION_NAME_1,
PERMISSION_NAME_2,
PERMISSION_NAME_3,
PERMISSION_NAME_4,
PERMISSION_NAME_5,
PERMISSION_NAME_6,
ADVERTISE_TYPE,
ADVERTISE_END_TIME,
ADVERTISE_COMMENT,
RECRUITING,
MIN_RECRUIT_LEVEL,
MAX_RECRUIT_LEVEL,
URL,
PERMISSION_SET_1,
PERMISSION_SET_2,
PERMISSION_SET_3,
PERMISSION_SET_4,
PERMISSION_SET_5,
PERMISSION_SET_6
)
VALUES(
@IN_GUILD_SID,
@IN_NAME,
'',
'',
0,
'',
0,
0,
0,
0,
0,
0,
0,
0,
0,
@IN_PERMISSION_NAME_1, @IN_PERMISSION_NAME_2, @IN_PERMISSION_NAME_3,
@IN_PERMISSION_NAME_4, @IN_PERMISSION_NAME_5, @IN_PERMISSION_NAME_6,
@IN_ADVERTISE_TYPE, '', 0, @IN_RECRUITING, @IN_MIN_RECRUIT_LEVEL, @IN_MAX_RECRUIT_LEVEL, '',0,0,0,0,0,0);

IF EXISTS (SELECT player_id FROM GuildMember WHERE player_id = @IN_LEADER_SID)
BEGIN
UPDATE GuildMember SET guild_id = @IN_GUILD_SID, permission = 7 WHERE player_id = @IN_LEADER_SID
END
ELSE
BEGIN
INSERT INTO Guildmember(player_id, guild_id, prev_guild_id, guild_block_time, permission, memo)
VALUES(@IN_LEADER_SID, @IN_GUILD_SID, 0, 0, 7,'');
END


-- end of smp_insert_guild

USE [Telecaster]
GO
/****** Object: StoredProcedure [dbo].[smp_set_guild] Script Date: 18.05.2012 19:20:16 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- start of smp_set_party

CREATE PROCEDURE [dbo].[smp_set_guild]
@IN_PLAYER_SID INT,
@IN_GUILD_SID INT,
@IN_PREV_GUILD_SID INT

AS
SET NOCOUNT ON

UPDATE Character SET guild_id = @IN_GUILD_SID, prev_guild_id = @IN_PREV_GUILD_SID WHERE sid = @IN_PLAYER_SID

IF EXISTS (SELECT player_id FROM GuildMember WHERE player_id = @IN_PLAYER_SID)
BEGIN
UPDATE GuildMember SET guild_id = @IN_GUILD_SID, prev_guild_id = @IN_PREV_GUILD_SID WHERE player_id = @IN_PLAYER_SID
END
ELSE
BEGIN
INSERT INTO Guildmember(player_id, guild_id, prev_guild_id, guild_block_time, permission, memo)
VALUES(@IN_PLAYER_SID, @IN_GUILD_SID, 0, 0, 1,'');
END

-- end of smp_set_guild

[ismokedrow]

+1

[gruce]

-2

[Blackcat2011]

Message 2714, Level 16, State 3, Procedure smp_insert_guild, line 3
The database already exists an object called "smp_insert_guild".
what to do?

[c1ph3r]

Originally Posted by Blackcat2011

Message 2714, Level 16, State 3, Procedure smp_insert_guild, line 3
The database already exists an object called "smp_insert_guild".
what to do?

Hmm let me think about it...perhaps you have to read the errormessage and try to use your brain.

Perhaps there allready exists an object called "smp_insert_guild" and you have to alter this stored procedure instead of trying to creat it.

If you don't have any clue about databases, you should not try to setup a complete rappelz server! It's like driving a car without arms and legs...It won't end successfully^^

[Blackcat2011]

I understand the meaning of the error.
I do not know how to fix the already established before the procedure

[c1ph3r]

There are two ways to fix this problem...deleting the old smp or modifying the create-ctatements....