Register for your free account! | Forgot your password?

Go Back   elitepvpers > World of Warcraft > WoW Private Server > WoW PServer Hosting
You last visited: Today at 02:50

  • Please register to post and access all features, it's quick, easy and FREE!

 

Teleporte geht nicht mehr [Trinity 3.3.5a]

Reply
 
Old   #1
 
elite*gold: 0
Join Date: Apr 2011
Posts: 63
Received Thanks: 3
Teleporte geht nicht mehr [Trinity 3.3.5a]

Hey leute

ich habe mal an nem telporter gebastelt ... und joa der funzte auch ... bis vor kurzen -.- ... ich poste mal ein teil der zusammen gehört hir rein ... villeicht kann mir einer von euch helfen oder n rechtschreib fehler finden den ich gemacht habe :3 ... eingebatcht wird er ohne fehler und ingame steht auch das gossip fehler frei und funktionstüchtig :3

danke im vorraus

creature_template

gossip_menu_option

smart_scripts



wow-player is offline  
Old   #2
 
elite*gold: 0
Join Date: Aug 2013
Posts: 31
Received Thanks: 5
Hallo wow-player

Wenn du willst, kannst du mich über Skype kontaktieren, dann kann ich dir besser helfen bzw. kann dir einen Teleport NPC über SmartAI schreiben und dir dann die sql ausgeben.

Mit freundlichen Grüßen

Damien


Damien132 is offline  
Old   #3
 
elite*gold: 0
Join Date: Apr 2011
Posts: 63
Received Thanks: 3
ja also eig hat es bei mir immer super geklappt xD aber jetzt nimmt er es nicht mehr an ... why auch immer ._.
wow-player is offline  
Old   #4
 
elite*gold: 2693
Join Date: Jul 2010
Posts: 6,449
Received Thanks: 1,224
Quote:
INSERT INTO smart_scripts (entryorguid, source_type, id, link, event_type, event_phase_mask, event_chance, event_flags, event_param1, event_param2, event_param3, event_param4, action_type, action_param1, action_param2, action_param3, action_param4, action_param5, action_param6, target_type, target_param1, target_param2, target_param3, target_x, target_y, target_z, target_o, comment) VALUES

('60000', 0, 1, 0, 62, 0, 100, 0, '60001', 1, 0, 0, 62, 0, 0, 0, 0, 0, 0, 0, 8, 0, 0, -8842.09, 626.358, 94.0867, 3.61363, 'Teleporter script'),
Das Rote zu 60000, dann funktionierts.


°"Crazy"° is offline  
Old   #5
 
elite*gold: 0
Join Date: Apr 2011
Posts: 63
Received Thanks: 3
hmmm geht trotzdem nicht :/
wow-player is offline  
Old   #6
 
elite*gold: 0
Join Date: Aug 2013
Posts: 31
Received Thanks: 5
NSERT INTO smart_scripts (entryorguid, source_type, id, link, event_type, event_phase_mask, event_chance, event_flags, event_param1, event_param2, event_param3, event_param4, action_type, action_param1, action_param2, action_param3, action_param4, action_param5, action_param6, target_type, target_param1, target_param2, target_param3, target_x, target_y, target_z, target_o, comment) VALUES

('60000', 0, 1, 0, 62, 0, 100, 0, '60000', 1, 0, 0, 62, 0, 0, 0, 0, 0, 0, 0, 8, 0, 0, -8842.09, 626.358, 94.0867, 3.61363, 'Teleporter script'),

Mach das Rote (die 8) zu einer 7
Sollte für Targettype stehen
8 wäre Position
7 ist Action Invoker

Dann sollte es gehen
Damien132 is offline  
Old   #7
 
elite*gold: 0
Join Date: Apr 2011
Posts: 63
Received Thanks: 3
hat nix geändert :/
wow-player is offline  
Old   #8
 
elite*gold: 2693
Join Date: Jul 2010
Posts: 6,449
Received Thanks: 1,224
Poste dich mal dein komplettes Script. Nur einen Auszug posten, das ist fail. Bitte nutze die [code] - Tags, wenn du noch Hilfe brauchst.
°"Crazy"° is offline  
Old   #9
 
elite*gold: 0
Join Date: Apr 2011
Posts: 63
Received Thanks: 3
Code:
DELETE FROM creature_template WHERE entry = '60000';

INSERT INTO creature_template (entry, modelid1, name, subname, IconName, gossip_menu_id, minlevel, maxlevel, Health_mod, Mana_mod, Armor_mod, faction_A, faction_H, npcflag, speed_walk, speed_run, scale, rank, dmg_multiplier, unit_class, unit_flags, type, type_flags, InhabitType, RegenHealth, flags_extra, AiName) VALUES
('60000', '5233', "Teleporter", "test", 'Directions', '60000', 71, 71, 1.56, 1.56, 1.56, 35, 35, 3, 1, 1.14286, 1, 1, 1, 1, 2, 7, 138936390, 3, 1, 2, 'SmartAI');


DELETE FROM gossip_menu_option WHERE menu_id>'59999' AND menu_id<'60008';
DELETE FROM smart_scripts WHERE entryorguid = '60000';


