There is 2 problems with this hack and they are in field list. shoutmaxdaily and shouthierarchy are unknown colomn in field list. Is there a way to get these working ?
These queries wont run from hack installer so is there a way to run them manually ?
Code:
$query['new'][] = 'ALTER TABLE '.TABLE_PREFIX.'usergroup
ADD `shoutboxpermissions` INT(10) UNSIGNED DEFAULT \'0\' NOT NULL,
ADD `shouthierarchy` TINYINT(5) UNSIGNED DEFAULT \'0\' NOT NULL,
ADD `shoutmaxdaily` TINYINT(5) UNSIGNED DEFAULT \'0\' NOT NULL';
Code:
$query['new'][] = 'UPDATE '.TABLE_PREFIX.'usergroup SET shoutboxpermissions=\'1023\', shouthierarchy=\'1\' WHERE usergroupid=\'6\'';
$query['new'][] = 'UPDATE '.TABLE_PREFIX.'usergroup SET shoutboxpermissions=\'895\', shouthierarchy=\'2\' WHERE usergroupid=\'5\'';
$query['new'][] = 'UPDATE '.TABLE_PREFIX.'usergroup SET shoutboxpermissions=\'879\', shouthierarchy=\'3\' WHERE usergroupid=\'7\'';
$query['new'][] = 'UPDATE '.TABLE_PREFIX.'usergroup SET shoutboxpermissions=\'15\', shouthierarchy=\'4\' WHERE usergroupid=\'2\'';
$query['new'][] = 'UPDATE '.TABLE_PREFIX.'usergroup SET shoutboxpermissions=\'1\', shouthierarchy=\'6\' WHERE usergroupid=\'4\'';
$query['new'][] = 'UPDATE '.TABLE_PREFIX.'usergroup SET shoutboxpermissions=\'1\', shouthierarchy=\'5\' WHERE usergroupid=\'3\'';
$query['new'][] = 'UPDATE '.TABLE_PREFIX.'usergroup SET shoutboxpermissions=\'1\', shouthierarchy=\'0\' WHERE usergroupid=\'1\'';