blob: 640cb08503d06ae84d5318cf8f5f3753019a4e25 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
|
<?php
use Engelsystem\Database\DB;
use Engelsystem\Models\User\User;
/**
* Returns Message id array
*
* @return array
*/
function Message_ids()
{
return DB::select('SELECT `id` FROM `Messages`');
}
/**
* Returns message by id.
*
* @param int $message_id message ID
* @return array|null
*/
function Message($message_id)
{
$message = DB::selectOne('SELECT * FROM `Messages` WHERE `id`=? LIMIT 1', [$message_id]);
return empty($message) ? null : $message;
}
/**
* send message
*
* @param int $receiver_user_id User ID of Receiver
* @param string $text Text of Message
* @return bool
*/
function Message_send($receiver_user_id, $text)
{
$user = auth()->user();
$receiver = User::find($receiver_user_id);
if (empty($text) || !$receiver || $receiver->id == $user->id) {
return false;
}
return DB::insert('
INSERT INTO `Messages` (`Datum`, `SUID`, `RUID`, `Text`)
VALUES(?, ?, ?, ?)
',
[
time(),
$user->id,
$receiver->id,
$text
]
);
}
|
