{Request} A list of all active accounts registered in 2011.

italianMiner72

hero member

Activity: 910

Merit: 511

Quote from: ~DefaultTrust on January 21, 2020, 11:59:35 AM

Quote from: italianMiner72 on January 21, 2020, 10:51:19 AM

Quote from: ~DefaultTrust on January 17, 2020, 05:50:54 AM

Quote from: italianMiner72 on January 17, 2020, 01:44:45 AM

Hi mate!
If code is open source, plz updare on github or something like dropbox/Google drive.
Thank you

Hi!

No it's not open source but i can share database file (in sqlite format).

sorry, but i'm not interested at the data :-)
can i pm you?
thank you.

Yes you can.

Done!
Thank you!

~DefaultTrust

copper member

Activity: 1554

Merit: 489

Stop the war!

Quote from: italianMiner72 on January 21, 2020, 10:51:19 AM

Quote from: ~DefaultTrust on January 17, 2020, 05:50:54 AM

Quote from: italianMiner72 on January 17, 2020, 01:44:45 AM

Hi mate!
If code is open source, plz updare on github or something like dropbox/Google drive.
Thank you

Hi!

No it's not open source but i can share database file (in sqlite format).

sorry, but i'm not interested at the data :-)
can i pm you?
thank you.

Yes you can.

italianMiner72

hero member

Activity: 910

Merit: 511

Quote from: ~DefaultTrust on January 17, 2020, 05:50:54 AM

Quote from: italianMiner72 on January 17, 2020, 01:44:45 AM

Hi mate!
If code is open source, plz updare on github or something like dropbox/Google drive.
Thank you

Hi!

No it's not open source but i can share database file (in sqlite format).

sorry, but i'm not interested at the data :-)
can i pm you?
thank you.

Phinnaeus Gage

legendary

Activity: 1918

Merit: 1570

Bitcoin: An Idea Worth Spending

Quote from: TheBeardedBaby on January 15, 2020, 04:03:50 AM

I don't know if this is possible but I would like to get a list of all the accounts active in the past 120 days which were registered back in 2011.
Just tagged one, and I have seen some before.
Can be a Google spredsheet list as well, easier to work with data that way.

me

https://bitcointalksearch.org/user/phinnaeus-gage-24792

TheBeardedBaby

legendary

Activity: 2240

Merit: 3150

