User:All is love love/Project page

Submission for the October 2011 Coding Challenge/Wikipedia Slideshow.

"Evolution is a change from an indefinite, incoherent, homogeneity to a definite, coherent, heterogeneity, through continuous
differentiations and integrations." ~ Herbert Spencer, First Principles (1862)

WikiJoy is a [new] way to transmit Wikipedia articles, it make possible say: "This article give me joy, and worth". In other words, its a user friendly form to avaliate content from a article.

So, when you read a article and enjoyed it, you can vote in the page content, approving it.

The project itself is a double side app:

* the user side just send some informations (page id, city and language) to the server;
* server receive data from users and save it in a database, and make this data avaliable by a simple API;

A possible problem would be create a empire of "pop" articles, but using more data from Wikimedia dumps is possible get ranks by Category, and spread [good] articles from any subjects. And using API its easy create new applications describing trends and good content.

User side

edit
/*
    wikiJoy
 Copyright (C) 2011 Jonas Xavier, Sóstenes Barros <jonas.agx and sostenesbarros @gmail.com>
 
    This program is free software; you can redistribute it and/or
    modify it under the terms of the GNU General Public License
    as published by the Free Software Foundation; either version 2
    of the License, or (at your option) any later version.
 
    This program is distributed in the hope that it will be useful,
    but WITHOUT ANY WARRANTY; without even the implied warranty of
    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
    GNU General Public License for more details.
 
    You should have received a copy of the GNU General Public License
    along with this program; if not, write to
 
    Free Software Foundation, Inc.
    51 Franklin Street, Fifth Floor
    Boston, MA   02110-1301, USA.
 
    or see this page : https://www.gnu.org/licenses/gpl-2.0.txt
 */
addOnloadHook( 
    function () {
        if (wgAction === 'view') {
            addPortletLink( 'p-views', 'javascript:doEnjoy()', 'enjoy', 'ca-enjoy', 'Enjoy this article' );
            getEnjoy();
        }
    });
 
doEnjoy = function () {
    $.ajax(
        {
            url: 'http://ifpedia.recife.ifpe.edu.br/wikijoy/joy_api.php',
            dataType: 'json',
            type: 'POST',
            data: { 
                pageId: wgArticleId,
                pageName: wgPageName,
                language: wgContentLanguage
            },
            success: function ( data ) {
                console.log(data.success);
            }
        });
};
 
getEnjoy = function () {
    $.ajax( 
        {
            url: 'http://ifpedia.recife.ifpe.edu.br/wikijoy/joy_api.php',
            dataType: 'json',
            data: {
                pageId: wgArticleId
            },
            success: function( data ) {
                $('#ca-enjoy a').attr('title', 'Enjoy this article. It was enjoyed ' + data.page.page_joycount + ' times.');
            }
        });
};

Server side

edit
/*
    wikiJoy
 Copyright (C) 2011 Jonas Xavier, Sóstenes Barros <jonas.agx and sostenesbarros @gmail.com>
 
    This program is free software; you can redistribute it and/or
    modify it under the terms of the GNU General Public License
    as published by the Free Software Foundation; either version 2
    of the License, or (at your option) any later version.
 
    This program is distributed in the hope that it will be useful,
    but WITHOUT ANY WARRANTY; without even the implied warranty of
    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
    GNU General Public License for more details.
 
    You should have received a copy of the GNU General Public License
    along with this program; if not, write to
 
    Free Software Foundation, Inc.
    51 Franklin Street, Fifth Floor
    Boston, MA   02110-1301, USA.
 
    or see this page : https://www.gnu.org/licenses/gpl-2.0.txt
 */
/******************* joy_util.php *******************/

