?
 

So you do not have to do this step then?

Sorry kind of confused now, the guide says..

***WARNING*** - You may run in to errors on some of the updates, (I ignored some), but
there is one you can not ignore: 1711_account_restricted_aa.sql
YOU NEED THIS UPDATE for your server to create accounts without errors.
If you get an error when sourcing that in, you can do this to help it along:

Open the 1711 file with Notepad++ and remove the first line (there is 3)
After removing that line, run the update again.
I CAN NOT help you with all the errors from the updates, but just search the forums for
any others.

You should always apply any updates where the code is newer than your installed database version, but since they currently match there is no need to do so.

Sql files
 

Ok thank you.

Ok I have these windows now, is this what I was suppose to be getting?

http://s1194.photobucket.com/albums/...t=eqemuser.jpg

If my server is up and running , how do I connect to it?

Thanks for those that helped
 

Think I will just try this at another time. Just too much to do and not enough info for me. Just wanted to actually create a LAN server, got forums mixed up. Read about the LAN setup and it is more confusing than this one.

It took me 4 days to get mine up and running, thank you so much for your guide =)

One more thing! I am very new to managing a server, any recommended reading?

Not too outdated...
 

Its been awhile since I was active around here, (school priorities), but even though my original guide posted here is a little outdated, most of it is the download links and rev. updates. I just downloaded all new fresh versions of both the compile source and peq, installing it on a windows vista box last night. (Oct 23rd, 2011) and I still had all the same apps I originally was using when I wrote this guide. (2008 C++ express, mysql 5.1, etc). I had absolutely no problems compiling the server and sourcing in the current database. Since it had been awhile that I played around with this, I had to refer back to this to refresh my memory on a few things, but I didn't have to do anything different than I used to. I also had no probs compiling all the newest updates on my debian linux box either, but THANK YOU to the devs for a lot of the updates you've done, especially the guild creation window. I love it!

My Attempt to do step 9
 

At Step 9 I get 5 succeeded 0 failed 0 up-to-date 0 skipped. But when I select release and build I get ========== Build: 3 succeeded, 2 failed, 0 up-to-date, 0 skipped ==========

The Errors are :
MMF.cpp(325) : warning C4532: 'return' : jump out of __finally block has undefined behavior during termination handling
httpsocket.cpp(115) : warning C4715: 'HTTPSocket::ProcessReceivedData' : not all control paths return a value
EQWParser.cpp(105) : error C2106: '=' : left operand must be l-value
EQWParser.cpp(108) : error C2106: '=' : left operand must be l-value
embperl.cpp(150) : error C2106: '=' : left operand must be l-value
embperl.cpp(153) : error C2106: '=' : left operand must be l-value
warning C4200: nonstandard extension used : zero-sized array in struct/unionCannot generate copy-ctor or copy-assignment operator when UDT contains a zero-sized array
EmuTCPServer.cpp one above
EmuTCPConnection.cpp many like above
ZoneLaunch.cpp one like above
worldserver.cpp many like above
eqlaunch.cpp many like above
worldconn.cpp many like above
tinyxmlparser.cpp warning C4996: 'strncpy': This function or variable may be unsafe. Consider using strncpy_s instead. To disable deprecation, use _CRT_SECURE_NO_WARNINGS. See online help for details. C:\Program Files (x86)\Microsoft Visual Studio 9.0\VC\include\string.h(157) : see declaration of 'strncpy'
tinyxmlerror.cpp warning C4996: 'strncpy': This function or variable may be unsafe. Consider using strncpy_s instead. To disable deprecation, use _CRT_SECURE_NO_WARNINGS. See online help for details. C:\Program Files (x86)\Microsoft Visual Studio 9.0\VC\include\string.h(157) : see declaration of 'strncpy'
tinyxml.cpp many like above
tinystr.cpp one like above
timer.cpp \common\timer.cpp(68) : warning C4244: '=' : conversion from 'time_t' to 'long', possible loss of data
TCPConnection.cpp many of the following c:\source\trunk\eqemuserver\common\../common/eq_packet_structs.h(429) : warning C4200: nonstandard extension used : zero-sized array in struct/union
4> Cannot generate copy-ctor or copy-assignment operator when UDT contains a zero-sized array
packet_dump.cpp many of the above
Mutex.cpp ..\common\Mutex.cpp(128) : warning C4800: 'BOOL' : forcing value to bool 'true' or 'false' (performance warning)
LINK : warning LNK4098: defaultlib 'LIBCMT' conflicts with use of other libs; use /NODEFAULTLIB:library

