[X3 Release] Keazain`s Latest Compiles and Converted NCDB & Logon DB ready for use!

[randal]

I actually want to upgrade to the latest. Do i just run the new world and logn scripts against my db and it will keep my characters and pets?

Thanks again.

[keazain]

im right now compiling, and making a brand new core, db etc and testing ALL stuff for errors, and then i release the new one here, and adding mangos FUN db incl. mall and teleporter and gold quest!
and the last thing today before im going to new years party

[vintvlad]

were is magos fun ?

[Muskade]

Keazain Lottery

_________________________DATABASE_____________________

INSERT INTO `creature_names` VALUES ('77777', 'Keazain Lottery', 'Keazain Lottery', '', '0', '7', '0', '0', '0', '0', '21723', '0', '0', '0', '1', '1', '0', '0');
INSERT INTO `creature_proto` VALUES ('77777', '80', '80', '35', '200000', '200000', '20000', '1', '128', '1870', '0', '14', '20', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '7', '0.8', '0', '0', '0', '0', '0', '2.5', '8', '14', '0', '0', '0', '0', '0', '0', '0');

INSERT INTO `vendors` VALUES ('77777', '90011', '1', '0', '0', '0');
INSERT INTO `vendors` VALUES ('77777', '90012', '1', '0', '0', '0');
INSERT INTO `vendors` VALUES ('77777', '90013', '1', '0', '0', '0');

INSERT INTO `items` VALUES ('90018','8','-1','-1','JACKPOT','JACKPOT','JACKPOT','JACKPOT','11766','0','0','500000000','50000000 0','0','-1','-1','0','0','0','0','0','0','0','0','0','0','20','0','0','0','0','0','0','0','0', '0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0', '0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0', '0','0','-1','-1','0','-1','0','0','0','-1','0','-1','0','0','0','-1','0','-1','0','0','0','-1','0','-1','0','0','0','-1','0','-1','0','','0','0','0','0','0','-1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','-1','0','0');
INSERT INTO `items` VALUES ('90017','8','-1','-1','10 Golds','10 Golds','10 Golds','10 Golds','11766','0','0','100000','100000','0','-1','-1','0','0','0','0','0','0','0','0','0','0','20','0','0','0','0','0','0','0','0', '0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0', '0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0', '0','0','-1','-1','0','-1','0','0','0','-1','0','-1','0','0','0','-1','0','-1','0','0','0','-1','0','-1','0','0','0','-1','0','-1','0','','0','0','0','0','0','-1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','-1','0','0');
INSERT INTO `items` VALUES ('90016','8','-1','-1','1000 Golds','1000 Golds','1000 Golds','1000 Golds','11766','0','0','10000000','10000000','0','-1','-1','0','0','0','0','0','0','0','0','0','0','20','0','0','0','0','0','0','0','0', '0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0', '0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0', '0','0','-1','-1','0','-1','0','0','0','-1','0','-1','0','0','0','-1','0','-1','0','0','0','-1','0','-1','0','0','0','-1','0','-1','0','','0','0','0','0','0','-1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','-1','0','0');
INSERT INTO `items` VALUES ('90015','8','-1','-1','100 Golds','100 Golds','100 Golds','100 Golds','11766','0','0','1000000','1000000','0','-1','-1','0','0','0','0','0','0','0','0','0','0','20','0','0','0','0','0','0','0','0', '0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0', '0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0', '0','0','-1','-1','0','-1','0','0','0','-1','0','-1','0','0','0','-1','0','-1','0','0','0','-1','0','-1','0','0','0','-1','0','-1','0','','0','0','0','0','0','-1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','-1','0','0');
INSERT INTO `items` VALUES ('90014','8','-1','-1','1 Golds','1 Golds','1 Golds','1 Golds','11766','0','0','10000','10000','0','-1','-1','0','0','0','0','0','0','0','0','0','0','20','0','0','0','0','0','0','0','0', '0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0', '0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0', '0','0','-1','-1','0','-1','0','0','0','-1','0','-1','0','0','0','-1','0','-1','0','0','0','-1','0','-1','0','0','0','-1','0','-1','0','','0','0','0','0','0','-1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','-1','0','0');
INSERT INTO `items` VALUES ('90013','8','-1','-1','100 Golds ticket','100 Golds ticket','100 Golds ticket','100 Golds ticket','11766','1','4','1000000','1000000','0','-1','-1','0','0','0','0','0','0','0','0','0','0','1','0','0','0','0','0','0','0','0',' 0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0',' 0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0',' 0','0','-1','-1','0','-1','0','0','0','-1','0','-1','0','0','0','-1','0','-1','0','0','0','-1','0','-1','0','0','0','-1','0','-1','0','','0','0','0','0','0','-1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','-1','0','0');
INSERT INTO `items` VALUES ('90012','8','-1','-1','10 Golds ticket','10 Golds ticket','10 Golds ticket','10 Golds ticket','11766','1','4','100000','100000','0','-1','-1','0','0','0','0','0','0','0','0','0','0','1','0','0','0','0','0','0','0','0',' 0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0',' 0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0',' 0','0','-1','-1','0','-1','0','0','0','-1','0','-1','0','0','0','-1','0','-1','0','0','0','-1','0','-1','0','0','0','-1','0','-1','0','','0','0','0','0','0','-1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','-1','0','0');
INSERT INTO `items` VALUES ('90011','8','-1','-1','1 Golds ticket','1 Golds ticket','1 Golds ticket','1 Golds ticket','11766','1','4','10000','10000','0','-1','-1','0','0','0','0','0','0','0','0','0','0','1','0','0','0','0','0','0','0','0',' 0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0',' 0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0',' 0','0','-1','-1','0','-1','0','0','0','-1','0','-1','0','0','0','-1','0','-1','0','0','0','-1','0','-1','0','0','0','-1','0','-1','0','','0','0','0','0','0','-1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','-1','0','0');

INSERT INTO `loot_items` VALUES ('5560', '90011', '90014', '40', '0', '1', '2', '0');
INSERT INTO `loot_items` VALUES ('5564', '90011', '90017', '15', '0', '1', '1', '0');
INSERT INTO `loot_items` VALUES ('5567', '90012', '90015', '30', '0', '1', '2', '0');
INSERT INTO `loot_items` VALUES ('5565', '90012', '90017', '28', '0', '1', '2', '0');
INSERT INTO `loot_items` VALUES ('5570', '90012', '90018', '0.5', '0', '1', '1', '0');
INSERT INTO `loot_items` VALUES ('5571', '90013', '90015', '30', '0', '1', '2', '0');
INSERT INTO `loot_items` VALUES ('5573', '90013', '90016', '55', '0', '1', '2', '0');
INSERT INTO `loot_items` VALUES ('5576', '90013', '90018', '2', '0', '1', '1', '0');

_________________________DATABASE_____________________

ingame .npc spawn 77777

[Mango Jerry]

Thanks for it Muskade.
Lottery is epic <3

[x6x6x6x]

man this is the best and most updated\stable release +rep for sure
btw: i will test and compare all of your emu's and i will upoad a table of features so ppl could compare by their own needs (the table will contain weaknesses and strength points

[eluzai777]

man this is the best and most updated\stable release +rep for sure
btw: i will test and compare all of your emu's and i will upoad a table of features so ppl could compare by their own needs (the table will contain weaknesses and strength points

Can you compare the emu cores for spells ? i want to know which core has the fewest spell bugs for classes.


Keazain this thread is getting better by the day. Great work! Thanks!

[snalle]

OMG keep the AWSOME WORK UP!!!!

[Muskade]

Keazain Morpher

____________________DATABASE__________________________

INSERT INTO creature_names
(`entry`, `name`, `subname`, `info_str`, `Flags1`, `type`, `family`, `rank`, `unk4`, `spelldataid`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`, `unknown_float1`, `unknown_float2`, `civilian`, `leader`)
VALUES
(88888, 'Keazain Morpher', 'Keazain Morpher', '', 0, 0, 0, 3, 0, 0, 24129, 0, 0, 0, 1, 1, 0, NULL);

