[bmann_420]

Even better

I think that option would be very beneficial.

[Mordekay]

To continue to spin this thread this could help building really large comunities/servernetworks of servers who doesn't know about themselfe at all....
Think about this: one database on a website that has a form to register/remove his own servers. Putting them into the section he wants, of couse, the section must be extended to the region of the server. Updating the server-list once or twice a day. This way you could find easily a server for any mod you want without leaving the server you are connected to and without looking onto any website.

[xOR]

Originally Posted by davidonpda In fact, I would like to see others voice approval and support that this would be a utilized function. If I am the only one that is going to use it, I should do it myself.

the vote result is pretty clear, so the decision is made that xREDIRECT will get this feature.
like bmann suggested it will be controlled by a CVAR (or even more). i think additionally there will be a define option in the source code to turn it on or off, so the SQL code is not compiled into all the binaries of people who don't plan to ever use SQL.

bug tracker entry for this is here.

[davidonpda]

Let me know the format that it will be stored in the database, and I will begin working on a PHP front end for a webserver.

[Styles]

No, this is a very good idea to add. What you should do is on plugin start, parse the mysql db for data and just hold it, don't keep trying to access it.

Then compare ip with net_address (cvar) to blank it out.

But your smart xOR..you should know

[xOR]

the feature of a centralized server list in a database is meant to save admins from having to touch every single server for a list change. this means i need some interval where i refresh the data from the sql tables, otherwise the admin would have to restart every single server and then we're back at touching every server.

for servers that load a new map every 20 minutes it probably doesn't matter but there are servers with longer games (in NS a single game can easily take an hour or longer and the server is designed not to interrupt ongoing games with a map change), longer time limits or even 24/7 servers which need an automatic refresh. so, as i wrote in the bug entry, there will be this refresh but of course i won't constantly reload the list from the database every round or even read the data directly from there, in case you thought that. but well, that would be very far away from how the plugin currently works anyway, why should i do this

[bmann_420]

A simple command fromin game or hlsw for a map change, is much easier than overwriting files for every server.

[jsterling]

You could connect to the database on server start and map change and have it write to the serverlist.ini and as bmann said also add a cvar to grab and write.

[xOR]

i already said something about refreshing on start and map change - what do you do on 24/7 servers that maybe restart once a day? and on NS servers that might have a game running for 2 hours?

and it's not a CVAR but a command and xREDIRECT already has it: redirect_reload. of course this command will work for SQL server lists. i think bmann was rather talking about the "restart" command or "map"/"changelevel" anyway but i am sure redirect_reload is the better solution, it does not need any kind of restart to work (and it already works today).

why are you trying to convince me of not implementing an automatic refresh in a specific interval anyway? it would be like every 20 minutes. a selection every 20 minutes...for a mysql database...i really don't see where the problem is. the interval will be configurable or maybe even have the option to be completely deactivated.
of course i will run tests with it and should i notice the refresh causes a small lag everytime the plugin does it i might turn it off by default.

is that a solution everyone could live with?

[danielkza]

Originally Posted by xOR of course i will run tests with it and should i notice the refresh causes a small lag everytime the plugin does it i might turn it off by default. is that a solution everyone could live with?

I don't think it would be a problem if using threaded queries. Since the data set won't be anything too large, the processing would be fast enough so lag won't be noticed. I agree with your point, it's a great addition to the plugin, but you can configure it for whatever delay you want, or even disable it.