Paying for simple PHP fix

feonix Peon

Messages:: 54

Likes Received:: 0

Best Answers:: 0

Trophy Points:: 0

#1

Fixed it myself. I had to add..

include($phpbb_root_path . 'common.' . $phpEx);

To the top. The functions_user.php file relied on things in common. So obvious now. I spent hours on this one.

Thanks for all the help anyway.

feonix, Dec 1, 2008 IP

elias_sorensen Well-Known Member

Messages:: 852

Likes Received:: 20

Best Answers:: 0

Trophy Points:: 110

#2

Hi,

I don't think that URL for the functions_user.php file will work since it's stored on a local drive.

Try:

This: include("/forum/includes/functions_user.php");
Or this: include("/includes/functions_user.php");
Or this: include("../includes/functions_user.php");
Or, at last, this: include("includes/functions_user.php");

elias_sorensen, Dec 1, 2008 IP

misbah Active Member

Messages:: 265

Likes Received:: 10

Best Answers:: 0

Trophy Points:: 68

#3

elias_sorensen...
include function can include file with full path address...
for more info, read this
http://id2.php.net/manual/en/ini.core.php#ini.include-path
Code (markup):

misbah, Dec 1, 2008 IP

feonix Peon

Messages:: 54

Likes Received:: 0

Best Answers:: 0

Trophy Points:: 0

#4

Yes it's finding the include file just fine. No error message about "group_user_add" being an undefined function. The script just runs and quits without any output and like I said if I put a print line after the call to the function it doesn't output but if I put it before it does. So it seems to be like the function isn't working right and is crashing or something weird. I know this function is commonly used to do this though.

If someone can fix this for me here in the forums I'll pay you as well.

Here are a couple different scripts that use this function without any problems and at the bottom the full function text....

<?php
/**
*
* @package auto_group
* @version 0.2.1
* @copyright (c) 2007 A_Jelly_Doughnut
* @license GNU Public License
*
*/

if (!defined('IN_PHPBB'))
{
exit;
}

