Help with the realmlist table.....

18 posts in this topic

Posted

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.

0

Share this post


Link to post
Share on other sites

Posted

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


0

Share this post


Link to post
Share on other sites

Posted

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>
<username> and <password> are up to them, where <gmlevel> is a number 1-4 of what you want their GM access to be, and <realm ID> 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 <realm ID>. Here's an example,
account create john d1ngl3b3r13s 3 -1

0

Share this post


Link to post
Share on other sites

Posted

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

0

Share this post


Link to post
Share on other sites

Posted

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

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
4 - Admin

3 - console

2 - GameMaster

1 - Ticket bitch
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.

1

Share this post


Link to post
Share on other sites

Posted

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

0

Share this post


Link to post
Share on other sites

Posted

no

0

Share this post


Link to post
Share on other sites

Posted

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

0

Share this post


Link to post
Share on other sites

Posted

Use the worldserver's console ;)

0

Share this post


Link to post
Share on other sites

Posted

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

0

Share this post


Link to post
Share on other sites

Posted (edited)

ok cool.

as for the accout info.....isnt that an INGAME command?

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

Edited by psychobandit
0

Share this post


Link to post
Share on other sites

Posted

The proper syntax is:

.account create $account $password

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.

-1

Share this post


Link to post
Share on other sites

Posted

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.

No shit sherlock, you just might be right.
-1

Share this post


Link to post
Share on other sites

Posted

Dose not exist to my knowledge.

Now it "dose", Watson.

-1

Share this post


Link to post
Share on other sites

Posted

Surprised you haven't been banned yet, troll.

-1

Share this post


Link to post
Share on other sites

Posted

Surprised you haven't been banned yet, troll.

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

0

Share this post


Link to post
Share on other sites

Posted (edited)

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.

Edited by Zze
0

Share this post


Link to post
Share on other sites

Posted

4 - Admin

3 - console

2 - GameMaster

1 - Ticket bitch
should be:
4 = console

3 = Admin

2 = Gamemaster

1 = Moderator

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

1

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now

  • Recently Browsing   0 members

    No registered users viewing this page.