NHL Eastside Hockey Manager 2007 pre-game database format

[The_Blue_Line]

The attached zip contains details with regards to the EHM 2007 pre-game database format. This is useful if you wish to create any utilities that edit the EHM 2007 database. This was previously posted in the SI Games forum but seeing as EHM is no longer on sale, there is every chance that this may be lost for all time if not backed up on TBL. The original thread by Graeme Kelly can be found here on SI Games' forum: http://community.sigames.com/showthread ... ase-format

A PDF copy of the two pages from the original SI Forum thread are included in the zip file.

Any questions regarding the EHM 2007 database format should be asked in the Data Editing Forum: http://www.ehmtheblueline.com/forums/vi ... .php?f=110

Download: https://skydrive.live.com/?cid=a0fa740e ... C5C5%21400#

[archibalduk]

database_types.h

//----------------------------------------------------------------------------
// Project: NHL Eastside Hockey Manager
// Sports Interactive Ltd
// Copyright © 2005. All Rights Reserved.
//
// FILE: database_types.h
// AUTHOR: Graeme Kelly
//
// OVERVIEW
// ~~~~~~~~
// Header file for the database types
//
//----------------------------------------------------------------------------

#ifndef DATABASE_TYPES_H
#define DATABASE_TYPES_H

// text lengths
enum {
LONG_TEXT_LENGTH = 101,
STANDARD_TEXT_LENGTH = 51,
SHORT_TEXT_LENGTH = 26,
REAL_SHORT_TEXT_LENGTH = 6,
THREE_LETTER_TEXT_LENGTH = 4,
SIX_LETTER_TEXT_LENGTH = 7
};

// Ignore the first eight bytes of index.dat
enum { INDEX_IGNORE_DATA = 8 };

// club staff table sizes
enum {
DIRECTOR_SIZE = 3,
SQUAD_SIZE = 75,
SCOUT_SIZE = 15,
COACH_SIZE = 5,
PHYSIO_SIZE = 3
};

// Maximum number of tactics in training at once
enum { MAX_TACTIC_TRAINING = 4 };

// Maximum size of a squad for a match
enum { TEAM_SZ = 23 };

struct INDEX;
struct CONTINENTS;
struct NATIONS;
struct CITIES;
struct ARENAS;
struct CLUBS;
struct STAFF;
struct NON_PLAYERS;
struct PLAYERS;
struct STAFF_PREFERENCES;
struct STAFF_HISTORIES;
struct STAFF_LANGUAGES;
struct CLUB_COMPS;
struct CLUB_COMP_HISTORIES;
struct STAFF_COMPS;
struct STAFF_COMP_HISTORIES;
struct OFFICIALS;
struct COLOURS;
struct NAMES;
struct AFFILIATIONS;
struct RETIRED_NUMBERS;
struct STATES_PROVINCES;
struct INJURIES;
struct CURRENCIES;
struct STAGE_NAMES;
struct DRAFTED_PLAYERS;
struct DB_PLAYER_INFO;
struct DB_STAFF_INFO;
struct DB_PLAYER_RIGHTS;
struct CLUB_HISTORIES;
struct DB_CLUB_RECORDS;
struct DRAFTS;

typedef bool CBOOL;
typedef char CHAR;
typedef unsigned char UCHAR;
typedef short SHORT;
typedef unsigned short USHORT;
typedef double DOUBLE;
typedef long LONG;
typedef unsigned long ULONG;

typedef LONG CONTINENTS_PTR;
typedef LONG NATIONS_PTR;
typedef LONG CITIES_PTR;
typedef LONG ARENAS_PTR;
typedef LONG CLUBS_PTR;
typedef LONG STAFF_PTR;
typedef LONG NON_PLAYERS_PTR;
typedef LONG PLAYERS_PTR;
typedef LONG STAFF_PREFERENCES_PTR;
typedef LONG STAFF_HISTORIES_PTR;
typedef LONG STAFF_LANGUAGES_PTR;
typedef LONG CLUB_COMPS_PTR;
typedef LONG CLUB_COMP_HISTORIES_PTR;
typedef LONG STAFF_COMPS_PTR;
typedef LONG STAFF_COMP_HISTORIES_PTR;
typedef LONG OFFICIALS_PTR;
typedef LONG COLOURS_PTR;
typedef LONG AFFILIATIONS_PTR;
typedef LONG RETIRED_NUMBERS_PTR;
typedef LONG STATES_PROVINCES_PTR;
typedef LONG CHAR_PTR;
typedef LONG DRAFTED_PLAYERS_PTR;
typedef LONG PLAYER_RIGHTS_PTR;
typedef LONG DRAFTS_PTR;

struct SI_DATE
{
SHORT day;
SHORT year;
CBOOL leap_year;
};

// the following structures need to be byte aligned
#ifdef PLATFORM_MAC
#pragma options align=packed
#endif

// -------------------------- //
// Index.dat //
// -------------------------- //

struct INDEX
{
CHAR filename[ STANDARD_TEXT_LENGTH ]; // Data filename
LONG file_id; // Data filename ID number
LONG table_sz; // Data file table size
LONG version; // Version information (not used)
};

// -------------------------- //
// Continents //
// -------------------------- //

struct CONTINENTS
{
DOUBLE ContinentRegionalStrength;
LONG ContinentID;
CHAR ContinentNameThreeLetter[ THREE_LETTER_TEXT_LENGTH ];
CHAR ContinentName[ SHORT_TEXT_LENGTH ];
CHAR ContinentNameContinentality[ SHORT_TEXT_LENGTH ];
CHAR ContinentGenderName;
};

// -------------------------- //
// Nations //
// -------------------------- //

