FIX: SQL Errors Using MySQL 5 - To fix user registration Run in phpMyAdmin ALTER TABLE nuke_users CHANGE bio bio TINYTEXT NULL; ALTER TABLE nuke_users CHANGE ublock ublock TINYTEXT NULL;

Hosted by the SW:Rebellion Network

Welcome to Evaders Squadron Coding [ESC]

We host quality Star Wars sites - inquire at The Star Wars Rebellion Network


Login/Create an Account

Forums

· Forums FAQ
· Search
· Usergroups
· Profile
· Private Messages

Support Us

This site runs with your support. Please donate:

User Info/Login

Link to Us

Evaders Squadron Coding [ESC] :: View topic - Fix: Setting Users Permissions

Fix: Setting Users Permissions

Evaders Squadron Coding [ESC] Forum Index -> Coding Services

View previous topic :: View next topic

Author

Message

Evaders99

Joined: Jan 11, 2002
Posts: 3079
Location: USA

Posted: Sun Feb 11, 2007 2:24 am Post subject: Fix: Setting Users Permissions

Can't set your users to moderate individual forums? Here's a fix for those using the latest BBToNuke versions.

in modules/Forums/admin/admin_ug_auth.php

Code:

FIND

$sql = "SELECT user_id FROM " . USER_GROUP_TABLE . " WHERE user_id = '$user_id'";
$result = $db->sql_query($sql);
$row = $db->sql_fetchrow($result);
$user_check = $row['user_id'];

REPLACE WITH

$sql = "SELECT * FROM " . USER_GROUP_TABLE . " WHERE user_id = '$user_id'";
$result = $db->sql_query($sql);
$row = $db->sql_fetchrow($result);
$user_check = $row['user_id'];
$group_id = $row['group_id'];

FIND

message_die(GENERAL_ERROR, 'Could not create private group', '', __LINE__, __FILE__, $sql);
}
}

REPLACE WITH

message_die(GENERAL_ERROR, 'Could not create private group', '', __LINE__, __FILE__, $sql);
}
      $sql5 = "SELECT forum_id FROM " . FORUMS_TABLE . " WHERE 1;";
      $result5 = $db->sql_query($sql5);
      while($row5 = $db->sql_fetchrow($result5)) {
            $sql6 = "INSERT INTO " . AUTH_ACCESS_TABLE . " (group_id, forum_id) VALUES (" . $group_id . ',' . $row5['forum_id'] .")";
            $result6 = $db->sql_query($sql6);
   }
} else {
      $sql5 = "SELECT forum_id FROM " . FORUMS_TABLE . " WHERE 1;";
      $result5 = $db->sql_query($sql5);
      while($row5 = $db->sql_fetchrow($result5)) {
         $sql6 = "SELECT * FROM " . AUTH_ACCESS_TABLE . " WHERE group_id = $group_id AND forum_id = " . $row5['forum_id'];
         $result6 = $db->sql_query($sql6);
         if ($row6 = $db->sql_fetchrow($result6)) { } else {
               $sql6 = "INSERT INTO " . AUTH_ACCESS_TABLE . " (group_id, forum_id) VALUES (" . $group_id . ',' . $row5['forum_id'] .")";
               $result6 = $db->sql_query($sql6);
            }
   }
}

_________________
Evaders99

Webmaster

Administrator

Fighting is terrible, but not as terrible as losing the will to fight.
- SW:Rebellion Network - Evaders Squadron Coding -

The cake is a lie.

Evaders99

Joined: Jan 11, 2002
Posts: 3079
Location: USA

Posted: Sun Feb 11, 2007 11:12 pm Post subject:

Can't set your users to individual permissions to access forums?

in modules/Forums/admin/admin_ug_auth.php

Code:

FIND

if( $forum_access[$i][$auth_field] == AUTH_ACL && isset($change_acl_list[$forum_id][$auth_field]) )

REPLACE WITH

if( $forum_access[$i][$auth_field] == AUTH_ACL && isset($change_acl_list[$forum_id]) )

_________________
Evaders99

Webmaster

Administrator

Fighting is terrible, but not as terrible as losing the will to fight.
- SW:Rebellion Network - Evaders Squadron Coding -

The cake is a lie.

Display posts from previous:

	Evaders Squadron Coding [ESC] Forum Index -> Coding Services	All times are GMT - 5 Hours
Page 1 of 1

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

© 2005 - 2007 by Evaders99. All Rights Reserved.
All logos and trademarks in this site are property of their respective owner.
The comments are property of their posters.
You can syndicate our news using the file backend.php

PHP-Nuke Copyright © 2005 by Francisco Burzi. This is free software, and you may redistribute it under the GPL.
PHP-Nuke comes with absolutely no warranty, for details, see the license.
Page Generation: 0.18 Seconds