Rappelz Private Server Registration Script

Page 4 of 5 « First 23 4 5
07/30/2011 19:32 rattexxl#46
$host = "127.0.0.1\\SQLExpress"; // your sql instance
kannst aber auch deine ip rein machen

bei line 9 fehler liegt es am Router da der port nicht weiter geleitet wird und somit keine verbindung zu deiner DB aufbauen kann.

Kann aber auch sein das 1 dienst bei dir nicht an ist.
07/30/2011 19:39 Makenci#47
danke, ich versuche mal und guck mal

kommt immer wieder der gleiche Fehler..
was für Dienste müsste ich den freischalten ?
08/14/2011 05:09 91ervans#48
Weis jemand wie ich das lösen kann ?

Quote:
Warning: mssql_select_db() [function.mssql-select-db]: message: The server principal "SERVER\IUSR_91ervans" is not able to access the database "Auth" under the current security context. (severity 14) in C:\inetpub\vhosts\pfad\register.php on line 12
MfG 91ervans
08/20/2011 21:32 91ervans#49
Weis den niemand eine lösung auf dei fehlermeldung ?

Also wo muss ich das einstellen das mein Webserver auf die Datenbank Auth zugreifen kann ?

MfG 91ervans
09/06/2011 20:07 SingChan#50
Fatal error: Call to undefined function mssql_connect() in C:\AppServ\www\REGI.php on line 9

help
01/02/2012 16:39 Ginahund#51
bin bereit 50€ für ein Regi script zu zahlen was geht
01/06/2012 19:13 XoreYo#52
"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"


Just read the first post. -.-'
01/29/2012 03:14 Exterminator-[Fury]#53
Can u help me making a register page?
i do only have to create a index.php file in xamp htdocs folder and put ur info in it right ?
do i have to change some stuff in the file?

Quote:
Originally Posted by Strean View Post
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
04/03/2012 21:13 bauke9#54
Ok.

I have NEVER used xampp, php, what-so-ever.
Could you make a step-by-step guide (except installation) on how to have the register page being able to be accessed through the internet. (I have no idea where to put this info ;D)
04/03/2012 22:05 Xijezu#55
Quote:
Originally Posted by bauke9 View Post
Ok.

I have NEVER used xampp, php, what-so-ever.
Could you make a step-by-step guide (except installation) on how to have the register page being able to be accessed through the internet. (I have no idea where to put this info ;D)
I rather would say use IIS instead of XAMPP.

But well, here a short overview (I hope you understand it like this):

IIS is a Windows-Hosttool, means it is already included. You have to activate it in your Control Panel -> Windows Programs.
When you activated it, you can find IIS (Internet Information Service) in your programs. When you start it, you see a Default Page (accessable through [Only registered and activated users can see links. Click Here To Register...]), you can edit it or delete it and add a new page, basically it doesn't make any difference.

After that you have to download and Install PHP ([Only registered and activated users can see links. Click Here To Register...]) - It will get activated automatically.
After that you just have to set up the Sql Server Driver for PHP (since the mssql_[...] isn't supported anymore) and that's it.

PM me if you have any questions. ;)
04/03/2012 22:15 Modamer9#56
Hi
You can use wampserver .

he very simple.
WampServer is a web development platform on Windows allowing you to create dynamic web applications with Apache2, PHP and MySQL.
04/03/2012 22:18 Xijezu#57
Quote:
Originally Posted by Modamer9 View Post
Hi
You can use wampserver .

he very simple.
WampServer is a web development platform on Windows allowing you to create dynamic web applications with Apache2, PHP and MySQL.
If you use wamp -> Don't cry when you have a lack of security.

If I remember right, wamp is a previous version from XAMPP, and those "server" are NOT for public hosting.
04/03/2012 23:18 Modamer9#58
Quote:
Originally Posted by Xijezu View Post
If you use wamp -> Don't cry when you have a lack of security.

If I remember right, wamp is a previous version from XAMPP, and those "server" are NOT for public hosting.
yes in first install is not secure . but you can make hem better when you use brain.exe and your update .

I am using wamp server since long time. It's light weight and very easy to configure and do upgrades. Also If you need perl, you can simply install perl into wamp server. I also used xampp couple of times, but simply I don't like it. Also I heard it has some security vulnerabilities and need to reconfigure
04/03/2012 23:26 haxti#59
Quote:
Originally Posted by Modamer9 View Post
Also I heard it has some security vulnerabilities and need to reconfigure
Any Webserver have those...
04/03/2012 23:28 →Striker←#60
Quote:
Originally Posted by haxti View Post
Any Webserver have those...
No, Not really..
Page 4 of 5 « First 23 4 5