ascent / mangos
Would you like to react to this message? Create an account in a few clicks or log in to continue.

Ãʱâ Áö±Þ ¾ÆÀÌÅÛ

Go down

Ãʱâ Áö±Þ ¾ÆÀÌÅÛ Empty Ãʱâ Áö±Þ ¾ÆÀÌÅÛ

¿Ã¸®±â  study4u Sun Aug 31, 2008 7:18 am


¸Á°í½º Ãʱâ Áö±Þ ¾ÆÀÌÅÛ

¾î¼¾Æ®¿ëÀº ¾Æ·¡ ´ä±Û¿¡ ÀÖ½À´Ï´Ù.

/* 28Ä­ °¡¹æ Áö±Þ */
REPLACE INTO `item_template` (`entry`, `class`, `subclass`, `unk0`, `name`, `displayid`, `Quality`, `Flags`, `BuyCount`, `BuyPrice`, `SellPrice`, `InventoryType`, `AllowableClass`, `AllowableRace`, `ItemLevel`, `RequiredLevel`, `RequiredSkill`, `RequiredSkillRank`, `requiredspell`, `requiredhonorrank`, `RequiredCityRank`, `RequiredReputationFaction`, `RequiredReputationRank`, `maxcount`, `stackable`, `ContainerSlots`, `stat_type1`, `stat_value1`, `stat_type2`, `stat_value2`, `stat_type3`, `stat_value3`, `stat_type4`, `stat_value4`, `stat_type5`, `stat_value5`, `stat_type6`, `stat_value6`, `stat_type7`, `stat_value7`, `stat_type8`, `stat_value8`, `stat_type9`, `stat_value9`, `stat_type10`, `stat_value10`, `dmg_min1`, `dmg_max1`, `dmg_type1`, `dmg_min2`, `dmg_max2`, `dmg_type2`, `dmg_min3`, `dmg_max3`, `dmg_type3`, `dmg_min4`, `dmg_max4`, `dmg_type4`, `dmg_min5`, `dmg_max5`, `dmg_type5`, `armor`, `holy_res`, `fire_res`, `nature_res`, `frost_res`, `shadow_res`, `arcane_res`, `delay`, `ammo_type`, `RangedModRange`, `spellid_1`, `spelltrigger_1`, `spellcharges_1`, `spellcooldown_1`, `spellcategory_1`, `spellcategorycooldown_1`, `spellid_2`, `spelltrigger_2`, `spellcharges_2`, `spellcooldown_2`, `spellcategory_2`, `spellcategorycooldown_2`, `spellid_3`, `spelltrigger_3`, `spellcharges_3`, `spellcooldown_3`, `spellcategory_3`, `spellcategorycooldown_3`, `spellid_4`, `spelltrigger_4`, `spellcharges_4`, `spellcooldown_4`, `spellcategory_4`, `spellcategorycooldown_4`, `spellid_5`, `spelltrigger_5`, `spellcharges_5`, `spellcooldown_5`, `spellcategory_5`, `spellcategorycooldown_5`, `bonding`, `description`, `PageText`, `LanguageID`, `PageMaterial`, `startquest`, `lockid`, `Material`, `sheath`, `RandomProperty`, `RandomSuffix`, `block`, `itemset`, `MaxDurability`, `area`, `Map`, `BagFamily`, `TotemCategory`, `socketColor_1`, `socketContent_1`, `socketColor_2`, `socketContent_2`, `socketColor_3`, `socketContent_3`, `socketBonus`, `GemProperties`, `ExtendedCost`, `RequiredDisenchantSkill`, `ArmorDamageModifier`, `ScriptName`, `DisenchantID`) VALUES (21858, 1, 0, -1, 'Spellfire Bag', 39459, 3, 0, 1, 80000, 20000, 18, -1, -1, 95, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 28, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2, '', 0, 0, 0, 0, 0, 8, 0, 0, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, 'internalitemhandler', 0);
/* 1°³ Ãß°¡ */
INSERT INTO `playercreateinfo_item` VALUES ('1', '1', '21858', '1');
INSERT INTO `playercreateinfo_item` VALUES ('1', '2', '21858', '1');
INSERT INTO `playercreateinfo_item` VALUES ('1', '4', '21858', '1');
INSERT INTO `playercreateinfo_item` VALUES ('1', '5', '21858', '1');
INSERT INTO `playercreateinfo_item` VALUES ('1', '8', '21858', '1');
INSERT INTO `playercreateinfo_item` VALUES ('1', '9', '21858', '1');
INSERT INTO `playercreateinfo_item` VALUES ('2', '1', '21858', '1');
INSERT INTO `playercreateinfo_item` VALUES ('2', '3', '21858', '1');
INSERT INTO `playercreateinfo_item` VALUES ('2', '4', '21858', '1');
INSERT INTO `playercreateinfo_item` VALUES ('2', '7', '21858', '1');
INSERT INTO `playercreateinfo_item` VALUES ('2', '9', '21858', '1');
INSERT INTO `playercreateinfo_item` VALUES ('3', '1', '21858', '1');
INSERT INTO `playercreateinfo_item` VALUES ('3', '2', '21858', '1');
INSERT INTO `playercreateinfo_item` VALUES ('3', '3', '21858', '1');
INSERT INTO `playercreateinfo_item` VALUES ('3', '4', '21858', '1');
INSERT INTO `playercreateinfo_item` VALUES ('3', '5', '21858', '1');
INSERT INTO `playercreateinfo_item` VALUES ('4', '1', '21858', '1');
INSERT INTO `playercreateinfo_item` VALUES ('4', '3', '21858', '1');
INSERT INTO `playercreateinfo_item` VALUES ('4', '4', '21858', '1');
INSERT INTO `playercreateinfo_item` VALUES ('4', '11', '21858', '1');
INSERT INTO `playercreateinfo_item` VALUES ('4', '5', '21858', '1');
INSERT INTO `playercreateinfo_item` VALUES ('5', '1', '21858', '1');
INSERT INTO `playercreateinfo_item` VALUES ('5', '4', '21858', '1');
INSERT INTO `playercreateinfo_item` VALUES ('5', '5', '21858', '1');
INSERT INTO `playercreateinfo_item` VALUES ('5', '8', '21858', '1');
INSERT INTO `playercreateinfo_item` VALUES ('5', '9', '21858', '1');
INSERT INTO `playercreateinfo_item` VALUES ('6', '1', '21858', '1');
INSERT INTO `playercreateinfo_item` VALUES ('6', '3', '21858', '1');
INSERT INTO `playercreateinfo_item` VALUES ('6', '11', '21858', '1');
INSERT INTO `playercreateinfo_item` VALUES ('6', '7', '21858', '1');
INSERT INTO `playercreateinfo_item` VALUES ('7', '1', '21858', '1');
INSERT INTO `playercreateinfo_item` VALUES ('7', '4', '21858', '1');
INSERT INTO `playercreateinfo_item` VALUES ('7', '8', '21858', '1');
INSERT INTO `playercreateinfo_item` VALUES ('7', '9', '21858', '1');
INSERT INTO `playercreateinfo_item` VALUES ('8', '1', '21858', '1');
INSERT INTO `playercreateinfo_item` VALUES ('8', '3', '21858', '1');
INSERT INTO `playercreateinfo_item` VALUES ('8', '4', '21858', '1');
INSERT INTO `playercreateinfo_item` VALUES ('8', '7', '21858', '1');
INSERT INTO `playercreateinfo_item` VALUES ('8', '5', '21858', '1');
INSERT INTO `playercreateinfo_item` VALUES ('8', '8', '21858', '1');
INSERT INTO `playercreateinfo_item` VALUES ('10', '3', '21858', '1');
INSERT INTO `playercreateinfo_item` VALUES ('10', '2', '21858', '1');
INSERT INTO `playercreateinfo_item` VALUES ('10', '4', '21858', '1');
INSERT INTO `playercreateinfo_item` VALUES ('10', '5', '21858', '1');
INSERT INTO `playercreateinfo_item` VALUES ('10', '8', '21858', '1');
INSERT INTO `playercreateinfo_item` VALUES ('10', '9', '21858', '1');
INSERT INTO `playercreateinfo_item` VALUES ('11', '1', '21858', '1');
INSERT INTO `playercreateinfo_item` VALUES ('11', '3', '21858', '1');
INSERT INTO `playercreateinfo_item` VALUES ('11', '2', '21858', '1');
INSERT INTO `playercreateinfo_item` VALUES ('11', '5', '21858', '1');
INSERT INTO `playercreateinfo_item` VALUES ('11', '7', '21858', '1');
INSERT INTO `playercreateinfo_item` VALUES ('11', '8', '21858', '1');

