New Server

[Plague]

http://eq2emulator.net/wiki/index.php/A ... ows_Binary
Using this guide.
0. Make sure to keep track of all user names and passwords for the various programs

1-3 Create accounts
http://eq2emulator.net/phpBB3/ucp.php?mode=register
http://eq2emulator.net/portal/index.php?p=account

4. Download SVN (Used TortoiseSVN) and unzip (7zip)
4.1 https://tortoisesvn.net/downloads.html
4.2 http://7-zip.org/download.html
https://svn.eq2emulator.net/svn/eq2server
https://svn.eq2emulator.net/svn/eq2content
https://svn.eq2emulator.net/svn/eq2tools

6. Install MySQL
mysql-installer-web-community-5.7.20.0.msi
6.1 I pretty much guessed at the install configuration as I could not find a guide.
6.2 Clicked Server only tho was tempted for full install to be sure.
6.3 clicked Standalone MySQL Server
6.4 Dropdown to Server Machine
6.5 Left everything else default

7. Install HeidiSQL (or other gui) and log in to your MySQL database.
https://www.heidisql.com/download.php?d ... =installer
7.2 Create a database with the name eq2 (Right click > Create new > Database)
7.3 Create a User/password under tools > user-manager
7.4 "Allow access to" eq2 database (Had to add object first)
(Thinking at this point I missed something because my eq2 database is empty)

8 Open world_db.ini
8.1 [Database]
host=localhost
user=
password=
database=eq2
9 Open LoginServer.ini
9.1 worldname=
9.1.1 Easy enough
9.2 External_IP_HERE
9.2.1 Yah not sure bout this one yet
9.3 Account=
Password=
9.3.1 Easy enough

10 Start eq2world
Of course you know by now this did not work. Suspect I screwed up something along the way seeing as my database is empty. Any Hints on how to fix would be nice

[Jabantiz]

Did you compile your own server? Also if you did you need to set the update port to 9104 in the loginserver.ini for the new DB patcher it uses.

[Plague]

was an older guide for precompiled considering attempting to compile my own atm.

[Plague]

Guide = http://eq2emulator.net/wiki/index.php/A ... ows_Server
SVN = https://svn.eq2emulator.net/svn/eq2server
Visual Studio 2017 Community Edition is taking a long time to install, then ill try to compile my own.

[Plague]

https://svn.eq2emulator.net/svn/eq2server
1. EQ2WorldVC10.sln
2.Under the VC++ Directories

• Include directories
  • $(SolutionDir)..\source\depends\mysql-5.1.45-win32\include
    $(SolutionDir)..\source\depends\zlib\include
  Library directories
  • $(SolutionDir)..\source\depends\mysql-5.1.45-win32\lib\opt
    $(SolutionDir)..\source\depends\zlib\lib

3. Compile

Received these two errors one time each

Code: Select all

Error	C3688	invalid literal suffix 'EXE_NAME'; literal operator or literal operator template 'operator ""EXE_NAME' not found
Error	C2664	'int _snprintf(char *const ,const ::size_t,const char *const ,...)': cannot convert argument 3 from 'int' to 'const char *const '	

[Jabantiz]

Did you add the MySQL stuff to the include/library directories? New server source should be using mariaDb (spin off of MySQL so compatible with each other) however the MySQL in the depends folder is so old it won't compile with new compilers, one of the main reason it was switched to maria.

Received these two errors one time each

Code: Select all

Error	C3688	invalid literal suffix 'EXE_NAME'; literal operator or literal operator template 'operator ""EXE_NAME' not found
Error	C2664	'int _snprintf(char *const ,const ::size_t,const char *const ,...)': cannot convert argument 3 from 'int' to 'const char *const '	

/sigh, I have fixed this about 4 times now not sure how it keeps coming back. basically in whatever file the error is coming from has something like this

Code: Select all

" "EXE_NAME" "

however there needs to be spaces between the quotes and EXE_NAME like this

Code: Select all

" " EXE_NAME " "

Stupid minor change but I have been doing it repeatedly for some reason.

[Plague]

I did not add anything to the include libraries as they were already populated I just changed them from the win32 to winx64 versions.

[Jabantiz]

Ok this is odd, the files I have from svn all point to "mariadb-10.1.19" folder, not the "mysql-5.1.45-win32" folder. Also there is no need to change it to 64 as there are build configurations for both 32 and 64 releasa and debug linking to the correct versions of the libs.

Do you see any of the newer files in the solution like zone/SPGrid.cpp or Trade.cpp or Bots/Bot.cpp? if not in the solution are they in the source folder?

EDIT:
https://svn.eq2emulator.net/!/#eq2serve ... ld.vcxproj

Around line 100 you can see mariadb, no clue how you got files with mysql

[Plague]

My \source\depends\ only contains 3 folders zlib, mysql-5.1.45-winx64, and mysql-5.1.45-win32

This is the EQ2World.vcxproj I ended up with and the depends point to MySQL.

Code: Select all

