The dump file you sourced to create your server database is just a snapshot. You import that into a MySQL database which is what the server uses for it's data and what the various editors modify.
Making changes to the dump file doesn't do anything unless you import it into MySQL again. Doing so replaces your existing database with the dump again. Unless you really want to start from scratch this is the wrong thing to do.
To edit items in the MySQL database you can use the item editor you're already using, or you will need something like HeidiSQL or Navicat.
As an example, if you used HeidiSQL or Navicat you would be able to execute queries on your database to change items.
This would select a particular item:
SELECT `Name`,`ldonprice` FROM items WHERE `Name` LIKE "%Archaic Blade of Battle%"
And this would change its price to 75
UPDATE items SET `ldonprice` = 75 WHERE `Name` LIKE "%Archaic Blade of Battle%"
Depending on the tool you use you can also edit things in a grid like a spreadsheet and then save those changes back to the database.
|
Threaded Mode
