Belindo

Thanks for getting back on this Antoine! It seems that this applies for new users? In my case I’m creating accounts from our companies Active Directory. So for me it would be ideal if people can change the league on their profile and then it will be approved without an admin having to do that.
No rush, as I currently have a workaround, but if it’s a simple line of code you can pull out of your sleeve, that would be great!

For now, I have foun a workaround by using the Admin Report pluging with a query that compares the ‘footballpool_league’ and ‘footballpool_registeredforleague’ from the users-meta.

Query below:

SELECT y.nickName, pool_wp_leagues.name AS currentLeagueName, pool_wp_leagues_1.name AS requestedLeagueName
FROM (
	(
		SELECT x.UserID, wp_usermeta.meta_value AS nickName, Sum(x.CurrentLeague) AS CurrentLeague, Sum(x.RequestedLeague) AS RequestedLeague 
		FROM (
			SELECT wp_usermeta.user_id AS UserID, (wp_usermeta.meta_value*1) AS CurrentLeague, Null AS RequestedLeague FROM wp_usermeta WHERE wp_usermeta.meta_key='footballpool_league' 
			UNION ALL 
			SELECT wp_usermeta.user_id AS UserID, Null AS CurrentLeague, (wp_usermeta.meta_value*1) AS RequestedLeague FROM wp_usermeta WHERE wp_usermeta.meta_key='footballpool_registeredforleague'
		) AS x 
		INNER JOIN wp_usermeta ON x.UserID = wp_usermeta.user_id GROUP BY x.UserID, wp_usermeta.meta_value, wp_usermeta.meta_key HAVING wp_usermeta.meta_key='nickname'
	) AS y INNER JOIN pool_wp_leagues ON y.CurrentLeague = pool_wp_leagues.id
) INNER JOIN pool_wp_leagues AS pool_wp_leagues_1 ON y.RequestedLeague = pool_wp_leagues_1.id
GROUP BY y.userID, y.nickName, y.currentLeague, pool_wp_leagues.name, y.requestedleague, pool_wp_leagues_1.name, y.CurrentLeague
HAVING y.CurrentLeague <> y.requestedLeague

• This reply was modified 8 years ago by Belindo.