/**
* purpose: create LSDB Team from wf Team
* params: request object
* returns: Team Object
*/
function wf_create_LSDB_Team($obj)
{
global $dbi;
$verein_id = 0;
$sql = 'Select * from wfevent where wfevent_id=' . $obj['wfevent_id'];
$pres = sql_query($sql, $dbi);
$aWF = sql_fetch_array($pres, $dbi);
if ($aWF['event_id'] > 0) {
debug('Registering new Team for Event: ' . $aWF['event_id']);
// CREATE:
$cT = new cTeam();
$cT->setDB($dbi);
$cT->aDATA['id'] = 0;
$cT->aDATA['tname'] = $obj['teamname'];
$cT->aDATA['tlocation_id'] = $obj['location_id'];
$cT->aDATA['tverein_id'] = $obj['verein_id'];
$cT->aDATA['tevent_id'] = $aWF['event_id'];
$cT->save();
} else {
debug('E:WFF150:NoTargetLigaConfigured');
}
return $cT->aDATA;
}
<?php
/**
* purpose: test team.class and XML generator
* params: tid=<number>
* returns: XML team record
*/
require_once "../code/config.php";
require_once "../includes/sql_layer.php";
require_once "../ORM/team.php";
if (isset($_REQUEST['id']) && is_numeric($_REQUEST['id'])) {
$t_id = strip_tags($_REQUEST['id']);
}
if (!isset($t_id)) {
die('X2');
}
$dbi = sql_connect($dbhost, $dbuname, $dbpass, $dbname);
$T = new cTeam();
$T->setDB($dbi);
$T->getbyID($t_id);
#$T->save();
header('Content-Type: application/xml; charset=ISO-8859-1');
echo $T->returnXML();
echo $T->pError;
function _saveTeam($team_id, $event_id, $team_name, $verein_id, $location_id)
{
#
# called by create/EDIT team -- INSERT / UPDATE
#
global $dbi, $usertoken, $TEAM_LEVEL, $sipgoback;
if (!$TEAM_LEVEL > 2) {
die('<h3>E:T22:NoAccessThisLeague</h3>');
}
if (!$event_id > 0) {
die('Team must be assigned to an event ... <br/>' . $sipgoback);
}
if (!$team_name) {
die('Team Name is missing ... <br/>' . $sipgoback);
}
if ($verein_id == 0) {
$verein_id = "NULL";
}
if ($location_id == 0) {
$location_id = "NULL";
}
$cT = new cTeam();
$cT->setDB($dbi);
$cT->aDATA['id'] = $team_id;
$cT->aDATA['tname'] = $team_name;
$cT->aDATA['tlocation_id'] = $location_id;
$cT->aDATA['tverein_id'] = $verein_id;
$cT->aDATA['tevent_id'] = $event_id;
$cT->save();
/*
* make sure a possible eventchange is propagated to the lineup
*/
$strsql = "UPDATE tblteamplayer set leventid={$event_id} where lteamid={$team_id} limit 20";
$precord = sql_query($strsql, $dbi);
}
