KAPE
Home   ›  KAPE Clubrecords   ›  CLUBRECORDS CATEGORIE

[insert_php]

setlocale(LC_ALL,’nl_NL’);
global $wpdb;
global $wp;
$current_url = home_url(add_query_arg(array($_GET), $wp->request));
$url_components = parse_url($current_url);
parse_str($url_components[‘query’], $params);

$categ=$params[‘cat’];

$query = $wpdb->get_results(“select id,omschrijving from categorie where id= ‘” . $categ . “‘ “);
foreach ($query as $row) {
echo “Clubrecords ” . $row->omschrijving . ” (” . $row->id . “)
“;
}
echo “Outdoor“;

switch($categ) {
case “BENJ”:
$arr = array(1,2,0);
break;
case “BENM”:
$arr = array(1,2,0);
break;
case “PUPJ”:
$arr = array(1,2,6,0,18);
break;
case “PUPM”:
$arr = array(1,2,0,18);
break;
case “MINJ”:
$arr = array(7,8,9,10,6,0,18,19);
break;
case “MINM”:
$arr = array(7,8,9,10,6,0,57,19);
break;
case “CADJ”:
$arr = array(3,8,9,10,24,2,6,0,32,48,89,61,97,65,69);
break;
case “CADM”:
$arr = array(3,8,9,10,24,2,6,0,32,48,89,58,97,65,69);
break;
case “SCHJ”:
$arr = array(1,2,0);
break;
case “SCHM”:
$arr = array(3,8,9,10,24,2,6,0,32,48,38,89,59,58,97,65,69,66,70);
break;
case “JUNH”:
$arr = array(1,2,0);
break;
case “JUND”:
$arr = array(1,2,0);
break;
case “SENH”:
$arr = array(1,2,0);
break;
case “SEND”:
$arr = array(1,2,0);
break;
case “SENH”:
$arr = array(1,2,0);
break;
case “SEND”:
$arr = array(1,2,0);
break;
case “M35”:
$arr = array(1,2,0);
break;
case “W35”:
$arr = array(1,2,0);
break;
case “M40”:
$arr = array(1,2,0);
break;
case “W40”:
$arr = array(1,2,0);
break;
case “M45”:
$arr = array(1,2,0);
break;
case “W45”:
$arr = array(1,2,0);
break;
case “M50”:
$arr = array(1,2,0);
break;
case “W50”:
$arr = array(1,2,0);
break;
case “M55”:
$arr = array(1,2,0);
break;
case “W55”:
$arr = array(1,2,0);
break;
case “M60”:
$arr = array(1,2,0);
break;
case “W60”:
$arr = array(1,2,0);
break;
case “M65”:
$arr = array(1,2,0);
break;
case “W65”:
$arr = array(1,2,0);
break;
case “M70”:
$arr = array(1,2,0);
break;
case “W70”:
$arr = array(1,2,0);
break;
case “M75”:
$arr = array(1,2,0);
break;
case “W75”:
$arr = array(1,2,0);
break;
case “M80”:
$arr = array(1,2,0);
break;
case “W80”:
$arr = array(1,2,0);
break;
}

echo “

“;
echo “

“;
echo “

“;

foreach ($arr as &$proef) {

$query = $wpdb->get_results(“select voornaam,naam,date_format(pres_dat,’%d-%m-%Y’) datum,proef,locatie,tijd,case when tijd=tijd2 then 1 else 0 end electijd from atleet_prestaties where categorie= ‘” . $categ . “‘ and proef_id = ” . $proef . ” and indoor=0 order by tijd2 asc limit 1 “);

foreach ($query as $row) {
echo “

“;
if ( $row-> electijd == 1 )
{
echo “

“;
}
else
{
echo “

“;
}
echo “

“;
}

}
echo “

“;
echo “

Discipline Atleet Prestatie Datum Locatie Opmerking
” . $row->proef . “ ” . $row->voornaam . ” ” . $row->naam . “ ” . substr($row->tijd, 0, -1) . “ ” . substr($row->tijd, 0, -1) . “* ” . $row->datum . “ ” . $row->locatie . “

“;
echo “* Handmatige tijdsopname“;

switch($categ) {
case “BENJ”:
$arr = array(12,13,14,15);
break;
case “BENM”:
$arr = array(12,13,14,15);
break;
case “PUPJ”:
$arr = array(12,13,14,16,17);
break;
case “PUPM”:
$arr = array(12,13,14,16,17);
break;
case “MINJ”:
$arr = array(12,13,14,16,17);
break;
case “MINM”:
$arr = array(12,13,22,16,20,21);
break;
}

echo “

“;
echo “

“;
echo “

“;

foreach ($arr as &$proef) {

$query = $wpdb->get_results(“select voornaam,naam,date_format(pres_dat,’%d-%m-%Y’) datum,proef,locatie,afstand from atleet_prestaties where categorie= ‘” . $categ . “‘ and proef_id = ” . $proef . ” and indoor=0 order by afstand desc limit 1 “);

foreach ($query as $row) {
echo “

“;
}
}
echo “

“;
echo “

Discipline Atleet Prestatie Datum Locatie Opmerking
” . $row->proef . “ ” . $row->voornaam . ” ” . $row->naam . “ ” . $row->afstand . “m ” . $row->datum . “ ” . $row->locatie . “

“;