/* ³¯½Ú ÁÙ¸®¾È È£¶ûÀÌ ·¾Á¦ÇÑ ¾ø¾Ö±â */
UPDATE item_template SET item_template.RequiredLevel=1,item_template.ItemLevel=0, item_template.RequiredSkill=0,item_template.RequiredSkillRank=0 WHERE item_template.entry = 19902;

/* ³¯½Ú ÁÙ¸®¾È È£¶ûÀÌ Ãß°¡ Äõ¸®¹® */
/* Àΰ£ */
INSERT INTO playercreateinfo_item VALUES (1,1,19902,1);/* ˟ȍ */
INSERT INTO playercreateinfo_item VALUES (1,2,19902,1);/* ¼º±â»ç */
INSERT INTO playercreateinfo_item VALUES (1,4,19902,1);/* µµÀû */
INSERT INTO playercreateinfo_item VALUES (1,5,19902,1);/* »çÁ¦ */
INSERT INTO playercreateinfo_item VALUES (1,8,19902,1);/* ¸¶¹ý»ç */
INSERT INTO playercreateinfo_item VALUES (1,9,19902,1);/* È渶¹ý»ç */
/* ¿ÀÅ© */
INSERT INTO playercreateinfo_item VALUES (2,1,19902,1);/* ˟ȍ */
INSERT INTO playercreateinfo_item VALUES (2,3,19902,1);/* »ç³É²Û */
INSERT INTO playercreateinfo_item VALUES (2,4,19902,1);/* µµÀû */
INSERT INTO playercreateinfo_item VALUES (2,7,19902,1);/* ÁÖ¼ú»ç */
INSERT INTO playercreateinfo_item VALUES (2,9,19902,1);/* È渶¹ý»ç */
/* µå¿öÇÁ */
INSERT INTO playercreateinfo_item VALUES (3,1,19902,1);/* ˟ȍ */
INSERT INTO playercreateinfo_item VALUES (3,2,19902,1);/* ¼º±â»ç */
INSERT INTO playercreateinfo_item VALUES (3,3,19902,1);/* »ç³É²Û */
INSERT INTO playercreateinfo_item VALUES (3,4,19902,1);/* µµÀû */
INSERT INTO playercreateinfo_item VALUES (3,5,19902,1);/* »çÁ¦ */
/* ¿¤ÇÁ */
INSERT INTO playercreateinfo_item VALUES (4,1,19902,1);/* ˟ȍ */
INSERT INTO playercreateinfo_item VALUES (4,3,19902,1);/* »ç³É²Û */
INSERT INTO playercreateinfo_item VALUES (4,4,19902,1);/* µµÀû */
INSERT INTO playercreateinfo_item VALUES (4,5,19902,1);/* »çÁ¦ */
INSERT INTO playercreateinfo_item VALUES (4,11,19902,1);/* µå·çÀ̵å */
/* ¾ðµ¥µå */
INSERT INTO playercreateinfo_item VALUES (5,1,19902,1);/* ˟ȍ */
INSERT INTO playercreateinfo_item VALUES (5,4,19902,1);/* µµÀû */
INSERT INTO playercreateinfo_item VALUES (5,5,19902,1);/* »çÁ¦ */
INSERT INTO playercreateinfo_item VALUES (5,8,19902,1);/* ¸¶¹ý»ç */
INSERT INTO playercreateinfo_item VALUES (5,9,19902,1);/* È渶¹ý»ç */
/* Ÿ¿ì·» */
INSERT INTO playercreateinfo_item VALUES (6,1,19902,1);/* ˟ȍ */
INSERT INTO playercreateinfo_item VALUES (6,3,19902,1);/* »ç³É²Û */
INSERT INTO playercreateinfo_item VALUES (6,7,19902,1);/* ÁÖ¼ú»ç */
INSERT INTO playercreateinfo_item VALUES (6,11,19902,1);/* µå·çÀ̵å */
/* ³ë¿ò */
INSERT INTO playercreateinfo_item VALUES (7,1,19902,1);/* ˟ȍ */
INSERT INTO playercreateinfo_item VALUES (7,4,19902,1);/* µµÀû */
INSERT INTO playercreateinfo_item VALUES (7,8,19902,1);/* ¸¶¹ý»ç */
INSERT INTO playercreateinfo_item VALUES (7,9,19902,1);/* È渶¹ý»ç */
/* Æ®·Ñ */
INSERT INTO playercreateinfo_item VALUES (8,1,19902,1);/* ˟ȍ */
INSERT INTO playercreateinfo_item VALUES (8,3,19902,1);/* »ç³É²Û */
INSERT INTO playercreateinfo_item VALUES (8,4,19902,1);/* µµÀû */
INSERT INTO playercreateinfo_item VALUES (8,5,19902,1);/* »çÁ¦ */
INSERT INTO playercreateinfo_item VALUES (8,7,19902,1);/* ÁÖ¼ú»ç */
INSERT INTO playercreateinfo_item VALUES (8,8,19902,1);/* ¸¶¹ý»ç */
/* µå·¹³ªÀÌ */
INSERT INTO playercreateinfo_item VALUES (10,1,19902,1);/* ˟ȍ */
INSERT INTO playercreateinfo_item VALUES (10,2,19902,1);/* ¼º±â»ç */
INSERT INTO playercreateinfo_item VALUES (10,3,19902,1);/* »ç³É²Û */
INSERT INTO playercreateinfo_item VALUES (10,5,19902,1);/* »çÁ¦ */
INSERT INTO playercreateinfo_item VALUES (10,7,19902,1);/* ÁÖ¼ú»ç */
INSERT INTO playercreateinfo_item VALUES (10,8,19902,1);/* ¸¶¹ý»ç */
/* ºí·¯µå¿¤ÇÁ */
INSERT INTO playercreateinfo_item VALUES (11,2,19902,1);/* ¼º±â»ç */
INSERT INTO playercreateinfo_item VALUES (11,3,19902,1);/* »ç³É²Û */
INSERT INTO playercreateinfo_item VALUES (11,4,19902,1);/* µµÀû */
INSERT INTO playercreateinfo_item VALUES (11,5,19902,1);/* »çÁ¦ */
INSERT INTO playercreateinfo_item VALUES (11,8,19902,1);/* ¸¶¹ý»ç */
INSERT INTO playercreateinfo_item VALUES (11,9,19902,1);/* È渶¹ý»ç */

