Automation Rules

ok, thankyou !

Schedule the custom action to run one time (not bulk) and it will allow you to input the member to run it for.

interesting : how may I chose by hand a specific member to test/debug the rule ?

I don't see anything in particular that would be causing a problem with your rule group. I can't see what member groups you have set in your conditions since the member groups from your rule export do not exist on my system, but I would double check that you have your member groups set correctly. Also, this rule group is attached to the custom action which you have created. So that means that it will only run when your custom action is called. I would double check that it is still scheduled as a recurring bulk action and that it has not stalled or been deleted. Finally, if all of that still looks correct, you can turn debugging on for your rule and then inspect the debug logs to see if anything looks off. With debugging turned on for the rule, you can also trigger the rule to run for a member of your choosing by hand and then inspect the log for that and see where it may have gone wrong.

ok, here is the rule as attached file. It tries to detect inactive members since more than one year from a group to change its primary group and send a reminder through PM & e-mail. mi-détection-apprentis-inactifs.xml

Ok, but you didn't mention what the rule is supposed to do and why you think its not working. Sometimes its best to just export the rule and post it here.

Hi, thankyou for your reply, here an example : User X has made its last post at november 27, 2017 Schedule on all users Rule triggers on users where their last post is NOT within the last year => user X does not fit in. Edit : It seems the problem may be a bit deeper than expected. In fact, when performing a search with the built-in user search engine looking for users having their last post between dec.11 2016 and dec.11 2017, user X does not appear in the list neither (!!!???) So the rule may be ok, but IPS may have some bug here... really strange situation...

No clue. A specific example would be helpful...

Hi, Since the installation of latest update (V1.4.5) some rules dont work anymore, like just ignored... Some clues about it ? Best regards, Z

Thanks for answer! Do you help with PHP code?)

There is not really a straightforward easy way to accomplish that goal without writing some custom php code to go in your rules. The event is when a new database record is created, and the action will be a custom one which will need to take the value from the "Order city" field of the custom database and look up all the users who have a matching data field, and then pass those to the email action.

Hello! Here is what I did: 1. Create new Custom Data Fields - Work City (checkbox) 2. Create new Database Fields - Order city (radio) I want to: 1. If new record in database is created 2. Send an Email to everyone who matches the value of Work City = Order city For example: 1. There are 10 members who have Database Fields (Work City) = London 2. Create an new record for which Custom Data Fields (Order city) = London How to send a Email bulk letters to anyone with Custom Data Fields (Order city) = London? Thanks for your app and support!

Ahh, yes thank you. That worked.

I dont think your $teamRows are objects. I believe that the query returns an associative array. Try $team1Row['field_27']

I'm trying to use a simple lookup based on a value and am not getting anything returned from the query after a record is added. //<?php $team1Row = \IPS\Db::i()->select( 'primary_id_field, field_27', 'cms_custom_database_5', array( 'primary_id_field=?', $content->field_61 ) )->first(); $team2Row = \IPS\Db::i()->select( 'primary_id_field, field_27', 'cms_custom_database_5', array( 'primary_id_field=?', $content->field_63 ) )->first(); $newTitle = $team1Row->field_27." vs. ".$team2Row->field_27." winID: ".$content->field_61." loseID: ".$content->field_63; return $newTitle; Is this the right query structure to use? The final output is " vs. winID: 8 loserID: 23" with the ID's being correct. The custom database has the field_27 also. Thanks

Hi, We're trying to detect active members in community to reward them (under a reputation condition too). So, to detect that kind of users we've imagined to find users having published a certain amount of posts in a period of time AND only in specific forums/sections of the community (the technical ones). But it seems we've reached the limits of Automation Rules... So maybe by making some code/condition "by hand" it could be possible ? Do you have any ideas ? Thankyou and best regards, Z

Another way would be: $post = $content->comments(1,0); The IPS\forums\Topic object model has the following core method on it: /** * Get comments * * @param int|NULL $limit The number to get (NULL to use static::getCommentsPerPage()) * @param int|NULL $offset The number to start at (NULL to examine \IPS\Request::i()->page) * @param string $order The column to order by * @param string $orderDirection "asc" or "desc" * @param \IPS\Member|NULL $member If specified, will only get comments by that member * @param bool|NULL $includeHiddenComments Include hidden comments or not? NULL to base of currently logged in member's permissions * @param \IPS\DateTime|NULL $cutoff If an \IPS\DateTime object is provided, only comments posted AFTER that date will be included * @param mixed $extraWhereClause Additional where clause(s) (see \IPS\Db::build for details) * @param bool|NULL $bypassCache Used in cases where comments may have already been loaded i.e. splitting comments on an item. * @param bool $includeDeleted Include Deleted Content * @param bool|NULL $canViewWarn TRUE to include Warning information, NULL to determine automatically based on moderator permissions. * @return array|NULL|\IPS\Content\Comment If $limit is 1, will return \IPS\Content\Comment or NULL for no results. For any other number, will return an array. */ public function comments( $limit=NULL, $offset=NULL, $order='date', $orderDirection='asc', $member=NULL, $includeHiddenComments=NULL, $cutoff=NULL, $extraWhereClause=NULL, $bypassCache=FALSE, $includeDeleted=FALSE, $canViewWarn=NULL )

Just wondering if anyone knew how we can have it so Membershop points that you earn (such as from posting) will convert to Reputation Points after say every hour?

For anyone curious in the future its this: $post = \IPS\forums\Topic\Post::load( $content->topic_firstpost );

I have created a rule that does an action when a topic is hidden, but unfortunately I can;t seem to load the post object to get the post content because a topic doesn't contain that information. To be perfectly honest I don't even know where to find documentation on all the class namespaces, so I have kind of been guessing most the way. What am i doing wrong here? $post = \IPS\Content\Item::load( $content->topic_firstpost ); Is what I'm doing not even possible?

Perfect. Good job on solving that one.

Ok so I cant edit my previous posts, but I finally found a solution. I have deduced that the default value for a post state is open. Therefore setting an event condition to check for the state value wont work due to it always being open. Therefore, its not until "Defer To Page End" that the state has been set correctly. So I manipulate my action code to check the state of the content before processing the action code, and obviously have it triggered at point "Defer To Page End".

I wish i could find the file where the event is define to investigate

Update: Event trigger doesnt pick up the link as a new topic. It appears that the code triggers a new post when the topic is moved, despite keeping the same id. Odd. Back to the drawing board!

Hi All, To anyone who is reading this and wants a solution. As per Kevins guidance above, I was able to locate the following: The state field in the database for topic's stores the value "link" when saving a link. Usually this field has the value of open or close, which defines the post being locked or not, etc. Keep in mind i didn't know how to deconstruct the object any other way than to view the database table for forum_topics. Hope this helps anyone in the future!