- custom profile field fixed

- fixing sql_fetchfield from cache - changing the quote parser. In my tests i have not seen changed behaviour - but i might have broken something with this change. git-svn-id: file:///svn/phpbb/trunk@6232 89ea8834-ac86-4346-8a33-228a782c2dd0
author: Meik Sievertsen <acydburn@phpbb.com> 2006-08-03 15:23:34 +0000
committer: Meik Sievertsen <acydburn@phpbb.com> 2006-08-03 15:23:34 +0000
commit: 82f42bb5fa611e790e02bc679b88ce90b3f8156b (patch)
tree: 7cb7cf746da4fd979569dc41dcec96db5f5c9acd /phpBB/includes/acp
parent: 650007a5f18e0538b27bf93d674c264fef58c506 (diff)
download: forums-82f42bb5fa611e790e02bc679b88ce90b3f8156b.tar
forums-82f42bb5fa611e790e02bc679b88ce90b3f8156b.tar.gz
forums-82f42bb5fa611e790e02bc679b88ce90b3f8156b.tar.bz2
forums-82f42bb5fa611e790e02bc679b88ce90b3f8156b.tar.xz
forums-82f42bb5fa611e790e02bc679b88ce90b3f8156b.zip
3 files changed, 284 insertions, 277 deletions
diff --git a/phpBB/includes/acp/acp_forums.php b/phpBB/includes/acp/acp_forums.php
index 8542d44301..ac461772d6 100644
--- a/phpBB/includes/acp/acp_forums.php
+++ b/phpBB/includes/acp/acp_forums.php
@@ -1082,7 +1082,7 @@ class acp_forums
 	{
 		global $db;
 
-		$table_ary = array(LOG_TABLE, POSTS_TABLE, TOPICS_TABLE, DRAFTS_TABLE, TOPICS_TRACK_TABLE);
+		$table_ary = array(ACL_GROUPS_TABLE, ACL_USERS_TABLE, LOG_TABLE, POSTS_TABLE, TOPICS_TABLE, DRAFTS_TABLE, TOPICS_TRACK_TABLE);
 
 		foreach ($table_ary as $table)
 		{
@@ -1123,6 +1123,7 @@ class acp_forums
 
 		$errors = array();
 		$log_action_posts = $log_action_forums = $posts_to_name = $subforums_to_name = '';
+		$forum_ids = array($forum_id);
 
 		if ($action_posts == 'delete')
 		{
@@ -1166,8 +1167,6 @@ class acp_forums
 		if ($action_subforums == 'delete')
 		{
 			$log_action_forums = 'FORUMS';
-
-			$forum_ids = array($forum_id);
 			$rows = get_forum_branch($forum_id, 'children', 'descending', false);
 
 			foreach ($rows as $row)
@@ -1259,11 +1258,6 @@ class acp_forums
 			WHERE left_id > {$forum_data['right_id']}";
 		$db->sql_query($sql);
 
-		if (!isset($forum_ids) || !is_array($forum_ids))
-		{
-			$forum_ids = array($forum_id);
-		}
-
 		// Delete forum ids from extension groups table
 		$sql = 'SELECT group_id, allowed_forums 
 			FROM ' . EXTENSION_GROUPS_TABLE;
diff --git a/phpBB/includes/acp/acp_profile.php b/phpBB/includes/acp/acp_profile.php
index 65589dd0c1..c361c47c2e 100644
--- a/phpBB/includes/acp/acp_profile.php
+++ b/phpBB/includes/acp/acp_profile.php
@@ -549,7 +549,7 @@ class acp_profile
 						{
 							$error[] = $user->lang['NO_FIELD_ENTRIES'];
 						}
-					}	
+					}
 				}
 
 				$step = (isset($_REQUEST['next'])) ? $step + 1 : ((isset($_REQUEST['prev'])) ? $step - 1 : $step);
@@ -933,280 +933,23 @@ class acp_profile
 				'field_active'		=> 1
 			);
 
