Database to Media(Db2media)'nın SQL Mantığı

Dogu9999 · 10 Mar 2026

Merhaba Sevgili Turkmmo Ailesi

Bugün sizlere "Database to Media (Db2media)" yaparken ki oluşan ".TXT" lerin hangi queryler eşliğinde çıktığını gösteren bir paylaşım yapmak istedim.

Code:

characterdata_5000.txt
Query : SELECT _RefObjCommon.Service, _RefObjCommon.ID, _RefObjCommon.CodeName128, _RefObjCommon.ObjName128, _RefObjCommon.OrgObjCodeName128, _RefObjCommon.NameStrID128, _RefObjCommon.DescStrID128, _RefObjCommon.CashItem, _RefObjCommon.Bionic, _RefObjCommon.TypeID1, _RefObjCommon.TypeID2, _RefObjCommon.TypeID3, _RefObjCommon.TypeID4, _RefObjCommon.DecayTime, _RefObjCommon.Country, _RefObjCommon.Rarity, _RefObjCommon.CanTrade, _RefObjCommon.CanSell, _RefObjCommon.CanBuy, _RefObjCommon.CanBorrow, _RefObjCommon.CanDrop, _RefObjCommon.CanPick, _RefObjCommon.CanRepair, _RefObjCommon.CanRevive, _RefObjCommon.CanUse, _RefObjCommon.CanThrow, _RefObjCommon.Price, _RefObjCommon.CostRepair, _RefObjCommon.CostRevive, _RefObjCommon.CostBorrow, _RefObjCommon.KeepingFee, _RefObjCommon.SellPrice, _RefObjCommon.ReqLevelType1, _RefObjCommon.ReqLevel1, _RefObjCommon.ReqLevelType2, _RefObjCommon.ReqLevel2, _RefObjCommon.ReqLevelType3, _RefObjCommon.ReqLevel3, _RefObjCommon.ReqLevelType4, _RefObjCommon.ReqLevel4, _RefObjCommon.MaxContain, _RefObjCommon.RegionID, _RefObjCommon.Dir, _RefObjCommon.OffsetX, _RefObjCommon.OffsetY, _RefObjCommon.OffsetZ, _RefObjCommon.Speed1, _RefObjCommon.Speed2, _RefObjCommon.Scale, _RefObjCommon.BCHeight, _RefObjCommon.BCRadius, _RefObjCommon.EventID, _RefObjCommon.AssocFileObj128, _RefObjCommon.AssocFileDrop128, _RefObjCommon.AssocFileIcon128, _RefObjCommon.AssocFile1_128, _RefObjCommon.AssocFile2_128, _RefObjChar.Lvl, _RefObjChar.CharGender, _RefObjChar.MaxHP, _RefObjChar.MaxMP, _RefObjChar.InventorySize, _RefObjChar.CanStore_TID1, _RefObjChar.CanStore_TID2, _RefObjChar.CanStore_TID3, _RefObjChar.CanStore_TID4, _RefObjChar.CanBeVehicle, _RefObjChar.CanControl, _RefObjChar.DamagePortion, _RefObjChar.MaxPassenger, _RefObjChar.AssocTactics, _RefObjChar.PD, _RefObjChar.MD, _RefObjChar.PAR, _RefObjChar.MAR, _RefObjChar.ER, _RefObjChar.BR, _RefObjChar.HR, _RefObjChar.CHR, _RefObjChar.ExpToGive, _RefObjChar.CreepType, _RefObjChar.Knockdown, _RefObjChar.KO_RecoverTime, _RefObjChar.DefaultSkill_1, _RefObjChar.DefaultSkill_2, _RefObjChar.DefaultSkill_3, _RefObjChar.DefaultSkill_4, _RefObjChar.DefaultSkill_5, _RefObjChar.DefaultSkill_6, _RefObjChar.DefaultSkill_7, _RefObjChar.DefaultSkill_8, _RefObjChar.DefaultSkill_9, _RefObjChar.DefaultSkill_10, _RefObjChar.TextureType, _RefObjChar.Except_1, _RefObjChar.Except_2, _RefObjChar.Except_3, _RefObjChar.Except_4, _RefObjChar.Except_5, _RefObjChar.Except_6, _RefObjChar.Except_7, _RefObjChar.Except_8, _RefObjChar.Except_9, _RefObjChar.Except_10 FROM _RefObjCommon INNER JOIN _RefObjChar ON _RefObjCommon.Link = _RefObjChar.ID WHERE _RefObjCommon.TypeID1 = 1 AND _RefObjCommon.Service = 1 AND _RefObjCommon.ID BETWEEN 0 AND 4999

characterdata_10000.txt
Query : SELECT _RefObjCommon.Service, _RefObjCommon.ID, _RefObjCommon.CodeName128, _RefObjCommon.ObjName128, _RefObjCommon.OrgObjCodeName128, _RefObjCommon.NameStrID128, _RefObjCommon.DescStrID128, _RefObjCommon.CashItem, _RefObjCommon.Bionic, _RefObjCommon.TypeID1, _RefObjCommon.TypeID2, _RefObjCommon.TypeID3, _RefObjCommon.TypeID4, _RefObjCommon.DecayTime, _RefObjCommon.Country, _RefObjCommon.Rarity, _RefObjCommon.CanTrade, _RefObjCommon.CanSell, _RefObjCommon.CanBuy, _RefObjCommon.CanBorrow, _RefObjCommon.CanDrop, _RefObjCommon.CanPick, _RefObjCommon.CanRepair, _RefObjCommon.CanRevive, _RefObjCommon.CanUse, _RefObjCommon.CanThrow, _RefObjCommon.Price, _RefObjCommon.CostRepair, _RefObjCommon.CostRevive, _RefObjCommon.CostBorrow, _RefObjCommon.KeepingFee, _RefObjCommon.SellPrice, _RefObjCommon.ReqLevelType1, _RefObjCommon.ReqLevel1, _RefObjCommon.ReqLevelType2, _RefObjCommon.ReqLevel2, _RefObjCommon.ReqLevelType3, _RefObjCommon.ReqLevel3, _RefObjCommon.ReqLevelType4, _RefObjCommon.ReqLevel4, _RefObjCommon.MaxContain, _RefObjCommon.RegionID, _RefObjCommon.Dir, _RefObjCommon.OffsetX, _RefObjCommon.OffsetY, _RefObjCommon.OffsetZ, _RefObjCommon.Speed1, _RefObjCommon.Speed2, _RefObjCommon.Scale, _RefObjCommon.BCHeight, _RefObjCommon.BCRadius, _RefObjCommon.EventID, _RefObjCommon.AssocFileObj128, _RefObjCommon.AssocFileDrop128, _RefObjCommon.AssocFileIcon128, _RefObjCommon.AssocFile1_128, _RefObjCommon.AssocFile2_128, _RefObjChar.Lvl, _RefObjChar.CharGender, _RefObjChar.MaxHP, _RefObjChar.MaxMP, _RefObjChar.InventorySize, _RefObjChar.CanStore_TID1, _RefObjChar.CanStore_TID2, _RefObjChar.CanStore_TID3, _RefObjChar.CanStore_TID4, _RefObjChar.CanBeVehicle, _RefObjChar.CanControl, _RefObjChar.DamagePortion, _RefObjChar.MaxPassenger, _RefObjChar.AssocTactics, _RefObjChar.PD, _RefObjChar.MD, _RefObjChar.PAR, _RefObjChar.MAR, _RefObjChar.ER, _RefObjChar.BR, _RefObjChar.HR, _RefObjChar.CHR, _RefObjChar.ExpToGive, _RefObjChar.CreepType, _RefObjChar.Knockdown, _RefObjChar.KO_RecoverTime, _RefObjChar.DefaultSkill_1, _RefObjChar.DefaultSkill_2, _RefObjChar.DefaultSkill_3, _RefObjChar.DefaultSkill_4, _RefObjChar.DefaultSkill_5, _RefObjChar.DefaultSkill_6, _RefObjChar.DefaultSkill_7, _RefObjChar.DefaultSkill_8, _RefObjChar.DefaultSkill_9, _RefObjChar.DefaultSkill_10, _RefObjChar.TextureType, _RefObjChar.Except_1, _RefObjChar.Except_2, _RefObjChar.Except_3, _RefObjChar.Except_4, _RefObjChar.Except_5, _RefObjChar.Except_6, _RefObjChar.Except_7, _RefObjChar.Except_8, _RefObjChar.Except_9, _RefObjChar.Except_10 FROM _RefObjCommon INNER JOIN _RefObjChar ON _RefObjCommon.Link = _RefObjChar.ID WHERE _RefObjCommon.TypeID1 = 1 AND _RefObjCommon.Service = 1 AND _RefObjCommon.ID BETWEEN 5000 AND 9999

characterdata_15000.txt
Query : SELECT _RefObjCommon.Service, _RefObjCommon.ID, _RefObjCommon.CodeName128, _RefObjCommon.ObjName128, _RefObjCommon.OrgObjCodeName128, _RefObjCommon.NameStrID128, _RefObjCommon.DescStrID128, _RefObjCommon.CashItem, _RefObjCommon.Bionic, _RefObjCommon.TypeID1, _RefObjCommon.TypeID2, _RefObjCommon.TypeID3, _RefObjCommon.TypeID4, _RefObjCommon.DecayTime, _RefObjCommon.Country, _RefObjCommon.Rarity, _RefObjCommon.CanTrade, _RefObjCommon.CanSell, _RefObjCommon.CanBuy, _RefObjCommon.CanBorrow, _RefObjCommon.CanDrop, _RefObjCommon.CanPick, _RefObjCommon.CanRepair, _RefObjCommon.CanRevive, _RefObjCommon.CanUse, _RefObjCommon.CanThrow, _RefObjCommon.Price, _RefObjCommon.CostRepair, _RefObjCommon.CostRevive, _RefObjCommon.CostBorrow, _RefObjCommon.KeepingFee, _RefObjCommon.SellPrice, _RefObjCommon.ReqLevelType1, _RefObjCommon.ReqLevel1, _RefObjCommon.ReqLevelType2, _RefObjCommon.ReqLevel2, _RefObjCommon.ReqLevelType3, _RefObjCommon.ReqLevel3, _RefObjCommon.ReqLevelType4, _RefObjCommon.ReqLevel4, _RefObjCommon.MaxContain, _RefObjCommon.RegionID, _RefObjCommon.Dir, _RefObjCommon.OffsetX, _RefObjCommon.OffsetY, _RefObjCommon.OffsetZ, _RefObjCommon.Speed1, _RefObjCommon.Speed2, _RefObjCommon.Scale, _RefObjCommon.BCHeight, _RefObjCommon.BCRadius, _RefObjCommon.EventID, _RefObjCommon.AssocFileObj128, _RefObjCommon.AssocFileDrop128, _RefObjCommon.AssocFileIcon128, _RefObjCommon.AssocFile1_128, _RefObjCommon.AssocFile2_128, _RefObjChar.Lvl, _RefObjChar.CharGender, _RefObjChar.MaxHP, _RefObjChar.MaxMP, _RefObjChar.InventorySize, _RefObjChar.CanStore_TID1, _RefObjChar.CanStore_TID2, _RefObjChar.CanStore_TID3, _RefObjChar.CanStore_TID4, _RefObjChar.CanBeVehicle, _RefObjChar.CanControl, _RefObjChar.DamagePortion, _RefObjChar.MaxPassenger, _RefObjChar.AssocTactics, _RefObjChar.PD, _RefObjChar.MD, _RefObjChar.PAR, _RefObjChar.MAR, _RefObjChar.ER, _RefObjChar.BR, _RefObjChar.HR, _RefObjChar.CHR, _RefObjChar.ExpToGive, _RefObjChar.CreepType, _RefObjChar.Knockdown, _RefObjChar.KO_RecoverTime, _RefObjChar.DefaultSkill_1, _RefObjChar.DefaultSkill_2, _RefObjChar.DefaultSkill_3, _RefObjChar.DefaultSkill_4, _RefObjChar.DefaultSkill_5, _RefObjChar.DefaultSkill_6, _RefObjChar.DefaultSkill_7, _RefObjChar.DefaultSkill_8, _RefObjChar.DefaultSkill_9, _RefObjChar.DefaultSkill_10, _RefObjChar.TextureType, _RefObjChar.Except_1, _RefObjChar.Except_2, _RefObjChar.Except_3, _RefObjChar.Except_4, _RefObjChar.Except_5, _RefObjChar.Except_6, _RefObjChar.Except_7, _RefObjChar.Except_8, _RefObjChar.Except_9, _RefObjChar.Except_10 FROM _RefObjCommon INNER JOIN _RefObjChar ON _RefObjCommon.Link = _RefObjChar.ID WHERE _RefObjCommon.TypeID1 = 1 AND _RefObjCommon.Service = 1 AND _RefObjCommon.ID BETWEEN 10000 AND 14999

