How to make a Registration page?

[trygon11]

So i made my server public (i think)
I changed my realmlist to my external IP and my realmlist.conf
I myself can still connect.
I dont however have a registration page for other people to make accounts
I am using Arcemu
I made a DynDns host thing and changed my hosts folder in my c:/Windows/system32/drivers/ect to
127.0.0.1 DynDNS name
Internal IP DynDNS name
External IP DynDNS name

now when i put my dyndns name in my browser i get my router page
Ive also already forwarded the proper ports


If you need any other info just ask

+Rep x3 for a working solution

All Help is VERY much appreciated.
Thank you!

[trygon11]

Even a link to a working guide, so far i haven't found any decent ones, either they didnt work or they were in some other language.

[Summer]

Ur useing wamp or somthing ?

[spitfire21]

Ok well Im guessing you don't know php there really isn't a guide.
There are guides to learn php but for you the best solution would be
download someones and customize it for you. To do that read their
guide on how to install and change logos and images around.

[Aellya]

Indeed, what you need is to make a form where people supply their info (account name, password, email, extra info) then submit it to a page (can be the same page) which then adds an entry to the mysql table. This can only be done with a dynamic server page system such as asp or php

A sudo php example, Exclues the web page form needed to submit the data (loads of info about how to make those on t' 'net)


define("DB_LOGON", "logon_db"); // Change to your database name

<add checking here for valid username and password strings>

// Check if the user name is already used.
$sqlquery = "SELECT acct FROM ".DB_LOGON.".accounts WHERE login='$username'";
$query = mysql_query($sqlquery);
$number = mysql_num_rows($query);
if($number >= 1)
echo "That user name is already taken. If this is your new account, wait up to 5 minutes before it gets activated.";
else
{
// Add the new account
$ip = getenv('REMOTE_ADDR');
$userpass = strtoupper($username).":".strtoupper($password);

$sqlinsert = "INSERT INTO ".DB_LOGON.".accounts (`login`, `password`, `encrypted_password`, `email`, `lastip`)";
$sqlinsert .= " VALUES ('$username', '$password', SHA('$userpass'), '$email', '$ip')";

mysql_query($sqlinsert);
echo "Account Created!";
}

The login server rescans the account table every 5 minutes so it can take upto 5 minutes before the account becomes active.

Hope this helps