struct NATIONS
{
DOUBLE NationIIHFRankingScore;
DOUBLE NationIIHFRankingScore98;
DOUBLE NationIIHFRankingScore99;
DOUBLE NationIIHFRankingScore00;
DOUBLE NationIIHFRankingScore01;
DOUBLE NationIIHFRankingScore02;
DOUBLE NationIIHFRankingScore03;
CHAR NationJnrFinalPosition01;
CHAR NationJnrFinalPosition02;
CHAR NationJnrFinalPosition03;
CHAR NationMenFinalPosition01;
CHAR NationMenFinalPosition02;
CHAR NationMenFinalPosition03;
LONG NationID;
LONG NationNumberStaff;
CONTINENTS_PTR NationContinent;
CITIES_PTR NationCapitalCity;
ARENAS_PTR NationNationalStadium;
COLOURS_PTR NationForegroundColour1;
COLOURS_PTR NationBackgroundColour1;
COLOURS_PTR NationTrimColour1;
COLOURS_PTR NationForegroundColour2;
COLOURS_PTR NationBackgroundColour2;
COLOURS_PTR NationTrimColour2;
COLOURS_PTR NationForegroundColour3;
COLOURS_PTR NationBackgroundColour3;
COLOURS_PTR NationTrimColour3;
NATIONS_PTR NationRivals1;
NATIONS_PTR NationRivals2;
NATIONS_PTR NationRivals3;
CHAR NationNameThreeLetter[ THREE_LETTER_TEXT_LENGTH ];
SHORT NationNumberClubs;
SHORT NationReputation;
CHAR NationName[ STANDARD_TEXT_LENGTH ];
CHAR NationNameShort[ SHORT_TEXT_LENGTH ];
CHAR NationNameNationality[ SHORT_TEXT_LENGTH ];
CHAR NationGenderName;
CHAR NationGenderNameShort;
CHAR NationRegion;
CHAR NationActualRegion;
CHAR NationFirstLanguage;
CHAR NationSecondLanguage;
CHAR NationThirdLanguage;
CHAR NationStateOfDevelopment;
CHAR NationGroupMembership;
CHAR NationGameImportance;
CHAR NationLeagueStandard;
CHAR NationLeagueSelected;
CHAR NationGamesPlayed;
CHAR NationCitizenShipYears;
};



// -------------------------- //
// Cities //
// -------------------------- //

struct CITIES
{
DOUBLE CityLatitude;
DOUBLE CityLongitude;
LONG CityID;
STATES_PROVINCES_PTR CityState;
NATIONS_PTR CityNation;
CHAR CityName[ STANDARD_TEXT_LENGTH ];
CHAR CityGenderName;
CHAR CityAttraction;
};

// -------------------------- //
// Stadiums //
// -------------------------- //

struct ARENAS
{
LONG StadiumID;
LONG StadiumCapacity;
LONG StadiumSeatingCapacity;
LONG StadiumExpansionCapacity;
CITIES_PTR StadiumCity;
ARENAS_PTR StadiumNearbyStadium;
CHAR StadiumName[STANDARD_TEXT_LENGTH];
CHAR StadiumGenderName;
CHAR StadiumRinkSize;
CHAR StadiumIceCondition;
};

// -------------------------- //
// Clubs //
// -------------------------- //

struct CLUBS
{
// original data
LONG ClubID;
LONG ClubCash;
LONG ClubAttendance;
LONG ClubMinAttendance;
LONG ClubMaxAttendance;
LONG ClubEuroFlag;
LONG ClubTacticTraining[ MAX_TACTIC_TRAINING ];
LONG ClubTacticSelected;
LONG ClubFanSupport;
LONG ClubPlayerBudget;
NATIONS_PTR ClubNation;
CLUB_COMPS_PTR ClubDivision;
CLUB_COMPS_PTR ClubLastDivision;
CLUB_COMPS_PTR ClubReserveDivision;
ARENAS_PTR ClubStadium;
ARENAS_PTR ClubPracticeFacilities;
COLOURS_PTR ClubForegroundColour1;
COLOURS_PTR ClubBackgroundColour1;
COLOURS_PTR ClubTrimColour1;
COLOURS_PTR ClubForegroundColour2;
COLOURS_PTR ClubBackgroundColour2;
COLOURS_PTR ClubTrimColour2;
COLOURS_PTR ClubForegroundColour3;
COLOURS_PTR ClubBackgroundColour3;
COLOURS_PTR ClubTrimColour3;
STAFF_PTR ClubFavouriteStaff1;
STAFF_PTR ClubFavouriteStaff2;
STAFF_PTR ClubFavouriteStaff3;
STAFF_PTR ClubDislikedStaff1;
STAFF_PTR ClubDislikedStaff2;
STAFF_PTR ClubDislikedStaff3;
CLUBS_PTR ClubRivals1;
CLUBS_PTR ClubRivals2;
CLUBS_PTR ClubRivals3;
STAFF_PTR ClubChairman;
STAFF_PTR ClubDirectorList[ DIRECTOR_SIZE ];
STAFF_PTR ClubManager;
STAFF_PTR ClubAssistantManager;
STAFF_PTR ClubHeadCoach;
STAFF_PTR ClubHeadScout;
STAFF_PTR ClubSquadList[ SQUAD_SIZE ];
STAFF_PTR ClubCoachList[ COACH_SIZE ];
STAFF_PTR ClubScoutList[ SCOUT_SIZE ];
STAFF_PTR ClubPhysioList[ PHYSIO_SIZE ];
STAFF_PTR ClubCaptain;
STAFF_PTR ClubAssistantCaptain1;
STAFF_PTR ClubAssistantCaptain2;
SHORT ClubReputation;
SHORT ClubYearFounded;
CHAR ClubName[STANDARD_TEXT_LENGTH];
CHAR ClubNameShort[SHORT_TEXT_LENGTH];
CHAR ClubAbbreviation[ REAL_SHORT_TEXT_LENGTH ];
CHAR ClubNickName[ STANDARD_TEXT_LENGTH ];
CHAR ClubGenderNameShort;
CHAR ClubLastPosition;
CHAR ClubProfessionalStatus;
CHAR ClubOwnStadium;
CHAR ClubHomeMatchDay;
CHAR ClubTraining;
CHAR ClubPLC;
CHAR ClubGenderName;
CHAR ClubEuroSeeding;
CHAR ClubHasLinkedClub;
CHAR ClubMarketSize;
};

// -------------------------- //
// Affiliations //
// -------------------------- //

struct AFFILIATIONS
{
LONG AffiliationID;
CLUBS_PTR AffiliationUpperClub;
CLUBS_PTR AffiliationLowerClub;
CHAR AffiliationType;
CHAR AffiliationDependency;
CHAR AffiliationGoalieCount;
CHAR AffiliationSkaterCount;
};


// -------------------------- //
// Retired Numbers //
// -------------------------- //
struct RETIRED_NUMBERS
{
LONG RetiredNumberID;
CLUBS_PTR RetiredNumberClub;
CHAR RetiredNumberPlayerName[ LONG_TEXT_LENGTH ];
UCHAR RetiredNumber;
};

// -------------------------- //
// Staff //
// -------------------------- //

