Veteran Player new to EQEmu meed advice...

[thegofa]

Hi All,

Firstly if im posting in the wrong place I apologize, but im new to actually posting anything.

I have 2 questions that I need advice on please and would appreciate your kind and patient replies.

I have tried to work these out by going round and round on the Wiki site and also the forums but cant find the info I needed (im not too tech).

1) Can I play single player by using the EQEmu? Like just start the game and use the emulator so I can use EQ on a PC thats not connected to the net.

2) How do I set up a private server for myself and my 2 kids, 1 on LAN and one connecting from outside. I have a spare PC, 8gb ram and i5 to run it.

If you could please point me in the right direction on how to accomplish these two things I would be very grateful (so would my kids).

Thanks everyone,
TG

[N0ctrnl]

There are a bunch of guides on how to do exactly what you're after. Akkadius' server repack is a good way to turn a Windows install into a server. Then you can forward ports and be done with it.

Much like EQ itself, whatever you want to do has most likely been done before. Just search around a bit here and the wiki and you'll find what you're after without a lot of trouble :)

[thegofa]

Thanks for the advise, i'll try again to find it.

Also, any help on the single player?

Thank you,
TG

[N0ctrnl]

That's where your firewall ports are going to come in. The setup guides almost all have info about that in them.

[Uleat]

With that small of a player base, I would definitely recommend running your own login server. Plus, you could actually run the server on the computer that you wish
to play on - if you don't mind that computer having all of the 'extra' stuff on it to run the server.

I play on a single computer..but, your configuration would be different than mine if you're looking to host LAN and WAN players.


1 player or 100..really no difference unless you want the 1 player to run on 'localhost' as opposed to being exposed to a LAN. (I run mine as localhost.)

[thegofa]

Thanks for all your help guys, very kind.

Tried to get everything working, followed all the instructions etc and d/l the files but I seem to get timed out errors when I open my EQ client and try to log in.

I think it might be a bit to tech for me but at least I had a go.

Wish there was a link to "download this to run a local server" .zip and I could just drag it to a folder and run my EQ client and connect (eqhosts on my Titanium edited to 127.0.0.1)

Regards,
TG

[Uleat]

Let it soak in for a few days..there is a lot of info to digest, especially if you're new to this.

[thegofa]

It seemed to work ok, got CMake grabbing bits, Git downloading and assigning, then realised I hadnt changed eqemu_config.xml to say peq for database, then at least all the windows came up on startup.

Then when I open EQ client, the login screen comes up and I put my login / password, that I made in the source load_login / create login account etc but it just says timed out after 2 secs.

I tried but its a bit more than my poor brain can do haha.

Thanks anyway (friend said you were good community)
TG

[thegofa]

I might just delete it all and start fresh.

I cant see where I missed anything or did anything wrong but I will start again and triple check every step and see if I can get it going.

Just to check with you all, I do all this:
http://wiki.eqemulator.org/p?Complete_Windows-based_Server_Setup_Guide&frm=Main

Followed by all of this:
http://wiki.eqemulator.org/p?Windows_Private_Login_Server_Setup_Guide&frm=Main

Im now wanting to just run it for me and my son, on a LAN (no WAN).

Thanks again for all your help and patience,
TG.

[thegofa]

Just to check with you all, I do all this:
http://wiki.eqemulator.org/p?Complete_Windows-based_Server_Setup_Guide&frm=Main

Followed by all of this:
http://wiki.eqemulator.org/p?Windows_Private_Login_Server_Setup_Guide&frm=Main
TG.

Can someone please just confirm if what ive said is correct here to get a "single player / LAN game" for my son and I.

Many thanks,
TG.

[N0ctrnl]

You're making this way harder than it has to be :)

http://wiki.eqemulator.org/p?Akkas_PEQ_Server_Installer

Run the installer, open firewall ports, profit.

[thegofa]

Sorry N0ctrnl as I said im very green when it comes to anything technical.

I still have 1 question (please be gentle), once this is done do I need to add or change anything to make it a server on a LAN for my son and me?

Thanks for all the help and sorry im so dumb.
TG.

[Uleat]

I have a ton of posts around describing setups..most of which should still be viable.


Since you want more than one player, you will need to setup for a public server - with a few alterations.


-- As mentioned earlier, you need to ensure that the 'loginserver' project is selected in cmake and build your binaries off of that setting.

-- Forego the port-forwarding since you don't want WAN traffic.

-- Make sure that your database has the four(4) loginserver tables prefixed with 'tbl' - you can verify either with HeidiSQL or with this query:
SHOW TABLES LIKE 'tbl%'

-- Your 'local_network' setting in login.ini should be the first three(3) segments of your LAN domain: (mine for reference)
local_network = 127.0.0.

-- ALL IP addresses in your config files should be that of your server computer's LAN address with the exception of database - which should be 127.0.0.1

