login  Naam:   Wachtwoord: 
Registreer je!
 Scripts:
Scripts > PHP > Oude scripts > Privé berichten systeem

Privé berichten systeem

Auteur: cowbeast - 31 augustus 2004 - 19:46 - Gekeurd door: Dennisvb - Hits: 7981 - Aantal punten: 3.00 (9 stemmen)


Helloow

Ik terug(cowbeast)
Dit is een script dat niet van mij is maar het is wel zeer goed!! Het is het oude pm systeem van sitemasters!! van v1 dus!!

Veel plezier!!

Greetz Mathieu(cowbeast)

Code:

Config.php
######### 

  1. <?php 
  2. //connecten naar de database 
  3. mysql_connect ("localhost","username", "password"); 
  4. mysql_select_db("database"); 
  5. ?>



Berichttoevoegen.php
################## 

  1. <?php 
  2. include ("config.php"); 
  3. $tijd = date("H:i"); 
  4.  
  5. //nederlandse datum opstellen 
  6.  
  7. $dagvanweek = date("l"); 
  8. $arraydag = array("Zondag", "Maandag", "Dinsdag", 
  9. "Woensdag", "Donderdag", 
  10. "Vrijdag", "Zaterdag"); 
  11. $dagvanweek = $arraydag[date("w")]; 
  12. $arraymaand = array("Januari", "Februari", "Maart", "April", "Mei", 
  13. "Juni", "Juli", "Augustus", "September", 
  14. "Oktober", "November", "December"); 
  15. $datum = date("j ") . $arraymaand[date("n") - 1] . date(" Y"); 
  16. if(isset($_POST['Submit'])) { //als er op submit is gedrukt 
  17. //checken of alles ingevuld is 
  18. if ($_POST['titel'] == "") 
  19.   $error ="Je moet een titel invullen !"; 
  20.   elseif ($_POST['bericht'] == "") 
  21.   $error = "Je moet een bericht invullen !"; 
  22. if ($error) 
  23.   { //als er iets niet is ingevuld... 
  24. ?><div align="center"><table width="50%" border="1" 
  25.        cellspacing="0" cellpadding="2"> 
  26.        <tr bordercolor="#000000"> 
  27.        <td bordercolor="#000000" bgcolor="#CCCCCC" height="36"> 
  28.        <div align="center"><font color="#000000" face="Verdana, 
  29.        Arial, Helvetica, sans-serif" size="-1"><div align=center> 
  30.        <font color=black size=-1 face=verdana><b>$error</b> 
  31.        <br></font></div></font></div> 
  32.        <form method="post" action="javascript:history.go(-1)"> 
  33.        <div align=center><input type="submit" name="Terug" 
  34.        value="Terug"></div> 
  35.        </form></td></tr></table></div> 
  36. <?php 
  37.   } 
  38. elseif (!$error) //als alles is ingevuld ... 
  39.   { 
  40.  
  41.  
  42. $titel = addslashes($titel); 
  43. $bericht = htmlspecialchars($bericht,ENT_QUOTES); 
  44. $bericht = addslashes($bericht); 
  45. $bericht = nl2br($bericht); 
  46. $bericht = str_replace("<br />", "", $bericht); 
  47. $jenickname =stripslashes($jenickname); 
  48.  
  49. //MOGELIJK AANPASSEN VAN GEGEVENS 
  50. //JENICKNAME EN JEID IS MAAR EEN VOORBEELD 
  51. //JE ZAL DAT MOETEN VERANDEREN NAAR WAT DE WAARDE IS VAN DE ID VAN DE MEMBER EN DE NICKNAME ETC. 
  52.  
  53. $query = "INSERT INTO berichten (titel, wie, bericht, datum, 
  54. tijd, van, vanid) VALUES ('$titel', '$nummer', '$bericht', '$datum', 
  55. '$tijd', '$jenickname', '$jeid')"; 
  56. mysql_query($query) or die (mysql_error()); 
  57.  
  58. echo "Het bericht is succesvol gestuurd naar de persoon"; 
  59.  
  60.   } 
  61. } 
  62.  
  63. else 
  64.  
  65. { 
  66.  
  67. ?> 
  68. <form method="post" action=""> 
  69.   <table width="100%" border="0" cellspacing="0" cellpadding="2"> 
  70.     <tr> 
  71.       <td> 
  72.         <div align="center"><font face="Verdana, Arial, Helvetica, sans-serif" size="-1">Naar 
  73.           wie:</font></div> 
  74.       </td> 
  75.     </tr> 
  76.     <tr> 
  77.       <td> 
  78.         <div align="center"> <font face="Verdana, Arial, Helvetica, sans-serif" size="-1"> 
  79.           <select name="nummer" size="1"> 
  80.             <?php 
  81. $query = mysql_query("SELECT * FROM members order by nickname"); 
  82. while ($obj2 = mysql_fetch_object($query)) { 
  83. $persoon = $obj2->nickname; 
  84. echo"<option value=\"$persoon\">$persoon</option>"; 
  85. } 
  86. ?> 
  87.           </select> 
  88.           </font></div> 
  89.       </td> 
  90.     </tr> 
  91.     <tr> 
  92.       <td> 
  93.         <div align="center"><font face="Verdana, Arial, Helvetica, sans-serif" size="-1">Titel:</font></div> 
  94.       </td> 
  95.     </tr> 
  96.     <tr> 
  97.       <td> 
  98.         <div align="center"> <font face="Verdana, Arial, Helvetica, sans-serif" size="-1"> 
  99.           <input type="text" name="titel" size="50" maxlength="50"> 
  100.           </font></div> 
  101.       </td> 
  102.     </tr> 
  103.     <tr> 
  104.       <td> 
  105.         <div align="center"><font face="Verdana, Arial, Helvetica, sans-serif" size="-1">Bericht:</font></div> 
  106.       </td> 
  107.     </tr> 
  108.     <tr> 
  109.       <td> 
  110.         <div align="center"><font face="Verdana, Arial, Helvetica, sans-serif"><font size="-1"> 
  111.           <textarea name="bericht" cols="60" rows="20"></textarea> 
  112.           </font></font></div> 
  113.       </td> 
  114.     </tr> 
  115.     <tr> 
  116.       <td>&nbsp;</td> 
  117.     </tr> 
  118.     <tr> 
  119.       <td> 
  120.         <div align="center"> 
  121.           <input type="submit" name="Submit" value="Stuur bericht"> 
  122.           <input type="reset" name="Reset" value="Reset"> 
  123.         </div> 
  124.       </td> 
  125.     </tr> 
  126.   </table> 
  127. </form> 
  128. <?php 
  129. } 
  130. ?>



