[Help Thread] Please post your questions here.

[sunnyxie49]

Hi i need yours help
i created a c# project, almost finished
Now there is a problem
need one button_Click send some message(command) to authserver(PrincessAuroraServer.exe) or gameserver(CaptainHerlockServer.exe)
I need someone to tell me ,what should I do.



now i use SendKeys work for it
have other ways to do it?

[nimoht]

Originally Posted by sunnyxie49

Hi i need yours help
i created a c# project, almost finished
Now there is a problem
need one button_Click send some message(command) to authserver(PrincessAuroraServer.exe) or gameserver(CaptainHerlockServer.exe)
I need someone to tell me ,what should I do.



now i use SendKeys work for it
have other ways to do it?

You need to create an Telnet ( TCP) client in your application using the console_allow_ip ip, console_port port and console_password password for authentication, when your tcp client as connected and logged, you can send commands to gameserver, auth server don't know.

insert_item don't work.

good luck!

[thund22222]

hello, i need some help! i have problem with delete character
whenever i want to delete the character window appears enter pass!!?

[ThunderNikk]

Try adding these to the gameserver.opt...

S game.use_storage_security:0
S game.check_storage_security_always:0
S game.use_delete_security:0

[thund22222]

Originally Posted by thndr

Try adding these to the gameserver.opt...

S game.use_storage_security:0
S game.check_storage_security_always:0
S game.use_delete_security:0

thanks , but i have question
how can i use securityNo where password is stored?

[ThunderNikk]

Maybe password2 in account table?

Keep in mind it is limited to a 6 digit pin numbers only.

You will have to add it to your account creation and you will have to create a way for users to be able to update or change their security password through your website.

[thund22222]

you experience password2 in table account but is not also you try securityno table failed
i just want to know where to store password

[ThunderNikk]

If you are going to make me MD5 hash a 6 digit password and put it in password2 in the account table and change my gameserver.opt just to find out for you...

It is telecaster.dbo.SecurityNo

I am still working on making it work.

[XavierDeFawks]

Originally Posted by thndr

Try adding these to the gameserver.opt...

S game.use_storage_security:0
S game.check_storage_security_always:0
S game.use_delete_security:0

N game.use_security:0
You are missing this one.

Originally Posted by thndr

If you are going to make me MD5 hash a 6 digit password and put it in password2 in the account table and change my gameserver.opt just to find out for you...

It is telecaster.dbo.SecurityNo

I am still working on making it work.

If you are trying to get SecurityNo to work i can help you with this.

[thund22222]

Originally Posted by xXExiledXx

N game.use_security:0
You are missing this one.



If you are trying to get SecurityNo to work i can help you with this.

thanks, yeh i try to make it work

[XavierDeFawks]

The SecurityNo is set in the SecurityNo table in telecaster. For mine telecaster was all set up i only needed 2 things to make it work.

This smp in your Auth database.

 Spoiler

-- start of dbo.smp_check_security
CREATE PROCEDURE [dbo].[smp_check_security]
@IN_ACCOUNT VARCHAR(60),
@IN_SECURITY VARCHAR(60)
AS
SET NOCOUNT ON

IF @IN_ACCOUNT LIKE '@%' AND CONVERT( VARBINARY, @IN_SECURITY ) = CONVERT( VARBINARY, '0000000' ) AND EXISTS ( SELECT * FROM Account WHERE account = @IN_ACCOUNT )
BEGIN
SELECT @IN_ACCOUNT AS account;
END
ELSE
BEGIN
--SELECT account FROM tb_account WHERE account = @IN_ACCOUNT AND LEN( jumin ) = 14 AND SUBSTRING( jumin, 8, 7 ) = @IN_SECURITY
SELECT account FROM Account WHERE account = @IN_ACCOUNT AND password = @IN_SECURITY --LEN( password ) = 14 AND SUBSTRING( jumin, 8, 7 ) = @IN_SECURITY
END

-- end of dbo.smp_check_security

GO

And set this value in ur authserver.opt

N db.auth.use_md5_for_security_no:1

And SecurityNo should work.

[thund22222]

