コード例 #1
0
ファイル: Del.php プロジェクト: FMaz008/ccv4
 public static function delete($userId)
 {
     $dbMgr = DbManager::getInstance();
     //Instancier le gestionnaire
     $db = $dbMgr->getConn('game');
     //Demander la connexion existante
     //Suppression de tous les perso du compte
     $query = 'SELECT id' . ' FROM ' . DB_PREFIX . 'perso' . ' WHERE userId=:id;';
     $prep = $db->prepare($query);
     $prep->bindValue(':id', $userId, PDO::PARAM_INT);
     $prep->executePlus($db, __FILE__, __LINE__);
     $arr = $prep->fetchAll();
     $prep->closeCursor();
     $prep = NULL;
     foreach ($arr as &$perso) {
         Mj_Perso_Del::delete($perso['id']);
     }
     //suppression du compte
     $query = 'DELETE FROM ' . DB_PREFIX . 'account' . ' WHERE id=:id' . ' LIMIT 1;';
     $prep = $db->prepare($query);
     $prep->bindValue(':id', $userId, PDO::PARAM_INT);
     $prep->executePlus($db, __FILE__, __LINE__);
     $prep->closeCursor();
     $prep = NULL;
 }
コード例 #2
0
ファイル: DelPerso2.php プロジェクト: FMaz008/ccv4
 public static function generatePage(&$tpl, &$session, &$account)
 {
     $dbMgr = DbManager::getInstance();
     //Instancier le gestionnaire
     $db = $dbMgr->getConn('game');
     //Demander la connexion existante
     if (!isset($_GET['id']) || !isset($_POST['yes'])) {
         return fctErrorMSG('Données requises manquantes. (cheat)');
     }
     if ($session->getVar('persoId') == $_GET['id']) {
         $session->setVar('persoId', NULL);
     }
     //Trouver les informations sur le perso / Valider s'il est authorisé à être modifié
     $query = 'SELECT id' . ' FROM ' . DB_PREFIX . 'perso' . ' WHERE id=:persoId' . ' AND userid=:userId' . ' AND inscription_valide="mod"' . ' LIMIT 1;';
     $prep = $db->prepare($query);
     $prep->bindValue(':persoId', $_GET['id'], PDO::PARAM_INT);
     $prep->bindValue(':userId', $account->getId(), PDO::PARAM_INT);
     $prep->executePlus($db, __FILE__, __LINE__);
     $arr = $prep->fetch();
     $prep->closeCursor();
     $prep = NULL;
     if ($arr === false) {
         return fctErrorMSG('Ce personnage n\'existe pas, ne vous appartiend pas, ou n\'est pas en phase de refus. (cheat)');
     }
     //Apeller la fonction qui gère la suppression de perso.
     Mj_Perso_Del::delete($_GET['id'], $account->getUser());
     //Augmenter le nombre de création de perso de 1
     $query = 'UPDATE ' . DB_PREFIX . 'account' . ' SET auth_creation_perso=auth_creation_perso+1' . ' WHERE id=:userId' . ' LIMIT 1;';
     $prep = $db->prepare($query);
     $prep->bindValue(':userId', $account->getId(), PDO::PARAM_INT);
     $prep->executePlus($db, __FILE__, __LINE__);
     //Retourner le template complété/rempli
     $tpl->set('PAGE', 'News');
     return $tpl->fetch($account->getSkinRemotePhysicalPath() . 'html/Member/redirect.htm', __FILE__, __LINE__);
 }
