Go Back   EQEmulator Home > EQEmulator Forums > Development > Development::Database/World Building

Development::Database/World Building World Building forum, dedicated to the EQEmu MySQL Database. Post partial/complete databases for spawns, items, etc.

Reply
 
Thread Tools Display Modes
  #1  
Old 04-12-2004, 01:35 AM
RexChaos
Dragon
 
Join Date: Feb 2004
Location: Everywhere you want to be
Posts: 582
Default

I agree. That's a good idea. I was using the iEQ program when I did it however. :-/ Nifty little program I might add.
__________________
An obnoxiously large picture should go here with some witty saying about some cartoon character I made in EQ, but then I realized that shit is fucking annoying.
Reply With Quote
  #2  
Old 04-12-2004, 05:00 AM
DataMan4971
Sarnak
 
Join Date: Dec 2003
Location: Seattle
Posts: 46
Default Very helpful

Pretty Cool, Used it on my server


As said above though, it also took forever to source
__________________
-Keep you friends close, and your enemies closer-The Art of War

Artemis, the Emperor of Assasins - Draclian Signus, GM Admin and complete follower of the way of Draclian Signus.
Reply With Quote
  #3  
Old 04-12-2004, 11:38 AM
themushygod
Sarnak
 
Join Date: Feb 2004
Posts: 60
Default

ill be adding the update tonight
Reply With Quote
  #4  
Old 04-13-2004, 12:21 AM
Klasfide
Fire Beetle
 
Join Date: Mar 2004
Posts: 20
Default

Most of my querys are 0 0 too, its not changing them, i did a fresh install of the db aswell, I sourced mw055 1 then alpha 2 , then doorupdates then dumpeditems then loot update then npc types upate
Reply With Quote
  #5  
Old 04-13-2004, 01:03 AM
govtcheeze
Hill Giant
 
Join Date: Mar 2004
Location: South Florida
Posts: 247
Default

About 75% of them should be 0, each mob is checked for 4 different permutations of the name as they appear in the MW database:

mob
#mob
mobXX
and #mobXX

This is done for completeness sake, and takes awhile.

It also compares each name with the zone in the spawn table, and compares it to the habitats listing from allakhazam. This is why orcs in different zones carry unique loot.
__________________
GovtCheeze, Welfare Warrior
"Listen, here's the thing. If you can't spot the sucker in the first half hour at the table, then you ARE the sucker." -- Mike McDermott, Rounders

Developer of the original (circa 2004):
Loots v2.0, bitch!
Faction v1.0, bitch!
Magelo-like clone v0.3, bitch!
Zone geometry and spawn/path viewer, bitch!
Reply With Quote
  #6  
Old 04-13-2004, 07:33 AM
Klasfide
Fire Beetle
 
Join Date: Mar 2004
Posts: 20
Default

Also plat isn't dropping off mobs either.
Reply With Quote
  #7  
Old 04-13-2004, 07:54 AM
govtcheeze
Hill Giant
 
Join Date: Mar 2004
Location: South Florida
Posts: 247
Default

Make sure you got the new version, and sourced it correctly. It has been dropping my server and the live test server AFAIK. I also double-checked the source to make sure plat drops are in there, and they are:

INSERT INTO loottable VALUES ('4179', 'A_Burynai_Burrower', '440', '2944', '0'); -- A_Burynai_Burrower level is 12
INSERT INTO loottable_entries VALUES ('4179', '4179', '1', '15'); -- A_Burynai_Burrower has 1 total items
INSERT INTO lootdrop VALUES ('4179', 'A_Burynai_Burrower');
INSERT INTO lootdrop_entries VALUES (4179, 5652, 1, 1, '100'); -- A_Burynai_Burrower gets Burynai Digmaster\'s Claw
__________________
GovtCheeze, Welfare Warrior
"Listen, here's the thing. If you can't spot the sucker in the first half hour at the table, then you ARE the sucker." -- Mike McDermott, Rounders

Developer of the original (circa 2004):
Loots v2.0, bitch!
Faction v1.0, bitch!
Magelo-like clone v0.3, bitch!
Zone geometry and spawn/path viewer, bitch!
Reply With Quote
  #8  
Old 04-13-2004, 10:08 AM
Klasfide
Fire Beetle
 
Join Date: Mar 2004
Posts: 20
Default

shrug wierd, I sourced it like I always have with your sqls, i did a fresh database with the new update.. shrug not sure then ;/ some plat drops on some mobs but most dont drop plat.
Reply With Quote
  #9  
Old 04-24-2004, 05:39 AM
govtcheeze
Hill Giant
 
Join Date: Mar 2004
Location: South Florida
Posts: 247
Default

File location has changed. New link is:

http://govtcheeze.eqemulator.net/dow...heeze_loot.rar

- and -

http://govtcheeze.eqemulator.net/dow...e_loot_log.rar

You can always browse to http://govtcheeze.eqemulator.net/download/ for a list of all files I have released.
__________________
GovtCheeze, Welfare Warrior
"Listen, here's the thing. If you can't spot the sucker in the first half hour at the table, then you ARE the sucker." -- Mike McDermott, Rounders

Developer of the original (circa 2004):
Loots v2.0, bitch!
Faction v1.0, bitch!
Magelo-like clone v0.3, bitch!
Zone geometry and spawn/path viewer, bitch!
Reply With Quote
  #10  
Old 05-13-2004, 05:56 PM
govtcheeze
Hill Giant
 
Join Date: Mar 2004
Location: South Florida
Posts: 247
Default

bumping post, new version released
__________________
GovtCheeze, Welfare Warrior
"Listen, here's the thing. If you can't spot the sucker in the first half hour at the table, then you ARE the sucker." -- Mike McDermott, Rounders

Developer of the original (circa 2004):
Loots v2.0, bitch!
Faction v1.0, bitch!
Magelo-like clone v0.3, bitch!
Zone geometry and spawn/path viewer, bitch!
Reply With Quote
  #11  
Old 09-17-2004, 07:56 AM
govtcheeze
Hill Giant
 
Join Date: Mar 2004
Location: South Florida
Posts: 247
Default

version 1.0, bling bling
__________________
GovtCheeze, Welfare Warrior
"Listen, here's the thing. If you can't spot the sucker in the first half hour at the table, then you ARE the sucker." -- Mike McDermott, Rounders

Developer of the original (circa 2004):
Loots v2.0, bitch!
Faction v1.0, bitch!
Magelo-like clone v0.3, bitch!
Zone geometry and spawn/path viewer, bitch!
Reply With Quote
  #12  
Old 11-05-2004, 01:24 PM
govtcheeze
Hill Giant
 
Join Date: Mar 2004
Location: South Florida
Posts: 247
Default

version 2.0, bling bling
__________________
GovtCheeze, Welfare Warrior
"Listen, here's the thing. If you can't spot the sucker in the first half hour at the table, then you ARE the sucker." -- Mike McDermott, Rounders

Developer of the original (circa 2004):
Loots v2.0, bitch!
Faction v1.0, bitch!
Magelo-like clone v0.3, bitch!
Zone geometry and spawn/path viewer, bitch!
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 03:39 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 - 2025, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3