Jump to content


NEW custom search, includes forums, wiki, github issues, TC sourcecode, irc logs, doxygen automated documentation; read more here
Photo

Help with the realmlist table.....


  • Please log in to reply
17 replies to this topic

#1 alysher

alysher

    Advanced Member

  • Members
  • PipPipPip
  • 112 posts

Posted 04 February 2011 - 01:14 AM

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 Zze

Zze

    Advanced Member

  • Members
  • PipPipPip
  • 229 posts

Posted 04 February 2011 - 01:22 AM

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 Gregarious

Gregarious

    Advanced Member

  • Members
  • PipPipPip
  • 189 posts

Posted 04 February 2011 - 01:24 AM

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


#4 alysher

alysher

    Advanced Member

  • Members
  • PipPipPip
  • 112 posts

Posted 04 February 2011 - 01:58 AM

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 Zze

Zze

    Advanced Member

  • Members
  • PipPipPip
  • 229 posts

Posted 04 February 2011 - 02:22 AM

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.

#6 alysher

alysher

    Advanced Member

  • Members
  • PipPipPip
  • 112 posts

Posted 04 February 2011 - 02:32 AM

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 Zze

Zze

    Advanced Member

  • Members
  • PipPipPip
  • 229 posts

Posted 04 February 2011 - 02:35 AM

no

#8 alysher

alysher

    Advanced Member

  • Members
  • PipPipPip
  • 112 posts

Posted 04 February 2011 - 02:42 AM

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 Zze

Zze

    Advanced Member

  • Members
  • PipPipPip
  • 229 posts

Posted 04 February 2011 - 02:43 AM

Use the worldserver's console ;)

#10 dabyv

dabyv

    Advanced Member

  • Members
  • PipPipPip
  • 161 posts

Posted 04 February 2011 - 03:37 AM

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 psychobandit

psychobandit

    Advanced Member

  • Members
  • PipPipPip
  • 73 posts

Posted 04 February 2011 - 04:22 AM

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, 04 February 2011 - 04:22 AM.


#12 Gregarious

Gregarious

    Advanced Member

  • Members
  • PipPipPip
  • 189 posts

Posted 04 February 2011 - 05:04 AM

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.

#13 Zze

Zze

    Advanced Member

  • Members
  • PipPipPip
  • 229 posts

Posted 04 February 2011 - 05:39 AM

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.

#14 Gregarious

Gregarious

    Advanced Member

  • Members
  • PipPipPip
  • 189 posts

Posted 04 February 2011 - 05:44 AM

Dose not exist to my knowledge.


Now it "dose", Watson.

#15 Zze

Zze

    Advanced Member

  • Members
  • PipPipPip
  • 229 posts

Posted 04 February 2011 - 05:48 AM

Surprised you haven't been banned yet, troll.

#16 Gregarious

Gregarious

    Advanced Member

  • Members
  • PipPipPip
  • 189 posts

Posted 04 February 2011 - 05:50 AM

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!

#17 Zze

Zze

    Advanced Member

  • Members
  • PipPipPip
  • 229 posts

Posted 04 February 2011 - 06:00 AM

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, 04 February 2011 - 06:03 AM.


#18 ClanCC

ClanCC

    Advanced Member

  • Members
  • PipPipPip
  • 239 posts

Posted 04 February 2011 - 10:01 AM

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.

"Whomsoever takes up this blade shall wield power eternal. Just as the blade rends flesh, so must power scar the spirit." Frostmourne
===================================
My Works:

- Prevent players from accessing GM Island
===================================
+like if this post is helpful. :P