0) { $query = sql_query("SELECT uname FROM ".$user_prefix."_users WHERE uname LIKE '%".mxAddSlashesForSQL($queryString)."%' LIMIT 5"); //was haben wir gefunden? if($query) { while ($result = sql_fetch_object($query)) { $uname = $result->uname; //Userdaten auf Basis der gefundenen Übereinstimmungen $userdata = mxGetUserDataFromUsername($uname); $pic = sql_fetch_array(sql_query("SELECT aid, foto, werist FROM ".$prefix."_avatar WHERE ((aid='$uname')) ")); if (!empty($pic["foto"])) { $avatarFile = $pic["foto"]; }else{ $avatarFile = $pic["werist"]; } // Wenn ein Avatar hochgeladen wurde if (!empty($avatarFile)) { $avatar = $avatarFile; } else { $avatar = "kein_bild.jpg"; } $picpath = MX_PATH_MEMBERAVATAR; $bild = "

"; //Onlinestatus $online = mxIsUserOnline($uname); if ($online ==true) { $online = mxCreateImage('images/online.gif'); } else { $online = mxCreateImage('images/offline.gif'); } //Die Ausgabe echo '

'.$bild.'	Nickname: '.$uname.'
Alter: '.$userdata['user_age'].'
User ist:'.$online.'

'; } } } else { // Nix machen } // Das ist der queryString. } //else weil sonst beim Suchergebnis die ganze Webseite auftaucht Klammer befindet sich am Ende des Dokumentes else { ?> $maxpages) { $page = $maxpages; } $min = $pagesize * ($page - 1); if ($min < 1) { $min = 0; } /* Datensaetze auslesen */ $result = sql_query("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 LIMIT " . $min . ", " . $pagesize); if (!$result) { prvmsgerror(_ERRMSGDATABASE); } if (!$total_messages = sql_num_rows($result)) { $havemessages = 0; } else { $havemessages = 1; pmxHeader::add_script('modules/' . $module_name . '/javascript.js'); pmxHeader::add_script(PMX_JAVASCRIPT_PATH . 'jquery/jquery.js'); pmxHeader::add_script(PMX_JAVASCRIPT_PATH . 'jquery/jquery.tooltip.js'); ?> \n"; echo "\n"; messagesheader(); echo "

" . mxCreateImage("$url_images/inbox.png", _ESENTPMS) . " " . _PMIN . "

"; echo "\n"; if (!$havemessages) { echo "\n\n\n"; } else { echo "\n" . "\n"; echo "\n" . "\n" . '' . "\n" . "\n" . "\n" . "\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"]); $tooltip = pmValueToText($row["subject"]) . ' |~| ' . pmValueToText($row["msg_text"]); echo "\n"; echo "\n"; echo ''; echo "\n"; echo "\n"; echo "\n"; echo "\n"; $count++; } if ($havemessages) { echo "\n" . "\n" . "\n" . "\n" . "\n" . "\n" . "\n" . "\n"; } } echo "\n\n\n

" . _PMSDONTHAVESOME . "
" . _EMPFPMS . "
	' . mxCreateImage($url_images . '/down.gif', _PMSMSGSTATUS) . '		" . _PMSFROM . "	" . _PMSSUBJECT . "	" . _PMSDATE . "
"; echo "	"; if ($row["read_msg"] == 1) { echo mxCreateImage($url_images . '/read.gif', _PMSREAD); } else { echo mxCreateImage($url_images . '/unread.gif', _PMSNOTREAD); } echo "	' . mxCreateImage($url_icons . '/' . $row['msg_image']) . '	" . mxCreateUserprofileLink($row["fromname"]) . "	" . $row["subject"] . "	$postedtime
	" . _PMALL . "				" . _SAVEPMSS . " " . mxCreateImage("$url_images/disk.png", _SAVEPMS) . "
"; if ($havemessages) { echo " " . mxCreateImage("$url_images/arrow_top.gif") . _PMDEL . " "; echo ""; echo " "; echo " " . mxCreateImage("$url_images/mail_new.png", _PMSPRIVATEMESSAGESEND) . " " . _PMSPRIVATEMESSAGESEND . " "; echo " " . mxCreateImage("$url_images/outbox.png", _ASENTPMS) . " " . _ASENTPMS . ""; echo pm_pager($page, $allrows); } else { echo " " . mxCreateImage("$url_images/mail_new.png", _PMSPRIVATEMESSAGESEND) . " " . _PMSPRIVATEMESSAGESEND . " "; echo " " . mxCreateImage("$url_images/outbox.png", _ASENTPMS) . " " . _ASENTPMS . " "; } echo "

\n"; } function messagesheader($modus = 'read') { global $url_images, $module_name, $prefix, $user_prefix, $bgcolor3, $bgcolor2; $windowname = md5($GLOBALS['sitename']); $modus = ($modus == 'send') ? '' : '&op=sendmsg'; /* PM Begrenzung */ $status = mxPmBoxstatus(); // mxDebugFuncVars($status); $getbox = $status['get']; $sendbox = $status['send']; if ($getbox['limit'] || $sendbox['limit']) { pmxHeader::add_style('modules/' . $GLOBALS['module_name'] . '/style/bar.css'); if ($getbox['box'] >= $getbox['limit']) { $getbox['free'] = '' . $getbox['free'] . ''; } if ($sendbox['box'] >= $sendbox['limit']) { $sendbox['free'] = '' . $sendbox['free'] . ''; } // Balkenanzeige $prozentpninbox = ($getbox['limit']) ? floor($getbox['box'] * 100 / $getbox['limit']) : 0; // mit floor() gleich abrunden $prozentpnoutbox = ($sendbox['limit']) ? floor($sendbox['box'] * 100 / $sendbox['limit']) : 0; switch (true) { case $prozentpninbox < 75: $makefullA = "background-color: green;"; break; case $prozentpninbox < 90: $makefullA = "background-color: orange;"; break; case $prozentpninbox > 100: $prozentpninbox = 100; // falls uebervoll, auf 100% stellen default: $makefullA = "background-color: red;"; } switch (true) { case $prozentpnoutbox < 75: $makefullB = "background-color: green;"; break; case $prozentpnoutbox < 90: $makefullB = "background-color: orange;"; break; case $prozentpnoutbox > 100: $prozentpnoutbox = 100; // falls uebervoll, auf 100% stellen default: $makefullB = "background-color: red;"; } $in = '

' . $prozentpninbox . '%
'; $out = '

' . $prozentpnoutbox . '%
'; if ($getbox['error']) { $in .= '
' . _GETPMBOXVOLL . '
'; } if ($sendbox['error']) { $out .= '
' . _SENTPMBOXVOLL . '
'; } // Ende Balkenanzeige } /* Ende PM Begrenzung */ include_once("modules/Your_Account/navbar.php"); OpenTable(); nav(); CloseTable(); echo '
'; OpenTable(); echo "
" . _PMSPRIVATEMESSAGES . "

"; /* PM Begrenzung */ if ($getbox['limit'] || $sendbox['limit']) { echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; // Balkenanzeige echo "\n"; echo "\n"; echo "\n"; echo "\n"; // Ende Balkenanzeige echo "
" . _PMNE . " " . _PMNA . "
" . _PMNOCH . $getbox['free'] . _PMFREI . _PMVON . $getbox['limit'] . " " . _PMNOCH . $sendbox['free'] . _PMFREI . _PMVON . $sendbox['limit'] . "
" . $in . " " . $out . "
\n"; } /* Ende PM Begrenzung */ CloseTable(); // echo '
'; } function prvmsgerror($error_msg) { global $header, $footer, $bgcolor2, $url_images; if (!isset($header)) { include("header.php"); } messagesheader(); echo "" . "

"; echo "" . _PMSGERROR . "

"; OpenTable2(); echo "
$error_msg

"; CloseTable2(); echo "

" . _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; 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(); echo "

  " . mxCreateImage("$url_images/inbox.png", _ESENTPMS) . "  " . _PMIN . "

"; echo""; echo "" . "" . "" . "" . "\n" . "" . '' . ""; if (!empty($posterdata["user_sig"])) { echo "\n"; } echo "
" . "" . mxCreateImage("$url_images/privatemessages.png", _PMSRETURNTOPMSG) . " "; if ($previous) { echo "" . mxCreateImage("$url_images/left.gif", _PMSPREVIOUS) . " "; } else { echo mxCreateImage("$url_images/left.gif", _PMSPREVIOUS) . " "; } if ($next) { echo "" . mxCreateImage("$url_images/right.gif", _PMSNEXT) . ""; } else { echo mxCreateImage("$url_images/right.gif", _PMSNEXT); } echo "
" . _PMSPRIVATEMESSAGE . ":   " . msg_smile($row["subject"]) . "
" . _PMSFROM . ": " . mxCreateUserprofileLink($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 mxCreateImage($url_avatar . '/' . $posterdata['user_avatar'], $posterdata['uname']) . '
'; } else { echo mxCreateImage($url_avatar . '/' . $blankavatar, $posterdata['uname']) . '
'; } echo get_onlinestatus($posterdata["uname"]) . " ' . mxCreateImage($url_icons . '/' . $row['msg_image']) . ' ' . _PMSSENT . ': ' . $postedtime . '
" . $row["msg_text"] . "

" . $posterdata["user_sig"] . "
" . "" . "\n" . "
" . mxCreateImage("$url_images/email_delete.png", _PMSDELETE) . " " . _PMSDELETE . "\n " . "" . mxCreateImage("$url_images/privatemessages.png", _PMSRETURNTOPMSG) . " "; if ($previous) { echo "" . mxCreateImage("$url_images/left.gif", _PMSPREVIOUS) . " "; } else { echo mxCreateImage("$url_images/left.gif", _PMSPREVIOUS) . " "; } if ($next) { echo "" . mxCreateImage("$url_images/right.gif", _PMSNEXT) . ""; } else { echo mxCreateImage("$url_images/right.gif", _PMSNEXT); } 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 " " . "" . "" . "
" . htmlspecialchars($replymsg) . " "; if ($allow_bbcode == 1) { printsmilies(); } echo "
"; if ($allow_bbcode == 1) { putitems(); echo ' '; } echo "
" . _PMSSAVE . ":

" . _NOTSAVEPMS . "
\n" . "" . "\n" . " \n" . "\n" . "
" . "
"; } } function sendmessage($msg_id, $uid, $to_user = "") { global $allow_bbcode, $allow_html; global $prefix, $user_prefix, $module_name, $url_smiles, $url_images, $subjectdefaulticon; global $bgcolor1, $bgcolor2, $bgcolor3, $textcolor1, $textcolor2; $msg_id = intval($msg_id); $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 "\n"; echo "\n"; messagesheader(); echo "" . "" . "" . "" . "" . "" . "" . ""; if (MX_IS_ADMIN) { echo "" . "" . "" . ""; } echo "" . "" . "" . "" . "" . "" . "" . "" . "" . "" . "" . "" . "" . "" . "" . "
" . _PMSPRIVATEMESSAGESEND . "
" . "
" . mxCreateImage("$url_images/privatemessages.png", _PMSRETURNTOPMSG) . "
" . _PMSTO . ":

Automatische suche durch Namen eingeben...
" . _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 " " . "" . "" . "
" . htmlspecialchars($msg_text) . " "; if ($allow_bbcode == 1) { printsmilies(); } echo "
"; if ($allow_bbcode == 1) { putitems(); echo ' '; } 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 submitmessage($arrpostdata, $uid) { global $prefix, $user_prefix, $module_name, $refresh, $bgcolor2; /* Senderdaten */ $sender = mxGetUserData(); if (empty($arrpostdata["to_user"]) && empty($arrpostdata["to_all"]) || (!empty($arrpostdata["to_all"]) && !MX_IS_ADMIN)) { prvmsgerror(_ERRMSGNOUSER); } if (empty($arrpostdata["to_all"])) { /* Empfaengerdaten */ $recipient = mxGetUserDataFromUsername($arrpostdata['to_user']); /* kein gueltiger Empfaenger */ if (empty($recipient['uid'])) { prvmsgerror(_PMSUSERNOTINDB); } /* ignore Funktion */ if (mxPmIsRecipientIgnored($recipient['uid'], $uid)) { prvmsgerror($recipient['uname'] . ' ' . _NOMESSAGE); } /* PM Begrenzung */ $status = mxPmBoxstatus($recipient['uid']); $getbox_recipient = $status['get']; if ($getbox_recipient['limit'] && $getbox_recipient['error']) { prvmsgerror(_EMPFPMBOXVOLL); } /* Ende PM Begrenzung */ } /* PM Begrenzung */ $status = mxPmBoxstatus(); $sendbox = $status['send']; if ($sendbox['limit'] && $sendbox['error']) { prvmsgerror(_SENTPMBOXVOLL); } /* Ende PM Begrenzung */ $arrpostdata["subject"] = strip_tags($arrpostdata["subject"]); if (!($arrpostdata["subject"])) { $arrpostdata["subject"] = _PMNOSUBJECT; } if (!($arrpostdata["message"])) { prvmsgerror(_ERRMSGNOMESSAGE); } $qry1 = "INSERT INTO {$prefix}_priv_msgs (msg_image, subject, from_userid, to_userid, msg_time, msg_text) "; if (empty($arrpostdata["to_all"])) { $qry1 .= "VALUES ('" . mxAddSlashesForSQL($arrpostdata["image"]) . "', '" . mxAddSlashesForSQL($arrpostdata["subject"]) . "', " . intval($uid) . ", " . intval($recipient['uid']) . ", now(), '" . mxAddSlashesForSQL($arrpostdata["message"]) . "')"; if (!sql_query($qry1)) { prvmsgerror(_ERRMSGNOSUBMIT . ' (1)'); } /* Gesendete PM´S speichern */ if (!empty($arrpostdata["notsave"])) { $newid = sql_insert_id(); $qry = "INSERT INTO {$prefix}_priv_msgs_send (msg_id, msg_image, subject, from_userid, to_userid, msg_time, msg_text) VALUES (" . intval($newid) . ", '" . mxAddSlashesForSQL($arrpostdata["image"]) . "', '" . mxAddSlashesForSQL($arrpostdata["subject"]) . "', " . intval($uid) . ", " . intval($recipient['uid']) . ", now(), '" . mxAddSlashesForSQL($arrpostdata["message"]) . "')"; sql_query($qry); } /* Ende Gesendete PM´S speichern */ } 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 ('" . mxAddSlashesForSQL($arrpostdata["image"]) . "', '" . mxAddSlashesForSQL($arrpostdata["subject"]) . "', " . intval($uid) . ", " . intval($to_userid) . ", now(), '" . mxAddSlashesForSQL($arrpostdata["message"]) . "')"; $result2 = sql_query($qry2); if ($result2) $i++; } } } /* Email bei neuer PN wenn User offline ist */ if (empty($arrpostdata["to_all"])) { mxPmMailNote($recipient, $sender); } /* Ende, Email bei neuer PN wenn User offline ist */ pmxHeader::add(''); messagesheader(); echo "" . "" . "" . "

" . _PMSMSGPOSTED . " " . ((isset($i)) ? " (" . $i . " User)" : "") . "
" . _PMSRETURNTOPMSG . "
"; } function deletemessage($msg_id, $uid) { global $prefix, $user_prefix, $module_name, $refresh, $bgcolor2, $url_images; 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 { $xrefresh = ($nextid) ? ($refresh * 2) : $refresh; pmxHeader::add(''); messagesheader(); echo "" . "

" . _PMSMSGDELETED . '

'; if ($nextid) { echo "" . mxCreateImage("$url_images/privatemessages.png", _PMSRETURNTOPMSG) . " " . mxCreateImage("$url_images/right.gif", _PMSNEXT) . ""; } else { echo "" . _PMSRETURNTOPMSG . ""; } echo "

"; } } function deletemessages($arrformvars, $uid) { global $prefix, $refresh, $module_name, $bgcolor2; $status = 0; $delmess = array(); 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(); echo "" . "

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

" . _PMSRETURNTOPMSG . "

"; } function pm_pager($page, $allrows, $op = '') { global $module_name, $pagesize; /* 5 sollten es schon sein... */ $pagesize = (empty($pagesize) || intval($pagesize) < 5) ? 5 : intval($pagesize); if ($allrows <= $pagesize) { return ' '; } /* Anzahl aller Seiten */ $numpages = ceil($allrows / $pagesize); $start = 1; $end = $numpages + 1; if ($numpages > 10) { $start = $page - 4; if ($start < 1) $start = 1; $end = $start + 10; if ($end > $numpages) $end = $numpages + 1; if ($end == $numpages + 1) $start = $end - 10; } $link = 'modules.php?name=' . $module_name . (($op == 'sendmsg') ? '&op=sendmsg' : ''); $out = '
'; if ($page <= 1) { $out .= ' « '; } else { $caption = _GOTOPAGEPREVIOUS . ': ' . ($page - 1) ; $backlink = ($page > 1) ? ' href="' . $link . '&page=' . ($page - 1) . '"' : ''; $out .= ' « '; } if ($start > 1) { $out .= '1'; if ($start > 2) $out .= ' .. '; } for ($i = $start; $i < $end; $i++) { if ($i == $page) { $out .= '' . $i . ''; } else { $out .= '' . $i . ''; } } if ($end < $numpages + 1) { if ($end < $numpages) $out .= ' .. '; $out .= '' . $numpages . ''; } if ($page >= $numpages) { $out .= ' » '; } else { $caption = _GOTOPAGENEXT . ': ' . ($page + 1) ; $nextlink = ($page < $numpages) ? ' href="' . $link . '&page=' . ($page + 1) . '"' : ''; $out .= ' » '; } $out .= '
'; $out = str_replace('', "\n", $out); return $out; } function sendmsg($uid) { global $prefix, $user_prefix, $module_name, $url_smiles, $url_icons, $subjectdefaulticon, $url_images, $pagesize; global $bgcolor1, $bgcolor2, $bgcolor3, $textcolor1, $textcolor2, $popupwidth, $poptableborder; $result = sql_query("SELECT COUNT(to_userid) FROM `{$prefix}_priv_msgs_send` where from_userid = " . intval($uid)); list($allrows) = sql_fetch_row($result); /* Limit fuer Pager berechnen */ $pagesize = (empty($pagesize) || intval($pagesize) < 5) ? 5 : intval($pagesize); $page = (empty($_REQUEST['page']) || intval($_REQUEST['page']) < 1) ? 1 : intval($_REQUEST['page']); $maxpages = ceil($allrows / $pagesize); if ($page > $maxpages) { $page = $maxpages; } $min = $pagesize * ($page - 1); if ($min < 1) { $min = 0; } /* Datensaetze auslesen */ $result = sql_query("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 WHERE from_userid = " . intval($uid) . " ORDER BY msg_time DESC LIMIT " . $min . ", " . $pagesize); if (!$result) { prvmsgerror(_ERRMSGDATABASE); } if (!$total_messages = sql_num_rows($result)) { $havemessages = 0; } else { $havemessages = 1; pmxHeader::add_script('modules/' . $module_name . '/javascript.js'); pmxHeader::add_script(PMX_JAVASCRIPT_PATH . 'jquery/jquery.js'); pmxHeader::add_script(PMX_JAVASCRIPT_PATH . 'jquery/jquery.tooltip.js'); ?> \n"; echo "\n"; messagesheader('send'); echo "

  " . mxCreateImage("$url_images/outbox.png", _ESENTPMS) . "  " . _PMOUT . "

