From 4090438d13bc543d09f2d2ffeabb56d82213cada Mon Sep 17 00:00:00 2001 From: David Bernard Date: Sun, 11 Feb 2018 15:24:03 -0500 Subject: Fix CTF import and player profile for non-team matches. --- html/import/import_playerstuff.php | 4 ++++ html/pages/admin/check.php | 4 ++-- 2 files changed, 6 insertions(+), 2 deletions(-) mode change 100755 => 100644 html/import/import_playerstuff.php mode change 100755 => 100644 html/pages/admin/check.php diff --git a/html/import/import_playerstuff.php b/html/import/import_playerstuff.php old mode 100755 new mode 100644 index 73714e4..cf80b25 --- a/html/import/import_playerstuff.php +++ b/html/import/import_playerstuff.php @@ -130,6 +130,10 @@ $r_ttl = get_dp($q_ttl[col4]); $r_score = $q_score[col4]; + if (!$playerteam) { + $playerteam = 0; + } + // Generate player record $sql_playerid = " INSERT INTO uts_player diff --git a/html/pages/admin/check.php b/html/pages/admin/check.php old mode 100755 new mode 100644 index 938d036..125a282 --- a/html/pages/admin/check.php +++ b/html/pages/admin/check.php @@ -304,10 +304,10 @@ CREATE TABLE `uts_chartdata` ( `id` int(11) NOT NULL AUTO_INCREMENT, `mid` int(11) NOT NULL, `chartid` mediumint(9) NOT NULL, - `title` varchar(50) NOT NULL, + `title` varchar(50) DEFAULT NULL, `data` blob NOT NULL, `labels` blob NOT NULL, - `categories` blob NOT NULL, + `categories` blob, PRIMARY KEY (`id`), KEY `mid` (`mid`), KEY `mid_2` (`mid`) -- cgit