Jump to content

All Activity

This stream auto-updates

  1. Past hour
  2. Today
  3. Yesterday
  4. Last week
  5. Earlier
  6. I can learn all the skills. Req Level not working.
  7. Hi all, I've spent a few hours every night trying to get the appropriate database updates to install for Mangos1. I keep hitting a wall where the updates will fail for no apparent reason indicating that I'm on the version immediately prior to the update version so it can't be installed (which obviously the immediately prior version is what I'd expect an update to expect, but apparently it's a surprise sometimes in Rel21 for character1 and realmd). I've identified various failures, like the updates being compressed inside the Updates directories and the installer script expecting them to be in the root of the update directory. Shuffling files around and altering the script, restarting from scratch many many times, nothing seems to work. The Rel*.sql files just seem to fail because the database is not already on the version that the update file is updating to. Does anyone have a database export for Mangos1 (TBC), that is already updated? Instead of downloading database exports alongside updates, is there a database export somewhere that's already updated? THANK YOU! o7 :)
  8. Mangosd crashes MySQL service while starting. According to logs & console, first few SQL requests work fine, but at some point MySQL service just stops with an error. Environment: Windows 10 Pro (64-bit) 22H2 (v.19045.4046), MySQL 8.0.28, MangosThree v.22 although the same problem persisted on v.21 The very same MySQL works fine with MangosZero and MangosTwo ( not concurrently ). mysql-error-log.err world-database.log world-server.log
  9. I am trying to edit or remove the reinforcements in Alterac Valley. I am trying to stop AV from ending without the end boss is killed. I have been searching for months and no luck. Can anyone help me?
  10. Hello, I'm trying to customize a creature and bring it to life with scripts (I'm using singleplayerproject ver 2.3.7 core 28 db 19 web 11 - WoW Classic). The first event works well: the NPCs appear as they should but whatever I do the boss remains totally silent and refuses to start dialogues. I tried a number of modifications to the second event, copying and pasting existing data, but to no avail. There aren't many clear tutorials on how to use creature_ai_scripts. If anyone can help me here, I'd appreciate it. First Event (ok) : INSERT INTO `creature_ai_scripts` (`id`, `creature_id`, `event_type`, `event_inverse_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `event_param5`, `event_param6`, `action1_type`, `action1_param1`, `action1_param2`, `action1_param3`, `action2_type`, `action2_param1`, `action2_param2`, `action2_param3`, `action3_type`, `action3_param1`, `action3_param2`, `action3_param3`, `comment`) VALUES (40000101, 400001, 0, 0, 100, 1025, 4000, 9000, 4000, 9000, 0, 0, 12, 400014, 4, 60000, 0, 0, 0, 0, 0, 0, 0, 0, 'vilain'); Second Event (NO ok) INSERT INTO `creature_ai_scripts` (`id`, `creature_id`, `event_type`, `event_inverse_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `event_param5`, `event_param6`, `action1_type`, `action1_param1`, `action1_param2`, `action1_param3`, `action2_type`, `action2_param1`, `action2_param2`, `action2_param3`, `action3_type`, `action3_param1`, `action3_param2`, `action3_param3`, `comment`) VALUES (40000102, 400001, 4, 0, 15, 0, 0, 0, 0, 0, 0, 0, 1, 20000, 20001, 20002, 0, 0, 0, 0, 0, 0, 0, 0, 'Southshore Crier - Yell on Spawn'); The Vilain : INSERT INTO `creature_template` (`Entry`, `Name`, `SubName`, `MinLevel`, `MaxLevel`, `ModelId1`, `ModelId2`, `ModelId3`, `ModelId4`, `Faction`, `Scale`, `Family`, `CreatureType`, `InhabitType`, `RegenerateStats`, `RacialLeader`, `NpcFlags`, `UnitFlags`, `DynamicFlags`, `ExtraFlags`, `CreatureTypeFlags`, `StaticFlags1`, `StaticFlags2`, `StaticFlags3`, `StaticFlags4`, `SpeedWalk`, `SpeedRun`, `Detection`, `CallForHelp`, `Pursuit`, `Leash`, `Timeout`, `UnitClass`, `Rank`, `HealthMultiplier`, `PowerMultiplier`, `DamageMultiplier`, `DamageVariance`, `ArmorMultiplier`, `ExperienceMultiplier`, `MinLevelHealth`, `MaxLevelHealth`, `MinLevelMana`, `MaxLevelMana`, `MinMeleeDmg`, `MaxMeleeDmg`, `MinRangedDmg`, `MaxRangedDmg`, `Armor`, `MeleeAttackPower`, `RangedAttackPower`, `MeleeBaseAttackTime`, `RangedBaseAttackTime`, `DamageSchool`, `MinLootGold`, `MaxLootGold`, `LootId`, `PickpocketLootId`, `SkinningLootId`, `KillCredit1`, `KillCredit2`, `MechanicImmuneMask`, `SchoolImmuneMask`, `ResistanceHoly`, `ResistanceFire`, `ResistanceNature`, `ResistanceFrost`, `ResistanceShadow`, `ResistanceArcane`, `PetSpellDataId`, `MovementType`, `TrainerType`, `TrainerSpell`, `TrainerClass`, `TrainerRace`, `TrainerTemplateId`, `VendorTemplateId`, `GossipMenuId`, `InteractionPauseTimer`, `CorpseDecay`, `SpellList`, `StringId1`, `StringId2`, `EquipmentTemplateId`, `Civilian`, `AIName`, `ScriptName`) VALUES (400001, 'Shaman Poil Putride', NULL, 12, 12, 10854, 0, 0, 0, 70, 2, 0, 6, 3, 14, 0, 0, 32768, 0, 0, 0, 0, 0, 0, 0, 1, 1.14286, 18, 0, 15000, 0, 0, 2, 3, 3, 1, 1.7, 1, 1, 1, 1697, 1697, 1500, 1500, 60, 80, 21.2784, 29.2578, 1200, 9, 100, 2000, 2000, 0, 128, 172, 1773, 1773, 0, 0, 0, 8389136, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, 1773, 0, 'EventAI', ''); Text 1 : INSERT INTO `broadcast_text` (`Id`, `Text`, `Text1`, `ChatTypeID`, `LanguageID`, `ConditionID`, `EmotesID`, `Flags`, `SoundEntriesID1`, `SoundEntriesID2`, `EmoteID1`, `EmoteID2`, `EmoteID3`, `EmoteDelay1`, `EmoteDelay2`, `EmoteDelay3`, `VerifiedBuild`) VALUES (20000, 'Mourez ! Pauvres fous !', '', 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 31882); Text 2 : INSERT INTO `broadcast_text` (`Id`, `Text`, `Text1`, `ChatTypeID`, `LanguageID`, `ConditionID`, `EmotesID`, `Flags`, `SoundEntriesID1`, `SoundEntriesID2`, `EmoteID1`, `EmoteID2`, `EmoteID3`, `EmoteDelay1`, `EmoteDelay2`, `EmoteDelay3`, `VerifiedBuild`) VALUES (20001, 'A moi revenants !', '', 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 31882); Text 3: INSERT INTO `broadcast_text` (`Id`, `Text`, `Text1`, `ChatTypeID`, `LanguageID`, `ConditionID`, `EmotesID`, `Flags`, `SoundEntriesID1`, `SoundEntriesID2`, `EmoteID1`, `EmoteID2`, `EmoteID3`, `EmoteDelay1`, `EmoteDelay2`, `EmoteDelay3`, `VerifiedBuild`) VALUES (20002, 'Créatures Impies !', '', 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 31882);
  11. Hi, I'm looking to create a custom dungeon instance (a new dungeon for vanilla) but I haven't seen any tutorials describing "instances" and how to go about creating one. Using Mangos Zero
  12. Wer dennoch an Classic Server Interesse hat. Es gibt andere Projekte, die WoTlK Classic Server entwickeln. Dies dient lediglich als Info für die, die auf der Suche nach einem Classic Server sind.
  13. Pysis

    account

    I was helping with `realmd` account creation today, and wanted to add some of my own documentation from the personal exchange to further help the public with technical literacy for this topic. https://www.getmangos.eu/wiki/referenceinfo/otherfiles/managing-user-accounts-using-3rd-party-apps-r20088/ This page actually provides this more generic information well, but wanted to link that to here for that reason, and also in case I can add anything more useful too. My statements are not producing the same value, but this is the clarified process, with differing examples. Remember to replace `username` and `password` with your intended, respective values, and your resulting SHA1 hash will most likely be different than my `5b...78` hash. For the shell command examples, I provide alternatives that request user input to compete, to make this more obvious. Using the MariaDB included, or associated, GUI application client, HeidiSQL: https://www.heidisql.com/help.php#queries I use DBeaver, but have also used MySQL Workbench in the past, along with SequelPro for Apple computers, and Navicat even longer ago. The base SQL, mentioned above, that I also wanted to represent a bit differently: `SELECT SHA1(CONCAT(UPPER('username'), ':', UPPER('password')));` Fish shell command line statements: ``` ⋊> echo -n 'SELECT SHA1(CONCAT(UPPER(\'username\'), \':\', UPPER(\'password\')));' | mariadb -s -p"$dbRootPP"; 5b039d152722e351c8bdebcf06fd8cd4e5244d78 ⋊> echo -n 'SELECT SHA1(\''(read -P 'Username: '| upcase)':'(read -P 'Password: '| upcase)'\');' | mariadb -s -p"$dbRootPP"; Username: username Password: password 5b039d152722e351c8bdebcf06fd8cd4e5244d78 ⋊> echo -n 'USERNAME:PASSWORD' | sha1sum | cut -d' ' -f1 5b039d152722e351c8bdebcf06fd8cd4e5244d78 ⋊> echo -n (read -P 'Username: '| upcase)':'(read -P 'Password: '| upcase) | sha1sum | cut -d' ' -f1 Username: username Password: password 5b039d152722e351c8bdebcf06fd8cd4e5244d78 ⋊> echo -n 'USERNAME:PASSWORD' | openssl sha1 | cut -d' ' -f2 5b039d152722e351c8bdebcf06fd8cd4e5244d78 ⋊> echo -n (read -P 'Username: '| upcase)':'(read -P 'Password: '| upcase) | openssl sha1 | cut -d' ' -f2 Username: username Password: password 5b039d152722e351c8bdebcf06fd8cd4e5244d78 ⋊> echo -n 'USERNAME:PASSWORD' | /usr/bin/openssl sha1 | cut -d' ' -f2 5b039d152722e351c8bdebcf06fd8cd4e5244d78 ⋊> echo -n (read -P 'Username: '| upcase)':'(read -P 'Password: '| upcase) | /usr/bin/openssl sha1 | cut -d' ' -f2 Username: username Password: password 5b039d152722e351c8bdebcf06fd8cd4e5244d78 ``` My environment: ``` ⋊> neofetch --stdout distro kernel shell term distro: Fedora release 39 (Thirty Nine) x86_64 kernel: 6.6.13-200.fc39.x86_64 shell: fish 3.7.0 term: gnome-terminal ⋊> mariadb --version mysql Ver 15.1 Distrib 10.1.21-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2 ⋊> sha1sum --version sha1sum (GNU coreutils) 9.3 Copyright (C) 2023 Free Software Foundation, Inc. License GPLv3+: GNU GPL version 3 or later <https://gnu.org/licenses/gpl.html>. This is free software: you are free to change and redistribute it. There is NO WARRANTY, to the extent permitted by law. Written by Ulrich Drepper, Scott Miller, and David Madore. ⋊> openssl version OpenSSL 1.1.1b 26 Feb 2019 ⋊> /usr/bin/openssl version OpenSSL 3.1.1 30 May 2023 (Library: OpenSSL 3.1.1 30 May 2023) ``` The only remaining problem was that the new account, or at some point, any account, were all receiving messages that they were banned, or the account closed, and could basically not login using the WoW client. Changing `LogLevel` to '2' in `realmd.conf` helped show us a message about an AuthChallenge code module reporting "Banned IP ...". https://github.com/search?q=repo%3Amangos%2Frealmd banned&type=code https://github.com/mangos/realmd/blob/8c08d47a9a3e6c64007be67074e7c587a5e63e5e/Auth/AuthSocket.cpp#L375 This could be answered in another article, and I may have seem some posts mentioning various strategies, but I want to briefly list the possible solutions for these other problems here, since they are at least close in function and process. What may have fixed this these problems, while even using the localhost IP address 127.0.0.1 in the `realmd.conf` file, is restarting the realmd process. https://www.getmangos.eu/forums/topic/10721-says-my-account-is-closed/#comment-79515 https://www.getmangos.eu/forums/topic/10690-stuck-on-connected/#comment-79328 For specific account problems, try using the same localhost IP address as the `localAddress`, but changing the `address` field to the external IP address of the machine the server is being hosted on. An alternative is deleting the `address` field record's data. We also checked reduced `failedLogins` to '0', any `active` field to '1', or `locked` to '0', and checking there was no matching record for either IP address in the `ip_banned` table, or even that it was empty. Also, for any solution in this post, make sure all database changes are saved/persisted, so you can reload and find the data you updated again, which is more applicable when using GUI application clients to interact with a database, but also any command line execution in case errors are reported there too.
  14. I'd like to do something like what they did in ValHalla in D2. I have the ideas, I have the knowledge and know-ho, it's just a matter of doing it.
  15. I want to make a story, such as the WIfe of Bath. The Wife of Bath is a character in Geoffrey Chaucer’s Canterbury Tales. She is one of the most developed characters in the book, with her prologue twice as long as her tale1. She is a seamstress by trade but a professional wife by occupation, having been married five times 2. Her tale is among the best-known of the Canterbury Tales and provides insight into the role of women in the Late Middle Ages 1. The tale is often regarded as the first of the so-called “marriage group” of tales, which includes the Clerk’s, the Merchant’s, and the Franklin’s tales 1 This would definietely be more interesting than a PvP or PvE environment. There is no tales, that could be taken from English textes. I want to do this. Will take some time.
  16. Almost Though I forked a github repo from 4 years ago and reworked some stuff. dabatase runs inside a single container, Realmd runs inside a single container, and world also has it's own container. Using that for a kubernetes deployment. DB and Realmd are working fine, worldserver at the moment is crashing with an error i have to troubleshoot
  17. Oh Ok, Thank you for your answer
  18. Hi @mvoogd! Unfortunately, MangosTwo does not support PlayerBots. There was some work done in the form of a PR on the GitHub Repo - but it was still a work in progress by the author and has not been finished.
  19. I have a question, I was able to compile everything and it works great however when I enable the bots in cmake and recompile the code I am getting errors, 1st of all the bot folder is empty so I am missing the code for the bots, when I go to github and download the code there myself and copy it in the bot folder I am getting a lot more errors. My question is where can I download the bot code which should go with the Mangos 2 version or how can I enable this feature? Thank you
  20. It's just about quest items, but also affecting trade items like herbals. I don't know of any quick fix that checks trade items.
  21. @D Q I have pushed a PR out on the original repository where the fix was initial committed too.
  22. @Meltie Thanks for the quick response... I would love to contribute. But TBH, I am not very certain I understand the intention of that piece of the code. Only spotted the obvious "prof" part. Might create a PR and discuss further.
  23. @D Q There are two authors to this commit, Fyre and I. Just never got around to fixing the issue yet and just being busy outside of the project. Feel free to make a PR with the fix and will get it pushed out.
  24. Looking at the commit that changed this code https://github.com/mangosone/server/commit/360ddbdf862780c35664d44e15f9de9a3be13dab#diff-60492af07b2ca76bed925294d27c48cab25f8db3a33423e3db010c3d800e8b68L4460 I guess it should be like below. But I am not very familiar with the objects either. bool prof = SpellMgr::IsProfessionSpell(trainer_spell->spell); // if we use || here all profession skills are "red" if (prof && trainer_spell->reqLevel && (trainer_spell->reqLevel) < reqLevel) { return TRAINER_SPELL_RED; } // check skill requirement // I am not sure, but the previous version checks !prof. Similarly, if we have "prof || xxxx" here, all profession skills are red if (!prof || trainer_spell->reqSkill && GetBaseSkillValue(trainer_spell->reqSkill) < trainer_spell->reqSkillValue) { return TRAINER_SPELL_RED; } @Fyre, sorry for tagging you here. But looks like you are the author of that commit. can you take a look?
  25. I see similar issue on TBC too.
  26. My server is TBC, based on latest master. My character is now lv8. All the profession skills, including fishing, first aid, cooking, etc are show as unavailable to me. Is there any known issue or did I miss anything. Thanks
  27. I had exactly same issue and the solution worked The trick is you have to find all the "updates" between A and B and apply them one by one.
  28. I think I found another bug related to looting. Here's how I reproduce it: Create two bots(I believe it's also the same issue with real players, but I don't have a friend to play with me ) Have them all accept a quest to collect some items change the loot mode to master loot. Whenever you or the bots try to loot the quest item, you will get the error "Cannot loot this right now". Workaround: just change to other loot mode when you are working on that quest Potential fix: I am not sure if I understand the code correctly, but the following fix works so far(for couple of hours of playing) @@ -144,8 +144,14 @@ void WorldSession::HandleAutostoreLootItemOpcode(WorldPacket& recv_data) } case MASTER_LOOT: { - if((item->winner && item->winner != player->GetObjectGuid()) || (!item->winner && !item->is_underthreshold && !item->freeforall)) + if((item->winner && item->winner != player->GetObjectGuid()) + || (!item->winner && !item->is_underthreshold && !item->freeforall && !qitem)) { + // below is just to show the item flags for debugging. + sLog.outError("winner=%s, player=%s, is_underthreshold=%d, freeforall=%d", + item->winner.GetString().c_str(), + player->GetObjectGuid().GetString().c_str(), + item->is_underthreshold, + item->freeforall); player->SendEquipError(EQUIP_ERR_LOOT_CANT_LOOT_THAT_NOW, NULL, NULL, item->itemid); return; }
  29. Brand new user here ... I could solve the realmd update issues and update but unfortunately not the mangos d version mismatch issue , when trying to apply the updates update 22_03 fails. preventing further updates ... any help would be greatly appreciated as I am in the last bit of the setup for the server. mysql -u root character0 < Rel22_03_001_Adjust_Tables.sql ===== Status ===== ===== DB is on Version: ===== * UPDATE FAILED * Add_field_comments root@X299-DARK:/home/mangos/mangos/zero/db/database/Character/Updates/Rel22# mysql -u root character0 < Rel22_0 Rel22_03_001_Adjust_Tables.sql Rel22_04_001_Add_Quest_Tracker_Table.sql root@X299-DARK:/home/mangos/mangos/zero/db/database/Character/Updates/Rel22# mysql -u root character0 < Rel22_04_001_Add_Quest_Tracker_Table.sql ===== Status ===== === Expected === ===== Found Version ===== * UPDATE SKIPPED * Rel22_03_001 - IS NOT APPLIED 22_2_1 - Add_field_comments root@X299-DARK:/home/mangos/mangos/zero/db/database/Character/Updates/Rel22#
  1. Load more activity
×
×
  • 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