Code Duplication - jacobemerick/web - Measure and Improve Code Quality continuously with Scrutinizer

Code Duplication Length = 24-111 lines in 5 locations

collector/stream/DistanceCollector.class.inc.php 1 location



Loader::load('collector', 'Collector');

final class DistanceCollector extends Collector
{

	public static function getMissingDistances()
	{
		$query = "SELECT `id`, `date` FROM `jpemeric_stream`.`distance` WHERE `id` NOT IN (SELECT `type_id` FROM `jpemeric_stream`.`post` WHERE `type` = 'distance')";
		return self::run_query($query);
	}

	public static function getRow($id)
	{
		$query = "SELECT * FROM `jpemeric_stream`.`distance` WHERE `id` = '{$id}'";
		return self::run_row_query($query);
	}

	public static function getDistanceByFields($date, $type, $distance)
	{
		$type = self::escape($type);
		$distance = self::escape($distance);
		$query = "SELECT * FROM `jpemeric_stream`.`distance` WHERE `date` = '{$date}' && `type` = '{$type}' && `distance` = '{$distance}' LIMIT 1";
		return self::run_row_query($query);
	}

}

collector/waterfall/CompanionCollector.class.inc.php 1 location



Loader::load('collector', 'Collector');

final class CompanionCollector extends Collector
{

	public static function getByAlias($alias)
	{
		$alias = self::escape($alias);
		
		$query = "
			SELECT
				`companion`.`id`,
				`companion`.`name`,
				`companion`.`alias`,
				`companion`.`title`,
				`companion`.`description`,
				`companion`.`introduction`,
				`photo`.`name` AS `photo`,
				`photo_category`.`name` AS `photo_category`,
				`photo`.`description` AS `photo_description`
			FROM
				`jpemeric_waterfall`.`companion`
					LEFT JOIN (
						`jpemeric_image`.`photo`
							INNER JOIN
								`jpemeric_image`.`photo_category`
									ON `photo_category`.`id` = `photo`.`category`
						) ON `photo`.`id` = `companion`.`image`
			WHERE
				`companion`.`alias` = '{$alias}'
			LIMIT 1";
		
		return self::run_row_query($query);
	}

	public static function getCompanionList()
	{
		$query = "
			SELECT
				`companion`.`name`,
				`companion`.`alias`,
				COUNT(1) AS `count`
			FROM
				`jpemeric_waterfall`.`companion`
					INNER JOIN
						`jpemeric_waterfall`.`log_companion_map`
							ON `log_companion_map`.`companion` = `companion`.`id`
					INNER JOIN
						`jpemeric_waterfall`.`log`
							ON `log`.`id` = `log_companion_map`.`log`
			WHERE
				`log`.`is_public` = '1'
			GROUP BY
				`companion`.`alias`
			ORDER BY
				`companion`.`name`";
		
		return self::run_query($query);
	}

	public static function getLogListForCompanion($companion, $total, $offset = 0)
	{
		$query = "
			SELECT
				`log`.`id`,
				`log`.`title`,
				`log`.`alias`,
				`log`.`date`,
				`log`.`introduction`,
				`photo`.`name` AS `photo`,
				`photo_category`.`name` AS `photo_category`,
				`photo`.`description` AS `photo_description`
			FROM
				`jpemeric_waterfall`.`log`
					INNER JOIN
						`jpemeric_waterfall`.`log_companion_map`
							ON `log_companion_map`.`log` = `log`.`id`
					LEFT JOIN (
						`jpemeric_image`.`photo`
							INNER JOIN
								`jpemeric_image`.`photo_category`
									ON `photo_category`.`id` = `photo`.`category`
						) ON `photo`.`id` = `log`.`image`
			WHERE
				`log_companion_map`.`companion` = '{$companion}' &&
				`log`.`is_public` = '1'
			ORDER BY
				`log`.`date` DESC
			LIMIT
				{$offset}, {$total}";
		return self::run_query($query);
	}

	public static function getLogCountForCompanion($companion)
	{
		$query = "
			SELECT
				COUNT(1) AS `count`
			FROM
				`jpemeric_waterfall`.`log`
					INNER JOIN
						`jpemeric_waterfall`.`log_companion_map`
							ON `log_companion_map`.`log` = `log`.`id`
			WHERE
				`log_companion_map`.`companion` = '{$companion}' &&
				`log`.`is_public` = '1'";
		return self::get_count($query);
	}

}

