(fix)deleted char on crash [patch]

[higi]

this is for thoose have problems with random deleted chars after mangosd crash, it happend sometimes during char save

this is maybe slower idea REPLACE instead DELETE+INSERT dont know, but chars will not be deleted..

http://paste2.org/p/420585

original patch writed by Triply

this is not for mangos GIT branch

[crashuncle]

I think not all SQL servers support "REPLACE" and its slower, but the idea itself is good. There shouldn't be a break between the deletion and the insert at all.

[False.Genesis]

afaik postgreSQL doesnt support REPLACE INTO...

that chars get lost during crash rather looks like your START TRANSCATION .. sql .... sql ... *crash* doesnt auto-rollback the changes although its supposed to.

[higi]

afaik postgreSQL doesnt support REPLACE INTO...

that chars get lost during crash rather looks like your START TRANSCATION .. sql .... sql ... *crash* doesnt auto-rollback the changes although its supposed to.

ye its maybe cause :

BINARY UPDATE LOG

The binary update log is NOT enabled.

You will not be able to do point in time recovery

See http://dev.mysql.com/doc/refman/5.0/en/point-in-time-recovery.html

we have off all logs to reduce lag