"; echo "\n"; if (!$havemessages) { echo "\n\n\n"; } else { echo "\n" . "\n"; echo "\n" . "\n" . '' . "\n" . "\n" . "\n" . "\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"]); $tooltip = pmValueToText($row["subject"]) . ' |~| ' . pmValueToText($row["msg_text"]); echo "\n"; echo "\n"; echo ''; echo "\n"; echo "\n"; echo "\n"; echo "\n"; $count++; } if ($havemessages) { echo "\n" . "\n" . "\n" . "\n" . "\n" . "\n" . "\n" . "\n"; } } echo "\n\n\n

" . _SENTPMSDONTHAVESOME . "

  " . _SENTPMS . "
' . mxCreateImage($url_images . '/down.gif', _PMSMSGSTATUS) . ' " . _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 " $\""$ "; } elseif (is_null($ungelesen["read_msg"])) { echo " $\""$ "; } else { echo " $\""$ "; } /* if ($ungelesen["read_msg"] == "0") { echo " $\""$ "; } else { echo ""; }*/ // <----- bis hier echo " ' . mxCreateImage($url_icons . '/' . $row['msg_image']) . ' " . mxCreateUserprofileLink($row["toname"]) . " " . $row["subject"] . " $postedtime
" . _PMALL . " " . _SAVEPMSS . " " . mxCreateImage("$url_images/disk.png", _SAVEPMS) . "
"; if ($havemessages) { echo " " . mxCreateImage("$url_images/arrow_top.gif") . _PMDEL . " "; echo ""; echo " "; echo "

  " . mxCreateImage("$url_images/mail_new.png", _PMSPRIVATEMESSAGESEND) . " " . _PMSPRIVATEMESSAGESEND . " "; echo "  " . mxCreateImage("$url_images/inbox.png", _ESENTPMS) . " " . _ESENTPMS . ""; echo pm_pager($page, $allrows, 'sendmsg'); } else { echo "

  " . mxCreateImage("$url_images/mail_new.png", _PMSPRIVATEMESSAGESEND) . " " . _PMSPRIVATEMESSAGESEND . " "; echo "  " . mxCreateImage("$url_images/inbox.png", _ESENTPMS) . " " . _ESENTPMS . "

