2013-12-11, 02:05 PM
2013-12-11, 02:20 PM
IIRC, database fields for badword & replacement have 100 characters length, viz., varchar(100)
you can increase both of them - however not sure that such lengthy replacements are required
moreover such lengthy replacements might not work perfect ..
you can increase both of them - however not sure that such lengthy replacements are required
moreover such lengthy replacements might not work perfect ..
2013-12-11, 02:27 PM
where exactly is varchar(100) edited?
because i need to change a given word into a link and the link is longer than 100 characters....
mycode creates a mess of things if someone uses the word in a thread topic. i've asked about making mycode so it only affects body text, but never figured it out.
i guess i can make short links with goo.gl
because i need to change a given word into a link and the link is longer than 100 characters....
mycode creates a mess of things if someone uses the word in a thread topic. i've asked about making mycode so it only affects body text, but never figured it out.
i guess i can make short links with goo.gl
2013-12-11, 02:48 PM
^ changing field length should be possible through database manager
(eg. phpMyAdmin --> mybb_badwords --> structure --> field --> action --> change --> edit ..)
or sql queries can be used like below (assuming that tables prefix is mybb)
(eg. phpMyAdmin --> mybb_badwords --> structure --> field --> action --> change --> edit ..)
or sql queries can be used like below (assuming that tables prefix is mybb)
ALTER TABLE `mybb_badwords` CHANGE `badword` `badword` VARCHAR( 200 )
ALTER TABLE `mybb_badwords` CHANGE `replacement` `replacement` VARCHAR( 200 )