characterdata_20000.txt
Query : SELECT _RefObjCommon.Service, _RefObjCommon.ID, _RefObjCommon.CodeName128, _RefObjCommon.ObjName128, _RefObjCommon.OrgObjCodeName128, _RefObjCommon.NameStrID128, _RefObjCommon.DescStrID128, _RefObjCommon.CashItem, _RefObjCommon.Bionic, _RefObjCommon.TypeID1, _RefObjCommon.TypeID2, _RefObjCommon.TypeID3, _RefObjCommon.TypeID4, _RefObjCommon.DecayTime, _RefObjCommon.Country, _RefObjCommon.Rarity, _RefObjCommon.CanTrade, _RefObjCommon.CanSell, _RefObjCommon.CanBuy, _RefObjCommon.CanBorrow, _RefObjCommon.CanDrop, _RefObjCommon.CanPick, _RefObjCommon.CanRepair, _RefObjCommon.CanRevive, _RefObjCommon.CanUse, _RefObjCommon.CanThrow, _RefObjCommon.Price, _RefObjCommon.CostRepair, _RefObjCommon.CostRevive, _RefObjCommon.CostBorrow, _RefObjCommon.KeepingFee, _RefObjCommon.SellPrice, _RefObjCommon.ReqLevelType1, _RefObjCommon.ReqLevel1, _RefObjCommon.ReqLevelType2, _RefObjCommon.ReqLevel2, _RefObjCommon.ReqLevelType3, _RefObjCommon.ReqLevel3, _RefObjCommon.ReqLevelType4, _RefObjCommon.ReqLevel4, _RefObjCommon.MaxContain, _RefObjCommon.RegionID, _RefObjCommon.Dir, _RefObjCommon.OffsetX, _RefObjCommon.OffsetY, _RefObjCommon.OffsetZ, _RefObjCommon.Speed1, _RefObjCommon.Speed2, _RefObjCommon.Scale, _RefObjCommon.BCHeight, _RefObjCommon.BCRadius, _RefObjCommon.EventID, _RefObjCommon.AssocFileObj128, _RefObjCommon.AssocFileDrop128, _RefObjCommon.AssocFileIcon128, _RefObjCommon.AssocFile1_128, _RefObjCommon.AssocFile2_128, _RefObjChar.Lvl, _RefObjChar.CharGender, _RefObjChar.MaxHP, _RefObjChar.MaxMP, _RefObjChar.InventorySize, _RefObjChar.CanStore_TID1, _RefObjChar.CanStore_TID2, _RefObjChar.CanStore_TID3, _RefObjChar.CanStore_TID4, _RefObjChar.CanBeVehicle, _RefObjChar.CanControl, _RefObjChar.DamagePortion, _RefObjChar.MaxPassenger, _RefObjChar.AssocTactics, _RefObjChar.PD, _RefObjChar.MD, _RefObjChar.PAR, _RefObjChar.MAR, _RefObjChar.ER, _RefObjChar.BR, _RefObjChar.HR, _RefObjChar.CHR, _RefObjChar.ExpToGive, _RefObjChar.CreepType, _RefObjChar.Knockdown, _RefObjChar.KO_RecoverTime, _RefObjChar.DefaultSkill_1, _RefObjChar.DefaultSkill_2, _RefObjChar.DefaultSkill_3, _RefObjChar.DefaultSkill_4, _RefObjChar.DefaultSkill_5, _RefObjChar.DefaultSkill_6, _RefObjChar.DefaultSkill_7, _RefObjChar.DefaultSkill_8, _RefObjChar.DefaultSkill_9, _RefObjChar.DefaultSkill_10, _RefObjChar.TextureType, _RefObjChar.Except_1, _RefObjChar.Except_2, _RefObjChar.Except_3, _RefObjChar.Except_4, _RefObjChar.Except_5, _RefObjChar.Except_6, _RefObjChar.Except_7, _RefObjChar.Except_8, _RefObjChar.Except_9, _RefObjChar.Except_10 FROM _RefObjCommon INNER JOIN _RefObjChar ON _RefObjCommon.Link = _RefObjChar.ID WHERE _RefObjCommon.TypeID1 = 1 AND _RefObjCommon.Service = 1 AND _RefObjCommon.ID BETWEEN 15000 AND 19999

characterdata_25000.txt
Query : SELECT _RefObjCommon.Service, _RefObjCommon.ID, _RefObjCommon.CodeName128, _RefObjCommon.ObjName128, _RefObjCommon.OrgObjCodeName128, _RefObjCommon.NameStrID128, _RefObjCommon.DescStrID128, _RefObjCommon.CashItem, _RefObjCommon.Bionic, _RefObjCommon.TypeID1, _RefObjCommon.TypeID2, _RefObjCommon.TypeID3, _RefObjCommon.TypeID4, _RefObjCommon.DecayTime, _RefObjCommon.Country, _RefObjCommon.Rarity, _RefObjCommon.CanTrade, _RefObjCommon.CanSell, _RefObjCommon.CanBuy, _RefObjCommon.CanBorrow, _RefObjCommon.CanDrop, _RefObjCommon.CanPick, _RefObjCommon.CanRepair, _RefObjCommon.CanRevive, _RefObjCommon.CanUse, _RefObjCommon.CanThrow, _RefObjCommon.Price, _RefObjCommon.CostRepair, _RefObjCommon.CostRevive, _RefObjCommon.CostBorrow, _RefObjCommon.KeepingFee, _RefObjCommon.SellPrice, _RefObjCommon.ReqLevelType1, _RefObjCommon.ReqLevel1, _RefObjCommon.ReqLevelType2, _RefObjCommon.ReqLevel2, _RefObjCommon.ReqLevelType3, _RefObjCommon.ReqLevel3, _RefObjCommon.ReqLevelType4, _RefObjCommon.ReqLevel4, _RefObjCommon.MaxContain, _RefObjCommon.RegionID, _RefObjCommon.Dir, _RefObjCommon.OffsetX, _RefObjCommon.OffsetY, _RefObjCommon.OffsetZ, _RefObjCommon.Speed1, _RefObjCommon.Speed2, _RefObjCommon.Scale, _RefObjCommon.BCHeight, _RefObjCommon.BCRadius, _RefObjCommon.EventID, _RefObjCommon.AssocFileObj128, _RefObjCommon.AssocFileDrop128, _RefObjCommon.AssocFileIcon128, _RefObjCommon.AssocFile1_128, _RefObjCommon.AssocFile2_128, _RefObjChar.Lvl, _RefObjChar.CharGender, _RefObjChar.MaxHP, _RefObjChar.MaxMP, _RefObjChar.InventorySize, _RefObjChar.CanStore_TID1, _RefObjChar.CanStore_TID2, _RefObjChar.CanStore_TID3, _RefObjChar.CanStore_TID4, _RefObjChar.CanBeVehicle, _RefObjChar.CanControl, _RefObjChar.DamagePortion, _RefObjChar.MaxPassenger, _RefObjChar.AssocTactics, _RefObjChar.PD, _RefObjChar.MD, _RefObjChar.PAR, _RefObjChar.MAR, _RefObjChar.ER, _RefObjChar.BR, _RefObjChar.HR, _RefObjChar.CHR, _RefObjChar.ExpToGive, _RefObjChar.CreepType, _RefObjChar.Knockdown, _RefObjChar.KO_RecoverTime, _RefObjChar.DefaultSkill_1, _RefObjChar.DefaultSkill_2, _RefObjChar.DefaultSkill_3, _RefObjChar.DefaultSkill_4, _RefObjChar.DefaultSkill_5, _RefObjChar.DefaultSkill_6, _RefObjChar.DefaultSkill_7, _RefObjChar.DefaultSkill_8, _RefObjChar.DefaultSkill_9, _RefObjChar.DefaultSkill_10, _RefObjChar.TextureType, _RefObjChar.Except_1, _RefObjChar.Except_2, _RefObjChar.Except_3, _RefObjChar.Except_4, _RefObjChar.Except_5, _RefObjChar.Except_6, _RefObjChar.Except_7, _RefObjChar.Except_8, _RefObjChar.Except_9, _RefObjChar.Except_10 FROM _RefObjCommon INNER JOIN _RefObjChar ON _RefObjCommon.Link = _RefObjChar.ID WHERE _RefObjCommon.TypeID1 = 1 AND _RefObjCommon.Service = 1 AND _RefObjCommon.ID BETWEEN 20000 AND 24999

characterdata_30000.txt
Query : SELECT _RefObjCommon.Service, _RefObjCommon.ID, _RefObjCommon.CodeName128, _RefObjCommon.ObjName128, _RefObjCommon.OrgObjCodeName128, _RefObjCommon.NameStrID128, _RefObjCommon.DescStrID128, _RefObjCommon.CashItem, _RefObjCommon.Bionic, _RefObjCommon.TypeID1, _RefObjCommon.TypeID2, _RefObjCommon.TypeID3, _RefObjCommon.TypeID4, _RefObjCommon.DecayTime, _RefObjCommon.Country, _RefObjCommon.Rarity, _RefObjCommon.CanTrade, _RefObjCommon.CanSell, _RefObjCommon.CanBuy, _RefObjCommon.CanBorrow, _RefObjCommon.CanDrop, _RefObjCommon.CanPick, _RefObjCommon.CanRepair, _RefObjCommon.CanRevive, _RefObjCommon.CanUse, _RefObjCommon.CanThrow, _RefObjCommon.Price, _RefObjCommon.CostRepair, _RefObjCommon.CostRevive, _RefObjCommon.CostBorrow, _RefObjCommon.KeepingFee, _RefObjCommon.SellPrice, _RefObjCommon.ReqLevelType1, _RefObjCommon.ReqLevel1, _RefObjCommon.ReqLevelType2, _RefObjCommon.ReqLevel2, _RefObjCommon.ReqLevelType3, _RefObjCommon.ReqLevel3, _RefObjCommon.ReqLevelType4, _RefObjCommon.ReqLevel4, _RefObjCommon.MaxContain, _RefObjCommon.RegionID, _RefObjCommon.Dir, _RefObjCommon.OffsetX, _RefObjCommon.OffsetY, _RefObjCommon.OffsetZ, _RefObjCommon.Speed1, _RefObjCommon.Speed2, _RefObjCommon.Scale, _RefObjCommon.BCHeight, _RefObjCommon.BCRadius, _RefObjCommon.EventID, _RefObjCommon.AssocFileObj128, _RefObjCommon.AssocFileDrop128, _RefObjCommon.AssocFileIcon128, _RefObjCommon.AssocFile1_128, _RefObjCommon.AssocFile2_128, _RefObjChar.Lvl, _RefObjChar.CharGender, _RefObjChar.MaxHP, _RefObjChar.MaxMP, _RefObjChar.InventorySize, _RefObjChar.CanStore_TID1, _RefObjChar.CanStore_TID2, _RefObjChar.CanStore_TID3, _RefObjChar.CanStore_TID4, _RefObjChar.CanBeVehicle, _RefObjChar.CanControl, _RefObjChar.DamagePortion, _RefObjChar.MaxPassenger, _RefObjChar.AssocTactics, _RefObjChar.PD, _RefObjChar.MD, _RefObjChar.PAR, _RefObjChar.MAR, _RefObjChar.ER, _RefObjChar.BR, _RefObjChar.HR, _RefObjChar.CHR, _RefObjChar.ExpToGive, _RefObjChar.CreepType, _RefObjChar.Knockdown, _RefObjChar.KO_RecoverTime, _RefObjChar.DefaultSkill_1, _RefObjChar.DefaultSkill_2, _RefObjChar.DefaultSkill_3, _RefObjChar.DefaultSkill_4, _RefObjChar.DefaultSkill_5, _RefObjChar.DefaultSkill_6, _RefObjChar.DefaultSkill_7, _RefObjChar.DefaultSkill_8, _RefObjChar.DefaultSkill_9, _RefObjChar.DefaultSkill_10, _RefObjChar.TextureType, _RefObjChar.Except_1, _RefObjChar.Except_2, _RefObjChar.Except_3, _RefObjChar.Except_4, _RefObjChar.Except_5, _RefObjChar.Except_6, _RefObjChar.Except_7, _RefObjChar.Except_8, _RefObjChar.Except_9, _RefObjChar.Except_10 FROM _RefObjCommon INNER JOIN _RefObjChar ON _RefObjCommon.Link = _RefObjChar.ID WHERE _RefObjCommon.TypeID1 = 1 AND _RefObjCommon.Service = 1 AND _RefObjCommon.ID BETWEEN 25000 AND 29999

characterdata_35000.txt
Query : SELECT _RefObjCommon.Service, _RefObjCommon.ID, _RefObjCommon.CodeName128, _RefObjCommon.ObjName128, _RefObjCommon.OrgObjCodeName128, _RefObjCommon.NameStrID128, _RefObjCommon.DescStrID128, _RefObjCommon.CashItem, _RefObjCommon.Bionic, _RefObjCommon.TypeID1, _RefObjCommon.TypeID2, _RefObjCommon.TypeID3, _RefObjCommon.TypeID4, _RefObjCommon.DecayTime, _RefObjCommon.Country, _RefObjCommon.Rarity, _RefObjCommon.CanTrade, _RefObjCommon.CanSell, _RefObjCommon.CanBuy, _RefObjCommon.CanBorrow, _RefObjCommon.CanDrop, _RefObjCommon.CanPick, _RefObjCommon.CanRepair, _RefObjCommon.CanRevive, _RefObjCommon.CanUse, _RefObjCommon.CanThrow, _RefObjCommon.Price, _RefObjCommon.CostRepair, _RefObjCommon.CostRevive, _RefObjCommon.CostBorrow, _RefObjCommon.KeepingFee, _RefObjCommon.SellPrice, _RefObjCommon.ReqLevelType1, _RefObjCommon.ReqLevel1, _RefObjCommon.ReqLevelType2, _RefObjCommon.ReqLevel2, _RefObjCommon.ReqLevelType3, _RefObjCommon.ReqLevel3, _RefObjCommon.ReqLevelType4, _RefObjCommon.ReqLevel4, _RefObjCommon.MaxContain, _RefObjCommon.RegionID, _RefObjCommon.Dir, _RefObjCommon.OffsetX, _RefObjCommon.OffsetY, _RefObjCommon.OffsetZ, _RefObjCommon.Speed1, _RefObjCommon.Speed2, _RefObjCommon.Scale, _RefObjCommon.BCHeight, _RefObjCommon.BCRadius, _RefObjCommon.EventID, _RefObjCommon.AssocFileObj128, _RefObjCommon.AssocFileDrop128, _RefObjCommon.AssocFileIcon128, _RefObjCommon.AssocFile1_128, _RefObjCommon.AssocFile2_128, _RefObjChar.Lvl, _RefObjChar.CharGender, _RefObjChar.MaxHP, _RefObjChar.MaxMP, _RefObjChar.InventorySize, _RefObjChar.CanStore_TID1, _RefObjChar.CanStore_TID2, _RefObjChar.CanStore_TID3, _RefObjChar.CanStore_TID4, _RefObjChar.CanBeVehicle, _RefObjChar.CanControl, _RefObjChar.DamagePortion, _RefObjChar.MaxPassenger, _RefObjChar.AssocTactics, _RefObjChar.PD, _RefObjChar.MD, _RefObjChar.PAR, _RefObjChar.MAR, _RefObjChar.ER, _RefObjChar.BR, _RefObjChar.HR, _RefObjChar.CHR, _RefObjChar.ExpToGive, _RefObjChar.CreepType, _RefObjChar.Knockdown, _RefObjChar.KO_RecoverTime, _RefObjChar.DefaultSkill_1, _RefObjChar.DefaultSkill_2, _RefObjChar.DefaultSkill_3, _RefObjChar.DefaultSkill_4, _RefObjChar.DefaultSkill_5, _RefObjChar.DefaultSkill_6, _RefObjChar.DefaultSkill_7, _RefObjChar.DefaultSkill_8, _RefObjChar.DefaultSkill_9, _RefObjChar.DefaultSkill_10, _RefObjChar.TextureType, _RefObjChar.Except_1, _RefObjChar.Except_2, _RefObjChar.Except_3, _RefObjChar.Except_4, _RefObjChar.Except_5, _RefObjChar.Except_6, _RefObjChar.Except_7, _RefObjChar.Except_8, _RefObjChar.Except_9, _RefObjChar.Except_10 FROM _RefObjCommon INNER JOIN _RefObjChar ON _RefObjCommon.Link = _RefObjChar.ID WHERE _RefObjCommon.TypeID1 = 1 AND _RefObjCommon.Service = 1 AND _RefObjCommon.ID BETWEEN 30000 AND 34999

