projects / github / wallabag / wallabag.git / blame
| Commit | Line | Data |
|---|---|---|
| 792097fb | 1 | <?php |
| 3602405e NL |
2 | /** |
| 3 | * wallabag, self hostable application allowing you to not miss any content anymore | |
| 4 | * | |
| 5 | * @category wallabag | |
| 6 | * @author Nicolas Lœuillet <nicolas@loeuillet.org> | |
| 7 | * @copyright 2013 | |
| 8 | * @license http://opensource.org/licenses/MIT see COPYING file | |
| 9 | */ | |
| 10 | ||
| 792097fb NL |
11 | $errors = array(); |
| 12 | $successes = array(); | |
| 1be13ba1 | 13 | |
| 9fdd8843 | 14 | $final = false; |
| d61e86a3 | 15 | $email = ""; |
| 9fdd8843 | 16 | |
| 5e26c910 | 17 | require_once('install_functions.php'); |
| 444f1406 | 18 | |
| 1be13ba1 NL |
19 | if (isset($_GET['clean'])) { |
| 20 | if (is_dir('install')){ | |
| f5618feb | 21 | delTree('install', true); |
| 8df90295 TC |
22 | header('Location: index.php'); |
| 23 | } | |
| 24 | if (is_dir('cache')) { | |
| f5618feb | 25 | delTree('cache', false, false); |
| 8df90295 | 26 | header('Location: index.php'); |
| 1be13ba1 NL |
27 | } |
| 28 | } | |
| 29 | ||
| fecb62a3 | 30 | if (isset($_POST['download'])) { |
| fb5a9666 | 31 | if (!file_put_contents("cache/vendor.zip", fopen("http://static.wallabag.org/files/vendor.zip", 'r'))) { |
| d967a1fa | 32 | $errors[] = 'Impossible to download vendor.zip. Please <a href="http://wllbg.org/vendor">download it manually</a> and unzip it in your wallabag folder.'; |
| 792097fb NL |
33 | } |
| 34 | else { | |
| 35 | if (extension_loaded('zip')) { | |
| 36 | $zip = new ZipArchive(); | |
| 37 | if ($zip->open("cache/vendor.zip") !== TRUE){ | |
| 38 | $errors[] = 'Impossible to open cache/vendor.zip. Please unzip it manually in your wallabag folder.'; | |
| 39 | } | |
| 40 | if ($zip->extractTo(realpath(''))) { | |
| 41 | @unlink("cache/vendor.zip"); | |
| 42 | $successes[] = 'twig is now installed, you can install wallabag.'; | |
| 43 | } | |
| 44 | else { | |
| 45 | $errors[] = 'Impossible to extract cache/vendor.zip. Please unzip it manually in your wallabag folder.'; | |
| 46 | } | |
| 47 | $zip->close(); | |
| 48 | } | |
| 49 | else { | |
| 50 | $errors[] = 'zip extension is not enabled in your PHP configuration. Please unzip cache/vendor.zip in your wallabag folder.'; | |
| 51 | } | |
| 52 | } | |
| 53 | } | |
| fecb62a3 | 54 | else if (isset($_POST['install'])) { |
| 792097fb NL |
55 | if (!is_dir('vendor')) { |
| 56 | $errors[] = 'You must install twig before.'; | |
| ca056e7f | 57 | } else { |
| 792097fb | 58 | $continue = true; |
| ca056e7f TC |
59 | $salt = generate_salt(); |
| 60 | $content = file_get_contents('inc/poche/config.inc.default.php'); | |
| 792097fb | 61 | |
| ca056e7f TC |
62 | // User informations |
| 63 | $username = trim($_POST['username']); | |
| 64 | $password = trim($_POST['password']); | |
| d61e86a3 | 65 | $email = trim($_POST['email']); |
| ca056e7f | 66 | $salted_password = sha1($password . $username . $salt); |
| 792097fb | 67 | |
| ca056e7f TC |
68 | // Database informations |
| 69 | $moreQueries = array(); | |
| 792097fb | 70 | |
| ca056e7f TC |
71 | if ($_POST['db_engine'] == 'sqlite') { |
| 72 | if (!copy('install/poche.sqlite', 'db/poche.sqlite')) { | |
| 467503fb | 73 | $errors[] = 'Impossible to create the SQLite database file. Please check your file permissions.'; |
| 792097fb NL |
74 | } |
| 75 | else { | |
| ca056e7f TC |
76 | $db_path = 'sqlite:' . realpath('') . '/db/poche.sqlite'; |
| 77 | $handle = new PDO($db_path); | |
| 78 | $handle->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); | |
| 79 | $sql_structure = ""; | |
| 80 | } | |
| 81 | } else { | |
| 82 | // MySQL and Postgre | |
| 0ae1e652 TC |
83 | /* |
| 84 | * Default values for server if not filled | |
| 85 | */ | |
| 86 | $server = "localhost"; | |
| 87 | $database = "wallabag"; | |
| 88 | ||
| ca056e7f TC |
89 | try { |
| 90 | ||
| 91 | if ($_POST['db_engine'] == 'mysql') { | |
| 7f8f8271 | 92 | if ($_POST['mysql_server'] != "") {$server = $_POST['mysql_server'];} // if server and database are filled |
| 0ae1e652 TC |
93 | if ($_POST['mysql_database'] != "") {$database = $_POST['mysql_database'];} |
| 94 | ||
| dfc1d3e8 TC |
95 | $sql_structure = file_get_contents('install/mysql.sql'); |
| 96 | ||
| 976d6935 TC |
97 | if (isset($_POST['mysql_utf8_mb4'])) { |
| 98 | //with UTF8-MB4 | |
| 0ae1e652 | 99 | $db_path = 'mysql:host=' . $server . ';dbname=' . $database . ';charset=utf8mb4'; |
| 976d6935 TC |
100 | $handle = new PDO($db_path, $_POST['mysql_user'], $_POST['mysql_password'], array( |
| 101 | PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES utf8mb4', | |
| 102 | )); | |
| 054c9d88 | 103 | $content = str_replace("define ('MYSQL_USE_UTF8MB4', FALSE);", "define ('MYSQL_USE_UTF8MB4', TRUE);", $content); |
| 976d6935 | 104 | } else { // regular UTF8 |
| dfc1d3e8 | 105 | $sql_structure = str_replace(" DEFAULT CHARSET=utf8mb4", "", $sql_structure); // replace the UTF8-MB4 occurences inside the mysql.sql file |
| 0ae1e652 | 106 | $db_path = 'mysql:host=' . $server . ';dbname=' . $database; |
| 976d6935 TC |
107 | $handle = new PDO($db_path, $_POST['mysql_user'], $_POST['mysql_password']); |
| 108 | } | |
| 0ae1e652 TC |
109 | $handle->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); |
| 110 | ||
| 111 | $content = str_replace("define ('STORAGE_SERVER', 'localhost');", "define ('STORAGE_SERVER', '".$server."');", $content); | |
| 112 | $content = str_replace("define ('STORAGE_DB', 'poche');", "define ('STORAGE_DB', '".$database."');", $content); | |
| ca056e7f TC |
113 | $content = str_replace("define ('STORAGE_USER', 'poche');", "define ('STORAGE_USER', '".$_POST['mysql_user']."');", $content); |
| 114 | $content = str_replace("define ('STORAGE_PASSWORD', 'poche');", "define ('STORAGE_PASSWORD', '".$_POST['mysql_password']."');", $content); | |
| ca056e7f TC |
115 | |
| 116 | $moreQueries[] = "INSERT INTO `entries` (`id`, `title`, `url`, `is_read`, `is_fav`, `content`, `user_id`) VALUES | |
| 86edff44 NL |
117 | (1, 'Framabag, un nouveau service libre et gratuit', 'http://www.framablog.org/index.php/post/2014/02/05/Framabag-service-libre-gratuit-interview-developpeur', 0, 0, 0x0a3c68323e556e6520696e74657276696577206465204e69636f6c61732c20736f6e2064c3a976656c6f70706575722e3c2f68323e0a3c703e3c656d3e496c206e6520766f757320612073c3bb72656d656e742070617320c3a96368617070c3a920717565206e6f74726520636f6e736f6d6d6174696f6e20646520636f6e74656e75732064752057656220657374207465727269626c656d656e74206368726f6e6f706861676520657420706172746963756c69c3a872656d656e7420667275737472616e746520746f757420c3a0206c6120666f6973c2a03a206e6f6e207365756c656d656e74206e6f757320706173736f6e732062656175636f7570202874726f70c2a03f292064652074656d707320656e206c69676e6520c3a0206578706c6f726572206c6573206d696e6573206175726966c3a8726573206465206c6120746f696c652c20792064c3a974656374616e742070c3a970697465732065742066696c6f6e732c206d616973206e6f757320736f6d6d657320737572746f757420636f6e7374616d6d656e7420656e206d616e7175652e204dc3aa6d65207369206e6f7573206e6520736f6d6d6573207061732064616e73206c65207a617070696e67206672c3a96ec3a9746971756520736920666163696c656d656e742064c3a96e6f6e63c3a920706172206c657320646f637465732070737963686f6c6f677565732071756920706f6e74696669656e7420737572206c65732064616e67657273206475206e756dc3a9726971756520706f7572206c6573206a65756e65732063657276656c6c65732c20696c206e6f7573207669656e7420736f7576656e74206c6520676fc3bb7420616d6572206465206ce28099696e6163686576c3a9c2a03a20706173206c652074656d707320646520746f7574206c69726520283c6120687265663d22687474703a2f2f66722e77696b74696f6e6172792e6f72672f77696b692f544c4452223e544c3b44523c2f613e2065737420646576656e75206c6520636c696e2064e28099c593696c206d692d6669677565206d692d72616973696e2064e28099756e652067c3a96ec3a9726174696f6e206465206c65637465757273207072657373c3a973292c207061732074726f70206c652074656d70732064652072c3a9666cc3a963686972206e6f6e20706c75732068c3a96c61732c20706173206c652074656d707320646520737569767265206c6120726962616d62656c6c65206465206c69656e73206173736f6369c3a97320c3a020756e2061727469636c65e280a63c6272202f3e3c2f656d3e3c2f703e0a3c703e3c656d3e506f7572206e6f757320646f6e6e657220626f6e6e6520636f6e736369656e63652c206e6f75732072616e67656f6e73207363727570756c657573656d656e7420756e206d61727175652d7061676520646520706c75732064616e7320756e20736f75732d646f73736965722071756920656e20636f6d706f7274652064c3a96ac3a0203235362c206e6f7573206e6f746f6e7320756e20c3a96cc3a96d656e7420646520706c75732064616e73206c6120746f756a6f757273207269646963756c656d656e74206c6f6e67756520746f75646f756c697374652c2062726566206e6f75732072656d6574746f6e7320c3a020706c757320746172642c2063e280996573742dc3a02d64697265206c6520706c757320736f7576656e742061757820696e74726f757661626c65732063616c656e6465732067726563717565732c206c6520736f696e206465206c69726520767261696d656e7420756e2061727469636c65206a7567c3a920696e74c3a972657373616e742c20646520726567617264657220756e6520766964c3a96f207369676e616cc3a96520706172206c65732072c3a97a6f73736f63696f732c206465206c69726520756e20636861706974726520656e746965722064e28099756e206f75767261676520646973706f6e69626c6520656e206c69676e65e280a63c6272202f3e3c2f656d3e3c2f703e0a3c703e3c656d3e416c6f7273206269656e2073c3bb722c20c3a02064c3a966617574206465206e6f757320646f6e6e657220746f7574206c652074656d70732071756920736572616974206ec3a963657373616972652c2064657320736f6c7574696f6e73206578697374656e7420706f7572206e6f7573207065726d657474726520646520c2abc2a06c69726520706c75732074617264c2a0c2bb20656e20736175766567617264616e74206c65207072c3a9636965757820706f6c6c656e206465206e6f7320627574696e61676573206465207369746520656e20736974652c2065742064e28099656e20666169726520756c74c3a97269657572656d656e7420766f747265206d69656cc2a03b2063e280996573742062656c20657420626f6e206d616973206c65732072756368657320736f6e7420756e207065752064697374616e7465732c20c3a7612073e28099617070656c6c65206c6520636c6f756420286e6f7320616d69732074656368696573206de280996f6e74206269656e206578706c697175c3a9206d616973206ae280996169207365756c656d656e7420636f6d70726973207175652064657320747275637320c3a0206d6f6920736f6e742073757220646573206d616368696e6573206c6f696e7461696e65732c20c3a761206e65206d652072617373757265207061732074726f702920657420656c6c657320736f6e7420736f7576656e742070726f707269c3a97461697265732c206e65206c61697373616e7420656e7472657220717565206c6573203c733e7574696c69736174657572733c2f733e20636f6e736f6d6d61746575727320706179616e74732065742071756920636f6e73656e74656e7420c3a0206c6575727320636f6e646974696f6e732e2053616e7320636f6d70746572207175652064652067726f7320626f7572646f6e73207669656e6e656e742070726f666974657220706c7573206f75206d6f696e73206469736372c3a874656d656e7420646520746f757465732063657320747261636573206465206e6f75732d6dc3aa6d657320717569207065726d657474656e74206465206d6f6ec3a97469736572206e6f7472652070726f66696cc2a03a207369206a6520636f6c6c65637465207375722063657320736572766963657320286e65206c6573206e6f6d6d6f6e73207061732c206a757374656d656e742920756e652073c3a97269652064e2809961727469636c657320737572206ce280996964c3a965206465204e6174757265206368657a2044696465726f742c206a6520726563657672616920646976657273657320736f6c6c696369746174696f6e7320706f757220646576656e697220636c69656e74206465206c6120626f757469717565204e61747572652026616d703b2044c3a9636f75766572746520647520626f756c65766172642044696465726f742e2045742073692064e280996176656e74757265206c65732070726f6772616d6d6573206465206c61204e5341206d6f756c696e656e7420737572206c6520736572766963652c206a6520736572616920706575742dc3aa74726520756e206a6f75722064616e7320756e65206c6973746520646573206d696c6974616e7473206e61747572697374657320696e64c3a973697261626c657320737572206c657320766f6c73206465206c612050616e416d20286a65206e65207361697320706c75732074726f70207369206a6520706c616973616e7465206cc3a02c2066696e616c656d656e74e280a6293c6272202f3e3c2f656d3e3c2f703e0a3c703e3c656d3e4c6120626f6e6e65206964c3a965c2a03a20c2abc2a0736520636f6e7374697475657220756e2072c3a9736572766f697220646520646f63756d656e74732073c3a96c656374696f6e6ec3a97320c3a020706172636f7572697220706c75732074617264c2a0c2bb20617070656c61697420646f6e6320756e6520617574726520626f6e6e65206964c3a9652c2063656c6c652064e2809961766f6972206c6520636f6e7472c3b46c652064652063652072c3a9736572766f69722c206465206e6f74726520636f6c6c656374696f6e20706572736f6e6e656c6c652e2043e28099657374204e69636f6c6173204cc59375696c6c65742c2063692d646573736f757320696e74657276696577c3a92c207175692073e28099792065737420636f6c6cc3a9206176656320756e652062656c6c65206170706c69636174696f6e20617070656cc3a96520657568e280a6206f75692c20617070656cc3a9652057616c6c616261672e3c6272202f3e3c2f656d3e3c2f703e0a3c703e3c656d3e4672616d61736f667420736f757469656e742064e28099617574616e7420706c757320736f6e20696e6974696174697665207175e280993c6120687265663d22687474703a2f2f7777772e6672616d61626c6f672e6f72672f696e6465782e7068702f706f73742f323031342f30312f33312f4765656b74696f6e6e6572642d57616c6c61626167223e6f6e206c7569206120636865726368c3a920646573206d6973c3a872657320706f757220756e6520686973746f697265206465206e6f6d3c2f613e206574207175e28099696c2065737420706f737369626c652064e28099696e7374616c6c657220736f692d6dc3aa6d6520756e6520636f7069652064652057616c6c616261672073757220736f6e2070726f70726520736974652e3c6272202f3e3c2f656d3e3c2f703e0a3c703e3c656d3e4c6520706574697420706c7573206465204672616d61736f66742c2072c3a97365617520746f756a6f7572732064c3a973697265757820646520766f75732070726f706f7365722064657320616c7465726e617469766573206c6962c3a972617472696365732c2063e2809965737420646520766f75732070726f706f736572202873757220696e736372697074696f6e207072c3a9616c61626c652920756e20616363c3a873206175204672616d616261672c2061757472656d656e742064697420766f7472652057616c6c616261672073757220756e2073657276657572204672616d612a2061766563206e6f74726520676172616e74696520646520636f6e666964656e7469616c6974c3a92e20436f6d6d6520706f7572206c65204672616d616e6577732c206e6f757320766f7573206163637565696c6c6f6e7320766f6c6f6e74696572732064616e73206c61206c696d697465206465206e6f732063617061636974c3a9732c20656e20766f757320696e766974616e7420c3a020766f7573206c616e6365722064616e7320766f747265206175746f2d68c3a962657267656d656e742064652057616c6c616261672e3c6272202f3e4365742061727469636c65206573742074726f70206c6f6e67c2a03f204d657474657a2d6c652064616e73203c6120687265663d22687474703a2f2f7777772e6672616d616261672e6f72672f696e6465782e706870223e766f747265204672616d616261673c2f613e20657420686f702e3c6272202f3e3c2f656d3e3c2f703e0a3c703e3c656d3e4672616d61626c6f67c2a03a2053616c7574204e69636f6c6173e280a62054752070657578207465207072c3a973656e74657220627269c3a876656d656e74c2a03f3c6272202f3e3c2f656d3e3c2f703e0a3c703e53616c7574c2a0212044c3a976656c6f70706575722050485020646570756973207175656c7175657320616e6ec3a96573206d61696e74656e616e742028313020616e73292c206ae28099616920766f756c75206d652072656d657474726520c3a0206e697665617520746563686e697175656d656e74207061726c616e742028646570756973203320616e732c206ae28099616920706173206d616c206cc3a26368c3a9206c6520636c6176696572292e20506f7572206d6573206265736f696e7320706572736f732c206ae28099616920646f6e63206372c3a9c3a920756e2070657469742070726f6a657420706f75722072656d706c6163657220756e6520736f6c7574696f6e2070726f707269c3a97461697265206578697374616e74652e2053616e7320617563756e65207072c3a974656e74696f6e2c206ae2809961692068c3a962657267c3a92063652070726f6a6574207375722047697468756220657420636f6d6d652063e28099657374206c61207365756c6520736f6c7574696f6e203c656d3e6f70656e20736f757263653c2f656d3e20646520636520747970652c206c65206e6f6d62726520646520706572736f6e6e657320696e74c3a972657373c3a965732061206175676d656e74c3a920e280a63c2f703e0a3c703e3c656d3e4c6573207574696c6973617465757273206465207365727669636573204672616d61736f6674206e65206c6520736176656e742070617320666f7263c3a96d656e742c206d6169732074752061732064c3a96ac3a020706173206d616c207061727469636970c3a920c3a0206c61204672616d6147616c617869652c206e6f6ec2a03f3c6272202f3e3c2f656d3e3c2f703e0a3c703e456e2065666665742e204ae28099616920636f6d6d656e63c3a920756e20706c7567696e20706f7572204672616d616e6577732c203c6120687265663d2268747470733a2f2f6769746875622e636f6d2f6e69636f736f6d622f74747273732d70757267652d6163636f756e7473223e74747273732d70757267652d6163636f756e74733c2f613e2c20717569207065726d6574206465206e6574746f796572206c61206261736520646520646f6e6ec3a9657320646520636f6d7074657320706c7573207574696c6973c3a9732e204d616973206365203c656d3e706c7567696e3c2f656d3e2061206265736f696e2064e28099c3aa747265207465726d696ec3a920c3a0203130302520706f757220c3aa74726520696e74c3a96772c3a9206175207365696e206465204672616d616e6577732028657420646f6e632064652054696e792054696e7920525353292c207369207175656c7175e28099756e20736f756861697465206de2809961696465722c20696c206ee2809979206120617563756e20736f7563692e3c6272202f3e4ae28099616920617573736920666169742031206f7520322061707061726974696f6e732064616e73206465732074726164756374696f6e7320706f7572204672616d61626c6f672e205269656e2064e2809965787472616f7264696e616972652c206a65206e652073756973207061732062696c696e6775652c20c3a761206d65207065726d6574206465206de28099656e747261c3ae6e65722e3c2f703e0a3c703e3c656d3e5061726c6f6e73206465207375697465206465206365207175692066c3a2636865c2a03a20746f6e206170706c69636174696f6e2057616c6c616261672c20656c6c652073e28099617070656c6c6169742070617320e2809c506f636865e2809d2c206176616e74c2a03f205475206e6f7573207261636f6e746573206ce28099686973746f697265c2a03f3c6272202f3e3c2f656d3e3c2f703e0a3c703e45756820656e20656666657420e280a62044c3a96ac3a02c20706f757271756f69203c656d3e706f6368653c2f656d3ec2a03f20506172636520717565206ce28099756e206465732074726f697320c2abc2a074c3a96e6f7273c2a0c2bb20737572206c65206d61726368c3a92073e28099617070656c6c65203c656d3e506f636b65743c2f656d3e2e20436f6d6d65206d6f6e206170706c69206ee28099c3a9746169742064657374696ec3a965207175e28099c3a0206d6f6e20757361676520706572736f6e6e656c2061752064c3a9706172742c206a65206e65206d6520737569732070617320746f72747572c3a9206269656e206c6f6e6774656d70732e3c2f703e0a3c703e43657420c3a974c3a92c206f6e2061206661696c6c69206368616e676572206465206e6f6d2c207175616e6420696c2079206120657520646520706c757320656e20706c75732064e280997574696c69736174657572732e2045742070756973206f6e2073e28099657374206469742071756520706f6368652c2063e28099c3a97461697420706173206d616c2c20c3a76120736f6e6e616974206269656e206672616ec3a761697320657420707569732061766563206c6573207175656c717565732064697a61696e65732064e280997574696c69736174657572732c206f6e206e652067c3aa6e657261697420706572736f6e6e652e3c2f703e0a3c703e43e280996573742073616e7320636f6d707465722061766563206c657320736f6369c3a974c3a97320616dc3a972696361696e6573206574206c6575722066c3a2636865757365206d616e696520646520766f756c6f697220656e766f796572206c657572732061766f6361747320c3a020746f757420626f7574206465206368616d702e204c65203233206a616e766965722c206ae280996169207265c3a77520756e20656d61696c206465206c61207061727420647520636162696e65742064e2809961766f6361747320646520506f636b6574206d652064656d616e64616e74206465206368616e676572206c65206e6f6d2c206c65206c6f676f2c206465206e6520706c7573207574696c69736572206c65207465726d6520e2809c726561642d69742d6c61746572e2809d2028c2abc2a06c6973657a206c6520706c75732074617264c2a0c2bb29206574206465206e6520706c757320646972652071756520506f636b6574206ee280996573742070617320677261747569742028746f7574206573742070617274692064e280993c6120687265663d2268747470733a2f2f747769747465722e636f6d2f77616c6c616261676170702f7374617475732f343233373836333635393434323235373932223e756e2074776565743c2f613e206fc3b9206a65207175616c6966696520506f636b657420646520c2abc2a06e6f6e2066726565c2a0c2bb20c3a0207361766f6972206e6f6e206c69627265292e20427265662c206dc3aa6d65207369206a652073656d626c6169732064616e73206d6f6e2064726f69742c206ae280996169207175616e64206dc3aa6d652070726973206c612064c3a9636973696f6e206465206368616e676572206465206e6f6d2065742057616c6c6162616720657374206ec3a92c20737569746520617578203c6120687265663d22687474703a2f2f6672616d61646174652e6f72672f73747564732e7068703f736f6e646167653d6c6c6370366f6a70796339706b6c6861223e64697a61696e65732064652070726f706f736974696f6e73206465206e6f6d207265c3a77565733c2f613e2e2043e2809965737420756e206dc3a96c616e676520656e747265206c652077616c6c61627920286465206c612066616d696c6c6520646573206b616e676f75726f75732c207175692073746f636b656e742064616e73206c65757220706f63686520636520717569206c65757220657374206368657229206574203c656d3e6261673c2f656d3e20286c6573207465726d657320736163202f207361636f636865202f2062657361636520736f6e7420c3a96e6f726dc3a96d656e7420726576656e7573292e204d616973206d61696e74656e616e742c206f6e207661206465206ce280996176616e742c20706c75732064652074656d707320c3a020706572647265206176656320c3a7612c206f6e2061206475207061696e20737572206c6120706c616e6368652e3c6272202f3e3c696d67207372633d22687474703a2f2f7777772e6672616d61626c6f672e6f72672f7075626c69632f5f696d672f6672616d61626c6f672f77616c6c6162795f626162792e6a70672220616c743d2277616c6c61627920617665632062c3a962c3a92064616e7320736120706f6368652220636c6173733d22633122207469746c653d2277616c6c61627920617665632062c3a962c3a92064616e7320736120706f63686522202f3e206372c3a96469742070686f746f203c6120687265663d22687474703a2f2f7777772e666c69636b722e636f6d2f70686f746f732f3236373832383634404e30302f353032373230323233342f696e2f70686f746f6c6973742d3845654a35412d6831544c36762d4e454c38312d636e4e6b536f2d39594d3174762d374b636736622d387a70416f612d61315a4c4d4e2d39594d3339722d3768355341442d38456548664c2d3845654677752d647456776e4d2d38756f4d45312d4a457a58652d47713471792d3932564a50522d43786531762d38483344324a2d61315a464e732d395937324b362d38456547784c2d354c353346782d354e6b454e732d3555384354592d354e6b7373682d6e6b6176462d3943726777502d3773644341612d647566324b682d685a65707a792d685a645531652d685a656f66462d685a656b44672d685a656741592d685a654d5a6e2d6a61486741662d3850383744322d354e677152762d6154343851422d685a645634592d685a654336342d45526770732d3556594747642d3556594a42312d354e6b72466b2d364a786837682d3768395075512d4552664d782d6831553169682d683155534278223e57696c6c69616d2057617262793c2f613e20717569206175746f72697365206578706c69636974656d656e7420746f7574652072c3a97574696c69736174696f6e2e3c2f703e0a3c703e3c656d3e426f6e2c20616c6f7273206578706c697175652d6d6f6920636520717565206a65207661697320706f75766f69722066616972652061766563204672616d61626167e280a63c6272202f3e3c2f656d3e3c2f703e0a3c703e416c6f7273204672616d616261672c20c3a761207465207065726d6574206465207465206372c3a9657220756e20636f6d7074652067726174756974656d656e74206574206c696272656d656e7420706f757220706f75766f6972207574696c697365722057616c6c616261672e205365756c6520746f6e206164726573736520656d61696c20657374206ec3a963657373616972652c206f6e207365206368617267652064e28099696e7374616c6c6572206574206465206d657474726520c3a0206a6f75722057616c6c6162616720706f757220746f692e20547520706575782064e2809961696c6c657572732070726f6669746572203c6120687265663d22687474703a2f2f7777772e6672616d61736f66742e6e65742f23746f705067436c6f7564223e64e280996175747265732073657276696365732070726f706f73c3a97320706172204672616d61736f6674206963693c2f613e2e3c2f703e0a3c703ec380206365206a6f75722c20696c207920612038333420636f6d70746573206372c3a9c3a97320737572204672616d616261672e3c2f703e0a3c703e3c656d3e566f7573206176657a20767261696d656e7420636f6ec3a7752063652073657276696365206166696e207175e280996f6e20707569737365206ce280997574696c69736572206176656320756e206d6178696d756d2064e280996f7574696c732c206e6f6ec2a03f3c6272202f3e3c2f656d3e3c2f703e0a3c703e4175746f7572206465206ce280996170706c69636174696f6e207765622c20696c206578697374652064c3a96ac3a020646573206170706c69636174696f6e7320706f757220736d61727470686f6e65732028416e64726f69642065742057696e646f77732050686f6e65292c2064657320657874656e73696f6e732046697265666f7820657420476f6f676c65204368726f6d652e3c2f703e0a3c703e436f6d6d652057616c6c6162616720706f7373c3a864652064657320666c7578205253532c2063e2809965737420666163696c65206465206c697265206c65732061727469636c657320736175766567617264c3a97320737572207361206c697365757365202873692063656c6c652d6369207065726d6574206465206c6972652064657320666c757820525353292e2043616c696272652028c2abc2a06c6f67696369656c206465206c6563747572652c2064652067657374696f6e206465206269626c696f7468c3a87175657320657420646520636f6e76657273696f6e206465206669636869657273206e756dc3a972697175657320646520747970652065626f6f6b206f75206c6976726520c3a96c656374726f6e69717565c2a0c2bb2c6e6f757320646974207562756e74752d66722e6f72672920696e74c3a867726520646570756973207175656c717565732073656d61696e6573206d61696e74656e616e74206c6120706f73736962696c6974c3a92064652072c3a9637570c3a9726572206c65732061727469636c6573206e6f6e206c75732c20707261746971756520706f757220666169726520756e20666963686965722065507562c2a0213c2f703e0a3c703e44e28099617574726573206170706c69636174696f6e7320776562207065726d657474656e74206ce28099696e74c3a967726174696f6e20617665632057616c6c61626167202846726573685253532c204c6565642065742054696e792054696e792052535320706f7572206c657320616772c3a96761746575727320646520666c7578292e204ce2809941504920717569207365726120646973706f6e69626c652064616e73206c612070726f636861696e652076657273696f6e2064652057616c6c61626167207065726d657474726120656e636f726520706c75732064e28099696e74657261637469766974c3a92e3c2f703e0a3c703e3c656d3e5920612d742d696c20756e206d6f6465206465206c65637475726520686f7273206c69676e65206f75206573742d6365207175652063e28099657374207072c3a9767520706f7572206c65732070726f636861696e65732076657273696f6e73c2a03f3c6272202f3e3c2f656d3e3c2f703e0a3c703e496c2079206120756e2070736575646f206d6f646520686f7273206c69676e652c20646973706f6e69626c652061766563206ce280996170706c69636174696f6e20416e64726f69642e204f6e20706575742072c3a9637570c3a9726572202876696120756e20666c75782052535329206c65732061727469636c6573206e6f6e206c757320717565206ce280996f6e206120736175766567617264c3a9732e20556e6520666f69732064c3a9636f6e6e656374c3a92c206f6e207065757420636f6e74696e75657220c3a0206c6972652073757220736f6e20736d61727470686f6e65206f75207361207461626c65747465206c65732061727469636c65732e2050617220636f6e7472652c20696c206d616e7175652064657320666f6e6374696f6e6e616c6974c3a973c2a03a207175616e64207475206d61727175657320756e2061727469636c6520636f6d6d65206c752c206365206ee28099657374207061732073796e6368726f6e6973c3a92061766563206c612076657273696f6e207765622064652057616c6c616261672e204ae28099657370c3a8726520717565206a652073756973207072657371756520636c6169722064616e73206d6573206578706c69636174696f6e732e3c2f703e0a3c703e506f7572206c612076322c20717569206573742064c3a96ac3a020656e20636f7572732064652064c3a976656c6f7070656d656e742c206fc3b9206a652073756973206269656e20616964c3a9207061722056696e63656e74204a6f757373652c206f6e2061757261206c6120706f73736962696c6974c3a92064e2809961766f697220756e2076726169206d6f646520686f7273206c69676e652e3c2f703e0a3c703e3c656d3e416c6f7273207369206f6e2076657574206169646572202f2070617274696369706572202f20747269666f75696c6c6572206c6520636f6465202f20766f757320656e766f79657220646573207265746f7572732c206f6e206661697420636f6d6d656e74c2a03f3c6272202f3e3c2f656d3e3c2f703e0a3c703e4f6e207065757420616964657220646520706c75736965757273206661c3a76f6e73c2a03a3c2f703e0a3c756c3e3c6c693e7574696c697365722077616c6c61626167206574206e6f75732072656d6f6e746572206c65732070726f626cc3a86d65732072656e636f6e7472c3a973c2a03b3c2f6c693e0a3c6c693e706172746963697065722061752064c3a976656c6f7070656d656e74206465206ce280996170706c69636174696f6e2068747470733a2f2f6769746875622e636f6d2f77616c6c616261672f77616c6c616261672053692053696c6578202f2053796d666f6e7932202f2048544d4c35202f206574632e207465207061726c656e742c206ee2809968c3a97369746520706173c2a0213c2f6c693e0a3c6c693e636f6d6d6520746f75742070726f6a65742c206c652067726f7320706f696e74206e6f697220657374206c65206d616e71756520646520646f63756d656e746174696f6e2e203c6120687265663d22687474703a2f2f646f632e77616c6c616261672e6f7267223e456c6c652065737420646973706f206963693c2f613e206d61697320696c206d616e71756520706c65696e2064652063686f73657320657420746f7574206ee280996573742070617320c3a0206a6f7572c2a03b3c2f6c693e0a3c6c693e7061726c65722064652057616c6c61626167206175746f757220646520766f7573c2a03b3c2f6c693e0a3c6c693e696c20657869737465203c6120687265663d2268747470733a2f2f666c617474722e636f6d2f7468696e672f313236353438302f706f6368652d612d726561642d69742d6c617465722d6f70656e2d736f757263652d73797374656d223e756e20636f6d70746520466c617474723c2f613e2e3c2f6c693e0a3c2f756c3e3c703e3c656d3e4c65206d6f74206465206c612066696ee280a63f3c6272202f3e3c2f656d3e3c2f703e0a3c703e4d6572636920c3a0204672616d61736f66742064e280996163637565696c6c697220657420646520736f7574656e69722057616c6c61626167c2a0213c2f703e0a3c703e4c6120726f7574652065737420656e636f7265206269656e206c6f6e67756520706f7572206e6520706c7573207574696c6973657220646520736f6c7574696f6e732070726f707269c3a97461697265732c206d616973206f6e2064657672616974207920617272697665722c206e6f6ec2a03f3c2f703e0a3c703e3c696d67207372633d22687474703a2f2f7777772e6672616d61626c6f672e6f72672f7075626c69632f5f696d672f6672616d61626c6f672f706c65696e4c6573506f636865732e706e672220616c743d226672616d61736f667420706c65696e206c657320706f636865732220636c6173733d22633122207469746c653d226672616d61736f667420706c65696e206c657320706f6368657322202f3e3c6272202f3e3c6120687265663d22687474703a2f2f6672616d616c61622e6f72672f676b6e642d63726561746f722f223e6861636b657a2047c3a967c3a9c2a0213c2f613e3c2f703e0a, 1), |
| 118 | (2, 'wallabag/wallabag', 'https://github.com/wallabag/wallabag', 0, 0, 0x3c7370616e20636c6173733d226e616d65223e524541444d452e6d643c2f7370616e3e3c703e77616c6c6162616720697320612073656c6620686f737461626c65206170706c69636174696f6e20616c6c6f77696e6720796f7520746f206e6f74206d69737320616e7920636f6e74656e7420616e796d6f72652e20436c69636b2c20736176652c2072656164206974207768656e20796f752063616e2e20497420657874726163747320636f6e74656e7420736f207468617420796f752063616e2072656164206974207768656e20796f7520686176652074696d652e3c2f703e0a3c703e4d6f726520696e666f726d6174696f6e73206f6e206f757220776562736974653a203c6120687265663d22687474703a2f2f77616c6c616261672e6f7267223e77616c6c616261672e6f72673c2f613e3c2f703e0a3c68323e3c6120636c6173733d22616e63686f722220687265663d2268747470733a2f2f6769746875622e636f6d2f77616c6c616261672f77616c6c61626167236c6963656e7365223e3c2f613e4c6963656e73653c2f68323e0a3c703e436f7079726967687420c2a920323031302d32303134204e69636f6c6173204cc59375696c6c6574203c6120687265663d226d61696c746f3a6e69636f6c6173406c6f6575696c6c65742e6f7267223e6e69636f6c6173406c6f6575696c6c65742e6f72673c2f613e205468697320776f726b20697320667265652e20596f752063616e2072656469737472696275746520697420616e642f6f72206d6f6469667920697420756e64657220746865207465726d73206f662074686520446f205768617420546865204675636b20596f752057616e7420546f205075626c6963204c6963656e73652c2056657273696f6e20322c206173207075626c69736865642062792053616d20486f63657661722e205365652074686520434f5059494e472066696c6520666f72206d6f72652064657461696c732e3c2f703e0a, 1), | |
| 119 | (3, 'a self hostable application for saving web pages | wallabag', 'https://www.wallabag.org/', 0, 1, 0x0a3c64697620636c6173733d22726f77223e0a3c64697620636c6173733d22636f6c2d6c672d3820636f6c2d6d642d313220636f6c2d78732d313220636f6c2d736d2d3132223e0a3c703e77616c6c616261672028666f726d65726c7920706f636865292069732061203c7374726f6e673e73656c6620686f737461626c65206170706c69636174696f6e20666f7220736176696e67207765622070616765733c2f7374726f6e673e2e20556e6c696b65206f746865722073657276696365732cc2a077616c6c6162616720697320667265652028617320696e2066726565646f6d2920616e64206f70656e20736f757263652e3c2f703e0a3c2f6469763e0a0a3c2f6469763e0a3c64697620636c6173733d22726f77223e0a3c64697620636c6173733d22636f6c2d6c672d3820636f6c2d6d642d313220636f6c2d78732d313220636f6c2d736d2d3132223e0a3c703e576974682074686973206170706c69636174696f6e20796f752077696c6c206e6f74206d69737320636f6e74656e7420616e796d6f72652e203c7374726f6e673e436c69636b2c20736176652c2072656164206974207768656e20796f752077616e743c2f7374726f6e673e2e2049742073617665732074686520636f6e74656e7420796f752073656c65637420736f207468617420796f752063616e2072656164206974207768656e20796f7520686176652074696d652e3c2f703e0a3c2f6469763e0a0a3c2f6469763e0a3c64697620636c6173733d22726f77223e0a3c64697620636c6173733d22636f6c2d6c672d3620636f6c2d6d642d313220636f6c2d78732d313220636f6c2d736d2d3132223e0a3c68323e486f7720697420776f726b733c2f68323e0a3c703e5468616e6b7320746f2074686520626f6f6b6d61726b6c6574206f72203c61207469746c653d22446f776e6c6f6164732220687265663d22687474703a2f2f7777772e77616c6c616261672e6f72672f646f776e6c6f6164732f223e74686972642d7061727479206170706c69636174696f6e733c2f613e2c20796f75207361766520616e2061727469636c6520696e20796f7572c2a077616c6c6162616720746f2072656164206974206c617465722e205468656e2c207768656e20796f75206f70656e20796f75722077616c6c616261672c203c7374726f6e673e796f752063616e20636f6d666f727461626c79207265616420796f75722061727469636c65733c2f7374726f6e673e2e3c2f703e0a3c68323e486f7720746f207573652077616c6c616261673c2f68323e0a3c703e5468657265206172652074776f207761797320746f207573652077616c6c616261673a20796f752063616e203c6120687265663d22687474703a2f2f7777772e77616c6c616261672e6f72672f6672657175656e746c792d61736b65642d7175657374696f6e732f23486f775f63616e5f495f696e7374616c6c5f77616c6c616261675f616e645f776861745f6172655f7468655f726571756972656d656e7473223e696e7374616c6c2069743c2f613ec2a06f6e20796f75722077656220736572766572206f7220796f752063616ec2a03c6120687265663d22687474703a2f2f6170702e696e746865706f6368652e636f6d223e63726561746520616e206163636f756e743c2f613ec2a06174204672616d616261672028776520696e7374616c6c20616e642075706772616465c2a077616c6c6162616720666f7220796f75292e3c2f703e0a3c2f6469763e0a0a3c2f6469763e0a, 1);"; | |
| ca056e7f TC |
120 | $moreQueries[] = "INSERT INTO `tags` (`id`, `value`) VALUES (1, 'opensource');"; |
| 121 | $moreQueries[] = "INSERT INTO `tags_entries` (`id`, `entry_id`, `tag_id`) VALUES (1, 2, 1);"; | |
| 86edff44 | 122 | |
| ca056e7f TC |
123 | } |
| 124 | else if ($_POST['db_engine'] == 'postgres') { | |
| 0ae1e652 TC |
125 | if ($_POST['pg_server'] != "") {$server = $_POST['pg_server'];} |
| 126 | if ($_POST['pg_database'] != "") {$database = $_POST['pg_database'];} | |
| 127 | ||
| 128 | $db_path = 'pgsql:host=' . $server . ';dbname=' . $database; | |
| 129 | $handle = new PDO($db_path, $_POST['pg_user'], $_POST['pg_password']); | |
| 130 | $handle->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); | |
| 131 | ||
| 132 | $content = str_replace("define ('STORAGE_SERVER', 'localhost');", "define ('STORAGE_SERVER', '".$server."');", $content); | |
| 133 | $content = str_replace("define ('STORAGE_DB', 'poche');", "define ('STORAGE_DB', '".$database."');", $content); | |
| ca056e7f TC |
134 | $content = str_replace("define ('STORAGE_USER', 'poche');", "define ('STORAGE_USER', '".$_POST['pg_user']."');", $content); |
| 135 | $content = str_replace("define ('STORAGE_PASSWORD', 'poche');", "define ('STORAGE_PASSWORD', '".$_POST['pg_password']."');", $content); | |
| ca056e7f TC |
136 | |
| 137 | $moreQueries[] = "INSERT INTO entries (title, url, is_read, is_fav, content, user_id) VALUES | |
| 3dca040a | 138 | ('Framabag, un nouveau service libre et gratuit', 'http://www.framablog.org/index.php/post/2014/02/05/Framabag-service-libre-gratuit-interview-developpeur', false, false, convert_from(decode('3c68323e556e6520696e74657276696577206465204e69636f6c61732c20736f6e2064c3a976656c6f70706575722e3c2f68323e0a3c703e3c656d3e496c206e6520766f757320612073c3bb72656d656e742070617320c3a96368617070c3a920717565206e6f74726520636f6e736f6d6d6174696f6e20646520636f6e74656e75732064752057656220657374207465727269626c656d656e74206368726f6e6f706861676520657420706172746963756c69c3a872656d656e7420667275737472616e746520746f757420c3a0206c6120666f6973c2a03a206e6f6e207365756c656d656e74206e6f757320706173736f6e732062656175636f7570202874726f70c2a03f292064652074656d707320656e206c69676e6520c3a0206578706c6f726572206c6573206d696e6573206175726966c3a8726573206465206c6120746f696c652c20792064c3a974656374616e742070c3a970697465732065742066696c6f6e732c206d616973206e6f757320736f6d6d657320737572746f757420636f6e7374616d6d656e7420656e206d616e7175652e204dc3aa6d65207369206e6f7573206e6520736f6d6d6573207061732064616e73206c65207a617070696e67206672c3a96ec3a9746971756520736920666163696c656d656e742064c3a96e6f6e63c3a920706172206c657320646f637465732070737963686f6c6f677565732071756920706f6e74696669656e7420737572206c65732064616e67657273206475206e756dc3a9726971756520706f7572206c6573206a65756e65732063657276656c6c65732c20696c206e6f7573207669656e7420736f7576656e74206c6520676fc3bb7420616d6572206465206ce28099696e6163686576c3a9c2a03a20706173206c652074656d707320646520746f7574206c69726520283c6120687265663d22687474703a2f2f66722e77696b74696f6e6172792e6f72672f77696b692f544c4452223e544c3b44523c2f613e2065737420646576656e75206c6520636c696e2064e28099c593696c206d692d6669677565206d692d72616973696e2064e28099756e652067c3a96ec3a9726174696f6e206465206c65637465757273207072657373c3a973292c207061732074726f70206c652074656d70732064652072c3a9666cc3a963686972206e6f6e20706c75732068c3a96c61732c20706173206c652074656d707320646520737569767265206c6120726962616d62656c6c65206465206c69656e73206173736f6369c3a97320c3a020756e2061727469636c65e280a63c6272202f3e3c2f656d3e3c2f703e0a3c703e3c656d3e506f7572206e6f757320646f6e6e657220626f6e6e6520636f6e736369656e63652c206e6f75732072616e67656f6e73207363727570756c657573656d656e7420756e206d61727175652d7061676520646520706c75732064616e7320756e20736f75732d646f73736965722071756920656e20636f6d706f7274652064c3a96ac3a0203235362c206e6f7573206e6f746f6e7320756e20c3a96cc3a96d656e7420646520706c75732064616e73206c6120746f756a6f757273207269646963756c656d656e74206c6f6e67756520746f75646f756c697374652c2062726566206e6f75732072656d6574746f6e7320c3a020706c757320746172642c2063e280996573742dc3a02d64697265206c6520706c757320736f7576656e742061757820696e74726f757661626c65732063616c656e6465732067726563717565732c206c6520736f696e206465206c69726520767261696d656e7420756e2061727469636c65206a7567c3a920696e74c3a972657373616e742c20646520726567617264657220756e6520766964c3a96f207369676e616cc3a96520706172206c65732072c3a97a6f73736f63696f732c206465206c69726520756e20636861706974726520656e746965722064e28099756e206f75767261676520646973706f6e69626c6520656e206c69676e65e280a63c6272202f3e3c2f656d3e3c2f703e0a3c703e3c656d3e416c6f7273206269656e2073c3bb722c20c3a02064c3a966617574206465206e6f757320646f6e6e657220746f7574206c652074656d70732071756920736572616974206ec3a963657373616972652c2064657320736f6c7574696f6e73206578697374656e7420706f7572206e6f7573207065726d657474726520646520c2abc2a06c69726520706c75732074617264c2a0c2bb20656e20736175766567617264616e74206c65207072c3a9636965757820706f6c6c656e206465206e6f7320627574696e61676573206465207369746520656e20736974652c2065742064e28099656e20666169726520756c74c3a97269657572656d656e7420766f747265206d69656cc2a03b2063e280996573742062656c20657420626f6e206d616973206c65732072756368657320736f6e7420756e207065752064697374616e7465732c20c3a7612073e28099617070656c6c65206c6520636c6f756420286e6f7320616d69732074656368696573206de280996f6e74206269656e206578706c697175c3a9206d616973206ae280996169207365756c656d656e7420636f6d70726973207175652064657320747275637320c3a0206d6f6920736f6e742073757220646573206d616368696e6573206c6f696e7461696e65732c20c3a761206e65206d652072617373757265207061732074726f702920657420656c6c657320736f6e7420736f7576656e742070726f707269c3a97461697265732c206e65206c61697373616e7420656e7472657220717565206c6573203c733e7574696c69736174657572733c2f733e20636f6e736f6d6d61746575727320706179616e74732065742071756920636f6e73656e74656e7420c3a0206c6575727320636f6e646974696f6e732e2053616e7320636f6d70746572207175652064652067726f7320626f7572646f6e73207669656e6e656e742070726f666974657220706c7573206f75206d6f696e73206469736372c3a874656d656e7420646520746f757465732063657320747261636573206465206e6f75732d6dc3aa6d657320717569207065726d657474656e74206465206d6f6ec3a97469736572206e6f7472652070726f66696cc2a03a207369206a6520636f6c6c65637465207375722063657320736572766963657320286e65206c6573206e6f6d6d6f6e73207061732c206a757374656d656e742920756e652073c3a97269652064e2809961727469636c657320737572206ce280996964c3a965206465204e6174757265206368657a2044696465726f742c206a6520726563657672616920646976657273657320736f6c6c696369746174696f6e7320706f757220646576656e697220636c69656e74206465206c6120626f757469717565204e61747572652026616d703b2044c3a9636f75766572746520647520626f756c65766172642044696465726f742e2045742073692064e280996176656e74757265206c65732070726f6772616d6d6573206465206c61204e5341206d6f756c696e656e7420737572206c6520736572766963652c206a6520736572616920706575742dc3aa74726520756e206a6f75722064616e7320756e65206c6973746520646573206d696c6974616e7473206e61747572697374657320696e64c3a973697261626c657320737572206c657320766f6c73206465206c612050616e416d20286a65206e65207361697320706c75732074726f70207369206a6520706c616973616e7465206cc3a02c2066696e616c656d656e74e280a6293c6272202f3e3c2f656d3e3c2f703e0a3c703e3c656d3e4c6120626f6e6e65206964c3a965c2a03a20c2abc2a0736520636f6e7374697475657220756e2072c3a9736572766f697220646520646f63756d656e74732073c3a96c656374696f6e6ec3a97320c3a020706172636f7572697220706c75732074617264c2a0c2bb20617070656c61697420646f6e6320756e6520617574726520626f6e6e65206964c3a9652c2063656c6c652064e2809961766f6972206c6520636f6e7472c3b46c652064652063652072c3a9736572766f69722c206465206e6f74726520636f6c6c656374696f6e20706572736f6e6e656c6c652e2043e28099657374204e69636f6c6173204cc59375696c6c65742c2063692d646573736f757320696e74657276696577c3a92c207175692073e28099792065737420636f6c6cc3a9206176656320756e652062656c6c65206170706c69636174696f6e20617070656cc3a96520657568e280a6206f75692c20617070656cc3a9652057616c6c616261672e3c6272202f3e3c2f656d3e3c2f703e0a3c703e3c656d3e4672616d61736f667420736f757469656e742064e28099617574616e7420706c757320736f6e20696e6974696174697665207175e280993c6120687265663d22687474703a2f2f7777772e6672616d61626c6f672e6f72672f696e6465782e7068702f706f73742f323031342f30312f33312f4765656b74696f6e6e6572642d57616c6c61626167223e6f6e206c7569206120636865726368c3a920646573206d6973c3a872657320706f757220756e6520686973746f697265206465206e6f6d3c2f613e206574207175e28099696c2065737420706f737369626c652064e28099696e7374616c6c657220736f692d6dc3aa6d6520756e6520636f7069652064652057616c6c616261672073757220736f6e2070726f70726520736974652e3c6272202f3e3c2f656d3e3c2f703e0a3c703e3c656d3e4c6520706574697420706c7573206465204672616d61736f66742c2072c3a97365617520746f756a6f7572732064c3a973697265757820646520766f75732070726f706f7365722064657320616c7465726e617469766573206c6962c3a972617472696365732c2063e2809965737420646520766f75732070726f706f736572202873757220696e736372697074696f6e207072c3a9616c61626c652920756e20616363c3a873206175204672616d616261672c2061757472656d656e742064697420766f7472652057616c6c616261672073757220756e2073657276657572204672616d612a2061766563206e6f74726520676172616e74696520646520636f6e666964656e7469616c6974c3a92e20436f6d6d6520706f7572206c65204672616d616e6577732c206e6f757320766f7573206163637565696c6c6f6e7320766f6c6f6e74696572732064616e73206c61206c696d697465206465206e6f732063617061636974c3a9732c20656e20766f757320696e766974616e7420c3a020766f7573206c616e6365722064616e7320766f747265206175746f2d68c3a962657267656d656e742064652057616c6c616261672e3c6272202f3e4365742061727469636c65206573742074726f70206c6f6e67c2a03f204d657474657a2d6c652064616e73203c6120687265663d22687474703a2f2f7777772e6672616d616261672e6f72672f696e6465782e706870223e766f747265204672616d616261673c2f613e20657420686f702e3c6272202f3e3c2f656d3e3c2f703e0a3c703e3c656d3e4672616d61626c6f67c2a03a2053616c7574204e69636f6c6173e280a62054752070657578207465207072c3a973656e74657220627269c3a876656d656e74c2a03f3c6272202f3e3c2f656d3e3c2f703e0a3c703e53616c7574c2a0212044c3a976656c6f70706575722050485020646570756973207175656c7175657320616e6ec3a96573206d61696e74656e616e742028313020616e73292c206ae28099616920766f756c75206d652072656d657474726520c3a0206e697665617520746563686e697175656d656e74207061726c616e742028646570756973203320616e732c206ae28099616920706173206d616c206cc3a26368c3a9206c6520636c6176696572292e20506f7572206d6573206265736f696e7320706572736f732c206ae28099616920646f6e63206372c3a9c3a920756e2070657469742070726f6a657420706f75722072656d706c6163657220756e6520736f6c7574696f6e2070726f707269c3a97461697265206578697374616e74652e2053616e7320617563756e65207072c3a974656e74696f6e2c206ae2809961692068c3a962657267c3a92063652070726f6a6574207375722047697468756220657420636f6d6d652063e28099657374206c61207365756c6520736f6c7574696f6e203c656d3e6f70656e20736f757263653c2f656d3e20646520636520747970652c206c65206e6f6d62726520646520706572736f6e6e657320696e74c3a972657373c3a965732061206175676d656e74c3a920e280a63c2f703e0a3c703e3c656d3e4c6573207574696c6973617465757273206465207365727669636573204672616d61736f6674206e65206c6520736176656e742070617320666f7263c3a96d656e742c206d6169732074752061732064c3a96ac3a020706173206d616c207061727469636970c3a920c3a0206c61204672616d6147616c617869652c206e6f6ec2a03f3c6272202f3e3c2f656d3e3c2f703e0a3c703e456e2065666665742e204ae28099616920636f6d6d656e63c3a920756e20706c7567696e20706f7572204672616d616e6577732c203c6120687265663d2268747470733a2f2f6769746875622e636f6d2f6e69636f736f6d622f74747273732d70757267652d6163636f756e7473223e74747273732d70757267652d6163636f756e74733c2f613e2c20717569207065726d6574206465206e6574746f796572206c61206261736520646520646f6e6ec3a9657320646520636f6d7074657320706c7573207574696c6973c3a9732e204d616973206365203c656d3e706c7567696e3c2f656d3e2061206265736f696e2064e28099c3aa747265207465726d696ec3a920c3a0203130302520706f757220c3aa74726520696e74c3a96772c3a9206175207365696e206465204672616d616e6577732028657420646f6e632064652054696e792054696e7920525353292c207369207175656c7175e28099756e20736f756861697465206de2809961696465722c20696c206ee2809979206120617563756e20736f7563692e3c6272202f3e4ae28099616920617573736920666169742031206f7520322061707061726974696f6e732064616e73206465732074726164756374696f6e7320706f7572204672616d61626c6f672e205269656e2064e2809965787472616f7264696e616972652c206a65206e652073756973207061732062696c696e6775652c20c3a761206d65207065726d6574206465206de28099656e747261c3ae6e65722e3c2f703e0a3c703e3c656d3e5061726c6f6e73206465207375697465206465206365207175692066c3a2636865c2a03a20746f6e206170706c69636174696f6e2057616c6c616261672c20656c6c652073e28099617070656c6c6169742070617320e2809c506f636865e2809d2c206176616e74c2a03f205475206e6f7573207261636f6e746573206ce28099686973746f697265c2a03f3c6272202f3e3c2f656d3e3c2f703e0a3c703e45756820656e20656666657420e280a62044c3a96ac3a02c20706f757271756f69203c656d3e706f6368653c2f656d3ec2a03f20506172636520717565206ce28099756e206465732074726f697320c2abc2a074c3a96e6f7273c2a0c2bb20737572206c65206d61726368c3a92073e28099617070656c6c65203c656d3e506f636b65743c2f656d3e2e20436f6d6d65206d6f6e206170706c69206ee28099c3a9746169742064657374696ec3a965207175e28099c3a0206d6f6e20757361676520706572736f6e6e656c2061752064c3a9706172742c206a65206e65206d6520737569732070617320746f72747572c3a9206269656e206c6f6e6774656d70732e3c2f703e0a3c703e43657420c3a974c3a92c206f6e2061206661696c6c69206368616e676572206465206e6f6d2c207175616e6420696c2079206120657520646520706c757320656e20706c75732064e280997574696c69736174657572732e2045742070756973206f6e2073e28099657374206469742071756520706f6368652c2063e28099c3a97461697420706173206d616c2c20c3a76120736f6e6e616974206269656e206672616ec3a761697320657420707569732061766563206c6573207175656c717565732064697a61696e65732064e280997574696c69736174657572732c206f6e206e652067c3aa6e657261697420706572736f6e6e652e3c2f703e0a3c703e43e280996573742073616e7320636f6d707465722061766563206c657320736f6369c3a974c3a97320616dc3a972696361696e6573206574206c6575722066c3a2636865757365206d616e696520646520766f756c6f697220656e766f796572206c657572732061766f6361747320c3a020746f757420626f7574206465206368616d702e204c65203233206a616e766965722c206ae280996169207265c3a77520756e20656d61696c206465206c61207061727420647520636162696e65742064e2809961766f6361747320646520506f636b6574206d652064656d616e64616e74206465206368616e676572206c65206e6f6d2c206c65206c6f676f2c206465206e6520706c7573207574696c69736572206c65207465726d6520e2809c726561642d69742d6c61746572e2809d2028c2abc2a06c6973657a206c6520706c75732074617264c2a0c2bb29206574206465206e6520706c757320646972652071756520506f636b6574206ee280996573742070617320677261747569742028746f7574206573742070617274692064e280993c6120687265663d2268747470733a2f2f747769747465722e636f6d2f77616c6c616261676170702f7374617475732f343233373836333635393434323235373932223e756e2074776565743c2f613e206fc3b9206a65207175616c6966696520506f636b657420646520c2abc2a06e6f6e2066726565c2a0c2bb20c3a0207361766f6972206e6f6e206c69627265292e20427265662c206dc3aa6d65207369206a652073656d626c6169732064616e73206d6f6e2064726f69742c206ae280996169207175616e64206dc3aa6d652070726973206c612064c3a9636973696f6e206465206368616e676572206465206e6f6d2065742057616c6c6162616720657374206ec3a92c20737569746520617578203c6120687265663d22687474703a2f2f6672616d61646174652e6f72672f73747564732e7068703f736f6e646167653d6c6c6370366f6a70796339706b6c6861223e64697a61696e65732064652070726f706f736974696f6e73206465206e6f6d207265c3a77565733c2f613e2e2043e2809965737420756e206dc3a96c616e676520656e747265206c652077616c6c61627920286465206c612066616d696c6c6520646573206b616e676f75726f75732c207175692073746f636b656e742064616e73206c65757220706f63686520636520717569206c65757220657374206368657229206574203c656d3e6261673c2f656d3e20286c6573207465726d657320736163202f207361636f636865202f2062657361636520736f6e7420c3a96e6f726dc3a96d656e7420726576656e7573292e204d616973206d61696e74656e616e742c206f6e207661206465206ce280996176616e742c20706c75732064652074656d707320c3a020706572647265206176656320c3a7612c206f6e2061206475207061696e20737572206c6120706c616e6368652e3c6272202f3e3c696d67207372633d22687474703a2f2f7777772e6672616d61626c6f672e6f72672f7075626c69632f5f696d672f6672616d61626c6f672f77616c6c6162795f626162792e6a70672220616c743d2277616c6c61627920617665632062c3a962c3a92064616e7320736120706f6368652220636c6173733d22633122207469746c653d2277616c6c61627920617665632062c3a962c3a92064616e7320736120706f63686522202f3e206372c3a96469742070686f746f203c6120687265663d22687474703a2f2f7777772e666c69636b722e636f6d2f70686f746f732f3236373832383634404e30302f353032373230323233342f696e2f70686f746f6c6973742d3845654a35412d6831544c36762d4e454c38312d636e4e6b536f2d39594d3174762d374b636736622d387a70416f612d61315a4c4d4e2d39594d3339722d3768355341442d38456548664c2d3845654677752d647456776e4d2d38756f4d45312d4a457a58652d47713471792d3932564a50522d43786531762d38483344324a2d61315a464e732d395937324b362d38456547784c2d354c353346782d354e6b454e732d3555384354592d354e6b7373682d6e6b6176462d3943726777502d3773644341612d647566324b682d685a65707a792d685a645531652d685a656f66462d685a656b44672d685a656741592d685a654d5a6e2d6a61486741662d3850383744322d354e677152762d6154343851422d685a645634592d685a654336342d45526770732d3556594747642d3556594a42312d354e6b72466b2d364a786837682d3768395075512d4552664d782d6831553169682d683155534278223e57696c6c69616d2057617262793c2f613e20717569206175746f72697365206578706c69636974656d656e7420746f7574652072c3a97574696c69736174696f6e2e3c2f703e0a3c703e3c656d3e426f6e2c20616c6f7273206578706c697175652d6d6f6920636520717565206a65207661697320706f75766f69722066616972652061766563204672616d61626167e280a63c6272202f3e3c2f656d3e3c2f703e0a3c703e416c6f7273204672616d616261672c20c3a761207465207065726d6574206465207465206372c3a9657220756e20636f6d7074652067726174756974656d656e74206574206c696272656d656e7420706f757220706f75766f6972207574696c697365722057616c6c616261672e205365756c6520746f6e206164726573736520656d61696c20657374206ec3a963657373616972652c206f6e207365206368617267652064e28099696e7374616c6c6572206574206465206d657474726520c3a0206a6f75722057616c6c6162616720706f757220746f692e20547520706575782064e2809961696c6c657572732070726f6669746572203c6120687265663d22687474703a2f2f7777772e6672616d61736f66742e6e65742f23746f705067436c6f7564223e64e280996175747265732073657276696365732070726f706f73c3a97320706172204672616d61736f6674206963693c2f613e2e3c2f703e0a3c703ec380206365206a6f75722c20696c207920612038333420636f6d70746573206372c3a9c3a97320737572204672616d616261672e3c2f703e0a3c703e3c656d3e566f7573206176657a20767261696d656e7420636f6ec3a7752063652073657276696365206166696e207175e280996f6e20707569737365206ce280997574696c69736572206176656320756e206d6178696d756d2064e280996f7574696c732c206e6f6ec2a03f3c6272202f3e3c2f656d3e3c2f703e0a3c703e4175746f7572206465206ce280996170706c69636174696f6e207765622c20696c206578697374652064c3a96ac3a020646573206170706c69636174696f6e7320706f757220736d61727470686f6e65732028416e64726f69642065742057696e646f77732050686f6e65292c2064657320657874656e73696f6e732046697265666f7820657420476f6f676c65204368726f6d652e3c2f703e0a3c703e436f6d6d652057616c6c6162616720706f7373c3a864652064657320666c7578205253532c2063e2809965737420666163696c65206465206c697265206c65732061727469636c657320736175766567617264c3a97320737572207361206c697365757365202873692063656c6c652d6369207065726d6574206465206c6972652064657320666c757820525353292e2043616c696272652028c2abc2a06c6f67696369656c206465206c6563747572652c2064652067657374696f6e206465206269626c696f7468c3a87175657320657420646520636f6e76657273696f6e206465206669636869657273206e756dc3a972697175657320646520747970652065626f6f6b206f75206c6976726520c3a96c656374726f6e69717565c2a0c2bb2c6e6f757320646974207562756e74752d66722e6f72672920696e74c3a867726520646570756973207175656c717565732073656d61696e6573206d61696e74656e616e74206c6120706f73736962696c6974c3a92064652072c3a9637570c3a9726572206c65732061727469636c6573206e6f6e206c75732c20707261746971756520706f757220666169726520756e20666963686965722065507562c2a0213c2f703e0a3c703e44e28099617574726573206170706c69636174696f6e7320776562207065726d657474656e74206ce28099696e74c3a967726174696f6e20617665632057616c6c61626167202846726573685253532c204c6565642065742054696e792054696e792052535320706f7572206c657320616772c3a96761746575727320646520666c7578292e204ce2809941504920717569207365726120646973706f6e69626c652064616e73206c612070726f636861696e652076657273696f6e2064652057616c6c61626167207065726d657474726120656e636f726520706c75732064e28099696e74657261637469766974c3a92e3c2f703e0a3c703e3c656d3e5920612d742d696c20756e206d6f6465206465206c65637475726520686f7273206c69676e65206f75206573742d6365207175652063e28099657374207072c3a9767520706f7572206c65732070726f636861696e65732076657273696f6e73c2a03f3c6272202f3e3c2f656d3e3c2f703e0a3c703e496c2079206120756e2070736575646f206d6f646520686f7273206c69676e652c20646973706f6e69626c652061766563206ce280996170706c69636174696f6e20416e64726f69642e204f6e20706575742072c3a9637570c3a9726572202876696120756e20666c75782052535329206c65732061727469636c6573206e6f6e206c757320717565206ce280996f6e206120736175766567617264c3a9732e20556e6520666f69732064c3a9636f6e6e656374c3a92c206f6e207065757420636f6e74696e75657220c3a0206c6972652073757220736f6e20736d61727470686f6e65206f75207361207461626c65747465206c65732061727469636c65732e2050617220636f6e7472652c20696c206d616e7175652064657320666f6e6374696f6e6e616c6974c3a973c2a03a207175616e64207475206d61727175657320756e2061727469636c6520636f6d6d65206c752c206365206ee28099657374207061732073796e6368726f6e6973c3a92061766563206c612076657273696f6e207765622064652057616c6c616261672e204ae28099657370c3a8726520717565206a652073756973207072657371756520636c6169722064616e73206d6573206578706c69636174696f6e732e3c2f703e0a3c703e506f7572206c612076322c20717569206573742064c3a96ac3a020656e20636f7572732064652064c3a976656c6f7070656d656e742c206fc3b9206a652073756973206269656e20616964c3a9207061722056696e63656e74204a6f757373652c206f6e2061757261206c6120706f73736962696c6974c3a92064e2809961766f697220756e2076726169206d6f646520686f7273206c69676e652e3c2f703e0a3c703e3c656d3e416c6f7273207369206f6e2076657574206169646572202f2070617274696369706572202f20747269666f75696c6c6572206c6520636f6465202f20766f757320656e766f79657220646573207265746f7572732c206f6e206661697420636f6d6d656e74c2a03f3c6272202f3e3c2f656d3e3c2f703e0a3c703e4f6e207065757420616964657220646520706c75736965757273206661c3a76f6e73c2a03a3c2f703e0a3c756c3e3c6c693e7574696c697365722077616c6c61626167206574206e6f75732072656d6f6e746572206c65732070726f626cc3a86d65732072656e636f6e7472c3a973c2a03b3c2f6c693e0a3c6c693e706172746963697065722061752064c3a976656c6f7070656d656e74206465206ce280996170706c69636174696f6e2068747470733a2f2f6769746875622e636f6d2f77616c6c616261672f77616c6c616261672053692053696c6578202f2053796d666f6e7932202f2048544d4c35202f206574632e207465207061726c656e742c206ee2809968c3a97369746520706173c2a0213c2f6c693e0a3c6c693e636f6d6d6520746f75742070726f6a65742c206c652067726f7320706f696e74206e6f697220657374206c65206d616e71756520646520646f63756d656e746174696f6e2e203c6120687265663d22687474703a2f2f646f632e77616c6c616261672e6f7267223e456c6c652065737420646973706f206963693c2f613e206d61697320696c206d616e71756520706c65696e2064652063686f73657320657420746f7574206ee280996573742070617320c3a0206a6f7572c2a03b3c2f6c693e0a3c6c693e7061726c65722064652057616c6c61626167206175746f757220646520766f7573c2a03b3c2f6c693e0a3c6c693e696c20657869737465203c6120687265663d2268747470733a2f2f666c617474722e636f6d2f7468696e672f313236353438302f706f6368652d612d726561642d69742d6c617465722d6f70656e2d736f757263652d73797374656d223e756e20636f6d70746520466c617474723c2f613e2e3c2f6c693e0a3c2f756c3e3c703e3c656d3e4c65206d6f74206465206c612066696ee280a63f3c6272202f3e3c2f656d3e3c2f703e0a3c703e4d6572636920c3a0204672616d61736f66742064e280996163637565696c6c697220657420646520736f7574656e69722057616c6c61626167c2a0213c2f703e0a3c703e4c6120726f7574652065737420656e636f7265206269656e206c6f6e67756520706f7572206e6520706c7573207574696c6973657220646520736f6c7574696f6e732070726f707269c3a97461697265732c206d616973206f6e2064657672616974207920617272697665722c206e6f6ec2a03f3c2f703e0a3c703e3c696d67207372633d22687474703a2f2f7777772e6672616d61626c6f672e6f72672f7075626c69632f5f696d672f6672616d61626c6f672f706c65696e4c6573506f636865732e706e672220616c743d226672616d61736f667420706c65696e206c657320706f636865732220636c6173733d22633122207469746c653d226672616d61736f667420706c65696e206c657320706f6368657322202f3e3c6272202f3e3c6120687265663d22687474703a2f2f6672616d616c61622e6f72672f676b6e642d63726561746f722f223e6861636b657a2047c3a967c3a9c2a0213c2f613e3c2f703e0a', 'hex'), 'UTF8'), 1), |
| 139 | ('wallabag/wallabag', 'https://github.com/wallabag/wallabag', false, false, convert_from(decode('3c7370616e20636c6173733d226e616d65223e524541444d452e6d643c2f7370616e3e3c703e77616c6c6162616720697320612073656c6620686f737461626c65206170706c69636174696f6e20616c6c6f77696e6720796f7520746f206e6f74206d69737320616e7920636f6e74656e7420616e796d6f72652e20436c69636b2c20736176652c2072656164206974207768656e20796f752063616e2e20497420657874726163747320636f6e74656e7420736f207468617420796f752063616e2072656164206974207768656e20796f7520686176652074696d652e3c2f703e0a3c703e4d6f726520696e666f726d6174696f6e73206f6e206f757220776562736974653a203c6120687265663d22687474703a2f2f77616c6c616261672e6f7267223e77616c6c616261672e6f72673c2f613e3c2f703e0a3c68323e3c6120636c6173733d22616e63686f722220687265663d2268747470733a2f2f6769746875622e636f6d2f77616c6c616261672f77616c6c61626167236c6963656e7365223e3c2f613e4c6963656e73653c2f68323e0a3c703e436f7079726967687420c2a920323031302d32303134204e69636f6c6173204cc59375696c6c6574203c6120687265663d226d61696c746f3a6e69636f6c6173406c6f6575696c6c65742e6f7267223e6e69636f6c6173406c6f6575696c6c65742e6f72673c2f613e205468697320776f726b20697320667265652e20596f752063616e2072656469737472696275746520697420616e642f6f72206d6f6469667920697420756e64657220746865207465726d73206f662074686520446f205768617420546865204675636b20596f752057616e7420546f205075626c6963204c6963656e73652c2056657273696f6e20322c206173207075626c69736865642062792053616d20486f63657661722e205365652074686520434f5059494e472066696c6520666f72206d6f72652064657461696c732e3c2f703e0a', 'hex'), 'UTF8'), 1), | |
| 140 | ('a self hostable application for saving web pages | wallabag', 'https://www.wallabag.org/', false, true, convert_from(decode('3c64697620636c6173733d22726f77223e0a3c64697620636c6173733d22636f6c2d6c672d3820636f6c2d6d642d313220636f6c2d78732d313220636f6c2d736d2d3132223e0a3c703e77616c6c616261672028666f726d65726c7920706f636865292069732061203c7374726f6e673e73656c6620686f737461626c65206170706c69636174696f6e20666f7220736176696e67207765622070616765733c2f7374726f6e673e2e20556e6c696b65206f746865722073657276696365732cc2a077616c6c6162616720697320667265652028617320696e2066726565646f6d2920616e64206f70656e20736f757263652e3c2f703e0a3c2f6469763e0a0a3c2f6469763e0a3c64697620636c6173733d22726f77223e0a3c64697620636c6173733d22636f6c2d6c672d3820636f6c2d6d642d313220636f6c2d78732d313220636f6c2d736d2d3132223e0a3c703e576974682074686973206170706c69636174696f6e20796f752077696c6c206e6f74206d69737320636f6e74656e7420616e796d6f72652e203c7374726f6e673e436c69636b2c20736176652c2072656164206974207768656e20796f752077616e743c2f7374726f6e673e2e2049742073617665732074686520636f6e74656e7420796f752073656c65637420736f207468617420796f752063616e2072656164206974207768656e20796f7520686176652074696d652e3c2f703e0a3c2f6469763e0a0a3c2f6469763e0a3c64697620636c6173733d22726f77223e0a3c64697620636c6173733d22636f6c2d6c672d3620636f6c2d6d642d313220636f6c2d78732d313220636f6c2d736d2d3132223e0a3c68323e486f7720697420776f726b733c2f68323e0a3c703e5468616e6b7320746f2074686520626f6f6b6d61726b6c6574206f72203c61207469746c653d22446f776e6c6f6164732220687265663d22687474703a2f2f7777772e77616c6c616261672e6f72672f646f776e6c6f6164732f223e74686972642d7061727479206170706c69636174696f6e733c2f613e2c20796f75207361766520616e2061727469636c6520696e20796f7572c2a077616c6c6162616720746f2072656164206974206c617465722e205468656e2c207768656e20796f75206f70656e20796f75722077616c6c616261672c203c7374726f6e673e796f752063616e20636f6d666f727461626c79207265616420796f75722061727469636c65733c2f7374726f6e673e2e3c2f703e0a3c68323e486f7720746f207573652077616c6c616261673c2f68323e0a3c703e5468657265206172652074776f207761797320746f207573652077616c6c616261673a20796f752063616e203c6120687265663d22687474703a2f2f7777772e77616c6c616261672e6f72672f6672657175656e746c792d61736b65642d7175657374696f6e732f23486f775f63616e5f495f696e7374616c6c5f77616c6c616261675f616e645f776861745f6172655f7468655f726571756972656d656e7473223e696e7374616c6c2069743c2f613ec2a06f6e20796f75722077656220736572766572206f7220796f752063616ec2a03c6120687265663d22687474703a2f2f6170702e696e746865706f6368652e636f6d223e63726561746520616e206163636f756e743c2f613ec2a06174204672616d616261672028776520696e7374616c6c20616e642075706772616465c2a077616c6c6162616720666f7220796f75292e3c2f703e0a3c2f6469763e0a0a3c2f6469763e0a', 'hex'), 'UTF8'), 1)"; | |
| ca056e7f TC |
141 | $moreQueries[] = "INSERT INTO tags (value) VALUES ('opensource')"; |
| 142 | $moreQueries[] = "INSERT INTO tags_entries (entry_id, tag_id) VALUES (2, 1)"; | |
| 792097fb | 143 | |
| ca056e7f | 144 | $sql_structure = file_get_contents('install/postgres.sql'); |
| 792097fb | 145 | } |
| ca056e7f | 146 | // create database structure |
| fdda9fd9 TC |
147 | if (!$handle) { |
| 148 | $continue = false; | |
| 149 | $errors[] = "Couldn't connect to your database server. Please check credentials."; | |
| 150 | } else { | |
| 151 | $query = $handle->exec($sql_structure); | |
| 152 | ||
| 153 | $usertest = executeQuery($handle,"SELECT * from users WHERE username = ?", array($username)); | |
| 154 | if (!empty($usertest)) { | |
| 155 | $continue = false; | |
| 156 | $errors[] = "An user already exists with this username in database."; | |
| 157 | } | |
| 158 | } | |
| 5395d7f8 | 159 | |
| ca056e7f | 160 | } catch (PDOException $e) { |
| fdda9fd9 TC |
161 | /* Error codes : |
| 162 | / 7 : PostgreSQL issues | |
| 163 | / 1045 : Access denied to the user : user doesn't exists | |
| 164 | / 1044 : Access denied to the user : user doesn't have the rights to connect to this database | |
| 165 | / 2005 : Unknown database server | |
| 166 | */ | |
| 167 | switch ($e->getCode()) { | |
| 168 | case 7: | |
| 169 | $errors[] = "PostgreSQL has encountered an issue : " . $e->getMessage(); | |
| 170 | break; | |
| 171 | case 1045: | |
| 172 | $errors[] = "The password for this user is incorrect, or this user doesn't exist."; | |
| 173 | break; | |
| 174 | case 1044: | |
| 175 | $errors[] = "The user isn't allowed to use this database."; | |
| 176 | break; | |
| 177 | case 2005: | |
| 178 | $errors[] = "The server can't be reached."; | |
| 179 | break; | |
| 180 | default: | |
| 181 | $errors[] = "A error happened while connecting to your database : " . $e->getMessage(); | |
| 182 | break; | |
| 183 | } | |
| ca056e7f TC |
184 | $continue = false; |
| 185 | } | |
| 186 | } | |
| 187 | } | |
| 054c9d88 | 188 | |
| ca056e7f | 189 | if ($continue) { |
| d61e86a3 TC |
190 | $sql = "INSERT INTO users (username, password, name, email) VALUES (?, ?, ?, ?)"; |
| 191 | $params = array($username, $salted_password, $username, $email); | |
| ca056e7f | 192 | $query = executeQuery($handle, $sql, $params); |
| 792097fb | 193 | |
| ca056e7f | 194 | $id_user = (int)$handle->lastInsertId('users_id_seq'); |
| 792097fb | 195 | |
| ca056e7f TC |
196 | $sql = 'INSERT INTO users_config ( user_id, name, value ) VALUES (?, ?, ?)'; |
| 197 | $params = array($id_user, 'pager', '10'); | |
| 198 | $query = executeQuery($handle, $sql, $params); | |
| 792097fb | 199 | |
| ca056e7f TC |
200 | $sql = 'INSERT INTO users_config ( user_id, name, value ) VALUES (?, ?, ?)'; |
| 201 | $params = array($id_user, 'language', 'en_EN.UTF8'); | |
| 202 | $query = executeQuery($handle, $sql, $params); | |
| 792097fb | 203 | |
| ca056e7f TC |
204 | foreach ($moreQueries as $query) { |
| 205 | executeQuery($handle, $query, array()); | |
| 206 | } | |
| 11ef4de5 | 207 | |
| 86edff44 | 208 | |
| ca056e7f | 209 | if (!copy('inc/poche/config.inc.default.php', 'inc/poche/config.inc.php')) { |
| 467503fb | 210 | $errors[] = 'Installation aborted, impossible to create inc/poche/config.inc.php file. Maybe you don\'t have write access to create it. Check your file permissions.'; |
| ca056e7f TC |
211 | } else { |
| 212 | if ($_POST['db_engine'] != 'sqlite') { | |
| 213 | $content = str_replace("define ('STORAGE', 'sqlite');", "define ('STORAGE', '".$_POST['db_engine']."');", $content); | |
| 214 | file_put_contents('inc/poche/config.inc.php', $content); | |
| 792097fb | 215 | } |
| ca056e7f TC |
216 | $content = str_replace("define ('SALT', '');", "define ('SALT', '".$salt."');", $content); |
| 217 | file_put_contents('inc/poche/config.inc.php', $content); | |
| 11ef4de5 | 218 | $final = true; |
| 792097fb NL |
219 | } |
| 220 | } | |
| ca056e7f | 221 | } |
| 792097fb NL |
222 | ?> |
| 223 | <!DOCTYPE html> | |
| 224 | <html> | |
| 225 | <head> | |
| 226 | <meta name="viewport" content="initial-scale=1.0"> | |
| 227 | <meta charset="utf-8"> | |
| 228 | <!--[if IE]> | |
| 229 | <meta http-equiv="X-UA-Compatible" content="IE=10"> | |
| 230 | <![endif]--> | |
| d967a1fa | 231 | <title>wallabag - installation</title> |
| 792097fb NL |
232 | <link rel="shortcut icon" type="image/x-icon" href="themes/baggy/img/favicon.ico" /> |
| 233 | <link rel="apple-touch-icon-precomposed" sizes="144x144" href="themes/baggy/img/apple-touch-icon-144x144-precomposed.png"> | |
| 234 | <link rel="apple-touch-icon-precomposed" sizes="72x72" href="themes/baggy/img/apple-touch-icon-72x72-precomposed.png"> | |
| 235 | <link rel="apple-touch-icon-precomposed" href="themes/baggy/img/apple-touch-icon-precomposed.png"> | |
| 236 | <link href='//fonts.googleapis.com/css?family=PT+Sans:700' rel='stylesheet' type='text/css'> | |
| 237 | <link rel="stylesheet" href="themes/baggy/css/ratatouille.css" media="all"> | |
| 238 | <link rel="stylesheet" href="themes/baggy/css/font.css" media="all"> | |
| 239 | <link rel="stylesheet" href="themes/baggy/css/main.css" media="all"> | |
| 240 | <link rel="stylesheet" href="themes/baggy/css/messages.css" media="all"> | |
| 241 | <link rel="stylesheet" href="themes/baggy/css/print.css" media="print"> | |
| b692691d | 242 | <script src="themes/_global/js/jquery-2.1.3.min.js"></script> |
| 792097fb | 243 | <script src="themes/baggy/js/init.js"></script> |
| 444f1406 TC |
244 | |
| 245 | ||
| 246 | <style type="text/css"> | |
| 247 | a { | |
| 248 | color:#000; | |
| 249 | text-decoration:underline; | |
| 250 | padding:0 1px; | |
| 251 | } | |
| 252 | a:hover { | |
| 253 | color:#fff; | |
| 254 | background-color:#333; | |
| 255 | text-decoration:none; | |
| 256 | padding:0 1px; | |
| 257 | } | |
| 258 | p { | |
| 259 | margin:0; | |
| 260 | padding:5px 0; | |
| 261 | } | |
| 262 | em { | |
| 263 | font-style:normal; | |
| 264 | background-color:#ffc; | |
| 265 | padding: 0.1em 0; | |
| 266 | } | |
| 267 | ul, ol { | |
| 268 | margin:10px 0 10px 20px; | |
| 269 | padding:0 0 0 15px; | |
| 270 | } | |
| 271 | ul li, ol li { | |
| 272 | margin:0 0 7px 0; | |
| 273 | padding:0 0 0 3px; | |
| 274 | } | |
| 275 | h2 { | |
| 276 | font-size:18px; | |
| 277 | padding:0; | |
| 278 | } | |
| 279 | h3 { | |
| 280 | font-size:16px; | |
| 281 | padding:0; | |
| 282 | margin:20px 0 5px 0; | |
| 283 | } | |
| 284 | h4 { | |
| 285 | font-size:14px; | |
| 286 | padding:0; | |
| 287 | margin:15px 0 5px 0; | |
| 288 | } | |
| 289 | code { | |
| 290 | font-size:1.1em; | |
| 291 | background-color:#f3f3ff; | |
| 292 | color:#000; | |
| 293 | } | |
| 294 | em strong { | |
| 295 | text-transform: uppercase; | |
| 296 | } | |
| 297 | table#chart { | |
| 298 | border-collapse:collapse; | |
| 299 | } | |
| 300 | table#chart th { | |
| 301 | background-color:#eee; | |
| 302 | padding:2px 3px; | |
| 303 | border:1px solid #fff; | |
| 304 | } | |
| 305 | table#chart td { | |
| 306 | text-align:center; | |
| 307 | padding:2px 3px; | |
| 308 | border:1px solid #eee; | |
| 309 | } | |
| 310 | table#chart tr.enabled td { | |
| 311 | /* Leave this alone */ | |
| 312 | } | |
| 313 | table#chart tr.disabled td, | |
| 314 | table#chart tr.disabled td a { | |
| 315 | } | |
| 316 | table#chart tr.disabled td a { | |
| 317 | text-decoration:underline; | |
| 318 | } | |
| 319 | div.chunk { | |
| 320 | margin:20px 0 0 0; | |
| 321 | padding:0 0 10px 0; | |
| 322 | border-bottom:1px solid #ccc; | |
| 323 | } | |
| 324 | .footnote, | |
| 325 | .footnote a { | |
| 326 | font:10px/12px verdana, sans-serif; | |
| 327 | color:#aaa; | |
| 328 | } | |
| 329 | .footnote em { | |
| 330 | background-color:transparent; | |
| 331 | font-style:italic; | |
| 332 | } | |
| 333 | .good{ | |
| 334 | background-color:#52CC5B; | |
| 335 | } | |
| 336 | .bad{ | |
| 337 | background-color:#F74343; | |
| 338 | font-style:italic; | |
| 339 | font-weight: bold; | |
| 340 | } | |
| 341 | .pass{ | |
| 342 | background-color:#FF9500; | |
| 343 | } | |
| c1e90b9e TC |
344 | .detail { |
| 345 | cursor: pointer; | |
| 444f1406 | 346 | } |
| dd0d7ad9 TC |
347 | .descriptions { |
| 348 | margin-left: 10%; | |
| 349 | position: relative; | |
| 350 | top: 50%; | |
| 351 | } | |
| 352 | .database_inputs { | |
| 353 | float: left; | |
| 354 | width: 50% | |
| 355 | } | |
| 356 | .database_info { | |
| 357 | width: 100%; | |
| 358 | overflow: auto; | |
| 359 | } | |
| 22f19b23 TC |
360 | .compatibity_result { |
| 361 | margin: auto; | |
| 8d7ec546 | 362 | max-width: 350px; |
| 22f19b23 TC |
363 | min-height: 50px; |
| 364 | line-height: 50px; | |
| 365 | text-align: center; | |
| 11ef4de5 TC |
366 | margin-bottom: 30px; |
| 367 | border-radius: 3px; | |
| 22f19b23 TC |
368 | } |
| 369 | ||
| 370 | h2, legend { | |
| 371 | font-size: 30px; | |
| 372 | text-transform: uppercase; | |
| 373 | font-family: "PT Sans",sans-serif; | |
| 374 | } | |
| 375 | ||
| 376 | legend:after { | |
| 377 | content: ""; | |
| 378 | height: 4px; | |
| 379 | width: 70px; | |
| 380 | background-color: #000; | |
| 381 | display: block; | |
| 382 | } | |
| 9834d87e TC |
383 | #reloadpage { |
| 384 | cursor: pointer; | |
| 385 | background-color: #000; | |
| 386 | color: #FFF; | |
| 387 | padding: 0.5em 1em; | |
| 388 | display: inline-block; | |
| 389 | border: 1px solid #000; | |
| 390 | } | |
| 391 | #reloadpage:hover { | |
| 392 | background-color: #FFF; | |
| 393 | color: #000; | |
| 394 | } | |
| 11ef4de5 TC |
395 | .final { |
| 396 | margin-top: 10%; | |
| 397 | margin-left: 30%; | |
| 398 | max-width: 400px; | |
| 399 | text-align: center; | |
| 400 | border-radius: 6px; | |
| 401 | } | |
| 402 | .final h1 { | |
| 403 | line-height: 50px; | |
| 404 | } | |
| 405 | ||
| 406 | .final em { | |
| 407 | margin-top: 40px; | |
| 408 | font-size: 12px; | |
| 409 | } | |
| 444f1406 TC |
410 | |
| 411 | </style> | |
| 412 | ||
| 792097fb NL |
413 | </head> |
| 414 | <body> | |
| 415 | <header class="w600p center mbm"> | |
| 416 | <h1 class="logo"> | |
| 417 | <img width="100" height="100" src="themes/baggy/img/logo-w.png" alt="logo poche" /> | |
| 418 | </h1> | |
| 419 | </header> | |
| 420 | <div id="main"> | |
| 421 | <button id="menu" class="icon icon-menu desktopHide"><span>Menu</span></button> | |
| 422 | <ul id="links" class="links"> | |
| 976d6935 TC |
423 | <li><a href="docs/" target="_blank">Offline Doc</a></li> |
| 424 | <li><a href="http://doc.wallabag.org/" target="_blank">Online doc</a></li> | |
| 425 | <li><a href="http://support.wallabag.org/" target="_blank">help</a></li> | |
| 426 | <li><a href="http://www.wallabag.org/" target="_blank">wallabag.org</a></li> | |
| 11ef4de5 TC |
427 | </ul> |
| 428 | <?php if (!$final) : ?> | |
| 792097fb | 429 | <?php if (!empty($errors)) : ?> |
| d09a5674 | 430 | <div class='messages error install'> |
| 792097fb NL |
431 | <p>Errors during installation:</p> |
| 432 | <p> | |
| 433 | <ul> | |
| 434 | <?php foreach($errors as $error) :?> | |
| 435 | <li><?php echo $error; ?></li> | |
| 436 | <?php endforeach; ?> | |
| 437 | </ul> | |
| 438 | </p> | |
| 439 | <p><a href="index.php">Please reload</a> this page when you think you resolved these problems.</p> | |
| 440 | </div> | |
| 441 | <?php endif; ?> | |
| 442 | <?php if (!empty($successes)) : ?> | |
| d09a5674 | 443 | <div class='messages success install'> |
| 792097fb NL |
444 | <p> |
| 445 | <ul> | |
| 446 | <?php foreach($successes as $success) :?> | |
| 447 | <li><?php echo $success; ?></li> | |
| 448 | <?php endforeach; ?> | |
| 449 | </ul> | |
| 450 | </p> | |
| 451 | </div> | |
| d09a5674 NL |
452 | <?php else : ?> |
| 453 | <?php if (file_exists('inc/poche/config.inc.php') && is_dir('vendor')) : ?> | |
| 454 | <div class='messages success install'> | |
| 455 | <p> | |
| 8df90295 | 456 | <a href="index.php?clean=0">Click here to finish update.</a><br> |
| 467503fb | 457 | If it fails, check your file permissions or just delete the install directory. |
| d09a5674 | 458 | </p> |
| 8df90295 | 459 | <p>You may have to clear cache (by going into config screen) after update.</p> |
| d09a5674 NL |
460 | </div> |
| 461 | <?php endif; ?> | |
| 792097fb NL |
462 | <?php endif; ?> |
| 463 | <p>To install wallabag, you just have to fill the following fields. That's all.</p> | |
| 976d6935 | 464 | |
| 22f19b23 TC |
465 | <div> |
| 466 | <h2>Server compatibility test</h2> | |
| 467 | <?php if (isOkay()) { ?> | |
| 468 | <div class="compatibity_result detail good">All good</div> | |
| 469 | <?php } elseif (isPassing()) { ?> | |
| 8d7ec546 | 470 | <div class="compatibity_result detail pass">Some warnings, but the minimum is here !</div> |
| 22f19b23 TC |
471 | <?php } else { ?> |
| 472 | <div class="compatibity_result detail bad">Bad news : you can't run wallabag</div> | |
| 8d7ec546 | 473 | <?php } $status = status(); $pdo_drivers = pdoDrivers(); ?> |
| 22f19b23 | 474 | </div> |
| 444f1406 TC |
475 | |
| 476 | <div class="details"> | |
| 477 | <div> | |
| c1e90b9e | 478 | <hr> |
| 444f1406 TC |
479 | <h2 style="text-align:center;"><?php echo $status['app_name']; ?>: Compatibility Test</h2> |
| 480 | <table cellpadding="0" cellspacing="0" border="0" width="100%" id="chart"> | |
| 481 | <thead> | |
| 482 | <tr> | |
| 483 | <th>Test</th> | |
| 484 | <th>Should Be</th> | |
| 485 | <th>What You Have</th> | |
| 486 | <th>What it means</th> | |
| 487 | </tr> | |
| 488 | </thead> | |
| 489 | <tbody> | |
| 490 | <tr class="<?php echo ($status['php']) ? 'enabled' : 'disabled'; ?>"> | |
| 491 | <td>PHP</td> | |
| 492 | <td>5.3.3 or higher</td> | |
| 493 | <td class="<?php echo ($status['php']) ? 'good' : 'disabled'; ?>"><?php echo phpversion(); ?></td> | |
| 494 | <td><?php echo ($status['php']) ? '<strong>PHP:</strong> You are running a supported version of PHP.' : '<strong>PHP:</strong> You are running an unsupported version of PHP. <strong>' . $status['app_name'] . ' will not work here.</strong>' ;?></td> | |
| 495 | </tr> | |
| 496 | <tr class="<?php echo ($status['pdo']) ? 'enabled' : 'disabled'; ?>"> | |
| 497 | <td><a href="http://php.net/manual/en/book.pdo.php">PDO</a></td> | |
| 498 | <td>Enabled</td> | |
| 499 | <?php echo ($status['pdo']) ? '<td class="good">Enabled</span>' : '<td class="bad">Disabled'; ?></td> | |
| 500 | <td><?php echo ($status['pdo']) ? '<strong>PDO:</strong> You have PDO support enabled.' : '<strong>PDO:</strong> Your PHP installation doesn\'t support PHP PDO. <strong>' . $status['app_name'] . ' will not work here.</strong>' ?></td> | |
| 501 | </tr> | |
| 22f19b23 TC |
502 | <tr class="<?php echo ($status['pdo_drivers_passing']) ? 'enabled' : 'disabled'; ?>"> |
| 503 | <td>PDO Drivers</td> | |
| 504 | <td>One of the PDO drivers must be installed</td> | |
| 976d6935 | 505 | <?php echo ($status['pdo_drivers_passing']) ? '<td class="good">At least one driver is enabled</span>' : '<td class="bad">No driver available'; ?></td> |
| 22f19b23 TC |
506 | <td><?php echo ($status['pdo_drivers_passing']) ? '<strong>PDO:</strong> You have at least one PDO driver installed.' : '<strong>PDO Drivers:</strong> Your PHP installation doesn\'t have any PDO driver installed. <strong>' . $status['app_name'] . ' will not work here.</strong>' ?></td> |
| 507 | </tr> | |
| 444f1406 TC |
508 | <tr class="<?php echo ($status['xml']) ? 'enabled' : 'disabled'; ?>"> |
| 509 | <td><a href="http://php.net/xml">XML</a></td> | |
| 510 | <td>Enabled</td> | |
| 511 | <?php echo ($status['xml']) ? '<td class="good">Enabled, and sane</span>' : '<td class="bad">Disabled, or broken'; ?></td> | |
| 512 | <td><?php echo ($status['xml']) ? '<strong>XML:</strong> You have XMLReader support or a version of XML support that isn\'t broken installed.' : '<strong>XML:</strong> Your PHP installation doesn\'t support XML parsing. <strong>' . $status['app_name'] . ' will not work here.</strong>' ?></td> | |
| 513 | </tr> | |
| 514 | <tr class="<?php echo ($status['pcre']) ? 'enabled' : 'disabled'; ?>"> | |
| 515 | <td><a href="http://php.net/pcre">PCRE</a></td> | |
| 516 | <td>Enabled</td> | |
| 517 | <?php echo ($status['pcre']) ? '<td class="good">Enabled' : '<td class="bad">Disabled'; ?></td> | |
| 518 | <td><?php echo ($status['pcre']) ? '<strong>PCRE:</strong> You have PCRE support installed.' : '<strong>PCRE:</strong> Your PHP installation doesn\'t support Perl-Compatible Regular Expressions. <strong>' . $status['app_name'] .' will not work here.</strong>' ?></td> | |
| 519 | </tr> | |
| 520 | <tr class="<?php echo ($status['zlib']) ? 'enabled' : 'disabled'; ?>"> | |
| 521 | <td><a href="http://php.net/zlib">Zlib</a></td> | |
| 522 | <td>Enabled</td> | |
| 523 | <?php echo ($status['zlib']) ? '<td class="good">Enabled' : '<td class="bad">Disabled'; ?></td> | |
| 524 | <td><?php echo ($status['zlib']) ? '<strong>Zlib:</strong> You have <code>Zlib</code> enabled. This allows SimplePie to support GZIP-encoded pages.' : '<strong>Zlib:</strong> The <code>Zlib</code> extension is not available. SimplePie will ignore any GZIP-encoding, and instead handle pages as uncompressed text.' ?></td> | |
| 525 | </tr> | |
| 526 | <tr class="<?php echo ($status['mbstring']) ? 'enabled' : 'disabled'; ?>"> | |
| 527 | <td><a href="http://php.net/mbstring">mbstring</a></td> | |
| 528 | <td>Enabled</td> | |
| 529 | <?php echo ($status['mbstring']) ? '<td class="good">Enabled' : '<td class="bad">Disabled'; ?></td> | |
| 530 | <td rowspan="2"><?php if(($status['mbstring']) && ($status['iconv'])) { ?><strong>mbstring and iconv:</strong> You have both <code>mbstring</code> and <code>iconv</code> installed! This will allow <?php echo $status['app_name']; ?> to handle the greatest number of languages. | |
| 531 | <?php } elseif ($status['mbstring']) { ?><strong>mbstring:</strong> <code>mbstring</code> is installed, but <code>iconv</code> is not. | |
| 532 | <?php } elseif ($status['iconv']) { ?><strong>iconv:</strong> <code>iconv</code> is installed, but <code>mbstring</code> is not. | |
| 533 | <?php } else { ?><strong>mbstring and iconv:</strong> <em>You do not have either of the extensions installed.</em> This will significantly impair your ability to read non-English pages, as well as even some English ones. | |
| 534 | <?php } ?> | |
| 535 | </td> | |
| 536 | </tr> | |
| 537 | <tr class="<?php echo ($status['iconv']) ? 'enabled' : 'disabled'; ?>"> | |
| 538 | <td><a href="http://php.net/iconv">iconv</a></td> | |
| 539 | <td>Enabled</td> | |
| 540 | <?php echo ($status['iconv']) ? '<td class="good">Enabled' : '<td class="bad">Disabled'; ?></td> | |
| 541 | </tr> | |
| 542 | <tr class="<?php echo ($status['dom']) ? 'enabled' : 'disabled'; ?>"> | |
| 543 | <td><a href="http://php.net/manual/en/book.dom.php">DOM / XML extension</a></td> | |
| 544 | <td>Enabled</td> | |
| 545 | <?php echo ($status['dom']) ? '<td class="good">Enabled' : '<td class="bad">Disabled'; ?></td> | |
| 546 | <td><?php echo ($status['dom']) ? '<strong>DOM/XML:</strong> You can parse <em>ini</em> files.' : '<strong>DOM/XML:</strong> Your PHP configuration isn\'t standard, you\'re missing PHP-DOM. You may try to install a package or recompile PHP. <strong>' . $status['app_name'] . ' will not work here.</strong>'; ?></td> | |
| 547 | </tr> | |
| 548 | <tr class="<?php echo ($status['filter']) ? 'enabled' : 'disabled'; ?>"> | |
| 549 | <td><a href="http://uk.php.net/manual/en/book.filter.php">Data filtering</a></td> | |
| 550 | <td>Enabled</td> | |
| 551 | <?php echo ($status['filter']) ? '<td class="good">Enabled' : '<td class="pass">Disabled'; ?></td> | |
| 552 | <td><?php echo ($status['filter']) ? '<strong>Data filtering:</strong> You can use the PHP build-in DOM to operate on XML documents.' : '<strong>Data filtering:</strong> Your PHP configuration has the filter extension disabled. <strong>' . $status['app_name'] . ' will not work here.</strong>' ?></td> | |
| 553 | </tr> | |
| 554 | <tr class="<?php echo ($status['gd']) ? 'enabled' : 'disabled'; ?>"> | |
| 555 | <td><a href="http://php.net/manual/en/book.image.php">GD</a></td> | |
| 556 | <td>Enabled</td> | |
| 557 | <?php echo ($status['gd']) ? '<td class="good">Enabled' : '<td class="pass">Disabled'; ?></td> | |
| 558 | <td><?php echo($status['gd']) ? '<strong>GD:</strong> You have <code>GD</code> support installed.' : '<strong>GD:</strong> The <code>GD</code> extension is not available. ' . $status['app_name'] . ' will not be able to download pictures locally on your server.' ?></td> | |
| 559 | </tr> | |
| 560 | <tr class="<?php echo ($status['tidy']) ? 'enabled' : 'disabled'; ?>"> | |
| 561 | <td><a href="http://php.net/tidy">Tidy</a></td> | |
| 562 | <td>Enabled</td> | |
| 563 | <?php echo ($status['tidy']) ? '<td class="good">Enabled' : '<td class="pass">Disabled'; ?></td> | |
| 564 | <td><?php echo ($status['tidy']) ? '<strong>Tidy:</strong> You have <code>Tidy</code> support installed.' : '<strong>Tidy:</strong> The <code>Tidy</code> extension is not available.' . $status['app_name'] . ' should still work with most pages, but you may experience problems with some. You can install it with <code>sudo apt-get install php5-tidy</code> and then reload Apache <code>sudo service apache2 reload</code>.' ; ?></td> | |
| 565 | </tr> | |
| 566 | <tr class="<?php echo ($status['curl']) ? 'enabled' : 'disabled'; ?>"> | |
| 567 | <td><a href="http://php.net/curl">cURL</a></td> | |
| 568 | <td>Enabled</td> | |
| 569 | <?php echo (extension_loaded('curl')) ? '<td class="good">Enabled' : '<td class="pass">Disabled'; ?></td> | |
| 570 | <td><?php echo ($status['curl']) ? '<strong>cURL:</strong> You have <code>cURL</code> support installed.' : '<strong>cURL:</strong> The <code>cURL</code> extension is not available. SimplePie will use <code>fsockopen()</code> instead.' ?></td> | |
| 571 | </tr> | |
| 572 | <tr class="<?php echo ($status['parse_ini']) ? 'enabled' : 'disabled'; ?>"> | |
| 573 | <td><a href="http://uk.php.net/manual/en/function.parse-ini-file.php">Parse ini file</td> | |
| 574 | <td>Enabled</td> | |
| 575 | <?php echo ($status['parse_ini']) ? '<td class="good">Enabled' : '<td class="bad">Disabled'; ?></td> | |
| 576 | <td><?php echo ($status['parse_ini']) ? '<strong>Parse ini:</strong> You can parse <em>ini</em> files.' : '<strong>Parse ini files function :</strong> Bad luck : your webhost has decided to block the use of the <em>parse_ini_file</em> function. <strong>' . $status['app_name'] . ' will not work here.' ?></td> | |
| 577 | </tr> | |
| 578 | <tr class="<?php echo ($status['parallel']) ? 'enabled' : 'disabled'; ?>"> | |
| 579 | <td>Parallel URL fetching</td> | |
| 580 | <td>Enabled</td> | |
| 581 | <?php echo ($status['parallel']) ? '<td class="good">Enabled' : '<td class="pass">Disabled'; ?></td> | |
| 582 | <td><?php echo ($status['parallel']) ? '<strong>Parallel URL fetching:</strong> You have <code>HttpRequestPool</code> or <code>curl_multi</code> support installed.' : '<strong>Parallel URL fetching:</strong> <code>HttpRequestPool</code> or <code>curl_multi</code> support is not available. ' . $status['app_name'] . ' will use <code>file_get_contents()</code> instead to fetch URLs sequentially rather than in parallel.' ?></td> | |
| 583 | </tr> | |
| 584 | <tr class="<?php echo ($status['allow_url_fopen']) ? 'enabled' : 'disabled'; ?>"> | |
| 585 | <td><a href="http://www.php.net/manual/en/filesystem.configuration.php#ini.allow-url-fopen">allow_url_fopen</a></td> | |
| 586 | <td>Enabled</td> | |
| af13787e TC |
587 | <?php if ($status['allow_url_fopen']) { ?> |
| 588 | <td class="good">Enabled</td> | |
| 589 | <td><strong>allow_url_fopen:</strong> You have allow_url_fopen enabled. | |
| 590 | <?php } elseif ($status['curl']) { ?> | |
| 591 | <td class="pass">Disabled</td> | |
| 592 | <td><strong>allow_url_fopen</strong> is disabled, but curl is supported, so it should be ok.</td> | |
| 593 | <?php } else { ?> | |
| 594 | <td class="bad">Disabled</td> | |
| 595 | <td><strong>allow_url_fopen:</strong> Your PHP configuration has allow_url_fopen disabled. | |
| 596 | <strong><?php echo $status['app_name']; ?> will not work here.</strong><?php } ?></td> | |
| 444f1406 TC |
597 | </tr> |
| 598 | <tr class="<?php echo ($status['gettext']) ? 'enabled' : 'disabled'; ?>"> | |
| 599 | <td><a href="http://php.net/manual/en/book.gettext.php">gettext</a></td> | |
| 600 | <td>Enabled</td> | |
| 601 | <?php echo ($status['gettext']) ? '<td class="good">Enabled' : '<td class="bad">Disabled'; ?></td> | |
| 602 | <td><?php echo ($status['gettext']) ? '<strong>Gettext:</strong> You have <code>gettext</code> enabled.</em>' : '<strong>GetText:</strong> The <code>gettext</code> extension is not available. The system we use to display wallabag in various languages is not available. <strong>' . $status['app_name'] .' will not work here.</strong>' ?></td> | |
| 603 | </tr> | |
| 604 | </tbody> | |
| 605 | </table> | |
| 22f19b23 | 606 | <hr> |
| 444f1406 | 607 | </div> |
| 444f1406 TC |
608 | <div class="details"> |
| 609 | <?php //if ($status['php'] && $status['xml'] && $status['pcre'] && $status['mbstring'] && $status['iconv'] && $status['filter'] && $status['allow_url_fopen']) { ?> | |
| 610 | <?php if (isOkay()) { ?> | |
| 611 | <h3>Bottom Line: Yes, you can run <?php echo $status['app_name']; ?> !</h3> | |
| 612 | <p><em>Your webhost has its act together!</em></p> | |
| 613 | <p><strong>Note</strong>: Passing this test does not guarantee that <?php echo $status['app_name']; ?> will run on your webhost — it only ensures that the basic requirements have been addressed. If you experience any problems, please let us know.</p> | |
| 614 | <?php //} else if ($status['php'] && $status['xml'] && $status['pcre'] && $status['mbstring'] && $status['allow_url_fopen'] && $status['filter']) { ?> | |
| 615 | <?php } else if (!isOkay() && isPassing()) { ?> | |
| 616 | <h3>Bottom Line: Yes, you can run <?php echo $status['app_name']; ?> !</h3> | |
| 617 | <p><em>For most pages, it'll run with no problems.</em> There are certain languages that you might have a hard time with though.</p> | |
| 618 | <p><strong>Note</strong>: Passing this test does not guarantee that <?php echo $status['app_name']; ?> will run on your webhost — it only ensures that the basic requirements have been addressed. If you experience any problems, please let us know.</p> | |
| 619 | <?php } else { ?> | |
| 620 | <h3>Bottom Line: We're sorry…</h3> | |
| 621 | <p><em>Your webhost does not support the minimum requirements for <?php echo $status['app_name']; ?>.</em> It may be a good idea to contact your webhost and point them to the results of this test. They may be able to enable/install the required components.</p> | |
| 9834d87e | 622 | <p>If this is your own server and you think you have all the requirements installed, please get in touch with us.</p> |
| 444f1406 TC |
623 | <?php } ?> |
| 624 | </div> | |
| 625 | ||
| 22f19b23 TC |
626 | <div class="chunk"> |
| 627 | <p class="footnote">This compatibility test has been borrowed (and slightly adapted by <a href="http://fivefilters.org/content-only/">fivefilters.org</a>) from the one supplied by <a href="http://simplepie.org/">SimplePie.org</a>.</a></p> | |
| 628 | </div> | |
| 444f1406 | 629 | </div> |
| 444f1406 | 630 | <form method="post" class="technical"> |
| 9834d87e TC |
631 | <hr> |
| 632 | <div class='twig'> | |
| 633 | <h2>Twig installation</h2> | |
| ca056e7f | 634 | <?php if (!is_dir('vendor')) : ?> |
| 9834d87e TC |
635 | |
| 636 | <p>wallabag needs twig, a template engine (<a href="http://twig.sensiolabs.org/">?</a>). Two ways to install it:</p> | |
| ca056e7f TC |
637 | <ul> |
| 638 | <li>automatically download and extract vendor.zip into your wallabag folder. | |
| 639 | <p><input type="submit" name="download" value="Download vendor.zip" /></p> | |
| 640 | <?php if (!extension_loaded('zip')) : ?> | |
| 641 | <b>Be careful, zip extension is not enabled in your PHP configuration. You'll have to unzip vendor.zip manually.</b> | |
| 642 | <?php endif; ?> | |
| 643 | <em>This method is mainly recommended if you don't have a dedicated server.</em></li> | |
| 22f19b23 | 644 | <li>use <a href="http://getcomposer.org/">Composer</a> in your wallabag folder :<pre><code>curl -s http://getcomposer.org/installer | php |
| 9834d87e TC |
645 | php composer.phar install</code></pre> |
| 646 | <span id="reloadpage">Reload to check</span> | |
| 647 | </li> | |
| ca056e7f | 648 | </ul> |
| 9834d87e TC |
649 | |
| 650 | <?php else : ?> | |
| 651 | Twig is properly installed. | |
| ca056e7f | 652 | <?php endif; ?> |
| 9834d87e | 653 | </div> |
| dd0d7ad9 | 654 | <div class="database_info"> |
| 9834d87e | 655 | <hr> |
| dd0d7ad9 | 656 | <fieldset class="database_inputs"> |
| 22f19b23 | 657 | <legend><strong>Database settings</strong></legend> |
| 792097fb NL |
658 | <p> |
| 659 | Database engine: | |
| 660 | <ul> | |
| 8d7ec546 TC |
661 | <li> |
| 662 | <?php if ($pdo_drivers['sqlite']) { ?> | |
| 663 | <label for="sqlite">SQLite</label> <input name="db_engine" type="radio" checked="" id="sqlite" value="sqlite" /> | |
| 664 | <?php } else { ?> | |
| 665 | <div class="messages notice"> | |
| 666 | <p>You have to enable <a href="http://php.net/manual/ref.pdo-sqlite.php">pdo_sqlite extension</a> to use SQLite.</p> | |
| 667 | </div> | |
| 668 | <?php } ?> | |
| 669 | </li> | |
| 670 | <li> | |
| 671 | <?php if ($pdo_drivers['mysql']) { ?> | |
| 672 | <label for="mysql">MySQL</label> <input name="db_engine" type="radio" id="mysql" value="mysql" /> | |
| 673 | <div id="pdo_mysql" class='messages notice install'> | |
| 674 | <p>All fields have to be filled.</p> | |
| 675 | </div> | |
| 676 | <ul id="mysql_infos"> | |
| 7f8f8271 TC |
677 | <li><label for="mysql_server">Server</label> <input type="text" placeholder="eg : localhost" id="mysql_server" name="mysql_server" /></li> |
| 678 | <li><label for="mysql_database">Existing database</label> <input type="text" placeholder="eg : wallabag" id="mysql_database" name="mysql_database" /></li> | |
| 8d7ec546 TC |
679 | <li><label for="mysql_user">User</label> <input type="text" placeholder="user" id="mysql_user" name="mysql_user" /></li> |
| 680 | <li><label for="mysql_password">Password</label> <input type="password" placeholder="p4ssw0rd" id="mysql_password" name="mysql_password" /></li> | |
| 681 | <li><label for="mysql_utf8_mb4">Use UTF-8 MB4</label> <input id="mysql_utf8_mb4" type="checkbox" name="mysql_utf8_mb4"> | |
| 682 | <div id="utf8_mb4_infos"><em>Warning :</em> UTF-8 MB4 is used to fully support unicode characters. It is available only with MySQL starting with version 5.5.3. | |
| 976d6935 | 683 | Install will failed if you check this while using an older MySQL server.</div></li> |
| 8d7ec546 TC |
684 | </ul> |
| 685 | <?php } else { ?> | |
| 686 | <div class="messages notice"> | |
| 687 | <p>You have to enable <a href="http://php.net/manual/ref.pdo-mysql.php">pdo_mysql extension</a> to use MySQL.</p> | |
| 688 | </div> | |
| 689 | <?php } ?> | |
| 690 | </li> | |
| 691 | <li> | |
| 692 | <?php if ($pdo_drivers['postgres']) { ?> | |
| 693 | <label for="postgres">PostgreSQL</label> <input name="db_engine" type="radio" id="postgres" value="postgres" /> | |
| 694 | <div id="pdo_postgres" class='messages notice install'> | |
| 369e00e6 | 695 | <p>All fields have to be filled.</p> |
| 8d7ec546 TC |
696 | </div> |
| 697 | <ul id="pg_infos"> | |
| 7f8f8271 TC |
698 | <li><label for="pg_server">Server</label> <input type="text" placeholder="eg : localhost" id="pg_server" name="pg_server" /></li> |
| 699 | <li><label for="pg_database">Existing database</label> <input type="text" placeholder="eg : wallabag" id="pg_database" name="pg_database" /></li> | |
| 792097fb | 700 | <li><label for="pg_user">User</label> <input type="text" placeholder="user" id="pg_user" name="pg_user" /></li> |
| fcd37d0c | 701 | <li><label for="pg_password">Password</label> <input type="password" placeholder="p4ssw0rd" id="pg_password" name="pg_password" /></li> |
| 8d7ec546 TC |
702 | </ul> |
| 703 | <?php } else { ?> | |
| 704 | <div class="messages notice"> | |
| 705 | <p>You have to enable <a href="https://php.net/manual/ref.pdo-pgsql.php">pdo_pgsql extension</a> to use PostgreSQL.</p> | |
| 706 | </div> | |
| 707 | <?php } ?> | |
| 708 | </li> | |
| 792097fb NL |
709 | </ul> |
| 710 | </p> | |
| 711 | </fieldset> | |
| dd0d7ad9 TC |
712 | <div class="descriptions"> |
| 713 | <div id="sqlite_description"> | |
| 714 | SQLite is the most simple database system of all three. It is therefore recommended for people who don't want or know how to configure other database systems. | |
| 715 | </div> | |
| 716 | <div id="mysql_description"> | |
| 976d6935 | 717 | MySQL (also called MariaDB) is one of the most popular database systems. It comes with most shared hosting plans. |
| dd0d7ad9 TC |
718 | </div> |
| 719 | <div id="postgres_description"> | |
| 976d6935 | 720 | PostgreSQL. Because some people prefer it to MySQL. With reasons. |
| dd0d7ad9 TC |
721 | </div> |
| 722 | </div> | |
| 723 | </div> | |
| c1e90b9e | 724 | <hr> |
| 9834d87e | 725 | <div class="usersettings"> |
| dd0d7ad9 | 726 | <fieldset style="clear: both"> |
| 792097fb NL |
727 | <legend><strong>User settings</strong></legend> |
| 728 | <p> | |
| 729 | <label for="username">Username</label> | |
| 730 | <input type="text" required id="username" name="username" value="wallabag" /> | |
| 731 | </p> | |
| 732 | <p> | |
| 733 | <label for="password">Password</label> | |
| 734 | <input type="password" required id="password" name="password" value="wallabag" /> | |
| 046b9316 | 735 | <label for="show">Show password:</label> <input style="margin-left:-80px;" name="show" id="show" type="checkbox" onchange="document.getElementById('password').type = this.checked ? 'text' : 'password'"> |
| 792097fb NL |
736 | </p> |
| 737 | <p> | |
| 046b9316 | 738 | <label for="email">Email (not required)</label> |
| 739 | <input type="email" id="email" name="email" /> | |
| 792097fb NL |
740 | </p> |
| 741 | </fieldset> | |
| 1be13ba1 | 742 | <input type="submit" id="install_button" value="Install wallabag" name="install" /> |
| 9834d87e | 743 | </div> |
| 792097fb NL |
744 | </form> |
| 745 | </div> | |
| 11ef4de5 TC |
746 | <?php else : ?> |
| 747 | <div class="final good"> | |
| 748 | <h1>wallabag is now installed ! :-) </h1> | |
| 749 | <a href="index.php?clean=0">Click here to access the login form</a><br /> | |
| 750 | <em>The installation will now try to delete the install directory. If this fails, delete it manually.</em></div> | |
| 751 | <?php endif; ?> | |
| 792097fb | 752 | <script> |
| 9834d87e TC |
753 | <?php if (!is_dir('vendor')) : ?> |
| 754 | $(".database_info").hide(); | |
| 755 | $(".usersettings").hide(); | |
| 756 | <?php endif ?> | |
| 8df90295 | 757 | |
| 9834d87e TC |
758 | /* |
| 759 | * Database showing/hiding | |
| 760 | */ | |
| 792097fb | 761 | $("#mysql_infos").hide(); |
| dd0d7ad9 | 762 | $("#mysql_description").hide(); |
| 792097fb | 763 | $("#pg_infos").hide(); |
| dd0d7ad9 TC |
764 | $("#postgres_description").hide(); |
| 765 | $("#sqlite_description").show(); | |
| 369e00e6 TC |
766 | $("#pdo_postgres").hide(); |
| 767 | $("#pdo_mysql").hide(); | |
| 768 | ||
| 9834d87e TC |
769 | /* |
| 770 | * Details hiding | |
| 771 | */ | |
| 772 | ||
| 773 | $(".details").hide(); | |
| 976d6935 | 774 | $("#utf8_mb4_infos").hide(); |
| 9834d87e | 775 | |
| 444f1406 TC |
776 | <?php |
| 777 | if (!isPassing()) : ?> | |
| 778 | $('.technical').hide(); | |
| 779 | <?php | |
| 780 | else : | |
| 781 | ?> | |
| 782 | $('.technical').show(); | |
| 783 | <?php | |
| 784 | endif; | |
| 785 | ?> | |
| 786 | ||
| 8df90295 TC |
787 | <?php if (file_exists('inc/poche/config.inc.php') && is_dir('vendor')) : ?> |
| 788 | $('.technical').hide(); | |
| 789 | <?php endif ?> | |
| 790 | ||
| 976d6935 TC |
791 | $("#mysql_utf8_mb4").click(function() { |
| 792 | $("#utf8_mb4_infos").toggle(); | |
| 793 | }); | |
| 794 | ||
| 792097fb NL |
795 | $("input[name=db_engine]").click(function() |
| 796 | { | |
| 797 | if ( $("#mysql").prop('checked')) { | |
| 798 | $("#mysql_infos").show(); | |
| 369e00e6 | 799 | $("#pdo_mysql").show(); |
| 792097fb | 800 | $("#pg_infos").hide(); |
| 369e00e6 | 801 | $("#pdo_postgres").hide(); |
| 1be13ba1 | 802 | $("#pdo_sqlite").hide(); |
| dd0d7ad9 TC |
803 | $("#sqlite_description").hide(); |
| 804 | $("#postgres_description").hide(); | |
| 805 | $("#mysql_description").show(); | |
| c1e90b9e | 806 | $("#install_button").show(); |
| 792097fb NL |
807 | } |
| 808 | else { | |
| feecea28 | 809 | if ( $("#postgres").prop('checked')) { |
| 792097fb | 810 | $("#mysql_infos").hide(); |
| 369e00e6 | 811 | $("#pdo_mysql").hide(); |
| 792097fb | 812 | $("#pg_infos").show(); |
| 369e00e6 | 813 | $("#pdo_postgres").show(); |
| 1be13ba1 | 814 | $("#pdo_sqlite").hide(); |
| dd0d7ad9 TC |
815 | $("#sqlite_description").hide(); |
| 816 | $("#mysql_description").hide(); | |
| 817 | $("#postgres_description").show(); | |
| 1be13ba1 | 818 | $("#install_button").show(); |
| 792097fb NL |
819 | } |
| 820 | else { | |
| 821 | $("#mysql_infos").hide(); | |
| 822 | $("#pg_infos").hide(); | |
| 369e00e6 TC |
823 | $("#pdo_postgres").hide(); |
| 824 | $("#pdo_mysql").hide(); | |
| dd0d7ad9 TC |
825 | $("#sqlite_description").show(); |
| 826 | $("#mysql_description").hide(); | |
| 827 | $("#postgres_description").hide(); | |
| 792097fb NL |
828 | } |
| 829 | } | |
| 830 | }); | |
| 444f1406 TC |
831 | |
| 832 | $(".detail").click(function() | |
| 833 | { | |
| 834 | $('.details').toggle(); | |
| 835 | }); | |
| 9834d87e TC |
836 | $("#reloadpage").click(function() |
| 837 | { | |
| 838 | location.reload(); | |
| 839 | }); | |
| c1e90b9e | 840 | |
| 792097fb NL |
841 | </script> |
| 842 | </body> | |
| a50d7f0f | 843 | </html> |