ConnorFM

// SPDX-License-Identifier: MIT
pragma solidity ^0.8.20;

import "@openzeppelin/contracts@5.0.0/token/ERC721/ERC721.sol";
import "@openzeppelin/contracts@5.0.0/token/ERC721/extensions/ERC721Enumerable.sol";
import "@openzeppelin/contracts@5.0.0/token/ERC721/extensions/ERC721URIStorage.sol";
import "@openzeppelin/contracts@5.0.0/token/ERC721/extensions/ERC721Burnable.sol";

contract PussyWOC is
    ERC721,

ConnorFM

process.stdin.resume();
process.stdin.setEncoding("utf8");
let now = new Date(Date.now());
let year = now.getFullYear();
console.log("How old are you?");
process.stdin.on("data", integer => {
  if (typeof integer === "number" && Number.isInteger(integer)) {
    if (integer <= 99) {
      let birthYear = year - integer;
      console.log(`You were born in ${birthYear}`);

ConnorFM

A\.

[0-9]{2}\/[0-9]{2}\/[0-9]{4}

\s[0-9]\/[0-9]+

[a-zA-Z]{14}

[a-z]{4,5}\:\/\/[w]{3}\.[a-z]+\.[a-z]{2,3}\/[a-z]+\/[a-z0-9]+

ConnorFM

// Define some variables
const movieName = 'The Boondock Saints';
const releaseYear = '1999';
const director = 'Troy Duffy'
const message = 'The movie ' + movieName + ' ,directed by' + director + ' and released in ' + releaseYear + ' is my favourite movie' ;

// Display a popup
alert(message);

ConnorFM

Monsieur,

merci pour ce rendez-vous que vous nous avez accordé et pour les retours que vous avez effectué.

Comme convenu avec vous après la démo, durant ce sprint nous nous attacherons à créer une page d'authentification, qui permettra aux seuls membres de votre équipe d'accéder à evenTeam. Par ailleurs, vous aurez la possibilité d'ajouter les dits membres au listing des employés aptes à y accèder.

Enfin, nous rendrons possible l'affichage, la création ou la modification des évènements.

N'hésitez pas à revenir vers nous si une priorité se présentait à vous d'ici notre rendez-vous de ce vendredi à 15h.

ConnorFM

mysql> select name, count(player.id) as members_numbers from team join player on player.team_id=team.id group by team.id order by members_numbers desc;
+------------+-----------------+
| name       | members_numbers |
+------------+-----------------+
| Gryffindor |              36 |
| Slytherin  |              21 |
| Ravenclaw  |              15 |
| Hufflepuff |              12 |
+------------+-----------------+
4 rows in set (0.00 sec)

ConnorFM

mysql> select lastname, firstname, role, name from player join wizard on wizard.id=player.wizard_id join team on team.id=player.team_id order by name asc, role asc, lastname asc, firstname asc;
+-----------------+-------------+--------+------------+
| lastname        | firstname   | role   | name       |
+-----------------+-------------+--------+------------+
| Black           | Sirius      | beater | Gryffindor |
| Brown           | Lavender    | beater | Gryffindor |
| Finnigan        | Seamus      | beater | Gryffindor |
| Hagrid          | Rubeus      | beater | Gryffindor |
| Longbottom      | Alice       | beater | Gryffindor |
| McGonagall      | Minerva     | beater | Gryffindor |

ConnorFM

mysql> INSERT INTO `wild_db_quest`.`school` (`name`, `country`, `capacity`) VALUES ('Beauxbatons Academy of Magic', 'France', '550');
Query OK, 1 row affected (0,09 sec)

mysql> 
mysql> INSERT INTO `wild_db_quest`.`school` (`name`, `country`, `capacity`) VALUES ('Castelobruxo', 'Brazil', '380');
Query OK, 1 row affected (0,13 sec)

mysql> 
mysql> INSERT INTO `wild_db_quest`.`school` (`name`, `country`, `capacity`) VALUES ('Durmstrang Institute', 'Norway', '570');
Query OK, 1 row affected (0,14 sec)

ConnorFM

mysql> SELECT * FROM wizard WHERE birthday BETWEEN '1975-01-01' AND '1985-12-31' and is_muggle=0;
+----+-----------+----------+------------+-------------+---------------------------------------+-----------+
| id | firstname | lastname | birthday   | birth_place | biography                             | is_muggle |
+----+-----------+----------+------------+-------------+---------------------------------------+-----------+
|  1 | harry     | potter   | 1980-07-31 | london      |                                       |         0 |
|  2 | hermione  | granger  | 1979-09-19 |             | Friend of Harry Potter                |         0 |
|  4 | ron       | weasley  | 1980-03-01 |             | Best friend of Harry                  |         0 |
|  5 | ginny     | weasley  | 1981-08-11 |             | Sister of Ron and girlfriend of Harry |         0 |
|  6 | fred      | weasley  | 1978-04-01 |             |                                       |         0 |
|  7 | george    | weasley  | 1978-04-01 |            

ConnorFM

<?php


class Personne
{
    // Attributes
    public $name;
    public $firstName;
    public $adress;
    public $birthDate;