[Release]9.4 Official Files

11/12/2017 23:24 Ghost Informatics#211
Quote:
Originally Posted by toyfarm View Post
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
11/12/2017 23:28 ThunderNikk#212
Restore the Databases to the SQL (Auth,Arcadia,ArcadiaInfo,Billing,Telecaster).

You will find them in the databases folder.
11/12/2017 23:33 toyfarm#213
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
11/16/2017 15:19 hiderian#214
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.
11/16/2017 15:50 ThunderNikk#215
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.
11/23/2017 15:36 mevius#216
Does "Blessed E-Repair" included in the item resources? Please somebody tell me that ID. I can't find it...
11/23/2017 16:12 Rappler007#217
Quote:
Originally Posted by mevius View Post
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:

Code:
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)
11/23/2017 16:51 ThunderNikk#218
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.
11/24/2017 14:57 YuhaBah#219
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 ^^
11/25/2017 02:46 ThunderNikk#220
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
11/26/2017 04:18 nano1995#221
the Auth didn't want to Restore what can i do
11/26/2017 04:35 ThunderNikk#222
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.
12/03/2017 15:05 xDdaviiDxD#223
Hello, i have one question... can you make the auth.bak works with SQL 2012 version 11.00.3128 ?^^
12/03/2017 16:16 ThunderNikk#224
Quote:
Originally Posted by xDdaviiDxD View Post
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...

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

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

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

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

I am pretty sure those are both in a 2012 or earlier cast.
12/03/2017 16:25 xDdaviiDxD#225
Ah okay, thanks a lot for your help ThunderNikk :)