INSERT INTO gossip_menu_option (menu_id, id, option_icon, option_text, option_id, npc_option_npcflag, action_menu_id, action_poi_id, box_coded, box_money, box_text) VALUES
('60000', 1, 2, 'Playertreff', 1, 1, '', 0, 0, 0, ''),
('60000', 2, 3, 'Haupt horde', 1, 1, '60001', 0, 0, 0, ''),
('60000', 3, 3, 'haupt alli', 1, 1, '60002', 0, 0, 0, ''),
('60000', 4, 3, 'Level Arena', 1, 1, '60003', 0, 0, 0, ''),
('60000', 5, 3, 'Instanzen', 1, 1, '60004', 0, 0, 0, ''),
('60000', 6, 3, 'Events', 1, 1, '60005', 0, 0, 0, ''),
('60000', 7, 3, 'PvP-Arenen', 1, 1, '60006', 0, 0, 0, ''),
('60000', 8, 3, 'Sonstiges', 1, 1, '60007', 0, 0, 0, ''),
('60001', 1, 2, 'Orgrimmar', 1, 1, '', 0, 0, 0, ''),
('60001', 2, 2, 'Silbermond', 1, 1, '', 0, 0, 0, ''),
('60001', 3, 2, 'Unterstadt', 1, 1, '', 0, 0, 0, ''),
('60001', 4, 2, 'Donnerfels', 1, 1, '', 0, 0, 0, ''),
('60001', 5, 3, 'Back', 1, 1, '60000', 0, 0, 0, ''),
('60002', 1, 2, 'Sturmwind', 1, 1, '', 0, 0, 0, ''),
('60002', 2, 2, 'Eisenschmiede', 1, 1, '', 0, 0, 0, ''),
('60002', 3, 2, 'Darnassus', 1, 1, '', 0, 0, 0, ''),
('60002', 4, 2, 'Die Exodar', 1, 1, '', 0, 0, 0, ''),
('60002', 5, 3, 'Back', 1, 1, '60000', 0, 0, 0, ''),
('60003', 1, 2, 'Level 1-10', 1, 1, '', 0, 0, 0, ''),
('60003', 2, 2, 'Level 10-20', 1, 1, '', 0, 0, 0, ''),
('60003', 3, 2, 'Level 20-30', 1, 1, '', 0, 0, 0, ''),
('60003', 4, 2, 'Level 30-40', 1, 1, '', 0, 0, 0, ''),
('60003', 5, 2, 'Level 40-50', 1, 1, '', 0, 0, 0, ''),
('60003', 6, 2, 'Level 50-60', 1, 1, '', 0, 0, 0, ''),
('60003', 7, 2, 'Level 60-70', 1, 1, '', 0, 0, 0, ''),
('60003', 8, 2, 'Level 70-80', 1, 1, '', 0, 0, 0, ''),
('60003', 9, 2, 'Level 80-90', 1, 1, 0, 0, 0, 0, ''),
('60003', 10, 2, 'Level 90-100', 1, 1, 0, 0, 0, 0, ''),
('60003', 11, 2, 'Level 100-110', 1, 1, 0, 0, 0, 0, ''),
('60003', 12, 2, 'Level 110-120', 1, 1, 0, 0, 0, 0, ''),
('60003', 13, 2, 'Level 120-130', 1, 1, 0, 0, 0, 0, ''),
('60003', 14, 2, 'Level 130-140', 1, 1, 0, 0, 0, 0, ''),
('60003', 15, 2, 'Level 140-150', 1, 1, 0, 0, 0, 0, ''),
('60003', 16, 2, 'Level 160-170', 1, 1, 0, 0, 0, 0, ''),
('60003', 17, 2, 'Level 170-180', 1, 1, 0, 0, 0, 0, ''),
('60003', 18, 2, 'Level 180-190', 1, 1, 0, 0, 0, 0, ''),
('60003', 19, 2, 'Level 200-210', 1, 1, 0, 0, 0, 0, ''),
('60003', 20, 2, 'Level 210-220', 1, 1, 0, 0, 0, 0, ''),
('60003', 21, 2, 'Level 220-230', 1, 1, 0, 0, 0, 0, ''),
('60003', 22, 2, 'Level 230-240', 1, 1, 0, 0, 0, 0, ''),
('60003', 23, 2, 'Level 240-250', 1, 1, 0, 0, 0, 0, ''),
('60003', 24, 3, 'Back', 1, 1, '60000', 0, 0, 0, ''),
('60004', 1, 2, 'T11', 1, 1, '', 0, 0, 0, ''),
('60004', 2, 2, 'T12', 1, 1, '', 0, 0, 0, ''),
('60004', 3, 2, 'T13', 1, 1, '', 0, 0, 0, ''),
('60004', 4, 3, 'Back', 1, 1, '60000', 0, 0, 0, ''),
('60005', 1, 2, 'Jump', 1, 1, '', 0, 0, 0, ''),
('60005', 2, 2, 'Jump 2', 1, 1, '', 0, 0, 0, ''),
('60005', 3, 3, 'Back', 1, 1, '60000', 0, 0, 0, ''),
('60006', 1, 2, 'Gurubashi', 1, 1, '', 0, 0, 0, ''),
('60006', 2, 3, 'Back', 1, 1, '60000', 0, 0, 0, ''),
('60007', 1, 2, 'Schwimmbad', 1, 1, '', 0, 0, 0, ''),
('60007', 2, 2, 'Disco', 1, 1, '', 0, 0, 0, ''),
('60007', 3, 3, 'Back', 1, 1, '60000', 0, 0, 0, '');


