function clm_api_db_logging()
{
$table = '#__clm_logging';
$primaryKey = 'id';
$columns = array(array('db' => 'id', 'dt' => 0), array('db' => 'type', 'dt' => 1), array('db' => 'name', 'dt' => 2), array('db' => 'content', 'dt' => 3), array('db' => 'timestamp', 'dt' => 4), array('db' => 'userid', 'dt' => 5), array('db' => 'callid', 'dt' => 6), array('db' => 'id', 'dt' => 7));
$allowed = array("type" => "i");
$out = clm_class_DataTables::simple($_POST, $table, $primaryKey, $columns, $allowed, clm_core::$db);
$lang = clm_core::$lang->logging;
for ($i = 0; $i < count($out["data"]); $i++) {
$out["data"][$i][0] = $i + 1;
if (!clm_core::$db->user->get($out["data"][$i][5])->isNew()) {
$out["data"][$i][5] = clm_core::$db->user->get($out["data"][$i][5])->username;
}
$out["data"][$i][4] = date("d.m.y H:i:s", $out["data"][$i][4]);
$result = clm_class_log::refactor($out["data"][$i][1], $out["data"][$i][2], $out["data"][$i][3]);
$out["data"][$i][1] = $result[0];
$out["data"][$i][2] = $result[1];
$out["data"][$i][3] = $result[2];
}
return array(true, "m_tableSuccess", $out);
}
function clm_api_db_tournament_group()
{
$table = '#__clm_liga';
$primaryKey = 'id';
$columns = array(array('db' => 'id', 'dt' => 0), array('db' => 'name', 'dt' => 1), array('db' => 'sid', 'dt' => 2), array('db' => 'runden_modus', 'dt' => 3), array('db' => 'runden', 'dt' => 4), array('db' => 'teil', 'dt' => 5), array('db' => 'stamm', 'dt' => 6), array('db' => 'sl', 'dt' => 7), array('db' => 'bemerkungen', 'dt' => 8), array('db' => 'mail', 'dt' => 9), array('db' => 'id', 'dt' => 10), array('db' => 'rnd', 'dt' => 11), array('db' => 'published', 'dt' => 12), array('db' => 'ordering', 'dt' => 13), array('db' => 'id', 'dt' => 14));
// Erzwinge Filter bei unzureichenden Berechtigungen
if (clm_core::$access->access('BE_league_general') == 1 && clm_core::$access->access('BE_teamtournament_general') == 0) {
if (in_array('liga_mt', $_POST["names"])) {
$_POST["values"][array_search("liga_mt", $_POST["names"])] = "0";
} else {
$_POST["names"][] = "liga_mt";
$_POST["values"][] = "0";
}
} else {
if (clm_core::$access->access('BE_league_general') == 0 && clm_core::$access->access('BE_teamtournament_general') == 1) {
if (in_array('liga_mt', $_POST["names"])) {
$_POST["values"][array_search("liga_mt", $_POST["names"])] = "1";
} else {
$_POST["names"][] = "liga_mt";
$_POST["values"][] = "1";
}
}
}
$allowed = array("runden_modus" => "i", "published" => "i", "sid" => "i", "catidAlltime:catidEdition" => "i", "liga_mt" => "i");
$out = clm_class_DataTables::simple($_POST, $table, $primaryKey, $columns, $allowed, clm_core::$db);
$lang = clm_core::$lang->tournament_group;
$clmAccess = clm_core::$access;
for ($i = 0; $i < count($out["data"]); $i++) {
if (clm_core::$db->liga->get($out["data"][$i][0])->liga_mt == 0) {
$right = "league";
$section = "ligen";
} else {
$right = "teamtournament";
$section = "mturniere";
}
$out["data"][$i][0] = $i + 1;
$out["data"][$i][1] = clm_class_category::name($out["data"][$i][14], true);
if (!($out["data"][$i][7] != $clmAccess->getJid() and $clmAccess->access('BE_' . $right . '_edit_detail') !== true or $clmAccess->access('BE_' . $right . '_edit_detail') === false)) {
//$out["data"][$i][1] = '<a href="'.clm_core::$load->gen_url(array("section"=>"ligen","task"=>"edit","cid[]"=>$out["data"][$i][14]),array("view")).'">'.$out["data"][$i][1].'</a>';
$out["data"][$i][1] = '<a href="' . clm_core::$load->gen_url(array("section" => $section, "task" => "edit", "cid[]" => $out["data"][$i][14]), array("view")) . '">' . $out["data"][$i][1] . '</a>';
}
// Saisonname statt sid Anzeigen
$sid = intval($out["data"][$i][2]);
$out["data"][$i][2] = clm_core::$db->saison->get($sid)->name;
// Modus ID in Name umsetzen
$out["data"][$i][3] = clm_core::$load->mode_to_name(intval($out["data"][$i][3]), true);
// Runden mit Bestätigung/sl_ok
// eingetragene Teilnehmer
$query = 'SELECT COUNT(id)' . ' FROM #__clm_runden_termine' . ' WHERE liga = ' . $out["data"][$i][14] . ' AND sl_ok = \'1\'';
// Durchläufe Anzeigen
if (clm_core::$db->liga->get($out["data"][$i][14])->durchgang > 1) {
$out["data"][$i][4] = clm_core::$db->liga->get($out["data"][$i][14])->durchgang . " x " . $out["data"][$i][4];
}
if (!($out["data"][$i][7] != $clmAccess->getJid() and $clmAccess->access('BE_' . $right . '_edit_detail') !== true or $clmAccess->access('BE_' . $right . '_edit_detail') === false) and $out["data"][$i][11] == 1) {
$out["data"][$i][4] = '<a href="' . clm_core::$load->gen_url(array("section" => "runden", "liga" => $out["data"][$i][14]), array("view")) . '">' . $out["data"][$i][4] . " " . $lang->rounds . '</a>' . "<br/>" . $lang->open . clm_core::$db->count($query) . " " . $lang->confirmed . $lang->close;
} else {
$out["data"][$i][4] = $out["data"][$i][4] . " " . $lang->rounds . "<br/>" . $lang->open . clm_core::$db->count($query) . " " . $lang->confirmed . $lang->close;
}
// Stammspieler + Ersatzspieler
$out["data"][$i][6] = $out["data"][$i][6] . " " . $lang->open . $lang->plus . " " . clm_core::$db->liga->get($out["data"][$i][14])->ersatz . $lang->close;
// Turnierleiter
$query = 'SELECT name' . ' FROM #__clm_user' . ' WHERE jid = ' . $out["data"][$i][7] . ' AND sid = ' . $sid;
$result = clm_core::$db->loadAssocList($query);
if (count($result) == 1) {
$out["data"][$i][7] = $result[0]["name"];
} else {
$out["data"][$i][7] = "-";
}
if ($out["data"][$i][8] == "") {
$out["data"][$i][8] = $lang->column9_no;
} else {
$out["data"][$i][8] = '<a href="javascript:void(0);" onclick=\'clm_modal_display("' . htmlspecialchars($out["data"][$i][8], ENT_QUOTES, "UTF-8") . '")\' href="javascript:;" >' . $lang->column9_yes . '</a>';
}
// Mail
if ($out["data"][$i][9] == 1) {
$out["data"][$i][9] = '<button class="clm_table_image " value=\'["db_tournament_publish",[' . $out["data"][$i][14] . ',false,true,"mail"]]\'><img width="16" height="16" src="' . clm_core::$load->gen_image_url("table/apply") . '" /></button>';
} else {
$out["data"][$i][9] = '<button class="clm_table_image" value=\'["db_tournament_publish",[' . $out["data"][$i][14] . ',true,true,"mail"]]\'><img width="16" height="16" src="' . clm_core::$load->gen_image_url("table/cancel") . '" /></button>';
}
// DWZ berechnet
$params = clm_core::$db->liga->get($out["data"][$i][10])->params;
$params = new clm_class_params($params);
if ($params->get("inofDWZ", "0") == "1") {
$out["data"][$i][10] = '<button class="clm_table_image" value=\'["db_tournament_delDWZ",[' . $out["data"][$i][14] . ',true]]\'><img width="16" height="16" src="' . clm_core::$load->gen_image_url("table/apply") . '" /></button>';
} else {
$out["data"][$i][10] = '<button class="clm_table_image" value=\'["db_tournament_genDWZ",[' . $out["data"][$i][14] . ',true]]\'><img width="16" height="16" src="' . clm_core::$load->gen_image_url("table/cancel") . '" /></button>';
}
// Runden
if ($out["data"][$i][11] == 1) {
$out["data"][$i][11] = '<button class="clm_table_image " value=\'["db_tournament_delRounds",[' . $out["data"][$i][14] . ',true]]\'><img width="16" height="16" src="' . clm_core::$load->gen_image_url("table/apply") . '" /></button>';
} else {
$out["data"][$i][11] = '<button class="clm_table_image" value=\'["db_tournament_genRounds",[' . $out["data"][$i][14] . ',true]]\'><img width="16" height="16" src="' . clm_core::$load->gen_image_url("table/cancel") . '" /></button>';
}
// Veröffentlicht
if ($out["data"][$i][12] == 1) {
$out["data"][$i][12] = '<button class="clm_table_image " value=\'["db_tournament_publish",[' . $out["data"][$i][14] . ',false,true]]\'><img width="16" height="16" src="' . clm_core::$load->gen_image_url("table/apply") . '" /></button>';
} else {
$out["data"][$i][12] = '<button class="clm_table_image" value=\'["db_tournament_publish",[' . $out["data"][$i][14] . ',true,true]]\'><img width="16" height="16" src="' . clm_core::$load->gen_image_url("table/cancel") . '" /></button>';
}
$out["data"][$i][13] = '<input class="clm_table_orderingBox" onkeypress="return clm_isChangeNumber(event);" value="' . $out["data"][$i][13] . '" type="text">';
$out["data"][$i][13] .= '<input class="clm_table_orderingId" value="' . $out["data"][$i][14] . '" type="hidden">';
}
return array(true, "m_tableSuccess", $out);
}
function clm_api_db_tournament()
{
$table = '#__clm_turniere';
$primaryKey = 'id';
$columns = array(array('db' => 'id', 'dt' => 0), array('db' => 'name', 'dt' => 1), array('db' => 'sid', 'dt' => 2), array('db' => 'dateStart', 'dt' => 3), array('db' => 'invitationText', 'dt' => 4), array('db' => 'vereinZPS', 'dt' => 5), array('db' => 'typ', 'dt' => 6), array('db' => 'runden', 'dt' => 7), array('db' => 'teil', 'dt' => 8), array('db' => 'tl', 'dt' => 9), array('db' => 'id', 'dt' => 10), array('db' => 'rnd', 'dt' => 11), array('db' => 'published', 'dt' => 12), array('db' => 'ordering', 'dt' => 13), array('db' => 'id', 'dt' => 14));
$allowed = array("typ" => "i", "published" => "i", "sid" => "i", "catidAlltime:catidEdition" => "i");
$out = clm_class_DataTables::simple($_POST, $table, $primaryKey, $columns, $allowed, clm_core::$db);
$lang = clm_core::$lang->tournament;
$clmAccess = clm_core::$access;
for ($i = 0; $i < count($out["data"]); $i++) {
$out["data"][$i][0] = $i + 1;
$out["data"][$i][1] = clm_class_category::name($out["data"][$i][14], false);
if (!($out["data"][$i][9] != $clmAccess->getJid() and $clmAccess->access('BE_tournament_edit_detail') !== true or $clmAccess->access('BE_tournament_edit_detail') === false)) {
$out["data"][$i][1] = '<a href="' . clm_core::$load->gen_url(array("view" => "turform", "task" => "edit", "id" => $out["data"][$i][14])) . '">' . $out["data"][$i][1] . '</a>';
}
// Saisonname statt sid Anzeigen
$sid = intval($out["data"][$i][2]);
$out["data"][$i][2] = clm_core::$db->saison->get($sid)->name;
// dateStart durch dateStart und dateEnd ersetzen
if (clm_core::$db->turniere->get($out["data"][$i][14])->dateStart != '0000-00-00') {
$out["data"][$i][3] = clm_core::$load->date_to_string(clm_core::$db->turniere->get($out["data"][$i][14])->dateStart, false, true);
if (clm_core::$db->turniere->get($out["data"][$i][14])->dateEnd != '0000-00-00') {
$out["data"][$i][3] .= " " . $lang->until . " " . clm_core::$load->date_to_string(clm_core::$db->turniere->get($out["data"][$i][14])->dateEnd, false, true);
}
} else {
$out["data"][$i][3] = $lang->unknownDate;
}
// Veranstalter / Ausrichter
$out["data"][$i][5] = clm_core::$load->zps_to_district($out["data"][$i][5]);
if (clm_core::$db->turniere->get($out["data"][$i][14])->bezirkTur == 1) {
$out["data"][$i][5] = $lang->districtEvent . ($out["data"][$i][5] != "" ? "<br />" . $out["data"][$i][5] : "");
}
// Ausschreibung
if ($out["data"][$i][4] == "") {
$out["data"][$i][4] = $lang->column3_no;
} else {
$out["data"][$i][4] = $lang->column3_yes;
}
if (!($out["data"][$i][9] != $clmAccess->getJid() and $clmAccess->access('BE_tournament_edit_detail') !== true or $clmAccess->access('BE_tournament_edit_detail') === false)) {
$out["data"][$i][4] = '<a href="' . clm_core::$load->gen_url(array("view" => "turinvite", "task" => "edit", "id" => $out["data"][$i][14])) . '">' . $out["data"][$i][4] . '</a>';
}
// Modus ID in Name umsetzen
$out["data"][$i][6] = clm_core::$load->mode_to_name(intval($out["data"][$i][6]), false);
// eingetragene Teilnehmer
$query = 'SELECT COUNT(id)' . ' FROM #__clm_turniere_tlnr' . ' WHERE turnier = ' . $out["data"][$i][14];
if (!($out["data"][$i][9] != $clmAccess->getJid() and $clmAccess->access('BE_tournament_edit_detail') !== true or $clmAccess->access('BE_tournament_edit_detail') === false)) {
$out["data"][$i][8] = '<a href="' . clm_core::$load->gen_url(array("view" => "turplayers", "task" => "edit", "id" => $out["data"][$i][14])) . '">' . $out["data"][$i][8] . " " . $lang->player . '</a>' . "<br/>" . $lang->open . clm_core::$db->count($query) . " " . $lang->registered . $lang->close;
} else {
$out["data"][$i][8] = $out["data"][$i][8] . " " . $lang->player . "<br/>" . $lang->open . clm_core::$db->count($query) . " " . $lang->registered . $lang->close;
}
// Runden mit Bestätigung/tl_ok
// eingetragene Teilnehmer
$query = 'SELECT COUNT(id)' . ' FROM #__clm_turniere_rnd_termine' . ' WHERE turnier = ' . $out["data"][$i][14] . ' AND tl_ok = \'1\'';
// Durchläufe Anzeigen
if (clm_core::$db->turniere->get($out["data"][$i][14])->dg > 1) {
$out["data"][$i][7] = clm_core::$db->turniere->get($out["data"][$i][14])->dg . " x " . $out["data"][$i][7];
}
if (!($out["data"][$i][9] != $clmAccess->getJid() and $clmAccess->access('BE_tournament_edit_detail') !== true or $clmAccess->access('BE_tournament_edit_detail') === false)) {
$out["data"][$i][7] = '<a href="' . clm_core::$load->gen_url(array("view" => "turrounds", "task" => "edit", "id" => $out["data"][$i][14])) . '">' . $out["data"][$i][7] . " " . $lang->rounds . '</a>' . "<br/>" . $lang->open . clm_core::$db->count($query) . " " . $lang->confirmed . $lang->close;
} else {
$out["data"][$i][7] = $out["data"][$i][7] . " " . $lang->rounds . "<br/>" . $lang->open . clm_core::$db->count($query) . " " . $lang->confirmed . $lang->close;
}
// Turnierleiter
$query = 'SELECT name' . ' FROM #__clm_user' . ' WHERE jid = ' . $out["data"][$i][9] . ' AND sid = ' . $sid;
$result = clm_core::$db->loadAssocList($query);
if (count($result) == 1) {
$out["data"][$i][9] = $result[0]["name"];
} else {
$out["data"][$i][9] = "-";
}
// DWZ berechnet
$params = clm_core::$db->turniere->get($out["data"][$i][10])->params;
$params = new clm_class_params($params);
if ($params->get("inofDWZ", "0") == "1") {
$out["data"][$i][10] = '<button class="clm_table_image" value=\'["db_tournament_delDWZ",[' . $out["data"][$i][14] . ',false]]\'><img width="16" height="16" src="' . clm_core::$load->gen_image_url("table/apply") . '" /></button>';
} else {
$out["data"][$i][10] = '<button class="clm_table_image" value=\'["db_tournament_genDWZ",[' . $out["data"][$i][14] . ',false]]\'><img width="16" height="16" src="' . clm_core::$load->gen_image_url("table/cancel") . '" /></button>';
}
// Runden freigegeben
if ($out["data"][$i][11] == 1) {
$out["data"][$i][11] = '<button class="clm_table_image clm_button_del_danger" value=\'["db_tournament_delRounds",[' . $out["data"][$i][14] . ',false]]\'><img width="16" height="16" src="' . clm_core::$load->gen_image_url("table/apply") . '" /></button>';
} else {
$out["data"][$i][11] = '<button class="clm_table_image" value=\'["db_tournament_genRounds",[' . $out["data"][$i][14] . ',false]]\'><img width="16" height="16" src="' . clm_core::$load->gen_image_url("table/cancel") . '" /></button>';
}
// Veröffentlicht
if ($out["data"][$i][12] == 1) {
$out["data"][$i][12] = '<button class="clm_table_image " value=\'["db_tournament_publish",[' . $out["data"][$i][14] . ',false,false]]\'><img width="16" height="16" src="' . clm_core::$load->gen_image_url("table/apply") . '" /></button>';
} else {
$out["data"][$i][12] = '<button class="clm_table_image" value=\'["db_tournament_publish",[' . $out["data"][$i][14] . ',true,false]]\'><img width="16" height="16" src="' . clm_core::$load->gen_image_url("table/cancel") . '" /></button>';
}
$out["data"][$i][13] = '<input class="clm_table_orderingBox" onkeypress="return clm_isChangeNumber(event);" value="' . $out["data"][$i][13] . '" type="text">';
$out["data"][$i][13] .= '<input class="clm_table_orderingId" value="' . $out["data"][$i][14] . '" type="hidden">';
}
return array(true, "m_tableSuccess", $out);
}
