Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
 All Forums
 Snitz Forums 2000 MOD-Group
 MOD Add-On Forum (W/Code)
 Find Duplicate Members

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!
Before posting, make sure you have read this topic!

Screensize:
UserName:
Password:
Format Mode:
Format: BoldItalicizedUnderlineStrikethrough Align LeftCenteredAlign Right Horizontal Rule Insert HyperlinkInsert EmailInsert Image Insert CodeInsert QuoteInsert List
   
Message:

* HTML is OFF
* Forum Code is ON
Smilies
Smile [:)] Big Smile [:D] Cool [8D] Blush [:I]
Tongue [:P] Evil [):] Wink [;)] Clown [:o)]
Black Eye [B)] Eight Ball [8] Frown [:(] Shy [8)]
Shocked [:0] Angry [:(!] Dead [xx(] Sleepy [|)]
Kisses [:X] Approve [^] Disapprove [V] Question [?]

 
Check here to subscribe to this topic.
   

T O P I C    R E V I E W
garyrobar Posted - 16 December 2008 : 11:37:04
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.

<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>


<
15   L A T E S T    R E P L I E S    (Newest First)
garyrobar Posted - 18 June 2009 : 07:47:38
show me the SQL code you are using...I'll fix and send back...
Giumer Posted - 22 May 2009 : 11:09:18
hi mate plz i ,am have 3 accaunts and me forum and ip is equal but if I go to see it doesn't visualize them to me it tells only me the total one of the ips, my database and in MSQL. me look only this

Find Duplicate Member IP Addresses:

This table shows the contents of the IP Address in the user profiles that are duplicates.

Member ID Posts Member Name IP Address Email

There are a total of 26 IP Addresses found in the Database.

thx for help
MikeB.Lynn Posted - 16 April 2009 : 08:04:11
Never mind I just got it. Sorry
MikeB.Lynn Posted - 16 April 2009 : 07:32:05
When I use the path to my db file:
gfn.Open[/forum/fpdb/snitz_forums_2000.mdb]

I get this:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

/forum/testdupmem.asp, line 18
HuwR Posted - 16 April 2009 : 02:35:30
that bit of code should be on two line

dim gfn, grs, gSQL
Set gfn

recheck your code against what was posted in the topic
MikeB.Lynn Posted - 16 April 2009 : 00:26:02
I get this:

Microsoft VBScript compilation error '800a0401'

Expected end of statement

/testdupmem.asp, line 4

dim gfn, grs, gSQLSet gfn
-------------------------^
garyrobar Posted - 10 April 2009 : 11:13:49
yup, that would be totally possible. You could hard-code, or add a table to the database.
bobby131313 Posted - 17 January 2009 : 20:36:49
This page is awesome!

I'm wondering though if there's maybe a bit of code that could be added to exclude a list of IP's from being included on the page. AOL proxies for example. It would remove a good bit of clutter from mine for sure.<
PackYakcouk Posted - 01 January 2009 : 11:32:02
Oh brilliant!

thanks for that, i thought it was going to list EVERY member then highlight the duplicates

ta!<
AnonJr Posted - 01 January 2009 : 10:50:09
Unless I missed something, its only going to show duplicates. I would guess that you don't have any members that it considers duplicates.<
PackYakcouk Posted - 01 January 2009 : 09:17:34
I have just added Classicmotorcycling's code to my forum and have linked it to admin_home.asp.

When i login click admin options and launch the page all i see is the below



isnt it suposed to list all members and point out duplicates? or have i missed something ?<
Giumer Posted - 30 December 2008 : 07:10:05
ok thx nly for info yuo have problem for Image ? tis mods not is for Image , np<
HuwR Posted - 30 December 2008 : 06:04:36
we do not offer assistance with anything relating to Images forums, MODs or other wise, sorry, but if you have a problem then take it up with image.<
Giumer Posted - 30 December 2008 : 06:02:43
sorry mate , this mods not is for Image , i'am include this file and me forum , and have this problem , and sorry for me english , and sorry for post ! np , delete this post and thx !<
HuwR Posted - 30 December 2008 : 04:18:49
quote:
me forum is Image and is www.giumer.it
Then go to image for help.<

Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.04 seconds. Powered By: Snitz Forums 2000 Version 3.4.07