struct STAFF
{
LONG StaffID;
LONG StaffEstimatedWage;
LONG StaffEstimatedValue;
NATIONS_PTR StaffNation;
NATIONS_PTR StaffSecondNation;
PLAYERS_PTR StaffPlayerData;
STAFF_PREFERENCES_PTR StaffPreferences;
NON_PLAYERS_PTR StaffNonPlayerData;
CLUBS_PTR StaffNationContracted;
CLUBS_PTR StaffClubContracted;
CLUBS_PTR StaffClubPlaying;
LONG StaffPlayerRightsIndex;
CITIES_PTR StaffBirthTown;
CHAR_PTR StaffFirstName;
CHAR_PTR StaffSecondName;
SI_DATE StaffDateOfBirth;
SI_DATE StaffDateJoinedNation;
SI_DATE StaffContractExpiresNation;
SI_DATE StaffDateJoinedClub;
SI_DATE StaffContractExpiresClub;
SI_DATE StaffFirstProContract;
SHORT StaffYearOfBirth;
UCHAR StaffInternationalApps;
UCHAR StaffInternationalGoals;
UCHAR StaffInternationalAssists;
CHAR StaffJobForNation;
CHAR StaffAdaptability;
CHAR StaffJobForClub;
CHAR StaffAmbition;
CHAR StaffDetermination;
CHAR StaffLoyalty;
CHAR StaffPressure;
CHAR StaffProfessionalism;
CHAR StaffSportsmanship;
CHAR StaffTemperament;
CHAR StaffPlayingSquad;
CHAR StaffClassification;
CHAR StaffClubValuation;
CHAR StaffDeclaredNation;
CHAR StaffStanleyCupsWon;
CHAR StaffSquadSelectedFor;
CHAR StaffNationalTeamJobLevel;
LONG StaffEstimatedWageWeekly;
};

// -------------------------- //
// Non Players //
// -------------------------- //

struct NON_PLAYERS
{
LONG StaffNonPlayerID;
SHORT StaffNonPlayerCurrentAbility;
SHORT StaffNonPlayerPotentialAbility;
SHORT StaffNonPlayerHomeReputation;
SHORT StaffNonPlayerCurrentReputation;
SHORT StaffNonPlayerWorldReputation;
CHAR StaffNonPlayerAttacking;
CHAR StaffNonPlayerBusiness;
CHAR StaffNonPlayerCoachingTechnique;
CHAR StaffNonPlayerDirectness;
CHAR StaffNonPlayerDiscipline;
CHAR StaffNonPlayerFreeRoles;
CHAR StaffNonPlayerInterference;
CHAR StaffNonPlayerJudgement;
CHAR StaffNonPlayerJudgingPotential;
CHAR StaffNonPlayerManHandling;
CHAR StaffNonPlayerMotivating;
CHAR StaffNonPlayerPatience;
CHAR StaffNonPlayerPhysiotherapy;
CHAR StaffNonPlayerResources;
CHAR StaffNonPlayerTactics;
CHAR StaffNonPlayerYoungsters;
CHAR StaffNonPlayerTacticPreferred;
CHAR StaffNonPlayerCoachingForwards;
CHAR StaffNonPlayerCoachingDefensemen;
CHAR StaffNonPlayerCoachingGoaltenders;
CHAR StaffNonPlayerLineMatching;
CHAR StaffNonPlayerPowerPlay;
CHAR StaffNonPlayerPenaltyKill;
CHAR StaffNonPlayerPhysical;
};

// -------------------------- //
// Players //
// -------------------------- //

struct PLAYERS
{
LONG StaffPlayerID;
SHORT StaffPlayerCurrentAbility;
SHORT StaffPlayerPotentialAbility;
SHORT StaffPlayerHomeReputation;
SHORT StaffPlayerCurrentReputation;
SHORT StaffPlayerWorldReputation;
CHAR StaffPlayerSquadNumber;
CHAR StaffPlayerInternationalSquadNumber;
CHAR StaffPlayerAcceleration;
CHAR StaffPlayerAggression;
CHAR StaffPlayerAgility;
CHAR StaffPlayerAnticipation;
CHAR StaffPlayerBalance;
CHAR StaffPlayerBravery;
CHAR StaffPlayerConsistency;
CHAR StaffPlayerDecisions;
CHAR StaffPlayerDirtiness;
CHAR StaffPlayerFlair;
CHAR StaffPlayerImportantMatches;
CHAR StaffPlayerInjuryProneness;
CHAR StaffPlayerLeadership;
CHAR StaffPlayerMovement;
CHAR StaffPlayerNaturalFitness;
CHAR StaffPlayerOneOnOnes;
CHAR StaffPlayerPace;
CHAR StaffPlayerPassing;
CHAR StaffPlayerPositioning;
CHAR StaffPlayerReflexes;
CHAR StaffPlayerStamina;
CHAR StaffPlayerStrength;
CHAR StaffPlayerTeamwork;
CHAR StaffPlayerVersatility;
CHAR StaffPlayerVision;
CHAR StaffPlayerWorkRate;
CHAR StaffPlayerHandedness;
UCHAR StaffPlayerHeight;
UCHAR StaffPlayerWeight;
UCHAR StaffPlayerFavouriteNumber;
CHAR StaffPlayerGoaltender;
CHAR StaffPlayerLeftDefense;
CHAR StaffPlayerRightDefense;
CHAR StaffPlayerLeftWing;
CHAR StaffPlayerCenter;
CHAR StaffPlayerRightWing;
CHAR StaffPlayerAgitation;
CHAR StaffPlayerBlocker;
CHAR StaffPlayerChecking;
CHAR StaffPlayerDefensiveRole;
CHAR StaffPlayerDeflections;
CHAR StaffPlayerDeking;
CHAR StaffPlayerFaceoffs;
CHAR StaffPlayerFighting;
CHAR StaffPlayerGlove;
CHAR StaffPlayerHitting;
CHAR StaffPlayerOffensiveRole;
CHAR StaffPlayerPassTendency;
CHAR StaffPlayerPokecheck;
CHAR StaffPlayerRebounds;
CHAR StaffPlayerRecovery;
CHAR StaffPlayerSlapshot;
CHAR StaffPlayerStickhandling;
CHAR StaffPlayerWristshot;
CHAR StaffPlayerMorale;
CHAR StaffPlayerGoalieStyle;
CHAR StaffPlayerJuniorPreference;
};

// -------------------------- //
// Player details //
// -------------------------- //

struct STAFF_PREFERENCES
{
LONG StaffPreferencesID;
CLUBS_PTR StaffFavouriteClubs1;
CLUBS_PTR StaffFavouriteClubs2;
CLUBS_PTR StaffFavouriteClubs3;
CLUBS_PTR StaffDislikedClubs1;
CLUBS_PTR StaffDislikedClubs2;
CLUBS_PTR StaffDislikedClubs3;
STAFF_PTR StaffFavouriteStaff1;
STAFF_PTR StaffFavouriteStaff2;
STAFF_PTR StaffFavouriteStaff3;
STAFF_PTR StaffDislikedStaff1;
STAFF_PTR StaffDislikedStaff2;
STAFF_PTR StaffDislikedStaff3;
};

