Need Some Help With A PM Function

Posts: 803 Location: Dresden

Thu 24 Mar, 2011 22:38

Subject: 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: [ Show ]

Code: [Download] [Hide] [Select]

<?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 . '[/url]';

					$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 . '[/url]';

					$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 . '[/url]';

				$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);

}

?>

thanks in advance ;)

Profile PM Website ICQ

KugeLSichA

Quote

Posts: 803 Location: Dresden

Sun 27 Mar, 2011 20:38

Subject: 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!

Profile PM Website ICQ

spydie

Quote

Posts: 1796 Location: In the Boxes

Sun 27 Mar, 2011 21:05

Subject: 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

Profile PM Website MSN

Informpro

Quote

Posts: 1110

Mon 28 Mar, 2011 11:31

Subject: 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.

Profile PM

This topic is locked: you cannot edit posts or make replies.

Page 1 of 1

You cannot post new topics
You cannot reply to topics
You cannot edit your posts
You cannot delete your posts
You cannot vote in polls
You cannot attach files
You can download files
You cannot post calendar events

This is a "Lo-Fi" version of our main content. To view the full version with more information, formatting and images, please click here.

Powered by Icy Phoenix based on phpBB
Generation Time: 0.1618s (PHP: 11% SQL: 89%)
SQL queries: 10 - Debug Off - GZIP Enabled

Icy Phoenix

Icy Phoenix - Powering Communities

Need Some Help With A PM Function