Auntie Mangos

* What bug does the patch fix? What features does the patch add? As of changes in patch 3.3, Conflagrate deals 60% instant damage of immolate/shadowflame and 40% as 3-tick DOT effect. * For which repository revision was the patch created? [9371] * Is there a thread in the bug report section or at lighthouse? If yes, please add a link to the thread. http://getmangos.eu/community/showthread.php?12022 * Who has been writing this patch? Please include either forum user names or email addresses. Me. http://paste2.org/p/669439 In the patch I decrease instant damage coefficient from 80% to 60% (down to 3 immolate/shadowflame ticks of 5) and save damage for DOT effect as 40% of immolate damage divided by 3 ticks of Conflagrate DOT.

The patch was written for revision 8806. This patch fixes the following bugs: 1. Partial resists occur in multiples of 10% (not 25% like pre-WotLK). 2. At a given value of resistance, only 3-4 resist percentages are possible. 3. The long-term average damage resisted at a given value of resistance appears to follow the formula Average Resist = Resistance/(Constant+ Resistance) For level 80 mobs, the Constant is 400. For level 83 bosses, the Constant appears to be 510 (pending final confirmation). 4. The possibility of a given partial resist % is eliminated when the average resistance (from the above formula) is 20% higher. 5. The probability of each partial resist seems to obey a triangular distribution. Bug report thread: http://getmangos.eu/community/viewtopic.php?id=10898 The patch was written by me. More information about the formula is at: http://elitistjerks.com/f15/t44675-resistance_mechanics_wotlk/ Link to the patch: http://paste2.org/p/511213 Tested after applying the patch: Casting shadow spells against a paladin with 130 Shadow Resist Aura: Theoretically would result in: 10 percent resisted: 13.68% 20 percent resisted: 38.68% 30 percent resisted: 36.32% 40 percent resisted: 11.32% Out of 239 spell hits I got: 10 percent resisted: 36 spells (15%) 20 percent resisted: 88 spells (37%) 30 percent resisted: 89 spells (37%) 40 percent resisted: 26 spells (11%)

