<?php
-
/**
* Name: public_server
- * Description: Friendica plugin/addon with functions suitable for a public server.
- * Version: 1.0
+ * Description: Friendica addon with functions suitable for a public server. WARNING: This addon is currently not well maintained. It may produce unexpected results. Use with caution!
+ * Version: 1.1
* Author: Keith Fernie <http://friendika.me4.it/profile/keith>
*/
-
-
-
-function public_server_install() {
-
- register_hook('register_account', 'addon/public_server/public_server.php', 'public_server_register_account');
- register_hook('cron', 'addon/public_server/public_server.php', 'public_server_cron');
- register_hook('enotify','addon/public_server/public_server.php', 'public_server_enotify');
- register_hook('logged_in', 'addon/public_server/public_server.php', 'public_server_login');
+use Friendica\App;
+use Friendica\BaseModule;
+use Friendica\Core\Hook;
+use Friendica\Core\Logger;
+use Friendica\Core\Renderer;
+use Friendica\Database\DBA;
+use Friendica\DI;
+use Friendica\Model\Notification;
+use Friendica\Model\User;
+use Friendica\Core\Config\Util\ConfigFileLoader;
+use Friendica\Util\DateTimeFormat;
+
+function public_server_install()
+{
+ Hook::register('load_config', 'addon/public_server/public_server.php', 'public_server_load_config');
+ Hook::register('register_account', 'addon/public_server/public_server.php', 'public_server_register_account');
+ Hook::register('cron', 'addon/public_server/public_server.php', 'public_server_cron');
+ Hook::register('enotify', 'addon/public_server/public_server.php', 'public_server_enotify');
+ Hook::register('logged_in', 'addon/public_server/public_server.php', 'public_server_login');
}
-
-function public_server_uninstall() {
-
- unregister_hook('register_account', 'addon/public_server/public_server.php', 'public_server_register_account');
- unregister_hook('cron', 'addon/public_server/public_server.php', 'public_server_cron');
- unregister_hook('enotify','addon/public_server/public_server.php', 'public_server_enotify');
- unregister_hook('logged_in', 'addon/public_server/public_server.php', 'public_server_login');
+function public_server_load_config(App $a, ConfigFileLoader $loader)
+{
+ $a->getConfigCache()->load($loader->loadAddonConfig('public_server'));
}
-function public_server_register_account($a,$b) {
-
+function public_server_register_account(App $a, $b)
+{
$uid = $b;
- $days = get_config('public_server','expiredays');
- $days_posts = get_config('public_server','expireposts');
- if(! $days)
+ $days = DI::config()->get('public_server', 'expiredays');
+ $days_posts = DI::config()->get('public_server', 'expireposts');
+ if (!$days) {
return;
-
- $r = q("UPDATE user set account_expires_on = '%s', expire = %d where uid = %d limit 1",
- dbesc(datetime_convert('UTC','UTC','now +' . $days . ' days')),
- intval($days_posts),
- intval($uid)
- );
-
-};
-
-
-function public_server_cron($a,$b) {
- require_once('include/enotify.php');
- $r = q("select * from user where account_expires_on < UTC_TIMESTAMP() + INTERVAL 5 DAY and account_expires_on > '0000-00-00 00:00:00' and
- expire_notification_sent = '0000-00-00 00:00:00' ");
-
- if(count($r)) {
- foreach($r as $rr) {
- notification(array(
- 'uid' => $rr['uid'],
- 'type' => NOTIFY_SYSTEM,
- 'system_type' => 'public_server_expire',
- 'language' => $rr['language'],
- 'to_name' => $rr['username'],
- 'to_email' => $rr['email'],
- 'source_name' => t('Administrator'),
- 'source_link' => $a->get_baseurl(),
- 'source_photo' => $a->get_baseurl() . '/images/person-80.jpg',
- ));
-
- q("update user set expire_notification_sent = '%s' where uid = %d limit 1",
- dbesc(datetime_convert()),
- intval($rr['uid'])
- );
- }
}
- $r = q("select * from user where account_expired = 1 and account_expires_on < UTC_TIMESTAMP() - INTERVAL 5 DAY and account_expires_on > '0000-00-00 00:00:00'");
- if(count($r)) {
- require_once('include/Contact.php');
- foreach($r as $rr)
- user_remove($rr['uid']);
+ $fields = ['account_expires_on' => DateTimeFormat::utc('now +' . $days . ' days'), 'expire' => $days_posts];
+ DBA::update('user', $fields, ['uid' => $uid]);
+}
+function public_server_cron(App $a, $b)
+{
+ Logger::notice("public_server: cron start");
+
+ $users = DBA::selectToArray('user', [], ["`account_expires_on` > ? AND `account_expires_on` < ?
+ AND `expire_notification_sent` <= ?", DBA::NULL_DATETIME, DateTimeFormat::utc('now + 5 days'), DBA::NULL_DATETIME]);
+ foreach ($users as $rr) {
+ DI::notify()->createFromArray([
+ 'type' => Notification\Type::SYSTEM,
+ 'uid' => $rr['uid'],
+ 'system_type' => 'public_server_expire',
+ 'source_name' => DI::l10n()->t('Administrator'),
+ 'source_link' => DI::baseUrl()->get(),
+ 'source_photo' => DI::baseUrl()->get() . '/images/person-80.jpg',
+ ]);
+
+ $fields = ['expire_notification_sent' => DateTimeFormat::utcNow()];
+ DBA::update('user', $fields, ['uid' => $rr['uid']]);
}
- $nologin = get_config('public_server','nologin');
- if($nologin) {
- $r = q("select uid from user where account_expired = 0 and login_date = '0000-00-00 00:00:00' and register_date < UTC_TIMESTAMP() - INTERVAL %d DAY and account_expires_on = '0000-00-00 00:00:00'",intval($nologin));
- if(count($r)) {
- foreach($r as $rr)
- q("update user set account_expires_on = '%s' where uid = %d limit 1",
- dbesc(datetime_convert('UTC','UTC','now +' . '6 days')),
- intval($rr['uid'])
- );
+
+ $nologin = DI::config()->get('public_server', 'nologin', false);
+ if ($nologin) {
+ $users = DBA::selectToArray('user', [], ["NOT `account_expired` AND `login_date` <= ? AND `register_date` < ? AND `account_expires_on` <= ?",
+ DBA::NULL_DATETIME, DateTimeFormat::utc('now - ' . (int)$nologin . ' days'), DBA::NULL_DATETIME]);
+ foreach ($users as $rr) {
+ $fields = ['account_expires_on' => DateTimeFormat::utc('now +6 days')];
+ DBA::update('user', $fields, ['uid' => $rr['uid']]);
}
- }
-
-
- $flagusers = get_config('public_server','flagusers');
- if($flagusers) {
- $r = q("select uid from user where account_expired = 0 and login_date < UTC_TIMESTAMP() - INTERVAL %d DAY and account_expires_on = '0000-00-00 00:00:00' and `page-flags` = 0",intval($flagusers));
- if(count($r)) {
- foreach($r as $rr)
- q("update user set account_expires_on = '%s' where uid = %d limit 1",
- dbesc(datetime_convert('UTC','UTC','now +' . '6 days')),
- intval($rr['uid'])
- );
+ }
+
+ $flagusers = DI::config()->get('public_server', 'flagusers', false);
+ if ($flagusers) {
+ $users = DBA::selectToArray('user', [], ["NOT `account_expired` AND `login_date` < ? AND `account_expires_on` <= ? AND `page-flags` = ?",
+ DateTimeFormat::utc('now - ' . (int)$flagusers . ' days'), DBA::NULL_DATETIME, User::PAGE_FLAGS_NORMAL]);
+ foreach ($users as $rr) {
+ $fields = ['account_expires_on' => DateTimeFormat::utc('now +6 days')];
+ DBA::update('user', $fields, ['uid' => $rr['uid']]);
}
- }
+ }
- $flagposts = get_config('public_server','flagposts');
- $flagpostsexpire = get_config('public_server','flagpostsexpire');
+ $flagposts = DI::config()->get('public_server', 'flagposts');
+ $flagpostsexpire = DI::config()->get('public_server', 'flagpostsexpire');
if ($flagposts && $flagpostsexpire) {
- $r = q("select uid from user where account_expired = 0 and login_date < UTC_TIMESTAMP() - INTERVAL %d DAY and account_expires_on = '0000-00-00 00:00:00' and expire = 0 and 'page-flags' = 0",intval(flagposts));
- if(count($r)) {
- foreach($r as $rr)
- q("update user set expire = %d where uid = %d limit 1",
- intval($flagpostsexpire),
- intval($rr['uid'])
- );
+ $users = DBA::selectToArray('user', [], ["NOT `account_expired` AND `login_date` < ? AND `account_expires_on` <= ? AND NOT `expire` AND `page-flags` = ?",
+ DateTimeFormat::utc('now - ' . (int)$flagposts . ' days'), DBA::NULL_DATETIME, User::PAGE_FLAGS_NORMAL]);
+ foreach ($users as $rr) {
+ DBA::update('user', ['expire' => $flagpostsexpire], ['uid' => $rr['uid']]);
}
- }
-
+ }
+ Logger::notice("public_server: cron end");
}
-function public_server_enotify(&$a, &$b) {
- if (x($b, 'params') && $b['params']['type'] == NOTIFY_SYSTEM
- && x($b['params'], 'system_type') && $b['params']['system_type'] === 'public_server_expire') {
- $b['itemlink'] = $a->get_baseurl();
- $b['epreamble'] = $b['preamble'] = sprintf( t('Your account on %s will expire in a few days.'), get_config('system','sitename'));
- $b['subject'] = t('Your Friendica account is about to expire.');
- $b['body'] = sprintf( t("Hi %1\$s,\n\nYour account on %2\$s will expire in less than five days. You may keep your account by logging in at least once every 30 days"), $b['params']['to_name'], "[url=" . $app->config["system"]["url"] . "]" . $app->config["sitename"] . "[/url]");
- }
+function public_server_enotify(App $a, array &$b)
+{
+ if (!empty($b['params']) && $b['params']['type'] == Notification\Type::SYSTEM
+ && !empty($b['params']['system_type']) && $b['params']['system_type'] === 'public_server_expire') {
+ $b['itemlink'] = DI::baseUrl()->get();
+ $b['epreamble'] = $b['preamble'] = DI::l10n()->t('Your account on %s will expire in a few days.', DI::config()->get('system', 'sitename'));
+ $b['subject'] = DI::l10n()->t('Your Friendica account is about to expire.');
+ $b['body'] = DI::l10n()->t("Hi %1\$s,\n\nYour account on %2\$s will expire in less than five days. You may keep your account by logging in at least once every 30 days", $b['params']['to_name'], "[url=" . DI::config()->get('system', 'url') . "]" . DI::config()->get('config', 'sitename') . "[/url]");
+ }
}
-function public_server_login($a,$b) {
- $days = get_config('public_server','expiredays');
- if(! $days)
+function public_server_login(App $a, $b)
+{
+ $days = DI::config()->get('public_server', 'expiredays');
+ if (!$days) {
return;
- $r = q("UPDATE user set account_expires_on = '%s' where uid = %d and account_expires_on > '0000-00-00 00:00:00' limit 1",
- dbesc(datetime_convert('UTC','UTC','now +' . $days . ' days')),
- local_user()
- );
+ }
+
+ $fields = ['account_expires_on' => DateTimeFormat::utc('now +' . $days . ' days')];
+ $condition = ["`uid` = ? AND `account_expires_on` > ?", local_user(), DBA::NULL_DATETIME];
+ DBA::update('user', $fields, $condition);
+}
+
+function public_server_addon_admin_post(App $a)
+{
+ BaseModule::checkFormSecurityTokenRedirectOnError('/admin/addons/publicserver', 'publicserver');
+
+ DI::config()->set('public_server', 'expiredays', trim($_POST['expiredays'] ?? ''));
+ DI::config()->set('public_server', 'expireposts', trim($_POST['expireposts'] ?? ''));
+ DI::config()->set('public_server', 'nologin', trim($_POST['nologin'] ?? ''));
+ DI::config()->set('public_server', 'flagusers', trim($_POST['flagusers'] ?? ''));
+ DI::config()->set('public_server', 'flagposts', trim($_POST['flagposts'] ?? ''));
+ DI::config()->set('public_server', 'flagpostsexpire', trim($_POST['flagpostsexpire'] ?? ''));
+}
+
+function public_server_addon_admin(App $a, string &$o)
+{
+ $token = BaseModule::getFormSecurityToken('publicserver');
+ $t = Renderer::getMarkupTemplate('admin.tpl', 'addon/public_server');
+ $o = Renderer::replaceMacros($t, [
+ '$submit' => DI::l10n()->t('Save Settings'),
+ '$form_security_token' => $token,
+ '$infotext' => DI::l10n()->t('Set any of these options to 0 to deactivate it.'),
+ '$expiredays' => ["expiredays", "Expire Days", intval(DI::config()->get('public_server', 'expiredays')), "When an account is created on the site, it is given a hard "],
+ '$expireposts' => ["expireposts", "Expire Posts", intval(DI::config()->get('public_server', 'expireposts')), "Set the default days for posts to expire here"],
+ '$nologin' => ["nologin", "No Login", intval(DI::config()->get('public_server', 'nologin')), "Remove users who have never logged in after nologin days "],
+ '$flagusers' => ["flagusers", "Flag users", intval(DI::config()->get('public_server', 'flagusers')), "Remove users who last logged in over flagusers days ago"],
+ '$flagposts' => ["flagposts", "Flag posts", intval(DI::config()->get('public_server', 'flagposts')), "For users who last logged in over flagposts days ago set post expiry days to flagpostsexpire "],
+ '$flagpostsexpire' => ["flagpostsexpire", "Flag posts expire", intval(DI::config()->get('public_server', 'flagpostsexpire'))],
+ ]);
}