/**
  * Read existing data
  */
 private function readExistingData()
 {
     Configuration::loadAll();
     $Tables = array('sport' => 'name', 'type' => 'name', 'plugin' => 'key', 'equipment' => 'name', 'equipment_type' => 'name', 'tag' => 'tag');
     foreach ($Tables as $Table => $Column) {
         $this->ExistingData['runalyze_' . $Table] = array();
         $Statement = $this->DB->query('SELECT `id`,`' . $Column . '` FROM `' . PREFIX . $Table . '`');
         while ($Row = $Statement->fetch()) {
             $this->ExistingData['runalyze_' . $Table][$Row[$Column]] = $Row['id'];
         }
     }
     $FetchEquipmentSportRelation = $this->DB->query('SELECT CONCAT(`sportid`, "-", `equipment_typeid`) FROM `' . PREFIX . 'equipment_sport`');
     $this->ExistingData['runalyze_equipment_sport'] = array();
     while ($Relation = $FetchEquipmentSportRelation->fetchColumn()) {
         $this->ExistingData['runalyze_equipment_sport'][] = $Relation;
     }
 }
 /**
  * Read existing data
  */
 private function readExistingData()
 {
     Configuration::loadAll();
     $Tables = array('clothes' => 'name', 'shoe' => 'name', 'sport' => 'name', 'type' => 'name', 'plugin' => 'key');
     foreach ($Tables as $Table => $Column) {
         $this->ExistingData['runalyze_' . $Table] = array();
         $Statement = $this->DB->query('SELECT `id`,`' . $Column . '` FROM `' . PREFIX . $Table . '`');
         while ($Row = $Statement->fetch()) {
             $this->ExistingData['runalyze_' . $Table][$Row[$Column]] = $Row['id'];
         }
     }
 }
Example #3
0
 /**
  * Init constants
  */
 private function defineConsts()
 {
     require_once FRONTEND_PATH . 'system/define.consts.php';
     Configuration::loadAll();
     \Runalyze\Calculation\JD\VDOTCorrector::setGlobalFactor(Configuration::Data()->vdotFactor());
     require_once FRONTEND_PATH . 'class.Helper.php';
 }