PVPKO 28 Aralık 2008 - 1299 Private Server Tanıtım,Database,Client ve Procedure Paylaşım Blogu
KnightOnline PVP Server Tanıtımı
Metin2 PVP Server Tanıtım

3 Ocak 2009 Cumartesi

90 LeveL Skillerini DB'nize Ekleyin

Aşağıdaki QA Kodu sayesinde DB'nize 90 LeveL skillerini ekleyebileceksiniz.. Ben aşağıdaki QA kodlarını Local'de denedim. Bir sorun olmadı fakat bütün skiller malesef çalışmıyor.. Denediğim skillerin adlarını ve classlarını yazayım;

  • Deadly Fire ( Mage Flame Skilli)
  • Frost Ball ( Mage Glacier Skilli)
  • Earth Therapy ( Priest Talisman Skill)
  • Eye's of God ( Rogue Explorer Skill olması lazım)
  • Warriorda Master 20 Skili.
Kod:
INSERT INTO MAGIC ( [MagicNum], [EnName], [KrName], [Description], [BeforeAction], [TargetAction], [SelfEffect], [FlyingEffect], [TargetEffect], [Moral], [SkillLevel], [Skill], [Msp], [HP], [ItemGroup], [UseItem], [CastTime], [ReCastTime], [SuccessRate], [Type1], [Type2], [Range], [Etc], [Event] ) VALUES ( 210574, 'È*ÀÌ¾î ¹ìÇǸ¯', 'Vampiric Fire', '[Knight]FALL DOWN FLAME ONE SPEAR SEND, AND, POISON POISON WITH HP FILL UP.', 0, 0, 0, 1, 141, 7, 80, 2105, 350, 0, 9, 0, 15, 255, 100, 3, 0, 25, 1, 0 );
INSERT INTO MAGIC ( [MagicNum], [EnName], [KrName], [Description], [BeforeAction], [TargetAction], [SelfEffect], [FlyingEffect], [TargetEffect], [Moral], [SkillLevel], [Skill], [Msp], [HP], [ItemGroup], [UseItem], [CastTime], [ReCastTime], [SuccessRate], [Type1], [Type2], [Range], [Etc], [Event] ) VALUES ( 208680, 'ºñ½ºÆ® ÇÏÀ̵ù', 'Beast Hiding', '[Knight]FALL DOWN %500 DAMAGE GIVE AND 5SECOND APPEAR PERFORM.', 0, 0, 0, 1, 10002, 7, 75, 2086, 250, 0, 1, 0, 0, 255, 0, 1, 9, 0, 1, 0 );
INSERT INTO MAGIC ( [MagicNum], [EnName], [KrName], [Description], [BeforeAction], [TargetAction], [SelfEffect], [FlyingEffect], [TargetEffect], [Moral], [SkillLevel], [Skill], [Msp], [HP], [ItemGroup], [UseItem], [CastTime], [ReCastTime], [SuccessRate], [Type1], [Type2], [Range], [Etc], [Event] ) VALUES ( 108680, 'ºñ½ºÆ® ÇÏÀ̵ù', 'Beast Hiding', '[Knight]FALL DOWN %500 DAMAGE GIVE AND 5 SECOND BECOME INVISIBLE ENSURE.', 0, 0, 0, 1, 10002, 7, 75, 1086, 250, 0, 1, 0, 0, 255, 0, 1, 9, 0, 1, 0 );
INSERT INTO MAGIC ( [MagicNum], [EnName], [KrName], [Description], [BeforeAction], [TargetAction], [SelfEffect], [FlyingEffect], [TargetEffect], [Moral], [SkillLevel], [Skill], [Msp], [HP], [ItemGroup], [UseItem], [CastTime], [ReCastTime], [SuccessRate], [Type1], [Type2], [Range], [Etc], [Event] ) VALUES ( 210554, 'ÆÄÀÌ¾î ½g', 'Fire Thorn', 'Lowers the enemys body temperature. It slows down your enemy for 20 seconds', 3, 0, 0, 1, 113, 7, 54, 2105, 220, 0, 9, 379069000, 15, 60, 30, 3, 0, 25, 1, 0 );
INSERT INTO MAGIC ( [MagicNum], [EnName], [KrName], [Description], [BeforeAction], [TargetAction], [SelfEffect], [FlyingEffect], [TargetEffect], [Moral], [SkillLevel], [Skill], [Msp], [HP], [ItemGroup], [UseItem], [CastTime], [ReCastTime], [SuccessRate], [Type1], [Type2], [Range], [Etc], [Event] ) VALUES ( 209554, 'ÆÄÀÌ¾î ½g', 'Fire Thorn', 'Inflict powerful flame damage with continuous damage which lasts temporarily.', 3, 0, 0, 1, 113, 7, 54, 2095, 220, 0, 9, 379069000, 15, 60, 30, 3, 0, 25, 1, 0 );
INSERT INTO MAGIC ( [MagicNum], [EnName], [KrName], [Description], [BeforeAction], [TargetAction], [SelfEffect], [FlyingEffect], [TargetEffect], [Moral], [SkillLevel], [Skill], [Msp], [HP], [ItemGroup], [UseItem], [CastTime], [ReCastTime], [SuccessRate], [Type1], [Type2], [Range], [Etc], [Event] ) VALUES ( 109554, 'ÆÄÀÌ¾î ½g', 'Fire Thorn', 'Inflict flame damage and absorb their HP. Absorbing HP is allowed on other players only.', 3, 0, 0, 1, 113, 7, 54, 1095, 220, 0, 9, 379069000, 15, 60, 30, 3, 0, 25, 1, 0 );
INSERT INTO MAGIC ( [MagicNum], [EnName], [KrName], [Description], [BeforeAction], [TargetAction], [SelfEffect], [FlyingEffect], [TargetEffect], [Moral], [SkillLevel], [Skill], [Msp], [HP], [ItemGroup], [UseItem], [CastTime], [ReCastTime], [SuccessRate], [Type1], [Type2], [Range], [Etc], [Event] ) VALUES ( 110554, 'ÆÄÀÌ¾î ½g', 'Fire Thorn', 'Inflict flame damage and absorb their HP. Absorbing HP is allowed on other players only.', 3, 0, 0, 1, 113, 7, 54, 1105, 220, 0, 9, 379069000, 15, 60, 30, 3, 0, 25, 1, 0 );
INSERT INTO MAGIC ( [MagicNum], [EnName], [KrName], [Description], [BeforeAction], [TargetAction], [SelfEffect], [FlyingEffect], [TargetEffect], [Moral], [SkillLevel], [Skill], [Msp], [HP], [ItemGroup], [UseItem], [CastTime], [ReCastTime], [SuccessRate], [Type1], [Type2], [Range], [Etc], [Event] ) VALUES ( 109554, 'ÆÄÀÌ¾î ½g', 'Fire Thorn', 'Inflict flame damage and absorb their HP. Absorbing HP is allowed on other players only.', 3, 0, 0, 1, 113, 7, 54, 1095, 220, 0, 9, 379069000, 15, 60, 30, 3, 0, 25, 1, 0 );
INSERT INTO MAGIC ( [MagicNum], [EnName], [KrName], [Description], [BeforeAction], [TargetAction], [SelfEffect], [FlyingEffect], [TargetEffect], [Moral], [SkillLevel], [Skill], [Msp], [HP], [ItemGroup], [UseItem], [CastTime], [ReCastTime], [SuccessRate], [Type1], [Type2], [Range], [Etc], [Event] ) VALUES ( 109554, 'ÆÄÀÌ¾î ½g', 'Fire Thorn', 'Inflict flame damage and absorb their HP. Absorbing HP is allowed on other players only.', 3, 0, 0, 1, 113, 7, 54, 1095, 220, 0, 9, 379069000, 15, 60, 30, 3, 0, 25, 1, 0 );
INSERT INTO MAGIC ( [MagicNum], [EnName], [KrName], [Description], [BeforeAction], [TargetAction], [SelfEffect], [FlyingEffect], [TargetEffect], [Moral], [SkillLevel], [Skill], [Msp], [HP], [ItemGroup], [UseItem], [CastTime], [ReCastTime], [SuccessRate], [Type1], [Type2], [Range], [Etc], [Event] ) VALUES ( 110561, 'Deadly Fire', 'Deadly Fire', '?????????', 3, 0, 0, 1, 113, 8, 69, 1105, 800, 0, 0, 0, 15, 180, 30, 3, 4, 60, 1, 0 );
INSERT INTO MAGIC ( [MagicNum], [EnName], [KrName], [Description], [BeforeAction], [TargetAction], [SelfEffect], [FlyingEffect], [TargetEffect], [Moral], [SkillLevel], [Skill], [Msp], [HP], [ItemGroup], [UseItem], [CastTime], [ReCastTime], [SuccessRate], [Type1], [Type2], [Range], [Etc], [Event] ) VALUES ( 210561, 'Deadly Fire', 'Deadly Fire', '?????????', 3, 0, 0, 1, 113, 8, 69, 2105, 800, 0, 0, 0, 15, 180, 30, 3, 4, 60, 1, 0 );
INSERT INTO MAGIC ( [MagicNum], [EnName], [KrName], [Description], [BeforeAction], [TargetAction], [SelfEffect], [FlyingEffect], [TargetEffect], [Moral], [SkillLevel], [Skill], [Msp], [HP], [ItemGroup], [UseItem], [CastTime], [ReCastTime], [SuccessRate], [Type1], [Type2], [Range], [Etc], [Event] ) VALUES ( 110569, 'Phoenix Fire', 'Phoenix Fire', '???????', 0, 0, 0, 1, 2901, 10, 69, 1105, 900, 0, 9, 0, 15, 153, 30, 3, 0, 25, 1, 0 );
INSERT INTO MAGIC ( [MagicNum], [EnName], [KrName], [Description], [BeforeAction], [TargetAction], [SelfEffect], [FlyingEffect], [TargetEffect], [Moral], [SkillLevel], [Skill], [Msp], [HP], [ItemGroup], [UseItem], [CastTime], [ReCastTime], [SuccessRate], [Type1], [Type2], [Range], [Etc], [Event] ) VALUES ( 210569, 'Phoenix Fire', 'Phoenix Fire', '????????', 0, 0, 0, 1, 2901, 10, 69, 2105, 900, 0, 9, 0, 15, 153, 30, 3, 0, 25, 1, 0 );
INSERT INTO MAGIC ( [MagicNum], [EnName], [KrName], [Description], [BeforeAction], [TargetAction], [SelfEffect], [FlyingEffect], [TargetEffect], [Moral], [SkillLevel], [Skill], [Msp], [HP], [ItemGroup], [UseItem], [CastTime], [ReCastTime], [SuccessRate], [Type1], [Type2], [Range], [Etc], [Event] ) VALUES ( 108673, 'Staggering Daggers', 'Fros', '????????', 0, 0, 0, 1, 213, 7, 71, 1086, 400, 0, 1, 0, 0, 52, 100, 1, 4, 0, 1, 0 );
INSERT INTO MAGIC ( [MagicNum], [EnName], [KrName], [Description], [BeforeAction], [TargetAction], [SelfEffect], [FlyingEffect], [TargetEffect], [Moral], [SkillLevel], [Skill], [Msp], [HP], [ItemGroup], [UseItem], [CastTime], [ReCastTime], [SuccessRate], [Type1], [Type2], [Range], [Etc], [Event] ) VALUES ( 208673, 'Staggering Daggers', 'Frost', '?????????', 0, 0, 0, 1, 213, 7, 71, 2086, 400, 0, 1, 0, 0, 52, 100, 1, 4, 0, 1, 0 );
INSERT INTO MAGIC ( [MagicNum], [EnName], [KrName], [Description], [BeforeAction], [TargetAction], [SelfEffect], [FlyingEffect], [TargetEffect], [Moral], [SkillLevel], [Skill], [Msp], [HP], [ItemGroup], [UseItem], [CastTime], [ReCastTime], [SuccessRate], [Type1], [Type2], [Range], [Etc], [Event] ) VALUES ( 108581, 'Fast Arrows', 'Fast Arrows', '??????????????', 0, 0, 0, 1, 10123, 1, 78, 1085, 300, 0, 9, 0, 0, 180, 100, 4, 0, 0, 1, 0 );
INSERT INTO MAGIC ( [MagicNum], [EnName], [KrName], [Description], [BeforeAction], [TargetAction], [SelfEffect], [FlyingEffect], [TargetEffect], [Moral], [SkillLevel], [Skill], [Msp], [HP], [ItemGroup], [UseItem], [CastTime], [ReCastTime], [SuccessRate], [Type1], [Type2], [Range], [Etc], [Event] ) VALUES ( 208581, 'Fast Arrows', 'Fast Arrows', '???????????????', 0, 0, 0, 1, 10123, 1, 78, 2085, 300, 0, 9, 0, 0, 180, 100, 4, 0, 0, 1, 0 );
INSERT INTO MAGIC ( [MagicNum], [EnName], [KrName], [Description], [BeforeAction], [TargetAction], [SelfEffect], [FlyingEffect], [TargetEffect], [Moral], [SkillLevel], [Skill], [Msp], [HP], [ItemGroup], [UseItem], [CastTime], [ReCastTime], [SuccessRate], [Type1], [Type2], [Range], [Etc], [Event] ) VALUES ( 106576, 'Ice Sword', 'Ice Sword', '?????????????', 0, 0, 0, 1, 10002, 8, 77, 1065, 400, 0, 0, 0, 0, 5, 100, 1, 0, 0, 1, 0 );
INSERT INTO MAGIC ( [MagicNum], [EnName], [KrName], [Description], [BeforeAction], [TargetAction], [SelfEffect], [FlyingEffect], [TargetEffect], [Moral], [SkillLevel], [Skill], [Msp], [HP], [ItemGroup], [UseItem], [CastTime], [ReCastTime], [SuccessRate], [Type1], [Type2], [Range], [Etc], [Event] ) VALUES ( 206576, 'Ice Sword', 'Ice Sword', '========', 0, 0, 0, 1, 10002, 8, 77, 1065, 400, 0, 0, 0, 0, 5, 100, 1, 0, 0, 1, 0 );
INSERT INTO MAGIC ( [MagicNum], [EnName], [KrName], [Description], [BeforeAction], [TargetAction], [SelfEffect], [FlyingEffect], [TargetEffect], [Moral], [SkillLevel], [Skill], [Msp], [HP], [ItemGroup], [UseItem], [CastTime], [ReCastTime], [SuccessRate], [Type1], [Type2], [Range], [Etc], [Event] ) VALUES ( 106822, 'Purificatory', 'Purificatory', 'Enemys', 0, 0, 0, 1, 702, 2, 20, 1068, 250, 0, 9, 0, 0, 255, 100, 5, 0, 25, 1, 0 );
INSERT INTO MAGIC ( [MagicNum], [EnName], [KrName], [Description], [BeforeAction], [TargetAction], [SelfEffect], [FlyingEffect], [TargetEffect], [Moral], [SkillLevel], [Skill], [Msp], [HP], [ItemGroup], [UseItem], [CastTime], [ReCastTime], [SuccessRate], [Type1], [Type2], [Range], [Etc], [Event] ) VALUES ( 206822, 'Purificatory', 'Purificatory', 'Enemys', 0, 0, 0, 1, 702, 2, 20, 1068, 250, 0, 9, 0, 0, 255, 100, 5, 0, 25, 1, 0 );
INSERT INTO MAGIC ( [MagicNum], [EnName], [KrName], [Description], [BeforeAction], [TargetAction], [SelfEffect], [FlyingEffect], [TargetEffect], [Moral], [SkillLevel], [Skill], [Msp], [HP], [ItemGroup], [UseItem], [CastTime], [ReCastTime], [SuccessRate], [Type1], [Type2], [Range], [Etc], [Event] ) VALUES ( 110669, 'Frost Ball', 'Frost Ball', 'xxx', 0, 0, 0, 1, 13004, 7, 69, 1106, 500, 0, 9, 0, 15, 203, 30, 3, 0, 30, 1, 0 );
INSERT INTO MAGIC ( [MagicNum], [EnName], [KrName], [Description], [BeforeAction], [TargetAction], [SelfEffect], [FlyingEffect], [TargetEffect], [Moral], [SkillLevel], [Skill], [Msp], [HP], [ItemGroup], [UseItem], [CastTime], [ReCastTime], [SuccessRate], [Type1], [Type2], [Range], [Etc], [Event] ) VALUES ( 210669, 'Frost Ball', 'Frost Ball', 'enemys', 0, 0, 0, 1, 13004, 7, 69, 1106, 500, 0, 9, 0, 15, 203, 30, 3, 0, 30, 1, 0 );
INSERT INTO MAGIC ( [MagicNum], [EnName], [KrName], [Description], [BeforeAction], [TargetAction], [SelfEffect], [FlyingEffect], [TargetEffect], [Moral], [SkillLevel], [Skill], [Msp], [HP], [ItemGroup], [UseItem], [CastTime], [ReCastTime], [SuccessRate], [Type1], [Type2], [Range], [Etc], [Event] ) VALUES ( 109649, 'Iliscet', '??? ??', '???? ??? ??? ?? ?????', 0, 0, 0, 0, 213, 7, 51, 1096, 160, 0, 9, 0, 15, 53, 30, 3, 4, 100, 1, 0 );
INSERT INTO MAGIC ( [MagicNum], [EnName], [KrName], [Description], [BeforeAction], [TargetAction], [SelfEffect], [FlyingEffect], [TargetEffect], [Moral], [SkillLevel], [Skill], [Msp], [HP], [ItemGroup], [UseItem], [CastTime], [ReCastTime], [SuccessRate], [Type1], [Type2], [Range], [Etc], [Event] ) VALUES ( 209649, 'Iliscet', '??? ??', '???? ??? ??? ?? ?????', 0, 0, 0, 0, 213, 7, 51, 2096, 160, 0, 9, 0, 15, 53, 30, 3, 4, 100, 1, 0 );
INSERT INTO MAGIC ( [MagicNum], [EnName], [KrName], [Description], [BeforeAction], [TargetAction], [SelfEffect], [FlyingEffect], [TargetEffect], [Moral], [SkillLevel], [Skill], [Msp], [HP], [ItemGroup], [UseItem], [CastTime], [ReCastTime], [SuccessRate], [Type1], [Type2], [Range], [Etc], [Event] ) VALUES ( 105533, 'Ice Berg', 'Ice Berg', '??? 250???? ??? 150 ???? ?? ???? ?? ?? ?????', 0, 0, 0, 0, 10002, 7, 33, 1055, 300, 0, 0, 0, 0, 5, 100, 1, 0, 0, 1, 0 );
INSERT INTO MAGIC ( [MagicNum], [EnName], [KrName], [Description], [BeforeAction], [TargetAction], [SelfEffect], [FlyingEffect], [TargetEffect], [Moral], [SkillLevel], [Skill], [Msp], [HP], [ItemGroup], [UseItem], [CastTime], [ReCastTime], [SuccessRate], [Type1], [Type2], [Range], [Etc], [Event] ) VALUES ( 205533, 'Ice Berg', 'Ice Berg', '??? 250???? ??? 150 ???? ?? ???? ?? ?? ?????', 0, 0, 0, 0, 10002, 7, 33, 2055, 300, 0, 0, 0, 0, 5, 100, 1, 0, 0, 1, 0 );
INSERT INTO MAGIC ( [MagicNum], [EnName], [KrName], [Description], [BeforeAction], [TargetAction], [SelfEffect], [FlyingEffect], [TargetEffect], [Moral], [SkillLevel], [Skill], [Msp], [HP], [ItemGroup], [UseItem], [CastTime], [ReCastTime], [SuccessRate], [Type1], [Type2], [Range], [Etc], [Event] ) VALUES ( 108822, 'Eyes of God', 'Eye''s of God', '????????', 0, 0, 0, 1, 0, 1, 20, 1088, 700, 0, 9, 0, 30, 60, 70, 9, 0, 100, 1, 0 );
INSERT INTO MAGIC ( [MagicNum], [EnName], [KrName], [Description], [BeforeAction], [TargetAction], [SelfEffect], [FlyingEffect], [TargetEffect], [Moral], [SkillLevel], [Skill], [Msp], [HP], [ItemGroup], [UseItem], [CastTime], [ReCastTime], [SuccessRate], [Type1], [Type2], [Range], [Etc], [Event] ) VALUES ( 208822, 'Eyes of God', 'Eye''s of God', '????????', 0, 0, 0, 1, 0, 1, 20, 2088, 700, 0, 9, 0, 30, 60, 70, 9, 0, 100, 1, 0 );
INSERT INTO MAGIC ( [MagicNum], [EnName], [KrName], [Description], [BeforeAction], [TargetAction], [SelfEffect], [FlyingEffect], [TargetEffect], [Moral], [SkillLevel], [Skill], [Msp], [HP], [ItemGroup], [UseItem], [CastTime], [ReCastTime], [SuccessRate], [Type1], [Type2], [Range], [Etc], [Event] ) VALUES ( 206559, 'Rexenor', 'Rexenor', '??? 300???? ??? 200 ???? ?? ???? ?? ?? ?????', 0, 0, 0, 0, 113, 7, 70, 1065, 400, 0, 0, 0, 0, 8, 100, 1, 0, 0, 1, 0 );
INSERT INTO MAGIC ( [MagicNum], [EnName], [KrName], [Description], [BeforeAction], [TargetAction], [SelfEffect], [FlyingEffect], [TargetEffect], [Moral], [SkillLevel], [Skill], [Msp], [HP], [ItemGroup], [UseItem], [CastTime], [ReCastTime], [SuccessRate], [Type1], [Type2], [Range], [Etc], [Event] ) VALUES ( 106559, 'Rexenor', 'Rexenor', '??? 300???? ??? 200 ???? ?? ???? ?? ?? ?????', 0, 0, 0, 0, 113, 7, 70, 1065, 400, 0, 0, 0, 0, 8, 100, 1, 0, 0, 1, 0 );


