3 Days Guild Penalty

12/13/2015 23:00 [Admin]Slice#1
does anybody know how to remove the 3 day guild penalty for when you leave a guild?
12/13/2015 23:14 treica#2
Doing a quick search seem i found pretty fast what is so hard to look for :P

[Only registered and activated users can see links. Click Here To Register...]


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

Code:
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
12/13/2015 23:40 [Admin]Slice#3
Quote:
Originally Posted by treica View Post
Doing a quick search seem i found pretty fast what is so hard to look for :P

[Only registered and activated users can see links. Click Here To Register...]


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

Code:
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 :)
12/14/2015 14:53 JuuF#4
Quote:
Originally Posted by [Admin]Slice View Post
thank you :)
We have a 'thanks' button already, what is the point of writing thank you instead of using that button?
12/14/2015 23:35 [Admin]Slice#5
Quote:
Originally Posted by JuuF View Post
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. :)
12/15/2015 11:17 JuuF#6
Quote:
Originally Posted by [Admin]Slice View Post
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. :)
[Only registered and activated users can see links. Click Here To Register...]

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 [Only registered and activated users can see links. Click Here To Register...] is the link. You are welcome.
12/15/2015 12:23 [Admin]Slice#7
Quote:
Originally Posted by JuuF View Post
[Only registered and activated users can see links. Click Here To Register...]

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 [Only registered and activated users can see links. Click Here To Register...] is the link. You are welcome.
rules dont apply to me :)
12/15/2015 13:36 wallerus#8
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.
12/15/2015 22:46 [Admin]Slice#9
Quote:
Originally Posted by wallerus View Post
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.