mod/admin.php

   1 <?php
   2
   3  /**
   4  * @file mod/admin.php
   5  *
   6  * @brief Friendica admin
   7  */
   8
   9 use \Friendica\Core\Config;
  10
  11 require_once("include/enotify.php");
  12 require_once("include/text.php");
  13
  14 /**
  15  * @brief Process send data from the admin panels subpages
  16  *
  17  * This function acts as relais for processing the data send from the subpages
  18  * of the admin panel. Depending on the 1st parameter of the url (argv[1])
  19  * specialized functions are called to process the data from the subpages.
  20  *
  21  * The function itself does not return anything, but the subsequencely function
  22  * return the HTML for the pages of the admin panel.
  23  *
  24  * @param App $a
  25  *
  26  */
  27 function admin_post(App $a) {
  28
  29
  30         if(!is_site_admin()) {
  31                 return;
  32         }
  33
  34         // do not allow a page manager to access the admin panel at all.
  35
  36         if (x($_SESSION,'submanage') && intval($_SESSION['submanage'])) {
  37                 return;
  38         }
  39
  40         // urls
  41         if ($a->argc > 1) {
  42                 switch ($a->argv[1]){
  43                         case 'site':
  44                                 admin_page_site_post($a);
  45                                 break;
  46                         case 'users':
  47                                 admin_page_users_post($a);
  48                                 break;
  49                         case 'plugins':
  50                                 if($a->argc > 2 &&
  51                                         is_file("addon/".$a->argv[2]."/".$a->argv[2].".php")) {
  52                                                 @include_once("addon/".$a->argv[2]."/".$a->argv[2].".php");
  53                                                 if(function_exists($a->argv[2].'_plugin_admin_post')) {
  54                                                         $func = $a->argv[2].'_plugin_admin_post';
  55                                                         $func($a);
  56                                                 }
  57                                 }
  58                                 goaway('admin/plugins/'.$a->argv[2]);
  59                                 return; // NOTREACHED
  60                                 break;
  61                         case 'themes':
  62                                 if($a->argc < 2) {
  63                                         if(is_ajax()) return;
  64                                         goaway('admin/');
  65                                         return;
  66                                 }
  67
  68                                 $theme = $a->argv[2];
  69                                 if(is_file("view/theme/$theme/config.php")){
  70                                         function __call_theme_admin_post(App $a, $theme) {
  71                                                 $orig_theme = $a->theme;
  72                                                 $orig_page = $a->page;
  73                                                 $orig_session_theme = $_SESSION['theme'];
  74                                                 require_once("view/theme/$theme/theme.php");
  75                                                 require_once("view/theme/$theme/config.php");
  76                                                 $_SESSION['theme'] = $theme;
  77
  78
  79                                                 $init = $theme."_init";
  80                                                 if(function_exists($init)) $init($a);
  81                                                 if(function_exists("theme_admin_post")) {
  82                                                         $admin_form = theme_admin_post($a);
  83                                                 }
  84
  85                                                 $_SESSION['theme'] = $orig_session_theme;
  86                                                 $a->theme = $orig_theme;
  87                                                 $a->page = $orig_page;
  88                                                 return $admin_form;
  89                                         }
  90                                         __call_theme_admin_post($a, $theme);
  91                                 }
  92                                 info(t('Theme settings updated.'));
  93                                 if(is_ajax()) return;
  94
  95                                 goaway('admin/themes/'.$theme);
  96                                 return;
  97                                 break;
  98                         case 'features':
  99                                 admin_page_features_post($a);
 100                                 break;
 101                         case 'logs':
 102                                 admin_page_logs_post($a);
 103                                 break;
 104                         case 'dbsync':
 105                                 admin_page_dbsync_post($a);
 106                                 break;
 107                 }
 108         }
 109
 110         goaway('admin');
 111         return; // NOTREACHED
 112 }
 113
 114 /**
 115  * @brief Generates content of the admin panel pages
 116  *
 117  * This function generates the content for the admin panel. It consists of the
 118  * aside menu (same for the entire admin panel) and the code for the soecified
 119  * subpage of the panel.
 120  *
 121  * The structure of the adress is: /admin/subpage/details though "details" is
 122  * only necessary for some subpages, like themes or addons where it is the name
 123  * of one theme resp. addon from which the details should be shown. Content for
 124  * the subpages is generated in separate functions for each of the subpages.
 125  *
 126  * The returned string hold the generated HTML code of the page.
 127  *
 128  * @param App $a
 129  * @return string
 130  */
 131 function admin_content(App $a) {
 132
 133         if(!is_site_admin()) {
 134                 return login(false);
 135         }
 136
 137         if (x($_SESSION,'submanage') && intval($_SESSION['submanage'])) {
 138                 return "";
 139         }
 140
 141         // APC deactivated, since there are problems with PHP 5.5
 142         //if (function_exists("apc_delete")) {
 143         //      $toDelete = new APCIterator('user', APC_ITER_VALUE);
 144         //      apc_delete($toDelete);
 145         //}
 146
 147         // Header stuff
 148         $a->page['htmlhead'] .= replace_macros(get_markup_template('admin_settings_head.tpl'), array());
 149
 150         /*
 151          * Side bar links
 152          */
 153         $aside_tools = array();
 154         // array(url, name, extra css classes)
 155         // not part of $aside to make the template more adjustable
 156         $aside_sub = array(
 157                 'site'   =>     array("admin/site/", t("Site") , "site"),
 158                 'users'  =>     array("admin/users/", t("Users") , "users"),
 159                 'plugins'=>     array("admin/plugins/", t("Plugins") , "plugins"),
 160                 'themes' =>     array("admin/themes/", t("Themes") , "themes"),
 161                 'features' =>   array("admin/features/", t("Additional features") , "features"),
 162                 'dbsync' =>     array("admin/dbsync/", t('DB updates'), "dbsync"),
 163                 'queue'  =>     array("admin/queue/", t('Inspect Queue'), "queue"),
 164                 'federation' => array("admin/federation/", t('Federation Statistics'), "federation"),
 165         );
 166
 167         /* get plugins admin page */
 168
 169         $r = q("SELECT `name` FROM `addon` WHERE `plugin_admin` = 1 ORDER BY `name`");
 170         $aside_tools['plugins_admin']=array();
 171         foreach ($r as $h){
 172                 $plugin =$h['name'];
 173                 $aside_tools['plugins_admin'][] = array("admin/plugins/".$plugin, $plugin, "plugin");
 174                 // temp plugins with admin
 175                 $a->plugins_admin[] = $plugin;
 176         }
 177
 178         $aside_tools['logs'] = array("admin/logs/", t("Logs"), "logs");
 179         $aside_tools['viewlogs'] = array("admin/viewlogs/", t("View Logs"), 'viewlogs');
 180         $aside_tools['diagnostics_probe'] = array('probe/', t('probe address'), 'probe');
 181         $aside_tools['diagnostics_webfinger'] = array('webfinger/', t('check webfinger'), 'webfinger');
 182
 183         $t = get_markup_template("admin_aside.tpl");
 184         $a->page['aside'] .= replace_macros($t, array(
 185                 '$admin' => $aside_tools,
 186                 '$subpages' => $aside_sub,
 187                 '$admtxt' => t('Admin'),
 188                 '$plugadmtxt' => t('Plugin Features'),
 189                 '$logtxt' => t('Logs'),
 190                 '$diagnosticstxt' => t('diagnostics'),
 191                 '$h_pending' => t('User registrations waiting for confirmation'),
 192                 '$admurl'=> "admin/"
 193         ));
 194
 195
 196
 197         /*
 198          * Page content
 199          */
 200         $o = '';
 201         // urls
 202         if($a->argc > 1) {
 203                 switch ($a->argv[1]){
 204                         case 'site':
 205                                 $o = admin_page_site($a);
 206                                 break;
 207                         case 'users':
 208                                 $o = admin_page_users($a);
 209                                 break;
 210                         case 'plugins':
 211                                 $o = admin_page_plugins($a);
 212                                 break;
 213                         case 'themes':
 214                                 $o = admin_page_themes($a);
 215                                 break;
 216                         case 'features':
 217                                 $o = admin_page_features($a);
 218                                 break;
 219                         case 'logs':
 220                                 $o = admin_page_logs($a);
 221                                 break;
 222                         case 'viewlogs':
 223                                 $o = admin_page_viewlogs($a);
 224                                 break;
 225                         case 'dbsync':
 226                                 $o = admin_page_dbsync($a);
 227                                 break;
 228                         case 'queue':
 229                                 $o = admin_page_queue($a);
 230                                 break;
 231                         case 'federation':
 232                                 $o = admin_page_federation($a);
 233                                 break;
 234                         default:
 235                                 notice(t("Item not found."));
 236                 }
 237         } else {
 238                 $o = admin_page_summary($a);
 239         }
 240
 241         if(is_ajax()) {
 242                 echo $o;
 243                 killme();
 244                 return '';
 245         } else {
 246                 return $o;
 247         }
 248 }
 249
 250 /**
 251  * @brief Subpage with some stats about "the federation" network
 252  *
 253  * This function generates the "Federation Statistics" subpage for the admin
 254  * panel. The page lists some numbers to the part of "The Federation" known to
 255  * the node. This data includes the different connected networks (e.g.
 256  * Diaspora, Hubzilla, GNU Social) and the used versions in the different
 257  * networks.
 258  *
 259  * The returned string contains the HTML code of the subpage for display.
 260  *
 261  * @param App $a
 262  * @return string
 263  */
 264 function admin_page_federation(App $a) {
 265         // get counts on active friendica, diaspora, redmatrix, hubzilla, gnu
 266         // social and statusnet nodes this node is knowing
 267         //
 268         // We are looking for the following platforms in the DB, "Red" should find
 269         // all variants of that platform ID string as the q() function is stripping
 270         // off one % two of them are needed in the query
 271         // Add more platforms if you like, when one returns 0 known nodes it is not
 272         // displayed on the stats page.
 273         $platforms = array('Friendica', 'Diaspora', '%%red%%', 'Hubzilla', 'BlaBlaNet', 'GNU Social', 'StatusNet', 'Mastodon');
 274         $colors    = array('Friendica' => '#ffc018',     // orange from the logo
 275                            'Diaspora'  => '#a1a1a1',     // logo is black and white, makes a gray
 276                            '%%red%%'   => '#c50001',     // fire red from the logo
 277                            'Hubzilla'  => '#43488a',     // blue from the logo
 278                            'BlaBlaNet' => '#3B5998',     // blue from the navbar at blablanet-dot-com
 279                            'GNU Social'=> '#a22430',     // dark red from the logo
 280                            'StatusNet' => '#789240',     // the green from the logo (red and blue have already others
 281                            'Mastodon'  => '#1a9df9');    // blue from the Mastodon logo
 282         $counts = array();
 283         $total = 0;
 284
 285         foreach ($platforms as $p) {
 286                 // get a total count for the platform, the name and version of the
 287                 // highest version and the protocol tpe
 288                 $c = qu('SELECT COUNT(*) AS `total`, `platform`, `network`, `version` FROM `gserver`
 289                                 WHERE `platform` LIKE "%s" AND `last_contact` >= `last_failure`
 290                                 ORDER BY `version` ASC;', $p);
 291                 $total = $total + $c[0]['total'];
 292
 293                 // what versions for that platform do we know at all?
 294                 // again only the active nodes
 295                 $v = qu('SELECT COUNT(*) AS `total`, `version` FROM `gserver`
 296                                 WHERE `last_contact` >= `last_failure` AND `platform` LIKE "%s"
 297                                 GROUP BY `version`
 298                                 ORDER BY `version`;', $p);
 299
 300                 //
 301                 // clean up version numbers
 302                 //
 303                 // some platforms do not provide version information, add a unkown there
 304                 // to the version string for the displayed list.
 305                 foreach ($v as $key => $value) {
 306                         if ($v[$key]['version'] == '') {
 307                                 $v[$key] = array('total'=>$v[$key]['total'], 'version'=>t('unknown'));
 308                         }
 309                 }
 310                 // in the DB the Diaspora versions have the format x.x.x.x-xx the last
 311                 // part (-xx) should be removed to clean up the versions from the "head
 312                 // commit" information and combined into a single entry for x.x.x.x
 313                 if($p=='Diaspora') {
 314                         $newV = array();
 315                         $newVv = array();
 316                         foreach($v as $vv) {
 317                                 $newVC = $vv['total'];
 318                                 $newVV = $vv['version'];
 319                                 $posDash = strpos($newVV, '-');
 320                                 if($posDash)
 321                                         $newVV = substr($newVV, 0, $posDash);
 322                                 if(isset($newV[$newVV]))
 323                                         $newV[$newVV] += $newVC;
 324                                 else
 325                                         $newV[$newVV] = $newVC;
 326                         }
 327                         foreach ($newV as $key => $value) {
 328                                 array_push($newVv, array('total'=>$value, 'version'=>$key));
 329                         }
 330                         $v = $newVv;
 331                 }
 332
 333                 // early friendica versions have the format x.x.xxxx where xxxx is the
 334                 // DB version stamp; those should be operated out and versions be
 335                 // conbined
 336                 if($p=='Friendica') {
 337                         $newV = array();
 338                         $newVv = array();
 339                         foreach ($v as $vv) {
 340                                 $newVC = $vv['total'];
 341                                 $newVV = $vv['version'];
 342                                 $lastDot = strrpos($newVV,'.');
 343                                 $len = strlen($newVV)-1;
 344                                 if(($lastDot == $len-4) && (!strrpos($newVV,'-rc')==$len-3))
 345                                         $newVV = substr($newVV, 0, $lastDot);
 346                                 if(isset($newV[$newVV]))
 347                                         $newV[$newVV] += $newVC;
 348                                 else
 349                                         $newV[$newVV] = $newVC;
 350                         }
 351                         foreach ($newV as $key => $value) {
 352                                 array_push($newVv, array('total'=>$value, 'version'=>$key));
 353                         }
 354                         $v = $newVv;
 355                 }
 356
 357                 foreach ($v as $key => $vv)
 358                         $v[$key]["version"] = trim(strip_tags($vv["version"]));
 359
 360                 // the 3rd array item is needed for the JavaScript graphs as JS does
 361                 // not like some characters in the names of variables...
 362                 $counts[$p]=array($c[0], $v, str_replace(array(' ','%'),'',$p), $colors[$p]);
 363         }
 364
 365         // some helpful text
 366         $intro = t('This page offers you some numbers to the known part of the federated social network your Friendica node is part of. These numbers are not complete but only reflect the part of the network your node is aware of.');
 367         $hint = t('The <em>Auto Discovered Contact Directory</em> feature is not enabled, it will improve the data displayed here.');
 368
 369         // load the template, replace the macros and return the page content
 370         $t = get_markup_template("admin_federation.tpl");
 371         return replace_macros($t, array(
 372                 '$title' => t('Administration'),
 373                 '$page' => t('Federation Statistics'),
 374                 '$intro' => $intro,
 375                 '$hint' => $hint,
 376                 '$autoactive' => get_config('system', 'poco_completion'),
 377                 '$counts' => $counts,
 378                 '$version' => FRIENDICA_VERSION,
 379                 '$legendtext' => sprintf(t('Currently this node is aware of %d nodes from the following platforms:'), $total),
 380                 '$baseurl' => App::get_baseurl(),
 381         ));
 382 }
 383
 384 /**
 385  * @brief Admin Inspect Queue Page
 386  *
 387  * Generates a page for the admin to have a look into the current queue of
 388  * postings that are not deliverabke. Shown are the name and url of the
 389  * recipient, the delivery network and the dates when the posting was generated
 390  * and the last time tried to deliver the posting.
 391  *
 392  * The returned string holds the content of the page.
 393  *
 394  * @param App $a
 395  * @return string
 396  */
 397 function admin_page_queue(App $a) {
 398         // get content from the queue table
 399         $r = q("SELECT `c`.`name`, `c`.`nurl`, `q`.`id`, `q`.`network`, `q`.`created`, `q`.`last`
 400                         FROM `queue` AS `q`, `contact` AS `c`
 401                         WHERE `c`.`id` = `q`.`cid`
 402                         ORDER BY `q`.`cid`, `q`.`created`;");
 403
 404         $t = get_markup_template("admin_queue.tpl");
 405         return replace_macros($t, array(
 406                 '$title' => t('Administration'),
 407                 '$page' => t('Inspect Queue'),
 408                 '$count' => sizeof($r),
 409                 'id_header' => t('ID'),
 410                 '$to_header' => t('Recipient Name'),
 411                 '$url_header' => t('Recipient Profile'),
 412                 '$network_header' => t('Network'),
 413                 '$created_header' => t('Created'),
 414                 '$last_header' => t('Last Tried'),
 415                 '$info' => t('This page lists the content of the queue for outgoing postings. These are postings the initial delivery failed for. They will be resend later and eventually deleted if the delivery fails permanently.'),
 416                 '$entries' => $r,
 417         ));
 418 }
 419
 420 /**
 421  * @brief Admin Summary Page
 422  *
 423  * The summary page is the "start page" of the admin panel. It gives the admin
 424  * a first overview of the open adminastrative tasks.
 425  *
 426  * The returned string contains the HTML content of the generated page.
 427  *
 428  * @param App $a
 429  * @return string
 430  */
 431 function admin_page_summary(App $a) {
 432         global $db;
 433         // are there MyISAM tables in the DB? If so, trigger a warning message
 434         $r = q("SELECT `engine` FROM `information_schema`.`tables` WHERE `engine` = 'myisam' AND `table_schema` = '%s' LIMIT 1",
 435                 dbesc($db->database_name()));
 436         $showwarning = false;
 437         $warningtext = array();
 438         if (dbm::is_result($r)) {
 439                 $showwarning = true;
 440                 $warningtext[] = sprintf(t('Your DB still runs with MyISAM tables. You should change the engine type to InnoDB. As Friendica will use InnoDB only features in the future, you should change this! See <a href="%s">here</a> for a guide that may be helpful converting the table engines. You may also use the <tt>convert_innodb.sql</tt> in the <tt>/util</tt> directory of your Friendica installation.<br />'), 'https://dev.mysql.com/doc/refman/5.7/en/converting-tables-to-innodb.html');
 441         }
 442         // MySQL >= 5.7.4 doesn't support the IGNORE keyword in ALTER TABLE statements
 443         if ((version_compare($db->server_info(), '5.7.4') >= 0) AND
 444                 !(strpos($db->server_info(), 'MariaDB') !== false)) {
 445                 $warningtext[] = t('You are using a MySQL version which does not support all features that Friendica uses. You should consider switching to MariaDB.');
 446         }
 447         $r = q("SELECT `page-flags`, COUNT(`uid`) AS `count` FROM `user` GROUP BY `page-flags`");
 448         $accounts = array(
 449                 array(t('Normal Account'), 0),
 450                 array(t('Soapbox Account'), 0),
 451                 array(t('Community/Celebrity Account'), 0),
 452                 array(t('Automatic Friend Account'), 0),
 453                 array(t('Blog Account'), 0),
 454                 array(t('Private Forum'), 0)
 455         );
 456
 457         $users=0;
 458         foreach ($r as $u){ $accounts[$u['page-flags']][1] = $u['count']; $users+= $u['count']; }
 459
 460         logger('accounts: '.print_r($accounts,true),LOGGER_DATA);
 461
 462         $r = qu("SELECT COUNT(`id`) AS `count` FROM `register`");
 463         $pending = $r[0]['count'];
 464
 465         $r = qu("SELECT COUNT(*) AS `total` FROM `deliverq` WHERE 1");
 466         $deliverq = (($r) ? $r[0]['total'] : 0);
 467
 468         $r = qu("SELECT COUNT(*) AS `total` FROM `queue` WHERE 1");
 469         $queue = (($r) ? $r[0]['total'] : 0);
 470
 471         if (get_config('system','worker')) {
 472                 $r = qu("SELECT COUNT(*) AS `total` FROM `workerqueue` WHERE 1");
 473                 $workerqueue = (($r) ? $r[0]['total'] : 0);
 474         } else {
 475                 $workerqueue = 0;
 476         }
 477
 478         // We can do better, but this is a quick queue status
 479
 480         $queues = array('label' => t('Message queues'), 'deliverq' => $deliverq, 'queue' => $queue, 'workerq' => $workerqueue);
 481
 482
 483         $t = get_markup_template("admin_summary.tpl");
 484         return replace_macros($t, array(
 485                 '$title' => t('Administration'),
 486                 '$page' => t('Summary'),
 487                 '$queues' => $queues,
 488                 '$workeractive' => get_config('system','worker'),
 489                 '$users' => array(t('Registered users'), $users),
 490                 '$accounts' => $accounts,
 491                 '$pending' => array(t('Pending registrations'), $pending),
 492                 '$version' => array(t('Version'), FRIENDICA_VERSION),
 493                 '$baseurl' => App::get_baseurl(),
 494                 '$platform' => FRIENDICA_PLATFORM,
 495                 '$codename' => FRIENDICA_CODENAME,
 496                 '$build' =>  get_config('system','build'),
 497                 '$plugins' => array(t('Active plugins'), $a->plugins),
 498                 '$showwarning' => $showwarning,
 499                 '$warningtext' => $warningtext
 500         ));
 501 }
 502
 503 /**
 504  * @brief Process send data from Admin Site Page
 505  *
 506  * @param App $a
 507  */
 508 function admin_page_site_post(App $a) {
 509         if(!x($_POST,"page_site")) {
 510                 return;
 511         }
 512
 513         check_form_security_token_redirectOnErr('/admin/site', 'admin_site');
 514
 515         // relocate
 516         if(x($_POST,'relocate') && x($_POST,'relocate_url') && $_POST['relocate_url']!="") {
 517                 $new_url = $_POST['relocate_url'];
 518                 $new_url = rtrim($new_url,"/");
 519
 520                 $parsed = @parse_url($new_url);
 521                 if(!$parsed || (!x($parsed,'host') || !x($parsed,'scheme'))) {
 522                         notice(t("Can not parse base url. Must have at least <scheme>://<domain>"));
 523                         goaway('admin/site');
 524                 }
 525
 526                 /* steps:
 527                  * replace all "baseurl" to "new_url" in config, profile, term, items and contacts
 528                  * send relocate for every local user
 529                  * */
 530
 531                 $old_url = App::get_baseurl(true);
 532
 533                 // Generate host names for relocation the addresses in the format user@address.tld
 534                 $new_host = str_replace("http://", "@", normalise_link($new_url));
 535                 $old_host = str_replace("http://", "@", normalise_link($old_url));
 536
 537                 function update_table($table_name, $fields, $old_url, $new_url) {
 538                         global $db, $a;
 539
 540                         $dbold = dbesc($old_url);
 541                         $dbnew = dbesc($new_url);
 542
 543                         $upd = array();
 544                         foreach ($fields as $f) {
 545                                 $upd[] = "`$f` = REPLACE(`$f`, '$dbold', '$dbnew')";
 546                         }
 547
 548                         $upds = implode(", ", $upd);
 549
 550
 551
 552                         $q = sprintf("UPDATE %s SET %s;", $table_name, $upds);
 553                         $r = q($q);
 554                         if(!$r) {
 555                                 notice("Failed updating '$table_name': ".$db->error);
 556                                 goaway('admin/site');
 557                         }
 558                 }
 559
 560                 // update tables
 561                 // update profile links in the format "http://server.tld"
 562                 update_table("profile", array('photo', 'thumb'), $old_url, $new_url);
 563                 update_table("term", array('url'), $old_url, $new_url);
 564                 update_table("contact", array('photo','thumb','micro','url','nurl','alias','request','notify','poll','confirm','poco', 'avatar'), $old_url, $new_url);
 565                 update_table("gcontact", array('url','nurl','photo','server_url','notify','alias'), $old_url, $new_url);
 566                 update_table("item", array('owner-link','owner-avatar','author-link','author-avatar','body','plink','tag'), $old_url, $new_url);
 567
 568                 // update profile addresses in the format "user@server.tld"
 569                 update_table("contact", array('addr'), $old_host, $new_host);
 570                 update_table("gcontact", array('connect','addr'), $old_host, $new_host);
 571
 572                 // update config
 573                 $a->set_baseurl($new_url);
 574                 set_config('system','url',$new_url);
 575
 576                 // send relocate
 577                 $users = q("SELECT `uid` FROM `user` WHERE `account_removed` = 0 AND `account_expired` = 0");
 578
 579                 foreach ($users as $user) {
 580                         proc_run(PRIORITY_HIGH, 'include/notifier.php', 'relocate', $user['uid']);
 581                 }
 582
 583                 info("Relocation started. Could take a while to complete.");
 584
 585                 goaway('admin/site');
 586         }
 587         // end relocate
 588
 589         $sitename               =       ((x($_POST,'sitename'))                 ? notags(trim($_POST['sitename']))              : '');
 590         $hostname               =       ((x($_POST,'hostname'))                 ? notags(trim($_POST['hostname']))              : '');
 591         $sender_email           =       ((x($_POST,'sender_email'))             ? notags(trim($_POST['sender_email']))          : '');
 592         $banner                 =       ((x($_POST,'banner'))                   ? trim($_POST['banner'])                        : false);
 593         $shortcut_icon          =       ((x($_POST,'shortcut_icon'))            ? notags(trim($_POST['shortcut_icon']))         : '');
 594         $touch_icon             =       ((x($_POST,'touch_icon'))               ? notags(trim($_POST['touch_icon']))            : '');
 595         $info                   =       ((x($_POST,'info'))                     ? trim($_POST['info'])                          : false);
 596         $language               =       ((x($_POST,'language'))                 ? notags(trim($_POST['language']))              : '');
 597         $theme                  =       ((x($_POST,'theme'))                    ? notags(trim($_POST['theme']))                 : '');
 598         $theme_mobile           =       ((x($_POST,'theme_mobile'))             ? notags(trim($_POST['theme_mobile']))          : '');
 599         $maximagesize           =       ((x($_POST,'maximagesize'))             ? intval(trim($_POST['maximagesize']))          :  0);
 600         $maximagelength         =       ((x($_POST,'maximagelength'))           ? intval(trim($_POST['maximagelength']))        :  MAX_IMAGE_LENGTH);
 601         $jpegimagequality       =       ((x($_POST,'jpegimagequality'))         ? intval(trim($_POST['jpegimagequality']))      :  JPEG_QUALITY);
 602
 603
 604         $register_policy        =       ((x($_POST,'register_policy'))          ? intval(trim($_POST['register_policy']))       :  0);
 605         $daily_registrations    =       ((x($_POST,'max_daily_registrations'))  ? intval(trim($_POST['max_daily_registrations']))       :0);
 606         $abandon_days           =       ((x($_POST,'abandon_days'))             ? intval(trim($_POST['abandon_days']))          :  0);
 607
 608         $register_text          =       ((x($_POST,'register_text'))            ? notags(trim($_POST['register_text']))         : '');
 609
 610         $allowed_sites          =       ((x($_POST,'allowed_sites'))            ? notags(trim($_POST['allowed_sites']))         : '');
 611         $allowed_email          =       ((x($_POST,'allowed_email'))            ? notags(trim($_POST['allowed_email']))         : '');
 612         $block_public           =       ((x($_POST,'block_public'))             ? True                                          : False);
 613         $force_publish          =       ((x($_POST,'publish_all'))              ? True                                          : False);
 614         $global_directory       =       ((x($_POST,'directory'))                ? notags(trim($_POST['directory']))             : '');
 615         $thread_allow           =       ((x($_POST,'thread_allow'))             ? True                                          : False);
 616         $newuser_private                =       ((x($_POST,'newuser_private'))          ? True                                  : False);
 617         $enotify_no_content             =       ((x($_POST,'enotify_no_content'))       ? True                                  : False);
 618         $private_addons                 =       ((x($_POST,'private_addons'))           ? True                                  : False);
 619         $disable_embedded               =       ((x($_POST,'disable_embedded'))         ? True                                  : False);
 620         $allow_users_remote_self        =       ((x($_POST,'allow_users_remote_self'))  ? True                                  : False);
 621
 622         $no_multi_reg           =       ((x($_POST,'no_multi_reg'))             ? True                                          : False);
 623         $no_openid              =       !((x($_POST,'no_openid'))               ? True                                          : False);
 624         $no_regfullname         =       !((x($_POST,'no_regfullname'))          ? True                                          : False);
 625         $no_utf                 =       !((x($_POST,'no_utf'))                  ? True                                          : False);
 626         $community_page_style   =       ((x($_POST,'community_page_style'))     ? intval(trim($_POST['community_page_style']))  : 0);
 627         $max_author_posts_community_page        =       ((x($_POST,'max_author_posts_community_page'))  ? intval(trim($_POST['max_author_posts_community_page']))       : 0);
 628
 629         $verifyssl              =       ((x($_POST,'verifyssl'))                ? True                                          : False);
 630         $proxyuser              =       ((x($_POST,'proxyuser'))                ? notags(trim($_POST['proxyuser']))             : '');
 631         $proxy                  =       ((x($_POST,'proxy'))                    ? notags(trim($_POST['proxy']))                 : '');
 632         $timeout                =       ((x($_POST,'timeout'))                  ? intval(trim($_POST['timeout']))               : 60);
 633         $delivery_interval      =       ((x($_POST,'delivery_interval'))        ? intval(trim($_POST['delivery_interval']))     : 0);
 634         $poll_interval          =       ((x($_POST,'poll_interval'))            ? intval(trim($_POST['poll_interval']))         : 0);
 635         $maxloadavg             =       ((x($_POST,'maxloadavg'))               ? intval(trim($_POST['maxloadavg']))            : 50);
 636         $maxloadavg_frontend    =       ((x($_POST,'maxloadavg_frontend'))      ? intval(trim($_POST['maxloadavg_frontend']))   : 50);
 637         $optimize_max_tablesize =       ((x($_POST,'optimize_max_tablesize'))   ? intval(trim($_POST['optimize_max_tablesize'])): 100);
 638         $optimize_fragmentation =       ((x($_POST,'optimize_fragmentation'))   ? intval(trim($_POST['optimize_fragmentation'])): 30);
 639         $poco_completion        =       ((x($_POST,'poco_completion'))          ? intval(trim($_POST['poco_completion']))       : false);
 640         $poco_requery_days      =       ((x($_POST,'poco_requery_days'))        ? intval(trim($_POST['poco_requery_days']))     : 7);
 641         $poco_discovery         =       ((x($_POST,'poco_discovery'))           ? intval(trim($_POST['poco_discovery']))        : 0);
 642         $poco_discovery_since   =       ((x($_POST,'poco_discovery_since'))     ? intval(trim($_POST['poco_discovery_since']))  : 30);
 643         $poco_local_search      =       ((x($_POST,'poco_local_search'))        ? intval(trim($_POST['poco_local_search']))     : false);
 644         $nodeinfo               =       ((x($_POST,'nodeinfo'))                 ? intval(trim($_POST['nodeinfo']))              : false);
 645         $dfrn_only              =       ((x($_POST,'dfrn_only'))                ? True                                          : False);
 646         $ostatus_disabled       =       !((x($_POST,'ostatus_disabled'))        ? True                                          : False);
 647         $ostatus_poll_interval  =       ((x($_POST,'ostatus_poll_interval'))    ? intval(trim($_POST['ostatus_poll_interval'])) :  0);
 648         $ostatus_full_threads   =       ((x($_POST,'ostatus_full_threads'))     ? True                                          : False);
 649         $diaspora_enabled       =       ((x($_POST,'diaspora_enabled'))         ? True                                          : False);
 650         $ssl_policy             =       ((x($_POST,'ssl_policy'))               ? intval($_POST['ssl_policy'])                  : 0);
 651         $force_ssl              =       ((x($_POST,'force_ssl'))                ? True                                          : False);
 652         $old_share              =       ((x($_POST,'old_share'))                ? True                                          : False);
 653         $hide_help              =       ((x($_POST,'hide_help'))                ? True                                          : False);
 654         $suppress_language      =       ((x($_POST,'suppress_language'))        ? True                                          : False);
 655         $suppress_tags          =       ((x($_POST,'suppress_tags'))            ? True                                          : False);
 656         $use_fulltext_engine    =       ((x($_POST,'use_fulltext_engine'))      ? True                                          : False);
 657         $itemcache              =       ((x($_POST,'itemcache'))                ? notags(trim($_POST['itemcache']))             : '');
 658         $itemcache_duration     =       ((x($_POST,'itemcache_duration'))       ? intval($_POST['itemcache_duration'])          : 0);
 659         $max_comments           =       ((x($_POST,'max_comments'))             ? intval($_POST['max_comments'])                : 0);
 660         $lockpath               =       ((x($_POST,'lockpath'))                 ? notags(trim($_POST['lockpath']))              : '');
 661         $temppath               =       ((x($_POST,'temppath'))                 ? notags(trim($_POST['temppath']))              : '');
 662         $basepath               =       ((x($_POST,'basepath'))                 ? notags(trim($_POST['basepath']))              : '');
 663         $singleuser             =       ((x($_POST,'singleuser'))               ? notags(trim($_POST['singleuser']))            : '');
 664         $proxy_disabled         =       ((x($_POST,'proxy_disabled'))           ? True                                          : False);
 665         $old_pager              =       ((x($_POST,'old_pager'))                ? True                                          : False);
 666         $only_tag_search        =       ((x($_POST,'only_tag_search'))          ? True                                          : False);
 667         $rino                   =       ((x($_POST,'rino'))                     ? intval($_POST['rino'])                        : 0);
 668         $embedly                =       ((x($_POST,'embedly'))                  ? notags(trim($_POST['embedly']))               : '');
 669         $worker                 =       ((x($_POST,'worker'))                   ? True                                          : False);
 670         $worker_queues          =       ((x($_POST,'worker_queues'))            ? intval($_POST['worker_queues'])               : 4);
 671         $worker_dont_fork       =       ((x($_POST,'worker_dont_fork'))         ? True                                          : False);
 672         $worker_fastlane        =       ((x($_POST,'worker_fastlane'))          ? True                                          : False);
 673         $worker_frontend        =       ((x($_POST,'worker_frontend'))          ? True                                          : False);
 674
 675         if($a->get_path() != "")
 676                 $diaspora_enabled = false;
 677
 678         if(!$thread_allow)
 679                 $ostatus_disabled = true;
 680
 681         if($ssl_policy != intval(get_config('system','ssl_policy'))) {
 682                 if($ssl_policy == SSL_POLICY_FULL) {
 683                         q("UPDATE `contact` SET
 684                                 `url`     = REPLACE(`url`    , 'http:' , 'https:'),
 685                                 `photo`   = REPLACE(`photo`  , 'http:' , 'https:'),
 686                                 `thumb`   = REPLACE(`thumb`  , 'http:' , 'https:'),
 687                                 `micro`   = REPLACE(`micro`  , 'http:' , 'https:'),
 688                                 `request` = REPLACE(`request`, 'http:' , 'https:'),
 689                                 `notify`  = REPLACE(`notify` , 'http:' , 'https:'),
 690                                 `poll`    = REPLACE(`poll`   , 'http:' , 'https:'),
 691                                 `confirm` = REPLACE(`confirm`, 'http:' , 'https:'),
 692                                 `poco`    = REPLACE(`poco`   , 'http:' , 'https:')
 693                                 WHERE `self` = 1"
 694                         );
 695                         q("UPDATE `profile` SET
 696                                 `photo`   = REPLACE(`photo`  , 'http:' , 'https:'),
 697                                 `thumb`   = REPLACE(`thumb`  , 'http:' , 'https:')
 698                                 WHERE 1 "
 699                         );
 700                 }
 701                 elseif($ssl_policy == SSL_POLICY_SELFSIGN) {
 702                         q("UPDATE `contact` SET
 703                                 `url`     = REPLACE(`url`    , 'https:' , 'http:'),
 704                                 `photo`   = REPLACE(`photo`  , 'https:' , 'http:'),
 705                                 `thumb`   = REPLACE(`thumb`  , 'https:' , 'http:'),
 706                                 `micro`   = REPLACE(`micro`  , 'https:' , 'http:'),
 707                                 `request` = REPLACE(`request`, 'https:' , 'http:'),
 708                                 `notify`  = REPLACE(`notify` , 'https:' , 'http:'),
 709                                 `poll`    = REPLACE(`poll`   , 'https:' , 'http:'),
 710                                 `confirm` = REPLACE(`confirm`, 'https:' , 'http:'),
 711                                 `poco`    = REPLACE(`poco`   , 'https:' , 'http:')
 712                                 WHERE `self` = 1"
 713                         );
 714                         q("UPDATE `profile` SET
 715                                 `photo`   = REPLACE(`photo`  , 'https:' , 'http:'),
 716                                 `thumb`   = REPLACE(`thumb`  , 'https:' , 'http:')
 717                                 WHERE 1 "
 718                         );
 719                 }
 720         }
 721         set_config('system','ssl_policy',$ssl_policy);
 722         set_config('system','delivery_interval',$delivery_interval);
 723         set_config('system','poll_interval',$poll_interval);
 724         set_config('system','maxloadavg',$maxloadavg);
 725         set_config('system','maxloadavg_frontend',$maxloadavg_frontend);
 726         set_config('system','optimize_max_tablesize',$optimize_max_tablesize);
 727         set_config('system','optimize_fragmentation',$optimize_fragmentation);
 728         set_config('system','poco_completion',$poco_completion);
 729         set_config('system','poco_requery_days',$poco_requery_days);
 730         set_config('system','poco_discovery',$poco_discovery);
 731         set_config('system','poco_discovery_since',$poco_discovery_since);
 732         set_config('system','poco_local_search',$poco_local_search);
 733         set_config('system','nodeinfo',$nodeinfo);
 734         set_config('config','sitename',$sitename);
 735         set_config('config','hostname',$hostname);
 736         set_config('config','sender_email', $sender_email);
 737         set_config('system','suppress_language',$suppress_language);
 738         set_config('system','suppress_tags',$suppress_tags);
 739         set_config('system','shortcut_icon',$shortcut_icon);
 740         set_config('system','touch_icon',$touch_icon);
 741
 742         if($banner=="") {
 743                 // don't know why, but del_config doesn't work...
 744                 q("DELETE FROM `config` WHERE `cat` = '%s' AND `k` = '%s' LIMIT 1",
 745                         dbesc("system"),
 746                         dbesc("banner")
 747                 );
 748         } else {
 749                 set_config('system','banner', $banner);
 750         }
 751
 752         if($info=="") {
 753                 del_config('config','info');
 754         } else {
 755                 set_config('config','info',$info);
 756         }
 757         set_config('system','language', $language);
 758         set_config('system','theme', $theme);
 759
 760         if($theme_mobile === '---') {
 761                 del_config('system','mobile-theme');
 762         } else {
 763                 set_config('system','mobile-theme', $theme_mobile);
 764                 }
 765                 if($singleuser === '---') {
 766                         del_config('system','singleuser');
 767                 } else {
 768                         set_config('system','singleuser', $singleuser);
 769                 }
 770         set_config('system','maximagesize', $maximagesize);
 771         set_config('system','max_image_length', $maximagelength);
 772         set_config('system','jpeg_quality', $jpegimagequality);
 773
 774         set_config('config','register_policy', $register_policy);
 775         set_config('system','max_daily_registrations', $daily_registrations);
 776         set_config('system','account_abandon_days', $abandon_days);
 777         set_config('config','register_text', $register_text);
 778         set_config('system','allowed_sites', $allowed_sites);
 779         set_config('system','allowed_email', $allowed_email);
 780         set_config('system','block_public', $block_public);
 781         set_config('system','publish_all', $force_publish);
 782         set_config('system','directory', $global_directory);
 783         set_config('system','thread_allow', $thread_allow);
 784         set_config('system','newuser_private', $newuser_private);
 785         set_config('system','enotify_no_content', $enotify_no_content);
 786         set_config('system','disable_embedded', $disable_embedded);
 787         set_config('system','allow_users_remote_self', $allow_users_remote_self);
 788
 789         set_config('system','block_extended_register', $no_multi_reg);
 790         set_config('system','no_openid', $no_openid);
 791         set_config('system','no_regfullname', $no_regfullname);
 792         set_config('system','community_page_style', $community_page_style);
 793         set_config('system','max_author_posts_community_page', $max_author_posts_community_page);
 794         set_config('system','no_utf', $no_utf);
 795         set_config('system','verifyssl', $verifyssl);
 796         set_config('system','proxyuser', $proxyuser);
 797         set_config('system','proxy', $proxy);
 798         set_config('system','curl_timeout', $timeout);
 799         set_config('system','dfrn_only', $dfrn_only);
 800         set_config('system','ostatus_disabled', $ostatus_disabled);
 801         set_config('system','ostatus_poll_interval', $ostatus_poll_interval);
 802         set_config('system','ostatus_full_threads', $ostatus_full_threads);
 803         set_config('system','diaspora_enabled', $diaspora_enabled);
 804
 805         set_config('config','private_addons', $private_addons);
 806
 807         set_config('system','force_ssl', $force_ssl);
 808         set_config('system','old_share', $old_share);
 809         set_config('system','hide_help', $hide_help);
 810         set_config('system','use_fulltext_engine', $use_fulltext_engine);
 811         set_config('system','itemcache', $itemcache);
 812         set_config('system','itemcache_duration', $itemcache_duration);
 813         set_config('system','max_comments', $max_comments);
 814         set_config('system','lockpath', $lockpath);
 815         set_config('system','temppath', $temppath);
 816         set_config('system','basepath', $basepath);
 817         set_config('system','proxy_disabled', $proxy_disabled);
 818         set_config('system','old_pager', $old_pager);
 819         set_config('system','only_tag_search', $only_tag_search);
 820         set_config('system','worker', $worker);
 821         set_config('system','worker_queues', $worker_queues);
 822         set_config('system','worker_dont_fork', $worker_dont_fork);
 823         set_config('system','worker_fastlane', $worker_fastlane);
 824         set_config('system','frontend_worker', $worker_frontend);
 825
 826         if($rino==2 and !function_exists('mcrypt_create_iv')) {
 827                 notice(t("RINO2 needs mcrypt php extension to work."));
 828         } else {
 829                 set_config('system','rino_encrypt', $rino);
 830         }
 831
 832         set_config('system','embedly', $embedly);
 833
 834
 835         info(t('Site settings updated.').EOL);
 836         goaway('admin/site');
 837         return; // NOTREACHED
 838
 839 }
 840
 841 /**
 842  * @brief Generate Admin Site subpage
 843  *
 844  * This function generates the main configuration page of the admin panel.
 845  *
 846  * @param  App $a
 847  * @return string
 848  */
 849 function admin_page_site(App $a) {
 850
 851         /* Installed langs */
 852         $lang_choices = get_available_languages();
 853
 854         if(strlen(get_config('system','directory_submit_url')) AND
 855                 !strlen(get_config('system','directory'))) {
 856                         set_config('system','directory', dirname(get_config('system','directory_submit_url')));
 857                         del_config('system','directory_submit_url');
 858         }
 859
 860         /* Installed themes */
 861         $theme_choices = array();
 862         $theme_choices_mobile = array();
 863         $theme_choices_mobile["---"] = t("No special theme for mobile devices");
 864         $files = glob('view/theme/*');
 865         if($files) {
 866                 foreach($files as $file) {
 867                         if(intval(file_exists($file.'/unsupported')))
 868                                 continue;
 869
 870                         $f = basename($file);
 871                         $theme_name = ((file_exists($file.'/experimental')) ?  sprintf("%s - \x28Experimental\x29", $f) : $f);
 872                         if(file_exists($file.'/mobile')) {
 873                                 $theme_choices_mobile[$f] = $theme_name;
 874                         } else {
 875                                 $theme_choices[$f] = $theme_name;
 876                         }
 877                 }
 878         }
 879
 880         /* Community page style */
 881         $community_page_style_choices = array(
 882                 CP_NO_COMMUNITY_PAGE => t("No community page"),
 883                 CP_USERS_ON_SERVER => t("Public postings from users of this site"),
 884                 CP_GLOBAL_COMMUNITY => t("Global community page")
 885                 );
 886
 887         /* OStatus conversation poll choices */
 888         $ostatus_poll_choices = array(
 889                 "-2" => t("Never"),
 890                 "-1" => t("At post arrival"),
 891                 "0" => t("Frequently"),
 892                 "60" => t("Hourly"),
 893                 "720" => t("Twice daily"),
 894                 "1440" => t("Daily")
 895                 );
 896
 897         $poco_discovery_choices = array(
 898                 "0" => t("Disabled"),
 899                 "1" => t("Users"),
 900                 "2" => t("Users, Global Contacts"),
 901                 "3" => t("Users, Global Contacts/fallback"),
 902                 );
 903
 904         $poco_discovery_since_choices = array(
 905                 "30" => t("One month"),
 906                 "91" => t("Three months"),
 907                 "182" => t("Half a year"),
 908                 "365" => t("One year"),
 909                 );
 910
 911         /* get user names to make the install a personal install of X */
 912         $user_names = array();
 913         $user_names['---'] = t('Multi user instance');
 914         $users = q("SELECT `username`, `nickname` FROM `user`");
 915         foreach ($users as $user) {
 916                 $user_names[$user['nickname']] = $user['username'];
 917         }
 918
 919         /* Banner */
 920         $banner = get_config('system','banner');
 921         if($banner == false)
 922                 $banner = '<a href="http://friendica.com"><img id="logo-img" src="images/friendica-32.png" alt="logo" /></a><span id="logo-text"><a href="http://friendica.com">Friendica</a></span>';
 923         $banner = htmlspecialchars($banner);
 924         $info = get_config('config','info');
 925         $info = htmlspecialchars($info);
 926
 927         // Automatically create temporary paths
 928         get_temppath();
 929         get_lockpath();
 930         get_itemcachepath();
 931
 932         //echo "<pre>"; var_dump($lang_choices); die("</pre>");
 933
 934         /* Register policy */
 935         $register_choices = array(
 936                 REGISTER_CLOSED => t("Closed"),
 937                 REGISTER_APPROVE => t("Requires approval"),
 938                 REGISTER_OPEN => t("Open")
 939         );
 940
 941         $ssl_choices = array(
 942                 SSL_POLICY_NONE => t("No SSL policy, links will track page SSL state"),
 943                 SSL_POLICY_FULL => t("Force all links to use SSL"),
 944                 SSL_POLICY_SELFSIGN => t("Self-signed certificate, use SSL for local links only (discouraged)")
 945         );
 946
 947         if($a->config['hostname'] == "")
 948                 $a->config['hostname'] = $a->get_hostname();
 949
 950         $diaspora_able = ($a->get_path() == "");
 951
 952         $optimize_max_tablesize = Config::get('system','optimize_max_tablesize', 100);
 953
 954         if ($optimize_max_tablesize < -1) {
 955                 $optimize_max_tablesize = -1;
 956         }
 957
 958         if ($optimize_max_tablesize == 0) {
 959                 $optimize_max_tablesize = 100;
 960         }
 961
 962         $t = get_markup_template("admin_site.tpl");
 963         return replace_macros($t, array(
 964                 '$title' => t('Administration'),
 965                 '$page' => t('Site'),
 966                 '$submit' => t('Save Settings'),
 967                 '$registration' => t('Registration'),
 968                 '$upload' => t('File upload'),
 969                 '$corporate' => t('Policies'),
 970                 '$advanced' => t('Advanced'),
 971                 '$portable_contacts' => t('Auto Discovered Contact Directory'),
 972                 '$performance' => t('Performance'),
 973                 '$worker_title' => t('Worker'),
 974                 '$relocate'=> t('Relocate - WARNING: advanced function. Could make this server unreachable.'),
 975                 '$baseurl' => App::get_baseurl(true),
 976                 // name, label, value, help string, extra data...
 977                 '$sitename'             => array('sitename', t("Site name"), $a->config['sitename'],''),
 978                 '$hostname'             => array('hostname', t("Host name"), $a->config['hostname'], ""),
 979                 '$sender_email'         => array('sender_email', t("Sender Email"), $a->config['sender_email'], t("The email address your server shall use to send notification emails from."), "", "", "email"),
 980                 '$banner'               => array('banner', t("Banner/Logo"), $banner, ""),
 981                 '$shortcut_icon'        => array('shortcut_icon', t("Shortcut icon"), get_config('system','shortcut_icon'),  t("Link to an icon that will be used for browsers.")),
 982                 '$touch_icon'           => array('touch_icon', t("Touch icon"), get_config('system','touch_icon'),  t("Link to an icon that will be used for tablets and mobiles.")),
 983                 '$info'                 => array('info',t('Additional Info'), $info, sprintf(t('For public servers: you can add additional information here that will be listed at %s/siteinfo.'), get_server())),
 984                 '$language'             => array('language', t("System language"), get_config('system','language'), "", $lang_choices),
 985                 '$theme'                => array('theme', t("System theme"), get_config('system','theme'), t("Default system theme - may be over-ridden by user profiles - <a href='#' id='cnftheme'>change theme settings</a>"), $theme_choices),
 986                 '$theme_mobile'         => array('theme_mobile', t("Mobile system theme"), get_config('system','mobile-theme'), t("Theme for mobile devices"), $theme_choices_mobile),
 987                 '$ssl_policy'           => array('ssl_policy', t("SSL link policy"), (string) intval(get_config('system','ssl_policy')), t("Determines whether generated links should be forced to use SSL"), $ssl_choices),
 988                 '$force_ssl'            => array('force_ssl', t("Force SSL"), get_config('system','force_ssl'), t("Force all Non-SSL requests to SSL - Attention: on some systems it could lead to endless loops.")),
 989                 '$old_share'            => array('old_share', t("Old style 'Share'"), get_config('system','old_share'), t("Deactivates the bbcode element 'share' for repeating items.")),
 990                 '$hide_help'            => array('hide_help', t("Hide help entry from navigation menu"), get_config('system','hide_help'), t("Hides the menu entry for the Help pages from the navigation menu. You can still access it calling /help directly.")),
 991                 '$singleuser'           => array('singleuser', t("Single user instance"), get_config('system','singleuser'), t("Make this instance multi-user or single-user for the named user"), $user_names),
 992                 '$maximagesize'         => array('maximagesize', t("Maximum image size"), get_config('system','maximagesize'), t("Maximum size in bytes of uploaded images. Default is 0, which means no limits.")),
 993                 '$maximagelength'       => array('maximagelength', t("Maximum image length"), get_config('system','max_image_length'), t("Maximum length in pixels of the longest side of uploaded images. Default is -1, which means no limits.")),
 994                 '$jpegimagequality'     => array('jpegimagequality', t("JPEG image quality"), get_config('system','jpeg_quality'), t("Uploaded JPEGS will be saved at this quality setting [0-100]. Default is 100, which is full quality.")),
 995
 996                 '$register_policy'      => array('register_policy', t("Register policy"), $a->config['register_policy'], "", $register_choices),
 997                 '$daily_registrations'  => array('max_daily_registrations', t("Maximum Daily Registrations"), get_config('system', 'max_daily_registrations'), t("If registration is permitted above, this sets the maximum number of new user registrations to accept per day.  If register is set to closed, this setting has no effect.")),
 998                 '$register_text'        => array('register_text', t("Register text"), $a->config['register_text'], t("Will be displayed prominently on the registration page.")),
 999                 '$abandon_days'         => array('abandon_days', t('Accounts abandoned after x days'), get_config('system','account_abandon_days'), t('Will not waste system resources polling external sites for abandonded accounts. Enter 0 for no time limit.')),
1000                 '$allowed_sites'        => array('allowed_sites', t("Allowed friend domains"), get_config('system','allowed_sites'), t("Comma separated list of domains which are allowed to establish friendships with this site. Wildcards are accepted. Empty to allow any domains")),
1001                 '$allowed_email'        => array('allowed_email', t("Allowed email domains"), get_config('system','allowed_email'), t("Comma separated list of domains which are allowed in email addresses for registrations to this site. Wildcards are accepted. Empty to allow any domains")),
1002                 '$block_public'         => array('block_public', t("Block public"), get_config('system','block_public'), t("Check to block public access to all otherwise public personal pages on this site unless you are currently logged in.")),
1003                 '$force_publish'        => array('publish_all', t("Force publish"), get_config('system','publish_all'), t("Check to force all profiles on this site to be listed in the site directory.")),
1004                 '$global_directory'     => array('directory', t("Global directory URL"), get_config('system','directory'), t("URL to the global directory. If this is not set, the global directory is completely unavailable to the application.")),
1005                 '$thread_allow'         => array('thread_allow', t("Allow threaded items"), get_config('system','thread_allow'), t("Allow infinite level threading for items on this site.")),
1006                 '$newuser_private'      => array('newuser_private', t("Private posts by default for new users"), get_config('system','newuser_private'), t("Set default post permissions for all new members to the default privacy group rather than public.")),
1007                 '$enotify_no_content'   => array('enotify_no_content', t("Don't include post content in email notifications"), get_config('system','enotify_no_content'), t("Don't include the content of a post/comment/private message/etc. in the email notifications that are sent out from this site, as a privacy measure.")),
1008                 '$private_addons'       => array('private_addons', t("Disallow public access to addons listed in the apps menu."), get_config('config','private_addons'), t("Checking this box will restrict addons listed in the apps menu to members only.")),
1009                 '$disable_embedded'     => array('disable_embedded', t("Don't embed private images in posts"), get_config('system','disable_embedded'), t("Don't replace locally-hosted private photos in posts with an embedded copy of the image. This means that contacts who receive posts containing private photos will have to authenticate and load each image, which may take a while.")),
1010                 '$allow_users_remote_self' => array('allow_users_remote_self', t('Allow Users to set remote_self'), get_config('system','allow_users_remote_self'), t('With checking this, every user is allowed to mark every contact as a remote_self in the repair contact dialog. Setting this flag on a contact causes mirroring every posting of that contact in the users stream.')),
1011                 '$no_multi_reg'         => array('no_multi_reg', t("Block multiple registrations"),  get_config('system','block_extended_register'), t("Disallow users to register additional accounts for use as pages.")),
1012                 '$no_openid'            => array('no_openid', t("OpenID support"), !get_config('system','no_openid'), t("OpenID support for registration and logins.")),
1013                 '$no_regfullname'       => array('no_regfullname', t("Fullname check"), !get_config('system','no_regfullname'), t("Force users to register with a space between firstname and lastname in Full name, as an antispam measure")),
1014                 '$no_utf'               => array('no_utf', t("UTF-8 Regular expressions"), !get_config('system','no_utf'), t("Use PHP UTF8 regular expressions")),
1015                 '$community_page_style' => array('community_page_style', t("Community Page Style"), get_config('system','community_page_style'), t("Type of community page to show. 'Global community' shows every public posting from an open distributed network that arrived on this server."), $community_page_style_choices),
1016                 '$max_author_posts_community_page' => array('max_author_posts_community_page', t("Posts per user on community page"), get_config('system','max_author_posts_community_page'), t("The maximum number of posts per user on the community page. (Not valid for 'Global Community')")),
1017                 '$ostatus_disabled'     => array('ostatus_disabled', t("Enable OStatus support"), !get_config('system','ostatus_disabled'), t("Provide built-in OStatus \x28StatusNet, GNU Social etc.\x29 compatibility. All communications in OStatus are public, so privacy warnings will be occasionally displayed.")),
1018                 '$ostatus_poll_interval' => array('ostatus_poll_interval', t("OStatus conversation completion interval"), (string) intval(get_config('system','ostatus_poll_interval')), t("How often shall the poller check for new entries in OStatus conversations? This can be a very ressource task."), $ostatus_poll_choices),
1019                 '$ostatus_full_threads' => array('ostatus_full_threads', t("Only import OStatus threads from our contacts"), get_config('system','ostatus_full_threads'), t("Normally we import every content from our OStatus contacts. With this option we only store threads that are started by a contact that is known on our system.")),
1020                 '$ostatus_not_able'     => t("OStatus support can only be enabled if threading is enabled."),
1021                 '$diaspora_able'        => $diaspora_able,
1022                 '$diaspora_not_able'    => t("Diaspora support can't be enabled because Friendica was installed into a sub directory."),
1023                 '$diaspora_enabled'     => array('diaspora_enabled', t("Enable Diaspora support"), get_config('system','diaspora_enabled'), t("Provide built-in Diaspora network compatibility.")),
1024                 '$dfrn_only'            => array('dfrn_only', t('Only allow Friendica contacts'), get_config('system','dfrn_only'), t("All contacts must use Friendica protocols. All other built-in communication protocols disabled.")),
1025                 '$verifyssl'            => array('verifyssl', t("Verify SSL"), get_config('system','verifyssl'), t("If you wish, you can turn on strict certificate checking. This will mean you cannot connect (at all) to self-signed SSL sites.")),
1026                 '$proxyuser'            => array('proxyuser', t("Proxy user"), get_config('system','proxyuser'), ""),
1027                 '$proxy'                => array('proxy', t("Proxy URL"), get_config('system','proxy'), ""),
1028                 '$timeout'              => array('timeout', t("Network timeout"), (x(get_config('system','curl_timeout'))?get_config('system','curl_timeout'):60), t("Value is in seconds. Set to 0 for unlimited (not recommended).")),
1029                 '$delivery_interval'    => array('delivery_interval', t("Delivery interval"), (x(get_config('system','delivery_interval'))?get_config('system','delivery_interval'):2), t("Delay background delivery processes by this many seconds to reduce system load. Recommend: 4-5 for shared hosts, 2-3 for virtual private servers. 0-1 for large dedicated servers.")),
1030                 '$poll_interval'        => array('poll_interval', t("Poll interval"), (x(get_config('system','poll_interval'))?get_config('system','poll_interval'):2), t("Delay background polling processes by this many seconds to reduce system load. If 0, use delivery interval.")),
1031                 '$maxloadavg'           => array('maxloadavg', t("Maximum Load Average"), ((intval(get_config('system','maxloadavg')) > 0)?get_config('system','maxloadavg'):50), t("Maximum system load before delivery and poll processes are deferred - default 50.")),
1032                 '$maxloadavg_frontend'  => array('maxloadavg_frontend', t("Maximum Load Average (Frontend)"), ((intval(get_config('system','maxloadavg_frontend')) > 0)?get_config('system','maxloadavg_frontend'):50), t("Maximum system load before the frontend quits service - default 50.")),
1033                 '$optimize_max_tablesize'=> array('optimize_max_tablesize', t("Maximum table size for optimization"), $optimize_max_tablesize, t("Maximum table size (in MB) for the automatic optimization - default 100 MB. Enter -1 to disable it.")),
1034                 '$optimize_fragmentation'=> array('optimize_fragmentation', t("Minimum level of fragmentation"), ((intval(get_config('system','optimize_fragmentation')) > 0)?get_config('system','optimize_fragmentation'):30), t("Minimum fragmenation level to start the automatic optimization - default value is 30%.")),
1035
1036                 '$poco_completion'      => array('poco_completion', t("Periodical check of global contacts"), get_config('system','poco_completion'), t("If enabled, the global contacts are checked periodically for missing or outdated data and the vitality of the contacts and servers.")),
1037                 '$poco_requery_days'    => array('poco_requery_days', t("Days between requery"), get_config('system','poco_requery_days'), t("Number of days after which a server is requeried for his contacts.")),
1038                 '$poco_discovery'       => array('poco_discovery', t("Discover contacts from other servers"), (string) intval(get_config('system','poco_discovery')), t("Periodically query other servers for contacts. You can choose between 'users': the users on the remote system, 'Global Contacts': active contacts that are known on the system. The fallback is meant for Redmatrix servers and older friendica servers, where global contacts weren't available. The fallback increases the server load, so the recommened setting is 'Users, Global Contacts'."), $poco_discovery_choices),
1039                 '$poco_discovery_since' => array('poco_discovery_since', t("Timeframe for fetching global contacts"), (string) intval(get_config('system','poco_discovery_since')), t("When the discovery is activated, this value defines the timeframe for the activity of the global contacts that are fetched from other servers."), $poco_discovery_since_choices),
1040                 '$poco_local_search'    => array('poco_local_search', t("Search the local directory"), get_config('system','poco_local_search'), t("Search the local directory instead of the global directory. When searching locally, every search will be executed on the global directory in the background. This improves the search results when the search is repeated.")),
1041
1042                 '$nodeinfo'             => array('nodeinfo', t("Publish server information"), get_config('system','nodeinfo'), t("If enabled, general server and usage data will be published. The data contains the name and version of the server, number of users with public profiles, number of posts and the activated protocols and connectors. See <a href='http://the-federation.info/'>the-federation.info</a> for details.")),
1043
1044                 '$use_fulltext_engine'  => array('use_fulltext_engine', t("Use MySQL full text engine"), get_config('system','use_fulltext_engine'), t("Activates the full text engine. Speeds up search - but can only search for four and more characters.")),
1045                 '$suppress_language'    => array('suppress_language', t("Suppress Language"), get_config('system','suppress_language'), t("Suppress language information in meta information about a posting.")),
1046                 '$suppress_tags'        => array('suppress_tags', t("Suppress Tags"), get_config('system','suppress_tags'), t("Suppress showing a list of hashtags at the end of the posting.")),
1047                 '$itemcache'            => array('itemcache', t("Path to item cache"), get_config('system','itemcache'), t("The item caches buffers generated bbcode and external images.")),
1048                 '$itemcache_duration'   => array('itemcache_duration', t("Cache duration in seconds"), get_config('system','itemcache_duration'), t("How long should the cache files be hold? Default value is 86400 seconds (One day). To disable the item cache, set the value to -1.")),
1049                 '$max_comments'         => array('max_comments', t("Maximum numbers of comments per post"), get_config('system','max_comments'), t("How much comments should be shown for each post? Default value is 100.")),
1050                 '$lockpath'             => array('lockpath', t("Path for lock file"), get_config('system','lockpath'), t("The lock file is used to avoid multiple pollers at one time. Only define a folder here.")),
1051                 '$temppath'             => array('temppath', t("Temp path"), get_config('system','temppath'), t("If you have a restricted system where the webserver can't access the system temp path, enter another path here.")),
1052                 '$basepath'             => array('basepath', t("Base path to installation"), get_config('system','basepath'), t("If the system cannot detect the correct path to your installation, enter the correct path here. This setting should only be set if you are using a restricted system and symbolic links to your webroot.")),
1053                 '$proxy_disabled'       => array('proxy_disabled', t("Disable picture proxy"), get_config('system','proxy_disabled'), t("The picture proxy increases performance and privacy. It shouldn't be used on systems with very low bandwith.")),
1054                 '$old_pager'            => array('old_pager', t("Enable old style pager"), get_config('system','old_pager'), t("The old style pager has page numbers but slows down massively the page speed.")),
1055                 '$only_tag_search'      => array('only_tag_search', t("Only search in tags"), get_config('system','only_tag_search'), t("On large systems the text search can slow down the system extremely.")),
1056
1057                 '$relocate_url'         => array('relocate_url', t("New base url"), App::get_baseurl(), t("Change base url for this server. Sends relocate message to all DFRN contacts of all users.")),
1058
1059                 '$rino'                 => array('rino', t("RINO Encryption"), intval(get_config('system','rino_encrypt')), t("Encryption layer between nodes."), array("Disabled", "RINO1 (deprecated)", "RINO2")),
1060                 '$embedly'              => array('embedly', t("Embedly API key"), get_config('system','embedly'), t("<a href='http://embed.ly'>Embedly</a> is used to fetch additional data for web pages. This is an optional parameter.")),
1061
1062                 '$worker'               => array('worker', t("Enable 'worker' background processing"), get_config('system','worker'), t("The worker background processing limits the number of parallel background jobs to a maximum number and respects the system load.")),
1063                 '$worker_queues'        => array('worker_queues', t("Maximum number of parallel workers"), get_config('system','worker_queues'), t("On shared hosters set this to 2. On larger systems, values of 10 are great. Default value is 4.")),
1064                 '$worker_dont_fork'     => array('worker_dont_fork', t("Don't use 'proc_open' with the worker"), get_config('system','worker_dont_fork'), t("Enable this if your system doesn't allow the use of 'proc_open'. This can happen on shared hosters. If this is enabled you should increase the frequency of poller calls in your crontab.")),
1065                 '$worker_fastlane'      => array('worker_fastlane', t("Enable fastlane"), get_config('system','worker_fastlane'), t("When enabed, the fastlane mechanism starts an additional worker if processes with higher priority are blocked by processes of lower priority.")),
1066                 '$worker_frontend'      => array('worker_frontend', t('Enable frontend worker'), get_config('system','frontend_worker'), t('When enabled the Worker process is triggered when backend access is performed (e.g. messages being delivered). On smaller sites you might want to call yourdomain.tld/worker on a regular basis via an external cron job. You should only enable this option if you cannot utilize cron/scheduled jobs on your server. The worker background process needs to be activated for this.')),
1067
1068                 '$form_security_token'  => get_form_security_token("admin_site")
1069
1070         ));
1071
1072 }
1073
1074 /**
1075  * @brief Generates admin panel subpage for DB syncronization
1076  *
1077  * This page checks if the database of friendica is in sync with the specs.
1078  * Should this not be the case, it attemps to sync the structure and notifies
1079  * the admin if the automatic process was failing.
1080  *
1081  * The returned string holds the HTML code of the page.
1082  *
1083  * @param App $a
1084  * @return string
1085  **/
1086 function admin_page_dbsync(App $a) {
1087
1088         $o = '';
1089
1090         if($a->argc > 3 && intval($a->argv[3]) && $a->argv[2] === 'mark') {
1091                 set_config('database', 'update_'.intval($a->argv[3]), 'success');
1092                 $curr = get_config('system','build');
1093                 if(intval($curr) == intval($a->argv[3]))
1094                         set_config('system','build',intval($curr) + 1);
1095                 info(t('Update has been marked successful').EOL);
1096                 goaway('admin/dbsync');
1097         }
1098
1099         if(($a->argc > 2) AND (intval($a->argv[2]) OR ($a->argv[2] === 'check'))) {
1100                 require_once("include/dbstructure.php");
1101                 $retval = update_structure(false, true);
1102                 if(!$retval) {
1103                         $o .= sprintf(t("Database structure update %s was successfully applied."), DB_UPDATE_VERSION)."<br />";
1104                         set_config('database', 'dbupdate_'.DB_UPDATE_VERSION, 'success');
1105                 } else
1106                         $o .= sprintf(t("Executing of database structure update %s failed with error: %s"),
1107                                         DB_UPDATE_VERSION, $retval)."<br />";
1108                 if($a->argv[2] === 'check')
1109                         return $o;
1110         }
1111
1112         if($a->argc > 2 && intval($a->argv[2])) {
1113                 require_once('update.php');
1114                 $func = 'update_'.intval($a->argv[2]);
1115                 if(function_exists($func)) {
1116                         $retval = $func();
1117                         if($retval === UPDATE_FAILED) {
1118                                 $o .= sprintf(t("Executing %s failed with error: %s"), $func, $retval);
1119                         }
1120                         elseif($retval === UPDATE_SUCCESS) {
1121                                 $o .= sprintf(t('Update %s was successfully applied.', $func));
1122                                 set_config('database',$func, 'success');
1123                         }
1124                         else
1125                                 $o .= sprintf(t('Update %s did not return a status. Unknown if it succeeded.'), $func);
1126                 } else {
1127                         $o .= sprintf(t('There was no additional update function %s that needed to be called.'), $func)."<br />";
1128                         set_config('database',$func, 'success');
1129                 }
1130                 return $o;
1131         }
1132
1133         $failed = array();
1134         $r = q("SELECT `k`, `v` FROM `config` WHERE `cat` = 'database' ");
1135         if (dbm::is_result($r)) {
1136                 foreach ($r as $rr) {
1137                         $upd = intval(substr($rr['k'],7));
1138                         if($upd < 1139 || $rr['v'] === 'success')
1139                                 continue;
1140                         $failed[] = $upd;
1141                 }
1142         }
1143         if (! count($failed)) {
1144                 $o = replace_macros(get_markup_template('structure_check.tpl'),array(
1145                         '$base'   => App::get_baseurl(true),
1146                         '$banner' => t('No failed updates.'),
1147                         '$check'  => t('Check database structure'),
1148                 ));
1149         } else {
1150                 $o = replace_macros(get_markup_template('failed_updates.tpl'),array(
1151                         '$base'   => App::get_baseurl(true),
1152                         '$banner' => t('Failed Updates'),
1153                         '$desc'   => t('This does not include updates prior to 1139, which did not return a status.'),
1154                         '$mark'   => t('Mark success (if update was manually applied)'),
1155                         '$apply'  => t('Attempt to execute this update step automatically'),
1156                         '$failed' => $failed
1157                 ));
1158         }
1159
1160         return $o;
1161
1162 }
1163
1164 /**
1165  * @brief Process data send by Users admin page
1166  *
1167  * @param App $a
1168  */
1169 function admin_page_users_post(App $a) {
1170         $pending     = (x($_POST, 'pending')           ? $_POST['pending']           : array());
1171         $users       = (x($_POST, 'user')              ? $_POST['user']               : array());
1172         $nu_name     = (x($_POST, 'new_user_name')     ? $_POST['new_user_name']     : '');
1173         $nu_nickname = (x($_POST, 'new_user_nickname') ? $_POST['new_user_nickname'] : '');
1174         $nu_email    = (x($_POST, 'new_user_email')    ? $_POST['new_user_email']    : '');
1175         $nu_language = get_config('system', 'language');
1176
1177         check_form_security_token_redirectOnErr('/admin/users', 'admin_users');
1178
1179         if (!($nu_name==="") && !($nu_email==="") && !($nu_nickname==="")) {
1180                 require_once('include/user.php');
1181
1182                 $result = create_user(array('username'=>$nu_name, 'email'=>$nu_email,
1183                         'nickname'=>$nu_nickname, 'verified'=>1, 'language'=>$nu_language));
1184                 if (! $result['success']) {
1185                         notice($result['message']);
1186                         return;
1187                 }
1188                 $nu = $result['user'];
1189                 $preamble = deindent(t('
1190                         Dear %1$s,
1191                                 the administrator of %2$s has set up an account for you.'));
1192                 $body = deindent(t('
1193                         The login details are as follows:
1194
1195                         Site Location:  %1$s
1196                         Login Name:             %2$s
1197                         Password:               %3$s
1198
1199                         You may change your password from your account "Settings" page after logging
1200                         in.
1201
1202                         Please take a few moments to review the other account settings on that page.
1203
1204                         You may also wish to add some basic information to your default profile
1205                         (on the "Profiles" page) so that other people can easily find you.
1206
1207                         We recommend setting your full name, adding a profile photo,
1208                         adding some profile "keywords" (very useful in making new friends) - and
1209                         perhaps what country you live in; if you do not wish to be more specific
1210                         than that.
1211
1212                         We fully respect your right to privacy, and none of these items are necessary.
1213                         If you are new and do not know anybody here, they may help
1214                         you to make some new and interesting friends.
1215
1216                         Thank you and welcome to %4$s.'));
1217
1218                 $preamble = sprintf($preamble, $nu['username'], $a->config['sitename']);
1219                 $body = sprintf($body, App::get_baseurl(), $nu['email'], $result['password'], $a->config['sitename']);
1220
1221                 notification(array(
1222                         'type' => "SYSTEM_EMAIL",
1223                         'to_email' => $nu['email'],
1224                         'subject'=> sprintf(t('Registration details for %s'), $a->config['sitename']),
1225                         'preamble'=> $preamble,
1226                         'body' => $body));
1227
1228         }
1229
1230         if(x($_POST,'page_users_block')) {
1231                 foreach($users as $uid){
1232                         q("UPDATE `user` SET `blocked` = 1-`blocked` WHERE `uid` = %s",
1233                                 intval($uid)
1234                         );
1235                 }
1236                 notice(sprintf(tt("%s user blocked/unblocked", "%s users blocked/unblocked", count($users)), count($users)));
1237         }
1238         if(x($_POST,'page_users_delete')) {
1239                 require_once("include/Contact.php");
1240                 foreach($users as $uid){
1241                         user_remove($uid);
1242                 }
1243                 notice(sprintf(tt("%s user deleted", "%s users deleted", count($users)), count($users)));
1244         }
1245
1246         if(x($_POST,'page_users_approve')) {
1247                 require_once("mod/regmod.php");
1248                 foreach($pending as $hash){
1249                         user_allow($hash);
1250                 }
1251         }
1252         if(x($_POST,'page_users_deny')) {
1253                 require_once("mod/regmod.php");
1254                 foreach($pending as $hash){
1255                         user_deny($hash);
1256                 }
1257         }
1258         goaway('admin/users');
1259         return; // NOTREACHED
1260 }
1261
1262 /**
1263  * @brief Admin panel subpage for User management
1264  *
1265  * This function generates the admin panel page for user management of the
1266  * node. It offers functionality to add/block/delete users and offers some
1267  * statistics about the userbase.
1268  *
1269  * The returned string holds the HTML code of the page.
1270  *
1271  * @param App $a
1272  * @return string
1273  */
1274 function admin_page_users(App $a) {
1275         if($a->argc>2) {
1276                 $uid = $a->argv[3];
1277                 $user = q("SELECT `username`, `blocked` FROM `user` WHERE `uid` = %d", intval($uid));
1278                 if(count($user)==0) {
1279                         notice('User not found'.EOL);
1280                         goaway('admin/users');
1281                         return ''; // NOTREACHED
1282                 }
1283                 switch($a->argv[2]){
1284                         case "delete":{
1285                                 check_form_security_token_redirectOnErr('/admin/users', 'admin_users', 't');
1286                                 // delete user
1287                                 require_once("include/Contact.php");
1288                                 user_remove($uid);
1289
1290                                 notice(sprintf(t("User '%s' deleted"), $user[0]['username']).EOL);
1291                         }; break;
1292                         case "block":{
1293                                 check_form_security_token_redirectOnErr('/admin/users', 'admin_users', 't');
1294                                 q("UPDATE `user` SET `blocked` = %d WHERE `uid` = %s",
1295                                         intval(1-$user[0]['blocked']),
1296                                         intval($uid)
1297                                 );
1298                                 notice(sprintf(($user[0]['blocked']?t("User '%s' unblocked"):t("User '%s' blocked")) , $user[0]['username']).EOL);
1299                         }; break;
1300                 }
1301                 goaway('admin/users');
1302                 return ''; // NOTREACHED
1303
1304         }
1305
1306         /* get pending */
1307         $pending = q("SELECT `register`.*, `contact`.`name`, `user`.`email`
1308                                  FROM `register`
1309                                  LEFT JOIN `contact` ON `register`.`uid` = `contact`.`uid`
1310                                  LEFT JOIN `user` ON `register`.`uid` = `user`.`uid`;");
1311
1312
1313         /* get users */
1314         $total = qu("SELECT COUNT(*) AS `total` FROM `user` WHERE 1");
1315         if(count($total)) {
1316                 $a->set_pager_total($total[0]['total']);
1317                 $a->set_pager_itemspage(100);
1318         }
1319
1320         /* ordering */
1321         $valid_orders = array(
1322                 'contact.name',
1323                 'user.email',
1324                 'user.register_date',
1325                 'user.login_date',
1326                 'lastitem_date',
1327                 'user.page-flags'
1328         );
1329
1330         $order = "contact.name";
1331         $order_direction = "+";
1332         if (x($_GET,'o')){
1333                 $new_order = $_GET['o'];
1334                 if ($new_order[0]==="-") {
1335                         $order_direction = "-";
1336                         $new_order = substr($new_order,1);
1337                 }
1338
1339                 if (in_array($new_order, $valid_orders)){
1340                         $order = $new_order;
1341                 }
1342                 if (x($_GET,'d')){
1343                         $new_direction = $_GET['d'];
1344                 }
1345         }
1346         $sql_order = "`".str_replace('.','`.`',$order)."`";
1347         $sql_order_direction = ($order_direction==="+")?"ASC":"DESC";
1348
1349         $users = qu("SELECT `user`.*, `contact`.`name`, `contact`.`url`, `contact`.`micro`, `user`.`account_expired`, `contact`.`last-item` AS `lastitem_date`
1350                                 FROM `user`
1351                                 INNER JOIN `contact` ON `contact`.`uid` = `user`.`uid` AND `contact`.`self`
1352                                 WHERE `user`.`verified`
1353                                 ORDER BY $sql_order $sql_order_direction LIMIT %d, %d",
1354                                 intval($a->pager['start']),
1355                                 intval($a->pager['itemspage'])
1356                                 );
1357
1358         //echo "<pre>$users"; killme();
1359
1360         $adminlist = explode(",", str_replace(" ", "", $a->config['admin_email']));
1361         $_setup_users = function ($e) use ($adminlist){
1362                 $accounts = array(
1363                         t('Normal Account'),
1364                         t('Soapbox Account'),
1365                         t('Community/Celebrity Account'),
1366                                                 t('Automatic Friend Account')
1367                 );
1368                 $e['page-flags'] = $accounts[$e['page-flags']];
1369                 $e['register_date'] = relative_date($e['register_date']);
1370                 $e['login_date'] = relative_date($e['login_date']);
1371                 $e['lastitem_date'] = relative_date($e['lastitem_date']);
1372                 //$e['is_admin'] = ($e['email'] === $a->config['admin_email']);
1373                 $e['is_admin'] = in_array($e['email'], $adminlist);
1374                 $e['is_deletable'] = (intval($e['uid']) != local_user());
1375                 $e['deleted'] = ($e['account_removed']?relative_date($e['account_expires_on']):False);
1376                 return $e;
1377         };
1378         $users = array_map($_setup_users, $users);
1379
1380
1381         // Get rid of dashes in key names, Smarty3 can't handle them
1382         // and extracting deleted users
1383
1384         $tmp_users = array();
1385         $deleted = array();
1386
1387         while(count($users)) {
1388                 $new_user = array();
1389                 foreach(array_pop($users) as $k => $v) {
1390                         $k = str_replace('-','_',$k);
1391                         $new_user[$k] = $v;
1392                 }
1393                 if($new_user['deleted']) {
1394                         array_push($deleted, $new_user);
1395                 }
1396                 else {
1397                         array_push($tmp_users, $new_user);
1398                 }
1399         }
1400         //Reversing the two array, and moving $tmp_users to $users
1401         array_reverse($deleted);
1402         while(count($tmp_users)) {
1403                 array_push($users, array_pop($tmp_users));
1404         }
1405
1406         $th_users = array_map(null,
1407                 array(t('Name'), t('Email'), t('Register date'), t('Last login'), t('Last item'),  t('Account')),
1408                 $valid_orders
1409         );
1410
1411         $t = get_markup_template("admin_users.tpl");
1412         $o = replace_macros($t, array(
1413                 // strings //
1414                 '$title' => t('Administration'),
1415                 '$page' => t('Users'),
1416                 '$submit' => t('Add User'),
1417                 '$select_all' => t('select all'),
1418                 '$h_pending' => t('User registrations waiting for confirm'),
1419                 '$h_deleted' => t('User waiting for permanent deletion'),
1420                 '$th_pending' => array(t('Request date'), t('Name'), t('Email')),
1421                 '$no_pending' =>  t('No registrations.'),
1422                 '$pendingnotetext' => t('Note from the user'),
1423                 '$approve' => t('Approve'),
1424                 '$deny' => t('Deny'),
1425                 '$delete' => t('Delete'),
1426                 '$block' => t('Block'),
1427                 '$unblock' => t('Unblock'),
1428                 '$siteadmin' => t('Site admin'),
1429                 '$accountexpired' => t('Account expired'),
1430
1431                 '$h_users' => t('Users'),
1432                 '$h_newuser' => t('New User'),
1433                 '$th_deleted' => array(t('Name'), t('Email'), t('Register date'), t('Last login'), t('Last item'), t('Deleted since')),
1434                 '$th_users' => $th_users,
1435                 '$order_users' => $order,
1436                 '$order_direction_users' => $order_direction,
1437
1438                 '$confirm_delete_multi' => t('Selected users will be deleted!\n\nEverything these users had posted on this site will be permanently deleted!\n\nAre you sure?'),
1439                 '$confirm_delete' => t('The user {0} will be deleted!\n\nEverything this user has posted on this site will be permanently deleted!\n\nAre you sure?'),
1440
1441                 '$form_security_token' => get_form_security_token("admin_users"),
1442
1443                 // values //
1444                 '$baseurl' => App::get_baseurl(true),
1445
1446                 '$pending' => $pending,
1447                 'deleted' => $deleted,
1448                 '$users' => $users,
1449                 '$newusername' => array('new_user_name', t("Name"), '', t("Name of the new user.")),
1450                 '$newusernickname' => array('new_user_nickname', t("Nickname"), '', t("Nickname of the new user.")),
1451                 '$newuseremail' => array('new_user_email', t("Email"), '', t("Email address of the new user."), '', '', 'email'),
1452         ));
1453         $o .= paginate($a);
1454         return $o;
1455 }
1456
1457
1458 /**
1459  * @brief Plugins admin page
1460  *
1461  * This function generates the admin panel page for managing plugins on the
1462  * friendica node. If a plugin name is given a single page showing the details
1463  * for this addon is generated. If no name is given, a list of available
1464  * plugins is shown.
1465  *
1466  * The template used for displaying the list of plugins and the details of the
1467  * plugin are the same as used for the templates.
1468  *
1469  * The returned string returned hulds the HTML code of the page.
1470  *
1471  * @param App $a
1472  * @return string
1473  */
1474 function admin_page_plugins(App $a) {
1475
1476         /*
1477          * Single plugin
1478          */
1479         if($a->argc == 3) {
1480                 $plugin = $a->argv[2];
1481                 if(!is_file("addon/$plugin/$plugin.php")) {
1482                         notice(t("Item not found."));
1483                         return '';
1484                 }
1485
1486                 if(x($_GET,"a") && $_GET['a']=="t") {
1487                         check_form_security_token_redirectOnErr('/admin/plugins', 'admin_themes', 't');
1488
1489                         // Toggle plugin status
1490                         $idx = array_search($plugin, $a->plugins);
1491                         if($idx !== false) {
1492                                 unset($a->plugins[$idx]);
1493                                 uninstall_plugin($plugin);
1494                                 info(sprintf(t("Plugin %s disabled."), $plugin));
1495                         } else {
1496                                 $a->plugins[] = $plugin;
1497                                 install_plugin($plugin);
1498                                 info(sprintf(t("Plugin %s enabled."), $plugin));
1499                         }
1500                         set_config("system","addon", implode(", ",$a->plugins));
1501                         goaway('admin/plugins');
1502                         return ''; // NOTREACHED
1503                 }
1504
1505                 // display plugin details
1506                 require_once('library/markdown.php');
1507
1508                 if(in_array($plugin, $a->plugins)) {
1509                         $status="on"; $action= t("Disable");
1510                 } else {
1511                         $status="off"; $action= t("Enable");
1512                 }
1513
1514                 $readme=Null;
1515                 if(is_file("addon/$plugin/README.md")) {
1516                         $readme = file_get_contents("addon/$plugin/README.md");
1517                         $readme = Markdown($readme);
1518                 } elseif(is_file("addon/$plugin/README")) {
1519                         $readme = "<pre>". file_get_contents("addon/$plugin/README") ."</pre>";
1520                 }
1521
1522                 $admin_form="";
1523                 if(is_array($a->plugins_admin) && in_array($plugin, $a->plugins_admin)) {
1524                         @require_once("addon/$plugin/$plugin.php");
1525                         $func = $plugin.'_plugin_admin';
1526                         $func($a, $admin_form);
1527                 }
1528
1529                 $t = get_markup_template("admin_plugins_details.tpl");
1530
1531                 return replace_macros($t, array(
1532                         '$title' => t('Administration'),
1533                         '$page' => t('Plugins'),
1534                         '$toggle' => t('Toggle'),
1535                         '$settings' => t('Settings'),
1536                         '$baseurl' => App::get_baseurl(true),
1537
1538                         '$plugin' => $plugin,
1539                         '$status' => $status,
1540                         '$action' => $action,
1541                         '$info' => get_plugin_info($plugin),
1542                         '$str_author' => t('Author: '),
1543                         '$str_maintainer' => t('Maintainer: '),
1544
1545                         '$admin_form' => $admin_form,
1546                         '$function' => 'plugins',
1547                         '$screenshot' => '',
1548                         '$readme' => $readme,
1549
1550                         '$form_security_token' => get_form_security_token("admin_themes"),
1551                 ));
1552         }
1553
1554
1555
1556         /*
1557          * List plugins
1558          */
1559
1560         if (x($_GET,"a") && $_GET['a']=="r") {
1561                 check_form_security_token_redirectOnErr(App::get_baseurl().'/admin/plugins', 'admin_themes', 't');
1562                 reload_plugins();
1563                 info("Plugins reloaded");
1564                 goaway(App::get_baseurl().'/admin/plugins');
1565         }
1566
1567         $plugins = array();
1568         $files = glob("addon/*/");
1569         if ($files) {
1570                 foreach ($files as $file) {
1571                         if (is_dir($file)) {
1572                                 list($tmp, $id)=array_map("trim", explode("/",$file));
1573                                 $info = get_plugin_info($id);
1574                                 $show_plugin = true;
1575
1576                                 // If the addon is unsupported, then only show it, when it is enabled
1577                                 if ((strtolower($info["status"]) == "unsupported") AND !in_array($id,  $a->plugins)) {
1578                                         $show_plugin = false;
1579                                 }
1580
1581                                 // Override the above szenario, when the admin really wants to see outdated stuff
1582                                 if (get_config("system", "show_unsupported_addons")) {
1583                                         $show_plugin = true;
1584                                 }
1585
1586                                 if ($show_plugin) {
1587                                         $plugins[] = array($id, (in_array($id,  $a->plugins)?"on":"off") , $info);
1588                                 }
1589                         }
1590                 }
1591         }
1592
1593         $t = get_markup_template("admin_plugins.tpl");
1594         return replace_macros($t, array(
1595                 '$title' => t('Administration'),
1596                 '$page' => t('Plugins'),
1597                 '$submit' => t('Save Settings'),
1598                 '$reload' => t('Reload active plugins'),
1599                 '$baseurl' => App::get_baseurl(true),
1600                 '$function' => 'plugins',
1601                 '$plugins' => $plugins,
1602                 '$pcount' => count($plugins),
1603                 '$noplugshint' => sprintf(t('There are currently no plugins available on your node. You can find the official plugin repository at %1$s and might find other interesting plugins in the open plugin registry at %2$s'), 'https://github.com/friendica/friendica-addons', 'http://addons.friendi.ca'),
1604                 '$form_security_token' => get_form_security_token("admin_themes"),
1605         ));
1606 }
1607
1608 /**
1609  * @param array $themes
1610  * @param string $th
1611  * @param int $result
1612  */
1613 function toggle_theme(&$themes,$th,&$result) {
1614         for($x = 0; $x < count($themes); $x ++) {
1615                 if($themes[$x]['name'] === $th) {
1616                         if($themes[$x]['allowed']) {
1617                                 $themes[$x]['allowed'] = 0;
1618                                 $result = 0;
1619                         }
1620                         else {
1621                                 $themes[$x]['allowed'] = 1;
1622                                 $result = 1;
1623                         }
1624                 }
1625         }
1626 }
1627
1628 /**
1629  * @param array $themes
1630  * @param string $th
1631  * @return int
1632  */
1633 function theme_status($themes,$th) {
1634         for($x = 0; $x < count($themes); $x ++) {
1635                 if($themes[$x]['name'] === $th) {
1636                         if($themes[$x]['allowed']) {
1637                                 return 1;
1638                         }
1639                         else {
1640                                 return 0;
1641                         }
1642                 }
1643         }
1644         return 0;
1645 }
1646
1647
1648 /**
1649  * @param array $themes
1650  * @return string
1651  */
1652 function rebuild_theme_table($themes) {
1653         $o = '';
1654         if(count($themes)) {
1655                 foreach($themes as $th) {
1656                         if($th['allowed']) {
1657                                 if(strlen($o))
1658                                         $o .= ',';
1659                                 $o .= $th['name'];
1660                         }
1661                 }
1662         }
1663         return $o;
1664 }
1665
1666
1667 /**
1668  * @brief Themes admin page
1669  *
1670  * This function generates the admin panel page to control the themes available
1671  * on the friendica node. If the name of a theme is given as parameter a page
1672  * with the details for the theme is shown. Otherwise a list of available
1673  * themes is generated.
1674  *
1675  * The template used for displaying the list of themes and the details of the
1676  * themes are the same as used for the plugins.
1677  *
1678  * The returned string contains the HTML code of the admin panel page.
1679  *
1680  * @param App $a
1681  * @return string
1682  */
1683 function admin_page_themes(App $a) {
1684
1685         $allowed_themes_str = get_config('system','allowed_themes');
1686         $allowed_themes_raw = explode(',',$allowed_themes_str);
1687         $allowed_themes = array();
1688         if(count($allowed_themes_raw))
1689                 foreach($allowed_themes_raw as $x)
1690                         if(strlen(trim($x)))
1691                                 $allowed_themes[] = trim($x);
1692
1693         $themes = array();
1694         $files = glob('view/theme/*');
1695         if($files) {
1696                 foreach($files as $file) {
1697                         $f = basename($file);
1698                         $is_experimental = intval(file_exists($file.'/experimental'));
1699                         $is_supported = 1-(intval(file_exists($file.'/unsupported')));
1700                         $is_allowed = intval(in_array($f,$allowed_themes));
1701
1702                         if($is_allowed OR $is_supported OR get_config("system", "show_unsupported_themes"))
1703                                 $themes[] = array('name' => $f, 'experimental' => $is_experimental, 'supported' => $is_supported, 'allowed' => $is_allowed);
1704                 }
1705         }
1706
1707         if(! count($themes)) {
1708                 notice(t('No themes found.'));
1709                 return '';
1710         }
1711
1712         /*
1713          * Single theme
1714          */
1715
1716         if($a->argc == 3) {
1717                 $theme = $a->argv[2];
1718                 if(! is_dir("view/theme/$theme")) {
1719                         notice(t("Item not found."));
1720                         return '';
1721                 }
1722
1723                 if(x($_GET,"a") && $_GET['a']=="t") {
1724                         check_form_security_token_redirectOnErr('/admin/themes', 'admin_themes', 't');
1725
1726                         // Toggle theme status
1727
1728                         toggle_theme($themes,$theme,$result);
1729                         $s = rebuild_theme_table($themes);
1730                         if($result) {
1731                                 install_theme($theme);
1732                                 info(sprintf('Theme %s enabled.',$theme));
1733                         }
1734                         else {
1735                                 uninstall_theme($theme);
1736                                 info(sprintf('Theme %s disabled.',$theme));
1737                         }
1738
1739                         set_config('system','allowed_themes',$s);
1740                         goaway('admin/themes');
1741                         return ''; // NOTREACHED
1742                 }
1743
1744                 // display theme details
1745                 require_once('library/markdown.php');
1746
1747                 if(theme_status($themes,$theme)) {
1748                         $status="on"; $action= t("Disable");
1749                 } else {
1750                         $status="off"; $action= t("Enable");
1751                 }
1752
1753                 $readme=Null;
1754                 if(is_file("view/theme/$theme/README.md")) {
1755                         $readme = file_get_contents("view/theme/$theme/README.md");
1756                         $readme = Markdown($readme);
1757                 } elseif(is_file("view/theme/$theme/README")) {
1758                         $readme = "<pre>". file_get_contents("view/theme/$theme/README") ."</pre>";
1759                 }
1760
1761                 $admin_form="";
1762                 if(is_file("view/theme/$theme/config.php")) {
1763                         function __get_theme_admin_form(App $a, $theme) {
1764                                 $orig_theme = $a->theme;
1765                                 $orig_page = $a->page;
1766                                 $orig_session_theme = $_SESSION['theme'];
1767                                 require_once("view/theme/$theme/theme.php");
1768                                 require_once("view/theme/$theme/config.php");
1769                                 $_SESSION['theme'] = $theme;
1770
1771
1772                                 $init = $theme."_init";
1773                                 if(function_exists($init)) $init($a);
1774                                 if(function_exists("theme_admin")) {
1775                                         $admin_form = theme_admin($a);
1776                                 }
1777
1778                                 $_SESSION['theme'] = $orig_session_theme;
1779                                 $a->theme = $orig_theme;
1780                                 $a->page = $orig_page;
1781                                 return $admin_form;
1782                         }
1783                         $admin_form = __get_theme_admin_form($a, $theme);
1784                 }
1785
1786                 $screenshot = array(get_theme_screenshot($theme), t('Screenshot'));
1787                 if(! stristr($screenshot[0],$theme))
1788                         $screenshot = null;
1789
1790
1791                 $t = get_markup_template("admin_plugins_details.tpl");
1792                 return replace_macros($t, array(
1793                         '$title' => t('Administration'),
1794                         '$page' => t('Themes'),
1795                         '$toggle' => t('Toggle'),
1796                         '$settings' => t('Settings'),
1797                         '$baseurl' => App::get_baseurl(true),
1798                         '$plugin' => $theme,
1799                         '$status' => $status,
1800                         '$action' => $action,
1801                         '$info' => get_theme_info($theme),
1802                         '$function' => 'themes',
1803                         '$admin_form' => $admin_form,
1804                         '$str_author' => t('Author: '),
1805                         '$str_maintainer' => t('Maintainer: '),
1806                         '$screenshot' => $screenshot,
1807                         '$readme' => $readme,
1808
1809                         '$form_security_token' => get_form_security_token("admin_themes"),
1810                 ));
1811         }
1812
1813
1814         // reload active themes
1815         if (x($_GET,"a") && $_GET['a']=="r") {
1816                 check_form_security_token_redirectOnErr(App::get_baseurl().'/admin/themes', 'admin_themes', 't');
1817                 if ($themes) {
1818                         foreach ($themes as $th) {
1819                                 if ($th['allowed']) {
1820                                         uninstall_theme($th['name']);
1821                                         install_theme($th['name']);
1822                                 }
1823                         }
1824                 }
1825                 info("Themes reloaded");
1826                 goaway(App::get_baseurl().'/admin/themes');
1827         }
1828
1829         /*
1830          * List themes
1831          */
1832
1833         $xthemes = array();
1834         if ($themes) {
1835                 foreach($themes as $th) {
1836                         $xthemes[] = array($th['name'],(($th['allowed']) ? "on" : "off"), get_theme_info($th['name']));
1837                 }
1838         }
1839
1840
1841         $t = get_markup_template("admin_plugins.tpl");
1842         return replace_macros($t, array(
1843                 '$title'               => t('Administration'),
1844                 '$page'                => t('Themes'),
1845                 '$submit'              => t('Save Settings'),
1846                 '$reload'              => t('Reload active themes'),
1847                 '$baseurl'             => App::get_baseurl(true),
1848                 '$function'            => 'themes',
1849                 '$plugins'             => $xthemes,
1850                 '$pcount'              => count($themes),
1851                 '$noplugshint'         => sprintf(t('No themes found on the system. They should be paced in %1$s'),'<code>/view/themes</code>'),
1852                 '$experimental'        => t('[Experimental]'),
1853                 '$unsupported'         => t('[Unsupported]'),
1854                 '$form_security_token' => get_form_security_token("admin_themes"),
1855         ));
1856 }
1857
1858
1859 /**
1860  * @brief Prosesses data send by Logs admin page
1861  *
1862  * @param App $a
1863  */
1864 function admin_page_logs_post(App $a) {
1865         if (x($_POST,"page_logs")) {
1866                 check_form_security_token_redirectOnErr('/admin/logs', 'admin_logs');
1867
1868                 $logfile   = ((x($_POST,'logfile'))   ? notags(trim($_POST['logfile']))  : '');
1869                 $debugging = ((x($_POST,'debugging')) ? true                             : false);
1870                 $loglevel  = ((x($_POST,'loglevel'))  ? intval(trim($_POST['loglevel'])) : 0);
1871
1872                 set_config('system','logfile', $logfile);
1873                 set_config('system','debugging',  $debugging);
1874                 set_config('system','loglevel', $loglevel);
1875         }
1876
1877         info(t("Log settings updated."));
1878         goaway('admin/logs');
1879         return; // NOTREACHED
1880 }
1881
1882 /**
1883  * @brief Generates admin panel subpage for configuration of the logs
1884  *
1885  * This function take the view/templates/admin_logs.tpl file and generates a
1886  * page where admin can configure the logging of friendica.
1887  *
1888  * Displaying the log is separated from the log config as the logfile can get
1889  * big depending on the settings and changing settings regarding the logs can
1890  * thus waste bandwidth.
1891  *
1892  * The string returned contains the content of the template file with replaced
1893  * macros.
1894  *
1895  * @param App $a
1896  * @return string
1897  */
1898 function admin_page_logs(App $a) {
1899
1900         $log_choices = array(
1901                 LOGGER_NORMAL   => 'Normal',
1902                 LOGGER_TRACE    => 'Trace',
1903                 LOGGER_DEBUG    => 'Debug',
1904                 LOGGER_DATA     => 'Data',
1905                 LOGGER_ALL      => 'All'
1906         );
1907
1908         if (ini_get('log_errors')) {
1909                 $phplogenabled = t('PHP log currently enabled.');
1910         } else {
1911                 $phplogenabled = t('PHP log currently disabled.');
1912         }
1913
1914         $t = get_markup_template("admin_logs.tpl");
1915
1916         return replace_macros($t, array(
1917                 '$title' => t('Administration'),
1918                 '$page' => t('Logs'),
1919                 '$submit' => t('Save Settings'),
1920                 '$clear' => t('Clear'),
1921                 '$baseurl' => App::get_baseurl(true),
1922                 '$logname' =>  get_config('system','logfile'),
1923
1924                 // name, label, value, help string, extra data...
1925                 '$debugging' => array('debugging', t("Enable Debugging"),get_config('system','debugging'), ""),
1926                 '$logfile' => array('logfile', t("Log file"), get_config('system','logfile'), t("Must be writable by web server. Relative to your Friendica top-level directory.")),
1927                 '$loglevel' => array('loglevel', t("Log level"), get_config('system','loglevel'), "", $log_choices),
1928
1929                 '$form_security_token' => get_form_security_token("admin_logs"),
1930                 '$phpheader' => t("PHP logging"),
1931                 '$phphint' => t("To enable logging of PHP errors and warnings you can add the following to the .htconfig.php file of your installation. The filename set in the 'error_log' line is relative to the friendica top-level directory and must be writeable by the web server. The option '1' for 'log_errors' and 'display_errors' is to enable these options, set to '0' to disable them."),
1932                 '$phplogcode' => "error_reporting(E_ERROR | E_WARNING | E_PARSE);\nini_set('error_log','php.out');\nini_set('log_errors','1');\nini_set('display_errors', '1');",
1933                 '$phplogenabled' => $phplogenabled,
1934         ));
1935 }
1936
1937 /**
1938  * @brief Generates admin panel subpage to view the Friendica log
1939  *
1940  * This function loads the template view/templates/admin_viewlogs.tpl to
1941  * display the systemlog content. The filename for the systemlog of friendica
1942  * is relative to the base directory and taken from the config entry 'logfile'
1943  * in the 'system' category.
1944  *
1945  * Displaying the log is separated from the log config as the logfile can get
1946  * big depending on the settings and changing settings regarding the logs can
1947  * thus waste bandwidth.
1948  *
1949  * The string returned contains the content of the template file with replaced
1950  * macros.
1951  *
1952  * @param App $a
1953  * @return string
1954  */
1955 function admin_page_viewlogs(App $a) {
1956         $t = get_markup_template("admin_viewlogs.tpl");
1957         $f = get_config('system','logfile');
1958         $data = '';
1959
1960         if(!file_exists($f)) {
1961                 $data = t("Error trying to open <strong>$f</strong> log file.\r\n<br/>Check to see if file $f exist and is readable.");
1962         }
1963         else {
1964                 $fp = fopen($f, 'r');
1965                 if(!$fp) {
1966                         $data = t("Couldn't open <strong>$f</strong> log file.\r\n<br/>Check to see if file $f is readable.");
1967                 }
1968                 else {
1969                         $fstat = fstat($fp);
1970                         $size = $fstat['size'];
1971                         if($size != 0) {
1972                                 if($size > 5000000 || $size < 0)
1973                                         $size = 5000000;
1974                                 $seek = fseek($fp,0-$size,SEEK_END);
1975                                 if($seek === 0) {
1976                                         $data = escape_tags(fread($fp,$size));
1977                                         while(! feof($fp))
1978                                                 $data .= escape_tags(fread($fp,4096));
1979                                 }
1980                         }
1981                         fclose($fp);
1982                 }
1983         }
1984         return replace_macros($t, array(
1985                 '$title' => t('Administration'),
1986                 '$page' => t('View Logs'),
1987                 '$data' => $data,
1988                 '$logname' =>  get_config('system','logfile')
1989         ));
1990 }
1991
1992 /**
1993  * @brief Prosesses data send by the features admin page
1994  *
1995  * @param App $a
1996  */
1997 function admin_page_features_post(App $a) {
1998
1999         check_form_security_token_redirectOnErr('/admin/features', 'admin_manage_features');
2000
2001         logger('postvars: '.print_r($_POST,true),LOGGER_DATA);
2002
2003         $arr = array();
2004         $features = get_features(false);
2005
2006         foreach($features as $fname => $fdata) {
2007                 foreach(array_slice($fdata,1) as $f) {
2008                         $feature = $f[0];
2009                         $feature_state = 'feature_'.$feature;
2010                         $featurelock = 'featurelock_'.$feature;
2011
2012                         if(x($_POST[$feature_state]))
2013                                 $val = intval($_POST['feature_'.$feature]);
2014                         else
2015                                 $val = 0;
2016                         set_config('feature',$feature,$val);
2017
2018                         if(x($_POST[$featurelock]))
2019                                 set_config('feature_lock',$feature,$val);
2020                         else
2021                                 del_config('feature_lock',$feature);
2022                 }
2023         }
2024
2025         goaway('admin/features');
2026         return; // NOTREACHED
2027 }
2028
2029 /**
2030  * @brief Subpage for global additional feature management
2031  *
2032  * This functin generates the subpage 'Manage Additional Features'
2033  * for the admin panel. At this page the admin can set preferences
2034  * for the user settings of the 'additional features'. If needed this
2035  * preferences can be locked through the admin.
2036  *
2037  * The returned string contains the HTML code of the subpage 'Manage
2038  * Additional Features'
2039  *
2040  * @param App $a
2041  * @return string
2042  */
2043 function admin_page_features(App $a) {
2044
2045         if((argc() > 1) && (argv(1) === 'features')) {
2046                 $arr = array();
2047                 $features = get_features(false);
2048
2049                 foreach($features as $fname => $fdata) {
2050                         $arr[$fname] = array();
2051                         $arr[$fname][0] = $fdata[0];
2052                         foreach(array_slice($fdata,1) as $f) {
2053
2054                                 $set = get_config('feature',$f[0]);
2055                                 if($set === false)
2056                                         $set = $f[3];
2057                                 $arr[$fname][1][] = array(
2058                                         array('feature_' .$f[0],$f[1],$set,$f[2],array(t('Off'),t('On'))),
2059                                         array('featurelock_' .$f[0],sprintf(t('Lock feature %s'),$f[1]),(($f[4] !== false) ? "1" : ''),'',array(t('Off'),t('On')))
2060                                 );
2061                         }
2062                 }
2063
2064                 $tpl = get_markup_template("admin_settings_features.tpl");
2065                 $o .= replace_macros($tpl, array(
2066                         '$form_security_token' => get_form_security_token("admin_manage_features"),
2067                         '$title' => t('Manage Additional Features'),
2068                         '$features' => $arr,
2069                         '$submit' => t('Save Settings'),
2070                 ));
2071
2072                 return $o;
2073         }
2074 }