[Release]9.4 Official Files

[Ghost Informatics]

Originally Posted by toyfarm

its time to learn this for myself. but im looking at the guide and the first bak to restore is auth_gameportal.bak, but where is this ? ive never dont this before so pardon the dumb questions

There's auth database inside the release

[ThunderNikk]

Restore the Databases to the SQL (Auth,Arcadia,ArcadiaInfo,Billing,Telecaster).

You will find them in the databases folder.

[toyfarm]

Thank you for answering. I'm confused because the file in there is just auth.bak, the one in the guide is auth_gameportal.bak

[hiderian]

Thank you for sharing the files.

I need your help that how to add NPC. Because I want to add some NPC (ex.ID=11021), I tried to set "0" at local_flag in dbo.NPCResource. However it doesn't work. Some of NPCs work by set "0" like that method, though.

[ThunderNikk]

If you are just turning them on and off sometimes it works to do that just server sided.

If you are adding new you may need to create an RDB to resource to the client.

[mevius]

Does "Blessed E-Repair" included in the item resources? Please somebody tell me that ID. I can't find it...

[Rappler007]

Originally Posted by mevius

Does "Blessed E-Repair" included in the item resources? Please somebody tell me that ID. I can't find it...

That depends on the ItemResource you are using.

SQL-query to search for specific items:

use Arcadia
select sR.value, iR.* from ItemResource as iR join StringResource as sR on iR.name_id = sR.code
where sR.value like '%E-Repair%'

If the output contains blessed e-rep, you found it, if it doesn't, it's most likely not in the db (except for untranslated item names - then you could try to search by icon_name)

[ThunderNikk]

It does not appear to be to me.

It would not be difficult to make though as the mythiral e_repair for the kings sword performs the same function.

[YuhaBah]

It has 960124 id. I use RUS strings and released dbo.ItemResource.
I test it and its works =) But in EN strings it named like gander point, but its not ^^

[ThunderNikk]

Yeah weird its string in the string resource is "Gender Change Potion"

But icon file name is icon_commerce_blessed_epowder

Guess it just didn't get the correct translation update.

Thanks YuhaBah

[nano1995]

the Auth didn't want to Restore what can i do

[ThunderNikk]

Hit the little link down on the bottom left hand corner of the SQL window and give us some more details on the error you are getting.

[xDdaviiDxD]

Hello, i have one question... can you make the auth.bak works with SQL 2012 version 11.00.3128 ?^^

[ThunderNikk]

Originally Posted by xDdaviiDxD

Hello, i have one question... can you make the auth.bak works with SQL 2012 version 11.00.3128 ?^^

You can download developer to use for personal use for free...



Why handicap yourself by continuing to use 2012?

What you can do yourself...Use an older auth from an earlier server version release that was backed up with 2012. I think I have 2 of them...it is your choice whether you want a table called "account" or "accounts"

I recommend account...





I am pretty sure those are both in a 2012 or earlier cast.

[xDdaviiDxD]

Ah okay, thanks a lot for your help ThunderNikk