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

04-13-2004, 01:03 AM
|
Hill Giant
|
|
Join Date: Mar 2004
Location: South Florida
Posts: 247
|
|
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.
|

04-13-2004, 07:33 AM
|
Fire Beetle
|
|
Join Date: Mar 2004
Posts: 20
|
|
Also plat isn't dropping off mobs either.
|

04-13-2004, 07:54 AM
|
Hill Giant
|
|
Join Date: Mar 2004
Location: South Florida
Posts: 247
|
|
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
|
 |
|
 |

04-13-2004, 10:08 AM
|
Fire Beetle
|
|
Join Date: Mar 2004
Posts: 20
|
|
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.
|

04-24-2004, 05:39 AM
|
Hill Giant
|
|
Join Date: Mar 2004
Location: South Florida
Posts: 247
|
|
|

05-13-2004, 05:56 PM
|
Hill Giant
|
|
Join Date: Mar 2004
Location: South Florida
Posts: 247
|
|
bumping post, new version released
|

09-17-2004, 07:56 AM
|
Hill Giant
|
|
Join Date: Mar 2004
Location: South Florida
Posts: 247
|
|
version 1.0, bling bling
|

11-05-2004, 01:24 PM
|
Hill Giant
|
|
Join Date: Mar 2004
Location: South Florida
Posts: 247
|
|
version 2.0, bling bling
|

04-21-2005, 08:48 PM
|
Sarnak
|
|
Join Date: Apr 2005
Posts: 42
|
|
The link is broke.. anyone have this avail?
|

05-18-2005, 05:54 AM
|
Sarnak
|
|
Join Date: Apr 2002
Posts: 39
|
|
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.
|

05-18-2005, 06:13 PM
|
Dragon
|
|
Join Date: Dec 2003
Location: Earth
Posts: 818
|
|
-deleted no longer maintained or compatable-
Last edited by sdabbs65; 06-02-2005 at 12:24 PM..
|

06-02-2005, 02:53 AM
|
Hill Giant
|
|
Join Date: Mar 2004
Location: South Florida
Posts: 247
|
|
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.
|

06-02-2005, 05:45 AM
|
 |
Discordant
|
|
Join Date: Apr 2003
Location: Winnipeg, Manitoba Canada
Posts: 270
|
|
update
Hey GOV update your sig bitch!
jk
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
All times are GMT -4. The time now is 06:44 PM.
|
|
 |
|
 |
|
|
|
 |
|
 |
|
 |