thanks alot for this hack i am using vb3.6.0
but there is a problem in the hack here is the problem in the database appear i have tried to use moderation by keywords here:
Database error in vBulletin 3.6.0:
PHP Code:
Invalid SQL:
UPDATE usergroup SET
### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Members',
`description` = '',
`usertitle` = '',
`opentag` = '<font color=\"#330033\"><b>',
`closetag` = '</b></font>',
`passwordexpires` = '0',
`passwordhistory` = '0',
`forumpermissions` = '782847',
`attachlimit` = '0',
`pmquota` = '500',
`pmpermissions` = '3',
`pmsendmax` = '50',
`moderatepm_permissions` = '0',
`calendarpermissions` = '63',
`wolpermissions` = '1',
`adminpermissions` = '0',
`genericpermissions` = '472389575',
`genericoptions` = '54',
`profilepicmaxwidth` = '400',
`profilepicmaxheight` = '300',
`profilepicmaxsize` = '65535',
`avatarmaxwidth` = '130',
`avatarmaxheight` = '130',
`avatarmaxsize` = '20000',
`signaturepermissions` = '237567',
`sigpicmaxwidth` = '500',
`sigpicmaxheight` = '100',
`sigpicmaxsize` = '20000',
`sigmaxrawchars` = '1800',
`sigmaxchars` = '900',
`sigmaxlines` = '0',
`sigmaxsizebbcode` = '7',
`sigmaximages` = '80',
`hhroptions` = '0',
`anymediapermissions` = '3'
WHERE usergroupid=2;
MySQL Error : Unknown column 'hhroptions' in 'field list'
Error Number : 1054
Date : Tuesday, August 8th 2006 @ 09:13:17 PM
Script : http://*******.com/admincp/usergroup.php?do=update
Referrer : http://*******.com/admincp/usergroup.php?do=edit&usergroupid=2
IP Address :
Username : Terminatoronly
Classname : vb_database