account create

im using CzF Season 4.5 [1.00.90] files and i cant create an account with Microsoft SQL Server Management.

when i go to memb_info and try to add memb___id and memb__pwd it says 'cannot enter any other value than null'?

please help cus i cant use mumaker (it gives error)

What kind of error does MuMaker sends to you?

I think is more easy to fix it wich trying to insert a account directly to you SQL Management.

Or trying to use another account manager, like MuEditor2.1.

I'll upload it for you.

Good Luck.

when i use that prog it just does nothing when i click account create and correctly fill everything in

Well I'm pretty sure that the database is MD5, and you can't just insert some random data of course u will get null.

How about trying to create the account with Mu Account Create (MD5)? and then edit the character in MuMaker :)

Quote:

---

Originally Posted by alfaiatex

I was trying till he start to be a ass...

By the way, probably he'll not be able to run a sort of "Mu Account Create (MD5)" or something like that. He got problems in his ODBCs Drivers, and without it, it'll unable to connect to his SQL Server to create account, whatever is the Database criptography...

I'll stop, i wish u the best luck with your problem.

---

If you wanted to help in anyway, you'd explain to me how to fix my ODBC drivers. But it wasn't that you stupid. MuMaker doesn't relate with ODBC, but it relates with your TPC/IP configuration of your SQL Manager. I fixed it and now I can succsesfully make accounts and run MuMaker.. (guess im not that kind of a noob).

Only problem is, that my server runs perfect (no errors or something) but when I log in my main.exe (correct serial, version and IP), I select server, try to login with my account and it says 'Your account is invalid'.

When I open my SQL Manager, and click on dbo.MEMB_INFO i see my account there with the password I typed in....

so wtf? @afghann

Now it's serious.

'Your account is invalid' show sometimes when ConnectMember is loaded.
See Serverinfo.dat from your GameServer. Sometimes it happen to be setting on.

Also, Check out JoinServer Cfg. See if is MD5 or not. And check if your MuMaker is creating accounts with same type.

Quote:

---

Originally Posted by alfaiatex

Now it's serious.

'Your account is invalid' show sometimes when ConnectMember is loaded.
See Serverinfo.dat from your GameServer. Sometimes it happen to be setting on.

Also, Check out JoinServer Cfg. See if is MD5 or not. And check if your MuMaker is creating accounts with same type.

---

it's so weird. When I create an account with username: x and password: x with MuMaker (MD5 off), but when I create an account with other usernames (MD5 off) it says account is invalid.

My server files does support MD5 but i turned it off.

This is my gameserver's servinfo.dat:

Code:

---

[GameServerInfo]
ServerName            = GS
ServerCode            = 0
NonPK                = 0
PkLimitFree            = 0
ConnectMemberLoad        = 0
ChangeCharacterName        = 0
NewServer            = 1
EventOff            = 0

---

and joinserver

Code:

---

//------------------------------------------------------//
//            JoinServer Configs                //
//------------------------------------------------------//
[Configs]
UseMD5                    = 0
AutomaticDC                = 1
DupePrevent                = 5

---

my memb__pwd is varchar(50) at my sql server.

you just created an acc using MD5 :P, in joinserver configs, change USEMD5 = 0 to UseMD5 = 1. Put the 'WZ_MD5_MOD.dll' in C:\Program Files\Microsoft SQL Server\MSSQL\Binn\, Go to enterprise manager and right click "MEMB_INFO" table and design. After that edit the "varchar(50) to Varbinary(16) and at last run the following in your query

Code:

---

exec sp_addextendedproc N'XP_MD5_CheckValue', N'WZ_MD5_MOD.dll'
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

---

Download link for the dll : http://www.mediafire.com/?59cw5k7ly2k5kol

Quote:

---

Originally Posted by afghan

you just created an acc using MD5 :P, in joinserver configs, change USEMD5 = 0 to UseMD5 = 1. Put the 'WZ_MD5_MOD.dll' in C:\Program Files\Microsoft SQL Server\MSSQL\Binn\, Go to enterprise manager and right click "MEMB_INFO" table and design. After that edit the "varchar(50) to Varbinary(16) and at last run the following in your query

Code:

---

exec sp_addextendedproc N'XP_MD5_CheckValue', N'WZ_MD5_MOD.dll'
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

---

Download link for the dll : WZ_MD5_MOD.dll

---

Thank you - that solved my problem.