INSERT INTO smart_scripts (entryorguid, source_type, id, link, event_type, event_phase_mask, event_chance, event_flags, event_param1, event_param2, event_param3, event_param4, action_type, action_param1, action_param2, action_param3, action_param4, action_param5, action_param6, target_type, target_param1, target_param2, target_param3, target_x, target_y, target_z, target_o, comment) VALUES 
('60000', 0, 1, 0, 62, 0, 100, 0, '60000', 1, 0, 0, 62, 0, 0, 0, 0, 0, 0, 0, 7, 0, 0, -8842.09, 626.358, 94.0867, 3.61363, 'Teleporter script'),
('60000', 0, 2, 0, 62, 0, 100, 0, '60001', 2, 0, 0, 62, 1, 0, 0, 0, 0, 0, 0, 7, 0, 0, 1601.08, -4378.69, 9.9846, 2.14362, 'Teleporter script'),
('60000', 0, 3, 0, 62, 0, 100, 0, '60001', 3, 0, 0, 62, 0, 0, 0, 0, 0, 0, 0, 7, 0, 0, -14281.9, 552.564, 8.90422, 0.860144, 'Teleporter script'),
('60000', 0, 4, 0, 62, 0, 100, 0, '60001', 4, 0, 0, 62, 530, 0, 0, 0, 0, 0, 0, 7, 0, 0, -1887.62, 5359.09, -12.4279, 4.40435, 'Teleporter script'),
('60000', 0, 5, 0, 62, 0, 100, 0, '60002', 1, 0, 0, 62, 571, 0, 0, 0, 0, 0, 0, 7, 0, 0, 5809.55, 503.975, 657.526, 2.38338, 'Teleporter script'),
('60000', 0, 6, 0, 62, 0, 100, 0, '60002', 2, 0, 0, 62, 0, 0, 0, 0, 0, 0, 0, 7, 0, 0, -13181.8, 339.356, 42.9805, 1.18013, 'Teleporter script'),
('60000', 0, 7, 0, 62, 0, 100, 0, '60002', 3, 0, 0, 62, 1, 0, 0, 0, 0, 0, 0, 7, 0, 0, 9869.91, 2493.58, 1315.88, 2.78897, 'Teleporter script'),
('60000', 0, 8, 0, 62, 0, 100, 0, '60002', 4, 0, 0, 62, 0, 0, 0, 0, 0, 0, 0, 7, 0, 0, -4900.47, -962.585, 501.455, 5.40538, 'Teleporter script'),
('60000', 0, 9, 0, 62, 0, 100, 0, '60003', 1, 0, 0, 62, 530, 0, 0, 0, 0, 0, 0, 7, 0, 0, -3864.92, -11643.7, -137.644, 5.50862, 'Teleporter script'),
('60000', 0, 10, 0, 62, 0, 100, 0, '60003', 2, 0, 0, 62, 1, 0, 0, 0, 0, 0, 0, 7, 0, 0, -1274.45, 71.8601, 128.159, 2.80623, 'Teleporter script'),
('60000', 0, 11, 0, 62, 0, 100, 0, '60003', 3, 0, 0, 62, 0, 0, 0, 0, 0, 0, 0, 7, 0, 0, 1633.75, 240.167, -43.1034, 6.26128, 'Teleporter script'),
('60000', 0, 12, 0, 62, 0, 100, 0, '60003', 4, 0, 0, 62, 530, 0, 0, 0, 0, 0, 0, 7, 0, 0, 9738.28, -7454.19, 13.5605, 0.043914, 'Teleporter script'),
('60000', 0, 13, 0, 62, 0, 100, 0, '60003', 5, 0, 0, 62, 0, 0, 0, 0, 0, 0, 0, 7, 0, 0, -5163.54, 925.423, 257.181, 1.57423, 'Teleporter script'),
('60000', 0, 14, 0, 62, 0, 100, 0, '60003', 6, 0, 0, 62, 0, 0, 0, 0, 0, 0, 0, 7, 0, 0, -11209.6, 1666.54, 24.6974, 1.42053, 'Teleporter script'),
('60000', 0, 15, 0, 62, 0, 100, 0, '60003', 7, 0, 0, 62, 0, 0, 0, 0, 0, 0, 0, 7, 0, 0, -8799.15, 832.718, 97.6348, 6.04085, 'Teleporter script'),
('60000', 0, 16, 0, 62, 0, 100, 0, '60003', 8, 0, 0, 62, 1, 0, 0, 0, 0, 0, 0, 7, 0, 0, 1811.78, -4410.5, -18.4704, 5.20165, 'Teleporter script'),
('60000', 0, 17, 0, 62, 0, 100, 0, '60003', 9, 0, 0, 62, 1, 0, 0, 0, 0, 0, 0, 7, 0, 0, -4657.3, -2519.35, 81.0529, 4.54808, 'Teleporter script'),
('60000', 0, 18, 0, 62, 0, 100, 0, '60003', 10, 0, 0, 62, 1, 0, 0, 0, 0, 0, 0, 7, 0, 0, -4470.28, -1677.77, 81.3925, 1.16302, 'Teleporter script'),
('60000', 0, 19, 0, 62, 0, 100, 0, '60003', 11, 0, 0, 62, 0, 0, 0, 0, 0, 0, 0, 7, 0, 0, 2873.15, -764.523, 160.332, 5.10447, 'Teleporter script'),
('60000', 0, 20, 0, 62, 0, 100, 0, '60003', 12, 0, 0, 62, 0, 0, 0, 0, 0, 0, 0, 7, 0, 0, -234.675, 1561.63, 76.8921, 1.24031, 'Teleporter script'),
('60000', 0, 21, 0, 62, 0, 100, 0, '60003', 13, 0, 0, 62, 1, 0, 0, 0, 0, 0, 0, 7, 0, 0, -731.607, -2218.39, 17.0281, 2.78486, 'Teleporter script'),
('60000', 0, 22, 0, 62, 0, 100, 0, '60003', 14, 0, 0, 62, 1, 0, 0, 0, 0, 0, 0, 7, 0, 0, 4249.99, 740.102, -25.671, 1.34062, 'Teleporter script'),
('60000', 0, 23, 0, 62, 0, 100, 0, '60003', 15, 0, 0, 62, 0, 0, 0, 0, 0, 0, 0, 7, 0, 0, -7179.34, -921.212, 165.821, 5.09599, 'Teleporter script'),
('60000', 0, 24, 0, 62, 0, 100, 0, '60003', 16, 0, 0, 62, 0, 0, 0, 0, 0, 0, 0, 7, 0, 0, -7527.05, -1226.77, 285.732, 5.29626, 'Teleporter script'),
('60000', 0, 25, 0, 62, 0, 100, 0, '60003', 17, 0, 0, 62, 1, 0, 0, 0, 0, 0, 0, 7, 0, 0, -3520.14, 1119.38, 161.025, 4.70454, 'Teleporter script'),
('60000', 0, 26, 0, 62, 0, 100, 0, '60003', 18, 0, 0, 62, 1, 0, 0, 0, 0, 0, 0, 7, 0, 0, -1421.42, 2907.83, 137.415, 1.70718, 'Teleporter script'),
('60000', 0, 27, 0, 62, 0, 100, 0, '60003', 19, 0, 0, 62, 0, 0, 0, 0, 0, 0, 0, 7, 0, 0, 1269.64, -2556.21, 93.6088, 0.620623, 'Teleporter script'),
('60000', 0, 28, 0, 62, 0, 100, 0, '60003', 20, 0, 0, 62, 0, 0, 0, 0, 0, 0, 0, 7, 0, 0, 3352.92, -3379.03, 144.782, 6.25978, 'Teleporter script'),
('60000', 0, 29, 0, 62, 0, 100, 0, '60003', 21, 0, 0, 62, 0, 0, 0, 0, 0, 0, 0, 7, 0, 0, -10177.9, -3994.9, -111.239, 6.01885, 'Teleporter script'),
('60000', 0, 30, 0, 62, 0, 100, 0, '60003', 22, 0, 0, 62, 0, 0, 0, 0, 0, 0, 0, 7, 0, 0, -6071.37, -2955.16, 209.782, 0.015708, 'Teleporter script'),
('60000', 0, 31, 0, 62, 0, 100, 0, '60003', 23, 0, 0, 62, 1, 0, 0, 0, 0, 0, 0, 7, 0, 0, -6801.19, -2893.02, 9.00388, 0.158639, 'Teleporter script'),
('60000', 0, 32, 0, 62, 0, 100, 0, '60004', 1, 0, 0, 62, 530, 0, 0, 0, 0, 0, 0, 7, 0, 0, -3324.49, 4943.45, -101.239, 4.63901, 'Teleporter script'),
('60000', 0, 33, 0, 62, 0, 100, 0, '60004', 2, 0, 0, 62, 530, 0, 0, 0, 0, 0, 0, 7, 0, 0, -3324.49, 4943.45, -101.239, 4.63901, 'Teleporter script'),
('60000', 0, 34, 0, 62, 0, 100, 0, '60004', 3, 0, 0, 62, 530, 0, 0, 0, 0, 0, 0, 7, 0, 0, -3324.49, 4943.45, -101.239, 4.63901, 'Teleporter script'),
('60000', 0, 35, 0, 62, 0, 100, 0, '60005', 1, 0, 0, 62, 530, 0, 0, 0, 0, 0, 0, 7, 0, 0, -3324.49, 4943.45, -101.239, 4.63901, 'Teleporter script'),
('60000', 0, 36, 0, 62, 0, 100, 0, '60005', 2, 0, 0, 62, 530, 0, 0, 0, 0, 0, 0, 7, 0, 0, -3324.49, 4943.45, -101.239, 4.63901, 'Teleporter script'),
('60000', 0, 37, 0, 62, 0, 100, 0, '60006', 1, 0, 0, 62, 530, 0, 0, 0, 0, 0, 0, 7, 0, 0, -3324.49, 4943.45, -101.239, 4.63901, 'Teleporter script'),
('60000', 0, 38, 0, 62, 0, 100, 0, '60007', 1, 0, 0, 62, 530, 0, 0, 0, 0, 0, 0, 7, 0, 0, -3324.49, 4943.45, -101.239, 4.63901, 'Teleporter script'),
('60000', 0, 39, 0, 62, 0, 100, 0, '60007', 2, 0, 0, 62, 1, 0, 0, 0, 0, 0, 0, 7, 0, 0, -8369.65, -4253.11, -204.272, -2.70526, 'Teleporter script');
wow-player is offline  
Old   #10
 
