phpBB.de

Code: Alles auswählen

#
#-----[ FIND ]------------------------------------------
#
	$sql = "SELECT * FROM " . RANKS_TABLE . "
		ORDER BY rank_min, rank_title";
#
#-----[ REPLACE WITH ]------------------------------------------
#
	$sql = "SELECT r.*, g.group_name
		FROM " . RANKS_TABLE . " r
			LEFT JOIN " . GROUPS_TABLE . " g ON g.group_id = r.rank_group
		ORDER BY r.rank_special DESC, rank_group ASC, r.rank_min ASC"; // ADDED 'r.' AND ', g.group_name' AND 'r LEFT JOIN " . GROUPS_TABLE . " g ON g.group_id = r.rank_group' AND 'rank_group ASC, ' BY Group Rank Hack
#
#-----[ FIND ]------------------------------------------
#
		"L_SPECIAL_RANK" => $lang['Special_rank'],
#
#-----[ REPLACE WITH ]------------------------------------------
#
		"L_SPECIAL_RANK" => $lang['Group_Rank_special'], // ADDED 'Group_' BY Group Rank Hack
#
#-----[ FIND ]------------------------------------------
#
		$rank_is_special = ( $special_rank ) ? $lang['Yes'] : $lang['No'];
#
#-----[ REPLACE WITH ]------------------------------------------
#
		$rank_is_special = ( $special_rank ) ? $lang['Yes'] : ( $rank_rows[$i]['rank_group'] > 0 ? $rank_rows[$i]['group_name'] : $lang['No'] );   // ADDED  '( $rank_rows[$i]['rank_title'] > 0 ? $rank_rows[$i]['group_name'] :' AND ')' BY Group Rank Hack
#
#-------------------------------------------------------

Code: Alles auswählen

#-----[ OPEN ]------------------------------------------
#
/admin/admin_groups.php
#
#-----[ FIND ]------------------------------------------
#
		else if( $mode == 'newgroup' )
		{
#
#-----[ AFTER, ADD ]------------------------------------------
#
			// BEGIN Group Rank Hack
			$sql = "SELECT MAX(group_order) AS max_order
				FROM " . GROUPS_TABLE . "
				WHERE group_single_user = 0";
			if ( !($result = $db->sql_query($sql)) )
			{
				message_die(GENERAL_ERROR, 'Could not insert new group', '', __LINE__, __FILE__, $sql);
			}
			$group_order = $db->sql_fetchrow($result);
			$group_order = $group_order['max_order'] + 1;
			// END Group Rank Hack
#-----[ FIND ]------------------------------------------
#
			$sql = "INSERT INTO " . GROUPS_TABLE . " (group_type, group_name, group_description, group_moderator, group_single_user)
				VALUES ($group_type, '" . str_replace("\'", "''", $group_name) . "', '" . str_replace("\'", "''", $group_description) . "', $group_moderator,	'0')";
#
#-----[ IN-LINE, FIND ]------------------------------------------
#
group_single_user
#
#-----[ IN-LINE, AFTER, ADD ]------------------------------------------
#
, group_order
#
#-----[ IN-LINE, FIND ]------------------------------------------
#
'0'
#
#-----[ IN-LINE, AFTER, ADD ]------------------------------------------
#
, $group_order
#
#-----[ AFTER, ADD ]------------------------------------------
#
// ADDED ', group_order' AND ', $group_order' BY Group Rank Hack
#