Jump to content

Search the Community

Showing results for tags 'database'.

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Categories

  • Mangos Zero
    • Enhancement Requests (Zero)
    • Tasks (Zero)
  • Mangos One
    • Enhancement Requests (One)
    • Tasks (One)
  • Mangos Two
    • Enhancement Requests (Two)
    • Tasks (Two)
  • Mangos Three
    • Enhancement Requests (Three}
    • Tasks (Three)
  • Mangos Four
    • Enhancement Requests (Four)
    • Tasks (Four)
  • Mangos Five
    • Enhancement Requests (Five)
    • Tasks (Five)
  • Cross-Core
    • Bugs
    • Enhancement Requests
    • Tasks
    • Sub-Modules
    • Eluna
    • Linux
    • Windows
    • Archived Cross-Core/Other Reports
  • Others
    • Mangos VB
    • Mangos Sharp
    • Third Party Software
    • Website
  • Bug Tracker Archives (Resolved issues)
    • Archived Reports (Zero)(Resolved issues)
    • Archived Tasks (Zero)(Resolved issues)
    • Archived Reports (One)(Resolved issues)
    • Archived Tasks (One)(Resolved issues)
    • Archived Reports (Two)(Resolved issues)
    • Archived Tasks (Two)(Resolved issues)
    • Archived Reports (Three)(Resolved issues)
    • Archived Reports (Five)(Resolved issues)

Categories

  • Development Roadmap
  • Documentation
    • Installation Guides
    • Playerbot AI
    • Standards And Practices
  • Tutorials
    • Advanced
    • Contributing to Mangos
    • Debugging
  • Reference Information
    • ClientFiles
    • Database Info
    • DBC Files
    • Other
    • Packet Info
    • Server Files
    • Server Components

Forums

  • MaNGOS Information
    • Announcements & Releases
    • Covenant-WoW.com Website - Official Mangos Test Servers
  • Community Discussion Areas
    • Introduce Yourself
    • Community Cafe
    • Community Input
    • Community Projects
    • MaNGOS University
  • Community Help and Support
    • Peer to Peer Technical Support
    • Frequently Asked Questions
    • Resources
  • Development & Patch Submissions
    • Development
    • Patch Submissions
  • Eluna LUA Engine
    • Eluna Central
  • International Help & Support
    • International Boards
  • Archived
    • Main Archives
    • Archive of Pre-2012 Forum

Product Groups

There are no results to display.

Categories

  • Mangos Zero
  • Mangos One
  • Mangos Two
  • Mangos Three
  • Addons
    • Classic Addons
  • World Of Warcraft Patches
    • WoW Patches
    • The Burning Crusade Patches
    • Wrath of the Lich King
    • Client Tools Patchers

Blogs

  • getMaNGOS
  • DBC handling for mangos
  • The Road to Zero Release 21
  • Necrovoice's development blog.
  • What the Heck happened to Antz and MaNGOS in 2018 !!
  • Other Wow Emu Projects

Find results in...

Find results that contain...


Date Created

  • Start

    End


Last Updated

  • Start

    End


Filter by number of...

Joined

  • Start

    End


Group


Core


Skype


Discord


Website URL


AIM


ICQ


Yahoo


Jabber


About Me


Gender


Location


Interests