<?xml version="1.0" encoding="utf-8"?>
<Project DefaultTargets="Build" ToolsVersion="15.0" xmlns="http://schemas.microsoft.com/developer/msbuild/2003">
  <ItemGroup Label="ProjectConfigurations">
    <ProjectConfiguration Include="Release|Win32">
      <Configuration>Release</Configuration>
      <Platform>Win32</Platform>
    </ProjectConfiguration>
    <ProjectConfiguration Include="Release|x64">
      <Configuration>Release</Configuration>
      <Platform>x64</Platform>
    </ProjectConfiguration>
    <ProjectConfiguration Include="Debug|Win32">
      <Configuration>Debug</Configuration>
      <Platform>Win32</Platform>
    </ProjectConfiguration>
    <ProjectConfiguration Include="Debug|x64">
      <Configuration>Debug</Configuration>
      <Platform>x64</Platform>
    </ProjectConfiguration>
  </ItemGroup>
  <PropertyGroup Label="Globals">
    <ProjectName>EQ2World</ProjectName>
    <ProjectGuid>{FC063D75-089D-4470-B255-032A80DE3CCE}</ProjectGuid>
    <RootNamespace>EQ2World</RootNamespace>
    <WindowsTargetPlatformVersion>10.0.16299.0</WindowsTargetPlatformVersion>
  </PropertyGroup>
  <Import Project="$(VCTargetsPath)\Microsoft.Cpp.Default.props" />
  <PropertyGroup Condition="'$(Configuration)|$(Platform)'=='Release|Win32'" Label="Configuration">
    <ConfigurationType>Application</ConfigurationType>
    <UseOfMfc>false</UseOfMfc>
    <CharacterSet>MultiByte</CharacterSet>
    <PlatformToolset>v141</PlatformToolset>
  </PropertyGroup>
  <PropertyGroup Condition="'$(Configuration)|$(Platform)'=='Debug|Win32'" Label="Configuration">
    <ConfigurationType>Application</ConfigurationType>
    <UseOfMfc>false</UseOfMfc>
    <CharacterSet>MultiByte</CharacterSet>
    <WholeProgramOptimization>false</WholeProgramOptimization>
    <PlatformToolset>v141</PlatformToolset>
  </PropertyGroup>
  <PropertyGroup Condition="'$(Configuration)|$(Platform)'=='Release|x64'" Label="Configuration">
    <ConfigurationType>Application</ConfigurationType>
    <UseOfMfc>false</UseOfMfc>
    <CharacterSet>MultiByte</CharacterSet>
    <PlatformToolset>v141</PlatformToolset>
  </PropertyGroup>
  <PropertyGroup Condition="'$(Configuration)|$(Platform)'=='Debug|x64'" Label="Configuration">
    <ConfigurationType>Application</ConfigurationType>
    <UseOfMfc>false</UseOfMfc>
    <CharacterSet>MultiByte</CharacterSet>
    <WholeProgramOptimization>false</WholeProgramOptimization>
    <PlatformToolset>v141</PlatformToolset>
  </PropertyGroup>
  <Import Project="$(VCTargetsPath)\Microsoft.Cpp.props" />
  <ImportGroup Label="ExtensionSettings">
  </ImportGroup>
  <ImportGroup Condition="'$(Configuration)|$(Platform)'=='Release|Win32'" Label="PropertySheets">
    <Import Project="$(UserRootDir)\Microsoft.Cpp.$(Platform).user.props" Condition="exists('$(UserRootDir)\Microsoft.Cpp.$(Platform).user.props')" Label="LocalAppDataPlatform" />
    <Import Project="$(VCTargetsPath)Microsoft.CPP.UpgradeFromVC71.props" />
  </ImportGroup>
  <ImportGroup Condition="'$(Configuration)|$(Platform)'=='Debug|Win32'" Label="PropertySheets">
    <Import Project="$(UserRootDir)\Microsoft.Cpp.$(Platform).user.props" Condition="exists('$(UserRootDir)\Microsoft.Cpp.$(Platform).user.props')" Label="LocalAppDataPlatform" />
    <Import Project="$(VCTargetsPath)Microsoft.CPP.UpgradeFromVC71.props" />
  </ImportGroup>
  <ImportGroup Condition="'$(Configuration)|$(Platform)'=='Release|x64'" Label="PropertySheets">
    <Import Project="$(UserRootDir)\Microsoft.Cpp.$(Platform).user.props" Condition="exists('$(UserRootDir)\Microsoft.Cpp.$(Platform).user.props')" Label="LocalAppDataPlatform" />
    <Import Project="$(VCTargetsPath)Microsoft.CPP.UpgradeFromVC71.props" />
  </ImportGroup>
  <ImportGroup Condition="'$(Configuration)|$(Platform)'=='Debug|x64'" Label="PropertySheets">
    <Import Project="$(UserRootDir)\Microsoft.Cpp.$(Platform).user.props" Condition="exists('$(UserRootDir)\Microsoft.Cpp.$(Platform).user.props')" Label="LocalAppDataPlatform" />
    <Import Project="$(VCTargetsPath)Microsoft.CPP.UpgradeFromVC71.props" />
  </ImportGroup>
  <PropertyGroup Label="UserMacros" />
  <PropertyGroup>
    <_ProjectFileVersion>10.0.30319.1</_ProjectFileVersion>
    <OutDir Condition="'$(Configuration)|$(Platform)'=='Debug|Win32'">$(SolutionDir)worldserver\</OutDir>
    <IntDir Condition="'$(Configuration)|$(Platform)'=='Debug|Win32'">.\$(ProjectName)__Debug\</IntDir>
    <LinkIncremental Condition="'$(Configuration)|$(Platform)'=='Debug|Win32'">false</LinkIncremental>
    <OutDir Condition="'$(Configuration)|$(Platform)'=='Debug|x64'">$(SolutionDir)worldserver\</OutDir>
    <IntDir Condition="'$(Configuration)|$(Platform)'=='Debug|x64'">.\$(ProjectName)__Debug_$(Platform)\</IntDir>
    <LinkIncremental Condition="'$(Configuration)|$(Platform)'=='Debug|x64'">false</LinkIncremental>
    <OutDir Condition="'$(Configuration)|$(Platform)'=='Release|Win32'">.\..\..\bin\</OutDir>
    <IntDir Condition="'$(Configuration)|$(Platform)'=='Release|Win32'">.\$(ProjectName)__$(Configuration)_$(PlatformName)\</IntDir>
    <OutDir Condition="'$(Configuration)|$(Platform)'=='Release|x64'">.\..\..\bin\</OutDir>
    <IntDir Condition="'$(Configuration)|$(Platform)'=='Release|x64'">.\$(ProjectName)__$(Configuration)_$(PlatformName)\</IntDir>
    <LinkIncremental Condition="'$(Configuration)|$(Platform)'=='Release|x64'">true</LinkIncremental>
    <CodeAnalysisRuleSet Condition="'$(Configuration)|$(Platform)'=='Release|Win32'">AllRules.ruleset</CodeAnalysisRuleSet>
    <CodeAnalysisRules Condition="'$(Configuration)|$(Platform)'=='Release|Win32'" />
    <CodeAnalysisRuleAssemblies Condition="'$(Configuration)|$(Platform)'=='Release|Win32'" />
    <CodeAnalysisRuleSet Condition="'$(Configuration)|$(Platform)'=='Release|x64'">AllRules.ruleset</CodeAnalysisRuleSet>
    <CodeAnalysisRules Condition="'$(Configuration)|$(Platform)'=='Release|x64'" />
    <CodeAnalysisRuleAssemblies Condition="'$(Configuration)|$(Platform)'=='Release|x64'" />
    <CodeAnalysisRuleSet Condition="'$(Configuration)|$(Platform)'=='Debug|Win32'">AllRules.ruleset</CodeAnalysisRuleSet>
    <CodeAnalysisRules Condition="'$(Configuration)|$(Platform)'=='Debug|Win32'" />
    <CodeAnalysisRuleAssemblies Condition="'$(Configuration)|$(Platform)'=='Debug|Win32'" />
    <CodeAnalysisRuleSet Condition="'$(Configuration)|$(Platform)'=='Debug|x64'">AllRules.ruleset</CodeAnalysisRuleSet>
    <CodeAnalysisRules Condition="'$(Configuration)|$(Platform)'=='Debug|x64'" />
    <CodeAnalysisRuleAssemblies Condition="'$(Configuration)|$(Platform)'=='Debug|x64'" />
    <TargetName Condition="'$(Configuration)|$(Platform)'=='Debug|x64'">$(ProjectName)__Debug_$(Platform)</TargetName>
    <IncludePath Condition="'$(Configuration)|$(Platform)'=='Debug|x64'">$(SolutionDir)..\source\depends\mysql-5.1.45-winx64\include;$(SolutionDir)..\source\depends\zlib\include;$(IncludePath)</IncludePath>
    <IncludePath Condition="'$(Configuration)|$(Platform)'=='Release|x64'">$(SolutionDir)..\source\depends\mysql-5.1.45-winx64\include;$(SolutionDir)..\source\depends\zlib\include;$(IncludePath)</IncludePath>
    <LibraryPath Condition="'$(Configuration)|$(Platform)'=='Release|x64'">$(SolutionDir)..\source\depends\mysql-5.1.45-winx64\lib\opt;$(SolutionDir)..\source\depends\zlib\lib;$(LibraryPath)</LibraryPath>
    <LibraryPath Condition="'$(Configuration)|$(Platform)'=='Debug|x64'">$(SolutionDir)..\source\depends\mysql-5.1.45-winx64\lib\opt;$(SolutionDir)..\source\depends\zlib\lib;$(LibraryPath)</LibraryPath>
    <IncludePath Condition="'$(Configuration)|$(Platform)'=='Release|Win32'">$(SolutionDir)..\source\depends\mysql-5.1.45-win32\include;$(SolutionDir)..\source\depends\zlib\include;$(IncludePath)</IncludePath>
    <LibraryPath Condition="'$(Configuration)|$(Platform)'=='Release|Win32'">$(SolutionDir)..\source\depends\mysql-5.1.45-win32\lib\opt;$(SolutionDir)..\source\depends\zlib\lib;$(LibraryPath)</LibraryPath>
    <IncludePath Condition="'$(Configuration)|$(Platform)'=='Debug|Win32'">$(SolutionDir)..\source\depends\mysql-5.1.45-win32\include;$(SolutionDir)..\source\depends\zlib\include;$(IncludePath)</IncludePath>
    <LibraryPath Condition="'$(Configuration)|$(Platform)'=='Debug|Win32'">$(SolutionDir)..\source\depends\mysql-5.1.45-win32\lib\opt;$(SolutionDir)..\source\depends\zlib\lib;$(LibraryPath)</LibraryPath>
    <TargetName Condition="'$(Configuration)|$(Platform)'=='Debug|Win32'">$(ProjectName)__Debug</TargetName>
    <GenerateManifest Condition="'$(Configuration)|$(Platform)'=='Debug|x64'">false</GenerateManifest>
  </PropertyGroup>
  <ItemDefinitionGroup Condition="'$(Configuration)|$(Platform)'=='Debug|Win32'">
    <Midl>
      <TypeLibraryName>.\../build/World.tlb</TypeLibraryName>
    </Midl>
    <ClCompile>
      <Optimization>Disabled</Optimization>
      <PreprocessorDefinitions>WORLD;DEBUG;_EQDEBUG;_WIN32_WINNT=0x0400;WIN32;_CONSOLE;EQ2;EQN_DEBUG;_CRT_SECURE_NO_DEPRECATE;%(PreprocessorDefinitions)</PreprocessorDefinitions>
      <ExceptionHandling>Async</ExceptionHandling>
      <BasicRuntimeChecks>EnableFastChecks</BasicRuntimeChecks>
      <RuntimeLibrary>MultiThreadedDebug</RuntimeLibrary>
      <BufferSecurityCheck>true</BufferSecurityCheck>
      <FunctionLevelLinking>true</FunctionLevelLinking>
      <PrecompiledHeader>NotUsing</PrecompiledHeader>
      <PrecompiledHeaderOutputFile>
      </PrecompiledHeaderOutputFile>
      <AssemblerListingLocation>$(IntDir)</AssemblerListingLocation>
      <ObjectFileName>$(IntDir)</ObjectFileName>
      <ProgramDataBaseFileName>$(IntDir)</ProgramDataBaseFileName>
      <XMLDocumentationFileName>$(IntDir)</XMLDocumentationFileName>
      <BrowseInformation>
      </BrowseInformation>
      <WarningLevel>Level1</WarningLevel>
      <SuppressStartupBanner>true</SuppressStartupBanner>
      <DebugInformationFormat>ProgramDatabase</DebugInformationFormat>
      <CompileAs>CompileAsCpp</CompileAs>
      <DisableSpecificWarnings>4996;%(DisableSpecificWarnings)</DisableSpecificWarnings>
      <ShowIncludes>false</ShowIncludes>
      <ErrorReporting>Prompt</ErrorReporting>
      <PrecompiledHeaderFile>
      </PrecompiledHeaderFile>
      <BrowseInformationFile>
      </BrowseInformationFile>
    </ClCompile>
    <ResourceCompile>
      <PreprocessorDefinitions>_DEBUG;%(PreprocessorDefinitions)</PreprocessorDefinitions>
      <Culture>0x0409</Culture>
    </ResourceCompile>
    <Link>
      <AdditionalOptions>/MACHINE:I386  %(AdditionalOptions)</AdditionalOptions>
      <AdditionalDependencies>odbc32.lib;odbccp32.lib;wsock32.lib;zlib.lib;mysqlclient.lib;lua5.1.lib;%(AdditionalDependencies)</AdditionalDependencies>
      <SuppressStartupBanner>true</SuppressStartupBanner>
      <AdditionalLibraryDirectories>..\..\source\LUA</AdditionalLibraryDirectories>
      <ManifestFile>$(IntDir)$(TargetName).intermediate.manifest</ManifestFile>
      <IgnoreSpecificDefaultLibraries>LIBCMT;LIBC;%(IgnoreSpecificDefaultLibraries)</IgnoreSpecificDefaultLibraries>
      <GenerateDebugInformation>true</GenerateDebugInformation>
      <ProgramDatabaseFile>$(IntDir)$(TargetName).pdb</ProgramDatabaseFile>
      <GenerateMapFile>false</GenerateMapFile>
      <MapExports>false</MapExports>
      <SubSystem>
      </SubSystem>
      <RandomizedBaseAddress>false</RandomizedBaseAddress>
      <FixedBaseAddress>
      </FixedBaseAddress>
      <DataExecutionPrevention>
      </DataExecutionPrevention>
      <TargetMachine>MachineX86</TargetMachine>
      <LinkErrorReporting>PromptImmediately</LinkErrorReporting>
      <OptimizeReferences>true</OptimizeReferences>
      <EnableCOMDATFolding>true</EnableCOMDATFolding>
      <LinkTimeCodeGeneration>
      </LinkTimeCodeGeneration>
      <ProfileGuidedDatabase>$(IntDir)$(TargetName).pgd</ProfileGuidedDatabase>
      <OutputFile>$(OutDir)$(TargetName)$(TargetExt)</OutputFile>
    </Link>
    <PreBuildEvent />
    <PostBuildEvent>
      <Command>
      </Command>
    </PostBuildEvent>
    <Bscmake>
      <SuppressStartupBanner>false</SuppressStartupBanner>
    </Bscmake>
    <Bscmake>
      <OutputFile>
      </OutputFile>
    </Bscmake>
  </ItemDefinitionGroup>
  <ItemDefinitionGroup Condition="'$(Configuration)|$(Platform)'=='Debug|x64'">
    <Midl>
      <TargetEnvironment>X64</TargetEnvironment>
      <TypeLibraryName>.\../build/World.tlb</TypeLibraryName>
    </Midl>
    <ClCompile>
      <Optimization>Disabled</Optimization>
      <PreprocessorDefinitions>WORLD;_DEBUG;_EQDEBUG;_WIN32_WINNT=0x0400;WIN32;_CONSOLE;EQ2;EQN_DEBUG;_CRT_SECURE_NO_DEPRECATE;%(PreprocessorDefinitions)</PreprocessorDefinitions>
      <ExceptionHandling>Sync</ExceptionHandling>
      <BasicRuntimeChecks>EnableFastChecks</BasicRuntimeChecks>
      <RuntimeLibrary>MultiThreadedDebug</RuntimeLibrary>
      <BufferSecurityCheck>true</BufferSecurityCheck>
      <FunctionLevelLinking>false</FunctionLevelLinking>
      <PrecompiledHeader>NotUsing</PrecompiledHeader>
      <PrecompiledHeaderOutputFile>
      </PrecompiledHeaderOutputFile>
      <AssemblerListingLocation>$(IntDir)</AssemblerListingLocation>
      <ObjectFileName>$(IntDir)</ObjectFileName>
      <ProgramDataBaseFileName>$(IntDir)</ProgramDataBaseFileName>
      <BrowseInformation>false</BrowseInformation>
      <SuppressStartupBanner>true</SuppressStartupBanner>
      <DebugInformationFormat>ProgramDatabase</DebugInformationFormat>
      <DisableSpecificWarnings>4996;%(DisableSpecificWarnings)</DisableSpecificWarnings>
      <ShowIncludes>false</ShowIncludes>
      <InlineFunctionExpansion>AnySuitable</InlineFunctionExpansion>
      <MinimalRebuild>true</MinimalRebuild>
      <RuntimeTypeInfo>false</RuntimeTypeInfo>
      <PrecompiledHeaderFile>
      </PrecompiledHeaderFile>
    </ClCompile>
    <ResourceCompile>
      <PreprocessorDefinitions>_DEBUG;%(PreprocessorDefinitions)</PreprocessorDefinitions>
      <Culture>0x0409</Culture>
    </ResourceCompile>
    <Link>
      <AdditionalDependencies>odbc32.lib;odbccp32.lib;wsock32.lib;Zlibx64_debug.lib;mysqlclient_debug.lib;LUALibx64_debug.lib;%(AdditionalDependencies)</AdditionalDependencies>
      <SuppressStartupBanner>true</SuppressStartupBanner>
      <AdditionalLibraryDirectories>..\..\source\LUA</AdditionalLibraryDirectories>
      <IgnoreSpecificDefaultLibraries>LIBCMT;LIBC;%(IgnoreSpecificDefaultLibraries)</IgnoreSpecificDefaultLibraries>
      <GenerateDebugInformation>true</GenerateDebugInformation>
      <ProgramDatabaseFile>$(IntDir)$(TargetName).pdb</ProgramDatabaseFile>
      <SubSystem>
      </SubSystem>
      <RandomizedBaseAddress>false</RandomizedBaseAddress>
      <FixedBaseAddress>
      </FixedBaseAddress>
      <DataExecutionPrevention>
      </DataExecutionPrevention>
      <TargetMachine>MachineX64</TargetMachine>
      <OptimizeReferences>true</OptimizeReferences>
      <EnableCOMDATFolding>true</EnableCOMDATFolding>
      <LinkTimeCodeGeneration>Default</LinkTimeCodeGeneration>
      <ProfileGuidedDatabase>$(IntDir)$(TargetName).pgd</ProfileGuidedDatabase>
      <ManifestFile>
      </ManifestFile>
      <LinkErrorReporting>PromptImmediately</LinkErrorReporting>
      <AdditionalOptions>/ignore:4099 %(AdditionalOptions)</AdditionalOptions>
    </Link>
    <ProjectReference>
      <LinkLibraryDependencies>true</LinkLibraryDependencies>
    </ProjectReference>
    <PreBuildEvent />
    <PostBuildEvent>
      <Command>
      </Command>
    </PostBuildEvent>
  </ItemDefinitionGroup>
  <ItemDefinitionGroup Condition="'$(Configuration)|$(Platform)'=='Release|Win32'">
    <Midl>
      <TypeLibraryName>.\../build/World.tlb</TypeLibraryName>
    </Midl>
    <ClCompile>
      <InlineFunctionExpansion>AnySuitable</InlineFunctionExpansion>
      <PreprocessorDefinitions>_WIN32_WINNT=0x0400;WIN32;NDEBUG;_CONSOLE;WORLD;EQ2;_CRT_SECURE_NO_DEPRECATE;%(PreprocessorDefinitions)</PreprocessorDefinitions>
      <StringPooling>true</StringPooling>
      <ExceptionHandling>Sync</ExceptionHandling>
      <RuntimeLibrary>MultiThreaded</RuntimeLibrary>
      <BufferSecurityCheck>false</BufferSecurityCheck>
      <FunctionLevelLinking>false</FunctionLevelLinking>
      <PrecompiledHeader>NotUsing</PrecompiledHeader>
      <PrecompiledHeaderOutputFile>
      </PrecompiledHeaderOutputFile>
      <AssemblerListingLocation>$(IntDir)</AssemblerListingLocation>
      <ObjectFileName>$(IntDir)</ObjectFileName>
      <ProgramDataBaseFileName>$(IntDir)</ProgramDataBaseFileName>
      <BrowseInformation>false</BrowseInformation>
      <SuppressStartupBanner>true</SuppressStartupBanner>
      <DebugInformationFormat>ProgramDatabase</DebugInformationFormat>
      <Optimization>Full</Optimization>
      <IntrinsicFunctions>true</IntrinsicFunctions>
      <FavorSizeOrSpeed>Speed</FavorSizeOrSpeed>
      <OmitFramePointers>true</OmitFramePointers>
      <WholeProgramOptimization>true</WholeProgramOptimization>
      <FloatingPointModel>Fast</FloatingPointModel>
      <PrecompiledHeaderFile>
      </PrecompiledHeaderFile>
    </ClCompile>
    <ResourceCompile>
      <PreprocessorDefinitions>NDEBUG;%(PreprocessorDefinitions)</PreprocessorDefinitions>
      <Culture>0x0409</Culture>
    </ResourceCompile>
    <Link>
      <AdditionalOptions>/MACHINE:I386 %(AdditionalOptions)</AdditionalOptions>
      <AdditionalDependencies>odbc32.lib;odbccp32.lib;wsock32.lib;zlib.lib;mysqlclient.lib;lua5.1.lib;%(AdditionalDependencies)</AdditionalDependencies>
      <OutputFile>$(OutDir)$(TargetName)$(TargetExt)</OutputFile>
      <SuppressStartupBanner>true</SuppressStartupBanner>
      <AdditionalLibraryDirectories>..\..\source\LUA</AdditionalLibraryDirectories>
      <IgnoreSpecificDefaultLibraries>libc;msvcrt;libcmtd;%(IgnoreSpecificDefaultLibraries)</IgnoreSpecificDefaultLibraries>
      <GenerateDebugInformation>true</GenerateDebugInformation>
      <ProgramDatabaseFile>$(IntDir)$(TargetName).pdb</ProgramDatabaseFile>
      <GenerateMapFile>false</GenerateMapFile>
      <MapFileName>
      </MapFileName>
      <SubSystem>
      </SubSystem>
      <RandomizedBaseAddress>false</RandomizedBaseAddress>
      <DataExecutionPrevention>
      </DataExecutionPrevention>
      <OptimizeReferences>true</OptimizeReferences>
      <EnableCOMDATFolding>true</EnableCOMDATFolding>
      <LinkTimeCodeGeneration>UseLinkTimeCodeGeneration</LinkTimeCodeGeneration>
      <ProfileGuidedDatabase>$(IntDir)$(TargetName).pgd</ProfileGuidedDatabase>
      <ManifestFile>$(IntDir)$(TargetName).intermediate.manifest</ManifestFile>
      <LinkErrorReporting>PromptImmediately</LinkErrorReporting>
    </Link>
    <PreBuildEvent />
    <PostBuildEvent>
      <Command>
      </Command>
    </PostBuildEvent>
  </ItemDefinitionGroup>
  <ItemDefinitionGroup Condition="'$(Configuration)|$(Platform)'=='Release|x64'">
    <Midl>
      <TargetEnvironment>X64</TargetEnvironment>
      <TypeLibraryName>.\../build/World.tlb</TypeLibraryName>
    </Midl>
    <ClCompile>
      <Optimization>Disabled</Optimization>
      <InlineFunctionExpansion>AnySuitable</InlineFunctionExpansion>
      <PreprocessorDefinitions>_WIN32_WINNT=0x0400;WIN32;NDEBUG;_CONSOLE;WORLD;EQ2;_CRT_SECURE_NO_DEPRECATE;%(PreprocessorDefinitions)</PreprocessorDefinitions>
      <StringPooling>true</StringPooling>
      <ExceptionHandling>Sync</ExceptionHandling>
      <RuntimeLibrary>MultiThreaded</RuntimeLibrary>
      <BufferSecurityCheck>false</BufferSecurityCheck>
      <FunctionLevelLinking>false</FunctionLevelLinking>
      <PrecompiledHeader>NotUsing</PrecompiledHeader>
      <PrecompiledHeaderOutputFile>
      </PrecompiledHeaderOutputFile>
      <AssemblerListingLocation>$(IntDir)</AssemblerListingLocation>
      <ObjectFileName>$(IntDir)</ObjectFileName>
      <ProgramDataBaseFileName>$(IntDir)</ProgramDataBaseFileName>
      <BrowseInformation>
      </BrowseInformation>
      <SuppressStartupBanner>true</SuppressStartupBanner>
      <DebugInformationFormat>ProgramDatabase</DebugInformationFormat>
      <MinimalRebuild>false</MinimalRebuild>
      <BasicRuntimeChecks>Default</BasicRuntimeChecks>
      <RuntimeTypeInfo>
      </RuntimeTypeInfo>
      <PrecompiledHeaderFile>
      </PrecompiledHeaderFile>
    </ClCompile>
    <ResourceCompile>
      <PreprocessorDefinitions>NDEBUG;%(PreprocessorDefinitions)</PreprocessorDefinitions>
      <Culture>0x0409</Culture>
    </ResourceCompile>
    <ProjectReference>
      <LinkLibraryDependencies>true</LinkLibraryDependencies>
    </ProjectReference>
    <Link>
      <AdditionalDependencies>LUALibx64_release.lib;ws2_32.lib;Zlibx64_release.lib;mysqlclientx64_release.lib;%(AdditionalDependencies)</AdditionalDependencies>
      <OutputFile>$(OutDir)$(TargetName)_$(Platform)$(TargetExt)</OutputFile>
      <SuppressStartupBanner>true</SuppressStartupBanner>
      <AdditionalLibraryDirectories>..\..\source\LUA</AdditionalLibraryDirectories>
      <IgnoreSpecificDefaultLibraries>libc.lib; msvcrt.lib; libcd.lib; libcmtd.lib; msvcrtd.lib;%(IgnoreSpecificDefaultLibraries)</IgnoreSpecificDefaultLibraries>
      <GenerateDebugInformation>true</GenerateDebugInformation>
      <ProgramDatabaseFile>$(IntDir)$(TargetName)__$(Configuration)_$(Platform).pdb</ProgramDatabaseFile>
      <GenerateMapFile>false</GenerateMapFile>
      <MapFileName>
      </MapFileName>
      <SubSystem>
      </SubSystem>
      <RandomizedBaseAddress>false</RandomizedBaseAddress>
      <DataExecutionPrevention>
      </DataExecutionPrevention>
      <TargetMachine>MachineX64</TargetMachine>
      <OptimizeReferences>true</OptimizeReferences>
      <EnableCOMDATFolding>true</EnableCOMDATFolding>
      <LinkTimeCodeGeneration>UseLinkTimeCodeGeneration</LinkTimeCodeGeneration>
      <ManifestFile>$(IntDir)$(TargetName)__$(Configuration)_$(Platform).intermediate.manifest</ManifestFile>
      <ProfileGuidedDatabase>$(IntDir)$(TargetName)__$(Configuration)_$(Platform).pgd</ProfileGuidedDatabase>
      <LinkErrorReporting>PromptImmediately</LinkErrorReporting>
    </Link>
    <PreBuildEvent />
    <PostBuildEvent>
      <Command>
      </Command>
    </PostBuildEvent>
  </ItemDefinitionGroup>
  <ItemGroup>
    <ClCompile Include="..\..\source\common\DatabaseNew.cpp" />
    <ClCompile Include="..\..\source\common\DatabaseResult.cpp" />
    <ClCompile Include="..\..\source\WorldServer\Achievements\Achievements.cpp" />
    <ClCompile Include="..\..\source\WorldServer\Achievements\AchievementsDB.cpp" />
    <ClCompile Include="..\..\source\WorldServer\AltAdvancement\AltAdvancement.cpp" />
    <ClCompile Include="..\..\source\WorldServer\AltAdvancement\AltAdvancementDB.cpp" />
    <ClCompile Include="..\..\source\WorldServer\Chat\Chat.cpp" />
    <ClCompile Include="..\..\source\WorldServer\Chat\ChatChannel.cpp" />
    <ClCompile Include="..\..\source\WorldServer\Chat\ChatDB.cpp" />
    <ClCompile Include="..\..\source\WorldServer\classes.cpp" />
    <ClCompile Include="..\..\source\WorldServer\client.cpp" />
    <ClCompile Include="..\..\source\WorldServer\ClientPacketFunctions.cpp" />
    <ClCompile Include="..\..\source\WorldServer\Collections\Collections.cpp" />
    <ClCompile Include="..\..\source\WorldServer\Collections\CollectionsDB.cpp" />
    <ClCompile Include="..\..\source\WorldServer\Combat.cpp" />
    <ClCompile Include="..\..\source\WorldServer\Commands\CommandsDB.cpp" />
    <ClCompile Include="..\..\source\WorldServer\Entity.cpp" />
    <ClCompile Include="..\..\source\WorldServer\Factions.cpp" />
    <ClCompile Include="..\..\source\WorldServer\GroundSpawn.cpp" />
    <ClCompile Include="..\..\source\WorldServer\Guilds\Guild.cpp" />
    <ClCompile Include="..\..\source\WorldServer\Guilds\GuildDB.cpp" />
    <ClCompile Include="..\..\source\WorldServer\Housing\HousingDB.cpp" />
    <ClCompile Include="..\..\source\WorldServer\Housing\HousingPackets.cpp" />
    <ClCompile Include="..\..\source\WorldServer\IRC\IRC.cpp" />
    <ClCompile Include="..\..\source\WorldServer\IRC\IRCChannel.cpp" />
    <ClCompile Include="..\..\source\WorldServer\IRC\IRCMessage.cpp" />
    <ClCompile Include="..\..\source\WorldServer\IRC\IRCServer.cpp" />
    <ClCompile Include="..\..\source\WorldServer\Items\Items.cpp" />
    <ClCompile Include="..\..\source\WorldServer\Items\ItemsDB.cpp" />
    <ClCompile Include="..\..\source\WorldServer\Items\Loot.cpp" />
    <ClCompile Include="..\..\source\WorldServer\Items\LootDB.cpp" />
    <ClCompile Include="..\..\source\WorldServer\Languages.cpp" />
    <ClCompile Include="..\..\source\WorldServer\LoginServer.cpp" />
    <ClCompile Include="..\..\source\WorldServer\LuaFunctions.cpp" />
    <ClCompile Include="..\..\source\WorldServer\LuaInterface.cpp" />
    <ClCompile Include="..\..\source\WorldServer\net.cpp" />
    <ClCompile Include="..\..\source\WorldServer\NPC.cpp" />
    <ClCompile Include="..\..\source\WorldServer\NPC_AI.cpp" />
    <ClCompile Include="..\..\source\WorldServer\Object.cpp" />
    <ClCompile Include="..\..\source\WorldServer\Player.cpp" />
    <ClCompile Include="..\..\source\WorldServer\Quests.cpp" />
    <ClCompile Include="..\..\source\WorldServer\races.cpp" />
    <ClCompile Include="..\..\source\WorldServer\Recipes\Recipe.cpp" />
    <ClCompile Include="..\..\source\WorldServer\Recipes\RecipeDB.cpp" />
    <ClCompile Include="..\..\source\WorldServer\Rules\Rules.cpp" />
    <ClCompile Include="..\..\source\WorldServer\Rules\RulesDB.cpp" />
    <ClCompile Include="..\..\source\WorldServer\Sign.cpp" />
    <ClCompile Include="..\..\source\WorldServer\Skills.cpp" />
    <ClCompile Include="..\..\source\WorldServer\Spawn.cpp" />
    <ClCompile Include="..\..\source\WorldServer\SpellProcess.cpp" />
    <ClCompile Include="..\..\source\WorldServer\Spells.cpp" />
    <ClCompile Include="..\..\source\WorldServer\Titles.cpp" />
    <ClCompile Include="..\..\source\WorldServer\Tradeskills\TradeskillsDB.cpp" />
    <ClCompile Include="..\..\source\WorldServer\Tradeskills\TradeskillsPackets.cpp" />
    <ClCompile Include="..\..\source\WorldServer\Traits\Traits.cpp" />
    <ClCompile Include="..\..\source\WorldServer\Widget.cpp" />
    <ClCompile Include="..\..\source\WorldServer\World.cpp" />
    <ClCompile Include="..\..\source\WorldServer\WorldDatabase.cpp" />
    <ClCompile Include="..\..\source\WorldServer\zoneserver.cpp" />
    <ClCompile Include="..\..\source\WorldServer\Tradeskills\Tradeskills.cpp" />
    <ClCompile Include="..\..\source\WorldServer\Commands\Commands.cpp" />
    <ClCompile Include="..\..\source\WorldServer\Commands\ConsoleCommands.cpp" />
    <ClCompile Include="..\..\source\common\Condition.cpp" />
    <ClCompile Include="..\..\source\common\ConfigReader.cpp" />
    <ClCompile Include="..\..\source\common\CRC16.cpp" />
    <ClCompile Include="..\..\source\common\Crypto.cpp" />
    <ClCompile Include="..\..\source\common\database.cpp" />
    <ClCompile Include="..\..\source\common\dbcore.cpp" />
    <ClCompile Include="..\..\source\common\debug.cpp" />
    <ClCompile Include="..\..\source\common\emu_opcodes.cpp" />
    <ClCompile Include="..\..\source\common\EQEMuError.cpp" />
    <ClCompile Include="..\..\source\common\EQPacket.cpp" />
    <ClCompile Include="..\..\source\common\EQStream.cpp" />
    <ClCompile Include="..\..\source\common\EQStreamFactory.cpp" />
    <ClCompile Include="..\..\source\common\Log.cpp" />
    <ClCompile Include="..\..\source\common\md5.cpp" />
    <ClCompile Include="..\..\source\common\misc.cpp" />
    <ClCompile Include="..\..\source\common\MiscFunctions.cpp" />
    <ClCompile Include="..\..\source\common\Mutex.cpp" />
    <ClCompile Include="..\..\source\common\opcodemgr.cpp" />
    <ClCompile Include="..\..\source\common\packet_dump.cpp" />
    <ClCompile Include="..\..\source\common\packet_functions.cpp" />
    <ClCompile Include="..\..\source\common\PacketStruct.cpp" />
    <ClCompile Include="..\..\source\common\RC4.cpp" />
    <ClCompile Include="..\..\source\common\TCPConnection.cpp" />
    <ClCompile Include="..\..\source\common\timer.cpp" />
    <ClCompile Include="..\..\source\common\xmlParser.cpp" />
  </ItemGroup>
  <ItemGroup>
    <ClInclude Include="..\..\source\common\DatabaseNew.h" />
    <ClInclude Include="..\..\source\common\DatabaseResult.h" />
    <ClInclude Include="..\..\source\WorldServer\Achievements\Achievements.h" />
    <ClInclude Include="..\..\source\WorldServer\AltAdvancement\AltAdvancement.h" />
    <ClInclude Include="..\..\source\WorldServer\Chat\Chat.h" />
    <ClInclude Include="..\..\source\WorldServer\Chat\ChatChannel.h" />
    <ClInclude Include="..\..\source\WorldServer\classes.h" />
    <ClInclude Include="..\..\source\WorldServer\client.h" />
    <ClInclude Include="..\..\source\WorldServer\ClientPacketFunctions.h" />
    <ClInclude Include="..\..\source\WorldServer\Collections\Collections.h" />
    <ClInclude Include="..\..\source\WorldServer\Combat.h" />
    <ClInclude Include="..\..\source\WorldServer\Entity.h" />
    <ClInclude Include="..\..\source\WorldServer\Factions.h" />
    <ClInclude Include="..\..\source\WorldServer\GroundSpawn.h" />
    <ClInclude Include="..\..\source\WorldServer\Guilds\Guild.h" />
    <ClInclude Include="..\..\source\WorldServer\IRC\IRC.h" />
    <ClInclude Include="..\..\source\WorldServer\IRC\IRCChannel.h" />
    <ClInclude Include="..\..\source\WorldServer\IRC\IRCMessage.h" />
    <ClInclude Include="..\..\source\WorldServer\IRC\IRCReplyCodes.h" />
    <ClInclude Include="..\..\source\WorldServer\IRC\IRCServer.h" />
    <ClInclude Include="..\..\source\WorldServer\Items\Items.h" />
    <ClInclude Include="..\..\source\WorldServer\Items\Loot.h" />
    <ClInclude Include="..\..\source\WorldServer\Languages.h" />
    <ClInclude Include="..\..\source\WorldServer\LoginServer.h" />
    <ClInclude Include="..\..\source\WorldServer\LuaFunctions.h" />
    <ClInclude Include="..\..\source\WorldServer\LuaInterface.h" />
    <ClInclude Include="..\..\source\WorldServer\MutexHelper.h" />
    <ClInclude Include="..\..\source\WorldServer\MutexList.h" />
    <ClInclude Include="..\..\source\WorldServer\MutexMap.h" />
    <ClInclude Include="..\..\source\WorldServer\MutexVector.h" />
    <ClInclude Include="..\..\source\WorldServer\net.h" />
    <ClInclude Include="..\..\source\WorldServer\NPC.h" />
    <ClInclude Include="..\..\source\WorldServer\NPC_AI.h" />
    <ClInclude Include="..\..\source\WorldServer\Object.h" />
    <ClInclude Include="..\..\source\WorldServer\Player.h" />
    <ClInclude Include="..\..\source\WorldServer\Quests.h" />
    <ClInclude Include="..\..\source\WorldServer\races.h" />
    <ClInclude Include="..\..\source\WorldServer\Recipes\Recipe.h" />
    <ClInclude Include="..\..\source\WorldServer\Rules\Rules.h" />
    <ClInclude Include="..\..\source\WorldServer\Sign.h" />
    <ClInclude Include="..\..\source\WorldServer\Skills.h" />
    <ClInclude Include="..\..\source\WorldServer\Spawn.h" />
    <ClInclude Include="..\..\source\WorldServer\SpawnLists.h" />
    <ClInclude Include="..\..\source\WorldServer\SpellProcess.h" />
    <ClInclude Include="..\..\source\WorldServer\Spells.h" />
    <ClInclude Include="..\..\source\WorldServer\Titles.h" />
    <ClInclude Include="..\..\source\WorldServer\Traits\Traits.h" />
    <ClInclude Include="..\..\source\WorldServer\Variables.h" />
    <ClInclude Include="..\..\source\WorldServer\VisualStates.h" />
    <ClInclude Include="..\..\source\WorldServer\Widget.h" />
    <ClInclude Include="..\..\source\WorldServer\World.h" />
    <ClInclude Include="..\..\source\WorldServer\WorldDatabase.h" />
    <ClInclude Include="..\..\source\WorldServer\WorldTCPConnection.h" />
    <ClInclude Include="..\..\source\WorldServer\zoneserver.h" />
    <ClInclude Include="..\..\source\WorldServer\Commands\Commands.h" />
    <ClInclude Include="..\..\source\WorldServer\Commands\ConsoleCommands.h" />
    <ClInclude Include="..\..\source\WorldServer\Tradeskills\Tradeskills.h" />
    <ClInclude Include="..\..\source\common\Common_Defines.h" />
    <ClInclude Include="..\..\source\common\ConfigReader.h" />
    <ClInclude Include="..\..\source\common\CRC16.h" />
    <ClInclude Include="..\..\source\common\Crypto.h" />
    <ClInclude Include="..\..\source\common\database.h" />
    <ClInclude Include="..\..\source\common\DataBuffer.h" />
    <ClInclude Include="..\..\source\common\dbcore.h" />
    <ClInclude Include="..\..\source\common\debug.h" />
    <ClInclude Include="..\..\source\common\emu_opcodes.h" />
    <ClInclude Include="..\..\source\common\emu_oplist.h" />
    <ClInclude Include="..\..\source\common\EQ2_Common_Structs.h" />
    <ClInclude Include="..\..\source\common\EQEMuError.h" />
    <ClInclude Include="..\..\source\common\EQPacket.h" />
    <ClInclude Include="..\..\source\common\EQStream.h" />
    <ClInclude Include="..\..\source\common\EQStreamFactory.h" />
    <ClInclude Include="..\..\source\common\GlobalHeaders.h" />
    <ClInclude Include="..\..\source\common\linked_list.h" />
    <ClInclude Include="..\..\source\common\Log.h" />
    <ClInclude Include="..\..\source\common\LogTypes.h" />
    <ClInclude Include="..\..\source\common\md5.h" />
    <ClInclude Include="..\..\source\common\misc.h" />
    <ClInclude Include="..\..\source\common\MiscFunctions.h" />
    <ClInclude Include="..\..\source\common\Mutex.h" />
    <ClInclude Include="..\..\source\common\opcodemgr.h" />
    <ClInclude Include="..\..\source\common\packet_dump.h" />
    <ClInclude Include="..\..\source\common\packet_functions.h" />
    <ClInclude Include="..\..\source\common\PacketStruct.h" />
    <ClInclude Include="..\..\source\common\queue.h" />
    <ClInclude Include="..\..\source\common\RC4.h" />
    <ClInclude Include="..\..\source\common\Seperator.h" />
    <ClInclude Include="..\..\source\common\servertalk.h" />
    <ClInclude Include="..\..\source\common\TCPConnection.h" />
    <ClInclude Include="..\..\source\common\timer.h" />
    <ClInclude Include="..\..\source\common\types.h" />
    <ClInclude Include="..\..\source\common\version.h" />
    <ClInclude Include="..\..\source\common\xmlParser.h" />
  </ItemGroup>
  <Import Project="$(VCTargetsPath)\Microsoft.Cpp.targets" />
  <ImportGroup Label="ExtensionTargets">
  </ImportGroup>