/** Handles automagic grouping based on post count, time registered, and/or warnings.
* @param arrat $users - user IDs to act on. default $user->data['user_id']
* @param array $check - keys are fields in the users table, values will be numerical
*/
function auto_group($users = false, $check = false)
{
global $db, $user, $phpbb_root_path, $phpEx;

// guests cannot belong to groups
if (!$user->data['is_registered'])
{
return false;
}

// if we have a list of user IDs, clean them up
if (is_array($users))
{
$users = array_map('intval', $users);
}

if ($users === false)
{
$users = array($user->data['user_id']);

$user_row[$user->data['user_id']] = $user->data;
$check['posts'][$user->data['user_id']] = (int) $user->data['user_posts'];
$check['days'][$user->data['user_id']] = (int) max(1, round((time() - $user->data['user_regdate']) / 86400));
$check['warnings'][$user->data['user_id']] = (int) $user->data['user_warnings'];
}
else
{
// we need some info from the DB...to avoid possible SQL injection, we select *
$sql = 'SELECT * FROM ' . USERS_TABLE .
" WHERE " . $db->sql_in_set('user_id', $users);
$result = $db->sql_query($sql);

while ($row = $db->sql_fetchrow($result))
{
$user_row[$row['user_id']] = $row;
$check['posts'][$row['user_id']] = (int) $row['user_posts'];
$check['days'][$row['user_id']] = (int) max(1, round((time() - $row['user_regdate']) / 86400));
$check['warnings'][$row['user_id']] = (int) $row['user_warnings'];
}
}

// build SQL query...now using AND logic
$sql_select = $sql_or = '';
foreach ($check as $column => $value)
{
$sql_select .= "group_min_$column, group_max_$column, ";
$sql_or .= " group_min_$column <> 0 OR group_max_$column <> 0 OR ";
}

// trim trailing ,
$sql_select = substr($sql_select, 0, strrpos($sql_select, ','));
$sql_or = substr($sql_or, 0, -3);

$sql = "SELECT group_id, group_auto_default, $sql_select FROM " . GROUPS_TABLE . "
WHERE group_type <> " . GROUP_SPECIAL . "
AND ($sql_or)";
$result = $db->sql_query($sql, 7200);

$group_data = array();
while ($row = $db->sql_fetchrow($result))
{
$group_data[$row['group_id']] = $row;
}

if (!sizeof($group_data))
{
return false;
}

// The meat of the MOD...
// go through groups one at a time
$remove_groups = $add_groups = $group_make_default = array();
foreach ($group_data as $group_id => $data)
{
$group_make_default[$group_id] = $data['group_auto_default'];

// To achieve this, we check each column...
foreach ($check as $column => $value_ary)
{
// ... for each user in $users
foreach ($value_ary as $user_id => $value)
{
if ($user_id == ANONYMOUS)
{
continue;
}

// If there is no limit, skip it.
if ((int) $data['group_min_' . $column] == 0 && (int) $data['group_max_' . $column] == 0)
{
continue;
}
/**
* If values got out of whack, make sure user is properly kicked out of
* special status that new groups may assign.
* Cases where users might get kicked out:
* - Warnings expire
* - Post count drops due to post/topic/forum deletion
*
* This also handles hitting the maximum "as predicted"
*/
if (($data['group_min_' . $column] > 0 && $value < $data['group_min_' . $column]) ||
($data['group_max_' . $column] > 0 && $value > $data['group_max_' . $column]))
{
$remove_groups[$group_id][] = $user_id;
}
/**
* We also handle the event that an admin created a group and this user falls
* between the min_value and max_value for the new group.
* i.e.: user has 47 posts, and a group for users between 40 and 50 posts is
* created. The user is added to that group.
*/
else if ((($data['group_min_' . $column] > 0 && $value >= $data['group_min_' . $column]) ||
($data['group_max_' . $column] > 0 && $value <= $data['group_max_' . $column])) && (!isset($remove_groups[$group_id]) || !in_array($user_id, $remove_groups[$group_id])))
{
$add_groups[$group_id][] = $user_id;
}
}
}
}
$db->sql_freeresult($result);

if (sizeof($remove_groups))
{
if (!function_exists('group_user_del'))
{
include($phpbb_root_path . 'includes/functions_user.' . $phpEx);
}

// because phpBB doesn't check if users are actually members of the group
// before removing them, we check it before calling group_user_del()
$user_ids = array();
foreach ($remove_groups as $group_id => $user_id_ary)
{
if (is_array($user_id_ary) && sizeof($user_id_ary))
{
$user_ids = array_merge($user_ids, $user_id_ary);
}
}

$sql = 'SELECT user_id, group_id FROM ' . USER_GROUP_TABLE . '
WHERE ' . $db->sql_in_set('group_id', array_keys($remove_groups)) . '
AND ' . $db->sql_in_set('user_id', $user_ids);
$result = $db->sql_query($sql);

// we replace $remove_groups with the results from this SQL query...
// It returns people who need to be removed _and_ are members of the group
$remove_groups = array();
while ($row = $db->sql_fetchrow($result))
{
$remove_groups[$row['group_id']][] = $row['user_id'];
}

foreach ($remove_groups as $group_id => $user_id_ary)
{
if (!is_array($user_id_ary))
{
$user_id_ary = array($user_id_ary);
}

group_user_del($group_id, $user_id_ary, false, false, true);
}
}

if (sizeof($add_groups))
{
if (!function_exists('group_user_add'))
{
include($phpbb_root_path . 'includes/functions_user.' . $phpEx);
}

foreach ($add_groups as $group_id => $user_id_ary)
{
if (!is_array($user_id_ary))
{
$user_id_ary = array($user_id_ary);
}
$user_id_ary = array_unique($user_id_ary);

// if there are users to be both added and removed from this group,
// handle that. Remove overrides add for obvious reasons.
if (isset($remove_groups[$group_id]))
{
// we go thru and unset keys that exist in both arrays
$intersection = array_intersect($add_groups[$group_id], $remove_groups[$group_id]);

if (sizeof($intersection))
{
foreach ($intersection as $key => $void)
{
unset($user_id_ary[$group_id][$key]);
}
}
unset($intersecton);
}

// If admin requests it, user can get new default group by this method.
// Useful primarily for colouring.
group_user_add($group_id, $user_id_ary, false, false, $group_make_default[$group_id], 0, 0, false, true);
}
}

return false;
}

