... be migrated without association (retain UserID=0). The article IDs
-- should also match up.
-- *********************************************************************
-- This script assumes you have ...
...
User Query
$t_value = $the_team_id_that_i_want_to_look_at;
$user_list_query="
SELECT DISTINCT
u.UserID,
CONCAT(u.FirstName, ' ', u.LastName) AS 'Fullname'
FROM
Users u
WHERE
u.StatusType ...
... Users u ON u.UserID=s.StaffUserID
INNER JOIN Resources r ON r.ThisResourceID=s.CategoryID
INNER JOIN Teams t ON t.TeamID=s.TeamID
GROUP BY
s.LogID
ORDER BY
s.TeamID, u.Username, s.DateTimeCreated, ...
So there is other documentation out there. I'm basing most of this article on the official Joomla 1.6 documentation: http://docs.joomla.org/Creating_a_profile_plugin and I want to use an example that ...
... 5 columns:
MediaWiki: number of unique guests, students and staff by month. Also associates a UserID to the wikimedia_user table to identify a user.
SELECT
CONCAT(MONTHNAME(t2.Date), ' ', ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.