<?php
require_once("ObjectChat.php");
require_once("ObjectGraphic.php");
require_once("ObjectLocation.php");
require_once("Common_Functions.php");
require_once("Constants.php");
//define("AMFPHP_BASE", "../../core/");
//require_once("../../core/shared/util/Authenticate.php");


class ProteanObject {

    var $methodTable = array(
        "pushObject" => array("description" => "Pushes a protean object to the server db","access" => "remote","roles" => "admin,user"),
        "getNewObjects" => array("description" => "Fetches new protean objects from the server db","access" => "remote","roles" => "admin,user,guest"),
        "deleteObject" => array("description" => "Deletes a protean object from the server db","access" => "remote","roles" => "admin,user"),
        "getNewChats" => array("description" => "Gets new chats from the server db","access" => "remote","roles" => "admin,user,guest"),
        "pushNewMessage" => array("description" => "Pushes a chat message into the server db","access" => "remote","roles" => "admin,user,guest"),
        "getNewFiles" => array("description" => "Fetches new files' info from the server db","access" => "remote","roles" => "admin,user,guest"),
        "getProjectDetails" => array("description" => "Gets project details for the project logged into","access" => "remote","roles" => "admin,user,guest"),
        "pushNewFile" => array("description" => "Pushes a file's info to the server db","access" => "remote","roles" => "admin"),
        "deleteFile" => array("description" => "Deletes a files' info from the server db","access" => "remote","roles" => "admin"),
        "registerCbr" => array("description" => "Registers a collaborator into a project - also logs them into the project if registered","access" => "remote","roles" => "admin,user,guest"),
        "getUpdates" => array("description" => "Get updates from the updation timeline","access" => "remote","roles" => "admin,user,guest"),
        "unregCbr" => array("description" => "Logs out a collaborator from a project","access" => "remote","roles" => "admin,user,guest"),
        "getUsers" => array("description" => "Get a list of all collaborators for the project presently logged into","access" => "remote","roles" => "admin,user,guest"),
        "getAllChats" => array("description" => "Gets all chats for the present project","access" => "remote","roles" => "admin,user,guest"),
        "getProjects" => array("description" => "Gets all projects for which the present user is registered","access" => "remote","roles" => "admin,user,guest"),
        "addProject" => array("description" => "Adds a new project","access" => "remote","roles" => "admin"),
        "deleteProject" => array("description" => "Deletes a project","access" => "remote","roles" => "admin"),
        "addUserAndCbr" => array("description" => "Adds a new user and then calls addCbr","access" => "remote","roles" => "admin"),
        "addCbr" => array("description" => "Adds a collaborator to a project","access" => "remote","roles" => "admin"),
        "getFilesForProjects" => array("description" => "Gets all files for an array of Project Ids","access" => "remote","roles" => "admin")
    );

    public $id;
    public $file_id;
    public $project_id;
    public $creator;
    public $objChat;
    public $objGraphic;
    public $objLocation;

    function beforeFilter($function_called) {
        if(array_key_exists($function_called,$this->methodTable)) {
            if(Authenticate::isUserInRole($this->methodTable[$function_called]["roles"])==true) {
                return true;
            }
            else {
                return false;
            }
        }
        else {
            return true;
        }
    }

    public function pushObject($pobj=NULL) {
        $this->file_id = $pobj['file_id'];
        $this->project_id = $pobj['project_id'];
        $this->creator = $pobj['creator'];
        $this->objChat = $pobj['objChat'];
        $this->objGraphic = $pobj['objGraphic'];
        $this->objGraphic['created'] = getLocalTime();
        $this->objLocation = $pobj['objLocation'];

        $loc = serialize($this->objLocation);
        $gra = serialize($this->objGraphic);
        $cha = serialize($this->objChat);
/*      $myFile = "log1.txt";
        $fh = fopen($myFile, 'w');
        fwrite($fh, $loc);
        fclose($fh);*/

        $sql_connection = connect_to_db();
        $query = "INSERT INTO project".$this->project_id."
                    (`object_file_id`,`object_creator`,`object_location`,`object_graphic`,`object_chat`)
                    VALUES ({$this->file_id},'{$this->creator}','{$loc}','{$gra}','{$cha}')";
        $result_set = mysql_query($query);
        confirm_query($result_set);
        $this->id = mysql_insert_id();
        mysql_close($sql_connection);
        $this->serverUpdate($this->project_id,"newmarkup",$this->file_id,4);
    }

