summaryrefslogtreecommitdiff
path: root/htdocs/src
diff options
context:
space:
mode:
authorJesse Morgan <jesse@jesterpm.net>2011-05-12 16:59:36 -0700
committerJesse Morgan <jesse@jesterpm.net ; true>2011-05-12 16:59:36 -0700
commitdd24e2c973a7979894971bdc38d904d2aecc7d5d (patch)
tree2f8474d22cbf29749219bd6dd543bb22b959465e /htdocs/src
parente159ae5209a561043ceb89aa640b207df15181b7 (diff)
Well, you can see posts on the moderation panel now
Diffstat (limited to 'htdocs/src')
-rw-r--r--htdocs/src/Cif_Database.inc.php196
-rw-r--r--htdocs/src/Cif_Database_Exception.inc.php31
-rw-r--r--htdocs/src/Post.inc.php82
-rw-r--r--htdocs/src/PostIterator.inc.php67
-rw-r--r--htdocs/src/User.inc.php74
-rw-r--r--htdocs/src/base.inc.php45
-rw-r--r--htdocs/src/config.inc.php8
7 files changed, 501 insertions, 2 deletions
diff --git a/htdocs/src/Cif_Database.inc.php b/htdocs/src/Cif_Database.inc.php
new file mode 100644
index 0000000..e78889c
--- /dev/null
+++ b/htdocs/src/Cif_Database.inc.php
@@ -0,0 +1,196 @@
+<?php
+require_once('Cif_Database_Exception.inc.php');
+
+/**
+ * @category Cif
+ * @package Cif_Database
+ *
+ * @author Jesse Morgan <jesse@jesterpm.net>
+ * @copyright Copyright (c) 2009, Jesse Morgan
+ * @version $Id: Cif_Database.inc.php 134 2011-03-08 23:35:57Z jessemorgan $
+ */
+
+/**
+ * Cif_Database is an object providing an
+ * interface to manipulate a MySQL database.
+ *
+ * @package Cif_Database
+ */
+class Cif_Database {
+ /**
+ * Creates a new Cif_Database_Database object and connects to the database.
+ *
+ * @param string $host MySQL Server to connect to.
+ * @param string $user Username to connect with.
+ * @param string $password Password to connect with.
+ * @param string $database Database to select.
+ * @throws Cif_Database_Exception if the database can not be opened.
+ */
+ public function __construct($host, $user, $password, $database) {
+ if (!mysql_connect($host, $user, $password)) {
+ throw new Cif_Database_Exception("Failed to connect to database.");
+ }
+
+ if (!mysql_select_db($database)) {
+ throw new Cif_Database_Exception("Failed to select database.");
+ }
+ }
+
+ /**
+ * Fetch one row from the database with the given query.
+ *
+ * @param string $query The MySQL query.
+ * @return array Array of fields mapped to values.
+ * @throws Cif_Database_Exception if the query fails.
+ */
+ public function fetchAssocRow($query) {
+ $result = mysql_query($query);
+
+ // A query error occured.
+ if (!$result) {
+ throw new Cif_Database_Exception("Query Failed.");
+ }
+
+ return $this->_cleanRow(mysql_fetch_assoc($result));
+ }
+
+ /**
+ * Fetch multiple rows from the database with the given query.
+ *
+ * @param string $query The MySQL query.
+ * @return array Array containing arrays of fields mapped to values for each row.
+ * @throws Cif_Database_Exception if the query fails.
+ */
+ public function fetchAssocRows($query) {
+ $result = mysql_query($query);
+
+ // A query error occured.
+ if (!$result) {
+ throw new Cif_Database_Exception("Query Failed.");
+ }
+
+ $rows = array();
+ while ($row = mysql_fetch_assoc($result)) {
+ $rows[] = $this->_cleanRow($row);
+ }
+
+ return $rows;
+ }
+
+ /**
+ * Update a specified table in the database with the values given.
+ *
+ * @param string $table The table to update.
+ * @param array $values Array of fields mapped to values to update.
+ * @param string $append Optional string to be appended to the MySQL query.
+ * @throws InvalidArgumentException if the table name or values list are empty.
+ * @throws Cif_Database_Exception if the query fails.
+ */
+ public function update($table, $values, $append = "") {
+ // If the table name is empty, or they didn't provide an array of updates,
+ // throw an exception.
+ if ($table == "" or !is_array($values)) {
+ throw new InvalidArgumentException();
+ }
+
+ // Prep the $values for the update.
+ foreach ($values as $field=>$value) {
+ if ($value === NULL) {
+ $updatefields[] = "`$field`=NULL";
+
+ } else {
+ $updatefields[] = "`$field`='$value'";
+ }
+ }
+
+ $result = mysql_query("UPDATE `$table` SET ". implode(",", $updatefields) ." $append");
+
+ if (!$result) {
+ throw new Cif_Database_Exception("Update Failed.");
+ }
+ }
+
+ /**
+ * Insert a collection of rows into the database.
+ *
+ * @param string $table The table to update.
+ * @param array $row Arrays of fields mapped to values for the new row.
+ * @return int Auto-incremented id of the new row.
+ * @throws InvalidArgumentException if the table name or values list are empty.
+ * @throws Cif_Database_Exception if the query fails.
+ */
+ function insert($table, $row) {
+ if (!is_array($row)) {
+ throw new InvalidArgumentException();
+ }
+
+ foreach ($row as $field=>$value) {
+ $fields[] = "`$field`";
+
+ if ($value === NULL) {
+ $values[] = "NULL";
+
+ } else {
+ $values[] = "'$value'";
+ }
+ }
+
+ $result = mysql_query("INSERT INTO `$table` (". implode(', ', $fields) .") VALUES (". implode(", ", $values) .")");
+
+ if ($result) {
+ $id = mysql_insert_id();
+
+ return $id;
+
+ } else {
+ throw new Cif_Database_Exception("Insert Failed.");
+ }
+ }
+
+ /**
+ * Delete rows from the specified table.
+ *
+ * @param string $table The table to delete from.
+ * @param string $where The string to append to the end of the query.
+ * @throws Cif_Database_Exception if the query fails.
+ */
+ function delete($table, $where) {
+ $result = mysql_query("DELETE FROM `$table` WHERE $where");
+
+ if (!$result) {
+ throw new Cif_Database_Exception("Delete Failed.");
+ }
+ }
+
+ /**
+ * Run a query against the database.
+ *
+ * @param string $query The query to run.
+ * @throws Cif_Database_Exception if the query fails.
+ */
+ function raw($command) {
+ $result = mysql_query($command);
+
+ if (!$result) {
+ throw new Cif_Database_Exception("Raw Command.");
+ }
+ }
+
+ /**
+ * Strip the slashes from every field of the given row.
+ *
+ * @param array $row Array of fields mapped to values.
+ * @return array Array of fields mapped to values, without slashes.
+ */
+ private function _cleanRow($row) {
+ if (!$row) return NULL;
+
+ foreach ($row as $key => $value) {
+ $new[$key] = stripslashes($value);
+ }
+ return $new;
+ }
+
+}
+
+?>
diff --git a/htdocs/src/Cif_Database_Exception.inc.php b/htdocs/src/Cif_Database_Exception.inc.php
new file mode 100644
index 0000000..cf70661
--- /dev/null
+++ b/htdocs/src/Cif_Database_Exception.inc.php
@@ -0,0 +1,31 @@
+<?php
+/**
+ * @category Cif
+ * @package Cif_Database
+ *
+ * @author Jesse Morgan <jesse@jesterpm.net>
+ * @copyright Copyright (c) 2009, Jesse Morgan
+ * @version $Id: Cif_Database_Exception.inc.php 134 2011-03-08 23:35:57Z jessemorgan $
+ */
+
+/**
+ * Cif_Database_Exception is a MySQL specific exception.
+ *
+ * @package Cif_Database
+ */
+class Cif_Database_Exception extends Exception {
+ /**
+ * Constructor for the Cif_Database_Exception.
+ * Creates a new Exception with the mysql error messages as the message.
+ *
+ * @param string $message Message to prepend to the Exception message.
+ */
+ public function __construct($message) {
+ parent::__construct($message . " Error: ". mysql_error(), mysql_errno());
+ }
+
+
+
+}
+
+?> \ No newline at end of file
diff --git a/htdocs/src/Post.inc.php b/htdocs/src/Post.inc.php
new file mode 100644
index 0000000..a4d34f7
--- /dev/null
+++ b/htdocs/src/Post.inc.php
@@ -0,0 +1,82 @@
+<?php
+
+/* Foursquare Community Site
+ *
+ * Copyright (C) 2011 Foursquare Church.
+ *
+ * Developers: Jesse Morgan <jmorgan@foursquarestaff.com>
+ *
+ */
+
+require_once "base.inc.php";
+
+class Post {
+ private $info;
+
+
+ public function __construct($info=null) {
+ $this->info = $info;
+ }
+
+ public static function getById($id) {
+ $where = "id='$id'";
+
+ return Post::getPost($where);
+ }
+
+ public static function getBySecretId($secretid) {
+ $where = "secretid='$secretid'";
+
+ return Post::getPost($where);
+ }
+
+ private static function getPost($where) {
+ $query = "SELECT * FROM post WHERE $where";
+
+ $db = getDatabase();
+
+ $row = $db->fetchAssocRow($query);
+
+ if ($row) {
+ $user = new Post();
+ $user->info = $row;
+
+ return $user;
+
+ } else {
+ return false;
+ }
+ }
+
+ public function save() {
+ $db = getDatabase();
+
+ // TODO: Implement Save
+ }
+
+ public function getId() {
+ return $this->info['id'];
+ }
+
+ public function getName() {
+ return $this->info['name'];
+ }
+
+ public function getStage() {
+ return $this->info['stage'];
+ }
+
+ public function approve() {
+ $this->info['stage'] = 'approved';
+ }
+
+ public function verify() {
+ $this->info['stage'] = 'verify';
+ }
+
+ public function getCreated() {
+ return $this->info['created'];
+ }
+}
+
+?>
diff --git a/htdocs/src/PostIterator.inc.php b/htdocs/src/PostIterator.inc.php
new file mode 100644
index 0000000..6106f23
--- /dev/null
+++ b/htdocs/src/PostIterator.inc.php
@@ -0,0 +1,67 @@
+<?php
+
+/* Foursquare Community Site
+ *
+ * Copyright (C) 2011 Foursquare Church.
+ *
+ * Developers: Jesse Morgan <jmorgan@foursquarestaff.com>
+ *
+ */
+
+require_once "base.inc.php";
+
+class PostIterator implements Iterator {
+ private $where;
+ private $rows;
+ private $position;
+
+ public function __construct() {
+ $this->where = array();
+ $this->rows = array();
+ $this->position = 0;
+ }
+
+ public function filterStage($stage) {
+ $this->where[] = "stage='$stage'";
+ }
+
+ public function filterSource($source) {
+ $this->where[] = "source_id='$source'";
+ }
+
+ public function rewind() {
+ $this->position = 0;
+ }
+
+ public function current() {
+ return new Post($this->rows[$this->position]);
+ }
+
+ public function key() {
+ return $this->rows[$this->position]['id'];
+ }
+
+ public function next() {
+ ++$this->position;
+ }
+
+ public function valid() {
+ return isset($this->rows[$this->position]);
+ }
+
+ public function query() {
+ $query = "SELECT * FROM post";
+
+ if (count($this->where) > 0) {
+ $where = join(' AND ', $this->where);
+ $query .= " WHERE $where";
+ }
+
+ $db = getDatabase();
+
+ $this->rows = $db->fetchAssocRows($query);
+ $this->position = 0;
+ }
+}
+
+?>
diff --git a/htdocs/src/User.inc.php b/htdocs/src/User.inc.php
new file mode 100644
index 0000000..6821042
--- /dev/null
+++ b/htdocs/src/User.inc.php
@@ -0,0 +1,74 @@
+<?php
+
+/* Foursquare Community Site
+ *
+ * Copyright (C) 2011 Foursquare Church.
+ *
+ * Developers: Jesse Morgan <jmorgan@foursquarestaff.com>
+ *
+ */
+
+require_once "base.inc.php";
+
+class User {
+ private $info;
+
+
+ public static function getById($id) {
+ $where = "id='$id'";
+
+ return User::getUser($where);
+ }
+
+ public static function getByEmail($email) {
+ $where = "email='$email'";
+
+ return User::getUser($where);
+ }
+
+ private static function getUser($where) {
+ $query = "SELECT * FROM user WHERE $where";
+
+ $db = getDatabase();
+
+ $row = $db->fetchAssocRow($query);
+
+ if ($row) {
+ $user = new User();
+ $user->info = $row;
+
+ return $user;
+
+ } else {
+ return false;
+ }
+ }
+
+ public function save() {
+ $db = getDatabase();
+
+ // TODO: Implement save
+ }
+
+ public function getId() {
+ return $this->info['id'];
+ }
+
+ public function getName() {
+ return $this->info['name'];
+ }
+
+ public function getEmail() {
+ return $this->info['email'];
+ }
+
+ public function setPassword($password) {
+ $this->info['password'] = sha1($password);
+ }
+
+ public function authenticate($password) {
+ return sha1($password) == $this->info['password'];
+ }
+}
+
+?>
diff --git a/htdocs/src/base.inc.php b/htdocs/src/base.inc.php
new file mode 100644
index 0000000..d7a9354
--- /dev/null
+++ b/htdocs/src/base.inc.php
@@ -0,0 +1,45 @@
+<?php
+
+/* Foursquare Community Site
+ *
+ * Copyright (C) 2011 Foursquare Church.
+ *
+ * Developers: Jesse Morgan <jmorgan@foursquarestaff.com>
+ *
+ */
+
+require_once('config.inc.php');
+
+require_once('Cif_Database.inc.php');
+
+/* Set the timezone for PHP */
+date_default_timezone_set('America/Los_Angeles');
+
+/* Start Session */
+session_start();
+
+/* Helper functions */
+$__DB = null;
+
+function getDatabase() {
+ global $CONFIG, $__DB;
+
+ if ($__DB == null) {
+ try {
+ $__DB = new Cif_Database($CONFIG['dbhost'], $CONFIG['dbuser'],
+ $CONFIG['dbpass'], $CONFIG['dbname']);
+
+ } catch (Cif_Database_Exception $e) {
+ die("Could not connect to database");
+ }
+ }
+
+ return $__DB;
+}
+
+function __autoload($class) {
+ require_once "$class.inc.php";
+}
+
+
+?>
diff --git a/htdocs/src/config.inc.php b/htdocs/src/config.inc.php
index e93eb43..1ca6808 100644
--- a/htdocs/src/config.inc.php
+++ b/htdocs/src/config.inc.php
@@ -12,14 +12,18 @@ $CONFIG = array(
// Database Information
'dbhost' => '127.0.0.1',
'dbuser' => 'p4scommunity',
- 'dbpass' => '',
+ 'dbpass' => 'password',
'dbname' => 'p4scommunity',
// Site Information
'sitetitle' => 'Foursquare Community',
'urlroot' => 'http://localhost/~jesse/p4s/community/htdocs',
+
+ 'root' => '/Users/jesse/Development/P4Square/community/htdocs',
-
+ 'debug' => true,
);
+set_include_path(get_include_path() . PATH_SEPARATOR . $CONFIG['root'].'/src');
+
?>