INSERT INTO creature_proto
(`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `attacktype`, `mindamage`, `maxdamage`, `can_ranged`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `respawntime`, `armor`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `combat_reach`, `bounding_radius`, `auras`, `boss`, `money`, `invisibility_type`, `death_state`, `walk_speed`, `run_speed`, `fly_speed`, `extra_a9_flags`, `spell1`, `spell2`, `spell3`, `spell4`, `spell_flags`, `modImmunities`)
VALUES
(88888, 80, 80, 35, 100000, 100000, 100000, 1, 3, 0, 0, 7500, 2000, 0, 0, 0, 0, 360000, 2002, 0, 0, 0, 0, 0, 0, 1, 0, '', 0, 0, 0, 0, 2.5, 8, 14, 0, 0, 0, 0, 0, 0, 0);

____________________DATABASE__________________________




_________________________LUA__________________________

function morph_main_menu(pUnit, player)
pUnit:GossipCreateMenu(7544, player, 0)
pUnit:GossipMenuAddItem(1, "Humanoids Morphs 1", 6, 0)
pUnit:GossipMenuAddItem(1, "Humanoids Morphs 2", 7, 0)
pUnit:GossipMenuAddItem(1, "Fun Morphs", 9, 0)
pUnit:GossipSendMenu(player)
end

function morph_on_gossip_talk(pUnit, event, player)
morph_main_menu(pUnit, player)
end

function morph_on_gossip_select(pUnit, event, player, id, intid, code, pMisc)
if(intid == 6) then
pUnit:GossipCreateMenu(7543, player, 0)
pUnit:GossipMenuAddItem(1, "Dwarf - Female", 70, 0)
pUnit:GossipMenuAddItem(1, "Dwarf - Male", 71, 0)
pUnit:GossipMenuAddItem(1, "Orc - Female", 72, 0)
pUnit:GossipMenuAddItem(1, "Orc - Male", 73, 0)
pUnit:GossipMenuAddItem(1, "Nightelf - Female", 74, 0)
pUnit:GossipMenuAddItem(1, "Nightelf - Male", 75, 0)
pUnit:GossipMenuAddItem(1, "Dranei - Female", 76, 0)
pUnit:GossipMenuAddItem(1, "Troll - Male", 77, 0)
pUnit:GossipMenuAddItem(1, "Human Male", 78, 0)
pUnit:GossipMenuAddItem(1, "Tauren - Male", 79, 0)
pUnit:GossipMenuAddItem(1, "Deathknight - Female", 80, 0)
pUnit:GossipSendMenu(player)
end

if(intid == 7) then
pUnit:GossipCreateMenu(7543, player, 0)
pUnit:GossipMenuAddItem(1, "Undead -Male", 81, 0)
pUnit:GossipMenuAddItem(1, "Undead Pirate", 82, 0)
pUnit:GossipMenuAddItem(1, "Dranei Pirate", 83, 0)
pUnit:GossipMenuAddItem(1, "Dwarf Pirate", 84, 0)
pUnit:GossipMenuAddItem(1, "Gnome Pirate", 85, 0)
pUnit:GossipMenuAddItem(1, "Goblin Pirate", 86, 0)
pUnit:GossipMenuAddItem(1, "Human Pirate", 87, 0)
pUnit:GossipMenuAddItem(1, "Night Elf Pirate", 88, 0)
pUnit:GossipMenuAddItem(1, "Orc Pirate", 89, 0)
pUnit:GossipMenuAddItem(1, "Tauren Pirate", 90, 0)
pUnit:GossipMenuAddItem(1, "Troll Pirate", 91, 0)
pUnit:GossipSendMenu(player)
end
if(intid == 9) then
pUnit:GossipCreateMenu(7543, player, 0)
pUnit:GossipMenuAddItem(1, "Akama", 50, 0)
pUnit:GossipMenuAddItem(1, "Chinese Dragon", 51, 0)
pUnit:GossipMenuAddItem(1, "Demon Hunter", 52, 0)
pUnit:GossipMenuAddItem(1, "Diablo", 53, 0)
pUnit:GossipMenuAddItem(1, "Alliance Armored guy", 54, 0)
pUnit:GossipMenuAddItem(1, "Gryphon", 55, 0)
pUnit:GossipMenuAddItem(1, "Fel Elf Female Melee", 56, 0)
pUnit:GossipMenuAddItem(1, "Fel Elf Female Caster", 57, 0)
pUnit:GossipMenuAddItem(1, "Member of the Scarlet", 58, 0)
pUnit:GossipMenuAddItem(1, "Fire Dancer", 59, 0)
pUnit:GossipMenuAddItem(1, "Squeeky Gnome", 60, 0)
pUnit:GossipSendMenu(player)
end
if(intid == 50) then
player:SetModel(20681)
end
if(intid == 51) then
player:SetModel(14779)
end
if(intid == 52) then
player:SetModel(7570)
end
if(intid == 53) then
player:SetModel(10992)
end
if(intid == 54) then
player:SetModel(25575)
end
if(intid == 55) then
player:SetModel(25579)
end
if(intid == 56) then
player:SetModel(23225)
end
if(intid == 57) then
player:SetModel(22980)
end
if(intid == 5 then
player:SetModel(25506)
end
if(intid == 59) then
player:SetModel(23523)
end
if(intid == 60) then
player:SetModel(25029)
end
if(intid == 70) then
player:SetModel(25019)
end
if(intid == 71) then
player:SetModel(25023)
end
if(intid == 72) then
player:SetModel(25024)
end
if(intid == 73) then
player:SetModel(25020)
end
if(intid == 74) then
player:SetModel(25060)
end
if(intid == 75) then
player:SetModel(25022)
end
if(intid == 76) then
player:SetModel(2502
end
if(intid == 77) then
player:SetModel(25021)
end
if(intid == 7 then
player:SetModel(25059)
end
if(intid == 79) then
player:SetModel(25025)
end
if(intid == 80) then
player:SetModel(24694)
end
if(intid == 81) then
player:SetModel(25065)
end
if(intid == 82) then
player:SetModel(25042)
end
if(intid == 83) then
player:SetModel(25033)
end
if(intid == 84) then
player:SetModel(25034)
end
if(intid == 85) then
player:SetModel(25035)
end
if(intid == 86) then
player:SetModel(25036)
end
if(intid == 87) then
player:SetModel(25037)
end
if(intid == 8 then
player:SetModel(2503
end
if(intid == 89) then
player:SetModel(25059)
end
if(intid == 90) then
player:SetModel(25040)
end
if(intid == 91) then
player:SetModel(25041)
end

end

RegisterUnitGossipEvent(88888, 1, "morph_on_gossip_talk")
RegisterUnitGossipEvent(88888, 2, "morph_on_gossip_select")

_________________________LUA__________________________

save in script with name Morph.lua

[johnstone]

could some 1 give me a hand im tring 2 add a item 1 a vander thats in the game im saying this will looking at the vander .npc additem 38613
and its not working im yousing the updat core AreEmu_rev.1958
what am i doing rong?
how do i say it rite? any know ?

[johnstone]

Here Keazain Tier 7 Vendor

__________________________CODE START_______________________________

INSERT INTO `creature_names` (`entry`,`name`,`subname`,`info_str`,`type`,`spelldataid`,`male_displayid`,`fema le_displayid`,`civilian`,`leader`) VALUES ('444444',"Keazain Tier 7 Vendor",'Keazain Tier 7 Vendor','Keazain Tier 7 Vendor','10','0','19622','0','0','0');
insert into `creature_proto` (`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `attacktype`, `mindamage`, `maxdamage`, `can_ranged`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `respawntime`, `armor`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `combat_reach`, `bounding_radius`, `auras`, `boss`, `money`, `invisibility_type`, `death_state`, `walk_speed`, `run_speed`, `fly_speed`, `extra_a9_flags`, `spell1`, `spell2`, `spell3`, `spell4`, `spell_flags`, `modImmunities`) values('444444','80','80','35','5000000','5000000','0','1','4224','2000','0','39 ','55','0','0','0','0','360000','1212','0','0','0','0','0','0','1.5','0.306','0' ,'0','0','0','0','2.5','8','14','0','0','0','0','0','0','0');
INSERT INTO vendors(entry, item, amount) VALUES(444444, 39558, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 39560, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 39561, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 39564, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 39565, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 39578, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 39579, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 39580, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 39581, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 39582, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 39605, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 39606, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 39607, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 39608, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 39609, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 39610, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 39611, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 39612, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 39613, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 39622, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 39553, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 39554, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 39555, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 39556, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 39557, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 39544, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 39545, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 39546, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 39547, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 39548, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 39531, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 39538, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 39539, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 39542, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 39543, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 39592, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 39593, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 39594, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 39595, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 39596, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 39583, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 39588, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 39589, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 39590, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 39591, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 39491, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 39492, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 39493, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 39494, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 39495, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 39521, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 39523, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 39528, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 39529, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 39530, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 39496, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 39497, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 39498, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 39499, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 39500, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 39633, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 39634, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 39635, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 39636, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 39637, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 39638, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 39639, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 39640, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 39641, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 39642, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 39628, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 39629, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 39630, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 39631, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 39632, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 39514, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 39515, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 39517, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 39518, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 39519, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 39617, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 39618, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 39619, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 39620, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 39621, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 39623, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 39624, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 39625, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 39626, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 39627, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 40495, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 40496, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 40499, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 40500, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 40502, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 40503, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 40504, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 40505, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 40506, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 40507, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 40525, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 40527, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 40528, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 40529, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 40530, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 40544, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 40545, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 40546, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 40547, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 40548, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 40471, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 40472, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 40473, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 40493, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 40494, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 40466, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 40467, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 40468, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 40469, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 40470, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 40460, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 40461, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 40462, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 40463, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 40465, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 40514, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 40515, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 40516, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 40517, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 40518, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 40508, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 40509, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 40510, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 40512, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 40513, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 40415, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 40416, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 40417, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 40418, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 40419, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 40454, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 40456, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 40457, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 40458, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 40459, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 40420, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 40421, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 40422, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 40423, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 40424, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 40574, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 40575, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 40576, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 40577, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 40578, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 40579, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 40580, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 40581, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 40583, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 40584, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 40569, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 40570, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 40571, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 40572, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 40573, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 40445, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 40447, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 40448, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 40449, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 40450, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 40550, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 40552, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 40554, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 40556, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 40557, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 40559, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 40563, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 40565, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 40567, 1);
INSERT INTO vendors(entry, item, amount) VALUES(444444, 40568, 1);