characterdata_40000.txt
Query : SELECT _RefObjCommon.Service, _RefObjCommon.ID, _RefObjCommon.CodeName128, _RefObjCommon.ObjName128, _RefObjCommon.OrgObjCodeName128, _RefObjCommon.NameStrID128, _RefObjCommon.DescStrID128, _RefObjCommon.CashItem, _RefObjCommon.Bionic, _RefObjCommon.TypeID1, _RefObjCommon.TypeID2, _RefObjCommon.TypeID3, _RefObjCommon.TypeID4, _RefObjCommon.DecayTime, _RefObjCommon.Country, _RefObjCommon.Rarity, _RefObjCommon.CanTrade, _RefObjCommon.CanSell, _RefObjCommon.CanBuy, _RefObjCommon.CanBorrow, _RefObjCommon.CanDrop, _RefObjCommon.CanPick, _RefObjCommon.CanRepair, _RefObjCommon.CanRevive, _RefObjCommon.CanUse, _RefObjCommon.CanThrow, _RefObjCommon.Price, _RefObjCommon.CostRepair, _RefObjCommon.CostRevive, _RefObjCommon.CostBorrow, _RefObjCommon.KeepingFee, _RefObjCommon.SellPrice, _RefObjCommon.ReqLevelType1, _RefObjCommon.ReqLevel1, _RefObjCommon.ReqLevelType2, _RefObjCommon.ReqLevel2, _RefObjCommon.ReqLevelType3, _RefObjCommon.ReqLevel3, _RefObjCommon.ReqLevelType4, _RefObjCommon.ReqLevel4, _RefObjCommon.MaxContain, _RefObjCommon.RegionID, _RefObjCommon.Dir, _RefObjCommon.OffsetX, _RefObjCommon.OffsetY, _RefObjCommon.OffsetZ, _RefObjCommon.Speed1, _RefObjCommon.Speed2, _RefObjCommon.Scale, _RefObjCommon.BCHeight, _RefObjCommon.BCRadius, _RefObjCommon.EventID, _RefObjCommon.AssocFileObj128, _RefObjCommon.AssocFileDrop128, _RefObjCommon.AssocFileIcon128, _RefObjCommon.AssocFile1_128, _RefObjCommon.AssocFile2_128, _RefObjChar.Lvl, _RefObjChar.CharGender, _RefObjChar.MaxHP, _RefObjChar.MaxMP, _RefObjChar.InventorySize, _RefObjChar.CanStore_TID1, _RefObjChar.CanStore_TID2, _RefObjChar.CanStore_TID3, _RefObjChar.CanStore_TID4, _RefObjChar.CanBeVehicle, _RefObjChar.CanControl, _RefObjChar.DamagePortion, _RefObjChar.MaxPassenger, _RefObjChar.AssocTactics, _RefObjChar.PD, _RefObjChar.MD, _RefObjChar.PAR, _RefObjChar.MAR, _RefObjChar.ER, _RefObjChar.BR, _RefObjChar.HR, _RefObjChar.CHR, _RefObjChar.ExpToGive, _RefObjChar.CreepType, _RefObjChar.Knockdown, _RefObjChar.KO_RecoverTime, _RefObjChar.DefaultSkill_1, _RefObjChar.DefaultSkill_2, _RefObjChar.DefaultSkill_3, _RefObjChar.DefaultSkill_4, _RefObjChar.DefaultSkill_5, _RefObjChar.DefaultSkill_6, _RefObjChar.DefaultSkill_7, _RefObjChar.DefaultSkill_8, _RefObjChar.DefaultSkill_9, _RefObjChar.DefaultSkill_10, _RefObjChar.TextureType, _RefObjChar.Except_1, _RefObjChar.Except_2, _RefObjChar.Except_3, _RefObjChar.Except_4, _RefObjChar.Except_5, _RefObjChar.Except_6, _RefObjChar.Except_7, _RefObjChar.Except_8, _RefObjChar.Except_9, _RefObjChar.Except_10 FROM _RefObjCommon INNER JOIN _RefObjChar ON _RefObjCommon.Link = _RefObjChar.ID WHERE _RefObjCommon.TypeID1 = 1 AND _RefObjCommon.Service = 1 AND _RefObjCommon.ID BETWEEN 35000 AND 39999

characterdata_45000.txt
Query : SELECT _RefObjCommon.Service, _RefObjCommon.ID, _RefObjCommon.CodeName128, _RefObjCommon.ObjName128, _RefObjCommon.OrgObjCodeName128, _RefObjCommon.NameStrID128, _RefObjCommon.DescStrID128, _RefObjCommon.CashItem, _RefObjCommon.Bionic, _RefObjCommon.TypeID1, _RefObjCommon.TypeID2, _RefObjCommon.TypeID3, _RefObjCommon.TypeID4, _RefObjCommon.DecayTime, _RefObjCommon.Country, _RefObjCommon.Rarity, _RefObjCommon.CanTrade, _RefObjCommon.CanSell, _RefObjCommon.CanBuy, _RefObjCommon.CanBorrow, _RefObjCommon.CanDrop, _RefObjCommon.CanPick, _RefObjCommon.CanRepair, _RefObjCommon.CanRevive, _RefObjCommon.CanUse, _RefObjCommon.CanThrow, _RefObjCommon.Price, _RefObjCommon.CostRepair, _RefObjCommon.CostRevive, _RefObjCommon.CostBorrow, _RefObjCommon.KeepingFee, _RefObjCommon.SellPrice, _RefObjCommon.ReqLevelType1, _RefObjCommon.ReqLevel1, _RefObjCommon.ReqLevelType2, _RefObjCommon.ReqLevel2, _RefObjCommon.ReqLevelType3, _RefObjCommon.ReqLevel3, _RefObjCommon.ReqLevelType4, _RefObjCommon.ReqLevel4, _RefObjCommon.MaxContain, _RefObjCommon.RegionID, _RefObjCommon.Dir, _RefObjCommon.OffsetX, _RefObjCommon.OffsetY, _RefObjCommon.OffsetZ, _RefObjCommon.Speed1, _RefObjCommon.Speed2, _RefObjCommon.Scale, _RefObjCommon.BCHeight, _RefObjCommon.BCRadius, _RefObjCommon.EventID, _RefObjCommon.AssocFileObj128, _RefObjCommon.AssocFileDrop128, _RefObjCommon.AssocFileIcon128, _RefObjCommon.AssocFile1_128, _RefObjCommon.AssocFile2_128, _RefObjChar.Lvl, _RefObjChar.CharGender, _RefObjChar.MaxHP, _RefObjChar.MaxMP, _RefObjChar.InventorySize, _RefObjChar.CanStore_TID1, _RefObjChar.CanStore_TID2, _RefObjChar.CanStore_TID3, _RefObjChar.CanStore_TID4, _RefObjChar.CanBeVehicle, _RefObjChar.CanControl, _RefObjChar.DamagePortion, _RefObjChar.MaxPassenger, _RefObjChar.AssocTactics, _RefObjChar.PD, _RefObjChar.MD, _RefObjChar.PAR, _RefObjChar.MAR, _RefObjChar.ER, _RefObjChar.BR, _RefObjChar.HR, _RefObjChar.CHR, _RefObjChar.ExpToGive, _RefObjChar.CreepType, _RefObjChar.Knockdown, _RefObjChar.KO_RecoverTime, _RefObjChar.DefaultSkill_1, _RefObjChar.DefaultSkill_2, _RefObjChar.DefaultSkill_3, _RefObjChar.DefaultSkill_4, _RefObjChar.DefaultSkill_5, _RefObjChar.DefaultSkill_6, _RefObjChar.DefaultSkill_7, _RefObjChar.DefaultSkill_8, _RefObjChar.DefaultSkill_9, _RefObjChar.DefaultSkill_10, _RefObjChar.TextureType, _RefObjChar.Except_1, _RefObjChar.Except_2, _RefObjChar.Except_3, _RefObjChar.Except_4, _RefObjChar.Except_5, _RefObjChar.Except_6, _RefObjChar.Except_7, _RefObjChar.Except_8, _RefObjChar.Except_9, _RefObjChar.Except_10 FROM _RefObjCommon INNER JOIN _RefObjChar ON _RefObjCommon.Link = _RefObjChar.ID WHERE _RefObjCommon.TypeID1 = 1 AND _RefObjCommon.Service = 1 AND _RefObjCommon.ID >= 40000

eventzonedata.txt
Query : SELECT * FROM _RefEventZone WHERE Service = 1

gachaitemset.txt
Query : SELECT * FROM _RefGachaItemSet WHERE Service = 1

gameworldconfigdata.txt
Query : SELECT GroupCodeName128, ValueCodeName128, Type, Value FROM _RefGame_World_Config WHERE Service = 1

gameworlddata.txt
Query : SELECT ID, WorldCodeName128, Type, WorldMaxCount, WorldMaxUserCount, ConfigGroupCodeName128 FROM _RefGame_World

hwanleveldata.txt
Query : SELECT HwanLevel, Title_CH70, Title_EU70 FROM _RefHWANLevel

