Openkore data + MySQL

[Bibian]

Would it be possible (and usefull) to have openkore support having data from control/*.txt and tables/*.txt in a mysql database?

This way you could have 1 single database server to which your clients connect and get their data from, all they would need to do is query the right data.
1 database would be able to house the information for an unlimited amount of bots (limited by your HD space of course), making it easier to manage (with a proper tool).

Thoughts? Idea's?

ps: Dont reply if you dont know what MySQL is, does or howto use it

[Cozzie]

I'm trying to think up of a good example and cant think of anything, care to share where your idea comes from?

[sli]

Possible, yes. Useful, yes. Feasible or practical? Fuuuuck no. Needed? Still fuck no. Consider: who's going to have issues running out of room for OpenKore installations (which is just, minimum, one config file per bot and nothing more) but own a hosting account with a high amount of available SQL space? A lot of hosts don't even allow external connections to MySQL.

[Bibian]

well this way i could (for example) run a bot at home and at my server without having to transfer the config

[sli]

Honestly, it'd be much easier over HTTP(S) or just HTTP with basic auth. You could do it with a plugin. Just have it hook start, then download and overwrite the config before it's loaded.

[Cozzie]

I was thinking along the lines of easier/powerful ways of sharing/manging config files, but regarding vivi's use of this, I remember she suggested it months ago and it's a good idea imo. It's just really for the real power users.

[Kissa2k]

It's hard enough to code it. I think transferring config files through http to your server will be much easier..

[sli]

Well, with MySQL I imagine it'd just be one query to get an entire config and the resulting data is parsed just like the current config:

Code: Select all

select config from control where char='Flipkick'

Or one query to get a MySQL version of the config:

Code: Select all

select * from config where char='Flipkick'

Then the row is fetched as an associative array into %config where it could be accessed exactly like it is currently ($config{master} would be the 'master' field in the config table).

[Silence]

its a good idea but then you will have to deal with people trying to setup their own MySQL server and then dealing with configuring and updating it.

It would be a good idea for an off branch of OK for people who bot via different locations but i don't see whats wrong with using a program such as DKore http://rofan.ru/viewtopic.php?t=2479 (which -SHOULD- be a main part of OpenKore anyways) for running multiple accounts.

[sli]

Everything in OpenKore is obvious, people just don't want to figure shit out themselves. There's no need for a specialized config editor.