Support Forum

Advanced Search
Forum Scope


Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
plugins-topic
HTML EMAIL Plugin - Post Content Not Appearing when Moderator on
Avatar
Ricki
Michigan
Member
sp_UserOfflineSmall Offline
Jun 17, 2015 - 1:50 pm

Yes, I am able to edit the plugin files.  I create custom Wordpress plugins and am very familiar with PHP.  I am not familiar with simple:press code with the exception of themes.

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Jun 17, 2015 - 3:14 pm

Well it's an odd one and I can't imagine why it has not cropped up before. Bottom line is it seems that the post content is not even sent to the routine in question. But - I have not had an opportunity to actually try this fix...

File is wp-content/sp-resources/forum-plugins/subscriptions/library/sp-subscriptions-components.php.

Line 37 should be trhe sytart f the sql SELECT statement. As in:

'SELECT '.SFFORUMS.'.forum_id, forum_slug, '.SFTOPICS.'.topic_id, topic_slug, topic_name, '.SFPOSTS.'.post_id, '.SFPOSTS.'.user_id, post_status, post_index, guest_name

You need to add 'post_content'; to the end of that column list as in:

'SELECT '.SFFORUMS.'.forum_id, forum_slug, '.SFTOPICS.'.topic_id, topic_slug, topic_name, '.SFPOSTS.'.post_id, '.SFPOSTS.'.user_id, post_status, post_index, guest_name, post_content 

Then, somewhere between lines 48 and 55 add the line:

$newpost['postcontent_unescaped'] = $postData->post_content;

Now to see if it works for you! And if it does note please that this is not a perfect or the final solution but it might just be good enough as a stop-gap until we can issue the proper  update. Please let me know...

andy-signature.png
YELLOW
SWORDFISH
Avatar
Ricki
Michigan
Member
sp_UserOfflineSmall Offline
Jun 17, 2015 - 4:16 pm

Thank you.  The code fixed the problem... including it not showing up with the HTML Email Plugin.

Avatar
Ike
Sawtry, UK
Member
Free Members
sp_UserOfflineSmall Offline
Jun 17, 2015 - 4:44 pm

Excellent, glad you have a fix until the update is released.

Forum Timezone: Europe/Stockholm
Most Users Ever Online: 1170
Currently Online:
Guest(s) 1
Currently Browsing this Page:
1 Guest(s)
Top Posters:
Mr Papa: 19448
Ike: 2086
Brandon: 864
kvr28: 804
jim: 650
FidoSysop: 577
Conrad_Farlow: 531
fiddlerman: 358
Stefano Prete: 325
Member Stats:
Guest Posters: 619
Members: 17362
Moderators: 0
Admins: 4
Forum Stats:
Groups: 7
Forums: 17
Topics: 10127
Posts: 79625