| Both sides previous revisionPrevious revisionNext revision | Previous revision |
| servers:windows:nginx:piwigo [2025/01/26 18:18] – Sean Rhone | servers:windows:nginx:piwigo [2026/01/22 04:00] (current) – [config.inc.php] Sean Rhone |
|---|
| ====== 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 ====== |
| |
| "%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 ===== |
| ====== 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; |
| 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" |
| 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] |
| ; 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"; |
| } | } |
| |
| ===== 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> |
| "%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_darkroom" reset --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_darkroom" pull 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 |
| :: 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" -u "root" -p --opt -r "piwigo-database-%RANDOM%.sql" "piwigo" | "%ProgramFiles%\Git\bin\git.exe" -C "%SystemDrive%\www\media" init --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" -C "%SystemDrive%\www\media\themes\bootstrap_darkroom" init --initial-branch="master" |
| | "%ProgramFiles%\Git\bin\git.exe" -C "%SystemDrive%\www\media\themes\bootstrap_darkroom" add "." |
| |
| :: 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" -C "%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_darkroom" gc --aggressive --prune="all" |
| | "%ProgramFiles%\Git\bin\git.exe" -C "%SystemDrive%\www\media\themes\bootstrap_darkroom" fsck --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 ====== |
| ===== 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> |
| // 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', |
| // 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') |
| ); | ); |
| |
| ?></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]]) |
| |