public function RatingProject($_internID, $_projectID, $_value) { //Si aucune note n'avait été donné avant, la rajouter. if (parent::DBQuery("SELECT * FROM ratings WHERE internID=" . $_internID . " and projectID=" . $_projectID) == null) { parent::DBExecute("INSERT INTO ratings (score,internID, projectID)\n\t\t\t\t\t\t\t\tVALUES(\n\t\t\t\t\t\t\t\t" . $_value . ",\n\t\t\t\t\t\t\t\t" . $_internID . ",\n\t\t\t\t\t\t\t\t" . $_projectID . ")"); } else { //Sinon, mettre à jour la base de donnée parent::DBExecute("Update ratings \n\t\t\t\t\t\t\t\tSET\n\t\t\t\t\t\t\t\tscore = " . $_value . "\n\t\t\t\t\t\t\t\tWHERE\n\t\t\t\t\t\t\t\tinternID = " . $_internID . " AND\n\t\t\t\t\t\t\t\tprojectID = " . $_projectID . ";"); } }
public function Logout($_token) { $token = $this->TokenGen(); //Mise à jour de l'utilisateur. $cmd = "UPDATE users SET token= " . $token . "WHERE token = " . $_token; parent::DBExecute($cmd); }
public function DeleteProject($_projectId) { parent::DBExecute("DELETE FROM ratings WHERE projectID = " . $_projectId); parent::DBExecute("DELETE FROM projects WHERE ID = " . $_projectId); }