Conquer Club

Code: Select all

 #  Partner          Games  Record  Win%   Net  Pts/G  Years
--  ---------------  -----  ------  ----  ----  -----  ---------
 1  KJHunter           168  102-66   61%  +658   +3.9  2025-2026
 2  UCAbears           111   72-39   65%  +556   +5.0  2006-2015
 3  alster              61   44-17   72%  +244   +4.0  2006-2018
 4  KKlemen             68   47-21   69%  +237   +3.5  2026
 5  eddymush            58   39-19   67%  +209   +3.6  2006-2013
 6  phishn80            43   31-12   72%  +204   +4.7  2006-2018
 7  cmeb4udie           58   48-10   83%  +180   +3.1  2006-2007
 8  KidTwist            38   27-11   71%  +169   +4.4  2006-2007
 9  Rynn                20    16-4   80%  +135   +6.8  2006-2007
10  jaydog              31    22-9   71%  +129   +4.2  2006-2013
11  Master Chief        18    13-5   72%  +109   +6.1  2006-2013
12  beardbuster         41   25-16   61%  +103   +2.5  2025-2026
13  reverend_kyle       35   25-10   71%  +103   +2.9  2006-2007
14  eye84free           27    19-8   70%   +89   +3.3  2006-2013
15  Darkended Blade     69   37-32   54%   +75   +1.1  2025-2026
16  ptlowe              14    11-3   79%   +68   +4.9  2006-2012
17  Marie LaVeaux       11     6-5   55%   +63   +5.7  2017-2026
18  Greatwhite          67   48-19   72%   +59   +0.9  2017-2026
19  FUUF                65   39-26   60%   +58   +0.9  2025-2026
20  shoop76             31   21-10   68%   +54   +1.7  2008-2026
21  SC MAN              32   17-15   53%   +51   +1.6  2008-2026
22  mchs35              11     7-4   64%   +47   +4.3  2013
23  Jones888            23   12-11   52%   +42   +1.8  2025-2026
24  Yellow Peril        26   16-10   62%   +31   +1.2  2013
25  Paul906             32   17-15   53%   +29   +0.9  2025-2026
26  middleton          128   85-43   66%   +24   +0.2  2025-2026
27  owenshooter         20    11-9   55%   +21   +1.1  2025-2026
28  subjekt             19    13-6   68%   +11   +0.6  2007
29  Mike Doherty        15    10-5   67%    +0   +0.0  2006-2007
30  riverj              14     8-6   57%    -3   -0.2  2026

Code: Select all

 #  Team                         Games  My Record   Net
--  ---------------------------  -----  ---------  ----
 1  2007spaceodyssey & Natascha     43      19-24  -217
 2  Khayam & Tazyoglu               18       3-15  -205
 3  FriendlyMe & kwall5             37      22-15  -107
 4  Angettes Boy & fritsyyy          6        2-4  -105
 5  Monkeymagic07 & huskerdu        33      19-14  -105
 6  BeN5487 & flipperskipper        26      14-12   -92
 7  Grysbaek & rgry                  6        1-5   -77
 8  Mussar & snusleppa               5        1-4   -76
 9  Dabar & dhx1301                 12        4-8   -74
10  AR & IceAR                      12       2-10   -72

Code: Select all

 #  Player            Games  My Record   Net  Partners Tried
--  ----------------  -----  ---------  ----  --------------
 1  Natascha             50      23-27  -252              18
 2  2007spaceodyssey     44      20-24  -194              19
 3  Chilic               14        7-7  -165               9
 4  middleton            14       4-10  -157               7
 5  kwall5               38      22-16  -129               7
 6  flipperskipper       54      32-22  -108              14
 7  Tazyoglu             19       4-15  -106               9
 8  Khayam               19       4-15  -106               9
 9  farinelli            12        5-7  -105               6
10  juke                 11        2-9  -105               8

Code: Select all

Setting     All-Time Pts/G  Since 2024 Pts/G  Since 2024 Record  Since 2024 Net
----------  --------------  ----------------  -----------------  --------------
Flat Rate             +0.9              +1.1            442-272            +817
Escalating            +1.0              -1.6              64-65            -204
No Spoils             +1.6              -0.8            161-131            -229
Parachute             +0.7              +0.7            182-118            +208
Chained               +0.3              +0.3            440-300            +253
Unlimited             +2.0              -0.5              44-48             -47
No Fog                +1.4              +0.5            571-392            +526
Fog                   -1.2              -1.1              97-79            -189

