insert into creature_template (entry, modelid_m, modelid_f, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction, npcflag, speed, rank, mindmg, maxdmg, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, size, family, bounding_radius, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, combat_reach, type, civilian, flag1, equipmodel1, equipmodel2, equipmodel3, equipinfo1, equipinfo2, equipinfo3, equipslot1, equipslot2, equipslot3, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, ainame, movementtype, inhabittype, scriptname) values (20000, 7102, 0, "link's vendor", "tier 4", 80, 80, 160500, 160500, 100, 100, 100000, 120, 6, "1,08", 0, 39, 55, 100, 1710, 1881, 0, 0, 1, 0, 2, 0, 0, 0, 0, "45,144", "62,073", 100, "2,38", 7, 0, 407371782, 22403, 0, 0, 218173186, 0, 0, 3, 0, 0, 8403, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 377, "", 0, 3, ""); insert into creature (guid, id, map, position_x, position_y, position_z, orientation, spawntimesecs, spawndist, currentwaypoint, spawn_position_x, spawn_position_y, spawn_position_z, spawn_orientation, curhealth, curmana, deathstate, movementtype, auras) values (75000, 20000, 1, -839.58, -5017.03, 496.98, 1, 180, 7, 0, -839.58, -5017.03, 496.98, 1, 10000, 100, 0, 0, (null)); insert into npc_vendor (entry, item, maxcount, incrtime) values (20000, (20000, (20000, (20000, (20000, (20000, (20000, (20000, (20000, (20000,
29012, 29011, 29015, 29016, 29017, 29021, 29019, 29022, 29023, 29020,
0, 0, 0, 0, 0, 0, 0, 0, 0, 0,
0), 0), 0), 0), 0), 0), 0), 0), 0), 0),
(20000, (20000, (20000, (20000, (20000, (20000, (20000, (20000, (20000, (20000, (20000, (20000, (20000, (20000, (20000,
29061, 29062, 29063, 29064, 29065, 29066, 29067, 29068, 29069, 29070, 29071, 29072, 29073, 29074, 29075,
0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0,
0), 0), 0), 0), 0), 0), 0), 0), 0), 0), 0), 0), 0), 0), 0),
(20000, (20000, (20000, (20000,
29081, 29082, 29083, 29084,
0, 0, 0, 0,
0), 0), 0), 0),
(20000, 29085, 0, 0), (20000, (20000, (20000, (20000, (20000, (20000, (20000, (20000, (20000, (20000, (20000, (20000, (20000, (20000, (20000,
29038, 29039, 29040, 29042, 29043, 30169, 30170, 30171, 30172, 30173, 29028, 29029, 29030, 29031, 29032,
0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0,
0), 0), 0), 0), 0), 0), 0), 0), 0), 0), 0), 0), 0), 0), 0),
(20000, (20000, (20000, (20000, (20000,
29044, 29045, 29046, 29047, 29048,
0, 0, 0, 0, 0,
0), 0), 0), 0), 0),
(20000, (20000, (20000, (20000, (20000, (20000, (20000, (20000, (20000, (20000, (20000, (20000, (20000, (20000, (20000,
29086, 29087, 29088, 29089, 29090, 29091, 29092, 29093, 29094, 29095, 29096, 29097, 29098, 29099, 29100,
0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0,
0), 0), 0), 0), 0), 0), 0), 0), 0), 0), 0), 0), 0), 0), 0),
(20000, (20000, (20000, (20000, (20000, (20000, (20000, (20000, (20000, (20000,
29049, 29050, 29053, 29054, 29055, 29056, 29057, 29058, 29059, 29060,
0, 0, 0, 0, 0, 0, 0, 0, 0, 0,
0), 0), 0), 0), 0), 0), 0), 0), 0), 0),
(20000, (20000, (20000, (20000, (20000,
29076, 29077, 29078, 29079, 29080,
0, 0, 0, 0, 0,
0), 0), 0), 0), 0),
(20000, 28963, 0, 0),
(20000, (20000, (20000, (20000,
28964, 28966, 28967, 28968,
0, 0, 0, 0,
0), 0), 0), 0);