Hello Guy's
I have a problem when I edit the usergroup.php
When I put this code to my usergroup.php, I can not manage the usergroups permissions.
It's this code :
Find :
PHP Code:
if ($usergroupid != 1) // Guests can not post attachments
{
print_table_header($vbphrase['attachment_permissions']);
Add Above :
PHP Code:
print_table_header($vbphrase['shoutbox_cpusergroup_title']);
print_yes_no_row($vbphrase['shoutbox_cpusergroup_canview'], 'usergroup[shoutview]', $ug_bitfield['shoutview']);
print_yes_no_row($vbphrase['shoutbox_cpusergroup_canshout'], 'usergroup[shoutpost]', $ug_bitfield['shoutpost']);
print_input_row($vbphrase['shoutbox_cpusergroup_maxdaily'], 'usergroup[shoutmaxdaily]', $usergroup[shoutmaxdaily]);
if ($usergroupid != 1) { // Allow guests to shout but do nothing else...
print_yes_no_row($vbphrase['shoutbox_cpusergroup_canedit'], 'usergroup[shoutedit]', $ug_bitfield['shoutedit']);
print_yes_no_row($vbphrase['shoutbox_cpusergroup_candelete'], 'usergroup[shoutdelete]', $ug_bitfield['shoutdelete']);
print_yes_no_row($vbphrase['shoutbox_cpusergroup_canhdelete'], 'usergroup[shouthdelete]', $ug_bitfield['shouthdelete']);
print_yes_no_row($vbphrase['shoutbox_cpusergroup_caneditothers'], 'usergroup[shouteditothers]', $ug_bitfield['shouteditothers']);
print_yes_no_row($vbphrase['shoutbox_cpusergroup_candeleteothers'], 'usergroup[shoutdeleteothers]', $ug_bitfield['shoutdeleteothers']);
print_yes_no_row($vbphrase['shoutbox_cpusergroup_canhdeleteothers'], 'usergroup[shouthdeleteothers]', $ug_bitfield['shouthdeleteothers']);
print_yes_no_row($vbphrase['shoutbox_cpusergroup_canip'], 'usergroup[shoutip]', $ug_bitfield['shoutip']);
print_yes_no_row($vbphrase['shoutbox_cpusergroup_coventry'], 'usergroup[shoutcoventry]', $ug_bitfield['shoutcoventry']);
if ($vboptions['shoutbox_enablehierarchy'] == 1) {
print_input_row($vbphrase['shoutbox_cpusergroup_hierarchy'], 'usergroup[shouthierarchy]', $usergroup['shouthierarchy']);
}
}
print_table_break();
print_column_style_code(array('width: 70%', 'width: 30%'));
This is my error, it's happend on all groups:
HTML Code:
Usergroup Manager
Database error in vBulletin 3.0.5:
Invalid SQL: UPDATE usergroup SET
### UPDATE QUERY GENERATED BY fetch_query_sql() ###
title = 'Administrators',
description = 'Beheerder van de Dutch Racing League',
usertitle = 'Administrator',
opentag = '',
closetag = '',
passwordexpires = '90',
passwordhistory = '0',
shoutview = '0',
shoutpost = '0',
shoutmaxdaily = '0',
shoutedit = '0',
shoutdelete = '0',
shouthdelete = '0',
shouteditothers = '0',
shoutdeleteothers = '0',
shouthdeleteothers = '0',
shoutip = '0',
shoutcoventry = '0',
shouthierarchy = '1',
attachlimit = '0',
avatarmaxwidth = '120',
avatarmaxheight = '120',
avatarmaxsize = '25000',
profilepicmaxwidth = '60',
profilepicmaxheight = '60',
profilepicmaxsize = '12500',
pmquota = '25',
pmsendmax = '10',
forumpermissions = '393215',
pmpermissions = '3',
calendarpermissions = '31',
wolpermissions = '31',
adminpermissions = '3',
genericpermissions = '4194239',
genericoptions = '31'
WHERE usergroupid=6
mysql error: Unknown column 'shoutview' in 'field list'
mysql error number: 1054