function SendOnlineMail()
{
global $db, $func, $__POST, $auth;
include_once "modules/mail/class_mail.php";
$mail = new mail();
if ($_POST['toUserID'] == -1) {
$_SESSION['tmpmsgbody'] = $_POST['msgbody'];
$_SESSION['tmpmsgsubject'] = $_POST['Subject'];
$func->information(t("Bitte gib einen Empfänger für deine Mail an"), "index.php?mod=mail&action=" . $_GET['action'] . "&step=2&replyto=" . $_GET['replyto'] . "&back=1");
// To additional recipients from cfg
} elseif (substr($_POST['toUserID'], 1, 7) == '-mail-') {
$to = substr($_POST['toUserID'], 8, strlen($_POST['toUserID']));
$mail->create_inet_mail('', $to, $__POST['Subject'], $__POST['msgbody'], $_POST['SenderMail']);
$func->confirmation('Die Mail wurde and ' . $to . ' versendet', '');
unset($_SESSION['tmpmsgbody']);
unset($_SESSION['tmpmsgsubject']);
// System-Mail: Insert will be done, by MF
} elseif ($auth['userid'] and $_POST['type'] == 0) {
// Send Info-Mail to receiver
if ($cfg['sys_internet']) {
$row = $db->qry_first('SELECT u.username, u.email, u.lsmail_alert FROM %prefix%user AS u WHERE u.userid = %int%', $_POST['toUserID']);
if ($row['lsmail_alert']) {
$mail->create_inet_mail($row['username'], $row['email'], t('Benachrichtigung: Neue LS-Mail'), t('Du hast eine neue Lansuite-Mail erhalten. Diese Benachrichtigung kannst du im System unter "Meine Einstellungen" deaktivieren'));
}
}
return true;
// Inet-Mail
} else {
$row = $db->qry_first("SELECT name, firstname, email FROM %prefix%user WHERE userid = %int%", $_POST['toUserID']);
if ($auth['userid']) {
$row2 = $db->qry_first("SELECT email FROM %prefix%user WHERE userid = %int%", $auth['userid']);
$_POST['SenderMail'] = $row2['email'];
}
$mail->create_inet_mail($row['firstname'] . ' ' . $row['name'], $row['email'], $__POST['Subject'], $__POST['msgbody'], $_POST['SenderMail']);
$func->confirmation('Die Mail wurde versendet', '');
unset($_SESSION['tmpmsgbody']);
unset($_SESSION['tmpmsgsubject']);
return false;
}
}
function SetNotPaid($userid, $partyid)
{
global $db, $cfg, $func, $auth, $seat2, $usrmgr;
include_once "modules/mail/class_mail.php";
$mail = new mail();
$Messages = array('success' => '', 'error' => '');
$db->qry('UPDATE %prefix%party_user SET paid = 0, paiddate = "" WHERE user_id = %int% AND party_id = %int% LIMIT 1', $userid, $partyid);
$row = $db->qry_first('SELECT username, email from %prefix%user WHERE userid = %int%', $userid);
$row2 = $db->qry_first('SELECT name FROM %prefix%partys WHERE party_id = %int%', $partyid);
$msgtext = $cfg['signon_not_paid_email_text'];
$msgtext = str_replace('%USERNAME%', $row['username'], $msgtext);
$msgtext = str_replace('%PARTYNAME%', $row2['name'], $msgtext);
if ($cfg['signon_send_paid_email'] == 1 or $cfg['signon_send_paid_email'] == 3) {
$mail->create_sys_mail($userid, $cfg['signon_paid_email_subject'], $msgtext) ? $Messages['success'] .= $row['username'] . ' (System-Mail)' . HTML_NEWLINE : ($Messages['error'] .= $row['username'] . ' (System-Mail)' . HTML_NEWLINE);
}
if ($cfg['signon_send_paid_email'] == 2 or $cfg['signon_send_paid_email'] == 3) {
$mail->create_inet_mail($row['username'], $row['email'], $cfg['signon_paid_email_subject'], $msgtext) ? $Messages['success'] .= $row['username'] . ' (Internet-Mail)' . HTML_NEWLINE : ($Messages['error'] .= $row['username'] . ' (Internet-Mail)' . HTML_NEWLINE);
}
// Switch seat back to "marked"
$seat2->MarkSeatIfNotPaidAndSeatReserved($userid);
$usrmgr->WriteXMLStatFile();
$func->log_event(t('Benutzer "%1" wurde für die Party "%2" auf "nicht bezahlt" gesetzt', $row['username'], $row2['name']), 1, '', 'Zahlstatus');
return $Messages;
}
$func->information(t('Du bist nicht berechtigt das Passwort dieses Clans zu ändern'), "index.php?mod=home");
} else {
include_once 'inc/classes/class_masterform.php';
$mf = new masterform();
if ($auth['type'] < 2) {
$mf->AddField(t('Dezeitiges Passwort'), 'old_password', IS_PASSWORD, '', FIELD_OPTIONAL, 'CheckClanPW');
}
$mf->AddField(t('Neues Passwort'), 'password', IS_NEW_PASSWORD);
if ($mf->SendForm('index.php?mod=clanmgr&action=clanmgr&step=10', 'clan', 'clanid', $_GET['clanid'])) {
include_once "modules/mail/class_mail.php";
$mail = new mail();
// Send information mail to all clan members
$clanuser = $db->qry("SELECT userid, username, email FROM %prefix%user WHERE clanid=%int%", $_GET['clanid']);
while ($data = $db->fetch_array($clanuser)) {
$mail->create_mail($auth['userid'], $data['userid'], t('Clanpasswort geändert'), t('Das Clanpasswort wurde durch den Benutzer %1 in "%2" geändert', array($auth['username'], $_POST['password_original'])));
$mail->create_inet_mail($data['username'], $data['email'], t('Clanpasswort geändert'), t('Das Clanpasswort wurde durch den Benutzer %1 in "%2" geändert', array($auth['username'], $_POST['password_original'])), $cfg["sys_party_mail"]);
}
$func->log_event(t('Das Clanpasswort wurde durch den Benutzer %1 geändert', $auth['username']), 1, t('clanmgr'));
}
}
break;
// Delete
// Delete
case 20:
if ($auth['type'] >= 3) {
if ($_GET['clanid']) {
$_POST['action'][$_GET['clanid']] = 1;
}
if ($_POST['action']) {
foreach ($_POST['action'] as $key => $val) {
$db->qry("DELETE FROM %prefix%clan WHERE clanid = %string%", $key);
case 2:
// Email prüfen, Freischaltecode generieren, Email senden
$user_data = $db->qry_first("SELECT username FROM %prefix%user WHERE email = %string%", $_POST['pwr_mail']);
if ($user_data['username'] == "LS_SYSTEM") {
$func->information(t('Für den System-Account darf kein neues Passwort generiert werden'), "index.php?mod=usrmgr&action=pwrecover&step=1");
} else {
if ($user_data['username']) {
$fcode = '';
for ($x = 0; $x <= 24; $x++) {
$fcode .= chr(mt_rand(65, 90));
}
$db->qry("UPDATE %prefix%user SET fcode='{$fcode}' WHERE email = %string%", $_POST['pwr_mail']);
$path = substr($_SERVER['REQUEST_URI'], 0, strpos($_SERVER['REQUEST_URI'], "index.php"));
include_once "modules/mail/class_mail.php";
$mail = new mail();
$mail->create_inet_mail($user_data['username'], $_POST['pwr_mail'], $cfg['usrmgr_pwrecovery_subject'], str_replace("%USERNAME%", $user_data['username'], str_replace("%PATH%", "http://{$_SERVER['SERVER_NAME']}:{$_SERVER['SERVER_PORT']}{$path}index.php?mod=usrmgr&action=pwrecover&step=3&fcode={$fcode}", $cfg['usrmgr_pwrecovery_text'])));
$func->confirmation(t('Dir wurde nun eine Freischalte-URL an die angegebene Emailadresse gesendet. Mit dem Aufruf dieser URL wird dir neues Passwort generiert werden.'), "index.php");
} else {
$func->information(t('Die von dir eigegebene Email existiert nicht in der Datenbank'), "index.php?mod=usrmgr&action=pwrecover&step=1");
}
}
break;
case 3:
// Freischaltecode prüfen, Passwort generieren, Freischaltcode zurücksetzen
$user_data = $db->qry_first("SELECT fcode FROM %prefix%user WHERE fcode = %string%", $_GET['fcode']);
if ($user_data['fcode'] && $_GET['fcode'] != '') {
$new_pwd = "";
for ($x = 0; $x <= 8; $x++) {
$new_pwd .= chr(mt_rand(65, 90));
}
$db->qry("UPDATE %prefix%user SET password = %string%, fcode = '' WHERE fcode = %string%", md5($new_pwd), $_GET['fcode']);
$text = str_replace("%CLAN%", $user["clan"], $text);
$text = str_replace("%CLANURL%", $user["clanurl"], $text);
$text = str_replace("%PARTYNAME%", $party_data["name"], $text);
$text = str_replace('%PARTYURL%', $cfg['sys_partyurl'], $text);
$text = str_replace("%MAXGUESTS%", $party_data['max_guest'], $text);
$text = str_replace("%WWCLID%", $user["wwclid"], $text);
$text = str_replace("%WWCLCLANID%", $user["wwclclanid"], $text);
$text = str_replace("%NGLID%", $user["nglid"], $text);
$text = str_replace("%NGLCLANID%", $user["nglclanid"], $text);
$text = str_replace("%IP%", $user["ip"], $text);
$user["paid"] ? $text = str_replace("%BEZAHLT%", t('Ja'), $text) : ($text = str_replace("%BEZAHLT%", t('Nein'), $text));
$user["checkin"] ? $text = str_replace("%EINGECHECKT%", t('Ja'), $text) : ($text = str_replace("%EINGECHECKT%", t('Nein'), $text));
$user["party_id"] ? $text = str_replace("%ANGEMELDET%", t('Ja'), $text) : ($text = str_replace("%ANGEMELDET%", t('Nein'), $text));
// Mail senden
if ($_POST["toinet"]) {
if ($mail->create_inet_mail($user["firstname"] . " " . $user["name"], $user["email"], $_POST["subject"], $text, $cfg["sys_party_mail"])) {
$success .= $user["firstname"] . " " . $user["name"] . "[" . $user["email"] . "]" . HTML_NEWLINE;
} else {
$fail .= $user["firstname"] . " " . $user["name"] . "[" . $user["email"] . "]" . HTML_NEWLINE;
}
}
if ($_POST["tosys"]) {
$mail->create_sys_mail($user["userid"], $__POST["subject"], $text);
}
}
$db->free_result($users);
if ($_POST["toinet"]) {
$inet_success = t('Die Mail wurde erfolgreich an folgende Benutzer gesendet:') . HTML_NEWLINE . $success . HTML_NEWLINE . HTML_NEWLINE . t('An folgende Benutzer konnte die Mail leider nicht gesendet werden:') . HTML_NEWLINE . $fail . HTML_NEWLINE . HTML_NEWLINE;
}
if ($_POST["tosys"]) {
$sys_success = t('Die Nachrichten an die System-Mailbox wurden erfolgreich versandt');
function Mastercomment($mod, $id, $update_table = array())
{
global $framework, $dsp, $auth, $db, $func, $cfg;
#echo '<ul class="Line">';
$dsp->AddFieldsetStart(t('Kommentare'));
// Delete comments
if ($_GET['mc_step'] == 10) {
include_once 'inc/classes/class_masterdelete.php';
$md = new masterdelete();
$md->LogID = $id;
$md->Delete('comments', 'commentid', $_GET['commentid']);
unset($_GET['commentid']);
}
$CurentURLBase = $framework->get_clean_url_query('base');
$CurentURLBase = str_replace('&mc_step=10', '', $CurentURLBase);
$CurentURLBase = str_replace('&mf_step=2', '', $CurentURLBase);
$CurentURLBase = preg_replace('#&mf_id=[0-9]*#si', '', $CurentURLBase);
$CurentURLBase = preg_replace('#&commentid=[0-9]*#si', '', $CurentURLBase);
// No Order by in this MS, for it collidates with possible other MS on this page
$order_by_tmp = $_GET['order_by'];
$_GET['order_by'] = '';
// List current comments
include_once 'modules/mastersearch2/class_mastersearch2.php';
$ms2 = new mastersearch2('bugtracker');
$ms2->query['from'] = "%prefix%comments AS c\n LEFT JOIN %prefix%user AS u ON c.creatorid = u.userid\n ";
$ms2->query['where'] = "c.relatedto_item = '{$mod}' AND c.relatedto_id = '{$id}'";
$ms2->config['dont_link_first_line'] = 1;
$ms2->AddSelect('UNIX_TIMESTAMP(c.date) AS date');
$ms2->AddSelect('c.creatorid');
$ms2->AddSelect('u.avatar_path');
$ms2->AddSelect('u.signature');
$ms2->AddSelect('u.userid');
$ms2->AddResultField('', 'u.username', 'FetchDataRow', '', 180);
$ms2->AddResultField('', 'c.text', 'FetchPostRow');
$ms2->AddIconField('quote', 'javascript:document.getElementById(\'text\').value += \'[quote]\' + document.getElementById(\'post%id%\').innerHTML + \'[/quote]\'', t('Zitieren'));
$ms2->AddIconField('edit', $CurentURLBase . '&commentid=%id%#dsp_form2', t('Editieren'), 'EditAllowed');
if ($auth['type'] >= 3) {
$ms2->AddIconField('delete', $CurentURLBase . '&mc_step=10&commentid=', t('Löschen'));
}
$ms2->PrintSearch($CurentURLBase, 'c.commentid');
$_GET['order_by'] = $order_by_tmp;
// Add new comments
if ($cfg['mc_only_logged_in'] and !$auth['login']) {
$func->information(t('Bitte loggen dich ein, bevor du einen Kommentar verfasst'), NO_LINK);
} else {
if ($_GET['commentid']) {
$row = $db->qry_first("SELECT creatorid FROM %prefix%comments WHERE commentid = %int%", $_GET['commentid']);
}
if (!$_GET['commentid'] or $row['creatorid'] and $row['creatorid'] == $auth['userid'] or $auth['type'] >= 2) {
include_once 'inc/classes/class_masterform.php';
$mf = new masterform();
$mf->LogID = $id;
$mf->AddField(t('Kommentar'), 'text', '', LSCODE_BIG);
if (!$auth['login']) {
$mf->AddField('', 'captcha', IS_CAPTCHA);
}
$mf->AddFix('relatedto_item', $mod);
$mf->AddFix('relatedto_id', $id);
if (!$_GET['commentid']) {
$mf->AddFix('date', 'NOW()');
}
if (!$_GET['commentid']) {
$mf->AddFix('creatorid', $auth['userid']);
}
if ($mf->SendForm('', 'comments', 'commentid', $_GET['commentid'])) {
// Send email-notifications to thread-subscribers
$path = substr($_SERVER['REQUEST_URI'], 0, strpos($_SERVER['REQUEST_URI'], "index.php"));
include_once "modules/mail/class_mail.php";
$mail = new mail();
if (!$_GET['fid']) {
$_GET['fid'] = $thread['fid'];
}
// Internet-Mail
$subscribers = $db->qry('SELECT b.userid, u.firstname, u.name, u.email FROM %prefix%comments_bookmark AS b
LEFT JOIN %prefix%user AS u ON b.userid = u.userid
WHERE b.email = 1 AND b.relatedto_item = %string% AND b.relatedto_id = %int%', $mod, $id);
while ($subscriber = $db->fetch_array($subscribers)) {
if ($subscriber['userid'] != $auth['userid']) {
$mail->create_inet_mail($subscriber["firstname"] . " " . $subscriber["name"], $subscriber["email"], t('Es gibt einen neuen Kommentar'), str_replace('%URL%', $_SERVER['HTTP_REFERER'], t('Es wurde ein neuer Kommentar in einem Lansuite-Modul geschrieben: %URL%')), $cfg["sys_party_mail"]);
}
}
$db->free_result($subscribers);
// Sys-Mail
$subscribers = $db->qry('SELECT userid FROM %prefix%comments_bookmark AS b
WHERE b.sysemail = 1 AND b.relatedto_item = %string% AND b.relatedto_id = %int%', $mod, $id);
while ($subscriber = $db->fetch_array($subscribers)) {
if ($subscriber['userid'] != $auth['userid']) {
$mail->create_sys_mail($subscriber["userid"], t('Es gibt einen neuen Kommentar'), str_replace('%URL%', $_SERVER['HTTP_REFERER'], t('Es wurde ein neuer Kommentar in einem Lansuite-Modul geschrieben: %URL%')));
}
}
$db->free_result($subscribers);
// Update LastChange in $update_table, if $update_table is set
if ($update_table) {
list($key, $val) = each($update_table);
$db->qry('UPDATE %prefix%' . $key . ' SET changedate=NOW() WHERE ' . $val . ' = %int%', $id);
}
}
} else {
$func->error(t('Du bist nicht berechtigt, diesen Kommentar zu editieren'));
}
}
$dsp->AddFieldsetEnd();
#echo '</ul>';
// Bookmarks and Auto-Mail
if ($auth['login'] and $auth['type'] > 1) {
if ($_GET['set_bm']) {
$db->qry_first('DELETE FROM %prefix%comments_bookmark WHERE relatedto_id = %int% AND relatedto_item = %string%', $id, $mod);
if ($_POST["check_bookmark"]) {
$db->qry('INSERT INTO %prefix%comments_bookmark
SET relatedto_id = %int%, relatedto_item = %string%, userid = %int%, email = %int%, sysemail = %int%', $id, $mod, $auth['userid'], $_POST['check_email'], $_POST['check_sysemail']);
}
}
$bookmark = $db->qry_first('SELECT 1 AS found, email, sysemail FROM %prefix%comments_bookmark WHERE relatedto_id = %int% AND relatedto_item = %string% AND userid = %int%', $id, $mod, $auth['userid']);
if ($bookmark['found']) {
$_POST['check_bookmark'] = 1;
}
if ($bookmark['email']) {
$_POST['check_email'] = 1;
}
if ($bookmark['sysemail']) {
$_POST['check_sysemail'] = 1;
}
$dsp->SetForm($_SERVER['REQUEST_URI'] . '&set_bm=1');
$dsp->AddFieldsetStart(t('Monitoring'));
$additionalHTML = "onclick=\"CheckBoxBoxActivate('email', this.checked)\"";
$dsp->AddCheckBoxRow("check_bookmark", t('Lesezeichen'), t('Diesen Beitrag in meine Lesezeichen aufnehmen<br><i>(Lesezeichen ist Vorraussetzung, um Benachrichtigung per Mail zu abonnieren)</i>'), "", 1, $_POST["check_bookmark"], '', '', $additionalHTML);
$dsp->StartHiddenBox('email', $_POST["check_bookmark"]);
$dsp->AddCheckBoxRow("check_email", t('E-Mail Benachrichtigung'), t('Bei Antworten auf diesen Beitrag eine Internet-Mail an mich senden'), "", 1, $_POST["check_email"]);
$dsp->AddCheckBoxRow("check_sysemail", t('System-E-Mail'), t('Bei Antworten auf diesen Beitrag eine System-Mail an mich senden'), "", 1, $_POST["check_sysemail"]);
if ($bookmark["found"]) {
$dsp->StopHiddenBox();
}
$dsp->AddFormSubmitRow("edit");
if (!$bookmark["found"]) {
$dsp->StopHiddenBox();
}
$dsp->AddFieldsetEnd();
}
}
$tid = $db->insert_id();
// Assign just created post to this new thread
$db->qry("UPDATE %prefix%board_posts SET tid = %int% WHERE pid = %int%", $tid, $pid);
}
// Send email-notifications to thread-subscribers
$path = substr($_SERVER['REQUEST_URI'], 0, strpos($_SERVER['REQUEST_URI'], "index.php"));
include_once "modules/mail/class_mail.php";
$mail = new mail();
if (!$_GET['fid']) {
$_GET['fid'] = $thread['fid'];
}
// Internet-Mail
$subscribers = $db->qry("SELECT b.userid, u.firstname, u.name, u.email FROM %prefix%board_bookmark AS b\n \t\tLEFT JOIN %prefix%user AS u ON b.userid = u.userid\n \t\tWHERE b.email = 1 and (b.tid = %int% or b.fid = %int%)\n \t\t", $tid, $_GET['fid']);
while ($subscriber = $db->fetch_array($subscribers)) {
if ($subscriber['userid'] != $auth['userid']) {
$mail->create_inet_mail($subscriber["firstname"] . " " . $subscriber["name"], $subscriber["email"], $cfg["board_subscribe_subject"], str_replace("%URL%", "http://{$_SERVER['SERVER_NAME']}:{$_SERVER['SERVER_PORT']}{$path}index.php?mod=board&action=thread&tid={$tid}", $cfg["board_subscribe_text"]), $cfg["sys_party_mail"]);
}
}
$db->free_result($subscribers);
// Sys-Mail
$subscribers = $db->qry("SELECT userid FROM %prefix%board_bookmark AS b\n WHERE b.sysemail = 1 and (b.tid = %int% or b.fid = %int%)\n ", $tid, $_GET['fid']);
while ($subscriber = $db->fetch_array($subscribers)) {
if ($subscriber['userid'] != $auth['userid']) {
$mail->create_sys_mail($subscriber["userid"], $cfg["board_subscribe_subject"], str_replace("%URL%", "http://{$_SERVER['SERVER_NAME']}:{$_SERVER['SERVER_PORT']}{$path}index.php?mod=board&action=thread&tid={$tid}", $cfg["board_subscribe_text"]));
}
}
$db->free_result($subscribers);
}
$dsp->AddFieldsetEnd();
}
if ($thread['caption'] != '') {