INSERT INTO MAGIC_TYPE3 ( [iNum], [Name], [Description], [Radius], [Angle], [DirectType], [FirstDamage], [EndDamage], [TimeDamage], [Duration], [Attribute] ) VALUES ( 109554, 'ttt', 'ttt', 0, 0, 8, -1550, 0, 0, 0, 1 );
INSERT INTO MAGIC_TYPE3 ( [iNum], [Name], [Description], [Radius], [Angle], [DirectType], [FirstDamage], [EndDamage], [TimeDamage], [Duration], [Attribute] ) VALUES ( 110554, 'ttt', 'ttt', 0, 0, 8, -1550, 0, 0, 0, 1 );
INSERT INTO MAGIC_TYPE3 ( [iNum], [Name], [Description], [Radius], [Angle], [DirectType], [FirstDamage], [EndDamage], [TimeDamage], [Duration], [Attribute] ) VALUES ( 209554, 'ttt', 'ttt', 0, 0, 8, -1550, 0, 0, 0, 1 );
INSERT INTO MAGIC_TYPE3 ( [iNum], [Name], [Description], [Radius], [Angle], [DirectType], [FirstDamage], [EndDamage], [TimeDamage], [Duration], [Attribute] ) VALUES ( 210554, 'ttt', 'ttt', 0, 0, 8, -1550, 0, 0, 0, 1 );


