<?php
if (isset($_POST['title']) and isset($_POST['priority']) and isset($_POST['description'])) {
$addTitle = $_POST['title'];
$addPriority = $_POST['priority'];
$addDescription = $_POST['description'];
require $GLOBALS['LOF_SERVER_urlPhp'] . '/plugins/lof/popup.php';
//GOOD
$bdd = LOF_connect();
$req = $bdd->prepare('UPDATE ' . $GLOBALS['LOF_BDD_TABLE_forums'] . '(title, description, priority) VALUES(:title,:description,:priority)');
$req->execute(array('title' => $addTitle, 'description' => $addDescription, 'priority' => $addPriority));
LOF_successPopup("Modification effectué !");
?>
<meta http-equiv="refresh" content="1">
<?php
}
throw new Exception('Certains champs ne sont pas remplit.');
}
//Author
if (!($infosMessage['messageAuthorId'] == $_SESSION['id'])) {
throw new Exception("Vous n'êtes pas l'auteur de ce message");
}
//Verify Pin
if (!($infosMessage['messagePin'] == $_GET['pin'])) {
throw new Exception("Erreur dans le code pin");
}
//BDD connection
$bdd = LOFConnect();
//Update Message
$req = $bdd->prepare('UPDATE ' . $GLOBALS['LOF_BDD_TABLE_messages'] . ' SET content = :content WHERE id = ' . $_GET['id'] . ' AND pin = "' . $_GET['pin'] . '"');
$req->execute(array('content' => $_POST['message']));
LOF_successPopup("Mise à jour effectuer ! Rediction en cours...");
?>
<META http-equiv="refresh" content="1;URL=/forum/post.php?id=<?php
echo $_GET['postId'];
?>
&page=<?php
echo $_GET['postPage'];
?>
">
<?php
} catch (Exception $e) {
LOF_errorPopup($e->getMessage());
}
}
?>
WHERE ' . $GLOBALS['LOF_BDD_TABLE_posts'] . '.id = ' . $_GET['postId'] . ' AND ' . $GLOBALS['LOF_BDD_TABLE_posts'] . '.pin = "' . $_GET['pin'] . '"';
$bdd = LOFConnect();
//BDD connect
$postData = $bdd->query($request);
$post = $postData->fetch();
if (!($post['messageAuthorId'] == $_SESSION['id'])) {
throw new Exception("Vous n'êtes pas l'auteur de ce message");
}
if ($_GET['action'] <= 0 && $_GET['action'] >= 2) {
throw new Exception("Erreur dans le type d'action");
}
// Update post
$reqForum = $bdd->query('UPDATE ' . $GLOBALS['LOF_BDD_TABLE_posts'] . ' SET postState = ' . $_GET['action'] . ' WHERE id = ' . $post['postId'] . ' AND pin = "' . $_GET['pin'] . '"');
$bdd = null;
if ($_GET['action'] == 1) {
LOF_successPopup("<strong>Le sujet est considéré comme résolu !</strong> Vous pouvez toujours répondre mais, si votre question est identique mais la solution proposée ici ne fonctionne pas/plus merci de faire un nouveau sujet.");
} else {
if ($_GET['action'] == 2) {
LOF_errorPopup("Le sujet que vous consultez a été fermé par son auteur, vous ne pouvez plus y répondre.");
}
}
?>
<noscript><META http-equiv="refresh" content="2;URL=/forum/post.php?id=<?php
echo $_GET['postId'];
?>
&page=1"></noscript>
<?php
} catch (Exception $e) {
header("HTTP/1.0 500 Internal Server Error");
echo "Erreur interne : la lecture du message à échouée.";
//BDD connection
$bdd = LOFConnect();
//Account exist ?
$reply = $bdd->query("SELECT " . $GLOBALS['LOF_BDD_TABLE_account'] . ".id, " . $GLOBALS['LOF_BDD_TABLE_account'] . ".rank, " . $GLOBALS['LOF_BDD_TABLE_account'] . ".pseudo, " . $GLOBALS['LOF_BDD_TABLE_account'] . ".password FROM " . $GLOBALS['LOF_BDD_TABLE_account'] . " WHERE pseudo='" . $loginName . "'");
//Modifier la requête
$value = $reply->fetch();
if (!($value['pseudo'] == $loginName and $value['password'] == $loginPassword)) {
throw new Exception('Mot de passe ou nom de compte incorrect.');
}
//GOOD
$req = $bdd->query('UPDATE ' . $GLOBALS['LOF_BDD_TABLE_account'] . ' SET lastlogin = NOW() WHERE id = ' . $value['id']);
$_SESSION['id'] = $value['id'];
$_SESSION['rank'] = $value['rank'];
$_SESSION['user'] = $value['pseudo'];
$_SESSION['connect'] = 1;
LOF_successPopup("Connexion en cours à votre compte...");
//Rediction
/*if(isset($_GET['url']))
header('Location: '.$_GET['url']);
else
header('Location: /'); */
if (isset($_GET['url'])) {
?>
<META http-equiv="refresh" content="2;URL=<?php
echo $_GET['url'];
?>
">
<?php
} else {
?>
<META http-equiv="refresh" content="2;URL=/">
$actualPassword = LOF_encrypt($_POST['actualPassword']);
if ($data['password'] == $actualPassword) {
$newPassword = LOF_encrypt($_POST['newPassword']);
$newPasswordAgain = LOF_encrypt($_POST['newPasswordAgain']);
if ($newPassword == $newPasswordAgain) {
$req = $bdd->prepare('UPDATE ' . $GLOBALS['LOF_BDD_TABLE_account'] . ' SET password = :password WHERE id = ' . $_SESSION['id']);
$req->execute(array('password' => $newPassword));
LOF_successPopup("Modification effectuée (Mot de passe), rechargement de la page dans quelques secondes ...");
} else {
LOF_errorPopup("Le nouveau mot de passe n'est pas identiques dans les 2 champs.");
}
} else {
LOF_errorPopup("Le mot de passe actuel n'est pas valide.");
}
}
//Update About
if ($_POST['signature'] != $data['signature'] or $_POST['skype'] != $data['skype'] or $_POST['twitter'] != $data['twitter'] or $_POST['facebook'] != $data['facebook'] or $_POST['youtube'] != $data['youtube'] or $_POST['website1'] != $data['website1'] or $_POST['website2'] != $data['website2'] or $_POST['website3'] != $data['website3']) {
$req = $bdd->prepare('UPDATE ' . $GLOBALS['LOF_BDD_TABLE_account'] . ' SET signature = :signature, skype = :skype, twitter = :twitter, facebook = :facebook, youtube = :youtube, website1 = :website1, website2 = :website2, website3 = :website3 WHERE id = ' . $_SESSION['id']);
$req->execute(array('signature' => $_POST['signature'], 'skype' => $_POST['skype'], 'twitter' => $_POST['twitter'], 'facebook' => $_POST['facebook'], 'youtube' => $_POST['youtube'], 'website1' => $_POST['website1'], 'website2' => $_POST['website2'], 'website3' => $_POST['website3']));
LOF_successPopup("Modification effectuée (Facultatif), rechargement de la page dans quelques secondes ...");
}
$bdd = NULL;
//Rediction
header('Refresh: 2');
} catch (Exception $e) {
LOF_errorPopup($e->getMessage());
}
}
?>
//BDD connection
$bdd = LOFConnect();
//Generate Pin code for post
$pin = LOF_generatePin();
$req = $bdd->prepare('INSERT INTO ' . $GLOBALS['LOF_BDD_TABLE_posts'] . '(category, title, description, author, messageNb, pin) VALUES(:category,:title,:description,:author,:messageNb,:pin)');
$req->execute(array('category' => $_GET['id'], 'title' => $title, 'description' => $description, 'author' => $_SESSION['id'], 'messageNb' => 1, 'pin' => $pin));
$postId = $bdd->lastInsertId();
//Generate Pin code for message
$pin = LOF_generatePin();
//Create Message
$reqMsg = $bdd->prepare('INSERT INTO ' . $GLOBALS['LOF_BDD_TABLE_messages'] . '(postId, headerMsg, content, author, publish, pin) VALUES(:postId, :headerMsg, :content,:author,:publish,:pin)');
$reqMsg->execute(array('postId' => $postId, 'headerMsg' => 1, 'content' => $message, 'author' => $_SESSION['id'], 'publish' => $date->format('Y-m-j H:i:s'), 'pin' => $pin));
$messageId = $bdd->lastInsertId();
$reqForum = $bdd->query('UPDATE ' . $GLOBALS['LOF_BDD_TABLE_posts'] . ' SET lastMessage = ' . $messageId . ' WHERE id = ' . $postId);
//Update Forum
$reqForum = $bdd->query('UPDATE ' . $GLOBALS['LOF_BDD_TABLE_forums'] . ' SET messageNb = messageNb + 1, postNb = postNb + 1, lastMessage = ' . $messageId . ' WHERE id = ' . $_GET['id']);
$bdd = null;
LOF_successPopup("Votre poste est en ligne !");
//Rediction
if (isset($_GET['url'])) {
header('Location: ' . $_GET['url']);
} else {
header('Location: /');
}
} catch (Exception $e) {
LOF_errorPopup($e->getMessage());
}
}
?>
if (empty($postId) and empty($message)) {
throw new Exception('Certains champs ne sont pas remplit.');
}
//BDD connection
$bdd = LOFConnect();
//Create Message
$reqMsg = $bdd->prepare('INSERT INTO ' . $GLOBALS['LOF_BDD_TABLE_messages'] . '(postId, content, author, publish, pin) VALUES(:postId,:content,:author,:publish,:pin)');
$reqMsg->execute(array('postId' => $postId, 'content' => $message, 'author' => $_SESSION['id'], 'publish' => $date->format('Y-m-j H:i:s'), 'pin' => $pin));
$messageId = $bdd->lastInsertId();
$reqForum = $bdd->query('UPDATE ' . $GLOBALS['LOF_BDD_TABLE_posts'] . ' SET messageNb = messageNb + 1, lastMessage = ' . $messageId . ' WHERE id = ' . $postId);
//Update Forum
$reqInfosPost = $bdd->query('SELECT ' . $GLOBALS['LOF_BDD_TABLE_posts'] . '.category FROM ' . $GLOBALS['LOF_BDD_TABLE_posts'] . ' WHERE id = ' . $postId);
$infosPost = $reqInfosPost->fetch();
$reqForum = $bdd->query('UPDATE ' . $GLOBALS['LOF_BDD_TABLE_forums'] . ' SET messageNb = messageNb + 1, lastMessage = ' . $messageId . ' WHERE id = ' . $infosPost['category']);
//Update user information (msgNb)
$reqUser = $bdd->query('UPDATE ' . $GLOBALS['LOF_BDD_TABLE_account'] . ' SET msgNb = msgNb + 1 WHERE id = ' . $_SESSION['id']);
$bdd = null;
LOF_successPopup("Merci de votre réponse ! Redirection en cours...");
?>
<META http-equiv="refresh" content="2;URL=/forum/post.php?id=<?php
echo $_GET['id'];
?>
&page=1">
<?php
} catch (Exception $e) {
LOF_errorPopup($e->getMessage());
}
}
?>
require '../plugins/lof/popup.php';
require '../plugins/lof/addOn/encrypt.php';
//Update avatar
try {
// User connect ?
if (!isset($_SESSION['connect'])) {
throw new Exception('Seules les personnes connectees peuvent supprimer des messages');
}
//Image format
if (!($extension = strrchr($_FILES['avatar']['name'], '.') == ".png")) {
throw new Exception('Le format de l\'image n\'est pas de type .png.');
}
//Size of image
if (filesize($_FILES['avatar']['tmp_name']) > 32768) {
throw new Exception('L\'image est trop volumineuse.');
}
//Upload image
if (!move_uploaded_file($_FILES['avatar']['tmp_name'], "avatar/" . $_SESSION['id'] . ".png")) {
throw new Exception('Erreur lors de la mise en ligne.');
}
//Rediction
LOF_successPopup("Votre avatar est maintenant en ligne ! Redirection en cours...");
?>
<META http-equiv="refresh" content="2;URL=editProfile.php">
<?php
} catch (Exception $e) {
LOF_errorPopup($e->getMessage());
}
?>
<?php
if (isset($_POST['title']) and isset($_POST['priority']) and isset($_POST['description'])) {
$addTitle = $_POST['title'];
$addPriority = $_POST['priority'];
$addDescription = $_POST['description'];
require $GLOBALS['LOF_SERVER_urlPhp'] . '/plugins/lof/popup.php';
//GOOD
$bdd = LOF_connect();
$req = $bdd->prepare('INSERT INTO ' . $GLOBALS['LOF_BDD_TABLE_forums'] . '(title, description, priority) VALUES(:title,:description,:priority)');
$req->execute(array('title' => $addTitle, 'description' => $addDescription, 'priority' => $addPriority));
LOF_successPopup("L'ajout est effectué !");
?>
<meta http-equiv="refresh" content="1">
<?php
}
' . $GLOBALS['LOF_BDD_TABLE_posts'] . '.id AS postId,
' . $GLOBALS['LOF_BDD_TABLE_account'] . '.id AS messageAuthorId
FROM ' . $GLOBALS['LOF_BDD_TABLE_posts'] . '
LEFT JOIN ' . $GLOBALS['LOF_BDD_TABLE_account'] . ' ON ' . $GLOBALS['LOF_BDD_TABLE_account'] . '.id=' . $GLOBALS['LOF_BDD_TABLE_posts'] . '.author
WHERE ' . $GLOBALS['LOF_BDD_TABLE_posts'] . '.id = ' . $_GET['postId'] . ' AND ' . $GLOBALS['LOF_BDD_TABLE_posts'] . '.pin = "' . $_GET['pin'] . '"';
$bdd = LOFConnect();
//BDD connect
$postData = $bdd->query($request);
$post = $postData->fetch();
if (!($post['messageAuthorId'] == $_SESSION['id'])) {
throw new Exception("Vous n'êtes pas l'auteur de ce message");
}
// Update post
$reqForum = $bdd->query('UPDATE ' . $GLOBALS['LOF_BDD_TABLE_posts'] . ' SET postState = 0 WHERE id = ' . $post['postId'] . ' AND pin = "' . $_GET['pin'] . '"');
$bdd = null;
LOF_successPopup("<strong>Le sujet est de nouveau ouvert !</strong> Vous pouvez maintenant répondre au sujet.");
?>
<noscript><META http-equiv="refresh" content="2;URL=/forum/post.php?id=<?php
echo $_GET['postId'];
?>
&page=1"></noscript>
<?php
} catch (Exception $e) {
header("HTTP/1.0 500 Internal Server Error");
echo "Erreur interne : la lecture du message à échouée.";
die;
}
?>
//Password
if (!($registrationPassword == $registrationPassword_again)) {
throw new Exception('Les mots de passe ne sont pas identiques.');
}
$req = $bdd->prepare('INSERT INTO ' . $GLOBALS['LOF_BDD_TABLE_account'] . '(rank, pseudo, password, email, created, lastlogin) VALUES(:rank,:pseudo,:password,:email,:created,:lastlogin)');
$req->execute(array('rank' => 0, 'pseudo' => $registrationName, 'password' => $registrationPassword, 'email' => $minEmail, 'created' => $date->format('Y-m-d'), 'lastlogin' => $date->format('Y-m-d')));
//Generate Avatar
$avatar = imagecreate(170, 170);
//Colors list
$colorsList = array(imagecolorallocate($avatar, 255, 128, 0), imagecolorallocate($avatar, 192, 57, 43), imagecolorallocate($avatar, 26, 188, 156), imagecolorallocate($avatar, 142, 68, 173), imagecolorallocate($avatar, 41, 128, 185), imagecolorallocate($avatar, 39, 174, 96), imagecolorallocate($avatar, 241, 196, 15), imagecolorallocate($avatar, 108, 122, 137));
$white = imagecolorallocate($avatar, 255, 255, 255);
//Foreground Color
$font = '../css/OpenSans-Light.ttf';
$size = imagettfbbox(44, 0, $font, strtoupper(substr($registrationName, 0, 1)));
$c = $size[4] - $size[6];
$d = $size[3] - $size[5];
$x = (170 - $d) / 2;
$y = (170 + $c) / 2;
imagefill($avatar, 0, 0, $colorsList[array_rand($colorsList)]);
imagettftext($avatar, 44, 0, $x, $y, $white, $font, strtoupper(substr($registrationName, 0, 1)));
//Write Pseudo
imagepng($avatar, "avatar/" . $bdd->lastInsertId() . ".png");
//Save avatar
LOF_successPopup("Bravo, votre compte est maintenant disponible !");
} catch (Exception $e) {
LOF_errorPopup($e->getMessage());
}
}
?>