/* ³¯½Ú Ȳõ ºñ·æ °ú ·¾Á¦ÇÑ ¾ø¾Ö±â 37015 */
UPDATE item_template SET item_template.RequiredLevel=1,item_template.ItemLevel=0, item_template.RequiredSkill=0,item_template.RequiredSkillRank=0 WHERE item_template.entry = 32862;

/* ³¯½Ú Ȳõ ºñ·æ Ãß°¡ Äõ¸®¹® */
INSERT INTO playercreateinfo_item VALUES (1,1,32862,1);
INSERT INTO playercreateinfo_item VALUES (1,2,32862,1);
INSERT INTO playercreateinfo_item VALUES (1,4,32862,1);
INSERT INTO playercreateinfo_item VALUES (1,5,32862,1);
INSERT INTO playercreateinfo_item VALUES (1,8,32862,1);
INSERT INTO playercreateinfo_item VALUES (1,9,32862,1);
INSERT INTO playercreateinfo_item VALUES (2,1,32862,1);
INSERT INTO playercreateinfo_item VALUES (2,3,32862,1);
INSERT INTO playercreateinfo_item VALUES (2,4,32862,1);
INSERT INTO playercreateinfo_item VALUES (2,7,32862,1);
INSERT INTO playercreateinfo_item VALUES (2,9,32862,1);
INSERT INTO playercreateinfo_item VALUES (3,1,32862,1);
INSERT INTO playercreateinfo_item VALUES (3,2,32862,1);
INSERT INTO playercreateinfo_item VALUES (3,3,32862,1);
INSERT INTO playercreateinfo_item VALUES (3,4,32862,1);
INSERT INTO playercreateinfo_item VALUES (3,5,32862,1);
INSERT INTO playercreateinfo_item VALUES (4,1,32862,1);
INSERT INTO playercreateinfo_item VALUES (4,3,32862,1);
INSERT INTO playercreateinfo_item VALUES (4,4,32862,1);
INSERT INTO playercreateinfo_item VALUES (4,5,32862,1);
INSERT INTO playercreateinfo_item VALUES (4,11,32862,1);
INSERT INTO playercreateinfo_item VALUES (5,1,32862,1);
INSERT INTO playercreateinfo_item VALUES (5,4,32862,1);
INSERT INTO playercreateinfo_item VALUES (5,5,32862,1);
INSERT INTO playercreateinfo_item VALUES (5,8,32862,1);
INSERT INTO playercreateinfo_item VALUES (5,9,32862,1);
INSERT INTO playercreateinfo_item VALUES (6,1,32862,1);
INSERT INTO playercreateinfo_item VALUES (6,3,32862,1);
INSERT INTO playercreateinfo_item VALUES (6,7,32862,1);
INSERT INTO playercreateinfo_item VALUES (6,11,32862,1);
INSERT INTO playercreateinfo_item VALUES (7,1,32862,1);
INSERT INTO playercreateinfo_item VALUES (7,4,32862,1);
INSERT INTO playercreateinfo_item VALUES (7,8,32862,1);
INSERT INTO playercreateinfo_item VALUES (7,9,32862,1);
INSERT INTO playercreateinfo_item VALUES (8,1,32862,1);
INSERT INTO playercreateinfo_item VALUES (8,3,32862,1);
INSERT INTO playercreateinfo_item VALUES (8,4,32862,1);
INSERT INTO playercreateinfo_item VALUES (8,5,32862,1);
INSERT INTO playercreateinfo_item VALUES (8,7,32862,1);
INSERT INTO playercreateinfo_item VALUES (8,8,32862,1);
INSERT INTO playercreateinfo_item VALUES (10,1,32862,1);
INSERT INTO playercreateinfo_item VALUES (10,2,32862,1);
INSERT INTO playercreateinfo_item VALUES (10,3,32862,1);
INSERT INTO playercreateinfo_item VALUES (10,5,32862,1);
INSERT INTO playercreateinfo_item VALUES (10,7,32862,1);
INSERT INTO playercreateinfo_item VALUES (10,8,32862,1);
INSERT INTO playercreateinfo_item VALUES (11,2,32862,1);
INSERT INTO playercreateinfo_item VALUES (11,3,32862,1);
INSERT INTO playercreateinfo_item VALUES (11,4,32862,1);
INSERT INTO playercreateinfo_item VALUES (11,5,32862,1);
INSERT INTO playercreateinfo_item VALUES (11,8,32862,1);
INSERT INTO playercreateinfo_item VALUES (11,9,32862,1);