// -------------------------- //
// Staff History //
// -------------------------- //

struct STAFF_HISTORIES
{
LONG StaffHistoryID;
STAFF_PTR StaffHistoryStaff;
CLUBS_PTR StaffHistoryClub;
CLUB_COMPS_PTR StaffHistoryComp;
SHORT StaffHistoryYear;
USHORT StaffHistoryMinutes;
USHORT StaffHistoryConceded;
USHORT StaffHistoryShutouts;
USHORT StaffHistorySaves;
USHORT StaffHistoryPenalties;
CHAR StaffHistoryOnLoan;
UCHAR StaffHistoryApps;
UCHAR StaffHistoryGoals;
UCHAR StaffHistoryAssists;
CHAR StaffHistoryPlusMinus;
UCHAR StaffHistoryWins;
UCHAR StaffHistoryLosses;
UCHAR StaffHistoryTies;
CHAR StaffHistoryPlayoff;
};

// -------------------------- //
// Club Competitions //
// -------------------------- //

struct CLUB_COMPS
{
LONG ClubCompID;
CONTINENTS_PTR ClubCompContinent;
NATIONS_PTR ClubCompNation;
COLOURS_PTR ClubCompForegroundColour;
COLOURS_PTR ClubCompBackgroundColour;
COLOURS_PTR ClubCompTrimColour;
CHAR ClubCompNameSixLetter[ SIX_LETTER_TEXT_LENGTH ];
CHAR ClubCompGenderNameShort;
CHAR ClubCompScope;
SHORT ClubCompReputation;
CHAR ClubCompName[STANDARD_TEXT_LENGTH];
CHAR ClubCompNameShort[SHORT_TEXT_LENGTH];
CHAR ClubCompPlayoffTrophyName[ STANDARD_TEXT_LENGTH ];
CHAR ClubCompRegularSeasonTrophyName[ STANDARD_TEXT_LENGTH ];
CHAR ClubCompPlayoffTrophyGender;
CHAR ClubCompRegularSeasonTrophyGender;
CHAR ClubCompSelected;
CHAR ClubCompGenderName;
CHAR ClubCompUpperAgeLimit;
};

// -------------------------- //
// Club Competition History //
// -------------------------- //

struct CLUB_COMP_HISTORIES
{
LONG ClubCompHistoryID;
CLUB_COMPS_PTR ClubCompHistoryClubComp;
CLUBS_PTR ClubCompHistoryWinners;
CLUBS_PTR ClubCompHistoryRunnersUp;
CLUBS_PTR ClubCompHistoryThirdPlaced;
CLUBS_PTR ClubCompHistoryHosts;
CLUBS_PTR ClubCompHistoryRegularSeasonChampions;
SHORT ClubCompHistoryYear;
};

// -------------------------- //
// Staff Competitions //
// -------------------------- //

struct STAFF_COMPS
{
LONG StaffCompID;
CONTINENTS_PTR StaffCompContinent;
NATIONS_PTR StaffCompNation;
CLUB_COMPS_PTR StaffCompCompetition;
COLOURS_PTR StaffCompForegroundColour;
COLOURS_PTR StaffCompBackgroundColour;
COLOURS_PTR StaffCompTrimColour;
SHORT StaffCompReputation;
CHAR StaffCompNameShort[SHORT_TEXT_LENGTH];
CHAR StaffCompName[STANDARD_TEXT_LENGTH];
CHAR StaffCompGenderNameShort;
CHAR StaffCompGenderName;
};

// -------------------------- //
// Staff Competition History //
// -------------------------- //

struct STAFF_COMP_HISTORIES
{
LONG StaffCompHistoryID;
CLUBS_PTR StaffCompHistoryFirstPlacedClub;
CLUBS_PTR StaffCompHistorySecondPlacedClub;
CLUBS_PTR StaffCompHistoryThirdPlacedClub;
STAFF_COMPS_PTR StaffCompHistoryStaffComp;
STAFF_PTR StaffCompHistoryFirstPlacedIndex;
STAFF_PTR StaffCompHistorySecondPlacedIndex;
STAFF_PTR StaffCompHistoryThirdPlacedIndex;
CHAR_PTR StaffCompHistoryFirstPlacedFirstName;
CHAR_PTR StaffCompHistoryFirstPlacedSecondName;
CHAR_PTR StaffCompHistorySecondPlacedFirstName;
CHAR_PTR StaffCompHistorySecondPlacedSecondName;
CHAR_PTR StaffCompHistoryThirdPlacedFirstName;
CHAR_PTR StaffCompHistoryThirdPlacedSecondName;
SHORT StaffCompHistoryYear;
};

// -------------------------- //
// Officials //
// -------------------------- //

struct OFFICIALS
{
LONG OfficialID;
CHAR_PTR OfficialFirstName;
CHAR_PTR OfficialSecondName;
NATIONS_PTR OfficialNation;
CITIES_PTR OfficialCity;
CLUB_COMPS_PTR OfficialClubCompetition;
SHORT OfficialYearOfBirth;
SHORT OfficialCurrentAbility;
SHORT OfficialPotentialAbility;
SHORT OfficialReputation;
SI_DATE OfficialDateOfBirth;
CHAR OfficialAllowingRoughness;
CHAR OfficialDiscipline;
CHAR OfficialImportantMatches;
CHAR OfficialPressure;
CHAR OfficialRefereeing;
CHAR OfficialSkatingLine;
CHAR OfficialAllowingInterference;
};

// -------------------------- //
// Colours //
// -------------------------- //

struct COLOURS
{
LONG ColourID;
CHAR ColourName[STANDARD_TEXT_LENGTH];
UCHAR ColourRedIntensity;
UCHAR ColourGreenIntensity;
UCHAR ColourBlueIntensity;
};

// -------------------------- //
// Names //
// -------------------------- //

struct NAMES
{
CHAR Name[STANDARD_TEXT_LENGTH];
LONG NameID;
LONG Nation;
CHAR count;
};

// -------------------------- //
// States and Provinces //
// -------------------------- //

// The hm_states_provinces structure contains the information regarding any
// USA/Canada states and provinces
struct STATES_PROVINCES
{
LONG StateID;
NATIONS_PTR StateNation;
CHAR StateName[ STANDARD_TEXT_LENGTH ];
CHAR StateNameShort[ STANDARD_TEXT_LENGTH ];
CHAR StateGenderName;
CHAR StateAbbrev[ REAL_SHORT_TEXT_LENGTH ];
};

