[Release] TRM's Cthulhu Ftagn Dual-Database MaNGOS Repack (3.3.5.12340) - 32 & 64-bit

[CthulhuFtagn]

@Stefan30 (http://mmopro.net/forums/members/stefan30/): Gracias mi amigo.

[Narcoleptic]

Did this new update fixed any of the errors and bugs we talked about...? sorry for asking this...
Big Hug

[CthulhuFtagn]

If you are referring to the Pet Stamina bug, then no; I applied a patch which I thought would fix the problem, but it did not... I'm trying to rewrite it so that it fixes the problem.

[Narcoleptic]

Ohh ok :) other thing in the file you posted in the folder scriptv2 you inserted the update 23 with all the package but you did not inserted the alone file is that normal or you didn´t do any updates on that folder and you just did the compilation?
Thanks friend :)

[CthulhuFtagn]

Just the compilation brotherman.

[thewarrior99]

I'll have a look and see what I can do for ya...

Update Available:

MaNGOS updated to 10434
Vellum patch implemented
Eye of Archerus Patch implemented
Updates consolidated into larger files
Quice updated to 1.2.54 in Tools folderCU_0023.zip (http://www.mediafire.com/?i0bv73xrujrdvo0) (13.13 MB)

Note: Only use the consolidated .sql files if you are installing the repack for the first time to get up-to-date.


EDIT: I do not have those errors, and to test I even did a complete reinstall. If you are changing things with certain NPCs, etc then you are going to run into those types of errors, but until I can reproduce it I'm not going to worry about it (especially if it doesn't affect gameplay).

btw, now i can see my db. I noticed all that some players had problems with exodar. then I tele to exodar and I got problem too. so i try to do like other (update with your .sql files). everything was succssesful. Then I tried .tele exodar again and I got the same problem again. then I delete whole server and made the same thing again and still the same...

[Stefan30]

Ohh ok :) other thing in the file you posted in the folder scriptv2 you inserted the update 23 with all the package but you did not inserted the alone file is that normal or you didn´t do any updates on that folder and you just did the compilation?
Thanks friend :)

open in your update folder ".../DB/scriptdev2/scriptdev2_0000-0023_all.sql and copy/paste to your quiery in sqlyog on the scriptdev2 database this:

UPDATE sd2_db_version SET VERSION='TRM CU 0023 ScriptDev2 1815';
After that Ctrl+A to mark the text and push F9
Before paste when you're already open scriptdev2 quiery delete all on the quiery box and then paste
congartulations ;) your sd2 version is 0023 :)

[CthulhuFtagn]

btw, now i can see my db. I noticed all that some players had problems with exodar. then I tele to exodar and I got problem too. so i try to do like other (update with your .sql files). everything was succssesful. Then I tried .tele exodar again and I got the same problem again. then I delete whole server and made the same thing again and still the same...It's people like this that make me tear my hair out. Can't read or follow directions, can't be bothered to read other posts.


http://www.youtube.com/watch?v=Iqv3hnmdAE8
THERE IS NO PROBLEM WITH .tele exodar.

(2ndbigblue == thewarrior99)

[Narcoleptic]

open in your update folder ".../DB/scriptdev2/scriptdev2_0000-0023_all.sql and copy/paste to your quiery in sqlyog on the scriptdev2 database this:

UPDATE sd2_db_version SET VERSION='TRM CU 0023 ScriptDev2 1815';
After that Ctrl+A to mark the text and push F9
Before paste when you're already open scriptdev2 quiery delete all on the quiery box and then paste
congartulations ;) your sd2 version is 0023 :)

Do i really need to do this...? or i can ignore...?
Thanks friend

[CthulhuFtagn]

You don't need to do that, it's just MY way of keeping track of the updates, the core doesn't need it.

[Narcoleptic]

eh eh ok thanks :)

After the update i got this on the window...its normal or there is some problem...?451

[Stefan30]

Oh! CthulhuFtagn i wanna report you something what i've been check out
In PoS (dungeon) the first boss `Forgemaster Garfrost` is not scripted... and the second boss `Ick` don't cast Poison Nova.
i have a question about the ICC instance... before enter in the instance does i need to do the quests about it or i can ignore em ?
When i kill the first boss there's no opening the gates to continiue ahead... What i must to do...?
I hope on your help dude i believe in you

[Stefan30]

eh eh ok thanks :)

After the update i got this on the window...its normal or there is some problem...?451

check out this page here are the answers :
http://mmopro.net/forums/f155/%5Brelease%5D-trms-cthulhu-ftagn-dual-database-mangos-repack-3-3-5-12340-32-64-bit-4286/index24.html

[CthulhuFtagn]

eh eh ok thanks :)

After the update i got this on the window...its normal or there is some problem...?451Yep, those are normal, they are also not 'errors' as some believe, they are just information.


Oh! CthulhuFtagn i wanna report you something what i've been check out
In PoS (dungeon) the first boss `Forgemaster Garfrost` is not scripted... and the second boss `Ick` don't cast Poison Nova.
i have a question about the ICC instance... before enter in the instance does i need to do the quests about it or i can ignore em ?
When i kill the first boss there's no opening the gates to continiue ahead... What i must to do...?
I hope on your help dude i believe in youI would do the quests first, make sure that GM is OFF, if you use .gm on then no NPC will attack you (nor can they see you).


@thewarrior99:
Just to prove that
.tele exodar works, I completely reinstalled the server from scratch, applied the updates, and created a new toon; if you are having problems with the command it is YOUR installation that has the problem, not my server.

http://www.youtube.com/watch?v=g9ZysYMLCjk

[thewarrior99]

Yep, those are normal, they are also not 'errors' as some believe, they are just information.

I would do the quests first, make sure that GM is OFF, if you use .gm on then no NPC will attack you (nor can they see you).


@thewarrior99:
Just to prove that
.tele exodar works, I completely reinstalled the server from scratch, applied the updates, and created a new toon; if you are having problems with the command it is YOUR installation that has the problem, not my server.

UPLOADING VIDEO
BUAH. i'm gm a lot of time and on other server it's working properly. and it's not only exodar(i mean like a city not like a teleport command), it's all Azuremyst Isle. Sry for brothering. bb

[CthulhuFtagn]

Ok, now I'm uploading a video for Azuremyst Isle just to prove you wrong... again.

[Stefan30]

Yep, those are normal, they are also not 'errors' as some believe, they are just information.

I would do the quests first, make sure that GM is OFF, if you use .gm on then no NPC will attack you (nor can they see you).
Okey... can you tell me the first quest of that part i must to check him and try to improve my skills ...
thanks you in advance

[thewarrior99]

Ok, now I'm uploading a video for Azuremyst Isle just to prove you wrong... again.

I know I'm wrong. I didn't say that is your server fault. Your server is great. I was just asking for help... I know i'm doing something wrong and I didn't know where yet...

[CthulhuFtagn]

I don't have time for every little question you have Stefan30, sorry, but I have better things to do; and as much as I have helped, I'm sure you can use wowhead or thottbot and figure it out yourself.

Here's Azuremyst Isle thewarrior99

http://www.youtube.com/watch?v=vmM2_T3LaPg

[Stefan30]

okey CthulhuFtagn sorry

[CthulhuFtagn]

It's ok, but you guys/gals do have to learn to do some things on your own; as much as I like to help out every once in a while you have to get your hands dirty and fiddle around.

[Stefan30]

Okey CthulhuFtagn ... i'm already improved (about this quest)
I checked in thottbot and wowhead... i take the first quest - its about Forge of Souls... i take the next part [Echoes of Tortured Souls] i'm already defeated the two bosses from the instance and quest is complete but when i go to talk with Lady Sylvannas the Windrunner to complete the quest she don't have an any "?" to her... i can't speak with her and i can't continue the part of this quest...

[CthulhuFtagn]

Ok, I tested the quest chain and you were wrong. She does have a ? above her, it seems you went to the wrong Sylvannas.


.go xyz 442.82 213.18 528.70 658The quest itself even tells you to speak with her at the rear of the Forge of Souls.

http://img137.imageshack.us/img137/2055/startend.jpg

Next quest
http://img832.imageshack.us/img832/7970/testsr.jpg (http://img6.imageshack.us/img6/239/testkv.jpg)

[Stefan30]

damn... i'm tired and so nervous but i'm still chatty with you :D
okey check out this pics...
452
after that see this:
453
Note: look at the chat too man :)

[CthulhuFtagn]

I see them, but you need to complete the quest... I did find one missing Sylvannas (I will add in the next release as well)

INSERT INTO `creature` (`guid`,`id`,`map`,`spawnMask`,`phaseMask`,`modeli d`,`equipment_id`,`position_x`,`position_y`,`posit ion_z`,`orientation`,`spawntimesecs`,`spawndist`,` currentwaypoint`,`curhealth`,`curmana`,`DeathState `,`MovementType`) VALUES
(200211, 38189, 658, 1, 64, 0, 1290, 1054.39, 113.838, 628.156, 4.9397, 25, 5, 0, 6972500, 85160, 0, 0);
That one is for the end of Deliverance from the Pit.

[Stefan30]

i see that too... she must to be near to the last boss of FoS and i add her too :) thanks man
oh ... one more thing ... to the continiue for the quest ... [Deliverence from the pit] (for defeating Scourgelord Tyrannus) there one more Sylvannas for quest delivering.... (.add npc 38189) missing too :)
i add her too fix her too on the next release
and to the way for the Tyrannus have a trash mobs... there's missing too

[CthulhuFtagn]

INSERT INTO `creature` (`guid`,`id`,`map`,`spawnMask`,`phaseMask`,`modeli d`,`equipment_id`,`position_x`,`position_y`,`posit ion_z`,`orientation`,`spawntimesecs`,`spawndist`,` currentwaypoint`,`curhealth`,`curmana`,`DeathState `,`MovementType`) VALUES
(200283, 38161, 632, 1, 64, 0, 1290, 5679.45, 2531.03, 714.692, 3.91248, 25, 5, 0, 6972500, 85160, 0, 0);

[Stefan30]

yes :) great work ...
But when i made that update i've got new errors, check it out:

Creature (GUIDLow: 202825 Entry: 36892 ) Has duplicate aura (spell 18950 effect 0) in `auras` field.
Creature (GUIDLow: 202825 Entry: 36892 ) Has duplicate aura (spell 18950 effect 1) in `auras` field.
Creature (GUIDLow: 202825 Entry: 36893 ) Has duplicate aura (spell 18950 effect 0) in `auras` field.
Creature (GUIDLow: 202825 Entry: 36893 ) Has duplicate aura (spell 18950 effect 1) in `auras` field.
Creature (GUIDLow: 202825 Entry: 36893 ) Has duplicate aura (spell 18950 effect 0) in `auras` field.
Creature (GUIDLow: 202825 Entry: 36893 ) Has duplicate aura (spell 18950 effect 1) in `auras` field.
Creature (GUIDLow: 202825 Entry: 36892 ) Has duplicate aura (spell 18950 effect 0) in `auras` field.
Creature (GUIDLow: 202825 Entry: 36892 ) Has duplicate aura (spell 18950 effect 1) in `auras` field.
Creature (GUIDLow: 202825 Entry: 36893 ) Has duplicate aura (spell 18950 effect 0) in `auras` field.
Creature (GUIDLow: 202825 Entry: 36893 ) Has duplicate aura (spell 18950 effect 1) in `auras` field.
Creature (GUIDLow: 202825 Entry: 36893 ) Has duplicate aura (spell 18950 effect 0) in `auras` field.
Creature (GUIDLow: 202825 Entry: 36893 ) Has duplicate aura (spell 18950 effect 1) in `auras` field.

[marko94]

I freshly downloaded the server because I had some PC issues , so now you merged all the updates into one SQL file, I tried to apply them but I get error on those SQL's (for empty DB, mangos DB)

Trying to apply "empty_0000-0023_all":
454

Trying to apply "mangos_0000-0023_all":
455

[CthulhuFtagn]

Use SQLYog and it works fine.

Stefan, here's the quest chain NPCs (And no, I don't get the errors you posted - It looks to me like you tried to add some NPCs - Ymirjar Deathbringer (36892) and Ymirjar Flamebearer (36893) - and are getting errors... if you are going to add things DO NOT report them as errors on my repack )

Dark Ranger Vorel (37780)
.go xyz 5939.18 618.32 650.58 571

Lady Sylvanas Windrunner (37596)
.go xyz 4900.08 2208.45 638.73 632

Bronjahm (36497)
.go xyz 5297.33 2506.63 686.06 632

Devourer of Souls (36502)
.go xyz 5661.58 2507.19 708.82 632

Lady Sylvanas Windrunner (38161)
.go xyz 5679.45 2531.03 714.69 632

Lady Sylvanas Windrunner (36990)
.go xyz 442.82 213.18 528.70 658

Horde Slave (36770)
.go xyz 559.54 62.52 525.01 658
.go xyz 582.47 -6.99 512.59 658
.go xyz 637.67 -76.02 512.58 658
.go xyz 760.59 -58.40 511.75 658
.go xyz 849.19 -25.84 509.0 658
.go xyz 859.97 15.69 510.44 658
.go xyz 691.64 208.68 511.64 658
.go xyz 636.08 260.49 509.40 658
.go xyz 638.04 307.27 509.07 658
.go xyz 599.86 335.67 508.28 658
.go xyz 579.57 312.54 508.57 658
.go xyz 535.0 302.1 508.79 658
.go xyz 661.82 15.66 486.29 658
.go xyz 683.48 -60.31 507.42 4.0 658
.go xyz 754.87 9.41 465.42 658

Foregemaster Garfrost (36494)
.go xyz 712.92 -231.60 526.71 658

Gorkun Ironskull (37592)
.go xyz 629.60 112.19 510.28 658

Scourgelord Tyrannas (36658)
.go xyz 1018.38 167.25 651.87 658

Lady Sylvanas Windrunner (38189)
.go xyz 1054.39 113.83 628.15 658

Lady Sylvanas Windrunner (37223)
.go xyz 5266.77 1953.42 707.69 668

[Stefan30]

well... just want to help you to be added in the next release, lest you write and other ppl that are missing creatures and npc's and one more thing ... can u give me some script for Halls of Reflection ? there's missing npc's too and the event inside maybe or may i make mistake, does it work?
:( forgive me if i break your rules

[marko94]

Again the same errors with SQLYog ...

[CthulhuFtagn]

@marko: Try doing the updates in order then... I'll see if I can replicate your problem when I have time and fix it for the next release. Remember not to inject updates you've already done.

@Stefan30: You didn't break my rules, but you did report an error that had nothing to do with my repack (twice), if you add/subtract from the repack and then get errors that is your own fault.

If you don't know how an instance works and you report an error, that is your own fault.

If you report missing NPCs and you didn't enter the instance correctly (ie: teleporting there), that is your own fault.

I will report, from now on, any user who posts a 'bug' that does not exists in the repack as it is a waste of both my time and the users on the forums time.

[Stefan30]

okey ... well tell me something... on your server All instances and Raids works correctly without bugs, blizzlike ?
and if you tell me where i can find npc spells and where i can fix them on my database... before long time in wowhead shows us which boss what spell using and i add her ... ? can u help me for that, you're will be more goldy guy ^^ love ya dude You're so patient to me

[CthulhuFtagn]

No, of course not. No repack is perfect.

EDIT: Most spells are located with the NPC itself in the database, you can use Quice to edit them (in the tools folder).

Some spells are in the core, so they can't be edited.

[Stefan30]

No, of course not. No repack is perfect.

EDIT: Most spells are located with the NPC itself in the database, you can use Quice to edit them (in the tools folder).

Some spells are in the core, so they can't be edited.
well... i don't wanna hurry... so what will happen if i try to add the spells to the npc from Quice ? does it fault orr... i'll be wrong ? :(

[CthulhuFtagn]

That depends on how you do it... I'm not going to say it won't give you some errors, but it may 'hack' it's way into a fix.

http://img130.imageshack.us/img130/2012/spells.jpg

Bone Storm - Spell - World of Warcraft (http://www.wowhead.com/spell=69076)
BOOOOOOOOOOOOOOOOOOONNNNNNNEEEEE STOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOORMMMMMMMM!

I made a video (with .GM ON so I could do it quick) of the run through of the previous quest line that we talked about. This shows that it can be done just fine.


http://www.youtube.com/watch?v=baG3QIFR9f0

I don't know if some of you don't know about playing sound files from the WoW console... try these:


/script PlaySoundFile("Sound\\Creature\\LordMarrowgar\\IC_Marrowgar_Aggro 01.wav")

/script PlaySoundFile("Sound\\Creature\\LordMarrowgar\\IC_Marrowgar_AreaE ntry01.wav")

/script PlaySoundFile("Sound\\Creature\\LordMarrowgar\\IC_Marrowgar_Berse rk01.wav")

/script PlaySoundFile("Sound\\Creature\\LordMarrowgar\\IC_Marrowgar_BS01. wav")

/script PlaySoundFile("Sound\\Creature\\LordMarrowgar\\IC_Marrowgar_BS02. wav")

/script PlaySoundFile("Sound\\Creature\\LordMarrowgar\\IC_Marrowgar_BS03. wav")

/script PlaySoundFile("Sound\\Creature\\LordMarrowgar\\IC_Marrowgar_Death 01.wav")

/script PlaySoundFile("Sound\\Creature\\LordMarrowgar\\IC_Marrowgar_Slay0 1.wav")

/script PlaySoundFile("Sound\\Creature\\LordMarrowgar\\IC_Marrowgar_Slay0 2.wav")

/script PlaySoundFile("Sound\\Creature\\LordMarrowgar\\IC_Marrowgar_WW01. wav")

[Narcoleptic]

I have some things i want to tell you friend...about the dungeons and raids...in the Halls of stone the last boss, the Tribunal...did he worked for you...? and in VoA the door don´t seem to work i had to delete it and only then i can enter it...and the raids for 10 and 25 ppl heroic VoA and Ulduar i cannot enter with GM mode...is this normal...?
Thanks

[CthulhuFtagn]

Ulduar And VoA can only be completed in 10 and 25 man NORMAL, there is no Heroic version... again, DO NOT POST a 'bug' unless you know how an instance works.

The last boss of the Halls of Stone is Sjonnir The Ironshaper

Sjonnir the Ironshaper is the last boss of Halls of Stone, a sub-zone of Ulduar.
not the Tribunal Chest (http://www.wowhead.com/object=190586).

[Stefan30]

I made a video (with .GM ON so I could do it quick) of the run through of the previous quest line that we talked about. This shows that it can be done just fine.
dude... i'm already with the quests ... but lady sylvannas dont start the event ...

[CthulhuFtagn]

Then you did it wrong. Pure and simple. Having to make a video each time to show people how things work is really annoying... I wish before someone posts that "such and such" doesn't work that they would atleast do a little research into the subject... look at the post about Ulduar 10-25 man HEROIC, anyone who's ever done Ulduar or VoA would know that there is no Heroic versions; but that doesn't stop the "Lazy Leechers" from asking.

[Stefan30]

not enough strenght yet to talk about it ... nvm... forget it

[CthulhuFtagn]

@marko94: I tested a newly downloaded Server with the current CU_0023 pack and I had no errors at all.

UPLOADING A VIDEO TUTORIAL TO ADD TO THE FIRST POST. It will be uploaded in High-Definition so you'll be able to see and hear everything I tell you/show you to do.

[Narcoleptic]

Ulduar And VoA can only be completed in 10 and 25 man NORMAL, there is no Heroic version... again, DO NOT POST a 'bug' unless you know how an instance works.

The last boss of the Halls of Stone is Sjonnir The Ironshaper

not the Tribunal Chest (http://www.wowhead.com/object=190586).

I´m very sorry friend :( it wont happen again i promise...

[CthulhuFtagn]

I'm sorry if I seem angry, upset, or belligerent. I just put a lot of work into this and to have people make false claims kinda urks me. I'll try to make my comments more constructive in the future.

[Stefan30]

can someone help me with that ? I have no idea, where this appeared ? :(

SESSION: recieved unexpected opcode CMSG_CANCEL_TRADE (0x011c) the player has not logged in yet and not recently logout
This application has requested the Runtime to terminate it in an unusual way.
Please contact the application's support team for more information.

[CthulhuFtagn]

Tutorial (best watched with 720p in full screen mode @ YouTube)

http://www.youtube.com/watch?v=2SNnxA4UguY

[marko94]

UPLOADING A VIDEO TUTORIAL TO ADD TO THE FIRST POST. It will be uploaded in High-Definition so you'll be able to see and hear everything I tell you/show you to do.

I applied the updates and server works I just had to apply them one by one 'cause merged SQL didn't worked and no offense but no need to tutor me with videos and all that detailed tutorials (click here, click there) I'm not noob considering this SQL updating or computers so I'm just implying that there is no need to talk to me like I'm noobish kid who sat in front of the computer for the first time, my high school is after all computer tehnician ^^

P.S. This was no act of anger I'm just sayin' ...

[CthulhuFtagn]

Well, as you can see from the video the merged SQL files worked fine in SQLYog (which is what I had told you to use). And, I've been a computer technician in both the Navy and Army, and have been a programmer for 21 years which is longer than you've been alive... the video was aimed at everyone, not just you.

http://img9.imageshack.us/img9/5918/13837915.jpg

So...
http://img413.imageshack.us/img413/3666/me2na.jpg

[marko94]

Man I am aware of you computer skill otherwise you server wouldn't be se good.I was just sayin that you don't have to draw me a picture so I can figure out what I have to do.Yes I used the SQLYog and it worked with no problems I only preffered Navicat because I had expirience with it, anyways it should extract it right just don't know what is the problem.Now when that is done let's settle this over a pint ! :)

P.S. No hard feelings man, I respect the elders :)

[skiik]

Has anyone been able to get Eye of Archerus working after installing this patch. It does not work for me and i still cannot move the eye. Not sure if its my install or not though. Can someone confirm for me please?

Its like the 3rd death knight quest where you have to control the eye

Thanks in advance

btw, now i can see my db. I noticed all that some players had problems with exodar. then I tele to exodar and I got problem too. so i try to do like other (update with your .sql files). everything was succssesful. Then I tried .tele exodar again and I got the same problem again. then I delete whole server and made the same thing again and still the same...

[CthulhuFtagn]

Man I am aware of you computer skill otherwise you server wouldn't be se good.I was just sayin that you don't have to draw me a picture so I can figure out what I have to do.Yes I used the SQLYog and it worked with no problems I only preffered Navicat because I had expirience with it, anyways it should extract it right just don't know what is the problem.Now when that is done let's settle this over a pint ! :)

P.S. No hard feelings man, I respect the elders :)
Heck yeah dude... let's have two pints.

And now for the random image of the day before I hit the hay:
http://lolthulhu.com/wp-content/uploads/2008/05/r3v3n63-stompn.jpg

[paulwantstoplay]

Sorry to bother you about this small problem (for you probably, but for me it's a big one).
I can't download the file vmap_extract_assembler_bin.zip (http://www.mediafire.com/?fgf0m4act057zw8) from your first page anymore, it gives the error "Invalid or Deleted File".
Could you please upload it again, as it is essential for me, that vertical collision works.
Thanks in advance, CF (or TRM as you used to be called :D)

EDIT: I just noticed the utility in your CU_0023.zip (http://www.mediafire.com/?i0bv73xrujrdvo0) file. Can i use that one instead of the one from the link?

[Stefan30]

Has anyone been able to get Eye of Archerus working after installing this patch. It does not work for me and i still cannot move the eye. Not sure if its my install or not though. Can someone confirm for me please?

Its like the 3rd death knight quest where you have to control the eye

Thanks in advance

I can confirum dude :) but for the first time you can make the quest Completeble from your Quice database editor... aaaaaaaaanddd when that quest be scripted and more in some release you can edin him again ;)

@CthulhuFtagn i have some very bad crashes... can someone help me with that problem ?
Checkout the codes:
This error has appeared in my mangosd.exe ... i'm don't touch anything when i start my application and just stay and watch... on every 5 min i don't get errors in my cmd on mangosd.exe and then its appear this:

This application has requested the Runtime to terminate it in an unusual way.
Please contact the application's support team for more information.
Note: There was no players online... i just testing what's the problem and i don't have any idea...

When i check my crash folder i see that:
What's happen ? i'm not sure... i can't believe on that...

[CthulhuFtagn]

Sorry to bother you about this small problem (for you probably, but for me it's a big one).
I can't download the file vmap_extract_assembler_bin.zip (http://www.mediafire.com/?fgf0m4act057zw8) from your first page anymore, it gives the error "Invalid or Deleted File".
Could you please upload it again, as it is essential for me, that vertical collision works.
Thanks in advance, CF (or TRM as you used to be called :D)

EDIT: I just noticed the utility in your CU_0023.zip (http://www.mediafire.com/?i0bv73xrujrdvo0) file. Can i use that one instead of the one from the link?Yep, you can use that one ;)


I can confirum dude :) but for the first time you can make the quest Completeble from your Quice database editor... aaaaaaaaanddd when that quest be scripted and more in some release you can edin him again ;)

@CthulhuFtagn i have some very bad crashes... can someone help me with that problem ?
Checkout the codes:
This error has appeared in my mangosd.exe ... i'm don't touch anything when i start my application and just stay and watch... on every 5 min i don't get errors in my cmd on mangosd.exe and then its appear this:

This application has requested the Runtime to terminate it in an unusual way.
Please contact the application's support team for more information.Note: There was no players online... i just testing what's the problem and i don't have any idea...

When i check my crash folder i see that:

Revision: * * 10434 c5cf389ce50ec2bd6f36d142733917ac0b91053f
Date 3:9:2010. Time 13:34
//================================================== ===
*** Hardware ***
Processor: Intel(R) Core(TM)2 Duo CPU E4600 @ 2.40GHz
Number Of Processors: 2
Physical Memory: 3395856 KB (Available: 727592 KB)
Commit Charge Limit: 4194303 KB
*** Operation System ***
Windows Vista or Windows Server 2008 Home Edition Service Pack 1 (Version 6.0, Build 6001)
//================================================== ===
Exception code: E06D7363
Fault address: 763642EB 01:000432EB C:\Windows\system32\kernel32.dll
Registers:
EAX:0D2D858C
EBX:127148D8
ECX:00000003
EDX:00000000
ESI:00000000
EDI:0091B1C0
CS:EIP:001B:763642EB
SS:ESP:0023:0D2D858C EBP:0D2D85DC
DS:0023 ES:0023 FS:003B GS:0000
Flags:00000202
CRITICAL ERROR.
Couldn't initialize the symbol handler for process.
Error [Not enough storage is available to process this command.
].

Call stack:
Address Frame Function SourceFile
763642EB 00000000 0001:000432EB C:\Windows\system32\kernel32.dll
6B66DF60 00000000 0001:0005CF60 C:\Windows\WinSxS\x86_microsoft.vc90.crt_1fc8b3b9a 1e18e3b_9.0.30729.4974_none_50940634bcb759cb\MSVCR 90.dll
00457B50 00000000 0001:00056B50 C:\Server\MaNGOS\Win32\mangosd.exe
007C34DE 00000000 0001:003C24DE C:\Server\MaNGOS\Win32\mangosd.exe
007C2C2B 00000000 0001:003C1C2B C:\Server\MaNGOS\Win32\mangosd.exe
007C3C1F 00000000 0001:003C2C1F C:\Server\MaNGOS\Win32\mangosd.exe
007C3AD0 00000000 0001:003C2AD0 C:\Server\MaNGOS\Win32\mangosd.exe
007C39C3 00000000 0001:003C29C3 C:\Server\MaNGOS\Win32\mangosd.exe
007C3900 00000000 0001:003C2900 C:\Server\MaNGOS\Win32\mangosd.exe
007C2DDC 00000000 0001:003C1DDC C:\Server\MaNGOS\Win32\mangosd.exe
007C2EFD 00000000 0001:003C1EFD C:\Server\MaNGOS\Win32\mangosd.exe
004D47DE 00000000 0001:000D37DE C:\Server\MaNGOS\Win32\mangosd.exe
004D4332 00000000 0001:000D3332 C:\Server\MaNGOS\Win32\mangosd.exe
004D4A12 00000000 0001:000D3A12 C:\Server\MaNGOS\Win32\mangosd.exe
00902C8B 00000000 0001:00501C8B C:\Server\MaNGOS\Win32\mangosd.exe
00902140 00000000 0001:00501140 C:\Server\MaNGOS\Win32\mangosd.exe
00906A1D 00000000 0001:00505A1D C:\Server\MaNGOS\Win32\mangosd.exe
0091DDE8 00000000 0001:0051CDE8 C:\Server\MaNGOS\Win32\mangosd.exe
006478F5 00000000 0001:002468F5 C:\Server\MaNGOS\Win32\mangosd.exe
0064620C 00000000 0001:0024520C C:\Server\MaNGOS\Win32\mangosd.exe
0045795E 00000000 0001:0005695E C:\Server\MaNGOS\Win32\mangosd.exe
0091B1D9 00000000 0001:0051A1D9 C:\Server\MaNGOS\Win32\mangosd.exe
6B551864 00000000 0001:00050864 C:\Server\MaNGOS\Win32\ACE.dll
6B633433 00000000 0001:00022433 C:\Windows\WinSxS\x86_microsoft.vc90.crt_1fc8b3b9a 1e18e3b_9.0.30729.4974_none_50940634bcb759cb\MSVCR 90.dll
6B6334C7 00000000 0001:000224C7 C:\Windows\WinSxS\x86_microsoft.vc90.crt_1fc8b3b9a 1e18e3b_9.0.30729.4974_none_50940634bcb759cb\MSVCR 90.dll
76364911 00000000 0001:00043911 C:\Windows\system32\kernel32.dll
7729E4B6 00000000 0001:0003D4B6 C:\Windows\system32\ntdll.dll
7729E489 00000000 0001:0003D489 C:\Windows\system32\ntdll.dll
Call stack:
Address Frame Function SourceFile
772B9A94 00000000 0001:00058A94 C:\Windows\system32\ntdll.dll
7636C1B2 00000000 0001:0004B1B2 C:\Windows\system32\kernel32.dll
Call stack:
Address Frame Function SourceFile
772B9A94 00000000 0001:00058A94 C:\Windows\system32\ntdll.dll
76321C7A 00000000 0001:00000C7A C:\Windows\system32\kernel32.dll
0091B3F0 00000000 0001:0051A3F0 C:\Server\MaNGOS\Win32\mangosd.exe
00921D30 00000000 0001:00520D30 C:\Server\MaNGOS\Win32\mangosd.exe
0091B1D9 00000000 0001:0051A1D9 C:\Server\MaNGOS\Win32\mangosd.exe
6B551864 00000000 0001:00050864 C:\Server\MaNGOS\Win32\ACE.dll
6B633433 00000000 0001:00022433 C:\Windows\WinSxS\x86_microsoft.vc90.crt_1fc8b3b9a 1e18e3b_9.0.30729.4974_none_50940634bcb759cb\MSVCR 90.dll
6B6334C7 00000000 0001:000224C7 C:\Windows\WinSxS\x86_microsoft.vc90.crt_1fc8b3b9a 1e18e3b_9.0.30729.4974_none_50940634bcb759cb\MSVCR 90.dll
76364911 00000000 0001:00043911 C:\Windows\system32\kernel32.dll
7729E4B6 00000000 0001:0003D4B6 C:\Windows\system32\ntdll.dll
7729E489 00000000 0001:0003D489 C:\Windows\system32\ntdll.dll
Call stack:
Address Frame Function SourceFile
772B9A94 00000000 0001:00058A94 C:\Windows\system32\ntdll.dll
76321C7A 00000000 0001:00000C7A C:\Windows\system32\kernel32.dll
0091B3F0 00000000 0001:0051A3F0 C:\Server\MaNGOS\Win32\mangosd.exe
00921D30 00000000 0001:00520D30 C:\Server\MaNGOS\Win32\mangosd.exe
0091B1D9 00000000 0001:0051A1D9 C:\Server\MaNGOS\Win32\mangosd.exe
6B551864 00000000 0001:00050864 C:\Server\MaNGOS\Win32\ACE.dll
6B633433 00000000 0001:00022433 C:\Windows\WinSxS\x86_microsoft.vc90.crt_1fc8b3b9a 1e18e3b_9.0.30729.4974_none_50940634bcb759cb\MSVCR 90.dll
6B6334C7 00000000 0001:000224C7 C:\Windows\WinSxS\x86_microsoft.vc90.crt_1fc8b3b9a 1e18e3b_9.0.30729.4974_none_50940634bcb759cb\MSVCR 90.dll
76364911 00000000 0001:00043911 C:\Windows\system32\kernel32.dll
7729E4B6 00000000 0001:0003D4B6 C:\Windows\system32\ntdll.dll
7729E489 00000000 0001:0003D489 C:\Windows\system32\ntdll.dll
Call stack:
Address Frame Function SourceFile
772B9A94 00000000 0001:00058A94 C:\Windows\system32\ntdll.dll
76321C7A 00000000 0001:00000C7A C:\Windows\system32\kernel32.dll
0091B3F0 00000000 0001:0051A3F0 C:\Server\MaNGOS\Win32\mangosd.exe
00921D30 00000000 0001:00520D30 C:\Server\MaNGOS\Win32\mangosd.exe
0091B1D9 00000000 0001:0051A1D9 C:\Server\MaNGOS\Win32\mangosd.exe
6B551864 00000000 0001:00050864 C:\Server\MaNGOS\Win32\ACE.dll
6B633433 00000000 0001:00022433 C:\Windows\WinSxS\x86_microsoft.vc90.crt_1fc8b3b9a 1e18e3b_9.0.30729.4974_none_50940634bcb759cb\MSVCR 90.dll
6B6334C7 00000000 0001:000224C7 C:\Windows\WinSxS\x86_microsoft.vc90.crt_1fc8b3b9a 1e18e3b_9.0.30729.4974_none_50940634bcb759cb\MSVCR 90.dll
76364911 00000000 0001:00043911 C:\Windows\system32\kernel32.dll
7729E4B6 00000000 0001:0003D4B6 C:\Windows\system32\ntdll.dll
7729E489 00000000 0001:0003D489 C:\Windows\system32\ntdll.dll
Call stack:
Address Frame Function SourceFile
772B9A94 00000000 0001:00058A94 C:\Windows\system32\ntdll.dll
0D2D7794 00000000 0000:00000000
FF50D845 FFFFFFFF 0000:00000000
Call stack:
Address Frame Function SourceFile
772B9A94 00000000 0001:00058A94 C:\Windows\system32\ntdll.dll
763C6C93 00000000 0001:000A5C93 C:\Windows\system32\kernel32.dll
763C6DCD 00000000 0001:000A5DCD C:\Windows\system32\kernel32.dll
7637A091 00000000 0001:00059091 C:\Windows\system32\kernel32.dll
6B678ED9 00000000 0001:00067ED9 C:\Windows\WinSxS\x86_microsoft.vc90.crt_1fc8b3b9a 1e18e3b_9.0.30729.4974_none_50940634bcb759cb\MSVCR 90.dll
6B67935D 00000000 0001:0006835D C:\Windows\WinSxS\x86_microsoft.vc90.crt_1fc8b3b9a 1e18e3b_9.0.30729.4974_none_50940634bcb759cb\MSVCR 90.dll
6B63EFD2 00000000 0001:0002DFD2 C:\Windows\WinSxS\x86_microsoft.vc90.crt_1fc8b3b9a 1e18e3b_9.0.30729.4974_none_50940634bcb759cb\MSVCR 90.dll
6B63E671 00000000 0001:0002D671 C:\Windows\WinSxS\x86_microsoft.vc90.crt_1fc8b3b9a 1e18e3b_9.0.30729.4974_none_50940634bcb759cb\MSVCR 90.dll
00412F68 00000000 0001:00011F68 C:\Server\MaNGOS\Win32\mangosd.exe
0091B1D9 00000000 0001:0051A1D9 C:\Server\MaNGOS\Win32\mangosd.exe
6B551864 00000000 0001:00050864 C:\Server\MaNGOS\Win32\ACE.dll
6B633433 00000000 0001:00022433 C:\Windows\WinSxS\x86_microsoft.vc90.crt_1fc8b3b9a 1e18e3b_9.0.30729.4974_none_50940634bcb759cb\MSVCR 90.dll
6B6334C7 00000000 0001:000224C7 C:\Windows\WinSxS\x86_microsoft.vc90.crt_1fc8b3b9a 1e18e3b_9.0.30729.4974_none_50940634bcb759cb\MSVCR 90.dll
76364911 00000000 0001:00043911 C:\Windows\system32\kernel32.dll
7729E4B6 00000000 0001:0003D4B6 C:\Windows\system32\ntdll.dll
7729E489 00000000 0001:0003D489 C:\Windows\system32\ntdll.dll
Call stack:
Address Frame Function SourceFile
772B9A94 00000000 0001:00058A94 C:\Windows\system32\ntdll.dll
74F31FC8 00000000 0001:00000FC8 C:\Windows\system32\MSWSOCK.dll
773A1693 00000000 0001:00000693 C:\Windows\system32\WS2_32.dll
6B514F05 00000000 0001:00013F05 C:\Server\MaNGOS\Win32\ACE.dll
FFFFFFFF FFFFFFFF 0000:00000000
Call stack:
Address Frame Function SourceFile
772B9A94 00000000 0001:00058A94 C:\Windows\system32\ntdll.dll
74F31FC8 00000000 0001:00000FC8 C:\Windows\system32\MSWSOCK.dll
773A1693 00000000 0001:00000693 C:\Windows\system32\WS2_32.dll
6B514F05 00000000 0001:00013F05 C:\Server\MaNGOS\Win32\ACE.dll
FFFFFFFF FFFFFFFF 0000:00000000
========================
Local Variables And Parameters
Call stack:
Address Frame Function SourceFile
763642EB 00000000 0001:000432EB C:\Windows\system32\kernel32.dll
6B66DF60 00000000 0001:0005CF60 C:\Windows\WinSxS\x86_microsoft.vc90.crt_1fc8b3b9a 1e18e3b_9.0.30729.4974_none_50940634bcb759cb\MSVCR 90.dll
00457B50 00000000 0001:00056B50 C:\Server\MaNGOS\Win32\mangosd.exe
007C34DE 00000000 0001:003C24DE C:\Server\MaNGOS\Win32\mangosd.exe
007C2C2B 00000000 0001:003C1C2B C:\Server\MaNGOS\Win32\mangosd.exe
007C3C1F 00000000 0001:003C2C1F C:\Server\MaNGOS\Win32\mangosd.exe
007C3AD0 00000000 0001:003C2AD0 C:\Server\MaNGOS\Win32\mangosd.exe
007C39C3 00000000 0001:003C29C3 C:\Server\MaNGOS\Win32\mangosd.exe
007C3900 00000000 0001:003C2900 C:\Server\MaNGOS\Win32\mangosd.exe
007C2DDC 00000000 0001:003C1DDC C:\Server\MaNGOS\Win32\mangosd.exe
007C2EFD 00000000 0001:003C1EFD C:\Server\MaNGOS\Win32\mangosd.exe
004D47DE 00000000 0001:000D37DE C:\Server\MaNGOS\Win32\mangosd.exe
004D4332 00000000 0001:000D3332 C:\Server\MaNGOS\Win32\mangosd.exe
004D4A12 00000000 0001:000D3A12 C:\Server\MaNGOS\Win32\mangosd.exe
00902C8B 00000000 0001:00501C8B C:\Server\MaNGOS\Win32\mangosd.exe
00902140 00000000 0001:00501140 C:\Server\MaNGOS\Win32\mangosd.exe
00906A1D 00000000 0001:00505A1D C:\Server\MaNGOS\Win32\mangosd.exe
0091DDE8 00000000 0001:0051CDE8 C:\Server\MaNGOS\Win32\mangosd.exe
006478F5 00000000 0001:002468F5 C:\Server\MaNGOS\Win32\mangosd.exe
0064620C 00000000 0001:0024520C C:\Server\MaNGOS\Win32\mangosd.exe
0045795E 00000000 0001:0005695E C:\Server\MaNGOS\Win32\mangosd.exe
0091B1D9 00000000 0001:0051A1D9 C:\Server\MaNGOS\Win32\mangosd.exe
6B551864 00000000 0001:00050864 C:\Server\MaNGOS\Win32\ACE.dll
6B633433 00000000 0001:00022433 C:\Windows\WinSxS\x86_microsoft.vc90.crt_1fc8b3b9a 1e18e3b_9.0.30729.4974_none_50940634bcb759cb\MSVCR 90.dll
6B6334C7 00000000 0001:000224C7 C:\Windows\WinSxS\x86_microsoft.vc90.crt_1fc8b3b9a 1e18e3b_9.0.30729.4974_none_50940634bcb759cb\MSVCR 90.dll
76364911 00000000 0001:00043911 C:\Windows\system32\kernel32.dll
7729E4B6 00000000 0001:0003D4B6 C:\Windows\system32\ntdll.dll
7729E489 00000000 0001:0003D489 C:\Windows\system32\ntdll.dll
========================
Global Variables
What's happen ? i'm not sure... i can't believe on that...Looking at your error log, NONE of those errors have anything to do with the repack's files. Here's my suggestion.

1. Check the amount of space on your hard drive.

CRITICAL ERROR.
Couldn't initialize the symbol handler for process.
Error [Not enough storage is available to process this command.
].2. Your memory chip may be going bad, again, has nothing to do with the repack.
Exception code: E06D7363
Fault address: 763642EB 01:000432EB C:\Windows\system32\kernel32.dll3. Uninstall/reinstall the Visual C++ runtimes and the .NET Framework 3.5

4.
772B9A94 00000000 0001:00058A94 C:\Windows\system32\ntdll.dll
74F31FC8 00000000 0001:00000FC8 C:\Windows\system32\MSWSOCK.dll
773A1693 00000000 0001:00000693 C:\Windows\system32\WS2_32.dll
...
7637A091 00000000 0001:00059091 C:\Windows\system32\kernel32.dll
6B678ED9 00000000 0001:00067ED9 C:\Windows\WinSxSYou may have some corrupt files in your Windows Installation, which could be caused by a large of amount of fragmentation. I would suggest:
a. Run CCleaner (with CCenhancer)
b. Run Eusing Free Registry Cleaner
c. Run Defraggler

5.
This application has requested the Runtime to terminate it in an unusual way.
...
6B633433 00000000 0001:00022433 C:\Windows\WinSxS\x86_microsoft.vc90.crt_1fc8b3b9a 1e18e3b_9.0.30729.4974_none_50940634bcb759cb\MSVCR 90.dll
6B6334C7 00000000 0001:000224C7 C:\Windows\WinSxS\x86_microsoft.vc90.crt_1fc8b3b9a 1e18e3b_9.0.30729.4974_none_50940634bcb759cb\MSVCR 90.dll
This can also be caused by a corrupt installation of Visual C++ runtimes.

And the BIGGEST problem of them all...

*** Operation System ***
Windows Vista

Update Compiling:

MaNGOS updated to 10438
Acid Scripts Updated to 36

[Scott]

This is awesome, thanks for spending your time making this :)

[CthulhuFtagn]

Thanks Scott, I appreciate that.

EDIT:

Big update today! I'm happy to say Acid Scripts has been updated from version 35 to version 36 and we just went from 4,601 creatures in ACID 3.0.4 to 5,777 in this release! AND we just went from 17,967 Total Scripts in ACID 3.0.4 to 22,077 in this release. It's an update I've been waiting for since March 19, but we've finally got it implemented!

EDIT 2: While I was writing this an update went in to 'Fix Text Entry Errors', so we are actually now at revision 37. ACID - CIA.vc (http://cia.vc/stats/project/ACID)

Update Available:

MaNGOS updated to 10438
Acid Scripts Updated to 37CU_0024a.zip (http://www.mediafire.com/?q9d46idon42kkrf)(17.63 MB)

Changes in Acid Scripts from 3.0.4 (35) - 3.0.5 (37) "Trial by Fire"

Rough Scripts for Isle of Quel'Danas Trash Mobs added - (Scripted by X-Savior)
Rough Scripts for Searing Gorge Trash Mobs added - (Scripted by X-Savior)
Rough Scripts for Swamp of Sorrows Trash Mobs added - (Scripted by X-Savior)
Rough Scripts for The Hinterlands Trash Mobs added - (Scripted by X-Savior)
Rough Scripts for Western Plaguelands Trash Mobs added - (Scripted by X-Savior)
Rough Scripts for Azshara Trash Mobs added - (Scripted by X-Savior)
Rough Scripts for Bloodmyst Isle Trash Mobs added - (Scripted by X-Savior)
Rough Scripts for Darkshore Trash Mobs added - (Scripted by X-Savior)
Rough Scripts for Desolace Trash Mobs added - (Scripted by X-Savior)
Rough Scripts for Durotar Trash Mobs added - (Scripted by X-Savior)
Rough Scripts for Dustwallow Marsh Trash Mobs added - (Scripted by X-Savior)
Rough Scripts for Felwood Trash Mobs added - (Scripted by X-Savior)
Rough Scripts for Feralas Trash Mobs added - (Scripted by X-Savior)
Rough Scripts for Mulgore Trash Mobs added - (Scripted by X-Savior)
Rough Scripts for Stonetalon Mountains Trash Mobs added - (Scripted by X-Savior)
Improved Existing Scripts for Wailing Caverns and Added Instance Data Scripts - (Scripted by X-Savior)
Improved and Re-Wrote Existing Scripts and Finished Rough Scripting Remaining NPC's for Maraudon - (Scripted by X-Savior)
Improved and Re-Wrote Existing Scripts and Finished Rough Scripting Remaining NPC's for Ragefire Chasm - (Scripted by X-Savior)
Improved and Re-Wrote Existing Scripts and Finished Rough Scripting Remaining NPC's for Razorfen Kraul (NEED TO CHECK SOUND ID'S FOR BOSS STILL) - (Scripted by X-Savior)
Improved and Re-Wrote Existing Scripts and Finished Rough Scripting Remaining NPC's for Scarlet Monastery - (Scripted by X-Savior)
Improved and Re-Wrote Existing Scripts and Finished Rough Scripting Remaining NPC's for Stratholme - (Scripted by X-Savior)
Improved and Re-Wrote Existing Scripts and Finished Rough Scripting Remaining NPC's for Tempest Keep: The Arcatraz - (Scripted by X-Savior)
Improved and Re-Wrote Existing Scripts and Finished Rough Scripting Remaining NPC's for Tempest Keep: The Botanica - (Scripted by X-Savior)
Improved and Re-Wrote Existing Scripts and Finished Rough Scripting Remaining NPC's for Tempest Keep: The Mechanar - (Scripted by X-Savior)
Improved and Re-Wrote Existing Scripts for Tanaris - (Scripted by X-Savior)
Fixed all Thrash Spell Casts (Implemented Proper Proc Auras) - (Scripted by X-Savior)
Removed NPC Dismount/Mount Hack Scripts and Properly Implement These Scripts - (Scripted by X-Savior)
Fixed and Improved Crust Burster and Greater Crust Burster Scripts plus Implemented Scripts for 2 other similar NPC's in Outlands - (Scripted by X-Savior)
Fixed Persistent Liquid Fire of Elune Aura on NPC Respawn - (Scripted by X-Savior)
Added Support for Quest: 12107 and 12110 "The End of the Line" - (Scripted by NoFantasy)
Added Support for Quest: 12630 "Kickin' Nass and Takin' Manes" - (Scripted by NoFantasy)
Added Support for Quest: 12903 "That's What Friends Are For..." - (Scripted by NoFantasy)
Added Spawn Visual for Electromental in Blade's Edge Mountians - (Scripted by Schmoozerd)
Added Scripts for Onyxian Lair Guard - (Scripted by Schmoozerd)
Added Instance Data Scripts for Bosses in Caverns of Time: The Culling of Stratholme - (Scripted by Schmoozerd)
Added Instance Data Scripts for Death's Head Ward Keeper in Razorfen Kraul - (Scripted by Reve)
Added Instance Data Scripts for Sunken Temple - (Scripted by Reve)
Added Instance Data for Vilebranch Speaker in Zul'Gurub - (Scripted by ZPS)
Added Instance Data for Blackhand Veteran and Blackhand Summoner in Blackrock Spire - (Scripted by Schmoozerd)
Added Script Improvements and Additions for Tirisfal Glades - (Original Scripts by Insanity Peppers)
Added Biletoad Infection for Biletoads in Wailing Caverns - (Scripted by Insanity Peppers)
Fixed and Modified Several Call for Help Scripts - (Scripted by X-Savior)
Fixed and Improved Many NPC Buff Scripts - (Scripted by X-Savior)
Fixed and Modified Several Incorrect Event Flags - (Fixed by X-Savior)
Fixed Spell Target Flags for Flamewalker in Molten Core - (Fixed by Schmoozerd)
Fixed and Corrected a bunch of Text Entry Errors - (Fixed by Patman128)
Various Misc Script Fixes and Improvements - (Fixed by X-Savior)
Rewrote MANY Random Existing Scripts in Instances (Many Outdated and Basic Scripts From Early ACID Days were Re-Written) - (Scripted by X-Savior)
General Coding Cleanups/Organizing
Removed all Scripts for NPC's Overlapping with SD2
Continued Adding NPC Place Holders and NPC Script Name Tags For MANY ZonesSo, your mangos databases' db_version table should read:

TRM CU 0024a YTDB 340 Acid 37 MaNGOS 10438 ScriptDev2 1815The World of Warcraft Armory - Jacepwns @ Burning Legion - Profile (http://www.wowarmory.com/character-sheet.xml?r=Burning+Legion&cn=Jacepwns)

http://www.youtube.com/watch?v=ltM5jHIJFw4

[Narcoleptic]

Thank you so much!!! :)

[CthulhuFtagn]

I'm going to get rid of the doubling up of the scripts in empty/mangos folders, what you can do (from now on) is inject the mangos updates into the empty db as well and then run the truncation script in the empty folder. This will save on file size and make things easier for me as well.

This feature will be in the next update.

[Stefan30]

Yep, you can use that one ;)

Looking at your error log, NONE of those errors have anything to do with the repack's files. Here's my suggestion.

1. Check the amount of space on your hard drive.

CRITICAL ERROR.
Couldn't initialize the symbol handler for process.
Error [Not enough storage is available to process this command.
].2. Your memory chip may be going bad, again, has nothing to do with the repack.
Exception code: E06D7363
Fault address: 763642EB 01:000432EB C:\Windows\system32\kernel32.dll3. Uninstall/reinstall the Visual C++ runtimes and the .NET Framework 3.5

4.
772B9A94 00000000 0001:00058A94 C:\Windows\system32\ntdll.dll
74F31FC8 00000000 0001:00000FC8 C:\Windows\system32\MSWSOCK.dll
773A1693 00000000 0001:00000693 C:\Windows\system32\WS2_32.dll
...
7637A091 00000000 0001:00059091 C:\Windows\system32\kernel32.dll
6B678ED9 00000000 0001:00067ED9 C:\Windows\WinSxSYou may have some corrupt files in your Windows Installation, which could be caused by a large of amount of fragmentation. I would suggest:
a. Run CCleaner (with CCenhancer)
b. Run Eusing Free Registry Cleaner
c. Run Defraggler

5.
This application has requested the Runtime to terminate it in an unusual way.
...
6B633433 00000000 0001:00022433 C:\Windows\WinSxS\x86_microsoft.vc90.crt_1fc8b3b9a 1e18e3b_9.0.30729.4974_none_50940634bcb759cb\MSVCR 90.dll
6B6334C7 00000000 0001:000224C7 C:\Windows\WinSxS\x86_microsoft.vc90.crt_1fc8b3b9a 1e18e3b_9.0.30729.4974_none_50940634bcb759cb\MSVCR 90.dll
This can also be caused by a corrupt installation of Visual C++ runtimes.

And the BIGGEST problem of them all...

*** Operation System ***
Windows Vista

Update Compiling:

MaNGOS updated to 10438
Acid Scripts Updated to 36

thanks mate ... i'm already installed a new OS x64 and this time isn't Vista (puke) will try to improve my machine... ;}
Btw great work for the updates! AN ONE BIG THANK YOU ON YOU AND YOUR TEAM...
I know your work is hard but i promise to improve my skills with more reading, not to saddle you with unnecessary work and will mostly try to get rid of "Lazy Leecher" Rank :)

[CthulhuFtagn]

Right on brotherman, glad to hear about you finally gracing your machine with a 21st century operating system.

EDIT:
Small Update Available:

Truncation of Empty Database
3.23 MB smaller file size
.tele locations added
HallsofReflection
TheShadowThrone
TheFrozenHalls
PitofSaron
TheForgeofSouls
ICCEntrance
ScourgelordsCommand

CU_0025.zip (http://www.mediafire.com/?sfjsefagmk2cdms) (14.8 MB)

[Stefan30]

Cthulhu what you mean for 00025.sql ?
You mean i need to inject 0000-00023_mangosall.sql + 00024mangos.sql in the empty database and then inject truncation.sql in empty ? i'm not uderstand exacly... :( sry about the question but i'm a little newbie with that... i told ya in the beggining that my english is not perfect...

[marko94]

Cthulhu what you mean for 00025.sql ?
You mean i need to inject 0000-00023_mangosall.sql + 00024mangos.sql in the empty database and then inject truncation.sql in empty ? i'm not uderstand exacly... :( sry about the question but i'm a little newbie with that... i told ya in the beggining that my english is not perfect...

Execute your "mangos_0000-0025_all' in empty database and just run that truncation SQL...pure and simple.

[Stefan30]

Execute your "mangos_0000-0025_all' in empty database and just run that truncation SQL...pure and simple.

really really very big Thank for that man... It's pure and simple for you ... cuz you know English pretti well... my english is bad and that is fail for me :D i 'll read and learn ... will improve my english in future but for now just need time for that :)
Thanks again :) +rep to you from me :)



Edit:: i've got error on the last step.... when i execute truncation.sql in the empty database
Check it out this:

Error Code : 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TRUNCATE TABLE creature_model_race' at line 2

[CthulhuFtagn]

It was missing a semi-colon after creature_model_info, try this:

TRUNCATE TABLE creature;
TRUNCATE TABLE creature_ai_scripts;
TRUNCATE TABLE creature_ai_texts;
TRUNCATE TABLE creature_battleground;
TRUNCATE TABLE creature_involvedrelation;
TRUNCATE TABLE creature_loot_template;
TRUNCATE TABLE creature_model_info;
TRUNCATE TABLE creature_model_race;
TRUNCATE TABLE creature_movement;
TRUNCATE TABLE creature_movement_scripts;
TRUNCATE TABLE creature_movement_template;
TRUNCATE TABLE creature_onkill_reputation;
TRUNCATE TABLE creature_questrelation;
TRUNCATE TABLE creature_respawn;
TRUNCATE TABLE creature_template;
TRUNCATE TABLE creature_template_addon;
TRUNCATE TABLE npc_gossip;
TRUNCATE TABLE npc_spellclick_spells;
TRUNCATE TABLE npc_text;
TRUNCATE TABLE npc_trainer;
TRUNCATE TABLE npc_vendor;

[Stefan30]

It was missing a semi-colon after creature_model_info, try this:

TRUNCATE TABLE creature;
TRUNCATE TABLE creature_ai_scripts;
TRUNCATE TABLE creature_ai_texts;
TRUNCATE TABLE creature_battleground;
TRUNCATE TABLE creature_involvedrelation;
TRUNCATE TABLE creature_loot_template;
TRUNCATE TABLE creature_model_info;
TRUNCATE TABLE creature_model_race;
TRUNCATE TABLE creature_movement;
TRUNCATE TABLE creature_movement_scripts;
TRUNCATE TABLE creature_movement_template;
TRUNCATE TABLE creature_onkill_reputation;
TRUNCATE TABLE creature_questrelation;
TRUNCATE TABLE creature_respawn;
TRUNCATE TABLE creature_template;
TRUNCATE TABLE creature_template_addon;
TRUNCATE TABLE npc_gossip;
TRUNCATE TABLE npc_spellclick_spells;
TRUNCATE TABLE npc_text;
TRUNCATE TABLE npc_trainer;
TRUNCATE TABLE npc_vendor;

i don't found the biggest words for you man... you're just ... increadible godlike maybe
Thanks

[CthulhuFtagn]

You're very welcome.

Ia! Ia! Cthulhu fhtagn!
Ph'nglui mglw'nafh Cthulhu R'lyeh wgah'nagl fhtagn.
In his house at R'lyeh, dead Cthulhu waits dreaming.

http://img809.imageshack.us/img809/5299/unclecthulhu.jpg

[Stefan30]

You're very welcome.

Ia! Ia! Cthulhu fhtagn!
Ph'nglui mglw'nafh Cthulhu R'lyeh wgah'nagl fhtagn.
In his house at R'lyeh, dead Cthulhu waits dreaming.

http://img809.imageshack.us/img809/5299/unclecthulhu.jpg

Waaaaaaaaaaah! :( The face eating monster ! :( run RUN, believe me, YOU DON'T WANT MY SOUL MISTRESS! :( i'm salty

[CthulhuFtagn]

Is there any other teleport locations that you notice would be good to have? I know some people were PMing me about the ones I posted earlier.... if you've got some more just let me know and I'll add em'.

[Stefan30]

Is there any other teleport locations that you notice would be good to have? I know some people were PMing me about the ones I posted earlier.... if you've got some more just let me know and I'll add em'.

You mean ICC_teleporter.sql ? :D i saw that can i extract it now ? does it works correctly ?

[marko94]

You mean ICC_teleporter.sql ? :D i saw that can i extract it now ? does it works correctly ?

Haha :D , no man he means if you have a nice teleport location in mind and you think it should be added, say what's on your mind.

[Stefan30]

oh... (headbang) :D sorry ... no i dont think for now...
@CthulhuFtagn can i ask you something... ?
In the freshly updates 0025 does it need to be added the missing creatures what i'd been posted early.... you know - i mean for PoS and FoS and HoR :) ?

[CthulhuFtagn]

They were not included in the release... I'm testing first.

[Narcoleptic]

Friend sorry to bother with this again but just an update on the problem...i notice that not only Stamina is bugged but also the Attack Power and the Armor...so none of them give the bonus to the pet :)
Sorry if you already knew this friend :)
Thanks

[skiik]

I never used quice before. Had a look at it last night. It's pretty overwhelming. Might just wait for an update unless someone can tell me what to change..

On a side note, anyone know where a characters total achievement points are stored in database? Was thinking of building an achievement ladder or something :-)


I can confirum dude :) but for the first time you can make the quest Completeble from your Quice database editor... aaaaaaaaanddd when that quest be scripted and more in some release you can edin him again ;)

@CthulhuFtagn i have some very bad crashes... can someone help me with that problem ?
Checkout the codes:
This error has appeared in my mangosd.exe ... i'm don't touch anything when i start my application and just stay and watch... on every 5 min i don't get errors in my cmd on mangosd.exe and then its appear this:

This application has requested the Runtime to terminate it in an unusual way.
Please contact the application's support team for more information.
Note: There was no players online... i just testing what's the problem and i don't have any idea...

When i check my crash folder i see that:
What's happen ? i'm not sure... i can't believe on that...

[CthulhuFtagn]

Friend sorry to bother with this again but just an update on the problem...i notice that not only Stamina is bugged but also the Attack Power and the Armor...so none of them give the bonus to the pet :)
Sorry if you already knew this friend :)
ThanksYep, already known.


I never used quice before. Had a look at it last night. It's pretty overwhelming. Might just wait for an update unless someone can tell me what to change..

On a side note, anyone know where a characters total achievement points are stored in database? Was thinking of building an achievement ladder or something :-)The game's engine adds them up automatically, the number is not stored in the database.


Small Update Available:

Fix for truncation.sql
Icecrown Citadel teleporters fix
.tele locations added
TheSpire
ThePlagueworks
TheCrimsonHall
BloodPrinces
TheSanctumofBlood
TheFrostWingHalls
TheDreamwalker
SindragosasDoor
TheFrostQueensLair

CU_0026.zip (http://www.mediafire.com/?sdx38j4aarbv82j) (14.82 MB)

[impact1560]

Do I donate to you or this site?

[CthulhuFtagn]

Just donate to mmopro.net
http://mmopro.net/forums/payments.php

EDIT: When I tried to check the link above I got the message

This recipient is currently unable to receive money.I sent a message to MysteriousSouL (http://mmopro.net/forums/members/mysterioussoul/), we'll see what happens.

EDIT 2: He's fixed the link.

Just a heads up to all, if you want a quick and easy way to get rid of that "Lazy Leecher" title, you can donate $15 and get Donator status. You get sparklies around your name as well.

Donators

http://mmopro.net/forums/images/ranks/donator.png

It helps keep these forums running, and insures that I can continue to post my repacks/updates here.

[jimmy6666]

Hi Cthulhu Ftagn

Just noticed a small error: When you go to the darkmoon faire in Elwynn forest, the music doesn't play for it. The regular Elwynn music plays instead.

Just FYI

Cheers,

[impact1560]

Thank You

[Stefan30]

Well... i inject correctly the database ... and i update them without errors... but somethings wrong there, cuz my creatures do not cast any spells... maybe thats from scriptdev2 or maybe from empty truncation?
Can anyone confirum for this MYSTERY? :(

[CthulhuFtagn]

Well... i inject correctly the database ... and i update them without errors... but somethings wrong there, cuz my creatures do not cast any spells... maybe thats from scriptdev2 or maybe from empty truncation?
Can anyone confirum for this MYSTERY? :(Can't confirm that one, not sure what you've done.

If you used the truncation.sql in your mangos database then you shouldn't have ANY creatures... but why you would do that is beyond me. Please stop posting errors (that do not exists) if you have not tried reinstalling the server to check if you did something wrong first.


http://www.youtube.com/watch?v=_5KYRh3qR9o


Hi Cthulhu Ftagn

Just noticed a small error: When you go to the darkmoon faire in Elwynn forest, the music doesn't play for it. The regular Elwynn music plays instead.

Just FYI

Cheers,I'll see what I can do about that. ;)

[Stefan30]

check out the instances .... i see the normal creatures cast spells ... check the instanses for high level

[GrandpaJohn]

@CT:

upadate was successful no problems server running great,

hey man i like that new look on your avatar

[CthulhuFtagn]

I'm going to go check a high-level instance, and if you are wasting my time... I will be talking to MysteriousSouL.

[Stefan30]

I'm going to go check a high-level instance, and if you are wasting my time... I will be talking to MysteriousSouL.

Man i don't have a reason to enrage you ... just yesterday after update i go with my friends to check the instances for the high level ... in FoS, PoS and HoR don't cast spells only melee damage... including and the bosses

[CthulhuFtagn]

Well, I went to Ulduar in the Halls of Lightning and confirmed that you are, in fact, wasting my time again.


http://www.youtube.com/watch?v=CLEDbssPvgE

As you can see I get the knock-back cast at me, as well as Lava Burst at around 00:50.

I've been REALLY patient with you, but now it's getting ridiculous.


EDIT:
@CT:

upadate was successful no problems server running great,

hey man i like that new look on your avatarThanks GJ, if you want an avatar like mine I can create you one based on your favorite toon/npc/enemy/boss.

[Stefan30]

okay man... i understand you're really patient to me ... but i saw that works -> i told you FoS, PoS and HoR .... why you make me so stupid ...

[CthulhuFtagn]

Actually your exact words were:


but somethings wrong there, cuz my creatures do not cast any spells.
Then when I check the "creatures" you change it to "in instances".

check out the instances .... i see the normal creatures cast spells ... check the instanses for high levelSo, I checked a level 80 instance.

Then you said:


okay man... i saw that works i told you FoS, PoS and HoR .... why you make me so stupid ...

You need to be more descriptive if you are going to post bugs.

An example would be: "I was in <INSTANCE> and the creature <CREATURE> did not cast <SPELL>, it was in <THIS AREA> of the <INSTANCE>"

Update Available:

MaNGOS updated to 10442
Fix armor bonus part of talent 33853 and ranks
Fix 64962 bonus for 47541 and ranks.
Implement spell 55680.
Increase search distance at height search if we know expected limit.
Removed un-needed dbghelp.dll in the x64 folderCU_0027.zip (http://www.mediafire.com/?2vteupyc7de0ftw) (14.54)

Gonna take a break this weekend, so this'll be the last update for today.

[Stefan30]

Actually your exact words were:


Then when I check the "creatures" you change it to "in instances".
So, I checked a level 80 instance.

You need to be more descriptive if you are going to post bugs.

An example would be: "I was in <INSTANCE> and the creature <CREATURE> did not cast <SPELL>, it was in <THIS AREA> of the <INSTANCE>"
Okey see.. you imporved me... i really sorry for that you're right... in future i will post more descriptive ;)
Thanks for the update and sorry again it works great... without problems

[CthulhuFtagn]

@ GrandpaJohn (http://mmopro.net/forums/members/grandpajohn/): I made you a cool avatar.

http://img840.imageshack.us/img840/143/granpajohn.png

[GrandpaJohn]

@CT:

hey man i really like it iused to dress up as Good ole Santa at my wife's job so i guess it kinda fits lol

[CthulhuFtagn]

I knew you were the cool granpa like that... my "papa" used to do that too.

EDIT: I know you've never used one, here's how to use it.

1. Right-Click the image and save it to your desktop
2. Go to Settings at the Upper-Right of this page
3. Click on Edit Avatar on the left menu under My Settings
4. Click the radio button Use Custom Avatar
5. Click Browse and click on the image you downloaded, Click OK (or Open)
6. Click Save Changes to the right

voila!

[GrandpaJohn]

hey man there i am lol
it kinda looks like my level 56 alliance knome mage i had name was iggy

[CthulhuFtagn]

Right on! Well, I'll see you guys tomorrow... gonna relax with my little boy and wife. Maybe BBQ tonight.

[GrandpaJohn]

ok man you have a great time with your son and wife they be more important have a great one

[impact1560]

Are you working on a repack for Cataclysm? If so, is this going to be a new repack or an update?

[CthulhuFtagn]

Just checkin' in... yup the Cataclysm repack will be an update just like this, but I will make another topic for it.

Update Available:

MaNGOS updated to 10444
Fixed scripted AI init for TemporarySummon/Totem summon code
Fixed expected packet size for SMSG_SET_PROFICIENCY
Commented out deprecated opcode checksCU_0028a.zip (http://www.mediafire.com/?prt670mtza65xzu) (14.54 MB)

And now back to relaxin' :cool:

[Biohazzard]

Well man :) I know i'm welcome hehe :D
Umm great work for the repack it's working without problems ;)
I'm on my way to test it ;)

Addition:
@Cthulhu Ftagn
Well... it was a looooong night man... so wanna ask you something first...
i was testing all night with my friends (Team & Testers) annd we've got a text file with some unscripted details... can i send you on a private message for sure if there is any mistake not to confuse the users or i must to post here with risk ?
I promise to do my best to describe in detail the information that i givin you. :cool:

[Narcoleptic]

Just checkin' in... yup the Cataclysm repack will be an update just like this, but I will make another topic for it.

Update Available:

MaNGOS updated to 10444
Fixed scripted AI init for TemporarySummon/Totem summon code
Fixed expected packet size for SMSG_SET_PROFICIENCY
Commented out deprecated opcode checksCU_0028a.zip (http://www.mediafire.com/?prt670mtza65xzu) (14.54 MB)

And now back to relaxin' :cool:

Only one word...GOD... :)
Thanks friend

[CthulhuFtagn]

Good morning * yawn *, thanks for the comments.


Well man :) I know i'm welcome hehe :D
Umm great work for the repack it's working without problems ;)
I'm on my way to test it ;)

Addition:
@Cthulhu Ftagn
Well... it was a looooong night man... so wanna ask you something first...
i was testing all night with my friends (Team & Testers) annd we've got a text file with some unscripted details... can i send you on a private message for sure if there is any mistake not to confuse the users or i must to post here with risk ?
I promise to do my best to describe in detail the information that i givin you. :cool:Yeah, just PM it. ;)

Update Available:

MaNGOS updated to 10447
Certain compilers refuse to erase const_iterator...
Small fix for single target auras: remove caster only auras
Re-implement in more safe way single cast spell targets system.

CU_0029.zip (http://www.mediafire.com/?8d8v46zj75wmwqi) (14.54 MB)

[GrandpaJohn]

@CT:

afternoon to you
all updated sucessfully at 12:00 noon my time and everthing running great
loving the avatar man thanks much, have a good time with the family and a great BBQ i hope.

[CthulhuFtagn]

Yep, you're 3 hours ahead from Arizona (Mountain time)... gonna be a good day, the suns out, a nice breeze not too hot, not too cold (where I'm at). You're very welcome.

EDIT: That's why you're so cool... you're from the future! :cool:

[Biohazzard]

good ... waiting for your Private Message CT :)

[CthulhuFtagn]

Go ahead and send the errors you spoke of, I'm gonna go drop off some of my sons old baby clothes at my brothers'.

[Biohazzard]

Umm... dude have a little problem... i'm newrly registered here and i can't send private messages yet ;) i'll try something
GL

Edit: Okey... try this for now download (http://www.4shared.com/account/document/8ySHwmaa/ReportForCT.html)

[ellenya]

#include "precompiled.h"
#include "def_spire.h"

enum BossSpells
{
SPELL_INFEST = 70541,
SPELL_NECROTIC_PLAGUE = 70337,
SPELL_PLAGUE_SIPHON = 74074,
SPELL_SOUL_REAPER = 69409,
SPELL_SPAWN_DEFILE = 72762,
SPELL_HARVEST_SOUL = 68980,
SPELL_HARVEST_SOUL_TELEPORT = 71372,
//
SPELL_CHANNEL_KING = 71769,
SPELL_BROKEN_FROSTMOURNE = 72398,
SPELL_BOOM_VISUAL = 72726,
SPELL_ICEBLOCK_TRIGGER = 71614,
SPELL_TIRION_LIGHT = 71797,
SPELL_FROSTMOURNE_TRIGGER = 72405,
SPELL_SUMMON_BROKEN_FROSTMOURNE = 72406,
SPELL_SUMMON_BROKEN_FROSTMOURNE_2 = 73017,
SPELL_DISENGAGE = 61508,
SPELL_FURY_OF_FROSTMOURNE = 70063,
SPELL_REVIVE_VISUAL = 37755,
SPELL_REVIVE = 51918,
SPELL_CLONE_PLAYER = 57507,
SPELL_BERSERK = 47008,

SPELL_REMORSELESS_WINTER = 68981,
SPELL_PAIN_AND_SUFFERING = 72133,
SPELL_QUAKE = 72262,

// SPELL_SUMMON_RAGING_SPIRIT = 69201, // triggered
SPELL_SUMMON_RAGING_SPIRIT = 69200,
SPELL_SOUL_SHRIEK = 69242,

SPELL_SUMMON_ICE_SPHERE = 69103,
SPELL_ICE_PULSE = 69099,
SPELL_ICE_BURST = 69108,
SPELL_ICE_SPHERE_VISUAL = 69090,

SPELL_SUMMON_DRUDGE_GHOULS = 70358,

SPELL_SUMMON_SHAMBLING_HORROR = 70372,
SPELL_SHOCKWAVE = 72149,
SPELL_HORROR_ENRAGE = 72143,

SPELL_SUMMON_VILE_SPIRITS = 70498,
SPELL_SPIRITS_BURST = 70503,

SPELL_SUMMON_VALKYR = 69037,
NPC_VALKYR = 36609,
SPELL_WINGS_OF_THE_DAMNED = 74352,

SPELL_DEFILE = 72743,

SPELL_REVALL = 26687,

NPC_ICE_SPHERE = 36633,
NPC_DEFILER = 38757,
NPC_RAGING_SPIRIT = 36701,
NPC_VILE_SPIRIT = 37799,
NPC_STRANGULATE_VEHICLE = 36598,

};

enum Common
{
FINAL_ARTHAS_MOVIE = 16,
};

static Locations SpawnLoc[]=
{
{459.93689f, -2124.638184f, 1040.860107f}, // 0 Lich King Intro
{503.15652f, -2124.516602f, 1040.860107f}, // 1 Lich king move end
{491.27118f, -2124.638184f, 1040.860107f}, // 2 Tirion 1
{481.69797f, -2124.638184f, 1040.860107f}, // 3 Tirion 2
{498.00448f, -2201.573486f, 1046.093872f}, // 4 Valkyrs?
{517.48291f, -2124.905762f, 1040.861328f}, // 5 Tirion?
{529.85302f, -2124.709961f, 1040.859985f}, // 6 Lich king final, o=3.1146
{520.311f, -2124.709961f, 1040.859985f}, // 7 Frostmourne
};

struct MANGOS_DLL_DECL boss_the_lich_king_iccAI : public BSWScriptedAI
{
boss_the_lich_king_iccAI(Creature* pCreature) : BSWScriptedAI(pCreature)
{
pInstance = (instance_icecrown_spire*)pCreature->GetInstanceData();
oldflag = 0;
Reset();
}

instance_icecrown_spire* pInstance;
uint8 stage;
uint32 nextEvent;
uint32 nextPoint;
uint32 UpdateTimer;
uint32 oldflag;
bool movementstarted;
bool battlestarted;
bool finalphase;
Creature* pTirion;
Creature* pFrostmourne;

void Reset()
{
if(!pInstance) return;
resetTimers();
stage = 0;
nextEvent = 0;
nextPoint = 0;
movementstarted = false;
battlestarted = false;
finalphase = false;
m_creature->SetOrientation(0.0f);
pInstance->CloseDoor(pInstance->GetData64(GO_ICESHARD_1));
pInstance->CloseDoor(pInstance->GetData64(GO_ICESHARD_2));
pInstance->CloseDoor(pInstance->GetData64(GO_ICESHARD_3));
pInstance->CloseDoor(pInstance->GetData64(GO_ICESHARD_4));
if (oldflag)
if (GameObject* pGoFloor = pInstance->instance->GetGameObject(pInstance->GetData64(GO_ARTHAS_PLATFORM)))
{
pGoFloor->RemoveFlag(GAMEOBJECT_FLAGS, GO_FLAG_DAMAGED | GO_FLAG_NODESPAWN);
pGoFloor->SetUInt32Value(GAMEOBJECT_BYTES_1,oldflag);
}
pInstance->CloseDoor(pInstance->GetData64(GO_FROSTY_WIND));
}

void MoveInLineOfSight(Unit* pWho)
{
}

void EnterEvadeMode()
{
if (!pInstance) return;
if (finalphase && pInstance->GetData(TYPE_LICH_KING) == IN_PROGRESS) return;

m_creature->RemoveAllAuras();
m_creature->DeleteThreatList();
m_creature->CombatStop(true);
m_creature->LoadCreaturesAddon();
if (m_creature->isAlive())
m_creature->GetMotionMaster()->MoveTargetedHome();

m_creature->SetLootRecipient(NULL);

Reset();
}

void MovementInform(uint32 type, uint32 id)
{
if (type != POINT_MOTION_TYPE || !movementstarted) return;
if (id == nextPoint)
{
movementstarted = false;
pInstance->SetData(TYPE_EVENT,nextEvent);
m_creature->GetMotionMaster()->MovementExpired();
}
}

void KilledUnit(Unit* pVictim)
{

if (!battlestarted) return;

switch (urand(0,1)) {
case 0:
DoScriptText(-1631519,m_creature,pVictim);
break;
case 1:
DoScriptText(-1631517,m_creature,pVictim);
break;
};
}

void JustReachedHome()
{
if (!pInstance) return;
pInstance->SetData(TYPE_LICH_KING, FAIL);
stage = 0;
battlestarted = false;
finalphase = false;
}


void StartMovement(uint32 id, uint32 _nextEvent)
{
nextPoint = id;
nextEvent = _nextEvent;
m_creature->GetMotionMaster()->Clear();
m_creature->GetMotionMaster()->MovePoint(id, SpawnLoc[id].x, SpawnLoc[id].y, SpawnLoc[id].z);
pInstance->SetData(TYPE_EVENT,0);
movementstarted = true;
}

void JustSummoned(Creature* summoned)
{
if(!pInstance || !summoned) return;

if (Unit* pTarget = doSelectRandomPlayerAtRange(60.0f))
{
summoned->SetInCombatWith(pTarget);
summoned->AddThreat(pTarget,100.0f);
}
}

void Aggro(Unit *who)
{
if(!pInstance) return;
pInstance->SetData(TYPE_LICH_KING, IN_PROGRESS);
}

void JustDied(Unit *killer)
{
if(!pInstance) return;
pInstance->SetData(TYPE_LICH_KING, DONE);
DoScriptText(-1631528,m_creature,killer);

pInstance->SetData(TYPE_EVENT,14010);

}

void UpdateAI(const uint32 diff)
{

if(!pInstance) return;

if (pInstance->GetData(TYPE_EVENT_NPC) == NPC_LICH_KING)
{
UpdateTimer = pInstance->GetData(TYPE_EVENT_TIMER);
if (UpdateTimer <= diff)
{
debug_log("EventMGR: creature %u received signal %u ",m_creature->GetEntry(),pInstance->GetData(TYPE_EVENT));
switch (pInstance->GetData(TYPE_EVENT))
{
case 12000:
m_creature->SetUInt32Value(UNIT_NPC_EMOTESTATE, EMOTE_STATE_STAND);
m_creature->SetStandState(UNIT_STAND_STATE_STAND);
StartMovement(0,12020);
break;
case 12020:
m_creature->SetUInt32Value(UNIT_NPC_EMOTESTATE, EMOTE_STATE_TALK);
DoScriptText(-1631501, m_creature);
UpdateTimer = 12000;
pInstance->SetData(TYPE_EVENT,12030);
break;
case 12040:
m_creature->SetUInt32Value(UNIT_NPC_EMOTESTATE, EMOTE_STATE_READY2H);
DoScriptText(-1631503, m_creature);
UpdateTimer = 8000;
pInstance->SetData(TYPE_EVENT,12041);
break;
case 12041:
m_creature->SetUInt32Value(UNIT_NPC_EMOTESTATE, EMOTE_STATE_LAUGH);
UpdateTimer = 3000;
pInstance->SetData(TYPE_EVENT,12042);
break;
case 12042:
m_creature->SetUInt32Value(UNIT_NPC_EMOTESTATE,EMOTE_ONESHOT_P OINT_NOSHEATHE);
UpdateTimer = 2000;
pInstance->SetData(TYPE_EVENT,12043);
break;
case 12043:
m_creature->SetUInt32Value(UNIT_NPC_EMOTESTATE,EMOTE_ONESHOT_N ONE);
UpdateTimer = 10000;
pInstance->SetData(TYPE_EVENT,12050);
break;
case 12060:
m_creature->SetUInt32Value(UNIT_NPC_EMOTESTATE, EMOTE_STATE_TALK);
DoScriptText(-1631505, m_creature);
UpdateTimer = 10000;
pInstance->SetData(TYPE_EVENT,12080);
break;
case 12080:
m_creature->SetUInt32Value(UNIT_NPC_EMOTESTATE,EMOTE_STATE_REA DY2H);
UpdateTimer = 2000;
pInstance->SetData(TYPE_EVENT,12100);
break;
case 12100:
m_creature->SetUInt32Value(UNIT_NPC_EMOTESTATE,EMOTE_ONESHOT_N ONE);
UpdateTimer = 6000;
pInstance->SetData(TYPE_EVENT,12120);
break;
case 12120:
m_creature->SetInCombatWithZone();
battlestarted = true;
pInstance->SetData(TYPE_EVENT,12200);
UpdateTimer = 10000;
break;
case 12200:
DoScriptText(-1631506, m_creature);
UpdateTimer = 5000;
pInstance->SetData(TYPE_EVENT,12220);
break;
case 13000:
m_creature->SetOrientation(3.1146f);
DoScriptText(-1631507, m_creature);
UpdateTimer = 12000;
finalphase = true;
doCast(SPELL_FURY_OF_FROSTMOURNE);
pInstance->SetData(TYPE_EVENT,13020);
if (pTirion = (Creature*)Unit::GetUnit((*m_creature),pInstance->GetData64(NPC_TIRION))) {
m_creature->SetInCombatWith(pTirion);
pTirion->AddThreat(m_creature, 1000.0f);
}
m_creature->SetInCombatWithZone();
break;
case 13020:
DoScriptText(-1631508, m_creature);
UpdateTimer = 12000;
pInstance->SetData(TYPE_EVENT,13060);
break;
case 13060:
DoScriptText(-1631509, m_creature);
UpdateTimer = 15000;
pInstance->SetData(TYPE_EVENT,13100);
break;
case 13100:
DoScriptText(-1631510, m_creature);
UpdateTimer = 15000;
pInstance->SetData(TYPE_EVENT,13110);
doCast(SPELL_CHANNEL_KING);
break;
case 13120:
DoScriptText(-1631511, m_creature);
UpdateTimer = 12000;
pInstance->SetData(TYPE_EVENT,13130);
break;
case 13140:
UpdateTimer = 6000;
doRemove(SPELL_CHANNEL_KING);
pInstance->SetData(TYPE_EVENT,13150);
m_creature->CastSpell(m_creature, SPELL_SUMMON_BROKEN_FROSTMOURNE, false);
break;
case 13160:
UpdateTimer = 6000;
pInstance->SetData(TYPE_EVENT,13170);
m_creature->CastSpell(m_creature, SPELL_SUMMON_BROKEN_FROSTMOURNE_2, false);
break;
case 13180:
UpdateTimer = 12000;
pInstance->SetData(TYPE_EVENT,13190);
if (pFrostmourne = m_creature->SummonCreature(NPC_FROSTMOURNE_HOLDER, SpawnLoc[7].x, SpawnLoc[7].y, SpawnLoc[7].z, 0, TEMPSUMMON_MANUAL_DESPAWN, 5000))
{
pFrostmourne->CastSpell(pFrostmourne, SPELL_BROKEN_FROSTMOURNE, false);
pFrostmourne->CastSpell(pFrostmourne, SPELL_FROSTMOURNE_TRIGGER, false);
pFrostmourne->GetMotionMaster()->MoveChase(m_creature);
m_creature->SetFlag(UNIT_FIELD_FLAGS, UNIT_FLAG_DISARMED);
}
break;
case 13200:
DoScriptText(-1631512, m_creature);
m_creature->RemoveAurasDueToSpell(SPELL_SUMMON_BROKEN_FROSTMOU RNE);
m_creature->RemoveAllAuras();
pFrostmourne->RemoveAurasDueToSpell(SPELL_FROSTMOURNE_TRIGGER);
UpdateTimer = 5000;
pInstance->SetData(TYPE_EVENT,13210);
break;
case 13280:
UpdateTimer = 2000;
pInstance->SetData(TYPE_EVENT,13290);
stage = 13;
if (pFrostmourne) pFrostmourne->ForcedDespawn();
if (Creature* pTemp = (Creature*)Unit::GetUnit((*m_creature),pInstance->GetData64(NPC_FROSTMOURNE_TRIGGER)))
pTemp->ForcedDespawn();
if (Creature* pTemp = (Creature*)Unit::GetUnit((*m_creature),pInstance->GetData64(NPC_FROSTMOURNE_HOLDER)))
pTemp->ForcedDespawn();
SetCombatMovement(true);
battlestarted = true;
break;
default:
break;
}
} else UpdateTimer -= diff;
pInstance->SetData(TYPE_EVENT_TIMER, UpdateTimer);
}

if (battlestarted && !m_creature->SelectHostileTarget() && !finalphase)
{
battlestarted = false;
pInstance->SetData(TYPE_LICH_KING, FAIL);
pInstance->SetData(TYPE_EVENT,0);
EnterEvadeMode();
return;
}

if (!m_creature->SelectHostileTarget() || !m_creature->getVictim())
return;

switch(stage)
{
case 0: // Phase 1
// timedCast(SPELL_SHOCKWAVE, diff);
timedCast(SPELL_INFEST, diff);
timedCast(SPELL_SUMMON_DRUDGE_GHOULS, diff);
timedCast(SPELL_PLAGUE_SIPHON, diff);
timedCast(SPELL_SUMMON_SHAMBLING_HORROR, diff);
timedCast(SPELL_NECROTIC_PLAGUE, diff);

DoMeleeAttackIfReady();
if (timedQuery(SPELL_BERSERK, diff))
{
doCast(SPELL_BERSERK);
DoScriptText(-1631518,m_creature);
};

if (m_creature->GetHealthPercent() < 70.0f)
{
stage = 1;
DoScriptText(-1631515,m_creature);
}
break;
case 1: // Go in transition phase
m_creature->AttackStop();
m_creature->SetFlag(UNIT_FIELD_FLAGS, UNIT_FLAG_NON_ATTACKABLE);
SetCombatMovement(false);
StartMovement(1,0);
stage = 2;
break;
case 2:
if (movementstarted) return;
doCast(SPELL_REMORSELESS_WINTER);
stage = 3;
break;
case 3:
timedCast(SPELL_SUMMON_RAGING_SPIRIT, diff);
timedCast(SPELL_SUMMON_ICE_SPHERE, diff);
timedCast(SPELL_PAIN_AND_SUFFERING, diff);

if (timedQuery(SPELL_BERSERK, diff))
{
doCast(SPELL_BERSERK);
DoScriptText(-1631518,m_creature);
};

if (timedQuery(SPELL_REMORSELESS_WINTER, diff))
{
doCast(SPELL_QUAKE);
stage = 4;
DoScriptText(-1631524, m_creature);
pInstance->OpenDoor(pInstance->GetData64(GO_SNOW_EDGE));
};
break;
case 4: // Platform destruct
if (timedQuery(SPELL_QUAKE, diff))
{
pInstance->OpenDoor(pInstance->GetData64(GO_ICESHARD_1));
pInstance->OpenDoor(pInstance->GetData64(GO_ICESHARD_2));
pInstance->OpenDoor(pInstance->GetData64(GO_ICESHARD_3));
pInstance->OpenDoor(pInstance->GetData64(GO_ICESHARD_4));
if (GameObject* pGoFloor = pInstance->instance->GetGameObject(pInstance->GetData64(GO_ARTHAS_PLATFORM)))
{
pGoFloor->SetFlag(GAMEOBJECT_FLAGS, GO_FLAG_DAMAGED | GO_FLAG_NODESPAWN);
oldflag = pGoFloor->GetUInt32Value(GAMEOBJECT_BYTES_1);
pGoFloor->SetUInt32Value(GAMEOBJECT_BYTES_1,8449);
}
pInstance->CloseDoor(pInstance->GetData64(GO_FROSTY_WIND));
pInstance->CloseDoor(pInstance->GetData64(GO_SNOW_EDGE));
m_creature->GetMotionMaster()->Clear();
m_creature->GetMotionMaster()->MoveChase(m_creature->getVictim());
m_creature->RemoveFlag(UNIT_FIELD_FLAGS, UNIT_FLAG_NON_ATTACKABLE);
SetCombatMovement(true);
stage = 5;
}
break;
case 5: // Phase 2

if (timedQuery(SPELL_SPAWN_DEFILE, diff))
{
doCast(SPELL_SPAWN_DEFILE);
DoScriptText(-1631531,m_creature);
}
if (timedQuery(SPELL_SUMMON_VALKYR, diff))
{
doCast(SPELL_SUMMON_VALKYR);
DoScriptText(-1631527,m_creature);
}

timedCast(SPELL_SOUL_REAPER, diff);
timedCast(SPELL_INFEST, diff);

DoMeleeAttackIfReady();

if (timedQuery(SPELL_BERSERK, diff))
{
doCast(SPELL_BERSERK);
DoScriptText(-1631518,m_creature);
};

if (m_creature->GetHealthPercent() < 40.0f)
{
stage = 6;
DoScriptText(-1631523,m_creature);
}
break;
case 6: // Go in transition phase
m_creature->AttackStop();
m_creature->SetFlag(UNIT_FIELD_FLAGS, UNIT_FLAG_NON_ATTACKABLE);
SetCombatMovement(false);
StartMovement(1,0);
stage = 7;
break;
case 7: // Platform restore
if (movementstarted) return;
if (GameObject* pGoFloor = pInstance->instance->GetGameObject(pInstance->GetData64(GO_ARTHAS_PLATFORM)))
{
pGoFloor->RemoveFlag(GAMEOBJECT_FLAGS, GO_FLAG_DAMAGED | GO_FLAG_NODESPAWN);
pGoFloor->SetUInt32Value(GAMEOBJECT_BYTES_1,oldflag);
}
pInstance->OpenDoor(pInstance->GetData64(GO_FROSTY_WIND));
doCast(SPELL_REMORSELESS_WINTER);
stage = 8;
break;
case 8:
timedCast(SPELL_SUMMON_RAGING_SPIRIT, diff);
timedCast(SPELL_SUMMON_ICE_SPHERE, diff);
timedCast(SPELL_PAIN_AND_SUFFERING, diff);

if (timedQuery(SPELL_BERSERK, diff))
{
doCast(SPELL_BERSERK);
DoScriptText(-1631518,m_creature);
};

if (timedQuery(SPELL_REMORSELESS_WINTER, diff))
{
DoScriptText(-1631524, m_creature);
doCast(SPELL_SUMMON_VILE_SPIRITS);
for (uint8 i = 0; i < getSpellData(SPELL_SUMMON_VILE_SPIRITS); ++i)
doCast(NPC_VILE_SPIRIT);
doCast(SPELL_QUAKE);
stage = 9;
pInstance->OpenDoor(pInstance->GetData64(GO_SNOW_EDGE));
};

break;
case 9: // Platform destruct
if (timedQuery(SPELL_QUAKE, diff))
{
if (GameObject* pGoFloor = pInstance->instance->GetGameObject(pInstance->GetData64(GO_ARTHAS_PLATFORM)))
{
pGoFloor->SetFlag(GAMEOBJECT_FLAGS, GO_FLAG_DAMAGED | GO_FLAG_NODESPAWN);
oldflag = pGoFloor->GetUInt32Value(GAMEOBJECT_BYTES_1);
pGoFloor->SetUInt32Value(GAMEOBJECT_BYTES_1,8449);
}
pInstance->CloseDoor(pInstance->GetData64(GO_SNOW_EDGE));
pInstance->CloseDoor(pInstance->GetData64(GO_FROSTY_WIND));
m_creature->GetMotionMaster()->Clear();
m_creature->GetMotionMaster()->MoveChase(m_creature->getVictim());
m_creature->RemoveFlag(UNIT_FIELD_FLAGS, UNIT_FLAG_NON_ATTACKABLE);
SetCombatMovement(true);
stage = 10;
}
break;
case 10: // Phase 3
if (timedQuery(SPELL_SPAWN_DEFILE, diff))
{
doCast(SPELL_SPAWN_DEFILE);
// DoScriptText(-1631527,m_creature);
}
timedCast(SPELL_SOUL_REAPER, diff);

if (timedQuery(SPELL_HARVEST_SOUL, diff))
{
doCast(SPELL_HARVEST_SOUL);
DoScriptText(-1631520,m_creature);
}

timedCast(SPELL_SOUL_REAPER, diff);
timedCast(SPELL_INFEST, diff);

DoMeleeAttackIfReady();

if (m_creature->GetHealthPercent() < 10.0f)
{
stage = 11;
DoScriptText(-1631513,m_creature);
}
break;
case 11: // Ending Phase start
m_creature->AttackStop();
SetCombatMovement(false);
StartMovement(6,13000);
stage = 12;
battlestarted = false;
break;
case 12:
break;
case 13:
DoMeleeAttackIfReady();
break;
}
}
};


CreatureAI* GetAI_boss_the_lich_king_icc(Creature* pCreature)
{
return new boss_the_lich_king_iccAI(pCreature);
};

struct MANGOS_DLL_DECL boss_tirion_iccAI : public ScriptedAI
{
boss_tirion_iccAI(Creature* pCreature) : ScriptedAI(pCreature)
{
pInstance = (ScriptedInstance*)pCreature->GetInstanceData();
Reset();
}

ScriptedInstance *pInstance;
uint32 UpdateTimer;
uint32 nextEvent;
uint32 nextPoint;
bool movementstarted;
Creature* pMenethil;

void Reset()
{
if(!pInstance) return;
movementstarted = false;
m_creature->RemoveAurasDueToSpell(SPELL_ICEBLOCK_TRIGGER);
m_creature->SetOrientation(M_PI_F);
}

void StartMovement(uint32 id, uint32 _nextEvent)
{
nextPoint = id;
nextEvent = _nextEvent;
m_creature->GetMotionMaster()->MovePoint(id, SpawnLoc[id].x, SpawnLoc[id].y, SpawnLoc[id].z);
pInstance->SetData(TYPE_EVENT,0);
movementstarted = true;
}

void MovementInform(uint32 type, uint32 id)
{
if (type != POINT_MOTION_TYPE || !movementstarted) return;
if (id == nextPoint)
{
movementstarted = false;
pInstance->SetData(TYPE_EVENT,nextEvent);
m_creature->GetMotionMaster()->MovementExpired();
}
}

void doSendCinematic()
{
Map::PlayerList const &pList = m_creature->GetMap()->GetPlayers();
if (pList.isEmpty()) return;
for (Map::PlayerList::const_iterator i = pList.begin(); i != pList.end(); ++i)
if (Player* pPlayer = i->getSource())
if (pPlayer && pPlayer->isAlive() && pPlayer->IsInMap(m_creature))
pPlayer->SendMovieStart(FINAL_ARTHAS_MOVIE);
}

void doRevivePlayers()
{
Map::PlayerList const &pList = pMenethil->GetMap()->GetPlayers();
if (pList.isEmpty()) return;
for (Map::PlayerList::const_iterator i = pList.begin(); i != pList.end(); ++i)
{
if (Player* pPlayer = i->getSource())
{
if (pPlayer && !pPlayer->isAlive() && pPlayer->IsInMap(pMenethil))
{
pMenethil->CastSpell(pPlayer, SPELL_REVALL, true);
pPlayer->ResurrectPlayer(100, false);
}
}
};
}

void UpdateAI(const uint32 diff)
{

if (pInstance->GetData(TYPE_LICH_KING) == FAIL && m_creature->HasAura(SPELL_ICEBLOCK_TRIGGER))
{
m_creature->RemoveAurasDueToSpell(SPELL_ICEBLOCK_TRIGGER);
m_creature->GetMotionMaster()->MoveTargetedHome();
Reset();
}

if (pInstance->GetData(TYPE_EVENT_NPC) == NPC_TIRION)
{
UpdateTimer = pInstance->GetData(TYPE_EVENT_TIMER);
if (UpdateTimer <= diff)
{
debug_log("EventMGR: creature %u received signal %u ",m_creature->GetEntry(),pInstance->GetData(TYPE_EVENT));
switch (pInstance->GetData(TYPE_EVENT))
{
case 12030:
m_creature->SetUInt32Value(UNIT_NPC_EMOTESTATE, EMOTE_ONESHOT_TALK);
DoScriptText(-1631552, m_creature);
UpdateTimer = 9000;
pInstance->SetData(TYPE_EVENT,12040);
break;
case 12050:
m_creature->SetUInt32Value(UNIT_NPC_EMOTESTATE, EMOTE_ONESHOT_POINT_NOSHEATHE);
DoScriptText(-1631554, m_creature);
UpdateTimer = 3000;
pInstance->SetData(TYPE_EVENT,12051);
break;
case 12051:
m_creature->SetUInt32Value(UNIT_NPC_EMOTESTATE, EMOTE_ONESHOT_NONE);
UpdateTimer = 1000;
pInstance->SetData(TYPE_EVENT,12052);
break;
case 12052:
m_creature->RemoveSplineFlag(SPLINEFLAG_WALKMODE);
StartMovement(3,12053);
break;
case 12053:
UpdateTimer = 3000;
pInstance->SetData(TYPE_EVENT,12060);
m_creature->CastSpell(m_creature, SPELL_ICEBLOCK_TRIGGER, true);
break;
case 13110:
DoScriptText(-1631555, m_creature);
UpdateTimer = 6000;
m_creature->CastSpell(m_creature, SPELL_TIRION_LIGHT, false);
pInstance->SetData(TYPE_EVENT,13120);
break;
case 13130:
SetCombatMovement(false);
m_creature->RemoveAurasDueToSpell(SPELL_ICEBLOCK_TRIGGER);
UpdateTimer = 500;
m_creature->SetOrientation(0.0f);
pInstance->SetData(TYPE_EVENT,13131);
break;
case 13131:
m_creature->RemoveSplineFlag(SPLINEFLAG_WALKMODE);
StartMovement(2,13132);
break;
case 13132:
StartMovement(5,13140);
DoScriptText(-1631556, m_creature);
m_creature->SetUInt32Value(UNIT_NPC_EMOTESTATE, EMOTE_STATE_READY2H);
break;
case 13150:
UpdateTimer = 1000;
pInstance->SetData(TYPE_EVENT,13160);
break;
case 13170:
UpdateTimer = 2000;
pInstance->SetData(TYPE_EVENT,13180);
break;
case 13190:
UpdateTimer = 500;
pInstance->SetData(TYPE_EVENT,13200);
break;
case 13210:
UpdateTimer = 3000;
pInstance->SetData(TYPE_EVENT,13230);
break;
case 13230:
UpdateTimer = 12000;
pMenethil = m_creature->SummonCreature(NPC_MENETHIL, m_creature->GetPositionX()+5, m_creature->GetPositionY()+5, m_creature->GetPositionZ(), 0, TEMPSUMMON_MANUAL_DESPAWN, 5000);
pInstance->SetData(TYPE_EVENT,13250);
DoScriptText(-1631560, pMenethil);
break;
case 13250:
UpdateTimer = 6000;
pInstance->SetData(TYPE_EVENT,13270);
DoScriptText(-1631561, pMenethil);
pMenethil->CastSpell(pMenethil, SPELL_REVIVE_VISUAL, false);
doRevivePlayers();
break;
case 13270:
UpdateTimer = 6000;
pInstance->SetData(TYPE_EVENT,13280);
if (Creature* pLichKing = (Creature*)Unit::GetUnit((*m_creature),pInstance->GetData64(NPC_LICH_KING)))
{
m_creature->SetInCombatWith(pLichKing);
pLichKing->SetInCombatWith(m_creature);
pLichKing->AddThreat(m_creature, 1000.0f);
m_creature->AI()->AttackStart(pLichKing);
pMenethil->AI()->AttackStart(pLichKing);
SetCombatMovement(true);
m_creature->GetMotionMaster()->MoveChase(pLichKing);
};
break;
case 13290:
UpdateTimer = 5000;
pInstance->SetData(TYPE_EVENT,13310);
DoScriptText(-1631590, pMenethil);
break;
case 13310:
UpdateTimer = 5000;
pInstance->SetData(TYPE_EVENT,13330);
DoScriptText(-1631591, m_creature);
break;
case 13330:
UpdateTimer = 5000;
pInstance->SetData(TYPE_EVENT,13350);
DoScriptText(-1631592, pMenethil);
break;
case 13350:
UpdateTimer = 2000;
pInstance->SetData(TYPE_EVENT,13370);
DoScriptText(-1631593, m_creature);
break;
case 14010:
m_creature->AttackStop();
SetCombatMovement(false);
UpdateTimer =90000;
pInstance->SetData(TYPE_EVENT,14030);
m_creature->SetUInt32Value(UNIT_NPC_EMOTESTATE, EMOTE_ONESHOT_NONE);
if (Creature* pLichKing = (Creature*)Unit::GetUnit((*m_creature),pInstance->GetData64(NPC_LICH_KING)))
pLichKing->RemoveFlag(UNIT_DYNAMIC_FLAGS, UNIT_DYNFLAG_LOOTABLE);
doSendCinematic();
break;
case 14030:
UpdateTimer = 20000;
pInstance->SetData(TYPE_EVENT,14030);
DoScriptText(-1631594, m_creature);
// if (pMenethil && pMenethil->isAlive()) pMenethil->ForcedDespawn();
if (pMenethil && pMenethil->isAlive()) pMenethil->SetVisibility(VISIBILITY_OFF);
if (Creature* pLichKing = (Creature*)Unit::GetUnit((*m_creature),pInstance->GetData64(NPC_LICH_KING)))
pLichKing->SetFlag(UNIT_DYNAMIC_FLAGS, UNIT_DYNFLAG_LOOTABLE);
pInstance->SetData(TYPE_EVENT,0);
EnterEvadeMode();
break;
default:
break;
}
} else UpdateTimer -= diff;
pInstance->SetData(TYPE_EVENT_TIMER, UpdateTimer);
}

if (!m_creature->SelectHostileTarget() || !m_creature->getVictim())
return;
DoMeleeAttackIfReady();
}


};

bool GossipHello_boss_tirion_icc(Player* pPlayer, Creature* pCreature)
{
ScriptedInstance* pInstance;
pInstance = (ScriptedInstance*)pCreature->GetInstanceData();

if (pInstance->GetData(TYPE_LICH_KING) != NOT_STARTED &&
pInstance->GetData(TYPE_LICH_KING) != FAIL )
{
pPlayer->PlayerTalkClass->SendGossipMenu(721002, pCreature->GetGUID());
return true;
};

pPlayer->ADD_GOSSIP_ITEM_ID(GOSSIP_ICON_CHAT, -1631608, GOSSIP_SENDER_MAIN, GOSSIP_ACTION_INFO_DEF);
pPlayer->PlayerTalkClass->SendGossipMenu(721001, pCreature->GetGUID());
return true;
};

bool GossipSelect_boss_tirion_icc(Player* pPlayer, Creature* pCreature, uint32 uiSender, uint32 uiAction)
{
ScriptedInstance* pInstance;
pInstance = (ScriptedInstance*)pCreature->GetInstanceData();
if (!pInstance) return false;

if (uiAction == GOSSIP_ACTION_INFO_DEF)
{
pPlayer->CLOSE_GOSSIP_MENU();
pInstance->SetData(TYPE_LICH_KING, IN_PROGRESS);
pInstance->SetData(TYPE_EVENT,12000);
return true;
} else return false;
};

CreatureAI* GetAI_boss_tirion_icc(Creature* pCreature)
{
return new boss_tirion_iccAI(pCreature);
};

struct MANGOS_DLL_DECL mob_ice_sphere_iccAI : public BSWScriptedAI
{
mob_ice_sphere_iccAI(Creature *pCreature) : BSWScriptedAI(pCreature)
{
pInstance = (ScriptedInstance*)pCreature->GetInstanceData();
Reset();
}

ScriptedInstance *pInstance;

void Reset()
{
resetTimers();
doCast(SPELL_ICE_SPHERE_VISUAL);
m_creature->AddSplineFlag(SPLINEFLAG_WALKMODE);
}


void UpdateAI(const uint32 uiDiff)
{
if (!pInstance || pInstance->GetData(TYPE_LICH_KING) != IN_PROGRESS)
m_creature->ForcedDespawn();

if (!m_creature->SelectHostileTarget() || !m_creature->getVictim())
{
if (Unit* pTarget = doSelectRandomPlayerAtRange(120.0f))
{
m_creature->SetInCombatWith(pTarget);
m_creature->AddThreat(pTarget,100.0f);
}
return;
}

if (m_creature->getVictim()->GetTypeId() != TYPEID_PLAYER)
return;

timedCast(SPELL_ICE_PULSE, uiDiff);

if (m_creature->IsWithinDistInMap(m_creature->getVictim(), 1.0f))
timedCast(SPELL_ICE_BURST,uiDiff);
}
};

CreatureAI* GetAI_mob_ice_sphere_icc(Creature* pCreature)
{
return new mob_ice_sphere_iccAI(pCreature);
};

struct MANGOS_DLL_DECL mob_defiler_iccAI : public BSWScriptedAI
{
mob_defiler_iccAI(Creature *pCreature) : BSWScriptedAI(pCreature)
{
m_pInstance = ((ScriptedInstance*)pCreature->GetInstanceData());
Reset();
}

ScriptedInstance *m_pInstance;
uint32 life_timer;
float m_Size0;
float m_Size;

void Reset()
{
SetCombatMovement(false);
life_timer = 30000;
m_creature->SetFlag(UNIT_FIELD_FLAGS, UNIT_FLAG_NON_ATTACKABLE);
m_creature->SetFlag(UNIT_FIELD_FLAGS, UNIT_FLAG_NOT_SELECTABLE);
m_creature->CastSpell(m_creature, SPELL_DEFILE, true);
m_Size0 = m_creature->GetFloatValue(OBJECT_FIELD_SCALE_X);
m_Size = m_Size0;
}

void AttackStart(Unit *pWho)
{
return;
}

bool doSearchPlayers()
{
if(doSelectRandomPlayerAtRange(m_Size * 3.0f)) return true;
else return false;
}

void UpdateAI(const uint32 uiDiff)
{
if(m_pInstance && m_pInstance->GetData(TYPE_LICH_KING) != IN_PROGRESS)
m_creature->ForcedDespawn();

if (life_timer <= uiDiff)
m_creature->ForcedDespawn();
else life_timer -= uiDiff;

if (doSearchPlayers() && m_Size <= m_Size0 * 6.0f) {
m_Size = m_Size*1.01;
m_creature->SetFloatValue(OBJECT_FIELD_SCALE_X, m_Size);
}

}

};

CreatureAI* GetAI_mob_defiler_icc(Creature* pCreature)
{
return new mob_defiler_iccAI(pCreature);
}

struct MANGOS_DLL_DECL mob_strangulate_vehicleAI : public ScriptedAI
{
mob_strangulate_vehicleAI(Creature *pCreature) : ScriptedAI(pCreature)
{
m_pInstance = ((ScriptedInstance*)pCreature->GetInstanceData());
Reset();
}

ScriptedInstance *m_pInstance;

void Reset()
{
SetCombatMovement(false);
m_creature->SetFlag(UNIT_FIELD_FLAGS, UNIT_FLAG_NON_ATTACKABLE);
m_creature->SetFlag(UNIT_FIELD_FLAGS, UNIT_FLAG_NOT_SELECTABLE);
}

void AttackStart(Unit *pWho)
{
return;
}

void UpdateAI(const uint32 uiDiff)
{
m_creature->ForcedDespawn();
}

};

CreatureAI* GetAI_mob_strangulate_vehicle(Creature* pCreature)
{
return new mob_strangulate_vehicleAI(pCreature);
}

struct MANGOS_DLL_DECL mob_vile_spiritAI : public BSWScriptedAI
{
mob_vile_spiritAI(Creature *pCreature) : BSWScriptedAI(pCreature)
{
pInstance = (ScriptedInstance*)pCreature->GetInstanceData();
Reset();
}

ScriptedInstance *pInstance;
bool movementstarted;

void Reset()
{
resetTimers();
if (Unit* pTarget = doSelectRandomPlayerAtRange(120.0f))
{
m_creature->SetInCombatWith(pTarget);
m_creature->AddThreat(pTarget,1000.0f);
}
SetCombatMovement(false);
movementstarted = false;
m_creature->AddSplineFlag(SPLINEFLAG_WALKMODE);
}


void UpdateAI(const uint32 uiDiff)
{
if (!pInstance || pInstance->GetData(TYPE_LICH_KING) != IN_PROGRESS)
m_creature->ForcedDespawn();

if (!m_creature->SelectHostileTarget() || !m_creature->getVictim())
return;

if (timedQuery(SPELL_SPIRITS_BURST, uiDiff) && !movementstarted)
{
SetCombatMovement(true);
m_creature->GetMotionMaster()->MoveChase(m_creature->getVictim());
movementstarted = true;
}

if (m_creature->getVictim()->GetTypeId() != TYPEID_PLAYER)
return;

if (m_creature->IsWithinDistInMap(m_creature->getVictim(), 1.0f))
{
doCast(SPELL_SPIRITS_BURST);
m_creature->ForcedDespawn();
};
}
};

CreatureAI* GetAI_mob_vile_spirit(Creature* pCreature)
{
return new mob_vile_spiritAI(pCreature);
}

struct MANGOS_DLL_DECL mob_raging_spiritAI : public BSWScriptedAI
{
mob_raging_spiritAI(Creature *pCreature) : BSWScriptedAI(pCreature)
{
pInstance = (ScriptedInstance*)pCreature->GetInstanceData();
Reset();
}

ScriptedInstance *pInstance;

void Reset()
{
resetTimers();
m_creature->SetDisplayId(10771);
}

void UpdateAI(const uint32 uiDiff)
{
if (!pInstance || pInstance->GetData(TYPE_LICH_KING) != IN_PROGRESS)
m_creature->ForcedDespawn();

if (!m_creature->SelectHostileTarget() || !m_creature->getVictim())
return;

timedCast(SPELL_SOUL_SHRIEK, uiDiff);
}
};

CreatureAI* GetAI_mob_raging_spirit(Creature* pCreature)
{
return new mob_raging_spiritAI(pCreature);
}

void AddSC_boss_the_lich_king_icc()
{
Script *newscript;

newscript = new Script;
newscript->Name = "boss_the_lich_king_icc";
newscript->GetAI = &GetAI_boss_the_lich_king_icc;
newscript->RegisterSelf();

newscript = new Script;
newscript->Name = "boss_tirion_icc";
newscript->GetAI = &GetAI_boss_tirion_icc;
newscript->pGossipHello = &GossipHello_boss_tirion_icc;
newscript->pGossipSelect = &GossipSelect_boss_tirion_icc;
newscript->RegisterSelf();

newscript = new Script;
newscript->Name = "mob_ice_sphere_icc";
newscript->GetAI = &GetAI_mob_ice_sphere_icc;
newscript->RegisterSelf();

newscript = new Script;
newscript->Name = "mob_defiler_icc";
newscript->GetAI = &GetAI_mob_defiler_icc;
newscript->RegisterSelf();

newscript = new Script;
newscript->Name = "mob_strangulate_vehicle";
newscript->GetAI = &GetAI_mob_strangulate_vehicle;
newscript->RegisterSelf();

newscript = new Script;
newscript->Name = "mob_vile_spirit";
newscript->GetAI = &GetAI_mob_vile_spirit;
newscript->RegisterSelf();

newscript = new Script;
newscript->Name = "mob_raging_spirit";
newscript->GetAI = &GetAI_mob_raging_spirit;
newscript->RegisterSelf();

};

Can you make this script in your next update is the lichking fight


// Script Generated: 2010-03-29 23:23:48
// Run this query on your world database
// UPDATE `creature_template` SET ScriptName='npc_Professor Putricide' WHERE `entry`=36678;
#include "precompiled.h"


struct MANGOS_DLL_DECL Professor PutricideAI : public ScriptedAI
{
Professor PutricideAI(Creature* pCreature) : ScriptedAI(pCreature)
{
Reset();
}

uint32 spell1_phase1_Timer;
uint32 spell2_phase1_Timer;
uint32 spell3_phase1_Timer;
uint32 spell4_phase1_Timer;
uint32 spell5_phase1_Timer;
uint32 spell6_phase1_Timer;
uint32 spell1_phase2_Timer;
uint32 spell2_phase2_Timer;
uint32 spell3_phase2_Timer;
uint32 spell4_phase2_Timer;
uint32 spell5_phase2_Timer;
uint32 spell6_phase2_Timer;
uint32 spell1_phase3_Timer;
uint32 spell2_phase3_Timer;
uint32 phase;

void Aggro(Unit* pWho)
{
}

void KilledUnit(Unit* pVictim)
{
}

void JustDied(Unit* pKiller)
{
}

void Reset()
{
spell1_phase1_Timer = 20000+rand()%20000;
spell2_phase1_Timer = 80000+rand()%20000;
spell3_phase1_Timer = 20000+rand()%20000;
spell4_phase1_Timer = 20000+rand()%20000;
spell5_phase1_Timer = 50000+rand()%30000;
spell6_phase1_Timer = 80000+rand()%20000;
spell1_phase2_Timer = 20000+rand()%20000;
spell2_phase2_Timer = 60000+rand()%20000;
spell3_phase2_Timer = 50000+rand()%30000;
spell4_phase2_Timer = 50000+rand()%30000;
spell5_phase2_Timer = 30000+rand()%30000;
spell6_phase2_Timer = 50000+rand()%40000;
spell1_phase3_Timer = 20000+rand()%20000;
spell2_phase3_Timer = 10000+rand()%10000;
phase = 0;
}

void UpdateAI(const uint32 diff)
{
if (!m_creature->SelectHostileTarget() || !m_creature->getVictim())
return;

if (phase == 1)
{

if (spell1_phase1_Timer <= diff)
{
DoCastSpellIfCan(SelectUnit(SELECT_TARGET_RANDOM, 0), 70346);
spell1_phase1_Timer = 20000+rand()%20000;
} else spell1_phase1_Timer -= diff;

if (spell2_phase1_Timer <= diff)
{
DoCastSpellIfCan(SelectUnit(SELECT_TARGET_RANDOM, 0), 71968);
spell2_phase1_Timer = 80000+rand()%20000;
} else spell2_phase1_Timer -= diff;

if (spell3_phase1_Timer <= diff)
{
DoCastSpellIfCan(m_creature->getVictim(), 70672);
spell3_phase1_Timer = 20000+rand()%20000;
} else spell3_phase1_Timer -= diff;

if (spell4_phase1_Timer <= diff)
{
DoCastSpellIfCan(SelectUnit(SELECT_TARGET_RANDOM, 0), 70701);
spell4_phase1_Timer = 20000+rand()%20000;
} else spell4_phase1_Timer -= diff;

if (spell5_phase1_Timer <= diff)
{
DoCastSpellIfCan(m_creature->getVictim(), 70447);
spell5_phase1_Timer = 50000+rand()%30000;
} else spell5_phase1_Timer -= diff;

if (spell6_phase1_Timer <= diff)
{
DoCastSpellIfCan(SelectUnit(SELECT_TARGET_RANDOM, 0), 71617);
spell6_phase1_Timer = 80000+rand()%20000;
} else spell6_phase1_Timer -= diff;
}

if (phase == 2)
{

if (spell1_phase2_Timer <= diff)
{
DoCastSpellIfCan(SelectUnit(SELECT_TARGET_RANDOM, 0), 70346);
spell1_phase2_Timer = 20000+rand()%20000;
} else spell1_phase2_Timer -= diff;

if (spell2_phase2_Timer <= diff)
{
DoCastSpellIfCan(m_creature->getVictim(), 71968);
spell2_phase2_Timer = 60000+rand()%20000;
} else spell2_phase2_Timer -= diff;

if (spell3_phase2_Timer <= diff)
{
DoCastSpellIfCan(SelectUnit(SELECT_TARGET_RANDOM, 0), 70672);
spell3_phase2_Timer = 50000+rand()%30000;
} else spell3_phase2_Timer -= diff;

if (spell4_phase2_Timer <= diff)
{
DoCastSpellIfCan(m_creature->getVictim(), 70447);
spell4_phase2_Timer = 50000+rand()%30000;
} else spell4_phase2_Timer -= diff;

if (spell5_phase2_Timer <= diff)
{
DoCastSpellIfCan(SelectUnit(SELECT_TARGET_RANDOM, 0), 71278);
spell5_phase2_Timer = 30000+rand()%30000;
} else spell5_phase2_Timer -= diff;

if (spell6_phase2_Timer <= diff)
{
DoCastSpellIfCan(SelectUnit(SELECT_TARGET_RANDOM, 0), 72297);
spell6_phase2_Timer = 50000+rand()%40000;
} else spell6_phase2_Timer -= diff;
}

if (phase == 3)
{

if (spell1_phase3_Timer <= diff)
{
DoCastSpellIfCan(m_creature, 71603);
spell1_phase3_Timer = 20000+rand()%20000;
} else spell1_phase3_Timer -= diff;

if (spell2_phase3_Timer <= diff)
{
DoCastSpellIfCan(SelectUnit(SELECT_TARGET_RANDOM, 0), 72672);
spell2_phase3_Timer = 10000+rand()%10000;
} else spell2_phase3_Timer -= diff;
}

DoMeleeAttackIfReady();
}
};

CreatureAI* GetAIProfessor Putricide(Creature* pCreature)
{
return new Professor PutricideAI (pCreature);
}

void AddSC_Professor Putricide()
{
Script *newscript;
newscript = new Script;
newscript->Name = "npc_Professor Putricide";
newscript->GetAI = &GetAIProfessor Putricide;
newscript->RegisterSelf();
}

this is the script from Professor Putricide or is this wrong for mangos

[ellenya]

scripts/northrend/icecrown_citadel/icecrown_citadel at master from rsa's scriptdev2 - GitHub (http://github.com/rsa/scriptdev2/tree/master/scripts/northrend/icecrown_citadel/icecrown_citadel/)

on the page you will find scritps

maybe you can even use them in your next update. I'm trying to just
help

[Narcoleptic]

Friend i found some odd problems in game...first this only happens when you create a new character, the old ones work just fine dont ask me why...maybe the area?? or faction...well the first problem is the reputation (not major problem) you start at lvl 1 with all the factions and some more called test??? see the screenshot...
the second one is with the sellers...and this one is the most strange because like i told you i checked with the old character and that not happens :( only the new character have all this problems maybe because of the updates...some items appear to be broken like the throwing weapons...see the screenshot and the last thing...did you changed the ratios?? Xp and that stuff...? because when i created this new character and play for a while i got to lvl 6 like in a blink and with the old character that didn´t happen...its very strange but something´s wrong but i don´t know what...459

[Narcoleptic]

Ok update the reputation problem must have been some crazy computer freakout so forget about it...the other problem of the sellers still continues :( the one from the photo and that i tested are from Dun Morogh the starting area for Dwarfs and Gnomes...
thanks

[CthulhuFtagn]

Brand new toon, NONE of those problems. I told you and the others, if you are going to report an error, make sure it's not your doing.

http://img808.imageshack.us/img808/3003/wowscrnshot090510120102.jpg

As far as the "Broken" items, they are deprecated... try this in your mangos database:

DELETE FROM npc_vendor WHERE item = "2947";
DELETE FROM npc_vendor WHERE item = "3131";
DELETE FROM npc_vendor WHERE item = "2946";
DELETE FROM npc_vendor WHERE item = "3111";If you want to delete an item from a vendors inventory, click on him and type

.npc delitem [NAME OF ITEM]to add an item

.npc additem [NAME OF ITEM]

I have not changed anything in the mangosd.conf file that would increase the leveling.

[marko94]

Man ... am I the only one without server problems here ... and GPJ of course ... :D

[CthulhuFtagn]

Nope, it seems like there are only two people who are constantly complaining of errors that they themselves caused, and one of them is already banned... Stefan30 (http://mmopro.net/forums/members/stefan30/)

Kreg Bilmn - NPC - World of Warcraft (http://www.wowhead.com/npc=1691)
http://img521.imageshack.us/img521/5404/itemsm.jpg

[marko94]

Yeah, that Stefan30 guy. And this one isn't far off ... I mean why don't people just read the damn instructions ...

[CthulhuFtagn]

Well, whenever this happens, I always think of what my grandmother used to say.
"It takes people like that to make the rest of us look good."

http://www.toonpool.com/user/4265/files/illiterate_moron_551175.jpg

[GrandpaJohn]

@CT:

those are such minute problems and i wouldn't think that it would cause an interference with the performance of the server that i wouldn't bother you with it anyway
so hey CT small favor about my avatar (dont get me wrong i love it ) could you if you find the time check the knomes and look at the green hair color and possibly color my avatar's beard and hair that color if at all possible
that way he would look like my alliance char iggy

[CthulhuFtagn]

I'll do you one better and make you one with a gnome with green hair/beard.

[marko94]

Well your grandmother was right and that picture is just what that sentence needed.

And be sure to make one of those avatar pic's for me when I reach 80 rep points ... I hope you'll be alive untill then ... :D

[CthulhuFtagn]

http://img812.imageshack.us/img812/1126/85099362.png

Well, I'm gonna go get some Beer Brats ready for the BBQ... * drool *

[GrandpaJohn]

@CT:

thats it thats the same pic my char iggy thank you much

[Narcoleptic]

Friend i didn´t edit nothing in fact even if i want to i don´t know how...second you have seen the photos...i´m not lying...the problem with the reputation i told in a post before that its fixed (don´t know what caused that) but this one of the broken items continues and i didn´t do a thing...i understand that you became pissed off with this but its not my fault...i only do the updates as you say and nothing more...beside the pet problem this is the first bug i have seen in game and i really don´t know why because i didn´t touch a thing :( i´m only trying to help :(

[Narcoleptic]

Please tell me if there is a way to show you that i didn´t touch the database or edited anything like you said...beside the updates you made...if there is please tell me, i will send you the pics so you see that i´m not lying...

[marko94]

Edit your post, don't double-post ...

[GrandpaJohn]

@Narcoleptic

check back on the previous page he gave you a fix for the broken items if you wouiuld just read before posting you would see things

[Narcoleptic]

@Narcoleptic

check back on the previous page he gave you a fix for the broken items if you wouiuld just read before posting you would see things

I have seen the fix friend...i´m only saying that i didn´t touch a thing in the database or whatever place i could edit...
Thanks

[CthulhuFtagn]

Small Update Available:

MaNGOS updated to 10448
Use base run speed * 2 as fall speed.
Delete deprecated 'broken' items from vendorsCU_0030.zip (http://www.mediafire.com/?c4lld6zq135ibh2) (14.54 MB)

I'm currently looking at/testing rsa's scripts from his github scriptdev2 library and will see if some can implemented in the next release.

EDIT: Alrighty, gotta convert some of the makefiles so I can compile the scripts for Windows... I'll keep you guys updated... see ya' tomorrow.

[Biohazzard]

heya CT ;}
Did you see the text dokument which i gave you early ? :) can u confirum that info ?
And yes will be wonderful to feel that update ... you're our hope man, just don't giveup thanks alot

Edit: If you want i can help you with testing of some scripts in the git lib ? :)

[aussie]

just what to say this has be the best repack i have test and the most up to date one out there, keep up the good work and look forward to future Releases

[ellenya]

#include "precompiled.h"
#include "def_spire.h"

enum BossSpells
{
SPELL_INFEST = 70541,
SPELL_NECROTIC_PLAGUE = 70337,
SPELL_PLAGUE_SIPHON = 74074,
SPELL_SOUL_REAPER = 69409,
SPELL_SPAWN_DEFILE = 72762,
SPELL_HARVEST_SOUL = 68980,
SPELL_HARVEST_SOUL_TELEPORT = 71372,
//
SPELL_CHANNEL_KING = 71769,
SPELL_BROKEN_FROSTMOURNE = 72398,
SPELL_BOOM_VISUAL = 72726,
SPELL_ICEBLOCK_TRIGGER = 71614,
SPELL_TIRION_LIGHT = 71797,
SPELL_FROSTMOURNE_TRIGGER = 72405,
SPELL_SUMMON_BROKEN_FROSTMOURNE = 72406,
SPELL_SUMMON_BROKEN_FROSTMOURNE_2 = 73017,
SPELL_DISENGAGE = 61508,
SPELL_FURY_OF_FROSTMOURNE = 70063,
SPELL_REVIVE_VISUAL = 37755,
SPELL_REVIVE = 51918,
SPELL_CLONE_PLAYER = 57507,
SPELL_BERSERK = 47008,

SPELL_REMORSELESS_WINTER = 68981,
SPELL_PAIN_AND_SUFFERING = 72133,
SPELL_QUAKE = 72262,

// SPELL_SUMMON_RAGING_SPIRIT = 69201, // triggered
SPELL_SUMMON_RAGING_SPIRIT = 69200,
SPELL_SOUL_SHRIEK = 69242,

SPELL_SUMMON_ICE_SPHERE = 69103,
SPELL_ICE_PULSE = 69099,
SPELL_ICE_BURST = 69108,
SPELL_ICE_SPHERE_VISUAL = 69090,

SPELL_SUMMON_DRUDGE_GHOULS = 70358,

SPELL_SUMMON_SHAMBLING_HORROR = 70372,
SPELL_SHOCKWAVE = 72149,
SPELL_HORROR_ENRAGE = 72143,

SPELL_SUMMON_VILE_SPIRITS = 70498,
SPELL_SPIRITS_BURST = 70503,

SPELL_SUMMON_VALKYR = 69037,
NPC_VALKYR = 36609,
SPELL_WINGS_OF_THE_DAMNED = 74352,

SPELL_DEFILE = 72743,

SPELL_REVALL = 26687,

NPC_ICE_SPHERE = 36633,
NPC_DEFILER = 38757,
NPC_RAGING_SPIRIT = 36701,
NPC_VILE_SPIRIT = 37799,
NPC_STRANGULATE_VEHICLE = 36598,

};

enum Common
{
FINAL_ARTHAS_MOVIE = 16,
};

static Locations SpawnLoc[]=
{
{459.93689f, -2124.638184f, 1040.860107f}, // 0 Lich King Intro
{503.15652f, -2124.516602f, 1040.860107f}, // 1 Lich king move end
{491.27118f, -2124.638184f, 1040.860107f}, // 2 Tirion 1
{481.69797f, -2124.638184f, 1040.860107f}, // 3 Tirion 2
{498.00448f, -2201.573486f, 1046.093872f}, // 4 Valkyrs?
{517.48291f, -2124.905762f, 1040.861328f}, // 5 Tirion?
{529.85302f, -2124.709961f, 1040.859985f}, // 6 Lich king final, o=3.1146
{520.311f, -2124.709961f, 1040.859985f}, // 7 Frostmourne
};

struct MANGOS_DLL_DECL boss_the_lich_king_iccAI : public BSWScriptedAI
{
boss_the_lich_king_iccAI(Creature* pCreature) : BSWScriptedAI(pCreature)
{
pInstance = (instance_icecrown_spire*)pCreature->GetInstanceData();
oldflag = 0;
Reset();
}

instance_icecrown_spire* pInstance;
uint8 stage;
uint32 nextEvent;
uint32 nextPoint;
uint32 UpdateTimer;
uint32 oldflag;
bool movementstarted;
bool battlestarted;
bool finalphase;
Creature* pTirion;
Creature* pFrostmourne;

void Reset()
{
if(!pInstance) return;
resetTimers();
stage = 0;
nextEvent = 0;
nextPoint = 0;
movementstarted = false;
battlestarted = false;
finalphase = false;
m_creature->SetOrientation(0.0f);
pInstance->CloseDoor(pInstance->GetData64(GO_ICESHARD_1));
pInstance->CloseDoor(pInstance->GetData64(GO_ICESHARD_2));
pInstance->CloseDoor(pInstance->GetData64(GO_ICESHARD_3));
pInstance->CloseDoor(pInstance->GetData64(GO_ICESHARD_4));
if (oldflag)
if (GameObject* pGoFloor = pInstance->instance->GetGameObject(pInstance->GetData64(GO_ARTHAS_PLATFORM)))
{
pGoFloor->RemoveFlag(GAMEOBJECT_FLAGS, GO_FLAG_DAMAGED | GO_FLAG_NODESPAWN);
pGoFloor->SetUInt32Value(GAMEOBJECT_BYTES_1,oldflag);
}
pInstance->CloseDoor(pInstance->GetData64(GO_FROSTY_WIND));
}

void MoveInLineOfSight(Unit* pWho)
{
}

void EnterEvadeMode()
{
if (!pInstance) return;
if (finalphase && pInstance->GetData(TYPE_LICH_KING) == IN_PROGRESS) return;

m_creature->RemoveAllAuras();
m_creature->DeleteThreatList();
m_creature->CombatStop(true);
m_creature->LoadCreaturesAddon();
if (m_creature->isAlive())
m_creature->GetMotionMaster()->MoveTargetedHome();

m_creature->SetLootRecipient(NULL);

Reset();
}

void MovementInform(uint32 type, uint32 id)
{
if (type != POINT_MOTION_TYPE || !movementstarted) return;
if (id == nextPoint)
{
movementstarted = false;
pInstance->SetData(TYPE_EVENT,nextEvent);
m_creature->GetMotionMaster()->MovementExpired();
}
}

void KilledUnit(Unit* pVictim)
{

if (!battlestarted) return;

switch (urand(0,1)) {
case 0:
DoScriptText(-1631519,m_creature,pVictim);
break;
case 1:
DoScriptText(-1631517,m_creature,pVictim);
break;
};
}

void JustReachedHome()
{
if (!pInstance) return;
pInstance->SetData(TYPE_LICH_KING, FAIL);
stage = 0;
battlestarted = false;
finalphase = false;
}


void StartMovement(uint32 id, uint32 _nextEvent)
{
nextPoint = id;
nextEvent = _nextEvent;
m_creature->GetMotionMaster()->Clear();
m_creature->GetMotionMaster()->MovePoint(id, SpawnLoc[id].x, SpawnLoc[id].y, SpawnLoc[id].z);
pInstance->SetData(TYPE_EVENT,0);
movementstarted = true;
}

void JustSummoned(Creature* summoned)
{
if(!pInstance || !summoned) return;

if (Unit* pTarget = doSelectRandomPlayerAtRange(60.0f))
{
summoned->SetInCombatWith(pTarget);
summoned->AddThreat(pTarget,100.0f);
}
}

void Aggro(Unit *who)
{
if(!pInstance) return;
pInstance->SetData(TYPE_LICH_KING, IN_PROGRESS);
}

void JustDied(Unit *killer)
{
if(!pInstance) return;
pInstance->SetData(TYPE_LICH_KING, DONE);
DoScriptText(-1631528,m_creature,killer);

pInstance->SetData(TYPE_EVENT,14010);

}

void UpdateAI(const uint32 diff)
{

if(!pInstance) return;

if (pInstance->GetData(TYPE_EVENT_NPC) == NPC_LICH_KING)
{
UpdateTimer = pInstance->GetData(TYPE_EVENT_TIMER);
if (UpdateTimer <= diff)
{
debug_log("EventMGR: creature %u received signal %u ",m_creature->GetEntry(),pInstance->GetData(TYPE_EVENT));
switch (pInstance->GetData(TYPE_EVENT))
{
case 12000:
m_creature->SetUInt32Value(UNIT_NPC_EMOTESTATE, EMOTE_STATE_STAND);
m_creature->SetStandState(UNIT_STAND_STATE_STAND);
StartMovement(0,12020);
break;
case 12020:
m_creature->SetUInt32Value(UNIT_NPC_EMOTESTATE, EMOTE_STATE_TALK);
DoScriptText(-1631501, m_creature);
UpdateTimer = 12000;
pInstance->SetData(TYPE_EVENT,12030);
break;
case 12040:
m_creature->SetUInt32Value(UNIT_NPC_EMOTESTATE, EMOTE_STATE_READY2H);
DoScriptText(-1631503, m_creature);
UpdateTimer = 8000;
pInstance->SetData(TYPE_EVENT,12041);
break;
case 12041:
m_creature->SetUInt32Value(UNIT_NPC_EMOTESTATE, EMOTE_STATE_LAUGH);
UpdateTimer = 3000;
pInstance->SetData(TYPE_EVENT,12042);
break;
case 12042:
m_creature->SetUInt32Value(UNIT_NPC_EMOTESTATE,EMOTE_ONESHOT_P OINT_NOSHEATHE);
UpdateTimer = 2000;
pInstance->SetData(TYPE_EVENT,12043);
break;
case 12043:
m_creature->SetUInt32Value(UNIT_NPC_EMOTESTATE,EMOTE_ONESHOT_N ONE);
UpdateTimer = 10000;
pInstance->SetData(TYPE_EVENT,12050);
break;
case 12060:
m_creature->SetUInt32Value(UNIT_NPC_EMOTESTATE, EMOTE_STATE_TALK);
DoScriptText(-1631505, m_creature);
UpdateTimer = 10000;
pInstance->SetData(TYPE_EVENT,12080);
break;
case 12080:
m_creature->SetUInt32Value(UNIT_NPC_EMOTESTATE,EMOTE_STATE_REA DY2H);
UpdateTimer = 2000;
pInstance->SetData(TYPE_EVENT,12100);
break;
case 12100:
m_creature->SetUInt32Value(UNIT_NPC_EMOTESTATE,EMOTE_ONESHOT_N ONE);
UpdateTimer = 6000;
pInstance->SetData(TYPE_EVENT,12120);
break;
case 12120:
m_creature->SetInCombatWithZone();
battlestarted = true;
pInstance->SetData(TYPE_EVENT,12200);
UpdateTimer = 10000;
break;
case 12200:
DoScriptText(-1631506, m_creature);
UpdateTimer = 5000;
pInstance->SetData(TYPE_EVENT,12220);
break;
case 13000:
m_creature->SetOrientation(3.1146f);
DoScriptText(-1631507, m_creature);
UpdateTimer = 12000;
finalphase = true;
doCast(SPELL_FURY_OF_FROSTMOURNE);
pInstance->SetData(TYPE_EVENT,13020);
if (pTirion = (Creature*)Unit::GetUnit((*m_creature),pInstance->GetData64(NPC_TIRION))) {
m_creature->SetInCombatWith(pTirion);
pTirion->AddThreat(m_creature, 1000.0f);
}
m_creature->SetInCombatWithZone();
break;
case 13020:
DoScriptText(-1631508, m_creature);
UpdateTimer = 12000;
pInstance->SetData(TYPE_EVENT,13060);
break;
case 13060:
DoScriptText(-1631509, m_creature);
UpdateTimer = 15000;
pInstance->SetData(TYPE_EVENT,13100);
break;
case 13100:
DoScriptText(-1631510, m_creature);
UpdateTimer = 15000;
pInstance->SetData(TYPE_EVENT,13110);
doCast(SPELL_CHANNEL_KING);
break;
case 13120:
DoScriptText(-1631511, m_creature);
UpdateTimer = 12000;
pInstance->SetData(TYPE_EVENT,13130);
break;
case 13140:
UpdateTimer = 6000;
doRemove(SPELL_CHANNEL_KING);
pInstance->SetData(TYPE_EVENT,13150);
m_creature->CastSpell(m_creature, SPELL_SUMMON_BROKEN_FROSTMOURNE, false);
break;
case 13160:
UpdateTimer = 6000;
pInstance->SetData(TYPE_EVENT,13170);
m_creature->CastSpell(m_creature, SPELL_SUMMON_BROKEN_FROSTMOURNE_2, false);
break;
case 13180:
UpdateTimer = 12000;
pInstance->SetData(TYPE_EVENT,13190);
if (pFrostmourne = m_creature->SummonCreature(NPC_FROSTMOURNE_HOLDER, SpawnLoc[7].x, SpawnLoc[7].y, SpawnLoc[7].z, 0, TEMPSUMMON_MANUAL_DESPAWN, 5000))
{
pFrostmourne->CastSpell(pFrostmourne, SPELL_BROKEN_FROSTMOURNE, false);
pFrostmourne->CastSpell(pFrostmourne, SPELL_FROSTMOURNE_TRIGGER, false);
pFrostmourne->GetMotionMaster()->MoveChase(m_creature);
m_creature->SetFlag(UNIT_FIELD_FLAGS, UNIT_FLAG_DISARMED);
}
break;
case 13200:
DoScriptText(-1631512, m_creature);
m_creature->RemoveAurasDueToSpell(SPELL_SUMMON_BROKEN_FROSTMOU RNE);
m_creature->RemoveAllAuras();
pFrostmourne->RemoveAurasDueToSpell(SPELL_FROSTMOURNE_TRIGGER);
UpdateTimer = 5000;
pInstance->SetData(TYPE_EVENT,13210);
break;
case 13280:
UpdateTimer = 2000;
pInstance->SetData(TYPE_EVENT,13290);
stage = 13;
if (pFrostmourne) pFrostmourne->ForcedDespawn();
if (Creature* pTemp = (Creature*)Unit::GetUnit((*m_creature),pInstance->GetData64(NPC_FROSTMOURNE_TRIGGER)))
pTemp->ForcedDespawn();
if (Creature* pTemp = (Creature*)Unit::GetUnit((*m_creature),pInstance->GetData64(NPC_FROSTMOURNE_HOLDER)))
pTemp->ForcedDespawn();
SetCombatMovement(true);
battlestarted = true;
break;
default:
break;
}
} else UpdateTimer -= diff;
pInstance->SetData(TYPE_EVENT_TIMER, UpdateTimer);
}

if (battlestarted && !m_creature->SelectHostileTarget() && !finalphase)
{
battlestarted = false;
pInstance->SetData(TYPE_LICH_KING, FAIL);
pInstance->SetData(TYPE_EVENT,0);
EnterEvadeMode();
return;
}

if (!m_creature->SelectHostileTarget() || !m_creature->getVictim())
return;

switch(stage)
{
case 0: // Phase 1
// timedCast(SPELL_SHOCKWAVE, diff);
timedCast(SPELL_INFEST, diff);
timedCast(SPELL_SUMMON_DRUDGE_GHOULS, diff);
timedCast(SPELL_PLAGUE_SIPHON, diff);
timedCast(SPELL_SUMMON_SHAMBLING_HORROR, diff);
timedCast(SPELL_NECROTIC_PLAGUE, diff);

DoMeleeAttackIfReady();
if (timedQuery(SPELL_BERSERK, diff))
{
doCast(SPELL_BERSERK);
DoScriptText(-1631518,m_creature);
};

if (m_creature->GetHealthPercent() < 70.0f)
{
stage = 1;
DoScriptText(-1631515,m_creature);
}
break;
case 1: // Go in transition phase
m_creature->AttackStop();
m_creature->SetFlag(UNIT_FIELD_FLAGS, UNIT_FLAG_NON_ATTACKABLE);
SetCombatMovement(false);
StartMovement(1,0);
stage = 2;
break;
case 2:
if (movementstarted) return;
doCast(SPELL_REMORSELESS_WINTER);
stage = 3;
break;
case 3:
timedCast(SPELL_SUMMON_RAGING_SPIRIT, diff);
timedCast(SPELL_SUMMON_ICE_SPHERE, diff);
timedCast(SPELL_PAIN_AND_SUFFERING, diff);

if (timedQuery(SPELL_BERSERK, diff))
{
doCast(SPELL_BERSERK);
DoScriptText(-1631518,m_creature);
};

if (timedQuery(SPELL_REMORSELESS_WINTER, diff))
{
doCast(SPELL_QUAKE);
stage = 4;
DoScriptText(-1631524, m_creature);
pInstance->OpenDoor(pInstance->GetData64(GO_SNOW_EDGE));
};
break;
case 4: // Platform destruct
if (timedQuery(SPELL_QUAKE, diff))
{
pInstance->OpenDoor(pInstance->GetData64(GO_ICESHARD_1));
pInstance->OpenDoor(pInstance->GetData64(GO_ICESHARD_2));
pInstance->OpenDoor(pInstance->GetData64(GO_ICESHARD_3));
pInstance->OpenDoor(pInstance->GetData64(GO_ICESHARD_4));
if (GameObject* pGoFloor = pInstance->instance->GetGameObject(pInstance->GetData64(GO_ARTHAS_PLATFORM)))
{
pGoFloor->SetFlag(GAMEOBJECT_FLAGS, GO_FLAG_DAMAGED | GO_FLAG_NODESPAWN);
oldflag = pGoFloor->GetUInt32Value(GAMEOBJECT_BYTES_1);
pGoFloor->SetUInt32Value(GAMEOBJECT_BYTES_1,8449);
}
pInstance->CloseDoor(pInstance->GetData64(GO_FROSTY_WIND));
pInstance->CloseDoor(pInstance->GetData64(GO_SNOW_EDGE));
m_creature->GetMotionMaster()->Clear();
m_creature->GetMotionMaster()->MoveChase(m_creature->getVictim());
m_creature->RemoveFlag(UNIT_FIELD_FLAGS, UNIT_FLAG_NON_ATTACKABLE);
SetCombatMovement(true);
stage = 5;
}
break;
case 5: // Phase 2

if (timedQuery(SPELL_SPAWN_DEFILE, diff))
{
doCast(SPELL_SPAWN_DEFILE);
DoScriptText(-1631531,m_creature);
}
if (timedQuery(SPELL_SUMMON_VALKYR, diff))
{
doCast(SPELL_SUMMON_VALKYR);
DoScriptText(-1631527,m_creature);
}

timedCast(SPELL_SOUL_REAPER, diff);
timedCast(SPELL_INFEST, diff);

DoMeleeAttackIfReady();

if (timedQuery(SPELL_BERSERK, diff))
{
doCast(SPELL_BERSERK);
DoScriptText(-1631518,m_creature);
};

if (m_creature->GetHealthPercent() < 40.0f)
{
stage = 6;
DoScriptText(-1631523,m_creature);
}
break;
case 6: // Go in transition phase
m_creature->AttackStop();
m_creature->SetFlag(UNIT_FIELD_FLAGS, UNIT_FLAG_NON_ATTACKABLE);
SetCombatMovement(false);
StartMovement(1,0);
stage = 7;
break;
case 7: // Platform restore
if (movementstarted) return;
if (GameObject* pGoFloor = pInstance->instance->GetGameObject(pInstance->GetData64(GO_ARTHAS_PLATFORM)))
{
pGoFloor->RemoveFlag(GAMEOBJECT_FLAGS, GO_FLAG_DAMAGED | GO_FLAG_NODESPAWN);
pGoFloor->SetUInt32Value(GAMEOBJECT_BYTES_1,oldflag);
}
pInstance->OpenDoor(pInstance->GetData64(GO_FROSTY_WIND));
doCast(SPELL_REMORSELESS_WINTER);
stage = 8;
break;
case 8:
timedCast(SPELL_SUMMON_RAGING_SPIRIT, diff);
timedCast(SPELL_SUMMON_ICE_SPHERE, diff);
timedCast(SPELL_PAIN_AND_SUFFERING, diff);

if (timedQuery(SPELL_BERSERK, diff))
{
doCast(SPELL_BERSERK);
DoScriptText(-1631518,m_creature);
};

if (timedQuery(SPELL_REMORSELESS_WINTER, diff))
{
DoScriptText(-1631524, m_creature);
doCast(SPELL_SUMMON_VILE_SPIRITS);
for (uint8 i = 0; i < getSpellData(SPELL_SUMMON_VILE_SPIRITS); ++i)
doCast(NPC_VILE_SPIRIT);
doCast(SPELL_QUAKE);
stage = 9;
pInstance->OpenDoor(pInstance->GetData64(GO_SNOW_EDGE));
};

break;
case 9: // Platform destruct
if (timedQuery(SPELL_QUAKE, diff))
{
if (GameObject* pGoFloor = pInstance->instance->GetGameObject(pInstance->GetData64(GO_ARTHAS_PLATFORM)))
{
pGoFloor->SetFlag(GAMEOBJECT_FLAGS, GO_FLAG_DAMAGED | GO_FLAG_NODESPAWN);
oldflag = pGoFloor->GetUInt32Value(GAMEOBJECT_BYTES_1);
pGoFloor->SetUInt32Value(GAMEOBJECT_BYTES_1,8449);
}
pInstance->CloseDoor(pInstance->GetData64(GO_SNOW_EDGE));
pInstance->CloseDoor(pInstance->GetData64(GO_FROSTY_WIND));
m_creature->GetMotionMaster()->Clear();
m_creature->GetMotionMaster()->MoveChase(m_creature->getVictim());
m_creature->RemoveFlag(UNIT_FIELD_FLAGS, UNIT_FLAG_NON_ATTACKABLE);
SetCombatMovement(true);
stage = 10;
}
break;
case 10: // Phase 3
if (timedQuery(SPELL_SPAWN_DEFILE, diff))
{
doCast(SPELL_SPAWN_DEFILE);
// DoScriptText(-1631527,m_creature);
}
timedCast(SPELL_SOUL_REAPER, diff);

if (timedQuery(SPELL_HARVEST_SOUL, diff))
{
doCast(SPELL_HARVEST_SOUL);
DoScriptText(-1631520,m_creature);
}

timedCast(SPELL_SOUL_REAPER, diff);
timedCast(SPELL_INFEST, diff);

DoMeleeAttackIfReady();

if (m_creature->GetHealthPercent() < 10.0f)
{
stage = 11;
DoScriptText(-1631513,m_creature);
}
break;
case 11: // Ending Phase start
m_creature->AttackStop();
SetCombatMovement(false);
StartMovement(6,13000);
stage = 12;
battlestarted = false;
break;
case 12:
break;
case 13:
DoMeleeAttackIfReady();
break;
}
}
};


CreatureAI* GetAI_boss_the_lich_king_icc(Creature* pCreature)
{
return new boss_the_lich_king_iccAI(pCreature);
};

struct MANGOS_DLL_DECL boss_tirion_iccAI : public ScriptedAI
{
boss_tirion_iccAI(Creature* pCreature) : ScriptedAI(pCreature)
{
pInstance = (ScriptedInstance*)pCreature->GetInstanceData();
Reset();
}

ScriptedInstance *pInstance;
uint32 UpdateTimer;
uint32 nextEvent;
uint32 nextPoint;
bool movementstarted;
Creature* pMenethil;

void Reset()
{
if(!pInstance) return;
movementstarted = false;
m_creature->RemoveAurasDueToSpell(SPELL_ICEBLOCK_TRIGGER);
m_creature->SetOrientation(M_PI_F);
}

void StartMovement(uint32 id, uint32 _nextEvent)
{
nextPoint = id;
nextEvent = _nextEvent;
m_creature->GetMotionMaster()->MovePoint(id, SpawnLoc[id].x, SpawnLoc[id].y, SpawnLoc[id].z);
pInstance->SetData(TYPE_EVENT,0);
movementstarted = true;
}

void MovementInform(uint32 type, uint32 id)
{
if (type != POINT_MOTION_TYPE || !movementstarted) return;
if (id == nextPoint)
{
movementstarted = false;
pInstance->SetData(TYPE_EVENT,nextEvent);
m_creature->GetMotionMaster()->MovementExpired();
}
}

void doSendCinematic()
{
Map::PlayerList const &pList = m_creature->GetMap()->GetPlayers();
if (pList.isEmpty()) return;
for (Map::PlayerList::const_iterator i = pList.begin(); i != pList.end(); ++i)
if (Player* pPlayer = i->getSource())
if (pPlayer && pPlayer->isAlive() && pPlayer->IsInMap(m_creature))
pPlayer->SendMovieStart(FINAL_ARTHAS_MOVIE);
}

void doRevivePlayers()
{
Map::PlayerList const &pList = pMenethil->GetMap()->GetPlayers();
if (pList.isEmpty()) return;
for (Map::PlayerList::const_iterator i = pList.begin(); i != pList.end(); ++i)
{
if (Player* pPlayer = i->getSource())
{
if (pPlayer && !pPlayer->isAlive() && pPlayer->IsInMap(pMenethil))
{
pMenethil->CastSpell(pPlayer, SPELL_REVALL, true);
pPlayer->ResurrectPlayer(100, false);
}
}
};
}

void UpdateAI(const uint32 diff)
{

if (pInstance->GetData(TYPE_LICH_KING) == FAIL && m_creature->HasAura(SPELL_ICEBLOCK_TRIGGER))
{
m_creature->RemoveAurasDueToSpell(SPELL_ICEBLOCK_TRIGGER);
m_creature->GetMotionMaster()->MoveTargetedHome();
Reset();
}

if (pInstance->GetData(TYPE_EVENT_NPC) == NPC_TIRION)
{
UpdateTimer = pInstance->GetData(TYPE_EVENT_TIMER);
if (UpdateTimer <= diff)
{
debug_log("EventMGR: creature %u received signal %u ",m_creature->GetEntry(),pInstance->GetData(TYPE_EVENT));
switch (pInstance->GetData(TYPE_EVENT))
{
case 12030:
m_creature->SetUInt32Value(UNIT_NPC_EMOTESTATE, EMOTE_ONESHOT_TALK);
DoScriptText(-1631552, m_creature);
UpdateTimer = 9000;
pInstance->SetData(TYPE_EVENT,12040);
break;
case 12050:
m_creature->SetUInt32Value(UNIT_NPC_EMOTESTATE, EMOTE_ONESHOT_POINT_NOSHEATHE);
DoScriptText(-1631554, m_creature);
UpdateTimer = 3000;
pInstance->SetData(TYPE_EVENT,12051);
break;
case 12051:
m_creature->SetUInt32Value(UNIT_NPC_EMOTESTATE, EMOTE_ONESHOT_NONE);
UpdateTimer = 1000;
pInstance->SetData(TYPE_EVENT,12052);
break;
case 12052:
m_creature->RemoveSplineFlag(SPLINEFLAG_WALKMODE);
StartMovement(3,12053);
break;
case 12053:
UpdateTimer = 3000;
pInstance->SetData(TYPE_EVENT,12060);
m_creature->CastSpell(m_creature, SPELL_ICEBLOCK_TRIGGER, true);
break;
case 13110:
DoScriptText(-1631555, m_creature);
UpdateTimer = 6000;
m_creature->CastSpell(m_creature, SPELL_TIRION_LIGHT, false);
pInstance->SetData(TYPE_EVENT,13120);
break;
case 13130:
SetCombatMovement(false);
m_creature->RemoveAurasDueToSpell(SPELL_ICEBLOCK_TRIGGER);
UpdateTimer = 500;
m_creature->SetOrientation(0.0f);
pInstance->SetData(TYPE_EVENT,13131);
break;
case 13131:
m_creature->RemoveSplineFlag(SPLINEFLAG_WALKMODE);
StartMovement(2,13132);
break;
case 13132:
StartMovement(5,13140);
DoScriptText(-1631556, m_creature);
m_creature->SetUInt32Value(UNIT_NPC_EMOTESTATE, EMOTE_STATE_READY2H);
break;
case 13150:
UpdateTimer = 1000;
pInstance->SetData(TYPE_EVENT,13160);
break;
case 13170:
UpdateTimer = 2000;
pInstance->SetData(TYPE_EVENT,13180);
break;
case 13190:
UpdateTimer = 500;
pInstance->SetData(TYPE_EVENT,13200);
break;
case 13210:
UpdateTimer = 3000;
pInstance->SetData(TYPE_EVENT,13230);
break;
case 13230:
UpdateTimer = 12000;
pMenethil = m_creature->SummonCreature(NPC_MENETHIL, m_creature->GetPositionX()+5, m_creature->GetPositionY()+5, m_creature->GetPositionZ(), 0, TEMPSUMMON_MANUAL_DESPAWN, 5000);
pInstance->SetData(TYPE_EVENT,13250);
DoScriptText(-1631560, pMenethil);
break;
case 13250:
UpdateTimer = 6000;
pInstance->SetData(TYPE_EVENT,13270);
DoScriptText(-1631561, pMenethil);
pMenethil->CastSpell(pMenethil, SPELL_REVIVE_VISUAL, false);
doRevivePlayers();
break;
case 13270:
UpdateTimer = 6000;
pInstance->SetData(TYPE_EVENT,13280);
if (Creature* pLichKing = (Creature*)Unit::GetUnit((*m_creature),pInstance->GetData64(NPC_LICH_KING)))
{
m_creature->SetInCombatWith(pLichKing);
pLichKing->SetInCombatWith(m_creature);
pLichKing->AddThreat(m_creature, 1000.0f);
m_creature->AI()->AttackStart(pLichKing);
pMenethil->AI()->AttackStart(pLichKing);
SetCombatMovement(true);
m_creature->GetMotionMaster()->MoveChase(pLichKing);
};
break;
case 13290:
UpdateTimer = 5000;
pInstance->SetData(TYPE_EVENT,13310);
DoScriptText(-1631590, pMenethil);
break;
case 13310:
UpdateTimer = 5000;
pInstance->SetData(TYPE_EVENT,13330);
DoScriptText(-1631591, m_creature);
break;
case 13330:
UpdateTimer = 5000;
pInstance->SetData(TYPE_EVENT,13350);
DoScriptText(-1631592, pMenethil);
break;
case 13350:
UpdateTimer = 2000;
pInstance->SetData(TYPE_EVENT,13370);
DoScriptText(-1631593, m_creature);
break;
case 14010:
m_creature->AttackStop();
SetCombatMovement(false);
UpdateTimer =90000;
pInstance->SetData(TYPE_EVENT,14030);
m_creature->SetUInt32Value(UNIT_NPC_EMOTESTATE, EMOTE_ONESHOT_NONE);
if (Creature* pLichKing = (Creature*)Unit::GetUnit((*m_creature),pInstance->GetData64(NPC_LICH_KING)))
pLichKing->RemoveFlag(UNIT_DYNAMIC_FLAGS, UNIT_DYNFLAG_LOOTABLE);
doSendCinematic();
break;
case 14030:
UpdateTimer = 20000;
pInstance->SetData(TYPE_EVENT,14030);
DoScriptText(-1631594, m_creature);
// if (pMenethil && pMenethil->isAlive()) pMenethil->ForcedDespawn();
if (pMenethil && pMenethil->isAlive()) pMenethil->SetVisibility(VISIBILITY_OFF);
if (Creature* pLichKing = (Creature*)Unit::GetUnit((*m_creature),pInstance->GetData64(NPC_LICH_KING)))
pLichKing->SetFlag(UNIT_DYNAMIC_FLAGS, UNIT_DYNFLAG_LOOTABLE);
pInstance->SetData(TYPE_EVENT,0);
EnterEvadeMode();
break;
default:
break;
}
} else UpdateTimer -= diff;
pInstance->SetData(TYPE_EVENT_TIMER, UpdateTimer);
}

if (!m_creature->SelectHostileTarget() || !m_creature->getVictim())
return;
DoMeleeAttackIfReady();
}


};

bool GossipHello_boss_tirion_icc(Player* pPlayer, Creature* pCreature)
{
ScriptedInstance* pInstance;
pInstance = (ScriptedInstance*)pCreature->GetInstanceData();

if (pInstance->GetData(TYPE_LICH_KING) != NOT_STARTED &&
pInstance->GetData(TYPE_LICH_KING) != FAIL )
{
pPlayer->PlayerTalkClass->SendGossipMenu(721002, pCreature->GetGUID());
return true;
};

pPlayer->ADD_GOSSIP_ITEM_ID(GOSSIP_ICON_CHAT, -1631608, GOSSIP_SENDER_MAIN, GOSSIP_ACTION_INFO_DEF);
pPlayer->PlayerTalkClass->SendGossipMenu(721001, pCreature->GetGUID());
return true;
};

bool GossipSelect_boss_tirion_icc(Player* pPlayer, Creature* pCreature, uint32 uiSender, uint32 uiAction)
{
ScriptedInstance* pInstance;
pInstance = (ScriptedInstance*)pCreature->GetInstanceData();
if (!pInstance) return false;

if (uiAction == GOSSIP_ACTION_INFO_DEF)
{
pPlayer->CLOSE_GOSSIP_MENU();
pInstance->SetData(TYPE_LICH_KING, IN_PROGRESS);
pInstance->SetData(TYPE_EVENT,12000);
return true;
} else return false;
};

CreatureAI* GetAI_boss_tirion_icc(Creature* pCreature)
{
return new boss_tirion_iccAI(pCreature);
};

struct MANGOS_DLL_DECL mob_ice_sphere_iccAI : public BSWScriptedAI
{
mob_ice_sphere_iccAI(Creature *pCreature) : BSWScriptedAI(pCreature)
{
pInstance = (ScriptedInstance*)pCreature->GetInstanceData();
Reset();
}

ScriptedInstance *pInstance;

void Reset()
{
resetTimers();
doCast(SPELL_ICE_SPHERE_VISUAL);
m_creature->AddSplineFlag(SPLINEFLAG_WALKMODE);
}


void UpdateAI(const uint32 uiDiff)
{
if (!pInstance || pInstance->GetData(TYPE_LICH_KING) != IN_PROGRESS)
m_creature->ForcedDespawn();

if (!m_creature->SelectHostileTarget() || !m_creature->getVictim())
{
if (Unit* pTarget = doSelectRandomPlayerAtRange(120.0f))
{
m_creature->SetInCombatWith(pTarget);
m_creature->AddThreat(pTarget,100.0f);
}
return;
}

if (m_creature->getVictim()->GetTypeId() != TYPEID_PLAYER)
return;

timedCast(SPELL_ICE_PULSE, uiDiff);

if (m_creature->IsWithinDistInMap(m_creature->getVictim(), 1.0f))
timedCast(SPELL_ICE_BURST,uiDiff);
}
};

CreatureAI* GetAI_mob_ice_sphere_icc(Creature* pCreature)
{
return new mob_ice_sphere_iccAI(pCreature);
};

struct MANGOS_DLL_DECL mob_defiler_iccAI : public BSWScriptedAI
{
mob_defiler_iccAI(Creature *pCreature) : BSWScriptedAI(pCreature)
{
m_pInstance = ((ScriptedInstance*)pCreature->GetInstanceData());
Reset();
}

ScriptedInstance *m_pInstance;
uint32 life_timer;
float m_Size0;
float m_Size;

void Reset()
{
SetCombatMovement(false);
life_timer = 30000;
m_creature->SetFlag(UNIT_FIELD_FLAGS, UNIT_FLAG_NON_ATTACKABLE);
m_creature->SetFlag(UNIT_FIELD_FLAGS, UNIT_FLAG_NOT_SELECTABLE);
m_creature->CastSpell(m_creature, SPELL_DEFILE, true);
m_Size0 = m_creature->GetFloatValue(OBJECT_FIELD_SCALE_X);
m_Size = m_Size0;
}

void AttackStart(Unit *pWho)
{
return;
}

bool doSearchPlayers()
{
if(doSelectRandomPlayerAtRange(m_Size * 3.0f)) return true;
else return false;
}

void UpdateAI(const uint32 uiDiff)
{
if(m_pInstance && m_pInstance->GetData(TYPE_LICH_KING) != IN_PROGRESS)
m_creature->ForcedDespawn();

if (life_timer <= uiDiff)
m_creature->ForcedDespawn();
else life_timer -= uiDiff;

if (doSearchPlayers() && m_Size <= m_Size0 * 6.0f) {
m_Size = m_Size*1.01;
m_creature->SetFloatValue(OBJECT_FIELD_SCALE_X, m_Size);
}

}

};

CreatureAI* GetAI_mob_defiler_icc(Creature* pCreature)
{
return new mob_defiler_iccAI(pCreature);
}

struct MANGOS_DLL_DECL mob_strangulate_vehicleAI : public ScriptedAI
{
mob_strangulate_vehicleAI(Creature *pCreature) : ScriptedAI(pCreature)
{
m_pInstance = ((ScriptedInstance*)pCreature->GetInstanceData());
Reset();
}

ScriptedInstance *m_pInstance;

void Reset()
{
SetCombatMovement(false);
m_creature->SetFlag(UNIT_FIELD_FLAGS, UNIT_FLAG_NON_ATTACKABLE);
m_creature->SetFlag(UNIT_FIELD_FLAGS, UNIT_FLAG_NOT_SELECTABLE);
}

void AttackStart(Unit *pWho)
{
return;
}

void UpdateAI(const uint32 uiDiff)
{
m_creature->ForcedDespawn();
}

};

CreatureAI* GetAI_mob_strangulate_vehicle(Creature* pCreature)
{
return new mob_strangulate_vehicleAI(pCreature);
}

struct MANGOS_DLL_DECL mob_vile_spiritAI : public BSWScriptedAI
{
mob_vile_spiritAI(Creature *pCreature) : BSWScriptedAI(pCreature)
{
pInstance = (ScriptedInstance*)pCreature->GetInstanceData();
Reset();
}

ScriptedInstance *pInstance;
bool movementstarted;

void Reset()
{
resetTimers();
if (Unit* pTarget = doSelectRandomPlayerAtRange(120.0f))
{
m_creature->SetInCombatWith(pTarget);
m_creature->AddThreat(pTarget,1000.0f);
}
SetCombatMovement(false);
movementstarted = false;
m_creature->AddSplineFlag(SPLINEFLAG_WALKMODE);
}


void UpdateAI(const uint32 uiDiff)
{
if (!pInstance || pInstance->GetData(TYPE_LICH_KING) != IN_PROGRESS)
m_creature->ForcedDespawn();

if (!m_creature->SelectHostileTarget() || !m_creature->getVictim())
return;

if (timedQuery(SPELL_SPIRITS_BURST, uiDiff) && !movementstarted)
{
SetCombatMovement(true);
m_creature->GetMotionMaster()->MoveChase(m_creature->getVictim());
movementstarted = true;
}

if (m_creature->getVictim()->GetTypeId() != TYPEID_PLAYER)
return;

if (m_creature->IsWithinDistInMap(m_creature->getVictim(), 1.0f))
{
doCast(SPELL_SPIRITS_BURST);
m_creature->ForcedDespawn();
};
}
};

CreatureAI* GetAI_mob_vile_spirit(Creature* pCreature)
{
return new mob_vile_spiritAI(pCreature);
}

struct MANGOS_DLL_DECL mob_raging_spiritAI : public BSWScriptedAI
{
mob_raging_spiritAI(Creature *pCreature) : BSWScriptedAI(pCreature)
{
pInstance = (ScriptedInstance*)pCreature->GetInstanceData();
Reset();
}

ScriptedInstance *pInstance;

void Reset()
{
resetTimers();
m_creature->SetDisplayId(10771);
}

void UpdateAI(const uint32 uiDiff)
{
if (!pInstance || pInstance->GetData(TYPE_LICH_KING) != IN_PROGRESS)
m_creature->ForcedDespawn();

if (!m_creature->SelectHostileTarget() || !m_creature->getVictim())
return;

timedCast(SPELL_SOUL_SHRIEK, uiDiff);
}
};

CreatureAI* GetAI_mob_raging_spirit(Creature* pCreature)
{
return new mob_raging_spiritAI(pCreature);
}

void AddSC_boss_the_lich_king_icc()
{
Script *newscript;

newscript = new Script;
newscript->Name = "boss_the_lich_king_icc";
newscript->GetAI = &GetAI_boss_the_lich_king_icc;
newscript->RegisterSelf();

newscript = new Script;
newscript->Name = "boss_tirion_icc";
newscript->GetAI = &GetAI_boss_tirion_icc;
newscript->pGossipHello = &GossipHello_boss_tirion_icc;
newscript->pGossipSelect = &GossipSelect_boss_tirion_icc;
newscript->RegisterSelf();

newscript = new Script;
newscript->Name = "mob_ice_sphere_icc";
newscript->GetAI = &GetAI_mob_ice_sphere_icc;
newscript->RegisterSelf();

newscript = new Script;
newscript->Name = "mob_defiler_icc";
newscript->GetAI = &GetAI_mob_defiler_icc;
newscript->RegisterSelf();

newscript = new Script;
newscript->Name = "mob_strangulate_vehicle";
newscript->GetAI = &GetAI_mob_strangulate_vehicle;
newscript->RegisterSelf();

newscript = new Script;
newscript->Name = "mob_vile_spirit";
newscript->GetAI = &GetAI_mob_vile_spirit;
newscript->RegisterSelf();

newscript = new Script;
newscript->Name = "mob_raging_spirit";
newscript->GetAI = &GetAI_mob_raging_spirit;
newscript->RegisterSelf();

};

Can you make this script in your next update is the lichking fight


// Script Generated: 2010-03-29 23:23:48
// Run this query on your world database
// UPDATE `creature_template` SET ScriptName='npc_Professor Putricide' WHERE `entry`=36678;
#include "precompiled.h"


struct MANGOS_DLL_DECL Professor PutricideAI : public ScriptedAI
{
Professor PutricideAI(Creature* pCreature) : ScriptedAI(pCreature)
{
Reset();
}

uint32 spell1_phase1_Timer;
uint32 spell2_phase1_Timer;
uint32 spell3_phase1_Timer;
uint32 spell4_phase1_Timer;
uint32 spell5_phase1_Timer;
uint32 spell6_phase1_Timer;
uint32 spell1_phase2_Timer;
uint32 spell2_phase2_Timer;
uint32 spell3_phase2_Timer;
uint32 spell4_phase2_Timer;
uint32 spell5_phase2_Timer;
uint32 spell6_phase2_Timer;
uint32 spell1_phase3_Timer;
uint32 spell2_phase3_Timer;
uint32 phase;

void Aggro(Unit* pWho)
{
}

void KilledUnit(Unit* pVictim)
{
}

void JustDied(Unit* pKiller)
{
}

void Reset()
{
spell1_phase1_Timer = 20000+rand()%20000;
spell2_phase1_Timer = 80000+rand()%20000;
spell3_phase1_Timer = 20000+rand()%20000;
spell4_phase1_Timer = 20000+rand()%20000;
spell5_phase1_Timer = 50000+rand()%30000;
spell6_phase1_Timer = 80000+rand()%20000;
spell1_phase2_Timer = 20000+rand()%20000;
spell2_phase2_Timer = 60000+rand()%20000;
spell3_phase2_Timer = 50000+rand()%30000;
spell4_phase2_Timer = 50000+rand()%30000;
spell5_phase2_Timer = 30000+rand()%30000;
spell6_phase2_Timer = 50000+rand()%40000;
spell1_phase3_Timer = 20000+rand()%20000;
spell2_phase3_Timer = 10000+rand()%10000;
phase = 0;
}

void UpdateAI(const uint32 diff)
{
if (!m_creature->SelectHostileTarget() || !m_creature->getVictim())
return;

if (phase == 1)
{

if (spell1_phase1_Timer <= diff)
{
DoCastSpellIfCan(SelectUnit(SELECT_TARGET_RANDOM, 0), 70346);
spell1_phase1_Timer = 20000+rand()%20000;
} else spell1_phase1_Timer -= diff;

if (spell2_phase1_Timer <= diff)
{
DoCastSpellIfCan(SelectUnit(SELECT_TARGET_RANDOM, 0), 71968);
spell2_phase1_Timer = 80000+rand()%20000;
} else spell2_phase1_Timer -= diff;

if (spell3_phase1_Timer <= diff)
{
DoCastSpellIfCan(m_creature->getVictim(), 70672);
spell3_phase1_Timer = 20000+rand()%20000;
} else spell3_phase1_Timer -= diff;

if (spell4_phase1_Timer <= diff)
{
DoCastSpellIfCan(SelectUnit(SELECT_TARGET_RANDOM, 0), 70701);
spell4_phase1_Timer = 20000+rand()%20000;
} else spell4_phase1_Timer -= diff;

if (spell5_phase1_Timer <= diff)
{
DoCastSpellIfCan(m_creature->getVictim(), 70447);
spell5_phase1_Timer = 50000+rand()%30000;
} else spell5_phase1_Timer -= diff;

if (spell6_phase1_Timer <= diff)
{
DoCastSpellIfCan(SelectUnit(SELECT_TARGET_RANDOM, 0), 71617);
spell6_phase1_Timer = 80000+rand()%20000;
} else spell6_phase1_Timer -= diff;
}

if (phase == 2)
{

if (spell1_phase2_Timer <= diff)
{
DoCastSpellIfCan(SelectUnit(SELECT_TARGET_RANDOM, 0), 70346);
spell1_phase2_Timer = 20000+rand()%20000;
} else spell1_phase2_Timer -= diff;

if (spell2_phase2_Timer <= diff)
{
DoCastSpellIfCan(m_creature->getVictim(), 71968);
spell2_phase2_Timer = 60000+rand()%20000;
} else spell2_phase2_Timer -= diff;

if (spell3_phase2_Timer <= diff)
{
DoCastSpellIfCan(SelectUnit(SELECT_TARGET_RANDOM, 0), 70672);
spell3_phase2_Timer = 50000+rand()%30000;
} else spell3_phase2_Timer -= diff;

if (spell4_phase2_Timer <= diff)
{
DoCastSpellIfCan(m_creature->getVictim(), 70447);
spell4_phase2_Timer = 50000+rand()%30000;
} else spell4_phase2_Timer -= diff;

if (spell5_phase2_Timer <= diff)
{
DoCastSpellIfCan(SelectUnit(SELECT_TARGET_RANDOM, 0), 71278);
spell5_phase2_Timer = 30000+rand()%30000;
} else spell5_phase2_Timer -= diff;

if (spell6_phase2_Timer <= diff)
{
DoCastSpellIfCan(SelectUnit(SELECT_TARGET_RANDOM, 0), 72297);
spell6_phase2_Timer = 50000+rand()%40000;
} else spell6_phase2_Timer -= diff;
}

if (phase == 3)
{

if (spell1_phase3_Timer <= diff)
{
DoCastSpellIfCan(m_creature, 71603);
spell1_phase3_Timer = 20000+rand()%20000;
} else spell1_phase3_Timer -= diff;

if (spell2_phase3_Timer <= diff)
{
DoCastSpellIfCan(SelectUnit(SELECT_TARGET_RANDOM, 0), 72672);
spell2_phase3_Timer = 10000+rand()%10000;
} else spell2_phase3_Timer -= diff;
}

DoMeleeAttackIfReady();
}
};

CreatureAI* GetAIProfessor Putricide(Creature* pCreature)
{
return new Professor PutricideAI (pCreature);
}

void AddSC_Professor Putricide()
{
Script *newscript;
newscript = new Script;
newscript->Name = "npc_Professor Putricide";
newscript->GetAI = &GetAIProfessor Putricide;
newscript->RegisterSelf();
}

this is the script from Professor Putricide or is this wrong for mangos


scripts/northrend/icecrown_citadel/icecrown_citadel at master from rsa's scriptdev2 - GitHub (http://github.com/rsa/scriptdev2/tree/master/scripts/northrend/icecrown_citadel/icecrown_citadel/)

on the page you will find scritps

[CthulhuFtagn]

just what to say this has be the best repack i have test and the most up to date one out there, keep up the good work and look forward to future ReleasesThanks aussie, I appreciate your comment.

ellenya, I've already seen that from the previous page (http://mmopro.net/forums/f155/%5Brelease%5D-trms-cthulhu-ftagn-dual-database-mangos-repack-3-3-5-12340-32-64-bit-4286/index36.html#post25741) and I even made a comment about it: post (http://mmopro.net/forums/f155/%5Brelease%5D-trms-cthulhu-ftagn-dual-database-mangos-repack-3-3-5-12340-32-64-bit-4286/index38.html#post25769)

I have reported you to MysteriousSouL due to double-posting and your inability to read.


heya CT ;}
Did you see the text dokument which i gave you early ? :) can u confirum that info ?
And yes will be wonderful to feel that update ... you're our hope man, just don't giveup thanks alot

Edit: If you want i can help you with testing of some scripts in the git lib ? :)Yep, I got the document. I'm trying to confirm most of them.

Well, I do my own testing before releases... but thanks.


Update Compiling:

MaNGOS updated to 10450
Skip wrong guid movement packets.
Typos in enum names and comments.
YTDB updated to 341 (563_FIX_10434)
ScriptDev2 updated to 1816

[Bing]

#include "precompiled.h"
#include "def_spire.h"

enum BossSpells
{
SPELL_INFEST = 70541,
SPELL_NECROTIC_PLAGUE = 70337,
SPELL_PLAGUE_SIPHON = 74074,
SPELL_SOUL_REAPER = 69409,
SPELL_SPAWN_DEFILE = 72762,
SPELL_HARVEST_SOUL = 68980,
SPELL_HARVEST_SOUL_TELEPORT = 71372,
//
SPELL_CHANNEL_KING = 71769,
SPELL_BROKEN_FROSTMOURNE = 72398,
SPELL_BOOM_VISUAL = 72726,
SPELL_ICEBLOCK_TRIGGER = 71614,
SPELL_TIRION_LIGHT = 71797,
SPELL_FROSTMOURNE_TRIGGER = 72405,
SPELL_SUMMON_BROKEN_FROSTMOURNE = 72406,
SPELL_SUMMON_BROKEN_FROSTMOURNE_2 = 73017,
SPELL_DISENGAGE = 61508,
SPELL_FURY_OF_FROSTMOURNE = 70063,
SPELL_REVIVE_VISUAL = 37755,
SPELL_REVIVE = 51918,
SPELL_CLONE_PLAYER = 57507,
SPELL_BERSERK = 47008,

SPELL_REMORSELESS_WINTER = 68981,
SPELL_PAIN_AND_SUFFERING = 72133,
SPELL_QUAKE = 72262,

// SPELL_SUMMON_RAGING_SPIRIT = 69201, // triggered
SPELL_SUMMON_RAGING_SPIRIT = 69200,
SPELL_SOUL_SHRIEK = 69242,

SPELL_SUMMON_ICE_SPHERE = 69103,
SPELL_ICE_PULSE = 69099,
SPELL_ICE_BURST = 69108,
SPELL_ICE_SPHERE_VISUAL = 69090,

SPELL_SUMMON_DRUDGE_GHOULS = 70358,

SPELL_SUMMON_SHAMBLING_HORROR = 70372,
SPELL_SHOCKWAVE = 72149,
SPELL_HORROR_ENRAGE = 72143,

SPELL_SUMMON_VILE_SPIRITS = 70498,
SPELL_SPIRITS_BURST = 70503,

SPELL_SUMMON_VALKYR = 69037,
NPC_VALKYR = 36609,
SPELL_WINGS_OF_THE_DAMNED = 74352,

SPELL_DEFILE = 72743,

SPELL_REVALL = 26687,

NPC_ICE_SPHERE = 36633,
NPC_DEFILER = 38757,
NPC_RAGING_SPIRIT = 36701,
NPC_VILE_SPIRIT = 37799,
NPC_STRANGULATE_VEHICLE = 36598,

};

enum Common
{
FINAL_ARTHAS_MOVIE = 16,
};

static Locations SpawnLoc[]=
{
{459.93689f, -2124.638184f, 1040.860107f}, // 0 Lich King Intro
{503.15652f, -2124.516602f, 1040.860107f}, // 1 Lich king move end
{491.27118f, -2124.638184f, 1040.860107f}, // 2 Tirion 1
{481.69797f, -2124.638184f, 1040.860107f}, // 3 Tirion 2
{498.00448f, -2201.573486f, 1046.093872f}, // 4 Valkyrs?
{517.48291f, -2124.905762f, 1040.861328f}, // 5 Tirion?
{529.85302f, -2124.709961f, 1040.859985f}, // 6 Lich king final, o=3.1146
{520.311f, -2124.709961f, 1040.859985f}, // 7 Frostmourne
};

struct MANGOS_DLL_DECL boss_the_lich_king_iccAI : public BSWScriptedAI
{
boss_the_lich_king_iccAI(Creature* pCreature) : BSWScriptedAI(pCreature)
{
pInstance = (instance_icecrown_spire*)pCreature->GetInstanceData();
oldflag = 0;
Reset();
}

instance_icecrown_spire* pInstance;
uint8 stage;
uint32 nextEvent;
uint32 nextPoint;
uint32 UpdateTimer;
uint32 oldflag;
bool movementstarted;
bool battlestarted;
bool finalphase;
Creature* pTirion;
Creature* pFrostmourne;

void Reset()
{
if(!pInstance) return;
resetTimers();
stage = 0;
nextEvent = 0;
nextPoint = 0;
movementstarted = false;
battlestarted = false;
finalphase = false;
m_creature->SetOrientation(0.0f);
pInstance->CloseDoor(pInstance->GetData64(GO_ICESHARD_1));
pInstance->CloseDoor(pInstance->GetData64(GO_ICESHARD_2));
pInstance->CloseDoor(pInstance->GetData64(GO_ICESHARD_3));
pInstance->CloseDoor(pInstance->GetData64(GO_ICESHARD_4));
if (oldflag)
if (GameObject* pGoFloor = pInstance->instance->GetGameObject(pInstance->GetData64(GO_ARTHAS_PLATFORM)))
{
pGoFloor->RemoveFlag(GAMEOBJECT_FLAGS, GO_FLAG_DAMAGED | GO_FLAG_NODESPAWN);
pGoFloor->SetUInt32Value(GAMEOBJECT_BYTES_1,oldflag);
}
pInstance->CloseDoor(pInstance->GetData64(GO_FROSTY_WIND));
}

void MoveInLineOfSight(Unit* pWho)
{
}

void EnterEvadeMode()
{
if (!pInstance) return;
if (finalphase && pInstance->GetData(TYPE_LICH_KING) == IN_PROGRESS) return;

m_creature->RemoveAllAuras();
m_creature->DeleteThreatList();
m_creature->CombatStop(true);
m_creature->LoadCreaturesAddon();
if (m_creature->isAlive())
m_creature->GetMotionMaster()->MoveTargetedHome();

m_creature->SetLootRecipient(NULL);

Reset();
}

void MovementInform(uint32 type, uint32 id)
{
if (type != POINT_MOTION_TYPE || !movementstarted) return;
if (id == nextPoint)
{
movementstarted = false;
pInstance->SetData(TYPE_EVENT,nextEvent);
m_creature->GetMotionMaster()->MovementExpired();
}
}

void KilledUnit(Unit* pVictim)
{

if (!battlestarted) return;

switch (urand(0,1)) {
case 0:
DoScriptText(-1631519,m_creature,pVictim);
break;
case 1:
DoScriptText(-1631517,m_creature,pVictim);
break;
};
}

void JustReachedHome()
{
if (!pInstance) return;
pInstance->SetData(TYPE_LICH_KING, FAIL);
stage = 0;
battlestarted = false;
finalphase = false;
}


void StartMovement(uint32 id, uint32 _nextEvent)
{
nextPoint = id;
nextEvent = _nextEvent;
m_creature->GetMotionMaster()->Clear();
m_creature->GetMotionMaster()->MovePoint(id, SpawnLoc[id].x, SpawnLoc[id].y, SpawnLoc[id].z);
pInstance->SetData(TYPE_EVENT,0);
movementstarted = true;
}

void JustSummoned(Creature* summoned)
{
if(!pInstance || !summoned) return;

if (Unit* pTarget = doSelectRandomPlayerAtRange(60.0f))
{
summoned->SetInCombatWith(pTarget);
summoned->AddThreat(pTarget,100.0f);
}
}

void Aggro(Unit *who)
{
if(!pInstance) return;
pInstance->SetData(TYPE_LICH_KING, IN_PROGRESS);
}

void JustDied(Unit *killer)
{
if(!pInstance) return;
pInstance->SetData(TYPE_LICH_KING, DONE);
DoScriptText(-1631528,m_creature,killer);

pInstance->SetData(TYPE_EVENT,14010);

}

void UpdateAI(const uint32 diff)
{

if(!pInstance) return;

if (pInstance->GetData(TYPE_EVENT_NPC) == NPC_LICH_KING)
{
UpdateTimer = pInstance->GetData(TYPE_EVENT_TIMER);
if (UpdateTimer <= diff)
{
debug_log("EventMGR: creature %u received signal %u ",m_creature->GetEntry(),pInstance->GetData(TYPE_EVENT));
switch (pInstance->GetData(TYPE_EVENT))
{
case 12000:
m_creature->SetUInt32Value(UNIT_NPC_EMOTESTATE, EMOTE_STATE_STAND);
m_creature->SetStandState(UNIT_STAND_STATE_STAND);
StartMovement(0,12020);
break;
case 12020:
m_creature->SetUInt32Value(UNIT_NPC_EMOTESTATE, EMOTE_STATE_TALK);
DoScriptText(-1631501, m_creature);
UpdateTimer = 12000;
pInstance->SetData(TYPE_EVENT,12030);
break;
case 12040:
m_creature->SetUInt32Value(UNIT_NPC_EMOTESTATE, EMOTE_STATE_READY2H);
DoScriptText(-1631503, m_creature);
UpdateTimer = 8000;
pInstance->SetData(TYPE_EVENT,12041);
break;
case 12041:
m_creature->SetUInt32Value(UNIT_NPC_EMOTESTATE, EMOTE_STATE_LAUGH);
UpdateTimer = 3000;
pInstance->SetData(TYPE_EVENT,12042);
break;
case 12042:
m_creature->SetUInt32Value(UNIT_NPC_EMOTESTATE,EMOTE_ONESHOT_P OINT_NOSHEATHE);
UpdateTimer = 2000;
pInstance->SetData(TYPE_EVENT,12043);
break;
case 12043:
m_creature->SetUInt32Value(UNIT_NPC_EMOTESTATE,EMOTE_ONESHOT_N ONE);
UpdateTimer = 10000;
pInstance->SetData(TYPE_EVENT,12050);
break;
case 12060:
m_creature->SetUInt32Value(UNIT_NPC_EMOTESTATE, EMOTE_STATE_TALK);
DoScriptText(-1631505, m_creature);
UpdateTimer = 10000;
pInstance->SetData(TYPE_EVENT,12080);
break;
case 12080:
m_creature->SetUInt32Value(UNIT_NPC_EMOTESTATE,EMOTE_STATE_REA DY2H);
UpdateTimer = 2000;
pInstance->SetData(TYPE_EVENT,12100);
break;
case 12100:
m_creature->SetUInt32Value(UNIT_NPC_EMOTESTATE,EMOTE_ONESHOT_N ONE);
UpdateTimer = 6000;
pInstance->SetData(TYPE_EVENT,12120);
break;
case 12120:
m_creature->SetInCombatWithZone();
battlestarted = true;
pInstance->SetData(TYPE_EVENT,12200);
UpdateTimer = 10000;
break;
case 12200:
DoScriptText(-1631506, m_creature);
UpdateTimer = 5000;
pInstance->SetData(TYPE_EVENT,12220);
break;
case 13000:
m_creature->SetOrientation(3.1146f);
DoScriptText(-1631507, m_creature);
UpdateTimer = 12000;
finalphase = true;
doCast(SPELL_FURY_OF_FROSTMOURNE);
pInstance->SetData(TYPE_EVENT,13020);
if (pTirion = (Creature*)Unit::GetUnit((*m_creature),pInstance->GetData64(NPC_TIRION))) {
m_creature->SetInCombatWith(pTirion);
pTirion->AddThreat(m_creature, 1000.0f);
}
m_creature->SetInCombatWithZone();
break;
case 13020:
DoScriptText(-1631508, m_creature);
UpdateTimer = 12000;
pInstance->SetData(TYPE_EVENT,13060);
break;
case 13060:
DoScriptText(-1631509, m_creature);
UpdateTimer = 15000;
pInstance->SetData(TYPE_EVENT,13100);
break;
case 13100:
DoScriptText(-1631510, m_creature);
UpdateTimer = 15000;
pInstance->SetData(TYPE_EVENT,13110);
doCast(SPELL_CHANNEL_KING);
break;
case 13120:
DoScriptText(-1631511, m_creature);
UpdateTimer = 12000;
pInstance->SetData(TYPE_EVENT,13130);
break;
case 13140:
UpdateTimer = 6000;
doRemove(SPELL_CHANNEL_KING);
pInstance->SetData(TYPE_EVENT,13150);
m_creature->CastSpell(m_creature, SPELL_SUMMON_BROKEN_FROSTMOURNE, false);
break;
case 13160:
UpdateTimer = 6000;
pInstance->SetData(TYPE_EVENT,13170);
m_creature->CastSpell(m_creature, SPELL_SUMMON_BROKEN_FROSTMOURNE_2, false);
break;
case 13180:
UpdateTimer = 12000;
pInstance->SetData(TYPE_EVENT,13190);
if (pFrostmourne = m_creature->SummonCreature(NPC_FROSTMOURNE_HOLDER, SpawnLoc[7].x, SpawnLoc[7].y, SpawnLoc[7].z, 0, TEMPSUMMON_MANUAL_DESPAWN, 5000))
{
pFrostmourne->CastSpell(pFrostmourne, SPELL_BROKEN_FROSTMOURNE, false);
pFrostmourne->CastSpell(pFrostmourne, SPELL_FROSTMOURNE_TRIGGER, false);
pFrostmourne->GetMotionMaster()->MoveChase(m_creature);
m_creature->SetFlag(UNIT_FIELD_FLAGS, UNIT_FLAG_DISARMED);
}
break;
case 13200:
DoScriptText(-1631512, m_creature);
m_creature->RemoveAurasDueToSpell(SPELL_SUMMON_BROKEN_FROSTMOU RNE);
m_creature->RemoveAllAuras();
pFrostmourne->RemoveAurasDueToSpell(SPELL_FROSTMOURNE_TRIGGER);
UpdateTimer = 5000;
pInstance->SetData(TYPE_EVENT,13210);
break;
case 13280:
UpdateTimer = 2000;
pInstance->SetData(TYPE_EVENT,13290);
stage = 13;
if (pFrostmourne) pFrostmourne->ForcedDespawn();
if (Creature* pTemp = (Creature*)Unit::GetUnit((*m_creature),pInstance->GetData64(NPC_FROSTMOURNE_TRIGGER)))
pTemp->ForcedDespawn();
if (Creature* pTemp = (Creature*)Unit::GetUnit((*m_creature),pInstance->GetData64(NPC_FROSTMOURNE_HOLDER)))
pTemp->ForcedDespawn();
SetCombatMovement(true);
battlestarted = true;
break;
default:
break;
}
} else UpdateTimer -= diff;
pInstance->SetData(TYPE_EVENT_TIMER, UpdateTimer);
}

if (battlestarted && !m_creature->SelectHostileTarget() && !finalphase)
{
battlestarted = false;
pInstance->SetData(TYPE_LICH_KING, FAIL);
pInstance->SetData(TYPE_EVENT,0);
EnterEvadeMode();
return;
}

if (!m_creature->SelectHostileTarget() || !m_creature->getVictim())
return;

switch(stage)
{
case 0: // Phase 1
// timedCast(SPELL_SHOCKWAVE, diff);
timedCast(SPELL_INFEST, diff);
timedCast(SPELL_SUMMON_DRUDGE_GHOULS, diff);
timedCast(SPELL_PLAGUE_SIPHON, diff);
timedCast(SPELL_SUMMON_SHAMBLING_HORROR, diff);
timedCast(SPELL_NECROTIC_PLAGUE, diff);

DoMeleeAttackIfReady();
if (timedQuery(SPELL_BERSERK, diff))
{
doCast(SPELL_BERSERK);
DoScriptText(-1631518,m_creature);
};

if (m_creature->GetHealthPercent() < 70.0f)
{
stage = 1;
DoScriptText(-1631515,m_creature);
}
break;
case 1: // Go in transition phase
m_creature->AttackStop();
m_creature->SetFlag(UNIT_FIELD_FLAGS, UNIT_FLAG_NON_ATTACKABLE);
SetCombatMovement(false);
StartMovement(1,0);
stage = 2;
break;
case 2:
if (movementstarted) return;
doCast(SPELL_REMORSELESS_WINTER);
stage = 3;
break;
case 3:
timedCast(SPELL_SUMMON_RAGING_SPIRIT, diff);
timedCast(SPELL_SUMMON_ICE_SPHERE, diff);
timedCast(SPELL_PAIN_AND_SUFFERING, diff);

if (timedQuery(SPELL_BERSERK, diff))
{
doCast(SPELL_BERSERK);
DoScriptText(-1631518,m_creature);
};

if (timedQuery(SPELL_REMORSELESS_WINTER, diff))
{
doCast(SPELL_QUAKE);
stage = 4;
DoScriptText(-1631524, m_creature);
pInstance->OpenDoor(pInstance->GetData64(GO_SNOW_EDGE));
};
break;
case 4: // Platform destruct
if (timedQuery(SPELL_QUAKE, diff))
{
pInstance->OpenDoor(pInstance->GetData64(GO_ICESHARD_1));
pInstance->OpenDoor(pInstance->GetData64(GO_ICESHARD_2));
pInstance->OpenDoor(pInstance->GetData64(GO_ICESHARD_3));
pInstance->OpenDoor(pInstance->GetData64(GO_ICESHARD_4));
if (GameObject* pGoFloor = pInstance->instance->GetGameObject(pInstance->GetData64(GO_ARTHAS_PLATFORM)))
{
pGoFloor->SetFlag(GAMEOBJECT_FLAGS, GO_FLAG_DAMAGED | GO_FLAG_NODESPAWN);
oldflag = pGoFloor->GetUInt32Value(GAMEOBJECT_BYTES_1);
pGoFloor->SetUInt32Value(GAMEOBJECT_BYTES_1,8449);
}
pInstance->CloseDoor(pInstance->GetData64(GO_FROSTY_WIND));
pInstance->CloseDoor(pInstance->GetData64(GO_SNOW_EDGE));
m_creature->GetMotionMaster()->Clear();
m_creature->GetMotionMaster()->MoveChase(m_creature->getVictim());
m_creature->RemoveFlag(UNIT_FIELD_FLAGS, UNIT_FLAG_NON_ATTACKABLE);
SetCombatMovement(true);
stage = 5;
}
break;
case 5: // Phase 2

if (timedQuery(SPELL_SPAWN_DEFILE, diff))
{
doCast(SPELL_SPAWN_DEFILE);
DoScriptText(-1631531,m_creature);
}
if (timedQuery(SPELL_SUMMON_VALKYR, diff))
{
doCast(SPELL_SUMMON_VALKYR);
DoScriptText(-1631527,m_creature);
}

timedCast(SPELL_SOUL_REAPER, diff);
timedCast(SPELL_INFEST, diff);

DoMeleeAttackIfReady();

if (timedQuery(SPELL_BERSERK, diff))
{
doCast(SPELL_BERSERK);
DoScriptText(-1631518,m_creature);
};

if (m_creature->GetHealthPercent() < 40.0f)
{
stage = 6;
DoScriptText(-1631523,m_creature);
}
break;
case 6: // Go in transition phase
m_creature->AttackStop();
m_creature->SetFlag(UNIT_FIELD_FLAGS, UNIT_FLAG_NON_ATTACKABLE);
SetCombatMovement(false);
StartMovement(1,0);
stage = 7;
break;
case 7: // Platform restore
if (movementstarted) return;
if (GameObject* pGoFloor = pInstance->instance->GetGameObject(pInstance->GetData64(GO_ARTHAS_PLATFORM)))
{
pGoFloor->RemoveFlag(GAMEOBJECT_FLAGS, GO_FLAG_DAMAGED | GO_FLAG_NODESPAWN);
pGoFloor->SetUInt32Value(GAMEOBJECT_BYTES_1,oldflag);
}
pInstance->OpenDoor(pInstance->GetData64(GO_FROSTY_WIND));
doCast(SPELL_REMORSELESS_WINTER);
stage = 8;
break;
case 8:
timedCast(SPELL_SUMMON_RAGING_SPIRIT, diff);
timedCast(SPELL_SUMMON_ICE_SPHERE, diff);
timedCast(SPELL_PAIN_AND_SUFFERING, diff);

if (timedQuery(SPELL_BERSERK, diff))
{
doCast(SPELL_BERSERK);
DoScriptText(-1631518,m_creature);
};

if (timedQuery(SPELL_REMORSELESS_WINTER, diff))
{
DoScriptText(-1631524, m_creature);
doCast(SPELL_SUMMON_VILE_SPIRITS);
for (uint8 i = 0; i < getSpellData(SPELL_SUMMON_VILE_SPIRITS); ++i)
doCast(NPC_VILE_SPIRIT);
doCast(SPELL_QUAKE);
stage = 9;
pInstance->OpenDoor(pInstance->GetData64(GO_SNOW_EDGE));
};

break;
case 9: // Platform destruct
if (timedQuery(SPELL_QUAKE, diff))
{
if (GameObject* pGoFloor = pInstance->instance->GetGameObject(pInstance->GetData64(GO_ARTHAS_PLATFORM)))
{
pGoFloor->SetFlag(GAMEOBJECT_FLAGS, GO_FLAG_DAMAGED | GO_FLAG_NODESPAWN);
oldflag = pGoFloor->GetUInt32Value(GAMEOBJECT_BYTES_1);
pGoFloor->SetUInt32Value(GAMEOBJECT_BYTES_1,8449);
}
pInstance->CloseDoor(pInstance->GetData64(GO_SNOW_EDGE));
pInstance->CloseDoor(pInstance->GetData64(GO_FROSTY_WIND));
m_creature->GetMotionMaster()->Clear();
m_creature->GetMotionMaster()->MoveChase(m_creature->getVictim());
m_creature->RemoveFlag(UNIT_FIELD_FLAGS, UNIT_FLAG_NON_ATTACKABLE);
SetCombatMovement(true);
stage = 10;
}
break;
case 10: // Phase 3
if (timedQuery(SPELL_SPAWN_DEFILE, diff))
{
doCast(SPELL_SPAWN_DEFILE);
// DoScriptText(-1631527,m_creature);
}
timedCast(SPELL_SOUL_REAPER, diff);

if (timedQuery(SPELL_HARVEST_SOUL, diff))
{
doCast(SPELL_HARVEST_SOUL);
DoScriptText(-1631520,m_creature);
}

timedCast(SPELL_SOUL_REAPER, diff);
timedCast(SPELL_INFEST, diff);

DoMeleeAttackIfReady();

if (m_creature->GetHealthPercent() < 10.0f)
{
stage = 11;
DoScriptText(-1631513,m_creature);
}
break;
case 11: // Ending Phase start
m_creature->AttackStop();
SetCombatMovement(false);
StartMovement(6,13000);
stage = 12;
battlestarted = false;
break;
case 12:
break;
case 13:
DoMeleeAttackIfReady();
break;
}
}
};


CreatureAI* GetAI_boss_the_lich_king_icc(Creature* pCreature)
{
return new boss_the_lich_king_iccAI(pCreature);
};

struct MANGOS_DLL_DECL boss_tirion_iccAI : public ScriptedAI
{
boss_tirion_iccAI(Creature* pCreature) : ScriptedAI(pCreature)
{
pInstance = (ScriptedInstance*)pCreature->GetInstanceData();
Reset();
}

ScriptedInstance *pInstance;
uint32 UpdateTimer;
uint32 nextEvent;
uint32 nextPoint;
bool movementstarted;
Creature* pMenethil;

void Reset()
{
if(!pInstance) return;
movementstarted = false;
m_creature->RemoveAurasDueToSpell(SPELL_ICEBLOCK_TRIGGER);
m_creature->SetOrientation(M_PI_F);
}

void StartMovement(uint32 id, uint32 _nextEvent)
{
nextPoint = id;
nextEvent = _nextEvent;
m_creature->GetMotionMaster()->MovePoint(id, SpawnLoc[id].x, SpawnLoc[id].y, SpawnLoc[id].z);
pInstance->SetData(TYPE_EVENT,0);
movementstarted = true;
}

void MovementInform(uint32 type, uint32 id)
{
if (type != POINT_MOTION_TYPE || !movementstarted) return;
if (id == nextPoint)
{
movementstarted = false;
pInstance->SetData(TYPE_EVENT,nextEvent);
m_creature->GetMotionMaster()->MovementExpired();
}
}

void doSendCinematic()
{
Map::PlayerList const &pList = m_creature->GetMap()->GetPlayers();
if (pList.isEmpty()) return;
for (Map::PlayerList::const_iterator i = pList.begin(); i != pList.end(); ++i)
if (Player* pPlayer = i->getSource())
if (pPlayer && pPlayer->isAlive() && pPlayer->IsInMap(m_creature))
pPlayer->SendMovieStart(FINAL_ARTHAS_MOVIE);
}

void doRevivePlayers()
{
Map::PlayerList const &pList = pMenethil->GetMap()->GetPlayers();
if (pList.isEmpty()) return;
for (Map::PlayerList::const_iterator i = pList.begin(); i != pList.end(); ++i)
{
if (Player* pPlayer = i->getSource())
{
if (pPlayer && !pPlayer->isAlive() && pPlayer->IsInMap(pMenethil))
{
pMenethil->CastSpell(pPlayer, SPELL_REVALL, true);
pPlayer->ResurrectPlayer(100, false);
}
}
};
}

void UpdateAI(const uint32 diff)
{

if (pInstance->GetData(TYPE_LICH_KING) == FAIL && m_creature->HasAura(SPELL_ICEBLOCK_TRIGGER))
{
m_creature->RemoveAurasDueToSpell(SPELL_ICEBLOCK_TRIGGER);
m_creature->GetMotionMaster()->MoveTargetedHome();
Reset();
}

if (pInstance->GetData(TYPE_EVENT_NPC) == NPC_TIRION)
{
UpdateTimer = pInstance->GetData(TYPE_EVENT_TIMER);
if (UpdateTimer <= diff)
{
debug_log("EventMGR: creature %u received signal %u ",m_creature->GetEntry(),pInstance->GetData(TYPE_EVENT));
switch (pInstance->GetData(TYPE_EVENT))
{
case 12030:
m_creature->SetUInt32Value(UNIT_NPC_EMOTESTATE, EMOTE_ONESHOT_TALK);
DoScriptText(-1631552, m_creature);
UpdateTimer = 9000;
pInstance->SetData(TYPE_EVENT,12040);
break;
case 12050:
m_creature->SetUInt32Value(UNIT_NPC_EMOTESTATE, EMOTE_ONESHOT_POINT_NOSHEATHE);
DoScriptText(-1631554, m_creature);
UpdateTimer = 3000;
pInstance->SetData(TYPE_EVENT,12051);
break;
case 12051:
m_creature->SetUInt32Value(UNIT_NPC_EMOTESTATE, EMOTE_ONESHOT_NONE);
UpdateTimer = 1000;
pInstance->SetData(TYPE_EVENT,12052);
break;
case 12052:
m_creature->RemoveSplineFlag(SPLINEFLAG_WALKMODE);
StartMovement(3,12053);
break;
case 12053:
UpdateTimer = 3000;
pInstance->SetData(TYPE_EVENT,12060);
m_creature->CastSpell(m_creature, SPELL_ICEBLOCK_TRIGGER, true);
break;
case 13110:
DoScriptText(-1631555, m_creature);
UpdateTimer = 6000;
m_creature->CastSpell(m_creature, SPELL_TIRION_LIGHT, false);
pInstance->SetData(TYPE_EVENT,13120);
break;
case 13130:
SetCombatMovement(false);
m_creature->RemoveAurasDueToSpell(SPELL_ICEBLOCK_TRIGGER);
UpdateTimer = 500;
m_creature->SetOrientation(0.0f);
pInstance->SetData(TYPE_EVENT,13131);
break;
case 13131:
m_creature->RemoveSplineFlag(SPLINEFLAG_WALKMODE);
StartMovement(2,13132);
break;
case 13132:
StartMovement(5,13140);
DoScriptText(-1631556, m_creature);
m_creature->SetUInt32Value(UNIT_NPC_EMOTESTATE, EMOTE_STATE_READY2H);
break;
case 13150:
UpdateTimer = 1000;
pInstance->SetData(TYPE_EVENT,13160);
break;
case 13170:
UpdateTimer = 2000;
pInstance->SetData(TYPE_EVENT,13180);
break;
case 13190:
UpdateTimer = 500;
pInstance->SetData(TYPE_EVENT,13200);
break;
case 13210:
UpdateTimer = 3000;
pInstance->SetData(TYPE_EVENT,13230);
break;
case 13230:
UpdateTimer = 12000;
pMenethil = m_creature->SummonCreature(NPC_MENETHIL, m_creature->GetPositionX()+5, m_creature->GetPositionY()+5, m_creature->GetPositionZ(), 0, TEMPSUMMON_MANUAL_DESPAWN, 5000);
pInstance->SetData(TYPE_EVENT,13250);
DoScriptText(-1631560, pMenethil);
break;
case 13250:
UpdateTimer = 6000;
pInstance->SetData(TYPE_EVENT,13270);
DoScriptText(-1631561, pMenethil);
pMenethil->CastSpell(pMenethil, SPELL_REVIVE_VISUAL, false);
doRevivePlayers();
break;
case 13270:
UpdateTimer = 6000;
pInstance->SetData(TYPE_EVENT,13280);
if (Creature* pLichKing = (Creature*)Unit::GetUnit((*m_creature),pInstance->GetData64(NPC_LICH_KING)))
{
m_creature->SetInCombatWith(pLichKing);
pLichKing->SetInCombatWith(m_creature);
pLichKing->AddThreat(m_creature, 1000.0f);
m_creature->AI()->AttackStart(pLichKing);
pMenethil->AI()->AttackStart(pLichKing);
SetCombatMovement(true);
m_creature->GetMotionMaster()->MoveChase(pLichKing);
};
break;
case 13290:
UpdateTimer = 5000;
pInstance->SetData(TYPE_EVENT,13310);
DoScriptText(-1631590, pMenethil);
break;
case 13310:
UpdateTimer = 5000;
pInstance->SetData(TYPE_EVENT,13330);
DoScriptText(-1631591, m_creature);
break;
case 13330:
UpdateTimer = 5000;
pInstance->SetData(TYPE_EVENT,13350);
DoScriptText(-1631592, pMenethil);
break;
case 13350:
UpdateTimer = 2000;
pInstance->SetData(TYPE_EVENT,13370);
DoScriptText(-1631593, m_creature);
break;
case 14010:
m_creature->AttackStop();
SetCombatMovement(false);
UpdateTimer =90000;
pInstance->SetData(TYPE_EVENT,14030);
m_creature->SetUInt32Value(UNIT_NPC_EMOTESTATE, EMOTE_ONESHOT_NONE);
if (Creature* pLichKing = (Creature*)Unit::GetUnit((*m_creature),pInstance->GetData64(NPC_LICH_KING)))
pLichKing->RemoveFlag(UNIT_DYNAMIC_FLAGS, UNIT_DYNFLAG_LOOTABLE);
doSendCinematic();
break;
case 14030:
UpdateTimer = 20000;
pInstance->SetData(TYPE_EVENT,14030);
DoScriptText(-1631594, m_creature);
// if (pMenethil && pMenethil->isAlive()) pMenethil->ForcedDespawn();
if (pMenethil && pMenethil->isAlive()) pMenethil->SetVisibility(VISIBILITY_OFF);
if (Creature* pLichKing = (Creature*)Unit::GetUnit((*m_creature),pInstance->GetData64(NPC_LICH_KING)))
pLichKing->SetFlag(UNIT_DYNAMIC_FLAGS, UNIT_DYNFLAG_LOOTABLE);
pInstance->SetData(TYPE_EVENT,0);
EnterEvadeMode();
break;
default:
break;
}
} else UpdateTimer -= diff;
pInstance->SetData(TYPE_EVENT_TIMER, UpdateTimer);
}

if (!m_creature->SelectHostileTarget() || !m_creature->getVictim())
return;
DoMeleeAttackIfReady();
}


};

bool GossipHello_boss_tirion_icc(Player* pPlayer, Creature* pCreature)
{
ScriptedInstance* pInstance;
pInstance = (ScriptedInstance*)pCreature->GetInstanceData();

if (pInstance->GetData(TYPE_LICH_KING) != NOT_STARTED &&
pInstance->GetData(TYPE_LICH_KING) != FAIL )
{
pPlayer->PlayerTalkClass->SendGossipMenu(721002, pCreature->GetGUID());
return true;
};

pPlayer->ADD_GOSSIP_ITEM_ID(GOSSIP_ICON_CHAT, -1631608, GOSSIP_SENDER_MAIN, GOSSIP_ACTION_INFO_DEF);
pPlayer->PlayerTalkClass->SendGossipMenu(721001, pCreature->GetGUID());
return true;
};

bool GossipSelect_boss_tirion_icc(Player* pPlayer, Creature* pCreature, uint32 uiSender, uint32 uiAction)
{
ScriptedInstance* pInstance;
pInstance = (ScriptedInstance*)pCreature->GetInstanceData();
if (!pInstance) return false;

if (uiAction == GOSSIP_ACTION_INFO_DEF)
{
pPlayer->CLOSE_GOSSIP_MENU();
pInstance->SetData(TYPE_LICH_KING, IN_PROGRESS);
pInstance->SetData(TYPE_EVENT,12000);
return true;
} else return false;
};

CreatureAI* GetAI_boss_tirion_icc(Creature* pCreature)
{
return new boss_tirion_iccAI(pCreature);
};

struct MANGOS_DLL_DECL mob_ice_sphere_iccAI : public BSWScriptedAI
{
mob_ice_sphere_iccAI(Creature *pCreature) : BSWScriptedAI(pCreature)
{
pInstance = (ScriptedInstance*)pCreature->GetInstanceData();
Reset();
}

ScriptedInstance *pInstance;

void Reset()
{
resetTimers();
doCast(SPELL_ICE_SPHERE_VISUAL);
m_creature->AddSplineFlag(SPLINEFLAG_WALKMODE);
}


void UpdateAI(const uint32 uiDiff)
{
if (!pInstance || pInstance->GetData(TYPE_LICH_KING) != IN_PROGRESS)
m_creature->ForcedDespawn();

if (!m_creature->SelectHostileTarget() || !m_creature->getVictim())
{
if (Unit* pTarget = doSelectRandomPlayerAtRange(120.0f))
{
m_creature->SetInCombatWith(pTarget);
m_creature->AddThreat(pTarget,100.0f);
}
return;
}

if (m_creature->getVictim()->GetTypeId() != TYPEID_PLAYER)
return;

timedCast(SPELL_ICE_PULSE, uiDiff);

if (m_creature->IsWithinDistInMap(m_creature->getVictim(), 1.0f))
timedCast(SPELL_ICE_BURST,uiDiff);
}
};

CreatureAI* GetAI_mob_ice_sphere_icc(Creature* pCreature)
{
return new mob_ice_sphere_iccAI(pCreature);
};

struct MANGOS_DLL_DECL mob_defiler_iccAI : public BSWScriptedAI
{
mob_defiler_iccAI(Creature *pCreature) : BSWScriptedAI(pCreature)
{
m_pInstance = ((ScriptedInstance*)pCreature->GetInstanceData());
Reset();
}

ScriptedInstance *m_pInstance;
uint32 life_timer;
float m_Size0;
float m_Size;

void Reset()
{
SetCombatMovement(false);
life_timer = 30000;
m_creature->SetFlag(UNIT_FIELD_FLAGS, UNIT_FLAG_NON_ATTACKABLE);
m_creature->SetFlag(UNIT_FIELD_FLAGS, UNIT_FLAG_NOT_SELECTABLE);
m_creature->CastSpell(m_creature, SPELL_DEFILE, true);
m_Size0 = m_creature->GetFloatValue(OBJECT_FIELD_SCALE_X);
m_Size = m_Size0;
}

void AttackStart(Unit *pWho)
{
return;
}

bool doSearchPlayers()
{
if(doSelectRandomPlayerAtRange(m_Size * 3.0f)) return true;
else return false;
}

void UpdateAI(const uint32 uiDiff)
{
if(m_pInstance && m_pInstance->GetData(TYPE_LICH_KING) != IN_PROGRESS)
m_creature->ForcedDespawn();

if (life_timer <= uiDiff)
m_creature->ForcedDespawn();
else life_timer -= uiDiff;

if (doSearchPlayers() && m_Size <= m_Size0 * 6.0f) {
m_Size = m_Size*1.01;
m_creature->SetFloatValue(OBJECT_FIELD_SCALE_X, m_Size);
}

}

};

CreatureAI* GetAI_mob_defiler_icc(Creature* pCreature)
{
return new mob_defiler_iccAI(pCreature);
}

struct MANGOS_DLL_DECL mob_strangulate_vehicleAI : public ScriptedAI
{
mob_strangulate_vehicleAI(Creature *pCreature) : ScriptedAI(pCreature)
{
m_pInstance = ((ScriptedInstance*)pCreature->GetInstanceData());
Reset();
}

ScriptedInstance *m_pInstance;

void Reset()
{
SetCombatMovement(false);
m_creature->SetFlag(UNIT_FIELD_FLAGS, UNIT_FLAG_NON_ATTACKABLE);
m_creature->SetFlag(UNIT_FIELD_FLAGS, UNIT_FLAG_NOT_SELECTABLE);
}

void AttackStart(Unit *pWho)
{
return;
}

void UpdateAI(const uint32 uiDiff)
{
m_creature->ForcedDespawn();
}

};

CreatureAI* GetAI_mob_strangulate_vehicle(Creature* pCreature)
{
return new mob_strangulate_vehicleAI(pCreature);
}

struct MANGOS_DLL_DECL mob_vile_spiritAI : public BSWScriptedAI
{
mob_vile_spiritAI(Creature *pCreature) : BSWScriptedAI(pCreature)
{
pInstance = (ScriptedInstance*)pCreature->GetInstanceData();
Reset();
}

ScriptedInstance *pInstance;
bool movementstarted;

void Reset()
{
resetTimers();
if (Unit* pTarget = doSelectRandomPlayerAtRange(120.0f))
{
m_creature->SetInCombatWith(pTarget);
m_creature->AddThreat(pTarget,1000.0f);
}
SetCombatMovement(false);
movementstarted = false;
m_creature->AddSplineFlag(SPLINEFLAG_WALKMODE);
}


void UpdateAI(const uint32 uiDiff)
{
if (!pInstance || pInstance->GetData(TYPE_LICH_KING) != IN_PROGRESS)
m_creature->ForcedDespawn();

if (!m_creature->SelectHostileTarget() || !m_creature->getVictim())
return;

if (timedQuery(SPELL_SPIRITS_BURST, uiDiff) && !movementstarted)
{
SetCombatMovement(true);
m_creature->GetMotionMaster()->MoveChase(m_creature->getVictim());
movementstarted = true;
}

if (m_creature->getVictim()->GetTypeId() != TYPEID_PLAYER)
return;

if (m_creature->IsWithinDistInMap(m_creature->getVictim(), 1.0f))
{
doCast(SPELL_SPIRITS_BURST);
m_creature->ForcedDespawn();
};
}
};

CreatureAI* GetAI_mob_vile_spirit(Creature* pCreature)
{
return new mob_vile_spiritAI(pCreature);
}

struct MANGOS_DLL_DECL mob_raging_spiritAI : public BSWScriptedAI
{
mob_raging_spiritAI(Creature *pCreature) : BSWScriptedAI(pCreature)
{
pInstance = (ScriptedInstance*)pCreature->GetInstanceData();
Reset();
}

ScriptedInstance *pInstance;

void Reset()
{
resetTimers();
m_creature->SetDisplayId(10771);
}

void UpdateAI(const uint32 uiDiff)
{
if (!pInstance || pInstance->GetData(TYPE_LICH_KING) != IN_PROGRESS)
m_creature->ForcedDespawn();

if (!m_creature->SelectHostileTarget() || !m_creature->getVictim())
return;

timedCast(SPELL_SOUL_SHRIEK, uiDiff);
}
};

CreatureAI* GetAI_mob_raging_spirit(Creature* pCreature)
{
return new mob_raging_spiritAI(pCreature);
}

void AddSC_boss_the_lich_king_icc()
{
Script *newscript;

newscript = new Script;
newscript->Name = "boss_the_lich_king_icc";
newscript->GetAI = &GetAI_boss_the_lich_king_icc;
newscript->RegisterSelf();

newscript = new Script;
newscript->Name = "boss_tirion_icc";
newscript->GetAI = &GetAI_boss_tirion_icc;
newscript->pGossipHello = &GossipHello_boss_tirion_icc;
newscript->pGossipSelect = &GossipSelect_boss_tirion_icc;
newscript->RegisterSelf();

newscript = new Script;
newscript->Name = "mob_ice_sphere_icc";
newscript->GetAI = &GetAI_mob_ice_sphere_icc;
newscript->RegisterSelf();

newscript = new Script;
newscript->Name = "mob_defiler_icc";
newscript->GetAI = &GetAI_mob_defiler_icc;
newscript->RegisterSelf();

newscript = new Script;
newscript->Name = "mob_strangulate_vehicle";
newscript->GetAI = &GetAI_mob_strangulate_vehicle;
newscript->RegisterSelf();

newscript = new Script;
newscript->Name = "mob_vile_spirit";
newscript->GetAI = &GetAI_mob_vile_spirit;
newscript->RegisterSelf();

newscript = new Script;
newscript->Name = "mob_raging_spirit";
newscript->GetAI = &GetAI_mob_raging_spirit;
newscript->RegisterSelf();

};

Can you make this script in your next update is the lichking fight


// Script Generated: 2010-03-29 23:23:48
// Run this query on your world database
// UPDATE `creature_template` SET ScriptName='npc_Professor Putricide' WHERE `entry`=36678;
#include "precompiled.h"


struct MANGOS_DLL_DECL Professor PutricideAI : public ScriptedAI
{
Professor PutricideAI(Creature* pCreature) : ScriptedAI(pCreature)
{
Reset();
}

uint32 spell1_phase1_Timer;
uint32 spell2_phase1_Timer;
uint32 spell3_phase1_Timer;
uint32 spell4_phase1_Timer;
uint32 spell5_phase1_Timer;
uint32 spell6_phase1_Timer;
uint32 spell1_phase2_Timer;
uint32 spell2_phase2_Timer;
uint32 spell3_phase2_Timer;
uint32 spell4_phase2_Timer;
uint32 spell5_phase2_Timer;
uint32 spell6_phase2_Timer;
uint32 spell1_phase3_Timer;
uint32 spell2_phase3_Timer;
uint32 phase;

void Aggro(Unit* pWho)
{
}

void KilledUnit(Unit* pVictim)
{
}

void JustDied(Unit* pKiller)
{
}

void Reset()
{
spell1_phase1_Timer = 20000+rand()%20000;
spell2_phase1_Timer = 80000+rand()%20000;
spell3_phase1_Timer = 20000+rand()%20000;
spell4_phase1_Timer = 20000+rand()%20000;
spell5_phase1_Timer = 50000+rand()%30000;
spell6_phase1_Timer = 80000+rand()%20000;
spell1_phase2_Timer = 20000+rand()%20000;
spell2_phase2_Timer = 60000+rand()%20000;
spell3_phase2_Timer = 50000+rand()%30000;
spell4_phase2_Timer = 50000+rand()%30000;
spell5_phase2_Timer = 30000+rand()%30000;
spell6_phase2_Timer = 50000+rand()%40000;
spell1_phase3_Timer = 20000+rand()%20000;
spell2_phase3_Timer = 10000+rand()%10000;
phase = 0;
}

void UpdateAI(const uint32 diff)
{
if (!m_creature->SelectHostileTarget() || !m_creature->getVictim())
return;

if (phase == 1)
{

if (spell1_phase1_Timer <= diff)
{
DoCastSpellIfCan(SelectUnit(SELECT_TARGET_RANDOM, 0), 70346);
spell1_phase1_Timer = 20000+rand()%20000;
} else spell1_phase1_Timer -= diff;

if (spell2_phase1_Timer <= diff)
{
DoCastSpellIfCan(SelectUnit(SELECT_TARGET_RANDOM, 0), 71968);
spell2_phase1_Timer = 80000+rand()%20000;
} else spell2_phase1_Timer -= diff;

if (spell3_phase1_Timer <= diff)
{
DoCastSpellIfCan(m_creature->getVictim(), 70672);
spell3_phase1_Timer = 20000+rand()%20000;
} else spell3_phase1_Timer -= diff;

if (spell4_phase1_Timer <= diff)
{
DoCastSpellIfCan(SelectUnit(SELECT_TARGET_RANDOM, 0), 70701);
spell4_phase1_Timer = 20000+rand()%20000;
} else spell4_phase1_Timer -= diff;

if (spell5_phase1_Timer <= diff)
{
DoCastSpellIfCan(m_creature->getVictim(), 70447);
spell5_phase1_Timer = 50000+rand()%30000;
} else spell5_phase1_Timer -= diff;

if (spell6_phase1_Timer <= diff)
{
DoCastSpellIfCan(SelectUnit(SELECT_TARGET_RANDOM, 0), 71617);
spell6_phase1_Timer = 80000+rand()%20000;
} else spell6_phase1_Timer -= diff;
}

if (phase == 2)
{

if (spell1_phase2_Timer <= diff)
{
DoCastSpellIfCan(SelectUnit(SELECT_TARGET_RANDOM, 0), 70346);
spell1_phase2_Timer = 20000+rand()%20000;
} else spell1_phase2_Timer -= diff;

if (spell2_phase2_Timer <= diff)
{
DoCastSpellIfCan(m_creature->getVictim(), 71968);
spell2_phase2_Timer = 60000+rand()%20000;
} else spell2_phase2_Timer -= diff;

if (spell3_phase2_Timer <= diff)
{
DoCastSpellIfCan(SelectUnit(SELECT_TARGET_RANDOM, 0), 70672);
spell3_phase2_Timer = 50000+rand()%30000;
} else spell3_phase2_Timer -= diff;

if (spell4_phase2_Timer <= diff)
{
DoCastSpellIfCan(m_creature->getVictim(), 70447);
spell4_phase2_Timer = 50000+rand()%30000;
} else spell4_phase2_Timer -= diff;

if (spell5_phase2_Timer <= diff)
{
DoCastSpellIfCan(SelectUnit(SELECT_TARGET_RANDOM, 0), 71278);
spell5_phase2_Timer = 30000+rand()%30000;
} else spell5_phase2_Timer -= diff;

if (spell6_phase2_Timer <= diff)
{
DoCastSpellIfCan(SelectUnit(SELECT_TARGET_RANDOM, 0), 72297);
spell6_phase2_Timer = 50000+rand()%40000;
} else spell6_phase2_Timer -= diff;
}

if (phase == 3)
{

if (spell1_phase3_Timer <= diff)
{
DoCastSpellIfCan(m_creature, 71603);
spell1_phase3_Timer = 20000+rand()%20000;
} else spell1_phase3_Timer -= diff;

if (spell2_phase3_Timer <= diff)
{
DoCastSpellIfCan(SelectUnit(SELECT_TARGET_RANDOM, 0), 72672);
spell2_phase3_Timer = 10000+rand()%10000;
} else spell2_phase3_Timer -= diff;
}

DoMeleeAttackIfReady();
}
};

CreatureAI* GetAIProfessor Putricide(Creature* pCreature)
{
return new Professor PutricideAI (pCreature);
}

void AddSC_Professor Putricide()
{
Script *newscript;
newscript = new Script;
newscript->Name = "npc_Professor Putricide";
newscript->GetAI = &GetAIProfessor Putricide;
newscript->RegisterSelf();
}

this is the script from Professor Putricide or is this wrong for mangos


scripts/northrend/icecrown_citadel/icecrown_citadel at master from rsa's scriptdev2 - GitHub (http://github.com/rsa/scriptdev2/tree/master/scripts/northrend/icecrown_citadel/icecrown_citadel/)

on the page you will find scritps

Ellenya, DO NOT ask for things like this. It is against forum rules. If Cthulhu wants to add this, he will. But on his own time. Do not push for things like this, or you will be infracted. You have been warned.

[CthulhuFtagn]

Thanks Bing.

[GrandpaJohn]

@CT:

morning to ya there from West Palm Beach, Fl hope alss well out your way

[CthulhuFtagn]

Doing great, just compiling an update and testing with a fresh install (just to make sure). The weather's nice today, gonna have some of the in-laws over and chill-axe.

And, here it is...

Update Available:

MaNGOS updated to 10450
Skip wrong guid movement packets.
Typos in enum names and comments.
YTDB updated to 341 (563_FIX_10434)
ScriptDev2 updated to 1816 FIXING

[GrandpaJohn]

@CT:

mangos went in unsuccessful,([Err] 1054 - Unknown column '561_FIX_10372' in 'db_version_ytdb'
[Err] # Y2kCat
ALTER TABLE db_version_ytdb CHANGE COLUMN 561_FIX_10372 563_FIX_10434 BIT;
[Msg] Finished - Unsuccessfully)

scriptdev2 was successfull

[CthulhuFtagn]

That's weird... I even re-downloaded the entire pack to get it just right...

Delete these lines from mangos_0031.sql (It's at the top)

# Y2kCat
ALTER TABLE db_version_ytdb CHANGE COLUMN 561_FIX_10372 563_FIX_10434 BIT;
REPLACE INTO `db_version_ytdb` (`version`) VALUES ('563_FIX_10434');Replace with


# Y2kCat
ALTER TABLE db_version_ytdb CHANGE COLUMN 562_FIX_10408 563_FIX_10434 BIT;
REPLACE INTO `db_version_ytdb` (`version`) VALUES ('563_FIX_10434');

I know what I did wrong, I forgot to include the mangos_0013.sql file inside the all file... so the All file went in fine, but if you already installed them in order then you would have that problem... fixing now.

[GrandpaJohn]

@CT:

so i just need to change the 561 to 562 then save and reinstall it >

[CthulhuFtagn]

561_FIX_10372
to
562_FIX_10408

[GrandpaJohn]

@CT:

there ya go man that took care of it 755 quieries finished successfully wow big update server booted up great
sorry man my first error

[CthulhuFtagn]

No, it wasn't your fault... that was my bad, I saw it right when you posted your error message... I'll try to be more vigilant in the future.

[GrandpaJohn]

@ CT:

hey man you're entitled to a mistake you're only human and you have a lot on your mind its not a biggy
but i did think i did something wrong

[CthulhuFtagn]

Fix-ted... lol

Update Available:

Fixed errors in mangos_0031.sql and mangos_0000-0031_all.sql

CU_0031a.zip (http://www.mediafire.com/?7x7zv676dlthc6t) (14.60 MB)

[GrandpaJohn]

so do i need to apply this one too ?

[CthulhuFtagn]

Nope... it's just to fix the file that you've already fixed.

[GrandpaJohn]

@ CT:

question about mysql,if i try to install itv as a service this is what i get (Installing MySQL as an Service
Access is denied.
0 file(s) copied.
Install/Remove of the Service Denied!
Try to start the MySQL deamon as service ...
The service name is invalid.

More help is available by typing NET HELPMSG 2185.

Press any key to continue . . .) any ideas why it wont let me install it?

i can start it without installing it ok

[Biohazzard]

Yep, I got the document. I'm trying to confirm most of them.

Well, I do my own testing before releases... but thanks.
Well ... i'm happy to hear that ;) i hope to help as you as the others i'll try to check all instances and will send you again a text file.. i'm tryin to don't spaming here...
okey i leave you to finish you're work aaaaand i'm on my way to check mine :) cya
and thanks for the update ;]
Oh for bit to forgeting ... aamm i wanna ask you does it good to be used some script from the scriptdev2 forums ? there are posting the scripts by coding... check the ellenya's link earlier... :)
Thanks in advance bye for now and sry if i do mistakes, my english is not very well...
(whew) nice ppls here ;]

[usns]

awesome man nice work best repack out there ive tested tu

[CthulhuFtagn]

@ CT:

question about mysql,if i try to install itv as a service this is what i get (Installing MySQL as an Service
Access is denied.
0 file(s) copied.
Install/Remove of the Service Denied!
Try to start the MySQL deamon as service ...
The service name is invalid.

More help is available by typing NET HELPMSG 2185.

Press any key to continue . . .) any ideas why it wont let me install it?

i can start it without installing it okStop the mysql.bat from running first, right-click the mysql_installservice.bat file and click Run as administrator, that should do it.


awesome man nice work best repack out there ive tested tuThanks, I'm glad you like it.

[GrandpaJohn]

@ CT:

well i tried what you said but it still tells me the same thing guess i'll just have to run it the way i've been doing it.

[CthulhuFtagn]

Weird, sorry I couldn't be of more help. You can (if you are running Windows Vista / Windows 7) disable User Account Control and then restart. Not sure why it won't install as a service for you... darn. I know that if you are running from a Guest account it may disable you starting a service, but I doubt that's it.

[GrandpaJohn]

@ CT:

i'm running windows 7 home edition, not sure if i'm running from a guest account or not how do i tell ?

[CthulhuFtagn]

Go Start and where it says "Search programs and files" type User Accounts click on it at the top.

http://img186.imageshack.us/img186/7594/usero.jpg

http://img814.imageshack.us/img814/7289/uac.jpg

[ZomgEary]

Ohai! Awesome work with the AHBot, and all the updates TRM:)

[CthulhuFtagn]

Thanks brother Zomg, good to see you still around dude.

[GrandpaJohn]

@ CT:

well its working as a service now iwas already had an administrator account but i had to put the user account control settings to its lowest and then restart and now it works thanks much man you're great

[GrandpaJohn]

@ Zomg:

howdy there bud how ya been long time no see
how ya like my avatar that CT made me

[ZomgEary]

Thanks brother Zomg, good to see you still around dude.

Yeah, classes started...amongst other things, but now I am back..so hopefully I won't be lazy..and be able to help you out some again:P or wherever / whenever you need it.


@ Zomg:

howdy there bud how ya been long time no see
how ya like my avatar that CT made me

I've been fine, yourself? And looks good, I've been watching him change his avatar quite a bit. Good to see you've gotten yourself one! :)

[GrandpaJohn]

@ Zomg:

i'm doing great loving this repack of CT's keeping up with all his updates and doing just great
well guys this ole man gonna get off for the nite and i'll see ya'll tommorrow.

[ZomgEary]

@ Zomg:

i'm doing great loving this repack of CT's keeping up with all his updates and doing just great

Yeah, can't beat TRM, lol. By the way, congratulations on the Donator title.

EDIT: Side-note, don't know if it's any concern, but updates all went in flawlessly, since I last updated(CU006). :) So keep up the good work!

[matt71tx]

Very nice repack. This is one of the "cleanest" repacks I have used. I configured the repack with no problems and was able to apply all of the CU_0031a updates fine. The only errors mangos reported were these:

ERROR:SD2: Script registering but ScriptName npc_eye_of_acherus is not assigned in database. Script will not be used.
ERROR:SD2: Script registering but ScriptName mob_archaeras_add is not assigned in database. Script will not be used.
ERROR:SD2: Script registering but ScriptName event_spell_altar_boss_aggro is not assigned in database. Script will not be used.
ERROR:SD2: Script registering but ScriptName instance_onyxias_lair is not assigned in database. Script will not be used.

Did I miss something or are these normal errors for this release?

Thanks for the work on this repack. I am trying to find a stable and reliable WOTLK repack before things go crazy when then new expansion comes out. This repack seems to be the best one I have tried so far.

[CthulhuFtagn]

Thank you for your comments

http://img683.imageshack.us/img683/2945/noterrors.jpg

Those aren't errors, the daemon is simply telling you that those scripts exists in the ScriptDev2 .dll but are not used in the database.

How to Create an Uber Protection Paladin in TRM's Cthulhu Ftagn Repack:

http://www.youtube.com/watch?v=U4IjKn4Q0cs


EDIT: Good mornin', let's get this day started with an update.

Update Available:

MaNGOS updated to 10452
Replace ASSERT by MANGOS_ASSERT.
Typo in World field.

CU_0032.zip (http://filebeam.com/1df4f577a30d64bb663a2848d0748fbc) (14.60)

[Dimman]

http://www.youtube.com/watch?v=U4IjKn4Q0cs
Haha great video! :)

[CthulhuFtagn]

Thanks brother Dimman.

[GrandpaJohn]

@ CT:

morning to ya there in arizona update applied successfully and all is running great
also talking with my son now on skype and he is watching your video on the pally he has a level
80 prot palyy on the pay server also and he is very impressed with your video.

[CthulhuFtagn]

Right on, I'm glad he enjoyed it.

[Bing]

Yes, those "errors" are more of just warnings in this case.

[Go)Focus]

The Link to Download Server_TRM335a is Broked, Can't Download the Server.

http://www.mediafire.com/?vllhabk2jyr5wcb

=S.

Thanks..

[CthulhuFtagn]

Mediafire is currently undergoing maintenance, it looks like... I'll upload to a mirror.

Mirror Download - Filebeam:
Server_TRM335a.zip (http://filebeam.com/027fe749bc104223171f2a9f99b8f2ac) (96.18 MB)

Map and DBC extractor:
maps_dbc.zip (http://filebeam.com/76bd4aed37c998b6146cd12d3af5546e) (90.7 KB)

1. To use, extract the maps_dbc.zip file to anywhere
2. Cut & Paste the ad.exe file from within the extracted folder to your World of Warcraft directory
3. Double-click and wait until it is done extracting (It will close automatically)
4. Cut & Paste the maps and dbc folders to your C:\Windows\Server\MaNGOS\Win32 or x64 folders.

[Go)Focus]

Any News ? xD =)

[GrandpaJohn]

@ Go)Focus:

what type of news are you looking for ?

[CthulhuFtagn]

Update Available:

MaNGOS updated to 10457 (required_10457_01_mangos_spell_proc_event)
Fix proc of 51692 and ranks.
Implement 60764.
Add missing break, thanks to nos4r2zod.
Fix 54821 proc.
Fix disease consume part of 49020 and ranks.
Added the current map & dbc extractor to the tools folder.Filebeam Mirror:
CU_0033.zip (http://filebeam.com/a5012f741cc7199e56a88465b40c2e12)(14.68)

Mediafire Mirror:
CU_0033.zip (http://www.mediafire.com/?lva3ewe2fwi4vbv) (14.68)

http://img443.imageshack.us/img443/4475/consolew.jpg

EDIT: Re-uploaded to fix mangos_0000-0033_all.sql.

[GrandpaJohn]

@ CT:

update executed successfully, server running great no problems thanks keep up the great work man

[CthulhuFtagn]

As a side project, I'm working on a World of Warcraft-like, 2D top-down game called Plains of Chaos. It will be open source, currently it's in VERY low Alpha phase 0.0.0.3 But so far I've got my sprite engine, sound effects, background music, and animation working.

Download:
Plains of Chaos.zip (http://filebeam.com/8d99e5be07912f9d480ef585144bcdc3) (2.91 MB)

Screenshot: (Click to enlarge)
http://img825.imageshack.us/img825/4945/poc0002s.jpg (http://img713.imageshack.us/img713/6859/poc0002.jpg)

Changelog:


0.0.0.3
Resolution now at 1024x768
Resources externalized (Sounds, Music, Sprites, Tiles)
Save files in .ini format, can be easily edited with a text editor (player_0001.sav)
Up, Down, Left, Right
GUI elements added
Sound effects added
Background music added

[GrandpaJohn]

@ CT:

i just downloaded it thats really cool man you are awsome

[CthulhuFtagn]

Thanks GJ, I have so many ideas for this... it's gonna be Epic... scratch that... Legendary!

[GrandpaJohn]

@ CT:

Great i can't wait to give it a try when its done
possibility by the time you make legendary on here the lengendary game will be going lol

[Narcoleptic]

Just amazing friend :) you´re great ;)
Thanks

[legendztheboss]

server is working fine so far, keep up the good work :)

[matt71tx]

Hmmm... Adjusting any Rate.Drop.Item setting in mangos seems to not effect drop rates in game. Any idea whats causing this?

[CthulhuFtagn]

Works great for me. Not sure what YOU are doing wrong.

[Cheogae]

Was just wondering about the updating aspect of the server. When I watch the video I notice that you have a long list in the empty folder but I only see 2 files. This is where I am new to all of this but what do you mean by inject everything from the mangos folder?

[CthulhuFtagn]

In other words, do the same updates you did to the mangos database to the empty database and then run the truncation.sql file into the empty database.
OR, you could have just read the How to.txt file in the empty database folder of the Cumulative Update.


Inject the SQL updates from the mangos folder into your empty database then run the truncation.sql file.Which says the same thing.

I put files in there for a reason.

[Cheogae]

I been able to update some of it but I get some errors from tables that don't exist

[Biohazzard]

As a side project, I'm working on a World of Warcraft-like, 2D top-down game called Plains of Chaos. It will be open source, currently it's in VERY low Alpha phase 0.0.0.3 But so far I've got my sprite engine, sound effects, background music, and animation working.

Download:
Plains of Chaos.zip (http://filebeam.com/8d99e5be07912f9d480ef585144bcdc3) (2.91 MB)

Screenshot: (Click to enlarge)
http://img825.imageshack.us/img825/4945/poc0002s.jpg (http://img713.imageshack.us/img713/6859/poc0002.jpg)

Changelog:


0.0.0.3
Resolution now at 1024x768
Resources externalized (Sounds, Music, Sprites, Tiles)
Save files in .ini format, can be easily edited with a text editor (player_0001.sav)
Up, Down, Left, Right
GUI elements added
Sound effects added
Background music added
LAL ! :D awsome work :) keep it up :)

[Narcoleptic]

Friend can you tell me where should i change or edit stats so that the respawn time of the flowers, ores (professions stuffs) can be faster...? they are too slow...
Thanks

[CthulhuFtagn]

I been able to update some of it but I get some errors from tables that don't existThen you are doing it wrong, as countless others have said the updates went in fine, and I have personally re-downloaded the server and installed all updates (just like in the video) and it works great.


LAL ! :D awsome work :) keep it up :)Thanks dude.


Friend can you tell me where should i change or edit stats so that the respawn time of the flowers, ores (professions stuffs) can be faster...? they are too slow...
ThanksI believe that:

# Rate.Mining.Amount
# Rate.Mining.Next
# Mining Rates (Mining.Amount changes minimum/maximum usetimes of a deposit,
# Mining.Next changes chance to have next use of a deposit)
...
Rate.Mining.Amount = 1
Rate.Mining.Next = 1These might be what you're looking for, but I've never edited those portions of the .conf file so I'm not certain of what values you would need; you can probably fiddle around with them and let us know.

Update Compiling:

MaNGOS updated to 10459
Restore update area aura values at caster/around targets.
Changes to corpse decay/respawn times for creatures.

[Cheogae]

I watched the video more closely and I have seen my problem I think. You updated from CU_0023 while I am using CU_0029. Is that a issue or should it work?


/* SQL Error (1146): Table 'empty.creature_model_race' doesn't exist *
I get this error when I try to load the empty folder. BTW this is my very first
time trying to do this so please be patient :)

[CthulhuFtagn]

@Cheogae: Let me be clear about the update files. If you have already installed an update into your database you shouldn't install that update again. So, if you installed the _all.sql file to get up-to-date, the next time there is an update you would ONLY inject the highest numbered update in the folder. Let me be clearer; if I updated from the original repack and then used CU_0029.zip, I would have injected mangos_0000-0029_all.sql into my database(s), the next update comes along CU_0030.zip, I would ONLY inject mangos_0030.sql into my database... does that make sense?

If you have installed an update, and try to install that same update again, you WILL get errors and you will, more than likely, have to reinstall the server.

Update Available:

MaNGOS updated to 10459
Restore update area aura values at caster/around targets.
Changes to corpse decay/respawn times for creatures.

Filebeam Mirror:
CU_0034.zip (http://filebeam.com/e24bcc933119819949e7149818480c45)(14.68)

Mediafire Mirror:
CU_0034.zip (http://www.mediafire.com/?gx2d6y0s6g6dpbp) (14.68)

[Cheogae]

I am trying to update from the beginning after I unzip the server

[GrandpaJohn]

@ CT:

update installed successfully server booted up no errors and its running great.
great work again man as usual keep it up

[CthulhuFtagn]

Thanks GJ.

Here's a video, we start off with already having placed the file where they need to be and starting the mysql service.

[Cheogae]

Now when I downloaded your repack you had the CU_0029 linked with it. So that is where I started to try and update from. But where should I actually start updating from if I unzip the server folder to my harddrive?

[CthulhuFtagn]

Best watched in 720p in full screen at YouTube (just click the YouTube logo in the lower-right of the video).

http://www.youtube.com/watch?v=PYTwJg5ByfM

REMEMBER: This video is only used if you are updating from a clean 0000 server to the newest version.

[Cheogae]

So if I want a lively server I shouldn't worry about the empty part then?

[CthulhuFtagn]

Correct.

[Cheogae]

K thanks. I ran into a small snag but I am moving over to my other pc to do the work since I have more problems with win7 with this kind of stuff than xp home or xp pro

[CthulhuFtagn]

As you can see I am using Windows 7 Ultimate (x64) and there are no problems.

http://img195.imageshack.us/img195/5347/infopm.jpg

[Cheogae]

I have win7 ultimate but running 32bit when I can be running 64

[CthulhuFtagn]

It has nothing to do with your operating system, my repack works on any system and has been tested on Windows XP, Vista, and Windows 7 (both 32 & 64-bit)

[Cheogae]

Oh the repack runs fine without the updates its just the updating. I am getting a error now dealing with my mysql server on the other pc so I am downloading a new version. I am still new to mysql atm, The stupid community college I went to only offers Microsoft Access.

/* SQL Error (1064): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ALTER TABLE db_version_ytdb CHANGE COLUMN 561_FIX_10372 562_FIX_10408 bit' at line 4 */ That is the error I got while updating mangos. I was a small way into the update.

[CthulhuFtagn]

Since I've been really patient, I will ask that you not post your error messages or anymore questions here as I will not answer or respond to them as you seem as if you cannot follow the simplest instructions, nor can you follow a VIDEO outlining the process. Please do not even respond to this post as I'm done with arguing and my wife says I need to relax.

[GrandpaJohn]

@ CT:

Hey bud how do you get that windows 7 system info window to come up, when i right click my computer i get a different window pop up

[CthulhuFtagn]

Click on Start > All Programs > Accessories > System Tools > System Information

Alternately, you can Click Start and where it says "Search programs and files" type System Information and click the top link.

[marko94]

Since I've been really patient, I will ask that you not post your error messages or anymore questions here as I will not answer or respond to them as you seem as if you cannot follow the simplest instructions, nor can you follow a VIDEO outlining the process. Please do not even respond to this post as I'm done with arguing and my wife says I need to relax.

All those instructions on the main page and no one is reading them ... shame ...

[CthulhuFtagn]

A'men.

[Cheogae]

Everything seems to gone fine finally just a simple question when your server is fully up to date should it say mangos/0.17.0-dev (* * Revision 10459)?

[CthulhuFtagn]

Update Available:

MaNGOS updated to 10461
Fix error message in extractor tool
Fixed unexpected area aura stacking from same caster at spellmods reapply.

Filebeam Mirror:
CU_0035.zip (http://filebeam.com/a94d9e2a55ce18e10859894e3726020c)(14.68)

Mediafire Mirror:
CU_0035.zip (http://www.mediafire.com/?qsjcgfmzh6ocdkx) (14.68)

[Cheogae]

Hey Cthulu did the updates stop a player from opening the door to go to the Lich King?

[GrandpaJohn]

@ CT:

well brotherman that update went in sucessfully with no problems as was expected server running great keep the the great work bro

[CthulhuFtagn]

@ A person who can actually read and follow directions:

Right on GJ, hey can you do me a favor? Can you remind me where the 'door' to the Lich King is? It's weird, because I always used the Spire's teleporter to get to the Lich King, but now I hear that there is a door... I guess you learn something new everyday.

[Piplup]

Cheogae, end any mysqld.exe processes from your Task Manager and use the MySQL.bat inside the Server folder - try updating after doing this.

I think the problem was that you're trying to update a different DB (probably from a different repack) with the same DB login info as this repack.

[Cheogae]

The door worked before I updated :) and the boss (Deathbringer Saurfang) was spawned to boot unlike now

[GrandpaJohn]

@ CT:

I believe its the door next to the, "BIG ROCK CANDY MOUNTAIN" !

[CthulhuFtagn]

Yup, that was it GJ... right next to it.


http://www.youtube.com/watch?v=G0dgJBNISNA

Well, I gotta head to the Dojo in 30 minutes so gotta get my Gi/Obi on... I'll catch up later.

[wjcb1975]

Hello all. I'm GJ's son and I have been playing this game for about 6 years now, the pay one and ones like these , and i have never had a problem with any of CT's repacks at all. I never post anything because i know how to read directions properly. As long as ive been playing ive never used a door to get to the lich king, a teleporter yes but never a door. If you guys quit posting these supposed problems and read and follow directions you will be able to play the game and learn a few things about it like there are no doors to the lich king.

[Cheogae]

If I was using another map, vmap, dbc, buildings download instead of the one that Cthulu has posted. Would that make a difference on how the server works?

[CthulhuFtagn]

Yes it would


Hello all. I'm GJ's son and I have been playing this game for about 6 years now, the pay one and ones like these , and i have never had a problem with any of CT's repacks at all. I never post anything because i know how to read directions properly. As long as ive been playing ive never used a door to get to the lich king, a teleporter yes but never a door. If you guys quit posting these supposed problems and read and follow directions you will be able to play the game and learn a few things about it like there are no doors to the lich king.+rep x 6

[jimmy6666]

Hey Cthulhu Ftagn

Did you ever manage to figure out why the music wasn't playing for the Darkmoon Faire?

I've looked into it and it seems for music to play you need to have the "new area" heading pop up Eg "Darkmoon Faire" pop up which triggers the music, as it does when Eg you enter the "Elwynn Forest" - presumably there's no "area" been defined for the Faire in the repack? As when you enter the faire "Elwynn Forest" pops up along with the standard Elwynn music.

[Biohazzard]

@CT
Hey dude :) You got a new rank ! GRATZ!!!!!! /bow /respect the administrator is right to gave you that ;) you're cool man, you're just a cool!
I Respect your work and my dream is: when i get old will be like you :P +rep again for ya

NOTES: Hey guys watch this out and have fun :D


http://www.youtube.com/watch?v=3n49U1BxZ2M

[GrandpaJohn]

@ CT:

yeah bro congrats on the new rank you definetly deserve it keep up your great work

[CthulhuFtagn]

Hey Cthulhu Ftagn

Did you ever manage to figure out why the music wasn't playing for the Darkmoon Faire?

I've looked into it and it seems for music to play you need to have the "new area" heading pop up Eg "Darkmoon Faire" pop up which triggers the music, as it does when Eg you enter the "Elwynn Forest" - presumably there's no "area" been defined for the Faire in the repack? As when you enter the faire "Elwynn Forest" pops up along with the standard Elwynn music.Yeah, I was looking into it, I haven't got it fixed yet, but it's still on my queue of 'to-do'.


@CT
Hey dude :) You got a new rank ! GRATZ!!!!!! /bow /respect the administrator is right to gave you that ;) you're cool man, you're just a cool!
I Respect your work and my dream is: when i get old will be like you :P +rep again for ya

NOTES: Hey guys watch this out and have fun :D
... Video ...Thanks brother... that video was disturbing...


@ CT:

yeah bro congrats on the new rank you definetly deserve it keep up your great workThanks GJ!

[paulwantstoplay]

Hey, CT! Gratz with your new rank, and thanks for the help you gave me through PM.
The server works smoothly now, and i've got AH-bot working too!
It's easy if you just read what you write. Can't imagine why anyone else would have problems with that! :D

Like I promised, a huge big +1rep

EDIT: seems I have to give someone else rep first, before i can give it to you.
By reading all the posts here, i think i give grandpaJohn rep, as he seems to be your best fan!

[ZomgEary]

Hey CT (I feel dirty calling you that-.-), I'm not sure if what I'm about to ask if it is a known issue for you or not, but I've encountered a few cloaks now that are giving me the "I'll never be able to equip that" message, simply curious if it's a fail on my side, or a known issue or whatever it may be.

Example would be Might of the Nerub (Heroic)..it's itemID is 47481.

[CthulhuFtagn]

Well, Might of the Nerub (http://www.wowhead.com/?item=47481) is a http://static.wowhead.com/images/icons/horde.gif Horde only item while the http://static.wowhead.com/images/icons/alliance.gif Alliance counterpart is Strength of the Nerub (http://www.wowhead.com/item=47192)... if you are Alliance and trying to wear the Might cloak, that will give you the error in question.


This item will be converted to http://static.wowhead.com/images/wow/icons/tiny/inv_misc_cape_16.gif Strength of the Nerub (http://www.wowhead.com/item=47192) if you transfer to http://static.wowhead.com/images/icons/alliance.gif Alliance.

[ZomgEary]

Pff..well Noob moment ftw! Thank you lol.

[CthulhuFtagn]

Not a problem brother Zomg.


http://www.youtube.com/watch?v=r10H7hs-3AI

[ZomgEary]

Yeah..went and checked after you informed me of my mistake lol, thanks again...should of figured that was why..oh well..

[Biohazzard]

@CT
Sorry mate, but ... can u give me a coordinates for the Frozen throne ... i try so many but i can't found it ...

Note: please give me justa a .tele xxxxx.xxxx.x.x.x.x.x.x.x. etc.
Really sry about that question...

[GrandpaJohn]

@ Zomg:

uh oh!! Zomg look out now hes giving you a video just like he did Chaogae

[CthulhuFtagn]

@CT
Sorry mate, but ... can u give me a coordinates for the Frozen throne ... i try so many but i can't found it ...

Note: please give me justa a .tele xxxxx.xxxx.x.x.x.x.x.x.x. etc.
Really sry about that question...

.tele TheFrozenThroneor you could have done

.lookup tele frozen

Coordinates are:

.go xyz 500.091 -2126.92 1041.64 631

[Biohazzard]

.tele TheFrozenThroneor you could have done

.lookup tele frozen

Coordinates are:

.go xyz 500.091 -2126.92 1041.64 631
thanks mate you're great... can u be my father ? ^^

[CthulhuFtagn]

http://www.tshirtbordello.com/images/whos-your-daddy-lg.gif

You guys should check out my other post while you're waiting for my next update:
http://mmopro.net/forums/f53/largest-collection-cataclysm-icons-interface-elements-loading-screens-769-mb-4414/

[Rathir]

Oh my gosh Cthulhu, I leave for a little bit and you've updated to 35 . . . (I was on 19) nice work as always. :)

Update 35 worked perfectly.

[CthulhuFtagn]

Right on, I'm glad you kept it going error-free.

[Biohazzard]

http://www.tshirtbordello.com/images/whos-your-daddy-lg.gif

You guys should check out my other post while you're waiting for my next update:
http://mmopro.net/forums/f53/largest-collection-cataclysm-icons-interface-elements-loading-screens-769-mb-4414/

I Really wanna be my father :D now i confirum my words :D GOOD GOOD JOB VERY GOOD ! /bow and /respect

[CthulhuFtagn]

Before I release this update, I want you to remember that it's been 9 years since the attacks on the World Trade Center Towers; let us never forget those who lost their lives and continue to lose and risk their lives for our freedom overseas. God bless America, it's Allies, and God bless our Troops!

http://img827.imageshack.us/img827/7826/911c.jpg

Update Available:

MaNGOS updated to 10471
Drop vmap_debugger.
Fixed totem owner faction/level set for creature onwer case.
Rename some opcode handler to better follow used naming style.
Typos in comments in recent patches.
Implement proper triggering for spell 34477, 57934
Proper reset threat rediraction for existed spells.
Implement SPELL_EFFECT_REDIRECT_THREAT
Revert a part of [10463] and move them back to the .gitignore file in the sub-directory
Clean up the .gitignore files.
Implement spell 6495.

Filebeam Mirror:
CU_0036.zip (http://filebeam.com/f030d8ee4c93804cf7fd08a3f6128778) (14.69)

Mediafire Mirror:
CU_0036.zip (http://www.mediafire.com/?hn2w989bpb8vb8m) (14.69)

[GrandpaJohn]

@ CT:

I agree with you 100% brother, amen to what you said, " GOD BLESS US ALL".

Also man update executed successfully server running great no errors keep up the great work bro

[Narcoleptic]

Thanks once again ;) working Great :)

[CthulhuFtagn]

Good morning my fellow mmoprotozoans; let's get this party started.

Update Available:

MaNGOS updated to 10475
Implement SPELL_AURA_HEAL_ABSORB (301).
Cleanup vmap_assembler.
Fix structure SMSG_SPELLHEALLOG for 3.5.5.
Implement SPELL_AURA_MOD_PET_AOE_DAMAGE_AVOIDANCE (310).

Filebeam Mirror:
CU_0037.zip (http://filebeam.com/69f1969cda390f785d1507a9c38b9504) (14.69)

Mediafire Mirror:
CU_0037.zip (http://www.mediafire.com/?b41lq9f1d1b5mcd) (14.69)

[GrandpaJohn]

@ CT:

well the update executed successfully and the server booted up with no errors.
i'm begining to feel like a broken record, but i suppose thats a good thing tho right ?

[CthulhuFtagn]

A very good thing, I need your feedback just in-case.

[dialgeta]

how can i change the ip of the database @ mysql..

I don't want it as 127.0.0.1

Because nobody can connect me

how can i change it ;o? D:

[CthulhuFtagn]

How to edit your database:

Install SQLyog Community Edition - 8.61 (http://code.google.com/p/sqlyog/downloads/detail?name=SQLyog-8.6.1-0Community.exe&can=2&q=)

Make sure you have MySQL.bat running, then load it up and click Continue, then make sure your connection looks like below:

(Click New to make a connection)

http://img821.imageshack.us/img821/1239/pass.jpg

Username is root
Password is mangos

Click the + next to your realmd database, then click the + next to Tables, then right-click the realmlist table and click Open table. Now edit the address column to reflect your external IP. Now click the blue disk to save (next to the red trash can).

http://img526.imageshack.us/img526/698/realmlistj.jpg

This is also where you can change the name of the server from MaNGOS to whatever you'd like.

Now give your friends the external IP address and make sure they edit their realmlist.wtf file to reflect the change from 127.0.0.1

If you have any more questions, please use the Search function as they have already been answered (as has this one).

EDIT:
Update Available:

MaNGOS updated to 10477.
Fixed heal amount for some cases heal absorb.
Fix 31228 and ranks.Filebeam Mirror:
CU_0038.zip (http://filebeam.com/ebe2ab3f126832fb053936ffaec81a4e) (14.69)

Mediafire Mirror:
CU_0038.zip (http://www.mediafire.com/?y4yeeezyrkr4miz) (14.69)

And a video for all you guys lookin' for a Geek & Gamer Girl:


http://www.youtube.com/watch?v=eRoQWZoG6lI

[GrandpaJohn]

@ CT:

Well bud, just like all the others update executed flawlessly, no errors server up and running great keep up the great work

[CthulhuFtagn]

Let me know how your new machine runs it GJ.

[GrandpaJohn]

@ CT:

its really not a new machine maybe about 4-6 months old i've moved the server to it and its been doing great running the server. The old machine i now play the game on and i dont do anything on that sever machine except for the wow server
so its been doing great so far. i have the the server on the old machine too its the one i use as a update test machine first and also as a backup.

[CthulhuFtagn]

Like I said, the coolest granpa in West Palm Beach, Florida!

[dialgeta]

now i can't connect at all

I knew the thing with the realmlist thing

and uhm I made it work abit.. but I still can't connect to my realm
all my ports are open and I am using my WAN Ip ;O or w/e
I can see the realm list but can't connect to it ... QQ

and If I change the config of respora from 127.0.0.1 it says i can't connect to mysql..

any other ports that I have to open? D:

sorry to bug ._.

I am on latest update ;o

[Narcoleptic]

Maybe is a problem with your ISP...or a router problem...

[CthulhuFtagn]

now i can't connect at all

I knew the thing with the realmlist thing

and uhm I made it work abit.. but I still can't connect to my realm
all my ports are open and I am using my WAN Ip ;O or w/e
I can see the realm list but can't connect to it ... QQ

and If I change the config of respora from 127.0.0.1 it says i can't connect to mysql..

any other ports that I have to open? D:

sorry to bug ._.

I am on latest update ;o

What part of
If you have any more questions, please use the Search function as they have already been answered (as has this one). did you not understand?