Newer
Older
ini_set('display_errors', 1);
ini_set('log_errors',1);
error_reporting(E_ALL);
mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);
include_once('functions/db_connect.php');
include_once('functions/db_methods.php');
if( !empty($csv) ){
$secret=$_POST['secret'];
$user=db_checkSecret($secret);
if( $user ){
$C=preg_split('/
/',$csv);
if( trim($C[0]) == 'runde,spieltag,T,H,A,TH,TA,MID' ){
foreach( $C as $i=>$v ){
if( $i > 0 ) db_addErgebnisse(SAISON.','.$v,$secret);
}
} else if( trim($C[0]) == 'Saison,Spieltag,MatchID,teamID,L,Pos,SpielerID,Spieler,Z+,Z-,T,A,Bk' ) {
foreach( $C as $i=>$v ){
if( $i > 0 ) db_addStatistik($v,$secret);
}
} else if( trim($C[0]) == 'TeamID,N,SpielerID,Attr,Spieler,Alter,Pos,S,T,A,Z+,Z-,Zd' ){
$w=preg_split('/,/',$v);
if( !empty($TEAMS[$w[0]]) ){
if( $TEAMS[$w[0]] == $w[1] ){
} else if( trim($C[0]) == 'SpielerID,Spieler,Alter,Nt,Saison,Liga,TeamID,Team,S,T,A,Z+,Z-,Zd,Bk,Bi+,Bi-,Attr,Face,Karriereende' ){
db_addSpieler(array_pop($C),$secret);
}
}
}
?>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="cache-control" content="no-cache" />
<meta http-equiv="pragma" content="no-cache" />
<meta http-equiv="expires" content="0" />
var SAISON_SETTINGS={{ site.pages | where_exp: 'item','item.saison>25' | sort: 'saison' | map: 'finalteams' | jsonify }};
var MANAGERVOTING={{ page.managervoting.enabled | default: false }};
var MANAGERVOTING_TEAM='{{ page.managervoting.result }}'; {% assign M = site.pages | where_exp: "item", "item.saison > 25" %}
var MANAGERVOTING_WINNER={ {% for m in M %}"{{ m.saison }}" : {{ m.managervoting.result | jsonify }}{% if forloop.last == false %},{% endif %}{% endfor %} };
var SAISON_TEAMVOTED=json_load('functions/get_managervoted.php?saison='+SAISON);
SAISON_TEAMVOTED.push([]);
TEAMS.forEach(
function(v){
T2ID[v.nt] = v.id;
}
);
var STARTLISTE={{ page.startliste | jsonify }}; {% assign startliste_size = page.startliste[0] | size | append: '' %}
var STARTLISTE_PARTIEN={{ site.data.partien | map: startliste_size | jsonify }}[0];
var STARTLISTE_PARTIEN_PAUSE={{ page.startliste_partien_pause | jsonify }};
if( $.isArray( STARTLISTE_PARTIEN_PAUSE ) ){
STARTLISTE_PARTIEN.forEach(
function(v,i){
if( STARTLISTE_PARTIEN_PAUSE[i] != undefined ){
STARTLISTE_PARTIEN[i][0]=STARTLISTE_PARTIEN_PAUSE[i];
}
}
);
}
var SPIELER=json_load('functions/get_spieler.php');
var UNKNOWN=json_load('functions/get_unknown.php');
if( UNKNOWN.length == 0 ) UNKNOWN=[[''],['']];
UNKNOWN = UNKNOWN.reduce((a,b) => (a.concat(b)));
var NEUESPIELER=json_load('functions/get_neuespieler.php');
var ERGEBNISSE=json_load('functions/get_ergebnisse.php');
var STAT_SAISON=json_load('functions/get_statistik_by_saison.php?saison='+SAISON);
var STAT_ALL=json_load('functions/get_statistik.php');
var MEISTERTITEL=calculateAllPunktestand().map((a) => ( a[0].nt ));
if( STATISTIK_SAISON[v.SpielerID] == undefined ) STATISTIK_SAISON[v.SpielerID]={ 'S' :0, 'T' : 0, 'A' : 0, 'Z' : 0, 'Zpos' : 0, 'Zneg' : 0, 'MID' : [], 'face' : '' };
STATISTIK_SAISON[v.SpielerID].S++;
STATISTIK_SAISON[v.SpielerID].T+=v.Tore*1;
STATISTIK_SAISON[v.SpielerID].A+=v.Assists*1;
STATISTIK_SAISON[v.SpielerID].Z+=v.Zwk*1;
STATISTIK_SAISON[v.SpielerID].Zpos+=v.Zpos*1;
STATISTIK_SAISON[v.SpielerID].Zneg+=v.Zneg*1;
STATISTIK_SAISON[v.SpielerID].MID.push(v.MID);
STATISTIK_SAISON[v.SpielerID].name=v.name;
STATISTIK_SAISON[v.SpielerID].age=v.age*1;
STATISTIK_SAISON[v.SpielerID].age_saison=v.age_saison*1;
STATISTIK_SAISON[v.SpielerID].nt=v.nt;
STATISTIK_SAISON[v.SpielerID].attr=v.attr;
}
);
STATISTIK_ALL={};
STAT_ALL.forEach(
function(v,i){
if( STATISTIK_ALL[v.SpielerID] == undefined ) STATISTIK_ALL[v.SpielerID]={ 'S' :0, 'T' : 0, 'A' : 0, 'Z' : 0, 'Zpos' : 0, 'Zneg' : 0, 'MID' : [], 'face' : '' };
STATISTIK_ALL[v.SpielerID].S++;
STATISTIK_ALL[v.SpielerID].T+=v.Tore*1;
STATISTIK_ALL[v.SpielerID].A+=v.Assists*1;
STATISTIK_ALL[v.SpielerID].Z+=v.Zwk*1;
STATISTIK_ALL[v.SpielerID].Zpos+=v.Zpos*1;
STATISTIK_ALL[v.SpielerID].Zneg+=v.Zneg*1;
STATISTIK_ALL[v.SpielerID].MID.push(v.MID);
STATISTIK_ALL[v.SpielerID].name=v.name;
STATISTIK_ALL[v.SpielerID].age=v.age*1;
STATISTIK_ALL[v.SpielerID].age_saison=v.age_saison*1;
STATISTIK_ALL[v.SpielerID].nt=v.nt;
STATISTIK_ALL[v.SpielerID].attr=v.attr;
}
);
const STEP={{ page.step | default: '1' }};
const FINALS_STEP={{ page.finals_step | default: '0' }};
const LIGASPIELTAG={{ page.ligaspieltag | default: '1' }};
const SAISON_START_DATE=new Date( '{{ page.date }}' ).toJSON();
// check ob alle Teams der Startliste in DB vorhanden sind
var check=
STARTLISTE.map(
(a) => (
a.map( (b) => ( T2ID[b] != undefined ) )
)
).reduce(( c,d ) => ( c && d )).reduce(( e,f ) => ( e && f ));
if( check ){
$(document).ready( function(){
calculatePartien('{{ page.saison }}', '{{ page.date }}');
calculatePunktestand('{{ page.saison }}', '7'); // ######## check this
calculateTabelle('{{ page.saison }}','T');
calculateTabelle('{{ page.saison }}','A');
calculateTabelle('{{ page.saison }}','Z');
$(this).toggleClass('active',true);
$('table.tabelle').toggleClass('d-none',true);
$('#tabelle_'+$(this).text()[0]).toggleClass('d-none',false);
$('#news tbody').html('');
UNKNOWN.forEach(
function(v,i){
var team=TEAMS.filter((a) => ( a.nt == v.nt ))[0];
if( team == undefined ) return;
var tr = document.createElement('tr');
var td = document.createElement('td');
var st=parseInt(( new Date() - new Date(v.zeitstempel) ) / 1000 / 3600 / 24);
$(td).text( st == 1 ? 'vor ' + st + ' Tag' : 'vor ' + st + ' Tagen' );
$(tr).append(td);
var td = document.createElement('td');
td.innerText='';
$(tr).append(td);
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
var td = document.createElement('td');
var img = document.createElement('img');
img.src='images/flags/' + ( v.flag ? v.flag : v.nt ) + '.svg';
img.classList='flags';
$(td).append(img);
$(tr).append(td);
var td = document.createElement('td');
td.classList='mono';
var a = document.createElement('a');
a.href='https://ultrasoccer.de/playerprofile/?id='+v.SpielerID;
a.target='ultrasoccer';
$(a).text(v.SpielerID);
$(td).append(a);
$(tr).append(td);
var td = document.createElement('td');
var a = document.createElement('a');
a.href='https://ultrasoccer.de/players/?id='+v.teamID;
a.target='ultrasoccer';
$(a).text(v.team);
$(td).append(a);
$(tr).append(td);
$('#news tbody').append(tr);
}
);
NEUESPIELER.forEach(
function(v,i){
var team=TEAMS.filter((a) => ( a.nt == v.nt ))[0];
if( team == undefined ) return;
if( STARTLISTE.reduce((a,b) => (a.concat(b))).indexOf( v.nt ) == -1 ) return;
var tr = document.createElement('tr');
var td = document.createElement('td');
var st=parseInt(( new Date() - new Date(v.zeitstempl) ) / 1000 / 3600 / 24);
$(td).text( st == 1 ? 'vor ' + st + ' Tag' : 'vor ' + st + ' Tagen' );
$(tr).append(td);
var td = document.createElement('td');
var div = document.createElement('div');
div.classList='face';
if( v.face.split(/_/g).length == 5 ){
var img = document.createElement('img');
img.src='images/facegenerator/fg_head_' + v.face.split(/_/g)[0] + '.png';
$(div).append(img);
var img = document.createElement('img');
img.src='images/facegenerator/fg_hair_' + v.face.split(/_/g)[1] + '.png';
$(div).append(img);
var img = document.createElement('img');
img.src='images/facegenerator/fg_beard_' + v.face.split(/_/g)[2] + '.png';
$(div).append(img);
var img = document.createElement('img');
img.src='images/facegenerator/fg_mouth_' + v.face.split(/_/g)[3] + '.png';
$(div).append(img);
var img = document.createElement('img');
img.src='images/facegenerator/fg_eyes_' + v.face.split(/_/g)[4] + '.png';
$(div).append(img);
}
$(td).append(div);
$(tr).append(td);
var td = document.createElement('td');
var img = document.createElement('img');
img.src='images/flags/' + ( team.flag ? team.flag : team.nt ) + '.svg';
img.classList='flags';
$(td).append(img);
$(tr).append(td);
var td = document.createElement('td');
var a = document.createElement('a');
if( v.attr != '' ){
Object.values( v.attr.split(/ /g) ).forEach(
function(w){
var attr = document.createElement('i');
attr.classList='fas '+w;
$(td).append(attr);
}
)
}
$(a).text(v.name);
var span=document.createElement('span');
$(span).text(' ('+v.age+')');
$(td).append(a);
$(td).append(span);
$(tr).append(td);
var td = document.createElement('td');
var a = document.createElement('a');
a.href='https://ultrasoccer.de/players/?id='+v.teamID;
a.target='ultrasoccer';
$(a).text(team.name);
$(td).append(a);
$(tr).append(td);
$('#news tbody').append(tr);
}
);
}
);
} else {
alert( 'Error: Nicht alle Teams der Startliste sind in der DB vorhanden!');
}
</script>
<form method="POST">
<div id="copypaste" class="d-none" ondblclick="$(this).toggleClass('d-none')">
<button type="submit">update</button>
<input type="text" name="secret" placeholder="secret" value="<?=$secret?>">
<textarea name="csv"></textarea>
</div>
</form>
<div class="div_right">
<button id="historie" class="" onclick="calculateHistorie()"><b>HISTORIE</b></button> <button id="ewige" class="" onclick="calculateEwige()"><b>EWIGE</b></button>
{% for f in site.pages %}
{% assign fn = f.name | slice:0,2 %}
{% assign fn_isnumeric = fn | is_numeric %}
{% if fn_isnumeric %}
{% assign fn = fn | times: 1 %}
<a href="./{{ fn }}.php"><button class="{% if page.saison == fn %}active{% endif %}"><b>{{ fn | minus: 25 }}</b><sup>{{ fn }}</sup></button></a>
{% endif %}
{% endfor %}
<h4 class="tabelle">Tabelle <button>Zweikampf</button><button>Assists</button><button>Tore</button><button class="punktestand active">Punktestand</button></h2>
<thead>
<tr>
<th>Pl.</th>
<th>Sp.</th>
<th>Team</th>
<th><i class="fas fa-trophy" title="Pokalgewinn"></i></th>
<th><i class="fas fa-crown" title="Meistertitel"></i></th>
<th><i class="fas fa-star" title="im Finale gescheitert"></i></th>
<th><i class="fas fa-thumbs-up managervoted" title="von Managern zum Team des Jahres gewählt"></i></th>
<th title="Siege">S</th>
<th title="Unentschieden">U</th>
<th title="Niederlagen">N</th>
<th>Pkt.</th>
</tr>
</thead>
<tbody>
</tbody>
</table>
<table id="tabelle_T" class="tabelle d-none">
<th>Name</th>
<th>Team</th>
<th>T</th>
</tr>
</thead>
<tbody>
</tbody>
</table>
<table id="tabelle_A" class="tabelle d-none">
<th>Name</th>
<th>Team</th>
<th>A</th>
</tr>
</thead>
<tbody>
</tbody>
</table>
<table id="tabelle_Z" class="tabelle d-none">
<table id="tabelle_team" class="tabelle d-none" ondblclick="backToActiveTable()">
<thead>
<tr>
<th>Spieler</th>
<th>Alter</th>
<th>S/T/A</th>
<th>Zwk</th>
</tr>
</thead>
<tbody>
</tbody>
</table>
<table id="tabelle_historie" class="tabelle d-none" ondblclick="backToActiveTable()">
<thead>
<tr>
</tr>
</thead>
<tbody>
</tbody>
</table>
<h3>Spielerdebüts</h3>
<table id="news">
<thead>
<th>Zeit</th>
<th>Nt</th>
<th>Spieler</th>
<th>Team</th>
</thead>
<tbody>
</tbody>
</table>
<div id="partien" class="div_left">
</div>
<div id="lastresults" class="d-none" ondblclick="hideLastResults(true)">
<table>
<tbody>
</tbody>
</table>
</div>