const getCheerUrl = function (cheerW, usr) {
  const res = await pool.query('select cheer, url from cheers')
    const result = res.rows;
    let message1;
    let done;
    console.log('there was a cheer');
    for (let x = 0; x < result.length; x++) {
      console.log('just the object', result[x]);
      console.log('grab further', result[x].cheer);
      const indexVal = cheerW.indexOf(result[x].cheer);
      console.log('userstate', usr);
      console.log(indexVal);
      if (indexVal !== -1) {
        message1 = cheerW;
        while (message1.indexOf(result[x].cheer) !== -1) {
          message1 = message1.replace(result[x].cheer, `<img class="emoteImg" src="${result[x].url}">`);
          console.log(message1);
          message1 = `${usr.username}: </br> ${message1}`;
          console.log(usr['user-id']);
        }
        done = 1;
        break;
      } else {
        console.log('no db entry');
      }
    }
    if (done !== 1) {
      io.emit('cheer', cheerW);
      console.log('cheer was made with no entry in DB', cheerW);
    } else {
      const user = await getUser(usr['user-id'])
          if (!user) {
            console.log('User not found');
          } else {
            const {
              id, display_name, login,
              broadcaster_type, view_count, profile_image_url,
            } = user;
            const name = `[${id}] ${display_name} (${login})`;
            const props = `${broadcaster_type}, ${view_count} view(s), image: ${profile_image_url}`;
            console.log(`${name} -- ${props}`);
            const profileElment = `<img align="left" style="padding-right: 3px;" class="profImg" src="${profile_image_url}" alt="null" id="itemImg">`;
            message1 = `${profileElment} ${message1}`;
            console.log('message content', message1);
            io.emit('cheer', message1);
          }
    }
};