Why remove user from premium data, and not set as normal player?Quote:
Originally Posted by gustavobm
Printable View
Why remove user from premium data, and not set as normal player?Quote:
Originally Posted by gustavobm
There isnt a "normal player" in premium data, so the "fix" prevent users to be removed...Quote:
Originally Posted by SmileYzn
Another way is to change the ExpireDate to future date and paycode to 0.. Like this:
And the problem is fixed too..Quote:
void RemoveBill(char* szId){
char szQuery[256];
sprintf(szQuery,"UPDATE MEMB_INFO set PayCode='0', ExpireDate=DATEADD(year,5,GETDATE()) WHERE memb___id = '%s'",szId);
g_JoinServerConnectDB.Exec(szQuery);
If you use this fix, is more easy when instert a new account, update premium data with 0.Quote:
Originally Posted by rusolp
The problem is (and i don't know why) when it runs a Query to select user info in PremiumData and the result of ExpireDate is NULL for some reason gameserver crash (maybe it doesn't accept NULL values for datetime) what i did was insert user info if it's not there and avoid to remove the info if the ExpireDate (LeftTime) is < 0.
It was the only way that i found that not causes problems in game with "Your premium access..."
Try changing the query so that ExpireDate isn't NULL, just pass through a date value with a year of 9999 or something as a default. Maybe that could work for you.Quote:
Originally Posted by gustavobm
What client version are you guys using?
No omg, you can simple deal with the null value in code.Quote:
Originally Posted by fallenfate
I mean check when is null value.
If GS is crashing is not in MultiServer the problem, but at GS that received a null packet.
Beautiful wordsQuote:
Originally Posted by SmileYzn
I don't actually have the issue, I thought gustavo was saying your fix didn't work so I was just offering an alternative. Relax guys, ;).
I tested this too and not have crashes.Quote:
Originally Posted by fallenfate
Yeah no worries, I was just saying I misunderstood his post, so I tried to help with an alternate method, that's all.
Anyway, happy compiling to everyone, :D.
Thanks matte, I am checking whole MultiServer since you can run 2 DataServers at once.Quote:
Originally Posted by fallenfate
But is lacking some packets, someone can help?
any one already fix the ancient+JOH?
Friend, when this happens? You can describle it?Quote:
Originally Posted by clerigz
when you put JOH in any ancient items you will not see the harmony option in your ancient items and it will be successfully..Quote:
Originally Posted by SmileYzn