The Forum has been Updated
The code has been upgraded to the latest .NET core version. Please check instructions in the Community Announcements about migrating your account.
Wrote a quick script to more easily point out duplicate posters (BY IP ADDRESS)
Just replace part with your own conn string, and your own url...(in caps lock below) This is meant to be saved as it's own page.
You get a print out of any members with an IP address that another member also has. It orders by IP address, so you can easily see what members are creating mults.
I typically delete the duplicates that have no posts. Sometime I'll move all posts under the oldest account for the same person.
<
Just replace part with your own conn string, and your own url...(in caps lock below) This is meant to be saved as it's own page.
You get a print out of any members with an IP address that another member also has. It orders by IP address, so you can easily see what members are creating mults.
I typically delete the duplicates that have no posts. Sometime I'll move all posts under the oldest account for the same person.
Code:
<table border-collapse="separate" style="border:1px solid #D8D8D8;" cellpadding="9" cellspacing="1">
<tr>
<td valign="top" class="border" align="left">
<div class="title" style="text-align: left;">Find Duplicate Member Profiles</div>
<p>This table shows the contents of the url fields in the user profiles.</p>
<table cellpadding="3" class="stattable" style="border-collapse: collapse;">
<tr bgcolor="#e0e0e0">
<td align="center">Member ID</td>
<td align="center">Posts</td>
<td align="center">Member Name</td>
<td align="center">IP Address</td>
<td align="center">Email</td>
</tr>
<%
dim gfn, grs, gSQL
Set gfn = Server.CreateObject("ADODB.Connection")
gfn.Open [#########YOUR CONN STRING#########]
Set grs = Server.CreateObject("ADODB.RecordSet")
gSQL = "select member_id, m_posts, m_name, m_ip, m_email from forum_members order by m_ip"
grs.Open gSQL, gfn, adOpenStatic
if grs.eof then
response.write "<tr><td> -na- </td><td>0</td><td>0</td></tr>"
else
thisloop = "5555555555"
lastloop = "8888888888"
do while not grs.eof
i=i+1
lastloop = currentloop
currentloop = grs("m_ip")
outputlast = output
'put current row in the variable
output = "<tr><td><a target=""_new"" href=""http://www.YOURURL.TLD/forum/pop_profile.asp?mode=display&id=" & grs("member_id") & """>" & grs("member_id") & "</a></td><td>" & grs("m_posts") & "</td><td>" & grs("m_name") & "</td><td>" & grs("m_ip") & "</td><td>" & grs("m_email") & "</td></tr>"
if currentloop = lastloop then
if flag = 1 then '---is a subsequent - so only print curr row
response.write output
else
response.write outputlast
response.write output
end if
flag = 1
else
flag = 0
end if
grs.movenext
loop
end if
grs.Close
Set grs = Nothing
gfn.Close
Set gfn= Nothing
Set gSQL = Nothing
%>
</table>
<%
response.write "<p>There were " & i & " total duplicates found in the table.</p>"
%>
</td>
</tr>
</table>
<
Postet den
Hi Gary,
Thanks for the code!
Hey, Just a quick question ... have you ever encountered multiple IP Addresses per member before?
I've seen it before where the m_ip field would look like this for example (replace the 0's with real numbers):
000.000.000.000, 000.000.000.000
<
Thanks for the code!
Hey, Just a quick question ... have you ever encountered multiple IP Addresses per member before?
I've seen it before where the m_ip field would look like this for example (replace the 0's with real numbers):
000.000.000.000, 000.000.000.000
<
Postet den
let me have a quick look....<
Postet den
this is quite common, and is related to proxy servers. there is a mod/fix about that sorts it out<
Postet den
and by the way, just because more than one member shares an ip address does not mean they are a duplicate poster or even the same person for that matter<
Postet den
You've got to be careful when using just the IP. If multiple members are in the same college dorm they could appear to have the same IP. Even the e-mail address may be different as I've had a couple double-entrants with different IPs and different e-mails - the rest of the profile was the same and in their post they mentioned that they were the same person.
Having said that, it looks like you've got that reasonably well in hand by linking to the profile page.
As a side note, if you put your code in the [ scrollcode ] tags (sans spaces) it will make it a little easier on the eyes and keep people from having to scroll the page to read replies.
<
Having said that, it looks like you've got that reasonably well in hand by linking to the profile page.
As a side note, if you put your code in the [ scrollcode ] tags (sans spaces) it will make it a little easier on the eyes and keep people from having to scroll the page to read replies.
<