Updated - V6 What bug does the patch fix? What features does the patch add? Aura 262 (http://thottbot.com/?e=Apply%20Aura%20262) For which repository revision was the patch created? 8879 Is there a thread in the bug report section or at lighthouse? If yes, please add a link to the thread. http://getmangos.eu/community/viewtopic.php?id=8251 or http://getmangos.eu/community/viewtopic.php?id=5986 or many, many others... Who has been writing this patch? Please include either forum user names or email addresses. Me Status: All work as it should now, but charges for fingers of frost are done with "SetAuraCharges()", so players see how many spells remains, but I like this solution more than some "uint8" in unit.cpp... Thanks to Lynx3d for patch for triggering of FoF/Frostbite and Sudden death rage saving from here (Sorry, forum is down:() Please, test this patch - I know, its bigger than other ones, but everything cant be fixed with 5 lines of code, and its fixes really important Talents for Arms warriors and Frost mages. Thanks Diff (ChangeLog): V6a: http://pastebin.ca/1693896 (Currently on my server with around 500 ppl) V6: http://pastebin.ca/1689562 V5b: http://pastebin.ca/1666611 V5a: http://pastebin.ca/1657361 V5: http://pastebin.ca/1656666 V4b: http://pastebin.ca/1649882 V4a: http://pastebin.ca/1648243 V4: http://pastebin.ca/1632638(tested on server with around 130 players, with no bugs/new crashes, thx spichy ) V3: http://pastebin.ca/1627221 V2: http://pastebin.org/41516(for rev 8609) V2: http://pastebin.org/41498(for rev 8558) V1: http://pastebin.org/34949 SQL: DELETE FROM spell_proc_event WHERE entry IN(44543, 44545); INSERT INTO spell_proc_event (`entry`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask0`, `SpellFamilyMask1`, `SpellFamilyMask2`, `procFlags`, `procEx`, `ppmRate`, `CustomChance`, `Cooldown`) VALUES('44543','0','3','33555104','0','0','0','0','0','7','0'), ('44545','0','3','33555104','0','0','0','0','0','15','0'); And one more sql for Taste for blood hidden cooldown: http://getmangos.eu/community/showthread.php?p=90637 (thx reeshack, i forget to this ) Related patches: Warbringer - remove movement imparing effects Juggernaut - additional crit chance Sudden death - rage management

take a look - List of supported versions : http://getmangos.eu/community/viewtopic.php?id=19462 also repacks are not supported on this forum

Tried to apply patch with revision 10277 and getting fatal error at the very last line. Not exactly sure why, maybe I just copied it screwy. Using the diff code from -This Post-

http://getmangos.eu/community/showthread.php?7318-Guide-Mangos-Windows-Setup you must set expansions for accounts from console: account set addon [username] [number 0-2, 0 being vanilla, 2 being WotLK]

the warlock demonic circle spell has it's fix in http://getmangos.eu/community/showthread.php?13085-My-github-Repo&highlight=my+github+repo. hope that was helpful,good luck

patro did the following mod of False.Genesis' patch on that same line in this post: else if(index == UNIT_FIELD_FACTIONTEMPLATE) { FactionTemplateEntry const *ft1, *ft2; ft1 = ((Player*)this)->getFactionTemplateEntry(); ft2 = ((Player*)target)->getFactionTemplateEntry(); if(ft1 && ft2 && !ft1->IsFriendlyTo(*ft2)) { uint32 faction = ((Player*)target)->getFaction(); DEBUG_LOG("-- VALUES_UPDATE: Sending '%s' the blue-group-fix from '%s' (faction %u)", target->GetName(), ((Player*)this)->GetName(), faction); *data << uint32(faction); ch = true; } I also noticed that this update has a few trailing spaces, some trailing tabs, and a lot of tabs instead of spaces for indent. This may not mean much (I wouldn't know as I'm not much of a C++ programmer, but I always use spaces and never trail spaces as that's the way I was taught in college), but it seems inconsistent with the MaNGOS code style.

there is a LOT of stickies with a LOT of information about GIT and how to use all its features: http://getmangos.eu/community/viewforum.php?id=27

What bug does the patch fix? Mind Blast, Searing Pain and Earth Shock combat log shows a value double of dmg done to enemy. And this double damage is used in the future, such as for the calculation of hp obtained by Vampiric Embrace. For which SubVersion revision was the patch created? 6007 Is there a thread in the bug report section? http://getmangos.eu/community/viewtopic.p...p;hl=mind+blast Who has been writing this patch? Ultron Index: Unit.cpp =================================================================== --- Unit.cpp (revision 6007) +++ Unit.cpp (working copy) @@ -776,8 +776,9 @@ if (pVictim->GetTypeId() != TYPEID_PLAYER) { if(spellProto && IsDamageToThreatSpell(spellProto)) - damage *= 2; - pVictim->AddThreat(this, damage, damageSchoolMask, spellProto); + pVictim->AddThreat(this, damage*2, damageSchoolMask, spellProto); + else + pVictim->AddThreat(this, damage, damageSchoolMask, spellProto); } else // victim is a player { http://filebeam.com/67f5c9fa87b1dd2bae30a8a7ae368176

