Completed
Push — master ( cd6ca3...800f7e )
by Florin
02:35
created
tests/controller/main_test.php 2 patches
Unused Use Statements   -2 removed lines patch added patch discarded remove patch
@@ -2,8 +2,6 @@
 block discarded – undo
2 2
 
3 3
 namespace florinp\messenger\tests\controller;
4 4
 
5
-use Symfony\Component\HttpFoundation\JsonResponse;
6
-
7 5
 class main_test extends \phpbb_test_case {
8 6
 
9 7
     /**
Please login to merge, or discard this patch.
Indentation   +110 added lines, -110 removed lines patch added patch discarded remove patch
@@ -6,114 +6,114 @@
 block discarded – undo
6 6
 
7 7
 class main_test extends \phpbb_test_case {
8 8
 
9
-    /**
10
-     * @var \florinp\messenger\controller\main
11
-     */
12
-    protected $controller;
13
-
14
-    public function setUp() {
15
-        parent::setUp();
16
-        /**
17
-         * @var \phpbb\user $user Mock the user class
18
-         */
19
-        $user = $this->getMock('\phpbb\user', array(), array('\phpbb\datetime'));
20
-
21
-        /**
22
-         * @var \phpbb\request\request $request
23
-         */
24
-        $request = $this->getMockBuilder('\phpbb\request\request')
25
-            ->disableOriginalConstructor()
26
-            ->getMock();
27
-
28
-        /**
29
-         * @var \florinp\messenger\models\main_model $model
30
-         */
31
-        $model = $this->getMockBuilder('\florinp\messenger\models\main_model')
32
-            ->disableOriginalConstructor()
33
-            ->getMock();
34
-
35
-        /**
36
-         * @var \phpbb\notification\manager $notification_manager
37
-         */
38
-        $notification_manager = $this->getMockBuilder('\phpbb\notification\manager')
39
-            ->disableOriginalConstructor()
40
-            ->getMock();
41
-
42
-        /**
43
-         * @var \florinp\messenger\libs\emojione $emojione
44
-         */
45
-        $emojione = $this->getMockBuilder('\florinp\messenger\libs\emojione')
46
-            ->disableOriginalConstructor()
47
-            ->getMock();
48
-
49
-        /**
50
-         * @var \florinp\messenger\libs\upload $upload
51
-         */
52
-        $upload = $this->getMockBuilder('\florinp\messenger\libs\upload')
53
-            ->disableOriginalConstructor()
54
-            ->getMock();
55
-
56
-        /**
57
-         * @var \florinp\messenger\libs\download $download
58
-         */
59
-        $download = $this->getMockBuilder('\florinp\messenger\libs\download')
60
-            ->disableOriginalConstructor()
61
-            ->getMock();
62
-
63
-        $this->controller = new \florinp\messenger\controller\main(
64
-            $request,
65
-            $user,
66
-            $model,
67
-            $notification_manager,
68
-            $emojione,
69
-            $upload,
70
-            $download
71
-        );
72
-    }
73
-
74
-    public function tearDown() {
75
-        $this->controller = null;
76
-        parent::tearDown();
77
-    }
78
-
79
-    public function publish_data() {
80
-        return array(
81
-            array(200, json_encode(array()))
82
-        );
83
-    }
84
-    /**
85
-     * @dataProvider publish_data
86
-     */
87
-    public function test_publish($status_code, $page_content) {
88
-        $response = $this->controller->publish();
89
-        $this->assertInstanceOf('\Symfony\Component\HttpFoundation\Response', $response);
90
-        $this->assertEquals($status_code, $response->getStatusCode());
91
-        $this->assertEquals($page_content, $response->getContent());
92
-    }
93
-
94
-
95
-    public function load_data() {
96
-        return array(
97
-            array(200, json_encode(array(
98
-                'success' => false,
99
-                'error' => 'The request is invalid'
100
-            )))
101
-        );
102
-    }
103
-    /**
104
-     * @dataProvider load_data
105
-     */
106
-    public function test_load($status_code, $page_content) {
107
-        $response = $this->controller->load();
108
-        $this->assertInstanceOf('\Symfony\Component\HttpFoundation\Response', $response);
109
-        $this->assertEquals($status_code, $response->getStatusCode());
110
-        $this->assertEquals($page_content, $response->getContent());
111
-    }
112
-
113
-
114
-    public function updateMessages_data() {
115
-        return array(
116
-            array(200, json_encode(array('success' => false)))
117
-        );
118
-    }
9
+	/**
10
+	 * @var \florinp\messenger\controller\main
11
+	 */
12
+	protected $controller;
13
+
14
+	public function setUp() {
15
+		parent::setUp();
16
+		/**
17
+		 * @var \phpbb\user $user Mock the user class
18
+		 */
19
+		$user = $this->getMock('\phpbb\user', array(), array('\phpbb\datetime'));
20
+
21
+		/**
22
+		 * @var \phpbb\request\request $request
23
+		 */
24
+		$request = $this->getMockBuilder('\phpbb\request\request')
25
+			->disableOriginalConstructor()
26
+			->getMock();
27
+
28
+		/**
29
+		 * @var \florinp\messenger\models\main_model $model
30
+		 */
31
+		$model = $this->getMockBuilder('\florinp\messenger\models\main_model')
32
+			->disableOriginalConstructor()
33
+			->getMock();
34
+
35
+		/**
36
+		 * @var \phpbb\notification\manager $notification_manager
37
+		 */
38
+		$notification_manager = $this->getMockBuilder('\phpbb\notification\manager')
39
+			->disableOriginalConstructor()
40
+			->getMock();
41
+
42
+		/**
43
+		 * @var \florinp\messenger\libs\emojione $emojione
44
+		 */
45
+		$emojione = $this->getMockBuilder('\florinp\messenger\libs\emojione')
46
+			->disableOriginalConstructor()
47
+			->getMock();
48
+
49
+		/**
50
+		 * @var \florinp\messenger\libs\upload $upload
51
+		 */
52
+		$upload = $this->getMockBuilder('\florinp\messenger\libs\upload')
53
+			->disableOriginalConstructor()
54
+			->getMock();
55
+
56
+		/**
57
+		 * @var \florinp\messenger\libs\download $download
58
+		 */
59
+		$download = $this->getMockBuilder('\florinp\messenger\libs\download')
60
+			->disableOriginalConstructor()
61
+			->getMock();
62
+
63
+		$this->controller = new \florinp\messenger\controller\main(
64
+			$request,
65
+			$user,
66
+			$model,
67
+			$notification_manager,
68
+			$emojione,
69
+			$upload,
70
+			$download
71
+		);
72
+	}
73
+
74
+	public function tearDown() {
75
+		$this->controller = null;
76
+		parent::tearDown();
77
+	}
78
+
79
+	public function publish_data() {
80
+		return array(
81
+			array(200, json_encode(array()))
82
+		);
83
+	}
84
+	/**
85
+	 * @dataProvider publish_data
86
+	 */
87
+	public function test_publish($status_code, $page_content) {
88
+		$response = $this->controller->publish();
89
+		$this->assertInstanceOf('\Symfony\Component\HttpFoundation\Response', $response);
90
+		$this->assertEquals($status_code, $response->getStatusCode());
91
+		$this->assertEquals($page_content, $response->getContent());
92
+	}
93
+
94
+
95
+	public function load_data() {
96
+		return array(
97
+			array(200, json_encode(array(
98
+				'success' => false,
99
+				'error' => 'The request is invalid'
100
+			)))
101
+		);
102
+	}
103
+	/**
104
+	 * @dataProvider load_data
105
+	 */
106
+	public function test_load($status_code, $page_content) {
107
+		$response = $this->controller->load();
108
+		$this->assertInstanceOf('\Symfony\Component\HttpFoundation\Response', $response);
109
+		$this->assertEquals($status_code, $response->getStatusCode());
110
+		$this->assertEquals($page_content, $response->getContent());
111
+	}
112
+
113
+
114
+	public function updateMessages_data() {
115
+		return array(
116
+			array(200, json_encode(array('success' => false)))
117
+		);
118
+	}
119 119
 }
120 120
\ No newline at end of file
Please login to merge, or discard this patch.
event/main_listener.php 3 patches
Indentation   +140 added lines, -140 removed lines patch added patch discarded remove patch
@@ -14,144 +14,144 @@
 block discarded – undo
14 14
 class main_listener implements EventSubscriberInterface
