Opretter inge bruger - Får inden fejl :s
Hej Eksperten (:Jeg har http://www.CoolBoom.dk/index.php?side=register
Når folk skal oprette en bruger
skal de udfylde følgende felter
markerer med **
Når alt er udfyldt og brugeren
vil trykke på knappen "Opret Bruger"
Burde den paste daterne i Databasen
"members" ( Mine tabeller kan ses under min kode)
Istedet for skriver den bare "Din bruger er oprettet"
men egentlig så er den ikke paster i databasen :s
min kode ser således ud
___________________________________________
<? include "connect.php"; ?><head>
<SCRIPT LANGUAGE="JavaScript">
function popUp() {
props=window.open('hemmeligord.php', 'poppage', 'toolbars=0, scrollbars=0, location=0, statusbars=0, menubars=0, resizable=0, width=400, height=300, left = 520, top = 300');
}
// End -->
</script>
</head>
<?
//top("Register Dig");
?>
<div id="content_top">
<h1>Opret Bruger</h1>
</div>
<div id="content_middle">
<?
include("connect.php");
if(isset($_POST['submit'])){
$username = strip_tags($_POST[username]);
$username_len = strlen($username);
$fodt_d = strip_tags($_POST[fodt_d]);
$fodt_d_len = strlen($fodt_m);
$fodt_m = strip_tags($_POST[fodt_m]);
$fodt_m_len = strlen($fodt_m);
$fodt_aa = strip_tags($_POST[fodt_aa]);
$fodt_aa_len = strlen($fodt_aa);
$sex = strip_tags($_POST[sex]);
$sex_len = strlen($sex);
$nyhedsbrev = strip_tags($_POST[nyhedsbrev]);
$nyhedsbrev_len = strlen($nyhedsbrev);
$privat_kode = strip_tags($_POST[privat_kode]);
$privat_kode_len = strlen($privat_kode);
$hab_name = strip_tags($_POST[hab_name]);
$hab_name_len = strlen($hab_name);
$password = strip_tags($_POST[password]);
$password_len = strlen($password);
$pass_repeat = strip_tags($_POST[pass_repeat]);
$ecrypted_pass = ($password);
$email = $_POST[email];
$email_len = strlen($email);
$email_repeat = $_POST[email_repeat];
$name = $_POST['name'];
$created = date("d/m-Y H:i:s",time());
$ip = $_SERVER['REMOTE_ADDR'];
$profiletext = "Denne bruger er for doven til at rediger sin profiltekst!! (:";
$deaktiveret = "aktiveret";
if($password != $pass_repeat){
echo "Dine password er <i>ikke</i> ens!";
//header("location:createuser");
//footer();
exit;
}else{
if($username_len >= "3"){
if(ereg("^[a-zA-Z0-9 _-]{3,16}$", $username)){
$check = mysql_query("SELECT * FROM members WHERE user = '$username'")or die(mysql_error());
$count = mysql_num_rows($check);
if($count >= "1"){
echo "<div class=\"register_rules\"><font color=\"red\">Brugernavnet er allerede i brug!<br />Vælg venligst et andet.</font></div>";
} else {
if(ereg("^[a-zA-Z0-9 .:_-]{3,16}$", $hab_name)){
$e_check = "/^[-+\\.0-9=a-z_]+@([-0-9a-z]+\\.)+([0-9a-z]){2,4}$/i";
if(preg_match($e_check, $email)){
if($email != $email_repeat){
echo "<div class=\"register_rules\"><font color=\"red\">Dine emails passer ikke sammen!</font></div>";
}else{
$query = mysql_query("INSERT INTO members (user, fodt_d, fodt_m, fodt_aa, sex, nyhedsbrev, privat_kode, pass, email, name, hab_name, pro_text, created, ip) VALUES ('$username', '$fodt_d', '$fodt_m', '$fodt_aa', '$sex', '$nyhedsbrev', '$privat_kode', '$ecrypted_pass', '$email', '$name', '$hab_name', '$profiletext', '$created', '$ip')");
$query = mysql_query("INSERT INTO deaktiveret (user, deaktiveret) VALUES ('$username', '$deaktiveret')");
echo "Din bruger er oprettet og er nu klar til brug!";
echo "<meta http-equiv='refresh' content='3;url=http://www.coolboom.dk/index.php?side=register' />";
echo "</div>";
//footer();
exit;
}
}else {
echo "<div class=\"register_rules\"><font color=\"red\">Din email indholder ulovligt tegn!</font></div>";
}
} else {
echo "<div class=\"register_rules\"><font color=\"red\">Dit habbo navn indholder ulovlige tegn!</font></div>";
}
}
}else{
echo "<div class=\"register_rules\"><font color=\"red\">Dit brugernavn indholder ulovlige tegn!</font></div>";
}
}else{
echo "<div class=\"register_rules\"><font color=\"red\">Dit kodeord skal mindst være 3 cifte langt!</font></div>";
}
}
}
?> <font color="red"><i><u>Bruger oprettelsen er ude af drift! - Beklager!</u></i></font><br /><br />
<form action="" method="post">
<font color="red">
Felter med ** Skal udfyldes!!<br /><br>
</font>
<lable class="inputlable">Brugernavn: <font color="red">**</font></lable><br />
<input type="text" name="username" class="input" style="width: 150px;" maxlength="20" /><br /><br />
<lable class="inputlable">Habbo Navn: <font color="red">**</font></lable><br />
<input type="text" name="hab_name" class="input" style="width: 150px;" maxlength="15" /><br /><br />
<lable class="inputlable">hemmeligt ord: <a href="java script:popUp()">Læs mere her!</a></lable><br />
<input type="text" name="privat_kode" class="input" style="width: 150px;" value="( Valgfrit )" /><br /><br />
<lable class="inputlable">Kodeord: <font color="red">**</font></lable><br />
<input type="password" name="password" class="input" style="width: 150px;" /><br /><br />
<lable class="inputlable">Gentag Kodeord: <font color="red">**</font></lable><br />
<input type="password" name="pass_repeat" class="input" style="width: 150px;" /><br /><br />
<lable class="inputlable">Navn: <font color="red">**</font></lable><br />
<input type="text" name="name" class="input" style="width: 150px;" /><br /><br />
<lable class="inputlable">Email: <font color="red">**</font></lable><br />
<input type="text" name="email" class="input" style="width: 150px;" /><br /><br />
<lable class="inputlable">Gentag Email: <font color="red">**</font></lable><br />
<input type="text" name="email_repeat" class="input" style="width: 150px;" /><br /><br />
<lable class="inputlable">Køn: <font color="red">**</font></lable><br />
Mand: <input type="checkbox" value="Mand" name="sex"><br />
Kvinde: <input type="checkbox" value="Kvinde" name="sex"/><br /><br />
<lable class="inputlable">Fødselsdato: ( Fx. 06-11-1996 ) <font color="red">**</font></lable><br />
<select name="fodt_d"> <!-- D Står for DAG -->
<option value="01">01</option>
<option value="02">02</option>
<option value="03">03</option>
<option value="04">04</option>
<option value="05">05</option>
<option value="06">06</option>
<option value="07">07</option>
<option value="08">08</option>
<option value="09">09</option>
<option value="10">10</option>
<option value="11">11</option>
<option value="12">12</option>
<option value="13">13</option>
<option value="14">14</option>
<option value="15">15</option>
<option value="16">16</option>
<option value="17">17</option>
<option value="18">18</option>
<option value="19">19</option>
<option value="20">20</option>
<option value="21">21</option>
<option value="22">22</option>
<option value="23">23</option>
<option value="24">24</option>
<option value="25">25</option>
<option value="26">26</option>
<option value="27">27</option>
<option value="28">28</option>
<option value="29">29</option>
<option value="30">30</option>
<option value="31">31</option>
</select>
<select name="fodt_m"> <!-- M Står for Månede -->
<option value="Januar">Januar</option>
<option value="Febuar">Febuar</option>
<option value="Marts">Marts</option>
<option value="April">April</option>
<option value="Maj">Maj</option>
<option value="Juni">Juni</option>
<option value="Juli">Juli</option>
<option value="August">August</option>
<option value="September">September</option>
<option value="Oktober">Oktober</option>
<option value="November">November</option>
<option value="December">December</option>
</select>
<select name="fodt_aa"> <!-- AA Står for Å Og er ligmed År -->
<option value="1940">1940</option>
<option value="1941">1941</option>
<option value="1942">1942</option>
<option value="1943">1943</option>
<option value="1944">1944</option>
<option value="1945">1945</option>
<option value="1946">1946</option>
<option value="1947">1947</option>
<option value="1948">1948</option>
<option value="1949">1949</option>
<option value="1950">1950</option>
<option value="1951">1951</option>
<option value="1952">1952</option>
<option value="1953">1953</option>
<option value="1954">1954</option>
<option value="1955">1955</option>
<option value="1956">1956</option>
<option value="1957">1957</option>
<option value="1958">1958</option>
<option value="1959">1959</option>
<option value="1960">1960</option>
<option value="1961">1961</option>
<option value="1962">1962</option>
<option value="1963">1963</option>
<option value="1964">1964</option>
<option value="1965">1965</option>
<option value="1966">1966</option>
<option value="1967">1967</option>
<option value="1968">1968</option>
<option value="1969">1969</option>
<option value="1970">1970</option>
<option value="1971">1971</option>
<option value="1972">1972</option>
<option value="1973">1973</option>
<option value="1974">1974</option>
<option value="1975">1975</option>
<option value="1976">1976</option>
<option value="1977">1977</option>
<option value="1978">1978</option>
<option value="1979">1979</option>
<option value="1980">1980</option>
<option value="1981">1981</option>
<option value="1982">1982</option>
<option value="1983">1983</option>
<option value="1984">1984</option>
<option value="1985">1985</option>
<option value="1986">1986</option>
<option value="1987">1987</option>
<option value="1988">1988</option>
<option value="1989">1989</option>
<option value="1990">1990</option>
<option value="1991">1991</option>
<option value="1992">1992</option>
<option value="1993">1993</option>
<option value="1994">1994</option>
<option value="1995">1995</option>
<option value="1996">1996</option>
<option value="1997">1997</option>
<option value="1998">1998</option>
<option value="1999">1999</option>
<option value="2000">2000</option>
<option value="2001">2001</option>
<option value="2002">2002</option>
<option value="2003" disabled="disabled">2003</option>
<option value="2004" disabled="disabled">2004</option>
<option value="2005" disabled="disabled">2005</option>
<option value="2006" disabled="disabled">2006</option>
<option value="2007" disabled="disabled">2007</option>
<option value="2008" disabled="disabled">2008</option>
<option value="2009" disabled="disabled">2009</option>
<option value="2010" disabled="disabled">2010</option>
</select><br /><br />
Nyhedsbrev? ( Sendes hver 1. dag i måneden )<input name="nyhedsbrev" type="checkbox" value="1" checked /><br /><br />
<input type="submit" name="submit" class="register_btn" value="Opret Bruger" /> -
Brugeroprettelse er ikke åben!!
</form>
__________________________________________
Min Mysql Tabel ( members )
__________________________________________
`id` int(11) NOT NULL auto_increment,
`user` varchar(255) NOT NULL,
`fodt_d` varchar(255) NOT NULL,
`fodt_m` varchar(255) NOT NULL,
`fodt_aa` varchar(255) NOT NULL,
`privat_kode` varchar(255) NOT NULL,
`pass` varchar(255) NOT NULL,
`status` varchar(255) NOT NULL default 'Bruger',
`chef` varchar(255) NOT NULL default '0',
`email` varchar(255) NOT NULL,
`name` varchar(255) NOT NULL,
`nyhedsbrev` varchar(255) NOT NULL,
`sex` varchar(255) NOT NULL,
`hab_name` varchar(255) NOT NULL,
`presence` varchar(255) NOT NULL,
`today_msg` varchar(255) NOT NULL default 'Ændre status',
`pro_text` text NOT NULL,
`online` varchar(255) NOT NULL default 'Offline',
`lastonline` varchar(255) NOT NULL default 'aldrig været online',
`stilling` varchar(255) NOT NULL default 'Álm. Bruger',
`tagwall` varchar(255) NOT NULL default '1',
`tag_w_ban` text NOT NULL,
`tag_ban_dato` varchar(255) NOT NULL,
`debat` varchar(255) NOT NULL default '1',
`time` varchar(255) NOT NULL,
`created` varchar(255) NOT NULL,
`admin_id` varchar(255) NOT NULL default '1',
`ban_aarsag` text NOT NULL,
`ip` varchar(255) NOT NULL,
`ansogt_sendt` varchar(255) NOT NULL default '0',
`habbo tjek` varchar(255) NOT NULL default 'nej',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=40 ;
______________________________________
håber der er en som kan se fejlen (:
På forhånd tak for hjælpen
&& forsæt god torsdag (:
// Mikkel Bering
