[Help] Trouble connecting to Server - Kekku's Files

[gReGiTh]

EDIT: Thread title changed, I have some more things I need help with, see my other posts in this thread.

I'm trying to add an account manually in smse..

I've had my server done and ready to be tested for about 4 hours now.. in that time, I've been messing with WAMP trying to get the register script given with Kekku's server files to work.

I'm very frustrated atm.. I don't have knowledge of web servers and am having trouble getting it to work..

What I'd really like is for someone to tell me what goes in each field in dbo.accounts in order to manually add an account - because for some reason, whenever I try to create one manually, I put something invalid in one or more fields, and when I save it, it reverts back to the way it was (lacking the account I was trying to add).

All I really need is to know what to put in each field.

DO NOT TELL ME TO SEARCH. I have searched, and before someone tells me to go read a sticky where it says how to do just that, I know, but Kekku's db is different, dbo.accounts has more fields and doesn't seem to want to let me add anything manually there.

[MentaL]

[simoelon]

This is what you have to fill in in dbo.Account :

AID: Just put 1 for the first account, 2 for the 2nd, 3 for the 3d and so on
UserID: Your username
UGradeID: just put 0 here
PGradeID: put 0 for normal user, 255 for administrator
RegDate: just put any date there, e.g. 2008.03.01
Name: Just write any name, like Joe, or Bob
Email: its e-mail, it doesn't have to be valid
RegNum: leave null there
Age: it's the age of player
Sex: 0 is for man, 1 for woman (I guess)
ZipCode: leave null here
Country: Your country code, it won't affect gameplay, unless you're using country filter
LastCID: leave null here
Cert: put 1 here

Now open dbo.Login and set:

UserID: it's the username
AID: check what have you inserted in dbo.Account, if account "account" has AID 1, then set AID to 1 here also.
Password: well, it's where the passwords are stored :)
LastConnDate: Last date, the user was connected, you can leave this null
LastIP: Last IP the user has used, you can leave this null

Well, this should work, I'm using the register script, which came with his server files, it works fine for me. Check if you have edited your php.ini file, register script won't work if connection to mssql isn't allowed ;)

[gReGiTh]

Thanks man.

Yeah I enabled everything in php.ini but still get a bunch of errors (can't connect to server etc). I'll fix it later.

Now my only problem is that the server doesn't showup ingame (so I can't connect). It should show up if I only have matchserver running right?

[simoelon]

Lucky you, you got locator to start ^^. Anyways, check if information is set right in dbo.ServerStatus and dbo.LocatorStatus. Remember, that if you used localhost when configuring locator.ini, you also have to use localhost when configuring db's, but I'd suggest to use you real IP. ;)

[gReGiTh]

Lucky you, you got locator to start ^^. Anyways, check if information is set right in dbo.ServerStatus and dbo.LocatorStatus. Remember, that if you used localhost when configuring locator.ini, you also have to use localhost when configuring db's, but I'd suggest to use you real IP. ;)

I wasn't using locator at all, just running matchserver and there are no servers showing up to connect to ingame when I try to login. I guess I'll go try to get locator to work...

Edit. lol... I followed the readme in locator folder:
____________________________________________
To get locator work
open ServerStatus Table in GunzDB
Example:
-----------------------------------]
ServerID:---1----------------------]
CurrPlayer:-0----------------------]
MaxPlayer:--200--------------------]
Time:-------30.12.1993 0:00:00-----]
IP:---------127.0.0.1--------------]
Port:-------6000-------------------]
ServerName:-Match------------------]
Opened:-----1----------------------]
Type:-------2----------------------]
___________________________________

And wala, the server showed up ingame.. but whenever I try to connect I get the error ingame "Cannot connect to server"... I go and look at my matchserver to see why I can't login.. and there's nothing showing up at all about anyone trying to login... Any idea how I can fix this? ;P


If it helps, here's my matchserver log:

Match-Server Log
[04/06/08 08:16:40] DBMS connected
[04/06/08 08:16:40] Command registeration completed
[04/06/08 08:16:40] Release Date : Jan 11 2007
[04/06/08 08:16:40] X-Trap Off
[04/06/08 08:16:40] Server Country : BRAZIL
[04/06/08 08:16:40] Command version : (56)
[04/06/08 08:16:40] Event usable state : (false)
[04/06/08 08:16:40] Load event size : (0)
[04/06/08 08:16:40] FileCRCCheckSum usable state : (false)
[04/06/08 08:16:40] FileCRC size : (1)
[04/06/08 08:16:40] Country Code Filter usalbe state : (false)
[04/06/08 08:16:40] Accept Invalied IP state : (true)
[04/06/08 08:16:40] Keeper IP : (127.0.0.1)
[04/06/08 08:16:40] Match Server Created (Port:6000)
[04/06/08 08:21:40] GARBAGE SESSION CLEANING : ClientCount=0, SessionCount=1, AgentCount=1

[simoelon]

I guess I'll go try to get locator to work...

Well, locator is the one who gets information about all of your match servers and show them on the login screen. If locator isn't working, you won't be able to select a server you want to join, so without locator, you server is useless...

[gReGiTh]

What goes in dbo.LocatorStatus?

Edit: I filled it in with 1, 127.0.0.1, 8900 and the rest 1, which all were automatically changed... but still I can't connect...

[simoelon]

In dbo.LocatorStatus, you fill in 1 IP PORT 0 0 0 0 1000 DATE
Also, check you firewall settings, maybe it's blocking the connection.

[gReGiTh]

I did that and still having the same problem. Can I have your AIM or MSN address?