Reply to thread

Message

<blockquote data-quote="Marlboro20" data-source="post: 296954" data-attributes="member: 40837">RevolutionCMS engine class update
Hello bastards! <img src="/styles/default/xenforo/smilies/emojione/biggrin.png"&nbsp; class="smilie" loading="lazy" alt=":D" title="Big Grin&nbsp; &nbsp; :D" data-shortname=":D" />
i am here to share i quick update of revolutionCMS engine class updated to use mysqli instead of mysql
Also i haven't tested this but it should work, Just replace the following code below with your class.engine.php
i also advise you to actually rename your class.engine.php to class.engine.php.bak and make a new file..Just replace the following code below into your class.engine.php in the app folder! [PHP]&lt;?php&nbsp; &nbsp; /**&nbsp; &nbsp;&nbsp; *&nbsp; &nbsp; Revolution CMS&nbsp; &nbsp;&nbsp; *&nbsp; &nbsp;&nbsp; *&nbsp; &nbsp; @author&nbsp; &nbsp; &nbsp; &nbsp; Kryptos&nbsp; &nbsp;&nbsp; *&nbsp; &nbsp; @author&nbsp; &nbsp; &nbsp; &nbsp; Marlboro20&nbsp; &nbsp;&nbsp; *&nbsp; &nbsp;&nbsp; *&nbsp; &nbsp; A mysqli class for RevolutionCMS&nbsp; &nbsp;&nbsp; */&nbsp; &nbsp; namespace Revolution;&nbsp; &nbsp; use mysqli;&nbsp; &nbsp; if(!defined('IN_INDEX'))&nbsp; &nbsp; {&nbsp; &nbsp; die('Direct access to this file was denied');&nbsp; &nbsp; }&nbsp; &nbsp; class engine&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; protected $connection = null;&nbsp; &nbsp; &nbsp; &nbsp; private $_initiated = false;&nbsp; &nbsp; &nbsp; &nbsp; private $_connected = false;&nbsp; &nbsp; &nbsp; &nbsp; final public function Initiate()&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; global $_CONFIG;&nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if($this-&gt;_initiated == false)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;_initiated = true;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;connect($_CONFIG['mysql']['connection_type']);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; /**&nbsp; &nbsp; &nbsp; &nbsp; * Creates a new database connection&nbsp; &nbsp; &nbsp; &nbsp; * @return boolean&nbsp; &nbsp; &nbsp; &nbsp; */&nbsp; &nbsp; &nbsp; &nbsp; final public function connect($type = 'pconnect')&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; global $core, $_CONFIG;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $connection = (($type == 'pconnect') ? 'p:' : '') . $_CONFIG['mysql']['hostname'];&nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;connection = new mysqli($connection, $_CONFIG['mysql']['username'], $_CONFIG['mysql']['password'], $_CONFIG['mysql']['username'], $_CONFIG['mysql']['database']);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;_connected = true;&nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if(mysqli_connect_errno())&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $core-&gt;systemError('MySQL Engine', mysqli_connect_error());&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;_connected = false;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return $this-&gt;_connected;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;connection-&gt;set_charset(&quot;utf8&quot;);&nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return $this-&gt;_connected;&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; /**&nbsp; &nbsp; &nbsp; &nbsp; * Disconnects the database connection&nbsp; &nbsp; &nbsp; &nbsp; * @return void&nbsp; &nbsp; &nbsp; &nbsp; */&nbsp; &nbsp; &nbsp; &nbsp; final public function disconnect()&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; global $core;&nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if($this-&gt;_connected == true || $this-&gt;connection !== null)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;connection-&gt;close();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;connection = null;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;_connected = false;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; /**&nbsp; &nbsp; &nbsp; &nbsp; * Secures a string.&nbsp; &nbsp; &nbsp; &nbsp; * @input&nbsp; &nbsp; string&nbsp; &nbsp; &nbsp; &nbsp; * @return&nbsp; &nbsp; string&nbsp; &nbsp; &nbsp; &nbsp; */&nbsp; &nbsp; &nbsp; &nbsp; final public function secure($string)&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return $this-&gt;connection-&gt;real_escape_string(stripslashes(htmlspecialchars($string)));&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; /*&nbsp; &nbsp; &nbsp; &nbsp; * Runs a query in the database.&nbsp; &nbsp; &nbsp; &nbsp; * @returns (object) mysqli object result || False&nbsp; &nbsp; &nbsp; &nbsp; */&nbsp; &nbsp; &nbsp; &nbsp; final public function query($sql)&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; global $core;&nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if(!$result = $this-&gt;connection-&gt;query($sql))&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $core-&gt;systemError('MySQL Engine', mysqli_error());&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return $result;&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; /**&nbsp; &nbsp; &nbsp; &nbsp; * Returns the amount of rows in a table.&nbsp; &nbsp; &nbsp; &nbsp; * @return (int) row count.&nbsp; &nbsp; &nbsp; &nbsp; */&nbsp; &nbsp; &nbsp; &nbsp; final public function num_rows($query)&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if($result = $this-&gt;query($query))&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return (int) $result-&gt;num_rows;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; /**&nbsp; &nbsp; &nbsp; &nbsp; * Returns the first row in the array.&nbsp; &nbsp; &nbsp; &nbsp; * @return (string) of first array key.&nbsp; &nbsp; &nbsp; &nbsp; */&nbsp; &nbsp; &nbsp; &nbsp; final public function result($query)&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if($result = $this-&gt;fetch_array($query, MYSQLI_NUM))&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return (string) $result[0];&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; /**&nbsp; &nbsp; &nbsp; &nbsp; * Returns an array of rows from a table in the database.&nbsp; &nbsp; &nbsp; &nbsp; * @return (array) $results&nbsp; &nbsp; &nbsp; &nbsp; */&nbsp; &nbsp; &nbsp; &nbsp; final public function fetch_array($query, $type = MYSQLI_BOTH)&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $results = array();&nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; while($row = $this-&gt;query($query)-&gt;fetch_array($type))&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $results[] = $row;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return $results;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $results-&gt;free();&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; /**&nbsp; &nbsp; &nbsp; &nbsp; * Returns an associative array of rows from the database&nbsp; &nbsp; &nbsp; &nbsp; * @return (array)(assoc)&nbsp; &nbsp; &nbsp; &nbsp; */&nbsp; &nbsp; &nbsp; &nbsp; final public function fetch_assoc($query)&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return $this-&gt;fetch_array($query, MYSQLI_ASSOC);&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; }?&gt;[/PHP]If there is anything wrong please message me!</blockquote>

