[Help Thread] Please post your questions here.

[InkDevil]

Originally Posted by kikochi

thanks for that .. but 9.5.2 item didn't work for me
this is log from RDBTool-3.1.0

10/06/2019 22:32:59:461 Info: Reading Arcadia.dbo.ItemResource
10/06/2019 22:32:59:469 Info: SQL: SQLDriverConnect additional info(1):
10/06/2019 22:32:59:470 Info: SQL: query: 
10/06/2019 22:32:59:470 Info: SQL: 01000:1:5701:[Microsoft][ODBC SQL Server Driver][SQL Server]Changed database context to 'master'.
10/06/2019 22:32:59:470 Info: SQL: 01000:2:5703:[Microsoft][ODBC SQL Server Driver][SQL Server]Changed language setting to us_english.
10/06/2019 22:32:59:478 Error: SQL: SQLExecute error(-1):
10/06/2019 22:32:59:478 Error: SQL: query: SELECT "id", "name_id", "tooltip_id", "type", "group", "class", "wear_type", "set_id", "set_part_flag", "grade", "rank", "level", "enhance", "socket", "status_flag", "limit_deva", "limit_asura", "limit_gaia", "job_depth", "limit_fighter", "limit_hunter", "limit_magician", "limit_summoner", "use_min_level", "use_max_level", "target_min_level", "target_max_level", "range", "weight", "price", "huntaholic_point", "arena_point", "ethereal_durability", "endurance", "material", "summon_id", "item_use_flag", "available_period", "decrease_type", "throw_range", "base_type_0", "base_var1_0", "base_var2_0", "base_type_1", "base_var1_1", "base_var2_1", "base_type_2", "base_var1_2", "base_var2_2", "base_type_3", "base_var1_3", "base_var2_3", "opt_type_0", "opt_var1_0", "opt_var2_0", "opt_type_1", "opt_var1_1", "opt_var2_1", "opt_type_2", "opt_var1_2", "opt_var2_2", "opt_type_3", "opt_var1_3", "opt_var2_3", "effect_id", "enhance_id", "skill_id", "state_id", "state_level", "state_time", "cool_time", "cool_time_group", "model_type_dem", "model_type_def", "model_type_asm", "model_type_asf", "model_type_gam", "model_type_gaf", "deco_model_change", "model_00", "model_01", "model_02", "model_03", "model_04", "model_05", "model_06", "model_07", "model_08", "model_09", "model_10", "model_11", "model_12", "model_13", "model_14", "model_15", "model_16", "model_17", "texture_filename", "drop_type", "icon_id", "icon_file_name", "script_text", "group_bit_set", "effect01", "effect02", "value1_1", "value1_2", "value1_3", "value1_4", "value1_5", "value1_6", "value1_7", "value1_8", "value1_9", "value1_10", "value2_1", "value2_2", "value2_3", "value2_4", "value2_5", "value2_6", "value2_7", "value2_8", "value2_9", "value2_10" FROM Arcadia.dbo.ItemResource;
10/06/2019 22:32:59:479 Error: SQL: 42S22:1:207:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'effect01'.
10/06/2019 22:32:59:480 Error: SQL: 42S22:2:207:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'effect02'.
10/06/2019 22:32:59:481 Error: SQL: 42S22:3:207:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'value1_1'.
10/06/2019 22:32:59:481 Error: SQL: 42S22:4:207:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'value1_2'.
10/06/2019 22:32:59:481 Error: SQL: 42S22:5:207:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'value1_3'.
10/06/2019 22:32:59:481 Error: SQL: 42S22:6:207:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'value1_4'.
10/06/2019 22:32:59:482 Error: SQL: 42S22:7:207:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'value1_5'.
10/06/2019 22:32:59:482 Error: SQL: 42S22:8:207:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'value1_6'.
10/06/2019 22:32:59:482 Error: SQL: 42S22:9:207:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'value1_7'.
10/06/2019 22:32:59:483 Error: SQL: 42S22:10:207:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'value1_8'.
10/06/2019 22:32:59:483 Error: SQL: 42S22:11:207:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'value1_9'.
10/06/2019 22:32:59:483 Error: SQL: 42S22:12:207:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'value1_10'.
10/06/2019 22:32:59:483 Error: SQL: 42S22:13:207:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'value2_1'.
10/06/2019 22:32:59:483 Error: SQL: 42S22:14:207:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'value2_2'.
10/06/2019 22:32:59:484 Error: SQL: 42S22:15:207:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'value2_3'.
10/06/2019 22:32:59:484 Error: SQL: 42S22:16:207:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'value2_4'.
10/06/2019 22:32:59:484 Error: SQL: 42S22:17:207:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'value2_5'.
10/06/2019 22:32:59:484 Error: SQL: 42S22:18:207:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'value2_6'.
10/06/2019 22:32:59:484 Error: SQL: 42S22:19:207:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'value2_7'.
10/06/2019 22:32:59:485 Error: SQL: 42S22:20:207:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'value2_8'.
10/06/2019 22:32:59:485 Error: SQL: 42S22:21:207:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'value2_9'.
10/06/2019 22:32:59:485 Error: SQL: 42S22:22:207:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'value2_10'.
10/06/2019 22:32:59:485 Error: SQL: 42000:23:8180:[Microsoft][ODBC SQL Server Driver][SQL Server]Statement(s) could not be prepared.

