User Tools

Site Tools


servers:windows:nginx:piwigo

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
servers:windows:nginx:piwigo [2025/01/26 18:18] Sean Rhoneservers:windows:nginx:piwigo [2026/01/22 04:00] (current) – [config.inc.php] Sean Rhone
Line 1: Line 1:
 ====== Information ====== ====== Information ======
  
-  * Piwigo ((https://piwigo.org/)) +  * Piwigo ((https://www.piwigo.org/)) 
-  * Bootstrap Darkroom Theme ((https://github.com/Piwigo/piwigo-bootstrap-darkroom)) +  * Bootstrap Darkroom Theme ((https://piwigo.org/ext/index.php?eid=831)) ((https://doc.piwigo.org/piwigo-themes/bootstrap-darkroom-theme-piwigo)) 
-  * [[Information:Realm of Espionage]]+  * [[information;realm_of_espionage|Realm of Espionage]]
   * https://media.realmofespionage.xyz   * https://media.realmofespionage.xyz
  
 ===== Prerequisites ===== ===== Prerequisites =====
  
-  * [[windows:10|Windows 10]] +  * [[windows;10_ltsc_server|Windows 10 (21H2)]] 
-  * [[servers;windows;freenginx_php_php-cgi|freenginx + PHP + PHP-CGI]]+  * [[servers;windows;nginx_php_php-cgi|nginx + PHP + PHP-CGI]]
   * [[servers;windows;nginx;lets_encrypt|Certbot (Let's Encrypt)]]   * [[servers;windows;nginx;lets_encrypt|Certbot (Let's Encrypt)]]
 +  * [[programs;windows;git|Git]]
 +  * [[servers;windows;mariadb|MariaDB]]
  
 ====== Dependencies ====== ====== Dependencies ======
  
   * https://piwigo.org/guides/install/requirements   * https://piwigo.org/guides/install/requirements
- +  * https://github.com/Piwigo/piwigo-videojs/wiki/How-to-add-videos 
-===== Git ===== +  * https://github.com/Piwigo/piwigo-videojs/wiki/Synchronize#requirement
- +
-  * https://www.git-scm.com/download/win +
-  * Last tested: ''Git-2.47.1.2-64-bit.exe'' +
- +
-  * Git from the command line and also from 3rd-party software +
- +
-===== MariaDB Server ===== +
- +
-  * https://mariadb.org/download/ +
-  * Last tested: ''mariadb-11.6.2-winx64.msi'' +
- +
-  * No Development components or Third party tools +
-  * Use UTF8 as default server's character set +
-  * [x] Enable Networking+
  
 ====== Download Source ====== ====== Download Source ======
Line 37: Line 25:
  
   "%ProgramFiles%\Git\bin\git.exe" clone --branch "master" --depth "1" --recurse-submodules "https://github.com/Piwigo/Piwigo.git" "%SystemDrive%\www\media"   "%ProgramFiles%\Git\bin\git.exe" clone --branch "master" --depth "1" --recurse-submodules "https://github.com/Piwigo/Piwigo.git" "%SystemDrive%\www\media"
- 
-  explorer "%SystemDrive%\www\media" 
  
 ===== Bootstrap Darkroom ===== ===== Bootstrap Darkroom =====
Line 48: Line 34:
 ====== Database ====== ====== Database ======
  
-  "%ProgramFiles%\MariaDB 11.6\bin\mariadb.exe" -u "root" -p+  "%ProgramFiles%\MariaDB 12.2\bin\mariadb.exe" -u "root"
  
   CREATE DATABASE piwigo;   CREATE DATABASE piwigo;
Line 56: Line 42:
   GRANT ALL PRIVILEGES ON piwigo.* to 'piwigo'@'localhost';   GRANT ALL PRIVILEGES ON piwigo.* to 'piwigo'@'localhost';
  
-  FLUSH PRIVILEGES;+  FLUSH PRIVILEGES;EXIT;
  
-  EXIT +====== nginx + PHP-CGI Configuration ======
- +
-====== Environment ======+
  
 ===== PHP ===== ===== PHP =====
  
-  notepad "%SystemDrive%\www\php\media.ini"+  "notepad.exe" "%SystemDrive%\www\php\media.ini"
  
 <code> <code>
 [PHP] [PHP]
-; Modules 
 extension_dir = ".\ext" extension_dir = ".\ext"
 extension = "exif" extension = "exif"
Line 74: Line 57:
 extension = "mbstring" extension = "mbstring"
 extension = "mysqli" extension = "mysqli"
-zend_extension = "opcache" 
  
-; Settings+log_errors = "Off" 
 +error_reporting = "~E_ALL" 
 +display_errors = "Off" 
 +display_startup_errors = "Off" 
 +html_errors = "Off" 
 + 
 +max_execution_time = "200" 
 +memory_limit = "512M"
 post_max_size = "100M" post_max_size = "100M"
 upload_max_filesize = "100M" upload_max_filesize = "100M"
 +max_file_uploads = "100"
  
 [Date] [Date]
Line 85: Line 75:
 ; End</code> ; End</code>
  
-  CD "%SystemDrive%\" && "php.exe" -c "%SystemDrive%\www\php\media.ini" -m +  "php.exe" -c "%SystemDrive%\www\php\media.ini" -m
- +
-====== freenginx + PHP-CGI Configuration ======+
  
 ===== PHP-CGI ===== ===== PHP-CGI =====
  
-  * :!: ''fastcgi_params'' include hard-coded to freenginx version path +  "notepad.exe" "%SystemDrive%\www\nginx\default.d\media.conf"
- +
-  notepad "%SystemDrive%\www\nginx\default.d\media.conf"+
  
 <code> <code>
-# PHP-CGI +location "~" "\.(php)(/.*)?$
-location ~ \.(php)(/.*)?$ { + fastcgi_split_path_info "^(.+\.(?:php))(/.*)$"
-    fastcgi_split_path_info ^(.+\.(?:php))(/.*)$; + fastcgi_intercept_errors "on"; 
-    fastcgi_intercept_errors "on"; + fastcgi_index "index.php"; 
-    fastcgi_index "index.php"; + include "C:/www/nginx/conf/fastcgi_params"; 
-    include "C:/freenginx-1.27.4/conf/fastcgi_params"; + fastcgi_param "SCRIPT_FILENAME"$document_root$fastcgi_script_name"
-    fastcgi_param "SCRIPT_FILENAME" $document_root$fastcgi_script_name; + fastcgi_param "PATH_INFO"$fastcgi_path_info"
-    fastcgi_param "PATH_INFO" $fastcgi_path_info; + fastcgi_param "HTTPS" "on"; 
-    fastcgi_param "HTTPS" "on"; + 
-    fastcgi_pass "127.0.0.1:9003";+ fastcgi_pass "127.0.0.1:9003";
 } }
  
Line 112: Line 98:
 ===== Server Block ===== ===== Server Block =====
  
-  notepad "%SystemDrive%\www\nginx\vhosts.d\media.conf"+  "notepad.exe" "%SystemDrive%\www\nginx\vhosts.d\media.conf"
  
 <code> <code>
 server { server {
-    listen "443" "ssl"; + listen "443" "ssl"; 
-    http2 "on"; + http2 "on"; 
-    server_name "media.realmofespionage.xyz"; + server_name "media.realmofespionage.xyz"; 
-    root "C:/www/media"; + root "C:/www/media"; 
-    index "index.php";+ index "index.php";
  
-    include C:/www/nginx/default.d/media.conf; + include "C:/www/nginx/default.d/media.conf"
-    include C:/www/nginx/default.d/headers.conf;+ include "C:/www/nginx/default.d/headers.conf";
  
-    client_max_body_size "100M";+ client_max_body_size "100M";
  
-   add_header Content-Security-Policy "default-src "self"; script-src "self" "unsafe-inline" "unsafe-eval"; style-src "self" "unsafe-inline"always;+access_log "logs/media-access.log"; 
 +# error_log "logs/media-error.log";
  
-#    access_log  logs/media-access.log; + location "/"
-#    error_log  logs/media-error.log; +  index "index.php"
- +  try_files "$uri $uri/" "@rewrite"
-# Install dir post-install block + }
-+
-#    location "/install" { +
-#        location ~* \.(php)$ { +
-#            deny "all"; +
-#        } +
-#    } +
- +
-    location / { +
-        index index.php; +
-        try_files $uri $uri/ @rewrite; +
-    } +
- +
-    location @rewrite { +
-        rewrite ^/picture((/|$).*)$ /picture.php$1 last; +
-        rewrite ^/index((/|$).*)$ /index.php$1 last; +
-        rewrite ^/i((/|$).*)$ /i.php$1 last; +
-    }+
  
 + location "@rewrite" {
 +  rewrite "^/picture((/|$).*)$" "/picture.php$1" "last";
 +  rewrite "^/index((/|$).*)$" "/index.php$1" "last";
 +  rewrite "^/i((/|$).*)$" "/i.php$1" "last";
 + }
 } }
  
 # End</code> # End</code>
  
-  "%SystemDrive%\www\scripts\freenginx\Reload.bat"+  "%SystemDrive%\www\scripts\nginx\Reload.bat"
  
-====== Batch Files ======+====== Scripts ======
  
   MKDIR "%SystemDrive%\www\scripts\media"   MKDIR "%SystemDrive%\www\scripts\media"
  
-  explorer "%SystemDrive%\www\scripts\media"+  "explorer.exe" "%SystemDrive%\www\scripts\media"
  
 ===== PHP-CGI ===== ===== PHP-CGI =====
  
-  notepad "%SystemDrive%\www\scripts\media\PHP-CGI.bat"+  "notepad.exe" "%SystemDrive%\www\scripts\media\PHP-CGI.bat"
  
 <code> <code>
 +@echo off
 +
 +CD "%Temp%"
 +
 SET "PHP_FCGI_MAX_REQUESTS=0" SET "PHP_FCGI_MAX_REQUESTS=0"
 SET "PHP_FCGI_CHILDREN=1" SET "PHP_FCGI_CHILDREN=1"
  
-START "Media PHP-CGI" "php-cgi.exe" -b "127.0.0.1:9003" -c "%SystemDrive%\www\php\media.ini" -q+START "Media PHP-CGI" /MIN "php-cgi.exe" -b "127.0.0.1:9003" -c "%SystemDrive%\www\php\media.ini" -q 
 + 
 +SET "PHP_FCGI_MAX_REQUESTS=" 
 +SET "PHP_FCGI_CHILDREN="
  
 :: End</code> :: End</code>
Line 177: Line 159:
   "%SystemDrive%\www\scripts\media\PHP-CGI.bat"   "%SystemDrive%\www\scripts\media\PHP-CGI.bat"
  
-==== Autostart ====+===== Update =====
  
-  explorer "%ProgramData%\Microsoft\Windows\Start Menu\Programs\StartUp"+  "notepad.exe" "%SystemDrive%\www\scripts\media\Update.bat"
  
-  "%SystemDrive%\www\scripts\media\PHP-CGI.bat"+<code> 
 +@echo off
  
-  Media PHP-CGI+TITLE Media Updater 
 +CD "%Temp%"
  
-===== Update =====+"%ProgramFiles%\Git\bin\git.exe" -C "%SystemDrive%\www\media" reset --hard "origin/master" 
 +"%ProgramFiles%\Git\bin\git.exe" -C "%SystemDrive%\www\media" pull origin "master" --rebase
  
-  * https://github.com/Piwigo/Piwigo/commits/master/ +"%ProgramFiles%\Git\bin\git.exe" -C "%SystemDrive%\www\media\themes\bootstrap_darkroom" reset --hard "origin/master" 
-  * https://github.com/Piwigo/piwigo-bootstrap-darkroom/commits/master/+"%ProgramFiles%\Git\bin\git.exe" -C "%SystemDrive%\www\media\themes\bootstrap_darkroom" pull origin "master" --rebase
  
-  notepad "%SystemDrive%\www\scripts\media\Update.bat"+:: End</code> 
 + 
 +  "%SystemDrive%\www\scripts\media\Update.bat" 
 + 
 +===== Back-up ===== 
 + 
 +  "notepad.exe" "%SystemDrive%\www\scripts\media\Back-up.bat"
  
 <code> <code>
 @echo off @echo off
  
-:: Piwigo +TITLE Media Back-up 
-"%ProgramFiles%\Git\bin\git.exe" -C "%SystemDrive%\www\media" reset --hard +CD "%Temp%"
-"%ProgramFiles%\Git\bin\git.exe-C "%SystemDrive%\www\media" pull origin "master" --rebase+
  
-:: Bootstrap Darkroom +"tar.exe" -czf "D:\Servers\Scheduled Backups\piwigo-files-auto-%RANDOM%.tar.gz" -C "%SystemDrive%\www" "media" 
-"%ProgramFiles%\Git\bin\git.exe" -C "%SystemDrive%\www\media\themes\bootstrap_darkroomreset --hard +"%ProgramFiles%\MariaDB 12.2\bin\mariadb-dump.exe" -u "root" --opt -r "D:\Servers\Scheduled Backups\%RANDOM%-piwigo.sql" "piwigo" 
-"%ProgramFiles%\Git\bin\git.exe" -C "%SystemDrive%\www\media\themes\bootstrap_darkroompull origin "master" --rebase+ 
 +::"tar.exe" -czf "%UserProfile%\Downloads\piwigo-files-auto-%RANDOM%.tar.gz" -C "%SystemDrive%\www" "media
 +::"%ProgramFiles%\MariaDB 12.2\bin\mariadb-dump.exe-u "root" --opt -r "%UserProfile%\Downloads\%RANDOM%-piwigo.sql" "piwigo"
  
 :: End</code> :: End</code>
 +
 +  "%SystemDrive%\www\scripts\media\Back-up.bat"
  
 ===== Maintenance ===== ===== Maintenance =====
  
-  notepad "%SystemDrive%\www\scripts\media\Maintenance.bat"+  "notepad.exe" "%SystemDrive%\www\scripts\media\Maintenance.bat"
  
 <code> <code>
 @echo off @echo off
  
-:: Piwigo+TITLE Media Maintenance 
 +CD "%Temp%" 
 "%ProgramFiles%\Git\bin\git.exe" -C "%SystemDrive%\www\media" gc --aggressive --prune="all" "%ProgramFiles%\Git\bin\git.exe" -C "%SystemDrive%\www\media" gc --aggressive --prune="all"
 "%ProgramFiles%\Git\bin\git.exe" -C "%SystemDrive%\www\media" fsck --full --strict "%ProgramFiles%\Git\bin\git.exe" -C "%SystemDrive%\www\media" fsck --full --strict
  
-:: Bootstrap Darkroom 
 "%ProgramFiles%\Git\bin\git.exe" -C "%SystemDrive%\www\media\themes\bootstrap_darkroom" gc --aggressive --prune="all" "%ProgramFiles%\Git\bin\git.exe" -C "%SystemDrive%\www\media\themes\bootstrap_darkroom" gc --aggressive --prune="all"
 "%ProgramFiles%\Git\bin\git.exe" -C "%SystemDrive%\www\media\themes\bootstrap_darkroom" fsck --full --strict "%ProgramFiles%\Git\bin\git.exe" -C "%SystemDrive%\www\media\themes\bootstrap_darkroom" fsck --full --strict
Line 222: Line 217:
 :: End</code> :: End</code>
  
-===== Back-up =====+  "%SystemDrive%\www\scripts\media\Maintenance.bat"
  
-==== Database ====+===== Git Fix =====
  
-  notepad "%SystemDrive%\www\scripts\media\Database Back-up.bat"+  * :!: Set **both** ''user.email'' 
 + 
 +  "notepad.exe" "%SystemDrive%\www\scripts\media\Git Fix.bat"
  
 <code> <code>
 @echo off @echo off
  
-:: User\Downloads +TITLE Media Git Fix 
-CD "%UserProfile%\Downloads"+CD "%Temp%"
  
-:: NAS +::################## 
-::CD /D "D:\Servers\Scheduled Backups"+::# Piwigo 
 +::##################
  
-echo Root MariaDB user password prompt: +RMDIR /S /Q "%SystemDrive%\www\media\.git" 
-"%ProgramFiles%\MariaDB 11.6\bin\mariadb-dump.exe" -"root" ---opt -r "piwigo-database-%RANDOM%.sql" "piwigo"+"%ProgramFiles%\Git\bin\git.exe" -"%SystemDrive%\www\mediainit --initial-branch="master" 
 +"%ProgramFiles%\Git\bin\git.exe-C "%SystemDrive%\www\media" add "."
  
-pause+::###################################### 
 +"%ProgramFiles%\Git\bin\git.exe" -C "%SystemDrive%\www\media" config "user.email" "espionage724@x" 
 +::######################################
  
-:: End</code>+"%ProgramFiles%\Git\bin\git.exe" -C "%SystemDrive%\www\media" commit --message="x"
  
-==== Files ====+"%ProgramFiles%\Git\bin\git.exe" -C "%SystemDrive%\www\media" remote add "origin" "https://github.com/Piwigo/Piwigo.git" 
 +"%ProgramFiles%\Git\bin\git.exe" -C "%SystemDrive%\www\media" pull --depth "1" --recurse-submodules "origin" "master" --rebase
  
-  notepad "%SystemDrive%\www\scripts\media\Files Back-up.bat"+"%ProgramFiles%\Git\bin\git.exe" -C "%SystemDrive%\www\media" reset --hard "origin/master" 
 +"%ProgramFiles%\Git\bin\git.exe" -C "%SystemDrive%\www\media" gc --aggressive --prune="all" 
 +"%ProgramFiles%\Git\bin\git.exe-C "%SystemDrive%\www\media" fsck --full --strict
  
-<code> +::################## 
-@echo off+::# Bootstrap Darkroom 
 +::##################
  
-:: User\Downloads +RMDIR /S /Q "%SystemDrive%\www\media\themes\bootstrap_darkroom\.git" 
-tar -czf "%UserProfile%\Downloads\piwigo-files-auto-%RANDOM%.tar.gz" -C "%SystemDrive%\www" "media"+"%ProgramFiles%\Git\bin\git.exe" -"%SystemDrive%\www\media\themes\bootstrap_darkroom" init --initial-branch="master" 
 +"%ProgramFiles%\Git\bin\git.exe" -C "%SystemDrive%\www\media\themes\bootstrap_darkroomadd "."
  
-:: NAS +::###################################### 
-::tar -czf "D:\Servers\Scheduled Backups\piwigo-files-auto-%RANDOM%.tar.gz" -C "%SystemDrive%\www" "media"+"%ProgramFiles%\Git\bin\git.exe" -C "%SystemDrive%\www\media\themes\bootstrap_darkroom" config "user.email" "espionage724@x" 
 +::###################################### 
 + 
 +"%ProgramFiles%\Git\bin\git.exe" -"%SystemDrive%\www\media\themes\bootstrap_darkroom" commit --message="x" 
 + 
 +"%ProgramFiles%\Git\bin\git.exe" -C "%SystemDrive%\www\media\themes\bootstrap_darkroom" remote add "origin" "https://github.com/Piwigo/piwigo-bootstrap-darkroom.git" 
 +"%ProgramFiles%\Git\bin\git.exe" -C "%SystemDrive%\www\media\themes\bootstrap_darkroom" pull --depth "1" --recurse-submodules "origin" "master" --rebase 
 + 
 +"%ProgramFiles%\Git\bin\git.exe" -C "%SystemDrive%\www\media\themes\bootstrap_darkroom" reset --hard "origin/master" 
 +"%ProgramFiles%\Git\bin\git.exe" -C "%SystemDrive%\www\media\themes\bootstrap_darkroomgc --aggressive --prune="all" 
 +"%ProgramFiles%\Git\bin\git.exe" -C "%SystemDrive%\www\media\themes\bootstrap_darkroomfsck --full --strict
  
 :: End</code> :: End</code>
 +
 +  "%SystemDrive%\www\scripts\media\Git Fix.bat"
 +
 +====== Task Scheduler ======
 +
 +===== PHP-CGI =====
 +
 +  * Auto-start
 +
 +  SCHTASKS /Create /SC "ONLOGON" /TN "Media PHP-CGI" /TR "%SystemDrive%\www\scripts\media\PHP-CGI.bat" /F
 +
 +===== Update =====
 +
 +  * Daily ''01:00:00 AM''
 +
 +  SCHTASKS /Create /SC "DAILY" /TN "Media Update" /TR "%SystemDrive%\www\scripts\media\Update.bat" /ST "01:00" /F
 +
 +===== Back-up =====
 +
 +  * Monthly (2nd) ''01:10:00 AM''
 +
 +  SCHTASKS /Create /SC "MONTHLY" /D "2" /M "*" /TN "Media Back-up" /TR "%SystemDrive%\www\scripts\media\Back-up.bat" /ST "01:10" /F
 +
 +===== Maintenance =====
 +
 +  * Monthly (2nd) ''01:30:00 AM''
 +
 +  SCHTASKS /Create /SC "MONTHLY" /D "2" /M "*" /TN "Media Maintenance" /TR "%SystemDrive%\www\scripts\media\Maintenance.bat" /ST "01:30" /F
  
 ====== Initial Setup ====== ====== Initial Setup ======
Line 278: Line 322:
 ===== config.inc.php ===== ===== config.inc.php =====
  
 +  * [[https://piwigo.org/forum/viewtopic.php?pid=159584#p159584|nginx Rewrite source]]
 +  * [[https://doc.piwigo.org/import-and-manage-photos/file-formats-compatible-piwigo#block-5cef6409208a4b3ead19b930f85942b2|Video Uploading source]]
   * [[https://github.com/Piwigo/Piwigo/blob/master/include/config_default.inc.php|More Settings]]   * [[https://github.com/Piwigo/Piwigo/blob/master/include/config_default.inc.php|More Settings]]
  
-  notepad "%SystemDrive%\www\media\local\config\config.inc.php"+  "notepad.exe" "%SystemDrive%\www\media\local\config\config.inc.php"
  
 <code> <code>
Line 291: Line 337:
 // Minimal Logging // Minimal Logging
 $conf['log_level'] = 'EMERGENCY'; $conf['log_level'] = 'EMERGENCY';
 +
 +// Hide PHP Warnings
 +$conf['show_php_errors'] = E_ALL & ~E_DEPRECATED & ~E_NOTICE & ~E_WARNING;
  
 // Header Links // Header Links
 $conf['links'] = array( $conf['links'] = array(
   'https://realmofespionage.xyz' => 'Realm of Espionage',   'https://realmofespionage.xyz' => 'Realm of Espionage',
-  'https://wiki.realmofespionage.xyz' => 'RoE | Wiki', +  'https://wiki.realmofespionage.xyz/start' => 'RoE | Wiki',
-  'https://blog.realmofespionage.xyz' => 'RoE | Blog',+
   'https://wiki.realmofespionage.xyz/user;espionage724' => 'Webmaster Info',   'https://wiki.realmofespionage.xyz/user;espionage724' => 'Webmaster Info',
   'https://wiki.realmofespionage.xyz/servers;windows;nginx;piwigo' => 'Instance Configuration Notes',   'https://wiki.realmofespionage.xyz/servers;windows;nginx;piwigo' => 'Instance Configuration Notes',
Line 303: Line 351:
 // Video Uploading // Video Uploading
 $conf['upload_form_all_types'] = true; $conf['upload_form_all_types'] = true;
 +
 $conf['file_ext'] = array_merge( $conf['file_ext'] = array_merge(
   $conf['picture_ext'],   $conf['picture_ext'],
-  array('tiff', 'tif', 'mpg','zip','avi','mp3','ogg','pdf','webm','mp4')+  array('mp4','webmv','m4v','webm','mov')
   );   );
  
Line 311: Line 360:
 ?></code> ?></code>
  
-====== Albums ======+===== database.inc.php =====
  
-===== 2004Scape (localhost) =====+  * :!: Change ''db_password''
  
-  * https://media.realmofespionage.xyz/index/category/2+  "notepad.exe" "%SystemDrive%\www\media\local\config\config.inc.php"
  
 <code> <code>
-<a href="https://wiki.realmofespionage.xyz/games;windows;2004scape_localhost" target="_blank" rel="noopener">Windows</a> | <a href="https://wiki.realmofespionage.xyz/games;linux;2004scape_localhost" target="_blank" rel="noopener">Linux</a> | <a href="https://wiki.realmofespionage.xyz/games;bsd;2004scape_localhost" target="_blank" rel="noopener">FreeBSD</a> | <a href="https://lostcity.rs/t/singleplayer-main-branch-scripts-and-desktop-start-launchers-on-windows-linux-freebsd/54" target="_blank" rel="noopener">Lost City Forums</a> +<?php 
-</code>+$conf['dblayer''mysqli'; 
 +$conf['db_base'] = 'piwigo'; 
 +$conf['db_user''piwigo'; 
 +$conf['db_password''x'; 
 +$conf['db_host''localhost';
  
-===== 2009Scape (localhost) =====+$prefixeTable 'piwigo_';
  
-  * https://media.realmofespionage.xyz/index/category/3+define('PHPWG_INSTALLED', true); 
 +define('PWG_CHARSET', 'utf-8'); 
 +define('DB_CHARSET', 'utf8'); 
 +define('DB_COLLATE', '');
  
-<code> +?></code>
-<a href="https://wiki.realmofespionage.xyz/servers;windows;games;2009scape_localhost" target="_blank" rel="noopener">Windows</a> | <a href="https://wiki.realmofespionage.xyz/servers;linux;games;2009scape_localhost" target="_blank" rel="noopener">Linux</a> | <a href="https://wiki.realmofespionage.xyz/servers;bsd;games;2009scape_localhost" target="_blank" rel="noopener">FreeBSD</a> | <a href="https://forum.2009scape.org/viewtopic.php?t=1038-singleplayer-server-rt4-client-master-branches-scripts-and-desktop-start-launchers-on-windows-linux" target="_blank" rel="noopener">2009Scape Forums</a> +
-</code>+
  
-===== Diablo II =====+====== Backup ======
  
-  * https://media.realmofespionage.xyz/index/category/9+===== Folder =====
  
-<code> +****
-<a href="https://wiki.realmofespionage.xyz/games;windows;diablo_2" target="_blank" rel="noopener">Windows</a> | <a href="https://wiki.realmofespionage.xyz/games;linux;wine;diablo_2" target="_blank" rel="noopener">Linux</a> | <a href="https://wiki.realmofespionage.xyz/games;bsd;wine;diablo_2" target="_blank" rel="noopener">FreeBSD</a> +
-</code>+
  
-==== Espionage ====+  "tar.exe" -czf "%UserProfile%\Downloads\piwigo-files-manual-%RANDOM%.tar.gz" -C "%SystemDrive%\www" "media"
  
-  * https://media.realmofespionage.xyz/index/category/10 +===== Database =====
-  * :?: Needed different sorting order: Numeric 1-9+
  
-<code>Amazon (Spear), SP, Classic (non-LoD), /players 1</code>+****
  
-===== Old School RuneScape =====+  CD "%UserProfile%\Downloads" && "%ProgramFiles%\MariaDB 12.2\bin\mariadb-dump.exe" -u "root" --opt -r "piwigo.sql" "piwigo"
  
-  * https://media.realmofespionage.xyz/index/category/4+====== Restore ======
  
-<code> +===== Database =====
-<a href="https://secure.runescape.com/m=hiscore_oldschool_hardcore_ironman/hiscorepersonal?user1=Espionage724" target="_blank" rel="noopener">Hardcore</a> | <a href="https://secure.runescape.com/m=hiscore_oldschool_ironman/hiscorepersonal?user1=Espionage724" target="_blank" rel="noopener">Ironman</a> | <a href="https://secure.runescape.com/m=hiscore_oldschool/hiscorepersonal?user1=Espionage724" target="_blank" rel="noopener">Overall</a> | <a href="https://oldschool.runescape.wiki/w/Special:Contributions/Espionage724" target="_blank" rel="noopener">OSRS Wiki</a> +
-</code>+
  
-===== RuneScape =====+  * [[#database|Initial set-up]]
  
-  * https://media.realmofespionage.xyz/index/category/5+  "%ProgramFiles%\MariaDB 12.2\bin\mariadb.exe" -u "root" --execute="CREATE DATABASE piwigo" 
 + 
 +  "%ProgramFiles%\MariaDB 12.2\bin\mariadb.exe" -u "root" "piwigo" < "%UserProfile%\Downloads\piwigo.sql" 
 + 
 +====== Resources ====== 
 + 
 +===== Albums Formatting ===== 
 + 
 +==== 4 Links ==== 
 + 
 +  * https://media.realmofespionage.xyz/index/category/2
  
 <code> <code>
-<a href="https://secure.runescape.com/m=hiscore_hardcore_ironman/compare?user1=Espionage724" target="_blank" rel="noopener">Hardcore</a> | <a href="https://secure.runescape.com/m=hiscore_ironman/compare?user1=Espionage724" target="_blank" rel="noopener">Ironman</a> | <a href="https://secure.runescape.com/m=hiscore/compare?user1=Espionage724" target="_blank" rel="noopener">Overall</a> | <a href="https://apps.runescape.com/runemetrics/app/overview/player/Espionage724" target="_blank" rel="noopener">RuneMetrics</a> | <a href="https://runescape.wiki/w/Special:Contributions/Espionage724" target="_blank" rel="noopener">RuneScape Wiki</a>+<a href="https://wiki.realmofespionage.xyz/games;windows;2004scape_localhost" target="_blank" rel="noopener">Windows</a> | <a href="https://wiki.realmofespionage.xyz/games;linux;2004scape_localhost" target="_blank" rel="noopener">Linux</a> | <a href="https://wiki.realmofespionage.xyz/games;bsd;2004scape_localhost" target="_blank" rel="noopener">FreeBSD</a> | <a href="https://lostcity.rs/t/singleplayer-main-branch-scripts-and-desktop-start-launchers-on-windows-linux-freebsd/54" target="_blank" rel="noopener">Lost City Forums</a>
 </code> </code>
  
-===== World of Warcraft 3.3.5 =====+==== Single Link ====
  
-  * https://media.realmofespionage.xyz/index/category/6+  * https://media.realmofespionage.xyz/picture/268/category/17
  
 <code> <code>
-<a href="https://wiki.realmofespionage.xyz/servers;windows;games;trinitycore_3.3.5_localhost" target="_blank" rel="noopener">Windows</a> | <a href="https://wiki.realmofespionage.xyz/servers;linux;games;trinitycore_3.3.5_localhost" target="_blank" rel="noopener">Linux</a> | <a href="https://wiki.realmofespionage.xyz/servers;bsd;games;trinitycore_3.3.5_localhost" target="_blank" rel="noopener">FreeBSD</a> | <a href="https://talk.trinitycore.org/t/singleplayer-scripts-and-desktop-start-launchers-on-windows-linux-freebsd/33293" target="_blank" rel="noopener">TrinityCore Forums</a>+<a href="https://wiki.realmofespionage.xyz/games;windows;dota_2_steamcmd" target="_blank" rel="noopener">Notes</a>
 </code> </code>
 +
 +===== TODOs =====
 +
 +  * Show title on pictures (long titles get cut-off in navbar)
 +  * AI ([[https://piwigo.org/forum/viewtopic.php?pid=192438#p192438|post]], [[https://github.com/Piwigo/Piwigo/commits/master/include/config_default.inc.php|config.inc.php]])
  
C:/www/wiki/data/attic/servers/windows/nginx/piwigo.1737933539.txt.gz · Last modified: by Sean Rhone

Except where otherwise noted, content on this wiki is licensed under the following license: CC0 1.0 Universal
CC0 1.0 Universal Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki