Help with the realmlist table.....

Offtopic Chillout Room
1

ok, i am setting up a server for myself and a few friends. the server is going to be at my home network, but my friends will be connecting from out side of it. there is only one column of data in the realmlist table so how and what would i do to add the local ip and external ip’s to the table.

2

www.whatsmyip.org will show you the external IP address. Use this in the IP column.

You’ll need to use that computers local IP address while connecting to the realm. IF you are locally connecting (Within your own network).

What I mean to say is open up command prompt and type ipconfig use this “IP address” in your realmlist.wtf.

Your friends will use the external IP you entered in the realmlist table.

Think of it like this…


Realm -- -- Router -- network

        |

       You
3

Get your current ip from WhatIsMyIP.com and give it to your friends. Your friends need to add it to their realmlist like this:

set realmlist your.ip.number.here

And yours will look like:

set realmlist 127.0.0.1

Now, go into your “auth” database, find the “realmlist” table, and put your WhatIsMyIP.com IP in the “address” column.

Voila. You and your friends can connect to your server.

If you haven’t made accounts for them yet, you’ll need to do that by typing the following command inside the worldserver.exe that you run to start the server (after it finishes loading):

account create <username> <password> <gmlevel> <realm ID>

and are up to them, where is a number 1-4 of what you want their GM access to be, and is the ID# of the realm shown in the realmlist table you went to in the instruction above. If you want them to have GM access on ALL realms, put “-1” as the .

Here’s an example,

account create john d1ngl3b3r13s 3 -1
4

so correct me if i am wrong but it sounds like all i have to do is set the ip to my ip(or in my case my dyndns domain name since i have a dynamic ip) and any one on the internet can access the server as well as any one on the local network(and the local-host)

and as for account creation i need info on where to find a sql query that will create my master account so i can log in and create other accts. also some sort of description for the gm acct lvls would be nice since the wiki doesn’t have this info

5

Well, what I am saying is you have to configure the realm to accept connections from outside your network. You’ll do this by changing the local IP entered in realmlist table to your external IP (http://www.whatsmyip.org) after you’ve done that along with port forwarding and adding the proper firewall exceptions. You should be able to receive connections outside your own network…

People outside your network will connect to the external address.

To locally connect you simply find the LAN IP address of the realm by running command prompt → ipconfig and place that in your realmlist.wtf

The other poster told you how to create an account the wrong way…

account create <username> <password> <gmlevel> <realm ID>
  • Dose not exist to my knowledge.

The proper syntax is:

.account create $account $password

In order to make it an account with GM access you’ll need to do

.account set gmlevel

[CODE]4 - Admin

3 - console

2 - GameMaster

1 - Ticket bitch[/CODE]

I think

To set the account’s expansion level use

.account set addon

Setting up dyndns is the same just use in place of the external IP…

Sorry to whomever is reading this. I know I typed this crappy, It’s just been one of those days… Please understand.

6

ok, i am a bit confused…do i need mutiple entries in my realmlist to access my realm from both internal and external networks?

7

no

8

ok cool.

as for the accout info…isnt that an INGAME command? if so then i cant use it atm because i have no accounts in my auth for me to log in with…let alone one with gm access

9

Use the worldserver’s console /emoticons/default_wink.png

10

for acc info .pinfo (select a player or put name of hero)

for acc create .acc create (username pass pass)

for example .pinfo herco

and .acc create dog 989 989

11

What they are telling you is, When you start up “worldserver.exe”, a command prompt window opens & lots of info streams up in it. THAT is the “worldserver console”. You type inside that window to create your accounts.

Hope that makes it clear enough /emoticons/default_smile.png

12

Those are in-game commands, which also work, but he needs an account to login to in order to use them.

Typing commands without the dot “.” before them in the worldserver console work as if you’re already in-game.

13

No shit sherlock, you just might be right.

14

Now it “dose”, Watson.

15

Surprised you haven’t been banned yet, troll.

16

I know right? How DARE I teach you something you didn’t already know. How DARE I!

17

You are just one sad little ignorant troll its alright. I don’t respect you enough ta care.

Edit:

FTW you haven’t ever taught me a thing.

18

should be:

[CODE]4 = console

3 = Admin

2 = Gamemaster

1 = Moderator[/CODE]

4 should not be used, it’s meant for console only.

19

So, I am asking here because it is about the realmlist. So when I open the realmlist it has a bunch of Null values that are incomprehensible and also the realmlist file is in .frm form. Any fix? Here’s the link for what the file looks like. I just need to see something comprehensible for this so I can change it. No one but me can log in because of it. http://i.imgur.com/yIG8uEn.png

20

@LivingTorch https://www.digitalocean.com/community/tutorials/a-basic-mysql-tutorial