phpBB.de

Code: Alles auswählen

hp
<?php

define('IN_PHPBB', true);
// Specify the path to you phpBB3 installation directory.
$phpbb_root_path = (defined('PHPBB_ROOT_PATH')) ? PHPBB_ROOT_PATH : './';
$phpEx = substr(strrchr(__FILE__, '.'), 1);
// The common.php file is required.
include($phpbb_root_path . 'common.' . $phpEx);
include($phpbb_root_path . 'includes/functions_posting.' . $phpEx);

$user->session_begin();
$auth->acl($user->data);
$user->setup();


// check if day is already done
$check_date = Date("Y-m-d");
$sql = "SELECT * FROM rhf_birthday_post WHERE birthday = '$check_date'";

$result = $db->sql_query($sql);

$number =  $db->sql_affectedrows($result);

if ($number != 1) {
	$sql = "INSERT INTO rhf_birthday_post (birthday) VALUES ('$check_date')";

	$result = $db->sql_query($sql);

	// choose a user
	$user_id = 1372;

	// pick a forum to add out post to
	$forum_id = 26;

	$date = date("d.m.Y");
	$now = getdate(time() + $user->timezone + $user->dst - date('Z'));

	$subject = stripslashes("Happy Birthday am $date");

	$sql = "SELECT u.*
		FROM " . USERS_TABLE . " AS u
		WHERE u.user_id <> " . ANONYMOUS . "
		AND u.user_birthday LIKE  '" . $db->sql_escape(sprintf('%2d-%2d-', $now['mday'], $now['mon'])) . "%'
		ORDER BY username";
	$result = $db->sql_query($sql);
	$message_body = "";
	$birthday_count = 0;

	// read users
	while ($row = $db->sql_fetchrow($result)) {
		$user_birthday = $row['user_birthday'];
		$birthday_count++;
		$user_id = $row['user_id'];
		$username = $row['username'];
		$user_avatar = $row['user_avatar'];
		$username_link = append_sid("http://www.rc-heli-fan.org/memberlist.php?mode=viewprofile&u=$user_id");
		if (!empty($user_avatar)) {
			$message_body .= '[img]http://www.rc-heli-fan.org/download/file.php?avatar=' . $user_avatar . '[/img]';
		} else {
			$message_body .= '[img]http://www.rc-heli-fan.org/images/default_avatar.gif[/img]';
		}

		$message_body .= '  [url=' . $username_link . ']' . $username . '[/url]';
		$message_body .= "\n";
	}
	$db->sql_freeresult($result);

	switch ($birthday_count) {
		case 0:
			$message_pre = "Heute hat leider kein Mensch hier Geburtstag.\n\n";
			$message_pre .= "Also los, liebe  Menschen, sorgt daf�r, dass das nicht nochmal passiert :-)";
			break;
		case 1:
			$message_pre = "Heute hat ein lieber Mensch Geburtstag:\n";
			$message_post = "Viel Spass beim Feiern!";
			break;
		default:
			$message_pre = "Heute haben $birthday_count liebe Menschen Geburtstag\n";
			$message_post = "Viel Spass beim Feiern!";
	}


	$message = $message_pre . "\n" . $message_body . "\n" . $message_post;

//	print("subject: $subject<br>");
//	print($message);
//	die();


// note that multibyte support is enabled here
$subject = utf8_normalize_nfc($subject);
$message = utf8_normalize_nfc($message);

// variables to hold the parameters for submit_post
$poll = $uid = $bitfield = $options = '';

generate_text_for_storage($subject, $uid, $bitfield, $options, false, false, false);
generate_text_for_storage($message, $uid, $bitfield, $options, true, true, true);

$data = array(
	'forum_id'		=> $forum_id,
	'icon_id'		=> false,

	'enable_bbcode'		=> true,
	'enable_smilies'	=> true,
	'enable_urls'		=> true,
	'enable_sig'		=> true,

	'from_user_id'		=> 1372,

	'message'		=> $message,
	'message_md5'		=> md5($message),

	'bbcode_bitfield'	=> $bitfield,
	'bbcode_uid'		=> $uid,

	'post_edit_locked'	=> 0,
	'topic_title'		=> $subject,
	'notify_set'		=> false,
	'notify'		=> false,
	'post_time' 		=> 0,
	'forum_name'		=> '',
	'enable_indexing'	=> true,
);

submit_post('post', $subject, 'Mit Raupe am Po', POST_NORMAL, $poll, $data);

}

?>

Code: Alles auswählen

//   print("subject: $subject<br>");
//   print($message);
//   die();

Code: Alles auswählen

CREATE TABLE IF NOT EXISTS `rhf_birthday_post` (
  `birthday` date NOT NULL DEFAULT '0000-00-00'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;