thanks for that .. but 9.5.2 item didn't work for me
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.