Adding a moderator for forums

Lieutenant Joined: Mar 11, 2003 Posts: 180

ahhh, that must be it

thanks for letting me know, i'll make sure i get the latest forums package then

Nuke Cadet Joined: Jun 21, 2003 Posts: 3

I have a quick workaround for this problem
remove the user from all groups
then set permissions for the user
then add the user back into groups.

When you set user permissions it appears that a special individual user group is created.(a row in bb_user_groups table) but if the user is already in a group then the row is not inserted and the changes dont stick.

Nuke Soldier Joined: Apr 16, 2003 Posts: 15

Fix:

Code:

$newmaxvalue are max value of group id from table nuke_bbgroups +1

INSERT INTO `nuke_bbgroups` ( `group_id` , `group_type` , `group_name` , `group_description` , `group_moderator` , `group_single_user` )
VALUES (
'$newmaxvalue', '1', '', 'Personal User', '0', '1'
);

$newmaxvalue are "group id"
$user_id are user id

INSERT INTO `nuke_bbuser_group` ( `group_id` , `user_id` , `user_pending` )
VALUES (
'$newmaxvalue', '$user_id, '0'
);

Just do it Smile

(from italy) www.raulken.it

Posted: Sun Oct 19, 2003 2:50 pm

I have same problem ...

I want put moderator in my bbtonuke ...

but, have this error ...

I understand like fix problem...

try download file, but link dont work ...

Raulken, I put this code where !?

thx

Nuke Soldier Joined: Apr 16, 2003 Posts: 15

"To hand"

Please staff fix on file

Posted: Wed Oct 22, 2003 8:16 am

Raulken - what file is that to go in?

-sting

Nuke Soldier Joined: Apr 16, 2003 Posts: 15

I use it on sqlplus(tool no web, manual sql)... Because modules/Forums/admin/admin_ug_auth.php not work...

Posted: Thu Oct 23, 2003 6:30 pm

But ... how fix ? Confused

I have other errors in forum .. like when: Notify me when a reply is posted
is checked in post .. have a error..

link of nickname is incorrect ... link is invalid

is it possible to block the button soon Submit after the first click? to avoid that it is clicked again and send the same message again.

wait. Thx

Nuke Cadet Joined: May 04, 2003 Posts: 3

This subject had me baffled as far as modifing the original code so I just wrote a new script for the admin that makes the necessary additions to the bbgroups and bbuser_group

The code is rough but works. You have to know the User ID of the member you are going to change permissions for. The script will find the next group id number and automatically add it for you. Maybe after some sleep I will fix it up some. Very Happy

first I call forumfix.php and goes in the admin/modules/ folder

Code:

<?php

/*******************************************************************************
*
* Redistribution and use with or without modification, are
* permitted provided that the following condition is met:
*
* Redistributions must retain the credit to original author below.
*
* File : forumfix.php
* Addon for PHP-Nuke to manage forums Couldn't update private forum permissions problem
* Date : 10/29/2003
*
* Author : ToJo
* Website : http://www.coopvets.com
* Email : tojo@coopvets.com
*******************************************************************************/

if(!eregi("admin.php", $PHP_SELF)){ die("Access Denied"); }

$result = sql_query("select radminuser, radminsuper from ".$prefix."_authors where aid='$aid'", $dbi);
list($radminuser, $radminsuper)=sql_fetch_row($result, $dbi);
if(($radminuser==1)OR($radminsuper==1)){

/**************************************************/

function forumfix(){
global $fixsubmit, $addsubmit, $action, $user_id, $newmaxvalue;

include("header.php");
GraphicAdmin();
OpenTable();
if(!$action){
$newmaxvalue = 0;

$query =mysql_query("SELECT group_id FROM nuke_bbgroups ORDER BY group_id DESC") or die(mysql_error());
$row = mysql_fetch_array($query);
$newmaxvalue = $row[group_id];
$newmaxvalue++;

echo "<form method=\"post\" action=\"admin.php?op=forumfix&action=add\">";
echo "<center><table border=\"0\" cellspacing=\"0\" cellpadding=\"4\">";
echo "<tr><td align=right>User ID:</td><td><input type=\"text\" name=\"user_id\" size=\"24\" maxlength=\"24\" value=\"\" /></td></tr>";
echo "<tr><td align=right>New Group ID:</td><td><input type=\"text\" name=\"newmaxvalue\" size=\"24\" maxlength=\"24\" value=\"$newmaxvalue\" /></td></tr>";
echo "</table><br><br>";
echo "<input type=\"submit\" name=\"fixsubmit\" value=\"Fix Member Grouping\" />";
echo "</form>\n";
}

if($action=="add"){
if(!$addsubmit){

echo "<center>Are you sure?<br>";
echo "<form method=\"post\" action=\"admin.php?op=forumfix&action=add&newmaxvalue=$newmaxvalue&user_id=$user_id\">";
echo "<input type=\"submit\" name=\"addsubmit\" value=\"Yes\" /></form><br>";
echo "<a href=\"admin.php?op=forumfix\">Back</a>";
} else {

/*$newmaxvalue are max value of group id from table nuke_bbgroups +1 */
$query1 =mysql_query("INSERT INTO nuke_bbuser_group VALUES ('$newmaxvalue', '$user_id', '0')") or die(mysql_error());
$query2 =mysql_query("INSERT INTO nuke_bbgroups VALUES ('$newmaxvalue', '1', '', 'Personal User', '0', '1')") or die(mysql_error());
}

CloseTable();

include("footer.php");

}}

/**************************************************/

switch($op){

case "forumfix":
forumfix();
break ;

}

/**************************************************/

} else {
echo "Access Denied";
}
?>

