Appel de variable defaillantRésolu/Fermé

Question

Bonsoir, je créé un site en php sous une base en opensource (Nuked Klan) et je me confronte à un problème... tout bête, j'ai la valeur d'une variable que je n'arrives pas à afficher... Je voudrais afficher le contenus de la variable auteur en fonction de autor_id Voici le moment où ça pêche, ligne 157: [spoiler] function classe($sid, $nb_subcat) { global $nuked, $theme, $bgcolor1, $bgcolor2, $bgcolor3; $sql12 = mysql_query("SELECT autor, autor_id FROM " . SECTIONS_TABLE . " WHERE artid = '" . $artid . "'"); list($autor, $autor_id) = mysql_fetch_row($sql); if ($_REQUEST['op'] == "classe") { echo "

" . _SECTIONS . "

" . "

" . "[ " . _INDEXSECTIONS . " | "; if ($_REQUEST['orderby'] == "news") { echo _NEWSART . " | "; } else { echo "" . _NEWSART . " | "; } if ($_REQUEST['orderby'] == "count") { echo _TOPART . " | "; } else { echo "" . _TOPART . " | "; } echo "" . _SUGGESTART . " ]

"; } $nb_max = $nuked['max_sections']; if (!$_REQUEST['p']) $_REQUEST['p'] = 1; $start = $_REQUEST['p'] * $nb_max - $nb_max; if ($sid != "") $where = "WHERE S.secid = '" . $sid . "'"; else $where = ""; if ($_REQUEST['orderby'] == "name") { $order = "ORDER BY S.title"; } else if ($_REQUEST['orderby'] == "count") { $order = "ORDER BY S.counter DESC"; } else if ($_REQUEST['orderby'] == "note") { $order = "ORDER BY note DESC"; } else { $_REQUEST['orderby'] = "news"; $order = "ORDER BY S.artid DESC"; } $sql = mysql_query("SELECT S.artid, S.title, S.date, S.counter, S.content, AVG(V.vote) AS note FROM " . SECTIONS_TABLE . " AS S LEFT JOIN " . VOTE_TABLE . " AS V ON S.artid = V.vid AND V.module = 'Sections' " . $where . " GROUP BY S.artid " . $order); $nb_art = mysql_num_rows($sql); if ($nb_art > 1 && $sid != "") { echo " " . "

" . _ORDERBY . " : "; if ($_REQUEST['orderby'] == "news") echo "" . _DATE . " | "; else echo "" . _DATE . " | "; if ($_REQUEST['orderby'] == "count") echo "" . _TOPFILE . " | "; else echo "" . _TOPFILE . " | "; if ($_REQUEST['orderby'] == "name") echo "" . _NAME . " | "; else echo" " . _NAME . " | "; if ($_REQUEST['orderby'] == "note") echo"" . _NOTE . ""; else echo" " . _NOTE . ""; echo "

"; } if ($nb_art > 0) { if ($nb_art > $nb_max) { echo "

"; $url = "index.php?file=Sections&op=" . $_REQUEST['op'] . "&secid=" . $sid . "&orderby=" . $_REQUEST['orderby']; number($nb_art, $nb_max, $url); echo "

"; } echo "
"; $sqlhot = mysql_query("SELECT artid FROM " . SECTIONS_TABLE . " ORDER BY counter DESC LIMIT 0, 10"); $seek = mysql_data_seek($sql, $start); for($i = 0;$i < $nb_max;$i++) { if (list($artid, $title, $date, $counter, $content) = mysql_fetch_row($sql)) { /* ?>

$newsdate) $att = " " . _NEW; if ($content != "") { $content = str_replace(" ", "", $content); $content = str_replace(" ", " ", $content); $texte = strip_tags($content); $texte = str_replace("(--pagebreak--)", "", $texte); if (strlen($texte) > 150) { $texte = substr($texte, 0, 150) . "..."; $texte = htmlentities($texte); } } else { $texte = ""; } mysql_data_seek($sqlhot, 0); while (list($id_hot) = mysql_fetch_array($sqlhot)) { if ($artid == $id_hot && $nb_art > 1 && $counter > 9) $att .= " " . _HOT; } if ($date != "") $alt = "title=\"" . _ADDTHE . " " . strftime("%x %H:%M", $date) . "\""; else $alt = ""; if (is_file("themes/" . $theme . "/images/articles.gif")) { $img = " $\"\"$ "; } else { $img = " $\"\"$ "; } $sql5 = mysql_query("SELECT pseudo FROM " . USER_TABLE . " WHERE id = '" . $autor_id . "'"); $test = mysql_num_rows($sql5); list($auteur) = mysql_fetch_array($sql5); $auteur = "" . $auteur . ""; $auteur = $autor; echo " " . "

