Hallo liebe User.
Da ich nun auf MySql umsteige brauche ich kurz noch hilfe.
Meine Passwörter werden als 'Key' gespeichert doch im Ucp werden sie nur von 'password' geladen.
Jetzt bräuchte ich jemanden der mir die Md5 Abfrage entfernt und macht das es aus der Zeile 'Key' das Passwort ließt.
Die Pw's sind Klartext.
Mfg
PHP
<?phpinclude('./inc/config.php');include('./inc/functions.php');include('./lang/'.$language.'.lng');$page = addslashes($_REQUEST["page"]);$user = addslashes($_REQUEST["username"]);$pass = addslashes($_REQUEST["password"]);$language = strtolower($language);if(empty($page)) $page="home";$file = $page;if(!empty($user) AND !empty($pass)){$query = mysql_query('SELECT * FROM accounts WHERE name="'.$user.'" AND passwort="'.md5($pass).'"');if(mysql_num_rows($query) == 1){$_SESSION["user"] = $user;echo'<meta http-equiv="refresh" content="0; url=index.php?page=pverwaltung">';$ip = getenv ("REMOTE_ADDR");$timestamp = time();$ipupdate = mysql_query('INSERT INTO cplogin_log SET user="'.$user.'",ip ="'.$ip.'",date="'.date("d.m.Y",$timestamp).'"');}else $error = '<center>Username oder Passwort ist falsch.</center>';}$query2 = mysql_query('SELECT * FROM accounts WHERE name="'.$_SESSION["user"].'"');while($userinfos = mysql_fetch_array($query2)){$passwort = $userinfos["password"];$adminrang = $userinfos["admin"];$bankgeld = $userinfos["bank"];$eingeloggt = $userinfos["eingeloggt"];$premium = $userinfos["premium"];$level = $userinfos["level"];$ffrak = $userinfos["team"];$frank = $userinfos["rang"];$pcoins = $userinfos["coins"];}// ---- Online Check ----$online3 = "SELECT * from accounts WHERE eingeloggt = '1' AND name='".$_SESSION["user"]."'"; $online2 = mysql_query($online3); $online = mysql_num_rows($online2); // ---- Ende ----include('./designe/'.$designe.'/head.php');include('./designe/'.$designe.'/navi.php');include('./designe/'.$designe.'/middle.tpl'); if(file_exists('./pages/'.$file.'.php')) { include('./pages/'.$file.'.php');} if(!empty($error)) echo '<font color="red">'.$error.'</font>'; include('./designe/'.$designe.'/foot.tpl'); ?>
PHP
<?phpif(empty($_SESSION["user"])){?><center><form action="index.php?page=login" method="post"><table id="login"> <tr><td><?php // echo $logi1lng; ?> <input type="text" name="username" value="Username" onFocus="if(this.value=='Username') this.value=''" onBlur="if(this.value==''){this.value='Username'}" autocomplete="off" maxlength="16" style="width: 150px" /></td></tr> <tr><td><?php //echo $logi2lng; ?> <input type="password" name="password" value="Password" onFocus="if(this.value=='Password') this.value=''" onBlur="if(this.value==''){this.value='Password'}" autocomplete="off" maxlength="20" style="width: 150px" /></td></tr> <tr><td><input type="submit" value="<?php echo "Login"; ?>" style="width: 150px"></td></tr></table></form></center><?php}else{echo'';}?>
PHP
<?php// ---- Online Player ----$anzahl = "SELECT * from accounts WHERE eingeloggt = '1'"; $anzahl2 = mysql_query($anzahl); $onlineplayer = mysql_num_rows($anzahl2); // ---- Ende ----$query = mysql_query('SELECT * FROM accounts WHERE name="'.$_SESSION["user"].'"');if(mysql_num_rows($query) == 1){while($userinfos = mysql_fetch_array($query)){$level = $userinfos["level"];$fraktion = GetFrak($userinfos["team"]);$rang = GetRang($userinfos["team"],$userinfos["rang"]);}}if($fraktion == "Zivilist"){$finfos = 'Fraktion: '.$fraktion;}else{$finfos = 'Fraktion: '.$fraktion.' | Rang: '.$rang;}?><?phpif(empty($_SESSION["user"])){?><div style="padding-left:25px; padding-top:5px;"><form action="index.php?page=login" method="post"> <input type="text" name="username" value="Username" onFocus="if(this.value=='Username') this.value=''" onBlur="if(this.value==''){this.value='Username'}" autocomplete="off" maxlength="30" style="width: 150px" /> <input type="password" name="password" value="Password" onFocus="if(this.value=='Password') this.value=''" onBlur="if(this.value==''){this.value='Password'}" autocomplete="off" maxlength="30" style="width: 150px" /> <input type="submit" value="<?php echo "Login"; ?>" style="width: 150px"> <font style="padding-left:350px; font-size:14px; color:white;">Spieler Online: <?php echo $onlineplayer; ?></font></form></div><?php}else{if($adminrang == 0){$admin="";}else{$admin=" | Admin Rang: ".GetARang($adminrang);}$pnsum = mysql_num_rows(mysql_query('SELECT * FROM private_messages WHERE to_user_name ="'.$_SESSION["user"].'" AND is_read="0"'));if($pnsum==0){$pnsum="";}else{$pnsum="(".$pnsum.")";}echo'<div style="padding-left:25px; padding-top:9px; font-size:13px; color:white;">';echo 'Hallo '.$_SESSION["user"].' | Level: '.$level.' | '.$finfos.' | <a href="index.php?page=private_message" style="color:white;">Nachrichten'.$pnsum.'</a>'.$admin;echo'</div>';}?>