كود PHP:
USE [SRO_FEIER_SHARDDB]
GO
/****** Object: StoredProcedure [dbo].[_TextData] Script Date: 18/10/2016 06:39:45 م ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE procedure [dbo].[_TextData]
as
select 'CharacterData.txt'
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 and Bionic = 1 and Service = 1 order by _RefObjCommon.ID
select 'ItemData.txt'
SELECT a.Service,a.ID,a.CodeName128,a.ObjName128,a.OrgObjCodeName128,a.NameStrID128,a.DescStrID128,a.CashItem,a.Bionic,a.TypeID1,a.TypeID2,a.TypeID3,a.TypeID4,a.DecayTime,a.Country,a.Rarity,a.CanTrade,a.CanSell,a.CanBuy,a.CanBorrow,a.CanDrop,a.CanPick,a.CanRepair,a.CanRevive,a.CanUse,a.CanThrow,a.Price,a.CostRepair,a.CostRevive,a.CostBorrow,a.KeepingFee,a.SellPrice,a.ReqLevelType1,a.ReqLevel1,a.ReqLevelType2,a.ReqLevel2,a.ReqLevelType3,a.ReqLevel3,a.ReqLevelType4,a.ReqLevel4,a.MaxContain,a.RegionID,a.Dir ,a.OffsetX,a.OffsetY,a.OffsetZ,a.Speed1,a.Speed2,a.Scale ,a.BCHeight,a.BCRadius,a.EventID,a.AssocFileObj128,a.AssocFileDrop128,a.AssocFileIcon128 ,a.AssocFile1_128,a.AssocFile2_128,b.MaxStack ,b.ReqGender,b.ReqStr,b.ReqInt,b.ItemClass,b.SetID,replace(convert(decimal(18,7), b.Dur_L),'0000000','0'),replace(convert(decimal(18,7), b.Dur_U),'0000000','0'),replace(convert(decimal(18,7), b.PD_L),'0000000','0'),replace(convert(decimal(18,7), b.PD_U),'0000000','0'),replace(convert(decimal(18,7), b.PDInc),'0000000','0') ,replace(convert(decimal(18,7), b.ER_L),'0000000','0') ,replace(convert(decimal(18,7), b.ER_U),'0000000','0'),replace(convert(decimal(18,7), b.ERInc),'0000000','0'),replace(convert(decimal(18,7), b.PAR_L),'0000000','0'),replace(convert(decimal(18,7), b.PAR_U),'0000000','0'),replace(convert(decimal(18,7), b.PARInc),'0000000','0'),replace(convert(decimal(18,7), b.BR_L),'0000000','0'),replace(convert(decimal(18,7), b.BR_U),'0000000','0'),replace(convert(decimal(18,7), b.MD_L),'0000000','0') ,replace(convert(decimal(18,7), b.MD_U),'0000000','0'),replace(convert(decimal(18,7), b.MDInc),'0000000','0'),replace(convert(decimal(18,7), b.MAR_L),'0000000','0'),replace(convert(decimal(18,7), b.MAR_U),'0000000','0'),replace(convert(decimal(18,7), b.MARInc),'0000000','0') ,replace(convert(decimal(18,7), b.PDStr_L),'0000000','0'),replace(convert(decimal(18,7), b.PDStr_U),'0000000','0') ,replace(convert(decimal(18,7), b.MDInt_L),'0000000','0') ,replace(convert(decimal(18,7), b.MDInt_U),'0000000','0'),b.Quivered,b.Ammo1_TID4,b.Ammo2_TID4 ,b.Ammo3_TID4,b.Ammo4_TID4,b.Ammo5_TID4,b.SpeedClass,b.TwoHanded,b.Range,replace(convert(decimal(18,7), b.PAttackMin_L),'0000000','0'),replace(convert(decimal(18,7), b.PAttackMin_U),'0000000','0'),replace(convert(decimal(18,7), b.PAttackMax_L),'0000000','0') ,replace(convert(decimal(18,7), b.PAttackMax_U),'0000000','0'),replace(convert(decimal(18,7), b.PAttackInc),'0000000','0'),replace(convert(decimal(18,7), b.MAttackMin_L),'0000000','0'),replace(convert(decimal(18,7), b.MAttackMin_U),'0000000','0'),replace(convert(decimal(18,7), b.MAttackMax_L),'0000000','0'),replace(convert(decimal(18,7), b.MAttackMax_U),'0000000','0'),replace(convert(decimal(18,7), b.MAttackInc),'0000000','0'),replace(convert(decimal(18,7), b.PAStrMin_L),'0000000','0'),replace(convert(decimal(18,7), b.PAStrMin_U),'0000000','0'),replace(convert(decimal(18,7), b.PAStrMax_L),'0000000','0'),replace(convert(decimal(18,7), b.PAStrMax_U),'0000000','0'),replace(convert(decimal(18,7), b.MAInt_Min_L),'0000000','0'),replace(convert(decimal(18,7), b.MAInt_Min_U),'0000000','0'),replace(convert(decimal(18,7), b.MAInt_Max_L),'0000000','0') ,replace(convert(decimal(18,7), b.MAInt_Max_U),'0000000','0') ,replace(convert(decimal(18,7), b.HR_L),'0000000','0') ,replace(convert(decimal(18,7), b.HR_U),'0000000','0') ,replace(convert(decimal(18,7), b.HRInc),'0000000','0'),replace(convert(decimal(18,7), b.CHR_L),'0000000','0'),replace(convert(decimal(18,7), b.CHR_U),'0000000','0'),b.Param1,b.Desc1_128,b.Param2,RTRIM(b.Desc2_128),b.Param3,b.Desc3_128,b.Param4,b.Desc4_128,b.Param5,b.Desc5_128,b.Param6,b.Desc6_128,b.Param7,b.Desc7_128,b.Param8,b.Desc8_128 ,b.Param9 ,b.Desc9_128,b.Param10,b.Desc10_128,b.Param11,b.Desc11_128,b.Param12,b.Desc12_128,b.Param13,b.Desc13_128,b.Param14,b.Desc14_128,b.Param15,b.Desc15_128,b.Param16,b.Desc16_128,b.Param17,b.Desc17_128,b.Param18,b.Desc18_128,b.Param19,b.Desc19_128,b.Param20 ,b.Desc20_128,b.MaxMagicOptCount,b.ChildItemCount FROM _RefObjCommon as a INNER JOIN _RefObjItem as b ON a.Link=b.ID and a.TypeID1 = 3and Service = 1 order by a.id
select 'SkillData.txt'
select * from _RefSkill
select 'TeleportBuilding.txt'
select Service,ID,CodeName128,ObjName128,OrgObjCodeName128,NameStrID128,DescStrID128,CashItem,Bionic,TypeID1,TypeID2,TypeID3,TypeID4,DecayTime,Country,Rarity,CanTrade,CanSell,CanBuy,CanBorrow,CanDrop,CanPick,CanRepair,CanRevive,CanUse,CanThrow,Price,CostRepair,CostRevive,CostBorrow,KeepingFee,SellPrice,ReqLevelType1,ReqLevel1,ReqLevelType2,ReqLevel2,ReqLevelType3,ReqLevel3,ReqLevelType4,ReqLevel4,MaxContain,RegionID,Dir,OffsetX,OffsetY,OffsetZ,Speed1,Speed2,Scale,BCHeight,BCRadius,EventID,AssocFileObj128,AssocFileDrop128,AssocFileIcon128,AssocFile1_128,AssocFile2_128,0 from _RefObjCommon where TypeID1=4 and Service = 1
select 'TeleportData.txt'
select Service,ID,rtrim(CodeName128),AssocRefObjID,ZoneName128,GenRegionID,GenPos_X,GenPos_Y,GenPos_Z,GenAreaRadius,CanBeResurrectPos,CanGotoResurrectPos,GenWorldID from _RefTeleport where Service = 1
select 'TeleportLink.txt'
select Service,OwnerTeleport,TargetTeleport,Fee,0,0,Restrict1,Data1_1,Data1_2,Restrict2,Data2_1,Data2_2,Restrict3,Data3_1,Data3_2,Restrict4,Data4_1,Data4_2,Restrict5,Data5_1,Data5_2 from _RefTeleLink where Service = 1
select 'RefShopGoods.txt'
select Service, Country, RefTabCodeName, RefPackageItemCodeName, SlotIndex, Param1, Param1_Desc128, Param2, Param2_Desc128, Param3, Param3_Desc128, Param4,Param4_Desc128 from _RefShopGoods where service = 1
select 'RefPricePolicyOfItem.txt'
select Service, Country, RefPackageItemCodeName,PaymentDevice,PreviousCost,Cost,Param1,Param1_Desc128,Param2,Param2_Desc128,Param3,Param3_Desc128,Param4,Param4_Desc128 from _Refpricepolicyofitem where service = 1
select 'RefScrapOfPackageItem.txt'
select Service, Country, RefPackageItemCodeName,RefItemCodeName,OptLevel,Variance,Data,MagParamNum,MagParam1,MagParam2,MagParam3,MagParam4,MagParam5,MagParam6,MagParam7,MagParam8,MagParam9,MagParam10,MagParam11,MagParam12,Param1,Param1_Desc128,Param2,Param2_Desc128,Param3,Param3_Desc128,Param4,Param4_Desc128,[Index] from _refscrapofpackageitem where service = 1
select 'RefPackageItem.txt'
select Service, Country, ID,CodeName128,SaleTag,ExpandTerm,NameStrID,DescStrID,AssocFileIcon,Param1,Param1_Desc128,Param2,Param2_Desc128,Param3,Param3_Desc128,Param4,Param4_Desc128 from _refpackageitem where service = 1
select 'RefShop.txt'
select Service, Country, ID,CodeName128,Param1,Param1_Desc128,Param2,Param2_Desc128,Param3,Param3_Desc128,Param4,Param4_Desc128 from _RefShop where service = 1
select 'RefShopTab.txt'
select Service, Country, ID,CodeName128,RefTabGroupCodeName,StrID128_Tab from _refshoptab where service = 1
select 'RefShopGroup.txt'
select Service, Country, ID,CodeName128,RefNPCCodeName,Param1,Param1_Desc128,Param2,Param2_Desc128,Param3,Param3_Desc128,Param4,Param4_Desc128 from _refshopgroup where service = 1
select 'RefShopTabGroup.txt'
select Service, Country, ID,CodeName128,StrID128_Group from _RefShopTabGroup where service = 1
select 'RefMappingShopGroup.txt'
select Service, Country, RefShopGroupCodeName,RefShopCodeName from _RefMappingShopGroup where service = 1
select 'RefMappingShopWithTab.txt'
select Service, Country, RefShopCodeName,RefTabGroupCodeName from _RefMappingShopWithTab where service = 1
select 'RefShopItemStockPeriod.txt'
select Service,Country,RefShopGroupCodeName,RefPackageItemCodeName,StockOpeningDate,StockExpireDate,PeriodDevice from _RefShopItemStockPeriod where service = 1
select 'GameWorldData.txt'
select ID,WorldCodeName128,Type,WorldMaxCount,WorldMaxUserCount,ConfigGroupCodeName128 from _RefGame_World
select 'GameWorldConfigData.txt'
select GroupCodeName128,ValueCodeName128,Type,Value from _RefGame_World_Config where service = 1 order by GroupCodeName128
select 'GroupWorld_Config_ForClient.txt'
select Service,ValueCodeName128,Value from _RefGameWorldGroup_Config where type = 'CLIENT_DATA' and service = 1
select 'GachaNpcMap.txt'
select * from _RefGachaNpcMap where service = 1
select 'GachaItemSet.txt'
select * from _RefGachaItemSet where service = 1
select 'HwanLevelData.txt'
select HwanLevel,Title_CH70,Title_EU70 from _RefHWANLevel
select 'MagicOption.txt'
select Service, ID, MOptName128, AttrType, MLevel, replace(cast(Prob as varchar(32)),',','.'), 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
select 'MagicOptionAssign.txt'
select * from _RefMagicOptAssign where service = 1
select 'RefMagicOptGroup.txt'
select * from _RefMagicOptGroup where Service=1
select 'NpcPos.txt'
select dwObjID, nRegionDbID,replace(convert(decimal(18,7), fLocalPosX),'0000000','0'),replace(convert(decimal(18,7), fLocalPosY),'0000000','0'),replace(convert(decimal(18,7), fLocalPosZ),'0000000','0') from Tab_RefNest inner join tab_reftactics on tab_refnest.dwtacticsid = tab_reftactics.dwtacticsid
select 'QuestData.txt'
select * from _RefQuest where service=1
select 'RefAbilityByItemOptLevelData.txt'
select * from _RefAbilityByItemOptLevel where service=1
select 'RefMagicOptByItemOptLevelData.txt'
select * from _RefMagicOptByItemOptLevel order by Link
select 'RefSkillByItemOptLevelData.txt'
select * from _RefSkillByItemOptLevel order by Link
select 'RefRegion.txt'
select * from _RefRegion
select 'RefServerEventID.txt'
select ID from _RefServerEvent where service = 1 order by ID desc
select 'RefSetItemGroup.txt'
select * from _RefSetItemGroup where service=1
select 'CollectionBook_Item.txt'
select a.Service,a.CodeName128,a.ObjName128,a.ThemeCodeName128,b.ID,a.SlotIndex,a.Story128,a.DDJFile128 from _RefCollectionBook_Item as a inner join _RefCollectionBook_Theme as b on a.ThemeCodeName128 = b.CodeName128
select 'CollectionBook_Theme.txt'
select * from _RefCollectionBook_Theme where Service=1
select 'RefOptionalTeleport.txt'
select * from _RefOptionalTeleport where service=1
select 'SiegeFortress.txt'
select * from _RefSiegeFortress where service=1
select 'SiegeFortressBattleRank.txt'
select * from _RefSiegeFortressBattleRank where service=1
select 'SiegeFortressGuard.txt'
select * from _RefSiegeFortressGuard where service=1
select 'SiegeFortressItemForge.txt'
select * from _RefSiegeFortressItemForge where service=1
select 'SiegeStructUpgradeData.txt'
select * from _RefSiegeStructUpgrade where service=1
select 'RefSiegeDungeon.txt'
select * from _RefSiegeDungeon where Service=1
select 'RefSiegeBlessBuff.txt'
select * from _RefSiegeBlessBuff where service=1
select 'SpecialNpcData.txt'
select id,codename128 from _RefObjCommon where codename128 like '%NPC_%_SPECIAL%' and service = 1 order by id
select 'LevelData.txt'
select * from _RefLevel
select 'dg.txt (drop gold)'
select MonLevel,GoldMin,GoldMax from _RefDropGold
select 'CharGrowData.txt'
select * from _RefObjCharGrow
select 'RefRegionBindOptionalFunction.txt'
select * from _RefRegionBindOptionalFunction
select 'RefReinforceLimitDegree.txt'
select (select CodeName128 from _RefObjCommon where ID = RefItemID), Degree from _RefReinforceLimitDegree
select 'RefRentItem.txt'
select * from _RefRentItem where service = 1
select 'RefRewardPolicyToBuyScrapItem.txt'
select * from _RefRewardPolicyToBuyScrapItem where service = 1
select 'RefRewardPolicyToSellPackageItem.txt'
select * from _RefRewardPolicyToSellPackageItem where service = 1
select 'RefRewardPolicyToSellScrapItem.txt'
select * from _RefRewardPolicyToSellScrapItem where service = 1
select 'RefTreatItemOfShop.txt'
select * from _RefTreatItemOfShop where Service = 1
select 'RefUpgradeEquipItem.txt'
select * from _RefUpgradeEquipItem where Service = 1
select 'EventData.txt'
select ID, CodeName, DescName from _RefEvent where Service = 1
select 'EventZoneData.txt'
select * from _RefEventZone where Service = 1
select 'MagicOptionAssignForTradeEquip.txt'
select* from _RefMagicOptAssignForTradeEquip where Service = 1
select 'RefAccessPermissionOfShop.txt'
select * from _RefAccessPermissionOfShop where Service = 1
select 'RefAlchemy_MK_MaterialGroup.txt'
select * from _RefAlchemy_MK_MaterialGroup where Service = 1
select 'RefAlchemy_MK_RecipeData.txt'
select * from _RefAlchemy_MK_Recipe where Service = 1
select 'RefAlchemy_MK_ToolTip.txt'
select * from _RefAlchemy_MK_ToolTip where Service = 1
select 'RefAlchemy_MK_UI.txt'
select * from _RefAlchemy_MK_UI where Service = 1
select 'RefAlchemy_MK_ResultGroup.txt'
select * from _RefAlchemy_MK_ResultGroup where Service = 1
select 'RefAlchemy_MK_RecipeShopData.txt'
select replace(Shop_CodeName, 'MK_','NPC_'), a.RC_ID, b.RC_CodeName128, b.Service, b.RC_ID, a.Cost, b.RC_StrID128 , 'UIIT_STT_ALCHEMY' from _RefAlchemy_MK_Shop as a, _RefAlchemy_MK_Recipe as b where a.Service = 1 and a.RC_ID = b.RC_ID
select 'RefCartCosInfo.txt'
select * from _RefCartCosInfo where Service = 1
select 'RefConditionToBuyScrapItem.txt'
select * from _RefConditionToBuyScrapItem where Service = 1
select 'RefConditionToSellPackageItem.txt'
select * from _RefConditionToSellPackageItem where Service = 1
select 'RefConditionToSellScrapItem.txt'
select * from _RefConditionToSellScrapItem where Service = 1
select 'RefEquipItemPenalty.txt'
select * from _RefEquipItemPenalty where Service = 1
select 'RefQusetReward.txt(inactive)'
select QuestID, QuestCodeName, IsView, IsBasicReward, IsItemReward, IsCheckCondition, IsCheckCountry, IsCheckClass, IsCheckGender, Gold, Exp, SPExp, SP, AP, APType, Hwan, Inventory, ItemRewardType, SelectionCnt, Param1, Param1_Desc, Param2, Param2_Desc, Param3, Param3_Desc from _RefQuestReward where Service = 1
select 'RefQuestRewardItems.txt'
select QuestID, QuestCodeName, RewardType, ItemCodeName, RentItemCodeName, OptionalItemCode, OptionalItemCnt, AchieveQuantity, IsPackageItem, MinLevel, MaxLevel from _RefQuestRewardItems where Service = 1
select 'RefItemUpgradeNReinforceRatio.txt'
select * from _RefItemUpgradeNReinforceRatio
select 'RefGift_ExchangeCoupon.txt'
select * from _RefGift_ExchangeCoupon
select 'RefGift_ExchangeItem.txt'
select * from _RefGift_ExchangeItem
select 'RefExtraAbilityByEquipItemOptLevel.txt'
select Service, RefItemID, OptLevel, replace(cast(Phy_Inc_Opt as varchar(32)),',','.'), replace(cast(Mgc_Inc_Opt as varchar(32)),',','.'), 0, MgcOptLevel1, MgcOptValue1, MgcOptID2, MgcOptLevel2, MgcOptValue2, MgcOptID3, MgcOptLevel3, MgcOptValue3, MgcOptID4, MgcOptLevel4, MgcOptValue4, MgcOptID5, MgcOptLevel5, MgcOptValue5, SkillID1, SkillID2, SkillID3, SkillID4, SkillID5 from _RefExtraAbilityByEquipItemOptLevel where Service = 1
select 'RefEventReward.txt'
select * from _RefEventReward where Service = 1
select 'RefEventRewardItems.txt'
select EventID, EventCodeName, ItemCodeName, PayCount, replace(cast(AchieveRatio as varchar(32)),',','.'), RentItemCodeName, IsPackageItem, MinLevel, MaxLevel, Param1, Param1_Desc, Param2, Param2_Desc from _RefEventRewardItems where Service = 1
GO
شـريـط الاهـداءات
18-10-2016, 07:48 PM
.gif){kind=icon}
العرض الشجري