Go Back   EQEmulator Home > EQEmulator Forums > Archives > Archive::Development > Archive::Development

Archive::Development Archive area for Development's posts that were moved here after an inactivity period of 90 days.

Reply
 
Thread Tools Display Modes
  #1  
Old 03-06-2002, 06:37 AM
Drawde
Dragon
 
Join Date: Jan 2002
Posts: 521
Default Spawn/world data 0.6

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.
Reply With Quote
  #2  
Old 03-06-2002, 06:41 AM
devn00b's Avatar
devn00b
Demi-God
 
Join Date: Jan 2002
Posts: 15,658
Default

Url Not found =P

The requested URL /~drawde/worlddata0.6.zip. was not found on this server
__________________
(Former)Senior EQEMu Developer
GuildWars Co-Founder / World Builder.
World Builder and Co-Founder Zek [PVP/Guild Wars/City Takeovers]
Member of the "I hate devn00b" Club
Most Senior EQEMu Member.

Current Work: EverQuest 2 Emulator. Zeklabs Server
Reply With Quote
  #3  
Old 03-06-2002, 12:13 PM
Stud
Sarnak
 
Join Date: Jan 2002
Posts: 44
Default

nevermind....it was just me.....
Reply With Quote
  #4  
Old 03-06-2002, 02:07 PM
strychn
Hill Giant
 
Join Date: Feb 2002
Posts: 129
Default

take the period of the end of the url....:p
Reply With Quote
  #5  
Old 03-06-2002, 02:25 PM
Nunnehi
Fire Beetle
 
Join Date: Jan 2002
Posts: 20
Default

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

Nunnehi
Systems Administrator
Reply With Quote
  #6  
Old 03-06-2002, 09:12 PM
Drawde
Dragon
 
Join Date: Jan 2002
Posts: 521
Default

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)
Reply With Quote
  #7  
Old 03-07-2002, 12:00 AM
Nunnehi
Fire Beetle
 
Join Date: Jan 2002
Posts: 20
Default

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

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

Nunnehi
Systems Administrator
Reply With Quote
  #8  
Old 03-09-2002, 12:26 AM
g0dmachine
Fire Beetle
 
Join Date: Feb 2002
Posts: 9
Default

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
Reply With Quote
  #9  
Old 03-09-2002, 01:13 AM
g0dmachine
Fire Beetle
 
Join Date: Feb 2002
Posts: 9
Default

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

not sure why it wasnt there before but works now
Reply With Quote
  #10  
Old 03-18-2002, 05:05 AM
Realm
Fire Beetle
 
Join Date: Mar 2002
Posts: 7
Default Easier

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?
Reply With Quote
  #11  
Old 03-18-2002, 08:35 AM
flipper
Sarnak
 
Join Date: Jan 2002
Location: California
Posts: 94
Default

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:

Code:
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.
Reply With Quote
  #12  
Old 03-18-2002, 09:30 AM
Hmm
Discordant
 
Join Date: Jan 2002
Posts: 276
Default

i didnt even bother to rename em and it works.
__________________
Hmm...
Reply With Quote
  #13  
Old 03-18-2002, 04:12 PM
Lurker_005
Demi-God
 
Join Date: Jan 2002
Location: Tourist town USA
Posts: 1,671
Default

For an easy install batch file, see this post

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.

Code:
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
Reply With Quote
  #14  
Old 03-18-2002, 10:38 PM
Drawde
Dragon
 
Join Date: Jan 2002
Posts: 521
Default

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.
Reply With Quote
  #15  
Old 03-19-2002, 05:12 PM
Ariak
Dragon
 
Join Date: Mar 2002
Posts: 633
Default ETA on Next Version?

ETA on Next Version?
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

   

All times are GMT -4. The time now is 01:36 PM.


 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3