which .sln file should i compile?
 

I'm trying to compile the code according to http://merlins-revenge.org/node/70
but I'm getting a lot of errors, so i just wanted to check that i should be using SERVER.SLN not EQEmuLoginServer.sln ?

EQEmuLoginServer.sln is for the login server that comes with EQEMU....

if getting a lot of errors, and the compile is failing... make sure you have ZLIB and your compiler has it listed in its libraries.... I've done this to myself a few times... :(

I've got zlib version 1.2.3
"C:\zlib" is in my "include files" as well as C:\zlib\include.
I just noticed one thing; the "library files" weren't setup as i didn't see the difference. I'm going to give that a go! I really hope this works :D

ack, same errors from Compiling...
logsys_eqemu.cpp
logsys.cpp
EQEmuConfig.cpp
EmuTCPServer.cpp
c:\documents and settings\owner\desktop\eqemu server files\trunk\eqemuserver\common\EmuTCPConnection.h( 23) : warning C4200: nonstandard extension used : zero-sized array in struct/union
Cannot generate copy-ctor or copy-assignment operator when UDT contains a zero-sized array

is it just my system or does anyone else get those?

These are not errors. They are warnings and will not prevent the compile from completing. I get these same errors. I'm sure most do. Ignore them. Are you getting executables when you are done?

The proper compiling guide is in the Wiki:
http://www.eqemulator.net/wiki/wikka.php?wakka=VS2008

Thanks for that Zandig, I'll follow it from here. I've only ever used VB.NET at a beginner level and this is a little mysterious!

I think I got the executables, not 100% sure but there's a Build directory under \EQEmu Server Files\trunk\EQEmuServer that has a blue ? next to it, which i assume means it's in the SVN folder but SVN doesn't know what to do with it.

I dropped my old database (goodbye old chars!) and am running peqdb_rev1549.sql ... the instructions on http://www.eqemulator.net/wiki/wikka.php?wakka=VS2008 say to run the sql in \EQEmu Server Files\trunk\EQEmuServer\utils\sql\svn

So does that mean the only SQL i need to run now is bots.sql
botsconvert.sql and 1562_instanced_spawnconditions.sql ? (not sure what botsconvert.sql is for tho)

I tried sourcing load_player.sql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 10
Server version: 5.0.85-community-nt MySQL Community Edition (GPL)

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> use PEQ
Database changed
mysql> source C:\t\load_player.sql
ERROR:
Failed to open file 'player_tables\aa_timers.sql', error: 2

mysql>
I tested it with another file and that woirked fine
mysql> source C:\t\t.sql
+------------+-------+------+
| type | npcID | temp |
+------------+-------+------+
| Animation1 | 500 | 0 |
+------------+-------+------+
1 row in set (0.00 sec)

mysql>
I tried it via HeidiSQL
USE `peq`;
/* Loading file "C:\t\load_player.sql" into query tab #1 ... */
source player_tables/aa_timers.sql;
/* SQL Error (1064): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'source player_tables/aa_timers.sql' at line 1 */

What should i do?

You are better off loading mysql from the directory where the .sql is located.

C:\>cd t
C:\t\>mysql -uroot -psomepass peq
mysql>source load_player.sql;

Thanks for that joligario!