phpBB.nl

Code: Selecteer alles

mysql_query("UPDATE phpbb_users SET user_warnings=user_warnings-2 WHERE username = '{$user_row['username']}'");

Code: Selecteer alles

$db->sql_query($sql);

Code: Selecteer alles

<?php
/**
*
* @package phpBB3
* @version $Id: prime_ban_to_group.php,v 1.0.1 2009/07/29 22:06:00 primehalo Exp $
* @copyright (c) 2008-2009 Ken F. Innes IV
* @license http://opensource.org/licenses/gpl-license.php GNU Public License
*
*/

/**
* Make sure this file has not already been included.
*/
if (!defined('PRIME_BAN_TO_GROUP'))
{
	define('PRIME_BAN_TO_GROUP', true);
	define('BANNED_GROUP_NAME', 'Verbannen');		// Group name for permanently banned users
	define('SUSPENDED_GROUP_NAME', 'Verbannen');	// Group name for temporarily banned users

	class prime_ban_to_group
	{
		/**
		* Constructor
		*/
		function prime_ban_to_group($ids = null, $ban_len = 0, $mode = '')
		{
			$this->ban_to_group($ids, $ban_len, $mode);
		}

		/**
		*/
		function ban_to_group($ids = null, $ban_len = 0, $mode = '')
		{
			if ($mode == 'user' || $mode == 'email' || $mode == '')
			{
				if (is_int($ban_len))
				{
					$this->group_users_add(($ban_len ? SUSPENDED_GROUP_NAME : BANNED_GROUP_NAME), $ids);
				}
				else if ($ban_len == 'unban')
				{
					global $db;
					if (empty($ids) || $mode === '') // remove stale bans
					{
						$sql = 'SELECT u.user_id, u.username, b.ban_end'
							 . '	FROM ' . USERS_TABLE . ' u, ' . BANLIST_TABLE . ' b'
							 . '	WHERE ban_end < ' . time()
							 . '		AND ban_end <> 0'
							 . '		AND u.user_type <> ' . USER_IGNORE
							 . '		AND ((u.user_email <> \'\' AND u.user_email = b.ban_email) OR u.user_id = b.ban_userid)';
					}
					else
					{
						$sql = 'SELECT u.user_id, u.username, b.ban_end'
							 . '	FROM ' . USERS_TABLE . ' u, ' . BANLIST_TABLE . ' b'
							 . '	WHERE ' . $db->sql_in_set('b.ban_id', $ids)
							 . '		AND ' . ($mode == 'email' ? 'u.user_email = b.ban_email' : 'u.user_id = b.ban_userid');
					}
					$result = $db->sql_query($sql);
					$ids = array();
					while ($row = $db->sql_fetchrow($result))
					{
						$type = $row['ban_end'] ? SUSPENDED_GROUP_NAME : BANNED_GROUP_NAME;
						$ids[$type][] = $row['user_id'];
						$names[$type][] = $row['username'];
					}
					$db->sql_freeresult($result);
					foreach ($ids as $group_name => $user_ids)
					{
						$this->group_users_del($group_name, $user_ids, $names[$group_name]);
					}
				}
			}
		}

		/**
		*/
		function get_group_data($group_name)
		{
			global $db;

			$sql = 'SELECT * '
			     . ' FROM ' . GROUPS_TABLE . ' '
			     . " WHERE group_name='" . $group_name . "'"
			;
			$result = $db->sql_query($sql);
			$group_data = $db->sql_fetchrow($result);
			$db->sql_freeresult($result);

			return ($group_data);
		}

		/**
		*/
		function group_users_add($group_name, $user_ids, $usernames = false)
		{
			$group_data	= $this->get_group_data($group_name);
			$group_id	= isset($group_data['group_id']) ? $group_data['group_id'] : null;
			if (!empty($group_id) && function_exists('group_user_add'))
			{
				group_user_add($group_id, $user_ids, $usernames, $group_name, true, 0, 0, $group_data);
			}
			return(false);
		}

		/**
		*/
		function group_users_del($group_name, $user_ids, $usernames = false)
		{
			global $db;
			$group_data	= $this->get_group_data($group_name);
			$group_id	= isset($group_data['group_id']) ? $group_data['group_id'] : null;
			if (!empty($group_id) && function_exists('group_user_del'))
			{
				// Get users belonging to the group from which we want them removed (only needed so prevent log entries for removing users that don't even belong to the group)
				$sql = 'SELECT user_id'
				     . ' FROM ' . USER_GROUP_TABLE
				     . ' WHERE group_id = ' . $group_id
				     . ' 	AND ' . $db->sql_in_set('user_id', (array)$user_ids)
				;
				$result = $db->sql_query($sql);
				$user_ids = array(); // clear out the user_ids array
				while ($row = $db->sql_fetchrow($result))
				{
					$user_ids[] = $row['user_id'];
				}
				$db->sql_freeresult($result);
				if (!empty($user_ids))
				{
					remove_default_rank($group_id, $user_ids);
					group_user_del($group_id, $user_ids, $usernames, $group_name, 0, 0, $group_data);
					$sql = "UPDATE phpbb_users SET user_warnings=user_warnings-2 WHERE username = '{$user->data['username']}'";
					$db->sql_query($sql);
				}
			}
			return(false);
		}
	}
}
?>

Code: Selecteer alles

               $sql = "UPDATE phpbb_users SET user_warnings=user_warnings-2 WHERE username = '{$user->data['username']}'";
               $db->sql_query($sql);