Private List Server - Revision history

Deliot at 17:30, 24 October 2011

2011-10-24T17:30:16Z

← Older revision		Revision as of 17:30, 24 October 2011
Line 29:		Line 29:


	*There are ~~MANY~~ places in the '''bzfls.php''' file that are customized to the MySQL tables names used in the official BZFlag Global Registration Server. These MySQL table names may conflict with YOUR table names. To find them, search '''bzfls.php''' for "bzbb3_" (as seen in the code sample below). Edit/Replace them as necessary to match the table prefix you used for YOUR phpbb3 MySQL tables:		*There are many places in the '''bzfls.php''' file that are customized to the MySQL tables names used in the official BZFlag Global Registration Server. These MySQL table names may conflict with YOUR table names. To find them, search '''bzfls.php''' for "bzbb3_" (as seen in the code sample below). Edit/Replace them as necessary to match the table prefix you used for YOUR phpbb3 MySQL tables:

	'''before'''		'''(before)'''
	$result = sqlQuery ("		$result = sqlQuery ("
	SELECT g.group_id FROM bzbb3_user_group ug, bzbb3_groups g		SELECT g.group_id FROM bzbb3_user_group ug, bzbb3_groups g
	WHERE g.group_id=ug.group_id AND ug.user_pending=0 AND ug.user_id = $playerid");		WHERE g.group_id=ug.group_id AND ug.user_pending=0 AND ug.user_id = $playerid");

	'''after'''		'''(after)'''
	$result = sqlQuery ("		$result = sqlQuery ("
	SELECT g.group_id FROM phpbb_user_group ug, phpbb_groups g		SELECT g.group_id FROM phpbb_user_group ug, phpbb_groups g
	WHERE g.group_id=ug.group_id AND ug.user_pending=0 AND ug.user_id = $playerid");		WHERE g.group_id=ug.group_id AND ug.user_pending=0 AND ug.user_id = $playerid");

Deliot at 17:28, 24 October 2011

2011-10-24T17:28:16Z

