phpBB Guru - Официальная русская поддержка форума phpBB3

Код: Выделить всё

Could not insert new group

DEBUG MODE

SQL Error : 1054 Unknown column 'group_count' in 'field list'

INSERT INTO phpbb_groups (group_type, group_name, group_description, group_moderator, group_count,group_count_max,group_count_enable, group_single_user) VALUES (0, 'srth', 'srth', 2, '99999999','99999999','', '0')

Line : 410
File : admin_groups.php

Код: Выделить всё

You are not Authorised to do this

Код: Выделить всё

# 
#-----[ OPEN ]------------------------------------------ 
# 
includes/functions_post.php

# 
#-----[ FIND ]------------------------------------------ 
# 
	return;
}

//
// Delete a post/poll

# 
#-----[ BEFORE, ADD ]------------------------------------------ 
# 
	$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);
			}
		}
	}

Код: Выделить всё

# 
#-----[ OPEN ]------------------------------------------ 
# 
includes/usercp_register.php

# 
#-----[ FIND ]------------------------------------------ 
#
$email_template = 'user_welcome'; 
}

# 
#-----[ AFTER, ADD ]------------------------------------------ 
# 
$sql = "SELECT ug.user_id, g.group_id as g_id, g.group_name , u.user_posts, g.group_count 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 ug.user_id is NULL 
         AND g.group_count=0 
         AND g.group_single_user=0 
         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 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 inserting user group, group count', '', __LINE__, __FILE__, $sql); 
   } 
} 

Код: Выделить всё

# 
#-----[ OPEN ]------------------------------------------ 
# 
modcp.php
# 
#-----[ FIND ]------------------------------------------ 
# 
$count_sql = array();

# 
#-----[ AFTER, ADD ]------------------------------------------ 
# 
$user_updated = array();

# 
#-----[ FIND ]------------------------------------------ 
# 
WHERE user_id = " . $row['poster_id'];

# 
#-----[ AFTER, ADD ]------------------------------------------ 
# 
	$user_updated [] = "SELECT ug.user_id, g.group_id as g_id, u.user_posts, g.group_count, g.group_count_max, ".$row['poster_id']." as u_id FROM " . GROUPS_TABLE . " g, ".USERS_TABLE." u
		LEFT JOIN ". USER_GROUP_TABLE." ug ON g.group_id=ug.group_id AND ug.user_id=".$row['poster_id']."
		WHERE u.user_id=".$row['poster_id']."
		AND g.group_single_user=0 
		AND g.group_count_enable=1
		AND g.group_moderator<>".$row['poster_id'];

# 
#-----[ FIND ]------------------------------------------ 
# 
$sql = "SELECT post_id

# 
#-----[ BEFORE, ADD ]------------------------------------------ 
# 
if ( sizeof($user_updated) )
{
	for($i = 0; $i < sizeof($user_updated); $i++)
	{
		if ( !($result = $db->sql_query($user_updated[$i])) )
		{
			message_die(GENERAL_ERROR, 'Error geting users post stat', '', __LINE__, __FILE__, $user_updated[$i]);
		}
		while ($group_data = $db->sql_fetchrow($result))
		{
			$user_already_added = (!empty($group_data['user_id']) || $group_data['u_id']==ANONYMOUS) ? TRUE : FALSE;
			$user_add = ($group_data['group_count'] == $group_data['user_posts'] && $group_data['u_id']!=ANONYMOUS) ? TRUE : FALSE;
			$user_remove = ($group_data['group_count'] > $group_data['user_posts'] && $group_data['u_id']!=ANONYMOUS) ? 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'].", ".$group_data['u_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 autogroup
				$sql = "DELETE FROM " . USER_GROUP_TABLE . "
					WHERE group_id=".$group_data['g_id']." 
					AND user_id=".$group_data['u_id'];
				if ( !($db->sql_query($sql)) )
				{
					message_die(GENERAL_ERROR, 'Could not remove users, group count', '', __LINE__, __FILE__, $sql);
				}
			}
			unset ($group_data);
		}
		$db->sql_freeresult($result);
	}
}

Код: Выделить всё

FROM " . GROUPS_TABLE . " g, ".USERS_TABLE." u

Код: Выделить всё

FROM ".USERS_TABLE." u, " . GROUPS_TABLE . " g

Код: Выделить всё

	<tr> 
	  <td class="row1" width="38%"><span class="gen">{L_GROUP_STATUS}:</span></td>
	  <td class="row2" width="62%"> 
		<input type="radio" name="group_type" value="{S_GROUP_OPEN_TYPE}" {S_GROUP_OPEN_CHECKED} /> {L_GROUP_OPEN} &nbsp;&nbsp;<input type="radio" name="group_type" value="{S_GROUP_CLOSED_TYPE}" {S_GROUP_CLOSED_CHECKED} />	{L_GROUP_CLOSED} &nbsp;&nbsp;<input type="radio" name="group_type" value="{S_GROUP_HIDDEN_TYPE}" {S_GROUP_HIDDEN_CHECKED} />	{L_GROUP_HIDDEN}</td> 
	</tr>
<tr> 
  <td class="row1" width="38%"><span class="gen">{L_GROUP_COUNT}:<br/>{L_GROUP_COUNT_MAX}:</span><br/>
  <span class="gensmall">{L_GROUP_COUNT_EXPLAIN}</span></td>
  <td class="row2" width="62%"><input type="text" class="post" name="group_count" maxlength="12" size="12" value="{GROUP_COUNT}" /><br/><input type="text" 
class="post" name="group_count_max" maxlength="12" size="12" value="{GROUP_COUNT_MAX}" />
	<br/>&nbsp;&nbsp; <span class="gen"></span><input type="checkbox" name="group_count_enable" {GROUP_COUNT_ENABLE_CHECKED} 
>&nbsp;{L_GROUP_COUNT_ENABLE}
	<br/>&nbsp;&nbsp; <input type="checkbox" name="group_count_update" value="0"/>&nbsp;{L_GROUP_COUNT_UPDATE}
	<br/>&nbsp;&nbsp; <input type="checkbox" name="group_count_delete" value="0"/>&nbsp;{L_GROUP_COUNT_DELETE}</span>
  </td>
</tr>

	<!-- BEGIN group_edit -->