Newer
Older
include_once('functions/db_connect.php');
include_once('functions/db_methods.php');
$UNKNOWN=[];
$T = db_getFromTeams();
foreach( $T as $t ){
$u=db_getUnknownSpieler( $t['id'] );
if( count($u) > 0 ) $UNKNOWN[]=$u;
}
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>
var SAISON_SETTINGS={{ site.pages | where_exp: 'item','item.saison>25' | sort: 'saison' | map: 'finalteams' | jsonify }};
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_encode( db_getFromSpieler() )?>;
var UNKNOWN=<?=json_encode( $UNKNOWN )?>.reduce((a,b) => (a.concat(b)));
var STAT_SAISON=<?=json_encode( db_getFromStatistikBySaison(SAISON))?>;
var STAT_ALL=<?=json_encode( db_getFromStatistik())?>;
STATISTIK_SAISON={};
STAT_SAISON.forEach(
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');
//calculatePunktestand( 0, '7');
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;
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
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');
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);
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
var td = document.createElement('td');
var div = document.createElement('div');
div.classList='face';
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');
a.href='https://ultrasoccer.de/playerprofile/?id='+v.id;
a.target='ultrasoccer';
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="knapp gescheitert"></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>