elite*gold: 2693
Join Date: Jul 2010
Posts: 6,449
Received Thanks: 1,224
Und was genau funktioniert nicht?
°"Crazy"° is offline  
Old   #11
 
elite*gold: 0
Join Date: Apr 2011
Posts: 63
Received Thanks: 3
der player wird nicht geportet ... also es passier nix
wow-player is offline  
Old   #12
 
elite*gold: 2693
Join Date: Jul 2010
Posts: 6,449
Received Thanks: 1,224
Bei allen?
°"Crazy"° is offline  
Old   #13
 
elite*gold: 0
Join Date: Apr 2011
Posts: 63
Received Thanks: 3
Jo bei allen ... ausser den punkten wo man ins untermenü kommt
wow-player is offline  
Old   #14
 
elite*gold: 2693
Join Date: Jul 2010
Posts: 6,449
Received Thanks: 1,224
Code:
SET
@gossip = 60000;

DELETE FROM creature_template WHERE entry = @gossip;

INSERT INTO creature_template (entry, modelid1, name, subname, IconName, gossip_menu_id, minlevel, maxlevel, Health_mod, Mana_mod, Armor_mod, faction_A, faction_H, npcflag, speed_walk, speed_run, scale, rank, dmg_multiplier, unit_class, unit_flags, type, type_flags, InhabitType, RegenHealth, flags_extra, AiName) VALUES
(@gossip, '5233', "Teleporter", "test", 'Directions', @gossip,81,81, 1.56, 1.56, 1.56, 35, 35, 3, 1, 1.14286, 1, 1, 1, 1, 2,8, 138936390, 3, 1, 2, 'SmartAI');


