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));
