My site is in production and need some extra work to improve it. The site is built on top of CakePHP with MySQL as a backend.
My original script is an open source and can be found at:
[url removed, login to view]
My site was integrated with twitter through its API by creating a page within the admin area of my site with the following features:
a. Admin will create a new keyword (hashtag, username or keyword) to track.
b. Once the keyword is created, the script will extract all tweets for for that keyword. It should keep searching as long the track is not disabled. (If real-time stream is not possible then it should refresh every 10 minutes.)
c. The script implement some regular expressions to clean the tweets by removing #, @ & RT:. The script should be smart enough to post media files appropriately in my site.
d. The script retrieve also username, name & image of user and other related information.
e. Each of extracted information should be stored in a certain place at the mysql.
f. the admin can disable,delete and add more keywords using the same method at the same time.
The site currently allow people to login with their twitter accounts to my site, get their basic information, such as photo, name ..etc.. Then post their message at the website as tweets in twitter.
The work needed to be done is in the attached file:
Please note that tasks might be modified and adjusted during the implementation phase. If you want the URL of my website, then please ask for it in private messages.