The error message in that image implies you did not applied the code change.
omg yeah sama i just manually looked the code and changed the two lines but now when i exactly copied and pasted your code it is working now.
ok so the error was showing very nicely that you have tripped spam filter and the plugin dont let post people with too many links.
but if they reduce the links and publish the post then they get sql error please help i have changed the code exactly
Query:
SELECT rid FROM mybb_reportedposts WHERE pid=19721 AND reportstatus=0 LIMIT 1
let me rephrase the plugin works to stop someone add to many links but if they reduce the link and the thread is published and the plugin have to create a report in the report center the error comes up
here is what i have currently
![[Image: kAbd5G3.png]](http://i.imgur.com/kAbd5G3.png)
Knowing the error may help.
Oh there is another line in the plugin that should be updated. Find:
PHP Code:
if($settings['spamalyser_report_nodupe']) {
if($db->fetch_field($db->simple_select('reportedposts', 'rid', 'pid='.$pid.' AND reportstatus=0', array('limit' => 1)), 'rid')) return false;
}
$lang->load('spamalyser');
$post = get_post($pid);
$db->insert_query('reportedposts', array(
'pid' => $pid,
'tid' => $post['tid'],
'fid' => $post['fid'],
'uid' => (int)$settings['spamalyser_report_uid'],
'dateline' => TIME_NOW,
'reportstatus' => 0,
'reason' => $db->escape_string($lang->sprintf($lang->spamalyser_report_msg, $thresh))
));
|
Change to:
PHP Code:
if($settings['spamalyser_report_nodupe']) {
if($db->fetch_field($db->simple_select('reportedcontent', 'rid', 'id='.$pid.' AND reportstatus=0 AND (type="post" OR type="")', array('limit' => 1)), 'rid')) return false;
}
$lang->load('spamalyser');
$post = get_post($pid);
$db->insert_query('reportedcontent', array(
'id' => $pid,
'id2' => $post['tid'],
'id3' => $post['fid'],
'type' => 'post',
'uid' => (int)$settings['spamalyser_report_uid'],
'dateline' => TIME_NOW,
'reportstatus' => 0,
'reason' => $db->escape_string($lang->sprintf($lang->spamalyser_report_msg, $thresh))
));
|
changed the code. thanks sama for the help
Says not compatable with mybb 1.8.6
(10-19-2015 11:14 AM)metulburr Wrote: [ -> ]Says not compatable with mybb 1.8.6
You can just change the compatibility line in sp_admin.php to include 1.8:
'compatibility' => '14*,15*,16*,18*',
However it doesn't work properly, and not even really need as 1.8 has it's own spam functions built in now.
(03-05-2015 04:20 AM)Hamster24 Wrote: [ -> ]Please update this to 1.8 version
I have added the 2 fixes that Sama34 posted for mybb1.8
full download here:
https://github.com/mmikeww/mybb-spamalys...https://github.com/mmikeww/mybb-spamalyser/archive/
(03-05-2015 06:58 PM)Hamster24 Wrote: [ -> ]also in spamalyser logs what is /admin/spamalyser_img/action_.gif i what does it symbolize as i am getting a broken image (404) so don't know what this image means.
other images such as /admin/spamalyser_img/action_blocked.gif is showing fine.
I'm seeing this too. As you said, for posts that get 'blocked', they correctly display the red X image. But for posts that get 'reported', or posts that are allowed through, I get the 404 image.