GM Tools/MSSQL server issue

for start i need to tell ya that i've installed mssql 2014(2008 didn't work on windows 10), i've connected succesfull but when i try to create an account i have these errors. screens attached. Any ideeas?

Yes, i have an idea why it happens.
Use clean database which has been released by Extornia (http://forum.ragezone.com/f459/extor...v1-0-a-906897/) this will work for 100%.
At the moment you probably use some other release database, which have edited stored procedures and GM tool is not adjusted to it.

Quote:

---

Originally Posted by Dens666

Yes, i have an idea why it happens.
Use clean database which has been released by Extornia (http://forum.ragezone.com/f459/extor...v1-0-a-906897/) this will work for 100%.
At the moment you probably use some other release database, which have edited stored procedures and GM tool is not adjusted to it.

---

Hello Dens666
i use Extornias DB Files and mssql 2014. everything work fine but now i want to play and need to register an account.
the bega tool does not work. it says connection was ok but when i try to create i get errors.

Can someone pls tell me the sql command to create an account, especially for the password, because i dont know how to encrypt it to a hash to store it in the password column in the database.
So i could finally make a new Tool by myself and share it.

Quote:

---

Originally Posted by manticore

Hello Dens666
i use Extornias DB Files and mssql 2014. everything work fine but now i want to play and need to register an account.
the bega tool does not work. it says connection was ok but when i try to create i get errors.

Can someone pls tell me the sql command to create an account, especially for the password, because i dont know how to encrypt it to a hash to store it in the password column in the database.
So i could finally make a new Tool by myself and share it.

---

You might as well just look into stored procedures, rather than looking for existing queries every time. :?

Quote:

---

Originally Posted by ShadowGohan

You might as well just look into stored procedures, rather than looking for existing queries every time. :?

---

i dont understand what you are mean. My problem is the tool does not work i think its because i use a mssql 2014 database. SO thought to know the sql command to create an account it would solve my problem.
A command to write data into database i know but i dont now how to create a password. Is it MD5 hashed or something other hashed????? thats my problem :D

- - - Updated - - -

ok now i understand what you said.
i looked around in the database and found some procedures and tried something.

insert into cabal_auth_table( ID, Password )
values('test', pwdencrypt('test') )

does not work

if i use the procedures to create an account like in other thread said, is does not work too.

i always get this error and i think the password creation is wrong.

Meldung 8152, Ebene 16, Status 11, Zeile 1
Zeichenfolgen- oder Binärdaten würden abgeschnitten.

Means
Strings or binarydata will cutted.

after i executed these lines i always get this error.

Pls help

PWDencrypt in sql 2014 outputs a 70 byte binary string, while in earlier versions it's only 26 bytes, modify your auth table and set the varbinary(50) value to varbinary(100)

Quote:

---

Originally Posted by PunkS7yle

PWDencrypt in sql 2014 outputs a 70 byte binary string, while in earlier versions it's only 26 bytes, modify your auth table and set the varbinary(50) value to varbinary(100)

---

very big thank :) will try that today in a view hours.

So i think its not neccessary to make a new tool, because the old one should work then.

Quote:

---

Originally Posted by manticore

So i think its not neccessary to make a new tool, because the old one should work then.

---

That is correct.

Quote:

---

Originally Posted by PunkS7yle

That is correct.

---

I also needed to change the procedure!!
Now i works with mssql 2014

i still have the problem posted, tryed a lot of things.. something concrete to do please?

Quote:

---

Originally Posted by jslim

i still have the problem posted, tryed a lot of things.. something concrete to do please?

---

Quote:

---

Originally Posted by PunkS7yle

PWDencrypt in sql 2014 outputs a 70 byte binary string, while in earlier versions it's only 26 bytes, modify your auth table and set the varbinary(50) value to varbinary(100)

---

Obviously didn't try what I told you.

i did that,

Code:

---

USE [Account]
GO

UPDATE [dbo].[cabal_auth_table]
  SET [ID] = <ID, varchar(50),>
      ,[Password] = <Password, varbinary(100),>
      ,[Login] = <Login, int,>
      ,[LoginTime] = <LoginTime, datetime,>
      ,[LogoutTime] = <LogoutTime, datetime,>
      ,[AuthType] = <AuthType, int,>
      ,[PlayTime] = <PlayTime, int,>
      ,[IdentityNo] = <IdentityNo, char(13),>
      ,[LoginEx] = <LoginEx, int,>
      ,[LastIp] = <LastIp, char(16),>
      ,[AuthKey] = <AuthKey, varchar(32),>
      ,[nation_Code] = <nation_Code, int,>
      ,[createDate] = <createDate, datetime,>
      ,[Email] = <Email, varchar(200),>
      ,[IP] = <IP, varchar(50),>
      ,[Question] = <Question, varchar(200),>
      ,[Answer] = <Answer, varchar(200),>
      ,[LoginCounter] = <LoginCounter, int,>
 WHERE <Search Conditions,,>
GO

---

still not working

Run cabal_tool_registerAccount_web and if the account generated by it doesn't work show table data.

i can't post it..forum don't let me

- - - Updated - - -

what do you mean run it? i tryed to execute it, not working

You should learn how to run a stored procedure before you're trying to run a server...