ckegg

just take out .GetRawValue() from that line

I am surprised there are so many version of my script and none of them fixed critical bugs

-- nevermind VladimirMangos fixed problem on 10831

I don't know if you didn't read my posting or what, if you know a better way please feel free to rewrite it. There was a previous version that I use GO info stored in mangos but while in the half way I realized my server was a small server so I just did use database method for time save.

If you don't mind you can use this hack code to prevent blinking through door that I wrote for my server. It is not recommended for large server because it fetches SQL for object information. If someone can improve this or have better idea feel free to rewrite it. * this is only half of the code, the minus(deleting) code shouldn't be removed because it is part of my other code, just take a look on the adding parts * diff --git a/src/game/Spell.cpp b/src/game/Spell.cpp index 95e6580..85e3867 100644 --- a/src/game/Spell.cpp +++ b/src/game/Spell.cpp @@ -4302,24 +4302,43 @@ SpellCastResult Spell::CheckCast(bool strict) case SPELL_EFFECT_LEAP: case SPELL_EFFECT_TELEPORT_UNITS_FACE_CASTER: { - float dis = GetSpellRadius(sSpellRadiusStore.LookupEntry(m_spellInfo->EffectRadiusIndex[i])); - float fx = m_caster->GetPositionX() + dis * cos(m_caster->GetOrientation()); - float fy = m_caster->GetPositionY() + dis * sin(m_caster->GetOrientation()); - // teleport a bit above terrain level to avoid falling below it - float fz = m_caster->GetBaseMap()->GetHeight(fx, fy, m_caster->GetPositionZ(), true); - if(fz <= INVALID_HEIGHT) // note: this also will prevent use effect in instances without vmaps height enabled - return SPELL_FAILED_TRY_AGAIN; - - float caster_pos_z = m_caster->GetPositionZ(); - // Control the caster to not climb or drop when +-fz > 8 - if(!(fz <= caster_pos_z + 8 && fz >= caster_pos_z - 8)) - return SPELL_FAILED_TRY_AGAIN; - // not allow use this effect at battleground until battleground start if(m_caster->GetTypeId() == TYPEID_PLAYER) if(BattleGround const *bg = ((Player*)m_caster)->GetBattleGround()) if(bg->GetStatus() != STATUS_IN_PROGRESS) return SPELL_FAILED_TRY_AGAIN; + + //check door + bool findDoor = false; + float dis = GetSpellRadius(sSpellRadiusStore.LookupEntry(m_spellInfo->EffectRadiusIndex[i])); + + QueryResult *result = WorldDatabase.PQuery("SELECT id, " + "(POW(position_x - '%f', 2) + POW(position_y - '%f', 2) + POW(position_z - '%f', 2)) AS order_ " + "FROM gameobject WHERE map='%u' AND (POW(position_x - '%f', 2) + POW(position_y - '%f', 2) + POW(position_z - '%f', 2)) <= '%f' ORDER BY order_", + m_caster->GetPositionX(), m_caster->GetPositionY(), m_caster->GetPositionZ(), + m_caster->GetMapId(),m_caster->GetPositionX(), m_caster->GetPositionY(), m_caster->GetPositionZ(), dis*dis+5); + + if (result) + { + do + { + Field *fields = result->Fetch(); + uint32 entry = fields[0].GetUInt32(); + + GameObjectInfo const * pDoor = sObjectMgr.GetGameObjectInfo(entry); + + if(!pDoor) + continue; + + if ( pDoor->type == GAMEOBJECT_TYPE_DOOR ) + findDoor = true; + + } while (result->NextRow()); + delete result; + } + if ( findDoor ) + return SPELL_FAILED_TRY_AGAIN; + break; } case SPELL_EFFECT_STEAL_BENEFICIAL_BUFF:

Mangos Version: 10479 [problem begins around 1042x] Custom Patches: none SD2 Version: none Database Name and Version : YTDB 563 How it SHOULD work: Display correct locale text in game How it DOES work: Now it is only displaying english (name from template), localization is not working. Last test: 2010-09-12 18:02:39 >> Loaded 15841 gameobject locale strings 2010-09-12 18:02:40 >> Loaded 1676 PageText locale strings 2010-09-12 18:02:40 >>> Localization strings loaded login game and check around objects, ex: mailbox, chair, store sign, mine, and any books in game, all display name/content from template, not from locales_gameobject or locales_page_text However, all other localization are working fine, creature name, npc chat, quest, and item.

In rev.10342 when doing the following command will crash the server also send items username "title" "content" 22502 22503 22498 22501 22497 22496 22500 22499 23062

The enchanting spell "Black Magic" got the same problem too http://www.wowhead.com/spell=59630 After the SQL ERROR: Duplicate entry log , the next one is SQL ROLLBACK, and everything before that is reverted,

I just apply patches on my server, will see. I was grouping with them, but I was outside of the instance. They were doing Instructor Razuvious in Naxx and I saw half of them dropped. They said they just casted Prayer of Fortitude.

Actually if you enter any instance and use group spells, or some area effect spells while you are grouped, freezes the client. Not really sure how to repeat it, but I can confirm. My testers said they only disconnected in instance.

Well, you just don't get it, just, oh well. I think you don't even know what are _locales_ tables do in database either. And, if you have a better solution to get the same spell ID but highest rank, let us know, and make sure it is not broken after a client switch with newer ranks on spell

You don't even understand Mangos either, that's why you are doing double work. I wrote the localization support in Playbot, you can check with change log. Just put enUS dbc in main dbc folder and create a sub-folder for your own language, like dbc\\FR and it isn't difficult to get a english one... just go to BZ official site and download the client It is good to see the progress on Playbot and everything is doing so great especially for blueboy's work in recently. I haven't update for a long time but I am still following this thread, I mean I just want to point out if someone is going wrong path, no matter if it is hard coded spells or if it is localization supported, just want to let you know there is something there already that can solve your problem more easily and efficiently.

dude, looks like you didn't dig this thread for localization spells issue; I mean you are doing meaningless work. Get a English DBC and your own French DBC then all your spells and mount will work. If you don't understand this please search for the solution.

My players just reported that if someone post an enchantment material such as Infinite Dust, which has no SellPrice, or item has no BuyPrice, buyer will stop buying ANY item until this item expires.......... Anyone wanna look into this?

My suggestion is, you can create a private vendor in GM island and put those on him. so eventually your AH should have those pop. Or, we can request a new table like "associate_ah_item_template", so ah bot will post something from it.