[Vince]

You can do math in MySQL and I honestly prefer saving data intermittently, rather than sending one huge query on disconnect. If the server unexpectedly crashes then all the currently connected players will lose all their stats for that session, whereas with intermittent saves they will only lose a few stats or none at all.

PHP код:

UPDATE character SET cigars = cigars + 1 WHERE charid = ...