Ascent [DataBase][Releases] everytime update with changelog

[mgX^]

its all ripoffs of NCDB anyways....

 

[Team_NOVA]

Can someone make yelly db in only 1 script to import into database ... It's really annoying to import one by one all the scripts .. or just tell me which table will fix my spirit healer pls I need the answer fast

 

[DjAligator]

use yelly it has spirit healer

 

[Team_NOVA]

But can you tell me how to get the whole database extracted it will be really annoying to get one by one all the tables ! Or which table will fix the spirit healer is it the Graveyard table ?!

 

[DjAligator]

In HyntDB7
Message:
Fix spells in warlock provided items thks to EmThirtyTwo.
Fix Talking bug
Fix GO names Summon Circle.
----
Modified : /Development/tables_world/creature_proto.sql
Modified : /Development/tables_world/gameobject_names.sql
Modified : /Development/tables_world/items.sql

 

[Dubsta]

What one of those download links contains the WarpNPC compiler?

 

[MaxGGR]

Well I tried jellydb but in open ascent says creatures_timed_emotes doesnt exists.
I dont think Its a big problem but... jelly is in 99 and ABD is in 273 what should I do?
-jelly doesnt has cte
-ABD too buggy with OpenAscent
-WhyDB well known by its loots problems.

I think they should join to make a good team (as it was NCDB now on private XD)

 

[DjAligator]

i use Yelly with Wemu work very good

 

[Gonzo9014]

Please i beg you.

Can you please do one world and one character sql file that i can load.

 

[DjAligator]

In WhyDB97
Message:
- Removed spell effect from the portal to Isle of Quel'Danas, let the external scripts handle that.
- More wretched fiends and wretched dev spawned
- Some more frenzied ghouls and skeletal ravagers and other deathscar mobs
- Wrath Enforcer are Evil and Pit Overlord again
- Gives skeletal ravager en frenzied ghoul some more space
- Items price fixes tnx to MUSICODC for his select query
- Some Creature HP fixes tnx to MUSICODC for his select query
- Some Creature DMG fixes tnx to MUSICODC for his select query
- More instance (Magisters) spawns tnx to psyco, thank you

So, now gonna trigger on the 'quest exploits' and further damage fixes.
----
Modified : /development/ascent_world/creature_names.sql
Modified : /development/ascent_world/creature_proto.sql
Modified : /development/ascent_world/creature_spawns.sql
Modified : /development/ascent_world/gameobject_names.sql
Modified : /development/ascent_world/gameobject_spawns.sql
Modified : /development/ascent_world/items.sql
Modified : /development/ascent_world/quests.sql
Added : /development/updates/changeset_19.sql

 

[DjAligator]

In ArDB50

DB Updates. YEA!
----
Modified : /ardb/Development/tables_world/creature_names.sql
Modified : /ardb/Development/tables_world/creature_proto.sql
Modified : /ardb/Development/tables_world/creature_spawns.sql
Modified : /ardb/Development/tables_world/gameobject_names.sql
Modified : /ardb/Development/tables_world/gameobject_spawns.sql
Modified : /ardb/Development/tables_world/items.sql
Modified : /ardb/Development/tables_world/quests.sql

 

[KalManiac]

does yelly use 1 database as in only world? no character? cuz when i extract, it extract everything including the character table to my world tables, and need a tut on yelly pls

 

[DjAligator]

In WhyDB106
Message:
-Corrected some factions
-Some creature armor fixes
-Localized Names fixes
-Added 2 new items and updated some items
-More creature spawn en waypoints work
-professiondiscoveries tnx to the OpenAscent team
-Corrected some displayids and some visuals.
And applyed changeset_20 ^.^
----
Modified : /HOWTOCOMMIT!.txt
Modified : /development/ascent_world/creature_names.sql
Modified : /development/ascent_world/creature_names_localized.sql
Modified : /development/ascent_world/creature_proto.sql
Modified : /development/ascent_world/creature_spawns.sql
Modified : /development/ascent_world/creature_waypoints.sql
Modified : /development/ascent_world/itempages_localized.sql
Modified : /development/ascent_world/items.sql
Modified : /development/ascent_world/professiondiscoveries.sql
Modified : /development/ascent_world/spell_coef_override.sql
Modified : /development/updates/changeset_20.sql

 

[DjAligator]

In HyntDB10
Message:
Fix Sunwell trash mobs.
Add spawn Felmyst, Lady Sacrolash ,Grand Warlock Alythess, M'uru.
Fix M'uru's summons.
----
Modified : /Development/tables_world/creature_proto.sql
Modified : /Development/tables_world/creature_spawns.sql

 

[tajudin]

First of all, i wanna thank you alligator for your work keeping this updated.

I always look forward for your uploads in DB and emulator too. And i would like to give mi opinion on those DB posted( sorry if my english is wrong, hope u might understand it at least).

ABDB-> I am using this, but a " fixed" one i found dont remember where, i have tried the 272 and all those versions, and they are really such a mess. A lot of mobs with the wrong flags, profesions, angels dont work ..., i really dont recommend it.

