Correction des programmes (ATTENTION : vous devez être capable de FAIRE seuls !)

moodle_mes_messages_V1.py -> https://trinket.io/python3/d7a873b745

import mysql.connector as mysql
 
db = mysql.connect(
    host = "moodle.lyceestendhal.it",
    port = 3306,   # ou 3306 depuis sa salle de classe
    user = "moodle_guest",
    passwd = "<mot de passe>",
    database = "moodle"
)
print(db)
cursor = db.cursor()
cursor.execute("SELECT `id` FROM `moodle`.`mdl_user` WHERE `email` = '<votre adresse email>';")
for row in cursor:
    print(row)

moodle_mes_messages_V2.py ->https://trinket.io/python3/f06ec4a8b1

import mysql.connector as mysql

email = input("Entrez votre adresse email")

db = mysql.connect(
    host = "moodle.lyceestendhal.it",
    port = 3306,   # ou 3306 depuis sa salle de classe
    user = "moodle_guest",
    passwd = "<mot de passe>",
    database = "moodle"
)
print(db)
cursor = db.cursor()
cursor.execute("SELECT `id` FROM `moodle`.`mdl_user` WHERE `email` = '" + email + "';")
for row in cursor:
    print(row)

moodle_mes_messages_V3.py -> https://trinket.io/python3/1e6157e465

import mysql.connector as mysql

email = input("Entrez votre adresse email sans le '@lyceestendhal.it' : ")
email += "@lyceestendhal.it"

db = mysql.connect(
    host = "moodle.lyceestendhal.it",
    port = 3306,   # ou 3306 depuis sa salle de classe
    user = "moodle_guest",
    passwd = "<mot de passe>",
    database = "moodle"
)
print(db)
cursor = db.cursor()
cursor.execute("SELECT `id` FROM `moodle`.`mdl_user` WHERE `email` = '" + email + "';")
for row in cursor:
    print(row)

moodle_mes_messages_V4.py -> https://trinket.io/python3/6ee0c5a5ae

import mysql.connector as mysql

email = input("Entrez votre adresse email sans le '@lyceestendhal.it' : ")
email += "@lyceestendhal.it"

db = mysql.connect(
    host = "moodle.lyceestendhal.it",
    port = 3306,   # ou 3306 depuis sa salle de classe
    user = "moodle_guest",
    passwd = "<mot de passe>",
    database = "moodle"
)
print(db)
cursor = db.cursor()
cursor.execute("SELECT `id`, `conversationid`, DATE_ADD('1970-1-1 00:00:00', INTERVAL `timecreated` SECOND) as date, (SELECT `email` FROM `moodle`.`mdl_user` WHERE `id` = (SELECT `userid` FROM `moodle`.`mdl_message_conversation_members` WHERE (`conversationid` = `moodle`.`mdl_messages`.`conversationid`) AND (`userid` != `useridfrom`)))'email destinataire', `smallmessage` FROM `moodle`.`mdl_messages` WHERE `useridfrom` = (SELECT `id` FROM `moodle`.`mdl_user` WHERE `email` = '" + email + "');")
for row in cursor:
    print(row)

moodle_mes_messages_V5.py -> https://trinket.io/python3/62474127d2

import mysql.connector as mysql

email = input("Entrez votre adresse email sans le '@lyceestendhal.it' : ")
email += "@lyceestendhal.it"

db = mysql.connect(
    host = "moodle.lyceestendhal.it",
    port = 3306,   # ou 3306 depuis sa salle de classe
    user = "moodle_guest",
    passwd = "<mot de passe>",
    database = "moodle"
)
print(db)
cursor = db.cursor()
cursor.execute("SELECT MIN(id), `ip`, DATE_ADD('1970-1-1 00:00:00', INTERVAL `timecreated` SECOND) as date FROM `moodle`.`mdl_logstore_standard_log` WHERE `userid` = (SELECT `id` FROM `moodle`.`mdl_user` WHERE `email` = '" + email + "' ) GROUP BY `ip` ORDER BY `id` DESC LIMIT 10;")
for row in cursor:
    print(row)