brmcdani Posted October 29, 2009 Share Posted October 29, 2009 Hello I am currently trying to add a delete feature to my forum. I believe I have everything built right but I am having some problems when debugging. I do not have PHP Designer 2008 and I am using eclipse as my IDE so it may be something simple. Please give me some help if you can. Thanks! I have these two source files: <?php if(!$_SESSION['uid']){ header("Location: index.php"); } $actz = $_GET['act2']; $actzz = array('reply','topic','admin','delete'); if($actz){ $admin = isa($_SESSION['uid']); if($actz == 'admin'){ if($admin){ // }else { echo "You are not an administrator, so you cannot view this page!"; } } if($actz == 'reply'){ $id = mss($_GET['id']); if($id){ $sql = "SELECT * FROM `alabama_forum_replies` WHERE `id`='".$id."'"; $res = mysql_query($sql) or die(mysql_error()); if(mysql_num_rows($res) == 0){ echo "This topic doesn't exist, so therefore you cannot edit it!"; }else { $row = mysql_fetch_assoc($res); $user_id = $row['uid']; if($user_id == $_SESSION['uid'] || $admin == 1){ if(!$_POST['submit']){ echo "<form method=\"post\" action=\"index.php?act=mod&act2=reply&id=".$id."\">\n"; echo "<table border=\"0\" width=\"100%\" cellspacing=\"3\" cellpadding=\"3\">\n"; echo "<tr><td class=\"forum_header\" align=\"center\"><textarea style=\"width:90%;height:200px\" name=\"reply\">".htmlentities($row['message'])."</textarea></td></tr>\n"; echo "<tr><td class=\"forum_header\" align=\"center\"><input type=\"submit\" name=\"submit\" value=\"Submit Edited Comment\"></td></tr>\n"; echo "</table></form>\n"; }else { $reply = mss($_POST['reply']); if($reply){ $r = range(10,10000); if(in_array(strlen($reply),$r)){ $sql2 = "UPDATE `alabama_forum_replies` SET `message`='".$reply."', `edit_time`='".time()."' WHERE `id`='".$id."'"; $res2 = mysql_query($sql2) or die(mysql_error()); header("Location: index.php?act=topic&id=".$row['tid'].""); }else { echo "Your reply must be between 10 and 10,000 characters in length!\n"; } } } }else { echo "This is not your reply to edit!"; } } } } if ($actz == 'deletereply'){ $id = mss($_GET['id']); if($id){ $sql = "DELETE * FROM `alabama_forum_replies` WHERE `id`='".$id."'"; $res = mysql_query($sql) or die(mysql_error()); if(mysql_num_rows == 0){ echo "This topic doesn't exist"; }else { $row = mysql_fetch_assoc($res); $user_id = $row['uid']; if(user_id == $_SESSION['uid'] || $admin == 1){ if(!$_POST[submit]){ echo "<form method=\"post\" action=\"index.php?act=delete&act2=deletereply&id=".$id."\>\n"; echo "<table border=\"0\" width=\"100%\" cellspacing=\"3\" cellpadding=\"3\">\n"; echo "<tr><td class=\"forum_header\" align=\"center\"><textarea style=\"width:90%;height:200px\" name=\"deletethis\">".htmlentities($row['message'])."</textarea></td></tr>\n"; echo "<tr><td class=\"forum_header\" align=\"center\"><input type=\"submit\" name=\"submit\" value=\"Delete Comment\"></td></tr>\n"; echo "</table></form>\n"; }else{ } }else{ echo "This is not your reply to edit"; } } } } if($actz == 'topic'){ } }else { header("Location: index.php"); } <?php $id = mss($_GET['id']); $page = (!$_GET['page'] || $_GET['page'] < 0) ? "1" : $_GET['page']; $page = ceil($page); $limit = 10; $start = $limit; $end = $page*$limit-($limit); if($id){ $sql = "SELECT * FROM `alabama_forum_topics` WHERE `id`='".$id."'"; $res = mysql_query($sql) or die(mysql_error()); if(mysql_num_rows($res) == 0){ echo "This topic does not exist!"; }else { $row = mysql_fetch_assoc($res); $sql2 = "SELECT admin FROM `alabama_forum_sub_cats` WHERE `id`='".$row['cid']."'"; $res2 = mysql_query($sql2) or die(mysql_error()); $row2 = mysql_fetch_assoc($res2); if($row2['admin'] == 1 && $admin_user_level == 0){ echo "You cannot view this topic!"; }else { $a = (isa($row['uid'])) ? "<font style=\"color:#800000;\">ADMIN</font>" : ""; echo "<table border=\"0\" width=\"100%\" cellspacing=\"3\" cellpadding=\"3\">\n"; echo "<tr><td colspan=\"2\" align=\"left\" class=\"forum_header\"><b>".$row['title']."</b> - Posted On: <em>".$row['date']."</em></td></tr>\n"; echo "<tr><td align=\"left\" width=\"15%\" valign=\"top\" class=\"forum_header\">".uid($row['uid'], true)."<br>Post Count: ".post($row['uid'])."<br>".$a."</td>"; echo "<td align=\"left\" valign=\"top\" class=\"forum_header\">\n"; echo topic($row['message']); echo "</td>\n"; echo "</tr>\n"; $amount_check = "SELECT * FROM `alabama_forum_replies` WHERE `tid`='".$id."'"; $amount_check_res = mysql_query($amount_check) or die(mysql_error()); $amount_count = mysql_num_rows($amount_check_res); $pages = ceil($amount_count/$limit); $previous = ($page-1 <= 0) ? "« Prev" : "<a href=\"./index.php?act=topic&id=".$id."&page=".($page-1)."\">« Prev</a>"; $nextpage = ($page+1 > $pages) ? "Next »" : "<a href=\"./index.php?act=topic&id=".$id."&page=".($page+1)."\">Next »</a>"; echo "<tr><td align=\"right\" colspan=\"2\" class=\"forum_header\">\n"; echo "Pages: "; echo $previous; for($i=1;$i<=$pages;$i++){ $href = ($page == $i) ? " ".$i." " : " <a href=\"./index.php?act=topic&id=".$id."&page=".$i."\">".$i."</a> "; echo $href; } echo $nextpage; echo "</td></tr>\n"; $select_sql = "SELECT * FROM `alabama_forum_replies` WHERE `tid`='".$id."' ORDER BY id ASC LIMIT ".$end.",".$start.""; $select_res = mysql_query($select_sql) or die(mysql_error()); echo "</table>\n"; echo "<table border=\"0\" width=\"100%\" cellspacing=\"3\" cellpadding=\"3\" class=\"reply\">\n"; while($rowr = mysql_fetch_assoc($select_res)){ $b = (isa($rowr['uid'])) ? "<font style=\"color:#800000;\">ADMIN</font>" : ""; echo "<tr><td colspan=\"2\" align=\"left\" class=\"forum_header\">Posted On: <em>".$rowr['date']."</em></td></tr>\n"; echo "<tr><td align=\"left\" width=\"15%\" valign=\"top\" class=\"forum_header\">".uid($rowr['uid'], true)."<br>Post Count: ".post($rowr['uid'])."<br>".$b."</td>"; echo "<td align=\"left\" valign=\"top\" class=\"forum_header\">\n"; echo topic($rowr['message']); if($rowr['edit_time'] > 0){ echo "<tr><td colspan=\"2\" align=\"right\"><em>Last Edit: ".date("M d, Y",$rowr['edit_time']) . " at " . date("h:i:s",$rowr['edit_time'])."</em></td></tr>\n"; } $adminz = isa($_SESSION['uid']); if($adminz == 1 || $rowr['uid'] == $_SESSION['uid']){ echo "<tr><td align=\"left\" colspan=\"2\"><a href=\"index.php?act=mod&act2=reply&id=".$rowr['id']."\">Edit This Reply</a></td></tr>\n"; } if($adminz == 1 || $rowr['uid'] == $_SESSION['uid']){ echo "<tr><td align=\"left\" colspan=\"2\"><a href=\"index.php?act=delete&act2=deletereply&id=".$rowr['id']."\">Delete This Reply</a></td></tr>\n"; } echo "</td>\n"; echo "</tr>\n"; } echo "<form method=\"post\" action=\"./index.php?act=reply&id=".$row['id']."\">\n"; echo "<tr><td colspan=\"2\" align=\"center\"><textarea style=\"width:90%\" name=\"reply\"></textarea><br><input type=\"submit\" name=\"submit\" value=\"Add Reply\" style=\"width:90%\"></td></tr>\n"; echo "</table>\n"; } } }else { echo "Please view a valid topic!"; } ?> Link to comment https://forums.phpfreaks.com/topic/179433-solved-adding-delete-feature-to-my-forum/ Share on other sites More sharing options...
joel24 Posted October 29, 2009 Share Posted October 29, 2009 it would be similar to your "delete reply" setup. except you'd delete the topic id then delete all the replies in alabama_forum_replies that are assigned to that topic id. or is your delete reply code not working and you want help with that? Link to comment https://forums.phpfreaks.com/topic/179433-solved-adding-delete-feature-to-my-forum/#findComment-946756 Share on other sites More sharing options...
brmcdani Posted October 29, 2009 Author Share Posted October 29, 2009 My deletereply code is not working. Edit reply is working fine. Link to comment https://forums.phpfreaks.com/topic/179433-solved-adding-delete-feature-to-my-forum/#findComment-946783 Share on other sites More sharing options...
brmcdani Posted October 29, 2009 Author Share Posted October 29, 2009 Ok I am making some progress with my problem now. I am getting an sql_error that says "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '* FROM `alabama_forum_replies` WHERE `id`='3'' at line 1" As far as I can tell my SQL statement is fine, but I am getting frustrated and tired of searching for my mistake. Let me narrow down the code to where the problem is defined by mysql_error. if ($actz == 'deletereply'){ $id2 = mss($_GET['id']); if($id2){ $sql3 = "DELETE * FROM `alabama_forum_replies` WHERE `id`='".$id2."'"; $res3 = mysql_query($sql3) or die(mysql_error()); if(mysql_num_rows == 0){ echo "This topic doesn't exist"; }else { $row = mysql_fetch_assoc($res3); $user_id = $row['uid']; if(user_id == $_SESSION['uid'] || $admin == 1){ if(!$_POST[submit]){ echo "<form method=\"post\" action=\"index.php?act=delete&act2=deletereply&id=".$id2."\>\n"; echo "<table border=\"0\" width=\"100%\" cellspacing=\"3\" cellpadding=\"3\">\n"; echo "<tr><td class=\"forum_header\" align=\"center\"><textarea style=\"width:90%;height:200px\" name=\"deletethis\">".htmlentities($row['message'])."</textarea></td></tr>\n"; echo "<tr><td class=\"forum_header\" align=\"center\"><input type=\"submit\" name=\"submit\" value=\"Delete Comment\"></td></tr>\n"; echo "</table></form>\n"; }else{ } }else{ echo "This is not your reply to edit"; } } } } Link to comment https://forums.phpfreaks.com/topic/179433-solved-adding-delete-feature-to-my-forum/#findComment-946838 Share on other sites More sharing options...
ngreenwood6 Posted October 29, 2009 Share Posted October 29, 2009 You do not need the * in the delete query. it should be: $sql3 = "DELETE FROM `alabama_forum_replies` WHERE `id`='".$id2."'"; Link to comment https://forums.phpfreaks.com/topic/179433-solved-adding-delete-feature-to-my-forum/#findComment-946840 Share on other sites More sharing options...
brmcdani Posted October 29, 2009 Author Share Posted October 29, 2009 Yep that did the trick. Thanks a lot everyone! Link to comment https://forums.phpfreaks.com/topic/179433-solved-adding-delete-feature-to-my-forum/#findComment-946841 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.