Dyspro

lol si myslis naco je pvp server ?? aby sa mohlo zabijat lolo na oficiale to je tak.. nemas sancu sa skontaktovat s ali... si sprav normal server ked take nieco chces lolec

njn srry

http://emupedia.com/forums/showthread.php?t=2016 , treba sa tam registrovat preto som tu nedaval odkaz na forum ale len veci napisane tam

nn ja som to neskusal ja som len cital a nasiel som nieco nasiel som nieco o characteroch neviem co vam to pomoze http://wowguilds.be/upload/characters.sql mno niekto na nejakom fore napisal toto : CREATE TABLE `characters` ( `guid` bigint(20) unsigned NOT NULL default '0', `acct` bigint(20) unsigned NOT NULL default '0', `data` longtext NOT NULL, `indepData` longtext NOT NULL, `name` varchar(21) NOT NULL default '', `level` int(10) unsigned NOT NULL default '0', `class` int(10) unsigned NOT NULL default '0', `race` int(10) unsigned NOT NULL default '0', `positionX` float NOT NULL default '0', `positionY` float NOT NULL default '0', `positionZ` float NOT NULL default '0', `mapId` int(10) unsigned NOT NULL default '0', `zoneId` int(10) unsigned NOT NULL default '0', `orientation` float NOT NULL default '0', `taximask` longtext NOT NULL, `outfit` longtext NOT NULL, `reputation` float NOT NULL default '0', `skills` longtext NOT NULL, `taxiX` float NOT NULL default '0', `taxiY` float NOT NULL default '0', `taxiZ` float NOT NULL default '0', `unlearn_count` int(11) NOT NULL default '0', `transportGuid` bigint(32) unsigned NOT NULL default '0', `stableSlots` tinyint(4) unsigned NOT NULL default '0', `enumFlag` int(10) unsigned NOT NULL default '0', `resurrectionLoc` text NOT NULL, `instanceId` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`guid`) ) ENGINE=MyISAM DEFAULT CHARSET=iso-8859-2; Use that, it 100% works.

njn to bolo aj pre ostatnych ktory nevedia ako na to

