"); // ##################################################################### //PM per E-Mail sichern function msgsichern($uid) { global $prefix, $user_prefix, $module_name, $url_smiles, $subjectdefaulticon, $url_images, $url_button; global $bgcolor1, $bgcolor2, $bgcolor3, $textcolor1, $textcolor2, $popupwidth,$poptableborder; $uid = (int)$uid; $kopf = "". _HELLO . ",\n" . _PMEMAIL . _DOMAIN . "\n". _YOURMAILPMS . "\n" . _HPMS . ":\n\n"; $linie1 ="--------------------------------------------------------------------------------------------------------------------"; $linie2 ="************************************************************************************************"; $nachricht =$kopf; $qry="SELECT subject, from_userid, msg_time, msg_text FROM ${prefix}_priv_msgs WHERE to_userid=".$uid." order by msg_time desc"; $result = sql_query($qry); while (list($subject, $from_userid, $msg_time, $msg_text) = sql_fetch_row($result)) { $qry2="SELECT * FROM ${prefix}_users WHERE uid=".$from_userid.""; $result2 = sql_query($qry2); $row = sql_fetch_array($result2); $absender=$row["uname"]; $nachricht .="$linie2\n"; $nachricht .=" ". _TOPMS ." $msg_time " . _SPMS ." $absender:\n"; $nachricht .="$linie1\n"; $nachricht .=" $msg_text\n"; } $nachricht .="$linie2\n"; $nachricht .="\n\n\n" . _AOPMS . ":\n\n\n"; $qry4="SELECT subject, to_userid, msg_time, msg_text FROM ${prefix}_priv_msgs_send WHERE from_userid=".$uid." order by msg_time desc"; $result4 = sql_query($qry4); while (list($subject, $to_userid, $msg_time, $msg_text) = sql_fetch_row($result4)) { $qry5="SELECT * FROM ${prefix}_users WHERE uid=".$to_userid.""; $result5 = sql_query($qry5); $row5 = sql_fetch_array($result5); $empfang=$row["uname"]; $nachricht .="$linie2\n"; $nachricht .=" ". _TOPMS ." $msg_time " . _ANPMS ." $empfang:\n"; $nachricht .="$linie1\n"; $nachricht .=" $msg_text\n"; } $nachricht .="$linie2\n"; $nachricht .="\n\n" . _MFGPMS . "\n " . _PMSBOX; $qry3="SELECT * FROM ${prefix}_users WHERE uid=".$uid.""; $result3 = sql_query($qry3); $row2 = sql_fetch_array($result3); $email=$row2["email"]; $absend=$row2["uname"]; $headers = "From: $absend <$email>\n"; $headers .= "X-Sender: <$email>\n"; $headers .= "X-Mailer: aePMsicher v0.1\n"; $headers .= "X-Priority: 1\n"; $headers .= "Return-Path: $absend <$email>\n"; mail($email, _PMSSI, $nachricht, $headers); messagesheader($uid); OpenTable(); echo '' . _YOURPMS . ''; echo "

" . mxCreateImage("$url_button/index.gif", _PMSRETURNTOPMSG) . "

"; CloseTable(); } //PM per E-Mail sichern ende // ##################################################################### function msgindex($uid) { global $prefix, $user_prefix, $module_name, $url_smiles, $url_icons, $subjectdefaulticon, $url_images, $url_button; global $bgcolor1, $bgcolor2, $bgcolor3, $textcolor1, $textcolor2, $popupwidth, $poptableborder; $uid = (int)$uid; $qry = "SELECT " . $prefix . "_priv_msgs.*, UNIX_TIMESTAMP(msg_time) as msgtimestamp, " . $user_prefix . "_users.uname as fromname " . "FROM " . $prefix . "_priv_msgs LEFT JOIN " . $user_prefix . "_users ON " . $prefix . "_priv_msgs.from_userid = " . $user_prefix . "_users.uid " . "WHERE (to_userid = $uid) order by msg_time desc;"; $result = sql_query($qry); if (!$result) { prvmsgerror(_ERRMSGDATABASE); } if (!$total_messages = sql_num_rows($result)) { $havemessages = 0; } else { $havemessages = 1; printOverlibDiv(); $pm_overlib = new Overlib(); echo ' '; } $count = 0; echo "

\n"; echo "\n"; messagesheader($uid); echo "\n"; if (!$havemessages) { echo "\n\t\n\n"; } else { echo "\n" . "\t\n" . "\t\n" . "\t\n" . "\t\n" . "\t\n" . "\t\n" . "\n"; while ($row = sql_fetch_array($result)) { if (empty($row["msg_image"])) $row["msg_image"] = $subjectdefaulticon; if (empty($row["fromname"])) $row["fromname"] = ""; $postedtime = mx_strftime(_PMSTIMESTRING, $row["msgtimestamp"]); $row["subject"] = strip_tags($row["subject"]); $row["subject"] = msg_smile($row["subject"]); $row["msg_text"] = strip_tags($row["msg_text"], "

"); // $row["msg_text"] = str_replace(array(')','|'),array(')','|'),$row["msg_text"]); /// macht mxSecureValue() rückgängig $row["msg_text"] = pmPrepDisplay($row["msg_text"]); $pm_overlib->ol_capicon = $url_icons . "/" . $row["msg_image"]; $pm_overlib->ol_delay = 200; $pm_overlib->ol_hauto = "True"; $pm_overlib->ol_vauto = "True"; $myover = $pm_overlib->vover(pmValueToText($row["msg_text"]), pmValueToText($row["subject"])); echo "\t\n"; echo "\t\n"; echo "\t\n"; echo "\t\n"; echo "\t\n"; echo "\t\n"; echo "\n"; $count++; } } echo "\n\t\n\n

