Rappelz Private Server Registration Script

rattexxl · 07/30/2011, 19:32

$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.

Makenci · 07/30/2011, 19:39

danke, ich versuche mal und guck mal

kommt immer wieder der gleiche Fehler..
was für Dienste müsste ich den freischalten ?

91ervans · 08/14/2011, 05:09

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

91ervans · 08/20/2011, 21:32

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

SingChan · 09/06/2011, 20:07

Fatal error: Call to undefined function mssql_connect() in C:\AppServ\www\REGI.php on line 9

help

Ginahund · 01/02/2012, 16:39

bin bereit 50€ für ein Regi script zu zahlen was geht

XoreYo · 01/06/2012, 19:13

"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. -.-'

Exterminator-[Fury] · 01/29/2012, 03:14

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

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

bauke9 · 04/03/2012, 21:13

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)

Xijezu · 04/03/2012, 22:05

Quote:

Originally Posted by bauke9

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

), 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 (

) - 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.

Modamer9 · 04/03/2012, 22:15

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.

Xijezu · 04/03/2012, 22:18

Quote:

Originally Posted by Modamer9

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.

Modamer9 · 04/03/2012, 23:18

Quote:

Originally Posted by Xijezu

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

haxti · 04/03/2012, 23:26

Quote:

Originally Posted by Modamer9

Also I heard it has some security vulnerabilities and need to reconfigure

Any Webserver have those...

→Striker← · 04/03/2012, 23:28

Quote:

Originally Posted by haxti

Any Webserver have those...

No, Not really..