__________________________CODE END_______________________________

ok i made a sql file for this and i ran it and its saying unkonwn columm female_displayid in field list.....>>?any thiots?

[johnstone]

this time i get told 88888 duplicate hum i tink ill chang it add a digest see if this fixes it i hoipe so i see at the botom u have
RegisterUnitGossipEvent(88888, 1, "morph_on_gossip_talk")
RegisterUnitGossipEvent(88888, 2, "morph_on_gossip_select")
is this the dup?

Keazain Morpher

____________________DATABASE__________________________

INSERT INTO creature_names
(`entry`, `name`, `subname`, `info_str`, `Flags1`, `type`, `family`, `rank`, `unk4`, `spelldataid`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`, `unknown_float1`, `unknown_float2`, `civilian`, `leader`)
VALUES
(88888, 'Keazain Morpher', 'Keazain Morpher', '', 0, 0, 0, 3, 0, 0, 24129, 0, 0, 0, 1, 1, 0, NULL);

INSERT INTO creature_proto
(`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `attacktype`, `mindamage`, `maxdamage`, `can_ranged`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `respawntime`, `armor`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `combat_reach`, `bounding_radius`, `auras`, `boss`, `money`, `invisibility_type`, `death_state`, `walk_speed`, `run_speed`, `fly_speed`, `extra_a9_flags`, `spell1`, `spell2`, `spell3`, `spell4`, `spell_flags`, `modImmunities`)
VALUES
(88888, 80, 80, 35, 100000, 100000, 100000, 1, 3, 0, 0, 7500, 2000, 0, 0, 0, 0, 360000, 2002, 0, 0, 0, 0, 0, 0, 1, 0, '', 0, 0, 0, 0, 2.5, 8, 14, 0, 0, 0, 0, 0, 0, 0);

