Ossirian AQ20

Yo!

I’ve been working on Ossirian the Unscarred. You can find it here: https://github.com/k…e/tree/ossirian

To see the diff: https://github.com/k…ompare/ossirian

Before I open pull request, there are few minor issues:

  • Yells don’t work (IDs are obsolete, will fix tomorow)

  • Crystals aren’t clickable on client side? (This issue has been bugging me for several hours, help appreciated)

Other than that, it is complete (Well, the code which is to be executed after crystal is clicked is not tested but assumed to be working)

Script also assumes following SQL update:

[CODE]-- Ossirian Crystal

UPDATE gameobject_template SET faction=35 WHERE entry=180619;

UPDATE gameobject_template SET ScriptName=‘go_ossirian_crystal’ WHERE entry=180619;

– Ossirian the Unscarred

DELETE FROM script_texts WHERE entry BETWEEN -1509027 AND -1509018;

DELETE FROM creature_text WHERE entry=15339;

INSERT INTO creature_text (entry,groupid,id,text,type,language,probability,emote,duration,sound,comment) VALUES

(15339, 0, 0, ‘I am rejuvinated!’, 14, 0, 100, 0, 0, 8593, ‘SAY_SUPREME_1’),

(15339, 0, 1, ‘My powers are renewed!’, 14, 0, 100, 0, 0, 8595, ‘SAY_SUPREME_2’),

(15339, 0, 2, ‘My powers return!’, 14, 0, 100, 0, 0, 8596, ‘SAY_SUPREME_3’),

(15339, 1, 0, ‘Protect the city at all costs!’, 14, 0, 100, 0, 0, 8597, ‘SAY_INTRO_1’),

(15339, 1, 1, ‘To your posts. Defend the city.’, 14, 0, 100, 0, 0, 8600, ‘SAY_INTRO_2’),

(15339, 1, 2, ‘Tresspassers will be terminated.’, 14, 0, 100, 0, 0, 8601, ‘SAY_INTRO_3’),

(15339, 2, 0, ‘Sands of the desert rise and block out the sun!’, 14, 0, 100, 0, 0, 8598, ‘SAY_AGGRO’),

(15339, 3, 0, ‘You are terminated.’, 14, 0, 100, 0, 0, 8602, ‘SAY_SLAY’),

(15339, 4, 0, ‘I…have…failed.’, 14, 0, 100, 0, 0, 8594, ‘SAY_DEATH’),

(15339, 5, 0, ‘The walls have been breached!’, 14, 0, 100, 0, 0, 8599, ‘SAY_KURINAXX_DEATH’);[/CODE]

Feedback please?

From sniffs:

[5] GUID: Full: 0xF11002C18B00059A Type: GameObject Entry: 180619 Low: 1434

[5] Object Type: GameObject (5)

[5] Update Flags: LowGuid, StationaryObject, GOPosition, GORotation (848)

[5] GO Position GUID: 0x0

[5] GO Position: X: -9407.718 Y: 1960.211 Z: 85.63906

[5] GO Transport Position: X: -9407.718 Y: 1960.211 Z: 85.63906

[5] GO Orientation: 1.117009

[5] GO Transport Orientation: 0

[5] Low GUID: -1962932838

[5] GO Rotation: X: 0 Y: 0 Z: 0.5299187 W: 0.8480484

[5] OBJECT_FIELD_GUID: -1962932838/-2.465612E-32

[5] 1: -250608959/-7.131067E+29

[5] OBJECT_FIELD_TYPE: 33/4.624285E-44

[5] OBJECT_FIELD_ENTRY: 180619/2.531011E-40

[5] OBJECT_FIELD_SCALE_X: 1077936128/3

[5] GAMEOBJECT_DISPLAYID: 6486/9.088822E-42

[5] 13: 1065353216/1

[5] GAMEOBJECT_DYNAMIC: -65536/NaN

[5] GAMEOBJECT_FACTION: 35/4.904545E-44

[5] GAMEOBJECT_BYTES_1: -16774655/-1.701931E+38

Aha, so faction in TDB is incorrect (0). Thanks.

SQL in first post & code updated.

One more issue left: For some reason, when I click the crystal, it doesn’t trigger GO_ossirian_crystal::OnGossipHello().

I get error trying to click on links