In Progress

PHPList and e107 CMS integration

Looking for someone to help on several projects and aspects of projects. Must have very good skill in PHP, AJAX and MySQL. Experience in the e107 CMS very helpful.

Interested in a person with time available, that wants a long-term relationship. Must:

(1) Be available and not always "too busy" to do the work

(2) Be a fast learner and keep good notes so I don't have to explain things over and over

(3) Be a good communicator

First project is to write a script to run as a chron job to pull data from one set of tables into another:

(1)

update table list l from table e107_userclass_classes uc:

update [url removed, login to view] = uc.userclass_id, l.name= uc.userclass_name, l.description=uc.userclass_description

Logic:

loop through table e107_userclass_classes and find out if there are any values in there missing or out of synch in table list, then update table list with these values.

(2)

update the table listuser from e107_user, updating userid to listid links from user_class

(3)

update the table user_user uu from e107_user u, updating values for:

[url removed, login to view] from u.user_id

[url removed, login to view] from u.user_email

(4)

update table user_user_attribute ua from e107_user u

[url removed, login to view] from u.user_id

ua.attributeid=1

ua.value=u.user_login

Skills: AJAX, MySQL, PHP

See more: e107 ajax, ajax e107, work ua, job in cms, explain ajax, write php and mysql, email list pull, data synch, Data Integration, help cms, php ajax cms, mysql update values, update values mysql, ajax php mysql update, loop table, missing table, php cms update, script update mysql tables, userid, script update mysql table ajax, mysql project cms, integration data, loop table php, ajax mysql php update, ajax integration

About the Employer:
( 19 reviews ) Lompoc, United States

Project ID: #1291840

Awarded to:

Mindon

check the PMB please.thanks.

$20 USD / hour
(62 Reviews)
6.1

4 freelancers are bidding on average $20/hour for this job

dboyzhang

Hello, please see PMB.

$20 USD / hour
(228 Reviews)
6.9
thelogicgates1

Hi, Ready to start. Check PMB please.

$19 USD / hour
(47 Reviews)
6.6
webdeveloper02

Dear Sir , I would like to work for you on our project 40 hours in a week. Please check our PMB for more detail. Thanks Amar Panchal

$20 USD / hour
(0 Reviews)
0.0