INSERT INTO MAGIC_TYPE3 ( [iNum], [Name], [Description], [Radius], [Angle], [DirectType], [FirstDamage], [EndDamage], [TimeDamage], [Duration], [Attribute] ) VALUES ( 210574, 'ttt', 'ttt', 0, 0, 8, -5000, 0, -8000, 20, 1 );
INSERT INTO MAGIC_TYPE3 ( [iNum], [Name], [Description], [Radius], [Angle], [DirectType], [FirstDamage], [EndDamage], [TimeDamage], [Duration], [Attribute] ) VALUES ( 110576, 'Deadly Fire', 'Deadly Fire', 0, 0, 1, -2000, 0, 0, 0, 1 );
INSERT INTO MAGIC_TYPE3 ( [iNum], [Name], [Description], [Radius], [Angle], [DirectType], [FirstDamage], [EndDamage], [TimeDamage], [Duration], [Attribute] ) VALUES ( 110576, 'Deadly Fire', 'Deadly Fire', 0, 0, 1, -2000, 0, 0, 0, 1 );
INSERT INTO MAGIC_TYPE3 ( [iNum], [Name], [Description], [Radius], [Angle], [DirectType], [FirstDamage], [EndDamage], [TimeDamage], [Duration], [Attribute] ) VALUES ( 210561, 'Deadly Fire', 'Deadly Fire', 0, 0, 1, -2000, 0, 0, 0, 1 );
INSERT INTO MAGIC_TYPE3 ( [iNum], [Name], [Description], [Radius], [Angle], [DirectType], [FirstDamage], [EndDamage], [TimeDamage], [Duration], [Attribute] ) VALUES ( 110561, 'Deadly Fire', 'Deadly Fire', 0, 0, 1, -2000, 0, 0, 0, 1 );
INSERT INTO MAGIC_TYPE3 ( [iNum], [Name], [Description], [Radius], [Angle], [DirectType], [FirstDamage], [EndDamage], [TimeDamage], [Duration], [Attribute] ) VALUES ( 110569, 'Phoenix Fire', 'Phoenix Fire', 15, 0, 1, -3000, 0, 0, 0, 1 );
INSERT INTO MAGIC_TYPE3 ( [iNum], [Name], [Description], [Radius], [Angle], [DirectType], [FirstDamage], [EndDamage], [TimeDamage], [Duration], [Attribute] ) VALUES ( 210569, 'Phoenix Fire', 'Phoenix Fire', 15, 0, 1, -3000, 0, 0, 0, 1 );
INSERT INTO MAGIC_TYPE3 ( [iNum], [Name], [Description], [Radius], [Angle], [DirectType], [FirstDamage], [EndDamage], [TimeDamage], [Duration], [Attribute] ) VALUES ( 110669, 'Frost Ball', 'Frost Ball', 0, 0, 1, -3000, 0, 0, 0, 1 );
INSERT INTO MAGIC_TYPE3 ( [iNum], [Name], [Description], [Radius], [Angle], [DirectType], [FirstDamage], [EndDamage], [TimeDamage], [Duration], [Attribute] ) VALUES ( 210669, 'Frost Ball', 'Frost Ball', 0, 0, 1, -3000, 0, 0, 0, 1 );




