Error \n";
echo "Please install or upgrade MyQuilt Admin before using it.
";
include("admin_footer.php");
exit;
}
}
function printDeletionWarning() {
global $admin;
if (!isInstalled())
return;
if (strstr($_SERVER['PHP_SELF'], "/admin/index.php") || strstr($_SERVER['PHP_SELF'], "/admin/sendpass.php") || strstr($_SERVER['PHP_SELF'], "/admin/install.php") || strstr($_SERVER['PHP_SELF'], "/admin/upgrade2.0.php") || strstr($_SERVER['PHP_SELF'], "/admin/upgrade3.0.php"))
return;
if (file_exists(dirname(__FILE__)."/install.php") || file_exists(dirname(__FILE__)."/upgrade2.0.php") || file_exists(dirname(__FILE__)."/upgrade3.0.php"))
echo 'You need to delete the files admin/install.php , admin/upgrade2.0.php and admin/upgrade3.0.php from your server!
';
}
function isDbCurrent() {
$result = mysql_query("SELECT version FROM ".TABLE_PREFIX."admin WHERE id = '1'");
if (@mysql_num_rows($result) < 1)
return false;
$row = mysql_fetch_array($result);
if (strcmp($row['version'], MQA_VERSION) != 0)
return false;
return true;
}
function isDbCurrentBouncer() {
if (strstr($_SERVER['PHP_SELF'], "/admin/install.php") || strstr($_SERVER['PHP_SELF'], "/admin/upgrade2.0.php") || strstr($_SERVER['PHP_SELF'], "/admin/upgrade3.0.php"))
return;
if (!isDbCurrent()) {
$page_title = " › Database Not Current!";
include("admin_header.php");
echo "Error \n";
echo "Please upgrade MyQuilt Admin's database before using it.
";
include("admin_footer.php");
exit;
}
}
function getCats(&$count) {
$query = "SELECT catId FROM ".TABLE_PREFIX."categories ORDER BY catId ASC";
$result = mysql_query($query);
$count = mysql_num_rows($result);
$cats = array();
while ($row = mysql_fetch_array($result)) {
array_push($cats, $row);
}
return $cats;
}
function catDropdown($selected = "", $exclude_member_cat = false) {
$query = "SELECT * FROM ".TABLE_PREFIX."categories".($exclude_member_cat ? " WHERE catId != 2" : "")." ORDER BY cat_name ASC";
$result = mysql_query($query);
echo "\t\t\n";
echo "\t\t\tCategory \n";
echo "\t\t\t\n";
while ($row = mysql_fetch_array($result))
echo "\t\t\t\t".$row['cat_name']." \n";
echo "\t\t\t \n";
echo "\t\t \n";
}
function catDropdownSearch($selected = "") {
$query = "SELECT * FROM ".TABLE_PREFIX."categories ORDER BY cat_name ASC";
$result = mysql_query($query);
echo "\t\t\n";
echo "\t\t\tBrowse Category \n";
echo "\t\t\t\n";
echo "\t\t\t\tAll \n";
while ($row = mysql_fetch_array($result))
echo "\t\t\t\t".$row['cat_name']." \n";
echo "\t\t\t \n";
echo "\t\t \n";
}
function cleanFolderName($folder_name) {
$folder_name = preg_replace('/[^a-z0-9_\-[:blank:]{1}]/i', '', strtolower($folder_name));;
$folder_name = str_replace(" ", "_", $folder_name);
return $folder_name;
}
function isFolderTaken($folder_name, $exclude) {
$query = "SELECT * FROM ".TABLE_PREFIX."categories WHERE folder_name = '".escape($folder_name)."' AND catId != '".escape($exclude)."'";
$result = mysql_query($query);
if (mysql_num_rows($result) < 1)
return false;
return true;
}
function cleanFileName($filename) {
$path_parts = pathinfo($filename);
$filename = rtrim(basename($filename, $path_parts['extension']), ".");
$filename = preg_replace('/[^a-z0-9_\-[:blank:]{1}]/i', '', strtolower($filename));;
$filename = str_replace(" ", "_", $filename);
return $filename;
}
function get_patch_filename($name, $member_num, $imgtype) {
global $admin;
switch ($imgtype)
{
case "1":
$ext = ".gif";
break;
case "3":
$ext = ".png";
break;
}
if ($admin->patch_naming == "#name")
$patch_stored = cleanFolderName($member_num . strtolower($name)) . $ext;
elseif ($admin->patch_naming == "#")
$patch_stored = cleanFolderName($member_num) . $ext;
else
$patch_stored = cleanFolderName(strtolower($name) . $member_num) . $ext;
return $patch_stored;
}
function getPatchFilename($name, $member_num, $ext) {
global $admin;
if ($admin->patch_naming == "#name")
$patch_stored = cleanFolderName($member_num . strtolower($name)) . $ext;
elseif ($admin->patch_naming == "#")
$patch_stored = cleanFolderName($member_num) . $ext;
else
$patch_stored = cleanFolderName(strtolower($name) . $member_num) . $ext;
return $patch_stored;
}
function getPatches(&$count, $isApproved, $search_by = "", $search_for = "", $catId = "", $sort_by = "", $sort_how = "", $perpage_by_arg = "") {
global $perpage;
$query = "SELECT * FROM ".TABLE_PREFIX."patches WHERE isApproved = '".escape($isApproved)."'";
if ($search_by == "member_name" || $search_by == "member_num" || $search_by == "member_email" || $search_by == "patch_url" || $search_by == "patch_desc" || $search_by == "patch_stored")
$query .= " AND $search_by ".($search_by == "member_num" ? "= '".escape($search_for)."'" : "LIKE '%".escape($search_for)."%'");
if ($catId != "")
$query .= " AND catId = '".escape($catId)."'";
$result = mysql_query($query);
$count = mysql_num_rows($result);
$query .= " ORDER BY ";
switch($sort_by)
{
case "displayId":
case "member_name":
case "member_num":
case "date_received":
$query .= $sort_by;
break;
default:
$query .= "patchId";
break;
}
if (strtoupper($sort_how) == "ASC")
$query .= " ASC";
else
$query .= " DESC";
// Figure out how to paginate
if (strstr(dirname($_SERVER['PHP_SELF']), "/admin")) {
if (is_numeric($perpage) && $perpage > 0)
$perpage_in = $perpage;
else
$perpage_in = $count;
$start = validateP() * $perpage_in - $perpage_in;
$query .= " LIMIT $start, ".escape($perpage_in);
}
else {
if (is_numeric($perpage_by_arg) && $perpage_by_arg > 0)
$perpage_in = $perpage_by_arg;
else
$perpage_in = $count;
if ($_GET['catId'] == $catId || $_GET['catId'] == -1)
$start = validateP() * $perpage_in - $perpage_in;
else
$start = 0;
$query .= " LIMIT $start, ".escape($perpage_in);
}
//echo $query."\n";
echo "\t\t\t\tJanuary \n";
echo "\t\t\t\tFebruary \n";
echo "\t\t\t\tMarch \n";
echo "\t\t\t\tApril \n";
echo "\t\t\t\tMay \n";
echo "\t\t\t\tJune \n";
echo "\t\t\t\tJuly \n";
echo "\t\t\t\tAugust \n";
echo "\t\t\t\tSeptember \n";
echo "\t\t\t\tOctober \n";
echo "\t\t\t\tNovember \n";
echo "\t\t\t\tDecember \n";
echo "\t\t\t \n";
}
function dayDropdown($selected, $id_concat = "") {
echo "\t\t\t\n";
for ($i = 1; $i <= 31; $i++) {
$padded = "$i";
if ($i / 10 < 1)
$padded = str_pad($padded, 2, "0", STR_PAD_LEFT);
echo "\t\t\t\t$i \n";
}
echo "\t\t\t \n";
}
function hourDropdown($selected, $id_concat = "") {
echo "\t\t\t\n";
for ($i = 1; $i <= 12; $i++) {
// Get Selected
if ($selected > 12) {
$selected = $selected - 12;
$selected = str_pad($selected, 2, "0", STR_PAD_LEFT);
}
elseif ($selected == "00")
$selected = 12;
$padded = "$i";
if ($i / 10 < 1)
$padded = str_pad($padded, 2, "0", STR_PAD_LEFT);
echo "\t\t\t\t$i \n";
}
echo "\t\t\t \n";
}
function minuteDropdown($selected, $id_concat = "") {
echo "\t\t\t\n";
for ($i = 0; $i <= 59; $i++) {
$padded = "$i";
if ($i / 10 < 1)
$padded = str_pad($padded, 2, "0", STR_PAD_LEFT);
echo "\t\t\t\t$padded \n";
}
echo "\t\t\t \n";
}
function getPosts(&$count, $year = "", $month = "", $search_by = "", $search_for = "") {
global $perpage;
$start = validateP() * $perpage - $perpage;
$query = "SELECT * FROM ".TABLE_PREFIX."blog";
switch($search_by)
{
case "title":
case "content":
$query .= " WHERE ".$search_by." LIKE '%".escape($search_for)."%'";
$where = false;
break;
default:
$where = true;
break;
}
// Year
if (!empty($year)) {
$query .= ($where ? " WHERE" : " AND")." YEAR(post_date) = '".escape($year)."'";
$where = false;
}
// Month
if (!empty($month))
$query .= ($where ? " WHERE" : " AND")." MONTH(post_date) = '".escape($month)."'";
$result = mysql_query($query);
$count = mysql_num_rows($result);
$query .= " ORDER BY post_date DESC LIMIT $start, ".escape($perpage);
$result = mysql_query($query);
$posts = array();
while ($row = mysql_fetch_array($result))
array_push($posts, $row);
return $posts;
}
function getMembers() {
$query = "SELECT * FROM ".TABLE_PREFIX."patches WHERE isApproved = '1' AND catId = '2' ORDER BY member_name ASC";
$result = mysql_query($query);
$members = array();
while ($row = mysql_fetch_array($result))
array_push($members, $row);
return $members;
}
/*******************************************************************************
*
* GENERAL FUNCTIONS
*
*******************************************************************************/
function cleanUp($string) {
// Clean Up Form Submissions
$string = strip_tags($string);
$string = str_replace("\r\n", " ", $string);
$string = str_replace("\n", " ", $string);
$string = str_replace("\r", " ", $string);
$string = stripslashes($string);
$string = htmlentities($string, ENT_QUOTES);
$string = trim($string);
return $string;
}
function cleanUpCode($string) {
// Allow some html
$string = strip_tags($string, "");
$string = my_nl2br($string);
$string = stripslashes($string);
$string = str_replace("&", "&", $string);
$string = str_replace("'", "'", $string);
$string = addslashes($string);
$string = trim($string);
return $string;
}
function my_nl2br($string) {
$string = str_replace("\r\n", "\n";
$url = "\t 0) {
echo $url.$prev."\" title=\"Previous\">« \n";
}
if ($p == 1)
echo "\t1 \n";
else
echo $url."1\" title=\"Page 1\">1
$i \n";
else
echo $url.$i."\" title=\"Page $i\">$i\n";
}
}
if ($p + 2 < $howmany)
echo "\t ...\n";
if ($p == $howmany)
echo "\t$howmany \n";
else
echo $url.$howmany."\" title=\"Page $howmany\">$howmany\n";
// Next Link
if ($next*$perpage < $num+$perpage) {
echo $url.$next."\" title=\"Next\">»\n";
}
echo "\n\n";
}
function quilt_pagination($num, $perpage, $catId) {
$p = validateP();
$prev = $p - 1;
$next = $p + 1;
$howmany = ceil($num/$perpage);
if ($num <= $perpage) {
return;
}
echo "\n";
$url = "\t 0) {
echo $url.$prev."\" title=\"Previous\">« \n";
}
if ($p == 1)
echo "\t1 \n";
else
echo $url."1\" title=\"Page 1\">1\n";
if ($p >= 4)
echo "\t ...\n";
for ($i = $p - 2; $i <= $p + 2; $i++) {
if ($i >= 2 && $i <= $howmany - 1) {
if($i == $p)
echo "\t$i \n";
else
echo $url.$i."\" title=\"Page $i\">$i\n";
}
}
if ($p + 2 < $howmany)
echo "\t ...\n";
if ($p == $howmany)
echo "\t$howmany \n";
else
echo $url.$howmany."\" title=\"Page $howmany\">$howmany\n";
// Next Link
if ($next*$perpage < $num+$perpage) {
echo $url.$next."\" title=\"Next\">»\n";
}
echo "
\n\n";
}
/*******************************************************************************
*
* TEMPLATE FUNCTIONS
*
*******************************************************************************/
function print_cat_name($catId) {
$cat = new Category();
if ($cat->getCatById(cleanUp($catId)))
echo $cat->cat_name;
else
echo "Invalid Category ID";
}
function print_cat_description($catId) {
$cat = new Category();
if ($cat->getCatById(cleanUp($catId)))
echo stripslashes($cat->cat_desc);
else
echo "Invalid Category ID";
}
function print_cat_patch_count($catId) {
$cat = new Category();
if ($cat->getCatById(cleanUp($catId)))
echo $cat->patchCount();
else
echo "Invalid Category ID";
}
function print_cat_patches_list($catId, $patches_on_row = "", $perpage = "", $use_fillers = "", $filler_url = "", $filler_alt = "", $use_alt = "", $alt_url = "", $alt_alt = "", $sort_by = "", $sort_how = "") {
$admin = new Admin();
$admin->getAdmin();
$cat = new Category();
$patch = new Patch();
if (!$cat->getCatById(cleanUp($catId))) {
echo "Invalid Category ID
\n";
return;
}
// Get Category Defaults
if (!is_numeric($patches_on_row) || $patches_on_row < 1)
$patches_on_row = $cat->perline;
if (!is_numeric($perpage) || ($perpage != -1 && $perpage < 1))
$perpage = $cat->perpage;
if ($use_fillers === "")
$use_fillers = $cat->use_fillers;
if ($filler_url == "")
$filler_url = $cat->filler_url;
if ($filler_alt == "")
$filler_alt = $cat->filler_alt;
if ($use_alt === "")
$use_alt = $cat->use_alt;
if ($alt_url == "")
$alt_url = $cat->alt_url;
if ($alt_alt == "")
$alt_alt = $cat->alt_alt;
if ($sort_by != "displayId" && $sort_by != "member_name" && $sort_by != "member_num" && $sort_by != "date_received")
$sort_by = $cat->sort_by;
if ($sort_how != "asc" && $sort_how != "desc")
$sort_how = $cat->sort_how;
// Take Alternating Patches into account
if ($use_alt == true)
$perpage = ceil($perpage / 2);
// Get Patches
$patches = getPatches($patch_count, 1, "", "", $cat->catId, $sort_by, $sort_how, $perpage);
if ($patch_count < 1)
return; // No patches found - print nothing
// Validate Perpage
if ($perpage < 1)
$perpage = $patch_count;
$i=0; // Row
$j=1; // Patch Count
$k=1; // Alternating Patches
echo "catId\">\n";
foreach ($patches as $row) {
$patch->getPatchById($row['patchId']);
// Is Alternating Patch?
if ($k % 2 == 0 && $use_alt == true) {
echo "\t".'".($patch->patch_url != "" && $patch->patch_url != "http://" ? '' : '').' ' : '')." \n";
// End Row?
if ($i == $patches_on_row-1)
$i=0;
else
$i++;
$j++;
$k++;
}
// Filler Patches
if ($i != 0 && $use_fillers == true) {
$leftover = $patches_on_row - $i;
for ($i=0; $i<$leftover; $i++) {
if ($i % 2 == 0 && $use_alt == true) {
echo "\t".' \n";
continue;
}
echo "\t".' \n";
}
}
echo " \n";
// Pagination
quilt_pagination($patch_count, $perpage, $cat->catId);
}
function print_cat_patches($catId, $patches_on_row = "", $perpage = "", $use_fillers = "", $filler_url = "", $filler_alt = "", $use_alt = "", $alt_url = "", $alt_alt = "", $sort_by = "", $sort_how = "") {
$admin = new Admin();
$admin->getAdmin();
$cat = new Category();
$patch = new Patch();
if (!$cat->getCatById(cleanUp($catId))) {
echo "Invalid Category ID
\n";
return;
}
// Get Category Defaults
if (!is_numeric($patches_on_row) || $patches_on_row < 1)
$patches_on_row = $cat->perline;
if (!is_numeric($perpage) || ($perpage != -1 && $perpage < 1))
$perpage = $cat->perpage;
if ($use_fillers === "")
$use_fillers = $cat->use_fillers;
if ($filler_url == "")
$filler_url = $cat->filler_url;
if ($filler_alt == "")
$filler_alt = $cat->filler_alt;
if ($use_alt === "")
$use_alt = $cat->use_alt;
if ($alt_url == "")
$alt_url = $cat->alt_url;
if ($alt_alt == "")
$alt_alt = $cat->alt_alt;
if ($sort_by != "displayId" && $sort_by != "member_name" && $sort_by != "member_num" && $sort_by != "date_received")
$sort_by = $cat->sort_by;
if ($sort_how != "asc" && $sort_how != "desc")
$sort_how = $cat->sort_how;
// Take Alternating Patches into account
if ($use_alt == true)
$perpage = ceil($perpage / 2);
// Get Patches
$patches = getPatches($patch_count, 1, "", "", $cat->catId, $sort_by, $sort_how, $perpage);
if ($patch_count < 1)
return; // No patches found - print nothing
// Validate Perpage
if ($perpage < 1)
$perpage = $patch_count;
$i=0; // Row
$j=1; // Patch Count
$k=1; // Alternating Patches
echo "catId\">\n";
foreach ($patches as $row) {
$patch->getPatchById($row['patchId']);
// Is Alternating Patch?
if ($k % 2 == 0 && $use_alt == true) {
echo "\t".'
'."\n";
// End Row?
if ($i == $patches_on_row-1) {
echo "\t
\n";
$i=0;
}
else
$i++;
$j++;
$k++;
}
// Patch Info
$path = "/".$admin->patch_dir."/".$cat->folder_name."/".$patch->patch_stored;
$info = @getimagesize($_SERVER['DOCUMENT_ROOT'].$path);
//
echo "\t".($patch->patch_url != "" && $patch->patch_url != "http://" ? '
' : '').' ' : '')."\n";
// End Row?
if ($i == $patches_on_row-1) {
echo "\t
\n";
$i=0;
}
else
$i++;
$j++;
$k++;
}
// Filler Patches
if ($i != 0 && $use_fillers == true) {
$leftover = $patches_on_row - $i;
for ($i=0; $i<$leftover; $i++) {
if ($i % 2 == 0 && $use_alt == true) {
echo "\t".'
'."\n";
continue;
}
echo "\t".'
'."\n";
}
}
echo "
\n";
// Validate patches per page
if (!is_numeric($perpage) || $perpage < 1)
$perpage = $patch_count;
$start = validateP() * $perpage - $perpage;
// Print the Quilt - $i = iterator, $j = index, $k = row
for ($i=0, $j=$start, $k=0; $i<$perpage; $i++,$j++) {
if ($j >= $patch_count)
break;
elseif ($patches[$j] == "a")
// Print Alternating Patch
echo "\t".'
'."\n";
else {
// Print Real Patch
$patch->getPatchById($patches[$j]);
$cat->getCatById($patch->catId);
// Patch Info
$path = "/".$admin->patch_dir."/".$cat->folder_name."/".$patch->patch_stored;
$info = @getimagesize($_SERVER['DOCUMENT_ROOT'].$path);
//
echo "\t".($patch->patch_url != "" && $patch->patch_url != "http://" ? '
' : '').' ' : '')."\n";
}
// End Row?
if ($k == $patches_on_row-1) {
echo "\t
\n";
$k=0;
}
else
$k++;
}
// Filler Patches
if ($k!=0 && $use_fillers == true) {
$leftover = $patches_on_row - $k;
// Add Trailing Alt Patch
if (!is_numeric($patches[$j])) {
echo "\t".'
'."\n";
$leftover--;
}
for ($i=0; $i<$leftover; $i++) {
if ($i % 2 != 0)
echo "\t".'
'."\n";
else
echo "\t".'
'."\n";
}
}
echo "
patch_url\" title=\"$patch->member_name #$patch->member_num\" target=\"_blank\">$patch->member_name".(!empty($display_member_num) ? " #$patch->member_num" : "")." ";
}
function print_last_added_date() {
$admin = new Admin();
$admin->getAdmin();
$patch = new Patch();
$patches = getPatches($patch_count, 1, "", "", 2, "date_received", "desc");
if ($patch_count < 1)
return;
$patch->getPatchById($patches[0]['patchId']);
echo date($admin->date_format, strtotime($patch->date_received) + ($admin->time_offset * 60 * 60));
}
function print_last_added_time() {
$admin = new Admin();
$admin->getAdmin();
$patch = new Patch();
$patches = getPatches($patch_count, 1, "", "", 2, "date_received", "desc");
if ($patch_count < 1)
return;
$patch->getPatchById($patches[0]['patchId']);
echo date($admin->time_format, strtotime($patch->date_received) + ($admin->time_offset * 60 * 60));
}
function print_post_id() {
global $post;
echo $post->id;
}
function print_post_title() {
global $post;
echo $post->title;
}
function print_post_content() {
global $post;
echo stripslashes($post->content);
}
function print_post_date($format = "") {
global $post;
$admin = new Admin();
$admin->getAdmin();
if (empty($format))
$format = $admin->date_format;
echo date($format, strtotime($post->post_date) + ($admin->time_offset * 60 * 60));
}
function print_post_time($format = "") {
global $post;
$admin = new Admin();
$admin->getAdmin();
if (empty($format))
$format = $admin->time_format;
echo date($format, strtotime($post->post_date) + ($admin->time_offset * 60 * 60));
}
function print_blog_archives() {
// Check to see if there are blog entries
$query = "SELECT id FROM ".TABLE_PREFIX."blog ORDER BY id DESC";
$result = mysql_query($query);
if (mysql_num_rows($result) < 1)
return;
// Get Current Year Archives
$query = "SELECT DISTINCT MONTH(post_date) AS month, YEAR(post_date) AS year FROM ".TABLE_PREFIX."blog WHERE YEAR(post_date) = '".date("Y")."' ORDER BY post_date DESC";
$result = mysql_query($query);
echo "\n";
// Print Archives
while($row = mysql_fetch_array($result)) {
$month = date("F", mktime(0, 0, 0, $row['month'], 1, $row['year']));
echo "\t".$month." ".$row['year']." Year of ".$row['year']." \n";
}
function print_full_log($display_time = false) {
$admin = new Admin();
$admin->getAdmin();
$patch = new Patch();
// Check and see if there are existing trades
$cat = new Category();
$cat->getCatById(2);
if ($cat->patchCount() < 1)
return;
// Validate Log Year
if (!is_numeric($_GET['log_year']) || $_GET['log_year'] < 2000 || $_GET['log_year'] > date("Y"))
$log_year = date("Y");
else
$log_year = $_GET['log_year'];
// Get Trades
$query = "SELECT patchId FROM ".TABLE_PREFIX."patches WHERE isApproved = '1' AND catId = '2' AND YEAR(date_received) = '".escape($log_year)."' ORDER BY date_received DESC";
$result = mysql_query($query);
echo "Trade Log \n";
if (mysql_num_rows($result) < 1)
echo "No trades for the year $log_year.
\n";
else {
echo "\n";
}
// Get Archives
$query = "SELECT DISTINCT YEAR(date_received) AS year FROM ".TABLE_PREFIX."patches WHERE isApproved = '1' AND catId = '2' AND YEAR(date_received) != '".escape($log_year)."' ORDER BY year DESC";
$result = mysql_query($query);
if (mysql_num_rows($result) > 0) {
echo "Archives \n";
echo "\n";
while ($row = mysql_fetch_array($result))
echo "\t".$row['year']." \n";
}
}
/*******************************************************************************
*
* INCLUDES
*
*******************************************************************************/
if (isInstalled()) {
include_once("classes/Admin.php");
include_once("classes/Blog.php");
include_once("classes/Category.php");
include_once("classes/Patch.php");
}
isInstalledBouncer();
isDbCurrentBouncer();
Welcome to my Quilt
