Witam
Czy ktoś mógłby mi pomóc przerobić 3 skrypty php ?
Ponieważ robię sobie stronę www dla znajomych, ale słabo znam język php
a potrzebuję zrobić Prywatne wiadomości na stronie. Pobrałem sobie takowe skrypty z muweb, tylko tam jest skrypt który wysyła PW do postaci w grze (skrypt robiony pod serwer muonline). A ja potrzebuję zrobić, aby te wiadomości się przesyłały między osobami zalogowanymi na stronie.
plik: mail.ph
<?
require("config.php");
$account_id = stripslashes($_SESSION['user']);
$account_id = clean_var($account_id);
if($account_id == NULL){Die ("<img src=\"images/warning.gif\" alt=\"Access Denied\"> Access Denied!</div></table></div></table></table>");}
$sql_accountid_check = $db->Execute("select accountid from MuWeb_mail where accountid=?",array($account_id));
$sql_accountid_check_execute = $sql_accountid_check->numrows();
if($sql_accountid_check_execute <= 0){$sql_insert_account = $db->Execute("INSERT INTO MuWeb_mail (accountid) VALUES (?)",array($account_id));
$sql_insert_account2 = $db->Execute("INSERT INTO MuWeb_mail_store (accountid,store_inbox,store_sent) VALUES (?,'0','0')",array($account_id));}
$sql_inbox_sent_msg_take = $db->Execute("select store_inbox,store_sent from MuWeb_mail_store where accountid=?",array($account_id));
$sql_inbox_sent = $sql_inbox_sent_msg_take->fetchrow();
$sql_inbox_msg_check_script = $db->Execute("select read_msg from MuWeb_mail where accountid=? and inbox='inbox' and read_msg='0'",array($account_id));
$sql_inbox_msg_check = $sql_inbox_msg_check_script->numrows();
if($sql_inbox_sent[0] == NULL){$sql_inbox_sent[0] = '0';}
if($sql_inbox_sent[1] == NULL){$sql_inbox_sent[1] = '0';}
$from_character_sql_script = $db->Execute("Select gameid1,gameid2,gameid3,gameid4,gameid5,gameidc From accountcharacter WHERE id=?",array($account_id));
$from_character_execute = $from_character_sql_script->fetchrow();
?>
<table width="393" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="394"> </td>
</tr>
<tr>
<td><div align="center">
<?
include_once("includes/mail_functions.php");
if (isset($_POST["new_mail"])){
new_mail();}
if (isset($_POST["delete_msg_inbox"])){
delete_mail_inbox();}
if (isset($_POST["delete_msg_sent"])){
delete_mail_sent();}
if (isset($_POST["view_msg_inbox"])){
read_mail();
echo('
<fieldset><legend>'.$_POST['subject'].'</legend>
<table width="367" border="0" align="center" cellpadding="0" cellspacing="4">
<tr>
<td width="64" scope="row"><div align="right">From</div></td>
<td width="287" colspan="2" scope="row"><div align="left">'.$_POST['from'].'
</div></td>
</tr>
<tr>
<td scope="row"><div align="right">Subject</div></td>
<td colspan="2" scope="row"><div align="left">'.$_POST['subject'].'</div></td>
</tr>
<tr>
<td scope="row"><div align="right">Date</div></td>
<td colspan="2" scope="row"><div align="left">'.$_POST['date'].'</div></td>
</tr>
<tr>
<td valign="top" scope="row"><div align="right">Msg</div></td>
<td colspan="2" rowspan="3" valign="top" scope="row"><div align="left">'.$_POST['msg'].'</div></td>
</tr>
<tr>
<td valign="top" scope="row"><div align="right"></div></td>
</tr>
<tr>
<td valign="top" scope="row"> </td>
</tr>
</table>
</fieldset>
');}
if (isset($_POST["view_msg_sent"])){
echo('
<fieldset><legend>'.$_POST['subject'].'</legend>
<table width="367" border="0" align="center" cellpadding="0" cellspacing="4">
<tr>
<td width="64" scope="row"><div align="right">To</div></td>
<td width="287" colspan="2" scope="row"><div align="left">'.$_POST['to'].'
</div></td>
</tr>
<tr>
<td scope="row"><div align="right">Subject</div></td>
<td colspan="2" scope="row"><div align="left">'.$_POST['subject'].'</div></td>
</tr>
<tr>
<td scope="row"><div align="right">Date</div></td>
<td colspan="2" scope="row"><div align="left">'.$_POST['date'].'</div></td>
</tr>
<tr>
<td valign="top" scope="row"><div align="right">Msg</div></td>
<td colspan="2" rowspan="3" valign="top" scope="row"><div align="left">'.$_POST['msg'].'</div></td>
</tr>
<tr>
<td valign="top" scope="row"><div align="right"></div></td>
</tr>
<tr>
<td valign="top" scope="row"> </td>
</tr>
</table>
</fieldset>
');}
?>
</div></td>
</tr>
<tr>
<td> </td>
</tr>
</table>
<table width="80%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td><div align="center">
<fieldset>
<legend>New Mail </legend>
<form action="" method="post" name="new_mail" id="new_mail">
<table width="367" border="0" align="center" cellpadding="0" cellspacing="4">
<tr>
<td width="64" scope="row"><div align="right">To Character </div></td>
<td colspan="2" scope="row"><div align="left">
<input name="to_character" type="text" id="to_character" maxlength="10">
(10 digits->A-Z)</div></td>
</tr>
<tr>
<td scope="row"><div align="right">Subject</div></td>
<td colspan="2" scope="row"><div align="left">
<input name="subject" type="text" id="subject" maxlength="30">
(30 digits->A-Z)</div></td>
</tr>
<tr>
<td scope="row"><div align="right">From</div></td>
<td colspan="2" scope="row"><div align="left"></div>
<div align="left"></div>
<div align="left"><? echo("<select name='from_character' id='from_character'>
<option value='$from_character_execute[0]'>$from_character_execute[0]</option>
<option value='$from_character_execute[1]'>$from_character_execute[1]</option>
<option value='$from_character_execute[2]'>$from_character_execute[2]</option>
<option value='$from_character_execute[3]'>$from_character_execute[3]</option>
<option value='$from_character_execute[4]'>$from_character_execute[4]</option>
</select>"); ?></div></td>
</tr>
<tr>
<td valign="top" scope="row"><div align="right">Msg</div></td>
<td colspan="2" rowspan="3" scope="row"><div align="left">
<textarea name=new_msg cols=30 rows=5 id="new_msg" onFocus=CheckLen(this)
onBlur=CheckLen(this)
onChange=CheckLen(this)
onKeyDown=CheckLen(this) onKeyUp=CheckLen(this)></textarea>
</div></td>
</tr>
<tr>
<td valign="top" scope="row"><div align="right">Max Length <? echo($muweb['msg_length']); ?></div></td>
</tr>
<tr>
<td valign="top" scope="row"> </td>
</tr>
<tr>
<td scope="row"> </td>
<td width="45" scope="row"><input type="submit" name="Submit" value="Send" class="button">
</td>
<td width="242" scope="row"><div align="left">
<input type="reset" name="Reset" value="Reset" class="button">
</div></td>
</tr>
</table>
<table width="200" border="0" cellspacing="0" cellpadding="0">
<tr>
<th scope="row"><input name="new_mail" type="hidden" id="new_mail" value="new_mail"></th>
</tr>
</table>
</form>
</fieldset>
</div></td>
</tr>
</table>
<table width="200" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td> </td>
</tr>
</table>
<table width="80%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td><div align="center">
<fieldset>
<legend>Inbox [<? echo("$sql_inbox_sent[0] / "); echo($muweb['store_inbox']); ?> alowed] </legend>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td scope="row"><div align="center">
<? include_once("includes/mail_inbox.php"); ?>
</div></td>
</tr>
</table>
</fieldset>
</div></td>
</tr>
</table>
<table width="200" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td> </td>
</tr>
</table>
<table width="80%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td><div align="center">
<fieldset>
<legend>Sent [<? echo("$sql_inbox_sent[1] / "); echo($muweb['store_sent']); ?> alowed] </legend>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td scope="row"><div align="center">
<? include_once("includes/mail_sent.php"); ?>
</div></td>
</tr>
</table>
</fieldset>
</div></td>
</tr>
</table>
<table width="200" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td> </td>
</tr>
</table>
plik: mail_functions.php
<?
if (eregi("includes/mail_functions.php", $_SERVER['SCRIPT_NAME'])) { die ("Access Denied!"); }
function new_mail()
{
require("config.php");
$account_id = stripslashes($_SESSION['user']);
$post_to_character = stripslashes($_POST['to_character']);
$post_subject = stripslashes($_POST['subject']);
$post_from_character = stripslashes($_POST['from_character']);
$post_new_msg = stripslashes($_POST['new_msg']);
$sql_mail_sent_check_script = $db->Execute("select store_sent from MuWeb_mail_store where accountid=?",array($account_id));
$sql_mail_sent_check = $sql_mail_sent_check_script->fetchrow();
$sql_to_character_check_script = $db->Execute("select name,accountid from character where name=?",array($post_to_character));
$sql_to_character_check = $sql_to_character_check_script->numrows();
$sql_to_character_check_ = $sql_to_character_check_script->fetchrow();
$sql_mail_inbox_check_script = $db->Execute("select store_inbox from MuWeb_mail_store where accountid='$sql_to_character_check_[1]'");
$sql_mail_inbox_check = $sql_mail_inbox_check_script->fetchrow();
$sql_new_mail_inbox = ($sql_mail_inbox_check[0] + 1);
$sql_new_mail_sent = ($sql_mail_sent_check[0] + 1);
$d= date("d-m-Y");
$t = date('g:i A');
$date = "$d $t";
if (
empty($account_id) ||
empty($post_to_character) ||
empty($post_subject) ||
empty($post_from_character) ||
empty($post_new_msg)){
echo "$warning_start Some Fields Were Left Blank! $warning_end";}
elseif($sql_to_character_check <= 0){
echo "$warning_start Character $post_to_character Does Not Exist! $warning_end";}
elseif($sql_mail_sent_check[0] >= $muweb['store_sent']){
echo "$warning_start Please Delete Some Messages From Send Store, Your Send Store Is Full! $warning_end";}
elseif($sql_mail_inbox_check[0] >= $muweb['store_inbox']){
echo "$warning_start Message Could Not Be Send To $post_to_character, His Store Inbox Is Full! $warning_end ";}
else{
$sql_send_new_msg = "
INSERT INTO MuWeb_mail (to_character,from_character,accountid,subject,mail_msg,inbox,sent,read_msg,date) VALUES (?,?,?,?,?,?,?,?,?)
INSERT INTO MuWeb_mail (to_character,from_character,accountid,subject,mail_msg,inbox,sent,read_msg,date) VALUES (?,?,?,?,?,?,?,?,?)
Update MuWeb_mail_store set store_inbox=?
where accountid=?
Update MuWeb_mail_store set store_sent=?
where accountid=?
";
//$sql_script_website_settings "delete from MuWeb where servername='$delete[0]'";
$execute_sql_script = $db->Execute($sql_send_new_msg,array($post_to_character,$post_from_character,$sql_to_character_check_[1],$post_subject,$post_new_msg,'inbox','0','0',$date,$post_to_character,$post_from_character,$account_id,$post_subject,$post_new_msg,'0','sent','0',$date,$sql_new_mail_inbox,$sql_to_character_check_[1],$sql_new_mail_sent,$account_id));
echo "$ok_start Message Has Been SuccessFully Sent To $post_to_character! $ok_end";
}
}
function read_mail()
{
require("config.php");
$account_id = stripslashes($_SESSION['user']);
$post_subject = stripslashes($_POST['subject']);
$post_from_character = stripslashes($_POST['from']);
$post_msg = stripslashes($_POST['msg']);
$date = stripslashes($_POST['date']);
if (
empty($date) ||
empty($account_id) ||
empty($post_subject) ||
empty($post_from_character) ||
empty($post_msg)){
echo "$warning_start Some Fields Were Left Blank! $warning_end";}
else{
$sql_read_msg = "Update MuWeb_mail set read_msg='1' where accountid=? and from_character=? and subject=? and mail_msg=? and date=?";
//$sql_script_website_settings "delete from MuWeb where servername='$delete[0]'";
$execute_sql_script = $db->Execute($sql_read_msg,array($account_id,$post_from_character,$post_subject,$post_msg,$date));
}
}
function delete_mail_inbox()
{
require("config.php");
$account_id = stripslashes($_SESSION['user']);
$post_subject = stripslashes($_POST['subject']);
$post_from_character = stripslashes($_POST['from']);
$post_msg = stripslashes($_POST['msg']);
$date = stripslashes($_POST['date']);
$sql_mail_inbox_check_script = $db->Execute("select store_inbox from MuWeb_mail_store where accountid=?",array($account_id));
$sql_mail_inbox_check = $sql_mail_inbox_check_script->fetchrow();
$sql_new_mail_inbox = ($sql_mail_inbox_check[0] - 1);
if (
empty($date) ||
empty($account_id) ||
empty($post_subject) ||
empty($post_from_character) ||
empty($post_msg)){
echo "$warning_start Some Fields Were Left Blank! $warning_end";}
else{
$sql_delete_msg = "
Delete from MuWeb_mail where accountid=? and from_character=? and subject=? and mail_msg=? and date=? and inbox='inbox'
Update MuWeb_mail_store set store_inbox=?
where accountid=?
";
//$sql_script_website_settings "delete from MuWeb where servername='$delete[0]'";
$execute_sql_script = $db->Execute($sql_delete_msg,array($account_id,$post_from_character,$post_subject,$post_msg,$date,$sql_new_mail_inbox,$account_id));
echo "$ok_start Message SuccessFully Deleted! $ok_end";
}
}
function delete_mail_sent()
{
require("config.php");
$account_id = stripslashes($_SESSION['user']);
$post_subject = stripslashes($_POST['subject']);
$post_to_character = stripslashes($_POST['to']);
$post_msg = stripslashes($_POST['msg']);
$date = stripslashes($_POST['date']);
$sql_mail_sent_check_script = $db->Execute("select store_sent from MuWeb_mail_store where accountid='$account_id'");
$sql_mail_inbox_check = $sql_mail_sent_check_script->fetchrow();
$sql_new_mail_sent = ($sql_mail_inbox_check[0] - 1);
if (
empty($date) ||
empty($account_id) ||
empty($post_subject) ||
empty($post_to_character) ||
empty($post_msg)){
echo "$warning_start Some Fields Were Left Blank! $warning_end";}
else{
$sql_delete_msg = "
Delete from MuWeb_mail where accountid=? and to_character=? and subject=? and mail_msg=? and date=? and sent='sent'
Update MuWeb_mail_store set store_sent=?
where accountid=?
";
//$sql_script_website_settings "delete from MuWeb where servername='$delete[0]'";
$execute_sql_script = $db->Execute($sql_delete_msg,array($account_id,$post_to_character,$post_subject,$post_msg,$date,$sql_new_mail_sent,$account_id));
echo "$ok_start Message SuccessFully Deleted! $ok_end";
}
}
?>
plik: mail_inbox.php
<?PHP
if (eregi("includes/mail_inbox.php", $_SERVER['SCRIPT_NAME'])) { die ("Access Denied"); }
require_once('config.php');
$accountid=stripslashes($_SESSION['user']);
$accountid=clean_var($accountid);
$sql_select_msg = "SELECT from_character,accountid,subject,mail_msg,inbox,read_msg,date from muweb_mail where accountid=? and inbox='inbox' order by date desc";
$sql_select_msg_execute = $db->Execute($sql_select_msg,array($accountid));
echo '
<table class="sort-table" id="table-1" height=0 border="0" cellpadding="4" cellspacing="0">
<thead><tr>
<td width=1 aling=left>#</td>
<td width=50 aling=left>From</td>
<td width=100 aling=left>Subject</td>
<td width=300 aling=left>Date/Time</td>
<td width=100 aling=left>View</td>
<td width=100 aling=left>Delete</td>
<td width=100 aling=left>Status</td>
</tr></thead>
';
for($i=0;$i < $sql_select_msg_execute->numrows();++$i)
{
$sql_select_msg_done = $sql_select_msg_execute->fetchrow();
$rank = $i+1;
if($sql_select_msg_done[5] == '0'){$sql_select_msg_done[5] ='<img src=images/msg_unread.gif>';}
if($sql_select_msg_done[5] == '1'){$sql_select_msg_done[5] ='<img src=images/msg_read.gif>';}
//$msg_table_delete = "<table width=120 border=0 cellspacing=2 cellpadding=0><tr><th width=120 scope=row><form action=\'\' method=post name=delete_msg_inbox id=delete_msg_inbox><table width=120 border=0 cellspacing=0 cellpadding=0><tr><td width=36 scope=row class=text_administrator>Delete: </td><td width=94 scope=row><div align=center><input name=from type=hidden id=from value=$sql_select_msg_done[0]><input name=subject type=hidden id=subject value=\'$sql_select_msg_done[2]\'><input name=date type=hidden id=date value=\'$sql_select_msg_done[6]\'><input name=msg type=hidden id=msg value=\'$sql_select_msg_done[3]\'><input name=delete_msg_inbox type=hidden id=delete_msg_inbox value=delete_msg_inbox><a href=#><img src=images/submit_button.png onclick=delete_msg_inbox.submit()></a></div></td></tr></table></form></th></tr></table>";
//$msg_table_view = "<table width=120 border=0 cellspacing=2 cellpadding=0><tr><th width=120 scope=row><form action=\'\' method=post name=view_msg id=view_msg><table width=120 border=0 cellspacing=0 cellpadding=0><tr><td width=36 scope=row class=text_administrator>View: </td><td width=94 scope=row><div align=center><input name=from type=hidden id=from value=$sql_select_msg_done[0]><input name=subject type=hidden id=subject value=\'$sql_select_msg_done[2]\'><input name=date type=hidden id=date value=\'$sql_select_msg_done[6]\'><input name=msg type=hidden id=msg value=\'$sql_select_msg_done[3]\'><input name=view_msg_inbox type=hidden id=view_msg_inbox value=view_msg_inbox><a href=#><img src=images/submit_button.png onclick=view_msg.submit()></a></div></td></tr></table></form></th></tr></table>";
$msg_table_delete ="
<table width='40' border='0' cellpadding='0' cellspacing='0'>
<tr>
<td width='85'><form action='' method='post' name='delete_msg_inbox' id='delete_msg_inbox'>
<input name='Delete' type='submit' id='Delete' value='Delete' class='button'>
<input name=from type=hidden id=from value='$sql_select_msg_done[0]'>
<input name=subject type=hidden id=subject value='$sql_select_msg_done[2]'>
<input name=date type=hidden id=date value='$sql_select_msg_done[6]'>
<input name=msg type=hidden id=msg value='$sql_select_msg_done[3]'>
<input name=delete_msg_inbox type=hidden id=delete_msg_inbox value=delete_msg_inbox>
</form></td>
</tr></table>";
$msg_table_view ="<table width='40' border='0' cellpadding='0' cellspacing='0'>
<tr>
<td width='85'><form action='' method='post' name='view_msg' id='view_msg'>
<input name='View' type='submit' id='View' value='View' class='button'>
<input name=from type=hidden id=from value='$sql_select_msg_done[0]'>
<input name=subject type=hidden id=subject value='$sql_select_msg_done[2]'>
<input name=date type=hidden id=date value='$sql_select_msg_done[6]'>
<input name=msg type=hidden id=msg value='$sql_select_msg_done[3]'>
<input name=view_msg_inbox type=hidden id=view_msg_inbox value=view_msg_inbox>
</form></td>
</tr></table>";
echo "<tbody><tr>
<td align=left class=text_statistics>$rank</td>
<td align=left class=text_statistics>$sql_select_msg_done[0]</td>
<td align=left class=text_statistics>$sql_select_msg_done[2]</td>
<td align=left class=text_statistics>$sql_select_msg_done[6]</td>
<td align=left>$msg_table_view</td>
<td align=left>$msg_table_delete</td>
<td align=center>$sql_select_msg_done[5]</td>
</tr></tbody>";
}
?>
</TABLE>
plik: mail_sent.php
<?PHP
if (eregi("includes/mail_sent.php", $_SERVER['SCRIPT_NAME'])) { die ("Access Denied"); }
require_once('config.php');
$accountid=stripslashes($_SESSION['user']);
$accountid=clean_var($accountid);
$sql_select_msg = "SELECT to_character,accountid,subject,mail_msg,inbox,read_msg,date from muweb_mail where accountid=? and sent='sent' order by date desc";
$sql_select_msg_execute = $db->Execute($sql_select_msg,array($accountid));
echo '
<table class="sort-table" id="table-1" height=0 border="0" cellpadding="4" cellspacing="0">
<thead><tr>
<td width=1 aling=left>#</td>
<td width=50 aling=left>To</td>
<td width=100 aling=left>Subject</td>
<td width=300 aling=left>Date/Time</td>
<td width=100 aling=left>View</td>
<td width=100 aling=left>Delete</td>
<td width=100 aling=left>Status</td>
</tr></thead>
';
for($i=0;$i < $sql_select_msg_execute->numrows();++$i)
{
$sql_select_msg_done = $sql_select_msg_execute->fetchrow();
$rank = $i+1;
//$msg_table_delete = "<table width=120 border=0 cellspacing=2 cellpadding=0><tr><th width=120 scope=row><form action=\'\' method=post name=delete_msg_sent id=delete_msg_sent><table width=120 border=0 cellspacing=0 cellpadding=0><tr><td width=36 scope=row class=text_administrator>Delete: </td><td width=94 scope=row><div align=center><input name=to type=hidden id=to value=$sql_select_msg_done[0]><input name=subject type=hidden id=subject value=\'$sql_select_msg_done[2]\'><input name=date type=hidden id=date value=\'$sql_select_msg_done[6]\'><input name=msg type=hidden id=msg value=\'$sql_select_msg_done[3]\'><input name=delete_msg_sent type=hidden id=delete_msg_sent value=delete_msg_sent><a href=#><img src=images/submit_button.png onclick=delete_msg_sent.submit()></a></div></td></tr></table></form></th></tr></table>";
//$msg_table_view = "<table width=120 border=0 cellspacing=2 cellpadding=0><tr><th width=120 scope=row><form action=\'\' method=post name=view_msg id=view_msg><table width=120 border=0 cellspacing=0 cellpadding=0><tr><td width=36 scope=row class=text_administrator>View: </td><td width=94 scope=row><div align=center><input name=to type=hidden id=to value=$sql_select_msg_done[0]><input name=subject type=hidden id=subject value=\'$sql_select_msg_done[2]\'><input name=date type=hidden id=date value=\'$sql_select_msg_done[6]\'><input name=msg type=hidden id=msg value=\'$sql_select_msg_done[3]\'><input name=view_msg_sent type=hidden id=view_msg_sent value=view_msg_sent><a href=#><img src=images/submit_button.png onclick=view_msg.submit()></a></div></td></tr></table></form></th></tr></table>";
$msg_table_delete ="
<table width='40' border='0' cellpadding='0' cellspacing='0'>
<tr>
<td width='85'><form action='' method='post' name='delete_msg_sent' id='delete_msg_sent'>
<input name='Delete' type='submit' id='Delete' value='Delete' class='button'>
<input name=to type=hidden id=to value='$sql_select_msg_done[0]'>
<input name=subject type=hidden id=subject value='$sql_select_msg_done[2]'>
<input name=date type=hidden id=date value='$sql_select_msg_done[6]'>
<input name=msg type=hidden id=msg value='$sql_select_msg_done[3]'>
<input name=delete_msg_sent type=hidden id=delete_msg_sent value=delete_msg_sent>
</form></td>
</tr></table>";
$msg_table_view ="<table width='40' border='0' cellpadding='0' cellspacing='0'>
<tr>
<td width='85'><form action='' method='post' name='view_msg' id='view_msg'>
<input name='View' type='submit' id='View' value='View' class='button'>
<input name=to type=hidden id=to value='$sql_select_msg_done[0]'>
<input name=subject type=hidden id=subject value='$sql_select_msg_done[2]'>
<input name=date type=hidden id=date value='$sql_select_msg_done[6]'>
<input name=msg type=hidden id=msg value='$sql_select_msg_done[3]'>
<input name=view_msg_sent type=hidden id=view_msg_sent value=view_msg_sent>
</form></td>
</tr></table>";
echo "<tbody><tr>
<td align=left class=text_statistics>$rank</td>
<td align=left class=text_statistics>$sql_select_msg_done[0]</td>
<td align=left class=text_statistics>$sql_select_msg_done[2]</td>
<td align=left class=text_statistics>$sql_select_msg_done[6]</td>
<td align=left>$msg_table_view</td>
<td align=left>$msg_table_delete</td>
<td align=center><img src=images/send_msg.gif></td>
</tr></tbody>";
}
?>
</TABLE>
Proszę o pomoc.
Czy ktoś mógłby mi pomóc przerobić 3 skrypty php ?
Ponieważ robię sobie stronę www dla znajomych, ale słabo znam język php
a potrzebuję zrobić Prywatne wiadomości na stronie. Pobrałem sobie takowe skrypty z muweb, tylko tam jest skrypt który wysyła PW do postaci w grze (skrypt robiony pod serwer muonline). A ja potrzebuję zrobić, aby te wiadomości się przesyłały między osobami zalogowanymi na stronie.
plik: mail.ph
<?
require("config.php");
$account_id = stripslashes($_SESSION['user']);
$account_id = clean_var($account_id);
if($account_id == NULL){Die ("<img src=\"images/warning.gif\" alt=\"Access Denied\"> Access Denied!</div></table></div></table></table>");}
$sql_accountid_check = $db->Execute("select accountid from MuWeb_mail where accountid=?",array($account_id));
$sql_accountid_check_execute = $sql_accountid_check->numrows();
if($sql_accountid_check_execute <= 0){$sql_insert_account = $db->Execute("INSERT INTO MuWeb_mail (accountid) VALUES (?)",array($account_id));
$sql_insert_account2 = $db->Execute("INSERT INTO MuWeb_mail_store (accountid,store_inbox,store_sent) VALUES (?,'0','0')",array($account_id));}
$sql_inbox_sent_msg_take = $db->Execute("select store_inbox,store_sent from MuWeb_mail_store where accountid=?",array($account_id));
$sql_inbox_sent = $sql_inbox_sent_msg_take->fetchrow();
$sql_inbox_msg_check_script = $db->Execute("select read_msg from MuWeb_mail where accountid=? and inbox='inbox' and read_msg='0'",array($account_id));
$sql_inbox_msg_check = $sql_inbox_msg_check_script->numrows();
if($sql_inbox_sent[0] == NULL){$sql_inbox_sent[0] = '0';}
if($sql_inbox_sent[1] == NULL){$sql_inbox_sent[1] = '0';}
$from_character_sql_script = $db->Execute("Select gameid1,gameid2,gameid3,gameid4,gameid5,gameidc From accountcharacter WHERE id=?",array($account_id));
$from_character_execute = $from_character_sql_script->fetchrow();
?>
<table width="393" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="394"> </td>
</tr>
<tr>
<td><div align="center">
<?
include_once("includes/mail_functions.php");
if (isset($_POST["new_mail"])){
new_mail();}
if (isset($_POST["delete_msg_inbox"])){
delete_mail_inbox();}
if (isset($_POST["delete_msg_sent"])){
delete_mail_sent();}
if (isset($_POST["view_msg_inbox"])){
read_mail();
echo('
<fieldset><legend>'.$_POST['subject'].'</legend>
<table width="367" border="0" align="center" cellpadding="0" cellspacing="4">
<tr>
<td width="64" scope="row"><div align="right">From</div></td>
<td width="287" colspan="2" scope="row"><div align="left">'.$_POST['from'].'
</div></td>
</tr>
<tr>
<td scope="row"><div align="right">Subject</div></td>
<td colspan="2" scope="row"><div align="left">'.$_POST['subject'].'</div></td>
</tr>
<tr>
<td scope="row"><div align="right">Date</div></td>
<td colspan="2" scope="row"><div align="left">'.$_POST['date'].'</div></td>
</tr>
<tr>
<td valign="top" scope="row"><div align="right">Msg</div></td>
<td colspan="2" rowspan="3" valign="top" scope="row"><div align="left">'.$_POST['msg'].'</div></td>
</tr>
<tr>
<td valign="top" scope="row"><div align="right"></div></td>
</tr>
<tr>
<td valign="top" scope="row"> </td>
</tr>
</table>
</fieldset>
');}
if (isset($_POST["view_msg_sent"])){
echo('
<fieldset><legend>'.$_POST['subject'].'</legend>
<table width="367" border="0" align="center" cellpadding="0" cellspacing="4">
<tr>
<td width="64" scope="row"><div align="right">To</div></td>
<td width="287" colspan="2" scope="row"><div align="left">'.$_POST['to'].'
</div></td>
</tr>
<tr>
<td scope="row"><div align="right">Subject</div></td>
<td colspan="2" scope="row"><div align="left">'.$_POST['subject'].'</div></td>
</tr>
<tr>
<td scope="row"><div align="right">Date</div></td>
<td colspan="2" scope="row"><div align="left">'.$_POST['date'].'</div></td>
</tr>
<tr>
<td valign="top" scope="row"><div align="right">Msg</div></td>
<td colspan="2" rowspan="3" valign="top" scope="row"><div align="left">'.$_POST['msg'].'</div></td>
</tr>
<tr>
<td valign="top" scope="row"><div align="right"></div></td>
</tr>
<tr>
<td valign="top" scope="row"> </td>
</tr>
</table>
</fieldset>
');}
?>
</div></td>
</tr>
<tr>
<td> </td>
</tr>
</table>
<table width="80%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td><div align="center">
<fieldset>
<legend>New Mail </legend>
<form action="" method="post" name="new_mail" id="new_mail">
<table width="367" border="0" align="center" cellpadding="0" cellspacing="4">
<tr>
<td width="64" scope="row"><div align="right">To Character </div></td>
<td colspan="2" scope="row"><div align="left">
<input name="to_character" type="text" id="to_character" maxlength="10">
(10 digits->A-Z)</div></td>
</tr>
<tr>
<td scope="row"><div align="right">Subject</div></td>
<td colspan="2" scope="row"><div align="left">
<input name="subject" type="text" id="subject" maxlength="30">
(30 digits->A-Z)</div></td>
</tr>
<tr>
<td scope="row"><div align="right">From</div></td>
<td colspan="2" scope="row"><div align="left"></div>
<div align="left"></div>
<div align="left"><? echo("<select name='from_character' id='from_character'>
<option value='$from_character_execute[0]'>$from_character_execute[0]</option>
<option value='$from_character_execute[1]'>$from_character_execute[1]</option>
<option value='$from_character_execute[2]'>$from_character_execute[2]</option>
<option value='$from_character_execute[3]'>$from_character_execute[3]</option>
<option value='$from_character_execute[4]'>$from_character_execute[4]</option>
</select>"); ?></div></td>
</tr>
<tr>
<td valign="top" scope="row"><div align="right">Msg</div></td>
<td colspan="2" rowspan="3" scope="row"><div align="left">
<textarea name=new_msg cols=30 rows=5 id="new_msg" onFocus=CheckLen(this)
onBlur=CheckLen(this)
onChange=CheckLen(this)
onKeyDown=CheckLen(this) onKeyUp=CheckLen(this)></textarea>
</div></td>
</tr>
<tr>
<td valign="top" scope="row"><div align="right">Max Length <? echo($muweb['msg_length']); ?></div></td>
</tr>
<tr>
<td valign="top" scope="row"> </td>
</tr>
<tr>
<td scope="row"> </td>
<td width="45" scope="row"><input type="submit" name="Submit" value="Send" class="button">
</td>
<td width="242" scope="row"><div align="left">
<input type="reset" name="Reset" value="Reset" class="button">
</div></td>
</tr>
</table>
<table width="200" border="0" cellspacing="0" cellpadding="0">
<tr>
<th scope="row"><input name="new_mail" type="hidden" id="new_mail" value="new_mail"></th>
</tr>
</table>
</form>
</fieldset>
</div></td>
</tr>
</table>
<table width="200" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td> </td>
</tr>
</table>
<table width="80%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td><div align="center">
<fieldset>
<legend>Inbox [<? echo("$sql_inbox_sent[0] / "); echo($muweb['store_inbox']); ?> alowed] </legend>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td scope="row"><div align="center">
<? include_once("includes/mail_inbox.php"); ?>
</div></td>
</tr>
</table>
</fieldset>
</div></td>
</tr>
</table>
<table width="200" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td> </td>
</tr>
</table>
<table width="80%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td><div align="center">
<fieldset>
<legend>Sent [<? echo("$sql_inbox_sent[1] / "); echo($muweb['store_sent']); ?> alowed] </legend>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td scope="row"><div align="center">
<? include_once("includes/mail_sent.php"); ?>
</div></td>
</tr>
</table>
</fieldset>
</div></td>
</tr>
</table>
<table width="200" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td> </td>
</tr>
</table>
plik: mail_functions.php
<?
if (eregi("includes/mail_functions.php", $_SERVER['SCRIPT_NAME'])) { die ("Access Denied!"); }
function new_mail()
{
require("config.php");
$account_id = stripslashes($_SESSION['user']);
$post_to_character = stripslashes($_POST['to_character']);
$post_subject = stripslashes($_POST['subject']);
$post_from_character = stripslashes($_POST['from_character']);
$post_new_msg = stripslashes($_POST['new_msg']);
$sql_mail_sent_check_script = $db->Execute("select store_sent from MuWeb_mail_store where accountid=?",array($account_id));
$sql_mail_sent_check = $sql_mail_sent_check_script->fetchrow();
$sql_to_character_check_script = $db->Execute("select name,accountid from character where name=?",array($post_to_character));
$sql_to_character_check = $sql_to_character_check_script->numrows();
$sql_to_character_check_ = $sql_to_character_check_script->fetchrow();
$sql_mail_inbox_check_script = $db->Execute("select store_inbox from MuWeb_mail_store where accountid='$sql_to_character_check_[1]'");
$sql_mail_inbox_check = $sql_mail_inbox_check_script->fetchrow();
$sql_new_mail_inbox = ($sql_mail_inbox_check[0] + 1);
$sql_new_mail_sent = ($sql_mail_sent_check[0] + 1);
$d= date("d-m-Y");
$t = date('g:i A');
$date = "$d $t";
if (
empty($account_id) ||
empty($post_to_character) ||
empty($post_subject) ||
empty($post_from_character) ||
empty($post_new_msg)){
echo "$warning_start Some Fields Were Left Blank! $warning_end";}
elseif($sql_to_character_check <= 0){
echo "$warning_start Character $post_to_character Does Not Exist! $warning_end";}
elseif($sql_mail_sent_check[0] >= $muweb['store_sent']){
echo "$warning_start Please Delete Some Messages From Send Store, Your Send Store Is Full! $warning_end";}
elseif($sql_mail_inbox_check[0] >= $muweb['store_inbox']){
echo "$warning_start Message Could Not Be Send To $post_to_character, His Store Inbox Is Full! $warning_end ";}
else{
$sql_send_new_msg = "
INSERT INTO MuWeb_mail (to_character,from_character,accountid,subject,mail_msg,inbox,sent,read_msg,date) VALUES (?,?,?,?,?,?,?,?,?)
INSERT INTO MuWeb_mail (to_character,from_character,accountid,subject,mail_msg,inbox,sent,read_msg,date) VALUES (?,?,?,?,?,?,?,?,?)
Update MuWeb_mail_store set store_inbox=?
where accountid=?
Update MuWeb_mail_store set store_sent=?
where accountid=?
";
//$sql_script_website_settings "delete from MuWeb where servername='$delete[0]'";
$execute_sql_script = $db->Execute($sql_send_new_msg,array($post_to_character,$post_from_character,$sql_to_character_check_[1],$post_subject,$post_new_msg,'inbox','0','0',$date,$post_to_character,$post_from_character,$account_id,$post_subject,$post_new_msg,'0','sent','0',$date,$sql_new_mail_inbox,$sql_to_character_check_[1],$sql_new_mail_sent,$account_id));
echo "$ok_start Message Has Been SuccessFully Sent To $post_to_character! $ok_end";
}
}
function read_mail()
{
require("config.php");
$account_id = stripslashes($_SESSION['user']);
$post_subject = stripslashes($_POST['subject']);
$post_from_character = stripslashes($_POST['from']);
$post_msg = stripslashes($_POST['msg']);
$date = stripslashes($_POST['date']);
if (
empty($date) ||
empty($account_id) ||
empty($post_subject) ||
empty($post_from_character) ||
empty($post_msg)){
echo "$warning_start Some Fields Were Left Blank! $warning_end";}
else{
$sql_read_msg = "Update MuWeb_mail set read_msg='1' where accountid=? and from_character=? and subject=? and mail_msg=? and date=?";
//$sql_script_website_settings "delete from MuWeb where servername='$delete[0]'";
$execute_sql_script = $db->Execute($sql_read_msg,array($account_id,$post_from_character,$post_subject,$post_msg,$date));
}
}
function delete_mail_inbox()
{
require("config.php");
$account_id = stripslashes($_SESSION['user']);
$post_subject = stripslashes($_POST['subject']);
$post_from_character = stripslashes($_POST['from']);
$post_msg = stripslashes($_POST['msg']);
$date = stripslashes($_POST['date']);
$sql_mail_inbox_check_script = $db->Execute("select store_inbox from MuWeb_mail_store where accountid=?",array($account_id));
$sql_mail_inbox_check = $sql_mail_inbox_check_script->fetchrow();
$sql_new_mail_inbox = ($sql_mail_inbox_check[0] - 1);
if (
empty($date) ||
empty($account_id) ||
empty($post_subject) ||
empty($post_from_character) ||
empty($post_msg)){
echo "$warning_start Some Fields Were Left Blank! $warning_end";}
else{
$sql_delete_msg = "
Delete from MuWeb_mail where accountid=? and from_character=? and subject=? and mail_msg=? and date=? and inbox='inbox'
Update MuWeb_mail_store set store_inbox=?
where accountid=?
";
//$sql_script_website_settings "delete from MuWeb where servername='$delete[0]'";
$execute_sql_script = $db->Execute($sql_delete_msg,array($account_id,$post_from_character,$post_subject,$post_msg,$date,$sql_new_mail_inbox,$account_id));
echo "$ok_start Message SuccessFully Deleted! $ok_end";
}
}
function delete_mail_sent()
{
require("config.php");
$account_id = stripslashes($_SESSION['user']);
$post_subject = stripslashes($_POST['subject']);
$post_to_character = stripslashes($_POST['to']);
$post_msg = stripslashes($_POST['msg']);
$date = stripslashes($_POST['date']);
$sql_mail_sent_check_script = $db->Execute("select store_sent from MuWeb_mail_store where accountid='$account_id'");
$sql_mail_inbox_check = $sql_mail_sent_check_script->fetchrow();
$sql_new_mail_sent = ($sql_mail_inbox_check[0] - 1);
if (
empty($date) ||
empty($account_id) ||
empty($post_subject) ||
empty($post_to_character) ||
empty($post_msg)){
echo "$warning_start Some Fields Were Left Blank! $warning_end";}
else{
$sql_delete_msg = "
Delete from MuWeb_mail where accountid=? and to_character=? and subject=? and mail_msg=? and date=? and sent='sent'
Update MuWeb_mail_store set store_sent=?
where accountid=?
";
//$sql_script_website_settings "delete from MuWeb where servername='$delete[0]'";
$execute_sql_script = $db->Execute($sql_delete_msg,array($account_id,$post_to_character,$post_subject,$post_msg,$date,$sql_new_mail_sent,$account_id));
echo "$ok_start Message SuccessFully Deleted! $ok_end";
}
}
?>
plik: mail_inbox.php
<?PHP
if (eregi("includes/mail_inbox.php", $_SERVER['SCRIPT_NAME'])) { die ("Access Denied"); }
require_once('config.php');
$accountid=stripslashes($_SESSION['user']);
$accountid=clean_var($accountid);
$sql_select_msg = "SELECT from_character,accountid,subject,mail_msg,inbox,read_msg,date from muweb_mail where accountid=? and inbox='inbox' order by date desc";
$sql_select_msg_execute = $db->Execute($sql_select_msg,array($accountid));
echo '
<table class="sort-table" id="table-1" height=0 border="0" cellpadding="4" cellspacing="0">
<thead><tr>
<td width=1 aling=left>#</td>
<td width=50 aling=left>From</td>
<td width=100 aling=left>Subject</td>
<td width=300 aling=left>Date/Time</td>
<td width=100 aling=left>View</td>
<td width=100 aling=left>Delete</td>
<td width=100 aling=left>Status</td>
</tr></thead>
';
for($i=0;$i < $sql_select_msg_execute->numrows();++$i)
{
$sql_select_msg_done = $sql_select_msg_execute->fetchrow();
$rank = $i+1;
if($sql_select_msg_done[5] == '0'){$sql_select_msg_done[5] ='<img src=images/msg_unread.gif>';}
if($sql_select_msg_done[5] == '1'){$sql_select_msg_done[5] ='<img src=images/msg_read.gif>';}
//$msg_table_delete = "<table width=120 border=0 cellspacing=2 cellpadding=0><tr><th width=120 scope=row><form action=\'\' method=post name=delete_msg_inbox id=delete_msg_inbox><table width=120 border=0 cellspacing=0 cellpadding=0><tr><td width=36 scope=row class=text_administrator>Delete: </td><td width=94 scope=row><div align=center><input name=from type=hidden id=from value=$sql_select_msg_done[0]><input name=subject type=hidden id=subject value=\'$sql_select_msg_done[2]\'><input name=date type=hidden id=date value=\'$sql_select_msg_done[6]\'><input name=msg type=hidden id=msg value=\'$sql_select_msg_done[3]\'><input name=delete_msg_inbox type=hidden id=delete_msg_inbox value=delete_msg_inbox><a href=#><img src=images/submit_button.png onclick=delete_msg_inbox.submit()></a></div></td></tr></table></form></th></tr></table>";
//$msg_table_view = "<table width=120 border=0 cellspacing=2 cellpadding=0><tr><th width=120 scope=row><form action=\'\' method=post name=view_msg id=view_msg><table width=120 border=0 cellspacing=0 cellpadding=0><tr><td width=36 scope=row class=text_administrator>View: </td><td width=94 scope=row><div align=center><input name=from type=hidden id=from value=$sql_select_msg_done[0]><input name=subject type=hidden id=subject value=\'$sql_select_msg_done[2]\'><input name=date type=hidden id=date value=\'$sql_select_msg_done[6]\'><input name=msg type=hidden id=msg value=\'$sql_select_msg_done[3]\'><input name=view_msg_inbox type=hidden id=view_msg_inbox value=view_msg_inbox><a href=#><img src=images/submit_button.png onclick=view_msg.submit()></a></div></td></tr></table></form></th></tr></table>";
$msg_table_delete ="
<table width='40' border='0' cellpadding='0' cellspacing='0'>
<tr>
<td width='85'><form action='' method='post' name='delete_msg_inbox' id='delete_msg_inbox'>
<input name='Delete' type='submit' id='Delete' value='Delete' class='button'>
<input name=from type=hidden id=from value='$sql_select_msg_done[0]'>
<input name=subject type=hidden id=subject value='$sql_select_msg_done[2]'>
<input name=date type=hidden id=date value='$sql_select_msg_done[6]'>
<input name=msg type=hidden id=msg value='$sql_select_msg_done[3]'>
<input name=delete_msg_inbox type=hidden id=delete_msg_inbox value=delete_msg_inbox>
</form></td>
</tr></table>";
$msg_table_view ="<table width='40' border='0' cellpadding='0' cellspacing='0'>
<tr>
<td width='85'><form action='' method='post' name='view_msg' id='view_msg'>
<input name='View' type='submit' id='View' value='View' class='button'>
<input name=from type=hidden id=from value='$sql_select_msg_done[0]'>
<input name=subject type=hidden id=subject value='$sql_select_msg_done[2]'>
<input name=date type=hidden id=date value='$sql_select_msg_done[6]'>
<input name=msg type=hidden id=msg value='$sql_select_msg_done[3]'>
<input name=view_msg_inbox type=hidden id=view_msg_inbox value=view_msg_inbox>
</form></td>
</tr></table>";
echo "<tbody><tr>
<td align=left class=text_statistics>$rank</td>
<td align=left class=text_statistics>$sql_select_msg_done[0]</td>
<td align=left class=text_statistics>$sql_select_msg_done[2]</td>
<td align=left class=text_statistics>$sql_select_msg_done[6]</td>
<td align=left>$msg_table_view</td>
<td align=left>$msg_table_delete</td>
<td align=center>$sql_select_msg_done[5]</td>
</tr></tbody>";
}
?>
</TABLE>
plik: mail_sent.php
<?PHP
if (eregi("includes/mail_sent.php", $_SERVER['SCRIPT_NAME'])) { die ("Access Denied"); }
require_once('config.php');
$accountid=stripslashes($_SESSION['user']);
$accountid=clean_var($accountid);
$sql_select_msg = "SELECT to_character,accountid,subject,mail_msg,inbox,read_msg,date from muweb_mail where accountid=? and sent='sent' order by date desc";
$sql_select_msg_execute = $db->Execute($sql_select_msg,array($accountid));
echo '
<table class="sort-table" id="table-1" height=0 border="0" cellpadding="4" cellspacing="0">
<thead><tr>
<td width=1 aling=left>#</td>
<td width=50 aling=left>To</td>
<td width=100 aling=left>Subject</td>
<td width=300 aling=left>Date/Time</td>
<td width=100 aling=left>View</td>
<td width=100 aling=left>Delete</td>
<td width=100 aling=left>Status</td>
</tr></thead>
';
for($i=0;$i < $sql_select_msg_execute->numrows();++$i)
{
$sql_select_msg_done = $sql_select_msg_execute->fetchrow();
$rank = $i+1;
//$msg_table_delete = "<table width=120 border=0 cellspacing=2 cellpadding=0><tr><th width=120 scope=row><form action=\'\' method=post name=delete_msg_sent id=delete_msg_sent><table width=120 border=0 cellspacing=0 cellpadding=0><tr><td width=36 scope=row class=text_administrator>Delete: </td><td width=94 scope=row><div align=center><input name=to type=hidden id=to value=$sql_select_msg_done[0]><input name=subject type=hidden id=subject value=\'$sql_select_msg_done[2]\'><input name=date type=hidden id=date value=\'$sql_select_msg_done[6]\'><input name=msg type=hidden id=msg value=\'$sql_select_msg_done[3]\'><input name=delete_msg_sent type=hidden id=delete_msg_sent value=delete_msg_sent><a href=#><img src=images/submit_button.png onclick=delete_msg_sent.submit()></a></div></td></tr></table></form></th></tr></table>";
//$msg_table_view = "<table width=120 border=0 cellspacing=2 cellpadding=0><tr><th width=120 scope=row><form action=\'\' method=post name=view_msg id=view_msg><table width=120 border=0 cellspacing=0 cellpadding=0><tr><td width=36 scope=row class=text_administrator>View: </td><td width=94 scope=row><div align=center><input name=to type=hidden id=to value=$sql_select_msg_done[0]><input name=subject type=hidden id=subject value=\'$sql_select_msg_done[2]\'><input name=date type=hidden id=date value=\'$sql_select_msg_done[6]\'><input name=msg type=hidden id=msg value=\'$sql_select_msg_done[3]\'><input name=view_msg_sent type=hidden id=view_msg_sent value=view_msg_sent><a href=#><img src=images/submit_button.png onclick=view_msg.submit()></a></div></td></tr></table></form></th></tr></table>";
$msg_table_delete ="
<table width='40' border='0' cellpadding='0' cellspacing='0'>
<tr>
<td width='85'><form action='' method='post' name='delete_msg_sent' id='delete_msg_sent'>
<input name='Delete' type='submit' id='Delete' value='Delete' class='button'>
<input name=to type=hidden id=to value='$sql_select_msg_done[0]'>
<input name=subject type=hidden id=subject value='$sql_select_msg_done[2]'>
<input name=date type=hidden id=date value='$sql_select_msg_done[6]'>
<input name=msg type=hidden id=msg value='$sql_select_msg_done[3]'>
<input name=delete_msg_sent type=hidden id=delete_msg_sent value=delete_msg_sent>
</form></td>
</tr></table>";
$msg_table_view ="<table width='40' border='0' cellpadding='0' cellspacing='0'>
<tr>
<td width='85'><form action='' method='post' name='view_msg' id='view_msg'>
<input name='View' type='submit' id='View' value='View' class='button'>
<input name=to type=hidden id=to value='$sql_select_msg_done[0]'>
<input name=subject type=hidden id=subject value='$sql_select_msg_done[2]'>
<input name=date type=hidden id=date value='$sql_select_msg_done[6]'>
<input name=msg type=hidden id=msg value='$sql_select_msg_done[3]'>
<input name=view_msg_sent type=hidden id=view_msg_sent value=view_msg_sent>
</form></td>
</tr></table>";
echo "<tbody><tr>
<td align=left class=text_statistics>$rank</td>
<td align=left class=text_statistics>$sql_select_msg_done[0]</td>
<td align=left class=text_statistics>$sql_select_msg_done[2]</td>
<td align=left class=text_statistics>$sql_select_msg_done[6]</td>
<td align=left>$msg_table_view</td>
<td align=left>$msg_table_delete</td>
<td align=center><img src=images/send_msg.gif></td>
</tr></tbody>";
}
?>
</TABLE>
Proszę o pomoc.
