MySQL update trigger for jos_rsform_submission_values table

Cancelled Posted Feb 20, 2013 Paid on delivery
Cancelled Paid on delivery

Tables:

a) jos_rsform_submission_values (this is RS Form Pro 1.4 table)

b) cm_rsform_article_update (columns: id, form_id, submission_id, article_text, article_id)

In the cm_rsform_article_update table:

id: auto_increment column

form_id: refers to FormId column in jos_rsform_submission_values

submission_id: refers to SubmissionId column in jos_rsform_submission_values

article_id: refers to id column in jos_content

article_text: see sample value for this column below:

Affiliations

{affiliations:value}

Achievements

{achievements:value}

On after UPDATE trigger on 'jos_rsform_submission_values' table:

1) replace values in {} brackets with relevant values in jos_rsform_submission_values

2) Update intro_text column in jos_content table for corresponding article_id's in cm_rsform_article_update table with value obtained in step 1

3) Repeat steps 1 and 2 for all rows in cm_rsform_article_update table

The code should work for:

1. Joomla 1.5

2. MySQL 5.1

3. RS Form Pro 1.4

Joomla MySQL PHP

Project ID: #4264656

About the project

5 proposals Remote project Active Feb 23, 2013

5 freelancers are bidding on average $90 for this job

gopalvora

ready to start Thanks

$70 USD in 4 days
(149 Reviews)
6.7
hunterboss

Dear friend Please check your PMB to see more detail. Thank you

$100 USD in 5 days
(92 Reviews)
6.5
sunilexpert

I am an expert web developer with 8+ years of developing dynamic web applications and websites. I have understood and able to visualize what you are looking for, I can do this job quickly with quality.

$100 USD in 2 days
(38 Reviews)
5.5
truongngocthanh

Hello, I can do it quickly for you. Please check your private message for more detail. Thank you

$80 USD in 1 day
(6 Reviews)
3.8
joomlavenus

Hi D&D, I can do it, and ready to start.

$100 USD in 2 days
(2 Reviews)
2.0