EQEmulator Forums
Page 3 of 4 12 3 4
Show 40 post(s) from this thread on one page

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Development::Database/World Building (https://www.eqemulator.org/forums/forumdisplay.php?f=596)
-   -   complete live-like loot tables version 2.0! (https://www.eqemulator.org/forums/showthread.php?t=12584)

Jezebell 04-04-2004 02:36 AM
That is step 9 and 10, but i looks like the link is broken :(

govtcheeze 04-04-2004 03:05 AM
This message board system did not like the space in the file name (even though it was valid). I have updated the file name to not include any spaces.

http://home.gravyisgood.com/eqemu_do...pha2_addon.rar

(I am working on the finishing touches to the next release as I type this, and hope to have it out by this evening...you may want to wait for this release :))

mikenune 04-05-2004 01:48 PM
When I source the second .SQL file, I on't get any errors but after every query I get a response saying:

Quote:
Query OK, 0 rows affected (0.00 sec)
Rows matched: 0 Changed: 0 Warnings: 0
I'm not sure but shouldn't the queries actually make changes to the data?

govtcheeze 04-05-2004 02:39 PM
Very strange...did you delete from npc_types by accident? To test, try this command:

select name from npc_types limit 5;

If you get no results, you may have deleted the data from this table and need to start over :(

Also, did you tell mySQL to use your eqemu database? It may be using the default database (mysql) if not.

Shadow-Wolf 04-05-2004 03:31 PM
i get it too gov and it happens alot, i think it may be a reason it takes a way to source into the server also.. but oh well great job it gets most of the mobs their loot :)

themushygod 04-08-2004 01:26 PM
very usefull most most mobs have loot for me now

took forever to source that script though

govtcheeze 04-11-2004 11:53 PM
editing the main post did not mark the post as new, so bumping this as people see the new version is out

RexChaos 04-12-2004 01:08 AM
Just one problem that I've foiund, but not sure if you corrected in this version... skeletons and decaying skeletons are dropping bone chips, but they are magical and non-stackable. I believe the correct item number they should be dropping is 13073 (or 13703...13730?) or something like that. I'm at work right now so I can't check, but I think that's it.

So if I change the skeleton bone chip drops can it still affect all of them globally? I know you said things are done on a per zone basis, but to replace bone chips on a per zone basis would...well...suck. :)

Once again, thanks for these tables. HUGE help!

govtcheeze 04-12-2004 01:18 AM
You would not need to change much, take this skeleton for instance:

Code:
INSERT INTO loottable VALUES ('118', 'A_Skeleton', '200', '1360', '0'); -- A_Skeleton level is 6
INSERT INTO loottable_entries VALUES ('118', '118', '18', '15'); -- A_Skeleton has 18 total items
INSERT INTO lootdrop VALUES ('118', 'A_Skeleton');
INSERT INTO lootdrop_entries VALUES (118, 12694, 1, 0, '5'); -- A_Skeleton gets Bone Chips
INSERT INTO lootdrop_entries VALUES (118, 19552, 1, 0, '5'); -- A_Skeleton gets Calcified Ribcage
INSERT INTO lootdrop_entries VALUES (118, 20190, 1, 0, '5'); -- A_Skeleton gets Decaying Foot Bones
All you would need to change is :

Code:
INSERT INTO lootdrop_entries VALUES (118, 12694, 1, 0, '5'); -- A_Skeleton gets Bone Chips
to
Code:
INSERT INTO lootdrop_entries VALUES (118, 13073, 1, 0, '5'); -- A_Skeleton gets Bone Chips
You will need to do it for every skeleton type you want to update, but you do not need to do it on a per-zone basis. Hope this makes sense...if not let me know :)

RexChaos 04-12-2004 01:22 AM
Exxxxcellent...

Yep. That looks good to me. Thanks a bunch Dr. Cheese :)

By the way, where can I mail my first born child to?

govtcheeze 04-12-2004 01:34 AM
FOrgot to add, you should consider writing your updates in sql format, ie:

Code:
UPDATE lootdrop_entries set item_id = ##### where lootdrop_id = ##### and item_id = ##### LIMIT 1;
So in the example above, you would write:

Code:
UPDATE lootdrop_entries set item_id = 13073 where lootdrop_id = 118 and item_id = 12694 LIMIT 1;
This is good for 2 reasons, the first is if you re-source an update of mine, you can simply re-source your sql and the changes are done...no need to do the work again. The second and more important feature is you can post these updates for everyone to use :)

RexChaos 04-12-2004 01:35 AM
I agree. That's a good idea. I was using the iEQ program when I did it however. :-/ Nifty little program I might add.

DataMan4971 04-12-2004 05:00 AM
Very helpful
 
Pretty Cool, Used it on my server


As said above though, it also took forever to source

themushygod 04-12-2004 11:38 AM
ill be adding the update tonight :)

Klasfide 04-13-2004 12:21 AM
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


All times are GMT -4. The time now is 12:19 AM.
Page 3 of 4 12 3 4
Show 40 post(s) from this thread on one page

Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.