초기 지급 아이템

Go down

초기 지급 아이템 Empty 초기 지급 아이템

올리기  study4u on 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 번 수정됨

_________________
배워서남준다 : http://study4u.justgoo.com/

study4u

게시물 갯수 : 29
Join date : 2008-08-09

http://study4u.justgoo.com/

위로 Go down

초기 지급 아이템 Empty 어센트 초기 지급 아이템

올리기  study4u on 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*/

_________________
배워서남준다 : http://study4u.justgoo.com/

study4u

게시물 갯수 : 29
Join date : 2008-08-09

http://study4u.justgoo.com/

위로 Go down

위로


 
Permissions in this forum:
답글을 올릴 수 없습니다