</Project>

https://svn.eq2emulator.net/svn/eq2server Is the SVN I used. (from the Admin guide how to compile a windows server)

[Jabantiz]

Ok this is odd. I click the link you just posted, I get the unsecure site warning or whatever and continue on (self signed cert so browsers bitch about it) so I can browse the files, I go to trunk/source/depends/ and see all 4 folders listed. Browsing to the project file (trunk/win/VC10Projects/) shows the project file I linked earlier with mariadb listed.

I checked out a fresh install of public SVN and again it has mariadb listed.

What revision is your svn showing as? It should be 2715 as that was the last commit (to the release folder not trunk in this case)

[Plague]

You nailed it with that one. I was not at revision 2715 (even tho I did a SVN checkout twice after reading your post) I ended up having to delete the whole folder and checking it out in another folder for it to go to revision 2715. Maria is listed now and it compiled just fine. Time to make some content (and trouble)

[Plague]

Perhaps a bit hasty post there. Everything compiled and I ended up with 2 files "EQ2World__Debug.pdb" and "EQ2World__Debug.exe"
I am still missing (what is probably a pretty simple step) on how to populate the database in heidisql.
Everything I have done so far in the order I did it.
I kept notes for two reasons first so Jabantiz get a little laugh and then point out something obvious I missed and second so the admin guide on the wiki can get updated.