Originally Posted by xXExiledXx

The SecurityNo is set in the SecurityNo table in telecaster. For mine telecaster was all set up i only needed 2 things to make it work.

This smp in your Auth database.

 Spoiler

-- start of dbo.smp_check_security
CREATE PROCEDURE [dbo].[smp_check_security]
@IN_ACCOUNT VARCHAR(60),
@IN_SECURITY VARCHAR(60)
AS
SET NOCOUNT ON

IF @IN_ACCOUNT LIKE '@%' AND CONVERT( VARBINARY, @IN_SECURITY ) = CONVERT( VARBINARY, '0000000' ) AND EXISTS ( SELECT * FROM Account WHERE account = @IN_ACCOUNT )
BEGIN
SELECT @IN_ACCOUNT AS account;
END
ELSE
BEGIN
--SELECT account FROM tb_account WHERE account = @IN_ACCOUNT AND LEN( jumin ) = 14 AND SUBSTRING( jumin, 8, 7 ) = @IN_SECURITY
SELECT account FROM Account WHERE account = @IN_ACCOUNT AND password = @IN_SECURITY --LEN( password ) = 14 AND SUBSTRING( jumin, 8, 7 ) = @IN_SECURITY
END

-- end of dbo.smp_check_security

GO

And set this value in ur authserver.opt

N db.auth.use_md5_for_security_no:1

And SecurityNo should work.

thank you very much i will try ...

[ThunderNikk]

Originally Posted by xXExiledXx

The SecurityNo is set in the SecurityNo table in telecaster. For mine telecaster was all set up i only needed 2 things to make it work.

This smp in your Auth database.

 Spoiler

-- start of dbo.smp_check_security
CREATE PROCEDURE [dbo].[smp_check_security]
@IN_ACCOUNT VARCHAR(60),
@IN_SECURITY VARCHAR(60)
AS
SET NOCOUNT ON

IF @IN_ACCOUNT LIKE '@%' AND CONVERT( VARBINARY, @IN_SECURITY ) = CONVERT( VARBINARY, '0000000' ) AND EXISTS ( SELECT * FROM Account WHERE account = @IN_ACCOUNT )
BEGIN
SELECT @IN_ACCOUNT AS account;
END
ELSE
BEGIN
--SELECT account FROM tb_account WHERE account = @IN_ACCOUNT AND LEN( jumin ) = 14 AND SUBSTRING( jumin, 8, 7 ) = @IN_SECURITY
SELECT account FROM Account WHERE account = @IN_ACCOUNT AND password = @IN_SECURITY --LEN( password ) = 14 AND SUBSTRING( jumin, 8, 7 ) = @IN_SECURITY
END

-- end of dbo.smp_check_security

GO

And set this value in ur authserver.opt

N db.auth.use_md5_for_security_no:1

And SecurityNo should work.

I have tried all kinds of different ways.

With Auth emu

Not sure if this works in the auth emu but I used the auth emu queries for SecurityNo

N db.auth.use_md5_for_security_no:1

sql.db_securitynocheck.param.account:1
sql.db_securitynocheck.param.security_no:2
sql.db_securitynocheck.query:{CALL smp_check_security(?, ?)}

1. Plain text entry in SecurityNo

2. MD5 entry in SecurityNo

3. MD5 with 2011 salt entry in SecurityNo

Regular Princess Aurora for 9.1

1. Plain text entry in SecurityNo

N db.auth.use_md5_for_security_no:0

2. MD5 entry in SecurityNo

N db.auth.use_md5_for_security_no:1

3. MD5 with 2011 salt entry in SecurityNo

N db.auth.use_md5_for_security_no:1

No mater which way I try it always returns that my password is incorrect.

I don't need it anyway I was just trying to help Thund22222

[XavierDeFawks]

Ah I was using the official auth server. When it tells you your password is incorrect that probably means smp_check_security didnt return a value. Atleast that was the cause in my case. I had to edit it because the in value for password was set as 11 while md5 is a constant 32 so it was truncating data for me.

[thund22222]

thank you anyway, i will try

i have another question how do i give the player temporary pet after 7 days it disappears automatically?