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');
$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>
<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 }};
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');
console.log( UNKNOWN );
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');
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(){
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;
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);
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
237
238
239
240
241
242
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);
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
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');
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>