انا طالب منكم Change Password PHP & Login Panel PHP With Config
و بكون اللوجن بانل مربوطه ب Change Password PHP اللي هيا بكتب فيها ال ID + PW و بعد ما اكتب ال ID و ال PW و ادوس لوجن يدخلني علي ال Change Password PHP Page
و لو حاد معاه reset statues points php يرفعهالي بل مره معلش و يا ريت يكون ال Restet Statues + Change Password مربوطين بل Login Panel و يكونو شغلين 100% معلش
//check that the user is logged if(!isset($_SESSION)){ session_start(); } if (isset($_SESSION['name'])) { $userID = $_SESSION['name']; } else { echo "<script>location.href='index.php'</script>"; die; }
//makesure that the the variable char is present if(!isset($_GET["char"])){ echo "<script>location.href='controlpanel.php'</script>"; die; }
/************************************* *convert a date in the format AAAA-MM-DD *into numbers of days passed from 2000-01-01 *************************************/ function date2int($end) {
$titulo="Reset your status points"; require_once("./modules/include/Config.php"); require_once("./modules/include/sqlConn.php"); require_once("./modules/include/Security.php");
mssql_select_db($dbName1, $dbConn) or die ("Couln't select database $dbName1");
//select the JID from this account $getUserJID = mssql_query("select * from TB_User where StrUserID = '".$_SESSION["name"]."'"); while ($row = mssql_fetch_array($getUserJID)) { $userJID = $row['JID']; //$userGM = $row['sec_content']; }
mssql_select_db($dbName2, $dbConn) or die ("Couln't select database $dbName2");
//check that the char belong to te logged account $getCharID = mssql_query("select * from _User where UserJID = '$userJID'"); $charnumeros=0; while ($row = mssql_fetch_array($getCharID)) { $charID2 = $row['CharID']; if($charID2==$_GET['char']){ $charnumeros++; } }
//select char informations needed to reset $getCharInfos = mssql_query("select * from _Char where CharID = ".$_GET['char']); while ($row2 = mssql_fetch_array($getCharInfos)) { $charName = $row2['CharName16']; $charLevel = $row2['CurLevel']; }
$erro=""; $reset = ($charLevel-1)+20; $remainStats = ($charLevel-1)*3; if($_GET["r"]=="true"){ //hoje it's the date from the present day $hoje=date2int(date("Y-m-d"));
//does this char already made a reset sometime? $jaDeu=mssql_num_rows(mssql_query("select * from _Char_Reset where char_id='".$_GET['char']."'")); if($jaDeu>0){ //this is not the first time so let's know when it was $quandoDeu=mssql_query("select * from _Char_Reset where char_id='".$_GET['char']."'"); while ($row = mssql_fetch_array($quandoDeu)) { $charLastReset = $row['last_reset']; } //how much days ago? (today - last reset) $passaram=$hoje-$charLastReset;
//if already 7 days passed update else you must wait if($passaram>6){ mssql_query("update _Char_Reset set last_reset='$hoje' where char_id='".$_GET['char']."'"); }else{ $erro="You must wait ".(7-$passaram)." days to reset $charName again"; } }else{ //insert that today this char made a reset mssql_query("insert into _Char_Reset (char_id,last_reset) values ('".$_GET['char']."','$hoje')"); }
if($erro==""){ //here we make the reset itself if no errors occur $conteudo="<br><br><br><p align='center'><font color='#2ed900'>$charName's Status Points were reseted.</font></p>"; mssql_query("update _Char set Strength=$reset, Intellect=$reset, RemainStatPoint=$remainStats where CharID = ".$_GET['char']); }else{ $conteudo="<br><br><br><br><br><p align='center'><font color='red'>$erro</font></p>"; } }else{ //here we have a confirmation if the player is sure he want to make the reset $conteudo="<br><br><br><p align='center'>Are you sure you want to reset $charName's Status Points?</p><p align='center'>Remember that you can only reset it again after 7 days</font>"; $conteudo=$conteudo."<br><br><p align='center'><a href=\"reset.php?char=".$_GET["char"]."&r=true\"><img src=\"styles/img/cp/reset.png\" alt=\"\" border=\"0\"></a></p>"; } include("theme.php");
واحد بس كل 7 ايام
___
PHP Code for Changing Password
كود PHP:
<?php session_start(); include 'dbconfig.php';
$username = $_POST['username']; $password = $_POST['password']; $newpassword = $_POST['newpassword']; $confirmnewpassword = $_POST['confirmnewpassword']; $result = mysql_query("SELECT password FROM user_info WHERE user_id='$username'"); if(!$result) { echo "The username you entered does not exist"; } else if($password!= mysql_result($result, 0)) { echo "You entered an incorrect password"; } if($newpassword=$confirmnewpassword) $sql=mysql_query("UPDATE user_info SET password='$newpassword' where
user_id='$username'"); if($sql) { echo "Congratulations You have successfully changed your password"; } else { echo "Passwords do not match"; } ?>