There are three versions of MaNGOS: MaNGOS-Zero is intended for "vanilla" WoW, client version patched to 1.12.1.5875 or 1.12.2.6005. MaNGOS-One is to be used with "The Burning Crusade" expansion, client version patched to 2.4.3.8606. MaNGOS is the main project and meant for "Wrath Of The Lich King" expansion, client version patched to 3.3.5.12340. At this time, there is no officially supported MaNGOS server for Cataclysm, due to technical reasons. Posting topics asking when there will be a Cataclysm server will earn you some flames and stern looks. Reaper-X is what we refer to as a "repack" around here. This means someone has compiled an executable binary from the source code and repackaged it as an "out-of-the-box" server kit. Repacks are not supported here. For help with those, you must contact the author of that software package. MaNGOS is intended to be a learning project. This means that, at the very least, you will learn how to compile and put together your own server from scratch. MaNGOS is cross-platform, supporting both Windows and Linux operating systems. You will need some sort of C++ compiler, at the very least. For Windows, it is recommended to use Visual C++ 2008 or newer. Linux has a compiler built right in, the GNU Compiler Collection, abbreviated as gcc. MaNGOS uses Git as its version control software for updating the source code and obtaining it for compiling. It is recommended to use it, but you can still work with the source code without using Git. It is also recommended to include ScriptDev and ACID, which add a more sophisticated AI and behaviors to dungeon encounters, raids, battlegrounds, outdoor PvP, certain NPCs, and world bosses. You will also need a database to populate your world with all the creatures and NPCs as well as provide all the items, spells, pets, gear, and everything else. The two most popular databases for MaNGOS are UDB and YTDB. There are a few others, like Project Silvermoon, but UDB and YTDB are more frequently updated. A complete server will consist of those elements. Which versions you'll use depends on which client version you wish to play. If none of this has scared you away, yet, and you're ready and willing to get your hands dirty and heat up some brain cells, then there are several good tutorials and guides for creating your very own ManGOS server. You'll also discover many helpful individuals to lend a hand when you get stuck upon a problem. Also, feel free to browse through all the forums. You'll find a wealth of information to give you a firm grasp of all the fun and work that goes into making MaNGOS the gold standard of private WoW servers. For learning Git and updating or patching your source code: Source code management For help with compiling, installing, setting up, and upgrading your server: Installation, configuration & upgrades For dealing with other issues you encounter once you have your server up and running: General support

This thread should have been closed a long time ago. If you want more recent news, look here [Working]OutdoorPvP r10049+ instead of reviving a thread that has been dead for over a year and a half.

13th October 2010 Often things are so very obvious that everyone fails to notice them. House cleaning Isn't there more than just these forums? Yes, we have noticed this recently, too. Thus this section may now be used to give feedback to any part of the mangos website. Up next: private messages, and more fixes. Feedback this way, please.

same here, but every 10 - 15 min, maybe because we have only about 400 players. EDIT: Isnt it this http://getmangos.eu/community/viewtopic.php?id=11276 ?

What bug does the patch fix? What features does the patch add? - It should fix spell like Unstable affliction dispel trigger, which suffer from the level penalty and doesn't gain proper amount of spell power bonus. For which repository revision was the patch created? Rev. 8578 Is there a thread in the bug report section or at lighthouse? If yes, please add a link to the thread. It was mentioned in : http://getmangos.eu/community/viewtopic.php?id=5937 Who has been writing this patch? Please include either forum user names or email addresses. Me, reeshack Paste2.org : V1 : http://paste2.org/p/477024 V2 : http://paste2.org/p/476974 Quotation from wowwiki :" Downranking is the process of using a lower than maximum spell rank in order to gain higher efficiency per mana. " That means if there isn't specified rank of the spell (or there is only one), it should not get any level penalty. Currently the calculation of level penalty is based only on spell level, which some spells, like f.e. Unstable Affliction dispel trigger, has 1 and therefore they are treated in a wrong way and gain very low spell power bonus.

Seems to be you have any error in DB, try to re-installing complete DB or try with this updater: http://getmangos.eu/community/topic/15590/python-yet-another-script-for-sql-updates/. Thanks!

I don't know why people insist on using CMake on Windows... There are well tested project files for Visual Studio and we have repeatedly pointed out (e.g. in the announcement) that CMake is still experimental for Windows, so we will not give support at this point. Of course you are free to discuss how to fix existing problems, but there is no guarantee for prompt solutions. Oh and if you don't accept that the forum language is english, or continue personal flaming, i'll have to close this thread.

