Where is the Fix Group Script?

Nuke Soldier Joined: Jul 09, 2003 Posts: 32

Quote:

Please try the Fix Group Script - http://www.nukecops.com/postt1.html

I went to the link, but there's no sign of the Fix Group Script... Wink

Anyone knows where it is?

Posted: Tue Oct 10, 2006 5:03 am

Kommius wrote:

Quote:

Please try the Fix Group Script - http://www.nukecops.com/postt1.html

I went to the link, but there's no sign of the Fix Group Script... Wink

Anyone knows where it is?

While an informatiove link I didn't find the fixgroup script either. I am told that is what I need for a small problem.

Hopefully someone knows where to find it? Very Happy

Nuke Soldier Joined: May 24, 2006 Posts: 33

Has anyone been able to find this script? I am in need of it!!

Thanks,
Slappy

Nuke Soldier Joined: May 24, 2006 Posts: 33

Opps,

i think I found it. And for everyone who is looking for it, here is the script!

Code:

<?php
//***** check users and user groups ****//
if (!eregi("modules.php", $PHP_SELF)) {
die ("You can't access this file directly...");
}
if ($popup != "1"){
$module_name = basename(dirname(__FILE__));
require("modules/".$module_name."/nukebb.php");
}
else
{
$phpbb_root_path = 'modules/Forums/';
}

define('IN_PHPBB', true);
include($phpbb_root_path . 'extension.inc');
include($phpbb_root_path . 'common.'.$phpEx);
include('includes/functions_search.'.$phpEx);

// Start session management
$userdata = session_pagestart($user_ip, PAGE_SEARCH, $nukeuser);
init_userprefs($userdata);
// End session management

$sql = "SELECT user_id, username
FROM " . USERS_TABLE ."
WHERE user_id > 0";
if ( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, 'Could not obtain user list', '', __LINE__, __FILE__, $sql);
}

$liste ='';
while ( $row = $db->sql_fetchrow($result) )
{
$username = $row['username'];
$user_id = $row['user_id'];
$usergroup = '';

$sql1 = "SELECT ug.group_id
FROM " . USER_GROUP_TABLE ." ug, ". GROUPS_TABLE. " g
WHERE ug.user_id = $user_id
AND ug.group_id = g.group_id
AND g.group_single_user = 1
";

if ( ($result1 = $db->sql_query($sql1)) )
{
$row1 = $db->sql_fetchrow($result1);
$usergroup =( ( $row1['group_id'] != '' ) ? $row1['group_id'] : 'User has no user group'.$row1 );

}

if (!($row1['group_id'] != ''))
{

$sql2 = "SELECT MAX(group_id) AS total
FROM " . GROUPS_TABLE;
if ( !($result2 = $db->sql_query($sql2)) )
{
message_die(GENERAL_ERROR, 'Could not obtain next group_id information', '', __LINE__, __FILE__, $sq2l);
}

if ( !($row2 = $db->sql_fetchrow($result2)) )
{
message_die(GENERAL_ERROR, 'Could not obtain next group_id information', '', __LINE__, __FILE__, $sql2);
}
$group_id = $row2['total'] + 1;

$sql3 = "INSERT INTO " . GROUPS_TABLE . " (group_id, group_name, group_description, group_single_user, group_moderator)
VALUES ($group_id, '', 'Personal User', 1, 0)";
if ( !($result3 = $db->sql_query($sql3, BEGIN_TRANSACTION)) )
{
message_die(GENERAL_ERROR, 'Could not insert data into groups table', '', __LINE__, __FILE__, $sql3);
}

$sql4 = "INSERT INTO " . USER_GROUP_TABLE . " (user_id, group_id, user_pending)
VALUES ($user_id, $group_id, 0)";
if( !($result4 = $db->sql_query($sql4, END_TRANSACTION)) )
{
message_die(GENERAL_ERROR, 'Could not insert data into user_group table', '', __LINE__, __FILE__, $sql4);
}

$usergroup = $usergroup.', adding user group '.$group_id;
}

$liste .= ( ( $liste != '' ) ? '<br> ' : '' ) . $username.' <b>'.$usergroup.'</b>';
}

message_die(GENERAL_MESSAGE,'Users:<br>'.$liste);

?>

Nuke Cadet Joined: Jan 06, 2007 Posts: 5

so how do i fix it? i put that in a php and upload to modules/forums?

Nuke Soldier Joined: May 24, 2006 Posts: 33

Yes, then you need to navigate to the file via browser.

Copy the script above
Past into file and name it groupfix.php
Upload to public folder
Navigate to file via browser

So for you it would be: http://www.yoursite.com/modules/Forums/groupfix.php

Very Happy

Nuke Cadet Joined: Jan 06, 2007 Posts: 5

lol... ok i got that done.... I think, is this what its suppose to look like?
http://www.awhitedesigns.com/mac/modules.php?name=Forums&file=groupfix

Nuke Soldier Joined: May 24, 2006 Posts: 33

Yeah, that should do it. Though I've never done it that way. Very Happy