Code: Select all

1. File structure.
  1.1 Create a folder in the root of your drive c:
  1.2 I named this folder eq2 but can name it whatever you want.
  1.3 Inside this folder create two more folders eq2client (where the game gets installed) and eq2emu.
  1.4 Inside eq2emu (the working directory) create a folder Source.

2. Retrieving source code/
  2.1 https://tortoisesvn.net/downloads.html is used to retrieve the source code.
  2.2 After it is installed right click the Source folder you created in step 1.4 and select SVN checkout.
  2.3 Enter https://svn.eq2emulator.net/svn/eq2server as the url of the repository.
  2.4 The login credentials are SVN Username: anonymous (no password required) 

3. Compiling 
  3.1 Visual Studio 2017 Community Edition was used for this part.
  3.2 Open eq2emu/Source/trunk/winEQ2WorldVC10.sln
  3.3 Right click eq2world and under the vc++ directories tab make sure of the following.
    3.3.1 Included directories
           $(SolutionDir)..\source\depends\mariadb-10.1.19\include;$(SolutionDir)..\source\depends\zlib\include;$(IncludePath)
    3.3.2 Library directories
           $(SolutionDir)..\source\depends\mariadb-10.1.19\lib\32-debug;$(SolutionDir)..\source\depends\zlib\lib;$(LibraryPath)
  3.4 Riclick EQ2WORLD and click Build.

