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($_POST['p']) ){
$PARTIEN = json_decode( $_POST['p'], true );
//var_dump( $PARTIEN );
}
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);
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
*/
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' ) {
$H=0; $A=0; $T=''; $runde=0; $spieltag=0; $TH=0; $TA=0; $MID=0;
$St = [];
foreach( $C as $i=>$v ){
if( $i > 0 ) $St[]=$v;
$V = preg_split('/,/',$v);
if( $V[4] == 'H' && $V[5]*1 > 0 ){
$TH+=$V[10]*1;
$H =$V[3]*1;
}
if( $V[4] == 'G' && $V[5]*1 > 0 ){
$TA+=$V[10]*1;
$A =$V[3]*1;
}
$MID=$V[2];
}
$inv = false;
$r = array_filter($PARTIEN,
function($v,$k){
global $H;
global $A;
global $inv;
global $H_nt;
global $A_nt;
if( $v['MID']*1 == 0 && $v['H']*1 == $H && $v['A']*1 == $A ){
$H_nt = $v['H_nt'];
$A_nt = $v['A_nt'];
return true;
} else if( $v['MID']*1 == 0 && $v['H'] == $A && $v['A'] == $H ){
$H_nt = $v['H_nt'];
$A_nt = $v['A_nt'];
$inv = true;
return true;
}
},ARRAY_FILTER_USE_BOTH
);
if( sizeof($r) > 0 ){
$r = array_values($r)[0];
$runde = $r['runde'];
$spieltag = $r['spieltag'];
db_addErgebnisse(implode( ',', [ SAISON, $runde, $spieltag, $T, $H_nt, $A_nt, $TA, $TH, $MID ] ), $secret);
} else {
db_addErgebnisse(implode( ',', [ SAISON, $runde, $spieltag, $T, $H_nt, $A_nt, $TH, $TA, $MID ] ), $secret);
}
foreach( $St as $st ){
db_addStatistik($st,$secret);
}
}
} else if( trim($C[0]) == 'TeamID,N,SpielerID,Attr,Spieler,Alter,Pos,S,T,A,Z+,Z-,Zd' ){
$TEAMS=db_getIdNtFromTeams();
foreach( $C as $i=>$v ){
$w=preg_split('/,/',$v);
if( !empty($TEAMS[$w[0]]) ){
if( $TEAMS[$w[0]] == $w[1] ){
//db_addSpieler($v,$secret);
}
}
}
} 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 STAT_ALL_MID=json_load('functions/get_statistikMID.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].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);
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
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>
<div id="copypaste" class="d-none" ondblclick="$(this).toggleClass('d-none')">
<button type="button" onclick="$('#p').val(JSON.stringify( PARTIEN )); $('#formu').submit();">update</button>
<input type="text" name="secret" placeholder="secret" value="<?=$secret?>">
<input type="hidden" id="p" name="p" value="">
<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 <a style="color: aliceblue;" href="https://ultrasoccer.de/forum/?thread=29761&title=nationsleaguenlfaqdatenzahlen&page=1#post12" target="ultrasoccer">[Regelwerk]</a> <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">
<div class="scrollen_team">
<table id="tabelle_team" class="tabelle d-none" ondblclick="backToActiveTable()">
<thead>
<tr>
<th></th>
<th>Nt</th>
<th>Spieler</th>
<th>Alter</th>
</tr>
</thead>
<tbody>
</tbody>
</table>
</div>
<div class="scrollen">
<table id="tabelle_historie" class="tabelle d-none" ondblclick="backToActiveTable()">
<thead>
<tr>
</tr>
</thead>
<tbody>
</tbody>
</table>
</div>
<h3 class="news">Spielerdebüts</h3>
<table id="news" class="news">
<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>