How to remove 48hrs rejoin to guild

[macboyem07]

anybody help

[FunkyJustice]

Look

A Script for a Homepage to reset the Guild Rejoin Time

[Chriѕ]

Just change it in the Database.

1. (Character DBF -> programmability -> stored Procedures)


2. Search "dbo.GUILD_STR" , rightclick and click Change.


3. Search :

PHP Code:

IF @iGu = 'D1'
BEGIN

UPDATE CHARACTER_TBL
SET m_tGuildMember = CONVERT(CHAR(8),DATEADD(d,2,GETDATE()),112) 
+ RIGHT('00' + CONVERT(VARCHAR(2),DATEPART(hh,DATEADD(d,2,GETDATE()))),2) 
+ RIGHT('00' + CONVERT(VARCHAR(2),DATEPART(mi,DATEADD(d,2,GETDATE()))),2) 
+ RIGHT('00' + CONVERT(VARCHAR(2),DATEPART(ss,DATEADD(d,2,GETDATE()))),2) 


And change it to:

PHP Code:

IF @iGu = 'D1'
BEGIN

UPDATE CHARACTER_TBL
SET m_tGuildMember = CONVERT(CHAR(8),DATEADD(mi,1,GETDATE()),112) 
+ RIGHT('00' + CONVERT(VARCHAR(2),DATEPART(hh,DATEADD(mi,1,GETDATE()))),2) 
+ RIGHT('00' + CONVERT(VARCHAR(2),DATEPART(mi,DATEADD(mi,1,GETDATE()))),2) 
+ RIGHT('00' + CONVERT(VARCHAR(2),DATEPART(ss,DATEADD(mi,1,GETDATE()))),2) 


Search:

PHP Code:

IF @iGu = 'D2'
BEGIN

UPDATE CHARACTER_TBL
SET m_tGuildMember = CONVERT(CHAR(8),DATEADD(d,2,GETDATE()),112) 
+ RIGHT('00' + CONVERT(VARCHAR(2),DATEPART(hh,DATEADD(d,2,GETDATE()))),2) 
+ RIGHT('00' + CONVERT(VARCHAR(2),DATEPART(mi,DATEADD(d,2,GETDATE()))),2) 
+ RIGHT('00' + CONVERT(VARCHAR(2),DATEPART(ss,DATEADD(d,2,GETDATE()))),2) 


Change it to :

PHP Code:

IF @iGu = 'D2'
BEGIN

UPDATE CHARACTER_TBL
SET m_tGuildMember = CONVERT(CHAR(8),DATEADD(mi,1,GETDATE()),112) 
+ RIGHT('00' + CONVERT(VARCHAR(2),DATEPART(hh,DATEADD(mi,1,GETDATE()))),2) 
+ RIGHT('00' + CONVERT(VARCHAR(2),DATEPART(mi,DATEADD(mi,1,GETDATE()))),2) 
+ RIGHT('00' + CONVERT(VARCHAR(2),DATEPART(ss,DATEADD(mi,1,GETDATE()))),2) 


Just leave a Guild and Logout -> Login and you will not have any Guildrejoin time.
__________________

[World.o.Flyff]

To change the amount of time before you can rejoin a guild:

This has two parts. The first is the cache so this works while you stay logged in and the second you have to change some stored procedures in the database.

First part:

Find this line in DPCacheSrvr (its in there twice):

pPlayer->m_tGuildMember += CTimeSpan( 2, 0, 0, 0 );

Change the (2, 0, 0, 0) to what you want in the format of (Days, Hours, Minutes, Seconds). i.e. 5 minutes (0, 0, 5, 0)

Second part:

Find the GUILD_STR stored procedure in CHARACTER_DBF and find this in the procedure (Again its there twice):

SET m_tGuildMember = CONVERT(CHAR(8),DATEADD(d,2,GETDATE()),112) 
+ RIGHT('00' + CONVERT(VARCHAR(2),DATEPART(hh,DATEADD(d,2,GETDATE()))),2) 
+ RIGHT('00' + CONVERT(VARCHAR(2),DATEPART(mi,DATEADD(d,2,GETDATE()))),2) 
+ RIGHT('00' + CONVERT(VARCHAR(2),DATEPART(ss,DATEADD(d,2,GETDATE()))),2)

Now change

DATEADD(d,2,GETDATE())))

to the same value you entered above. i.e. 5 minutes again

DATEADD(mi,5,GETDATE())))

[©ross]

and this is already released..

[macboyem07]

thanks guys