INSERT INTO MAGIC_TYPE3 ( [iNum], [Name], [Description], [Radius], [Angle], [DirectType], [FirstDamage], [EndDamage], [TimeDamage], [Duration], [Attribute] ) VALUES ( 109649, 'Ilisket', '???? ??? ??? ?? ?????', 0, 0, 1, -2000, 0, 0, 0, 2 );
INSERT INTO MAGIC_TYPE3 ( [iNum], [Name], [Description], [Radius], [Angle], [DirectType], [FirstDamage], [EndDamage], [TimeDamage], [Duration], [Attribute] ) VALUES ( 209649, 'Ilisket', '???? ??? ??? ?? ?????', 0, 0, 1, -2000, 0, 0, 0, 2 );



INSERT INTO MAGIC_TYPE9 ( [iNum], [Name], [Description], [ValidGroup], [NationChange], [MonsterNum], [TargetChange], [StateChange], [Radius], [Hitrate], [Duration], [AddDamage], [Vision], [NeedItem] ) VALUES ( 108680, 'ºñ½ºÆ® ÇÏÀ̵ù', 'Àû¿¡°Ô 300%ÀÇ ÇÇÇظ¦ ÁÖ¸ç 5ÃÊ°£ ÀÚ½ÅÀ» Åõ¸í»óÅ·Π¸¸µé¾î ÁI´Ï´Ù.', 0, 0, 0, 1, 2, 0, 100, 5, 0, 100, 0 );
INSERT INTO MAGIC_TYPE9 ( [iNum], [Name], [Description], [ValidGroup], [NationChange], [MonsterNum], [TargetChange], [StateChange], [Radius], [Hitrate], [Duration], [AddDamage], [Vision], [NeedItem] ) VALUES ( 208680, 'ºñ½ºÆ® ÇÏÀ̵ù', 'Àû¿¡°Ô 300%ÀÇ ÇÇÇظ¦ ÁÖ¸ç 5ÃÊ°£ ÀÚ½ÅÀ» Åõ¸í»óÅ·Π¸¸µé¾î ÁI´Ï´Ù.', 0, 0, 0, 1, 2, 0, 100, 5, 0, 100, 0 );