    public function getLocationsByFileId($f_id,$p_id) {
        $sql_connection = connect_to_db();
        $query = "SELECT object_location
                    FROM project".$p_id."
                    WHERE object_file_id={$f_id}";
        $result_set = mysql_query($query,$sql_connection);
        confirm_query($result_set);
        $loc_set = array();
        while($result = mysql_fetch_array($result_set)) {
            $loc_set[] = unserialize($result['object_location']);
        }
        mysql_close($sql_connection);
        return $loc_set;
    }

    public function getGraphicsByLocation($loc,$f_id,$p_id) {
        //$objl = new ObjectLocation;
        //$objl->type = $loc['type'];
        //$objl->value = $loc['value'];
        //$sloc = serialize($objl);
        $this->objLocation = $loc;
        $sloc = serialize($this->objLocation);
        $myFile = "log2.txt";
        $fh = fopen($myFile, 'w');
        fwrite($fh, $sloc);
        fclose($fh);
        $sql_connection = connect_to_db();
        $query = "SELECT object_graphic
                    FROM project".$p_id."
                    WHERE object_file_id={$f_id}
                    AND object_location='".$sloc."'";
        $result_set = mysql_query($query,$sql_connection);
        confirm_query($result_set);
        $gra_set = array();
        while($result = mysql_fetch_array($result_set)) {
            $gra_set[] = unserialize($result['object_graphic']);
        }
        mysql_close($sql_connection);
        return $gra_set;
    }

    public function getNewObjects($f_id,$p_id,$latest_object_id) {
        $sql_connection = connect_to_db();
        $query = "SELECT *
                    FROM project".$p_id."
                    WHERE object_file_id={$f_id}
                    AND object_id>{$latest_object_id}";
        $result_set = mysql_query($query,$sql_connection);
        confirm_query($result_set);
        $poArray = array();
        while($result = mysql_fetch_array($result_set)) {

            $pobj = new ProteanObject;
            $pobj->id = $result['object_id'];
            $pobj->project_id = $p_id;
            $pobj->file_id = $f_id;
            $pobj->creator = $result['object_creator'];
            $pobj->objLocation = unserialize($result['object_location']);
            $pobj->objGraphic = unserialize($result['object_graphic']);
            $pobj->objChat = unserialize($result['object_chat']);

            $poArray[] = $pobj;
        }
        mysql_close($sql_connection);
        return $poArray;
    }
    public function deleteObject($f_id,$p_id,$object_id) {
        $sql_connection = connect_to_db();
        $query = "DELETE FROM project".$p_id."
                    WHERE object_file_id=".$f_id."
                    AND object_id=".$object_id."
                    LIMIT 1";
        $result_set = mysql_query($query,$sql_connection);
        confirm_query($result_set);
        mysql_close($sql_connection);
        return $result_set;
    }

    public function getAllChats($p_id) {
        $sql_connection = connect_to_db();
        $query = "SELECT *
                    FROM chats
                    WHERE chat_project_id={$p_id}";
        $result_set = mysql_query($query,$sql_connection);
        confirm_query($result_set);
        $resultArray = array();
        while($result = mysql_fetch_array($result_set)) {
            $resultArray[] = $result;
        }
        mysql_close($sql_connection);
        return $resultArray;
    }

    public function getNewChats($p_id,$chat_id) {
        $sql_connection = connect_to_db();
        $query = "SELECT *
                    FROM chats
                    WHERE chat_project_id={$p_id}
                    AND chat_id>{$chat_id}";
        $result_set = mysql_query($query,$sql_connection);
        confirm_query($result_set);
        $resultArray = array();
        while($result = mysql_fetch_array($result_set)) {
            $resultArray[] = $result;
        }
        mysql_close($sql_connection);

        return $resultArray;
    }

    public function pushNewMessage($p_id,$creator,$text) {
        $created = getLocalTime();
        $sql_connection = connect_to_db();
        $query = "INSERT INTO chats
                    (`chat_project_id`,`chat_creator`,`chat_created`,`chat_text`)
                    VALUES ('{$p_id}','{$creator}','{$created}','{$text}')";
        $result_set = mysql_query($query);
        confirm_query($result_set);
        mysql_close($sql_connection);
        $this->serverUpdate($p_id,"newchat",$creator,3);
    }