/**
* Ask Mr. Database for all users who meet the critera of the group being created
* @param array $group_id - $group_id used in the group_create() function
* @param bool &$make_default - Found by this SQL query, pass-by-ref
* @return array $auto_add_users - users who should be added to this group.
*/
function auto_groups_create($group_id, &$make_default)
{
global $db;

$sql = 'SELECT * FROM ' . GROUPS_TABLE . '
WHERE group_id = ' . (int) $group_id;
$result = $db->sql_query($sql);

$group_attributes = $db->sql_fetchrow($result);

$make_default = $group_attributes['group_auto_default'];

$where_sql = $auto_add_users = array();
// auto groups mod added
if (!empty($group_attributes['group_min_posts']) || !empty($group_attributes['group_max_posts']) || !empty($group_attributes['group_min_days']) ||
!empty($group_attributes['group_max_days']) || !empty($group_attributes['group_max_days']) || !empty($group_attributes['group_min_warnings']) || !empty($group_attributes['group_max_warnings']))
{
$field_ary = array(
'posts' => 'user_posts',
'days' => 'user_regdate',
'warnings' => 'user_warnings',);

// we find users who meet requirements for this group by building
// an sql query
$extremes = array('min' => '>=', 'max' => '<');
foreach ($field_ary as $mode => $field)
{
foreach ($extremes as $end => $sign)
{
// building this 'where' clause isn't easy...
if (isset($group_attributes['group_' . $end . '_' . $mode]) && $group_attributes['group_' . $end . '_' . $mode])
{
if ($mode == 'days')
{
/**
* this isn't stored in the same format we present the user
* user_regdate is seconds, 'group_(min/max)' is in days
**/
$time_required = (time() - ($group_attributes['group_' . $end . '_days'] * 86400));
// because we're dealing with timestamps, our min/max is wrong
$sign = ($sign == '>=') ? '<' : '>=';
$where_sql[] = "$field $sign $time_required";
}
else
{
$where_sql[] = "$field $sign " . $group_attributes['group_' . $end . '_' . $mode];
}
}
}
}

$sql = 'SELECT user_id FROM ' . USERS_TABLE . '
WHERE ' . $db->sql_in_set('user_type', array(USER_NORMAL, USER_FOUNDER)) . "
AND " . implode(' AND ', $where_sql);
$result = $db->sql_query($sql);

while ($row = $db->sql_fetchrow($result))
{
$auto_add_users[] = $row['user_id'];
}
$db->sql_freeresult($result);

// remove users who do not belong in this group and were added by
// the auto groups MOD
// This completes the sync
$sql = 'DELETE FROM ' . USER_GROUP_TABLE . '
WHERE group_id = ' . (int) $group_id . '
AND auto_group = 1
AND ' . $db->sql_in_set('user_id', $auto_add_users, true, true);
$db->sql_query($sql);

return $auto_add_users;
}
}

?>
Click to expand...

and...

<?php
/**
* @package Admin Tool Kit - Merge Groups
* @id $Id$
* @license GNU Public License
*/

if (!defined('IN_PHPBB'))
{
exit;
}

