Commit graph

201 commits

Author SHA1 Message Date
pentarctagon
ba296898d7 Store additional information in the database:
* mp_scenario_addon_id
* mp_scenario_addon_version (host's version)
* mp_era_addon_id
* mp_era_addon_version (host's version)
* active_mod_addon_ids
* active_mod_versions (host's versions)

Forward-port of #4958
2020-07-30 13:17:22 -05:00
Pentarctagon
113a4e0913 Use mariadbpp rather than the mysql C connector.
Reasoning being:
* The result_set and other APIs are nicer to use.
* We use mariadb on our server rather than mysql, so this would minimize the chance of any incompatibilities.
* The mysql C++ connector 1.1 isn't compatible with with c++17 (https://stackoverflow.com/q/47284705).
2020-07-30 13:17:22 -05:00
Pentarctagon
67c169ed80 Add scripts to pull various pieces of information from the MP database.
The intent being that I plan to run these once a month and post the results on the forum.
2020-03-26 14:54:53 -05:00
Pentarctagon
95dc6b5f45 Only store game information once the game starts. 2020-01-21 18:02:28 -06:00
pentarctagon
81e2cae74f Store additional fields in the database.
* Whether the game allows observers.
* Whether the game's replay should be publicly available (currently the same as whether observers are allowed pending the second part of #3909).
* Whether the game had a password set.
* The side's name - this differs from what can be retrieved from USER_ID since it will have the name of any AI used.
2019-10-28 00:40:24 -05:00
pentarctagon
ea90383f1d
Make additional changes to client source handling based on discussion.
Add a "BSD Repository" option.
Add data/dist to .gitignore.
Delete data/dist from git.
Error conditions reading data/dist just set the value to Default.
Remove a leftover TODO comment.
Add description comments for the two new database columns.
2019-10-22 01:14:45 -05:00
pentarctagon
21f9b19120 Also store where the client came from. 2019-10-20 13:57:45 -05:00
pentarctagon
c04ecaa8fb Store the client version in the database.
This will now store the version of the client playing a side in `game_player_info`.
2019-10-20 13:57:45 -05:00
pentarctagon
6d60cc550e
Use consistent formatting in table_definitions.sql. 2019-09-28 21:42:53 -05:00
pentarctagon
f1d48a0947
Fixup user_is_moderator default. 2019-09-28 12:32:54 -05:00
pentarctagon
2cd4273192 Use BIT(1) for fields with only 2 possible non-NULL values. 2019-09-28 09:27:20 +02:00
pentarctagon
7cb6482b32 Store in the database whether the game is a reload or not. 2019-09-28 09:27:20 +02:00
Pentarctagon
b9246dc6b4 Add a flag to record if the game encountered an OOS error. 2019-08-17 14:42:35 +02:00
Pentarctagon
9470eea825 People who have MP mod authority for testing or other reasons can continue to use the existing user_is_moderator column check, but for people who are supposed to moderate the server, now the forum group will be used.
This will make it easier to add/remove people to/from the group, and also ensure that the list of actual moderators matches up with the list available to users.

New config attributes added for this are:
* db_group_table - should be, based on the phpbb documentation I found, phpbb_user_group
* mp_mod_group - should be set to Multiplayer Moderators group ID
2019-08-15 14:36:16 +02:00
Pentarctagon
59e9f9a138 Add support for storing game information in wesnoth's mysql database.
This requires three more tables to be added to any database with the forum user handler enabled, the structures of which are defined in the wesnothd man page:
* `db_game_info_table` - stores information about each game.
* `db_game_player_info_table` - stores information about each player in the game.
* `db_game_modification_info_table` - stores information about any modifications that are enabled for the game.
2019-08-12 13:04:26 +02:00
Charles Dang
950a156712 Addressed most of the remaining whitespace issues from #2613
[ci skip]
2018-03-11 14:59:37 +11:00
Iris Morelle
8442764435 Add script for creating a new campaignd instance
[ci skip]
2018-03-10 01:08:58 -03:00
Ignacio R. Morelle
548efbbf97 send_campaignd_command: Add to repository 2015-04-24 23:57:39 -03:00
Ignacio R. Morelle
2c625b6d9d update_server: boost_prefix=-mt isn't good for gonzo anymore 2014-11-22 05:09:01 -03:00
Ignacio R. Morelle
d95b181eaa update_server: Show locations of scons' output 2014-11-22 04:31:18 -03:00
Ignacio R. Morelle
0e9f0a0ef0 Revert "create_symlinks: Make an exception for 1.10"
This reverts commit d4f7ebc8ed.
2014-10-30 00:12:57 -03:00
Ignacio R. Morelle
d4f7ebc8ed create_symlinks: Make an exception for 1.10 2014-10-29 21:38:44 -03:00
Ignacio R. Morelle
11c1976a3b Fix thread count setting for 1.9 wesnothd and add one for 1.12 2014-10-29 21:31:36 -03:00
Ignacio R. Morelle
050aab785c Revert "new_release: Workaround race condition in wesnothd SIGHUP handler"
This reverts commit 62eb55a5a7, since it
was superseded by a real fix in 6629fdf64e.
2014-06-26 19:44:39 -04:00
Ignacio R. Morelle
62eb55a5a7 new_release: Workaround race condition in wesnothd SIGHUP handler
If we try to send a message immediately after signaling SIGHUP to
wesnothd, it won't get caught by wesnothd, probably because the control
socket is being reopened just as the message arrives. Thus, we need a 1
second delay after the signal.

This was fixed in production a while ago but I forgot to commit the
change.
2014-06-12 18:17:31 -04:00
Ignacio R. Morelle
912456bf29 send_server_command: Fix issues with screen stuff command not working
At least on baldras' version of screen, the stuff command argument here
absolutely needs to be wrapped in single or double quotes to work.

I actually fixed this months ago but forgot to commit.
2014-06-12 18:15:03 -04:00
Ignacio R. Morelle
1a1ccea4cb update_server: 1.11 is the 1.12 branch 2014-06-12 17:21:34 -04:00
Ignacio R. Morelle
090f8bf0cb update_server: Build from master if the $VERISON is not recognized 2014-06-12 17:21:34 -04:00
Ignacio R. Morelle
e122da96e4 update_server: Use $HOME/source for SOURCE_ROOT
... instead of hardcoding a path in /usr. This should let server2 and
server3 use an unmodified copy of the script.
2014-06-11 22:53:38 -04:00
Ignacio R. Morelle
284300cde9 update_server: Rewrote about 50% of the script, now works with RO checkouts
* Using scons -Y to point scons to a source tree that might be
   read-only for the user building campaignd/wesnothd (as is the case on
   baldras).
 * Renamed or changed several variables for clarity.
 * As a side-effect, links within the server instance dir are now
   absolute rather than relative (/home/wesnoth/build/foo/bar instead of
   ../../build/foo/bar).
 * ~/builds-int/<version> is the intermediate build directory
 * ~/builds/<build-id> remains as the target directory
 * /usr/src/wesnoth is the source directory base (we need to handle
   basilic and gonzo separately later)

I'm fairly sure nobody other than me could possibly demand a more
detailed description of this commit.
2014-06-08 22:52:06 -04:00
Ignacio R. Morelle
b6ce79e634 update_server: The 1.12 branch now exists 2014-03-10 17:00:10 -03:00
Ignacio R. Morelle
d4fad10ab6 run_server: 30 threads for 1.10, not 1.9 2014-02-21 06:02:03 -03:00
Ignacio R. Morelle
0540b987c2 run_server: Use more threads for 1.9 (32), less threads for 1.8 (8) 2014-02-21 05:52:25 -03:00
Ignacio R. Morelle
8aa1c0e1f2 run_campaignd: Use 4 threads for 1.9 or 1.12 only 2014-02-21 05:50:03 -03:00
Ignacio R. Morelle
230fa23f9e Update run_campaignd script from production 2014-02-08 08:04:17 -03:00
Ignacio R. Morelle
7e7a32447e Update run_server script from production 2014-02-08 08:02:45 -03:00
Ignacio R. Morelle
01a6a3bb1d Update new_release script from production 2014-02-08 08:00:35 -03:00
Ignacio R. Morelle
6cad834573 Updated logfilter_irc* scripts with the current production versions 2014-02-08 07:59:25 -03:00
Ignacio R. Morelle
c6c0979800 Update create_symlinks script from production 2014-02-08 07:57:49 -03:00
Ignacio R. Morelle
639e78c4c1 Update tail_log_irc script from production
Removed a "fix the script" message.
2014-02-08 07:56:57 -03:00
Ignacio R. Morelle
ffc43a10e4 Update send_server_command with code changes from production
They mostly seem to be code cleanups or style changes, plus the hack to
try to start the irc echo for the old instance after restarting... which
doesn't seem to be working.
2014-02-08 07:55:23 -03:00
Ignacio R. Morelle
425cce189f Long overdue update to the update_server script to match production
* Added code for handling 1.8 and 1.10
 * Don't use libana for Wesnoth versions that include it (1.9.x)
 * We now use Git, not SVN. The downstream repository is managed
   externally, so we need to update a git-new-workdir checkout every
   time we want to build.
 * Other nondescript changes

(Apologies for the horrible commit message, but it looks like there was
more than my own changes awaiting to be committed.)
2014-02-08 07:48:41 -03:00
Eric S. Raymond
7f85fa000c The git transition.
Most references to and dependencies on Subversion have been removed.
"+svn" is now "+dev". Files that can't be fixed yet have a FIXME-GIT
comment in them; most of these are in the website tests.
2013-03-26 10:44:47 -04:00
Gunter Labes
157c1d5c9f change the test port from 15001 to 14990 2009-11-09 20:18:28 +00:00
Gunter Labes
5ed2a1f9e7 corrected symbolic link source 2009-10-14 20:57:58 +00:00
Gunter Labes
d991db88ff handle the mod filter differently 2009-08-12 03:10:53 +00:00
Gunter Labes
a38e7d8ec5 on the alternates use trunk as the dev server...
...and always show logged on/off messages
2009-07-28 21:27:34 +00:00
Gunter Labes
49045345e7 added some logfilter scripts needed by tail_log_irc 2009-07-28 15:28:07 +00:00
Gunter Labes
f04947d6d4 added a script to tail server log files 2009-07-28 15:13:49 +00:00
Gunter Labes
79f34fa53a added some more fatal exit codes 2009-07-13 19:55:39 +00:00