Updating Server
 

Is there a Wiki article or anything that details the proper way to update the server (All of it) to the newest versions?

I know how to source in sql files from the SVN but here lately any updates I do result in the server going to shit (unable to log in, no gear, etc). I'm currently sitting with Rev245 (except for the respawn_timers update).

Any information is appreciated.

Since no one has even looked at this, thought I would clarify anyways.

I know how to source in the sql files and run queries. However, I know you are supposed to do something with the new World.exe, Zone.exe, etc files that come with the package.

What is that process?

You can learn to compile your own code and keep up-to-date by looking here:
http://www.eqemulator.net/wiki/wikka.php?wakka=VS2008

Do I need to recompile the code every time I download new binaries? (like going from r245 to r384)

If you are using the Binaries, you don't need to compile anything. If by "compile", you mean, sourcing the SQL for the database, then the answer is no. You don't need to source the whole database every time you update your binaries, but you can if you wanted to. Though, the best way to do it is just to make sure you make all of the SQL updates that came between the revisions of the code you were upgrading from and to. So, if you were going from R245 to R384, there would be a lot of SQL updates you would have to make. You would do all of the SQL updates from between R245 and R384. You can find most of the SQL updates in the /utils/sql/svn/ directory of the source code download. But, some of the updates are listed directly in the changelog.txt file itself, so make sure to read through that as well.

Like Trevius mentioned, you cannot compile binaries. When you update binaries, the only thing you need to do is check for database structure changes, which should be noted. Those changes can be sourced from SQL scripts which will take you very little time to perform in most cases.

Well I noticed when I download new binaries there is always copies of world.exe, zone.exe, patch.conf, etc. Are these just for people doing new installs?