itemdata_5000.txt
Query : SELECT _RefObjCommon.Service, _RefObjCommon.ID, _RefObjCommon.CodeName128, _RefObjCommon.ObjName128, _RefObjCommon.OrgObjCodeName128, _RefObjCommon.NameStrID128, _RefObjCommon.DescStrID128, _RefObjCommon.CashItem, _RefObjCommon.Bionic, _RefObjCommon.TypeID1, _RefObjCommon.TypeID2, _RefObjCommon.TypeID3, _RefObjCommon.TypeID4, _RefObjCommon.DecayTime, _RefObjCommon.Country, _RefObjCommon.Rarity, _RefObjCommon.CanTrade, _RefObjCommon.CanSell, _RefObjCommon.CanBuy, _RefObjCommon.CanBorrow, _RefObjCommon.CanDrop, _RefObjCommon.CanPick, _RefObjCommon.CanRepair, _RefObjCommon.CanRevive, _RefObjCommon.CanUse, _RefObjCommon.CanThrow, _RefObjCommon.Price, _RefObjCommon.CostRepair, _RefObjCommon.CostRevive, _RefObjCommon.CostBorrow, _RefObjCommon.KeepingFee, _RefObjCommon.SellPrice, _RefObjCommon.ReqLevelType1, _RefObjCommon.ReqLevel1, _RefObjCommon.ReqLevelType2, _RefObjCommon.ReqLevel2, _RefObjCommon.ReqLevelType3, _RefObjCommon.ReqLevel3, _RefObjCommon.ReqLevelType4, _RefObjCommon.ReqLevel4, _RefObjCommon.MaxContain, _RefObjCommon.RegionID, _RefObjCommon.Dir, _RefObjCommon.OffsetX, _RefObjCommon.OffsetY, _RefObjCommon.OffsetZ, _RefObjCommon.Speed1, _RefObjCommon.Speed2, _RefObjCommon.Scale, _RefObjCommon.BCHeight, _RefObjCommon.BCRadius, _RefObjCommon.EventID, _RefObjCommon.AssocFileObj128, _RefObjCommon.AssocFileDrop128, _RefObjCommon.AssocFileIcon128, _RefObjCommon.AssocFile1_128, _RefObjCommon.AssocFile2_128, _RefObjItem.MaxStack, _RefObjItem.ReqGender, _RefObjItem.ReqStr, _RefObjItem.ReqInt, _RefObjItem.ItemClass, _RefObjItem.SetID, REPLACE(_RefObjItem.Dur_L,',','.'), REPLACE(_RefObjItem.Dur_U,',','.'), REPLACE(_RefObjItem.PD_L,',','.'), REPLACE(_RefObjItem.PD_U,',','.'), REPLACE(_RefObjItem.PDInc,',','.'), REPLACE(_RefObjItem.ER_L,',','.'), REPLACE(_RefObjItem.ER_U,',','.'), REPLACE(_RefObjItem.ERInc,',','.'), REPLACE(_RefObjItem.PAR_L,',','.'), REPLACE(_RefObjItem.PAR_U,',','.'), REPLACE(_RefObjItem.PARInc,',','.'), REPLACE(_RefObjItem.BR_L,',','.'), REPLACE(_RefObjItem.BR_U,',','.'), REPLACE(_RefObjItem.MD_L,',','.'), REPLACE(_RefObjItem.MD_U,',','.'), REPLACE(_RefObjItem.MDInc,',','.'), REPLACE(_RefObjItem.MAR_L,',','.'), REPLACE(_RefObjItem.MAR_U,',','.'), REPLACE(_RefObjItem.MARInc,',','.'), REPLACE(_RefObjItem.PDStr_L,',','.'), REPLACE(_RefObjItem.PDStr_U,',','.'), REPLACE(_RefObjItem.MDInt_L,',','.'), REPLACE(_RefObjItem.MDInt_U,',','.'), _RefObjItem.Quivered, _RefObjItem.Ammo1_TID4, _RefObjItem.Ammo2_TID4, _RefObjItem.Ammo3_TID4, _RefObjItem.Ammo4_TID4, _RefObjItem.Ammo5_TID4, _RefObjItem.SpeedClass, _RefObjItem.TwoHanded, _RefObjItem.Range, REPLACE(_RefObjItem.PAttackMin_L,',','.'), REPLACE(_RefObjItem.PAttackMin_U,',','.'), REPLACE(_RefObjItem.PAttackMax_L,',','.'), REPLACE(_RefObjItem.PAttackMax_U,',','.'), REPLACE(_RefObjItem.PAttackInc,',','.'), REPLACE(_RefObjItem.MAttackMin_L,',','.'), REPLACE(_RefObjItem.MAttackMin_U,',','.'), REPLACE(_RefObjItem.MAttackMax_L,',','.'), REPLACE(_RefObjItem.MAttackMax_U,',','.'), REPLACE(_RefObjItem.MAttackInc,',','.'), REPLACE(_RefObjItem.PAStrMin_L,',','.'), REPLACE(_RefObjItem.PAStrMin_U,',','.'), REPLACE(_RefObjItem.PAStrMax_L,',','.'), REPLACE(_RefObjItem.PAStrMax_U,',','.'), REPLACE(_RefObjItem.MAInt_Min_L,',','.'), REPLACE(_RefObjItem.MAInt_Min_U,',','.'), REPLACE(_RefObjItem.MAInt_Max_L,',','.'), REPLACE(_RefObjItem.MAInt_Max_U,',','.'), REPLACE(_RefObjItem.HR_L,',','.'), REPLACE(_RefObjItem.HR_U,',','.'), REPLACE(_RefObjItem.HRInc,',','.'), REPLACE(_RefObjItem.CHR_L,',','.'), REPLACE(_RefObjItem.CHR_U,',','.'), _RefObjItem.Param1, _RefObjItem.Desc1_128, _RefObjItem.Param2, TRIM(_RefObjItem.Desc2_128), _RefObjItem.Param3, _RefObjItem.Desc3_128, _RefObjItem.Param4, _RefObjItem.Desc4_128, _RefObjItem.Param5, _RefObjItem.Desc5_128, _RefObjItem.Param6, _RefObjItem.Desc6_128, _RefObjItem.Param7, _RefObjItem.Desc7_128, _RefObjItem.Param8, _RefObjItem.Desc8_128, _RefObjItem.Param9, _RefObjItem.Desc9_128, _RefObjItem.Param10, _RefObjItem.Desc10_128, _RefObjItem.Param11, _RefObjItem.Desc11_128, _RefObjItem.Param12, _RefObjItem.Desc12_128, _RefObjItem.Param13, _RefObjItem.Desc13_128, _RefObjItem.Param14, _RefObjItem.Desc14_128, _RefObjItem.Param15, _RefObjItem.Desc15_128, _RefObjItem.Param16, _RefObjItem.Desc16_128, _RefObjItem.Param17, _RefObjItem.Desc17_128, _RefObjItem.Param18, _RefObjItem.Desc18_128, _RefObjItem.Param19, _RefObjItem.Desc19_128, _RefObjItem.Param20, _RefObjItem.Desc20_128, _RefObjItem.MaxMagicOptCount, _RefObjItem.ChildItemCount FROM _RefObjCommon INNER JOIN _RefObjItem ON _RefObjCommon.Link = _RefObjItem.ID WHERE _RefObjCommon.TypeID1 = 3 AND _RefObjCommon.Service = 1 AND _RefObjCommon.ID BETWEEN 0 AND 4999

itemdata_10000.txt
Query : SELECT _RefObjCommon.Service, _RefObjCommon.ID, _RefObjCommon.CodeName128, _RefObjCommon.ObjName128, _RefObjCommon.OrgObjCodeName128, _RefObjCommon.NameStrID128, _RefObjCommon.DescStrID128, _RefObjCommon.CashItem, _RefObjCommon.Bionic, _RefObjCommon.TypeID1, _RefObjCommon.TypeID2, _RefObjCommon.TypeID3, _RefObjCommon.TypeID4, _RefObjCommon.DecayTime, _RefObjCommon.Country, _RefObjCommon.Rarity, _RefObjCommon.CanTrade, _RefObjCommon.CanSell, _RefObjCommon.CanBuy, _RefObjCommon.CanBorrow, _RefObjCommon.CanDrop, _RefObjCommon.CanPick, _RefObjCommon.CanRepair, _RefObjCommon.CanRevive, _RefObjCommon.CanUse, _RefObjCommon.CanThrow, _RefObjCommon.Price, _RefObjCommon.CostRepair, _RefObjCommon.CostRevive, _RefObjCommon.CostBorrow, _RefObjCommon.KeepingFee, _RefObjCommon.SellPrice, _RefObjCommon.ReqLevelType1, _RefObjCommon.ReqLevel1, _RefObjCommon.ReqLevelType2, _RefObjCommon.ReqLevel2, _RefObjCommon.ReqLevelType3, _RefObjCommon.ReqLevel3, _RefObjCommon.ReqLevelType4, _RefObjCommon.ReqLevel4, _RefObjCommon.MaxContain, _RefObjCommon.RegionID, _RefObjCommon.Dir, _RefObjCommon.OffsetX, _RefObjCommon.OffsetY, _RefObjCommon.OffsetZ, _RefObjCommon.Speed1, _RefObjCommon.Speed2, _RefObjCommon.Scale, _RefObjCommon.BCHeight, _RefObjCommon.BCRadius, _RefObjCommon.EventID, _RefObjCommon.AssocFileObj128, _RefObjCommon.AssocFileDrop128, _RefObjCommon.AssocFileIcon128, _RefObjCommon.AssocFile1_128, _RefObjCommon.AssocFile2_128, _RefObjItem.MaxStack, _RefObjItem.ReqGender, _RefObjItem.ReqStr, _RefObjItem.ReqInt, _RefObjItem.ItemClass, _RefObjItem.SetID, REPLACE(_RefObjItem.Dur_L,',','.'), REPLACE(_RefObjItem.Dur_U,',','.'), REPLACE(_RefObjItem.PD_L,',','.'), REPLACE(_RefObjItem.PD_U,',','.'), REPLACE(_RefObjItem.PDInc,',','.'), REPLACE(_RefObjItem.ER_L,',','.'), REPLACE(_RefObjItem.ER_U,',','.'), REPLACE(_RefObjItem.ERInc,',','.'), REPLACE(_RefObjItem.PAR_L,',','.'), REPLACE(_RefObjItem.PAR_U,',','.'), REPLACE(_RefObjItem.PARInc,',','.'), REPLACE(_RefObjItem.BR_L,',','.'), REPLACE(_RefObjItem.BR_U,',','.'), REPLACE(_RefObjItem.MD_L,',','.'), REPLACE(_RefObjItem.MD_U,',','.'), REPLACE(_RefObjItem.MDInc,',','.'), REPLACE(_RefObjItem.MAR_L,',','.'), REPLACE(_RefObjItem.MAR_U,',','.'), REPLACE(_RefObjItem.MARInc,',','.'), REPLACE(_RefObjItem.PDStr_L,',','.'), REPLACE(_RefObjItem.PDStr_U,',','.'), REPLACE(_RefObjItem.MDInt_L,',','.'), REPLACE(_RefObjItem.MDInt_U,',','.'), _RefObjItem.Quivered, _RefObjItem.Ammo1_TID4, _RefObjItem.Ammo2_TID4, _RefObjItem.Ammo3_TID4, _RefObjItem.Ammo4_TID4, _RefObjItem.Ammo5_TID4, _RefObjItem.SpeedClass, _RefObjItem.TwoHanded, _RefObjItem.Range, REPLACE(_RefObjItem.PAttackMin_L,',','.'), REPLACE(_RefObjItem.PAttackMin_U,',','.'), REPLACE(_RefObjItem.PAttackMax_L,',','.'), REPLACE(_RefObjItem.PAttackMax_U,',','.'), REPLACE(_RefObjItem.PAttackInc,',','.'), REPLACE(_RefObjItem.MAttackMin_L,',','.'), REPLACE(_RefObjItem.MAttackMin_U,',','.'), REPLACE(_RefObjItem.MAttackMax_L,',','.'), REPLACE(_RefObjItem.MAttackMax_U,',','.'), REPLACE(_RefObjItem.MAttackInc,',','.'), REPLACE(_RefObjItem.PAStrMin_L,',','.'), REPLACE(_RefObjItem.PAStrMin_U,',','.'), REPLACE(_RefObjItem.PAStrMax_L,',','.'), REPLACE(_RefObjItem.PAStrMax_U,',','.'), REPLACE(_RefObjItem.MAInt_Min_L,',','.'), REPLACE(_RefObjItem.MAInt_Min_U,',','.'), REPLACE(_RefObjItem.MAInt_Max_L,',','.'), REPLACE(_RefObjItem.MAInt_Max_U,',','.'), REPLACE(_RefObjItem.HR_L,',','.'), REPLACE(_RefObjItem.HR_U,',','.'), REPLACE(_RefObjItem.HRInc,',','.'), REPLACE(_RefObjItem.CHR_L,',','.'), REPLACE(_RefObjItem.CHR_U,',','.'), _RefObjItem.Param1, _RefObjItem.Desc1_128, _RefObjItem.Param2, TRIM(_RefObjItem.Desc2_128), _RefObjItem.Param3, _RefObjItem.Desc3_128, _RefObjItem.Param4, _RefObjItem.Desc4_128, _RefObjItem.Param5, _RefObjItem.Desc5_128, _RefObjItem.Param6, _RefObjItem.Desc6_128, _RefObjItem.Param7, _RefObjItem.Desc7_128, _RefObjItem.Param8, _RefObjItem.Desc8_128, _RefObjItem.Param9, _RefObjItem.Desc9_128, _RefObjItem.Param10, _RefObjItem.Desc10_128, _RefObjItem.Param11, _RefObjItem.Desc11_128, _RefObjItem.Param12, _RefObjItem.Desc12_128, _RefObjItem.Param13, _RefObjItem.Desc13_128, _RefObjItem.Param14, _RefObjItem.Desc14_128, _RefObjItem.Param15, _RefObjItem.Desc15_128, _RefObjItem.Param16, _RefObjItem.Desc16_128, _RefObjItem.Param17, _RefObjItem.Desc17_128, _RefObjItem.Param18, _RefObjItem.Desc18_128, _RefObjItem.Param19, _RefObjItem.Desc19_128, _RefObjItem.Param20, _RefObjItem.Desc20_128, _RefObjItem.MaxMagicOptCount, _RefObjItem.ChildItemCount FROM _RefObjCommon INNER JOIN _RefObjItem ON _RefObjCommon.Link = _RefObjItem.ID WHERE _RefObjCommon.TypeID1 = 3 AND _RefObjCommon.Service = 1 AND _RefObjCommon.ID BETWEEN 5000 AND 9999

