[Share] RanGS GMCharEdit

Page 3 of 4 FirstFirst 1234 LastLast
Results 31 to 45 of 48
  1. #31
    Member Noritsu is offline
    MemberRank
    May 2009 Join Date
    67Posts

    Re: [Share] RanGS GMCharEdit

    Your user accounts should be in the GSUSerInfo. Which means, whichever GM accounts you use to login in-game is the one you use to login in the GMCharEdit

  2. #32
    Account Upgraded | Title Enabled! Hezuka is offline
    True MemberRank
    Mar 2013 Join Date
    253Posts

    Re: [Share] RanGS GMCharEdit

    Quote Originally Posted by calibur17 View Post
    Have you already enabled the tcp/ip config of your sql? > If yes, have you restarted it? If No, retart it first > If YES and still gets the error, try checking if you have the GMCharEdit.cfg and delete it then try again.
    any desk to me please to fixed this :(
    Signature rules violation

    Please read our forum rules over again.

  3. #33
    Account Upgraded | Title Enabled! caspian0 is offline
    True MemberRank
    Jul 2012 Join Date
    1,303Posts

    Re: [Share] RanGS GMCharEdit

    Quote Originally Posted by Hezuka View Post
    any desk to me please to fixed this :(
    pm me your anydesk

  4. #34
    Account Upgraded | Title Enabled! Hezuka is offline
    True MemberRank
    Mar 2013 Join Date
    253Posts

    Re: [Share] RanGS GMCharEdit

    Quote Originally Posted by caspian0 View Post
    pm me your anydesk
    done to pm
    Signature rules violation

    Please read our forum rules over again.

  5. #35
    Ultimate Member calibur17 is offline
    MemberRank
    Mar 2011 Join Date
    174Posts

    Re: [Share] RanGS GMCharEdit

    Quote Originally Posted by jhesociety View Post
    Do i need to add same info on GSUserInfo or just only UserInfo table??
    Do it on both GSUserInfo & UserInfo jsut to be sure.

  6. #36
    Member Noritsu is offline
    MemberRank
    May 2009 Join Date
    67Posts

    Re: [Share] RanGS GMCharEdit

    Quote Originally Posted by calibur17 View Post
    Do it on both GSUserInfo & UserInfo jsut to be sure.
    As far as I know, should just be GSUserInfo. If you find a reason to put it in the UserInfo table please inform me

  7. #37
    Registered Rekesan is offline
    MemberRank
    Dec 2020 Join Date
    18Posts

    Re: [Share] RanGS GMCharEdit

    After editing your XML, execute this query in your sql.

    PHP Code:
    USE [RanUser]
    GO
    /****** Object:  StoredProcedure [dbo].[gm_login]    Script Date: 3/8/2021 2:04:46 PM ******/
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER OFF
    GO

    ALTER PROCEDURE 
    [dbo].[gm_login]

    \@
    userId        char(50),
    \@
    userPass     char(50),
    \@
    authenticate char(50),
    \@
    userIp    char(50OUTPUT,
    @
    nReturn int OUTPUT
        
    AS
        DECLARE  \@
    NuserNum    int,
           \@
    NuserType    int

        SET NOCOUNT ON    SET

    @nReturn 0    SET  \@NuserNum 0

            SELECT  
    \@NuserNum GSUserInfo.UserNum, \@NuserTypeGSUserInfo.UserType
        
    FROM
    GSUserInfo

         WHERE GSUserInfo
    .UserID = \@userId AND GSUserInfo.UserPass = \@userPass AND GSUserInfo.UserAvailable AND GSUserInfo.UserType>=20

    -- ID PWD ??...    

    IF  \@
    NuserNum 0    BEGIN

    -- ID PWD ??? ?? ???????

            
    SET @nReturn 0
        END
        
    ELSE
        
    BEGIN

            
    -- ID PWD ??

            
    SET @nReturn =  \@Nuser+Type

    -- ???? ???

            
    INSERT INTO LogGmCmd (UserNumGmCmd)

            
    VALUES   \@NuserNum'LOGIN GMTOOL UserID:' + \@userId)

        
    END    

        SET NOCOUNT OFF    

        
    RETURN @nReturn 

  8. #38
    Ultimate Member calibur17 is offline
    MemberRank
    Mar 2011 Join Date
    174Posts

    Re: [Share] RanGS GMCharEdit

    Quote Originally Posted by Noritsu View Post
    As far as I know, should just be GSUserInfo. If you find a reason to put it in the UserInfo table please inform me
    Actually don't have a reason for it. I just did it back when i was testing your app and everything worked well so i just left it there on both
    Guess i can remove it already then? Thanks!

  9. #39
    Member Noritsu is offline
    MemberRank
    May 2009 Join Date
    67Posts

    Re: [Share] RanGS GMCharEdit

    Quote Originally Posted by calibur17 View Post
    Actually don't have a reason for it. I just did it back when i was testing your app and everything worked well so i just left it there on both
    Guess i can remove it already then? Thanks!
    I want to delete that table entirely. If it's being referenced by something in the source, I need to find it so it can be changed. Still scouring a massive source code. This is way to much work for one person

  10. #40
    Member 4k0cDh4n is offline
    MemberRank
    Mar 2021 Join Date
    Behind ULocation
    36Posts

    Re: [Share] RanGS GMCharEdit

    Quote Originally Posted by Noritsu View Post
    Since most of you are having problems running the GMCharEdit using ADO. Here's my source
    I have fixed and changed a few things.
    • The ADO config does not use an encrypted user, pass, ip, and DB
    • No more Xtremetools pro required
    • Character name search works


    if you want to see what i have changed, use winmerge
    Download Link
    https://www.mediafire.com/file/hl96w...rEdit.rar/file


    link to the config file: http://forum.ragezone.com/f528/share...ml#post9069869

    GMCharEdit.xml
    Code:
    <?xml version="1.0" standalone="yes"?>
    <groups>
        <group>
        <title>International Server</title>
            <userdb>
                <name>RanUser</name>
                <ip>127.0.0.1,50711 OR DESKTOP-TRASH\SQLEXPRESS01</ip>
                <id>sa</id>
                <pw>1234</pw>
            </userdb>
            <gamedb>
                <name>RanGameS1</name>
                <ip>127.0.0.1,50711 OR DESKTOP-TRASH\SQLEXPRESS01</ip>
                <id>sa</id>
                <pw>1234</pw>
            </gamedb>
            <logdb>
                <name>RanLogS1</name>
                <ip>127.0.0.1,50711 OR DESKTOP-TRASH\SQLEXPRESS01</ip>
                <id>sa</id>
                <pw>1234</pw>
            </logdb>
        </group>
    </groups>
    Edit:
    I guess it's not clear for some people:
    Your account login should be saved in GSUserInfo with type 30 (specifically accounts with usertype at least 20). In other words, whatever GM account you login in-game is the one you also use for this tool.

    thanks



    tip:
    dont forget to execute script for gm login also enable sql tcp conn so you can use gmc outside your server network and make sure allow it from your windows firewall

  11. #41
    Ultimate Member abn0rmalism0 is offline
    MemberRank
    Apr 2020 Join Date
    177Posts

    Re: [Share] RanGS GMCharEdit

    how to build gmcharedit? i always got error

  12. #42
    Account Upgraded | Title Enabled! caspian0 is offline
    True MemberRank
    Jul 2012 Join Date
    1,303Posts

    Re: [Share] RanGS GMCharEdit

    Quote Originally Posted by abn0rmalism0 View Post
    how to build gmcharedit? i always got error
    make sure you have updated toolkit in ranthirdparty..

  13. #43
    Ultimate Member abn0rmalism0 is offline
    MemberRank
    Apr 2020 Join Date
    177Posts

    Re: [Share] RanGS GMCharEdit

    Quote Originally Posted by caspian0 View Post
    make sure you have updated toolkit in ranthirdparty..
    i have updated but still error can you help me?

  14. #44
    Ultimate Member rcanary is offline
    MemberRank
    Feb 2018 Join Date
    152Posts

    Re: [Share] RanGS GMCharEdit

    it has an error while build. do you have a gmcharedit application only? thank you.
    i hope someone share,


    - - - Updated - - -

    Quote Originally Posted by caspian0 View Post
    make sure you have updated toolkit in ranthirdparty..

    i already updated the toolkit but keeps prompt the error on build, do you have a application only?, i would like to try the gmcharedit exe, thank you.

  15. #45
    Member Rima1423 is offline
    MemberRank
    Jan 2021 Join Date
    40Posts

    Re: [Share] RanGS GMCharEdit

    solved
    Last edited by Rima1423; 29-04-21 at 06:39 AM.



Page 3 of 4 FirstFirst 1234 LastLast

Advertisement