/* ³¯½Ú ¿¤·¹Å© */
/* Great Blue Elekk = 29745 */
/* Great Green Elekk = 29746 */
/* Great Purple Elekk = 29747 */
/* ³¯½Ú ¸» */
/* Swift Palomino = 18776 */
/* Swift Brown Steed = 18777 */
/* Swift White Steed = 18778 */
/* ³¯½Ú ±â°èŸÁ¶ */
/* Swift Green Mechanostrider = 18772 */
/* Swift White Mechanostrider = 18773 */
/* Swift Yellow Mechanostrider = 18774 */
/* ³¯½Ú È£¶ûÀÌ */
/* Swift Frostsaber = 18766 */
/* Swift Mistsaber = 18767 */
/* Swift Stormsaber = 18902 */
/* Swift Zulian Tiger = 19902 */
/* ³¯½Ú »ê¾ç */
/* Swift White Ram = 18785 */
/* Swift Brown Ram = 18786 */
/* Swift Gray Ram = 18787 */
/* ³¯½Ú ·¾ÅÍ */
/* Swift Blue Raptor = 18788 */
/* Swift Olive Raptor = 18789 */
/* Swift Orange Raptor = 18790 */
/* Swift Razzashi Raptor = 19872 */
/* ³¯½Ú ÇØ°ñ¸¶ */
/* Purple Skeletal Warhorse = 18791 */
/* Green Skeletal Warhorse = 13334 */
/* Deathcharger = 13335 */
/* ÄÚµµ */
/* Blessed Arcanite Barding = 18793 */
/* Great Brown Kodo = 18794 */
/* Great Gray Kodo = 18795 */
/* ´Á´ë */
/* Swift Brown Wolf = 18796 */
/* Swift Timber Wolf = 18797 */
/* Swift Gray Wolf = 18798 */
/* ¸ÅŸÁ¶ */
/* Swift Green Hawkstrider = 29223 */
/* Swift Purple Hawkstrider = 29224 */
/* µå·¹°ï */
/* Swift Nether Drake = 30609 */
/* ¿ÍÀ̹ø */
/* Swift Green Windrider = 25531 */
/* Swift Yellow Windrider = 25532 */
/* Swift Purple Windrider = 25533 */
/* Swift Red Windrider = 25477 */
/* ±×¸®ÇÉ */
/* Swift Blue Gryphon = 25473 */
/* Swift Red Gryphon = 25527 */
/* Swift Green Gryphon = 25528 */
/* Swift Purple Gryphon = 25529 */
/* ºñ·æ */
/* Green Riding Nether Ray =32314 */
/* Purple Riding Nether Ray = 32316 */
/* Red Riding Nether Ray = 32317 */
/* Silver Riding Nether Ray = 32318 */
/* Blue Riding Nether Ray = 32319 */
/* ³¯½Úºñ·æ */
/* Onyx Netherwing Drake = 32857 */
/* Azure Netherwing Drake = 32858 */
/* Cobalt Netherwing Drake = 32859 */
/* Purple Netherwing Drake = 32860 */
/* Veridian Netherwing Drake = 32861 */
/* Violet Netherwing Drake = 32862 */




