|
|
| PHP-Nuke France - Communauté Européenne: Forums |
|
|
ATTENTION
En téléchargeant une version de PHP-Nuke autre que celle que nous proposons, vous prenez la décision de ne pouvoir prétendre à aucun support sur nos Forums.
Vous êtes libre de faire vos propres choix mais nous ne pouvons accepter de faire le travail des autres.
Par conséquent et en connaissance de cause, toute question relative à une autre version que celle que nous nous sommes engagé à supporter sera transférée à la corbeille. Prenez 2 minutes pour prendre connaissance plus en détails de notre fonctionnement
| Voir le sujet précédent :: Voir le sujet suivant |
|
|
|
sebcas1
Novice
Inscrit le: Aug 10, 2003
Messages: 2
|
 Posté le: 12.04.2004, 16:35:10 Sujet du message: Aide pour Encyclopedia |
 |
|
Bonjour,
Je voudrais ajouter dans le module encyclopedia une requête. J'ai donc mis une nouvelle function dans l'index.php mais cela ne passe pas. Quelqu'un peut-il me venir en aide svp ?
J'ai donc rajouté ceci avant avant switch($op) { :
funtion cdf($cdf) {
echo 'Championnat de France<br>';
$requete=mysql_query("SELECT points FROM points, annee FROM saisons , nom FROM saisons, nuke_encyclopedia_text AS encyclo, divisions WHERE id_joueur FROM encyclo = points FROM id_joueur");
$total=0;
WHILE ($donnees = mysql_fetch_array ($requete) )
{
$total=$total+$donnees[0];
echo ' $donnees[1] $donnees[2] ($donnees[0] points)<br>'
}
}
et ça après après switch($op) { :
case "cdf":
cdf($cdf);
break;
Le fichier index.php ressemble à ça maintenant
| Code: | <?php
######################################################################
# PHP-NUKE: Web Portal System
# ===========================
#
# Copyright (c) 2002 by Francisco Burzi (fbc@mandrakesoft.com)
# http://phpnuke.org
#
# This program is free software. You can redistribute it and/or modify
# it under the terms of the GNU General Public License as published by
# the Free Software Foundation; either version 2 of the License.
######################################################################
if (!eregi("modules.php", $_SERVER['PHP_SELF'])) {
die ("You can't access this file directly...");
}
require_once("mainfile.php");
$module_name = basename(dirname(__FILE__));
get_lang($module_name);
$pagetitle = "- "._ENCYCLOPEDIA."";
function encysearch($eid) {
global $module_name;
echo "<center><form action=\"modules.php?name=$module_name&file=search\" method=\"post\">"
."<input type=\"text\" size=\"20\" name=\"query\"> "
."<input type=\"hidden\" name=\"eid\" value=\"$eid\">"
."<input type=\"submit\" value=\""._SEARCH."\">"
."</form>"
."</center>";
}
function alpha($eid) {
global $module_name, $prefix, $db;
echo "<center>"._ENCYSELECTLETTER."</center>";
$alphabet = array ("A","B","C","D","E","F","G","H","I","J","K","L","M",
"N","O","P","Q","R","S","T","U","V","W","X","Y","Z");
$num = count($alphabet) - 1;
echo "<center>[ ";
$counter = 0;
while (list(, $ltr) = each($alphabet)) {
$numrows = $db->sql_numrows($db->sql_query("SELECT * FROM ".$prefix."_encyclopedia_text WHERE eid='$eid' AND UPPER(title) LIKE '$ltr%'"));
if ($numrows > 0) {
echo "<a href=\"modules.php?name=$module_name&op=terms&eid=$eid<r=$ltr\">$ltr</a>";
} else {
echo "$ltr";
}
if ( $counter == round($num/2) ) {
echo " ]\n<br>\n[ ";
} elseif ( $counter != $num ) {
echo " | \n";
}
$counter++;
}
echo " ]</center><br>\n\n\n";
encysearch($eid);
echo "<center>"._GOBACK."</center>";
}
function list_content($eid) {
global $module_name, $prefix, $sitename, $db;
$sql = "SELECT title, description FROM ".$prefix."_encyclopedia WHERE eid='$eid'";
$result = $db->sql_query($sql);
$row = $db->sql_fetchrow($result);
$title = $row[title];
$description = $row[description];
include("header.php");
title("$title");
OpenTable3();
echo "<center><b>$title</b></center><br>"
."<p align=\"justify\">$description</p>";
CloseTable3();
echo "<br>";
OpenTable3();
alpha($eid);
CloseTable3();
echo "<br>";
OpenTable3();
CloseTable3();
include("footer.php");
}
function terms($eid, $ltr) {
global $module_name, $prefix, $sitename, $db, $admin;
$sql = "SELECT active FROM ".$prefix."_encyclopedia WHERE eid='$eid'";
$result = $db->sql_query($sql);
$row = $db->sql_fetchrow($result);
$active = $row[active];
$sql = "SELECT title FROM ".$prefix."_encyclopedia WHERE eid='$eid'";
$result = $db->sql_query($sql);
$row = $db->sql_fetchrow($result);
$title = $row[title];
include("header.php");
title("$title");
OpenTable3();
if (($active == 1) OR (is_admin($admin))) {
if (($active != 1) AND (is_admin($admin))) {
echo "<center>"._YOURADMINENCY."</center>";
}echo "<center>Selectionnez une lettre :</center>"
."<table border=\"0\" align=\"center\">";
$sql = "SELECT tid, title FROM ".$prefix."_encyclopedia_text WHERE UPPER(title) LIKE '$ltr%' AND eid='$eid'ORDER by title ASC";
$result = $db->sql_query($sql);
$numrows = $db->sql_numrows($result);
if ($numrows == 0) {
echo "<center><i>"._NOCONTENTFORLETTER." $ltr.</i></center>";
}
while ($row = $db->sql_fetchrow($result)) {
$tid = $row[tid];
$title = $row[title];
echo "<tr><td><a href=\"modules.php?name=$module_name&op=content&tid=$tid\">$title</a></td></tr>";
}
echo "</table>";
alpha($eid);
} else {
echo "<center>"._ENCYNOTACTIVE."<br>"
.""._GOBACK."</center>";
}
CloseTable3();
include("footer.php");
}
function content($tid, $ltr, $page=0, $query="") {
global $prefix, $db, $sitename, $admin, $module_name;
include("header.php");
OpenTable3();
$sql = "SELECT * FROM ".$prefix."_encyclopedia_text WHERE tid='$tid'";
$result = $db->sql_query($sql);
$ency = $db->sql_fetchrow($result);
$sql = "SELECT active FROM ".$prefix."_encyclopedia WHERE eid='$ency[eid]'";
$result = $db->sql_query($sql);
$row = $db->sql_fetchrow($result);
$active = $row[active];
if (($active == 1) OR ($active == 0 AND is_admin($admin))) {
$db->sql_query("UPDATE ".$prefix."_encyclopedia_text SET counter=counter+1 WHERE tid='$tid'");
$sql = "SELECT title FROM ".$prefix."_encyclopedia WHERE eid='$ency[eid]'";
$result = $db->sql_query($sql);
$row = $db->sql_fetchrow($result);
$enc_title = $row[title];
echo "<font class=\"title\">$ency[title]</font>";
$contentpages = explode( "<!--pagebreak-->", $ency[text] );
$pageno = count($contentpages);
if ( $page=="" || $page < 1 )
$page = 1;
if ( $page > $pageno )
$page = $pageno;
$arrayelement = (int)$page;
$arrayelement --;
if ($pageno > 1) {
echo ""._PAGE.": $page/$pageno<br>";
}
if (isset($query)) {
$contentpages[$arrayelement] = eregi_replace($query,"<b>$query</b>",$contentpages[$arrayelement]);
$fromsearch = "&query=$query";
} else {
$fromsearch = "";
}
echo "<p align=\"justify\">".nl2br($contentpages[$arrayelement])."</p>";
if($page >= $pageno) {
$next_page = "";
} else {
$next_pagenumber = $page + 1;
if ($page != 1) {
$next_page .= "- ";
}
$next_page .= "<a href=\"modules.php?name=$module_name&op=content&tid=$tid&page=$next_pagenumber$fromsearch\">"._NEXT." ($next_pagenumber/$pageno)</a> <a href=\"modules.php?name=$module_name&op=content&tid=$tid&page=$next_pagenumber\"><img src=\"images/download/right.gif\" border=\"0\" alt=\""._NEXT."\" title=\""._NEXT."\"></a>";
}
if($page <= 1) {
$previous_page = "";
} else {
$previous_pagenumber = $page - 1;
$previous_page = "<a href=\"modules.php?name=$module_name&op=content&tid=$tid&page=$previous_pagenumber$fromsearch\"><img src=\"images/download/left.gif\" border=\"0\" alt=\""._PREVIOUS."\" title=\""._PREVIOUS."\"></a> <a href=\"modules.php?name=$module_name&op=content&tid=$tid&page=$previous_pagenumber$fromsearch\">"._PREVIOUS." ($previous_pagenumber/$pageno)</a>";
}
if (is_admin($admin)) {
echo "<p align=\"right\">[ <a href=\"admin.php?op=encyclopedia_text_edit&tid=$ency[tid]\">"._EDIT."</a> ]</p>";
echo '<b>Championnat de France</b><br>';
}
} else {
echo "Sorry, This page isn't active...";
}
CloseTable3();
include("footer.php");
}
function list_themes() {
global $prefix, $db, $sitename, $admin, $multilingual, $module_name;
include("header.php");
title(""._ENCYCLOPEDIA."");
OpenTable3();
$sql = "SELECT eid, title, description, elanguage FROM ".$prefix."_encyclopedia WHERE active='1'";
$result = $db->sql_query($sql);
echo "<blockquote>";
while ($row = $db->sql_fetchrow($result)) {
$eid = $row[eid];
$title = $row[title];
$description = $row[description];
$elanguage = $row[elanguage];
if ($multilingual == 1) {
$the_lang = "<img src=\"images/language/flag-$elanguage.png\" hspace=\"3\" border=\"0\" height=\"10\" width=\"20\">";
} else {
$the_lang = "";
}
if ($subtitle != "") {
$subtitle = "<br>($description)<br>";
} else {
$subtitle = "";
}
if (is_admin($admin)) {
echo "<strong><big>·</big></strong> $the_lang <a href=\"modules.php?name=$module_name&op=list_content&eid=$eid\">$title</a><br>$description<br>[ <a href=\"admin.php?op=encyclopedia_edit&eid=$eid\">"._EDIT."</a> | <a href=\"admin.php?op=encyclopedia_change_status&eid=$eid&active=1\">"._DEACTIVATE."</a> | <a href=\"admin.php?op=encyclopedia_delete&eid=$eid\">"._DELETE."</a> ]<br>";
} else {
echo "<strong><big>·</big></strong> $the_lang <a href=\"modules.php?name=$module_name&op=list_content&eid=$eid\">$title</a><br> $description<br>";
}
}
echo "</blockquote>";
if (is_admin($admin)) {
$sql = "SELECT eid, title, description, elanguage FROM ".$prefix."_encyclopedia WHERE active='0'";
$result = $db->sql_query($sql);
echo "<br><center><b>"._YOURADMININACTIVELIST."</b></center><br>";
echo "<blockquote>";
while ($row = $db->sql_fetchrow($result)) {
$eid = $row[eid];
$title = $row[title];
$description = $row[description];
$elanguage = $row[elanguage];
if ($multilingual == 1) {
$the_lang = "<img src=\"images/language/flag-$elanguage.png\" hspace=\"3\" border=\"0\" height=\"10\" width=\"20\">";
} else {
$the_lang = "";
}
if ($subtitle != "") {
$subtitle = " ($subtitle) ";
} else {
$subtitle = " ";
}
echo "<strong><big>·</big></strong> $the_lang <a href=\"modules.php?name=$module_name&op=list_content&eid=$eid\">$title</a><br>$description<br>[ <a href=\"admin.php?op=encyclopedia_edit&eid=$eid\">"._EDIT."</a> | <a href=\"admin.php?op=encyclopedia_change_status&eid=$eid&active=0\">"._ACTIVATE."</a> | <a href=\"admin.php?op=encyclopedia_delete&eid=$eid\">"._DELETE."</a> ]<br>";
}
echo "</blockquote>";
}
CloseTable3();
include("footer.php");
}
funtion cdf($cdf) {
echo '<b>Championnat de France</b><br>';
$requete=mysql_query("SELECT points FROM points, annee FROM saisons , nom FROM saisons, nuke_encyclopedia_text AS encyclo, divisions WHERE id_joueur FROM encyclo = points FROM id_joueur");
$total=0;
WHILE ($donnees = mysql_fetch_array ($requete) )
{
$total=$total+$donnees[0];
echo '<b> $donnees[1] $donnees[2] ($donnees[0] points)<br>'
}
}
switch($op) {
case "cdf":
cdf($cdf);
break;
case "content":
content($tid, $ltr, $page, $query);
break;
case "list_content":
list_content($eid);
break;
case "terms":
terms($eid, $ltr);
break;
case "search":
search($query, $eid);
break;
default:
list_themes();
break;
}
?> |
|
|
 |
|
|
sgtcoignet
Pote
Inscrit le: Jun 21, 2003
Messages: 54
Localisation: France Bordeaux
|
| Posté le: 18.04.2004, 11:56:19 Sujet du message: |
|
|
Bonjour,
Je ne suis pas sur d'avoir tout compris.
Peux-tu expliquer exactement le résultat souhaité ?
As-tu créé des tables supplémentaires, point, saisons ?
Mercis |
|
|
|
|
|
|
|
|
|
|
Vous ne pouvez pas poster de nouveaux sujets dans ce forum
Vous ne pouvez pas répondre aux sujets dans ce forum
Vous ne pouvez pas éditer vos messages dans ce forum
Vous ne pouvez pas supprimer vos messages dans ce forum
Vous ne pouvez pas voter dans les sondages de ce forum
Vous ne pouvez pas joindre des fichiers dans ce forum
Vous pouvez télécharger des fichiers dans ce forum
|
| :: Powered by phpBB © 2001, 2005 phpBB Group :: |
|
|
|
|
FAQ
Rechercher
Groupes d'utilisateurs
Les Rangs
Profil
Se connecter pour vérifier ses messages privés
Connexion
AVANT TOUT, consultez la charte de nos forums !
