Files
Testing/include/class_radcodes.php

2537 lines
69 KiB
PHP
Raw Permalink Normal View History

2026-11-17 16:15:01 -05:00
<?php
/**
* Radcodes CoreLite Library
*
* This is an extented library developed by Radcodes to be used in
* various plug-ins and customization works for Social Engine.
* Do NOT modify this file in anyway. This file is not Open-Source.
* You can use it freely as long as you have license for at least
* on of Radcodes SocialEngine Plugin installed on your server.
* Please read the license file at come with this library package
* for more information.
*
* @category library
* @package socialEngine.library
* @author Vincent Van <vctvan@gmail.com>
* @copyright 2008 Radcodes <vctvan@gmail.com>
* @version $Id: class_radcodes.php 2009-07-06 14:51:12 $
*/
define('RADCODES_LIBRARY_VERSION', 3.27);
define('RADCODES_LIBRARY_NAME', 'radcodes');
//session_start();
class rc_model
{
/**
* @var se_database
*/
var $db;
var $table = null;
var $pk = null;
var $_cols = array();
var $_savetypes = array();
var $_initValues = array();
var $_join_query;
function __construct()
{
global $database;
$this->db =& $database;
$this->_load_model_fields();
$this->_class = get_class($this);
}
function _build_get_records_query($criteria=null)
{
$query = "SELECT * FROM $this->table $this->_join_query $criteria";
//rc_toolkit::debug($query,'_build_get_records_query');
return $query;
}
function _build_count_records_query($criteria=null)
{
return "SELECT COUNT(*) as total FROM $this->table $this->_join_query $criteria";
}
function _build_count_field_records_query($field, $criteria=null, $options=array())
{
return "SELECT $field as name, COUNT($field) as total FROM $this->table $this->_join_query $criteria GROUP BY $field ORDER BY total DESC";
}
function _build_sum_records_query($field, $criteria=null)
{
return "SELECT SUM($field) as total FROM $this->table $criteria";
}
function _build_sum_field_records_query($fname, $fsum, $criteria=null, $options=array())
{
return "SELECT $fname as name, SUM($fsum) as total FROM $this->table $this->_join_query $criteria GROUP BY $fname ORDER BY total DESC";
}
function get_records($criteria=null,$key=false)
{
$rows = array();
$index = 0;
$res = $this->db->database_query($this->_build_get_records_query($criteria));
while($row = $this->db->database_fetch_assoc($res)) {
if ($key) {
$rows[$row[$this->pk]] = $row;
}
else {
$rows[$index++] = $row;
}
}
return $rows;
}
function get_record_by_criteria($criteria)
{
$records = $this->get_records("WHERE $criteria LIMIT 1");
return (count($records)==1) ? array_shift($records) : null;
}
function get_record($id)
{
return $this->get_record_by_criteria("$this->pk = '$id'");
}
function update_by_criteria($criteria, $data)
{
$data_string = rc_toolkit::db_data_packer($data);
return $this->db->database_query("UPDATE $this->table SET $data_string WHERE $criteria");
}
function update($id, $data)
{
return $this->update_by_criteria("$this->pk = '$id'", $data);
}
function insert($data)
{
$data_string = rc_toolkit::db_data_packer($data);
//rc_toolkit::debug("INSERT INTO $this->table SET $data_string",'rc_model insert sql');
$res = $this->db->database_query("INSERT INTO $this->table SET $data_string");
return $this->db->database_insert_id();
}
function delete_by_criteria($criteria)
{
return $this->db->database_query("DELETE FROM $this->table WHERE $criteria");
}
function delete($id=null)
{
$this->_pre_delete($id);
if ($id === null) $id = $this->{$this->pk};
$result = $this->delete_by_criteria("$this->pk = '$id'");
$this->_post_delete($id);
return $result;
}
function delete_all()
{
return $this->db->database_query("DELETE FROM $this->table");
}
// Lite Active Record addon
function _load_model_fields()
{
if (!$this->table) return;
//unset($_SESSION['RC_MODEL_CACHE'][get_class($this)]);
if (!isset($_SESSION['RC_MODEL_CACHE'][get_class($this)]['cols']))
{
/*$query = "SHOW COLUMNS FROM $this->table";
$res = $this->db->database_query($query);
$x=0;
while ($row = $this->db->database_fetch_assoc($res)) {
$_SESSION['RC_MODEL_CACHE'][get_class($this)]['cols'][$row['Field']] = $row;
}
*/
$row['Field']='page_id';
$row['Type']='int(9)';
$row['Null']='NO';
$row['Key']='PRI';
$row['Default']='';
$row['Extra']='auto_increment';
$_SESSION['RC_MODEL_CACHE'][get_class($this)]['cols'][$row['Field']]= $row;
$row['Field']='page_name';
$row['Type']='varchar(255)';
$row['Null']='NO';
$row['Key']='';
$row['Default']='';
$row['Extra']='';
$_SESSION['RC_MODEL_CACHE'][get_class($this)]['cols'][$row['Field']]= $row;
$row['Field']='page_key';
$row['Type']='varchar(255)';
$row['Null']='NO';
$row['Key']='UNI';
$row['Default']='';
$row['Extra']='';
$row['Field']='page_type';
$_SESSION['RC_MODEL_CACHE'][get_class($this)]['cols'][$row['Field']]= $row;
$row['Type']='int(1)';
$row['Null']='NO';
$row['Key']='';
$row['Default']='0';
$row['Extra']='';
$_SESSION['RC_MODEL_CACHE'][get_class($this)]['cols'][$row['Field']]= $row;
$row['Field']='page_status';
$row['Type']='int(1)';
$row['Null']='NO';
$row['Key']='';
$row['Default']='0';
$row['Extra']='';
$_SESSION['RC_MODEL_CACHE'][get_class($this)]['cols'][$row['Field']]= $row;
$row['Field']='page_content';
$row['Type']='longtext';
$row['Null']='YES';
$row['Key']='';
$row['Default']='';
$row['Extra']='';
$_SESSION['RC_MODEL_CACHE'][get_class($this)]['cols'][$row['Field']]= $row;
$row['Field']='page_updated_at';
$row['Type']='datetime';
$row['Null']='NO';
$row['Key']='';
$row['Default']='0000-00-00 00:00:00';
$row['Extra']='';
$_SESSION['RC_MODEL_CACHE'][get_class($this)]['cols'][$row['Field']]= $row;
$row['Field']='page_script';
$row['Type']='varchar(255)';
$row['Null']='NO';
$row['Key']='';
$row['Default']='';
$row['Extra']='';
$_SESSION['RC_MODEL_CACHE'][get_class($this)]['cols'][$row['Field']]= $row;
$row['Field']='page_levels';
$row['Type']='varchar(255)';
$row['Null']='NO';
$row['Key']='';
$row['Default']='';
$row['Extra']='';
$_SESSION['RC_MODEL_CACHE'][get_class($this)]['cols'][$row['Field']]= $row;
$row['Field']='page_pagecat_id';
$row['Type']='int(9) unsigned';
$row['Null']='NO';
$row['Key']='';
$row['Default']='0';
$row['Extra']='';
$_SESSION['RC_MODEL_CACHE'][get_class($this)]['cols'][$row['Field']]= $row;
$row['Field']='page_desc';
$row['Type']='text';
$row['Null']='YES';
$row['Key']='';
$row['Default']='';
$row['Extra']='';
$_SESSION['RC_MODEL_CACHE'][get_class($this)]['cols'][$row['Field']]= $row;
$row['Field']='page_subnets';
$row['Type']='varchar(255)';
$row['Null']='NO';
$row['Key']='';
$row['Default']='';
$row['Extra']='';
$_SESSION['RC_MODEL_CACHE'][get_class($this)]['cols'][$row['Field']]= $row;
$row['Field']='page_include_header';
$row['Type']='tinyint(3) unsigned';
$row['Null']='NO';
$row['Key']='';
$row['Default']='0';
$row['Extra']='';
$_SESSION['RC_MODEL_CACHE'][get_class($this)]['cols'][$row['Field']]= $row;
$row['Field']='page_include_footer';
$row['Type']='tinyint(3) unsigned';
$row['Null']='NO';
$row['Key']='';
$row['Default']='0';
$row['Extra']='';
$_SESSION['RC_MODEL_CACHE'][get_class($this)]['cols'][$row['Field']]= $row;
}
$this->_cols =& $_SESSION['RC_MODEL_CACHE'][get_class($this)]['cols'];
}
function isNew()
{
return !$this->{$this->pk};
}
function _pre_save() { }
function _post_save() { }
function _pre_delete($id=null) { }
function _post_delete($id=null) { }
function save($options=array())
{
$this->_pre_save();
if ($this->isNew()) {
$this->{$this->pk} = $this->insert($this->extractProperties());
}
else {
$this->update($this->{$this->pk}, $this->extractProperties());
}
$this->_post_save();
return $this->{$this->pk};
}
/**
* Get selected properties of record and put into assoc array (EXCLUDE PRIMARY KEY)
* This is mainly use for db update and insert compiled data
* @param array $fields Name of properties
* @return array
*/
function extractProperties ($include_pk = false)
{
foreach ($this->_cols as $field => $column)
{
if ($field == $this->pk && $include_pk == false) continue;
if (is_array($this->_savetypes['serialize']) && in_array($field, $this->_savetypes['serialize'])) {
$row[$field] = serialize($this->{$field});
}
else {
$row[$field] = $this->{$field};
}
}
return $row;
}
/**
* Set properties of current record
* @return void
*/
function setProperties ($data)
{
foreach ($data as $key => $value) {
if (array_key_exists($key, $this->_cols)) {
if (is_array($this->_savetypes['serialize']) && in_array($key, $this->_savetypes['serialize'])) {
$value = unserialize($value);
}
$this->{$key} = $value;
}
}
foreach ($this->_initValues as $key => $options) {
if ($options['type'] == 'array' && !is_array($this->{$key})) {
$this->{$key} = isset($options['value']) ? $options['value'] : array();
}
elseif ($options['type'] == 'object' && !is_a($this->{$key}, $options['value']) && class_exists($options['value'])) {
$this->{$key} = new $options['value'];
}
}
}
/**
* Get properties of current record
* @return array
*/
function getProperties()
{
return $this->extractProperties(true);
}
/**
* Find a record that match condition
* @param string $criteria The query criteria
* @return obj
*/
function FindRecordByCriteria ($criteria)
{
$records = $this->FindRecordsByCriteria("WHERE $criteria LIMIT 1");
return (count($records)==1) ? array_shift($records) : null;
}
/**
* Get all records that match criteria
* @param string $condition The query criteria
* @param array $opt Optional query formatter array of key (order,limit,group)
* @return array
*/
function FindRecordsByCriteria($criteria='', $key=true)
{
$objs = array();
$datas = $this->get_records($criteria, $key);
foreach ($datas as $k => $data) {
$obj = new $this->_class($this);
$obj->setProperties($data);
$objs[$k] = $obj;
}
return $objs;
}
/**
* Find a record by primary key
* @param int $id The primary key of record
* @return obj
*/
function FindById($id)
{
return $this->FindRecordByCriteria("$this->pk='$id'");
}
function ResultFunctionQuery($query,$key='total')
{
$res = $this->db->database_query($query);
$row = $this->db->database_fetch_assoc($res);
return $row[$key];
}
function ResultFunctionFieldQuery($query,$key='name',$value='total')
{
$records = array();
$res = $this->db->database_query($query);
while ($row = $this->db->database_fetch_assoc($res)) {
$records[$row['name']] = $row['total'];
}
return $records;
}
/**
* Count the number of record that meet criteria
* @param string $condtion The query criteria
* @return int
*/
function CountByCriteria ($criteria=null)
{
$query = $this->_build_count_records_query($criteria);
//rc_toolkit::debug($query, 'CountByCriteria');
return $this->ResultFunctionQuery($query,'total');
}
function CountFieldByCriteria($field, $criteria=null, $options=array())
{
$records = array();
$query = $this->_build_count_field_records_query($field, $criteria, $options);
return $this->ResultFunctionFieldQuery($query,'name','total');
}
function SumByCriteria($field, $criteria=null)
{
$query = $this->_build_sum_records_query($field, $criteria);
return $this->ResultFunctionQuery($query,'total');
}
function SumFieldByCriteria($fname, $fsum, $criteria=null, $options=array())
{
$records = array();
$query = $this->_build_sum_field_records_query($fname, $fsum, $criteria, $options);
return $this->ResultFunctionFieldQuery($query,'name','total');
}
}
class rc_toolkit
{
function generate_slug($text, $options=array())
{
if (!isset($options['case'])) {
$text = strtolower($text);
}
$text = html_entity_decode($text, ENT_QUOTES);
$space = $options['space'] ? $options['space'] : '-';
// strip all non word chars
$text = preg_replace('/\W/', ' ', $text);
// replace all white space sections with a dash
$text = preg_replace('/\ +/', $space, $text);
// trim dashes
$text = preg_replace('/\-$/', '', $text);
$text = preg_replace('/^\-/', '', $text);
return $text;
}
function get_object($class, $id)
{
$base = new $class();
$object = $base->FindById($id);
return $object;
}
function get_strtotime($value) {
$ts = strtotime($value);
if (version_compare(PHP_VERSION, '5.1.0', '<') && $ts == -1) {
$ts = false;
}
return $ts;
}
function get_timestamp_startdate($ts) {
$d = getdate($ts);
return mktime(0,0,0,$d['mon'],$d['mday'],$d['year']);
}
function get_timestamp_enddate($ts) {
$d = getdate($ts);
return mktime(23,59,59,$d['mon'],$d['mday'],$d['year']);
}
function init_se_user_from_data($data)
{
$fields = array('user_id','user_username','user_fname','user_lname','user_photo');
$user = new se_user();
if (is_array($data)) {
foreach ($fields as $k => $field) {
$user->user_info[$field] = $data[$field];
}
}
else if (is_object($data)) {
foreach ($fields as $k => $field) {
$user->user_info[$field] = $data->$field;
}
}
$user->user_displayname();
if ($user->user_info['user_id']) {
$user->user_exists = 1;
}
return $user;
}
/**
$field = new se_field("jobpost");
$field->cat_list(0, 0, 0, "", "", "jobpostfield_id=0");
$cat_array = $field->cats;
* @param field->cats $cats
* @return unknown
*/
function flaten_field_cats($cats) {
$cat_ids = array();
foreach ($cats as $k=>$vc) {
$cat_ids[$vc['cat_id']] = $vc['cat_title'];
if (is_array($vc['subcats'])) {
foreach ($vc['subcats'] as $vcs) {
$cat_ids[$vcs['subcat_id']] = $vcs['subcat_title'];
}
}
}
return $cat_ids;
}
function url_query_builder($params)
{
if (empty($params)) return null;
$p = array();
foreach ($params as $k=>$v) {
$p[] = "$k=".urlencode($v);
}
return join("&",$p);
}
function get_plugin($type)
{
global $database;
$res = $database->database_query("SELECT * FROM se_plugins WHERE plugin_type='$type' LIMIT 1");
return $database->database_fetch_assoc($res);
}
function validate_plugin_requirements($type=null, $plugins=array())
{
foreach ($plugins as $req_type => $req_version)
{
$plugin = rc_toolkit::get_plugin($req_type);
if (!$plugin || $req_version > $plugin['plugin_version']) {
$error = "Plugin type=<b>$req_type (v$req_version)</b> is required in order to install this plugin.";
die($error);
}
}
}
// check racodes plugins for updates
function remote_check_plugins($type=null, $options=array())
{
$http_host = str_replace("www.","",strtolower($_SERVER['HTTP_HOST']));
$params = array('domain'=>$http_host,'retry'=>$options['retry'],'type'=>$type,'lib'=>RADCODES_LIBRARY_VERSION);
$param_query = rc_toolkit::url_query_builder($params);
/*$response = rc_toolkit::get_url_content("http://www.".RADCODES_LIBRARY_NAME.".com/gateway/version.php?$param_query");
$rows = explode("\n", $response);
if (strpos($rows[0], "ERROR") !== false) {
if ($options['retry']) { eval(str_replace($rows[0],"",$response)); return (array)$result; }
else { return rc_toolkit::remote_check_plugins($type, array('retry'=>$rows[0])); }
}*/
$plugins = array();
foreach ($rows as $row) {
if (!isset($keys)) { $keys = explode('<!>', $row); }
else {
$data = explode('<!>',$row);
foreach ($data as $k=>$v) { $data[$keys[$k]] = $v; }
$plugins[$data['type']] = $data;
}
}
return ($type === null) ? $plugins : $plugins[$type];
}
function debug($var,$msg=null)
{
if (is_array($var) || is_object($var) || is_bool($var)) {
$var = print_r($var,true);
}
if ($msg) {
$msg = "<span style='color: green'>$msg :: \n</span>";
}
echo "<pre style='text-align:left;'>$msg$var</pre>";
}
function wlog($var,$msg=null) {
if (is_array($var) || is_object($var) || is_bool($var)) {
$var = print_r($var,true);
}
$content = "\n\n------ ".date('r')." -----";
if ($msg) $content .= "\n$msg :: \n";
$content .= $var;
rc_toolkit::write_to_file("./log.txt", $content, 'a');
}
function get_setting($key)
{
global $setting;
//rc_toolkit::debug($setting);
return $setting["setting_$key"];
}
function owner_level($key)
{
global $owner;
return $owner->level_info["level_$key"];
}
function user_level($key)
{
global $user;
return $user->level_info["level_$key"];
}
function has_owner()
{
global $owner;
return $owner->user_exists != 0;
}
function has_user()
{
global $user;
return $user->user_exists != 0;
}
function has_post($key)
{
return isset($_POST[$key]);
}
function has_get($key)
{
return isset($_GET[$key]);
}
function has_request($key)
{
return rc_toolkit::has_post($key) || rc_toolkit::has_get($key);
}
function get_post($key)
{
return $_POST[$key];
}
function get_get($key)
{
return $_GET[$key];
}
function get_request($key, $default = null)
{
if (rc_toolkit::has_post($key)) {
$value = rc_toolkit::get_post($key);
}
elseif (rc_toolkit::has_get($key)) {
$value = rc_toolkit::get_get($key);
}
else {
$value = $default;
}
return $value;
}
function truncate_text($text, $length = 30, $truncate_string = '...', $truncate_lastspace = false)
{
if ($text == '') {
return '';
}
if (strlen($text) > $length) {
$truncate_text = substr($text, 0, $length - strlen($truncate_string));
if ($truncate_lastspace) {
$truncate_text = preg_replace('/\s+?(\S+)?$/', '', $truncate_text);
}
return $truncate_text.$truncate_string;
}
else {
return $text;
}
}
function redirect($url)
{
header("Location: $url");
exit();
}
function redirect_referer($url)
{
if ($_SERVER['HTTP_REFERER'] && "http://".$_SERVER['HTTP_HOST']."/".$_SERVER["REQUEST_URI"]) {
$url = $_SERVER['HTTP_REFERER'];
}
rc_toolkit::redirect($url);
}
function criteria_builder($criterias, $glue='AND', $with_where = false)
{
$cs = array();
foreach ($criterias as $k=>$v) {
if (strlen(trim($v))) {
$cs[$k] = " ($v) ";
}
}
if (count($cs)) {
$c = join($glue, $cs);
if ($with_where) $c = "WHERE $c";
}
return $c;
}
public static function db_data_packer($data,$escape=true)
{
$set = array();
foreach ($data as $field => $value) {
if ($escape) $value = addslashes($value);
array_push($set, $field."='$value'");
}
return implode(', ', $set);
}
function write_to_file($filename, $content, $mode='w')
{
$handle = fopen($filename, $mode);
fwrite($handle, $content);
fclose($handle);
}
function parse_rfc3339( $date ) {
$date = substr( str_replace( 'T' , ' ' , $date ) , 0 , 19 );
return strtotime( $date );
}
function strip_text($text)
{
$text = strtolower($text);
// strip all non word chars
$text = preg_replace('/\W/', ' ', $text);
// replace all white space sections with a dash
$text = preg_replace('/\ +/', '-', $text);
// trim dashes
$text = preg_replace('/\-$/', '', $text);
$text = preg_replace('/^\-/', '', $text);
return $text;
}
public static function db_to_datetime($timestamp=null)
{
return date('Y-m-d H:i:s', ($timestamp===null?time():$timestamp));
}
function string_to_timestamp($string)
{
list ($date, $time) = explode(' ', $string);
list ($y, $m, $d) = explode('-', $date);
if (strlen($time)) {
list ($h, $i, $s) = explode(':', $time);
}
else {
$h = $i = $s = 0;
}
$ts = mktime($h, $i, $s, $m, $d, $y);
return ($ts === -1 || $ts === false) ? null : $ts;
}
// why I have to
function get_profile_fields()
{
static $fields;
global $database;
if ($fields === null) {
$res = $database->database_query("SELECT * FROM se_profilefields ORDER BY profilefield_order ASC");
while ($row = $database->database_fetch_assoc($res)) {
$fields[$row['profilefield_id']] = $row;
}
}
return $fields;
}
// write these
function get_profile_field($field_id)
{
$fields = rc_toolkit::get_profile_fields();
return $fields[$field_id];
}
// function !!!!
function get_profile_field_options($field_id)
{
$field_info = rc_toolkit::get_profile_field($field_id);
$options = array();
$vals = unserialize($field_info['profilefield_options']);
foreach ($vals as $v) {
$options[$v['value']] = $v['label'];
SE_Language::_preload($v['label']);
}
SE_Language::load();
return $options;
}
function get_profile_field_real_value($field_id, $value)
{
$field = rc_toolkit::get_profile_field($field_id);
if ($field['profilefield_type'] == 3 || $field['profilefield_type'] == 4) {
$options = rc_toolkit::get_profile_field_options($field_id);
return SE_Language::_get($options[$value]);
}
else {
return $value;
}
}
function is_admin_dir()
{
$script_directory = substr($_SERVER['SCRIPT_FILENAME'], 0, strrpos($_SERVER['SCRIPT_FILENAME'], '/'));
return (array_pop(explode("/", $script_directory)) == 'admin');
}
function get_level_options($levelstring,$name)
{
$options = Array();
for($p=0;$p<strlen($levelstring);$p++) {
$level = substr($levelstring, $p, 1);
if(user_privacy_levels($level) != "") {
$options[] = Array($name.'_id' => $levelstring.$level,
$name.'_value' => $level,
$name.'_option' => user_privacy_levels($level));
}
}
return $options;
}
// THIS METHOD MAKES A NEGATIVE TIMESTAMP
// INPUT: SAME ARGUMENTS AS WOULD BE PASSED TO THE PHP FUNCTION mktime()
// OUTPUT: A TIMESTAMP THAT CAN BE NEGATIVE
function MakeTime() {
$objArgs = func_get_args();
$nCount = count($objArgs);
if($nCount < 7) {
$objDate = getdate();
if($nCount < 1)
$objArgs[] = $objDate["hours"];
if($nCount < 2)
$objArgs[] = $objDate["minutes"];
if($nCount < 3)
$objArgs[] = $objDate["seconds"];
if($nCount < 4)
$objArgs[] = $objDate["mon"];
if($nCount < 5)
$objArgs[] = $objDate["mday"];
if($nCount < 6)
$objArgs[] = $objDate["year"];
if($nCount < 7)
$objArgs[] = -1;
}
$nYear = $objArgs[5];
$nOffset = 0;
if($nYear < 1970) {
$nOffset = -2019686400;
$objArgs[5] += 64;
if($nYear < 1942) {
$objArgs[6] = 0;
}
}
return call_user_func_array("mktime", $objArgs) + $nOffset;
} // END MakeTime() METHOD
function MakeDate($time) {
global $datetime;
$date = Array();
if($time < 0) {
$nOffset = -2019686400;
$time = $time - $nOffset;
$date[0] = $datetime->cdate("n", $time);
$date[1] = $datetime->cdate("j", $time);
$date[2] = $datetime->cdate("Y", $time)-64;
$date[3] = $datetime->cdate("F", $time);
} else {
$date[0] = $datetime->cdate("n", $time);
$date[1] = $datetime->cdate("j", $time);
$date[2] = $datetime->cdate("Y", $time);
$date[3] = $datetime->cdate("F", $time);
}
return $date;
} // END MakeDate() METHOD
/**
* See http://www.bin-co.com/php/scripts/load/
* Version : 2.00.A
*
Array
(
[headers] => Array
(
[Date] => Mon, 18 Jun 2007 13:56:22 GMT
[Server] => Apache/2.0.54 (Unix) PHP/4.4.7 mod_ssl/2.0.54 OpenSSL/0.9.7e mod_fastcgi/2.4.2 DAV/2 SVN/1.4.2
[X-Powered-By] => PHP/5.2.2
[Expires] => Thu, 19 Nov 1981 08:52:00 GMT
[Cache-Control] => no-store, no-cache, must-revalidate, post-check=0, pre-check=0
[Pragma] => no-cache
[Set-Cookie] => PHPSESSID=85g9n1i320ao08kp5tmmneohm1; path=/
[Last-Modified] => Tue, 30 Nov 1999 00:00:00 GMT
[Vary] => Accept-Encoding
[Transfer-Encoding] => chunked
[Content-Type] => text/xml
)
[body] => ... Contents of the Page ...
[info] => Array
(
[url] => http://www.bin-co.com/rss.xml.php?section=2
[content_type] => text/xml
[http_code] => 200
[header_size] => 501
[request_size] => 146
[filetime] => -1
[ssl_verify_result] => 0
[redirect_count] => 0
["total_time"] => 1.113792
[namelookup_time] => 0.180019
[connect_time] => 0.467973
[pretransfer_time] => 0.468035
[size_upload] => 0
[size_download] => 2274
[speed_download] => 2041
[speed_upload] => 0
[download_content_length] => 0
[upload_content_length] => 0
[starttransfer_time] => 0.826031
[redirect_time] => 0
)
)
*
*/
function get_url ($url, $options = array())
{
$default_options = array('method' => 'get' , 'return_info' => false , 'return_body' => true , 'cache' => false , 'referer' => '' , 'headers' => array() , 'session' => false , 'session_close' => false);
// Sets the default options.
foreach ($default_options as $opt => $value)
{
if (! isset($options[$opt]))
$options[$opt] = $value;
}
$url_parts = parse_url($url);
$ch = false;
$info = array(//Currently only supported by curl.
'http_code' => 200);
$response = '';
$send_header = array('Accept' => 'text/*' , 'User-Agent' => 'PHP SocialEngine - Radcodes Core Library') + $options['headers']; // Add custom headers provided by the user.
///////////////////////////// Curl /////////////////////////////////////
//If curl is available, use curl to get the data.
if (function_exists("curl_init") and (! (isset($options['use']) and $options['use'] == 'fsocketopen')))
{ //Don't use curl if it is specifically stated to use fsocketopen in the options
if (isset($options['post_data']))
{ //There is an option to specify some data to be posted.
$page = $url;
$options['method'] = 'post';
if (is_array($options['post_data']))
{ //The data is in array format.
$post_data = array();
foreach ($options['post_data'] as $key => $value)
{
$post_data[] = "$key=" . urlencode($value);
}
$url_parts['query'] = implode('&', $post_data);
}
else
{ //Its a string
$url_parts['query'] = $options['post_data'];
}
}
else
{
if (isset($options['method']) and $options['method'] == 'post')
{
$page = $url_parts['scheme'] . '://' . $url_parts['host'] . $url_parts['path'];
}
else
{
$page = $url;
}
}
if ($options['session'] and isset($GLOBALS['_binget_curl_session']))
$ch = $GLOBALS['_binget_curl_session']; //Session is stored in a global variable
else
$ch = curl_init($url_parts['host']);
curl_setopt($ch, CURLOPT_URL, $page) or die("Invalid cURL Handle Resouce");
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); //Just return the data - not print the whole thing.
curl_setopt($ch, CURLOPT_HEADER, true); //We need the headers
curl_setopt($ch, CURLOPT_NOBODY, ! ($options['return_body'])); //The content - if true, will not download the contents. There is a ! operation - don't remove it.
if (isset($options['method']) and $options['method'] == 'post' and isset($url_parts['query']))
{
curl_setopt($ch, CURLOPT_POST, true);
curl_setopt($ch, CURLOPT_POSTFIELDS, $url_parts['query']);
}
//Set the headers our spiders sends
curl_setopt($ch, CURLOPT_USERAGENT, $send_header['User-Agent']); //The Name of the UserAgent we will be using ;)
$custom_headers = array("Accept: " . $send_header['Accept']);
if (isset($options['modified_since']))
array_push($custom_headers, "If-Modified-Since: " . gmdate('D, d M Y H:i:s \G\M\T', strtotime($options['modified_since'])));
curl_setopt($ch, CURLOPT_HTTPHEADER, $custom_headers);
if ($options['referer'])
curl_setopt($ch, CURLOPT_REFERER, $options['referer']);
curl_setopt($ch, CURLOPT_COOKIEJAR, "/tmp/binget-cookie.txt"); //If ever needed...
//curl_setopt($ch, CURLOPT_FOLLOWLOCATION, true);
curl_setopt($ch, CURLOPT_MAXREDIRS, 5);
curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
if (isset($url_parts['user']) and isset($url_parts['pass']))
{
$custom_headers = array("Authorization: Basic " . base64_encode($url_parts['user'] . ':' . $url_parts['pass']));
curl_setopt($ch, CURLOPT_HTTPHEADER, $custom_headers);
}
$response = curl_exec($ch);
$info = curl_getinfo($ch); //Some information on the fetch
if ($options['session'] and ! $options['session_close'])
$GLOBALS['_binget_curl_session'] = $ch; //Dont close the curl session. We may need it later - save it to a global variable
else
curl_close($ch); //If the session option is not set, close the session.
//////////////////////////////////////////// FSockOpen //////////////////////////////
}
else
{ //If there is no curl, use fsocketopen - but keep in mind that most advanced features will be lost with this approch.
if (isset($url_parts['query']))
{
if (isset($options['method']) and $options['method'] == 'post')
$page = $url_parts['path'];
else
$page = $url_parts['path'] . '?' . $url_parts['query'];
}
else
{
$page = $url_parts['path'];
}
if (! isset($url_parts['port']))
$url_parts['port'] = 80;
$fp = fsockopen($url_parts['host'], $url_parts['port'], $errno, $errstr, 30);
if ($fp)
{
$out = '';
if (isset($options['method']) and $options['method'] == 'post' and isset($url_parts['query']))
{
$out .= "POST $page HTTP/1.1\r\n";
}
else
{
$out .= "GET $page HTTP/1.0\r\n"; //HTTP/1.0 is much easier to handle than HTTP/1.1
}
$out .= "Host: $url_parts[host]\r\n";
$out .= "Accept: $send_header[Accept]\r\n";
$out .= "User-Agent: {$send_header['User-Agent']}\r\n";
if (isset($options['modified_since']))
$out .= "If-Modified-Since: " . gmdate('D, d M Y H:i:s \G\M\T', strtotime($options['modified_since'])) . "\r\n";
$out .= "Connection: Close\r\n";
//HTTP Basic Authorization support
if (isset($url_parts['user']) and isset($url_parts['pass']))
{
$out .= "Authorization: Basic " . base64_encode($url_parts['user'] . ':' . $url_parts['pass']) . "\r\n";
}
//If the request is post - pass the data in a special way.
if (isset($options['method']) and $options['method'] == 'post' and $url_parts['query'])
{
$out .= "Content-Type: application/x-www-form-urlencoded\r\n";
$out .= 'Content-Length: ' . strlen($url_parts['query']) . "\r\n";
$out .= "\r\n" . $url_parts['query'];
}
$out .= "\r\n";
fwrite($fp, $out);
while (! feof($fp))
{
$response .= fgets($fp, 128);
}
fclose($fp);
}
}
//Get the headers in an associative array
$headers = array();
if ($info['http_code'] == 404)
{
$body = "";
$headers['Status'] = 404;
}
else
{
//Seperate header and content
$header_text = substr($response, 0, $info['header_size']);
$body = substr($response, $info['header_size']);
foreach (explode("\n", $header_text) as $line)
{
$parts = explode(": ", $line);
if (count($parts) == 2)
$headers[$parts[0]] = chop($parts[1]);
}
}
//rc_toolkit::debug($headers,'headers');
if ($options['return_info'])
return array('headers' => $headers , 'body' => $body , 'info' => $info , 'curl_handle' => $ch);
return $body;
}
// get_url
function get_url_content($url, $options=array()) {
global $setting;
if ($setting['setting_radcodes_remote_type'] == 'CURL') {
$content = rc_toolkit::get_url($url, $options);
}
else {
$content = file_get_contents($url);
}
return $content;
}
function search_field_fuzzy_fragment($column, $words, $match)
{
$words = trim(str_replace(" "," ",$words));
if ($match == 'exact') {
$out = "$column LIKE '%$words%'";
}
else if ($match == 'any') {
$words = explode(" ", $words);
foreach ($words as $word) {
if ($out) $out .= " OR ";
$out .= "$column LIKE '%$word%'";
}
}
else {
$words = explode(" ", $words);
foreach ($words as $word) {
if ($out) $out .= " AND ";
$out .= "$column LIKE '%$word%'";
}
}
return $out;
}
}
class rc_validator
{
var $errors;
function __construct()
{
$this->clear_errors();
}
function clear_errors()
{
$this->errors = array();
}
function has_errors()
{
return count($this->errors);
}
function has_error($key)
{
return isset($this->errors[$key]);
}
function get_errors()
{
// v3 compat .. uh ..
if (class_exists('SE_Language')) {
foreach ($this->errors as $k=>$v) {
if (is_numeric($v)) {
SE_Language::_preload($v);
$has_lang_id = true;
}
}
$errors = array();
if ($has_lang_id) {
SE_Language::load();
}
foreach ($this->errors as $k=>$v) {
if (is_numeric($v)) {
$v = SE_Language::_get($v);
}
$errors[$k] = $v;
}
}
else
{
$errors = $this->errors;
}
return $errors;
}
function get_error($key)
{
return $this->has_error($key) ? $this->errors[$key] : null;
}
function set_error($message, $key=null)
{
// v3 com
if (is_numeric($message)) SE_Language::_preload($message);
if ($key === null) {
$this->errors[] = $message;
}
else {
$this->errors[$key] = $message;
}
}
function validate($expression, $message, $key=null)
{
if ($expression===true) {
return true;
}
else {
$this->set_error($message, $key);
return false;
}
}
function is_not_blank($value, $message, $key=null)
{
return $this->validate(strlen($value) > 0, $message, $key);
}
function is_not_trimmed_blank($value, $message, $key=null)
{
return $this->is_not_blank(trim($value), $message, $key);
}
function is_email($value, $messsage, $key=null)
{
return ($this->validate(preg_match('|^[\w\d][\w\d\,\.\-]*\@([\w\d\-]+\.)+([a-zA-Z]+)$|', $data) > 0, $message, $key));
}
function is_number($value, $message, $key=null)
{
return $this->validate(is_numeric($value), $message, $key);
}
function is_date($value, $message, $key=null)
{
list ($y, $m, $d) = explode('-', $value);
if (is_numeric($y) && is_numeric($m) && is_numeric($d)) {
return $this->validate(checkdate($m,$d,$y), $message, $key);
}
else {
return $this->validate(false, $message, $key);
}
}
function is_datetime($value, $message, $key=null)
{
if (preg_match("/^(\d{4})-(\d{2})-(\d{2}) ([01][0-9]|2[0-3]):([0-5][0-9]):([0-5][0-9])$/", $value, $ms)) {
return $this->validate(checkdate($ms[2], $ms[3], $ms[1]), $message, $key);
}
return $this->validate(false, $message, $key);
}
function is_datetime_str($value, $message, $key=null) {
$ts = strtotime($value);
if (version_compare(PHP_VERSION, '5.1.0', '>=')) {
return $this->validate($ts !== false, $message, $key);
}
else {
return $this->validate($ts != -1, $message, $key);
}
}
function is_url($value, $message, $key=null)
{
$pattern = '~^
(https?|ftps?):// # http or ftp (+SSL)
(
([a-z0-9-]+\.)+[a-z]{2,6} # a domain name
| # or
\d{1,3}\.\d{1,3}\.\d{1,3}\.\d{1,3} # a IP address
)
(:[0-9]+)? # a port (optional)
(/?|/\S+) # a /, nothing or a / with something
$~ix';
return $this->validate(preg_match($pattern, $value) > 0, $message, $key);
}
function license($value, $type, $key=null)
{
global $global_plugins;
if (!is_array($global_plugins)) $global_plugins = array();
foreach ($global_plugins as $k=>$v) {
if ($v[plugin_type] == $type) {
$version = $v[plugin_version];
}
}
$http_host = str_replace("www.","",strtolower($_SERVER['HTTP_HOST']));
$response = rc_toolkit::get_url_content("http://www.radcodes.com/gateway/license.php?key=$value&domain=$http_host&type=$type&version=$version");
if (strstr($response,"CONFIRM")) {
list($res,$domains,$error) = explode("::",$response);
return $this->validate(in_array($http_host, explode(',',$domains)), "Invalid License", $key);
} elseif (strstr($response,"ERROR")) {
return $this->validate(false, str_replace("ERROR::","",$response), $key);
}
}
}
class rc_xml_parser {
function get_children($vals, &$i) {
$children = array();
if (isset($vals[$i]['value'])){
$children['VALUE'] = $vals[$i]['value'];
}
while (++$i < count($vals)){
switch ($vals[$i]['type']){
case 'cdata':
if (isset($children['VALUE'])){
$children['VALUE'] .= $vals[$i]['value'];
}
else {
$children['VALUE'] = $vals[$i]['value'];
}
break;
case 'complete':
if (isset($vals[$i]['attributes'])) {
$children[$vals[$i]['tag']][]['ATTRIBUTES'] = $vals[$i]['attributes'];
$index = count($children[$vals[$i]['tag']])-1;
if (isset($vals[$i]['value'])){
$children[$vals[$i]['tag']][$index]['VALUE'] = $vals[$i]['value'];
}
else {
$children[$vals[$i]['tag']][$index]['VALUE'] = '';
}
}
else {
if (isset($vals[$i]['value'])){
$children[$vals[$i]['tag']][]['VALUE'] = $vals[$i]['value'];
}
else {
$children[$vals[$i]['tag']][]['VALUE'] = '';
}
}
break;
case 'open':
if (isset($vals[$i]['attributes'])) {
$children[$vals[$i]['tag']][]['ATTRIBUTES'] = $vals[$i]['attributes'];
$index = count($children[$vals[$i]['tag']])-1;
$children[$vals[$i]['tag']][$index] = array_merge($children[$vals[$i]['tag']][$index],$this->get_children($vals, $i));
}
else {
$children[$vals[$i]['tag']][] = $this->get_children($vals, $i);
}
break;
case 'close':
return $children;
}
}
}
function get_xml_tree($data) {
if( ! $data )
return false;
$parser = xml_parser_create('UTF-8');
xml_parser_set_option($parser, XML_OPTION_SKIP_WHITE, 1);
xml_parse_into_struct($parser, $data, $vals, $index);
xml_parser_free($parser);
$tree = array();
$i = 0;
if (isset($vals[$i]['attributes'])) {
$tree[$vals[$i]['tag']][]['ATTRIBUTES'] = $vals[$i]['attributes'];
$index = count($tree[$vals[$i]['tag']])-1;
$tree[$vals[$i]['tag']][$index] = array_merge($tree[$vals[$i]['tag']][$index], $this->get_children($vals, $i));
}
else {
$tree[$vals[$i]['tag']][] = $this->get_children($vals, $i);
}
return $tree;
}
}
class rc_tagcloud extends rc_model
{
var $pk = 'tag_id';
var $case_insensitive = true;
function delete_name($name)
{
$criteria = rc_toolkit::db_data_packer(array('tag_name'=>$name));
return $this->delete_by_criteria($criteria);
}
function log_tag($name)
{
// just some safety
if ($name=='') return false;
if ($this->case_insensitive) $name = strtolower($name);
$data = array('tag_name'=>$name);
$data_string = rc_toolkit::db_data_packer($data);
$tag = $this->get_record_by_criteria($data_string);
if ($tag) {
$data['tag_count'] = $tag['tag_count'] + 1;
$this->update($tag[$this->pk],$data);
return $tag[$this->pk];
}
else {
$data['tag_count'] = 1;
return $this->insert($data);
}
}
function get_cloud($max_entry, $order_by='count', $sort=null)
{
$records = $this->get_records("ORDER BY tag_count desc LIMIT $max_entry");
$columns = array();
$i=0;
foreach ($records as $k=>$v) {
$records[$k]['rank'] = ++$i;
$columns[$k] = ($order_by == 'name') ? $records[$k]['tag_name'] : $records[$k]['tag_count'];
}
if ($sort === null) {
$sort = ($order_by=='count') ? SORT_DESC : SORT_ASC;
}
array_multisort($columns, $sort, $records);
return $records;
}
}
class rc_cat extends rc_model
{
var $pk = 'cat_id';
var $pd = 'cat_dependency';
var $pt = 'cat_title';
var $po = 'cat_order';
var $_ref = array('table'=>'','pk'=>'','pc'=>'');
function _build_get_records_query($criteria=null)
{
$criteria = str_replace(array($this->pk, $this->pd, $this->pt, $this->po),
array('a.'.$this->pk, 'a.'.$this->pd, 'a.'.$this->pt, 'a.'.$this->po),
$criteria
);
$query = "SELECT a.*, b.cat_id as parent_cat_id, b.cat_title as parent_cat_title FROM $this->table as a
LEFT JOIN $this->table as b ON b.{$this->pk} = a.{$this->pd}
$criteria
";
return $query;
}
function FindRecordsByCriteria($criteria='', $key=true)
{
$objs = array();
$datas = $this->get_records($criteria, $key);
//rc_toolkit::debug($datas,"datas");
foreach ($datas as $k => $data) {
$obj = new $this->_class($this);
$obj->setProperties($data);
$obj->parent_cat_id = $data['parent_cat_id'];
$obj->parent_cat_title = $data['parent_cat_title'];
$objs[$k] = $obj;
}
return $objs;
}
function count_items($options=array())
{
$rc = $this->_ref['pc'];
$query = "SELECT $rc as name, COUNT($rc) as total FROM {$this->_ref['table']}
LEFT JOIN $this->table ON $this->table.$this->pk = $rc
GROUP BY $rc
";
return $this->ResultFunctionFieldQuery($query,'name','total');
}
function get_struct_categories($pid=null)
{
static $cats;
if ($cats === null) {
$records = $this->FindRecordsByCriteria("ORDER BY $this->po ASC");
$cats = array();
foreach ($records as $k => $r) {
$parent = $r->{$this->pd} > 0 ? $r->{$this->pd} : 0;
$cats[$parent][$r->{$this->pk}] = $r;
}
}
return $pid === null ? $cats : (array)$cats[$pid];
}
function get_categories($parent=0,$subcat=true)
{
$cats = $this->get_struct_categories($parent);
if ($subcat) {
foreach ($cats as $k=>$v) {
$cats[$k]->subcategories = $this->get_categories($v->cat_id, false);
}
}
return $cats;
}
function get_category_tree()
{
$stats = $this->count_items();
$cats = $this->get_categories(0,true);
$sumcats = 0;
foreach ($cats as $k=>$v) {
$cnt = $stats[$k] ? $stats[$k] : 0;
$cats[$k]->count = $cnt;
$subtotal = 0;
if (is_array($v->subcategories)) {
foreach ($v->subcategories as $kk=>$vv) {
$cnt = $stats[$kk] ? $stats[$kk] : 0;
$cats[$k]->subcategories[$kk]->count = $cnt;
$subtotal += $cnt;
}
}
$cats[$k]->subtotal = $subtotal;
$cats[$k]->total = $cats[$k]->count + $cats[$k]->subtotal;
$sumcats += $cats[$k]->total;
}
$total = array_sum($stats);
$uncategorized = $total - $sumcats;
$tree = array(
'stats' => $stats,
'categories' => $cats,
'total' => $total,
'uncategorized' => $uncategorized
);
}
function get_max_id()
{
$row = $this->db->database_fetch_assoc($this->db->database_query("SELECT max($this->pk) AS max_id FROM $this->table"));
return $row['max_id'];
}
function add_new($title, $parent=0)
{
$class = get_class($this);
$obj = new $class;
$obj->{$obj->pt} = $title;
$obj->{$obj->pd} = (int) $parent;
$obj->{$obj->po} = $this->get_max_id() + 1;
$obj->save();
return $obj;
}
function delete_category($id)
{
$subcats = $this->get_categories($id,false);
$cat_ids = array($id);
if (count($subcats)) {
$cat_ids = array_merge($cat_ids, array_keys($subcats));
}
$cat_id_str = join("','",$cat_ids);
$this->delete_by_criteria("$this->pd = '$id'");
$this->delete($id);
$query = "UPDATE {$this->_ref['table']} SET {$this->_ref['pc']} = '0' WHERE {$this->_ref['pc']} IN ('$cat_id_str')";
$this->db->database_query($query);
}
function ordering($direction)
{
if ($direction == 'down') {
$operation = '>';
$ordering = 'asc';
}
else {
$operation = '<';
$ordering = 'desc';
}
$cat_id = $this->{$this->pk};
$cat_order = $this->{$this->po};
$cat_dependency = $this->{$this->pd};
$other = $this->FindRecordByCriteria("$this->pk <> '$cat_id' AND $this->pd = '$cat_dependency' AND $this->po $operation '$cat_order' ORDER BY $this->po $ordering");
if ($other) {
$this->{$this->po} = $other->{$this->po};
$this->save();
$other->{$this->po} = $cat_order;
$other->save();
}
}
}
class rc_categories extends rc_model
{
var $pk = 'id'; // primary
var $pd = 'dependency'; // dependency col
var $pt = 'title'; // title col
function get_categories($parent=0,$subcat=true)
{
$rows = $this->get_records("WHERE $this->pd = '$parent' ORDER BY $this->pk",true);
if ($subcat) {
foreach ($rows as $k=>$row) {
$rows[$k]['subcategories'] = $this->get_categories($row[$this->pk],false);
$rows[$k]['next_subcat'] = 1;
if (count($rows[$k]['subcategories'])) {
$rows[$k]['next_subcat'] += max(array_keys($rows[$k]['subcategories']));
}
}
}
return $rows;
}
function get_max_id()
{
$row = $this->db->database_fetch_assoc($this->db->database_query("SELECT max($this->pk) AS max_id FROM $this->table"));
return $row['max_id'];
}
function save_categories($maincats, $subcats)
{
if (!is_array($maincats)) return;
foreach ($maincats as $mid=>$title) {
if (!strlen(trim($title))) { // title is blank, ie
$this->delete($mid); // delete row
$this->delete_by_criteria("$this->pd = '$mid'"); // delete all children
}
else {
$mctemp = $this->get_record_by_criteria("$this->pk = '$mid' and $this->pd = '0'"); // check if row exists
if ($mctemp) {
$mctemp[$this->pt] = $title;
$this->update($mctemp[$this->pk],$mctemp); // update
$nid = $mid;
}
else {
$mctemp = array($this->pt => $title, $this->pd => 0);
$nid = $this->insert($mctemp);
}
if (is_array($subcats[$mid])) {
foreach ($subcats[$mid] as $sid => $title) {
if (!strlen(trim($title))) {
$this->delete_by_criteria("$this->pk = '$sid' and $this->pd = '$mid'");
}
else {
$sctemp = $this->get_record_by_criteria("$this->pk = '$sid' and $this->pd = '$mid'");
if ($sctemp) {
$sctemp[$this->pt] = $title;
$this->update($sctemp[$this->pk], $sctemp);
}
else {
$sctemp = array($this->pt => $title, $this->pd => $nid);
$this->insert($sctemp);
}
}
}
}
}
}
}
}
class rc_tag extends rc_model {
var $table = null;
var $pk = 'tag_id'; // primary key
var $po = 'tag_object_id'; // object ref key
var $pn = 'tag_name';
var $_glue = ',';
function clean_input_tags($input_tags)
{
if (is_array($input_tags)) {
$tags = array();
foreach ($input_tags as $k => $v) {
$trim_v = trim($v);
if (strlen($trim_v)) {
$tags[] = $trim_v;
}
}
return $tags;
}
else {
return $this->clean_input_tags(explode($this->_glue, $input_tags));
}
}
function get_object_tags($object_id)
{
$tags = array();
$query = "SELECT * FROM $this->table WHERE $this->po = '$object_id'";
$res = $this->db->database_query($query);
while ($row = $this->db->database_fetch_assoc($res)) {
$tags[$row[$this->pk]] = $row[$this->pn];
}
return $tags;
}
function update_object_tags($object_id, $string_tags)
{
$cur_tags = $this->get_object_tags($object_id);
$new_tags = $this->clean_input_tags($string_tags);
$insert_tags = array_diff($new_tags, $cur_tags);
//rc_toolkit::debug($cur_tags,'$cur_tags');
//rc_toolkit::debug($insert_tags,'insert_tgas');
foreach ($insert_tags as $name) {
$data = array($this->po => $object_id, $this->pn => $name);
$this->insert($data);
}
$delete_tags = array_diff($cur_tags, $new_tags);
foreach ($delete_tags as $name) {
$this->delete_by_criteria("$this->po = '$object_id' AND $this->pn = '$name'");
}
}
function delete_object_tags($object_id)
{
$this->delete_by_criteria("$this->po = '$object_id'");
}
function get_popular_tags($limit=100, $order_by='count', $sort=null, $classes=array(1,3,7,10,20,40,65,100), $where=null)
{
$query = "SELECT $this->pn as name, COUNT(*) as count FROM $this->table $where GROUP BY $this->pn ORDER BY count DESC LIMIT $limit";
$res = $this->db->database_query($query);
$columns = array();
$i = 0;
$max_class = count($classes) + 1;
$records = array();
while ($row = $this->db->database_fetch_assoc($res)) {
$i++;
$records[$i] = $row;
$records[$i]['rank'] = $i;
$columns[$i] = ($order_by == 'name') ? $records[$i]['name'] : $records[$i]['count'];
foreach ($classes as $k=>$bound) {
if ($i <= $bound) {
$records[$i]['class'] = $k + 1;
break;
}
}
if (!isset($records[$i]['class'])) $records[$i]['class'] = $max_class;
}
if ($sort === null) {
$sort = ($order_by=='count') ? SORT_DESC : SORT_ASC;
}
array_multisort($columns, $sort, $records);
return $records;
}
function get_object_ids_tagged_with($tags)
{
$ids = array();
$tags = $this->clean_input_tags($tags);
$query = "SELECT DISTINCT $this->po FROM $this->table WHERE $this->pn IN ('" .join("','", $tags). "')";
$res = $this->db->database_query($query);
while ($row = $this->db->database_fetch_assoc($res)) {
$ids[] = $row[$this->po];
}
return $ids;
}
function get_object_tags_by_object_ids($ids)
{
$criteria = "WHERE $this->po IN ('". join("','",$ids) ."')";
$records = $this->FindRecordsByCriteria($criteria);
$data = array();
foreach ($records as $row) {
$data[$row->{$this->po}][$row->{$this->pk}] = $row->{$this->pn};
}
return $data;
}
}
class rc_level extends rc_model
{
var $table = 'se_levels';
var $pk = 'level_id';
}
class rc_field extends rc_model
{
var $table = 'se_fields';
var $pk = 'field_id';
}
class rc_user extends rc_model {
var $table = 'se_users';
var $pk = 'user_id';
/**
* @var se_user
*/
var $se_user;
function __construct()
{
rc_model::__construct();
$this->se_user = new se_user();
}
function setProperties($data)
{
rc_model::setProperties($data);
$this->load_se_user();
}
function load_se_user()
{
$user = new se_user();
$user->user_exists = 1;
$user->user_info = $this->getProperties();
$this->se_user = $user;
$this->se_user->user_displayname();
$this->user_displayname_short = $this->se_user->user_displayname_short;
$this->user_displayname = $this->se_user->user_displayname;
return $this->se_user;
}
}
class rc_profile extends rc_model {
var $table = 'se_profile';
var $pk = 'profile_id';
}
class rc_comment extends rc_model
{
var $type = '';
var $table;
var $pk; // id
var $po; // comment_[type]_id
var $pa; // authoruser_id
var $pd; // comment_date
var $pb; // comment_body
var $identifier;
function __construct($identifier=null)
{
$type = $this->type;
$this->table = "rc_{$type}comments";
$this->pk = $type.'comment_id';
$this->po = $type.'comment_'.$type.'_id';
$this->pa = $type.'comment_authoruser_id';
$this->pd = $type.'comment_date';
$this->pb = $type.'comment_body';
$this->identifier = $identifier;
rc_model::rc_model();
}
function count_by_object_ids($ids)
{
$criteria = "WHERE $this->po IN ('" . join("','",$ids) . "')";
return $this->CountFieldByCriteria($this->po, $criteria);
}
function _build_get_records_query($criteria=null)
{
$u = new rc_user();
$query = "SELECT {$this->table}.*, se_users.* FROM $this->table
JOIN $u->table ON {$this->table}.{$this->pa} = {$u->table}.{$u->pk}
$criteria";
return $query;
}
function FindRecordsByCriteria($criteria='', $key=true)
{
$objs = array();
$datas = $this->get_records($criteria, $key);
foreach ($datas as $k => $data) {
$obj = new $this->_class($this);
$obj->setProperties($data);
$rc_user = new rc_user();
$rc_user->setProperties($data);
$obj->rc_user = $rc_user;
$objs[$k] = $obj;
}
return $objs;
}
function comment_total()
{
return $this->CountByCriteria("WHERE $this->po='$this->identifier'");
}
function comment_list($start, $limit)
{
$critiera = "WHERE $this->po = '$this->identifier' ORDER BY $this->pk DESC LIMIT $start, $limit";
$comments = $this->FindRecordsByCriteria($critiera);
$comment_array = array();
foreach ($comments as $comment) {
$comment_array[] = array(
'comment_id' => $comment->{$this->pk},
'comment_author' => $comment->rc_user->se_user,
'comment_date' => $comment->{$this->pd},
'comment_body' => $comment->{$this->pb}
);
}
return $comment_array;
}
function comment_delete_selected($start, $limit)
{
$ids = array();
foreach ($_POST as $k=>$v) {
if (strstr($k, 'comment_') && $v==1) {
$ids[] = str_replace('comment_','', $k);
}
}
$this->delete_by_criteria("$this->po = '$this->identifier' AND $this->pk IN ('" . join("','",$ids) . "')");
}
function comment_post($object_id, $author_id, $body)
{
$class = get_class($this);
$object = new $class;
$object->{$object->po} = $object_id;
$object->{$object->pa} = $author_id;
$object->{$object->pb} = $body;
$object->{$object->pd} = time();
return $object->save();
}
}
class rc_rating {
var $type;
// replace type with $type
var $table; // se_typeratings
var $pk; // typerating_id
var $po; // typerating_type_id
var $pu; // typerating_user_id
var $pr; // typerating_rating
var $pd; // typerating_daterated
var $table_object; // se_types
function __construct($type, $options=array()) {
$this->type = $type;
$this->table = "se_{$type}ratings";
$this->table_object = "se_{$type}s";
$this->pk = "{$type}rating_id";
$this->po = "{$type}rating_{$type}_id";
$this->pu = "{$type}rating_user_id";
$this->pr = "{$type}rating_rating";
$this->pd = "{$type}rating_daterated";
}
function rating_list($object_id, $start, $limit, $sort_by="", $where="") {
global $database;
$cs = array("$this->po = '$object_id'");
if ($where) $cs['where'] = $where;
$condition = rc_toolkit::criteria_builder($cs);
if (!$sort_by) $sort_by = "$this->pd DESC";
$sql = "SELECT {$this->table}.*, se_users.user_id, se_users.user_username, se_users.user_fname, se_users.user_lname, se_users.user_photo
FROM {$this->table}
JOIN se_users ON $this->pu = se_users.user_id
WHERE $condition
ORDER BY $sort_by
LIMIT $start, $limit
";
//rc_toolkit::debug($sql,'get_raters sql');
$ratings = array();
$res = $database->database_query($sql);
while ($row = $database->database_fetch_assoc($res)) {
$se_user = rc_toolkit::init_se_user_from_data($row);
$row['user'] = $se_user;
$ratings[] = $row;
}
return $ratings;
}
function get_rating($user_id, $object_id) {
global $database;
$sql = "SELECT * FROM $this->table WHERE $this->pu = '$user_id' AND $this->po = '$object_id' LIMIT 1";
$res = $database->database_query($sql);
$rating = $database->database_fetch_assoc($res);
//rc_toolkit::debug($rating,'get_rating');
return $rating;
}
// get_rating
function has_rated($user_id, $object_id) {
$rating = $this->get_rating($user_id, $object_id);
return !empty($rating);
}
// has_rated
function rating_total($object_id) {
global $database;
$sql = "SELECT COUNT(*) as total FROM $this->table WHERE $this->po = '$object_id'";
$res = $database->database_query($sql);
$rating = $database->database_fetch_assoc($res);
return $rating['total'] > 0 ? $rating['total'] : 0;
}
// rating_total
function add_rating($user_id, $object_id, $rating, $update_cache = true) {
global $database;
$type =& $this->type;
$data = array(
$this->pu => $user_id,
$this->po => $object_id,
$this->pr => $rating,
$this->pd => time()
);
$rating_total = $this->rating_total($object_id);
$sql = "INSERT INTO $this->table SET " . rc_toolkit::db_data_packer($data);
$res = $database->database_query($sql);
$rating_id = $database->database_insert_id();
$return_data = array('rating_id' => $rating_id);
if ($update_cache) {
// GET AVERAGE RATING / NUM VOTES FOR BAYESIAN WEIGHTED RATING
$sql = "SELECT avg({$type}_cache_rating) AS average_rating, avg({$type}_cache_rating_total) AS average_total FROM $this->table_object WHERE {$type}_cache_rating_total<>'0'";
//rc_toolkit::debug($sql);
$avg = $database->database_fetch_assoc($database->database_query($sql));
$sql = "SELECT {$type}_cache_rating as cache_rating FROM $this->table_object WHERE {$type}_id = '$object_id'";
//rc_toolkit::debug($sql);
$object_info = $database->database_fetch_assoc($database->database_query($sql));
// GET TOTAL RATING
$new_total = $rating_total + 1;
$new_rating = ($object_info[cache_rating]*$rating_total+$rating) / $new_total;
$new_rating_weighted = ( ($avg[average_total] * $avg[average_rating]) + ($new_total * $new_rating) ) / ($avg[average_total] + $new_total);
// SET NEW CACHED RATINGS
$sql = "UPDATE $this->table_object SET
{$type}_cache_rating='$new_rating',
{$type}_cache_rating_weighted='$new_rating_weighted',
{$type}_cache_rating_total='$new_total'
WHERE {$type}_id = '$object_id'";
//rc_toolkit::debug($sql);
$database->database_query($sql);
$return_data[rating_full] = floor($new_rating);
$return_data[rating_part] = (($new_rating-$return_data[rating_full]) == 0) ? 0 : 1;
$return_data[rating_none] = 5-$return_data[rating_full]-$return_data[rating_part];
$return_data[rating_total] = $new_total;
}
return $return_data;
}
// add_rating
}
class rc_vote extends rc_model {
var $table = null;
var $pk = 'vote_id'; // primary key
var $po = 'vote_object_id'; // object ref key
var $pu = 'vote_user_id'; // user id
var $pd = 'vote_date'; // create
var $pc = 'vote_comment'; // comment
function _pre_save()
{
if ($this->isNew() and empty($this->{$this->pd})) {
$this->{$this->pd} = time();
}
}
function _build_count_records_query($criteria=null)
{
$u = new rc_user();
$query = "SELECT COUNT({$this->table}.{$this->pk}) as total FROM $this->table
JOIN {$u->table} ON {$u->table}.{$u->pk} = {$this->table}.{$this->pu}
$criteria
";
return $query;
}
function _build_get_records_query($criteria=null)
{
$u = new rc_user();
$query = "SELECT * FROM $this->table
JOIN {$u->table} ON {$u->table}.{$u->pk} = {$this->table}.{$this->pu}
$criteria
";
return $query;
}
function FindRecordsByCriteria($criteria='', $key=true)
{
$objs = array();
$datas = $this->get_records($criteria, $key);
foreach ($datas as $k => $data) {
$obj = new $this->_class($this);
$obj->setProperties($data);
$rc_user = new rc_user();
$rc_user->setProperties($data);
$obj->rc_user = $rc_user;
$objs[$k] = $obj;
}
return $objs;
}
function get_vote($user_id, $object_id)
{
return $this->FindRecordByCriteria("$this->po='$object_id' AND $this->pu='$user_id'");
}
function has_vote($user_id, $object_id)
{
$total = $this->CountByCriteria("WHERE $this->po='$object_id' AND $this->pu='$user_id'");
return $total > 0;
}
function count_by_user_id($user_id)
{
$criteria = "WHERE $this->pu = '$user_id'";
return $this->CountByCriteria($criteria);
}
function count_by_object_id($object_id)
{
$criteria = "WHERE $this->po = '$object_id'";
return $this->CountByCriteria($criteria);
}
function get_by_object_id($object_id, $limit=null, $sort=null)
{
$criteria = "WHERE $this->po = '$object_id' ";
$criteria .= " ORDER BY " . ($sort ? $sort : "$this->pd asc");
if ($limit !== null) $criteria .= " LIMIT $limit ";
return $this->FindRecordsByCriteria($criteria);
}
function delete_by_object_id($object_id)
{
$this->delete_by_criteria("$this->po = '$object_id'");
}
function register_vote($object_id, $user_id, $comment='')
{
$this->{$this->po} = $object_id;
$this->{$this->pu} = $user_id;
$this->{$this->pc} = $comment;
return $this->save();
}
function unregister_vote($object_id, $user_id)
{
$this->delete_by_criteria("$this->po = '$object_id' AND $this->pu = '$user_id'");
}
function count_voters($where="")
{
$query = "SELECT COUNT(distinct user_id) as total FROM $this->table
JOIN se_users ON se_users.user_id = {$this->table}.{$this->pu}
$where
";
return $this->ResultFunctionQuery($query,'total');
}
function get_voters($start=0, $limit=10, $where="", $sort="total_votes DESC")
{
$query = "SELECT se_users.*, COUNT($this->pk) as total_votes FROM se_users
JOIN $this->table ON se_users.user_id = {$this->table}.{$this->pu}
$where
GROUP BY se_users.user_id
ORDER BY $sort
LIMIT $start, $limit
";
$rc_users = $this->_get_popular_users_count($query);
return $rc_users;
}
// sample usage where object is an user
function count_objecters($where="")
{
$query = "SELECT COUNT(distinct user_id) as total FROM $this->table
JOIN se_users ON se_users.user_id = {$this->table}.{$this->po}
$where
";
return $this->ResultFunctionQuery($query,'total');
}
// sample usage where object is an user
function get_objecters($start=0, $limit=10, $where="", $sort="total_votes DESC")
{
$query = "SELECT se_users.*, COUNT($this->pk) as total_votes FROM se_users
JOIN $this->table ON se_users.user_id = {$this->table}.{$this->po}
$where
GROUP BY se_users.user_id
ORDER BY $sort
LIMIT $start, $limit
";
$rc_users = $this->_get_popular_users_count($query);
return $rc_users;
}
function get_object_ids_voted_by($user_id)
{
$ids = array();
$query = "SELECT DISTINCT $this->po FROM $this->table WHERE $this->pu = '$user_id'";
$res = $this->db->database_query($query);
while ($row = $this->db->database_fetch_assoc($res)) {
$ids[] = $row[$this->po];
}
return $ids;
}
function _get_popular_users_count($query)
{
$res = $this->db->database_query($query);
$rc_users = array();
while ($r = $this->db->database_fetch_assoc($res)) {
$rc_user = new rc_user();
$rc_user->setProperties($r);
$rc_user->total_votes = $r['total_votes']; // lazy
$rc_users[] = $rc_user;
}
return $rc_users;
}
}
class rc_pager
{
/**
* The current page number
* @type int
*/
var $page;
/**
* Number of record in each page
* @type int
*/
var $page_size;
/**
* Total number of rows in record set
* @type int
*/
var $total_entries;
/**
* Total number of pages
* @type int
*/
var $total_pages;
/**
* Contruct a new Paginator instance
*
* @param $page The current page number
* @param $page_size The number of record show in 1 page
* @param $total_entries The total number of row in record set
*
* @return void
*/
function __construct ($page, $page_size, $total_entries)
{
$this->page = $page;
$this->page_size = $page_size;
$this->total_entries = $total_entries;
$this->total_pages = ceil($this->total_entries / $this->page_size);
if( $this->page > $this->total_pages )
{
$this->page = $this->total_pages;
}
if( $this->page < 1 )
{
$this->page = 1;
}
$this->offset = ( $this->page - 1 ) * $this->page_size;
}
function assign_smarty_vars($page_entries=null)
{
global $smarty;
if ($page_entries === null) {
if ($this->total_pages > $this->page) {
$page_entries = $this->page_size;
}
else {
$page_entries = $total_entries - ($this->total_pages - 1) * $this->page_size;
}
}
$smarty->assign('total_entries', $this->total_entries);
$smarty->assign('p', $this->page);
$smarty->assign('maxpage', $this->total_pages);
$smarty->assign('p_start', $this->offset + 1);
$smarty->assign('p_end', $this->offset + $page_entries);
}
}
function radcodes_hook_se_admin_notifications()
{
global $global_plugins, $admin_notifications;
$radcodes_lib_version = number_format(RADCODES_LIBRARY_VERSION,2);
if ($global_plugins['radcodes']['plugin_version'] > $radcodes_lib_version) {
$admin_notifications[] = 11000006;
}
}
function radcodes_hook_se_footer() {
global $smarty;
$rc_toolkit = new rc_toolkit();
$smarty->assign('rc_toolkit', $rc_toolkit);
}