-			$db->sql_query('INSERT INTO ' . PROFILE_FIELDS_TABLE . ' ' . $db->sql_build_array('INSERT', $profile_fields));
+			$sql = 'INSERT INTO ' . PROFILE_FIELDS_TABLE . ' ' . $db->sql_build_array('INSERT', $profile_fields);
+			$db->sql_query($sql);
 
 			$field_id = $db->sql_nextid();
 		}
 		else
 		{
-			$db->sql_query('UPDATE ' . PROFILE_FIELDS_TABLE . ' SET ' . $db->sql_build_array('UPDATE', $profile_fields) . "
-				WHERE field_id = $field_id");
+			$sql = 'UPDATE ' . PROFILE_FIELDS_TABLE . '
+				SET ' . $db->sql_build_array('UPDATE', $profile_fields) . "
+				WHERE field_id = $field_id";
+			$db->sql_query($sql);
 		}
 		
 		if ($action == 'create')
 		{
-
 			$field_ident = '_' . $field_ident;
-
-			switch (SQL_LAYER)
-			{
-				case 'mysql':
-				case 'mysql4':
-				case 'mysqli':
-
-					// We are defining the biggest common value, because of the possibility to edit the min/max values of each field.
-					$sql = 'ALTER TABLE ' . PROFILE_FIELDS_DATA_TABLE . " ADD `$field_ident` ";
-					switch ($field_type)
-					{
-						case FIELD_STRING:
-							$sql .= ' VARCHAR(255) ';
-						break;
-
-						case FIELD_DATE:
-							$sql .= 'VARCHAR(10) ';
-						break;
-
-						case FIELD_TEXT:
-							$sql .= "TEXT";
-		//						ADD {$field_ident}_bbcode_uid VARCHAR(5) NOT NULL,
-		//						ADD {$field_ident}_bbcode_bitfield INT(11) UNSIGNED";
-						break;
-
-						case FIELD_BOOL:
-							$sql .= 'TINYINT(2) ';
-						break;
-				
-						case FIELD_DROPDOWN:
-							$sql .= 'MEDIUMINT(8) ';
-						break;
-
-						case FIELD_INT:
-							$sql .= 'BIGINT(20) ';
-						break;
-					}
-
-				break;
-
-				case 'sqlite':
-
-					switch ($field_type)
-					{
-						case FIELD_STRING:
-							$type = ' VARCHAR(255) ';
-						break;
-
-						case FIELD_DATE:
-							$type = 'VARCHAR(10) ';
-						break;
-
-						case FIELD_TEXT:
-							$type = "TEXT(65535)";
-		//						ADD {$field_ident}_bbcode_uid VARCHAR(5) NOT NULL,
-		//						ADD {$field_ident}_bbcode_bitfield INT(11) UNSIGNED";
-						break;
-
-						case FIELD_BOOL:
-							$type = 'TINYINT(2) ';
-						break;
-				
-						case FIELD_DROPDOWN:
-							$type = 'MEDIUMINT(8) ';
-						break;
-
-						case FIELD_INT:
-							$type = 'BIGINT(20) ';
-						break;
-					}
-
-					// We are defining the biggest common value, because of the possibility to edit the min/max values of each field.
-					if (version_compare(sqlite_libversion(), '3.0') == -1)
-					{
-						$sql = "SELECT sql
-							FROM sqlite_master 
-							WHERE type = 'table' 
-								AND name = '" . PROFILE_FIELDS_DATA_TABLE . "'
-							ORDER BY type DESC, name;";
-						$result = $db->sql_query($sql);
-						$row = $db->sql_fetchrow($result);
-						$db->sql_freeresult($result);
-
-						// Create a temp table and populate it, destroy the existing one
-						$db->sql_query(preg_replace('#CREATE\s+TABLE\s+"?' . PROFILE_FIELDS_DATA_TABLE . '"?#i', 'CREATE TEMPORARY TABLE ' . PROFILE_FIELDS_DATA_TABLE . '_temp', $row['sql']));
-						$db->sql_query('INSERT INTO ' . PROFILE_FIELDS_DATA_TABLE . '_temp SELECT * FROM ' . PROFILE_FIELDS_DATA_TABLE);
-						$db->sql_query('DROP TABLE ' . PROFILE_FIELDS_DATA_TABLE);
-
-						preg_match('#\((.*)\)#s', $row['sql'], $matches);
-
-						$new_table_cols = trim($matches[1]);
-						$old_table_cols = explode(',', $new_table_cols);
-						$column_list = array();
-						foreach($old_table_cols as $declaration)
-						{
-							$entities = preg_split('#\s+#', trim($declaration));
-							if ($entities == 'PRIMARY')
-							{
-								continue;
-							}
-							$column_list[] = $entities[0];
-						}
-
-						$columns = implode(',', $column_list);
-
-						$new_table_cols = $field_ident . ' ' . $type . ',' . $new_table_cols;
-
-						// create a new table and fill it up. destroy the temp one
-						$db->sql_query('CREATE TABLE ' . PROFILE_FIELDS_DATA_TABLE . ' (' . $new_table_cols . ');');
-						$db->sql_query('INSERT INTO ' . PROFILE_FIELDS_DATA_TABLE . ' (' . $columns . ') SELECT ' . $columns . ' FROM ' . PROFILE_FIELDS_DATA_TABLE . '_temp;');
-						$db->sql_query('DROP TABLE ' . PROFILE_FIELDS_DATA_TABLE . '_temp');
-					}
-					else
-					{
-						$sql = 'ALTER TABLE ' . PROFILE_FIELDS_DATA_TABLE . " ADD $field_ident [$type]";
-					}
-
-
-				break;
-
-				case 'mssql':
-				case 'mssql_odbc':
-
-					// We are defining the biggest common value, because of the possibility to edit the min/max values of each field.
-					$sql = 'ALTER TABLE [' . PROFILE_FIELDS_DATA_TABLE . "] ADD [$field_ident] ";
-
-					switch ($field_type)
-					{
-						case FIELD_STRING:
-							$sql .= ' [VARCHAR] (255) ';
-						break;
-
-						case FIELD_DATE:
-							$sql .= '[VARCHAR] (10) ';
-						break;
-
-						case FIELD_TEXT:
-							$sql .= "[TEXT]";
-		//						ADD {$field_ident}_bbcode_uid [VARCHAR] (5) NOT NULL,
-		//						ADD {$field_ident}_bbcode_bitfield [INT] UNSIGNED";
-						break;
-
-						case FIELD_BOOL:
-						case FIELD_DROPDOWN:
-							$sql .= '[INT] ';
-						break;
-
-						case FIELD_INT:
-							$sql .= '[FLOAT] ';
-						break;
-					}
-
-				break;
-
-				case 'postgres':
-
-					// We are defining the biggest common value, because of the possibility to edit the min/max values of each field.
-					$sql = 'ALTER TABLE ' . PROFILE_FIELDS_DATA_TABLE . " ADD COLUMN \"$field_ident\" ";
-
-					switch ($field_type)
-					{
-						case FIELD_STRING:
-							$sql .= ' VARCHAR(255) ';
-						break;
-
-						case FIELD_DATE:
-							$sql .= 'VARCHAR(10) ';
-						break;
-
-						case FIELD_TEXT:
-							$sql .= "TEXT";
-		//						ADD {$field_ident}_bbcode_uid VARCHAR(5) NOT NULL,
-		//						ADD {$field_ident}_bbcode_bitfield INT4 UNSIGNED";
-						break;
-
-						case FIELD_BOOL:
-							$sql .= 'INT2 ';
-						break;
-				
-						case FIELD_DROPDOWN:
-							$sql .= 'INT4 ';
-						break;
-
-						case FIELD_INT:
-							$sql .= 'INT8 ';
-						break;
-					}
-
-				break;
-
-				case 'firebird':
-
-					// We are defining the biggest common value, because of the possibility to edit the min/max values of each field.
-					$sql = 'ALTER TABLE ' . PROFILE_FIELDS_DATA_TABLE . " ADD \"$field_ident\" ";
-
-					switch ($field_type)
-					{
-						case FIELD_STRING:
-							$sql .= ' VARCHAR(255) ';
-						break;
-
-						case FIELD_DATE:
-							$sql .= 'VARCHAR(10) ';
-						break;
-
-						case FIELD_TEXT:
-							$sql .= "BLOB SUB_TYPE TEXT";
-		//						ADD {$field_ident}_bbcode_uid VARCHAR(5) NOT NULL,
-		//						ADD {$field_ident}_bbcode_bitfield INTEGER UNSIGNED";
-						break;
-
-						case FIELD_BOOL:
-						case FIELD_DROPDOWN:
-							$sql .= 'INTEGER ';
-						break;
-
-						case FIELD_INT:
-							$sql .= 'DOUBLE PRECISION ';
-						break;
-					}
-
-				break;
-
-				case 'oracle':
-
-					// We are defining the biggest common value, because of the possibility to edit the min/max values of each field.
-					$sql = 'ALTER TABLE ' . PROFILE_FIELDS_DATA_TABLE . " ADD \"$field_ident\" ";
-					switch ($field_type)
-					{
-						case FIELD_STRING:
-							$sql .= ' VARCHAR2(255) ';
-						break;
-
-						case FIELD_DATE:
-							$sql .= 'VARCHAR2(10) ';
-						break;
-
-						case FIELD_TEXT:
-							$sql .= "CLOB";
-		//						ADD {$field_ident}_bbcode_uid VARCHAR2(5) NOT NULL,
-		//						ADD {$field_ident}_bbcode_bitfield NUMBER(11) UNSIGNED";
-						break;
-
-						case FIELD_BOOL:
-							$sql .= 'NUMBER(2) ';
-						break;
-				
-						case FIELD_DROPDOWN:
-							$sql .= 'NUMBER(8) ';
-						break;
-
-						case FIELD_INT:
-							$sql .= 'NUMBER(20) ';
-						break;
-					}
-
-				break;
-			}
-	
-			$profile_sql[] = $sql;
+			$profile_sql[] = $this->add_field_ident($field_ident, $field_type);
 		}
 
 		$sql_ary = array(
@@ -1298,9 +1041,9 @@ class acp_profile
 				else
 				{
 					$this->update_insert(PROFILE_FIELDS_LANG_TABLE, $sql_ary, array(
-						'field_id' => $field_id,
-						'lang_id' => (int) $default_lang_id,
-						'option_id' => (int) $option_id)
+						'field_id'	=> $field_id,
+						'lang_id'	=> (int) $default_lang_id,
+						'option_id'	=> (int) $option_id)
 					);
 				}
 			}
