Xenithar

I figured out the problem. The file will not execute the delete statement because an index is not used. This is a "feature" for MySQL and has been for a while. I discovered this by taking just the raw SQL and attempting to run it as an individual query. After disabling the safe updates option, the script ran fine.

We need to start specifying indexes for delete statements or this could happen again. Should we update the patch?

Mobs are also somehow resisting the mage debuffs which make them weak to frost. This is the "Elemental Precision" talent. In the combat log it logs "Mob resisted you elemental weakness". I have also had "Winter's Chill" resisted in the past, but have not checked in the recent month or two.

I am closing this because this was so long ago and it has not happened in years. If somebody can reproduce this in R21, please open a new ticket.

One of the database updates wiped my waypoints out. I am not sure which one, but will begin looking through the updates I ran and try to make heads or tails of it. I restored them using the full DB script for that table and all is good again.

Are you running R21 or R20? What build? With my build from last week all quests involving NPCs pathing has stopped working. It isn't mmaps because regular mobs and such work fine.

*UPDATE*

I believe I figured it out, to an extent.
[code]
DoScriptText with source Creature (Entry: 12717 Guid: 33115) could not find text entry -1000501.
SD3: EscortAI Start with 0 waypoints (possible missing entry in script_waypoint).
[/code]
My database was created eons ago and has been updated to the latest version, but apparently the waypoints or something did not update, or something. I will look into it, but something is not right here.

Antz this was on like, R17. I have not had this bug in several years now.

This affected an older version of the server, I believe R18 or R19. I have not seen it in R20 or R21.

This affects almost any mob. It does damage but won't freeze the mob. I'll speak with Antz and maybe help out here once I finish my current tasks.

Are you saying that if a spell is cast on a target, you can't pickpocket anything? I would be happy to test this if you can explain it a bit more clearly. I also need to know what version of the server you're running.

Just updating this. I updated last night after not being around for a while due t my job and it is still not working. I am currently working on an update to fix various creature scales, a DB optimization script, and have an on-going, long-term project of improving the bot AI in Zero. I will look into this once I finish the creature scale update, since it appears to be almost complete.

I cannot reproduce this. My undead level 60 rogue has a 4.73% crit chance completely naked with no buffs at 60. It is substantially higher all geared up. My mage was 2.11% WITH gear, but mages aren't supposed to do melee. Other classes follow suite. Can another dev check this as well?

I will check them in Linux when I get my work laptop out again (likely Monday). I can then also screenshot it for you, if those are indeed the files with the whitespace up front.

Max, I ran into this on my Linux/Unix systems. When opening the SQL files in Linux/Unix, there is a space at the start of the file before any SQL code which makes the entire file not run. I believe somebody saved these incorrectly, likely on a Windows box. To make them run on my systems, I simply opened the files in GNU "nano", pressed DEL once, and closed/saved the files. They then ran without a hitch.

I'll look into this when I get home tomorrow night. Should be a simple fix. I personally have a script set to a cron job in Linux. Is this a stored procedure or SQL script?

I can test to see what my toons are, but it APPEARS to work for me. I rarely crit on some toons and others (rogue/hunter) I crit regularly. I will check this when I get home tomorrow night.

Using GM mode will teleport you into anything, even Onyxia at level 1 and without the item required. A side-effect of this bug is that if a player, say level 30, attempts to enter SM and cannot, I cannot teleport them as a GM anywhere. For example, I could not teleport my fiance from the instance-gates for SM back to Brill. It says the player is already being teleported even though she was not. The only fix is for her to log and come back. It is kind of like a teleport flag is permanently set.

I forgot to post the update to this. MANY mobs are incorrect again, including Horde Guards (entry 3501). The male guard is half the size of my female Tauren character. I have been generating a list of incorrect NPCs and mobs and will be creating a SQL update to fix it. Lots are wrong though. Some Zhevra are tiny, others are perfect. Different entries though.

True, but why is it not letting lv29 toons in? It says you need to be 29. Get a 29 toon and you cannot get in. Very strange.

That is not the issue. Even at 1024 it blanks out at times. The issue is a coding issue inside the bot somewhere.

I ran the tools manually and they worked, but I haven't checked out the new scripts. I will rebuild this weekend and test them. I will fix them if needed.

Did you configure MaNGOS and point it to the correct directories and such? What you are describing sounds to me like the server daemon is not finding the movement maps. I cannot reproduce this with the current build. Did you copy the new mmaps directory into the correct location after building?

*UPDATE*

Scratch that, I can now produce this issue with the maps created by the new tools. Things even go underground where the Darkmoon Faire is supposed to be. See attached pics.

Last night I cloned the latest d21 branch and built the new tools. I then re-extracted everything and it fixes about 90% of the movement issues with mobs. Some mobs still climb into the air, but hunter/lock pets can now follow the player and mobs can get to the player to fight, instead of standing in place and trying to enter combat repeatedly. My advice to the OP is to clone everything again, build again, and extract everything using the new tools. This should fix your problems.

I will note that the new, unified tool does a good job, but I still get mobs going into the sky from time to time. I am not sure why, but it is still MUCH better than before, though a hair behind what we had a year ago. Perhaps we should make an option for creating better movement maps at the expense of disk space. Kind of like we have the option to make worse maps to save space (int vs float I believe).

It is fixed, I get the new tools, and the new tools fix about 90% of the movemaps issues, such as mobs bouncing around in the air. I will change this to completed and close it.

I don't do Skype. No 64bit Linux builds, and Microsoft switched it from the world-wide standard SIP protocol to something custom, so I cannot cross-chat with it with other clients. I'll re-clone and test now.

Reaper, I said vmaps/movement and MEANT to say mmaps/movement, thanks for the correction. I got separate tools the last time I built everything on my Linux box (assembler and extractor were separate) and this was Monday. I just now cloned the official repo, develop21, and can't even build the stuff due to an LUA make error. I am about to post this error in a ticket, but I believe the separate tools were bugged and I have bad mmaps, as this person probably does. Once I can try building the mmaps with the new, unified tool I expect the issue to go away.