module/show/show_quest.php

   1 <?php
   2 include_once("conf.php");
   3 include_once("include/functions.php");
   4
   5 function getQuestText($quest_text)
   6 {
   7   $letter = array( '$b' ,'$B$B', '$B' ,  '$N'  ,   '$n'  , '$C'    ,   '$c'  ,  '$r'  ,  '$R'  ,'<a' ,'<A');
   8   $values = array('<br>','<br>','<br>','(Name)', '(Name)','(Class)','(Class)','(Race)','(Race)','< a','< A');
   9   return str_replace($letter, $values, $quest_text);
  10 }
  11
  12 function renderReqCollect($item_id, $maxcount, $count)
  13 {
  14  if (!$item_id > 0)
  15    return;
  16  $name=getItemName($item_id);
  17  echo "<tr><td>&nbsp;&nbsp;<a href=\"?item=$item_id\">$name</a>:&nbsp;$count/$maxcount</td></tr>";
  18 }
  19
  20 function renderReqKillOrCast($text,$ReqCreatureOrGOId,$ReqCreatureOrGOCount,$ReqSpellCast, $count)
  21 {
  22  global $lang;
  23  if ($ReqCreatureOrGOId>0)
  24  {
  25   echo "<tr><td><a style='float: right;' href=\"?map&npc=$ReqCreatureOrGOId\">$lang[map]</a>&nbsp;&nbsp;";
  26   if ($ReqSpellCast==0) // Требуется убить моба
  27   {
  28    if ($text)
  29      echo "<a href=\"?npc=$ReqCreatureOrGOId\">$text</a>";
  30    else
  31      echo $lang['kill'].'&nbsp;'.getCreatureName($ReqCreatureOrGOId);
  32   }
  33   else
  34   {
  35 //    $spell_name=getSpellName($ReqSpellCast);
  36     if (!$text) $text = $lang['cast'];
  37     echo "<a href=\"?spell=$ReqSpellCast\">$text</a>&nbsp;$lang[cast_on]&nbsp;".getCreatureName($ReqCreatureOrGOId);
  38   }
  39   echo ":&nbsp;$count/$ReqCreatureOrGOCount</td></tr>";
  40  }
  41  else if ($ReqCreatureOrGOId<0)
  42  {
  43   $ReqCreatureOrGOId=-$ReqCreatureOrGOId;
  44   echo "<tr><td><a style='float: right;' href=\"?map&obj=$ReqCreatureOrGOId\">$lang[map]</a>&nbsp;&nbsp;";
  45   if ($ReqSpellCast==0) // Требуется использовать геймобьект
  46   {
  47    if ($text)
  48      echo "<a href=\"?object=$ReqCreatureOrGOId\">$text</a>";
  49    else
  50      echo $lang['use'].'&nbsp;'.getGameobjectName($ReqCreatureOrGOId);
  51   }
  52   else
  53   {
  54     if (!$text) $text = $lang['cast'];
  55 //    $spell_name=getSpellName($ReqSpellCast);
  56     echo "<a href=\"?spell=$ReqSpellCast\">$text</a> $lang[cast_on]&nbsp;".getGameobjectName($ReqCreatureOrGOId);
  57   }
  58   echo ":&nbsp;$count/$ReqCreatureOrGOCount</td></tr>";
  59  }
  60 }
  61 function renderQuestSource($srcID, $srcCount)
  62 {
  63  if (!$srcID)
  64    return;
  65  $name=getItemName($srcID);
  66  echo "<tr><td>&nbsp;&nbsp;<a href=\"?item=$srcID\">$name</a>".($srcCount?'&nbsp;x&nbsp;'.$srcCount:'').'</td></tr>';
  67 }
  68
  69 ########
  70
  71 $entry = intval(@$_REQUEST['quest']);
  72 $guid  = intval(@$_REQUEST['guid']);
  73
  74 $quest=getQuest($entry);
  75 if (!$quest)
  76 {
  77   RenderError("$lang[quest_not_found1]");
  78 }
  79 else
  80 {
  81  $q_status = 0;
  82  if ($guid)
  83    $q_status = $cDB->selectRow("SELECT * FROM `character_queststatus` WHERE `guid` = ?d AND `quest` = ?d", $guid, $entry);
  84  if ($lang['www_quest'])
  85         echo "<a href=\"".sprintf($lang['www_quest'], $entry)."\" target=\"_blank\"\">".sprintf($lang['www_quest'], $entry)."</a><br>";
  86
  87  echo "<table class=quest width=550>";
  88  echo "<tbody>";
  89
  90  echo "<tr><td class=head>$quest[Title]";
  91
  92  if ($quest['Type'])
  93    echo "<br><FONT size=-3>&lt;".getQuestType($quest['Type'])."&gt;</FONT>";
  94
  95  if (getAllowableRace($quest['RequiredRaces']) && ($quest['RequiredRaces'] & 1101) && ($quest['RequiredRaces'] !=1791))
  96  {
  97      echo "<br><FONT color=#0000ff>$lang[required_races]&nbsp;$lang[Alliance]&nbsp;</FONT><img width=22 height=22 src='images/player_info/factions_img/alliance.gif'>";
  98      echo '<br><FONT color=#0000ff>'.$game_text['allowable_race'].'&nbsp;'.getAllowableRace($quest['RequiredRaces']).'</FONT>';
  99  }
 100
 101 if (getAllowableRace($quest['RequiredRaces']) && ($quest['RequiredRaces'] & 690) && ($quest['RequiredRaces'] !=1791))
 102  {
 103      echo "<br><FONT color=#ff0000>$lang[required_races]&nbsp;$lang[Horde]&nbsp;</FONT><img width=22 height=22 src='images/player_info/factions_img/horde.gif'>";
 104      echo '<br><FONT color=#ff0000>'.$game_text['allowable_race'].'&nbsp;'.getAllowableRace($quest['RequiredRaces']).'</FONT>';
 105  }
 106
 107 if (($quest['RequiredRaces'] == 0) OR ($quest['RequiredRaces'] == 1791))
 108  {
 109      echo "</br>";
 110      echo "<br><FONT color=#008800>$lang[required_races]&nbsp;$lang[Both]</FONT>";
 111      echo '<br><FONT color=#008800>'.$game_text['allowable_race'].'&nbsp;'.getAllowableRace(1791).'</FONT>';
 112  }
 113
 114  if (getAllowableClass($quest['RequiredClasses']))
 115      echo '<br><FONT color=#000000>'.$game_text['allowable_class'].'&nbsp;'.getQAllowableClass($quest['RequiredClasses']).'</FONT>';
 116
 117  if ($entry == getQuestOld($entry))
 118     echo '<br><FONT color=#ff0000><b>'.$lang['quest_marked'].'</FONT></b>';
 119
 120  echo "</th></tr>";
 121  echo "</th></tr>";
 122
 123  echo '<tr><td>';
 124  if ($quest['ZoneOrSort']>0)
 125    echo "<a style='float: right;' href=\"?s=q&ZoneID=".$quest['ZoneOrSort']."\">".getAreaName($quest['ZoneOrSort'], 0)."</a>";
 126  else
 127  if ($quest['ZoneOrSort']<0 AND ((-$quest['ZoneOrSort']) >= 374 OR (-$quest['ZoneOrSort']) == 221 OR (-$quest['ZoneOrSort']) == 241 OR ((-$quest['ZoneOrSort']) >= 344 AND (-$quest['ZoneOrSort']) < 371) or
 128     (-$quest['ZoneOrSort']) == 284 OR (-$quest['ZoneOrSort']) == 25 OR (-$quest['ZoneOrSort']) == 41 OR (-$quest['ZoneOrSort']) < 24))
 129    echo "<a style='float: right;' href=\"?s=q&SortID=".(-$quest['ZoneOrSort'])."\">".getQuestSort(-$quest['ZoneOrSort'], 0)."</a>";
 130
 131  echo "$lang[quest_level]&nbsp;$quest[QuestLevel]<br>";
 132
 133 if ($quest['RequiredSkill'])
 134    echo "<a style='float: right;' href=\"?s=q&SkillID=".($quest['RequiredSkill'])."\">".getSkillName($quest['RequiredSkill'], 0)."&nbsp;($quest[RequiredSkillValue])</a>";
 135
 136  if ($quest['MinLevel'])
 137  echo "$lang[obtained_at_level]&nbsp;$quest[MinLevel]</td></tr>";
 138
 139  if ($quest['SuggestedPlayers'])
 140      echo "<tr><td>$lang[suggestedplayers]&nbsp;<b>$quest[SuggestedPlayers]</b></td></tr>";
 141
 142  if ($quest['LimitTime'])
 143      echo '<tr><td>'.$lang['qlimittime'].'&nbsp;'.getTimeText($quest['LimitTime']).'</td></tr>';
 144
 145  if (getGameEventQuest($quest['entry']))
 146   {
 147   $qevent=getGameEventQuest($quest['entry']);
 148    echo '<tr><td>'.$lang['obtained_at_event'].':&nbsp;<FONT color=#E614E6>'.getGameEventName($qevent).'</FONT></td></tr>';
 149   }
 150
 151  if ($quest['SpecialFlags'] & QUEST_SPECIAL_FLAG_MONTHLY)
 152      echo "<tr><td>$lang[item_type]:&nbsp;<a href=\"?s=q&Sfm=".($quest['SpecialFlags'])."\">".$lang['quest_type3']."</a></td></tr>";
 153
 154  if ($quest['QuestFlags'] & QUEST_FLAGS_WEEKLY)
 155      echo "<tr><td>$lang[item_type]:&nbsp;<a href=\"?s=q&Sfw=".($quest['QuestFlags'])."\">".$lang['quest_type2']."</a></td></tr>";
 156
 157  if ($quest['QuestFlags'] & QUEST_FLAGS_DAILY)
 158      echo "<tr><td>$lang[item_type]:&nbsp;<a href=\"?s=q&Sfd=".($quest['QuestFlags'])."\">".$lang['quest_type1']."</a></td></tr>";
 159
 160  if (($quest['SpecialFlags'] & QUEST_SPECIAL_FLAG_REPEATABLE) && (($quest['SpecialFlags'] & QUEST_SPECIAL_FLAG_MONTHLY) ==0) && ($quest['QuestFlags'] & (QUEST_FLAGS_DAILY | QUEST_FLAGS_WEEKLY))  == 0)
 161      echo "<tr><td>$lang[item_type]:&nbsp;<a href=\"?s=q&Sfr=".($quest['SpecialFlags'])."\">".$lang['quest_type0']."</a></td></tr>";
 162
 163  if ($quest['RequiredMinRepFaction'])
 164    echo "<tr><td>$lang[item_faction_rank]:</td></tr>";
 165
 166  if ($quest['RequiredMinRepFaction'])
 167    echo "<tr><td> ".getFactionName($quest['RequiredMinRepFaction']).":&nbsp;$quest[RequiredMinRepValue]($lang[item_min_level])</td></tr>";
 168
 169  if ($quest['RequiredMaxRepFaction'])
 170    echo "<tr><td>".getFactionName($quest['RequiredMaxRepFaction']).":&nbsp;$quest[RequiredMaxRepValue]($lang[item_max_level])</td></tr>";
 171
 172  $questobjectives = getQuestText($quest['Objectives']);
 173  $questrequestitemstext = getQuestText($quest['RequestItemsText']);
 174  $questofferrewardtext = getQuestText($quest['OfferRewardText']);
 175  if ($questobjectives)
 176    echo "<tr><td>$questobjectives<hr></td></tr>";
 177      else  if ($questrequestitemstext)
 178        echo "<tr><td>$questrequestitemstext<hr></td></tr>";
 179          else  if ($questofferrewardtext)
 180            echo "<tr><td>$questofferrewardtext<hr></td></tr>";
 181
 182  ### Рек собрать
 183  if ($quest['RepObjectiveFaction'])
 184    echo "<tr><td>$lang[item_faction_rank]:</td></tr>";
 185
 186  if ($quest['RepObjectiveFaction'])
 187    echo "<tr><td>".getFactionName($quest['RepObjectiveFaction']).":&nbsp;$quest[RepObjectiveValue]($lang[item_min_level])</td></tr>";
 188
 189  if ($quest['ReqItemId1'] OR $quest['ReqItemId2'] OR $quest['ReqItemId3'] OR $quest['ReqItemId4'] OR $quest['ReqItemId5'] OR $quest['ReqItemId6'])
 190  {
 191   echo "<tr><td class=mark>$lang[collect]</td></tr>";
 192   renderReqCollect($quest['ReqItemId1'],$quest['ReqItemCount1'],$q_status?$q_status['itemcount1']:0);
 193   renderReqCollect($quest['ReqItemId2'],$quest['ReqItemCount2'],$q_status?$q_status['itemcount2']:0);
 194   renderReqCollect($quest['ReqItemId3'],$quest['ReqItemCount3'],$q_status?$q_status['itemcount3']:0);
 195   renderReqCollect($quest['ReqItemId4'],$quest['ReqItemCount4'],$q_status?$q_status['itemcount4']:0);
 196   renderReqCollect($quest['ReqItemId5'],$quest['ReqItemCount5'],$q_status?$q_status['itemcount5']:0);
 197   renderReqCollect($quest['ReqItemId6'],$quest['ReqItemCount6'],$q_status?$q_status['itemcount6']:0);
 198  }
 199 ###
 200 ### Рек убить
 201 if ($quest['ReqCreatureOrGOId1'] != 0 OR $quest['ReqCreatureOrGOId2'] != 0 OR
 202     $quest['ReqCreatureOrGOId3'] != 0 OR $quest['ReqCreatureOrGOId4'] != 0 )
 203 {
 204 // echo "<tr><td class=mark>$lang[kill]</td></tr>";
 205  renderReqKillOrCast($quest['ObjectiveText1'],$quest['ReqCreatureOrGOId1'],$quest['ReqCreatureOrGOCount1'],$quest['ReqSpellCast1'],$q_status?$q_status['mobcount1']:0);
 206  renderReqKillOrCast($quest['ObjectiveText2'],$quest['ReqCreatureOrGOId2'],$quest['ReqCreatureOrGOCount2'],$quest['ReqSpellCast2'],$q_status?$q_status['mobcount2']:0);
 207  renderReqKillOrCast($quest['ObjectiveText3'],$quest['ReqCreatureOrGOId3'],$quest['ReqCreatureOrGOCount3'],$quest['ReqSpellCast3'],$q_status?$q_status['mobcount3']:0);
 208  renderReqKillOrCast($quest['ObjectiveText4'],$quest['ReqCreatureOrGOId4'],$quest['ReqCreatureOrGOCount4'],$quest['ReqSpellCast4'],$q_status?$q_status['mobcount4']:0);
 209 }
 210
 211 if ($quest['ReqSourceId1'] != 0 OR $quest['ReqSourceId2'] != 0 OR
 212     $quest['ReqSourceId3'] != 0 OR $quest['ReqSourceId4'] != 0 )
 213 {
 214  echo "<tr><td class=mark>$lang[req_items]</td></tr>";
 215  renderQuestSource($quest['ReqSourceId1'],$quest['ReqSourceCount1']);
 216  renderQuestSource($quest['ReqSourceId2'],$quest['ReqSourceCount2']);
 217  renderQuestSource($quest['ReqSourceId3'],$quest['ReqSourceCount3']);
 218  renderQuestSource($quest['ReqSourceId4'],$quest['ReqSourceCount4']);
 219 }
 220
 221 ###
 222 echo "<tr><td>".getQuestText($quest['Details'])."</td></tr>";
 223  if ($quest['CompletedText'])
 224 {
 225    echo "<tr><td class=head>$lang[quest_completed]</td></tr>";
 226    echo '<tr><td>'.$quest['CompletedText'].'</td></tr>';
 227 }
 228 if ($quest['SrcItemId'] || $quest['SrcSpell'])
 229 {
 230  echo "<tr><td class=head>$lang[provided]</td></tr>";
 231  if ($quest['SrcItemId'])
 232  {
 233    $item = getItem($quest['SrcItemId'], "`entry`, `name`, `Quality`, `displayid`");
 234    echo '<tr><td class=reward>&nbsp;'.text_show_item($item['entry'], $item['displayid']);
 235    echo '&nbsp;<a class='.$Quality[$item['Quality']].' href="?item='.$item['entry'].'">'.$item['name'].'</a>';
 236    if ($quest['SrcItemCount']>1) echo "&nbsp;x$quest[SrcItemCount]";
 237    echo "</td></tr>";
 238  }
 239  if ($quest['SrcSpell'])
 240  {
 241   $spell=getSpell($quest['SrcSpell']); // Кастуемый спелл
 242   if ($spell) $spellName = getSpellName($spell);
 243   else        $spellName = "Spell $quest[SrcSpell]";
 244   echo "<tr><td class=reward>&nbsp;";show_spell($spell['id'], $spell['SpellIconID']);
 245   echo " <a href=\"?spell=$spell[id]\">$spell[SpellName]</a></td></tr>";
 246  }
 247 }
 248 echo "<tr><td class=head>$lang[quest_rewards]</td></tr>";
 249
 250 if ($quest['RewItemId1'] OR $quest['RewItemId1'] OR $quest['RewItemId1'] OR $quest['RewItemId1'])
 251 {
 252  echo "<tr><td class=mark>$lang[Rew_item]</td></tr>";
 253  echo "<tr><td class=reward>&nbsp;";
 254  if ($quest['RewItemId1']) {show_item($quest['RewItemId1']);}
 255  if ($quest['RewItemId2']) {echo $lang['item_sel_and'];show_item($quest['RewItemId2']);}
 256  if ($quest['RewItemId3']) {echo $lang['item_sel_and'];show_item($quest['RewItemId3']);}
 257  if ($quest['RewItemId4']) {echo $lang['item_sel_and'];show_item($quest['RewItemId4']);}
 258  echo "</td></tr>";
 259 }
 260 if ($quest['RewChoiceItemId1'] OR $quest['RewChoiceItemId2'] OR $quest['RewChoiceItemId3'] OR
 261     $quest['RewChoiceItemId4'] OR $quest['RewChoiceItemId5'] OR $quest['RewChoiceItemId6'])
 262 {
 263  echo "<tr><td class=mark>$lang[Rew_select_item]</td></tr>";
 264  echo "<tr><td class=reward>&nbsp;";
 265  if ($quest['RewChoiceItemId1']) {show_item($quest['RewChoiceItemId1']);}
 266  if ($quest['RewChoiceItemId2']) {echo $lang['item_sel_or'];show_item($quest['RewChoiceItemId2']);}
 267  if ($quest['RewChoiceItemId3']) {echo $lang['item_sel_or'];show_item($quest['RewChoiceItemId3']);}
 268  if ($quest['RewChoiceItemId4']) {echo $lang['item_sel_or'];show_item($quest['RewChoiceItemId4']);}
 269  if ($quest['RewChoiceItemId5']) {echo $lang['item_sel_or'];show_item($quest['RewChoiceItemId5']);}
 270  if ($quest['RewChoiceItemId6']) {echo $lang['item_sel_or'];show_item($quest['RewChoiceItemId6']);}
 271  echo "</td></tr>";
 272 }
 273 if ($quest['RewMailTemplateId'])
 274 {
 275  $MailTime=$quest['RewMailDelaySecs']/60/60;
 276  $ItemMail=getItemMail($quest['RewMailTemplateId']);
 277  echo "<tr><td class=mark>$lang[Rew_mail]&nbsp;$lang[Mail_item_time]".$MailTime."$lang[Mail_time]";
 278  if ($ItemMail)
 279   {
 280     echo "<tr><td class=mark>$lang[Rew_item_mail]</td></tr>";
 281     echo "<tr><td class=reward>&nbsp;";{show_item($ItemMail);}
 282   }
 283     echo "</td></tr>";
 284 }
 285 if ($quest['RewSpell'] || $quest['RewSpellCast'])
 286 {
 287  $learn = $quest['RewSpell'] ? $quest['RewSpell'] : $quest['RewSpellCast'];
 288  $spell=getSpell($learn);
 289  if ($spell) $spellName = getSpellName($spell);
 290  else        $spellName = "Spell $learn";
 291  echo '<tr><td class=mark>'.($quest['RewSpell']?$lang['learn_spell']:$lang['cast_spell']).'</td></tr>';
 292  echo "<tr><td class=reward>&nbsp;";show_spell($spell['id'], $spell['SpellIconID']);
 293  echo " <a href=\"?spell=$spell[id]\">$spell[SpellName]</a></td></tr>";
 294 }
 295
 296 for ($i = 1; $i <= 5; $i++)
 297 {
 298  switch (ABS($quest['RewRepValueId'.$i])):
 299   case 1:  $RepValueId[$i] = 10;   break;
 300   case 2:  $RepValueId[$i] = 25;   break;
 301   case 3:  $RepValueId[$i] = 75;   break;
 302   case 4:  $RepValueId[$i] = 150;  break;
 303   case 5:  $RepValueId[$i] = 250;  break;
 304   case 6:  $RepValueId[$i] = 350;  break;
 305   case 7:  $RepValueId[$i] = 500;  break;
 306   case 8:  $RepValueId[$i] = 1000; break;
 307   case 9:  $RepValueId[$i] = 5;    break;
 308   default: $RepValueId[$i] = 0;
 309  endswitch;
 310
 311  $quest_rate[$i] = getRepRewRate($quest['RewRepFaction'.$i]);
 312
 313  if ($quest['RewRepValueId'.$i] < 0)
 314   $RepValueId[$i] = -$RepValueId[$i];
 315
 316  if ($quest['RewRepValue'.$i] && $quest['RewRepValueId'.$i])
 317   $quest['RewRepValue'.$i] = $quest['RewRepValue'.$i]/100;
 318
 319  if (!$quest['RewRepValue'.$i] && $quest['RewRepValueId'.$i])
 320   $quest['RewRepValue'.$i] = $RepValueId[$i];
 321
 322  $quest['RewRepValue'.$i]=$quest['RewRepValue'.$i]*$quest_rate[$i];
 323 }
 324
 325  if ($quest['RewRepFaction1'] AND !$quest['RewRepFaction2'] AND
 326     !$quest['RewRepFaction3'] AND !$quest['RewRepFaction4'] AND
 327     !$quest['RewRepFaction5'])
 328  {
 329   $spillover=getRepSpillover($quest['RewRepFaction1']);
 330   if ($spillover)
 331    foreach ($spillover as $faction)
 332    {
 333      if ($faction['faction1'])
 334      {
 335      $quest['RewRepFaction2']=$faction['faction1'];
 336      $quest['RewRepValue2']=$quest['RewRepValue1']*$faction['rate_1'];
 337      }
 338      if ($faction['faction2'])
 339      {
 340      $quest['RewRepFaction3']=$faction['faction2'];
 341      $quest['RewRepValue3']=$quest['RewRepValue1']*$faction['rate_2'];
 342      }
 343      if ($faction['faction3'])
 344      {
 345      $quest['RewRepFaction4']=$faction['faction3'];
 346      $quest['RewRepValue4']=$quest['RewRepValue1']*$faction['rate_3'];
 347      }
 348      if ($faction['faction4'])
 349      {
 350      $quest['RewRepFaction5']=$faction['faction4'];
 351      $quest['RewRepValue5']=$quest['RewRepValue1']*$faction['rate_4'];
 352      }
 353    }
 354  }
 355
 356 if ($quest['RewRepFaction1'] OR $quest['RewRepFaction2'] OR
 357     $quest['RewRepFaction3'] OR $quest['RewRepFaction4'] OR
 358     $quest['RewRepFaction5'])
 359 {
 360  echo "<tr><td class=mark>$lang[Rew_reputation]</td></tr>";
 361  if ($quest['RewRepFaction1'] && $quest['RewRepValue1'])echo "<tr><td>&nbsp;".getFactionName($quest['RewRepFaction1']).":&nbsp;$quest[RewRepValue1]</td></tr>";
 362  if ($quest['RewRepFaction2'] && $quest['RewRepValue2'])echo "<tr><td>&nbsp;".getFactionName($quest['RewRepFaction2']).":&nbsp;$quest[RewRepValue2]</td></tr>";
 363  if ($quest['RewRepFaction3'] && $quest['RewRepValue3'])echo "<tr><td>&nbsp;".getFactionName($quest['RewRepFaction3']).":&nbsp;$quest[RewRepValue3]</td></tr>";
 364  if ($quest['RewRepFaction4'] && $quest['RewRepValue4'])echo "<tr><td>&nbsp;".getFactionName($quest['RewRepFaction4']).":&nbsp;$quest[RewRepValue4]</td></tr>";
 365  if ($quest['RewRepFaction5'] && $quest['RewRepValue5'])echo "<tr><td>&nbsp;".getFactionName($quest['RewRepFaction5']).":&nbsp;$quest[RewRepValue5]</td></tr>";
 366 }
 367 if($quest['RewMoneyMaxLevel'])  echo "<tr><td class=mark>$lang[Rew_XP]&nbsp;".getQuestXPValue($quest)."&nbsp;xp";
 368 if($quest['RewHonorAddition'] OR $quest['RewHonorMultiplier'])
 369 {
 370 if ($quest['RewHonorMultiplier'])
 371   $ihonor=round(getTeamContributionPoints(79)*$quest['RewHonorMultiplier']*0.1+$quest['RewHonorAddition']);
 372 else
 373  $ihonor=round($quest['RewHonorAddition']);
 374  echo "<tr><td class=mark>$lang[Rew_honor]&nbsp;".substr($ihonor, 0, 4);
 375 }
 376 if($quest['RewOrReqMoney']) echo "<tr><td class=mark>$lang[Rew_money]&nbsp;".money($quest['RewOrReqMoney'])."</td></tr>";
 377 ###
 378
 379 $number = 0;
 380 echo "<tr><td class = head>$lang[start]:</td></tr>";
 381 if ($rows = $dDB->select("SELECT *
 382                           FROM `creature_template` join `creature_questrelation`
 383                           WHERE
 384                           `creature_questrelation`.`quest` = ?d AND
 385                           `creature_questrelation`.`id` = `creature_template`.`entry`", $quest['entry']))
 386 foreach ($rows as $creature)
 387 {
 388   localiseCreature($creature);
 389   $loyality = getLoyality($creature['faction_A']);
 390   echo "<tr><td><a style='float: right;' href=\"?map&npc=$creature[entry]\">$lang[map]</a>";
 391   echo "<a href=\"?npc=$creature[entry]\">$creature[name]</a> ($loyality)";
 392   if ($creature['subname'] != "")
 393    echo "<br><FONT color=#008800 size=-3>&lt;$creature[subname]&gt;</FONT>";
 394   echo "</td></tr>";
 395   $number++;
 396 }
 397
 398 if ($rows = $dDB->select("SELECT *
 399                           FROM `gameobject_template` join `gameobject_questrelation`
 400                           WHERE
 401                           `gameobject_questrelation`.`quest` = ?d AND
 402                           `gameobject_questrelation`.`id` = `gameobject_template`.`entry`", $quest['entry']))
 403 foreach ($rows as $go)
 404 {
 405   localiseGameobject($go);
 406   echo "<tr><td><a style='float: right;' href=\"?map&obj=$go[entry]\">$lang[map]</a>";
 407   echo "<a href=\"?object=$go[entry]\">$go[name]</a></td></tr>";
 408   $number++;
 409 }
 410
 411 if ($rows = $dDB->select("SELECT `entry`, `name`,`Quality`, `displayid` FROM `item_template` WHERE `startquest` = ?d", $quest['entry']))
 412 foreach ($rows as $item)
 413 {
 414  localiseItem($item);
 415  echo '<tr><td class=reward>&nbsp;'.text_show_item($item['entry'], $item['displayid']);
 416  echo '&nbsp;<a class='.$Quality[$item['Quality']].' href="?item='.$item['entry'].'">'.$item['name'].'</a>';
 417  $number++;
 418 }
 419
 420 if ($number==0)
 421 echo "<tr><td bgColor=#ff0000>$lang[quest_not_found]</td></tr>";
 422
 423 $number = 0;
 424 echo "<tr><td class = head>$lang[end_q]:</td></tr>";
 425 if ($rows = $dDB->select("SELECT *
 426                           FROM `creature_template` join `creature_involvedrelation`
 427                           WHERE
 428                           `creature_involvedrelation`.`quest` = ?d AND
 429                           `creature_involvedrelation`.`id` = `creature_template`.`entry`", $quest['entry']))
 430 foreach ($rows as $creature)
 431 {
 432   localiseCreature($creature);
 433   $loyality = getLoyality($creature['faction_A']);
 434   echo "<tr><td><a style='float: right;' href=\"?map&npc=$creature[entry]\">$lang[map]</a>";
 435   echo "<a href=\"?npc=$creature[entry]\">$creature[name]</a> ($loyality)";
 436   if ($creature['subname'] != "")
 437    echo "<br><FONT color=#008800 size=-3>&lt;$creature[subname]&gt;</FONT>";
 438   echo "</td></tr>";
 439   $number++;
 440 }
 441
 442 if ($rows = $dDB->select("SELECT *
 443                           FROM `gameobject_template` join `gameobject_involvedrelation`
 444                           WHERE
 445                           `gameobject_involvedrelation`.`quest` = ?d AND
 446                           `gameobject_involvedrelation`.`id` = `gameobject_template`.`entry`", $quest['entry']))
 447 foreach ($rows as $go)
 448 {
 449   localiseGameobject($go);
 450   echo "<tr><td><a style='float: right;' href=\"?map&obj=$go[entry]\">$lang[map]</a>";
 451   echo "<a href=\"?object=$go[entry]\">$go[name]</a></td></tr>";
 452   $number++;
 453 }
 454
 455 if ($number==0)
 456 echo "<tr><td bgColor=#ff0000>$lang[quest_not_found]</td></tr>";
 457
 458 ### этот квест часть серии:
 459 $needForQuest = $dDB->selectRow("SELECT * FROM `quest_template` WHERE ABS(`PrevQuestId`) = ?d", $quest['entry']);
 460 if ($quest['PrevQuestId'] != 0 OR $quest['NextQuestId'] != 0 OR $needForQuest)
 461 {
 462  echo "<tr><td class = head>$lang[this_quest_is_part_of_a_series]</td></tr>";
 463  $step=0;
 464  // Разматываем цепочку квестов назад
 465  if ($quest['PrevQuestId']!=0)
 466  {
 467     $prevquest[0]=$quest;
 468     $list = 0;
 469     while ($prevquest[$list]['PrevQuestId']!=0)
 470     {
 471      $qbefore = getQuest(abs($prevquest[$list]['PrevQuestId']));
 472      if ($qbefore)
 473      {
 474       $prevquest[$list+1]=$qbefore;
 475       $list+=1;
 476      }
 477      else
 478      {
 479        $entry = $prevquest[$list]['PrevQuestId'];
 480        $prevquest[$list+1]['entry'] = $entry;
 481        $prevquest[$list+1]['Title'] = "Error qid = $entry";
 482        $prevquest[$list+1]['QuestLevel'] = "??";
 483        $list+=1;
 484        break;
 485      }
 486     }
 487     // Выводим все предыдущие квесты
 488     while ($step<$list)
 489     {
 490      $qinfo = $prevquest[$list-$step];
 491      echo "<tr><td>";
 492      echo "<div style='float: right;'>($lang[level]&nbsp;$qinfo[QuestLevel])</div>";
 493      if (getAllowableRace($qinfo['RequiredRaces']) && ($qinfo['RequiredRaces'] & 1101) && ($qinfo['RequiredRaces'] !=1791))
 494          echo "$lang[step]($step)&nbsp;<img width=14 height=14 src='images/player_info/factions_img/alliance.gif'>&nbsp;<a href=\"?quest=$qinfo[entry]\">$qinfo[Title]</a>";
 495      else
 496      if (getAllowableRace($qinfo['RequiredRaces']) && ($qinfo['RequiredRaces'] & 690) && ($qinfo['RequiredRaces'] !=1791))
 497          echo "$lang[step]($step)&nbsp;<img width=14 height=14 src='images/player_info/factions_img/horde.gif'>&nbsp;<a href=\"?quest=$qinfo[entry]\">$qinfo[Title]</a>";
 498      else
 499          echo "$lang[step]($step)&nbsp;<a href=\"?quest=$qinfo[entry]\">$qinfo[Title]</a>";
 500      echo "</td></tr>";
 501      $step++;
 502     }
 503  }
 504  echo "<tr><td>";
 505  echo "<div style='float: right;'>($lang[level]&nbsp;$quest[QuestLevel])</div>";
 506  if (getAllowableRace($quest['RequiredRaces']) && ($quest['RequiredRaces'] & 1101) && ($quest['RequiredRaces'] !=1791))
 507      echo "$lang[step]($step)&nbsp;<img width=14 height=14 src='images/player_info/factions_img/alliance.gif'>&nbsp;$quest[Title]";
 508  else
 509  if (getAllowableRace($quest['RequiredRaces']) && ($quest['RequiredRaces'] & 690) && ($quest['RequiredRaces'] !=1791))
 510      echo "$lang[step]($step)&nbsp;<img width=14 height=14 src='images/player_info/factions_img/horde.gif'>&nbsp;$quest[Title]";
 511  else
 512      echo "$lang[step]($step)&nbsp;$quest[Title]";
 513  echo "</td></tr>";
 514  $step++;
 515  // Пытаемся найти следующие квесты
 516  $nextquest = $quest;
 517  while($nextquest!=0)
 518  {
 519    // Сначала по полю NextQuestId
 520    if ($nextquest['NextQuestId']!=0)
 521    {
 522      $nextquest = getQuest(abs($nextquest['NextQuestId']));
 523      echo "<tr><td>";
 524      echo "<div style='float: right;'>($lang[level]&nbsp;$nextquest[QuestLevel])</div>";
 525      if (getAllowableRace($nextquest['RequiredRaces']) && ($nextquest['RequiredRaces'] & 1101) && ($nextquest['RequiredRaces'] !=1791))
 526          echo "$lang[step]($step)&nbsp;<img width=14 height=14 src='images/player_info/factions_img/alliance.gif'>&nbsp;<a href=\"?quest=$nextquest[entry]\">$nextquest[Title]</a>";
 527      else
 528      if (getAllowableRace($nextquest['RequiredRaces']) && ($nextquest['RequiredRaces'] & 690) && ($nextquest['RequiredRaces'] !=1791))
 529          echo "$lang[step]($step)&nbsp;<img width=14 height=14 src='images/player_info/factions_img/horde.gif'>&nbsp;<a href=\"?quest=$nextquest[entry]\">$nextquest[Title]</a>";
 530      else
 531          echo "$lang[step]($step)&nbsp;<a href=\"?quest=$nextquest[entry]\">$nextquest[Title]</a>";
 532      echo "</td></tr>";
 533    }
 534    // Если не вышло то по полю PrevQuestId = $nextquest[entry](у других квестов)
 535    else
 536    {
 537     if ($needForQuest)
 538     {
 539      localiseQuest($needForQuest);
 540      $nextquest=$needForQuest;
 541      echo "<tr><td>";
 542      echo "<div style='float: right;'>($lang[level]&nbsp;$nextquest[QuestLevel])</div>";
 543      if (getAllowableRace($nextquest['RequiredRaces']) && ($nextquest['RequiredRaces'] & 1101) && ($nextquest['RequiredRaces'] !=1791))
 544          echo "$lang[step]($step)&nbsp;<img width=14 height=14 src='images/player_info/factions_img/alliance.gif'>&nbsp;<a href=\"?quest=$nextquest[entry]\">$nextquest[Title]</a>";
 545      else
 546      if (getAllowableRace($nextquest['RequiredRaces']) && ($nextquest['RequiredRaces'] & 690) && ($nextquest['RequiredRaces'] !=1791))
 547          echo "$lang[step]($step)&nbsp;<img width=14 height=14 src='images/player_info/factions_img/horde.gif'>&nbsp;<a href=\"?quest=$nextquest[entry]\">$nextquest[Title]</a>";
 548      else
 549          echo "$lang[step]($step)&nbsp;<a href=\"?quest=$nextquest[entry]\">$nextquest[Title]</a>";
 550      echo "</td></tr>";
 551      $needForQuest = $dDB->selectRow("SELECT * FROM `quest_template` WHERE ABS(`PrevQuestId`) = ?d", $nextquest['entry']);
 552     }
 553     else
 554      $nextquest = 0;
 555    }
 556    $step++;
 557  }
 558 }
 559 // Ищем квесты требующие выполнение даного квеста
 560 $needForQuest = $dDB->selectPage($number, "SELECT * FROM `quest_template` WHERE ABS(`PrevQuestId`) = ?d", $quest['entry']);
 561 if ($needForQuest AND $number > 1) // если == 1 то мы уже вывели это в цепочке
 562 {
 563  echo "<tr><td class = head>$lang[req_for_quest]</td></tr>";
 564  foreach ($needForQuest as $nextquest)
 565  {
 566   localiseQuest($nextquest);
 567   echo "<tr><td>";
 568   echo "<div style='float: right;'>($lang[level]&nbsp;$nextquest[QuestLevel])</div>";
 569   if (getAllowableRace($nextquest['RequiredRaces']) && ($nextquest['RequiredRaces'] & 1101) && ($nextquest['RequiredRaces'] !=1791))
 570       echo "<img width=14 height=14 src='images/player_info/factions_img/alliance.gif'>&nbsp;<a href=\"?quest=$nextquest[entry]\">$nextquest[Title]</a>";
 571   else
 572   if (getAllowableRace($nextquest['RequiredRaces']) && ($nextquest['RequiredRaces'] & 690) && ($nextquest['RequiredRaces'] !=1791))
 573        echo "<img width=14 height=14 src='images/player_info/factions_img/horde.gif'>&nbsp;<a href=\"?quest=$nextquest[entry]\">$nextquest[Title]</a>";
 574   else
 575        echo "<a href=\"?quest=$nextquest[entry]\">$nextquest[Title]</a>";
 576   echo "</td></tr>";
 577  }
 578 }
 579
 580 ###
 581 echo "<tr><td class = head>$lang[additional_info]</td></tr>";
 582 echo "<tr><td><b style='float: right;'>".getNumPalayersCompletedQuest($quest['entry'])."</b>{$lang['players_completed_quest']}:</td></tr>";
 583 echo "<tr><td><b style='float: right;'>".getNumPalayersWithThisQuest($quest['entry'])."</b>{$lang['players_with_this_quest']}:</td></tr>";
 584 echo "</tbody></table>";
 585 }
 586 ?>