Code: Select all

Map                 Games   Record  Win%    Net  Pts/G
------------------  -----  -------  ----  -----  -----
Classic               515  345-170   67%  +1289   +2.5
USA                   237   169-68   71%   +998   +4.2
CCU                    84    57-27   68%   +300   +3.6
Europe                147    97-50   66%   +271   +1.8
Balkan Peninsula       20     16-4   80%   +185   +9.2
Iberia                 31    21-10   68%   +182   +5.9
Canada                 47    29-18   62%   +143   +3.0
Europa                128    79-49   62%   +134   +1.0
Tamriel                38    23-15   61%   +114   +3.0
Doodle Earth           32    22-10   69%    +81   +2.5
Discworld              66    40-26   61%    +76   +1.2
Hong Kong              22     13-9   59%    +65   +3.0
Alexander's Empire     21     15-6   71%    +59   +2.8
Philippines            44    24-20   55%    +31   +0.7
Japan                  18     12-6   67%    +30   +1.7
Montreal               26    16-10   62%    +22   +0.8
Midgard                20     12-8   60%    +20   +1.0
France                 33    20-13   61%    +10   +0.3
Germany                51    31-20   61%     -7   -0.1
Vancouver              25    15-10   60%    -38   -1.5
Australia              44    24-20   55%    -41   -0.9
Arctic                 24    13-11   54%    -53   -2.2
British Isles         118    73-45   62%    -99   -0.8
Portugal               22     7-15   32%   -249  -11.3
Brazil                 48    20-28   42%   -344   -7.2

Code: Select all