struct INJURIES
{
SHORT InjuryMinimumDaysOut;
SHORT InjuryExtraDaysOut;
SHORT InjuryID;
CHAR InjuryCategory;
CHAR InjuryChance;
CHAR InjuryInactiveRatio;
CBOOL InjuryIsRecurring;
CHAR InjurySeverity;
CHAR InjuryCause;
CHAR InjuryGender;
CHAR InjuryName[ STANDARD_TEXT_LENGTH ];
CHAR InjuryNameDative[ STANDARD_TEXT_LENGTH ];
CHAR InjuryNameGenetive[ STANDARD_TEXT_LENGTH ];
CHAR InjuryNameSpecialNominative[ STANDARD_TEXT_LENGTH ];
};

struct CURRENCIES
{
LONG CurrencyID;
NATIONS_PTR CurrencyNation;
DOUBLE CurrencyExchangeRate;
DOUBLE CurrencyApproxExchangeRate;
DOUBLE CurrencyVeryApproxExchangeRate;
CHAR CurrencyNameGender;
CHAR CurrencyShortNameGender;
CHAR CurrencyName[ STANDARD_TEXT_LENGTH ];
CHAR CurrencyShortName[ SHORT_TEXT_LENGTH ];
CHAR Currency3LetterCode[ THREE_LETTER_TEXT_LENGTH ];
CHAR CurrencySymbol[ THREE_LETTER_TEXT_LENGTH ];
};

struct STAGE_NAMES
{
LONG StageNameID;
CHAR StageNameLongName[ STANDARD_TEXT_LENGTH ];
CHAR StageNameShortName[ SHORT_TEXT_LENGTH ];
CHAR StageNamePluralName[ STANDARD_TEXT_LENGTH ];
CHAR StageNameLongNameGender;
CHAR StageNameShortNameGender;
CHAR StageNamePluralNameGender;
};

struct DRAFTED_PLAYERS
{
LONG DraftedPlayerID;
STAFF_PTR DraftedPlayerStaffID;
DRAFTS_PTR DraftedPlayerDraftID;
CLUBS_PTR DraftedPlayerClubID;
SHORT DraftedPlayerYear;
SHORT DraftedPlayerOverall;
UCHAR DraftedPlayerDraftRound;
};

struct DB_PLAYER_RIGHTS
{
LONG PlayerRightsID;
STAFF_PTR PlayerRightsStaffID;
CLUB_COMPS_PTR PlayerRightsCompID;
CLUBS_PTR PlayerRightsClubID;
};

struct CLUB_HISTORIES
{
LONG ClubHistoryID;
CLUB_COMPS_PTR ClubHistoryComp;
CLUBS_PTR ClubHistoryClub;
SHORT ClubHistoryYear;
SHORT ClubHistoryGoalsScored;
SHORT ClubHistoryGoalsAgainst;
SHORT ClubHistoryPoints;
CHAR ClubHistoryPosition;
CHAR ClubHistoryPlayed;
CHAR ClubHistoryWon;
CHAR ClubHistoryTied;
CHAR ClubHistoryLost;
CHAR ClubHistoryOvertimeWins;
CHAR ClubHistoryOvertimeLosses;
CHAR ClubHistoryShootoutWins;
CHAR ClubHistoryShootoutLosses;
};