FrozenGod I have summited a bug report on the errors your getting but it seems nobody is looking at it but here's the link to it http://getmangos.eu/community/showthread.php?13197-TAO-ACE-Code

Hey there I got the latest version of everything and this works just fine.... of course if you put too much items in the AH, your connection will freeze while connecting....too much depends on your computer... but if its your first time using it i suggest you put like 2000-5000 items in the Horde-Alliance AH...and less in the neutral AH.... 500-1000 So here you go: PART 24 - ADD-ON: AUCTION HOUSE ** This patch modifies the core so it populates the auction houses with items. It makes the game feel a bit more like official. Items and prices are chosen randomly based on the parameters you define. If an auction expires, auctions are deleted quietly. If the auction sells, you *can* get the in-game mail for that item. ** Information http://getmangos.eu/community/showthread.php?8386-%5bPATCH%5d-AuctionHouse-Bot&highlight=auction ** Download http://skinlayers.net/patches-mangos/ ** If you’ve installed the Add-On while installing your server, you’ll only need to do AHBot Part 3 – Creating the Account and then change the Account and GUID numbers in the Mangos.Conf ** AHBot Part 1 – Auction House Patch – Require the software to be re-compile • Create the folders C:\\Mangos\\Addon\\AHBot and put your patch file there • Right click on C:\\Mangos and choose “Git Bash Here” • You will need to test the patch to make sure your not going to run into trouble, type the following command replacing the X number with the number of the file located at the specified path: git apply --check Addon/AHBot/mangos-XXXX-ahbot.patch • If the patch did not encountered any trouble, you can continue to the next point • Type the following command replacing the X number with the number of the file located at the specified path: git apply Addon/AuctionHouse/mangos-ahbot-XXXX.patch • Close the GIT Bash window when its done ** The next step will required to re-compile mangos. If you’re thinking to add more addons wich need to re-compile mangos as well, perhaps it will save you time to take the appropriate action on each add-ons until a re-compile is required • Rebuild Mangos (See PART 8 - Compiling and PART 9 - Installing Mangos) ** Choose to replace the files in your C:\\Mangos ** AHBot Part 2 – Adding the SQL code in the Database • Add the C:\\Mangos\\sql\\characters_auctionhousebot.sql and then the C:\\Mangos\\sql\\characters_auctionhousebot_update.sql to your characters database (See PART 15 - Updating your Database with SQL Files) ** AHBot Part 3 – Creating the Account • Create a new account named “Addon” with a password of your chosen. (See PART 22 - Console Commands) • Login to the server with your World of Warcraft Client and create a character witch you are going to use as the auction house bot character. Lets name it “AuctionHouse” ** This character will be the auctions' owner for all the items created by the bot. • Enter the game with this character for it to receive its game settings. • Then you can logout • Open SQLyog and connect to your database • Select the realmd database and open the “Account” table. • Note the account number for the character having “Addon” as user name. ** You may want to disable the 4 defaults account. Just put a 1 in the “locked” columns for theses. i guess they aren't beiing use by saying so... • Select the characters database and open the “characters” table. Knowing the account number, you’ll be able to note the character's GUID. • Close SQLyog ** AHBot Part 4 – Tuning the Mangos.conf ** Take note that if you’re installing this Add-on apart from your server installation, the C:\\Mangos\\src\\Mangosd\\Mangosd.conf.dist.in will be modified and it would be best to copy that file as the new C:\\Mangos\\Mangos.conf. Of course you will need to put back your settings • Tune up theses settings in your C:\\Mangos\\Mangos.conf file: ** If the settings are missing, insert them at the end of your config file AuctionHouseBot.EnableSeller = 1 AuctionHouseBot.EnableBuyer = 1 AuctionHouseBot.Account = 0 AuctionHouseBot.GUID = 0 AuctionHouseBot.VendorItems = 1 AuctionHouseBot.LootItems = 1 AuctionHouseBot.OtherItems = 1 AuctionHouseBot.No_Bind = 1 AuctionHouseBot.Bind_When_Picked_Up = 0 AuctionHouseBot.Bind_When_Equipped = 1 AuctionHouseBot.Bind_When_Use = 1 AuctionHouseBot.Bind_Quest_Item = 0 AuctionHouseBot.ItemsPerCycle = 500 AuctionHouseBot.UseBuyPriceForSeller = 0 AuctionHouseBot.UseBuyPriceForBuyer = 0 # AuctionHouseBot.Account is the account number (in realmd->account table) of the player you want to run as the auction bot. Note: a value of 0 will disable the bot # AuctionHouseBot.GUID is the GUID (in mangos->character table) of the player you want to run as the auction bot. Note: a value of 0 will disable the bot • Change this other setting in your C:\\Mangos\\Mangos.conf file: AllowTwoSide.Interaction.Auction = 1 ** AHBot Part 5 – Tuning the SQL Database • Connect to your SQL Server with SQLyog • Select your Characters Database on the left and go in your “AuctionHouseBot” table in the “Table Data” section • Here are the settings you need to change to your convenience for each auction house (Alliance, Horde, Neutral) a) The minimum (minitems) and maximum (maxitems) items in each auction house Default value Minitems = 0 Maxitems = 0 ** You won’t have any item’s in the auction house if you don’t change it ** If you put too many item’s, depending on your machine, it might take time to login to the server b) The minimum (mintime) and maximum (maxtime) number of hours for an auction Default value Mintime = 8 Maxtime = 24 c) The percentage of the auction items that should be trade goods and items of the mention quality. A value of 0 will disable. All 16 combined should give a total of 100 Default Value PercentGreyTradeGoods = 0 PercentGreyItems = 0 PercentWhiteTradeGoods = 27 PercentWhiteItems = 10 PercentGreenTradeGoods = 12 PercentGreenItems = 30 PercentBlueTradeGoods = 10 PercentBlueItems = 8 PercentPurpleTradeGoods = 1 PercentPurpleItems = 2 PercentOrangeTradeGoods = 0 PercentOrangeItems = 0 PercentYellowTradeGoods = 0 PercentYellowItems = 0 d) MinPrice and MaxPrise are the minimum and maximum price adjustment for the mention type of items. For example, let say a minimum of 150, which means 150%. So if an item vendors for 1g it would go to auction for a minimum of 1.5g. Default Value MinPriceGrey = 100 MaxPriceGrey = 150 MinPriceWhite = 150 MaxPriceWhite = 250 MinPriceGreen = 800 MaxPriceGreen = 1400 MinPriceBlue = 1250 MaxPriceBlue = 1750 MinPricePurple = 2250 MaxPricePurple = 4550 MinPriceOrange = 3250 MaxPriceOrange = 5550 MinPriceYellow = 5250 MaxPriceYellow = 6550 e) MinBidPrice and MaxBidPrice are the starting and ending bid as a percent of the buyout price. For example, if this value is 50 and the buyout price is randomly chosen to be 1g, then the bid price will be 50s. Default Value MinBidPriceGrey = 70 MaxBidPriceGrey = 100 MinBidPriceWhite = 70 MaxBidPriceWhite = 100 MinBidPriceGreen = 80 MaxBidPriceGreen = 100 MinBidPriceBlue = 75 MaxBidPriceBlue = 100 MinBidPricePurple = 80 MaxBidPricePurple = 100 MinBidPriceOrange = 80 MaxBidPriceOrange = 100 MinBidPriceYellow = 80 MaxBidPriceYellow = 100 f) MaxStack is maximum stack size to create for this quality type. A value of zero will disable the maximum stack size for this quality allowing the bot to create stacks (of random size) of items as big as the item type allows. Default Value MaxStackGrey = 0 BuyerPriceGrey = 1 MaxStackWhite = 0 BuyerPriceWhite = 1 MaxStackGreen = 3 BuyerPriceGreen = 5 MaxStackBlue = 2 BuyerPriceBlue = 12 MaxStackPurple = 1 BuyerPricePurple = 15 MaxStackOrange = 1 BuyerPriceOrange = 20 MaxStackYellow = 1 BuyerPriceYellow = 22 g) BuyerBiddingInterval Default value BuyerBiddingInterval = 1 BuyerBidsPerInterval = 1

