Kein Email an Gebannte User

[color]

Hi
Ich suche eine Mod der an gebannte User Kein Email sendet.
Kennt jemand so ein Mod, Oder wie man das anders regeln könnte.

MFG

[color]

Ich habe da was gefunden, aber die anleitung verstehe ich nicht ganz.
Es gibts viel von $sql

Code: Alles auswählen

#
#-----[ OPEN ]------------------------------------------
#
admin/admin_mass_email.php
#
#-----[ FIND ]------------------------------------------
#
	$sql
#
#-----[ REPLACE WITH ]------------------------------------------
#
# Replace the whole line with this!

//-- mod : No mass mail to banned members ------------------------------------------------------------
//-- add
	if ( $group_id != -1 )
	{
		$sql = 'SELECT u.user_email FROM ' . USERS_TABLE . ' u, ' . USER_GROUP_TABLE . " ug
			LEFT JOIN " . BANLIST_TABLE . " b ON u.user_id = b.ban_userid
				WHERE ug.group_id = $group_id
				AND ug.user_pending <> " . TRUE . '
				AND u.user_id = ug.user_id
				AND ISNULL( b.ban_userid )';
	}
	else
	{
		$sql = 'SELECT u.user_email FROM ' . USERS_TABLE . " u
			LEFT JOIN " . BANLIST_TABLE . " b ON u.user_id = b.ban_userid
				WHERE ISNULL( b.ban_userid )";
	}
//-- fin mod : No mass mail to banned members --------------------------------------------------------

#
#-----[ SAVE/CLOSE ALL FILES ]------------------------------------------
#
# EoM

Das Mod Heist
##############################################################
## MOD Title: No mass mail to banned members
## MOD Author: eviL3 < evil@phpbbmodders.net > (Igor Wiedler) http://phpbbmodders.net
## MOD Description: Name says it all.
## MOD Version: 1.0.0

[Quaresma7]

Müsste das hier sein :

$sql = ( $group_id != -1 ) ? "SELECT u.user_email FROM " . USERS_TABLE . " u, " . USER_GROUP_TABLE . " ug WHERE ug.group_id = $group_id AND ug.user_pending <> " . TRUE . " AND u.user_id = ug.user_id" : "SELECT user_email FROM " . USERS_TABLE;
if ( !($result = $db->sql_query($sql)) )

bin mir aber nicht zu 100% sicher .

[color]

Hey ging aber schnell Besten dank, Probier das mall aus.

Mfg

[color]

Nö bekomme fehler meldung beim senden

Code: Alles auswählen

Could not select group members

DEBUG MODE

SELECT u.user_email FROM forum_users u LEFT JOIN forum_banlist b ON u.user_id = b.ban_userid WHERE ISNULL( b.ban_userid )

[color]

Ok das müste so aus sehen.

Code: Alles auswählen

#
#-----[ OPEN ]------------------------------------------
#
admin/admin_mass_email.php
#
#-----[ FIND ]------------------------------------------
#
$sql = ( $group_id != -1 ) ? "SELECT u.user_email FROM " . USERS_TABLE . " u, " . USER_GROUP_TABLE . " ug WHERE ug.group_id = $group_id AND ug.user_pending <> " . TRUE . " AND u.user_id = ug.user_id" : "SELECT user_email FROM " . USERS_TABLE; 
#
#-----[ REPLACE WITH ]------------------------------------------
#
# Replace the whole line with this!

//-- mod : No mass mail to banned members ------------------------------------------------------------
//-- add
	if ( $group_id != -1 )
	{
		$sql = 'SELECT u.user_email FROM ' . USERS_TABLE . ' u, ' . USER_GROUP_TABLE . " ug
			LEFT JOIN " . BANLIST_TABLE . " b ON u.user_id = b.ban_userid
				WHERE ug.group_id = $group_id
				AND ug.user_pending <> " . TRUE . '
				AND u.user_id = ug.user_id
				AND ISNULL( b.ban_userid )';
	}
	else
	{
		$sql = 'SELECT u.user_email FROM ' . USERS_TABLE . " u
			LEFT JOIN " . BANLIST_TABLE . " b ON u.user_id = b.ban_userid
				WHERE ISNULL( b.ban_userid )";
	}
//-- fin mod : No mass mail to banned members --------------------------------------------------------

#
#-----[ SAVE/CLOSE ALL FILES ]------------------------------------------
#
# EoM

Jetz funktioniert