chamilo / chamilo-lms

     * used in the works tool to record informations when

     * an user upload 1 work

     */

    public static function event_upload($doc_id)

    {

        $TABLETRACK_UPLOADS = Database::get_main_table(TABLE_STATISTIC_TRACK_E_UPLOADS);

        $courseId = api_get_course_int_id();

        $reallyNow = api_get_utc_datetime();

        $user_id = api_get_user_id();

        $doc_id = intval($doc_id);

        $sql = "INSERT INTO ".$TABLETRACK_UPLOADS."

                    ( upload_user_id,

                      c_id,

                      upload_cours_id,

                      upload_work_id,

                      upload_date,

                      upload_session_id

                    )

                    VALUES (

                     ".$user_id.",

                     '".$courseId."',

                     '',

                     '".$doc_id."',

                     '".$reallyNow."',

                     '".api_get_session_id()."'

                    )";

        Database::query($sql);

        return 1;

    }

     * and later again.

     * Doing this twice causes an error, I remove one of them.

     */

    public static function event_download($doc_url)

    {

        $tbl_stats_downloads = Database::get_main_table(TABLE_STATISTIC_TRACK_E_DOWNLOADS);

        $doc_url = Database::escape_string($doc_url);

        $reallyNow = api_get_utc_datetime();

        $user_id = "'".api_get_user_id()."'";

        $_cid = api_get_course_int_id();

        $sql = "INSERT INTO $tbl_stats_downloads (

                     down_user_id,

                     c_id,

                     down_doc_path,

                     down_date,

                     down_session_id

                    )

                    VALUES (

                     ".$user_id.",

                     '".$_cid."',

                     '".$doc_url."',

                     '".$reallyNow."',

                     '".api_get_session_id()."'

                    )";

        Database::query($sql);

        return 1;

    }

    /**

     * @param doc_id id of document (id in mainDb.document table)