Archive

Posts Tagged ‘trigger’

Android – Education App

September 19th, 2011 Comments off

Overview: An app for Android which let’s learners know about new course offerings, download items of interest, and view/listen to content.

MLI is implementing oAuth so that the app can work using tokens versus signup requiring sending of user information.

Workflow:
1)Learner registers/subscribes to free app which lists newly released and currently available courses to which they can listen and/or view.
Learner is sent an email which they click on their android which autoinstalls on their android.

2) The App automatically updates the list of currently available courses. Preference: update automatically once a week or prompt learner that they can update immediately (we can discuss this) when accessing the app.

3) The App allows learners to download content (audio and/or video files) to review at their convenience. A queue or curriculum folder is where the learner can select the courses at there convenience.

4) When the learner views/listens to the course, the app sends to our corporate database that the learner has viewed/listened to the file. It is preferable that both the start and completion date and time is recorded. If not possible, then notification that the learner has clicked on the link to begin the course could be the trigger.

5) Corporate database records the learner has completed the course (learner id token or registration data, course id, start and completion date/time)

The database I am referring to is the corporate learning management system. Upon recording of completed course, the process integrates into the online course progression (posttest and application for credit, certificate generation, completion of course) which is already built and working.

Bid should include email contact for references specifically related to android apps.

Please specifically outline what event could trigger the completion event (i.e. clicking on the link to begin listening to the file or embedding triggering code within the file which would trigger upon the learner finishing listening to the file).

Blackberry – Education App

September 19th, 2011 Comments off

Overview: An app for blackberrys which let’s learners know about new course offerings, download items of interest, and view/listen to content.

MLI is implementing oAuth so that the app can work using tokens versus signup requiring sending of user information.

Workflow:
1)Learner registers/subscribes to free app which lists newly released and currently available courses to which they can listen and/or view.
Learner is sent an email which they click on their blackberry which autoinstalls on their blackberry.

2) The App automatically updates the list of currently available courses. Preference: update automatically once a week or prompt learner that they can update immediately (we can discuss this) when accessing the app.

3) The App allows learners to download content (audio and/or video files) to review at their convenience. A queue or curriculum folder is where the learner can select the courses at there convenience.

4) When the learner views/listens to the course, the app sends to our corporate database that the learner has viewed/listened to the file. It is preferable that both the start and completion date and time is recorded. If not possible, then notification that the learner has clicked on the link to begin the course could be the trigger.

5) Corporate database records the learner has completed the course (learner id token or registration data, course id, start and completion date/time)

The database I am referring to is the corporate learning management system. Upon recording of completed course, the process integrates into the online course progression (posttest and application for credit, certificate generation, completion of course) which is already built and working.

Bid should include email contact for references specifically related to blackberry apps.

Please specifically outline what event could trigger the completion event (i.e. clicking on the link to begin listening to the file or embedding triggering code within the file which would trigger upon the learner finishing listening to the file).

Mysql Trigger

August 22nd, 2011 Comments off

I have a field in my database that occassionally gets populated with the following string:

