Register Page

[Z?v??]

";
$ip = ($_SERVER['HTTP_X_FORWARDED_FOR'])
? $_SERVER['HTTP_X_FORWARDED_FOR']
: $_SERVER['REMOTE_ADDR'];
if(file_exists('ipbans/'.$ip))
{
die("Your IP has been banned, there is no way around this.

[hamster01]

Re: Register Page

just look at this line:

$db->query("INSERT INTO users (username, login_name, name, last, age, aog, msn, aim, aol, yahoo, 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}', '{$name}', '{$last}', '{$age}', '{$aog}', '{$msn}', '{$aim}', '{$aol}', '{$yahoo}', md5('{$_POST['password']}'), 1, $sm, 0, 0, 1, 12, 12, 100, 100, 5, 5, 100, 100, 1, '{$_POST['gender']}', unix_timestamp(), '{$_POST['email']}', -1, '$IP', '$IP')");

[CraigF]

Re: Register Page

DeathStar reply to my PM's

[hamster01]

Re: Register Page

got none.. Answer me on msn

[CraigF]

Re: Register Page

22:41:27 [email protected] says:

HI

 

that was the last msg i seen from you, should we talk in your game? i cant talk on msn it doesnt show me msgs

[Z?v??]

Re: Register Page

Whats wrong with that line? It all looks good to me. :|

[hamster01]

Re: Register Page

well ,username, login_name, name, last, age, aog, msn, aim, aol, yahoo, userpass

thats incorect

[Z?v??]

Re: Register Page

Show me the complete code with your changes in it. Cause I don't understand whats wrong in that.

[hamster01]

Re: Register Page

username, login_name, name, userpass thats the order

dont know hwo you put it

[Z?v??]

Re: Register Page

What are you talkin about? lol

[hamster01]

Re: Register Page

nevermind im hard explaining

[Decepti0n]

Re: Register Page

You don't need it in the correct order

And I couldn't find much wrong with it at first, it seems to match up, could always add a notice in game if they haven't picked one, to go get one

[hamster01]

Re: Register Page

Decrypti0n i though it was:

$db->query("INSERT INTO users (username, login_name, name, last, age, aog, msn, aim, aol, yahoo, 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}', '{$name}',  md5('{$_POST['password']}'), 1, $sm, 0, 0, 1, 12, 12, 100, 100, 5, 5, 100, 100, 1, '{$_POST['gender']}', unix_timestamp(), '{$_POST['email']}', -1, '$IP', '$IP', '{$last}', '{$age}', '{$aog}', '{$msn}', '{$aim}', '{$aol}', '{$yahoo}')");[code]

now i only see its:
$db->query("INSERT INTO users (username, login_name, name, last, age, aog, msn, aim, aol, yahoo, 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}', '{$name}', '{$last}', '{$age}', '{$aog}', '{$msn}', '{$aim}', '{$aol}', '{$yahoo}', md5('{$_POST['password']}'), 1, $sm, 0, 0, 1, 12, 12, 100, 100, 5, 5, 100, 100, 1, '{$_POST['gender']}', unix_timestamp(), '{$_POST['email']}', -1, '$IP', '$IP')");

 

I'll have a look at that script. ;)[/code]

[Z?v??]

Re: Register Page

Ok, thanks deathstar. :-)

[vinyl]

Re: Register Page

if I am failing to understand the posts, forgive me....

the order is strict if the columns are NOT named, if they are then the values will be INSERTED in the order scripted by the column list

value1->column1 of "INSERT into (column1, etc...) VALUES(value1, etc...

also users.gender is type 'Enum' and as such can only be 'Male' or 'Female' and is case-sensitive I believe.

(somebody correct me here if I'm wrong)

if none of this relates to the problem, or I'm looking at something covered/checked/known already....sorry.

[hamster01]

Re: Register Page

I dont think it scase sensitive.

I would just keep on searching.. normally an weird error

Try this at end of querys:

or die("Error aoorured at $query");