Query to get mob from DB to CLIENT .txt

**PX2000** · 13-04-12

Use SQL 2008 R2 Express

Code:

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 CodeName128 like 'MOB_%' and Service=1
                      Order by ID