INSERT INTO MAGIC_TYPE1 ( [iNum], [Name], [Description], [Type], [HitRate], [Hit], [AddDamage], [Delay], [ComboType], [ComboCount], [ComboDamage], [Range] ) VALUES ( 108673, 'Freezing Daggers', 'Z', 0, 100, 400, 1000, 0, 0, 1, 0, 0 );
INSERT INTO MAGIC_TYPE1 ( [iNum], [Name], [Description], [Type], [HitRate], [Hit], [AddDamage], [Delay], [ComboType], [ComboCount], [ComboDamage], [Range] ) VALUES ( 208673, 'Freezing Daggers', 'X', 0, 100, 400, 1000, 0, 0, 1, 0, 0 );
INSERT INTO MAGIC_TYPE1 ( [iNum], [Name], [Description], [Type], [HitRate], [Hit], [AddDamage], [Delay], [ComboType], [ComboCount], [ComboDamage], [Range] ) VALUES ( 105533, 'Ice Berg', 'Ice Berg', 0, 100, 250, 150, 100, 0, 1, 0, 0 );
INSERT INTO MAGIC_TYPE1 ( [iNum], [Name], [Description], [Type], [HitRate], [Hit], [AddDamage], [Delay], [ComboType], [ComboCount], [ComboDamage], [Range] ) VALUES ( 205533, 'Ice Berg', 'Ice Berg', 0, 100, 250, 150, 100, 0, 1, 0, 0 );
INSERT INTO MAGIC_TYPE1 ( [iNum], [Name], [Description], [Type], [HitRate], [Hit], [AddDamage], [Delay], [ComboType], [ComboCount], [ComboDamage], [Range] ) VALUES ( 206559, 'Rexenor', 'Rexenor', 1, 100, 250, 0, 100, 0, 1, 0, 0 );
INSERT INTO MAGIC_TYPE1 ( [iNum], [Name], [Description], [Type], [HitRate], [Hit], [AddDamage], [Delay], [ComboType], [ComboCount], [ComboDamage], [Range] ) VALUES ( 106559, 'Rexenor', 'Rexenor', 1, 100, 250, 0, 100, 0, 1, 0, 0 );

