$name, 'type'=>'dir', 'url'=>$dir . $name . '/', 'contents'=>dir_get_contents($dir . $name . '/', $filter, $sort));
} else if (is_file($dir . $name) && (($filter && preg_match($filter, $dir . $name)) || !$filter)) {
$structure[] = array('name'=>$name, 'type'=>'file', 'url'=>$dir . $name);
}
}
$type = array();
while (list($key, $value) = each($structure)) { $type[$key] = $value['type']; }
array_multisort($type, $sort, $structure);
return $structure;
}
}
###############################################################
#
# Function: endtime(string $text);
# Author: Neo Geek (NG)
#
###############################################################
if (!function_exists('endtime')) {
function endtime() { return microtime(true) - constant('int_microtime'); }
}
###############################################################
#
# Function: error(string $text);
# Author: Neo Geek (NG)
#
###############################################################
if (!function_exists('error')) {
function error($text = '') {
if (!$text) { return false; } else { $text = date('Y-m-d H:i:s') . ' - ' . $text; }
if (constant('error_log')) {
file_put_contents(is_string(constant('error_log'))?constant('error_log'):'log.txt', $text . PHP_EOL, FILE_APPEND);
}
if (constant('error_reporting')) {
echo '' . preg_replace('/(^[[:alpha:] ]+:)/', '\1', strip_tags($text)) . '
' . PHP_EOL;
}
return false;
}
}
###############################################################
#
# Function: fetch_remote_file(string $file [, string $query]);
# Author: Neo Geek (NG)
#
###############################################################
if (!function_exists('fetch_remote_file')) {
function fetch_remote_file($file, $query = '') {
$path = parse_url($file);
if ($fs = @fsockopen($path['host'], isset($path['port'])?$path['port']:80)) {
$header = ($query?'POST':'GET') . ' ' . $path['path'] . ' HTTP/1.0' . "\r\n" . 'Host: ' . $path['host'] . "\r\n";
if ($query){
$header .= 'Content-type: application/x-www-form-urlencoded' . "\r\n";
$header .= 'Content-length: ' . strlen($query) . "\r\n" . 'Connection: close' . "\r\n\r\n" . $query;
} else { $header .= "\r\n"; }
fwrite($fs, $header);
$buffer = '';
while ($tmp = fread($fs, 1024)) { $buffer .= $tmp; }
preg_match('/HTTP\/[0-9\.]{1,3} ([0-9]{3})/', $buffer, $http);
preg_match('/Location: (.*)/', $buffer, $redirect);
if (isset($redirect[1]) && $file != trim($redirect[1])) { return fetch_remote_file(trim($redirect[1])); }
if (isset($http[1]) && $http[1] == 200) { return substr($buffer, strpos($buffer, "\r\n\r\n") +4); } else { return false; }
} else { return false; }
}
}
###############################################################
#
# Function: file_put_contents(string $table, string $field);
# Author: Neo Geek (NG)
#
###############################################################
if (!function_exists('field_type')) {
function field_type($table, $field) {
$results = mysql_fetch_results('SHOW COLUMNS FROM `' . $table . '` WHERE `Field` = "' . $field . '"');
preg_match('/^[a-z]+/i', $results[0]['Type'], $matches);
return $matches[0];
}
}
###############################################################
#
# Function: file_put_contents(string $file [, string $contents, boolean $flag]);
# Author: Neo Geek (NG)
#
###############################################################
if (!function_exists('file_put_contents')) {
if (!@constant('FILE_APPEND')) { define('FILE_APPEND', true); }
function file_put_contents($file, $contents = '', $flag = false) {
$file_handle = fopen(preg_replace('/\/+/', '/', $file), $flag?'a+':'w+');
fwrite($file_handle, $contents);
fclose($file_handle);
return true;
}
}
###############################################################
#
# Function: is_date(string $value);
# Author: Neo Geek (NG)
#
###############################################################
if (!function_exists('is_date')) {
function is_date($value) {
if (preg_match('/^([0-9]{2})([-\/ ])([0-9]{2})([-\/ ])([0-9]{2,4})$/', (string)$value)) { return true; } else { return false; }
}
}
###############################################################
#
# Function: is_email(string $value);
# Author: Neo Geek (NG)
#
###############################################################
if (!function_exists('is_email')) {
function is_email($value) {
if (preg_match('/^[[:alnum:]-.]+@[[:alnum:]-]+\.[[:alnum:]]{2,}+$/', (string)$value)) { return true; } else { return false; }
}
}
###############################################################
#
# Function: is_empty(string $value);
# Author: Neo Geek (NG)
#
###############################################################
if (!function_exists('is_empty')) {
function is_empty($value) {
if (!isset($value)) { return true; } else { return false; }
}
}
###############################################################
#
# Function: is_number(string $value);
# Author: Neo Geek (NG)
#
###############################################################
if (!function_exists('is_number')) {
function is_number($value) {
if (preg_match('/^[.0-9]+$/', (string)$value)) { return true; } else { return false; }
}
}
###############################################################
#
# Function: is_simple(string $value);
# Author: Neo Geek (NG)
#
###############################################################
if (!function_exists('is_simple')) {
function is_simple($value) {
if (preg_match('/^[[:alnum:]_]+$/', (string)$value)) { return true; } else { return false; }
}
}
###############################################################
#
# Function: is_simple_alpha(string $value);
# Author: Neo Geek (NG)
#
###############################################################
if (!function_exists('is_simple_alpha')) {
function is_simple_alpha($value) {
if (preg_match('/^[[:alnum:]]+$/', (string)$value)) { return true; } else { return false; }
}
}
###############################################################
#
# Function: is_simple_number(string $value);
# Author: Neo Geek (NG)
#
###############################################################
if (!function_exists('is_simple_number')) {
function is_simple_number($value) {
if (preg_match('/^[0-9]+$/', (string)$value)) { return true; } else { return false; }
}
}
###############################################################
#
# Function: is_web_address(string $value);
# Author: Neo Geek (NG)
#
###############################################################
if (!function_exists('is_web_address')) {
function is_web_address($value) {
if (preg_match('/^((http|https):\/\/)?+[[:alnum:]-]+\.+[[:alnum:]]/', (string)$value)) { return true; } else { return false; }
}
}
###############################################################
#
# Function: mysql_fetch_results(string $query [, array $results]);
# Author: Neo Geek (NG)
#
###############################################################
if (!function_exists('mysql_fetch_results')) {
function mysql_fetch_results($query = '', $results = array()) {
$result = @mysql_query($query) or error('MySQL Error: ' . mysql_error());
while ($row = @mysql_fetch_assoc($result)) { $results[] = $row; }
return $results;
}
}
###############################################################
#
# Function: path_info([integer $offset]);
# Author: Neo Geek (NG)
#
###############################################################
if (!function_exists('path_info')) {
function path_info($offset = 0) {
$pathinfo = isset($_SERVER['PATH_INFO'])?$_SERVER['PATH_INFO']:(isset($_SERVER['ORIG_PATH_INFO'])?$_SERVER['ORIG_PATH_INFO']:null);
if ($pathinfo && $pathinfo != $_SERVER['SCRIPT_NAME']) {
$path_info = explode('/', substr($pathinfo, 1));
if (isset($path_info[$offset])) { return $path_info[$offset]; }
}
return false;
}
}
###############################################################
#
# Function: primary_key(string $table);
# Author: Neo Geek (NG)
#
###############################################################
if (!function_exists('primary_key')) {
function primary_key($table = '') {
$results = mysql_fetch_results('DESCRIBE ' . $table);
foreach ($results as $field) { if ($field['Key'] == 'PRI') { return $field['Field']; } }
return false;
}
}
###############################################################
#
# Function: print_array(array $array1 [, array $array2, ..., array $array10]);
# Author: Neo Geek (NG)
#
###############################################################
if (!function_exists('print_array')) {
function print_array() {
$arrays = func_get_args();
foreach ($arrays as $array) { echo '' . print_r($array, true) . '
'; }
}
}
###############################################################
#
# Function: sanitize_data([array $array]);
# Author: Neo Geek (NG)
#
###############################################################
if (!function_exists('sanitize_data')) {
function sanitize_data(&$data) {
if (is_array($data)) {
reset($data);
while (list($key, $value) = each($data)) {
$data[$key] = mysql_real_escape_string(get_magic_quotes_gpc()?stripslashes($value):$value);
}
reset($data);
} else { $data = mysql_real_escape_string(get_magic_quotes_gpc()?stripslashes($data):$data); }
return $data;
}
}
###############################################################
#
# Function: set_location(string $url);
# Author: Neo Geek (NG)
#
###############################################################
if (!function_exists('set_location')) {
function set_location($url) {
if (!headers_sent()) { header('Location: ' . $url); exit; }
return false;
}
}
###############################################################
#
# Function: timeago(timestamp $timestamp);
# Author: Neo Geek (NG)
#
###############################################################
if (!function_exists('timeago')) {
function timeago($timestamp) {
$diff = time() - strtotime($timestamp);
if ($diff < 60) { $output = $diff . ' seconds ago'; }
else if (round($diff / 60) < 60) { $output = round($diff / 60) . ' minute(s) ago'; }
else if (round($diff / 3600) < 24) { $output = round($diff / 3600) . ' hour(s) ago'; }
else if (round($diff / 86400) < 7) { $output = round($diff / 86400) . ' day(s) ago'; }
else if (round($diff / 604800) < 4) { $output = round($diff / 604800) . ' week(s) ago'; }
else if (round($diff / 2419200) < 12) { $output = round($diff / 2419200) . ' month(s) ago'; }
else if (round($diff / 29030400)) { $output = round($diff / 29030400) . ' years(s) ago'; }
if (preg_match('/[2-9]+/', $output)) { $output = str_replace('(s)', 's', $output); }
else { $output = str_replace('(s)', '', $output); }
return $output;
}
}
###############################################################
#
# Function: url_query(array $replacements, string $return);
# Author: Neo Geek (NG)
#
###############################################################
if (!function_exists('url_query')) {
function url_query($replacements = array(), $return = 'string') {
if (!is_array($replacements)) { return false; }
reset($replacements);
$output = array();
while (list($key, $value) = each($replacements)) {
if (!$value && isset($_GET[$key])) { unset($_GET[$key]); unset($replacements[$key]); }
}
$url_querys = array_merge($_GET, $replacements);
while (list($key, $value) = each($url_querys)) {
if ($value) { $output[] = $key . '=' . $value; }
}
if ($return == 'string' && count($output)) { $output = '?' . implode($output, '&'); }
return $output?$output:'';
}
}
###############################################################
###############################################################
#
# Template
#
###############################################################
if (!isset($_GET['norender']) && isset($ob_template)) { ob_start('ob_template'); }
function ob_template($buffer) {
global $ob_template;
preg_match('/(.*)<\/title>/si', $buffer, $regs);
$ob_template = preg_replace('/%title%/si', trim($regs[1]), $ob_template);
preg_match('/<head>(.*)<\/head>/si', $buffer, $regs);
$regs[1] = preg_replace('/<title>(.*)<\/title>/si', '', $regs[1]);
$ob_template = preg_replace('/%head%/si', trim($regs[1]), $ob_template);
preg_match('/<body>(.*)<\/body>/si', $buffer, $regs);
$ob_template = preg_replace('/%body%/si', trim($regs[1]), $ob_template);
$ob_template = preg_replace('/%([a-z_]+)%/si', '', $ob_template);
return $ob_template;
}
###############################################################
###############################################################
#
# Class: DB
# Author: Neo Geek (NG)
#
###############################################################
class DB {
var $resource = null;
var $results = null;
var $instances = array('connect'=>0, 'query'=>0);
function Connect($server, $username, $password, $database, $cache = true) {
$resource = @mysql_connect($server, $username, $password, true) or error('MySQL Error: ' . mysql_error());
if ($database) { @mysql_select_db($database, $resource) or error('MySQL Error: ' . mysql_error()); }
if ($cache) { $this->resource = $resource; }
$this->instances['connect']++;
return $resource;
}
function Query($query, $resource = null, $return = 'array', $cache = true) {
if (is_resource($resource)) { $result = @mysql_query($query, $resource) or error('MySQL Error: ' . mysql_error()); }
else if (is_resource($this->resource)) { $result = @mysql_query($query, $this->resource) or error('MySQL Error: ' . mysql_error()); }
else { $result = @mysql_query($query) or error('MySQL Error: ' . mysql_error()); }
if ($return == 'array') {
$results = array();
while ($row = @mysql_fetch_assoc($result)) { $results[] = $row; }
@mysql_free_result($result);
} else if ($return == 'boolean') {
$results = @mysql_affected_rows();
@mysql_free_result($result);
} else {
$results = $result;
}
if ($cache) { $this->results = $results; }
$this->instances['query']++;
return $results;
}
function Close($resource = null) {
if (is_resource($resource)) { @mysql_close($resource) or error('MySQL Error: ' . mysql_error()); }
else if (is_resource($this->resource)) { @mysql_close($this->resource) or error('MySQL Error: ' . mysql_error()); }
return false;
}
}
###############################################################
$DB = new DB;
###############################################################
###############################################################
#
# Class: Database
# Author: Neo Geek (NG)
#
###############################################################
class Database {
var $resource = null;
var $results = null;
function DatabaseList() {
global $DB;
$results = array();
if (is_resource($this->resource)) { $database_list = mysql_list_dbs($this->resource) or error('MySQL Error: ' . mysql_error()); }
else if (is_resource($DB->resource)) { $database_list = mysql_list_dbs($DB->resource) or error('MySQL Error: ' . mysql_error()); }
else { return error('MySQL Error: Cannot connect to MySQL server. Please advise.'); }
while ($database = @mysql_fetch_object($database_list)) { $results[] = array('database'=>$database->Database); }
$this->results = $results;
@mysql_free_result($database_list);
return $results;
}
function TableList($database) {
global $DB;
$results = array();
if (is_resource($this->resource)) { $table_list = mysql_list_tables($database, $this->resource) or error('MySQL Error: ' . mysql_error()); }
else if (is_resource($DB->resource)) { $table_list = mysql_list_tables($database, $DB->resource) or error('MySQL Error: ' . mysql_error()); }
else { return error('MySQL Error: Cannot connect to MySQL server. Please advise.'); }
$table_count = @mysql_num_rows($table_list);
for ($i = 0; $i < $table_count; $i++) { $results[] = array('table'=>mysql_tablename($table_list, $i)); }
$this->results = $results;
@mysql_free_result($table_list);
return $results;
}
function Table($database, $table, $fields = '*', $clause = null) {
global $DB;
$db_sort_by = (isset($_GET['db_sort_by']) && is_simple($_GET['db_sort_by']))?$_GET['db_sort_by']:'';
$db_sort_order = (isset($_GET['db_sort_order']) && is_simple($_GET['db_sort_order']))?$_GET['db_sort_order']:'asc';
$db_start = (isset($_GET['db_start']) && is_simple_number($_GET['db_start']))?$_GET['db_start']:0;
$db_limit = (isset($_GET['db_limit']) && is_simple_number($_GET['db_limit']))?$_GET['db_limit']:constant('maxview');
$sql = 'SELECT ' . $fields . ' FROM `' . $database . '`.`' . $table . '`';
if ($clause) { $sql .= ' ' . $clause; }
if ($db_sort_by) { $sql .= ' ORDER BY `' . $db_sort_by . '` ' . ucwords($db_sort_order) . ''; }
if ($db_limit) { $sql .= ' LIMIT ' . $db_start . ', ' . $db_limit; }
if (is_resource($this->resource)) { $results = $DB->Query($sql, $this->resource, 'array', false); }
else if (is_resource($DB->resource)) { $results = $DB->Query($sql, $DB->resource, 'array', false); }
else { return error('MySQL Error: Cannot connect to MySQL server. Please advise.'); }
$this->results = $results;
return $results;
}
function Process($database, $table, $variables = array(), $clause = null) {
global $DB;
if (!count($variables)) { return false; }
if (is_resource($this->resource)) { $resource = $this->resource; }
else if (is_resource($DB->resource)) { $resource = $DB->resource; }
else { return error('MySQL Error: Cannot connect to MySQL server. Please advise.'); }
$updates = array();
$columns = $DB->Query('SHOW COLUMNS FROM `' . $database . '`.`' . $table . '`', $resource, 'array', false);
foreach ($columns as $column) {
if (isset($variables[$column['Field']]) && $column['Key'] != 'PRI') {
$value = $variables[$column['Field']];
if (is_number($value) || $value == 'NOW()') { $updates[] = '`' . $column['Field'] . '` = ' . $value . ''; } else {
$updates[] = '`' . $column['Field'] . '` = "' . $value . '"';
}
} else if ($column['Key'] == 'PRI') { $primary_key = $column['Field']; }
}
if (!count($updates)) { return error('MySQL Error: None of the included key/value sets can update this table.'); }
if (isset($variables[$primary_key])) {
$results = $DB->Query('SELECT `' . $primary_key . '` FROM `' . $database . '`.`' . $table . '` WHERE `' . $primary_key . '` = ' . $variables[$primary_key] . '', $resource, 'array', false);
}
if (!isset($results) || !count($results)) { $sql = 'INSERT INTO ' . '`' . $database . '`.`' . $table . '` SET ' . implode($updates, ', '); }
else { $sql = 'UPDATE ' . '`' . $database . '`.`' . $table . '` SET ' . implode($updates, ', ') . ' WHERE `' . $primary_key . '` = ' . $variables[$primary_key] . '' . $clause; }
return $DB->Query($sql, $resource, 'boolean', false);
}
}
###############################################################
$Database = new Database;
###############################################################
###############################################################
#
# Class: GFX
# Author: Neo Geek (NG)
#
###############################################################
class GFX
{
function Resize($image, $width = 100, $height = 100, $output = null) {
if (!is_file($image)) { return false; }
$properties = getimagesize($image);
$cache = md5(serialize(array_merge(func_get_args(), $properties))) . '.' . substr($properties['mime'], 6);
if (is_dir($output) && is_file($output . $cache)) { return $output . $cache; }
if ($properties['mime'] == 'image/jpeg') { $original = imagecreatefromjpeg($image); }
else if ($properties['mime'] == 'image/gif') { $original = imagecreatefromgif($image); }
else if ($properties['mime'] == 'image/png') { $original = imagecreatefrompng($image); }
$new = imagecreatetruecolor($width, $height);
$ratio = $properties[0]/$properties[1];
if ($width/$height < $ratio) {
$offset_x = ($width-$height) / 2;
$offset_y = 0;
$width = $height*$ratio;
} else {
$offset_x = 0;
$offset_y = ($height-$width) / 2;
$height = $width/$ratio;
}
imagecopyresampled($new, $original, -$offset_x, -$offset_y, 0, 0, $width, $height, $properties[0], $properties[1]);
if (!$output && !headers_sent()) { header('Content-type: ' . $properties['mime']); } else if (is_dir($output)) { $output .= $cache; }
if ($properties['mime'] == 'image/jpeg') { imagejpeg($new, $output, 100); }
else if ($properties['mime'] == 'image/gif') { imagegif($new, $output); }
else if ($properties['mime'] == 'image/png') { imagepng($new, $output); }
imagedestroy($original);
imagedestroy($new);
return $output;
}
}
###############################################################
$GFX = new GFX;
###############################################################
###############################################################
#
# Class: OpenID
# Author: Neo Geek (NG)
#
###############################################################
class OpenID {
function Request($url = '', $options = array(), $canonize = false, $query = '') {
$url = (!strpos($url, '://'))?'http://'.$url:$url;
if ($canonize) { $url = preg_replace(array('/([^:])\/+/', '/\/$/'), array('\1/', ''), $url); }
if (function_exists('stream_get_contents')) { $contents = @stream_get_contents(@fopen($url, 'rb')); } else { $contents = file_get_contents($url); }
preg_match('/<link.*(?:rel=["\']openid.server["\'].*href=["\'](.*)["\']|href=["\'](.*)["\'].*rel=["\']openid.server["\']).*>/U', $contents, $server);
preg_match('/<link.*(?:rel=["\']openid.delegate["\'].*href=["\'](.*)["\']|href=["\'](.*)["\'].*rel=["\']openid.delegate["\']).*>/U', $contents, $delegate);
if (isset($delegate[1])) { return OpenID::Request($delegate[1]); } else if (!isset($server[1])) { return false; }
setcookie('fopenid', $server[1], time() +3600, '/');
$server_info = parse_url($server[1]);
if (substr($url, 0, strpos($url, ':')) != $server_info['scheme']) { $url = str_replace(substr($url, 0, strpos($url, ':')), $server_info['scheme'], $url); }
if (!isset($options['openid.identity'])) { $options['openid.identity'] = $url; }
if (!isset($options['openid.mode'])) { $options['openid.mode'] = 'checkid_setup'; }
if (!isset($options['openid.trust_root'])) { $options['openid.trust_root'] = 'http://' . $_SERVER['HTTP_HOST'] . $_SERVER['REQUEST_URI']; }
if (!isset($options['openid.return_to'])) { $options['openid.return_to'] = 'http://' . $_SERVER['HTTP_HOST'] . $_SERVER['REQUEST_URI']; }
while (list($key, $value) = each($options)) { $query .= $key . '=' . $value . '&'; }
header('Location: ' . $server[1] . (preg_match('/\?/', $server[1])?'&':'?') . $query); exit;
}
function Verify($query = '') {
$_GET['openid_mode'] = 'check_authentication';
while (list($key, $value) = each($_GET)) { $query .= preg_replace('/(openid|sreg)_/', '\1.', $key) . '=' . urlencode($value) . '&'; }
if (function_exists('stream_get_contents')) {
$results = @stream_get_contents(@fopen($_COOKIE['fopenid'], 'rb', false, @stream_context_create(array('http'=>array('method'=>'POST', 'content'=>$query)))));
} else {
$results = @file_get_contents($_COOKIE['fopenid'] . (preg_match('/\?/', $_COOKIE['fopenid'])?'&':'?') . $query);
}
if (preg_match('/true/', $results)) { return $_GET; }
return false;
}
}
$OpenID = new OpenID;
###############################################################
#
# Class: Template
# Author: Neo Geek (NG)
#
###############################################################
class Template {
var $tools = array();
function Parse($template = '') {
if (is_file($template)) { $template = file_get_contents($template); }
preg_match('/<!--{header:start}-->(.*)<!--{header:end}-->/si', $template, $matches['header']);
preg_match('/<!--{data:start}-->(.*)<!--{data:end}-->/si', $template, $matches['data']);
preg_match('/<!--{nodata:start}-->(.*)<!--{nodata:end}-->/si', $template, $matches['nodata']);
preg_match('/<!--{footer:start}-->(.*)<!--{footer:end}-->/si', $template, $matches['footer']);
while (list($key, $value) = each($matches)) {
$matches[$key] = isset($matches[$key][1])?$matches[$key][1]:'';
}
return $matches;
}
function Render($template, $data) {
if (isset($data['header'])) { $data_header = $data['header']; unset($data['header']); }
if (isset($data['footer'])) { $data_footer = $data['footer']; unset($data['footer']); }
if (isset($data['data'])) { $data = $data['data']; }
$output = '';
if (!is_array($template)) { $template = $this->Parse($template); }
if (isset($data_header)) {
foreach ($data_header as $row) {
$temp = isset($template['header'])?$template['header']:'';
while (list($key, $value) = each($row)) { $temp = preg_replace('/%' . $key . '%/i', $value, $temp); }
$output .= $temp;
}
} else {
$output .= isset($template['header'])?$template['header']:'';
}
if (isset($data)) {
foreach ($data as $row) {
$temp = isset($template['data'])?$template['data']:'';
while (list($key, $value) = each($row)) { $temp = preg_replace('/%' . $key . '%/i', $value, $temp); }
$output .= $temp;
}
}
if (!count($data)) {
$output .= isset($template['nodata'])?$template['nodata']:'';
}
if (isset($data_footer)) {
foreach ($data_footer as $row) {
$temp = isset($template['footer'])?$template['footer']:'';
while (list($key, $value) = each($row)) { $temp = preg_replace('/%' . $key . '%/i', $value, $temp); }
$output .= $temp;
}
} else {
$output .= isset($template['footer'])?$template['footer']:'';
}
return $output;
}
function Generate($data, $sortable = true, $render = true) {
$output = '';
if (!is_array($data) || !count($data)) { return false; }
$db_sort_by = (isset($_GET['db_sort_by']) && is_simple($_GET['db_sort_by']))?$_GET['db_sort_by']:'';
$db_sort_order = (isset($_GET['db_sort_order']) && is_simple($_GET['db_sort_order']))?strtolower($_GET['db_sort_order']):'asc';
if ($db_sort_order == 'asc') { $db_sort_order = 'desc'; } else { $db_sort_order = 'asc'; }
$output .= '<!--{header:start}-->' . str_repeat(PHP_EOL, 2);
$output .= '<table cellspacing="3" cellpadding="2" border="1">' . str_repeat(PHP_EOL, 2);
$output .= '<tr>' . PHP_EOL;
reset($data);
while (list($key, $value) = each($data[0])) {
if ($sortable) {
$output .= '<th>';
$output .= '<a href="' . url_query(array('db_sort_by'=>$key, 'db_sort_order'=>$db_sort_order)) . '">' . $key . '</a>';
if ($db_sort_by == $key && $db_sort_order == 'asc') { $output .= ' <span class="sort_desc">↓</span>'; }
else if ($db_sort_by == $key && $db_sort_order == 'desc') { $output .= ' <span class="sort_asc">↑</span>'; }
$output .= '</th>' . PHP_EOL;
} else { $output .= '<th>' . $key . '</th>' . PHP_EOL; }
}
reset($this->tools);
while (list($key, $value) = each($this->tools)) {
$output .= '<th>' . $value[0] . '</th>' . PHP_EOL;
}
$output .= '</tr>' . str_repeat(PHP_EOL, 2);
$output .= '<!--{header:end}-->' . str_repeat(PHP_EOL, 2);
$output .= '<!--{data:start}-->' . str_repeat(PHP_EOL, 2);
$output .= '<tr>' . PHP_EOL;
reset($data[0]);
while (list($key, $value) = each($data[0])) {
$output .= '<td>%' . strtoupper($key) . '%</td>' . PHP_EOL;
}
reset($this->tools);
while (list($key, $value) = each($this->tools)) {
$output .= '<td class="tools">' . $value[1] . '</td>' . PHP_EOL;
}
$output .= '</tr>' . str_repeat(PHP_EOL, 2);
$output .= '<!--{data:end}-->' . str_repeat(PHP_EOL, 2);
$output .= '<!--{footer:start}-->' . str_repeat(PHP_EOL, 2);
$output .= '</table>' . str_repeat(PHP_EOL, 2);
$output .= '<!--{footer:end}-->';
if ($render) { return $this->Render($output, $data); }
return $output;
}
function Pagination($total_rows = 0, $single_page_display = true) {
$output = '';
if (!$total_rows) { return false; }
$output .= '<p class="pagination">' . PHP_EOL;
$output .= '<strong>Page:</strong> ' . PHP_EOL;
if (is_array($total_rows)) { $total_rows = count($total_rows); }
$db_start = (isset($_GET['db_start']) && is_simple_number($_GET['db_start']))?$_GET['db_start']:0;
$db_limit = (isset($_GET['db_limit']) && is_simple_number($_GET['db_limit']))?$_GET['db_limit']:constant('maxview');
for ($i = 1; $i <= ceil($total_rows / $db_limit); $i++) {
if ($db_start == (($i-1) * $db_limit)) { $output .= '<strong>'; }
$output .= '<a href="' . constant('page') . '' . url_query(array('db_start'=>(($i-1) * $db_limit))) . '">' . $i . '</a> ';
if ($db_start == (($i-1) * $db_limit)) { $output .= '</strong> '; }
$output .= PHP_EOL;
}
$output .= '</p>' . str_repeat(PHP_EOL, 2);
if (!$single_page_display && $total_rows <= constant('maxview')) { return false; }
return $output;
}
function Form($database, $table, $data = array(), $fields = array(), $autoformat = true) {
global $DB;
$output = '';
if (!is_array($fields)) { $fields = array_clean(explode(',', $fields)); }
$columns = $DB->Query('SHOW COLUMNS FROM `' . $database . '`.`' . $table . '`', $DB->resource, 'resource', false);
while ($row = @mysql_fetch_assoc($columns)) {
if ($row['Key'] == 'PRI') { array_unshift($fields, $row); }
else if (!@func_get_arg(3)) { $fields[] = $row; }
else if (in_array($row['Field'], $fields)) { $fields[array_search($row['Field'], $fields)] = $row; }
}
$action = str_replace('&', '&', substr($_SERVER['REQUEST_URI'], strrpos($_SERVER['REQUEST_URI'], '/') +1));
$output .= '<form action="' . $action . '" method="post">' . str_repeat(PHP_EOL, 2);
$output .= '<fieldset>' . str_repeat(PHP_EOL, 2);
foreach ($fields as $field) {
if (!is_array($field)) { continue; }
preg_match('/([a-z]+)(?:(?:\()(.*)(?:\)))?/si', $field['Type'], $type);
if (count($data) && isset($data[0][$field['Field']])) { $value = $data[0][$field['Field']]; }
else { $value = isset($field['Default'])?$field['Default']:''; }
if ($field['Key'] != 'PRI') {
$output .= '<label for="inpt_' . $field['Field'] . '">' . ucwords(str_replace('_', ' ', $field['Field'])) . ':</label> ' . PHP_EOL;
if ($autoformat && in_array($type[1], array('tinyblob', 'blob', 'mediumblob', 'longblob', 'tinytext', 'text', 'mediumtext', 'longtext'))) {
$output .= '<textarea name="' . $field['Field'] . '" id="inpt_' . $field['Field'] . '" cols="40" rows="5">' . htmlspecialchars($value) . '</textarea><br />' . str_repeat(PHP_EOL, 2);
} else if ($autoformat && $type[1] == 'tinyint' && $type[2] == 1) {
$output .= '<select name="' . $field['Field'] . '" id="inpt_' . $field['Field'] . '">' . PHP_EOL;
$output .= '<option value="1"' . ($value?' selected="selected"':'') . '>True</option>' . PHP_EOL;
$output .= '<option value="0"' . (!$value?' selected="selected"':'') . '>False</option>' . PHP_EOL;
$output .= '</select><br />' . str_repeat(PHP_EOL, 2);
} else if ($autoformat && in_array($type[1], array('enum', 'set')) && isset($type[2])) {
preg_match_all('/\'(.*)\'/U', $type[2], $matches);
$output .= '<select name="' . $field['Field'] . '" id="inpt_' . $field['Field'] . '">' . PHP_EOL;
foreach ($matches[1] as $option) {
$output .= '<option value="' . $option . '"' . ($value==$option?' selected="selected"':'') . '>' . $option . '</option>' . PHP_EOL;
}
$output .= '</select><br />' . str_repeat(PHP_EOL, 2);
} else {
$output .= '<input name="' . $field['Field'] . '" id="inpt_' . $field['Field'] . '" type="text" value="' . htmlspecialchars($value) . '" size="40" /><br />' . str_repeat(PHP_EOL, 2);
}
} else {
$output .= '<input name="' . $field['Field'] . '" type="hidden" value="' . ($value?$value:0) . '" />' . str_repeat(PHP_EOL, 2);
$primary_key = array('name'=>$field['Field'], 'value'=>$value);
}
}
$output .= '<label> </label>' . PHP_EOL;
if (isset($primary_key['value']) && $primary_key['value'] != 0) { $output .= '<button type="submit">Save</button> '; }
else { $output .= '<button type="submit">Add</button> '; }
$output .= '<button type="reset">Reset</button>' . str_repeat(PHP_EOL, 2);
$output .= '</fieldset>' . str_repeat(PHP_EOL, 2);
$output .= '</form>' . str_repeat(PHP_EOL, 2);
return $output;
}
}
###############################################################
$Template = new Template;
###############################################################
?>