if to use an addons for add level quest to a label of this quest exemple :

[70] The Second and Third Fragments

the key page don't see a good progression for key


to correct this bug in membersinst.php remplace

Code: Select all

function buildSQL($item,$key,$type)
{
   global $wowdb, $selectp, $wherep, $pcount, $selectq, $whereq, $qcount;

   list($iname, $thottnum) = explode('|', $item);

   if ($type == 'quest')
   {
      ++$pcount;
      $selectq .= ", sum(if(quests.quest_name = '".$iname."', 1, 0)) AS $key";
      if ($pcount == 1)
      {
         $whereq .= " quests.quest_name = '".$iname."'";
      }
      else
      {
         $whereq .= " OR quests.quest_name = '".$iname."%";
      }
   }
   else
   {
      ++$qcount;
      $selectp .= ", sum(if(items.item_name = '".$iname."', 1, 0)) AS $key";
      if ($qcount == 1)
      {
         $wherep .= " items.item_name = '".$iname."'";
      }
      else
      {
         $wherep .= " OR items.item_name = '".$iname."'";
      }
   }
}

by

Code: Select all


function buildSQL($item,$key,$type)
{
   global $wowdb, $selectp, $wherep, $pcount, $selectq, $whereq, $qcount;

   list($iname, $thottnum) = explode('|', $item);

   if ($type == 'quest')
   {
      ++$pcount;
      $selectq .= ", sum(if(quests.quest_name LIKE '%".$iname."%', 1, 0)) AS $key";
      if ($pcount == 1)
      {
         $whereq .= " quests.quest_name LIKE '%".$iname."%'";
      }
      else
      {
         $whereq .= " OR quests.quest_name LIKE '%".$iname."%'";
      }
      //echo $whereq."<br>";
   }
   else
   {
      ++$qcount;
      $selectp .= ", sum(if(items.item_name = '".$iname."', 1, 0)) AS $key";
      if ($qcount == 1)
      {
         $wherep .= " items.item_name = '".$iname."'";
      }
      else
      {
         $wherep .= " OR items.item_name = '".$iname."'";
      }
   }
}

Put in as a last minute fix for final release v1.7.3

I edited wowdb to strip out the level in the quest name

after my firts upload i'm bug to uopload file

Quest [] could not be inserted
1062: Duplicate entry '6-' for key 1

Yeah, I didn't test the change and confirm it was ok

ALWAYS check the "Official Bugs & Updates" forum for fixes
There is a hot fix there for the error you posted