Gecko [ admjudic.com.br ]

Name	Size	Permission
event	[ DIR ]	drwxr-xr-x
external	[ DIR ]	drwxr-xr-x
form	[ DIR ]	drwxr-xr-x
output	[ DIR ]	drwxr-xr-x
privacy	[ DIR ]	drwxr-xr-x
drop.php	7.44 KB	-rw-r--r--
drop_pickup.php	4.46 KB	-rw-r--r--
drop_snippet_restore_decode_ru...	3.61 KB	-rw-r--r--
external.php	13.06 KB	-rw-r--r--
helper.php	4.13 KB	-rw-r--r--
item.php	4.26 KB	-rw-r--r--
manager.php	35.86 KB	-rw-r--r--
page_helper.php	7.42 KB	-rw-r--r--
persistent.php	28.11 KB	-rw-r--r--
restore_decode_rule.php	3.01 KB	-rw-r--r--
shortcodes.php	4.83 KB	-rw-r--r--
stash.php	4.59 KB	-rw-r--r--
trade.php	5.39 KB	-rw-r--r--
tradeitems.php	1.71 KB	-rw-r--r--
user_item.php	6.15 KB	-rw-r--r--

Code Editor : drop_pickup.php

<?php
// This file is part of Moodle - http://moodle.org/
//
// Moodle 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 3 of the License, or
// (at your option) any later version.
//
// Moodle 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 Moodle.  If not, see <http://www.gnu.org/licenses/>.

/**
 * Item drop pickup model.
 *
 * @package    block_stash
 * @copyright  2016 Frédéric Massart - FMCorz.net
 * @license    http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later
 */

namespace block_stash;
defined('MOODLE_INTERNAL') || die();

use lang_string;

/**
 * Item drop pickup model class.
 *
 * @package    block_stash
 * @copyright  2016 Frédéric Massart - FMCorz.net
 * @license    http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later
 */
class drop_pickup extends persistent {

const TABLE = 'block_stash_drop_pickups';

protected static function define_properties() {
        return [
            'dropid' => [
                'type' => PARAM_INT
            ],
            'userid' => [
                'type' => PARAM_INT
            ],
            'pickupcount' => [
                'type' => PARAM_INT,
                'default' => 0
            ],
            'lastpickup' => [
                'type' => PARAM_INT,
                'default' => null,
                'null' => NULL_ALLOWED
            ]
        ];
    }

/**
     * Delete all entries for a user in a stash.
     *
     * @param int $userid The user ID.
     * @param int $stashid The stash ID.
     */
    public static function delete_all_for_user_in_stash($userid, $stashid) {
        global $DB;
        $sql = 'DELETE FROM {' . self::TABLE . '}
                 WHERE userid = :userid
                   AND dropid IN (
                       SELECT d.id
                         FROM {' . drop::TABLE . '} d
                         JOIN {' . item::TABLE . '} i
                           ON i.id = d.itemid
                        WHERE i.stashid = :stashid
                   )';
        $DB->execute($sql, ['userid' => $userid, 'stashid' => $stashid]);
    }

public static function detele_drop_for_user_item($userid, $itemid, $stashid) {
        global $DB;
        $sql = 'DELETE FROM {' . self::TABLE . '}
                 WHERE userid = :userid
                   AND dropid IN (
                       SELECT d.id
                         FROM {' . drop::TABLE . '} d
                         JOIN {' . item::TABLE . '} i
                           ON i.id = d.itemid
                        WHERE i.stashid = :stashid AND d.itemid = :itemid
                   )';
        $DB->execute($sql, ['userid' => $userid, 'stashid' => $stashid, 'itemid' => $itemid]);
    }

/**
     * Get a drop pickup for a drop and user.
     *
     * This creates the row if it does not exist.
     *
     * @param int $dropid The drop ID.
     * @param int $userid The user ID.
     * @return drop_pickup
     */
    public static function get_relation($dropid, $userid) {
        $params = ['dropid' => $dropid, 'userid' => $userid];
        $dp = self::get_record($params);
        if (!$dp) {
            $dp = new self(null, (object) $params);
        }
        return $dp;
    }

/**
     * Validate the item ID.
     *
     * @param string $value The item ID.
     * @return true|lang_string
     */
    protected function validate_dropid($value) {
        if (!drop::record_exists($value)) {
            return new lang_string('invaliddata', 'error');
        }
        return true;
    }

/**
     * Validate the pickup count.
     *
     * @param string $value The pickup count.
     * @return true|lang_string
     */
    protected function validate_pickupcount($value) {
        if ($value < 0) {
            return new lang_string('invaliddata', 'error');
        }
        return true;
    }

/**
     * Validate the user ID.
     *
     * @param string $value The user ID.
     * @return true|lang_string
     */
    protected function validate_userid($value) {
        global $DB;
        if (!$DB->record_exists('user', ['id' => $value])) {
            return new lang_string('invaliddata', 'error');
        }
        return true;
    }
}

${this.title}

Code Editor : drop_pickup.php