[Fix] Inventory Penya Bug / Bank Penya Bug..

[xJohn08]

If Any Of Your Member(s) Have Ever Put More Than 2Bil In There Bank And Re-Log And Its In The Negative Or.. You Pick Up More Than 2Bil And Your Penya Is Reset To 0 Well.. This Will Fix It..

What It Dose :
If The "New Penya" Is More Than 2BIl Then It Sets "New Penya" To 2Bil

MySQL Trigger ( Inventory Fix )

Create Trigger `Anti-Bug` Before Update On `Characters` For Each Row 
Begin
If New.Penya > 2000000000 Then 
Set New.Penya = 2000000000;
End If;
End;

MySQL Trigger ( Bank Fix )

Create Trigger `Anti-Bug` Before Update On `Accounts` For Each Row 
Begin
If New.BankPenya1 > 2000000000 Then 
Set New.BankPenya1= 2000000000;
End If;
If New.BankPenya2 > 2000000000 Then 
Set New.BankPenya2 = 2000000000;
End If;
If New.BankPenya3 > 2000000000 Then 
Set New.BankPenya3= 2000000000;
End If;
End;

Hope This Helps Some People.. ^^

- John

[MentaL]

[Luxury]

Nice Release but the invintory Fix isnt working it just gives me a error...

[xJohn08]

its prob. cause they both have the same name.. so make 1 Anti-Bug and the other Anti-Bug 2...

[Luxury]

Create Trigger `Anti-Bug2` Before Update On `Characters` For Each Row
Begin
If New.Penya > 2000000000 Then
Set New.Penya = 2000000000;
End If;
End;

Nop

[Xc3sz]

Why dont just make it turn into perin,Easy....

[Luxury]

Why dont just make it turn into perin,Easy....

Yep thats the system im using atm

[xJohn08]

Why dont just make it turn into perin,Easy....

Well on our server perins get duped so we have wiped them from the public =3 But the Trigger works on my server.. =x

[BBim]

Nice idea...
Just two things:
- Doesnt the triggers lags the server?
- The problem of it is size of the packet(its int and not int64) or database?

[Xc3sz]

Well on our server perins get duped so we have wiped them from the public =3 But the Trigger works on my server.. =x

Ahhh i See..:P

[Scratch]

awww so whats i need do for get inventory bug fix??

[creed0116]

hmmn... you should delete the trigger of your autochange job at your character table... both works fine with me