@@ -5,6 +5,9 @@ |
||
5 | 5 | final class IntroductionCollector extends Collector |
6 | 6 | { |
7 | 7 | |
8 | + /** |
|
9 | + * @param string $type |
|
10 | + */ |
|
8 | 11 | public static function getRow($type, $value = '') |
9 | 12 | { |
10 | 13 | $query = "SELECT `title`,`content`,`image` FROM `jpemeric_blog`.`introduction` WHERE `type` = '{$type}' && `value` = '{$value}' LIMIT 1"; |
@@ -17,6 +17,9 @@ discard block |
||
17 | 17 | return self::run_query($query); |
18 | 18 | } |
19 | 19 | |
20 | + /** |
|
21 | + * @param integer $total |
|
22 | + */ |
|
20 | 23 | public static function getMainList($total, $offset = 0) |
21 | 24 | { |
22 | 25 | $query = "SELECT `post`.`id` AS `id`, `title`, `path`, `date`, `body`, `category` FROM `jpemeric_blog`.`post` WHERE `display` = '1' ORDER BY `date` DESC LIMIT {$offset}, {$total}"; |
@@ -29,6 +32,9 @@ discard block |
||
29 | 32 | return self::get_count($query); |
30 | 33 | } |
31 | 34 | |
35 | + /** |
|
36 | + * @param integer $total |
|
37 | + */ |
|
32 | 38 | public static function getPostsForTag($tag_id, $total, $offset = 0) |
33 | 39 | { |
34 | 40 | $query = "SELECT `post`.`id` AS `id`, `title`, `path`, `date`, `body`, `category` FROM `jpemeric_blog`.`post`,`jpemeric_blog`.`ptlink` WHERE `display` = '1' && `post`.`id` = `ptlink`.`post_id` && `ptlink`.`tag_id` = '{$tag_id}' ORDER BY `date` DESC LIMIT {$offset}, {$total}"; |
@@ -41,6 +47,9 @@ discard block |
||
41 | 47 | return self::get_count($query); |
42 | 48 | } |
43 | 49 | |
50 | + /** |
|
51 | + * @param integer $total |
|
52 | + */ |
|
44 | 53 | public static function getPostsForCategory($category, $total, $offset = 0) |
45 | 54 | { |
46 | 55 | $category = self::escape($category); |
@@ -83,6 +83,9 @@ |
||
83 | 83 | return self::run_query($query); |
84 | 84 | } |
85 | 85 | |
86 | + /** |
|
87 | + * @param integer $count |
|
88 | + */ |
|
86 | 89 | public static function getRecentBlogComments($count) |
87 | 90 | { |
88 | 91 | $query = " |
@@ -12,6 +12,9 @@ |
||
12 | 12 | return self::run_query($query); |
13 | 13 | } |
14 | 14 | |
15 | + /** |
|
16 | + * @param string $date |
|
17 | + */ |
|
15 | 18 | public static function getDistanceByFields($date, $type, $distance) |
16 | 19 | { |
17 | 20 | $type = self::escape($type); |
@@ -12,6 +12,9 @@ |
||
12 | 12 | return self::run_query($query); |
13 | 13 | } |
14 | 14 | |
15 | + /** |
|
16 | + * @param integer $action |
|
17 | + */ |
|
15 | 18 | public static function getHuluByFields($title, $action) |
16 | 19 | { |
17 | 20 | $title = self::escape($title); |
@@ -12,6 +12,9 @@ |
||
12 | 12 | return self::run_query($query); |
13 | 13 | } |
14 | 14 | |
15 | + /** |
|
16 | + * @param string $date |
|
17 | + */ |
|
15 | 18 | public static function getTweetByFields($date, $text) |
16 | 19 | { |
17 | 20 | $date = self::escape($date); |
@@ -19,6 +19,9 @@ |
||
19 | 19 | return self::run_row_query($query); |
20 | 20 | } |
21 | 21 | |
22 | + /** |
|
23 | + * @param integer $type |
|
24 | + */ |
|
22 | 25 | public static function getImagesForPiece($piece_id, $type) |
23 | 26 | { |
24 | 27 | $piece_id = self::escape($piece_id); |
@@ -35,6 +35,9 @@ discard block |
||
35 | 35 | return self::get_count($query); |
36 | 36 | } |
37 | 37 | |
38 | + /** |
|
39 | + * @param integer $offset |
|
40 | + */ |
|
38 | 41 | public static function getInRange($offset, $start) |
39 | 42 | { |
40 | 43 | $query = "SELECT * FROM `jpemeric_stream`.`post` ORDER BY `date` DESC LIMIT {$start}, {$offset}"; |
@@ -48,6 +51,9 @@ discard block |
||
48 | 51 | return self::get_count($query); |
49 | 52 | } |
50 | 53 | |
54 | + /** |
|
55 | + * @param integer $offset |
|
56 | + */ |
|
51 | 57 | public static function getByTagInRange($tag, $offset, $start) |
52 | 58 | { |
53 | 59 | $tag = self::escape($tag); |
@@ -17,6 +17,9 @@ |
||
17 | 17 | return self::run_row_query($query); |
18 | 18 | } |
19 | 19 | |
20 | + /** |
|
21 | + * @param string $date |
|
22 | + */ |
|
20 | 23 | public static function getDistanceByFields($date, $type, $distance) |
21 | 24 | { |
22 | 25 | $type = self::escape($type); |