1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:
40:
41:
42:
43:
44:
45:
46:
47:
48:
49:
50:
51:
52:
53:
54:
55:
56:
57:
58:
59:
60:
61:
62:
63:
64:
65:
66:
67:
68:
69:
70:
71:
72:
73:
74:
75:
76:
77:
78:
79:
80:
81:
82:
83:
84:
85:
86:
87:
88:
89:
90:
91:
92:
93:
94:
95:
96:
97:
98:
99:
100:
101:
102:
103:
104:
105:
106:
107:
108:
109:
110:
111:
112:
113:
114:
115:
116:
117:
118:
119:
120:
121:
122:
123:
124:
125:
126:
127:
128:
129:
130:
131:
132:
133:
134:
135:
136:
137:
138:
139:
140:
141:
142:
143:
144:
145:
146:
147:
148:
149:
150:
151:
152:
153:
154:
155:
156:
157:
158:
159:
160:
161:
162:
163:
164:
165:
166:
167:
168:
169:
170:
171:
172:
173:
174:
175:
176:
177:
178:
179:
180:
181:
182:
183:
184:
185:
186:
187:
188:
189:
190:
191:
192:
193:
194:
195:
196:
197:
198:
199:
200:
201:
202:
203:
204:
205:
206:
207:
208:
209:
210:
211:
212:
213:
214:
215:
216:
217:
218:
219:
220:
221:
222:
223:
224:
225:
226:
227:
228:
229:
230:
231:
232:
233:
234:
235:
236:
237:
238:
239:
240:
241:
242:
243:
244:
245:
246:
247:
248:
249:
250:
251:
252:
253:
254:
255:
256:
257:
258:
259:
260:
261:
262:
263:
264:
265:
266:
267:
268:
269:
270:
271:
272:
273:
274:
275:
276:
277:
278:
279:
280:
281:
282:
283:
284:
285:
286:
287:
288:
289:
290:
291:
292:
293:
294:
295:
296:
297:
298:
299:
300:
301:
302:
303:
304:
305:
306:
307:
308:
309:
310:
311:
312:
313:
314:
315:
316:
317:
318:
319:
320:
321:
322:
323:
324:
325:
326:
327:
328:
329:
330:
331:
332:
333:
334:
335:
336:
337:
338:
339:
340:
341:
342:
343:
344:
345:
346:
347:
348:
349:
350:
351:
352:
353:
354:
355:
356:
357:
358:
359:
360:
361:
362:
363:
364:
365:
366:
367:
368:
369:
370:
371:
372:
373:
374:
375:
376:
377:
378:
379:
380:
381:
382:
383:
384:
385:
386:
387:
388:
389:
390:
391:
392:
393:
394:
395:
396:
397:
398:
399:
400:
401:
402:
403:
404:
405:
406:
407:
408:
409:
410:
411:
412:
413:
414:
415:
416:
417:
418:
419:
420:
421:
422:
423:
424:
425:
426:
427:
428:
429:
430:
431:
432:
433:
434:
435:
436:
437:
438:
439:
440:
441:
442:
443:
444:
445:
446:
447:
448:
449:
450:
451:
452:
453:
454:
455:
456:
457:
458:
459:
460:
461:
462:
463:
464:
465:
466:
467:
468:
469:
470:
471:
472:
473:
474:
475:
476:
477:
478:
479:
480:
481:
482:
483:
484:
485:
486:
487:
488:
489:
490:
491:
492:
493:
494:
495:
496:
497:
498:
499:
500:
501:
502:
503:
504:
505:
506:
507:
508:
509:
510:
511:
512:
513:
514:
515:
516:
517:
518:
519:
520:
521:
522:
523:
524:
525:
526:
527:
528:
529:
530:
531:
532:
533:
534:
535:
536:
537:
538:
539:
540:
541:
542:
543:
544:
545:
546:
547:
548:
549:
550:
551:
552:
553:
554:
555:
556:
557:
558:
559:
560:
561:
562:
563:
564:
565:
566:
567:
568:
569:
570:
571:
572:
573:
574:
575:
576:
577:
578:
579:
580:
581:
582:
583:
|
<?php
$filename="verwarnung.php";
require("./global.php");
require("./acp/lib/class_parse.php");
require("./acp/lib/ver_conf.inc.php");
$lang->load("VERWARNUNG,START");
$config = loadVerwConfig();
$autoban = $config['autoban'];
$veranz = $config['veranz'];
$teamver = $config['teamver'];
$trennz = stripslashes($config['trennz']);
$vcsov = $config['vcsov'];
$pmov = $config['pmov'];
$senderid = $config['senderid'];
$pm_subject = $config['pm_subject'];
$pm_message = $config['pm_message'];
$vl = $config['vl'];
$deletepm = $config['deletepm'];
$bl = $config['bl'];
$gidvw = $config['gidvw'];
$rddub = $config['rddub'];
delVerw($vl);
delBan($bl);
$userid = $_GET['userid'];
$postid = $_GET['postid'];
$senderid = (empty($senderid)) ? $wbbuserdata['userid'] : $senderid;
// Groupids //
if(!empty($userid) || is_numeric($userid)) {
$groupids = array();
$result = $db->query("SELECT groupid FROM bb".$n."_user2groups WHERE userid = '".$userid."'");
while($row = $db->fetch_array($result)) $groupids[] = $row['groupid'];
}
$groupcombinationid = $wbbuserdata['groupcombinationid'];
$result1 = $db->query("SELECT groupids FROM bb".$n."_groupcombinations WHERE groupcombinationid = '".$groupcombinationid."'");
$row1 = $db->fetch_array($result1);
$groupids1 = explode(",", $row1['groupids']);
// Funktion //
function ver_show() {
global $n, $db, $tpl, $trennz, $lang, $master_board_name, $headinclude, $header, $footer;
$result = $db->query("SELECT * FROM `bb".$n."_verwarnungen` ORDER BY datum DESC");
$j = 1;
while($row = $db->fetch_array($result))
{
unset($ver_show);
$id_n = $row['id_n'];
$name = $row['name'];
$id_v = $row['id_v'];
$verwarn = $row['verwarner'];
$anzahl = $row['anzahl'];
$text = $row['text'];
$sonstiges = $row['sonstiges'];
$postid = $row['postid'];
$threadid = $row['threadid'];
$topic = "<b><a href=\"thread.php?postid=".$postid."#post".$postid."\" target=\"_blank\">".$row['topic']."</a></b>";
$datum = date("j.n.Y - H:i", $row['datum']);
$blocked = ($row['blocked'] == 1) ? $lang->get("LANG_ACP_VERW_YES"): $lang->get("LANG_ACP_VERW_NO");
$id_v = explode($trennz, $id_v);
$verwarn = explode($trennz, $verwarn);
for($i=0; $i < count($id_v); $i++) $ver_show .= ($i == count($id_v) - 1) ? "<a href=\"profile.php?userid=".$id_v[$i]."\" target=\"_blank\">".$verwarn[$i]."</a>" : "<a href=\"profile.php?userid=".$id_v[$i]."\" target=\"_blank\">".$verwarn[$i]."</a>, ";
$class = ($j % 2 == 0) ? "tablea" : "tableb";
eval ("\$verwarnungen .= \"".$tpl->get("verwarnung_bit")."\";");
$j++;
}
eval("\$tpl->output(\"".$tpl->get("verwarnung_show")."\");");
}
function weiterleitung($success) {
global $userid, $postid;
$location = $_SERVER['PHP_SELF']."?userid=".$userid."&postid=".$postid."&success=".$success;
header("Location: ".$location);
}
function parse_pm_message($pm_message)
{
$pmm[] = nl2br($pm_message);
return str_replace("\"","\\\"",implode("",$pmm));
}
function get_topic_info($postid)
{
global $db, $n;
$result = $db->query_first("SELECT p.threadid, t.topic FROM bb".$n."_posts p LEFT JOIN bb".$n."_threads t ON ( p.threadid = t.threadid ) WHERE p.postid = '".$postid."'");
return $result;
}
function make_drop_down()
{
global $db, $n;
$ddm = "<select name=\"grund\">";
$result = $db->query("SELECT text FROM bb".$n."_verwarntexte");
while($row = $db->fetch_array($result))
{
$ddm .= "<option value=\"".$row['text']."\">".$row['text']."</option>";
}
$ddm .= "</select>";
return $ddm;
}
function make_spvw()
{
global $db, $n, $pmov, $lang;
$spvw = "<select name=\"spvw\">";
$s1 = ($pmov == 1) ? "selected": "";
$s2 = ($pmov == 0) ? "selected": "";
$spvw .= "<option value=\"1\" ".$s1.">".$lang->get("LANG_ACP_VERW_YES")."</option>";
$spvw .= "<option value=\"0\" ".$s2.">".$lang->get("LANG_ACP_VERW_NO")."</option>";
$spvw .= "</select>";
return $spvw;
}
$canban = ($wbbuserdata['verw_can_ban']) ? TRUE : FALSE;
$canverw = ($wbbuserdata['verw_can_verw'] || $canban) ? TRUE : FALSE;
// Liste //
$action = $_GET['action'];
if(empty($action) && empty($_GET['userid'])) $action = "show";
if($action == "show")
{
if($wbbuserdata['verw_can_list']) ver_show();
else eval("\$tpl->output(\"".$tpl->get("access_error")."\");");
}
else
{
if($canverw) {
if(!empty($_GET['success'])) $success = $_GET['success'];
if(!empty($userid)) {
$result = $db->query("SELECT * FROM `bb".$n."_verwarnungen` WHERE id_n = '".$userid."'");
$row = $db->fetch_array($result);
$num = $db->num_rows($result);
if($num > 0)
{
$result1 = $db->query("SELECT email, regdate, lastvisit FROM `bb".$n."_users` WHERE userid = '".$userid."'");
$row1 = $db->fetch_array($result1);
$u_userid = $userid;
$u_name = $row['name'];
$u_email = $row1['email'];
$u_regdate = $row1['regdate'];
$u_lastvisit = date("j.n.Y - H:i", $row1['lastvisit']);
$u_blocked = ($row['blocked'] == 1) ? $lang->get("LANG_ACP_VERW_YES"): $lang->get("LANG_ACP_VERW_NO");
$v_anzahl = $row['anzahl'];
$v_text = $row['text'];
$v_sonstiges = $row['sonstiges'];
$v_datum = date("j.n.Y - H:i", $row['datum']);
$v_verwarner = $row['verwarner'];
$v_userid = $row['id_v'];
$v_postid = $row['postid'];
$v_threadid = $row['threadid'];
$v_topic = "<b><a href=\"thread.php?postid=".$v_postid."#post".$v_postid."\" target=\"_blank\">".$row['topic']."</a></b>";
$v_userid = explode($trennz, $v_userid);
$v_verwarner = explode($trennz, $v_verwarner);
for($i=0; $i < count($v_userid); $i++) $ver_show .= ($i == count($v_userid) - 1) ? "<a href=\"profile.php?userid=".$v_userid[$i]."\" target=\"_blank\"><u>".$v_verwarner[$i]."</u></a>" : "<a href=\"profile.php?userid=".$v_userid[$i]."\" target=\"_blank\"><u>".$v_verwarner[$i]."</u></a>, ";
}
else
{
$result1 = $db->query("SELECT username, email, regdate, lastvisit FROM `bb".$n."_users` WHERE userid = '".$userid."'");
$row1 = $db->fetch_array($result1);
$u_userid = $userid;
$u_name = $row1['username'];
$u_email = $row1['email'];
$u_regdate = $row1['regdate'];
$u_lastvisit = date("j.n.Y - H:i", $row1['lastvisit']);
$u_blocked = ($row['blocked'] == 1) ? $lang->get("LANG_ACP_VERW_YES"): $lang->get("LANG_ACP_VERW_NO");
$v_anzahl = 0;
$v_text = "-";
$v_datum = "-";
$v_verwarner = "-";
$v_userid = "-";
$v_postid = "-";
$v_threadid = "-";
$v_topic = "-";
$v_sonstiges = "-";
}
$post = get_topic_info($postid);
$topic = "<b><a href=\"thread.php?postid=".$postid."#post".$postid."\" target=\"_blank\">".$post['topic']."</a></b>";
$bres = $db->query_first("SELECT blocked FROM `bb".$n."_verwarnungen` WHERE id_n = '".$userid."'");
$blocked = $bres['blocked'];
if($canban)
{
if(empty($autoban))
{
$banchechbox = "<tr class=\"secondrow\"><td>".$lang->get("LANG_VERW_BAN_DE")."</td><td><select name=\"bannen\"><option value=\"-\" selected>-</option><option value=\"1\">".$lang->get("LANG_VERW_BAN")."</option><option value=\"0\">".$lang->get("LANG_VERW_DEBAN")."</option></select></td></tr>";
$row = "firstrow";
}
else $row = "secondrow";
}
else $row = "secondrow";
$abschick = "<input type=\"submit\" value=\"+ 1\" name=\"add\"> <input type=\"submit\" value=\"- 1\" name=\"del\" />";
$ddm = make_drop_down();
$spvw = make_spvw();
if(empty($autoban) && $canban) $abschick .= " <input type=\"submit\" name=\"ban\" value=\"".$lang->get("LANG_VERW_BAN")."/".$lang->get("LANG_VERW_DEBAN")."\" />";
elseif (!empty($blocked) && !empty($autoban)) $abschick .= " <input type=\"submit\" name=\"entbann\" value=\"".$lang->get("LANG_VERW_DEBAN")."\" />";
$id_v = $wbbuserdata['userid'];
if(isset($_POST['add']))
{
$text = $_POST['text'];
$vgrund = $_POST['grund'];
$vorher = $_POST['vorher'];
$anzahl = $vorher + 1;
if(!empty($blocked) && !empty($autoban)) $success = $lang->get("LANG_VERW_BAN_ALL");
elseif(!empty($autoban) && $anzahl >= $veranz && empty($blocked))
{
if($userid == $wbbuserdata['userid']) $success = $lang->get("LANG_VERW_BAN_SELF");
elseif($teamver == 2)
{
if(!empty($groupids) && !empty($groupids1))
{
if(($groupids[0] < $groupids1[0]) || ($groupids[0] == $groupids1[0])) $success = $lang->get("LANG_VERW_BAN_ERROR");
elseif($groupids[0] > $groupids1[0])
{
$datum = time();
$postarr = get_topic_info($postid);
$verwarner = $db->query("SELECT id_v, verwarner FROM `bb".$n."_verwarnungen` WHERE id_n = '".$userid."'");
$v_row = $db->fetch_array($verwarner);
$result = $db->query("UPDATE `bb".$n."_users` SET blocked = '1', admincanemail = '0', showemail = '0', usercanemail = '0', receivepm = '0', groupcombinationid = '".$gidvw."', rankid = '".$rddub."' WHERE userid = '".$userid."'");
$result2 = $db->query("SELECT groupids FROM bb".$n."_groupcombinations WHERE groupcombinationid = '".$gidvw."'");
$row = $db->fetch_array($result);
$groupids_b = explode(",", $row['groupids']);
$result = $db->query("DELETE FROM `bb".$n."_user2groups` WHERE userid = '".$userid."'");
foreach($groupids_b as $groupid) $result3 = $db->query("INSERT INTO `bb".$n."_user2groups` VALUES ('".$userid."', '".$groupid."')");
$result1 = $db->query("UPDATE `bb".$n."_verwarnungen` SET blocked = '1', anzahl = '".$anzahl."', id_v = '".$v_row['id_v'].$trennz.$wbbuserdata['userid']."', verwarner = '".$v_row['verwarner'].$trennz.addslashes($wbbuserdata['username'])."', datum = '".$datum."', postid = '".$postid."', threadid = '".$postarr['threadid']."', topic = '".addslashes($postarr['topic'])."' WHERE id_n = '".$userid."'");
if($result && $result1 && $result2) $success = $lang->get("LANG_VERW_BAN_AUTO");
else $success = $lang->get("LANG_VERW_BAN_AUTO_ERROR");
}
}
else echo $lang->get("LANG_VERW_USER_NOT");
}
elseif($teamver == 1)
{
$datum = time();
$postarr = get_topic_info($postid);
$verwarner = $db->query("SELECT id_v, verwarner FROM `bb".$n."_verwarnungen` WHERE id_n = '".$userid."'");
$v_row = $db->fetch_array($verwarner);
$result = $db->query("UPDATE `bb".$n."_users` SET blocked = '1', admincanemail = '0', showemail = '0', usercanemail = '0', receivepm = '0', groupcombinationid = '".$gidvw."', rankid = '".$rddub."' WHERE userid = '".$userid."'");
$result2 = $db->query("SELECT groupids FROM bb".$n."_groupcombinations WHERE groupcombinationid = '".$gidvw."'");
$row = $db->fetch_array($result);
$groupids_b = explode(",", $row['groupids']);
$result = $db->query("DELETE FROM `bb".$n."_user2groups` WHERE userid = '".$userid."'");
foreach($groupids_b as $groupid) $result3 = $db->query("INSERT INTO `bb".$n."_user2groups` VALUES ('".$userid."', '".$groupid."')");
$result1 = $db->query("UPDATE `bb".$n."_verwarnungen` SET blocked = '1', anzahl = '".$anzahl."', id_v = '".$v_row['id_v'].$trennz.$wbbuserdata['userid']."', verwarner = '".$v_row['verwarner'].$trennz.addslashes($wbbuserdata['username'])."', datum = '".$datum."', postid = '".$postid."', threadid = '".$postarr['threadid']."', topic = '".addslashes($postarr['topic'])."' WHERE id_n = '".$userid."'");
if($result && $result1 && $result2) $success = $lang->get("LANG_VERW_BAN_AUTO");
else $success = $lang->get("LANG_VERW_BAN_AUTO_ERROR");
}
}
elseif($anzahl == 0 && $anzahl != "")
{
$result = $db->query("DELETE FROM `bb".$n."_verwarnungen` WHERE id_n = '".$userid."'");
if($result) $success = $lang->get("LANG_VERW_DEL");
else $success = $lang->get("LANG_VERW_DEL_NOT");
}
else
{
if(empty($blocked))
{
if($userid == $wbbuserdata['userid']) $success = $lang->get("LANG_VERW_BAN_SELF");
else
{
if($vorher >= 1)
{
$datum = time();
$postarr = get_topic_info($postid);
$verwarner = $db->query("SELECT id_v, verwarner FROM `bb".$n."_verwarnungen` WHERE id_n = '".$userid."'");
$v_row = $db->fetch_array($verwarner);
$result = $db->query("UPDATE `bb".$n."_verwarnungen` SET anzahl = '".$anzahl."', text = '".addslashes($vgrund)."', sonstiges = '".addslashes($text)."', id_v = '".$v_row['id_v'].$trennz.$wbbuserdata['userid']."', verwarner = '".$v_row['verwarner'].$trennz.addslashes($wbbuserdata['username'])."', datum = '".$datum."', postid = '".$postid."', threadid = '".$postarr['threadid']."', topic = '".addslashes($postarr['topic'])."' WHERE id_n = '".$userid."'");
if($_POST['spvw'] == 1)
{
$result = $db->query_first("SELECT postid, topic FROM `bb".$n."_verwarnungen` WHERE id_n = '".$userid."'");
$thread = "<a href=\"thread.php?postid=".$result['postid']."#post".$result['postid']."\" target=\"_blank\">".$result['topic']."</a>";
$verwarner = $wbbuserdata['username'];
$username = $u_name;
$grund = (!empty($vgrund)) ? "<b>".$vgrund."</b> (".$text.")": "<b>".$text."</b>";
eval ("\$pm_message=(\"".parse_pm_message($pm_message)."\");");
$result = getwbbuserdata($userid);
if($senderid == $wbbuserdata['userid'] && $deletepm == 2) $db->unbuffered_query("INSERT INTO bb".$n."_privatemessage (senderid,recipientid,subject,message,sendtime, allowhtml, deletepm) VALUES ('".$senderid."','".$result['userid']."','".addslashes($pm_subject)."','".addslashes($pm_message)."','".time()."', '1', '".$deletepm."')",1);
else $db->unbuffered_query("INSERT INTO bb".$n."_privatemessage (senderid,recipientid,subject,message,sendtime, allowhtml) VALUES ('".$senderid."','".$result['userid']."','".addslashes($pm_subject)."','".addslashes($pm_message)."','".time()."', '1')",1);
if($result['pmpopup']==1) $db->unbuffered_query("UPDATE `bb".$n."_users` SET pmpopup=2 WHERE userid='".$result[userid]."'",1);
if($result['emailonpm']==1) {
if($result['languagepackid']==$lang->languagepackid) $userlang=$lang;
else {
$userlang=new language(intval($result['languagepackid']));
$userlang->load("OWN,MAIL");
}
$master_board_name_email = getlangvar($o_master_board_name, $userlang, 0);
eval ("\$mail_text = \"".$userlang->get4eval("LANG_MAIL_NEWPM_TEXT")."\";");
eval ("\$mail_subject = \"".$userlang->get4eval("LANG_MAIL_NEWPM_SUBJECT")."\";");
mailer($result['email'],$mail_subject,$mail_text);
}
}
if($result) $success = $lang->get("LANG_VERW_ADD");
else $success = $lang->get("LANG_VERW_ADD_NOT");
}
else
{
$datum = time();
$postarr = get_topic_info($postid);
$oldrank = $db->query_first("SELECT groupcombinationid, rankid FROM `bb".$n."_users` WHERE userid = '".$userid."'");
if($_POST['spvw'] == 1)
{
$result = $db->query_first("SELECT postid, topic FROM `bb".$n."_verwarnungen` WHERE id_n = '".$userid."'");
$thread = "<a href=\"thread.php?postid=".$result['postid']."#post".$result['postid']."\" target=\"_blank\">".$result['topic']."</a>";
$verwarner = $wbbuserdata['username'];
$username = $u_name;
$grund = (!empty($vgrund)) ? "<b>".$vgrund."</b> (".$text.")": "<b>".$text."</b>";
eval ("\$pm_message=(\"".parse_pm_message($pm_message)."\");");
$result = getwbbuserdata($userid);
if($senderid == $wbbuserdata['userid'] && $deletepm == 2) $db->unbuffered_query("INSERT INTO bb".$n."_privatemessage (senderid,recipientid,subject,message,sendtime, allowhtml, deletepm) VALUES ('".$senderid."','".$result['userid']."','".addslashes($pm_subject)."','".addslashes($pm_message)."','".time()."', '1', '".$deletepm."')",1);
else $db->unbuffered_query("INSERT INTO bb".$n."_privatemessage (senderid,recipientid,subject,message,sendtime, allowhtml) VALUES ('".$senderid."','".$result['userid']."','".addslashes($pm_subject)."','".addslashes($pm_message)."','".time()."', '1')",1);
if($result['pmpopup']==1) $db->unbuffered_query("UPDATE `bb".$n."_users` SET pmpopup=2 WHERE userid='".$result[userid]."'",1);
if($result['emailonpm']==1) {
if($result['languagepackid']==$lang->languagepackid) $userlang=$lang;
else {
$userlang=new language(intval($result['languagepackid']));
$userlang->load("OWN,MAIL");
}
$master_board_name_email = getlangvar($o_master_board_name, $userlang, 0);
eval ("\$mail_text = \"".$userlang->get4eval("LANG_MAIL_NEWPM_TEXT")."\";");
eval ("\$mail_subject = \"".$userlang->get4eval("LANG_MAIL_NEWPM_SUBJECT")."\";");
mailer($result['email'],$mail_subject,$mail_text);
}
}
$result = $db->query("INSERT INTO `bb".$n."_verwarnungen` (`name`, `id_n`, `verwarner`, `id_v`, `datum`, `anzahl`, `oldrank`, `oldrankid`, `text`, `sonstiges`, `postid`, `threadid`, `topic`) VALUES ('".addslashes($u_name)."', '".$u_userid."', '".addslashes($wbbuserdata['username'])."', '".$wbbuserdata['userid']."', '".$datum."', '".$anzahl."', '".$oldrank[0]."', '".$oldrank[1]."', '".addslashes($vgrund)."', '".addslashes($text)."', '".$postid."', '".$postarr['threadid']."', '".addslashes($postarr['topic'])."')");
if($result) $success = $lang->get("LANG_VERW_ADD");
else $success = $lang->get("LANG_VERW_ADD_NOT");
}
}
}
else $success = $lang->get("LANG_VERW_IS_BANNED");
}
weiterleitung($success);
}
elseif(isset($_POST['del']))
{
$vorher = $_POST['vorher'];
if($blocked != 1)
{
if($userid == $wbbuserdata['userid']) $success = $lang->get("LANG_VERW_BAN_SELF");
else
{
if($vorher - 1 >= 1)
{
$result = $db->query("SELECT id_v, verwarner FROM `bb".$n."_verwarnungen` WHERE id_n = '".$userid."'");
$arr = $db->fetch_array($result);
$v_arr = explode($trennz, $arr['verwarner']);
$vid_arr = explode($trennz, $arr['id_v']);
$v_count = count($v_arr) - 1;
$vid_count = count($vid_arr) - 1;
unset($v_arr[$v_count]);
unset($vid_arr[$vid_count]);
for($i = 1; $i <= $v_count; $i++) $verwarner .= ($i == $v_count) ? $v_arr[$i-1] : $v_arr[$i-1].$trennz;
for($i = 1; $i <= $vid_count; $i++) $v_id .= ($i == $vid_count) ? $vid_arr[$i-1] : $vid_arr[$i-1].$trennz;
$anzahl = $vorher - 1;
$result1 = $db->query("UPDATE `bb".$n."_verwarnungen` SET anzahl = '".$anzahl."', id_v = '".$v_id."', verwarner = '".$verwarner."' WHERE id_n = '".$userid."'");
if($result1) $success = $lang->get("LANG_VERW_DEL");
else $success = $lang->get("LANG_VERW_DEL_NOT");
}
elseif($vorher - 1 == 0)
{
$result = $db->query("DELETE FROM `bb".$n."_verwarnungen` WHERE id_n = '".$userid."'");
if($result) $success = $lang->get("LANG_VERW_DEL");
else $success = $lang->get("LANG_VERW_DEL_NOT");
}
}
}
else $success = $lang->get("LANG_VERW_IS_BANNED");
weiterleitung($success);
}
elseif(isset($_POST['ban']))
{
$vorher = $_POST['vorher'];
$iit_res = $db->query("SELECT * FROM `bb".$n."_verwarnungen` WHERE id_n = '".$userid."'");
$iit = $db->num_rows($iit_res);
if($userid == $wbbuserdata['userid']) $success = $lang->get("LANG_VERW_BAN_SELF");
else
{
if(empty($autoban) && $_POST['bannen'] != "-" && $canban)
{
if($_POST['bannen'])
{
if($userid == $wbbuserdata['userid']) $success = $lang->get("LANG_VERW_BAN_SELF");
elseif($teamver == 2)
{
if(!empty($groupids) && !empty($groupids1))
{
if(($groupids[0] < $groupids1[0]) || ($groupids[0] == $groupids1[0])) $success = $lang->get("LANG_VERW_BAN_ERROR");
elseif($groupids[0] > $groupids1[0])
{
$datum = time();
$postarr = get_topic_info($postid);
if(empty($vorher) && $iit <= 0)
{
$oldrank = $db->query_first("SELECT groupcombinationid, rankid FROM `bb".$n."_users` WHERE userid = '".$userid."'");
$result1 = $db->query("INSERT INTO `bb".$n."_verwarnungen` (`name`, `id_n`, `verwarner`, `id_v`, `datum`, `anzahl`, `oldrank`, `oldrankid`, `text`, `sonstiges`, `blocked`, `postid`, `threadid`, `topic`) VALUES ('".addslashes($u_name)."', '".$u_userid."', '".addslashes($wbbuserdata['username'])."', '".$wbbuserdata['userid']."', '".$datum."', '".$anzahl."', '".$oldrank[0]."', '".$oldrank[1]."', '-', ,'-', '1', '".$postid."', '".$postarr['threadid']."', '".addslashes($postarr['topic'])."')");
}
else
{
$verwarner = $db->query("SELECT id_v, verwarner FROM `bb".$n."_verwarnungen` WHERE id_n = '".$userid."'");
$v_row = $db->fetch_array($verwarner);
$result1 = $db->query("UPDATE `bb".$n."_verwarnungen` SET blocked = '1', datum = '".$datum."', id_v = '".$v_row['id_v'].$trennz.$wbbuserdata['userid']."', verwarner = '".$v_row['verwarner'].$trennz.addslashes($wbbuserdata['username'])."', postid = '".$postid."', threadid = '".$postarr['threadid']."', topic = '".addslashes($postarr['topic'])."' WHERE id_n = '".$userid."'");
}
$result = $db->query("UPDATE `bb".$n."_users` SET blocked = '1', admincanemail = '0', showemail = '0', usercanemail = '0', receivepm = '0', groupcombinationid = '".$gidvw."', rankid = '".$rddub."' WHERE userid = '".$userid."'");
$result2 = $db->query("SELECT groupids FROM bb".$n."_groupcombinations WHERE groupcombinationid = '".$gidvw."'");
$row = $db->fetch_array($result);
$groupids_b = explode(",", $row['groupids']);
$result = $db->query("DELETE FROM `bb".$n."_user2groups` WHERE userid = '".$userid."'");
foreach($groupids_b as $groupid) $result3 = $db->query("INSERT INTO `bb".$n."_user2groups` VALUES ('".$userid."', '".$groupid."')");
if($result && $result1 && $result2) $success = $lang->get("LANG_VERW_BAN_BAN");
else $success = $lang->get("LANG_VERW_BAN_BAN_ERROR");
}
}
else echo $lang->get("LANG_VERW_USER_NOT");
}
elseif($teamver == 1)
{
$datum = time();
$postarr = get_topic_info($postid);
if($vorher == 0 && $iit <= 0)
{
$oldrank = $db->query_first("SELECT groupcombinationid, rankid FROM `bb".$n."_users` WHERE userid = '".$userid."'");
$result1 = $db->query("INSERT INTO `bb".$n."_verwarnungen` (`name`, `id_n`, `verwarner`, `id_v`, `datum`, `anzahl`, `oldrank`, `oldrankid`, `text`, `sonstiges`, `blocked`, `postid`, `threadid`, `topic`) VALUES ('".addslashes($u_name)."', '".$u_userid."', '".addslashes($wbbuserdata['username'])."', '".$wbbuserdata['userid']."', '".$datum."', '".$anzahl."', '".$oldrank[0]."', '".$oldrank[1]."', '-', '-', '1', '".$postid."', '".$postarr['threadid']."', '".addslashes($postarr['topic'])."')");
}
else
{
$verwarner = $db->query("SELECT id_v, verwarner FROM `bb".$n."_verwarnungen` WHERE id_n = '".$userid."'");
$v_row = $db->fetch_array($verwarner);
$result1 = $db->query("UPDATE `bb".$n."_verwarnungen` SET blocked = '1', datum = '".$datum."', id_v = '".$v_row['id_v'].$trennz.$wbbuserdata['userid']."', verwarner = '".$v_row['verwarner'].$trennz.addslashes($wbbuserdata['username'])."', postid = '".$postid."', threadid = '".$postarr['threadid']."', topic = '".addslashes($postarr['topic'])."' WHERE id_n = '".$userid."'");
}
$result = $db->query("UPDATE `bb".$n."_users` SET blocked = '1', admincanemail = '0', showemail = '0', usercanemail = '0', receivepm = '0', groupcombinationid = '".$gidvw."', rankid = '".$rddub."' WHERE userid = '".$userid."'");
$result2 = $db->query("SELECT groupids FROM bb".$n."_groupcombinations WHERE groupcombinationid = '".$gidvw."'");
$row = $db->fetch_array($result);
$groupids_b = explode(",", $row['groupids']);
$result = $db->query("DELETE FROM `bb".$n."_user2groups` WHERE userid = '".$userid."'");
foreach($groupids_b as $groupid) $result3 = $db->query("INSERT INTO `bb".$n."_user2groups` VALUES ('".$userid."', '".$groupid."')");
if($result && $result1 && $result2) $success = $lang->get("LANG_VERW_BAN_BAN");
else $success = $lang->get("LANG_VERW_BAN_BAN_ERROR");
}
}
else
{
$groupid = $db->query_first("SELECT oldrank, anzahl, oldrankid FROM `bb".$n."_verwarnungen` WHERE id_n = '".$userid."'");
if(empty($groupid[0])) $groupid[0] = 4;
if(empty($groupid[1])) $result1 = $db->query("DELETE FROM `bb".$n."_verwarnungen` WHERE id_n = '".$userid."'");
else
{
$result = $db->query("SELECT id_v, verwarner FROM `bb".$n."_verwarnungen` WHERE id_n = '".$userid."'");
$arr = $db->fetch_array($result);
$v_arr = explode($trennz, $arr['verwarner']);
$vid_arr = explode($trennz, $arr['id_v']);
$v_count = count($v_arr) - 1;
$vid_count = count($vid_arr) - 1;
unset($v_arr[$v_count]);
unset($vid_arr[$vid_count]);
for($i = 1; $i <= $v_count; $i++) $verwarner .= ($i == $v_count) ? $v_arr[$i-1] : $v_arr[$i-1].$trennz;
for($i = 1; $i <= $vid_count; $i++) $v_id .= ($i == $vid_count) ? $vid_arr[$i-1] : $vid_arr[$i-1].$trennz;
$result1 = $db->query("UPDATE `bb".$n."_verwarnungen` SET blocked = '0', id_v = '".$v_id."', verwarner = '".$verwarner."' WHERE id_n = '".$userid."'");
}
$result = $db->query("UPDATE `bb".$n."_users` SET blocked = '0', groupcombinationid = '".$groupid[0]."', rankid = '".$groupid[2]."', admincanemail = '1', showemail = '1', usercanemail = '1', receivepm = '1' WHERE userid = '".$userid."'");
$result2 = $db->query("SELECT groupids FROM bb".$n."_groupcombinations WHERE groupcombinationid = '".$groupid[0]."'");
$row = $db->fetch_array($result);
$groupids_b = explode(",", $row['groupids']);
$result = $db->query("DELETE FROM `bb".$n."_user2groups` WHERE userid = '".$userid."'");
foreach($groupids_b as $groupid) $result3 = $db->query("INSERT INTO `bb".$n."_user2groups` VALUES ('".$userid."', '".$groupid."')");
if($result && $result1 && $result2) $success = $lang->get("LANG_VERW_BAN_DEBAN");
else $success = $lang->get("LANG_VERW_BAN_DEBAN_ERROR");
}
}
}
weiterleitung($success);
}
elseif(isset($_POST['entbann']))
{
$groupid = $db->query_first("SELECT oldrank, oldrankid, anzahl FROM `bb".$n."_verwarnungen` WHERE id_n = '".$userid."'");
$result = $db->query("UPDATE `bb".$n."_users` SET blocked = '0', groupcombinationid = '".$groupid[0]."', rankid = '".$groupid[1]."', admincanemail = '1', showemail = '1', usercanemail = '1', receivepm = '1' WHERE userid = '".$userid."'");
$result2 = $db->query("SELECT groupids FROM bb".$n."_groupcombinations WHERE groupcombinationid = '".$groupid[0]."'");
$row = $db->fetch_array($result);
$groupids_b = explode(",", $row['groupids']);
$result = $db->query("DELETE FROM `bb".$n."_user2groups` WHERE userid = '".$userid."'");
foreach($groupids_b as $groupid) $result3 = $db->query("INSERT INTO `bb".$n."_user2groups` VALUES ('".$userid."', '".$groupid."')");
if(empty($groupid[2])) $result1 = $db->query("DELETE FROM `bb".$n."_verwarnungen` WHERE id_n = '".$userid."'");
else $result1 = $db->query("UPDATE `bb".$n."_verwarnungen` SET blocked = '0' WHERE id_n = '".$userid."'");
if($result && $result1) $success = $lang->get("LANG_VERW_BAN_DEBAN");
else $success = $lang->get("LANG_VERW_BAN_DEBAN_ERROR");
weiterleitung($success);
}
eval("\$tpl->output(\"".$tpl->get("verwarnung")."\");");
}
else eval("\$tpl->output(\"".$tpl->get("access_error")."\");");
}
else eval("\$tpl->output(\"".$tpl->get("access_error")."\");");
}
?>
|