<?php
    function getJoyConnection() {
        $conn = mysql_connect( 'localhost', 'root', 'root' ) or die ( 'MySQL Error.' );
        mysql_select_db( 'joy', $conn ) or die ( 'MySQL Error.' );
        return $conn;
    }

    /* Retorna um Array com as informacoes de uma entrada na tabela joy */
    function getJoyByPageId( $pageId ) {
        $conn = getJoyConnection();
        $query = sprintf( "SELECT * FROM joy WHERE page_id = '%s'", mysql_real_escape_string($pageId) );
        $result = mysql_query( $query, $conn ) or die ('MySQL Error.');

        if (mysql_num_rows( $result )) {
            $row = mysql_fetch_assoc($result);
        }
        mysql_close($conn);
        return $row;
    }

    /* Retorna um booleano informando se a pagina foi "enjoyed" */
    function pageEnjoyed($pageId) {
        $conn = getJoyConnection();
        $query = sprintf( "SELECT page_id FROM joy WHERE page_id = '%s'", mysql_real_escape_string($pageId) );
        $result = mysql_query( $query, $conn ) or die ('MySQL Error.');
        $numRows = mysql_num_rows( $result );
        mysql_close($conn);
        return ( $numRows > 0 ) ? true : false;
    }

    /* Insere um Joy referente a uma pagina. */
    function insertJoyPage($pageId, $pageTitle, $language) {
        $conn = getJoyConnection();
        $date =  new DateTime();
        $datefmt = $date->format('Y-m-d H:i:s');
        $success = false;
        $query = sprintf( "INSERT INTO joy (page_id, page_title, page_joycount, joy_timestamp, language) values ('%s', '%s', '%s', '%s', '%s')",
                          mysql_real_escape_string($pageId),
                          mysql_real_escape_string($pageTitle),
                          mysql_real_escape_string(1),
                          mysql_real_escape_string($datefmt),
                          mysql_real_escape_string($language) );
       $success = mysql_query( $query, $conn );
       mysql_close($conn);
       return $succes;
    }

    /* Atualiza o numero de Joys da pagina com id = $pageId  */
    function updateJoyPage($pageId, $joyCount) {
        $conn = getJoyConnection();
        $date = new DateTime();
        $datefmt = $date->format('Y-m-d H:i:s');
        $success = false;
        $query = sprintf("UPDATE joy SET page_joycount = '%s' WHERE page_id = '%s'",
                          mysql_real_escape_string($joyCount),
                          mysql_real_escape_string($pageId));
        $success = mysql_query( $query, $conn );

        mysql_close($conn);
        return $success;
    }

    function addJoy($pageId, $pageTitle, $language) {
        $success = false;
        if ( pageEnjoyed( $pageId ) ) {
            //echo "UPADATE: ";
            $page = getJoyByPageId( $pageId );
            $success = updateJoyPage( $pageId, $page['page_joycount'] + 1 );
        } else {
            //echo "INSERT: ";
            $success = insertJoyPage( $pageId, $pageTitle, $language );
        }
        return $success;
    }

    function getRanking(){
        $conn = getJoyConnection();
        $query = "SELECT j.page_joycount, j.page_title FROM joy j order by j.page_joycount desc limit 10";
        $result = mysql_query($query, $conn);
        while($r[]=mysql_fetch_array($sql));
        return json_encode( $r );
    }

?>
/******************* joy_api.php *******************/

<?php
    require_once './joy_utils.php';

    $request_method = strtolower( $_SERVER['REQUEST_METHOD'] );

    switch ($request_method) {
        case 'post':
            if ( isset( $_POST['pageId'] )
                && isset( $_POST['pageName'] )
                && isset( $_POST['language'] )) {
                $result = addJoy($_POST['pageId'], $_POST['pageName'], $_POST['language']);

            } else {
                echo "Required Fields:<br />
                      pageId: Article Id.<br />
                      pageName: Article Name.<br />
                      language: Article Language (ex.: pt-BR).<br />";
            }
            $response = array('succes' => $result);
            echo json_encode($response);
            return;
        break;
        case 'get':
            if ( isset( $_GET['pageId'] ) ) {
                $result = getJoyByPageId($_GET['pageId']);
                if (empty( $result )) {
                    $result['page_joycount'] = 0;
                    echo json_encode(array( 'page' => $result ));

                } else {
                    echo json_encode(array('page' => $result));
                }
            }
            return;
        break;
        default:
           echo 'Request Method not suported: ' . $request_method;
    }
?>
/*
    wikiJoy
 Copyright (C) 2011 Jonas Xavier, Sóstenes Barros <jonas.agx and sostenesbarros @gmail.com>
 
    This program is free software; you can redistribute it and/or
    modify it under the terms of the GNU General Public License
    as published by the Free Software Foundation; either version 2
    of the License, or (at your option) any later version.
 
    This program is distributed in the hope that it will be useful,
    but WITHOUT ANY WARRANTY; without even the implied warranty of
    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
    GNU General Public License for more details.
 
    You should have received a copy of the GNU General Public License
    along with this program; if not, write to
 
    Free Software Foundation, Inc.
    51 Franklin Street, Fifth Floor
    Boston, MA   02110-1301, USA.
 
    or see this page : https://www.gnu.org/licenses/gpl-2.0.txt
 */
create table joy(
	page_id int primary key, 
	page_title varchar(255),
	page_joycount int, 
	joy_timestamp timestamp, 
	language varchar(10)
);

create table category(
	page_id int, 
	category_id int, 
	category varchar(255)
);

create table user(
	user_id int unsigned NOT NULL primary key,
	page_id int unsigned NOT NULL,
	joy_timestamp timestamp
);