itemdata_15000.txt
Query : SELECT _RefObjCommon.Service, _RefObjCommon.ID, _RefObjCommon.CodeName128, _RefObjCommon.ObjName128, _RefObjCommon.OrgObjCodeName128, _RefObjCommon.NameStrID128, _RefObjCommon.DescStrID128, _RefObjCommon.CashItem, _RefObjCommon.Bionic, _RefObjCommon.TypeID1, _RefObjCommon.TypeID2, _RefObjCommon.TypeID3, _RefObjCommon.TypeID4, _RefObjCommon.DecayTime, _RefObjCommon.Country, _RefObjCommon.Rarity, _RefObjCommon.CanTrade, _RefObjCommon.CanSell, _RefObjCommon.CanBuy, _RefObjCommon.CanBorrow, _RefObjCommon.CanDrop, _RefObjCommon.CanPick, _RefObjCommon.CanRepair, _RefObjCommon.CanRevive, _RefObjCommon.CanUse, _RefObjCommon.CanThrow, _RefObjCommon.Price, _RefObjCommon.CostRepair, _RefObjCommon.CostRevive, _RefObjCommon.CostBorrow, _RefObjCommon.KeepingFee, _RefObjCommon.SellPrice, _RefObjCommon.ReqLevelType1, _RefObjCommon.ReqLevel1, _RefObjCommon.ReqLevelType2, _RefObjCommon.ReqLevel2, _RefObjCommon.ReqLevelType3, _RefObjCommon.ReqLevel3, _RefObjCommon.ReqLevelType4, _RefObjCommon.ReqLevel4, _RefObjCommon.MaxContain, _RefObjCommon.RegionID, _RefObjCommon.Dir, _RefObjCommon.OffsetX, _RefObjCommon.OffsetY, _RefObjCommon.OffsetZ, _RefObjCommon.Speed1, _RefObjCommon.Speed2, _RefObjCommon.Scale, _RefObjCommon.BCHeight, _RefObjCommon.BCRadius, _RefObjCommon.EventID, _RefObjCommon.AssocFileObj128, _RefObjCommon.AssocFileDrop128, _RefObjCommon.AssocFileIcon128, _RefObjCommon.AssocFile1_128, _RefObjCommon.AssocFile2_128, _RefObjItem.MaxStack, _RefObjItem.ReqGender, _RefObjItem.ReqStr, _RefObjItem.ReqInt, _RefObjItem.ItemClass, _RefObjItem.SetID, REPLACE(_RefObjItem.Dur_L,',','.'), REPLACE(_RefObjItem.Dur_U,',','.'), REPLACE(_RefObjItem.PD_L,',','.'), REPLACE(_RefObjItem.PD_U,',','.'), REPLACE(_RefObjItem.PDInc,',','.'), REPLACE(_RefObjItem.ER_L,',','.'), REPLACE(_RefObjItem.ER_U,',','.'), REPLACE(_RefObjItem.ERInc,',','.'), REPLACE(_RefObjItem.PAR_L,',','.'), REPLACE(_RefObjItem.PAR_U,',','.'), REPLACE(_RefObjItem.PARInc,',','.'), REPLACE(_RefObjItem.BR_L,',','.'), REPLACE(_RefObjItem.BR_U,',','.'), REPLACE(_RefObjItem.MD_L,',','.'), REPLACE(_RefObjItem.MD_U,',','.'), REPLACE(_RefObjItem.MDInc,',','.'), REPLACE(_RefObjItem.MAR_L,',','.'), REPLACE(_RefObjItem.MAR_U,',','.'), REPLACE(_RefObjItem.MARInc,',','.'), REPLACE(_RefObjItem.PDStr_L,',','.'), REPLACE(_RefObjItem.PDStr_U,',','.'), REPLACE(_RefObjItem.MDInt_L,',','.'), REPLACE(_RefObjItem.MDInt_U,',','.'), _RefObjItem.Quivered, _RefObjItem.Ammo1_TID4, _RefObjItem.Ammo2_TID4, _RefObjItem.Ammo3_TID4, _RefObjItem.Ammo4_TID4, _RefObjItem.Ammo5_TID4, _RefObjItem.SpeedClass, _RefObjItem.TwoHanded, _RefObjItem.Range, REPLACE(_RefObjItem.PAttackMin_L,',','.'), REPLACE(_RefObjItem.PAttackMin_U,',','.'), REPLACE(_RefObjItem.PAttackMax_L,',','.'), REPLACE(_RefObjItem.PAttackMax_U,',','.'), REPLACE(_RefObjItem.PAttackInc,',','.'), REPLACE(_RefObjItem.MAttackMin_L,',','.'), REPLACE(_RefObjItem.MAttackMin_U,',','.'), REPLACE(_RefObjItem.MAttackMax_L,',','.'), REPLACE(_RefObjItem.MAttackMax_U,',','.'), REPLACE(_RefObjItem.MAttackInc,',','.'), REPLACE(_RefObjItem.PAStrMin_L,',','.'), REPLACE(_RefObjItem.PAStrMin_U,',','.'), REPLACE(_RefObjItem.PAStrMax_L,',','.'), REPLACE(_RefObjItem.PAStrMax_U,',','.'), REPLACE(_RefObjItem.MAInt_Min_L,',','.'), REPLACE(_RefObjItem.MAInt_Min_U,',','.'), REPLACE(_RefObjItem.MAInt_Max_L,',','.'), REPLACE(_RefObjItem.MAInt_Max_U,',','.'), REPLACE(_RefObjItem.HR_L,',','.'), REPLACE(_RefObjItem.HR_U,',','.'), REPLACE(_RefObjItem.HRInc,',','.'), REPLACE(_RefObjItem.CHR_L,',','.'), REPLACE(_RefObjItem.CHR_U,',','.'), _RefObjItem.Param1, _RefObjItem.Desc1_128, _RefObjItem.Param2, TRIM(_RefObjItem.Desc2_128), _RefObjItem.Param3, _RefObjItem.Desc3_128, _RefObjItem.Param4, _RefObjItem.Desc4_128, _RefObjItem.Param5, _RefObjItem.Desc5_128, _RefObjItem.Param6, _RefObjItem.Desc6_128, _RefObjItem.Param7, _RefObjItem.Desc7_128, _RefObjItem.Param8, _RefObjItem.Desc8_128, _RefObjItem.Param9, _RefObjItem.Desc9_128, _RefObjItem.Param10, _RefObjItem.Desc10_128, _RefObjItem.Param11, _RefObjItem.Desc11_128, _RefObjItem.Param12, _RefObjItem.Desc12_128, _RefObjItem.Param13, _RefObjItem.Desc13_128, _RefObjItem.Param14, _RefObjItem.Desc14_128, _RefObjItem.Param15, _RefObjItem.Desc15_128, _RefObjItem.Param16, _RefObjItem.Desc16_128, _RefObjItem.Param17, _RefObjItem.Desc17_128, _RefObjItem.Param18, _RefObjItem.Desc18_128, _RefObjItem.Param19, _RefObjItem.Desc19_128, _RefObjItem.Param20, _RefObjItem.Desc20_128, _RefObjItem.MaxMagicOptCount, _RefObjItem.ChildItemCount FROM _RefObjCommon INNER JOIN _RefObjItem ON _RefObjCommon.Link = _RefObjItem.ID WHERE _RefObjCommon.TypeID1 = 3 AND _RefObjCommon.Service = 1 AND _RefObjCommon.ID BETWEEN 10000 AND 14999

itemdata_20000.txt
Query : SELECT _RefObjCommon.Service, _RefObjCommon.ID, _RefObjCommon.CodeName128, _RefObjCommon.ObjName128, _RefObjCommon.OrgObjCodeName128, _RefObjCommon.NameStrID128, _RefObjCommon.DescStrID128, _RefObjCommon.CashItem, _RefObjCommon.Bionic, _RefObjCommon.TypeID1, _RefObjCommon.TypeID2, _RefObjCommon.TypeID3, _RefObjCommon.TypeID4, _RefObjCommon.DecayTime, _RefObjCommon.Country, _RefObjCommon.Rarity, _RefObjCommon.CanTrade, _RefObjCommon.CanSell, _RefObjCommon.CanBuy, _RefObjCommon.CanBorrow, _RefObjCommon.CanDrop, _RefObjCommon.CanPick, _RefObjCommon.CanRepair, _RefObjCommon.CanRevive, _RefObjCommon.CanUse, _RefObjCommon.CanThrow, _RefObjCommon.Price, _RefObjCommon.CostRepair, _RefObjCommon.CostRevive, _RefObjCommon.CostBorrow, _RefObjCommon.KeepingFee, _RefObjCommon.SellPrice, _RefObjCommon.ReqLevelType1, _RefObjCommon.ReqLevel1, _RefObjCommon.ReqLevelType2, _RefObjCommon.ReqLevel2, _RefObjCommon.ReqLevelType3, _RefObjCommon.ReqLevel3, _RefObjCommon.ReqLevelType4, _RefObjCommon.ReqLevel4, _RefObjCommon.MaxContain, _RefObjCommon.RegionID, _RefObjCommon.Dir, _RefObjCommon.OffsetX, _RefObjCommon.OffsetY, _RefObjCommon.OffsetZ, _RefObjCommon.Speed1, _RefObjCommon.Speed2, _RefObjCommon.Scale, _RefObjCommon.BCHeight, _RefObjCommon.BCRadius, _RefObjCommon.EventID, _RefObjCommon.AssocFileObj128, _RefObjCommon.AssocFileDrop128, _RefObjCommon.AssocFileIcon128, _RefObjCommon.AssocFile1_128, _RefObjCommon.AssocFile2_128, _RefObjItem.MaxStack, _RefObjItem.ReqGender, _RefObjItem.ReqStr, _RefObjItem.ReqInt, _RefObjItem.ItemClass, _RefObjItem.SetID, REPLACE(_RefObjItem.Dur_L,',','.'), REPLACE(_RefObjItem.Dur_U,',','.'), REPLACE(_RefObjItem.PD_L,',','.'), REPLACE(_RefObjItem.PD_U,',','.'), REPLACE(_RefObjItem.PDInc,',','.'), REPLACE(_RefObjItem.ER_L,',','.'), REPLACE(_RefObjItem.ER_U,',','.'), REPLACE(_RefObjItem.ERInc,',','.'), REPLACE(_RefObjItem.PAR_L,',','.'), REPLACE(_RefObjItem.PAR_U,',','.'), REPLACE(_RefObjItem.PARInc,',','.'), REPLACE(_RefObjItem.BR_L,',','.'), REPLACE(_RefObjItem.BR_U,',','.'), REPLACE(_RefObjItem.MD_L,',','.'), REPLACE(_RefObjItem.MD_U,',','.'), REPLACE(_RefObjItem.MDInc,',','.'), REPLACE(_RefObjItem.MAR_L,',','.'), REPLACE(_RefObjItem.MAR_U,',','.'), REPLACE(_RefObjItem.MARInc,',','.'), REPLACE(_RefObjItem.PDStr_L,',','.'), REPLACE(_RefObjItem.PDStr_U,',','.'), REPLACE(_RefObjItem.MDInt_L,',','.'), REPLACE(_RefObjItem.MDInt_U,',','.'), _RefObjItem.Quivered, _RefObjItem.Ammo1_TID4, _RefObjItem.Ammo2_TID4, _RefObjItem.Ammo3_TID4, _RefObjItem.Ammo4_TID4, _RefObjItem.Ammo5_TID4, _RefObjItem.SpeedClass, _RefObjItem.TwoHanded, _RefObjItem.Range, REPLACE(_RefObjItem.PAttackMin_L,',','.'), REPLACE(_RefObjItem.PAttackMin_U,',','.'), REPLACE(_RefObjItem.PAttackMax_L,',','.'), REPLACE(_RefObjItem.PAttackMax_U,',','.'), REPLACE(_RefObjItem.PAttackInc,',','.'), REPLACE(_RefObjItem.MAttackMin_L,',','.'), REPLACE(_RefObjItem.MAttackMin_U,',','.'), REPLACE(_RefObjItem.MAttackMax_L,',','.'), REPLACE(_RefObjItem.MAttackMax_U,',','.'), REPLACE(_RefObjItem.MAttackInc,',','.'), REPLACE(_RefObjItem.PAStrMin_L,',','.'), REPLACE(_RefObjItem.PAStrMin_U,',','.'), REPLACE(_RefObjItem.PAStrMax_L,',','.'), REPLACE(_RefObjItem.PAStrMax_U,',','.'), REPLACE(_RefObjItem.MAInt_Min_L,',','.'), REPLACE(_RefObjItem.MAInt_Min_U,',','.'), REPLACE(_RefObjItem.MAInt_Max_L,',','.'), REPLACE(_RefObjItem.MAInt_Max_U,',','.'), REPLACE(_RefObjItem.HR_L,',','.'), REPLACE(_RefObjItem.HR_U,',','.'), REPLACE(_RefObjItem.HRInc,',','.'), REPLACE(_RefObjItem.CHR_L,',','.'), REPLACE(_RefObjItem.CHR_U,',','.'), _RefObjItem.Param1, _RefObjItem.Desc1_128, _RefObjItem.Param2, TRIM(_RefObjItem.Desc2_128), _RefObjItem.Param3, _RefObjItem.Desc3_128, _RefObjItem.Param4, _RefObjItem.Desc4_128, _RefObjItem.Param5, _RefObjItem.Desc5_128, _RefObjItem.Param6, _RefObjItem.Desc6_128, _RefObjItem.Param7, _RefObjItem.Desc7_128, _RefObjItem.Param8, _RefObjItem.Desc8_128, _RefObjItem.Param9, _RefObjItem.Desc9_128, _RefObjItem.Param10, _RefObjItem.Desc10_128, _RefObjItem.Param11, _RefObjItem.Desc11_128, _RefObjItem.Param12, _RefObjItem.Desc12_128, _RefObjItem.Param13, _RefObjItem.Desc13_128, _RefObjItem.Param14, _RefObjItem.Desc14_128, _RefObjItem.Param15, _RefObjItem.Desc15_128, _RefObjItem.Param16, _RefObjItem.Desc16_128, _RefObjItem.Param17, _RefObjItem.Desc17_128, _RefObjItem.Param18, _RefObjItem.Desc18_128, _RefObjItem.Param19, _RefObjItem.Desc19_128, _RefObjItem.Param20, _RefObjItem.Desc20_128, _RefObjItem.MaxMagicOptCount, _RefObjItem.ChildItemCount FROM _RefObjCommon INNER JOIN _RefObjItem ON _RefObjCommon.Link = _RefObjItem.ID WHERE _RefObjCommon.TypeID1 = 3 AND _RefObjCommon.Service = 1 AND _RefObjCommon.ID BETWEEN 15000 AND 19999

