function migrateAssets()
{
$maxImportTime = JComponentHelper::getParams('com_joomleague')->get('max_import_time', 0);
if (empty($maxImportTime)) {
$maxImportTime = 9000;
}
if ((int) ini_get('max_execution_time') < $maxImportTime) {
@set_time_limit($maxImportTime);
}
$query = "SHOW TABLES LIKE '%_joomleague%'";
$db = JFactory::getDbo();
$tables = array();
$db->setQuery($query);
$results = $db->loadColumn();
foreach ($results as $tablename) {
$fields = $db->getTableColumns($tablename);
foreach ($fields as $field) {
if (in_array('asset_id', array_keys($field))) {
$tables[] = $tablename;
}
}
}
for ($i = 0; $i < count($tables); $i++) {
$table = $tables[$i];
$query = 'SELECT id FROM ' . $table;
$db->setQuery($query);
if ($items = $db->loadObjectList()) {
$table = str_replace($db->getPrefix() . 'joomleague_', '', $table);
foreach ($items as $item) {
// TODO: process the $table string such that it reflects the class name
// JTable::getInstance now expects $type and $prefix with proper capitals (as table class name)
// Could replace first letter and every letter following an underscore by its capital
// and removing the underscores, but that would fail for eventtype, position_eventtype
// and team_trainingdata and template_config
$tbl = JTable::getInstance(str_replace('_', '', $table), "Table");
if ($tbl->load($item->id)) {
}
$tbl->store(true);
}
}
echo '<br>Migrated ' . count($items) . ' records in ' . $tables[$i] . ' ';
echo PrintStepResult(true);
}
return '';
}
function migrateAssets()
{
$maxImportTime = JComponentHelper::getParams('com_joomleague')->get('max_import_time', 0);
if (empty($maxImportTime)) {
$maxImportTime = 9000;
}
if ((int) ini_get('max_execution_time') < $maxImportTime) {
@set_time_limit($maxImportTime);
}
$query = "SHOW TABLES LIKE '%_joomleague%'";
$db = JFactory::getDbo();
$tables = array();
$db->setQuery($query);
$results = $db->loadColumn();
foreach ($results as $tablename) {
$fields = $db->getTableColumns($tablename);
foreach ($fields as $field) {
if (in_array('asset_id', array_keys($field))) {
$tables[] = $tablename;
}
}
}
for ($i = 0; $i < count($tables); $i++) {
$table = $tables[$i];
$query = 'SELECT id FROM ' . $table;
$db->setQuery($query);
if ($items = $db->loadObjectList()) {
$table = str_replace($db->getPrefix() . 'joomleague_', '', $table);
foreach ($items as $item) {
$tbl = JTable::getInstance(str_replace('_', '', $table), "Table");
if ($tbl->load($item->id)) {
}
$tbl->store(true);
}
}
echo '<br>Migrated ' . count($items) . ' records in ' . $tables[$i] . ' ';
echo PrintStepResult(true);
}
return '';
}
function TipResultsToPredictionResults()
{
$db = JFactory::getDbo();
$result = true;
$copied = false;
$i = 0;
//$query='TRUNCATE TABLE `#__joomleague_prediction_result`'; $db->setQuery($query); $db->execute();
echo JText::sprintf('Copying --> Table content of [%1$s] to [%2$s]', '<b>joomleague_tip_results</b>', '<b>joomleague_prediction_result</b>');
$query = 'SELECT * FROM #__joomleague_tip_results';
$db->setQuery($query);
if ($predictiongametipresults = $db->loadObjectList()) {
$query = 'SELECT prediction_id,tmp_old_pid FROM #__joomleague_prediction_project';
$db->setQuery($query);
$dPredProject = $db->loadAssocList('tmp_old_pid');
//echo '<pre>~'.print_r($dPredProject,true).'~</pre>';
$query = 'SELECT id,tmp_old_pid FROM #__joomleague_project';
$db->setQuery($query);
$dProjects = $db->loadAssocList('tmp_old_pid');
$query = 'SELECT id,tmp_old_match_id FROM #__joomleague_match';
$db->setQuery($query);
$dMatches = $db->loadAssocList('tmp_old_match_id');
foreach ($predictiongametipresults as $predictiongametipresult) {
if (isset($dPredProject[$predictiongametipresult->project_id])) {
$prediction_id = $dPredProject[$predictiongametipresult->project_id]['prediction_id'];
// get new prediction_id...
if (isset($dProjects[$predictiongametipresult->project_id])) {
$project_id = $dProjects[$predictiongametipresult->project_id]['id'];
// get new project id of predProject...
if (isset($dMatches[$predictiongametipresult->match_id])) {
$match_id = $dMatches[$predictiongametipresult->match_id]['id'];
if ($predictiongametipresult->tip != '0') {
$tipp = empty($predictiongametipresult->tip) ? 'NULL' : "'" . $predictiongametipresult->tip . "'";
} else {
$tipp = "'0'";
}
if ($predictiongametipresult->tip_home != '0') {
$tipp_home = empty($predictiongametipresult->tip_home) ? 'NULL' : "'" . $predictiongametipresult->tip_home . "'";
} else {
$tipp_home = "'0'";
}
if ($predictiongametipresult->tip_away != '0') {
$tipp_away = empty($predictiongametipresult->tip_away) ? 'NULL' : "'" . $predictiongametipresult->tip_away . "'";
} else {
$tipp_away = "'0'";
}
if ($predictiongametipresult->joker != '0') {
$joker = empty($predictiongametipresult->joker) ? 'NULL' : "'" . $predictiongametipresult->joker . "'";
} else {
$joker = "'0'";
}
$copied = true;
$result = true;
$query = "\tINSERT INTO\t#__joomleague_prediction_result\n\t\t\t\t\t\t\t\t\t\t\t\t\t(\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t`prediction_id`,\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t`user_id`,\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t`project_id`,\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t`match_id`,\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t`tipp`,\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t`tipp_home`,\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t`tipp_away`,\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t`joker`,\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t`tmp_old_id`\n\t\t\t\t\t\t\t\t\t\t\t\t\t)\n\t\t\t\t\t\t\t\t\t\t\t\tVALUES\n\t\t\t\t\t\t\t\t\t\t\t\t\t(\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t'{$prediction_id}',\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t'{$predictiongametipresult->user_id}',\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t'{$project_id}',\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t'{$match_id}',\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t{$tipp},\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t{$tipp_home},\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t{$tipp_away},\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t{$joker},\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t'{$predictiongametipresult->id}'\n\t\t\t\t\t\t\t\t\t\t\t\t\t)";
$db->setQuery($query);
if (!$db->execute()) {
$result = false;
echo PrintStepResult($result) . '<br />';
echo '<br />' . $db->getErrorMsg() . ' <br />';
} else {
$i++;
}
} else {
$match_id = 0;
}
} else {
$project_id = 0;
}
} else {
$prediction_id = 0;
}
}
} else {
$result = false;
echo PrintStepResult($result) . '<br />';
echo '<br />' . $db->getErrorMsg() . ' <br />';
}
if ($i == count($predictiongametipresults)) {
$color = 'green';
} elseif ($i == 0) {
$color = 'red';
} else {
$color = 'orange';
}
echo '<br /><br /><b style="color:' . $color . ';" >' . JText::sprintf('COM_JOOMLEAGUE_DB_UPDATE_COPIED_X_OF_Y_RECORDS', $i, count($predictiongametipresults)) . '</b><br /><br />';
return '';
}
function UpdateTemplateMasters()
{
/**********************************
******** Update Script for xml template to store the non existing Variable
***********************************/
/*
* developer: diddipoeler
* date: 13.01.2011
* Bugtracker Backend Bug #579
* change old textname in newtextname
*/
$convert = array('JL_AGAINST' => 'AGAINST', 'JL_AVG' => 'AVG', 'JL_BONUS' => 'BONUS', 'JL_DIFF' => 'DIFF', 'JL_FOR' => 'FOR', 'JL_GB' => 'GB', 'JL_H2H' => 'H2H', 'JL_H2H_AWAY' => 'H2H_AWAY', 'JL_H2H_DIFF' => 'H2H_DIFF', 'JL_H2H_FOR' => 'H2H_FOR', 'JL_LEGS' => 'LEGS', 'JL_LEGS_DIFF' => 'LEGS_DIFF', 'JL_LEGS_RATIO' => 'LEGS_RATIO', 'JL_LEGS_WIN' => 'LEGS_WIN', 'JL_LOSSES' => 'LOSSES', 'JL_NEGPOINTS' => 'NEGPOINTS', 'JL_OLDNEGPOINTS' => 'OLDNEGPOINTS', 'JL_PLAYED' => 'PLAYED', 'JL_POINTS' => 'POINTS', 'JL_POINTS_RATIO' => 'POINTS_RATIO', 'JL_QUOT' => 'QUOT', 'JL_RESULTS' => 'RESULTS', 'JL_SCOREAGAINST' => 'SCOREAGAINST', 'JL_SCOREFOR' => 'SCOREFOR', 'JL_SCOREPCT' => 'SCOREPCT', 'JL_START' => 'START', 'JL_TIES' => 'TIES', 'JL_WINPCT' => 'WINPCT', 'JL_WINS' => 'WINS');
echo '<b>' . JText::_('Updating new variables and templates for usage in the Master-Templates') . '</b><br />';
$db = JFactory::getDBO();
$query = 'SELECT id,name,master_template FROM #__joomleague_project';
$db->setQuery($query);
if ($projects = $db->loadObjectList()) {
//echo '<br />';
$xmldir = JPATH_SITE . DS . 'components' . DS . 'com_joomleague' . DS . 'settings' . DS . 'default';
if ($handle = JFolder::files($xmldir)) {
# check that each xml template has a corresponding record in the
# database for this project (except for projects using master templates).
# If not,create the rows with default values
# from the xml file
foreach ($handle as $file) {
if (strtolower(substr($file, -3)) == 'xml' && substr($file, 0, strlen($file) - 4) != 'table' && substr($file, 0, 10) != 'prediction') {
$defaultconfig = array();
$template = substr($file, 0, strlen($file) - 4);
$out = simplexml_load_file($xmldir . DS . $file, 'SimpleXMLElement', LIBXML_NOCDATA);
$temp = '';
$arr = obj2Array($out);
$outName = JText::_($out->name[0]);
echo '<br />' . JText::sprintf('Template: [%1$s] - Name: [%2$s]', "<b>{$template}</b>", "<b>{$outName}</b>") . '<br />';
if (isset($arr["fieldset"]["field"])) {
foreach ($arr["fieldset"]["field"] as $param) {
$temp .= $param["@attributes"]["name"] . "=" . $param["@attributes"]["default"] . "\n";
$defaultconfig[$param["@attributes"]["name"]] = $param["@attributes"]["default"];
}
} else {
foreach ($arr["fieldset"] as $paramsgroup) {
foreach ($paramsgroup["field"] as $param) {
if (!isset($param["@attributes"])) {
if (isset($param["name"])) {
$temp .= $param["name"] . "=" . $param["default"] . "\n";
$defaultconfig[$param["name"]] = $param["default"];
}
} else {
if (isset($param["name"])) {
/*
* developer: diddipoeler
* date: change on 13.01.2011
* Bugtracker Backend Bug #579
* error message string to object example template teamstats
*/
//$temp .= $param["@attributes"]["name"]."=".$param["@attributes"]["default"]."\n";
$temp .= $param["name"] . "=" . $param["default"] . "\n";
//$defaultconfig[$param["@attributes"]["name"]]=$param["@attributes"]["default"];
$defaultconfig[$param["name"]] = $param["default"];
}
}
}
}
}
$changeNeeded = false;
foreach ($projects as $proj) {
$count_diff = 0;
$configvalues = array();
$query = "SELECT params FROM #__joomleague_template_config WHERE project_id={$proj->id} AND template='" . $template . "'";
$db->setQuery($query);
if ($id = $db->loadResult()) {
//template present in db for this project
$string = '';
$templateTitle = '';
$params = explode("\n", trim($id));
foreach ($params as $param) {
$row = explode("=", $param);
if (isset($row[1])) {
list($name, $value) = $row;
$configvalues[$name] = $value;
}
}
foreach ($defaultconfig as $key => $value) {
if (!array_key_exists($key, $configvalues)) {
$count_diff++;
$configvalues[$key] = $value;
}
}
if ($count_diff || $template == 'ranking' || $template == 'overall') {
foreach ($configvalues as $key => $value) {
if (preg_match("/%H:%m/i", $value)) {
// change text
$value = 'H:i';
} else {
// text ok
}
/*
* developer: diddipoeler
* date: change on 13.01.2011
* Bugtracker Backend Bug #579
* change old textname in newtextname
*/
if (preg_match("/JL_/i", $value)) {
// change text
$value = str_replace(array_keys($convert), array_values($convert), $value);
} else {
// text ok
}
$value = trim($value);
$string .= "{$key}={$value}\n";
}
echo JText::sprintf('Difference found for project [%1$s]', '<b>' . $proj->name . '</b>') . ' - ';
$changeNeeded = true;
$query = " UPDATE #__joomleague_template_config ";
$query .= " SET ";
$query .= " title='" . $out->name[0] . "',";
$query .= " params='{$string}' ";
$query .= " WHERE template='{$template}' AND project_id=" . $proj->id;
$db->setQuery($query);
if (!$db->query()) {
echo '<span style="color:red">';
echo JText::sprintf('Problems while saving config for [%1$s] with project-ID [%2$s]!', '<b>' . $template . '</b>', '<b>' . $proj->id . '</b>');
echo '</span>' . '<br />';
echo $db->getErrorMsg() . '<br />';
} else {
echo JText::sprintf('Updated template [%1$s] with project-ID [%2$s]', '<span style="color:green;"><b>' . $template . '</b></span>', '<span style="color:green"><b>' . $proj->id . '</b></span>') . PrintStepResult(true) . '<br />';
}
}
} elseif ($proj->master_template == 0) {
//check that project has own templates
//or if template not present,create a row with default values
echo '<br /><span style="color:orange;">' . JText::sprintf('Need to insert into project with project-ID [%1$s] - Project name is [%2$s]', '<b>' . $proj->id . '</b>', '<b>' . $proj->name . '</b>') . '</span><br />';
$changeNeeded = true;
$temp = trim($temp);
$query = "\tINSERT\n\t\t\t\t\t\t\tINTO #__joomleague_template_config\n\t\t\t\t\t\t\t(template,title,params,project_id)\n\t\t\t\t\t\t\tVALUES\n\t\t\t\t\t\t\t('{$template}','" . $out->name[0] . "','{$temp}','{$proj->id}')";
$db->setQuery($query);
//echo error,allows to check if there is a mistake in the template file
if (!$db->query()) {
echo '<span style="color:red; font-weight:bold; ">' . JText::sprintf('Error with [%s]:', $template) . '</span><br />';
echo $db->getErrorMsg() . '<br/>';
} else {
echo JText::sprintf('Inserted %1$s into project with ID %2$s', '<b>' . $template . '</b>', '<b>' . $proj->id . '</b>') . PrintStepResult(true) . '<br />';
}
}
}
if (!$changeNeeded) {
echo '<span style="color:green">' . JText::_('No changes needed for this template') . '</span>' . '<br />';
}
}
}
} else {
echo ' - <span style="color:red">' . JText::_('No templates found') . '</span>';
}
} else {
echo ' - <span style="color:green">' . JText::_('No update was needed') . '</span>';
}
return '';
}
$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));
function addStandardsForSoccer()
{
$events_player = array();
$events_staff = array();
$events_referees = array();
$events_clubstaff = array();
$PlayersPositions = array();
$StaffPositions = array();
$RefereePositions = array();
$ClubStaffPositions = array();
$result = false;
$db = JFactory::getDbo();
if ('AddEvents' == 'AddEvents') {
echo JText::sprintf('Adding standard soccer events to table table [%s]', '<b>' . '#__joomleague_eventtype' . '</b>');
$squery = 'SELECT * FROM #__joomleague_eventtype WHERE name=`%s`';
$isquery = 'INSERT INTO #__joomleague_eventtype (`name`,`icon`) VALUES (`%1$s`,`%2$s`)';
$query = "SELECT * FROM #__joomleague_sports_type WHERE name='COM_JOOMLEAGUE_ST_SOCCER'";
$db->setQuery($query);
$sports_type = $db->loadObject();
$newEventName = 'COM_JOOMLEAGUE_E_GOAL';
$newEventIcon = 'images/com_joomleague/database/events/soccer/goal.png';
$suspension = 0;
$query = build_SelectQuery('eventtype', $newEventName);
$db->setQuery($query);
if (!($object = $db->loadObject())) {
$query = build_InsertQuery_Event('eventtype', $newEventName, $newEventIcon, $suspension, $sports_type->id, 1);
$db->setQuery($query);
$result = $db->execute();
$events_player['0'] = $db->insertid();
} else {
$events_player['0'] = $object->id;
}
$newEventName = 'COM_JOOMLEAGUE_E_ASSISTS';
$newEventIcon = 'images/com_joomleague/database/events/soccer/assists.png';
$suspension = 0;
$query = build_SelectQuery('eventtype', $newEventName);
$db->setQuery($query);
if (!($object = $db->loadObject())) {
$query = build_InsertQuery_Event('eventtype', $newEventName, $newEventIcon, $suspension, $sports_type->id, 2);
$db->setQuery($query);
$result = $db->execute();
$events_player['1'] = $db->insertid();
} else {
$events_player['1'] = $object->id;
}
$newEventName = 'COM_JOOMLEAGUE_E_YELLOW_CARD';
$newEventIcon = 'images/com_joomleague/database/events/soccer/yellow_card.png';
$suspension = 0;
$query = build_SelectQuery('eventtype', $newEventName);
$db->setQuery($query);
if (!($object = $db->loadObject())) {
$query = build_InsertQuery_Event('eventtype', $newEventName, $newEventIcon, $suspension, $sports_type->id, 3);
$db->setQuery($query);
$result = $db->execute();
$events_player['2'] = $db->insertid();
$events_staff['2'] = $db->insertid();
$events_clubstaff['2'] = $db->insertid();
$events_referees['2'] = $db->insertid();
} else {
$events_player['2'] = $object->id;
$events_staff['2'] = $object->id;
$events_clubstaff['2'] = $object->id;
$events_referees['2'] = $object->id;
}
$newEventName = 'COM_JOOMLEAGUE_E_YELLOW-RED_CARD';
$newEventIcon = 'images/com_joomleague/database/events/soccer/yellow_red_card.png';
$suspension = 1;
$query = build_SelectQuery('eventtype', $newEventName);
$db->setQuery($query);
if (!($object = $db->loadObject())) {
$query = build_InsertQuery_Event('eventtype', $newEventName, $newEventIcon, $suspension, $sports_type->id, 4);
$db->setQuery($query);
$result = $db->execute();
$events_player['3'] = $db->insertid();
$events_staff['3'] = $db->insertid();
$events_clubstaff['3'] = $db->insertid();
$events_referees['3'] = $db->insertid();
} else {
$events_player['3'] = $object->id;
$events_staff['3'] = $object->id;
$events_clubstaff['3'] = $object->id;
$events_referees['3'] = $object->id;
}
$newEventName = 'COM_JOOMLEAGUE_E_RED_CARD';
$newEventIcon = 'images/com_joomleague/database/events/soccer/red_card.png';
$suspension = 1;
$query = build_SelectQuery('eventtype', $newEventName);
$db->setQuery($query);
if (!($object = $db->loadObject())) {
$query = build_InsertQuery_Event('eventtype', $newEventName, $newEventIcon, $suspension, $sports_type->id, 5);
$db->setQuery($query);
$result = $db->execute();
$events_player['4'] = $db->insertid();
$events_staff['4'] = $db->insertid();
$events_clubstaff['4'] = $db->insertid();
$events_referees['4'] = $db->insertid();
} else {
$events_player['4'] = $object->id;
$events_staff['4'] = $object->id;
$events_clubstaff['4'] = $object->id;
$events_referees['4'] = $object->id;
}
$newEventName = 'COM_JOOMLEAGUE_E_FOUL';
$newEventIcon = 'images/com_joomleague/database/events/soccer/foul.png';
$suspension = 0;
$query = build_SelectQuery('eventtype', $newEventName);
$db->setQuery($query);
if (!($object = $db->loadObject())) {
$query = build_InsertQuery_Event('eventtype', $newEventName, $newEventIcon, $suspension, $sports_type->id, 6);
$db->setQuery($query);
$result = $db->execute();
$events_player['5'] = $db->insertid();
$events_referees['5'] = $db->insertid();
} else {
$events_player['5'] = $object->id;
$events_referees['5'] = $object->id;
}
$newEventName = 'COM_JOOMLEAGUE_E_FOUL_TIME';
$newEventIcon = 'images/com_joomleague/database/events/soccer/foul_time.png';
$suspension = 0;
$query = build_SelectQuery('eventtype', $newEventName);
$db->setQuery($query);
if (!($object = $db->loadObject())) {
$query = build_InsertQuery_Event('eventtype', $newEventName, $newEventIcon, $suspension, $sports_type->id, 7);
$db->setQuery($query);
$result = $db->execute();
$events_player['6'] = $db->insertid();
$events_referees['6'] = $db->insertid();
} else {
$events_player['6'] = $object->id;
$events_referees['6'] = $object->id;
}
$newEventName = 'COM_JOOMLEAGUE_E_OWN_GOAL';
$newEventIcon = 'images/com_joomleague/database/events/soccer/own_goal.png';
$suspension = 0;
$query = build_SelectQuery('eventtype', $newEventName);
$db->setQuery($query);
if (!($object = $db->loadObject())) {
$query = build_InsertQuery_Event('eventtype', $newEventName, $newEventIcon, $suspension, $sports_type->id, 8);
$db->setQuery($query);
$result = $db->execute();
$events_player['7'] = $db->insertid();
} else {
$events_player['7'] = $object->id;
}
$newEventName = 'COM_JOOMLEAGUE_E_PENALTY_GOAL';
$newEventIcon = 'images/com_joomleague/database/events/soccer/penalty_goal.png';
$suspension = 0;
$query = build_SelectQuery('eventtype', $newEventName);
$db->setQuery($query);
if (!($object = $db->loadObject())) {
$query = build_InsertQuery_Event('eventtype', $newEventName, $newEventIcon, $suspension, $sports_type->id, 9);
$db->setQuery($query);
$result = $db->execute();
$events_player['8'] = $db->insertid();
$events_referees['8'] = $db->insertid();
} else {
$events_player['8'] = $object->id;
$events_referees['8'] = $object->id;
}
$newEventName = 'COM_JOOMLEAGUE_E_INJURY';
$newEventIcon = 'images/com_joomleague/database/events/soccer/injured.png';
$suspension = 0;
$query = build_SelectQuery('eventtype', $newEventName);
$db->setQuery($query);
if (!($object = $db->loadObject())) {
$query = build_InsertQuery_Event('eventtype', $newEventName, $newEventIcon, $suspension, $sports_type->id, 10);
$db->setQuery($query);
$result = $db->execute();
$events_player['9'] = $db->insertid();
$events_staff['9'] = $db->insertid();
$events_clubstaff['9'] = $db->insertid();
$events_referees['9'] = $db->insertid();
} else {
$events_player['9'] = $object->id;
$events_staff['9'] = $object->id;
$events_clubstaff['9'] = $object->id;
$events_referees['9'] = $object->id;
}
$newEventName = 'COM_JOOMLEAGUE_E_BLUE_CARD';
$newEventIcon = 'images/com_joomleague/database/events/soccer/blue_card.png';
$suspension = 0;
$query = build_SelectQuery('eventtype', $newEventName);
$db->setQuery($query);
if (!($object = $db->loadObject())) {
$query = build_InsertQuery_Event('eventtype', $newEventName, $newEventIcon, $suspension, $sports_type->id, 11);
$db->setQuery($query);
$result = $db->execute();
$events_player['10'] = $db->insertid();
$events_staff['10'] = $db->insertid();
$events_clubstaff['10'] = $db->insertid();
$events_referees['10'] = $db->insertid();
} else {
$events_player['10'] = $object->id;
$events_staff['10'] = $object->id;
$events_clubstaff['10'] = $object->id;
$events_referees['10'] = $object->id;
}
$newEventName = 'COM_JOOMLEAGUE_E_BLUE_RED_CARD';
$newEventIcon = 'images/com_joomleague/database/events/soccer/blue_red_card.png';
$suspension = 1;
$query = build_SelectQuery('eventtype', $newEventName);
$db->setQuery($query);
if (!($object = $db->loadObject())) {
$query = build_InsertQuery_Event('eventtype', $newEventName, $newEventIcon, $suspension, $sports_type->id, 12);
$db->setQuery($query);
$result = $db->execute();
$events_player['11'] = $db->insertid();
$events_staff['11'] = $db->insertid();
$events_clubstaff['11'] = $db->insertid();
$events_referees['11'] = $db->insertid();
} else {
$events_player['11'] = $object->id;
$events_staff['11'] = $object->id;
$events_clubstaff['11'] = $object->id;
$events_referees['11'] = $object->id;
}
echo PrintStepResult($result) . '<br />';
if (!$result) {
echo JText::_('DO NOT WORRY... Surely at least one of the events was already existing in your database!!!') . '<br />';
}
echo '<br />';
}
//+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
$result = false;
if ('AddPositions' == 'AddPositions') {
echo JText::sprintf('Adding standard soccer positions to table table [%s]', '<b>' . '#__joomleague_position' . '</b>');
if ('AddGeneralPlayersPositions' == 'AddGeneralPlayersPositions') {
// Add new Parent position to PlayersPositions
$newPosName = 'COM_JOOMLEAGUE_F_PLAYERS';
$newPosSwitch = 'persontype';
$newPosParent = '0';
$newPosContent = '1';
$query = build_SelectQuery('position', $newPosName);
$db->setQuery($query);
if (!($dbresult = $db->loadObject())) {
$query = build_InsertQuery_Position('position', $newPosName, $newPosSwitch, $newPosParent, $newPosContent, $sports_type->id, 1);
$db->setQuery($query);
$result = $db->execute();
$ParentID = $db->insertid();
$PlayersPositions['0'] = $db->insertid();
} else {
$ParentID = $dbresult->id;
$PlayersPositions['0'] = $dbresult->id;
}
if ('AddGeneralPlayersChildPositions' == 'AddGeneralPlayersChildPositions') {
// Add new Child positions to PlayersPositions
// New Child position for PlayersPositions
$newPosName = 'COM_JOOMLEAGUE_P_GOALKEEPER';
$newPosSwitch = 'persontype';
$newPosParent = $ParentID;
$newPosContent = '1';
$query = build_SelectQuery('position', $newPosName);
$db->setQuery($query);
if (!($object = $db->loadObject())) {
$query = build_InsertQuery_Position('position', $newPosName, $newPosSwitch, $newPosParent, $newPosContent, $sports_type->id, 2);
$db->setQuery($query);
$result = $db->execute();
$PlayersPositions['1'] = $db->insertid();
} else {
$PlayersPositions['1'] = $object->id;
}
// New Child position for PlayersPositions
$newPosName = 'COM_JOOMLEAGUE_P_DEFENDER';
$newPosSwitch = 'persontype';
$newPosParent = $ParentID;
$newPosContent = '1';
$query = build_SelectQuery('position', $newPosName);
$db->setQuery($query);
if (!($object = $db->loadObject())) {
$query = build_InsertQuery_Position('position', $newPosName, $newPosSwitch, $newPosParent, $newPosContent, $sports_type->id, 3);
$db->setQuery($query);
$result = $db->execute();
$PlayersPositions['2'] = $db->insertid();
} else {
$PlayersPositions['2'] = $object->id;
}
// New Child position for PlayersPositions
$newPosName = 'COM_JOOMLEAGUE_P_MIDFIELDER';
$newPosSwitch = 'persontype';
$newPosParent = $ParentID;
$newPosContent = '1';
$query = build_SelectQuery('position', $newPosName);
$db->setQuery($query);
if (!($object = $db->loadObject())) {
$query = build_InsertQuery_Position('position', $newPosName, $newPosSwitch, $newPosParent, $newPosContent, $sports_type->id, 4);
$db->setQuery($query);
$result = $db->execute();
$PlayersPositions['3'] = $db->insertid();
} else {
$PlayersPositions['3'] = $object->id;
}
// New Child position for PlayersPositions
$newPosName = 'COM_JOOMLEAGUE_P_FORWARD';
$newPosSwitch = 'persontype';
$newPosParent = $ParentID;
$newPosContent = '1';
$query = build_SelectQuery('position', $newPosName);
$db->setQuery($query);
if (!($object = $db->loadObject())) {
$query = build_InsertQuery_Position('position', $newPosName, $newPosSwitch, $newPosParent, $newPosContent, $sports_type->id, 5);
$db->setQuery($query);
$result = $db->execute();
$PlayersPositions['4'] = $db->insertid();
} else {
$PlayersPositions['4'] = $object->id;
}
}
}
//----------------------------------------------------------------------
if ('AddGeneralStaffPositions' == 'AddGeneralStaffPositions') {
if ('AddGeneralStaffTeamStaffPositions' == 'AddGeneralStaffTeamStaffPositions') {
// Add new Parent position to StaffPositions
$newPosName = 'COM_JOOMLEAGUE_F_TEAM_STAFF';
$newPosSwitch = 'persontype';
$newPosParent = '0';
$newPosContent = '2';
$query = build_SelectQuery('position', $newPosName);
$db->setQuery($query);
if (!($dbresult = $db->loadObject())) {
$query = build_InsertQuery_Position('position', $newPosName, $newPosSwitch, $newPosParent, $newPosContent, $sports_type->id, 6);
$db->setQuery($query);
$result = $db->execute();
$ParentID = $db->insertid();
$StaffPositions['0'] = $db->insertid();
} else {
$ParentID = $dbresult->id;
$StaffPositions['0'] = $dbresult->id;
}
}
//----------------------------------------------------------------------
if ('AddGeneralStaffCoachesPositions' == 'AddGeneralStaffCoachesPositions') {
// Add new Parent position to StaffPositions
$newPosName = 'COM_JOOMLEAGUE_F_COACHES';
$newPosSwitch = 'persontype';
$newPosParent = '0';
$newPosContent = '2';
$query = build_SelectQuery('position', $newPosName);
$db->setQuery($query);
if (!($dbresult = $db->loadObject())) {
$query = build_InsertQuery_Position('position', $newPosName, $newPosSwitch, $newPosParent, $newPosContent, $sports_type->id, 7);
$db->setQuery($query);
$result = $db->execute();
$ParentID = $db->insertid();
$StaffPositions['1'] = $db->insertid();
} else {
$ParentID = $dbresult->id;
$StaffPositions['1'] = $dbresult->id;
}
if ('AddGeneralStaffCoachesChildPositions' == 'AddGeneralStaffCoachesChildPositions') {
// New Child position for StaffPositions
$newPosName = 'COM_JOOMLEAGUE_F_COACH';
$newPosSwitch = 'persontype';
$newPosParent = $ParentID;
$newPosContent = '2';
$query = build_SelectQuery('position', $newPosName);
$db->setQuery($query);
if (!($object = $db->loadObject())) {
$query = build_InsertQuery_Position('position', $newPosName, $newPosSwitch, $newPosParent, $newPosContent, $sports_type->id, 8);
$db->setQuery($query);
$result = $db->execute();
$StaffPositions['2'] = $db->insertid();
} else {
$StaffPositions['2'] = $object->id;
}
// New Child position for StaffPositions
$newPosName = 'COM_JOOMLEAGUE_F_HEAD_COACH';
$newPosSwitch = 'persontype';
$newPosParent = $ParentID;
$newPosContent = '2';
$query = build_SelectQuery('position', $newPosName);
$db->setQuery($query);
if (!($object = $db->loadObject())) {
$query = build_InsertQuery_Position('position', $newPosName, $newPosSwitch, $newPosParent, $newPosContent, $sports_type->id, 9);
$db->setQuery($query);
$result = $db->execute();
$StaffPositions['3'] = $db->insertid();
} else {
$StaffPositions['3'] = $object->id;
}
}
}
//----------------------------------------------------------------------
if ('AddGeneralStaffMaintainerteamPositions' == 'AddGeneralStaffMaintainerteamPositions') {
// Add new Parent position to StaffPositions
$newPosName = 'COM_JOOMLEAGUE_F_MAINTAINER_TEAM';
$newPosSwitch = 'persontype';
$newPosParent = '0';
$newPosContent = '2';
$query = build_SelectQuery('position', $newPosName);
$db->setQuery($query);
if (!($dbresult = $db->loadObject())) {
$query = build_InsertQuery_Position('position', $newPosName, $newPosSwitch, $newPosParent, $newPosContent, $sports_type->id, 10);
$db->setQuery($query);
$result = $db->execute();
$ParentID = $db->insertid();
$StaffPositions['4'] = $db->insertid();
} else {
$ParentID = $dbresult->id;
$StaffPositions['4'] = $dbresult->id;
}
if ('AddGeneralStaffMaintainerChildPositions' == 'AddGeneralStaffMaintainerChildPositions') {
// New Child position for StaffPositions
$newPosName = 'COM_JOOMLEAGUE_F_MAINTAINER';
$newPosSwitch = 'persontype';
$newPosParent = $ParentID;
$newPosContent = '2';
$query = build_SelectQuery('position', $newPosName);
$db->setQuery($query);
if (!($object = $db->loadObject())) {
$query = build_InsertQuery_Position('position', $newPosName, $newPosSwitch, $newPosParent, $newPosContent, $sports_type->id, 11);
$db->setQuery($query);
$result = $db->execute();
$StaffPositions['5'] = $db->insertid();
} else {
$StaffPositions['5'] = $object->id;
}
}
}
//----------------------------------------------------------------------
if ('AddGeneralStaffMedicalStaffPositions' == 'AddGeneralStaffMedicalStaffPositions') {
// Add new Parent position to StaffPositions
$newPosName = 'COM_JOOMLEAGUE_F_MEDICAL_STAFF';
$newPosSwitch = 'persontype';
$newPosParent = '0';
$newPosContent = '2';
$query = build_SelectQuery('position', $newPosName);
$db->setQuery($query);
if (!($dbresult = $db->loadObject())) {
$query = build_InsertQuery_Position('position', $newPosName, $newPosSwitch, $newPosParent, $newPosContent, $sports_type->id, 12);
$db->setQuery($query);
$result = $db->execute();
$ParentID = $db->insertid();
$StaffPositions['6'] = $db->insertid();
} else {
$ParentID = $dbresult->id;
$StaffPositions['6'] = $dbresult->id;
}
}
}
//----------------------------------------------------------------------
if ('AddGeneralRefereesPositions' == 'AddGeneralRefereesPositions') {
// Add new Parent position to RefereesPositions
$newPosName = 'COM_JOOMLEAGUE_F_REFEREES';
$newPosSwitch = 'persontype';
$newPosParent = '0';
$newPosContent = '3';
$query = build_SelectQuery('position', $newPosName);
$db->setQuery($query);
if (!($dbresult = $db->loadObject())) {
$query = build_InsertQuery_Position('position', $newPosName, $newPosSwitch, $newPosParent, $newPosContent, $sports_type->id, 13);
$db->setQuery($query);
$result = $db->execute();
$ParentID = $db->insertid();
$RefereePositions['0'] = $db->insertid();
} else {
$ParentID = $dbresult->id;
$RefereePositions['0'] = $dbresult->id;
}
if ('AddGeneralRefereesChildPositions' == 'AddGeneralRefereesChildPositions') {
// New Child position for RefereePositions
$newPosName = 'COM_JOOMLEAGUE_F_CENTER_REFEREE';
$newPosSwitch = 'persontype';
$newPosParent = $ParentID;
$newPosContent = '3';
$query = build_SelectQuery('position', $newPosName);
$db->setQuery($query);
if (!($object = $db->loadObject())) {
$query = build_InsertQuery_Position('position', $newPosName, $newPosSwitch, $newPosParent, $newPosContent, $sports_type->id, 14);
$db->setQuery($query);
$result = $db->execute();
$RefereePositions['1'] = $db->insertid();
} else {
$RefereePositions['1'] = $object->id;
}
// New Child position for RefereePositions
$newPosName = 'COM_JOOMLEAGUE_F_LINESMAN';
$newPosSwitch = 'persontype';
$newPosParent = $ParentID;
$newPosContent = '3';
$query = build_SelectQuery('position', $newPosName);
$db->setQuery($query);
if (!($object = $db->loadObject())) {
$query = build_InsertQuery_Position('position', $newPosName, $newPosSwitch, $newPosParent, $newPosContent, $sports_type->id, 15);
$db->setQuery($query);
$result = $db->execute();
$RefereePositions['2'] = $db->insertid();
} else {
$RefereePositions['2'] = $object->id;
}
// New Child position for RefereePositions
$newPosName = 'COM_JOOMLEAGUE_F_FOURTH_OFFICIAL';
$newPosSwitch = 'persontype';
$newPosParent = $ParentID;
$newPosContent = '3';
$query = build_SelectQuery('position', $newPosName);
$db->setQuery($query);
if (!($object = $db->loadObject())) {
$query = build_InsertQuery_Position('position', $newPosName, $newPosSwitch, $newPosParent, $newPosContent, $sports_type->id, 16);
$db->setQuery($query);
$result = $db->execute();
$RefereePositions['3'] = $db->insertid();
} else {
$RefereePositions['3'] = $object->id;
}
// New Child position for RefereePositions
$newPosName = 'COM_JOOMLEAGUE_F_FIFTH_OFFICIAL';
$newPosSwitch = 'persontype';
$newPosParent = $ParentID;
$newPosContent = '3';
$query = build_SelectQuery('position', $newPosName);
$db->setQuery($query);
if (!($object = $db->loadObject())) {
$query = build_InsertQuery_Position('position', $newPosName, $newPosSwitch, $newPosParent, $newPosContent, $sports_type->id, 17);
$db->setQuery($query);
$result = $db->execute();
$RefereePositions['4'] = $db->insertid();
} else {
$RefereePositions['4'] = $object->id;
}
}
}
//----------------------------------------------------------------------
if ('AddGeneralClubstaffPositions' == 'AddGeneralClubstaffPositions') {
// Add new Parent position to ClubStaffPositions
$newPosName = 'COM_JOOMLEAGUE_F_CLUB_STAFF';
$newPosSwitch = 'persontype';
$newPosParent = '0';
$newPosContent = '4';
$query = build_SelectQuery('position', $newPosName);
$db->setQuery($query);
if (!($dbresult = $db->loadObject())) {
$query = build_InsertQuery_Position('position', $newPosName, $newPosSwitch, $newPosParent, $newPosContent, $sports_type->id, 18);
$db->setQuery($query);
$result = $db->execute();
$ParentID = $db->insertid();
$ClubStaffPositions['0'] = $db->insertid();
} else {
$ParentID = $dbresult->id;
$ClubStaffPositions['0'] = $dbresult->id;
}
if ('AddGeneralClubstaffChildPositions' == 'AddGeneralClubstaffChildPositions') {
// New Child position for ClubStaffPositions
$newPosName = 'COM_JOOMLEAGUE_F_CLUB_MANAGER';
$newPosSwitch = 'persontype';
$newPosParent = $ParentID;
$newPosContent = '4';
$query = build_SelectQuery('position', $newPosName);
$db->setQuery($query);
// hier die 4 als newposcontent einf�gen
if (!($object = $db->loadObject())) {
$query = build_InsertQuery_Position('position', $newPosName, $newPosSwitch, $newPosParent, $newPosContent, $sports_type->id, 19);
$db->setQuery($query);
$result = $db->execute();
$ClubStaffPositions['1'] = $db->insertid();
} else {
$ClubStaffPositions['1'] = $object->id;
}
$newPosName = 'COM_JOOMLEAGUE_F_CLUB_YOUTH_MANAGER';
$newPosSwitch = 'persontype';
$newPosParent = $ParentID;
$newPosContent = '4';
$query = build_SelectQuery('position', $newPosName);
$db->setQuery($query);
// hier die 4 als newposcontent einf�gen
if (!($object = $db->loadObject())) {
$query = build_InsertQuery_Position('position', $newPosName, $newPosSwitch, $newPosParent, $newPosContent, $sports_type->id, 20);
$db->setQuery($query);
$result = $db->execute();
$ClubStaffPositions['2'] = $db->insertid();
} else {
$ClubStaffPositions['2'] = $object->id;
}
}
}
echo PrintStepResult($result) . '<br />';
if (!$result) {
echo JText::_('DO NOT WORRY... Surely at least one of the positions was already existing in your database!!!') . '<br />';
}
echo '<br />';
}
//+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
$result = false;
echo JText::sprintf('Adding standard position-related-events for soccer to table table [%s]', '<b>' . '#__joomleague_position_eventtype' . '</b>');
foreach ($PlayersPositions as $ppkey => $ppid) {
foreach ($events_player as $epkey => $epid) {
$query = build_InsertQuery_PositionEventType($ppid, $epid);
$db->setQuery($query);
$result = $db->execute();
}
}
foreach ($StaffPositions as $spkey => $spid) {
foreach ($events_staff as $eskey => $esid) {
$query = build_InsertQuery_PositionEventType($spid, $esid);
$db->setQuery($query);
$result = $db->execute();
}
}
foreach ($RefereePositions as $rkey => $rid) {
foreach ($events_referees as $erkey => $erid) {
$query = build_InsertQuery_PositionEventType($rid, $erid);
$db->setQuery($query);
$result = $db->execute();
}
}
foreach ($ClubStaffPositions as $cskey => $csid) {
foreach ($events_clubstaff as $ecskey => $escid) {
$query = build_InsertQuery_PositionEventType($csid, $escid);
$db->setQuery($query);
$result = $db->execute();
}
}
echo PrintStepResult($result) . '<br />';
if (!$result) {
echo JText::_('DO NOT WORRY... Surely at least one of the position related events was already existing in your database!!!') . '<br />';
}
return '';
}