DJRavine's Codebook:

[ADVERTISEMENT]
Thread Closed 
 
Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
[MANGOS] Set up your Mangos Server 2.0.8 TBC with EasyPHP
03-06-2007, 08:48 AM (This post was last modified: 07-25-2007 04:46 AM by DJRavine.)
Post: #1
[MANGOS] Set up your Mangos Server 2.0.8 TBC with EasyPHP
First of all you must have World of Warcraft: The Buning Crusade 2.0.8
you can download patches from Here

PART 1: DOWNLOADS

1. Download SQLyog at SQLyog Downloads Page

2. Download the latest version of EasyPHP at EasyPHP Downloads Page

3. Download the server:

DOWNLOAD LINKS BY DJRavine:

DOWNLOAD: MaNGOS v2.0.8 [COMPLETE].rar - 233.93MB [FileCrocodile.com]
DOWNLOAD: MaNGOS v2.0.8 [COMPLETE].rar - 233.93MB [SendSpace]
DOWNLOAD: MaNGOS v2.0.8 [COMPLETE].rar - 233.93MB [UpLoading.com]


PART 2: INSTALL


1. Install EasyPHP

2. Install SQLyog

3. Extract MaNGOS_TBC_v2.0.8_COMPLETE.rar to "C:\Mangos"

PART 3: SETTING UP YOUR PASSWORD

1. Run EasyPHP (Be sure that Apache and Mysql are on "Running" status, right-click on his icon in trayicon, on the bottom-right side of the screen, and click Run or press F2)

2. Open your EasyPHP folder (Eg. C:\Program files\EasyPHP 2.0b1) and copy phpmyadmin folder in www folder.

3. Open your browser and go to http://127.0.0.1/phpmyadmin

4. Click on Privileges

5. Click Edit Privileges of root user (the right sided icon with a guy with a pencil)

6. Edit there your password (it will be usefull for mangosd.exe and realmd.exe connection to databases)

PART 4: SETTING UP YOUR DATABASES

1. Now open SQLyog

2. Put "localhost" as MySQL Host Address, "root" as User Name, the password of your database as Password and "3306" as port

3. Click Save and then click on Connect

4. Right-Click on [email protected] group and then select "Create Database"

5. Type "mangos"

6. Repeat step 4 and then step 5 but type "realmd" instead of mangos this time

7. Now right-click on mangos database and select "Restore From SQL Dump"

8. Find the mangos_bc.sql and load it (it should be in "C:\mangos\sql" folder)

9. Wait a little and then repeat step 7 but now for realmd database

10. Same as step 8 but now you've to load realmd.sql

PART 5: SETTING UP REALM(realmd.exe) AND WORLD(mangosd.exe) CONNECTIONS

1. In C:\Mangos folder open realmd.conf with notepad.

