لملف فى البينات
mssql.class.php
<?php
class mssql {
var $config = "config.inc.php";
var $sqlLink;
var $sqlQuery;
var $rowCount;
var $arr;
function dbOpen($dbName) {
if (!$this->sqlLink) {
include_once("$this->config");
global $mssql_server;
$db = array("Database"=>"$dbName");
$this->mssql_server = $mssql_server;
$this->sqlLink = sqlsrv_connect($mssql_server, $db);
if (!$this->sqlLink) {
echo "Error: Connection to the database couldn't be established. <br />";
}
return;
} else {
exit;
}
}
function dbClose() {
sqlsrv_close($this->sqlLink);
}
function dbQuery($string) {
$this->sqlQuery = sqlsrv_query($this->sqlLink, $string);
if(!$this->sqlQuery){
echo "Error: Query execution failed. <br />";
die( print_r( sqlsrv_errors(), true));
}
return $this->sqlQuery;
}
function numRows($string) {
$params = array();
$opt = array("Scrollable" => SQLSRV_CURSOR_KEYSET);
$stmt = sqlsrv_query($this->sqlLink, $string, $params, $opt);
$this->rowCount = sqlsrv_num_rows($stmt);
return $this->rowCount;
}
function fetchArray($string) {
$query = $this->dbQuery($string);
$this->arr = sqlsrv_fetch_array($query);
return $this->arr;
}
function getFortData($fortID) {
$row = $this->fetchArray("SELECT * FROM _SiegeFortress WHERE FortressID = $fortID");
echo '<td style="border:1px solid #3f3f3f;">';
$fortName = $row["FortressID"];
switch ($fortName) {
case 1:
echo "<img style='vertical-align:middle;' src='img/fort-jangan.png' /></td><td style='border:1px solid #3f3f3f;width:160px;'>Jangan fortress</td>";
break;
case 3:
echo "<img style='vertical-align:middle;' src='img/fort-hotan.png' /></td><td style='border:1px solid #3f3f3f;width:160px;'>Hotan fortress</td>";
break;
case 6:
echo "<img style='vertical-align:middle;' src='img/fort-bandit.png' /></td><td style='border:1px solid #3f3f3f;width:160px;'>Bandit fortress</td>";
break;
}
echo '</td>';
echo '<td style="border:1px solid #3f3f3f;width: 250px">';
$guildID = $row["GuildID"];
$guildName = $this->fetchArray("select Name from _Guild where ID = $guildID");
echo $guildName['Name'];
echo '</td>';
echo '<td style="border:1px solid #3f3f3f;width: 220px;">';
echo $row['TaxRatio']."%";
echo '</td>';
}
}
?>