Changeset 1854 in ExiteCMS

Timestamp:

10/16/08 11:56:20 (3 years ago)

Author:

hverton

Message:

added the user country code to the post record when inserting a message

File:

• modules/common/mail2forum/php-files/modules/mail2forum/m2f_pop3.php (modified) (2 diffs)

modules/common/mail2forum/php-files/modules/mail2forum/m2f_pop3.php

@@ -42 +42 @@
 // include for image manipulation functions
 require_once PATH_INCLUDES."photo_functions_include.php";
+
+// need the GeoIP functions to determine the mailers country of origin
+require_once PATH_INCLUDES."geoip_include.php";
 
 // include the PEAR POP3 and MIME decode class
@@ -260 +263 @@
     }
 
+    // determine the country code for the senders mail server
+    $sender_cc = GeoIP_IP2Code($post['received']['ip']);
+    if (!$sender_cc) $sender_cc = "";
+
     // insert the new message into the posts table
-    $sql = "INSERT INTO ".$db_prefix."posts (forum_id, thread_id, post_subject, post_message, post_showsig, post_smileys, post_author, post_datestamp, post_ip, post_edituser, post_edittime) 
-        VALUES ('$forum_id', '$thread_id', '".mysql_escape_string($subject)."', '".mysql_escape_string($post['body'])."', '1', '1', '".$sender['user_id']."', '$posttime', '".$post['received']['ip']."', '0', '0')";
+    $sql = "INSERT INTO ".$db_prefix."posts (forum_id, thread_id, post_subject, post_message, post_showsig, post_smileys, post_author, post_datestamp, post_ip, post_user_cc, post_edituser, post_edittime) 
+        VALUES ('$forum_id', '$thread_id', '".mysql_escape_string($subject)."', '".mysql_escape_string($post['body'])."', '1', '1', '".$sender['user_id']."', '$posttime', '".$post['received']['ip']."', '$sender_cc', '0', '0')";
     $result = dbquery($sql);
     if (!$result) {