    public function getNewFiles($p_id,$file_id) {
        $sql_connection = connect_to_db();
        $query = "SELECT file_id,file_name,file_link,file_type
                    FROM files
                    WHERE file_project_id={$p_id}
                    AND file_id>{$file_id}";
        $result_set = mysql_query($query,$sql_connection);
        confirm_query($result_set);
        $resultArray = array();
        while($result = mysql_fetch_array($result_set)) {
            $resultArray[] = $result;
        }
        mysql_close($sql_connection);
        return $resultArray;
    }

    public function getProjectDetails($p_id) {
        $sql_connection = connect_to_db();
        $query = "SELECT project_name, project_create_date
                    FROM projects
                    WHERE project_id={$p_id}
                    LIMIT 1";
        $result_set = mysql_query($query,$sql_connection);
        confirm_query($result_set);
        $result = mysql_fetch_array($result_set);
        mysql_close($sql_connection);
        return $result;
    }

    public function pushNewFile($f_pid,$f_name,$f_link,$f_type,$f_uploader) {
        $sql_connection = connect_to_db();
        $query = "SELECT file_id
                    FROM files
                    WHERE file_name='{$f_name}'
                    AND file_project_id={$f_pid}";
        $result_set = mysql_query($query);
        confirm_query($result_set);
        if($r = mysql_fetch_array($result_set)) {
            return false;
        }
        $query = "INSERT INTO files
                    (`file_project_id`,`file_name`,`file_uploader`,`file_link`,`file_type`)
                    VALUES ('{$f_pid}','{$f_name}','{$f_uploader}','{$f_link}',{$f_type})";
        $result_set = mysql_query($query);
        confirm_query($result_set);
        mysql_close($sql_connection);
        $this->serverUpdate($f_pid,"newfileadded",$f_uploader,1);
        return true;
    }

    public function deleteFile($f_pid,$f_name,$cbr_name) {
        $sql_connection = connect_to_db();
        $query = "DELETE FROM files
                    WHERE `file_project_id`=".$f_pid."
                    AND file_name='".$f_name."'
                    LIMIT 1";
        $result_set = mysql_query($query);
        confirm_query($result_set);
        mysql_close($sql_connection);
        $this->serverUpdate($f_pid,"filedeleted",$cbr_name,1);
        return $result_set;
    }

    public function getUsers($project_id) {
        $sql_connection = connect_to_db();
        $query = "SELECT * FROM collaborators
                    WHERE collaborator_project_id={$project_id}";
        $result_set = mysql_query($query);
        confirm_query($result_set);
        mysql_close($sql_connection);
        return $result_set;
    }

    public function registerCbr($project_id,$cbr_name,$cbr_email="") {
        $sql_connection = connect_to_db();
        $query = "SELECT * FROM collaborators
                    WHERE collaborator_name='{$cbr_name}'
                    AND collaborator_project_id={$project_id}
                    AND collaborator_status='offline'";
        $cbr_result_set = mysql_query($query);
        confirm_query($cbr_result_set);
        $time = getLocalTime();
        if(mysql_num_rows($cbr_result_set)>0) {
            $query = "UPDATE collaborators
                        SET collaborator_status='online'
                        WHERE collaborator_name='{$cbr_name}'
                        AND collaborator_project_id={$project_id}";
            $result_set = mysql_query($query);
            confirm_query($result_set);
        }
        else {
            return false;
        }
        $query = "SELECT update_id
                    FROM updates
                    WHERE update_time<'{$time}'
                    ORDER BY update_id DESC
                    LIMIT 1";
        $result_set = mysql_query($query);
        confirm_query($result_set);
        if($result = mysql_fetch_array($result_set)) {
            $latest_update_id=$result['update_id']+1;
        }
        else {
            $latest_update_id=0;
        }
        mysql_close($sql_connection);
        $this->serverUpdate($project_id,"useronline",$cbr_name,2);
        return array($latest_update_id);
    }

    public function getUpdates($project_id,$latest_update_id,$cbr_name) {
        $sql_connection = connect_to_db();
        $time = getLocalTime();
        $query = "UPDATE collaborators
                    SET collaborator_pinged='{$time}'
                    WHERE collaborator_project_id={$project_id}
                    AND collaborator_name='{$cbr_name}'";
        $result_set = mysql_query($query);
        confirm_query($result_set);
        $query = "SELECT update_id,update_header,update_body
                    FROM updates
                    WHERE update_project_id={$project_id}
                    AND update_id>{$latest_update_id}";
        $result_set = mysql_query($query);
        confirm_query($result_set);
        //return $result_set;
        $resultArray = array();
        while($result = mysql_fetch_array($result_set)) {
            //$updateLine = new Array();
            $updateLine['update_id']=$result['update_id'];
            $updateLine['update_header']=$result['update_header'];
            $updateLine['update_body']=unserialize($result['update_body']);
            $updateLine['update_level']=$result['update_level'];
            $resultArray[] = $updateLine;
        }
        mysql_close($sql_connection);
        return $resultArray;
    }

