<?php require('connect.php'); include('header.php'); $errorz = ' '; $allok = ' '; $err = 0; $errorz = 'Your nickname is too long(10 characters is max)<br/>'; $err = 1; } } else{ $errorz = $errorz.'You forgot to fill the nickname input<br/>'; $err = 1; } } else{ $errorz = $errorz.'You forgot to fill the Repeat(nickname) input<br/>'; $err = 1; } $errorz = $errorz.'Your password is too long<br/>'; $err = 1; } } else{ $errorz = $errorz.'You forgot to fill the password input<br/>'; $err = 1; } } else{ $errorz = $errorz.'You forgot to fill the Repeat(password) input<br/>'; $err = 1; } if($err=1){ goto omfg; } if($nick!==$nickr){ $errorz = $errorz.'Your nicknames doesnt match each other.<br/>'; $err = 1; } if($pass!==$passr){ $errorz = $errorz.'Your passwords doesnt match each other.<br/>'; $err = 1; } $errorz = $errorz.'Your nickname is too long<br/>'; $err = 1; } } else{ $errorz = $errorz.'Where is your IGN?!<br/>'; $err = 1; } if($err=1){ goto omfg; } if($err=0){ $nickname = mysqli_real_escape_string($dbc,$nick); $password = mysqli_real_escape_string($dbc,$pass); $ign = mysqli_real_escape_string($dbc,$ign); $qz = "SELECT name FROM users WHERE name='".$nickname."' LIMIT 1"; $ec = mysqli_num_rows($rz); if($ec = 1){ $errorz = $errorz.'Nickname already registered... you\'ve got bad luck<br/>'; $err = 1; } $qn = "SELECT IGN FROM users WHERE IGN='".$ign."'"; $en = mysqli_num_rows($rn); if($en !== 0){ $errorz = $errorz.'IGN already registered... you\'ve got bad luck<br/>'; $err = 1; } if($err=1){ goto omfg; } $q = "INSERT INTO users (name,password,IGN,registertime) Values ('$nickname','$password','$ign',NOW() )"; $r = mysqli_query($dbc, $q) or trigger_error ("Zapytanie $q\n<br/>Wywalilo blad : " .mysqli_error($dbc)); $to = 'avatars/'.$nick.'.png'; $from = 'avatars/default.png'; $errorz = $errorz."Couldnt create avatar for ya... wtf?"; } if(mysqli_affected_rows($dbc) == 1 ) { $allok = '<h3>Thank you for Registering at our site!Welcome in society '.$nickname.'</h3>'; } } } omfg: echo ' <form action="register.php" method="post"> Nickname (up to 20 characters) : <center><input type="text" name="nick" /></center> Repeat nickname : <center><input type="text" name="nickr" /></center> Password (up to 20 characters): <center><input type="password" name="pass" /></center> Repeat password: <center><input type="password" name="passr" /></center> In game name : <center><input type="text" name="ign" /></center><br/><br/> <center>By clicking submit I promise that im not gonna trollin here. <input type="submit" name="sm" value="Submit!" /><input type="reset" value="Reset!"/></center> </form>'; } else{ if($allok!=' '){ } if($errorz!==' '){ echo '<a href="register.php" style="text-decoration:underline">Back to registration form</a> or <a href="index.php" style="text-decoration:underline">Go to home.</a>'; } } include('footer.html'); ?>
a tabela mysql wyglada tak
Cytat
`id` int(5) NOT NULL AUTO_INCREMENT,
`name` varchar(20) NOT NULL,
`password` varchar(20) NOT NULL,
`IGN` varchar(20) NOT NULL DEFAULT '0',
`posts` int(7) NOT NULL DEFAULT '0',
`warns` int(7) NOT NULL,
`thanks` int(7) NOT NULL DEFAULT '0',
`level` varchar(15) NOT NULL DEFAULT 'member',
`title` varchar(25) NOT NULL,
`signature` varchar(65) DEFAULT '0',
`registertime` varchar(255) NOT NULL,
PRIMARY KEY (`id`,`name`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8
`name` varchar(20) NOT NULL,
`password` varchar(20) NOT NULL,
`IGN` varchar(20) NOT NULL DEFAULT '0',
`posts` int(7) NOT NULL DEFAULT '0',
`warns` int(7) NOT NULL,
`thanks` int(7) NOT NULL DEFAULT '0',
`level` varchar(15) NOT NULL DEFAULT 'member',
`title` varchar(25) NOT NULL,
`signature` varchar(65) DEFAULT '0',
`registertime` varchar(255) NOT NULL,
PRIMARY KEY (`id`,`name`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8
Problem tkwi w tym ze skrypt php nie wykonuje się po linii 72.. przynajmniej tak to dla mnie wygląda , jestem prawie pewien że gdzieś brakuje nawiasu albo czegoś takiego tylko nie mogę tego znaleźć.Z góry dziękuję za pomoc.