PunKeD_GuRu

Thanks for the reply. Will give it ago soon, and leave my feedback =).

I suppose i should try n restart the pc... it has been acouple of months... Thanks for the reply thou, there wasnt any open realm windows, but it might have failed to close or something...

When i try to lauch the mangos-realmd It says: MaNGOS realmd can not bind to 192.168.0.2:3724 terminate called after throwing an instance of 'std::runtime_error' what(): Dead Reference Aborted Put original realmd.conf in, and changed DB stuff. MaNGOS realmd can not bind to 0.0.0.0:3724 terminate called after throwing an instance of 'std::runtime_error' what(): Dead Reference Aborted Seems to have happened today. Every week or so I do an update, been updaing fine for a couple of months... Running Ubuntu 8.04. Downloaded mangos today (30th june(rev 10124)) Any help would be greatly appreciated.

On the Wiki section, the Ubuntu install. 2nd requirement. 2.Your using 32-bit Ubuntu Server 8.04 / 8.10 or Debian 5.0 Does this mean that the install guide that follows it would not work on a 64Bit Ubuntu? I've run the server on win vista x64 without problems. Would like to take advantage of the servers CPU and use the 64Bit... Takes advantage of an extra 2GB memory stick i have somewhere aswel... Has anyone else setup a server on Ubuntu x64? Thanks for any feedback.

