TSV_FILE="$1"

TYPE="${2:-0}"

DATABASE_FILE="$3"

DATABASE_FN="pkgi"

DATABASE_EXT="txt"

DATABASE_TYPE=""

case "$TYPE" in

[0-9]) TYPE_ID="$2";;

Uknown | none | NONE) TYPE_ID=0;;

Game | game | GAME) TYPE_ID=1 && DATABASE_TYPE='_games';;

dlc|DLC) TYPE_ID=2 && DATABASE_TYPE='_dlcs';;

Theme | theme | THEME) TYPE_ID=3 && DATABASE_TYPE='_themes';;

Avatar | avatar | AVATAR) TYPE_ID=4 && DATABASE_TYPE='_avatars';;

Demo | DEMO | demo) TYPE_ID=5 && DATABASE_TYPE='_demos';;

Manager | manager | MANAGER) TYPE_ID=6 && DATABASE_TYPE='_managers';;

Emulator | emulator | EMULATOR) TYPE_ID=7 && DATABASE_TYPE='_emulators';;

App | app | APP) TYPE_ID=8 && DATABASE_TYPE='_apps';;

Tool |tool | TOOL) TYPE_ID=9 && DATABASE_TYPE='_tools';;

*) TYPE_ID=0;;

[ -z "$DATABASE_FILE"] && DATABASE_FILE="${DATABASE_FN}${DATABASE_TYPE}.${DATABASE_EXT}"

tail -n +2 "$TSV_FILE" | awk -F ' ' '{print $6","'"$TYPE_ID"'","$3",,"$5","$4","$9","$10}' > "$DATABASE_FILE"