study4u °¡ Sun Aug 31, 2008 7:20 am¿¡ ¼öÁ¤ÇÔ, ÃÑ 1 ¹ø ¼öÁ¤µÊ

study4u

°Ô½Ã¹° °¹¼ö : 29
Join date : 2008-08-09

http://study4u.justgoo.com/

À§·Î Go down

Ãʱâ Áö±Þ ¾ÆÀÌÅÛ Empty ¾î¼¾Æ® Ãʱâ Áö±Þ ¾ÆÀÌÅÛ

¿Ã¸®±â  study4u Sun Aug 31, 2008 7:18 am


¾î¼¾Æ® »ç¿ëÀÚ¿ë

¿À·¡Àü¿¡ »ç¿ëÇÏ´ø Äõ¸®¹®ÀÔ´Ï´Ù. ÇöÀç DB¿¡¼­µµ Àû¿ëÀÌ µÇ´ÂÁö´Â È®ÀÎÇØ º¸Áö ¾Ê¾ÒÀ¸³ª Âü°í ÀÚ·á·Î »ç¿ëÇϼ¼¿ä.

/* Å»°Í(³¯½Ú ÁÙ¸®¾È È£¶ûÀÌ = 19902) ·¾Á¦ÇÑ ¾ø¾Ö±â */
UPDATE items SET items.itemlevel=1,items.RequiredLevel=1,items.ItemLevel=0, items.RequiredSkill=0,items.RequiredSkillRank=0 WHERE items.entry = 19902;

/* Àΰ£ */
INSERT INTO playercreateinfo_items VALUES (1,19902,26,1);
INSERT INTO playercreateinfo_items VALUES (9,19902,26,1);
INSERT INTO playercreateinfo_items VALUES (18,19902,26,1);
INSERT INTO playercreateinfo_items VALUES (25,19902,26,1);
INSERT INTO playercreateinfo_items VALUES (34,19902,26,1);
INSERT INTO playercreateinfo_items VALUES (38,19902,26,1);

/* ¿ÀÅ© */
INSERT INTO playercreateinfo_items VALUES (2,19902,26,1);
INSERT INTO playercreateinfo_items VALUES (11,19902,26,1);
INSERT INTO playercreateinfo_items VALUES (19,19902,26,1);
INSERT INTO playercreateinfo_items VALUES (30,19902,26,1);
INSERT INTO playercreateinfo_items VALUES (39,19902,26,1);

/* µå¿öÇÁ */
INSERT INTO playercreateinfo_items VALUES (3,19902,26,1);
INSERT INTO playercreateinfo_items VALUES (10,19902,26,1);
INSERT INTO playercreateinfo_items VALUES (12,19902,26,1);
INSERT INTO playercreateinfo_items VALUES (20,19902,26,1);
INSERT INTO playercreateinfo_items VALUES (26,19902,26,1);