₿uy / $ell ..oeleo ;(

Quote from: qwk on January 17, 2020, 12:26:20 PM

Quote from: TheBeardedBaby on January 15, 2020, 04:03:50 AM

I would like to get a list of all the accounts active in the past 120 days which were registered back in 2011.

Well, you've already got that list, but here's one more thought:
you should devise a way to sieve out the hacked accounts.

Sure, if there are not enough evidence like this, i won't tag them.

qwk

donator

Activity: 3542

Merit: 3413

Shitcoin Minimalist

Quote from: TheBeardedBaby on January 15, 2020, 04:03:50 AM

I would like to get a list of all the accounts active in the past 120 days which were registered back in 2011.

Well, you've already got that list, but here's one more thought:
you should devise a way to sieve out the hacked accounts.

hosseinimr93

legendary

Activity: 2380

Merit: 5213

Only 1075 out of 45699 accounts have become online since October 01, 2019
Click the link below to see the list.

Full list of accounts that have been created in 2011 and have been online at least one time since October 01, 2019

~DefaultTrust

copper member

Activity: 1554

Merit: 489

Stop the war!

Quote from: italianMiner72 on January 17, 2020, 01:44:45 AM

Hi mate!
If code is open source, plz updare on github or something like dropbox/Google drive.
Thank you

Hi!

No it's not open source but i can share database file (in sqlite format).

italianMiner72

hero member

Activity: 910

Merit: 511

Quote from: ~DefaultTrust on January 16, 2020, 02:27:13 PM

I have parsed 2009-2012 registrations and continue parsing now. You can choose any range of dates, sort by Posts, Activity, Merit etc. More info here: https://bitcointalksearch.org/topic/ann-all-bitcointalk-users-table-project-5218103

Hi mate!
If code is open source, plz updare on github or something like dropbox/Google drive.
Thank you

~DefaultTrust

copper member

Activity: 1554

Merit: 489

Stop the war!

I have parsed 2009-2012 registrations and continue parsing now. You can choose any range of dates, sort by Posts, Activity, Merit etc. More info here: https://bitcointalksearch.org/topic/ann-all-bitcointalk-users-table-project-5218103

TheBeardedBaby

legendary

Activity: 2240

Merit: 3150

₿uy / $ell ..oeleo ;(

Thank you guys. I'll start with the list from 2011 that was posted above then I'll check the 2009/2010 list.
Any help is appriciated. There will be no Witch Hunting for sure. If I see a solid evidence I'll tag the account. I don't really like to destroy accounts, especially created back in the begining of all this,really.
The results will be posted on my Club thread.

hosseinimr93

legendary

Activity: 2380

Merit: 5213

I wrote code to scrap the profiles. But it takes a very long time. As accounts registered in 2009 and 2010 were much lower than 2011, I decided to run it for 2009 and 2010. It might be helpful. There might be some stolen or sold accounts among them too.
There were totally 3127 accounts registered before January 01, 2011.
There were only 85 profiles that have been online at least one time since October 01, 2019.

The list is available in the following sheet.

List of users who have registered in 2009 or 2010 and have been online at least one time since October 01, 2019

~DefaultTrust

copper member

Activity: 1554

Merit: 489

Stop the war!

I also tried to write a forum parser. Here is my result http://18.217.51.255/ It is parsed about 15000 users and still working now.
If admin is against, I will stop the script.

LoyceMobile

hero member

Activity: 1659

Merit: 687

LoyceV on the road. Or couch.

Quote from: unsoindovo on January 15, 2020, 02:23:28 PM

Hum. I tried to scrape data from bitcointalk months ago, but I haven't found the trick to avoid cloud flare protection.
How do you skip that?

I don't do anything, it just works.

unsoindovo

legendary

Activity: 1932

Merit: 1042

https://locktrip.com/?refId=40964

Quote from: LoyceMobile on January 15, 2020, 11:53:08 AM

Quote from: Rizzrack on January 15, 2020, 11:41:30 AM

As logfiles also mentioned: http://loyce.club/active/7d.html + REGEX magic

I've removed the https to make the link work.

I can get you full data by scraping all profiles, but using my deleted posts viewer is faster.

Hum. I tried to scrape data from bitcointalk months ago, but I haven't found the trick to avoid cloud flare protection.
How do you skip that?

LoyceV

legendary

Activity: 3290

Merit: 16489

Thick-Skinned Gang Leader and Golden Feather 2021

Quote from: Rizzrack on January 15, 2020, 12:22:52 PM

Quote from: LoyceMobile on January 15, 2020, 11:53:08 AM

I've removed the https to make the link work.

No SSL for Top 3 search engine on bitcointalk ? Cry

OK then, edited previous post

No, I'm not really worried about a man in the middle attack on this data.

Quote from: logfiles on January 15, 2020, 08:37:48 AM

So looking at http://loyce.club/archive/members, we shall be able to get accounts that were registered at a given period of time but are still active or were at least active from the time LoyceV started archiving posts.

My data started less than 7 months ago. I didn't even think about using this, so thanks

There's one flaw though: this only includes users who made a post, not the accounts that only changed their password to activate later. I can scrape all 2011 profiles if iasenko wants it (it'll take a day).

Rizzrack

copper member

Activity: 784

Merit: 710

Defend Bitcoin and its PoW: bitcoincleanup.com

Quote from: LoyceMobile on January 15, 2020, 11:53:08 AM

I've removed the https to make the link work.

No SSL for Top 3 search engine on bitcointalk ? Cry

OK then, edited previous post

LoyceMobile

hero member

Activity: 1659

Merit: 687

LoyceV on the road. Or couch.

Quote from: Rizzrack on January 15, 2020, 11:41:30 AM

As logfiles also mentioned: http://loyce.club/active/7d.html + REGEX magic

I've removed the https to make the link work.

I can get you full data by scraping all profiles, but using my deleted posts viewer is faster.

Rizzrack

copper member

Activity: 784

Merit: 710

Defend Bitcoin and its PoW: bitcoincleanup.com

Quote from: italianMiner72 on January 15, 2020, 11:06:13 AM

wowowowowow!!!
this seems a good method to query the bitcointalk SMF Forum.
plz can you share the inline query to get this results?
thank you!

As logfiles also mentioned: loyce.club/active/7d.html + REGEX magic
No SMF was harmed making this list ! Grin

italianMiner72

hero member

Activity: 910

Merit: 511

logfiles

copper member

Activity: 2170

Merit: 1827

Top Crypto Casino

I know this method is rudimentary because i have zero skills when it comes to data scrapping or technical aspects of forum data but i think Loyce.club's Unedited/Deleted post viewer can be very useful.

So looking at http://loyce.club/archive/members, we shall be able to get accounts that were registered at a given period of time but are still active or were at least active from the time LoyceV started archiving posts.

Looking at http://loyce.club/archive/members/0/, Luke-Jr was the first member who was registered in 2011 who has recently had some of his posts archived

So you will look at members from the same list whose User ID starts from Luke-Jr's ➡ 3318 to smracer's ➡ 48727 (In http://loyce.club/archive/members/4/)
Hope it helps, there are a few hundreds of UID's in there

Rizzrack

copper member

Activity: 784

Merit: 710

Defend Bitcoin and its PoW: bitcoincleanup.com

Quote from: TheBeardedBaby on January 15, 2020, 04:03:50 AM

I would like to get a list of all the accounts active in the past 120 days which were registered back in 2011.

forumalacali

full member

Activity: 294

Merit: 193

Quote from: TheBeardedBaby on January 15, 2020, 04:19:02 AM

Quote from: forumalacali on January 15, 2020, 04:07:42 AM

Quote from: TheBeardedBaby on January 15, 2020, 04:03:50 AM

I don't know if this is possible but I would like to get a list of all the accounts active in the past 120 days which were registered back in 2011.
Just tagged one, and I have seen some before.
Can be a Google spredsheet list as well, easier to work with data that way.

If you are a member in 2011 and received btc Grin

I don't hang out in the forum Grin

I wondered beautiful thought...

After the forum hack from 2015 there are many accounts with weak passwords hacked and sold, now from time to time I see old newbie accounts wearing avatars, saying around that " I just heard of bitcoin and...", joining spam campaigns or are used for bumping.. So this list will help a lot to start cleaning those who were hacked and sold back then.

hımmmm you caught my attention now

TheBeardedBaby

legendary

Activity: 2240

Merit: 3150

₿uy / $ell ..oeleo ;(

Quote from: GazetaBitcoin on January 15, 2020, 05:25:14 AM

Why do you need the accounts registered in 2011 (still active)? Did something happen in that specific year?

No, nothing spesific happned just those were the ones I've seen the most when I look for bumping services.

Quote from: El duderino_ on January 15, 2020, 05:26:57 AM

And the active ones from 2010 .... there are some to ....

This is just the start, when I'm done with those, will continue with the other years as well. Let's see how it will go at first.

El duderino_

legendary

Activity: 2688

Merit: 13334

BTC + Crossfit, living life.

And the active ones from 2010 .... there are some to ....

GazetaBitcoin

legendary

Activity: 1680

Merit: 6524

Fully-fledged Merit Cycler|Spambuster'23|Pie Baker

Why do you need the accounts registered in 2011 (still active)? Did something happen in that specific year?

shield132

hero member

Activity: 2352

Merit: 905

Metawin.com - Truly the best casino ever

Perhaps it would be possible if most of member search options weren't disabled but there is one option that comes to my mind. The first account that registered in 2011 starts with profile ID: 3130 and ends with 48828. It seems in just 2011 year, 45,698 members were registered. Idk how can I help you further, you need program with algorithm that will check this URLs like bruteforce and save information about them in one file and then you manually check their last activity with search of 2019 like you do in excel for example.
Some accounts that I just found are:
ElectricMucus
kano <-- he is known good guy.
Cluster2k
piotr_n

TheBeardedBaby

legendary

Activity: 2240

Merit: 3150

₿uy / $ell ..oeleo ;(

Quote from: forumalacali on January 15, 2020, 04:07:42 AM

Quote from: TheBeardedBaby on January 15, 2020, 04:03:50 AM

I don't know if this is possible but I would like to get a list of all the accounts active in the past 120 days which were registered back in 2011.
Just tagged one, and I have seen some before.
Can be a Google spredsheet list as well, easier to work with data that way.

If you are a member in 2011 and received btc Grin

I don't hang out in the forum Grin

I wondered beautiful thought...

After the forum hack from 2015 there are many accounts with weak passwords hacked and sold, now from time to time I see old newbie accounts wearing avatars, saying around that " I just heard of bitcoin and...", joining spam campaigns or are used for bumping.. So this list will help a lot to start cleaning those who were hacked and sold back then.

forumalacali

full member

Activity: 294

Merit: 193

Quote from: TheBeardedBaby on January 15, 2020, 04:03:50 AM

I don't know if this is possible but I would like to get a list of all the accounts active in the past 120 days which were registered back in 2011.
Just tagged one, and I have seen some before.
Can be a Google spredsheet list as well, easier to work with data that way.

If you are a member in 2011 and received btc Grin

I don't hang out in the forum Grin

I wondered beautiful thought...

TheBeardedBaby

legendary

Activity: 2240

Merit: 3150

₿uy / $ell ..oeleo ;(

I don't know if this is possible but I would like to get a list of all the accounts active in the past 120 days which were registered back in 2011.
Just tagged one, and I have seen some before.
Can be a Google spredsheet list as well, easier to work with data that way.

Topic: {Request} A list of all active accounts registered in 2011. (Read 689 times)