GunZ Database Issue

Page 1 of 2 12 LastLast
Results 1 to 25 of 29
  1. #1
    Member James Green is offline
    MemberRank
    Oct 2013 Join Date
    57Posts

    GunZ Database Issue

    Hi, I am having an issue with a GunZ DB, I noticed that once I got it imported into MSSQL that it was missing a row/field in the dbo.Account but problem is that the database works perfect with no issues so I don't know exactly what to do. This is a screenshot of the first line that needs a password column -> http://prntscr.com/37b27y


  2. #2
    Pee Aitch Pee Dave is offline
    MemberRank
    Mar 2011 Join Date
    The NetherlandsLocation
    722Posts

    Re: GunZ Database Issue

    The password should be stored in the login table, not account.

  3. #3
    Member James Green is offline
    MemberRank
    Oct 2013 Join Date
    57Posts

    Re: GunZ Database Issue

    Ah, alright. Thanks, just looking for a GunZ client now as for some reason winrar said it had a checksum error.

  4. #4
    Yaaay! Tannous is offline
    MemberRank
    Jul 2012 Join Date
    KonohaLocation
    840Posts

    Re: GunZ Database Issue

    Quote Originally Posted by James Green View Post
    Ah, alright. Thanks, just looking for a GunZ client now as for some reason winrar said it had a checksum error.
    As Dave said the password is in dbo.Login table.

    and use Phoenix client and server files from here:
    http://forum.ragezone.com/f245/gunz-...client-701737/

  5. #5
    Member James Green is offline
    MemberRank
    Oct 2013 Join Date
    57Posts

    Re: GunZ Database Issue

    Ok well I did get a good client but now I am having an issue that my server won't show up in the server list but let me see if those will work and yes I do have everything like they are but should TCP ports be the same in all 3 exe's? MatchServer, MatchAgent and locator? e.g. 6000, 6000, 6000 as TCP
    Could you help me out over join.me tannus?

  6. #6
    Yaaay! Tannous is offline
    MemberRank
    Jul 2012 Join Date
    KonohaLocation
    840Posts

    Re: GunZ Database Issue

    Quote Originally Posted by James Green View Post
    Ok well I did get a good client but now I am having an issue that my server won't show up in the server list but let me see if those will work and yes I do have everything like they are but should TCP ports be the same in all 3 exe's? MatchServer, MatchAgent and locator? e.g. 6000, 6000, 6000 as TCP
    Could you help me out over join.me tannus?
    The ports should be as they are when you download the server files, and you should NOT change them, just forward the ports (5100/6000/8900/7000 - 7777...) or w/e ports you have I forgot what ports should be forwarded sorry, and use TCP/UDP.
    if you don't know how to forward with your router, here you go:
    http://portforward.com/ (choose your router name it will guide you)
    or you can add a network adapter for Gunz, (optional if you have a router), in this situation you can forward your default gateway as DMZ.
    ----------------------------------------------------------------------------------------------------------
    use your IP in exe's files or the No-IP host, or 127.0.0.1 if you want the server private for you (with 127.0.0.1 u don't need to port forward)
    if it didn't work then ask us again :/
    hope it helps <3

  7. #7
    Member James Green is offline
    MemberRank
    Oct 2013 Join Date
    57Posts

    Re: GunZ Database Issue

    Um, my server doesn't need portforwarded as it is hosted off a VPS :S

  8. #8
    Yaaay! Tannous is offline
    MemberRank
    Jul 2012 Join Date
    KonohaLocation
    840Posts

    Re: GunZ Database Issue

    Quote Originally Posted by James Green View Post
    Um, my server doesn't need portforwarded as it is hosted off a VPS :S
    Then perfect, just setup the correct IP's / Ports in the configuration files of the server, and all done.. You don't have to change the ports, unless you have edited them before, the IP change it as I told you in the previous comment :)

  9. #9
    Member James Green is offline
    MemberRank
    Oct 2013 Join Date
    57Posts

    Re: GunZ Database Issue

    That's the problem though. What if I wanted it public should the IP be the the IP I connect to my VPS with and if so, should all the ini files have that IP or should my files have the 127.0.0.1?

  10. #10
    Yaaay! Tannous is offline
    MemberRank
    Jul 2012 Join Date
    KonohaLocation
    840Posts

    Re: GunZ Database Issue

    Yeah it should be the VPS's IP, to make it public (in the VPS go here http://www.whatismyip.com/ you'll find your IP)
    MatchServer IP's:
    Code:
    FREELOGINIP=""
    KEEPERIP="127.0.0.1"
    MONITORIP="127.0.0.1"
    .
    .
    .
    DBAgentIP=127.0.0.1
    MatchAgent:
    Code:
    <MATCHSERVERADDRESS ip="127.0.0.1" tcpport="6000"/>
    <ADDRESS ip="VPS IP" tcpport="7777" udpport="5100"/>
    Locator:
    Code:
    IP="VPS IP"
    As I remember they should be like this :/

  11. #11
    Member James Green is offline
    MemberRank
    Oct 2013 Join Date
    57Posts

    Re: GunZ Database Issue

    Ok, well now the server is running. What should I put in the client as ports though? Match server runs on 6000 so should I put 6000 for the client?

  12. #12
    Yaaay! Tannous is offline
    MemberRank
    Jul 2012 Join Date
    KonohaLocation
    840Posts

    Re: GunZ Database Issue

    Quote Originally Posted by James Green View Post
    Ok, well now the server is running. What should I put in the client as ports though? Match server runs on 6000 so should I put 6000 for the client?
    Well, first I hope you configured your MatchServer as it's in dbo.ServerStatus:
    Code:
    ServerID= 1
    CurrPlayer= 0
    MaxPlayer= 500
    Time= 0:00:00
    IP= VPS IP
    Port= 6000
    ServerName= MatchServer1
    Opened= 1
    Type=4
    // or whatever you did should be the same as server side
    in client side you only have to edit system.xml in system.mrs (of course after decompile it), you need to replace all the IPs with your VPS IP, and that's it.

  13. #13
    Member James Green is offline
    MemberRank
    Oct 2013 Join Date
    57Posts

    Re: GunZ Database Issue

    Ok well there is an AgentIP field, would I put 127.0.0.1 r my VPS IP in there

  14. #14
    Yaaay! Tannous is offline
    MemberRank
    Jul 2012 Join Date
    KonohaLocation
    840Posts

    Re: GunZ Database Issue

    Quote Originally Posted by James Green View Post
    Ok well there is an AgentIP field, would I put 127.0.0.1 r my VPS IP in there
    AgentIP field in where, what file ?!

  15. #15
    Member James Green is offline
    MemberRank
    Oct 2013 Join Date
    57Posts

    Re: GunZ Database Issue

    in the dbo.serverstatus

  16. #16
    Yaaay! Tannous is offline
    MemberRank
    Jul 2012 Join Date
    KonohaLocation
    840Posts

    Re: GunZ Database Issue

    Quote Originally Posted by James Green View Post
    in the dbo.serverstatus
    Oh leave this field empty tho D:

  17. #17
    Member James Green is offline
    MemberRank
    Oct 2013 Join Date
    57Posts

    Re: GunZ Database Issue

    Screenshot to make it easier for you to see what is wrong here -> http://prntscr.com/37hrng MatchServer< MatchAgent XML:http://prntscr.com/37hs26 Locator -> http://prntscr.com/37hsep

    - - - Updated - - -

    See, I wonder how to put the mode as public or online, but I have it on test mode

  18. #18
    Yaaay! Tannous is offline
    MemberRank
    Jul 2012 Join Date
    KonohaLocation
    840Posts

    Re: GunZ Database Issue

    First KEEPERIP should be 127.0.0.1, as I tried this when I made my server and it worked (I dunnu about how you did it if it works or not)
    test that means in the dbo.ServerStatus should be Type 4.
    other options:
    Code:
    debug => 1
    match => 2
    clan => 3
    event => 5
    Make sure the LANGUAGE/COUNTRY in server.ini is the same as the source building type, I mean if you build in BR_Release, then you should type BRZ in both fields, or if you are using Phoenix runnable then, i'm not sure, but it's also BRZ.

  19. #19
    Member James Green is offline
    MemberRank
    Oct 2013 Join Date
    57Posts

    Re: GunZ Database Issue

    Omg i got it working omg omg omg

    - - - Updated - - -

    It was the firewall even thought it was turned off, it was blocking the ports from the program ;D

  20. #20
    Yaaay! Tannous is offline
    MemberRank
    Jul 2012 Join Date
    KonohaLocation
    840Posts

    Re: GunZ Database Issue

    Quote Originally Posted by James Green View Post
    Omg i got it working omg omg omg
    Okay GOOD JOB ;)

  21. #21
    Member James Green is offline
    MemberRank
    Oct 2013 Join Date
    57Posts

    Re: GunZ Database Issue

    Now it says failed to retrieve account information:S?

  22. #22
    Yaaay! Tannous is offline
    MemberRank
    Jul 2012 Join Date
    KonohaLocation
    840Posts

    Re: GunZ Database Issue

    Quote Originally Posted by James Green View Post
    Now it says failed to retrieve account information:S?
    I gotta catch up a lecture, post your problem and i'll see it after I finish my studying :P
    Hopefully fix it too XD

  23. #23
    Member James Green is offline
    MemberRank
    Oct 2013 Join Date
    57Posts

    Re: GunZ Database Issue


  24. #24
    Yaaay! Tannous is offline
    MemberRank
    Jul 2012 Join Date
    KonohaLocation
    840Posts

    Re: GunZ Database Issue

    Quote Originally Posted by James Green View Post
    Probably you didn't create the account correct, make sure you created the account in dbo.Account and dbo.Login (for each ID the same information)

  25. #25
    Member James Green is offline
    MemberRank
    Oct 2013 Join Date
    57Posts

    Re: GunZ Database Issue

    YES, that worked omg, thank you so much!

    - - - Updated - - -

    Now I need to know how to enable quest for the game because it's not listed as a game mode:S

    - - - Updated - - -

    OK 1 last question and this is very important, is there anyway to secure the config.XML? I don't want people seeing my IP for the VPS.



Page 1 of 2 12 LastLast

Advertisement