-- Your EQ client eqhost files should point to the LAN address of your server computer.


Note: If possible, use static addresses on your LAN so that you don't have to trace connection issues every time you boot-up your network - or -
reserve the lan address of your server computer in your router using the MAC ID of the LAN card in your server computer.



<!-- Only specify these two if you really think you need to. (read: You don't) -->
<!-- <address>some.server.com</address> -->
<!-- <localaddress>192.168.0.5</localaddress> -->


You will need to un-remark both of these and put your server LAN address in both fields.

My 'localhost' config looks like this:

<!-- Only specify these two if you really think you need to. (read: You don't) -->
<address>127.0.0.1</address>
<localaddress>127.0.0.1</localaddress>



Check this and post back with any remaining issues.

[thegofa]

Ok, firstly, thank you all for putting up with me and all your awesome help.

Managed to download that file, unzip to folder, run and install.

Seemed to do all it needed to and finished with "press any key" as instructions showed so must have been good.

UPDATE: lol sorry, my son now says he is playing on Steam f2p with him mates (dad crawls away) so I now have one last question.

I have installed the Akkas PEQ server and files etc, but now want to just configure to single player, no one else to join, would you please be kind enough to let me know what I should change to make it just a single player server.

I know im a pain, but im so desperate to relive my old game once more :)
TG.

[Uleat]

If you setup to play on a LAN, you can still play solo.

That would allow your son to play at a later date, if he so decides, without having to reconfigure again.


If you are playing on the same computer as what hosts your server, you can just change all of the LAN card addresses to '127.0.0.1' and it will connect solely on your computer.

[Shin Noir]

I would say instead of focusing on a "LAN only" server, set it up the generic akka route, so that your server is listed on the eqemu server list, and in your eqemu_config.xml, set the Locked element on, so the server is locked by default when it boots up, that way only allowed (100 status+) players can join.

Then, when you have a son or friend or whomever that wants to join for the first time, you can let them in by doing a one time process: You get in sync, tell them to get to server select, You then #unlock in game, they can join, make a character real quick, then look at the account table for the latest created account (it's likely them), and change their status to 100 (so they can rejoin), and #lock it again. Now they can enter the server at any time, any where, even when locked.

That way, you never have to muck with configuring it for LAN, and it'll work everywhere, and it's protected from unwanted guests (as long as you don't forget to #unlock/re-#lock).

The only part you'll have to double check is what commands are exposed for a status 100 user (they need it to get through locked), which is in command_settings table.

but this is what I'd do for a "LAN server". Since, if your friend has mates who play, they may all be interested in playing, and they aren't LAN. ;)

[thegofa]

I will be playing on this PC, which also hosts the server.

I will change things if the lad wants to join me later, for now ill just change the LAN card addresses.

Um, where do I find those? <waits for roaring thunder and swift kick in the butt>
TG.

EDIT: Shin Noir, you might have a point, I didnt know I could lock it. I will have to work out how but the wiki etc has many answers.
Uleat, I might try this idea first it seems like a good plan as my son changes his mind like the wind changes...

[Uleat]

Haha!

login.ini and eqemu_config.xml

[thegofa]

Ok starting server with t_start_server.bat and starts to do stuff (windows etc) then I get an error window come up...

"the program cant start because LIBMYSQL.dll is missing from your computer"

Heeeeeelp !
TG.

[Uleat]

Open your server folder, double-click on the eqemu_update.pl file, then select the option to download dll's.

That will get you 3..including the missing one.

[thegofa]

Awesome thank you.

The final lap now...

I have got all things going, logged into MY server (woohoo) and made a toon.

Last thing I need to know please and I promise to never darken your door again.

How do I lock my server and how do I change peoples (mine too) status to 100 so we can get into the server once its locked.

So close now...
TG.

[Nerdgasm]

Not sure if you figured this out; Your 'eqemu_config' file should have nearish the middle where the <loginserver> information is something that says;
<unlocked></unlock>
<!--locked></locked> - or something to that nature. Get rid of <unlocked></unlocked> so it just shows;

<!-- Server status. Default is unlocked -->
<locked></locked>

^ To reunlock your server just changed the <locked></locked> to <unlocked></unlocked> =P ^

In your database (I'd use HeidSQL to update it, or Navicat), under 'Account' you'll see your ID|Name(aka account name)|charname|sharedplat|password|status(blah blah blah blah blah)

You'll want to change your status to 250 and you'll be able to get into the server. To allow other people to connect and set their status, the easiest way I found to do this (and there's probably easier but it works for me) in game on your toon type #unlock. have that person join, and once they're in your server #lock, go into your DB again and change their account to 250 (or 100, or whatever).

Or I guess an easier way if you didn't want to downloan HediSQL or Navicat would be to navigate to your server through command prompt; (for me it'd be C:\EQ\EQEmuServer) and type; world flag your_account_name 250. So for me it'd be world flag Sinclipse 250.

[thegofa]

Many thanks for your help Nerdgasm, but when I start HeidiSQL and go into peq db, then look at account, I have nothing listed (see here).
.
http://i.imgur.com/sc161X1.png
.
Sorry to be a pain.
TG.

[Shin Noir]

Click the data tab on the top center ish
By default when you click a table on the left, you're seeing what is called the schema. (It's basically defining the types of fields in the table). When you click the data tab, you're now seeing the records inside your DB, and you can double click/edit fields by changing values, much like Excel.

Also, nerdgasm's note about the locked/unlocked may be slightly confusing, you can comment/uncomment the <locked/> element to enable locking.


<!-- Server status. Default is unlocked DO NOT EDIT RIGHT NOW -->
<!-- <locked/> -->
<!-- <unlocked/> -->


by removing the <!-- --> wrapping parts.

[thegofa]

You guys are awesome!!!!

All running well, locked her and changed my acc to 250 status, and logged in through the locked server status.

I just have a couple of things that dont seem right.

1) Not real important - I cant seem to change to a different UI, looks like it doing something but then just moves windows a bout but its still default?

