Novo's Easy Trinity Emulator

01/18/2010 17:40 Sevenface#226
Bei mir genauso wollte npc vendor einfügen (Finished - unsuccessfully) aber warum als was muss man das auch donwloaden ? mangos oder ?

[Err] 1054 - Unknown column 'modelid_A' in 'field list'
[Err] insert into `creature_template` (`entry`, `modelid_A`, `modelid_A2`, `modelid_H`, `modelid_H2`, `name`, `subname`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed`, `scale`, `rank`, `mindmg`, `maxdmg`, `baseattacktime`, `family`, `type`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `mingold`, `maxgold`)
values ('134123', '10979', '0', '0', '0', "Vendor T5", "LumixServer", '255', '255', '100000', '100001', '10001', '10001', '10000', '35', '35', '129', '8.00', '1', '0', '1000000', '1000001', '100', '0', '10', '0', '0', '0', '0', '0', '0', '0', '0');
[Msg] Finished - Unsuccessfully
01/19/2010 13:19 Myst1C#227
[Err] 1146 - Table 'world.creature_names' doesn't exist
[Err] 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 ('100003', "Taxi", "BloodyWater", '', '0', '1', '1', '0', '0', '0', ' 24191', '0', '0', '0', '1', '1', '1', '0');
[Err] 1146 - Table 'world.creature_proto' doesn't exist
[Err] 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 ('100003', '1', '255', '35', '24191', '24191', '24191', '1', '14889203', '100', '0', '24191', '24191', '0', '0', '0', '0', '61000', '24191', '24191', '24191', '24191', '24191', '24191', '24191', '0', '0', "0", '1', '10101', '0', '0', '2.50', '8.00', '14.00', '0', '0', '0', '0', '0', '0', '0');
[Msg] Finished - Unsuccessfully
--------------------------------------------------

//ArcEmu < v2976

[Err] 1146 - Table 'world.creature_names' doesn't exist
[Err] insert into `creature_names` (`entry`, `name`, `subname`, `info_str`, `Flags1`, `type`, `family`, `rank`, `killcredit1`, `killcredit2`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`, `unknown_float1`, `unknown_float2`, `leader`)
values ('100003', "Taxi", "BloodyWater", '', '0', '1', '1', '0', '0', '0', ' 24191', '0', '0', '0', '1', '1', '0');
[Err] 1146 - Table 'world.creature_proto' doesn't exist
[Err] 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`, `summonguard`)
values ('100003', '1', '255', '35', '24191', '24191', '24191', '1', '14889203', '100', '0', '24191', '24191', '0', '0', '0', '0', '61000', '24191', '24191', '24191', '24191', '24191', '24191', '24191', '0', '0', "0", '1', '10101', '0', '0', '2.50', '8.00', '14.00', '0', '0', '0', '0', '0', '0', '0', '1');
[Msg] Finished - Unsuccessfully
--------------------------------------------------

//ArcEmu > v2976

[Err] 1146 - Table 'world.creature_names' doesn't exist
[Err] 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 ('100003', "Taxi", "BloodyWater", '', '0', '1', '1', '0', '0', '0', ' 24191', '0', '0', '0', '1', '1', '1', '0');
[Err] 1146 - Table 'world.creature_proto' doesn't exist
[Err] insert into `creature_proto` (`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `attacktype`, `mindamage`, `maxdamage`, `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`)
values ('100003', '1', '255', '35', '24191', '24191', '24191', '1', '14889203', '100', '0', '24191', '24191', '0', '0', '0', '61000', '24191', '24191', '24191', '24191', '24191', '24191', '24191', '0', '0', "0", '1', '10101', '0', '0', '2.50', '8.00', '14.00', '0');
[Msg] Finished - Unsuccessfully
--------------------------------------------------

//Ascent