berichtenzien.php
############## 

  1. <?php 
  2. include ("config.php"); 
  3. if ($delber) 
  4.   { 
  5. $query = "DELETE from berichten where wie = '$jenickname'"; 
  6.  
  7. //AANPASSEN 
  8.  
  9. mysql_query($query); 
  10.  
  11. foreach($_POST as $key => $value) { 
  12.     if($value == "delete") { 
  13.         mysql_query("DELETE FROM berichten WHERE id='" . $key . "'") or die(mysql_error()); 
  14.     } 
  15. } 
  16.  
  17. echo "<div align = center><font face=verdana size=2> 
  18. De geselecteerde berichten zijn verwijderd</font></div>"; 
  19.   } if (!$delber) 
  20.   { 
  21. $query = mysql_query("SELECT * FROM berichten where wie = '$jenickname'"); 
  22.  
  23. //AANPASSEN 
  24.  
  25. $totaal = mysql_num_rows($query); 
  26. if ($totaal > 0) 
  27.     { 
  28. ?> 
  29.  
  30. <script language = "Javascript"> 
  31. function SelecteerAlles() { 
  32. if (document.delber.check_all.checked==1) { 
  33.     val=1; 
  34. } else { 
  35.     val=0; 
  36. } 
  37. dml=document.forms['delber']; 
  38. len = dml.elements.length; 
  39.  
  40. var i=0; 
  41. for( i=0 ; i<len ; i++) { 
  42.     if (dml.elements[i].value=='delete') { 
  43.     dml.elements[i].checked=val; 
  44.     } 
  45. } 
  46. } 
  47. </script> 
  48.  
  49. <form name="delber" method="post" action=""> 
  50.   <table width="100%" border="1" cellspacing="0" cellpadding="2" bordercolor="#000000" bgcolor="#CCCCCC"> 
  51.     <tr> 
  52.  
  53.       <td width="4%"> 
  54.         <div align="center">&nbsp;</div> 
  55.       </td> 
  56.  
  57.       <td width="39%"> 
  58.         <div align="center"><b><font face="Verdana, Arial, Helvetica, sans-serif" size="-1">Titel:</font></b></div> 
  59.       </td> 
  60.       <td width="30%"> 
  61.         <div align="center"><b><font face="Verdana, Arial, Helvetica, sans-serif" size="-1">Poster:</font></b></div> 
  62.       </td> 
  63.       <td width="31%"> 
  64.         <div align="center"><b><font face="Verdana, Arial, Helvetica, sans-serif" size="-1">Verzonden 
  65.           op:</font></b></div> 
  66.       </td> 
  67.     </tr> 
  68.     <?php 
  69.  
  70. $query = "SELECT * FROM berichten where wie = '$jenickname' ORDER BY id DESC"; 
  71.  
  72. //AANPASSEN 
  73.  
  74. $record = mysql_query($query); 
  75. while ($obj = mysql_fetch_object($record)) 
  76.       { 
  77. $titel = stripslashes($obj->titel); 
  78. $van = $obj->van; 
  79. $vanid =$obj->vanid; 
  80. $datum =$obj->datum; 
  81. $berichtid =$obj->id; 
  82. $persoon =stripslashes($obj->van); 
  83.  
  84. $bericht_id = $obj->id; 
  85.  
  86. if($obj->gelezen == 1) { $kleur = "#FFFFFF"; } 
  87. else { $kleur = "#E8E8E8"; } 
  88. ?> 
  89.     <tr bgcolor="<?php echo $kleur; ?>"> 
  90.  
  91.       <td width="4%"><font face="Verdana, Arial, Helvetica, sans-serif" size="-1"> 
  92.       <?php 
  93.       echo "<input type=\"checkbox\" name=\"" . $bericht_id . "\" value=\"delete\">\n"; 
  94.       ?> 
  95.         </font></td> 
  96.  
  97.       <td width="39%"><font face="Verdana, Arial, Helvetica, sans-serif" size="-1"> 
  98.         <?php echo"<a href=\"index.php?action=bekijkbericht&id=$berichtid\">$titel</a>"; ?> 
  99.         </font></td> 
  100.       <td width="26%"> 
  101.         <div align="center"><font face="Verdana, Arial, Helvetica, sans-serif" size="-1"> 
  102.         <?php echo"<a href=\"index.php?action=profielpersoon&id=$vanid\">$persoon</a>"; ?> 
  103.           </font></div> 
  104.       </td> 
  105.       <td width="31%"> 
  106.         <div align="center"><font face="Verdana, Arial, Helvetica, sans-serif" size="-1"> 
  107.         <?php echo"$datum, $obj->tijd"; ?> 
  108.           </font></div> 
  109.       </td> 
  110.     </tr> 
  111. <?php 
  112.       } 
  113. ?> 
  114.     <tr bgcolor="#FFFFFF"> 
  115.       <td colspan="4" height="3"> 
  116.         <div align="right"><input type="checkbox" name="check_all" value="checkall" 
  117. onClick="javascript:SelecteerAlles()"> Selecteer alle berichten. &nbsp; 
  118. <input type="submit" name="delber" value="Verwijder geselecteerde berichten"></div> 
  119.       </td> 
  120.     </tr> 
  121.  
  122.  
  123.   </table> 
  124. </form> 
  125. <?php 
  126.     } else 
  127.     { 
  128. echo "<p align=\"center\"><font size=\"-1\" 
  129. face=\"Verdana, Arial, Helvetica, sans-serif\">Je hebt geen 
  130. berichten in je postenvak.</font></p>"; 
  131.     } 
  132.   } 
  133. ?>



