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
  #46  
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
  #47  
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
  #48  
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
  #49  
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
  #50  
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
  #51  
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
  #52  
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
  #53  
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
  #54  
Old 04-21-2005, 08:48 PM
SiliconeClone
Sarnak
 
Join Date: Apr 2005
Posts: 42
Default

The link is broke.. anyone have this avail?
Reply With Quote
  #55  
Old 05-18-2005, 05:54 AM
Calabeth
Sarnak
 
Join Date: Apr 2002
Posts: 39
Default

Ok Q for ye Mr Cheeze.

In your updates and such are the Rathe Mtns Hill Giants supposed to be poor bastages now? The server I am playing on has a DB what supposedly has your Loot and Faction DB added in with it. But the Giants are like 3pp at most so far.

If they are supposed to be alot richer then that I'll let the server admin know so they can resource your loot DB into there instead.

PS clicking on your links results in 404 Not Found.
Reply With Quote
  #56  
Old 05-18-2005, 06:13 PM
sdabbs65
Dragon
 
Join Date: Dec 2003
Location: Earth
Posts: 818
Default

-deleted no longer maintained or compatable-
__________________
hosting Eqemu/Runuo/wow Emulators.

www.cheaterz.info

Last edited by sdabbs65; 06-02-2005 at 12:24 PM..
Reply With Quote
  #57  
Old 06-02-2005, 02:53 AM
govtcheeze
Hill Giant
 
Join Date: Mar 2004
Location: South Florida
Posts: 247
Default

Its been 6 months since this was maintained, but I am pretty sure coin was based on the level of the mob. I had some formula based on average mob coin values from live and applied it generally to the script since prior to this, mobs didnt drop any coin.
__________________
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
  #58  
Old 06-02-2005, 05:45 AM
mwmdragon's Avatar
mwmdragon
Discordant
 
Join Date: Apr 2003
Location: Winnipeg, Manitoba Canada
Posts: 270
Default update

Hey GOV update your sig bitch!

jk
__________________
Thanks
MWMDRAGON

NeverQuest
http://neverquest.gotdns.com
Emucade
http://dragonsden.emuunlim.com
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 07: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 - 2024, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3