I keep getting this error
Fatal error: Cannot redeclare drawavatarr() (previously declared in /home/danielxp/public_html/members/forum.php:307) in /home/danielxp/public_html/members/forum.php on line 307
Because it is showing the avatar if they have one in a mysql loop
I dunno how to fix it
Look at the code below
Sorry i had to put it on here i got a error on pastebin.
Fatal error: Cannot redeclare drawavatarr() (previously declared in /home/danielxp/public_html/members/forum.php:307) in /home/danielxp/public_html/members/forum.php on line 307
Because it is showing the avatar if they have one in a mysql loop
I dunno how to fix it
Look at the code below
| Code: |
| <?php
include("config.php"); include("bbcodes.php"); include("smbb.php"); echo "<body background='bg.GIF'>"; echo "<html> <head> <link rel=\"stylesheet\" href=\"forumcss.css\" type=\"text/css\"> </head> </html>"; switch($_GET['action']) { default: $getcat = mysql_query("SELECT * FROM category") or die(mysql_error()); while($cats = mysql_fetch_array($getcat)) { echo "<table width='450' border='2' cellspacing='0' cellpadding='0'> <tr> <td background='images/bar.png'>$cats[name]</td> </tr> <tr> <td bgcolor='#D8E6FF' colspan='4'><table width='100%' border='0' cellspacing='0' cellpadding='0'> <tr> <td width='470'>Forum Name</td> <td width='93'>Topics</td> <td width='91'>Replies</td> <td width='113'>Last Post</td> </tr> </table>"; $getfor = mysql_query("SELECT * FROM forums") or die(mysql_error()); while($forums = mysql_fetch_array($getfor)) { $tottopics1 = mysql_query("SELECT * FROM topics WHERE fid = '$forums[id]'") or die(mysql_error()); $tottopics = mysql_num_rows($tottopics1); $totreply1 = mysql_query("SELECT * FROM reply WHERE fid = '$forums[id]'") or die(mysql_error()); $totreply = mysql_num_rows($totreply1); echo "<tr> <td bgcolor='#FFFFFF' colspan='4'><table width='100%' border='0' cellspacing='0' cellpadding='0'> <tr> <td width='407'><a href='forum.php?action=viewforum&id=$forums[id]'><b>$forums[name]</b></a><br>$forums[description]</td> <td width='93'>$tottopics</td> <td width='91'>$totreply</td> <td width='133'> </td> </tr> </table>"; } echo "</td> </tr> </table>"; } break; case "viewforum": $id1 = $_GET['id']; $id=addslashes($id1); $getcat = mysql_query("SELECT * FROM forums WHERE `id` = '$id'") or die(mysql_error()); $cat = mysql_fetch_array($getcat); echo "<table width='450' border='2' cellspacing='0' cellpadding='0'> <tr> <td background='images/bar.png'>Forum Navigation</td> </tr> <tr> <td bgcolor='#D8E6FF'><a href='forum.php'>Forum Index</a> » <b>$cat[name]</b> </td> </tr> </table><br>"; echo "<table width='450' border='2' cellspacing='0' cellpadding='0'> <tr> <td background='images/bar.png'>$cat[name]</td> </tr> <tr> <td bgcolor='#D8E6FF' colspan='4'><table width='100%' border='0' cellspacing='0' cellpadding='0'> <tr> <td width='470'>Topic Title and Description</td> <td width='93'>Starter</td> <td width='93'># Replies</td> <td width='91'># Views</td> <td width='150'>Last Post by</td> </tr> </table>"; $gettop = mysql_query("SELECT * FROM topics WHERE `fid` = '$id'") or die(mysql_error()); if(mysql_num_rows($gettop) == 0) { echo "<tr><td bgcolor='#FFFFFF' colspan='4'> There are no topics in this forum!</td><tr>"; } while($topics = mysql_fetch_array($gettop)) { echo "<tr> <td bgcolor='#FFFFFF' colspan='4'><table width='100%' border='0' cellspacing='0' cellpadding='0'> <tr> <td width='407'><a href='forum.php?action=viewtopic&id=$topics[id]'><b>$topics[title]</b></a><br>$topics[description]</td> <td width='93'>$topics[author]</td> <td width='93'></td> <td width='91'>$topics[views]</td> <td width='133'></td> </tr> </table>"; } break; case "viewtopic": $id1 = $_GET['id']; $id=addslashes($id1); if(!isset($_GET['page'])){ $page = 1; } else { $page = $_GET['page']; } $gettop = mysql_query("SELECT * FROM topics WHERE `id` = '$id'") or die(mysql_error()); $topic = mysql_fetch_array($gettop); $topid = $topic[fid]; $getcat = mysql_query("SELECT * FROM forums WHERE `id` = '$topid'") or die(mysql_error()); $cat = mysql_fetch_array($getcat); echo "<table width='450' border='2' cellspacing='0' cellpadding='0'> <tr> <td background='images/bar.png'>Forum Navigation</td> </tr> <tr> <td bgcolor='#D8E6FF'><a href='forum.php'>Forum Index</a> » <a href='forum.php?action=viewforum&id=$cat[id]'>$cat[name]</a> » <b>$topic[title]</b> </td> </tr> </table><br>"; echo "<table width='450' border='2' cellspacing='0' cellpadding='0'> <tr> <td background='images/bar.png'>$topic[title]</td> </tr> <tr> <td bgcolor='#D8E6FF' colspan='4'><table width='100%' border='0' cellspacing='0' cellpadding='0'> <tr> <td>Posted on $topic[date] at $topic[time]</td> </tr> <table width='450' border='0' cellspacing='0' cellpadding='0' bgcolor='#FFFFFF'> <tr> <td width='120'>"; echo "<br>"; $username = $topic[author]; echo "<center><a href='members.php?user=$username'><b>$topic[author]</b></a></center>"; $amposts = mysql_query("SELECT * FROM reply WHERE author = '$username'") or die(mysql_error()); $totalposts = mysql_num_rows($amposts); $amtopics = mysql_query("SELECT * FROM topics WHERE author = '$username'") or die(mysql_error()); $totaltopics = mysql_num_rows($amtopics); $topandpost = $totalposts + $totaltopics; if($topandpost >=200) { echo "<center>Extreme Member</center>"; } else if($topandpost >=100) { echo "<center>Senior Member</center>"; } else if($topandpost >=50) { echo "<center>Junior Member</center>"; } else if($topandpost >=25) { echo "<center>Active Member</center>"; } else if($topandpost >=0) { echo "<center>Newbie</center>"; } function drawavatar($username) { $filename = 'avatars/'.$username.'.gif'; if (file_exists($filename)) { echo '<center><img src="'.$filename.'" border="0"></center>'; } else { echo '<center><img src="avatars/none.png" border="0"></center>'; } } $getuser = mysql_query("SELECT * from users where username = '$username'"); $profile = mysql_fetch_array($getuser); $text = $topic[text]; $text = parseubb($text, red); $signature = $profile[signature]; $signature = parseubb($signature, red); drawavatar($username); echo "<center>Posts: $topandpost </center>"; echo "<br><br>"; echo "</td> <td width='330'>$text <br><br> ----------Signature---------- <br> $signature </td> </tr> </table> "; //Gets the comments $max_results = "5"; $from = (($page * $max_results) - $max_results); $getreplys = mysql_query("SELECT * from reply WHERE `topicid` = '$id' order by id DESC LIMIT $from, $max_results"); while($replys = mysql_fetch_array($getreplys)) { echo " <tr> <td bgcolor='#D8E6FF' colspan='4'><table width='100%' border='0' cellspacing='0' cellpadding='0'> <tr> <td>Posted on $replys[date] at $replys[time]</td> </tr> <table width='450' border='0' cellspacing='0' cellpadding='0' bgcolor='#FFFFFF'> <tr> <td width='120'>"; echo "<br>"; $username = $replys[author]; echo "<center><a href='members.php?user=$username'><b>$replys[author]</b></a></center>"; $amposts = mysql_query("SELECT * FROM reply WHERE author = '$username'") or die(mysql_error()); $totalposts = mysql_num_rows($amposts); $amtopics = mysql_query("SELECT * FROM topics WHERE author = '$username'") or die(mysql_error()); $totaltopics = mysql_num_rows($amtopics); $topandpost = $totalposts + $totaltopics; if($topandpost >=200) { echo "<center>Extreme Member</center>"; } else if($topandpost >=100) { echo "<center>Senior Member</center>"; } else if($topandpost >=50) { echo "<center>Junior Member</center>"; } else if($topandpost >=25) { echo "<center>Active Member</center>"; } else if($topandpost >=0) { echo "<center>Newbie</center>"; } function drawavatarr($username) { $filename = 'avatars/'.$username.'.gif'; if (file_exists($filename)) { echo '<center><img src="'.$filename.'" border="0"></center>'; } else { echo '<center><img src="avatars/none.png" border="0"></center>'; } } $getuser = mysql_query("SELECT * from users where username = '$username'"); $profile = mysql_fetch_array($getuser); $text = $replys[text]; $text = parseubb($text, red); $signature = $profile[signature]; $signature = parseubb($signature, red); drawavatarr($username); echo "<center>Posts: $topandpost </center>"; echo "<br><br>"; echo "</td> <td width='330'>$text <br><br> ----------Signature---------- <br> $signature </td> </tr> </table> "; } echo " </table>"; echo "<br><table width='450' border='2' cellspacing='0' cellpadding='0' bgcolor='#FFFFFF'> <tr> <td background='images/bar.png'>Pages</td> </tr> <tr> <td>"; $total_results = mysql_result(mysql_query("SELECT COUNT(*) as Num FROM reply WHERE `topicid` = '$id'"),0); $total_pages = ceil($total_results / $max_results); for($i = 1; $i <= $total_pages; $i++){ if(($page) == $i){ echo "$i "; echo "</font>"; } else { echo "<a href=\"".$_SERVER['PHP_SELF']."?page=$i\" title=\"Page $i\">$i</a> "; } } echo " </td> </tr> </table>"; echo "<br><table width='450' border='2' cellspacing='0' cellpadding='0' bgcolor='#FFFFFF'> <tr> <td background='images/bar.png'>Post a reply</td> </tr> <tr> <td><br><form method='post' action='forum.php?action=postreply&id=$topic[id]&fid=$cat[id]'> <textarea name='reply' cols='50' rows='10'></textarea> <br> <input type='submit' name='Submit' value='Submit'></form></td> </tr> </table>"; break; case "postreply": $id1 = $_GET['id']; $id=addslashes($id1); $fid1 = $_GET['fid']; $fid=addslashes($fid1); $reply = nl2br(htmlspecialchars($_POST[reply])); if((!$_POST[reply])){ exit("<table width='450' border='2' cellspacing='0' cellpadding='0' bgcolor='#FFFFFF'> <tr> <td background='images/bar.png'>Error</td> </tr> <tr> <td>Please enter your reply</td> </tr> </table>"); } $topicid = $id; $author = $logged[username]; $date = date("l j F Y"); $time = date("i:H A"); $text = $reply; $fid = $fid; $query = mysql_query("INSERT INTO reply (topicid, author, date, time, text, fid) VALUES('$topicid','$author','$date','$time','$text','$fid')"); echo "<table width='450' border='2' cellspacing='0' cellpadding='0' bgcolor='#FFFFFF'> <tr> <td background='images/bar.png'>Thank you</td> </tr> <tr> <td>You will now be redirected!</td> </tr> </table>"; echo "<meta http-equiv=\"Refresh\" content=\"0; URL=forum.php?action=viewtopic&id=$id\"/>"; break; } ?> |
Sorry i had to put it on here i got a error on pastebin.