bekijkbericht.php
############# 

  1. <?php 
  2. include ('config.php'); 
  3.  
  4. $query =@mysql_query("SELECT wie FROM berichten WHERE id='$id'"); 
  5. $wie = @mysql_result($query,0,"wie"); 
  6.  
  7. if ($wie == $jenickname) { //MOGELIJK AANPASSEN 
  8.  
  9. $query = "SELECT * FROM berichten where id = $id"; 
  10. $record = mysql_query($query); 
  11. while ($obj = mysql_fetch_object($record)) { 
  12.     $titel = stripslashes($obj->titel); 
  13.     $persoon = stripslashes($obj->van); 
  14.     $datum =$obj->datum; 
  15.     $tijd =$obj->tijd; 
  16.     $berichtid = $obj->id; 
  17.     $van = $obj->van; 
  18.     $vanid=$obj->vanid; 
  19.     $bericht = $obj->bericht; 
  20.     $bericht = str_replace ("&lt;", "<", $bericht); 
  21.     $bericht = str_replace ("&gt;", ">", $bericht); 
  22.     $bericht = str_replace ("&quot;", "\"", $bericht); 
  23.     $bericht = str_replace ("&amp;", "&", $bericht); 
  24.     $bericht = str_replace ("<br />", "", $bericht); 
  25.     $bericht = str_replace("&#039;","'",$bericht); 
  26.  
  27. $bericht=highlight_string(stripslashes($bericht)); 
  28. $query2 = "UPDATE berichten SET gelezen = 1 where id = $id"; 
  29. mysql_query($query2); 
  30.   ?> 
  31.   <table width="100%" border="1" cellspacing="0" cellpadding="2" bordercolor="#000000"> 
  32.   <tr> 
  33.   <td height="22"> <font color="#FFFFFF" face="Verdana, Arial, Helvetica, sans-serif" size="-1"> 
  34.   <?php echo("<font face=arial color=#FFFFFF><b>$titel</b></font>"); ?> 
  35.   </font></td> 
  36.   </tr><tr> 
  37.     <td height="23" valign="top"><b><font color="#000000" face="Verdana, Arial, 
  38.   Helvetica, sans-serif" size="-1"> Gepost door :</font></b> <font color="#000000"> 
  39.       <?php echo("<font face=verdana size=-1 color=#000000>$persoon</font>"); ?> 
  40.       <br> 
  41.       <b><font face="Verdana, Arial, Helvetica, sans-serif" size="-1">Gepost op:</font></b></font> 
  42.       <?php echo("<font face=verdana size=-1 color=#000000>$datum, $tijd</font>"); ?> 
  43.       &nbsp; <br> 
  44.   <hr noshade> 
  45.   <?php echo("<font face=verdana color=#000000>$bericht</font>"); ?> 
  46.   </td> 
  47.   </tr> 
  48.   </table> 
  49. <?php 
  50. } 
  51. ?> 
  52. <br> 
  53. <?php 
  54. if ($Submit) { 
  55.   if (!$bericht2) 
  56.   $error = "Je moet een bericht invullen<br><br>"; 
  57.   elseif (!$titel2) 
  58.   $error = "Je moet een titel invullen<br><br>"; 
  59.   if (!$error) { 
  60.     $tijd2 = date("H:i"); 
  61.     $dagvanweek = date("l"); 
  62.     $arraydag = array("Zondag", "Maandag", "Dinsdag", 
  63.     "Woensdag", "Donderdag", "Vrijdag", "Zaterdag"); 
  64.     $dagvanweek = $arraydag[date("w")]; 
  65.     $arraymaand = array("Januari", "Februari", "Maart", "April", "Mei", 
  66.     "Juni", "Juli", "Augustus", "September", 
  67.     "Oktober", "November", "December"); 
  68.     $datum2 = date("j ") . $arraymaand[date("n") - 1] . date(" Y"); 
  69.     $bericht2 = htmlspecialchars($bericht2,ENT_QUOTES); 
  70.     $titel2 = addslashes($titel2); 
  71.     $bericht2 = addslashes($bericht2); 
  72.     $bericht2 = nl2br($bericht2); 
  73.     $bericht2 = str_replace("<br />", "", $bericht2); 
  74.     $query = "INSERT INTO berichten (titel, wie, bericht, datum, 
  75.     tijd, van, vanid) VALUES ('$titel2', '$persoon', 
  76.     '$bericht2', '$datum2', '$tijd2', '$jenickname', '$jeid')"; 
  77.     mysql_query($query) or die (mysql_error()); 
  78.     echo " Je reactie is succesvol gepost !"; 
  79.   } elseif ($error) 
  80.   { ?> 
  81.     <div align="center"><table width="50%" border="1" 
  82.     cellspacing="0" cellpadding="2"> 
  83.     <tr bordercolor="#000000"> 
  84.     <td bordercolor="#000000" bgcolor="#CCCCCC" height="36"> 
  85.     <div align="center"><font color="#000000" face="Verdana, 
  86.     Arial, Helvetica, sans-serif" size="-1"><div align=center> 
  87.     <font color=black size=-1 face=verdana><b>$error</b> 
  88.     <br></font></div></font></div> 
  89.     <form method="post" action="javascript:history.go(-1)"> 
  90.     <div align=center><input type="submit" name="Terug" 
  91.     value="Terug"></div> 
  92.     </form></td></tr></table></div> 
  93.     <?php 
  94.   }   
  95. } else 
  96. { 
  97. ?> 
  98. <form method="post" action=""> 
  99.  
  100.   <table width="100%" border="1" cellpadding="2" bordercolor="#000000" cellspacing="0"> 
  101.     <tr> 
  102.       <td height="38" bordercolor="#000000"> 
  103.         <div align="left"><font face="Verdana, Arial, Helvetica, sans-serif" size="-1"><b>Post 
  104.           een reactie:</b><br> 
  105.           </font> 
  106.           <hr noshade> 
  107.           <div align="center"><font face="Verdana, Arial, Helvetica, sans-serif" size="-1">Titel:</font></div> 
  108.         </div> 
  109.       </td> 
  110.     </tr> 
  111.     <tr> 
  112.       <td bordercolor="#000000" height="2"> 
  113.         <div align="center"> 
  114.           <input type="text" name="titel2" size="50" maxlength="50" value="Re: <?php echo"$titel"; ?>"> 
  115.         </div> 
  116.       </td> 
  117.     </tr> 
  118.     <tr> 
  119.       <td bordercolor="#000000" height="26"> 
  120.         <div align="left"><font face="Verdana, Arial, Helvetica, sans-serif" size="-1"> 
  121.           </font></div> 
  122.         <div align="center"><font size="-1" face="Verdana, Arial, Helvetica, sans-serif">Bericht:</font></div> 
  123.       </td> 
  124.     </tr> 
  125.     <tr> 
  126.       <td bordercolor="#000000"> 
  127.         <div align="center"> 
  128.           <textarea name="bericht2" cols="60" rows="10"></textarea> 
  129.         </div> 
  130.       </td> 
  131.     </tr> 
  132.     <tr> 
  133.       <td bordercolor="#000000">&nbsp;</td> 
  134.     </tr> 
  135.     <tr> 
  136.       <td bordercolor="#000000"> 
  137.         <div align="center"> 
  138.           <input type="Submit" name="Submit" value="Post reactie"> 
  139.           <input type="reset" name="Reset" value="Reset"> 
  140.         </div> 
  141.       </td> 
  142.     </tr> 
  143.   </table> 
  144. </form> 
  145. <?php 
  146. } 
  147. ?> 
  148. <br> 
  149. <div align="center"> 
  150.   <table width="100%" border="1" cellspacing="0" cellpadding="2" bordercolor="#000000" bgcolor="#FFFFFF"> 
  151.     <tr> 
  152.       <td> 
  153.         <div align="center"> 
  154.           <input type="submit" name="naarfberichten" value="Terug naar berichten" 
  155.           onClick="window.location='berichtenzien.php'"> 
  156.         </div> 
  157.       </td> 
  158.     </tr> 
  159.   </table> 
  160.   </div> 
  161. <?php 
  162. } else { 
  163. echo "<p align=\"center\"><font size=\"-1\" face=\"Verdana, Arial, Helvetica, sans-serif\">Dit bericht is niet naar jou gestuurd !</font></p>";     
  164. } 
  165. ?>



