search

DarkAngel39 / ArcDB

Project ArcDB is a World of Warcraft database for version 3.3.5a that supports ArcEmu. It's based on WhyDB and LoeDB (thanks to them for their work). This database project like any other similar is not officially supported by the ArcEmu development staff and no help of any kind will be provided there regarding this database. The project is simply kept in sync with their core database structure.
5 stars 14 forks source link

[Quests] Borean Tundra { ALLIANCE } #1

Open arazi47 opened 9 years ago

arazi47 commented 9 years ago

This research has been done on WhyDB rev 158, I don't know if anything changed on ArcDB. Here is my list of ALLIANCE ONLY quests in Borean Tundra that are bugged: http://paste2.org/_jEz3szEU.

Note that only a few quests have notes in them about what to do. Also, some of the quests 10-20% need to be fixed within the core (they need to be scripted in C++/Lua), but most of them are DB work (spawning NPCs etc)

Zyres commented 9 years ago

What do you mean with "spawning NPCs etc"... are some spawns missing for the quest?

arazi47 commented 9 years ago

Yep. They're not spawned.

DarkAngel39 commented 9 years ago

All of these spawns are done by scripts, this is not a database issue. I will do some work on it when I get some free time (in the coming week or too). Maybe also tinker the Wintergrasp script a little and do some other stuff. But scripting all zones in lua is just ridiculous. I am not even sure that the core will be able to handle all of the lua stuff should such thing be done, let alone work properly. Arcemu needs better database scripting system that should include simple stuff like gossip quest scripts, using items on npc's, areatrigger spawning npc's and/or give quest credit, cast spell when crossed and so one. Something like the smart AI that Trinity Core uses. Along with database conditions for some more simple stuff. Lua is only good if you don't run too many scripts and even then they need to be as efficient as possible in order for the core to work with the proper speed and memory usage. This project was never intended to fully script ArcEmu. It is only database + world events and some basic lua scripting support (mainly for the events as they are time limited and is easier to disable scripts simply by deleting the script folder). If anyone wishes to script everything, I highly recommend that this should be done in C++.

Zyres commented 9 years ago

I would appreciate your feedback: https://github.com/AscEmu/AscEmu/ Currently the events are managed by core and we are working slowly on the open issues.

arazi47 commented 7 years ago

Started reworking on this? I'm working on ArcEmu MoP, wanna help with the DB? :D

schnek commented 4 months ago

@arazi47 we need help logging into the game (AscEmu/MoP) 😅