connect("poetrydmv");
if ( $_POST[action] == "send" )
{
if ( ( strlen(Trim($_POST[t_message])) == 0 ) ||
( strlen(Trim($_POST[i_recipientid])) == 0 ) )
{
$message = "You Must Fill Out The Message Form To Send";
} else {
$message = "Message Sent";
$t_message = nl2br(strip_tags($_POST[t_message]));
$now = time();
$dmv->exec("INSERT INTO member_messages VALUES ( $now, $mem_id, $_POST[i_recipientid], now(), 'f', '$t_message' );");
}
}
if ( $_GET[action] == "purge" )
{
$message = "Message History Purged";
$sql = "DELETE FROM member_messages WHERE i_recipientid = $mem_id;";
$dmv->exec($sql);
}
if ( $_GET[action] == "delete" )
{
$message = "Message Deleted";
$dmv->exec("DELETE FROM member_messages WHERE i_messageid = $_GET[mid] AND i_recipientid = $_GET[i_recipientid];");
$include='/communicator.php?mode=history&offset=0';
Header("Location: $include");
}
if ( $_GET[action] == "addFriend" )
{
$message = "Friend Added";
$sql = "INSERT INTO member_friends VALUES ( $mem_id, $_GET[i_friendid]);";
$dmv->exec($sql);
}
if ( $_GET[action] == "removeFriend" )
{
$message = "Friend Deleted";
$dmv->exec("DELETE FROM member_friends WHERE i_memberid = $mem_id AND i_friendid = $_GET[i_friendid];");
}
if ( ( $_POST[action] == "sendAll" ) && ( $_SESSION[member][i_memberstate] > 2 ) )
{
if ( strlen(Trim($_POST[t_message])) == 0 )
{
$message = "You Must Fill Out The Message Form To Send";
} else {
$t_message = nl2br(strip_tags($_POST[t_message]));
$now = time();
$sql = "SELECT i_memberid FROM members WHERE i_memberstate > 0 AND status=1 AND member_type IN (1,2,3,4,5,7,8) ";
if ( isset($_POST[filter]) )
{
if ($_POST[filter] == 'online' ) {
$sql .= "AND i_timestamp > ".$threshold." ";
$t_message = "DMV ALERT:\n" . $t_message;
}
if ( $_POST[filter] == "aboard" ) {
$sql .= " AND member_type IN (1,7,8) ";
$t_message = "ABoard Mass Message:
\n" . $t_message;
}
if ( $_POST[filter] == "admins" ) {
$sql .= " AND i_memberstate > 1";
$t_message = "Admin Mass Message:
\n" . $t_message;
}
if ( $_POST[filter] == "patrons" ) {
$sql .= " AND b_patron = 't'";
$t_message = "Patron Mass Message:
\n" . $t_message;
}
} else {
$t_message = "Mass Message:
\n" . $t_message;
}
$sql .= " ORDER BY i_memberid;";
$amv= new poetrydmv();
$amv->connect("poetrydmv");
$dmv->exec($sql);
$rows = $dmv->RecordCount();
$dmv->moveFirst();
for ( $y = 0; $y < $rows; $y++ )
{
$rs=$dmv->fobject();
$amv->exec("INSERT INTO member_messages VALUES ( $now, $mem_id, $rs->i_memberid, now(), 'f', '$t_message' );");
$dmv->moveNext();
}
$message = "Message Sent to $rows Members";
$amv->close();
}
}
if ( isset($_GET[returnto]) ) $_GET[mode] = $_GET[returnto];
include("communicator.php");
$dmv->close();
?>