', $table_prefix='', $goOffline=true ) { // perform a number of fatality checks, then die gracefully if (!function_exists( 'mysql_connect' )) { $mosSystemError = 1; if ($goOffline) { $basePath = dirname( __FILE__ ); include $basePath . '/../configuration.php'; include $basePath . '/../offline.php'; exit(); } } if (phpversion() < '4.2.0') { if (!($this->_resource = @mysql_connect( $host, $user, $pass ))) { $mosSystemError = 2; if ($goOffline) { $basePath = dirname( __FILE__ ); include $basePath . '/../configuration.php'; include $basePath . '/../offline.php'; exit(); } } } else { if (!($this->_resource = @mysql_connect( $host, $user, $pass, true ))) { $mosSystemError = 2; if ($goOffline) { $basePath = dirname( __FILE__ ); include $basePath . '/../configuration.php'; include $basePath . '/../offline.php'; exit(); } } } if ($db != '' && !mysql_select_db( $db, $this->_resource )) { $mosSystemError = 3; if ($goOffline) { $basePath = dirname( __FILE__ ); include $basePath . '/../configuration.php'; include $basePath . '/../offline.php'; exit(); } } $this->_table_prefix = $table_prefix; //@mysql_query("SET NAMES 'utf8'", $this->_resource); $this->_ticker = 0; $this->_log = array(); } /** * @param int */ function debug( $level ) { $this->_debug = intval( $level ); } /** * @return int The error number for the most recent query */ function getErrorNum() { return $this->_errorNum; } /** * @return string The error message for the most recent query */ function getErrorMsg() { return str_replace( array( "\n", "'" ), array( '\n', "\'" ), $this->_errorMsg ); } /** * Get a database escaped string * * @param string The string to be escaped * @param boolean Optional parameter to provide extra escaping * @return string * @access public * @abstract */ function getEscaped( $text, $extra = false ) { // Use the appropriate escape string depending upon which version of php // you are running if (version_compare(phpversion(), '4.3.0', '<')) { $string = mysql_escape_string($text); } else { $string = mysql_real_escape_string($text, $this->_resource); } if ($extra) { $string = addcslashes( $string, '%_' ); } return $string; } /** * Get a quoted database escaped string * * @param string A string * @param boolean Default true to escape string, false to leave the string unchanged * @return string * @access public */ function Quote( $text, $escaped = true ) { return '\''.($escaped ? $this->getEscaped( $text ) : $text).'\''; } /** * Quote an identifier name (field, table, etc) * @param string The name * @return string The quoted name */ function NameQuote( $s ) { $q = $this->_nameQuote; if (strlen( $q ) == 1) { return $q . $s . $q; } else { return $q{0} . $s . $q{1}; } } /** * @return string The database prefix */ function getPrefix() { return $this->_table_prefix; } /** * @return string Quoted null/zero date string */ function getNullDate() { return $this->_nullDate; } /** * Sets the SQL query string for later execution. * * This function replaces a string identifier $prefix with the * string held is the _table_prefix class variable. * * @param string The SQL query * @param string The offset to start selection * @param string The number of results to return * @param string The common table prefix */ function setQuery( $sql, $offset = 0, $limit = 0, $prefix='#__' ) { $this->_sql = $this->replacePrefix( $sql, $prefix ); $this->_limit = intval( $limit ); $this->_offset = intval( $offset ); } /** * This function replaces a string identifier $prefix with the * string held is the _table_prefix class variable. * * @param string The SQL query * @param string The common table prefix * @author thede, David McKinnis */ function replacePrefix( $sql, $prefix='#__' ) { $sql = trim( $sql ); $escaped = false; $quoteChar = ''; $n = strlen( $sql ); $startPos = 0; $literal = ''; while ($startPos < $n) { $ip = strpos($sql, $prefix, $startPos); if ($ip === false) { break; } $j = strpos( $sql, "'", $startPos ); $k = strpos( $sql, '"', $startPos ); if (($k !== FALSE) && (($k < $j) || ($j === FALSE))) { $quoteChar = '"'; $j = $k; } else { $quoteChar = "'"; } if ($j === false) { $j = $n; } $literal .= str_replace( $prefix, $this->_table_prefix, substr( $sql, $startPos, $j - $startPos ) ); $startPos = $j; $j = $startPos + 1; if ($j >= $n) { break; } // quote comes first, find end of quote while (TRUE) { $k = strpos( $sql, $quoteChar, $j ); $escaped = false; if ($k === false) { break; } $l = $k - 1; while ($l >= 0 && $sql{$l} == '\\') { $l--; $escaped = !$escaped; } if ($escaped) { $j = $k+1; continue; } break; } if ($k === FALSE) { // error in the query - no end quote; ignore it break; } $literal .= substr( $sql, $startPos, $k - $startPos + 1 ); $startPos = $k+1; } if ($startPos < $n) { $literal .= substr( $sql, $startPos, $n - $startPos ); } return $literal; } /** * @return string The current value of the internal SQL vairable */ function getQuery() { return "
" . htmlspecialchars( $this->_sql ) . "
"; } /** * Execute the query * @return mixed A database resource if successful, FALSE if not. */ function query() { global $mosConfig_debug; if ($this->_limit > 0 && $this->_offset == 0) { $this->_sql .= "\nLIMIT $this->_limit"; } else if ($this->_limit > 0 || $this->_offset > 0) { $this->_sql .= "\nLIMIT $this->_offset, $this->_limit"; } if ($this->_debug) { $this->_ticker++; $this->_log[] = $this->_sql; } $this->_errorNum = 0; $this->_errorMsg = ''; $this->_cursor = mysql_query( $this->_sql, $this->_resource ); if (!$this->_cursor) { $this->_errorNum = mysql_errno( $this->_resource ); $this->_errorMsg = mysql_error( $this->_resource )." SQL=$this->_sql"; if ($this->_debug) { trigger_error( mysql_error( $this->_resource ), E_USER_NOTICE ); //echo "
" . $this->_sql . "
\n"; if (function_exists( 'debug_backtrace' )) { foreach( debug_backtrace() as $back) { if (@$back['file']) { echo '
'.$back['file'].':'.$back['line']; } } } } return false; } return $this->_cursor; } /** * @return int The number of affected rows in the previous operation */ function getAffectedRows() { return mysql_affected_rows( $this->_resource ); } function query_batch( $abort_on_error=true, $p_transaction_safe = false) { $this->_errorNum = 0; $this->_errorMsg = ''; if ($p_transaction_safe) { $si = mysql_get_server_info( $this->_resource ); preg_match_all( "/(\d+)\.(\d+)\.(\d+)/i", $si, $m ); if ($m[1] >= 4) { $this->_sql = 'START TRANSACTION;' . $this->_sql . '; COMMIT;'; } else if ($m[2] >= 23 && $m[3] >= 19) { $this->_sql = 'BEGIN WORK;' . $this->_sql . '; COMMIT;'; } else if ($m[2] >= 23 && $m[3] >= 17) { $this->_sql = 'BEGIN;' . $this->_sql . '; COMMIT;'; } } $query_split = preg_split ("/[;]+/", $this->_sql); $error = 0; foreach ($query_split as $command_line) { $command_line = trim( $command_line ); if ($command_line != '') { $this->_cursor = mysql_query( $command_line, $this->_resource ); if (!$this->_cursor) { $error = 1; $this->_errorNum .= mysql_errno( $this->_resource ) . ' '; $this->_errorMsg .= mysql_error( $this->_resource )." SQL=$command_line
"; if ($abort_on_error) { return $this->_cursor; } } } } return $error ? false : true; } /** * Diagnostic function */ function explain() { $temp = $this->_sql; $this->_sql = "EXPLAIN $this->_sql"; $this->query(); if (!($cur = $this->query())) { return null; } $first = true; $buf = ""; $buf .= $this->getQuery(); while ($row = mysql_fetch_assoc( $cur )) { if ($first) { $buf .= ""; foreach ($row as $k=>$v) { $buf .= ""; } $buf .= ""; $first = false; } $buf .= ""; foreach ($row as $k=>$v) { $buf .= ""; } $buf .= ""; } $buf .= "
$k
$v

 "; mysql_free_result( $cur ); $this->_sql = $temp; return "
$buf
"; } /** * @return int The number of rows returned from the most recent query. */ function getNumRows( $cur=null ) { return mysql_num_rows( $cur ? $cur : $this->_cursor ); } /** * This method loads the first field of the first row returned by the query. * * @return The value returned in the query or null if the query failed. */ function loadResult() { if (!($cur = $this->query())) { return null; } $ret = null; if ($row = mysql_fetch_row( $cur )) { $ret = $row[0]; } mysql_free_result( $cur ); return $ret; } /** * Load an array of single field results into an array */ function loadResultArray($numinarray = 0) { if (!($cur = $this->query())) { return null; } $array = array(); while ($row = mysql_fetch_row( $cur )) { $array[] = $row[$numinarray]; } mysql_free_result( $cur ); return $array; } /** * Load a assoc list of database rows * @param string The field name of a primary key * @return array If key is empty as sequential list of returned records. */ function loadAssocList( $key='' ) { if (!($cur = $this->query())) { return null; } $array = array(); while ($row = mysql_fetch_assoc( $cur )) { if ($key) { $array[$row[$key]] = $row; } else { $array[] = $row; } } mysql_free_result( $cur ); return $array; } /** * This global function loads the first row of a query into an object * * If an object is passed to this function, the returned row is bound to the existing elements of object. * If object has a value of null, then all of the returned query fields returned in the object. * @param string The SQL query * @param object The address of variable */ function loadObject( &$object ) { if ($object != null) { if (!($cur = $this->query())) { return false; } if ($array = mysql_fetch_assoc( $cur )) { mysql_free_result( $cur ); mosBindArrayToObject( $array, $object, null, null, false ); return true; } else { return false; } } else { if ($cur = $this->query()) { if ($object = mysql_fetch_object( $cur )) { mysql_free_result( $cur ); return true; } else { $object = null; return false; } } else { return false; } } } /** * Load a list of database objects * @param string The field name of a primary key * @return array If key is empty as sequential list of returned records. * If key is not empty then the returned array is indexed by the value * the database key. Returns null if the query fails. */ function loadObjectList( $key='' ) { if (!($cur = $this->query())) { return null; } $array = array(); while ($row = mysql_fetch_object( $cur )) { if ($key) { $array[$row->$key] = $row; } else { $array[] = $row; } } mysql_free_result( $cur ); return $array; } /** * @return The first row of the query. */ function loadRow() { if (!($cur = $this->query())) { return null; } $ret = null; if ($row = mysql_fetch_row( $cur )) { $ret = $row; } mysql_free_result( $cur ); return $ret; } /** * Load a list of database rows (numeric column indexing) * @param int Value of the primary key * @return array If key is empty as sequential list of returned records. * If key is not empty then the returned array is indexed by the value * the database key. Returns null if the query fails. */ function loadRowList( $key=null ) { if (!($cur = $this->query())) { return null; } $array = array(); while ($row = mysql_fetch_row( $cur )) { if ( !is_null( $key ) ) { $array[$row[$key]] = $row; } else { $array[] = $row; } } mysql_free_result( $cur ); return $array; } /** * Document::db_insertObject() * * { Description } * * @param string $table This is expected to be a valid (and safe!) table name * @param [type] $keyName * @param [type] $verbose */ function insertObject( $table, &$object, $keyName = NULL, $verbose=false ) { $fmtsql = "INSERT INTO $table ( %s ) VALUES ( %s ) "; $fields = array(); foreach (get_object_vars( $object ) as $k => $v) { if (is_array($v) or is_object($v) or $v === NULL) { continue; } if ($k[0] == '_') { // internal field continue; } $fields[] = $this->NameQuote( $k ); $values[] = $this->Quote( $v ); } $this->setQuery( sprintf( $fmtsql, implode( ",", $fields ) , implode( ",", $values ) ) ); ($verbose) && print "$sql
\n"; if (!$this->query()) { return false; } $id = mysql_insert_id( $this->_resource ); ($verbose) && print "id=[$id]
\n"; if ($keyName && $id) { $object->$keyName = $id; } return true; } /** * Document::db_updateObject() * * { Description } * * @param string $table This is expected to be a valid (and safe!) table name * @param [type] $updateNulls */ function updateObject( $table, &$object, $keyName, $updateNulls=true ) { $fmtsql = "UPDATE $table SET %s WHERE %s"; $tmp = array(); foreach (get_object_vars( $object ) as $k => $v) { if( is_array($v) or is_object($v) or $k[0] == '_' ) { // internal or NA field continue; } if( $k == $keyName ) { // PK not to be updated $where = $keyName . '=' . $this->Quote( $v ); continue; } if ($v === NULL && !$updateNulls) { continue; } if( $v == '' ) { $val = "''"; } else { $val = $this->Quote( $v ); } $tmp[] = $this->NameQuote( $k ) . '=' . $val; } $this->setQuery( sprintf( $fmtsql, implode( ",", $tmp ) , $where ) ); return $this->query(); } /** * @param boolean If TRUE, displays the last SQL statement sent to the database * @return string A standised error message */ function stderr( $showSQL = false ) { return "DB function failed with error number $this->_errorNum" ."
$this->_errorMsg" .($showSQL ? "
SQL =
$this->_sql
" : ''); } function insertid() { return mysql_insert_id( $this->_resource ); } function getVersion() { return mysql_get_server_info( $this->_resource ); } /** * @return array A list of all the tables in the database */ function getTableList() { $this->setQuery( 'SHOW TABLES' ); return $this->loadResultArray(); } /** * @param array A list of valid (and safe!) table names * @return array A list the create SQL for the tables */ function getTableCreate( $tables ) { $result = array(); foreach ($tables as $tblval) { $this->setQuery( 'SHOW CREATE table ' . $this->getEscaped( $tblval ) ); $rows = $this->loadRowList(); foreach ($rows as $row) { $result[$tblval] = $row[1]; } } return $result; } /** * @param array A list of valid (and safe!) table names * @return array An array of fields by table */ function getTableFields( $tables ) { $result = array(); foreach ($tables as $tblval) { $this->setQuery( 'SHOW FIELDS FROM ' . $tblval ); $fields = $this->loadObjectList(); foreach ($fields as $field) { $result[$tblval][$field->Field] = preg_replace("/[(0-9)]/",'', $field->Type ); } } return $result; } /** * Fudge method for ADOdb compatibility */ function GenID( $foo1=null, $foo2=null ) { return '0'; } } /** * mosDBTable Abstract Class. * @abstract * @package Joomla * @subpackage Database * * Parent classes to all database derived objects. Customisation will generally * not involve tampering with this object. * @author Andrew Eddie _tbl = $table; $this->_tbl_key = $key; $this->_db =& $db; } /** * Returns an array of public properties * @return array */ function getPublicProperties() { static $cache = null; if (is_null( $cache )) { $cache = array(); foreach (get_class_vars( get_class( $this ) ) as $key=>$val) { if (substr( $key, 0, 1 ) != '_') { $cache[] = $key; } } } return $cache; } /** * Filters public properties * @access protected * @param array List of fields to ignore */ function filter( $ignoreList=null ) { $ignore = is_array( $ignoreList ); $iFilter = new InputFilter(); foreach ($this->getPublicProperties() as $k) { if ($ignore && in_array( $k, $ignoreList ) ) { continue; } $this->$k = $iFilter->process( $this->$k ); } } /** * @return string Returns the error message */ function getError() { return $this->_error; } /** * Gets the value of the class variable * @param string The name of the class variable * @return mixed The value of the class var (or null if no var of that name exists) */ function get( $_property ) { if(isset( $this->$_property )) { return $this->$_property; } else { return null; } } /** * Set the value of the class variable * @param string The name of the class variable * @param mixed The value to assign to the variable */ function set( $_property, $_value ) { $this->$_property = $_value; } /** * Resets public properties * @param mixed The value to set all properties to, default is null */ function reset( $value=null ) { $keys = $this->getPublicProperties(); foreach ($keys as $k) { $this->$k = $value; } } /** * binds a named array/hash to this object * * can be overloaded/supplemented by the child class * @param array $hash named array * @return null|string null is operation was satisfactory, otherwise returns an error */ function bind( $array, $ignore='' ) { if (!is_array( $array )) { $this->_error = strtolower(get_class( $this ))."::bind failed."; return false; } else { return mosBindArrayToObject( $array, $this, $ignore ); } } /** * binds an array/hash to this object * @param int $oid optional argument, if not specifed then the value of current key is used * @return any result from the database operation */ function load( $oid=null ) { $k = $this->_tbl_key; if ($oid !== null) { $this->$k = $oid; } $oid = $this->$k; if ($oid === null) { return false; } //Note: Prior to PHP 4.2.0, Uninitialized class variables will not be reported by get_class_vars(). /* $class_vars = $this->getPublicProperties(); foreach ($class_vars as $name => $value) { if ($name != $k) { $this->$name = $value; } } */ $class_vars = get_class_vars(get_class($this)); foreach ($class_vars as $name => $value) { if (($name != $k) and ($name != "_db") and ($name != "_tbl") and ($name != "_tbl_key")) { $this->$name = $value; } } $this->reset(); $query = "SELECT *" . "\n FROM $this->_tbl" . "\n WHERE $this->_tbl_key = " . $this->_db->Quote( $oid ) ; $this->_db->setQuery( $query ); return $this->_db->loadObject( $this ); } /** * generic check method * * can be overloaded/supplemented by the child class * @return boolean True if the object is ok */ function check() { return true; } /** * Inserts a new row if id is zero or updates an existing row in the database table * * Can be overloaded/supplemented by the child class * @param boolean If false, null object variables are not updated * @return null|string null if successful otherwise returns and error message */ function store( $updateNulls=false ) { $k = $this->_tbl_key; if ($this->$k != 0) { $ret = $this->_db->updateObject($this->_tbl, $this, $this->_tbl_key, $updateNulls); } else { $ret = $this->_db->insertObject($this->_tbl, $this, $this->_tbl_key); } if (!$ret) { $this->_error = strtolower(get_class($this))."::store failed
" . $this->_db->getErrorMsg(); return false; } else { return true; } } /** * @param string $where This is expected to be a valid (and safe!) SQL expression */ function move( $dirn, $where='' ) { $k = $this->_tbl_key; $sql = "SELECT $this->_tbl_key, ordering FROM $this->_tbl"; if ($dirn < 0) { $sql .= "\n WHERE ordering < " . (int) $this->ordering; $sql .= ($where ? "\n AND $where" : ''); $sql .= "\n ORDER BY ordering DESC"; $sql .= "\n LIMIT 1"; } else if ($dirn > 0) { $sql .= "\n WHERE ordering > " . (int) $this->ordering; $sql .= ($where ? "\n AND $where" : ''); $sql .= "\n ORDER BY ordering"; $sql .= "\n LIMIT 1"; } else { $sql .= "\nWHERE ordering = " . (int) $this->ordering; $sql .= ($where ? "\n AND $where" : ''); $sql .= "\n ORDER BY ordering"; $sql .= "\n LIMIT 1"; } $this->_db->setQuery( $sql ); //echo 'A: ' . $this->_db->getQuery(); $row = null; if ($this->_db->loadObject( $row )) { $query = "UPDATE $this->_tbl" . "\n SET ordering = " . (int) $row->ordering . "\n WHERE $this->_tbl_key = " . $this->_db->Quote( $this->$k ) ; $this->_db->setQuery( $query ); if (!$this->_db->query()) { $err = $this->_db->getErrorMsg(); die( $err ); } //echo 'B: ' . $this->_db->getQuery(); $query = "UPDATE $this->_tbl" . "\n SET ordering = " . (int) $this->ordering . "\n WHERE $this->_tbl_key = " . $this->_db->Quote( $row->$k ) ; $this->_db->setQuery( $query ); //echo 'C: ' . $this->_db->getQuery(); if (!$this->_db->query()) { $err = $this->_db->getErrorMsg(); die( $err ); } $this->ordering = $row->ordering; } else { $query = "UPDATE $this->_tbl" . "\n SET ordering = " . (int) $this->ordering . "\n WHERE $this->_tbl_key = " . $this->_db->Quote( $this->$k ) ; $this->_db->setQuery( $query ); //echo 'D: ' . $this->_db->getQuery(); if (!$this->_db->query()) { $err = $this->_db->getErrorMsg(); die( $err ); } } } /** * Compacts the ordering sequence of the selected records * @param string Additional where query to limit ordering to a particular subset of records. This is expected to be a valid (and safe!) SQL expression */ function updateOrder( $where='' ) { $k = $this->_tbl_key; if (!array_key_exists( 'ordering', get_class_vars( strtolower(get_class( $this )) ) )) { $this->_error = "WARNING: ".strtolower(get_class( $this ))." does not support ordering."; return false; } if ($this->_tbl == "#__content_frontpage") { $order2 = ", content_id DESC"; } else { $order2 = ''; } $query = "SELECT $this->_tbl_key, ordering" . "\n FROM $this->_tbl" . ( $where ? "\n WHERE $where" : '' ) . "\n ORDER BY ordering$order2 " ; $this->_db->setQuery( $query ); if (!($orders = $this->_db->loadObjectList())) { $this->_error = $this->_db->getErrorMsg(); return false; } // first pass, compact the ordering numbers for ($i=0, $n=count( $orders ); $i < $n; $i++) { if ($orders[$i]->ordering >= 0) { $orders[$i]->ordering = $i+1; } } $shift = 0; $n=count( $orders ); for ($i=0; $i < $n; $i++) { //echo "i=$i id=".$orders[$i]->$k." order=".$orders[$i]->ordering; if ($orders[$i]->$k == $this->$k) { // place 'this' record in the desired location $orders[$i]->ordering = min( $this->ordering, $n ); $shift = 1; } else if ($orders[$i]->ordering >= $this->ordering && $this->ordering > 0) { $orders[$i]->ordering++; } } //echo '
';print_r($orders);echo '
'; // compact once more until I can find a better algorithm for ($i=0, $n=count( $orders ); $i < $n; $i++) { if ($orders[$i]->ordering >= 0) { $orders[$i]->ordering = $i+1; $query = "UPDATE $this->_tbl" . "\n SET ordering = " . (int) $orders[$i]->ordering . "\n WHERE $k = " . $this->_db->Quote( $orders[$i]->$k ) ; $this->_db->setQuery( $query); $this->_db->query(); //echo '
'.$this->_db->getQuery(); } } // if we didn't reorder the current record, make it last if ($shift == 0) { $order = $n+1; $query = "UPDATE $this->_tbl" . "\n SET ordering = " . (int) $order . "\n WHERE $k = " . $this->_db->Quote( $this->$k ) ; $this->_db->setQuery( $query ); $this->_db->query(); //echo '
'.$this->_db->getQuery(); } return true; } /** * Generic check for whether dependancies exist for this object in the db schema * * can be overloaded/supplemented by the child class * @param string $msg Error message returned * @param int Optional key index * @param array Optional array to compiles standard joins: format [label=>'Label',name=>'table name',idfield=>'field',joinfield=>'field']. This is expected to hold only valid (and safe!) SQL expressions * @return true|false */ function canDelete( $oid=null, $joins=null ) { $k = $this->_tbl_key; if ($oid) { $this->$k = $oid; } if (is_array( $joins )) { $select = $k; $join = ''; foreach( $joins as $table ) { $tblName = $this->getEscaped( $table['name'] ); $idField = $this->getEscaped( $table['idfield'] ); $jnField = $this->getEscaped( $table['joinfield'] ); $select .= ",\n COUNT(DISTINCT `$tblName`.`$idField`) AS `count_".substr($tblName, 3)."_$idField`"; $join .= "\n LEFT JOIN `$tblName` ON `$tblName`.`$jnField` = `$this->_tbl`.`$k`"; } $query = "SELECT $select" . "\n FROM `$this->_tbl`" . $join . "\n WHERE `$this->_tbl`.`$k` = ". (int) $this->$k . "\n GROUP BY `$this->_tbl`.`$k`" ; $this->_db->setQuery( $query ); $obj = null; if (!$this->_db->loadObject($obj)) { $this->_error = $this->_db->getErrorMsg(); return false; } $msg = array(); foreach( $joins as $table ) { $tblName = $this->getEscaped( $table['name'] ); $idField = $this->getEscaped( $table['idfield'] ); $k = 'count_'.substr($tblName, 3).'_'.$idField; if ($obj->$k) { $msg[] = $table['label']; } } if (count( $msg )) { $this->_error = "noDeleteRecord" . ": " . implode( ', ', $msg ); return false; } else { return true; } } return true; } /** * Default delete method * * can be overloaded/supplemented by the child class * @return true if successful otherwise returns and error message */ function delete( $oid=null ) { //if (!$this->canDelete( $msg )) { // return $msg; //} $k = $this->_tbl_key; if ($oid) { $this->$k = intval( $oid ); } $query = "DELETE FROM $this->_tbl" . "\n WHERE $this->_tbl_key = " . $this->_db->Quote( $this->$k ) ; $this->_db->setQuery( $query ); if ($this->_db->query()) { return true; } else { $this->_error = $this->_db->getErrorMsg(); return false; } } /** * Checks out an object * @param int User id * @param int Object id */ function checkout( $user_id, $oid=null ) { if (!array_key_exists( 'checked_out', get_class_vars( strtolower(get_class( $this )) ) )) { $this->_error = "WARNING: ".strtolower(get_class( $this ))." does not support checkouts."; return false; } $k = $this->_tbl_key; if ($oid !== null) { $this->$k = $oid; } $time = date( 'Y-m-d H:i:s' ); if (intval( $user_id )) { $user_id = intval( $user_id ); // new way of storing editor, by id $query = "UPDATE $this->_tbl" . "\n SET checked_out = $user_id, checked_out_time = " . $this->_db->Quote( $time ) . "\n WHERE $this->_tbl_key = " . $this->_db->Quote( $this->$k ) ; $this->_db->setQuery( $query ); $this->checked_out = $user_id; $this->checked_out_time = $time; } else { $user_id = $this->_db->Quote( $user_id ); // old way of storing editor, by name $query = "UPDATE $this->_tbl" . "\n SET checked_out = 1, checked_out_time = " . $this->_db->Quote( $time ) . ", editor = $user_id" . "\n WHERE $this->_tbl_key = " . $this->_db->Quote( $this->$k ) ; $this->_db->setQuery( $query ); $this->checked_out = 1; $this->checked_out_time = $time; $this->checked_out_editor = $user_id; } return $this->_db->query(); } /** * Checks in an object * @param int Object id */ function checkin( $oid=null ) { if (!array_key_exists( 'checked_out', get_class_vars( strtolower(get_class( $this )) ) )) { $this->_error = "WARNING: ".strtolower(get_class( $this ))." does not support checkin."; return false; } $k = $this->_tbl_key; $nullDate = $this->_db->getNullDate(); if ($oid !== null) { $this->$k = intval( $oid ); } if ($this->$k == NULL) { return false; } $query = "UPDATE $this->_tbl" . "\n SET checked_out = 0, checked_out_time = " . $this->_db->Quote( $nullDate ) . "\n WHERE $this->_tbl_key = " . $this->_db->Quote( $this->$k ) ; $this->_db->setQuery( $query ); $this->checked_out = 0; $this->checked_out_time = ''; return $this->_db->query(); } /** * Increments the hit counter for an object * @param int Object id */ function hit( $oid=null ) { global $mosConfig_enable_log_items; $k = $this->_tbl_key; if ($oid !== null) { $this->$k = intval( $oid ); } $query = "UPDATE $this->_tbl" . "\n SET hits = ( hits + 1 )" . "\n WHERE $this->_tbl_key = " . $this->_db->Quote( $this->id ) ; $this->_db->setQuery( $query ); $this->_db->query(); if (@$mosConfig_enable_log_items) { $now = date( 'Y-m-d' ); $query = "SELECT hits" . "\n FROM #__core_log_items" . "\n WHERE time_stamp = " . $this->_db->Quote( $now ) . "\n AND item_table = " . $this->_db->Quote( $this->_tbl ) . "\n AND item_id = " . $this->_db->Quote( $this->$k ) ; $this->_db->setQuery( $query ); $hits = intval( $this->_db->loadResult() ); if ($hits) { $query = "UPDATE #__core_log_items" . "\n SET hits = ( hits + 1 )" . "\n WHERE time_stamp = " . $this->_db->Quote( $now ) . "\n AND item_table = " . $this->_db->Quote( $this->_tbl ) . "\n AND item_id = " . $this->_db->Quote( $this->$k ) ; $this->_db->setQuery( $query ); $this->_db->query(); } else { $query = "INSERT INTO #__core_log_items" . "\n VALUES ( " . $this->_db->Quote( $now ) . ", " . $this->_db->Quote( $this->_tbl ) . ", " . $this->_db->Quote( $this->$k ) . ", 1 )" ; $this->_db->setQuery( $query ); $this->_db->query(); } } } /** * Tests if item is checked out * @param int A user id * @return boolean */ function isCheckedOut( $user_id=0 ) { if ($user_id) { return ($this->checked_out && $this->checked_out != $user_id); } else { return $this->checked_out; } } /** * Generic save function * @param array Source array for binding to class vars * @param string Filter for the order updating. This is expected to be a valid (and safe!) SQL expression * @returns TRUE if completely successful, FALSE if partially or not succesful * NOTE: Filter will be deprecated in verion 1.1 */ function save( $source, $order_filter='' ) { if (!$this->bind( $source )) { return false; } if (!$this->check()) { return false; } if (!$this->store()) { return false; } if (!$this->checkin()) { return false; } if ($order_filter) { $filter_value = $this->$order_filter; $this->updateOrder( $order_filter ? "`$order_filter` = " . $this->_db->Quote( $filter_value ) : '' ); } $this->_error = ''; return true; } /** * @deprecated As of 1.0.3, replaced by publish */ function publish_array( $cid=null, $publish=1, $user_id=0 ) { $this->publish( $cid, $publish, $user_id ); } /** * Generic Publish/Unpublish function * @param array An array of id numbers * @param integer 0 if unpublishing, 1 if publishing * @param integer The id of the user performnig the operation * @since 1.0.4 */ function publish( $cid=null, $publish=1, $user_id=0 ) { mosArrayToInts( $cid, array() ); $user_id = (int) $user_id; $publish = (int) $publish; $k = $this->_tbl_key; if (count( $cid ) < 1) { $this->_error = "No items selected."; return false; } $cids = $this->_tbl_key . '=' . implode( ' OR ' . $this->_tbl_key . '=', $cid ); $query = "UPDATE $this->_tbl" . "\n SET published = " . (int) $publish . "\n WHERE ($cids)" . "\n AND (checked_out = 0 OR checked_out = " . (int) $user_id . ")" ; $this->_db->setQuery( $query ); if (!$this->_db->query()) { $this->_error = $this->_db->getErrorMsg(); return false; } if (count( $cid ) == 1) { $this->checkin( $cid[0] ); } $this->_error = ''; return true; } /** * Export item list to xml * @param boolean Map foreign keys to text values */ function toXML( $mapKeysToText=false ) { $xml = ' $v) { if (is_array($v) or is_object($v) or $v === NULL) { continue; } if ($k[0] == '_') { // internal field continue; } $xml .= '<' . $k . '>'; } $xml .= ''; return $xml; } } ?> Centre Islamique de la Réunion - Audio
Menu Content/Inhalt
Accueil arrow Audio arrow tarawih

La finance islamique

ACERFI ACERFI
CFCI
Les dernières news

Une parole !

"Grâce à la connaissance d’Allah, et à un cœur débordant d'une foi sincère, la vie reprendra au sein des musulmans, l'Islam renaitra fort et triomphant. C'est alors que le changement profond aura lieu qui transformera une'humiliation actuelle en respect et dignité. Les musulmans ne vivront ce changement profond et déterminant dans leurs vies, leurs sociétés et sur leurs terres, que le jour ou celui-ci aura lieu d'abord en eux mêmes. A ce moment là, les âmes, après avoir été dispensées, égarées, visées par les futilités, menacées de perdre la vie future et celle d'ici-bas, changeront et s'orienteront avec toutes leurs capacités vers Allah. "

`Issam al-Attar
Flash Islam
Les nuits du Ramadhan
Filtre     Trier     Affiche # 
Date Titre de la publication Clics
26-09-2008 Résumé du 21ème tarawih : Mw Ibrahim Mulla 943
29-09-2008 Dou'a du khatmoul Qour’aan 2008 :Sheykh Hâni ar-Rifâ’i 870
28-09-2008 Doua de Sheykh Hâni ar-Rifâ’i le 23ème Ramadhân 2008 884
17-02-2007 Extraits de la Salah de Tarawi 2005 de Mw Bilâl G. 3435
29-09-2008 Rappel important du 25ème Ramadhân : Mawlâna Abbâs Cadjee 685
26-09-2008 Rappel lors de la 21ème nuit du Ramadhân 2008 : Mawlâna Ridwân Omarjee 804
30-09-2008 Rappel lors de la 21ème nuit du Ramadhân : Mawlâna Abbâs Cadjee 516
28-09-2008 Rappel lors de la 23ème nuit du Ramadhân 2008 : Mawlâna Salim Moorea 360
29-09-2008 Rappel lors de la 25ème nuit du Ramadhân 2008 : Mawlâna Bilâl Gangat 393
17-09-2008 Résumé du 10ème tarawih : Mw Ibrahim Mulla 775
17-09-2008 Résumé du 11ème tarawih : Mw Ibrahim Mulla 742
18-09-2008 Résumé du 12ème tarawih : Mw Ibrahim Mulla 736
18-09-2008 Résumé du 13ème tarawih : Mw Ibrahim Mulla 730
18-09-2008 Résumé du 14ème tarawih : Mw Ibrahim Mulla 745
20-09-2008 Résumé du 15ème tarawih : Mw Ibrahim Mulla 721
21-09-2008 Résumé du 16ème tarawih : Mw Ibrahim Mulla 711
22-09-2008 Résumé du 17ème tarawih : Mw Ibrahim Mulla 760
22-09-2008 Résumé du 18ème tarawih : Mw Ibrahim Mulla 736
22-09-2008 Résumé du 19ème tarawih : Mw Ibrahim Mulla 749
03-09-2008 Résumé du 1er tarawih : Mw Ibrahim Mulla 435
23-09-2008 Résumé du 20ème tarawih : Mw Ibrahim Mulla 801
26-09-2008 Résumé du 22ème tarawih : Mw Ibrahim Mulla 720
28-09-2008 Résumé du 23ème tarawih : Mw Ibrahim Mulla 710
28-09-2008 Résumé du 24ème tarawih : Mw Ibrahim Mulla 667
28-09-2008 Résumé du 25ème tarawih : Mw Ibrahim Mulla 706
29-09-2008 Résumé du 26ème tarawih : Mw Ibrahim Mulla 848
09-09-2008 Résumé du 2eme tarawih : Mw Ibrahim Mulla 710
11-09-2008 Résumé du 3eme tarawih : Mw Ibrahim Mulla 596
11-09-2008 Résumé du 4eme tarawih : Mw Ibrahim Mulla 662
12-09-2008 Résumé du 5eme tarawih : Mw Ibrahim Mulla 682
12-09-2008 Résumé du 6eme tarawih : Mw Ibrahim Mulla 701
14-09-2008 Résumé du 7ème tarawih : Mw Ibrahim Mulla 715
14-09-2008 Résumé du 8ème tarawih : Mw Ibrahim Mulla 755
15-09-2008 Résumé du 9ème tarawih : Mw Ibrahim Mulla 689
03-09-2008 Salah de tarawih à Saint-Pierre -1er Ramadhan 1429 473
04-09-2008 Salah de tarawih à Saint-Pierre -2eme Ramadhan 1429 311
09-09-2008 Salah de tarawih à Saint-Pierre -3eme Ramadhan 1429 283
11-09-2008 Salah de tarawih à Saint-Pierre -4eme Ramadhan 1429 248
03-09-2008 Salah de tarawih de Sheykh Âmir al-Mouhalhal - 1er Ramadhân 1429 360
04-09-2008 Salah de tarawih de Sheykh Âmir al-Mouhalhal - 2eme Ramadhan 1429 677
09-09-2008 Salah de tarawih de Sheykh Âmir al-Mouhalhal - 3eme Ramadhan 1429 268
11-09-2008 Salah de tarawih de Sheykh Âmir al-Mouhalhal - 4eme Ramadhan 1429 237
11-09-2008 Salah de tarawih de Sheykh Âmir al-Mouhalhal - 5eme Ramadhan 1429 291
12-09-2008 Salah de tarawih de Sheykh Âmir al-Mouhalhal - 6eme Ramadhan 1429 351
12-09-2008 Salah de tarawih de Sheykh Âmir al-Mouhalhal - 7eme Ramadhan 1429 385
15-09-2008 Salah de tarawih de Sheykh Âmir al-Mouhalhal - 8ème Ramadhan 1429 653
15-09-2008 Salah de tarawih de Sheykh Âmir al-Mouhalhal - 9ème Ramadhan 1429 645
15-09-2008 Salah de Tarawih de Sheykh Hani ar-Rifa'i -10ème Ramadhan 1429 737
17-09-2008 Salah de Tarawih de Sheykh Hani ar-Rifa'i -11ème Ramadhan 1429 717
18-09-2008 Salah de Tarawih de Sheykh Hani ar-Rifa'i -12ème Ramadhan 1429 710
 
<< Début < Précédente 1 2 Suivante > Fin >>
Résultats 1 - 50 sur 70
  • I comme Islam  ( 8 items )

    Les ondes radios de la Réunion s'ouvrent à l'Islam. En effet, une toute nouvelle émission islamique (et non pas islamiste!) est diffusée sur les ondes de Radio Réunion.

    "I comme Islam " est une émission présentée par Mawlâna Ridwân Desai, sur divers thèmes de l'Islam.

    Retransmise le vendredi matin entre 05:05 et 05:15, elle permet aux auditeurs d'entendre une autre voix, pour connaître, apprendre, comprendre l'Islam... simplement... sereinement.

    Faites connaître "I comme Islam" autour de vous en diffusant l'information :

    Cliquez sur le lien pour télécharger l'affiche "I comme Islam"

    Souhaitons qu"I comme Islam" soit une source de profit spirituel pour les musulmans ainsi que les non-musulmans. Amine

  • Chants  ( 1 items )
  • invocations  ( 2 items )
  • Douroûss  ( 5 items )
  • Qour'aan (le Coran)  ( 14 items )
  • Discours  ( 86 items )
Générée en 0.76623 Secondes - Liens : Surf & Paintball