    public function serverUpdate($project_id,$header,$body,$level) {
        $sql_connection = connect_to_db();
        $time = getLocalTime();
        $newBody = serialize($body);                                    // body is serialized
        $query = "INSERT INTO updates
                    (`update_project_id`,`update_header`,`update_body`,`update_level`,`update_time`)
                    VALUES ({$project_id},'{$header}','{$newBody}',{$level},'{$time}')";
        $result_set = mysql_query($query);
        confirm_query($result_set);
        mysql_close($sql_connection);
    }

    public function unregCbr($project_id,$cbr_name) {
        $sql_connection = connect_to_db();
        $query = "UPDATE collaborators
            SET collaborator_status = 'offline'
            WHERE collaborator_project_id={$project_id}
            AND collaborator_name='{$cbr_name}'";
        $result_set = mysql_query($query);
        confirm_query($result_set);
        mysql_close($sql_connection);
        $this->serverUpdate($project_id,"useroffline",$cbr_name,2);
    }

    public function userLogin($username,$pass) {
        $sql_connection = connect_to_db();
        $hashed_pass = sha1($pass);
        $query = "SELECT user_roles
                    FROM users
                    WHERE user_name='".$username."'
                    AND user_pass='".$hashed_pass."'
                    LIMIT 1";
        $result_set = mysql_query($query);
        confirm_query($result_set);
        if($result=mysql_fetch_array($result_set)) {
            $query = "SELECT collaborator_project_id
                        FROM collaborators
                        WHERE collaborator_name='{$username}'
                        AND collaborator_status='online'
                        LIMIT 1";
            $rs = mysql_query($query);
            confirm_query($rs);
            if($r = mysql_fetch_array($rs)) {
                return false;
            }
            Authenticate::login($username,$result['user_roles']);
            mysql_close($sql_connection);
            return $result['user_roles'];
        }
        mysql_close($sql_connection);
        return false;
    }
    public function check_if_logged_in() {
        return Authenticate::isAuthenticated();
    }
    public function getProjects($username) {
        $sql_connection = connect_to_db();
        $query = "SELECT project_id,project_name
                    FROM projects
                    WHERE project_id IN
                    (SELECT collaborator_project_id FROM collaborators WHERE collaborator_name='{$username}')";
        $result_set = mysql_query($query);
        confirm_query($result_set);
        $resultArray = array();
        while($result = mysql_fetch_array($result_set)) {
            $resultArray[]=array("project_id"=>$result['project_id'],"project_name"=>$result['project_name']);
        }
        mysql_close($sql_connection);
        return $resultArray;
    }

    public function addProject($pname,$cname) {
        $created = getLocalTime();
        $sql_connection = connect_to_db();
        $query = "SELECT project_id
                    FROM projects
                    WHERE project_name='{$pname}'";
        $result_set = mysql_query($query);
        confirm_query($result_set);
        if($result = mysql_fetch_array($result_set)) {
            return false;
        }
        $query = "INSERT INTO projects
                    (project_name,project_create_date)
                    VALUES ('{$pname}','{$created}')";
        $result_set = mysql_query($query);
        confirm_query($result_set);
        $pid = mysql_insert_id();
        $query = "CREATE TABLE `project".$pid."` (
                    `object_id` BIGINT( 20 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
                    `object_file_id` BIGINT( 20 ) NOT NULL ,
                    `object_creator` VARCHAR( 20 ) NOT NULL ,
                    `object_location` BLOB NOT NULL ,
                    `object_graphic` BLOB NOT NULL ,
                    `object_chat` BLOB NOT NULL
                    ) ENGINE = MYISAM ;";
        $result_set = mysql_query($query);
        confirm_query($result_set);
        $query = "INSERT INTO collaborators
                    (collaborator_project_id,collaborator_name,collaborator_status)
                    VALUES ({$pid},'{$cname}','offline')";
        $result_set = mysql_query($query);
        confirm_query($result_set);
        mysql_close($sql_connection);
        $this->serverUpdate($pid,"newprojectadded",$pname,1);
        return true;
    }
    public function deleteProject($pid) {
        $sql_connection = connect_to_db();
        $query = "DELETE FROM projects
                    WHERE project_id={$pid}
                    LIMIT 1";
        $result_set = mysql_query($query);
        confirm_query($result_set);

        $query = "DROP TABLE project{$pid}";
        $result_set = mysql_query($query);
        confirm_query($result_set);

        $query = "DELETE FROM collaborators
                    WHERE collaborator_project_id={$pid}";
        $result_set = mysql_query($query);
        confirm_query($result_set);

        $query = "DELETE FROM chats
                    WHERE chat_project_id={$pid}";
        $result_set = mysql_query($query);
        confirm_query($result_set);

        $query = "DELETE FROM files
                    WHERE file_project_id={$pid}";
        $result_set = mysql_query($query);
        confirm_query($result_set);
        mysql_close($sql_connection);
    }