" . " " . " " . "

" . _AUTHOR . " : " . $auteur . "

"; if ($texte != "") { echo " "; } echo"

" . $img . " " . $title . "" . $att . "	" . " $\"\"$
" . $texte . "
" . _SUITE . " "; //echo "
" . _READSART . " : " . $counter . " "; //vote_index("Sections", $artid); echo "

"; } } if ($nb_art > $nb_max) { echo "

"; $url = "index.php?file=Sections&op=" . $_REQUEST['op'] . "&secid=" . $sid . "&orderby=" . $_REQUEST['orderby']; number($nb_art, $nb_max, $url); echo "

"; } } else { if ($nb_subcat == 0 && $sid > 0) echo "

" . _NOARTS . "

"; if ($_REQUEST['op'] == "classe") echo "

" . _NOARTINDB . "

"; } } Voilà mon code en entier, aux environs des lignes 550 You cannot open this page directly"); } global $user, $nuked, $language; translate("modules/Sections/lang/" . $language . ".lang.php"); ?> <?php echo $nuked['name'] . ' - ' . $nuked['slogan']; ?> = $level_access && $level_access > -1) { // include ("modules/Vote/index.php"); compteur("Sections"); function index() { global $nuked; opentable(); echo "

" . _SECTIONS . "

" . "

" . "[ " . _INDEXSECTIONS . " | " . "" . _NEWSART . " | " . "" . _TOPART . " | " . "" . _SUGGESTART . " ]

"; $sql = mysql_query("SELECT artid FROM " . SECTIONS_TABLE); $nb_arts = mysql_num_rows($sql); $sql_nbcat = mysql_query("SELECT secid FROM " . SECTIONS_CAT_TABLE); $nb_cat = mysql_num_rows($sql_nbcat); if ($nb_cat > 0) { echo " "; $sql_cat = mysql_query("SELECT secid, secname, description FROM " . SECTIONS_CAT_TABLE . " WHERE parentid = 0 ORDER BY position, secname"); $test = 0; while (list($secid, $secname, $description) = mysql_fetch_array($sql_cat)) { $secname = htmlentities($secname); if ($secid != $last_cid) { $test++; if ($test == 1) { echo ""; } echo " "; if ($test == 2) { $test = 0; echo " "; } $last_secid = $secid; } } if ($test == 1) echo " "; echo "

$\"\"$ " . $secname . ""; $sql2 = mysql_query("SELECT secid FROM " . SECTIONS_TABLE . " WHERE secid = '" . $secid . "'"); $nb_art = mysql_num_rows($sql2); if ($nb_art > 0) { echo " (" . $nb_art . ") "; } if ($description != "") { echo "

" . $description . "

"; } else { echo "
"; } $sql_subcat = mysql_query("SELECT secid, secname FROM " . SECTIONS_CAT_TABLE . " WHERE parentid = '" . $secid . "' ORDER BY position, secname LIMIT 0, 4"); $nb_subcat = mysql_num_rows($sql_subcat); if ($nb_subcat > 0) { $t = 0; while (list($sub_cat_id, $sub_cat_titre) = mysql_fetch_array($sql_subcat)) { $sub_cat_titre = htmlentities($sub_cat_titre); $t++; if ($t <= 3) echo "" . $sub_cat_titre . " "; else echo "..."; } } echo "

"; } else { echo "
"; } classe("0", "0"); if ($nb_cat > 0 || $nb_arts > 0) echo "

( " . _THEREIS . " " . $nb_arts . " " . _ARTDB . " & " . $nb_cat . " " . _SECDB . " " . _INDATABASE . " )

"; else echo "

" . _NOARTINDB . "

"; closetable(); } function categorie($secid) { global $nuked; opentable(); $sql = mysql_query("SELECT secname, description, parentid FROM " . SECTIONS_CAT_TABLE . " WHERE secid = '" . $secid . "'"); if(mysql_num_rows($sql) <= 0) { redirect("index.php?file=404", 0); exit(); } list($secname, $description, $parentid) = mysql_fetch_row($sql); $secname = htmlentities($secname); $sql2 = mysql_query("SELECT * FROM " . SECTIONS_TABLE . " WHERE secid = '" . $secid . "'"); $nb_art = mysql_num_rows($sql2); if ($parentid > 0) { $sql_parent = mysql_query("SELECT secname FROM " . SECTIONS_CAT_TABLE . " WHERE secid = '" . $parentid . "'"); list($parent_titre) = mysql_fetch_array($sql_parent); $parent_titre = htmlentities($parent_titre); echo "

" . _SECTIONS . " > " . $parent_titre . " > " . $secname . "

"; } else { echo "

" . _SECTIONS . " > " . $secname . "

"; } $sql_subcat = mysql_query("SELECT secid, secname, description FROM " . SECTIONS_CAT_TABLE . " WHERE parentid = '" . $secid . "' ORDER BY position, secname"); $nb_subcat = mysql_num_rows($sql_subcat); $count = 0; if ($nb_subcat > 0) { echo " "; while (list($catid, $parentcat, $parentdesc) = mysql_fetch_array($sql_subcat)) { $parentcat = htmlentities($parentcat); $sql_nbcat = mysql_query("SELECT secid FROM " . SECTIONS_TABLE . " WHERE secid = '" . $catid . "'"); $nb_artcat = mysql_num_rows($sql_nbcat); if ($catid != $last_catid) { $count++; if ($count == 1) { echo ""; } echo ""; if ($count == 2) { $count = 0; echo " "; } $last_catid = $catid; } } if ($count == 1) echo " "; echo "

$\"\"$ " . $parentcat . " (" . $nb_artcat . ")
" . $parentdesc . "

"; } else { echo "

" . $description . "

"; } classe($secid, $nb_subcat); echo "
"; closetable(); } function article($artid) { global $nuked, $user, $visiteur, $bgcolor3, $bgcolor2, $bgcolor1; opentable(); if (($_REQUEST['p'] == 1) OR ($_REQUEST['p'] == "")) { $upd = mysql_query("UPDATE " . SECTIONS_TABLE . " SET counter = counter + 1 WHERE artid = '" . $artid . "'"); } $sql = mysql_query("SELECT artid, secid, title, content, autor, autor_id, counter, date FROM " . SECTIONS_TABLE . " WHERE artid = '" . $artid . "'"); if(mysql_num_rows($sql) <= 0) { redirect("index.php?file=404", 0); exit(); } list($artid, $secid, $title, $content, $autor, $autor_id, $counter, $date) = mysql_fetch_row($sql); $sql2 = mysql_query("SELECT secname, parentid FROM " . SECTIONS_CAT_TABLE . " WHERE secid = '" . $secid . "'"); list($secname, $parentid) = mysql_fetch_row($sql2); $secname = htmlentities($secname); if ($secid == 0) { $category = _NONE; } else if ($parentid > 0) { $sql3 = mysql_query("SELECT secname FROM " . SECTIONS_CAT_TABLE . " WHERE secid = '" . $parentid . "'"); list($parent_name) = mysql_fetch_array($sql3); $parent_name = htmlentities($parent_name); $category = "" . $parent_name . " -> " . $secname . ""; } else { $category = "" . $secname . ""; } $title = htmlentities($title); $autor = htmlentities($autor); $words = sizeof(explode(" ", $content)); if ($autor_id != "") { $sql4 = mysql_query("SELECT pseudo FROM " . USER_TABLE . " WHERE id = '" . $autor_id . "'"); $test = mysql_num_rows($sql4); } if ($autor_id != "" && $test > 0) { list($auteur) = mysql_fetch_array($sql4); $auteur = "" . $auteur . ""; } else { $auteur = $autor; } $contentpages = explode("(--pagebreak--)", $content); $pageno = count($contentpages); if ($_REQUEST['p'] == "" || $_REQUEST['p'] < 1) $_REQUEST['p'] = 1; if ($_REQUEST['p'] > $pageno) $_REQUEST['p'] = $pageno; $arrayelement = (int)$_REQUEST['p']; $arrayelement --; if ($date != "") $date = strftime("%x %H:%M", $date); if ($visiteur >= admin_mod("Sections")) { echo" "; echo "

$\"\"$ " . " $\"\"$

"; } echo "

" . _SECTIONX . "

" . " " . " "; //. " " //. " "; if ($auteur != "") { echo"

" . _AUTHOR . " : " . $auteur . "

"; } //echo " " //. "

"; $sql = mysql_query("SELECT active FROM " . $nuked['prefix'] . "_comment_mod WHERE module = 'sections'"); list($active) = mysql_fetch_array($sql); if($active ==1) { echo "

"; } closetable(); } function classe($sid, $nb_subcat) { global $nuked, $theme, $bgcolor1, $bgcolor2, $bgcolor3; $sql12 = mysql_query("SELECT autor, autor_id FROM " . SECTIONS_TABLE . " WHERE artid = '" . $artid . "'"); list($autor, $autor_id) = mysql_fetch_row($sql); if ($_REQUEST['op'] == "classe") { echo "

" . _SECTIONS . "

" . "

" . "[ " . _INDEXSECTIONS . " | "; if ($_REQUEST['orderby'] == "news") { echo _NEWSART . " | "; } else { echo "" . _NEWSART . " | "; } if ($_REQUEST['orderby'] == "count") { echo _TOPART . " | "; } else { echo "" . _TOPART . " | "; } echo "" . _SUGGESTART . " ]

"; } $nb_max = $nuked['max_sections']; if (!$_REQUEST['p']) $_REQUEST['p'] = 1; $start = $_REQUEST['p'] * $nb_max - $nb_max; if ($sid != "") $where = "WHERE S.secid = '" . $sid . "'"; else $where = ""; if ($_REQUEST['orderby'] == "name") { $order = "ORDER BY S.title"; } else if ($_REQUEST['orderby'] == "count") { $order = "ORDER BY S.counter DESC"; } else if ($_REQUEST['orderby'] == "note") { $order = "ORDER BY note DESC"; } else { $_REQUEST['orderby'] = "news"; $order = "ORDER BY S.artid DESC"; } $sql = mysql_query("SELECT S.artid, S.title, S.date, S.counter, S.content, AVG(V.vote) AS note FROM " . SECTIONS_TABLE . " AS S LEFT JOIN " . VOTE_TABLE . " AS V ON S.artid = V.vid AND V.module = 'Sections' " . $where . " GROUP BY S.artid " . $order); $nb_art = mysql_num_rows($sql); if ($nb_art > 1 && $sid != "") { echo " " . "

" . _ORDERBY . " : "; if ($_REQUEST['orderby'] == "news") echo "" . _DATE . " | "; else echo "" . _DATE . " | "; if ($_REQUEST['orderby'] == "count") echo "" . _TOPFILE . " | "; else echo "" . _TOPFILE . " | "; if ($_REQUEST['orderby'] == "name") echo "" . _NAME . " | "; else echo" " . _NAME . " | "; if ($_REQUEST['orderby'] == "note") echo"" . _NOTE . ""; else echo" " . _NOTE . ""; echo "

"; } if ($nb_art > 0) { if ($nb_art > $nb_max) { echo "

"; $url = "index.php?file=Sections&op=" . $_REQUEST['op'] . "&secid=" . $sid . "&orderby=" . $_REQUEST['orderby']; number($nb_art, $nb_max, $url); echo "

"; } echo "
"; $sqlhot = mysql_query("SELECT artid FROM " . SECTIONS_TABLE . " ORDER BY counter DESC LIMIT 0, 10"); $seek = mysql_data_seek($sql, $start); for($i = 0;$i < $nb_max;$i++) { if (list($artid, $title, $date, $counter, $content) = mysql_fetch_row($sql)) { /* ?>

$newsdate) $att = " " . _NEW; if ($content != "") { $content = str_replace(" ", "", $content); $content = str_replace(" ", " ", $content); $texte = strip_tags($content); $texte = str_replace("(--pagebreak--)", "", $texte); if (strlen($texte) > 150) { $texte = substr($texte, 0, 150) . "..."; $texte = htmlentities($texte); } } else { $texte = ""; } mysql_data_seek($sqlhot, 0); while (list($id_hot) = mysql_fetch_array($sqlhot)) { if ($artid == $id_hot && $nb_art > 1 && $counter > 9) $att .= " " . _HOT; } if ($date != "") $alt = "title=\"" . _ADDTHE . " " . strftime("%x %H:%M", $date) . "\""; else $alt = ""; if (is_file("themes/" . $theme . "/images/articles.gif")) { $img = " $\"\"$ "; } else { $img = " $\"\"$ "; } $sql5 = mysql_query("SELECT pseudo FROM " . USER_TABLE . " WHERE id = '" . $autor_id . "'"); $test = mysql_num_rows($sql5); list($auteur) = mysql_fetch_array($sql5); $auteur = "" . $auteur . ""; $auteur = $autor; echo " " . "

" . " " . " " . "

" . _AUTHOR . " : " . $auteur . "

"; if ($texte != "") { echo " "; } echo"

" . $img . " " . $title . "" . $att . "	" . " $\"\"$
" . $texte . "
" . _SUITE . " "; //echo "
" . _READSART . " : " . $counter . " "; //vote_index("Sections", $artid); echo "

"; } } if ($nb_art > $nb_max) { echo "

"; $url = "index.php?file=Sections&op=" . $_REQUEST['op'] . "&secid=" . $sid . "&orderby=" . $_REQUEST['orderby']; number($nb_art, $nb_max, $url); echo "

"; } } else { if ($nb_subcat == 0 && $sid > 0) echo "

" . _NOARTS . "

"; if ($_REQUEST['op'] == "classe") echo "

" . _NOARTINDB . "

"; } } function pdf($artid) { global $nuked; $sql = mysql_query("SELECT title, content FROM " . SECTIONS_TABLE . " WHERE artid = '" . $artid . "'"); list($title, $text) = mysql_fetch_row($sql); $text = "
" . $text; $text = str_replace(""", "\"", $text); $text = str_replace("'", "\'", $text); $text = str_replace("à", "à", $text); $text = str_replace("â", "â", $text); $text = str_replace("é", "é", $text); $text = str_replace("è", "è", $text); $text = str_replace("ê", "ê", $text); $text = str_replace("û", "û", $text); $text = str_replace("(--pagebreak--)", _PAGEB, $text); $articleurl = $nuked['url'] . "/index.php?file=Sections&op=article&artid=" . $artid; include ('Includes/html2pdf/html2pdf.class.php'); $sitename = $nuked['name'] . " - " . $nuked['slogan']; $sitename = @html_entity_decode($sitename); $texte = "

