Wie oben beschrieben einen SQL insert machen. Mit denn entsprechenden Buffs wie Level/Aktion/Icon usw
Du solltest auch beachten das man das nicht nur in der DB speichert mach dir einen Test Server spiele etwas mit denn Magics rum so lernst du es am schnellsten.
/*
LastChaos skill Editor
by HateMe
Function: Export skill.lod as SQL
************************************************** *********
This Programm doesn't create the Databases or the Tables.
*/
INSERT INTO t_skill(a_index, a_name_usa, a_client_icon_col, a_client_icon_row, a_client_icon_texid, a_client_tooltip_usa, a_client_description_usa, a_cd_fe_after, a_cd_dd2, a_cd_fd7, a_cd_fd6, a_cd_fd5, a_cd_fd4, a_cd_fdc2, a_cd_oc2, a_cd_oh2, a_cd_oz2, a_cd_ox2, a_cd_fos2, a_cd_fot2, a_cd_fe5, a_cd_fe4, a_cd_fe3, a_cd_fa2, a_cd_sa2, a_cd_re2, a_cd_ra2, a_cd_dd, a_cd_fd3, a_cd_fd2, a_cd_fd1, a_cd_fd0, a_cd_fdc, a_cd_oc, a_cd_oh, a_cd_oz, a_cd_ox, a_cd_fos, a_cd_fot, a_cd_fe2, a_cd_fe1, a_cd_fe0, a_cd_fa, a_cd_sa, a_cd_re, a_cd_ra, a_reuseTime, a_fireTime, a_stillTime, a_readyTime, a_appState, a_soul_consum, a_useMagicLevel3, a_useMagicIndex3, a_useMagicLevel2, a_useMagicIndex2, a_useMagicLevel1, a_useMagicIndex1, a_useWeaponType1, a_useWeaponType0, a_useState, a_targetNum, a_targetType, a_fireRange2, a_fireRange, a_appRange, a_maxLevel, a_sorcerer_flag, a_flag, a_type, a_apet_index, a_job2, a_job ) VALUES
(1, "Power Magnum", 0, 0, 0, "Strong blade attack.", "Increase damage on next attack.
", "", 0, 0, 0, 0, 1.14, 1, 0, 0, 0, 0, 0, 0, "TI Power Magnum 2", "", "TI Power Magnum 1_a", "ti_a_skill_01", "", "", "", 0, 0, 0, 0, 1.14, 1, 0, 0, 0, 0, 0, 0, "TI Power Magnum 2", "", "TI Power Magnum 1", "ti_skill_01", "", "", "", 30, 22, 0, 0, 0, 0, 0, -1, 0, -1, 0, -1, 4, 3, 2, 1, 2, 2, 2, 0, 5, 0, 4, 0, 0, 0, 0);
INSERT INTO t_skilllevel(a_index, a_level, a_needHP, a_needMP, a_needGP, a_durtime, a_dummypower, a_needItemIndex1, a_needItemCount1, a_needItemIndex2, a_needItemCount2, a_learnLevel, a_learnSP, a_learnSkillIndex1, a_learnSkillLevel1, a_learnSkillIndex2, a_learnSkillLevel2, a_learnSkillIndex3, a_learnSkillLevel3, a_learnItemIndex1, a_learnItemCount1, a_learnItemIndex2, a_learnItemCount2, a_learnItemIndex3, a_learnItemCount3, a_learnstr, a_learndex, a_learnint, a_learncon, a_appMagicIndex1, a_appMagicLevel1, a_appMagicIndex2, a_appMagicLevel2, a_appMagicIndex3, a_appMagicLevel3, a_magicIndex1, a_magicLevel1, a_magicIndex2, a_magicLevel2, a_magicIndex3, a_magicLevel3, a_learnGP ) VALUES
(1, 1, 0, 8, 0, 0, 128, -1, 0, -1, 0, 1, 0, -1, 0, -1, 0, -1, 0, -1, 0, -1, 0, -1, 0, 0, 0, 0, 0, -1, 0, -1, 0, -1, 0, 45, 1, -1, 0, -1, 0, 0);
INSERT INTO t_skilllevel(a_index, a_level, a_needHP, a_needMP, a_needGP, a_durtime, a_dummypower, a_needItemIndex1, a_needItemCount1, a_needItemIndex2, a_needItemCount2, a_learnLevel, a_learnSP, a_learnSkillIndex1, a_learnSkillLevel1, a_learnSkillIndex2, a_learnSkillLevel2, a_learnSkillIndex3, a_learnSkillLevel3, a_learnItemIndex1, a_learnItemCount1, a_learnItemIndex2, a_learnItemCount2, a_learnItemIndex3, a_learnItemCount3, a_learnstr, a_learndex, a_learnint, a_learncon, a_appMagicIndex1, a_appMagicLevel1, a_appMagicIndex2, a_appMagicLevel2, a_appMagicIndex3, a_appMagicLevel3, a_magicIndex1, a_magicLevel1, a_magicIndex2, a_magicLevel2, a_magicIndex3, a_magicLevel3, a_learnGP ) VALUES
(1, 2, 0, 15, 0, 0, 154, -1, 0, -1, 0, 1, 0, -1, 0, -1, 0, -1, 0, -1, 0, -1, 0, -1, 0, 0, 0, 0, 0, -1, 0, -1, 0, -1, 0, 45, 2, -1, 0, -1, 0, 0);
INSERT INTO t_skilllevel(a_index, a_level, a_needHP, a_needMP, a_needGP, a_durtime, a_dummypower, a_needItemIndex1, a_needItemCount1, a_needItemIndex2, a_needItemCount2, a_learnLevel, a_learnSP, a_learnSkillIndex1, a_learnSkillLevel1, a_learnSkillIndex2, a_learnSkillLevel2, a_learnSkillIndex3, a_learnSkillLevel3, a_learnItemIndex1, a_learnItemCount1, a_learnItemIndex2, a_learnItemCount2, a_learnItemIndex3, a_learnItemCount3, a_learnstr, a_learndex, a_learnint, a_learncon, a_appMagicIndex1, a_appMagicLevel1, a_appMagicIndex2, a_appMagicLevel2, a_appMagicIndex3, a_appMagicLevel3, a_magicIndex1, a_magicLevel1, a_magicIndex2, a_magicLevel2, a_magicIndex3, a_magicLevel3, a_learnGP ) VALUES
(1, 3, 0, 23, 0, 0, 195, -1, 0, -1, 0, 1, 0, -1, 0, -1, 0, -1, 0, -1, 0, -1, 0, -1, 0, 0, 0, 0, 0, -1, 0, -1, 0, -1, 0, 45, 3, -1, 0, -1, 0, 0);
INSERT INTO t_skilllevel(a_index, a_level, a_needHP, a_needMP, a_needGP, a_durtime, a_dummypower, a_needItemIndex1, a_needItemCount1, a_needItemIndex2, a_needItemCount2, a_learnLevel, a_learnSP, a_learnSkillIndex1, a_learnSkillLevel1, a_learnSkillIndex2, a_learnSkillLevel2, a_learnSkillIndex3, a_learnSkillLevel3, a_learnItemIndex1, a_learnItemCount1, a_learnItemIndex2, a_learnItemCount2, a_learnItemIndex3, a_learnItemCount3, a_learnstr, a_learndex, a_learnint, a_learncon, a_appMagicIndex1, a_appMagicLevel1, a_appMagicIndex2, a_appMagicLevel2, a_appMagicIndex3, a_appMagicLevel3, a_magicIndex1, a_magicLevel1, a_magicIndex2, a_magicLevel2, a_magicIndex3, a_magicLevel3, a_learnGP ) VALUES
(1, 4, 0, 32, 0, 0, 250, -1, 0, -1, 0, 1, 0, -1, 0, -1, 0, -1, 0, -1, 0, -1, 0, -1, 0, 0, 0, 0, 0, -1, 0, -1, 0, -1, 0, 45, 4, -1, 0, -1, 0, 0);
INSERT INTO t_skilllevel(a_index, a_level, a_needHP, a_needMP, a_needGP, a_durtime, a_dummypower, a_needItemIndex1, a_needItemCount1, a_needItemIndex2, a_needItemCount2, a_learnLevel, a_learnSP, a_learnSkillIndex1, a_learnSkillLevel1, a_learnSkillIndex2, a_learnSkillLevel2, a_learnSkillIndex3, a_learnSkillLevel3, a_learnItemIndex1, a_learnItemCount1, a_learnItemIndex2, a_learnItemCount2, a_learnItemIndex3, a_learnItemCount3, a_learnstr, a_learndex, a_learnint, a_learncon, a_appMagicIndex1, a_appMagicLevel1, a_appMagicIndex2, a_appMagicLevel2, a_appMagicIndex3, a_appMagicLevel3, a_magicIndex1, a_magicLevel1, a_magicIndex2, a_magicLevel2, a_magicIndex3, a_magicLevel3, a_learnGP ) VALUES
(1, 5, 0, 42, 0, 0, 320, -1, 0, -1, 0, 1, 0, -1, 0, -1, 0, -1, 0, -1, 0, -1, 0, -1, 0, 0, 0, 0, 0, -1, 0, -1, 0, -1, 0, 45, 5, -1, 0, -1, 0, 0);
Also , ich habe herausgefunden das es reicht mit Insert this Record und dann Update .