Please Log in to join the conversation.
INSERT INTO `TABLE_PREFIX_comprofiler_plugin_activity_comments` ( `user_id`, `asset`, `message`, `date` ) SELECT b.`userid`, CONCAT( 'comment.', ( SELECT `id` FROM `TABLE_PREFIX_comprofiler_plugin_activity_comments` WHERE `asset` = CONCAT( 'profile.', b.`userid`, '.field.FIELD_ID' ) AND `message` = b.`feedback` LIMIT 1 ) ), b.`feedback`, b.`date` FROM `TABLE_PREFIX_comprofiler_plug_profilebook` AS b WHERE b.`posterid` > 0 AND b.`mode` = 'w' AND ( b.`feedback` != '' AND b.`feedback` IS NOT NULL )
Please Log in to join the conversation.
Please Log in to join the conversation.
`message` = b.`feedback`
`message` = b.`postercomment`
Please Log in to join the conversation.
Please Log in to join the conversation.
Please Log in to join the conversation.