Well, you can see posts on the moderation panel now

1 files changed, 67 insertions, 0 deletions

diff --git a/htdocs/moderate/src/accounts.inc.php b/htdocs/moderate/src/accounts.inc.php
new file mode 100644
index 0000000..fac6c7c
--- /dev/null
+++ b/htdocs/moderate/src/accounts.inc.php
@@ -0,0 +1,67 @@
+<?php
+/* $Id: accounts.inc.php 134 2011-03-08 23:35:57Z jessemorgan $ */
+
+function getAccount($id) {
+    $query = "SELECT * FROM jpm_users WHERE"
+        . "`id`='$id' OR `email`='$id'";
+    
+    $db = getDatabase();
+
+    $results = array();
+
+    try {
+        $results = $db->fetchAssocRow($query);
+
+    } catch (Cif_Database_Exception $e) {
+        $results = false;
+    }
+
+    return $results;
+}
+
+function updatePassword($id, $password) {
+    $db = getDatabase();
+
+    $row['password'] = sha1($password);
+    
+    $db->update('jpm_users', $row, "WHERE `id`='$id'");
+}
+
+function getAccounts($s) {
+    $query = "SELECT * FROM jpm_users";
+    
+    if (!is_null($s)) {
+        $s = addslashes($s);
+        $query .= " WHERE name LIKE '%$s%' OR email LIKE '%$s%'";
+    }
+
+    $query .= " ORDER BY name";
+    
+    $db = getDatabase();
+
+    $results = array();
+
+    try {
+        $results = $db->fetchAssocRows($query);
+
+    } catch (Cif_Database_Exception $e) {
+        $results = array();
+    }
+
+    return $results;
+}
+
+function generatePassword() {
+    $alphabet = "ABCDEFGHJKLMNPQRSTUVWXYZabcdefghjkmnpqrstuvwxyz123456789!@#$%*()";
+    $length = strlen($alphabet);
+
+    $password = '';
+    for ($i = 0; $i < 8; $i++) {
+        $pos = rand(0, $length - 1);
+        $password .= substr($alphabet, $pos, 1); 
+    }
+
+    return $password;
+}
+
+?>