gideon

In Spelleffects.cpp:

+case 45109:

+        {

+        // Greengill Slave Freed

+        m_caster->CastSpell(m_caster, 45110, true);

+         return;

+        }

       case 45030:                                                                 // Impale Emissary

       {

Maybe not 100% as seems like area spell and effects as is only 1 credit at a time.

outdoor_pvp_035-6452.patch

doesnt address any sql issues you may/may not have.

So with all the dupe entry errors I get I decided to change the format from INSERT to REPLACE..

Thus far it has removed all dupe entry errors.. BUT.

Is there something that could be wrong by doing this ?

I have noticed NO change aside from less error spam. If you DO know of any adverse side effects that could come from this please share

so, go find the following in Pet.cpp

if (i == 3 && !itr->second->IsPassive())
                       CharacterDatabase.PExecute("INSERT INTO pet_aura (guid,caster_guid,spell,effect_index,amount,maxduration,remaintime,remainchar
ges) "
                               "VALUES
('%u', '" I64FMTD "', '%u', '%u', '%d', '%d', '%d', '%d')",
                               m_charmInfo->GetPetNumber(), itr->second->GetCasterGUID(),
(uint32)(*itr).second->GetId(), (uint32)(*itr).second->GetEffIndex(),
(*itr).second->GetModifier()->m_amount,int((*itr).second->GetAuraMaxDuration()),int((*itr).second->GetAuraDuration()),int((*itr).second->m_procCharges));
       }

and change it to:

if (i == 3 && !itr->second->IsPassive())
                       CharacterDatabase.PExecute("REPLACE INTO pet_aura (guid,caster_guid,spell,effect_index,amount,maxduration,remaintime,remainchar
ges) "
                               "VALUES
('%u', '" I64FMTD "', '%u', '%u', '%d', '%d', '%d', '%d')",
                               m_charmInfo->GetPetNumber(), itr->second->GetCasterGUID(),
(uint32)(*itr).second->GetId(), (uint32)(*itr).second->GetEffIndex(),
(*itr).second->GetModifier()->m_amount,int((*itr).second->GetAuraMaxDuration()),int((*itr).second->GetAuraDuration()),int((*itr).second->m_procCharges));
       }

laters

Updated:

outdoor_pvp_035-6440.patch

<div class='quotetop'>QUOTE (w12x @ Jul 31 2008, 04:38 PM) <{POST_SNAPBACK}></div>

I beg to differ, I just updated my source to 6408 without conflict...[/b]

agreed, 6408 no conflict.