Found 19 results

  1. The quest "Root Samples" (Quest ID 866) activates the collection of "Root Sample" (Item ID 5056) from specific game objects introduced just for this quest. Right now within the database of Zero, One and Two this is set to the loot templates of the standard rather than the specific game objects. (e.g. game objects Silverleaf ID 1617 vs. Silverleaf ID 3725) Since the game objects are placed within the Barrens correctly, this can easily be fixed by removing the item from the currect gameobject_loot_templates and adding it to the loot templates of the quest specific game objects: -- Remove wrong loot template associations (gameobjects not in Barrens) DELETE FROM `gameobject_loot_template` WHERE `item` = 5056; -- Add new loot template associations for Barrens gameobjects INSERT INTO `gameobject_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `condition_id`) VALUES (2511, 5056, -40, 0, 1, 1, 0), (2512, 5056, -40, 0, 1, 1, 0), (2513, 5056, -40, 0, 1, 1, 0), (2514, 5056, -40, 0, 1, 1, 0), (2515, 5056, -40, 0, 1, 1, 0), (2516, 5056, -40, 0, 1, 1, 0); If deleting everything with Item ID 5056 is too drastic, you might want to add the entries 1414, 1416, 1417 and 1418 to the WHERE-clause, but IMHO the item shouldn't appear anywhere else, so wiping all entries would be the clean solution. This might be pretty similar for Three, but since I don't do Three, I can't tell.
  2. On updating character2 table to version 22.1.1, faced a trouble with adding Rel21_04_001_update_deprecated_ROW_FORMAT.sql into db. It reports that MySQL can't complete a request "ALTER TABLE groups ROW_FORMAT=DYNAMIC ENGINE=INNODB;" After a search in a Google, I found that there is a kind of troubles with dynamic row format in InnoDB in MySQL 8 (v 8.0.22), and solved a problem by simple removing this string from update file (i.e., row format for this table leaved unchanged, i.e., MyISAM). All other fields changed correctly. Now all works fine, but just reporting to you about this trouble.
  3. Hello! In Mangos Two (v.21.11.49, db v.21.12.55, WoW 3.3.5 EN), I found a strange bug. On some maps there is almost no mineral veins or herbs (for herbalism). For example, if I trying to find tin ore, there is no this type ore in Hillsbrad Foothills (where must be alot of it according to maps from WowHead). Same thing is for herbs. How this can be fixed?
  4. There are two missing texts in the Earth Sapta (Quest ID 1462 and 1463) quest for Zero, One and Two: UPDATE `quest_template` SET `OfferRewardText`='Take this and remember, it is sacred.' WHERE `entry`=1462; UPDATE `quest_template` SET `OfferRewardText`='I give you one in good faith. You already proved yourself once, but me tinkin\' you should be more careful in the future.' WHERE `entry`=1463; Might have to update locales_quest / MAGNET translations accordingly.
  5. There is a wrong `RequestItemsText` within the quest data of Fire Sapta (Quest ID 1464): UPDATE `quest_template` SET `RequestItemsText`=NULL WHERE `entry`=1464; This text is already correctly set within the `Objectives`.
  6. I have successfully cloned, built, installed the mangostwo project and extracted all of the map data (I think). However, I am hitting a snag on the DB setup. I am using this guide: I've installed mysql-server with sudo apt install mysql-server Then I switched to root and loaded up mysql to do this command (which, BTW, "privileges" is misspelled in the guide: CREATE USER 'mangos'@'localhost' IDENTIFIED BY 'mangos'; GRANT ALL PRIVILEGES ON *.* TO 'mangos'@'localhost' WITH GRANT OPTION; I exited, and did cd /home/mangos/db/ git clone https://github.com/mangoszero/database.git . --recursive --depth=1 ./InstallDatabases.sh (in the guide, the pictures are dead links, so I can't see what Database options to use, but I did mysql host name = localhost, mysql user name = mangos, mysql port = 3306, then I typed in my mangos linux user's password (which I also manually set the mangos mysql user's password to). Then I did all of the default database names. Then, I get a big string of these errors: Importing file World/Setup/FullDB/spell_learn_spell.sql ERROR 1045 (28000): Access denied for user 'mangos'@'localhost' (using password: YES) File World/Setup/FullDB/spell_learn_spell.sql imported Importing file World/Setup/FullDB/spell_loot_template.sql ERROR 1045 (28000): Access denied for user 'mangos'@'localhost' (using password: YES) File World/Setup/FullDB/spell_loot_template.sql imported I looked at the InstallDatabases.sh script, and I feel like there is an issue. printBanner printf "What is your MySQL host name ?\t[${svr_def}]: " read svr svr=${svr:-${svr_def}} printf "What is your MySQL user name ?\t[${user_def}]: " read user user=${user:-${user_def}} printf "What is your MySQL port ?\t[${port_def}]: " read port port=${port:-${port_def}} printf "What is your MySQL password ?\t [], " mysql_config_editor set --login-path=local --host=${svr} --port=${port} --user=${user} --password --skip-warn if [ "${DUMP}" = "YES" ]; then printf "Enter it again \t[]: " read pass fi Here is the prompt for password. 1) It looks like the script doesn't even store the password in a variable. And 2) mysql_config_editor DEFINITELY prompts the user for a password if you use the --password flag like that. So... I feel like I'm totally missing something. Thoughts?
  7. Please make mangos run on updated versions of MySQL and MARIA as it is getting harder to obtain the older versions for 64-bit
  8. Hi!Few weeks ago has been created a project: http://www.wowgaming.orgIt's a WoW resource pool (Db search, wiki, addons etc) subdivided by expansion that currently support wotlk 3.3.5aAll information inside are stored with original data from that specific game version.It's totally Free and Open Source alternative to (dead?) OpenWoW site!Please read this page to understand why and how we can do it.This project can be helpful for:- Wiki and Database search engine for educational Open Source application server projects, such as AzerothCore/TrinityCore/Mangos etc.- Keeping an historical archive of World of Warcraft original data- Discussing and Blogging about newest and oldest WoW Facts wotlk portal (index of all subsite below): http://www.wowgaming.org/wotlk.htmldatabase: https://wowgaming.altervista.org/aowow/addon list: http://www.wowgaming.org/addons-335a-collection/wiki: https://wowgaming.altervista.org/wp/wotlk-home/ Our repositories: https://github.com/wowgame If you want to help us or maintaining another version using our free toolsPlease, Contact us on Discord
  9. Hi. Long time lurker first time poster. I have successfully installed and run a MaNGOS Zero server on my home Ubuntu server now for just about half a year. I see there are beeing updates pushed quite often on the site but I cant find any information on how I update my installation to the latest build. Is there any documentation on how to update an existing Mangos Zero install to the latest build of Mangos Zero? I would appreciate any help
  10. Hello Does someone have a db query or anything where you can fake /who command and show people players online? Thank you
  11. The database table "spell_linked" was introduced as incremental update with Rel21_08_001. With the commit "Updated to expect Rel21_08_012_Commands_update" it was then moved to the base updates. At this point it is meant to be part of the base database (full database), but it is not. If you set up a fresh database today, you're base database will be 21_08_012 (according to db_version table), which is newer and therefore prevents reapplying the incremental update 21_08_001. The table creation for "spell_linked" is missing in the mangosdLoadDB.sql script as well as the corresponding content script inside the FullDB folder. I've checked Rel21_07_019 through Rel21_08_011 to double check if another script is missing. Seems fine. Maybe prior incremental scripts are missing as well?
  12. Hello everyone I wanted to give an update on my most recent working within the Dragonblight before I go away on my much needed vacation. My most recent endeavour to correct the spawn locations of the many Arctic Hare has been a very slow and daunting one. What started in the Dragonblight spilled into the Borean Tundra and Zul'Drak. But I am happy to say that this portion is about 75% complete. In addition to the ever troublesome dust bunn..I mean Arctic Hare, I have poked around with three other things * Smoldering Skeletons now properly display their aura and have had their cosmetic aura added. * Golluck Rockfist of Wyrmrest Temple now has a patrol path * Add Missing Wyrmrest Protector as well as removed a few that should not be there I hope you all enjoyed the update and I will see you all next week
  13. Although it has only been one day from my opening post, I have been working on the Arctic grizzly and Arctic cubs for about two weeks now. I am happy to say 647 waypoints with a total of 776 lines later, they now are working correctly. (As of this writing they still require some scripting) The Arctic Grizzly and cubs now have the following corrections Spawn locations. Way-points. Spawn Locations. Linking - slave/master/flags. 21 duplicates removed between the two. (Moved)
  14. Hello everyone, I thought the work I have been doing on Dragonblight would be a great opportunity to start my first blog. This is the largest and most complex undertaking I have ever taken on here at MaNGOS and wanted you all to be a part of its progress. As a side note and something I would like every reader to keep in mind is that the when I speak of "progress" or "percent completed" it is based on the personal end goals I set for myself when the thought of doing an overhaul on the zone first came to be. So sit back and enjoy some cake. Base Project Outline (In no particular order) 1) Waypoints 1-1) Add missing waypoints 1-2) Update current Waypoints 1-3) Remove incorrect/unused waypoints 2) NPC spawns 2-1) Add missing NPCs 2-2) Remove duplicate NPCs 3) NPC linking 4) Scripting 4-1) db_scripts 4-2) AI_scripts 4-3) Potential for SD3 / Eluna 5) Quests 6) NPC updates 6-1) Faction Updates 6-2) Gossip 6-3) Flags 6-3-1) NpcFlags 6-3-2) UnitFlags 6-3-3) DynamicFlags 6-3-4) ExtraFlags 6-4) miscellaneous Attribute updates 7) Npc cosmetic tweaks 8) Game Objects 8) Data cleanup and submission
  15. Is there some sort of procedure to follow when it comes to updating / using a new version of the Mangos Zero Server? How can I retain all of my DB info / not loose character progress? I apologize if this question has been answered elsewhere..the amount of content on this site is huge and I didn't find anything Also I'm still very new to mangos, so hopefully this doesn't come across as a huge noob question... Thanks!
  16. Heya folks, has there been any development of the AoWoW database explorer for mangoszero ? I can't find any fork that is even remotely in a working condition with the official mangoszero database. I'd like to run a clone of http://db.vanillagaming.org - would there be anyone with the knowledge of how to get there ? Cheers
  17. Hi! If anyone more traveled in these matters could give me some pointers I would be happy. I'm currently running an old repack Mangos for 2.4.3, v18 database I think and it's kinda wonky when I actually decided to play around. So I have been trying to get the v21 to work. For waaaay to many hours now, so asking for help. These are steps I have tried. I downloaded the v21 server files and extractor from this site, extracted and setup the config's is no biggie. After a few attempts with gitcloning the database, i notice when using git to downloaded the clone is missing several files, So I have now downloaded them manually and placed in the database folder for a complete database to install. Also found that the Database installer batchfile included had some errors regarding the updatesfolder so fixed those paths manually so the realm, character and world updates gets installed. there is a bunch of those updates sql files that gives errrors, I have no idea if this is supposed to be ok or not but for the characters DB update, these files gives error when installing: 21000_00_Release_021_Initial.sql and 21000_01_warden_action.sql gets an "Error 1146 at Line 2 : Table 'Realmd.character_db_version' doesn't exist" while Rel21_2_1_match_client_limits.sql *UPDATE FAILED* revision_refractor In the RealmDB update only 20150816_01_db_version.sql , Rel21_1_1_dbdocs_updates.sql and Rel21_1_2_dbdocs_update.sql are installed, the rest of the sql files are either skipped or failed. In the World updates folder, things are weird since there is a folder there thats supposed to be ran first, but if I do that mangosd.exe won't start since it complains about world_db table being wrong, and a quick look at the table reveals that all the updates in the worldfolder has had their names added to the db_version description, good for keeping track, but the server refuses to load if it's not exactly and only database 21,structure 1, content 0, revision_refractor, so to get the server to even start i need to run the files from the Rel20_to_Base_rel21Updates folder. (i also need to run the 20150816_01_db_version.sql in the realm updates too to get it to be what the realmd.exe is expecting. Now the server is startable, and playable but there is a bunch of errors related to Scriptdev2 and pretty much every castermob in instances is bugged and not following a player that moves out of LoS, so i expect i'm doing something horribly wrong. (i also tried to place the files from world/updates/rev21/Rel20_to_BaseRel21_Updates up into the rev21 and changed their names a bit so they'd get loaded in first. but that changed nothing. I apologize for the wall of text and probably incoherent rantings, but I'm stuck now and if anyone has some good ideas on how to get one up and running without all errors on the way, I'd be most thankful. /P
  18. Hey guys, i have a problem with updating worldDB to the right version. The only update that i can not apply is Rel21_2_0_SD2_refactoring.sql.(ERROR 1091 (42000) at line 5: Can't DROP 'ScriptName'; check that column/key exists). Who can help me out here? thx in advance The table `db_version` indicates that your [World] database does not match the expected structure! [A] You have database Version: 21 Structure: 1 Content: 0 Description: revision_refactor [B] You need database Version: 21 Structure: 2 Content: 6 Description: dbdocs updates You must apply all updates after [A] to [B] to use MaNGOS with this database. These updates are included in the database/World/Updates folder.
  19. I'm trying to understand how can I close AQ gates, roots, runes and other content like 4 dragons. I found that I can just add for example 4 dragons to my disables table and they will not spawn, but how it should be with AQ gates, because there is a line in db_scripts table with this script but they still open. Maybe I am missing something?
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue. Privacy Policy Terms of Use