2) Quite urgent - Whenever I make a Froglok its starts him in South Qeynos and as he spawns he is summarily beaten to death by 2 guards ???

Thanks again for all the awesome help,
TG.

[Krran]

Hi Thegofa!

I just wanted to give you a welcome.
I am still also (still!) pretty green when it comes to this technology, though I do eventually end up getting something working. So, keep hope and keep in touch!

- Krran/Tzeedei/etc...

[thegofa]

Hi Krran,

Ive played EQ since the first day it arrived, bought all the expansions too and the people were always pretty cool.

One thing ive learned is that this forum has so many kind people that are willing to help you out no matter how "untech" you are, its nice.

Thank you for the welcome, its good to have a great community to rely on :)

Just waiting on my 2 questions as its hard for my poor Froggie haha!
TG

[Thor]

Update: I now have my server made, locked and I can log in all fine.

Have made all races and seems only Frogloks have an issue with starting zone...

Using my daughters account as she doesnt use it now, to have a second character in my game with me and made a Cleric to be a companion to my Warrior (at least im not alone now and have a healer to keep me alive) :)

I am now ready to go off on my own and leave you poor people in peace, just need to know if im the only person that cant make a Froglok without him having South Qeynos as his spawn, which results in bloody, gory, crushing instant death. ;(

Thanks,
Thor.

EDITEDITEDIT : Hahaha just realised I posted on my daughters account, apologies for any confusion.

FINAL EDIT: Oh wow, just realised THIS is my acc, thegofa is hers, wondered why the join date was so new on thegofa. I knew id been a member here for a long time!

[Nerdgasm]

Update: I now have my server made, locked and I can log in all fine.

Have made all races and seems only Frogloks have an issue with starting zone...

Using my daughters account as she doesnt use it now, to have a second character in my game with me and made a Cleric to be a companion to my Warrior (at least im not alone now and have a healer to keep me alive) :)

I am now ready to go off on my own and leave you poor people in peace, just need to know if im the only person that cant make a Froglok without him having South Qeynos as his spawn, which results in bloody, gory, crushing instant death. ;(

Thanks,
Thor.

EDITEDITEDIT : Hahaha just realised I posted on my daughters account, apologies for any confusion.

FINAL EDIT: Oh wow, just realised THIS is my acc, thegofa is hers, wondered why the join date was so new on thegofa. I knew id been a member here for a long time!

Quick and easy way to get rid of that problems is updating your start zone, or just deleting the guards in that zone. ^.^

[Nerdgasm]

Click the data tab on the top center ish
By default when you click a table on the left, you're seeing what is called the schema. (It's basically defining the types of fields in the table). When you click the data tab, you're now seeing the records inside your DB, and you can double click/edit fields by changing values, much like Excel.

Also, nerdgasm's note about the locked/unlocked may be slightly confusing, you can comment/uncomment the <locked/> element to enable locking.


<!-- Server status. Default is unlocked DO NOT EDIT RIGHT NOW -->
<!-- <locked/> -->
<!-- <unlocked/> -->


by removing the <!-- --> wrapping parts.


Either way works, I spose.

<!-- Server status. Default is unlocked -->
<locked></locked>

I was to lazy to change it. Was easier (for me) to just get rid of the unlocked and leave the locked. =P

[Thor]

I will try to do that (not sure how) thanks Nerdgasm.

Another weird thing is, if I make a Beastlord, he doesn't have kick as a skill and if I go to a trainer its there in the train list but I cant select it to train it.

Also he has Slam? But thats not a Beastlord skill...

Very strange indeed...
Thor (thegofa)