4. Account set up time.
  4.1 http://eq2emulator.net/phpBB3/ucp.php?mode=register
  4.2 http://eq2emulator.net/portal/index.php?p=account
  4.3 You should no have
    4.3.1 Login Account Name
    4.3.2 Login Account Password
    4.3.3 World Account Name - Account name that will be used by the server to login.
    4.3.4 World Account Password - Password that will be used by the server to login.
    4.3.5 World Server Name - Name used to identify your server.
    4.3.6 World Description - Brief description describing your world.

5. MySQL
  5.1 mysql-installer-web-community-5.7.20.0.msi
  5.2 I selected full install
  5.3 Standalone MySQL server
  5.4 Click dropdown and select Server Machine
  5.5 Leave everything else at its default

6. Install HeidiSQL
  6.1 https://www.heidisql.com/download.php?download=installer
  6.2 Right Click > Create new > database and name it eq2
  6.3 Click Tools > user manager and create a user and password
    6.3.1 In the Allow Access to: box click on Database eq2 and then click save

7. Unzip using your favorite program (7zip for me) 
  7.1 Source > releases > eq2emulator > 0.7.2 > EQ2Emulator_0.7.2_Complete.zip
  7.2 Unzip this into your working directory.
 
8. World_db.ini
  8.1 Right click > edit
       [Database]
       host=localhost
       user=World Account Name from step 4.3.3
       password=World Account Password from step 4.3.4
       database=eq2