2. edit LoginDatabaseInfo like this -> LoginDatabaseInfo = "localhost;3306;root;mypass;realmd" (delete "mypass" and type your password that you've set up in phpmyadmin)

3. Now open realmd.conf with notepad.

4. edit LoginDatabaseInfo as in step 2 and
WorldDatabaseInfo like this -> WorldDatabaseInfo = "127.0.0.1;3306;root;mypass;mangos"

PART 6: RUN YOUR SERVER

1. Run realmd.exe

2. Run mangosd.exe

PART 7: SET UP YOUR CLIENT TO CONNECT TO YOUR SERVER

1. Open realmlist.wtf with notepad.

2. Delete everything and type: "set realmlist 127.0.0.1" (or "set realmlist <your ip>)

Part 8(Optional): INSTALL WEB PORTAL

1. Download Web Portal (Link By BurningDappa)

2. Extract it on your www EasyPHP folder ("C:\Program Files\EasyPHP 2.0b1\www" or something like that)

3. Now Open SQLyog

4. Connect into your sql server

5. Right-Click on realmd database database and select "Restore From SQL Dump"

6. Load "sql_account_extends.sql" in sql folder ("C:\Program Files\EasyPHP 2.0b1\www\sql" or where you've extracted the web portal)

7. Do step 5 and then step 6 for "sql_newtables.sql" and then in "C:\Program Files\EasyPHP 2.0b1\www\sql\updates" load 22.sql

8. Edit config.php in www folder like this:
Code:
<?php
$config = array(
'template'       => 'offlike', //Default template
'lang'           => 'en',        // Default language
'db_type'        => 'mysql', //Database type
'db_host'        => '127.0.0.1', //Database IP
'db_port'        => '3306', // Database Port
'db_username'    => 'root',// Database Username
'db_password'    => 'mypass',// Database Password
'db_name'        => 'realmd', //Name of Realm Database
'db_encoding'    => 'CP1251'     // Very important, check your mysql "my.ini"
);

$news_forum_id = 0;            // forum id for frontpage news.
$bugs_forum_id = 0;            // forum id for "bugtracker" forums

$templates = array('offlike');
$languages = array(
    'en' => 'English',
    'ru' => 'Russian',
    'de' => 'German',
    'hu' => 'Hungarian',
    'es' => 'Spanish'
);
?>
If you have some question... just ask it!

I hope this guide could be usefull for every one that wants to open a new 2.0.8 tbc server Wink

Cya.

By Hakuji.
Find all posts by this user
03-09-2007, 11:51 PM
Post: #2
[MANGOS] Set up your Mangos Server 2.0.8 TBC with EasyPHP
hey lemme be the first to thank you for this. My server works perfectly but i am a noob when it comes with PHP and webservers Sad . so i have no idea what to do with these files... after i do all that stuff with easyPHP what do i do next Confused? CAN U PLEASE HELP ME
Find all posts by this user
03-12-2007, 12:33 AM
Post: #3
[MANGOS] Set up your Mangos Server 2.0.8 TBC with EasyPHP
After you set up all these things you may now let mangosd.exe and realmd.exe run. Go in your World Of Warcraft folder (C:\Program Files\World Of Warcraft) and open your realmlist.wtf using notepad. Then delete everything is in that file and type "set realmlist 127.0.0.1" or "set realmlist <IP>" and put your IP or your DNS instead of <IP>. Wink
If you have other issues after this... explain what's your problem Big Grin... i'll try to help you again Wink
Find all posts by this user
03-13-2007, 08:53 PM
Post: #4
[MANGOS] Set up your Mangos Server 2.0.8 TBC with EasyPHP
Nice work.

And you access the site by going http://myip (Eg. http://198.26.589.9)?
03-14-2007, 03:35 AM
Post: #5
[MANGOS] Set up your Mangos Server 2.0.8 TBC with EasyPHP
Hello Hakuji,

I've struggled getting a private realm up for nearly 7 hours in a row now, trying different things. I decided a while ago to use MaNGOS way of doing it, and since then I've tried many different toturials - but no luck.

I followed your step by step guide, and I managed to download all the correct programs and get my SQL server running - also "dumping" the correct sql files (mangos_bc and realmd_bc) into the databases (hoping I make sense now).

I then changed the realmlist file in my WoW root folder to the correct information allowing me to access my private realm. Before I entered WoW though, I made sure to open realmd.exe and mangosd.exe.

I can't understand though - what should be my login and password when I've entered WoW? I've tried hosting a private realm ages ago, where I manually (outside of wow) had to make the account I was going to use in WoW. I used Mara's Repack back then.


Please see if you can help me, mate Sad

You can either contact me through here or by e-mail [email protected]

Ask away of things I've done or haven't done, and I'll answer the best way I can.
03-18-2007, 10:29 PM
Post: #6
[MANGOS] Set up your Mangos Server 2.0.8 TBC with EasyPHP
Soren you can make accounts in the MaNGOS program. I forgot the command though. Also if you have the webserver setup you could create it on there and open MySQL and change the account type from 0 to 3.

Anger at lies lasts forever. Anger at truth can't last.
Greg Evans, Luann (comic), September 27, 2003
My body won't tell my mind what ive been thinking before its out of my mouth.
ITS A TRAP!
Find all posts by this user
03-25-2007, 04:45 AM
Post: #7
[MANGOS] Set up your Mangos Server 2.0.8 TBC with EasyPHP
mmmmm when i install the easyphp and it start.. it says that port 3306 is occupied by Mysqld-nt
what to do???' only the icon of apache is green the icon for mysql is red
Confused
03-25-2007, 05:03 PM
Post: #8
[MANGOS] Set up your Mangos Server 2.0.8 TBC with EasyPHP
check that you dont have another copy of mysql server running when u load...

[Image: DJRavine_userbar.gif]
[Image: djr_sig.png]
[Image: thedjravine.png]
"In a world of genocide... The pacifist must take control..." - DJRavine
Visit this user's website Find all posts by this user
03-30-2007, 11:00 PM
Post: #9
[MANGOS] Set up your Mangos Server 2.0.8 TBC with EasyPHP
Agh, I've been trying to get my Web server running all day, it keeps coming up with this,
Code:
SQL Error: Client does not support authentication protocol requested by server; consider upgrading MySQL client at c:\program files\easyphp1-8\www\mwf_w3\index.php line 37

Array
(
    ([)code] => 1251
    [message] => Client does not support authentication protocol requested by server; consider upgrading MySQL client
    [query] => mysql_connect()
    [context] => c:\program files\easyphp1-8\www\mwf_w3\index.php line 37
)

At the bit where it has ([)code] take out the brackets, i had to put them there to stop it messing up my post.
03-30-2007, 11:53 PM
Post: #10
[MANGOS] Set up your Mangos Server 2.0.8 TBC with EasyPHP
hmm.. this looks serious...
coz the client hasnt got the protocol...
what version mysql server are you running?

[Image: DJRavine_userbar.gif]
[Image: djr_sig.png]
[Image: thedjravine.png]
"In a world of genocide... The pacifist must take control..." - DJRavine
Visit this user's website Find all posts by this user
03-31-2007, 12:05 AM
Post: #11
[MANGOS] Set up your Mangos Server 2.0.8 TBC with EasyPHP
I've fixed that now but i get this now,
Code:
SQL Error: Table 'realmd.site_settings' doesn't exist at C:\Program Files\EasyPHP 2.0b1\www\mwf_W3\core\common.php line 38

Array
(
    [code] => 1146
    [message] => Table 'realmd.site_settings' doesn't exist
    [query] => SELECT * FROM site_settings
    [context] => C:\Program Files\EasyPHP 2.0b1\www\mwf_W3\core\common.php line 38
)

And im running MySQL v5

I also get errors when im importing 2 www files, 22.sql and sql_newtables.sql
03-31-2007, 12:45 AM
Post: #12
[MANGOS] Set up your Mangos Server 2.0.8 TBC with EasyPHP
have u installed all the sql files to the DB...

ps.. i havent used this pack at all..
so i dont know its install method...

[Image: DJRavine_userbar.gif]
[Image: djr_sig.png]
[Image: thedjravine.png]
"In a world of genocide... The pacifist must take control..." - DJRavine
Visit this user's website Find all posts by this user
03-31-2007, 12:47 AM
Post: #13
[MANGOS] Set up your Mangos Server 2.0.8 TBC with EasyPHP
DJRavine Wrote:have u installed all the sql files to the DB...

ps.. i havent used this pack at all..
so i dont know its install method...

Well i've got other packs to work, all i really need is a simple page with a registration form and a WhosOnline page

So link me if you have any simple ones...

P.S. Your one worked at http://nadasoft.ath.cx/wowps/forum/showthread.php?t=12 but i'm not planning at setting up any forums just a registration page with a whosonline page like i said, :bowl:

Heres an example of what im looking for : http://magicstar.ath.cx/
03-31-2007, 02:00 AM
Post: #14
[MANGOS] Set up your Mangos Server 2.0.8 TBC with EasyPHP
http://www.wowps.org/forum/showthread.php?t=95
03-31-2007, 02:36 AM
Post: #15
[MANGOS] Set up your Mangos Server 2.0.8 TBC with EasyPHP
Mist Wrote:http://www.wowps.org/forum/showthread.php?t=95
Great, Thanks, Can you please test it for me and go to http://81.99.178.151/ make an account and login for me so i know it works for everybody else, thanks.
04-03-2007, 04:50 PM (This post was last modified: 04-03-2007 05:59 PM by Kerppa.)
Post: #16
[MANGOS] Set up your Mangos Server 2.0.8 TBC with EasyPHP
Okey, I dont even know where to start Tongue
I downloaded the Server and that webpage. Did everything by the guide line.
Even downloaded SQLyog to do everything like the guide line.
Still not working! Getting constantly this error On step 7.
Quote:SQLyog: sql_newtables.sql
[COLOR="Red"]Query:
ALTER TABLE realmlist ADD `dbinfo` varchar(255) DEFAULT NULL

Error occured at:2007-04-03 09:46:16
Line no.:11
Error Code: 1060 - Duplicate column name 'dbinfo'[/COLOR]

Same whit Navicat:sql_newtables.sql
[COLOR="Red"][Err] 1060 - Duplicate column name 'dbinfo'
[Msg] Finished - Unsuccessfully[/COLOR]

SQLyog:22.sql
[COLOR="Red"]Query:
ALTER TABLE site_regkeys ADD `used` tinyint(1) DEFAULT '0'

Error occured at:2007-04-03 09:48:11
Line no.:1
Error Code: 1146 - Table 'realmd_bc.site_regkeys' doesn't exist[/COLOR]

same whit navicat:22.sql
[COLOR="Red"][Err] 1146 - Table 'realmd_bc.site_regkeys' doesn't exist
[Msg] Finished - Unsuccessfully

[/COLOR]
Meaby someone could help me a bit?Sad
Find all posts by this user
04-04-2007, 08:12 PM
Post: #17
[MANGOS] Set up your Mangos Server 2.0.8 TBC with EasyPHP
Error Code: 1060 - Duplicate column name 'dbinfo'
are u applying to an empty DB.. ?

[Image: DJRavine_userbar.gif]
[Image: djr_sig.png]
[Image: thedjravine.png]
"In a world of genocide... The pacifist must take control..." - DJRavine
Visit this user's website Find all posts by this user
04-14-2007, 06:03 AM
Post: #18
[MANGOS] Set up your Mangos Server 2.0.8 TBC with EasyPHP
:bgmad: Whenever i go to open mangos.exe and realmd.exe they both close any ideas?
04-14-2007, 09:06 AM
Post: #19
[MANGOS] Set up your Mangos Server 2.0.8 TBC with EasyPHP
okay i fixed alot and its pretty good im able to login but theres one thing wrong..when i run mangos.exe it works fine until page text this is the error:

ERROR:SQL: SELECT MAX(`entry`) FROM `page_text`
ERROR:query ERROR: Table 'mangos.page_text' doesn't exist
ERROR:Error loading `page_text` table (not exist?)

if someone could help me create this file without reinstalling that would be great or if someone has an idea to reinstall that will fix this that would be good Big Grin
04-20-2007, 09:09 AM
Post: #20
[MANGOS] Set up your Mangos Server 2.0.8 TBC with EasyPHP
Hi I have a question...Why do some guards in the area that you should able to go to show as your enemys?...EX Im a gnome and the ironforge guards and the mountineer guys wanna kill me. How Do I change that?
05-11-2007, 04:53 AM
Post: #21
[MANGOS] Set up your Mangos Server 2.0.8 TBC with EasyPHP
Hello,
I have installed MaNGOS version 2.0.12 successfully with this guide, as I'm complete novice in SQL and PHP. I managed to set up the webpage too, because I really have no idea where to create new accounts with SQL. I had same errors as Kerppa while loading the scripts, but it didn't make the page unable to create accounts. Well, what my problem is - when I'm trying to log onto my server I get constantly returned to realm list instead of character list.

P.
05-11-2007, 05:46 AM
Post: #22
[MANGOS] Set up your Mangos Server 2.0.8 TBC with EasyPHP
I managed to sort that out too, now I know how to edit SQL databases ;/
But now I'm stuck at "Connected" part, and a while after I'm getting "Disconnected from server".

P.S. sorry for not editing previous post, but I didn't notice I wasn't logged on and I though I can't edit my posts (like is on some forums).

[EDIT] It is working now, I used another (I think?) repack posted by DJRavine on Emupedia.
05-14-2007, 04:13 AM
Post: #23
[MANGOS] Set up your Mangos Server 2.0.8 TBC with EasyPHP
my server worked good in a week, then i moved my computer to a friend and it worked there to but only for a few hour. i dont know what happend but people just couldnt log in. my ports was opened, i have a dynamic ip but i change it everyday. i have tried to make a new server but that didnt work

anyone knows what the problem is? please help me!
05-16-2007, 07:38 PM
Post: #24
[MANGOS] Set up your Mangos Server 2.0.8 TBC with EasyPHP
Pretzel you have a realmloop going on. Theres a guide around here on it.

Anger at lies lasts forever. Anger at truth can't last.
Greg Evans, Luann (comic), September 27, 2003
My body won't tell my mind what ive been thinking before its out of my mouth.
ITS A TRAP!
Find all posts by this user
05-20-2007, 02:55 AM
Post: #25
[MANGOS] Set up your Mangos Server 2.0.8 TBC with EasyPHP
when i try to make the web portal
i cant load sql_newtables.sql i get this error :

There was an error while executing a query.
The query and the error message has been logged at:
C.
Please click on "Open Error File..." to open the error file.


in the error file it stands like this:

Query:
ALTER TABLE `realmlist` ADD `dbinfo` VARCHAR( 255 ) NOT NULL

Error occured at:2007-05-17 22:15:00
Line no.:1
Error Code: 1060 - Duplicate column name 'dbinfo'

Query:
CREATE TABLE `zone_coordinates` (
`map` bigint(20) default NULL,
`zone_id` bigint(20) default NULL,
`name` varchar(255) default NULL,
`name_short` varchar(255) default NULL,
`x_min` float default NULL,
`x_max` float default NULL,
`y_min` float default NULL,
`y_max` float default NULL,
`priory` bigint(20) NOT NULL default '0',
PRIMARY KEY (`priory`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251

Error occured at:2007-05-17 22:15:06
Line no.:16
Error Code: 1050 - Table 'zone_coordinates' already exists

Query:
CREATE TABLE `zone_coordinates` (
`map` bigint(20) default NULL,
`zone_id` bigint(20) default NULL,
`name` varchar(255) default NULL,
`name_short` varchar(255) default NULL,
`x_min` float default NULL,
`x_max` float default NULL,
`y_min` float default NULL,
`y_max` float default NULL,
`priory` bigint(20) NOT NULL default '0',
PRIMARY KEY (`priory`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251

Error occured at:2007-05-17 22:15:14
Line no.:16
Error Code: 1050 - Table 'zone_coordinates' already exists

Query:
ALTER TABLE `realmlist` ADD `dbinfo` VARCHAR( 255 ) NOT NULL

Error occured at:2007-05-17 22:15:41
Line no.:1
Error Code: 1060 - Duplicate column name 'dbinfo'

Query:
CREATE TABLE `zone_coordinates` (
`map` bigint(20) default NULL,
`zone_id` bigint(20) default NULL,
`name` varchar(255) default NULL,
`name_short` varchar(255) default NULL,
`x_min` float default NULL,
`x_max` float default NULL,
`y_min` float default NULL,
`y_max` float default NULL,
`priory` bigint(20) NOT NULL default '0',
PRIMARY KEY (`priory`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251

Error occured at:2007-05-17 22:15:50
Line no.:52
Error Code: 1050 - Table 'zone_coordinates' already exists

Query:
ALTER TABLE `realmlist` ADD `dbinfo` VARCHAR( 255 ) NOT NULL

Error occured at:2007-05-17 22:15:56
Line no.:1
Error Code: 1060 - Duplicate column name 'dbinfo'

Query:
ALTER TABLE `realmlist` ADD `dbinfo` VARCHAR( 255 ) NOT NULL

Error occured at:2007-05-17 22:15:58
Line no.:1
Error Code: 1060 - Duplicate column name 'dbinfo'

Query:
CREATE TABLE `zone_coordinates` (
`map` bigint(20) default NULL,
`zone_id` bigint(20) default NULL,
`name` varchar(255) default NULL,
`name_short` varchar(255) default NULL,
`x_min` float default NULL,
`x_max` float default NULL,
`y_min` float default NULL,
`y_max` float default NULL,
`priory` bigint(20) NOT NULL default '0',
PRIMARY KEY (`priory`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251

Error occured at:2007-05-17 22:16:01
Line no.:16
Error Code: 1050 - Table 'zone_coordinates' already exists

Query:
CREATE TABLE `zone_coordinates` (
`map` bigint(20) default NULL,
`zone_id` bigint(20) default NULL,
`name` varchar(255) default NULL,
`name_short` varchar(255) default NULL,
`x_min` float default NULL,
`x_max` float default NULL,
`y_min` float default NULL,
`y_max` float default NULL,
`priory` bigint(20) NOT NULL default '0',
PRIMARY KEY (`priory`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251

Error occured at:2007-05-17 22:16:02
Line no.:16
Error Code: 1050 - Table 'zone_coordinates' already exists

Query:
CREATE TABLE `zone_coordinates` (
`map` bigint(20) default NULL,
`zone_id` bigint(20) default NULL,
`name` varchar(255) default NULL,
`name_short` varchar(255) default NULL,
`x_min` float default NULL,
`x_max` float default NULL,
`y_min` float default NULL,
`y_max` float default NULL,
`priory` bigint(20) NOT NULL default '0',
PRIMARY KEY (`priory`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251

Error occured at:2007-05-17 22:16:04
Line no.:16
Error Code: 1050 - Table 'zone_coordinates' already exists

Query:
ALTER TABLE `realmlist` ADD `dbinfo` VARCHAR( 255 ) NOT NULL

Error occured at:2007-05-17 22:16:32
Line no.:1
Error Code: 1060 - Duplicate column name 'dbinfo'

Query:
ALTER TABLE `item_template` ADD `unk_203` INT(10) NOT NULL default '0' AFTER `sheath`

Error occured at:2007-05-18 04:02:58
Line no.:7
Error Code: 1060 - Duplicate column name 'unk_203'

Query:
ALTER TABLE `account` ADD `tbc` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0' AFTER `online`

Error occured at:2007-05-18 04:03:10
Line no.:1
Error Code: 1060 - Duplicate column name 'tbc'

Query:
ALTER TABLE realmlist ADD `dbinfo` varchar(255) DEFAULT NULL

Error occured at:2007-05-19 18:47:39
Line no.:11
Error Code: 1060 - Duplicate column name 'dbinfo'

Query:
ALTER TABLE site_regkeys ADD `used` tinyint(1) DEFAULT '0'

Error occured at:2007-05-19 18:48:06
Line no.:1
Error Code: 1146 - Table 'realmd.site_regkeys' doesn't exist

Query:
ALTER TABLE site_regkeys ADD `used` tinyint(1) DEFAULT '0'

Error occured at:2007-05-19 18:48:39
Line no.:1
Error Code: 1146 - Table 'realmd.site_regkeys' doesn't exist

Query:
ALTER TABLE site_regkeys ADD `used` tinyint(1) DEFAULT '0'

Error occured at:2007-05-19 18:48:40
Line no.:1
Error Code: 1146 - Table 'realmd.site_regkeys' doesn't exist

Query:
ALTER TABLE site_regkeys ADD `used` tinyint(1) DEFAULT '0'

Error occured at:2007-05-19 18:48:41
Line no.:1
Error Code: 1146 - Table 'realmd.site_regkeys' doesn't exist

Query:
ALTER TABLE realmlist ADD `dbinfo` varchar(255) DEFAULT NULL

Error occured at:2007-05-19 18:50:06
Line no.:11
Error Code: 1060 - Duplicate column name 'dbinfo'

Query:
ALTER TABLE realmlist ADD `dbinfo` varchar(255) DEFAULT NULL

Error occured at:2007-05-19 18:50:10
Line no.:11
Error Code: 1060 - Duplicate column name 'dbinfo'

Query:
ALTER TABLE realmlist ADD `dbinfo` varchar(255) DEFAULT NULL

Error occured at:2007-05-19 18:52:01
Line no.:11
Error Code: 1060 - Duplicate column name 'dbinfo'

help plz!
05-27-2007, 05:58 AM
Post: #26
[MANGOS] Set up your Mangos Server 2.0.8 TBC with EasyPHP
This one is SQL_NewtablesConfused
Query:
ALTER TABLE realmlist ADD `dbinfo` varchar(255) DEFAULT NULL

Error occured at:2007-05-27 00:11:54
Line no.:11
Error Code: 1060 - Duplicate column name 'dbinfo'

Query:
ALTER TABLE realmlist ADD `dbinfo` varchar(255) DEFAULT NULL

_________________________________________________________________
And this is The update 22


Query:
ALTER TABLE site_regkeys ADD `used` tinyint(1) DEFAULT '0'

Error occured at:2007-05-27 21:42:35
Line no.:1
Error Code: 1146 - Table 'realmd.site_regkeys' doesn't exist , please help meBig Grin
Find all posts by this user
06-13-2007, 04:22 AM
Post: #27
[MANGOS] Set up your Mangos Server 2.0.8 TBC with EasyPHP
hello i am having trouble see ive done everything except the web portal which says is optional (had trouble installing web portal, the sql_newtables.sql and 22.sql gave me errors it said it couldnt find something) anyway ive installed it and im putting wow 2.0.8 on my computer now. on what wow versions will this work first wow version to 2.0.8 i assume. thats just info here is my real question how do i make an account i dont know if i have made one or not and i dont know the password how do i create an account and edit username and passwords. maybe after i get that down i can learn how to create a gm account or character idk if there are gm "accounts" but i will learn that later im just worryed about making accounts and assigning passwords/usernames thx in advance. you can email me at [email protected]
Find all posts by this user
06-13-2007, 06:39 AM
Post: #28
[MANGOS] Set up your Mangos Server 2.0.8 TBC with EasyPHP
There are many posts on creating accounts/gm accounts but here is a refresher. When mangosd.exe is running just type "create admin password" without the quotes, and of course substitute admin and password with what u want. (Ex: create admin ASDFGHJ) Now that you created it to make it a gm you type "setgm admin 4" <--1 to 4 , with 4 being the highest possible rank. You can edit them manually in SQL by using Navicat or SQLyog, again there are many posts on these subjects. As far as the web pack no clue as I dont use it, sry.
Visit this user's website Find all posts by this user
06-17-2007, 11:19 AM
Post: #29
[MANGOS] Set up your Mangos Server 2.0.8 TBC with EasyPHP
guide is correct, closed and stickied.

Death awaits you..
[Image: sigug3.jpg]
[Image: wowps_admin.gif]
Visit this user's website Find all posts by this user
Thread Closed 


[-]
Share/Bookmark (Show All)
Facebook Linkedin Technorati Twitter Digg MySpace Delicious

Possibly Related Threads...
Thread: Author Replies: Views: Last Post
  [MaNGOS] Linux Install / Compile Guide DJRavine 21 26,756 04-03-2010 10:35 PM
Last Post: robertmaverick
  make a portal for mangos Jakey 8 4,326 12-21-2009 07:53 AM
Last Post: rothmans92
  [MaNGOS] LAN + INTERNET Router Setup DJRavine 67 28,188 03-01-2009 03:08 AM
Last Post: DJRavine
  [MaNGOS] Complete Installation Guide DJRavine 32 31,786 09-26-2008 07:59 AM
Last Post: Jakey
  [MaNGOS] Source Code Documentation DJRavine 1 6,317 06-17-2007 11:53 AM
Last Post: DJRavine
  Guide to setting up a Mangos server. Ryu 11 18,807 06-17-2007 11:00 AM
Last Post: Ryu
  PDF Setup Guide for TBC MaNGOS DJRavine 1 5,735 04-03-2007 01:37 AM
Last Post: DJRavine
  [MaNGOS] Upgrade to Latest Revision DJRavine 3 11,021 02-25-2007 07:16 AM
Last Post: puddinlover

Forum Jump:


Contact Us | WoWps.org | Return to Top | Return to Content | Lite (Archive) Mode | RSS Syndication | CSS Validated!