/* ³ªÀÌÆ®¿¤ÇÁ */
INSERT INTO playercreateinfo_items VALUES (4,19902,26,1);
INSERT INTO playercreateinfo_items VALUES (15,19902,26,1);
INSERT INTO playercreateinfo_items VALUES (21,19902,26,1);
INSERT INTO playercreateinfo_items VALUES (27,19902,26,1);
INSERT INTO playercreateinfo_items VALUES (42,19902,26,1);

/* ¾ðµ¥µå */
INSERT INTO playercreateinfo_items VALUES (5,19902,26,1);
INSERT INTO playercreateinfo_items VALUES (22,19902,26,1);
INSERT INTO playercreateinfo_items VALUES (28,19902,26,1);
INSERT INTO playercreateinfo_items VALUES (35,19902,26,1);
INSERT INTO playercreateinfo_items VALUES (40,19902,26,1);

/* Ÿ¿ì·» */
INSERT INTO playercreateinfo_items VALUES (6,19902,26,1);
INSERT INTO playercreateinfo_items VALUES (16,19902,26,1);
INSERT INTO playercreateinfo_items VALUES (31,19902,26,1);
INSERT INTO playercreateinfo_items VALUES (43,19902,26,1);

/* ³ë¿ò */
INSERT INTO playercreateinfo_items VALUES (7,19902,26,1);
INSERT INTO playercreateinfo_items VALUES (23,19902,26,1);
INSERT INTO playercreateinfo_items VALUES (36,19902,26,1);
INSERT INTO playercreateinfo_items VALUES (41,19902,26,1);

/* Æ®·Ñ */
INSERT INTO playercreateinfo_items VALUES (8,19902,26,1);
INSERT INTO playercreateinfo_items VALUES (17,19902,26,1);
INSERT INTO playercreateinfo_items VALUES (24,19902,26,1);
INSERT INTO playercreateinfo_items VALUES (29,19902,26,1);
INSERT INTO playercreateinfo_items VALUES (32,19902,26,1);
INSERT INTO playercreateinfo_items VALUES (37,19902,26,1);

/* µå·¹³ªÀÌ */
INSERT INTO playercreateinfo_items VALUES (44,19902,26,1);
INSERT INTO playercreateinfo_items VALUES (45,19902,26,1);
INSERT INTO playercreateinfo_items VALUES (46,19902,26,1);
INSERT INTO playercreateinfo_items VALUES (47,19902,26,1);
INSERT INTO playercreateinfo_items VALUES (48,19902,26,1);
INSERT INTO playercreateinfo_items VALUES (49,19902,26,1);

/* ºí·¯µå¿¤ÇÁ */
INSERT INTO playercreateinfo_items VALUES (50,19902,26,1);
INSERT INTO playercreateinfo_items VALUES (51,19902,26,1);
INSERT INTO playercreateinfo_items VALUES (52,19902,26,1);
INSERT INTO playercreateinfo_items VALUES (53,19902,26,1);
INSERT INTO playercreateinfo_items VALUES (54,19902,26,1);
INSERT INTO playercreateinfo_items VALUES (55,19902,26,1);


/* 28Ä­ °¡¹æ Item(21858) Á¦ÇÑ ÇØÁ¦ */
UPDATE items SET items.subclass=0,items.RequiredLevel=1,items.ItemLevel=0, items.RequiredSkill=0,items.RequiredSkillRank=0,items.bagfamily=0 WHERE items.entry = 21858;

