Event Scripts

[Gilroes]

Hi,

So I'm having a wonderful time playing this repack (I love it!) and I tried some events out but none work correctly, decorations and quest NPC's do not spawn is some places. The only event that works 1% is the Hallow's End, I can get the pumpkin things in the inn's and stuff but the headless horseman doesn't come out and throw fire everywhere, if anyone has fully working/better event scripts please share them!

And, how do I remove these midsummer braisers and banners which are in silvermoon city? They seem to be stuck and won't despawn. http://imgur.com/a/fukI7

Also, how do I manually get myself into the Horseman's Dungeon? As it's only me who plays. XD

- Lewis

 

[Titesusy]

Working a little on the Hallow'end event, I can put these SQL script I made. But, there are to put the Candy buckets in right places (thanks to wowhead) and to set them in correct event phase: edit the "game_event_gameobject" table inserting rows with your new candy buckets GUIDs, always with the eventEntry=12 (Hallow'end ID) like :

INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES ('12', '327921')

Now, for the "debug" of the candy buckets:
https://www.emucoach.com/showthread.php/5723-V10-Halloween-LETC-events

 

[Gilroes]

**EDIT: Sorry I misread your post, forget the sentence with the strikes through it.**
I'll try this thanks! }<strike>Also why can you not share your hallow's end scripts? I kinda need to get it fixed badly. But thank-you anyway!}</strike>

 

[Titesusy]

I can't share my Hallow'end script because I don't have I only use Emucoach V5 (always... I know! But I prefer it....) But the event scripts I put are working too on V6! So...
View attachment coordd10.jpg
For now, I'm working on Darkmoon Faire events. There are Three events linked to the main event. I reached the Darkmoon isle too. I post the coords, If you want to setup a portal...

But no mini games are working. I'll try to sql script at least one of them... But for begining, I can post these scripts for Darkmoon Faire:

INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES ('3', '10021');
INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES ('4', '10021');
INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES ('5', '10021');
INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES ('3', '9859');
INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES ('4', '9859');
INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES ('5', '9859');
INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES ('3', '9886');
INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES ('4', '9886');
INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES ('5', '9886');
INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES ('3', '9883');
INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES ('4', '9883');
INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES ('5', '9883');
INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES ('3', '9895');
INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES ('4', '9895');
INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES ('5', '9895');
INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES ('3', '9104');
INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES ('4', '9104');
INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES ('5', '9104');
INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES ('3', '9124');
INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES ('4', '9124');
INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES ('5', '9124');
INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES ('3', '9105');
INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES ('4', '9105');
INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES ('5', '9105');
INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES ('5', '15685');
INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES ('5', '15690');
INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES ('5', '15680');
INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES ('5', '15679');
INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES ('5', '15678');
INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES ('5', '15692');
INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES ('5', '15682');
INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES ('5', '15677');
INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES ('5', '16091');
INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES ('5', '15676');
INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES ('5', '15688');
INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES ('5', '15681');
INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES ('5', '16092');
INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES ('5', '15675');
INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES ('5', '15689');
INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES ('5', '15687');
INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES ('5', '15684');
INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES ('5', '15691');
INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES ('5', '15683');
INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES ('5', '16168');
INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES ('5', '15708');
INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES ('5', '15705');
INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES ('5', '16172');
INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES ('5', '15709');
INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES ('5', '15706');
INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES ('5', '15702');
INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES ('5', '15707');
INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES ('5', '15701');
INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES ('5', '15922');
INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES ('5', '15921');
INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES ('5', '15920');
INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES ('5', '15923');
INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES ('5', '16164');
INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES ('5', '15919');
INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES ('5', '15918');
INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES ('5', '16171');
INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES ('5', '15695');
INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES ('5', '15917');
INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES ('5', '15703');
INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES ('5', '15915');
INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES ('5', '15914');
INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES ('5', '15913');
INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES ('5', '15912');
INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES ('5', '15916');
INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES ('5', '16163');
INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES ('5', '15910');
INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES ('5', '16169');
INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES ('5', '15909');
INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES ('5', '15696');
INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES ('5', '15905');
INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES ('5', '15697');
INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES ('5', '15907');
INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES ('5', '15906');
INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES ('5', '15699');
INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES ('5', '15904');
INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES ('5', '15897');
INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES ('5', '15903');
INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES ('5', '15898');
INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES ('5', '15698');
INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES ('5', '15902');
INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES ('5', '15899');
INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES ('5', '16166');
INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES ('5', '15908');
INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES ('5', '16162');
INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES ('5', '15901');
INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES ('5', '15900');

 