" . _PMSDONTHAVESOME . "
	$\""$	" . _PMSFROM . "	" . _PMSSUBJECT . "	" . _PMSDATE . "
"; echo "	"; if ($row["read_msg"] == 1) { echo " "; } else { echo " $\""$ "; } echo "	" . $row["fromname"] . "	" . $row["subject"] . "	$postedtime
"; echo " " . mxCreateImage("$url_button/ausgang.gif", _ASENTPMS) . " "; echo "" . mxCreateImage("$url_button/senden.gif", _PMSPRIVATEMESSAGESEND) . " "; if ($havemessages) { echo " "; echo ""; echo "" . " "; echo "" . mxCreateImage("$url_button/speichern.gif", _SAVEPMS) . " \n"; echo " " . mxCreateImage("$url_button/index.gif", _PMSRETURNTOPMSG) . " "; } echo "

\n"; } // ##################################################################### function messagesheader($uid) { global $url_images, $module_name, $prefix, $user_prefix; include_once("modules/Your_Account/navbar.php"); OpenTable(); nav(); CloseTable(); echo "
"; OpenTable(); $buddyalt = strip_tags(eregi_replace("
", "\n", _PMSDISCRIBE)); $windowname = md5($GLOBALS['sitename']); echo "
" . mxCreateImage("$url_images/pmessage.gif", _PMSRETURNTOPMSG) . " " . _PMSPRIVATEMESSAGES . "

" . mxCreateImage("$url_images/buddy.gif", $buddyalt) . "

\n"; //PM Begrenzung $uid = (int)$uid; $allget = 0; $allsend = 0; $qry = "SELECT read_msg, Count(msg_id) FROM ${prefix}_priv_msgs WHERE to_userid=" . $uid . " GROUP BY read_msg;"; $result = sql_query($qry); while (list($read_msg, $nums) = sql_fetch_row($result)) { $allget = $nums; #++; # Anzahl aller pm's ermitteln } $qry = "SELECT read_msg, Count(msg_id) FROM ${prefix}_priv_msgs_send WHERE from_userid=" . $uid . " GROUP BY read_msg;"; $result = sql_query($qry); while (list($read_msg, $nums) = sql_fetch_row($result)) { $allsend = $nums; #++; # Anzahl aller pm's ermitteln } include("modules/Private_Messages/inboxsize-conf.php"); $erlaubtpm = $sentboxsize; $erlaubtgetpm = $inboxsize; if($allget >= $erlaubtgetpm) { $allget = "$allget"; } if($allsend >= $erlaubtpm) { $allsend = "$allsend"; } echo "" . _PMNE . $allget . " (" . $erlaubtgetpm . ") / " . _PMNA . $allsend . " (" . $erlaubtpm . ") \n"; //Ende PM Begrenzung CloseTable(); // echo "
"; } // ##################################################################### function messagesheader1($uid) { global $url_images, $module_name, $prefix, $user_prefix; include_once("modules/Your_Account/navbar.php"); OpenTable(); nav(); CloseTable(); echo "
"; OpenTable(); $buddyalt = strip_tags(eregi_replace("
", "\n", _PMSDISCRIBE)); $windowname = md5($GLOBALS['sitename']); echo "
" . mxCreateImage("$url_images/pmessage.gif", _PMSRETURNTOPMSG) . " " . _PMSPRIVATEMESSAGES . "

" . mxCreateImage("$url_images/buddy.gif", $buddyalt) . "

\n"; //PM Begrenzung $uid = (int)$uid; $allget = 0; $allsend = 0; $qry = "SELECT read_msg, Count(msg_id) FROM ${prefix}_priv_msgs WHERE to_userid=" . $uid . " GROUP BY read_msg;"; $result = sql_query($qry); while (list($read_msg, $nums) = sql_fetch_row($result)) { $allget = $nums; #++; # Anzahl aller pm's ermitteln } $qry = "SELECT read_msg, Count(msg_id) FROM ${prefix}_priv_msgs_send WHERE from_userid=" . $uid . " GROUP BY read_msg;"; $result = sql_query($qry); while (list($read_msg, $nums) = sql_fetch_row($result)) { $allsend = $nums; #++; # Anzahl aller pm's ermitteln } include("modules/Private_Messages/inboxsize-conf.php"); $erlaubtpm = $sentboxsize; $erlaubtgetpm = $inboxsize; if($allget >= $erlaubtgetpm) { $allget = "$allget"; } if($allsend >= $erlaubtpm) { $allsend = "$allsend"; } echo "" . _PMNA . $allsend . " (" . $erlaubtpm . ") / " . _PMNE . $allget . " (" . $erlaubtgetpm . ") \n"; //Ende PM Begrenzung CloseTable(); // echo "
"; } // ##################################################################### function prvmsgerror($error_msg) { global $header, $footer, $PHP_SELF, $bgcolor2, $url_button; if (!isset($header)) { include("header.php"); } messagesheader($uid); echo "" . "

"; echo "" . _PMSGERROR . "

"; OpenTable2(); echo "
$error_msg

