ok ill tell you step by step for two posible options first one:
1.- copy you information and save it as a .sql file:
Code:
INSERT INTO `items` VALUES ('25', '2', '2', '-1', 'Worn Shortsword', 'Worn Shortsword', 'Worn Shortsword', 'Worn Shortsword', '1542', '1', '0', '35', '7', '21', '-1', '-1', '2', '1', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '3', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1900', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0', '1', '0', '0', '0', '1', '3', '0', '0', '0', '0', '20', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
2.-go to your database and right click into it and select "execute batch file"
3.- wait until finished then save database
4.- restart ascent server or type .reload items in game
5.- clean cache and its done
Now option 2 this is a little bit harder
1.- copy the following information and save it as a .txt :
Code:
25, 2, 2, -1, 'Worn Shortsword', 'Worn Shortsword', 'Worn Shortsword', 'Worn Shortsword', 1542, 1, 0, 35, 7, 21, -1, -1, 2, 1, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1900, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 1, 0, 0, 0, 1, 3, 0, 0, 0, 0, 20, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0
2.- open your items table and select import wizards
3.- select the option that says separate by commas
4.- click next until it select you to browse the .txt file
5.- click next then right click and select "direct match all"
6.-click next>> and let it finish
7.- wait until finished then save database
8.- restart ascent server or type .reload items in game
9.- clean cache and its done
Hope you get it
BTW worn shortsword entry ID (entry id 25) is already in use so you will need to replace the entry id of your custom worn shortsword or delete the existing one in your database