Not Solved Membership data file
#1
Not Solved
What file is the membership data stored in? I would like to tease out  names, ISPs & email addresses. Using the


Admin/User Groups/Table View


I get the addies & Names but not the ISPs. To get the ISP I have to look at each individually which is a pita. If I knew which file(s) the membership info is kept in, I could extract the info into the format I want using custom program I wrote.


Thx,


Swede
Reply
#2
Not Solved
MyBB doesn't store information on the ISP of users.
Reply
#3
Not Solved
(2015-11-17, 04:52 PM)laie_techie Wrote: MyBB doesn't store information on the ISP of users.

It must as it displays the Registration IP when clicking the Options button of a member.I want to use it check for bogus registrations. If I knew the file the data was in I could extract into a better format for my purposes (sort by ISP).

Thx your reply though.

Swede
Reply
#4
Not Solved
(2015-11-18, 02:15 AM)Swede Wrote:
(2015-11-17, 04:52 PM)laie_techie Wrote: MyBB doesn't store information on the ISP of users.

It must as it displays the Registration IP when clicking the Options button of a member.I want to use it check for bogus registrations. If I knew the file the data was in I could extract into a better format for my purposes (sort by ISP).

Thx your reply though.

Swede

The users table includes a field for the registration IP, but does not store information about the ISP. The only way to map an IP to ISP is to call a WHOIS service.
Reply
#5
Not Solved
Data file? MyBB stores member IPs encoded in the mybb_users table of your SQL database - not a physical file.
Reply
#6
Not Solved
Swede, did you mean IPs or ISP?
Reply
#7
Not Solved
(2015-11-18, 09:57 PM)laie_techie Wrote: Swede, did you mean IPs or ISP?
I apparently misspoke. I want the Registration IP's. Sorry for any confusion.

Thx,

Swede
Reply
#8
Not Solved
Thanks the help guys. After talking to you guys, I found out from my ISP the data is in an SQL database on the server. I was able to dl the member database and tease out the info I wanted. Now I will be able to sort the membership by any field. Sorting by RegIP will make finding (some) "illegitmates" much easier.
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)