/* 1°³ Ãß°¡ */
/* ¸¸¾à ¿©·¯°³ Ãß°¡ÇÏ°í ½ÍÀ¸¸é ¾Æ·¡ Äõ¸®¹® ¹Ýº¹ÇÏ¸é µË´Ï´Ù */
INSERT INTO playercreateinfo_items VALUES (1,21858,27,1);
INSERT INTO playercreateinfo_items VALUES (9,21858,27,1);
INSERT INTO playercreateinfo_items VALUES (18,21858,27,1);
INSERT INTO playercreateinfo_items VALUES (25,21858,27,1);
INSERT INTO playercreateinfo_items VALUES (34,21858,27,1);
INSERT INTO playercreateinfo_items VALUES (38,21858,27,1);
INSERT INTO playercreateinfo_items VALUES (2,21858,27,1);
INSERT INTO playercreateinfo_items VALUES (11,21858,27,1);
INSERT INTO playercreateinfo_items VALUES (19,21858,27,1);
INSERT INTO playercreateinfo_items VALUES (30,21858,27,1);
INSERT INTO playercreateinfo_items VALUES (39,21858,27,1);
INSERT INTO playercreateinfo_items VALUES (3,21858,27,1);
INSERT INTO playercreateinfo_items VALUES (10,21858,27,1);
INSERT INTO playercreateinfo_items VALUES (12,21858,27,1);
INSERT INTO playercreateinfo_items VALUES (20,21858,27,1);
INSERT INTO playercreateinfo_items VALUES (26,21858,27,1);
INSERT INTO playercreateinfo_items VALUES (4,21858,27,1);
INSERT INTO playercreateinfo_items VALUES (15,21858,27,1);
INSERT INTO playercreateinfo_items VALUES (21,21858,27,1);
INSERT INTO playercreateinfo_items VALUES (27,21858,27,1);
INSERT INTO playercreateinfo_items VALUES (42,21858,27,1);
INSERT INTO playercreateinfo_items VALUES (5,21858,27,1);
INSERT INTO playercreateinfo_items VALUES (22,21858,27,1);
INSERT INTO playercreateinfo_items VALUES (28,21858,27,1);
INSERT INTO playercreateinfo_items VALUES (35,21858,27,1);
INSERT INTO playercreateinfo_items VALUES (40,21858,27,1);
INSERT INTO playercreateinfo_items VALUES (6,21858,27,1);
INSERT INTO playercreateinfo_items VALUES (16,21858,27,1);
INSERT INTO playercreateinfo_items VALUES (31,21858,27,1);
INSERT INTO playercreateinfo_items VALUES (43,21858,27,1);
INSERT INTO playercreateinfo_items VALUES (7,21858,27,1);
INSERT INTO playercreateinfo_items VALUES (23,21858,27,1);
INSERT INTO playercreateinfo_items VALUES (36,21858,27,1);
INSERT INTO playercreateinfo_items VALUES (41,21858,27,1);
INSERT INTO playercreateinfo_items VALUES (8,21858,27,1);
INSERT INTO playercreateinfo_items VALUES (17,21858,27,1);
INSERT INTO playercreateinfo_items VALUES (24,21858,27,1);
INSERT INTO playercreateinfo_items VALUES (29,21858,27,1);
INSERT INTO playercreateinfo_items VALUES (32,21858,27,1);
INSERT INTO playercreateinfo_items VALUES (37,21858,27,1);
INSERT INTO playercreateinfo_items VALUES (44,21858,27,1);
INSERT INTO playercreateinfo_items VALUES (45,21858,27,1);
INSERT INTO playercreateinfo_items VALUES (46,21858,27,1);
INSERT INTO playercreateinfo_items VALUES (47,21858,27,1);
INSERT INTO playercreateinfo_items VALUES (48,21858,27,1);
INSERT INTO playercreateinfo_items VALUES (49,21858,27,1);
INSERT INTO playercreateinfo_items VALUES (50,21858,27,1);
INSERT INTO playercreateinfo_items VALUES (51,21858,27,1);
INSERT INTO playercreateinfo_items VALUES (52,21858,27,1);
INSERT INTO playercreateinfo_items VALUES (53,21858,27,1);
INSERT INTO playercreateinfo_items VALUES (54,21858,27,1);
INSERT INTO playercreateinfo_items VALUES (55,21858,27,1);

/* Å»°Í(Ȳõ ºñ·æ = 32862) ·¾Á¦ÇÑ ¾ø¾Ö±â */
UPDATE items SET items.itemlevel=1,items.RequiredLevel=1,items.ItemLevel=0, items.RequiredSkill=0,items.RequiredSkillRank=0 WHERE items.entry = 32862;

INSERT INTO playercreateinfo_items VALUES (1,32862,31,1);
INSERT INTO playercreateinfo_items VALUES (9,32862,31,1);
INSERT INTO playercreateinfo_items VALUES (18,32862,31,1);
INSERT INTO playercreateinfo_items VALUES (25,32862,31,1);
INSERT INTO playercreateinfo_items VALUES (34,32862,31,1);
INSERT INTO playercreateinfo_items VALUES (38,32862,31,1);
INSERT INTO playercreateinfo_items VALUES (2,32862,31,1);
INSERT INTO playercreateinfo_items VALUES (11,32862,31,1);
INSERT INTO playercreateinfo_items VALUES (19,32862,31,1);
INSERT INTO playercreateinfo_items VALUES (30,32862,31,1);
INSERT INTO playercreateinfo_items VALUES (39,32862,31,1);
INSERT INTO playercreateinfo_items VALUES (3,32862,31,1);
INSERT INTO playercreateinfo_items VALUES (10,32862,31,1);
INSERT INTO playercreateinfo_items VALUES (12,32862,31,1);
INSERT INTO playercreateinfo_items VALUES (20,32862,31,1);
INSERT INTO playercreateinfo_items VALUES (26,32862,31,1);
INSERT INTO playercreateinfo_items VALUES (4,32862,31,1);
INSERT INTO playercreateinfo_items VALUES (15,32862,31,1);
INSERT INTO playercreateinfo_items VALUES (21,32862,31,1);
INSERT INTO playercreateinfo_items VALUES (27,32862,31,1);
INSERT INTO playercreateinfo_items VALUES (42,32862,31,1);
INSERT INTO playercreateinfo_items VALUES (5,32862,31,1);
INSERT INTO playercreateinfo_items VALUES (22,32862,31,1);
INSERT INTO playercreateinfo_items VALUES (28,32862,31,1);
INSERT INTO playercreateinfo_items VALUES (35,32862,31,1);
INSERT INTO playercreateinfo_items VALUES (40,32862,31,1);
INSERT INTO playercreateinfo_items VALUES (6,32862,31,1);
INSERT INTO playercreateinfo_items VALUES (16,32862,31,1);
INSERT INTO playercreateinfo_items VALUES (31,32862,31,1);
INSERT INTO playercreateinfo_items VALUES (43,32862,31,1);
INSERT INTO playercreateinfo_items VALUES (7,32862,31,1);
INSERT INTO playercreateinfo_items VALUES (23,32862,31,1);
INSERT INTO playercreateinfo_items VALUES (36,32862,31,1);
INSERT INTO playercreateinfo_items VALUES (41,32862,31,1);
INSERT INTO playercreateinfo_items VALUES (8,32862,31,1);
INSERT INTO playercreateinfo_items VALUES (17,32862,31,1);
INSERT INTO playercreateinfo_items VALUES (24,32862,31,1);
INSERT INTO playercreateinfo_items VALUES (29,32862,31,1);
INSERT INTO playercreateinfo_items VALUES (32,32862,31,1);
INSERT INTO playercreateinfo_items VALUES (37,32862,31,1);
INSERT INTO playercreateinfo_items VALUES (44,32862,31,1);
INSERT INTO playercreateinfo_items VALUES (45,32862,31,1);
INSERT INTO playercreateinfo_items VALUES (46,32862,31,1);
INSERT INTO playercreateinfo_items VALUES (47,32862,31,1);
INSERT INTO playercreateinfo_items VALUES (48,32862,31,1);
INSERT INTO playercreateinfo_items VALUES (49,32862,31,1);
INSERT INTO playercreateinfo_items VALUES (50,32862,31,1);
INSERT INTO playercreateinfo_items VALUES (51,32862,31,1);
INSERT INTO playercreateinfo_items VALUES (52,32862,31,1);
INSERT INTO playercreateinfo_items VALUES (53,32862,31,1);
INSERT INTO playercreateinfo_items VALUES (54,32862,31,1);
INSERT INTO playercreateinfo_items VALUES (55,32862,31,1);