"; } 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; list($id, $uid) = mxForceInteger($id, $uid); $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["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); } if (empty($posterdata["user_sig"])) { $rowspan = "2"; } else { $rowspan = "3"; $posterdata["user_sig"] = pmPrepDisplay(pmxSigBbCode($posterdata["user_sig"])); } messagesheader('send'); echo "

  " . mxCreateImage("$url_images/outbox.png", _PMOUT) . "  " . _PMOUT . "

"; echo""; echo "" . "" . "" . "" . "\n" . "" . "" . ""; if (!empty($posterdata["user_sig"])) { echo "\n"; } echo "
" . "" . mxCreateImage("$url_images/privatemessages.png", _PMSRETURNTOPMSG) . " "; if ($previous) { echo "" . mxCreateImage("$url_images/left.gif", _PMSPREVIOUS) . " "; } else { echo mxCreateImage("$url_images/left.gif", _PMSPREVIOUS) . " "; } if ($next) { echo "" . mxCreateImage("$url_images/right.gif", _PMSNEXT) . ""; } else { echo mxCreateImage("$url_images/right.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"] . "
" . "" . "\n" // . "
" . mxCreateImage("$url_images/email_delete.png", _PMSDELETE) . " " . _PMSDELETE . "\n " . mxCreateImage("$url_images/email_delete.png", _PMSDELETE) . "\n" . " " . "" . mxCreateImage("$url_images/privatemessages.png", _PMSRETURNTOPMSG) . " "; if ($previous) { echo "" . mxCreateImage("$url_images/left.gif", _PMSPREVIOUS) . " "; } else { echo mxCreateImage("$url_images/left.gif", _PMSPREVIOUS) . " "; } if ($next) { echo "" . mxCreateImage("$url_images/right.gif", _PMSNEXT) . ""; } else { echo mxCreateImage("$url_images/right.gif", _PMSNEXT); } echo "
" . "
"; } } function deletesentmessage($msg_id, $uid) { global $prefix, $user_prefix, $module_name, $refresh, $bgcolor2, $url_images; 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); } else { messagesheader($uid, 'send'); echo "" . "

