"); $page = (isset($_GET['page'])) ? (int)$_GET['page'] : 1; define('MX_ML_IMAGEPATH', 'modules/' . $module_name . '/images/'); //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 . MX_BASE_URL . "\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 ${user_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 ${user_prefix}_users WHERE uid=".$to_userid.""; $result5 = sql_query($qry5); $row5 = sql_fetch_array($result5); $empfang=$row5["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 ${user_prefix}_users WHERE uid=".$uid.""; $result3 = sql_query($qry3); $row2 = sql_fetch_array($result3); $email=$row2["email"]; $absend=$row2["uname"]; mxmail($email, _PMSSI, $nachricht, $email, "", "", $absend); 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, $page, $pagesize; global $bgcolor1, $bgcolor2, $bgcolor3, $textcolor1, $textcolor2, $popupwidth, $poptableborder; $uid = (int)$uid; $count = "SELECT COUNT(to_userid) AS total FROM ${prefix}_priv_msgs "; $select = "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 "; $min = $pagesize * ($page - 1); // This is where we start our record set from $max = $pagesize; // This is how many rows to select $where = "where to_userid = $uid "; $sort = "order by msg_time"; //sorty by ..... $limit = " DESC LIMIT " . $min . ", " . $max; // we only want rows $min to $max $count_result = sql_query($count . $where); list($num_rows_per_order) = sql_fetch_row($count_result); $result = sql_query($select . $where . $sort . $limit); # or die(); // Now lets do it !! if (!$result) { prvmsgerror(_ERRMSGDATABASE, $uid); } 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"; 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++; } } //page echo "\n\t\n\t\n\n



" . _PMSDONTHAVESOME . "


  " . _EMPFPMS . "