"; CloseTable2(); echo "
" . mxCreateImage($url_button . '/zurueck.gif', _PMSGOBACK) . "
" . _GOBACK . "
"; include("footer.php"); die(""); } // ##################################################################### function readmessage($id, $uid) { global $prefix, $user_prefix, $module_name, $url_smiles, $url_icons, $url_avatar, $url_images, $blankavatar; global $allow_bbcode, $allow_html ; global $bgcolor1, $bgcolor2, $bgcolor3, $textcolor1, $textcolor2, $url_button; list($id, $uid) = mxForceInteger($id, $uid); // by AE $qry = "SELECT " . $prefix . "_priv_msgs.*, UNIX_TIMESTAMP(msg_time) as msgtimestamp FROM " . $prefix . "_priv_msgs WHERE (to_userid=$uid) and (msg_id=$id);"; $result = sql_query($qry); if (!$result) { prvmsgerror(_ERRMSGDATABASE); } $row = sql_fetch_array($result); if (!$row["msg_id"]) { msgindex($uid); } else { $posterdata = get_userdata_from_id($row["from_userid"]); $postedtime = mx_strftime(_PMSTIMESTRING, $row["msgtimestamp"]); $replymsg = pmUndoPrepDisplay($row['msg_text']); $replymsg = "[quote][i]" . _ON . " " . $postedtime . ", " . _PMSWROTE . " " . $posterdata['uname'] . ":[/i]\n" . $replymsg . "\n[/quote]\n"; $row["msg_text"] = pmPrepDisplay($row["msg_text"]); $qry = "SELECT msg_id FROM " . $prefix . "_priv_msgs WHERE to_userid=$uid and msg_time>'" . $row["msg_time"] . "' and msg_id<>'" . $row["msg_id"] . "' and (from_userid is not null) order by msg_time asc LIMIT 0,1"; list($next) = sql_fetch_row(sql_query($qry)); $qry = "SELECT msg_id FROM " . $prefix . "_priv_msgs WHERE to_userid=$uid and msg_time<'" . $row["msg_time"] . "' and msg_id<>'" . $row["msg_id"] . "' and (from_userid is not null) order by msg_time desc LIMIT 0,1"; list($previous) = sql_fetch_row(sql_query($qry)); $qry = "UPDATE " . $prefix . "_priv_msgs SET read_msg=1 WHERE msg_id=" . $row["msg_id"]; $result = sql_query($qry); if (!$result) { prvmsgerror(_ERRMSGDATABASE); } if (empty($posterdata["user_sig"])) { $rowspan = "2"; } else { $rowspan = "3"; $posterdata["user_sig"] = pmPrepDisplay(pmxSigBbCode($posterdata["user_sig"])); } messagesheader($uid); echo""; echo "" . "" . "" . "" . "\n" . "" . "" . ""; if (!empty($posterdata["user_sig"])) { echo "\n"; } echo "
" . "" . mxCreateImage("$url_button/index.gif", _PMSRETURNTOPMSG) . " "; if ($previous) { echo "" . mxCreateImage("$url_button/vorherige.gif", _PMSPREVIOUS) . " "; } else { echo "" . mxCreateImage("$url_button/vorherige.gif", _PMSPREVIOUS) . " "; } if ($next) { echo "" . mxCreateImage("$url_button/naechste.gif", _PMSNEXT) . ""; } else { echo "" . mxCreateImage("$url_button/naechste.gif", _PMSNEXT) . ""; } echo "
" . _PMSPRIVATEMESSAGE . ":   " . msg_smile($row["subject"]) . "
" . _PMSFROM . ": " . $posterdata["uname"] . "

\n"; $isAvatar = mxIsAvatarUploaded($posterdata["uname"], true); if ($isAvatar) { // Bild ausgeben: echo $isAvatar; } else if (!empty($posterdata["user_avatar"]) && $posterdata["user_avatar"] != "blank.gif") { echo " $\""$
\n"; } else { echo " $\""$
\n"; } echo "
$\""$ " . _PMSPROFILE . "
\n" . get_onlinestatus($posterdata["uname"]) . " $\"\"$ " . _PMSSENT . ": $postedtime
" . $row["msg_text"] . "

" . $posterdata["user_sig"] . "
" . "" . "\n" . "
" . mxCreateImage("$url_button/antworten.gif", _PMSREPLY) . "\n" . " " . mxCreateImage("$url_button/loeschen.gif", _PMSDELETE) . "\n " . "" . mxCreateImage("$url_button/index.gif", _PMSRETURNTOPMSG) . " "; if ($previous) { echo "" . mxCreateImage("$url_button/vorherige.gif", _PMSPREVIOUS) . " "; } else { echo "" . mxCreateImage("$url_button/vorherige.gif", _PMSPREVIOUS) . " "; } if ($next) { echo "" . mxCreateImage("$url_button/naechste.gif", _PMSNEXT) . ""; } else { echo "" . mxCreateImage("$url_button/naechste.gif", _PMSNEXT) . ""; } echo "
" . "
"; // ########################## echo ' '; echo "
"; echo "\n"; echo "\n"; echo "
" . "" . "" . ""; if (MX_IS_ADMIN) { echo "" . "" . "" . ""; } echo "" . "" . "" . "" . "" . "" . "" . "" . "" . "" . "" . "" . "
" . $posterdata["uname"] . " " . _PMSREPLY . ":
" . _PMSTOALL1 . ": " . _PMSTOALL2 . "
" . _PMSSUBJECT . ":
" . _PMSMESSAGEICON . ": " . mxPmGetPictos($row["msg_image"]) . "
" . _PMSMESSAGE . ":

