how to remove from all monsters drop, and keep only adena? I mean about command in navicat.

write it in navicat query.

delete from droplist where itemId!=57

delete from droplist table where item id not 57.

57 adena id.

Edited August 2, 20179 yr by wongerlt

Do you have command? Because that "delete from droplist where itemId!=57"

 

wrong

m

Do you have command? Because that "delete from droplist where itemId!=57"

 

wrong

send here screenshot droplist table

http://imgur.com/a/TSHhp

Try with where itemId < 57 and itemId > 57, not sure if it can read !=.

Edited August 2, 20179 yr by SweeTs

http://imgur.com/a/TSHhp

where u write command?

u must write it in "Query"

where u write command?

u must write it in "Query"

now its ok, thank you boy.

 

 

Try with where itemId < 57 and itemId > 57, not sure if it can read !=.

thank you SweeTs to trying help me:)

Locked then.