コード例 #3
0
ファイル: index.php プロジェクト: FMaz008/ccv4
 private static function doInscription(&$tpl, &$account, &$mj)
 {
     $dbMgr = DbManager::getInstance();
     //Instancier le gestionnaire
     $db = $dbMgr->getConn('game');
     //Demander la connexion existante
     $query = 'SELECT p.*, a.email, a.id as aid' . ' FROM ' . DB_PREFIX . 'perso as p' . ' LEFT JOIN ' . DB_PREFIX . 'account as a ON (a.id=p.userId)' . ' WHERE p.inscription_valide="0";';
     $prep = $db->prepare($query);
     $prep->executePlus($db, __FILE__, __LINE__);
     $arrAll = $prep->fetchAll();
     $prep->closeCursor();
     $prep = NULL;
     foreach ($arrAll as &$arrInscr) {
         //Accepter l'inscription
         if ($_POST['inscr_' . $arrInscr['id']] == 'ok') {
             //Activer le perso
             $query = 'UPDATE ' . DB_PREFIX . 'perso' . ' SET `inscription_valide`="1",' . ' `pa` = `pamax`,' . ' `lieu`=:lieu_depart' . ' WHERE id = :id' . ' LIMIT 1;';
             $prep = $db->prepare($query);
             $prep->bindValue('id', $arrInscr['id']);
             $prep->bindValue('lieu_depart', LIEU_DEPART);
             $prep->executePlus($db, __FILE__, __LINE__);
             $prep->closeCursor();
             $prep = NULL;
             //Ajouter le message d'accueil dans le HE
             $query = 'SELECT db_param' . ' FROM ' . DB_PREFIX . 'item_db' . ' WHERE db_id=9' . ' LIMIT 1;';
             $prep = $db->prepare($query);
             $prep->executePlus($db, __FILE__, __LINE__);
             $arr = $prep->fetch();
             $prep->closeCursor();
             $prep = NULL;
             Member_He::add('Douanier', $arrInscr['id'], 'msg', stripslashes($arr['db_param']));
             //Ajouter&equiper les items de bienvenu
             $query = 'SELECT db_id, db_resistance' . ' FROM `' . DB_PREFIX . 'item_db`' . ' WHERE `db_id` IN(309, 310, 311);';
             $prep = $db->prepare($query);
             $prep->executePlus($db, __FILE__, __LINE__);
             $arrAll = $prep->fetchAll();
             $prep->closeCursor();
             $prep = NULL;
             $query = 'INSERT INTO `' . DB_PREFIX . 'item_inv`' . ' (`inv_id`,	`inv_dbid`,	`inv_persoid`,' . ' `inv_equip`,`inv_qte`,	`inv_resistance`)' . ' VALUES' . ' (' . ' NULL, 	:db_id, 	:persoId,' . ' "1", 	1,			:resistance' . ' );';
             $prep = $db->prepare($query);
             foreach ($arrAll as &$arr) {
                 $prep->bindValue('db_id', $arr['db_id'], PDO::PARAM_INT);
                 $prep->bindValue('persoId', $arrInscr['id'], PDO::PARAM_INT);
                 $prep->bindValue('resistance', $arr['db_resistance'], PDO::PARAM_INT);
                 $prep->executePlus($db, __FILE__, __LINE__);
             }
             $prep->closeCursor();
             $prep = NULL;
             //Envoie du email :
             $tpl->set('COMMENTAIRE', $_POST['inscr_commentaire_' . $arrInscr['id']]);
             $tpl->set('MJ_EMAIL', $mj->getEmail());
             $MSG = $tpl->fetch($account->getSkinRemotePhysicalPath() . 'html/Mj/emailPersoAccepte.htm', __FILE__, __LINE__);
             mail($arrInscr['email'], "Cybercity 2034", $MSG, "From: robot@cybercity2034.com\n" . "MIME-Version: 1.0\n" . "Content-type: text/html; charset=iso-8859-1\n");
         }
         //Refuser l'inscription
         if ($_POST['inscr_' . $arrInscr['id']] == 'mod') {
             //Rendre le perso modifiable
             $query = 'UPDATE ' . DB_PREFIX . 'perso' . ' SET inscription_valide="mod"' . ' WHERE id = :persoId' . ' LIMIT 1;';
             $prep = $db->prepare($query);
             $prep->bindValue('persoId', $arrInscr['id'], PDO::PARAM_INT);
             $prep->executePlus($db, __FILE__, __LINE__);
             $prep->closeCursor();
             $prep = NULL;
             //Ajouter un message dans le HE (qui sera affiché en haut de la page de modification
             Member_He::add($mj->getNom(), $arrInscr['id'], 'inscription', $_POST['inscr_commentaire_' . $arrInscr['id']]);
             //Envoie du email :
             $tpl->set('COMMENTAIRE', $_POST['inscr_commentaire_' . $arrInscr['id']]);
             $tpl->set('MJ_EMAIL', $mj->getEmail());
             $MSG = $tpl->fetch($account->getSkinRemotePhysicalPath() . 'html/Mj/emailPersoRefuse.htm', __FILE__, __LINE__);
             mail($arrInscr['email'], "Cybercity 2034", $MSG, "From: robot@cybercity2034.com\n" . "MIME-Version: 1.0\n" . "Content-type: text/html; charset=iso-8859-1\n");
         }
         //Supprimer l'inscription
         if ($_POST['inscr_' . $arrInscr['id']] == 'suppr') {
             //Supprimer le perso
             Mj_Perso_Del::delete($arrInscr['id'], $mj->getNom());
             //Redonner la chance d'effectuer une inscription
             $query = 'UPDATE ' . DB_PREFIX . 'account' . ' SET auth_creation_perso= auth_creation_perso+1' . ' WHERE id=:accountId' . ' LIMIT 1;';
             $prep = $db->prepare($query);
             $prep->bindValue('accountId', $arrInscr['aid'], PDO::PARAM_INT);
             $prep->executePlus($db, __FILE__, __LINE__);
             $prep->closeCursor();
             $prep = NULL;
             //Envoie du email :
             $tpl->set('COMMENTAIRE', $_POST['inscr_commentaire_' . $arrInscr['id']]);
             $tpl->set('MJ_EMAIL', $mj->getEmail());
             $MSG = $tpl->fetch($account->getSkinRemotePhysicalPath() . 'html/Mj/emailPersoSupprime.htm', __FILE__, __LINE__);
             mail($arrInscr['email'], "Cybercity 2034", $MSG, "From: robot@cybercity2034.com\n" . "MIME-Version: 1.0\n" . "Content-type: text/html; charset=utf-8\n");
         }
     }
 }
