Group x mag niet in map y

CoNiO · Bericht door **CoNiO** » 13 mar 2006, 09:14

Ik ben op zoek waarbij ik een gebruikersgroep zijn rechten kan afnemen voor 1 bepaalde map. Dus wanneer je in groep x zit, krijg je geen toegang meer tot map y. Bestaat deze mod ?

Kan het ook omgekeerd ? Dat wanneer je in de gebruikersgroep 'VIP' zit, dat je dan een map meer te zien krijgt ?

Diablo Gamer · Bericht door **Diablo Gamer** » 13 mar 2006, 09:33

volgens mij kan het met van Auto group van Niels

Code: Selecteer alles

############################################################## 
## MOD Title:          Auto group 
## MOD Author:         Niels < ncr@db9.dk > (Niels Chr. Rød) http://mods.db9.dk 
## MOD Description:    This mod will make it posible to add member
##                     to a user group, depending on there post count 
## MOD Version:        1.2.2
## Compatibility:      2.0.5->2.0.6
## 
## Installation Level: Intermediate
## Installation Time:  10 Minutes (1mn by EasyMOD of Nuttzy)
## Files To Edit:      8
##      groupcp.php
##      modcp.php
##      admin/admin_groups.php
##      include/functions_post.php
##      include/usercp_register.php
##      language/lang_english/lang_admin.php
##      language/lang_english/lang_main.php
##      templates/subSilver/admin/group_edit_body.tpl
##
## Included Files:     2
##      auto_group_db_update.php
##      tool/sync_postcount.php
##
############################################################## 
## For Security Purposes, Please Check: http://www.phpbb.com/mods/ for the 
## latest version of this MOD. Downloading this MOD from other sites could cause malicious code 
## to enter into your phpBB Forum. As such, phpBB will not offer support for MOD's not offered 
## in our MOD-Database, located at: http://www.phpbb.com/mods/ 
############################################################## 
## Author Notes: 
## 
## 1. Full MOD description
## -----------
## This mod will make it posible to add member to a user group,
## depending on there post count. This makes it posible to make a
## group "Everyone" (0 posts) where all members are members by default
## or a group like "Posters" (1 posts) where all users witch have
## posted are a member.
## Now also support MAX post count, so the users will be removed
## if they have more posts than required
##
## 2. EasyMOD
## -----------
## This MOD is compatible and can be installed by EasyMOD
## of Nuttzy (but is not officially EasyMOD Compliant)!
## http://area51.phpbb.com/phpBB22/viewforum.php?sid=&f=15
##
## However, on alpha releases of EM and meanwhile beta or 
## final release some actions are NOT performed.
## You'll have to do them manually !
##
## 2.1 SQL commands are not performed
## -----------
## This MOD need a database update.
## Then, in any case if you install this MOD manually or using
## an alpha release of EM, please copying the *_db_update.php
## in your phpBB root directory, run it with your navigator,
## and then delete it from the phpBB root directory.
##
## Please, do it NOW! Before editing phpBB files by EM or manually!!!
## Otherwise, you may have an error message during your next
## connection.
##
## 2.2 Translation are not managed
## -----------
## Moreover, EM can not already manage actions for any other
## language than English (but language intructions are proceed
## to all installed languages in order to prevent errors).
## So the translations provided with this MOD must be installed
## manually if you need them.
##
## 3. Official last version link
## -----------
## Meanwhile the phpBB group validation and as the MOD is not yet
## in the phpBB MOD database, check this official link for updates...
## http://mods.db9.dk/viewtopic.php?t=115
##
## 4. Installation notes
## -----------
## I have included the optional sync_postcount.php, witch will
## syncronise the users post count. This is only nessesary to
## run this, if you think your users post count are not rigth.
##
############################################################## 
## MOD History: 
## 
##   2003-12-06 - Version 1.2.2
##      - phpBB template & EasyMOD compliance enhancement
## 
##   2003-10-04 - Version 1.2.1.
##        - changed some of the syntax used in the how-to
##
##   2003-08-24 - Version 1.2.0
##      - EM ready for 2.0.6
##
##   ????-??-?? - Version 1.1.9
##      - corrected admin_groups.php, a spell error prevented
##        the user list to show, when add/update users
##
##   ????-??-?? - Version 1.1.8
##      - corrected admin_groups.php, a missing language variable added
##
##   ????-??-?? - Version 1.1.7
##      - corrected a typo in the how-to related to groupcp.php,
##        witch caused a SQL error
##
##   ????-??-?? - Version 1.1.6
##      - bugs in version 1.1.3 corrected (functions_post.php
##        and modcp.php)
##
##   ????-??-?? - Version 1.1.5
##      - changed groupcp.php to prevent SQL error
##
##   ????-??-?? - Version 1.1.4
##      - corrected a bug in modcp.php, witch caused a SQL error
##
##   ????-??-?? - Version 1.1.3
##      - now support maximum number of posts
##
##   ????-??-?? - Version 1.1.2
##      - corrected groupcp.php, to allow re-join of a hidden group
##
##   ????-??-?? - Version 1.1.1
##      - missed some changes into the lang_main.php
##
##   ????-??-?? - Version 1.1.0
##      - if a user have unsubscribed from a autogroup, they are now
##        allowed to re-join "closer/hidden groups" later
##
##   ????-??-?? - Version 1.0.5
##      - typo in the how-to, regarding modcp.php
##
##   ????-??-?? - Version 1.0.4
##      - not include change into modcp.php
##
##   ????-??-?? - Version 1.0.3
##      - the how-to for admin_groups.php was corrected
##
##   ????-??-?? - Version 1.0.2
##      - fixed that guest users was added to autogroups, upon posting
##
##   ????-??-?? - Version 1.0.1
##      - corrected the placement of the code in usercp_register.php
##
##   ????-??-?? - Version 1.0.0
##      - now considerd as final
##
##   ????-??-?? - Version 0.10.2
##      - users are added to "0" groups when register even if "Users
##        automatic added when posting" are disabled
##
##   ????-??-?? - Version 0.10.1
##      - minor change to the language file 
##
##   ????-??-?? - Version 0.10.0
##      - re-written code, now users are true members of user groups,
##        code consider as BETA
##
##   ????-??-?? - Version 0.9.9
##      - minor changes to lang_admin.php
##
##   ????-??-?? - Version 0.9.8
##      - now posible to mass email a auto group
##
##   ????-??-?? - Version 0.9.7
##      - now display the groups members when changing the groups permissions
##
##   ????-??-?? - Version 0.9.6
##      - improved the SQL in auth.php
##
##   ????-??-?? - Version 0.9.5
##      - I had put a "update" find in the script instead of a original code
##
##   ????-??-?? - Version 0.9.4
##      - Important security update, in auth.php
##
##   ????-??-?? - Version 0.9.3
##      - changed the explanation text in group permissions, admin panel
##
##   ????-??-?? - Version 0.9.2
##      - Fixed some typos in the how-to, regarding admin_ug_auth.php,
##        and corrected where groupcp.php are located
##
##   ????-??-?? - Version 0.9.1
##      - cosmetic change, "post group" are now "Auto group"
##
##   ????-??-?? - Version 0.9.0
##      - initial BETA release
##
############################################################## 
## Before Adding This MOD To Your Forum, You Should Back Up All Files Related To This MOD 
##############################################################

