Auto Group mod

[Muiter]

Ik heb deze mod getracht te instaleren. Helaas is er iets fout gegaan in functions_post.php

Error geting users post stat

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax near 'WHERE u.user_id= AND g.group_single_user=0 AND g.group_count_enable=1 AND' at line 3

SELECT ug.user_id, g.group_id as g_id, u.user_posts, g.group_count, g.group_count_max FROM phpbb_groups g, phpbb_users u LEFT JOIN phpbb_user_group ug ON g.group_id=ug.group_id AND ug.user_id= WHERE u.user_id= AND g.group_single_user=0 AND g.group_count_enable=1 AND g.group_moderator<>

Line : 488
File : /var/www/html/modelcars/forum/includes/functions_post.php

Ik heb o.a. deze code moeten toevoegen:

Code: Selecteer alles

	$sql = "SELECT ug.user_id, g.group_id as g_id, u.user_posts, g.group_count, g.group_count_max FROM " . GROUPS_TABLE . " g, ".USERS_TABLE." u 
		LEFT JOIN ". USER_GROUP_TABLE." ug ON g.group_id=ug.group_id AND ug.user_id=$user_id
		WHERE u.user_id=$user_id
		AND g.group_single_user=0 
		AND g.group_count_enable=1
		AND g.group_moderator<>$user_id";
	if ( !($result = $db->sql_query($sql)) )
	{
		message_die(GENERAL_ERROR, 'Error geting users post stat', '', __LINE__, __FILE__, $sql);
	}
	while ($group_data = $db->sql_fetchrow($result))
	{
$user_already_added = (empty($group_data['user_id'])) ? FALSE : TRUE; 
$user_add = ($group_data['group_count'] == $group_data['user_posts'] && $user_id!=ANONYMOUS) ? TRUE : FALSE; 
$user_remove = ($group_data['group_count'] > $group_data['user_posts'] || $group_data['group_count_max'] < $group_data['user_posts']) ? TRUE : FALSE;
		if ($user_add && !$user_already_added)
		{
			//user join a autogroup
			$sql = "INSERT INTO " . USER_GROUP_TABLE . " (group_id, user_id, user_pending) 
				VALUES (".$group_data['g_id'].", $user_id, '0')";
			if ( !($db->sql_query($sql)) )
			{
				message_die(GENERAL_ERROR, 'Error insert users, group count', '', __LINE__, __FILE__, $sql);
			}
		} else
		if ( $user_already_added && $user_remove)
		{
			//remove user from auto group
			$sql = "DELETE FROM " . USER_GROUP_TABLE . "
				WHERE group_id=".$group_data['g_id']." 
				AND user_id=$user_id";
			if ( !($db->sql_query($sql)) )
			{
				message_die(GENERAL_ERROR, 'Could not remove users, group count', '', __LINE__, __FILE__, $sql);
			}
		}
	}

Iemand een idee of hier een fout in zit en zo ja welke fout.

[ElbertF]

Heb je de SQL queries uitgevoerd?

[Muiter]

Heb je de SQL queries uitgevoerd?

Ja
De mod werkt ook alleen komt deze foutmelding als er een bericht wordt geplaatst.

Ik had ook dit probleem maar heb dat kunnen oplossen door dat onderwerp.

[Muiter]

Ik kom tot ontdekking dat ik zelf een klein foutje heb gemaakt, het werkt nu wel goed