" . ""; if ($allow_html == 1) { echo _PMSHTML . ": " . _PMSPMON . "
\n"; } else { echo _PMSHTML . ": " . _PMSOFF . "
\n"; } if ($allow_bbcode == 1) { echo _PMSBBCODELINK . _PMSBBCODE . ": " . _PMSPMON . "
\n"; } else { echo _PMSBBCODE . ": " . _PMSOFF . "
\n"; } echo " " . "" . "" . "
" . mxEntityQuotes($replymsg) . " "; if ($allow_bbcode == 1) { printsmilies(); } echo "
"; if ($allow_bbcode == 1) { putitems(); } echo "
\n" . "" . "\n" . " \n" . "\n" . "
" . "
"; } } //###################################################################### function deletesentmessage($msg_id, $uid) { global $prefix, $user_prefix, $PHP_SELF, $module_name, $refresh, $bgcolor2, $url_button; list($msg_id, $uid) = mxForceInteger($msg_id, $uid); $qry = "SELECT msg_time FROM ".$prefix."_priv_msgs_send WHERE (to_userid=$uid) and (msg_id=$msg_id) and (to_userid is not null) LIMIT 0,1"; list($time) = sql_fetch_row(sql_query($qry)); $qry = "SELECT msg_id FROM ".$prefix."_priv_msgs_send WHERE (to_userid=$uid) and (msg_time>'$time') and (msg_id<>$msg_id) and (to_userid is not null) order by msg_time asc LIMIT 0,1"; list($nextid) = sql_fetch_row(sql_query($qry)); $qry = "DELETE FROM ".$prefix."_priv_msgs_send WHERE (msg_id=$msg_id) AND (to_userid=$uid) or (to_userid is null)"; if(!sql_query($qry)) { prvmsgerror(_ERRMSGNODELETE); } else { messagesheader1($uid); echo "" ."

"._PMSMSGDELETED."

"; if ($nextid){ $xrefresh = $refresh*2; echo " $\""._PMSRETURNTOPMSG."\"$ $\""._PMSNEXT."\"$ "; echo ""; } else { echo ""._PMSRETURNTOPMSG.""; echo ""; } echo "

"; } } // ###################################################################### function deletesentmessages($arrformvars, $uid) { global $prefix, $refresh, $module_name, $bgcolor2; $status =0; if (isset($arrformvars["msg_id"])){ list($uid, $arrformvars["msg_id"]) = mxForceInteger($uid, $arrformvars["msg_id"]); while(list($key, $val) = each($arrformvars["msg_id"])) { $qry="DELETE FROM ".$prefix."_priv_msgs_send WHERE (msg_id=$val) AND (to_userid=$uid) or (to_userid is null)"; if(!sql_query($qry)) { prvmsgerror(_ERRMSGNODELETE); } else { $status =1; } } } messagesheader1($uid); echo "" ."

"; if ($status){ echo _PMSMSGDELETED2; } else { echo _PMSMSGNOTODELETE; } echo "

"._PMSRETURNTOPMSG."

"; echo ""; } // ##################################################################### function sendmessage($msg_id, $uid, $to_user = "") { global $allow_bbcode, $allow_html; global $prefix, $user_prefix, $module_name, $url_smiles, $url_button, $subjectdefaulticon; global $bgcolor1, $bgcolor2, $bgcolor3, $textcolor1, $textcolor2; list($msg_id, $uid) = mxForceInteger($msg_id, $uid); $count = 0; $userlistlink = "[ " . _PMSUSERSLIST . " ]"; if ($msg_id) { $qry = "SELECT msgs.msg_image, msgs.subject, msgs.to_userid, UNIX_TIMESTAMP(msg_time), msgs.msg_text, fromuser.uname " . "FROM " . $prefix . "_priv_msgs AS msgs LEFT JOIN " . $user_prefix . "_users AS fromuser ON msgs.from_userid = fromuser.uid " . "WHERE ((to_userid=$uid) AND (msg_id=$msg_id) and (from_userid is not null));"; $result = sql_query($qry); if (!$result) { prvmsgerror(_ERRMSGDATABASE); } list($msg_image, $subject, $to_userid, $msg_time, $msg_text, $to_user) = sql_fetch_row($result); $msg_time = mx_strftime(_PMSTIMESTRING, $msg_time); if (!$msg_image) { $msg_image = $subjectdefaulticon; } $subject = _PMSRE . ": " . msg_desmile($subject); $subject = str_replace("" . _PMSRE . ": " . _PMSRE . ": ", _PMSRE . ": ", $subject); $msg_text = pmUndoPrepDisplay($msg_text); $msg_text = "[quote][i]" . _ON . " " . $msg_time . ", " . _PMSWROTE . " " . $to_user . ":[/i]\n" . $msg_text . "\n[/quote]\n"; } else { if (is_numeric($uid) && empty($to_user)) { $qry = "SELECT uid, uname from " . $user_prefix . "_users where uid=$uid and user_stat=1 and uname<>'" . mxAddSlashesForSQL($GLOBALS['anonymous']) . "';"; $result = sql_query($qry); list($uid, $to_user) = sql_fetch_row($result); } else { $to_user = (empty($to_user)) ? $uid : $to_user; } $msg_image = $subjectdefaulticon; $subject = ""; $msg_text = ""; } echo ' '; echo "
"; echo "\n"; echo "\n"; messagesheader($uid); echo "" . "" . "" . "" . "" . "" . "" . ""; if (MX_IS_ADMIN) { echo "" . "" . "" . ""; } echo "" . "" . "" . "" . "" . "" . "" . "" . "" . "" . "" ."" ."" . "" . "
" . _PMSPRIVATEMESSAGESEND . "
" . "
" . mxCreateImage("$url_button/index.gif", _PMSRETURNTOPMSG) . "
" . _PMSTO . ":    " . $userlistlink . "
" . _PMSTOALL1 . ": " . _PMSTOALL2 . "
" . _PMSSUBJECT . ":
" . _PMSMESSAGEICON . ": " . mxPmGetPictos($msg_image) . "
" . _PMSMESSAGE . ":

