X-Git-Url: https://disinclined.org/git/?a=blobdiff_plain;ds=sidebyside;f=index.php;h=bf2249bfd14920d5550c47184bd62ba7bcd57499;hb=60e2ac52bbf649d4b04f91bc731672a94c4373a8;hp=58b10f6e923c68411d8203956ae7a28cf94c1c2a;hpb=fd9475498aaef1e21324c9acea39463fa53fcbbe;p=dylansserver.git
diff --git a/index.php b/index.php
index 58b10f6..bf2249b 100644
--- a/index.php
+++ b/index.php
@@ -172,6 +172,13 @@ class index extends cms {
";
- $sql = "SELECT text FROM projects";
+ $sql = "SELECT text FROM projects ORDER BY rank";
$result = $this->db->query($sql);
while ($entry = $result->fetch_object()) {
echo $entry->text;
@@ -201,7 +208,7 @@ OTHER_PROJECTS;
my projects:
HEREDOC;
- $sql = "SELECT title FROM projects";
+ $sql = "SELECT title FROM projects ORDER BY rank";
$result = $this->db->query($sql);
while ($entry = $result->fetch_object()) {
echo "
$entry->title";
@@ -435,8 +442,8 @@ class note extends cms {
// and a default author needs to be set
// for no-javascript users.
$stmt->bind_param('sss',
- htmlspecialchars($_POST['name']),
- htmlspecialchars($_POST['text']),
+ $_POST['name'],
+ $_POST['text'],
$this->id);
$stmt->execute();
}
@@ -491,7 +498,7 @@ END_OF_NAVIGATION;
$date_posted = $entry['date_posted'];
$author = $entry['author'];
$text = htmlspecialchars($entry['text']);
- $head = "
$author
";
+ $head = "
" . htmlspecialchars($author) . "
";
echo <<