[Help Thread] Please post your questions here.

Page 313 of 586 « First 213263303311312 313 314315323363413 Last »
05/22/2015 16:37 smoegsmoeg#4681
Quote:
Originally Posted by thndr View Post
Learn to fish.

1) select * from arcadia.dbo.ItemResource where icon_file_name like '%retraining%'

920013

2) select * from arcadia.dbo.ItemResource where icon_file_name like '%growth%'

900014
900015
900016
900017
900018

3) Hidden village buffs, Master class buffs, GM buffs. Make your hidden village buffer buff all three and you are set. Strange you would ask a "How to play the game" question though.
Thanks - and yes I'm trying to learn - so that was awefully helpfull.
In regard to the buffs - yes i could make "event buffs" but those don't apply to the pet sadly - My question was more to the point: on alot of private servers there are "buff pets" you can summon that buff you - I was looking for something like that. since my search did not really gave me the answers i was looking for (like: install this pet into the database and how) oor (more likly) i was searching for the wrong terms - so i did not find the how to threat that explains it :)

thank you though for your fishing tipps :)
05/22/2015 17:30 ThunderNikk#4682
Master class buffs and GM buffs both buff the pets.

Here is some of the scripts I have on my HV buffer "NPC_Buff.lua"...


There is a charge function on the master class buffs you can change if you want.

There is also a permission check on the server buffs or GM buffs that buff the entire server you need to be a GM in order to order the buffs you can change that if you want also.

With everything in there it makes you and your pets pretty unstoppable.
05/22/2015 17:43 beecloven#4683
Is there an unique key or hash key for each field of the file in "Step Two" its User Password or something other? Thank you for previous answer =)
05/22/2015 17:59 ThunderNikk#4684
It is just for generating completely random passwords.

You will create a log in name for each database and a randomly generated password if you wish for the best security...

Example

Database: Auth
User: Apple Pie
Password: phnni4ZJoAKStdSghIARiK

Database: Arcadia
User: Nonyabuisness
Password: gIAZJ2KqhcDj0MNnw5oM5e

Database: Telecaster
User: Whateveryouwant
Password: KsQxtdcoSo03CXuO6n6J6M
05/23/2015 11:01 beecloven#4685
When i starting auth and game server then try to log in i get the message in console "[ODBC SQL Server Driver][SQL Server]Changed database context to 'auth' and invalid object name 'account'". The password "admin" has been hashed to md5 key like "2011admin" and it's "613b5247e3398350918cb622a3ec19e9". The table in auth SQL database called "dbo.Accounts". What's wrong with that? And can i use old auth version? Thanks in advance.
There is my configs.
auth.opt
common.opt
gameserver.opt
05/23/2015 11:20 sergeu1988#4686
Hello everyone, if you can, give guide how to make launcher with autoreload to 9.1. thanks in advance
05/23/2015 16:57 ismokedrow#4687
Quote:
Originally Posted by beecloven View Post
When i starting auth and game server then try to log in i get the message in console "[ODBC SQL Server Driver][SQL Server]Changed database context to 'auth' and invalid object name 'account'". The password "admin" has been hashed to md5 key like "2011admin" and it's "613b5247e3398350918cb622a3ec19e9". The table in auth SQL database called "dbo.Accounts". What's wrong with that? And can i use old auth version? Thanks in advance.
There is my configs.
auth.opt
common.opt
gameserver.opt
Obvious error is obvious mate. 'Invalid object[table] dbo.Account' means your dbo.Auth doesn't contain a table or object by the name of dbo.Account. E.g. yours is likely auth.dbo.Accounts.

Take a good hard look at the documentation provided by glandu in the release thread of the Auth emulator.
05/23/2015 17:06 beecloven#4688
Quote:
Originally Posted by ismokedrow View Post
Obvious error is obvious mate. 'Invalid object[table] dbo.Account' means your dbo.Auth doesn't contain a table or object by the name of dbo.Account. E.g. yours is likely auth.dbo.Accounts.

Take a good hard look at the documentation provided by glandu in the release thread of the Auth emulator.
Thanks for answer but i did everything by the guide xD. May be need something else to complete guide.
05/23/2015 18:35 ThunderNikk#4689
He said read the auth emulator thread carefully.

It explains what to do if your Auth account table is named differently.

dbo.account

or

dbo.accounts

He said nothing about reading the guide more carefully.
05/23/2015 18:54 beecloven#4690
Quote:
Originally Posted by thndr View Post
He said read the auth emulator thread carefully.

It explains what to do if your Auth account table is named differently.

dbo.account

or

dbo.accounts

He said nothing about reading the guide more carefully.
I mean add some links for Auth emulator to complete the guide.
05/23/2015 19:29 ismokedrow#4691
Like the link below?

[Only registered and activated users can see links. Click Here To Register...]
05/23/2015 19:35 beecloven#4692
Quote:
Originally Posted by ismokedrow View Post
Like the link below?

[Only registered and activated users can see links. Click Here To Register...]
There is old version.
05/23/2015 20:17 king1king#4693
Hello guys
Help files Revolution
Ostata not add any files when Shi save anything Balskl of the RBD RAPPELZ Glandu2
Show me problems in Alarcadia
I can not to run the server I hope to help

And also I need to Terra wings :) what he wants to help

Thank you for all

sorry for bad english
05/23/2015 21:04 ThunderNikk#4694
Quote:
Originally Posted by beecloven View Post
There is old version.
The most recent version is on page one of the forums...

[Only registered and activated users can see links. Click Here To Register...]

Are you for real?

To hell with the search feature you need to learn to use your mouse scroll wheel.

EDIT: I was mistaken only the older version linked in the guide has the proper instructions on how to run the account queries.

Here for your laziness...

#If the table name is "account":
sql.db_account.query:SELECT * FROM account WHERE account = ? AND password = ?;
sql.db_updatelastserveridx.query:UPDATE account SET last_login_server_idx = ? WHERE account_id = ?;

#If the table name is "accounts" (just change the sql query):
#sql.db_account.query:SELECT * FROM accounts WHERE account = ? AND password = ?;
#sql.db_updatelastserveridx.query:UPDATE accounts SET last_login_server_idx = ? WHERE account_id = ?;
05/23/2015 21:23 beecloven#4695
Quote:
Originally Posted by thndr View Post
The most recent version is on page one of the forums...

[Only registered and activated users can see links. Click Here To Register...]

Are you for real?

To hell with the search feature you need to learn to use your mouse scroll wheel.

EDIT: I was mistaken only the older version linked in the guide has the proper instructions on how to run the account queries.

Here for your laziness...

#If the table name is "account":
sql.db_account.query:SELECT * FROM account WHERE account = ? AND password = ?;
sql.db_updatelastserveridx.query:UPDATE account SET last_login_server_idx = ? WHERE account_id = ?;

#If the table name is "accounts" (just change the sql query):
#sql.db_account.query:SELECT * FROM accounts WHERE account = ? AND password = ?;
#sql.db_updatelastserveridx.query:UPDATE accounts SET last_login_server_idx = ? WHERE account_id = ?;
I just can't understand why you didn't answer if you knew it. It looks like a bit stranger than you said about my laziness.
Page 313 of 586 « First 213263303311312 313 314315323363413 Last »