search

mangosR2 / scriptdev2

MangosR2 universal Script Library, compartible with all mangosR2 cores (v2, 3, 4 and possible later).
http://mangosr2.2x2forum.com/
GNU General Public License v2.0
82 stars 47 forks source link

ScriptNames in DB #82

Open KiriX opened 12 years ago

KiriX commented 12 years ago

At server startup: При запуске сервера в консоли:

SD2: Script registering but ScriptName npc_ic_vehicle is not assigned in databas e. Script will not be used. SD2: Script registering but ScriptName boss_krick_event is not assigned in datab ase. Script will not be used. SD2: Script registering but ScriptName mob_chaotic_rift is not assigned in datab ase. Script will not be used. SD2: Script registering but ScriptName boss_general_vezax is not assigned in dat abase. Script will not be used. SD2: Script registering but ScriptName event_spell_saronite_barrier is not assig ned in database. Script will not be used. SD2: Script registering but ScriptName npc_hodir_helper is not assigned in datab ase. Script will not be used. SD2: Script registering but ScriptName mob_eyebeam_trigger is not assigned in da tabase. Script will not be used. SD2: Script registering but ScriptName mob_kologarn_pit_kill_bunny is not assign ed in database. Script will not be used. SD2: Script registering but ScriptName mob_assault_bot is not assigned in databa se. Script will not be used. SD2: Script registering but ScriptName mob_mimirons_inferno is not assigned in d atabase. Script will not be used. SD2: Script registering but ScriptName mob_dark_rune_acolyte is not assigned in database. Script will not be used. SD2: Script registering but ScriptName mob_dark_rune_evoker is not assigned in d atabase. Script will not be used. SD2: Script registering but ScriptName mob_boombot is not assigned in database. Script will not be used. SD2: Script registering but ScriptName adventurer is not assigned in database. S cript will not be used. SD2: Script registering but ScriptName event_call_flames is not assigned in data base. Script will not be used. SD2: Script registering but ScriptName npc_spirit_fount is not assigned in datab ase. Script will not be used. SD2: No script found for ScriptName 'boss_terenas_menethil_icc'. SD2: No script found for ScriptName 'boss_vezax'. SD2: No script found for ScriptName 'go_broken_harpoon'. SD2: No script found for ScriptName 'go_orb_of_the_blue_flight'. SD2: No script found for ScriptName 'go_thorim_lever'. SD2: No script found for ScriptName 'mob_armagedon_target'. SD2: No script found for ScriptName 'mob_saronite_vapor'. SD2: No script found for ScriptName 'mob_scorch_target'. SD2: No script found for ScriptName 'mob_seeping_feral_essence'. SD2: No script found for ScriptName 'npc_anub_ar_shadowcaster'. SD2: No script found for ScriptName 'npc_anub_ar_skirmisher'. SD2: No script found for ScriptName 'npc_anub_ar_warrior'. SD2: No script found for ScriptName 'npc_chaotic_rift'. SD2: No script found for ScriptName 'npc_hodir_druid'. SD2: No script found for ScriptName 'npc_hodir_mage'. SD2: No script found for ScriptName 'npc_hodir_priest'. SD2: No script found for ScriptName 'npc_hodir_shaman'. SD2: No script found for ScriptName 'npc_kiljaeden_controller'. SD2: No script found for ScriptName 'npc_portal_target'. SD2: No script found for ScriptName 'npc_skittering_infector'. SD2: No script found for ScriptName 'npc_void_sentinel_summoner'. SD2: No script found for ScriptName 'npc_watcher_gashra'. SD2: No script found for ScriptName 'npc_watcher_narjil'. SD2: No script found for ScriptName 'npc_watcher_silthik'.

[sd2_mr0332]

Venom commented 12 years ago

confirm. really annoing bug.

Venom commented 12 years ago

check this out? will this work?

UPDATE gameobject_template SET ScriptName='go_spectral_rift' WHERE entry=187055; UPDATE creature_template SET ScriptName='npc_crusade_persuaded' WHERE entry IN (28939,28940,28610); UPDATE creature_template SET ScriptName = 'mobs_risen_husk_spirit' WHERE entry IN (23554, 23555);
UPDATE creature_template SET ScriptName='mob_chaotic_rift' WHERE entry=26918; UPDATE creature_template SET ScriptName='boss_general_vezax' WHERE entry=33271; DELETE FROM scripted_event_id WHERE id=9735; INSERT INTO scripted_event_id VALUES (9735,'event_spell_saronite_barrier');

