Actualización de OBDB2 rev203.
Descargar Aquí
Aquí abajo os pongo el listado de cambios de las revisiones por encima de la 150 (la más "oficial").
Revision: 203
Author: DarkRavenMixage
Date: 13:41:26, domingo, 05 de agosto de 2007
Message:
- Fixed Dislayid of two items (Robe of Hateful Echoes & Illidari Shoulderpads) by Whiroph
- Fixed Gameobject and Loots of Herbalism and Mining by Darkrabbit
----
Modified : /obdb_gameobject_names.sql
Modified : /obdb_gameobject_spawns.sql
Modified : /obdb_items.sql
Modified : /obdb_objectloot.sql
Revision: 202
Author: dr4g0nsr
Date: 13:25:41, domingo, 05 de agosto de 2007
Message:
Merged the object loots from the old table for entries that are missing from wowhead
----
Modified : /obdb_objectloot.sql
Revision: 201
Author: DarkRavenMixage
Date: 13:08:55, domingo, 05 de agosto de 2007
Message:
- Karazhan Bosses AI. Thx to Zion
----
Modified : /obdb_ai_agents.sql
Revision: 200
Author: dr4g0nsr
Date: 12:47:58, domingo, 05 de agosto de 2007
Message:
Corrected some infos and typos in readme.txt.
WHEEE!!!!
REV 200!!!
Great job OBDB2 team!
----
Modified : /readme.txt
Revision: 199
Author: dr4g0nsr
Date: 12:45:08, domingo, 05 de agosto de 2007
Message:
Spawned Chok'sul
Spawned Kalin Windflight
Despawned Flasktaur
Added a bunch of waypoints for loch modan and near zones
----
Modified : /obdb_creature_spawns.sql
Modified : /obdb_creature_waypoints.sql
Revision: 198
Author: DarkRavenMixage
Date: 11:36:10, domingo, 05 de agosto de 2007
Message:
- Fixed all BlackTemple bosses (drop money health mana level) thanks to Whiroph & Darkrabbit
- Fixed all Tempestkeep bosses (drop money health mana level) thanks Whiroph & Darkrabbit
- Added Correct Emote to all BG emissary thanks Whiroph
- Fixed starting languages of draenei thanks to Darkrabbit
- Fixed all characters start positions by Whiroph
----
Modified : /obdb_creature_proto.sql
Modified : /obdb_creature_spawns.sql
Modified : /obdb_creatureloot.sql
Modified : /obdb_playercreateinfo.sql
Modified : /obdb_playercreateinfo_skills.sql
Revision: 197
Author: gaara
Date: 7:11:10, domingo, 05 de agosto de 2007
Message:
-reverted 5X fragment drop
-added 2 sell templates for npc
-removed blood elf warrior from playercreateinfo(there is no BE warr)
----
Modified : /obdb_creatureloot.sql
Modified : /obdb_playercreateinfo.sql
Modified : /obdb_vendors.sql
Revision: 196
Author: dr4g0nsr
Date: 23:05:00, sábado, 04 de agosto de 2007
Message:
Removed all elevators from Undercity, seems they affect some races to have 0 mana
We will try to find a solution to this weird problem
----
Modified : /obdb_gameobject_staticspawns.sql
Revision: 195
Author: dr4g0nsr
Date: 22:44:54, sábado, 04 de agosto de 2007
Message:
Fixed the problem with staticspawns, now players mana is correct
----
Modified : /obdb_gameobject_staticspawns.sql
Revision: 194
Author: gaara
Date: 18:46:26, sábado, 04 de agosto de 2007
Message:
-removed Third Key Fragment item from mobs that shouldn't drop it
-made Fragment Guardian drop the key Fragment's 5X for every player in party.
-set Medivh npc flag to quest npc
----
Modified : /obdb_creature_proto.sql
Modified : /obdb_creatureloot.sql
Revision: 193
Author: Oboro
Date: 6:57:59, sábado, 04 de agosto de 2007
Message:
- Added more recall locations
----
Modified : /obdb_recall.sql
Revision: 192
Author: dr4g0nsr
Date: 2:00:58, sábado, 04 de agosto de 2007
Message:
Added http://www.wowhead.com/?npc=1059, and some waypoints for that area
Added forges to goldshire
----
Modified : /obdb_creature_spawns.sql
Modified : /obdb_creature_waypoints.sql
Modified : /obdb_gameobject_spawns.sql
Revision: 191
Author: gaara
Date: 21:53:50, viernes, 03 de agosto de 2007
Message:
-Deleted alot of spawn/dupes of unselecteble Npcs/mobs around ring of observence
-Removed Auchindoun: Shadow Labyrinth item requarments(not needs as long as door can be opened)
----
Modified : /obdb_creature_spawns.sql
Modified : /obdb_worldmap_info.sql
Revision: 190
Author: gaara
Date: 13:42:39, viernes, 03 de agosto de 2007
Message:
-updated http://www.wowhead.com/?npc=18255 flags/vendor template.
-added more GO static_spawns(elevators).
----
Modified : /obdb_creature_proto.sql
Modified : /obdb_gameobject_staticspawns.sql
Modified : /obdb_vendors.sql
Revision: 189
Author: DarkRavenMixage
Date: 3:05:21, viernes, 03 de agosto de 2007
Message:
- Added npc's and linked quests for Karazhan Attunement
----
Modified : /obdb_creature_spawns.sql
Modified : /obdb_quests.sql
Revision: 188
Author: dr4g0nsr
Date: 1:00:12, viernes, 03 de agosto de 2007
Message:
Fixed Azuregos casts, picked up the casts that are not bugged (which is alot of work)
Azuregos naw kicks ass ^^
----
Modified : /obdb_ai_agents.sql
Revision: 187
Author: dr4g0nsr
Date: 23:35:45, jueves, 02 de agosto de 2007
Message:
New objectloots, parsed from wowhead
----
Modified : /obdb_objectloot.sql
Revision: 186
Author: dr4g0nsr
Date: 23:29:16, jueves, 02 de agosto de 2007
Message:
Updated tool for parsing the varios data from wowhead and allakhazam
----
Modified : /other/tools/ripper-parser tool/Main.dcu
Modified : /other/tools/ripper-parser tool/Main.dfm
Modified : /other/tools/ripper-parser tool/Main.pas
Modified : /other/tools/ripper-parser tool/Main.~dfm
Modified : /other/tools/ripper-parser tool/Main.~pas
Modified : /other/tools/ripper-parser tool/allakhrhipp.exe
Modified : /other/tools/ripper-parser tool/wowhead_func.dcu
Modified : /other/tools/ripper-parser tool/wowhead_func.pas
Modified : /other/tools/ripper-parser tool/wowhead_func.~pas
Revision: 185
Author: Oboro
Date: 16:30:04, jueves, 02 de agosto de 2007
Message:
- Added `prospectingloot` table
----
Modified : /dbexport.bat
Modified : /dbimport.bat
Modified : /dbimport_unix.sh
Modified : /nix_dbimport.sh
Added : /obdb_prospectingloot.sql
Revision: 184
Author: gaara
Date: 15:58:01, jueves, 02 de agosto de 2007
Message:
-http://www.wowhead.com/?npc=16388 sell template added faction/flags change
-put karazhan door at right place
-deleted 2 fake items
----
Modified : /obdb_creature_proto.sql
Modified : /obdb_gameobject_spawns.sql
Modified : /obdb_items.sql
Modified : /obdb_vendors.sql
Revision: 183
Author: dr4g0nsr
Date: 10:51:12, jueves, 02 de agosto de 2007
Message:
Forum/Site fixes:
http://emupedia.com/community/showthread.php?t=10729&page=7
Fix from bugtracker:
http://emupedia.com/obdb/view.php?id=54
BIG THNX FOR ALL PPL THAT WORK HARD AND CONTRIBUTE FIXES!!!
----
Modified : /obdb_creature_names.sql
Modified : /obdb_creature_proto.sql
Modified : /obdb_creature_spawns.sql
Modified : /obdb_gameobject_quest_finisher.sql
Modified : /obdb_gameobject_quest_item_binding.sql
Modified : /obdb_gameobject_spawns.sql
Modified : /obdb_gameobject_staticspawns.sql
Modified : /obdb_objectloot.sql
Modified : /obdb_quests.sql
Modified : /obdb_spell_disable_trainers.sql
Modified : /obdb_vendors.sql
Revision: 182
Author: dr4g0nsr
Date: 2:07:26, jueves, 02 de agosto de 2007
Message:
Added some spells to Azuregos, need to test more
Bosses have been re-checked and their HP/damage is changed, some of them was elite or rare elites, not the bosses
----
Modified : /obdb_ai_agents.sql
Modified : /obdb_creature_proto.sql
Revision: 181
Author: dr4g0nsr
Date: 23:39:35, miércoles, 01 de agosto de 2007
Message:
Almost 2 times more item loots (4982 rows naw)
----
Modified : /obdb_itemloot.sql
Revision: 180
Author: dr4g0nsr
Date: 23:09:57, miércoles, 01 de agosto de 2007
Message:
Deleted all flame_breaths from bosses since they are bugged as hell and ppl abusing them to kill bosses
----
Modified : /obdb_ai_agents.sql
Revision: 179
Author: drstrange
Date: 22:51:38, miércoles, 01 de agosto de 2007
Message:
(MORE Fixes) Hunters lvl 10 Tame Quest - Alliance
----
Modified : /obdb_quests.sql
Revision: 178
Author: dr4g0nsr
Date: 22:02:09, miércoles, 01 de agosto de 2007
Message:
Removed Lord Kazzak (he don't exist anymore in TBC, and he's bugged)
Changed worldmap_info, added new stuff, fixed wrong locations, renamed some
----
Modified : /obdb_creature_spawns.sql
Modified : /obdb_worldmap_info.sql
Revision: 177
Author: Odin
Date: 2:19:21, miércoles, 01 de agosto de 2007
Message:
Deleted FunServer stuff OBDB is NOT a Funserver Database!
Maybe I will create some Funserver Stuff one day but currently I have better things to do...
----
Deleted : /sql/querys/Funserver Database
Revision: 176
Author: DarkRavenMixage
Date: 0:39:56, miércoles, 01 de agosto de 2007
Message:
- Removed a crappy private server item from our database
----
Modified : /obdb_items.sql
Revision: 175
Author: dr4g0nsr
Date: 0:00:48, miércoles, 01 de agosto de 2007
Message:
mana tombs npc spawns + object spawns + waypoints
----
Modified : /obdb_creature_spawns.sql
Modified : /obdb_creature_waypoints.sql
Modified : /obdb_gameobject_spawns.sql
Revision: 174
Author: DarkRavenMixage
Date: 23:30:10, martes, 31 de julio de 2007
Message:
- Fixed the melee damage that Karazhan Bosses deal.
----
Modified : /obdb_creature_proto.sql
Revision: 173
Author: DarkRavenMixage
Date: 15:18:20, martes, 31 de julio de 2007
Message:
- Part 1 of Boss HP and FLAG fixes by DarkRavenMixage and Kni
----
Modified : /obdb_creature_proto.sql
Revision: 172
Author: dr4g0nsr
Date: 14:48:00, martes, 31 de julio de 2007
Message:
Changed batch files, looks and works better naw, can be enhanced further
Added 2 new static tables mentioned in rev941
"+ Added static spawn support to MapMgr. This is for objects like the deeprun tram."
map.cpp [line 280]:
QueryResult * result = WorldDatabase.Query("SELECT * FROM creature_spawns WHERE Map = %u",this->_mapId);
[line 341]:
result = WorldDatabase.Query("SELECT * FROM gameobject_staticspawns WHERE Map = %u",this->_mapId);
----
Added : /dbexport.bat
Modified : /dbimport.bat
Deleted : /export_tables.bat
Added : /obdb_creature_staticspawns.sql
Added : /obdb_gameobject_staticspawns.sql
Revision: 171
Author: dr4g0nsr
Date: 11:57:29, martes, 31 de julio de 2007
Message:
Added GM script for Undercity-Silvermoon teleport
http://www.ascentemu.com/forums/index.php?showtopic=54
Added AI Agents for Hellfire Penisula
http://www.ascentemu.com/forums/index.php?showtopic=105
----
Modified : /obdb_ai_agents.sql
Added : /other/GM_Scripts/silvermoon_undercity_orb.gm
Revision: 170
Author: dr4g0nsr
Date: 1:44:54, martes, 31 de julio de 2007
Message:
Fixed a few npc with wrong faction (fighting each other)
Few forum fixes:
http://www.ascentemu.com/forums/index.php?showtopic=193
http://emupedia.com/community/showpost.php?p=97517&postcount=93
----
Modified : /obdb_creature_names.sql
Modified : /obdb_creature_proto.sql
Modified : /obdb_creature_spawns.sql
Modified : /obdb_gameobject_names.sql
Modified : /obdb_gameobject_spawns.sql
Modified : /obdb_objectloot.sql
Revision: 169
Author: dr4g0nsr
Date: 1:27:24, martes, 31 de julio de 2007
Message:
2 gm scripts for orbs
http://emupedia.com/obdb/view.php?id=6
----
Added : /other/GM_Scripts/falconwatch_orb.gm
Added : /other/GM_Scripts/firewing_point_orb.gm
Revision: 168
Author: drstrange
Date: 0:46:07, martes, 31 de julio de 2007
Message:
(sigh) MORE Tame Beast (Hunters Quest) fixes.
...just blackjack the damn things into submission!
----
Modified : /obdb_quests.sql
Revision: 167
Author: dr4g0nsr
Date: 22:21:47, lunes, 30 de julio de 2007
Message:
anrest update for ascent
----
Modified : /other/tools/anrest/Main.dcu
Modified : /other/tools/anrest/Main.dfm
Modified : /other/tools/anrest/Main.pas
Modified : /other/tools/anrest/Main.~dfm
Modified : /other/tools/anrest/Main.~pas
Modified : /other/tools/anrest/anrest.exe
Revision: 166
Author: Oboro
Date: 0:56:51, lunes, 30 de julio de 2007
Message:
- Fixed stats for all Outland Dungeon Bossee
- Fixez by Lore: bugtracker id`s: 0000035, 0000036, 0000037, 0000039, 0000040. Tnx mate
----
Modified : /obdb_creature_proto.sql
Modified : /obdb_creature_spawns.sql
Modified : /obdb_gameobject_names.sql
Modified : /obdb_gameobject_quest_item_binding.sql
Modified : /obdb_gameobject_spawns.sql
Modified : /obdb_quests.sql
Modified : /obdb_spells112.sql
Modified : /obdb_teleport_coords.sql
Revision: 165
Author: drstrange
Date: 23:13:58, domingo, 29 de julio de 2007
Message:
The hunter tame/train level 10 quest had each npc giving the same rod, however, each rod casts a unique spell to match
quest objective. Each NPC gives the appropriate rod now.
----
Modified : /obdb_quests.sql
Revision: 164
Author: dr4g0nsr
Date: 22:46:26, domingo, 29 de julio de 2007
Message:
Fixed missing spawns: Ranger Captain Venn'ren
Fixed multiple wrong npc factions, including "the eye of the storm" bm in stormwind keep
Fixed areatriggers and worldmap, deleted unneeded stuff and fixed repop so ppl won't find themself in the air
----
Modified : /obdb_areatriggers.sql
Modified : /obdb_creature_names.sql
Modified : /obdb_creature_proto.sql
Modified : /obdb_creature_spawns.sql
Modified : /obdb_worldmap_info.sql
Revision: 163
Author: Oboro
Date: 17:04:07, domingo, 29 de julio de 2007
Message:
- corrected quest finisher for quest 9676 http://www.wowhead.com/?quest=9676 (it should be Jesthenis)
- corrected required item for Firewing signets quest.
----
Modified : /obdb_creature_quest_finisher.sql
Modified : /obdb_quests.sql
Revision: 162
Author: dr4g0nsr
Date: 13:59:38, domingo, 29 de julio de 2007
Message:
Reverted the old names and proto until i solve the problem with mounts that are beign deleted on the last update with fake stuff
----
Modified : /obdb_creature_names.sql
Modified : /obdb_creature_proto.sql
Revision: 161
Author: Odin
Date: 7:34:12, domingo, 29 de julio de 2007
Message:
I should work more but I am currently very busy =/
Whatever that you see that I am willing to help here
some changes =)
----
Modified : /dbimport.bat
Modified : /dbimport_unix.sh
Modified : /export_accounts.bat
Modified : /export_tables.bat
Modified : /import_accounts.bat
Modified : /readme.txt
Revision: 160
Author: dr4g0nsr
Date: 2:14:29, domingo, 29 de julio de 2007
Message:
added spawns file (has a problems with conflicts)
----
Added : /obdb_creature_spawns.sql
Revision: 159
Author: dr4g0nsr
Date: 2:13:05, domingo, 29 de julio de 2007
Message:
Deleted 3.3k fakes from creatures, renormalize spawns and waypoints
----
Modified : /obdb_creature_names.sql
Modified : /obdb_creature_proto.sql
Deleted : /obdb_creature_spawns.sql
Modified : /obdb_creature_waypoints.sql
Added : /sql/querys/dupednames.sql
Revision: 158
Author: Oboro
Date: 0:45:13, domingo, 29 de julio de 2007
Message:
- removed portals
- removed fake illidan spawns
----
Modified : /obdb_creature_spawns.sql
Modified : /obdb_gameobject_spawns.sql
Revision: 157
Author: dr4g0nsr
Date: 20:28:36, sábado, 28 de julio de 2007
Message:
removed spell_disable table from batch file
----
Modified : /dbimport.bat
Revision: 156
Author: dr4g0nsr
Date: 19:45:34, sábado, 28 de julio de 2007
Message:
removed the file to correct location [drlotro!!!!!!]
----
Added : /obdb_trainerspelloverride.sql
Deleted : /sql/exports/obdb_trainerspelloverride.sql
Revision: 155
Author: Oboro
Date: 19:41:49, sábado, 28 de julio de 2007
Message:
New creatureloot table
- new loots added (about 25k),
- slightly increased drop rate for quest items,
- added heroic drops to common cuz antrix doesnt support heroic mods yet.
( dr4g0n is a ripper )
----
Modified : /obdb_creatureloot.sql
Revision: 154
Author: drstrange
Date: 18:40:58, sábado, 28 de julio de 2007
Message:
----
Modified : /dbimport.bat
Modified : /export_tables.bat
Modified : /obdb_spell_disable_trainers.sql
Added : /sql/exports/obdb_trainerspelloverride.sql
Revision: 153
Author: drstrange
Date: 18:40:05, sábado, 28 de julio de 2007
Message:
Exporting Error - Sorry
----
Deleted : /obdb_trainerspelloverride.sql
Revision: 152
Author: drstrange
Date: 15:25:52, sábado, 28 de julio de 2007
Message:
Tame Beast returns to trainers.
----
Modified : /obdb_trainerspelloverride.sql
Revision: 151
Author: dr4g0nsr
Date: 1:07:10, sábado, 28 de julio de 2007
Message:
more trainers added, this time alchemy and enchanter ones, changed talktext - it was too long, levels also set up
----
Modified : /obdb_trainers.sql
Added : /sql/querys/update trainers from other tables.sql
Revision: 150
Author: dr4g0nsr
Date: 22:41:43, viernes, 27 de julio de 2007
Message:
Fixed 4 enchanters, trainers table needs a more global fix to add all missing stuff
----
Modified : /obdb_trainers.sql
Actualizaciones de Ascent:
Ascent rev1020 (czark):
Descargar Aquí
Ascent rev1021 (czark):
Descargar Aquí
Ascent rev1017 modded (xkiller):
Descargar Aquí
Yo estoy usando la revision 1017 modded de Ascent y parece estable. Además está parcheado para el problema del clima (niebla, niebla y más niebla...) además de para otro par de problemas.
La rev1021 acaba de salir hace unos minutos y aún no he podido probarla, aunque puede que no lo haga hasta que salga alguna con el fix del clima.
La OBDB2 rev203 se ha modificado de forma que no hace falta eliminar la tabla que indiqué hace unos post (gameobject_staticspawn). También se ha solucionado lo de la recolección de hierbas que ya te da plantas.
Por desgracia he podido comprobar que el deeprun se ha vuelto a fastidiar y algunas veces te tira del tren si te mueves en marcha y también te acaba soltando en el mar a mitad de trayecto (creo que cerca de auberdine).
Ahora una pregunta. Tengo un chaman, draenei, lvl11. Tiene botánica y la estoy subiendo y tengo 51 de habilidad... resulta que los trainers de herbalism no me dejan aprender oficial. ¿Alguien conoce la solucion?
Ah, por cierto, si queréis seguir cocinando en cualquier parte hay que aplicar el fix que puse hace unos post para los campfires, cozy fires y demás (a partir de ahora el campfirefix).