@@ -49,8 +49,7 @@ discard block |
||
| 49 | 49 | { |
| 50 | 50 | $this->set_title(sprintf(self::$TITLE_MAIN, ucwords($this->query))); |
| 51 | 51 | $this->set_description(sprintf(self::$DESCRIPTION_MAIN, ucwords($this->query))); |
| 52 | - } |
|
| 53 | - else |
|
| 52 | + } else |
|
| 54 | 53 | { |
| 55 | 54 | $this->set_title(sprintf(self::$TITLE_PAGINATED, ucwords($this->query), $this->page, $this->total_pages)); |
| 56 | 55 | $this->set_description(sprintf(self::$DESCRIPTION_PAGINATED, $this->page, $this->total_pages, ucwords($this->query))); |
@@ -63,22 +62,24 @@ discard block |
||
| 63 | 62 | |
| 64 | 63 | protected function get_introduction() |
| 65 | 64 | { |
| 66 | - if($this->total_pages > 1) |
|
| 67 | - return array( |
|
| 68 | - 'title' => "Posts from search '{$this->query}', page {$this->page} of {$this->total_pages}."); |
|
| 69 | - else if($this->total_pages == 1) |
|
| 70 | - return array( |
|
| 71 | - 'title' => "Posts from search '{$this->query}'."); |
|
| 72 | - else |
|
| 73 | - return array( |
|
| 74 | - 'title' => "Sorry, '{$this->query}' didn't return any posts."); |
|
| 65 | + if($this->total_pages > 1) {
|
|
| 66 | + return array( |
|
| 67 | + 'title' => "Posts from search '{$this->query}', page {$this->page} of {$this->total_pages}.");
|
|
| 68 | + } else if($this->total_pages == 1) {
|
|
| 69 | + return array( |
|
| 70 | + 'title' => "Posts from search '{$this->query}'.");
|
|
| 71 | + } else {
|
|
| 72 | + return array( |
|
| 73 | + 'title' => "Sorry, '{$this->query}' didn't return any posts.");
|
|
| 74 | + } |
|
| 75 | 75 | } |
| 76 | 76 | |
| 77 | 77 | protected function get_page_number() |
| 78 | 78 | { |
| 79 | 79 | $page = URLDecode::getPiece(3); |
| 80 | - if(isset($page) && is_numeric($page)) |
|
| 81 | - return $page; |
|
| 80 | + if(isset($page) && is_numeric($page)) {
|
|
| 81 | + return $page; |
|
| 82 | + } |
|
| 82 | 83 | return 1; |
| 83 | 84 | } |
| 84 | 85 | |
@@ -113,25 +114,29 @@ discard block |
||
| 113 | 114 | |
| 114 | 115 | protected function get_list_next_link() |
| 115 | 116 | { |
| 116 | - if($this->page == 1) |
|
| 117 | - return; |
|
| 118 | - if($this->page == 2) |
|
| 119 | - return Content::instance('URLSafe', "/search/{$this->query}/")->activate(); |
|
| 117 | + if($this->page == 1) {
|
|
| 118 | + return; |
|
| 119 | + } |
|
| 120 | + if($this->page == 2) {
|
|
| 121 | + return Content::instance('URLSafe', "/search/{$this->query}/")->activate();
|
|
| 122 | + } |
|
| 120 | 123 | return Content::instance('URLSafe', "/search/{$this->query}/" . ($this->page - 1) . '/')->activate(); |
| 121 | 124 | } |
| 122 | 125 | |
| 123 | 126 | protected function get_list_prev_link() |
| 124 | 127 | { |
| 125 | - if(($this->page * self::$POSTS_PER_PAGE) >= $this->get_total_post_count()) |
|
| 126 | - return; |
|
| 128 | + if(($this->page * self::$POSTS_PER_PAGE) >= $this->get_total_post_count()) {
|
|
| 129 | + return; |
|
| 130 | + } |
|
| 127 | 131 | return Content::instance('URLSafe', "/search/{$this->query}/" . ($this->page + 1) . '/')->activate(); |
| 128 | 132 | } |
| 129 | 133 | |
| 130 | 134 | private $total_post_count; |
| 131 | 135 | protected function get_total_post_count() |
| 132 | 136 | { |
| 133 | - if(!isset($this->total_post_count)) |
|
| 134 | - $this->total_post_count = count($this->get_search_result()); |
|
| 137 | + if(!isset($this->total_post_count)) {
|
|
| 138 | + $this->total_post_count = count($this->get_search_result()); |
|
| 139 | + } |
|
| 135 | 140 | return $this->total_post_count; |
| 136 | 141 | } |
| 137 | 142 | |
@@ -34,7 +34,7 @@ discard block |
||
| 34 | 34 | { |
| 35 | 35 | $query = URLDecode::getPiece(2); |
| 36 | 36 | $query = urldecode($query); |
| 37 | - $query = str_replace('-', ' ', $query); |
|
| 37 | + $query = str_replace('-', ' ', $query); |
|
| 38 | 38 | |
| 39 | 39 | $this->query = $query; |
| 40 | 40 | |
@@ -87,9 +87,9 @@ discard block |
||
| 87 | 87 | { |
| 88 | 88 | if(!isset($this->search_result)) |
| 89 | 89 | { |
| 90 | - global $container; |
|
| 91 | - $repository = new Jacobemerick\Web\Domain\Blog\Post\MysqlPostRepository($container['db_connection_locator']); |
|
| 92 | - $posts = $repository->getActivePosts(); |
|
| 90 | + global $container; |
|
| 91 | + $repository = new Jacobemerick\Web\Domain\Blog\Post\MysqlPostRepository($container['db_connection_locator']); |
|
| 92 | + $posts = $repository->getActivePosts(); |
|
| 93 | 93 | |
| 94 | 94 | $this->search_result = Search::instance() |
| 95 | 95 | ->setQuery($this->query) |
@@ -44,7 +44,7 @@ discard block |
||
| 44 | 44 | { |
| 45 | 45 | parent::set_head_data(); |
| 46 | 46 | |
| 47 | - if($this->page == 1) |
|
| 47 | + if ($this->page == 1) |
|
| 48 | 48 | { |
| 49 | 49 | $this->set_title(sprintf(self::$TITLE_MAIN, ucwords($this->query))); |
| 50 | 50 | $this->set_description(sprintf(self::$DESCRIPTION_MAIN, ucwords($this->query))); |
@@ -62,10 +62,10 @@ discard block |
||
| 62 | 62 | |
| 63 | 63 | protected function get_introduction() |
| 64 | 64 | { |
| 65 | - if($this->total_pages > 1) |
|
| 65 | + if ($this->total_pages > 1) |
|
| 66 | 66 | return array( |
| 67 | 67 | 'title' => "Posts from search '{$this->query}', page {$this->page} of {$this->total_pages}."); |
| 68 | - else if($this->total_pages == 1) |
|
| 68 | + else if ($this->total_pages == 1) |
|
| 69 | 69 | return array( |
| 70 | 70 | 'title' => "Posts from search '{$this->query}'."); |
| 71 | 71 | else |
@@ -76,7 +76,7 @@ discard block |
||
| 76 | 76 | protected function get_page_number() |
| 77 | 77 | { |
| 78 | 78 | $page = URLDecode::getPiece(3); |
| 79 | - if(isset($page) && is_numeric($page)) |
|
| 79 | + if (isset($page) && is_numeric($page)) |
|
| 80 | 80 | return $page; |
| 81 | 81 | return 1; |
| 82 | 82 | } |
@@ -84,7 +84,7 @@ discard block |
||
| 84 | 84 | private $search_result; |
| 85 | 85 | private function get_search_result() |
| 86 | 86 | { |
| 87 | - if(!isset($this->search_result)) |
|
| 87 | + if (!isset($this->search_result)) |
|
| 88 | 88 | { |
| 89 | 89 | global $container; |
| 90 | 90 | $repository = new Jacobemerick\Web\Domain\Blog\Post\MysqlPostRepository($container['db_connection_locator']); |
@@ -114,24 +114,24 @@ discard block |
||
| 114 | 114 | |
| 115 | 115 | protected function get_list_next_link() |
| 116 | 116 | { |
| 117 | - if($this->page == 1) |
|
| 117 | + if ($this->page == 1) |
|
| 118 | 118 | return; |
| 119 | - if($this->page == 2) |
|
| 119 | + if ($this->page == 2) |
|
| 120 | 120 | return Content::instance('URLSafe', "/search/{$this->query}/")->activate(); |
| 121 | - return Content::instance('URLSafe', "/search/{$this->query}/" . ($this->page - 1) . '/')->activate(); |
|
| 121 | + return Content::instance('URLSafe', "/search/{$this->query}/".($this->page - 1).'/')->activate(); |
|
| 122 | 122 | } |
| 123 | 123 | |
| 124 | 124 | protected function get_list_prev_link() |
| 125 | 125 | { |
| 126 | - if(($this->page * self::$POSTS_PER_PAGE) >= $this->get_total_post_count()) |
|
| 126 | + if (($this->page * self::$POSTS_PER_PAGE) >= $this->get_total_post_count()) |
|
| 127 | 127 | return; |
| 128 | - return Content::instance('URLSafe', "/search/{$this->query}/" . ($this->page + 1) . '/')->activate(); |
|
| 128 | + return Content::instance('URLSafe', "/search/{$this->query}/".($this->page + 1).'/')->activate(); |
|
| 129 | 129 | } |
| 130 | 130 | |
| 131 | 131 | private $total_post_count; |
| 132 | 132 | protected function get_total_post_count() |
| 133 | 133 | { |
| 134 | - if(!isset($this->total_post_count)) |
|
| 134 | + if (!isset($this->total_post_count)) |
|
| 135 | 135 | $this->total_post_count = count($this->get_search_result()); |
| 136 | 136 | return $this->total_post_count; |
| 137 | 137 | } |
@@ -56,11 +56,11 @@ |
||
| 56 | 56 | final private function get_list_posts() |
| 57 | 57 | { |
| 58 | 58 | $post_array = array(); |
| 59 | - foreach($this->get_list_results() as $post) |
|
| 59 | + foreach ($this->get_list_results() as $post) |
|
| 60 | 60 | { |
| 61 | 61 | $post_array[] = $this->format_post($post, true); |
| 62 | 62 | } |
| 63 | - if(count($post_array) < 1 && URLDecode::getPiece(1) !== 'search') |
|
| 63 | + if (count($post_array) < 1 && URLDecode::getPiece(1) !== 'search') |
|
| 64 | 64 | $this->eject(); |
| 65 | 65 | return $post_array; |
| 66 | 66 | } |
@@ -60,8 +60,9 @@ |
||
| 60 | 60 | { |
| 61 | 61 | $post_array[] = $this->format_post($post, true); |
| 62 | 62 | } |
| 63 | - if(count($post_array) < 1 && URLDecode::getPiece(1) !== 'search') |
|
| 64 | - $this->eject(); |
|
| 63 | + if(count($post_array) < 1 && URLDecode::getPiece(1) !== 'search') {
|
|
| 64 | + $this->eject(); |
|
| 65 | + } |
|
| 65 | 66 | return $post_array; |
| 66 | 67 | } |
| 67 | 68 | |
@@ -41,7 +41,7 @@ discard block |
||
| 41 | 41 | $active_page = $this->get_active_page(); |
| 42 | 42 | |
| 43 | 43 | $menu = array(); |
| 44 | - foreach(self::$MENU as $item) |
|
| 44 | + foreach (self::$MENU as $item) |
|
| 45 | 45 | { |
| 46 | 46 | $menu[] = (object) array( |
| 47 | 47 | 'name' => $item['name'], |
@@ -56,13 +56,13 @@ discard block |
||
| 56 | 56 | { |
| 57 | 57 | $current_uri = URLDecode::getPiece(1); |
| 58 | 58 | |
| 59 | - if(!isset($current_uri)) |
|
| 59 | + if (!isset($current_uri)) |
|
| 60 | 60 | return 'About'; |
| 61 | 61 | |
| 62 | 62 | $menu = self::$MENU; |
| 63 | - foreach($menu as $link) |
|
| 63 | + foreach ($menu as $link) |
|
| 64 | 64 | { |
| 65 | - if($link['uri'] == $current_uri) |
|
| 65 | + if ($link['uri'] == $current_uri) |
|
| 66 | 66 | return $link['name']; |
| 67 | 67 | } |
| 68 | 68 | |
@@ -56,14 +56,16 @@ |
||
| 56 | 56 | { |
| 57 | 57 | $current_uri = URLDecode::getPiece(1); |
| 58 | 58 | |
| 59 | - if(!isset($current_uri)) |
|
| 60 | - return 'About'; |
|
| 59 | + if(!isset($current_uri)) {
|
|
| 60 | + return 'About'; |
|
| 61 | + } |
|
| 61 | 62 | |
| 62 | 63 | $menu = self::$MENU; |
| 63 | 64 | foreach($menu as $link) |
| 64 | 65 | { |
| 65 | - if($link['uri'] == $current_uri) |
|
| 66 | - return $link['name']; |
|
| 66 | + if($link['uri'] == $current_uri) {
|
|
| 67 | + return $link['name']; |
|
| 68 | + } |
|
| 67 | 69 | } |
| 68 | 70 | |
| 69 | 71 | return 'About'; |
@@ -29,15 +29,19 @@ |
||
| 29 | 29 | |
| 30 | 30 | private function get_form_results() |
| 31 | 31 | { |
| 32 | - if(!Request::hasPost()) |
|
| 33 | - return array(); |
|
| 32 | + if(!Request::hasPost()) {
|
|
| 33 | + return array(); |
|
| 34 | + } |
|
| 34 | 35 | |
| 35 | - if(!Validate::checkRequest('post', 'name', 'string')) |
|
| 36 | - $error_message['name'] = 'Please enter a value for your name.'; |
|
| 37 | - if(!Validate::checkRequest('post', 'email', 'string')) |
|
| 38 | - $error_message['email'] = 'Please enter a valid email address.'; |
|
| 39 | - if(!Validate::checkRequest('post', 'message', 'string')) |
|
| 40 | - $error_message['message'] = 'Please enter a message.'; |
|
| 36 | + if(!Validate::checkRequest('post', 'name', 'string')) {
|
|
| 37 | + $error_message['name'] = 'Please enter a value for your name.'; |
|
| 38 | + } |
|
| 39 | + if(!Validate::checkRequest('post', 'email', 'string')) {
|
|
| 40 | + $error_message['email'] = 'Please enter a valid email address.'; |
|
| 41 | + } |
|
| 42 | + if(!Validate::checkRequest('post', 'message', 'string')) {
|
|
| 43 | + $error_message['message'] = 'Please enter a message.'; |
|
| 44 | + } |
|
| 41 | 45 | |
| 42 | 46 | if(!empty($error_message)) |
| 43 | 47 | { |
@@ -46,16 +46,16 @@ |
||
| 46 | 46 | 'value' => Request::getPost()); |
| 47 | 47 | } |
| 48 | 48 | |
| 49 | - global $container; |
|
| 50 | - $sent = $container['mail'] |
|
| 51 | - ->addTo($container['config']->admin_email) |
|
| 52 | - ->setSubject('Site Contact') |
|
| 53 | - ->setPlainMessage( |
|
| 54 | - 'Name: ' . Request::getPost('name') . "\n" . |
|
| 55 | - 'Email: ' . Request::getPost('email') . "\n" . |
|
| 56 | - 'Message: ' . Request::getPost('message') |
|
| 57 | - ) |
|
| 58 | - ->send(); |
|
| 49 | + global $container; |
|
| 50 | + $sent = $container['mail'] |
|
| 51 | + ->addTo($container['config']->admin_email) |
|
| 52 | + ->setSubject('Site Contact') |
|
| 53 | + ->setPlainMessage( |
|
| 54 | + 'Name: ' . Request::getPost('name') . "\n" . |
|
| 55 | + 'Email: ' . Request::getPost('email') . "\n" . |
|
| 56 | + 'Message: ' . Request::getPost('message') |
|
| 57 | + ) |
|
| 58 | + ->send(); |
|
| 59 | 59 | |
| 60 | 60 | return array( |
| 61 | 61 | 'success_message' => "Thank you for your message, " . Request::getPost('name') . "! I'll get back to you as soon as possible."); |
@@ -28,17 +28,17 @@ discard block |
||
| 28 | 28 | |
| 29 | 29 | private function get_form_results() |
| 30 | 30 | { |
| 31 | - if(!Request::hasPost()) |
|
| 31 | + if (!Request::hasPost()) |
|
| 32 | 32 | return array(); |
| 33 | 33 | |
| 34 | - if(!Validate::checkRequest('post', 'name', 'string')) |
|
| 34 | + if (!Validate::checkRequest('post', 'name', 'string')) |
|
| 35 | 35 | $error_message['name'] = 'Please enter a value for your name.'; |
| 36 | - if(!Validate::checkRequest('post', 'email', 'string')) |
|
| 36 | + if (!Validate::checkRequest('post', 'email', 'string')) |
|
| 37 | 37 | $error_message['email'] = 'Please enter a valid email address.'; |
| 38 | - if(!Validate::checkRequest('post', 'message', 'string')) |
|
| 38 | + if (!Validate::checkRequest('post', 'message', 'string')) |
|
| 39 | 39 | $error_message['message'] = 'Please enter a message.'; |
| 40 | 40 | |
| 41 | - if(!empty($error_message)) |
|
| 41 | + if (!empty($error_message)) |
|
| 42 | 42 | { |
| 43 | 43 | return array( |
| 44 | 44 | 'error_message' => $error_message, |
@@ -50,14 +50,14 @@ discard block |
||
| 50 | 50 | ->addTo($container['config']->admin_email) |
| 51 | 51 | ->setSubject('Site Contact') |
| 52 | 52 | ->setPlainMessage( |
| 53 | - 'Name: ' . Request::getPost('name') . "\n" . |
|
| 54 | - 'Email: ' . Request::getPost('email') . "\n" . |
|
| 55 | - 'Message: ' . Request::getPost('message') |
|
| 53 | + 'Name: '.Request::getPost('name')."\n". |
|
| 54 | + 'Email: '.Request::getPost('email')."\n". |
|
| 55 | + 'Message: '.Request::getPost('message') |
|
| 56 | 56 | ) |
| 57 | 57 | ->send(); |
| 58 | 58 | |
| 59 | 59 | return array( |
| 60 | - 'success_message' => "Thank you for your message, " . Request::getPost('name') . "! I'll get back to you as soon as possible."); |
|
| 60 | + 'success_message' => "Thank you for your message, ".Request::getPost('name')."! I'll get back to you as soon as possible."); |
|
| 61 | 61 | } |
| 62 | 62 | |
| 63 | 63 | } |
@@ -29,7 +29,7 @@ |
||
| 29 | 29 | Loader::load('collector', 'data/ChangelogCollector'); |
| 30 | 30 | $changelog_result = ChangelogCollector::getLast20Changes(); |
| 31 | 31 | |
| 32 | - foreach($changelog_result as $change) |
|
| 32 | + foreach ($changelog_result as $change) |
|
| 33 | 33 | { |
| 34 | 34 | $changelog[] = (object) array( |
| 35 | 35 | 'date' => (object) array( |
@@ -28,9 +28,9 @@ |
||
| 28 | 28 | |
| 29 | 29 | private function get_changelog() |
| 30 | 30 | { |
| 31 | - global $container; |
|
| 32 | - $changelogRepository = new MysqlChangelogRepository($container['db_connection_locator']); |
|
| 33 | - $changelog_result = $changelogRepository->getChanges(40); |
|
| 31 | + global $container; |
|
| 32 | + $changelogRepository = new MysqlChangelogRepository($container['db_connection_locator']); |
|
| 33 | + $changelog_result = $changelogRepository->getChanges(40); |
|
| 34 | 34 | |
| 35 | 35 | foreach($changelog_result as $change) |
| 36 | 36 | { |
@@ -26,16 +26,20 @@ discard block |
||
| 26 | 26 | |
| 27 | 27 | public function activate() |
| 28 | 28 | { |
| 29 | - if(!Request::hasPost()) |
|
| 30 | - return false; |
|
| 31 | - if(!Request::getPost('submit') == 'Submit Comment') |
|
| 32 | - return false; |
|
| 29 | + if(!Request::hasPost()) {
|
|
| 30 | + return false; |
|
| 31 | + } |
|
| 32 | + if(!Request::getPost('submit') == 'Submit Comment') {
|
|
| 33 | + return false; |
|
| 34 | + } |
|
| 33 | 35 | |
| 34 | 36 | $errors = $this->fetch_errors(); |
| 35 | - if(count($errors) > 0) |
|
| 36 | - return $errors; |
|
| 37 | - if(Request::getPost('catch') !== '') |
|
| 38 | - return false; |
|
| 37 | + if(count($errors) > 0) {
|
|
| 38 | + return $errors; |
|
| 39 | + } |
|
| 40 | + if(Request::getPost('catch') !== '') {
|
|
| 41 | + return false; |
|
| 42 | + } |
|
| 39 | 43 | |
| 40 | 44 | $page_id = $this->save_comment_page(); |
| 41 | 45 | $commenter_id = $this->save_commenter(); |
@@ -50,18 +54,24 @@ discard block |
||
| 50 | 54 | private function fetch_errors() |
| 51 | 55 | { |
| 52 | 56 | $errors = array(); |
| 53 | - if(!Validate::checkRequest('post', 'name', 'name')) |
|
| 54 | - $errors['name'] = 'You must include a valid name'; |
|
| 55 | - if(!Validate::checkRequest('post', 'email', 'email')) |
|
| 56 | - $errors['email'] = 'You must include a valid email'; |
|
| 57 | - if(Request::getPost('website') && !Validate::checkRequest('post', 'website', 'url')) |
|
| 58 | - $errors['website'] = 'Please enter a valid website'; |
|
| 59 | - if(!Validate::checkRequest('post', 'comment', 'string')) |
|
| 60 | - $errors['comment'] = 'You must enter a comment'; |
|
| 61 | - if(Request::getPost('notify') && Request::getPost('notify') != 'check') |
|
| 62 | - $errors['notify'] = 'You entered an invalid notify request'; |
|
| 63 | - if(Request::getPost('reply') && !Validate::checkRequest('post', 'reply', 'integer')) |
|
| 64 | - $errors['reply'] = 'You entered an invalid reply request'; |
|
| 57 | + if(!Validate::checkRequest('post', 'name', 'name')) {
|
|
| 58 | + $errors['name'] = 'You must include a valid name'; |
|
| 59 | + } |
|
| 60 | + if(!Validate::checkRequest('post', 'email', 'email')) {
|
|
| 61 | + $errors['email'] = 'You must include a valid email'; |
|
| 62 | + } |
|
| 63 | + if(Request::getPost('website') && !Validate::checkRequest('post', 'website', 'url')) {
|
|
| 64 | + $errors['website'] = 'Please enter a valid website'; |
|
| 65 | + } |
|
| 66 | + if(!Validate::checkRequest('post', 'comment', 'string')) {
|
|
| 67 | + $errors['comment'] = 'You must enter a comment'; |
|
| 68 | + } |
|
| 69 | + if(Request::getPost('notify') && Request::getPost('notify') != 'check') {
|
|
| 70 | + $errors['notify'] = 'You entered an invalid notify request'; |
|
| 71 | + } |
|
| 72 | + if(Request::getPost('reply') && !Validate::checkRequest('post', 'reply', 'integer')) {
|
|
| 73 | + $errors['reply'] = 'You entered an invalid reply request'; |
|
| 74 | + } |
|
| 65 | 75 | |
| 66 | 76 | return $errors; |
| 67 | 77 | } |
@@ -69,8 +79,9 @@ discard block |
||
| 69 | 79 | private function save_comment_page() |
| 70 | 80 | { |
| 71 | 81 | $page_result = CommentCollector::getCommentPageByURL($this->path, $this->site); |
| 72 | - if($page_result !== null) |
|
| 73 | - return $page_result->id; |
|
| 82 | + if($page_result !== null) {
|
|
| 83 | + return $page_result->id; |
|
| 84 | + } |
|
| 74 | 85 | |
| 75 | 86 | $query = "INSERT INTO `jpemeric_comment`.`comment_page` (`site`, `path`) VALUES ('%d', '%s')"; |
| 76 | 87 | $query = sprintf($query, $this->site, $this->path); |
@@ -85,8 +96,9 @@ discard block |
||
| 85 | 96 | 'name' => Request::getPost('name'), |
| 86 | 97 | 'email' => Request::getPost('email')); |
| 87 | 98 | |
| 88 | - if(Request::getPost('website') != '') |
|
| 89 | - $cookie_value['website'] = Request::getPost('website'); |
|
| 99 | + if(Request::getPost('website') != '') {
|
|
| 100 | + $cookie_value['website'] = Request::getPost('website');
|
|
| 101 | + } |
|
| 90 | 102 | |
| 91 | 103 | $cookie_value = json_encode($cookie_value); |
| 92 | 104 | |
@@ -95,8 +107,9 @@ discard block |
||
| 95 | 107 | ->save(); |
| 96 | 108 | |
| 97 | 109 | $commenter_result = CommentCollector::getCommenterByFields(Request::getPost('name'), Request::getPost('email'), Request::getPost('website')); |
| 98 | - if($commenter_result !== null) |
|
| 99 | - return $commenter_result->id; |
|
| 110 | + if($commenter_result !== null) {
|
|
| 111 | + return $commenter_result->id; |
|
| 112 | + } |
|
| 100 | 113 | |
| 101 | 114 | $query = "INSERT INTO `jpemeric_comment`.`commenter` (`name`,`email`,`url`) VALUES ('%s','%s','%s')"; |
| 102 | 115 | |
@@ -112,8 +125,9 @@ discard block |
||
| 112 | 125 | private function save_comment() |
| 113 | 126 | { |
| 114 | 127 | $comment_result = CommentCollector::getCommentByBody(Request::getPost('comment')); |
| 115 | - if($comment_result !== null) |
|
| 116 | - return $comment_result->id; |
|
| 128 | + if($comment_result !== null) {
|
|
| 129 | + return $comment_result->id; |
|
| 130 | + } |
|
| 117 | 131 | |
| 118 | 132 | $query = "INSERT INTO `jpemeric_comment`.`comment` (`body`, `body_format`) VALUES ('%s', '%s')"; |
| 119 | 133 | |
@@ -133,8 +147,9 @@ discard block |
||
| 133 | 147 | $query = "INSERT INTO `jpemeric_comment`.`comment_meta` (`commenter`,`comment`,`reply`,`notify`,`comment_page`,`date`,`display`) VALUES ('%d','%d','%d','%d','%d','%s','%d')"; |
| 134 | 148 | |
| 135 | 149 | $reply = Database::escape(Request::getPost('type')); |
| 136 | - if($reply == 'new') |
|
| 137 | - $reply = 0; |
|
| 150 | + if($reply == 'new') {
|
|
| 151 | + $reply = 0; |
|
| 152 | + } |
|
| 138 | 153 | // else check to make sure value is legit |
| 139 | 154 | |
| 140 | 155 | $notify = (Request::getPost('notify') == 'check') ? 1 : 0; |
@@ -163,8 +178,9 @@ discard block |
||
| 163 | 178 | |
| 164 | 179 | foreach($notification_result as $notification_row) |
| 165 | 180 | { |
| 166 | - if($notification_row->email == Request::getPost('email')) |
|
| 167 | - continue; |
|
| 181 | + if($notification_row->email == Request::getPost('email')) {
|
|
| 182 | + continue; |
|
| 183 | + } |
|
| 168 | 184 | |
| 169 | 185 | $email_recipient_array[$notification_row->email] = array( |
| 170 | 186 | 'email' => $notification_row->email, |
@@ -26,15 +26,15 @@ discard block |
||
| 26 | 26 | |
| 27 | 27 | public function activate() |
| 28 | 28 | { |
| 29 | - if(!Request::hasPost()) |
|
| 29 | + if (!Request::hasPost()) |
|
| 30 | 30 | return false; |
| 31 | - if(!Request::getPost('submit') == 'Submit Comment') |
|
| 31 | + if (!Request::getPost('submit') == 'Submit Comment') |
|
| 32 | 32 | return false; |
| 33 | 33 | |
| 34 | 34 | $errors = $this->fetch_errors(); |
| 35 | - if(count($errors) > 0) |
|
| 35 | + if (count($errors) > 0) |
|
| 36 | 36 | return $errors; |
| 37 | - if(Request::getPost('catch') !== '') |
|
| 37 | + if (Request::getPost('catch') !== '') |
|
| 38 | 38 | return false; |
| 39 | 39 | |
| 40 | 40 | $page_id = $this->save_comment_page(); |
@@ -50,17 +50,17 @@ discard block |
||
| 50 | 50 | private function fetch_errors() |
| 51 | 51 | { |
| 52 | 52 | $errors = array(); |
| 53 | - if(!Validate::checkRequest('post', 'name', 'name')) |
|
| 53 | + if (!Validate::checkRequest('post', 'name', 'name')) |
|
| 54 | 54 | $errors['name'] = 'You must include a valid name'; |
| 55 | - if(!Validate::checkRequest('post', 'email', 'email')) |
|
| 55 | + if (!Validate::checkRequest('post', 'email', 'email')) |
|
| 56 | 56 | $errors['email'] = 'You must include a valid email'; |
| 57 | - if(Request::getPost('website') && !Validate::checkRequest('post', 'website', 'url')) |
|
| 57 | + if (Request::getPost('website') && !Validate::checkRequest('post', 'website', 'url')) |
|
| 58 | 58 | $errors['website'] = 'Please enter a valid website'; |
| 59 | - if(!Validate::checkRequest('post', 'comment', 'string')) |
|
| 59 | + if (!Validate::checkRequest('post', 'comment', 'string')) |
|
| 60 | 60 | $errors['comment'] = 'You must enter a comment'; |
| 61 | - if(Request::getPost('notify') && Request::getPost('notify') != 'check') |
|
| 61 | + if (Request::getPost('notify') && Request::getPost('notify') != 'check') |
|
| 62 | 62 | $errors['notify'] = 'You entered an invalid notify request'; |
| 63 | - if(Request::getPost('reply') && !Validate::checkRequest('post', 'reply', 'integer')) |
|
| 63 | + if (Request::getPost('reply') && !Validate::checkRequest('post', 'reply', 'integer')) |
|
| 64 | 64 | $errors['reply'] = 'You entered an invalid reply request'; |
| 65 | 65 | |
| 66 | 66 | return $errors; |
@@ -69,7 +69,7 @@ discard block |
||
| 69 | 69 | private function save_comment_page() |
| 70 | 70 | { |
| 71 | 71 | $page_result = CommentCollector::getCommentPageByURL($this->path, $this->site); |
| 72 | - if($page_result !== null) |
|
| 72 | + if ($page_result !== null) |
|
| 73 | 73 | return $page_result->id; |
| 74 | 74 | |
| 75 | 75 | $query = "INSERT INTO `jpemeric_comment`.`comment_page` (`site`, `path`) VALUES ('%d', '%s')"; |
@@ -85,7 +85,7 @@ discard block |
||
| 85 | 85 | 'name' => Request::getPost('name'), |
| 86 | 86 | 'email' => Request::getPost('email')); |
| 87 | 87 | |
| 88 | - if(Request::getPost('website') != '') |
|
| 88 | + if (Request::getPost('website') != '') |
|
| 89 | 89 | $cookie_value['website'] = Request::getPost('website'); |
| 90 | 90 | |
| 91 | 91 | $cookie_value = json_encode($cookie_value); |
@@ -95,7 +95,7 @@ discard block |
||
| 95 | 95 | ->save(); |
| 96 | 96 | |
| 97 | 97 | $commenter_result = CommentCollector::getCommenterByFields(Request::getPost('name'), Request::getPost('email'), Request::getPost('website')); |
| 98 | - if($commenter_result !== null) |
|
| 98 | + if ($commenter_result !== null) |
|
| 99 | 99 | return $commenter_result->id; |
| 100 | 100 | |
| 101 | 101 | $query = "INSERT INTO `jpemeric_comment`.`commenter` (`name`,`email`,`url`) VALUES ('%s','%s','%s')"; |
@@ -112,7 +112,7 @@ discard block |
||
| 112 | 112 | private function save_comment() |
| 113 | 113 | { |
| 114 | 114 | $comment_result = CommentCollector::getCommentByBody(Request::getPost('comment')); |
| 115 | - if($comment_result !== null) |
|
| 115 | + if ($comment_result !== null) |
|
| 116 | 116 | return $comment_result->id; |
| 117 | 117 | |
| 118 | 118 | $query = "INSERT INTO `jpemeric_comment`.`comment` (`body`, `body_format`) VALUES ('%s', '%s')"; |
@@ -133,7 +133,7 @@ discard block |
||
| 133 | 133 | $query = "INSERT INTO `jpemeric_comment`.`comment_meta` (`commenter`,`comment`,`reply`,`notify`,`comment_page`,`date`,`display`) VALUES ('%d','%d','%d','%d','%d','%s','%d')"; |
| 134 | 134 | |
| 135 | 135 | $reply = Database::escape(Request::getPost('type')); |
| 136 | - if($reply == 'new') |
|
| 136 | + if ($reply == 'new') |
|
| 137 | 137 | $reply = 0; |
| 138 | 138 | // else check to make sure value is legit |
| 139 | 139 | |
@@ -152,13 +152,13 @@ discard block |
||
| 152 | 152 | |
| 153 | 153 | $commenter_result = CommentCollector::getCommenterByFields(Request::getPost('name'), Request::getPost('email'), Request::getPost('website')); |
| 154 | 154 | |
| 155 | - if($commenter_result->trusted == 1) |
|
| 155 | + if ($commenter_result->trusted == 1) |
|
| 156 | 156 | { |
| 157 | 157 | $notification_result = CommentCollector::getNotificationForPage($page); |
| 158 | 158 | |
| 159 | - foreach($notification_result as $notification_row) |
|
| 159 | + foreach ($notification_result as $notification_row) |
|
| 160 | 160 | { |
| 161 | - if($notification_row->email == Request::getPost('email')) |
|
| 161 | + if ($notification_row->email == Request::getPost('email')) |
|
| 162 | 162 | continue; |
| 163 | 163 | |
| 164 | 164 | $email_recipient_array[$notification_row->email] = array( |
@@ -171,15 +171,15 @@ discard block |
||
| 171 | 171 | |
| 172 | 172 | if ($site == 'blog') { |
| 173 | 173 | $subject = "New Comment on Jacob Emerick's Blog"; |
| 174 | - $message = "Hello!\nThere has been a new comment on the post '{$this->page_title}' at Jacob Emerick's Blog. You have chosen to be notified of it - please reply to [email protected] if you would like to be removed from these notifications.\n\nOn " . date('F j, Y g:i a') . ", " . Request::getPost('name') . " commented...\n" . Request::getPost('comment') . "\n\nVisit {$this->full_path}#comments to see and reply to all the comments on this post.\nThank you!"; |
|
| 174 | + $message = "Hello!\nThere has been a new comment on the post '{$this->page_title}' at Jacob Emerick's Blog. You have chosen to be notified of it - please reply to [email protected] if you would like to be removed from these notifications.\n\nOn ".date('F j, Y g:i a').", ".Request::getPost('name')." commented...\n".Request::getPost('comment')."\n\nVisit {$this->full_path}#comments to see and reply to all the comments on this post.\nThank you!"; |
|
| 175 | 175 | } else if ($site == 'waterfalls') { |
| 176 | 176 | $subject = "New Comment on Waterfalls of the Keweenaw"; |
| 177 | - $message = "Hello!\nThere has been a new comment on the page '{$this->page_title}' at Waterfalls of the Keweenaw. You have chosen to be notified of it - please reply to [email protected] if you would like to be removed from these notifications.\n\nOn " . date('F j, Y g:i a') . ", " . Request::getPost('name') . " commented...\n" . Request::getPost('comment') . "\n\nVisit {$this->full_path}#comments to see and reply to all the comments on this post.\nThank you!"; |
|
| 177 | + $message = "Hello!\nThere has been a new comment on the page '{$this->page_title}' at Waterfalls of the Keweenaw. You have chosen to be notified of it - please reply to [email protected] if you would like to be removed from these notifications.\n\nOn ".date('F j, Y g:i a').", ".Request::getPost('name')." commented...\n".Request::getPost('comment')."\n\nVisit {$this->full_path}#comments to see and reply to all the comments on this post.\nThank you!"; |
|
| 178 | 178 | } |
| 179 | 179 | |
| 180 | 180 | global $container; |
| 181 | 181 | |
| 182 | - foreach($email_recipient_array as $email_recipient) |
|
| 182 | + foreach ($email_recipient_array as $email_recipient) |
|
| 183 | 183 | { |
| 184 | 184 | $sent = $container['mail'] |
| 185 | 185 | ->addTo($email_recipient['email'], $email_recipient['name']) |
@@ -41,7 +41,7 @@ discard block |
||
| 41 | 41 | $comment_id = $this->save_comment(); |
| 42 | 42 | |
| 43 | 43 | $comment_meta_id = $this->save_comment_meta($commenter_id, $comment_id, $page_id); |
| 44 | - $comment_service_id = $this->save_to_comment_service(Request::getPost()); |
|
| 44 | + $comment_service_id = $this->save_to_comment_service(Request::getPost()); |
|
| 45 | 45 | |
| 46 | 46 | $this->send_notifications($page_id); |
| 47 | 47 | $this->redirect_to_comment($comment_meta_id); |
@@ -88,7 +88,7 @@ discard block |
||
| 88 | 88 | if(Request::getPost('website') != '') |
| 89 | 89 | $cookie_value['website'] = Request::getPost('website'); |
| 90 | 90 | |
| 91 | - setcookie('commenter', json_encode($cookie_value), time() + 31536000, '/', 'jacobemerick.com'); |
|
| 91 | + setcookie('commenter', json_encode($cookie_value), time() + 31536000, '/', 'jacobemerick.com'); |
|
| 92 | 92 | |
| 93 | 93 | $commenter_result = CommentCollector::getCommenterByFields(Request::getPost('name'), Request::getPost('email'), Request::getPost('website')); |
| 94 | 94 | if($commenter_result !== null) |
@@ -163,26 +163,26 @@ discard block |
||
| 163 | 163 | } |
| 164 | 164 | } |
| 165 | 165 | |
| 166 | - $site = URLDecode::getSite(); |
|
| 166 | + $site = URLDecode::getSite(); |
|
| 167 | 167 | |
| 168 | - if ($site == 'blog') { |
|
| 169 | - $subject = "New Comment on Jacob Emerick's Blog"; |
|
| 170 | - $message = "Hello!\nThere has been a new comment on the post '{$this->page_title}' at Jacob Emerick's Blog. You have chosen to be notified of it - please reply to [email protected] if you would like to be removed from these notifications.\n\nOn " . date('F j, Y g:i a') . ", " . Request::getPost('name') . " commented...\n" . Request::getPost('comment') . "\n\nVisit {$this->full_path}#comments to see and reply to all the comments on this post.\nThank you!"; |
|
| 171 | - } else if ($site == 'waterfalls') { |
|
| 172 | - $subject = "New Comment on Waterfalls of the Keweenaw"; |
|
| 173 | - $message = "Hello!\nThere has been a new comment on the page '{$this->page_title}' at Waterfalls of the Keweenaw. You have chosen to be notified of it - please reply to [email protected] if you would like to be removed from these notifications.\n\nOn " . date('F j, Y g:i a') . ", " . Request::getPost('name') . " commented...\n" . Request::getPost('comment') . "\n\nVisit {$this->full_path}#comments to see and reply to all the comments on this post.\nThank you!"; |
|
| 174 | - } |
|
| 168 | + if ($site == 'blog') { |
|
| 169 | + $subject = "New Comment on Jacob Emerick's Blog"; |
|
| 170 | + $message = "Hello!\nThere has been a new comment on the post '{$this->page_title}' at Jacob Emerick's Blog. You have chosen to be notified of it - please reply to [email protected] if you would like to be removed from these notifications.\n\nOn " . date('F j, Y g:i a') . ", " . Request::getPost('name') . " commented...\n" . Request::getPost('comment') . "\n\nVisit {$this->full_path}#comments to see and reply to all the comments on this post.\nThank you!"; |
|
| 171 | + } else if ($site == 'waterfalls') { |
|
| 172 | + $subject = "New Comment on Waterfalls of the Keweenaw"; |
|
| 173 | + $message = "Hello!\nThere has been a new comment on the page '{$this->page_title}' at Waterfalls of the Keweenaw. You have chosen to be notified of it - please reply to [email protected] if you would like to be removed from these notifications.\n\nOn " . date('F j, Y g:i a') . ", " . Request::getPost('name') . " commented...\n" . Request::getPost('comment') . "\n\nVisit {$this->full_path}#comments to see and reply to all the comments on this post.\nThank you!"; |
|
| 174 | + } |
|
| 175 | 175 | |
| 176 | - global $container; |
|
| 176 | + global $container; |
|
| 177 | 177 | |
| 178 | 178 | foreach($email_recipient_array as $email_recipient) |
| 179 | 179 | { |
| 180 | - $sent = $container['mail'] |
|
| 181 | - ->addTo($email_recipient['email'], $email_recipient['name']) |
|
| 182 | - ->addBCC($container['config']->admin_email) |
|
| 183 | - ->setSubject($subject) |
|
| 184 | - ->setPlainMessage($message) |
|
| 185 | - ->send(); |
|
| 180 | + $sent = $container['mail'] |
|
| 181 | + ->addTo($email_recipient['email'], $email_recipient['name']) |
|
| 182 | + ->addBCC($container['config']->admin_email) |
|
| 183 | + ->setSubject($subject) |
|
| 184 | + ->setPlainMessage($message) |
|
| 185 | + ->send(); |
|
| 186 | 186 | } |
| 187 | 187 | } |
| 188 | 188 | |
@@ -196,41 +196,41 @@ discard block |
||
| 196 | 196 | exit; |
| 197 | 197 | } |
| 198 | 198 | |
| 199 | - private function save_to_comment_service(array $data) |
|
| 200 | - { |
|
| 201 | - $path = $_SERVER['REQUEST_URI']; |
|
| 202 | - $path = explode('/', $path); |
|
| 203 | - $path = array_filter($path); |
|
| 204 | - $path = array_slice($path, 0, 2); |
|
| 205 | - $path = implode('/', $path); |
|
| 206 | - |
|
| 207 | - $body = [ |
|
| 208 | - 'commenter' => [ |
|
| 209 | - 'name' => $data['name'], |
|
| 210 | - 'email' => $data['email'], |
|
| 211 | - 'website' => $data['website'], |
|
| 212 | - ], |
|
| 213 | - 'body' => $data['comment'], |
|
| 214 | - 'should_notify' => (isset($data['notify']) && $data['notify'] == 'check'), |
|
| 215 | - 'domain' => (URLDecode::getSite() == 'blog' ? 'blog.jacobemerick.com' : 'waterfallsofthekeweenaw.com'), |
|
| 216 | - 'path' => $path, |
|
| 217 | - 'url' => $this->full_path, |
|
| 218 | - 'thread' => 'comments', |
|
| 219 | - 'ip_address' => $_SERVER['REMOTE_ADDR'], |
|
| 220 | - 'user_agent' => $_SERVER['HTTP_USER_AGENT'], |
|
| 221 | - 'referrer' => $_SERVER['HTTP_REFERER'], |
|
| 222 | - ]; |
|
| 223 | - |
|
| 224 | - global $config; |
|
| 225 | - $configuration = new Jacobemerick\CommentService\Configuration(); |
|
| 226 | - $configuration->setUsername($config->comments->user); |
|
| 227 | - $configuration->setPassword($config->comments->password); |
|
| 228 | - $configuration->addDefaultHeader('Content-Type', 'application/json'); |
|
| 229 | - $configuration->setHost($config->comments->host); |
|
| 230 | - $configuration->setCurlTimeout($config->comments->timeout); |
|
| 231 | - |
|
| 232 | - $client = new Jacobemerick\CommentService\ApiClient($configuration); |
|
| 233 | - $api = new Jacobemerick\CommentService\Api\DefaultApi($client); |
|
| 234 | - $response = $api->createComment($body); |
|
| 235 | - } |
|
| 199 | + private function save_to_comment_service(array $data) |
|
| 200 | + { |
|
| 201 | + $path = $_SERVER['REQUEST_URI']; |
|
| 202 | + $path = explode('/', $path); |
|
| 203 | + $path = array_filter($path); |
|
| 204 | + $path = array_slice($path, 0, 2); |
|
| 205 | + $path = implode('/', $path); |
|
| 206 | + |
|
| 207 | + $body = [ |
|
| 208 | + 'commenter' => [ |
|
| 209 | + 'name' => $data['name'], |
|
| 210 | + 'email' => $data['email'], |
|
| 211 | + 'website' => $data['website'], |
|
| 212 | + ], |
|
| 213 | + 'body' => $data['comment'], |
|
| 214 | + 'should_notify' => (isset($data['notify']) && $data['notify'] == 'check'), |
|
| 215 | + 'domain' => (URLDecode::getSite() == 'blog' ? 'blog.jacobemerick.com' : 'waterfallsofthekeweenaw.com'), |
|
| 216 | + 'path' => $path, |
|
| 217 | + 'url' => $this->full_path, |
|
| 218 | + 'thread' => 'comments', |
|
| 219 | + 'ip_address' => $_SERVER['REMOTE_ADDR'], |
|
| 220 | + 'user_agent' => $_SERVER['HTTP_USER_AGENT'], |
|
| 221 | + 'referrer' => $_SERVER['HTTP_REFERER'], |
|
| 222 | + ]; |
|
| 223 | + |
|
| 224 | + global $config; |
|
| 225 | + $configuration = new Jacobemerick\CommentService\Configuration(); |
|
| 226 | + $configuration->setUsername($config->comments->user); |
|
| 227 | + $configuration->setPassword($config->comments->password); |
|
| 228 | + $configuration->addDefaultHeader('Content-Type', 'application/json'); |
|
| 229 | + $configuration->setHost($config->comments->host); |
|
| 230 | + $configuration->setCurlTimeout($config->comments->timeout); |
|
| 231 | + |
|
| 232 | + $client = new Jacobemerick\CommentService\ApiClient($configuration); |
|
| 233 | + $api = new Jacobemerick\CommentService\Api\DefaultApi($client); |
|
| 234 | + $response = $api->createComment($body); |
|
| 235 | + } |
|
| 236 | 236 | } |
@@ -16,17 +16,17 @@ discard block |
||
| 16 | 16 | |
| 17 | 17 | private function __construct($write_params, $read_params) |
| 18 | 18 | { |
| 19 | - $this->write_connection = $this->connect( |
|
| 20 | - $write_params->host, |
|
| 21 | - $write_params->user, |
|
| 22 | - $write_params->password |
|
| 23 | - ); |
|
| 24 | - |
|
| 25 | - $this->read_connection = $this->connect( |
|
| 26 | - $read_params->host, |
|
| 27 | - $read_params->user, |
|
| 28 | - $read_params->password |
|
| 29 | - ); |
|
| 19 | + $this->write_connection = $this->connect( |
|
| 20 | + $write_params->host, |
|
| 21 | + $write_params->user, |
|
| 22 | + $write_params->password |
|
| 23 | + ); |
|
| 24 | + |
|
| 25 | + $this->read_connection = $this->connect( |
|
| 26 | + $read_params->host, |
|
| 27 | + $read_params->user, |
|
| 28 | + $read_params->password |
|
| 29 | + ); |
|
| 30 | 30 | |
| 31 | 31 | return $this; |
| 32 | 32 | } |
@@ -45,12 +45,12 @@ discard block |
||
| 45 | 45 | public static function instance() |
| 46 | 46 | { |
| 47 | 47 | if(!isset(self::$instance)) { |
| 48 | - global $config; |
|
| 49 | - self::$instance = new Database( |
|
| 50 | - $config->database->master, |
|
| 51 | - $config->database->slave |
|
| 52 | - ); |
|
| 53 | - } |
|
| 48 | + global $config; |
|
| 49 | + self::$instance = new Database( |
|
| 50 | + $config->database->master, |
|
| 51 | + $config->database->slave |
|
| 52 | + ); |
|
| 53 | + } |
|
| 54 | 54 | |
| 55 | 55 | return self::$instance; |
| 56 | 56 | } |
@@ -36,8 +36,9 @@ discard block |
||
| 36 | 36 | $mysqli = new mysqli($host, $username, $password); |
| 37 | 37 | |
| 38 | 38 | $has_connection_error = $mysqli->connect_error; |
| 39 | - if(isset($has_connection_error)) |
|
| 40 | - $this->has_connection_error = true; |
|
| 39 | + if(isset($has_connection_error)) {
|
|
| 40 | + $this->has_connection_error = true; |
|
| 41 | + } |
|
| 41 | 42 | |
| 42 | 43 | return $mysqli; |
| 43 | 44 | } |
@@ -67,8 +68,9 @@ discard block |
||
| 67 | 68 | { |
| 68 | 69 | self::instance()->log_query($query, $start); |
| 69 | 70 | $array = array(); |
| 70 | - while($row = $result->fetch_object()) |
|
| 71 | - $array[] = $row; |
|
| 71 | + while($row = $result->fetch_object()) {
|
|
| 72 | + $array[] = $row; |
|
| 73 | + } |
|
| 72 | 74 | $result->close(); |
| 73 | 75 | return $array; |
| 74 | 76 | } |
@@ -79,8 +81,9 @@ discard block |
||
| 79 | 81 | public static function selectRow($query) |
| 80 | 82 | { |
| 81 | 83 | $result = self::select($query); |
| 82 | - if(is_array($result)) |
|
| 83 | - return array_pop($result); |
|
| 84 | + if(is_array($result)) {
|
|
| 85 | + return array_pop($result); |
|
| 86 | + } |
|
| 84 | 87 | return false; |
| 85 | 88 | } |
| 86 | 89 | |
@@ -99,8 +102,9 @@ discard block |
||
| 99 | 102 | public static function lastInsertID() |
| 100 | 103 | { |
| 101 | 104 | $id = self::instance()->write_connection->insert_id; |
| 102 | - if($id == 0) |
|
| 103 | - return false; |
|
| 105 | + if($id == 0) {
|
|
| 106 | + return false; |
|
| 107 | + } |
|
| 104 | 108 | return $id; |
| 105 | 109 | } |
| 106 | 110 | |
@@ -84,6 +84,9 @@ |
||
| 84 | 84 | return false; |
| 85 | 85 | } |
| 86 | 86 | |
| 87 | + /** |
|
| 88 | + * @param string $query |
|
| 89 | + */ |
|
| 87 | 90 | public static function execute($query) |
| 88 | 91 | { |
| 89 | 92 | $start = microtime(true); |
@@ -36,7 +36,7 @@ discard block |
||
| 36 | 36 | $mysqli = new mysqli($host, $username, $password); |
| 37 | 37 | |
| 38 | 38 | $has_connection_error = $mysqli->connect_error; |
| 39 | - if(isset($has_connection_error)) |
|
| 39 | + if (isset($has_connection_error)) |
|
| 40 | 40 | $this->has_connection_error = true; |
| 41 | 41 | |
| 42 | 42 | return $mysqli; |
@@ -44,7 +44,7 @@ discard block |
||
| 44 | 44 | |
| 45 | 45 | public static function instance() |
| 46 | 46 | { |
| 47 | - if(!isset(self::$instance)) { |
|
| 47 | + if (!isset(self::$instance)) { |
|
| 48 | 48 | global $config; |
| 49 | 49 | self::$instance = new Database( |
| 50 | 50 | $config->database->master, |
@@ -63,23 +63,23 @@ discard block |
||
| 63 | 63 | public static function select($query) |
| 64 | 64 | { |
| 65 | 65 | $start = microtime(true); |
| 66 | - if($result = self::instance()->read_connection->query($query)) |
|
| 66 | + if ($result = self::instance()->read_connection->query($query)) |
|
| 67 | 67 | { |
| 68 | 68 | self::instance()->log_query($query, $start); |
| 69 | 69 | $array = array(); |
| 70 | - while($row = $result->fetch_object()) |
|
| 70 | + while ($row = $result->fetch_object()) |
|
| 71 | 71 | $array[] = $row; |
| 72 | 72 | $result->close(); |
| 73 | 73 | return $array; |
| 74 | 74 | } |
| 75 | - trigger_error('Could not preform query - ' . $query . ' - ' . self::instance()->read_connection->error); |
|
| 75 | + trigger_error('Could not preform query - '.$query.' - '.self::instance()->read_connection->error); |
|
| 76 | 76 | return false; |
| 77 | 77 | } |
| 78 | 78 | |
| 79 | 79 | public static function selectRow($query) |
| 80 | 80 | { |
| 81 | 81 | $result = self::select($query); |
| 82 | - if(is_array($result)) |
|
| 82 | + if (is_array($result)) |
|
| 83 | 83 | return array_pop($result); |
| 84 | 84 | return false; |
| 85 | 85 | } |
@@ -87,19 +87,19 @@ discard block |
||
| 87 | 87 | public static function execute($query) |
| 88 | 88 | { |
| 89 | 89 | $start = microtime(true); |
| 90 | - if(self::instance()->write_connection->query($query)) |
|
| 90 | + if (self::instance()->write_connection->query($query)) |
|
| 91 | 91 | { |
| 92 | 92 | self::instance()->log_query($query, $start); |
| 93 | 93 | return true; |
| 94 | 94 | } |
| 95 | - trigger_error('Could not preform query - ' . $query . '-' . self::instance()->write_connection->error); |
|
| 95 | + trigger_error('Could not preform query - '.$query.'-'.self::instance()->write_connection->error); |
|
| 96 | 96 | return false; |
| 97 | 97 | } |
| 98 | 98 | |
| 99 | 99 | public static function lastInsertID() |
| 100 | 100 | { |
| 101 | 101 | $id = self::instance()->write_connection->insert_id; |
| 102 | - if($id == 0) |
|
| 102 | + if ($id == 0) |
|
| 103 | 103 | return false; |
| 104 | 104 | return $id; |
| 105 | 105 | } |
@@ -119,7 +119,7 @@ discard block |
||
| 119 | 119 | private function gather_query_data() |
| 120 | 120 | { |
| 121 | 121 | $query_data = array(); |
| 122 | - foreach($this->query_log as $query) |
|
| 122 | + foreach ($this->query_log as $query) |
|
| 123 | 123 | { |
| 124 | 124 | $query = self::explain($query); |
| 125 | 125 | $query_data[] = $query; |
@@ -129,9 +129,9 @@ discard block |
||
| 129 | 129 | |
| 130 | 130 | public static function explain($query) |
| 131 | 131 | { |
| 132 | - $sql = 'EXPLAIN ' . $query['sql']; |
|
| 132 | + $sql = 'EXPLAIN '.$query['sql']; |
|
| 133 | 133 | |
| 134 | - if($result = self::instance()->read_connection->query($sql)) |
|
| 134 | + if ($result = self::instance()->read_connection->query($sql)) |
|
| 135 | 135 | { |
| 136 | 136 | $row = $result->fetch_assoc(); |
| 137 | 137 | $query['explain'] = $row; |
@@ -5,56 +5,56 @@ |
||
| 5 | 5 | final class ImperialUnitContent extends Content |
| 6 | 6 | { |
| 7 | 7 | |
| 8 | - protected function execute($type = '') |
|
| 9 | - { |
|
| 10 | - $number = floatval($this->content); |
|
| 11 | - $number *= 39.37; // convert to inches |
|
| 8 | + protected function execute($type = '') |
|
| 9 | + { |
|
| 10 | + $number = floatval($this->content); |
|
| 11 | + $number *= 39.37; // convert to inches |
|
| 12 | 12 | |
| 13 | - if ($type == '') { |
|
| 14 | - if ($number > (12 * 3 * 1760 * 5)) { |
|
| 15 | - $type = 'full miles'; |
|
| 16 | - } else if ($number > (12 * 3 * 1760 * .5)) { |
|
| 17 | - $type = 'tenth miles'; |
|
| 18 | - } else if ($number > (12 * 3 * 150)) { |
|
| 19 | - $type = 'yards'; |
|
| 20 | - } else if ($number > (12 * 10)) { |
|
| 21 | - $type = 'feet'; |
|
| 22 | - } else { |
|
| 23 | - $type = 'inches'; |
|
| 24 | - } |
|
| 25 | - } |
|
| 13 | + if ($type == '') { |
|
| 14 | + if ($number > (12 * 3 * 1760 * 5)) { |
|
| 15 | + $type = 'full miles'; |
|
| 16 | + } else if ($number > (12 * 3 * 1760 * .5)) { |
|
| 17 | + $type = 'tenth miles'; |
|
| 18 | + } else if ($number > (12 * 3 * 150)) { |
|
| 19 | + $type = 'yards'; |
|
| 20 | + } else if ($number > (12 * 10)) { |
|
| 21 | + $type = 'feet'; |
|
| 22 | + } else { |
|
| 23 | + $type = 'inches'; |
|
| 24 | + } |
|
| 25 | + } |
|
| 26 | 26 | |
| 27 | - switch ($type) { |
|
| 28 | - case 'full miles' : |
|
| 29 | - $this->content = number_format(round($number / (12 * 3 * 1760))) . ' miles'; |
|
| 30 | - break; |
|
| 31 | - case 'tenth miles' : |
|
| 32 | - $this->content = round($number / (12 * 3 * 1760), 1) . ' miles'; |
|
| 33 | - break; |
|
| 34 | - case 'yards' : |
|
| 35 | - $this->content = number_format(round($number / (12 * 3))) . ' yards'; |
|
| 36 | - break; |
|
| 37 | - case 'feet' : |
|
| 38 | - $this->content = number_format(round($number / 12)) . "'"; |
|
| 39 | - break; |
|
| 40 | - case 'inches' : |
|
| 41 | - $feet = floor($number / 12); |
|
| 27 | + switch ($type) { |
|
| 28 | + case 'full miles' : |
|
| 29 | + $this->content = number_format(round($number / (12 * 3 * 1760))) . ' miles'; |
|
| 30 | + break; |
|
| 31 | + case 'tenth miles' : |
|
| 32 | + $this->content = round($number / (12 * 3 * 1760), 1) . ' miles'; |
|
| 33 | + break; |
|
| 34 | + case 'yards' : |
|
| 35 | + $this->content = number_format(round($number / (12 * 3))) . ' yards'; |
|
| 36 | + break; |
|
| 37 | + case 'feet' : |
|
| 38 | + $this->content = number_format(round($number / 12)) . "'"; |
|
| 39 | + break; |
|
| 40 | + case 'inches' : |
|
| 41 | + $feet = floor($number / 12); |
|
| 42 | 42 | |
| 43 | - $inches = $number - $feet * 12; |
|
| 44 | - $inches = round($inches); |
|
| 43 | + $inches = $number - $feet * 12; |
|
| 44 | + $inches = round($inches); |
|
| 45 | 45 | |
| 46 | - if ($inches == 12) { |
|
| 47 | - $feet++; |
|
| 48 | - $inches = 0; |
|
| 49 | - } |
|
| 46 | + if ($inches == 12) { |
|
| 47 | + $feet++; |
|
| 48 | + $inches = 0; |
|
| 49 | + } |
|
| 50 | 50 | |
| 51 | - $this->content = ''; |
|
| 52 | - $this->content .= number_format($feet) . "'"; |
|
| 53 | - if (isset($inches) && $inches > 0) { |
|
| 54 | - $this->content .= " {$inches}\""; |
|
| 55 | - } |
|
| 56 | - break; |
|
| 57 | - } |
|
| 58 | - } |
|
| 51 | + $this->content = ''; |
|
| 52 | + $this->content .= number_format($feet) . "'"; |
|
| 53 | + if (isset($inches) && $inches > 0) { |
|
| 54 | + $this->content .= " {$inches}\""; |
|
| 55 | + } |
|
| 56 | + break; |
|
| 57 | + } |
|
| 58 | + } |
|
| 59 | 59 | |
| 60 | 60 | } |
| 61 | 61 | \ No newline at end of file |
@@ -26,16 +26,16 @@ discard block |
||
| 26 | 26 | |
| 27 | 27 | switch ($type) { |
| 28 | 28 | case 'full miles' : |
| 29 | - $this->content = number_format(round($number / (12 * 3 * 1760))) . ' miles'; |
|
| 29 | + $this->content = number_format(round($number / (12 * 3 * 1760))).' miles'; |
|
| 30 | 30 | break; |
| 31 | 31 | case 'tenth miles' : |
| 32 | - $this->content = round($number / (12 * 3 * 1760), 1) . ' miles'; |
|
| 32 | + $this->content = round($number / (12 * 3 * 1760), 1).' miles'; |
|
| 33 | 33 | break; |
| 34 | 34 | case 'yards' : |
| 35 | - $this->content = number_format(round($number / (12 * 3))) . ' yards'; |
|
| 35 | + $this->content = number_format(round($number / (12 * 3))).' yards'; |
|
| 36 | 36 | break; |
| 37 | 37 | case 'feet' : |
| 38 | - $this->content = number_format(round($number / 12)) . "'"; |
|
| 38 | + $this->content = number_format(round($number / 12))."'"; |
|
| 39 | 39 | break; |
| 40 | 40 | case 'inches' : |
| 41 | 41 | $feet = floor($number / 12); |
@@ -49,7 +49,7 @@ discard block |
||
| 49 | 49 | } |
| 50 | 50 | |
| 51 | 51 | $this->content = ''; |
| 52 | - $this->content .= number_format($feet) . "'"; |
|
| 52 | + $this->content .= number_format($feet)."'"; |
|
| 53 | 53 | if (isset($inches) && $inches > 0) { |
| 54 | 54 | $this->content .= " {$inches}\""; |
| 55 | 55 | } |
@@ -12,7 +12,7 @@ discard block |
||
| 12 | 12 | protected function execute($is_absolute = false, $size = 'medium') |
| 13 | 13 | { |
| 14 | 14 | preg_match_all(self::$PHOTO_PLACEHOLDER_MATCH, $this->content, $matches); |
| 15 | - foreach($matches[1] as $key => $match) |
|
| 15 | + foreach ($matches[1] as $key => $match) |
|
| 16 | 16 | { |
| 17 | 17 | $photo_content = $this->get_photo_content($match, $size, $is_absolute); |
| 18 | 18 | $this->content = str_replace($matches[0][$key], $photo_content, $this->content); |
@@ -37,7 +37,7 @@ discard block |
||
| 37 | 37 | |
| 38 | 38 | Loader::load('collector', 'image/PhotoCollector'); |
| 39 | 39 | $photo_result = PhotoCollector::fetchRow($category, $photo); |
| 40 | - if($photo_result == false) |
|
| 40 | + if ($photo_result == false) |
|
| 41 | 41 | return ''; |
| 42 | 42 | |
| 43 | 43 | $height = $file_size[1]; |
@@ -49,7 +49,7 @@ discard block |
||
| 49 | 49 | } |
| 50 | 50 | |
| 51 | 51 | $domain = '/'; |
| 52 | - if($is_absolute) |
|
| 52 | + if ($is_absolute) |
|
| 53 | 53 | $domain = Loader::getRootUrl('blog'); |
| 54 | 54 | |
| 55 | 55 | return sprintf(self::$PHOTO_CONTENT, $domain, $category, $photo, $size, $height, $width, $description, $description); |
@@ -37,8 +37,9 @@ discard block |
||
| 37 | 37 | |
| 38 | 38 | Loader::load('collector', 'image/PhotoCollector'); |
| 39 | 39 | $photo_result = PhotoCollector::fetchRow($category, $photo); |
| 40 | - if($photo_result == false) |
|
| 41 | - return ''; |
|
| 40 | + if($photo_result == false) {
|
|
| 41 | + return ''; |
|
| 42 | + } |
|
| 42 | 43 | |
| 43 | 44 | $height = $file_size[1]; |
| 44 | 45 | $width = $file_size[0]; |
@@ -49,8 +50,9 @@ discard block |
||
| 49 | 50 | } |
| 50 | 51 | |
| 51 | 52 | $domain = '/'; |
| 52 | - if($is_absolute) |
|
| 53 | - $domain = Loader::getRootUrl('blog'); |
|
| 53 | + if($is_absolute) {
|
|
| 54 | + $domain = Loader::getRootUrl('blog');
|
|
| 55 | + } |
|
| 54 | 56 | |
| 55 | 57 | return sprintf(self::$PHOTO_CONTENT, $domain, $category, $photo, $size, $height, $width, $description, $description); |
| 56 | 58 | } |