Finding a member who changed his username/email

I have a member whom I upgraded to Gold while waiting for his check to arrive. He is now missing and I suspect that he changed his user name/email so I cant find him. Is there a log anywhere that would show what he changed his user name and email to ?

I have Dolphin 7.2

Thanks!

There isn't a log of changes like that, good idea for the module guys. You should have a list of gold members in the admin/members page controls block.

if you can remember anything about him you can keyword search him

john,

could you try running a query on profiles last edited? maybe this will get it narrowed down to something legible?

also, if there is a number of days the membership level carries, you can run a query looking for the longest running date from your membership levels.

i would also think you would have some correspondence with this person, since you manually upgraded their level?

may not be the most efficient way, however, if you can provide sql some information, it will surely provide you some back. because the DateLastEdit is in a stupid format, which includes the time, so it makes it somewhat difficult to run a sql statement on that field when you dont know the time the event occurred. but oh well. thank good for the mathematical functions that are used in a query.

SELECT *
FROM `Profiles`
WHERE `DateLastEdit` > '2010-09-30 10:58:45'
LIMIT 0 , 30

what this says, is show me all profiles that have been updated since Sept. 30, 2010, this eliminates the time factor, because its not considered.

Now what i get are 10 records returned. this should help you figure out exactly who this person is. i used Sept 30, because i couldnt imagine a check taking longer than that to clear.

then trying to dig a little deeper:

SELECT IDMember,IDLEVEL,DateStarts FROM sys_acl_levels_members WHERE DateStarts > '2010-09-01 8:44:33' AND IDLevel = '4';

this will return 3 records, with the IDLevel being Gold,  DateStarts being greater than Sept 01, 2010, the actual records show that there are only 3 ID's that started after the queried date. so this should help you narrow it down.

so mrp is correct, there are no logs, and yes this would be a great module to have as an admin tool. there are methods of searching. if you want to cry you dont know sql, yeah well me either. http://sqlcourse.com get you some. too lazy to read and learn, go back to static pages, so sql is not required.