Jump to content

All Activity

This stream auto-updates

  1. Today
  2. Yesterday
  3. Last week
  4. Please post it. I’ve been trying to get fyre’s working but I’m stuck on the last step. (this is for Windows)
  5. @whero If you need a registration page, I can upload one of mine I coded a few years ago. Will have to adjust the structure to match Mangos.
  6. My server is online. I want to get a registration page. I'm willing to pay via paypal for a working registration script. If not I'll attempt to do one on my own but I don't really know where to start except for searching google. (This is for MaNGOStwo).
  7. Earlier
  8. Hello guys! When I first installed SPP Mangos WoW 3.3.5a the first time worked fine and I played a bit but I decided to delete it by sending it to Recycle bin (I think that's where the problem came from more likely) and freshly installed it again and didn't think of something happening to it, so I tried installing it the same way I did but this time when I select Start Up Server (64x) it opens up briefly and closes right after 1-3 seconds and the other pop windows stay open and one shows 2024-04-18T21:11:46.164827Z 12 [Note] Unknown database 'wotlkplayerbots' Whine in the server log file it shows this. 2024-04-18 22:03:47 ERROR:Could not connect to MySQL database at 127.0.0.1: Unknown database 'wotlkplayerbots' 2024-04-18 22:03:47 ERROR:Can not connect to Playerbot database 127.0.0.1;3310;root;123456;wotlkplayerbots I attached the server log as well if that helps. I'm not sure what else I can do, tried by fixing it but I'm just clueless at this point and I would provide with more details if needed, thank you in advance. (Also apologies if this was the wrong Topic to post it in, I'm new here and I couldn't find any other place) Server.log
  9. Hello. I am almost done installing MangosTwo but I keep getting the error "vmaps is empty or doesn't exist). Here is a pic. I also get a runtime error when I get to run vmap extractor. I delet the buildings and vmaps folder but it stops here.I don't know what to do. I've tried changin the folder name to remove spaces, moving it to desktop. I've tried deleting all dbc/mmaps/vmaps/maps/Buildings but everytime it says "vmaps doens't exist or is empty". Could someone post a direct link to the maps files for WoW 3.5.5a? That's the only way I think around it will work. To get the files from another extraction. Here is the run time error when I run vmaps-extractor directly.
  10. @antz Thank you for your response. Please see attached. Example is (I believe) using all defaults with no new profile created. The ERROR 1045 occurs on every line from beginning to end.
  11. @Conner Reid Can you provide the text of the error messages, perhaps a screenshot.
  12. Got to Step 17 and I get the following errors: 1. If I use the default server name, I get Error 1045 (28000) all the way down, whether or not I use the default user/pw/other settings. 2. If I use a custom server name, I get Error 2005 all the way down. Is there something I was supposed to have set up previously? I'm not sure where the .bat file is looking for usernames, server info, etc.? I have the version of MariaDB specified in the install guide installed with the settings as shown. What am I doing wrong here?
  13. Do you require VIsual Studio 32 bit to build 32 bit Mangos?
  14. You can download the repository in a zip file directly from github in browser.
  15. You can force git using http version 1.1 git config --global http.version HTTP/1.1
  16. I think the reason this is happening is because the Wifi is weak. That's what someone else had a problem with. Coud someone provide the files so I can download them manually? Or should I do a manual install of mangos?
  17. It's not making any files. I'm a little loss at using the EasyBuild method. Do I need to open my firewall. Or what is going on?
  18. I can learn all the skills. Req Level not working.
  19. 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 :)
  20. 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
  21. 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?
  22. 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);
  23. 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
  24. 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.
  25. 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.
  26. 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.
  27. 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.
  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