L2J Server

I see that bugs are found and fixed daily..

How would I go about updating the server without affecting the modifications I did, and the accounts/characters tables ?
(modifications I did was the html and teleport sql, all gatekeeper locations cost 500 adena)

Should I eclipse compile everytime ? run batch on specific sqls ?

Let me know how you do your weekly/monthly updates.

**Curently running Kamael rev:3627 I believe**

Using eclipse to update your datapack is perhaps the best way. Eclipse will attempt to merge your custom patches with the latest datapack. After that, you can build it.
You can copy all the files over your server's previous files.
For the SQL, you can run the database_installer file (bat or sh depending on your OS) and select to SKIP the loginserver installation, then UPDATE the gameserver. This will update your sql tables without affecting your accounts, characters, and everything related to those characters (quests, items, skills, clans, clan skills, etc etc etc).
Finally, we occasionally change the structure of tables. If such changes occur in tables related to the characters, you will have to update them separately. The database_installer will, in the very end, ask you if you wish to have it attempt to run those extra db update scripts, but I personally do not trust it for those. If you feel comfortable with SQL, I suggest manually running the scripts from the sql/updates/ folder, and only running the scripts which you know you haven't already ran in a previous update.

NOTE: Eclipse update will not always be 100% successful. Keep an eye out for reports of "Conflict" from eclipse. Whenever a conflict occurs, eclipse will generate some files with information like:
a) What was the original file like in the old revision
b) What is the original file in the latest revision
c) What is YOUR modified file
d) A file showing the latest revision with extra lines identifying parts from your modified file that do not properly fit into the latest.

You will have to manually re-apply your patches when conflicts occur. You can review those files in order to easier identify what changes you need to keep and how to re-patch.

Great !

I updated successfully and very easily aswell..
However.. Kamael village has no npc at all.. I'm guessing it's not normal, any clue as to where to go from here?

The Kamael village's spawns are present in the datapack. Perhaps something went wrong while running your spawnlist.sql
If you have custom spawns in there and eclipse had to merge your custom stuff with the DP stuff, you should doublecheck that there are no conflicts. Conflicts can cause "wierd stuff" to be written into the sql file, which will cause syntax errors. Syntax errors will cause the query to run until the error occurs, which would mean that you didn't import all the spawns...

If you do not have any custom spawns and haven't done any merging in Eclipse, you can try rightclicking on spawnlist.sql in eclipse, then select "replace with" and "latest from repository". Just execute the resulting spawnlist.sql in your mysql.