Володя

updateVendor: function (btn, e, row) {
    if (typeof(row) != 'undefined') {
        this.menu.record = row.data;
    }
    var id = this.menu.record.id;

    MODx.Ajax.request({
        url: this.config.url,
        params: {
            action: 'mgr/settings/vendor/get',
            id: id
        },
        listeners: {
            success: {
                fn: function ( r ) {
                    var w = Ext.getCmp('minishop2-window-vendor-update');
                    if (w) {
                        w.close();
                    }

                    w = MODx.load({
                        xtype: 'minishop2-window-vendor-update',
                        id: 'minishop2-window-vendor-update',
                        title: this.menu.record['name'],
                        record: r.object,
                        listeners: {
                            success: {
                                fn: function () {
                                    this.refresh();
                                }, scope: this
                            },
                        }
                    });
                    w.fp.getForm().reset();
                    w.fp.getForm().setValues(r.object);
                    w.show(e.target);
                }, scope: this
            }
        }
    });
},

Cannot execute queries while other unbuffered queries are active. Consider using PDOStatement::fetchAll(). Alternatively, if your code is only ever going to run against mysql, you may enable query buffering by setting the PDO::MYSQL_ATTR_USE_BUFFERED_QUERY attribute.

$driver_options = [
        PDO::MYSQL_ATTR_USE_BUFFERED_QUERY => true
];

$stmt = $xpdo->query('SELECT Clients FROM STATUSSERV');
if ($stmt) {
    $row = $stmt->fetch(PDO::FETCH_ASSOC);
    $stmt->closeCursor();
    print_r($row);
}

Кажется

в зависимости от локации выводить региональные цены minishop2

прочую информацию

{set $location = ''|detectUserLocation}
{if $location.name == 'название_локации'}
   ...
{/if}

function getXPDO($dsn, $user, $password, $prefix = '', $config_options = null, $driver_options = null)
{
    $config_options = [
        xPDO::OPT_CACHE_PATH   => MODX_CORE_PATH.'cache/',
        xPDO::OPT_TABLE_PREFIX => $prefix,
    ];
    $driver_options = [
        PDO::MYSQL_ATTR_LOCAL_INFILE => true,
        //PDO::ATTR_ERRMODE            => PDO::ERRMODE_EXCEPTION,
    ];

    try {
        /** @var xPDO $xpdo */
        $xpdo = new xPDO($dsn, $user, $password, $config_options, $driver_options);
        if ($xpdo AND is_object($xpdo)) {
            $xpdo->setLogLevel(xPDO::LOG_LEVEL_ERROR);
            $xpdo->setLogTarget('HTML');
            if ($xpdo->connect()) {
                return $xpdo;
            }
        }
    } catch (PDOException $e) {
        die('database connection failed: '.$e->getMessage());
    }


    return false;
}

$xpdo = getXPDO($dsn, $username, $password);

$query="SELECT Clients FROM STATUSSERV"; 
$count = $xpdo->exec($query);
print("Clients online: $count");
print_r($xpdo->errorInfo());

print_r($modx->errorInfo());

{$array|array_sum}

возможно ли обновить базу ip адресов?
проблема в том, что некорректно отображает город у некоторых ip адресов, причем на сайте библиотеки город корректно определил sypexgeo.net/ru/demo