Reply to thread

Message

<blockquote data-quote="Zvo" data-source="post: 277234" data-attributes="member: 40984">&lt;?php/*=======================================================================| UberCMS - Advanced Website and Content Management System for uberEmu| #######################################################################| Copyright (c) 2010, Roy 'Meth0d'| <a href="http://www.meth0d.org" target="_blank">http://www.meth0d.org</a>| #######################################################################| 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 3 of the License, or| (at your option) any later version.| #######################################################################| 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.\======================================================================*/class MySQL{&nbsp; &nbsp; private $connected = false;&nbsp; &nbsp; private $hostname = &quot;localhost&quot;;&nbsp; &nbsp; private $username = &quot;uber_uberdb&quot;;&nbsp; &nbsp; private $password = &quot;F5eWRuca&quot;;&nbsp; &nbsp; private $database = &quot;uber_db&quot;;&nbsp; &nbsp; private $link;&nbsp;&nbsp; &nbsp; &nbsp; public function MySQL($host, $user, $pass, $db)&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;connected = false;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;hostname = $host;&nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;username = $user;&nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;password = $pass;&nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;database = $db;&nbsp; &nbsp; }&nbsp;&nbsp; &nbsp; &nbsp; public function IsConnected()&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; if ($this-&gt;connected)&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return true;&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return false;&nbsp; &nbsp; }&nbsp; &nbsp; public function Connect()&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;link = @mysql_connect($this-&gt;hostname, $this-&gt;username, $this-&gt;password) or $this-&gt;error(mysql_error());&nbsp; &nbsp; &nbsp; &nbsp; @mysql_select_db($this-&gt;database, $this-&gt;link) or $this-&gt;error(mysql_error());&nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;connected = true;&nbsp; &nbsp; }&nbsp;&nbsp; &nbsp; &nbsp; public function Disconnect()&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; if($this-&gt;connected)&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; @mysql_close($this-&gt;link) or $this-&gt;error(&quot;could not close conn&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;connected = false;&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; }&nbsp;&nbsp; &nbsp; &nbsp; public function DoQuery($query)&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; $resultset = @mysql_query($query, $this-&gt;link) or $this-&gt;error(mysql_error());&nbsp; &nbsp; &nbsp; &nbsp; return $resultset;&nbsp; &nbsp; }&nbsp;&nbsp; &nbsp; &nbsp; public function Evaluate($resultset)&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; return @mysql_result($resultset, 0);&nbsp; &nbsp; }&nbsp;&nbsp; &nbsp; &nbsp; public function Error($errorString)&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; global $core;&nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $core-&gt;systemError('Database Error', $errorString);&nbsp; &nbsp; }&nbsp;&nbsp; &nbsp; &nbsp; public function __destruct()&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;disconnect();&nbsp; &nbsp; }}?&gt;</blockquote>

[QUOTE="Zvo, post: 277234, member: 40984"] <?php /*======================================================================= | UberCMS - Advanced Website and Content Management System for uberEmu | ####################################################################### | Copyright (c) 2010, Roy 'Meth0d' | [url]http://www.meth0d.org[/url] | ####################################################################### | 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 3 of the License, or | (at your option) any later version. | ####################################################################### | 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. \======================================================================*/ class MySQL { private $connected = false; private $hostname = "localhost"; private $username = "uber_uberdb"; private $password = "F5eWRuca"; private $database = "uber_db"; private $link; public function MySQL($host, $user, $pass, $db) { $this->connected = false; $this->hostname = $host; $this->username = $user; $this->password = $pass; $this->database = $db; } public function IsConnected() { if ($this->connected) { return true; } return false; } public function Connect() { $this->link = @mysql_connect($this->hostname, $this->username, $this->password) or $this->error(mysql_error()); @mysql_select_db($this->database, $this->link) or $this->error(mysql_error()); $this->connected = true; } public function Disconnect() { if($this->connected) { @mysql_close($this->link) or $this->error("could not close conn"); $this->connected = false; } } public function DoQuery($query) { $resultset = @mysql_query($query, $this->link) or $this->error(mysql_error()); return $resultset; } public function Evaluate($resultset) { return @mysql_result($resultset, 0); } public function Error($errorString) { global $core; $core->systemError('Database Error', $errorString); } public function __destruct() { $this->disconnect(); } } ?> [/QUOTE]

Verification

Reply to thread

Connect with us

Newest members