[Titesusy]

A little personal add: I added a new event (ID=127) to make ETC Concert each hour only in Darkmoon Faire Isle. The Original ETC Concert is set at 8:00PM everyday, on Southern road of Shattrah...

INSERT INTO `game_event` (`eventEntry`, `start_time`, `end_time`, `occurence`, `length`, `description`) VALUES ('127', '2016-11-07 10:00:00', '2020-12-31 23:59:59', '60', '5', 'L70ETC Concert Darkmoon Faire');
INSERT INTO `game_event_creature` (`eventEntry`, `guid`) VALUES ('127', '355431');
INSERT INTO `game_event_creature` (`eventEntry`, `guid`) VALUES ('127', '355496');
INSERT INTO `game_event_creature` (`eventEntry`, `guid`) VALUES ('127', '355489');
INSERT INTO `game_event_creature` (`eventEntry`, `guid`) VALUES ('127', '355490');
INSERT INTO `game_event_creature` (`eventEntry`, `guid`) VALUES ('127', '355491');
INSERT INTO `game_event_creature` (`eventEntry`, `guid`) VALUES ('127', '355495');

I'll work tomorrow on the display of Midsummer Fire Event Objects. But For the moment, I won't focus on its quests, only on the display.

 

[Titesusy]

So ... The Midsummer event.... *smiles*
https://www.emucoach.com/showthread.php/5345-v7-(maybe-older-)-cataclysm-server-Midsummer-event

 

[Gilroes]

Question, do I copy and paste these into the sql query on the world database?

 

[Titesusy]

Yes In the good order (following the answers)

It remain some particular item (like the blue flame) , but like I said before, please be patient I'll find time in next days to put them into correct event.

But I have a question: The table with flower Inside the pavillon (your second picture), are they too in the event? or they are not in the event ? These flowers are too in Silvermoon bank ...

 

[Gilroes]

I'm not actually 100% sure, it is probably there by default with the table, I'll have to take a look.

 

[Gilroes]

Hi,

Thank you! It works!

 

[Titesusy]

Hallow'End Event​

Your surprise is come! About your request for the candy buckets, I share with you the maping. It remains a small bug with these, in new cataclysm zones (like Uldum), they are both Alliance and Horde. It's fixing by seting the "requiredRace" field for theses quests, but I'm in weekend for now