____________________DATABASE__________________________




_________________________LUA__________________________

function morph_main_menu(pUnit, player)
pUnit:GossipCreateMenu(7544, player, 0)
pUnit:GossipMenuAddItem(1, "Humanoids Morphs 1", 6, 0)
pUnit:GossipMenuAddItem(1, "Humanoids Morphs 2", 7, 0)
pUnit:GossipMenuAddItem(1, "Fun Morphs", 9, 0)
pUnit:GossipSendMenu(player)
end

function morph_on_gossip_talk(pUnit, event, player)
morph_main_menu(pUnit, player)
end

function morph_on_gossip_select(pUnit, event, player, id, intid, code, pMisc)
if(intid == 6) then
pUnit:GossipCreateMenu(7543, player, 0)
pUnit:GossipMenuAddItem(1, "Dwarf - Female", 70, 0)
pUnit:GossipMenuAddItem(1, "Dwarf - Male", 71, 0)
pUnit:GossipMenuAddItem(1, "Orc - Female", 72, 0)
pUnit:GossipMenuAddItem(1, "Orc - Male", 73, 0)
pUnit:GossipMenuAddItem(1, "Nightelf - Female", 74, 0)
pUnit:GossipMenuAddItem(1, "Nightelf - Male", 75, 0)
pUnit:GossipMenuAddItem(1, "Dranei - Female", 76, 0)
pUnit:GossipMenuAddItem(1, "Troll - Male", 77, 0)
pUnit:GossipMenuAddItem(1, "Human Male", 78, 0)
pUnit:GossipMenuAddItem(1, "Tauren - Male", 79, 0)
pUnit:GossipMenuAddItem(1, "Deathknight - Female", 80, 0)
pUnit:GossipSendMenu(player)
end

