Page 7 of 7

PostPosted: Fri Jul 20, 2007 12:06 pm
by Overdriven
MOBS:
Code: Select all
- EVERY Mob in the database, which previously had a speed of 191 now has a speed of 200.

PostPosted: Fri Jul 20, 2007 12:28 pm
by 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.

Deamons Breach

PostPosted: Tue Jul 24, 2007 8:41 pm
by 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

PostPosted: Tue Jul 24, 2007 9:03 pm
by 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.

Alb , Hib, Mid Starting zones.

PostPosted: Wed Jul 25, 2007 4:15 am
by 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

Atlantis areas in DOL server now.

PostPosted: Sat Jul 28, 2007 8:35 pm
by 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... :)

PostPosted: Sat Jul 28, 2007 11:42 pm
by 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.

PostPosted: Sun Jul 29, 2007 12:45 pm
by Overdriven
God damn, nice update DH :O

PostPosted: Mon Aug 06, 2007 4:23 pm
by 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

PostPosted: Thu Aug 16, 2007 11:25 pm
by 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.

Re:

PostPosted: Mon Sep 01, 2008 3:38 am
by 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 ? ^^

Re: Re:

PostPosted: Mon Sep 01, 2008 3:36 pm
by 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.

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

PostPosted: Mon Sep 01, 2008 4:07 pm
by 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 =(

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

PostPosted: Mon Sep 01, 2008 4:32 pm
by 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 :D <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 !

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

PostPosted: Mon Sep 01, 2008 4:44 pm
by 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 8)