SELECT p.projectID, p.ownerID, p.clientID, p.name, p.description, p.display, p.added, p.addedBy, p.status, p.ticketPrefix, p.svnurl, p.svnuser, p.svnpass, pu.admin, pu.files, pu.issues, pu.msgs, pu.mstones, pu.todos, pu.svn, c.name as clientName, u.firstName as ownerFirstName, u.lastName as ownerLastName FROM #variables.tableprefix#projects p INNER JOIN #variables.tableprefix#project_users pu ON p.projectID = pu.projectID INNER JOIN #variables.tableprefix#users u ON p.ownerID = u.userID LEFT JOIN #variables.tableprefix#clients c on p.clientID = c.clientID WHERE 0=0 AND p.projectID = AND pu.userID = ORDER BY p.name SELECT p.projectID, p.ownerID, p.clientID, p.name, p.description, p.display, p.added, p.addedBy, p.status, p.ticketPrefix, p.svnurl, p.svnuser, p.svnpass, p.allow_reg, p.reg_active, p.reg_files, p.reg_issues, p.reg_msgs, p.reg_mstones, p.reg_todos, p.reg_svn, c.name as clientName, u.firstName as ownerFirstName, u.lastName as ownerLastName FROM #variables.tableprefix#projects p INNER JOIN #variables.tableprefix#users u ON p.ownerID = u.userID LEFT JOIN #variables.tableprefix#clients c on p.clientID = c.clientID WHERE 0=0 AND projectID = AND allow_reg = 1 ORDER BY p.name INSERT INTO #variables.tableprefix#projects (projectID,ownerID,name,description,display,added,addedBy,clientID,status,ticketPrefix,svnurl,svnuser,svnpass,allow_reg,reg_active,reg_files,reg_issues,reg_msgs,reg_mstones,reg_todos,reg_svn) VALUES (, , , , , #Now()#, , , , , , , , , , , , , , , ) UPDATE #variables.tableprefix#projects SET name = , ownerID = , description = , display = , clientID = , status = , ticketPrefix = , svnurl = , svnuser = , svnpass = , allow_reg = , reg_active = , reg_files = , reg_issues = , reg_msgs = , reg_mstones = , reg_todos = , reg_svn = WHERE projectID = DELETE FROM #variables.tableprefix#activity WHERE projectID = DELETE FROM #variables.tableprefix#files WHERE projectID = DELETE FROM #variables.tableprefix#issues WHERE projectID = DELETE FROM #variables.tableprefix#messages WHERE projectID = DELETE FROM #variables.tableprefix#milestones WHERE projectID = DELETE FROM #variables.tableprefix#projects WHERE projectID = DELETE FROM #variables.tableprefix#project_users WHERE projectID = DELETE FROM #variables.tableprefix#todolists WHERE projectID = DELETE FROM #variables.tableprefix#todos WHERE projectID = SELECT distinct u.userID, u.firstName, u.lastName, u.username, u.email, u.phone, u.mobile, u.lastLogin, u.email_files, u.mobile_files, u.email_issues, u.mobile_issues, u.email_msgs, u.mobile_msgs, u.email_mstones, u.mobile_mstones, u.email_todos, u.mobile_todos, u.avatar, c.prefix, c.suffix , pu.admin, pu.files, pu.issues, pu.msgs, pu.mstones, pu.todos, pu.svn FROM #variables.tableprefix#users u INNER JOIN #variables.tableprefix#project_users pu ON u.userID = pu.userID LEFT JOIN #variables.tableprefix#carriers c on u.carrierID = c.carrierID WHERE u.active = 1 AND projectID = AND projectID IN ('#replace(arguments.projectIDlist,",","','","ALL")#') AND pu.admin = 1 ORDER BY #arguments.order_by# SELECT userID, firstName, lastName FROM #variables.tableprefix#users WHERE active = 1 AND userID NOT IN ( select userID from #variables.tableprefix#project_users where projectID = ) ORDER BY lastName, firstName UPDATE #variables.tableprefix#projects SET ownerID = WHERE projectid = UPDATE #variables.tableprefix#project_users SET admin = 10, files = , issues = , msgs = , mstones = , todos = 10 WHERE projectid = AND userID =