Jameoo Posted May 6, 2008 Posted May 6, 2008 Hi Im Trying To Rais The Max On Stats i use bigint 249 i cant use decimal 249,2 coz it dnt work what is the biggest one you can choose from to get the highest amount EDITED with bigint 249 its only going to 9,223,372,036,854,775,808 Quote
Guest Anonymous Posted May 6, 2008 Posted May 6, 2008 Re: User Stats 9,223,372,036,854,775,807 is 2^63-1 ... See http://dev.mysql.com/doc/refman/5.1/en/ ... types.html Quoting from the manual ... The maximum number of digits for DECIMAL or NUMERIC is 65, but the actual range for a given DECIMAL or NUMERIC column can be constrained by the precision or scale for a given column So you will have find a different solution ... Try using a DOUBLE... Again (from the manual) A normal-size (double-precision) floating-point number. Allowable values are -1.7976931348623157E+308 to -2.2250738585072014E-308, 0, and 2.2250738585072014E-308 to 1.7976931348623157E+308. These are the theoretical limits, based on the IEEE standard. The actual range might be slightly smaller depending on your hardware or operating system. Quote
Miniman Posted May 6, 2008 Posted May 6, 2008 Re: User Stats Why are the stats so high? I've never seen a game with them that big......Not even that 2452 game lol. Quote
Jameoo Posted May 6, 2008 Author Posted May 6, 2008 Re: User Stats Hummm I Tryed Decimal 69 tha was max how do i make it more lol ?? the maximum on decimal 69 is.... 99,999,999,999,999,999,209,038,626,283,633,850,822,756,121,694,230,455,365,568,299,008 GROOVY AY Quote
Guest Anonymous Posted May 6, 2008 Posted May 6, 2008 Re: User Stats Hummm I Tryed Decimal 69 tha was max how do i make it more lol ?? As I said - use a DOUBLE The maximum (signed) is roughly ... 222,507,385,850,720,140,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000 But of course you will lose a lot of accuracy ... Quote
Joel Posted May 8, 2008 Posted May 8, 2008 Re: User Stats Lol what the hell, Why would you want your Game have large Stats, What you trying to do Blow up the SQL Database :evil: Quote
Jameoo Posted May 8, 2008 Author Posted May 8, 2008 Re: User Stats Thanks For Sayin That It Cheerd Me Up :-D Well my new game gonna be 100% easy so more ppl play it so yeh we need big numbers Quote
Joel Posted May 8, 2008 Posted May 8, 2008 Re: User Stats I wudnt make it easy, I've been to that point off tha stage When my game was easy, Everyone was complaining, Because its too Easy XD Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.