struct DB_CLUB_RECORDS
{
LONG ClubRecordsID;
CLUBS_PTR ClubRecordsClub;
SHORT ClubRecordsMostTeamPoints;
SHORT ClubRecordsMostTeamPointsYear;
CHAR ClubRecordsMostTeamWins;
SHORT ClubRecordsMostTeamWinsYear;
CHAR ClubRecordsMostTeamLosses;
SHORT ClubRecordsMostTeamLossesYear;
SHORT ClubRecordsMostTeamGoals;
SHORT ClubRecordsMostTeamGoalsYear;
SHORT ClubRecordsMostTeamGoalsAgainst;
SHORT ClubRecordsMostTeamGoalsAgainstYear;
SHORT ClubRecordsLeastTeamPoints;
SHORT ClubRecordsLeastTeamPointsYear;
CHAR ClubRecordsMostTeamTies;
SHORT ClubRecordsMostTeamTiesYear;
SHORT ClubRecordsMostPlayerGoalsSeason;
SHORT ClubRecordsMostPlayerGoalsSeasonYear;
STAFF_PTR ClubRecordsMostPlayerGoalsSeasonStaff;
CHAR_PTR ClubRecordsMostPlayerGoalsSeasonStaffFirstName;
CHAR_PTR ClubRecordsMostPlayerGoalsSeasonStaffSecondName;
SHORT ClubRecordsMostPlayerAssistsSeason;
SHORT ClubRecordsMostPlayerAssistsSeasonYear;
STAFF_PTR ClubRecordsMostPlayerAssistsSeasonStaff;
CHAR_PTR ClubRecordsMostPlayerAssistsSeasonStaffFirstName;
CHAR_PTR ClubRecordsMostPlayerAssistsSeasonStaffSecondName;
SHORT ClubRecordsMostPlayerPointsSeason;
SHORT ClubRecordsMostPlayerPointsSeasonYear;
STAFF_PTR ClubRecordsMostPlayerPointsSeasonStaff;
CHAR_PTR ClubRecordsMostPlayerPointsSeasonStaffFirstName;
CHAR_PTR ClubRecordsMostPlayerPointsSeasonStaffSecondName;
SHORT ClubRecordsMostPlayerPenaltyMinutesSeason;
SHORT ClubRecordsMostPlayerPenaltyMinutesSeasonYear;
STAFF_PTR ClubRecordsMostPlayerPenaltyMinutesSeasonStaff;
CHAR_PTR ClubRecordsMostPlayerPenaltyMinutesSeasonStaffFirstName;
CHAR_PTR ClubRecordsMostPlayerPenaltyMinutesSeasonStaffSecondName;
UCHAR ClubRecordsMostPlayerWinsSeason;
SHORT ClubRecordsMostPlayerWinsSeasonYear;
STAFF_PTR ClubRecordsMostPlayerWinsSeasonStaff;
CHAR_PTR ClubRecordsMostPlayerWinsSeasonStaffFirstName;
CHAR_PTR ClubRecordsMostPlayerWinsSeasonStaffSecondName;
UCHAR ClubRecordsMostPlayerShutoutsSeason;
SHORT ClubRecordsMostPlayerShutoutsSeasonYear;
STAFF_PTR ClubRecordsMostPlayerShutoutsSeasonStaff;
CHAR_PTR ClubRecordsMostPlayerShutoutsSeasonStaffFirstName;
CHAR_PTR ClubRecordsMostPlayerShutoutsSeasonStaffSecondName ;
SHORT ClubRecordsMostPlayerRookiePointsSeason;
SHORT ClubRecordsMostPlayerRookiePointsSeasonYear;
STAFF_PTR ClubRecordsMostPlayerRookiePointsSeasonStaff;
CHAR_PTR ClubRecordsMostPlayerRookiePointsSeasonStaffFirstName;
CHAR_PTR ClubRecordsMostPlayerRookiePointsSeasonStaffSecondName;
SHORT ClubRecordsMostPlayerGamesCareer;
STAFF_PTR ClubRecordsMostPlayerGamesCareerStaff;
CHAR_PTR ClubRecordsMostPlayerGamesCareerStaffFirstName;
CHAR_PTR ClubRecordsMostPlayerGamesCareerStaffSecondName;
SHORT ClubRecordsMostPlayerGoalsCareer;
STAFF_PTR ClubRecordsMostPlayerGoalsCareerStaff;
CHAR_PTR ClubRecordsMostPlayerGoalsCareerStaffFirstName;
CHAR_PTR ClubRecordsMostPlayerGoalsCareerStaffSecondName;
SHORT ClubRecordsMostPlayerAssistsCareer;
STAFF_PTR ClubRecordsMostPlayerAssistsCareerStaff;
CHAR_PTR ClubRecordsMostPlayerAssistsCareerStaffFirstName;
CHAR_PTR ClubRecordsMostPlayerAssistsCareerStaffSecondName;
SHORT ClubRecordsMostPlayerPointsCareer;
STAFF_PTR ClubRecordsMostPlayerPointsCareerStaff;
CHAR_PTR ClubRecordsMostPlayerPointsCareerStaffFirstName;
CHAR_PTR ClubRecordsMostPlayerPointsCareerStaffSecondName;
SHORT ClubRecordsMostPlayerPenaltyMinutesCareer;
STAFF_PTR ClubRecordsMostPlayerPenaltyMinutesCareerStaff;
CHAR_PTR ClubRecordsMostPlayerPenaltyMinutesCareerStaffFirstName;
CHAR_PTR ClubRecordsMostPlayerPenaltyMinutesCareerStaffSecondName;
SHORT ClubRecordsMostPlayerWinsCareer;
STAFF_PTR ClubRecordsMostPlayerWinsCareerStaff;
CHAR_PTR ClubRecordsMostPlayerWinsCareerStaffFirstName;
CHAR_PTR ClubRecordsMostPlayerWinsCareerStaffSecondName;
SHORT ClubRecordsMostPlayerShutoutsCareer;
STAFF_PTR ClubRecordsMostPlayerShutoutsCareerStaff;
CHAR_PTR ClubRecordsMostPlayerShutoutsCareerStaffFirstName;
CHAR_PTR ClubRecordsMostPlayerShutoutsCareerStaffSecondName;
SHORT ClubRecordsMostPlayerRookieGoalsSeason;
SHORT ClubRecordsMostPlayerRookieGoalsSeasonYear;
STAFF_PTR ClubRecordsMostPlayerRookieGoalsSeasonStaff;
CHAR_PTR ClubRecordsMostPlayerRookieGoalsSeasonStaffFirstName;
CHAR_PTR ClubRecordsMostPlayerRookieGoalsSeasonStaffSecondName;
};

struct DRAFTS
{
LONG DraftID;
CLUB_COMPS_PTR DraftComp;
CHAR DraftName[ STANDARD_TEXT_LENGTH ];
CHAR DraftGenderName;
CBOOL DraftExtinct;
};

struct STAFF_LANGUAGES
{
LONG StaffLanguageID;
STAFF_PTR StaffLanguageStaffID;
CHAR StaffLanguageProficiency;
};

struct DB_PLAYER_INFO
{
LONG StaffPlayerInfoID;
STAFF_PTR StaffPlayerInfoStaffID;
SHORT ProfessionalGamesPlayedRegularSeason;
SHORT ProfessionalGamesPlayedPlayoff;
SHORT ProfessionalNHLGamesPlayed;
SHORT CanadianJuniorGamesPlayed;
CHAR NHLSeasonsAccrued;
CBOOL HasPlayedInNorthAmericaAsJunior;
CBOOL HasPlayedInCollege; // NB. this is only present if "version" in index.dat is 0x02 ! (added for patch 3.0.3)
CHAR NorthAmericaMajorJuniorSeasons;

// total stats
SHORT league_appearances_for_club;
SHORT league_goals_for_club;
SHORT league_assists_for_club;
SHORT league_pims_for_club;
SHORT league_wins_for_club;
SHORT league_shutouts_for_club;

SHORT league_total_appearances;
SHORT league_total_goals;
SHORT league_total_assists;
SHORT league_total_pims;
SHORT league_total_wins;
SHORT league_total_shutouts;
};

struct DB_STAFF_INFO
{
LONG StaffInfoID;
STAFF_PTR StaffInfoStaffID;
CLUBS_PTR StaffInfoLastKnownClub;
};

// reset alignment
#ifdef PLATFORM_MAC
#pragma options align=reset
#endif

#endif

[archibalduk]

database_flags.h

//----------------------------------------------------------------------------
// Project: NHL Eastside Hockey Manager
// Sports Interactive Ltd
// Copyright © 2005. All Rights Reserved.
//
// FILE: database_flags.h
// AUTHOR: Graeme Kelly
//
//----------------------------------------------------------------------------

#ifndef DATABASE_FLAGS_H
#define DATABASE_FLAGS_H

// Invalid date def
#define INVALID_DATE DATE( 31, 1900 )

