2015-02-01, 05:46 PM
A couple of weeks ago we upgraded from 1.6.16 to 1.8.3. One issue that remains unresolved is that our users' previous IP addresses did not copy over. If I understand correctly, this is due to a change in format from IPv4 to IPv6.
So, second best, I thought we could do a data dump of the IP addresses from our 1.6 database to keep on my computer to check those IPs when needed. But, I need some help to figure out where they are all stored in the database so I can provide specific directions to the person who will actually create the .csv files for me.
In the mybb_users table I see lastip and regip. But, where are all of the other IP addresses stored in the 1.6 database that I can view on the ACP>U&G>Options>Show IP Addresses ( http://www.cheaprvliving.com/forums/spam...sses&uid=2)? Does it just pull from each table where an 'ip' or 'ipaddress' is stored (mybb_adminlog, mybb_adminsessions, mybb_maillogs, mybb_moderatorlog, mybb_posts, mybb_privatemessages, mybb_searchlog, mybb_sessions, mybb_threadratings)?
Thank you for your help.
So, second best, I thought we could do a data dump of the IP addresses from our 1.6 database to keep on my computer to check those IPs when needed. But, I need some help to figure out where they are all stored in the database so I can provide specific directions to the person who will actually create the .csv files for me.
In the mybb_users table I see lastip and regip. But, where are all of the other IP addresses stored in the 1.6 database that I can view on the ACP>U&G>Options>Show IP Addresses ( http://www.cheaprvliving.com/forums/spam...sses&uid=2)? Does it just pull from each table where an 'ip' or 'ipaddress' is stored (mybb_adminlog, mybb_adminsessions, mybb_maillogs, mybb_moderatorlog, mybb_posts, mybb_privatemessages, mybb_searchlog, mybb_sessions, mybb_threadratings)?
Thank you for your help.