Rappelz Private Server Registration Script

Strean · 05/20/2011, 22:06

Hey all .

I was wondering that i didnt see any register script for the private server...

so here is my script written in php :

PHP Code:


			
<?php



    $host = "(local)\\RappelzSQL"; // your sql instance

    $user = "sa"; // username

    $pw = ""; // password

    $db = "Auth"; // db

    $md5_key = "2011"; // your md5 key

    

    $connect = mssql_connect($host,$user,$pw)

    or die("Can't connect to the datebase.");

    

    mssql_select_db($db,$connect)

    or die("Can't select the datebase");



?>



<html>

  <head>

    <title>Register</title>

    <center>

    <h3 style="color:red">Rappelz : Register Page ( Pls insert more then 4 chars ! )</h3> 

    <form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="POST">

      Username : <input type="text" size="20" name="username" /><br />

      Password : <input type="password" size="20" name="password" /><br /><br />

      <input type="submit" value="Register now !" name="senden" />

    </form>

    <?php

    

      $usr = $_POST['username'];

      $pass = $_POST['password'];

      $endPw = $md5_key . $pass;

      $md5 = md5($endPw);

      

      $results = mssql_query("SELECT * FROM dbo.Accounts WHERE '$usr' LIKE login_name");

      $res = mssql_num_rows($results);

      

      if(strlen($usr) > 4 && strlen($pass) > 4)

      {

          if($res > 0)

          {

              echo "Account Exists !";

          }

          else

          {

              mssql_query("INSERT INTO dbo.Accounts(login_name,password,block,withdraw_remain_time,age,auth_ok,pcbang,last_login_server_idx,event_code,result) VALUES('$usr','$md5',0,0,18,1,1,1,0,1)");

              echo "Registration Success !";

          }

      }

      else

      {

          echo "Username or Password to small...";

      }

    

    ?>

    </center>

  </head>

</html>

if you want to start it with XAMPP you have to edit following things :

go in your XAMPP/php folder and open the "php.ini" file

edit following things :

;extension=php_mssql.dll ( remove the ";" before the extension )

its look like so :

extension=php_mssql.dll

and you have to edit this :

;extension=php_pdo_mssql.dll ( the same.. just remove the ";" )

Done.

Regards. Strean

Strean · 05/20/2011, 22:10

Quote:

Originally Posted by RoflcopterGoesSoiSoiSoi

sorry, but lol at your ******* "engrish". you shouldn't work in web development of any kind if you can't use proper english.

oh guy thats the reason why we have some leecher in this forum...

Why you didn't make an useful post ?

and yes im web developer.... but in germany.

I know that my english isn't the best but i just want to help other peolpe.

Muumiarmor · 05/20/2011, 23:48

Quote:

Originally Posted by RoflcopterGoesSoiSoiSoi

sorry, but lol at your ******* "engrish". you shouldn't work in web development of any kind if you can't use proper english.

If your going on about proper English then you should take a look at your own.

Sentence's start with a capital letter.

Don't forget you are on a German forum.

harmbasi · 05/20/2011, 23:59

@RoflcopterGoesSoiSoiSoi

Fail, making fun of someone else when you are worse than they are. You are so smart my friend.

Strean · 05/21/2011, 00:00

Quote:

Originally Posted by Muumiarmor

If your going on about proper English then you should take a look at your own.

Sentence's start with a capital letter.

Don't forget you are on a German forum.

Thanks, but many people don't understand that english peoples are guests in this forum..

But now its ok we dont want to spam this thread right ; )

manlive · 05/21/2011, 02:37

Quote:

Originally Posted by RoflcopterGoesSoiSoiSoi

sorry, but lol at your ******* "engrish". you shouldn't work in web development of any kind if you can't use proper english.

F@ke just go to do something u just blalalala talking and don't do anything

just shat up ...

thx man for this Script ...

RoflcopterGoesSoiSoiSoi · 05/21/2011, 11:47

You haven't seen any of the dev work I've done. ^o) I've posted screens, just not released my stuff for fear of "Y IT NO WORK RITE??".

~~cranK337~~ · 05/21/2011, 20:22

Fatal error: Call to undefined function mssql_connect() in /users/maskulin/www/index.php on line 9

doesnt work...

Strean · 05/22/2011, 00:28

you have to edit your php.ini .....

read my little guide under the script

~~cranK337~~ · 05/22/2011, 01:32

Oh, okay, I'll try it. Thanks.

killer1808 · 05/22/2011, 09:36

Strean please help,where i can find XAMPP/php folder?

read101 · 05/26/2011, 16:44

crank did you fix your problem, i get the same, Call to undefined function mssql_connect() in test.php on line 9
and i followed every thing, my php folder doesn't have php_mssql.dll so i downloaded that and the others needed, i get nothing but errors about unable to load dynamic dll and you don't have it installed on your computer.
any one can help me, or point me in the dereliction of new servers to use.

read101 · 05/27/2011, 01:52

i now have all the dlls installed and i get no errors when i start the web-server up but i still get error on line 9

read101 · 05/30/2011, 19:37

ok i got it working, but i used IIS7.

piratehat2 · 06/20/2011, 22:02

how do i use this to make a registration page?