" . _PMSMSGDELETED . "

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

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

" . _PMSRETURNTOPMSG . "

"; } // PM per E-Mail sichern function msgsichern($uid) { global $prefix, $user_prefix, $module_name, $url_smiles, $subjectdefaulticon, $url_images; global $bgcolor1, $bgcolor2, $bgcolor3, $textcolor1, $textcolor2, $popupwidth, $poptableborder; $kopf = "" . _HELLO . ",\n" . _PMEMAIL . PMX_HOME_URL . _YOURMAILPMS . _HPMS . ":\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" . _AOPMS . ":\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" . _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); // mxDebugFuncVars($nachricht); messagesheader(); OpenTable(); echo '' . _YOURPMS . ''; echo "
" . mxCreateImage("$url_images/privatemessages.png", _PMSRETURNTOPMSG) . "
"; CloseTable(); } // PM per E-Mail sichern ende /** * mainprog */ if (!MX_IS_USER) { header("Location: modules.php?name=Your_Account&op=login"); exit; } else { $module_name = basename(dirname(__FILE__)); define('MX_ML_IMAGEPATH', 'modules/' . $module_name . '/images/'); // 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"); include_once("modules/" . $module_name . "/bbfunctions.php"); // PM Begrenzung include_once("modules/" . $module_name . "/functions.php"); mxGetLangfile($module_name); if ($_REQUEST["op"] == "userslist") { userslist(); exit; } $pagetitle = _PMSPRIVATEMESSAGES; include('header.php'); echo "\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 "reply": sendmessage($_REQUEST["id"], $userdata["uid"]); break; case "send": sendmessage(0, (isset($_REQUEST["uname"]) ? $_REQUEST["uname"] : '')); break; case "post": case "send_to": sendmessage(0, (isset($_REQUEST["uname"]) ? $_REQUEST["uname"] : ''), (isset($_REQUEST["to_user"]) ? $_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_messages": deletemessages($_REQUEST, $userdata["uid"]); break; case "read_sent": readsentmessage($_REQUEST["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 "speichern": msgsichern($userdata["uid"]); break; default: msgindex($userdata["uid"]); break; } echo "\n\n"; include('footer.php'); }} ?>

