Kód: Vybrat vše
//setup cash to add up for all roles which allow posting without mod intervention
$role_ary = "
'ROLE_FORUM_LIMITED',
'ROLE_FORUM_LIMITED_POLLS',
'ROLE_FORUM_STANDARD',
'ROLE_FORUM_POLLS',
'ROLE_FORUM_FULL'";
$sql = 'SELECT role_id
FROM ' . ACL_ROLES_TABLE . "
WHERE role_name IN ($role_ary)
AND role_type = 'f_'";
$result = $db->sql_query($sql);
while ($row = $db->sql_fetchrow($result))
{
$sql_ary[] = array(
'role_id' => $row['role_id'],
'auth_option_id' => $sql_id[3],
'auth_setting' => 1,
);
}
$db->sql_freeresult($result);
$db->sql_multi_insert(ACL_ROLES_DATA_TABLE, $sql_ary);
//insert the modules
$sql = 'SELECT * FROM ' . MODULES_TABLE . " WHERE module_langname = 'ACP_CAT_DOT_MODS'";
$result = $db->sql_query($sql);
$row = $db->sql_fetchrow($result);
$db->sql_freeresult($result);
$sql_ary = array(
'module_enabled' => 1,
'module_display' => 1,
'module_basename' => '',
'module_class' => 'acp',
'parent_id' => $row['module_id'],
'left_id' => $row['right_id'],
'right_id' => $row['right_id'] + 3,
'module_langname' => 'ACP_HANDY_MODS',
'module_mode' => '',
'module_auth' => '',
);
$sql = 'INSERT INTO ' . MODULES_TABLE . ' ' . $db->sql_build_array('INSERT', $sql_ary);
$db->sql_query($sql);
$module_id = $db->sql_nextid();
$sql = 'UPDATE ' . MODULES_TABLE . "
SET left_id = left_id + 4, right_id = right_id + 4
WHERE left_id >= {$sql_ary['left_id']} AND module_id != $module_id";
$db->sql_query($sql);
$sql = 'UPDATE ' . MODULES_TABLE . "
SET right_id = right_id + 4
WHERE left_id < {$sql_ary['left_id']} AND right_id >= {$sql_ary['left_id']} AND module_id != $module_id";
$db->sql_query($sql);
$sql_ary = array(
'module_enabled' => 1,
'module_display' => 1,
'module_basename' => 'cash',
'module_class' => 'acp',
'parent_id' => $module_id,
'left_id' => $row['right_id'] + 1,
'right_id' => $row['right_id'] + 2,
'module_langname' => 'ACP_CASH',
'module_mode' => 'default',
'module_auth' => 'acl_a_',
);
$sql = 'INSERT INTO ' . MODULES_TABLE . ' ' . $db->sql_build_array('INSERT', $sql_ary);
$db->sql_query($sql);
//install the bank management module into the UCP
$sql = 'SELECT MAX(right_id) AS total_right FROM ' . MODULES_TABLE . " WHERE module_class = 'ucp'";
$result = $db->sql_query($sql);
$row = $db->sql_fetchrow($result);
$db->sql_freeresult($result);
$sql_ary = array(
'module_enabled' => 1,
'module_display' => 1,
'module_basename' => '',
'module_class' => 'ucp',
'parent_id' => 0,
'left_id' => $row['total_right'] + 1,
'right_id' => $row['total_right'] + 4,
'module_langname' => 'UCP_BANK',
'module_mode' => '',
'module_auth' => '',
);
$sql = 'INSERT INTO ' . MODULES_TABLE . ' ' . $db->sql_build_array('INSERT', $sql_ary);
$db->sql_query($sql);
$module_id = $db->sql_nextid();
$sql_ary = array(
'module_enabled' => 1,
'module_display' => 1,
'module_basename' => 'bank',
'module_class' => 'ucp',
'parent_id' => $module_id,
'left_id' => $row['total_right'] + 2,
'right_id' => $row['total_right'] + 3,
'module_langname' => 'UCP_BANK_MANAGEMENT',
'module_mode' => 'management',
'module_auth' => 'acl_a_bank_manage || acl_m_bank_manage',
);
$sql = 'INSERT INTO ' . MODULES_TABLE . ' ' . $db->sql_build_array('INSERT', $sql_ary);
$db->sql_query($sql);