tabel.php
######## 

  1. <?php 
  2. include ("config.php"); 
  3. $query = mysql_query("SELECT * FROM berichten where wie = '$jenickname' AND gelezen = '0'"); 
  4.  
  5. //AANPASSEN 
  6.  
  7. $berichten = mysql_num_rows($query); 
  8. ?> 
  9. <table width="90%" border="1" cellspacing="0" cellpadding="0" bordercolor="#000000"> 
  10.         <tr> 
  11.           <td bgcolor="#999999" height="22" background="grijs2.jpg"> 
  12.             <div align="left"> <font size="-1" face="Arial, Helvetica, sans-serif" color="#FFFFFF"> 
  13.             &nbsp;<b>Berichten:</b> 
  14.               </font> </div> 
  15.           </td> 
  16.         </tr> 
  17.         <tr> 
  18.           <td bgcolor="#FFFFFF" valign="top" height="26"> 
  19.             <table width="100%" border="0" cellspacing="0" cellpadding="3"> 
  20.               <tr> 
  21.                 <td valign="top" height="75"> 
  22.                   <div align="left"> 
  23.                     <p><font face="Verdana, Arial, Helvetica, sans-serif" size="-1">Je 
  24.                       hebt <b> 
  25.                       <?php echo"$berichten"; ?> 
  26.                       </b> nieuw(e) berichten in je postvak.</font></p> 
  27.                     <p><font face="Verdana, Arial, Helvetica, sans-serif" size="-1"> 
  28. <font face="Verdana, Arial, Helvetica, sans-serif" size="-1"><font face="Arial, Helvetica, sans-serif"> 
  29. -<a href="berichtenzien.php">Berichten 
  30.                       bekijken</a></font></font><font face="Arial, Helvetica, sans-serif"><br> 
  31.                       -<a href="berichttoevoegen.php">Bericht posten</a></font></font></p> 
  32.                   </div> 
  33.                 </td> 
  34.               </tr> 
  35.             </table> 
  36.           </td> 
  37.         </tr> 
  38.       </table>



De MySQL db!
#################

  1. CREATE TABLE `berichten` ( 
  2.   `id` int(10) NOT NULL auto_increment, 
  3.   `van` varchar(20) NOT NULL default '0', 
  4.   `vanid` int(5) NOT NULL default '0', 
  5.   `gelezen` int(1) NOT NULL default '0', 
  6.   `titel` varchar(50) NOT NULL default '', 
  7.   `wie` varchar(20) NOT NULL default '0', 
  8.   `bericht` text NOT NULL, 
  9.   `datum` varchar(15) NOT NULL default '', 
  10.   `tijd` varchar(15) NOT NULL default '', 
  11.   PRIMARY KEY  (`id`) 
  12. ) TYPE=MyISAM;

 Download code! Download code (.txt)

 Stemmen
Niet ingelogd

 Reacties
Post een reactie
Lees de reacties  ( 18 )
© 2002-2012 Sitemasters.be - Regels - Gehost door: Vircon - Laadtijd: 0.265s