Wish i could help, also havnt got it to work. Shame really. =(

<?php /** * External Database auth plugin for phpBB3 * Based on phpbb's ldap auth plugin. * Pedro Dias - [email][email protected][/email] * [url]http://pedrodiasgeekyblog.blogspot.com/2008/11/external-database-authentication-for.html[/url] */ /* Credit goes to Pedro for posting the example on his blog. I made some changes to the script, since I was getting a connections error. The changes I made will help people who install phpbb3 into its own separate database. I can assist with some help pm acctman on phpbb3 p.s. I am not Pedro, I'm just giving him credit for his work. I modified the script to make it work better. */ /** * @ignore */ if (!defined('IN_PHPBB')) { exit; } function login_extdb(&$username, &$password) { global $db, $config, $user; if (!$password) { return array( 'status' => LOGIN_ERROR_PASSWORD, 'error_msg' => 'NO_PASSWORD_SUPPLIED', 'user_row' => array('user_id' => ANONYMOUS), ); } if (!$username) { return array( 'status' => LOGIN_ERROR_USERNAME, 'error_msg' => 'LOGIN_ERROR_USERNAME', 'user_row' => array('user_id' => ANONYMOUS), ); } //// START HERE //// change where you see FILL IN /// This is the connection for my existing member database $dbhost1 = 'localhost'; $dbuser1 = 'FILL IN'; //this is the mysql login for your existing member db $dbpass1 = 'FILL IN'; $dbname1 = 'FILL IN'; $conn = mysql_connect($dbhost1, $dbuser1, $dbpass1) or die ('Error connecting to mysql'); mysql_select_db($dbname1); // We need to select the required fields, check you member table and write down the // following USERNAME, PASSWORD, EMAIL field names. Example my existing member fields are called // m_user, m_pass and m_email yours will be different. If you're lazy you can also do a SELECT * // I would replace with SELECT m_user, m_pass, m_email // This is how my query looks: // $query = "SELECT m_user,m_pass,m_email FROM rate_members WHERE m_user = '".$username."'"; $query = "SELECT * FROM FILL_IN_MEMBER-TABLE WHERE FILL_IN_USERNAME_FIELD = '".$username."'"; $result = mysql_query($query); $num_rows = mysql_num_rows($result); if($num_rows == 1){ $row = mysql_fetch_array($result, MYSQL_ASSOC); $extuser = $row['FILL IN']; //user field from existing db member table $extpass = $row['FILL IN']; //pass field from existing db member table $extmail = $row['FILL IN']; //email field from existing db member table } if ($num_rows == 1) { if (strcmp($extuser,$username) == 0 && strcmp($extpass,md5($password)) == 0) { /// This is the connection for phpBB3's database. The next 6 lines can be removed only if you've installed phpBB3 into you existing site db. /// I decided to keep things separate to make it easier to backup/restore. $dbhost = 'localhost'; $dbuser = 'FILL IN'; // you can get the info from the config.php file in your forum root $dbpass = 'FILL IN'; $dbname = 'FILL IN'; //// END HERE //// you do not have to change anything else for the script to work $conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to mysql'); mysql_select_db($dbname); $sql ='SELECT user_id, username, user_password, user_passchg, user_email, user_type FROM phpbb_users' . " WHERE username_clean = '" . $db->sql_escape(utf8_clean_string($username)) . "'"; $result = $db->sql_query($sql); $row = $db->sql_fetchrow($result); $db->sql_freeresult($result); if ($row) { if ($row['user_type'] == USER_INACTIVE || $row['user_type'] == USER_IGNORE) { return array( 'status' => LOGIN_ERROR_ACTIVE, 'error_msg' => 'ACTIVE_ERROR', 'user_row' => $row, ); } return array( 'status' => LOGIN_SUCCESS, 'error_msg' => false, 'user_row' => $row, ); } else { $sql = 'SELECT group_id FROM ' . GROUPS_TABLE . " WHERE group_name = '" . $db->sql_escape('REGISTERED') . "' AND group_type = " . GROUP_SPECIAL; $result = $db->sql_query($sql); $row = $db->sql_fetchrow($result); $db->sql_freeresult($result); if (!$row) { trigger_error('NO_GROUP'); } $extdb_user_row = array( 'username' => $username, 'user_password' => phpbb_hash($password), 'user_email' => $extmail, 'group_id' => (int) $row['group_id'], 'user_type' => USER_NORMAL, 'user_ip' => $user->ip, ); return array( 'status' => LOGIN_SUCCESS_CREATE_PROFILE, 'error_msg' => false, 'user_row' => $extdb_user_row, ); } } else { return array( 'status' => LOGIN_ERROR_PASSWORD, 'error_msg' => 'LOGIN_ERROR_PASSWORD', 'user_row' => array('user_id' => ANONYMOUS), ); } } return array( 'status' => LOGIN_ERROR_USERNAME, 'error_msg' => 'LOGIN_ERROR_USERNAME', 'user_row' => array('user_id' => ANONYMOUS), ); } ?> and for the SHA1 passwords: <?php /** * External MySQL auth plug-in for phpBB3 * * Authentication plug-ins is largely down to Sergey Kanareykin, our thanks to him. * * @package login * @version $Id: auth_dbext.php 8602 2009-04-09 16:38:27Z nzeyimana $ * @copyright NONE: use as you see fit but no guarantees * @license NONE: use as you see fit but no guarantees * */ /** * @ignore */ if (!defined('IN_PHPBB')) { exit; } /** * * @return boolean|string false if the user is identified and else an error message */ function init_dbext() { // TODO: do any needed initialization } /** * Login function */ function login_dbext(&$username, &$password) { global $db; // do not allow empty password if (!$password) { return array( 'status' => LOGIN_ERROR_PASSWORD, 'error_msg' => 'NO_PASSWORD_SUPPLIED', 'user_row' => array('user_id' => ANONYMOUS), ); } if (!$username) { return array( 'status' => LOGIN_ERROR_USERNAME, 'error_msg' => 'LOGIN_ERROR_USERNAME', 'user_row' => array('user_id' => ANONYMOUS), ); } ///////////////////////////////////////////////////////////////////////////////////////////////////////////// // Note: on my systems, I include these following lines from an external file that is not web-accessible ///////////////////////////////////////////////////////////////////////////////////////////////////////////// $db_host = "localhost"; // Here goes the MySQL server address, hostname or IP $db_user = "username"; // Here goes the MySQL user allowed to read the table below (GRANT SELECT ON ....) $db_password = "passwd"; // Here should go the password associated with the above user $db_database = "dbName"; // Here goes the Database containing the table below $db_table = "tblUsers"; // Here will goes the table list users allowed to login into PHPBB //////////////////////////////////////////////////////////////////////////////////////////////////////////// $col_username = "username"; $col_password = "password"; $hashMethod = "sha1"; // Can be one of: md5, sha1, plain // In case you choose to use a non-standard hashing function, be // sure to change below where the $hashedPassword variable is created $objMySqli = new mysqli($db_host, $db_user, $db_password, $db_database); /* check connection */ if (mysqli_connect_errno()) { return array( 'status' => LOGIN_ERROR_EXTERNAL_AUTH , 'error_msg' => 'LOGIN_ERROR_EXTERNAL_AUTH ', 'user_row' => array('user_id' => ANONYMOUS), ); } // Check the User/Password if($hashMethod == 'sha1') { $hashedPassword = sha1($password); } elseif($hashMethod == 'md5') { $hashedPassword = md5($password); } else { $hashedPassword = $password; } $sql = "SELECT 11 as ID FROM " . $db_table . " WHERE " . $col_username . " = '" . mysqli_real_escape_string($username) . "' AND " . $col_password . " = '" . mysqli_real_escape_string($hashedPassword) . "' "; if ( $result = $objMySqli->query($sql) ) { if ( $result->num_rows <= 0 ) { return array( 'status' => LOGIN_ERROR_USERNAME, 'error_msg' => 'LOGIN_ERROR_USERNAME', 'user_row' => array('user_id' => ANONYMOUS), ); } $sql = 'SELECT user_id, username, user_password, user_passchg, user_email, user_type FROM ' . USERS_TABLE . " WHERE username = '" . $db->sql_escape($username) . "'"; $result = $db->sql_query($sql); $row = $db->sql_fetchrow($result); $db->sql_freeresult($result); if ($row) { // User inactive... if ($row['user_type'] == USER_INACTIVE || $row['user_type'] == USER_IGNORE) { return array( 'status' => LOGIN_ERROR_ACTIVE, 'error_msg' => 'ACTIVE_ERROR', 'user_row' => $row, ); } // Successful login... return array( 'status' => LOGIN_SUCCESS, 'error_msg' => false, 'user_row' => $row, ); } // this is the user's first login so create an empty profile return array( 'status' => LOGIN_SUCCESS_CREATE_PROFILE, 'error_msg' => false, 'user_row' => user_row_dbext($username, sha1($password)), ); } else { // TODO: Handle this situation } // Not logged in using the external DB return array( 'status' => LOGIN_ERROR_EXTERNAL_AUTH, 'error_msg' => 'LOGIN_ERROR_EXTERNAL_AUTH', 'user_row' => array('user_id' => ANONYMOUS), ); } /** * This function generates an array which can be passed to the user_add function in order to create a user */ function user_row_dbext($username, $password) { global $db, $config, $user; // first retrieve default group id $sql = 'SELECT group_id FROM ' . GROUPS_TABLE . " WHERE group_name = '" . $db->sql_escape('REGISTERED') . "' AND group_type = " . GROUP_SPECIAL; $result = $db->sql_query($sql); $row = $db->sql_fetchrow($result); $db->sql_freeresult($result); if (!$row) { trigger_error('NO_GROUP'); } // generate user account data return array( 'username' => $username, 'user_password' => phpbb_hash($password), // Note: on my side, I don't use this because I want all passwords to remain on the remote system 'user_email' => '', // You can retrieve this Email at the time the user is authenticated from the external table 'group_id' => (int) $row['group_id'], 'user_type' => USER_NORMAL, 'user_ip' => $user->ip, ); } ?>

Id love to know how to do this aswel! I have a phpbb3 forum setup on the same server along with file sharing just so all the uni folks have access to my movies/music/a forum to request/and a forum for bugs on the wow server currently i create each account manually as the mmfm seems to have stopped updating and im not good enough at this kinda stuff to do it myself =( if someone was to share how they have theirs i could prob smooth of some corners on it! =)

U host multiple realm databases? seems like a waste unless u have seperate logins for each realm.

this is behind a a router, pretty much one sided. having the database port forwarded can be a high security risk. however if ur using the standard MySQL setup simply forward port 3306. (this is fo MySQL)

generally if the patch is worth it... its likely that mangos will pick it up and accept it... that or the patch still needs some work

linage, guildwars... a few other games use the same sorta systems of a C++ app + MySQL's etc But mangos is very specific to the current wow client... yourd be better of creating from stratch, rather than trying to modify the mangos core into a diff game.

u cant forward the same port to 2 computers behind 1 IP so 1 router, 2 LAN IP's same port cannot be forwarded to both. Mangos servers only require 2 ports to be forwarded, 3724 and 8085* *Unless you have selected custom ports, in which case simply forward those ports. im not familiar atall with trinity. I hosted 2 realms my server had the login and a realm my desktop had another realm. behind 1 router, which friends where able to connect to both realms without problems simply by having 8086 forwarded for the second realm.

yeah, simply have the realmd database accessable to both servers this allows multiple computers (part of the thread title)

within the mangos code there is a line that checks the DB versions... this code will make sure that you have a certain game client this code needs to be removed. You should have said you wanted to run different clients not i want to run classic wow, tbc and wotlk 3.x can still be run as "classic wow" if both expansions are disabled (expansion = 0 )

and ofcourse your not ment to be using mangos to host private servers. If you want a perfect running server, keep with 2.4.3 for now. But majority of stuff on 3.x is sorted, few pieces here n there but it can all be easily fixed with updates that come very regularly from the awesome mangos dev's =)

pay attention! you can use the same "mangos" database. Each realm is configured by the mangos.conf file for what game it takes!

Yes. Each realm is controlled by its own mangos.conf file. Therefor each realm can be of different rates, different settings, different language... and different expansion. Unless u know how to change the C++ coding to check... then you must have only 1 client version (currently 3.0.9)

first tip: remove the "Blizzard" logo's.... thats a pretty big no no... =/ other than that... is this just a standard forum, with a wow theme... coz atm thats all im seeing really nice work thou, graphically looks nice =) but again, wouldnt keep the blizzard logo's on there... i doubt very much they allowed you the rights to use theirs!

rather than creating something from complete scratch jump on the minimanager project.... they seem to have a fairly good one going always needs tweaks but its generally kept well

these are all simply guides.... so far every guide on this site is missing information which people need to read between the lines i kinda think it was dumbbed down enough as it is so i dont plan to dumb it down anymore... some things people need to learn... dont get me wrong, it slipped my knowledge the first time of merging... but yeah... mangos is a learning project.... not just a follow the dumbass guide to host ur own server.

if you fetch and merge, master isnt listed... this means u have the latest head revision.

this was done for GIT GUI... not bash's this is how to use the master, and get master... if you have master, and you try to get a different branch you need to create a seperate repository etc.. thats explained in the GIT section of the fourm

mangos is designed to be a good solid server not so much about having new features u dont see already but i have been looking into something similiar for some time! myself and a couple of others are looking at games like "EVE Online" these games are huge MMORPG's etc but alot of the game could be implemented web based several websites like InstantAction.c and quakelive.c also have web based exeecutables, using active x... id like to be able to create something that allows you to play parts of the game web based, and other parts using the actual client eve online is a good example because the whole marketplace, along with skill training etc, building ur ship, bla bla bla could easily be done web based rather than using the client alot of the similiar programing only varying form the actual game itself is different but im limited to my own head, and dont really know much about these websites that have active x web based executables such as IA and QL =/

not completly sure, but i believe that MiniManager has an item giving function built into it Maybe have alook at their code.

i have hosted realms on mates pc's that dont reach the minimum requirements for windows xp (SP2)... and they have run servers with a couple of mates attached.... If the server is empty, it doesnt take up much resources atall.... compiling the server takes awhiel on lower spec'd pc's. but just wait i suppose =/ same with the begining bit of loading the server up... takes "awhile" with lower spec'd pc's. I think you need some kind of "Milestone" requirements so for 10 people to join a server 100 people... 200... etc varied by vmaps aswel. another biggie is peoples upload speeds... for the people that get a dedicated line etc, not so bad and for the people on LANs like mine that are 10/100/1000... the 1000 really helps on the university network here: 1 pc... Windows Vista x64 SP1. Running in performance mode, with all visual effects disabled etc. also running for background program performance. 4 x 2gb DDRII 800Mhz Ram (Dual Channeled) Primary HDD: SataII 250gb Maxtor, (nothing fancy like raptors) Secondary HDD: SataII 1Tb Maxtor (this stores loads of videos etc, which are also shared across the network) Third HDD: SataII 1Tb Maxtor (stores music etc...) Network: Onboard connects to the Uni network using a 10/100/1000 Cat-5 Cable... (Uni network is pretty immense) PCI - 10/100/1000 Cat-6 direct to my pc... I update mangos 2-4 times a week i also run SD2, and minimanager website. its rare for more than 200 students to attempt to get on... but ive never seen the latency peek 40 for anyone. (and the person to have 40 was coz she was also downloading some other stuff neway. I admire your effort in doing this, but you will struggle as it varies on so many different variables.