DELETE FROM gossip_menu_option WHERE menu_id>'59999' AND menu_id<'60008';
DELETE FROM smart_scripts WHERE entryorguid = @gossip;


INSERT INTO gossip_menu_option (menu_id, id, option_icon, option_text, option_id, npc_option_npcflag, action_menu_id, action_poi_id, box_coded, box_money, box_text) VALUES
(@gossip, 1, 2, 'Playertreff', 1, 1, '', 0, 0, 0, ''),
(@gossip, 2, 3, 'Haupt horde', 1, 1, @gossip+1, 0, 0, 0, ''),
(@gossip, 3, 3, 'haupt alli', 1, 1, @gossip+2, 0, 0, 0, ''),
(@gossip, 4, 3, 'Level Arena', 1, 1, @gossip+3, 0, 0, 0, ''),
(@gossip, 5, 3, 'Instanzen', 1, 1, @gossip+4, 0, 0, 0, ''),
(@gossip, 6, 3, 'Events', 1, 1, @gossip+5, 0, 0, 0, ''),
(@gossip,8, 3, 'PvP-Arenen', 1, 1, @gossip+6, 0, 0, 0, ''),
(@gossip, 8, 3, 'Sonstiges', 1, 1, @gossip+7, 0, 0, 0, ''),

(@gossip+1, 1, 2, 'Orgrimmar', 1, 1, '', 0, 0, 0, ''),
(@gossip+1, 2, 2, 'Silbermond', 1, 1, '', 0, 0, 0, ''),
(@gossip+1, 3, 2, 'Unterstadt', 1, 1, '', 0, 0, 0, ''),
(@gossip+1, 4, 2, 'Donnerfels', 1, 1, '', 0, 0, 0, ''),
(@gossip+1, 5, 3, 'Back', 1, 1, @gossip, 0, 0, 0, ''),

(@gossip+2, 1, 2, 'Sturmwind', 1, 1, '', 0, 0, 0, ''),
(@gossip+2, 2, 2, 'Eisenschmiede', 1, 1, '', 0, 0, 0, ''),
(@gossip+2, 3, 2, 'Darnassus', 1, 1, '', 0, 0, 0, ''),
(@gossip+2, 4, 2, 'Die Exodar', 1, 1, '', 0, 0, 0, ''),
(@gossip+2, 5, 3, 'Back', 1, 1, @gossip, 0, 0, 0, ''),

