[HELP] Item Drop Data from Mobs

[leontan137]

INSERT INTO drop_data VALUES (DEFAULT, 9300149, 2040006, 1, 1, 0, 30000);
How can I execute this? I am required from owner to make Drop Data's for all mobs in Maple World, there are thousands and the item drops are million, how can I possibly do it? Is there a better way than copying modid,itemid,chance for million and million of times? Thank you for your Help! :D

[MentaL]

[divinesam]

I dont really understand what you mean.

Under SQL datasheet, there is a drop_data, and drop_global.

You may edit specific monster drop at drop_data
And you may edit global monster drop (all monster drop this item) under drop_global.

If you mean you want all monster in your server to drop the same item with the same drop rate, simply edit drop_global.

[leontan137]

I dont really understand what you mean.

Under SQL datasheet, there is a drop_data, and drop_global.

You may edit specific monster drop at drop_data
And you may edit global monster drop (all monster drop this item) under drop_global.

If you mean you want all monster in your server to drop the same item with the same drop rate, simply edit drop_global.

No, what I meant was that the server's mobs are not dropping items, so owner ask me to use SQL format to key in the mobid, itemid...as seen above, but 1 mob drops a few items and there are millions of mobs in Maple so how is it possible that I copy and paste the id 1 by 1?

[bbhing98]

Ask the owner to check his database whether he has drop_data or not. Then check if there's any value or not. If there is, then your source mob drops is screwed. Otherwise look for any source similar to your server version and rip the drop_data part(most likely there's value in the database already.)

[SlikStik]

What version is your server?

[leontan137]

What version is your server?

v1.31.2 MapleSEA how do I rip the drop_data part