if(intid == 7) then
pUnit:GossipCreateMenu(7543, player, 0)
pUnit:GossipMenuAddItem(1, "Undead -Male", 81, 0)
pUnit:GossipMenuAddItem(1, "Undead Pirate", 82, 0)
pUnit:GossipMenuAddItem(1, "Dranei Pirate", 83, 0)
pUnit:GossipMenuAddItem(1, "Dwarf Pirate", 84, 0)
pUnit:GossipMenuAddItem(1, "Gnome Pirate", 85, 0)
pUnit:GossipMenuAddItem(1, "Goblin Pirate", 86, 0)
pUnit:GossipMenuAddItem(1, "Human Pirate", 87, 0)
pUnit:GossipMenuAddItem(1, "Night Elf Pirate", 88, 0)
pUnit:GossipMenuAddItem(1, "Orc Pirate", 89, 0)
pUnit:GossipMenuAddItem(1, "Tauren Pirate", 90, 0)
pUnit:GossipMenuAddItem(1, "Troll Pirate", 91, 0)
pUnit:GossipSendMenu(player)
end
if(intid == 9) then
pUnit:GossipCreateMenu(7543, player, 0)
pUnit:GossipMenuAddItem(1, "Akama", 50, 0)
pUnit:GossipMenuAddItem(1, "Chinese Dragon", 51, 0)
pUnit:GossipMenuAddItem(1, "Demon Hunter", 52, 0)
pUnit:GossipMenuAddItem(1, "Diablo", 53, 0)
pUnit:GossipMenuAddItem(1, "Alliance Armored guy", 54, 0)
pUnit:GossipMenuAddItem(1, "Gryphon", 55, 0)
pUnit:GossipMenuAddItem(1, "Fel Elf Female Melee", 56, 0)
pUnit:GossipMenuAddItem(1, "Fel Elf Female Caster", 57, 0)
pUnit:GossipMenuAddItem(1, "Member of the Scarlet", 58, 0)
pUnit:GossipMenuAddItem(1, "Fire Dancer", 59, 0)
pUnit:GossipMenuAddItem(1, "Squeeky Gnome", 60, 0)
pUnit:GossipSendMenu(player)
end
if(intid == 50) then
player:SetModel(20681)
end
if(intid == 51) then
player:SetModel(14779)
end
if(intid == 52) then
player:SetModel(7570)
end
if(intid == 53) then
player:SetModel(10992)
end
if(intid == 54) then
player:SetModel(25575)
end
if(intid == 55) then
player:SetModel(25579)
end
if(intid == 56) then
player:SetModel(23225)
end
if(intid == 57) then
player:SetModel(22980)
end
if(intid == 5 then
player:SetModel(25506)
end
if(intid == 59) then
player:SetModel(23523)
end
if(intid == 60) then
player:SetModel(25029)
end
if(intid == 70) then
player:SetModel(25019)
end
if(intid == 71) then
player:SetModel(25023)
end
if(intid == 72) then
player:SetModel(25024)
end
if(intid == 73) then
player:SetModel(25020)
end
if(intid == 74) then
player:SetModel(25060)
end
if(intid == 75) then
player:SetModel(25022)
end
if(intid == 76) then
player:SetModel(2502
end
if(intid == 77) then
player:SetModel(25021)
end
if(intid == 7 then
player:SetModel(25059)
end
if(intid == 79) then
player:SetModel(25025)
end
if(intid == 80) then
player:SetModel(24694)
end
if(intid == 81) then
player:SetModel(25065)
end
if(intid == 82) then
player:SetModel(25042)
end
if(intid == 83) then
player:SetModel(25033)
end
if(intid == 84) then
player:SetModel(25034)
end
if(intid == 85) then
player:SetModel(25035)
end
if(intid == 86) then
player:SetModel(25036)
end
if(intid == 87) then
player:SetModel(25037)
end
if(intid == 8 then
player:SetModel(2503
end
if(intid == 89) then
player:SetModel(25059)
end
if(intid == 90) then
player:SetModel(25040)
end
if(intid == 91) then
player:SetModel(25041)
end

end

RegisterUnitGossipEvent(88888, 1, "morph_on_gossip_talk")
RegisterUnitGossipEvent(88888, 2, "morph_on_gossip_select")

_________________________LUA__________________________

save in script with name Morph.lua

[Muskade]

Change all 88888 for anything in sql an lua

[johnstone]

and could some 1 tell me how 2 add in the t7 things yousing sqlyog? whar do thay go walkthro?and 1 for the modify wepand 1 may b 4 skill for all charaacters? yes i know what a noob im learning what can i say u show i dont for get nexst time i need 2 edit it i will know how ...thank u all that help me ill+rep any 1 that trys 2 help me

[Muskade]

Keazain Buffer, Healer & remove Sickness

________________________DATABASE____________________________

INSERT INTO creature_names
(`entry`, `name`, `subname`, `info_str`, `Flags1`, `type`, `family`, `rank`, `unk4`, `spelldataid`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`, `unknown_float1`, `unknown_float2`, `civilian`, `leader`)
VALUES
(99999, 'Keazain Buffer-Healer', 'Keazain Buffer-Healer', '', 0, 0, 0, 3, 0, 0, 24804, 0, 0, 0, 1, 1, 0, NULL);

INSERT INTO creature_proto
(`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `attacktype`, `mindamage`, `maxdamage`, `can_ranged`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `respawntime`, `armor`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `combat_reach`, `bounding_radius`, `auras`, `boss`, `money`, `invisibility_type`, `death_state`, `walk_speed`, `run_speed`, `fly_speed`, `extra_a9_flags`, `spell1`, `spell2`, `spell3`, `spell4`, `spell_flags`, `modImmunities`)
VALUES
(99999, 80, 80, 35, 100000, 100000, 100000, 1, 3, 0, 0, 7500, 2000, 0, 0, 0, 0, 360000, 2002, 0, 0, 0, 0, 0, 0, 1, 0, '', 0, 0, 0, 0, 2.5, 8, 14, 0, 0, 0, 0, 0, 0, 0);

________________________DATABASE____________________________


___________________________LUA______________________________


function buff_main_menu(pUnit, player)
pUnit:GossipCreateMenu(8544, player, 0)
pUnit:GossipMenuAddItem(5, "Buff's.", 1, 0)
pUnit:GossipMenuAddItem(9, "Remove Rez Sickness", 2, 0)
pUnit:GossipMenuAddItem(4, "Heal", 90, 0)
pUnit:GossipSendMenu(player)
end

function buff_on_gossip_talk(pUnit, event, player)
buff_main_menu(pUnit, player)
end

function buff_on_gossip_select(pUnit, event, player, id, intid, code, pMisc)
if (intid == 1) then
pUnit:GossipCreateMenu(99, player, 0)
pUnit:GossipMenuAddItem(3, "Agility", 3, 0)
pUnit:GossipMenuAddItem(3, "Intellect", 4, 0)
pUnit:GossipMenuAddItem(3, "Protection", 5, 0)
pUnit:GossipMenuAddItem(3, "Spirit", 6, 0)
pUnit:GossipMenuAddItem(3, "Stamina", 7, 0)
pUnit:GossipMenuAddItem(3, "Strength", 8, 0)
pUnit:GossipSendMenu(player)
end

if (intid == 2) then
player:UnlearnSpell(15007)
pUnit:GossipComplete(player)
end

if (intid == 3) then
pUnit:FullCastSpellOnTarget(33077, player)
pUnit:GossipComplete(player)
end

if (intid == 4) then
pUnit:FullCastSpellOnTarget(33078, player)
pUnit:GossipComplete(player)
end

if (intid == 5) then
pUnit:FullCastSpellOnTarget(33079, player)
pUnit:GossipComplete(player)
end

if (intid == 6) then
pUnit:FullCastSpellOnTarget(33080, player)
pUnit:GossipComplete(player)
end

if (intid == 7) then
pUnit:FullCastSpellOnTarget(33081, player)
pUnit:GossipComplete(player)
end

if (intid == then
pUnit:FullCastSpellOnTarget(33082, player)
pUnit:GossipComplete(player)
end

if (intid == 90) then
pUnit:GossipCreateMenu(3543, player, 0)
pUnit:GossipMenuAddItem(4, "Health", 91, 0)
pUnit:GossipSendMenu(player)
end

if (intid == 91) then
pUnit:FullCastSpellOnTarget(25213,player)
pUnit:GossipComplete()
end

end

RegisterUnitGossipEvent(99999, 1, "buff_on_gossip_talk")
RegisterUnitGossipEvent(99999, 2, "buff_on_gossip_select")

___________________________LUA______________________________

save in script Buff.lua

.npc spawn 99999