function TruncateTablesForDevelopment() { $db = JFactory::getDbo(); echo '<b>' . JText::_('Truncating some tables for a clean update') . '</b><br /><br />'; $query = 'TRUNCATE TABLE `#__joomleague_club`'; $db->setQuery($query); $db->execute(); $query = 'TRUNCATE TABLE `#__joomleague_division`'; $db->setQuery($query); $db->execute(); $query = 'TRUNCATE TABLE `#__joomleague_eventtype`'; $db->setQuery($query); $db->execute(); $query = 'TRUNCATE TABLE `#__joomleague_league`'; $db->setQuery($query); $db->execute(); $query = 'TRUNCATE TABLE `#__joomleague_match`'; $db->setQuery($query); $db->execute(); $query = 'TRUNCATE TABLE `#__joomleague_match_event`'; $db->setQuery($query); $db->execute(); $query = 'TRUNCATE TABLE `#__joomleague_match_player`'; $db->setQuery($query); $db->execute(); $query = 'TRUNCATE TABLE `#__joomleague_match_referee`'; $db->setQuery($query); $db->execute(); $query = 'TRUNCATE TABLE `#__joomleague_match_staff`'; $db->setQuery($query); $db->execute(); $query = 'TRUNCATE TABLE `#__joomleague_person`'; $db->setQuery($query); $db->execute(); $query = 'TRUNCATE TABLE `#__joomleague_playground`'; $db->setQuery($query); $db->execute(); $query = 'TRUNCATE TABLE `#__joomleague_position`'; $db->setQuery($query); $db->execute(); $query = 'TRUNCATE TABLE `#__joomleague_position_eventtype`'; $db->setQuery($query); $db->execute(); $query = 'TRUNCATE TABLE `#__joomleague_project`'; $db->setQuery($query); $db->execute(); $query = 'TRUNCATE TABLE `#__joomleague_project_position`'; $db->setQuery($query); $db->execute(); $query = 'ALTER TABLE `#__joomleague_project_position` AUTO_INCREMENT =1000'; $db->setQuery($query); $db->execute(); $query = 'TRUNCATE TABLE `#__joomleague_project_referee`'; $db->setQuery($query); $db->execute(); $query = 'TRUNCATE TABLE `#__joomleague_project_team`'; $db->setQuery($query); $db->execute(); $query = 'TRUNCATE TABLE `#__joomleague_round`'; $db->setQuery($query); $db->execute(); $query = 'TRUNCATE TABLE `#__joomleague_season`'; $db->setQuery($query); $db->execute(); $query = 'TRUNCATE TABLE `#__joomleague_team`'; $db->setQuery($query); $db->execute(); $query = 'TRUNCATE TABLE `#__joomleague_team_player`'; $db->setQuery($query); $db->execute(); $query = 'TRUNCATE TABLE `#__joomleague_team_staff`'; $db->setQuery($query); $db->execute(); $query = 'TRUNCATE TABLE `#__joomleague_template_config`'; $db->setQuery($query); $db->execute(); $query = 'TRUNCATE TABLE `#__joomleague_team_trainingdata`'; $db->setQuery($query); $db->execute(); $query = 'TRUNCATE TABLE `#__joomleague_prediction_game`'; $db->setQuery($query); $db->execute(); $query = 'TRUNCATE TABLE `#__joomleague_prediction_admin`'; $db->setQuery($query); $db->execute(); $query = 'TRUNCATE TABLE `#__joomleague_prediction_member`'; $db->setQuery($query); $db->execute(); $query = 'TRUNCATE TABLE `#__joomleague_prediction_project`'; $db->setQuery($query); $db->execute(); $query = 'TRUNCATE TABLE `#__joomleague_prediction_result`'; $db->setQuery($query); $db->execute(); $query = 'TRUNCATE TABLE `#__joomleague_prediction_template`'; $db->setQuery($query); $db->execute(); echo addGhostPlayer(); return ''; }
$strings = $props['strings']; $praefix = 'COM_JOOMLEAGUE_ST_'; foreach ($strings as $key => $value) { // Add all Sport-types e.g. Soccer to #__joomleague_sports_type $pos = strpos($key, $praefix); if ($pos !== false) { $name = strtolower(substr($key, strlen($praefix))); $tblSportsType = JTable::getInstance("SportsType", "Table"); //fix for existing items $tblSportsType->load(array("name" => $key)); $tblSportsType->name = $key; $tblSportsType->icon = JPATH::clean('images/com_joomleague/database/sport_types/' . $name . '.png'); if (!$tblSportsType->store()) { //echo($tblSportsType->getError()); $status = 2; } JFolder::create(JPATH::clean(JPATH_ROOT . '/images/com_joomleague/database/events/' . $name)); } } return $status; } //_checkVersionTable(); $versionData = getVersion(); $major = $versionData->major; $minor = $versionData->minor; $build = $versionData->build; $revision = $versionData->revision; $version = sprintf('v%1$s.%2$s.%3$s.%4$s', $major, $minor, $build, $revision); echo PrintStepResult(addGhostPlayer()); echo PrintStepResult(addSportsType()); echo PrintStepResult(updateVersion($versionData));