Changes Required to Migrate the EGD

From US Go Wiki
Jump to: navigation, search

Contents

Configuration File Changes

Configuring PHP to Access MySQL

  1. Edit the files ./Config.inc, ./Config_AGAGD.inc, and ./Config_DB_images.inc
  2. Set the variables $ADMIN[NomeHost], $ADMIN[NomeUtente] and $ADMIN[PasswUtente] to the values required to access the database

Database

The database schema must be changed to accommodate the AGA data. For details see AGAGD Database Schema and AGA and EGD Data

Errors

  • ./Actions_logo_front.php: Replace Page_links with page_links
  • ./Actions_logo.php: Replace Page_links with page_links
  • ./Find_Player.php: Replace | Main panel with | Find Player
  • ./Find_Tournament.php:
    • Replace | Main panel with | Find Tournament
    • Date selector widgets use the format: dd/mm/yyyy while adjoining the text entry guideline states the format dd-mm-yyyy
  • ./index.php: Replace Page_links with page_links
  • ./index.php: Replace var address = '../Modus_foto.html'; with var address = './Modus_foto.html';
  • ./Player_Card.php:
    • Replace | Main panel with | Player Card
    • Replace Page_links with page_links
  • ./Tournament_Card.php:
    • Replace include_once("Config_EGDGD.inc"); with include_once("Config_AGAGD.inc");
    • Replace | Main panel with | Find Tournament

HTML Files

  • ./Disclaimer.html: Replace references to the EGF and EGD

Images

  • ./Immagini/Sfondo_base_AGAGD.gif: Replace EGD with AGAGD

PHP Files

  • ./Find_Games.php
    • replace from T_Games with from games FAILED
    • comment out $Query .= $Date_Query; FAILED
    • comment out $Query .= " ORDER BY Tournament_Date DESC LIMIT 0,500"; FAILED
    • change
  • ./Find_Player.php
    • comment out the line $Query[] = "WHERE EGF_Placement is not null";
    • remove EGF_Placement from the $Query[] arrays (two places)
    • remove EGF placement from the $Titoli_colonne arrays (two places)
    • change Gor to Rating in the $Query[] arrays (two places)
    • change Gor to Rating in the $Titoli_colonne arrays (two places)
    • change DGor to Sigma in the $Query[] arrays (two places)
    • add Sigma to the $Titoli_colonne arrays immediately after Rating (two places)
  • ./Find_Tournament.php
    • remove Tournament_Class from the $Query[] arrays (two places)
    • remove Class from the $Titoli_colonne arrays (two places)
  • ./includes/Func_Lib.php: function Version (): Replace references to the EGF and EGD

Template Files


American_Go_Assocation_Go_Database

Personal tools