Lord,Mvp,Gwwinner

    • Werbung zur Unterstützung des Forums ( Bitte AddBlocker deaktivieren )

    • Lord:
      <?php
      mssql_select_db      ("CHARACTER_01_DBF");
      $lord = mssql_fetch_array(mssql_query("SELECT TOP 1 m_szName FROM tblLord a LEFT JOIN CHARACTER_TBL b ON RIGHT('0000000' + CONVERT(VARCHAR(7),a.idLord),7)= b.m_idPlayer ORDER BY s_date DESC"));
      if (      $lord['m_szName'] != "")
      echo       $lord;
      else
      echo       "-";
      ?>


      MVP:
      <?php
      $mvp       = mssql_fetch_array(mssql_query("SELECT TOP 1 m_szName FROM tblCombatJoinPlayer JP LEFT JOIN tblCombatInfo CI ON JP.CombatID = CI.CombatID LEFT JOIN CHARACTER_TBL C ON JP.PlayerID = C.m_idPlayer WHERE CI.[Status] = '30' ORDER BY JP.CombatID DESC, Point DESC"));
      if (      $mvp['m_szName'] != "")
      echo       $mvp[m_szName];
      else
      echo       "-";
      ?>


      GW Gewinner:
      <?php
      $crown       = mssql_fetch_array(mssql_query("SELECT TOP 1 m_szGuild FROM tblCombatJoinGuild JG LEFT JOIN tblCombatInfo CI ON JG.CombatID = CI.CombatID LEFT JOIN GUILD_TBL G ON JG.GuildID = G.m_idGuild WHERE CI.[Status] = '30' ORDER BY JG.CombatID DESC, Point DESC"));
      if (      $crown['m_szGuild'] != "")
      echo       $crown[m_szGuild];
      else
      echo       "-";
      ?>


      Credtis gehen an Jusikid für den Release und an Sedrika :>