" . ""; if ($allow_html == 1) { echo _PMSHTML . ": " . _PMSPMON . "
\n"; } else { echo _PMSHTML . ": " . _PMSOFF . "
\n"; } if ($allow_bbcode == 1) { echo _PMSBBCODELINK . _PMSBBCODE . ": " . _PMSPMON . "
\n"; } else { echo _PMSBBCODE . ": " . _PMSOFF . "
\n"; } echo " " . "" . "" . "
" . mxEntityQuotes($msg_text) . " "; if ($allow_bbcode == 1) { printsmilies(); } echo "
"; if ($allow_bbcode == 1) { putitems(); } echo "
" . _PMSSAVE . ":

" ." " . _NOTSAVEPMS . "
\n" . "\n" . " \n" . "\n" . " \n" . "
" . "
" . "
"; } // ##################################################################### function cancelsubmit($msg_id, $uid) { list($msg_id, $uid) = mxForceInteger($msg_id, $uid); if ($msg_id) { readmessage($msg_id, $uid); } else { msgindex($uid); } } //###################################################################### function sendmsg($uid) { global $prefix, $user_prefix, $module_name, $url_smiles, $url_icons, $subjectdefaulticon, $url_images, $url_button; global $bgcolor1, $bgcolor2, $bgcolor3, $textcolor1, $textcolor2, $popupwidth, $poptableborder; $uid = (int)$uid; $qry = "SELECT " . $prefix . "_priv_msgs_send.*, UNIX_TIMESTAMP(msg_time) as msgtimestamp, " . $user_prefix . "_users.uname as toname " . "FROM " . $prefix . "_priv_msgs_send LEFT JOIN " . $user_prefix . "_users ON " . $prefix . "_priv_msgs_send.from_userid = " . $user_prefix . "_users.uid " . "WHERE (to_userid = $uid) order by msg_time desc;"; $result = sql_query($qry); if (!$result) { prvmsgerror(_ERRMSGDATABASE); } if (!$total_messages = sql_num_rows($result)) { $havemessages = 0; } else { $havemessages = 1; printOverlibDiv(); $pm_overlib = new Overlib(); echo ' '; } $count = 0; echo "
\n"; echo "\n"; messagesheader1($uid); echo "\n"; if (!$havemessages) { echo "\n\t\n\n"; } else { echo "\n" . "\t\n" . "\t\n" . "\t\n" . "\t\n" . "\t\n" . "\t\n" . "\n"; while ($row = sql_fetch_array($result)) { if (empty($row["msg_image"])) $row["msg_image"] = $subjectdefaulticon; if (empty($row["toname"])) $row["toname"] = ""; $postedtime = mx_strftime(_PMSTIMESTRING, $row["msgtimestamp"]); $row["subject"] = strip_tags($row["subject"]); $row["subject"] = msg_smile($row["subject"]); $row["msg_text"] = strip_tags($row["msg_text"], "
"); // $row["msg_text"] = str_replace(array(')','|'),array(')','|'),$row["msg_text"]); /// macht mxSecureValue() rückgängig $row["msg_text"] = pmPrepDisplay($row["msg_text"]); $pm_overlib->ol_capicon = $url_icons . "/" . $row["msg_image"]; $pm_overlib->ol_delay = 200; $pm_overlib->ol_hauto = "True"; $pm_overlib->ol_vauto = "True"; $myover = $pm_overlib->vover(pmValueToText($row["msg_text"]), pmValueToText($row["subject"])); echo "\t\n"; echo "\t\n"; echo "\t\n"; echo "\t\n"; echo "\t\n"; echo "\t\n"; echo "\n"; $count++; } } echo "\n\t\n\n

" . _SENTPMSDONTHAVESOME . "

