Welcome to Geeklog Monday, November 20 2017 @ 07:41 pm EST


JapioF

Anonymous
caffeinated

Here how you can make your comments track the IP of the poster (I couldn't find a topic for this, so I'm posting it here).

Create a new field in your gl_comments table called ip with the following setings: varchar(20), NULL default=0.0.0.0

Next, open your comments.php in ./public_html and find change to following code:

PHP Formatted Code
DB_save ($_TABLES['comments'], 'sid,uid,comment,date,title,pid,type', "'$sid',$uid,'$comment',now(),'$title',$pid,'$type'")
 


into:

PHP Formatted Code
DB_save ($_TABLES['comments'], 'sid,uid,comment,date,title,pid,type,ip', "'$sid',$uid,'$comment',now(),'$title',$pid,'$type','$ip'");
 


For now, it just saves the code into the table. It doesn't show when viewing a comment, I'm still working on that. I know that the Visitor Stats pluging does a similar thing, but I didn't have that installed at the time.

Use PhpMyAdmin to view the stored IP per comment.

Good luck,

JapioF

Status: offline

Dirk

Site Admin
Admin
Registered: 12/01/2002
Posts: 13073
Location:Stuttgart, Germany
You could, of course, simply upgrade to 1.3.11 which has all that built in ...

bye, Dirk

JapioF

Anonymous
caffeinated
Dirk, ofcourse I could... but what's the fun in that
This is much more fun...

JapioF

All times are EST. The time is now 07:41 pm.

  • Normal Topic
  • Sticky Topic
  • Locked Topic
  • New Post
  • Sticky Topic W/ New Post
  • Locked Topic W/ New Post
  •  View Anonymous Posts
  •  Able to post
  •  Filtered HTML Allowed
  •  Censored Content