diff options
Diffstat (limited to 'class')
| -rw-r--r-- | class/class.w.aff.php | 81 | ||||
| -rw-r--r-- | class/class.w.app.php | 24 | ||||
| -rw-r--r-- | class/class.w.config.php | 13 |
3 files changed, 113 insertions, 5 deletions
diff --git a/class/class.w.aff.php b/class/class.w.aff.php index d47ca7a..0c7aa24 100644 --- a/class/class.w.aff.php +++ b/class/class.w.aff.php @@ -207,7 +207,7 @@ public function copy(Art $art, $list) } -public function head($title, $tool) +public function head($title, $tool, $color4) { ?> <head> @@ -216,6 +216,11 @@ public function head($title, $tool) <link rel="shortcut icon" href="../media/logo.png" type="image/x-icon"> <link href="/css/stylebase.css" rel="stylesheet" /> <link href="/css/style<?= $tool ?>.css" rel="stylesheet" /> + <style> + :root { + --color4: <?= $color4 ?>; + } + </style> <title><?= $title ?></title> <script src="../rsc/js/app.js"></script> </head> @@ -240,6 +245,23 @@ public function arthead(Art $art, $cssdir, $cssread = '', $edit = 0) } +public function noarthead($id, $cssdir, $cssread = '') +{ + ?> + <head> + <meta charset="utf8" /> + <meta name="description" content="This article does not exist yet." /> + <meta name="viewport" content="width=device-width" /> + <link rel="shortcut icon" href="../media/logo.png" type="image/x-icon"> + <link href="/css/stylebase.css" rel="stylesheet" /> + <link href="<?= $cssdir . $cssread ?>" rel="stylesheet" /> + <title>❓ <?= $id ?></title> + <script src="../rsc/js/app.js"></script> + </head> + <?php + +} + @@ -755,8 +777,9 @@ public function nav($app) $cssread = file_get_contents($cssfile); echo '<details>'; echo '<summary>Edit current CSS</summary>'; - echo '<form>'; - echo '<textarea id="cssarea">' . $cssread . '</textarea>'; + echo '<form action="./" method="post">'; + echo '<textarea name="editcss" id="cssarea">' . $cssread . '</textarea>'; + echo '<input type="hidden" name="action" value="editcss">'; echo '<input type="submit" value="edit">'; echo '</form>'; echo '</details>'; @@ -910,12 +933,64 @@ public function nav($app) </details> + <details> + <summary>Duplicate Table</summary> + <p>If you want to save versions of your work.</p> + + <form action="./" method="post"> + <label for="arttable">Select the table you want to copy.</label> + <select name="arttable" id="arttable" required> + + <?php + foreach ($arttables as $arttable) { + if ($arttable == $config->arttable()) { + echo '<option value="' . $arttable . '" " selected >' . $arttable . '</option>'; + } else { + echo '<option value="' . $arttable . '">' . $arttable . '</option>'; + } + } + ?> + </select> + <label for="tablename">Choose a name for the copy</label> + <input type="text" name="tablename" id="tablename" required> + <input type="hidden" name="actiondb" value="duplicatetable"> + <input type="submit" value="Duplicate"> + </form> + + </details> + </article> <?php } + public function admindisplay($color4) + { + ?> + <article> + <h2>Display</h2> + <details> + <summary>Update favicon</summary> + <form action="./" method="post" enctype="multipart/form-data"> + <input type="file" name="favicon" id="favicon"> + <input type="submit" value="update"> + </form> + </details> + <details> + <summary>Change desktop background color</summary> + <form action="./" method="post"> + <label for="color4">Background color</label> + <input type="color" name="color4" id="color4" value="<?= $color4 ?>"> + <input type="hidden" name="action" value="editconfig"> + <input type="submit" value="color my life"> + </form> + </details> + </article> + <?php + + } + diff --git a/class/class.w.app.php b/class/class.w.app.php index 29d3fef..82e2bef 100644 --- a/class/class.w.app.php +++ b/class/class.w.app.php @@ -409,11 +409,11 @@ class App `template` varchar(255) DEFAULT NULL )"; - $alter = "ALTER TABLE `'.$tablename.'` + $alter = "ALTER TABLE `$tablename` ADD PRIMARY KEY (`id`)"; $req = $this->bdd->query($table); - $req->closeCursor(); + $req = $this->bdd->query($alter); return 'tablecreated'; } else { @@ -423,6 +423,26 @@ class App + public function tableduplicate($dbname, $arttable, $tablename) + { + $arttable = strip_tags($arttable); + $tablename = str_clean($tablename); + if($this->tableexist($dbname, $arttable) && !$this->tableexist($dbname, $tablename)) { + $duplicate = " CREATE TABLE `$tablename` LIKE `$arttable`;"; + $alter = "ALTER TABLE `$tablename` ADD PRIMARY KEY (`id`);"; + $insert = "INSERT `$tablename` SELECT * FROM `$arttable`;"; + + + $req = $this->bdd->query($duplicate . $alter . $insert); + + return 'tableduplicated'; + } else { + return 'tablealreadyexist'; + } + } + + + // __________________________________________ M E D ________________________________________________________ diff --git a/class/class.w.config.php b/class/class.w.config.php index 839bf77..1d5f7b5 100644 --- a/class/class.w.config.php +++ b/class/class.w.config.php @@ -15,6 +15,7 @@ class Config private $invite; private $read; private $cssread; + private $color4; // _______________________________________ F U N _______________________________________ @@ -99,6 +100,11 @@ class Config return $this->cssread; } + public function color4() + { + return $this->color4; + } + // __________________________________________ S E T ______________________________________ @@ -158,6 +164,13 @@ class Config $this->cssread = strip_tags($cssread); } + public function setcolor4($color4) + { + if(strlen($color4) <= 8) { + $this->color4 = $color4; + } + } + } |