Skip to main content

Posts

Showing posts with the label mysql

VW Interactive Ad Unit

Built the API services for an Ad unit that is personalized for each CBS fantasy football team. Each team plays 10 unique questions each week and earn points.  Leader board for each league.  History for last week's score. 

How to get WordPress posts permalinks using SQL(database) alone

SELECT wpp.post_title, wpp.post_type, wpp.guid, wpp.post_date, CONCAT( wpo_su.option_value, REPLACE( REPLACE( REPLACE( REPLACE( REPLACE( wpo.option_value, '%year%', DATE_FORMAT( wpp.post_date, '%Y' ) ) ,'%monthnum%', DATE_FORMAT( wpp.post_date, '%m' ) ) , '%day%', DATE_FORMAT( wpp.post_date, '%d' ) ) , '%postname%', wpp.post_name ) , '%category%', wpp.post_type ) ) AS permalink FROM wp_posts wpp INNER JOIN wp_options wpo ON wpo.option_name = 'permalink_structure' INNER JOIN wp_options wpo_su ON wpo_su.option_name = 'siteurl' WHERE ( wpp.post_type = 'post' OR wpp.post_type = 'page' ) AND wpp.post_status = 'publish'

A Target campaign

A micro site that allows user to get a free mp3 download after Facebook authentication. The site is written in PHP with MySQL database. Application features: Limits one download per user.  Integration with real-time music purchasing and download. Location restriction by user IP address. Integration with Email injection services. Twitter, Instagram and Facebook user authentication process. Works on both desktop and mobile web browsers. Supports high volume of traffic. moreshakira.target.com

Anthem Connects

This site is built using the CodeIgniter PHP framework. Very happy with this framework so far. It does everything I wanted a framework to do. The site is mostly static content except the Health Footprint and 10-day boost sections. The Health Footprint Calculator is heavy on Javascript. The front-end experience was built using jQuery. The back-end is driven by PHP and MySQL. Users can register account, take the quiz and track their scores. A admin tool was also included. It allows the admin to add new questions, answers, weight for each answer, The 10-day boost is simple. List of youtube videos plus some social elements. Development time: 3 weeks Site URL: http://connects.anthem.com

Clash of the Titans Fankit

I worked on a Fankit web application for Harry Potter back in July 2009 while I was at Crew Creative. It was created in a way that it can be reused for other sites easily. Today I saw Clash of the Titans Fankit site is up. I'm happy that Warner Bros likes the application and decided to use it again. This means a lot to me.

ReBuildUS, my first startup experience

After Crew Creative closed down, I decided to join a startup company( ReBuildUS.com ) that is building a online foreclosure marketplace platform. The company has a great business model and mission statement. To put distressed residential properties back into productive use. To rebuild communities by filling the holes left by foreclosure. To create jobs and the opportunity for financial independence. To give hard-working Americans a new way to buy a house. To rebuild the American Dream. After some nights and weekends, the site is launched today. Check it out, you may find a house you like.

Harry Potter Muggle Hub

One of my biggest project. Harry Potter Muggle Hub is a central place for fans to find interesting things to put on their own web site or social site profile. It is built from ground up like most of the projects I did. It comes with a nice CMS which allows the admin to control almost everything on the site including each module's content and their display order. The admin can create different Muggle Hub for different territory using the CMS. Admin can import content from different territory to reduce redundant work. Time spent: 6 weeks Programming: PHP, MySQL, Smarty Site URL: http://www.mugglehub.com

AEMA

A job posting page plus a simple tool that allows administrator to view and download resumes. Programming Languages: PHP, MySQL, Smarty http://aema.net/jobs/

Crew Labs

A project for Crew Creative. Crew Labs has a 10 steps entry form. Each step has complex validation logic. It also includes a tool for the judges to rate the film and keep track of submission status and results. Programming Languages: PHP, MySQL, Smarty, PEAR, jQuery http://www.crewcreative.com/crewlabs/submission/?x=step1

I DO!

I DO! is a community site that encourage people to vote NO on Prop 8 on Nov. 4th. You register, complete your profile and spread the words by sending invitations to all the people you know. I coded the site from scratch including the Database. GD image was used to resize user uploaded avatars. Programming Languages: PHP, MySQL, Smarty, PEAR http://ido.lovehonorcherish.org/

The Secret Life of Bees Facebook App

It is a re-skin of the Get Rambo'd app plus upgrade to the new Facebook API. It is a good project for me to catch up with the new APIs. Programming Languages: PHP, MySQL, Smarty, PEAR http://www.facebook.com/apps/application.php?id=11565967109

Crew Newsletter CMS

It's an internal project. I did it for Crew so they can put up a company wide newsletter easier and faster every month. The difference between this CMS and the previous ones are Ajax file uploading and jQuery. I switched from prototype to jQuery and I liked it better. It is lightweight, fast, easy to use, better error handling and more plug-ins. Language: PHP, MySQL, Smarty, jQuery

Planet Green G-Quiz Facebook App

A Facbook application which has a daily quiz, leader board and newsletter opt-in. It also has a CMS that allows the admin to input all the quizzes and day of the tips. Language: PHP, MySQL, Smarty http://www.facebook.com/apps/application.php?id=11871495534

Plantabillion.org CMS

More More CMS. What would be better than updating a site with no extra cost. Who wouldn't want a CMS for their site? Same as the last one with an extra Help button on the upper right. Now, you know where to get help using the CMS. Language: PHP, MySQL, Smarty, Javascript http://plantabillion.org

The Bourne Conspiracy Game CMS

Another beautiful CMS bases on the Discovery Studio one. A few more functions were added to this CMS. It allows the admin to enter contents for this multi-language site. It has publish, unpublish and preview function which are very handy. You don't want to push something live that doesn't look right. Language: PHP, MySQL, Smarty, Javascript http://www.bournethegame.com/

Discovery Studios

I spent about three weeks to build both the public site and the CMS from ground up which including design the database and overall back-end structure. About Us section use Ajax to load the profile on click. Television section use a Flash video player which loads in XML that is generated using PHP. The site also has a section that is only available for logged in users. Some contents are available for download only if the user belongs to a certain group. The CMS is the most important part of the web site. It includes user/group management for the login and download. For every content, the admin has the ability to add/upload, edit, delete and reorder using a friendly web user interface. It also has WYSIWYG editor for easy editing. Language: PHP, MySQL, Smarty, PEAR, Javascript, xajax http://discoverystudios.com

Barpintxo

This site is driven by a CMS which was built from ground up. Almost all contents could be updated using the CMS. The wine quiz was built using xajax. The CMS including add, edit, delete and drag to reorder contents. Language: PHP, MySQL, xajax, Smarty, Pear, Javascript http://www.barpintxo.com

Funny Games Facebook Application

A Facebook application which determines your personality base on how you answer all the questions. Each question has different weight. You can also compare your personality with your friends and see how compatible between you. Language: PHP, MySQL, Smarty, Pear http://www.facebook.com/apps/application.php?id=9133651802

Get Rambo'd Facebook Application

This is my first Facebook Application which was built using PHP, MySQL and FBML. http://www.facebook.com/apps/application.php?id=17391980563