class merge_groups
{
/**
* Tool Info
*
* @return Returns an array with the info about this tool.
*/
function info()
{
global $user;

return array(
'NAME' => $user->lang['MERGE_GROUPS'], // The name of this tool that will be shown to the user
'NAME_EXPLAIN' => $user->lang['MERGE_GROUPS_EXPLAIN'],

'CATEGORY' => $user->lang['USER_GROUP_TOOLS'], // The category this tool should be shown in
);
}

/**
* Display Options
*
* Output the options available
*/
function display_options()
{
return array(
'title' => 'MERGE_GROUPS',
'vars' => array(
'legend1' => 'MERGE_GROUPS',
'groups_to_merge' => array('lang' => 'GROUPS_TO_MERGE', 'type' => 'select', 'function' => 'groups_select_options', 'params' => array('{CONFIG_VALUE}'), 'multiple' => true, 'explain' => true),
'groups_merge_target' => array('lang' => 'GROUPS_MERGE_TO', 'type' => 'text:40:255', 'explain' => true),
'groups_remove' => array('lang' => 'GROUPS_REMOVE', 'type' => 'checkbox', 'explain' => true),
));
}

/**
* Run Tool
*
* Does the actual stuff we want the tool to do after submission
*/
function run_tool(&$error)
{
global $atk_root_path, $db, $user;
global $phpbb_root_path, $phpEx;

if (!check_form_key('merge_groups'))
{
$error[] = 'FORM_INVALID';
return;
}

// Some vars
$groups = request_var('groups_to_merge', array(0, 0));
$target_group = utf8_normalize_nfc(request_var('groups_merge_target', '', true));
$groups_remove = (isset($_POST['groups_remove']) ? true : false);

// Check vars
if (!$groups || sizeof($groups) == 1)
{
$error[] = 'NO_MERGE_GROUP';
}
if ($target_group == '')
{
$error[] = 'NO_TARGET_GROUP';
}

if (sizeof($error))
{
return false;
}

// Include nececeiry files
if (!function_exists('group_user_add'))
{
include($phpbb_root_path . 'includes/functions_user.' . $phpEx);
}

// First select all the users in these groups
$users = array();
$sql = 'SELECT user_id, group_leader, user_pending
FROM ' . USER_GROUP_TABLE . '
WHERE ' . $db->sql_in_set('group_id', $groups) . '
ORDER BY group_leader DESC, user_pending DESC';
$result = $db->sql_query($sql);
while ($row = $db->sql_fetchrow($result))
{
if (!isset($users[$row['user_id']]))
{
$users[$row['user_id']] = $row;
}
}
$db->sql_freeresult($result);

// Are we working with an existing group?
$sql = 'SELECT group_id
FROM ' . GROUPS_TABLE . '
WHERE group_name = \'' . $db->sql_escape($target_group) . "'";
$result = $db->sql_query_limit($sql, 1, 0);
$group_id = $db->sql_fetchfield('group_id', false, $result);
$db->sql_freeresult($result);

// If the group doesn't exist, create it
if (!$group_id)
{
$group_id = $this->create_group($target_group);
}

// Now assign the users to the group
foreach ($users as $user_id => $data)
{
if ($err_msg = group_user_add($group_id, $user_id, false, false, true, $data['group_leader'], $data['user_pending']))
{
$error[] = $err_msg;
break;
}
}

// Do we have to remove the old groups?
if ($groups_remove && !sizeof($error))
{
foreach ($groups as $group_id)
{
if ($err_msg = group_delete($group_id))
{
$error[] = $err_msg;
break;
}
}
}

// Notify the user we're done here
if (sizeof($error))
{
return false;
}
else
{
trigger_error($user->lang['GROUPS_MERGE_SUCCESS']);
}
}

/**
* Create a new group, the new group is default hidden (GROUP_HIDDEN)
*
* @param $group_name the name of the new group
* @return $group_id the id of the new group
*/
function create_group($group_name)
{
// Set the default data
$group_id = 0;
$group_data_ary = array(
'colour' =>'',
'rank' => 0,
'receive_pm' => 1,
'legend' => 0,
'message_limit' => 0,
'founder_manage' => 0,
);

group_create($group_id, GROUP_HIDDEN, $group_name, '', $group_data_ary);

return $group_id;
}
}