// Languages
#define DB_ALBANIAN 1
#define DB_ARABIC 2
#define DB_BULGARIAN 3
#define DB_CHINESE 4
#define DB_CROATIAN 5
#define DB_CZECH 6
#define DB_DUTCH 7
#define DB_ENGLISH 8
#define DB_FINNISH 9
#define DB_FRENCH 10
#define DB_GERMAN 11
#define DB_GREEK 12
#define DB_HEBREW 13
#define DB_HUNGARIAN 14
#define DB_ITALIAN 15
#define DB_JAPANESE 16
#define DB_KOREAN 17
#define DB_POLISH 18
#define DB_PORTUGUESE 19
#define DB_ROMANIAN 20
#define DB_RUSSIAN 21
#define DB_NORWEGIAN 22
#define DB_SERBIAN 23
#define DB_SPANISH 24
#define DB_TURKISH 25
#define DB_BURMESE 26
#define DB_MALAY 27
#define DB_PERSIAN 28
#define DB_SLOVAK 29
#define DB_SWEDISH 30
#define DB_ICELANDIC 31
#define DB_DANISH 32
#define DB_AFRIKAANS 33
#define _DB_ALBANIAN 34
#define DB_AMHARIC 35
#define DB_ARMENIAN 36
#define DB_AZERI 37
#define DB_BANGLA 38
#define DB_ESTONIAN 39
#define DB_GEORGIAN 40
#define DB_HINDI 41
#define DB_JAVANESE 42
#define DB_KHMER 43
#define DB_KYRGYZ 44
#define DB_LAO 45
#define DB_LATVIAN 46
#define DB_LETBURGESCH 47
#define DB_LITHUANIAN 48
#define DB_MACEDONIAN 49
#define DB_MALAGASY 50
#define DB_MALTESE 51
#define DB_SINHALESE 52
#define DB_SLOVENIAN 53
#define DB_SOMALI 54
#define DB_SWAHILI 55
#define DB_TAJIK 56
#define DB_TAMIL 57
#define DB_THAI 58
#define DB_UZBEK 59
#define VIETNAMESE 60
#define DB_MONGOL 61
#define DB_BOSNIAN 62
#define DB_UKRAINIAN 63
#define DB_ZULU 64

#define DB_NUMBER_OF_MDB_LANGUAGES DB_ZULU;

enum {
GAME_IMPORTANCE_MAJOR = 1,
GAME_IMPORTANCE_NORMAL = 2,
GAME_IMPORTANCE_MINOR = 3,
GAME_IMPORTANCE_NO_HOCKEY = 4
};


// NationGroupDefines
enum {
EEC_COUNTRY = 2,
NON_EEC_COUNTRY = 1
};

// Selected leagues defs
enum {
NOT_SELECTED = 0x0000,
SELECTED_BACKGROUND = 0x0001,
SELECTED_FOREGROUND = 0x0002,
ALL_DIVISIONS_ACTIVE = 0x0004,
SELECTED_START_DATE = 0x0008
};

// Ice conditions
enum {
ICE_EXCELLENT = 1,
ICE_GOOD,
ICE_POOR,
ICE_VERY_POOR
};

// rink size
enum {
RINK_SIZE_EURO = 1,
RINK_SIZE_NHL
};


// nation actual region
enum {
ACTUAL_REGION_AFRICA = 1,
ACTUAL_REGION_ASIA,
ACTUAL_REGION_CARIBBEAN,
ACTUAL_REGION_CENTRAL_AMERICA,
ACTUAL_REGION_CENTRAL_EUROPE,
ACTUAL_REGION_EASTERN_EUROPE,
ACTUAL_REGION_MIDDLE_EAST,
ACTUAL_REGION_NORTH_AFRICA,
ACTUAL_REGION_NORTH_AMERICA,
ACTUAL_REGION_OCEANIA,
ACTUAL_REGION_SCANDINAVIA,
ACTUAL_REGION_SOUTH_AMERICA,
ACTUAL_REGION_SOUTHERN_EUROPE,
ACTUAL_REGION_UK_AND_IRELAND,
FIRST_ACTUAL_REGION = ACTUAL_REGION_AFRICA,
LAST_ACTUAL_REGION = ACTUAL_REGION_UK_AND_IRELAND
};


// club professional status
enum {
PROFESSIONAL = 1,
SEMI_PRO,
AMATEUR
};

// states of development
enum {
DEVELOPED_STATE = 1,
DEVLOPING_STATE,
THIRD_WORLD_STATE
};

// database days of the week
enum {
DB_SUN = 1,
DB_MON,
DB_TUE,
DB_WED,
DB_THUR,
DB_FRI,
DB_SAT
};

// staff job for club/nation
enum {
JOB_INVALID_JOB = 0,
JOB_CHAIRMAN,
JOB_MANAGING_DIRECTOR,
JOB_PRESIDENT,
JOB_DIRECTOR_OF_PERSONNEL,
JOB_MANAGER,
JOB_ASSISTANT_MANAGER,
JOB_HEAD_COACH,
JOB_COACH,
JOB_SCOUT,
JOB_PHYSIO,
JOB_PLAYER,
JOB_PLAYER_COACH,
JOB_MEDIA_PUNDIT,
JOB_PLAYER_RETIRED,
JOB_HEAD_SCOUT, // Do not assign in the database
JOB_MANAGER_HEAD_COACH
};

// staff classification
typedef enum {
SC_INVALID = 0,
SC_NON_PLAYER,
SC_PLAYER,
SC_NON_PLAYER_AND_PLAYER,
SC_NEW_HUMAN_MANAGER,
SC_SPARE_NON_PLAYER,
SC_SPARE_PLAYER
} STAFF_CLASSIFICATION;

// Player form definitions
enum {
VERY_POOR = 0,
POOR,
AVERAGE,
GOOD,
VERY_GOOD,
SUPERB
};

// goalie styles
enum {
GOALIE_STYLE_MIXED = 0,
GOALIE_STYLE_BUTTERFLY,
GOALIE_STYLE_STANDUP,
GOALIE_STYLE_UNORTHODOX,
MAX_GOALIE_STYLES
};

// junior career prefs
//-1;None;0;College;1;Major Junior;2;Junior (Europe)
enum {
JUNIOR_PREFERENCE_NONE = -1,
JUNIOR_PREFERENCE_COLLEGE,
JUNIOR_PREFERENCE_MAJOR_JUNIOR,
JUNIOR_PREFERENCE_EUROPE
};

// handedness
enum {
RIGHT_HANDED = 0,
LEFT_HANDED,
SHOOTS_LEFT = LEFT_HANDED,
SHOOTS_RIGHT = RIGHT_HANDED,
CATCHES_LEFT = LEFT_HANDED,
CATCHES_RIGHT = RIGHT_HANDED
};

// Primary colour definitions
enum {
PRIMARY_BLACK = 1,
PRIMARY_WHITE,
PRIMARY_GREY,
PRIMARY_YELLOW,
PRIMARY_GREEN,
PRIMARY_BLUE,
PRIMARY_PURPLE,
PRIMARY_RED,
PRIMARY_ORANGE,
PRIMARY_BROWN
};

enum {
NATION_DECLARED_NONE = 0,
NATION_DECLARED_FIRST,
NATION_DECLARED_SECOND
};