worldconn.cpp bunch like below c:\source\trunk\eqemuserver\common\../common/EmuTCPConnection.h(23) : warning C4200: nonstandard extension used : zero-sized array in struct/union
5> Cannot generate copy-ctor or copy-assignment operator when UDT contains a zero-sized array

rulesys.cpp many like below
c:\source\trunk\eqemuserver\common\eq_packet_struc ts.h(429) : warning C4200: nonstandard extension used : zero-sized array in struct/union
5> Cannot generate copy-ctor or copy-assignment operator when UDT contains a zero-sized array
also
..\common\rulesys.cpp(177) : warning C4244: '=' : conversion from 'double' to 'float', possible loss of data
5>c:\source\trunk\eqemuserver\common\ruletypes.h(4 0) : warning C4305: '=' : truncation from 'double' to 'float'

dbcore.cpp ..\common\dbcore.cpp(199) : warning C4244: '=' : conversion from 'my_ulonglong' to 'int32', possible loss of data

Most are warnings but only get 3 of 5.
Possibly due to ActivePerl-5.14.2.1402 ?
navicat100_mysql_en
VS2008ExpressWithSP1ENUX1504728 ?

After changing in the source to match perl 514 I still get these errors:

2>.\EQWParser.cpp(105) : error C2106: '=' : left operand must be l-value
2>.\EQWParser.cpp(108) : error C2106: '=' : left operand must be l-value

3>.\embperl.cpp(150) : error C2106: '=' : left operand must be l-value
3>.\embperl.cpp(153) : error C2106: '=' : left operand must be l-value

Still only 3 of 5 build Zone and World fail to build.

Dave

Yes, use perl 5.12.

You'll also need to edit the source code to use the proper libraries. Find in files for perl510, and change both lines it lists to perl512.

These are the lines you should see after your search:

Perl512
 

Where can I get it? ActivePerl is at 514.

Dave

http://www.activestate.com/activeperl/downloads

Look down.

I compiled the server files Note: Missing Registered patch House of Thule
From http://projecteqemu.googlecode.com/svn/
Downloaded Oct-2011

[WORLD__INIT] CURRENT_WORLD_VERSION:EQEmulator 0.8.0
[NET__IDENTIFY] Registered patch 6.2
[NET__IDENTIFY] Registered patch Titanium
[NET__IDENTIFY] Registered patch SoF
[NET__IDENTIFY] Registered patch SoD
[NET__IDENTIFY] Registered patch Underfoot

Added #include "HoT.h"
Added HoT::Register(into);
Added HoT::Reload();

Edit Patches.cpp Example: Z:\ServerFiles\trunk\EQEmuServer\common\patches

#include "../debug.h"
#include "patches.h"
#include "Client62.h"
#include "Titanium.h"
#include "Anniversary.h"
#include "Underfoot.h"
#include "SoF.h"
#include "SoD.h"
#include "HoT.h"

void RegisterAllPatches(EQStreamIdentifier &into) {
Client62::Register(into);
Titanium::Register(into);
SoF::Register(into);
SoD::Register(into);
Underfoot::Register(into);
HoT::Register(into);
}

void ReloadAllPatches() {
Client62::Reload();
Titanium::Reload();
SoF::Reload();
SoD::Reload();
Underfoot::Reload();
HoT::Reload();
}

I have no idea why it was remarked in the file patches.cpp so i added it back.
I'll be running some test on standalone server.

The HoT patch is commented out because it is not in a playable state. The HoT patch has a minimal set of working Opcodes/structs to get in game with the live client (well the live client as it was the last time I updated it a couple of months ago).

Note that the House Of Thule client from Steam is really what we would class as Underfoot, the only difference from the Underfoot Steam download is the CD key gives you access to the HoT expansion, if you should choose to open an account with SOE and patch up to EQLive.