oregoncore/aowow

Web-based Database Viewer for OregonCore 2.4.3

Welcome to OregonCore!

OregonCore is a piece of software that targets emulation of a World of Warcraft: The Burning Crusade game server. Our goal is to create a stable MMO framework and to help teach and learn development among our community. OregonCore has sustained itself with its tight knit community of developers, testers and bug reporters and thanks all those who have been involved with the project over the years.

Build Status

Compiler	Platform	Branch	Status
clang	Linux x64	master
MSVC++ 2015	Windows x64	master

Docs, Community and Support

Development went ahead and documentation was left behind. Although we try to keep stuff documented, there's a lot to do. Here's what we've saved from old wiki and our growing new official documentation here.

Next place is our Discord, you can get support there as well as be a part of our growing community. We have also a forum, this is a place for developers to hang out and discuss all things.

If you have found a bug you may report it on our bugtracker, issues must include revision hash and as many details as possible to aide us in resolving it as quickly as possible.

aowow's Issues

Error when creature uses smartai

i think its because of the abilities that it must show.

but when you select a creature with smartai script attached to it.
the following error occurs:

SQL Error: Unknown column 'entryorguid' in 'where clause' at /var/www/AoWoW/npc.php line 109
Array
(
[code] => 1054
[message] => Unknown column 'entryorguid' in 'where clause'
[query] => SELECT action1_param1 FROM creature_ai_scripts WHERE entryorguid=117 AND action1_type=11
[context] => /var/www/AoWoW/npc.php line 109
)

AoWoW Code Design

AoWoW is quite an old project that was started around when there was popular php 4 and new version php 5 was yet to come. All were learning and thats perfectly fine but from the long-distance view the code is a little mess - is not fine designed. It's not fully compattible with todays software since it stayed behind and also to change a something you have to wander to many places in code.

Creating a custom design from scratch would be a pain in ass. There's already is an awesome, popular and highly-deployed MVC (Model-View-Controller) design. There are lots of mvc php frameworks that could serve this purpose - to be used as fundamental core AoWoW can be built upon just like OregonCore is built upon ACE.

I would not like to choose by myself only. I want to you to help us discuss this issue and to choose the right framwork that will fit best AoWoW.

Broken under php 7

AoWoW is not currently working with php version 7.
Probably because of DbSimple that is currently used. It relies on old mysql_ functions that were deprecated and removed in php 7.

Solution could be using quite compatible mysqli_ functions instead or switching to another db interface.

sql error when clicking on a gem

when you click on a gem you get the follwoing error

SQL Error: Table 'oregon_world.aowow_gemproperties' doesn't exist at /var/www/AoWoW/includes/allitems.php line 309
Array
(
[code] => 1146
[message] => Table 'oregon_world.aowow_gemproperties' doesn't exist
[query] => SELECT aowow_itemenchantmet.text from aowow_itemenchantmet, aowow_gemproperties WHERE (aowow_gemproperties.gempropertiesID=142 and aowow_itemenchantmet.itemenchantmetID=aowow_gemproperties.itemenchantmetID)
[context] => /var/www/AoWoW/includes/allitems.php line 309
)

You can not see drop ffrom bosses with reference_loot_template

You can not see drop ffrom bosses with reference_loot_template

For Example Al'ar
reference loot 34052

Fatal error: Call to undefined function mass_define() in

Revision: 0e67a63

when you want to search for something.

Fatal error: Call to undefined function mass_define() in /var/www/AoWoW/includes/alllocales.php on line 374

seems something went wrong with rewriting alllocales

Searhing for item gives sql error

when you search for an item, you get following error

SQL Error: Unknown column 'faction_A' in 'where clause' at /var/www/AoWoW/search.php line 107 Array ( [code] => 1054 [message] => Unknown column 'faction_A' in 'where clause' [query] => SELECTname,subname,minlevel,maxlevel,type,rank,A,H`, c.entry

    FROM aowow_factiontemplate, creature_template c

    WHERE
        (name LIKE '%sword%'
        OR subname LIKE '%sword%'
        )
        AND factiontemplateID=faction_A

[context] => /var/www/AoWoW/search.php line 107

)

there are tons more, basically every table thats different in the code then OC will have these kinds of errors. :p`

Neutral npcs with drops are not shown

There is a funny thing i just noticed...

take for example Kobold vermin
the npc is stated as neutral ( yellow A and H )
when you click on it you dont see the drops of that npc.

i noticed that that is with every "neutral" mob there is ( the one i tested lol )
quests are shown, so thats fine, but it doesnt show what it drops.

Anyone alive?

so.... write who is alive

SQL Error: Undeclared variable: DBSIMPLE_ERROR_NO_VALUE

when i want start section - objects

SQL Error: Undeclared variable: DBSIMPLE_ERROR_NO_VALUE at ...\www\AoWoW\objects.php line 47

sql error when writing comment

i have added all sql and when you write a comment.. you get the following error.

SQL Error: Unknown column 'gmlevel' in 'field list' at /var/www/AoWoW/includes/allcomments.php line 24
Array
(
[code] => 1054
[message] => Unknown column 'gmlevel' in 'field list'
[query] => SELECT username as user, gmlevel as roles FROM account WHERE id='150' LIMIT 1
[context] => /var/www/AoWoW/includes/allcomments.php line 24
)