@@ -1464,6 +1207,276 @@ class acp_profile
 			}
 		}
 	}
+
+	/**
+	* Return sql statement for adding a new field ident (profile field) to the profile fields data table
+	*/
+	function add_field_ident($field_ident, $field_type)
+	{
+		global $db;
+
+		switch (SQL_LAYER)
+		{
+			case 'mysql':
+			case 'mysql4':
+			case 'mysqli':
+
+				// We are defining the biggest common value, because of the possibility to edit the min/max values of each field.
+				$sql = 'ALTER TABLE ' . PROFILE_FIELDS_DATA_TABLE . " ADD `$field_ident` ";
+
+				switch ($field_type)
+				{
+					case FIELD_STRING:
+						$sql .= ' VARCHAR(255) ';
+					break;
+
+					case FIELD_DATE:
+						$sql .= 'VARCHAR(10) ';
+					break;
+
+					case FIELD_TEXT:
+						$sql .= "TEXT";
+		//						ADD {$field_ident}_bbcode_uid VARCHAR(5) NOT NULL,
+		//						ADD {$field_ident}_bbcode_bitfield INT(11) UNSIGNED";
+					break;
+
+					case FIELD_BOOL:
+						$sql .= 'TINYINT(2) ';
+					break;
+				
+					case FIELD_DROPDOWN:
+						$sql .= 'MEDIUMINT(8) ';
+					break;
+
+					case FIELD_INT:
+						$sql .= 'BIGINT(20) ';
+					break;
+				}
+
+			break;
+
+			case 'sqlite':
+
+				switch ($field_type)
+				{
+					case FIELD_STRING:
+						$type = ' VARCHAR(255) ';
+					break;
+
+					case FIELD_DATE:
+						$type = 'VARCHAR(10) ';
+					break;
+
+					case FIELD_TEXT:
+						$type = "TEXT(65535)";
+		//						ADD {$field_ident}_bbcode_uid VARCHAR(5) NOT NULL,
+		//						ADD {$field_ident}_bbcode_bitfield INT(11) UNSIGNED";
+					break;
+
+					case FIELD_BOOL:
+						$type = 'TINYINT(2) ';
+					break;
+
+					case FIELD_DROPDOWN:
+						$type = 'MEDIUMINT(8) ';
+					break;
+
+					case FIELD_INT:
+						$type = 'BIGINT(20) ';
+					break;
+				}
+
+				// We are defining the biggest common value, because of the possibility to edit the min/max values of each field.
+				if (version_compare(sqlite_libversion(), '3.0') == -1)
+				{
+					$sql = "SELECT sql
+						FROM sqlite_master 
+						WHERE type = 'table' 
+							AND name = '" . PROFILE_FIELDS_DATA_TABLE . "'
+						ORDER BY type DESC, name;";
+					$result = $db->sql_query($sql);
+					$row = $db->sql_fetchrow($result);
+					$db->sql_freeresult($result);
+
+					// Create a temp table and populate it, destroy the existing one
+					$db->sql_query(preg_replace('#CREATE\s+TABLE\s+"?' . PROFILE_FIELDS_DATA_TABLE . '"?#i', 'CREATE TEMPORARY TABLE ' . PROFILE_FIELDS_DATA_TABLE . '_temp', $row['sql']));
+					$db->sql_query('INSERT INTO ' . PROFILE_FIELDS_DATA_TABLE . '_temp SELECT * FROM ' . PROFILE_FIELDS_DATA_TABLE);
+					$db->sql_query('DROP TABLE ' . PROFILE_FIELDS_DATA_TABLE);
+
+					preg_match('#\((.*)\)#s', $row['sql'], $matches);
+
+					$new_table_cols = trim($matches[1]);
+					$old_table_cols = explode(',', $new_table_cols);
+					$column_list = array();
+
+					foreach ($old_table_cols as $declaration)
+					{
+						$entities = preg_split('#\s+#', trim($declaration));
+						if ($entities == 'PRIMARY')
+						{
+							continue;
+						}
+						$column_list[] = $entities[0];
+					}
+
+					$columns = implode(',', $column_list);
+
+					$new_table_cols = $field_ident . ' ' . $type . ',' . $new_table_cols;
+
+					// create a new table and fill it up. destroy the temp one
+					$db->sql_query('CREATE TABLE ' . PROFILE_FIELDS_DATA_TABLE . ' (' . $new_table_cols . ');');
+					$db->sql_query('INSERT INTO ' . PROFILE_FIELDS_DATA_TABLE . ' (' . $columns . ') SELECT ' . $columns . ' FROM ' . PROFILE_FIELDS_DATA_TABLE . '_temp;');
+					$db->sql_query('DROP TABLE ' . PROFILE_FIELDS_DATA_TABLE . '_temp');
+				}
+				else
+				{
+					$sql = 'ALTER TABLE ' . PROFILE_FIELDS_DATA_TABLE . " ADD $field_ident [$type]";
+				}
+
+			break;
+
+			case 'mssql':
+			case 'mssql_odbc':
+
+				// We are defining the biggest common value, because of the possibility to edit the min/max values of each field.
+				$sql = 'ALTER TABLE [' . PROFILE_FIELDS_DATA_TABLE . "] ADD [$field_ident] ";
+
+				switch ($field_type)
+				{
+					case FIELD_STRING:
+						$sql .= ' [VARCHAR] (255) ';
+					break;
+
+					case FIELD_DATE:
+						$sql .= '[VARCHAR] (10) ';
+					break;
+
+					case FIELD_TEXT:
+						$sql .= "[TEXT]";
+		//						ADD {$field_ident}_bbcode_uid [VARCHAR] (5) NOT NULL,
+		//						ADD {$field_ident}_bbcode_bitfield [INT] UNSIGNED";
+					break;
+
+					case FIELD_BOOL:
+					case FIELD_DROPDOWN:
+						$sql .= '[INT] ';
+					break;
+
+					case FIELD_INT:
+						$sql .= '[FLOAT] ';
+					break;
+				}
+
+			break;
+
+			case 'postgres':
+
+				// We are defining the biggest common value, because of the possibility to edit the min/max values of each field.
+				$sql = 'ALTER TABLE ' . PROFILE_FIELDS_DATA_TABLE . " ADD COLUMN \"$field_ident\" ";
+
+				switch ($field_type)
+				{
+					case FIELD_STRING:
+						$sql .= ' VARCHAR(255) ';
+					break;
+
+					case FIELD_DATE:
+						$sql .= 'VARCHAR(10) ';
+					break;
+
+					case FIELD_TEXT:
+						$sql .= "TEXT";
+		//						ADD {$field_ident}_bbcode_uid VARCHAR(5) NOT NULL,
+		//						ADD {$field_ident}_bbcode_bitfield INT4 UNSIGNED";
+					break;
+
+					case FIELD_BOOL:
+						$sql .= 'INT2 ';
+					break;
+
+					case FIELD_DROPDOWN:
+						$sql .= 'INT4 ';
+					break;
+
+					case FIELD_INT:
+						$sql .= 'INT8 ';
+					break;
+				}
+
+			break;
+
+			case 'firebird':
+
+				// We are defining the biggest common value, because of the possibility to edit the min/max values of each field.
+				$sql = 'ALTER TABLE ' . PROFILE_FIELDS_DATA_TABLE . " ADD \"$field_ident\" ";
+
+				switch ($field_type)
+				{
+					case FIELD_STRING:
+						$sql .= ' VARCHAR(255) ';
+					break;
+
+					case FIELD_DATE:
+						$sql .= 'VARCHAR(10) ';
+					break;
+
+					case FIELD_TEXT:
+						$sql .= "BLOB SUB_TYPE TEXT";
+		//						ADD {$field_ident}_bbcode_uid VARCHAR(5) NOT NULL,
+		//						ADD {$field_ident}_bbcode_bitfield INTEGER UNSIGNED";
+					break;
+
+					case FIELD_BOOL:
+					case FIELD_DROPDOWN:
+						$sql .= 'INTEGER ';
+					break;
+
+					case FIELD_INT:
+						$sql .= 'DOUBLE PRECISION ';
+					break;
+				}
+
+			break;
+
+			case 'oracle':
+
+				// We are defining the biggest common value, because of the possibility to edit the min/max values of each field.
+				$sql = 'ALTER TABLE ' . PROFILE_FIELDS_DATA_TABLE . " ADD \"$field_ident\" ";
+
+				switch ($field_type)
+				{
+					case FIELD_STRING:
+						$sql .= ' VARCHAR2(255) ';
+					break;
+
+					case FIELD_DATE:
+						$sql .= 'VARCHAR2(10) ';
+					break;
+
+					case FIELD_TEXT:
+						$sql .= "CLOB";
+		//						ADD {$field_ident}_bbcode_uid VARCHAR2(5) NOT NULL,
+		//						ADD {$field_ident}_bbcode_bitfield NUMBER(11) UNSIGNED";
+					break;
+
+					case FIELD_BOOL:
+						$sql .= 'NUMBER(2) ';
+					break;
+
+					case FIELD_DROPDOWN:
+						$sql .= 'NUMBER(8) ';
+					break;
+
+					case FIELD_INT:
+						$sql .= 'NUMBER(20) ';
+					break;
+				}
+
+			break;
+		}
+
+		return $sql;
+	}
 }
 
 ?>
 \ No newline at end of file