" . _PMNE . "	" . _PMNA . "
" . _PMNOCH . $getbox['free'] . _PMFREI . _PMVON . $getbox['limit'] . "	" . _PMNOCH . $sendbox['free'] . _PMFREI . _PMVON . $sendbox['limit'] . "
" . $in . "	" . $out . "

" . _SENTPMSDONTHAVESOME . "
" . _SENTPMS . "
	' . mxCreateImage($url_images . '/down.gif', _PMSMSGSTATUS) . '		" . _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 " $\""$ "; } elseif (is_null($ungelesen["read_msg"])) { echo " $\""$ "; } else { echo " $\""$ "; } /* if ($ungelesen["read_msg"] == "0") { echo " $\""$ "; } else { echo ""; }*/ // <----- bis hier echo "	' . mxCreateImage($url_icons . '/' . $row['msg_image']) . '	" . mxCreateUserprofileLink($row["toname"]) . "	" . $row["subject"] . "	$postedtime
	" . _PMALL . "				" . _SAVEPMSS . " " . mxCreateImage("$url_images/disk.png", _SAVEPMS) . "
"; if ($havemessages) { echo " " . mxCreateImage("$url_images/arrow_top.gif") . _PMDEL . " "; echo ""; echo " "; echo " " . mxCreateImage("$url_images/mail_new.png", _PMSPRIVATEMESSAGESEND) . " " . _PMSPRIVATEMESSAGESEND . " "; echo " " . mxCreateImage("$url_images/inbox.png", _ESENTPMS) . " " . _ESENTPMS . ""; echo pm_pager($page, $allrows, 'sendmsg'); } else { echo " " . mxCreateImage("$url_images/mail_new.png", _PMSPRIVATEMESSAGESEND) . " " . _PMSPRIVATEMESSAGESEND . " "; echo " " . mxCreateImage("$url_images/inbox.png", _ESENTPMS) . " " . _ESENTPMS . " "; } echo "