itemdata_25000.txt
Query : SELECT _RefObjCommon.Service, _RefObjCommon.ID, _RefObjCommon.CodeName128, _RefObjCommon.ObjName128, _RefObjCommon.OrgObjCodeName128, _RefObjCommon.NameStrID128, _RefObjCommon.DescStrID128, _RefObjCommon.CashItem, _RefObjCommon.Bionic, _RefObjCommon.TypeID1, _RefObjCommon.TypeID2, _RefObjCommon.TypeID3, _RefObjCommon.TypeID4, _RefObjCommon.DecayTime, _RefObjCommon.Country, _RefObjCommon.Rarity, _RefObjCommon.CanTrade, _RefObjCommon.CanSell, _RefObjCommon.CanBuy, _RefObjCommon.CanBorrow, _RefObjCommon.CanDrop, _RefObjCommon.CanPick, _RefObjCommon.CanRepair, _RefObjCommon.CanRevive, _RefObjCommon.CanUse, _RefObjCommon.CanThrow, _RefObjCommon.Price, _RefObjCommon.CostRepair, _RefObjCommon.CostRevive, _RefObjCommon.CostBorrow, _RefObjCommon.KeepingFee, _RefObjCommon.SellPrice, _RefObjCommon.ReqLevelType1, _RefObjCommon.ReqLevel1, _RefObjCommon.ReqLevelType2, _RefObjCommon.ReqLevel2, _RefObjCommon.ReqLevelType3, _RefObjCommon.ReqLevel3, _RefObjCommon.ReqLevelType4, _RefObjCommon.ReqLevel4, _RefObjCommon.MaxContain, _RefObjCommon.RegionID, _RefObjCommon.Dir, _RefObjCommon.OffsetX, _RefObjCommon.OffsetY, _RefObjCommon.OffsetZ, _RefObjCommon.Speed1, _RefObjCommon.Speed2, _RefObjCommon.Scale, _RefObjCommon.BCHeight, _RefObjCommon.BCRadius, _RefObjCommon.EventID, _RefObjCommon.AssocFileObj128, _RefObjCommon.AssocFileDrop128, _RefObjCommon.AssocFileIcon128, _RefObjCommon.AssocFile1_128, _RefObjCommon.AssocFile2_128, _RefObjItem.MaxStack, _RefObjItem.ReqGender, _RefObjItem.ReqStr, _RefObjItem.ReqInt, _RefObjItem.ItemClass, _RefObjItem.SetID, REPLACE(_RefObjItem.Dur_L,',','.'), REPLACE(_RefObjItem.Dur_U,',','.'), REPLACE(_RefObjItem.PD_L,',','.'), REPLACE(_RefObjItem.PD_U,',','.'), REPLACE(_RefObjItem.PDInc,',','.'), REPLACE(_RefObjItem.ER_L,',','.'), REPLACE(_RefObjItem.ER_U,',','.'), REPLACE(_RefObjItem.ERInc,',','.'), REPLACE(_RefObjItem.PAR_L,',','.'), REPLACE(_RefObjItem.PAR_U,',','.'), REPLACE(_RefObjItem.PARInc,',','.'), REPLACE(_RefObjItem.BR_L,',','.'), REPLACE(_RefObjItem.BR_U,',','.'), REPLACE(_RefObjItem.MD_L,',','.'), REPLACE(_RefObjItem.MD_U,',','.'), REPLACE(_RefObjItem.MDInc,',','.'), REPLACE(_RefObjItem.MAR_L,',','.'), REPLACE(_RefObjItem.MAR_U,',','.'), REPLACE(_RefObjItem.MARInc,',','.'), REPLACE(_RefObjItem.PDStr_L,',','.'), REPLACE(_RefObjItem.PDStr_U,',','.'), REPLACE(_RefObjItem.MDInt_L,',','.'), REPLACE(_RefObjItem.MDInt_U,',','.'), _RefObjItem.Quivered, _RefObjItem.Ammo1_TID4, _RefObjItem.Ammo2_TID4, _RefObjItem.Ammo3_TID4, _RefObjItem.Ammo4_TID4, _RefObjItem.Ammo5_TID4, _RefObjItem.SpeedClass, _RefObjItem.TwoHanded, _RefObjItem.Range, REPLACE(_RefObjItem.PAttackMin_L,',','.'), REPLACE(_RefObjItem.PAttackMin_U,',','.'), REPLACE(_RefObjItem.PAttackMax_L,',','.'), REPLACE(_RefObjItem.PAttackMax_U,',','.'), REPLACE(_RefObjItem.PAttackInc,',','.'), REPLACE(_RefObjItem.MAttackMin_L,',','.'), REPLACE(_RefObjItem.MAttackMin_U,',','.'), REPLACE(_RefObjItem.MAttackMax_L,',','.'), REPLACE(_RefObjItem.MAttackMax_U,',','.'), REPLACE(_RefObjItem.MAttackInc,',','.'), REPLACE(_RefObjItem.PAStrMin_L,',','.'), REPLACE(_RefObjItem.PAStrMin_U,',','.'), REPLACE(_RefObjItem.PAStrMax_L,',','.'), REPLACE(_RefObjItem.PAStrMax_U,',','.'), REPLACE(_RefObjItem.MAInt_Min_L,',','.'), REPLACE(_RefObjItem.MAInt_Min_U,',','.'), REPLACE(_RefObjItem.MAInt_Max_L,',','.'), REPLACE(_RefObjItem.MAInt_Max_U,',','.'), REPLACE(_RefObjItem.HR_L,',','.'), REPLACE(_RefObjItem.HR_U,',','.'), REPLACE(_RefObjItem.HRInc,',','.'), REPLACE(_RefObjItem.CHR_L,',','.'), REPLACE(_RefObjItem.CHR_U,',','.'), _RefObjItem.Param1, _RefObjItem.Desc1_128, _RefObjItem.Param2, TRIM(_RefObjItem.Desc2_128), _RefObjItem.Param3, _RefObjItem.Desc3_128, _RefObjItem.Param4, _RefObjItem.Desc4_128, _RefObjItem.Param5, _RefObjItem.Desc5_128, _RefObjItem.Param6, _RefObjItem.Desc6_128, _RefObjItem.Param7, _RefObjItem.Desc7_128, _RefObjItem.Param8, _RefObjItem.Desc8_128, _RefObjItem.Param9, _RefObjItem.Desc9_128, _RefObjItem.Param10, _RefObjItem.Desc10_128, _RefObjItem.Param11, _RefObjItem.Desc11_128, _RefObjItem.Param12, _RefObjItem.Desc12_128, _RefObjItem.Param13, _RefObjItem.Desc13_128, _RefObjItem.Param14, _RefObjItem.Desc14_128, _RefObjItem.Param15, _RefObjItem.Desc15_128, _RefObjItem.Param16, _RefObjItem.Desc16_128, _RefObjItem.Param17, _RefObjItem.Desc17_128, _RefObjItem.Param18, _RefObjItem.Desc18_128, _RefObjItem.Param19, _RefObjItem.Desc19_128, _RefObjItem.Param20, _RefObjItem.Desc20_128, _RefObjItem.MaxMagicOptCount, _RefObjItem.ChildItemCount FROM _RefObjCommon INNER JOIN _RefObjItem ON _RefObjCommon.Link = _RefObjItem.ID WHERE _RefObjCommon.TypeID1 = 3 AND _RefObjCommon.Service = 1 AND _RefObjCommon.ID BETWEEN 20000 AND 24999

itemdata_30000.txt
Query : SELECT _RefObjCommon.Service, _RefObjCommon.ID, _RefObjCommon.CodeName128, _RefObjCommon.ObjName128, _RefObjCommon.OrgObjCodeName128, _RefObjCommon.NameStrID128, _RefObjCommon.DescStrID128, _RefObjCommon.CashItem, _RefObjCommon.Bionic, _RefObjCommon.TypeID1, _RefObjCommon.TypeID2, _RefObjCommon.TypeID3, _RefObjCommon.TypeID4, _RefObjCommon.DecayTime, _RefObjCommon.Country, _RefObjCommon.Rarity, _RefObjCommon.CanTrade, _RefObjCommon.CanSell, _RefObjCommon.CanBuy, _RefObjCommon.CanBorrow, _RefObjCommon.CanDrop, _RefObjCommon.CanPick, _RefObjCommon.CanRepair, _RefObjCommon.CanRevive, _RefObjCommon.CanUse, _RefObjCommon.CanThrow, _RefObjCommon.Price, _RefObjCommon.CostRepair, _RefObjCommon.CostRevive, _RefObjCommon.CostBorrow, _RefObjCommon.KeepingFee, _RefObjCommon.SellPrice, _RefObjCommon.ReqLevelType1, _RefObjCommon.ReqLevel1, _RefObjCommon.ReqLevelType2, _RefObjCommon.ReqLevel2, _RefObjCommon.ReqLevelType3, _RefObjCommon.ReqLevel3, _RefObjCommon.ReqLevelType4, _RefObjCommon.ReqLevel4, _RefObjCommon.MaxContain, _RefObjCommon.RegionID, _RefObjCommon.Dir, _RefObjCommon.OffsetX, _RefObjCommon.OffsetY, _RefObjCommon.OffsetZ, _RefObjCommon.Speed1, _RefObjCommon.Speed2, _RefObjCommon.Scale, _RefObjCommon.BCHeight, _RefObjCommon.BCRadius, _RefObjCommon.EventID, _RefObjCommon.AssocFileObj128, _RefObjCommon.AssocFileDrop128, _RefObjCommon.AssocFileIcon128, _RefObjCommon.AssocFile1_128, _RefObjCommon.AssocFile2_128, _RefObjItem.MaxStack, _RefObjItem.ReqGender, _RefObjItem.ReqStr, _RefObjItem.ReqInt, _RefObjItem.ItemClass, _RefObjItem.SetID, REPLACE(_RefObjItem.Dur_L,',','.'), REPLACE(_RefObjItem.Dur_U,',','.'), REPLACE(_RefObjItem.PD_L,',','.'), REPLACE(_RefObjItem.PD_U,',','.'), REPLACE(_RefObjItem.PDInc,',','.'), REPLACE(_RefObjItem.ER_L,',','.'), REPLACE(_RefObjItem.ER_U,',','.'), REPLACE(_RefObjItem.ERInc,',','.'), REPLACE(_RefObjItem.PAR_L,',','.'), REPLACE(_RefObjItem.PAR_U,',','.'), REPLACE(_RefObjItem.PARInc,',','.'), REPLACE(_RefObjItem.BR_L,',','.'), REPLACE(_RefObjItem.BR_U,',','.'), REPLACE(_RefObjItem.MD_L,',','.'), REPLACE(_RefObjItem.MD_U,',','.'), REPLACE(_RefObjItem.MDInc,',','.'), REPLACE(_RefObjItem.MAR_L,',','.'), REPLACE(_RefObjItem.MAR_U,',','.'), REPLACE(_RefObjItem.MARInc,',','.'), REPLACE(_RefObjItem.PDStr_L,',','.'), REPLACE(_RefObjItem.PDStr_U,',','.'), REPLACE(_RefObjItem.MDInt_L,',','.'), REPLACE(_RefObjItem.MDInt_U,',','.'), _RefObjItem.Quivered, _RefObjItem.Ammo1_TID4, _RefObjItem.Ammo2_TID4, _RefObjItem.Ammo3_TID4, _RefObjItem.Ammo4_TID4, _RefObjItem.Ammo5_TID4, _RefObjItem.SpeedClass, _RefObjItem.TwoHanded, _RefObjItem.Range, REPLACE(_RefObjItem.PAttackMin_L,',','.'), REPLACE(_RefObjItem.PAttackMin_U,',','.'), REPLACE(_RefObjItem.PAttackMax_L,',','.'), REPLACE(_RefObjItem.PAttackMax_U,',','.'), REPLACE(_RefObjItem.PAttackInc,',','.'), REPLACE(_RefObjItem.MAttackMin_L,',','.'), REPLACE(_RefObjItem.MAttackMin_U,',','.'), REPLACE(_RefObjItem.MAttackMax_L,',','.'), REPLACE(_RefObjItem.MAttackMax_U,',','.'), REPLACE(_RefObjItem.MAttackInc,',','.'), REPLACE(_RefObjItem.PAStrMin_L,',','.'), REPLACE(_RefObjItem.PAStrMin_U,',','.'), REPLACE(_RefObjItem.PAStrMax_L,',','.'), REPLACE(_RefObjItem.PAStrMax_U,',','.'), REPLACE(_RefObjItem.MAInt_Min_L,',','.'), REPLACE(_RefObjItem.MAInt_Min_U,',','.'), REPLACE(_RefObjItem.MAInt_Max_L,',','.'), REPLACE(_RefObjItem.MAInt_Max_U,',','.'), REPLACE(_RefObjItem.HR_L,',','.'), REPLACE(_RefObjItem.HR_U,',','.'), REPLACE(_RefObjItem.HRInc,',','.'), REPLACE(_RefObjItem.CHR_L,',','.'), REPLACE(_RefObjItem.CHR_U,',','.'), _RefObjItem.Param1, _RefObjItem.Desc1_128, _RefObjItem.Param2, TRIM(_RefObjItem.Desc2_128), _RefObjItem.Param3, _RefObjItem.Desc3_128, _RefObjItem.Param4, _RefObjItem.Desc4_128, _RefObjItem.Param5, _RefObjItem.Desc5_128, _RefObjItem.Param6, _RefObjItem.Desc6_128, _RefObjItem.Param7, _RefObjItem.Desc7_128, _RefObjItem.Param8, _RefObjItem.Desc8_128, _RefObjItem.Param9, _RefObjItem.Desc9_128, _RefObjItem.Param10, _RefObjItem.Desc10_128, _RefObjItem.Param11, _RefObjItem.Desc11_128, _RefObjItem.Param12, _RefObjItem.Desc12_128, _RefObjItem.Param13, _RefObjItem.Desc13_128, _RefObjItem.Param14, _RefObjItem.Desc14_128, _RefObjItem.Param15, _RefObjItem.Desc15_128, _RefObjItem.Param16, _RefObjItem.Desc16_128, _RefObjItem.Param17, _RefObjItem.Desc17_128, _RefObjItem.Param18, _RefObjItem.Desc18_128, _RefObjItem.Param19, _RefObjItem.Desc19_128, _RefObjItem.Param20, _RefObjItem.Desc20_128, _RefObjItem.MaxMagicOptCount, _RefObjItem.ChildItemCount FROM _RefObjCommon INNER JOIN _RefObjItem ON _RefObjCommon.Link = _RefObjItem.ID WHERE _RefObjCommon.TypeID1 = 3 AND _RefObjCommon.Service = 1 AND _RefObjCommon.ID BETWEEN 25000 AND 29999

