function __construct($id, $since)
{
$this->user = intval($id);
global $con;
// shared lists
$sql = "\n SELECT `share`.`id`, `share`.`list`, `share`.`permissions`, `list`.`creator`, `share`.`time`\n FROM `share`, `list` \n WHERE `list`.`id` = `share`.`list` AND `share`.`user` = " . $id . " AND `share`.`permissions` <> 0 AND `share`.`time` >= " . $since . "\n ORDER BY `share`.`time` DESC;";
$query = mysqli_query($con, $sql);
while ($row = mysqli_fetch_assoc($query)) {
array_push($this->events, new FeedItem(FeedItemType::ListShared, intval($row['time']), new SharingInformation($row['id'], SimpleUser::get_by_id($row['creator']), $row['list'], $row['permissions'])));
}
// another user has added a word to a list which is shared with you
$sql = "\n SELECT `list`.`creator`, `word`.`user`, COUNT(`word`.`id`) AS 'amount', MIN(`word`.`time`) AS 'time', `list`.`id`\n FROM `list`, `share`, `word` \n WHERE `share`.`user` = " . $id . " AND `word`.`user` <> " . $id . " AND \n `word`.`list` = `list`.`id` AND `share`.`list` = `list`.`id` AND\n `list`.`active` <> 0 AND `share`.`permissions` <> 0 AND `word`.`status` <> 0 AND\n `word`.`time` > " . $since . "\n GROUP BY `word`.`list`, `word`.`user`\n ORDER BY `word`.`time` ASC;\n ";
$query = mysqli_query($con, $sql);
while ($row = mysqli_fetch_assoc($query)) {
if ($row['user'] == 0) {
continue;
}
array_push($this->events, new FeedItem(FeedItemType::WordAdded, intval($row['time']), new WordsAddedFeedItem($row['amount'], BasicWordList::get_by_id($row['id']), SimpleUser::get_by_id($row['creator']), SimpleUser::get_by_id($row['user']))));
}
// another user has added a word to your word list
$sql = "\n SELECT `list`.`creator`, `word`.`user`, COUNT(`word`.`id`) AS 'amount', MIN(`word`.`time`) AS 'time', `list`.`id`\n FROM `list`, `word` \n WHERE `word`.`list` = `list`.`id` AND `word`.`user` <> " . $id . " AND `list`.`creator` = " . $id . " AND\n `list`.`active` <> 0 AND `word`.`status` <> 0 AND\n `word`.`time` > " . $since . "\n GROUP BY `word`.`list`, `word`.`user`\n ORDER BY `word`.`time` ASC;\n ";
$query = mysqli_query($con, $sql);
while ($row = mysqli_fetch_assoc($query)) {
if (intval($row['user']) === 0) {
continue;
}
array_push($this->events, new FeedItem(FeedItemType::WordAdded, intval($row['time']), new WordsAddedFeedItem($row['amount'], BasicWordList::get_by_id($row['id']), SimpleUser::get_by_id($row['creator']), SimpleUser::get_by_id($row['user']))));
}
// users added
$sql = "\n SELECT `user1`, `time`\n FROM `relationship` \n WHERE `type` <> 0 AND `user2` = " . $id . " AND `time` >= " . $since . "\n ORDER BY `time` DESC;";
$query = mysqli_query($con, $sql);
while ($row = mysqli_fetch_assoc($query)) {
array_push($this->events, new FeedItem(FeedItemType::UserAdded, intval($row['time']), SimpleUser::get_by_id($row['user1'])));
}
}
public function __construct($id, SimpleUser $user, $list, $permissions)
{
$this->id = intval($id);
$this->user = $user;
$this->permissions = intval($permissions);
$this->list = BasicWordList::get_by_id($list);
}
