“;<\/p>\n\t$sql = “select * from i_result where team_id = “.$cnt.” order by team_id,e_id,id;”;
\n\t$res = mysql_query($sql) or die(mysql_error());
\n\twhile($row = mysql_fetch_assoc($res)){<\/p>\n
\t\t\/\/\u9806\u4f4d\u7528\u96c6\u8a08
\n\t\t$goal[$cnt] = $goal[$cnt] + $row[goal];
\n\t\t$lost[$cnt] = $lost[$cnt] + $row[lost];<\/p>\n
\t\t\/\/ \u52dd\u3061\u70b9\u96c6\u8a08
\n\t if( $row[result] == 1 ){
\n\t\t\t$mark_text =”\u25cb”;
\n\t\t\t$point = 3;
\n\t\t\t$win[$cnt]++;
\n\t\t}
\n\t elseif( $row[result] == 2 ){
\n\t\t\t$mark_text =”\u25cf”;
\n\t\t\t$point = 0;
\n\t\t\t$lose[$cnt]++;
\n\t\t}
\n\t else{
\n\t\t\t$mark_text =”\u25b3”;
\n\t\t\t$point = 1;
\n\t\t\t$draw[$cnt]++;
\n\t\t}
\n\t\t$total_point[$cnt] = $total_point[$cnt] + $point;<\/p>\n
\t\t$list5 .= “<\/p>\n
“;
\n\t\t$list5 .= “<\/p>\n“.$team_name[$row[‘e_id’]].”<\/td>\n | “.$row[‘goal’].” – “.$row[‘lost’].”<\/td>\n | “.$mark_text.”<\/td>\n | “.$row[‘game_date’].”<\/td>\n “;
\n\t\t$list5 .= “<\/tr>\n “;
\n\t}
\n\t$list5 .= “<\/table>\n “;
\n\t$list5 .= “<\/p><\/div>\n “;
\n}<\/p>\n \/\/\u3000\u9806\u4f4d\u30c7\u30fc\u30bf\u767b\u9332
\nfor($num =1;$num<=3;$num++){\n\t$sql = \"update i_rank set point = \".$total_point[$num].\", goal = \".$goal[$num].\",lost = \".$lost[$num].\",sa = \".$goal[$num].\" - \".$lost[$num].\", win = \".$win[$num].\",lose = \".$lose[$num].\",draw = \".$draw[$num].\",last_date = NOW() WHERE team_id =\".$num;\n\t$res = mysql_query($sql) or die(mysql_error());\n}\n\n\/\/ \u9806\u4f4d\u8868\u4f5c\u6210\n$list0 .= \"\n\n “; \n$list0 .= “ \u30002002\u5e74\u7d44\u30ea\u30fc\u30b0\uff08U-10\uff09\u3000\u9806\u4f4d\u8868\u3000<\/h1>\n“;
\n$list0 .= “<\/p>\n “;
\n$list0 .= “<\/p>\n“;
\n$list0 .= “<\/p>\n\u30c1\u30fc\u30e0\u540d<\/td>\n “;
\n$list0 .= “<\/p>\n | \u52dd\u70b9<\/td>\n “;
\n$list0 .= “<\/p>\n | \u52dd<\/td>\n “;
\n$list0 .= “<\/p>\n | \u8ca0<\/td>\n “;
\n$list0 .= “<\/p>\n | \u5206<\/td>\n “;
\n$list0 .= “<\/p>\n | \u5f97<\/td>\n “;
\n$list0 .= “<\/p>\n | \u5931<\/td>\n “;
\n$list0 .= “<\/p>\n | \u5dee<\/td>\n “;
\n$list0 .= “<\/tr>\n “;<\/p>\n \/\/ \u9806\u4f4d\u30c7\u30fc\u30bf\u53d6\u5f97
\n$sql = “select * from i_rank order by POINT DESC , sa DESC , goal DESC “;
\n$res = mysql_query($sql) or die(mysql_error());
\nwhile($row = mysql_fetch_assoc($res)){
\n\t$list0 .= “<\/p>\n | “;
\n\t$list0 .= “<\/p>\n“.$team_name[$row[team_id]].”<\/td>\n | “.$row[point].”<\/td>\n “;
\n\t$list0 .= “<\/p>\n | “.$row[win].”<\/td>\n | “.$row[lose].”<\/td>\n | “.$row[draw].”<\/td>\n “;
\n\t$list0 .= “<\/p>\n | “.$row[goal].”<\/td>\n | “.$row[lost].”<\/td>\n | “.$row[sa].”<\/td>\n “;
\n\t$list0 .= “<\/tr>\n “;
\n}<\/p>\n $list0 .= “<\/table>\n<\/div>\n
\n“;<\/p>\n \/\/\u3000\u30ea\u30fc\u30b0\u30e1\u30f3\u30d0\u8868
\n$list2 .= “<\/p>\n “; \n$list2 .= “ \u30002002\u5e74\u7d44\u30ea\u30fc\u30b0\uff08U-10\uff09\u30e1\u30f3\u30d0\u8868\u3000<\/h1>\n“;
\n$list2 .= “<\/p>\n “;
\n$list2 .= “<\/p>\n“;
\n$list2 .= “<\/p>\n\u30c1\u30fc\u30e0\u540d<\/td>\n “;
\n$list2 .= “<\/p>\n | \u30e1\u30f3\u30d0<\/td>\n “;
\n$list2 .= “<\/tr>\n “;
\n\/\/ Team A
\n$list2 .= “<\/p>\n | “;
\n$list2 .= “<\/p>\n“.$team_name[1].”<\/td>\n “;
\n$list2 .= “<\/p>\n | \u30e4\u30de\u30c8 \u30fb \u30c8\u30e2\u30e4 \u30fb \u30cf\u30e4\u30c8 \u30fb \u30cf\u30eb\u30c8 \u30fb \u30b7\u30e7\u30a6 \u30fb \u30a2\u30aa\u30c8<\/td>\n “;
\n$list2 .= “<\/tr>\n “;
\n\/\/ Team B
\n$list2 .= “<\/p>\n | “;
\n$list2 .= “<\/p>\n“.$team_name[2].”<\/td>\n “;
\n$list2 .= “<\/p>\n | \u30d2\u30ab\u30eb \u30fb \u30b1\u30f3\u30bf\u30ed\u30a6 \u30fb\u30c0\u30a4\u30ad \u30fb \u30bf\u30c4\u30ad \u30fb\u30c1\u30b5\u30c8 \u30fb \u30ea\u30e7\u30a6\u30de \u30fb \u30e6\u30a6\u30de<\/td>\n “;
\n$list2 .= “<\/tr>\n “;
\n\/\/ Team C
\n$list2 .= “<\/p>\n | “;
\n$list2 .= “<\/p>\n“.$team_name[3].”<\/td>\n “;
\n$list2 .= “<\/p>\n | \u30ca\u30aa\u30ad \u30fb \u30a2\u30ad\u30ce\u30ea \u30fb \u30b3\u30a6\u30ad \u30fb\u30b3\u30a6\u30c1\u30e3\u30f3 \u30fb \u30ec\u30f3 \u30fb \u30e6\u30a6\u30ca \u30fb \u30b7\u30e5\u30f3\u30b9\u30b1<\/td>\n “;
\n$list2 .= “<\/tr>\n “;
\n$list2 .= “<\/table>\n<\/div>\n
\n“;<\/p>\n $list10 .= “<\/center>“;<\/p>\n echo $list0;
\necho $list2;
\necho $list5;
\necho $list10;<\/p>\n ?><\/p>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"open","template":"","meta":[],"_links":{"self":[{"href":"http:\/\/inage.happystamp.jp\/index.php?rest_route=\/wp\/v2\/pages\/995"}],"collection":[{"href":"http:\/\/inage.happystamp.jp\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"http:\/\/inage.happystamp.jp\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"http:\/\/inage.happystamp.jp\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/inage.happystamp.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=995"}],"version-history":[{"count":49,"href":"http:\/\/inage.happystamp.jp\/index.php?rest_route=\/wp\/v2\/pages\/995\/revisions"}],"predecessor-version":[{"id":1450,"href":"http:\/\/inage.happystamp.jp\/index.php?rest_route=\/wp\/v2\/pages\/995\/revisions\/1450"}],"wp:attachment":[{"href":"http:\/\/inage.happystamp.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=995"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}} | | |