The second I call case.forumfix.php and goes in the admin/case/ folder

Code:

<?php

/************************************************************************/
/* PHP-NUKE: Web Portal System */
/* =========================== */
/* */
/* Copyright (c) 2002 by Francisco Burzi */
/* http://phpnuke.org */
/* */
/* This program is free software. You can redistribute it and/or modify */
/* it under the terms of the GNU General Public License as published by */
/* the Free Software Foundation; either version 2 of the License. */
/************************************************************************/

if (!eregi("admin.php", $PHP_SELF)) { die ("Access Denied"); }

switch($op) {

case "forumfix":

include("admin/modules/forumfix.php");
break;

}

?>

The third I call links.forumfix.php and goes in the admin/links/ folder

Code:

<?php

/************************************************************************/
/* PHP-NUKE: Web Portal System */
/* =========================== */
/* */
/* Copyright (c) 2002 by Francisco Burzi */
/* http://phpnuke.org */
/* */
/* This program is free software. You can redistribute it and/or modify */
/* it under the terms of the GNU General Public License as published by */
/* the Free Software Foundation; either version 2 of the License. */
/************************************************************************/

if (($radminsuper==1) OR ($radminlink==1)) {
adminmenu("admin.php?op=forumfix", "Forums Fix", "forumfix.gif");
}

?>

I used part of Raulken's script from above. (thanx for the inspiration!)

Only real problem right now is you have to back up after script is done but hey it works. Very Happy

Posted: Wed Oct 29, 2003 6:21 am

dont work ... Sad

but,, need now fix error in send email.. when Notify Replys is checked ...

Nuke Cadet Joined: May 04, 2003 Posts: 3

What don't work? I have used it multiple times on two sites both running nuke 6.5 with phbb 2.0.6.

Posted: Wed Oct 29, 2003 11:56 am

after click em Confirm button: "Are you Sure? Yes"
dont show nothing. only go next screen, with links of admin.

i am using nuke 6.9.

--
do u know solve problem with email ?

thx

Nuke Cadet Joined: May 04, 2003 Posts: 3

It works just doesn't show anything. After doing this just go back and try to set that person up as moderator or such and it should work. The scripting was done this morning at about 5 am and I just wanted to get it done before I fell asleep LOL.

As far as the e-mail - I have no idea. I don't have this problem so I haven't tried to fix it sorry!

Nuke Cadet Joined: Nov 24, 2003 Posts: 2

Hi everybody,

I have downloaded and executed fixgroup-file. It fixed the problem, but now I have lost all messages of "anonymous" users. The forum shows only those messages of only registered users and all messages of the guests are gone! Please advice what can be done in the situation?

Nuke Cadet Joined: Nov 24, 2003 Posts: 2

Hi everybody,

I have downloaded and executed fixgroup-file. It fixed the problem, but now I have lost all messages of "anonymous" users. The forum shows only those messages of only registered users and all messages of the guests are gone! Please advice what can be done in the situation?

chatserv wrote:

Make a backup of your database before trying this Download this file, upload it to the Forums folder and point your browser to http://www.yoursite.com/modules.php?name=Forums&file=fixgroup

Delete once done try changing the user's permissions once you have run the file.