[Help] Remove Material Drop

[Urbanhack]

Hello Guys... Some One Know How I Can Remove ALL Material Drop?

Some Script For Remove It?

I Dont Like Search One By One... And Delete Later...

I Need Remove All Fastly!!!

For Example Bones Crafted Leather... Armor Parts Weapon Parts...

 

Some Idea?

 

Anyway Tx A Lot

[Gxz]

shift+click on mob click droplist and delete the materials ;)

[Urbanhack]

shift+click on mob click droplist and delete the materials ;)

 

but it delete for 1 mob i need remove for all mobs in all the world.

i wanna clear the material drop

[Gxz]

but it delete for 1 mob i need remove for all mobs in all the world.

i wanna clear the material drop

if you delete 1 mob and you restart the server then all mobs like those you edited the first time will be refreshed and be like the 1st one you edited ;)

[MrAderson]

if you delete 1 mob and you restart the server then all mobs like those you edited the first time will be refreshed and be like the 1st one you edited ;)

 

At his 1st post his clearly saying that he dont want to delete it one by one...

 

what you dont understand?

 

@urbanhack i think that there is no such of script doing this.... and i never saw something like that you're asking for so...1 by 1 :D

[Gxz]

only 1 way... delete all materials from db ;)

[*ZwntanoiNekroi*]

not all materials...all the drops....and then add your drops....

right click on the table .....empty table :D

[Gxz]

not all materials...all the drops....and then add your drops....

right click on the table .....empty table :D

nop with this way he will delete everything, even adena so find materials ids and delete them

[*ZwntanoiNekroi*]

nop with this way he will delete everything, even adena so find materials ids and delete them

pfffff if he dont wants to do it then he cant delete the materials...

the best way...delete the whole drops and add his owns in the zones he wants :D

(sry for the double post)

[Gxz]

pfffff if he dont wants to do it then he cant delete the materials...

the best way...delete the whole drops and add his owns in the zones he wants :D

(sry for the double post)

which double post? and you must be really idiot to delete all droplist and take each mob to add him adena... it will take you weeks to finish lol

[*ZwntanoiNekroi*]

which double post? and you must be really idiot to delete all droplist and take each mob to add him adena... it will take you weeks to finish lol

omg i said only the mobs you want pffffffffffffffffffffffff

not all of them...

lock it please...

there is no such script that deletes the materials only this is a personal work

 

1st warning dont post again!

[Urbanhack]

-beep-.. well.. then i have to write all materials "id" on a .txt and later remove the drop with a sql.>>

DELETE FROM droplist WHERE item_id = XXXX;

then i need make this with all!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! IDs (Materials)

OMG! T_T

 

if some1 know a better way pls tell me!

 

ty

[LauQ]

-beep-.. well.. then i have to write all materials "id" on a .txt and later remove the drop with a sql.>>

DELETE FROM droplist WHERE item_id = XXXX;

then i need make this with all!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! IDs (Materials)

OMG! T_T

 

if some1 know a better way pls tell me!

 

ty

Yup, is best way.

 

Whatever way you choose, it's gonna be some work

 

Locked cause of wrong section, but I hope it's solved now anyway.

[rodox]

Maybe try sth like:

delete from droplist where itemId in (select item_id from etcitem where item_type like material)

[AdrenalinE]

try this : http://www.maxcheaters.com/forum/index.php?topic=122064.0 ;)

[AdrenalinE]

Thats isnt help or what ?!

Please mod just lock the topic.

lol!!! .. in my link all material delete from db...so .... :)

 

Close mod please