2c2
< // moderation.php
---
> // moderate.php
6,53d5
< include "db_connect.php";
< $link=null;
< $dbname="users";
< $utable="musers";
< $ucolumn="username";
< if( isset( $_GET['utable'] ) ) {
<   $utable=$_GET['utable'];
< }
< if( isset( $_POST['utable'] ) ) {
<   $utable=$_POST['utable'];
< }
< if( isset( $_GET['dbname'] ) ) {
<   $dbname=$_GET['dbname'];
< }
< if( isset( $_POST['dbname'] ) ) {
<   $dbname=$_POST['dbname'];
< }
< if( isset( $_GET['ucolumn'] ) ) {
<   $ucolumn=$_GET['ucolumn'];
< }
< if( isset( $_POST['ucolumn'] ) ) {
<   $ucolumn=$_POST['ucolumn'];
< }
< 
< function insertposting($cont) {
<   global $dbname;
<   $pusername="";
<   if ( isset( $_POST['username'] ) ) {
<     $pusername=urldecode($_POST['username']);
<   }
<   $temail="";
<   if ( isset( $_POST['email'] ) ) {
<     $temail=urldecode($_POST['email']);
<   }
<   $pstatus="moderating";
<   try {
<     if (!$link) $link = db_connect(); 
<     if (!$link) {
<        die('Could not connect: ' . mysql_error());
<     }
<     mysql_select_db($dbname);
<     $result = mysql_query("insert into posting values (NULL,'".$cont."', '".$pusername."', '".$temail."', '".$pstatus."')");
<   } catch (Exception $e) {
<     die('Could not connect: ' . mysql_error());
<   }
< }
< 
< 
65d16
<      $from = "From: rmetcalfe@rjmprogramming.com.au \r\n";
67c18
<       mail("rmetcalfe@rjmprogramming.com.au", "Things That We Have in Common ... " . $thisidea . " ... " . date('l jS \of F Y h:i:s A'), $thisidea, $from);
---
>       mail("rmetcalfe@rjmprogramming.com.au", "Things That We Have in Common ... " . $thisidea . " ... " . date('l jS \of F Y h:i:s A'), $thisidea);
80c31
<      $amsg="<div align='center' style='width:100%;'><iframe src='./login.php' title='Admin login' style='height:600px;;width:100%;'></iframe></div>";
---
>      $amsg="<div align='center'><iframe src='./login.php' title='Admin login' style='height:600px;'></iframe></div>";
84,95d34
< if (isset($_POST['mymdbidea'])) {
<  $msg='?';
<  $thisidea=urldecode($_POST['mymdbidea']);
<      $msg='@' . $thisidea;
<  if ($thisidea != '') {
<      insertposting(urlencode($_POST['mymdbidea']));
<      $msg='!';
<      date_default_timezone_set('Australia/Perth');
<      $amsg="<div align='center' style='width:100%;'><iframe src='./login.php' title='Admin login' style='height:600px;width:100%;'></iframe></div>";
<      $msg="Things That We Have in Common  " . date('l jS \of F Y h:i:s A') . " ... " . $thisidea . " ... has been flagged in the database for moderation (within 24 hours).";
<  }
< }
112,113d50
<  var sbutdb=null;
<  var mformdb=null;
136,146d72
<  function submitdbform() {
<    var mmoddb=document.getElementById('mydbmod' + thiscnt);
<    if (mmoddb != null) {
<     document.getElementById('mymdbidea').value=decodeURIComponent(mmoddb.title);
<    } 
<    //mformdb=document.getElementById('dbmoderation');
<    sbutdb=document.getElementById('dbsubmit');
<    //mformdb.submit();
<    sbutdb.click();
<    setTimeout(andthendb, 1000);
<  }
153,155d78
<  function andthendb() {
<    document.getElementById('mymideadb').value='';
<  }
166,168d88
<  function dbcnt(ot) {
<    thiscnt=eval(ot.id.replace('mydbmod',''));
<  }
207,210d126
< </form>
< <form action='./moderation.php' method='POST' align='center' name='dbmoderation' id='dbmoderation'>
< Database Moderation (ie. click resultant moderation button and will be sent for moderation and, perhaps, be included in list above within 24 hours):<br> <input style='width:100%;' type='text' name='mymdbidea' id='mymdbidea' value='' onblur=" if (this.value != '') { cnt++; thiscnt=cnt; document.getElementById('mytbody').innerHTML+='<tr><td><input id=mydbmod' + cnt + ' style=background-color:pink; type=button onmousedown=dbcnt(this); onclick=setTimeout(submitdbform,1000); value=Moderate title=' + encodeURIComponent(this.value) + '></input>' + ' ' + this.value + '</td><td></td>'; this.value='';  }   "></input><br><br>
< <input style='display:none;' id='dbsubmit' type='submit' value='Moderate'></input>