Register for your free account! | Forgot your password?

Go Back   elitepvpers > MMORPGs > Rappelz > Rappelz Private Server
You last visited: Today at 22:56

  • Please register to post and access all features, it's quick, easy and FREE!

 

Fix : Guild Not Show Members

Reply
 
Old   #1
 
elite*gold: 0
Join Date: Jan 2011
Posts: 27
Received Thanks: 15
Cool Fix : Guild Not Show Members

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.
Quote:
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
Quote:
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



emekpc is offline  
Thanks
7 Users
Old   #2
 
elite*gold: 0
Join Date: Oct 2010
Posts: 2,557
Received Thanks: 2,411
+1


ismokedrow is offline  
Old   #3
 
elite*gold: 0
Join Date: Aug 2011
Posts: 161
Received Thanks: 36
-2
gruce is offline  
Thanks
1 User
Old   #4
 
elite*gold: 0
Join Date: May 2011
Posts: 49
Received Thanks: 7
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?


Blackcat2011 is offline  
Old   #5
 
elite*gold: 0
Join Date: Sep 2008
Posts: 1,570
Received Thanks: 1,154
Quote:
Originally Posted by Blackcat2011 View Post
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^^
c1ph3r is offline  
Old   #6
 
elite*gold: 0
Join Date: May 2011
Posts: 49
Received Thanks: 7
I understand the meaning of the error.
I do not know how to fix the already established before the procedure
Blackcat2011 is offline  
Old   #7
 
elite*gold: 0
Join Date: Sep 2008
Posts: 1,570
Received Thanks: 1,154


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


c1ph3r is offline  
Thanks
2 Users
Reply



« Previous Thread | Next Thread »

Similar Threads
Guild Members
Hey guys...I've recently tried to search if a Character is in the guild with me... I tried to search them with MyGuild.Members.contains(C.entityID)...
4 Replies - CO2 PServer - Discussions / Questions
Recuiting Guild members on OMG guild
i need a Guild members.. :mofo: Guild name: Removed Just Contect me to my Yahoo messanger.. :cool::cool: Thanks! :)
1 Replies - Grand Chase Philippines
Looking for members for my guild!
Hey guys! just uploading some pick's. we got good members in our guild.. we are looking for high lvls and low lvls once you are active and talk...
14 Replies - SRO PServer - Discussions / Questions
New guild need members
Hi all, Guys i have guild lvl 2+115% but i need active and funny people to my guild only u must speak english and lvl 30+ who need pm me in game...
6 Replies - SRO PServer - Discussions / Questions
kicking guild members if BM without guild director
All right this is my first post so excuse me if im a bit noobie. This is a glitch and a tip to kicking members when u dont want to go to the Guild...
8 Replies - CO2 Guides & Templates



All times are GMT +2. The time now is 22:56.


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.

Support | Contact Us | FAQ | Advertising | Privacy Policy
Copyright ©2017 elitepvpers All Rights Reserved.