trabis wrote:
All xoops_version.php are read so..

// $Id: mysqldatabase.php 694 2006-09-04 11:33:22Z skalpa $
// ------------------------------------------------------------------------ //
// XOOPS - PHP Content Management System //
// Copyright (c) 2000 XOOPS.org //
// <https://xoops.org/> //
// ------------------------------------------------------------------------ //
// This program is free software; you can redistribute it and/or modify //
// it under the terms of the GNU General Public License as published by //
// the Free Software Foundation; either version 2 of the License, or //
// (at your option) any later version. //
// //
// You may not change or alter any portion of this comment or credits //
// of supporting developers from this source code or any supporting //
// source code which is considered copyrighted (c) material of the //
// original comment or credit authors. //
// //
// This program is distributed in the hope that it will be useful, //
// but WITHOUT ANY WARRANTY; without even the implied warranty of //
// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the //
// GNU General Public License for more details. //
// //
// You should have received a copy of the GNU General Public License //
// along with this program; if not, write to the Free Software //
// Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA //
// ------------------------------------------------------------------------ //
// Author: Kazumi Ono (AKA onokazu) //
// URL: http://www.myweb.ne.jp/, https://xoops.org/, http://www.xoopscube.jp/ //
// Project: The XOOPS Project //
// ------------------------------------------------------------------------- //
if (!defined("XOOPS_ROOT_PATH")) {
die("XOOPS root path not defined");
}
/**
* @package kernel
* @subpackage database
*
* @author Kazumi Ono
* @copyright copyright (c) 2000-2003 XOOPS.org
*/

/**
* base class
*/
include_once XOOPS_ROOT_PATH."/class/database/database.php";