".$title."

".$text."

".$sitename."
".$articleurl; $_REQUEST['file'] = $sitename."_".$title; $_REQUEST['file'] = str_replace(' ','_',$_REQUEST['file']); $_REQUEST['file'] .= ".pdf"; $pdf = new HTML2PDF('P','A4','fr'); $pdf->WriteHTML($texte); $pdf->Output($_REQUEST['file']); } switch ($_REQUEST['op']) { case "article": article($_REQUEST['artid']); break; case "classe": opentable(); classe($_REQUEST['sid'], $_REQUEST['nb_subcat']); closetable(); break; case "categorie": categorie($_REQUEST['secid']); break; case "pdf": pdf($_REQUEST['artid']); break; default: index(); break; } } else if ($level_access == -1) { opentable(); echo "

" . _MODULEOFF . "

" . _BACK . "

"; closetable(); } else if ($level_access == 1 && $visiteur == 0) { opentable(); echo "

" . _USERENTRANCE . "

" . _LOGINUSER . " | " . _REGISTERUSER . "

"; closetable(); } else { opentable(); echo "

" . _NOENTRANCE . "

" . _BACK . "

"; closetable(); } ?> /spoiler Merci d'avance de m'aider Configuration: Windows 7 / Safari 535.7

AssassinTourist · Answer

Bonjour, Votre code est trop long pour donner envie de tout lire et de vous aider. Est-ce que c'est ici que ça pose problème : $sql5 = mysql_query("SELECT pseudo FROM " . USER_TABLE . " WHERE id = '" . $autor_id . "'"); $test = mysql_num_rows($sql5); list($auteur) = mysql_fetch_array($sql5); $auteur = "" . $auteur . "";

thiryn · Answer

Ouip :P je crois que ce forum ne dispose pas de balise spoiler, c'est bien dommage.

Appel de variable defaillant

2 réponses

Discussions similaires

Newsletters