item_db.sql

[patr3k]

How can i update my item_db.sql in my phpmysql if there's changeset in item_db.sql from rAthena?

Edited August 14, 2012 by patr3k

[Mystery]

You just take the snippet of what was changed in item_db_sql (ONLY SNIPPET OF THE ITEM THAT WAS CHANGED) and then run it in your PHPAdmin. If you load the entire item_db_sql instead of the snippet of the item that was changed, you would run the risk of losing any custom changes you've done to any other items.

[patr3k]

what do you mean by snippet? can you give me an example how to do it or a guide. Thank you in advance.

[Lighta]

He means take a look at sql_files/update_svn...sql

Usually when the db change they put those files as a query to execute to do the change.

For exemple lastest I got is upgrade_svn16518.sql, if I open phpmyadmin (or any other mysql client) connect to my db and execute the query in that file, my db will be updated for the change in r16518.

(in this exemple it'll add colum favorite to my inventory table).

Otherwise if you don't know when that happen but know the change you could just create a query to apply them.

like :

REPLACE INTO `item_db_re` VALUES (19513,'Chicken_Bill','Chicken Bill',5,NULL,NULL,0,NULL,NULL,NULL,NULL,0xFFFFFFFF,7,2,4096,NULL,1,NULL,699,NULL,NULL,NULL);

Wich will update the item 19153. Hope you got it =)

[patr3k]

in myphpadmin:

Use tables: do i have to select item_db_re?

SQL query on database ragnarok: ( i insert this in the text box?)

REPLACE INTO `item_db_re` VALUES (19513,'Chicken_Bill','Chicken Bill',5,NULL,NULL,0,NULL,NULL,NULL,NULL,0xFFFFFFFF,7,2,4096,NULL,1,NULL,699,NULL,NULL,NULL);

then submit query?

Edited August 14, 2012 by patr3k

[Lighta]

You don't have to select the table, it's already set in the query, and yes it's in sql query that you copy past this.

But it's only an exemple I don't know wich item was change you just need to grep those line and do it.

[patr3k]

okay got it! Thanks a lot!