15 15
 {
16 16
 
17
-    static public function getSubscribedEvents()
18
-    {
19
-        return array(
20
-            'core.user_setup' => 'load_language_on_setup',
21
-            'core.page_footer' => 'friends_list',
22
-            'core.page_header' => 'check_login',
23
-            'core.memberlist_view_profile' => 'check_friends'
24
-        );
25
-    }
26
-
27
-
28
-    /* @var \phpbb\template\template */
29
-    protected $template;
30
-
31
-    /**
32
-     * @var main_model
33
-     */
34
-    protected $model;
35
-
36
-    /**
37
-     * @var friends_model
38
-     */
39
-    protected $friends_model;
40
-
41
-    /**
42
-     * @var user
43
-     */
44
-    protected $user;
45
-
46
-    /**
47
-     * @var symfony_request
48
-     */
49
-    protected $symfony_request;
50
-
51
-    public function __construct(
52
-        template $template,
53
-        main_model $model,
54
-        friends_model $friends_model,
55
-        user $user,
56
-        symfony_request $symfony_request
57
-    )
58
-    {
59
-        $this->template = $template;
60
-        $this->model = $model;
61
-        $this->friends_model = $friends_model;
62
-        $this->user = $user;
63
-        $this->symfony_request = $symfony_request;
64
-    }
65
-
66
-    public function friends_list()
67
-    {
68
-        $context = new RequestContext();
69
-        $context->fromRequest($this->symfony_request);
70
-        $baseUrl = generate_board_url(true) . $context->getBaseUrl();
71
-
72
-        $scriptName = $this->symfony_request->getScriptName();
73
-        $scriptName = substr($scriptName, -1, 1) == '/' ? '' : utf8_basename($scriptName);
74
-
75
-        if ($scriptName != '') {
76
-            $baseUrl = str_replace('/' . $scriptName, '', $baseUrl);
77
-        }
78
-
79
-        $friends = $this->model->getFriends();
80
-        $friends_online = array_filter($friends, function ($friend) {
81
-            return $friend['user_status'] != 0;
82
-        });
83
-        $this->template->assign_var('S_COUNT_FRIENDS', count($friends_online));
84
-        foreach ($friends as $friend) {
85
-            $this->template->assign_block_vars('chat_friends', array(
86
-                'U_USERID' => $friend['user_id'],
87
-                'U_USERNAME' => $friend['username'],
88
-                'U_USERCOLOR' => $friend['user_colour'],
89
-                'U_STATUS' => $friend['user_status'],
90
-                'U_USERINBOX' => $friend['inbox'],
91
-            ));
92
-        }
93
-        $this->template->assign_vars(array(
94
-            'BASE_URL' => $baseUrl
95
-        ));
96
-    }
97
-
98
-    public function load_language_on_setup($event)
99
-    {
100
-        $lang_set_ext = $event['lang_set_ext'];
101
-        $lang_set_ext[] = array(
102
-            'ext_name' => 'florinp/messenger',
103
-            'lang_set' => 'common',
104
-        );
105
-        $event['lang_set_ext'] = $lang_set_ext;
106
-    }
107
-
108
-    public function check_login()
109
-    {
110
-        $s_enable_messenger = 0;
111
-        if (in_array($this->user->data['user_type'], array(USER_NORMAL, USER_FOUNDER))) {
112
-            $s_enable_messenger = 1;
113
-        }
114
-        $this->template->assign_var('S_ENABLE_MESSENGER', $s_enable_messenger);
115
-    }
116
-
117
-    public function check_friends($event)
118
-    {
119
-        $context = new RequestContext();
120
-        $context->fromRequest($this->symfony_request);
121
-        $baseUrl = generate_board_url(true) . $context->getBaseUrl();
122
-
123
-        $scriptName = $this->symfony_request->getScriptName();
124
-        $scriptName = substr($scriptName, -1, 1) == '/' ? '' : utf8_basename($scriptName);
125
-
126
-        if ($scriptName != '') {
127
-            $baseUrl = str_replace('/' . $scriptName, '', $baseUrl);
128
-        }
129
-
130
-        $user_id = $event['member']['user_id'];
131
-        $sender_id = $this->user->data['user_id'];
132
-        $request = $this->friends_model->get_request_by_sender_id($sender_id);
133
-        $check_friend = $this->friends_model->check_friend(array(
134
-            'user_id' => $this->user->data['user_id'],
135
-            'friend_id' => $user_id,
136
-        ));
137
-        $check_request = $this->friends_model->check_request(array(
138
-            'user_id' => $user_id,
139
-            'sender_id' => $this->user->data['user_id']
140
-        ));
141
-        $check_request_confirm = $this->friends_model->check_request(array(
142
-            'user_id' => $this->user->data['user_id'],
143
-            'sender_id' => $user_id
144
-        ));
145
-        $check_widget = true;
146
-        if ($user_id == $this->user->data['user_id']) $check_widget = false;
147
-        $this->template->assign_vars(array(
148
-            'U_USER_ID' => $user_id,
149
-            'U_CHECK_FRIEND' => $check_friend,
150
-            'U_CHECK_REQUEST' => $check_request,
151
-            'U_CHECK_REQUEST_CONFIRM' => $check_request_confirm,
152
-            'U_CHECK_WIDGET' => $check_widget,
153
-            'U_REQUEST_ID' => $request['request_id'],
154
-            'BASE_URL' => $baseUrl
155
-        ));
156
-    }
17
+	static public function getSubscribedEvents()
18
+	{
19
+		return array(
20
+			'core.user_setup' => 'load_language_on_setup',
21
+			'core.page_footer' => 'friends_list',
22
+			'core.page_header' => 'check_login',
23
+			'core.memberlist_view_profile' => 'check_friends'
24
+		);
25
+	}
26
+
27
+
28
+	/* @var \phpbb\template\template */
29
+	protected $template;
30
+
31
+	/**
32
+	 * @var main_model
33
+	 */
34
+	protected $model;
35
+
36
+	/**
37
+	 * @var friends_model
38
+	 */
39
+	protected $friends_model;
40
+
41
+	/**
42
+	 * @var user
43
+	 */
44
+	protected $user;
45
+
46
+	/**
47
+	 * @var symfony_request
48
+	 */
49
+	protected $symfony_request;
50
+
51
+	public function __construct(
52
+		template $template,
53
+		main_model $model,
54
+		friends_model $friends_model,
55
+		user $user,
56
+		symfony_request $symfony_request
57
+	)
58
+	{
59
+		$this->template = $template;
60
+		$this->model = $model;
61
+		$this->friends_model = $friends_model;
62
+		$this->user = $user;
63
+		$this->symfony_request = $symfony_request;
64
+	}
65
+
66
+	public function friends_list()
67
+	{
68
+		$context = new RequestContext();
69
+		$context->fromRequest($this->symfony_request);
70
+		$baseUrl = generate_board_url(true) . $context->getBaseUrl();
71
+
72
+		$scriptName = $this->symfony_request->getScriptName();
73
+		$scriptName = substr($scriptName, -1, 1) == '/' ? '' : utf8_basename($scriptName);
74
+
75
+		if ($scriptName != '') {
76
+			$baseUrl = str_replace('/' . $scriptName, '', $baseUrl);
77
+		}
78
+
79
+		$friends = $this->model->getFriends();
80
+		$friends_online = array_filter($friends, function ($friend) {
81
+			return $friend['user_status'] != 0;
82
+		});
83
+		$this->template->assign_var('S_COUNT_FRIENDS', count($friends_online));
84
+		foreach ($friends as $friend) {
85
+			$this->template->assign_block_vars('chat_friends', array(
86
+				'U_USERID' => $friend['user_id'],
87
+				'U_USERNAME' => $friend['username'],
88
+				'U_USERCOLOR' => $friend['user_colour'],
89
+				'U_STATUS' => $friend['user_status'],
90
+				'U_USERINBOX' => $friend['inbox'],
91
+			));
92
+		}
93
+		$this->template->assign_vars(array(
94
+			'BASE_URL' => $baseUrl
95
+		));
96
+	}
97
+
98
+	public function load_language_on_setup($event)
99
+	{
100
+		$lang_set_ext = $event['lang_set_ext'];
101
+		$lang_set_ext[] = array(
102
+			'ext_name' => 'florinp/messenger',
103
+			'lang_set' => 'common',
104
+		);
105
+		$event['lang_set_ext'] = $lang_set_ext;
106
+	}
107
+
108
+	public function check_login()
109
+	{
110
+		$s_enable_messenger = 0;
111
+		if (in_array($this->user->data['user_type'], array(USER_NORMAL, USER_FOUNDER))) {
112
+			$s_enable_messenger = 1;
113
+		}
114
+		$this->template->assign_var('S_ENABLE_MESSENGER', $s_enable_messenger);
115
+	}
116
+
117
+	public function check_friends($event)
118
+	{
119
+		$context = new RequestContext();
120
+		$context->fromRequest($this->symfony_request);
121
+		$baseUrl = generate_board_url(true) . $context->getBaseUrl();
122
+
123
+		$scriptName = $this->symfony_request->getScriptName();
124
+		$scriptName = substr($scriptName, -1, 1) == '/' ? '' : utf8_basename($scriptName);
125
+
126
+		if ($scriptName != '') {
127
+			$baseUrl = str_replace('/' . $scriptName, '', $baseUrl);
128
+		}
129
+
130
+		$user_id = $event['member']['user_id'];
131
+		$sender_id = $this->user->data['user_id'];
132
+		$request = $this->friends_model->get_request_by_sender_id($sender_id);
133
+		$check_friend = $this->friends_model->check_friend(array(
134
+			'user_id' => $this->user->data['user_id'],
135
+			'friend_id' => $user_id,
136
+		));
137
+		$check_request = $this->friends_model->check_request(array(
138
+			'user_id' => $user_id,
139
+			'sender_id' => $this->user->data['user_id']
140
+		));
141
+		$check_request_confirm = $this->friends_model->check_request(array(
142
+			'user_id' => $this->user->data['user_id'],
143
+			'sender_id' => $user_id
144
+		));
145
+		$check_widget = true;
146
+		if ($user_id == $this->user->data['user_id']) $check_widget = false;
147
+		$this->template->assign_vars(array(
148
+			'U_USER_ID' => $user_id,
149
+			'U_CHECK_FRIEND' => $check_friend,
150
+			'U_CHECK_REQUEST' => $check_request,
151
+			'U_CHECK_REQUEST_CONFIRM' => $check_request_confirm,
152
+			'U_CHECK_WIDGET' => $check_widget,
153
+			'U_REQUEST_ID' => $request['request_id'],
154
+			'BASE_URL' => $baseUrl
155
+		));
156
+	}
157 157
 }
Please login to merge, or discard this patch.
Spacing   +5 added lines, -5 removed lines patch added patch discarded remove patch
@@ -67,17 +67,17 @@  discard block
 block discarded – undo
