Board3_Portal und Group Legend Positioning

[nickvergessen]

Redbull254:
Anstelle von

Code: Alles auswählen

ORDER BY group_legend_pos ASC

wäre

Code: Alles auswählen

ORDER BY g.group_legend_pos ASC

angebracht, um alle Datenbank-System zu unterstützen

[seemann1965]

Hallo,
habe heute Legend Repositioning 1.0.3 installiert, geht prima nur auf der Portalseite nicht, aber durch genannte Seite Fehler behoben.

portal/block/whois_online.php
Suche:

Code: Alles auswählen

{
	$sql = 'SELECT group_id, group_name, group_colour, group_type
		FROM ' . GROUPS_TABLE . '
		WHERE group_legend = 1
		ORDER BY group_name ASC';
}
else
{
	$sql = 'SELECT g.group_id, g.group_name, g.group_colour, g.group_type
		FROM ' . GROUPS_TABLE . ' g
		LEFT JOIN ' . USER_GROUP_TABLE . ' ug
			ON (
				g.group_id = ug.group_id
				AND ug.user_id = ' . $user->data['user_id'] . '
				AND ug.user_pending = 0
			)
		WHERE g.group_legend = 1
			AND (g.group_type <> ' . GROUP_HIDDEN . ' OR ug.user_id = ' . $user->data['user_id'] . ')
		ORDER BY g.group_name ASC';

Ersetzte mit:

Code: Alles auswählen

{
	$sql = 'SELECT group_id, group_name, group_colour, group_type, group_position
		FROM ' . GROUPS_TABLE . '
		WHERE group_legend = 1
		ORDER BY group_position ASC';
}
else
{
	$sql = 'SELECT g.group_id, g.group_name, g.group_colour, g.group_type, g.group_position
		FROM ' . GROUPS_TABLE . ' g
		LEFT JOIN ' . USER_GROUP_TABLE . ' ug
			ON (
				g.group_id = ug.group_id
				AND ug.user_id = ' . $user->data['user_id'] . '
				AND ug.user_pending = 0
			)
		WHERE g.group_legend = 1
			AND (g.group_type <> ' . GROUP_HIDDEN . ' OR ug.user_id = ' . $user->data['user_id'] . ')
		ORDER BY g.group_position ASC';

Nun gehts.

Gruß seemann