mod/admin.php

   1 <?php
   2
   3  /**
   4   * Friendica admin
   5   */
   6 require_once("include/remoteupdate.php");
   7
   8
   9 /**
  10  * @param App $a
  11  */
  12 function admin_post(&$a){
  13
  14
  15         if(!is_site_admin()) {
  16                 return;
  17         }
  18
  19         // do not allow a page manager to access the admin panel at all.
  20
  21         if(x($_SESSION,'submanage') && intval($_SESSION['submanage']))
  22                 return;
  23
  24
  25
  26         // urls
  27         if ($a->argc > 1){
  28                 switch ($a->argv[1]){
  29                         case 'site':
  30                                 admin_page_site_post($a);
  31                                 break;
  32                         case 'users':
  33                                 admin_page_users_post($a);
  34                                 break;
  35                         case 'plugins':
  36                                 if ($a->argc > 2 &&
  37                                         is_file("addon/".$a->argv[2]."/".$a->argv[2].".php")){
  38                                                 @include_once("addon/".$a->argv[2]."/".$a->argv[2].".php");
  39                                                 if(function_exists($a->argv[2].'_plugin_admin_post')) {
  40                                                         $func = $a->argv[2].'_plugin_admin_post';
  41                                                         $func($a);
  42                                                 }
  43                                 }
  44                                 goaway($a->get_baseurl(true) . '/admin/plugins/' . $a->argv[2] );
  45                                 return; // NOTREACHED
  46                                 break;
  47                         case 'themes':
  48                                 $theme = $a->argv[2];
  49                                 if (is_file("view/theme/$theme/config.php")){
  50                                         require_once("view/theme/$theme/config.php");
  51                                         if (function_exists("theme_admin_post")){
  52                                                 theme_admin_post($a);
  53                                         }
  54                                 }
  55                                 info(t('Theme settings updated.'));
  56                                 if(is_ajax()) return;
  57
  58                                 goaway($a->get_baseurl(true) . '/admin/themes/' . $theme );
  59                                 return;
  60                                 break;
  61                         case 'logs':
  62                                 admin_page_logs_post($a);
  63                                 break;
  64                         case 'dbsync':
  65                                 admin_page_dbsync_post($a);
  66                                 break;
  67                         case 'update':
  68                                 admin_page_remoteupdate_post($a);
  69                                 break;
  70                 }
  71         }
  72
  73         goaway($a->get_baseurl(true) . '/admin' );
  74         return; // NOTREACHED
  75 }
  76
  77 /**
  78  * @param App $a
  79  * @return string
  80  */
  81 function admin_content(&$a) {
  82
  83         if(!is_site_admin()) {
  84                 return login(false);
  85         }
  86
  87         if(x($_SESSION,'submanage') && intval($_SESSION['submanage']))
  88                 return "";
  89
  90         /**
  91          * Side bar links
  92          */
  93
  94         // array( url, name, extra css classes )
  95         $aside = Array(
  96                 'site'   =>     Array($a->get_baseurl(true)."/admin/site/", t("Site") , "site"),
  97                 'users'  =>     Array($a->get_baseurl(true)."/admin/users/", t("Users") , "users"),
  98                 'plugins'=>     Array($a->get_baseurl(true)."/admin/plugins/", t("Plugins") , "plugins"),
  99                 'themes' =>     Array($a->get_baseurl(true)."/admin/themes/", t("Themes") , "themes"),
 100                 'dbsync' => Array($a->get_baseurl(true)."/admin/dbsync/", t('DB updates'), "dbsync"),
 101                 //'update' =>   Array($a->get_baseurl(true)."/admin/update/", t("Software Update") , "update")
 102         );
 103
 104         /* get plugins admin page */
 105
 106         $r = q("SELECT * FROM `addon` WHERE `plugin_admin`=1");
 107         $aside['plugins_admin']=Array();
 108         foreach ($r as $h){
 109                 $plugin =$h['name'];
 110                 $aside['plugins_admin'][] = Array($a->get_baseurl(true)."/admin/plugins/".$plugin, $plugin, "plugin");
 111                 // temp plugins with admin
 112                 $a->plugins_admin[] = $plugin;
 113         }
 114
 115         $aside['logs'] = Array($a->get_baseurl(true)."/admin/logs/", t("Logs"), "logs");
 116
 117         $t = get_markup_template("admin_aside.tpl");
 118         $a->page['aside'] .= replace_macros( $t, array(
 119                         '$admin' => $aside,
 120                         '$admtxt' => t('Admin'),
 121                         '$plugadmtxt' => t('Plugin Features'),
 122                         '$logtxt' => t('Logs'),
 123                         '$h_pending' => t('User registrations waiting for confirmation'),
 124                         '$admurl'=> $a->get_baseurl(true)."/admin/"
 125         ));
 126
 127
 128
 129         /**
 130          * Page content
 131          */
 132         $o = '';
 133
 134         // urls
 135         if ($a->argc > 1){
 136                 switch ($a->argv[1]){
 137                         case 'site':
 138                                 $o = admin_page_site($a);
 139                                 break;
 140                         case 'users':
 141                                 $o = admin_page_users($a);
 142                                 break;
 143                         case 'plugins':
 144                                 $o = admin_page_plugins($a);
 145                                 break;
 146                         case 'themes':
 147                                 $o = admin_page_themes($a);
 148                                 break;
 149                         case 'logs':
 150                                 $o = admin_page_logs($a);
 151                                 break;
 152                         case 'dbsync':
 153                                 $o = admin_page_dbsync($a);
 154                                 break;
 155                         case 'update':
 156                                 $o = admin_page_remoteupdate($a);
 157                                 break;
 158                         default:
 159                                 notice( t("Item not found.") );
 160                 }
 161         } else {
 162                 $o = admin_page_summary($a);
 163         }
 164
 165         if(is_ajax()) {
 166                 echo $o;
 167                 killme();
 168                 return '';
 169         } else {
 170                 return $o;
 171         }
 172 }
 173
 174
 175 /**
 176  * Admin Summary Page
 177  * @param App $a
 178  * @return string
 179  */
 180 function admin_page_summary(&$a) {
 181         $r = q("SELECT `page-flags`, COUNT(uid) as `count` FROM `user` GROUP BY `page-flags`");
 182         $accounts = Array(
 183                 Array( t('Normal Account'), 0),
 184                 Array( t('Soapbox Account'), 0),
 185                 Array( t('Community/Celebrity Account'), 0),
 186                 Array( t('Automatic Friend Account'), 0),
 187                 Array( t('Blog Account'), 0),
 188                 Array( t('Private Forum'), 0)
 189         );
 190
 191         $users=0;
 192         foreach ($r as $u){ $accounts[$u['page-flags']][1] = $u['count']; $users+= $u['count']; }
 193
 194         logger('accounts: ' . print_r($accounts,true),LOGGER_DATA);
 195
 196         $r = q("SELECT COUNT(id) as `count` FROM `register`");
 197         $pending = $r[0]['count'];
 198
 199         $r = q("select count(*) as total from deliverq where 1");
 200         $deliverq = (($r) ? $r[0]['total'] : 0);
 201
 202         $r = q("select count(*) as total from queue where 1");
 203         $queue = (($r) ? $r[0]['total'] : 0);
 204
 205         // We can do better, but this is a quick queue status
 206
 207         $queues = array( 'label' => t('Message queues'), 'deliverq' => $deliverq, 'queue' => $queue );
 208
 209
 210         $t = get_markup_template("admin_summary.tpl");
 211         return replace_macros($t, array(
 212                 '$title' => t('Administration'),
 213                 '$page' => t('Summary'),
 214                 '$queues' => $queues,
 215                 '$users' => Array( t('Registered users'), $users),
 216                 '$accounts' => $accounts,
 217                 '$pending' => Array( t('Pending registrations'), $pending),
 218                 '$version' => Array( t('Version'), FRIENDICA_VERSION),
 219                 '$build' =>  get_config('system','build'),
 220                 '$plugins' => Array( t('Active plugins'), $a->plugins )
 221         ));
 222 }
 223
 224
 225 /**
 226  * Admin Site Page
 227  *  @param App $a
 228  */
 229 function admin_page_site_post(&$a){
 230         if (!x($_POST,"page_site")){
 231                 return;
 232         }
 233
 234     check_form_security_token_redirectOnErr('/admin/site', 'admin_site');
 235
 236         $sitename                       =       ((x($_POST,'sitename'))                 ? notags(trim($_POST['sitename']))                      : '');
 237         $banner                         =       ((x($_POST,'banner'))                   ? trim($_POST['banner'])                                        : false);
 238         $language                       =       ((x($_POST,'language'))                 ? notags(trim($_POST['language']))                      : '');
 239         $theme                          =       ((x($_POST,'theme'))                    ? notags(trim($_POST['theme']))                         : '');
 240         $maximagesize           =       ((x($_POST,'maximagesize'))             ? intval(trim($_POST['maximagesize']))          :  0);
 241
 242
 243         $register_policy        =       ((x($_POST,'register_policy'))  ? intval(trim($_POST['register_policy']))       :  0);
 244         $abandon_days       =   ((x($_POST,'abandon_days'))         ? intval(trim($_POST['abandon_days']))          :  0);
 245
 246         $register_text          =       ((x($_POST,'register_text'))    ? notags(trim($_POST['register_text']))         : '');
 247
 248         $allowed_sites          =       ((x($_POST,'allowed_sites'))    ? notags(trim($_POST['allowed_sites']))         : '');
 249         $allowed_email          =       ((x($_POST,'allowed_email'))    ? notags(trim($_POST['allowed_email']))         : '');
 250         $block_public           =       ((x($_POST,'block_public'))             ? True  :       False);
 251         $force_publish          =       ((x($_POST,'publish_all'))              ? True  :       False);
 252         $global_directory       =       ((x($_POST,'directory_submit_url'))     ? notags(trim($_POST['directory_submit_url']))  : '');
 253         $no_multi_reg           =       ((x($_POST,'no_multi_reg'))             ? True  :       False);
 254         $no_openid                      =       !((x($_POST,'no_openid'))               ? True  :       False);
 255         $no_regfullname         =       !((x($_POST,'no_regfullname'))  ? True  :       False);
 256         $no_utf                         =       !((x($_POST,'no_utf'))                  ? True  :       False);
 257         $no_community_page      =       !((x($_POST,'no_community_page'))       ? True  :       False);
 258
 259         $verifyssl                      =       ((x($_POST,'verifyssl'))                ? True  :       False);
 260         $proxyuser                      =       ((x($_POST,'proxyuser'))                ? notags(trim($_POST['proxyuser']))     : '');
 261         $proxy                          =       ((x($_POST,'proxy'))                    ? notags(trim($_POST['proxy'])) : '');
 262         $timeout                        =       ((x($_POST,'timeout'))                  ? intval(trim($_POST['timeout']))               : 60);
 263         $delivery_interval      =       ((x($_POST,'delivery_interval'))? intval(trim($_POST['delivery_interval']))             : 0);
 264         $poll_interval  =       ((x($_POST,'poll_interval'))? intval(trim($_POST['poll_interval']))             : 0);
 265         $maxloadavg             =       ((x($_POST,'maxloadavg'))       ? intval(trim($_POST['maxloadavg']))            : 50);
 266         $dfrn_only          =   ((x($_POST,'dfrn_only'))            ? True      :       False);
 267         $ostatus_disabled   =   !((x($_POST,'ostatus_disabled')) ? True  :   False);
 268         $diaspora_enabled   =   ((x($_POST,'diaspora_enabled')) ? True   :  False);
 269         $ssl_policy         =   ((x($_POST,'ssl_policy')) ? intval($_POST['ssl_policy']) : 0);
 270
 271         if($ssl_policy != intval(get_config('system','ssl_policy'))) {
 272                 if($ssl_policy == SSL_POLICY_FULL) {
 273                         q("update `contact` set
 274                                 `url`     = replace(`url`    , 'http:' , 'https:'),
 275                                 `photo`   = replace(`photo`  , 'http:' , 'https:'),
 276                                 `thumb`   = replace(`thumb`  , 'http:' , 'https:'),
 277                                 `micro`   = replace(`micro`  , 'http:' , 'https:'),
 278                                 `request` = replace(`request`, 'http:' , 'https:'),
 279                                 `notify`  = replace(`notify` , 'http:' , 'https:'),
 280                                 `poll`    = replace(`poll`   , 'http:' , 'https:'),
 281                                 `confirm` = replace(`confirm`, 'http:' , 'https:'),
 282                                 `poco`    = replace(`poco`   , 'http:' , 'https:')
 283                                 where `self` = 1"
 284                         );
 285                         q("update `profile` set
 286                                 `photo`   = replace(`photo`  , 'http:' , 'https:'),
 287                                 `thumb`   = replace(`thumb`  , 'http:' , 'https:')
 288                                 where 1 "
 289                         );
 290                 }
 291                 elseif($ssl_policy == SSL_POLICY_SELFSIGN) {
 292                         q("update `contact` set
 293                                 `url`     = replace(`url`    , 'https:' , 'http:'),
 294                                 `photo`   = replace(`photo`  , 'https:' , 'http:'),
 295                                 `thumb`   = replace(`thumb`  , 'https:' , 'http:'),
 296                                 `micro`   = replace(`micro`  , 'https:' , 'http:'),
 297                                 `request` = replace(`request`, 'https:' , 'http:'),
 298                                 `notify`  = replace(`notify` , 'https:' , 'http:'),
 299                                 `poll`    = replace(`poll`   , 'https:' , 'http:'),
 300                                 `confirm` = replace(`confirm`, 'https:' , 'http:'),
 301                                 `poco`    = replace(`poco`   , 'https:' , 'http:')
 302                                 where `self` = 1"
 303                         );
 304                         q("update `profile` set
 305                                 `photo`   = replace(`photo`  , 'https:' , 'http:'),
 306                                 `thumb`   = replace(`thumb`  , 'https:' , 'http:')
 307                                 where 1 "
 308                         );
 309                 }
 310         }
 311         set_config('system','ssl_policy',$ssl_policy);
 312         set_config('system','delivery_interval',$delivery_interval);
 313         set_config('system','poll_interval',$poll_interval);
 314         set_config('system','maxloadavg',$maxloadavg);
 315         set_config('config','sitename',$sitename);
 316         if ($banner==""){
 317                 // don't know why, but del_config doesn't work...
 318                 q("DELETE FROM `config` WHERE `cat` = '%s' AND `k` = '%s' LIMIT 1",
 319                         dbesc("system"),
 320                         dbesc("banner")
 321                 );
 322         } else {
 323                 set_config('system','banner', $banner);
 324         }
 325         set_config('system','language', $language);
 326         set_config('system','theme', $theme);
 327         set_config('system','maximagesize', $maximagesize);
 328
 329         set_config('config','register_policy', $register_policy);
 330         set_config('system','account_abandon_days', $abandon_days);
 331         set_config('config','register_text', $register_text);
 332         set_config('system','allowed_sites', $allowed_sites);
 333         set_config('system','allowed_email', $allowed_email);
 334         set_config('system','block_public', $block_public);
 335         set_config('system','publish_all', $force_publish);
 336         if ($global_directory==""){
 337                 // don't know why, but del_config doesn't work...
 338                 q("DELETE FROM `config` WHERE `cat` = '%s' AND `k` = '%s' LIMIT 1",
 339                         dbesc("system"),
 340                         dbesc("directory_submit_url")
 341                 );
 342         } else {
 343                 set_config('system','directory_submit_url', $global_directory);
 344         }
 345
 346         set_config('system','block_extended_register', $no_multi_reg);
 347         set_config('system','no_openid', $no_openid);
 348         set_config('system','no_regfullname', $no_regfullname);
 349         set_config('system','no_community_page', $no_community_page);
 350         set_config('system','no_utf', $no_utf);
 351         set_config('system','verifyssl', $verifyssl);
 352         set_config('system','proxyuser', $proxyuser);
 353         set_config('system','proxy', $proxy);
 354         set_config('system','curl_timeout', $timeout);
 355         set_config('system','dfrn_only', $dfrn_only);
 356         set_config('system','ostatus_disabled', $ostatus_disabled);
 357         set_config('system','diaspora_enabled', $diaspora_enabled);
 358
 359         info( t('Site settings updated.') . EOL);
 360         goaway($a->get_baseurl(true) . '/admin/site' );
 361         return; // NOTREACHED
 362
 363 }
 364
 365 /**
 366  * @param  App $a
 367  * @return string
 368  */
 369 function admin_page_site(&$a) {
 370
 371         /* Installed langs */
 372         $lang_choices = array();
 373         $langs = glob('view/*/strings.php');
 374
 375         if(is_array($langs) && count($langs)) {
 376                 if(! in_array('view/en/strings.php',$langs))
 377                         $langs[] = 'view/en/';
 378                 asort($langs);
 379                 foreach($langs as $l) {
 380                         $t = explode("/",$l);
 381                         $lang_choices[$t[1]] = $t[1];
 382                 }
 383         }
 384
 385         /* Installed themes */
 386         $theme_choices = array();
 387         $files = glob('view/theme/*');
 388         if($files) {
 389                 foreach($files as $file) {
 390                         $f = basename($file);
 391                         $theme_name = ((file_exists($file . '/experimental')) ?  sprintf("%s - \x28Experimental\x29", $f) : $f);
 392                         $theme_choices[$f] = $theme_name;
 393                 }
 394         }
 395
 396
 397         /* Banner */
 398         $banner = get_config('system','banner');
 399         if($banner == false)
 400                 $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>';
 401         $banner = htmlspecialchars($banner);
 402
 403         //echo "<pre>"; var_dump($lang_choices); die("</pre>");
 404
 405         /* Register policy */
 406         $register_choices = Array(
 407                 REGISTER_CLOSED => t("Closed"),
 408                 REGISTER_APPROVE => t("Requires approval"),
 409                 REGISTER_OPEN => t("Open")
 410         );
 411
 412         $ssl_choices = array(
 413                 SSL_POLICY_NONE => t("No SSL policy, links will track page SSL state"),
 414                 SSL_POLICY_FULL => t("Force all links to use SSL"),
 415                 SSL_POLICY_SELFSIGN => t("Self-signed certificate, use SSL for local links only (discouraged)")
 416         );
 417
 418         $t = get_markup_template("admin_site.tpl");
 419         return replace_macros($t, array(
 420                 '$title' => t('Administration'),
 421                 '$page' => t('Site'),
 422                 '$submit' => t('Submit'),
 423                 '$registration' => t('Registration'),
 424                 '$upload' => t('File upload'),
 425                 '$corporate' => t('Policies'),
 426                 '$advanced' => t('Advanced'),
 427
 428                 '$baseurl' => $a->get_baseurl(true),
 429                                                                         // name, label, value, help string, extra data...
 430                 '$sitename'             => array('sitename', t("Site name"), htmlentities($a->config['sitename'], ENT_QUOTES), ""),
 431                 '$banner'                       => array('banner', t("Banner/Logo"), $banner, ""),
 432                 '$language'             => array('language', t("System language"), get_config('system','language'), "", $lang_choices),
 433                 '$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),
 434                 '$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),
 435                 '$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.")),
 436
 437                 '$register_policy'      => array('register_policy', t("Register policy"), $a->config['register_policy'], "", $register_choices),
 438                 '$register_text'        => array('register_text', t("Register text"), htmlentities($a->config['register_text'], ENT_QUOTES, 'UTF-8'), t("Will be displayed prominently on the registration page.")),
 439                 '$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.')),
 440                 '$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")),
 441                 '$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")),
 442                 '$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.")),
 443                 '$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.")),
 444                 '$global_directory'     => array('directory_submit_url', t("Global directory update URL"), get_config('system','directory_submit_url'), t("URL to update the global directory. If this is not set, the global directory is completely unavailable to the application.")),
 445
 446                 '$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.")),
 447                 '$no_openid'            => array('no_openid', t("OpenID support"), !get_config('system','no_openid'), t("OpenID support for registration and logins.")),
 448                 '$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")),
 449                 '$no_utf'                       => array('no_utf', t("UTF-8 Regular expressions"), !get_config('system','no_utf'), t("Use PHP UTF8 regular expressions")),
 450                 '$no_community_page' => array('no_community_page', t("Show Community Page"), !get_config('system','no_community_page'), t("Display a Community page showing all recent public postings on this site.")),
 451                 '$ostatus_disabled' => array('ostatus_disabled', t("Enable OStatus support"), !get_config('system','ostatus_disable'), t("Provide built-in OStatus \x28identi.ca, status.net, etc.\x29 compatibility. All communications in OStatus are public, so privacy warnings will be occasionally displayed.")),
 452                 '$diaspora_enabled' => array('diaspora_enabled', t("Enable Diaspora support"), get_config('system','diaspora_enabled'), t("Provide built-in Diaspora network compatibility.")),
 453                 '$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.")),
 454                 '$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.")),
 455                 '$proxyuser'            => array('proxyuser', t("Proxy user"), get_config('system','proxyuser'), ""),
 456                 '$proxy'                        => array('proxy', t("Proxy URL"), get_config('system','proxy'), ""),
 457                 '$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).")),
 458                 '$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.")),
 459                 '$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.")),
 460                 '$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.")),
 461         '$form_security_token' => get_form_security_token("admin_site"),
 462
 463         ));
 464
 465 }
 466
 467
 468 function admin_page_dbsync(&$a) {
 469
 470         $o = '';
 471
 472         if($a->argc > 3 && intval($a->argv[3]) && $a->argv[2] === 'mark') {
 473                 set_config('database', 'update_' . intval($a->argv[3]), 'success');
 474                 $curr = get_config('system','build');
 475                 if(intval($curr) == intval($a->argv[3]))
 476                         set_config('system','build',intval($curr) + 1);
 477                 info( t('Update has been marked successful') . EOL);
 478                 goaway($a->get_baseurl(true) . '/admin/dbsync');
 479         }
 480
 481         if($a->argc > 2 && intval($a->argv[2])) {
 482                 require_once('update.php');
 483                 $func = 'update_' . intval($a->argv[2]);
 484                 if(function_exists($func)) {
 485                         $retval = $func();
 486                         if($retval === UPDATE_FAILED) {
 487                                 $o .= sprintf( t('Executing %s failed. Check system logs.'), $func);
 488                         }
 489                         elseif($retval === UPDATE_SUCCESS) {
 490                                 $o .= sprintf( t('Update %s was successfully applied.', $func));
 491                                 set_config('database',$func, 'success');
 492                         }
 493                         else
 494                                 $o .= sprintf( t('Update %s did not return a status. Unknown if it succeeded.'), $func);
 495                 }
 496                 else
 497                         $o .= sprintf( t('Update function %s could not be found.'), $func);
 498                 return $o;
 499         }
 500
 501         $failed = array();
 502         $r = q("select * from config where `cat` = 'database' ");
 503         if(count($r)) {
 504                 foreach($r as $rr) {
 505                         $upd = intval(substr($rr['k'],7));
 506                         if($upd < 1139 || $rr['v'] === 'success')
 507                                 continue;
 508                         $failed[] = $upd;
 509                 }
 510         }
 511         if(! count($failed))
 512                 return '<h3>' . t('No failed updates.') . '</h3>';
 513
 514         $o = replace_macros(get_markup_template('failed_updates.tpl'),array(
 515                 '$base' => $a->get_baseurl(true),
 516                 '$banner' => t('Failed Updates'),
 517                 '$desc' => t('This does not include updates prior to 1139, which did not return a status.'),
 518                 '$mark' => t('Mark success (if update was manually applied)'),
 519                 '$apply' => t('Attempt to execute this update step automatically'),
 520                 '$failed' => $failed
 521         ));
 522
 523         return $o;
 524
 525 }
 526
 527 /**
 528  * Users admin page
 529  *
 530  * @param App $a
 531  */
 532 function admin_page_users_post(&$a){
 533         $pending = ( x($_POST, 'pending') ? $_POST['pending'] : Array() );
 534         $users = ( x($_POST, 'user') ? $_POST['user'] : Array() );
 535
 536     check_form_security_token_redirectOnErr('/admin/users', 'admin_users');
 537
 538         if (x($_POST,'page_users_block')){
 539                 foreach($users as $uid){
 540                         q("UPDATE `user` SET `blocked`=1-`blocked` WHERE `uid`=%s",
 541                                 intval( $uid )
 542                         );
 543                 }
 544                 notice( sprintf( tt("%s user blocked/unblocked", "%s users blocked/unblocked", count($users)), count($users)) );
 545         }
 546         if (x($_POST,'page_users_delete')){
 547                 require_once("include/Contact.php");
 548                 foreach($users as $uid){
 549                         user_remove($uid);
 550                 }
 551                 notice( sprintf( tt("%s user deleted", "%s users deleted", count($users)), count($users)) );
 552         }
 553
 554         if (x($_POST,'page_users_approve')){
 555                 require_once("mod/regmod.php");
 556                 foreach($pending as $hash){
 557                         user_allow($hash);
 558                 }
 559         }
 560         if (x($_POST,'page_users_deny')){
 561                 require_once("mod/regmod.php");
 562                 foreach($pending as $hash){
 563                         user_deny($hash);
 564                 }
 565         }
 566         goaway($a->get_baseurl(true) . '/admin/users' );
 567         return; // NOTREACHED
 568 }
 569
 570 /**
 571  * @param App $a
 572  * @return string
 573  */
 574 function admin_page_users(&$a){
 575         if ($a->argc>2) {
 576                 $uid = $a->argv[3];
 577                 $user = q("SELECT * FROM `user` WHERE `uid`=%d", intval($uid));
 578                 if (count($user)==0){
 579                         notice( 'User not found' . EOL);
 580                         goaway($a->get_baseurl(true) . '/admin/users' );
 581                         return ''; // NOTREACHED
 582                 }
 583                 switch($a->argv[2]){
 584                         case "delete":{
 585                 check_form_security_token_redirectOnErr('/admin/users', 'admin_users', 't');
 586                                 // delete user
 587                                 require_once("include/Contact.php");
 588                                 user_remove($uid);
 589
 590                                 notice( sprintf(t("User '%s' deleted"), $user[0]['username']) . EOL);
 591                         }; break;
 592                         case "block":{
 593                 check_form_security_token_redirectOnErr('/admin/users', 'admin_users', 't');
 594                                 q("UPDATE `user` SET `blocked`=%d WHERE `uid`=%s",
 595                                         intval( 1-$user[0]['blocked'] ),
 596                                         intval( $uid )
 597                                 );
 598                                 notice( sprintf( ($user[0]['blocked']?t("User '%s' unblocked"):t("User '%s' blocked")) , $user[0]['username']) . EOL);
 599                         }; break;
 600                 }
 601                 goaway($a->get_baseurl(true) . '/admin/users' );
 602                 return ''; // NOTREACHED
 603
 604         }
 605
 606         /* get pending */
 607         $pending = q("SELECT `register`.*, `contact`.`name`, `user`.`email`
 608                                  FROM `register`
 609                                  LEFT JOIN `contact` ON `register`.`uid` = `contact`.`uid`
 610                                  LEFT JOIN `user` ON `register`.`uid` = `user`.`uid`;");
 611
 612
 613         /* get users */
 614
 615         $total = q("SELECT count(*) as total FROM `user` where 1");
 616         if(count($total)) {
 617                 $a->set_pager_total($total[0]['total']);
 618                 $a->set_pager_itemspage(100);
 619         }
 620
 621
 622         $users = q("SELECT `user` . * , `contact`.`name` , `contact`.`url` , `contact`.`micro`, `lastitem`.`lastitem_date`
 623                                 FROM
 624                                         (SELECT MAX(`item`.`changed`) as `lastitem_date`, `item`.`uid`
 625                                         FROM `item`
 626                                         WHERE `item`.`type` = 'wall'
 627                                         GROUP BY `item`.`uid`) AS `lastitem`
 628                                                  RIGHT OUTER JOIN `user` ON `user`.`uid` = `lastitem`.`uid`,
 629                                            `contact`
 630                                 WHERE
 631                                            `user`.`uid` = `contact`.`uid`
 632                                                 AND `user`.`verified` =1
 633                                         AND `contact`.`self` =1
 634                                 ORDER BY `contact`.`name` LIMIT %d, %d
 635                                 ",
 636                                 intval($a->pager['start']),
 637                                 intval($a->pager['itemspage'])
 638                                 );
 639
 640         function _setup_users($e){
 641                 $accounts = Array(
 642                         t('Normal Account'),
 643                         t('Soapbox Account'),
 644                         t('Community/Celebrity Account'),
 645                         t('Automatic Friend Account')
 646                 );
 647                 $e['page-flags'] = $accounts[$e['page-flags']];
 648                 $e['register_date'] = relative_date($e['register_date']);
 649                 $e['login_date'] = relative_date($e['login_date']);
 650                 $e['lastitem_date'] = relative_date($e['lastitem_date']);
 651                 return $e;
 652         }
 653         $users = array_map("_setup_users", $users);
 654
 655
 656         $t = get_markup_template("admin_users.tpl");
 657         $o = replace_macros($t, array(
 658                 // strings //
 659                 '$title' => t('Administration'),
 660                 '$page' => t('Users'),
 661                 '$submit' => t('Submit'),
 662                 '$select_all' => t('select all'),
 663                 '$h_pending' => t('User registrations waiting for confirm'),
 664                 '$th_pending' => array( t('Request date'), t('Name'), t('Email') ),
 665                 '$no_pending' =>  t('No registrations.'),
 666                 '$approve' => t('Approve'),
 667                 '$deny' => t('Deny'),
 668                 '$delete' => t('Delete'),
 669                 '$block' => t('Block'),
 670                 '$unblock' => t('Unblock'),
 671
 672                 '$h_users' => t('Users'),
 673                 '$th_users' => array( t('Name'), t('Email'), t('Register date'), t('Last login'), t('Last item'),  t('Account') ),
 674
 675                 '$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?'),
 676                 '$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?'),
 677
 678         '$form_security_token' => get_form_security_token("admin_users"),
 679
 680                 // values //
 681                 '$baseurl' => $a->get_baseurl(true),
 682
 683                 '$pending' => $pending,
 684                 '$users' => $users,
 685         ));
 686         $o .= paginate($a);
 687         return $o;
 688 }
 689
 690
 691 /**
 692  * Plugins admin page
 693  *
 694  * @param App $a
 695  * @return string
 696  */
 697 function admin_page_plugins(&$a){
 698
 699         /**
 700          * Single plugin
 701          */
 702         if ($a->argc == 3){
 703                 $plugin = $a->argv[2];
 704                 if (!is_file("addon/$plugin/$plugin.php")){
 705                         notice( t("Item not found.") );
 706                         return '';
 707                 }
 708
 709                 if (x($_GET,"a") && $_GET['a']=="t"){
 710             check_form_security_token_redirectOnErr('/admin/plugins', 'admin_themes', 't');
 711
 712                         // Toggle plugin status
 713                         $idx = array_search($plugin, $a->plugins);
 714                         if ($idx !== false){
 715                                 unset($a->plugins[$idx]);
 716                                 uninstall_plugin($plugin);
 717                                 info( sprintf( t("Plugin %s disabled."), $plugin ) );
 718                         } else {
 719                                 $a->plugins[] = $plugin;
 720                                 install_plugin($plugin);
 721                                 info( sprintf( t("Plugin %s enabled."), $plugin ) );
 722                         }
 723                         set_config("system","addon", implode(", ",$a->plugins));
 724                         goaway($a->get_baseurl(true) . '/admin/plugins' );
 725                         return ''; // NOTREACHED
 726                 }
 727                 // display plugin details
 728                 require_once('library/markdown.php');
 729
 730                 if (in_array($plugin, $a->plugins)){
 731                         $status="on"; $action= t("Disable");
 732                 } else {
 733                         $status="off"; $action= t("Enable");
 734                 }
 735
 736                 $readme=Null;
 737                 if (is_file("addon/$plugin/README.md")){
 738                         $readme = file_get_contents("addon/$plugin/README.md");
 739                         $readme = Markdown($readme);
 740                 } else if (is_file("addon/$plugin/README")){
 741                         $readme = "<pre>". file_get_contents("addon/$plugin/README") ."</pre>";
 742                 }
 743
 744                 $admin_form="";
 745                 if (is_array($a->plugins_admin) && in_array($plugin, $a->plugins_admin)){
 746                         @require_once("addon/$plugin/$plugin.php");
 747                         $func = $plugin.'_plugin_admin';
 748                         $func($a, $admin_form);
 749                 }
 750
 751                 $t = get_markup_template("admin_plugins_details.tpl");
 752                 return replace_macros($t, array(
 753                         '$title' => t('Administration'),
 754                         '$page' => t('Plugins'),
 755                         '$toggle' => t('Toggle'),
 756                         '$settings' => t('Settings'),
 757                         '$baseurl' => $a->get_baseurl(true),
 758
 759                         '$plugin' => $plugin,
 760                         '$status' => $status,
 761                         '$action' => $action,
 762                         '$info' => get_plugin_info($plugin),
 763                         '$str_author' => t('Author: '),
 764                         '$str_maintainer' => t('Maintainer: '),
 765
 766                         '$admin_form' => $admin_form,
 767                         '$function' => 'plugins',
 768                         '$screenshot' => '',
 769                         '$readme' => $readme,
 770
 771             '$form_security_token' => get_form_security_token("admin_themes"),
 772                 ));
 773         }
 774
 775
 776
 777         /**
 778          * List plugins
 779          */
 780
 781         $plugins = array();
 782         $files = glob("addon/*/");
 783         if($files) {
 784                 foreach($files as $file) {
 785                         if (is_dir($file)){
 786                                 list($tmp, $id)=array_map("trim", explode("/",$file));
 787                                 $info = get_plugin_info($id);
 788                                 $plugins[] = array( $id, (in_array($id,  $a->plugins)?"on":"off") , $info);
 789                         }
 790                 }
 791         }
 792
 793         $t = get_markup_template("admin_plugins.tpl");
 794         return replace_macros($t, array(
 795                 '$title' => t('Administration'),
 796                 '$page' => t('Plugins'),
 797                 '$submit' => t('Submit'),
 798                 '$baseurl' => $a->get_baseurl(true),
 799                 '$function' => 'plugins',
 800                 '$plugins' => $plugins,
 801         '$form_security_token' => get_form_security_token("admin_themes"),
 802         ));
 803 }
 804
 805 /**
 806  * @param array $themes
 807  * @param string $th
 808  * @param int $result
 809  */
 810 function toggle_theme(&$themes,$th,&$result) {
 811         for($x = 0; $x < count($themes); $x ++) {
 812                 if($themes[$x]['name'] === $th) {
 813                         if($themes[$x]['allowed']) {
 814                                 $themes[$x]['allowed'] = 0;
 815                                 $result = 0;
 816                         }
 817                         else {
 818                                 $themes[$x]['allowed'] = 1;
 819                                 $result = 1;
 820                         }
 821                 }
 822         }
 823 }
 824
 825 /**
 826  * @param array $themes
 827  * @param string $th
 828  * @return int
 829  */
 830 function theme_status($themes,$th) {
 831         for($x = 0; $x < count($themes); $x ++) {
 832                 if($themes[$x]['name'] === $th) {
 833                         if($themes[$x]['allowed']) {
 834                                 return 1;
 835                         }
 836                         else {
 837                                 return 0;
 838                         }
 839                 }
 840         }
 841         return 0;
 842 }
 843
 844
 845 /**
 846  * @param array $themes
 847  * @return string
 848  */
 849 function rebuild_theme_table($themes) {
 850         $o = '';
 851         if(count($themes)) {
 852                 foreach($themes as $th) {
 853                         if($th['allowed']) {
 854                                 if(strlen($o))
 855                                         $o .= ',';
 856                                 $o .= $th['name'];
 857                         }
 858                 }
 859         }
 860         return $o;
 861 }
 862
 863
 864 /**
 865  * Themes admin page
 866  *
 867  * @param App $a
 868  * @return string
 869  */
 870 function admin_page_themes(&$a){
 871
 872         $allowed_themes_str = get_config('system','allowed_themes');
 873         $allowed_themes_raw = explode(',',$allowed_themes_str);
 874         $allowed_themes = array();
 875         if(count($allowed_themes_raw))
 876                 foreach($allowed_themes_raw as $x)
 877                         if(strlen(trim($x)))
 878                                 $allowed_themes[] = trim($x);
 879
 880         $themes = array();
 881     $files = glob('view/theme/*');
 882     if($files) {
 883         foreach($files as $file) {
 884             $f = basename($file);
 885             $is_experimental = intval(file_exists($file . '/experimental'));
 886                         $is_supported = 1-(intval(file_exists($file . '/unsupported'))); // Is not used yet
 887                         $is_allowed = intval(in_array($f,$allowed_themes));
 888                         $themes[] = array('name' => $f, 'experimental' => $is_experimental, 'supported' => $is_supported, 'allowed' => $is_allowed);
 889         }
 890     }
 891
 892         if(! count($themes)) {
 893                 notice( t('No themes found.'));
 894                 return '';
 895         }
 896
 897         /**
 898          * Single theme
 899          */
 900
 901         if ($a->argc == 3){
 902                 $theme = $a->argv[2];
 903                 if(! is_dir("view/theme/$theme")){
 904                         notice( t("Item not found.") );
 905                         return '';
 906                 }
 907
 908                 if (x($_GET,"a") && $_GET['a']=="t"){
 909             check_form_security_token_redirectOnErr('/admin/themes', 'admin_themes', 't');
 910
 911                         // Toggle theme status
 912
 913                         toggle_theme($themes,$theme,$result);
 914                         $s = rebuild_theme_table($themes);
 915                         if($result)
 916                                 info( sprintf('Theme %s enabled.',$theme));
 917                         else
 918                                 info( sprintf('Theme %s disabled.',$theme));
 919
 920                         set_config('system','allowed_themes',$s);
 921                         goaway($a->get_baseurl(true) . '/admin/themes' );
 922                         return ''; // NOTREACHED
 923                 }
 924
 925                 // display theme details
 926                 require_once('library/markdown.php');
 927
 928                 if (theme_status($themes,$theme)) {
 929                         $status="on"; $action= t("Disable");
 930                 } else {
 931                         $status="off"; $action= t("Enable");
 932                 }
 933
 934                 $readme=Null;
 935                 if (is_file("view/theme/$theme/README.md")){
 936                         $readme = file_get_contents("view/theme/$theme/README.md");
 937                         $readme = Markdown($readme);
 938                 } else if (is_file("view/theme/$theme/README")){
 939                         $readme = "<pre>". file_get_contents("view/theme/$theme/README") ."</pre>";
 940                 }
 941
 942                 $admin_form="";
 943                 if (is_file("view/theme/$theme/config.php")){
 944                         require_once("view/theme/$theme/config.php");
 945                         if(function_exists("theme_admin")){
 946                                 $admin_form = theme_admin($a);
 947                         }
 948
 949                 }
 950
 951
 952                 $screenshot = array( get_theme_screenshot($theme), t('Screenshot'));
 953                 if(! stristr($screenshot[0],$theme))
 954                         $screenshot = null;
 955
 956                 $t = get_markup_template("admin_plugins_details.tpl");
 957                 return replace_macros($t, array(
 958                         '$title' => t('Administration'),
 959                         '$page' => t('Themes'),
 960                         '$toggle' => t('Toggle'),
 961                         '$settings' => t('Settings'),
 962                         '$baseurl' => $a->get_baseurl(true),
 963
 964                         '$plugin' => $theme,
 965                         '$status' => $status,
 966                         '$action' => $action,
 967                         '$info' => get_theme_info($theme),
 968                         '$function' => 'themes',
 969                         '$admin_form' => $admin_form,
 970                         '$str_author' => t('Author: '),
 971                         '$str_maintainer' => t('Maintainer: '),
 972                         '$screenshot' => $screenshot,
 973                         '$readme' => $readme,
 974
 975                         '$form_security_token' => get_form_security_token("admin_themes"),
 976                 ));
 977         }
 978
 979
 980
 981         /**
 982          * List themes
 983          */
 984
 985         $xthemes = array();
 986         if($themes) {
 987                 foreach($themes as $th) {
 988                         $xthemes[] = array($th['name'],(($th['allowed']) ? "on" : "off"), get_theme_info($th['name']));
 989                 }
 990         }
 991
 992         $t = get_markup_template("admin_plugins.tpl");
 993         return replace_macros($t, array(
 994                 '$title' => t('Administration'),
 995                 '$page' => t('Themes'),
 996                 '$submit' => t('Submit'),
 997                 '$baseurl' => $a->get_baseurl(true),
 998                 '$function' => 'themes',
 999                 '$plugins' => $xthemes,
1000                 '$experimental' => t('[Experimental]'),
1001                 '$unsupported' => t('[Unsupported]'),
1002         '$form_security_token' => get_form_security_token("admin_themes"),
1003         ));
1004 }
1005
1006
1007 /**
1008  * Logs admin page
1009  *
1010  * @param App $a
1011  */
1012
1013 function admin_page_logs_post(&$a) {
1014         if (x($_POST,"page_logs")) {
1015         check_form_security_token_redirectOnErr('/admin/logs', 'admin_logs');
1016
1017                 $logfile                =       ((x($_POST,'logfile'))          ? notags(trim($_POST['logfile']))       : '');
1018                 $debugging              =       ((x($_POST,'debugging'))        ? true                                                          : false);
1019                 $loglevel               =       ((x($_POST,'loglevel'))         ? intval(trim($_POST['loglevel']))      : 0);
1020
1021                 set_config('system','logfile', $logfile);
1022                 set_config('system','debugging',  $debugging);
1023                 set_config('system','loglevel', $loglevel);
1024
1025
1026         }
1027
1028         info( t("Log settings updated.") );
1029         goaway($a->get_baseurl(true) . '/admin/logs' );
1030         return; // NOTREACHED
1031 }
1032
1033 /**
1034  * @param App $a
1035  * @return string
1036  */
1037 function admin_page_logs(&$a){
1038
1039         $log_choices = Array(
1040                 LOGGER_NORMAL => 'Normal',
1041                 LOGGER_TRACE => 'Trace',
1042                 LOGGER_DEBUG => 'Debug',
1043                 LOGGER_DATA => 'Data',
1044                 LOGGER_ALL => 'All'
1045         );
1046
1047         $t = get_markup_template("admin_logs.tpl");
1048
1049         $f = get_config('system','logfile');
1050
1051         $data = '';
1052
1053         if(!file_exists($f)) {
1054                 $data = t("Error trying to open <strong>$f</strong> log file.\r\n<br/>Check to see if file $f exist and is
1055 readable.");
1056         }
1057         else {
1058                 $fp = fopen($f, 'r');
1059                 if(!$fp) {
1060                         $data = t("Couldn't open <strong>$f</strong> log file.\r\n<br/>Check to see if file $f is readable.");
1061                 }
1062                 else {
1063                         $fstat = fstat($fp);
1064                         $size = $fstat['size'];
1065                         if($size != 0)
1066                         {
1067                                 if($size > 5000000 || $size < 0)
1068                                         $size = 5000000;
1069                                 $seek = fseek($fp,0-$size,SEEK_END);
1070                                 if($seek === 0) {
1071                                         $data = escape_tags(fread($fp,$size));
1072                                         while(! feof($fp))
1073                                                 $data .= escape_tags(fread($fp,4096));
1074                                 }
1075                         }
1076                         fclose($fp);
1077                 }
1078         }
1079
1080         return replace_macros($t, array(
1081                 '$title' => t('Administration'),
1082                 '$page' => t('Logs'),
1083                 '$submit' => t('Submit'),
1084                 '$clear' => t('Clear'),
1085                 '$data' => $data,
1086                 '$baseurl' => $a->get_baseurl(true),
1087                 '$logname' =>  get_config('system','logfile'),
1088
1089                                                                         // name, label, value, help string, extra data...
1090                 '$debugging'            => array('debugging', t("Debugging"),get_config('system','debugging'), ""),
1091                 '$logfile'                      => array('logfile', t("Log file"), get_config('system','logfile'), t("Must be writable by web server. Relative to your Friendica top-level directory.")),
1092                 '$loglevel'             => array('loglevel', t("Log level"), get_config('system','loglevel'), "", $log_choices),
1093
1094         '$form_security_token' => get_form_security_token("admin_logs"),
1095         ));
1096 }
1097
1098 /**
1099  * @param App $a
1100  */
1101 function admin_page_remoteupdate_post(&$a) {
1102         // this function should be called via ajax post
1103         if(!is_site_admin()) {
1104                 return;
1105         }
1106
1107
1108         if (x($_POST,'remotefile') && $_POST['remotefile']!=""){
1109                 $remotefile = $_POST['remotefile'];
1110                 $ftpdata = (x($_POST['ftphost'])?$_POST:false);
1111                 doUpdate($remotefile, $ftpdata);
1112         } else {
1113                 echo "No remote file to download. Abort!";
1114         }
1115
1116         killme();
1117 }
1118
1119 /**
1120  * @param App $a
1121  * @return string
1122  */
1123 function admin_page_remoteupdate(&$a) {
1124         if(!is_site_admin()) {
1125                 return login(false);
1126         }
1127
1128         $canwrite = canWeWrite();
1129         $canftp = function_exists('ftp_connect');
1130
1131         $needupdate = true;
1132         $u = checkUpdate();
1133         if (!is_array($u)){
1134                 $needupdate = false;
1135                 $u = array('','','');
1136         }
1137
1138         $tpl = get_markup_template("admin_remoteupdate.tpl");
1139         return replace_macros($tpl, array(
1140                 '$baseurl' => $a->get_baseurl(true),
1141                 '$submit' => t("Update now"),
1142                 '$close' => t("Close"),
1143                 '$localversion' => FRIENDICA_VERSION,
1144                 '$remoteversion' => $u[1],
1145                 '$needupdate' => $needupdate,
1146                 '$canwrite' => $canwrite,
1147                 '$canftp'       => $canftp,
1148                 '$ftphost'      => array('ftphost', t("FTP Host"), '',''),
1149                 '$ftppath'      => array('ftppath', t("FTP Path"), '/',''),
1150                 '$ftpuser'      => array('ftpuser', t("FTP User"), '',''),
1151                 '$ftppwd'       => array('ftppwd', t("FTP Password"), '',''),
1152                 '$remotefile'=>array('remotefile','', $u['2'],'')
1153         ));
1154
1155 }