INSERT INTO MAGIC_TYPE4 ( [iNum], [Name], [Description], [BuffType], [Radius], [Duration], [AttackSpeed], [Speed], [AC], [ACPct], [Attack], [MagicAttack], [MaxHP], [MaxHpPct], [MaxMP], [MaxMpPct], [HitRate], [AvoidRate], [Str], [Sta], [Dex], [Intel], [Cha], [FireR], [ColdR], [LightningR], [MagicR], [DiseaseR], [PoisonR], [ExpPct] ) VALUES ( 108581, 'Fast arrows', 'Fast Arrows', 5, 0, 10, 190, 100, 0, 100, 100, 100, 0, 100, 0, 100, 100, 100, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 );
INSERT INTO MAGIC_TYPE4 ( [iNum], [Name], [Description], [BuffType], [Radius], [Duration], [AttackSpeed], [Speed], [AC], [ACPct], [Attack], [MagicAttack], [MaxHP], [MaxHpPct], [MaxMP], [MaxMpPct], [HitRate], [AvoidRate], [Str], [Sta], [Dex], [Intel], [Cha], [FireR], [ColdR], [LightningR], [MagicR], [DiseaseR], [PoisonR], [ExpPct] ) VALUES ( 208581, 'Fast Arrows', 'Fast arrows', 5, 0, 10, 190, 100, 0, 100, 100, 100, 0, 100, 0, 100, 100, 100, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 );

INSERT INTO MAGIC_TYPE5 ( [iNum], [Name], [Description], [Type], [ExpRecover], [NeedStone] ) VALUES ( 206822, 'Purificatory', 'WAS', 2, 0, 0 );
INSERT INTO MAGIC_TYPE5 ( [iNum], [Name], [Description], [Type], [ExpRecover], [NeedStone] ) VALUES ( 106822, 'Purificatory', 'WASS', 2, 0, 0 );

Buradan Kodu Not Defteri İçinde İndirebilirsiniz.



Buradan Gerekli oLan Patch İndirebilirsiniz.


90 LeveL Skilleri


Jedi & Storm NT - NC Editör

Name Change - Nation Transfer editörü Jedi ve Storm tarafından yapılmıştır.. Gayet güzel bir tasarıma sahiptir..

