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:
    • Rank:
      38354

      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

        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 ]

            People

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

              Dates

              • Created:
                Updated:
                Resolved:

                Development