<?php
require("./global.php");
require("./lib/class_parse.php");
require("./lib/class_pages.inc.php");
require("./lib/class_options.inc.php");

$options = &new select_options();

$result = $db->unbuffered_query("SELECT * FROM bb".$n."_designelements WHERE designpackid = '1'");
while($row=$db->fetch_array($result)) $style[$row['element']] = $row['value'];
eval ("\$css = \"".$tpl->get("css")."\";");

$sql_user = $db->query("Select * From bb".$n."_users Order by username");
while($row=mysql_fetch_array($sql_user)) {
  $userselect .= $options->create_options($row['userid'], $row['username'], $_REQUEST['s_user']);
  $userselect2.= $options->create_options($row['userid'], $row['username'], $_REQUEST['s_user2']);
}

$s_reads[$_REQUEST['s_read']] = "selected=\"selected\"";
if(!isset($_REQUEST['lim']) || $_REQUEST['lim'] == "") $_REQUEST['lim'] = 0;
if(!isset($_REQUEST['delallconfirm']) || $_REQUEST['delallconfirm'] == "") $_REQUEST['delallconfirm'] = 0;

if($_REQUEST['dla_action'] == "delallpms") {
  if($_REQUEST['delallconfirm'] == 1) {
    $db->query("DELETE FROM bb".$n."_privatemessage");
    $db->query("ALTER TABLE bb".$n."_privatemessage AUTO_INCREMENT=1");
  } else {
    eval ("\$pms_bit = \"".$tpl->get("all_pms_delconfirm",1)."\";");
  }
}

if($_POST['del_action'] == "del_pm"){ 
  if($_POST['pmid'] && count($_POST['pmid'])) $pmids=implode(',',$_POST['pmid']);
    else $pmids="";
  if($pmids) {
    $db->query("DELETE FROM bb".$n."_privatemessage WHERE privatemessageid IN (".addslashes($pmids).")");
  }
  $all=$db->query_first("SELECT COUNT(*) AS anz FROM bb".$n."_privatemessage");
  $_REQUEST['action'] = "show";
}

$all=$db->query_first("SELECT COUNT(*) AS anz FROM bb".$n."_privatemessage");
$read=$db->query_first("SELECT COUNT(*) AS anz FROM bb".$n."_privatemessage WHERE view > '0'");
$unread=$db->query_first("SELECT COUNT(*) AS anz FROM bb".$n."_privatemessage WHERE view = '0'");

if($_REQUEST['action'] == "show") { 
  $pmsbit="";
  
  if($_REQUEST['s_read'] > 0 || $_REQUEST['s_user'] > 0 || $_REQUEST['s_user2'] > 0) $where = "Where";
    else $where = "";
  
  $r_pm = "";
  if($_REQUEST['s_read'] == 1) $r_pm = "view > '0'";
  if($_REQUEST['s_read'] == 2) $r_pm = "view = '0'";
  
  $u_pm = $u_pm2 = "";
  if($_REQUEST['s_user'] > 0) {
    if($_REQUEST['s_read'] > 0) $u_pm = "And ";
    $u_pm .= "senderid = '".$_REQUEST['s_user']."'";
  }
  if($_REQUEST['s_user2'] > 0) {
    if($_REQUEST['s_read'] > 0 || $_REQUEST['s_user'] > 0) $u_pm2 = "And ";
    $u_pm2 .= "recipientid = '".$_REQUEST['s_user2']."'";
  }
  
  $anz = $db->query_first("Select Count(*) as anzahl FROM bb".$n."_privatemessage $where $r_pm $u_pm $u_pm2");
  if($anz['anzahl'] == $_REQUEST['lim']) $_REQUEST['lim'] -= 10;
  if($_REQUEST['lim'] < 0) $_REQUEST['lim'] = 0;
  
  $result = $db->query("SELECT * FROM bb".$n."_privatemessage $where $r_pm $u_pm $u_pm2 ORDER BY sendtime DESC LIMIT ".$_REQUEST['lim'].",10");
  while($num=mysql_fetch_array($result)) { 
    $pmid = $num['privatemessageid']; 
    $senderid = $num['senderid']; 
    $recipientid = $num['recipientid']; 
    $sendtime = date("d.m.Y / H:i", $num['sendtime']);
    if($num['view'] != 0){
      $readtime = "<img src=\"./images/read.gif\" border=\"0\">&nbsp;&nbsp;".date("d.m.Y / H:i", $num['view']);
    }else{
      $readtime = "<img src=\"./images/notread.gif\" border=\"0\">";
    }
    $sender = $db->query("SELECT username,signature FROM bb".$n."_users WHERE userid = '".$senderid."' ORDER BY username"); 
    while($num2=mysql_fetch_array($sender)) { 
      $senderanzeige = $num2['username'];
      $sig=$num2['signature'];
    } 
    $empfaenger = $db->query("SELECT username FROM bb".$n."_users WHERE userid = '".$recipientid."' ORDER BY username"); 
    while($num3=mysql_fetch_array($empfaenger)) { 
      $empfaengerausgabe = $num3['username'];
    }
    $parse = new parse($docensor,75,1,$hilight,1);
    $message = $parse->doparse($num['message'],$num['allowsmilies'],$num['allowhtml'],$num['allowbbcode'],$num['allowimages']);
    $subject = htmlconverter(textwrap($num['subject']));
    
    $message=str_replace("{imagefolder}","images",$message);
    $message=str_replace("{tableinbordercolor}",'#000000',$message);
    $message=str_replace("{inposttablecolor}",'#E2E2E2',$message);
    
    $signature = $parse->doparse($sig,$num['allowsmilies'],$num['allowhtml'],$num['allowbbcode'],$num['allowimages']);
    
    eval ("\$pmsbit .= \"".$tpl->get("all_pms_bit",1)."\";");
  }
  eval ("\$pmsdelbit = \"".$tpl->get("all_pms_del",1)."\";");
  $pages = &new pages($anz['anzahl'],10,13,"&action=show&s_read=$_REQUEST[s_read]&s_user=$_REQUEST[s_user]&s_user2=$_REQUEST[s_user2]&sid=$session[hash]");
  
  $bwd    = $pages->go_bwd($_REQUEST['lim']);
  $fwd    = $pages->go_fwd($_REQUEST['lim']);
  $first  = $pages->get_first($_REQUEST['lim']);
  $last   = $pages->get_last($_REQUEST['lim']);
  $seiten = $pages->get_pages($_REQUEST['lim']);
  
  eval ("\$pms_bit = \"".$tpl->get("all_pmsbit",1)."\";");
}
eval("\$tpl->output(\"".$tpl->get("all_pms",1)."\",1);");
?>