/**
* connection to a MySQL database
*
* @abstract
*
* @author Kazumi Ono
* @copyright copyright (c) 2000-2003 XOOPS.org
*
* @package kernel
* @subpackage database
*/
class XoopsMySQLDatabase extends XoopsDatabase
{
/**
* Database connection
* @var resource
*/
var $conn;

/**
* connect to the database
*
* @param bool $selectdb select the database now?
* @return bool successful?
*/
function connect($selectdb = true)
{
if ( !extension_loaded( 'mysql' ) ) {
trigger_error( 'notrace:mysql extension not loaded', E_USER_ERROR );
return false;
}
if (XOOPS_DB_PCONNECT == 1) {
$this->conn = @mysql_pconnect(XOOPS_DB_HOST, XOOPS_DB_USER, XOOPS_DB_PASS);
} else {
$this->conn = @mysql_connect(XOOPS_DB_HOST, XOOPS_DB_USER, XOOPS_DB_PASS);
}

if (!$this->conn) {
$this->logger->addQuery('', $this->error(), $this->errno());
return false;
}
if($selectdb != false){
if (!mysql_select_db(XOOPS_DB_NAME)) {
$this->logger->addQuery('', $this->error(), $this->errno());
return false;
}
}
return true;
}

/**
* generate an ID for a new row
*
* This is for compatibility only. Will always return 0, because MySQL supports
* autoincrement for primary keys.
*
* @param string $sequence name of the sequence from which to get the next ID
* @return int always 0, because MySQL has support for autoincrement
*/
function genId($sequence)
{
return 0; // will use auto_increment
}

/**
* Get a result row as an enumerated array
*
* @param resource $result
* @return array
*/
function fetchRow($result)
{
return @mysql_fetch_row($result);
}

/**
* Fetch a result row as an associative array
*
* @return array
*/
function fetchArray($result)
{
return @mysql_fetch_assoc( $result );
}

/**
* Fetch a result row as an associative array
*
* @return array
*/
function fetchBoth($result)
{
return @mysql_fetch_array( $result, MYSQL_BOTH );
}

/**
* Get the ID generated from the previous INSERT operation
*
* @return int
*/
function getInsertId()
{
return mysql_insert_id($this->conn);
}

/**
* Get number of rows in result
*
* @param resource query result
* @return int
*/
function getRowsNum($result)
{
return @mysql_num_rows($result);
}

/**
* Get number of affected rows
*
* @return int
*/
function getAffectedRows()
{
return mysql_affected_rows($this->conn);
}

/**
* Close MySQL connection
*
*/
function close()
{
mysql_close($this->conn);
}

/**
* will free all memory associated with the result identifier result.
*
* @param resource query result
* @return bool TRUE on success or FALSE on failure.
*/
function freeRecordSet($result)
{
return mysql_free_result($result);
}

/**
* Returns the text of the error message from previous MySQL operation
*
* @return bool Returns the error text from the last MySQL function, or '' (the empty string) if no error occurred.
*/
function error()
{
return @mysql_error();
}

/**
* Returns the numerical value of the error message from previous MySQL operation
*
* @return int Returns the error number from the last MySQL function, or 0 (zero) if no error occurred.
*/
function errno()
{
return @mysql_errno();
}

/**
* Returns escaped string text with single quotes around it to be safely stored in database
*
* @param string $str unescaped string text
* @return string escaped string text with single quotes around
*/
function quoteString($str)
{
$str = "'".str_replace('\\"', '"', addslashes($str))."'";
return $str;
}

/**
* perform a query on the database
*
* @param string $sql a valid MySQL query
* @param int $limit number of records to return
* @param int $start offset of first record to return
* @return resource query result or FALSE if successful
* or TRUE if successful and no result
*/
function queryF($sql, $limit=0, $start=0)
{
if ( !empty($limit) ) {
if (empty($start)) {
$start = 0;
}
$sql = $sql. ' LIMIT '.(int)$start.', '.(int)$limit;
}
$result = mysql_query($sql, $this->conn);
if ( $result ) {
$this->logger->addQuery($sql);
return $result;
} else {
$this->logger->addQuery($sql, $this->error(), $this->errno());
return false;
}
}

/**
* perform a query
*
* This method is empty and does nothing! It should therefore only be
* used if nothing is exactly what you want done!
*
* @param string $sql a valid MySQL query
* @param int $limit number of records to return
* @param int $start offset of first record to return
*
* @abstract
*/
function query($sql, $limit=0, $start=0)
{

}

/**
* perform queries from SQL dump file in a batch
*
* @param string $file file path to an SQL dump file
*
* @return bool FALSE if failed reading SQL file or TRUE if the file has been read and queries executed
*/
function queryFromFile($file){
if (false !== ($fp = fopen($file, 'r'))) {
include_once XOOPS_ROOT_PATH.'/class/database/sqlutility.php';
$sql_queries = trim(fread($fp, filesize($file)));
SqlUtility::splitMySqlFile($pieces, $sql_queries);
foreach ($pieces as $query) {
// [0] contains the prefixed query
// [4] contains unprefixed table name
$prefixed_query = SqlUtility::prefixQuery(trim($query), $this->prefix());
if ($prefixed_query != false) {
$this->query($prefixed_query[0]);
}
}
return true;
}
return false;
}

/**
* Get field name
*
* @param resource $result query result
* @param int numerical field index
* @return string
*/
function getFieldName($result, $offset)
{
return mysql_field_name($result, $offset);
}

/**
* Get field type
*
* @param resource $result query result
* @param int $offset numerical field index
* @return string
*/
function getFieldType($result, $offset)
{
return mysql_field_type($result, $offset);
}

/**
* Get number of fields in result
*
* @param resource $result query result
* @return int
*/
function getFieldsNum($result)
{
return mysql_num_fields($result);
}
}

/**
* Safe Connection to a MySQL database.
*
*
* @author Kazumi Ono
* @copyright copyright (c) 2000-2003 XOOPS.org
*
* @package kernel
* @subpackage database
*/
class XoopsMySQLDatabaseSafe extends XoopsMySQLDatabase
{

/**
* perform a query on the database
*
* @param string $sql a valid MySQL query
* @param int $limit number of records to return
* @param int $start offset of first record to return
* @return resource query result or FALSE if successful
* or TRUE if successful and no result
*/
function query($sql, $limit=0, $start=0)
{
return $this->queryF($sql, $limit, $start);
}
}

