PM systeem help

[Rockybag]

Hallo,

Ik heb net een PM systeem gevonden op google en op mijn website gezet. Ik heb ik de database 3 tabellen: members, pm en pmopties. Nu linkt het script wel naar de databse maar niet naar die tabellen. Ik hoop dat jullie mij kunnen helpen. Ik heb het script pm_inbox.php en pm_new.php. Als jullie meer nodig hebben hoor ik het graag.

Pm_inbox.php

<?php
$db_host = "localhost";
$db_user = "****";
$db_pass = "*************";
$db_name = "**";
$uuser = "gebruiker naam hier";
$db = mysql_connect($db_host,$db_user,$db_pass);
mysql_select_db($db_name, $db);
?>  
<?php
include ("pm_head.php");
?>
<table width="600">
<tr>
<td width="1%">
</td>
<td width="20%">
Van:
</td>
<td width="25%">
Datum
</td>
<td width="48%">
Onderwerp
</td>
</tr>
<form action="pm_inbox.php" method="post">
<?
if (isset($_POST["what"])){
$what =  $_POST["what"];
foreach ($_POST as $mid){
if (is_numeric($mid) == true){
if (isset($mid)){
switch ($what) {
case "delete":
$check_dwd = mysql_query("SELECT * FROM pmoptions WHERE user = '$uuser'");
while (list($id, $user, $alert, $buddy, $block, $dwd) =
mysql_fetch_row($check_dwd)){
if ($dwd == "delete"){
$query = "DELETE FROM pm WHERE id = '$mid'";
mysql_query($query);
}else{
$query = "UPDATE pm SET read = '-1' WHERE id = '$mid'";
mysql_query($query);
}
}
break;
case "unread";
$query = "UPDATE pm SET read = '0' WHERE id = '$mid'";
mysql_query($query);
break;
case "read";
$query = "UPDATE pm SET read = '1' WHERE id = '$mid'";
mysql_query($query);
break;
}
}else{}
}else{}
}
}else{}
$i = 0;
$result = mysql_query("SELECT * FROM pm WHERE `to` = '$uuser' && `read` != -1 ORDER by id DESC", $db);
while (list($id, $from, $ipsender, $to, $date, $time, $sub, $mes, $read) =
mysql_fetch_row($result)){
?>
<tr>
<td>
<input type="checkbox" name="<? echo $i?>" value="<? echo $id ?>">
</td>
<td>
<a href="pm_new.php?to=<? echo $from ?>"><? echo $from ?></a>
</td>
<td>
<? echo $date ?> <? echo $time ?>
</td>
<td>
<a href="pm_read.php?m=<? echo $id ?>"><? echo $sub ?></a>
</td>
</tr>
<?
$i++;
}
?>
</table>
<table width="600">
<tr>
<td>
Wat wil je doen met de geselecteerde berichten?&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
<select name="what">
<option value="delete">Verwijder</option>
<option value="unread">Markeer ongelezen</option>
<option value="read">Markeer gelezen</option>
</select>
<input type="submit" value="Go">
</td>
</tr>
</table>
</form>
</body>
</html>

en Pm_new.php

<?php
$db_host = "localhost";
$db_user = "******";
$db_pass = "*******";
$db_name = "***************";
$uuser = "gebruiker naam hier";
$db = mysql_connect($db_host,$db_user,$db_pass);
mysql_select_db($db_name, $db);
?> 
<?php
include ("pm_head.php");
if (!isset($_POST["submit"])){
if (isset($_GET["to"])){
$to = $_GET["to"];
}else{
$to = "";
}
if (isset($_GET["id"])){
$id = $_GET["id"];
$result = mysql_query("SELECT * FROM pm WHERE to = '$uuser' && id = '$id' " , $db);
while (list($mid, $mfrom, $mipsender, $mto, $mdate, $mtime, $msub, $mmes) =
mysql_fetch_row($result)){
$rsub = "re:";
$rsub .= $msub;
$rmes = "\n\r\n\rOriginal Message:\n";
$rmes .= $mmes;
}
}else{
$rsub = "";
$rmes = "";
}
?>
<table width="600">
<tr>
<td width="15%">
<form action="pm_new.php" method="post" name="send">
<b>Ontvanger</b>:
</td>
<td width="85%">
<input type="text" name="to" value="<? echo $to ?>"><input type="button" value="Selecteer vriend" onclick="window.open('pm_buddy.php','pm_buddy','width=200,HEIGHT=200,scrollbars=no,left=0,top=0,screenX=0,screenY=0')">
</td>
</tr>
<tr>
<td>
<b>Titel</b>:
</td>
<td>
<input type="text" name="sub" value="<? echo $rsub ?>" size="80">
</td>
</tr>
<tr>
<td align="center" colspan="2">
<b>Bericht</b>:<br><br>
<textarea rows="5" name="mes" cols="71"><? echo $rmes?></textarea>
</tr>
<tr>
<td align="center" colspan="2">
<input type="submit" name="submit" value="Send">
</td>
</tr>
</table>
</form>
<?
}else{
if ($_POST["to"] != "" && $_POST["mes"] != ""){
$to = $_POST["to"];
$mes = $_POST["mes"];
if  ($_POST["sub"] != ""){
$sub = $_POST["sub"];
}else{
$sub = "Geen";
}
$blocked = "0";
$check_blocklist = mysql_query("SELECT * FROM pmoptions WHERE user = '$uuser' LIMIT 1");
while (list($id, $user, $alert, $buddy, $block, $dwd) =
mysql_fetch_row($check_blocklist)){
$blocks = explode("|",$block);
$blocks_count = count($blocks) - "1";
if ($blocks_count >= "0"){
for ($i=0;$i<$blocks_count;$i++){
if ($blocks[$i] == $uuser){
$blocked++;
}else{
}
}
}else{}
}
if ($blocked == "0"){
$date =  date("j-n-Y");
$time =  date("G:i:s");
$ipsender = $_SERVER["REMOTE_ADDR"];
$query = "INSERT INTO pm (`from`, `ipsender`, `to`, `date`, `time`, `sub`, `mes`) VALUES ('$uuser','$ipsender','$to','$date','$time','$sub','$mes')";
mysql_query($query);
}

?>
<table width="600">
<tr>
<td>
Jouw bericht naar <? echo $to ?> is succesvol verzonden!<br>
<a href="pm_inbox.php">Klik hier</a> om terug te gaan naar je inbox.
</td>
</tr>
</table>
<?
}else{
?>
<table width="600">
<tr>
<th>
Je hebt het formulier niet volledig ingevult, dus is je bericht niet verstuurt<br>
<a href="pm_new.php">Klik hier</a> om het nog een keer te proberen.
</th>
</tr>
</table>
<?
}
}
?>
</body>
</html>

Ik hoop dat jullie een oplossing kunnen vinden.