no takze sem hadzem navod ktory som nasiel na internete keby niekto nahodou nevedel ako na to How to install (by finalzero) Installation Guide: (version 0.1) 1. Run the Kobold setup program (nothing more to it) 2. Tell the install where you want to install the game server e.g. C:\Kobold 3. Once setup has finished you need to perform serveral tasks: * Make sure you are using client 1.12.1 (the latest version of wow) - I am not 100% sure if this is a requirement however the client worked fine for me * Perform the post install tasks: * Go to the Kobold root folder and into the folder labeled Tools * Copy the file MapExtractor.exe into your wow client folder * Go to your client folder and create a new folder in there called maps * double-click MapExtractor.exe and wait for it to finish extracting the maps * When finished, move the mps folder into your Kobold server's root (where the readme.txt file is) * Go into the Tools folder again and double-click the file named DBCextractor.exe - when prompted extract the contents into the \KoboldServerLite\WS\ folder in the Kobold server directory o go to the above folder and edit the file ExtractDBC.bat o Modify the line set WoWdir=<your_wow_client>r\Data\ to point to your client's data foler e.g. C:\Program Files\World of Warcraft\Data o Save the file and then double-click to run it, make sure there are no errors 4. Now you need to setup the database, I will use Navicat as my example as thats what most people on this board seem to use. * Start Navicat and then create a new database (if you don't know how to do this, go to Google and search for Navicat creating a new database o Make sure the database format is utf-8 and call the database kobold * Now before you import the sql file you need to fix it as it has a bug (probably more but not found them yet): o Open up the file wow_server.sql using a text editor like conTEXT, don't try using Windows notepad as it can't handle the size of the sql file and will just crash + Locate the following line: `reputation` text NOT NULL (line number 325) and change it to the following: # Code: `reputation` text NOT NULL default '', + Save the SQL file * Now go to Navicat and select your database called kobold * right-click the database and choose Execute Batch File.. * When prompted locate the wow_server.sql file and run it * Confirm there were no errors 5. Okay now you need to edit two tables in the database so in Navicat double-click your database kobold to display the list of tables in the right hand side of the program. * Find the table called accounts and double-click it to open it o change the username and password to whatever you want it to be and then click on the small tick icon to save the changes and then close that edit window * There is another table to edit but we cannot do that until we have the kobold server running (step 6) 6. Now we need to setup the game server so it will run correctly and connect to the MySQL database to populate it with the initial settings. * Go to the kobold root folder and then into the folder called LS and then into the folder called conf * Open the file first config file called login_server.conf and edit the values as follows: * Code: LoginServerListenIp = <your_server_lan_address> #change this to your server's LAN ip address LoginServerPort = 3724 DefaultRealmName = Kobold Test Realm # leave it as is or change it to whatever you want to call your realm DefaultRealmAddr = <your_server_lan_address> # again change to your servers LAN ip address DefaultRealmPort = 3725 DefaultRealmType = "Normal" * Save the file and then open the sql.conf and edit as follows: * Code: DatabaseName = kobold DatabaseHost = localhost DatabasePort = 3306 DatabaseUser = <your_database_server's_root_id> DatabasePassword = <your_database_server's_root_password> * save the file and then go back to the root kobold folder 6.1 You need to perform the above steps two the conf files in the RS folder and the WS folder (e.g. \RS\conf\realm_server.conf) * DO NOT SIMPLY CUT AND PASTE THE ABOVE LIKE AN IDIOT, ACTUALLY OPEN EACH FILE AND EDIT THE RELEVANT SETTINGS AS EACH FILE IS SLIGHTLY DIFFERENT * 7. Now you need to fire up the server initially to get the database populated with some values. Start the server in the following order: * double-click WS_Server_Alive.bat (wait until it has loaded fully) * double-click RS_Server_Alive.bat * double-clickLS_Server_Alive.bat 8. Once the server has loaded up fully, the login server screen will say "Ready to accept connections" or something similar. You need to close down each window as we need to shutdown the game server now 9. Start Navicat again and do the following: * Locate the table realm_list and double-click to edit the data * change the filed address to whatever you have your server LAN ip as (e.g. 192.168.0.1) * Save the changes by clicking on the small tick icon and close the edit window 10. Finally you can restart the server in the order shown above to confirm it is able to connect to the database and everything is okay (takes about 3 minutes to load up fully) 11. You now need to edit your realmlist.wtf file in your client folder to point it to your local server. * Go to the client folder and edit the file realmlist.wtf and then change the line set realm list to point to your kobold server e.g. set realmlist mylocalserver 12. You also need to make sure Windows knows about your server, we need to edit the hosts file to do this. * start Windows Notepad and open the file hosts located in C:\windows\system32\drivers\etc\ * Add a new line at the end to look something like: * Code: <your_server_lan_address> <mylocalserver> e.g. Code: 192.168.0.1 kobold.localserver.com * Save the file an then exit Notepad 13. Okay if you have got this far and had no problems then you are ready to log into the game world. * Start your wow client and then log in with the username and password you put in the database (Step 5) * If all is well you should get prompted to choose your realm and then you can create a new character ----------- Thats it really, seems two files are missing that would let you import the game world (or I just haven't tested the import feature properly). Also there is an error during the startup of the WS_Server_Alive.bat script however as I mentioned earlier I have no idea what it relates to. If the author(s) of Kobold could be kind enough to post some feedback on this forum it would be greatly appreciated as its useless to post a release and then disappear without replying to comments. Appendix: a. Obtaining your servers IP address: * click on START > Run.. > type cmd to start the Windows Command Prompt * Type ipconfig /all to display your servers ip address o locate the line that says host name to get your servers hostname o locate the line ip address to locate the lan address of your server Revisions: 0.2 - Missed out a database setup step: * Open Navicat and find the table worldserver_list * change the field IP to your servers LAN ip address and save the record (click on the tick icon) and close the edit window ---------------------------------------------------------------------------------------------------------------- Common problems and fixes: 1. Unable to connect This happens allot with this server, just try logging in again until it realizes your client is there. 2. Realm is showing as off-line This also seems to happen until you actually manage to get on and create a character. While the server is on and your client is at the login screen, open up Navicat * locate the table realm_list and open it up * in the field status change the value to 1 and save (click the tick icon) the settings and close the edit window ---------------------------------------------------------------------------------------------------------------- Hope that helps you peeps. btw don't bother asking my anything about the steps as I really don't have time to sit on this forum and reply to every request for help. All the answers you need are on this forum, just need to learn how to use the Search button at the top of this forum Adios, Fz * EDIT: Make sure this line is correct: Code: `reputation` text NOT NULL default '', The '' are two single quotes i.e. ' otherwise you will have problems. This is not my guide! I saw it in ragezone so i decided to copy it here