Yelly-> One of the best i have seen so far, in which refers to spells, the mobs heal themselves, and that Stuff, BUT ! , i think it isnt made for blizzlike servers, mobs are TOO HARD for normal players, With 80+ mobs in instanes, and tons of them. Please if there is a blizzlike release of these, i 'd love to try it. note: You can revive, but there is no angels.

Now i am gonna try WhyDB and post here my opinions too, if dont mind to.

I have also tried to " mix" few of those DB to get a blizzlike with yelly spells, but got many wrong displays so its not a good idea.

Please continue your workd keeping this updated, i d really apreciate it.

edit: i tryed whyDB and its really similar to ADB, no reputation on kill and that stuff, does anyone know one with those fixes ? thanks.

See U !

 

[DjAligator]

In WhyDB119
Message:
Updated some missing protos 23600.23601 23567

deleted 46 FAKE parsed items, adjusted Quest 1269

We need to exchange the partial Changesets more!!!!

Made A full copy of my own items table i saw on the UDS server missing entries.

Adjusted developers team, all Non Committers out. They Had Time enough now!
----
Modified : /development/Developers.txt
Modified : /development/ascent_world/creature_proto.sql
Modified : /development/ascent_world/disenchantingloot.sql
Modified : /development/ascent_world/items.sql
Modified : /development/ascent_world/quests.sql
Deleted : /development/updates/CORE/Moonscript_bin.rar
Deleted : /development/updates/CORE/Release193.rar
Added : /development/updates/changeset_21.sql

 

[DjAligator]

In WhyDB120
Message:
Applied Fix to moonplusplus_full.sql
Worgs in Silverpine Forest really should not have stats of Prince Malchezaar Axes
And example should be valid, or commented out...



If Ure using Open Ascent revision 256++ Please Apply the Updates in the IMPORTANT OA REV256++ folder
BEWARE!!! U also have to do U're world config file becasue of some nice additions made in it...
----
Added : /IMPORTANT OA REV256++
Added : /IMPORTANT OA REV256++/256_creature_proto.sql
Added : /IMPORTANT OA REV256++/258_creature_proto.sql
Added : /IMPORTANT OA REV256++/Please Apply these Updates when running Newer rev of OPEN ASCENT
Added : /IMPORTANT OA REV256++/ascent-world.conf
Modified : /development/ascent_world/moonplusplus_full.sql

 

[khyle650]

these can raise the whydb120 by

You must be registered to see links

thanks great contribution

 

[DjAligator]

qsave is shutdown
that i don't upload there

 

[DjAligator]

In HyntDB12
Date: 3:43:00 PM, Sunday, June 01, 2008
Message:
Fix model Felmyst
Fix Felmyst spawn faction.
----
Modified : /Development/tables_world/creature_names.sql
Modified : /Development/tables_world/creature_proto.sql
Modified : /Development/tables_world/creature_spawns.sql

In HyntDB13
Message:
Fix Brutallus spawn faction.
----
Modified : /Development/tables_world/creature_spawns.sql


In WhyDB122
Message:
- Applied 258_creature_proto.sql and 256_creature_proto.sql, we fully support OpenAscent
- Items - Container Key Fixes tnx to Laser.
- Creature - Removes Double spawns.
- Quests - Corrected some minlevels.
- Quests - Fixes a RequiredMoney Quest.
- Creature - Flag of quest giver.
- Localized - Sets to utf8 on request of MUSICODC
- Items - New items tnx to psyco.
- Creature - Proto corrections tnx to psyco.
----
Modified : /development/ascent_world/creature_names_localized.sql
Modified : /development/ascent_world/creature_proto.sql
Modified : /development/ascent_world/creature_spawns.sql
Modified : /development/ascent_world/gameobject_names_localized.sql
Modified : /development/ascent_world/items.sql
Modified : /development/ascent_world/items_localized.sql
Modified : /development/ascent_world/npc_text_localized.sql
Modified : /development/ascent_world/quests.sql
Modified : /development/ascent_world/quests_localized.sql
Modified : /development/psycos-stuff/UPDATE instance 2.sql
Added : /development/updates/changeset 11-20.rar
Deleted : /development/updates/changeset_11.sql
Deleted : /development/updates/changeset_12.sql
Deleted : /development/updates/changeset_13.sql
Deleted : /development/updates/changeset_14.sql
Deleted : /development/updates/changeset_15.sql
Deleted : /development/updates/changeset_16.sql
Deleted : /development/updates/changeset_17.sql
Deleted : /development/updates/changeset_18.sql
Deleted : /development/updates/changeset_19.sql
Deleted : /development/updates/changeset_20.sql
Modified : /development/updates/changeset_21.sql
Added : /development/updates/changeset_22.sql

In WhyDB123
Message:
Deleted these Wrong Spawns in Shattrath

/*Creature Spawns Smokywood pastures*/
/*GameObject Xmas Gifts*/
/*GameObject Smokywood Pastures*/

added them to changeset_21.sql
----
Modified : /development/ascent_world/creature_spawns.sql
Modified : /development/ascent_world/gameobject_spawns.sql
Modified : /development/updates/changeset_21.sql