Materials Drop

[Itachi]

Hey guys , does some1 know how to make it DONT drop materials?

 

i know that there is a "code" to writte in 1 of the Server\GameServer\Config\ but i dunno the code...

 

can some1 tell me a code or a way to do that?

 

thanks  :P

[Commodus]

What do you mean??

 

The mob not to drop materials??

 

Or the players not to drop items in the ground?

[ExTrEmEDwarf]

u can delete the droplist table from navicat and then import the drop that u want to the mobs u want..

 

Edit: i guess i got the point, go to gameserver/config/altsettings and find this:

 

# AutoLoot enable. True to enable, False to disable

AutoLoot = False

 

Change it to True

[Itachi]

i mean...

 

how do i make the mobs NOT DROP any kind of material...

[Commodus]

i mean...

 

how do i make the mobs NOT DROP any kind of material...

 

The first way is that Extremedwarf said to you but there is also another way easier than the first.

 

Shift + Left click on the mob --> Show Droplist and from there you can see and delete the materials that you want.

[Matim]

Make new sql file ... for example something like:

 

DELETE FROM `tablename` WHERE id=ITEM ID;

 

In tablename i mean it should be droplist table.

 

The fastest way to delete all unnecessary drops from droplist.

 

[Itachi]

i know that way...

 

but i once saw a code in a Server\GameServer\Config  file that made it dont drop mats without deleting the droptable neither ingame droplist from mobs

[Matim]

What's the difference ... use my SQL code and you're done..

 

DELETE FROM `tablename` WHERE id=ITEM ID;

 

In tablename i mean it should be droplist table.

 

 

the same result

[Itachi]

Matim is there any way to erase all except the adena(57)?

 

cuz if i am to writte all id's i wont finish writting them not even tomorrow xD

thanks :D

[Matim]

Matim is there any way to erase all except the adena(57)?

 

cuz if i am to writte all id's i wont finish writting them not even tomorrow xD

thanks :D

 

Huh...im not sure..;D It should be something delete Alll where id != 57 xD But its SQL...hmm i will try to find something ^^

[Itachi]

if you find it can you post it here?

 

so that i get notified in msn. . .

 

thanks ;D

[Matim]

I have only somthing like this:

 

DELETE FROM `tablename` WHERE `id` > 57

 

so it will delete all drops with id higher than 57

 

and than use:

 

DELETE FROM `tablename` WHERE `id` < 57

 

so it will delete all drops with id lower than 57..

 

and i think it should work ^^ but im nor sure

[Itachi]

ok. . .

thanks i am trying it right now ;P

[Matim]

ok waiting for results  ;)

[Itachi]

it gives me a error ;/

 

"[Err] 1054 - Unknown column 'id' in 'where clause'

[Err] DELETE FROM `droplist` WHERE `id` > 57

[Msg] Finished - Unsuccessfully

--------------------------------------------------"

[ExTrEmEDwarf]

change the id with itemId

 

Something like that:

 

 

DELETE FROM `tablename` WHERE `itemId` > 57

 

 

and then use:

 

DELETE FROM `tablename` WHERE `itemId` < 57