View Single Post
Old September 23rd, 2004, 02:38 PM   #2 (permalink)
Chuck S
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 66,782
We dont use the Nuke usergroups for group access

We use the phpbb usergroups in Nuke

Quote:
function import_user_groups() {
global $Globals, $db_link, $link;

if ( !empty($Globals['dprefix']) ) {
$grouptable="{$Globals['dprefix']}bbgroups";
}
else
$grouptable="bbgroups";

$query = "SELECT group_id,group_name FROM $grouptable WHERE group_type=2 OR group_single_user=0";
$readug = ppmysql_query($query, $db_link);

if ( !$readug ) {
diewell("Error: Are you certain that your database prefix is set properly?<p>I cannot see your
Nuke \"<b>$grouptable</b>\" table.<p>The prefix setting adds characters to the front of Nuke
table names - please doublecheck this.");
}

$rcount = mysql_num_rows($readug);

if ($rcount > 0) {
$deleteq = "DELETE FROM {$Globals['pp_db_prefix']}usergroups";
$resultd = ppmysql_query($deleteq, $link);

if ( file_exists( "usergroups-nuke.sql") ) {
$filearray = file( "usergroups-nuke.sql" );

while ( list($num, $query) = each($filearray) ) {
if ( $query != "" && !strstr($query, "CREATE") ) {
$query = str_replace( ";", "", $query);
$query = str_replace( "{\$pp_db_prefix}", $Globals['pp_db_prefix'], $query );
$setup = ppmysql_query($query, $link);
}
}
}
else {
diewell("usergroups-nuke.sql is missing.");
}

while ( list( $groupid, $title ) = mysql_fetch_row( $readug ) ) {
$title = addslashes( $title );
if ( $groupid == 2 ) {
$query = "REPLACE INTO {$Globals['pp_db_prefix']}usergroups (groupid,groupname,modaccess,cpaccess,uploads,comments,diskspace,uploadsize,editpho,editposts) VALUES($groupid,'$title','1','1','1','1','0','0','1','1')";
}
else {
$query = "REPLACE INTO {$Globals['pp_db_prefix']}usergroups (groupid,groupname,modaccess,cpaccess,uploads,comments,diskspace,uploadsize,editpho,editposts) VALUES($groupid,'$title','0','0','1','1','0','0','1','1')";
}
$setug = ppmysql_query($query, $link);
}
}
ppmysql_free_result( $readug );
}

function init_user_groups() {
global $link, $pp_db_prefix;

if ( file_exists( "usergroups-nuke.sql") ) {
$filearray = file( "usergroups-nuke.sql" );

while ( list($num, $query) = each($filearray) ) {
if ($query != "") {
$query = str_replace( ";", "", $query);
$query = str_replace( "{\$pp_db_prefix}", $pp_db_prefix, $query );
$setup = mysql_query($query,$link);
}
}
}
else {
diewell("usergroups-nuke.sql is missing.");
}
}
There are only 3 usergroups or should be

INSERT INTO usergroups VALUES ('1','Anonymous','','','','','',0,0,0,0,0);
INSERT INTO usergroups VALUES ('2','Admin',1,1,1,'','',1,1,1,1,0);
INSERT INTO usergroups VALUES ('3','Regular Users','',1,1,'','',1,1,0,1,0);

If your missing one of those usergroups you can use one of these sql queries in phpmyadmin
__________________
Photopost Developer and Support Engineer

Please do not PM me for support or sales questions. Thank you for your understanding.
Chuck S is offline   Reply With Quote