O:8:”mgm_post”:8:{s:11:”purchasable”;s:1:”N”;s:13:”purchase_cost”;s:1:”0″;s:15:”purchase_expiry”;s:0:”";s:17:”purchase_duration”;s:1:”0″;s:7:”product”;a:0:{}s:23:”access_membership_types”;a:0:{}s:12:”access_delay”;a:0:{}s:15:”access_duration”;s:1:”0″;}

I need to switch this string to a similar but altogether different string, this one:

O:8:”mgm_post”:8:{s:11:”purchasable”;s:1:”N”;s:13:”purchase_cost”;s:1:”4″;s:15:”purchase_expiry”;s:0:”";s:17:”purchase_duration”;s:1:”0″;s:7:”product”;a:0:{}s:23:”access_membership_types”;a:1:{i:0;s:6:”member”;}s:12:”access_delay”;a:4:{s:5:”guest”;s:1:”0″;s:5:”trial”;s:1:”0″;s:4:”free”;s:1:”0″;s:6:”member”;s:1:”0″;}s:15:”access_duration”;s:1:”0″;}

I dont claim to be very good at SQL but this is what i have come up with:

CREATE TRIGGER setMetaValue BEFORE INSERT ON wp_postmeta
FOR EACH ROW
BEGIN
IF NEW.meta_value = ‘O:8:”mgm_post”:8:{s:11:”purchasable”;s:1:”N”;s:13:”purchase_cost”;s:1:”0″;s:15:”purchase_expiry”;s:0:”";s:17:”purchase_duration”;s:1:”0″;s:7:”product”;a:0:{}s:23:”access_membership_types”;a:0:{}s:12:”access_delay”;a:0:{}s:15:”access_duration”;s:1:”0″;}’ THEN

SET NEW.meta_value = ‘O:8:”mgm_post”:8:{s:11:”purchasable”;s:1:”N”;s:13:”purchase_cost”;s:1:”4″;s:15:”purchase_expiry”;s:0:”";s:17:”purchase_duration”;s:1:”0″;s:7:”product”;a:0:{}s:23:”access_membership_types”;a:1:{i:0;s:6:”member”;}s:12:”access_delay”;a:4:{s:5:”guest”;s:1:”0″;s:5:”trial”;s:1:”0″;s:4:”free”;s:1:”0″;s:6:”member”;s:1:”0″;}s:15:”access_duration”;s:1:”0″;}’;

END IF;
END $$

DELIMITER ;

However i get error warnings of syntax errors, could this be because of the characters in the string?
If this is true (even if its not) Can anyone help with a fix?

Regards

Categories: MySQL Tags: , , , , , ,

Interspire Email Marketer Autoresponder Re-work

May 2nd, 2011 Comments off

Need to be able to trigger auto responders of a custom Event date field.

Need to be able to select hours, days before or after the event to trigger the auto responder. This function looks similar to the trigger function that already exists in IEM.

Ea Cci Trigger

January 15th, 2010 Comments off

Looking for a programmer to improve an EA for the MT4 platform by adding the CCI Trigger, a SL, Hedge capability etc. Full details will follow.

RT

Drupal Error Fix 2

December 7th, 2009 Comments off

When I activate the Trigger Module on my Drupal site, I get the following error:

user warning: Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation ‘=’ query: SELECT aa.aid, a.type FROM trigger_assignments aa LEFT JOIN actions a ON aa.aid = a.aid WHERE aa.hook = ‘nodeapi’ AND aa.op = ‘view’ ORDER BY weight in /home/lanemax/public_html/modules/trigger/trigger.module on line 146.

I need you to fix whatever this error is, as well as telling me what was wrong so that it never happens again. :)

If you can do this, please place a bid.

Drupal Error Fix

December 7th, 2009 Comments off

When I activate the Trigger Module on my Drupal site, I get the following error:

user warning: Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation ‘=’ query: SELECT aa.aid, a.type FROM trigger_assignments aa LEFT JOIN actions a ON aa.aid = a.aid WHERE aa.hook = ‘nodeapi’ AND aa.op = ‘view’ ORDER BY weight in /home/lanemax/public_html/modules/trigger/trigger.module on line 146.

I need you to fix whatever this error is, as well as telling me what was wrong so that it never happens again. :)

If you can do this, please place a bid.

Make Image Parralax + Funny

October 17th, 2009 Comments off

Goal, to make this image funny animated to get attention, using parrallax scroller (see the swf for what a Parralax scroller does generally)

- Use photoshop to separate out
pointing fingers, hands forams, arrms and body, head and background
so they stack nicely on top of each other.

- fill in the cut out areas in the images so that when panning they don’t show duplicates or holes. (e.g. where the hands are cut out of the shirt fill it in with black, where the body is cut out from the backgroudn fill it with yellow)

Once separated create 2 additional hand images where it looks like the forefingers are closed (like he’s pulling the trigger)

Import these onto flash at different levels as different movie clips.
Give each of these instances a name

Use the attached parallax engine ParallaxBox.as (see sample AS3 actionscript.txt on how to use it), and insert the clips into the engine script. Horizontal (side to side) movement
is more important than vertical.

On mouse down, swap back and forth on the open trigger finger to closed trigger finger as if he’s firing.

randomly place attach bullet holes (like he’s shooting through the TV screen) graphics to the front layer on these presses.

Excel Trigger Betting Sheet

August 1st, 2009 Comments off

I want an Excel spreadsheet that will trigger bets into the GRuss Betting Assistant which in turn will automatically place bets for me on the Betfair Betting Exchange. The process would be :-
At x seconds (customer variable from 1 to 60 seconds) before the official off-time of a horse race
place a back bet (Stake customer variable from

Ea For Mt4 Programer Required

June 28th, 2009 Comments off

*Input Slippage value (any vlaue ex. 1,1.5,2,4.5

Bear