コード例 #4
0
ファイル: Innactif.php プロジェクト: BalamWeb/ccv4
 public static function go(&$account)
 {
     $dbMgr = DbManager::getInstance();
     //Instancier le gestionnaire
     $db = $dbMgr->getConn('game');
     //Demander la connexion existante
     $nextnow = mktime(date("H") - INNACTIVITE_TELEPORT_DELAY, date("i"), date("s"), date("m"), date("d"), date("Y"));
     $delExpir = mktime(date("H"), date("i"), date("s"), date("m"), date("d") - INNACTIVITE_DELETE_DELAY, date("Y"));
     try {
         //Trouver les innactifs
         $query = 'SELECT p.id' . ' FROM ' . DB_PREFIX . 'perso as p, ' . DB_PREFIX . 'account as a' . ' WHERE a.last_conn<:expiration' . ' AND p.userId = a.id' . ' AND p.lieu!=:lieu' . ' AND p.lieu!=:lieuVac' . ' LIMIT 5;';
         $prep = $db->prepare($query);
         $prep->bindValue('expiration', $nextnow, PDO::PARAM_INT);
         $prep->bindValue('lieu', INNACTIVITE_TELEPORT_LOCATION, PDO::PARAM_STR);
         $prep->bindValue('lieuVac', INNACTIVITE_VOLUNTARY_LOCATION, PDO::PARAM_STR);
         $prep->execute($db, __FILE__, __LINE__);
         $arrPerso = $prep->fetchAll();
         $prep->closeCursor();
         $prep = NULL;
         if (count($arrPerso) == 0) {
             return;
         }
         //Ne pas essayer de supprimer des perso, on le fera au prochain innactif
         $query = 'UPDATE ' . DB_PREFIX . 'perso' . ' SET lieu=:lieu' . ' WHERE id=:persoId;';
         $prep = $db->prepare($query);
         foreach ($arrPerso as &$id) {
             $id = (int) $id[0];
             //Téléporter les innactifs
             $prep->bindValue('lieu', INNACTIVITE_TELEPORT_LOCATION, PDO::PARAM_STR);
             $prep->bindValue('persoId', $id, PDO::PARAM_INT);
             $prep->execute($db, __FILE__, __LINE__);
             Member_He::add('System', $id, 'innact', 'Votre personnage a été téléporté pour inactivité.');
         }
         $prep->closeCursor();
         $prep = NULL;
     } catch (Exception $e) {
         fctBugReport('Erreur', $e->getMessage(), __FILE__, __LINE__);
     }
     try {
         //Trouver les trop innactifs (les supprimer)
         $query = 'SELECT p.id, p.nom, a.email' . ' FROM ' . DB_PREFIX . 'perso as p, ' . DB_PREFIX . 'account as a' . ' WHERE a.last_conn<:expiration' . ' AND p.userId = a.id' . ' AND p.lieu != :lieuVac' . ' LIMIT 1;';
         $prep = $db->prepare($query);
         $prep->bindValue('expiration', $delExpir, PDO::PARAM_INT);
         $prep->bindValue('lieuVac', INNACTIVITE_VOLUNTARY_LOCATION, PDO::PARAM_STR);
         $prep->execute($db, __FILE__, __LINE__);
         $arrPerso = $prep->fetchAll();
         $prep->closeCursor();
         $prep = NULL;
         if (count($arrPerso) == 0) {
             return;
         }
         //Ne pas essayer de supprimer des perso, on le fera au prochain innactif
         foreach ($arrPerso as &$arr) {
             //Apeller la fonction qui gère la suppression de perso.
             Mj_Perso_Del::delete($arr['id'], 'system');
             $tpl = new Template($account);
             //Envoyer un email de bye bye
             $tpl->set('PERSO_NOM', stripslashes($arr['nom']));
             $MSG = $tpl->fetch($account->getSkinRemotePhysicalPath() . 'html/Visitor/innactivite_email.htm', __FILE__, __LINE__);
             $ret = @mail($arr['email'], "Cybercity 2034 - Suppression", $MSG, "From: robot@cybercity2034.com\n" . "MIME-Version: 1.0\n" . "Content-type: text/html; charset=utf-8\n");
         }
     } catch (Exception $e) {
         fctBugReport('Erreur', $e->getMessage(), __FILE__, __LINE__);
     }
 }