{"action":"created","issue":{"url":"https://api.github.com/repos/sbpp/sourcebans-pp/issues/336","repository_url":"https://api.github.com/repos/sbpp/sourcebans-pp","labels_url":"https://api.github.com/repos/sbpp/sourcebans-pp/issues/336/labels{/name}","comments_url":"https://api.github.com/repos/sbpp/sourcebans-pp/issues/336/comments","events_url":"https://api.github.com/repos/sbpp/sourcebans-pp/issues/336/events","html_url":"https://github.com/sbpp/sourcebans-pp/issues/336","id":247511438,"number":336,"title":"Feature request; Web API instead of remote mysql","user":{"login":"distobj","id":477485,"avatar_url":"https://avatars3.githubusercontent.com/u/477485?v=4","gravatar_id":"","url":"https://api.github.com/users/distobj","html_url":"https://github.com/distobj","followers_url":"https://api.github.com/users/distobj/followers","following_url":"https://api.github.com/users/distobj/following{/other_user}","gists_url":"https://api.github.com/users/distobj/gists{/gist_id}","starred_url":"https://api.github.com/users/distobj/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/distobj/subscriptions","organizations_url":"https://api.github.com/users/distobj/orgs","repos_url":"https://api.github.com/users/distobj/repos","events_url":"https://api.github.com/users/distobj/events{/privacy}","received_events_url":"https://api.github.com/users/distobj/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2017-08-02T20:26:01Z","updated_at":"2017-08-04T14:18:51Z","closed_at":"2017-08-04T14:18:51Z","body":"I just tried to install sbpp, and got to the end of the install where the databases.cfg file snippet was presented, including the mysql remote host info. I have a shared hosting package with 1and1 and was pretty sure that they didn't allow remote access. Sure enough, that was the case.\r\n\r\nRather than using mysql over the internet, I suggest a Web interface (\"REST API\" if you prefer - I do not :). It would reduce the requirements on the installation environment, making it usable in cheaper hosting environments like mine. There are also other architectural improvements that this change would bring (decoupling of plugin code and database schema, for example), but it's unclear to me of the value to the project at this time.\r\n\r\nThanks."},"comment":{"url":"https://api.github.com/repos/sbpp/sourcebans-pp/issues/comments/320261024","html_url":"https://github.com/sbpp/sourcebans-pp/issues/336#issuecomment-320261024","issue_url":"https://api.github.com/repos/sbpp/sourcebans-pp/issues/336","id":320261024,"user":{"login":"Groruk","id":5796460,"avatar_url":"https://avatars2.githubusercontent.com/u/5796460?v=4","gravatar_id":"","url":"https://api.github.com/users/Groruk","html_url":"https://github.com/Groruk","followers_url":"https://api.github.com/users/Groruk/followers","following_url":"https://api.github.com/users/Groruk/following{/other_user}","gists_url":"https://api.github.com/users/Groruk/gists{/gist_id}","starred_url":"https://api.github.com/users/Groruk/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Groruk/subscriptions","organizations_url":"https://api.github.com/users/Groruk/orgs","repos_url":"https://api.github.com/users/Groruk/repos","events_url":"https://api.github.com/users/Groruk/events{/privacy}","received_events_url":"https://api.github.com/users/Groruk/received_events","type":"User","site_admin":false},"created_at":"2017-08-04T14:18:51Z","updated_at":"2017-08-04T14:18:51Z","body":"**This will not happen.** \r\nThe plugin and the web panel of SourceBans++ are separated parts (and we want to keep it this way). \r\nThe web panel is here to give the end user a simpler interface to work with SB++ and to some extend to add new functionality to the plugin. \r\nThe plugin shouldn't be dependent on the web panel (in theory you can run the plugin without the web panel) but on the MySQL database. \r\nAlmost all bigger plugins need to rely on a MySQL database to access data over multiple game server why be the odd ones out and depend on a web API instead.\r\n\r\nIt sounds like you should overthink your server setup or talk to your hoster maybe they can help you.\r\nYou're also free to fork SB++ and build your own API for this (we won't since we see no real improvement)."}}
{"actor":{"display_login":"Groruk"}}