[Help Thread] Please post your questions here.

smoegsmoeg · 05/22/2015, 16:37

Quote:

Originally Posted by thndr

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

ThunderNikk · 05/22/2015, 17:30

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

Spoiler

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.

beecloven · 05/22/2015, 17:43

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 =)

ThunderNikk · 05/22/2015, 17:59

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

beecloven · 05/23/2015, 11:01

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

Spoiler

common.opt

Spoiler

gameserver.opt

Spoiler

sergeu1988 · 05/23/2015, 11:20

Hello everyone, if you can, give guide how to make launcher with autoreload to 9.1. thanks in advance

~~ismokedrow~~ · 05/23/2015, 16:57

Quote:

Originally Posted by beecloven

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

Spoiler

auth.db.server:127.0.0.1
auth.db.port:1433
auth.db.name:auth
auth.db.account:sa

auth.clients.maxpublicserveridx:10

sql.db_account.column.serveridxoffset:server_list_ mask

%include:common.opt

common.opt

Spoiler

core.log.level:trace
core.log.consolelevel:info

#trafficdump.enable:true

auth.db.password:
auth.db.salt:2011

auth.clients.ip:0.0.0.0
auth.clients.port:58422
auth.clients.des_key:2011

auth.gameserver.ip:127.0.0.1
auth.gameserver.port:4502

upload.dir=upload
upload.clients.ip=0.0.0.0
upload.clients.port=32214
upload.clients.webport:5000

upload.gameserver.ip:127.0.0.1
upload.gameserver.port:4616

gameserver.opt

Spoiler

S:app.name:Game001
T:auth.server_idx:1
S:auth.server_name:Test
S:db.c.server:127.0.0.1
S:db.c.name:arcadia
S:db.c.account:sa
S:db.c._password:
S:db.user.server:127.0.0.1
S:db.user.name:telecaster
S:db.user.account:sa
S:db.user._password:
N:io.port:15574
S:io.auth.ip:127.0.0.1
S:io.ip_address:127.0.0.1
S:log.chat.ip:127.0.0.1
S:log.ip:127.0.0.1
T:log.chat.working:0
T:log.working:0
T:log.disable:1
S:game.mem_usage_info_save_interval:9999999
F:game.base_ethereal_durability_consumption_on_dam age:.30
F:game.base_ethereal_durability_consumption_on_ski ll_attack:.40
F:game.base_ethereal_durability_consumption_on_nor mal_attack:.10
F:game.pvp_damage_rate_for_summon:.12
F:game.pvp_damage_rate_for_player:.08
S game.exp_rate:5
S game.item_drop_rate:1
S game.gold_drop_rate:2
S game.chaos_drop_rate:2
T game.apply_stamina_bonus_in_premium_pcb:0
F game.premium_pcbang_bonus_rate:.30
F game.premium_pcbang_chaos_bonus_rate:.30
F game.premium_pcbang_gold_bonus_drop_rate:.30
F game.premium_pcbang_item_bonus_drop_rate:.30
F game.premium_pcbang_chaos_bonus_drop_rate:.30
F game.ally_pcbang_bonus_rate:.30
S game.ally_pcbang_chaos_bonus_rate:.30
T:game.update.version:24
T:game.max_level:180
T:game.PKServer:0
T:game.AdultServer:0
T:game.cash_usable_server:1
S:game.local_flag:4
T:game.min_global_chat_usable_level:10
T:game.use_auto_trap:0
T:game.use_auto_jail:0
T:game.ServiceServer:0
N:console.port:44554
S:console.allow_ip:127.0.0.1
S:console._password:
S:io.upload.ip:127.0.0.1
S:io.upload.port:4616
S:game.guild_icon_base_url:
S:game.url_list:guild.url|

S:game.server_screenshot_url:
S:game.helpdesk_url:
S:game.newbiehelp_asura_url:
S:game.newbiehelp_deva_url:
S:game.newbiehelp_gaia_url:
S:game.local_setting_list:log.ip|log.chat.ip|io.au th.ip|io.ip_address|db.c.server|db.user.server|N game.periodical_npc_adjustment
T:game.disable_trade:0
T:game.disable_booth:0
S:game.enhance_fail_type:2
T:game.monster_pathfinding:1
T:game.monster_wandering:1
T:game.no_collision_check:0
T:game.no_skill_cooltime:0
N:game.item_hold_time:2500
T:db.user.thread:4

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.

beecloven · 05/23/2015, 17:06

Quote:

Originally Posted by ismokedrow

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.

ThunderNikk · 05/23/2015, 18:35

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.

beecloven · 05/23/2015, 18:54

Quote:

Originally Posted by thndr

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.

~~ismokedrow~~ · 05/23/2015, 19:29

Like the link below?

beecloven · 05/23/2015, 19:35

Quote:

Originally Posted by ismokedrow

Like the link below?

There is old version.

~~king1king~~ · 05/23/2015, 20:17

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

ThunderNikk · 05/23/2015, 21:04

Quote:

Originally Posted by beecloven

There is old version.

The most recent version is on page one of the forums...

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 = ?;

beecloven · 05/23/2015, 21:23

Quote:

Originally Posted by thndr

The most recent version is on page one of the forums...

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.