#endif

[archibalduk]

language_types.h

//----------------------------------------------------------------------------
// Project: NHL Eastside Hockey Manager
// Sports Interactive Ltd
// Copyright © 2005. All Rights Reserved.
//
// FILE: language_types.h
// AUTHOR: Graeme Kelly
//
//----------------------------------------------------------------------------

#ifndef LANGUAGE_TYPES_H
#define LANGUAGE_TYPES_H

#include "language_types.h"

#ifdef PLATFORM_MAC
#pragma options align=packed
#endif

typedef struct
{
LONG club_tbl_sz;
LONG continent_tbl_sz;
LONG nation_comp_tbl_sz;
LONG nation_tbl_sz;
LONG cities_tbl_sz;
LONG club_comp_tbl_sz;
LONG stadiums_tbl_sz;
LONG staff_comp_tbl_sz;
LONG states_provinces_tbl_sz;
LONG injury_tbl_sz;
LONG currencies_tbl_sz;
LONG drafts_tbl_sz;
LONG stage_names_tbl_sz;
} LANG_HEADER;

#ifdef PLATFORM_MAC
#pragma options align=reset
#endif

// Structure containing club language information
typedef struct
{
CHAR ClubName[ STANDARD_TEXT_LENGTH ];
CHAR GenderClubName;
CHAR ClubNameShort[ SHORT_TEXT_LENGTH ];
CHAR GenderClubNameShort;
} CLUB_LANG;

// Structure containing continent language information
typedef struct
{
CHAR ContinentName[ SHORT_TEXT_LENGTH ];
CHAR GenderContinentName;
CHAR ContinentNameThreeLetter[ 4 ];
CHAR ContinentNameNationality[ SHORT_TEXT_LENGTH ];
} CONTINENT_LANG;

// Structure containing nation competition language information
typedef struct
{
CHAR NationCompName[ STANDARD_TEXT_LENGTH ];
CHAR GenderNationCompName;
CHAR NationCompNameShort[ SHORT_TEXT_LENGTH ];
CHAR GenderNationCompNameShort;
CHAR NationCompNameSixLetter[ 7 ];
} NATION_COMP_LANG;

// Structure containing nation language information
typedef struct
{
CHAR NationName[ STANDARD_TEXT_LENGTH ];
CHAR GenderNationName;
CHAR NationNameShort[ SHORT_TEXT_LENGTH ];
CHAR GenderNationNameShort;
CHAR NationNameThreeLetter[ 4 ];
CHAR NationNameNationality[ SHORT_TEXT_LENGTH ];
} NATION_LANG;

// Structure containing city language information
typedef struct
{
CHAR CityName[ STANDARD_TEXT_LENGTH ];
CHAR GenderCityName;
} CITY_LANG;

typedef struct
{
CHAR StateName[ STANDARD_TEXT_LENGTH ];
CHAR GenderStateName;
CHAR StateAbbrev[ REAL_SHORT_TEXT_LENGTH ];
} STATE_LANG;

typedef struct
{
CHAR InjuryName[ STANDARD_TEXT_LENGTH ];
CHAR InjuryNameDative[ STANDARD_TEXT_LENGTH ];
CHAR InjuryNameGenetive[ STANDARD_TEXT_LENGTH ];
CHAR InjuryNameSpecialNominative[ STANDARD_TEXT_LENGTH ];
CHAR InjuryGender;
} INJURY_LANG;

// Structure containing stadium language information
typedef struct
{
CHAR StadiumName[ STANDARD_TEXT_LENGTH ];
CHAR GenderStadiumName;
} STADIUM_LANG;

// Structure containing club comp language information
typedef struct
{
CHAR ClubCompName[ STANDARD_TEXT_LENGTH ];
CHAR GenderClubCompName;
CHAR ClubCompNameShort[ SHORT_TEXT_LENGTH ];
CHAR GenderClubCompNameShort;
CHAR ClubCompNameSixLetter[ 7 ];
CHAR ClubCompPlayoffTrophyName[ STANDARD_TEXT_LENGTH ];
CHAR ClubCompPlayoffTrophyGender;
CHAR ClubCompRegularSeasonTrophyName[ STANDARD_TEXT_LENGTH ];
CHAR ClubCompRegularSeasonTrophyGender;
} CLUB_COMP_LANG;

// Structure containing currencies language information
typedef struct
{
CHAR CurrencyName[ STANDARD_TEXT_LENGTH ];
CHAR CurrencyNameGender;
CHAR CurrencyShortName[ SHORT_TEXT_LENGTH ];
CHAR CurrencyShortNameGender;
} CURRENCY_LANG;

// Structure containing staff language information
typedef struct
{
CHAR StaffCompName[ STANDARD_TEXT_LENGTH ];
CHAR GenderStaffCompName;
CHAR StaffCompNameShort[ SHORT_TEXT_LENGTH ];
CHAR GenderStaffCompNameShort;
} STAFF_COMP_LANG;

// Structure containing draft language information
typedef struct
{
CHAR DraftName[ STANDARD_TEXT_LENGTH ];
CHAR DraftNameGender;
} DRAFT_LANG;

// Structure containing draft language information
typedef struct
{
CHAR StageNameLongName[ STANDARD_TEXT_LENGTH ];
CHAR StageNameLongNameGender;
CHAR StageNamePluralName[ STANDARD_TEXT_LENGTH ];
CHAR StageNamePluralNameGender;
CHAR StageNameShortName[ SHORT_TEXT_LENGTH ];
CHAR StageNameShortNameGender;
} STAGE_NAMES_LANG;

#endif

[archibalduk]

Some tables are sorted. You need to retain the sort order. These are:

[table][tr][th]Dat File[/th][th]Sort order[/th][/tr]
[tr][td]club.dat & nat_club.dat[/td][td]short name, long name[/td][/tr]
[tr][td]club_comp_history.dat & nation_comp_history.dat[/td][td]comp id, year[/td][/tr]
[tr][td]nation.dat[/td][td]short name, long name[/td][/tr]
[tr][td]officials.dat[/td][td]nation id, reputation[/td][/tr]
[tr][td]first_names.dat & second_names.dat[/td][td]nation id, name string[/td][/tr]
[tr][td]staff.dat[/td][td]second name, first name (id)[/td][/tr]
[tr][td]staff_history.dat[/td][td]staff id, year, club id, comp id, playoff[/td][/tr][/table]

For example, as per the table above, the records in the staff_history.dat file are ordered by staff id, then year, then club id, then comp id and then by playoffs.

*originally posted here by Graeme Kelly.