[Help Thread] Please post your questions here.

[ThunderNikk]

Originally Posted by mmno

what the command to send item to player via item box ?

I don't think there is one. I think the item box only links to a functional cash shop.

[.BlackCat.]

Originally Posted by mmno

what the command to send item to player via item box ?

You can do that via SQL Query :

INSERT INTO [Billing].[dbo].[PaidItem] ([buy_id],[account_id],[avatar_id],[avatar_name],[server_name],
            [taken_account_id],[taken_avatar_id],[taken_avatar_name],[taken_server_name],[item_code],
   [item_count],[type],[rest_item_count],[confirmed],[confirmed_time],[bought_time],[valid_time],
   [taken_time],[isCancel],[creationDate_],[updateDate_],[accessDate_],[creatorId_],[updatorId_],
   [portId_],[elixirType],[pk_],[gift]) 
  VALUES (1, /*Account_id*/ ,0,' ','Something',/*Account_id*/ ,0,' ',' ', /*Item_code*/ ,0,0,
         1 /*HowMuch*/ ,1,GETDATE(),GETDATE(),GETDATE() + 50,GETDATE(),0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0)

[Queeni]

Hi I have the problem that the 5.2 server lags can fix the problem?

[.BlackCat.]

Originally Posted by Queeni

Hi I have the problem that the 5.2 server lags can fix the problem?

Fix was already posted.

Originally Posted by thndr

Try adding this...

S log.disable:1

And change N log.working:0

To S log.working:0

[Queeni]

oh overlooked many thanks but still a question how do I get the client to German

[sona998]

Searching for skill animations didn't yield me any definite answers.

Is there a rdb that controls what animation effect each skill does? e.g. For 2-hit/3hit melee pet skills, it has a similar animation to Mental Concentration and a funny hit sound. Fog of Horror has a nice AoE smoke effect, etc.

Been creating new skills, and was wondering can you dictate what certain effect/sound is used for a skill, even perhaps, a combination of them?

Is there a list of these effects somewhere?

[naik127]

Does anyone have a structure item.rdb version 8.3

[Sherock]

Originally Posted by thndr

Don't thank me thank them.

no i'll thank you and them

[mmno]

Originally Posted by thndr

I don't think there is one. I think the item box only links to a functional cash shop.

Originally Posted by .BlackCat.

You can do that via SQL Query :

INSERT INTO [Billing].[dbo].[PaidItem] ([buy_id],[account_id],[avatar_id],[avatar_name],[server_name],
            [taken_account_id],[taken_avatar_id],[taken_avatar_name],[taken_server_name],[item_code],
   [item_count],[type],[rest_item_count],[confirmed],[confirmed_time],[bought_time],[valid_time],
   [taken_time],[isCancel],[creationDate_],[updateDate_],[accessDate_],[creatorId_],[updatorId_],
   [portId_],[elixirType],[pk_],[gift]) 
  VALUES (1, /*Account_id*/ ,0,' ','Something',/*Account_id*/ ,0,' ',' ', /*Item_code*/ ,0,0,
         1 /*HowMuch*/ ,1,GETDATE(),GETDATE(),GETDATE() + 50,GETDATE(),0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0)

isn't there in game command to send item in the player item box ?

[eziorav]

Originally Posted by mmno

isn't there in game command to send item in the player item box ?

no

[KirieZ]

I followed the installation guide from Player95 to create and configure the server but when I launch Aurora Server it throws an exception: " AUTH DB INIT ERROR: [DBNETLIB] [ConnectionOpen (Connect()).] SQL Server doesn't exists or access denied ", did some search and found that it could be port or password, but didn't found a way to fix.
My authserver.opt is: (and yes, it's converted to .eop)

 Spoiler

S db.auth.server:127.0.0.1
S db.auth.name:Auth
S db.auth.account:sa
S db.auth._password:
S app.name:Auth
S log.ip:127.0.0.1
S db.auth.port:1433
S io.auth.port:8841
N db.auth.use_webauth:0
N db.auth.use_md5:1
N db.auth.debug_md5:1
N db.auth.md5_key:2011

The only difference in all of the steps from the guide and mine's is that I installed everything from sql server instead of only some components.

What can I do?
Thanks in advance. Hope my English is understandable.

[Prentis]

Originally Posted by KirieZ

I followed the installation guide from Player95 to create and configure the server but when I launch Aurora Server it throws an exception: " AUTH DB INIT ERROR: [DBNETLIB] [ConnectionOpen (Connect()).] SQL Server doesn't exists or access denied ", did some search and found that it could be port or password, but didn't found a way to fix.
My authserver.opt is: (and yes, it's converted to .eop)

 Spoiler

S db.auth.server:127.0.0.1
S db.auth.name:Auth
S db.auth.account:sa
S db.auth._password:
S app.name:Auth
S log.ip:127.0.0.1
S db.auth.port:1433
S io.auth.port:8841
N db.auth.use_webauth:0
N db.auth.use_md5:1
N db.auth.debug_md5:1
N db.auth.md5_key:2011

The only difference in all of the steps from the guide and mine's is that I installed everything from sql server instead of only some components.

What can I do?
Thanks in advance. Hope my English is understandable.

Does your sa have a pw?

[Cyborg2009]

Hello all, i have problems with the 8.1 register scriipt! he makes not accounts in sql server 2012. Have anyone a helpfull script for using Register Account Script? pls help me.
In old Register stand dbo.Account, but in 8.1 is this dbo.Accounts and any more other as in old register^^

thx for help fast
Cyborg2009

[ThunderNikk]

@KirieZ Did you set the database owner for all of the databases as "sa" as it explains in the guide, and configure "sa" for a blank password until you get deeper along and start to utilize the DES hasher.

If "sa" does not own the databases MSSQL will not allow "sa" to log in from the Auth and Game server .exe

Also if you did not configure "sa" for a blank password the MSSQL may be looking for one.

@Cyborg2009 You just need to edit the script so it matches your database tables.

[Cyborg2009]

i have maked, but don't work he bring me errors^^ i don't know to fix this, i sit for this script at 5 houres and not become fixed