Rewrote Pillowcase

NOTE: There is a new database schema now, so the database from the testing server has to be copied over to the production server, otherwise this code
will fail.

1 files changed, 35 insertions, 0 deletions

@@ -0,0 +1,35 @@
+<?php
+
+function has_meta($id, $name)
+{
+        $getmeta = "SELECT * FROM meta WHERE comic_id = " . $id . " AND name = \"" . $name . "\"";
+        $getmeta2 = mysql_query($getmeta);
+        $getmeta3 = mysql_fetch_array($getmeta2);
+
+        if ($getmeta3['name'] == $name)
+        {
+                return true;
+        }
+
+        return false;
+}
+
+function get_meta($id, $name)
+{
+        $getmeta = "SELECT * FROM meta WHERE comic_id = " . $id . " AND name = \"" . $name . "\"";
+        $getmeta2 = mysql_query($getmeta);
+        $getmeta3 = mysql_fetch_array($getmeta2);
+
+        return $getmeta3['value'];      
+}
+
+function next_comic_id()
+{
+        $getcomic = "SELECT * FROM comics WHERE status = \"publish\" ORDER BY comic_id DESC LIMIT 0,1";
+        $getcomic2 = mysql_query($getcomic);
+        $getcomic3 = mysql_fetch_array($getcomic2);
+
+        return ($getcomic3['comic_id']+1);
+}
+
+?>