Ripple's miniBoard - RealityRipple

Affiliate:

Home | Message Boards | Hire | About | Site Map

Don Limpio | Grim Jim | Incredible Singing Robot
Mr. Quencho | Ruined Landscape | Windows XP

Battle.net Utilities | Windows Themes
Windows Cursors | Trillian Skins

Home

Freeware

Mozilla

Flash

Other
Message Boards

Hire

About

Site Map

Ripple's miniBoard

If you'd like your own comment message board system like the one seen on this site, all you need is PHP and a MySQL database (code can be modified to use a text file or other database types). Below are the sources to the files needed for the comment system. They are fully editable with simple HTML and CSS, and most of the code should be self-explanitory.

comment.php:

<?php 
 if( isset($_POST['txtApp']))
 {
  $appURL = $_POST['txtApp'];
  if(!empty($_POST['submit']))
  {
   if($_SESSION['security_code'] == $_POST['txtCaptcha'] && !empty($_SESSION['security_code']))
   {
    if(!empty($_POST['txtName']))
    {
     if(!empty($_POST['txtMsg']))
     {
      unset($_SESSION['security_code']);
      $username = stripslashes(htmlspecialchars($_POST['txtName'], ENT_QUOTES));
      $message = stripslashes(ereg_replace("\n", "<br>", htmlspecialchars($_POST['txtMsg'], ENT_QUOTES)));
      require('/direct/path/to/getDB.inc');
      $dbName = getDB($appURL);
      $user="Anonymous";
      $password="******";
      $database="db1";
      $host="db.myserver.com";
      $db = mysql_connect($host,$user,$password);
      @mysql_select_db($database, $db) or die("");
      $query = "CREATE TABLE IF NOT EXISTS `$dbName` (id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, posttime TIMESTAMP DEFAULT NOW(), username TINYTEXT, message TEXT);";
      if (!mysql_query($query, $db))
      {
       $title = 'Error';
       $body = "     <div class=\"title\">Error</div>\n";
       $body.= "     <p>There was a database error (creating table) while attempting to submit your comment: ".mysql_error()."</p>\n";
       $body.= "     <p style=\"text-align: center;\"><a href=\"$appURL\">Back</a></p>\n";
      }
      else
      {
       $query = "INSERT INTO `$dbName` (username, message) VALUES('$username', '$message');";
       if (!mysql_query($query, $db))
       {
        $title = 'Error';
        $body = "     <div class=\"title\">Error</div>\n";
        $body.= "     <p>There was a database error (inserting row) while attempting to submit your comment: ".mysql_error()."</p>\n";
        $body.= "     <p style=\"text-align: center;\"><a href=\"$appURL\">Back</a></p>\n";
       }
       else
       {
        $title = 'Thank You';
        $body = "     <div class=\"title\">Thank You</div>\n";
        $body.= "     <p>You have posted your comment! Thank you for your input.</p>\n";
        $body.= "     <p style=\"text-align: center;\"><a href=\"$appURL\">Back</a></p>\n";
       }
      }
      mysql_close($db);
     }
     else
     {
      $title = 'Error';
      $body = "     <div class=\"title\">Error</div>\n";
      $body.= "     <p>You did not submit a comment to be posted! Please go back and try again.</p>\n";
      $body.= "     <p style=\"text-align: center;\"><a href=\"$appURL\">Back</a></p>\n";
     }
    }
    else
    {
     $title = 'Error';
     $body = "     <div class=\"title\">Error</div>\n";
     $body.= "     <p>You did not submit a name to use! Please go back and try again.</p>\n";
     $body.= "     <p style=\"text-align: center;\"><a href=\"$appURL\">Back</a></p>\n";
    }
   }
   else
   {
    $title = 'Error';
    $body = "     <div class=\"title\">Error</div>\n";
    $body.= "     <p>The Captcha code you entered was incorrect! Please go back and try again.</p>\n";
    $body.= "     <p style=\"text-align: center;\"><a href=\"$appURL\">Back</a></p>\n";
   }
  }
  else
  {
   $title = 'Error';
   $body = "     <div class=\"title\">Error</div>\n";
   $body.= "     <p>You did not submit a comment to be posted! Please go back and try again.</p>\n";
   $body.= "     <p style=\"text-align: center;\"><a href=\"$appURL\">Back</a></p>\n";
  }
 }
 else
 {
  $title = 'Error';
  $body = "     <div class=\"title\">Error</div>\n";
  $body.= "     <p>You did not submit this message from a valid program page. Please don't mess around if you don't know what you're doing.</p>\n";
  $body.= "     <p style=\"text-align: center;\"><a href=\"http://realityripple.com\">Home</a></p>\n";
 }
?><!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
<html lang="en-US">
 <head>
  <title>
   <?php echo $title; ?>
  </title>
 </head>
 <body>
<?php echo $body;?>
 </body>
</html>

This file should be included into whatever page(s) you wish to have a message board on. Please leave the hyperlink in tact, so that others may have access to the source code as you have.

add.inc:

<table style="width: 100%;">
 <tr><th>Comments</th><th>Add a Comment</th></tr>
  <tr>
   <td valign="top">
    <div style="overflow: auto; height: 200px; font-family: Lucida Console; font-size: 12px; text-align: left;">
     <table width="100%">
