Code Duplication - ErnadoO/mod-phpbb-directory - Measure and Improve Code Quality continuously with Scrutinizer

Code Duplication Length = 17-18 lines in 2 locations

root/includes/acp/acp_directory.php 2 locations


					{
						switch ($action)
						{
							case 'votes':
								switch ($db->sql_layer)
								{
									case 'sqlite':
									case 'firebird':
										$db->sql_query('DELETE FROM ' . DIR_VOTE_TABLE);
									break;

									default:
										$db->sql_query('TRUNCATE TABLE ' . DIR_VOTE_TABLE);
									break;
								}

								$sql = 'UPDATE ' . DIR_LINK_TABLE . ' SET
									link_vote = 0,
									link_note = 0';
								$db->sql_query($sql);
							break;

							case 'comments':
								switch ($db->sql_layer)

								$db->sql_query($sql);
							break;

							case 'comments':
								switch ($db->sql_layer)
								{
									case 'sqlite':
									case 'firebird':
										$db->sql_query('DELETE FROM ' . DIR_COMMENT_TABLE);
									break;

									default:
										$db->sql_query('TRUNCATE TABLE ' . DIR_COMMENT_TABLE);
									break;
								}

								$sql = 'UPDATE ' . DIR_LINK_TABLE . ' SET
									link_comment = 0';
								$db->sql_query($sql);
							break;

							case 'clicks':
								$sql = 'UPDATE ' . DIR_LINK_TABLE . ' SET

		@@ 103-120 (lines=18) @@
100		{
101		switch ($action)
102		{
103		case 'votes':
104		switch ($db->sql_layer)
105		{
106		case 'sqlite':
107		case 'firebird':
108		$db->sql_query('DELETE FROM ' . DIR_VOTE_TABLE);
109		break;
110
111		default:
112		$db->sql_query('TRUNCATE TABLE ' . DIR_VOTE_TABLE);
113		break;
114		}
115
116		$sql = 'UPDATE ' . DIR_LINK_TABLE . ' SET
117		link_vote = 0,
118		link_note = 0';
119		$db->sql_query($sql);
120		break;
121
122		case 'comments':
123		switch ($db->sql_layer)
		@@ 122-138 (lines=17) @@
119		$db->sql_query($sql);
120		break;
121
122		case 'comments':
123		switch ($db->sql_layer)
124		{
125		case 'sqlite':
126		case 'firebird':
127		$db->sql_query('DELETE FROM ' . DIR_COMMENT_TABLE);
128		break;
129
130		default:
131		$db->sql_query('TRUNCATE TABLE ' . DIR_COMMENT_TABLE);
132		break;
133		}
134
135		$sql = 'UPDATE ' . DIR_LINK_TABLE . ' SET
136		link_comment = 0';
137		$db->sql_query($sql);
138		break;
139
140		case 'clicks':
141		$sql = 'UPDATE ' . DIR_LINK_TABLE . ' SET

ErnadoO / mod-phpbb-directory

Code Duplication Length = 17-18 lines in 2 locations

root/includes/acp/acp_directory.php 2 locations