Gossamer Forum: Products: Gossamer Links: Discussions: Save guest reviewer IP address in database

Jun 16, 2008, 8:28 AM

mrrob

Novice (32 posts)

Jun 16, 2008, 8:28 AM

Post #1 of 4

Shortcut

Save guest reviewer IP address in database

Hello,

When someone submits a review, glinks sends me a nice email notification which includes the ip address (or Remote Host as it is labelled in the email) of the reviewer.

I would like to store this IP address in the Review database in the review record, so I have a permanent record should I need it.

Dos anybody have any ideas as to the easiest way to do this?

Many Thanks,

Rob

Jun 16, 2008, 12:05 PM

Andy

Veteran / Moderator (18441 posts)

Jun 16, 2008, 12:05 PM

Post #2 of 4

Shortcut

Re: [mrrob] Save guest reviewer IP address in database In reply to

Hi,

The simplest way, would be to do the following:

Database > Reviews > Properties > Add Field

..or the link below, replaced with the correct URL to your admin area =))

http://www.domain.com/cgi-bin/admin/admin.cgi?db=Reviews&do=editor_add_field_form

Add the field:

Column Name: RecordedIP
Column Type: CHAR
Column Size: 20
Not Null No
Default
Form Display: Recorded IP
Form Type: TEXT
Form Size: 10

Then, in review_add.html, find:

Code:
                    <input type="hidden" name="add_this_review" value="1">

..and add:

Code:
                    <input type="hidden" name="RecordedIP" value="<%get_their_ip%>">

..then add a new global called get_their_ip , with this code:

Code:
sub { return $ENV{REMOTE_ADDR}; }

Untested, but that should work fine Smile

Cheers

Andy (mod)
andy@ultranerds.co.uk

Jun 18, 2008, 3:16 AM

mrrob

Novice (32 posts)

Jun 18, 2008, 3:16 AM

Post #3 of 4

Shortcut

Re: [Andy] Save guest reviewer IP address in database In reply to

Thanks Andy - great solution as always,

My only concern is that a very smart visitor would be able to alter the data in the hidden form field and thereby falsify their IP address. For legal reasons, we need a more robust solution which visitors couldn't tamper with.

I noticed that IP addresses get stored in the ClickTrack table. To store IP addresses in the Reviews table without a hidden field, would a plugin be required?

If so, are you up for the job?

Best Regards,

Rob

Jun 18, 2008, 3:19 AM

Andy

Veteran / Moderator (18441 posts)

Jun 18, 2008, 3:19 AM

Post #4 of 4

Shortcut

Re: [mrrob] Save guest reviewer IP address in database In reply to

Hi,

Mm.. could be done with a plugin. Shoot me a PM if your interested in a custom job, and I'll have a look into other ways its possible :)

Cheers

Andy (mod)
andy@ultranerds.co.uk