Making your server live with an account creation page

**gimmeurlife** · 05-31-2009

Ok first off i'm having the same problem as some others are. My server is Arcemu/Ascent. I can get people to connect to my server just fine.. but when they try and go to the account creation page i've set up it tells them the connection was reset while trying to reach the server please try again. And I can go to the account creation page from my own comp using the address i have from no-ip with DUC running on my desktop but when i try and create an account it says:

Code:

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\xampp\htdocs\runner.php on line 16
FAIL, try again

But my runner.php file is exactly as you had it:

Code:

<html>
    <body>
        <?php
        error_reporting(E_ALL);
        $name = $_POST['username'];
        $pass = $_POST['password'];
        $flags=0;
        if(!empty($_POST['TBC'])){
            $flags+=8;
        }
        if(!empty($_POST['WotLK'])){
            $flags+=16;
        }
        mysql_connect("localhost","root","ascent");
        mysql_select_db("logondb");
        if(mysql_num_rows(mysql_query("SELECT * FROM `accounts` WHERE `login`='$name'"))>0){   <------- Line 16 is here
            echo "UBER FAIL USERNAME TAKEN";
        }else{
            if(mysql_query("INSERT INTO accounts (login, password,flags) VALUES('$name', '$pass', '$flags' ) ")){
                echo"SUPER COOL AWESOME WORKNESS";
            }else{
                echo"FAIL, try again";
            }
        }

        ?>
    </body>
</html>

This is my realms.config as well just so u can see that I have it set correctly:

Code:

<Realm1 Name = "PwNsTaR Extreme Realm"
	Address = "pwnstar-wow.servegame.org:8129" 
	Icon = "PVP"
	Population = "1.0"
	TimeZone = "1">

And for those who are wondering where to DL Xampp since there is no link on that page anywhere you can get it here:

Code:

http://www.apachefriends.org/en/xampp-windows.html#641

**Rayuski** · 05-31-2009

Awesome guide!

**obliviousonion** · 08-03-2009

I had the same issue, with line 16, but I was rummaging through the code and I took issue to several points in it.

In the interest of more noob-friendly and debuggable code, I would advise this code for runner.php:

Code:

<html>
	<body>
		<?php
		error_reporting(E_ALL);
		$name = $_POST['username'];
		$pass = $_POST['password'];
		$flags = 0;
		if(!empty($_POST['TBC'])){
			$flags = 8;
		}
		if(!empty($_POST['WotLK'])){
			$flags = 24;
		}
		$host = "localhost";	//Location of MySQL (Don't need to change this)
		$mysqluser = "root";	//(CHANGE THIS) MySQL username
		$mysqlpass = "ascent";	//(CHANGE THIS) MySQL password
		$dbname = "character";	//(CHANGE THIS) Name of DB containing acct. info
		$table = "accounts";	//(CHANGE THIS) Name of table holding acct. info
		
		mysql_connect($host, $mysqluser, $mysqlpass) or die("Unable to connect to server");

		mysql_select_db($dbname) or die("Unable to select database");

		if(mysql_query("INSERT INTO $table (login, password, flags, banned) VALUES('$name', '$pass', '$flags', '0') ")){
			echo "Account Created";
		}else{
			echo "Account Creation Failed, Username Taken";
		}

		?>
	</body>
</html>

Naturally, you would replace the values I marked with "(CHANGE THIS)" to whatever they needed to be.
Everything except the MySQL password is identical to what I use, which works perfectly.

Also, the flag for WotLK is, in fact, 24. The old code worked in that respect, but if the user did not check both BC AND WotLK, he would not be able to play WotLK. Now the user can check any combination of BC or WotLK and be accurately recorded.

I am presently using ArcEmu 3.1.3.

**ScottyBoy** · 08-05-2009

josh you need to move the host file to desktop then mod it afterwards you need to save it and then move it back to the original folder

**4l3k** · 08-12-2009

i love it! +Rep

**Marlins238** · 09-08-2009

You have to pay for this..? Because instead of create host at the bottom of the page theres an add to cart button..

**mrjoker123** · 09-12-2009

can somebody make a guide on how to do it with that web hosting? thanks..

**Divyun** · 09-13-2009

Sweet awesome guide. +rep

Shout-Out

User Tag List

Thread: Making your server live with an account creation page

Thread Tools

Search Thread

guide

Fixing runner.php

Similar Threads

Make Your Server Public With Hamachi With An Account Creation Page

How To Make Your Server Public With Out Hamachi Problem Solved

Easy Guide to making your server live. With sceenshots.

Making your server public with hamachi/and making server 2.2.X

Make your server public with Hamachi

OwnedCore Forums

casino

CoreCoins

My OwnedCore

About Us

Casino