Originally Posted by
brodie1600
Go into your 'vendors' table in SQLyog, HeidiSQL, or Navicat (or whatever you may use). Create an entry (the entry # will be your NPC ID), add the item ID, put the amount as 1, the max amount as 1. Then edit the inctime column as the time you wish to have the item come back in the vendor table (this number is in seconds).
As for the achievement part, you will need a DBC editor to edit the raw DBC files in your main server folder. This is a very difficult process considering the columns don't have names, only numbers. If you wish to create your own achievement, you will need to find a guide that tells you what each column represents.
And for the LUA scripting and boss sounds, I won't be able to help you. All I can say is that you will need a program such as Notepad++ for LUA editing, and the boss sounds will probably be able to be configured in your database (e.g. SQLyog).
Hope this helps!