/* ³¯½Ú ¿¤·¹Å© */
/* Great Blue Elekk = 29745 */
/* Great Green Elekk = 29746 */
/* Great Purple Elekk = 29747 */
/* ³¯½Ú ¸» */
/* Swift Palomino = 18776 */
/* Swift Brown Steed = 18777 */
/* Swift White Steed = 18778 */
/* ³¯½Ú ±â°èŸÁ¶ */
/* Swift Green Mechanostrider = 18772 */
/* Swift White Mechanostrider = 18773 */
/* Swift Yellow Mechanostrider = 18774 */
/* ³¯½Ú È£¶ûÀÌ */
/* Swift Frostsaber = 18766 */
/* Swift Mistsaber = 18767 */
/* Swift Stormsaber = 18902 */
/* Swift Zulian Tiger = 19902 */
/* ³¯½Ú »ê¾ç */
/* Swift White Ram = 18785 */
/* Swift Brown Ram = 18786 */
/* Swift Gray Ram = 18787 */
/* ³¯½Ú ·¾ÅÍ */
/* Swift Blue Raptor = 18788 */
/* Swift Olive Raptor = 18789 */
/* Swift Orange Raptor = 18790 */
/* Swift Razzashi Raptor = 19872 */
/* ³¯½Ú ÇØ°ñ¸¶ */
/* Purple Skeletal Warhorse = 18791 */
/* Green Skeletal Warhorse = 13334 */
/* Deathcharger = 13335 */
/* ÄÚµµ */
/* Blessed Arcanite Barding = 18793 */
/* Great Brown Kodo = 18794 */
/* Great Gray Kodo = 18795 */
/* ´Á´ë */
/* Swift Brown Wolf = 18796 */
/* Swift Timber Wolf = 18797 */
/* Swift Gray Wolf = 18798 */
/* ¸ÅŸÁ¶ */
/* Swift Green Hawkstrider = 29223 */
/* Swift Purple Hawkstrider = 29224 */
/* µå·¹°ï */
/* Swift Nether Drake = 30609 */
/* ¿ÍÀ̹ø */
/* Swift Green Windrider = 25531 */
/* Swift Yellow Windrider = 25532 */
/* Swift Purple Windrider = 25533 */
/* Swift Red Windrider = 25477 */
/* ±×¸®ÇÉ */
/* Swift Blue Gryphon = 25473 */
/* Swift Red Gryphon = 25527 */
/* Swift Green Gryphon = 25528 */
/* Swift Purple Gryphon = 25529 */
/* ºñ·æ */
/* Green Riding Nether Ray =32314 */
/* Purple Riding Nether Ray = 32316 */
/* Red Riding Nether Ray = 32317 */
/* Silver Riding Nether Ray = 32318 */
/* Blue Riding Nether Ray = 32319 */
/* ³¯½Úºñ·æ */
/* Onyx Netherwing Drake = 32857 */
/* Azure Netherwing Drake = 32858 */
/* Cobalt Netherwing Drake = 32859 */
/* Purple Netherwing Drake = 32860 */
/* Veridian Netherwing Drake = 32861 */
/* Violet Netherwing Drake = 32862 spell:36142 41518*/

study4u

°Ô½Ã¹° °¹¼ö : 29
Join date : 2008-08-09

http://study4u.justgoo.com/

À§·Î Go down

À§·Î


 
Permissions in this forum:
´ä±ÛÀ» ¿Ã¸± ¼ö ¾ø½À´Ï´Ù