collector/waterfall/CountyCollector.class.inc.php 1 location



Loader::load('collector', 'Collector');

final class CountyCollector extends Collector
{

	public static function getByAlias($alias)
	{
		$alias = self::escape($alias);
		
		$query = "
			SELECT
				`county`.`id`,
				`county`.`name`,
				`county`.`alias`,
				`county`.`title`,
				`county`.`description`,
				`county`.`introduction`,
				`photo`.`name` AS `photo`,
				`photo_category`.`name` AS `photo_category`,
				`photo`.`description` AS `photo_description`
			FROM
				`jpemeric_waterfall`.`county`
					LEFT JOIN (
						`jpemeric_image`.`photo`
							INNER JOIN
								`jpemeric_image`.`photo_category`
									ON `photo_category`.`id` = `photo`.`category`
						) ON `photo`.`id` = `county`.`image`
			WHERE
				`county`.`alias` = '{$alias}'
			LIMIT 1";
		
		return self::run_row_query($query);
	}

	public static function getCountyList()
	{
		$query = "
			SELECT
				`county`.`name`,
				`county`.`alias`,
				COUNT(1) AS `count`
			FROM
				`jpemeric_waterfall`.`county`
					INNER JOIN
						`jpemeric_waterfall`.`waterfall`
							ON `waterfall`.`county` = `county`.`id`
			WHERE
				`waterfall`.`is_public` = '1'
			GROUP BY
				`county`.`alias`
			ORDER BY
				`county`.`name`";
		
		return self::run_query($query);
	}

	public static function getLogListForCounty($county, $total, $offset = 0)
	{
		$query = "
			SELECT
				`waterfall`.`id`,
				`waterfall`.`name`,
				`waterfall`.`alias` AS `waterfall_alias`,
				`waterfall`.`rating`,
				`photo`.`name` AS `photo`,
				`photo_category`.`name` AS `photo_category`,
				`photo`.`description` AS `photo_description`,
				`watercourse`.`name` AS `watercourse`,
				`watercourse`.`alias` AS `watercourse_alias`,
				`county`.`title` AS `county`
			FROM
				`jpemeric_waterfall`.`waterfall`
					LEFT JOIN (
						`jpemeric_image`.`photo`
							INNER JOIN
								`jpemeric_image`.`photo_category`
									ON `photo_category`.`id` = `photo`.`category`
						) ON `photo`.`id` = `waterfall`.`image`
					INNER JOIN
						`jpemeric_waterfall`.`watercourse`
							ON `watercourse`.`id` = `waterfall`.`watercourse`
					INNER JOIN
						`jpemeric_waterfall`.`county`
							ON `county`.`id` = `waterfall`.`county`
			WHERE
				`county`.`id` = '{$county}' &&
				`waterfall`.`is_public` = '1'
			ORDER BY
				`waterfall`.`name`,
				`watercourse`.`name`
			LIMIT
				{$offset}, {$total}";
		return self::run_query($query);
	}

	public static function getLogCountForCounty($county)
	{
		$query = "
			SELECT
				COUNT(1) AS `count`
			FROM
				`jpemeric_waterfall`.`waterfall`
					INNER JOIN
						`jpemeric_waterfall`.`watercourse`
							ON `watercourse`.`id` = `waterfall`.`watercourse`
			WHERE
				`waterfall`.`county` = '{$county}' &&
				`waterfall`.`is_public` = '1'";
		return self::get_count($query);
	}

}

collector/waterfall/LogTagCollector.class.inc.php 1 location



Loader::load('collector', 'Collector');

final class LogTagCollector extends Collector
{

	public static function getTag($alias)
	{
		$alias = self::escape($alias);
		
		$query = "
			SELECT
				`tag`.`id`,
				`tag`.`name`,
				`tag`.`alias`
			FROM
				`jpemeric_waterfall`.`tag`
			WHERE
				`tag`.`alias` = '{$alias}'
			LIMIT 1";
		
		return self::run_row_query($query);
	}

