Originally Posted by Ratmin82
here my CharacterMotion:
Code:
INSERT INTO Arcadia.dbo.CharacterMotion ([motion_id], [race_id], [sex], [file_name], [frame_length], [play_speed], [graphic_effect_file_ID], [graphic_effect_speed_type], [graphic_effect_position], [graphic_effect_follow], [graphic_effect_disappear], [sound_file_ID], [sound_volumn], [sound_play_probability], [sound_timing], [sound_reverb_apply], [sound_filter_apply], [sound_stereo_apply], [fx_id], [fx_timing], [fx_position], [fx_play_speed], [event01_id], [event01_timing], [event02_id], [event02_timing], [event03_id], [event03_timing], [event04_id], [event04_timing], [event05_id], [event05_timing], [event06_id], [event06_timing], [event07_id], [event07_timing], [event08_id], [event08_timing], [event09_id], [event09_timing], [event10_id], [event10_timing]) VALUES ('21799', '1', '0', 'skelgeneral01_una_attack01_biped', '36', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '19', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO Arcadia.dbo.CharacterMotion ([motion_id], [race_id], [sex], [file_name], [frame_length], [play_speed], [graphic_effect_file_ID], [graphic_effect_speed_type], [graphic_effect_position], [graphic_effect_follow], [graphic_effect_disappear], [sound_file_ID], [sound_volumn], [sound_play_probability], [sound_timing], [sound_reverb_apply], [sound_filter_apply], [sound_stereo_apply], [fx_id], [fx_timing], [fx_position], [fx_play_speed], [event01_id], [event01_timing], [event02_id], [event02_timing], [event03_id], [event03_timing], [event04_id], [event04_timing], [event05_id], [event05_timing], [event06_id], [event06_timing], [event07_id], [event07_timing], [event08_id], [event08_timing], [event09_id], [event09_timing], [event10_id], [event10_timing]) VALUES ('21800', '1', '0', 'skelgeneral01_una_attack02_biped', '34', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '21', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO Arcadia.dbo.CharacterMotion ([motion_id], [race_id], [sex], [file_name], [frame_length], [play_speed], [graphic_effect_file_ID], [graphic_effect_speed_type], [graphic_effect_position], [graphic_effect_follow], [graphic_effect_disappear], [sound_file_ID], [sound_volumn], [sound_play_probability], [sound_timing], [sound_reverb_apply], [sound_filter_apply], [sound_stereo_apply], [fx_id], [fx_timing], [fx_position], [fx_play_speed], [event01_id], [event01_timing], [event02_id], [event02_timing], [event03_id], [event03_timing], [event04_id], [event04_timing], [event05_id], [event05_timing], [event06_id], [event06_timing], [event07_id], [event07_timing], [event08_id], [event08_timing], [event09_id], [event09_timing], [event10_id], [event10_timing]) VALUES ('21801', '1', '0', 'skelgeneral01_una_attack03_biped', '36', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO Arcadia.dbo.CharacterMotion ([motion_id], [race_id], [sex], [file_name], [frame_length], [play_speed], [graphic_effect_file_ID], [graphic_effect_speed_type], [graphic_effect_position], [graphic_effect_follow], [graphic_effect_disappear], [sound_file_ID], [sound_volumn], [sound_play_probability], [sound_timing], [sound_reverb_apply], [sound_filter_apply], [sound_stereo_apply], [fx_id], [fx_timing], [fx_position], [fx_play_speed], [event01_id], [event01_timing], [event02_id], [event02_timing], [event03_id], [event03_timing], [event04_id], [event04_timing], [event05_id], [event05_timing], [event06_id], [event06_timing], [event07_id], [event07_timing], [event08_id], [event08_timing], [event09_id], [event09_timing], [event10_id], [event10_timing]) VALUES ('21802', '1', '0', 'skelgeneral01_una_damage01_biped', '27', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO Arcadia.dbo.CharacterMotion ([motion_id], [race_id], [sex], [file_name], [frame_length], [play_speed], [graphic_effect_file_ID], [graphic_effect_speed_type], [graphic_effect_position], [graphic_effect_follow], [graphic_effect_disappear], [sound_file_ID], [sound_volumn], [sound_play_probability], [sound_timing], [sound_reverb_apply], [sound_filter_apply], [sound_stereo_apply], [fx_id], [fx_timing], [fx_position], [fx_play_speed], [event01_id], [event01_timing], [event02_id], [event02_timing], [event03_id], [event03_timing], [event04_id], [event04_timing], [event05_id], [event05_timing], [event06_id], [event06_timing], [event07_id], [event07_timing], [event08_id], [event08_timing], [event09_id], [event09_timing], [event10_id], [event10_timing]) VALUES ('21803', '1', '0', 'skelgeneral01_una_damage02_biped', '26', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO Arcadia.dbo.CharacterMotion ([motion_id], [race_id], [sex], [file_name], [frame_length], [play_speed], [graphic_effect_file_ID], [graphic_effect_speed_type], [graphic_effect_position], [graphic_effect_follow], [graphic_effect_disappear], [sound_file_ID], [sound_volumn], [sound_play_probability], [sound_timing], [sound_reverb_apply], [sound_filter_apply], [sound_stereo_apply], [fx_id], [fx_timing], [fx_position], [fx_play_speed], [event01_id], [event01_timing], [event02_id], [event02_timing], [event03_id], [event03_timing], [event04_id], [event04_timing], [event05_id], [event05_timing], [event06_id], [event06_timing], [event07_id], [event07_timing], [event08_id], [event08_timing], [event09_id], [event09_timing], [event10_id], [event10_timing]) VALUES ('21804', '1', '0', 'skelgeneral01_una_dead01_biped', '64', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO Arcadia.dbo.CharacterMotion ([motion_id], [race_id], [sex], [file_name], [frame_length], [play_speed], [graphic_effect_file_ID], [graphic_effect_speed_type], [graphic_effect_position], [graphic_effect_follow], [graphic_effect_disappear], [sound_file_ID], [sound_volumn], [sound_play_probability], [sound_timing], [sound_reverb_apply], [sound_filter_apply], [sound_stereo_apply], [fx_id], [fx_timing], [fx_position], [fx_play_speed], [event01_id], [event01_timing], [event02_id], [event02_timing], [event03_id], [event03_timing], [event04_id], [event04_timing], [event05_id], [event05_timing], [event06_id], [event06_timing], [event07_id], [event07_timing], [event08_id], [event08_timing], [event09_id], [event09_timing], [event10_id], [event10_timing]) VALUES ('21805', '1', '0', 'skelgeneral01_una_default01_biped', '61', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO Arcadia.dbo.CharacterMotion ([motion_id], [race_id], [sex], [file_name], [frame_length], [play_speed], [graphic_effect_file_ID], [graphic_effect_speed_type], [graphic_effect_position], [graphic_effect_follow], [graphic_effect_disappear], [sound_file_ID], [sound_volumn], [sound_play_probability], [sound_timing], [sound_reverb_apply], [sound_filter_apply], [sound_stereo_apply], [fx_id], [fx_timing], [fx_position], [fx_play_speed], [event01_id], [event01_timing], [event02_id], [event02_timing], [event03_id], [event03_timing], [event04_id], [event04_timing], [event05_id], [event05_timing], [event06_id], [event06_timing], [event07_id], [event07_timing], [event08_id], [event08_timing], [event09_id], [event09_timing], [event10_id], [event10_timing]) VALUES ('21806', '1', '0', 'skelgeneral01_una_idle01_biped', '88', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO Arcadia.dbo.CharacterMotion ([motion_id], [race_id], [sex], [file_name], [frame_length], [play_speed], [graphic_effect_file_ID], [graphic_effect_speed_type], [graphic_effect_position], [graphic_effect_follow], [graphic_effect_disappear], [sound_file_ID], [sound_volumn], [sound_play_probability], [sound_timing], [sound_reverb_apply], [sound_filter_apply], [sound_stereo_apply], [fx_id], [fx_timing], [fx_position], [fx_play_speed], [event01_id], [event01_timing], [event02_id], [event02_timing], [event03_id], [event03_timing], [event04_id], [event04_timing], [event05_id], [event05_timing], [event06_id], [event06_timing], [event07_id], [event07_timing], [event08_id], [event08_timing], [event09_id], [event09_timing], [event10_id], [event10_timing]) VALUES ('21807', '1', '0', 'skelgeneral01_una_walk_biped', '31', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '13', '0', '13', '16', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
I know that more than 351 rows are ignored by sframe, so I used MonsterResource.motion_file_id = 4 as suggested by @ [Only registered and activated users can see links. Click Here To Register...]. In any case, here my MonsterMotionSet (although is ignored, row number= 352; I don't know how to use it with DG):
Code:
INSERT INTO Arcadia.dbo.MonsterMotionSet ([character_id], [def], [battle], [idle], [walk], [run], [be_attack], [be_attack2], [dead], [flying_dead], [take], [attack_1], [attack_2], [attack_3], [draw_bow], [target_bow], [fire_bow], [casting_1], [casting_2], [casting_3], [melee_1], [melee_2], [melee_3], [mount], [unmount]) VALUES ('353', '21805', '21805', '21806', '21807', '21807', '21802', '21803', '21804', '0', '0', '21799', '21800', '21801', '0', '0', '0', '0', '0', '0', '21799', '21800', '21801', '0', '0');
I also edited the CharacterMotion81Database.lua from RDBtool of Glandu2 to create a CharacterMotion95Database.lua as follow:
Code:
rdb.fields = {
{"motion_id", TYPE_INT32},
{"race_id", TYPE_INT32},
--{"sex", TYPE_INT32},
{"file_name", TYPE_CHAR, 48},
{"frame_length", TYPE_INT32},
{"play_speed", TYPE_INT32},
{"graphic_effect_file_ID", TYPE_INT32},
{"graphic_effect_speed_type", TYPE_INT32},
{"graphic_effect_position", TYPE_INT32},
{"sound_file_ID", TYPE_INT32},
{"sound_volumn", TYPE_INT32},
{"sound_play_probability", TYPE_INT32},
{"sound_timing", TYPE_INT32},
{"fx_id", TYPE_INT32},
{"fx_timing", TYPE_INT32},
{"fx_position", TYPE_INT32},
{"fx_play_speed", TYPE_INT32},
{"graphic_effect_disappear", TYPE_INT32},
{"event01_id", TYPE_INT16},
{"event02_id", TYPE_INT16},
{"event03_id", TYPE_INT16},
{"event04_id", TYPE_INT16},
{"event05_id", TYPE_INT16},
{"event06_id", TYPE_INT16},
{"event07_id", TYPE_INT16},
{"event08_id", TYPE_INT16},
{"event09_id", TYPE_INT16},
{"event10_id", TYPE_INT16},
{"event01_timing", TYPE_INT16},
{"event02_timing", TYPE_INT16},
{"event03_timing", TYPE_INT16},
{"event04_timing", TYPE_INT16},
{"event05_timing", TYPE_INT16},
{"event06_timing", TYPE_INT16},
{"event07_timing", TYPE_INT16},
{"event08_timing", TYPE_INT16},
{"event09_timing", TYPE_INT16},
{"event10_timing", TYPE_INT16},
{"graphic_effect_follow", TYPE_INT8},
{"sound_reverb_apply", TYPE_INT8},
{"sound_filter_apply", TYPE_INT8},
{"sound_stereo_apply", TYPE_INT8},
}
rdb.defaultTableName = "CharacterMotion"
rdb.convertData = function (dst, mode, row, rowNum)
if mode == DCT_Read and (dst == DF_CSV or dst == DF_SQL) then
row.padding0 = 103
row.padding1 = 0
end
end
|