/**
* Get groups
*
* Get all the groups that are availible on this board, and generate the options for the select field
*/
function groups_select_options()
{
global $db, $user;

$return = '';

$sql = 'SELECT group_id, group_type, group_name
FROM ' . GROUPS_TABLE . '
ORDER BY group_id ASC';
$result = $db->sql_query($sql);
while ($row = $db->sql_fetchrow($result))
{
$return .= '<option value="' . $row['group_id'] . '">' . (($row['group_type'] == GROUP_SPECIAL) ? $user->lang['G_' . $row['group_name']] : $row['group_name']) . '</option>';
}
$db->sql_freeresult($result);

return $return;
}
?>
Click to expand...

Full function from functions_user.php

/**
* Add user(s) to group
*
* @return mixed false if no errors occurred, else the user lang string for the relevant error, for example 'NO_USER'
*/
function group_user_add($group_id, $user_id_ary = false, $username_ary = false, $group_name = false, $default = false, $leader = 0, $pending = 0, $group_attributes = false)
{
global $db, $auth;

// We need both username and user_id info
$result = user_get_id_name($user_id_ary, $username_ary);

if (!sizeof($user_id_ary) || $result !== false)
{
return 'NO_USER';
}

// Remove users who are already members of this group
$sql = 'SELECT user_id, group_leader
FROM ' . USER_GROUP_TABLE . '
WHERE ' . $db->sql_in_set('user_id', $user_id_ary) . "
AND group_id = $group_id";
$result = $db->sql_query($sql);

$add_id_ary = $update_id_ary = array();
while ($row = $db->sql_fetchrow($result))
{
$add_id_ary[] = (int) $row['user_id'];

if ($leader && !$row['group_leader'])
{
$update_id_ary[] = (int) $row['user_id'];
}
}
$db->sql_freeresult($result);

// Do all the users exist in this group?
$add_id_ary = array_diff($user_id_ary, $add_id_ary);

// If we have no users
if (!sizeof($add_id_ary) && !sizeof($update_id_ary))
{
return 'GROUP_USERS_EXIST';
}

$db->sql_transaction('begin');

// Insert the new users
if (sizeof($add_id_ary))
{
$sql_ary = array();

foreach ($add_id_ary as $user_id)
{
$sql_ary[] = array(
'user_id' => (int) $user_id,
'group_id' => (int) $group_id,
'group_leader' => (int) $leader,
'user_pending' => (int) $pending,
);
}

$db->sql_multi_insert(USER_GROUP_TABLE, $sql_ary);
}

if (sizeof($update_id_ary))
{
$sql = 'UPDATE ' . USER_GROUP_TABLE . '
SET group_leader = 1
WHERE ' . $db->sql_in_set('user_id', $update_id_ary) . "
AND group_id = $group_id";
$db->sql_query($sql);
}

if ($default)
{
group_set_user_default($group_id, $user_id_ary, $group_attributes);
}

$db->sql_transaction('commit');

// Clear permissions cache of relevant users
$auth->acl_clear_prefetch($user_id_ary);

if (!$group_name)
{
$group_name = get_group_name($group_id);
}

$log = ($leader) ? 'LOG_MODS_ADDED' : 'LOG_USERS_ADDED';

add_log('admin', $log, $group_name, implode(', ', $username_ary));

group_update_listings($group_id);

// Return false - no error
return false;
}
Click to expand...

feonix, Dec 1, 2008 IP

mallorcahp Peon

Messages:: 141

Likes Received:: 2

Best Answers:: 0

Trophy Points:: 0

#5

It looks like it might be expecting an array for the $user_id

try this :


<?php
$group_id = 5;
$user_id = array();
$user_id[] = 54;

include("C:/Program Files/Apache Software Foundation/Apache2.2/htdocs/forum/includes/functions_user.php");

if ($error = group_user_add($group_id, $user_id))
{
trigger_error($error);
}

?>

PHP:

mallorcahp, Dec 1, 2008 IP

Log in or Sign up

Paying for simple PHP fix

feonix Peon

elias_sorensen Well-Known Member

misbah Active Member

feonix Peon

mallorcahp Peon

Useful Searches