2 files changed, 3 insertions, 3 deletions
diff --git a/pages/admin.php b/pages/admin.php
index fda03c3..12a2d01 100755
--- a/pages/admin.php
+++ b/pages/admin.php

@@ -563,7 +563,7 @@ if (isLoggedIn())
                                        $insanon = "INSERT INTO anon_commenters (username,email,website) VALUES (\"" . $getcomment3['author'] . "\",\"" . $getcomment3['email'] . "\",\"" . $getcomment3['website'] . "\")";
                                        $insanon2 = mysql_query($insanon);
-                                        $inscomment = "INSERT INTO comments (page_id,username,comment,is_anon) VALUES (\"" . $getcomment3['page_id'] . "\",\"" . $getcomment3['author'] . "\",\"" . $getcomment3['comment'] . "\",1)";
+                                        $inscomment = "INSERT INTO comments (page_id,user_id,comment,is_anon) VALUES (\"" . $getcomment3['page_id'] . "\"," . mysql_insert_id() . ",\"" . $getcomment3['comment'] . "\",1)";
                                        $inscomment2 = mysql_query($inscomment);
                                        $delcomment = "DELETE FROM moderation WHERE id = " . $getcomment3['id'];
diff --git a/pages/post.php b/pages/post.php
index 7d6dd08..87413e8 100755
--- a/pages/post.php
+++ b/pages/post.php

@@ -56,7 +56,7 @@ if (!isset($_GET['id']))
                                        {
                                                if ($getanon3['email'] == $_POST['email'])
                                                {
-                                                        $setcomment = "INSERT INTO comments SET page_id = \"" . $_GET['id'] . "\", username = \"" . $_POST['username'] . "\", comment = \"" . $_POST['comment'] . "\", is_anon = 1";
+                                                        $setcomment = "INSERT INTO comments SET page_id = \"" . $_GET['id'] . "\", user_id = " . $getanon3['id'] . ", comment = \"" . $_POST['comment'] . "\", is_anon = 1";
                                                        $setcomment2 = mysql_query($setcomment);
                                                        $page_id = $_GET['id'];
@@ -84,7 +84,7 @@ if (!isset($_GET['id']))
                                }
                        }
                } else {
-                        $setcomment = "INSERT INTO comments SET page_id = \"" . $_GET['id'] . "\", username = \"" . getSessionUsername() . "\", comment = \"" . $_POST['comment'] . "\", is_anon = 0";
+                        $setcomment = "INSERT INTO comments SET page_id = \"" . $_GET['id'] . "\", user_id = " . getSessionUserID() . ", comment = \"" . $_POST['comment'] . "\", is_anon = 0";
                        $setcomment2 = mysql_query($setcomment);
                        mail('hatkirby@fourisland.com', 'New comment on Four Island!', getSessionUsername() . ' has posted a comment on Four Island under the "page id" ' . $_GET['id']);

diff --git a/pages/admin.php b/pages/admin.php index fda03c3..12a2d01 100755 --- a/pages/admin.php +++ b/pages/admin.php
@@ -563,7 +563,7 @@ if (isLoggedIn())
563	$insanon = "INSERT INTO anon_commenters (username,email,website) VALUES (\"" . $getcomment3['author'] . "\",\"" . $getcomment3['email'] . "\",\"" . $getcomment3['website'] . "\")";	563	$insanon = "INSERT INTO anon_commenters (username,email,website) VALUES (\"" . $getcomment3['author'] . "\",\"" . $getcomment3['email'] . "\",\"" . $getcomment3['website'] . "\")";
564	$insanon2 = mysql_query($insanon);	564	$insanon2 = mysql_query($insanon);
565		565
566	$inscomment = "INSERT INTO comments (page_id,username,comment,is_anon) VALUES (\"" . $getcomment3['page_id'] . "\",\"" . $getcomment3['author'] . "\",\"" . $getcomment3['comment'] . "\",1)";	566	$inscomment = "INSERT INTO comments (page_id,user_id,comment,is_anon) VALUES (\"" . $getcomment3['page_id'] . "\"," . mysql_insert_id() . ",\"" . $getcomment3['comment'] . "\",1)";
567	$inscomment2 = mysql_query($inscomment);	567	$inscomment2 = mysql_query($inscomment);
568		568
569	$delcomment = "DELETE FROM moderation WHERE id = " . $getcomment3['id'];	569	$delcomment = "DELETE FROM moderation WHERE id = " . $getcomment3['id'];


diff --git a/pages/post.php b/pages/post.php index 7d6dd08..87413e8 100755 --- a/pages/post.php +++ b/pages/post.php
@@ -56,7 +56,7 @@ if (!isset($_GET['id']))
56	{	56	{
57	if ($getanon3['email'] == $_POST['email'])	57	if ($getanon3['email'] == $_POST['email'])
58	{	58	{
59	$setcomment = "INSERT INTO comments SET page_id = \"" . $_GET['id'] . "\", username = \"" . $_POST['username'] . "\", comment = \"" . $_POST['comment'] . "\", is_anon = 1";	59	$setcomment = "INSERT INTO comments SET page_id = \"" . $_GET['id'] . "\", user_id = " . $getanon3['id'] . ", comment = \"" . $_POST['comment'] . "\", is_anon = 1";
60	$setcomment2 = mysql_query($setcomment);	60	$setcomment2 = mysql_query($setcomment);
61		61
62	$page_id = $_GET['id'];	62	$page_id = $_GET['id'];
@@ -84,7 +84,7 @@ if (!isset($_GET['id']))
84	}	84	}
85	}	85	}
86	} else {	86	} else {
87	$setcomment = "INSERT INTO comments SET page_id = \"" . $_GET['id'] . "\", username = \"" . getSessionUsername() . "\", comment = \"" . $_POST['comment'] . "\", is_anon = 0";	87	$setcomment = "INSERT INTO comments SET page_id = \"" . $_GET['id'] . "\", user_id = " . getSessionUserID() . ", comment = \"" . $_POST['comment'] . "\", is_anon = 0";
88	$setcomment2 = mysql_query($setcomment);	88	$setcomment2 = mysql_query($setcomment);
89		89
90	mail('hatkirby@fourisland.com', 'New comment on Four Island!', getSessionUsername() . ' has posted a comment on Four Island under the "page id" ' . $_GET['id']);	90	mail('hatkirby@fourisland.com', 'New comment on Four Island!', getSessionUsername() . ' has posted a comment on Four Island under the "page id" ' . $_GET['id']);