Well, since CLI experience in mangos is lacking, i thought ill drop this patch that adds readline support under linux OS, with history of commands scrolling, and tab completion of commands. Some parts of the diff are hand-written (to get rid of trinityisms) so you may have to apply it manually. Also, remember to set up automake to link against readline --- a/src/game/Chat.h +++ b/src/game/Chat.h @@ -73,7 +73,7 @@ class ChatHandler int ParseCommands(const char* text); virtual char const* GetName() const; - + static ChatCommand* getCommandTable(); protected: explicit ChatHandler() : m_session(NULL) {} // for CLI subclass @@ -89,8 +89,6 @@ class ChatHandler bool ShowHelpForCommand(ChatCommand *table, const char* cmd); bool ShowHelpForSubCommands(ChatCommand *table, char const* cmd, char const* subcmd); - ChatCommand* getCommandTable(); - bool HandleAccountCommand(const char* args); bool HandleAccountCreateCommand(const char* args); bool HandleAccountDeleteCommand(const char* args); --- a/src/trinitycore/CliRunnable.cpp +++ b/src/trinitycore/CliRunnable.cpp @@ -37,6 +37,56 @@ #include "Player.h" #include "Chat.h" +#if PLATFORM != WINDOWS +#include <readline/readline.h> +#include <readline/history.h> + +char * command_finder(const char* text, int state) +{ + static int idx,len; + const char* ret; + ChatCommand *cmd = ChatHandler::getCommandTable(); + + if(!state) + { + idx = 0; + len = strlen(text); + } + + while(ret = cmd[idx].Name) + { + if(!cmd[idx].AllowConsole) + { + idx++; + continue; + } + + idx++; + //printf("Checking %s \\n", cmd[idx].Name); + if (strncmp(ret, text, len) == 0) + return strdup(ret); + if(cmd[idx].Name == NULL) + break; + } + + return ((char*)NULL); + +} + +char ** cli_completion(const char * text, int start, int end) +{ + char ** matches; + matches = (char**)NULL; + + if(start == 0) + matches = rl_completion_matches((char*)text,&command_finder); + else + rl_bind_key('\\t',rl_abort); + return (matches); +} + +#endif + void utf8print(const char* str) { #if PLATFORM == PLATFORM_WINDOWS @@ -316,10 +366,10 @@ void CliRunnable::run() WorldDatabase.ThreadStart(); // let thread do safe mySQL requests char commandbuf[256]; - + bool canflush = true; ///- Display the list of available CLI functions then beep sLog.outString(); - + rl_attempted_completion_function = cli_completion; if(sConfig.GetBoolDefault("BeepAtStart", true)) printf("\\a"); // \\a = Alert @@ -331,15 +381,16 @@ void CliRunnable::run() while (!World::IsStopped()) { fflush(stdout); - #ifdef linux - while (!kb_hit_return() && !World::IsStopped()) - // With this, we limit CLI to 10commands/second - usleep(100); - if (World::IsStopped()) - break; - #endif - char *command_str = fgets(commandbuf,sizeof(commandbuf),stdin); - if (command_str != NULL) + + char *command_str ; // = fgets(commandbuf,sizeof(commandbuf),stdin); + + #if PLATFORM == WINDOWS + command_str = fgets(commandbuf,sizeof(commandbuf),stdin); + #else + command_str = readline("TC>"); + rl_bind_key('\\t',rl_complete); + #endif + if (command_str != NULL) { for(int x=0;command_str[x];x++) if(command_str[x]=='\\r'||command_str[x]=='\\n') @@ -351,23 +402,30 @@ void CliRunnable::run() if(!*command_str) { - printf("TC>"); + #if PLATFORM == WINDOWS + printf("TC>"); + #endif continue; } std::string command; if(!consoleToUtf8(command_str,command)) // convert from console encoding to utf8 { - printf("TC>"); + #if PLATFORM == WINDOWS + printf("TC>"); + #endif continue; } + fflush(stdout); + sWorld.QueueCliCommand(&utf8print,command.c_str()); + #if PLATFORM != WINDOWS + add_history(command.c_str()); + #endif - sWorld.QueueCliCommand(&utf8print,command.c_str()); - } + } else if (feof(stdin)) { World::StopNow(SHUTDOWN_EXIT_CODE); } + } ///- End the database thread [vladimir: extracted from http://getmangos.eu/community/showthread.php?p=36981#post36981 ]

