From ea159a24b2dfbf05578e701f341c921280b2f810 Mon Sep 17 00:00:00 2001 From: Petr Baudis Date: Wed, 23 Jan 2008 03:08:15 +0100 Subject: [PATCH] OJD commit: Record author's IP address --- php/ojd_commit.php | 2 +- php/ojd_structure.sql | 4 +++- 2 files changed, 4 insertions(+), 2 deletions(-) diff --git a/php/ojd_commit.php b/php/ojd_commit.php index e91936c..1d6ae8c 100644 --- a/php/ojd_commit.php +++ b/php/ojd_commit.php @@ -32,7 +32,7 @@ $sgf_nodes = parse_simple_sgf($_REQUEST['sgf']); # 3. tree_node -if (!mysql_query("INSERT INTO tree_node_archive SET id = NULL")) { # id = NULL just to fulfill SQL syntax +if (!mysql_query("INSERT INTO tree_node_archive SET author = '".$_SERVER['REMOTE_ADDR']."'")) { die("Problem! " . mysql_error()); } $version = mysql_insert_id(); diff --git a/php/ojd_structure.sql b/php/ojd_structure.sql index 6d1b85f..d4ee098 100644 --- a/php/ojd_structure.sql +++ b/php/ojd_structure.sql @@ -10,7 +10,9 @@ DROP TABLE tree_node_archive; CREATE TABLE tree_node_archive ( - id INT AUTO_INCREMENT PRIMARY KEY + id INT AUTO_INCREMENT PRIMARY KEY, + + author VARCHAR(128) # Also IPv6 addresses and other junk! ) ENGINE=InnoDB; CREATE TABLE tree_node ( -- 2.11.4.GIT