How to change FlyFF Guild Re-Join Time.

[Military]

1. I re-posted it because people asked for it.

2. It was in a post, and i thought it would be useful to re-release it.

It was already here, so there wasn't a need to repost it.

 

[A n G r Y]

if 1 sec what is the pattern

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

CORRECT OR WRONG :/

 

[A n G r Y]

if 1 sec what is the pattern

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

correct or wrong :/

bummp !

 

[A n G r Y]

if 1 sec what is the pattern

set m_tguildmember = convert(char(8),dateadd(d,2,getdate()),112)
+ right('00' + convert(varchar(2),datepart(hh,dateadd(d,0,getdate()))),2)
+ right('00' + convert(varchar(2),datepart(mi,dateadd(d,0,getdate()))),2)
+ right('00' + convert(varchar(2),datepart(ss,dateadd(d,1,getdate()))),2)

correct or wrong :/

bumppppp i need this please answer ...

 

[x1122]

Thanks