PHP error 2: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given, from /home-persistent/smulligan/leagueleader/tags/127/hcpgen.php:299
CREATE TEMPORARY TABLE IF NOT EXISTS `ps_bf926d5c-f2c8-459d_0_0_1_details` ENGINE=MyISAM SELECT PlayerStat.PlayerStatId AS `PlayerStatId`,PlayerStat.PlayerId AS `PlayerId`,IFNULL(Team.TeamId,-1) AS `TeamId`,IFNULL(Division.DivisionId,IFNULL(playedDivision.DivisionId,-1)) AS `DivisionId`,IFNULL(League.LeagueId,-1) AS `LeagueId`,MatchStat.MatchStatId AS `MatchStatId`,SetStat.SetNumber AS `SetNumber`,PlayerStatError.PlayerName AS `ErrorPlayerName`,Player.LastName AS `LastName`,Player.FirstName AS `FirstName`,TeamStatError.TeamName AS `ErrorTeamName`,Team.Name AS `TeamName`,'{Substitutes}' AS `DefaultTeamName`,PlayerStat.TotalPoints AS `TotalPoints`,PlayerStat.TotalDarts AS `TotalDarts`,PlayerStat.`Games` AS `Games`,PlayerStat.`Wins` AS `Wins`,SUM(IF(PlayerFeat.FeatId=19,PlayerFeat.Value,0)) AS `Hat`,SUM(IF(PlayerFeat.FeatId=21,PlayerFeat.Value,0)) AS `3BD`,SUM(IF(PlayerFeat.FeatId=22,PlayerFeat.Value,0)) AS `Ton80`,SUM(IF(PlayerFeat.FeatId=23,PlayerFeat.Value,0)) AS `HTon`,SUM(IF(PlayerFeat.FeatId=24,PlayerFeat.Value,0)) AS `LTon`,SUM(IF(PlayerFeat.FeatId=2,PlayerFeat.Value,0)) AS `6DO`,SUM(IF(PlayerFeat.FeatId=3,PlayerFeat.Value,0)) AS `7DO`,SUM(IF(PlayerFeat.FeatId=4,PlayerFeat.Value,0)) AS `8DO`,SUM(IF(PlayerFeat.FeatId=5,PlayerFeat.Value,0)) AS `9DO`  FROM PlayerStat FORCE INDEX (IDX_SetStatId)  INNER JOIN SetStat ON (PlayerStat.SetStatId=SetStat.SetStatId AND SetStat.Ignored=FALSE) LEFT JOIN Player ON (Player.PlayerId=PlayerStat.PlayerId) LEFT JOIN PlayerStatError ON (PlayerStatError.PlayerStatId=PlayerStat.PlayerStatId) LEFT JOIN TeamStat ON (TeamStat.SetStatId=SetStat.SetStatId AND PlayerStat.HomeAway=TeamStat.HomeAway) LEFT JOIN TeamStatError ON (TeamStatError.TeamStatId=TeamStat.TeamStatId) LEFT JOIN Team AS playedTeam ON (playedTeam.TeamId=TeamStat.TeamId) LEFT JOIN Division AS playedDivision ON (playedTeam.DivisionId=playedDivision.DivisionId) INNER JOIN MatchStat ON (SetStat.MatchStatId=MatchStat.MatchStatId) CROSS JOIN (SELECT 0 AS TeamId, 0 AS DivisionId, 'All' AS Name) AS Team CROSS JOIN (SELECT 0 AS DivisionId, 0 AS LeagueId, 'All' AS Name) AS Division CROSS JOIN (SELECT 0 AS LeagueId, 1 AS Active, 'All' AS ShortName) AS League LEFT JOIN LeagueHCP ON (LeagueHCP.LeagueId=League.LeagueId) LEFT JOIN PlayerHandicap AS accurateHandicap ON (accurateHandicap.LeagueId=League.LeagueId AND accurateHandicap.PlayerId=PlayerStat.PlayerId AND accurateHandicap.GameId=SetStat.GameId AND accurateHandicap.Darthead=PlayerStat.Darthead AND accurateHandicap.DoubleBull=PlayerStat.DoubleBull) LEFT JOIN PlayerHandicap AS genericHandicap ON (genericHandicap.LeagueId=League.LeagueId AND genericHandicap.PlayerId=PlayerStat.PlayerId AND genericHandicap.GameId=0 AND genericHandicap.Darthead=0 AND genericHandicap.DoubleBull=-1) LEFT JOIN PlayerFeat ON (PlayerFeat.PlayerStatId=PlayerStat.PlayerStatId) LEFT JOIN dartbro_main.Feat ON (PlayerFeat.FeatId=dartbro_main.Feat.FeatId) INNER JOIN dartbro_main.Game ON (dartbro_main.Game.GameId=SetStat.GameId) WHERE MatchStat.LeagueId IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,125,126,124,123,121,122,119,120,114,115,116,127,128,129,130,131,133,134,135,136,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,154,155,156,157,158,159,160,161,162,163,164,165,166,167,168,169,170,171,172,173,174,175,176,177,178,179,180,181,182,183,184,185,186,187,188,189,190,191,192,193,297,293,196,197,198,199,284,201,283,203,282,205,279,207,278,209,276,211,275,213,281,215,280,217,285,219,295,221,294,223,291,225,226,227,228,229,290,231,289,233,288,235,287,237,286,239,299,241,298,243,274,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,296,269,292,271,272,273,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,337,338,343,342,345,344,346,347,348,349,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,365,366,368,369,370,371,372,373,374,375,376,377,378,379,380,381) AND dartbro_main.Game.GameTypeId=1 AND SetStat.PlayedDate>='2020-02-03' AND SetStat.PlayedDate<='2020-02-18' GROUP BY PlayerStat.PlayerStatId ORDER BY PlayerStat.PlayerId,MatchStat.Week,MatchStat.MatchStatId,SetStat.SetNumber<hr><html>
 <head>
  <title>LeagueLeader Error</title>
  
  <style type="text/css">
   #content
   {
       background-color: #DDD;
       border: 2px solid black;
       font-family: Arial;
       padding: 1em;
   }

   #header
   {
       font-family: Arial Black;
       font-size: 1.5em;
       text-align: left;
       color: white;
   }

   #description
   {
       font-family: Arial;
       font-size: 1em;
       text-align: left;
       margin-top: 1.5em;
   }
  #errormsg
   {
    font-family: Arial;
    font-size: 1em;
   }
   pre
   {
       font-weight: bold;
   }
  </style>
  <script>
  function closewindow()
  {
      if(window.parent)
      {
          window.parent.location = 'index.php?actions=home';
      }
      else
      {
          window.location = 'index.php?actions=home';
      }
  }
  </script>
  
 </head>
 <body>
 <table width="100%" height="100%">
  <tr>
   <td valign="middle" align="center">
   <table>
    <tr>
     <td id="content">
      <div id="header">
       LeagueLeader Error
      </div>
      <div id="description">
       It would seem that LeagueLeader has encountered an error:<br>
       <code>URI: /sharedreport.php?operatorid=965&code=902083bd-c40d-4221-87df-43b816419a8f<p>File: PlayerStandings.php(1935) : eval()'d code:1<br /></code>
       MySQL Error:
       <div id="errormsg">Unknown column 'SetStat.Ignored' in 'on clause'</div>
       <br><br>
       <a href="mailto:support@bullshooter.com">Please contact Arachnid and tell us what you were doing.</a>
      </div>
      <br>
      <center>
       <button onclick="closewindow();" style="pointer">
        <table>
         <tr><td><img src="images/leftarrow.gif">
         <td>Return To Main Menu        </table>
       </button>
      </center>
     </td>
    </tr>
   </table>
   </td>
  </tr>
 </table>
 </body>
</html>