CoNiO · Bericht door **CoNiO** » 13 mar 2006, 10:37

hmmm ik heb geen toegang tot die map op dat forum. Ik krijg deze error :

Sorry, but only users granted special access can read topics in this forum.

Raimon · Bericht door **Raimon** » 13 mar 2006, 10:44

Ik heb nergens last van

Deze link is het : http://mods.db9.dk/viewtopic.php?t=115
Succes :thumb:

Diablo Gamer schreef:je moet eerst lid worden dat lukt het wel

Is die al

Diablo Gamer · Bericht door **Diablo Gamer** » 13 mar 2006, 10:44

je moet eerst lid worden dat lukt het wel

brandsrus · Bericht door **brandsrus** » 13 mar 2006, 10:51

En minstens 1 bericht geplaatst te hebben op het forum, omdat je dan kan zien hoe het werkt

CoNiO · Bericht door **CoNiO** » 13 mar 2006, 20:13

ik krijg volgende error:

Error geting users post stat

DEBUG MODE

SQL Error : 1054 Unknown column 'g.group_id' in 'on clause'

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

Line : 514
File : functions_post.php

code daar is:

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);
			}
		}
	}

Bee · Bericht door **Bee** » 14 mar 2006, 09:34

Draai de wijzigingen in het bestand eens terug en probeer het dan opnieuw.

