Something happened to my Game

[$$ ?????? $$]

Everytime someone joins they get 100 crystals and 1000 in each stat how can i change it so they get 10 in each stat and no crystals.

[KDawg08]

Re: Something happened to my Game

go to REGISTER.PHP and search for this

mysql_query("INSERT INTO userstats VALUES

after that change all the numbers to look like this

mysql_query("INSERT INTO userstats VALUES($i, 10, 10, 10, 10, 10)", $c);

that will set all the stats to 10 upon registration

[$$ ?????? $$]

Re: Something happened to my Game

cheers mate i fixed it :-) , also who every joins they get 100 crystals here is the code can you sort it out for me.

$db->query("INSERT INTO users (username, login_name, userpass, level, money, crystals, donatordays, user_level, energy, maxenergy, will, maxwill, brave, maxbrave, hp, maxhp, location, gender, signedup, email, bankmoney, lastip, lastip_signup) VALUES( '{$username}', '{$username}', md5('{$_POST['password']}'), 1, 0, 100, 0, 1, 12, 12, 100, 100, 5, 5, 100, 100, 1, '{$_POST['gender']}', unix_timestamp(), '{$_POST['email']}', -1, '$IP', '$IP')");

[erus]

Re: Something happened to my Game

change this

$db->query("INSERT INTO users (username, login_name, userpass, level, money, crystals, donatordays, user_level, energy, maxenergy, will, maxwill, brave, maxbrave, hp, maxhp, location, gender, signedup, email, bankmoney, lastip, lastip_signup) VALUES( '{$username}', '{$username}', md5('{$_POST['password']}'), 1, 0, 100, 0, 1, 12, 12, 100, 100, 5, 5, 100, 100, 1, '{$_POST['gender']}', unix_timestamp(), '{$_POST['email']}', -1, '$IP', '$IP')");

 

to this

$db->query("INSERT INTO users (username, login_name, userpass, level, money, crystals, donatordays, user_level, energy, maxenergy, will, maxwill, brave, maxbrave, hp, maxhp, location, gender, signedup, email, bankmoney, lastip, lastip_signup) VALUES( '{$username}', '{$username}', md5('{$_POST['password']}'), 1, 0, 0, 0, 1, 12, 12, 100, 100, 5, 5, 100, 100, 1, '{$_POST['gender']}', unix_timestamp(), '{$_POST['email']}', -1, '$IP', '$IP')");

the number equate to this

1 (level), 0 (money), 0 (crystals), 0(donatordays), 1(user_level), 12(energy), 12(maxenergy), 100(will), 100(maxwill), 5(brave), 5(maxbrave), 100(hp), 100(maxhp), 1(location),