| @@ -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 = " | 
| @@ -163,10 +163,11 @@ | ||
| 163 | 163 |  	{
 | 
| 164 | 164 | $path = self::escape($path); | 
| 165 | 165 | |
| 166 | - if($commenter != 0) | |
| 167 | -			$trusted_commenter_clause = "(`commenter`.`trusted` = '1' || `commenter`.`id` = '{$commenter}')";
 | |
| 168 | - else | |
| 169 | - $trusted_commenter_clause = "`commenter`.`trusted` = '1'"; | |
| 166 | +		if($commenter != 0) {
 | |
| 167 | +					$trusted_commenter_clause = "(`commenter`.`trusted` = '1' || `commenter`.`id` = '{$commenter}')";
 | |
| 168 | +		} else {
 | |
| 169 | + $trusted_commenter_clause = "`commenter`.`trusted` = '1'"; | |
| 170 | + } | |
| 170 | 171 | |
| 171 | 172 | $query = " | 
| 172 | 173 | SELECT | 
| @@ -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); | 
| @@ -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 getTweetByFields($date, $text) | 
| 21 | 24 |  	{
 | 
| 22 | 25 |  		$query = "SELECT * FROM `jpemeric_stream`.`twitter` WHERE `date` = '{$date}' && `text` = '{$text}' LIMIT 1";
 | 
| @@ -34,6 +34,9 @@ discard block | ||
| 34 | 34 | return self::run_query($query); | 
| 35 | 35 | } | 
| 36 | 36 | |
| 37 | + /** | |
| 38 | + * @param integer $total | |
| 39 | + */ | |
| 37 | 40 | public static function getRecentList($total) | 
| 38 | 41 |      {
 | 
| 39 | 42 | $query = " | 
| @@ -178,6 +181,9 @@ discard block | ||
| 178 | 181 | return self::run_row_query($query); | 
| 179 | 182 | } | 
| 180 | 183 | |
| 184 | + /** | |
| 185 | + * @param string $date | |
| 186 | + */ | |
| 181 | 187 | public static function getByDate($date) | 
| 182 | 188 |      {
 | 
| 183 | 189 | $date = self::escape($date); | 
| @@ -117,6 +117,9 @@ | ||
| 117 | 117 | return self::run_query($query); | 
| 118 | 118 | } | 
| 119 | 119 | |
| 120 | + /** | |
| 121 | + * @param string $alias | |
| 122 | + */ | |
| 120 | 123 | public static function getByOldAlias($alias) | 
| 121 | 124 |      {
 | 
| 122 | 125 | $alias = self::escape($alias); | 
| @@ -97,6 +97,9 @@ | ||
| 97 | 97 | return $tag_array; | 
| 98 | 98 | } | 
| 99 | 99 | |
| 100 | + /** | |
| 101 | + * @param boolean $trim | |
| 102 | + */ | |
| 100 | 103 | final private function get_body_for_post($post, $trim) | 
| 101 | 104 |  	{
 | 
| 102 | 105 | $body = $post->body; | 
| @@ -37,8 +37,9 @@ discard block | ||
| 37 | 37 |  		Loader::load('collector', 'image/PhotoCollector');
 | 
| 38 | 38 | $photo_result = PhotoCollector::getRow($id); | 
| 39 | 39 | |
| 40 | - if($photo_result == null) | |
| 41 | - return; | |
| 40 | +		if($photo_result == null) {
 | |
| 41 | + return; | |
| 42 | + } | |
| 42 | 43 | |
| 43 | 44 | $name = $photo_result->name; | 
| 44 | 45 | $category = $photo_result->category; | 
| @@ -101,8 +102,9 @@ discard block | ||
| 101 | 102 |  	{
 | 
| 102 | 103 | $body = $post->body; | 
| 103 | 104 | |
| 104 | - if($trim) | |
| 105 | -			$body = Content::instance('SmartTrim', $body)->activate(self::$LENGTH_OF_TRIMMED_POST);
 | |
| 105 | +		if($trim) {
 | |
| 106 | +					$body = Content::instance('SmartTrim', $body)->activate(self::$LENGTH_OF_TRIMMED_POST);
 | |
| 107 | + } | |
| 106 | 108 | |
| 107 | 109 |  		$body = Content::instance('FixPhoto', $body)->activate(false, 'standard');
 | 
| 108 | 110 |  		$body = Content::instance('MarkupCode', $body)->activate();
 | 
| @@ -128,8 +130,9 @@ discard block | ||
| 128 | 130 | $cloud_array = array(); | 
| 129 | 131 | foreach($tag_result as $tag) | 
| 130 | 132 |  		{
 | 
| 131 | - if($tag->tag_count < self::$MINIMUM_TAG_COUNT) | |
| 132 | - continue; | |
| 133 | +			if($tag->tag_count < self::$MINIMUM_TAG_COUNT) {
 | |
| 134 | + continue; | |
| 135 | + } | |
| 133 | 136 | |
| 134 | 137 | $tag_object = new stdclass(); | 
| 135 | 138 | $tag_object->name = $tag->tag; | 
| @@ -147,8 +150,9 @@ discard block | ||
| 147 | 150 | |
| 148 | 151 | foreach($tag_result as $tag) | 
| 149 | 152 |  		{
 | 
| 150 | - if($tag->tag_count > $maximum) | |
| 151 | - $maximum = $tag->tag_count; | |
| 153 | +			if($tag->tag_count > $maximum) {
 | |
| 154 | + $maximum = $tag->tag_count; | |
| 155 | + } | |
| 152 | 156 | } | 
| 153 | 157 | return $maximum; | 
| 154 | 158 | } |