$\""$ " . _SENTPMSTO . " " . _PMSSUBJECT . " " . _PMSDATE . "
"; echo " "; if ($row["read_msg"] == 1) { echo " "; } else { echo " $\""$ "; } echo " " . $row["toname"] . " " . $row["subject"] . " $postedtime
"; echo "
" . mxCreateImage("$url_button/eingang.gif", _ESENTPMS) . " "; echo "" . mxCreateImage("$url_button/senden.gif", _PMSPRIVATEMESSAGESEND) . " "; if ($havemessages) { echo " "; echo ""; echo "" . " "; echo "" . mxCreateImage("$url_button/speichern.gif", _SAVEPMS) . "
\n"; echo "
" . mxCreateImage("$url_button/index.gif", _PMSRETURNTOPMSG) . "
"; } echo "
\n"; } // ##################################################################### function readsentmessage($id, $uid) { global $prefix, $user_prefix, $module_name, $url_smiles, $url_icons, $url_avatar, $url_images, $blankavatar; global $allow_bbcode, $allow_html ; global $bgcolor1, $bgcolor2, $bgcolor3, $textcolor1, $textcolor2, $url_button; list($id, $uid) = mxForceInteger($id, $uid); // by AE $qry = "SELECT " . $prefix . "_priv_msgs_send.*, UNIX_TIMESTAMP(msg_time) as msgtimestamp FROM " . $prefix . "_priv_msgs_send WHERE (from_userid=$uid) and (msg_id=$id);"; $result = sql_query($qry); if (!$result) { prvmsgerror(_ERRMSGDATABASE); } $row = sql_fetch_array($result); if (!$row["msg_id"]) { msgindex($uid); } else { $posterdata = get_userdata_from_id($row["from_userid"]); $postedtime = mx_strftime(_PMSTIMESTRING, $row["msgtimestamp"]); $replymsg = pmUndoPrepDisplay($row['msg_text']); $replymsg = "[quote][i]" . _ON . " " . $postedtime . ", " . _PMSWROTE . " " . $posterdata['uname'] . ":[/i]\n" . $replymsg . "\n[/quote]\n"; $row["msg_text"] = pmPrepDisplay($row["msg_text"]); $qry = "SELECT msg_id FROM " . $prefix . "_priv_msgs_send WHERE from_userid=$uid and msg_time>'" . $row["msg_time"] . "' and msg_id<>'" . $row["msg_id"] . "' and (from_userid is not null) order by msg_time asc LIMIT 0,1"; list($next) = sql_fetch_row(sql_query($qry)); $qry = "SELECT msg_id FROM " . $prefix . "_priv_msgs_send WHERE from_userid=$uid and msg_time<'" . $row["msg_time"] . "' and msg_id<>'" . $row["msg_id"] . "' and (from_userid is not null) order by msg_time desc LIMIT 0,1"; list($previous) = sql_fetch_row(sql_query($qry)); $qry = "UPDATE " . $prefix . "_priv_msgs_send SET read_msg=1 WHERE msg_id=" . $row["msg_id"]; $result = sql_query($qry); if (!$result) { prvmsgerror(_ERRMSGDATABASE); } if (empty($posterdata["user_sig"])) { $rowspan = "2"; } else { $rowspan = "3"; $posterdata["user_sig"] = pmPrepDisplay(pmxSigBbCode($posterdata["user_sig"])); } messagesheader1($uid); echo""; echo "" . "" . "" . "" . "\n" . "" . "" . ""; if (!empty($posterdata["user_sig"])) { echo "\n"; } echo "
" . "" . mxCreateImage("$url_button/index.gif", _PMSRETURNTOPMSG) . " "; if ($previous) { echo "" . mxCreateImage("$url_button/vorherige.gif", _PMSPREVIOUS) . " "; } else { echo "" . mxCreateImage("$url_button/vorherige.gif", _PMSPREVIOUS) . " "; } if ($next) { echo "" . mxCreateImage("$url_button/naechste.gif", _PMSNEXT) . ""; } else { echo "" . mxCreateImage("$url_button/naechste.gif", _PMSNEXT) . ""; } echo "
" . _PMSPRIVATEMESSAGE . ":   " . msg_smile($row["subject"]) . "
" . _SENTPMSTO . ": " . $posterdata["uname"] . "

\n"; $isAvatar = mxIsAvatarUploaded($posterdata["uname"], true); if ($isAvatar) { // Bild ausgeben: echo $isAvatar; } else if (!empty($posterdata["user_avatar"]) && $posterdata["user_avatar"] != "blank.gif") { echo " $\""$
\n"; } else { echo " $\""$
\n"; } echo "
$\""$ " . _PMSPROFILE . "
\n" . get_onlinestatus($posterdata["uname"]) . " $\"\"$ " . _PMSSENT . ": $postedtime
" . $row["msg_text"] . "