\n" . "
\"" " . _PMSFROM . "" . _PMSSUBJECT . "" . _PMSDATE . "
"; echo ""; if ($row["read_msg"] == 1) { echo " "; } else { echo "\"""; } echo " " . $row["fromname"] . "  " . $row["subject"] . "$postedtime
"; if ($num_rows_per_order > $pagesize) { $total_pages = ceil($num_rows_per_order / $pagesize); // How many pages are we dealing with here ?? $prev_page = $page - 1; if ($prev_page > 0) { echo ""; } else { echo "\n"; } echo ""; $next_page = $page + 1; if ($next_page <= $total_pages) { echo ""; } else { echo "\n"; } /* Added a numbered page list, only shows up to 50 pages. */ echo "\n"; } echo "
"; echo mxCreateImage(MX_ML_IMAGEPATH . 'left.gif', _PREVIOUS . " (" . $prev_page . ")"); echo " "; echo "$num_rows_per_order " . " ($total_pages " . _PAGES . ")"; echo ""; echo mxCreateImage(MX_ML_IMAGEPATH . 'right.gif', _NEXTPAGE . " (" . $next_page . ")"); echo " 
"; echo " [ "; for($n = 1; $n < $total_pages; $n++) { if ($n == $page) { echo "$n"; } else { echo ""; echo "$n"; } if ($n >= 50) { // if more than 50 pages are required, break it at 50. $break = true; break; } else { // guess not. echo " | "; } } if (!isset($break)) { // are we sopposed to break ? if ($n == $page) { echo "$n"; } else { echo ""; echo "$n"; } } echo " ] "; echo "
"; //page ende echo "
"; echo "\n"; echo " "; } echo "
\n"; } function messagesheader($uid) { global $url_images, $module_name, $prefix, $user_prefix, $bgcolor3, $bgcolor2, $pmgrenze_godadmin, $pmgrenze_admin; 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 to_userid, Count(msg_id) FROM ${prefix}_priv_msgs WHERE to_userid=" . $uid . " GROUP BY to_userid;"; $result = sql_query($qry); while (list($to_userid, $nums) = sql_fetch_row($result)) { $allget = $nums; #++; # Anzahl aller pm's ermitteln } $qry = "SELECT from_userid, Count(msg_id) FROM ${prefix}_priv_msgs_send WHERE from_userid=" . $uid . " GROUP BY from_userid;"; $result = sql_query($qry); while (list($from_userid, $nums) = sql_fetch_row($result)) { $allsend = $nums; #++; # Anzahl aller pm's ermitteln } include("modules/" . $GLOBALS['module_name'] . "/inboxsize-conf.php"); $erlaubtpm = $sentboxsize; $erlaubtgetpm = $inboxsize; if (MX_IS_ADMIN && $pmgrenze_admin == 0) { } else { if (mxGetAdminPref('radminsuper') && $pmgrenze_godadmin == 0) { } else { if($erlaubtpm == 0 && $erlaubtgetpm == 0) { } else { $nochpm = $erlaubtpm - $allsend; $nochgetpm = $erlaubtgetpm - $allget; if($allget >= $erlaubtgetpm) { $nochgetpm = "$nochgetpm"; } if($allsend >= $erlaubtpm) { $nochpm = "$nochpm"; } echo "
\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "
\n"; echo "

\n"; echo "" . _PMNE . "\n"; echo "

\n"; echo "

\n"; echo " " . _PMNA . "\n"; echo "

\n"; echo "

\n"; echo "" . _PMNOCH . $nochgetpm . _PMFREI . _PMVON . $erlaubtgetpm . "\n"; echo "

\n"; echo "

\n"; echo "" . _PMNOCH . $nochpm . _PMFREI . _PMVON . $erlaubtpm . "\n"; echo "

\n"; echo "
\n"; echo "\n"; } } } //Ende PM Begrenzung CloseTable(); // echo "
"; } function messagesheader1($uid) { global $url_images, $module_name, $prefix, $user_prefix, $bgcolor3, $bgcolor2, $pmgrenze_godadmin, $pmgrenze_admin; 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 to_userid, Count(msg_id) FROM ${prefix}_priv_msgs WHERE to_userid=" . $uid . " GROUP BY to_userid;"; $result = sql_query($qry); while (list($to_userid, $nums) = sql_fetch_row($result)) { $allget = $nums; #++; # Anzahl aller pm's ermitteln } $qry = "SELECT from_userid, Count(msg_id) FROM ${prefix}_priv_msgs_send WHERE from_userid=" . $uid . " GROUP BY from_userid;"; $result = sql_query($qry); while (list($from_userid, $nums) = sql_fetch_row($result)) { $allsend = $nums; #++; # Anzahl aller pm's ermitteln } include("modules/" . $GLOBALS['module_name'] . "/inboxsize-conf.php"); $erlaubtpm = $sentboxsize; $erlaubtgetpm = $inboxsize; if (MX_IS_ADMIN && $pmgrenze_admin == 0) { } else { if (mxGetAdminPref('radminsuper') && $pmgrenze_godadmin == 0) { } else { if($erlaubtpm == 0 and $erlaubtgetpm == 0) { } else { $nochpm = $erlaubtpm - $allsend; $nochgetpm = $erlaubtgetpm - $allget; if($allget >= $erlaubtgetpm) { $nochgetpm = "$nochgetpm"; } if($allsend >= $erlaubtpm) { $nochpm = "$nochpm"; } echo "
\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "
\n"; echo "

\n"; echo " " . _PMNA . "\n"; echo "

\n"; echo "

\n"; echo "" . _PMNE . "\n"; echo "

\n"; echo "

\n"; echo "" . _PMNOCH . $nochpm . _PMFREI . _PMVON . $erlaubtpm . "\n"; echo "

\n"; echo "

\n"; echo "" . _PMNOCH . $nochgetpm . _PMFREI . _PMVON . $erlaubtgetpm . "\n"; echo "

\n"; echo "
\n"; echo "\n"; } } } //Ende PM Begrenzung CloseTable(); // echo "
"; } function prvmsgerror($error_msg, $uid) { 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, $uid); } $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, $uid); } 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 "		" . "" . "" . "
"; if ($allow_bbcode == 1) { printsmilies(); } echo "
"; if ($allow_bbcode == 1) { putitems(); } echo "
" . _PMSSAVE . ":

" ."		 " . _NOTSAVEPMS . "
\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 (from_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_send WHERE (from_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_send WHERE (msg_id=$msg_id) AND (from_userid=$uid) or (from_userid is null)"; if(!sql_query($qry)) { prvmsgerror(_ERRMSGNODELETE, $uid); } 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 (from_userid=$uid) or (from_userid is null)"; if(!sql_query($qry)) { prvmsgerror(_ERRMSGNODELETE, $uid); } 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, $uid); } 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 . "
" . "
" . _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 "		" . "" . "" . "
"; 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, $page, $pagesize; global $bgcolor1, $bgcolor2, $bgcolor3, $textcolor1, $textcolor2, $popupwidth, $poptableborder; $uid = (int)$uid; $count = "SELECT COUNT(to_userid) AS total FROM ${prefix}_priv_msgs_send "; $select = "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.to_userid = ${user_prefix}_users.uid "; $min = $pagesize * ($page - 1); // This is where we start our record set from $max = $pagesize; // This is how many rows to select $where = "where from_userid = $uid "; $sort = "order by msg_time"; //sorty by ..... $limit = " DESC LIMIT " . $min . ", " . $max; // we only want rows $min to $max $count_result = sql_query($count . $where); list($num_rows_per_order) = sql_fetch_row($count_result); $result = sql_query($select . $where . $sort . $limit); # or die(); // Now lets do it !! if (!$result) { prvmsgerror(_ERRMSGDATABASE, $uid); } 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"; echo "\n" . "\t\n" . "\t\n" . "\t\n" . "\t\n" . "\t\n" . "\t\n" . "\n"; while ($row = sql_fetch_array($result)) { //Nachrichten ungelesenen auslesen für "pix" -----> $pm_uhrzeit = $row["msg_time"]; $select1 = "SELECT * FROM ${prefix}_priv_msgs "; $where1 = "where msg_time = '$pm_uhrzeit'"; $result_read_msg = sql_query($select1 . $where1); //<----- bis hier 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++; } } //page echo "\n\t\n\t\n\n



" . _SENTPMSDONTHAVESOME . "


  " . _SENTPMS . "

\n" . "
\"" " . _SENTPMSTO . "" . _PMSSUBJECT . "" . _PMSDATE . "
"; echo ""; //ab hier Abfrage für schon gelesen "pix"----> //Eigene Nachrichten auslesen $ungelesen= mysql_fetch_array($result_read_msg); if ($ungelesen["read_msg"] == 0 && $ungelesen["read_msg"] != "") { echo "\"""; } else { echo ""; } //<----- bis hier echo " " . $row["toname"] . "  " . $row["subject"] . "$postedtime
"; if ($num_rows_per_order > $pagesize) { $total_pages = ceil($num_rows_per_order / $pagesize); // How many pages are we dealing with here ?? $prev_page = $page - 1; if ($prev_page > 0) { echo ""; } else { echo "\n"; } echo ""; $next_page = $page + 1; if ($next_page <= $total_pages) { echo ""; } else { echo "\n"; } /* Added a numbered page list, only shows up to 50 pages. */ echo "\n"; } echo "
"; echo mxCreateImage(MX_ML_IMAGEPATH . 'left.gif', _PREVIOUS . " (" . $prev_page . ")"); echo " "; echo "$num_rows_per_order " . " ($total_pages " . _PAGES . ")"; echo ""; echo mxCreateImage(MX_ML_IMAGEPATH . 'right.gif', _NEXTPAGE . " (" . $next_page . ")"); echo " 
"; echo " [ "; for($n = 1; $n < $total_pages; $n++) { if ($n == $page) { echo "$n"; } else { echo ""; echo "$n"; } if ($n >= 50) { // if more than 50 pages are required, break it at 50. $break = true; break; } else { // guess not. echo " | "; } } if (!isset($break)) { // are we sopposed to break ? if ($n == $page) { echo "$n"; } else { echo ""; echo "$n"; } } echo " ] "; echo "
"; //page ende echo "
"; echo "\n"; echo " "; } 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, $uid); } $row = sql_fetch_array($result); if (!$row["msg_id"]) { msgindex($uid); } else { $posterdata = get_userdata_from_id($row["to_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, $uid); } 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/" . $GLOBALS['module_name'] . "/inboxsize-conf.php"); global $prefix, $user_prefix, $PHP_SELF, $module_name, $refresh, $bgcolor2, $pmgrenze_godadmin, $pmgrenze_admin; $to_userid = 0; $uid = (int)$uid; if (empty($arrpostdata["to_user"]) && empty($arrpostdata["to_all"]) || (!empty($arrpostdata["to_all"]) && !MX_IS_ADMIN)) { prvmsgerror(_ERRMSGNOUSER, $uid); } 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, $uid); } } // 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 (MX_IS_ADMIN && $pmgrenze_admin == 0) { } else { if (mxGetAdminPref('radminsuper') && $pmgrenze_godadmin == 0) { } else { if ($sentboxsize == 0) { } else { if ($countpmsent[0] >= $sentboxsize) { prvmsgerror(_SENTPMBOXVOLL, $uid); } } if ($inboxsize == 0) { } else { if ($count_anzahl[0] >= $inboxsize) { prvmsgerror(_PMBOXVOLL, $uid); } } } } //Ende PM Begrenzung if (!($arrpostdata["subject"])) { prvmsgerror(_ERRMSGNOSUBJECT, $uid); } if (strip_tags($arrpostdata["subject"]) != $arrpostdata["subject"]) { prvmsgerror(_ERRMSGNOHTMLINSUBJECT, $uid); } if (!($arrpostdata["image"])) { prvmsgerror(_ERRMSGNOICON, $uid); } if (!($arrpostdata["message"])) { prvmsgerror(_ERRMSGNOMESSAGE, $uid); } $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, from_userid, to_userid, msg_time, msg_text) "; //Gesendete PM´s speichern if (empty($arrpostdata["to_all"])) { //ignore Funktion if (mxModuleAllowed("Friendlist")) { include("modules/Friendlist/config.php"); if (!(MX_IS_ADMIN && $friendlist_admin == 0)) { if (!(mxGetAdminPref('radminsuper') && $friendlist_godadmin == 0)) { $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, $uid); } } } } ###### $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, $uid); } if (empty($arrpostdata["notsave"])) { } else { if (!$result = sql_query($qry_msg_sent)) { prvmsgerror(_ERRMSGNOSUBMIT, $uid); } } } 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'")); $message = _HELLO . " $touser_uname,\n" . _PMEMAIL . MX_BASE_URL . _PMEMAIL1 . "$Absender " . _PMEMAIL2 . MX_BASE_URL . "modules.php?name=" . $GLOBALS['module_name'] . _PMEMAIL3 . MX_BASE_URL . "modules.php?name=Your_Account&op=edithome"; $subject = _PMEMAILSUB . MX_BASE_URL; if (!mxIsUserOnline($touser_uname) && ($user_pm_mail ==1)) { mxMail($touser_email, "$subject", $message, $GLOBALS['adminmail'],"text","PM-Mail"); } pmxHeader::add(''); messagesheader($uid); echo "" . "" . "" . "

" . _PMSMSGPOSTED . " " . ((isset($i)) ? " (" . $i . " User)" : "") . "
" . _PMSRETURNTOPMSG . "

"; } 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, $uid); } else { $xrefresh = ($nextid) ? ($refresh * 2) : $refresh; pmxHeader::add(''); messagesheader($uid); echo "" . "

" . _PMSMSGDELETED . "

"; if ($nextid) { echo "" . mxCreateImage("$url_button/index.gif", _PMSRETURNTOPMSG) . "   " . mxCreateImage("$url_button/naechste.gif", _PMSNEXT) . ""; } else { echo "" . _PMSRETURNTOPMSG . ""; } 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); } } pmxHeader::add(''); messagesheader($uid); echo "" . "

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

" . _PMSRETURNTOPMSG . "

"; } /** * 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'); }