/**
* Read-Only connection to a MySQL database.
*
* This class allows only SELECT queries to be performed through its
* {@link query()} method for security reasons.
*
*
* @author Kazumi Ono
* @copyright copyright (c) 2000-2003 XOOPS.org
*
* @package kernel
* @subpackage database
*/
class XoopsMySQLDatabaseProxy extends XoopsMySQLDatabase
{

/**
* perform a query on the database
*
* this method allows only SELECT queries for safety.
*
* @param string $sql a valid MySQL query
* @param int $limit number of records to return
* @param int $start offset of first record to return
* @return resource query result or FALSE if unsuccessful
*/
function query($sql, $limit=0, $start=0)
{
$sql = ltrim($sql);
if (strtolower(substr($sql, 0, 6)) == 'select') {
//if (preg_match("/^SELECT.*/i", $sql)) {
return $this->queryF($sql, $limit, $start);
}
$this->logger->addQuery($sql, 'Database update not allowed during processing of a GET request', 0);
return false;
}
}
?>
.

Queries core
SELECT * FROM xoops_config WHERE (conf_modid = '1' AND conf_catid = '1') ORDER BY conf_order ASC
SELECT sess_data, sess_ip FROM xoops_session WHERE sess_id = '0123456789'
( 0.000125)
SELECT * FROM xoops_users u, xoops_user_profile p WHERE u.uid = p.profileid AND uid = '1' LIMIT 0, 1
( 0.000268)
SELECT * FROM xoops_modules WHERE dirname = 'system'
( 0.000189)
SELECT * FROM xoops_config WHERE (conf_modid = '1') ORDER BY conf_order ASC
( 0.000991)
SELECT COUNT(*) FROM xoops_banner
( 8.8E-5)
SELECT * FROM xoops_config WHERE (conf_modid = '1' AND conf_catid = '3') ORDER BY conf_order ASC
( 0.000258)
SELECT * FROM xoops_group_permission WHERE (gperm_modid = '1' AND gperm_name = 'module_admin' AND gperm_groupid IN (1,2))
( 0.000426)
SELECT * FROM xoops_modules WHERE (hasadmin = '1' AND isactive = '1' AND mid IN (1,2,3,4,7,16,9,10,11,12,13,15,17,19,20,21)) ORDER BY name ASC
( 0.000388)
SELECT * FROM xoops_group_permission WHERE (gperm_modid = '1' AND gperm_name = 'system_admin' AND gperm_groupid IN (1,2))
( 0.000479)
SELECT * FROM xoops_configcategory WHERE confcat_modid IN (7,3,20,17,19,12,13,15,10,4,21,2,16,11,1,9)
( 0.000218)
SELECT * FROM xoops_modules WHERE dirname = 'wflinks'
( 0.000179)
SELECT * FROM xoops_modules WHERE dirname = 'news'
( 0.00017)
SELECT * FROM xoops_config WHERE (conf_modid = '4') ORDER BY conf_order ASC
( 0.000622)
Total Number of Queries: 14 | Total SQL Generation Time: 0.004401

Queries module
DELETE FROM xoops_protector_access WHERE expire < UNIX_TIMESTAMP()
( 0.000173)
SELECT COUNT(*) FROM xoops_protector_access WHERE ip='7.65.43.21' AND request_uri='/cms/modules/system/admin.php?fct=preferences'
( 0.000145)
SELECT COUNT(*) FROM xoops_protector_access WHERE ip='7.65.43.21'
( 0.000118)
INSERT INTO xoops_protector_access SET ip='7.65.43.21',request_uri='/cms/modules/system/admin.php?fct=preferences',expire=UNIX_TIMESTAMP()+'60'
( 0.00014)
SELECT * FROM xoops_group_permission WHERE (gperm_modid = '1' AND gperm_name = 'module_admin' AND gperm_groupid IN (1,2))
( 0.000565)
SELECT * FROM xoops_configcategory WHERE confcat_modid IN (1,2,3,4,7,16,9,10,11,12,13,15,17,19,20,21,1)
( 0.000319)
SELECT * FROM xoops_modules WHERE mid IN (1,2,3,4,16,9,10,12,13,15,17,19,21)
( 0.000217)
Total Number of Queries: 7 | Total SQL Generation Time: 0.001677

Queries block
Total Number of Queries: 0 | Total SQL Generation Time: 0

Blocks
Total: 0 blocks

Execution Time
XOOPS took 0.219801902771 seconds to load.

ghia wrote:
The more I discover about the 2.2.x series, the more I find its version number correct with its advanced features as opposed to the poor functionality of the 2.0.x series of XOOPS.

I feel it's total unjust that the series 2.2.x are marked as unstable releases at Sourceforge. And maybe with all the problems of the recent introduction of the 2.3.x series it should be rebaptised to 2.1.x.