Comment insert to include IP Address

[urbn]

I run a site where 90% of comments / stories are by anonymous posts. Recently we have been having people from other sites spamming comments on the boards.

I have setup story submissions to include the IP address of the user ( by adding $linkres->link_field1 = $_SERVER['REMOTE_ADDR']; to the submit.php page) but I can't seem to find the page or query that handles the comment submissions.

Can anyone point me in the right direction to which page, class or function I will need to edit to include the IP Address to the comment insert query?

Also from what I have read registered user submissions are handled different then anonymous submissions, is this correct?

[urbn]

Well I found a simple fix / hack for this.

I guess since user accounts track the IP address within the user table the only need is to track anonymous posters IP's.

To track the IP address of anonymous comment posts you can do the following:
*Note this assumes the anonymous comments module is in use.


Create a new field in your comments table:
ipaddress, varchar 17


Open /modules/anonymous_comments/anonymous_comments_main.php

FIND:

$sql = "INSERT INTO " . table_comments . " (comment_user_id, comment_link_id, comment_date, comment_randkey, comment_content,`comment_anonymous_username`, `comment_anonymous_email`, `comment_anonymous_website` ) VALUES ($user_id, $link_id, NOW(), $randkey, '$comment_content', '$a_username','$a_email', '$a_website')";


REPLACE WITH:

$a_ipaddress = $_SERVER['REMOTE_ADDR'];

$sql = "INSERT INTO " . table_comments . " (comment_user_id, comment_link_id, comment_date, comment_randkey, comment_content,`comment_anonymous_username`, `comment_anonymous_email`, `comment_anonymous_website`,ipaddress ) VALUES ($user_id, $link_id, NOW(), $randkey, '$comment_content', '$a_username','$a_email', '$a_website', '$a_ipaddress')";



What this does:
All this will do is update the SQL insert string to include adding the ipaddress record with the $a_ipaddress value which is the value the server picks up for the users IP address.


With this information you can run queries to find all matching IP Addresses and delete all the spam for a specific IP, or find the IP used by a poster to ban by IP.

[key_key]

very good answer, congratulations

[foofoo]

This maybe it.

See this post from me http://forums.pligg.com/questions-co...-geo-flag.html

How could 1 use $_SERVER['REMOTE_ADDR'] to fetch the anonymous users ip for a country code flag?

[JagenganiDymn]

îôôòîï: ìîäåðû, à ìîæíî êàê íèòü ïåðåïîñò ñåáå âêîíòèê ñäåëàòü? íå âèæó êíîïîê, îáû÷íî âíèçó îíè

[PedroFunhe]

just a test, admin, del this message