" . $posterdata["user_sig"] . "
" . "" . "
" . mxCreateImage("$url_button/loeschen.gif", _PMSDELETE) . "\n" . " " . "" . mxCreateImage("$url_button/index.gif", _PMSRETURNTOPMSG) . " "; if ($previous) { echo "" . mxCreateImage("$url_button/vorherige.gif", _PMSPREVIOUS) . " "; } else { echo "" . mxCreateImage("$url_button/vorherige.gif", _PMSPREVIOUS) . " "; } if ($next) { echo "" . mxCreateImage("$url_button/naechste.gif", _PMSNEXT) . ""; } else { echo "" . mxCreateImage("$url_button/naechste.gif", _PMSNEXT) . ""; } echo "
" . "
"; } } // ##################################################################### function submitmessage($arrpostdata, $uid) { include("modules/Private_Messages/inboxsize-conf.php"); global $prefix, $user_prefix, $PHP_SELF, $module_name, $refresh, $bgcolor2; $uid = (int)$uid; if (empty($arrpostdata["to_user"]) && empty($arrpostdata["to_all"]) || (!empty($arrpostdata["to_all"]) && !MX_IS_ADMIN)) { prvmsgerror(_ERRMSGNOUSER); } if (empty($arrpostdata["to_all"])) { $result = sql_query("select uid from " . $user_prefix . "_users where uname=\"" . mxAddSlashesForSQL($arrpostdata["to_user"]) . "\""); list($to_userid) = sql_fetch_row($result); if (!$to_userid) { prvmsgerror(_PMSUSERNOTINDB); } } // PM Begrenzung $result_anzahl = sql_query("SELECT Count(*) FROM " . $prefix . "_priv_msgs WHERE to_userid=$to_userid"); $qry_sent = "SELECT Count(*) FROM " . $prefix . "_priv_msgs_send WHERE from_userid=$uid"; $result_sent = sql_query($qry_sent); $count_anzahl = sql_fetch_row($result_anzahl); $countpmsent = sql_fetch_row($result_sent); if ($countpmsent[0] >= $sentboxsize) { prvmsgerror(_SENTPMBOXVOLL); } if ($count_anzahl[0] >= $inboxsize) { prvmsgerror(_PMBOXVOLL); } //Ende PM Begrenzung if (!($arrpostdata["subject"])) { prvmsgerror(_ERRMSGNOSUBJECT); } if (strip_tags($arrpostdata["subject"]) != $arrpostdata["subject"]) { prvmsgerror(_ERRMSGNOHTMLINSUBJECT); } if (!($arrpostdata["image"])) { prvmsgerror(_ERRMSGNOICON); } if (!($arrpostdata["message"])) { prvmsgerror(_ERRMSGNOMESSAGE); } $arrpostdata["message"] = mxAddSlashesForSQL($arrpostdata["message"]); $arrpostdata["subject"] = mxAddSlashesForSQL(strip_tags($arrpostdata["subject"])); $qry1 = "INSERT INTO " . $user_prefix . "_priv_msgs (msg_image, subject, from_userid, to_userid, msg_time, msg_text) "; $qry_msg_sent = "INSERT INTO " . $user_prefix . "_priv_msgs_send (msg_image, subject, to_userid, from_userid, msg_time, msg_text) "; //Gesendete PM´s speichern if (empty($arrpostdata["to_all"])) { //ignore Funktion $ignore = sql_query("select uname from " . $user_prefix . "_users_ignorelist where uid='" . $to_userid . "' AND ignoreid='" . $uid . "'"); $nene = sql_num_rows($ignore); if ($nene == 1) { list($ignorename) = sql_fetch_row($ignore); prvmsgerror($ignorename . " " . _NOMESSAGE . "
" . _PMSRETURNTOPMSG); } ###### $qry1 .= "VALUES ('" . $arrpostdata["image"] . "', '" . $arrpostdata["subject"] . "', " . $uid . ", " . $to_userid . ", now(), '" . $arrpostdata["message"] . "')"; $qry_msg_sent .= "VALUES ('" . $arrpostdata["image"] . "', '" . $arrpostdata["subject"] . "', " . $uid . ", " . $to_userid . ", now(), '" . $arrpostdata["message"] . "')"; //Gesendete PM´S speichern if (!$result = sql_query($qry1)) { prvmsgerror(_ERRMSGNOSUBMIT); } if ($arrpostdata ["notsave"]) { if (!$result = sql_query($qry_msg_sent)) { prvmsgerror(_ERRMSGNOSUBMIT); } } } else { if (MX_IS_ADMIN) { $i = 0; $result = sql_query("select uid from " . $user_prefix . "_users where user_stat=1"); while (list($to_userid) = sql_fetch_row($result)) { $qry2 = $qry1 . " VALUES ('" . $arrpostdata["image"] . "', '" . $arrpostdata["subject"] . "', " . $uid . ", " . $to_userid . ", now(), '" . $arrpostdata["message"] . "')"; $result2 = sql_query($qry2); if ($result2) $i++; } } } ###Email bei neuer PN wenn User offline ist ##### #$Nachricht = $arrpostdata["message"]; $dieUserdaten = mxGetUserDataFromUid($uid); $Absender = $dieUserdaten['uname']; list($touser_uname,$touser_email,$user_pm_mail) = sql_fetch_row(sql_query("SELECT uname, email, user_pm_mail FROM " . $user_prefix . "_users WHERE uid='$to_userid'", $dbi), $dbi); $message = _HELLO . " $touser_uname,\n" . _PMEMAIL . _DOMAIN . _PMEMAIL1 . "$Absender " . _PMEMAIL2 . "http://" . _DOMAIN . "/modules.php?name=Private_Messages" . _PMEMAIL3 ."http://" . _DOMAIN . "/modules.php?name=Your_Account&op=edithome"; $subject = _PMEMAILSUB . _DOMAIN; if (!mxIsUserOnline($touser_uname) && ($user_pm_mail ==1)) { mxMail($touser_email, "$subject", $message, $GLOBALS['adminmail'],"text","PM-Mail"); } ####### messagesheader($uid); echo "" . "" . "" . "

" . _PMSMSGPOSTED . " " . ((isset($i)) ? " (" . $i . " User)" : "") . "
" . _PMSRETURNTOPMSG . "
"; echo ""; } // ##################################################################### function deletemessage($msg_id, $uid) { global $prefix, $user_prefix, $PHP_SELF, $module_name, $refresh, $bgcolor2, $url_button; list($msg_id, $uid) = mxForceInteger($msg_id, $uid); $qry = "SELECT msg_time FROM " . $prefix . "_priv_msgs WHERE (to_userid=$uid) and (msg_id=$msg_id) and (from_userid is not null) LIMIT 0,1"; list($time) = sql_fetch_row(sql_query($qry)); $qry = "SELECT msg_id FROM " . $prefix . "_priv_msgs WHERE (to_userid=$uid) and (msg_time>'$time') and (msg_id<>$msg_id) and (from_userid is not null) order by msg_time asc LIMIT 0,1"; list($nextid) = sql_fetch_row(sql_query($qry)); $qry = "DELETE FROM " . $prefix . "_priv_msgs WHERE (msg_id=$msg_id) AND (to_userid=$uid) or (from_userid is null)"; if (!sql_query($qry)) { prvmsgerror(_ERRMSGNODELETE); } else { messagesheader($uid); echo "" . "