(@gossip+3, 1, 2, 'Level 1-10', 1, 1, '', 0, 0, 0, ''),
(@gossip+3, 2, 2, 'Level 10-20', 1, 1, '', 0, 0, 0, ''),
(@gossip+3, 3, 2, 'Level 20-30', 1, 1, '', 0, 0, 0, ''),
(@gossip+3, 4, 2, 'Level 30-40', 1, 1, '', 0, 0, 0, ''),
(@gossip+3, 5, 2, 'Level 40-50', 1, 1, '', 0, 0, 0, ''),
(@gossip+3, 6, 2, 'Level 50-60', 1, 1, '', 0, 0, 0, ''),
(@gossip+3, 7, 2, 'Level 60-70', 1, 1, '', 0, 0, 0, ''),
(@gossip+3, 8, 2, 'Level80-80', 1, 1, '', 0, 0, 0, ''),
(@gossip+3, 9, 2, 'Level 80-90', 1, 1, 0, 0, 0, 0, ''),
(@gossip+3, 10, 2, 'Level 90-100', 1, 1, 0, 0, 0, 0, ''),
(@gossip+3, 11, 2, 'Level 100-110', 1, 1, 0, 0, 0, 0, ''),
(@gossip+3, 12, 2, 'Level 110-120', 1, 1, 0, 0, 0, 0, ''),
(@gossip+3, 13, 2, 'Level 120-130', 1, 1, 0, 0, 0, 0, ''),
(@gossip+3, 14, 2, 'Level 130-140', 1, 1, 0, 0, 0, 0, ''),
(@gossip+3, 15, 2, 'Level 140-150', 1, 1, 0, 0, 0, 0, ''),
(@gossip+3, 16, 2, 'Level 160-170', 1, 1, 0, 0, 0, 0, ''),
(@gossip+3, 17, 2, 'Level 170-180', 1, 1, 0, 0, 0, 0, ''),
(@gossip+3, 18, 2, 'Level 180-190', 1, 1, 0, 0, 0, 0, ''),
(@gossip+3, 19, 2, 'Level 200-210', 1, 1, 0, 0, 0, 0, ''),
(@gossip+3, 20, 2, 'Level 210-220', 1, 1, 0, 0, 0, 0, ''),
(@gossip+3, 21, 2, 'Level 220-230', 1, 1, 0, 0, 0, 0, ''),
(@gossip+3, 22, 2, 'Level 230-240', 1, 1, 0, 0, 0, 0, ''),
(@gossip+3, 23, 2, 'Level 240-250', 1, 1, 0, 0, 0, 0, ''),
(@gossip+3, 24, 3, 'Back', 1, 1, @gossip, 0, 0, 0, ''),

(@gossip+4, 1, 2, 'T11', 1, 1, '', 0, 0, 0, ''),
(@gossip+4, 2, 2, 'T12', 1, 1, '', 0, 0, 0, ''),
(@gossip+4, 3, 2, 'T13', 1, 1, '', 0, 0, 0, ''),
(@gossip+4, 4, 3, 'Back', 1, 1, @gossip, 0, 0, 0, ''),

(@gossip+5, 1, 2, 'Jump', 1, 1, '', 0, 0, 0, ''),
(@gossip+5, 2, 2, 'Jump 2', 1, 1, '', 0, 0, 0, ''),
(@gossip+5, 3, 3, 'Back', 1, 1, @gossip, 0, 0, 0, ''),

(@gossip+6, 1, 2, 'Gurubashi', 1, 1, '', 0, 0, 0, ''),
(@gossip+6, 2, 3, 'Back', 1, 1, @gossip, 0, 0, 0, ''),

(@gossip+7, 1, 2, 'Schwimmbad', 1, 1, '', 0, 0, 0, ''),
(@gossip+7, 2, 2, 'Disco', 1, 1, '', 0, 0, 0, ''),
(@gossip+7, 3, 3, 'Back', 1, 1, @gossip, 0, 0, 0, '');


INSERT INTO smart_scripts (entryorguid, source_type, id, link, event_type, event_phase_mask, event_chance, event_flags, event_param1, event_param2, event_param3, event_param4, action_type, action_param1, action_param2, action_param3, action_param4, action_param5, action_param6, target_type, target_param1, target_param2, target_param3, target_x, target_y, target_z, target_o, comment) VALUES 
(@gossip, 0, 1, 0, 62, 0, 100, 0, @gossip, 1, 0, 0, 62, 0, 0, 0, 0, 0, 0, 0,8, 0, 0, -8842.09, 626.358, 94.0867, 3.61363, 'Teleporter script'),

(@gossip, 0, 2, 0, 62, 0, 100, 0, @gossip+1, 2, 0, 0, 62, 1, 0, 0, 0, 0, 0, 0,8, 0, 0, 1601.08, -4378.69, 9.9846, 2.14362, 'Teleporter script'),
(@gossip, 0, 3, 0, 62, 0, 100, 0, @gossip+1, 3, 0, 0, 62, 0, 0, 0, 0, 0, 0, 0,8, 0, 0, -14281.9, 552.564, 8.90422, 0.860144, 'Teleporter script'),
(@gossip, 0, 4, 0, 62, 0, 100, 0, @gossip+1, 4, 0, 0, 62, 530, 0, 0, 0, 0, 0, 0,8, 0, 0, -1887.62, 5359.09, -12.4279, 4.40435, 'Teleporter script'),

(@gossip, 0, 5, 0, 62, 0, 100, 0, @gossip+2, 1, 0, 0, 62, 571, 0, 0, 0, 0, 0, 0,8, 0, 0, 5809.55, 503.975, 657.526, 2.38338, 'Teleporter script'),
(@gossip, 0, 6, 0, 62, 0, 100, 0, @gossip+2, 2, 0, 0, 62, 0, 0, 0, 0, 0, 0, 0,8, 0, 0, -13181.8, 339.356, 42.9805, 1.18013, 'Teleporter script'),
(@gossip, 0, 7, 0, 62, 0, 100, 0, @gossip+2, 3, 0, 0, 62, 1, 0, 0, 0, 0, 0, 0,8, 0, 0, 9869.91, 2493.58, 1315.88, 2.78897, 'Teleporter script'),
(@gossip, 0, 8, 0, 62, 0, 100, 0, @gossip+2, 4, 0, 0, 62, 0, 0, 0, 0, 0, 0, 0,8, 0, 0, -4900.47, -962.585, 501.455, 5.40538, 'Teleporter script'),

