So people don't think we're lazy.. (Changelog)

[Overdriven]

MOBS:

Code: Select all

- EVERY Mob in the database, which previously had a speed of 191 now has a speed of 200.

[Overdriven]

Don't ask why Etaew knows.

Spells:

Code: Select all

- "RvrResurrectionIllness" has been removed from the database.
- "PveResurrectionIllness" has been removed from the database.
- Both necessary LineXSpells were removed too.

[deer_hunter]

Added Mobs to Deamons Breach,

Code: Select all

397 mobs w/ equips in Zone - 489. Nergals breach
and Bilabongs Breach

Also added -

Code: Select all

6 zone points 713-718 for access through the zone 489 to the lowbe RVR zones proving grounds and lions den.

The entrance to these zones are near the main towns. they have an old man at the mouth of a cave.

D_H

[Overdriven]

Nice changes, DH.

Code: Select all

- All archived characters have now been moved and binded to their main city. This was forgotten after the last move.

[deer_hunter]

Thank you OD.

Added Ships to each starting zone.

Code: Select all

INSERT INTO worldobject
(WorldObject_ID, ClassType, Name, X, Y, Z, Heading, Region, Model, Emblem)
VALUES
("05215ca5-8f1c-49e7-9f8e-3e2112b9492b", "DOL.GS.GameStaticItem", "Albion ship", 229467, 227943, 4605, 773, 27, 2646, 0);

INSERT INTO worldobject
(WorldObject_ID, ClassType, Name, X, Y, Z, Heading, Region, Model, Emblem)
VALUES
("4af692b0-85dd-454f-90f8-fb7ae2fd87d5", "DOL.GS.GameStaticItem", "Albion ship", 229517, 227365, 4605, 1342, 27, 2646, 0);

INSERT INTO worldobject
(WorldObject_ID, ClassType, Name, X, Y, Z, Heading, Region, Model, Emblem)
VALUES
("50964f82-c535-48c3-8d65-c3334eb8f293", "DOL.GS.GameStaticItem", "Midgard ship", 360589, 358437, 4605, 1342, 27, 2646, 0);

INSERT INTO worldobject
(WorldObject_ID, ClassType, Name, X, Y, Z, Heading, Region, Model, Emblem)
VALUES
("79e8f08b-468e-492b-983e-b334a4cc550b", "DOL.GS.GameStaticItem", "Hibernian ship", 98395, 96871, 4605, 773, 27, 2646, 0);

INSERT INTO worldobject
(WorldObject_ID, ClassType, Name, X, Y, Z, Heading, Region, Model, Emblem)
VALUES
("a3fa7710-dd3f-4bd3-aaf1-2af32dd2bbdd", "DOL.GS.GameStaticItem", "Midgard ship", 360539, 359015, 4605, 773, 27, 2646, 0);

INSERT INTO worldobject
(WorldObject_ID, ClassType, Name, X, Y, Z, Heading, Region, Model, Emblem)
VALUES
("f0aef6f3-b924-46b6-8c44-fd1697a2884c", "DOL.GS.GameStaticItem", "Hibernian ship", 98445, 96293, 4605, 1342, 27, 2646, 0);


Please don't rerun this code. its just for refrence.
I got tired of looking at the dancing fire on the water.

D_H

[deer_hunter]

OK this is HUGE.

Code: Select all

39.868 mobs w/ equips - no dungeons done yet. (sorry)
zone 73 ALB
zone 30 MID
zone 130 HIB.

Code: Select all

12 zonepoints corrected - used with the ruins of atlantis.

I'm not sure how to get folks to the atlantis areas. I modified the teleport scripts one each for the new zones on my test server.

On live servers there's a boat that will take you from one of the main citys in SI to the ruins, then you teleport to Atlantis. Also there's a teleporter on live now that will teleport you directly to Oceanus Hesperus too.

Code: Select all

600+ world objects.

I'm a little worried about the merchants. I've imported everything but the itemtemplate. I'm pretty sure the items are already in the DOL DB. This will need to be checked.

Please restart the server at your earliest convienence.

D_H
ps- i'm going to take a break for a day or so...

[Etaew]

Good work deer_hunter.

I'll restart either at about 930AM tomorrow, or some time much later in the evening. ZioRed or Overdriven can if they get around to it.

[Overdriven]

God damn, nice update DH :O

[Overdriven]

This is thanks to `Dragonfire` on the forum:

Code: Select all

- 950 items with stats for Catacomb Auralite Armour has been added.
- 950 items have been added to the correct merchant for Auralite Armour
- 14/15 mobs have been added in their correct location for Catacombs

[Overdriven]

Final database backup has just been complete. I am now the ONLY person with the latest database


IF IF IF you're going to do any changes from this point onwards, please PM me and tell me what you intend to change.

[Satyr]

Items Fixed and Added Procs :

Code: Select all

- Azure Faithbound Cudge have now the correct proc ( Self Heal 130 )

- LLron's Ring of Shielding have now the correct proc ( Charges Ablative 50, 10 mins )

- Bane of Life have now the correct proc ( Charges Haste 20%, 10 mins )

- Azure Boots of Notes have now the correct proc ( 95DD Cold )

- Tome of Lichdom have now the correct proc ( Charges power regen 2, 10 mins )

- Stone Boned Choker have now the correct proc ( Charges 150 Ablative, 10 mins )

- Shadow Templar Medallion have now the correct proc ( Charges Endurance Regen 3, 10 mins )

- Medallion of Avoidance have now the correct proc ( Charges Dex/Qui Buff, 10 mins )

- Fine Steel Long Sword (Alb) have now the correct skin / effect / proc ( Haste 20%, 1 min )

- Dark Knight's Fury have now the correct skin / effect / proc ( Ablative 150, 10 mins )

- Swarm Caller's Lute have now the correct proc ( Charges Dex/Qui Debuff 56, 1 min )

Interesting what i found here... why am i fixing stuff atm that is posted to be fixed already ? ^^

[Overdriven]

Interesting what i found here... why am i fixing stuff atm that is posted to be fixed already ? ^^

I'd like to thank you for asking that particular question, it just made my day. Here are some probable reasons:

- They changed database.
- A majority of these fixes have most probably not been re-added
- They went with a "Better" (*Cough*BOLLOCKS*cough*) database, because it had MORE in it, but with MORE incorrect information.

Amongst reasons.

Please bring it up with Grav, and ask for him to go over every single db change and make sure they're still in there please If a majority is missing. I want a cookie.

[Luhz]

My guess is, at least compared to 1.902, a majority haven't been re-added. After I saw your post I started looking through the thread - a bunch of stuff as far back as June 2007 is missing from 1.902, I didn't even bother looking through the rest since then. Sad =(

[Graveen]

yes, sure, although db1.902 and its successors certainly don't get the focus they should.

iirc itemtemplates & mobs are the most different tables when we compare Storm and 1902.

Notice for the 1.9.0.1393, i added all the stuff coming from contribs i add to Storm.

For reviewing this post - i should tell for reviewing all posts in catching modifications - well.... later <think to the non compliant INSERT INTO to change, the need to check if item/spells are not here, the need to adapt to actual linexspell, the need to be careful with mythic changes...>

Anw if i have a volunteer right now, i love !

[Roozzz]

Anw if i have a volunteer right now, i love !

Good to hear, it's been a long time since there was actually a group of active people