k er staat nu een wat duidelijkere beschrijving ik hoop nu wel duidelijk genoeg :thumb: ?mosymuis schreef:"Newbie post secie mod" zegt me helemaal niets, kies een duidelijkere titel of licht toe wat je precies wilt hebben.
En wacht wat langer op een reactie, binnen drie uur je post omhoog bumpen is nogal onbeleefd. Wacht minimaal een dag voordat je dat doet.
Ik heb me daar geregistreerd en ingelogt maar ik krijg:mosymuis schreef:Aah. En je hebt geluk, want een dergelijke mod bestaat inderdaad.
http://mods.db9.dk/viewtopic.php?t=115
Code: Selecteer alles
Sorry, but only users granted special access can read topics in this forum. Auto group [2.0.6/EM]
You'll automatically gain access to this forum when you will post your first post in another forum. That way it will demonstrate how the Auto Group MOD works.
Code: Selecteer alles
#-----[ 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);
}
}
# Code: Selecteer alles
#-----[ FIND ]------------------------------------------
#
$sql = "SELECT post_id
#
Ja. Maar na heel wat geprobeer is het toch geluktsuperman5000 schreef:@plok : je gebruikt toch phpbbplus?
ik denk dat het daar door komt.
