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

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 16 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
×
×
  • 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