Jump to content

Breaking 2.147 Billion


StormTheGates

Recommended Posts

I run a game and one of the features is Russian Roulette. The problem Ive been having is that when a user wins they get 2x their money. However if that value exceeds the max of a 32bit integer, 2.147 billion or so they loose the extra money they should have won. How can I rectify this?

 

Thanks.

Link to comment
https://forums.phpfreaks.com/topic/99329-breaking-2147-billion/
Share on other sites

Should be able to do:

 

mysql_query("UPDATE users SET money=money+money WHERE username='$username'");
-or-
mysql_query("UPDATE users SET money=money*2 WHERE username='$username'");

 

:) MYSQL is probably better at it then php, because the value will never even be set in php's memory this way.

 

Best, Nathan

 

Link to comment
https://forums.phpfreaks.com/topic/99329-breaking-2147-billion/#findComment-508219
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.