buka phpmayadmin
SQL
SELECT id,username FROM `mdl_user` where username IN('4503','4509')
setelah kit adaptkan nim yang ada di mdl_user. kita ambil id usernya
kemudian insert. caranya seperti di bawah ini:
insert into mdl_role_assignments values
(NULL,5,33,3,0,1366063200,0,1366109765,2,'manual',0),
(NULL,5,23,3,0,1366063200,0,1366109765,2,'manual',0)
keterangan
5 siswa
23 sinrole
3 iduser
SELECT *
FROM `info_groups_members`
insert into info_groups_members values
(NULL,165,74,1366063200),
(NULL,165,102,1366063200),
(NULL,165,115,1366063200),
(NULL,165,1202,1366063200),
(NULL,165,5754,1366063200),
(NULL,165,5756,1366063200),
(NULL,165,5758,1366063200),
(NULL,165,5762,1366063200),
(NULL,165,5766,1366063200),
(NULL,165,5768,1366063200),
(NULL,165,5770,1366063200),
(NULL,165,5774,1366063200),
(NULL,165,5788,1366063200),
(NULL,165,5808,1366063200),
(NULL,165,5810,1366063200),
(NULL,165,5816,1366063200)
