3 Days Guild Penalty

[[Admin]Slice]

does anybody know how to remove the 3 day guild penalty for when you leave a guild?

[treica]

Doing a quick search seem i found pretty fast what is so hard to look for :P




This code is what you want to modify in usp_Read_Char_GuildJoinDate_R Stored Procedure.

SELECT TOP 1 @RemainTime = CASE 
WHEN DATEDIFF ( Hour , JoinDate , GETDATE() ) >=72 THEN 0
else 72-DATEDIFF ( Hour , JoinDate , GETDATE() ) END
FROM GuildChars
WHERE CharID = @CharID
ORDER BY JoinDate DESC

[[Admin]Slice]

Originally Posted by treica

Doing a quick search seem i found pretty fast what is so hard to look for :P




This code is what you want to modify in usp_Read_Char_GuildJoinDate_R Stored Procedure.

SELECT TOP 1 @RemainTime = CASE 
WHEN DATEDIFF ( Hour , JoinDate , GETDATE() ) >=72 THEN 0
else 72-DATEDIFF ( Hour , JoinDate , GETDATE() ) END
FROM GuildChars
WHERE CharID = @CharID
ORDER BY JoinDate DESC

thank you

[JuuF]

Originally Posted by [Admin]Slice

thank you

We have a 'thanks' button already, what is the point of writing thank you instead of using that button?

[[Admin]Slice]

Originally Posted by JuuF

We have a 'thanks' button already, what is the point of writing thank you instead of using that button?

because unlike your disrespectful self, i actually care to thank people in words. now if you have nothing useful to say dont say anything at all. thank you.

[JuuF]

Originally Posted by [Admin]Slice

because unlike your disrespectful self, i actually care to thank people in words. now if you have nothing useful to say dont say anything at all. thank you.

What i said is pretty useful for almost everybody but i think you are an exception and I am sorry, I can't help you in any way since i have no education about dead brains.

If your stupidity level wasn't over 9000 you could understand the reason and usage of my post easily. Next time read the section rules and don't try to argue with people who read more than you.

I know it will be pretty hard to find rules for someone like you, so is the link. You are welcome.

[[Admin]Slice]

Originally Posted by JuuF

What i said is pretty useful for almost everybody but i think you are an exception and I am sorry, I can't help you in any way since i have no education about dead brains.

If your stupidity level wasn't over 9000 you could understand the reason and usage of my post easily. Next time read the section rules and don't try to argue with people who read more than you.

I know it will be pretty hard to find rules for someone like you, so is the link. You are welcome.

rules dont apply to me

[wallerus]

Thanks JuuF! (Irony for those that didn't catch it)

Slice. You've used these forums to better your knowledge and you've even asked the kind and knowledgeable people on these forums for help, just as you have right here in this thread.

How about you get a little respect for Autrux who's job it is to deal with these shitposts, for those like JuuF who've given a plethora of information to this community on their own accord and for the forum community as a whole.
Don't act like you're above the rules because you're not, you just emit a horrible odor of disrespect for your peers here and it's this type of arrogant, stupid, cuntish behaviour that's driven great people from the Shaiya Epvp community, how about don't try push 1 of the last remaining good devs in JuuF away.

Nobody cares if you want to type out your thanks, it's not the proper way to do it. It's spam. If everyone wrote "thanks" threads would have multiple unnecessary pages for people to navigate and that's a pain in the ****.

The kind people who've helped also don't get a cute little +1 to their "Received Thanks" stat, no matter how silly you might think it is, the "Thanks" button is there for a reason, so ******* use it.

[[Admin]Slice]

Originally Posted by wallerus

Thanks JuuF! (Irony for those that didn't catch it)

Slice. You've used these forums to better your knowledge and you've even asked the kind and knowledgeable people on these forums for help, just as you have right here in this thread.

How about you get a little respect for Autrux who's job it is to deal with these shitposts, for those like JuuF who've given a plethora of information to this community on their own accord and for the forum community as a whole.
Don't act like you're above the rules because you're not, you just emit a horrible odor of disrespect for your peers here and it's this type of arrogant, stupid, cuntish behaviour that's driven great people from the Shaiya Epvp community, how about don't try push 1 of the last remaining good devs in JuuF away.

Nobody cares if you want to type out your thanks, it's not the proper way to do it. It's spam. If everyone wrote "thanks" threads would have multiple unnecessary pages for people to navigate and that's a pain in the arse.

The kind people who've helped also don't get a cute little +1 to their "Received Thanks" stat, no matter how silly you might think it is, the "Thanks" button is there for a reason, so fucking use it.

i apologize, i was in a bad mood this morning and i was disrespectful, i apologize for my bad attitude. i have been on this forum for awhile and usually am not like that. i try to be nice and kind to all. so again, i apologize for my bad attitude. now i know this might sound stupid after my arguement and how rude i was being but i wasnt feeling it so i was being a douche and i know thats not right i just hope you can take my apology into consideration. i am not trying to drive any devs away. that is not my attention. this is a great community and i didnt mean to do any wrongs.