AHHHH! i can connect to the server which is running on my pc but other people can log in but realm says off line and its status in the mysql is stet to 3 can someone explain plz . n00b i kno.! lol
Printable View
AHHHH! i can connect to the server which is running on my pc but other people can log in but realm says off line and its status in the mysql is stet to 3 can someone explain plz . n00b i kno.! lol
ok ...i did what said in the guide acctualy i check it alot of times to see if i'm getting it right i didn't missed a part but the stupid Ws wont load successfuly it just scrools an The system can't find the path specified. where did i go wrong :(
nevermind i did it ... the dbc and maps were corupted like so ... wich client do i have to use to log in ?
the latest 1.12.1 client works fine
i use 1.12.0 now i will update it ...
Ok, i have a big problem, and i don't think is from bad sql files or such things, the first thign i did was i installed like 2 weeks ago an MySQL 5.0xxx server and succesfully made Mangos 2356 Work, a few days ago i got our "Kobold" emulator, and i did exactly like it was writt4en here on the forum, but when i got to the "IMPORT BATCH FILE wow_server.sql" i got the following erro(and i modified it):Code:Query:
UPDATE creature_template SET trainer_type = 2 WHERE entry = 5177
Error occured at:2006-10-10 13:10:49
Line no.:11
Error Code: 1046 - No database selected
Query:
UPDATE creature_template SET trainer_type = 2 WHERE entry = 5177
Error occured at:2006-10-10 13:11:44
Line no.:11
Error Code: 1146 - Table 'kobold.creature_template' doesn't exist
Query:
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` text NOT NULL default,
`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=latin1
Error occured at:2006-10-10 13:13:58
Line no.:337
Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '
`skills` longtext NOT NULL,
`taxiX` float NOT NULL default '0',
`taxiY` float N' at line 18
Query:
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` text NOT NULL default,
`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=latin1
Error occured at:2006-10-10 13:14:58
Line no.:337
Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '
`skills` longtext NOT NULL,
`taxiX` float NOT NULL default '0',
`taxiY` float N' at line 18
Query:
CREATE TABLE `account_sessions` (
`account_id` int(10) unsigned NOT NULL default '0',
`ip` varchar(15) NOT NULL default '',
PRIMARY KEY (`account_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1
Error occured at:2006-10-10 13:15:49
Line no.:18
Error Code: 1050 - Table 'account_sessions' already exists
Query:
CREATE TABLE `account_sessions` (
`account_id` int(10) unsigned NOT NULL default '0',
`ip` varchar(15) NOT NULL default '',
PRIMARY KEY (`account_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1
Error occured at:2006-10-10 13:17:49
Line no.:18
Error Code: 1050 - Table 'account_sessions' already exists
Query:
CREATE TABLE `account_sessions` (
`account_id` int(10) unsigned NOT NULL default '0',
`ip` varchar(15) NOT NULL default '',
PRIMARY KEY (`account_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1
Error occured at:2006-10-10 13:18:29
Line no.:18
Error Code: 1050 - Table 'account_sessions' already exists
Query:
CREATE TABLE `account_sessions` (
`account_id` int(10) unsigned NOT NULL default '0',
`ip` varchar(15) NOT NULL default '',
PRIMARY KEY (`account_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1
Error occured at:2006-10-10 18:27:25
Line no.:18
Error Code: 1046 - No database selected
Query:
INSERT INTO creature_equip VALUES(1,6,2,5010,285346306)
Error occured at:2006-10-10 18:28:27
Line no.:1
Error Code: 1046 - No database selected
Query:
INSERT INTO creature_equip VALUES(1,6,2,5010,285346306)
Error occured at:2006-10-10 18:29:46
Line no.:1
Error Code: 1046 - No database selected
Query:
INSERT INTO sell_templ VALUES(1,54,2488)
Error occured at:2006-10-10 18:30:00
Line no.:1
Error Code: 1046 - No database selected
Query:
INSERT INTO sell_templ VALUES(1,54,2488)
Error occured at:2006-10-10 18:31:36
Line no.:1
Error Code: 1046 - No database selected
Query:
INSERT INTO creatures_loot VALUES(1,3,10316,0.03)
Error occured at:2006-10-10 18:33:19
Line no.:1
Error Code: 1046 - No database selected
Query:
CREATE TABLE `account_sessions` (
`account_id` int(10) unsigned NOT NULL default '0',
`ip` varchar(15) NOT NULL default '',
PRIMARY KEY (`account_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1
Error occured at:2006-10-10 18:40:35
Line no.:18
Error Code: 1046 - No database selected
Query:
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` text NOT NULL default,
`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=latin1
Error occured at:2006-10-10 18:42:34
Line no.:337
Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '
`skills` longtext NOT NULL,
`taxiX` float NOT NULL default '0',
`taxiY` float N' at line 18
Query:
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` text NOT NULL default,
`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=latin1
Error occured at:2006-10-10 18:43:19
Line no.:337
Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '
`skills` longtext NOT NULL,
`taxiX` float NOT NULL default '0',
`taxiY` float N' at line 18
Query:
CREATE TABLE `account_sessions` (
`account_id` int(10) unsigned NOT NULL default '0',
`ip` varchar(15) NOT NULL default '',
PRIMARY KEY (`account_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1
Error occured at:2006-10-10 18:45:10
Line no.:18
Error Code: 1050 - Table 'account_sessions' already exists
Query:
CREATE TABLE `account_sessions` (
`account_id` int(10) unsigned NOT NULL default '0',
`ip` varchar(15) NOT NULL default '',
PRIMARY KEY (`account_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1
Error occured at:2006-10-11 10:57:22
Line no.:18
Error Code: 1046 - No database selected
ANd from then on, even if i deleted the MySQL server and all his traces from the registry and reinstalled it like XX times and tried with other SQL files, even the mangos SQL files in completely different databases AND I GET THE SAME ERROR, the code wich i pasted upper is from the wow_server.sql and when i try to import ay batch file i get the error from that file...... :((. Does anyoen have any solution/???? i need help...
well would say your problem is most likely eatherQuote:
Originally Posted by r3b3l10u5
You didn't create a account with rights in Mysql for access to the database or
your conf files are wrong / also make sure you did NOT Cut and paste the conf file for SQL.config where in giving access it says:
DatabaseName = wow_server
DatabaseHost =
DatabasePort = 3306
DatabaseUser =
DatabasePassword =
each servers is diffrent and any cutting and pasting of them seems to mess up the servers
Also just noticed this as I was typing check your characterset I see yours reads ENGINE=MyISAM DEFAULT CHARSET=latin1
When I look at my config I have DatabaseCharSet = utf8 its located in your conf folder for sql.conf in each of your servers just a idea.
I have sucessfully install kobold on my machine, but more than half of the world is empty, also wrong spawned mobs eg: wolf in tedrassil instead of nightsaber?? can anyone recommend the best world.save? this emu looks promising, but need a little more improvement. I also found that the weapon skills did not increase when using Gm command to levelup, i mean level 60 should have max skill of 300 right? but it still show max skill of 10 or whatever your previous level is. Thank in advance:juggle:
Devicean, i am have on my sql server FULL RIGHT, i am the root :))and i set it up to UTF8, do i need to modify something else in wow_server.sql other that that NOT NULL DEFAULT sh1t/?? but the thing is that now after reinstallign the server not even the mangos files aren t installed i get that wow server error...even i try to import a new batch file in a completely new database ////////how the hell cn be such a thing?
EDIT: vadumee, u can get with gm commands to lvl 60, but if u don t use gm commands to increase your skill too, u re liek a fresh lvl 60 baby with your lvl 1 skill :), i think the command is .learnsk [skillID] [skill value]
EDIT2: or u can use .maxskills and all your primary skills(e.g. swords axes etc....) are maxed /....
I GOT IT, LOL i thought that the charset should be modified only from database options, but i modified it in the SQL file too :))) HURRAAAAAAAAAAAAA
Nice, I really like the AI in this release. Played for an hour or so, and it seems that ( unless am mistaken ) mobs don't run through walls anymore, I was in the Echoridge Mine at Northshire Valley killing Kobold Labourers, worked my way up the balconey thing in the mine that overlooks a small room I noticed standing directly below me ( like a couple feet ) was a level 11 kobold geomancer, normally on any other server I have played I have learned to expect to see that geomancer come flying up through the floor to smack me around, but didn't want to on this one.
Setup guide was super easy to follow, made setting up the server take hardly anytime at all. I got it running on my first attempt.
nice job
ok, i've made it with the sql database, i followed al the steps in the 0.3 guide with the WS RL LS modifying and i didn t paste anything, i am able to read :D,and when i "fire up the server" i get the following error, that i have an error on line 1 or 16 in world_server.conf, although i can t see any error typing there. look at the next phot, masterm what do you say about that :d
YAP i found it out, it has smt to do with the MOTD
I am guessing you have an apostrophy in there between the quotes somewhere.
so if your typing something like "Kobold's WoW server"
you have to lose the apostrophy between the "D" and the "S" so it says
"Kobolds WoW server"
or whatever you were going to name it :P
good luck
RE: the AI
do any the mobs cast spells?
if u have trouble getting the char to be createt use this and build the DB just tried it and it works.
now im just having trouble getting the .import wo
and .import gameobj to work, im just getting the error can't open creature spawn list.
-- ----------------------------
-- Table structure for characters
-- ----------------------------
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` text NULL,
`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=latin1;
Great Emu!
I put it online, but I'm having problems with trainers, in the emu load it says 0 trainers loaded.
Can anyone gave an idea how to fix it? It seems to be in tables in database, but what exacly I have to change?
Because it is emu without spawns and gameobjects in database!
So you cant unless you convert wowemu spawns to this!
I have yet to find an official Kobold/Ludmilla server website anywere. Are they planning on charging money for this in the future since it's not open source? Is there a community underways in creating a better spawn base for just Kobold type servers? Do you have a link?
every time i try to start server is says
please helpQuote:
The system cannot find the path specified.
-------------------------------------------------------------------------
= ZOMG Kobold LOL ver. 1.462.5875-win32 Public Limited - Logon Server
= Press Ctrl-C anytime after initialization to safely close server.
= LIMITED PUBLIC VERSION
-------------------------------------------------------------------------
11 17:35:04 V Log: Initialization...
11 17:35:05 V Config: File logging[ENABLED]
11 17:35:05 I Log: Started
11 17:35:05 I ClientUpdate: Loading available patches...
11 17:35:05 I ClientUpdate: directory 'clientupdate' contains 0 update(s)
11 17:35:05 E Config: Please set DatabaseHost option in conf file.
11 17:35:05 E Config: Please set DatabaseUser option in conf file.
11 17:35:05 E Config: Please set DatabasePassword option in conf file.
11 17:35:05 I Log: Stoped
WoW Server Restarted 17:35 ed 10/11/2006
The system cannot find the path specified.
u have to set it up so it can connect to ur mysql server
WS conf file
###############################################################################
#
# SQL Database Client Configuration file
#
# Contains: Login and password to access SQL server with all game data
#
###############################################################################
# MySQL connection information - REQUIRED
# DatabaseName, DatabaseHost, DatabasePort(3306 default), DatabaseUser, DatabasePassword
DatabaseName = kobold
DatabaseHost = localhost
DatabasePort = 3306
DatabaseUser = root
DatabasePassword = <--- ur sql password here
# Options (uncomment and set options if necessary):
#DatabaseCharSet = utf8
#DatabaseCompress = yes
# MySQL connection information Account - REQUIRED
# AccountDBName, AccountDBHost, AccountDBPort(3306 default), AccountDBUser, AccountDBPassword
AccountDBName = kobold
AccountDBHost = localhost
AccountDBPort = 3306
AccountDBUser = root
AccountDBPassword = <--- ur sql password here
# Options (uncomment and set options if necessary):
#AccountDBCharSet = utf8
#AccountDBCompress = yes
#--- END ---
RS conf file
###############################################################################
#
# SQL Database Client Configuration file
#
# Contains: Login and password to access SQL server with all game data
#
###############################################################################
# MySQL connection information - REQUIRED
# DatabaseName, DatabaseHost, DatabasePort(3306 default), DatabaseUser, DatabasePassword
DatabaseName = kobold
DatabaseHost = localhost
DatabasePort = 3306
DatabaseUser = root
DatabasePassword = <--- ur sql password here
# Options (uncomment and set options if necessary):
#DatabaseCharSet = utf8
#DatabaseCompress = yes
# MySQL connection information Account - REQUIRED
# AccountDBName, AccountDBHost, AccountDBPort(3306 default), AccountDBUser, AccountDBPassword
AccountDBName = kobold
AccountDBHost = localhost
AccountDBPort = 3306
AccountDBUser = root
AccountDBPassword = <--- ur sql password here
# Options (uncomment and set options if necessary):
#AccountDBCharSet = utf8
#AccountDBCompress = yes
#--- END ---
LS conf file
###############################################################################
#
# SQL Database Client Configuration file
#
# Contains: Login and password to access SQL server with all game data
#
###############################################################################
# MySQL connection information - REQUIRED
# DatabaseName, DatabaseHost, DatabasePort(3306 default), DatabaseUser, DatabasePassword
DatabaseName = kobold
DatabaseHost = localhost
DatabasePort = 3306
DatabaseUser = root
DatabasePassword = <--- ur sql password here
# Options (uncomment and set options if necessary):
#DatabaseCharSet = utf8
#DatabaseCompress = yes
#--- END ---
or u could just follow this guide from another post that ive found.
i have edited it a bit so it will work.
Okay I am going to attempt to write up a quick guide to getting Kobold working however some steps require making changes to the SQL database so if your not sure about this don't try it as you make end up making a mess of the database.
Hopefully this guide will be detailed enough to help you setup your Kobold server. I would like to point out that my tests were unsuccessful as I was able to enter the game world however due to two files missing from the pack I could not proceed any further with the testing. Also the server produced several errors which I am assuming are bugs in the python scripts however as I have no python knowledge I have not attempted to trace the cause of the errors.
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. [b]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 NULL,
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
0.3 - Added final setup steps (Thanks to Devincean for the info):
Server is supplied with empty World in MySQL, to import it from world_spawns.txt and world_gameobj.txt
enter the Game through WoW client onto your Server. Being GM, use GM command:
.import wo
to import World creatures, and then:
.import gameobj
to import Gameobjects
For reference to supported GM commands type:
.commands
5) Restart server after World is imported.
6) Have fun !
2006, Kobol Team.
Now to do this here are the steps:
1) go to your tools folder [KoboldServerLite\Tools]
2) copy the WoWEmuSCPtoSQLConverter.exe
3) Use any other emu for instance lets say UWC 1.3.x
4) paste WoWEmuSCPtoSQLConverter.exe in the scripts folder [uwc1.4.3/scripts]
5) then go to the saves folder in the uwc and copy the world.save [uwc1.3.4/saves]
6) paste the world.save in your scripts folder [uwc1.4.3/scripts]
7) execute the WoWEmuSCPtoSQLConverter.exe.
[NOTE: This will create a folder sql with .txt files in it]
8) open the sql folder and copy all the contents [uwc1.4.3/scripts/sql]
9) paste them to your WS folder in the Kobold Repack [KoboldServerLite\WS]
[NOTE: do NOT copy the sql folder itself copy the .txt files inside they need to be directly in the WS folder]
10) ingame run the commands .import wo and .import gameobj
[NOTE: after running the gameobj the server will auto restart most the time so run it last]
11) restart and enjoy a now populated repack
(also their is no guaranty any of this works correctly as I have found even pulling these scripts I got about 70% of my world from my UWC emu server meaning nearly half the mobs are still missing. However most of them and gameobjects got added)
----------------------------------------------------------------------------------------------------------------
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 :D
Adios,
Fz
* EDIT: Make sure this line is correct:
Code:
`reputation` text NULL,
"The stuff"
Password to open server distribution is 'ILoveKobold'.
ARGGGG i am going nuts!! i'm trying to set up a server and fallow the guide perfectly but when i execute batch file and select the wow_server.sql in navicat the execute batch file window pops up and the timer keeps counting but nothing else happens. i left it on all night and most of the day and nothing happens. can anyone help me out please?
also im not sure if this makes a difference but i am using the mysql bundled with xampp
well i did all right and server run ok, but trainers missing, battle stance for warrior dont work and other stuff im missing now....hope a good release will be posted :D
Yea, i knew that already, it just that in mangos or uwc it automatically increase the max skil level like [10/300](the cap)not the stated skill. but in this, ludmilla, you'll hv to log out 1st, then it will change. that was not really a problem, but i need a correct world.save,, because i tried afg and it spawn like the game objects are not properly spawn, missing npcs and so on.http://img82.imageshack.us/my.php?im...6121059mr0.jpg
here is what i get when using afg 3.0 world.save other city also have the same problem http://img82.imageshack.us/img82/812...6121059mr0.jpg