Clientprefs support

[ghost]

Will there be support for clientprefs in the future?

For example there is the centerprojectiles plugin on uncletopia, if I want to keep it enabled I would have to enable it on every server I join.

I understand that this is using postreges which sourcemod also supports and I could just edit the database file for clientprefs.

[leighmacdonald]

I do plan to eventually support this, in a centralized manner, but its a bit more complicated than just pointing to our pg as that will only ever listen on localhost. Id prefer to implement this via the https api that we already use. Unfortunately all the salient clientprefs functionality is in an extension so its a bit more work to make happen.

[Gcommer]

Are you interested in a contribution here?

I feel it's something like:

• Add clientprefs DB, and CRUD options to the website for users
• Expose clientprefs via an HTTP API
• Have sourcemod ping that API on user connect, and wire the results to relevant plugins

Assuming the prefs are small enough it honestly wouldn't be that bad to do push-based instead -- ie send all players' prefs to every server proactively. Maybe scp it every 5 minutes? With a binary file format it would likely be a few MB max.

[leighmacdonald]

This was actually going to come up pretty soon, Once the sql admin stuff is in place, since it makes sense to also support this now using the same database. Database will be exposed with a limited privileged user bound only to the wireguard interface so im not too worried about it anymore. We didn't originally have this vpn network setup previously.

The plan i had was to basically just implement https://github.com/alliedmodders/sourcemod/blob/master/configs/sql-init-scripts/pgsql/clientprefs-pgsql.sql and use the built in clientprefs extension. I had no intentions of doing anything on the site itself, but it seems reasonable if you think there is some value to that. Feel free to tackle it if you want.

[Gcommer]

Awesome I got clientprefs pointing to my gbans psql instance and it works great with no changes to the tf2centerprojectiles plugin.

Wrote #536 based on that architecture. Other than that its probably just infra changes on your end to close this bug.