UPDATE creature_template SET ScriptName = 'mob_assault_bot' WHERE entry = 34057; UPDATE creature_template SET ScriptName='mob_dark_rune_acolyte' WHERE entry=33110; UPDATE creature_template SET ScriptName='mob_dark_rune_evoker' WHERE entry=32878; UPDATE creature_template SET ScriptName='mob_boombot' WHERE entry=33346;

DELETE FROM scripted_event_id WHERE id=17841; INSERT INTO scripted_event_id VALUES (17841,'event_call_flames');

UPDATE creature_template SET ScriptName="npc_spirit_fount" WHERE entry= 27339; UPDATE creature_template SET ScriptName='npc_oil_stained_wolf' WHERE entry=25791; UPDATE creature_template SET ScriptName='npc_sinkhole_kill_credit' WHERE entry IN (26248,26249); UPDATE creature_template SET ScriptName='npc_beryl_sorcerer' WHERE entry=25316; UPDATE creature_template SET ScriptName='npc_dalaran_guardian_mage' WHERE entry IN (29255, 29254);

ZuSe commented 12 years ago

Works fine... somemore are missing:

ERROR:SD2: Script registering but ScriptName npc_ic_vehicle is not assigned in database. Script will no$ 2012-03-27 14:01:43 ERROR:SD2: Script registering but ScriptName npc_lazy_peon is not assigned in database. Script will not$ 2012-03-27 14:01:43 ERROR:SD2: Script registering but ScriptName boss_krick_event is not assigned in database. Script will $ 2012-03-27 14:01:43 ERROR:SD2: Script registering but ScriptName mob_eyebeam_trigger is not assigned in database. Script wi$ 2012-03-27 14:01:43 ERROR:SD2: Script registering but ScriptName mob_kologarn_pit_kill_bunny is not assigned in database. S$ 2012-03-27 14:01:43 ERROR:SD2: Script registering but ScriptName mob_mimirons_inferno is not assigned in database. Script w$ 2012-03-27 14:01:43 ERROR:SD2: Script registering but ScriptName adventurer is not assigned in database. Script will not be$

2012-03-27 14:01:43 ERROR:SD2: No script found for ScriptName 'boss_terenas_menethil_icc'. 2012-03-27 14:01:43 ERROR:SD2: No script found for ScriptName 'go_spectral_rift'. 2012-03-27 14:01:43 ERROR:SD2: No script found for ScriptName 'go_thorim_lever'. 2012-03-27 14:01:43 ERROR:SD2: No script found for ScriptName 'mob_scorch_target'. 2012-03-27 14:01:43 ERROR:SD2: No script found for ScriptName 'mob_seeping_feral_essence'. 2012-03-27 14:01:43 ERROR:SD2: No script found for ScriptName 'npc_captured_sunhawk_agent'. 2012-03-27 14:01:43 ERROR:SD2: No script found for ScriptName 'npc_susurrus'. 2012-03-27 14:01:43 ERROR:SD2: No script found for ScriptName 'npc_witch_doctor_mauari'.

KiriX commented 12 years ago

2012-03-27 14:01:43 ERROR:SD2: No script found for ScriptName 'boss_terenas_menethil_icc'. 2012-03-27 14:01:43 ERROR:SD2: No script found for ScriptName 'go_spectral_rift'. 2012-03-27 14:01:43 ERROR:SD2: No script found for ScriptName 'go_thorim_lever'. 2012-03-27 14:01:43 ERROR:SD2: No script found for ScriptName 'mob_scorch_target'. 2012-03-27 14:01:43 ERROR:SD2: No script found for ScriptName 'mob_seeping_feral_essence'. 2012-03-27 14:01:43 ERROR:SD2: No script found for ScriptName 'npc_captured_sunhawk_agent'. 2012-03-27 14:01:43 ERROR:SD2: No script found for ScriptName 'npc_susurrus'. 2012-03-27 14:01:43 ERROR:SD2: No script found for ScriptName 'npc_witch_doctor_mauari'. Just delete this scripts from DB - there is no in SD2 code...

ZuSe commented 12 years ago

Allright.. here are my Statments... maybe someone could add it to mr_sql? Its annoying if you get these errors every startup

