Regi Page

    • Werbung zur Unterstützung des Forums ( Bitte AddBlocker deaktivieren )

    • [FONT="Trebuchet MS"][COLOR="LemonChiffon"][SIZE="2"]CreateAccount Function

      Quellcode

      1. SET ANSI_NULLS ON
      2. GO
      3. SET QUOTED_IDENTIFIER ON
      4. GO
      5. CREATE PROCEDURE [dbo].[createaccount]
      6. @account VARCHAR(15),
      7. @password VARCHAR(32)
      9. AS
      11. SET NOCOUNT ON
      13. DECLARE @DateActivated AS CHAR(8)
      15. IF NOT EXISTS (SELECT account FROM ACCOUNT_TBL WHERE account = @account) BEGIN
      16. INSERT INTO ACCOUNT_TBL (account, [password], id_no2, isuse, member, realname)
      17. VALUES (@account, @password, @password, 'T', 'A', 'F')
      19. SET @DateActivated = CONVERT(CHAR(8), GETDATE()-1, 112 ) --Is the date today - 1
      20. --UPDATE ACCOUNT_TBL_DETAIL SET BlockTime = @DateYesterday WHERE account = @userid
      21. --INSERT INTO ACCOUNT_TBL_DETAIL (account, gamecode, tester, m_chLoginAuthority, regdate, BlockTime, EndTime, WebTime, isuse)
      22. -- VALUES (@account, 'A000', '2', 'F', GETDATE(), '20990101', '20990101', '20050101', 'O')
      24. INSERT INTO ACCOUNT_TBL_DETAIL (account, gamecode, tester, m_chLoginAuthority, regdate, BlockTime, EndTime, WebTime, isuse)
      25. VALUES (@account, 'A000', '2', 'F', GETDATE(), @DateActivated, '20990101', '20050101', 'O')
      27. END
      Alles anzeigen


      PHP-Quellcode

      1. <!-- Start Register -->
      3. <?php
      5. #############################
      6. ##Copyright (c) TheJacob#####
      7. ##All Rights Reserved########
      8. ##thejacobpollack@gmail.com##
      9. #############################
      11. #############################
      12. #############################
      14. ##Configuration##
      15. $mssql_server = ""; //MSSQL server name or IP
      16. $mssql_username = ""; //MSSQL username
      17. $mssql_password = ""; //MSSQL password
      18. $mssql_account_db = "ACCOUNT_DBF"; //MSSQL account database name
      19. $mssql_character_01_db = "CHARACTER_01_DBF"; //MSSQL character database name
      20. $mssql_account_table = "account_tbl"; //MSSQL account table name
      21. $mssql_username_column = "account"; //MSSQL username column in account table
      22. $mssql_password_column = "password"; //MSSQL password column in account table
      23. $hash = ""; //Hash code
      24. $random_text_text = "e=mc2"; //Random text they must enter to register
      26. #############################
      27. #############################
      29. ##MSSQL Connect Function##
      30. function mssql_connect_ini($mssql_server,$mssql_username,$mssql_password) {
      31. $mssql_connect = mssql_connect($mssql_server, $mssql_username, $mssql_password) or die ("<strong>Cannot connect to the MSSQL server.</strong>");
      32. if ((strlen($mssql_server) == 0) || (strlen($mssql_username) == 0) || (strlen($mssql_password) == 0)) {
      33. echo "<strong>The connection configuration settings are invalid. Please make sure you've entered them in correctly.</strong>";
      34. }
      35. }
      37. ##MSSQL Account Database Select Function##
      38. function mssql_account_ini($mssql_account_db) {
      39. $mssql_select_db = mssql_select_db($mssql_account_db) or die ("<strong>Cannot select the Account database.</strong>");
      40. if (strlen($mssql_account_db) == 0) {
      41. echo "<strong>The account database configuration setting is invalid. Please make sure you've entered it correctly.</strong>";
      42. }
      43. }
      45. #############################
      46. #############################
      48. ##MSSQL Core Functionality##
      49. mssql_connect_ini($mssql_server,$mssql_username,$mssql_password);
      50. mssql_account_ini($mssql_account_db);
      52. #############################
      53. #############################
      55. $pusername = @$_POST['username']; //Post wsername
      56. $ppassword = @$_POST['password']; //Post password
      57. $prpassword = @$_POST['rpassword']; //Post re-enter password
      58. $random_text = @$_POST['random_text']; //Random text
      60. if (isset($_POST['submit']) == true) {
      61. $username = preg_replace("/[^a-zA-Z0-9\-\_\!\$\#\@\^\&\*\(\)\^\+\ \.\?]/", "", $pusername);
      62. $password = preg_replace("/[^a-zA-Z0-9\-\_\!\$\#\@\^\&\*\(\)\^\+\ \.\?]/", "", $ppassword);
      64. if ((isset($_POST['submit']) == true) and (strlen($pusername) < 3) || (strlen($pusername) > 15)) {
      65. echo "Your username must be between 3 and 15 characters in length.";
      66. }
      68. else if ((isset($_POST['submit']) == true) and ((strlen($ppassword) < 3) || (strlen($ppassword) > 15) || (strlen($prpassword) < 3) || (strlen($prpassword) > 15))) {
      69. echo "The password must be between 3 and 15 characters in length.";
      70. }
      72. else if ((isset($_POST['submit']) == true) and ($ppassword != $prpassword)) {
      73. echo "The passwords must be the same.";
      74. }
      76. else if ((isset($_POST['submit']) == true) and (($pusername == $ppassword) || ($pusername == $prpassword))) {
      77. echo "The username and password cannot be the same.";
      78. }
      80. else if ((isset($_POST['submit']) == true) and ($random_text != $random_text_text)) {
      81. echo "The random text must be filled in correctly. Please take another look at the random text.";
      82. }
      84. else if (mssql_num_rows(mssql_query("SELECT * FROM $mssql_account_table WHERE $mssql_username_column = '$username'")) == '0') {
      85. $stmt = mssql_init('createaccount');
      86. mssql_bind($stmt, '@account', $username, SQLVARCHAR, false, false, 15);
      87. mssql_bind($stmt, '@password', md5($hash . $password), SQLVARCHAR, false, false, 36);
      88. mssql_execute($stmt) or die ("<strong>Error occurred while executing the statement.</strong>");
      89. mssql_free_statement($stmt);
      90. echo "You've been successfully registered as <strong>" . $username . "</strong>!";
      91. } else {
      92. echo "The username already exists.";
      93. }
      94. }
      96. ?>
      98. <br>
      99. <center>
      100. <form method ="post" action="#">
      101. <table>
      103. <tr>
      104. <td><strong>Username</strong></td>
      105. </tr>
      106. <tr>
      107. <td><input name="username" type="username"></td>
      108. </tr>
      109. <tr>
      110. <td><strong>Password</strong></td>
      111. </tr>
      112. <tr>
      113. <td><input name="password" type="password"></td>
      114. </tr>
      115. <tr>
      116. <td><strong>Re-enter Password</strong></td>
      117. </tr>
      118. <tr>
      119. <td><input name="rpassword" type="password"></td>
      120. </tr>
      121. <tr>
      122. <td><strong>Please enter "<?php echo $random_text_text ?>" without the brackets below</strong></td>
      123. </tr>
      124. <tr>
      125. <td><input name="random_text" type="text"></td>
      126. </tr>
      127. <tr>
      128. <td><input name="submit" type="submit" value="Register"></td>
      129. </tr>
      131. </table>
      132. </form>
      133. </center>
      135. <!-- End Regiser -->
      Alles anzeigen


      (C) TheJacob[/SIZE][/COLOR][/FONT]