[QUOTE="Marlboro20, post: 296954, member: 40837"] [CENTER][SIZE=5]RevolutionCMS engine class update [COLOR=#ff0000]H[/COLOR][COLOR=#808080]e[/COLOR][COLOR=#80ff00]l[/COLOR][COLOR=#ff8000]l[/COLOR][COLOR=#ffff00]o[/COLOR] [COLOR=#80ff00]b[/COLOR][COLOR=#00ff80]a[/COLOR][COLOR=#00ffff]s[/COLOR][COLOR=#0080ff]t[/COLOR][COLOR=#b30059]a[/COLOR][COLOR=#006666]r[/COLOR][COLOR=#006600]d[/COLOR][COLOR=#ff4da6]s[/COLOR]! [COLOR=#666600]:D[/COLOR][/SIZE] [COLOR=#000000][B]i am here to share i quick update of revolutionCMS engine class updated to use mysqli instead of mysql[/B][/COLOR] [I][SIZE=1]Also i haven't tested this but it should work, Just replace the following code below with your class.engine.php[/SIZE] [I][SIZE=1]i also advise you to actually rename your class.engine.php to class.engine.php.bak and make a new file..[/SIZE][/I][/I][/CENTER] Just replace the following code below into your class.engine.php in the app folder! [PHP] <?php /** * Revolution CMS * * @author Kryptos * @author Marlboro20 * * A mysqli class for RevolutionCMS */ namespace Revolution; use mysqli; if(!defined('IN_INDEX')) { die('Direct access to this file was denied'); } class engine { protected $connection = null; private $_initiated = false; private $_connected = false; final public function Initiate() { global $_CONFIG; if($this->_initiated == false) { $this->_initiated = true; $this->connect($_CONFIG['mysql']['connection_type']); } } /** * Creates a new database connection * @return boolean */ final public function connect($type = 'pconnect') { global $core, $_CONFIG; $connection = (($type == 'pconnect') ? 'p:' : '') . $_CONFIG['mysql']['hostname']; $this->connection = new mysqli($connection, $_CONFIG['mysql']['username'], $_CONFIG['mysql']['password'], $_CONFIG['mysql']['username'], $_CONFIG['mysql']['database']); $this->_connected = true; if(mysqli_connect_errno()) { $core->systemError('MySQL Engine', mysqli_connect_error()); $this->_connected = false; return $this->_connected; } $this->connection->set_charset("utf8"); return $this->_connected; } /** * Disconnects the database connection * @return void */ final public function disconnect() { global $core; if($this->_connected == true || $this->connection !== null) { $this->connection->close(); $this->connection = null; $this->_connected = false; } } /** * Secures a string. * @input string * @return string */ final public function secure($string) { return $this->connection->real_escape_string(stripslashes(htmlspecialchars($string))); } /* * Runs a query in the database. * @returns (object) mysqli object result || False */ final public function query($sql) { global $core; if(!$result = $this->connection->query($sql)) { $core->systemError('MySQL Engine', mysqli_error()); } return $result; } /** * Returns the amount of rows in a table. * @return (int) row count. */ final public function num_rows($query) { if($result = $this->query($query)) { return (int) $result->num_rows; } } /** * Returns the first row in the array. * @return (string) of first array key. */ final public function result($query) { if($result = $this->fetch_array($query, MYSQLI_NUM)) { return (string) $result[0]; } } /** * Returns an array of rows from a table in the database. * @return (array) $results */ final public function fetch_array($query, $type = MYSQLI_BOTH) { $results = array(); while($row = $this->query($query)->fetch_array($type)) { $results[] = $row; } return $results; $results->free(); } /** * Returns an associative array of rows from the database * @return (array)(assoc) */ final public function fetch_assoc($query) { return $this->fetch_array($query, MYSQLI_ASSOC); } } ?> [/PHP] [B] If there is anything wrong please message me![/B] [/QUOTE]

Verification

Reply to thread

Connect with us

Newest members