// Conquer Club -> CSV export (run in your browser console while on conquerclub.com)
// Downloads conquer_club_games.csv when done.
(async () => {
  const USERNAME = 'YOUR_USERNAME_HERE';   // <-- change this to your Conquer Club name
  const MAX_PLAYERS = 12, MAX_TEAMMATES = 3, MAX_OPPONENTS = 11;

  const GAME_TYPES = { S: 'Standard', C: 'Terminator', A: 'Assassin', P: 'Polymorphic', D: 'Doubles', T: 'Triples', Q: 'Quadruples' };
  const TEAM_SIZE = { D: 2, T: 3, Q: 4 };
  const INITIAL_TROOPS = { E: 'Automatic', M: 'Manual' };
  const PLAY_ORDER = { S: 'Sequential', F: 'Freestyle' };
  const SPOILS = { '1': 'No Spoils', '2': 'Escalating', '3': 'Flat Rate', '4': 'Nuclear', '5': 'Zombie' };
  const REINFORCEMENTS = { C: 'Chained', O: 'Adjacent', M: 'Unlimited', P: 'Parachute', N: 'None' };

  const user = USERNAME.toLowerCase();
  const pad2 = x => String(x).padStart(2, '0');
  const fmtDate = d => d ? `${pad2(d.getMonth() + 1)}/${pad2(d.getDate())}/${String(d.getFullYear()).slice(2)}` : '';
  const fmtMonth = d => d ? `${d.getFullYear()}-${pad2(d.getMonth() + 1)}` : '';
  const padArr = (arr, len) => arr.slice(0, len).concat(Array(Math.max(0, len - arr.length)).fill(''));
  const childText = (el, name) => {
    const c = [...el.children].find(x => x.tagName === name);
    return c ? c.textContent.trim() : '';
  };

  const headers = ['Game #', 'Date', 'Started', 'Month', 'Map', 'Players', 'Game Type', 'Team Game', 'Team Size', 'Teams',
    'Format', 'Multi-Team', 'Slots Per Player', 'Initial Troops', 'Play Order', 'Spoils', 'Reinforcements',
    'Fog of War', 'Trench Warfare', 'Round Limit', 'Round Length', 'Result', 'Finish Place', 'My Net Points',
    'Team Net Points', 'Rounds Played', 'Tournament', 'Private'];
  for (let i = 1; i <= MAX_TEAMMATES; i++) headers.push('Teammate ' + i);
  headers.push('Teammates (all)');
  for (let i = 1; i <= MAX_OPPONENTS; i++) headers.push('Opponent ' + i);
  headers.push('Opposing Teams', 'Beaten By', 'Link', 'Points Logged', 'Scored');

  const rows = [];
  const log = { apiTotal: '', fetched: 0, kept: 0, tooMany: 0, noUser: 0, noPoints: 0, scored: {}, types: {} };

  function parseGame(g) {
    const t = name => childText(g, name);
    const playersEl = [...g.children].find(x => x.tagName === 'players');
    const pEls = playersEl ? [...playersEl.children] : [];

    // Seats (a polymorphic player holds several seats under the same name)
    const seatNames = pEls.map(p => p.textContent.trim());
    const seatStates = pEls.map(p => p.getAttribute('state') || '');
    const nSeats = seatNames.length;

    // People, in first-seat order
    const people = [];
    seatNames.forEach(nm => { if (!people.includes(nm)) people.push(nm); });
    const nPeople = people.length;
    if (nPeople > MAX_PLAYERS) return 'TOO_MANY';

    const meName = people.find(x => x.toLowerCase() === user);
    if (!meName) return 'NO_USER';
    const mySeats = seatNames.map((nm, i) => nm === meName ? i : -1).filter(i => i >= 0);
    const personWon = nm => seatNames.some((x, i) => x === nm && seatStates[i] === 'Won');

    const typeCode = t('game_type');
    const teamSize = TEAM_SIZE[typeCode] || 1;
    const isTeam = teamSize > 1;
    const numTeams = isTeam ? Math.round(nSeats / teamSize) : nPeople;
    const teamOf = i => Math.floor(i / teamSize);
    const myTeam = teamOf(mySeats[0]);

    const teammates = [], oppTeams = [];
    if (isTeam) {
      for (let k = 0; k < numTeams; k++) {
        const members = [];
        for (let i = k * teamSize; i < Math.min((k + 1) * teamSize, nSeats); i++) {
          if (seatNames[i] !== meName && !members.includes(seatNames[i])) members.push(seatNames[i]);
        }
        if (k === myTeam) teammates.push(...members); else oppTeams.push(members);
      }
    } else {
      people.forEach(nm => { if (nm !== meName) oppTeams.push([nm]); });
    }
    const opponents = [].concat(...oppTeams);

    // Event log: points per seat, dates, seat elimination order
    const seatPts = Array(nSeats).fill(0), seatElim = [];
    let start = null, end = null, pointsLogged = false, eventCount = 0;
    const eventsEl = [...g.children].find(x => x.tagName === 'events');
    if (eventsEl) {
      [...eventsEl.children].forEach(e => {
        eventCount++;
        const ts = Number(e.getAttribute('timestamp')) || null;
        if (ts) { if (start === null || ts < start) start = ts; if (end === null || ts > end) end = ts; }
        const txt = e.textContent.trim();
        let m = txt.match(/^(\d+) (gains|loses) (\d+) points?$/);
        if (m) {
          pointsLogged = true;
          const s = +m[1] - 1;
          if (s >= 0 && s < nSeats) seatPts[s] += (m[2] === 'gains' ? 1 : -1) * +m[3];
          return;
        }
        m = txt.match(/^\d+ eliminated (\d+) from the game$/) || txt.match(/^(\d+) was kicked out/);
        if (m) { const s = +m[1] - 1; if (s >= 0 && s < nSeats && !seatElim.includes(s)) seatElim.push(s); }
      });
    }
    if (!pointsLogged) log.noPoints++;

    // Scored: use an explicit tag if the API ever adds one, otherwise infer from the event log
    const scoredTag = t('scored') || t('ranked');
    let scored;
    if (scoredTag) scored = /^(y|yes|1)$/i.test(scoredTag) ? 'Yes' : 'No';
    else if (pointsLogged) scored = 'Yes';
    else if (eventCount > 0) scored = 'No';
    else scored = 'Unknown';
    log.scored[scored] = (log.scored[scored] || 0) + 1;

    const myNet = mySeats.reduce((sum, i) => sum + seatPts[i], 0);
    let teamNet = myNet;
    if (isTeam) { teamNet = 0; for (let i = 0; i < nSeats; i++) if (teamOf(i) === myTeam) teamNet += seatPts[i]; }

    // A person is out once all their seats are out
    const personElim = [];
    seatElim.forEach((s, idx) => {
      const nm = seatNames[s];
      if (personElim.includes(nm)) return;
      const outSoFar = new Set(seatElim.slice(0, idx + 1));
      if (seatNames.every((x, i) => x !== nm || outSoFar.has(i))) personElim.push(nm);
    });

    const iWon = personWon(meName);
    let place = '';
    if (!isTeam) {
      if (iWon) place = 1;
      else { const ei = personElim.indexOf(meName); if (ei !== -1) place = nPeople - ei; }
    }

    const myTeamNames = isTeam ? seatNames.filter((x, i) => teamOf(i) === myTeam) : [meName];
    const winners = people.filter(nm => personWon(nm) && !myTeamNames.includes(nm));
    const endDate = end ? new Date(end * 1000) : null;
    const startDate = start ? new Date(start * 1000) : null;
    const speed = t('speed_game'), roundLimit = t('round_limit'), gameNum = t('game_number');

    return [
      +gameNum, fmtDate(endDate), fmtDate(startDate), fmtMonth(endDate), t('map'), nPeople,
      GAME_TYPES[typeCode] || typeCode, isTeam ? 'Yes' : 'No', teamSize, numTeams, `${teamSize}x${numTeams}`,
      isTeam && numTeams > 2 ? 'Yes' : 'No',
      typeCode === 'P' ? t('poly_slots') : '',
      INITIAL_TROOPS[t('initial_troops')] || t('initial_troops'),
      PLAY_ORDER[t('play_order')] || t('play_order'),
      SPOILS[t('bonus_cards')] || t('bonus_cards'),
      REINFORCEMENTS[t('fortifications')] || t('fortifications'),
      t('war_fog') === 'Y' ? 'Yes' : 'No',
      t('trench_warfare') === 'Y' ? 'Yes' : 'No',
      roundLimit === '0' || roundLimit === '' ? 'None' : roundLimit,
      speed === 'N' ? '24 Hours' : (/^\d+$/.test(speed) ? speed + ' Min' : speed),
      iWon ? 'Won' : 'Lost', place, myNet, teamNet, t('round'),
      t('tournament'), t('private') === 'Y' ? 'Yes' : 'No',
      ...padArr(teammates, MAX_TEAMMATES), teammates.join(', '),
      ...padArr(opponents, MAX_OPPONENTS),
      oppTeams.map(tm => tm.join(' & ')).join(' | '),
      winners.join(', '),
      'https://www.conquerclub.com/game.php?game=' + gameNum,
      pointsLogged ? 'Yes' : 'No',
      scored,
    ];
  }

  let page = 1, totalPages = 1;
  while (page <= totalPages) {
    const res = await fetch(`/api.php?mode=gamelist&gs=F&events=Y&names=Y&un=${encodeURIComponent(USERNAME)}&page=${page}`);
    const doc = new DOMParser().parseFromString(await res.text(), 'application/xml');
    const root = doc.documentElement;
    totalPages = parseInt((childText(root, 'page') || '1 of 1').split(' of ')[1], 10) || 1;
    const gamesEl = [...root.children].find(x => x.tagName === 'games');
    if (!gamesEl) break;
    log.apiTotal = gamesEl.getAttribute('total');
    const games = [...gamesEl.children].filter(x => x.tagName === 'game');
    if (!games.length) break;
    games.forEach(g => {
      log.fetched++;
      const r = parseGame(g);
      if (r === 'TOO_MANY') { log.tooMany++; return; }
      if (r === 'NO_USER') { log.noUser++; return; }
      rows.push(r); log.kept++;
      log.types[r[6]] = (log.types[r[6]] || 0) + 1;
    });
    console.log(`Page ${page} of ${totalPages} done (${log.kept} games kept so far)`);
    page++;
    await new Promise(r => setTimeout(r, 300));
  }

  rows.sort((a, b) => b[0] - a[0]);
  const esc = v => { const s = String(v ?? ''); return /[",\n]/.test(s) ? `"${s.replace(/"/g, '""')}"` : s; };
  const csv = [headers, ...rows].map(r => r.map(esc).join(',')).join('\n');
  const a = document.createElement('a');
  a.href = URL.createObjectURL(new Blob([csv], { type: 'text/csv' }));
  a.download = 'conquer_club_games.csv';
  document.body.appendChild(a); a.click(); a.remove();

  console.log('DONE', {
    'API reported total': log.apiTotal, 'Games fetched': log.fetched, 'Games kept': log.kept,
    'Skipped >12 players': log.tooMany, 'Skipped (username not found)': log.noUser,
    'Kept games with no points in log': log.noPoints, 'Scored': log.scored, 'Kept by type': log.types,
  });
})();