itemdata_35000.txt
Query : SELECT _RefObjCommon.Service, _RefObjCommon.ID, _RefObjCommon.CodeName128, _RefObjCommon.ObjName128, _RefObjCommon.OrgObjCodeName128, _RefObjCommon.NameStrID128, _RefObjCommon.DescStrID128, _RefObjCommon.CashItem, _RefObjCommon.Bionic, _RefObjCommon.TypeID1, _RefObjCommon.TypeID2, _RefObjCommon.TypeID3, _RefObjCommon.TypeID4, _RefObjCommon.DecayTime, _RefObjCommon.Country, _RefObjCommon.Rarity, _RefObjCommon.CanTrade, _RefObjCommon.CanSell, _RefObjCommon.CanBuy, _RefObjCommon.CanBorrow, _RefObjCommon.CanDrop, _RefObjCommon.CanPick, _RefObjCommon.CanRepair, _RefObjCommon.CanRevive, _RefObjCommon.CanUse, _RefObjCommon.CanThrow, _RefObjCommon.Price, _RefObjCommon.CostRepair, _RefObjCommon.CostRevive, _RefObjCommon.CostBorrow, _RefObjCommon.KeepingFee, _RefObjCommon.SellPrice, _RefObjCommon.ReqLevelType1, _RefObjCommon.ReqLevel1, _RefObjCommon.ReqLevelType2, _RefObjCommon.ReqLevel2, _RefObjCommon.ReqLevelType3, _RefObjCommon.ReqLevel3, _RefObjCommon.ReqLevelType4, _RefObjCommon.ReqLevel4, _RefObjCommon.MaxContain, _RefObjCommon.RegionID, _RefObjCommon.Dir, _RefObjCommon.OffsetX, _RefObjCommon.OffsetY, _RefObjCommon.OffsetZ, _RefObjCommon.Speed1, _RefObjCommon.Speed2, _RefObjCommon.Scale, _RefObjCommon.BCHeight, _RefObjCommon.BCRadius, _RefObjCommon.EventID, _RefObjCommon.AssocFileObj128, _RefObjCommon.AssocFileDrop128, _RefObjCommon.AssocFileIcon128, _RefObjCommon.AssocFile1_128, _RefObjCommon.AssocFile2_128, _RefObjItem.MaxStack, _RefObjItem.ReqGender, _RefObjItem.ReqStr, _RefObjItem.ReqInt, _RefObjItem.ItemClass, _RefObjItem.SetID, REPLACE(_RefObjItem.Dur_L,',','.'), REPLACE(_RefObjItem.Dur_U,',','.'), REPLACE(_RefObjItem.PD_L,',','.'), REPLACE(_RefObjItem.PD_U,',','.'), REPLACE(_RefObjItem.PDInc,',','.'), REPLACE(_RefObjItem.ER_L,',','.'), REPLACE(_RefObjItem.ER_U,',','.'), REPLACE(_RefObjItem.ERInc,',','.'), REPLACE(_RefObjItem.PAR_L,',','.'), REPLACE(_RefObjItem.PAR_U,',','.'), REPLACE(_RefObjItem.PARInc,',','.'), REPLACE(_RefObjItem.BR_L,',','.'), REPLACE(_RefObjItem.BR_U,',','.'), REPLACE(_RefObjItem.MD_L,',','.'), REPLACE(_RefObjItem.MD_U,',','.'), REPLACE(_RefObjItem.MDInc,',','.'), REPLACE(_RefObjItem.MAR_L,',','.'), REPLACE(_RefObjItem.MAR_U,',','.'), REPLACE(_RefObjItem.MARInc,',','.'), REPLACE(_RefObjItem.PDStr_L,',','.'), REPLACE(_RefObjItem.PDStr_U,',','.'), REPLACE(_RefObjItem.MDInt_L,',','.'), REPLACE(_RefObjItem.MDInt_U,',','.'), _RefObjItem.Quivered, _RefObjItem.Ammo1_TID4, _RefObjItem.Ammo2_TID4, _RefObjItem.Ammo3_TID4, _RefObjItem.Ammo4_TID4, _RefObjItem.Ammo5_TID4, _RefObjItem.SpeedClass, _RefObjItem.TwoHanded, _RefObjItem.Range, REPLACE(_RefObjItem.PAttackMin_L,',','.'), REPLACE(_RefObjItem.PAttackMin_U,',','.'), REPLACE(_RefObjItem.PAttackMax_L,',','.'), REPLACE(_RefObjItem.PAttackMax_U,',','.'), REPLACE(_RefObjItem.PAttackInc,',','.'), REPLACE(_RefObjItem.MAttackMin_L,',','.'), REPLACE(_RefObjItem.MAttackMin_U,',','.'), REPLACE(_RefObjItem.MAttackMax_L,',','.'), REPLACE(_RefObjItem.MAttackMax_U,',','.'), REPLACE(_RefObjItem.MAttackInc,',','.'), REPLACE(_RefObjItem.PAStrMin_L,',','.'), REPLACE(_RefObjItem.PAStrMin_U,',','.'), REPLACE(_RefObjItem.PAStrMax_L,',','.'), REPLACE(_RefObjItem.PAStrMax_U,',','.'), REPLACE(_RefObjItem.MAInt_Min_L,',','.'), REPLACE(_RefObjItem.MAInt_Min_U,',','.'), REPLACE(_RefObjItem.MAInt_Max_L,',','.'), REPLACE(_RefObjItem.MAInt_Max_U,',','.'), REPLACE(_RefObjItem.HR_L,',','.'), REPLACE(_RefObjItem.HR_U,',','.'), REPLACE(_RefObjItem.HRInc,',','.'), REPLACE(_RefObjItem.CHR_L,',','.'), REPLACE(_RefObjItem.CHR_U,',','.'), _RefObjItem.Param1, _RefObjItem.Desc1_128, _RefObjItem.Param2, TRIM(_RefObjItem.Desc2_128), _RefObjItem.Param3, _RefObjItem.Desc3_128, _RefObjItem.Param4, _RefObjItem.Desc4_128, _RefObjItem.Param5, _RefObjItem.Desc5_128, _RefObjItem.Param6, _RefObjItem.Desc6_128, _RefObjItem.Param7, _RefObjItem.Desc7_128, _RefObjItem.Param8, _RefObjItem.Desc8_128, _RefObjItem.Param9, _RefObjItem.Desc9_128, _RefObjItem.Param10, _RefObjItem.Desc10_128, _RefObjItem.Param11, _RefObjItem.Desc11_128, _RefObjItem.Param12, _RefObjItem.Desc12_128, _RefObjItem.Param13, _RefObjItem.Desc13_128, _RefObjItem.Param14, _RefObjItem.Desc14_128, _RefObjItem.Param15, _RefObjItem.Desc15_128, _RefObjItem.Param16, _RefObjItem.Desc16_128, _RefObjItem.Param17, _RefObjItem.Desc17_128, _RefObjItem.Param18, _RefObjItem.Desc18_128, _RefObjItem.Param19, _RefObjItem.Desc19_128, _RefObjItem.Param20, _RefObjItem.Desc20_128, _RefObjItem.MaxMagicOptCount, _RefObjItem.ChildItemCount FROM _RefObjCommon INNER JOIN _RefObjItem ON _RefObjCommon.Link = _RefObjItem.ID WHERE _RefObjCommon.TypeID1 = 3 AND _RefObjCommon.Service = 1 AND _RefObjCommon.ID BETWEEN 30000 AND 34999

itemdata_40000.txt
Query : SELECT _RefObjCommon.Service, _RefObjCommon.ID, _RefObjCommon.CodeName128, _RefObjCommon.ObjName128, _RefObjCommon.OrgObjCodeName128, _RefObjCommon.NameStrID128, _RefObjCommon.DescStrID128, _RefObjCommon.CashItem, _RefObjCommon.Bionic, _RefObjCommon.TypeID1, _RefObjCommon.TypeID2, _RefObjCommon.TypeID3, _RefObjCommon.TypeID4, _RefObjCommon.DecayTime, _RefObjCommon.Country, _RefObjCommon.Rarity, _RefObjCommon.CanTrade, _RefObjCommon.CanSell, _RefObjCommon.CanBuy, _RefObjCommon.CanBorrow, _RefObjCommon.CanDrop, _RefObjCommon.CanPick, _RefObjCommon.CanRepair, _RefObjCommon.CanRevive, _RefObjCommon.CanUse, _RefObjCommon.CanThrow, _RefObjCommon.Price, _RefObjCommon.CostRepair, _RefObjCommon.CostRevive, _RefObjCommon.CostBorrow, _RefObjCommon.KeepingFee, _RefObjCommon.SellPrice, _RefObjCommon.ReqLevelType1, _RefObjCommon.ReqLevel1, _RefObjCommon.ReqLevelType2, _RefObjCommon.ReqLevel2, _RefObjCommon.ReqLevelType3, _RefObjCommon.ReqLevel3, _RefObjCommon.ReqLevelType4, _RefObjCommon.ReqLevel4, _RefObjCommon.MaxContain, _RefObjCommon.RegionID, _RefObjCommon.Dir, _RefObjCommon.OffsetX, _RefObjCommon.OffsetY, _RefObjCommon.OffsetZ, _RefObjCommon.Speed1, _RefObjCommon.Speed2, _RefObjCommon.Scale, _RefObjCommon.BCHeight, _RefObjCommon.BCRadius, _RefObjCommon.EventID, _RefObjCommon.AssocFileObj128, _RefObjCommon.AssocFileDrop128, _RefObjCommon.AssocFileIcon128, _RefObjCommon.AssocFile1_128, _RefObjCommon.AssocFile2_128, _RefObjItem.MaxStack, _RefObjItem.ReqGender, _RefObjItem.ReqStr, _RefObjItem.ReqInt, _RefObjItem.ItemClass, _RefObjItem.SetID, REPLACE(_RefObjItem.Dur_L,',','.'), REPLACE(_RefObjItem.Dur_U,',','.'), REPLACE(_RefObjItem.PD_L,',','.'), REPLACE(_RefObjItem.PD_U,',','.'), REPLACE(_RefObjItem.PDInc,',','.'), REPLACE(_RefObjItem.ER_L,',','.'), REPLACE(_RefObjItem.ER_U,',','.'), REPLACE(_RefObjItem.ERInc,',','.'), REPLACE(_RefObjItem.PAR_L,',','.'), REPLACE(_RefObjItem.PAR_U,',','.'), REPLACE(_RefObjItem.PARInc,',','.'), REPLACE(_RefObjItem.BR_L,',','.'), REPLACE(_RefObjItem.BR_U,',','.'), REPLACE(_RefObjItem.MD_L,',','.'), REPLACE(_RefObjItem.MD_U,',','.'), REPLACE(_RefObjItem.MDInc,',','.'), REPLACE(_RefObjItem.MAR_L,',','.'), REPLACE(_RefObjItem.MAR_U,',','.'), REPLACE(_RefObjItem.MARInc,',','.'), REPLACE(_RefObjItem.PDStr_L,',','.'), REPLACE(_RefObjItem.PDStr_U,',','.'), REPLACE(_RefObjItem.MDInt_L,',','.'), REPLACE(_RefObjItem.MDInt_U,',','.'), _RefObjItem.Quivered, _RefObjItem.Ammo1_TID4, _RefObjItem.Ammo2_TID4, _RefObjItem.Ammo3_TID4, _RefObjItem.Ammo4_TID4, _RefObjItem.Ammo5_TID4, _RefObjItem.SpeedClass, _RefObjItem.TwoHanded, _RefObjItem.Range, REPLACE(_RefObjItem.PAttackMin_L,',','.'), REPLACE(_RefObjItem.PAttackMin_U,',','.'), REPLACE(_RefObjItem.PAttackMax_L,',','.'), REPLACE(_RefObjItem.PAttackMax_U,',','.'), REPLACE(_RefObjItem.PAttackInc,',','.'), REPLACE(_RefObjItem.MAttackMin_L,',','.'), REPLACE(_RefObjItem.MAttackMin_U,',','.'), REPLACE(_RefObjItem.MAttackMax_L,',','.'), REPLACE(_RefObjItem.MAttackMax_U,',','.'), REPLACE(_RefObjItem.MAttackInc,',','.'), REPLACE(_RefObjItem.PAStrMin_L,',','.'), REPLACE(_RefObjItem.PAStrMin_U,',','.'), REPLACE(_RefObjItem.PAStrMax_L,',','.'), REPLACE(_RefObjItem.PAStrMax_U,',','.'), REPLACE(_RefObjItem.MAInt_Min_L,',','.'), REPLACE(_RefObjItem.MAInt_Min_U,',','.'), REPLACE(_RefObjItem.MAInt_Max_L,',','.'), REPLACE(_RefObjItem.MAInt_Max_U,',','.'), REPLACE(_RefObjItem.HR_L,',','.'), REPLACE(_RefObjItem.HR_U,',','.'), REPLACE(_RefObjItem.HRInc,',','.'), REPLACE(_RefObjItem.CHR_L,',','.'), REPLACE(_RefObjItem.CHR_U,',','.'), _RefObjItem.Param1, _RefObjItem.Desc1_128, _RefObjItem.Param2, TRIM(_RefObjItem.Desc2_128), _RefObjItem.Param3, _RefObjItem.Desc3_128, _RefObjItem.Param4, _RefObjItem.Desc4_128, _RefObjItem.Param5, _RefObjItem.Desc5_128, _RefObjItem.Param6, _RefObjItem.Desc6_128, _RefObjItem.Param7, _RefObjItem.Desc7_128, _RefObjItem.Param8, _RefObjItem.Desc8_128, _RefObjItem.Param9, _RefObjItem.Desc9_128, _RefObjItem.Param10, _RefObjItem.Desc10_128, _RefObjItem.Param11, _RefObjItem.Desc11_128, _RefObjItem.Param12, _RefObjItem.Desc12_128, _RefObjItem.Param13, _RefObjItem.Desc13_128, _RefObjItem.Param14, _RefObjItem.Desc14_128, _RefObjItem.Param15, _RefObjItem.Desc15_128, _RefObjItem.Param16, _RefObjItem.Desc16_128, _RefObjItem.Param17, _RefObjItem.Desc17_128, _RefObjItem.Param18, _RefObjItem.Desc18_128, _RefObjItem.Param19, _RefObjItem.Desc19_128, _RefObjItem.Param20, _RefObjItem.Desc20_128, _RefObjItem.MaxMagicOptCount, _RefObjItem.ChildItemCount FROM _RefObjCommon INNER JOIN _RefObjItem ON _RefObjCommon.Link = _RefObjItem.ID WHERE _RefObjCommon.TypeID1 = 3 AND _RefObjCommon.Service = 1 AND _RefObjCommon.ID BETWEEN 35000 AND 39999

