Changes between Version 3 and Version 4 of AdminTips

Timestamp:

2012-01-06T21:28:30Z (13 years ago)

Author:

Pan Luo

Comment:

--

AdminTips

@@ -6 +6 @@
 {{{
 #!sql
+SET @EVENTID=EVENT_ID;
 SELECT * FROM users 
 WHERE id IN 
-    (SELECT distinct(evaluator) FROM evaluation_mixevals WHERE event_id = EVENTID AND evaluator NOT IN 
-        (SELECT distinct(submitter_id) FROM evaluation_submissions WHERE event_id = EVENTID)
+    (SELECT distinct(evaluator) FROM evaluation_mixevals WHERE event_id = @EVENTID AND evaluator NOT IN 
+        (SELECT distinct(submitter_id) FROM evaluation_submissions WHERE event_id = @EVENTID)
     );
 }}}
 
-Replace EVENTID to event id.
+Replace EVENT_ID to event id.
 
 === Submit for those students ===
 {{{
 #!sql
+SET @EVENTID=EVENT_ID, @COURSEID=COURSE_ID;
 INSERT INTO evaluation_submissions 
-    SELECT NULL,EVENTID, group_events.id, user_id,1,NOW(),'A',1,NOW(),NULL,NOW() 
+    SELECT NULL,@EVENTID, group_events.id, user_id,1,NOW(),'A',1,NOW(),NULL,NOW() 
     FROM groups 
     LEFT JOIN groups_members ON groups.id = groups_members.group_id 
@@ -26 +28 @@
           SELECT id FROM users 
           WHERE id IN 
-          (SELECT distinct(evaluator) FROM evaluation_mixevals WHERE event_id = EVENTID AND evaluator NOT IN 
-              (SELECT distinct(submitter_id) FROM evaluation_submissions WHERE event_id = EVENTID)
+          (SELECT distinct(evaluator) FROM evaluation_mixevals WHERE event_id = @EVENTID AND evaluator NOT IN 
+              (SELECT distinct(submitter_id) FROM evaluation_submissions WHERE event_id = @EVENTID)
           );;
 }}}
 
-Replace EVENTID to event id and COURSEID to course id.
+Replace EVENT_ID to event id and COURSE_ID to course id.