Contact me on Discord, I'll solve via teamviewer if you want.

[steamunity]

EN

Hi guys, I have two questions. I am using epic 7.3.

1 : How do I change NPC names in the game?
2 : I click the Shop Inventory button, but it won't open. (Nothing happens, it doesn't appear.)

Thank You.

TR

 Spoiler

Merhaba arkadaşlar,

1 : NPC İsimlerini nereden değiştiriyoruz? Atıyorum set_npc_name( "@90100800" ) Şeklinde eklenmiş fakat bu veriyi nereden çekiyor anlamadım?
2 : Mağaza Envanterine tıklayınca hiç bir şey olmuyor, açılmıyor.

Teşekkürler.

[ThunderNikk]

You change NPC names in the string resource table and make a new string rdb for the client after doing it.

The NPC will have a name_id and that is the code you look up in the string resource.

If you are talking about the in game item shop or cash shop. There is not one in the game until you build one.

You can take a look at GhostInformatic and Revolution Teams cash shop release...



Though if no one has in the later sections of the thread you may need to get someone to re share the files as Revolutions server they were hosting the downloads on has not been active for a while.

[moddypepo]

2019/06/20 13:57:43 DB COM ERROR(Thread:0, HRESULT:80004005, GUID:0C733A8B-2A1C-11CE-ADE5-00AA0044773D) : InstanceDungeonLoader(InstanceDungeonLoader:nPro cess()) : Login timeout expired

what is the error here guys ?
@

[steamunity]

Merchant :
Item Developer (Blacksmith) :

Hi guys,

When you click on this NPC, no store opens (No action.). What is the reason?

[ThunderNikk]

You probably don't have the connecting .lua file to make them work.

[steamunity]

Originally Posted by ThunderNikk

You probably don't have the connecting .lua file to make them work.

Where can I get these files? (epic 7.3 using)

Edit ; (Problem file pc_merchantetc.lua) Solved.

Then,

I clicked, but not working. I have a store system that makes online shopping. But there is no panel to pull items. Which file does Store Inventory relate to?

Edit ; Solved (Billing db added and gameserver.opt : T game.cash_usable_server:1)

Hi again,

How do change loading screen?

[ThunderNikk]

You can change the intro images and the log in screen by changing the following files, hashing the file names with a file name hasher and placing them in the resource folder...

company_logo(ascii).jpg
copyright_image(ascii).jpg
published_image(ascii).jpg
lobby_login_image(ascii).jpg

You can edit the header and footer borders of the loading screens by editing these files...

login_type02_pane(ascii).png
login_type02_pane_down(ascii).png
login_type02_pane_up(ascii).png

You can edit the proprietary company images on those pages by editing the following files...

lobby_login_game_logo(ascii).png
static_login_copyright(ascii).png
static_login_published(ascii).png
lobby_login_logo_subtitle(ascii).png

Of course these are all (ascii) because I launch a US client. If you do not launch (ascii) then drop that from the names and hash the files without it.

If the names are different for different launches you can find out in the Locale_info.ini file. Or maybe someone who runs a non English client can help out with that also.

If you mean all of the loading screens for warps and stuff then there are a lot of them you can look in the jpg folder after dumping a client. They are all named something like

loading_image34(ascii).jpg

[steamunity]

@ Yes, you are right. It helped RappelzFilesManager. (UNPACK)

My last question
How is add taming card (SSEV1 LV1 etc) to shop (no npc online store shop).

[steamunity]

Is there anyone???

[Dark Blaze]

Originally Posted by steamunity

How is add taming card (SSEV1 LV1 etc) to shop

Taming Skill Card or a tamed creature card?

Originally Posted by steamunity

shop (no npc online store shop)

This depends on the online shop system you're using.

[steamunity]

Originally Posted by Dark Blaze

Taming Skill Card or a tamed creature card?



This depends on the online shop system you're using.

tamed creature card. Like (550015 Taming Card White Dragon (SS0 Lv1))
I'm looking for the others.

[Dark Blaze]

Originally Posted by steamunity

tamed creature card. Like (550015 Taming Card White Dragon (SS0 Lv1))
I'm looking for the others.

Try this code it should list the IDs of the tamed creature cards and their IDs.

 Spoiler

USE [Arcadia]
SELECT ir.id, sr.[value]
FROM dbo.ItemResource AS ir
JOIN dbo.StringResource AS sr
ON ir.name_id = sr.code
WHERE ir.[type] = 2 AND ir.[group] = 13

[qaaah]

Hey all !

long time , i want ask about change language for the client.

the server work with 9.4

i use this client

there is anyway to run the Client with Arabic language ?

Thanks for your help and valuable time.

[steamunity]

Dark Plaze, thank you for help.. A few of them were found, at least.

My other question, Items falling in the game is very bad and missing. Rusty steel, armor, weapons not falling. (I'm using epic 7.3) The damage of the creatures is very high.

Why are these problems present?