Custom Search
Installing and setting up Apache Webserver with PHP – Setting up Private WoW Server
Posted by Reaper-X Jul 9 2007 4:40 pm
This is the fourth part of the Creating your own World of Warcraft Server using Mangos
- The First part is all about Installing and Configuring MySQL on your Windows Machine
- The Second part is about Configuring the WoW Mangos itself
- The Third part is all about Setting up Private WOW Server for Lan Party
- The Fourth part is all about Installing and Setting up Apache Webserver with PHP
Okay this is the last part of my guide about creating and setting up private wow server. And as the title said, this part is all about setting up webserver using apache on your pc that can be used to put the registration page for your private wow server
Previously i’ve said that i want to tell you on how to create the registration page for your wow server. Unfortunately, it seems impossible (if you know a good registration page that can be used for WoW Classic Server and TBC Server … please let me know) because different mangos version use different structure like column number differences between the wow classic server with the wow tbc server inside the realmd.account table. So in this guide im going to tell you to use the simple registration page created by Mangos-files.de that can be used for the registration page of your WoW Classic Server
But i think you don’t have to worry about that, because if you understand the steps required to set up webserver on your pc, basically you’ve done the important part with the exception you might need to edit / create the registration page by yourself
As a side note, you can also use your webserver for many other things like hosting your own webpages from your own computer :)
That’s all for the intro … now we’re going to start the guide
Requirements :
- Apache HTTPD (Free / Open Source) – In this example i use Apache 1.3.3.7 (Apache 1 Series)
- PHP Win32 Zip Version (Free / Open Source) – In this example i use PHP 4.4.3 (PHP4 Series)
- Know how to setup port forwarding
- A simple registration page for mangos (you can get it from here) / create one by yourself
Optional : Some people might prefer the easiest way of doing it … and if you like it that way then i’d suggest you to use XAMPP instead. But if you decided to use XAMPP and you already followed my previous mysql installation guide, you don’t need to enable the MySQL Service from XAMPP Control Panel
Note : i never tried using XAMPP but from the screenshot at XAMPP Website i think the XAMPP provides you a control panel / menu to enable or disable individual service from it
Important Note : Please take caution if you want to make your webserver accessible to everyone, because this guide only tell you the basic way of setting up webserver from your own computer
Installing Apache Webserver :
Since Apache installation for Windows is straightforward, you can just simply follow the setup process until this part, and then continue with the installation process until finished :
and don’t forget to remember the path where you’re going to install it
Installing PHP :
First of all you need to extract php into somewhere on your harddrive, and in this example the php location is at C:\PHP. And after you’ve finished extracting it, go to C:\PHP\Sapi from Windows Explorer and copy the php4apache.dll into the root of the php directory. If you choose to use Apache 2, then you need to copy the php4apache2.dll instead
Here’s what it should look like :
Installing PHP as module in Apache HTTPD :
Now after finished with the previous steps, you need to configure apache to load the php4 as a module. And here’s how to do it
1. Open httpd.conf in your Apache conf directory (in this example, the httpd.conf can be found at C:\Program Files\Apache Group\Apache\conf\httpd.conf)
2. Uncomment the :
LoadModule rewrite_module modules/mod_rewrite.so
and add this line after all the loadmodule :
LoadModule php4_module “C:/php/php4apache.dll”
Example image below :
3. At the addmodule section uncomment the :
AddModule mod_rewrite.c
and then at this line :
AddModule mod_php4.c
example image below :
4. At the addtype section add this line :
AddType application/x-httpd-php .php
AddType application/x-httpd-php-source .phps
5. Now at the DirectoryIndex section add / replace the previous line with this one :
DirectoryIndex index.html index.php
From the above example, the index.html always get first priority over index.php file but you can change it as you like
Testing your Apache Installation :
As for the last, now you need to open the command prompt window (Start Menu -> Run -> type CMD) or Start Menu -> Accessories -> Command Prompt
and type :
- Net stop apache
- Net start apache
This is done to make apache reload the configuration files that have been changed
Now you’ve finished with all the process, but of course you need to make sure your webserver is working properly so now you need to test it by typing http://localhost via your browser and if you see something like above image, that means your webserver is working
You’ve finished setting up apache webserver, mysql and php on your computer .. Now what you should do next ? well … because this is part of the mangos series guide, of course now you need to put the registration page you’ve downloaded previously into your www document root directory
If you followed this guide, the document root can be found at C:\Program Files\Apache Group\Apache\htdocs … but since the webserver is located on the same location as where you are, you don’t need FTP Program to do it, you just need to copy / extract the simple registration page into that directory … simple isn’t it ?
Trackbacks/Pingbacks
Leave a response
Connect with me
В этом что-то есть. Понятно, большое спасибо за помощь в этом вопросе.
I was righteous reading a point on how to persuade your down comforter all puffy again and practically all the answers said that you can categorize some tennis balls in the dryer to estimate that happen. how to pressurize a tennis ball mortarSo how does that plough exactly? Why does this happen? Can you throw away something else pretty than tennis balls? Thank you!
how to loop a tennis raquet
xBox Help, Tips and Tricks, Solutions and repair video, Cheats and secret codes for game consoles
Хостинг webolimp.us про устойчивый хостинг в Европе. Цена за хостинг от 8 рублей в месяц, надежные сервера. Кроме хостинга мы предлагаем следующие интернет услуги: Web-дизайн сайтов, создание web-сайтов, реклама ваших товаров или услуг в сети интернет.
Сайт компании Укрпостач, комплектация промышленной продукции. Комплектаця по Украине: клея, лаки, отвердители, мастика, пластикаты, резиновые смеси. Лаки-АК-113, ФЛ-582, КО-85, КО-815. Смолы, отвердители-Продукт АГМ-3, АГМ-9, К-115, К-153, СЭДМ-6, ЭД-20, Л-20. Резиновые смеси-ИРП-1078 нта, НО-68-1 нта, ИРП-1338 нта.
Сайт beton.zp.ua компании по реализации бетона, песка, цемента, сыпучих материалов, железобетона. Продаем бетон марок М50, М100, М150, М200, М250, М300, М350, М400. Производство высококачественного товарного бетона, продажа цемента, песка, керамзита, сухих строительных смесей.
Hello:
I am having some problems setting up Apache 2.0 Apache shows locally when I type the internal address 192.168.100.100 however when I try to connect externally I can’t get apache to connect to my internet provider’s ipaddress.
I am using Windows xp. The error message I am getting is can’t listen to port 80. However I changed port 80 to port 21 and port 8080 in the configuration file and the dos prompt does not stay on.
Any help you can give me would be gladly appreciated. My phone number is 204-694-8950 you can call me collect if you wish. I checked the configuration files and yet still I am still having the problems.
Thanks in Advance
Emanuel
I installed xampp and it’s working fine but i have a problem.
Even though I setup port 80 in both my firewall and router I’m told there’s a port issue seems that something else is using port 80. how do I detect that and fix the collsion?
#Paragon
hey thanks alot that link was a browser takeover site I love having my system overload with popups
Найти фамилию и адрес в Санкт-Петербурге по телефонному номеру абонента МТС – здесь поможет мобильный телефонный справочник и мобильная база данных МТС, Мегафон. Поиск человека по адресу и по фамилии в базе данных сотовых операторов Петербурга быстро и легально.
Узнать в Петербурге адрес и имя по номеру мобильного владельца сим-карты Мегафон – используется мобильный телефонный справочник СПб и телефонная база данных Мегафон, МТС. Поиск человека по адресу и по фамилии в базе данных сотовых операторов Санкт-Петербурга легально и быстро.
offering $100 for somone to help me set up all this with a page. e-mail me wardogtoolz@hotmail.com
Could some one help me, i cant seem to fined reaper-x registration page for my own web page.
thx if anyone can help
that second address is already up and hosting the index.zip.
It’s:
http://myfreefilehosting.com/f/a763abeade_0.1MB
Ok, I know there is a way to post stuff in a
So I’m putting it on fileplanet at
http://www.fileplanet.com/files/180000/184448.shtml
may be up in a few days…
and at
[URL]http://myfreefilehosting.com/f/a763abeade_0.1MB[/URL]
Hey Frantic,
for some reason my last comment got flagged and is awaiting moderation, so I logged in and am resending info to you. I couldn’t find my old index.php file and my new one is with a changed database that is too diferent too work without changing your db too match. I’ll send a reply as soon as I’m done with a new index.php for you.
Termigator
Hey Frantic,
I’ll load my old one which was just the one they provided with some fixes.. Looking for it now, will send in a few minutes after I check to make sure it works..
Termigator
just wondering if someone can post a full php script for users login and register page would be helpfull thanks so much
ahh man.. add the ; and anything else I missed, thanks… sorry, tired… cya
err: depends on your user/pass/email inputs…
function sha_password($user,$pass){
$user = strtoupper($user);
$pass = strtoupper($pass);
return SHA1($user.’:’.$pass);
}
$u = $_POST['username'];
$pass = $_POST['password']
$p = sha_password($u,$pass);
mysql_query(”INSERT INTO account (username,I,email) VALUES (’$u’,'$p’,'$e’)”);
Ok, This should work to create the encrypted password from the username/password needed in column “I” of database. It worked for me…
function sha_password($user,$pass){
$user = strtoupper($user);
$pass = strtoupper($pass);
return SHA1($user.’:’.$pass);
}
$u = $_POST['username'];
$p = sha_password($username,$password);
Oh, and btw, I got the “Players Currently Online” to work. Problem was that the character “online”(not Account “online”) column was in the characters db, not the mangos db.
*** So what Was:
Name:
<?php
$mysqlcon = mysql_connect(”127.0.0.1″,”root”,”mypass”);
mysql_select_db(”mangos”,$mysqlcon);
$mysqlres = mysql_query(”SELECT `name`,`guid`,`class` FROM `character` where `online` = 1″);
while (($thisuser = mysql_fetch_array($mysqlres))) {
echo ‘‘;
printf(”%s”,$thisuser['name']);
echo ‘‘;
}
?>
*** Should read:
Players Currently Online
Name:
<?php
$mysqlcon = mysql_connect(”127.0.0.1″,”root”,”mypass”);
mysql_select_db(”characters”,$mysqlcon);
$mysqlres = mysql_query(”SELECT `name`,`guid`,`class` FROM `character` where `online` = 1″);
while (($thisuser = mysql_fetch_array($mysqlres))) {
echo ‘‘;
printf(”%s”,$thisuser['name']);
echo ‘‘;
}
?>
or something there about…
****
** big change was:
mysql_select_db(”characters”,$mysqlcon);
everything else was cosmetic for my site, from what I remember…
Well, I guess the “I” column IS the password or at least it is a function of the password and the username… When you create a username and password from the mangos> command prompt the username goes into a username field, but the password does not show up in a password field, instead, the username and password are used to create an encrypted field “I”.
*** I need to know ***
Does anyone know how I can encrypt the username and password submitted in my website in .php so that it can be inserted into the “I” field of my database and work properly as the password created by the user at the game login menu.
Thanks
Ok, I’m giving up on this for now. Apparently the “I” is not the password either. and the only columns I see in Account in Realmd are as Follows:
(id,username,I,gmlevel,sessionkey,v,s,email,joindate,last_ip,failed_logins,locked,last_login,online,tbc,mutetime,locale)
So, I could really use some help with the function that sends data to the account in realmd so that ppl can create their own accounts on the website and the log in to the game.
P.S. These posts were referring probs encountered trying to get the simple registration page to work.
It was provided up at the top of the page, step 4, below Requirements ie:
http://mangos-files.de/index.php?show=misc&num=1
Oh, and one more thing…
I wanted setbc = 1 for all users by default.
Everyone already had the bc expansion.
I used SQLyog to edit the realmd database, double-clicking or expanding the table “account” in “realmd” and then right-clicking on Columns and selecting “Manage Columns” third column over “Defaults” and down in the “tbc” field edit 0 to 1
Problem: Could not create accounts from webpage.
Fix: column for password in db is I not password, plus I got rid of all the other junk cause most defaults are fine, and other columns don’t match as well, ie. banned.
Problem: was missing the email request,
Fix: added:
Email Address:
** Data sent to db Was:
mysql_select_db(’realmd’);
$q = “insert into account ( username,password,gmlevel,sessionkey,joindate,banned,last_ip,failed_logins,locked,last_login,online) values (’$u’,'$p’,'0′,”,NOW(),’0′,’127.0.0.1′,’0′,’0′,’2000-01-01 00:00:00′,’0′)”;
Changed to:
mysql_select_db(’realmd’);
$q = “insert into account ( username,I,email) values (’$u’,'$p’,'$e’)”;
Plus this change made more sense as well. this is my first time with php so don’t dis…
It Was:
$r = mysql_query($q);
if (!$r) { echo “MySQL error: ” . mysql_error().”!”; } else { echo “Registration Completed!”;}
echo ‘Return to add another.‘;
I changed it to:
$r = mysql_query($q);
if (!$r) { echo “Error:” . mysql_error().”! **Try a different username** “; } else { echo “Registration Completed!”;}
echo ‘Return to add another.‘;
It made more sense to me. I know I coulda put another if in to verify the error was a duplicate username, but since i figured it’s gonna be a duplicate username 99% of the time it’d be ok to let it slide…
I still am not getting my online chars to show up.. if someone reads this please help … I have:
Players Currently Online
Name:
<?php
$mysqlcon = mysql_connect(”localhost”,”root”,”mypass”);
mysql_select_db(”mangos”,$mysqlcon);
$mysqlres = mysql_query(”SELECT `name`,`guid`,`class` FROM `character` where `online` = 1″);
while (($thisuser = mysql_fetch_array($mysqlres))) {
echo ‘‘;
printf(”%s”,$thisuser['name']);
echo ‘‘;
}
?>
In the previous post err:
I would like to figure out a way to set all newly created accounts to BC, ( ie. setbc acctname 1 )
but from the index.php and not the mangos command prompt
Hey! – Kudos!
Great Guide! Following directions everything worked perfectly. The images were a great idea to verify I was on the right track. I can’t thank you enough!
When my index.php is accessed by a web browser everything seems to appear fine, however i don’t believe it is accessing the db correctly. It is not showing players online, and when I go to create an account I get the following error message:
MySQL error: Unknown column ‘password’ in ‘field list’!Return to add another.
Also I would like to figure out a way to set all newly created chars to BC or maybe have a way to have it as an option in the index.php. Wondering if it could be added to the following line somehow:
$q = “insert into account ( username,password,gmlevel,sessionkey,joindate,banned,last_ip,failed_logins,locked,last_login,online) values (’$u’,'$p’,'0′,”,NOW(),’0′,’127.0.0.1′,’0′,’0′,’2000-01-01 00:00:00′,’0′)”;
sorry for the long post… Hope you are still there. I can give more details if you need them.
Also, I’m using the following:
$db_u = “root”;
$db_p = “mypass”;
$db_host = “127.0.0.1″;
I have Unzipped the XAMPP and started the xampp_start.batch file.
But,There is an error and it says
A service specific error occurred: 1.
More help is available by typing NET HELPMSG 3547.
When I type that, this message appears:
The *** service is stopping
Reaper-X,
First off… I love the guide.. my server up and runnin on lan with help from no-ip i can access from lan or internet with no probs. I am trying to setup the test reg page. PHP and Apache work fine and the page loads it also writes to the MySQL db…. all except the password…? I used a 3rd party mavicat to view db… no password column i get the MySQL error: Unknown column ‘password’ in ‘field list’. It appears as though it is encrypted and in column I. I could be wrong… any advise on where the password is stored or how i store it in datat base from php app via web
i am using
Mango 4875
apache 2.2
php 5
Hi! i dunno if i can use a server like this can i? im not realy good at computer but im understand what stands but will i succes?
hey im sure you get this all the time lol, but im having hella time with setting up my private wow server, i have a web hosting for my site through http://www.aplus.net and am trying to work mysql and php database there, ive been playing with mysql and your newer newby freindly mango emulator and trying to get apache 1.3.39 installed. honestly im perty new to php coding in the first place with doing minor twinks on my forum. ive reasearched your tuts for hours on end now with my assistant admin and we are still stumped. ive registerd and am waiting to be in the forum. if you could e-mail me i can give you a lot more detailed info like my server and what not. ty for your time, and i might add, you are a GOD at this lol
is this legal?
Reaper, i have 2 problems:
First is -(i do all things what you had written in tips) everything works before, but when i made Apache and PhP i want to test my server and there is error and i can’t play. I run `realmd.exe` and `mangosd.exe` and on `mangosd.exe` it shows “(…) Check existing of map file ‘D:/wow/Daemon/Mangos/maps/0004331.map’ : not exist! Correct *.map files not found in patch ‘D:/wow/Daemon/Mangos/maps’ or *.vmap/*vmdir files in ‘D/wow/Daemon/Mangos/vmaps’(…)”
Datadir is correct, maps too i think (THERE IS 0004331.map in /maps! and i used ad.exe again – same!)
Second is: i don’t know how to make registration site (on Web) for my server (where people can register).
Please help me (i’m makeing server first time and i hope to play it soon ^^)
Hey, I see that you show us how to do this all, you helped me set up my other server and well I need help agian :(
Its about the port forwarding thing though. How do i forward ports, I went to my modem site 192.168.1.1 and then i logged in using username as admin (default) and pass as password ( default) then it asked me to make a real username and password, well i made it be eaxtly as the default and now i won’t let me forward ports. I am using Verizon DSL modem modle westell 6100.
I looked all over fot the solution and well noone can help me on this. I called my internet service provider and now they want me to pay more then the original 100$ AMerican dollars we are already paying.
I came for server help here for last my resort, because i know your good at what you do.
But well now I am back. Please respond ASAP if you can, I have had like 50 e-mails from our server site saying they can’t join the server registration page, says they don’t have acess and so on (its because of my ports) then people can’t log into my server (its because of my ports) I can play the server on Lan and on my computer but then others can’t.
Please help. I know your the best and so I came to the best ( not to flatter you)
I just wondered, if we make this on the internet, will our Normal WoW account be deleted? And how do we reset this server, i dont remember…
I got everything running, but the link to the sample reg page is not working. can you send me a link to a good one or email to me.
Just wanted to also say….AWSOME JOB….getting all this info out here for us.
Greatly appreciated.
The Apache service is starting.
The Apache service could not be started.
The service did not report an error.
More help is available by typing NET HELPMST 3534.
i seem to be having the same issue as Xyzy…
please and info on which direction to go
I got everything running great..I dont know what to do now..I downloaded the registration page and inserted that and that comes up now when i type in http://localhost..Can someone point me in the right direction..thnks a bunch
I got the server up and working great, I need a working registration page for my site. Anyone got one? Feel free to contact me at Mistafreeze2009@hotmail.com.
so i set up the apache server and go to that localhost website, but what do i do now? What do i need to do to get my friends connected and what do they need to do?
yeah me too, i really need this… everything is fine but i need a working reg page
Any 1 manage to get the simple sign up working. Please if u have can u msn me at crighton35@msn.com.
I have been goin for hours changin shit and nothing seems to work. The server is fine, the DB is fine it all works, just cannot get signup working.
thanks in advance.
# elliott
No .conf file ? are you sure ? that files actually always be there or else the httpd process won’t run at all
yo gm levels are actually 1-3 for me cuz moderator=1 game master=2 and administrator=3 and for gm commands in the game press enter type in .commands all the gm commands will pop up that are at you are able to use according to your gm level (p.s. i am using an older mangos thing for client 2.1.3 works great and higher versions connect succsessfully)
i cant log on it says “unable to connect”
all i found was apache 2.2.4 and for some reason theres no .conf file
EDIT: “NET HELPMSG 3534″
Well, fixed that problem, only to come upon a new problem during “net start apache.”
The Apache service is starting.
The Apache service could not be started.
The service did not report an error.
More help is available by typing NET HELPMST 3534.