Edit: Oops, title should be fix "for pre-3.0.3" chars. What bug does the patch fix? What features does the patch add? This fixes the DB error in characters table that causes old characters' clients to not exhibit the new regen system. Newer characters have this flag when created. It does not implement the fix in the core; it only makes it so the client receives the correct regen flag. Somewhere after update to 3.0.3, a line "SetFlag(UNIT_FIELD_FLAGS_2, UNIT_FLAG2_REGENERATE_POWER);" was added to the create player method in player.cpp. There was never a corresponding sql update to give this flag to characters created before then, though. For which repository revision was the patch created? Tested on 7264. Is there a thread in the bug report section or at lighthouse? If yes, please add a link to the thread. http://getmangos.eu/community/viewtopic.php?id=5416 Who has been writing this patch? Please include either forum user names or email addresses. me delimiter // DROP FUNCTION IF EXISTS fix_regen// CREATE FUNCTION fix_regen (datastring longtext) RETURNS longtext BEGIN declare i int default 0; declare back longtext default datastring; declare front longtext default ""; while i < 59 do set front = concat(front, substring(back, 1, instr(back, " "))); set back = substring(back, instr(back, " ") + 1); set i = i+1; end while; set back = substring(back, instr(back, " ") + 1); return concat(front,"2048 ",back); END; // delimiter ; Update characters set data = fix_regen(`data`);

