Veteran Player new to EQEmu meed advice... - Page 2

**Shin Noir** · #16 03-02-2016, 06:12 PM

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 · #17 03-02-2016, 06:17 PM

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** · #18 03-02-2016, 06:20 PM

Haha!

login.ini and eqemu_config.xml

thegofa · #19 03-02-2016, 06:32 PM

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** · #20 03-02-2016, 07:26 PM

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 · #21 03-02-2016, 09:35 PM

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 · #22 03-03-2016, 04:46 AM

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>

^ 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 · #23 03-03-2016, 05:59 AM

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).
.

.
Sorry to be a pain.
TG.

**Shin Noir** · #24 03-03-2016, 06:03 AM

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.

Code:

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

by removing the  wrapping parts.

thegofa · #25 03-03-2016, 06:45 AM

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 · #26 03-03-2016, 02:03 PM

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 · #27 03-03-2016, 03:08 PM

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 · #28 03-03-2016, 07:33 PM

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 · #29 03-05-2016, 03:46 AM

Quote:

Originally Posted by 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!

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

Nerdgasm · #30 03-05-2016, 03:48 AM

Quote:

Originally Posted by 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.

Code:

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

by removing the  wrapping parts.

Either way works, I spose.

Code:

		<!-- 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