Guild ! Again...

[emekpc]

When guild leader transfer leadership to other person, firstly normal all process. but after relog, leadership reback transfer first guild leader.
is there any fix about this ?

[ismokedrow]

You need to look at dbo.smp_set_guild_leader


Look Here:

 Spoiler

USE [Telecaster]
GO
/****** Object:  StoredProcedure [dbo].[smp_set_guild_leader]    Script Date: 9/23/2012 3:01:02 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

-- start of smp_set_guild_leader
ALTER PROCEDURE [dbo].[smp_set_guild_leader]
@IN_SID					INT, -- This defines the "Current" leaders ID
@IN_LEADER_SID			INT -- This defines the "New" leaders ID

AS
SET NOCOUNT ON

BEGIN TRANSACTION

-- Normal Member Permission = 1 / Leader Permission = 7
-- SET OLD Leader to "Normal Member"

UPDATE dbo.GuildMember SET permission = 1 WHERE guild_id = @IN_SID AND permission = 7

-- SET NEW Leader

UPDATE dbo.GuildMember SET permission = 7 WHERE player_id = @IN_LEADER_SID

COMMIT TRANSACTION

-- end of smp_set_guild_leader

If yours does not look like the above spoiler, that's probably your issue. If you need further assistance please feel free to say so.

[emekpc]

thanks you, ismokedrow... but i tried, and i tried, and i tried.
and i tired...

[ismokedrow]

emekpc, you are not providing any detailed information. You should try to use the smp I have provided and tell me your results from there I can help you further.

[emekpc]

Thanks really ismokedrow...
your sample clearly. actually my head is very confused me. may be i sleeping...
thanks again...

[Tekknoid]

Nulled

[ismokedrow]

Tekknoid i'm not really sure what you're talking about. The OP has a guild issue, I gave him the smp and as long as his guild tables were formed correctly it should have resolved his issue.

As too Apache vs. IIS my preference is IIS. You can use directory disable, web.config and other methods to prevent unwanted access to sensitive folders. In your opinion IIS may be "Stupid" but I find it very fluid and easy to use.

[Tekknoid]

wrong Thread -.-^^ nulled my comment

[Tofrum]

There is delete option ^^

[LeoMessi1899]

+1 Tofrum

[Tekknoid]

Originally Posted by Tofrum

There is delete option ^^

made my day^^