I'm having a big problem & need your help, I drop all my users to be able to start from userid=1 but it keeps shooting back up to id=236
I've dropped almost every table in phpMyadmin but it still keeps counting from 237 :mad: It has made me wanna cry so I'm asking for help now
if($_REQUEST['ref']) {
$q=$db->query("SELECT * FROM users WHERE userid={$_REQUEST['ref']}");
$r=$db->fetch_row($q);
}
$zone=mt_rand(1,4);
$db->query("INSERT INTO users (username, login_name, userpass, level, money, bankmoney, zone, gold, donatordays, adminlawl, energy, maxenergy, will, maxwill, brave, maxbrave, hp, maxhp, location, gender, signedup, email, lastip, lastip_signup, display_pic, layout) VALUES( '{$username}', '{$username}', md5('{$_POST['password']}'), 1, 200, 2000, $zone, 0, 3, 1, 100, 100, 5, 5, 5, 5, 20, 20, 1, '{$_POST['gender']}', unix_timestamp(), '{$_POST['email']}', '$IP', '$IP', 'images/noavatar.jpg', 4)");
$i=$db->insert_id();
$db->query("INSERT INTO userstats VALUES($i, 2, 2, 2, 2, 2)");
$db->query("INSERT INTO network_friends_top VALUES('', $i, 1, '', '', '', '', '', '', '')");
$db->query("INSERT INTO network_friends_approved VALUES('', $i, 1,UNIX_TIMESTAMP())");
$db->query("UPDATE users SET fightrank=$i WHERE userid=$i");
$pass = md5($_POST['password']);
if ($_REQUEST['ref'])