Code: Select all
//Create the forum
$sql = "INSERT INTO phpbb_forums
VALUES ('$forum_id', '1', '$new_member', '$description', '0', '$new_forum_order', '0', '0', '0', '', '0', '0', '0', '3', '1', '1', '3', '3', '3', '1', '1', '1', '-1', '1', '29')";
mysql_query($sql);
//Set the group values
$sql = "INSERT INTO phpbb_groups
VALUES ('$group_id', '1', '', 'Personal User', '0', '1')";
mysql_query($sql);
$sql = "INSERT INTO phpbb_user_groups
VALUES ('$group_id', '$user_id', '0')";
mysql_query($sql);
//Make the user moderator of his/her forum
$sql = "INSERT INTO phpbb_auth_access
VALUES ('$group_id', '$forum_id', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0')";
mysql_query($sql);