[Help Thread] Please post your questions here.

06/19/2019 21:05 InkDevil#7501
Quote:
Originally Posted by kikochi View Post
thanks for that .. but 9.5.2 item didn't work for me
this is log from RDBTool-3.1.0
Code:
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.
06/20/2019 00:22 steamunity#7502
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
06/20/2019 01:14 ThunderNikk#7503
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...

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

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.
06/20/2019 14:00 moddypepo#7504
2019/06/20 13:57:43 DB COM ERROR(Thread:0, HRESULT:80004005, GUID:0C733A8B-2A1C-11CE-ADE5-00AA0044773D) : InstanceDungeonLoader(InstanceDungeonLoader::onPro cess()) : Login timeout expired

what is the error here guys ?
@[Only registered and activated users can see links. Click Here To Register...]
06/21/2019 10:43 steamunity#7505
Merchant : [Only registered and activated users can see links. Click Here To Register...]
Item Developer (Blacksmith) : [Only registered and activated users can see links. Click Here To Register...]

Hi guys,

When you click on this NPC, no store opens (No action.). What is the reason?
06/21/2019 12:49 ThunderNikk#7506
You probably don't have the connecting .lua file to make them work.
06/21/2019 16:07 steamunity#7507
Quote:
Originally Posted by ThunderNikk View Post
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,

[Only registered and activated users can see links. Click Here To Register...] 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 :D (Billing db added and gameserver.opt : T game.cash_usable_server:1)


Hi again,

How do change loading screen?
06/22/2019 02:21 ThunderNikk#7508
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
06/22/2019 16:48 steamunity#7509
@[Only registered and activated users can see links. Click Here To Register...] 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).
06/26/2019 18:19 steamunity#7510
Is there anyone???
06/26/2019 19:14 Dark Blaze#7511
Quote:
Originally Posted by steamunity View Post
How is add taming card (SSEV1 LV1 etc) to shop
Taming Skill Card or a tamed creature card?

Quote:
Originally Posted by steamunity View Post
shop (no npc online store shop)
This depends on the online shop system you're using.
06/26/2019 19:57 steamunity#7512
Quote:
Originally Posted by Dark Blaze View Post
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.
06/26/2019 21:50 Dark Blaze#7513
Quote:
Originally Posted by steamunity View Post
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.
06/26/2019 23:32 qaaah#7514
Hey all !

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

the server work with 9.4

i use this client

Quote:
[Only registered and activated users can see links. Click Here To Register...]
there is anyway to run the Client with Arabic language ?

Thanks for your help and valuable time.
06/27/2019 00:10 steamunity#7515
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?