How to remove 48hrs rejoin to guild

05/09/2013 10:51 macboyem07#1
:handsdown:anybody help :handsdown:
05/09/2013 11:53 FunkyJustice#2
Look [Only registered and activated users can see links. Click Here To Register...]

A Script for a Homepage to reset the Guild Rejoin Time
05/10/2013 03:37 Chriѕ#3
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.
__________________
05/10/2013 12:26 World.o.Flyff#4
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):

Code:
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):

Code:
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

Code:
DATEADD(d,2,GETDATE())))
to the same value you entered above. i.e. 5 minutes again

Code:
DATEADD(mi,5,GETDATE())))
05/10/2013 12:27 İross#5
and this is already released..
[Only registered and activated users can see links. Click Here To Register...]
05/10/2013 13:26 macboyem07#6
thanks guys :D