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:
|
<?PHP
$filename="geburtstag_datei.php";
require ("./global.php");
// Hier die E-Mail-Addy ändern
$meine_email="noreply@b4k.net"; // Hier die E-Mail-Addy ändern
// Hier die E-Mail-Addy ändern
/* ### Newthread an Geburtstag ### */
$tal = $db->query_first("SELECT birthday,lastactivity FROM bb".$n."_users WHERE userid='$wbbuserdata[userid]'");
$monatauslese = substr($tal['birthday'],"5","2");
$tagauslese = substr($tal['birthday'],"8","2");
$vergleichszeit = mktime("23","59","59",$monatauslese,$tagauslese,date("Y"));
if($tal['lastactivity'] > $vergleichszeit) {
$db->unbuffered_query("UPDATE bb".$n."_users SET newthread_geb='0' WHERE userid='$wbbuserdata[userid]'",1);
}
$newthread_geb_aktiv_or_not = $db->query_first("SELECT aktiv FROM bb".$n."_newthread_geb");
if($newthread_geb_aktiv_or_not['aktiv'] == "1") {
$currentdate = formatdate("m-d", time());
$currentyear = intval(formatdate("Y", time()));
$result = $db->query("SELECT userid, username, birthday FROM bb".$n."_users WHERE birthday LIKE '%-$currentdate' AND activation = 1 ORDER BY username ASC");
while($row = $db->fetch_array($result)) {
flush();
sleep(2);
$birthyear = intval(substr($row[birthday], 0, 4));
$age = $currentyear-$birthyear;
if($age<1 || $age>200) $age="";
else $age=" $age";
$user_info_thread = $db->query_first("SELECT * FROM bb".$n."_users WHERE userid = '$row[userid]'");
$newthread_auslesung_TBL = $db->query_first("SELECT * FROM bb".$n."_newthread_geb");
$query1 = "SELECT * from bb".$n."_newthread_geb";
$result1 = mysql_query($query1);
while($row1 = mysql_fetch_array($result1))
{
$message_newthread = $row1[text];
$message_newthread = str_replace("{username}","$user_info_thread[username]",$message_newthread);
$message_newthread = str_replace("{boardname}","$master_board_name",$message_newthread);
$message_newthread = str_replace("{alter}","$age",$message_newthread);
$message_newthread = str_replace(" ","",$message_newthread);
}
$subject_newthread = $newthread_auslesung_TBL[title];
$subject_newthread = str_replace("{username}","$user_info_thread[username]",$subject_newthread);
$subject_newthread = str_replace("{boardname}","$master_board_name",$subject_newthread);
$subject_newthread = str_replace("{alter}","$age",$subject_newthread);
$t_v = $db->query_first("SELECT newthread_geb FROM bb".$n."_users WHERE userid='$row[userid]'");
if($t_v['newthread_geb'] == 0){
$thread_Sende_ID = $newthread_auslesung_TBL[sendnickid];
$sendnickn = $db->query_first("SELECT username FROM bb".$n."_users WHERE userid = '$thread_Sende_ID'");
$thread_Sende_Nick = $sendnickn[username];
$Icon_ID = $newthread_auslesung_TBL[iconid];
$board_ID_thread = $newthread_auslesung_TBL[boardid];
$board_infos = $db->query_first("SELECT * FROM bb".$n."_boards WHERE boardid = '$board_ID_thread'");
$board_thread_count = $board_infos[threadcount];
$board_thread_count = $board_thread_count + 1;
$board_post_count = $board_infos[postcount];
$board_post_count = $board_post_count + 1;
$db->unbuffered_query("INSERT INTO bb".$n."_threads (threadid,boardid,prefix,topic,iconid,starttime,starterid,starter,lastposttime,lastposterid,lastposter,views,closed,voted,votepoints,attachments,pollid,important,visible) VALUES (NULL,'$board_ID_thread','','$subject_newthread','$Icon_ID','".time()."','$thread_Sende_ID','$thread_Sende_Nick','".time()."','$thread_Sende_ID','$thread_Sende_Nick','0','0','0','0','0','0','0','1')");
$Aktuelle_UNIX_Zeit = time();
$Zeit_Auslese = $db->query_first("SELECT * FROM bb".$n."_threads WHERE starttime = '$Aktuelle_UNIX_Zeit'");
$db->unbuffered_query("UPDATE bb".$n."_boards SET threadcount='$board_thread_count', postcount='$board_post_count', lastthreadid='$Zeit_Auslese[threadid]', lastposttime='$Aktuelle_UNIX_Zeit', lastposterid='$thread_Sende_ID', lastposter='$thread_Sende_Nick' WHERE boardid='$board_ID_thread'",1);
$db->unbuffered_query("INSERT INTO bb".$n."_posts (postid,parentpostid,threadid,userid,username,iconid,posttopic, posttime,message,attachmentid,edittime,editorid,editor,editcount,allowsmilies,showsignature,ipaddress,visible,reindex) VALUES (NULL,'0','$Zeit_Auslese[threadid]','$thread_Sende_ID','$thread_Sende_Nick','$Icon_ID','$subject_newthread','".time()."','$message_newthread','0','0','0','','0','1','1','127.0.0.1','1','0')");
$db->unbuffered_query("UPDATE bb".$n."_users SET newthread_geb='1' WHERE userid='$row[userid]'",1);
}
}
$db->fetch_array($result);
}
/* ### Newthread an Geburtstag ### */
/* ### eMail an Geburtstagskinder ### */
$date=date("d");
$row=$db->query_first("SELECT * FROM bb".$n."_email_geb where id='1'");
if($row['datum'] != date("d")){
$email_geb_aktiv_or_not=$db->query_first("SELECT aktiv FROM bb".$n."_email_geb");
if($email_geb_aktiv_or_not['aktiv']=="1"){
$currentdate=formatdate("m-d", time());
$currentyear=intval(formatdate("Y", time()));
$result=$db->query("SELECT userid, username, birthday FROM bb".$n."_users WHERE birthday LIKE '%-$currentdate' AND activation='1' AND year(birthday)>1900");
while($row=$db->fetch_array($result)){
flush();
sleep(2);
$birthyear=intval(substr($row[birthday], 0, 4));
$age=$currentyear-$birthyear;
if($age<1 || $age>200) $age="";
else $age=" $age";
$user_info_thread=$db->query_first("SELECT * FROM bb".$n."_users WHERE userid='$row[userid]'");
$email_auslesung_TBL=$db->query_first("SELECT * FROM bb".$n."_email_geb");
$query1="SELECT * from bb".$n."_email_geb";
$result1=mysql_query($query1);
while($row1=mysql_fetch_array($result1)){
$message_email=$row1[text];
$message_email=str_replace("{username}","$user_info_thread[username]",$message_email);
$message_email=str_replace("{boardname}","$master_board_name",$message_email);
$message_email=str_replace("{alter}","$age",$message_email);
$message_email=str_replace(" ","",$message_email);
}
$subject_email=$email_auslesung_TBL[title];
$subject_email=str_replace("{username}","$user_info_thread[username]",$subject_email);
$subject_email=str_replace("{boardname}","$master_board_name",$subject_email);
$subject_email=str_replace("{alter}","$age",$subject_email);
$subject_email=str_replace("'","",$subject_email);
$thread_Sende_ID=$email_auslesung_TBL[sendnickid];
$sendnickn=$db->query_first("SELECT * FROM bb".$n."_users WHERE userid='$thread_Sende_ID'");
$thread_Sende_Nick=$sendnickn[username];
mailer($user_info_thread['email'],$subject_email,$message_email);
$db->unbuffered_query("UPDATE bb".$n."_email_geb SET datum='$date'");
}
}
}
/* ### eMail an Geburtstagskinder ### */
$mail_subject="GeburtstagsScript ausgeführt";
$mail_text="Hallo Admin\n\nDas GeburtstagsScript wurde ausgeführt.";
mailer($meine_email,$mail_subject,$mail_text);
echo "Script ausgeführt";
?> |