itemdata_45000.txt
Query : SELECT _RefObjCommon.Service, _RefObjCommon.ID, _RefObjCommon.CodeName128, _RefObjCommon.ObjName128, _RefObjCommon.OrgObjCodeName128, _RefObjCommon.NameStrID128, _RefObjCommon.DescStrID128, _RefObjCommon.CashItem, _RefObjCommon.Bionic, _RefObjCommon.TypeID1, _RefObjCommon.TypeID2, _RefObjCommon.TypeID3, _RefObjCommon.TypeID4, _RefObjCommon.DecayTime, _RefObjCommon.Country, _RefObjCommon.Rarity, _RefObjCommon.CanTrade, _RefObjCommon.CanSell, _RefObjCommon.CanBuy, _RefObjCommon.CanBorrow, _RefObjCommon.CanDrop, _RefObjCommon.CanPick, _RefObjCommon.CanRepair, _RefObjCommon.CanRevive, _RefObjCommon.CanUse, _RefObjCommon.CanThrow, _RefObjCommon.Price, _RefObjCommon.CostRepair, _RefObjCommon.CostRevive, _RefObjCommon.CostBorrow, _RefObjCommon.KeepingFee, _RefObjCommon.SellPrice, _RefObjCommon.ReqLevelType1, _RefObjCommon.ReqLevel1, _RefObjCommon.ReqLevelType2, _RefObjCommon.ReqLevel2, _RefObjCommon.ReqLevelType3, _RefObjCommon.ReqLevel3, _RefObjCommon.ReqLevelType4, _RefObjCommon.ReqLevel4, _RefObjCommon.MaxContain, _RefObjCommon.RegionID, _RefObjCommon.Dir, _RefObjCommon.OffsetX, _RefObjCommon.OffsetY, _RefObjCommon.OffsetZ, _RefObjCommon.Speed1, _RefObjCommon.Speed2, _RefObjCommon.Scale, _RefObjCommon.BCHeight, _RefObjCommon.BCRadius, _RefObjCommon.EventID, _RefObjCommon.AssocFileObj128, _RefObjCommon.AssocFileDrop128, _RefObjCommon.AssocFileIcon128, _RefObjCommon.AssocFile1_128, _RefObjCommon.AssocFile2_128, _RefObjItem.MaxStack, _RefObjItem.ReqGender, _RefObjItem.ReqStr, _RefObjItem.ReqInt, _RefObjItem.ItemClass, _RefObjItem.SetID, REPLACE(_RefObjItem.Dur_L,',','.'), REPLACE(_RefObjItem.Dur_U,',','.'), REPLACE(_RefObjItem.PD_L,',','.'), REPLACE(_RefObjItem.PD_U,',','.'), REPLACE(_RefObjItem.PDInc,',','.'), REPLACE(_RefObjItem.ER_L,',','.'), REPLACE(_RefObjItem.ER_U,',','.'), REPLACE(_RefObjItem.ERInc,',','.'), REPLACE(_RefObjItem.PAR_L,',','.'), REPLACE(_RefObjItem.PAR_U,',','.'), REPLACE(_RefObjItem.PARInc,',','.'), REPLACE(_RefObjItem.BR_L,',','.'), REPLACE(_RefObjItem.BR_U,',','.'), REPLACE(_RefObjItem.MD_L,',','.'), REPLACE(_RefObjItem.MD_U,',','.'), REPLACE(_RefObjItem.MDInc,',','.'), REPLACE(_RefObjItem.MAR_L,',','.'), REPLACE(_RefObjItem.MAR_U,',','.'), REPLACE(_RefObjItem.MARInc,',','.'), REPLACE(_RefObjItem.PDStr_L,',','.'), REPLACE(_RefObjItem.PDStr_U,',','.'), REPLACE(_RefObjItem.MDInt_L,',','.'), REPLACE(_RefObjItem.MDInt_U,',','.'), _RefObjItem.Quivered, _RefObjItem.Ammo1_TID4, _RefObjItem.Ammo2_TID4, _RefObjItem.Ammo3_TID4, _RefObjItem.Ammo4_TID4, _RefObjItem.Ammo5_TID4, _RefObjItem.SpeedClass, _RefObjItem.TwoHanded, _RefObjItem.Range, REPLACE(_RefObjItem.PAttackMin_L,',','.'), REPLACE(_RefObjItem.PAttackMin_U,',','.'), REPLACE(_RefObjItem.PAttackMax_L,',','.'), REPLACE(_RefObjItem.PAttackMax_U,',','.'), REPLACE(_RefObjItem.PAttackInc,',','.'), REPLACE(_RefObjItem.MAttackMin_L,',','.'), REPLACE(_RefObjItem.MAttackMin_U,',','.'), REPLACE(_RefObjItem.MAttackMax_L,',','.'), REPLACE(_RefObjItem.MAttackMax_U,',','.'), REPLACE(_RefObjItem.MAttackInc,',','.'), REPLACE(_RefObjItem.PAStrMin_L,',','.'), REPLACE(_RefObjItem.PAStrMin_U,',','.'), REPLACE(_RefObjItem.PAStrMax_L,',','.'), REPLACE(_RefObjItem.PAStrMax_U,',','.'), REPLACE(_RefObjItem.MAInt_Min_L,',','.'), REPLACE(_RefObjItem.MAInt_Min_U,',','.'), REPLACE(_RefObjItem.MAInt_Max_L,',','.'), REPLACE(_RefObjItem.MAInt_Max_U,',','.'), REPLACE(_RefObjItem.HR_L,',','.'), REPLACE(_RefObjItem.HR_U,',','.'), REPLACE(_RefObjItem.HRInc,',','.'), REPLACE(_RefObjItem.CHR_L,',','.'), REPLACE(_RefObjItem.CHR_U,',','.'), _RefObjItem.Param1, _RefObjItem.Desc1_128, _RefObjItem.Param2, TRIM(_RefObjItem.Desc2_128), _RefObjItem.Param3, _RefObjItem.Desc3_128, _RefObjItem.Param4, _RefObjItem.Desc4_128, _RefObjItem.Param5, _RefObjItem.Desc5_128, _RefObjItem.Param6, _RefObjItem.Desc6_128, _RefObjItem.Param7, _RefObjItem.Desc7_128, _RefObjItem.Param8, _RefObjItem.Desc8_128, _RefObjItem.Param9, _RefObjItem.Desc9_128, _RefObjItem.Param10, _RefObjItem.Desc10_128, _RefObjItem.Param11, _RefObjItem.Desc11_128, _RefObjItem.Param12, _RefObjItem.Desc12_128, _RefObjItem.Param13, _RefObjItem.Desc13_128, _RefObjItem.Param14, _RefObjItem.Desc14_128, _RefObjItem.Param15, _RefObjItem.Desc15_128, _RefObjItem.Param16, _RefObjItem.Desc16_128, _RefObjItem.Param17, _RefObjItem.Desc17_128, _RefObjItem.Param18, _RefObjItem.Desc18_128, _RefObjItem.Param19, _RefObjItem.Desc19_128, _RefObjItem.Param20, _RefObjItem.Desc20_128, _RefObjItem.MaxMagicOptCount, _RefObjItem.ChildItemCount FROM _RefObjCommon INNER JOIN _RefObjItem ON _RefObjCommon.Link = _RefObjItem.ID WHERE _RefObjCommon.TypeID1 = 3 AND _RefObjCommon.Service = 1 AND _RefObjCommon.ID >= 40000

leveldata.txt
Query : SELECT * FROM _RefLevel

magicoption.txt
Query : SELECT Service, ID, MOptName128, AttrType, MLevel, REPLACE(Prob,',','.'), Weight, Param1, Param2, Param3, Param4, Param5, Param6, Param7, Param8, Param9, Param10, Param11, Param12, Param13, Param14, Param15, Param16, ExcFunc1, ExcFunc2, ExcFunc3, ExcFunc4, ExcFunc5, ExcFunc6, AvailItemGroup1, ReqClass1, AvailItemGroup2, ReqClass2, AvailItemGroup3, ReqClass3, AvailItemGroup4, ReqClass4, AvailItemGroup5, ReqClass5, AvailItemGroup6, ReqClass6, AvailItemGroup7, ReqClass7, AvailItemGroup8, ReqClass8, AvailItemGroup9, ReqClass9, AvailItemGroup10, ReqClass10 FROM _RefMagicOpt WHERE Service = 1

magicoptionassign.txt
Query : SELECT * FROM _RefMagicOptAssign WHERE Service = 1

questdata.txt
Query : SELECT * FROM _RefQuest WHERE Service = 1

refabilitybyitemoptleveldata.txt
Query : SELECT Service, ID, RefItemID, ItemOptLevel FROM _RefAbilityByItemOptLevel

refmagicoptbyitemoptleveldata.txt
Query : SELECT * FROM _RefMagicOptByItemOptLevel

refmagicoptgroup.txt
Query : SELECT * FROM _RefMagicOptGroup WHERE Service = 1

refmappingshopgroup.txt
Query : SELECT * FROM _RefMappingShopGroup WHERE Service = 1

refmappingshopwithtab.txt
Query : SELECT * FROM _RefMappingShopWithTab WHERE Service = 1

refoptionalteleport.txt
Query : SELECT * FROM _RefOptionalTeleport WHERE Service = 1

refpackageitem.txt
Query : SELECT * FROM _RefPackageItem WHERE Service = 1

refpricepolicyofitem.txt
Query : SELECT * FROM _RefPricePolicyOfItem WHERE Service = 1

refquestrewarditems.txt
Query : SELECT QuestID, QuestCodeName, RewardType, ItemCodeName, RentItemCodeName, OptionalItemCode, OptionalItemCnt, AchieveQuantity, Param1, Param1_Desc, Param2, Param2_Desc FROM _RefQuestRewardItems WHERE Service = 1

refqusetreward.txt
Query : SELECT QuestID, QuestCodeName, IsView, IsBasicReward, IsItemReward, IsCheckCondition, IsCheckCountry, SelectionCnt, IsCheckClass, IsCheckGender, Gold, Exp, SPExp, SP, AP, APType, Hwan, Inventory, ItemRewardType, Param1, Param1_Desc, Param2, Param2_Desc, Param3, Param3_Desc FROM _RefQuestReward WHERE Service = 1

refscrapofpackageitem.txt
Query : SELECT * FROM _RefScrapOfPackageItem WHERE Service = 1

refsetitemgroup.txt
Query : SELECT * FROM _RefSetItemGroup

refshop.txt
Query : SELECT * FROM _RefShop WHERE Service = 1

refshopgoods.txt
Query : SELECT * FROM _RefShopGoods WHERE Service = 1

refshopgroup.txt
Query : SELECT * FROM _RefShopGroup WHERE Service = 1

refshoptab.txt
Query : SELECT * FROM _RefShopTab WHERE Service = 1

refshoptabgroup.txt
Query : SELECT * FROM _RefShopTabGroup WHERE Service = 1

refsiegeblessbuff.txt
Query : SELECT * FROM _RefSiegeBlessBuff WHERE Service = 1

refsiegedungeon.txt
Query : SELECT * FROM _RefSiegeDungeon WHERE Service = 1

refskillbyitemoptleveldata.txt
Query : SELECT * FROM _RefSkillByItemOptLevel

shopgroupdata.txt
Query : SELECT * FROM _RefShopItemGroup WHERE Service = 1

siegefortress.txt
Query : SELECT * FROM _RefSiegeFortress WHERE Service = 1

siegefortressbattlerank.txt
Query : SELECT * FROM _RefSiegeFortressBattleRank WHERE Service = 1

siegefortressguard.txt
Query : SELECT * FROM _RefSiegeFortressGuard WHERE Service = 1

siegefortressitemforge.txt
Query : SELECT * FROM _RefSiegeFortressItemForge WHERE Service = 1

siegestructupgradedata.txt
Query : SELECT * FROM _RefSiegeStructUpgrade WHERE Service = 1

skilldata_5000.txt
Query : SELECT * FROM _RefSkill WHERE Service = 1 AND ID BETWEEN 0 AND 4999

skilldata_10000.txt
Query : SELECT * FROM _RefSkill WHERE Service = 1 AND ID BETWEEN 5000 AND 9999

skilldata_15000.txt
Query : SELECT * FROM _RefSkill WHERE Service = 1 AND ID BETWEEN 10000 AND 14999

skilldata_20000.txt
Query : SELECT * FROM _RefSkill WHERE Service = 1 AND ID BETWEEN 15000 AND 19999

skilldata_25000.txt
Query : SELECT * FROM _RefSkill WHERE Service = 1 AND ID BETWEEN 20000 AND 24999

skilldata_30000.txt
Query : SELECT * FROM _RefSkill WHERE Service = 1 AND ID BETWEEN 25000 AND 29999

skilldata_35000.txt
Query : SELECT * FROM _RefSkill WHERE Service = 1 AND ID >= 30000

teleportbuilding.txt
Query : SELECT * FROM _RefObjCommon WHERE TypeID1 = 4 and Service = 1

teleportdata.txt
Query : SELECT Service, ID, CodeName128, AssocRefObjID, ZoneName128, GenRegionID, GenPos_X, GenPos_Y, GenPos_Z, GenAreaRadius, CanBeResurrectPos, CanGotoResurrectPos, GenWorldID FROM _RefTeleport WHERE Service = 1

teleportlink.txt
Query : SELECT * FROM _RefTeleLink WHERE Service = 1