[Err] 1146 - Table 'world.creature_names' doesn't exist
[Err] 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 ('100003', "Taxi", "BloodyWater", '', '0', '1', '1', '0', '0', '0', ' 24191', '0', '0', '0', '1', '1', '1', '0');
[Err] 1146 - Table 'world.creature_proto' doesn't exist
[Err] insert into `creature_proto` (`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `attacktype`, `mindamage`, `maxdamage`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `RespawnTime`, `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`)
values ('100003', '1', '255', '35', '24191', '24191', '24191', '1', '14889203', '100', '0', '24191', '24191', '0', '0', '0', '61000', '24191', '24191', '24191', '24191', '24191', '24191', '0', '0', "0", '1', '10101', '0', '0', '2.50', '8.00', '14.00', '0');
[Msg] Finished - Unsuccessfully
--------------------------------------------------

//Aspire

[Err] 1054 - Unknown column 'modelid_A' in 'field list'
[Err] insert into `creature_template` (`entry`, `modelid_A`, `modelid_A2`, `modelid_H`, `modelid_H2`, `name`, `subname`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed`, `scale`, `rank`, `mindmg`, `maxdmg`, `baseattacktime`, `family`, `type`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `mingold`, `maxgold`)
values ('100003', ' 24191', '0', '0', '0', "Taxi", "BloodyWater", '1', '255', '24191', '24191', '24191', '24191', '24191', '35', '35', '14889203', '8.00', '1', '0', '24191', '24191', '100', '1', '1', '24191', '24191', '24191', '24191', '24191', '24191', '10101', '10101');
[Msg] Finished - Unsuccessfully
--------------------------------------------------

//MaNGOS

Also bei mir gehts bei keinem.
01/21/2010 21:53 panoxy#228
Hier ein auszug von einem Mangos (beispiel)