(@gossip, 0, 9, 0, 62, 0, 100, 0, @gossip+3, 1, 0, 0, 62, 530, 0, 0, 0, 0, 0, 0,8, 0, 0, -3864.92, -11643.7, -137.644, 5.50862, 'Teleporter script'),
(@gossip, 0, 10, 0, 62, 0, 100, 0, @gossip+3, 2, 0, 0, 62, 1, 0, 0, 0, 0, 0, 0,8, 0, 0, -1274.45,71.8601, 128.159, 2.80623, 'Teleporter script'),
(@gossip, 0, 11, 0, 62, 0, 100, 0, @gossip+3, 3, 0, 0, 62, 0, 0, 0, 0, 0, 0, 0,8, 0, 0, 1633.75, 240.167, -43.1034, 6.26128, 'Teleporter script'),
(@gossip, 0, 12, 0, 62, 0, 100, 0, @gossip+3, 4, 0, 0, 62, 530, 0, 0, 0, 0, 0, 0,8, 0, 0, 9738.28, -7454.19, 13.5605, 0.043914, 'Teleporter script'),
(@gossip, 0, 13, 0, 62, 0, 100, 0, @gossip+3, 5, 0, 0, 62, 0, 0, 0, 0, 0, 0, 0,8, 0, 0, -5163.54, 925.423, 257.181, 1.57423, 'Teleporter script'),
(@gossip, 0, 14, 0, 62, 0, 100, 0, @gossip+3, 6, 0, 0, 62, 0, 0, 0, 0, 0, 0, 0,8, 0, 0, -11209.6, 1666.54, 24.6974, 1.42053, 'Teleporter script'),
(@gossip, 0, 15, 0, 62, 0, 100, 0, @gossip+3, 7, 0, 0, 62, 0, 0, 0, 0, 0, 0, 0,8, 0, 0, -8799.15, 832.718, 97.6348, 6.04085, 'Teleporter script'),
(@gossip, 0, 16, 0, 62, 0, 100, 0, @gossip+3, 8, 0, 0, 62, 1, 0, 0, 0, 0, 0, 0,8, 0, 0, 1811.78, -4410.5, -18.4704, 5.20165, 'Teleporter script'),
(@gossip, 0, 17, 0, 62, 0, 100, 0, @gossip+3, 9, 0, 0, 62, 1, 0, 0, 0, 0, 0, 0,8, 0, 0, -4657.3, -2519.35, 71.0529, 4.54808, 'Teleporter script'),
(@gossip, 0, 18, 0, 62, 0, 100, 0, @gossip+3, 10, 0, 0, 62, 1, 0, 0, 0, 0, 0, 0,8, 0, 0, -4470.28, -1677.77, 71.3925, 1.16302, 'Teleporter script'),
(@gossip, 0, 19, 0, 62, 0, 100, 0, @gossip+3, 11, 0, 0, 62, 0, 0, 0, 0, 0, 0, 0,8, 0, 0, 2873.15, -764.523, 160.332, 5.10447, 'Teleporter script'),
(@gossip, 0, 20, 0, 62, 0, 100, 0, @gossip+3, 12, 0, 0, 62, 0, 0, 0, 0, 0, 0, 0,8, 0, 0, -234.675, 1561.63,86.8921, 1.24031, 'Teleporter script'),
(@gossip, 0, 21, 0, 62, 0, 100, 0, @gossip+3, 13, 0, 0, 62, 1, 0, 0, 0, 0, 0, 0,8, 0, 0, -731.607, -2218.39, 17.0281, 2.78486, 'Teleporter script'),
(@gossip, 0, 22, 0, 62, 0, 100, 0, @gossip+3, 14, 0, 0, 62, 1, 0, 0, 0, 0, 0, 0,8, 0, 0, 4249.99,840.102, -25.671, 1.34062, 'Teleporter script'),
(@gossip, 0, 23, 0, 62, 0, 100, 0, @gossip+3, 15, 0, 0, 62, 0, 0, 0, 0, 0, 0, 0,8, 0, 0, -7179.34, -921.212, 165.821, 5.09599, 'Teleporter script'),
(@gossip, 0, 24, 0, 62, 0, 100, 0, @gossip+3, 16, 0, 0, 62, 0, 0, 0, 0, 0, 0, 0,8, 0, 0, -7527.05, -1226.77, 285.732, 5.29626, 'Teleporter script'),
(@gossip, 0, 25, 0, 62, 0, 100, 0, @gossip+3, 17, 0, 0, 62, 1, 0, 0, 0, 0, 0, 0,8, 0, 0, -3520.14, 1119.38, 161.025, 4.70454, 'Teleporter script'),
(@gossip, 0, 26, 0, 62, 0, 100, 0, @gossip+3, 18, 0, 0, 62, 1, 0, 0, 0, 0, 0, 0,8, 0, 0, -1421.42, 2907.83, 137.415, 1.70718, 'Teleporter script'),
(@gossip, 0, 27, 0, 62, 0, 100, 0, @gossip+3, 19, 0, 0, 62, 0, 0, 0, 0, 0, 0, 0,8, 0, 0, 1269.64, -2556.21, 93.6088, 0.620623, 'Teleporter script'),
(@gossip, 0, 28, 0, 62, 0, 100, 0, @gossip+3, 20, 0, 0, 62, 0, 0, 0, 0, 0, 0, 0,8, 0, 0, 3352.92, -3379.03, 144.782, 6.25978, 'Teleporter script'),
(@gossip, 0, 29, 0, 62, 0, 100, 0, @gossip+3, 21, 0, 0, 62, 0, 0, 0, 0, 0, 0, 0,8, 0, 0, -10177.9, -3994.9, -111.239, 6.01885, 'Teleporter script'),
(@gossip, 0, 30, 0, 62, 0, 100, 0, @gossip+3, 22, 0, 0, 62, 0, 0, 0, 0, 0, 0, 0,8, 0, 0, -6071.37, -2955.16, 209.782, 0.015708, 'Teleporter script'),
(@gossip, 0, 31, 0, 62, 0, 100, 0, @gossip+3, 23, 0, 0, 62, 1, 0, 0, 0, 0, 0, 0,8, 0, 0, -6801.19, -2893.02, 9.00388, 0.158639, 'Teleporter script'),

