From eee98526c48b9154cd9e9bc8bc3e07769e6a39ea Mon Sep 17 00:00:00 2001
From: Star Rauchenberger <fefferburbia@gmail.com>
Date: Sun, 22 Feb 2009 13:15:37 -0500
Subject: 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.
---
 includes/functions.php | 35 +++++++++++++++++++++++++++++++++++
 1 file changed, 35 insertions(+)
 create mode 100644 includes/functions.php

(limited to 'includes/functions.php')

diff --git a/includes/functions.php b/includes/functions.php
new file mode 100644
index 0000000..edb666b
--- /dev/null
+++ b/includes/functions.php
@@ -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);
+}
+
+?>
-- 
cgit 1.4.1