Enjoy an ad free experience by logging in. Not a member yet?
Register .
PM User | 1
New Coder
Join Date: Aug 2010
Posts: 36
Thanks: 8
Thanked 0 Times in 0 Posts
Need help with PM system
Everytime i try to delete a message in my inbox, it goes to deleted page and says it was deleted, but if you go back, it is still there.
The links are
http://www.triplenines.com/member_account.php
http://www.triplenines.com/delete_message.php
heres my coding for the inbox page
PHP Code:
<?php
();
$toplinks = "" ;
$_SESSION [ 'id' ])) {
$userid = $_SESSION [ 'id' ];
$username = $_SESSION [ 'username' ];
$toplinks = '<a href="member_profile.php?id=' . $userid . '">' . $username . '</a> •
;
'Please <a href="login.php"><input type="submit" name="Login" value="Login" /></a> to access your account' ;
?>
include_once "connect_to_mysql.php" ;
$sql = mysql_query ( "SELECT * FROM members WHERE id='$userid'" );
$row = mysql_fetch_array ( $sql )){
$country = $row [ "country" ];
$state = $row [ "state" ];
$city = $row [ "city" ];
$accounttype = $row [ "accounttype" ];
$bio = $row [ "bio" ];
$accounttype == "a" ) {
$userOptions = "You get options for Normal User" ;
$accounttype == "b" ) {
$userOptions = "You get options for Expert User" ;
$userOptions = "You get options for Super User" ;
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<?php echo $toplinks ; ?> </td>
<?php echo "$username" ; ?> </h3>
<?php echo "$userid" ; ?> " target="_self">View Profile</a><br />
<?php echo "$userid" ; ?> /pic1.jpg" alt="Ad" width="150" /></div></td>
<?php echo "$country" ; ?> <br />
<?php echo "$state" ; ?> <br />
<?php echo "$city" ; ?> <br />
<?php echo "$bio" ; ?> <br />
<?php
if ( $username ){
"<a href='create_message.php'>Create Message</a>
;
////////////////////////////////////////////////////////////////////////
require( 'connect_to_mysql.php' );
$query = mysql_query ( "SELECT * FROM messages WHERE to_user='$username' ORDER BY id DESC" );
$numrows = mysql_num_rows ( $query );
$numrows > 0 ){
"<form action='delete_message.php' method='POST'>" ;
"<div id='messages'>
;
$row = mysql_fetch_assoc ( $query )){
$msg_id = $row [ 'id' ];
$msg_to_user = $row [ 'to_user' ];
$msg_to_id = $row [ 'to_id' ];
$msg_from_user = $row [ 'from_user' ];
$msg_from_id = $row [ 'from_id' ];
$msg_subject = $row [ 'subject' ];
$msg_content = $row [ 'content' ];
$msg_date = $row [ 'date' ];
$msg_from_delete = $row [ 'from_delete' ];
$msg_to_delete = $row [ 'to_delete' ];
$msg_to_delete ){
"<div id='messages'>" ;
"<div id='leftside'>
;
"<div id='rightside'>$msg_date</div>" ;
"<div id='center'>
;
"<div style='clear: both;'></div>" ;
"</div>" ;
$num += 1 ;
$num == 0 ){
"You have no messages in your inbox." ;
"</form>" ;
"You have no messages in your inbox." ;
////////////////////////////////////////////////////////////////////////
echo "</div>
;
/////////////////////////////////////////////////////////////////////////////////////
echo "<div id='box'>
;
////////////////////////////////////////////////////////////////////////
require( 'connect_to_mysql.php' );
$query = mysql_query ( "SELECT * FROM messages WHERE from_user='$username' ORDER BY id DESC" );
$numrows = mysql_num_rows ( $query );
$numrows > 0 ){
"<form action='delete_message.php' method='POST'>" ;
"<div id='messages'>
;
$row = mysql_fetch_assoc ( $query )){
$msg_id = $row [ 'id' ];
$msg_to_user = $row [ 'to_user' ];
$msg_to_id = $row [ 'to_id' ];
$msg_from_user = $row [ 'from_user' ];
$msg_from_id = $row [ 'from_id' ];
$msg_subject = $row [ 'subject' ];
$msg_content = $row [ 'content' ];
$msg_date = $row [ 'date' ];
$msg_from_delete = $row [ 'from_delete' ];
$msg_to_delete = $row [ 'to_delete' ];
$msg_from_delete ){
"<div id='messages'>" ;
"<div id='leftside'>
;
"<div id='rightside'>$msg_date</div>" ;
"<div id='center'>
;
"<div style='clear: both;'></div>" ;
"</div>" ;
$num += 1 ;
$num == 0 ){
"You have no messages in your outbox." ;
"</form>" ;
"You have no messages in your outbox." ;
////////////////////////////////////////////////////////////////////////
echo "</div>
;
"</div>" ;
"<center><h2><font color='red'>You must be logged in to view this page.</font></h2></center>" ;
'connect_to_mysql.php' ); ?>
</h3>
My deleted page code will be in the nxt post because my te
PM User | 2
New Coder
Join Date: Aug 2010
Posts: 36
Thanks: 8
Thanked 0 Times in 0 Posts
Here's my code for the deleted page
PHP Code:
<?php
();
$toplinks = "" ;
$_SESSION [ 'id' ])) {
$userid = $_SESSION [ 'id' ];
$username = $_SESSION [ 'username' ];
$toplinks = '<a href="member_profile.php?id=' . $userid . '">' . $username . '</a> •
;
$toplinks = '<a href="join_form.php"><input type="submit" name="Register" value="Register" /><a href="login.php"><input type="submit" name="Login" value="Login" /></a>' ;
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<?php echo $toplinks ; ?> </p>
<?php
if ( $username ){
"<div id='box'>
;
////////////////////////////////////////////////////////////////////
$inboxbtn = $_POST [ 'deleteinbox' ];
$outboxbtn = $_POST [ 'deleteoutbox' ];
$inboxbtn ){
'connect_to_mysql.php' );
$selectall = $_POST [ 'selectall' ];
$selectall ){
$query = mysql_query ( "SELECT * FROM messages WHERE to_user='$username'" );
$row = mysql_fetch_assoc ( $query )){
mysql_query ( "UPDATE messages SET to_delete='1' WHERE to_user='$username'" );
"All messages have been deleted. If you did not want this to happen, then please contact us." ;
$query = mysql_query ( "SELECT * FROM messages WHERE to_user='$username'" );
$row = mysql_fetch_assoc ( $query )){
$msg_id = $row [ 'id' ];
$value = "cb" . "$msg_id" ;
$checkbox = $_POST [ $value ];
$checkbox ){
mysql_query ( "UPDATE messages SET to_delete='1' WHERE id='$msg_id'" );
"The selected messages have been deleted. If you did not want this to happen, then please contact a site administrator." ;
$outboxbtn ){
'connect_to_mysql.php' );
$selectall = $_POST [ 'selectall' ];
$selectall ){
$query = mysql_query ( "SELECT * FROM messages WHERE from_user='$username'" );
$row = mysql_fetch_assoc ( $query )){
mysql_query ( "UPDATE messages SET from_delete='1' WHERE from_user='$username'" );
"All messages have been deleted. If you did not want this to happen, then please contact a site administrator." ;
$query = mysql_query ( "SELECT * FROM messages WHERE from_user='$username'" );
$row = mysql_fetch_assoc ( $query )){
$msg_id = $row [ 'id' ];
$value = "cb" . "$msg_id" ;
$checkbox = $_POST [ $value ];
$checkbox ){
mysql_query ( "UPDATE messages SET from_delete='1' WHERE id='$msg_id'" );
"The selected messages have been deleted. If you did not want this to happen, then please contact a site administrator." ;
"You must click the delete button to view this page." ;
////////////////////////////////////////////////////////////////////
echo "</div>
;
"</div>" ;
"<center><h2><font color='red'>You must be logged in to view this page.</font></h2></center>" ;
'connect_to_mysql.php' ); ?>
</h3>
PM User | 3
Regular Coder
Join Date: Oct 2009
Location: United Kingdom
Posts: 728
Thanks: 4
Thanked 119 Times in 119 Posts
without knowing more, i can speculate that "from_delete" is an integer.
your code is currently setting the value to a "string" which causes errors
try this for each DELETE query
PHP Code:
mysql_query ( "UPDATE messages SET to_delete=1 WHERE to_user='$username'" ) or die( 'Error...' . mysql_error ());
PM User | 4
New Coder
Join Date: Aug 2010
Posts: 36
Thanks: 8
Thanked 0 Times in 0 Posts
that did not work, can you tell me what else you need to know?
PM User | 6
New Coder
Join Date: Aug 2010
Posts: 36
Thanks: 8
Thanked 0 Times in 0 Posts
username :
douboc@ymail.com
pwd: test
Jump To Top of Thread
Thread Tools
Rate This Thread
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
All times are GMT +1. The time now is 04:23 PM .
Advertisement
Log in to turn off these ads.
Before you post, read our: 
