• Index
• Search by APIs
• Search by Words
• Project Search

• Java
• Python
• JavaScript
• TypeScript
• C++
• Scala
• Blog

• server-master
  • sql
    • _nyxAccountLogs.sql
    • _nyxNews.sql
    • _nyxResources.sql
    • Character.sql
    • MEMB_STAT.sql
    • _nyxConfig.sql
    • MEMB_INFO.sql
    • _nyxSerialTracker.sql
    • _nyxMarket.sql
    • fixes
      • warehouse.sql
      • Character.sql
      • MEMB_INFO.sql
  • src
    • db
      • connect.ts
      • models
        • Character.ts
        • AccountCharacter.ts
        • index.ts
        • _nyxConfig.ts
        • MEMB_INFO.ts
        • Guild.ts
        • _nyxResources.ts
        • _nyxMarket.ts
        • MEMB_STAT.ts
        • _nyxNews.ts
        • warehouse.ts
        • GuildMember.ts
        • _nyxAccountLogs.ts
    • server.ts
    • middleware
      • validator.ts
      • auth.ts
    • controllers
      • characters
        • index.ts
        • search.ts
        • getOne.ts
        • getHOF.ts
        • getChars.ts
      • user
        • index.ts
        • character
          • reset.ts
          • class.ts
          • index.ts
          • name.ts
          • saveStats.ts
          • getChars.ts
        • extra
          • storage
            • index.ts
            • moveItem.ts
          • quests.ts
          • buyMarketItem.ts
          • index.ts
          • market.ts
          • name.ts
          • auction
            • getBidders.ts
            • index.ts
            • bid.ts
          • resWithdraw.ts
          • resDeposit.ts
        • account
          • exchangeOnline.ts
          • getLogs.ts
          • getOnline.ts
          • auth.ts
          • password.ts
          • index.ts
          • buyVip.ts
          • create.ts
          • getVip.ts
          • verify.ts
      • admin
        • index.ts
        • updateConfig.ts
        • postNews.ts
      • others
        • getNews.ts
        • index.ts
        • market
          • getMany.ts
          • index.ts
      • config
        • index.ts
        • getConfig.ts
      • guilds
        • getMany.ts
        • index.ts
        • getOne.ts
    • types
      • custom.d.ts
    • validation
      • characters.ts
      • users
        • index.ts
        • character.ts
        • account.ts
        • extra.ts
      • guilds
        • index.ts
    • tools
      • user
        • logs.ts
      • items
        • findAndRemove.ts
        • insertResources.ts
        • storage.ts
        • index.ts
        • generate.ts
        • decode.ts
        • slotsMatrix.ts
        • findFreeSlot.ts
      • logger.ts
      • json.ts
    • routes
      • config.ts
      • user
        • index.ts
        • character.ts
        • account.ts
        • extra.ts
      • characters.ts
      • admin.ts
      • index.ts
      • router.ts
      • guilds.ts
      • others.ts
      • notFound.ts
  • tslint.json
  • LICENSE
  • webpack.config.js
  • Dockerfile-db
  • README.md
  • package.json
  • Dockerfile
  • tsconfig.json
  • .gitignore
  • .dockerignore

import { Op } from 'sequelize';

// Types
import { Request, Response } from 'express';

// Tools
import logger from '../../tools/logger';

// Models
import model from '../../db/models';

const getHof = async (req: Request, res: Response) => {
  try {
    const sm = await model.Character.findOne({
      where: { [Op.or]: [{ Class: 0 }, { Class: 1 }] },
      attributes: ['Name', 'Class', 'HOFWins'],
      order: [
        ['HOFWins', 'DESC'],
        ['Resets', 'DESC'],
        ['cLevel', 'DESC']
      ],
      include: [
        {
          model: model.MEMB_STAT,
          attributes: {
            exclude: ['memb___id']
          }
        },
        {
          model: model.AccountCharacter,
          attributes: {
            exclude: ['Id']
          }
        }
      ]
    });

    const bk = await model.Character.findOne({
      where: { [Op.or]: [{ Class: 16 }, { Class: 17 }] },
      attributes: ['Name', 'Class', 'HOFWins'],
      order: [
        ['HOFWins', 'DESC'],
        ['Resets', 'DESC'],
        ['cLevel', 'DESC']
      ],
      include: [
        {
          model: model.MEMB_STAT,
          attributes: {
            exclude: ['memb___id']
          }
        },
        {
          model: model.AccountCharacter,
          attributes: {
            exclude: ['Id']
          }
        }
      ]
    });

    const elf = await model.Character.findOne({
      where: { [Op.or]: [{ Class: 32 }, { Class: 33 }] },
      attributes: ['Name', 'Class', 'HOFWins'],
      order: [
        ['HOFWins', 'DESC'],
        ['Resets', 'DESC'],
        ['cLevel', 'DESC']
      ],
      include: [
        {
          model: model.MEMB_STAT,
          attributes: {
            exclude: ['memb___id']
          }
        },
        {
          model: model.AccountCharacter,
          attributes: {
            exclude: ['Id']
          }
        }
      ]
    });

    const mg = await model.Character.findOne({
      where: {
        Class: 48
      },
      attributes: ['Name', 'Class', 'HOFWins'],
      order: [
        ['HOFWins', 'DESC'],
        ['Resets', 'DESC'],
        ['cLevel', 'DESC']
      ],
      include: [
        {
          model: model.MEMB_STAT,
          attributes: {
            exclude: ['memb___id']
          }
        },
        {
          model: model.AccountCharacter,
          attributes: {
            exclude: ['Id']
          }
        }
      ]
    });

    const dl = await model.Character.findOne({
      where: {
        Class: 64
      },
      attributes: ['Name', 'Class', 'HOFWins'],
      order: [
        ['HOFWins', 'DESC'],
        ['Resets', 'DESC'],
        ['cLevel', 'DESC']
      ],
      include: [
        {
          model: model.MEMB_STAT,
          attributes: {
            exclude: ['memb___id']
          }
        },
        {
          model: model.AccountCharacter,
          attributes: {
            exclude: ['Id']
          }
        }
      ]
    });

    res.json(!sm && !bk && !elf && !mg && !dl ? false : [sm, bk, elf, mg, dl]);
  } catch (error) {
    logger.error({ error, res });
  }
};

export default getHof;