REPLACE INTO `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `modelid_A`, `modelid_A2`, `modelid_H`, `modelid_H2`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacktime`, `unit_class`, `unit_flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `PetSpellDataId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `unk16`, `unk17`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `movementId`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`) VALUES (1234, 0, 0, 0, 0, 0, 3436, 0, 3436, 0, 'Hogral Bakkan', 'Rogue Trainer', '', 0, 12, 12, 247, 247, 0, 0, 563, 55, 55, 51, 0.97, 1, 0, 13, 19, 0, 5, 1, 2000, 2000, 1, 512, 0, 0, 0, 0, 4, 0, 10, 15, 4, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 4, 0, 2, '');
01/21/2010 22:12 panoxy#229
Ein NPC Vendor geht so. Mangos!

DELETE FROM `npc_vendor` WHERE (`entry`=155000);
INSERT INTO `npc_vendor` (entry, item, maxcount, incrtime, ExtendedCost) VALUES
(155000, 16666, 0, 0, 0),
(155000, 16667, 0, 0, 0);

Der vendor hat zb. 2 Items anzubieten. Die kosten, wert, name des Items, stabelbar, ect....sieht dann so aus. (DisplayID wäre dann 31416)

REPLACE INTO `item_template` (`entry`, `class`, `subclass`, `unk0`, `name`, `displayid`, `Quality`, `Flags`, `Faction`, `BuyCount`, `BuyPrice`, `SellPrice`, `InventoryType`, `AllowableClass`, `AllowableRace`, `ItemLevel`, `RequiredLevel`, `RequiredSkill`, `RequiredSkillRank`, `requiredspell`, `requiredhonorrank`, `RequiredCityRank`, `RequiredReputationFaction`, `RequiredReputationRank`, `maxcount`, `stackable`, `ContainerSlots`, `StatsCount`, `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`, `ScalingStatDistribution`, `ScalingStatValue`, `dmg_min1`, `dmg_max1`, `dmg_type1`, `dmg_min2`, `dmg_max2`, `dmg_type2`, `armor`, `holy_res`, `fire_res`, `nature_res`, `frost_res`, `shadow_res`, `arcane_res`, `delay`, `ammo_type`, `RangedModRange`, `spellid_1`, `spelltrigger_1`, `spellcharges_1`, `spellppmRate_1`, `spellcooldown_1`, `spellcategory_1`, `spellcategorycooldown_1`, `spellid_2`, `spelltrigger_2`, `spellcharges_2`, `spellppmRate_2`, `spellcooldown_2`, `spellcategory_2`, `spellcategorycooldown_2`, `spellid_3`, `spelltrigger_3`, `spellcharges_3`, `spellppmRate_3`, `spellcooldown_3`, `spellcategory_3`, `spellcategorycooldown_3`, `spellid_4`, `spelltrigger_4`, `spellcharges_4`, `spellppmRate_4`, `spellcooldown_4`, `spellcategory_4`, `spellcategorycooldown_4`, `spellid_5`, `spelltrigger_5`, `spellcharges_5`, `spellppmRate_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`, `RequiredDisenchantSkill`, `ArmorDamageModifier`, `Duration`, `ItemLimitCategory`, `HolidayId`, `ScriptName`, `DisenchantID`, `FoodType`, `minMoneyLoot`, `maxMoneyLoot`) VALUES (16666, 4, 3, -1, 'Vest of Elements', 31416, 3, 0, 0, 1, 161841, 32368, 5, -1, -1, 63, 58, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 3, 5, 20, 6, 20, 7, 13, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 370, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 1, '', 0, 0, 0, 0, 0, 5, 0, 0, 0, 0, 187, 120, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 225, 0, 0, 0, 0, '', 16666, 0, 0, 0);
01/22/2010 21:05 HiJack3r57#230
kann mir jemand sagen wie ich das auf hamachi umstelle ?
kenn mich leider nicht so aus damit
01/24/2010 09:54 SuZz#231
Du gehst bei deinem Mangos menü, Auf connect optionen / da steht Connect IP da gibst du deine Hamachi ip ein, und fertig
01/24/2010 17:53 .$am#232
Novo 1Klick server Neue Version Test^^
So ich habe mal die neue Version getestet und ich muss sagen es gibt ganz kleine macken an der db aber ansonsten is er grade einfach nur geil^^
Habe jetzt jeden Spell getestet und es funkt zu 100%
Dk Quest 100%
ICC noch nicht ausprobiert
Andere Instanzen 100%
#Edit: Acc Page Funtzt

Daumen hoch xD
01/26/2010 19:15 Fischtheripper#233
Hallo
Ich würde gerne wissen, ob es eine Liste mit Coords gibt, die auch aktuell ist und funktioniert. Besonders im Vordergrund steht Icc, wo ich leider nur den Bereich der ersten 4 Bosse sehen kann und den Rest leider nicht erreiche.

Gruß
Fisch
01/29/2010 12:04 x0re#234
hey, hab ein kleines problem, und zwar, wenn ich die raten ändern will, gehen sie, aber wenn ich dann novos starter neustarte, sind die raten wieder auf 1, wie kann ich die dauerhaft ändern? :S
01/29/2010 14:09 mmaaaxxxx#235
Soweit ich weiss stellt sich nur die Anzeige wieder auf 1, der Wert bleibt solange du da nicht neu rumfuscht
02/02/2010 17:00 .Bloodseeker#236
Omg du bist der beste xD
02/02/2010 20:34 Gularsch#237
Huhu,

die Erstellung und Installation meines Server verlief völlig problemlos. Deshalb mal ein großes Lob!

Ich kann mich einloggen, aber kein Realm auswählen, bzw. es steht nichts zur Auswahl, was mache ich falsch?

Wenn ich meinen Server starte, kommt vor "Apache Server is starting" die Meldung "Zugriff verweigert"

Hat das mit dem Apache Server vllt. was mit dem Realm zu tun?
02/02/2010 21:33 .$am#238
Das hat nichts mit Apache zu tun
Und mach dir keinen Kopf wegen der meldung "Zugriff Verweigert" das heißt nur das deine Firewall apache blockt^^
Ich hatte am anfang genau das gleiche problem deinstalliere novo nomma und installier ihn wieder dann müsste es funtzten ^^
02/03/2010 15:48 Gularsch#239
Habs neu installiert, immer noch keine Realm!
02/03/2010 16:24 .$am#240
Haste NetF ^^ ?