$arr = array();
foreach ($arr as &$proef) {

echo “

“;
echo “

“;
echo “

“;

$query = $wpdb->get_results(“select voornaam,naam,date_format(pres_dat,’%d-%m-%Y’) datum,proef,locatie,punten from atleet_prestaties where categorie= ‘” . $categ . “‘ and proef_id = ” . $proef . ” and indoor=0 order by afstand desc limit 1″);

foreach ($query as $row) {
echo “

“;
}
echo “

“;
echo “

Discipline Atleet Prestatie Datum Locatie Opmerking
” . $row->proef . “ ” . $row->voornaam . ” ” . $row->naam . “ ” . $row->punten . ” punten ” . $row->datum . “ ” . $row->locatie . “

“;
}

[/insert_php]

Indoor

[insert_php]

setlocale(LC_ALL,’nl_NL’);
global $wpdb;

//$cat = ‘BENJ’;
switch($categ) {
case “BENJ”:
$arr = array(1,0);
break;
case “BENM”:
$arr = array(1,0);
break;
case “PUPJ”:
$arr = array(1,0);
break;
case “PUPM”:
$arr = array(1,2,0,18);
break;
case “MINJ”:
$arr = array(1,0);
break;
case “MINM”:
$arr = array(1,7,8,9,10,6,0,18,19);
break;
}
echo “

“;
echo “

“;
echo “

“;

foreach ($arr as &$proef) {

$query = $wpdb->get_results(“select voornaam,naam,date_format(pres_dat,’%d-%m-%Y’) datum,proef,locatie,tijd,case when tijd=tijd2 then 1 else 0 end electijd from atleet_prestaties where categorie= ‘” . $categ . “‘ and proef_id = ” . $proef . ” and indoor=1 order by tijd2 asc limit 1 “);

foreach ($query as $row)
{
echo “

“;
if ( $row-> electijd == 1 )
{
echo “

“;
}
else
{
echo “

“;
}
echo “

“;
}
}
echo “

“;
echo “

Discipline Atleet Prestatie Datum Locatie Opmerking
” . $row->proef . “ ” . $row->voornaam . ” ” . $row->naam . “ ” . substr($row->tijd, 0, -1) . “ ” . substr($row->tijd, 0, -1) . “* ” . $row->datum . “ ” . $row->locatie . “

“;
echo “* Handmatige tijdsopname“;

switch($categ) {
case “BENJ”:
$arr = array(12,13,14,15);
break;
case “BENM”:
$arr = array(12,13,14,15);
break;
case “PUPJ”:
$arr = array(12,13,14,15,16);
break;
case “PUPM”:
$arr = array(12,13,14,15,16);
break;
case “MINJ”:
$arr = array(12,13,14,15,16);
break;
case “MINM”:
$arr = array(12,13,22,16,20,21);
break;
}

echo “

“;
echo “

“;
echo “

“;

foreach ($arr as &$proef) {

$query = $wpdb->get_results(“select voornaam,naam,date_format(pres_dat,’%d-%m-%Y’) datum,proef,locatie,afstand from atleet_prestaties where categorie= ‘” . $categ . “‘ and proef_id = ” . $proef . ” and indoor=1 order by afstand desc limit 1 “);

foreach ($query as $row) {
echo “

“;
}
}
echo “

“;
echo “

Discipline Atleet Prestatie Datum Locatie Opmerking
” . $row->proef . “ ” . $row->voornaam . ” ” . $row->naam . “ ” . $row->afstand . “m ” . $row->datum . “ ” . $row->locatie . “

“;

switch($categ) {
case “BENJ”:
$arr = array(28);
break;
case “BENM”:
$arr = array(28);
break;
case “PUPJ”:
$arr = array(28);
break;
case “PUPM”:
$arr = array(28);
break;
case “MINJ”:
$arr = array(28);
break;
case “MINM”:
$arr = array(28);
break;
}

echo “

“;
echo “

“;
echo “

“;
foreach ($arr as &$proef) {

$query = $wpdb->get_results(“select voornaam,naam,date_format(pres_dat,’%d-%m-%Y’) datum,proef,locatie,punten from atleet_prestaties where categorie= ‘” . $categ . “‘ and proef_id = ” . $proef . ” and indoor=1 order by punten desc limit 1 “);

foreach ($query as $row) {
echo “

“;
}
}
echo “

“;
echo “

Discipline Atleet Prestatie Datum Locatie Opmerking
” . $row->proef . “ ” . $row->voornaam . ” ” . $row->naam . “ ” . $row->punten . ” punten ” . $row->datum . “ ” . $row->locatie . “

“;

[/insert_php]

Introductie

Atletiekclub Kapellen werd gesticht op 9 augustus 1921 en is hiermee één van de oudste clubs in de provincie Antwerpen. In 1971 vierde onze club haar 50-ste verjaardag en mocht zij de titel “Koninklijk” aan haar naam toevoegen.

In 2021 vieren we de 100-ste verjaardag van de club. Tot 1982 was de “Koninklijke Athletiek Club Kapellen” een feitelijke vereniging. Op 1 juli 1983 werd de VZW “Koninklijke Atletiek Klub Kapellen” opgericht. Samen met de VZW-statuten werd meteen ook de nieuwe afkorting van de club – “KAPE” – geregistreerd.

Contacteer ons


E-mail: kape@val.be

Bankrekening - BE70 0019 3451 2325

Maatschappelijke zetel

Plasstraat 22
2180 Ekeren

Contacteer ons

Copyright © 2018 Koninklijke Atletiekclub Kapellen - Extranet