function show_player_auras_from_db($guid)
{
global $cDB;
$buffs = $cDB->selectCol("SELECT `spell` FROM `character_aura` WHERE `guid` = ?d GROUP BY `spell`", $guid);
foreach ($buffs as $aura) {
echo "<br>";
show_spell($aura, 0, 'aura');
}
}
echo "<tr><td class=reward> ";
show_item($ItemMail);
}
echo "</td></tr>";
}
if ($quest['RewSpell'] || $quest['RewSpellCast']) {
$learn = $quest['RewSpell'] ? $quest['RewSpell'] : $quest['RewSpellCast'];
$spell = getSpell($learn);
if ($spell) {
$spellName = getSpellName($spell);
} else {
$spellName = "Spell {$learn}";
}
echo '<tr><td class=mark>' . ($quest['RewSpell'] ? $lang['learn_spell'] : $lang['cast_spell']) . '</td></tr>';
echo "<tr><td class=reward> ";
show_spell($spell['id'], $spell['SpellIconID']);
echo " <a href=\"?spell={$spell['id']}\">{$spell['SpellName']}</a></td></tr>";
}
for ($i = 1; $i <= 5; $i++) {
switch (ABS($quest['RewRepValueId' . $i])) {
case 1:
$RepValueId[$i] = 10;
break;
case 2:
$RepValueId[$i] = 25;
break;
case 3:
$RepValueId[$i] = 75;
break;
case 4:
$RepValueId[$i] = 150;
function showEffectData($spell, $effect)
{
echo '<tr>';
echo '<th>Effect ' . ($effect - 1) . ':</th>';
echo '<td colspan=3>';
if ($spell['Effect_' . $effect] == 0) {
echo 'No Effect';
return;
} else {
$eff_id = $spell['Effect_' . $effect];
$aura = $spell['EffectApplyAuraName_' . $effect];
$itemId = $spell['EffectItemType_' . $effect];
$triggerId = $spell['EffectTriggerSpell_' . $effect];
$radius = $spell['EffectRadiusIndex_' . $effect];
$amount = getBasePointDesc($spell, $effect);
if ($aura == 107 or $aura == 108 or $aura == 109 or $aura == 112) {
$spellFamilyMask = $itemId;
$itemId = 0;
}
echo "({$eff_id}) " . getSpellEffectName($eff_id);
if ($aura) {
showAuraInfo($spell, $effect, $aura);
} else {
showEffectInfo($spell, $effect, $eff_id);
}
if ($spell['EffectAmplitude_' . $effect]) {
echo '<br>Interval: ' . $spell['EffectAmplitude_' . $effect] / 1000 . ' sec';
}
// Спелл
if ($triggerId) {
$trigger = getSpell($triggerId);
if ($trigger) {
echo '<table class=no_border><tbody><tr>';
echo '<td>';
show_spell($trigger['id'], $trigger['SpellIconID'], 'spellinfo');
echo '</td>';
echo '<td><a href="?spell=' . $trigger['id'] . '">' . $trigger['SpellName'] . '</a><br>Value: ' . $amount . '</td>';
echo '</tr></tbody></table>';
} else {
echo '<br>Err trigger spell id ' . $triggerId;
}
} else {
if ($itemId) {
$item = getItem($itemId);
if ($item) {
global $Quality;
$colorname = $item['Quality'];
echo "<table class=no_border><tbody><tr>";
echo "<td>";
show_item($item['entry'], $item['displayid'], 'spellinfo');
echo "</td>";
echo "<td><a class={$Quality[$colorname]} href=\"?item={$item['entry']}\">{$item['name']}</a>";
if ($amount > 1) {
echo " x" . $amount;
}
echo "</td>";
echo "</tr></tbody></table>";
} else {
echo "<br>Err item id " . $itemId;
}
} else {
if ($radius) {
echo "<br>Radius: " . getRadiusText($radius);
}
if ($amount != 0) {
echo "<br>Value: " . $amount;
}
}
}
}
echo "</td>";
echo "</tr>";
}
function r_spellIcon($data)
{
show_spell($data['id'], $data['SpellIconID']);
}