SQL Action 1

For a test user
I have the Login / Logout actions user connected on a subs subscription plan set up to on activation and deactivation , which I have allready programed BUT I NEED a trigger or auto action to delete user from CBuilder backend somehow after a idel time period like a 1 hour for the subs SQL action to fire. and delete users mosets listings.

What action allows any action you want to act on subscription activation and deactivation.

Thanks

CB Auto Actions is not a scheduler. There is no trigger in CB that fires every hour or anything of the sort. You'd need to setup an action to delete the user and run it every our using CRON. There is no action for deleting a user as it's considered dangerous. You'd have to use a Code action with Method set to PHP and use API to delete the user.

What action allows any action you want to act on subscription activation and deactivation.

Don't understand your question. An action doesn't care what trigger you use. For subscription activation and deactivation you can use the below with whatever action you like.

Plan Active
Global
Triggers: onCPayUserStateChange
User: Automatic
Access: Everybody
Conditions
1: [var3] Equal To PLAN_ID_HERE
2: [var2] Equal To A

Plan Expired
Global
Triggers: onCPayUserStateChange
User: Automatic
Access: Everybody
Conditions
1: [var3] Equal To PLAN_ID_HERE
2: [var2] Not Equal To A

How do you that is that hard?

How do you do what? Fire an action from CRON? Don't select a trigger (leaving it as None) then use CRON to schedule a GET request to the auto actions URL under the Global tab. There's also the Internal Users and Internal General triggers, which when using the Internal Users URL or Internal General URL found within CB Auto Actions > Parameters will run any auto actions with those respective triggers with Internal Users looping every user on your site (careful with that one).