	public static function getLogListForTag($tag, $total, $offset = 0)
	{
		$query = "
			SELECT
				`log`.`id`,
				`log`.`title`,
				`log`.`alias`,
				`log`.`date`,
				`log`.`introduction`,
				`photo`.`name` AS `photo`,
				`photo_category`.`name` AS `photo_category`,
				`photo`.`description` AS `photo_description`
			FROM
				`jpemeric_waterfall`.`log`
					INNER JOIN
						`jpemeric_waterfall`.`log_tag_map`
							ON `log_tag_map`.`log` = `log`.`id`
					LEFT JOIN (
						`jpemeric_image`.`photo`
							INNER JOIN
								`jpemeric_image`.`photo_category`
									ON `photo_category`.`id` = `photo`.`category`
						) ON `photo`.`id` = `log`.`image`
			WHERE
				`log_tag_map`.`tag` = '{$tag}' &&
				`log`.`is_public` = '1'
			ORDER BY
				`log`.`date` DESC
			LIMIT
				{$offset}, {$total}";
		
		return self::run_query($query);
	}

	public static function getLogCountForTag($tag)
	{
		$query = "
			SELECT
				COUNT(1) AS `count`
			FROM
				`jpemeric_waterfall`.`log`
					INNER JOIN
						`jpemeric_waterfall`.`log_tag_map`
							ON `log_tag_map`.`log` = `log`.`id`
			WHERE
				`log_tag_map`.`tag` = '{$tag}' &&
				`log`.`is_public` = '1'";
		
		return self::get_count($query);
	}

}

collector/waterfall/PeriodCollector.class.inc.php 1 location



Loader::load('collector', 'Collector');

final class PeriodCollector extends Collector
{

	public static function getByAlias($alias)
	{
		$alias = self::escape($alias);
		
		$query = "
			SELECT
				`period`.`id`,
				`period`.`name`,
				`period`.`alias`,
				`period`.`title`,
				`period`.`description`,
				`period`.`introduction`,
				`photo`.`name` AS `photo`,
				`photo_category`.`name` AS `photo_category`,
				`photo`.`description` AS `photo_description`
			FROM
				`jpemeric_waterfall`.`period`
					LEFT JOIN (
						`jpemeric_image`.`photo`
							INNER JOIN
								`jpemeric_image`.`photo_category`
									ON `photo_category`.`id` = `photo`.`category`
						) ON `photo`.`id` = `period`.`image`
			WHERE
				`period`.`alias` = '{$alias}'
			LIMIT 1";
		return self::run_row_query($query);
	}

	public static function getPeriodList()
	{
		$query = "
			SELECT
				`period`.`name`,
				`period`.`alias`,
				COUNT(1) AS `count`
			FROM
				`jpemeric_waterfall`.`period`
					INNER JOIN
						`jpemeric_waterfall`.`log`
							ON `log`.`period` = `period`.`id`
			WHERE
				`log`.`is_public` = '1'
			GROUP BY
				`period`.`alias`
			ORDER BY
				`period`.`id`";
		return self::run_query($query);
	}

	public static function getLogListForPeriod($period, $total, $offset = 0)
	{
		$query = "
			SELECT
				`log`.`id`,
				`log`.`title`,
				`log`.`alias`,
				`log`.`date`,
				`log`.`introduction`,
				`photo`.`name` AS `photo`,
				`photo_category`.`name` AS `photo_category`,
				`photo`.`description` AS `photo_description`
			FROM
				`jpemeric_waterfall`.`log`
					LEFT JOIN (
						`jpemeric_image`.`photo`
							INNER JOIN
								`jpemeric_image`.`photo_category`
									ON `photo_category`.`id` = `photo`.`category`
						) ON `photo`.`id` = `log`.`image`
			WHERE
				`log`.`period` = '{$period}' &&
				`log`.`is_public` = '1'
			ORDER BY
				`log`.`date` DESC
			LIMIT
				{$offset}, {$total}";
		
		return self::run_query($query);
	}

	public static function getLogCountForPeriod($period)
	{
		$query = "
			SELECT
				COUNT(1) AS `count`
			FROM
				`jpemeric_waterfall`.`log`
			WHERE
				`period` = '{$period}' &&
				`is_public` = '1'";
		return self::get_count($query);
	}

}

		@@ 5-28 (lines=24) @@
2
3		Loader::load('collector', 'Collector');
4
5		final class DistanceCollector extends Collector
6		{
7
8		public static function getMissingDistances()
9		{
10		$query = "SELECT `id`, `date` FROM `jpemeric_stream`.`distance` WHERE `id` NOT IN (SELECT `type_id` FROM `jpemeric_stream`.`post` WHERE `type` = 'distance')";
11		return self::run_query($query);
12		}
13
14		public static function getRow($id)
15		{
16		$query = "SELECT * FROM `jpemeric_stream`.`distance` WHERE `id` = '{$id}'";
17		return self::run_row_query($query);
18		}
19
20		public static function getDistanceByFields($date, $type, $distance)
21		{
22		$type = self::escape($type);
23		$distance = self::escape($distance);
24		$query = "SELECT * FROM `jpemeric_stream`.`distance` WHERE `date` = '{$date}' && `type` = '{$type}' && `distance` = '{$distance}' LIMIT 1";
25		return self::run_row_query($query);
26		}
27
28		}

		@@ 5-112 (lines=108) @@
