Could someone point me in the right direction....
 

I did a search for this but wasn't able to find what I was looking for.

I mostly followed Kavren's guide, aside from using Huppy's guide for port forwarding.

Everything installed and looks fine. But I think somewhere in the bunch I got a couple files mixed up.

Anways, my error is when I try to log into the server via the eqemulogin. This are the errors I'm given:

Ok those are my errors, and here is what I know:

EQEmulogin.exe doesn't like my 64x OS (Or so says my startup.bat), is that the main issue, if so has a work around been created for that? It appears setting it to run in compatibility mode helps, it doesn't crash the exe that way.

Other issue I saw when setting up, is the SVN DL never gave me a EQEmulogin.ini file, just a login.ini file which lacks a place to make changes to:

Here is my full login.ini file I changed to match the suggested eqemulogin.ini file:

Did I set that up the way it's supposed to or has something else gone wrong?

In regards to: Error adding local account for LS login: 'my LS account', duplicate name?

I tried a different LS login and got the same error. No way it can be a dup since it's the first time i tried it and never entered it into any of my tables.

You need to run this SQL against your database. It is from 1711_account_restricted_aa.sql. You may also be missing other updates. I believe Huppy's guide details where to find them and how to apply them.

ALTER TABLE `altadv_vars` ADD `account_time_required` INT UNSIGNED DEFAULT '0' NOT NULL AFTER `clientver`;
ALTER TABLE `account` ADD `time_creation` INT UNSIGNED DEFAULT '0' NOT NULL AFTER `suspendeduntil`;
UPDATE `account` SET `time_creation` = UNIX_TIMESTAMP() WHERE `time_creation` = 0;

If the first line causes an error, then you should only run the last two lines.

My hero.

Works.