Thanks for a great extension!
I just found a problem with a custom script I have relating to easy-profile. I upload my user accounts using j-import and was looking at some of the newly created users and found out that until they log in for the first time the jsn_users records do not exist. My script tries to look up a custom field I use with easy-profile from a username provided, but for accounts that are present but not yet in use the script thinks there is no account since jsn_user is not available yet.
$db->setQuery("SELECT jsn.status,jsn.firstname,jsn.lastname,u.email,u.name FROM #__jsn_users jsn LEFT JOIN #__users u ON jsn.id =u.id WHERE u.username = '".$searchUser."' LIMIT 1"
;$db->execute();
$num_rows = $db->getNumRows();
if ($num_rows == 0)
I think it is failing because the query is not getting all the results since jsn.status, jsn.firstname, and jsn.lastname do not exist?
I figured there are a few ways to possibly solve this.
1. I could see if you have a way to trigger the fields generation and input the default values that could be integrated with the mass importer j-import.
2. is there a way to run a query in phpmyadmin or a PHP script to manually trigger jsn_users to be created and have the defaults entered for all accounts that have not yet logged in before?
3. I could possibly change my above query to pull the lastvisitDate and check if it is a real date, the default of 0000-00-00 00:00:00 (account never used) or if it does not exist. I don't know programming at all. The person who wrote the script for me is no longer available.
Any help you can provide would be appreciated.
Peter
