does anybody know how to remove the 3 day guild penalty for when you leave a guild?
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 :)Quote:
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
[Only registered and activated users can see links. Click Here To Register...]Quote:
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. :)
rules dont apply to me :)Quote:
[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.
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.Quote:
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.