mrlongshen Posted March 15, 2013 Group: Members Topic Count: 98 Topics Per Day: 0.02 Content Count: 1302 Reputation: 79 Joined: 12/04/12 Last Seen: September 26, 2019 Share Posted March 15, 2013 hello guys, i want to ask, i got a ton of item_db2.txt. how do i import all this to sql file ? is that an easy method can generate the txt to sql ? i want to make this because i want add my custom item in flux cp. please help me. thx. Quote Link to comment Share on other sites More sharing options...
Cydh Posted March 15, 2013 Group: Developer Topic Count: 153 Topics Per Day: 0.03 Content Count: 2285 Reputation: 747 Joined: 06/16/12 Last Seen: February 21 Share Posted March 15, 2013 here? http://rathena.org/board/topic/56376-rathena-database-editor/ 1 Quote Link to comment Share on other sites More sharing options...
Mootie Posted March 15, 2013 Group: Members Topic Count: 43 Topics Per Day: 0.01 Content Count: 815 Reputation: 86 Joined: 10/26/12 Last Seen: June 10, 2022 Share Posted March 15, 2013 INSERT INTO `item_db2` ( `id` , `name_english` , `name_japanese` , `type` , `price_buy` , `price_sell` , `weight` , `atk:matk` , `defence` , `range` , `slots` , `equip_jobs` , `equip_upper` , `equip_genders` , `equip_locations` , `weapon_level` , `equip_level` , `refineable` , `view` , `script` , `equip_script` , `unequip_script` ) VALUES ('22000', 'sample', 'sapmple', '5', '20', NULL , '10', NULL , NULL , NULL , '1', '4294967295', '7', '2', '512', NULL , NULL , '1', '937', '', '', ''), Quote Link to comment Share on other sites More sharing options...
mrlongshen Posted March 15, 2013 Group: Members Topic Count: 98 Topics Per Day: 0.02 Content Count: 1302 Reputation: 79 Joined: 12/04/12 Last Seen: September 26, 2019 Author Share Posted March 15, 2013 i have to enter it manuall ? aw. its pain bro. got easy method ? Quote Link to comment Share on other sites More sharing options...
DJFUNK Posted March 15, 2013 Group: Members Topic Count: 11 Topics Per Day: 0.00 Content Count: 115 Reputation: 4 Joined: 10/25/12 Last Seen: August 31, 2023 Share Posted March 15, 2013 import method sir Quote Link to comment Share on other sites More sharing options...
mrlongshen Posted March 16, 2013 Group: Members Topic Count: 98 Topics Per Day: 0.02 Content Count: 1302 Reputation: 79 Joined: 12/04/12 Last Seen: September 26, 2019 Author Share Posted March 16, 2013 Cydh. Thx alot. I forgot about this tools have sql. Thx alott Quote Link to comment Share on other sites More sharing options...
Cydh Posted March 16, 2013 Group: Developer Topic Count: 153 Topics Per Day: 0.03 Content Count: 2285 Reputation: 747 Joined: 06/16/12 Last Seen: February 21 Share Posted March 16, 2013 never mind. I just give the link Quote Link to comment Share on other sites More sharing options...
Question
mrlongshen
hello guys, i want to ask, i got a ton of item_db2.txt.
how do i import all this to sql file ?
is that an easy method can generate the txt to sql ?
i want to make this because i want add my custom item in flux cp.
please help me. thx.
Link to comment
Share on other sites
6 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.