2
3		Loader::load('collector', 'Collector');
4
5		final class CompanionCollector extends Collector
6		{
7
8		public static function getByAlias($alias)
9		{
10		$alias = self::escape($alias);
11
12		$query = "
13		SELECT
14		`companion`.`id`,
15		`companion`.`name`,
16		`companion`.`alias`,
17		`companion`.`title`,
18		`companion`.`description`,
19		`companion`.`introduction`,
20		`photo`.`name` AS `photo`,
21		`photo_category`.`name` AS `photo_category`,
22		`photo`.`description` AS `photo_description`
23		FROM
24		`jpemeric_waterfall`.`companion`
25		LEFT JOIN (
26		`jpemeric_image`.`photo`
27		INNER JOIN
28		`jpemeric_image`.`photo_category`
29		ON `photo_category`.`id` = `photo`.`category`
30		) ON `photo`.`id` = `companion`.`image`
31		WHERE
32		`companion`.`alias` = '{$alias}'
33		LIMIT 1";
34
35		return self::run_row_query($query);
36		}
37
38		public static function getCompanionList()
39		{
40		$query = "
41		SELECT
42		`companion`.`name`,
43		`companion`.`alias`,
44		COUNT(1) AS `count`
45		FROM
46		`jpemeric_waterfall`.`companion`
47		INNER JOIN
48		`jpemeric_waterfall`.`log_companion_map`
49		ON `log_companion_map`.`companion` = `companion`.`id`
50		INNER JOIN
51		`jpemeric_waterfall`.`log`
52		ON `log`.`id` = `log_companion_map`.`log`
53		WHERE
54		`log`.`is_public` = '1'
55		GROUP BY
56		`companion`.`alias`
57		ORDER BY
58		`companion`.`name`";
59
60		return self::run_query($query);
61		}
62
63		public static function getLogListForCompanion($companion, $total, $offset = 0)
64		{
65		$query = "
66		SELECT
67		`log`.`id`,
68		`log`.`title`,
69		`log`.`alias`,
70		`log`.`date`,
71		`log`.`introduction`,
72		`photo`.`name` AS `photo`,
73		`photo_category`.`name` AS `photo_category`,
74		`photo`.`description` AS `photo_description`
75		FROM
76		`jpemeric_waterfall`.`log`
77		INNER JOIN
78		`jpemeric_waterfall`.`log_companion_map`
79		ON `log_companion_map`.`log` = `log`.`id`
80		LEFT JOIN (
81		`jpemeric_image`.`photo`
82		INNER JOIN
83		`jpemeric_image`.`photo_category`
84		ON `photo_category`.`id` = `photo`.`category`
85		) ON `photo`.`id` = `log`.`image`
86		WHERE
87		`log_companion_map`.`companion` = '{$companion}' &&
88		`log`.`is_public` = '1'
89		ORDER BY
90		`log`.`date` DESC
91		LIMIT
92		{$offset}, {$total}";
93		return self::run_query($query);
94		}
95
96		public static function getLogCountForCompanion($companion)
97		{
98		$query = "
99		SELECT
100		COUNT(1) AS `count`
101		FROM
102		`jpemeric_waterfall`.`log`
103		INNER JOIN
104		`jpemeric_waterfall`.`log_companion_map`
105		ON `log_companion_map`.`log` = `log`.`id`
106		WHERE
107		`log_companion_map`.`companion` = '{$companion}' &&
108		`log`.`is_public` = '1'";
109		return self::get_count($query);
110		}
111
112		}

		@@ 5-115 (lines=111) @@