" . _PMSMSGDELETED . "

"; if ($nextid) { $xrefresh = $refresh * 2; echo "" . mxCreateImage("$url_button/index.gif", _PMSRETURNTOPMSG) . " " . mxCreateImage("$url_button/naechste.gif", _PMSNEXT) . ""; echo ""; } else { echo "" . _PMSRETURNTOPMSG . ""; echo ""; } echo "

"; } } // ##################################################################### function deletemessages($arrformvars, $uid) { global $prefix, $refresh, $module_name, $bgcolor2; $status = 0; $delmess = array(); $uid = (int)$uid; if (isset($arrformvars["msg_id"])) { foreach ($arrformvars["msg_id"] as $key => $val) { $delmess[] = (int)$val; $status++; } if (count($delmess)) { $delmess = implode(',', $delmess); $del_unread = (empty($GLOBALS['allow_delete_unread'])) ? 'AND (read_msg <> 0)' : ''; $qry = "DELETE FROM " . $prefix . "_priv_msgs WHERE (msg_id IN (" . $delmess . ")) AND (to_userid=" . $uid . ") " . $del_unread . " OR (from_userid = 0) OR (msg_text IS NULL) OR (subject IS NULL) OR (msg_text='') OR (subject='')"; sql_query($qry); $qry = "SELECT COUNT(msg_id) FROM " . $prefix . "_priv_msgs WHERE (to_userid = " . $uid . ") AND msg_id IN (" . $delmess . ")"; $result = sql_query($qry); list($delmess) = sql_fetch_row($result); $status = $status - ((int)$delmess); } } messagesheader($uid); echo "" . "

"; if ($status) { echo _PMSMSGDELETED2 . " (" . $status . "x)"; } else { echo _PMSMSGNOTODELETE; } echo "

" . _PMSRETURNTOPMSG . "

"; echo ""; } /** * mainprog */ if (!MX_IS_USER) { header("Location: modules.php?name=Your_Account&op=login"); exit; } else { $module_name = basename(dirname(__FILE__)); // Link verwendet in Sprachdateien if (!defined("_PMSBBCODELINK")) define("_PMSBBCODELINK", ""); $userdata = mxGetUserData(); $_REQUEST["op"] = (empty($_REQUEST["op"])) ? "index" : $_REQUEST["op"]; $_REQUEST["uname"] = (empty($_REQUEST["uname"])) ? $userdata["uid"] : $_REQUEST["uname"]; $_REQUEST["to_user"] = (empty($_REQUEST["to_user"])) ? $userdata["uname"] : $_REQUEST["to_user"]; include_once("modules/" . $module_name . "/config.php"); if (@file_exists('modules/' . $module_name . '/bbfunctions.php')) include_once("modules/" . $module_name . "/bbfunctions.php"); include_once("modules/" . $module_name . "/functions.php"); mxGetLangfile($module_name); if ($op == "userslist") { userslist(); exit; } $pagetitle = _PMSPRIVATEMESSAGES; include('header.php'); echo "\n\n\n"; if (isset($_REQUEST['mode']) && isset($_REQUEST['u'])) { $_REQUEST['op'] = $_REQUEST['mode']; $xinfo = mxGetUserDataFromUid($_REQUEST['u']); $_REQUEST["to_user"] = $xinfo['uname']; } switch ($_REQUEST['op']) { case "read": readmessage($_REQUEST["id"], $userdata["uid"]); break; case "read_sent": readsentmessage($_REQUEST["id"], $userdata["uid"]); break; case "reply": sendmessage($_REQUEST["id"], $userdata["uid"]); break; case "send": sendmessage(0, $_REQUEST["uname"]); break; case "post": case "send_to": sendmessage(0, $_REQUEST["uname"], $_REQUEST["to_user"]); break; case "submit": if (isset($_REQUEST["submit"])) { submitmessage($_REQUEST, $userdata["uid"]); } else { cancelsubmit($_REQUEST["msg_id"], $userdata["uid"]); } break; case "delete": deletemessage($_REQUEST["msg_id"], $userdata["uid"]); break; case "delete_sent": deletesentmessage($_REQUEST["msg_id"], $userdata["uid"]); break; case "delete_sent_messages": deletesentmessages($_REQUEST, $userdata["uid"]); break; case "sendmsg": sendmsg($userdata["uid"]); break; case "delete_messages": deletemessages($_REQUEST, $userdata["uid"]); break; Default: msgindex($userdata["uid"]); break; case "speichern": msgsichern($userdata["uid"]); break; } echo "\n\n\n"; include('footer.php'); }

" . _SENTPMSDONTHAVESOME . "
	$\""$	" . _SENTPMSTO . "	" . _PMSSUBJECT . "	" . _PMSDATE . "
"; echo "	"; if ($row["read_msg"] == 1) { echo " "; } else { echo " $\""$ "; } echo "	" . $row["toname"] . "	" . $row["subject"] . "	$postedtime
"; echo " " . mxCreateImage("$url_button/eingang.gif", _ESENTPMS) . " "; echo "" . mxCreateImage("$url_button/senden.gif", _PMSPRIVATEMESSAGESEND) . " "; if ($havemessages) { echo " "; echo ""; echo "" . " "; echo "" . mxCreateImage("$url_button/speichern.gif", _SAVEPMS) . " \n"; echo " " . mxCreateImage("$url_button/index.gif", _PMSRETURNTOPMSG) . " "; } echo "