← Older revision		Revision as of 17:28, 24 October 2011
Line 30:		Line 30:

	*There are MANY places in the '''bzfls.php''' file that are customized to the MySQL tables names used in the official BZFlag Global Registration Server. These MySQL table names may conflict with YOUR table names. To find them, search '''bzfls.php''' for "bzbb3_" (as seen in the code sample below). Edit/Replace them as necessary to match the table prefix you used for YOUR phpbb3 MySQL tables:		*There are MANY places in the '''bzfls.php''' file that are customized to the MySQL tables names used in the official BZFlag Global Registration Server. These MySQL table names may conflict with YOUR table names. To find them, search '''bzfls.php''' for "bzbb3_" (as seen in the code sample below). Edit/Replace them as necessary to match the table prefix you used for YOUR phpbb3 MySQL tables:
	$result = sqlQuery ("
			'''before'''
			$result = sqlQuery ("
	SELECT g.group_id FROM bzbb3_user_group ug, bzbb3_groups g		SELECT g.group_id FROM bzbb3_user_group ug, bzbb3_groups g
			WHERE g.group_id=ug.group_id AND ug.user_pending=0 AND ug.user_id = $playerid");

			'''after'''
			$result = sqlQuery ("
			SELECT g.group_id FROM phpbb_user_group ug, phpbb_groups g
	WHERE g.group_id=ug.group_id AND ug.user_pending=0 AND ug.user_id = $playerid");		WHERE g.group_id=ug.group_id AND ug.user_pending=0 AND ug.user_id = $playerid");

Deliot: /* Directions */

2011-10-24T17:23:34Z

Directions

← Older revision		Revision as of 17:23, 24 October 2011
Line 27:		Line 27:
	$dbpass = "********";		$dbpass = "********";
	$bbdbname = 'phpbb3';		$bbdbname = 'phpbb3';


			*There are MANY places in the '''bzfls.php''' file that are customized to the MySQL tables names used in the official BZFlag Global Registration Server. These MySQL table names may conflict with YOUR table names. To find them, search '''bzfls.php''' for "bzbb3_" (as seen in the code sample below). Edit/Replace them as necessary to match the table prefix you used for YOUR phpbb3 MySQL tables:
			$result = sqlQuery ("
			SELECT g.group_id FROM bzbb3_user_group ug, bzbb3_groups g
			WHERE g.group_id=ug.group_id AND ug.user_pending=0 AND ug.user_id = $playerid");


	*For ease of setup, '''bzfls.php''' was edited to house files in the "main" PHPBB3 folder (ex: /usr/share/phpbb3/www/). The following lines were changed to accomplish this (linux example):		*For ease of setup, '''bzfls.php''' was edited to house files in the "main" PHPBB3 folder (ex: /usr/share/phpbb3/www/). The following lines were changed to accomplish this (linux example):
	$phpbb_root_path = '/usr/share/phpbb3/www/';		$phpbb_root_path = '/usr/share/phpbb3/www/';

Deliot at 20:02, 14 December 2010

2010-12-14T20:02:52Z

← Older revision		Revision as of 20:02, 14 December 2010
Line 21:		Line 21:
	serversettings.php.tmpl (rename to serversettings.php)		serversettings.php.tmpl (rename to serversettings.php)
	banfunctions.php		banfunctions.php
	*Edit serversettings.php such that it can connect to your PHPBB3 MySQL database. Note that this example assumes that the same database ~~is used for MySQL tables~~ used by '''bzfls.php''' ~~and~~ by the PHPBB3 installation:		*Edit '''serversettings.php''' such that it can connect to your PHPBB3 MySQL database. Note that this example assumes that the same database used by '''bzfls.php''' is also used by the PHPBB3 installation:
	$dbhost = "localhost";		$dbhost = "localhost";
	$dbname = "phpbb3";		$dbname = "phpbb3";

Alezakos: More wikifying!

2010-12-12T21:35:07Z

More wikifying!

← Older revision		Revision as of 21:35, 12 December 2010
Line 1:		Line 1:
	This article discusses how to create a PRIVATE [[List Server]] and have players authenticate via this server. This is generally not necessary, since BZFlag clients perform [[Global Registration]] via the official bzflag.org [[List Server]]. However, if a [[BZFS]] server is created within a private LAN network, it may be desirable/necessary to authenticate players locally.		This article discusses how to create a PRIVATE [[List Server]] and have players authenticate via this server. This is generally not necessary, since BZFlag clients perform [[Global Registration]] via the official bzflag.org [[List Server]]. However, if a [[BZFS]] server is created within a private LAN network, it may be desirable/necessary to authenticate players locally.

	=Assumptions=		==Assumptions==
	*This article assumes a working [[BZFS]] server is already in place and has been tested.		*This article assumes a working [[BZFS]] server is already in place and has been tested.
	*This article assumes the server admin understands how to set up a BZFS groups file (see [[Sample Group File]])		*This article assumes the server admin understands how to set up a BZFS groups file (see [[Sample Group File]])
Line 11:		Line 11:
	*This article was written using Windows clients to access both the game server and the private [[List Server]].		*This article was written using Windows clients to access both the game server and the private [[List Server]].

	=Difficulty=		==Difficulty==
	While no particular step in this process is overly difficult, there are many steps, and many interactions between steps. There are multiple points of failure during this process.		While no particular step in this process is overly difficult, there are many steps, and many interactions between steps. There are multiple points of failure during this process.

	=Directions=		==Directions==

	*Install and test your [[BZFS]] server. Make sure clients can connect and play the game.		*Install and test your [[BZFS]] server. Make sure clients can connect and play the game.
	*Install PHPBB3 on a web server, configure settings, test that users can REGISTER to the PHPBB3 board.		*Install PHPBB3 on a web server, configure settings, test that users can REGISTER to the PHPBB3 board.
Line 54:		Line 53:
	C:\BZFlag\bzflag.exe -list <nowiki>http://10.14.101.15/phpbb/bzfls.php</nowiki> -configdir c:\bzflag\config\		C:\BZFlag\bzflag.exe -list <nowiki>http://10.14.101.15/phpbb/bzfls.php</nowiki> -configdir c:\bzflag\config\

	=Testing=		==Testing==

	*Restart the [[BZFS]] server.		*Restart the [[BZFS]] server.
Line 82:		Line 81:
	*If all previous tests are successful, start your BZFS server and attempt to have registered PHPBB3 clients authenticate!!		*If all previous tests are successful, start your BZFS server and attempt to have registered PHPBB3 clients authenticate!!

	=Acknowledgments=		==Acknowledgments==
	*This guide would not have been possible without the help and guidance of BZFLAG player/admin "Blast".		*This guide would not have been possible without the help and guidance of BZFLAG player/admin "Blast".
	*This guide is based on a message board discussion found http://my.bzflag.org/bb/viewtopic.php?f=30&t=16653		*This guide is based on a message board discussion found http://my.bzflag.org/bb/viewtopic.php?f=30&t=16653

Alezakos: Wikify

2010-11-05T21:42:57Z

Wikify

← Older revision		Revision as of 21:42, 5 November 2010
Line 1:		Line 1:
	~~=Overview=~~
	This article discusses how to create a PRIVATE [[List Server]] and have players authenticate via this server. This is generally not necessary, since BZFlag clients perform [[Global Registration]] via the official bzflag.org [[List Server]]. However, if a [[BZFS]] server is created within a private LAN network, it may be desirable/necessary to authenticate players locally.		This article discusses how to create a PRIVATE [[List Server]] and have players authenticate via this server. This is generally not necessary, since BZFlag clients perform [[Global Registration]] via the official bzflag.org [[List Server]]. However, if a [[BZFS]] server is created within a private LAN network, it may be desirable/necessary to authenticate players locally.

99.31.222.199 at 03:23, 5 November 2010

2010-11-05T03:23:41Z

← Older revision		Revision as of 03:23, 5 November 2010
Line 47:		Line 47:
	#-q		#-q
	-publiclist <nowiki>http://10.14.101.15/phpbb/bzfls.php</nowiki>		-publiclist <nowiki>http://10.14.101.15/phpbb/bzfls.php</nowiki>
	*Edit the [[BZFS]] config file and create any text files necessary to use the ~~'''-userdb''' and~~ '''-groupdb''' ~~options~~. See the [[Sample conf]] and [[Sample Group File]] for more info:		*Edit the [[BZFS]] config file and create any text files necessary to use the '''-groupdb''' option. See the [[Sample conf]] and [[Sample Group File]] for more info:
	~~#userdb stores user to group mappings.~~
	~~-userdb /path/to/users.txt~~
	#groupdb stores group to permission mappings.		#groupdb stores group to permission mappings.
	-groupdb /path/to/groups.txt		-groupdb /path/to/groups.txt

Deliot at 18:21, 2 November 2010

2010-11-02T18:21:45Z

← Older revision		Revision as of 18:21, 2 November 2010
Line 41:		Line 41:
	`user_tokenip` varchar(40) COLLATE utf8_bin NOT NULL DEFAULT '',		`user_tokenip` varchar(40) COLLATE utf8_bin NOT NULL DEFAULT '',
	*A number of tables must be added to the PHPBB3 database to accommodate player tracking These tables can be found here: http://bzflag.svn.sourceforge.net/viewvc/bzflag/trunk/db/support/database_structure.sql?revision=20248&content-type=text/plain.		*A number of tables must be added to the PHPBB3 database to accommodate player tracking These tables can be found here: http://bzflag.svn.sourceforge.net/viewvc/bzflag/trunk/db/support/database_structure.sql?revision=20248&content-type=text/plain.
	*Edit the [[BZFS]] config file '''##List Server Connection##''' section to include something like the following. See the [[Sample conf]] for more info. In particular, it is important that '''-publicaddr''' and '''-publiclist''' are set:		*Edit the [[BZFS]] config file '''##List Server Connection##''' section to include something like the following. See the [[Sample conf]] for more info. In particular, it is important that '''-publicaddr''' and '''-publiclist''' are ON and set. The BZFS server isn't "public" in the traditional sense but it is "public" according to our new "private" LAN list server, so the public settings must be ON, and the private '''-q''' setting must be OFF.
	#The BZFS server isn't "public" in the traditional sense but it is "public" according to our new "private"
	#list server, so the public settings must be ON, and the private -q setting must be OFF.
	-public "My LAN BZFlag Server"		-public "My LAN BZFlag Server"
	-publicaddr 10.14.101.15:5154		-publicaddr 10.14.101.15:5154

Deliot at 18:17, 2 November 2010

2010-11-02T18:17:54Z

← Older revision		Revision as of 18:17, 2 November 2010
Line 42:		Line 42:
	*A number of tables must be added to the PHPBB3 database to accommodate player tracking These tables can be found here: http://bzflag.svn.sourceforge.net/viewvc/bzflag/trunk/db/support/database_structure.sql?revision=20248&content-type=text/plain.		*A number of tables must be added to the PHPBB3 database to accommodate player tracking These tables can be found here: http://bzflag.svn.sourceforge.net/viewvc/bzflag/trunk/db/support/database_structure.sql?revision=20248&content-type=text/plain.
	*Edit the [[BZFS]] config file '''##List Server Connection##''' section to include something like the following. See the [[Sample conf]] for more info. In particular, it is important that '''-publicaddr''' and '''-publiclist''' are set:		*Edit the [[BZFS]] config file '''##List Server Connection##''' section to include something like the following. See the [[Sample conf]] for more info. In particular, it is important that '''-publicaddr''' and '''-publiclist''' are set:
			#The BZFS server isn't "public" in the traditional sense but it is "public" according to our new "private"
			#list server, so the public settings must be ON, and the private -q setting must be OFF.
	-public "My LAN BZFlag Server"		-public "My LAN BZFlag Server"
	-publicaddr 10.14.101.15:5154		-publicaddr 10.14.101.15:5154
	-p 5154		-p 5154
	~~# Tells server not to respond to "pings". This makes the server private.~~
	~~# Leave this commented out.~~
	#-q		#-q
	-publiclist <nowiki>http://10.14.101.15/phpbb/bzfls.php</nowiki>		-publiclist <nowiki>http://10.14.101.15/phpbb/bzfls.php</nowiki>

Deliot at 18:13, 2 November 2010

2010-11-02T18:13:38Z

← Older revision		Revision as of 18:13, 2 November 2010
Line 48:		Line 48:
	# Leave this commented out.		# Leave this commented out.
	#-q		#-q
	-publiclist http://10.14.101.15/phpbb/bzfls.php		-publiclist <nowiki>http://10.14.101.15/phpbb/bzfls.php</nowiki>
	*Edit the [[BZFS]] config file and create any text files necessary to use the '''-userdb''' and '''-groupdb''' options. See the [[Sample conf]] and [[Sample Group File]] for more info:		*Edit the [[BZFS]] config file and create any text files necessary to use the '''-userdb''' and '''-groupdb''' options. See the [[Sample conf]] and [[Sample Group File]] for more info:
	#userdb stores user to group mappings.		#userdb stores user to group mappings.