A precision: You can set the first "@my_id" (where there is the line : SET @my_id=600000; -- You can modify this variable.), choosing a range of unused GUIDs from the "gameobject" table.
If the code made you a SQL error : duplication primary key tentative, then, choose another range for @my_id. If it works, then it's ok . In this case, don't worry if it already created the gameobjects, they will be reseted when you launch a new time the script. (To test, you can play with the "my_id" variable... but attention if you choose a too high number )
NB : If you already placed Candybuckets, the code will remove them automatically, each time you execute the code. (to prevent duplications in "gameobject" AND "game_event_gameobject" tables. Have fun ! (If you want to test: to start Hallow'end Event, type in chat ingame: .event start 12)


Bests regards my friend!

https://www.emucoach.com/showthread.php/5723-V10-Halloween-LETC-events

 

[Titesusy]

Hallow'End Event
- The Following​

In addition with the sql scripts shared in a previous answer (page 1), in conclusion, achievements unlocked for alliance and horde are:
- Tricks and Treats series (like for example http://www.wowhead.com/achievement=963 )
- Sinister calling achievement ( http://www.wowhead.com/achievement=292 )
- The mask task ( http://www.wowhead.com/achievement=979 )

About the Headless Horseman, when he's near to die, it cure himself until full life, being immune ... Maybe I'll look on its script, but not for now

 

[Gilroes]

You're a gem! Thanks ^.^ Also do you have any versions of these for vanilla world of Warcraft?

 

[Titesusy]

Thanks you! No I only play on 4.3.4 (Emucoach V5), and WTLK (from Mangos), but I "work" only on Trinitycore databases (Emucoach). The next script should be (for the begining of the next week), some warning corrections from Emucoach console. (from loading tables)

 

[Titesusy]

Introduction to the
"Database Cleaning"​

I share with you sql scripts to clean some Emucoach worldserver warnings while loading...

-- Date of the version : 12/11/ 2016

-- Remove warnings in worldserver.exe console like : 
-- Creature (GUID: 178647) does not exist but has a record in 'creature_addon'
-- If the guid creature doesn't exist, we can remove it from creature_addon

DELETE FROM
creature_addon
WHERE
creature_addon.guid NOT IN (SELECT creature.guid
FROM
creature);


-- Remove warnings in worldserver.exe console like : 
-- 'pool_creature' has a non existing creature spawn (GUID: 193186) defined for pool id (1500), skipped.
-- Same as previously, "pool_creature" know a guid (creature already ingame, not only in theory) which is not existing... So we can remove it from the pool_creature table.

DELETE FROM
pool_creature
WHERE
pool_creature.guid NOT IN (SELECT creature.guid
FROM
creature);


-- Remove warnings in worldserver.exe console like : 
-- Table 'creature_questrelation' has creature entry (2952) for quest 14452, but npcflag does not include UNIT_NPC_FLAG_QUESTGIVER
-- The flag for a quest giver should be at least equal 2, but there aren't, so let's do it!

UPDATE `creature_template` SET `npcflag`='2'
WHERE creature_template.npcflag = 0 AND creature_template.entry IN
(SELECT creature_questrelation.id
FROM creature_questrelation );

 

[Gilroes]

Question, I'm reinstalling my database, I think I screwed something up, do I just paste the whole thing into the database? Also do I need to select the database table it should go in or will it do that automatically?

 

[Titesusy]

I don't know what is you sql program, but with Navicat, I only must choose the database ("emucoachworld" database). The tables used but sql scripts will be automatically modified by scripts. I don't know if I answered to your question?

But Attention! I downloaded the V6 this weekend, and I sadly saw my sql scripts aren't working properly with the V6! (the maping, I see the Hallow'end candy buckets in the ground :/ for example), or my ETC scripts aren't working properly .... I'm confused :/ ... sorry

 

[Titesusy]

UPDATE : I'm working on V6 scripts ...

Scripts starting this post are tested and working on V6 (free) version.

-- ETC

UPDATE `game_event` SET `start_time`='2014-09-19 20:00:00', `end_time`='2020-01-01 23:00:0',`occurence`='1440',`length`='5' WHERE (`eventEntry`='32');

UPDATE `smart_scripts`
 SET `event_flags`='1', `link`='0'
WHERE `entryorguid`='23623' OR 
`entryorguid`='23624' OR 
`entryorguid`='23626' OR
`entryorguid`='23619' OR 
`entryorguid`='23830' OR
`entryorguid`='23625';
UPDATE `smart_scripts` SET `event_param1`='3000', `event_param2`='3000', `event_flags`='0' WHERE (`entryorguid`='23624') AND (`source_type`='0') AND (`id`='0') AND (`link`='0');
UPDATE `smart_scripts` SET `event_param1`='3000', `event_param2`='3000', `event_flags`='0' WHERE (`entryorguid`='23623') AND (`source_type`='0') AND (`id`='0') AND (`link`='0');
UPDATE `smart_scripts` SET `event_param1`='3000', `event_param2`='3000', `event_flags`='0' WHERE (`entryorguid`='23619') AND (`source_type`='0') AND (`id`='1') AND (`link`='0');
UPDATE `smart_scripts` SET `event_param1`='3000', `event_param2`='3000', `event_flags`='0' WHERE (`entryorguid`='23626') AND (`source_type`='0') AND (`id`='0') AND (`link`='0');
UPDATE `smart_scripts` SET `event_flags`='0', `event_param1`='3000', `event_param2`='3000' WHERE (`entryorguid`='23625') AND (`source_type`='0') AND (`id`='0') AND (`link`='0');

INSERT INTO `game_event` (`eventEntry`, `start_time`, `end_time`, `occurence`, `length`, `description`) VALUES ('127', '2016-11-07 10:00:00', '2020-12-31 23:59:59', '60', '5', 'L70ETC Concert Darkmoon Faire');
INSERT INTO `game_event_creature` (`eventEntry`, `guid`) VALUES ('127', '176210');
INSERT INTO `game_event_creature` (`eventEntry`, `guid`) VALUES ('127', '176205');
INSERT INTO `game_event_creature` (`eventEntry`, `guid`) VALUES ('127', '176206');
INSERT INTO `game_event_creature` (`eventEntry`, `guid`) VALUES ('127', '176207');
INSERT INTO `game_event_creature` (`eventEntry`, `guid`) VALUES ('127', '176209');
INSERT INTO `game_event_creature` (`eventEntry`, `guid`) VALUES ('127', '176162');

 

[Rhisk]

You need to organize your scripts a little more, you are doing the scripts in a punctual way, for example in the case of candy cubes, only put in the script the ones that were missing, if in another version of the repack are missing others then your fix is incomplete. The other is that you repeat many of them insert a more comfortable way of putting them is like this:

INSERT INTO `game_event_creature` (`eventEntry`, `guid`) VALUES 
(127, 176210),
(127, 176205),
(127, 176206),
(127, 176207),
(127, 176209),
(127, 176162);

Equally great work.

Sorry my Google english

 

[Titesusy]

For the candy buckets (Hallow'end), infact, it will delete all candy buckets already existing in world, and it put the "new" candy buckets with the maping I've done (1). The missing about candybucket it's infact the maping itself.... with the mmap, with my version, they are displayed a little in the ground with the V6. To fix it, could be to move everybuckets "z=z+d" in z axis (with "d" set as a float need to be determinated ...)

(1) : That's why, there are 2 "DELETE FROM" with multiples conditions which are every (existing?) candybuckets. I delete every candybuckets already existing (even the user, you for exemple, choose a wrong "SET @my_id=600000; ", you can choose another, and the candybuckets previously creatd are deleted Doing the deleting first, it delete first, and then, it rebuilds... If the candy buckets are missing, it delete nothing, so .... The reasons to delete even there are existing, is admitting you add a (missing) candybucket. To not add a new candybucket around yours, it will delete yours to set the new candybucket. In same way, admitting the user prompt a wrong "@my_id", the error will be a "dupplication of primary key tentative". To pass this error, there are the two delete before the insertion


Then, about the apparences of the scripts... I totally agree with you, my scripts need really a structure! But if you allow to me a defense. Infact, I'm "self-educated" ("autodidacte" in French). Most of scripts I post are "copy-paste" from my sql program (Navicat) or a massive generator of sql (Opendocument Calc). Sometimes I modify them, but when I do an operation (like insertion in a table), it displays the command, and I put it in a temporary file (before to post). I'll try in the future to structure in more my scripts as much as I can.

Reflecting, my head too needs a lot of structure! lol. I am not concentrate in a particular bug, my feelings are leading me. But it's like that...

Best Regards !