Help How To Remove?

[Undermufler]

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

[wongerlt]

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, 2017 by wongerlt

[Undermufler]

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

 

wrong

[wongerlt]

m

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

 

wrong

send here screenshot droplist table

[Undermufler]

http://imgur.com/a/TSHhp

[SweeTs]

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

Edited August 2, 2017 by SweeTs

[wongerlt]

http://imgur.com/a/TSHhp

where u write command?

u must write it in "Query"

[Undermufler]

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:)

[SweeTs]

Locked then.