(@gossip, 0, 32, 0, 62, 0, 100, 0, @gossip+4, 1, 0, 0, 62, 530, 0, 0, 0, 0, 0, 0,8, 0, 0, -3324.49, 4943.45, -101.239, 4.63901, 'Teleporter script'),
(@gossip, 0, 33, 0, 62, 0, 100, 0, @gossip+4, 2, 0, 0, 62, 530, 0, 0, 0, 0, 0, 0,8, 0, 0, -3324.49, 4943.45, -101.239, 4.63901, 'Teleporter script'),
(@gossip, 0, 34, 0, 62, 0, 100, 0, @gossip+4, 3, 0, 0, 62, 530, 0, 0, 0, 0, 0, 0,8, 0, 0, -3324.49, 4943.45, -101.239, 4.63901, 'Teleporter script'),

(@gossip, 0, 35, 0, 62, 0, 100, 0, @gossip+5, 1, 0, 0, 62, 530, 0, 0, 0, 0, 0, 0,8, 0, 0, -3324.49, 4943.45, -101.239, 4.63901, 'Teleporter script'),
(@gossip, 0, 36, 0, 62, 0, 100, 0, @gossip+5, 2, 0, 0, 62, 530, 0, 0, 0, 0, 0, 0,8, 0, 0, -3324.49, 4943.45, -101.239, 4.63901, 'Teleporter script'),

(@gossip, 0, 37, 0, 62, 0, 100, 0, @gossip+6, 1, 0, 0, 62, 530, 0, 0, 0, 0, 0, 0,8, 0, 0, -3324.49, 4943.45, -101.239, 4.63901, 'Teleporter script'),

(@gossip, 0, 38, 0, 62, 0, 100, 0, @gossip+7, 1, 0, 0, 62, 530, 0, 0, 0, 0, 0, 0,8, 0, 0, -3324.49, 4943.45, -101.239, 4.63901, 'Teleporter script'),
(@gossip, 0, 39, 0, 62, 0, 100, 0, @gossip+7, 2, 0, 0, 62, 1, 0, 0, 0, 0, 0, 0,8, 0, 0, -8369.65, -4253.11, -204.272, -2.70526, 'Teleporter script');
Alles andere überlasse ich mal Dir. Eventuell findest du deine ganzen Fehler.
°"Crazy"° is offline  
Old   #15
 
elite*gold: 0
Join Date: Apr 2011
Posts: 63
Received Thanks: 3
1062 - Duplicate entry '60000-1' for key 'PRIMARY'

habe auch nachgeguckt ... finde den fehler nicht ._.


wow-player is offline  
Reply

Tags
3.3.5a, sql, teleporter, trinity core, world of warcraft



« Previous Thread | Next Thread »

Similar Threads
Arctic Combat geht nicht mehr mapping accound funktuniert nicht
Bitte um Hilfe das gleiche ist auch bei Skype ich glaub das liegt an windows
1 Replies - elite*gold Trading
Server startet nicht mehr fsck geht auch nicht
Hallo ich habe seit heute ein Problem : Der Server startet mit einem fsck Fehler. Wenn ich dann jedoch fsck eingeben kommt folgender Text : ...
1 Replies - Metin2 PServer - Discussions / Questions
Crossfire: Mehr Buggy geht nicht... echt nicht
Hallo :D hatte grade ärgsten CF Bug ever. Also zuerst konnte ich mich einloggen, dann ging ich auf nen Server da hab ich dann Disconnect bekommen....
8 Replies - CrossFire
Msn fenster geht aus und geht nicht mehr an o.O
Ja mein problem ist wenn ich z.B mit der türkei rede (über msn mit cam und headset) dann geht das msn fenster zu mit dem ich gerade chate. aber ich...
5 Replies - Technical Support



All times are GMT +2. The time now is 02:50.


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Abuse
Copyright ©2017 elitepvpers All Rights Reserved.