[Help Thread] Please post your questions here.

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?

Quote:

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!:rtfm:

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

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

Quote:

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?

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.

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

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.

Quote:

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. :)

Quote:

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.

Quote:

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

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.

And set this value in ur authserver.opt

N db.auth.use_md5_for_security_no:1

And SecurityNo should work.

Quote:

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 ...

Quote:

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

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.

thank you anyway, i will try :)

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