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?
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.
Originally Posted by Dens666
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. :?
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)
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.
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?
Obviously didn't try what I told you.
i did that,
still not workingCode: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
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...
you mean execute? i did that
check your cabal_tool_registerAccount_web if ID / PW was varchar 32 and email was varchar 100 it might that is your problem even your query are Null
yes, it is ID / PW varchar 32 and email varchar 100
invalid object name cabal_auth_table, the fuck ? Is your table there even ?
yep, screenshot is upthere somewhere
Last edited by jslim; 04-07-16 at 11:50 PM.
try not null the id and email same to query and dbo table
nope, not working
Hell..... Dude....
At first check your Account.cabal_auth_table if the password field has a size of 100. If not: change it!
Next check all your procedures that the password field match the same size (100), if not change it to 100!
As PunkS7yle said before:
in SQL 2014 pwdencrypt needs a size of 70 so you can change the default size from 50 or whatever to 100
But this needs also to be changed in the procedures of which you can create an account.
If you dont know how to solve your problem, you should first learn how databases works, how mssql works and / or start over again and try and try.
But nevermind :) good luck :)
Reply With Quote