UTC ITEM % Rosseta set

BizHerTrabzon61' Alıntı:

USE [kn_online]

GO



UPDATE [dbo].[ITEM]

SET [Num] = <Num, bigint,>

,[strName] = <strName, varchar(50),>

,[Kind] = <Kind, tinyint,>

,[Slot] = <Slot, tinyint,>

,[Race] = <Race, tinyint,>

,[Class] = <Class, tinyint,>

,[Damage] = <Damage, smallint,>

,[Delay] = <Delay, smallint,>

,[Range] = <Range, smallint,>

,[Weight] = <Weight, smallint,>

,[Duration] = <Duration, smallint,>

,[BuyPrice] = <BuyPrice, int,>

,[SellPrice] = <SellPrice, int,>

,[Ac] = <Ac, smallint,>

,[Countable] = <Countable, tinyint,>

,[Effect1] = <Effect1, int,>

,[Effect2] = <Effect2, int,>

,[ReqLevel] = <ReqLevel, tinyint,>

,[ReqLevelMax] = <ReqLevelMax, tinyint,>

,[ReqRank] = <ReqRank, tinyint,>

,[ReqTitle] = <ReqTitle, tinyint,>

,[ReqStr] = <ReqStr, tinyint,>

,[ReqSta] = <ReqSta, tinyint,>

,[ReqDex] = <ReqDex, tinyint,>

,[ReqIntel] = <ReqIntel, tinyint,>

,[ReqCha] = <ReqCha, tinyint,>

,[SellingGroup] = <SellingGroup, tinyint,>

,[ItemType] = <ItemType, tinyint,>

,[Hitrate] = <Hitrate, smallint,>

,[Evasionrate] = <Evasionrate, smallint,>

,[DaggerAc] = <DaggerAc, smallint,>

,[SwordAc] = <SwordAc, smallint,>

,[MaceAc] = <MaceAc, smallint,>

,[AxeAc] = <AxeAc, smallint,>

,[SpearAc] = <SpearAc, smallint,>

,[BowAc] = <BowAc, smallint,>

,[JamadarAc] = <JamadarAc, smallint,>

,[FireDamage] = <FireDamage, tinyint,>

,[IceDamage] = <IceDamage, tinyint,>

,[LightningDamage] = <LightningDamage, tinyint,>

,[PoisonDamage] = <PoisonDamage, tinyint,>

,[HPDrain] = <HPDrain, tinyint,>

,[MPDamage] = <MPDamage, tinyint,>

,[MPDrain] = <MPDrain, tinyint,>

,[MirrorDamage] = <MirrorDamage, tinyint,>

,[StrB] = <StrB, smallint,>

,[StaB] = <StaB, smallint,>

,[DexB] = <DexB, smallint,>

,[IntelB] = <IntelB, smallint,>

,[ChaB] = <ChaB, smallint,>

,[MaxHpB] = <MaxHpB, smallint,>

,[MaxMpB] = <MaxMpB, smallint,>

,[FireR] = <FireR, smallint,>

,[ColdR] = <ColdR, smallint,>

,[LightningR] = <LightningR, smallint,>

,[MagicR] = <MagicR, smallint,>

,[PoisonR] = <PoisonR, smallint,>

,[CurseR] = <CurseR, smallint,>

WHERE <Search Conditions,,>

GO



[Hidden content]

Genişletmek için tıkla ...

BizHerTrabzon61' Alıntı:

USE [kn_online]

GO



UPDATE [dbo].[ITEM]

SET [Num] = <Num, bigint,>

,[strName] = <strName, varchar(50),>

,[Kind] = <Kind, tinyint,>

,[Slot] = <Slot, tinyint,>

,[Race] = <Race, tinyint,>

,[Class] = <Class, tinyint,>

,[Damage] = <Damage, smallint,>

,[Delay] = <Delay, smallint,>

,[Range] = <Range, smallint,>

,[Weight] = <Weight, smallint,>

,[Duration] = <Duration, smallint,>

,[BuyPrice] = <BuyPrice, int,>

,[SellPrice] = <SellPrice, int,>

,[Ac] = <Ac, smallint,>

,[Countable] = <Countable, tinyint,>

,[Effect1] = <Effect1, int,>

,[Effect2] = <Effect2, int,>

,[ReqLevel] = <ReqLevel, tinyint,>

,[ReqLevelMax] = <ReqLevelMax, tinyint,>

,[ReqRank] = <ReqRank, tinyint,>

,[ReqTitle] = <ReqTitle, tinyint,>

,[ReqStr] = <ReqStr, tinyint,>

,[ReqSta] = <ReqSta, tinyint,>

,[ReqDex] = <ReqDex, tinyint,>

,[ReqIntel] = <ReqIntel, tinyint,>

,[ReqCha] = <ReqCha, tinyint,>

,[SellingGroup] = <SellingGroup, tinyint,>

,[ItemType] = <ItemType, tinyint,>

,[Hitrate] = <Hitrate, smallint,>

,[Evasionrate] = <Evasionrate, smallint,>

,[DaggerAc] = <DaggerAc, smallint,>

,[SwordAc] = <SwordAc, smallint,>

,[MaceAc] = <MaceAc, smallint,>

,[AxeAc] = <AxeAc, smallint,>

,[SpearAc] = <SpearAc, smallint,>

,[BowAc] = <BowAc, smallint,>

,[JamadarAc] = <JamadarAc, smallint,>

,[FireDamage] = <FireDamage, tinyint,>

,[IceDamage] = <IceDamage, tinyint,>

,[LightningDamage] = <LightningDamage, tinyint,>

,[PoisonDamage] = <PoisonDamage, tinyint,>

,[HPDrain] = <HPDrain, tinyint,>

,[MPDamage] = <MPDamage, tinyint,>

,[MPDrain] = <MPDrain, tinyint,>

,[MirrorDamage] = <MirrorDamage, tinyint,>

,[StrB] = <StrB, smallint,>

,[StaB] = <StaB, smallint,>

,[DexB] = <DexB, smallint,>

,[IntelB] = <IntelB, smallint,>

,[ChaB] = <ChaB, smallint,>

,[MaxHpB] = <MaxHpB, smallint,>

,[MaxMpB] = <MaxMpB, smallint,>

,[FireR] = <FireR, smallint,>

,[ColdR] = <ColdR, smallint,>

,[LightningR] = <LightningR, smallint,>

,[MagicR] = <MagicR, smallint,>

,[PoisonR] = <PoisonR, smallint,>

,[CurseR] = <CurseR, smallint,>

WHERE <Search Conditions,,>

GO



[Hidden content]

Genişletmek için tıkla ...