Moodle Community Sites
  1. Moodle Community Sites
  2. MDLSITE-1862 META: Moodle.org reboot
  3. MDLSITE-1724

Make use of local_dev to populate cohort and control dev chat log access

    Details

    • Type: Sub-task Sub-task
    • Status: Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Component/s: moodle.org
    • Labels:

      Description

      From dev chat http://moodle.org/mod/cvsadmin/view.php?conversationid=9572#c334037

      Dev chat logs should be converted into a local plugin or perhaps part of local_dev, so that access is restricted to people in the dev database only.

      Also the dev database should populate a cohort which would then populate groups across courses

        Gliffy Diagrams

          Issue Links

            Activity

            Helen Foster created issue -
            Helen Foster made changes -
            Field Original Value New Value
            Priority Minor [ 4 ] Major [ 3 ]
            Labels triaged
            Assignee Helen Foster [ tsala ] Dan Poltawski [ poltawski ]
            David Mudrak made changes -
            Link This issue will be resolved by MDLSITE-1663 [ MDLSITE-1663 ]
            Helen Foster made changes -
            Parent MDLSITE-1862 [ 58122 ]
            Issue Type Improvement [ 4 ] Sub-task [ 5 ]
            Dan Poltawski made changes -
            Comment [ I updated the patch: https://github.com/moodlehq/moodle-local_dev/compare/danp-sync-cohorts

            And I installed it on the clone and tested it out, then I wrote some (horrible) queries to work out who is in the chat cohort, but not in developers list:

            {code}
            mysql> SELECT firstname, lastname FROM user WHERE id IN (SELECT userid FROM cohort_members WHERE cohortid = 5 AND userid NOT IN (SELECT userid FROM cohort_members WHERE cohortid = 9));
            +-----------+--------------+
            | firstname | lastname |
            +-----------+--------------+
            | Michael | Spall |
            | Sam | Test |
            | Mary | Cooch |
            | Kris | Stokking |
            | Bree | Vreedenburgh |
            +-----------+--------------+
            5 rows in set (3.44 sec)
            {code} ]
            Dan Poltawski made changes -
            Comment [ Hrm. Then the other way round (a bit weird, guest user in there):
            {code}
            mysql> SELECT firstname, lastname FROM user WHERE id IN (SELECT userid FROM cohort_members WHERE cohortid = 9 AND userid NOT IN (SELECT userid FROM cohort_members WHERE cohortid = 5));
            +-------------------------+-----------------------------------------+
            | firstname | lastname |
            +-------------------------+-----------------------------------------+
            | Guest | User |
            | Hans | de Zwart |
            | Thomas | Robb |
            | Ahmed | Nabil |
            | Holger | Schadeck |
            | Claudio | Tavares |
            | Antonio | Navarro |
            | Juraj | Chlebec |
            | Zhang | dexuan |
            | Set | Lonnert |
            | Ray | Kingdon |
            | Greg | Barnett |
            | Michael | Schneider |
            | Istvan | Bozsa |
            | Scott | Elliott |
            | Paul | Shew |
            | Palo | Jacko |
            | Stig Bjarne | Haugen |
            | John | Gone |
            | Zbigniew | Fiedorowicz |
            | Les | Kopari |
            | Daniel | Fetzer |
            | Pablo | Etcheverry |
            | David | Scotson |
            | Anders | Berggren |
            | Dr. Ali | Abureesh |
            | Henrik | Kaipe |
            | Russell | Jungwirth |
            | Andrew | Redkin |
            | Christian | Borowski |
            | Williams | Castillo |
            | Thanh | Le |
            | Dan | Stowell |
            | Daryl | Hawes |
            | Kristian | Nielsen |
            | André | Krüger |
            | Jan | Dierckx |
            | Carsten | Schmitz |
            | Hung | Viet Nam |
            | Markus | Hagman |
            | Enrique | Castro |
            | Ziba | Scott |
            | Andreas | Grabs |
            | ไพฑูรย์ | ทิพย์สันเทียะ |
            | Girts | Ozolins |
            | Anoochit | Chalothorn |
            | Jeff | Graham |
            | Brian | King |
            | Julian | Sedding |
            | Joey | Kendall-Morwick |
            | dovix | :) |
            | Paul | Daniels |
            | Dave | Balch |
            | romuald | lorthioir |
            | Aaron | Spike |
            | Ling | Li |
            | Fei | Yang |
            | Stephen | Bourget |
            | Andrew | Ivanov |
            | Lasha | Altunashvili |
            | Đinh Lư | Giang |
            | Zhigang | Sun |
            | Myles | Carrick |
            | Patrick | Li |
            | Charles | Severance |
            | 이찬영 | Lee Chan-young |
            | Tomaž | Savodnik |
            | Yu | Zhang |
            | Vy-Shane | Sin Fat |
            | Takayuki | ISHIKAWA |
            | Andar | Hutasoit |
            | Somsack | INTHASONE |
            | Sam | Chaffee |
            | Eloys | Lafuentes |
            | Manh Cuong | Nguyen |
            | Nagalingam | Kuhan |
            | Tom | Flannaghan |
            | Michael | Champanis |
            | Vincenzo K. | Marcovecchio |
            | Ed | Coyne |
            | Ken | Wilson |
            | David | Horat |
            | Amy | Groshek |
            | Marco Antonio | Toscano Freire |
            | Sidik | Lepic |
            | Charles | Fulton |
            | Oren | Gerstner |
            | Tahir Javed | Awan |
            | shuvro | paul |
            | Leandro | Vieira de Souza |
            | Derick | Turner |
            | Manuel | Montoya |
            | Phil | Cross |
            | James | Brisland |
            | Paul | Vaughan |
            | Luiz Eduardo Laydner | Cruz |
            | Isaac | Marco Blancas |
            | Olga | Santos |
            | Chris | Wager |
            | Nguyen Minh | Duc |
            | Joey | Meece |
            | Muhammad | Sutiyadi |
            | genius | hu |
            | Juan Gabriel | Sáenz |
            | Eric | Villard |
            | Rhodry | Korb |
            | Amir | Elion |
            | Gabriel | Dias |
            | wong | lai leng |
            | ana | glez |
            | Mike | Waters |
            | Constantinos | Delistavrou |
            | jerome | mouneyrac |
            | william adolfo | urrea varon |
            | Jérôme | Charaoui |
            | Abdel Kawy | Abdel Hady |
            | Jonathon | Fowler |
            | Liang | Feng |
            | Ivan | Rodríguez López |
            | Helen | Chen |
            | Felipe | Cidade |
            | Eric | Massague |
            | David | Knight |
            | David | Windham |
            | Nic | Root |
            | Askar | Salimbaev |
            | Wojciech | Dobrowolski |
            | joao | rodrigues |
            | Dianne | Britton |
            | Décio Henrique Marques | Silva |
            | Iyappan | Krishnaswamy |
            | Grady | Laksmono |
            | yimy | jaramillo |
            | tamanna | saxena |
            | Raphael | Eidus |
            | Jennifer | Brooks |
            | Oriol | Aguilar Anguera |
            | The | King |
            | Tom | Lanyon |
            | Rafael | Bernini |
            | Huy | Hoang |
            | Brian | Jorgensen |
            | Julio | Monetti |
            | Björn | Kechel |
            | Mike | Skovgaard |
            | Thomás | Sieczkowski |
            | Sahl | Saad |
            | Vadim | Dvorovenko |
            | Nadia | Afrin |
            | สมจิน | เปียโคกสูง |
            | Matthieu | Nué |
            | Spencer | Creasey |
            | Michael | Aherne |
            | Sumon | Shahriar |
            | Jonathon | Hile |
            | new | smile |
            | christian | gonzalez oyanedel |
            | Roly | Vicaria |
            | Tim | Lock |
            | rashmi | sonar |
            | Yannis | T |
            | spirit | x |
            | Timothy | Allen |
            | Urso | Wieske |
            | Valdir | Leite |
            | Thomas | Leonard |
            | Jay | Knight |
            | bomb | f16 |
            | José Ricardo | Schnell |
            | murat | cekinmez |
            | John | Crepezzi |
            | Truong | Viet Hung |
            | Mahmud | Gobel |
            | justin | lee |
            | Dean | Lennard |
            | karima | kamin |
            | Marco | Calisti |
            | Kevin | Wiliarty |
            | Taras | Chaykivskyy |
            | 123flash | chat |
            | Rex | Lorenzo |
            | 胜利 | 程 |
            | chapa | goonatillaka |
            | Lucas | Schwochow |
            | Adonis P | Dutra |
            | reena | nagrale |
            | Henning | Bostelmann |
            | Manjunath | Kalburgi |
            | Manbeer | Makhloga |
            | Lucian | DiPeso |
            | Giridhar | S |
            | prakash | msamy |
            | Luke | Tucker |
            | Jason | Platts |
            | Cathal | O'Riordan |
            | Maydane | Okiye |
            | Oktawian | Wołków |
            | jaap | wietman |
            | Nitin | Yadav |
            | tarun | gulyani |
            | admin | admin |
            | Jessica | Puls |
            | Moodle | Bot |
            | Phong | Pham Duy |
            | Kris | Robinson |
            | son | hoyoung |
            | Wirianto | Djunaidi |
            | Paul | Charsley |
            | Samet | BAL |
            | Jonathan | Champ |
            | Ahmed | Nada |
            | alaa | anis |
            | Kenny | Tran |
            | Rajesh | Panwar |
            | Efe Cem | Kocabaş |
            | Jan | Miller |
            | Leo | Jackson |
            | Moushami | Rai |
            | Badrul | Mohamad |
            | Divya | muvvala |
            | marian | van de Venn |
            | Pablo | Ordonez |
            | Luís André | Oliveira |
            | Shyam Sunder Santoshi | Visamsetty |
            | triet | le minh |
            | Gerwood | Stewart |
            | rohit | jain |
            | Tõnis | Tartes |
            | Jaswinder | Singh |
            | joven | imperio |
            | Megan | Thomas |
            | Patrick | McNeill |
            | Daren | Chandisingh |
            | Steven | Delapeña lascano |
            | Danny | Wahl |
            | Michael | Clair |
            | John | Kelsh |
            | Nikolaos | Ioannou |
            | Huy | LM |
            | galuh | muntaz |
            | hon wai | lau |
            | Aaron | Wells |
            | tania | cando |
            | ramya | krishnan |
            | RICARDO | bittar |
            | Ajay | Patel |
            | Robert | Fahy |
            | Anna | Davis |
            | Mauro | Mazzieri |
            | luay | khrisat |
            | fatima zohra | elhlouli |
            | Martin | Musatov |
            | Diogo | Henrique |
            | Byeon | Jaehee |
            | Postgraduate | Administrator |
            | Cecil | Betros |
            | Paul | Nicholls |
            | Yang | Yang |
            | Nathan | Mares |
            | 송 | 주홍 |
            | Deepa | Narayanan |
            | Tukam | Dixon |
            | wuwuh | hartono |
            | Catherine | cifuentes |
            | Rodrigo | Nascentes |
            | Chris | Follin |
            | Tyler | Bannister |
            | waldo | villegas mendivil |
            | Haden | Fletcher |
            | Gilles-Philippe | Leblanc |
            | Diane | Villemure |
            | Sam | Hemelryk |
            | Evan | Irving-Pease |
            | Vignesh | E |
            | tumbur | josua |
            | Jason | Ilicic |
            | Jody | Steele |
            | Yousef | Sabbah |
            | Mayank | Gupta |
            | Anita | Mourya |
            | Mike | Holzer |
            | Asaf | Ohaion |
            | Alexander | Bias |
            | Jean-Philippe | Gaudreau |
            | Helmut | Irle |
            | ALHAMDULILLAH Osman | Mohiuddin |
            | Sagie | Maoz |
            | Ali | Ayaz |
            | nikhil | gupta |
            | Gayan | Lorenzu Hewa |
            | Eduardo | Pinto |
            | Adam | Olley |
            | Adiel | Ntuk |
            | Hugh | Davenport |
            | Weston | Dunn |
            | Tony | Levi |
            | liao | liefa |
            | Tu | Nguyen |
            | Matt (WCW) | Meisberger |
            | Christan | Ondevilla |
            | Tom | Cubanski |
            | Kirill | Astashov |
            | Teddy | Kasev |
            | Aleksey | Avdeev |
            | aries | andan |
            | Wiktor | Wandachowicz |
            | udhayakumar | R |
            | Raymond | Antonio |
            | Ulises | Martínez |
            | Valeriy | Streltsov |
            | Andrew | Davidson |
            | Igor | Sazonov |
            | David | Penner |
            | David Hai | Gootvilig |
            | Fábio | Souto |
            | Kanika | Goyal |
            | Paul | Verrall |
            | Juho | Viitasalo |
            | Iurii | Kucherov |
            | Barbara | Ramiro |
            | Ciaran | Irvine |
            | Yevhenii | Vlasenko |
            | Nick | Read |
            | Didier | Raboud |
            | Adrian | Fish |
            | Kyle | Temkin |
            +-------------------------+-----------------------------------------+
            326 rows in set (3.45 sec)
            {code} ]
            Dan Poltawski made changes -
            Status Open [ 1 ] Resolved [ 5 ]
            Resolution Fixed [ 1 ]
            Martin Dougiamas made changes -
            Workflow jira [ 104094 ] SITES Full Workflow [ 126568 ]
            Martin Dougiamas made changes -
            Status Resolved [ 5 ] Closed [ 6 ]
            Helen Foster made changes -
            Workflow SITES Full Workflow [ 126568 ] SITES workflow plus [ 137221 ]

              People

              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Development