diff --git a/phpBB/includes/acp/acp_users.php b/phpBB/includes/acp/acp_users.php
index 83d9e1c950..a69a0f6681 100644
--- a/phpBB/includes/acp/acp_users.php
+++ b/phpBB/includes/acp/acp_users.php
@@ -618,8 +618,8 @@ class acp_users
 
 					// Validation data
 					$var_ary = array(
-						'password_confirm'	=> array('string', true, $config['min_pass_chars'], $config['max_pass_chars']),
 						'user_password'		=> array('string', true, $config['min_pass_chars'], $config['max_pass_chars']),
+						'password_confirm'	=> array('string', true, $config['min_pass_chars'], $config['max_pass_chars']),
 						'warnings'			=> array('num'),
 					);
author	Meik Sievertsen <acydburn@phpbb.com>	2006-08-03 15:23:34 +0000
committer	Meik Sievertsen <acydburn@phpbb.com>	2006-08-03 15:23:34 +0000
commit	82f42bb5fa611e790e02bc679b88ce90b3f8156b (patch)
tree	7cb7cf746da4fd979569dc41dcec96db5f5c9acd /phpBB/includes/acp
parent	650007a5f18e0538b27bf93d674c264fef58c506 (diff)
download	forums-82f42bb5fa611e790e02bc679b88ce90b3f8156b.tar forums-82f42bb5fa611e790e02bc679b88ce90b3f8156b.tar.gz forums-82f42bb5fa611e790e02bc679b88ce90b3f8156b.tar.bz2 forums-82f42bb5fa611e790e02bc679b88ce90b3f8156b.tar.xz forums-82f42bb5fa611e790e02bc679b88ce90b3f8156b.zip