hi, I have a user profile done, now I want in this profile to show a list of the categories that this user created, using a list module, but it does not work, something in the live value is wrong, I only get to show the current user categories, that means, it only shows me my own creations no matter what profile I see, and I want it to show the list based on the profile it has now, how do I do it?
so, if it looks the info in the url, that means I have to change the url of the user profile, so the id of the user appears in the url? how do I do that? and I did what you told me, this is what it showed me
SELECT t0.id AS pid,t0.pk AS pk,t0.pkb AS pkb,t0.parent_id AS parent,t0.author_id AS author,t0.author_session AS author_session,t0.cck AS cck,t0.storage_location AS loc,tt.id AS type_id,tt.alias AS type_alias FROM `#__cck_core` AS t0 LEFT JOIN `#__users` AS t1 ON t1.id = t0.pk LEFT JOIN `#__content` AS t2 ON t2.id = t0.pkb LEFT JOIN `#__cck_core_types` AS tt ON tt.name = t0.cck WHERE t2.state = 1 AND t2.access IN (1,1,2) AND ( t2.publish_up = '0000-00-00 00:00:00' OR t2.publish_up <= '2019-03-24 16:10' ) AND ( t2.publish_down = '0000-00-00 00:00:00' OR t2.publish_down >= '2019-03-24 16:10' ) AND t0.cck = 'user' AND t1.id = 34 ORDER BY t1.name ASC LIMIT 25