9. LoginServer.ini
  9.1 Right click > Edit
       [LoginServer]
       loginserver=127.0.0.1
       loginport=9100
       worldname=World Server Name from step 4.3.5
       worldaddress=127.0.0.1
       # internalworldaddress=
       worldport=9000
       locked=false
       account=minilogin
       password=minilogin
       autotableupdates=never
       autotableverbose=false
       autotabledata=false

       [WorldServer]
       Defaultstatus=
       Unavailzone=

       [UpdateServer]
       updateserveraddress=
       updateserverport=9104

       [LoginConfig]
       ServerMode=StandAlone
       ServerPort=9100

10. eq2_default.ini
  10.1 Open your client directory
  10.2 Right click > edit eq2_default.ini
  10.3 Set the cl_ls_address to
       cl_ls_address eq2emulator.net 

Also if you did you need to set the update port to 9104 in the loginserver.ini for the new DB patcher it uses.

Assuming you mean, at least I hope you do.
updateserveraddress=
updateserverport=9104

[Jabantiz]

Assuming you mean, at least I hope you do.
updateserveraddress=
updateserverport=9104

Yes, the address should be updates.eq2emulator.net, first run of the server you need to have it connect to the DB patcher to build the tables and get required data. It will also take some time running the first time, just have to let it do its thing. After it is done updating you can then close the server and get the content dump from svn and source it in if you want. It is important to run the patcher first before you source the dump as the patcher will nuke the dump/cause errors if you do it the other way around.

[Plague]

Yup server is up and running. Empty atm had to goto work before I could source in the content. Also did up an updated guide. Tho I had trouble figuring out how to set up a server, it was pretty easy to do once i figured out the correct steps.

[Cynnar]

I had trouble figuring out how to set up a server, it was pretty easy to do once i figured out the correct steps.

That is always the case. At least it is for me. Seems like nothing makes sense, and I keep messing things up, but once I figure it out it's like duh.

Also did up an updated guide.

This will be great to add to the wiki. I just looked at the wiki, and while it gets the job done, it could use some TLC.

Once we get the wiki straighten out I will see if I can get your guide and add it into the wiki.