<?php
 require('/direct/path/to/getDB.inc');
 $dbName   = getDB($appURL);
 $user     = "Anonymous";
 $password = "******";
 $database = "db1";
 $host     = "db.myserver.com";
 mysql_connect($host,$user,$password);
 @mysql_select_db($database) or die("");
 $appURL   = $_SERVER['ORIG_SCRIPT_NAME'];
 $query    = "SELECT * FROM `$dbName` ORDER BY posttime DESC;";
 $ret      = mysql_query($query);
 if (!$ret)
 {
  echo '     <tr><td style="text-align: center;">Share your opinion! Add a comment instantly on the right.</td></tr>'."\n";
 }
 else
 {
  while ($row = mysql_fetch_array($ret))
  {
   echo '    <tr>';
   echo '<td valign="top" style="text-align: left; font-weight: bold;">'.$row['username'].'</td>';
   $postTime = date('M j Y g:i A', strtotime($row['posttime']));
   echo '<td><div style="text-align: right; font-style: italic; color: #CCCCCC;">'.$postTime.'</div>';
   echo '<div style="text-align: left;">'.$row['message'].'</div></td>';
   echo '</tr><tr><td colspan="2"><hr></td></tr>'."\n";
  }
 }
?>
    </table>
   </div>
  </td>
  <td rowspan="5" valign="top" style="width: 250px;" >
   <form action="http://realityripple.com/site/comments/comment.php" method="post">
     <table width="250">
      <tr><td style="width: 150px;"><input type="hidden" name="txtApp" value="<?php echo $appURL; ?>"><label for="txtName">Name:</label></td><td style="width: 150px;"><input id="txtName" name="txtName" type="text" style="width: 150px;" class="textbox"></td></tr>
      <tr><td><label for="txtMsg">Message:</label></td><td><textarea id="txtMsg" name="txtMsg" rows="3" cols="22" class="textbox"></textarea></td></tr>
     <tr><td><img src="http://realityripple.com/site/comments/Captcha.php?width=75&height=25" alt="CAPTCHA" title="Please enter the sequence of characters you see here in the text box to the right.">: </td><td><input id="txtCaptcha" name="txtCaptcha" type="text" style="width: 60px;" class="textbox">  <input type="image" name="submit" value="Comment" alt="Comment" title="Comment" src="<?php echo $sdir."button.php?t=Comment" ?>"></td></tr>
    </table>
   </form>
  </td>
 </tr>
 <tr><td colspan="2" class="listR" style="font-size: 10px; color: #CCCCCC;">Powered by <a href="http://realityripple.com/site/comments/" title="Ripple's miniBoard">RmB</a></td></tr>
</table>

If you want the board to be spread across multiple pages, you can either modify the getDB.inc file to have certain comment tables on certain pages, or write it out entirely and use only one table.

getDB.inc:

This file is a simple 5 character Captcha system. You may need the MonoFont file in the same directory as the Captcha.php file. Please remember to set the exact location to Captcha.php in add.inc.

Captcha.php:

<?php
 session_start();
 class Captcha
 {
  var $font = 'monofont.ttf';
  function generateCode($characters)
  {
   $possible = '23456789bcdfghjkmnpqrstvwxyz';
   $code = '';
   $i = 0;
   while ($i < $characters)
   { 
    $code .= substr($possible, mt_rand(0, strlen($possible)-1), 1);
    $i++;
   }
   return $code;
  }
  function Captcha($width='120',$height='40',$characters='6')
  {
   $code = $this->generateCode($characters);
   $font_size = $height * 0.75;
   $image = @imagecreate($width, $height) or die('Cannot initialize new GD image stream');
   $background_color = imagecolorallocate($image, 255, 255, 255);
   $text_color = imagecolorallocate($image, 20, 40, 100);
   $noise_color = imagecolorallocate($image, 100, 120, 180);
   for( $i=0; $i<($width*$height)/3; $i++ )
   {
    imagefilledellipse($image, mt_rand(0,$width), mt_rand(0,$height), 1, 1, $noise_color);
   }
   for( $i=0; $i<($width*$height)/150; $i++ )
   {
    imageline($image, mt_rand(0,$width), mt_rand(0,$height), mt_rand(0,$width), mt_rand(0,$height), $noise_color);
   }
   $textbox = imagettfbbox($font_size, 0, $this->font, $code) or die('Error in imagettfbbox function');
   $x = ($width - $textbox[4])/2;
   $y = ($height - $textbox[5])/2;
   imagettftext($image, $font_size, 0, $x, $y, $text_color, $this->font , $code) or die('Error in imagettftext function');
   header('Content-Type: image/jpeg');
   imagejpeg($image);
   imagedestroy($image);
   $_SESSION['security_code'] = $code;
  }
 }
 $width = isset($_GET['width']) ? $_GET['width'] : '150';
 $height = isset($_GET['height']) ? $_GET['height'] : '50';
 $characters = isset($_GET['characters']) && $_GET['characters'] > 1 ? $_GET['characters'] : '5';
 $captcha = new Captcha($width,$height,$characters);
?>