X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=public_server%2Fpublic_server.php;h=7591c7d0d32fe23a2b8ce8bd3c5301b14ee816d1;hb=22bf23b8331d83e7c52982eb4731d1436ebc240f;hp=becf96c34fc493aaafc1e7021a21f62e864af228;hpb=a8d96f4f85d7293c5d3f503532252725277c269d;p=friendica-addons.git diff --git a/public_server/public_server.php b/public_server/public_server.php index becf96c3..7591c7d0 100644 --- a/public_server/public_server.php +++ b/public_server/public_server.php @@ -1,143 +1,153 @@ */ - - - -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\ConfigFileManager; +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(ConfigFileManager $loader) +{ + DI::app()->getConfigCache()->load($loader->loadAddonConfig('public_server'), \Friendica\Core\Config\ValueObject\Cache::SOURCE_STATIC); } -function public_server_register_account($a,$b) { - +function public_server_register_account($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) { - logger("public_server: cron start"); - - 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($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, + 'event' => 'SYSTEM_PUBLIC_SERVER_EXPIRATION', + 'uid' => $rr['uid'], + 'system_type' => 'public_server_expire', + 'source_name' => DI::l10n()->t('Administrator'), + 'source_link' => DI::baseUrl(), + 'source_photo' => DI::baseUrl() . '/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("public_server: cron end"); + } + 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(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(); + $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($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` > ?", DI::userSession()->getLocalUserId(), DBA::NULL_DATETIME]; + DBA::update('user', $fields, $condition); +} + +function public_server_addon_admin_post() +{ + 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(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'))], + ]); }