CoNiO · Bericht door **CoNiO** » 14 mar 2006, 13:41

Bee schreef:Draai de wijzigingen in het bestand eens terug en probeer het dan opnieuw.

die code komt rechtstreeks uit die MOD en MOET erin staan om de gebruikers automatisch te laten toevoegen, dus veel nut heeft de MOD niet meer dan als ik die code er gewoon uithaal ...

brandsrus · Bericht door **brandsrus** » 14 mar 2006, 13:56

Code: Selecteer alles

	if ($topic_update_sql != '')
	{
		$sql = "UPDATE " . TOPICS_TABLE . " SET 
			$topic_update_sql 
			WHERE topic_id = $topic_id";
		if (!$db->sql_query($sql))
		{
			message_die(GENERAL_ERROR, 'Error in posting', '', __LINE__, __FILE__, $sql);
		}
	}
	first_last_post_sync($post_id);

	if ($mode != 'poll_delete')
	{
		$sql = "UPDATE " . USERS_TABLE . "
			SET user_posts = user_posts $sign 
			WHERE user_id = $user_id";
		if (!$db->sql_query($sql, END_TRANSACTION))
		{
			message_die(GENERAL_ERROR, 'Error in posting', '', __LINE__, __FILE__, $sql);
		}
	}



	$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);
			}
		}
	}


	return;
}


//
// Delete a post/poll
//
function delete_post($mode, &$post_data, &$message, &$meta, &$forum_id, &$topic_id, &$post_id, &$poll_id)

Heb je hem in deze volgorde in het document geplaatst?

Zo ja, dan vraag ik me af of je de db_update.php die erbij zit uitgevoerd hebt

CoNiO · Bericht door **CoNiO** » 14 mar 2006, 19:33

brandsrus schreef:

Code: Selecteer alles

	if ($topic_update_sql != '')
	{
		$sql = "UPDATE " . TOPICS_TABLE . " SET 
			$topic_update_sql 
			WHERE topic_id = $topic_id";
		if (!$db->sql_query($sql))
		{
			message_die(GENERAL_ERROR, 'Error in posting', '', __LINE__, __FILE__, $sql);
		}
	}
	first_last_post_sync($post_id);

	if ($mode != 'poll_delete')
	{
		$sql = "UPDATE " . USERS_TABLE . "
			SET user_posts = user_posts $sign 
			WHERE user_id = $user_id";
		if (!$db->sql_query($sql, END_TRANSACTION))
		{
			message_die(GENERAL_ERROR, 'Error in posting', '', __LINE__, __FILE__, $sql);
		}
	}



	$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);
			}
		}
	}


	return;
}


//
// Delete a post/poll
//
function delete_post($mode, &$post_data, &$message, &$meta, &$forum_id, &$topic_id, &$post_id, &$poll_id)

Heb je hem in deze volgorde in het document geplaatst?

Zo ja, dan vraag ik me af of je de db_update.php die erbij zit uitgevoerd hebt

db update is gedaan & code staat in de volgorde die men zei in de txt, zoals jij toont dus

en aangezien de fout dit is: SQL Error : 1054 Unknown column 'g.group_id' in 'on clause' -> heeft dit niks te maken met db_update want group_id is de primary key van de groups table dus een standaard phpbb veld in een standaard phpbb table