DoL Public Database SvN Progress

[Dunnerholl]

im sorry i dont believe the OP list of accomplishments.

are you sure that its 100% spawns? day and night spawns, mobs that only spawn if certain others are killed etc etc ?

make it 99% or something please

i cant even make a main city a 100%

cause those stupid bats are spawning and despawning very fast, the trifecta guy has different visitors at different times and so on

[Argo]

I even think to remove the latest public DB in the "Download" section.

With all due respect Graveen, i don`t think that this is a good idea. We should people give something to start with even though it might be a very basic DB. Without that people will have no motivation for DoL but with it they might become new contributors for a DB or SVN. I remember how thankful i was when i catched a DB which was very very simple in the older days, it motivated me to contribute and create the missing things and so on. Just give it a second thought before you remove it

kind regards
Argoras

[Graveen]

In my mind a sticky topic would provide the places/links to download the databases while the download section is DoL server only.

But it was just an idea to separate DoL code from DoL db. Nothing really serious, so as we don't really have trouble with it, public db will stay here

[Argo]

In my mind a sticky topic would provide the places/links to download the databases while the download section is DoL server only.

An acceptable idea, worth a second thought

kind regards
Argoras

[geshi]

I'd like to help with this What's the best way to log all items from live? instead of doing it all by hand of course

[Roozzz]

I'd like to help with this What's the best way to log all items from live? instead of doing it all by hand of course

Packetlogger, then run it through the filter/converter.

[geshi]

It gets the currect item stats too? do I just delve a load of items or what?

[Graveen]

yep you must delve all. and link it to model/glow etc..

[geshi]

Ok, I'm going to start a list of things that need to be updated/fixed
1.98 http://www.camelotherald.com/article.php?id=513

Code: Select all

Druids
 
 - The summoned pets in the Nature Specialization line have all had their health increased by 5%. Additionally, the following pets have had their max level when summoned adjusted as follows:
 
Level 32 - Call Greater Nature Bear, Lynx, Wolf, Tree - Pet will summon at 76% of Caster's Level.
Level 43 - Call Elder Nature Bear - Pet will summon at 88% of Caster's Level.
Level 44 - Call Elder Nature Lynx - Pet will summon at 88% of Caster's Level.
Level 45 - Call Elder Nature Wolf, Tree - Pet will summon at 88% of Caster's Level.
 
 
 - A new snare spell has been added to the Nature Specialization line. This spell will not leave snare / root immunity on the target when removed.
 
Level 9  - Grasping Ivy - 2.5s cast / 20s duration / 60s recast - 1500 range - 50% snare (Matter) - 14 power
Level 19 - Grasping Tendrils - 2.5s cast / 30s duration / 60s recast - 1500 range - 50% snare (Matter) - 20 power
Level 29 - Grasping Creepers - 2.5s cast / 40s duration / 60s recast - 1500 range, 350 radius - 50% snare (Matter) - 27 power
Level 39 - Grasping Tangleweed - 2.5s cast / 50s duration / 60s recast - 1500 range, 350 radius - 50% snare (Matter) - 34 power
Level 49 - Grasping Thornweed - 2.5s cast / 60s duration / 60s recast - 1500 range, 350 radius - 50% snare (Matter) - 40 power
 
 
Warlocks
 
With 1.98, we are introducing several major changes to the current layout of how warlock spells are organized into their specialization lines. As such, all Warlocks have had all training points refunded, and may visit their trainers to respecialize.
 
Cursing Specialization:
 
 - Damage (Bolt), Primary
Level 2 - Lesser Bolt of Ruin - 3.2s cast / 20s recast - 1875 range - 10 damage (Matter) - 8% power
Level 4 - Greater Bolt of Ruin - 3.2s cast / 20s recast - 1875 range - 30 damage (Matter) - 8% power
Level 9 - Lesser Bolt of Havoc - 3.2s cast / 20s recast - 1875 range - 59 damage (Matter) - 8% power
Level 14 - Greater Bolt of Havoc - 3.2s cast / 20s recast - 1875 range - 87 damage (Matter) - 8% power
Level 17 - Lesser Bolt of Destruction - 3.2s cast / 20s recast - 1875 range - 116 damage (Matter) - 8% power
Level 20 - Bolt of Destruction - 3.2s cast / 20s recast - 1875 range - 153 damage (Matter) - 8% power
Level 24 - Greater Bolt of Destruction - 3.2s cast / 20s recast - 1875 range - 202 damage (Matter) - 8% power
Level 28 - Lesser Bolt of Death - 3.2s cast / 20s recast - 1875 range - 258 damage (Matter) - 8% power
Level 36 - Bolt of Death - 3.2s cast / 20s recast - 1875 range - 326 damage (Matter) - 8% power
Level 48 - Greater Bolt of Death - 3.2s cast / 20s recast - 1875 range - 413 damage (Matter) - 8% power
 
 - Damage (Direct), Primary
Level 3 - Curse of Hurt - 4s cast - 1500 range - 20 damage (Matter) - 7% power
Level 8 - Curse of Pain - 4s cast - 1500 range - 40 damage (Matter) - 7% power
Level 13 - Curse of Detriment - 4s cast - 1500 range - 59 damage (Matter) - 7% power
Level 19 - Curse of Ruin - 4s cast - 1500 range - 105 damage (Matter) - 7% power
Level 23 - Curse of Peril - 4s cast - 1500 range - 140 damage (Matter) - 7% power
Level 27 - Curse of Devastation - 4s cast - 1500 range - 178 damage (Matter) - 7% power
Level 35 - Curse of Disaster - 4s cast - 1500 range - 224 damage (Matter) - 7% power
Level 47 - Curse of Death - 4s cast - 1500 range - 284 damage (Matter) - 7% power
 
 - Damage (Direct) - This is not a primary / secondary spell, and will be affected by Dexterity and Casting Speed bonuses.
Level 5 - Lesser Twisting Curse - 2.8s cast - 1500 range - 29 damage (Matter) - 7% power
Level 10 - Twisting Curse Enemy - 2.8s cast - 1500 range - 50 damage (Matter) - 7% power
Level 15 Lesser Winding Curse Enemy - 2.8s cast - 1500 range - 70 damage (Matter) - 7% power
Level 21 Winding Curse Enemy - 2.8s cast - 1500 range - 95 damage (Matter) - 7% power
Level 26 Lesser Wrenching Curse Enemy - 2.8s cast - 1500 range - 116 damage (Matter) - 7% power
Level 33 Wrenching Curse Enemy - 2.8s cast - 1500 range - 145 damage (Matter) - 7% power
Level 39 Lesser Warping Curse Enemy - 2.8s cast - 1500 range - 170 damage (Matter) - 7% power
Level 46 Warping Curse Enemy - 2.8s cast - 1500 range - 199 damage (Matter) - 7% power
 
 - Nearsight, Secondary
Level 12 - Unmake Perception - 12s duration - 1500 range - 20% vision (Matter)
Level 18 - Unmake Vision - 2min duration - 1500 range - -25% vision (Matter)
Level 29 - Unmake Seeing - 2min duration - 1500 range - -45% vision (Matter)
Level 40 - Unmake Sight - 2min duration - 1500 range - -65% vision (Matter)
 
 - Damage (PBAOE), Secondary
Level 6 - Spell Burst - 350 radius - 38 damage (Matter)
Level 16 - Spell Bombardment - 350 radius - 111 damage (Matter)
Level 25 - Spell Blast - 350 radius - 178 damage (Matter)
Level 31 - Spellbinder's Burst - 350 radius - 222 damage (Matter)
Level 38 - Spellbinder's Bombardment - 350 radius - 273 damage (Matter)
Level 45 - Spellbinder's Blast - 350 radius - 325 damage (Matter)
 
 - Primer (Range)
Level 1 - Enduring Range - 5s cast / 10s duration - 1750 range - 15% power
Level 11 - Expanded Range - 4.6s cast / 10s duration - 2000 range - 15% power
Level 22 - Extended Range - 4.1s cast / 10s duration - 2250 range - 15% power
Level 32 - Boundless Range - 3.7s cast / 10s duration - 2500 range - 15% power
Level 42 - Critical Range - 3.3s cast / 10s duration - 2750 range - 15% power
Level 49 - Perennial Range - 3s cast / 10s duration - 3000 range - 15% power
 
 - Chamber
Level 7 - Chamber of Destruction - 10s cast - No Bolts
Level 37 - Chamber of Decimation - 10s cast - No Bolts
 
 
Hexing Specialization:
 
 - Root (Bolt), Primary
Level 1 - Hexed Clutching Root - 3.2s cast / 8s duration / 20s recast - 1875 range - Root (Matter) - 5% power
Level 6 - Hexed Grasping Root - 3.2s cast / 20s duration / 20s recast - 1875 range - Root (Matter) - 5% power
Level 11 - Hexed Bonding Root - 3.2s cast / 25s duration / 20s recast - 1875 range - Root (Matter) - 5% power
Level 15 - Hexed Webbing Root - 3.2s cast / 30s duration / 20s recast - 1875 range - Root (Matter) - 5% power
Level 21 - Hexed Clutching Root - 3.2s cast / 35s duration / 20s recast - 1875 range - Root (Matter) - 5% power
Level 25 - Hexed Holding Root - 3.2s cast / 40s duration / 20s recast - 1875 range - Root (Matter) - 5% power
Level 31 - Hexed Tangling Root - 3.2s cast / 45s duration / 20s recast - 1875 range - Root (Matter) - 5% power
Level 37 - Hexed Tenacious Root - 3.2s cast / 56s duration / 20s recast - 1875 range - Root (Matter) - 5% power
Level 47 - Hexed Detaining Root - 3.2s cast / 74s duration / 20s recast - 1875 range - Root (Matter) - 5% power
 
 - Lifetap, Primary
Level 3 - Molding Hex - 4s cast - 1500 range - Bonus: 70% returned / 13 damage (Matter) - 3 power
Level 8 - Rotting Hex - 4s cast - 1500 range - Bonus: 70% returned / 32 damage (Matter) - 6 power
Level 14 - Dissolving Hex - 4s cast - 1500 range - Bonus: 70% returned / 55 damage (Matter) - 9 power
Level 20 - Decaying Hex - 4s cast - 1500 range - Bonus: 70% returned / 79 damage (Matter) - 13 power
Level 27 - Decomposing Hex - 4s cast - 1500 range - Bonus: 70% returned / 106 damage (Matter) - 17 power
Level 35 - Polluting Hex - 4s cast - 1500 range - Bonus: 80% returned / 136 damage (Matter) - 22 power
Level 43 - Corrupting Hex - 4s cast - 1500 range - Bonus: 80% returned / 167 damage (Matter) - 27 power
Level 50 - Putrifying Hex - 4s cast - 1500 range - Bonus: 90% returned / 194 damage (Matter) - 31 power
 
 - Matter Resistance Debuff - This is not a primary / secondary spell, and will be affected by Dexterity and Casting Speed bonuses.
Level 23 - Malevolent Affliction - 2s cast / 8s duration - 1500 range - 15% Matter Debuff - 6% Power
Level 34 - Malevolent Pestilence - 2s cast / 8s duration - 1500 range - 30% Matter Debuff - 6% Power
Level 45 - Malevolent Scourge - 2s cast / 8s duration - 1500 range - 50% Matter Debuff - 6% Power
 
 - DoT, Secondary
Level 5 - Infernal Sore - 16s duration - 1500 range - 9 damage / pulse (Matter)
Level 9 - Infernal Eruption - 16s duration - 1500 range - 15 damage / pulse (Matter)
Level 19 - Infernal Rot - 16s duration - 1500 range - 37 damage / pulse (Matter)
Level 30 - Infernal Degeneration - 16s duration - 1500 range - 55 damage / pulse (Matter)
Level 41 - Infernal Infection - 16s duration - 1500 range - 76 damage / pulse (Matter)
Level 46 - Infernal Erosion - 16s duration - 1500 range - 88 damage / pulse (Matter)
 
 - Snare, Secondary
Level 4 - Spell of Creeping - 10s duration - 1500 range - 40% snare (Matter)
Level 10 - Spell of Slowness - 15s duration - 1500 range - 40% snare (Matter)
Level 18 - Spell of Languoring - 20s duration - 1500 range - 40% snare (Matter)
Level 26 - Spell of Lumbering - 25s duration - 1500 range - 40% snare (Matter)
Level 33 - Spell of Sluggishness - 30s duration - 1500 range - 40% snare (Matter)
Level 44 - Spell of Crawling - 35s duration - 1500 range - 40% snare (Matter)
 
 - Primer (Uninterruptable)
Level 2 - Steady Cast - 3s cast / 10s duration - 40% of Damage Reduced - 35% power
Level 12 - Solid Cast - 3s cast / 10s duration - 35% of Damage Reduced - 30% power
Level 22 - Fixed Cast - 3s cast / 10s duration - 30% of Damage Reduced - 25% power
Level 29 - Fortified Cast - 3s cast / 10s duration - 25% of Damage Reduced - 20% power
Level 38 - Anchored Cast - 3s cast / 10s duration - 20% of Damage Reduced - 15% power
Level 48 - Unshakable Cast - 3s cast / 10s duration - 0% of Damage Reduced - 10% power
 
 - Chamber
Level 7 - Chamber of Lesser Fate - 10s cast - No Bolts
Level 37 - Chamber of Greater Fate - 10s cast - Any
 
 
Witchcraft Specialization:
 
 - Heal (Bolt), Primary
Level 4 - Lesser Bolt of Mending - 3.2s cast / 20s recast - 2250 range - 42 health - 9% power
Level 9 - Bolt of Mending - 3.2s cast / 20s recast - 2250 range - 126 health - 9% power
Level 15 - Lesser Bolt of Renewal - 3.2s cast / 20s recast - 2250 range - 225 health - 9% power
Level 21 - Bolt of Renewal - 3.2s cast / 20s recast - 2250 range - 325 health - 9% power
Level 29 - Lesser Bolt of Healing - 3.2s cast / 20s recast - 2250 range - 458 health - 9% power
Level 38 - Bolt of Healing - 3.2s cast / 20s recast - 2250 range - 610 health - 9% power
Level 46 - Greater Bolt of Healing - 3.2s cast / 20s recast - 2250 range - 747 health - 9% power
 
 - Heal, Primary
Level 1 - Spell of Minor Mending - 4s cast - 2000 range - 15 health - 6% power
Level 6 - Spell of Mending - 4s cast - 2000 range - 53 health - 6% power
Level 10 - Spell of Greater Mending - 4s cast - 2000 range - 99 health - 6% power
Level 12 - Spell of Minor Renewal - 4s cast - 2000 range - 121 health - 6% power
Level 18 - Spell of Renewal - 4s cast - 2000 range - 200 health - 6% power
Level 22 - Spell of Greater Renewal - 4s cast - 2000 range - 250 health - 6% power
Level 26 - Spell of Minor Healing - 4s cast - 2000 range - 305 health - 6% power
Level 35 - Spell of Healing - 4s cast - 2000 range - 415 health - 6% power
Level 42 - Spell of Greater Healing - 4s cast - 2000 range - 503 health - 6% power
 
 - Lifetap, Secondary
Level 2 - Lesser Beguiled Pain - 1500 range - Bonus: 30% returned / 10 damage (Matter)
Level 3 - Beguiled Pain - 1500 range - Bonus: 30% returned / 15 damage (Matter)
Level 8 - Greater Beguiled Pain - 1500 range - Bonus: 30% returned / 34 damage (Matter)
Level 13 - Lesser Beguiled Injury - 1500 range - Bonus: 30% returned / 56 damage (Matter)
Level 19 - Beguiled Injury - 1500 range - Bonus: 40% returned / 79 damage (Matter)
Level 24 - Greater Beguiled Injury - 1500 range - Bonus: 40% returned / 97 damage (Matter)
Level 33 - Lesser Beguiled Hex - 1500 range - Bonus: 50% returned / 131 damage (Matter)
Level 43 - Beguiled Hex - 1500 range - Bonus: 60% returned / 168 damage (Matter)
Level 49 - Greater Beguiled Hex - 1500 range - Bonus: 60% returned / 191 damage (Matter)
 
 - Power Regeneration, Secondary
Level 25 - Spell of Regeneration -  1min duration - 5 power/pulse
Level 48 - Spell of Power - 1min duration - 20 power/pulse
 
 - Spreadheal, Secondary
Level 31 - Charmed Gift of Health - 2000 range - 135 health
Level 39 - Charmed Boon of Health - 2000 range - 180 health
Level 47 - Charmed Favor of Health - 2000 range - 225 health
 
 - Primer (Powerless)
Level 5 - Pure Cast - 5s cast / 10s duration - 5 power
Level 17 - Fluent Cast - 4.3s cast / 10s duration - 17 power
Level 28 - Skillful Cast - 3.7s cast / 10s duration - 28 power
Level 36 - Artistic Cast - 3.3s cast / 10s duration - 41 power
Level 41 - Masterful Cast - 3s cast / 10s duration - 28 power
 
 - Chamber
Level 7 - Chamber of Restraint - 10s cast - No Bolts
Level 37 - Chamber of Creation - 10s cast - Any





I can't seem to find the druid change patch notes on herald though

[stephenxpimentel]

yep you must delve all. and link it to model/glow etc..

link it as in drag it into the chat to make it delve to group? i didn't know that got you the model/glow... i would think it would give u stats too wouldnt it?

[geshi]

Code: Select all


REPLACE INTO `Spell` (`Spell_ID`, `SpellID`, `ClientEffect`, `Icon`, `Name`, `Description`, `Target`, `Range`, `Power`, `CastTime`, `Damage`, `DamageType`, `Type`, `Duration`, `Frequency`, `Pulse`, `PulsePower`, `Radius`, `RecastDelay`, `ResurrectHealth`, `ResurrectMana`, `Value`, `Concentration`, `LifeDrainReturn`, `AmnesiaChance`, `Message1`, `Message2`, `Message3`, `Message4`, `InstrumentRequirement`, `SpellGroup`, `EffectGroup`, `SubSpellID`, `MoveCast`, `Uninterruptible`, `IsFocus`, `SharedTimerGroup`, `IsPrimary`, `IsSecondary`, `AllowBolt`, `PackageID`) VALUES ('bard-2nd-dd-43', '14924', '14924', '14924', 'Screeching Howl', '', 'Enemy', '1000', '26', '0', '139', '10', 'DirectDamage', '0', '0', '0', '0', '0', '15', '1', '0', '0', '0', '0', '0', '', '', '', '', '0', '1', '0', '0', '1', '1', '0', '0', '0', '0', '0', 'JoshSpells');

REPLACE INTO `linexspell` (`LineXSpell_ID`, `LineName`, `SpellID`, `Level`, `PackageID`) VALUES ('bard-2nd-dd-43','Bard Music Spec','14924','43','Josh');



REPLACE INTO `Spell` (`Spell_ID`, `SpellID`, `ClientEffect`, `Icon`, `Name`, `Description`, `Target`, `Range`, `Power`, `CastTime`, `Damage`, `DamageType`, `Type`, `Duration`, `Frequency`, `Pulse`, `PulsePower`, `Radius`, `RecastDelay`, `ResurrectHealth`, `ResurrectMana`, `Value`, `Concentration`, `LifeDrainReturn`, `AmnesiaChance`, `Message1`, `Message2`, `Message3`, `Message4`, `InstrumentRequirement`, `SpellGroup`, `EffectGroup`, `SubSpellID`, `MoveCast`, `Uninterruptible`, `IsFocus`, `SharedTimerGroup`, `IsPrimary`, `IsSecondary`, `AllowBolt`, `PackageID`) VALUES ('bard-2nd-dd-33', '14923', '14923', '14923', 'Screeching Scream', '', 'Enemy', '1000', '20', '0', '108', '10', 'DirectDamage', '0', '0', '0', '0', '0', '15', '1', '0', '0', '0', '0', '0', '', '', '', '', '0', '1', '0', '0', '1', '1', '0', '0', '0', '0', '0', 'JoshSpells');

REPLACE INTO `linexspell` (`LineXSpell_ID`, `LineName`, `SpellID`, `Level`, `PackageID`) VALUES ('bard-2nd-dd-33','Bard Music Spec','14923','33','Josh');



REPLACE INTO `Spell` (`Spell_ID`, `SpellID`, `ClientEffect`, `Icon`, `Name`, `Description`, `Target`, `Range`, `Power`, `CastTime`, `Damage`, `DamageType`, `Type`, `Duration`, `Frequency`, `Pulse`, `PulsePower`, `Radius`, `RecastDelay`, `ResurrectHealth`, `ResurrectMana`, `Value`, `Concentration`, `LifeDrainReturn`, `AmnesiaChance`, `Message1`, `Message2`, `Message3`, `Message4`, `InstrumentRequirement`, `SpellGroup`, `EffectGroup`, `SubSpellID`, `MoveCast`, `Uninterruptible`, `IsFocus`, `SharedTimerGroup`, `IsPrimary`, `IsSecondary`, `AllowBolt`, `PackageID`) VALUES ('bard-2nd-dd-24', '14922', '14922', '14922', 'Screeching Shout', '', 'Enemy', '1000', '15', '0', '79', '10', 'DirectDamage', '0', '0', '0', '0', '0', '15', '1', '0', '0', '0', '0', '0', '', '', '', '', '0', '1', '0', '0', '1', '1', '0', '0', '0', '0', '0', 'JoshSpells');

REPLACE `linexspell` (`LineXSpell_ID`, `LineName`, `SpellID`, `Level`, `PackageID`) VALUES ('bard-2nd-dd-24','Bard Music Spec','14922','24','Josh');



REPLACE INTO `Spell` (`Spell_ID`, `SpellID`, `ClientEffect`, `Icon`, `Name`, `Description`, `Target`, `Range`, `Power`, `CastTime`, `Damage`, `DamageType`, `Type`, `Duration`, `Frequency`, `Pulse`, `PulsePower`, `Radius`, `RecastDelay`, `ResurrectHealth`, `ResurrectMana`, `Value`, `Concentration`, `LifeDrainReturn`, `AmnesiaChance`, `Message1`, `Message2`, `Message3`, `Message4`, `InstrumentRequirement`, `SpellGroup`, `EffectGroup`, `SubSpellID`, `MoveCast`, `Uninterruptible`, `IsFocus`, `SharedTimerGroup`, `IsPrimary`, `IsSecondary`, `AllowBolt`, `PackageID`) VALUES ('bard-2nd-dd-16', '14921', '14921', '14921', 'Screeching Tone', '', 'Enemy', '1000', '10', '0', '54', '10', 'DirectDamage', '0', '0', '0', '0', '0', '15', '1', '0', '0', '0', '0', '0', '', '', '', '', '0', '1', '0', '0', '1', '1', '0', '0', '0', '0', '0', 'JoshSpells');

REPLACE INTO `linexspell` (`LineXSpell_ID`, `LineName`, `SpellID`, `Level`, `PackageID`) VALUES ('bard-2nd-dd-16','Bard Music Spec','14921','16','Josh');



REPLACE INTO `Spell` (`Spell_ID`, `SpellID`, `ClientEffect`, `Icon`, `Name`, `Description`, `Target`, `Range`, `Power`, `CastTime`, `Damage`, `DamageType`, `Type`, `Duration`, `Frequency`, `Pulse`, `PulsePower`, `Radius`, `RecastDelay`, `ResurrectHealth`, `ResurrectMana`, `Value`, `Concentration`, `LifeDrainReturn`, `AmnesiaChance`, `Message1`, `Message2`, `Message3`, `Message4`, `InstrumentRequirement`, `SpellGroup`, `EffectGroup`, `SubSpellID`, `MoveCast`, `Uninterruptible`, `IsFocus`, `SharedTimerGroup`, `IsPrimary`, `IsSecondary`, `AllowBolt`, `PackageID`) VALUES ('bard-2nd-dd-8', '14920', '14920', '14920', 'Screeching Note', '', 'Enemy', '1000', '6', '0', '29', '10', 'DirectDamage', '0', '0', '0', '0', '0', '15', '1', '0', '0', '0', '0', '0', '', '', '', '', '0', '1', '0', '0', '1', '1', '0', '0', '0', '0', '0', 'JoshSpells');

REPLACE INTO `linexspell` (`LineXSpell_ID`, `LineName`, `SpellID`, `Level`, `PackageID`) VALUES ('bard-2nd-dd-8','Bard Music Spec','14920','8','Josh');

Bard Second DD's