コード例 #1
0
ファイル: linkconfig.main.php プロジェクト: jr-ewing/phpMyFAQ
$_admin = isset($permission['editconfig']) && $permission['editconfig'] ? true : false;
$rowcount = PMF_Filter::filterInput(INPUT_POST, 'rowcount', FILTER_VALIDATE_INT);
if (!is_null($rowcount)) {
    for ($i = 0; $i < $rowcount; $i++) {
        // load form posts
        $posts = array();
        foreach (array('id' => false, 'url' => '', 'reason' => '', 'enabled' => 'n', 'locked' => 'n', 'chown' => 'n', 'delete' => 'n') as $_key => $_default) {
            if (isset($_POST[$_key][$i])) {
                $posts[$_key] = $_POST[$_key][$i];
            } else {
                $posts[$_key] = $_default;
            }
        }
        switch ($posts['id']) {
            case 'NEW':
                $linkverifier->addVerifyRule($params['type'], $posts['url'], $posts['reason']);
                break;
            default:
                $query = sprintf("SELECT\n                                    *\n                                FROM\n                                    %sfaqlinkverifyrules\n                                WHERE\n                                        type='%s'\n                                    AND id=%d", SQLPREFIX, $db->escape_string($params['type']), $posts['id']);
                $row = false;
                $result = $db->query($query);
                if ($db->numRows($result) > 0) {
                    $row = $db->fetchObject($result);
                    $_owner = $row->owner == $user->getLogin() ? true : false;
                    // check if chown ?
                    if (!$_owner && $posts['chown'] == 'y' && ($_admin || $posts['locked'] == 'n')) {
                        $query = sprintf("UPDATE\n                                            %sfaqlinkverifyrules\n                                        SET\n                                            owner = '%s',\n                                            dtUpdateDate = '%s'\n                                            WHERE id = %d", SQLPREFIX, $db->escape_string($user->getLogin()), $db->escape_string(date('YmdHis')), $posts['id']);
                        $db->query($query);
                        $_owner = true;
                        break;
                    }