Spawn/world data 0.6

[Drawde]

Sorry it's been so long since the last version, but you can now get version
0.6 from http://www.innersystems.com/~drawde/worlddata0.6.zip
It should be compatible with both 0.2.3 and 0.2.4 (however you will be unable
to buy or sell from the merchants in the current 0.2.4 beta, though you can
see what things they sell)

New things in this version -
More or less complete merchant item lists
Basic faction data (one faction per race at the minute; I'll add individual factions and monster clans later)
Lots of Z coordinate fixes (still a lot to do though, especially in dungeons)
Armour/robe textures for NPCs (based on class and level)
More zone points (though they don't work at the minute)
Many other small changes, bugfixes and additions to NPC and loot table data.

Most city zones are working properly now, however Neriak and Paineel are still very buggy especially with Z coordinates.

Merchant lists include "generic" ones for various types of weapons, armour, supplies, jewellery etc.,
tradeskill item merchants (though tradeskills don't work in the emulator ATM), food and drink (different for
each race) as well as unique weapon, armour and artifact merchants for each race selling high-value magic items.

Any feedback on bugs (especially crashes and "bogus item" errors with merchants) would be very helpful!
There are (in 2.3 at least) some problems with gold and platinum not being subtracted when you buy things, and stackable/chargable
items (e.g food or potions) being deleted when bought due to having zero charges. However this is a bug in the EQEmu code
and has nothing to do with the merchant list data.

[devn00b]

Url Not found =P

The requested URL /~drawde/worlddata0.6.zip. was not found on this server

[Stud]

nevermind....it was just me.....

[strychn]

take the period of the end of the url....:p

[Nunnehi]

A good item to add would be Bladestorm, Katana of Steel Sleet. That sword was badass ;)

[Drawde]

That weapon isn't in the item DB unfortunately..
Also, many high-value/quest items have a value of either 0 or 1cp, so can't really be sold by merchants. Some of those that do have realistic money values I've added to the "artifact" merchant lists (usually one for each city and race)

[Nunnehi]

Ah, it's not a question item by the way. It was dropped from Dracoliche in Fearplane. Verant saw it as too powerful, and took it out. They replaced it with monsoon(shudder). Bladestorm was awesome :D

If you need stats of it, you can find it at www.everlore.com

[g0dmachine]

using 0.2.4 pre5 emu

i am getting this error on npc_types.txt

ERROR 1136: Column count doesn't match value count at row 1

[g0dmachine]

had to add merchant_id to the database
with type int(11) unsigned

not sure why it wasnt there before but works now

[Realm]

I was wondering if you had a link to a db.sql file that already had all the changes made to it. I could go through and copy and paste all of the files but I am worried I will break it by pasting it in the wrong place or without deleting the # that are in place of the --. Any way I can get a db.sql file that already has these things in place?

[flipper]

You don't need a completely integrated foo.sql file -- eventhough that would be nice.

I haven't had any problems taking the .txt files from Drawde's distribution and renaming them to .sql files. I then just add them into my "eq" database via mysql as follows:


mysql -u <my db username> -p
<enter your password when prompted>
use <your eqemu db name>
source loot.sql
source zone_points.sql
source <etc...>


You will get a few beeps due to duplicated db entries, but it works.

[Hmm]

i didnt even bother to rename em and it works.

[Lurker_005]

For an easy install batch file, see this post (http://forums.eqemu.net/showthread.php?s=&postid=4689#post4689)

Oh and if you turn echo on, it nicely outputs the import errors to the dos window. Mostly duplicate Key values, but it works just fine anyhow.

mysql -f eqtest <faction_list.txt

ERROR 1062 at line 1: Duplicate entry '1' for key 1
ERROR 1136 at line 7: Column count doesn't match value count at row 1
ERROR 1136 at line 9: Column count doesn't match value count at row 1
ERROR 1136 at line 10: Column count doesn't match value count at row 1
ERROR 1062 at line 26: Duplicate entry '124' for key 1
ERROR 1136 at line 51: Column count doesn't match value count at row 1

mysql -f eqtest <loot.txt
ERROR 1050 at line 5: Table 'lootdrop' already exists
ERROR 1062 at line 420: Duplicate entry '3471' for key 1
ERROR 1064 at line 476: You have an error in your SQL syntax near '' at line 1
ERROR 1050 at line 562: Table 'lootdrop_entries' already exists
ERROR 1062 at line 1234: Duplicate entry '63-1160' for key 1
ERROR 1062 at line 1302: Duplicate entry '69-1160' for key 1
ERROR 1062 at line 1368: Duplicate entry '75-1160' for key 1
ERROR 1062 at line 1435: Duplicate entry '81-1160' for key 1
ERROR 1062 at line 1541: Duplicate entry '313-5013' for key 1
ERROR 1062 at line 1542: Duplicate entry '313-5021' for key 1
ERROR 1062 at line 1543: Duplicate entry '313-5022' for key 1
ERROR 1062 at line 1654: Duplicate entry '326-5013' for key 1
ERROR 1062 at line 1655: Duplicate entry '326-5021' for key 1
ERROR 1062 at line 1656: Duplicate entry '326-5022' for key 1
ERROR 1062 at line 1685: Duplicate entry '328-5013' for key 1
ERROR 1062 at line 1686: Duplicate entry '328-5021' for key 1
ERROR 1062 at line 1687: Duplicate entry '328-5022' for key 1
ERROR 1062 at line 1779: Duplicate entry '340-5021' for key 1
ERROR 1062 at line 1780: Duplicate entry '340-5022' for key 1
ERROR 1062 at line 1847: Duplicate entry '349-12590' for key 1
ERROR 1062 at line 1882: Duplicate entry '354-5013' for key 1
ERROR 1062 at line 1883: Duplicate entry '354-5021' for key 1
ERROR 1062 at line 1884: Duplicate entry '354-5022' for key 1
ERROR 1062 at line 1902: Duplicate entry '360-5015' for key 1
ERROR 1062 at line 2026: Duplicate entry '396-10119' for key 1
ERROR 1062 at line 2137: Duplicate entry '431-11909' for key 1
ERROR 1062 at line 2139: Duplicate entry '431-14753' for key 1
ERROR 1062 at line 2140: Duplicate entry '431-9205' for key 1
ERROR 1062 at line 2240: Duplicate entry '444-11936' for key 1
ERROR 1062 at line 2241: Duplicate entry '444-12811' for key 1
ERROR 1062 at line 2242: Duplicate entry '444-11936' for key 1
ERROR 1062 at line 2719: Duplicate entry '3401-5014' for key 1
ERROR 1062 at line 2957: Duplicate entry '3542-3012' for key 1
ERROR 1062 at line 2973: Duplicate entry '3542-12187' for key 1
ERROR 1062 at line 3239: Duplicate entry '3892-13053' for key 1
ERROR 1062 at line 3471: Duplicate entry '4614-16535' for key 1
ERROR 1062 at line 3540: Duplicate entry '1001-10119' for key 1
ERROR 1062 at line 3588: Duplicate entry '1002-15045' for key 1
ERROR 1062 at line 3689: Duplicate entry '1002-15145' for key 1
ERROR 1062 at line 3790: Duplicate entry '1002-15245' for key 1
ERROR 1062 at line 3891: Duplicate entry '1002-15345' for key 1
ERROR 1062 at line 3992: Duplicate entry '1002-15445' for key 1
ERROR 1062 at line 4093: Duplicate entry '1002-15545' for key 1
ERROR 1062 at line 4194: Duplicate entry '1002-15645' for key 1
ERROR 1062 at line 4295: Duplicate entry '1002-15745' for key 1
ERROR 1062 at line 4396: Duplicate entry '1002-15845' for key 1
ERROR 1062 at line 4578: Duplicate entry '1002-19245' for key 1
ERROR 1062 at line 4679: Duplicate entry '1002-19345' for key 1
ERROR 1062 at line 4780: Duplicate entry '1002-19445' for key 1
ERROR 1050 at line 4947: Table 'loottable' already exists
ERROR 1062 at line 5317: Duplicate entry '3364' for key 1
ERROR 1062 at line 5335: Duplicate entry '3394' for key 1
ERROR 1050 at line 5498: Table 'loottable_entries' already exists

mysql -f eqtest <merchantlist.txt

ERROR 1062 at line 195: Duplicate entry '12-10' for key 1
ERROR 1062 at line 752: Duplicate entry '58-17' for key 1
ERROR 1062 at line 785: Duplicate entry '60-20' for key 1
ERROR 1062 at line 786: Duplicate entry '60-20' for key 1
ERROR 1062 at line 992: Duplicate entry '83-14' for key 1
ERROR 1062 at line 993: Duplicate entry '83-15' for key 1
ERROR 1062 at line 1439: Duplicate entry '123-7' for key 1
ERROR 1062 at line 1440: Duplicate entry '123-8' for key 1
ERROR 1062 at line 1441: Duplicate entry '123-9' for key 1
ERROR 1062 at line 1442: Duplicate entry '123-10' for key 1
ERROR 1062 at line 1443: Duplicate entry '123-11' for key 1
ERROR 1062 at line 1444: Duplicate entry '123-12' for key 1
ERROR 1062 at line 1445: Duplicate entry '123-13' for key 1
ERROR 1062 at line 1446: Duplicate entry '123-14' for key 1
ERROR 1062 at line 1447: Duplicate entry '123-15' for key 1
ERROR 1062 at line 1448: Duplicate entry '123-16' for key 1
ERROR 1062 at line 1449: Duplicate entry '123-17' for key 1
ERROR 1062 at line 1480: Duplicate entry '127-4' for key 1
ERROR 1062 at line 2140: Duplicate entry '205-21' for key 1
ERROR 1062 at line 3011: Duplicate entry '246-4' for key 1
ERROR 1062 at line 3036: Duplicate entry '246-29' for key 1
ERROR 1062 at line 3134: Duplicate entry '90-5' for key 1

mysql -f eqtest <npc_faction.txt


mysql -f eqtest <npc_types.txt

mysql -f eqtest <spawn2.txt

mysql -f eqtest <spawnentry.txt

mysql -f eqtest <spawngroup.txt

mysql -f eqtest <zone_points.txt

ERROR 1062 at line 2: Duplicate entry '1' for key 1
ERROR 1062 at line 3: Duplicate entry '2' for key 1
ERROR 1062 at line 4: Duplicate entry '3' for key 1
ERROR 1062 at line 5: Duplicate entry '4' for key 1
ERROR 1062 at line 18: Duplicate entry '17' for key 1
ERROR 1062 at line 19: Duplicate entry '18' for key 1
ERROR 1062 at line 20: Duplicate entry '19' for key 1

[Drawde]

With the next version I'll release a complete db file as well as the seperate .txt files, to make it easier to install. I'll still distribute the .txt files so people can merge the data with their own DB changes.

[Ariak]

ETA on Next Version?

[Drawde]

Probably within the next few days, certainly within a week.
I'm currently adding some loot tables for unique NPCs, bandits etc.

[RexChaos]

Link is broken. Any update on this work?

[tcsmyworld]

A 2 year old post, refering to spawn data for version 0.2.4, kinda doubt it.
Drawdes newest release was 1.1 final, but thats been quite some time.
He did pop on the forums a couple months back tho, I havent given up hope for Drawdes return :)

[RexChaos]

Crap...didn't see the date on it. sorry about that. Did a search for somethign at the time and that post caught my eye. Hehe...