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:
584:
585:
586:
587:
588:
589:
590:
591:
592:
593:
594:
595:
|
<?
//prüfe ob neuer Tag
$row10=$db->query_first("select * from bb".$n."_activ_dele where ikd=1");
$vvf=date("Ydm");$vmf=$row10['datum'];
$anz_users=$row10['users'];
$anz_users++;
$ziel_user=$row10['users_pm'];
$row999=$db->query("update bb".$n."_activ_dele set users='$anz_users' where ikd=1");
//anfangpm
if(($row10[gestartet]<>1 && $anz_users>$ziel_user) or ($vvf!=$vmf && $row10[gestartet]<>1)){
$row3=$db->query_first("SELECT * from bb".$n."_users WHERE userid=3");
$activelang="";
$activelang = new language(intval($row3['languagepackid']));
$activelang->load("MAIL,GLOBAL");
}
if($row10[gestartet]<>1 && $anz_users>$ziel_user){
@error_reporting(7);
@set_time_limit(0);
@set_magic_quotes_runtime(0);
$row90=$db->query("update bb".$n."_activ_dele set gestartet=1,users=0 where ikd=1");
$row222=$db->query_first("select * from bb".$n."_activ_dele where ikd=1");
$max_tage_pm=$row222[max_tage_pm];
$auto_pm=$row222[auto_pm];
$auto_info1 = $row222[auto_info1];
$row4=$db->query_first("SELECT * from bb".$n."_users WHERE userid=3");
if($auto_pm){
$max_pm_time=time()-(86400*$max_tage_pm);$del_pm1="0";
$pmds=$db->query("Select * from bb".$n."_privatemessage where sendtime<$max_pm_time order by sendtime limit 50");
while($del_pm=$db->fetch_array($pmds)){
$del_pm1=$del_pm[privatemessageid];
$del_pm_message=$del_pm[message];
$del_pm_betreff=$del_pm[subject];
$user_del_pm_send=$del_pm[senderid];
$juser_1=$db->query_first("SELECT * from bb".$n."_users WHERE userid='$user_del_pm_send'");
$pmds_1=$db->query("Select * from bb".$n."_privatemessagereceipts where privatemessageid='".$del_pm['privatemessageid']."'");
while($del_pm_1=$db->fetch_array($pmds_1)){
$user_del_pm_empfang=$del_pm_1[recipientid];
$juser_2=$db->query_first("SELECT * from bb".$n."_users WHERE userid='$user_del_pm_empfang'");
$juser_name_1=$juser_1[username];
$juser_name_2=$juser_2[username];
$pm_del_count++;
if($juser_2[pmloesch]&& $del_pm[deletepm]==0){
//mail an User
$mail_text = $activelang->get("LANG_MAIL_DELE_PM_TEXT",array('$juser_name_2' => $juser_name_2,'$juser_name_1' => $juser_name_1,'$del_pm_betreff' => $del_pm_betreff,'$del_pm_message' => $del_pm_message));
$mail_subject = $activelang->get("LANG_MAIL_DELE_PM_SUBJECT");
mailer($juser_2['email'],$mail_subject,$mail_text);
//mail an user ende
}
$db->query("delete from bb".$n."_privatemessagereceipts where privatemessageid=$del_pm1 ");
}
$db->query("delete from bb".$n."_privatemessage where privatemessageid=$del_pm1 ");
}
if($pm_del_count && $auto_info1){
$mail_text = $activelang->get("LANG_MAIL_DELE_ADMIN_PM_TEXT",array('$pm_del_count' => $pm_del_count));
$mail_subject = $activelang->get("LANG_MAIL_DELE_ADMIN_PM_SUBJECT");
mailer($row4['email'],$mail_subject,$mail_text);
}
}
$db->query("update bb".$n."_activ_dele set gestartet=0 where ikd=1");
}
//ende PM
$row10=$db->query_first("select * from bb".$n."_activ_dele where ikd=1");
if($vvf!=$vmf && $row10[gestartet]<>1){
//conifg aus DB holen
@error_reporting(7);
@set_time_limit(0);
@set_magic_quotes_runtime(0);
$row22=$db->query_first("select * from bb".$n."_activ_dele where ikd=1");
$max_tage = $row22[max_tage];
$max_tage_zeit = $row22[max_tage_zeit];
$max_stunde = $row22[max_stunde];
$max_stunde_zeit = $row22[max_stunde_zeit];
$user_nocheck = explode(",",$row22[user_nocheck]);
$auto_akti = $row22[auto_akti];
$auto_noakt = $row22[auto_noakt];
$auto_mail_akti = $row22[auto_mail_akti];
$auto_tage_0post = $row22[auto_tage_0post];
$auto_0post = $row22[auto_0post];
$auto_0post_tage = $row22[auto_0post_tage];
$auto_selbst = $row22[auto_selbst];
$auto_selbst_tage = $row22[auto_selbst_tage];
$auto_info1 = $row22[auto_info1];
$auto_info2 = $row22[auto_info2];
$auto_info3 = $row22[auto_info3];
$auto_info4 = $row22[auto_info4];
$auto_info5 = $row22[auto_info5];
$auto_info6 = $row22[auto_info6];
$row90=$db->query("update bb".$n."_activ_dele set datum='$vvf',gestartet=1 where ikd=1");
//hole Userdaten die sich nicht aktiviert haben
$db->unbuffered_query("UPDATE bb".$n."_users set warnung=0,warnung_art=0 where activation=1 and warnung_art=1");
$user_aktiv=$db->query("Select * from bb".$n."_users where activation<>1");
$maxak=time()-(86400*$max_tage);
$max0post=time()-(86400*$auto_tage_0post);
$row4=$db->query_first("SELECT * from bb".$n."_users WHERE userid=3");
//nicht aktivierte
while($row99=$db->fetch_array($user_aktiv)){
$nowti=time();
$wielang=$nowti-$row99[regdate];
$dele_h1=3600*$max_stunde;
$dele_h2=3600*$max_stunde_zeit;
//prüfe ob länger als xxh nicht aktiviert
if($wielang>$dele_h2 && $row99[warnung]==0 && $row99[warnung_art]==0 && $auto_akti){
//wenn zutrifft dann sende Warnungsemail
//sende email zuerst
$max_stunde_ist=$max_stunde-$max_stunde_zeit;
$mail_text = $activelang->get("LANG_MAIL_WARNUNG_TEXT",array('$row99[username]' => $row99[username],'$url2board' => $url2board,'$max_stunde_ist' => $max_stunde_ist));
$mail_subject = $activelang->get("LANG_MAIL_WARNUNG_SUBJECT");
mailer($row99['email'],$mail_subject,$mail_text);
if($emailverifymode==1 && $auto_mail_akti==1) {
$master_board_name_email = getlangvar($o_master_board_name, $activelang, 0);
$activation=$row99['activation'];
$subject = $activelang->get("LANG_MAIL_AKTIV_EMAIL",array('$row99[username]' => $row99[username],'$master_board_name_email' => $master_board_name_email,'$url2board' => $url2board,'$row99[userid]' => $row99[userid],'$activation' => $activation,'$webmastermail' => $row4[email]));
$content = $activelang->get("LANG_MAIL_AKTIV_EMAIL_TEXT", array('$master_board_name_email' => $master_board_name_email));
mailer($row99['email'],$content,$subject);
}
//informiere Admin über drohende Löschung
if($auto_info6){
$mail_text = $activelang->get("LANG_MAIL_WARNUNG_ADMIN_USER_TEXT",array('$row99[username]' => $row99[username],'$max_stunde_ist' => $max_stunde_ist));
$mail_subject = $activelang->get("LANG_MAIL_WARNUNG_ADMIN_USER_SUBJECT");
mailer($row4['email'],$mail_subject,$mail_text);
}
$db->unbuffered_query("UPDATE bb".$n."_users set warnung=1,warnung_art=1 where userid=$row99[userid]");
} else if($wielang>$dele_h1 && $row99[warnung]==1 && $row99[warnung_art]==1 && $auto_akti){
//Warnung nicht geholfen ? dann Lösche und sende Email
$mail_text = $activelang->get("LANG_MAIL_WARNUNG_DELE_TEXT",array('$row99[username]' => $row99[username],'$url2board' => $url2board));
$mail_subject = $activelang->get("LANG_MAIL_WARNUNG_DELE_SUBJECT");
mailer($row99['email'],$mail_subject,$mail_text);
//informiere Admin über Löschung
if($auto_info6){
$mail_text = $activelang->get("LANG_MAIL_WARNUNG_ADMIN_TEXT",array('$row99[username]' => $row99[username]));
$mail_subject = $activelang->get("LANG_MAIL_WARNUNG_ADMIN_SUBJECT");
mailer($row4['email'],$mail_subject,$mail_text);
}
//löschen
$id_del=$row99[userid];
$db->unbuffered_query("INSERT INTO bb".$n."_active_dele_users set username='".addslashes($row99[username])."',regtime='".$row99[regdate]."',deletime='".time()."',grund='".$activelang->get("LANG_MAIL_FRIEDHOF_ART_1")."'");
$db->unbuffered_query("DELETE FROM bb".$n."_access WHERE userid=$id_del",1);
$result = $db->query("SELECT avatarid, avatarextension FROM bb".$n."_avatars WHERE userid=$id_del");
while($row=$db->fetch_array($result)) @unlink("./../images/avatars/avatar-$row[avatarid].$row[avatarextension]");
$db->unbuffered_query("DELETE FROM bb".$n."_avatars WHERE userid=$id_del",1);
// delete pms sent by these users
$pmids = '';
$result = $db->query("SELECT privatemessageid FROM bb".$n."_privatemessage WHERE senderid=$id_del");
while ($row = $db->fetch_array($result)) $pmids .= (($pmids != '') ? (',') : ('')) . $row['privatemessageid'];
if ($pmids != '') {
$result = $db->query("SELECT attachmentid, attachmentextension, thumbnailextension FROM bb".$n."_attachments WHERE privatemessageid IN ($pmids) AND postid = 0");
while ($row = $db->fetch_array($result)) {
@unlink("./../attachments/attachment-".$row['attachmentid'].".".$row['attachmentextension']);
@unlink("./../attachments/thumbnail-".$row['attachmentid'].".".$row['thumbnailextension']);
}
$db->unbuffered_query("DELETE FROM bb".$n."_attachments WHERE privatemessageid IN ($pmids)", 1);
$db->unbuffered_query("DELETE FROM bb".$n."_privatemessage WHERE privatemessageid IN ($pmids)", 1);
$db->unbuffered_query("DELETE FROM bb".$n."_privatemessagereceipts WHERE privatemessageid IN ($pmids)", 1);
}
// delete pms user ende
// delete pms sent to these users
$db->unbuffered_query("UPDATE bb".$n."_privatemessagereceipts SET deletepm=0 WHERE recipientid =$id_del", 1);
$pmids = '';
$result = $db->query("SELECT privatemessageid FROM bb".$n."_privatemessagereceipts WHERE recipientid=$id_del");
while ($row = $db->fetch_array($result)) $pmids .= ",$row[privatemessageid]";
$deletepmids = '';
$result = $db->query("SELECT ".
"p.privatemessageid, p.inoutbox, COUNT(pmr.privatemessageid) as receipts ".
"FROM bb".$n."_privatemessage p ".
"LEFT OUTER JOIN bb".$n."_privatemessagereceipts pmr ON (pmr.privatemessageid=p.privatemessageid AND pmr.deletepm=0) ".
"WHERE p.privatemessageid IN (0$pmids) ".
"GROUP BY p.privatemessageid");
while ($row = $db->fetch_array($result)) {
if ($row['receipts'] == 0 && $row['inoutbox'] == 0) $deletepmids .= ",$row[privatemessageid]";
}
if ($deletepmids != '') {
$deletepmids = wbb_substr($deletepmids, 1);
$db->unbuffered_query("DELETE FROM bb".$n."_privatemessage WHERE privatemessageid IN (".$deletepmids.")", 1);
$db->unbuffered_query("DELETE FROM bb".$n."_privatemessagereceipts WHERE privatemessageid IN (".$deletepmids.")", 1);
// delete attachments as well
$result = $db->query("SELECT attachmentid, attachmentextension, thumbnailextension FROM bb".$n."_attachments WHERE privatemessageid IN (".$deletepmids.") AND postid = 0");
while ($row = $db->fetch_array($result)) {
@unlink("./../attachments/attachment-".$row['attachmentid'].".".$row['attachmentextension']);
@unlink("./../attachments/thumbnail-".$row['attachmentid'].".".$row['thumbnailextension']);
}
$db->unbuffered_query("DELETE FROM bb".$n."_attachments WHERE privatemessageid IN (".$deletepmids.")", 1);
}
//delete PMs ende gesendet
$db->unbuffered_query("DELETE FROM bb".$n."_events WHERE userid=$id_del",1);
$db->unbuffered_query("DELETE FROM bb".$n."_folders WHERE userid=$id_del",1);
$db->unbuffered_query("DELETE FROM bb".$n."_moderators WHERE userid=$id_del",1);
$db->unbuffered_query("UPDATE bb".$n."_posts SET userid=0 WHERE userid=$id_del",1);
$db->unbuffered_query("DELETE FROM bb".$n."_searchs WHERE userid=$id_del",1);
$db->unbuffered_query("DELETE FROM bb".$n."_subscribeboards WHERE userid=$id_del",1);
$db->unbuffered_query("DELETE FROM bb".$n."_subscribethreads WHERE userid=$id_del",1);
$db->unbuffered_query("UPDATE bb".$n."_threads SET starterid=0 WHERE starterid=$id_del ",1);
$db->unbuffered_query("UPDATE bb".$n."_threads SET lastposterid=0 WHERE lastposterid=$id_del",1);
$db->unbuffered_query("DELETE FROM bb".$n."_userfields WHERE userid=$id_del",1);
$db->unbuffered_query("DELETE FROM bb".$n."_users WHERE userid=$id_del",1);
$db->unbuffered_query("DELETE FROM bb".$n."_votes WHERE userid=$id_del",1);
$db->unbuffered_query("DELETE FROM bb".$n."_user2groups WHERE userid=$id_del",1);
$db->unbuffered_query("DELETE FROM bb".$n."_votes WHERE id=$id_del AND votemode=3",1);
$db->unbuffered_query("DELETE FROM bb".$n."_sessions WHERE userid=$id_del",1);
$db->unbuffered_query("DELETE FROM bb".$n."_acpmenuitemgroupscount WHERE userid=$id_del",1);
$db->unbuffered_query("DELETE FROM bb".$n."_acpmenuitemscount WHERE userid=$id_del",1);
$db->unbuffered_query("DELETE FROM bb".$n."_applications WHERE userid=$id_del",1);
$db->unbuffered_query("DELETE FROM bb".$n."_threadvisit WHERE userid=$id_del",1);
$db->unbuffered_query("DELETE FROM bb".$n."_boardvisit WHERE userid=$id_del",1);
$statupdate=$db->query_first("SELECT COUNT(*) AS usercount, MAX(userid) AS userid FROM bb".$n."_users");
$db->unbuffered_query("UPDATE bb".$n."_stats SET usercount='".$statupdate['usercount']."', lastuserid='".$statupdate['userid']."'",1);
}
//ende while
}
//User die gewarnt werden wegen inaktivität
if($auto_noakt){
$user_inaktiv=$db->query("Select * from bb".$n."_users where lastactivity<$maxak and warnung=0 and warnung_art=0");
$user_dele=$db->query("Select * from bb".$n."_users where lastactivity<$maxak and warnung>=2 and warnung_art=2");
$user_nodele=$db->query("Select * from bb".$n."_users where lastactivity>$maxak and warnung>=2 and warnung_art=2");
while($row99=$db->fetch_array($user_inaktiv)){
if (!in_array($row99[userid], $user_nocheck)){
$mail_text = $activelang->get("LANG_MAIL_WARNUNG_1_TEXT",array('$row99[username]' => $row99[username],'$url2board' => $url2board,'$max_tage' => $max_tage,'$max_tage_zeit' => $max_tage_zeit));
$mail_subject = $activelang->get("LANG_MAIL_WARNUNG_SUBJECT");
mailer($row99['email'],$mail_subject,$mail_text);
//informiere Admin über drohende Löschung
if($auto_info3){
$mail_text = $activelang->get("LANG_MAIL_WARNUNG_ADMIN_USER_1_TEXT",array('$row99[username]' => $row99[username],'$max_tage_zeit' => $max_tage_zeit));
$mail_subject = $activelang->get("LANG_MAIL_WARNUNG_ADMIN_USER_SUBJECT");
mailer($row4['email'],$mail_subject,$mail_text);
}
$xdummy=$max_tage_zeit+2;
$db->unbuffered_query("UPDATE bb".$n."_users set warnung=$xdummy,warnung_art=2 where userid=$row99[userid]");
}
}
while($row99=$db->fetch_array($user_nodele)){
if (!in_array($row99[userid], $user_nocheck)){
$db->unbuffered_query("UPDATE bb".$n."_users set warnung=0,warnung_art=0 where userid=$row99[userid]");
}
}
while($row99=$db->fetch_array($user_dele)){
if (!in_array($row99[userid], $user_nocheck)){
$xdummy=$row99[warnung];
$xdummy=$xdummy-1;
if($xdummy==2){
$mail_text = $activelang->get("LANG_MAIL_WARNUNG_DELE_1_TEXT",array('$row99[username]' => $row99[username],'$url2board' => $url2board));
$mail_subject = $activelang->get("LANG_MAIL_WARNUNG_DELE_SUBJECT");
mailer($row99['email'],$mail_subject,$mail_text);
//informiere Admin über Löschung
if($auto_info3){
$mail_text = $activelang->get("LANG_MAIL_WARNUNG_ADMIN_1_TEXT",array('$row99[username]' => $row99[username]));
$mail_subject = $activelang->get("LANG_MAIL_WARNUNG_ADMIN_SUBJECT");
mailer($row4['email'],$mail_subject,$mail_text);
}
//löschen
$id_del=$row99[userid];
$db->unbuffered_query("INSERT INTO bb".$n."_active_dele_users set username='".addslashes($row99[username])."',regtime='".$row99[regdate]."',deletime='".time()."',grund='".$activelang->get("LANG_MAIL_FRIEDHOF_ART_2")."'");
$db->unbuffered_query("DELETE FROM bb".$n."_access WHERE userid=$id_del",1);
$result = $db->query("SELECT avatarid, avatarextension FROM bb".$n."_avatars WHERE userid=$id_del");
while($row=$db->fetch_array($result)) @unlink("./../images/avatars/avatar-$row[avatarid].$row[avatarextension]");
$db->unbuffered_query("DELETE FROM bb".$n."_avatars WHERE userid=$id_del",1);
// delete pms sent by these users
$pmids = '';
$result = $db->query("SELECT privatemessageid FROM bb".$n."_privatemessage WHERE senderid=$id_del");
while ($row = $db->fetch_array($result)) $pmids .= (($pmids != '') ? (',') : ('')) . $row['privatemessageid'];
if ($pmids != '') {
$result = $db->query("SELECT attachmentid, attachmentextension, thumbnailextension FROM bb".$n."_attachments WHERE privatemessageid IN ($pmids) AND postid = 0");
while ($row = $db->fetch_array($result)) {
@unlink("./../attachments/attachment-".$row['attachmentid'].".".$row['attachmentextension']);
@unlink("./../attachments/thumbnail-".$row['attachmentid'].".".$row['thumbnailextension']);
}
$db->unbuffered_query("DELETE FROM bb".$n."_attachments WHERE privatemessageid IN ($pmids)", 1);
$db->unbuffered_query("DELETE FROM bb".$n."_privatemessage WHERE privatemessageid IN ($pmids)", 1);
$db->unbuffered_query("DELETE FROM bb".$n."_privatemessagereceipts WHERE privatemessageid IN ($pmids)", 1);
}
// delete pms user ende
// delete pms sent to these users
$db->unbuffered_query("UPDATE bb".$n."_privatemessagereceipts SET deletepm=0 WHERE recipientid =$id_del", 1);
$pmids = '';
$result = $db->query("SELECT privatemessageid FROM bb".$n."_privatemessagereceipts WHERE recipientid=$id_del");
while ($row = $db->fetch_array($result)) $pmids .= ",$row[privatemessageid]";
$deletepmids = '';
$result = $db->query("SELECT ".
"p.privatemessageid, p.inoutbox, COUNT(pmr.privatemessageid) as receipts ".
"FROM bb".$n."_privatemessage p ".
"LEFT OUTER JOIN bb".$n."_privatemessagereceipts pmr ON (pmr.privatemessageid=p.privatemessageid AND pmr.deletepm=0) ".
"WHERE p.privatemessageid IN (0$pmids) ".
"GROUP BY p.privatemessageid");
while ($row = $db->fetch_array($result)) {
if ($row['receipts'] == 0 && $row['inoutbox'] == 0) $deletepmids .= ",$row[privatemessageid]";
}
if ($deletepmids != '') {
$deletepmids = wbb_substr($deletepmids, 1);
$db->unbuffered_query("DELETE FROM bb".$n."_privatemessage WHERE privatemessageid IN (".$deletepmids.")", 1);
$db->unbuffered_query("DELETE FROM bb".$n."_privatemessagereceipts WHERE privatemessageid IN (".$deletepmids.")", 1);
// delete attachments as well
$result = $db->query("SELECT attachmentid, attachmentextension, thumbnailextension FROM bb".$n."_attachments WHERE privatemessageid IN (".$deletepmids.") AND postid = 0");
while ($row = $db->fetch_array($result)) {
@unlink("./../attachments/attachment-".$row['attachmentid'].".".$row['attachmentextension']);
@unlink("./../attachments/thumbnail-".$row['attachmentid'].".".$row['thumbnailextension']);
}
$db->unbuffered_query("DELETE FROM bb".$n."_attachments WHERE privatemessageid IN (".$deletepmids.")", 1);
}
//delete PMs ende gesendet
$db->unbuffered_query("DELETE FROM bb".$n."_events WHERE userid=$id_del",1);
$db->unbuffered_query("DELETE FROM bb".$n."_folders WHERE userid=$id_del",1);
$db->unbuffered_query("DELETE FROM bb".$n."_moderators WHERE userid=$id_del",1);
$db->unbuffered_query("UPDATE bb".$n."_posts SET userid=0 WHERE userid=$id_del",1);
$db->unbuffered_query("DELETE FROM bb".$n."_searchs WHERE userid=$id_del",1);
$db->unbuffered_query("DELETE FROM bb".$n."_subscribeboards WHERE userid=$id_del",1);
$db->unbuffered_query("DELETE FROM bb".$n."_subscribethreads WHERE userid=$id_del",1);
$db->unbuffered_query("UPDATE bb".$n."_threads SET starterid=0 WHERE starterid=$id_del ",1);
$db->unbuffered_query("UPDATE bb".$n."_threads SET lastposterid=0 WHERE lastposterid=$id_del",1);
$db->unbuffered_query("DELETE FROM bb".$n."_userfields WHERE userid=$id_del",1);
$db->unbuffered_query("DELETE FROM bb".$n."_users WHERE userid=$id_del",1);
$db->unbuffered_query("DELETE FROM bb".$n."_votes WHERE userid=$id_del",1);
$db->unbuffered_query("DELETE FROM bb".$n."_user2groups WHERE userid=$id_del",1);
$db->unbuffered_query("DELETE FROM bb".$n."_votes WHERE id=$id_del AND votemode=3",1);
$db->unbuffered_query("DELETE FROM bb".$n."_sessions WHERE userid=$id_del",1);
$db->unbuffered_query("DELETE FROM bb".$n."_acpmenuitemgroupscount WHERE userid=$id_del",1);
$db->unbuffered_query("DELETE FROM bb".$n."_acpmenuitemscount WHERE userid=$id_del",1);
$db->unbuffered_query("DELETE FROM bb".$n."_applications WHERE userid=$id_del",1);
$db->unbuffered_query("DELETE FROM bb".$n."_threadvisit WHERE userid=$id_del",1);
$db->unbuffered_query("DELETE FROM bb".$n."_boardvisit WHERE userid=$id_del",1);
$statupdate=$db->query_first("SELECT COUNT(*) AS usercount, MAX(userid) AS userid FROM bb".$n."_users");
$db->unbuffered_query("UPDATE bb".$n."_stats SET usercount='".$statupdate['usercount']."', lastuserid='".$statupdate['userid']."'",1);
} else
{
$db->unbuffered_query("UPDATE bb".$n."_users set warnung=$xdummy where userid=$row99[userid]");
}
}//ende if usercheck
}//ende while löschen
}//ende if auto
//start selbstlöschung
if($auto_selbst){
$user_selbst=$db->query("Select * from bb".$n."_users where warnung_art=0 and selbkill=1");
$user_selbst_count=$db->query("Select * from bb".$n."_users where warnung_art=4 and selbkill=1");
$user_selbst_no=$db->query("Select * from bb".$n."_users where warnung_art=4 and selbkill=0");
while($row99=$db->fetch_array($user_selbst)){
$mail_text = $activelang->get("LANG_MAIL_WARNUNG_3_TEXT",array('$row99[username]' => $row99[username],'$auto_selbst_tage' => $auto_selbst_tage));
$mail_subject = $activelang->get("LANG_MAIL_WARNUNG_SUBJECT_1");
mailer($row99['email'],$mail_subject,$mail_text);
//informiere Admin über drohende Löschung
if($auto_info4){
$mail_text = $activelang->get("LANG_MAIL_WARNUNG_ADMIN_USER_3_TEXT",array('$row99[username]' => $row99[username],'$auto_selbst_tage' => $auto_selbst_tage));
$mail_subject = $activelang->get("LANG_MAIL_WARNUNG_ADMIN_USER_SUBJECT1");
mailer($row4['email'],$mail_subject,$mail_text);
}
$xdummy=$auto_selbst_tage+2;
$db->unbuffered_query("UPDATE bb".$n."_users set warnung=$xdummy,warnung_art=4 where userid=$row99[userid]");
}//ende wihle
while($row99=$db->fetch_array($user_selbst_no)){
$db->unbuffered_query("UPDATE bb".$n."_users set warnung=0,warnung_art=0 where userid=$row99[userid]");
}
while($row99=$db->fetch_array($user_selbst_count)){ //start while
$xdummy=$row99[warnung];
$xdummy=$xdummy-1;
if($xdummy==2){
$mail_text = $activelang->get("LANG_MAIL_WARNUNG_DELE_3_TEXT",array('$row99[username]' => $row99[username],'$url2board' => $url2board));
$mail_subject = $activelang->get("LANG_MAIL_WARNUNG_DELE_SUBJECT");
mailer($row99['email'],$mail_subject,$mail_text);
//informiere Admin über Löschung
if($auto_info4){
$mail_text = $activelang->get("LANG_MAIL_WARNUNG_ADMIN_3_TEXT",array('$row99[username]' => $row99[username]));
$mail_subject = $activelang->get("LANG_MAIL_WARNUNG_ADMIN_SUBJECT");
mailer($row4['email'],$mail_subject,$mail_text);
}
//löschen
$id_del=$row99[userid];
$db->unbuffered_query("INSERT INTO bb".$n."_active_dele_users set username='".addslashes($row99[username])."',regtime='".$row99[regdate]."',deletime='".time()."',grund='".$activelang->get("LANG_MAIL_FRIEDHOF_ART_4")."'");
$db->unbuffered_query("DELETE FROM bb".$n."_access WHERE userid=$id_del",1);
$result = $db->query("SELECT avatarid, avatarextension FROM bb".$n."_avatars WHERE userid=$id_del");
while($row=$db->fetch_array($result)) @unlink("./../images/avatars/avatar-$row[avatarid].$row[avatarextension]");
$db->unbuffered_query("DELETE FROM bb".$n."_avatars WHERE userid=$id_del",1);
// delete pms sent by these users
$pmids = '';
$result = $db->query("SELECT privatemessageid FROM bb".$n."_privatemessage WHERE senderid=$id_del");
while ($row = $db->fetch_array($result)) $pmids .= (($pmids != '') ? (',') : ('')) . $row['privatemessageid'];
if ($pmids != '') {
$result = $db->query("SELECT attachmentid, attachmentextension, thumbnailextension FROM bb".$n."_attachments WHERE privatemessageid IN ($pmids) AND postid = 0");
while ($row = $db->fetch_array($result)) {
@unlink("./../attachments/attachment-".$row['attachmentid'].".".$row['attachmentextension']);
@unlink("./../attachments/thumbnail-".$row['attachmentid'].".".$row['thumbnailextension']);
}
$db->unbuffered_query("DELETE FROM bb".$n."_attachments WHERE privatemessageid IN ($pmids)", 1);
$db->unbuffered_query("DELETE FROM bb".$n."_privatemessage WHERE privatemessageid IN ($pmids)", 1);
$db->unbuffered_query("DELETE FROM bb".$n."_privatemessagereceipts WHERE privatemessageid IN ($pmids)", 1);
}
// delete pms user ende
// delete pms sent to these users
$db->unbuffered_query("UPDATE bb".$n."_privatemessagereceipts SET deletepm=0 WHERE recipientid =$id_del", 1);
$pmids = '';
$result = $db->query("SELECT privatemessageid FROM bb".$n."_privatemessagereceipts WHERE recipientid=$id_del");
while ($row = $db->fetch_array($result)) $pmids .= ",$row[privatemessageid]";
$deletepmids = '';
$result = $db->query("SELECT ".
"p.privatemessageid, p.inoutbox, COUNT(pmr.privatemessageid) as receipts ".
"FROM bb".$n."_privatemessage p ".
"LEFT OUTER JOIN bb".$n."_privatemessagereceipts pmr ON (pmr.privatemessageid=p.privatemessageid AND pmr.deletepm=0) ".
"WHERE p.privatemessageid IN (0$pmids) ".
"GROUP BY p.privatemessageid");
while ($row = $db->fetch_array($result)) {
if ($row['receipts'] == 0 && $row['inoutbox'] == 0) $deletepmids .= ",$row[privatemessageid]";
}
if ($deletepmids != '') {
$deletepmids = wbb_substr($deletepmids, 1);
$db->unbuffered_query("DELETE FROM bb".$n."_privatemessage WHERE privatemessageid IN (".$deletepmids.")", 1);
$db->unbuffered_query("DELETE FROM bb".$n."_privatemessagereceipts WHERE privatemessageid IN (".$deletepmids.")", 1);
// delete attachments as well
$result = $db->query("SELECT attachmentid, attachmentextension, thumbnailextension FROM bb".$n."_attachments WHERE privatemessageid IN (".$deletepmids.") AND postid = 0");
while ($row = $db->fetch_array($result)) {
@unlink("./../attachments/attachment-".$row['attachmentid'].".".$row['attachmentextension']);
@unlink("./../attachments/thumbnail-".$row['attachmentid'].".".$row['thumbnailextension']);
}
$db->unbuffered_query("DELETE FROM bb".$n."_attachments WHERE privatemessageid IN (".$deletepmids.")", 1);
}
//delete PMs ende gesendet
$db->unbuffered_query("DELETE FROM bb".$n."_events WHERE userid=$id_del",1);
$db->unbuffered_query("DELETE FROM bb".$n."_folders WHERE userid=$id_del",1);
$db->unbuffered_query("DELETE FROM bb".$n."_moderators WHERE userid=$id_del",1);
$db->unbuffered_query("UPDATE bb".$n."_posts SET userid=0 WHERE userid=$id_del",1);
$db->unbuffered_query("DELETE FROM bb".$n."_searchs WHERE userid=$id_del",1);
$db->unbuffered_query("DELETE FROM bb".$n."_subscribeboards WHERE userid=$id_del",1);
$db->unbuffered_query("DELETE FROM bb".$n."_subscribethreads WHERE userid=$id_del",1);
$db->unbuffered_query("UPDATE bb".$n."_threads SET starterid=0 WHERE starterid=$id_del ",1);
$db->unbuffered_query("UPDATE bb".$n."_threads SET lastposterid=0 WHERE lastposterid=$id_del",1);
$db->unbuffered_query("DELETE FROM bb".$n."_userfields WHERE userid=$id_del",1);
$db->unbuffered_query("DELETE FROM bb".$n."_users WHERE userid=$id_del",1);
$db->unbuffered_query("DELETE FROM bb".$n."_votes WHERE userid=$id_del",1);
$db->unbuffered_query("DELETE FROM bb".$n."_user2groups WHERE userid=$id_del",1);
$db->unbuffered_query("DELETE FROM bb".$n."_votes WHERE id=$id_del AND votemode=3",1);
$db->unbuffered_query("DELETE FROM bb".$n."_sessions WHERE userid=$id_del",1);
$db->unbuffered_query("DELETE FROM bb".$n."_acpmenuitemgroupscount WHERE userid=$id_del",1);
$db->unbuffered_query("DELETE FROM bb".$n."_acpmenuitemscount WHERE userid=$id_del",1);
$db->unbuffered_query("DELETE FROM bb".$n."_applications WHERE userid=$id_del",1);
$db->unbuffered_query("DELETE FROM bb".$n."_threadvisit WHERE userid=$id_del",1);
$db->unbuffered_query("DELETE FROM bb".$n."_boardvisit WHERE userid=$id_del",1);
$statupdate=$db->query_first("SELECT COUNT(*) AS usercount, MAX(userid) AS userid FROM bb".$n."_users");
$db->unbuffered_query("UPDATE bb".$n."_stats SET usercount='".$statupdate['usercount']."', lastuserid='".$statupdate['userid']."'",1);
} else
{
$db->unbuffered_query("UPDATE bb".$n."_users set warnung=$xdummy where userid=$row99[userid]");
}
}//ende while
}//ende selbstlöschung
//User die gewarnt werden wegen 0Post
if($auto_0post){
$user_0post=$db->query("Select * from bb".$n."_users where regdate<$max0post and warnung=0 and userposts<1 and warnung_art=0");
$user_0post_nodele=$db->query("Select * from bb".$n."_users where regdate<$max0post and warnung>=2 and userposts>=1 and warnung_art=3");
$user_0post_dele=$db->query("Select * from bb".$n."_users where regdate<$max0post and warnung>=2 and userposts<1 and warnung_art=3");
while($row99=$db->fetch_array($user_0post)){
if (!in_array($row99[userid], $user_nocheck)){
$mail_text = $activelang->get("LANG_MAIL_WARNUNG_2_TEXT",array('$row99[username]' => $row99[username],'$url2board' => $url2board,'$auto_tage_0post' => $auto_tage_0post,'$auto_0post_tage' => $auto_0post_tage));
$mail_subject = $activelang->get("LANG_MAIL_WARNUNG_SUBJECT");
mailer($row99['email'],$mail_subject,$mail_text);
//informiere Admin über drohende Löschung
if($auto_info2){
$mail_text = $activelang->get("LANG_MAIL_WARNUNG_ADMIN_USER_2_TEXT",array('$row99[username]' => $row99[username],'$auto_tage_0post' => $auto_tage_0post,'$auto_0post_tage' => $auto_0post_tage));
$mail_subject = $activelang->get("LANG_MAIL_WARNUNG_ADMIN_USER_SUBJECT");
mailer($row4['email'],$mail_subject,$mail_text);
}
$xdummy=$auto_0post_tage+2;
$db->unbuffered_query("UPDATE bb".$n."_users set warnung=$xdummy,warnung_art=3 where userid=$row99[userid]");
}
}
while($row99=$db->fetch_array($user_0post_nodele)){
if (!in_array($row99[userid], $user_nocheck)){
$db->unbuffered_query("UPDATE bb".$n."_users set warnung=0,warnung_art=0 where userid=$row99[userid]");
}
}
while($row99=$db->fetch_array($user_0post_dele)){
if (!in_array($row99[userid], $user_nocheck)){
$xdummy=$row99[warnung];
$xdummy=$xdummy-1;
if($xdummy==2){
$mail_text = $activelang->get("LANG_MAIL_WARNUNG_DELE_2_TEXT",array('$row99[username]' => $row99[username],'$url2board' => $url2board));
$mail_subject = $activelang->get("LANG_MAIL_WARNUNG_DELE_SUBJECT");
mailer($row99['email'],$mail_subject,$mail_text);
//informiere Admin über Löschung
if($auto_info3){
$mail_text = $activelang->get("LANG_MAIL_WARNUNG_ADMIN_2_TEXT",array('$row99[username]' => $row99[username]));
$mail_subject = $activelang->get("LANG_MAIL_WARNUNG_ADMIN_SUBJECT");
mailer($row4['email'],$mail_subject,$mail_text);
}
//löschen
$id_del=$row99[userid];
$db->unbuffered_query("INSERT INTO bb".$n."_active_dele_users set username='".addslashes($row99[username])."',regtime='".$row99[regdate]."',deletime='".time()."',grund='".$activelang->get("LANG_MAIL_FRIEDHOF_ART_3")."'");
$db->unbuffered_query("DELETE FROM bb".$n."_access WHERE userid=$id_del",1);
$result = $db->query("SELECT avatarid, avatarextension FROM bb".$n."_avatars WHERE userid=$id_del");
while($row=$db->fetch_array($result)) @unlink("./../images/avatars/avatar-$row[avatarid].$row[avatarextension]");
$db->unbuffered_query("DELETE FROM bb".$n."_avatars WHERE userid=$id_del",1);
// delete pms sent by these users
$pmids = '';
$result = $db->query("SELECT privatemessageid FROM bb".$n."_privatemessage WHERE senderid=$id_del");
while ($row = $db->fetch_array($result)) $pmids .= (($pmids != '') ? (',') : ('')) . $row['privatemessageid'];
if ($pmids != '') {
$result = $db->query("SELECT attachmentid, attachmentextension, thumbnailextension FROM bb".$n."_attachments WHERE privatemessageid IN ($pmids) AND postid = 0");
while ($row = $db->fetch_array($result)) {
@unlink("./../attachments/attachment-".$row['attachmentid'].".".$row['attachmentextension']);
@unlink("./../attachments/thumbnail-".$row['attachmentid'].".".$row['thumbnailextension']);
}
$db->unbuffered_query("DELETE FROM bb".$n."_attachments WHERE privatemessageid IN ($pmids)", 1);
$db->unbuffered_query("DELETE FROM bb".$n."_privatemessage WHERE privatemessageid IN ($pmids)", 1);
$db->unbuffered_query("DELETE FROM bb".$n."_privatemessagereceipts WHERE privatemessageid IN ($pmids)", 1);
}
// delete pms user ende
// delete pms sent to these users
$db->unbuffered_query("UPDATE bb".$n."_privatemessagereceipts SET deletepm=0 WHERE recipientid =$id_del", 1);
$pmids = '';
$result = $db->query("SELECT privatemessageid FROM bb".$n."_privatemessagereceipts WHERE recipientid=$id_del");
while ($row = $db->fetch_array($result)) $pmids .= ",$row[privatemessageid]";
$deletepmids = '';
$result = $db->query("SELECT ".
"p.privatemessageid, p.inoutbox, COUNT(pmr.privatemessageid) as receipts ".
"FROM bb".$n."_privatemessage p ".
"LEFT OUTER JOIN bb".$n."_privatemessagereceipts pmr ON (pmr.privatemessageid=p.privatemessageid AND pmr.deletepm=0) ".
"WHERE p.privatemessageid IN (0$pmids) ".
"GROUP BY p.privatemessageid");
while ($row = $db->fetch_array($result)) {
if ($row['receipts'] == 0 && $row['inoutbox'] == 0) $deletepmids .= ",$row[privatemessageid]";
}
if ($deletepmids != '') {
$deletepmids = wbb_substr($deletepmids, 1);
$db->unbuffered_query("DELETE FROM bb".$n."_privatemessage WHERE privatemessageid IN (".$deletepmids.")", 1);
$db->unbuffered_query("DELETE FROM bb".$n."_privatemessagereceipts WHERE privatemessageid IN (".$deletepmids.")", 1);
// delete attachments as well
$result = $db->query("SELECT attachmentid, attachmentextension, thumbnailextension FROM bb".$n."_attachments WHERE privatemessageid IN (".$deletepmids.") AND postid = 0");
while ($row = $db->fetch_array($result)) {
@unlink("./../attachments/attachment-".$row['attachmentid'].".".$row['attachmentextension']);
@unlink("./../attachments/thumbnail-".$row['attachmentid'].".".$row['thumbnailextension']);
}
$db->unbuffered_query("DELETE FROM bb".$n."_attachments WHERE privatemessageid IN (".$deletepmids.")", 1);
}
//delete PMs ende gesendet
$db->unbuffered_query("DELETE FROM bb".$n."_events WHERE userid=$id_del",1);
$db->unbuffered_query("DELETE FROM bb".$n."_folders WHERE userid=$id_del",1);
$db->unbuffered_query("DELETE FROM bb".$n."_moderators WHERE userid=$id_del",1);
$db->unbuffered_query("UPDATE bb".$n."_posts SET userid=0 WHERE userid=$id_del",1);
$db->unbuffered_query("DELETE FROM bb".$n."_searchs WHERE userid=$id_del",1);
$db->unbuffered_query("DELETE FROM bb".$n."_subscribeboards WHERE userid=$id_del",1);
$db->unbuffered_query("DELETE FROM bb".$n."_subscribethreads WHERE userid=$id_del",1);
$db->unbuffered_query("UPDATE bb".$n."_threads SET starterid=0 WHERE starterid=$id_del ",1);
$db->unbuffered_query("UPDATE bb".$n."_threads SET lastposterid=0 WHERE lastposterid=$id_del",1);
$db->unbuffered_query("DELETE FROM bb".$n."_userfields WHERE userid=$id_del",1);
$db->unbuffered_query("DELETE FROM bb".$n."_users WHERE userid=$id_del",1);
$db->unbuffered_query("DELETE FROM bb".$n."_votes WHERE userid=$id_del",1);
$db->unbuffered_query("DELETE FROM bb".$n."_user2groups WHERE userid=$id_del",1);
$db->unbuffered_query("DELETE FROM bb".$n."_votes WHERE id=$id_del AND votemode=3",1);
$db->unbuffered_query("DELETE FROM bb".$n."_sessions WHERE userid=$id_del",1);
$db->unbuffered_query("DELETE FROM bb".$n."_acpmenuitemgroupscount WHERE userid=$id_del",1);
$db->unbuffered_query("DELETE FROM bb".$n."_acpmenuitemscount WHERE userid=$id_del",1);
$db->unbuffered_query("DELETE FROM bb".$n."_applications WHERE userid=$id_del",1);
$db->unbuffered_query("DELETE FROM bb".$n."_threadvisit WHERE userid=$id_del",1);
$db->unbuffered_query("DELETE FROM bb".$n."_boardvisit WHERE userid=$id_del",1);
$statupdate=$db->query_first("SELECT COUNT(*) AS usercount, MAX(userid) AS userid FROM bb".$n."_users");
$db->unbuffered_query("UPDATE bb".$n."_stats SET usercount='".$statupdate['usercount']."', lastuserid='".$statupdate['userid']."'",1);
} else
{
$db->unbuffered_query("UPDATE bb".$n."_users set warnung=$xdummy where userid=$row99[userid]");
}
}//ende if usercheck
}
}
//ende if
$db->query("update bb".$n."_activ_dele set gestartet=0 where ikd=1");
}
?> |