Without spell-ids it never did happen! http://getmangos.eu/community/topic/7568/guide-how-to-post-a-proper-bug-report/

Just tried using the patch that is Under Review now and found something odd from console ahbot status returns Items loaded for Alliance=542, Horde=542, Neutral=542. Total = 1626 however from MySQL SELECT COUNT(*) FROM auction GROUP BY houseid returns the values 220, 202, 120 //Total is 542 Tested under FreeBSD, MaNGOS Rev 10637, No other patches

nanounico, maybe you could create some sort of top 10 script ? Like: Name: Score <1stname> <xp+level+experience+money> <2ndname> <xp+level+experience+money>

I wrote this topic http://getmangos.eu/community/showthread.php?12844-[bug-fix]Goblin-Rocket-Launcher-missing-spell_bonus_data-records&highlight= UDB 0.11.6 (387) for MaNGOS 9310 with SD2 SQL for rev. 1566. http://www.wowhead.com/?item=23836 Goblin Rocket Launcher has bonus from spell power. For example: (spellpower/dmg) 86 / ~1.3k 1235/ ~2.1k 1488/ ~2.5k The same problem is with http://www.wowhead.com/?spell=54998 This is my little patch DELETE FROM spell_bonus_data WHERE entry IN (46567,54757); INSERT INTO spell_bonus_data VALUES (46567,0,0,0,'Item - Goblin Rocket Launcher'), (54757,0,0,0,'Spell - Pyro Rocket'); Works correct on my server.