public function indexAction()
{
$smarty = Zend_Registry::get('view');
$request = $this->getRequest();
$id = $request->getParam('id', 0);
if ($id > 0) {
$modelSousCategorie = $this->_getModel();
$modelSujet = $this->_getModelSujet();
$modelCompte = $this->_getModelCompte();
$modelCategorie = $this->_getModelCategorie();
$modelMessage = $this->_getModelMessage();
$modelLecture = $this->_getModelLecture();
$log = new SessionLAG();
if ($log->_getTypeConnected('superadmin') || $log->_getTypeConnected('admin') || $log->_getTypeConnected('joueur')) {
$login = $modelCompte->fetchEntryForum($log->_getUser());
} else {
$login = 0;
}
$nb = null;
$last_messages = null;
$lecture = null;
$sujets = $modelSujet->fetchEntryBySousCategorie($id);
foreach ($sujets as $s) {
$nb[$s['idSujet']]['reponses'] = $modelMessage->countEntriesBySujet($s['idSujet']) - 1;
$last_messages[$s['idSujet']] = $modelMessage->fetchEntryLastBySujet($s['idSujet']);
if ($log->_getTypeConnected('superadmin') || $log->_getTypeConnected('admin') || $log->_getTypeConnected('joueur')) {
$lecture[$s['idSujet']] = $modelLecture->fetchEntriesByCompteAndSujet($log->_getUser(), $s['idSujet']);
}
}
$souscat = $modelSousCategorie->fetchEntryL($id);
$categorie = $modelCategorie->fetchEntryField($souscat['idCategorie'], array('idCategorie', 'titre', 'admin'));
$fil_arianne['cat'] = array('id' => $categorie['idCategorie'], 'nom' => $categorie['titre'], 'admin' => $categorie['admin']);
$fil_arianne['sscat'] = array('id' => $souscat['idSousCategorie'], 'nom' => $souscat['titre'], 'admin' => $categorie['admin']);
$smarty->assign('lecture', $lecture);
$smarty->assign('fil_arianne', $fil_arianne);
$smarty->assign('nb', $nb);
$smarty->assign('last_messages', $last_messages);
$smarty->assign('base_url', $request->getBaseUrl());
$smarty->assign('sujets', $sujets);
$smarty->assign('login', $login);
$smarty->assign('souscat', $souscat);
$smarty->assign('url_addsujet', $request->getBaseUrl() . '/sujet/form?idSsCat=' . $id);
$smarty->assign('url_viewsujet', $request->getBaseUrl() . '/sujet/index?id=');
$smarty->display('forum/souscategorie/index.tpl');
} else {
return $this->_helper->redirector('index', 'forum');
}
}
public function clotureAction()
{
$log = new SessionLAG();
$request = $this->getRequest();
$idSujet = (int) $request->getParam('id', 0);
$a = (int) $request->getParam('a', 0);
$model = $this->_getModel();
$sujet = $model->fetchEntryAuteur($idSujet);
//if($log->_getTypeConnected('admin')||$log->_getTypeConnected('superadmin')) {
if ($a == 1) {
if ($log->_getTypeConnected('superadmin') || $log->_getTypeConnected('admin') && ($sujet['nom'] == 'joueur' || $sujet['nom'] == 'admin') || $log->_getUser() == $sujet['idCompte']) {
if ($idSujet > 0) {
$model->save($idSujet, array('bloque' => $a));
}
return $this->_redirect('/sujet?id=' . $idSujet);
}
} elseif ($a == 0) {
if ($log->_getTypeConnected('superadmin') || $log->_getTypeConnected('admin') && ($sujet['nom'] == 'joueur' || $log->_getUser() == $sujet['idCompte'])) {
if ($idSujet > 0) {
$model->save($idSujet, array('bloque' => $a));
}
return $this->_redirect('/sujet?id=' . $idSujet);
}
} else {
$smarty->display('error/errorconnexion.tpl');
}
}
public function delavatarAction()
{
$log = new SessionLAG();
if ($log->_getTypeConnected('admin') || $log->_getTypeConnected('superadmin') || $log->_getTypeConnected('joueur')) {
$id = $log->_getUser();
$model = $this->_getModel();
$compte = $model->fetchEntry($id);
$compte['img'] = "no_logo.png";
$model->save($id, $compte);
}
return $this->_helper->redirector('form', 'compte');
}
public function indexAction()
{
$smarty = Zend_Registry::get('view');
$request = $this->getRequest();
$id = $request->getParam('id', 0);
if ($id > 0) {
$modelSousCategorie = $this->_getModelSousCategorie();
$modelSujet = $this->_getModelSujet();
$modelCompte = $this->_getModelCompte();
$modelCategorie = $this->_getModel();
$modelMessage = $this->_getModelMessage();
$modelLecture = $this->_getModelLecture();
$log = new SessionLAG();
if ($log->_getTypeConnected('superadmin') || $log->_getTypeConnected('admin') || $log->_getTypeConnected('joueur')) {
$login = $modelCompte->fetchEntryForum($log->_getUser());
} else {
$login = 0;
}
$lecture = null;
$categorie = $modelCategorie->fetchEntryField($id, array('idCategorie', 'titre', 'admin'));
if ($log->_getTypeConnected('superadmin') || $log->_getTypeConnected('admin')) {
$sscat = $modelSousCategorie->fetchEntryByCategorieAdminField($id, array('idSousCategorie', 'titre'));
$stats['nb_messages'] = $modelMessage->countEntries();
$stats['nb_sujets'] = $modelSujet->countEntries();
$stats['nb_sscat'] = $modelSousCategorie->countEntries();
$stats['nb_cat'] = $modelCategorie->countEntries();
} else {
$sscat = $modelSousCategorie->fetchEntryByCategorieField($id, array('idSousCategorie', 'titre'));
$stats['nb_messages'] = $modelMessage->countEntriesNonAdmin();
$stats['nb_sujets'] = $modelSujet->countEntriesNonAdmin();
$stats['nb_sscat'] = $modelSousCategorie->countEntriesNonAdmin();
$stats['nb_cat'] = $modelCategorie->countEntriesNonAdmin();
}
$nb = null;
$last_messages = null;
foreach ($sscat as $sc) {
$nb[$sc['idSousCategorie']]['nb_sujets'] = $modelSujet->countEntriesbySousCategorie($sc['idSousCategorie']);
$nb_message = $modelMessage->countEntriesbySsCat($sc['idSousCategorie']);
$nb[$sc['idSousCategorie']]['nb_reponses'] = $nb_message - $nb[$sc['idSousCategorie']]['nb_sujets'];
$last_messages[$sc['idSousCategorie']] = $modelMessage->fetchEntryLast($sc['idSousCategorie']);
$lecture[$sc['idSousCategorie']] = 1;
if (($log->_getTypeConnected('superadmin') || $log->_getTypeConnected('admin') || $log->_getTypeConnected('joueur')) && $nb[$sc['idSousCategorie']]['nb_sujets'] != 0) {
$lecture[$sc['idSousCategorie']] = $modelLecture->fetchEntriesByCompteAndSousCategorie($log->_getUser(), $sc['idSousCategorie']);
if ($nb[$sc['idSousCategorie']]['nb_sujets'] > $lecture[$sc['idSousCategorie']]) {
$lecture[$sc['idSousCategorie']] = 0;
}
}
}
$fil_arianne['cat'] = array('id' => $categorie['idCategorie'], 'nom' => $categorie['titre']);
// Recuperation Stats Forum
$stats['nb'] = $modelCompte->countEntriesActif();
$stats['last'] = $modelCompte->fetchEntryLast();
$smarty->assign('lecture', $lecture);
$smarty->assign('fil_arianne', $fil_arianne);
$smarty->assign('base_url', $request->getBaseUrl());
$smarty->assign('login', $login);
$smarty->assign('categorie', $categorie);
$smarty->assign('sscat', $sscat);
$smarty->assign('stats', $stats);
$smarty->assign('last_messages', $last_messages);
$smarty->assign('nb', $nb);
$smarty->assign('url_viewsc', $request->getBaseUrl() . '/souscategorie?id=');
$smarty->display('forum/categorie/index.tpl');
} else {
return $this->_helper->redirector('index', 'forum');
}
}
public function ajoutjeuAction()
{
$smarty = Zend_Registry::get('view');
$log = new SessionLAG();
if ($log->_getTypeConnected('joueur')) {
$request = $this->getRequest();
$modelLan = $this->_getModelLan();
$modelLanJoueur = $this->_getModelLanJoueur();
$modelLanJeuxJoueurTeam = $this->_getModelLanJeuxJoueurTeam();
$id = $log->_getUser();
$lan = $modelLan->fetchEntryOuverte();
$lanjoueur = $modelLanJoueur->fetchEntriesByLanAndJoueur($lan['idLan'], $id);
$jeux = $modelLanJeuxJoueurTeam->fetchEntriesJeuxNonRattaches($lanjoueur['idLanJoueur']);
$team = $modelLanJeuxJoueurTeam->fetchEntriesByLanJoueur($lanjoueur['idLanJoueur']);
$smarty->assign('test', $team);
$form = $this->_getModificationInscriptionLanForm();
$jeux_libres = $modelLanJeuxJoueurTeam->fetchEntriesJeuxLibresByLanJoueur($lan['idLan'], $log->_getUser());
if (sizeof($jeux_libres) > 0) {
$form->RemplirJeux($jeux, true);
} else {
$form->RemplirJeux($jeux, false);
}
if ($this->getRequest()->isPost()) {
if ($form->isValid($request->getPost())) {
$dataform = $form->getValues();
$team = $modelLanJeuxJoueurTeam->fetchEntriesByLanJoueur($lanjoueur['idLanJoueur']);
$ljjt['idLanJoueur'] = $lanjoueur['idLanJoueur'];
$ljjt['idTeam'] = $team[0]['idTeam'];
// Sauvegarde les jeux choisis pour cette lan
foreach ($dataform['jeux'] as $j) {
$ljjt['idJeux'] = $j;
$modelLanJeuxJoueurTeam->save(0, $ljjt);
}
return $this->_helper->redirector('indexjoueur', 'lan', '', array('id' => $lan['idLan']));
}
}
$smarty->assign('jeux', $jeux);
$smarty->assign('form', $form);
$smarty->assign('lan', $lan);
$smarty->display('inscription/ajoutjeu.tpl');
} else {
$smarty->display('error/errorconnexion.tpl');
}
}
public function formAction()
{
$smarty = Zend_Registry::get('view');
$log = new SessionLAG();
if ($log->_getTypeConnected('admin') || $log->_getTypeConnected('superadmin')) {
$request = $this->getRequest();
$id = (int) $request->getParam('id', 0);
$form = $this->_getNewsletterForm($id);
$model = $this->_getModel();
$modelType = $this->_getModelType();
$types = $modelType->fetchEntries();
$form->RemplirType($types);
if ($this->getRequest()->isPost()) {
if ($form->isValid($request->getPost())) {
$dataform = $form->getValues();
$dataform['idAdmin'] = $log->_getUser();
$model->save($id, $dataform);
if (!empty($dataform['img'])) {
$nom_image = $dataform["titre"];
require_once '../library/My/Utils.php';
$chaine_valide = valideChaine($nom_image);
$ext = explode('.', $dataform["img"]);
$ancien_nom = $dataform['img'];
$dataform['img'] = $chaine_valide . '.' . $ext[1];
require_once '../library/My/PhpThumb/ThumbLib.inc.php';
$thumb = PhpThumbFactory::create('../www/images/newsletter/tmp/' . $ancien_nom);
$thumb->resize(400, 400)->save('../www/images/newsletter/' . $dataform["img"]);
if (file_exists('../www/images/newsletter/tmp/' . $ancien_nom)) {
unlink('../www/images/newsletter/tmp/' . $ancien_nom);
}
}
$this->sendMail($dataform);
return $this->_helper->redirector('indexadmin');
}
} else {
if ($id > 0) {
$data = $model->fetchEntry($id);
$form->populate($data);
}
}
if ($id > 0) {
$smarty->assign('title', 'Lire Newsletter');
} else {
$smarty->assign('title', 'Envoyer Newsletter');
}
$smarty->assign('form', $form);
$smarty->display('newsletter/form.tpl');
} else {
$smarty->display('error/errorconnexion.tpl');
}
}
public function formAction()
{
$smarty = Zend_Registry::get('view');
$log = new SessionLAG();
if ($log->_getTypeConnected('admin') || $log->_getTypeConnected('superadmin') || $log->_getTypeConnected('joueur')) {
$request = $this->getRequest();
$id = (int) $request->getParam('id', 0);
$idSujet = (int) $request->getParam('idSujet', 0);
if ($id == 0) {
Zend_Registry::set('modeform', 'ajout');
} else {
Zend_Registry::set('modeform', 'modif');
}
$form = $this->_getMessageForm($id, $idSujet);
$modelMessage = $this->_getModelMessage();
$modelCompte = $this->_getModelCompte();
$modelGrade = $this->_getModelGrade();
$modelLecture = $this->_getModelLecture();
$modelSujet = $this->_getModel();
if ($this->getRequest()->isPost()) {
if ($form->isValid($request->getPost())) {
$dataform = $form->getValues();
$dataform['idSujet'] = $idSujet;
if ($id == 0) {
$dataform['idCompte'] = $log->_getUser();
} else {
$dataform['date_edition'] = date('Y-m-d H:i:s');
$dataform['auteur_edition'] = $log->_getUser();
}
$modelMessage->save($id, $dataform);
$nb_messages = $modelMessage->countEntriesByCompte($log->_getUser());
if ($log->_getTypeConnected('joueur') && $nb_messages != -1) {
$new_grade = $modelGrade->fetchEntryByNbMessages($nb_messages);
$compte['idGrade'] = $new_grade['idGrade'];
$modelCompte->save($log->_getUser(), $compte);
}
$modelLecture->deleteBySujetNotCompte($idSujet, $log->_getUser());
return $this->_redirect('/sujet?id=' . $idSujet);
}
} else {
if ($id > 0) {
$data = $modelMessage->fetchEntry($id);
if ($log->_getTypeConnected('superadmin') || $data['idCompte'] == $log->_getUser()) {
$form->populate($data);
} else {
$smarty->display('error/errorconnexion.tpl');
return $this->_redirect('/sujet?id=' . $idSujet);
}
}
}
if ($id > 0) {
$smarty->assign('title', 'Modification Message');
} else {
$smarty->assign('title', 'Ajout Message');
}
$sujet = $modelSujet->fetchEntryField($idSujet, array('idSujet', 'titre', 'date_s'));
$messages = $modelMessage->fetchEntryBySujet($idSujet, 'date_m DESC');
$compte = $modelMessage->fetchEntryCompteBySujet($idSujet);
foreach ($compte as $c) {
$comptes[$c['idCompte']] = $modelCompte->fetchEntryForum($c['idCompte']);
$comptes[$c['idCompte']]['nb_messages'] = $modelMessage->countEntriesByCompte($c['idCompte']);
}
$smarty->assign('comptes', $comptes);
$smarty->assign('messages', $messages);
$smarty->assign('base_url', $request->getBaseUrl());
$smarty->assign('sujet', $sujet);
$smarty->assign('form', $form);
$smarty->display('forum/message/form.tpl');
} else {
$smarty->display('error/errorconnexion.tpl');
}
}
public function indexjoueurAction()
{
$smarty = Zend_Registry::get('view');
$log = new SessionLAG();
if ($log->_getTypeConnected('joueur')) {
$request = $this->getRequest();
$smarty->assign('baseurl', $request->getBaseUrl());
$modelLanJoueur = $this->_getModelLanJoueur();
$model = $this->_getModel();
$id = $request->getParam('id', 0);
if ($id == 0) {
$lans = $modelLanJoueur->fetchEntriesByJoueur($log->_getUser());
$smarty->assign('lans', $lans);
$smarty->assign('title', 'Mes Lans');
$smarty->display('lan/indexJoueur.tpl');
} else {
$modelLanJeux = $this->_getModelLanJeux();
$modelLanJeuxJoueurTeam = $this->_getModelLanJeuxJoueurTeam();
$modelCompte = $this->_getModelCompte();
$modelConfig = $this->_getModelConfig();
$lan = $model->fetchEntryField($id, array('idLan', 'nom', 'adresse', 'ville', 'cp', 'adresse', 'datedeb'));
$joueur = $modelCompte->fetchEntryField($log->_getUser(), array('ville', 'cp'));
// recuperation des jeus o� le joueur s'est inscrit
$jeux = $modelLanJeuxJoueurTeam->fetchEntriesJeuxByLan($id, $log->_getUser());
$jeux_libres = $modelLanJeuxJoueurTeam->fetchEntriesJeuxLibresByLanJoueur($id, $log->_getUser());
if (sizeof($jeux_libres) > 0) {
$jeuxlibres = 1;
} else {
$jeuxlibres = 0;
}
// API Google Map v3
require APPLICATION_PATH . '/../library/My/GoogleMapAPI.class.php';
$map = new GoogleMapAPI();
$map->setMapType('ROADMAP');
$map->setDivId('googlemap');
// fixe les dimensions de la carte
$map->setSize('830px', '500px');
// definition du zoom automatique
$map->setEnableAutomaticCenterZoom(true);
// gestion de l'itineraire
$map->addDirection($joueur['ville'] . ' ' . $joueur['cp'], $lan['adresse'] . ' ' . $lan['ville'] . ' ' . $lan['cp']);
$map->setDisplayDirectionFields(true);
$map->setDirectionDivId('route');
$map->generate();
$smarty->assign('jeux_libres', $jeuxlibres);
$smarty->assign('title', 'Lan ' . $lan['nom']);
$smarty->assign('map', $map);
$smarty->assign('lan', $lan);
$smarty->assign('jeux', $jeux);
$smarty->assign('urladdjeu', $request->getBaseUrl() . '/inscription/ajoutjeu');
$smarty->display('lan/indexJoueurLan.tpl');
}
} else {
$smarty->assign('message', 'Erreur Connexion');
$smarty->display('error/errorconnexion.tpl');
}
}
public function indexAction()
{
$smarty = Zend_Registry::get('view');
$modelConfig = $this->_getModelConfig();
$forum_ouvert = $modelConfig->fetchEntrySetting('ouverture_forum');
if ($forum_ouvert['valeur'] == 1) {
$request = $this->getRequest();
$modelCategorie = $this->_getModelCategorie();
$modelSousCategorie = $this->_getModelSousCategorie();
$modelSujet = $this->_getModelSujet();
$modelMessage = $this->_getModelMessage();
$modelCompte = $this->_getModelCompte();
$modelLecture = $this->_getModelLecture();
$forum_ouvert['valeur'] = 0;
$nb = null;
$last_messages = null;
$sscat = null;
$log = new SessionLAG();
if ($log->_getTypeConnected('superadmin') || $log->_getTypeConnected('admin') || $log->_getTypeConnected('joueur')) {
$login = $modelCompte->fetchEntryForum($log->_getUser());
} else {
$login = 0;
}
if ($log->_getTypeConnected('superadmin') || $log->_getTypeConnected('admin')) {
$categories = $modelCategorie->fetchEntriesVisiblesAdmin();
$stats['nb_messages'] = $modelMessage->countEntries();
$stats['nb_sujets'] = $modelSujet->countEntries();
$stats['nb_sscat'] = $modelSousCategorie->countEntries();
$stats['nb_cat'] = $modelCategorie->countEntries();
} else {
$categories = $modelCategorie->fetchEntriesVisibles();
$stats['nb_messages'] = $modelMessage->countEntriesNonAdmin();
$stats['nb_sujets'] = $modelSujet->countEntriesNonAdmin();
$stats['nb_sscat'] = $modelSousCategorie->countEntriesNonAdmin();
$stats['nb_cat'] = $modelCategorie->countEntriesNonAdmin();
}
foreach ($categories as $cat) {
$forum_ouvert['valeur'] = 1;
if ($log->_getTypeConnected('superadmin') || $log->_getTypeConnected('admin')) {
$sscat[$cat['idCategorie']] = $modelSousCategorie->fetchEntryByCategorieVisiblesAdmin($cat['idCategorie']);
} else {
$sscat[$cat['idCategorie']] = $modelSousCategorie->fetchEntryByCategorieVisibles($cat['idCategorie']);
}
foreach ($sscat[$cat['idCategorie']] as $sc) {
$nb[$sc['idSousCategorie']]['nb_sujets'] = $modelSujet->countEntriesbySousCategorie($sc['idSousCategorie']);
$nb_message = $modelMessage->countEntriesbySsCat($sc['idSousCategorie']);
$nb[$sc['idSousCategorie']]['nb_reponses'] = $nb_message - $nb[$sc['idSousCategorie']]['nb_sujets'];
$last_messages[$sc['idSousCategorie']] = $modelMessage->fetchEntryLast($sc['idSousCategorie']);
$lecture[$sc['idSousCategorie']] = 1;
if (($log->_getTypeConnected('superadmin') || $log->_getTypeConnected('admin') || $log->_getTypeConnected('joueur')) && $nb[$sc['idSousCategorie']]['nb_sujets'] != 0) {
$lecture[$sc['idSousCategorie']] = $modelLecture->fetchEntriesByCompteAndSousCategorie($log->_getUser(), $sc['idSousCategorie']);
if ($nb[$sc['idSousCategorie']]['nb_sujets'] > $lecture[$sc['idSousCategorie']]) {
$lecture[$sc['idSousCategorie']] = 0;
}
}
}
}
// Recuperation Stats Forum
$stats['nb'] = $modelCompte->countEntriesActif();
$stats['last'] = $modelCompte->fetchEntryLast();
$stats['log'] = $modelCompte->fetchEntriesLogField(time() - 900, array('idCompte', 'login'));
$smarty->assign('lecture', $lecture);
$smarty->assign('sscat', $sscat);
$smarty->assign('login', $login);
$smarty->assign('last_messages', $last_messages);
$smarty->assign('url_cat', $request->getBaseUrl() . '/categorie?id=');
$smarty->assign('url_sscat', $request->getBaseUrl() . '/souscategorie?id=');
$smarty->assign('nb', $nb);
$smarty->assign('stats', $stats);
$smarty->assign('categories', $categories);
$smarty->assign('base_url', $request->getBaseUrl());
}
$smarty->assign('forum_ouvert', $forum_ouvert);
$smarty->display('forum/index.tpl');
}
