MuWeb Account Manager 0.1

Results 1 to 7 of 7
  1. #1
    Enthusiast zikmar is offline
    MemberRank
    Jul 2009 Join Date
    40Posts

    ! MuWeb Account Manager 0.1

    hi,
    i use this release from this post: http://forum.ragezone.com/f197/muweb...-0-1-a-348636/

    i make all thnigs 2-3-4-5 times
    but i cant create acc in db.MuOnline

    i set up correctly all, but in
    client side acc manager create acc successful

    in db MEMB_INFO i cant see this acc no write in db.

    i design db varbinry 16 i make all of the tutorial.

    where is the problem ?
    eny idea?

    thanks

    p.s
    i use winserver 2003 sp1
    sql2000 sp4
    xampp 1.7.1
    netframework 4
    c++ 2010

    this is corect?
    Code:
    Windows Registry Editor Version 5.00
    
    [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI]
    
    [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\MuOnline]
    "Driver"="C:\\WINDOWS\\System32\\SQLNCLI.dll "
    "Server"="(local)"
    "Database"="MuOnline"
    "LastUser"="sa"
    "Trusted_Connection"="Yes"
    
    [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\Me_MuOnline]
    "Driver"="C:\\WINDOWS\\System32\\SQLNCLI.dll "
    "Server"="(local)"
    "Database"="Me_MuOnline"
    "LastUser"="sa"
    "Trusted_Connection"="Yes"
    
    
    
    [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ODBC Data Sources]
    "MuOnline"="SQL Server"
    
    [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ODBC Data Sources]
    "Me_MuOnline"="SQL Server"
    
    [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ODBC File DSN]
    "DefaultDSNDir"="C:\\Program Files\\Common Files\\ODBC\\Data Sources"
    my db are :
    MuOnline
    MuOline_Event
    MuOnline_Ranking

    (change Me_MuOnline to Muonline_Ranking?)

    i have this error on querly
    Cannot add rows to sysdepends for the current stored procedure because it depends on the missing object 'master.dbo.XP_MD5_EncodeKeyVal'. The stored procedure will still be created.
    Last edited by zikmar; 18-01-13 at 01:31 AM.


  2. #2
    Enthusiast secmob is offline
    MemberRank
    Jan 2013 Join Date
    WonderlandLocation
    25Posts

    Re: MuWeb Account Manager 0.1

    CREATE FUNCTION [dbo].[fn_md5] (@data VARCHAR(10), @data2 VARCHAR(10))
    RETURNS BINARY(16) AS
    BEGIN
    DECLARE @hash BINARY(16)
    EXEC master.dbo.XP_MD5_EncodeKeyVal @data, @data2, @hash OUT
    RETURN @hash
    END
    If you're using MD5, this query should be ran on "Master" Database not MuOnline. As for the program, it is really old, what version of Mu are you running as it might cause problems.

  3. #3
    Enthusiast zikmar is offline
    MemberRank
    Jul 2009 Join Date
    40Posts

    Re: MuWeb Account Manager 0.1

    Quote Originally Posted by secmob View Post
    If you're using MD5, this query should be ran on "Master" Database not MuOnline. As for the program, it is really old, what version of Mu are you running as it might cause problems.
    i use season 2 srtem files from this post
    http://forum.ragezone.com/f197/muser...ii-new-874695/

    i take this error
    Server: Msg 2714, Level 16, State 5, Procedure fn_md5, Line 6
    There is already an object named 'fn_md5' in the database.

  4. #4
    Enthusiast secmob is offline
    MemberRank
    Jan 2013 Join Date
    WonderlandLocation
    25Posts

    Re: MuWeb Account Manager 0.1

    Are you able to run client & log in to an account? Seems like you don't have MD5 enabled for your server. Do check that you have done the necessary MD5 configuration here

  5. #5
    Enthusiast zikmar is offline
    MemberRank
    Jul 2009 Join Date
    40Posts

    Re: MuWeb Account Manager 0.1

    Quote Originally Posted by secmob View Post
    Are you able to run client & log in to an account? Seems like you don't have MD5 enabled for your server. Do check that you have done the necessary MD5 configuration here

    no i get dc when i try to log in.

    after i change on joinserver
    [Configs]
    UseMD5 = 1
    AutomaticDC = 1
    DupePrevent = 5

    and log in success

    i have done all this of tutoriall
    and still same.

  6. #6
    Enthusiast secmob is offline
    MemberRank
    Jan 2013 Join Date
    WonderlandLocation
    25Posts

    Re: MuWeb Account Manager 0.1

    The error you described in first post looks like you haven't ran the Query below in MuOnline database.

    CREATE FUNCTION [dbo].[fn_md5] (@data VARCHAR(10), @data2 VARCHAR(10))
    RETURNS BINARY(16) AS
    BEGIN
    DECLARE @hash BINARY(16)
    EXEC master.dbo.XP_MD5_EncodeKeyVal @data, @data2, @hash OUT
    RETURN @hash
    END
    And I think I mistyped that you should run this in Master previously. Sorry about that. If it still doesn't work, then I'm out of options. It might be ODBC settings or the configuration of MuWeb Account Manager.

    Sorry if I'm not of much help. Hope you find your answer or someone else has answers for you.

  7. #7
    Enthusiast zikmar is offline
    MemberRank
    Jul 2009 Join Date
    40Posts

    Re: MuWeb Account Manager 0.1

    Quote Originally Posted by secmob View Post
    The error you described in first post looks like you haven't ran the Query below in MuOnline database.



    And I think I mistyped that you should run this in Master previously. Sorry about that. If it still doesn't work, then I'm out of options. It might be ODBC settings or the configuration of MuWeb Account Manager.

    Sorry if I'm not of much help. Hope you find your answer or someone else has answers for you.
    thanks :)



Advertisement