[Itemtype Update! Read this, very important!]

give my 2 cents as well

open item_db2.txt

use notepad++, Ctrl+F, select Regular Expression

Find

^([0-9]*),([^,]*),([^,]*),4,

replace with

\1,\2,\3,99,

Find

^([0-9]*),([^,]*),([^,]*),5,

replace with

\1,\2,\3,4,

Find

^([0-9]*),([^,]*),([^,]*),99,

replace with

\1,\2,\3,5,

regular_expression.png

sql command

update item_db2 set type = !(type -4) +4 where type = 4 or type = 5;

EDIT:

awww ...

regular expression doesn't seem able to do numeric calculation ... I think ?

 

 

I dont have Item_db2, can you help me how to do this?

[[Tutorial] How to Create Ragnarok Offline 2013 client [Tutorial]]

How to fix this?