Shakeynath

I have changed the int to bigint for crystals, money and bank money but the limit is still at $2147483647

All i want is my stats too be more than 2 bill

My user stats are decimals not int ?

Is there a way too higher this cap then ? Because i try all the other SQL'S on here but always get mysql error

Exactly mate, Its more enjoyful because you have more things too reach and that

People get bored because they reach the limit and start getting bored, Is there a way or not ?

This is what my database is like >>> `userid` int(11) NOT NULL default '0', `strength` decimal(65,4) NOT NULL default '0.0000', `agility` decimal(65,4) NOT NULL default '0.0000', `guard` decimal(65,4) NOT NULL default '0.0000', `labour` decimal(65,4) NOT NULL default '0.0000', `IQ` decimal(65,4) NOT NULL default '0.000000' ) ENGINE=MyISAM DEFAULT CHARSET=latin1;   `money` `money` int(11) NOT NULL DEFAULT '0', `crystals` `crystals` int(11) NOT NULL DEFAULT '0', `bankmoney` `bankmoney` int(11) NOT NULL DEFAULT '0',   And everything is maxed out at 2,147,483,647 How can i change this ?

Not sure if this post is meant too be here or not, I apologise if its not :) Im just wondering if there is any way of sending out a email too all of your users ?

Whats that for ?

Its not what a player is getting. Its just i try adding houses and if i type in a high amount in cash it will just automatically go to 2,147,483,647

The maximum number the stats and money reaches up too is 2,147,483,647. We need to increase this, So is there any chance someone could help me on how to do this ?

Error SQL query: ALTER TABLE `users` CHANGE `exp` `exp` DECIMAL( 99, 4 ) NOT NULL DEFAULT '0.0000' MySQL said: Documentation #1426 - Too big precision 99 specified for column 'exp'. Maximum is 65.

Should it be: $ir['exp_needed'] = intval(($ir['level']+1)*($ir['level']+1)*($ir['level']+1)*2.2); Or $ir['exp_needed'] =(intval) (($ir['level']+1)*($ir['level']+1)*($ir['level']+1)*2.2); ???

My exp field was on DECIMAL(11,4) Not INT :S:S:S

I dont have that in my global_func :S

I can change the exp to big int but cant find the user_level in global_func for me too change it there, Can someone help me please

Users reach 9999999.9999 exp then it stops ?

how would i higher that ??

Now ive had a comment from a player saying his exp is sticking at 97% and he cant level anymore. We thought it was just his account but then we tested it and it would level. Any ideas ?

Okay thanks jord :)

I logged into my game this morning and the error on the authenticate.php file   Warning: mysql_connect() [function.mysql-connect]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (11) in /home/solarba2/public_html/class/class_db_mysql.php on line 46 FATAL ERROR: Could not connect to database on localhost (Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (11))   I refreshed the page then it worked and come onto the loggedin.php, When i went too explore it popped up and so i refreshed and it worked. It comes up on everything from time to time but when i refresh it seems too load up "/ Any ideas ?

<?php include "config.php"; global $_CONFIG; if($_GET['code'] != $_CONFIG['code']) { die(""); } define("MONO_ON", 1); require "class/class_db_{$_CONFIG['driver']}.php"; $db=new database; $db->configure($_CONFIG['hostname'], $_CONFIG['username'], $_CONFIG['password'], $_CONFIG['database'], $_CONFIG['persistent']); $db->connect(); $c=$db->connection_id; $set=array(); $settq=$db->query("SELECT * FROM settings"); while($r=$db->fetch_row($settq)) { $set[$r['conf_name']]=$r['conf_value']; } //brave update $query="UPDATE users SET brave=brave+((maxbrave/10)+0.5) WHERE brave<maxbrave "; $query2="UPDATE users SET brave=maxbrave WHERE brave>maxbrave"; $query3="UPDATE users SET hp=hp+(maxhp/3) WHERE hp<maxhp"; $query4="UPDATE users SET hp=maxhp WHERE hp>maxhp"; $db->query($query); $db->query($query2); $db->query($query3); $db->query($query4); $db->query($query5); //enerwill update $query="UPDATE users SET energy=energy+(maxenergy/(12.5)) WHERE energy<maxenergy AND donatordays=0"; $query5="UPDATE users SET energy=energy+(maxenergy/(6)) WHERE energy<maxenergy AND donatordays>0"; $query2="UPDATE users SET energy=maxenergy WHERE energy>maxenergy"; $query3="UPDATE users SET will=will+10 WHERE will<maxwill"; $query4="UPDATE users SET will=maxwill WHERE will>maxwill"; $query5=$thug = "UPDATE `users` SET `power`=`power`+(max_power/(12.5)) WHERE `power`<`max_power`"; mysql_query($thug); $db->query($query); $db->query($query5); $db->query($query2); $db->query($query3); $db->query($query4); if($set['validate_period'] == 5 && $set['validate_on']) { $db->query("UPDATE users SET verified=0"); } if($set['validate_period'] == 15 && $set['validate_on'] && in_array(date('i'),array("00", "15", "30", "45"))) { $db->query("UPDATE users SET verified=0"); } ?>

QUERY ERROR: Query was empty Query was Im getting this error when i try the fivemins cron "/

  Okay ill check right away buddy :)

I have just had a message of a member of mine saying that he and all other members are not getting any will or EXP. Can someone help please ?