UPDATE creature_template SET ScriptName='' WHERE entry=38579 LIMIT 1; --boss_terenas_menethil_icc UPDATE creature_template SET ScriptName='' WHERE entry=33221 LIMIT 1; --mob_scorch_target UPDATE creature_template SET ScriptName='' WHERE entry=34098 LIMIT 1; --mob_seeping_feral_essence UPDATE creature_template SET ScriptName='' WHERE entry=17824 LIMIT 1; --npc_captured_sunhawk_agent UPDATE creature_template SET ScriptName='' WHERE entry=17435 LIMIT 1; --npc_susurrus UPDATE creature_template SET ScriptName='' WHERE entry=10307 LIMIT 1; --npc_witch_doctor_mauari UPDATE gameobject_template SET ScriptName='' WHERE entry=187055 LIMIT 1; --go_spectral_rift UPDATE gameobject_template SET ScriptName='' WHERE entry=194264 LIMIT 1; --go_thorim_lever

KiriX commented 12 years ago

UPDATE creature_template SET ScriptName='' WHERE ScriptName='boss_terenas_menethil_icc';

Scripts should be like this. =) More simple and 100% without mistakes, errors or typos =)

ZuSe commented 12 years ago

allright.. just had this style coz of adding the missing entries for existing scripts^^

KiriX commented 12 years ago

I still have some errors: 2012-03-28 12:48:06 ERROR:SD2: Script registering but ScriptName npc_sa_demolisher is not assigned in database. Script will not be used. 2012-03-28 12:48:06 ERROR:SD2: Script registering but ScriptName npc_ic_vehicle is not assigned in database. Script will not be used. 2012-03-28 12:48:06 ERROR:SD2: Script registering but ScriptName boss_krick_event is not assigned in database. Script will not be used. 2012-03-28 12:48:06 ERROR:SD2: Script registering but ScriptName mob_eyebeam_trigger is not assigned in database. Script will not be used. 2012-03-28 12:48:06 ERROR:SD2: Script registering but ScriptName mob_kologarn_pit_kill_bunny is not assigned in database. Script will not be used. 2012-03-28 12:48:06 ERROR:SD2: Script registering but ScriptName mob_mimirons_inferno is not assigned in database. Script will not be used. 2012-03-28 12:48:06 ERROR:SD2: Script registering but ScriptName adventurer is not assigned in database. Script will not be used. 2012-03-28 12:48:06 ERROR:SD2: Script registering but ScriptName boss_shirrak is not assigned in database. Script will not be used. 2012-03-28 12:48:06 ERROR:SD2: No script found for ScriptName 'go_broken_harpoon'. 2012-03-28 12:48:06 ERROR:SD2: No script found for ScriptName 'mob_deceiver'. 2012-03-28 12:48:06 ERROR:SD2: No script found for ScriptName 'mob_felfire_fiend'. 2012-03-28 12:48:06 ERROR:SD2: No script found for ScriptName 'mob_voidsentinel'. 2012-03-28 12:48:06 ERROR:SD2: No script found for ScriptName 'npc_anub_ar_shadowcaster'. 2012-03-28 12:48:06 ERROR:SD2: No script found for ScriptName 'npc_anub_ar_skirmisher'. 2012-03-28 12:48:06 ERROR:SD2: No script found for ScriptName 'npc_anub_ar_warrior'. 2012-03-28 12:48:06 ERROR:SD2: No script found for ScriptName 'npc_skittering_infector'. 2012-03-28 12:48:06 ERROR:SD2: No script found for ScriptName 'npc_watcher_gashra'. 2012-03-28 12:48:06 ERROR:SD2: No script found for ScriptName 'npc_watcher_narjil'. 2012-03-28 12:48:06 ERROR:SD2: No script found for ScriptName 'npc_watcher_silthik'.

ZuSe commented 12 years ago

For some of them i have a fix:

UPDATE creature_template SET ScriptName='mob_kologarn_pit_kill_bunny' WHERE entry=33742; UPDATE creature_template SET ScriptName='mob_mimirons_inferno' WHERE entry=33370; UPDATE creature_template SET ScriptName='adventurer' WHERE entry=23133;

(pls use entries.. db might have problems when locales are different) funny thing is mimirons already has a linked script.

There are also a lot of errors in npc-spawnpoins and respawntimes. Best thing would be a full database-clean-up and release a new full-pack of ytdb

Venom commented 11 years ago

did that. full pack of ytdb. got same db errors. just as same as KiriX last comment

Venom commented 11 years ago

http://www.paste.to/MTg5ODU1NA==

consol loading error clean up.

rsa commented 11 years ago

npc_ic_cannon' WHERE entry IN (34944, 35429); UPDATE creature_template SET ScriptName = 'npc_sa_demolisher' WHERE entry = '28781'; UPDATE creature_template SET ScriptName = 'npc_sa_cannon'

this NPC scripts obsolete and removed.