67 67
     {
68 68
         $context = new RequestContext();
69 69
         $context->fromRequest($this->symfony_request);
70
-        $baseUrl = generate_board_url(true) . $context->getBaseUrl();
70
+        $baseUrl = generate_board_url(true).$context->getBaseUrl();
71 71
 
72 72
         $scriptName = $this->symfony_request->getScriptName();
73 73
         $scriptName = substr($scriptName, -1, 1) == '/' ? '' : utf8_basename($scriptName);
74 74
 
75 75
         if ($scriptName != '') {
76
-            $baseUrl = str_replace('/' . $scriptName, '', $baseUrl);
76
+            $baseUrl = str_replace('/'.$scriptName, '', $baseUrl);
77 77
         }
78 78
 
79 79
         $friends = $this->model->getFriends();
80
-        $friends_online = array_filter($friends, function ($friend) {
80
+        $friends_online = array_filter($friends, function($friend) {
81 81
             return $friend['user_status'] != 0;
82 82
         });
83 83
         $this->template->assign_var('S_COUNT_FRIENDS', count($friends_online));
@@ -118,13 +118,13 @@  discard block
 block discarded – undo
118 118
     {
119 119
         $context = new RequestContext();
120 120
         $context->fromRequest($this->symfony_request);
121
-        $baseUrl = generate_board_url(true) . $context->getBaseUrl();
121
+        $baseUrl = generate_board_url(true).$context->getBaseUrl();
122 122
 
123 123
         $scriptName = $this->symfony_request->getScriptName();
124 124
         $scriptName = substr($scriptName, -1, 1) == '/' ? '' : utf8_basename($scriptName);
125 125
 
126 126
         if ($scriptName != '') {
127
-            $baseUrl = str_replace('/' . $scriptName, '', $baseUrl);
127
+            $baseUrl = str_replace('/'.$scriptName, '', $baseUrl);
128 128
         }
129 129
 
130 130
         $user_id = $event['member']['user_id'];
Please login to merge, or discard this patch.
Braces   +3 added lines, -1 removed lines patch added patch discarded remove patch
@@ -143,7 +143,9 @@
 block discarded – undo
143 143
             'sender_id' => $user_id
144 144
         ));
145 145
         $check_widget = true;
146
-        if ($user_id == $this->user->data['user_id']) $check_widget = false;
146
+        if ($user_id == $this->user->data['user_id']) {
147
+        	$check_widget = false;
148
+        }
147 149
         $this->template->assign_vars(array(
148 150
             'U_USER_ID' => $user_id,
149 151
             'U_CHECK_FRIEND' => $check_friend,
Please login to merge, or discard this patch.
controller/friends.php 1 patch
Indentation   +156 added lines, -156 removed lines patch added patch discarded remove patch
@@ -12,160 +12,160 @@
 block discarded – undo
12 12
 class friends
13 13
 {
14 14
 
15
-    protected $template;
16
-    protected $user;
17
-    protected $user_loader;
18
-    protected $model;
19
-    protected $request;
20
-    protected $notification_manager;
21
-    protected $u_action;
22
-
23
-    public function __construct(
24
-        template $template,
25
-        request $request,
26
-        user $user,
27
-        user_loader $user_loader,
28
-        friends_model $model,
29
-        manager $notification_manager
30
-    )
31
-    {
32
-        $this->template = $template;
33
-        $this->request = $request;
34
-        $this->user = $user;
35
-        $this->user_loader = $user_loader;
36
-        $this->model = $model;
37
-        $this->notification_manager = $notification_manager;
38
-    }
39
-
40
-    public function friends_list()
41
-    {
42
-        $friends = $this->model->getFriends();
43
-        $i = 0;
44
-        foreach ($friends as $friend) {
45
-            $i = $i + 1;
46
-            $this->user_loader->load_users(array(
47
-                $friend['user_id']
48
-            ));
49
-            $this->template->assign_block_vars('friends', array(
50
-                'user_id' => $friend['user_id'],
51
-                'username' => $this->user_loader->get_username($friend['user_id'], 'full'),
52
-                'user_colour' => $friend['user_colour'],
53
-                'user_status' => ($friend['user_status'] == 1) ? 'online' : 'offline',
54
-                'row_count' => $i
55
-            ));
56
-        }
57
-
58
-        $this->template->assign_vars(array(
59
-            'U_ACTION' => $this->u_action,
60
-        ));
61
-    }
62
-
63
-    public function requests()
64
-    {
65
-        $requests = $this->model->get_friends_requests();
66
-        $i = 0;
67
-        foreach ($requests as $request) {
68
-            $i = $i + 1;
69
-            $this->user_loader->load_users(array(
70
-                $request['user_id'],
71
-                $request['sender_id']
72
-            ));
73
-            $this->template->assign_block_vars('requests', array(
74
-                'request_id' => $request['request_id'],
75
-                'sender_username' => $this->user_loader->get_username($request['sender_id'], 'full'),
76
-                'status' => ($request['status'] == 1) ? ($this->user->lang['APPROVED']) : ($this->user->lang['WAITING_FOR_APPROVAL']),
77
-                'time' => date('d M Y H:i:s', $request['time']),
78
-                'row_count' => $i
79
-            ));
80
-        }
81
-
82
-        $this->template->assign_vars(array(
83
-            'U_ACTION' => $this->u_action,
84
-        ));
85
-    }
86
-
87
-    public function delete_request($requests_id)
88
-    {
89
-        if (is_array($requests_id)) {
90
-            foreach ($requests_id as $id) {
91
-                $this->model->delete_friend_request($id);
92
-            }
93
-        } else {
94
-            $this->model->delete_friend_request($requests_id);
95
-        }
96
-    }
97
-
98
-    public function approve_request($requests_id)
99
-    {
100
-        if (is_array($requests_id)) {
101
-            foreach ($requests_id as $id) {
102
-                $request_data = $this->model->get_friend_request($id);
103
-                if ($request_data) {
104
-                    $this->model->add_friend(array(
105
-                        'user_id' => $request_data['user_id'],
106
-                        'friend_id' => $request_data['sender_id']
107
-                    ));
108
-                }
109
-
110
-            }
111
-        } else {
112
-            $this->model->approve_friend_request($requests_id);
113
-            $request_data = $this->model->get_friend_request($requests_id);
114
-            $this->model->add_friend(array(
115
-                'user_id' => $request_data['user_id'],
116
-                'friend_id' => $request_data['sender_id']
117
-            ));
118
-        }
119
-    }
120
-
121
-    public function send_request($user_id)
122
-    {
123
-        $user_id = (int)$user_id;
124
-        $sender_id = $this->user->data['user_id'];
125
-
126
-        $insert = array(
127
-            'user_id' => $user_id,
128
-            'sender_id' => $sender_id
129
-        );
130
-
131
-        if ($request_id = $this->model->insert_friends_request($insert)) {
132
-
133
-            $notification_data = array(
134
-                'request_id' => $request_id,
135
-                'sender_id' => $sender_id,
136
-                'sender_username' => $this->user->data ['username'],
137
-                'user_id' => $user_id
138
-            );
139
-
140
-            $this->notification_manager->add_notifications(array(
141
-                'florinp.messenger.notification.type.friend_request'
142
-            ), $notification_data);
143
-
144
-            return true;
145
-        }
146
-
147
-        return false;
148
-    }
149
-
150
-    public function remove_friend($user_id)
151
-    {
152
-
153
-        if (is_array($user_id)) {
154
-            foreach ($user_id as $id) {
155
-                $this->model->remove_friend($id);
156
-            }
157
-            return true;
158
-        } else {
159
-            if ($user_id > 1) {
160
-                $this->model->remove_friend($user_id);
161
-                return true;
162
-            }
163
-        }
164
-        return false;
165
-    }
166
-
167
-    public function set_page_url($u_action)
168
-    {
169
-        $this->u_action = $u_action;
170
-    }
15
+	protected $template;
16
+	protected $user;
17
+	protected $user_loader;
18
+	protected $model;
19
+	protected $request;
20
+	protected $notification_manager;
21
+	protected $u_action;
22
+
23
+	public function __construct(
24
+		template $template,
25
+		request $request,
26
+		user $user,
27
+		user_loader $user_loader,
28
+		friends_model $model,
29
+		manager $notification_manager
30
+	)
31
+	{
32
+		$this->template = $template;
33
+		$this->request = $request;
34
+		$this->user = $user;
35
+		$this->user_loader = $user_loader;
36
+		$this->model = $model;
37
+		$this->notification_manager = $notification_manager;
38
+	}
39
+
40
+	public function friends_list()
41
+	{
42
+		$friends = $this->model->getFriends();
43
+		$i = 0;
44
+		foreach ($friends as $friend) {
45
+			$i = $i + 1;
46
+			$this->user_loader->load_users(array(
47
+				$friend['user_id']
48
+			));
49
+			$this->template->assign_block_vars('friends', array(
50
+				'user_id' => $friend['user_id'],
51
+				'username' => $this->user_loader->get_username($friend['user_id'], 'full'),
52
+				'user_colour' => $friend['user_colour'],
53
+				'user_status' => ($friend['user_status'] == 1) ? 'online' : 'offline',
54
+				'row_count' => $i
55
+			));
56
+		}
57
+
58
+		$this->template->assign_vars(array(
59
+			'U_ACTION' => $this->u_action,
60
+		));
61
+	}
62
+
63
+	public function requests()
64
+	{
65
+		$requests = $this->model->get_friends_requests();
66
+		$i = 0;
67
+		foreach ($requests as $request) {
68
+			$i = $i + 1;
69
+			$this->user_loader->load_users(array(
70
+				$request['user_id'],
71
+				$request['sender_id']
72
+			));
73
+			$this->template->assign_block_vars('requests', array(
74
+				'request_id' => $request['request_id'],
75
+				'sender_username' => $this->user_loader->get_username($request['sender_id'], 'full'),
76
+				'status' => ($request['status'] == 1) ? ($this->user->lang['APPROVED']) : ($this->user->lang['WAITING_FOR_APPROVAL']),
77
+				'time' => date('d M Y H:i:s', $request['time']),
78
+				'row_count' => $i
79
+			));
80
+		}
81
+
82
+		$this->template->assign_vars(array(
83
+			'U_ACTION' => $this->u_action,
84
+		));
85
+	}
86
+
87
+	public function delete_request($requests_id)
88
+	{
89
+		if (is_array($requests_id)) {
90
+			foreach ($requests_id as $id) {
91
+				$this->model->delete_friend_request($id);
92
+			}
93
+		} else {
94
+			$this->model->delete_friend_request($requests_id);
95
+		}
96
+	}
97
+
98
+	public function approve_request($requests_id)
99
+	{
100
+		if (is_array($requests_id)) {
101
+			foreach ($requests_id as $id) {
102
+				$request_data = $this->model->get_friend_request($id);
103
+				if ($request_data) {
104
+					$this->model->add_friend(array(
105
+						'user_id' => $request_data['user_id'],
106
+						'friend_id' => $request_data['sender_id']
107
+					));
108
+				}
109
+
110
+			}
111
+		} else {
112
+			$this->model->approve_friend_request($requests_id);
113
+			$request_data = $this->model->get_friend_request($requests_id);
114
+			$this->model->add_friend(array(
115
+				'user_id' => $request_data['user_id'],
116
+				'friend_id' => $request_data['sender_id']
117
+			));
118
+		}
119
+	}
120
+
121
+	public function send_request($user_id)
122
+	{
123
+		$user_id = (int)$user_id;
124
+		$sender_id = $this->user->data['user_id'];
125
+
126
+		$insert = array(
127
+			'user_id' => $user_id,
128
+			'sender_id' => $sender_id
129
+		);
130
+
131
+		if ($request_id = $this->model->insert_friends_request($insert)) {
132
+
133
+			$notification_data = array(
134
+				'request_id' => $request_id,
135
+				'sender_id' => $sender_id,
136
+				'sender_username' => $this->user->data ['username'],
137
+				'user_id' => $user_id
138
+			);
139
+
140
+			$this->notification_manager->add_notifications(array(
141
+				'florinp.messenger.notification.type.friend_request'
142
+			), $notification_data);
143
+
144
+			return true;
145
+		}
146
+
147
+		return false;
148
+	}
149
+
150
+	public function remove_friend($user_id)
151
+	{
152
+
153
+		if (is_array($user_id)) {
154
+			foreach ($user_id as $id) {
155
+				$this->model->remove_friend($id);
156
+			}
157
+			return true;
158
+		} else {
159
+			if ($user_id > 1) {
160
+				$this->model->remove_friend($user_id);
161
+				return true;
162
+			}
163
+		}
164
+		return false;
165
+	}
166
+
167
+	public function set_page_url($u_action)
168
+	{
169
+		$this->u_action = $u_action;
170
+	}
171 171
 }
Please login to merge, or discard this patch.
controller/main.php 1 patch
Indentation   +182 added lines, -182 removed lines patch added patch discarded remove patch
@@ -15,187 +15,187 @@
 block discarded – undo
15 15
 class main
16 16
 {
17 17
 
18
-    protected $user;
19
-    protected $model;
20
-    protected $request;
21
-    protected $notification_manager;
22
-    protected $upload;
23
-    protected $download;
24
-
25
-    public function __construct(
26
-        request $request,
27
-        user $user,
28
-        main_model $model,
29
-        manager $notification_manager,
30
-        upload $upload,
31
-        download $download
32
-    )
33
-    {
34
-        $this->request = $request;
35
-        $this->user = $user;
36
-        $this->model = $model;
37
-        $this->notification_manager = $notification_manager;
38
-        $this->upload = $upload;
39
-        $this->download = $download;
40
-    }
41
-
42
-    public function handle()
43
-    {
44
-    }
45
-
46
-    public function index()
47
-    {
48
-
49
-    }
50
-
51
-    public function publish()
52
-    {
53
-        $text = $this->request->variable('text', '', true);
54
-        $receiver_id = $this->request->variable('receiver_id', 0);
55
-        $sender_id = $this->user->data['user_id'];
56
-
57
-        $response = array();
58
-        if ($receiver_id != 0 && trim($text) != '') {
59
-            $text = htmlspecialchars($text);
60
-            $text = str_replace(array("\n", "\r"), '', $text);
61
-
62
-            $message = array(
63
-                'sender_id' => $sender_id,
64
-                'receiver_id' => $receiver_id,
65
-                'text' => $text,
66
-                'sentAt' => time()
67
-            );
68
-
69
-            if ($id = $this->model->sendMessage($message)) {
70
-                $lastMessage = $this->model->getMessageById($id);
71
-                $response = array('success' => true, 'message' => $lastMessage);
72
-            } else {
73
-                $response = array(
74
-                    'succes' => false,
75
-                    'error' => 'An error has been ocurred!'
76
-                );
77
-            }
78
-        }
79
-
80
-        return new JsonResponse($response, 200);
81
-    }
82
-
83
-    public function getFile($id)
84
-    {
85
-        $id = explode('_', $id)[1];
86
-        $file = $this->model->getFileById($id);
87
-        $this->download->setFile($file['file']);
88
-        $this->download->sendDownload();
89
-    }
90
-
91
-    public function sendFile()
92
-    {
93
-        $receiver_id = $this->request->variable('receiver_id', 0);
94
-        $sender_id = $this->user->data['user_id'];
95
-
96
-        $response = array();
97
-        $file = $this->request->file('file');
98
-        if ($receiver_id != 0 && !empty($file)) {
99
-            if ($file['error'] == 0) {
100
-                $this->upload->file($file);
101
-                $this->upload->set_allowed_mime_types(array(
102
-                    'image/gif',
103
-                    'image/jpeg',
104
-                    'image/png',
105
-                    'application/pdf',
106
-                    'application/x-rar-compressed',
107
-                    'application/zip',
108
-                    'application/x-7z-compressed',
109
-                    'text/plain'
110
-                ));
111
-                $results = $this->upload->upload();
112
-                if (isset($results['errors']) && count($results['errors'])) {
113
-                    $response = array(
114
-                        'success' => false,
115
-                        'errors' => $results['errors']
116
-                    );
117
-                } else {
118
-                    $data = array(
119
-                        'sender_id' => $sender_id,
120
-                        'receiver_id' => $receiver_id,
121
-                        'fileName' => $results['original_filename'],
122
-                        'file' => $results['filename'],
123
-                        'type' => $results['mime'],
124
-                    );
125
-                    if ($id = $this->model->sendFile($data)) {
126
-                        $lastFile = $this->model->getFileById($id);
127
-                        $response = array(
128
-                            'success' => true,
129
-                            'file' => $lastFile
130
-                        );
131
-                    } else {
132
-                        $response = array(
133
-                            'succes' => false,
134
-                            'error' => 'An error has been ocurred!'
135
-                        );
136
-                    }
137
-                }
138
-            } else {
139
-                $response = array(
140
-                    'succes' => false,
141
-                    'error' => $file['error']
142
-                );
143
-            }
144
-        }
145
-
146
-        return new JsonResponse($response, 200);
147
-    }
148
-
149
-    public function load()
150
-    {
151
-        $friend_id = $this->request->variable('friend_id', 0);
152
-
153
-        if ($friend_id > 0) {
154
-            $messages = $this->model->getMessages($friend_id);
155
-            return new JsonResponse($messages, 200);
156
-        }
157
-        return new JsonResponse(array('success' => false, 'error' => 'The request is invalid'), 200);
158
-    }
159
-
160
-    public function updateMessages()
161
-    {
162
-        $friend_id = $this->request->variable('friend_id', 0);
163
-        if ($friend_id > 0) {
164
-            $newVal = $this->model->updateMessagesStatus($friend_id);
165
-            return new JsonResponse(array('success' => true, 'newVal' => $newVal), 200);
166
-        }
167
-        return new JsonResponse(array('success' => false), 200);
168
-    }
169
-
170
-    public function checkForNewMessages()
171
-    {
172
-        $friend_id = $this->request->variable('friend_id', 0);
173
-        if ($friend_id > 0) {
174
-            $messages = $this->model->getInboxFromId($friend_id);
175
-            return new JsonResponse(array('success' => true, 'messages' => $messages), 200);
176
-        }
177
-        return new JsonResponse(array('success' => false), 200);
178
-    }
179
-
180
-    public function getFriends()
181
-    {
182
-        $friends = $this->model->getFriends();
183
-        $friends_online = array_filter($friends, function ($friend) {
184
-            return $friend['user_status'] != 0;
185
-        });
186
-
187
-        $response = array(
188
-            'friends_online' => count($friends_online),
189
-            'friends_list' => $friends
190
-        );
191
-
192
-        return new JsonResponse($response, 200);
193
-    }
194
-
195
-    public function getEmoticons()
196
-    {
197
-        $response = array();
198
-        return new JsonResponse($response, 200);
199
-    }
18
+	protected $user;
19
+	protected $model;
20
+	protected $request;
21
+	protected $notification_manager;
22
+	protected $upload;
23
+	protected $download;
24
+
25
+	public function __construct(
26
+		request $request,
27
+		user $user,
28
+		main_model $model,
29
+		manager $notification_manager,
30
+		upload $upload,
31
+		download $download
32
+	)
33
+	{
34
+		$this->request = $request;
35
+		$this->user = $user;
36
+		$this->model = $model;
37
+		$this->notification_manager = $notification_manager;
38
+		$this->upload = $upload;
39
+		$this->download = $download;
40
+	}
41
+
42
+	public function handle()
43
+	{
44
+	}
45
+
46
+	public function index()
47
+	{
48
+
49
+	}
50
+
51
+	public function publish()
52
+	{
53
+		$text = $this->request->variable('text', '', true);
54
+		$receiver_id = $this->request->variable('receiver_id', 0);
55
+		$sender_id = $this->user->data['user_id'];
56
+
57
+		$response = array();
58
+		if ($receiver_id != 0 && trim($text) != '') {
59
+			$text = htmlspecialchars($text);
60
+			$text = str_replace(array("\n", "\r"), '', $text);
61
+
62
+			$message = array(
63
+				'sender_id' => $sender_id,
64
+				'receiver_id' => $receiver_id,
65
+				'text' => $text,
66
+				'sentAt' => time()
67
+			);
68
+
69
+			if ($id = $this->model->sendMessage($message)) {
70
+				$lastMessage = $this->model->getMessageById($id);
71
+				$response = array('success' => true, 'message' => $lastMessage);
72
+			} else {
73
+				$response = array(
74
+					'succes' => false,
75
+					'error' => 'An error has been ocurred!'
76
+				);
77
+			}
78
+		}
79
+
80
+		return new JsonResponse($response, 200);
81
+	}
82
+
83
+	public function getFile($id)
84
+	{
85
+		$id = explode('_', $id)[1];
86
+		$file = $this->model->getFileById($id);
87
+		$this->download->setFile($file['file']);
88
+		$this->download->sendDownload();
89
+	}
90
+
91
+	public function sendFile()
92
+	{
93
+		$receiver_id = $this->request->variable('receiver_id', 0);
94
+		$sender_id = $this->user->data['user_id'];
95
+
96
+		$response = array();
97
+		$file = $this->request->file('file');
98
+		if ($receiver_id != 0 && !empty($file)) {
99
+			if ($file['error'] == 0) {
100
+				$this->upload->file($file);
101
+				$this->upload->set_allowed_mime_types(array(
102
+					'image/gif',
103
+					'image/jpeg',
104
+					'image/png',
105
+					'application/pdf',
106
+					'application/x-rar-compressed',
107
+					'application/zip',
108
+					'application/x-7z-compressed',
109
+					'text/plain'
110
+				));
111
+				$results = $this->upload->upload();
112
+				if (isset($results['errors']) && count($results['errors'])) {
113
+					$response = array(
114
+						'success' => false,
115
+						'errors' => $results['errors']
116
+					);
117
+				} else {
118
+					$data = array(
119
+						'sender_id' => $sender_id,
120
+						'receiver_id' => $receiver_id,
121
+						'fileName' => $results['original_filename'],
122
+						'file' => $results['filename'],
123
+						'type' => $results['mime'],
124
+					);
125
+					if ($id = $this->model->sendFile($data)) {
126
+						$lastFile = $this->model->getFileById($id);
127
+						$response = array(
128
+							'success' => true,
129
+							'file' => $lastFile
130
+						);
131
+					} else {
132
+						$response = array(
133
+							'succes' => false,
134
+							'error' => 'An error has been ocurred!'
135
+						);
136
+					}
137
+				}
138
+			} else {
139
+				$response = array(
140
+					'succes' => false,
141
+					'error' => $file['error']
142
+				);
143
+			}
144
+		}
145
+
146
+		return new JsonResponse($response, 200);
147
+	}
148
+
149
+	public function load()
150
+	{
151
+		$friend_id = $this->request->variable('friend_id', 0);
152
+
153
+		if ($friend_id > 0) {
154
+			$messages = $this->model->getMessages($friend_id);
155
+			return new JsonResponse($messages, 200);
156
+		}
157
+		return new JsonResponse(array('success' => false, 'error' => 'The request is invalid'), 200);
158
+	}
159
+
160
+	public function updateMessages()
161
+	{
162
+		$friend_id = $this->request->variable('friend_id', 0);
163
+		if ($friend_id > 0) {
164
+			$newVal = $this->model->updateMessagesStatus($friend_id);
165
+			return new JsonResponse(array('success' => true, 'newVal' => $newVal), 200);
166
+		}
167
+		return new JsonResponse(array('success' => false), 200);
168
+	}
169
+
170
+	public function checkForNewMessages()
171
+	{
172
+		$friend_id = $this->request->variable('friend_id', 0);
173
+		if ($friend_id > 0) {
174
+			$messages = $this->model->getInboxFromId($friend_id);
175
+			return new JsonResponse(array('success' => true, 'messages' => $messages), 200);
176
+		}
177
+		return new JsonResponse(array('success' => false), 200);
178
+	}
179
+
180
+	public function getFriends()
181
+	{
182
+		$friends = $this->model->getFriends();
183
+		$friends_online = array_filter($friends, function ($friend) {
184
+			return $friend['user_status'] != 0;
185
+		});
186
+
187
+		$response = array(
188
+			'friends_online' => count($friends_online),
189
+			'friends_list' => $friends
190
+		);
191
+
192
+		return new JsonResponse($response, 200);
193
+	}
194
+
195
+	public function getEmoticons()
196
+	{
197
+		$response = array();
198
+		return new JsonResponse($response, 200);
199
+	}
200 200
 
201 201
 }
Please login to merge, or discard this patch.
models/main_model.php 3 patches
Indentation   +288 added lines, -288 removed lines patch added patch discarded remove patch
@@ -11,61 +11,61 @@  discard block
 block discarded – undo
11 11
 class main_model
12 12
 {
13 13
 
14
-    /**
15
-     * @var config
16
-     */
17
-    protected $config;
18
-
19
-    /**
20
-     * @var driver_interface
21
-     */
22
-    protected $phpbb_db;
23
-
24
-    /**
25
-     * @var user
26
-     */
27
-    protected $user;
28
-
29
-    /**
30
-     * @var database
31
-     */
32
-    protected $db;
33
-
34
-    /**
35
-     * @var string
36
-     */
37
-    protected $friends_request_table;
38
-
39
-    /**
40
-     * @var string
41
-     */
42
-    protected $user_friends_table;
43
-
44
-
45
-    public function __construct(
46
-        config $config,
47
-        driver_interface $phpbb_db,
48
-        user $user,
49
-        database $db,
50
-        $friends_request_table,
51
-        $user_friends_table
52
-    )
53
-    {
54
-        $this->config = $config;
55
-        $this->phpbb_db = $phpbb_db;
56
-        $this->user = $user;
57
-        $this->db = $db;
58
-        $this->friends_request_table = $friends_request_table;
59
-        $this->user_friends_table = $user_friends_table;
60
-    }
61
-
62
-    /**
63
-     * get all friends
64
-     * @return array the list of friends
65
-     */
66
-    public function getFriends()
67
-    {
68
-        $sql = "
14
+	/**
15
+	 * @var config
16
+	 */
17
+	protected $config;
18
+
19
+	/**
20
+	 * @var driver_interface
21
+	 */
22
+	protected $phpbb_db;
23
+
24
+	/**
25
+	 * @var user
26
+	 */
27
+	protected $user;
28
+
29
+	/**
30
+	 * @var database
31
+	 */
32
+	protected $db;
33
+
34
+	/**
35
+	 * @var string
36
+	 */
37
+	protected $friends_request_table;
38
+
39
+	/**
40
+	 * @var string
41
+	 */
42
+	protected $user_friends_table;
43
+
44
+
45
+	public function __construct(
46
+		config $config,
47
+		driver_interface $phpbb_db,
48
+		user $user,
49
+		database $db,
50
+		$friends_request_table,
51
+		$user_friends_table
52
+	)
53
+	{
54
+		$this->config = $config;
55
+		$this->phpbb_db = $phpbb_db;
56
+		$this->user = $user;
57
+		$this->db = $db;
58
+		$this->friends_request_table = $friends_request_table;
59
+		$this->user_friends_table = $user_friends_table;
60
+	}
61
+
62
+	/**
63
+	 * get all friends
64
+	 * @return array the list of friends
65
+	 */
66
+	public function getFriends()
67
+	{
68
+		$sql = "
69 69
             SELECT u.user_id,
70 70
                    u.username,
71 71
                    u.username_clean,
@@ -79,31 +79,31 @@  discard block
 block discarded – undo
79 79
             WHERE " . $this->user_friends_table . ".user_id = " . (int)$this->user->data['user_id'] . "
80 80
             GROUP BY u.user_id
81 81
         ";
82
-        $result = $this->phpbb_db->sql_query($sql);
83
-
84
-        $friends = array();
85
-        while ($row = $this->phpbb_db->sql_fetchrow($result)) {
86
-            $friends[] = array(
87
-                'user_id' => $row['user_id'],
88
-                'username' => $row['username_clean'],
89
-                'user_colour' => $row['user_colour'],
90
-                'user_status' => ($row['session_time'] >= (time() - ($this->config['load_online_time'] * 60))) ? 1 : 0,
91
-                'inbox' => $this->getInboxFromId($row['user_id'])
92
-            );
93
-        }
94
-        $this->phpbb_db->sql_freeresult();
95
-
96
-        return $friends;
97
-    }
98
-
99
-    /**
100
-     * checks if a user is friend with other user and vice-versa
101
-     * @param int $friend_id
102
-     * @return bool
103
-     */
104
-    public function checkFriend($friend_id)
105
-    {
106
-        $sql = "
82
+		$result = $this->phpbb_db->sql_query($sql);
83
+
84
+		$friends = array();
85
+		while ($row = $this->phpbb_db->sql_fetchrow($result)) {
86
+			$friends[] = array(
87
+				'user_id' => $row['user_id'],
88
+				'username' => $row['username_clean'],
89
+				'user_colour' => $row['user_colour'],
90
+				'user_status' => ($row['session_time'] >= (time() - ($this->config['load_online_time'] * 60))) ? 1 : 0,
91
+				'inbox' => $this->getInboxFromId($row['user_id'])
92
+			);
93
+		}
94
+		$this->phpbb_db->sql_freeresult();
95
+
96
+		return $friends;
97
+	}
98
+
99
+	/**
100
+	 * checks if a user is friend with other user and vice-versa
101
+	 * @param int $friend_id
102
+	 * @return bool
103
+	 */
104
+	public function checkFriend($friend_id)
105
+	{
106
+		$sql = "
107 107
 			SELECT COUNT(zebra_id) as friend_count
108 108
 			FROM " . ZEBRA_TABLE . "
109 109
 			WHERE user_id = " . (int)$friend_id . "
@@ -111,233 +111,233 @@  discard block
 block discarded – undo
111 111
 				AND friend = 1
112 112
 				AND foe = 0
113 113
 		";
114
-        $result = $this->phpbb_db->sql_query($sql);
115
-        $friend_count = (int)$this->phpbb_db->sql_fetchfield('friend_count');
116
-        $this->phpbb_db->sql_freeresult($result);
117
-
118
-        if ($friend_count > 0) {
119
-            return true;
120
-        } else {
121
-            return false;
122
-        }
123
-    }
124
-
125
-    /**
126
-     * Get number of unread messages from an user
127
-     * @param $friend_id
128
-     * @return int
129
-     */
130
-    public function getInboxFromId($friend_id)
131
-    {
132
-        $sql = "SELECT *
114
+		$result = $this->phpbb_db->sql_query($sql);
115
+		$friend_count = (int)$this->phpbb_db->sql_fetchfield('friend_count');
116
+		$this->phpbb_db->sql_freeresult($result);
117
+
118
+		if ($friend_count > 0) {
119
+			return true;
120
+		} else {
121
+			return false;
122
+		}
123
+	}
124
+
125
+	/**
126
+	 * Get number of unread messages from an user
127
+	 * @param $friend_id
128
+	 * @return int
129
+	 */
130
+	public function getInboxFromId($friend_id)
131
+	{
132
+		$sql = "SELECT *
133 133
 				FROM `messages`
134 134
 				WHERE `sender_id` = :sender_id
135 135
 					AND `receiver_id` = :receiver_id
136 136
 					AND `newMsg` = 1
137 137
 		";
138
-        $results = $this->db->select($sql, array(
139
-            ':sender_id' => (int)$friend_id,
140
-            ':receiver_id' => (int)$this->user->data['user_id']
141
-        ));
142
-
143
-        return count($results);
144
-    }
145
-
146
-    /**
147
-     * Insert a message in database
148
-     * @param array $data Message data
149
-     * @return bool|string
150
-     */
151
-    public function sendMessage($data)
152
-    {
153
-        $insert = array(
154
-            'sender_id' => $data['sender_id'],
155
-            'receiver_id' => $data['receiver_id'],
156
-            'text' => $data['text'],
157
-            'newMsg' => 1,
158
-            'sentAt' => time()
159
-        );
160
-
161
-        if ($this->db->insert('messages', $insert))
162
-            return $this->db->lastInsertId();
163
-        else
164
-            return false;
165
-    }
166
-
167
-    /**
168
-     * Insert a file in database
169
-     * @param $data File data
170
-     * @return bool|string
171
-     */
172
-    public function sendFile($data)
173
-    {
174
-        $insert = array(
175
-            'sender_id' => $data['sender_id'],
176
-            'receiver_id' => $data['receiver_id'],
177
-            'fileName' => $data['fileName'],
178
-            'file' => $data['file'],
179
-            'type' => $data['type'],
180
-            'sentAt' => time()
181
-        );
182
-
183
-        if ($this->db->insert('files', $insert))
184
-            return $this->db->lastInsertId();
185
-        else
186
-            return false;
187
-    }
188
-
189
-    /**
190
-     * Returns a message by a id
191
-     * @param $id Message id
192
-     * @return mixed
193
-     */
194
-    public function getMessageById($id)
195
-    {
196
-        $sql = "
138
+		$results = $this->db->select($sql, array(
139
+			':sender_id' => (int)$friend_id,
140
+			':receiver_id' => (int)$this->user->data['user_id']
141
+		));
142
+
143
+		return count($results);
144
+	}
145
+
146
+	/**
147
+	 * Insert a message in database
148
+	 * @param array $data Message data
149
+	 * @return bool|string
150
+	 */
151
+	public function sendMessage($data)
152
+	{
153
+		$insert = array(
154
+			'sender_id' => $data['sender_id'],
155
+			'receiver_id' => $data['receiver_id'],
156
+			'text' => $data['text'],
157
+			'newMsg' => 1,
158
+			'sentAt' => time()
159
+		);
160
+
161
+		if ($this->db->insert('messages', $insert))
162
+			return $this->db->lastInsertId();
163
+		else
164
+			return false;
165
+	}
166
+
167
+	/**
168
+	 * Insert a file in database
169
+	 * @param $data File data
170
+	 * @return bool|string
171
+	 */
172
+	public function sendFile($data)
173
+	{
174
+		$insert = array(
175
+			'sender_id' => $data['sender_id'],
176
+			'receiver_id' => $data['receiver_id'],
177
+			'fileName' => $data['fileName'],
178
+			'file' => $data['file'],
179
+			'type' => $data['type'],
180
+			'sentAt' => time()
181
+		);
182
+
183
+		if ($this->db->insert('files', $insert))
184
+			return $this->db->lastInsertId();
185
+		else
186
+			return false;
187
+	}
188
+
189
+	/**
190
+	 * Returns a message by a id
191
+	 * @param $id Message id
192
+	 * @return mixed
193
+	 */
194
+	public function getMessageById($id)
195
+	{
196
+		$sql = "
197 197
 			SELECT *
198 198
 			FROM `messages`
199 199
 			WHERE `id` = :id
200 200
 			LIMIT 1
201 201
 		";
202
-        $message = $this->db->select($sql, array(
203
-            ':id' => $id
204
-        ));
205
-
206
-        return $message[0];
207
-    }
208
-
209
-    /**
210
-     * Returns a file by id
211
-     * @param $id File id
212
-     * @return mixed
213
-     */
214
-    public function getFileById($id)
215
-    {
216
-        $sql = "
202
+		$message = $this->db->select($sql, array(
203
+			':id' => $id
204
+		));
205
+
206
+		return $message[0];
207
+	}
208
+
209
+	/**
210
+	 * Returns a file by id
211
+	 * @param $id File id
212
+	 * @return mixed
213
+	 */
214
+	public function getFileById($id)
215
+	{
216
+		$sql = "
217 217
 			SELECT *
218 218
 			FROM `files`
219 219
 			WHERE `id` = :id
220 220
 			LIMIT 1
221 221
 		";
222
-        $file = $this->db->select($sql, array(
223
-            ':id' => $id
224
-        ));
225
-
226
-        return $file[0];
227
-    }
228
-
229
-    /**
230
-     * Get all message from an user
231
-     * @param int $friend_id
232
-     * @return array
233
-     */
234
-    public function getMessages($friend_id)
235
-    {
236
-        // get the sent messages
237
-        $sql = "SELECT *
222
+		$file = $this->db->select($sql, array(
223
+			':id' => $id
224
+		));
225
+
226
+		return $file[0];
227
+	}
228
+
229
+	/**
230
+	 * Get all message from an user
231
+	 * @param int $friend_id
232
+	 * @return array
233
+	 */
234
+	public function getMessages($friend_id)
235
+	{
236
+		// get the sent messages
237
+		$sql = "SELECT *
238 238
 				FROM `messages`
239 239
 				WHERE `sender_id` = :sender_id
240 240
 					AND `receiver_id` = :receiver_id
241 241
 				ORDER BY `sentAt` ASC
242 242
 		";
243
-        $sqlFiles = "SELECT *
243
+		$sqlFiles = "SELECT *
244 244
 			FROM `files`
245 245
 			WHERE `sender_id` = :sender_id
246 246
 				AND `receiver_id` = :receiver_id
247 247
 			ORDER BY `sentAt` ASC
248 248
 		";
249
-        $sentMessages = $this->db->select($sql, array(
250
-            ':sender_id' => $this->user->data['user_id'],
251
-            ':receiver_id' => $friend_id
252
-        ));
253
-        $getInbox = $this->db->select($sql, array(
254
-            ':sender_id' => $friend_id,
255
-            ':receiver_id' => $this->user->data['user_id']
256
-        ));
257
-
258
-        $sentFiles = $this->db->select($sqlFiles, array(
259
-            ':sender_id' => $this->user->data['user_id'],
260
-            ':receiver_id' => $friend_id
261
-        ));
262
-        $getFiles = $this->db->select($sqlFiles, array(
263
-            ':sender_id' => $friend_id,
264
-            ':receiver_id' => $this->user->data['user_id']
265
-        ));
266
-
267
-        $sent = array();
268
-        foreach ($sentMessages as $msg) {
269
-            $item = array();
270
-            $item['id'] = $msg['id'];
271
-            $item['sender_id'] = $msg['sender_id'];
272
-            $item['receiver_id'] = $msg['receiver_id'];
273
-            $item['text'] = $msg['text'];
274
-            $item['sentAt'] = $msg['sentAt'];
275
-            $item['type'] = 'sent';
276
-
277
-            $sent[] = $item;
278
-        }
279
-        $inbox = array();
280
-        foreach ($getInbox as $msg) {
281
-            $item = array();
282
-            $item['id'] = $msg['id'];
283
-            $item['sender_id'] = $msg['sender_id'];
284
-            $item['receiver_id'] = $msg['receiver_id'];
285
-            $item['text'] = $msg['text'];
286
-            $item['sentAt'] = $msg['sentAt'];
287
-            $item['type'] = 'inbox';
288
-
289
-            $inbox[] = $item;
290
-        }
291
-
292
-        foreach ($sentFiles as $file) {
293
-            $item = array();
294
-            $item['id'] = 'f_' . $file['id'];
295
-            $item['sender_id'] = $file['sender_id'];
296
-            $item['receiver_id'] = $file['receiver_id'];
297
-            $item['fileName'] = $file['fileName'];
298
-            $item['file'] = $file['file'];
299
-            $item['sentAt'] = $file['sentAt'];
300
-            $item['type'] = 'sent';
301
-
302
-            $sent[] = $item;
303
-        }
304
-
305
-        foreach ($getFiles as $file) {
306
-            $item = array();
307
-            $item['id'] = 'f_' . $file['id'];
308
-            $item['sender_id'] = $file['sender_id'];
309
-            $item['receiver_id'] = $file['receiver_id'];
310
-            $item['fileName'] = $file['fileName'];
311
-            $item['file'] = $file['file'];
312
-            $item['sentAt'] = $file['sentAt'];
313
-            $item['type'] = 'inbox';
314
-
315
-            $inbox[] = $item;
316
-        }
317
-
318
-        $unsorted_messages = array_merge($sent, $inbox);
319
-
320
-        uasort($unsorted_messages, function ($a, $b) {
321
-            return ($a['sentAt'] > $b['sentAt']) ? -1 : 1;
322
-        });
323
-
324
-        $sorted_messages = array();
325
-        foreach ($unsorted_messages as $msg) {
326
-            $sorted_messages[] = $msg;
327
-        }
328
-
329
-        return $sorted_messages;
330
-    }
331
-
332
-    /**
333
-     * Change messages status to read
334
-     * @param $friend_id
335
-     * @return int
336
-     */
337
-    public function updateMessagesStatus($friend_id)
338
-    {
339
-
340
-        $sql = "
249
+		$sentMessages = $this->db->select($sql, array(
250
+			':sender_id' => $this->user->data['user_id'],
251
+			':receiver_id' => $friend_id
252
+		));
253
+		$getInbox = $this->db->select($sql, array(
254
+			':sender_id' => $friend_id,
255
+			':receiver_id' => $this->user->data['user_id']
256
+		));
257
+
258
+		$sentFiles = $this->db->select($sqlFiles, array(
259
+			':sender_id' => $this->user->data['user_id'],
260
+			':receiver_id' => $friend_id
261
+		));
262
+		$getFiles = $this->db->select($sqlFiles, array(
263
+			':sender_id' => $friend_id,
264
+			':receiver_id' => $this->user->data['user_id']
265
+		));
266
+
267
+		$sent = array();
268
+		foreach ($sentMessages as $msg) {
269
+			$item = array();
270
+			$item['id'] = $msg['id'];
271
+			$item['sender_id'] = $msg['sender_id'];
272
+			$item['receiver_id'] = $msg['receiver_id'];
273
+			$item['text'] = $msg['text'];
274
+			$item['sentAt'] = $msg['sentAt'];
275
+			$item['type'] = 'sent';
276
+
277
+			$sent[] = $item;
278
+		}
279
+		$inbox = array();
280
+		foreach ($getInbox as $msg) {
281
+			$item = array();
282
+			$item['id'] = $msg['id'];
283
+			$item['sender_id'] = $msg['sender_id'];
284
+			$item['receiver_id'] = $msg['receiver_id'];
285
+			$item['text'] = $msg['text'];
286
+			$item['sentAt'] = $msg['sentAt'];
287
+			$item['type'] = 'inbox';
288
+
289
+			$inbox[] = $item;
290
+		}
291
+
292
+		foreach ($sentFiles as $file) {
293
+			$item = array();
294
+			$item['id'] = 'f_' . $file['id'];
295
+			$item['sender_id'] = $file['sender_id'];
296
+			$item['receiver_id'] = $file['receiver_id'];
297
+			$item['fileName'] = $file['fileName'];
298
+			$item['file'] = $file['file'];
299
+			$item['sentAt'] = $file['sentAt'];
300
+			$item['type'] = 'sent';
301
+
302
+			$sent[] = $item;
303
+		}
304
+
305
+		foreach ($getFiles as $file) {
306
+			$item = array();
307
+			$item['id'] = 'f_' . $file['id'];
308
+			$item['sender_id'] = $file['sender_id'];
309
+			$item['receiver_id'] = $file['receiver_id'];
310
+			$item['fileName'] = $file['fileName'];
311
+			$item['file'] = $file['file'];
312
+			$item['sentAt'] = $file['sentAt'];
313
+			$item['type'] = 'inbox';
314
+
315
+			$inbox[] = $item;
316
+		}
317
+
318
+		$unsorted_messages = array_merge($sent, $inbox);
319
+
320
+		uasort($unsorted_messages, function ($a, $b) {
321
+			return ($a['sentAt'] > $b['sentAt']) ? -1 : 1;
322
+		});
323
+
324
+		$sorted_messages = array();
325
+		foreach ($unsorted_messages as $msg) {
326
+			$sorted_messages[] = $msg;
327
+		}
328
+
329
+		return $sorted_messages;
330
+	}
331
+
332
+	/**
333
+	 * Change messages status to read
334
+	 * @param $friend_id
335
+	 * @return int
336
+	 */
337
+	public function updateMessagesStatus($friend_id)
338
+	{
339
+
340
+		$sql = "
341 341
 			UPDATE `messages`
342 342
 			SET `newMsg` = 0
343 343
 			WHERE `newMsg` = 1
@@ -345,12 +345,12 @@  discard block
 block discarded – undo
345 345
 				AND `receiver_id` = :receiver_id
346 346
 		";
347 347
 
348
-        $sth = $this->db->prepare($sql);
349
-        $sth->bindValue(':sender_id', $friend_id);
350
-        $sth->bindValue(':receiver_id', $this->user->data['user_id']);
351
-        $sth->execute();
348
+		$sth = $this->db->prepare($sql);
349
+		$sth->bindValue(':sender_id', $friend_id);
350
+		$sth->bindValue(':receiver_id', $this->user->data['user_id']);
351
+		$sth->execute();
352 352
 
353
-        return $this->getInboxFromId($friend_id);
354
-    }
353
+		return $this->getInboxFromId($friend_id);
354
+	}
355 355
 
356 356
 }
Please login to merge, or discard this patch.
Spacing   +10 added lines, -10 removed lines patch added patch discarded remove patch
@@ -73,10 +73,10 @@  discard block
 block discarded – undo
73 73
                    u.user_colour,
74 74
                    s.session_id,
75 75
                    s.session_time
76
-            FROM " . $this->user_friends_table . "
77
-            LEFT JOIN " . USERS_TABLE . " AS u ON u.user_id = " . $this->user_friends_table . ".friend_id
78
-            LEFT JOIN " . SESSIONS_TABLE . " AS s ON s.session_user_id = u.user_id
79
-            WHERE " . $this->user_friends_table . ".user_id = " . (int)$this->user->data['user_id'] . "
76
+            FROM " . $this->user_friends_table."
77
+            LEFT JOIN " . USERS_TABLE." AS u ON u.user_id = ".$this->user_friends_table.".friend_id
78
+            LEFT JOIN " . SESSIONS_TABLE." AS s ON s.session_user_id = u.user_id
79
+            WHERE " . $this->user_friends_table.".user_id = ".(int)$this->user->data['user_id']."
80 80
             GROUP BY u.user_id
81 81
         ";
82 82
         $result = $this->phpbb_db->sql_query($sql);
@@ -105,9 +105,9 @@  discard block
 block discarded – undo
105 105
     {
106 106
         $sql = "
107 107
 			SELECT COUNT(zebra_id) as friend_count
108
-			FROM " . ZEBRA_TABLE . "
109
-			WHERE user_id = " . (int)$friend_id . "
110
-				AND zebra_id = " . (int)$this->user->data['user_id'] . "
108
+			FROM " . ZEBRA_TABLE."
109
+			WHERE user_id = " . (int)$friend_id."
110
+				AND zebra_id = " . (int)$this->user->data['user_id']."
111 111
 				AND friend = 1
112 112
 				AND foe = 0
113 113
 		";
@@ -291,7 +291,7 @@  discard block
 block discarded – undo
291 291
 
292 292
         foreach ($sentFiles as $file) {
293 293
             $item = array();
294
-            $item['id'] = 'f_' . $file['id'];
294
+            $item['id'] = 'f_'.$file['id'];
295 295
             $item['sender_id'] = $file['sender_id'];
296 296
             $item['receiver_id'] = $file['receiver_id'];
297 297
             $item['fileName'] = $file['fileName'];
@@ -304,7 +304,7 @@  discard block
 block discarded – undo
304 304
 
305 305
         foreach ($getFiles as $file) {
306 306
             $item = array();
307
-            $item['id'] = 'f_' . $file['id'];
307
+            $item['id'] = 'f_'.$file['id'];
308 308
             $item['sender_id'] = $file['sender_id'];
309 309
             $item['receiver_id'] = $file['receiver_id'];
310 310
             $item['fileName'] = $file['fileName'];
@@ -317,7 +317,7 @@  discard block
 block discarded – undo
317 317
 
318 318
         $unsorted_messages = array_merge($sent, $inbox);
319 319
 
320
-        uasort($unsorted_messages, function ($a, $b) {
320
+        uasort($unsorted_messages, function($a, $b) {
321 321
             return ($a['sentAt'] > $b['sentAt']) ? -1 : 1;
322 322
         });
323 323
 
Please login to merge, or discard this patch.
Braces   +10 added lines, -8 removed lines patch added patch discarded remove patch
@@ -158,10 +158,11 @@  discard block
 block discarded – undo
158 158
             'sentAt' => time()
159 159
         );
160 160
 
161
-        if ($this->db->insert('messages', $insert))
162
-            return $this->db->lastInsertId();
163
-        else
164
-            return false;
161
+        if ($this->db->insert('messages', $insert)) {
162
+                    return $this->db->lastInsertId();
163
+        } else {
164
+                    return false;
165
+        }
165 166
     }
166 167
 
167 168
     /**
@@ -180,10 +181,11 @@  discard block
 block discarded – undo
180 181
             'sentAt' => time()
181 182
         );
182 183
 
183
-        if ($this->db->insert('files', $insert))
184
-            return $this->db->lastInsertId();
185
-        else
186
-            return false;
184
+        if ($this->db->insert('files', $insert)) {
185
+                    return $this->db->lastInsertId();
186
+        } else {
187
+                    return false;
188
+        }
187 189
     }
188 190
 
189 191
     /**
Please login to merge, or discard this patch.
models/friends_model.php 2 patches
Indentation   +135 added lines, -135 removed lines patch added patch discarded remove patch
@@ -8,30 +8,30 @@  discard block
 block discarded – undo
8 8
 
9 9
 class friends_model
10 10
 {
11
-    protected $config;
12
-    protected $db;
13
-    protected $user;
14
-    protected $friends_request_table;
15
-    protected $user_friends_table;
16
-
17
-    public function __construct(
18
-        config $config,
19
-        driver_interface $db,
20
-        user $user,
21
-        $friends_request_table,
22
-        $user_friends_table
23
-    )
24
-    {
25
-        $this->config = $config;
26
-        $this->db = $db;
27
-        $this->user = $user;
28
-        $this->friends_request_table = $friends_request_table;
29
-        $this->user_friends_table = $user_friends_table;
30
-    }
31
-
32
-    public function getFriends()
33
-    {
34
-        $sql = "
11
+	protected $config;
12
+	protected $db;
13
+	protected $user;
14
+	protected $friends_request_table;
15
+	protected $user_friends_table;
16
+
17
+	public function __construct(
18
+		config $config,
19
+		driver_interface $db,
20
+		user $user,
21
+		$friends_request_table,
22
+		$user_friends_table
23
+	)
24
+	{
25
+		$this->config = $config;
26
+		$this->db = $db;
27
+		$this->user = $user;
28
+		$this->friends_request_table = $friends_request_table;
29
+		$this->user_friends_table = $user_friends_table;
30
+	}
31
+
32
+	public function getFriends()
33
+	{
34
+		$sql = "
35 35
             SELECT u.user_id, 
36 36
                    u.username, 
37 37
                    u.username_clean, 
@@ -45,28 +45,28 @@  discard block
 block discarded – undo
45 45
             WHERE " . $this->user_friends_table . ".user_id = " . (int)$this->user->data['user_id'] . "
46 46
             GROUP BY u.user_id
47 47
         ";
48
-        $result = $this->db->sql_query($sql);
48
+		$result = $this->db->sql_query($sql);
49 49
 
50
-        $friends = array();
51
-        while ($row = $this->db->sql_fetchrow($result)) {
52
-            $friends[] = array(
53
-                'user_id' => $row['user_id'],
54
-                'username' => $row['username_clean'],
55
-                'user_colour' => $row['user_colour'],
56
-                'user_status' => ($row['session_time'] >= (time() - ($this->config['load_online_time'] * 60))) ? 1 : 0,
57
-            );
58
-        }
59
-        $this->db->sql_freeresult();
50
+		$friends = array();
51
+		while ($row = $this->db->sql_fetchrow($result)) {
52
+			$friends[] = array(
53
+				'user_id' => $row['user_id'],
54
+				'username' => $row['username_clean'],
55
+				'user_colour' => $row['user_colour'],
56
+				'user_status' => ($row['session_time'] >= (time() - ($this->config['load_online_time'] * 60))) ? 1 : 0,
57
+			);
58
+		}
59
+		$this->db->sql_freeresult();
60 60
 
61
-        return $friends;
62
-    }
61
+		return $friends;
62
+	}
63 63
 
64
-    public function get_friends_requests()
65
-    {
64
+	public function get_friends_requests()
65
+	{
66 66
 
67
-        $requests = array();
67
+		$requests = array();
68 68
 
69
-        $sql = "
69
+		$sql = "
70 70
 			SELECT `request_id`,
71 71
 					`user_id`,
72 72
 					`sender_id`,
@@ -78,18 +78,18 @@  discard block
 block discarded – undo
78 78
 			ORDER BY `time` DESC
79 79
 		";
80 80
 
81
-        $result = $this->db->sql_query($sql);
81
+		$result = $this->db->sql_query($sql);
82 82
 
83
-        while ($row = $this->db->sql_fetchrow($result)) {
84
-            $requests[] = $row;
85
-        }
83
+		while ($row = $this->db->sql_fetchrow($result)) {
84
+			$requests[] = $row;
85
+		}
86 86
 
87
-        return $requests;
88
-    }
87
+		return $requests;
88
+	}
89 89
 
90
-    public function get_friend_request($id)
91
-    {
92
-        $sql = "
90
+	public function get_friend_request($id)
91
+	{
92
+		$sql = "
93 93
 			SELECT `request_id`,
94 94
 					`user_id`,
95 95
 					`sender_id`,
@@ -101,19 +101,19 @@  discard block
 block discarded – undo
101 101
 			ORDER BY `time` DESC
102 102
 			LIMIT 1
103 103
 		";
104
-        $result = $this->db->sql_query($sql);
105
-        $row = $this->db->sql_fetchrow($result);
106
-
107
-        if ($this->approve_friend_request($id)) {
108
-            return $row;
109
-        } else {
110
-            return false;
111
-        }
112
-    }
113
-
114
-    public function get_request_by_sender_id($sender_id)
115
-    {
116
-        $sql = "
104
+		$result = $this->db->sql_query($sql);
105
+		$row = $this->db->sql_fetchrow($result);
106
+
107
+		if ($this->approve_friend_request($id)) {
108
+			return $row;
109
+		} else {
110
+			return false;
111
+		}
112
+	}
113
+
114
+	public function get_request_by_sender_id($sender_id)
115
+	{
116
+		$sql = "
117 117
             SELECT `request_id`,
118 118
 					`user_id`,
119 119
 					`sender_id`,
@@ -125,15 +125,15 @@  discard block
 block discarded – undo
125 125
 			ORDER BY `time` DESC
126 126
 			LIMIT 1 
127 127
         ";
128
-        $result = $this->db->sql_query($sql);
129
-        $row = $this->db->sql_fetchrow($result);
128
+		$result = $this->db->sql_query($sql);
129
+		$row = $this->db->sql_fetchrow($result);
130 130
 
131
-        return $row;
132
-    }
131
+		return $row;
132
+	}
133 133
 
134
-    public function insert_friends_request(array $data)
135
-    {
136
-        $sql = "
134
+	public function insert_friends_request(array $data)
135
+	{
136
+		$sql = "
137 137
       INSERT INTO " . $this->friends_request_table . "
138 138
         (
139 139
           `user_id`,
@@ -149,35 +149,35 @@  discard block
 block discarded – undo
149 149
           " . time() . "
150 150
         )
151 151
     ";
152
-        $this->db->sql_query($sql);
152
+		$this->db->sql_query($sql);
153 153
 
154
-        return $this->db->sql_nextid();
155
-    }
154
+		return $this->db->sql_nextid();
155
+	}
156 156
 
157
-    public function delete_friend_request($request_id)
158
-    {
159
-        $sql = "
157
+	public function delete_friend_request($request_id)
158
+	{
159
+		$sql = "
160 160
 			DELETE FROM " . $this->friends_request_table . " WHERE `request_id` = " . (int)$request_id . "
161 161
 		";
162 162
 
163
-        return $this->db->sql_query($sql);
164
-    }
163
+		return $this->db->sql_query($sql);
164
+	}
165 165
 
166
-    public function approve_friend_request($request_id)
167
-    {
168
-        $sql = "
166
+	public function approve_friend_request($request_id)
167
+	{
168
+		$sql = "
169 169
 			UPDATE " . $this->friends_request_table . " SET `status` = 1 WHERE `request_id` = " . (int)$request_id . "
170 170
 		";
171 171
 
172
-        return $this->db->sql_query($sql);
173
-    }
172
+		return $this->db->sql_query($sql);
173
+	}
174 174
 
175
-    public function add_friend($data)
176
-    {
175
+	public function add_friend($data)
176
+	{
177 177
 
178
-        $check_friend = $this->check_friend($data);
179
-        if ($check_friend == false) {
180
-            $sql = "
178
+		$check_friend = $this->check_friend($data);
179
+		if ($check_friend == false) {
180
+			$sql = "
181 181
 				INSERT INTO " . $this->user_friends_table . "
182 182
 					(
183 183
 						`user_id`,
@@ -189,41 +189,41 @@  discard block
 block discarded – undo
189 189
 						" . (int)$data['friend_id'] . "
190 190
 					)
191 191
 			";
192
-            if ($this->db->sql_query($sql)) {
193
-                $aux = $data['user_id'];
194
-                $data['user_id'] = $data['friend_id'];
195
-                $data['friend_id'] = $aux;
196
-
197
-                self::add_friend($data);
198
-            } else {
199
-                return false;
200
-            }
201
-        } else {
202
-            return false;
203
-        }
204
-
205
-    }
206
-
207
-    public function check_friend($data)
208
-    {
209
-        $sql = "
192
+			if ($this->db->sql_query($sql)) {
193
+				$aux = $data['user_id'];
194
+				$data['user_id'] = $data['friend_id'];
195
+				$data['friend_id'] = $aux;
196
+
197
+				self::add_friend($data);
198
+			} else {
199
+				return false;
200
+			}
201
+		} else {
202
+			return false;
203
+		}
204
+
205
+	}
206
+
207
+	public function check_friend($data)
208
+	{
209
+		$sql = "
210 210
 			SELECT COUNT(*) AS `count`
211 211
 			FROM " . $this->user_friends_table . "
212 212
 			WHERE `user_id` = " . (int)$data['user_id'] . "
213 213
 			 		AND `friend_id` = " . (int)$data['friend_id'] . "
214 214
 		";
215
-        $this->db->sql_query($sql);
216
-        $count = $this->db->sql_fetchfield('count');
217
-        if ($count > 0) {
218
-            return true;
219
-        } else {
220
-            return false;
221
-        }
222
-    }
223
-
224
-    public function check_request($data)
225
-    {
226
-        $sql = "
215
+		$this->db->sql_query($sql);
216
+		$count = $this->db->sql_fetchfield('count');
217
+		if ($count > 0) {
218
+			return true;
219
+		} else {
220
+			return false;
221
+		}
222
+	}
223
+
224
+	public function check_request($data)
225
+	{
226
+		$sql = "
227 227
 			SELECT COUNT(*) AS `count`
228 228
 			FROM " . $this->friends_request_table . "
229 229
 			WHERE `user_id` = " . (int)$data['user_id'] . "
@@ -231,22 +231,22 @@  discard block
 block discarded – undo
231 231
 					AND `status` = 0
232 232
 			LIMIT 1
233 233
 		";
234
-        $this->db->sql_query($sql);
235
-        $count = $this->db->sql_fetchfield('count');
236
-        if ($count > 0) {
237
-            return true;
238
-        } else {
239
-            return false;
240
-        }
241
-    }
242
-
243
-    public function remove_friend($user_id)
244
-    {
245
-        $sql = "DELETE FROM " . $this->user_friends_table . " WHERE `user_id` = " . (int)$user_id . "";
246
-        $this->db->sql_query($sql);
247
-
248
-        $sql = "DELETE FROM " . $this->user_friends_table . " WHERE `friend_id` = " . (int)$user_id . "";
249
-        $this->db->sql_query($sql);
250
-    }
234
+		$this->db->sql_query($sql);
235
+		$count = $this->db->sql_fetchfield('count');
236
+		if ($count > 0) {
237
+			return true;
238
+		} else {
239
+			return false;
240
+		}
241
+	}
242
+
243
+	public function remove_friend($user_id)
244
+	{
245
+		$sql = "DELETE FROM " . $this->user_friends_table . " WHERE `user_id` = " . (int)$user_id . "";
246
+		$this->db->sql_query($sql);
247
+
248
+		$sql = "DELETE FROM " . $this->user_friends_table . " WHERE `friend_id` = " . (int)$user_id . "";
249
+		$this->db->sql_query($sql);
250
+	}
251 251
 
252 252
 }
Please login to merge, or discard this patch.
Spacing   +27 added lines, -27 removed lines patch added patch discarded remove patch
@@ -39,10 +39,10 @@  discard block
 block discarded – undo
39 39
                    u.user_colour, 
40 40
                    s.session_id, 
41 41
                    s.session_time
42
-            FROM " . $this->user_friends_table . "
43
-            LEFT JOIN " . USERS_TABLE . " AS u ON u.user_id = " . $this->user_friends_table . ".friend_id
44
-            LEFT JOIN " . SESSIONS_TABLE . " AS s ON s.session_user_id = u.user_id
45
-            WHERE " . $this->user_friends_table . ".user_id = " . (int)$this->user->data['user_id'] . "
42
+            FROM " . $this->user_friends_table."
43
+            LEFT JOIN " . USERS_TABLE." AS u ON u.user_id = ".$this->user_friends_table.".friend_id
44
+            LEFT JOIN " . SESSIONS_TABLE." AS s ON s.session_user_id = u.user_id
45
+            WHERE " . $this->user_friends_table.".user_id = ".(int)$this->user->data['user_id']."
46 46
             GROUP BY u.user_id
47 47
         ";
48 48
         $result = $this->db->sql_query($sql);
@@ -72,8 +72,8 @@  discard block
 block discarded – undo
72 72
 					`sender_id`,
73 73
 					`status`,
74 74
 					`time`
75
-			FROM " . $this->friends_request_table . "
76
-			WHERE `user_id` = " . (int)$this->user->data['user_id'] . "
75
+			FROM " . $this->friends_request_table."
76
+			WHERE `user_id` = " . (int)$this->user->data['user_id']."
77 77
                     AND `status` = 0
78 78
 			ORDER BY `time` DESC
79 79
 		";
@@ -95,8 +95,8 @@  discard block
 block discarded – undo
95 95
 					`sender_id`,
96 96
 					`status`,
97 97
 					`time`
98
-			FROM " . $this->friends_request_table . "
99
-			WHERE `request_id` = " . (int)$id . "
98
+			FROM " . $this->friends_request_table."
99
+			WHERE `request_id` = " . (int)$id."
100 100
                 AND `status` = 0
101 101
 			ORDER BY `time` DESC
102 102
 			LIMIT 1
@@ -119,8 +119,8 @@  discard block
 block discarded – undo
119 119
 					`sender_id`,
120 120
 					`status`,
121 121
 					`time`
122
-			FROM " . $this->friends_request_table . "
123
-			WHERE `sender_id` = " . (int)$sender_id . "
122
+			FROM " . $this->friends_request_table."
123
+			WHERE `sender_id` = " . (int)$sender_id."
124 124
                 AND `status` = 0
125 125
 			ORDER BY `time` DESC
126 126
 			LIMIT 1 
@@ -134,7 +134,7 @@  discard block
 block discarded – undo
134 134
     public function insert_friends_request(array $data)
135 135
     {
136 136
         $sql = "
137
-      INSERT INTO " . $this->friends_request_table . "
137
+      INSERT INTO " . $this->friends_request_table."
138 138
         (
139 139
           `user_id`,
140 140
           `sender_id`,
@@ -143,10 +143,10 @@  discard block
 block discarded – undo
143 143
         )
144 144
       VALUES
145 145
         (
146
-          " . ( int )$data ['user_id'] . ",
147
-          " . ( int )$data ['sender_id'] . ",
146
+          " . (int)$data ['user_id'].",
147
+          " . (int)$data ['sender_id'].",
148 148
           0,
149
-          " . time() . "
149
+          " . time()."
150 150
         )
151 151
     ";
152 152
         $this->db->sql_query($sql);
@@ -157,7 +157,7 @@  discard block
 block discarded – undo
157 157
     public function delete_friend_request($request_id)
158 158
     {
159 159
         $sql = "
160
-			DELETE FROM " . $this->friends_request_table . " WHERE `request_id` = " . (int)$request_id . "
160
+			DELETE FROM " . $this->friends_request_table." WHERE `request_id` = ".(int)$request_id."
161 161
 		";
162 162
 
163 163
         return $this->db->sql_query($sql);
@@ -166,7 +166,7 @@  discard block
 block discarded – undo
166 166
     public function approve_friend_request($request_id)
167 167
     {
168 168
         $sql = "
169
-			UPDATE " . $this->friends_request_table . " SET `status` = 1 WHERE `request_id` = " . (int)$request_id . "
169
+			UPDATE " . $this->friends_request_table." SET `status` = 1 WHERE `request_id` = ".(int)$request_id."
170 170
 		";
171 171
 
172 172
         return $this->db->sql_query($sql);
@@ -178,15 +178,15 @@  discard block
 block discarded – undo
178 178
         $check_friend = $this->check_friend($data);
179 179
         if ($check_friend == false) {
180 180
             $sql = "
181
-				INSERT INTO " . $this->user_friends_table . "
181
+				INSERT INTO " . $this->user_friends_table."
182 182
 					(
183 183
 						`user_id`,
184 184
 						`friend_id`
185 185
 					)
186 186
 				VALUES
187 187
 					(
188
-						" . (int)$data['user_id'] . ",
189
-						" . (int)$data['friend_id'] . "
188
+						" . (int)$data['user_id'].",
189
+						" . (int)$data['friend_id']."
190 190
 					)
191 191
 			";
192 192
             if ($this->db->sql_query($sql)) {
@@ -208,9 +208,9 @@  discard block
 block discarded – undo
208 208
     {
209 209
         $sql = "
210 210
 			SELECT COUNT(*) AS `count`
211
-			FROM " . $this->user_friends_table . "
212
-			WHERE `user_id` = " . (int)$data['user_id'] . "
213
-			 		AND `friend_id` = " . (int)$data['friend_id'] . "
211
+			FROM " . $this->user_friends_table."
212
+			WHERE `user_id` = " . (int)$data['user_id']."
213
+			 		AND `friend_id` = " . (int)$data['friend_id']."
214 214
 		";
215 215
         $this->db->sql_query($sql);
216 216
         $count = $this->db->sql_fetchfield('count');
@@ -225,9 +225,9 @@  discard block
 block discarded – undo
225 225
     {
226 226
         $sql = "
227 227
 			SELECT COUNT(*) AS `count`
228
-			FROM " . $this->friends_request_table . "
229
-			WHERE `user_id` = " . (int)$data['user_id'] . "
230
-					AND `sender_id` = " . (int)$data['sender_id'] . "
228
+			FROM " . $this->friends_request_table."
229
+			WHERE `user_id` = " . (int)$data['user_id']."
230
+					AND `sender_id` = " . (int)$data['sender_id']."
231 231
 					AND `status` = 0
232 232
 			LIMIT 1
233 233
 		";
@@ -242,10 +242,10 @@  discard block
 block discarded – undo
242 242
 
243 243
     public function remove_friend($user_id)
244 244
     {
245
-        $sql = "DELETE FROM " . $this->user_friends_table . " WHERE `user_id` = " . (int)$user_id . "";
245
+        $sql = "DELETE FROM ".$this->user_friends_table." WHERE `user_id` = ".(int)$user_id."";
246 246
         $this->db->sql_query($sql);
247 247
 
248
-        $sql = "DELETE FROM " . $this->user_friends_table . " WHERE `friend_id` = " . (int)$user_id . "";
248
+        $sql = "DELETE FROM ".$this->user_friends_table." WHERE `friend_id` = ".(int)$user_id."";
249 249
         $this->db->sql_query($sql);
250 250
     }
251 251
 
Please login to merge, or discard this patch.