2
3		Loader::load('collector', 'Collector');
4
5		final class CountyCollector extends Collector
6		{
7
8		public static function getByAlias($alias)
9		{
10		$alias = self::escape($alias);
11
12		$query = "
13		SELECT
14		`county`.`id`,
15		`county`.`name`,
16		`county`.`alias`,
17		`county`.`title`,
18		`county`.`description`,
19		`county`.`introduction`,
20		`photo`.`name` AS `photo`,
21		`photo_category`.`name` AS `photo_category`,
22		`photo`.`description` AS `photo_description`
23		FROM
24		`jpemeric_waterfall`.`county`
25		LEFT JOIN (
26		`jpemeric_image`.`photo`
27		INNER JOIN
28		`jpemeric_image`.`photo_category`
29		ON `photo_category`.`id` = `photo`.`category`
30		) ON `photo`.`id` = `county`.`image`
31		WHERE
32		`county`.`alias` = '{$alias}'
33		LIMIT 1";
34
35		return self::run_row_query($query);
36		}
37
38		public static function getCountyList()
39		{
40		$query = "
41		SELECT
42		`county`.`name`,
43		`county`.`alias`,
44		COUNT(1) AS `count`
45		FROM
46		`jpemeric_waterfall`.`county`
47		INNER JOIN
48		`jpemeric_waterfall`.`waterfall`
49		ON `waterfall`.`county` = `county`.`id`
50		WHERE
51		`waterfall`.`is_public` = '1'
52		GROUP BY
53		`county`.`alias`
54		ORDER BY
55		`county`.`name`";
56
57		return self::run_query($query);
58		}
59
60		public static function getLogListForCounty($county, $total, $offset = 0)
61		{
62		$query = "
63		SELECT
64		`waterfall`.`id`,
65		`waterfall`.`name`,
66		`waterfall`.`alias` AS `waterfall_alias`,
67		`waterfall`.`rating`,
68		`photo`.`name` AS `photo`,
69		`photo_category`.`name` AS `photo_category`,
70		`photo`.`description` AS `photo_description`,
71		`watercourse`.`name` AS `watercourse`,
72		`watercourse`.`alias` AS `watercourse_alias`,
73		`county`.`title` AS `county`
74		FROM
75		`jpemeric_waterfall`.`waterfall`
76		LEFT JOIN (
77		`jpemeric_image`.`photo`
78		INNER JOIN
79		`jpemeric_image`.`photo_category`
80		ON `photo_category`.`id` = `photo`.`category`
81		) ON `photo`.`id` = `waterfall`.`image`
82		INNER JOIN
83		`jpemeric_waterfall`.`watercourse`
84		ON `watercourse`.`id` = `waterfall`.`watercourse`
85		INNER JOIN
86		`jpemeric_waterfall`.`county`
87		ON `county`.`id` = `waterfall`.`county`
88		WHERE
89		`county`.`id` = '{$county}' &&
90		`waterfall`.`is_public` = '1'
91		ORDER BY
92		`waterfall`.`name`,
93		`watercourse`.`name`
94		LIMIT
95		{$offset}, {$total}";
96		return self::run_query($query);
97		}
98
99		public static function getLogCountForCounty($county)
100		{
101		$query = "
102		SELECT
103		COUNT(1) AS `count`
104		FROM
105		`jpemeric_waterfall`.`waterfall`
106		INNER JOIN
107		`jpemeric_waterfall`.`watercourse`
108		ON `watercourse`.`id` = `waterfall`.`watercourse`
109		WHERE
110		`waterfall`.`county` = '{$county}' &&
111		`waterfall`.`is_public` = '1'";
112		return self::get_count($query);
113		}
114
115		}

		@@ 5-77 (lines=73) @@
2
3		Loader::load('collector', 'Collector');
4
5		final class LogTagCollector extends Collector
6		{
7
8		public static function getTag($alias)
9		{
10		$alias = self::escape($alias);
11
12		$query = "
13		SELECT
14		`tag`.`id`,
15		`tag`.`name`,
16		`tag`.`alias`
17		FROM
18		`jpemeric_waterfall`.`tag`
19		WHERE
20		`tag`.`alias` = '{$alias}'
21		LIMIT 1";
22
23		return self::run_row_query($query);
24		}
25
26		public static function getLogListForTag($tag, $total, $offset = 0)
27		{
28		$query = "
29		SELECT
30		`log`.`id`,
31		`log`.`title`,
32		`log`.`alias`,
33		`log`.`date`,
34		`log`.`introduction`,
35		`photo`.`name` AS `photo`,
36		`photo_category`.`name` AS `photo_category`,
37		`photo`.`description` AS `photo_description`
38		FROM
39		`jpemeric_waterfall`.`log`
40		INNER JOIN
41		`jpemeric_waterfall`.`log_tag_map`
42		ON `log_tag_map`.`log` = `log`.`id`
43		LEFT JOIN (
44		`jpemeric_image`.`photo`
45		INNER JOIN
46		`jpemeric_image`.`photo_category`
47		ON `photo_category`.`id` = `photo`.`category`
48		) ON `photo`.`id` = `log`.`image`
49		WHERE
50		`log_tag_map`.`tag` = '{$tag}' &&
51		`log`.`is_public` = '1'
52		ORDER BY
53		`log`.`date` DESC
54		LIMIT
55		{$offset}, {$total}";
56
57		return self::run_query($query);
58		}
59
60		public static function getLogCountForTag($tag)
61		{
62		$query = "
63		SELECT
64		COUNT(1) AS `count`
65		FROM
66		`jpemeric_waterfall`.`log`
67		INNER JOIN
68		`jpemeric_waterfall`.`log_tag_map`
69		ON `log_tag_map`.`log` = `log`.`id`
70		WHERE
71		`log_tag_map`.`tag` = '{$tag}' &&
72		`log`.`is_public` = '1'";
73
74		return self::get_count($query);
75		}
76
77		}

		@@ 5-102 (lines=98) @@
