http://www.icyphoenix.com/viewtopic.php?f=26&t=7741
-----------------------------------
KugeLSichA
Thu 24 Mar, 2011 22:38

Need Some Help With A PM Function
-----------------------------------
Hey guys...

the following thing is driving me TOTALLY crazy, because i cant solve it...

i have rewritten a free tournament script to fully work with ICY users, functions and so on... all is working fine, as it should... but one small thing not...

the following code is from the tourney start page... if the admin start the tourney, all users should receive a PM with further details... its the first part of the code in the file... (rejected == 0)

and if there is a user with rejected == 1 (the else part) he should get a different PM wich tells him that he cant participate in the tourney...

The problem is... the script is sending all messages corretly for the first part... but not for the one user (and of course there is 1 user) with rejected == 1...

I also commented the first part, to check that there isn´t a problem with the second part... and then the 1 PM for this user is sended correctly...

anyone out here to help me solving this problem?
[spoiler][code linenumbers=false]<?php

// access for headadmins only
if ($user['usertype_headadmin'])
{
	if ($season['status'] == 'running')
	{
		$message = $lang['T_TOURNEY_RUNNING'];
	}
	elseif ($season['status'] == 'finished')
	{
		$message = $lang['T_TOURNEY_FINISHED'];
	}
	elseif ($season['status'] != 'bracket')
	{
		$message = $lang['T_SET_BRACKET_FIRST'];
	}
	else
	{
		// season users-query
		$sql = "SELECT * FROM " . TOURNEY_SEASON_USERS_TABLE . "
				WHERE `id_season` = " . $_REQUEST['season_id'] . "
				AND `usertype_player` = 1";
		if ( !$result = $db->sql_query($sql) )
		{
			message_die(GENERAL_ERROR, 'Could not obtain tourney season users information.', '', __LINE__, __FILE__, $sql);
		}
		$season_users_row = $db->sql_fetchrow($result);

		$script_name = preg_replace('/^\/?(.*?)\/?$/', "\\1", trim($board_config['script_path']));
		$script_name = ($script_name != '') ? $script_name . '/tourney.' . PHP_EXT : 'tourney.' . PHP_EXT;
		$server_name = trim($board_config['server_name']);
		$server_protocol = ($board_config['cookie_secure']) ? 'https://' : 'http://';
		$server_port = ($board_config['server_port'] <> 80) ? ':' . trim($board_config['server_port']) . '/' : '/';
		$url_tourney_adress = $server_protocol . $server_name . $server_port . $script_name . '?season_id=' . $_REQUEST['season_id'];
		// send a mail to all player that signed up
		// if player is not rejected
		if ($season_users_row['rejected'] == 0)
		{
			// This Query is needed to get the player names to pm ...
			$sql2 = "SELECT u1.username AS username_1, u1.user_id AS user_id_1, u1.user_active AS user_active_1, u2.username AS username_2, u2.user_id AS user_id_2, u2.user_active AS user_active_2, m.*
					FROM " . USERS_TABLE . " u1, " . USERS_TABLE . " u2, " . TOURNEY_MATCHES_TABLE . " m
					WHERE m.id_player1 = u1.user_id
						AND m.id_player2 = u2.user_id
						AND m.id_season = " . $_REQUEST['season_id'] . "";
			if (!($result2 = $db->sql_query($sql2)))
			{
				message_die(GENERAL_ERROR, 'Could not query private message post information', '', __LINE__, __FILE__, $sql2);
			}
			$user_n_row = $db->sql_fetchrowset($result2);
			for ($x = 0; $x < count($user_n_row); $x++)
			{
				if ($user_n_row[$x]['user_active_1'])
				{
					$player_id = $user_n_row[$x]['user_id_1'];
					$player_username = $user_n_row[$x]['username_1'];
					$opponent_id = $user_n_row[$x]['user_id_2'];
					$opponent_username = $user_n_row[$x]['username_2'];
					$bracket = $user_n_row[$x]['bracket'];
					$round = $user_n_row[$x]['round'];
					$match = $user_n_row[$x]['match'];

					$round_pre = $round - 1;
					$round_post = $round;
					$sql3 = "SELECT * FROM " . TOURNEY_DEADLINES_TABLE . "
							WHERE `id_season` = '" . $_REQUEST['season_id'] . "'
								AND `round` = '" . $bracket . $round_pre . "'";
					if ( !$result3 = $db->sql_query($sql3) )
					{
						message_die(GENERAL_ERROR, 'Could not obtain tourney deadlines information.', '', __LINE__, __FILE__, $sql3);
					}
					$deadlines_ref1 = $db->sql_numrows($result3);
					if ( $deadlines_row1 = $db->sql_fetchrow($result3) )
					{
						$deadline_pre = create_date($board_config['default_dateformat'], $deadlines_row1['deadline'], $board_config['board_timezone']);
					}
					$sql4 = "SELECT * FROM " . TOURNEY_DEADLINES_TABLE . "
							WHERE `id_season` = '" . $_REQUEST['season_id'] . "'
								AND `round` = '" . $bracket . $round_post . "'";
					if ( !$result4 = $db->sql_query($sql4) )
					{
						message_die(GENERAL_ERROR, 'Could not obtain tourney deadlines information.', '', __LINE__, __FILE__, $sql4);
					}
					$deadlines_ref2 = $db->sql_numrows($result4);
					if ( $deadlines_row2 = $db->sql_fetchrow($result4) )
					{
						$deadline_post = create_date($board_config['default_dateformat'], $deadlines_row2['deadline'], $board_config['board_timezone']);
					}
					$url_tourney = '[url=' . $url_tourney_adress . ']' . $url_tourney_adress . '';
					$pm_subject = $lang['T_MATCH_NOTIFY'] . ' - ' . $section['name'] . ' - ' . $season['name'];
					$pm_text = sprintf($lang['T_MATCH_NOTIFY_TEXT'], $player_username, $bracket, $round, $match, $section['name'], $season['name'], $opponent_username, $deadline_pre, $deadline_post, $url_tourney, ip_stripslashes($board_config['sitename']));

					// PM - BEGIN
					$founder_id = (defined('FOUNDER_ID') ? FOUNDER_ID : get_founder_id());
					include_once(IP_ROOT_PATH . 'includes/class_pm.' . PHP_EXT);
					$privmsg_sender = $founder_id;
					$privmsg_recipient = $player_id;
					$privmsg_subject = $pm_subject;
					$privmsg_message = $pm_text;

					$privmsg = new class_pm();
					$privmsg->send($privmsg_sender, $privmsg_recipient, $privmsg_subject, $privmsg_message);
					unset($privmsg);
					// PM - END
				}

				if ($user_n_row[$x]['user_active_2'])
				{
					$player_id = $user_n_row[$x]['user_id_2'];
					$player_username = $user_n_row[$x]['username_2'];
					$opponent_id = $user_n_row[$x]['user_id_1'];
					$opponent_username = $user_n_row[$x]['username_1'];
					$bracket = $user_n_row[$x]['bracket'];
					$round = $user_n_row[$x]['round'];
					$match = $user_n_row[$x]['match'];

					$round_pre = $round - 1;
					$round_post = $round;
					$sql5 = "SELECT * FROM " . TOURNEY_DEADLINES_TABLE . "
							WHERE `id_season` = '" . $_REQUEST['season_id'] . "'
								AND `round` = '" . $bracket . $round_pre . "'";
					if ( !$result5 = $db->sql_query($sql5) )
					{
						message_die(GENERAL_ERROR, 'Could not obtain tourney deadlines information.', '', __LINE__, __FILE__, $sql5);
					}
					$deadlines_ref1 = $db->sql_numrows($result5);
					if ( $deadlines_row1 = $db->sql_fetchrow($result5) )
					{
						$deadline_pre = create_date($board_config['default_dateformat'], $deadlines_row1['deadline'], $board_config['board_timezone']);
					}
					$sql6 = "SELECT * FROM " . TOURNEY_DEADLINES_TABLE . "
							WHERE `id_season` = '" . $_REQUEST['season_id'] . "'
								AND `round` = '" . $bracket . $round_post . "'";
					if ( !$result6 = $db->sql_query($sql6) )
					{
						message_die(GENERAL_ERROR, 'Could not obtain tourney deadlines information.', '', __LINE__, __FILE__, $sql6);
					}
					$deadlines_ref2 = $db->sql_numrows($result6);
					if ( $deadlines_row2 = $db->sql_fetchrow($result6) )
					{
						$deadline_post = create_date($board_config['default_dateformat'], $deadlines_row2['deadline'], $board_config['board_timezone']);
					}
					$url_tourney = '[url=' . $url_tourney_adress . ']' . $url_tourney_adress . '';
					$pm_subject = $lang['T_MATCH_NOTIFY'] . ' - ' . $section['name'] . ' - ' . $season['name'];
					$pm_text = sprintf($lang['T_MATCH_NOTIFY_TEXT'], $player_username, $bracket, $round, $match, $section['name'], $season['name'], $opponent_username, $deadline_pre, $deadline_post, $url_tourney, ip_stripslashes($board_config['sitename']));

					// PM - BEGIN
					$founder_id = (defined('FOUNDER_ID') ? FOUNDER_ID : get_founder_id());
					include_once(IP_ROOT_PATH . 'includes/class_pm.' . PHP_EXT);
					$privmsg_sender = $founder_id;
					$privmsg_recipient = $player_id;
					$privmsg_subject = $pm_subject;
					$privmsg_message = $pm_text;

					$privmsg = new class_pm();
					$privmsg->send($privmsg_sender, $privmsg_recipient, $privmsg_subject, $privmsg_message);
					unset($privmsg);
					// PM - END
				}
			}
		}
		// send a mail to the players that cant participate
		// if player is rejected
		else
		{
			// This Query is needed to get the player names to pm ...
			$sql7 = "SELECT * FROM " . USERS_TABLE . "
				WHERE user_id = '" . $season_users_row['id_user'] . "'";
			if (!($result7 = $db->sql_query($sql7)))
			{
				message_die(GENERAL_ERROR, 'Could not obtain users information', '', __LINE__, __FILE__, $sql7);
			}
			$user_row = $db->sql_fetchrowset($result7);
			for ($y = 0; $y < count($user_row); $y++)
			{
				$player_id = $user_row[$y]['user_id'];
				$player_username = $user_row[$y]['username'];

				$url_tourney = '[url=' . $url_tourney_adress . ']' . $url_tourney_adress . '';
				$pm_subject = sprintf($lang['T_MATCH_NOTIFY_OUT'], $section['name'], $season['name']);
				$pm_text = sprintf($lang['T_MATCH_NOTIFY_TEXT_OUT'], $player_username, $section['name'], $season['name'], $url_tourney, ip_stripslashes($board_config['sitename']));

				// PM - BEGIN
				$founder_id = (defined('FOUNDER_ID') ? FOUNDER_ID : get_founder_id());
				include_once(IP_ROOT_PATH . 'includes/class_pm.' . PHP_EXT);
				$privmsg_sender = $founder_id;
				$privmsg_recipient = $player_id;
				$privmsg_subject = $pm_subject;
				$privmsg_message = $pm_text;

				$privmsg = new class_pm();
				$privmsg->send($privmsg_sender, $privmsg_recipient, $privmsg_subject, $privmsg_message);
				unset($privmsg);
				// PM - END
			}
		}

		// set season-status to running
		$sql8 = "UPDATE " . TOURNEY_SEASONS_TABLE . "
				SET status = 'running'
				WHERE id = '" . $_REQUEST['season_id'] . "'";
		if( !($result8 = $db->sql_query($sql8)) )
		{
			message_die(GENERAL_ERROR, 'Could not update tourney season users information.', '', __LINE__, __FILE__, $sql8);
		}
		$message = $lang['T_TOURNEY_STARTED'];
	}
	$message .= '<br /><br />' . sprintf($lang['T_CLICK_RETURN_STATUS_VIEW'], '<a href="' . append_sid('tourney.' . PHP_EXT . '?season_id=' . $_REQUEST['season_id']) . '&mod=tourney_status&act=view&opt=">', '</a>');
	message_die(GENERAL_MESSAGE, $message);
}
else
{
	$message = $lang['T_WARNING_NO_ACCESS'] . '<br /><br />' . sprintf($lang['T_CLICK_RETURN_TOURNEY'], '<a href="' . append_sid('tourney.' . PHP_EXT . '?season_id=' . $_REQUEST['season_id']) . '">', '</a>');
	message_die(GENERAL_MESSAGE, $message);
}
?>[/code][/spoiler]

thanks in advance ;)


-----------------------------------
KugeLSichA
Sun 27 Mar, 2011 20:38

Re: Need Some Help With A PM Function
-----------------------------------
can i bump this a bit???

ops i already did  8)  :mricy: 

any PHP MySQL Pro can help me with this please? Thanks!


-----------------------------------
spydie
Sun 27 Mar, 2011 21:05

Re: Need Some Help With A PM Function
-----------------------------------
hm.

or i´m blind or there is´nt ==1 in this script
i only see result($sql7) where ==1 should be


-----------------------------------
Informpro
Mon 28 Mar, 2011 11:31

Re: Need Some Help With A PM Function
-----------------------------------
Hidden Message:
Sorry, but you must be registered and also post a reply to view this message.