    public function getAllUsers() {
        $sql_connection = connect_to_db();
        $query = "SELECT user_id,user_name
                    FROM users";
        $result_set = mysql_query($query);
        confirm_query($result_set);
        $resultArray = array();
        while($result = mysql_fetch_array($result_set)) {
            $resultArray[] = array("user_id" => $result['user_id'],"user_name" => $result['user_name']);
        }
        mysql_close($sql_connection);
        return $resultArray;
    }

    public function addUserAndCbr($uname,$umail,$ulevel,$msg,$pid) {
        switch($ulevel) {
            case '2':
                $urole = "user";
                break;
            case '3':
                $urole = "guest";
                break;
            default:
                return false;
        }
        $upass = createRandomPassword();
        $hpass = sha1($upass);
        $sql_connection = connect_to_db();
        $query = "INSERT INTO users
                    (user_name,user_pass,user_email,user_roles)
                    VALUES ('{$uname}','{$hpass}','{$umail}','{$urole}')";
        $result_set = mysql_query($query);
        confirm_query($result_set);
        $uid = mysql_insert_id();
        mysql_close($sql_connection);
        $sub = "Welcome to Protean by Krayon";
        $body = "Hi.\n\nYou have been added as a {$urole} on Protean - Multimedia Collaboration Suite. All you need to do now is install Protean Desktop client and login using the following details:\nUsername: {$uname}\nPassword: {$upass}\n\nYou will shortly receive a message telling you about the project you have been invited to.\n\n";
        //echo $body;
        $to = "<".$umail.">";
        mail($to,$sub,$body,"FROM: Krayon - ProteanMail <proteanmail.krayon@gmail.com>");
        $this->addCbr($pid,$uid,$msg);
    }

    public function addCbr($pid,$uid,$msg) {
        $sql_connection = connect_to_db();
        $query = "SELECT user_name,user_email
                    FROM users
                    WHERE user_id={$uid}
                    LIMIT 1";
        $result_set = mysql_query($query);
        confirm_query($result_set);
        if($result = mysql_fetch_array($result_set)) {
            $uname = $result['user_name'];
            $umail = $result['user_email'];
            $query = "INSERT INTO collaborators
                        (collaborator_project_id,collaborator_name,collaborator_email,collaborator_status)
                        VALUES ({$pid},'{$uname}','{$umail}','offline')";
            $cresult_set = mysql_query($query);
            confirm_query($cresult_set);
            $query = "SELECT project_name
                        FROM projects
                        WHERE project_id={$pid}
                        LIMIT 1";
            $presult_set = mysql_query($query);
            confirm_query($presult_set);
            $presult = mysql_fetch_array($presult_set);
            mysql_close($sql_connection);
            $sub = "You have been invited to a new project on Protean";
            $body = "Hi,\nYou have been invited to the project \"{$presult['project_name']}\"";
            if($msg!="") {
                $body .= " with the message:\n\n".$msg."\n\n";
            }
            $body .= "The next time you log into protean, you can see that this project has been added to your list of projects.";
            //echo $body;
            $to = "<".$umail.">";
            mail($to,$sub,$body,"FROM: Krayon - ProteanMail <proteanmail.krayon@gmail.com>");
            $this->serverUpdate($pid,"newcollaboratoradded",null,1);
            return true;
        }
        mysql_close($sql_connection);
        return false;
    }

