+<<<<<<< HEAD
+<?php\r
+\r
+/*\r
+ * Nucleus: PHP/MySQL Weblog CMS (http://nucleuscms.org/)\r
+ * Copyright (C) 2012 The Nucleus Group\r
+ *\r
+ * This program is free software; you can redistribute it and/or\r
+ * modify it under the terms of the GNU General Public License\r
+ * as published by the Free Software Foundation; either version 2\r
+ * of the License, or (at your option) any later version.\r
+ * (see nucleus/documentation/index.html#license for more info)\r
+ */\r
+/**\r
+ * @license http://nucleuscms.org/license.txt GNU General Public License\r
+ * @copyright Copyright (C) 2012 The Nucleus Group\r
+ * @version $Id$\r
+ */\r
+\r
+/*\r
+ * sql_* wrappers for DB class access\r
+ */\r
+if ( !class_exists('DB') )\r
+{\r
+ include_once realpath(dirname(__FILE__)) . '/DB.php';\r
+}\r
+\r
+/**\r
+ * Connects to database server with arguments\r
+ * @deprecated\r
+ */\r
+function sql_connect_args($host = 'localhost', $user = '', $password = '', $database = '', $new_link = FALSE)\r
+{\r
+ global $MYSQL_HANDLER;\r
+ return DB::setConnectionInfo($MYSQL_HANDLER[1], $host, $user, $password, $database);\r
+}\r
+\r
+/**\r
+ * Connects to database server\r
+ * @deprecated\r
+ */\r
+function sql_connect()\r
+{\r
+ global $MYSQL_HANDLER, $MYSQL_HOST, $MYSQL_USER, $MYSQL_PASSWORD, $MYSQL_DATABASE;\r
+\r
+ return DB::setConnectionInfo($MYSQL_HANDLER[1], $MYSQL_HOST, $MYSQL_USER, $MYSQL_PASSWORD, $MYSQL_DATABASE);\r
+}\r
+\r
+/**\r
+ * disconnects from SQL server\r
+ * @deprecated\r
+ */\r
+function sql_disconnect($conn = false)\r
+{\r
+ DB::disConnect();\r
+}\r
+\r
+/**\r
+ * disconnects from SQL server\r
+ * @deprecated\r
+ * @param unknown_type $conn\r
+ */\r
+function sql_close($conn = false)\r
+{\r
+ DB::disConnect();\r
+}\r
+\r
+/**\r
+ * executes an SQL query\r
+ * @deprecated\r
+ */\r
+function sql_query($query, $conn = false)\r
+{\r
+ global $mysql_affected_row;\r
+ $mysql_affected_row = -1;\r
+ if ( preg_match('/^\W*(INSERT|UPDATE|DELETE|DROP)/i', $query) )\r
+ {\r
+ $mysql_affected_row = DB::execute($query);\r
+ return $mysql_affected_row !== FALSE ? TRUE : FALSE;\r
+ }\r
+ return DB::getResult($query);\r
+}\r
+\r
+/**\r
+ * executes an SQL error\r
+ * @deprecated\r
+ */\r
+function sql_error($conn = false)\r
+{\r
+ $err = DB::getError();\r
+ return $err[2];\r
+}\r
+\r
+/**\r
+ * executes an SQL db select\r
+ * @deprecated\r
+ */\r
+function sql_select_db($db, $conn = false)\r
+{\r
+ sql_disconnect();\r
+ return sql_connect();\r
+}\r
+\r
+/**\r
+ * executes an SQL real escape\r
+ * @deprecated\r
+ */\r
+function sql_real_escape_string($val, $conn = false)\r
+{\r
+ if ( is_numeric($val) )\r
+ {\r
+ return $val;\r
+ }\r
+ $escapeval = DB::quoteValue($val);\r
+ if ( preg_match("/^'(.*)'$/", $escapeval, $matches) )\r
+ {\r
+ $escapeval = $matches[1];\r
+ }\r
+ return $escapeval;\r
+}\r
+\r
+/**\r
+ * executes an PDO::quote() like escape, ie adds quotes arround the string and escapes chars as needed\r
+ * @deprecated\r
+ */\r
+function sql_quote_string($val, $conn = false)\r
+{\r
+ if ( is_numeric($val) )\r
+ {\r
+ return $val;\r
+ }\r
+ return DB::quoteValue($val);\r
+}\r
+\r
+/**\r
+ * executes an SQL insert id\r
+ * @deprecated\r
+ */\r
+function sql_insert_id($conn = false)\r
+{\r
+ return DB::getInsertId();\r
+}\r
+\r
+/**\r
+ * executes an SQL result request\r
+ * @deprecated\r
+ */\r
+function sql_result($res, $row, $col)\r
+{\r
+ if ( !method_exists($res, 'fetch') ) return FALSE;\r
+ for ( $i = 0; $i < $row; $i++ )\r
+ $res->fetch();\r
+ return $res->fetchColumn($col);\r
+}\r
+\r
+/**\r
+ * frees sql result resources\r
+ * @deprecated\r
+ */\r
+function sql_free_result($res)\r
+{\r
+ if ( !method_exists($res, 'closeCursor') ) return FALSE;\r
+ return $res->closeCursor();\r
+}\r
+\r
+/**\r
+ * returns number of rows in SQL result\r
+ * @deprecated\r
+ */\r
+function sql_num_rows($res)\r
+{\r
+ if ( !method_exists($res, 'rowCount') ) return FALSE;\r
+ return $res->rowCount();\r
+}\r
+\r
+/**\r
+ * returns number of rows affected by SQL query\r
+ * @deprecated\r
+ */\r
+function sql_affected_rows($conn = false)\r
+{\r
+ global $mysql_affected_row;\r
+ return $mysql_affected_row;\r
+}\r
+\r
+/**\r
+ * Get number of fields in result\r
+ * @deprecated\r
+ */\r
+function sql_num_fields($res)\r
+{\r
+ if ( !method_exists($res, 'columnCount') ) return FALSE;\r
+ return $res->columnCount();\r
+}\r
+\r
+/**\r
+ * fetches next row of SQL result as an associative array\r
+ * @deprecated\r
+ */\r
+function sql_fetch_assoc($res)\r
+{\r
+ if ( !method_exists($res, 'fetch') ) return FALSE;\r
+ return $res->fetch(PDO::FETCH_ASSOC);\r
+}\r
+\r
+/**\r
+ * Fetch a result row as an associative array, a numeric array, or both\r
+ * @deprecated\r
+ */\r
+function sql_fetch_array($res)\r
+{\r
+ if ( !method_exists($res, 'fetch') ) return FALSE;\r
+ return $res->fetch(PDO::FETCH_BOTH);\r
+}\r
+\r
+/**\r
+ * fetches next row of SQL result as an object\r
+ * @deprecated\r
+ */\r
+function sql_fetch_object($res)\r
+{\r
+ if ( !method_exists($res, 'fetch') ) return FALSE;\r
+ return $res->fetch(PDO::FETCH_OBJ);\r
+}\r
+\r
+/**\r
+ * Get a result row as an enumerated array\r
+ * @deprecated\r
+ */\r
+function sql_fetch_row($res)\r
+{\r
+ if ( !method_exists($res, 'fetch') ) return FALSE;\r
+ return $res->fetch(PDO::FETCH_NUM);\r
+}\r
+\r
+/**\r
+ * Get column information from a result and return as an object\r
+ * @deprecated\r
+ */\r
+function sql_fetch_field($res, $offset = 0)\r
+{\r
+ return FALSE;\r
+}\r
+\r
+/**\r
+ * Get current system status (returns string)\r
+ * @deprecated\r
+ */\r
+function sql_stat($conn = false)\r
+{\r
+ return FALSE;\r
+}\r
+\r
+/**\r
+ * Returns the name of the character set\r
+ * @deprecated\r
+ */\r
+function sql_client_encoding($conn = false)\r
+{\r
+ return FALSE;\r
+}\r
+\r
+/**\r
+ * Get SQL client version\r
+ * @deprecated\r
+ */\r
+function sql_get_client_info()\r
+{\r
+ return DB::getAttribute(PDO::ATTR_CLIENT_VERSION);\r
+}\r
+\r
+/**\r
+ * Get SQL server version\r
+ * @deprecated\r
+ */\r
+function sql_get_server_info($conn = false)\r
+{\r
+ return DB::getAttribute(PDO::ATTR_SERVER_VERSION);\r
+}\r
+\r
+/**\r
+ * Returns a string describing the type of SQL connection in use for the connection or FALSE on failure\r
+ * @deprecated\r
+ */\r
+function sql_get_host_info($conn = false)\r
+{\r
+ return FALSE;\r
+}\r
+\r
+/**\r
+ * Returns the SQL protocol on success, or FALSE on failure.\r
+ * @deprecated\r
+ */\r
+function sql_get_proto_info($conn = false)\r
+{\r
+ return FALSE;\r
+}\r
+\r
+/**\r
+ * Get the name of the specified field in a result\r
+ * @deprecated\r
+ */\r
+function sql_field_name($res, $offset = 0)\r
+{\r
+ if ( !method_exists($res, 'getColumnMeta') ) return FALSE;\r
+ $column = $res->getColumnMeta($offset);\r
+ return $column['name'];\r
+}\r
+\r
+/**\r
+ * Set character encodings in each fields related to MySQL connection.\r
+ * @deprecated\r
+ */\r
+function sql_set_charset($charset)\r
+{\r
+ return TRUE;\r
+}\r
+=======
<?php
/*
{
return TRUE;
}
+>>>>>>> skinnable-master
OSDN Git Service
