Completed
Push — master ( cf0c7a...520b04 )
by Jacob
03:43
created

BlogCollector::getRow()   A

Complexity

Conditions 1
Paths 1

Size

Total Lines 5
Code Lines 3

Duplication

Lines 0
Ratio 0 %
Metric Value
dl 0
loc 5
rs 9.4286
cc 1
eloc 3
nc 1
nop 1
1
<?
0 ignored issues
show
Security Best Practice introduced by
It is not recommend to use PHP's short opening tag <?, better use <?php, or <?= in case of outputting.

Short opening tags are disabled in PHP’s default configuration. In such a case, all content of this file is output verbatim to the browser without being parsed, or executed.

As a precaution to avoid these problems better use the long opening tag <?php.

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