include ("mysqlLS.inc")?>
echo "";
echo "| Name | ";
echo "Maus drüber | ";
echo "
";
$sql = mysql_query("SELECT * FROM hauptdatei WHERE ng LIKE '%$su1%'");
while ($ds = mysql_fetch_object($sql)){
$name = $ds -> ng;
$geb = $ds -> geb;
$nrs = $ds -> nrs;
$anz = $ds -> anz;
$ae = $ds -> altere;
$al = $ds -> alterl;
$ae = substr($ae,0,2);
$al = substr($al,0,2);
$ages = $ds -> ages;
$esp = $ds -> erstes;
$lsp = $ds -> letztes;
$b1 = $ds -> s1;
$b2 = $ds -> s2;
$b3 = $ds -> s3;
$b4 = $ds -> s4;
$b5 = $ds -> s5;
$b6 = $ds -> s6;
$b7 = $ds -> s7;
$b8 = $ds -> s8;
$b9 = $ds -> s9;
$b10 = $ds -> s10;
$b11 = $ds -> s11;
$b12 = $ds -> s12;
$b13 = $ds -> s13;
$b14 = $ds -> s14;
$b15 = $ds -> s15;
$b16 = $ds -> s16;
$b17 = $ds -> s17;
$b18 = $ds -> s18;
$b19 = $ds -> s19;
$b20 = $ds -> s20;
$b21 = $ds -> s21;
$b22 = $ds -> s22;
$b23 = $ds -> s23;
$b24 = $ds -> s24;
$b25 = $ds -> s25;
$b26 = $ds -> s26;
$b27 = $ds -> s27;
$b28 = $ds -> s28;
$b29 = $ds -> s29;
$b30 = $ds -> s30;
$b31 = $ds -> s31;
$b32 = $ds -> s32;
$b33 = $ds -> s33;
$b34 = $ds -> s34;
$b35 = $ds -> s35;
$b36 = $ds -> s36;
$b37 = $ds -> s37;
$b38 = $ds -> s38;
$b39 = $ds -> s39;
$b40 = $ds -> s40;
$b41 = $ds -> s41;
$b42 = $ds -> s42;
$b43 = $ds -> s43;
$b44 = $ds -> s44;
$b45 = $ds -> s45;
$b46 = $ds -> s46;
$b47 = $ds -> s47;
$b48 = $ds -> s48;
$b49 = $ds -> s49;
$b50 = $ds -> s50;
$b51 = $ds -> s51;
$b52 = $ds -> s52;
$b53 = $ds -> s53;
$b54 = $ds -> s54;
$b55 = $ds -> s55;
$b56 = $ds -> s56;
$b57 = $ds -> s57;
$b58 = $ds -> s58;
$b59 = $ds -> s59;
$b60 = $ds -> s60;
$b61 = $ds -> s61;
$b62 = $ds -> s62;
$b63 = $ds -> s63;
$b64 = $ds -> s64;
$b65 = $ds -> s65;
$b66 = $ds -> s66;
$b67 = $ds -> s67;
$b68 = $ds -> s68;
$b69 = $ds -> s69;
$b70 = $ds -> s70;
$b71 = $ds -> s71;
$b72 = $ds -> s72;
$b73 = $ds -> s73;
$b74 = $ds -> s74;
$b75 = $ds -> s75;
$b76 = $ds -> s76;
$b77 = $ds -> s77;
$b78 = $ds -> s78;
$b79 = $ds -> s79;
$b80 = $ds -> s80;
$b81 = $ds -> s81;
$b82 = $ds -> s82;
$b83 = $ds -> s83;
$b84 = $ds -> s84;
$b85 = $ds -> s85;
$b86 = $ds -> s86;
$b87 = $ds -> s87;
$b88 = $ds -> s88;
$b89 = $ds -> s89;
$b90 = $ds -> s90;
$b91 = $ds -> s91;
$b92 = $ds -> s92;
$b93 = $ds -> s93;
$b94 = $ds -> s94;
$b95 = $ds -> s95;
$b96 = $ds -> s96;
$b97 = $ds -> s97;
$b98 = $ds -> s98;
$b99 = $ds -> s99;
$b100 = $ds -> s100;
$b101 = $ds -> s101;
$b102 = $ds -> s102;
$b103 = $ds -> s103;
$b104 = $ds -> s104;
$b105 = $ds -> s105;
$b106 = $ds -> s106;
$b107 = $ds -> s107;
$b108 = $ds -> s108;
$b109 = $ds -> s109;
$b110 = $ds -> s110;
$b111 = $ds -> s111;
$b112 = $ds -> s112;
$b113 = $ds -> s113;
$b114 = $ds -> s114;
$b115 = $ds -> s115;
$b116 = $ds -> s116;
$b117 = $ds -> s117;
$b118 = $ds -> s118;
$b119 = $ds -> s119;
$b120 = $ds -> s120;
$b121 = $ds -> s121;
$b122 = $ds -> s122;
$b123 = $ds -> s123;
$b124 = $ds -> s124;
$b125 = $ds -> s125;
$b126 = $ds -> s126;
$b127 = $ds -> s127;
$b128 = $ds -> s128;
$b129 = $ds -> s129;
$b130 = $ds -> s130;
$b131 = $ds -> s131;
$b132 = $ds -> s132;
$b133 = $ds -> s133;
$b134 = $ds -> s134;
$b135 = $ds -> s135;
$b136 = $ds -> s136;
$b137 = $ds -> s137;
$b138 = $ds -> s138;
$b139 = $ds -> s139;
$b140 = $ds -> s140;
$b141 = $ds -> s141;
$b142 = $ds -> s142;
$b143 = $ds -> s143;
$b144 = $ds -> s144;
$b145 = $ds -> s145;
$b146 = $ds -> s146;
$b147 = $ds -> s147;
$b148 = $ds -> s148;
$b149 = $ds -> s149;
$b150 = $ds -> s150;
echo "";
echo "| $name";
}
?>
include ("visitenkarte.inc")?>
| Visitenkarte echo "$vn"." "."$nn";?>
|
$sql = mysql_query("SELECT * FROM hauptdatei WHERE nrs=$nrs");
while ($ds = mysql_fetch_object($sql)){
$vn = $ds -> vn;
$nn = $ds -> nn;
$name = $ds ->ng;
$geb = $ds -> geb;
$nrs = $ds -> nrs;
$anz = $ds -> anz;
$ages = $ds -> ages;
$b1 = $ds -> s1;
$b2 = $ds -> s2;
$b3 = $ds -> s3;
$b4 = $ds -> s4;
$b5 = $ds -> s5;
$b6 = $ds -> s6;
$b7 = $ds -> s7;
$b8 = $ds -> s8;
$b9 = $ds -> s9;
$b10 = $ds -> s10;
$b11 = $ds -> s11;
$b12 = $ds -> s12;
$b13 = $ds -> s13;
$b14 = $ds -> s14;
$b15 = $ds -> s15;
$b16 = $ds -> s16;
$b17 = $ds -> s17;
$b18 = $ds -> s18;
$b19 = $ds -> s19;
$b20 = $ds -> s20;
$b21 = $ds -> s21;
$b22 = $ds -> s22;
$b23 = $ds -> s23;
$b24 = $ds -> s24;
$b25 = $ds -> s25;
$b26 = $ds -> s26;
$b27 = $ds -> s27;
$b28 = $ds -> s28;
$b29 = $ds -> s29;
$b30 = $ds -> s30;
$b31 = $ds -> s31;
$b32 = $ds -> s32;
$b33 = $ds -> s33;
$b34 = $ds -> s34;
$b35 = $ds -> s35;
$b36 = $ds -> s36;
$b37 = $ds -> s37;
$b38 = $ds -> s38;
$b39 = $ds -> s39;
$b40 = $ds -> s40;
$b41 = $ds -> s41;
$b42 = $ds -> s42;
$b43 = $ds -> s43;
$b44 = $ds -> s44;
$b45 = $ds -> s45;
$b46 = $ds -> s46;
$b47 = $ds -> s47;
$b48 = $ds -> s48;
$b49 = $ds -> s49;
$b50 = $ds -> s50;
$b51 = $ds -> s51;
$b52 = $ds -> s52;
$b53 = $ds -> s53;
$b54 = $ds -> s54;
$b55 = $ds -> s55;
$b56 = $ds -> s56;
$b57 = $ds -> s57;
$b58 = $ds -> s58;
$b59 = $ds -> s59;
$b60 = $ds -> s60;
$b61 = $ds -> s61;
$b62 = $ds -> s62;
$b63 = $ds -> s63;
$b64 = $ds -> s64;
$b65 = $ds -> s65;
$b66 = $ds -> s66;
$b67 = $ds -> s67;
$b68 = $ds -> s68;
$b69 = $ds -> s69;
$b70 = $ds -> s70;
$b71 = $ds -> s71;
$b72 = $ds -> s72;
$b73 = $ds -> s73;
$b74 = $ds -> s74;
$b75 = $ds -> s75;
$b76 = $ds -> s76;
$b77 = $ds -> s77;
$b78 = $ds -> s78;
$b79 = $ds -> s79;
$b80 = $ds -> s80;
$b81 = $ds -> s81;
$b82 = $ds -> s82;
$b83 = $ds -> s83;
$b84 = $ds -> s84;
$b85 = $ds -> s85;
$b86 = $ds -> s86;
$b87 = $ds -> s87;
$b88 = $ds -> s88;
$b89 = $ds -> s89;
$b90 = $ds -> s90;
$b91 = $ds -> s91;
$b92 = $ds -> s92;
$b93 = $ds -> s93;
$b94 = $ds -> s94;
$b95 = $ds -> s95;
$b96 = $ds -> s96;
$b97 = $ds -> s97;
$b98 = $ds -> s98;
$b99 = $ds -> s99;
$b100 = $ds -> s100;
$b101 = $ds -> s101;
$b102 = $ds -> s102;
$b103 = $ds -> s103;
$b104 = $ds -> s104;
$b105 = $ds -> s105;
$b106 = $ds -> s106;
$b107 = $ds -> s107;
$b108 = $ds -> s108;
$b109 = $ds -> s109;
$b110 = $ds -> s110;
$b111 = $ds -> s111;
$b112 = $ds -> s112;
$b113 = $ds -> s113;
$b114 = $ds -> s114;
$b115 = $ds -> s115;
$b116 = $ds -> s116;
$b117 = $ds -> s117;
$b118 = $ds -> s118;
$b119 = $ds -> s119;
$b120 = $ds -> s120;
$b121 = $ds -> s121;
$b122 = $ds -> s122;
$b123 = $ds -> s123;
$b124 = $ds -> s124;
$b125 = $ds -> s125;
$b126 = $ds -> s126;
$b127 = $ds -> s127;
$b128 = $ds -> s128;
$b129 = $ds -> s129;
$b130 = $ds -> s130;
$b131 = $ds -> s131;
$b132 = $ds -> s132;
$b133 = $ds -> s133;
$b134 = $ds -> s134;
$b135 = $ds -> s135;
$b136 = $ds -> s136;
$b137 = $ds -> s137;
$b138 = $ds -> s138;
$b139 = $ds -> s139;
$b140 = $ds -> s140;
$b141 = $ds -> s141;
$b142 = $ds -> s142;
$b143 = $ds -> s143;
$b144 = $ds -> s144;
$b145 = $ds -> s145;
$b146 = $ds -> s146;
$b147 = $ds -> s147;
$b148 = $ds -> s148;
$b149 = $ds -> s149;
$b150 = $ds -> s150;
$b = array($b1,$b2,$b3,$b4,$b5,$b6,$b7,$b8,$b9,$b10,$b11,$b12,$b13,$b14,$b15,$b16,$b17,$b18,$b19,$b20,$b21,$b22,$b23,$b24,$b25,$b26,$b27,$b28,$b29,$b30,$b31,$b32,$b33,$b34,$b35,$b36,$b37,$b38,$b39,$b40,$b41,$b42,$b43,$b44,$b45,$b46,$b47,$b48,$b49,$b50,$b51,$b52,$b53,$b54,$b55,$b56,$b57,$b58,$b59,$b60,$b61,$b62,$b63,$b64,$b65,$b66,$b67,$b68,$b69,$b70,$b71,$b72,$b73,$b74,$b75,$b76,$b77,$b78,$b79,$b80,$b81,$b82,$b83,$b84,$b85,$b86,$b87,$b88,$b89,$b90,$b91,$b92,$b93,$b94,$b95,$b96,$b97,$b98,$b99,$b100,$b101,$b102,$b103,$b104,$b105,$b106,$b107,$b108,$b109,$b110,$b111,$b112,$b113,$b114,$b115,$b116,$b117,$b118,$b119,$b120,$b121,$b122,$b123,$b124,$b125,$b126,$b127,$b128,$b129,$b130,$b131,$b132,$b133,$b134,$b135,$b136,$b137,$b138,$b139,$b140,$b141,$b142,$b143,$b144,$b145,$b146,$b147,$b148,$b149,$b150);
}
?>
echo "
";
echo "";
echo "| Nr. | ";
echo "Datum | ";
echo "Spielort | ";
echo "Heim | ";
echo "Gast | ";
echo "Erg | ";
echo "HZ | ";
echo "Art | ";
echo "Bemerk | ";
echo "T | ";
echo "
";
// --------------------------------------------------------
$sql = mysql_query("SELECT * FROM sptore WHERE nrs = $nrs");
while ($ds = mysql_fetch_object($sql)){
$t1 = $ds -> s1;
$t2 = $ds -> s2;
$t3 = $ds -> s3;
$t4 = $ds -> s4;
$t5 = $ds -> s5;
$t6 = $ds -> s6;
$t7 = $ds -> s7;
$t8 = $ds -> s8;
$t9 = $ds -> s9;
$t10 = $ds -> s10;
$t11 = $ds -> s11;
$t12 = $ds -> s12;
$t13 = $ds -> s13;
$t14 = $ds -> s14;
$t15 = $ds -> s15;
$t16 = $ds -> s16;
$t17 = $ds -> s17;
$t18 = $ds -> s18;
$t19 = $ds -> s19;
$t20 = $ds -> s20;
$t21 = $ds -> s21;
$t22 = $ds -> s22;
$t23 = $ds -> s23;
$t24 = $ds -> s24;
$t25 = $ds -> s25;
$t26 = $ds -> s26;
$t27 = $ds -> s27;
$t28 = $ds -> s28;
$t29 = $ds -> s29;
$t30 = $ds -> s30;
$t31 = $ds -> s31;
$t32 = $ds -> s32;
$t33 = $ds -> s33;
$t34 = $ds -> s34;
$t35 = $ds -> s35;
$t36 = $ds -> s36;
$t37 = $ds -> s37;
$t38 = $ds -> s38;
$t39 = $ds -> s39;
$t40 = $ds -> s40;
$t41 = $ds -> s41;
$t42 = $ds -> s42;
$t43 = $ds -> s43;
$t44 = $ds -> s44;
$t45 = $ds -> s45;
$t46 = $ds -> s46;
$t47 = $ds -> s47;
$t48 = $ds -> s48;
$t49 = $ds -> s49;
$t50 = $ds -> s50;
$t51 = $ds -> s51;
$t52 = $ds -> s52;
$t53 = $ds -> s53;
$t54 = $ds -> s54;
$t55 = $ds -> s55;
$t56 = $ds -> s56;
$t57 = $ds -> s57;
$t58 = $ds -> s58;
$t59 = $ds -> s59;
$t60 = $ds -> s60;
$t61 = $ds -> s61;
$t62 = $ds -> s62;
$t63 = $ds -> s63;
$t64 = $ds -> s64;
$t65 = $ds -> s65;
$t66 = $ds -> s66;
$t67 = $ds -> s67;
$t68 = $ds -> s68;
$t = array($t1,$t2,$t3,$t4,$t5,$t6,$t7,$t8,$t9,$t10,$t11,$t12,$t13,$t14,$t15,$t16,$t17,$t18,$t19,$t20,$t21,$t22,$t23,$t24,$t25,$t26,$t27,$t28,$t29,$t30,$t31,$t32,$t33,$t34,$t35,$t36,$t37,$t38,$t39,$t40,$t41,$t42,$t43,$t44,$t45,$t46,$t47,$t48,$t49,$t50,$t51,$t52,$t53,$t54,$t55,$t56,$t57,$t58,$t59,$t60,$t61,$t62,$t63,$t64,$t64,$t66,$t67,$t68);
echo "";
}
//-----------------------------------------------------------
$sql = mysql_query("SELECT * FROM spiele WHERE nr=$b1 OR nr=$b2 OR nr=$b3 OR nr=$b4 OR nr=$b5 OR nr=$b6 OR nr=$b7 OR nr=$b8 OR nr=$b9 OR nr=$b10 OR nr=$b11 OR nr=$b12 OR nr=$b13 OR nr=$b14 OR nr=$b15 OR nr=$b16 OR nr=$b17 OR nr=$b18 OR nr=$b19 OR nr=$b20 OR nr=$b21 OR nr=$b22 OR nr=$b23 OR nr=$b24 OR nr=$b25 OR nr=$b26 OR nr=$b27 OR nr=$b28 OR nr=$b29 OR nr=$b30 OR nr=$b31 OR nr=$b32 OR nr=$b33 OR nr=$b34 OR nr=$b35 OR nr=$b36 OR nr=$b37 OR nr=$b38 OR nr=$b39 OR nr=$b40 OR nr=$b41 OR nr=$b42 OR nr=$b43 OR nr=$b44 OR nr=$b45 OR nr=$b46 OR nr=$b47 OR nr=$b48 OR nr=$b49 OR nr=$b50 OR nr=$b51 OR nr=$b52 OR nr=$b53 OR nr=$b54 OR nr=$b55 OR nr=$b56 OR nr=$b57 OR nr=$b58 OR nr=$b59 OR nr=$b60 OR nr=$b61 OR nr=$b62 OR nr=$b63 OR nr=$b64 OR nr=$b65 OR nr=$b66 OR nr=$b67 OR nr=$b68 OR nr=$b69 OR nr=$b70 OR nr=$b71 OR nr=$b72 OR nr=$b73 OR nr=$b74 OR nr=$b75 OR nr=$b76 OR nr=$b77 OR nr=$b78 OR nr=$b79 OR nr=$b80 OR nr=$b81 OR nr=$b82 OR nr=$b83 OR nr=$b84 OR nr=$b85 OR nr=$b86 OR nr=$b87 OR nr=$b88 OR nr=$b89 OR nr=$b90 OR nr=$b91 OR nr=$b92 OR nr=$b93 OR nr=$b94 OR nr=$b95 OR nr=$b96 OR nr=$b97 OR nr=$b98 OR nr=$b99 OR nr=$b100 OR nr=$b101 OR nr=$b102 OR nr=$b103 OR nr=$b104 OR nr=$b105 OR nr=$b106 OR nr=$b107 OR nr=$b108 OR nr=$b109 OR nr=$b110 OR nr=$b111 OR nr=$b112 OR nr=$b113 OR nr=$b114 OR nr=$b115 OR nr=$b116 OR nr=$b117 OR nr=$b118 OR nr=$b119 OR nr=$b120 OR nr=$b121 OR nr=$b122 OR nr=$b123 OR nr=$b124 OR nr=$b125 OR nr=$b126 OR nr=$b127 OR nr=$b128 OR nr=$b129 OR nr=$b130 OR nr=$b131 OR nr=$b132 OR nr=$b133 OR nr=$b134 OR nr=$b135 OR nr=$b136 OR nr=$b137 OR nr=$b138 OR nr=$b139 OR nr=$b140 OR nr=$b141 OR nr=$b142 OR nr=$b143 OR nr=$b144 OR nr=$b145 OR nr=$b146 OR nr=$b147 OR nr=$b148 OR nr=$b149 OR nr=$b150;");
while ($ds = mysql_fetch_object($sql)){
$dat = $ds -> dat;
$ort = $ds -> ort;
$heim = $ds -> heim;
$gast = $ds -> gast;
$ee = $ds -> ee;
$he = $ds -> he;
$pkt = $ds -> pkt;
$tpl = $ds -> tpl;
$tmin = $ds -> tmin;
$nummer = $ds -> nr;
$art = $ds -> art;
$bem = $ds -> bem;
$bem2 = $ds -> bem2;
//----------------- Umwandlung von ee -------------------------
$t1 = substr($ee, 0, 2);
$t2 = substr($ee, 3, 2);
$t11 = substr($t1, 0, 1);
$t21 = substr($t2, 0, 1);
if ($t11 === "0"){
$t1 = substr($ee, 1, 1);
}
else {
$t1 = $t1;
}
if ($t21 === "0"){
$t2 = substr($ee, 4, 1);
}
else {
$t2 = $t2;
}
$ee = "$t1".":"."$t2";
//----------------- Umwandlung von he -------------------------
$u1 = substr($he, 0, 2);
$u2 = substr($he, 3, 2);
$u11 = substr($u1, 0, 1);
$u21 = substr($u2, 0, 1);
if ($u11 === "0"){
$u1 = substr($he, 1, 1);
}
else {
$u1 = $u1;
}
if ($u21 === "0"){
$u2 = substr($he, 4, 1);
}
else {
$u2 = $u2;
}
$he = "$u1".":"."$u2";
//............................................................
echo "
";
echo "| $nummer";
echo " | $dat";
echo " | $ort";
echo " | $heim";
echo " | $gast";
if ($pkt ==3) {
?>
| |
}
if ($pkt ==0) {
?>
|
}
if ($pkt ==1) {
?>
|
}
echo "$he";
if ($art == "WM_HF" or $art == "WM_F" or $art == "WM_PL") {
?>
| |
}
if ($art == "WM_VF" or $art == "WM_AF") {
?>
|
}
if ($art == "WM_VR" or $art == "WM_ZR") {
?>
|
}
if ($art == "WM-Q") {
?>
|
}
if ($art == "FS") {
?>
|
}
if ($art == "EM-Q") {
?>
|
}
if ($art == "EM_VR") {
?>
|
}
if ($art == "EM_AF" or $art == "EM_VF" or $art == "EM_HF") {
?>
|
}
if ($art == "EM_F") {
?>
|
}
if ($art == "OSP") {
?>
|
}
if ($art == "N.Tur" or $art == "Mini-WM" or $art == "Confed" or $art == "Confed VR" or $art == "Confed HF" or $art == "Confed PL" or $art == "US-Cup") {
?>
|
}
// --------------------------------------------------------------
switch ($bem) {
case "x":
echo "."; break;
case "":
echo " | ."; break;
default:
echo " | $bem";
}
for ($zx = 0; $zx < 68; $zx++){
if ($nummer === $t[$zx]){
?>
|  |
}
}
echo "";
if ($pkt ==3) {
$gew = $gew +1;
}
if ($pkt ==1) {
$un = $un +1;
}
if ($pkt ==0) {
$ver = $ver +1;
}
$z = $z+1;
$tp = $tp + $tpl;
$tm = $tm + $tmin;
$gp = $gp + $pkt;
}
$tp2 = $tp / 2;
$tm2 = $tm / 2;
$tore = "$tp2".":"."$tm2";
echo " |
";
?>
//---------------------------------------- datsp eingefuegt
$sql = mysql_query("SELECT * FROM datsp WHERE snr=$nrs");
while ($ds = mysql_fetch_object($sql)){
$gr = $ds -> gr;
$ma = $ds -> ma;
$to = $ds -> to;
}
// -------------------------------------------------------
//
$sql = mysql_query("SELECT * FROM spwmem WHERE nrsp=$nrs");
while ($ds = mysql_fetch_object($sql)){
$name = $ds -> name;
$nrsp = $ds -> nrsp;
$wf = $ds -> wf;
$wh = $ds -> wh;
$swm = $ds -> swm;
$ef = $ds -> ef;
$eh = $ds -> eh;
$sem = $ds -> sem;
}
//
mysql_close($dz);
?>