MC Web Designs
- Joined
- Oct 28, 2010
- Messages
- 888
- Reaction score
- 111
Hi guys, credit to this thread goes to nabby59.
How 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):
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):
Now change
to the same value you entered above. i.e. 5 minutes again
How 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())))