Özellikleri:
  • Uzak ve Local Bağlantısı Mevcuttur.
  • Prosedürleri otomatik olarak ekleyebiliyorsunuz.. ( Eğer DB'nizde prosedür mevcut ise kendisiyle değiştiriyor)
  • Editörün en aşağısındaki N.Transfer ve N.Change kısımdan işlerinizi halledebilirsiniz.

Buradan Jedi & Storm NT - NC Editör'ü İndirebilirsiniz.




İtem Editör

Özellikleri:

  • Local / Uzak Bağlantı
  • İtem Ekleme / Editleme / Silme
  • DB'nizdeki mevcut itemlerin Q.A kodlarını çıkarabilme
NOT: Uzak bağlantı kurabilmek için 1433 portu açık olması gerekir.


Buradan İtem Editör'ü İndirebilirsiniz.



İtem Editör styLemert Tarafından yazılmıştır.


1 Ocak 2009 Perşembe

Exceptional İtemleri DB'nize Ekleyin

Aşağıdaki Kodları Query Analyzer'a Kopyalayın ve F5 yaptığınız zaman DB'nize Exceptional Itemleri eklemiş olacaksınız.










Kodu Not Defterinde İndirmek için Tıklayınız..





31 Aralık 2008 Çarşamba

Usko Görev Takıları ve Bazı İtemleri DB'e Ekle

Kullanımı ;
Q.A kodlarını db'ye girmeniz yeterli olacaktır. Genelde bütün datalarda eklidir.

İtem Kodları;
Kod:
910153111 Mage Earring
910154112 Mercenary Earring
910155113 Assassin Earring
910156114 Priest Earring

910157137 Mercenary Pendant
910158138 Messenger Pendant
910159139 Cleric Pendant

910160118 Body Belt

910161271 Messenger Ring
910162272 Mercenary Ring
910163273 Assassin Ring
910164274 Priest Ring
Kod:
insert into [ITEM] Values (910153000,'Mage Earring',91,10,0,6,0,100,0,0,1,640,0,0,0,0,0,60,99,0,0,0,0,0,0,0,0,4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,4,0,0,3,10,40,5,5,5,5,5,5)
insert into [ITEM] Values (910154000,'Mercenary Earring',91,10,0,6,0,100,0,0,1,640,0,0,0,0,0,60,99,0,0,0,0,0,0,0,0,4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,4,3,0,0,0,40,0,3,3,3,3,3,3)
insert into [ITEM] Values (910155000,'Assassin Earring',91,10,0,6,0,100,0,0,1,640,0,0,0,0,0,60,99,0,0,0,0,0,0,0,0,4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,3,4,0,0,30,10,7,7,7,7,7,7)
insert into [ITEM] Values (910156000,'Priest Earring',91,10,0,6,0,100,0,0,1,640,0,0,0,0,0,60,99,0,0,0,0,0,0,0,0,4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,4,0,3,0,25,20,3,3,3,3,3,3)
insert into [ITEM] Values (910164000,'Priest Ring',93,12,0,0,0,100,0,0,1,640,0,5,0,0,0,1,99,0,0,0,0,0,0,0,103,4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,5,0,0,4,0,45,40,3,3,3,3,3,3)
insert into [ITEM] Values (910163000,'Assassin Ring',93,12,0,0,0,100,0,0,1,640,0,5,0,0,0,1,99,0,0,0,0,0,0,0,103,4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,4,5,0,0,50,30,4,4,4,4,4,4)
insert into [ITEM] Values (910161000,'Messenger Ring',93,12,0,0,0,100,0,0,1,640,0,5,0,0,0,1,99,0,0,0,0,0,0,0,103,4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,5,0,0,4,35,50,3,3,3,3,3,3)
insert into [ITEM] Values (910162000,'Mercenary Ring',93,12,0,0,0,100,0,0,1,640,0,5,0,0,0,1,99,0,0,0,0,0,0,0,103,4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,5,4,0,0,0,70,0,2,2,2,2,2,2)
insert into [ITEM] Values (910157000,'Mercenary Pendant',92,11,0,0,0,100,0,0,1,640,0,7,0,0,0,1,99,0,0,0,0,0,0,0,0,4,50,0,5,0,5,0,5,0,0,0,0,0,0,0,0,0,0,4,3,4,0,0,80,20,0,0,0,0,0,0)
insert into [ITEM] Values (910158000,'Messenger Pendant',92,11,0,0,0,100,0,0,1,640,0,7,0,0,0,1,99,0,0,0,0,0,0,0,0,4,50,0,5,0,5,0,5,0,0,0,0,0,0,0,0,0,0,0,4,0,3,3,60,40,3,3,3,3,3,3)
insert into [ITEM] Values (910159000,'Cleric Pendant',92,11,0,0,0,100,0,0,1,640,0,7,0,0,0,1,99,0,0,0,0,0,0,0,0,4,50,0,5,0,5,0,5,0,0,0,0,0,0,0,0,0,0,3,4,0,3,0,50,50,2,2,2,2,2,2)
insert into [ITEM] Values (910160000,'Body Belt',94,14,0,0,0,100,0,0,1,640,0,0,0,0,0,1,99,0,0,0,0,0,0,0,0,4,10,15,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,6,0,0,0,50,0,0,0,0,0,0,0)

insert into [ITEM] Values (910153111,'Mage Earring',91,10,0,6,0,100,0,0,1,640,0,0,0,0,0,60,99,0,0,0,0,0,0,0,0,4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,4,0,0,3,10,40,5,5,5,5,5,5)
insert into [ITEM] Values (910154112,'Mercenary Earring',91,10,0,6,0,100,0,0,1,640,0,0,0,0,0,60,99,0,0,0,0,0,0,0,0,4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,4,3,0,0,0,40,0,3,3,3,3,3,3)
insert into [ITEM] Values (910155113,'Assassin Earring',91,10,0,6,0,100,0,0,1,640,0,0,0,0,0,60,99,0,0,0,0,0,0,0,0,4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,3,4,0,0,30,10,7,7,7,7,7,7)
insert into [ITEM] Values (910156114,'Priest Earring',91,10,0,6,0,100,0,0,1,640,0,0,0,0,0,60,99,0,0,0,0,0,0,0,0,4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,4,0,3,0,25,20,3,3,3,3,3,3)
insert into [ITEM] Values (910164274,'Priest Ring',93,12,0,0,0,100,0,0,1,640,0,5,0,0,0,1,99,0,0,0,0,0,0,0,103,4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,5,0,0,4,0,45,40,3,3,3,3,3,3)
insert into [ITEM] Values (910163273,'Assassin Ring',93,12,0,0,0,100,0,0,1,640,0,5,0,0,0,1,99,0,0,0,0,0,0,0,103,4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,4,5,0,0,50,30,4,4,4,4,4,4)
insert into [ITEM] Values (910161271,'Messenger Ring',93,12,0,0,0,100,0,0,1,640,0,5,0,0,0,1,99,0,0,0,0,0,0,0,103,4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,5,0,0,4,35,50,3,3,3,3,3,3)
insert into [ITEM] Values (910162272,'Mercenary Ring',93,12,0,0,0,100,0,0,1,640,0,5,0,0,0,1,99,0,0,0,0,0,0,0,103,4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,5,4,0,0,0,70,0,2,2,2,2,2,2)
insert into [ITEM] Values (910157137,'Mercenary Pendant',92,11,0,0,0,100,0,0,1,640,0,7,0,0,0,1,99,0,0,0,0,0,0,0,0,4,50,0,5,0,5,0,5,0,0,0,0,0,0,0,0,0,0,4,3,4,0,0,80,20,0,0,0,0,0,0)
insert into [ITEM] Values (910158138,'Messenger Pendant',92,11,0,0,0,100,0,0,1,640,0,7,0,0,0,1,99,0,0,0,0,0,0,0,0,4,50,0,5,0,5,0,5,0,0,0,0,0,0,0,0,0,0,0,4,0,3,3,60,40,3,3,3,3,3,3)
insert into [ITEM] Values (910159139,'Cleric Pendant',92,11,0,0,0,100,0,0,1,640,0,7,0,0,0,1,99,0,0,0,0,0,0,0,0,4,50,0,5,0,5,0,5,0,0,0,0,0,0,0,0,0,0,3,4,0,3,0,50,50,2,2,2,2,2,2)
insert into [ITEM] Values (910160118,'Body Belt',94,14,0,0,0,100,0,0,1,640,0,0,0,0,0,1,99,0,0,0,0,0,0,0,0,4,10,15,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,6,0,0,0,50,0,0,0,0,0,0,0)

Insert into [ITEM] values (379015000,'Bezoar of Glyptodont',97,17,0,0,0,0,0,0,1,600000,0,0,1,0,0,1,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
Insert into [ITEM] values (379007000,'Tooth of Smilodon',97,17,0,0,0,0,0,0,1,600000,0,0,1,0,0,1,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
Insert into [ITEM] values (379008000,'Claw of Stegodon',97,17,0,0,0,0,0,0,1,600000,0,0,1,0,0,1,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
Insert into [ITEM] values (379009000,'Heart of Haunga',97,17,0,0,0,0,0,0,1,600000,0,0,1,0,0,1,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
Insert into [ITEM] values (379010000,'Gavolt scales',97,17,0,0,0,0,0,0,1,600000,0,0,1,0,0,1,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
Insert into [ITEM] values (379254000,'Wolf Hide',97,17,0,0,0,0,0,0,1,600000,0,0,1,0,0,1,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
Insert into [ITEM] values (910165000,'Wolfman',97,17,0,0,0,0,0,0,1,600000,0,0,1,0,0,1,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
Insert into [ITEM] values (389251000,'Arcas',97,17,0,0,0,0,0,0,1,600000,0,0,1,0,0,1,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
Insert into [ITEM] values (389252000,'Virgo',97,17,0,0,0,0,0,0,1,600000,0,0,1,0,0,1,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
Insert into [ITEM] values (389253000,'Libra',97,17,0,0,0,0,0,0,1,600000,0,0,1,0,0,1,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
Insert into [ITEM] values (389254000,'Canes Venatici',97,17,0,0,0,0,0,0,1,600000,0,0,1,0,0,1,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
Insert into [ITEM] values (389255000,'Leo',97,17,0,0,0,0,0,0,1,600000,0,0,1,0,0,1,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
Insert into [ITEM] values (389256000,'hydra',97,17,0,0,0,0,0,0,1,600000,0,0,1,0,0,1,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
Insert into [ITEM] values (379253000,'Skeleton',97,17,0,0,0,0,0,0,1,600000,0,0,1,0,0,1,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
Insert into [ITEM] values (379045000,'Cursed Bone',97,17,0,0,0,0,0,0,1,600000,0,0,1,0,0,1,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
Insert into [ITEM] values (379251000,'Kekoon gallbladder',97,17,0,0,0,0,0,0,1,600000,0,0,1,0,0,1,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
Insert into [ITEM] values (379252000,'Black silk spool',97,17,0,0,0,0,0,0,1,600000,0,0,1,0,0,1,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
Insert into [ITEM] values (910118000,'Kekoon Armor',97,17,0,0,0,0,0,0,1,600000,0,0,1,0,0,1,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
Insert into [ITEM] values (379013000,'Mythril vessel',97,17,0,0,0,0,0,0,1,600000,0,0,1,0,0,1,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
Insert into [ITEM] values (389522000,'Golden Star Ornament',97,17,0,0,0,0,0,0,1,600000,0,0,1,0,0,1,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
Insert into [ITEM] values (389523000,'Red Bow Ornament',97,17,0,0,0,0,0,0,1,600000,0,0,1,0,0,1,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
Insert into [ITEM] values (389524000,'Tinsel Ornament',97,17,0,0,0,0,0,0,1,600000,0,0,1,0,0,1,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
Insert into [ITEM] values (379270000,'Smirdon Meat',97,17,0,0,0,0,0,0,1,600000,0,0,1,0,0,1,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
Insert into [ITEM] values (379271000,'Smirdon Hide',97,17,0,0,0,0,0,0,1,600000,0,0,1,0,0,1,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
Insert into [ITEM] values (379272000,'Silver Feather',97,17,0,0,0,0,0,0,1,600000,0,0,1,0,0,1,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
Insert into [ITEM] values (379273000,'Animal Blood',97,17,0,0,0,0,0,0,1,600000,0,0,1,0,0,1,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
Insert into [ITEM] values (379275000,'Coarse Ground Bone',97,17,0,0,0,0,0,0,1,600000,0,0,1,0,0,1,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
Insert into [ITEM] values (379276000,'Oath of Darkness',97,17,0,0,0,0,0,0,1,600000,0,0,1,0,0,1,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)

Buradan Kodları Not Defteri İçinde İndirebilirsiniz.



Kodlar styLemert'den aLıntıdır.

DB'nize Mega Atross Ekleyin.

Mega Atross;
  • 990k hp si var.
  • Kesildiği taktirde 5k np veriyor.
  • Atack yapmıyor.
  • Boyutuda gayet küçük
Mega Atross'u DB'e eklemek için aşağıdaki kodu K_MONSTER tablesine ekleyiniz.


Kod:
8765 Mega Atross 1410 5 0 0 0 1 3 14 0 0 0 50 375000 5000 990000 10000 0 1224 261 649 2700 3000 2 9 5000 300104 300105 0 500 500 500 500 500 500 500 200 30 10 45 279618 1402 2 5 0  
Mega Atross'u çıkarmak için +monsummon 8765






29 Aralık 2008 Pazartesi

Hazır Odbc ve İniler + Kullanımı ve Resimli Anlatım

Öncelikle Aşağıdaki Linkten Hazır Odbc ve inileri indirin.

Hazır Odbc ve İNİler.. ( Pot Silinmesi Sorunu Giderildi)
Rar PaSS: privateserverlar.blogspot.com


NOT: Bu Odbc ve iniler DB ismi kn_online oLarak Hazırlanmıştır..


İndirdiğiniz dosyaları rar'dan çıkartınız.. Çıkardıktan Sonra " Oto Odbc " Dosyası içindeki regedit dosyasına 2 kere tıklayın ve karşınıza gelen ekranda tamam deyiniz.

Tamam dedikten sonra Başlat > Denetim MAsası > Yönetimsel Araçlar > Veri Kaynakları (ODBC) 'a giriyoruz..

Girdikten sonra yukarıdaki sekmelerden " SİSTEM DNS " yi seçiyoruz. Seçtikten sonra alttaki alanda;
  • data
  • Kdata
  • KN_Data
  • kn_online
  • Knight
  • Knight_Account
  • Knight_Data
  • LocalServer
  • Sknight
oLacaktır.. Bunlar var ise doğru yapmışız demektir.. Geriye sadece yapılandır diyerek kendi serverımıza göre uyarlayacağız.. Ben bir tanesini örnek olarak yapacağım diğerlerini siz uyarlarsınız...






28 Aralık 2008 Pazar

Usko'daki Yeni İtemleri DB'nize Ekleme + Resimli Anlatım

Öncelikle Buradan gerekli olan " Data " ve "Query Analyzer Kodlarını" aLıyoruz.

Serverımız Kapalı iken;

Başlat > Tüm Programlar > Microsoft SQL Server > Query Analyzer'ı çalıştırıyoruz..


Query Analyzer'dan DB'mizi Seçiyoruz..


Başta Almış olduğumuz Query Analyzer Kodlarını Buraya Kopyalıyoruz ve F5 'e basıyoruz..


Mesaj bölümünde çıkan yazılar bize işin bittiğini haber veriyor..

Bitirdikten Sonra Herhangi bir inventory editör iLe itemleri karakterinize verebilirsiniz.


Diğer İtemleri Aşağıdaki Resimlerden Görebilirsiniz.


Usko'daki Tüm Yeni İtemler
YASAL UYARI !! Sitemiz, hukuka, yasalara, telif haklarına ve kişilik haklarına saygılı olmayı amaç edinmiştir. Sitemiz, 5651 sayılı yasada tanımlanan yer sağlayıcı olarak hizmet vermektedir. İlgili yasaya göre, site yönetiminin hukuka aykırı içerikleri kontrol etme yükümlülüğü yoktur. Bu nedenle, sitemiz uyar ve kaldır prensibini benimsemiştir. Telif hakkına konu olan eserlerin yasal olmayan bir biçimde paylaşıldığını ve yasal haklarının çiğnendiğini düşünen hak sahipleri veya meslek birlikleri, s.gezer92[at]gmail.com mail adresinden bize ulaşabilirler. Şikayet yerinde görüldüğü takdirde ihlal olduğu düşünülen içerikler sitemizden kaldırılacaktır.
Arkasında Google Var! | Bu site Google Adsense ile gelir sağlamaktadır.