Group x mag niet in map y
Forumregels
Sinds 1 januari 2009 wordt phpBB2 niet meer ondersteund.
Onderstaande informatie is verouderd en dient uitsluitend als archief.
Sinds 1 januari 2009 wordt phpBB2 niet meer ondersteund.
Onderstaande informatie is verouderd en dient uitsluitend als archief.

Group x mag niet in map y
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 ?
Kan het ook omgekeerd ? Dat wanneer je in de gebruikersgroep 'VIP' zit, dat je dan een map meer te zien krijgt ?
- Diablo Gamer
- Berichten: 1394
- Lid geworden op: 02 jan 2004, 20:33
- Locatie: Dalen/Drenthe/Holland
- Contacteer:
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
##############################################################
Laatst gewijzigd door Diablo Gamer op 14 mar 2006, 20:04, 1 keer totaal gewijzigd.
It`s nice to be important, but it`s more important to be nice.
Ik heb nergens last van
Deze link is het : http://mods.db9.dk/viewtopic.php?t=115
Succes :thumb:

Succes :thumb:
Is die alDiablo Gamer schreef:je moet eerst lid worden dat lukt het wel
Laatst gewijzigd door Raimon op 13 mar 2006, 10:45, 1 keer totaal gewijzigd.
- Diablo Gamer
- Berichten: 1394
- Lid geworden op: 02 jan 2004, 20:33
- Locatie: Dalen/Drenthe/Holland
- Contacteer:
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:
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);
}
}
}
Laatst gewijzigd door CoNiO op 14 mar 2006, 13:42, 1 keer totaal gewijzigd.
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)
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 dusbrandsrus schreef:Heb je hem in deze volgorde in het document geplaatst?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)
Zo ja, dan vraag ik me af of je de db_update.php die erbij zit uitgevoerd hebt
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