    public function getFilesForProjects($p_ids_array,$p_names_array) {
        if($p_ids_array==null || $p_names_array==null) {
            return;
        }
        $sql_connection = connect_to_db();
        $result_array = array();
        $len = count($p_ids_array);
        for ($i=0;$i<$len;$i++) {
            $pid = $p_ids_array[$i];
            $pname = $p_names_array[$i];
            $query = "SELECT file_name,file_link
                        FROM files
                        WHERE file_project_id={$pid}";
            $result_set = mysql_query($query);
            confirm_query($result_set);
            $files = array();
            while($result = mysql_fetch_array($result_set)) {
                $files[] = array("name" => $result['file_name'],"link" => $result['file_link']);
            }
            $result_array[] = array("pname" => $pname, "pfiles" => $files);
        }
        mysql_close($sql_connection);
        return $result_array;
    }
    public function startSync($pid,$uname) {                        // access - only admin
        $sql_connection = connect_to_db();
        $query = "UPDATE settings
                    SET setting_value='{$uname}'
                    WHERE setting_name='sync_status'";
        $result_set = mysql_query($query);
        confirm_query($result_set);
        $query = "UPDATE settings
                    SET setting_value={$pid}
                    WHERE setting_name='sync_project'";
        $result_set = mysql_query($query);
        confirm_query($result_set);
        $this->serverUpdate($pid,"syncstart",array("project_id" => $pid,"sync_head" => $uname),5);
    }
    public function endSync($p_id) {                                    // access - admin
        $sql_connection = connect_to_db();
        $query = "UPDATE settings
                    SET setting_value=-1
                    WHERE setting_name='sync_status'";
        $result_set = mysql_query($query);
        confirm_query($result_set);
        $query = "UPDATE settings
                    SET setting_value=-1
                    WHERE setting_name='sync_project'";
        $result_set = mysql_query($query);
        confirm_query($result_set);
        $this->serverUpdate($p_id,"syncend",null,5);
    }

    public function syncFileUpdate($uname,$p_id,$f_id) {                // access - all
        $sql_connection = connect_to_db();
        $query = "SELECT setting_value
                    FROM settings
                    WHERE setting_name='sync_status'";
        $result_set = mysql_query($query);
        confirm_query($result_set);
        $sync_head = mysql_fetch_array($result_set);
        if($sync_head == -1) {
            return;
        }
        else if($sync_head==$uname) {
            $this->serverUpdate($p_id,"syncfile",$f_id,5);
        }
        else {
            return;
        }
    }
    public function syncPositionUpdate($uname,$p_id,$pos) {         // access - all
        $sql_connection = connect_to_db();
        $query = "SELECT setting_value
                    FROM settings
                    WHERE setting_name='sync_status'";
        $result_set = mysql_query($query);
        confirm_query($result_set);
        $sync_head = mysql_fetch_array($result_set);
        if($sync_head == -1) {
            return;
        }
        else if($sync_head==$uname) {
            $this->serverUpdate($p_id,"syncposition",$pos,5);
        }
        else {
            return;
        }
    }

    public function getSyncStatus() {                           //  access - all
        $sql_connection = connect_to_db();
        $query = "SELECT setting_value
                    FROM settings
                    WHERE setting_name='sync_status'";
        $result_set = mysql_query($query);
        confirm_query($result_set);
        $sync_head = mysql_fetch_array($result_set);
        if($sync_head = -1) {
            return false;
        }
        else {
            $query = "SELECT setting_value
                        FROM settings
                        WHERE setting_name='sync_project'";
            $result_set = mysql_query($query);
            confirm_query($result_set);
            $sync_project = mysql_fetch_array($result_set);

            $query = "SELECT update_body
                        FROM updates
                        WHERE update_header='syncfile'
                        ORDER BY update_time DESC
                        LIMIT 1";
            $result_set = mysql_query($query);
            confirm_query($result_set);
            $sync_file = mysql_fetch_array($result_set);
            /*
            $query = "SELECT update_body
                        FROM updates
                        WHERE update_header='syncposition'
                        ORDER BY update_time DESC
                        LIMIT 1";
            $result_set = mysql_query($query);
            confirm_query($result_set);
            $sync_position = mysql_fetch_array($result_set);*/
            return array("sync_head"=>$sync_head,"sync_project"=>$sync_project,"sync_file"=>$sync_file/*,"sync_position"=>$sync_position*/);
        }
    }
}
?>