Unsuccesfully

Go down

Unsuccesfully

Post by cascade124 on Sun Sep 20, 2015 10:41 am

hi, i am new on scripting and stuff and i am hosting a trinity 3.3.5 wow server 24/7.

when im trying to insert the portal master everytime came this error.

[Err] 1054 - Unknown column 'faction' in 'field list'
[Err] /*
TrinityCore Portal Master
By Rochet2
Downloaded from http://rochet2.github.io/
Bugs and contact with E-mail: Rochet2@post.com
*/

SET
@ENTRY          := 190000,
@NAME           := "Portal Master",
@SUBNAME        := "",
@MODEL          := 21572,

@AURA           := "30540", -- "35766" = casting

@TEXT_ID        := 300000,
@GOSSIP_MENU    := 50000,

@RUNE           := 194394;

-- Deleting code

DELETE FROM creature_template WHERE entry = @ENTRY;
DELETE FROM creature_template_addon WHERE Entry = @ENTRY ;
DELETE FROM gossip_menu WHERE entry BETWEEN @GOSSIP_MENU AND @GOSSIP_MENU+8;
DELETE FROM npc_text WHERE ID BETWEEN @TEXT_ID AND @TEXT_ID+4;
DELETE FROM gossip_menu_option WHERE menu_id BETWEEN @GOSSIP_MENU AND @GOSSIP_MENU+8;
DELETE FROM smart_scripts WHERE entryorguid = @ENTRY AND source_type = 0;
DELETE FROM conditions WHERE (SourceTypeOrReferenceId = 15 OR SourceTypeOrReferenceId = 14) AND SourceGroup BETWEEN @GOSSIP_MENU AND @GOSSIP_MENU+8;
DELETE from creature WHERE ID = @ENTRY;
DELETE from gameobject WHERE ID = @RUNE AND guid >= 200000;

-- Teleporter

INSERT INTO creature_template (entry, modelid1, name, subname, IconName, gossip_menu_id, minlevel, maxlevel, faction, npcflag, speed_walk, speed_run, scale, rank, unit_class, unit_flags, type, type_flags, InhabitType, RegenHealth, flags_extra, AiName) VALUES
(@ENTRY, @MODEL, @NAME, @SUBNAME, "Directions", @GOSSIP_MENU, 71, 71, 35, 3, 1, 1.14286, 1.25, 1, 1, 2, 7, 138936390, 3, 1, 2, "SmartAI");

-- Teleporter aura

INSERT INTO creature_template_addon (entry, mount, bytes1, bytes2, emote, path_id, auras) VALUES (@ENTRY, 0, 0, 0, 0, 0, @AURA);

-- Gossip header text link to menus

INSERT INTO gossip_menu (entry, text_id) VALUES
(@GOSSIP_MENU+4, @TEXT_ID+3),
(@GOSSIP_MENU+3, @TEXT_ID+2),
(@GOSSIP_MENU+2, @TEXT_ID+2),
(@GOSSIP_MENU+1, @TEXT_ID+2),
(@GOSSIP_MENU+8, @TEXT_ID+4),
(@GOSSIP_MENU+7, @TEXT_ID+4),
(@GOSSIP_MENU+6, @TEXT_ID+4),
(@GOSSIP_MENU+5, @TEXT_ID+4),
(@GOSSIP_MENU, @TEXT_ID+1),
(@GOSSIP_MENU, @TEXT_ID);

-- Gossip header texts

INSERT INTO npc_text (ID, text0_0, em0_1) VALUES
(@TEXT_ID+4, "$BWhere would you like to be ported?$B", 0),
(@TEXT_ID+3, "$BBe careful with choosing raids, I won't be there if you wipe.$B", 0),
(@TEXT_ID+2, "$BUp for some dungeon exploring?$B", 0),
(@TEXT_ID+1, "$B For The Alliance!$B", 6),
(@TEXT_ID,  "$B For the Horde!$B", 6);

-- Conditions for gossip option and menu factions

INSERT INTO conditions (SourceTypeOrReferenceId, SourceGroup, SourceEntry, ConditionTypeOrReference, ConditionValue1, Comment) VALUES
(15, @GOSSIP_MENU, 1, 6, 469, "Stormwind"),
(15, @GOSSIP_MENU+5, 2, 6, 469, "Dun Morogh"),
(15, @GOSSIP_MENU+5, 3, 6, 67, "Tirisfal Glades"),
(15, @GOSSIP_MENU+5, 4, 6, 67, "Ghostlands"),
(15, @GOSSIP_MENU+5, 5, 6, 469, "Loch modan"),
(15, @GOSSIP_MENU+5, 6, 6, 67, "Silverpine Forest"),
(15, @GOSSIP_MENU+5, 7, 6, 469, "Westfall"),
(15, @GOSSIP_MENU+5, 8, 6, 469, "Redridge mountains"),
(15, @GOSSIP_MENU+5, 9, 6, 469, "Duskwood"),
(15, @GOSSIP_MENU+5, 11, 6, 469, "Wetlands"),
(15, @GOSSIP_MENU+6, 0, 6, 469, "Azuremyst Isle"),
(15, @GOSSIP_MENU+6, 1, 6, 469, "Teldrassil"),
(15, @GOSSIP_MENU+6, 2, 6, 67, "Durotar"),
(15, @GOSSIP_MENU+6, 3, 6, 67, "Mulgore"),
(15, @GOSSIP_MENU+6, 4, 6, 469, "Bloodmyst Isle"),
(15, @GOSSIP_MENU+6, 5, 6, 469, "Darkshore"),
(15, @GOSSIP_MENU+6, 6, 6, 67, "The Barrens"),
(15, @GOSSIP_MENU+5, 1, 6, 67, "Eversong Woods"),
(15, @GOSSIP_MENU+5, 0, 6, 469, "Elwynn Forest"),
(15, @GOSSIP_MENU+4, 22, 6, 67, "Zul'Aman"),
(15, @GOSSIP_MENU, 2, 6, 67, "Orgrimmar"),
(15, @GOSSIP_MENU, 3, 6, 469, "Darnassus"),
(15, @GOSSIP_MENU, 4, 6, 469, "Ironforge"),
(15, @GOSSIP_MENU, 5, 6, 469, "Exodar"),
(15, @GOSSIP_MENU, 6, 6, 67, "Thunder bluff"),
(15, @GOSSIP_MENU, 7, 6, 67, "Undercity"),
(15, @GOSSIP_MENU, 8, 6, 67, "Silvermoon city"),
(15, @GOSSIP_MENU+1, 0, 6, 469, "Gnomeregan"),
(15, @GOSSIP_MENU+1, 1, 6, 469, "The Deadmines"),
(15, @GOSSIP_MENU+1, 2, 6, 469, "The Stockade"),
(15, @GOSSIP_MENU+1, 3, 6, 67, "Ragefire Chasm"),
(15, @GOSSIP_MENU+1, 4, 6, 67, "Razorfen Downs"),
(15, @GOSSIP_MENU+1, 5, 6, 67, "Raz
[Msg] Finished - Unsuccessfully


Portal master options works. Please need help ...

cascade124

Viestien lukumäärä : 1
Join date : 2015-09-20

Back to top Go down

Re: Unsuccesfully

Post by Rochet2 on Fri Nov 06, 2015 10:48 am

You are either not using TrinityCore or you are using too old version of it.
avatar
Rochet2
Admin

Viestien lukumäärä : 196
Join date : 2010-02-04

http://emuproject.bbflash.net

Back to top Go down

Back to top


 
Permissions in this forum:
You cannot reply to topics in this forum