games_players.php

<?php
    $row[0] = isset($_GET['game_ID']) ? $_GET['game_ID'] : time();
    $row[1] = isset($_GET['player_ID']) ? $_GET['player_ID'] : 0;
    $row[2] = isset($_GET['acc_ID']) ? $_GET['acc_ID'] : rand(0,9999);
    $row[3] = '---';
    $row[4] = isset($_GET['time']) ? $_GET['time'] : 0;
    $row[5] = isset($_GET['status']) ? $_GET['status'] : 0;
    $row[6] = isset($_GET['IP']) ? $_GET['IP'] : 'unknown';
    $row[7] = isset($_GET['Hero']) ? $_GET['Hero'] : '';
    $row[8] = isset($_GET['K']) ? $_GET['K'] : 0;
    $row[9] = isset($_GET['D']) ? $_GET['D'] : 0;
    $row[10] = isset($_GET['A']) ? $_GET['A'] : 0;
    $row[11] = isset($_GET['CK']) ? $_GET['CK'] : 0;
    $row[12] = isset($_GET['CD']) ? $_GET['CD'] : 0;
    $row[13] = isset($_GET['NK']) ? $_GET['NK'] : 0;
    $row[14] = isset($_GET['item1']) ? $_GET['item1'] : '';
    $row[15] = isset($_GET['item2']) ? $_GET['item2'] : '';
    $row[16] = isset($_GET['item3']) ? $_GET['item3'] : '';
    $row[17] = isset($_GET['item4']) ? $_GET['item4'] : '';
    $row[18] = isset($_GET['item5']) ? $_GET['item5'] : '';
    $row[19] = isset($_GET['item6']) ? $_GET['item6'] : '';
    $row[20] = isset($_GET['LeftReason']) ? $_GET['LeftReason'] : 'unknown';

    require 'connection.php' ;
    $query = mysql_query("INSERT INTO DB_game_players VALUES($row[0], $row[1], $row[2], '$row[3]', $row[4], '$row[5]', '$row[20]', '$row[6]', '$row[7]', $row[8], $row[9],$row[10], $row[11], $row[12], $row[13], '$row[14]', '$row[15]', '$row[16]', '$row[17]', '$row[18]', '$row[19]')");

        if (!$query){
            $fh = fopen('error_log.txt', 'a') or die("can't open file");
            fwrite($fh,"[".date('H:m:s d/m/y',time())."][Game #$row[0]][Player: #$row[1]]".mysql_error()."\n");
            fclose($fh);
        }


?>