2
3		Loader::load('collector', 'Collector');
4
5		final class PeriodCollector extends Collector
6		{
7
8		public static function getByAlias($alias)
9		{
10		$alias = self::escape($alias);
11
12		$query = "
13		SELECT
14		`period`.`id`,
15		`period`.`name`,
16		`period`.`alias`,
17		`period`.`title`,
18		`period`.`description`,
19		`period`.`introduction`,
20		`photo`.`name` AS `photo`,
21		`photo_category`.`name` AS `photo_category`,
22		`photo`.`description` AS `photo_description`
23		FROM
24		`jpemeric_waterfall`.`period`
25		LEFT JOIN (
26		`jpemeric_image`.`photo`
27		INNER JOIN
28		`jpemeric_image`.`photo_category`
29		ON `photo_category`.`id` = `photo`.`category`
30		) ON `photo`.`id` = `period`.`image`
31		WHERE
32		`period`.`alias` = '{$alias}'
33		LIMIT 1";
34		return self::run_row_query($query);
35		}
36
37		public static function getPeriodList()
38		{
39		$query = "
40		SELECT
41		`period`.`name`,
42		`period`.`alias`,
43		COUNT(1) AS `count`
44		FROM
45		`jpemeric_waterfall`.`period`
46		INNER JOIN
47		`jpemeric_waterfall`.`log`
48		ON `log`.`period` = `period`.`id`
49		WHERE
50		`log`.`is_public` = '1'
51		GROUP BY
52		`period`.`alias`
53		ORDER BY
54		`period`.`id`";
55		return self::run_query($query);
56		}
57
58		public static function getLogListForPeriod($period, $total, $offset = 0)
59		{
60		$query = "
61		SELECT
62		`log`.`id`,
63		`log`.`title`,
64		`log`.`alias`,
65		`log`.`date`,
66		`log`.`introduction`,
67		`photo`.`name` AS `photo`,
68		`photo_category`.`name` AS `photo_category`,
69		`photo`.`description` AS `photo_description`
70		FROM
71		`jpemeric_waterfall`.`log`
72		LEFT JOIN (
73		`jpemeric_image`.`photo`
74		INNER JOIN
75		`jpemeric_image`.`photo_category`
76		ON `photo_category`.`id` = `photo`.`category`
77		) ON `photo`.`id` = `log`.`image`
78		WHERE
79		`log`.`period` = '{$period}' &&
80		`log`.`is_public` = '1'
81		ORDER BY
82		`log`.`date` DESC
83		LIMIT
84		{$offset}, {$total}";
85
86		return self::run_query($query);
87		}
88
89		public static function getLogCountForPeriod($period)
90		{
91		$query = "
92		SELECT
93		COUNT(1) AS `count`
94		FROM
95		`jpemeric_waterfall`.`log`
96		WHERE
97		`period` = '{$period}' &&
98		`is_public` = '1'";
99		return self::get_count($query);
100		}
101
102		}

jacobemerick / web

Code Duplication Length = 24-111 lines in 5 locations

collector/stream/DistanceCollector.class.inc.php 1 location

collector/waterfall/CompanionCollector.class.inc.php 1 location

collector/waterfall/CountyCollector.class.inc.php 1 location

collector/waterfall/LogTagCollector.class.inc.php 1 location

collector/waterfall/PeriodCollector.class.inc.php 1 location