Advertisement
Guest User

change pass

a guest
Jun 18th, 2018
698
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.30 KB | None | 0 0
  1. <?php
  2.  
  3. //include('config.php');
  4.  
  5. // MSSQL server connection details
  6. // Database server
  7. define('DB_ADDR','127.0.0.1');
  8. // Database login
  9. define('DB_USER','sa');
  10. // Database password
  11. define('DB_PASS','SQLAdmin1');
  12.  
  13. define('DB_ACC','ACCOUNT');
  14.  
  15. $link = mssql_connect(DB_ADDR, DB_USER, DB_PASS);
  16. if (!$link) die('Could not connect to MSSQL database.');
  17.  
  18. echo '<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" >';
  19. echo '<HTML><HEAD>';
  20. echo '<meta content="JavaScript" name="vs_defaultClientScript">';
  21. echo '<link title="style" href="layout.css" type="text/css" rel="stylesheet">';
  22. echo '<meta http-equiv="Content-Type" content="text/html; charset=US">';
  23. echo '<title>'.PAGE_TITLE.'</title></head>';
  24. echo '<body bgcolor="#000000;">';
  25.  
  26. echo '<div align="center">';
  27.  
  28. if (isset($_REQUEST['action'])) {
  29. switch($_REQUEST['action']) {
  30. case 'changepass':
  31. $msg='';
  32. $login=$_REQUEST['login'];
  33. $curpass=$_REQUEST['curpass'];
  34. $newpass=$_REQUEST['newpass'];
  35. $newpass2=$_REQUEST['newpass2'];
  36. if (!ctype_alnum($login)) $msg='<h3>Invalid login name.</h3>';
  37. if (!ctype_alnum($curpass)) $msg='<h3>Invalid current password.</h3>';
  38. if (!ctype_alnum($newpass)) $msg='<h3>Invalid new password.</h3>';
  39. if ($newpass <> $newpass2) $msg='<h3>The new password and confirmation do not match.</h3>';
  40. if ($msg=='') {
  41. $q="update ".DB_ACC.".dbo.cabal_auth_table set [Password]='".md5($newpass)."' where [ID]='".$login."' and [Password]='".md5($curpass)."'";
  42. $r=mssql_query($q);
  43. if (mssql_rows_affected($link)==1) {
  44. $msg='<h3>Password changed successfully</h3>';
  45. } else {
  46. $msg='<h3>Something went wrong. Check login and password</h3>';
  47. }
  48. }
  49. break;
  50. }
  51. echo $msg;
  52. echo '<p><a href="password.php">Click here to go back to the main page.</a></p>';
  53. } else {
  54. echo '<h3>Password changer</h3>';
  55. echo '<table width="554" cellspacing="0" cellpadding="4" style="border:#333333 1px solid" border="0">';
  56. echo '<tr style="background-color:#333333"><td width="28" colspan="2" align="center"><span class="orange"><strong>Enter your current login and password</strong></td></tr>';
  57. echo '<form method="post" action="password.php?action=changepass">';
  58. echo '<tr style="background-color:#555555"><td align="right">Login:&nbsp;</td><td><input type="text" name="login" class="editbox" /></td></tr>';
  59. echo '<tr style="background-color:#555555;"><td align="right">Current password:&nbsp;</td><td><input type="password" name="curpass" class="editbox" /></td></tr>';
  60. echo '<tr style="background-color:#333333"><td width="28" colspan="2" align="center"><span class="orange"><strong>Enter your new password and confirm it</strong></td></tr>';
  61. echo '<tr style="background-color:#555555"><td align="right">New password:&nbsp;</td><td><input type="password" name="newpass" class="editbox" /></td></tr>';
  62. echo '<tr style="background-color:#555555"><td align="right">Confirm:&nbsp;</td><td><input type="password" name="newpass2" class="editbox" /></td></tr>';
  63. echo '<tr style="background-color:#555555"><td align="center" colspan="2"><input type="submit" value="Change password" class="button" /></td></tr>';
  64. echo '</form>';
  65. echo '</table>';
  66. }
  67.  
  68. echo '</div></body></html>';
  69. exit;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement