[Lua] The Lich King - Blizzlike

[markstbens]

Any ideas mine comes up with this error ....

[stoneharry]

Just do:

insert into `recall` (`id`, `name`, `MapId`, `positionX`, `positionY`, `positionZ`, `Orientation`) values('1867','zoo','631','431.038','-2124.07','1596.06','0.0986058');

Instead. It's because you already have a recall with the id of 867.

[markstbens]

Nice one mate cheers

[Fenalgin]

stoneharry can we talk over msn or and other program...i need you...send me email in private message please.... i got some questions...(added you :P)

and yea +rep... very nice release.

[Valoriaxr]

Well here are all the spells used in total... Rawr ;-;

Broken Frostmourne (too many i wont say what the ids are, search on wowhead :3) all of them apply to dummy's for that reason or not.
Summon terenas


(Spell 73220 which is the soul-blade frostmourne Emote - Sit (No Sheath) - Spell - World of Warcraft) this is the blade that the lich king uses, though im not sure how and why, he doesnt look equipped at all... it may combine on npc wise, of frostmourne yet it looks a little bent on the other side of the real blade, from the old style, so it may apply to the old model aswell, a quick transform maybe? o.o.... trinity is epic for keeping the visuals....

I do not like arcemu well... itl be down by cataclysm i presume.
Trinity and ManGoS might prevail first. since they have always copyed

Ice Lock, Which encases tirion, either the npc, or the spell, that doesnt matter

Ice Lock - Spell - World of Warcraft

the animation Emote ID's are pretty simple

Areatrigger's (the epic stoneharry already used them (bah frozen throne npc on wowhead usually rings a bell, but thats kind of lich king wise, or the platform)

the visuals for the destroy platform event, are on wowhead, but dont seem to work (i tryed them, weird goings on?)

Lich King Zap (Used to freeze tirion, shooting a beam out of frostmourne
(quake ( you already know) blah blah...

the npcs flying, -kind of weird movement on waypoints... but thats a unusual thing i do not understand.-

i think you already have all the spells required... Rawr.

the frostmourne soul one, it applys to players... but its a downward frostmourne. so im very confused by the fact, that it might be a morph OR, a creature in his hand even i can get confused at times...i think the item has the aura applyed to it.

[stoneharry]

Most of the visuals I know now, I was a idiot when I scripted this, I was still using the 3.3.2 DBC's hence having missing spells. I will correct it when I have a chance.

As far as the movement goes on players - I had no idea how to do this... On retail the vrykuls (or however you spell) function as vehicles, but unfortunately they do not on ArcEmu since vehicles are not supported publicly. >_< This is the only work around I have - It just moves the player to the npc's location and the npc runs towards the edge (till it reaches it and drops the player). If the npc dies before reaching there it drops the player. When the player moves - Upon reaching the location he drops slightly and it looks buggy. There is no solution that I know for this, the bubble visual was to stop the player look like he was swimming through the air. :/ If you have a better work-around for this then please tell me.

In terms of ArcEmu, I doubt it will die. It almost did in 3.0.9 if you remember, but if it did die another emulator would pop up that would continue the Ascent based side. Mangos never used to be that popular, infact it used to be terrible. Have faith.

[kaspenic]

I cant get this to work, I was able to extract it into the database, but i cant get to the throne, when i use .rec p zoo
it says instance does not exist

[stoneharry]

I cant get this to work, I was able to extract it into the database, but i cant get to the throne, when i use .rec p zoo
it says instance does not exist

You probably do not have the worldmap_info that is required.
Execute this:

insert into `worldmap_info` (`entry`, `screenid`, `type`, `maxplayers`, `minlevel`, `minlevel_heroic`, `repopx`, `repopy`, `repopz`, `repopentry`, `area_name`, `flags`, `cooldown`, `lvl_mod_a`, `required_quest`, `required_item`, `heroic_keyid_1`, `heroic_keyid_2`, `viewingDistance`, `required_checkpoint`) values('631','631','1','10','80','80','0','0','0','0','Icecrown Citadel 10man','24','86400','0','0','0','0','0','300','0');

Ignore any errors you get, then restart your server. Upon logging back in do .cheat trigger - This will allow you to bypass any raid/instance requirements. Then do .recall port zoo - now it should work.

[Xel]

You wouldn't have made it without me! xD

[kaspenic]

You probably do not have the worldmap_info that is required.
Execute this:

insert into `worldmap_info` (`entry`, `screenid`, `type`, `maxplayers`, `minlevel`, `minlevel_heroic`, `repopx`, `repopy`, `repopz`, `repopentry`, `area_name`, `flags`, `cooldown`, `lvl_mod_a`, `required_quest`, `required_item`, `heroic_keyid_1`, `heroic_keyid_2`, `viewingDistance`, `required_checkpoint`) values('631','631','1','10','80','80','0','0','0','0','Icecrown Citadel 10man','24','86400','0','0','0','0','0','300','0');

Ignore any errors you get, then restart your server. Upon logging back in do .cheat trigger - This will allow you to bypass any raid/instance requirements. Then do .recall port zoo - now it should work.

Thanks it worked... Very good:] +Rep

[davidknag]

Hey, Stone, can you put up a tutorial on how to actually ENTER ICC? I have a 3.3.2 Repack (every time i try to compile arcemu with visual C++ i get an error). I need help with this. but great guide +REP.

[stoneharry]

Hey, Stone, can you put up a tutorial on how to actually ENTER ICC? I have a 3.3.2 Repack (every time i try to compile arcemu with visual C++ i get an error). I need help with this. but great guide +REP.

Just execute the queries provided (including the one in my previous comment - the one above your post) into SQLyog / Navicat etc, restart the server then start WoW.exe. Make sure that your server is online and setup correctly. Upon reaching the WoW login screen you should see a dragon flying around with some dramatic music, and an annoying blizzard announcement on the left that doesn't make any sense but you might as well moan about. Enter your username and password, make sure the account is made on your private server and that the username and password is correct. Now you will login. Create a character, it is very important to make sure you make the correcter character since otherwise you may not like it later on! Now you are in game, you need to press the key [Enter] which is above the button on the right that says "Shift" on it. It is bigger than other buttons. Now you can type into the box that appears on the bottom left ".cheat trigger". Now hit enter again. If all went to plan, it should now say "Trigger Cheat Activated". Now for the final step, it is quite hard so be careful! Press the enter again and type in ".recall port zoo", if it worked then you will now be at the lich king, if not, then pick up the nearest gun you can find, aim it at your head, and pull the trigger (ask your nearest friend for help finding the trigger if unsure).

[BrantX]

Beautifully written, nice work! Can't +rep, have to spread.
I like the work-around you did for Tirion being frozen for some reason :P

[Mr.Jebus Christ]

Tirion's jump is a spell that uses "Jump Charge Unit" which is unsupported by arcemu. Also, use the trinity dbc extractor, it worked fine for me.

[stoneharry]

Tirion's jump is a spell that uses "Jump Charge Unit" which is unsupported by arcemu. Also, use the trinity dbc extractor, it worked fine for me.

Gold star for stating what has already been stated multiple times and a solution found for the DBC problem.