How to create a working registration page for MaNGOS rev 6399

[Insanity]

!!How to install your own personal registration page!!



Requirements:
Wamp Server
Registration page for the current Revision.
Windows 2k/ME/XP/Vista

.:Instructions:.

1. Wamp installation.











That should lead you through the installation...


2. Now, unpack the files inside the Registration rarfile into wampinstallationpath\www\

3. Go into your wampinstallationpath\www\config.php file and configure it as the following.

//////////////////////////////////////////
#MAIN HOST - MAIN SERVER
//////////////////////////////////////////
="localhost";            // MAIN HOST for Mangos database
="root";                    // MAIN USER for Mangos database
="YOUR PASSWORD";        // MAIN PASS for Mangos database
="mangos";                // MAIN NAME of Mangos database
//////////////////////////////////////////
="localhost";            // MAIN HOST for Realm database
="root";                    // MAIN USER for Realm database
="YOUR PASSWORD";        // MAIN PASS for Realm database
="realmd";                        // MAIN NAME of Real database
//////////////////////////////////////////
#HOST MAIN - REALM ONE
//////////////////////////////////////////
="localhost";            // MAIN HOST for Characters database
="root";                    // MAIN USER for Characters database
="YOUR PASSWORD";        // MAIN PASS for Characters database
="characters";            // MAIN NAME of Characters database
/////////////////////////////////
#HOST TWO - REALM TWO
/////////////////////////////////
="localhost";            // 2. HOST for Characters database
="root";                    // 2. USER for Characters database
="YOUR PASSWORD";        // 2. PASS for Characters database
="characters";            // 2. NAME of Characters database
/////////////////////////////////
#HOST THREE - REALM THREE
/////////////////////////////////
="localhost";            // 3. HOST for Characters database
="root";                    // 3. USER for Characters database
="YOUR PASSWORD";        // 3. PASS for Characters database
="characters";            // 3. NAME of Characters database
////////////////////////////////
#HOST FOUR - REALM FOUR
/////////////////////////////////
="localhost";            // 4. HOST for Characters database
="root";                    // 4. USER for Characters database
="YOUR PASSWORD";        // 4. PASS for Characters database
="characters";            // 4. NAME of Characters database
//////////////////////////////////////////

#REALM STATUS CHECK OPTIONS
//////////////////////////////////////////
 = 'CP1251';          // Set character encoding for MySQL
 = "localhost";                // MAIN HOST adress (for realm status)
 = "localhost";               // 2. HOST adress (for realm status)
 = "localhost";             // 3. HOST adress (for realm status)
 = "localhost";              // 4. HOST adress (for realm status)
 = "8085";                // Server port (for all realms status) 8085 or 3724
//////////////////////////////////////////

4. Change the RED parts to your serverip.
Change the PINK parts to your MySQL password.

5. You should be up and running with a functioning Wamp/Registration page for your MaNGOS rev 6300+

6.(Only if it's not working.)
If peopple still can't connect, but you're able to.
Make sure that Port 80 is used as the listen port and that it isnt't blocked by your ISP, Firewall, Router or anything.
To change your port, open the httpd.conf file and edit as following...
(The httpd.conf file is found inside wampinstallationpath\bin\apache\apache2.2.8\conf)


Change the orange part to your new listen port, but make sure that it's open all through, otherwise you'll have the same problem as before.

#
# Listen: Allows you to bind Apache to specific IP addresses and/or
# ports, instead of the default. See also the <VirtualHost>
# directive.
#
# Change this to Listen on specific IP addresses as shown below to 
# prevent Apache from glomming onto all bound IP addresses.
#
#Listen 12.34.56.78:80
Listen 80

Hope I was able to help you with this simple guide.
Not to much trouble to do it, but I know how hard it is to find a proper guide.

Best regards, Insanity.

[Yamajee]

Adding something to that, if still people can't connect and you can connect, check to make sure that Port 80 is the listen port and that it isn't blocked by your ISP like me, I had to change my listen port to 81. To change it, edit the httpd.conf File and edit the Listenport you get in there, but I'm pretty sure most of the ISP's won't block port 80, so don't panic a lot.

[Insanity]

Adding something to that, if still people can't connect and you can connect, check to make sure that Port 80 is the listen port and that it isn't blocked by your ISP like me, I had to change my listen port to 81. To change it, edit the httpd.conf File and edit the Listenport you get in there, but I'm pretty sure most of the ISP's won't block port 80, so don't panic a lot.

6.(Only if it's not working.)
If peopple still can't connect, but you're able to.
Make sure that Port 80 is used as the listen port and that it isnt't blocked by your ISP, Firewall, Router or anything.
To change your port, open the httpd.conf file and edit as following...
(The httpd.conf file is found inside wampinstallationpath\bin\apache\apache2.2.8\conf)


Change the orange part to your new listen port, but make sure that it's open all through, otherwise you'll have the same problem as before.

[punzzer]

Were is " Registration page for the current Revision." ????????

[Insanity]

Were is " Registration page for the current Revision." ????????

Lol sorry for that, something went wrong when posted. (maybe I was a little too tired)

Registration page for current revision


There you go

[zachj95]

Umm im getting this

Fatal error: Call to undefined function error() in C:\wamp\www\functiondata.php on line 227

How do i fix it?

[Insanity]

Umm im getting this

Fatal error: Call to undefined function error() in C:wampwwwfunctiondata.php on line 227

How do i fix it?

Hmm, that's a nasty one.

Line 227 Contains ---

error('Unable to connect to MySQL server. MySQL reported: '.mysql_error(), __FILE__, __LINE__);

Make sure that you're running MySQL and your password and everything is correct in the php files...

If it doesnt work... Try copying the Line 227 I posted and replace your old one with this one.

!!!Make sure to make a backup of your functiondata.php!!!

[Ryma]

Awsome Guide +Rep

[connor4333]

how do you do it so theres only 1 realm and not realm 1,2,3,4?

[Insanity]

how do you do it so theres only 1 realm and not realm 1,2,3,4?

no need to. they won't show until you fill them up anyways =)

[Evan_moore]

HELP PLEASE

i get this error and can't fix it


Fatal error: Call to undefined function error() in C:\wamp\www\functiondata.php on line 227

HELP THIS IS What MY FUNCTIONS LOOKS LIKE

the part i think the error is in

class DBLayer
{
var $link_id;
var $query_result;
var $saved_queries = array();
var $num_queries = 0;

function DBLayer($db_host, $db_username, $db_password, $db_name)
{
$this->link_id = @mysql_connect($db_host, $db_username, $db_password, true);

if ($this->link_id)
{
if (@mysql_select_db($db_name, $this->link_id))
return $this->link_id;
else
error('Unable to select database. MySQL reported:'.mysql_error(), __FILE__, __LINE__);
}
else
error('Unable to connect to MySQL server. MySQL reported: '.mysql_error(), __FILE__, __LINE__);
}

function query($sql)
{
$this->query_result = @mysql_query($sql, $this->link_id);

if ($this->query_result)
{
++$this->num_queries;
return $this->query_result;
}
else
{
return false;
}
}

[jalmari36]

Ok i need to change my mysql host address to hamachi ip, i did once change it from local host to 81.175... But i forgot how. xd

[jalmari36]

Ok changed port, works fine, but when i try to go to webpage, it is blank.
Is something wrong

[jalmari36]

Come on answer me!

[fantom727]

It works